participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "USL00E" 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 |
---|---|---|---|---|---|
5550837 | 5550837 | 20241118113436_jTFDH | USL00E | 2024-11-19T14:03:11.460Z | 2024-11-22T14:22:06.068Z |
5550667 | 5550667 | 20241118110504_lhLXk | USL00E | 2024-11-19T14:02:53.819Z | 2024-11-22T14:22:04.781Z |
5545306 | 5545306 | 20241116042046_RBGQq | USL00E | 2024-11-17T14:04:25.872Z | 2024-11-22T14:23:39.629Z |
5540211 | 5540211 | 20241114102338_6M2hQ | USL00E | 2024-11-15T14:03:07.930Z | 2024-11-22T14:23:49.563Z |
5456416 | 5456416 | 20241102111656_JlFwC | USL00E | 2024-11-03T14:04:30.339Z | 2024-11-11T14:22:28.814Z |
5443508 | 5443508 | 20241030064634_8BDmn | USL00E | 2024-11-01T12:20:32.914Z | 2024-11-07T14:26:51.848Z |
5443470 | 5443470 | 20241030063332_xXKAT | USL00E | 2024-11-01T12:20:31.400Z | 2024-11-07T14:26:51.768Z |
5443343 | 5443343 | 20241030052613_LAfA7 | USL00E | 2024-11-01T12:20:28.434Z | 2024-11-07T14:26:50.903Z |
5436111 | 5436111 | 20241030123007_fTj4p | USL00E | 2024-11-01T12:06:48.568Z | 2024-11-08T14:22:52.831Z |
5436068 | 5436068 | 20241030122547_MsVoG | USL00E | 2024-11-01T12:06:43.187Z | 2024-11-08T14:22:52.674Z |
5436006 | 5436006 | 20241030122015_S03IA | USL00E | 2024-11-01T12:06:31.980Z | 2024-11-08T14:22:52.428Z |
5435966 | 5435966 | 20241030121550_yCcdB | USL00E | 2024-11-01T12:06:27.596Z | 2024-11-08T14:22:52.303Z |
5435717 | 5435717 | 20241030115225_wxHmY | USL00E | 2024-11-01T12:05:48.206Z | 2024-11-08T14:22:51.412Z |
5435711 | 5435711 | 20241030115112_2Ura7 | USL00E | 2024-11-01T12:05:47.432Z | 2024-11-08T14:22:51.390Z |
5435448 | 5435448 | 20241030113000_DM8gA | USL00E | 2024-11-01T12:05:11.548Z | 2024-11-08T14:22:50.736Z |
5435437 | 5435437 | 20241030112913_mfLga | USL00E | 2024-11-01T12:05:10.301Z | 2024-11-08T14:22:50.678Z |
5435418 | 5435418 | 20241030112706_Ra93G | USL00E | 2024-11-01T12:05:07.572Z | 2024-11-08T14:22:50.510Z |
5435403 | 5435403 | 20241030112608_XWJ8e | USL00E | 2024-11-01T12:05:06.300Z | 2024-11-08T14:22:50.410Z |
5435381 | 5435381 | 20241030112315_3HQfp | USL00E | 2024-11-01T12:05:03.890Z | 2024-11-08T14:22:50.357Z |
5435254 | 5435254 | 20241030110858_NhH8h | USL00E | 2024-11-01T12:04:36.390Z | 2024-11-08T14:22:49.851Z |
5435232 | 5435232 | 20241030110714_e6ZdX | USL00E | 2024-11-01T12:04:34.158Z | 2024-11-08T14:22:49.686Z |
5435228 | 5435228 | 20241030110713_lg9Gt | USL00E | 2024-11-01T12:04:33.764Z | 2024-11-08T14:22:49.685Z |
5434971 | 5434971 | 20241030103121_YYxa9 | USL00E | 2024-11-01T12:03:52.467Z | 2024-11-08T14:22:48.804Z |
5434888 | 5434888 | 20241030102259_14yZW | USL00E | 2024-11-01T12:03:41.354Z | 2024-11-08T14:22:48.249Z |
5434870 | 5434870 | 20241030102210_28NKO | USL00E | 2024-11-01T12:03:39.952Z | 2024-11-08T14:22:48.218Z |
5434860 | 5434860 | 20241030102052_6bUiI | USL00E | 2024-11-01T12:03:38.758Z | 2024-11-08T14:22:48.202Z |
5434710 | 5434710 | 20241030100551_Ekpp3 | USL00E | 2024-11-01T12:03:11.995Z | 2024-11-08T14:22:47.486Z |
5434694 | 5434694 | 20241030100230_HPH2Y | USL00E | 2024-11-01T12:03:09.673Z | 2024-11-08T14:22:47.431Z |
5434671 | 5434671 | 20241030095954_ZCiZY | USL00E | 2024-11-01T12:03:07.066Z | 2024-11-08T14:22:47.417Z |
5434651 | 5434651 | 20241030095502_YyuzX | USL00E | 2024-11-01T12:03:01.585Z | 2024-11-08T14:22:47.378Z |
5434605 | 5434605 | 20241030094833_2EGT0 | USL00E | 2024-11-01T12:02:49.243Z | 2024-11-08T14:22:47.093Z |
5434573 | 5434573 | 20241030094451_3d1VR | USL00E | 2024-11-01T12:02:45.262Z | 2024-11-08T14:22:46.993Z |
5434498 | 5434498 | 20241030093437_I8X3N | USL00E | 2024-11-01T12:02:31.427Z | 2024-11-08T14:22:46.767Z |
5434412 | 5434412 | 20241030091856_uuKzZ | USL00E | 2024-11-01T12:02:15.407Z | 2024-11-08T14:22:46.280Z |
5434362 | 5434362 | 20241030090443_YtZxg | USL00E | 2024-11-01T12:02:04.413Z | 2024-11-08T14:22:46.164Z |
5434205 | 5434205 | 20241030083854_J9Blf | USL00E | 2024-11-01T12:01:32.511Z | 2024-11-08T14:22:45.618Z |
5434147 | 5434147 | 20241030082832_QiCJT | USL00E | 2024-11-01T12:01:24.002Z | 2024-11-08T14:22:45.439Z |
5434094 | 5434094 | 20241030081908_rHomk | USL00E | 2024-11-01T12:01:13.843Z | 2024-11-08T14:22:44.753Z |
5433996 | 5433996 | 20241030075809_vCvCn | USL00E | 2024-11-01T12:00:46.490Z | 2024-11-08T14:22:44.434Z |
5433948 | 5433948 | 20241030074918_ufhVl | USL00E | 2024-11-01T12:00:37.707Z | 2024-11-08T14:22:44.214Z |
5433924 | 5433924 | 20241030073959_L3utQ | USL00E | 2024-11-01T12:00:33.608Z | 2024-11-08T14:22:43.811Z |
5433912 | 5433912 | 20241030073659_xUOO9 | USL00E | 2024-11-01T12:00:32.255Z | 2024-11-08T14:22:43.696Z |
5433903 | 5433903 | 20241030073555_mLQQH | USL00E | 2024-11-01T12:00:31.358Z | 2024-11-08T14:22:43.684Z |
5433846 | 5433846 | 20241030071845_3Lfav | USL00E | 2024-11-01T12:00:19.165Z | 2024-11-08T14:22:43.292Z |
5433840 | 5433840 | 20241030071716_FcUae | USL00E | 2024-11-01T12:00:18.728Z | 2024-11-08T14:22:43.283Z |
5424067 | 5424067 | 20241029125348_9UuEV | USL00E | 2024-10-31T12:03:42.093Z | 2024-11-07T14:26:30.087Z |
5424054 | 5424054 | 20241029124925_wyIAG | USL00E | 2024-10-31T12:03:39.668Z | 2024-11-07T14:26:30.018Z |
5424030 | 5424030 | 20241029124411_E9De4 | USL00E | 2024-10-31T12:03:36.093Z | 2024-11-07T14:26:29.954Z |
5423946 | 5423946 | 20241029122844_8S83p | USL00E | 2024-10-31T12:03:16.860Z | 2024-11-07T14:26:29.712Z |
5423837 | 5423837 | 20241029121102_OSgue | USL00E | 2024-10-31T12:02:56.326Z | 2024-11-07T14:26:29.212Z |
5423821 | 5423821 | 20241029120825_eeF5N | USL00E | 2024-10-31T12:02:53.549Z | 2024-11-07T14:26:29.135Z |
5423793 | 5423793 | 20241029120127_EUcpP | USL00E | 2024-10-31T12:02:48.987Z | 2024-11-07T14:26:29.029Z |
5346776 | 5346776 | 20241022124429_I35sa | USL00E | 2024-10-24T12:05:42.036Z | 2024-10-31T12:29:47.940Z |
5346687 | 5346687 | 20241022122724_0sN0Q | USL00E | 2024-10-24T12:05:28.471Z | 2024-10-31T12:29:47.685Z |
5346635 | 5346635 | 20241022121951_3YVzs | USL00E | 2024-10-24T12:05:21.436Z | 2024-10-31T12:29:47.494Z |
5346485 | 5346485 | 20241022120706_P7BHX | USL00E | 2024-10-24T12:04:50.099Z | 2024-10-31T12:29:47.073Z |
5346452 | 5346452 | 20241022120439_s1wuO | USL00E | 2024-10-24T12:04:44.704Z | 2024-10-31T12:29:47.011Z |
5346421 | 5346421 | 20241022120104_FFL4C | USL00E | 2024-10-24T12:04:40.363Z | 2024-10-31T12:29:46.965Z |
5346338 | 5346338 | 20241022115111_1KTgO | USL00E | 2024-10-24T12:04:30.530Z | 2024-10-31T12:29:46.821Z |
5346315 | 5346315 | 20241022114742_ER2oF | USL00E | 2024-10-24T12:04:27.204Z | 2024-10-31T12:29:46.705Z |
5346238 | 5346238 | 20241022113836_2b9Et | USL00E | 2024-10-24T12:04:07.533Z | 2024-10-31T12:29:46.483Z |
5346218 | 5346218 | 20241022113646_2o2p2 | USL00E | 2024-10-24T12:04:01.121Z | 2024-10-31T12:29:46.435Z |
5346113 | 5346113 | 20241022113038_1TfqZ | USL00E | 2024-10-24T12:03:44.377Z | 2024-10-31T12:29:46.074Z |
5346109 | 5346109 | 20241022113035_EHSoQ | USL00E | 2024-10-24T12:03:43.788Z | 2024-10-31T12:29:46.059Z |
5346047 | 5346047 | 20241022112447_o0jJD | USL00E | 2024-10-24T12:03:36.687Z | 2024-10-31T12:29:45.983Z |
5346037 | 5346037 | 20241022112236_kl33r | USL00E | 2024-10-24T12:03:35.444Z | 2024-10-31T12:29:45.960Z |
5345895 | 5345895 | 20241022110546_h0yLV | USL00E | 2024-10-24T12:03:04.649Z | 2024-10-31T12:29:45.579Z |
5345832 | 5345832 | 20241022105932_0OSwC | USL00E | 2024-10-24T12:02:57.155Z | 2024-10-31T12:29:45.394Z |
5345492 | 5345492 | 20241022060700_kqEuO | USL00E | 2024-10-23T12:19:23.374Z | 2024-10-30T12:26:52.876Z |
5335739 | 5335739 | 20241022063754_aK2a9 | USL00E | 2024-10-23T12:00:24.249Z | 2024-10-31T12:29:37.424Z |
5335663 | 5335663 | 20241022062347_3156R | USL00E | 2024-10-23T12:00:11.916Z | 2024-10-31T12:29:37.112Z |
5335623 | 5335623 | 20241021060816_fyHTn | USL00E | 2024-10-22T12:18:21.971Z | 2024-10-29T12:26:36.543Z |
5335605 | 5335605 | 20241021060046_HrqBv | USL00E | 2024-10-22T12:18:21.298Z | 2024-10-29T12:26:36.523Z |
5335558 | 5335558 | 20241021054145_QY56d | USL00E | 2024-10-22T12:18:17.611Z | 2024-10-29T12:26:36.491Z |
5335528 | 5335528 | 20241021053445_WyksV | USL00E | 2024-10-22T12:18:16.627Z | 2024-10-29T12:26:36.449Z |
5335266 | 5335266 | 20241021042227_DZyrb | USL00E | 2024-10-22T12:18:05.668Z | 2024-10-29T12:26:36.122Z |
5329068 | 5329068 | 20241021093234_7r2a0 | USL00E | 2024-10-22T12:03:12.416Z | 2024-10-30T12:26:33.734Z |
5329055 | 5329055 | 20241021092938_G656w | USL00E | 2024-10-22T12:03:10.974Z | 2024-10-30T12:26:33.725Z |
5328586 | 5328586 | 20241021081512_OeCAP | USL00E | 2024-10-22T12:01:54.761Z | 2024-10-30T12:26:32.560Z |
5328547 | 5328547 | 20241021081204_PfZI3 | USL00E | 2024-10-22T12:01:40.924Z | 2024-10-30T12:26:32.505Z |
5328456 | 5328456 | 20241021075921_pM3Z1 | USL00E | 2024-10-22T12:01:28.781Z | 2024-10-30T12:26:32.274Z |
5328336 | 5328336 | 20241021073645_Yl2lI | USL00E | 2024-10-22T12:01:05.064Z | 2024-10-30T12:26:31.967Z |
5328233 | 5328233 | 20241021072028_QU0pB | USL00E | 2024-10-22T12:00:44.534Z | 2024-10-30T12:26:31.768Z |
5328230 | 5328230 | 20241021071932_BuZxh | USL00E | 2024-10-22T12:00:44.006Z | 2024-10-30T12:26:31.766Z |
5328174 | 5328174 | 20241021071009_0bDIK | USL00E | 2024-10-22T12:00:35.132Z | 2024-10-30T12:26:31.579Z |
5328149 | 5328149 | 20241021070112_O2Fs7 | USL00E | 2024-10-22T12:00:29.121Z | 2024-10-30T12:26:31.512Z |
5328117 | 5328117 | 20241021064735_s5n3w | USL00E | 2024-10-22T12:00:24.906Z | 2024-10-30T12:26:31.405Z |
5328086 | 5328086 | 20241021063227_XKR2P | USL00E | 2024-10-22T12:00:20.529Z | 2024-10-30T12:26:31.251Z |
5328067 | 5328067 | 20241021062811_wUu44 | USL00E | 2024-10-22T12:00:17.416Z | 2024-10-30T12:26:31.200Z |
5320589 | 5320589 | 20241018021151_zgG37 | USL00E | 2024-10-19T12:05:39.081Z | 2024-10-26T12:27:54.984Z |
5318422 | 5318422 | 20241017031618_XdC8v | USL00E | 2024-10-18T12:03:45.946Z | 2024-10-25T12:24:35.355Z |
5318275 | 5318275 | 20241017020820_qsc5r | USL00E | 2024-10-18T12:03:17.501Z | 2024-10-25T12:24:34.387Z |
5317896 | 5317896 | 20241017122401_jLwwy | USL00E | 2024-10-18T12:01:03.186Z | 2024-10-26T12:27:52.006Z |
5317045 | 5317045 | 20241016024259_8xT70 | USL00E | 2024-10-17T12:07:41.857Z | 2024-10-24T12:27:58.684Z |
5315302 | 5315302 | 20241015121348_phSG9 | USL00E | 2024-10-17T12:04:24.991Z | 2024-10-24T12:27:51.892Z |
5315014 | 5315014 | 20241015112919_yeeh0 | USL00E | 2024-10-17T12:04:06.512Z | 2024-10-24T12:27:49.092Z |
5314315 | 5314315 | 20241016122316_C1wRh | USL00E | 2024-10-17T12:02:04.444Z | 2024-10-25T12:24:29.607Z |
5314268 | 5314268 | 20241016120830_hmwVy | USL00E | 2024-10-17T12:01:55.512Z | 2024-10-25T12:24:29.380Z |
5314195 | 5314195 | 20241016115725_D9nwC | USL00E | 2024-10-17T12:01:50.133Z | 2024-10-25T12:24:29.006Z |
5314094 | 5314094 | 20241016113146_M38DH | USL00E | 2024-10-17T12:01:41.113Z | 2024-10-25T12:24:28.730Z |
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);