participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,444 rows where station_code = "USL019" 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 |
---|---|---|---|---|---|
5572533 | 5572533 | 20241121023312_TKT73 | USL019 | 2024-11-22T14:18:32.784Z | 2024-11-22T14:19:22.346Z |
5566410 | 5566410 | 20241121061034_V2CMl | USL019 | 2024-11-22T14:02:51.402Z | 2024-11-22T14:02:51.402Z |
5563351 | 5563351 | 20241120011934_eL82j | USL019 | 2024-11-21T14:15:57.367Z | 2024-11-22T14:21:13.432Z |
5559002 | 5559002 | 20241120090443_sm4sh | USL019 | 2024-11-21T14:05:00.954Z | 2024-11-22T14:19:21.345Z |
5558878 | 5558878 | 20241120083806_bTI3x | USL019 | 2024-11-21T14:04:42.847Z | 2024-11-22T14:19:21.320Z |
5558444 | 5558444 | 20241120060442_02Els | USL019 | 2024-11-21T14:03:16.733Z | 2024-11-22T14:19:21.230Z |
5558284 | 5558284 | 20241120055210_gvAI8 | USL019 | 2024-11-21T14:02:56.184Z | 2024-11-22T14:19:21.204Z |
5553540 | 5553540 | 20241118031039_nHAYO | USL019 | 2024-11-19T14:10:48.088Z | 2024-11-22T14:22:54.077Z |
5553234 | 5553234 | 20241118014451_FDfsy | USL019 | 2024-11-19T14:10:11.128Z | 2024-11-22T14:22:51.282Z |
5549846 | 5549846 | 20241118075545_yO8k8 | USL019 | 2024-11-19T14:00:59.109Z | 2024-11-22T14:21:53.956Z |
5543726 | 5543726 | 20241115030756_mPylR | USL019 | 2024-11-16T14:07:05.354Z | 2024-11-22T14:24:00.948Z |
5543483 | 5543483 | 20241115013918_p3uzp | USL019 | 2024-11-16T14:06:29.529Z | 2024-11-22T14:23:59.471Z |
5541404 | 5541404 | 20241114012736_gRLuo | USL019 | 2024-11-15T14:07:34.633Z | 2024-11-22T14:24:18.529Z |
5541041 | 5541041 | 20241114125534_FIVHF | USL019 | 2024-11-15T14:04:58.450Z | 2024-11-22T14:23:54.421Z |
5540864 | 5540864 | 20241114121611_xLXVi | USL019 | 2024-11-15T14:04:36.086Z | 2024-11-22T14:23:52.961Z |
5540848 | 5540848 | 20241114121340_RlQLi | USL019 | 2024-11-15T14:04:34.177Z | 2024-11-22T14:23:52.893Z |
5540780 | 5540780 | 20241114120522_sRgEM | USL019 | 2024-11-15T14:04:27.702Z | 2024-11-22T14:23:52.690Z |
5540672 | 5540672 | 20241114114915_5Jm1X | USL019 | 2024-11-15T14:04:15.551Z | 2024-11-22T14:23:52.033Z |
5540462 | 5540462 | 20241114111046_pE51K | USL019 | 2024-11-15T14:03:52.024Z | 2024-11-22T14:23:51.117Z |
5540397 | 5540397 | 20241114105438_Fxxqt | USL019 | 2024-11-15T14:03:35.039Z | 2024-11-22T14:23:50.761Z |
5540391 | 5540391 | 20241114105405_1AP72 | USL019 | 2024-11-15T14:03:34.170Z | 2024-11-22T14:23:50.731Z |
5540273 | 5540273 | 20241114103134_9hWlL | USL019 | 2024-11-15T14:03:13.301Z | 2024-11-22T14:23:50.190Z |
5540223 | 5540223 | 20241114102413_qG2UK | USL019 | 2024-11-15T14:03:09.044Z | 2024-11-22T14:23:50.005Z |
5539711 | 5539711 | 20241114084309_pVlU0 | USL019 | 2024-11-15T14:01:44.007Z | 2024-11-22T14:23:45.950Z |
5539694 | 5539694 | 20241114083832_o5gvl | USL019 | 2024-11-15T14:01:42.015Z | 2024-11-22T14:23:45.878Z |
5538040 | 5538040 | 20241113020032_UMdVt | USL019 | 2024-11-14T14:12:45.438Z | 2024-11-21T14:26:19.506Z |
5535402 | 5535402 | 20241112122348_yQQO7 | USL019 | 2024-11-14T14:07:54.008Z | 2024-11-21T14:25:47.759Z |
5535261 | 5535261 | 20241112120105_hvLxM | USL019 | 2024-11-14T14:07:43.634Z | 2024-11-21T14:25:45.414Z |
5535222 | 5535222 | 20241112115805_2uYlG | USL019 | 2024-11-14T14:07:35.512Z | 2024-11-21T14:25:45.147Z |
5535098 | 5535098 | 20241112113736_ENmK2 | USL019 | 2024-11-14T14:07:15.117Z | 2024-11-21T14:25:43.873Z |
5534991 | 5534991 | 20241112112218_3Y9Ez | USL019 | 2024-11-14T14:07:04.346Z | 2024-11-21T14:25:42.852Z |
5534958 | 5534958 | 20241112111647_rMNsv | USL019 | 2024-11-14T14:07:01.886Z | 2024-11-21T14:25:41.919Z |
5534563 | 5534563 | 20241113123853_yvD10 | USL019 | 2024-11-14T14:04:35.007Z | 2024-11-22T14:24:14.589Z |
5534491 | 5534491 | 20241113122251_40M8p | USL019 | 2024-11-14T14:04:28.614Z | 2024-11-22T14:24:14.155Z |
5534477 | 5534477 | 20241113121912_j2QZK | USL019 | 2024-11-14T14:04:27.719Z | 2024-11-22T14:24:14.118Z |
5534366 | 5534366 | 20241113115241_6Bu8B | USL019 | 2024-11-14T14:04:18.759Z | 2024-11-22T14:24:13.670Z |
5534325 | 5534325 | 20241113114351_qYJqw | USL019 | 2024-11-14T14:04:14.866Z | 2024-11-22T14:24:13.408Z |
5534238 | 5534238 | 20241113112327_QBRDI | USL019 | 2024-11-14T14:03:53.987Z | 2024-11-22T14:24:13.063Z |
5533996 | 5533996 | 20241113103614_Uiiho | USL019 | 2024-11-14T14:03:24.163Z | 2024-11-22T14:24:11.954Z |
5533848 | 5533848 | 20241113101809_1LjtB | USL019 | 2024-11-14T14:03:01.267Z | 2024-11-22T14:24:11.506Z |
5533800 | 5533800 | 20241113100942_DHnQg | USL019 | 2024-11-14T14:02:51.708Z | 2024-11-22T14:24:11.333Z |
5533569 | 5533569 | 20241113092237_Tj3zX | USL019 | 2024-11-14T14:02:25.644Z | 2024-11-22T14:24:10.252Z |
5533319 | 5533319 | 20241113082843_Ol8Re | USL019 | 2024-11-14T14:01:42.180Z | 2024-11-22T14:24:07.974Z |
5533305 | 5533305 | 20241113082552_Fb2z3 | USL019 | 2024-11-14T14:01:41.059Z | 2024-11-22T14:24:07.939Z |
5533153 | 5533153 | 20241113073514_IJoCq | USL019 | 2024-11-14T14:01:16.851Z | 2024-11-22T14:24:07.460Z |
5532367 | 5532367 | 20241112051416_xtK5I | USL019 | 2024-11-13T14:16:40.139Z | 2024-11-20T14:26:22.405Z |
5531576 | 5531576 | 20241112035021_jPZrf | USL019 | 2024-11-13T14:15:45.263Z | 2024-11-20T14:26:12.513Z |
5530269 | 5530269 | 20241112020320_UB5UF | USL019 | 2024-11-13T14:14:05.356Z | 2024-11-20T14:25:56.303Z |
5527116 | 5527116 | 20241112110157_yPHvu | USL019 | 2024-11-13T14:05:04.310Z | 2024-11-21T14:25:41.367Z |
5527077 | 5527077 | 20241112105831_JxwDy | USL019 | 2024-11-13T14:04:59.646Z | 2024-11-21T14:25:41.010Z |
5527014 | 5527014 | 20241112104700_uov6U | USL019 | 2024-11-13T14:04:51.539Z | 2024-11-21T14:25:40.330Z |
5526782 | 5526782 | 20241112101502_6LOvM | USL019 | 2024-11-13T14:04:09.238Z | 2024-11-21T14:25:38.437Z |
5526665 | 5526665 | 20241112100007_pzSxY | USL019 | 2024-11-13T14:03:49.432Z | 2024-11-21T14:25:37.136Z |
5526404 | 5526404 | 20241112091356_5i8Qy | USL019 | 2024-11-13T14:02:55.611Z | 2024-11-21T14:25:34.728Z |
5526267 | 5526267 | 20241112084750_AIla1 | USL019 | 2024-11-13T14:02:32.851Z | 2024-11-21T14:25:33.392Z |
5526264 | 5526264 | 20241112084737_12HKA | USL019 | 2024-11-13T14:02:32.488Z | 2024-11-21T14:25:33.342Z |
5526240 | 5526240 | 20241112084159_sJ0t7 | USL019 | 2024-11-13T14:02:21.675Z | 2024-11-21T14:25:33.060Z |
5526233 | 5526233 | 20241112083842_Qzhah | USL019 | 2024-11-13T14:02:17.856Z | 2024-11-21T14:25:32.883Z |
5526200 | 5526200 | 20241112083051_iFAVb | USL019 | 2024-11-13T14:02:09.832Z | 2024-11-21T14:25:31.754Z |
5526110 | 5526110 | 20241112080747_yCrWM | USL019 | 2024-11-13T14:01:56.303Z | 2024-11-21T14:25:30.524Z |
5526022 | 5526022 | 20241112074950_t2ecZ | USL019 | 2024-11-13T14:01:36.500Z | 2024-11-21T14:25:30.074Z |
5520464 | 5520464 | 20241110080209_1KQxZ | USL019 | 2024-11-12T14:06:55.755Z | 2024-11-19T14:21:20.825Z |
5517987 | 5517987 | 20241110053137_NqPl4 | USL019 | 2024-11-11T14:15:06.424Z | 2024-11-18T14:26:39.112Z |
5517917 | 5517917 | 20241110051645_lS9Ip | USL019 | 2024-11-11T14:15:02.060Z | 2024-11-18T14:26:38.926Z |
5517508 | 5517508 | 20241110035610_W3MP7 | USL019 | 2024-11-11T14:14:31.200Z | 2024-11-18T14:26:36.872Z |
5513930 | 5513930 | 20241110124914_mKT5G | USL019 | 2024-11-11T14:05:40.329Z | 2024-11-19T14:21:40.414Z |
5513871 | 5513871 | 20241110123342_hymj9 | USL019 | 2024-11-11T14:05:34.106Z | 2024-11-19T14:21:39.179Z |
5513836 | 5513836 | 20241110122627_rwEvt | USL019 | 2024-11-11T14:05:31.745Z | 2024-11-19T14:21:38.496Z |
5513733 | 5513733 | 20241110121235_MnoGs | USL019 | 2024-11-11T14:05:23.940Z | 2024-11-19T14:21:37.287Z |
5513463 | 5513463 | 20241110113426_22Y90 | USL019 | 2024-11-11T14:04:40.714Z | 2024-11-19T14:21:34.516Z |
5513431 | 5513431 | 20241110113143_gwV8R | USL019 | 2024-11-11T14:04:38.741Z | 2024-11-19T14:21:34.184Z |
5513289 | 5513289 | 20241110111125_jAVEM | USL019 | 2024-11-11T14:04:24.302Z | 2024-11-19T14:21:32.863Z |
5512917 | 5512917 | 20241110101144_UlHnm | USL019 | 2024-11-11T14:03:35.619Z | 2024-11-19T14:21:29.752Z |
5512848 | 5512848 | 20241110095827_uXHIK | USL019 | 2024-11-11T14:03:17.570Z | 2024-11-19T14:21:28.955Z |
5512737 | 5512737 | 20241110094213_DYQoR | USL019 | 2024-11-11T14:03:03.269Z | 2024-11-19T14:21:27.754Z |
5512686 | 5512686 | 20241110093035_kU2J7 | USL019 | 2024-11-11T14:02:57.859Z | 2024-11-19T14:21:27.454Z |
5512545 | 5512545 | 20241110090630_1RrkK | USL019 | 2024-11-11T14:02:37.654Z | 2024-11-19T14:21:26.142Z |
5512541 | 5512541 | 20241110090546_ZKFwx | USL019 | 2024-11-11T14:02:35.977Z | 2024-11-19T14:21:26.080Z |
5512294 | 5512294 | 20241110082836_36Ck2 | USL019 | 2024-11-11T14:02:02.717Z | 2024-11-19T14:21:22.758Z |
5512263 | 5512263 | 20241110082309_XD1tf | USL019 | 2024-11-11T14:01:58.664Z | 2024-11-19T14:21:22.313Z |
5512148 | 5512148 | 20241110080458_0pAPP | USL019 | 2024-11-11T14:01:37.051Z | 2024-11-19T14:21:20.880Z |
5512141 | 5512141 | 20241110080209_qTA0K | USL019 | 2024-11-11T14:01:36.120Z | 2024-11-11T14:01:36.120Z |
5512105 | 5512105 | 20241110075727_5StwU | USL019 | 2024-11-11T14:01:33.101Z | 2024-11-19T14:21:20.609Z |
5512098 | 5512098 | 20241110075615_3d3Yj | USL019 | 2024-11-11T14:01:32.366Z | 2024-11-19T14:21:20.574Z |
5511653 | 5511653 | 20241110063328_68PIa | USL019 | 2024-11-11T14:00:25.357Z | 2024-11-19T14:21:14.965Z |
5504913 | 5504913 | 20241108031737_GBHUO | USL019 | 2024-11-09T14:15:23.392Z | 2024-11-16T14:28:24.841Z |
5499633 | 5499633 | 20241108124722_2RWir | USL019 | 2024-11-09T14:04:29.271Z | 2024-11-17T14:23:14.003Z |
5499501 | 5499501 | 20241108122802_CNW43 | USL019 | 2024-11-09T14:04:13.083Z | 2024-11-17T14:23:12.207Z |
5499489 | 5499489 | 20241108122746_r7Tv4 | USL019 | 2024-11-09T14:04:11.328Z | 2024-11-17T14:23:11.982Z |
5499423 | 5499423 | 20241108121738_ZfyKo | USL019 | 2024-11-09T14:04:05.311Z | 2024-11-17T14:23:11.574Z |
5499315 | 5499315 | 20241108115441_HsyUG | USL019 | 2024-11-09T14:03:44.627Z | 2024-11-17T14:23:09.250Z |
5499285 | 5499285 | 20241108114949_PApzP | USL019 | 2024-11-09T14:03:41.758Z | 2024-11-17T14:23:08.700Z |
5499231 | 5499231 | 20241108114007_7zssE | USL019 | 2024-11-09T14:03:35.105Z | 2024-11-17T14:23:08.098Z |
5499229 | 5499229 | 20241108114004_oNIC3 | USL019 | 2024-11-09T14:03:34.702Z | 2024-11-17T14:23:08.073Z |
5499069 | 5499069 | 20241108105814_DO5ce | USL019 | 2024-11-09T14:03:05.330Z | 2024-11-17T14:23:04.750Z |
5499039 | 5499039 | 20241108105215_yz2Rf | USL019 | 2024-11-09T14:03:01.802Z | 2024-11-17T14:23:04.285Z |
5498917 | 5498917 | 20241108102506_NEpVm | USL019 | 2024-11-09T14:02:46.427Z | 2024-11-17T14:23:01.459Z |
5498827 | 5498827 | 20241108100937_g3BIS | USL019 | 2024-11-09T14:02:30.023Z | 2024-11-17T14:23:00.464Z |
5498737 | 5498737 | 20241108094539_XoNMB | USL019 | 2024-11-09T14:02:17.883Z | 2024-11-17T14:22:59.416Z |
5498668 | 5498668 | 20241108093339_HSxP2 | USL019 | 2024-11-09T14:02:08.255Z | 2024-11-17T14:22:58.810Z |
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);