participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,693 rows where station_code = "USL013" 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 |
---|---|---|---|---|---|
5129874 | 5129874 | 20240917050234_QQ8UU | USL013 | 2024-09-19T12:12:12.249Z | 2024-09-19T12:12:12.249Z |
5126398 | 5126398 | 20240918112601_NxdKv | USL013 | 2024-09-19T12:05:53.942Z | 2024-09-19T12:06:42.194Z |
5126326 | 5126326 | 20240918105717_ti32a | USL013 | 2024-09-19T12:05:45.629Z | 2024-09-19T12:06:42.182Z |
5126256 | 5126256 | 20240918101915_eYj0S | USL013 | 2024-09-19T12:05:27.415Z | 2024-09-19T12:06:42.169Z |
5126183 | 5126183 | 20240918091827_M2EAV | USL013 | 2024-09-19T12:05:17.889Z | 2024-09-19T12:06:42.156Z |
5126178 | 5126178 | 20240918091621_lAziM | USL013 | 2024-09-19T12:05:17.319Z | 2024-09-19T12:06:42.155Z |
5126059 | 5126059 | 20240918074349_FzRyZ | USL013 | 2024-09-19T12:04:52.289Z | 2024-09-19T12:06:42.133Z |
5123897 | 5123897 | 20240914115846_vHQOC | USL013 | 2024-09-18T12:11:59.565Z | 2024-09-19T12:20:16.157Z |
5123862 | 5123862 | 20240914114847_4mHE1 | USL013 | 2024-09-18T12:11:58.939Z | 2024-09-19T12:20:15.838Z |
5123838 | 5123838 | 20240914114218_2f3hz | USL013 | 2024-09-18T12:11:58.531Z | 2024-09-19T12:20:15.725Z |
5123799 | 5123799 | 20240914113248_9qm52 | USL013 | 2024-09-18T12:11:57.882Z | 2024-09-19T12:20:15.339Z |
5123736 | 5123736 | 20240914111733_w3K3L | USL013 | 2024-09-18T12:11:55.387Z | 2024-09-19T12:20:14.341Z |
5123670 | 5123670 | 20240914110237_TcynA | USL013 | 2024-09-18T12:11:53.788Z | 2024-09-19T12:20:13.719Z |
5123637 | 5123637 | 20240914105308_FkB3c | USL013 | 2024-09-18T12:11:52.867Z | 2024-09-19T12:20:13.405Z |
5123555 | 5123555 | 20240914103258_pOIWF | USL013 | 2024-09-18T12:11:51.328Z | 2024-09-19T12:20:12.600Z |
5123434 | 5123434 | 20240914100522_0Xe5U | USL013 | 2024-09-18T12:11:48.663Z | 2024-09-19T12:20:11.015Z |
5123315 | 5123315 | 20240914094344_FaWhm | USL013 | 2024-09-18T12:11:45.214Z | 2024-09-19T12:20:10.351Z |
5123303 | 5123303 | 20240914093712_6HV5P | USL013 | 2024-09-18T12:11:45.056Z | 2024-09-19T12:20:10.149Z |
5123286 | 5123286 | 20240914093500_k2wcZ | USL013 | 2024-09-18T12:11:44.035Z | 2024-09-19T12:20:09.331Z |
5123179 | 5123179 | 20240914091309_8oLMb | USL013 | 2024-09-18T12:11:41.756Z | 2024-09-19T12:20:08.605Z |
5123114 | 5123114 | 20240914085513_fVsmy | USL013 | 2024-09-18T12:11:40.061Z | 2024-09-19T12:20:07.741Z |
5123077 | 5123077 | 20240914084826_ol4mp | USL013 | 2024-09-18T12:11:39.552Z | 2024-09-19T12:20:07.580Z |
5123001 | 5123001 | 20240914083721_N2MWr | USL013 | 2024-09-18T12:11:37.548Z | 2024-09-19T12:20:07.205Z |
5122874 | 5122874 | 20240914081512_E0T9r | USL013 | 2024-09-18T12:11:33.283Z | 2024-09-19T12:20:06.578Z |
5122868 | 5122868 | 20240914081333_8HJr3 | USL013 | 2024-09-18T12:11:32.935Z | 2024-09-19T12:20:06.542Z |
5122554 | 5122554 | 20240914070624_1n6ou | USL013 | 2024-09-18T12:11:23.130Z | 2024-09-19T12:20:04.967Z |
5119025 | 5119025 | 20240915121306_v3Wv1 | USL013 | 2024-09-18T12:09:19.385Z | 2024-09-19T12:19:28.341Z |
5118952 | 5118952 | 20240915114837_NrR4U | USL013 | 2024-09-18T12:09:14.391Z | 2024-09-19T12:19:27.745Z |
5118863 | 5118863 | 20240915112048_UsAio | USL013 | 2024-09-18T12:09:09.925Z | 2024-09-19T12:19:26.692Z |
5118701 | 5118701 | 20240915104913_65L7Z | USL013 | 2024-09-18T12:08:59.362Z | 2024-09-19T12:19:24.999Z |
5118577 | 5118577 | 20240915102130_EZD0v | USL013 | 2024-09-18T12:08:51.723Z | 2024-09-19T12:19:24.009Z |
5118513 | 5118513 | 20240915100303_TMru2 | USL013 | 2024-09-18T12:08:49.292Z | 2024-09-19T12:19:23.515Z |
5118443 | 5118443 | 20240915094740_3l1eI | USL013 | 2024-09-18T12:08:44.381Z | 2024-09-19T12:19:22.953Z |
5118334 | 5118334 | 20240915092207_BvQog | USL013 | 2024-09-18T12:08:38.019Z | 2024-09-19T12:19:22.151Z |
5117891 | 5117891 | 20240915073837_pw9FO | USL013 | 2024-09-18T12:08:05.091Z | 2024-09-19T12:19:18.759Z |
5117593 | 5117593 | 20240915054007_WqUcO | USL013 | 2024-09-18T12:07:48.219Z | 2024-09-19T12:19:16.253Z |
5117579 | 5117579 | 20240915053633_QWOeY | USL013 | 2024-09-18T12:07:47.805Z | 2024-09-19T12:19:16.131Z |
5116907 | 5116907 | 20240915034814_alspD | USL013 | 2024-09-18T12:07:25.294Z | 2024-09-19T12:19:12.648Z |
5110115 | 5110115 | 20240913120604_W7eW8 | USL013 | 2024-09-17T12:14:57.079Z | 2024-09-19T12:20:55.770Z |
5110075 | 5110075 | 20240913120220_c1u5F | USL013 | 2024-09-17T12:14:56.623Z | 2024-09-19T12:20:55.735Z |
5109991 | 5109991 | 20240913114432_atp7e | USL013 | 2024-09-17T12:14:53.291Z | 2024-09-19T12:20:55.569Z |
5109975 | 5109975 | 20240913114227_3mAuP | USL013 | 2024-09-17T12:14:52.387Z | 2024-09-19T12:20:55.523Z |
5109969 | 5109969 | 20240913114214_JzPHs | USL013 | 2024-09-17T12:14:52.327Z | 2024-09-19T12:20:55.517Z |
5109869 | 5109869 | 20240913112540_dbRy3 | USL013 | 2024-09-17T12:14:48.090Z | 2024-09-19T12:20:55.185Z |
5109849 | 5109849 | 20240913112257_sbTg3 | USL013 | 2024-09-17T12:14:47.683Z | 2024-09-19T12:20:54.965Z |
5109846 | 5109846 | 20240913112240_TbiaM | USL013 | 2024-09-17T12:14:47.618Z | 2024-09-19T12:20:54.964Z |
5109828 | 5109828 | 20240913111446_uF2DK | USL013 | 2024-09-17T12:14:47.095Z | 2024-09-19T12:20:54.866Z |
5109793 | 5109793 | 20240913110614_Wq9w3 | USL013 | 2024-09-17T12:14:46.115Z | 2024-09-19T12:20:54.761Z |
5109782 | 5109782 | 20240913110502_aqdzM | USL013 | 2024-09-17T12:14:46.035Z | 2024-09-19T12:20:54.742Z |
5109738 | 5109738 | 20240913110224_5J3sW | USL013 | 2024-09-17T12:14:45.227Z | 2024-09-19T12:20:54.663Z |
5109706 | 5109706 | 20240913105033_ozsqA | USL013 | 2024-09-17T12:14:44.337Z | 2024-09-19T12:20:54.544Z |
5109597 | 5109597 | 20240913103433_uvt3D | USL013 | 2024-09-17T12:14:41.936Z | 2024-09-19T12:20:53.808Z |
5109514 | 5109514 | 20240913101033_2Se8m | USL013 | 2024-09-17T12:14:39.940Z | 2024-09-19T12:20:53.604Z |
5109405 | 5109405 | 20240913095032_u8XTz | USL013 | 2024-09-17T12:14:37.469Z | 2024-09-19T12:20:53.227Z |
5109382 | 5109382 | 20240913094500_aooHR | USL013 | 2024-09-17T12:14:36.984Z | 2024-09-19T12:20:53.179Z |
5109310 | 5109310 | 20240913093108_8937b | USL013 | 2024-09-17T12:14:35.281Z | 2024-09-19T12:20:52.830Z |
5109131 | 5109131 | 20240913085421_2WTSY | USL013 | 2024-09-17T12:14:31.115Z | 2024-09-19T12:20:51.793Z |
5109057 | 5109057 | 20240913083621_dzvrr | USL013 | 2024-09-17T12:14:28.425Z | 2024-09-19T12:20:51.573Z |
5108909 | 5108909 | 20240913080222_aRa39 | USL013 | 2024-09-17T12:14:16.777Z | 2024-09-19T12:20:51.104Z |
5108829 | 5108829 | 20240913074143_IsHfi | USL013 | 2024-09-17T12:14:09.069Z | 2024-09-19T12:20:50.906Z |
5108649 | 5108649 | 20240913065354_wawd0 | USL013 | 2024-09-17T12:13:55.644Z | 2024-09-19T12:20:50.170Z |
5108582 | 5108582 | 20240913063500_vjTfM | USL013 | 2024-09-17T12:13:51.792Z | 2024-09-19T12:20:49.596Z |
5108567 | 5108567 | 20240913062936_KVWhK | USL013 | 2024-09-17T12:13:51.174Z | 2024-09-19T12:20:49.534Z |
5108530 | 5108530 | 20240913061756_fMwar | USL013 | 2024-09-17T12:13:50.035Z | 2024-09-19T12:20:49.379Z |
5108481 | 5108481 | 20240913055358_GGtya | USL013 | 2024-09-17T12:13:47.162Z | 2024-09-19T12:20:48.958Z |
5108332 | 5108332 | 20240913045344_PDd2q | USL013 | 2024-09-17T12:13:37.172Z | 2024-09-19T12:20:48.243Z |
5107415 | 5107415 | 20240913035459_Wnmb3 | USL013 | 2024-09-17T12:13:14.678Z | 2024-09-19T12:20:47.106Z |
5096876 | 5096876 | 20240912120128_BZ8iw | USL013 | 2024-09-16T12:16:36.542Z | 2024-09-19T12:21:24.049Z |
5096864 | 5096864 | 20240912120027_Stbf8 | USL013 | 2024-09-16T12:16:36.330Z | 2024-09-19T12:21:24.034Z |
5096830 | 5096830 | 20240912115518_D8d8Z | USL013 | 2024-09-16T12:16:35.529Z | 2024-09-19T12:21:23.996Z |
5096693 | 5096693 | 20240912113103_2tr8p | USL013 | 2024-09-16T12:16:31.933Z | 2024-09-19T12:21:23.438Z |
5096628 | 5096628 | 20240912112517_GWyUh | USL013 | 2024-09-16T12:16:30.001Z | 2024-09-19T12:21:23.301Z |
5096348 | 5096348 | 20240912103641_Pnyy0 | USL013 | 2024-09-16T12:16:21.100Z | 2024-09-19T12:21:22.154Z |
5096143 | 5096143 | 20240912100748_QPBCI | USL013 | 2024-09-16T12:16:11.758Z | 2024-09-19T12:21:21.747Z |
5096111 | 5096111 | 20240912100351_gvVUR | USL013 | 2024-09-16T12:16:10.611Z | 2024-09-19T12:21:21.542Z |
5096050 | 5096050 | 20240912094836_VtSw3 | USL013 | 2024-09-16T12:16:06.462Z | 2024-09-19T12:21:21.178Z |
5096020 | 5096020 | 20240912094343_zoH0M | USL013 | 2024-09-16T12:16:05.536Z | 2024-09-19T12:21:20.985Z |
5095961 | 5095961 | 20240912093407_aFSDU | USL013 | 2024-09-16T12:16:03.506Z | 2024-09-19T12:21:20.748Z |
5095825 | 5095825 | 20240912090932_YuPAO | USL013 | 2024-09-16T12:15:59.072Z | 2024-09-19T12:21:20.346Z |
5095810 | 5095810 | 20240912090832_RJJhU | USL013 | 2024-09-16T12:15:58.814Z | 2024-09-19T12:21:20.329Z |
5095743 | 5095743 | 20240912085257_w6n3K | USL013 | 2024-09-16T12:15:55.523Z | 2024-09-19T12:21:19.992Z |
5095577 | 5095577 | 20240912080810_VCYfq | USL013 | 2024-09-16T12:15:49.386Z | 2024-09-19T12:21:19.143Z |
5095551 | 5095551 | 20240912080234_AmPrY | USL013 | 2024-09-16T12:15:48.668Z | 2024-09-19T12:21:19.008Z |
5095485 | 5095485 | 20240912074537_rvQcG | USL013 | 2024-09-16T12:15:43.064Z | 2024-09-19T12:21:18.664Z |
5095432 | 5095432 | 20240912073032_pTRwN | USL013 | 2024-09-16T12:15:40.024Z | 2024-09-19T12:21:18.526Z |
5095283 | 5095283 | 20240912065941_AHcAe | USL013 | 2024-09-16T12:15:29.355Z | 2024-09-19T12:21:17.923Z |
5095092 | 5095092 | 20240912054935_yboVw | USL013 | 2024-09-16T12:15:13.550Z | 2024-09-19T12:21:17.262Z |
5093338 | 5093338 | 20240912031827_Ove7D | USL013 | 2024-09-16T12:14:15.602Z | 2024-09-19T12:21:15.256Z |
5092440 | 5092440 | 20240912024619_80ONG | USL013 | 2024-09-16T12:13:54.397Z | 2024-09-19T12:21:14.110Z |
5092059 | 5092059 | 20240912023604_jTQBf | USL013 | 2024-09-16T12:13:39.459Z | 2024-09-19T12:21:13.616Z |
5083082 | 5083082 | 20240911115545_xmqJy | USL013 | 2024-09-15T12:18:35.186Z | 2024-09-19T12:21:49.274Z |
5083045 | 5083045 | 20240911115104_N1n0U | USL013 | 2024-09-15T12:18:34.331Z | 2024-09-19T12:21:49.163Z |
5083008 | 5083008 | 20240911114613_C7qF6 | USL013 | 2024-09-15T12:18:32.720Z | 2024-09-19T12:21:49.089Z |
5082651 | 5082651 | 20240911103920_fcJ9w | USL013 | 2024-09-15T12:18:21.712Z | 2024-09-19T12:21:48.291Z |
5082611 | 5082611 | 20240911103529_ntCDV | USL013 | 2024-09-15T12:18:20.943Z | 2024-09-19T12:21:48.180Z |
5082503 | 5082503 | 20240911101908_RpGAx | USL013 | 2024-09-15T12:18:16.693Z | 2024-09-19T12:21:48.016Z |
5082468 | 5082468 | 20240911101233_CC1rK | USL013 | 2024-09-15T12:18:15.533Z | 2024-09-19T12:21:47.983Z |
5082403 | 5082403 | 20240911100237_TX8Th | USL013 | 2024-09-15T12:18:14.266Z | 2024-09-19T12:21:47.947Z |
5082365 | 5082365 | 20240911095922_YGPZ2 | USL013 | 2024-09-15T12:18:12.887Z | 2024-09-19T12:21:47.885Z |
5082267 | 5082267 | 20240911094519_JOiIa | USL013 | 2024-09-15T12:18:09.605Z | 2024-09-19T12:21:47.620Z |
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);