participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,994 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 |
---|---|---|---|---|---|
5605148 | 5605148 | 20241125030812_zCSUK | CH0005 | 2024-11-26T14:18:36.546Z | 2024-11-26T14:18:45.253Z |
5605082 | 5605082 | 20241125025039_juPXg | CH0005 | 2024-11-26T14:18:30.822Z | 2024-11-26T14:18:45.229Z |
5604948 | 5604948 | 20241125021756_8E4cZ | CH0005 | 2024-11-26T14:18:14.741Z | 2024-11-26T14:18:45.186Z |
5604933 | 5604933 | 20241125021134_mqJcZ | CH0005 | 2024-11-26T14:18:12.423Z | 2024-11-26T14:18:45.180Z |
5604889 | 5604889 | 20241125015739_CyVJr | CH0005 | 2024-11-26T14:18:02.942Z | 2024-11-26T14:18:45.162Z |
5604885 | 5604885 | 20241125015631_896O6 | CH0005 | 2024-11-26T14:18:02.503Z | 2024-11-26T14:18:45.161Z |
5604858 | 5604858 | 20241125014734_wVPmc | CH0005 | 2024-11-26T14:17:59.540Z | 2024-11-26T14:18:45.149Z |
5604809 | 5604809 | 20241125012633_93YCS | CH0005 | 2024-11-26T14:17:52.742Z | 2024-11-26T14:18:45.135Z |
5604588 | 5604588 | 20241125001157_KZFKm | CH0005 | 2024-11-26T14:17:22.443Z | 2024-11-26T14:18:45.071Z |
5604533 | 5604533 | 20241124234857_Hb2Us | CH0005 | 2024-11-26T14:17:14.116Z | 2024-11-26T14:18:45.049Z |
5604229 | 5604229 | 20241124213436_PBKny | CH0005 | 2024-11-26T14:16:51.745Z | 2024-11-26T14:18:44.952Z |
5604066 | 5604066 | 20241124201559_Ntvl3 | CH0005 | 2024-11-26T14:16:20.238Z | 2024-11-26T14:18:44.859Z |
5600397 | 5600397 | 20241125044748_jnnKG | CH0005 | 2024-11-26T14:01:46.253Z | 2024-11-26T14:01:46.253Z |
5600395 | 5600395 | 20241125044730_8mQBM | CH0005 | 2024-11-26T14:01:45.823Z | 2024-11-26T14:01:45.823Z |
5600190 | 5600190 | 20241125040114_9Ubxe | CH0005 | 2024-11-26T14:00:52.563Z | 2024-11-26T14:00:52.563Z |
5600162 | 5600162 | 20241125035439_5uGwO | CH0005 | 2024-11-26T14:00:43.938Z | 2024-11-26T14:00:43.938Z |
5600052 | 5600052 | 20241125032922_LrBb2 | CH0005 | 2024-11-26T14:00:18.843Z | 2024-11-26T14:00:18.843Z |
5592533 | 5592533 | 20241123034541_vGzUc | CH0005 | 2024-11-24T14:21:07.302Z | 2024-11-26T14:23:47.860Z |
5592517 | 5592517 | 20241123034241_GSbz1 | CH0005 | 2024-11-24T14:21:06.454Z | 2024-11-26T14:23:47.701Z |
5592458 | 5592458 | 20241123033104_GyLa8 | CH0005 | 2024-11-24T14:21:02.428Z | 2024-11-26T14:23:46.740Z |
5592398 | 5592398 | 20241123031851_xuXZY | CH0005 | 2024-11-24T14:20:59.800Z | 2024-11-26T14:23:46.151Z |
5592344 | 5592344 | 20241123030912_Jc56i | CH0005 | 2024-11-24T14:20:56.572Z | 2024-11-26T14:23:45.218Z |
5584388 | 5584388 | 20241123042832_6TrYo | CH0005 | 2024-11-24T14:00:53.001Z | 2024-11-26T14:18:55.555Z |
5584294 | 5584294 | 20241123041000_hpDT4 | CH0005 | 2024-11-24T14:00:33.831Z | 2024-11-26T14:18:50.663Z |
5584224 | 5584224 | 20241123035718_DJvQV | CH0005 | 2024-11-24T14:00:16.349Z | 2024-11-26T14:18:48.278Z |
5544938 | 5544938 | 20241115174618_n2ZI0 | CH0005 | 2024-11-17T14:03:22.365Z | 2024-11-24T14:25:41.333Z |
5543002 | 5543002 | 20241114173925_4nMSR | CH0005 | 2024-11-16T14:05:14.697Z | 2024-11-23T14:26:16.962Z |
5511186 | 5511186 | 20241109045817_JlAY6 | CH0005 | 2024-11-10T14:16:26.880Z | 2024-11-17T14:24:06.319Z |
5511172 | 5511172 | 20241109045633_ByFPU | CH0005 | 2024-11-10T14:16:24.402Z | 2024-11-17T14:24:06.141Z |
5511097 | 5511097 | 20241109042510_58yF2 | CH0005 | 2024-11-10T14:16:14.394Z | 2024-11-17T14:24:04.548Z |
5510722 | 5510722 | 20241109032936_DSQbk | CH0005 | 2024-11-10T14:15:35.991Z | 2024-11-17T14:24:00.623Z |
5510556 | 5510556 | 20241109025831_vbteQ | CH0005 | 2024-11-10T14:15:26.348Z | 2024-11-17T14:23:58.978Z |
5510523 | 5510523 | 20241109025337_2V9mx | CH0005 | 2024-11-10T14:15:24.437Z | 2024-11-17T14:23:58.544Z |
5510398 | 5510398 | 20241109023453_2E4GQ | CH0005 | 2024-11-10T14:15:08.939Z | 2024-11-17T14:23:56.908Z |
5510015 | 5510015 | 20241109012707_QtkRF | CH0005 | 2024-11-10T14:14:26.940Z | 2024-11-17T14:23:52.036Z |
5508993 | 5508993 | 20241108210801_FqUKG | CH0005 | 2024-11-10T14:12:15.092Z | 2024-11-17T14:23:39.005Z |
5508773 | 5508773 | 20241108191739_Qqix8 | CH0005 | 2024-11-10T14:11:47.576Z | 2024-11-17T14:23:33.264Z |
5495926 | 5495926 | 20241106220928_C5MmJ | CH0005 | 2024-11-08T14:11:08.859Z | 2024-11-15T14:24:54.113Z |
5495858 | 5495858 | 20241106215133_nTR4a | CH0005 | 2024-11-08T14:11:01.911Z | 2024-11-15T14:24:53.633Z |
5495794 | 5495794 | 20241106213546_Mn2C4 | CH0005 | 2024-11-08T14:10:53.617Z | 2024-11-15T14:24:53.280Z |
5495695 | 5495695 | 20241106210457_EJZNv | CH0005 | 2024-11-08T14:10:38.503Z | 2024-11-15T14:24:52.400Z |
5495329 | 5495329 | 20241106192922_dLv5n | CH0005 | 2024-11-08T14:10:00.168Z | 2024-11-15T14:24:48.386Z |
5491720 | 5491720 | 20241106044152_ZBiCe | CH0005 | 2024-11-07T14:16:51.197Z | 2024-11-14T14:23:26.565Z |
5491398 | 5491398 | 20241106031156_KzfrX | CH0005 | 2024-11-07T14:16:03.391Z | 2024-11-14T14:23:25.646Z |
5491028 | 5491028 | 20241106014016_e5Fv8 | CH0005 | 2024-11-07T14:15:13.801Z | 2024-11-14T14:23:23.276Z |
5491007 | 5491007 | 20241106013409_oobQn | CH0005 | 2024-11-07T14:15:11.926Z | 2024-11-14T14:23:23.179Z |
5490862 | 5490862 | 20241106005830_tw27r | CH0005 | 2024-11-07T14:15:00.675Z | 2024-11-14T14:23:22.632Z |
5490680 | 5490680 | 20241106000623_xi9rU | CH0005 | 2024-11-07T14:14:29.781Z | 2024-11-14T14:23:21.206Z |
5490584 | 5490584 | 20241105233036_8rFxn | CH0005 | 2024-11-07T14:14:15.033Z | 2024-11-14T14:23:20.848Z |
5490150 | 5490150 | 20241105212334_2OQzF | CH0005 | 2024-11-07T14:13:20.559Z | 2024-11-14T14:23:17.803Z |
5490145 | 5490145 | 20241105212034_CqgDU | CH0005 | 2024-11-07T14:13:19.799Z | 2024-11-14T14:23:17.613Z |
5490131 | 5490131 | 20241105211529_ceooc | CH0005 | 2024-11-07T14:13:16.781Z | 2024-11-14T14:23:17.582Z |
5490123 | 5490123 | 20241105211208_B5tSF | CH0005 | 2024-11-07T14:13:15.362Z | 2024-11-14T14:23:17.558Z |
5489396 | 5489396 | 20241105184338_Ib12o | CH0005 | 2024-11-07T14:11:58.418Z | 2024-11-14T14:23:12.745Z |
5463704 | 5463704 | 20241102044145_SU2jZ | CH0005 | 2024-11-03T14:19:11.095Z | 2024-11-10T14:26:36.429Z |
5463598 | 5463598 | 20241102041628_P2MBG | CH0005 | 2024-11-03T14:19:00.934Z | 2024-11-10T14:26:35.654Z |
5463503 | 5463503 | 20241102034739_R2oFZ | CH0005 | 2024-11-03T14:18:51.353Z | 2024-11-10T14:26:35.384Z |
5463499 | 5463499 | 20241102034731_UIulo | CH0005 | 2024-11-03T14:18:51.051Z | 2024-11-10T14:26:35.383Z |
5463450 | 5463450 | 20241102034017_Ak83V | CH0005 | 2024-11-03T14:18:46.097Z | 2024-11-10T14:26:35.310Z |
5463431 | 5463431 | 20241102033731_FkII0 | CH0005 | 2024-11-03T14:18:45.159Z | 2024-11-10T14:26:35.216Z |
5463394 | 5463394 | 20241102033131_8kFeO | CH0005 | 2024-11-03T14:18:41.315Z | 2024-11-10T14:26:35.080Z |
5463386 | 5463386 | 20241102033104_wOW3U | CH0005 | 2024-11-03T14:18:41.047Z | 2024-11-10T14:26:35.074Z |
5463377 | 5463377 | 20241102033009_lc5GH | CH0005 | 2024-11-03T14:18:40.661Z | 2024-11-10T14:26:35.046Z |
5463376 | 5463376 | 20241102032954_kBv9C | CH0005 | 2024-11-03T14:18:40.240Z | 2024-11-10T14:26:35.045Z |
5463203 | 5463203 | 20241102025259_G2KJZ | CH0005 | 2024-11-03T14:18:26.237Z | 2024-11-10T14:26:34.519Z |
5463176 | 5463176 | 20241102024704_SWlC9 | CH0005 | 2024-11-03T14:18:25.243Z | 2024-11-10T14:26:34.449Z |
5463110 | 5463110 | 20241102023609_0arhK | CH0005 | 2024-11-03T14:18:19.489Z | 2024-11-10T14:26:34.271Z |
5463094 | 5463094 | 20241102023325_DpUzy | CH0005 | 2024-11-03T14:18:17.967Z | 2024-11-10T14:26:34.261Z |
5463067 | 5463067 | 20241102022926_JbEiY | CH0005 | 2024-11-03T14:18:16.801Z | 2024-11-10T14:26:34.192Z |
5462925 | 5462925 | 20241102015712_AeiRJ | CH0005 | 2024-11-03T14:18:10.059Z | 2024-11-10T14:26:33.730Z |
5462581 | 5462581 | 20241102004736_XMGAW | CH0005 | 2024-11-03T14:17:44.418Z | 2024-11-10T14:26:32.932Z |
5462470 | 5462470 | 20241102002452_amsV5 | CH0005 | 2024-11-03T14:17:28.428Z | 2024-11-10T14:26:32.594Z |
5462446 | 5462446 | 20241102002156_3L5K7 | CH0005 | 2024-11-03T14:17:26.691Z | 2024-11-10T14:26:32.533Z |
5462419 | 5462419 | 20241102001536_5vjW3 | CH0005 | 2024-11-03T14:17:25.228Z | 2024-11-10T14:26:32.475Z |
5462263 | 5462263 | 20241101233454_ct25I | CH0005 | 2024-11-03T14:17:06.792Z | 2024-11-10T14:26:32.066Z |
5462256 | 5462256 | 20241101233226_XPPFH | CH0005 | 2024-11-03T14:17:06.328Z | 2024-11-10T14:26:32.042Z |
5461955 | 5461955 | 20241101222338_ts7Nj | CH0005 | 2024-11-03T14:16:49.016Z | 2024-11-10T14:26:31.084Z |
5461936 | 5461936 | 20241101221810_O6A9b | CH0005 | 2024-11-03T14:16:47.797Z | 2024-11-10T14:26:30.981Z |
5461602 | 5461602 | 20241101201225_Dw3lt | CH0005 | 2024-11-03T14:15:57.825Z | 2024-11-10T14:26:29.242Z |
5461354 | 5461354 | 20241101181442_uBL6K | CH0005 | 2024-11-03T14:15:16.495Z | 2024-11-10T14:26:28.226Z |
5461325 | 5461325 | 20241101175857_yWWP4 | CH0005 | 2024-11-03T14:15:10.329Z | 2024-11-10T14:26:28.119Z |
5443281 | 5443281 | 20241030043106_gWyom | CH0005 | 2024-11-01T12:20:26.444Z | 2024-11-07T14:26:50.531Z |
5442116 | 5442116 | 20241030003926_tc3MU | CH0005 | 2024-11-01T12:19:26.202Z | 2024-11-07T14:26:45.074Z |
5442112 | 5442112 | 20241030003747_OyKS3 | CH0005 | 2024-11-01T12:19:26.088Z | 2024-11-07T14:26:45.063Z |
5442022 | 5442022 | 20241030002058_2GK28 | CH0005 | 2024-11-01T12:19:19.926Z | 2024-11-07T14:26:44.747Z |
5441903 | 5441903 | 20241030000015_pYTF7 | CH0005 | 2024-11-01T12:19:11.803Z | 2024-11-07T14:26:44.301Z |
5441420 | 5441420 | 20241029220840_JaK4i | CH0005 | 2024-11-01T12:18:33.766Z | 2024-11-07T14:26:42.017Z |
5433641 | 5433641 | 20241029203602_OZaWO | CH0005 | 2024-10-31T12:22:25.475Z | 2024-11-07T14:26:40.470Z |
5433366 | 5433366 | 20241029192524_RTvKa | CH0005 | 2024-10-31T12:22:10.728Z | 2024-11-07T14:26:38.749Z |
5433195 | 5433195 | 20241029180858_KPhgN | CH0005 | 2024-10-31T12:21:56.551Z | 2024-11-07T14:26:36.333Z |
5433160 | 5433160 | 20241029174610_zhqNK | CH0005 | 2024-10-31T12:21:53.494Z | 2024-11-07T14:26:35.831Z |
5432816 | 5432816 | 20241029044635_X1Qpg | CH0005 | 2024-10-31T12:21:35.986Z | 2024-11-06T14:27:28.806Z |
5432801 | 5432801 | 20241029044139_q0Mft | CH0005 | 2024-10-31T12:21:35.595Z | 2024-11-06T14:27:28.755Z |
5432795 | 5432795 | 20241029044053_PgJmh | CH0005 | 2024-10-31T12:21:35.352Z | 2024-11-06T14:27:28.738Z |
5432789 | 5432789 | 20241029043949_K75IM | CH0005 | 2024-10-31T12:21:35.197Z | 2024-11-06T14:27:28.713Z |
5432725 | 5432725 | 20241029042656_F94Qq | CH0005 | 2024-10-31T12:21:32.716Z | 2024-11-06T14:27:28.571Z |
5432670 | 5432670 | 20241029041308_a02Df | CH0005 | 2024-10-31T12:21:30.697Z | 2024-11-06T14:27:28.356Z |
5432664 | 5432664 | 20241029041238_MTNhW | CH0005 | 2024-10-31T12:21:30.500Z | 2024-11-06T14:27:28.325Z |
5432410 | 5432410 | 20241029032915_l6qc1 | CH0005 | 2024-10-31T12:21:21.374Z | 2024-11-06T14:27:26.980Z |
5432314 | 5432314 | 20241029031303_td1rF | CH0005 | 2024-10-31T12:21:17.568Z | 2024-11-06T14:27:26.646Z |
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);