participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,671 rows where station_code = "FR000Y" 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 |
---|---|---|---|---|---|
5571738 | 5571738 | 20241121003842_K4xyA | FR000Y | 2024-11-22T14:17:36.705Z | 2024-11-22T14:19:22.183Z |
5571230 | 5571230 | 20241120230451_6Pw1Q | FR000Y | 2024-11-22T14:16:40.323Z | 2024-11-22T14:19:22.073Z |
5569938 | 5569938 | 20241120180145_beZcE | FR000Y | 2024-11-22T14:14:38.393Z | 2024-11-22T14:19:21.832Z |
5565484 | 5565484 | 20241120043038_YZJh7 | FR000Y | 2024-11-21T14:18:50.817Z | 2024-11-22T14:21:47.653Z |
5565419 | 5565419 | 20241120042413_vwDIk | FR000Y | 2024-11-21T14:18:48.468Z | 2024-11-22T14:21:46.589Z |
5565284 | 5565284 | 20241120041316_C3K1z | FR000Y | 2024-11-21T14:18:44.929Z | 2024-11-22T14:21:45.521Z |
5565282 | 5565282 | 20241120041308_HVGJD | FR000Y | 2024-11-21T14:18:44.835Z | 2024-11-22T14:21:45.493Z |
5565163 | 5565163 | 20241120035815_42Tfz | FR000Y | 2024-11-21T14:18:34.606Z | 2024-11-22T14:21:42.773Z |
5565029 | 5565029 | 20241120034527_h9v7c | FR000Y | 2024-11-21T14:18:22.411Z | 2024-11-22T14:21:40.464Z |
5565007 | 5565007 | 20241120034424_49SUs | FR000Y | 2024-11-21T14:18:19.115Z | 2024-11-22T14:21:40.240Z |
5564800 | 5564800 | 20241120032758_BcIru | FR000Y | 2024-11-21T14:18:05.065Z | 2024-11-22T14:21:36.686Z |
5564690 | 5564690 | 20241120032059_rmr0r | FR000Y | 2024-11-21T14:17:58.521Z | 2024-11-22T14:21:35.557Z |
5558084 | 5558084 | 20241120053610_Jeqhl | FR000Y | 2024-11-21T14:02:29.290Z | 2024-11-22T14:19:21.176Z |
5558028 | 5558028 | 20241120053219_MGl6t | FR000Y | 2024-11-21T14:02:20.582Z | 2024-11-22T14:19:21.166Z |
5557792 | 5557792 | 20241120051146_TvLvn | FR000Y | 2024-11-21T14:01:45.676Z | 2024-11-22T14:19:21.129Z |
5557678 | 5557678 | 20241120050449_80iPZ | FR000Y | 2024-11-21T14:01:29.693Z | 2024-11-22T14:19:21.110Z |
5527912 | 5527912 | 20241111185907_tpR3t | FR000Y | 2024-11-13T14:09:32.734Z | 2024-11-20T14:25:22.934Z |
5527542 | 5527542 | 20241111173154_oXMKZ | FR000Y | 2024-11-13T14:08:37.373Z | 2024-11-20T14:25:13.277Z |
5524103 | 5524103 | 20241111031418_OawSX | FR000Y | 2024-11-12T14:16:32.784Z | 2024-11-19T14:22:17.235Z |
5502456 | 5502456 | 20241107183623_JyTpB | FR000Y | 2024-11-09T14:11:23.827Z | 2024-11-16T14:27:55.979Z |
5478695 | 5478695 | 20241104051010_kwlNR | FR000Y | 2024-11-05T14:18:42.427Z | 2024-11-12T14:28:16.566Z |
5478612 | 5478612 | 20241104044307_b73tC | FR000Y | 2024-11-05T14:18:34.262Z | 2024-11-12T14:28:16.393Z |
5478530 | 5478530 | 20241104042608_hjMYG | FR000Y | 2024-11-05T14:18:28.517Z | 2024-11-12T14:28:15.832Z |
5478503 | 5478503 | 20241104041954_vfA6x | FR000Y | 2024-11-05T14:18:26.287Z | 2024-11-12T14:28:15.737Z |
5478454 | 5478454 | 20241104041406_QKcS8 | FR000Y | 2024-11-05T14:18:23.832Z | 2024-11-12T14:28:15.476Z |
5478438 | 5478438 | 20241104041121_A3uH9 | FR000Y | 2024-11-05T14:18:22.731Z | 2024-11-12T14:28:15.403Z |
5478281 | 5478281 | 20241104034548_ZwmTS | FR000Y | 2024-11-05T14:18:09.133Z | 2024-11-12T14:28:14.793Z |
5478271 | 5478271 | 20241104034448_hVsvc | FR000Y | 2024-11-05T14:18:08.182Z | 2024-11-12T14:28:14.772Z |
5478010 | 5478010 | 20241104030654_08ruG | FR000Y | 2024-11-05T14:17:44.663Z | 2024-11-12T14:28:13.842Z |
5477997 | 5477997 | 20241104030544_QD03g | FR000Y | 2024-11-05T14:17:43.431Z | 2024-11-12T14:28:13.755Z |
5477909 | 5477909 | 20241104025253_rffw4 | FR000Y | 2024-11-05T14:17:35.859Z | 2024-11-12T14:28:13.214Z |
5477907 | 5477907 | 20241104025220_p3mAq | FR000Y | 2024-11-05T14:17:35.748Z | 2024-11-12T14:28:13.212Z |
5477883 | 5477883 | 20241104025109_vNGa9 | FR000Y | 2024-11-05T14:17:34.060Z | 2024-11-12T14:28:13.144Z |
5477818 | 5477818 | 20241104024043_wMIoO | FR000Y | 2024-11-05T14:17:28.111Z | 2024-11-12T14:28:13.033Z |
5477770 | 5477770 | 20241104023325_7H8Nz | FR000Y | 2024-11-05T14:17:23.854Z | 2024-11-12T14:28:12.870Z |
5477763 | 5477763 | 20241104023255_28732 | FR000Y | 2024-11-05T14:17:23.379Z | 2024-11-12T14:28:12.828Z |
5477744 | 5477744 | 20241104023117_GS6w3 | FR000Y | 2024-11-05T14:17:21.506Z | 2024-11-12T14:28:12.577Z |
5477720 | 5477720 | 20241104022643_5PGnk | FR000Y | 2024-11-05T14:17:19.280Z | 2024-11-12T14:28:12.529Z |
5477678 | 5477678 | 20241104021939_q4xuc | FR000Y | 2024-11-05T14:17:14.310Z | 2024-11-12T14:28:12.397Z |
5477619 | 5477619 | 20241104021335_Jcc3p | FR000Y | 2024-11-05T14:17:09.609Z | 2024-11-12T14:28:12.159Z |
5477616 | 5477616 | 20241104021333_DvCWC | FR000Y | 2024-11-05T14:17:09.473Z | 2024-11-12T14:28:12.150Z |
5477503 | 5477503 | 20241104020404_pPyKO | FR000Y | 2024-11-05T14:16:59.037Z | 2024-11-12T14:28:11.878Z |
5477113 | 5477113 | 20241104010247_pgEU3 | FR000Y | 2024-11-05T14:16:23.876Z | 2024-11-12T14:28:09.717Z |
5477079 | 5477079 | 20241104005817_kQl1T | FR000Y | 2024-11-05T14:16:20.935Z | 2024-11-12T14:28:08.524Z |
5477017 | 5477017 | 20241104005250_ywSp1 | FR000Y | 2024-11-05T14:16:17.664Z | 2024-11-12T14:28:08.277Z |
5476855 | 5476855 | 20241104003547_nLO93 | FR000Y | 2024-11-05T14:16:08.018Z | 2024-11-12T14:28:07.733Z |
5476718 | 5476718 | 20241104001013_3KqMw | FR000Y | 2024-11-05T14:15:58.887Z | 2024-11-12T14:28:06.979Z |
5476688 | 5476688 | 20241104000806_ILjeR | FR000Y | 2024-11-05T14:15:53.439Z | 2024-11-12T14:28:06.875Z |
5476671 | 5476671 | 20241104000623_sqAUz | FR000Y | 2024-11-05T14:15:50.531Z | 2024-11-12T14:28:06.771Z |
5476533 | 5476533 | 20241103233959_2lZq9 | FR000Y | 2024-11-05T14:15:35.053Z | 2024-11-12T14:28:06.425Z |
5476427 | 5476427 | 20241103232502_2JO4C | FR000Y | 2024-11-05T14:15:20.357Z | 2024-11-12T14:28:06.008Z |
5476310 | 5476310 | 20241103230442_5CZS6 | FR000Y | 2024-11-05T14:15:02.729Z | 2024-11-12T14:28:05.294Z |
5476132 | 5476132 | 20241103223111_RYCfv | FR000Y | 2024-11-05T14:14:47.119Z | 2024-11-12T14:28:03.312Z |
5475921 | 5475921 | 20241103215121_3syEp | FR000Y | 2024-11-05T14:14:33.519Z | 2024-11-12T14:28:01.809Z |
5475881 | 5475881 | 20241103214440_a4sBD | FR000Y | 2024-11-05T14:14:29.232Z | 2024-11-12T14:28:01.728Z |
5475852 | 5475852 | 20241103213944_v82BR | FR000Y | 2024-11-05T14:14:22.551Z | 2024-11-12T14:28:01.427Z |
5475723 | 5475723 | 20241103210924_LYnOS | FR000Y | 2024-11-05T14:14:03.441Z | 2024-11-12T14:28:00.732Z |
5475690 | 5475690 | 20241103210236_yPx18 | FR000Y | 2024-11-05T14:14:01.172Z | 2024-11-12T14:28:00.506Z |
5475238 | 5475238 | 20241103193348_8fuuX | FR000Y | 2024-11-05T14:12:50.269Z | 2024-11-12T14:27:57.678Z |
5475029 | 5475029 | 20241103185239_VO73M | FR000Y | 2024-11-05T14:12:25.898Z | 2024-11-12T14:27:56.501Z |
5475010 | 5475010 | 20241103184913_bVxV8 | FR000Y | 2024-11-05T14:12:24.257Z | 2024-11-12T14:27:56.115Z |
5474683 | 5474683 | 20241103175843_jAeM3 | FR000Y | 2024-11-05T14:11:34.337Z | 2024-11-12T14:27:53.873Z |
5474625 | 5474625 | 20241103174946_391us | FR000Y | 2024-11-05T14:11:24.764Z | 2024-11-12T14:27:53.543Z |
5454779 | 5454779 | 20241031051341_2Pdb2 | FR000Y | 2024-11-02T12:23:22.520Z | 2024-11-08T14:23:25.625Z |
5454539 | 5454539 | 20241031043631_NJ2PZ | FR000Y | 2024-11-02T12:23:10.930Z | 2024-11-08T14:23:23.755Z |
5454507 | 5454507 | 20241031043120_CJSo7 | FR000Y | 2024-11-02T12:23:08.949Z | 2024-11-08T14:23:23.432Z |
5454483 | 5454483 | 20241031042817_nn7rW | FR000Y | 2024-11-02T12:23:07.212Z | 2024-11-08T14:23:23.152Z |
5454478 | 5454478 | 20241031042752_42xBI | FR000Y | 2024-11-02T12:23:07.137Z | 2024-11-08T14:23:23.136Z |
5454457 | 5454457 | 20241031042520_CQq2h | FR000Y | 2024-11-02T12:23:06.480Z | 2024-11-08T14:23:23.068Z |
5454267 | 5454267 | 20241031040415_qXBCD | FR000Y | 2024-11-02T12:22:57.287Z | 2024-11-08T14:23:21.766Z |
5454175 | 5454175 | 20241031035052_Ai2U1 | FR000Y | 2024-11-02T12:22:53.452Z | 2024-11-08T14:23:20.967Z |
5454173 | 5454173 | 20241031035044_IZsBA | FR000Y | 2024-11-02T12:22:53.308Z | 2024-11-08T14:23:20.888Z |
5454120 | 5454120 | 20241031034419_KMgGK | FR000Y | 2024-11-02T12:22:51.437Z | 2024-11-08T14:23:20.624Z |
5454060 | 5454060 | 20241031033716_pL4QT | FR000Y | 2024-11-02T12:22:49.817Z | 2024-11-08T14:23:20.226Z |
5453891 | 5453891 | 20241031031256_RL5co | FR000Y | 2024-11-02T12:22:44.364Z | 2024-11-08T14:23:19.623Z |
5453868 | 5453868 | 20241031031047_DJdkA | FR000Y | 2024-11-02T12:22:43.927Z | 2024-11-08T14:23:19.596Z |
5453864 | 5453864 | 20241031031022_Xl7fs | FR000Y | 2024-11-02T12:22:43.907Z | 2024-11-08T14:23:19.595Z |
5453786 | 5453786 | 20241031025916_WxV03 | FR000Y | 2024-11-02T12:22:42.594Z | 2024-11-08T14:23:19.052Z |
5453740 | 5453740 | 20241031025414_4xVSW | FR000Y | 2024-11-02T12:22:41.511Z | 2024-11-08T14:23:18.961Z |
5453664 | 5453664 | 20241031024030_jfaeV | FR000Y | 2024-11-02T12:22:39.107Z | 2024-11-08T14:23:18.398Z |
5453545 | 5453545 | 20241031022201_S2hxf | FR000Y | 2024-11-02T12:22:35.742Z | 2024-11-08T14:23:18.030Z |
5453516 | 5453516 | 20241031021752_RlgPH | FR000Y | 2024-11-02T12:22:34.987Z | 2024-11-08T14:23:17.648Z |
5453471 | 5453471 | 20241031021454_QtYYM | FR000Y | 2024-11-02T12:22:34.317Z | 2024-11-08T14:23:17.566Z |
5444398 | 5444398 | 20241031011558_VdAKj | FR000Y | 2024-11-01T12:21:15.619Z | 2024-11-08T14:23:15.324Z |
5444217 | 5444217 | 20241031005954_G8bx6 | FR000Y | 2024-11-01T12:21:10.373Z | 2024-11-08T14:23:14.133Z |
5444112 | 5444112 | 20241031004832_3IOHh | FR000Y | 2024-11-01T12:21:06.416Z | 2024-11-08T14:23:13.979Z |
5443748 | 5443748 | 20241031001050_9HbhA | FR000Y | 2024-11-01T12:20:48.400Z | 2024-11-08T14:23:12.134Z |
5443640 | 5443640 | 20241030235809_q619E | FR000Y | 2024-11-01T12:20:43.369Z | 2024-11-08T14:23:11.841Z |
5440895 | 5440895 | 20241030231947_ZstDw | FR000Y | 2024-11-01T12:15:58.042Z | 2024-11-08T14:23:10.904Z |
5440818 | 5440818 | 20241030231053_9Z3Qj | FR000Y | 2024-11-01T12:15:52.747Z | 2024-11-08T14:23:10.766Z |
5440676 | 5440676 | 20241030224553_rLfSo | FR000Y | 2024-11-01T12:15:43.514Z | 2024-11-08T14:23:10.314Z |
5440624 | 5440624 | 20241030223639_MGJdv | FR000Y | 2024-11-01T12:15:39.841Z | 2024-11-08T14:23:10.078Z |
5440518 | 5440518 | 20241030222247_Yf3y5 | FR000Y | 2024-11-01T12:15:34.351Z | 2024-11-08T14:23:09.787Z |
5440516 | 5440516 | 20241030222227_aIyUw | FR000Y | 2024-11-01T12:15:34.174Z | 2024-11-08T14:23:09.774Z |
5440424 | 5440424 | 20241030220951_YxfFl | FR000Y | 2024-11-01T12:15:30.037Z | 2024-11-08T14:23:09.412Z |
5440380 | 5440380 | 20241030220452_fiNFy | FR000Y | 2024-11-01T12:15:27.825Z | 2024-11-08T14:23:09.289Z |
5440374 | 5440374 | 20241030220348_xoUwX | FR000Y | 2024-11-01T12:15:27.367Z | 2024-11-08T14:23:09.232Z |
5440227 | 5440227 | 20241030214445_PwJEJ | FR000Y | 2024-11-01T12:15:02.314Z | 2024-11-08T14:23:08.055Z |
5440150 | 5440150 | 20241030213034_CYD6Z | FR000Y | 2024-11-01T12:14:54.314Z | 2024-11-08T14:23:07.602Z |
5440032 | 5440032 | 20241030211348_0amnl | FR000Y | 2024-11-01T12:14:46.101Z | 2024-11-08T14:23:07.062Z |
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);