participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,471 rows where station_code = "CH0005" sorted by created_at descending
This data as json, copyable, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
| Link | rowid | meteor_unique_trajectory_identifier | station_code | created_at ▲ | updated_at |
|---|---|---|---|---|---|
| 9610508 | 9610508 | 20260404195718_Ud78N | CH0005 | 2026-04-06T12:09:47.477Z | 2026-04-06T12:16:14.582Z |
| 9610504 | 9610504 | 20260404195718_eQzos | CH0005 | 2026-04-06T12:09:47.198Z | 2026-04-06T12:16:14.581Z |
| 9604912 | 9604912 | 20260402015244_rNQAi | CH0005 | 2026-04-03T12:12:10.337Z | 2026-04-06T12:26:31.709Z |
| 9589604 | 9589604 | 20260328035017_lyv4X | CH0005 | 2026-03-29T12:01:28.448Z | 2026-04-06T12:37:28.762Z |
| 9589508 | 9589508 | 20260328033700_2ds37 | CH0005 | 2026-03-29T12:01:22.533Z | 2026-04-06T12:37:26.342Z |
| 9577144 | 9577144 | 20260325040306_MPYmS | CH0005 | 2026-03-26T12:04:14.588Z | 2026-04-03T12:36:36.150Z |
| 9576751 | 9576751 | 20260325030447_noOB4 | CH0005 | 2026-03-26T12:03:12.799Z | 2026-04-03T12:36:19.992Z |
| 9576390 | 9576390 | 20260325015934_cMrNV | CH0005 | 2026-03-26T12:02:05.580Z | 2026-04-03T12:35:57.037Z |
| 9576355 | 9576355 | 20260325015608_xzy3b | CH0005 | 2026-03-26T12:02:00.763Z | 2026-04-03T12:35:54.300Z |
| 9576210 | 9576210 | 20260325013523_GzG9x | CH0005 | 2026-03-26T12:01:34.936Z | 2026-04-03T12:35:48.696Z |
| 9575976 | 9575976 | 20260325005247_i5kit | CH0005 | 2026-03-26T12:00:51.566Z | 2026-04-03T12:35:39.226Z |
| 9575451 | 9575451 | 20260323221357_lG1iN | CH0005 | 2026-03-25T12:21:10.432Z | 2026-03-31T12:28:57.910Z |
| 9575405 | 9575405 | 20260323214021_tA4EF | CH0005 | 2026-03-25T12:21:01.255Z | 2026-03-31T12:28:56.708Z |
| 9575389 | 9575389 | 20260323213854_GyJtX | CH0005 | 2026-03-25T12:20:59.066Z | 2026-03-31T12:28:56.450Z |
| 9571771 | 9571771 | 20260324040218_jXxMZ | CH0005 | 2026-03-25T12:02:37.742Z | 2026-04-02T12:34:47.670Z |
| 9571643 | 9571643 | 20260324032151_cPBsw | CH0005 | 2026-03-25T12:02:11.967Z | 2026-04-02T12:34:36.114Z |
| 9571553 | 9571553 | 20260324025404_0hf7N | CH0005 | 2026-03-25T12:01:54.549Z | 2026-04-02T12:34:31.797Z |
| 9571465 | 9571465 | 20260324022621_iSN6D | CH0005 | 2026-03-25T12:01:35.835Z | 2026-04-02T12:34:27.964Z |
| 9571437 | 9571437 | 20260324020627_ZJ2wo | CH0005 | 2026-03-25T12:01:28.380Z | 2026-04-02T12:34:26.470Z |
| 9571411 | 9571411 | 20260324015401_CeVEk | CH0005 | 2026-03-25T12:01:21.781Z | 2026-04-02T12:34:25.473Z |
| 9571154 | 9571154 | 20260324001247_s8iJO | CH0005 | 2026-03-25T12:00:15.284Z | 2026-04-02T12:34:10.437Z |
| 9571152 | 9571152 | 20260324001247_33a5u | CH0005 | 2026-03-25T12:00:14.808Z | 2026-04-02T12:34:10.324Z |
| 9551787 | 9551787 | 20260320213324_GjrGH | CH0005 | 2026-03-22T12:27:02.750Z | 2026-03-28T12:37:02.015Z |
| 9551459 | 9551459 | 20260320195239_LVUhk | CH0005 | 2026-03-22T12:26:41.913Z | 2026-03-28T12:36:54.066Z |
| 9543475 | 9543475 | 20260321040037_BMAFB | CH0005 | 2026-03-22T12:03:55.441Z | 2026-03-29T12:19:08.037Z |
| 9542946 | 9542946 | 20260321015939_i3xu6 | CH0005 | 2026-03-22T12:02:09.753Z | 2026-03-29T12:19:00.600Z |
| 9542530 | 9542530 | 20260321000527_fTR58 | CH0005 | 2026-03-22T12:00:39.123Z | 2026-03-29T12:18:45.240Z |
| 9542061 | 9542061 | 20260319224625_UvPf6 | CH0005 | 2026-03-21T12:29:38.710Z | 2026-03-27T12:42:44.879Z |
| 9541371 | 9541371 | 20260319202425_aQINS | CH0005 | 2026-03-21T12:28:52.131Z | 2026-03-27T12:42:36.962Z |
| 9534467 | 9534467 | 20260320035125_oWoAu | CH0005 | 2026-03-21T12:08:04.387Z | 2026-03-28T12:34:18.602Z |
| 9534341 | 9534341 | 20260320034214_iModM | CH0005 | 2026-03-21T12:07:43.704Z | 2026-03-28T12:34:17.414Z |
| 9534309 | 9534309 | 20260320034056_L515K | CH0005 | 2026-03-21T12:07:40.757Z | 2026-03-28T12:34:17.255Z |
| 9533957 | 9533957 | 20260320031028_26FY1 | CH0005 | 2026-03-21T12:06:44.539Z | 2026-03-28T12:34:02.740Z |
| 9533818 | 9533818 | 20260320030144_JRS8e | CH0005 | 2026-03-21T12:06:23.496Z | 2026-03-28T12:34:00.968Z |
| 9533747 | 9533747 | 20260320025407_6fehY | CH0005 | 2026-03-21T12:06:10.806Z | 2026-03-28T12:34:00.056Z |
| 9533671 | 9533671 | 20260320025113_BjCUK | CH0005 | 2026-03-21T12:06:00.306Z | 2026-03-28T12:33:58.260Z |
| 9533164 | 9533164 | 20260320020520_JWIZU | CH0005 | 2026-03-21T12:04:37.664Z | 2026-03-28T12:33:49.430Z |
| 9533158 | 9533158 | 20260320020501_zz3pA | CH0005 | 2026-03-21T12:04:36.731Z | 2026-03-28T12:33:49.360Z |
| 9533001 | 9533001 | 20260320014528_21T42 | CH0005 | 2026-03-21T12:04:11.522Z | 2026-03-28T12:33:47.384Z |
| 9532658 | 9532658 | 20260320011729_VPXGo | CH0005 | 2026-03-21T12:03:21.627Z | 2026-03-28T12:33:35.038Z |
| 9532208 | 9532208 | 20260320003728_NmExB | CH0005 | 2026-03-21T12:02:04.417Z | 2026-03-28T12:33:25.853Z |
| 9531818 | 9531818 | 20260319235317_S9MNh | CH0005 | 2026-03-21T12:00:57.007Z | 2026-03-28T12:33:21.818Z |
| 9530490 | 9530490 | 20260318210226_JLkDi | CH0005 | 2026-03-20T12:24:26.574Z | 2026-03-26T12:39:12.968Z |
| 9521316 | 9521316 | 20260319040640_0Cjq0 | CH0005 | 2026-03-20T12:07:50.915Z | 2026-03-27T12:40:53.839Z |
| 9521216 | 9521216 | 20260319035808_T4Grq | CH0005 | 2026-03-20T12:07:43.039Z | 2026-03-27T12:40:52.761Z |
| 9521013 | 9521013 | 20260319034858_1LEG3 | CH0005 | 2026-03-20T12:07:22.238Z | 2026-03-27T12:40:50.143Z |
| 9520188 | 9520188 | 20260319030123_zMvMU | CH0005 | 2026-03-20T12:05:55.815Z | 2026-03-27T12:40:40.275Z |
| 9518228 | 9518228 | 20260319004438_Qvxde | CH0005 | 2026-03-20T12:02:09.967Z | 2026-03-27T12:40:07.735Z |
| 9517068 | 9517068 | 20260317223606_zkhMu | CH0005 | 2026-03-19T12:27:09.242Z | 2026-03-25T12:43:08.433Z |
| 9516478 | 9516478 | 20260317205826_GqskI | CH0005 | 2026-03-19T12:26:16.065Z | 2026-03-25T12:42:59.786Z |
| 9516233 | 9516233 | 20260317201718_hwt3b | CH0005 | 2026-03-19T12:25:48.450Z | 2026-03-25T12:42:51.863Z |
| 9516231 | 9516231 | 20260317201716_vVCHx | CH0005 | 2026-03-19T12:25:48.197Z | 2026-03-25T12:42:51.829Z |
| 9510472 | 9510472 | 20260318025402_O0y3q | CH0005 | 2026-03-19T12:07:43.876Z | 2026-03-26T12:37:12.774Z |
| 9508596 | 9508596 | 20260318010432_d0qNL | CH0005 | 2026-03-19T12:03:27.419Z | 2026-03-26T12:36:59.680Z |
| 9508552 | 9508552 | 20260318010254_vm4FY | CH0005 | 2026-03-19T12:03:18.846Z | 2026-03-26T12:36:59.259Z |
| 9508392 | 9508392 | 20260318005053_FnEvH | CH0005 | 2026-03-19T12:02:59.676Z | 2026-03-26T12:36:58.212Z |
| 9508145 | 9508145 | 20260318002531_DY612 | CH0005 | 2026-03-19T12:02:23.851Z | 2026-03-26T12:36:56.257Z |
| 9507901 | 9507901 | 20260317235330_tBD6D | CH0005 | 2026-03-19T12:01:37.500Z | 2026-03-26T12:36:54.277Z |
| 9507859 | 9507859 | 20260317234958_PWYrJ | CH0005 | 2026-03-19T12:01:30.060Z | 2026-03-26T12:36:54.023Z |
| 9502532 | 9502532 | 20260317042052_ISLVB | CH0005 | 2026-03-18T12:03:09.927Z | 2026-03-25T12:41:50.873Z |
| 9502521 | 9502521 | 20260317041758_gW3LG | CH0005 | 2026-03-18T12:03:07.459Z | 2026-03-25T12:41:50.768Z |
| 9502411 | 9502411 | 20260317034241_q21c8 | CH0005 | 2026-03-18T12:02:43.978Z | 2026-03-25T12:41:49.489Z |
| 9502372 | 9502372 | 20260317032621_LyJL1 | CH0005 | 2026-03-18T12:02:35.477Z | 2026-03-25T12:41:49.057Z |
| 9502368 | 9502368 | 20260317032454_Sgflp | CH0005 | 2026-03-18T12:02:35.038Z | 2026-03-25T12:41:49.032Z |
| 9502326 | 9502326 | 20260317031543_yWkYR | CH0005 | 2026-03-18T12:02:24.301Z | 2026-03-25T12:41:48.631Z |
| 9502204 | 9502204 | 20260317023958_gWOsA | CH0005 | 2026-03-18T12:01:55.021Z | 2026-03-25T12:41:47.457Z |
| 9502145 | 9502145 | 20260317021811_24DLi | CH0005 | 2026-03-18T12:01:40.921Z | 2026-03-25T12:41:46.863Z |
| 9502081 | 9502081 | 20260317014810_yr9XG | CH0005 | 2026-03-18T12:01:25.480Z | 2026-03-25T12:41:45.450Z |
| 9502041 | 9502041 | 20260317012837_WD0iw | CH0005 | 2026-03-18T12:01:16.370Z | 2026-03-25T12:41:45.024Z |
| 9495139 | 9495139 | 20260316042046_XNpnF | CH0005 | 2026-03-17T12:06:11.557Z | 2026-03-24T12:40:59.071Z |
| 9495119 | 9495119 | 20260316041733_WDTEa | CH0005 | 2026-03-17T12:06:08.676Z | 2026-03-24T12:40:58.346Z |
| 9494798 | 9494798 | 20260316030526_Of8GZ | CH0005 | 2026-03-17T12:05:01.798Z | 2026-03-24T12:40:50.231Z |
| 9494759 | 9494759 | 20260316025337_VLgXO | CH0005 | 2026-03-17T12:04:51.626Z | 2026-03-24T12:40:49.790Z |
| 9494734 | 9494734 | 20260316025121_YBPxo | CH0005 | 2026-03-17T12:04:45.671Z | 2026-03-24T12:40:49.560Z |
| 9494674 | 9494674 | 20260316024447_ywGn4 | CH0005 | 2026-03-17T12:04:36.264Z | 2026-03-24T12:40:49.294Z |
| 9494232 | 9494232 | 20260316014331_OZI1E | CH0005 | 2026-03-17T12:03:23.735Z | 2026-03-24T12:40:46.005Z |
| 9474272 | 9474272 | 20260312221522_jmHBx | CH0005 | 2026-03-14T12:22:27.216Z | 2026-03-20T12:37:17.178Z |
| 9470039 | 9470039 | 20260313042236_GQ3Kk | CH0005 | 2026-03-14T12:06:18.567Z | 2026-03-21T12:49:05.301Z |
| 9469642 | 9469642 | 20260313032207_4dweJ | CH0005 | 2026-03-14T12:05:02.684Z | 2026-03-21T12:48:53.635Z |
| 9469495 | 9469495 | 20260313025806_dCxf2 | CH0005 | 2026-03-14T12:04:28.678Z | 2026-03-21T12:48:40.362Z |
| 9469334 | 9469334 | 20260313022958_vyBHB | CH0005 | 2026-03-14T12:03:54.439Z | 2026-03-21T12:48:37.639Z |
| 9469321 | 9469321 | 20260313022920_EKrWH | CH0005 | 2026-03-14T12:03:51.310Z | 2026-03-21T12:48:37.535Z |
| 9469306 | 9469306 | 20260313022717_YdU2Q | CH0005 | 2026-03-14T12:03:47.533Z | 2026-03-21T12:48:37.229Z |
| 9469294 | 9469294 | 20260313022554_AJbUo | CH0005 | 2026-03-14T12:03:43.993Z | 2026-03-21T12:48:37.017Z |
| 9469227 | 9469227 | 20260313021709_jGdZI | CH0005 | 2026-03-14T12:03:30.501Z | 2026-03-21T12:48:35.537Z |
| 9469194 | 9469194 | 20260313021108_drUO5 | CH0005 | 2026-03-14T12:03:21.784Z | 2026-03-21T12:48:34.805Z |
| 9469054 | 9469054 | 20260313013628_hr2uQ | CH0005 | 2026-03-14T12:02:46.826Z | 2026-03-21T12:48:32.927Z |
| 9468993 | 9468993 | 20260313012736_njXzD | CH0005 | 2026-03-14T12:02:35.921Z | 2026-03-21T12:48:32.362Z |
| 9468986 | 9468986 | 20260313012725_jY71l | CH0005 | 2026-03-14T12:02:34.506Z | 2026-03-21T12:48:32.299Z |
| 9468717 | 9468717 | 20260313002511_dcxKx | CH0005 | 2026-03-14T12:01:30.176Z | 2026-03-21T12:48:28.327Z |
| 9468608 | 9468608 | 20260312235333_XzD6o | CH0005 | 2026-03-14T12:00:58.633Z | 2026-03-21T12:48:26.951Z |
| 9468543 | 9468543 | 20260312232710_TP0Eg | CH0005 | 2026-03-14T12:00:37.456Z | 2026-03-21T12:48:26.049Z |
| 9468509 | 9468509 | 20260312230509_n1yEa | CH0005 | 2026-03-14T12:00:27.837Z | 2026-03-21T12:48:25.425Z |
| 9468490 | 9468490 | 20260312230225_GXpGp | CH0005 | 2026-03-14T12:00:22.431Z | 2026-03-21T12:48:25.243Z |
| 9468453 | 9468453 | 20260312224646_IrpIB | CH0005 | 2026-03-14T12:00:13.280Z | 2026-03-21T12:48:24.721Z |
| 9456255 | 9456255 | 20260309223101_2qNk4 | CH0005 | 2026-03-11T12:15:55.404Z | 2026-03-17T12:43:01.088Z |
| 9455867 | 9455867 | 20260309204816_K18by | CH0005 | 2026-03-11T12:15:09.811Z | 2026-03-17T12:42:40.056Z |
| 9451842 | 9451842 | 20260310042157_Fse3f | CH0005 | 2026-03-11T12:04:01.290Z | 2026-03-18T12:39:05.634Z |
| 9451110 | 9451110 | 20260310004532_qaPAf | CH0005 | 2026-03-11T12:01:45.622Z | 2026-03-18T12:38:40.622Z |
| 9451010 | 9451010 | 20260310001908_2RZeX | CH0005 | 2026-03-11T12:01:26.040Z | 2026-03-18T12:38:39.197Z |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE participating_station
(
meteor_unique_trajectory_identifier text NOT NULL,
station_code text NOT NULL,
created_at datetime NOT NULL DEFAULT (
strftime(
'%Y-%m-%dT%H:%M:%fZ', 'now', 'utc'
)
),
updated_at datetime NOT NULL DEFAULT (
strftime(
'%Y-%m-%dT%H:%M:%fZ', 'now', 'utc'
)
),
FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier),
FOREIGN KEY (station_code) REFERENCES station (code),
UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE
);
CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier);
CREATE INDEX participating_station_created_at_index ON participating_station (created_at);
CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);