participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
28,449 rows where station_code = "USL005" 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 |
---|---|---|---|---|---|
5130313 | 5130313 | 20240917111301_EF3dh | USL005 | 2024-09-19T12:12:58.979Z | 2024-09-19T12:12:58.979Z |
5130305 | 5130305 | 20240917110839_LvVN0 | USL005 | 2024-09-19T12:12:58.086Z | 2024-09-19T12:12:58.086Z |
5130287 | 5130287 | 20240917110453_IBt25 | USL005 | 2024-09-19T12:12:56.246Z | 2024-09-19T12:12:56.246Z |
5130255 | 5130255 | 20240917104840_jLD3T | USL005 | 2024-09-19T12:12:51.694Z | 2024-09-19T12:12:51.694Z |
5130249 | 5130249 | 20240917104642_wjYtg | USL005 | 2024-09-19T12:12:51.254Z | 2024-09-19T12:12:51.254Z |
5130205 | 5130205 | 20240917101939_07rht | USL005 | 2024-09-19T12:12:46.317Z | 2024-09-19T12:12:46.317Z |
5130198 | 5130198 | 20240917101520_CR7AM | USL005 | 2024-09-19T12:12:45.722Z | 2024-09-19T12:12:45.722Z |
5130155 | 5130155 | 20240917095009_uxhVN | USL005 | 2024-09-19T12:12:41.361Z | 2024-09-19T12:12:41.361Z |
5130099 | 5130099 | 20240917090429_nRr0L | USL005 | 2024-09-19T12:12:34.775Z | 2024-09-19T12:12:34.775Z |
5126472 | 5126472 | 20240918120627_zHZnL | USL005 | 2024-09-19T12:06:02.127Z | 2024-09-19T12:06:42.207Z |
5108376 | 5108376 | 20240913051419_zSJsA | USL005 | 2024-09-17T12:13:41.834Z | 2024-09-19T12:20:48.536Z |
5108343 | 5108343 | 20240913045750_siQpO | USL005 | 2024-09-17T12:13:37.758Z | 2024-09-19T12:20:48.301Z |
5108320 | 5108320 | 20240913045001_EHouG | USL005 | 2024-09-17T12:13:36.471Z | 2024-09-19T12:20:48.149Z |
5108309 | 5108309 | 20240913044842_ElbEz | USL005 | 2024-09-17T12:13:36.139Z | 2024-09-19T12:20:48.116Z |
5108291 | 5108291 | 20240913044556_2uciR | USL005 | 2024-09-17T12:13:35.128Z | 2024-09-19T12:20:48.020Z |
5108037 | 5108037 | 20240913042048_A45YE | USL005 | 2024-09-17T12:13:29.006Z | 2024-09-19T12:20:47.776Z |
5107741 | 5107741 | 20240913040933_990Qw | USL005 | 2024-09-17T12:13:23.491Z | 2024-09-19T12:20:47.527Z |
5107413 | 5107413 | 20240913035459_Wnmb3 | USL005 | 2024-09-17T12:13:14.648Z | 2024-09-19T12:20:47.106Z |
5106308 | 5106308 | 20240913031818_2yFU5 | USL005 | 2024-09-17T12:12:49.262Z | 2024-09-19T12:20:45.807Z |
5096890 | 5096890 | 20240912120310_u9Wxr | USL005 | 2024-09-16T12:16:36.833Z | 2024-09-19T12:21:24.069Z |
5096879 | 5096879 | 20240912120147_oGOlJ | USL005 | 2024-09-16T12:16:36.580Z | 2024-09-19T12:21:24.053Z |
5096875 | 5096875 | 20240912120128_BZ8iw | USL005 | 2024-09-16T12:16:36.542Z | 2024-09-19T12:21:24.049Z |
5096850 | 5096850 | 20240912115749_2qiil | USL005 | 2024-09-16T12:16:35.903Z | 2024-09-19T12:21:24.022Z |
5096843 | 5096843 | 20240912115702_amZAt | USL005 | 2024-09-16T12:16:35.701Z | 2024-09-19T12:21:24.012Z |
5096824 | 5096824 | 20240912115501_2GK22 | USL005 | 2024-09-16T12:16:35.426Z | 2024-09-19T12:21:23.991Z |
5096811 | 5096811 | 20240912115230_D21jF | USL005 | 2024-09-16T12:16:35.276Z | 2024-09-19T12:21:23.965Z |
5096701 | 5096701 | 20240912113133_JkebJ | USL005 | 2024-09-16T12:16:32.058Z | 2024-09-19T12:21:23.456Z |
5096624 | 5096624 | 20240912112517_GWyUh | USL005 | 2024-09-16T12:16:30.001Z | 2024-09-19T12:21:23.301Z |
5096589 | 5096589 | 20240912111845_sMXtH | USL005 | 2024-09-16T12:16:28.213Z | 2024-09-19T12:21:22.949Z |
5096566 | 5096566 | 20240912111301_UN5GT | USL005 | 2024-09-16T12:16:27.558Z | 2024-09-19T12:21:22.799Z |
5096556 | 5096556 | 20240912111052_mqMkS | USL005 | 2024-09-16T12:16:27.518Z | 2024-09-19T12:21:22.763Z |
5096534 | 5096534 | 20240912110939_Vo7Xt | USL005 | 2024-09-16T12:16:26.725Z | 2024-09-19T12:21:22.655Z |
5096520 | 5096520 | 20240912110741_yWooD | USL005 | 2024-09-16T12:16:26.239Z | 2024-09-19T12:21:22.495Z |
5096463 | 5096463 | 20240912105451_wr9GD | USL005 | 2024-09-16T12:16:24.096Z | 2024-09-19T12:21:22.365Z |
5096446 | 5096446 | 20240912105351_H16q9 | USL005 | 2024-09-16T12:16:23.746Z | 2024-09-19T12:21:22.336Z |
5096425 | 5096425 | 20240912104920_7r03D | USL005 | 2024-09-16T12:16:23.294Z | 2024-09-19T12:21:22.293Z |
5096366 | 5096366 | 20240912103914_ZhcGn | USL005 | 2024-09-16T12:16:21.602Z | 2024-09-19T12:21:22.199Z |
5096360 | 5096360 | 20240912103847_vOzZZ | USL005 | 2024-09-16T12:16:21.362Z | 2024-09-19T12:21:22.193Z |
5096277 | 5096277 | 20240912102740_pG703 | USL005 | 2024-09-16T12:16:18.740Z | 2024-09-19T12:21:22.009Z |
5096255 | 5096255 | 20240912102532_vvfLq | USL005 | 2024-09-16T12:16:17.418Z | 2024-09-19T12:21:21.982Z |
5096193 | 5096193 | 20240912101501_uIfWg | USL005 | 2024-09-16T12:16:14.315Z | 2024-09-19T12:21:21.838Z |
5096161 | 5096161 | 20240912100932_2dwck | USL005 | 2024-09-16T12:16:12.373Z | 2024-09-19T12:21:21.759Z |
5096153 | 5096153 | 20240912100822_n9B1F | USL005 | 2024-09-16T12:16:11.923Z | 2024-09-19T12:21:21.755Z |
5096092 | 5096092 | 20240912095610_PUMZt | USL005 | 2024-09-16T12:16:09.411Z | 2024-09-19T12:21:21.369Z |
5096088 | 5096088 | 20240912095603_xfc00 | USL005 | 2024-09-16T12:16:09.115Z | 2024-09-19T12:21:21.343Z |
5096056 | 5096056 | 20240912095132_mRi62 | USL005 | 2024-09-16T12:16:08.254Z | 2024-09-19T12:21:21.222Z |
5096054 | 5096054 | 20240912095050_LpIvu | USL005 | 2024-09-16T12:16:08.071Z | 2024-09-19T12:21:21.201Z |
5096015 | 5096015 | 20240912094343_zoH0M | USL005 | 2024-09-16T12:16:05.536Z | 2024-09-19T12:21:20.985Z |
5095981 | 5095981 | 20240912093825_REKrX | USL005 | 2024-09-16T12:16:04.269Z | 2024-09-19T12:21:20.804Z |
5095897 | 5095897 | 20240912092332_q3f37 | USL005 | 2024-09-16T12:16:01.556Z | 2024-09-19T12:21:20.627Z |
5095890 | 5095890 | 20240912092252_Gj0kf | USL005 | 2024-09-16T12:16:01.516Z | 2024-09-19T12:21:20.602Z |
5095854 | 5095854 | 20240912091853_nyRhU | USL005 | 2024-09-16T12:16:00.659Z | 2024-09-19T12:21:20.537Z |
5095846 | 5095846 | 20240912091707_J9Y2u | USL005 | 2024-09-16T12:16:00.606Z | 2024-09-19T12:21:20.533Z |
5095813 | 5095813 | 20240912090844_U8de3 | USL005 | 2024-09-16T12:15:58.927Z | 2024-09-19T12:21:20.336Z |
5095789 | 5095789 | 20240912090203_TW0Yi | USL005 | 2024-09-16T12:15:58.247Z | 2024-09-19T12:21:20.232Z |
5095766 | 5095766 | 20240912085750_aR1Be | USL005 | 2024-09-16T12:15:57.508Z | 2024-09-19T12:21:20.108Z |
5095642 | 5095642 | 20240912083325_sA3Ep | USL005 | 2024-09-16T12:15:51.933Z | 2024-09-19T12:21:19.581Z |
5095634 | 5095634 | 20240912083020_AYpsh | USL005 | 2024-09-16T12:15:51.600Z | 2024-09-19T12:21:19.483Z |
5095621 | 5095621 | 20240912083017_yN1sc | USL005 | 2024-09-16T12:15:51.479Z | 2024-09-19T12:21:19.395Z |
5095571 | 5095571 | 20240912080810_VCYfq | USL005 | 2024-09-16T12:15:49.386Z | 2024-09-19T12:21:19.143Z |
5095566 | 5095566 | 20240912080600_YNFDs | USL005 | 2024-09-16T12:15:49.195Z | 2024-09-19T12:21:19.120Z |
5095553 | 5095553 | 20240912080249_X5PNS | USL005 | 2024-09-16T12:15:48.991Z | 2024-09-19T12:21:19.011Z |
5095500 | 5095500 | 20240912075059_ZA39Q | USL005 | 2024-09-16T12:15:44.208Z | 2024-09-19T12:21:18.710Z |
5095489 | 5095489 | 20240912074800_ipiMk | USL005 | 2024-09-16T12:15:43.271Z | 2024-09-19T12:21:18.678Z |
5095418 | 5095418 | 20240912073016_ADJSO | USL005 | 2024-09-16T12:15:39.766Z | 2024-09-19T12:21:18.492Z |
5095343 | 5095343 | 20240912072008_o0FCH | USL005 | 2024-09-16T12:15:34.245Z | 2024-09-19T12:21:18.190Z |
5095317 | 5095317 | 20240912071249_a6c1H | USL005 | 2024-09-16T12:15:32.377Z | 2024-09-19T12:21:18.133Z |
5095269 | 5095269 | 20240912065656_d4mnT | USL005 | 2024-09-16T12:15:28.780Z | 2024-09-19T12:21:17.867Z |
5095224 | 5095224 | 20240912064632_a382S | USL005 | 2024-09-16T12:15:25.100Z | 2024-09-19T12:21:17.568Z |
5095094 | 5095094 | 20240912055016_vKHhd | USL005 | 2024-09-16T12:15:13.940Z | 2024-09-19T12:21:17.266Z |
5095024 | 5095024 | 20240912051555_Q36el | USL005 | 2024-09-16T12:15:09.998Z | 2024-09-19T12:21:17.005Z |
5095014 | 5095014 | 20240912051341_UV0Yn | USL005 | 2024-09-16T12:15:09.557Z | 2024-09-19T12:21:16.976Z |
5094996 | 5094996 | 20240912050629_ejMR7 | USL005 | 2024-09-16T12:15:08.392Z | 2024-09-19T12:21:16.904Z |
5094979 | 5094979 | 20240912045928_5THRf | USL005 | 2024-09-16T12:15:06.624Z | 2024-09-19T12:21:16.797Z |
5094921 | 5094921 | 20240912043629_3iI5U | USL005 | 2024-09-16T12:15:01.271Z | 2024-09-19T12:21:16.562Z |
5094864 | 5094864 | 20240912042738_SVeCK | USL005 | 2024-09-16T12:14:59.928Z | 2024-09-19T12:21:16.466Z |
5094660 | 5094660 | 20240912041432_TzKym | USL005 | 2024-09-16T12:14:53.516Z | 2024-09-19T12:21:16.369Z |
5093286 | 5093286 | 20240912031701_8bbI4 | USL005 | 2024-09-16T12:14:14.565Z | 2024-09-19T12:21:15.207Z |
5083095 | 5083095 | 20240911115608_br023 | USL005 | 2024-09-15T12:18:35.532Z | 2024-09-19T12:21:49.332Z |
5083093 | 5083093 | 20240911115604_wak2c | USL005 | 2024-09-15T12:18:35.391Z | 2024-09-19T12:21:49.280Z |
5082972 | 5082972 | 20240911113955_T2gpw | USL005 | 2024-09-15T12:18:32.240Z | 2024-09-19T12:21:49.009Z |
5082912 | 5082912 | 20240911112556_gNXH1 | USL005 | 2024-09-15T12:18:30.825Z | 2024-09-19T12:21:48.876Z |
5082803 | 5082803 | 20240911110043_z2v6t | USL005 | 2024-09-15T12:18:25.847Z | 2024-09-19T12:21:48.688Z |
5082799 | 5082799 | 20240911110023_RN22L | USL005 | 2024-09-15T12:18:25.743Z | 2024-09-19T12:21:48.686Z |
5082776 | 5082776 | 20240911105654_ee9X9 | USL005 | 2024-09-15T12:18:25.268Z | 2024-09-19T12:21:48.653Z |
5082738 | 5082738 | 20240911105207_TxmQN | USL005 | 2024-09-15T12:18:24.270Z | 2024-09-19T12:21:48.494Z |
5082636 | 5082636 | 20240911103803_s6xOj | USL005 | 2024-09-15T12:18:21.622Z | 2024-09-19T12:21:48.288Z |
5082607 | 5082607 | 20240911103529_ntCDV | USL005 | 2024-09-15T12:18:20.943Z | 2024-09-19T12:21:48.180Z |
5082596 | 5082596 | 20240911103340_2OZGY | USL005 | 2024-09-15T12:18:20.647Z | 2024-09-19T12:21:48.177Z |
5082579 | 5082579 | 20240911102930_4Ystb | USL005 | 2024-09-15T12:18:20.411Z | 2024-09-19T12:21:48.129Z |
5082563 | 5082563 | 20240911102816_so05c | USL005 | 2024-09-15T12:18:20.288Z | 2024-09-19T12:21:48.118Z |
5082525 | 5082525 | 20240911102044_2oOQk | USL005 | 2024-09-15T12:18:17.337Z | 2024-09-19T12:21:48.037Z |
5082502 | 5082502 | 20240911101908_RpGAx | USL005 | 2024-09-15T12:18:16.693Z | 2024-09-19T12:21:48.016Z |
5082492 | 5082492 | 20240911101705_O8pyB | USL005 | 2024-09-15T12:18:16.510Z | 2024-09-19T12:21:48.000Z |
5082363 | 5082363 | 20240911095922_YGPZ2 | USL005 | 2024-09-15T12:18:12.887Z | 2024-09-19T12:21:47.885Z |
5082357 | 5082357 | 20240911095701_sj8i8 | USL005 | 2024-09-15T12:18:12.274Z | 2024-09-19T12:21:47.868Z |
5082240 | 5082240 | 20240911094411_VSFGW | USL005 | 2024-09-15T12:18:09.003Z | 2024-09-19T12:21:47.564Z |
5082224 | 5082224 | 20240911094019_6LFYd | USL005 | 2024-09-15T12:18:07.439Z | 2024-09-19T12:21:47.538Z |
5082050 | 5082050 | 20240911091527_uTwrR | USL005 | 2024-09-15T12:18:00.725Z | 2024-09-19T12:21:47.118Z |
5081981 | 5081981 | 20240911090901_bJk2g | USL005 | 2024-09-15T12:17:57.234Z | 2024-09-19T12:21:46.946Z |
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);