participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,621 rows where station_code = "US004C" 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 |
---|---|---|---|---|---|
5584181 | 5584181 | 20241117041056_GC7j2 | US004C | 2024-11-23T14:25:43.962Z | 2024-11-23T14:25:43.962Z |
5583889 | 5583889 | 20241119005903_j4w7I | US004C | 2024-11-23T14:25:08.009Z | 2024-11-23T14:25:08.009Z |
5583621 | 5583621 | 20241120040926_NjGNM | US004C | 2024-11-23T14:24:46.450Z | 2024-11-23T14:24:46.450Z |
5582926 | 5582926 | 20241120072811_Kp1Mg | US004C | 2024-11-23T14:21:58.867Z | 2024-11-23T14:21:58.867Z |
5582488 | 5582488 | 20241122033827_t8ITG | US004C | 2024-11-23T14:21:06.483Z | 2024-11-23T14:21:25.729Z |
5582469 | 5582469 | 20241122033501_eL4e7 | US004C | 2024-11-23T14:21:05.824Z | 2024-11-23T14:21:25.726Z |
5581841 | 5581841 | 20241122024055_HpYDb | US004C | 2024-11-23T14:20:47.562Z | 2024-11-23T14:21:25.627Z |
5581540 | 5581540 | 20241122021126_sy63Z | US004C | 2024-11-23T14:20:30.559Z | 2024-11-23T14:21:25.574Z |
5581414 | 5581414 | 20241122020040_FJH5u | US004C | 2024-11-23T14:20:22.606Z | 2024-11-23T14:21:25.555Z |
5577081 | 5577081 | 20241121064540_pmaOR | US004C | 2024-11-23T14:12:14.327Z | 2024-11-23T14:21:23.743Z |
5576343 | 5576343 | 20241122114951_QGSlD | US004C | 2024-11-23T14:09:15.875Z | 2024-11-23T14:09:15.875Z |
5576302 | 5576302 | 20241122114505_TlEZF | US004C | 2024-11-23T14:09:09.238Z | 2024-11-23T14:09:09.238Z |
5576295 | 5576295 | 20241122114243_LiNrX | US004C | 2024-11-23T14:09:08.241Z | 2024-11-23T14:09:08.241Z |
5576221 | 5576221 | 20241122113231_W4r19 | US004C | 2024-11-23T14:08:50.202Z | 2024-11-23T14:08:50.202Z |
5576205 | 5576205 | 20241122112859_7cGzD | US004C | 2024-11-23T14:08:45.726Z | 2024-11-23T14:08:45.726Z |
5576133 | 5576133 | 20241122111914_gs5Vy | US004C | 2024-11-23T14:08:37.870Z | 2024-11-23T14:08:37.870Z |
5576063 | 5576063 | 20241122111133_0vpF8 | US004C | 2024-11-23T14:08:30.615Z | 2024-11-23T14:08:30.615Z |
5575900 | 5575900 | 20241122104458_6qLv4 | US004C | 2024-11-23T14:08:00.828Z | 2024-11-23T14:08:00.828Z |
5575813 | 5575813 | 20241122102404_Ozbgx | US004C | 2024-11-23T14:07:39.752Z | 2024-11-23T14:07:39.752Z |
5575792 | 5575792 | 20241122102012_dFBTG | US004C | 2024-11-23T14:07:36.945Z | 2024-11-23T14:07:36.945Z |
5575772 | 5575772 | 20241122101521_9H9nu | US004C | 2024-11-23T14:07:33.563Z | 2024-11-23T14:07:33.563Z |
5575558 | 5575558 | 20241122094138_eFvGk | US004C | 2024-11-23T14:06:48.330Z | 2024-11-23T14:06:48.330Z |
5575546 | 5575546 | 20241122094005_H51U4 | US004C | 2024-11-23T14:06:46.991Z | 2024-11-23T14:06:46.991Z |
5575433 | 5575433 | 20241122092159_JDUhy | US004C | 2024-11-23T14:06:34.077Z | 2024-11-23T14:06:34.077Z |
5575317 | 5575317 | 20241122090259_BvpBT | US004C | 2024-11-23T14:06:07.679Z | 2024-11-23T14:06:07.679Z |
5575308 | 5575308 | 20241122090234_qAQU6 | US004C | 2024-11-23T14:06:06.469Z | 2024-11-23T14:06:06.469Z |
5575287 | 5575287 | 20241122085906_oBx7K | US004C | 2024-11-23T14:06:03.846Z | 2024-11-23T14:06:03.846Z |
5575285 | 5575285 | 20241122085828_mBgXC | US004C | 2024-11-23T14:06:03.570Z | 2024-11-23T14:06:03.570Z |
5575220 | 5575220 | 20241122084359_EvTUc | US004C | 2024-11-23T14:05:48.978Z | 2024-11-23T14:05:48.978Z |
5575194 | 5575194 | 20241122083347_QuG7U | US004C | 2024-11-23T14:05:45.096Z | 2024-11-23T14:05:45.096Z |
5575180 | 5575180 | 20241122083205_izOxx | US004C | 2024-11-23T14:05:41.299Z | 2024-11-23T14:05:41.299Z |
5575174 | 5575174 | 20241122082903_OP3XC | US004C | 2024-11-23T14:05:40.311Z | 2024-11-23T14:05:40.311Z |
5575148 | 5575148 | 20241122082309_1hrwU | US004C | 2024-11-23T14:05:36.406Z | 2024-11-23T14:05:36.406Z |
5575131 | 5575131 | 20241122081840_SgltA | US004C | 2024-11-23T14:05:32.849Z | 2024-11-23T14:05:32.849Z |
5575103 | 5575103 | 20241122081125_r09ZO | US004C | 2024-11-23T14:05:28.237Z | 2024-11-23T14:05:28.237Z |
5575101 | 5575101 | 20241122081100_YMOpk | US004C | 2024-11-23T14:05:27.764Z | 2024-11-23T14:05:27.764Z |
5575060 | 5575060 | 20241122075429_E30cG | US004C | 2024-11-23T14:05:17.497Z | 2024-11-23T14:05:17.497Z |
5575047 | 5575047 | 20241122074643_JyvL8 | US004C | 2024-11-23T14:05:10.148Z | 2024-11-23T14:05:10.148Z |
5575029 | 5575029 | 20241122074157_27H6b | US004C | 2024-11-23T14:05:06.770Z | 2024-11-23T14:05:06.770Z |
5574977 | 5574977 | 20241122072605_mZVFB | US004C | 2024-11-23T14:04:59.110Z | 2024-11-23T14:04:59.110Z |
5574947 | 5574947 | 20241122071230_SqMOq | US004C | 2024-11-23T14:04:53.811Z | 2024-11-23T14:04:53.811Z |
5574840 | 5574840 | 20241122064209_kyU0g | US004C | 2024-11-23T14:04:33.409Z | 2024-11-23T14:04:33.409Z |
5574727 | 5574727 | 20241122062019_F8XEo | US004C | 2024-11-23T14:04:11.393Z | 2024-11-23T14:04:11.393Z |
5574698 | 5574698 | 20241122061537_nqFV2 | US004C | 2024-11-23T14:04:07.647Z | 2024-11-23T14:04:07.647Z |
5574678 | 5574678 | 20241122061214_U6yyS | US004C | 2024-11-23T14:04:04.347Z | 2024-11-23T14:04:04.347Z |
5574640 | 5574640 | 20241122060820_mqR7g | US004C | 2024-11-23T14:03:56.549Z | 2024-11-23T14:03:56.549Z |
5574621 | 5574621 | 20241122060619_WKIL1 | US004C | 2024-11-23T14:03:49.920Z | 2024-11-23T14:03:49.920Z |
5574520 | 5574520 | 20241122055744_3ah1e | US004C | 2024-11-23T14:03:37.293Z | 2024-11-23T14:03:37.293Z |
5574329 | 5574329 | 20241122053428_4y1f3 | US004C | 2024-11-23T14:03:02.621Z | 2024-11-23T14:03:02.621Z |
5574040 | 5574040 | 20241122050335_vfaJ5 | US004C | 2024-11-23T14:02:14.292Z | 2024-11-23T14:02:14.292Z |
5573973 | 5573973 | 20241122045646_mKnqR | US004C | 2024-11-23T14:02:03.447Z | 2024-11-23T14:02:03.447Z |
5573733 | 5573733 | 20241122043735_jhJ3J | US004C | 2024-11-23T14:01:21.010Z | 2024-11-23T14:01:21.010Z |
5573567 | 5573567 | 20241122042711_6HpI8 | US004C | 2024-11-23T14:00:56.543Z | 2024-11-23T14:00:56.543Z |
5573241 | 5573241 | 20241121041230_vcxML | US004C | 2024-11-22T14:19:17.857Z | 2024-11-23T14:23:52.840Z |
5573188 | 5573188 | 20241121040503_NenFy | US004C | 2024-11-22T14:19:14.846Z | 2024-11-23T14:23:52.330Z |
5573142 | 5573142 | 20241121035950_e6x4a | US004C | 2024-11-22T14:19:12.308Z | 2024-11-23T14:23:51.906Z |
5573065 | 5573065 | 20241121034743_7nUqn | US004C | 2024-11-22T14:19:08.197Z | 2024-11-23T14:23:51.399Z |
5572899 | 5572899 | 20241121032333_3FEUd | US004C | 2024-11-22T14:18:57.585Z | 2024-11-23T14:23:49.361Z |
5572384 | 5572384 | 20241121021552_HAjO2 | US004C | 2024-11-22T14:18:21.090Z | 2024-11-23T14:23:44.847Z |
5572366 | 5572366 | 20241121021413_J5duc | US004C | 2024-11-22T14:18:19.555Z | 2024-11-23T14:23:44.319Z |
5572362 | 5572362 | 20241121021402_NH3qN | US004C | 2024-11-22T14:18:19.178Z | 2024-11-23T14:23:44.237Z |
5572296 | 5572296 | 20241121020632_3338a | US004C | 2024-11-22T14:18:13.877Z | 2024-11-23T14:23:42.693Z |
5571921 | 5571921 | 20241121010822_55zBB | US004C | 2024-11-22T14:17:47.219Z | 2024-11-23T14:23:37.834Z |
5571777 | 5571777 | 20241121004517_dIOrX | US004C | 2024-11-22T14:17:39.085Z | 2024-11-23T14:23:34.665Z |
5568122 | 5568122 | 20241121115314_dZOmT | US004C | 2024-11-22T14:08:08.914Z | 2024-11-23T14:21:24.199Z |
5568083 | 5568083 | 20241121114629_Wb9XG | US004C | 2024-11-22T14:08:04.100Z | 2024-11-23T14:21:24.188Z |
5568051 | 5568051 | 20241121114453_eHlRt | US004C | 2024-11-22T14:08:01.185Z | 2024-11-23T14:21:24.183Z |
5568048 | 5568048 | 20241121114406_X1AWv | US004C | 2024-11-22T14:08:00.461Z | 2024-11-23T14:21:24.181Z |
5567946 | 5567946 | 20241121113418_ofS1u | US004C | 2024-11-22T14:07:50.187Z | 2024-11-23T14:21:24.156Z |
5567898 | 5567898 | 20241121112509_30p02 | US004C | 2024-11-22T14:07:31.479Z | 2024-11-23T14:21:24.144Z |
5567599 | 5567599 | 20241121104218_9JFfX | US004C | 2024-11-22T14:06:35.931Z | 2024-11-23T14:21:24.055Z |
5567451 | 5567451 | 20241121102102_nyrGm | US004C | 2024-11-22T14:06:18.713Z | 2024-11-23T14:21:24.017Z |
5567449 | 5567449 | 20241121102056_UQ0tn | US004C | 2024-11-22T14:06:18.262Z | 2024-11-23T14:21:24.015Z |
5567442 | 5567442 | 20241121102016_Oe3K5 | US004C | 2024-11-22T14:06:17.184Z | 2024-11-23T14:21:24.012Z |
5567391 | 5567391 | 20241121100914_OJB2w | US004C | 2024-11-22T14:06:04.300Z | 2024-11-23T14:21:23.998Z |
5567376 | 5567376 | 20241121100649_Owf95 | US004C | 2024-11-22T14:06:02.270Z | 2024-11-23T14:21:23.994Z |
5567360 | 5567360 | 20241121100626_TlkQQ | US004C | 2024-11-22T14:05:59.529Z | 2024-11-23T14:21:23.990Z |
5567212 | 5567212 | 20241121094125_fQIW1 | US004C | 2024-11-22T14:05:34.870Z | 2024-11-23T14:21:23.948Z |
5567187 | 5567187 | 20241121093805_55GLb | US004C | 2024-11-22T14:05:31.389Z | 2024-11-23T14:21:23.939Z |
5567183 | 5567183 | 20241121093741_201xi | US004C | 2024-11-22T14:05:31.040Z | 2024-11-23T14:21:23.938Z |
5567131 | 5567131 | 20241121093020_XV2QN | US004C | 2024-11-22T14:05:25.498Z | 2024-11-23T14:21:23.920Z |
5566978 | 5566978 | 20241121085236_blqNz | US004C | 2024-11-22T14:04:48.843Z | 2024-11-23T14:21:23.868Z |
5566933 | 5566933 | 20241121084503_qs6pF | US004C | 2024-11-22T14:04:32.969Z | 2024-11-23T14:21:23.853Z |
5566915 | 5566915 | 20241121083812_H3HHR | US004C | 2024-11-22T14:04:28.970Z | 2024-11-23T14:21:23.846Z |
5566884 | 5566884 | 20241121082451_fJ2OX | US004C | 2024-11-22T14:04:22.325Z | 2024-11-23T14:21:23.837Z |
5566875 | 5566875 | 20241121082054_laWzV | US004C | 2024-11-22T14:04:20.534Z | 2024-11-23T14:21:23.834Z |
5566869 | 5566869 | 20241121082017_XHAIW | US004C | 2024-11-22T14:04:19.617Z | 2024-11-23T14:21:23.832Z |
5566852 | 5566852 | 20241121081553_d8K7S | US004C | 2024-11-22T14:04:17.519Z | 2024-11-23T14:21:23.828Z |
5566832 | 5566832 | 20241121080837_jgQvz | US004C | 2024-11-22T14:04:13.269Z | 2024-11-23T14:21:23.821Z |
5566780 | 5566780 | 20241121074615_Qy9OB | US004C | 2024-11-22T14:03:57.804Z | 2024-11-23T14:21:23.803Z |
5566755 | 5566755 | 20241121074020_Ncbk2 | US004C | 2024-11-22T14:03:51.768Z | 2024-11-23T14:21:23.796Z |
5566676 | 5566676 | 20241121071506_3tv2U | US004C | 2024-11-22T14:03:36.995Z | 2024-11-23T14:21:23.773Z |
5566665 | 5566665 | 20241121071257_H3uWe | US004C | 2024-11-22T14:03:35.500Z | 2024-11-23T14:21:23.770Z |
5566647 | 5566647 | 20241121071031_xLeku | US004C | 2024-11-22T14:03:33.073Z | 2024-11-23T14:21:23.766Z |
5566639 | 5566639 | 20241121070842_m8JsW | US004C | 2024-11-22T14:03:31.631Z | 2024-11-23T14:21:23.764Z |
5566583 | 5566583 | 20241121065304_ROuGj | US004C | 2024-11-22T14:03:15.209Z | 2024-11-23T14:21:23.748Z |
5566572 | 5566572 | 20241121064700_LK691 | US004C | 2024-11-22T14:03:12.510Z | 2024-11-23T14:21:23.745Z |
5566469 | 5566469 | 20241121061709_iKczL | US004C | 2024-11-22T14:02:57.498Z | 2024-11-23T14:21:23.710Z |
5566187 | 5566187 | 20241121054414_ojiFj | US004C | 2024-11-22T14:02:09.818Z | 2024-11-23T14:21:23.647Z |
5566176 | 5566176 | 20241121054344_gdLH7 | US004C | 2024-11-22T14:02:07.286Z | 2024-11-23T14:21:23.644Z |
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);