participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,119 rows where station_code = "USL018" 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 |
---|---|---|---|---|---|
5135675 | 5135675 | 20240914104828_UGApK | USL018 | 2024-09-19T12:20:13.342Z | 2024-09-19T12:20:13.342Z |
5134320 | 5134320 | 20240916081304_v72fR | USL018 | 2024-09-19T12:17:36.678Z | 2024-09-19T12:17:36.678Z |
5134243 | 5134243 | 20240916072151_XsOFb | USL018 | 2024-09-19T12:17:32.897Z | 2024-09-19T12:17:32.897Z |
5134221 | 5134221 | 20240916065736_6RWG2 | USL018 | 2024-09-19T12:17:31.992Z | 2024-09-19T12:17:31.992Z |
5134198 | 5134198 | 20240916063737_XdIVk | USL018 | 2024-09-19T12:17:29.727Z | 2024-09-19T12:17:29.727Z |
5134180 | 5134180 | 20240916061746_a3kc2 | USL018 | 2024-09-19T12:17:28.063Z | 2024-09-19T12:17:28.063Z |
5129637 | 5129637 | 20240917041548_Ws3ae | USL018 | 2024-09-19T12:11:56.461Z | 2024-09-19T12:11:56.461Z |
5126367 | 5126367 | 20240918111408_xbeOo | USL018 | 2024-09-19T12:05:50.294Z | 2024-09-19T12:06:42.189Z |
5126362 | 5126362 | 20240918111255_HogMK | USL018 | 2024-09-19T12:05:49.751Z | 2024-09-19T12:06:42.188Z |
5126303 | 5126303 | 20240918103600_RL252 | USL018 | 2024-09-19T12:05:33.875Z | 2024-09-19T12:06:42.177Z |
5126152 | 5126152 | 20240918084954_RyB23 | USL018 | 2024-09-19T12:05:13.249Z | 2024-09-19T12:06:42.150Z |
5126145 | 5126145 | 20240918084515_iP4jt | USL018 | 2024-09-19T12:05:12.318Z | 2024-09-19T12:06:42.149Z |
5126077 | 5126077 | 20240918075803_zw7Z3 | USL018 | 2024-09-19T12:04:57.489Z | 2024-09-19T12:06:42.136Z |
5126063 | 5126063 | 20240918074628_G6w9V | USL018 | 2024-09-19T12:04:52.788Z | 2024-09-19T12:06:42.133Z |
5125990 | 5125990 | 20240918061349_nr55v | USL018 | 2024-09-19T12:04:42.961Z | 2024-09-19T12:06:42.122Z |
5125962 | 5125962 | 20240918052152_o2RZX | USL018 | 2024-09-19T12:04:38.634Z | 2024-09-19T12:06:42.116Z |
5125937 | 5125937 | 20240918050216_2BILr | USL018 | 2024-09-19T12:04:36.018Z | 2024-09-19T12:06:42.112Z |
5125842 | 5125842 | 20240918041032_oyGUo | USL018 | 2024-09-19T12:04:15.283Z | 2024-09-19T12:06:42.095Z |
5125688 | 5125688 | 20240918032109_6jeFP | USL018 | 2024-09-19T12:03:53.165Z | 2024-09-19T12:06:42.069Z |
5125569 | 5125569 | 20240918030201_Fg6tL | USL018 | 2024-09-19T12:03:32.901Z | 2024-09-19T12:06:42.052Z |
5123832 | 5123832 | 20240914114033_bduqh | USL018 | 2024-09-18T12:11:58.519Z | 2024-09-19T12:20:15.682Z |
5123680 | 5123680 | 20240914110335_gKIy1 | USL018 | 2024-09-18T12:11:53.923Z | 2024-09-19T12:20:13.754Z |
5123639 | 5123639 | 20240914105308_FkB3c | USL018 | 2024-09-18T12:11:52.867Z | 2024-09-19T12:20:13.405Z |
5123631 | 5123631 | 20240914105139_W2Ory | USL018 | 2024-09-18T12:11:52.780Z | 2024-09-19T12:20:13.391Z |
5123623 | 5123623 | 20240914104820_4KGy2 | USL018 | 2024-09-18T12:11:52.593Z | 2024-09-19T12:20:13.324Z |
5123563 | 5123563 | 20240914103412_eBeM6 | USL018 | 2024-09-18T12:11:51.380Z | 2024-09-19T12:20:12.636Z |
5123498 | 5123498 | 20240914102011_Rb22K | USL018 | 2024-09-18T12:11:50.378Z | 2024-09-19T12:20:11.344Z |
5123465 | 5123465 | 20240914101336_lcJaI | USL018 | 2024-09-18T12:11:49.754Z | 2024-09-19T12:20:11.156Z |
5123408 | 5123408 | 20240914095924_Mu12k | USL018 | 2024-09-18T12:11:47.964Z | 2024-09-19T12:20:10.758Z |
5123361 | 5123361 | 20240914095152_D3WwZ | USL018 | 2024-09-18T12:11:46.757Z | 2024-09-19T12:20:10.568Z |
5123358 | 5123358 | 20240914095135_OGgYb | USL018 | 2024-09-18T12:11:46.525Z | 2024-09-19T12:20:10.530Z |
5123330 | 5123330 | 20240914094641_boaeZ | USL018 | 2024-09-18T12:11:45.294Z | 2024-09-19T12:20:10.415Z |
5123324 | 5123324 | 20240914094617_x28bk | USL018 | 2024-09-18T12:11:45.289Z | 2024-09-19T12:20:10.376Z |
5123317 | 5123317 | 20240914094344_FaWhm | USL018 | 2024-09-18T12:11:45.214Z | 2024-09-19T12:20:10.351Z |
5123219 | 5123219 | 20240914091845_VdRq7 | USL018 | 2024-09-18T12:11:42.623Z | 2024-09-19T12:20:09.023Z |
5123200 | 5123200 | 20240914091637_C3hPq | USL018 | 2024-09-18T12:11:42.276Z | 2024-09-19T12:20:08.919Z |
5123187 | 5123187 | 20240914091343_hDgLa | USL018 | 2024-09-18T12:11:42.067Z | 2024-09-19T12:20:08.876Z |
5123176 | 5123176 | 20240914091252_4u30v | USL018 | 2024-09-18T12:11:41.660Z | 2024-09-19T12:20:08.591Z |
5123138 | 5123138 | 20240914090021_iYd8u | USL018 | 2024-09-18T12:11:40.688Z | 2024-09-19T12:20:08.401Z |
5123104 | 5123104 | 20240914085339_CusZS | USL018 | 2024-09-18T12:11:39.966Z | 2024-09-19T12:20:07.707Z |
5123020 | 5123020 | 20240914084045_e6XCB | USL018 | 2024-09-18T12:11:38.212Z | 2024-09-19T12:20:07.328Z |
5122988 | 5122988 | 20240914083444_O8WTw | USL018 | 2024-09-18T12:11:36.999Z | 2024-09-19T12:20:07.105Z |
5122886 | 5122886 | 20240914081544_LmJ39 | USL018 | 2024-09-18T12:11:33.387Z | 2024-09-19T12:20:06.634Z |
5122807 | 5122807 | 20240914080212_ErnKI | USL018 | 2024-09-18T12:11:31.720Z | 2024-09-19T12:20:06.280Z |
5122792 | 5122792 | 20240914075801_V0o7g | USL018 | 2024-09-18T12:11:31.257Z | 2024-09-19T12:20:06.188Z |
5122763 | 5122763 | 20240914075426_ocgkT | USL018 | 2024-09-18T12:11:30.644Z | 2024-09-19T12:20:06.040Z |
5122717 | 5122717 | 20240914073634_38pOw | USL018 | 2024-09-18T12:11:29.175Z | 2024-09-19T12:20:05.846Z |
5122649 | 5122649 | 20240914072728_7ztSu | USL018 | 2024-09-18T12:11:27.003Z | 2024-09-19T12:20:05.516Z |
5122577 | 5122577 | 20240914071328_jUlGo | USL018 | 2024-09-18T12:11:24.053Z | 2024-09-19T12:20:05.134Z |
5122419 | 5122419 | 20240914061511_axhsA | USL018 | 2024-09-18T12:11:17.794Z | 2024-09-19T12:20:04.251Z |
5122306 | 5122306 | 20240914053106_xc3dJ | USL018 | 2024-09-18T12:11:13.542Z | 2024-09-19T12:20:03.841Z |
5122267 | 5122267 | 20240914051646_93Ktw | USL018 | 2024-09-18T12:11:12.052Z | 2024-09-19T12:20:03.550Z |
5122215 | 5122215 | 20240914045751_tFjqs | USL018 | 2024-09-18T12:11:10.370Z | 2024-09-19T12:20:03.214Z |
5120335 | 5120335 | 20240914031554_CpwnA | USL018 | 2024-09-18T12:10:37.558Z | 2024-09-19T12:19:59.942Z |
5119034 | 5119034 | 20240915121702_XX6ZZ | USL018 | 2024-09-18T12:09:19.771Z | 2024-09-19T12:19:28.468Z |
5118962 | 5118962 | 20240915115042_PX528 | USL018 | 2024-09-18T12:09:15.606Z | 2024-09-19T12:19:27.858Z |
5118953 | 5118953 | 20240915114837_NrR4U | USL018 | 2024-09-18T12:09:14.391Z | 2024-09-19T12:19:27.745Z |
5118825 | 5118825 | 20240915111647_UItIA | USL018 | 2024-09-18T12:09:05.966Z | 2024-09-19T12:19:25.840Z |
5118739 | 5118739 | 20240915105758_h3TuN | USL018 | 2024-09-18T12:09:00.866Z | 2024-09-19T12:19:25.229Z |
5118695 | 5118695 | 20240915104830_SvC76 | USL018 | 2024-09-18T12:08:59.140Z | 2024-09-19T12:19:24.978Z |
5118673 | 5118673 | 20240915104232_iX1Dz | USL018 | 2024-09-18T12:08:57.636Z | 2024-09-19T12:19:24.870Z |
5118665 | 5118665 | 20240915104148_OTz2b | USL018 | 2024-09-18T12:08:57.510Z | 2024-09-19T12:19:24.830Z |
5118649 | 5118649 | 20240915103809_W3Jnj | USL018 | 2024-09-18T12:08:55.860Z | 2024-09-19T12:19:24.735Z |
5118568 | 5118568 | 20240915102007_GvRFF | USL018 | 2024-09-18T12:08:51.343Z | 2024-09-19T12:19:23.920Z |
5118534 | 5118534 | 20240915101114_7Qeh1 | USL018 | 2024-09-18T12:08:50.203Z | 2024-09-19T12:19:23.734Z |
5118499 | 5118499 | 20240915100038_CCjb2 | USL018 | 2024-09-18T12:08:48.699Z | 2024-09-19T12:19:23.427Z |
5118471 | 5118471 | 20240915095408_G62tO | USL018 | 2024-09-18T12:08:46.539Z | 2024-09-19T12:19:23.191Z |
5118394 | 5118394 | 20240915093619_26hGq | USL018 | 2024-09-18T12:08:42.109Z | 2024-09-19T12:19:22.478Z |
5118359 | 5118359 | 20240915092915_SbRD5 | USL018 | 2024-09-18T12:08:39.632Z | 2024-09-19T12:19:22.304Z |
5118341 | 5118341 | 20240915092619_tN5rR | USL018 | 2024-09-18T12:08:38.297Z | 2024-09-19T12:19:22.181Z |
5118336 | 5118336 | 20240915092207_BvQog | USL018 | 2024-09-18T12:08:38.019Z | 2024-09-19T12:19:22.151Z |
5118263 | 5118263 | 20240915090302_yIog5 | USL018 | 2024-09-18T12:08:34.361Z | 2024-09-19T12:19:21.667Z |
5118172 | 5118172 | 20240915084612_SMr2e | USL018 | 2024-09-18T12:08:28.306Z | 2024-09-19T12:19:21.064Z |
5118156 | 5118156 | 20240915084509_seJy1 | USL018 | 2024-09-18T12:08:27.594Z | 2024-09-19T12:19:20.940Z |
5117926 | 5117926 | 20240915074739_KnYQh | USL018 | 2024-09-18T12:08:07.567Z | 2024-09-19T12:19:18.989Z |
5117830 | 5117830 | 20240915071549_Vepmt | USL018 | 2024-09-18T12:08:02.200Z | 2024-09-19T12:19:18.320Z |
5117816 | 5117816 | 20240915070855_VU36u | USL018 | 2024-09-18T12:08:01.225Z | 2024-09-19T12:19:18.175Z |
5117808 | 5117808 | 20240915070713_Kynf8 | USL018 | 2024-09-18T12:08:00.786Z | 2024-09-19T12:19:18.137Z |
5117805 | 5117805 | 20240915070701_2ki3n | USL018 | 2024-09-18T12:08:00.593Z | 2024-09-19T12:19:18.116Z |
5117788 | 5117788 | 20240915070226_6hJKX | USL018 | 2024-09-18T12:07:59.585Z | 2024-09-19T12:19:17.946Z |
5117764 | 5117764 | 20240915065100_p5UMP | USL018 | 2024-09-18T12:07:56.887Z | 2024-09-19T12:19:17.648Z |
5117718 | 5117718 | 20240915063557_nT9Zw | USL018 | 2024-09-18T12:07:53.434Z | 2024-09-19T12:19:17.180Z |
5117684 | 5117684 | 20240915062035_mFxpG | USL018 | 2024-09-18T12:07:51.975Z | 2024-09-19T12:19:16.918Z |
5117633 | 5117633 | 20240915055601_gzcXa | USL018 | 2024-09-18T12:07:50.166Z | 2024-09-19T12:19:16.613Z |
5117621 | 5117621 | 20240915055216_BfplS | USL018 | 2024-09-18T12:07:49.542Z | 2024-09-19T12:19:16.501Z |
5117581 | 5117581 | 20240915053633_QWOeY | USL018 | 2024-09-18T12:07:47.805Z | 2024-09-19T12:19:16.131Z |
5117312 | 5117312 | 20240915041722_7jUpl | USL018 | 2024-09-18T12:07:37.678Z | 2024-09-19T12:19:14.255Z |
5117186 | 5117186 | 20240915041041_b6iFW | USL018 | 2024-09-18T12:07:34.753Z | 2024-09-19T12:19:13.759Z |
5110473 | 5110473 | 20240911075417_EPoDj | USL018 | 2024-09-17T12:18:12.888Z | 2024-09-19T12:21:45.621Z |
5110129 | 5110129 | 20240913120836_b26mH | USL018 | 2024-09-17T12:14:57.241Z | 2024-09-19T12:20:55.802Z |
5110120 | 5110120 | 20240913120708_LNhBk | USL018 | 2024-09-17T12:14:57.115Z | 2024-09-19T12:20:55.780Z |
5110055 | 5110055 | 20240913115457_jv33f | USL018 | 2024-09-17T12:14:55.894Z | 2024-09-19T12:20:55.695Z |
5110020 | 5110020 | 20240913114917_Qd63n | USL018 | 2024-09-17T12:14:54.727Z | 2024-09-19T12:20:55.639Z |
5110005 | 5110005 | 20240913114640_mJFXV | USL018 | 2024-09-17T12:14:54.264Z | 2024-09-19T12:20:55.606Z |
5109913 | 5109913 | 20240913113542_QJF6g | USL018 | 2024-09-17T12:14:49.161Z | 2024-09-19T12:20:55.343Z |
5109891 | 5109891 | 20240913113331_Tiyi4 | USL018 | 2024-09-17T12:14:48.689Z | 2024-09-19T12:20:55.247Z |
5109878 | 5109878 | 20240913112630_LgKXv | USL018 | 2024-09-17T12:14:48.187Z | 2024-09-19T12:20:55.214Z |
5109840 | 5109840 | 20240913111912_GEgYX | USL018 | 2024-09-17T12:14:47.516Z | 2024-09-19T12:20:54.932Z |
5109838 | 5109838 | 20240913111834_NIdTR | USL018 | 2024-09-17T12:14:47.397Z | 2024-09-19T12:20:54.916Z |
5109784 | 5109784 | 20240913110502_aqdzM | USL018 | 2024-09-17T12:14:46.035Z | 2024-09-19T12:20:54.742Z |
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);