participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "USL00C" 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 |
---|---|---|---|---|---|
5573181 | 5573181 | 20241121040432_lIPS2 | USL00C | 2024-11-22T14:19:14.547Z | 2024-11-22T14:19:22.464Z |
5572901 | 5572901 | 20241121032348_plkJL | USL00C | 2024-11-22T14:18:57.882Z | 2024-11-22T14:19:22.411Z |
5572711 | 5572711 | 20241121030101_bZsqy | USL00C | 2024-11-22T14:18:45.169Z | 2024-11-22T14:19:22.378Z |
5572518 | 5572518 | 20241121023146_I95AU | USL00C | 2024-11-22T14:18:31.914Z | 2024-11-22T14:19:22.343Z |
5568063 | 5568063 | 20241121114559_3Ime9 | USL00C | 2024-11-22T14:08:02.580Z | 2024-11-22T14:08:02.580Z |
5567955 | 5567955 | 20241121113552_rydiC | USL00C | 2024-11-22T14:07:51.480Z | 2024-11-22T14:07:51.480Z |
5567827 | 5567827 | 20241121111624_gT16t | USL00C | 2024-11-22T14:07:21.003Z | 2024-11-22T14:07:21.003Z |
5567673 | 5567673 | 20241121105106_hgcba | USL00C | 2024-11-22T14:06:50.753Z | 2024-11-22T14:06:50.753Z |
5567495 | 5567495 | 20241121102843_WzvDV | USL00C | 2024-11-22T14:06:24.486Z | 2024-11-22T14:06:24.486Z |
5567447 | 5567447 | 20241121102044_bF79g | USL00C | 2024-11-22T14:06:18.090Z | 2024-11-22T14:06:18.090Z |
5567343 | 5567343 | 20241121100406_oH2UF | USL00C | 2024-11-22T14:05:57.032Z | 2024-11-22T14:05:57.032Z |
5567177 | 5567177 | 20241121093647_IzX5Q | USL00C | 2024-11-22T14:05:30.328Z | 2024-11-22T14:05:30.328Z |
5567113 | 5567113 | 20241121092534_s5KRf | USL00C | 2024-11-22T14:05:22.569Z | 2024-11-22T14:05:22.569Z |
5567100 | 5567100 | 20241121092248_p9aT4 | USL00C | 2024-11-22T14:05:14.845Z | 2024-11-22T14:05:14.845Z |
5566987 | 5566987 | 20241121085359_xpoct | USL00C | 2024-11-22T14:04:49.696Z | 2024-11-22T14:04:49.696Z |
5566946 | 5566946 | 20241121084650_qBGyL | USL00C | 2024-11-22T14:04:41.693Z | 2024-11-22T14:04:41.693Z |
5566910 | 5566910 | 20241121083618_iQw2i | USL00C | 2024-11-22T14:04:28.545Z | 2024-11-22T14:04:28.545Z |
5566887 | 5566887 | 20241121082605_lqHR0 | USL00C | 2024-11-22T14:04:22.876Z | 2024-11-22T14:04:22.876Z |
5566854 | 5566854 | 20241121081702_MhLEm | USL00C | 2024-11-22T14:04:17.716Z | 2024-11-22T14:04:17.716Z |
5566392 | 5566392 | 20241121060639_t3L7a | USL00C | 2024-11-22T14:02:43.094Z | 2024-11-22T14:02:43.094Z |
5566318 | 5566318 | 20241121055942_257yo | USL00C | 2024-11-22T14:02:26.655Z | 2024-11-22T14:02:26.655Z |
5565772 | 5565772 | 20241121044358_3idQU | USL00C | 2024-11-22T14:00:54.548Z | 2024-11-22T14:00:54.548Z |
5565756 | 5565756 | 20241121044159_79l5T | USL00C | 2024-11-22T14:00:52.881Z | 2024-11-22T14:00:52.881Z |
5565652 | 5565652 | 20241121043154_9mWaG | USL00C | 2024-11-22T14:00:35.839Z | 2024-11-22T14:00:35.839Z |
5563985 | 5563985 | 20241120022047_FW0pE | USL00C | 2024-11-21T14:17:02.569Z | 2024-11-22T14:21:26.013Z |
5563797 | 5563797 | 20241120020437_yUFAA | USL00C | 2024-11-21T14:16:44.188Z | 2024-11-22T14:21:23.389Z |
5559935 | 5559935 | 20241120113604_AIPQO | USL00C | 2024-11-21T14:07:36.707Z | 2024-11-22T14:19:21.553Z |
5559613 | 5559613 | 20241120104922_negQB | USL00C | 2024-11-21T14:06:44.104Z | 2024-11-22T14:19:21.485Z |
5559332 | 5559332 | 20241120100525_IU83O | USL00C | 2024-11-21T14:06:00.536Z | 2024-11-22T14:19:21.419Z |
5559010 | 5559010 | 20241120090453_ZcLk9 | USL00C | 2024-11-21T14:05:02.393Z | 2024-11-22T14:19:21.347Z |
5558883 | 5558883 | 20241120084330_RyIyo | USL00C | 2024-11-21T14:04:43.608Z | 2024-11-22T14:19:21.321Z |
5558617 | 5558617 | 20241120070744_0xA8b | USL00C | 2024-11-21T14:03:50.160Z | 2024-11-22T14:19:21.264Z |
5557979 | 5557979 | 20241120052800_hEtOa | USL00C | 2024-11-21T14:02:11.822Z | 2024-11-22T14:19:21.156Z |
5557720 | 5557720 | 20241120050754_stRD4 | USL00C | 2024-11-21T14:01:35.399Z | 2024-11-22T14:19:21.117Z |
5557567 | 5557567 | 20241120045750_tMQvV | USL00C | 2024-11-21T14:01:12.027Z | 2024-11-22T14:19:21.092Z |
5554098 | 5554098 | 20241119060819_6wgcf | USL00C | 2024-11-20T14:00:44.214Z | 2024-11-22T14:19:29.685Z |
5553985 | 5553985 | 20241119050836_QVKv7 | USL00C | 2024-11-20T14:00:18.413Z | 2024-11-22T14:19:25.519Z |
5553898 | 5553898 | 20241118044437_tYVF6 | USL00C | 2024-11-19T14:11:32.622Z | 2024-11-22T14:22:57.174Z |
5553812 | 5553812 | 20241118042614_tn1XR | USL00C | 2024-11-19T14:11:28.081Z | 2024-11-22T14:22:56.397Z |
5553685 | 5553685 | 20241118035249_D8327 | USL00C | 2024-11-19T14:11:16.601Z | 2024-11-22T14:22:55.373Z |
5553623 | 5553623 | 20241118033358_8zUBv | USL00C | 2024-11-19T14:11:05.746Z | 2024-11-22T14:22:54.858Z |
5553601 | 5553601 | 20241118033035_K3jh3 | USL00C | 2024-11-19T14:11:01.997Z | 2024-11-22T14:22:54.549Z |
5553284 | 5553284 | 20241118015718_uApD1 | USL00C | 2024-11-19T14:10:14.834Z | 2024-11-22T14:22:51.696Z |
5549778 | 5549778 | 20241118062757_xlWL9 | USL00C | 2024-11-19T14:00:49.551Z | 2024-11-22T14:21:52.690Z |
5549776 | 5549776 | 20241118062629_kJC0c | USL00C | 2024-11-19T14:00:49.101Z | 2024-11-22T14:21:52.624Z |
5541033 | 5541033 | 20241114125404_BZ5sZ | USL00C | 2024-11-15T14:04:57.750Z | 2024-11-22T14:23:54.384Z |
5540970 | 5540970 | 20241114123709_1uoFT | USL00C | 2024-11-15T14:04:52.634Z | 2024-11-22T14:23:53.691Z |
5540896 | 5540896 | 20241114122117_xZGCV | USL00C | 2024-11-15T14:04:38.963Z | 2024-11-22T14:23:53.041Z |
5540782 | 5540782 | 20241114120523_v3eGj | USL00C | 2024-11-15T14:04:28.015Z | 2024-11-22T14:23:52.706Z |
5540716 | 5540716 | 20241114115501_Y5uQE | USL00C | 2024-11-15T14:04:20.255Z | 2024-11-22T14:23:52.369Z |
5540687 | 5540687 | 20241114115122_wi62d | USL00C | 2024-11-15T14:04:17.761Z | 2024-11-22T14:23:52.092Z |
5540683 | 5540683 | 20241114115035_CtXrj | USL00C | 2024-11-15T14:04:17.417Z | 2024-11-22T14:23:52.088Z |
5540429 | 5540429 | 20241114110458_fyYFJ | USL00C | 2024-11-15T14:03:44.908Z | 2024-11-22T14:23:50.857Z |
5535558 | 5535558 | 20241112124931_VzKlO | USL00C | 2024-11-14T14:08:05.158Z | 2024-11-21T14:25:50.094Z |
5535227 | 5535227 | 20241112115814_ZLZrV | USL00C | 2024-11-14T14:07:36.280Z | 2024-11-21T14:25:45.158Z |
5535102 | 5535102 | 20241112113831_ZSvuv | USL00C | 2024-11-14T14:07:15.606Z | 2024-11-21T14:25:43.882Z |
5535026 | 5535026 | 20241112112657_P22uI | USL00C | 2024-11-14T14:07:07.311Z | 2024-11-21T14:25:43.244Z |
5534979 | 5534979 | 20241112112128_3pWt3 | USL00C | 2024-11-14T14:07:03.407Z | 2024-11-21T14:25:42.779Z |
5534572 | 5534572 | 20241113123951_2LM1o | USL00C | 2024-11-14T14:04:36.392Z | 2024-11-22T14:24:14.623Z |
5534554 | 5534554 | 20241113123641_vVAxY | USL00C | 2024-11-14T14:04:33.924Z | 2024-11-22T14:24:14.546Z |
5534540 | 5534540 | 20241113123332_wKd9q | USL00C | 2024-11-14T14:04:32.752Z | 2024-11-22T14:24:14.510Z |
5534180 | 5534180 | 20241113111410_d2TJE | USL00C | 2024-11-14T14:03:42.665Z | 2024-11-22T14:24:12.793Z |
5534168 | 5534168 | 20241113111234_NWTiu | USL00C | 2024-11-14T14:03:41.718Z | 2024-11-22T14:24:12.633Z |
5534154 | 5534154 | 20241113110951_dH51b | USL00C | 2024-11-14T14:03:40.828Z | 2024-11-22T14:24:12.582Z |
5534058 | 5534058 | 20241113105309_OxFR2 | USL00C | 2024-11-14T14:03:30.697Z | 2024-11-22T14:24:12.174Z |
5533644 | 5533644 | 20241113093753_JqPFY | USL00C | 2024-11-14T14:02:33.524Z | 2024-11-22T14:24:10.583Z |
5533588 | 5533588 | 20241113092916_0YQZr | USL00C | 2024-11-14T14:02:27.855Z | 2024-11-22T14:24:10.318Z |
5531950 | 5531950 | 20241112042219_daCKU | USL00C | 2024-11-13T14:16:03.438Z | 2024-11-20T14:26:16.560Z |
5531600 | 5531600 | 20241112035035_AxzaJ | USL00C | 2024-11-13T14:15:46.054Z | 2024-11-20T14:26:12.639Z |
5531269 | 5531269 | 20241112032755_dgCpU | USL00C | 2024-11-13T14:15:32.112Z | 2024-11-20T14:26:09.701Z |
5527108 | 5527108 | 20241112110038_ArLWe | USL00C | 2024-11-13T14:05:02.755Z | 2024-11-21T14:25:41.339Z |
5526952 | 5526952 | 20241112103644_TtayF | USL00C | 2024-11-13T14:04:43.606Z | 2024-11-21T14:25:39.919Z |
5526902 | 5526902 | 20241112102746_VOLHa | USL00C | 2024-11-13T14:04:29.664Z | 2024-11-21T14:25:39.570Z |
5526483 | 5526483 | 20241112093018_xce5I | USL00C | 2024-11-13T14:03:18.215Z | 2024-11-21T14:25:35.869Z |
5526321 | 5526321 | 20241112085929_HDaz2 | USL00C | 2024-11-13T14:02:42.825Z | 2024-11-21T14:25:34.070Z |
5526313 | 5526313 | 20241112085810_Djin6 | USL00C | 2024-11-13T14:02:42.184Z | 2024-11-21T14:25:34.047Z |
5525727 | 5525727 | 20241112061744_oetds | USL00C | 2024-11-13T14:00:30.740Z | 2024-11-21T14:25:25.829Z |
5524706 | 5524706 | 20241111051525_21uiG | USL00C | 2024-11-12T14:17:56.432Z | 2024-11-19T14:22:23.440Z |
5524588 | 5524588 | 20241111044407_gdlxZ | USL00C | 2024-11-12T14:17:43.749Z | 2024-11-19T14:22:22.586Z |
5524382 | 5524382 | 20241111040446_M3zAC | USL00C | 2024-11-12T14:17:12.972Z | 2024-11-19T14:22:20.884Z |
5520472 | 5520472 | 20241110081512_1YnOt | USL00C | 2024-11-12T14:06:59.715Z | 2024-11-19T14:21:21.734Z |
5520467 | 5520467 | 20241110081105_mmxvw | USL00C | 2024-11-12T14:06:58.598Z | 2024-11-19T14:21:21.333Z |
5519752 | 5519752 | 20241111125220_JvCU3 | USL00C | 2024-11-12T14:04:54.659Z | 2024-11-20T14:24:57.290Z |
5519744 | 5519744 | 20241111124918_Sg2UK | USL00C | 2024-11-12T14:04:53.991Z | 2024-11-20T14:24:56.838Z |
5519591 | 5519591 | 20241111120541_9JI6c | USL00C | 2024-11-12T14:04:33.573Z | 2024-11-20T14:24:53.143Z |
5519586 | 5519586 | 20241111120516_pFEN7 | USL00C | 2024-11-12T14:04:33.261Z | 2024-11-20T14:24:53.135Z |
5519309 | 5519309 | 20241111105709_ngopu | USL00C | 2024-11-12T14:03:43.410Z | 2024-11-20T14:24:47.298Z |
5519263 | 5519263 | 20241111105039_Sd333 | USL00C | 2024-11-12T14:03:30.158Z | 2024-11-20T14:24:46.935Z |
5519179 | 5519179 | 20241111103525_vWJCk | USL00C | 2024-11-12T14:03:16.128Z | 2024-11-20T14:24:46.298Z |
5519162 | 5519162 | 20241111102852_OztkJ | USL00C | 2024-11-12T14:03:14.040Z | 2024-11-20T14:24:46.045Z |
5519080 | 5519080 | 20241111101144_QItRZ | USL00C | 2024-11-12T14:03:00.948Z | 2024-11-20T14:24:45.009Z |
5519019 | 5519019 | 20241111095653_wEmwI | USL00C | 2024-11-12T14:02:41.861Z | 2024-11-20T14:24:44.028Z |
5518959 | 5518959 | 20241111094129_TGblk | USL00C | 2024-11-12T14:02:27.101Z | 2024-11-20T14:24:43.349Z |
5518856 | 5518856 | 20241111092217_z0vg0 | USL00C | 2024-11-12T14:02:13.939Z | 2024-11-20T14:24:42.122Z |
5518778 | 5518778 | 20241111090813_VsN3g | USL00C | 2024-11-12T14:02:01.633Z | 2024-11-20T14:24:41.172Z |
5518459 | 5518459 | 20241111075823_TiEvw | USL00C | 2024-11-12T14:01:01.110Z | 2024-11-20T14:24:35.117Z |
5518233 | 5518233 | 20241111062643_wLIp8 | USL00C | 2024-11-12T14:00:19.600Z | 2024-11-20T14:24:30.377Z |
5517476 | 5517476 | 20241110034920_KGn27 | USL00C | 2024-11-11T14:14:28.607Z | 2024-11-18T14:26:36.651Z |
5517168 | 5517168 | 20241110025751_ZvKpw | USL00C | 2024-11-11T14:14:00.667Z | 2024-11-18T14:26:35.060Z |
5513850 | 5513850 | 20241110123101_29PCQ | USL00C | 2024-11-11T14:05:32.852Z | 2024-11-19T14:21:39.048Z |
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);