participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "US000D" 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 |
---|---|---|---|---|---|
5505585 | 5505585 | 20241108061744_QXdu4 | US000D | 2024-11-09T14:16:24.346Z | 2024-11-09T14:16:28.821Z |
5505528 | 5505528 | 20241108055620_ANTzy | US000D | 2024-11-09T14:16:22.166Z | 2024-11-09T14:16:28.808Z |
5505294 | 5505294 | 20241108042800_LpB9K | US000D | 2024-11-09T14:16:05.965Z | 2024-11-09T14:16:28.747Z |
5499215 | 5499215 | 20241108113545_UhLxi | US000D | 2024-11-09T14:03:33.356Z | 2024-11-09T14:03:33.356Z |
5499172 | 5499172 | 20241108112251_qQktc | US000D | 2024-11-09T14:03:28.774Z | 2024-11-09T14:03:28.774Z |
5499159 | 5499159 | 20241108112032_KA70t | US000D | 2024-11-09T14:03:26.979Z | 2024-11-09T14:03:26.979Z |
5498248 | 5498248 | 20241108074245_z7qIF | US000D | 2024-11-09T14:00:57.141Z | 2024-11-09T14:00:57.141Z |
5498097 | 5498097 | 20241108064928_9DQ64 | US000D | 2024-11-09T14:00:28.469Z | 2024-11-09T14:00:28.469Z |
5485720 | 5485720 | 20241106065614_5bVRf | US000D | 2024-11-07T14:00:23.484Z | 2024-11-09T14:16:31.065Z |
5485565 | 5485565 | 20241105063708_Ntm3Y | US000D | 2024-11-06T14:18:30.076Z | 2024-11-09T14:21:23.022Z |
5479481 | 5479481 | 20241105093800_PakfF | US000D | 2024-11-06T14:02:23.557Z | 2024-11-09T14:19:06.802Z |
5479100 | 5479100 | 20241105080512_WTzXz | US000D | 2024-11-06T14:01:00.451Z | 2024-11-09T14:18:59.473Z |
5479081 | 5479081 | 20241105075824_5nyc1 | US000D | 2024-11-06T14:00:56.905Z | 2024-11-09T14:18:59.321Z |
5479051 | 5479051 | 20241105074054_FruZh | US000D | 2024-11-06T14:00:49.087Z | 2024-11-09T14:18:59.017Z |
5478997 | 5478997 | 20241105072235_mXQB7 | US000D | 2024-11-06T14:00:36.464Z | 2024-11-09T14:18:57.778Z |
5478975 | 5478975 | 20241105071844_6z01m | US000D | 2024-11-06T14:00:31.473Z | 2024-11-09T14:18:57.362Z |
5478969 | 5478969 | 20241105071711_BVsIE | US000D | 2024-11-06T14:00:30.635Z | 2024-11-09T14:18:57.275Z |
5478965 | 5478965 | 20241105071608_eYuTS | US000D | 2024-11-06T14:00:29.652Z | 2024-11-09T14:18:57.216Z |
5464279 | 5464279 | 20241101063534_Hm4Hg | US000D | 2024-11-03T14:22:10.631Z | 2024-11-09T14:24:37.655Z |
5463924 | 5463924 | 20241102061318_x9SBj | US000D | 2024-11-03T14:19:25.704Z | 2024-11-09T14:23:44.580Z |
5463788 | 5463788 | 20241102051215_HvuPP | US000D | 2024-11-03T14:19:17.284Z | 2024-11-09T14:23:43.929Z |
5463710 | 5463710 | 20241102044153_zt87q | US000D | 2024-11-03T14:19:11.362Z | 2024-11-09T14:23:43.546Z |
5463677 | 5463677 | 20241102043401_Kbbnz | US000D | 2024-11-03T14:19:09.693Z | 2024-11-09T14:23:43.397Z |
5460026 | 5460026 | 20241101123131_0X2vk | US000D | 2024-11-03T14:13:11.582Z | 2024-11-09T14:23:22.019Z |
5459838 | 5459838 | 20241101115950_xG9He | US000D | 2024-11-03T14:12:39.110Z | 2024-11-09T14:23:21.107Z |
5459761 | 5459761 | 20241101114836_DK35I | US000D | 2024-11-03T14:12:34.333Z | 2024-11-09T14:23:20.609Z |
5459649 | 5459649 | 20241101112937_ERzSN | US000D | 2024-11-03T14:12:24.643Z | 2024-11-09T14:23:20.057Z |
5459633 | 5459633 | 20241101112644_4ioho | US000D | 2024-11-03T14:12:23.459Z | 2024-11-09T14:23:20.050Z |
5459620 | 5459620 | 20241101112452_ixynV | US000D | 2024-11-03T14:12:22.597Z | 2024-11-09T14:23:20.001Z |
5459569 | 5459569 | 20241101111800_Xo6WM | US000D | 2024-11-03T14:12:18.686Z | 2024-11-09T14:23:19.584Z |
5459559 | 5459559 | 20241101111741_uleQp | US000D | 2024-11-03T14:12:17.596Z | 2024-11-09T14:23:19.469Z |
5459543 | 5459543 | 20241101111602_3O8gq | US000D | 2024-11-03T14:12:16.077Z | 2024-11-09T14:23:19.038Z |
5458964 | 5458964 | 20241101095128_74M3f | US000D | 2024-11-03T14:10:52.946Z | 2024-11-09T14:23:15.573Z |
5458842 | 5458842 | 20241101092532_gWN18 | US000D | 2024-11-03T14:10:41.785Z | 2024-11-09T14:23:14.711Z |
5458765 | 5458765 | 20241101091416_yV1Mi | US000D | 2024-11-03T14:10:34.881Z | 2024-11-09T14:23:14.281Z |
5458761 | 5458761 | 20241101091409_jdrxm | US000D | 2024-11-03T14:10:34.601Z | 2024-11-09T14:23:14.280Z |
5458707 | 5458707 | 20241101090518_hijYh | US000D | 2024-11-03T14:10:29.699Z | 2024-11-09T14:23:13.845Z |
5458696 | 5458696 | 20241101090412_fh3Hj | US000D | 2024-11-03T14:10:28.958Z | 2024-11-09T14:23:13.829Z |
5458614 | 5458614 | 20241101084953_rGMN6 | US000D | 2024-11-03T14:10:07.785Z | 2024-11-09T14:23:13.232Z |
5458547 | 5458547 | 20241101084139_w7dA4 | US000D | 2024-11-03T14:09:56.736Z | 2024-11-09T14:23:12.809Z |
5458494 | 5458494 | 20241101083514_V6tWB | US000D | 2024-11-03T14:09:51.337Z | 2024-11-09T14:23:12.602Z |
5458394 | 5458394 | 20241101082122_TgtVh | US000D | 2024-11-03T14:09:42.186Z | 2024-11-09T14:23:11.872Z |
5458360 | 5458360 | 20241101081555_YVkLR | US000D | 2024-11-03T14:09:39.170Z | 2024-11-09T14:23:11.799Z |
5458339 | 5458339 | 20241101081311_61eTd | US000D | 2024-11-03T14:09:37.034Z | 2024-11-09T14:23:11.555Z |
5456386 | 5456386 | 20241102111123_gYvAv | US000D | 2024-11-03T14:04:22.040Z | 2024-11-09T14:22:43.503Z |
5456333 | 5456333 | 20241102110214_O3qxg | US000D | 2024-11-03T14:04:14.987Z | 2024-11-09T14:22:42.952Z |
5456066 | 5456066 | 20241102101620_uXFYo | US000D | 2024-11-03T14:03:15.275Z | 2024-11-09T14:22:41.725Z |
5455984 | 5455984 | 20241102095840_wgfB3 | US000D | 2024-11-03T14:03:02.118Z | 2024-11-09T14:22:41.263Z |
5455969 | 5455969 | 20241102095422_lfFtw | US000D | 2024-11-03T14:03:00.036Z | 2024-11-09T14:22:41.138Z |
5455920 | 5455920 | 20241102094659_VeFVA | US000D | 2024-11-03T14:02:45.173Z | 2024-11-09T14:22:40.825Z |
5455898 | 5455898 | 20241102094107_VbGnw | US000D | 2024-11-03T14:02:38.105Z | 2024-11-09T14:22:40.697Z |
5455765 | 5455765 | 20241102091322_utbCp | US000D | 2024-11-03T14:02:15.850Z | 2024-11-09T14:22:39.350Z |
5455503 | 5455503 | 20241102081354_O0WNW | US000D | 2024-11-03T14:01:07.454Z | 2024-11-09T14:22:36.372Z |
5455495 | 5455495 | 20241102081146_uwTqW | US000D | 2024-11-03T14:01:05.823Z | 2024-11-09T14:22:36.293Z |
5455288 | 5455288 | 20241102071226_CVz1O | US000D | 2024-11-03T14:00:26.983Z | 2024-11-09T14:22:34.195Z |
5455274 | 5455274 | 20241102070746_20dAr | US000D | 2024-11-03T14:00:24.291Z | 2024-11-09T14:22:34.120Z |
5454976 | 5454976 | 20241031055939_ibcpD | US000D | 2024-11-02T12:23:28.398Z | 2024-11-08T14:23:26.545Z |
5454766 | 5454766 | 20241031051030_5424K | US000D | 2024-11-02T12:23:21.396Z | 2024-11-08T14:23:25.549Z |
5454697 | 5454697 | 20241031045607_HKIwS | US000D | 2024-11-02T12:23:17.039Z | 2024-11-08T14:23:24.773Z |
5454576 | 5454576 | 20241031044133_e63N3 | US000D | 2024-11-02T12:23:12.795Z | 2024-11-08T14:23:24.200Z |
5454013 | 5454013 | 20241031033057_uds4a | US000D | 2024-11-02T12:22:47.871Z | 2024-11-08T14:23:19.987Z |
5453011 | 5453011 | 20241101064033_Ed86i | US000D | 2024-11-02T12:19:41.731Z | 2024-11-09T14:24:37.726Z |
5452860 | 5452860 | 20241101050759_2Fek2 | US000D | 2024-11-02T12:19:30.588Z | 2024-11-09T14:24:35.045Z |
5452769 | 5452769 | 20241101042659_OIqfv | US000D | 2024-11-02T12:19:21.030Z | 2024-11-09T14:24:33.582Z |
5452696 | 5452696 | 20241101040955_ENF7K | US000D | 2024-11-02T12:19:14.959Z | 2024-11-09T14:24:32.974Z |
5452457 | 5452457 | 20241101031907_GrOFB | US000D | 2024-11-02T12:18:50.343Z | 2024-11-09T14:24:31.169Z |
5448017 | 5448017 | 20241031123441_D5aVe | US000D | 2024-11-02T12:09:48.377Z | 2024-11-09T14:24:02.504Z |
5447919 | 5447919 | 20241031122236_JIFrc | US000D | 2024-11-02T12:09:25.652Z | 2024-11-09T14:24:01.709Z |
5447889 | 5447889 | 20241031122046_52iWJ | US000D | 2024-11-02T12:09:23.775Z | 2024-11-09T14:24:01.613Z |
5447856 | 5447856 | 20241031121708_Ua2Cb | US000D | 2024-11-02T12:09:18.521Z | 2024-11-09T14:24:01.544Z |
5447720 | 5447720 | 20241031120425_WiOJA | US000D | 2024-11-02T12:08:58.998Z | 2024-11-09T14:24:01.133Z |
5447675 | 5447675 | 20241031120219_Kdumb | US000D | 2024-11-02T12:08:48.364Z | 2024-11-09T14:24:00.795Z |
5447463 | 5447463 | 20241031114411_dSLrU | US000D | 2024-11-02T12:08:14.264Z | 2024-11-09T14:23:59.896Z |
5447449 | 5447449 | 20241031114332_4Nprr | US000D | 2024-11-02T12:08:12.613Z | 2024-11-09T14:23:59.860Z |
5447298 | 5447298 | 20241031112746_r32QH | US000D | 2024-11-02T12:07:43.281Z | 2024-11-09T14:23:58.756Z |
5447291 | 5447291 | 20241031112736_qC2ie | US000D | 2024-11-02T12:07:43.023Z | 2024-11-09T14:23:58.744Z |
5447229 | 5447229 | 20241031112116_N2L5v | US000D | 2024-11-02T12:07:34.200Z | 2024-11-09T14:23:58.428Z |
5447198 | 5447198 | 20241031111729_FSR4h | US000D | 2024-11-02T12:07:28.534Z | 2024-11-09T14:23:58.271Z |
5447179 | 5447179 | 20241031111622_o7BOO | US000D | 2024-11-02T12:07:27.095Z | 2024-11-09T14:23:58.182Z |
5447049 | 5447049 | 20241031110156_k6k2Y | US000D | 2024-11-02T12:07:01.096Z | 2024-11-09T14:23:57.507Z |
5446918 | 5446918 | 20241031104827_Q01Z5 | US000D | 2024-11-02T12:06:42.892Z | 2024-11-09T14:23:57.119Z |
5446835 | 5446835 | 20241031103755_SR5Cd | US000D | 2024-11-02T12:06:27.152Z | 2024-11-09T14:23:56.694Z |
5446688 | 5446688 | 20241031102140_8wv6Z | US000D | 2024-11-02T12:06:02.826Z | 2024-11-09T14:23:55.936Z |
5446375 | 5446375 | 20241031095335_QZvDH | US000D | 2024-11-02T12:05:05.426Z | 2024-11-09T14:23:54.297Z |
5446095 | 5446095 | 20241031092728_tYy7c | US000D | 2024-11-02T12:04:14.409Z | 2024-11-09T14:23:52.922Z |
5445828 | 5445828 | 20241031085256_Qsam1 | US000D | 2024-11-02T12:03:19.562Z | 2024-11-09T14:23:51.508Z |
5445652 | 5445652 | 20241031083137_x1H7E | US000D | 2024-11-02T12:02:45.467Z | 2024-11-09T14:23:51.060Z |
5445594 | 5445594 | 20241031082456_2Nq0M | US000D | 2024-11-02T12:02:30.455Z | 2024-11-09T14:23:50.878Z |
5445586 | 5445586 | 20241031082420_i2EMs | US000D | 2024-11-02T12:02:28.787Z | 2024-11-09T14:23:50.858Z |
5445270 | 5445270 | 20241031072917_IFsxj | US000D | 2024-11-02T12:01:30.068Z | 2024-11-09T14:23:48.721Z |
5445167 | 5445167 | 20241031071229_E3x3F | US000D | 2024-11-02T12:01:13.135Z | 2024-11-09T14:23:48.172Z |
5445091 | 5445091 | 20241031065305_nJqt2 | US000D | 2024-11-02T12:00:54.887Z | 2024-11-09T14:23:47.419Z |
5445039 | 5445039 | 20241101073811_K2z73 | US000D | 2024-11-02T12:00:44.971Z | 2024-11-09T14:23:10.714Z |
5445012 | 5445012 | 20241101072905_kGr2B | US000D | 2024-11-02T12:00:30.643Z | 2024-11-09T14:23:10.181Z |
5445005 | 5445005 | 20241101072556_dG09e | US000D | 2024-11-02T12:00:28.369Z | 2024-11-09T14:23:10.140Z |
5435704 | 5435704 | 20241030115042_mN7h2 | US000D | 2024-11-01T12:05:47.130Z | 2024-11-08T14:22:51.389Z |
5435598 | 5435598 | 20241030114406_gH3jU | US000D | 2024-11-01T12:05:38.308Z | 2024-11-08T14:22:51.269Z |
5435575 | 5435575 | 20241030114251_3NjTK | US000D | 2024-11-01T12:05:35.962Z | 2024-11-08T14:22:51.189Z |
5435297 | 5435297 | 20241030111448_KtcOb | US000D | 2024-11-01T12:04:45.063Z | 2024-11-08T14:22:50.028Z |
5435278 | 5435278 | 20241030111248_CgaIM | US000D | 2024-11-01T12:04:41.421Z | 2024-11-08T14:22:49.903Z |
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);