participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,155 rows where station_code = "USL01E" 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 |
---|---|---|---|---|---|
5497876 | 5497876 | 20241107054036_HhxDT | USL01E | 2024-11-08T14:14:28.552Z | 2024-11-08T14:14:35.441Z |
5497843 | 5497843 | 20241107053250_3ZU3C | USL01E | 2024-11-08T14:14:26.544Z | 2024-11-08T14:14:35.434Z |
5497829 | 5497829 | 20241107052351_fmiuH | USL01E | 2024-11-08T14:14:25.389Z | 2024-11-08T14:14:35.431Z |
5497815 | 5497815 | 20241107051926_8sv0I | USL01E | 2024-11-08T14:14:23.810Z | 2024-11-08T14:14:35.429Z |
5497811 | 5497811 | 20241107051859_OwCHu | USL01E | 2024-11-08T14:14:23.410Z | 2024-11-08T14:14:35.428Z |
5497768 | 5497768 | 20241107050133_2nBGX | USL01E | 2024-11-08T14:14:19.482Z | 2024-11-08T14:14:35.419Z |
5497756 | 5497756 | 20241107050045_3j2rk | USL01E | 2024-11-08T14:14:18.422Z | 2024-11-08T14:14:35.417Z |
5497743 | 5497743 | 20241107045154_1iOln | USL01E | 2024-11-08T14:14:17.410Z | 2024-11-08T14:14:35.414Z |
5497730 | 5497730 | 20241107044450_FZAz4 | USL01E | 2024-11-08T14:14:16.581Z | 2024-11-08T14:14:35.411Z |
5497714 | 5497714 | 20241107044206_P2le2 | USL01E | 2024-11-08T14:14:15.417Z | 2024-11-08T14:14:35.407Z |
5497712 | 5497712 | 20241107044139_bbFLq | USL01E | 2024-11-08T14:14:15.353Z | 2024-11-08T14:14:35.407Z |
5497706 | 5497706 | 20241107043904_iDO83 | USL01E | 2024-11-08T14:14:14.931Z | 2024-11-08T14:14:35.405Z |
5497685 | 5497685 | 20241107042817_zQtGj | USL01E | 2024-11-08T14:14:10.967Z | 2024-11-08T14:14:35.400Z |
5497670 | 5497670 | 20241107042202_OHwxb | USL01E | 2024-11-08T14:14:09.695Z | 2024-11-08T14:14:35.397Z |
5497654 | 5497654 | 20241107041931_rzeho | USL01E | 2024-11-08T14:14:08.431Z | 2024-11-08T14:14:35.393Z |
5497638 | 5497638 | 20241107041650_9JvoA | USL01E | 2024-11-08T14:14:07.081Z | 2024-11-08T14:14:35.389Z |
5497180 | 5497180 | 20241107025343_lOJ4g | USL01E | 2024-11-08T14:13:19.138Z | 2024-11-08T14:14:35.276Z |
5496906 | 5496906 | 20241107020827_mcbTP | USL01E | 2024-11-08T14:12:58.250Z | 2024-11-08T14:14:35.211Z |
5492409 | 5492409 | 20241107082959_Ih3ZR | USL01E | 2024-11-08T14:01:00.984Z | 2024-11-08T14:01:00.984Z |
5492379 | 5492379 | 20241107082008_22tM2 | USL01E | 2024-11-08T14:00:54.585Z | 2024-11-08T14:00:54.585Z |
5492326 | 5492326 | 20241107080829_V6SwY | USL01E | 2024-11-08T14:00:46.908Z | 2024-11-08T14:00:46.908Z |
5492320 | 5492320 | 20241107080759_eJ3BY | USL01E | 2024-11-08T14:00:46.459Z | 2024-11-08T14:00:46.459Z |
5492312 | 5492312 | 20241107080629_v7p2l | USL01E | 2024-11-08T14:00:45.260Z | 2024-11-08T14:00:45.260Z |
5492295 | 5492295 | 20241107080221_Xe23i | USL01E | 2024-11-08T14:00:43.352Z | 2024-11-08T14:00:43.352Z |
5492285 | 5492285 | 20241107075515_7TMw4 | USL01E | 2024-11-08T14:00:41.943Z | 2024-11-08T14:00:41.943Z |
5492279 | 5492279 | 20241107075304_mnuDm | USL01E | 2024-11-08T14:00:41.045Z | 2024-11-08T14:00:41.045Z |
5492270 | 5492270 | 20241107075248_FnLN1 | USL01E | 2024-11-08T14:00:40.426Z | 2024-11-08T14:00:40.426Z |
5492258 | 5492258 | 20241107074720_JDlbR | USL01E | 2024-11-08T14:00:39.066Z | 2024-11-08T14:00:39.066Z |
5492220 | 5492220 | 20241107073335_C9o7C | USL01E | 2024-11-08T14:00:33.416Z | 2024-11-08T14:00:33.416Z |
5492202 | 5492202 | 20241107072638_SCQZI | USL01E | 2024-11-08T14:00:27.974Z | 2024-11-08T14:00:27.974Z |
5492195 | 5492195 | 20241107072513_BoK6z | USL01E | 2024-11-08T14:00:26.515Z | 2024-11-08T14:00:26.515Z |
5492169 | 5492169 | 20241107071830_PhUO2 | USL01E | 2024-11-08T14:00:22.490Z | 2024-11-08T14:00:22.490Z |
5492096 | 5492096 | 20241107063252_siafN | USL01E | 2024-11-08T14:00:09.890Z | 2024-11-08T14:00:09.890Z |
5470295 | 5470295 | 20241031064655_SMssT | USL01E | 2024-11-04T14:25:36.755Z | 2024-11-08T14:23:27.761Z |
5470254 | 5470254 | 20241031090421_M8SG2 | USL01E | 2024-11-04T14:21:55.993Z | 2024-11-08T14:22:04.037Z |
5470250 | 5470250 | 20241031071628_zg26G | USL01E | 2024-11-04T14:21:38.256Z | 2024-11-08T14:21:59.409Z |
5463896 | 5463896 | 20241102060450_sUMFZ | USL01E | 2024-11-03T14:19:22.896Z | 2024-11-08T14:21:55.314Z |
5463873 | 5463873 | 20241102055614_tn1I3 | USL01E | 2024-11-03T14:19:21.593Z | 2024-11-08T14:21:55.278Z |
5463855 | 5463855 | 20241102054404_FNIZF | USL01E | 2024-11-03T14:19:20.938Z | 2024-11-08T14:21:55.174Z |
5463775 | 5463775 | 20241102050235_fDn9Y | USL01E | 2024-11-03T14:19:16.363Z | 2024-11-08T14:21:54.888Z |
5463624 | 5463624 | 20241102042047_Py6E3 | USL01E | 2024-11-03T14:19:03.869Z | 2024-11-08T14:21:54.050Z |
5463452 | 5463452 | 20241102034040_yM8zP | USL01E | 2024-11-03T14:18:46.357Z | 2024-11-08T14:21:53.016Z |
5463034 | 5463034 | 20241102021820_eKiUZ | USL01E | 2024-11-03T14:18:15.476Z | 2024-11-08T14:21:51.007Z |
5463021 | 5463021 | 20241102021605_fY254 | USL01E | 2024-11-03T14:18:14.745Z | 2024-11-08T14:21:50.951Z |
5463000 | 5463000 | 20241102021334_qslYB | USL01E | 2024-11-03T14:18:13.863Z | 2024-11-08T14:21:50.657Z |
5462908 | 5462908 | 20241102015550_8ZKLh | USL01E | 2024-11-03T14:18:09.526Z | 2024-11-08T14:21:50.141Z |
5456887 | 5456887 | 20241102124320_0Vuv2 | USL01E | 2024-11-03T14:05:53.125Z | 2024-11-08T14:20:35.834Z |
5456859 | 5456859 | 20241102124236_2oJv7 | USL01E | 2024-11-03T14:05:50.473Z | 2024-11-08T14:20:35.654Z |
5456759 | 5456759 | 20241102121647_hqOAG | USL01E | 2024-11-03T14:05:37.947Z | 2024-11-08T14:20:33.428Z |
5456725 | 5456725 | 20241102121022_5J3iV | USL01E | 2024-11-03T14:05:33.567Z | 2024-11-08T14:20:33.143Z |
5456706 | 5456706 | 20241102120705_okMKo | USL01E | 2024-11-03T14:05:31.085Z | 2024-11-08T14:20:33.002Z |
5456638 | 5456638 | 20241102115715_V13Wg | USL01E | 2024-11-03T14:05:10.780Z | 2024-11-08T14:20:32.295Z |
5456627 | 5456627 | 20241102115350_ZnSUF | USL01E | 2024-11-03T14:05:09.557Z | 2024-11-08T14:20:32.228Z |
5456619 | 5456619 | 20241102115206_EX1gw | USL01E | 2024-11-03T14:05:08.749Z | 2024-11-08T14:20:32.205Z |
5456578 | 5456578 | 20241102114619_RidGe | USL01E | 2024-11-03T14:05:01.557Z | 2024-11-08T14:20:31.697Z |
5456472 | 5456472 | 20241102112947_dpkCi | USL01E | 2024-11-03T14:04:46.439Z | 2024-11-08T14:20:30.996Z |
5456456 | 5456456 | 20241102112516_qJEdh | USL01E | 2024-11-03T14:04:41.348Z | 2024-11-08T14:20:30.941Z |
5456428 | 5456428 | 20241102111954_FU54Y | USL01E | 2024-11-03T14:04:32.051Z | 2024-11-08T14:20:30.520Z |
5456418 | 5456418 | 20241102111656_JlFwC | USL01E | 2024-11-03T14:04:30.358Z | 2024-11-08T14:20:30.380Z |
5456403 | 5456403 | 20241102111503_LgpNx | USL01E | 2024-11-03T14:04:26.041Z | 2024-11-08T14:20:30.082Z |
5456324 | 5456324 | 20241102105929_IQ3nk | USL01E | 2024-11-03T14:04:12.393Z | 2024-11-08T14:20:28.826Z |
5456316 | 5456316 | 20241102105718_pV333 | USL01E | 2024-11-03T14:04:11.532Z | 2024-11-08T14:20:28.798Z |
5456288 | 5456288 | 20241102105351_Joes2 | USL01E | 2024-11-03T14:04:06.453Z | 2024-11-08T14:20:28.533Z |
5456279 | 5456279 | 20241102105236_P2hte | USL01E | 2024-11-03T14:04:05.279Z | 2024-11-08T14:20:28.511Z |
5456248 | 5456248 | 20241102104707_pvBlY | USL01E | 2024-11-03T14:03:53.666Z | 2024-11-08T14:20:28.273Z |
5456217 | 5456217 | 20241102104350_K2JQL | USL01E | 2024-11-03T14:03:49.756Z | 2024-11-08T14:20:27.865Z |
5456187 | 5456187 | 20241102103743_XWo3i | USL01E | 2024-11-03T14:03:44.523Z | 2024-11-08T14:20:27.678Z |
5456179 | 5456179 | 20241102103455_kRP8Z | USL01E | 2024-11-03T14:03:42.910Z | 2024-11-08T14:20:27.477Z |
5456175 | 5456175 | 20241102103441_f2ahm | USL01E | 2024-11-03T14:03:40.832Z | 2024-11-08T14:20:27.325Z |
5456132 | 5456132 | 20241102102739_RFoYX | USL01E | 2024-11-03T14:03:26.253Z | 2024-11-08T14:20:26.898Z |
5456125 | 5456125 | 20241102102657_L6BCr | USL01E | 2024-11-03T14:03:24.839Z | 2024-11-08T14:20:26.884Z |
5456115 | 5456115 | 20241102102332_DBZPQ | USL01E | 2024-11-03T14:03:22.541Z | 2024-11-08T14:20:26.830Z |
5456059 | 5456059 | 20241102101541_ZE0vy | USL01E | 2024-11-03T14:03:13.706Z | 2024-11-08T14:20:26.526Z |
5456011 | 5456011 | 20241102100656_w0NcZ | USL01E | 2024-11-03T14:03:06.371Z | 2024-11-08T14:20:26.217Z |
5455981 | 5455981 | 20241102095809_nnhNR | USL01E | 2024-11-03T14:03:01.261Z | 2024-11-08T14:20:25.893Z |
5455975 | 5455975 | 20241102095641_3eksi | USL01E | 2024-11-03T14:03:00.511Z | 2024-11-08T14:20:25.875Z |
5455967 | 5455967 | 20241102095322_QiN3c | USL01E | 2024-11-03T14:02:59.474Z | 2024-11-08T14:20:25.833Z |
5455954 | 5455954 | 20241102095042_E6HBC | USL01E | 2024-11-03T14:02:57.758Z | 2024-11-08T14:20:25.753Z |
5455945 | 5455945 | 20241102094917_Gl8kH | USL01E | 2024-11-03T14:02:53.504Z | 2024-11-08T14:20:25.649Z |
5455930 | 5455930 | 20241102094744_TmUSh | USL01E | 2024-11-03T14:02:47.568Z | 2024-11-08T14:20:25.542Z |
5455928 | 5455928 | 20241102094733_2QPfP | USL01E | 2024-11-03T14:02:46.437Z | 2024-11-08T14:20:25.531Z |
5455835 | 5455835 | 20241102092723_1MO54 | USL01E | 2024-11-03T14:02:27.006Z | 2024-11-08T14:20:24.337Z |
5455823 | 5455823 | 20241102092400_lB0Wk | USL01E | 2024-11-03T14:02:24.946Z | 2024-11-08T14:20:24.209Z |
5455813 | 5455813 | 20241102092217_mTt0u | USL01E | 2024-11-03T14:02:23.637Z | 2024-11-08T14:20:24.083Z |
5455771 | 5455771 | 20241102091407_V8rt4 | USL01E | 2024-11-03T14:02:16.225Z | 2024-11-08T14:20:23.786Z |
5455742 | 5455742 | 20241102090842_cpOVQ | USL01E | 2024-11-03T14:02:08.390Z | 2024-11-08T14:20:23.380Z |
5455727 | 5455727 | 20241102090518_jLHnm | USL01E | 2024-11-03T14:02:04.913Z | 2024-11-08T14:20:23.298Z |
5455721 | 5455721 | 20241102090446_tJ0BR | USL01E | 2024-11-03T14:02:03.705Z | 2024-11-08T14:20:23.270Z |
5455676 | 5455676 | 20241102085518_Dy2Gv | USL01E | 2024-11-03T14:01:51.816Z | 2024-11-08T14:20:22.973Z |
5455641 | 5455641 | 20241102084900_yTSl8 | USL01E | 2024-11-03T14:01:46.031Z | 2024-11-08T14:20:22.753Z |
5455611 | 5455611 | 20241102084308_Ouk3o | USL01E | 2024-11-03T14:01:40.412Z | 2024-11-08T14:20:22.560Z |
5455597 | 5455597 | 20241102084032_miihw | USL01E | 2024-11-03T14:01:37.427Z | 2024-11-08T14:20:22.443Z |
5455589 | 5455589 | 20241102083656_FeGJ5 | USL01E | 2024-11-03T14:01:35.450Z | 2024-11-08T14:20:22.392Z |
5455540 | 5455540 | 20241102082154_llww3 | USL01E | 2024-11-03T14:01:16.361Z | 2024-11-08T14:20:21.802Z |
5455517 | 5455517 | 20241102081551_XLhGk | USL01E | 2024-11-03T14:01:09.259Z | 2024-11-08T14:20:21.599Z |
5455486 | 5455486 | 20241102080717_hZ2KX | USL01E | 2024-11-03T14:01:04.391Z | 2024-11-08T14:20:21.269Z |
5455450 | 5455450 | 20241102074930_QjSJ8 | USL01E | 2024-11-03T14:00:57.566Z | 2024-11-08T14:20:20.862Z |
5455404 | 5455404 | 20241102074004_YsL6f | USL01E | 2024-11-03T14:00:50.839Z | 2024-11-08T14:20:20.589Z |
5455376 | 5455376 | 20241102073320_eCAjL | USL01E | 2024-11-03T14:00:44.071Z | 2024-11-08T14:20:20.442Z |
5455359 | 5455359 | 20241102072731_6GhT9 | USL01E | 2024-11-03T14:00:41.046Z | 2024-11-08T14:20:20.329Z |
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);