participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
21,407 rows where station_code = "USL002" 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 |
---|---|---|---|---|---|
5130299 | 5130299 | 20240917110723_xkX2H | USL002 | 2024-09-19T12:12:57.444Z | 2024-09-19T12:12:57.444Z |
5130269 | 5130269 | 20240917105640_0hgn2 | USL002 | 2024-09-19T12:12:54.362Z | 2024-09-19T12:12:54.362Z |
5130229 | 5130229 | 20240917103353_hUcWD | USL002 | 2024-09-19T12:12:48.462Z | 2024-09-19T12:12:48.462Z |
5130186 | 5130186 | 20240917100647_6PnEy | USL002 | 2024-09-19T12:12:44.683Z | 2024-09-19T12:12:44.683Z |
5130182 | 5130182 | 20240917100326_GtDCc | USL002 | 2024-09-19T12:12:44.166Z | 2024-09-19T12:12:44.166Z |
5130173 | 5130173 | 20240917095754_42EYD | USL002 | 2024-09-19T12:12:43.051Z | 2024-09-19T12:12:43.051Z |
5130145 | 5130145 | 20240917093334_vkQBn | USL002 | 2024-09-19T12:12:40.007Z | 2024-09-19T12:12:40.007Z |
5130134 | 5130134 | 20240917092145_ums1m | USL002 | 2024-09-19T12:12:38.706Z | 2024-09-19T12:12:38.706Z |
5130116 | 5130116 | 20240917091504_3oE1e | USL002 | 2024-09-19T12:12:36.348Z | 2024-09-19T12:12:36.348Z |
5129958 | 5129958 | 20240917070401_GNqqu | USL002 | 2024-09-19T12:12:20.022Z | 2024-09-19T12:12:20.022Z |
5129017 | 5129017 | 20240917030825_GeMsC | USL002 | 2024-09-19T12:11:11.607Z | 2024-09-19T12:11:11.607Z |
5128919 | 5128919 | 20240917025427_08JtW | USL002 | 2024-09-19T12:11:07.261Z | 2024-09-19T12:11:07.261Z |
5126480 | 5126480 | 20240918121513_bDCRk | USL002 | 2024-09-19T12:06:03.148Z | 2024-09-19T12:06:42.208Z |
5107574 | 5107574 | 20240913040235_AiJFj | USL002 | 2024-09-17T12:13:17.534Z | 2024-09-19T12:20:47.278Z |
5107234 | 5107234 | 20240913034756_okmil | USL002 | 2024-09-17T12:13:11.289Z | 2024-09-19T12:20:46.943Z |
5105467 | 5105467 | 20240913024716_KLbq3 | USL002 | 2024-09-17T12:12:18.214Z | 2024-09-19T12:20:44.588Z |
5096911 | 5096911 | 20240912121352_SxHQD | USL002 | 2024-09-16T12:16:37.419Z | 2024-09-19T12:21:24.200Z |
5096899 | 5096899 | 20240912120916_VAYy4 | USL002 | 2024-09-16T12:16:37.013Z | 2024-09-19T12:21:24.146Z |
5096872 | 5096872 | 20240912120122_29K1Y | USL002 | 2024-09-16T12:16:36.413Z | 2024-09-19T12:21:24.047Z |
5096816 | 5096816 | 20240912115400_1QeWS | USL002 | 2024-09-16T12:16:35.299Z | 2024-09-19T12:21:23.967Z |
5096800 | 5096800 | 20240912114824_2F7DO | USL002 | 2024-09-16T12:16:35.026Z | 2024-09-19T12:21:23.810Z |
5096739 | 5096739 | 20240912113533_2khjl | USL002 | 2024-09-16T12:16:33.667Z | 2024-09-19T12:21:23.535Z |
5096683 | 5096683 | 20240912113020_E3XV6 | USL002 | 2024-09-16T12:16:31.547Z | 2024-09-19T12:21:23.423Z |
5096618 | 5096618 | 20240912112444_hb8YP | USL002 | 2024-09-16T12:16:29.899Z | 2024-09-19T12:21:23.296Z |
5096612 | 5096612 | 20240912112318_flsUK | USL002 | 2024-09-16T12:16:29.753Z | 2024-09-19T12:21:23.272Z |
5096609 | 5096609 | 20240912112253_rHsFS | USL002 | 2024-09-16T12:16:29.663Z | 2024-09-19T12:21:23.270Z |
5096577 | 5096577 | 20240912111643_D1rXZ | USL002 | 2024-09-16T12:16:27.878Z | 2024-09-19T12:21:22.905Z |
5096546 | 5096546 | 20240912111025_pemTp | USL002 | 2024-09-16T12:16:27.367Z | 2024-09-19T12:21:22.723Z |
5096516 | 5096516 | 20240912110651_ikQVD | USL002 | 2024-09-16T12:16:26.058Z | 2024-09-19T12:21:22.485Z |
5096494 | 5096494 | 20240912110125_wZhYU | USL002 | 2024-09-16T12:16:25.045Z | 2024-09-19T12:21:22.410Z |
5096430 | 5096430 | 20240912104934_Djg3C | USL002 | 2024-09-16T12:16:23.369Z | 2024-09-19T12:21:22.304Z |
5096390 | 5096390 | 20240912104249_qPXEi | USL002 | 2024-09-16T12:16:22.322Z | 2024-09-19T12:21:22.238Z |
5096389 | 5096389 | 20240912104245_SjDRr | USL002 | 2024-09-16T12:16:22.184Z | 2024-09-19T12:21:22.225Z |
5096265 | 5096265 | 20240912102546_phlzu | USL002 | 2024-09-16T12:16:17.468Z | 2024-09-19T12:21:21.986Z |
5096253 | 5096253 | 20240912102506_xbkzd | USL002 | 2024-09-16T12:16:17.166Z | 2024-09-19T12:21:21.970Z |
5096214 | 5096214 | 20240912101851_xqITA | USL002 | 2024-09-16T12:16:15.780Z | 2024-09-19T12:21:21.911Z |
5096109 | 5096109 | 20240912100223_KOmm1 | USL002 | 2024-09-16T12:16:10.269Z | 2024-09-19T12:21:21.541Z |
5096104 | 5096104 | 20240912100215_Qu12E | USL002 | 2024-09-16T12:16:10.194Z | 2024-09-19T12:21:21.532Z |
5096097 | 5096097 | 20240912095920_j6lri | USL002 | 2024-09-16T12:16:09.772Z | 2024-09-19T12:21:21.464Z |
5096078 | 5096078 | 20240912095233_88Pof | USL002 | 2024-09-16T12:16:08.684Z | 2024-09-19T12:21:21.284Z |
5095996 | 5095996 | 20240912093903_EmRaC | USL002 | 2024-09-16T12:16:04.806Z | 2024-09-19T12:21:20.849Z |
5095975 | 5095975 | 20240912093652_5DORt | USL002 | 2024-09-16T12:16:04.110Z | 2024-09-19T12:21:20.802Z |
5095953 | 5095953 | 20240912093158_2wtIv | USL002 | 2024-09-16T12:16:03.319Z | 2024-09-19T12:21:20.717Z |
5095949 | 5095949 | 20240912093154_XjQRU | USL002 | 2024-09-16T12:16:03.111Z | 2024-09-19T12:21:20.705Z |
5095932 | 5095932 | 20240912092911_KvvU6 | USL002 | 2024-09-16T12:16:02.331Z | 2024-09-19T12:21:20.671Z |
5095861 | 5095861 | 20240912091954_0a6T5 | USL002 | 2024-09-16T12:16:00.920Z | 2024-09-19T12:21:20.564Z |
5095679 | 5095679 | 20240912084520_xz4ss | USL002 | 2024-09-16T12:15:52.944Z | 2024-09-19T12:21:19.665Z |
5095677 | 5095677 | 20240912084503_YEYid | USL002 | 2024-09-16T12:15:52.767Z | 2024-09-19T12:21:19.660Z |
5095662 | 5095662 | 20240912083637_x8sWM | USL002 | 2024-09-16T12:15:52.463Z | 2024-09-19T12:21:19.638Z |
5095560 | 5095560 | 20240912080344_clFBw | USL002 | 2024-09-16T12:15:49.003Z | 2024-09-19T12:21:19.087Z |
5095468 | 5095468 | 20240912074017_eXq7a | USL002 | 2024-09-16T12:15:41.966Z | 2024-09-19T12:21:18.613Z |
5095447 | 5095447 | 20240912073330_3q5PD | USL002 | 2024-09-16T12:15:40.531Z | 2024-09-19T12:21:18.552Z |
5095424 | 5095424 | 20240912073021_l32iG | USL002 | 2024-09-16T12:15:39.821Z | 2024-09-19T12:21:18.518Z |
5095383 | 5095383 | 20240912072415_PKa0Z | USL002 | 2024-09-16T12:15:38.171Z | 2024-09-19T12:21:18.381Z |
5095339 | 5095339 | 20240912071933_Z29Ve | USL002 | 2024-09-16T12:15:33.868Z | 2024-09-19T12:21:18.189Z |
5095306 | 5095306 | 20240912070614_V58JA | USL002 | 2024-09-16T12:15:31.715Z | 2024-09-19T12:21:18.069Z |
5095274 | 5095274 | 20240912065828_LaYmf | USL002 | 2024-09-16T12:15:29.004Z | 2024-09-19T12:21:17.910Z |
5095266 | 5095266 | 20240912065518_tUiI4 | USL002 | 2024-09-16T12:15:28.633Z | 2024-09-19T12:21:17.852Z |
5095244 | 5095244 | 20240912065132_JL2Qk | USL002 | 2024-09-16T12:15:27.597Z | 2024-09-19T12:21:17.673Z |
5095241 | 5095241 | 20240912065047_PLX2Z | USL002 | 2024-09-16T12:15:27.305Z | 2024-09-19T12:21:17.652Z |
5095163 | 5095163 | 20240912062137_L7VJg | USL002 | 2024-09-16T12:15:19.692Z | 2024-09-19T12:21:17.412Z |
5094895 | 5094895 | 20240912043452_Fg9tv | USL002 | 2024-09-16T12:15:01.024Z | 2024-09-19T12:21:16.540Z |
5094088 | 5094088 | 20240912034740_FHJ6E | USL002 | 2024-09-16T12:14:33.872Z | 2024-09-19T12:21:15.878Z |
5094040 | 5094040 | 20240912034603_zTuKf | USL002 | 2024-09-16T12:14:31.882Z | 2024-09-19T12:21:15.840Z |
5093903 | 5093903 | 20240912034021_5MTdw | USL002 | 2024-09-16T12:14:27.282Z | 2024-09-19T12:21:15.731Z |
5093263 | 5093263 | 20240912031526_Z2og4 | USL002 | 2024-09-16T12:14:13.763Z | 2024-09-19T12:21:15.070Z |
5092749 | 5092749 | 20240912025616_mmkZn | USL002 | 2024-09-16T12:14:03.195Z | 2024-09-19T12:21:14.506Z |
5092545 | 5092545 | 20240912025002_9C2QT | USL002 | 2024-09-16T12:13:59.505Z | 2024-09-19T12:21:14.340Z |
5082601 | 5082601 | 20240911103510_fQWSe | USL002 | 2024-09-15T12:18:20.867Z | 2024-09-19T12:21:48.180Z |
5082208 | 5082208 | 20240911093725_2n2Oi | USL002 | 2024-09-15T12:18:06.795Z | 2024-09-19T12:21:47.526Z |
5082163 | 5082163 | 20240911093149_vFEzH | USL002 | 2024-09-15T12:18:05.446Z | 2024-09-19T12:21:47.320Z |
5082009 | 5082009 | 20240911091222_9fnjU | USL002 | 2024-09-15T12:17:59.372Z | 2024-09-19T12:21:47.043Z |
5081920 | 5081920 | 20240911090322_VNnRU | USL002 | 2024-09-15T12:17:54.499Z | 2024-09-19T12:21:46.769Z |
5081846 | 5081846 | 20240911085144_XT9eu | USL002 | 2024-09-15T12:17:51.050Z | 2024-09-19T12:21:46.566Z |
5081780 | 5081780 | 20240911084203_wkCOX | USL002 | 2024-09-15T12:17:47.161Z | 2024-09-19T12:21:46.417Z |
5081752 | 5081752 | 20240911083859_ZLr0C | USL002 | 2024-09-15T12:17:45.825Z | 2024-09-19T12:21:46.377Z |
5081439 | 5081439 | 20240911074421_hraCQ | USL002 | 2024-09-15T12:17:33.345Z | 2024-09-19T12:21:45.376Z |
5081344 | 5081344 | 20240911072921_qM4rm | USL002 | 2024-09-15T12:17:30.859Z | 2024-09-19T12:21:45.147Z |
5081177 | 5081177 | 20240911064723_qzX3b | USL002 | 2024-09-15T12:17:25.821Z | 2024-09-19T12:21:44.697Z |
5081168 | 5081168 | 20240911064408_yf3Z0 | USL002 | 2024-09-15T12:17:25.438Z | 2024-09-19T12:21:44.688Z |
5081114 | 5081114 | 20240911063741_ZmBkX | USL002 | 2024-09-15T12:17:24.240Z | 2024-09-19T12:21:44.657Z |
5081054 | 5081054 | 20240911061650_t3xNz | USL002 | 2024-09-15T12:17:22.128Z | 2024-09-19T12:21:44.521Z |
5080905 | 5080905 | 20240911052214_xXTFJ | USL002 | 2024-09-15T12:17:16.973Z | 2024-09-19T12:21:44.038Z |
5080770 | 5080770 | 20240911044353_psbdW | USL002 | 2024-09-15T12:17:12.756Z | 2024-09-19T12:21:43.637Z |
5080729 | 5080729 | 20240911043105_xEQUY | USL002 | 2024-09-15T12:17:11.513Z | 2024-09-19T12:21:43.445Z |
5080422 | 5080422 | 20240911035651_O5GbI | USL002 | 2024-09-15T12:17:03.165Z | 2024-09-19T12:21:43.283Z |
5079314 | 5079314 | 20240911024740_FQwNQ | USL002 | 2024-09-15T12:16:15.013Z | 2024-09-19T12:21:41.413Z |
5070429 | 5070429 | 20240909070112_3tt1L | USL002 | 2024-09-14T12:21:08.867Z | 2024-09-17T12:19:05.604Z |
5068649 | 5068649 | 20240910115840_kwjwF | USL002 | 2024-09-14T12:19:19.907Z | 2024-09-18T12:15:26.438Z |
5068632 | 5068632 | 20240910115653_Tk4Vj | USL002 | 2024-09-14T12:19:19.775Z | 2024-09-18T12:15:26.428Z |
5068568 | 5068568 | 20240910115026_vwzL3 | USL002 | 2024-09-14T12:19:18.220Z | 2024-09-18T12:15:26.325Z |
5068522 | 5068522 | 20240910114601_hCwF2 | USL002 | 2024-09-14T12:19:17.127Z | 2024-09-18T12:15:26.260Z |
5068518 | 5068518 | 20240910114350_P3GBK | USL002 | 2024-09-14T12:19:17.022Z | 2024-09-18T12:15:26.257Z |
5068466 | 5068466 | 20240910113638_VMKDg | USL002 | 2024-09-14T12:19:16.149Z | 2024-09-18T12:15:26.189Z |
5068413 | 5068413 | 20240910112916_NAUEn | USL002 | 2024-09-14T12:19:14.969Z | 2024-09-18T12:15:26.109Z |
5068148 | 5068148 | 20240910110316_fJCTC | USL002 | 2024-09-14T12:19:09.912Z | 2024-09-18T12:15:25.671Z |
5068088 | 5068088 | 20240910105230_on01E | USL002 | 2024-09-14T12:19:08.642Z | 2024-09-18T12:15:25.541Z |
5068063 | 5068063 | 20240910104851_33XWt | USL002 | 2024-09-14T12:19:07.977Z | 2024-09-18T12:15:25.495Z |
5067993 | 5067993 | 20240910103948_Af8iz | USL002 | 2024-09-14T12:19:06.570Z | 2024-09-18T12:15:25.345Z |
5067945 | 5067945 | 20240910103518_sG2gx | USL002 | 2024-09-14T12:19:05.541Z | 2024-09-18T12:15:25.170Z |
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);