participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,874 rows where station_code = "US004Q" 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 |
---|---|---|---|---|---|
5592439 | 5592439 | 20241123032656_RO2Ow | US004Q | 2024-11-24T14:21:01.736Z | 2024-11-24T14:21:11.779Z |
5592417 | 5592417 | 20241123032043_RSrXn | US004Q | 2024-11-24T14:21:00.784Z | 2024-11-24T14:21:11.773Z |
5592316 | 5592316 | 20241123030158_wPV3s | US004Q | 2024-11-24T14:20:53.697Z | 2024-11-24T14:21:11.745Z |
5592198 | 5592198 | 20241123023259_puZ2z | US004Q | 2024-11-24T14:20:45.801Z | 2024-11-24T14:21:11.710Z |
5592163 | 5592163 | 20241123022645_ekyvu | US004Q | 2024-11-24T14:20:42.966Z | 2024-11-24T14:21:11.701Z |
5592043 | 5592043 | 20241123015951_UyxKO | US004Q | 2024-11-24T14:20:35.462Z | 2024-11-24T14:21:11.668Z |
5591753 | 5591753 | 20241123005030_EFJ2O | US004Q | 2024-11-24T14:20:15.994Z | 2024-11-24T14:21:11.581Z |
5591736 | 5591736 | 20241123004348_JdJNY | US004Q | 2024-11-24T14:20:14.909Z | 2024-11-24T14:21:11.577Z |
5586329 | 5586329 | 20241123115040_XIbdL | US004Q | 2024-11-24T14:07:34.161Z | 2024-11-24T14:07:34.161Z |
5586121 | 5586121 | 20241123111203_kBD5Y | US004Q | 2024-11-24T14:07:04.579Z | 2024-11-24T14:07:04.579Z |
5585939 | 5585939 | 20241123104013_bdxbg | US004Q | 2024-11-24T14:06:28.948Z | 2024-11-24T14:06:28.948Z |
5585826 | 5585826 | 20241123102258_FxvfW | US004Q | 2024-11-24T14:06:14.351Z | 2024-11-24T14:06:14.351Z |
5585777 | 5585777 | 20241123101121_b2WcK | US004Q | 2024-11-24T14:06:06.627Z | 2024-11-24T14:06:06.627Z |
5585743 | 5585743 | 20241123100501_AjHKh | US004Q | 2024-11-24T14:06:02.487Z | 2024-11-24T14:06:02.487Z |
5585662 | 5585662 | 20241123095010_d8Syd | US004Q | 2024-11-24T14:05:38.539Z | 2024-11-24T14:05:38.539Z |
5585619 | 5585619 | 20241123094253_oUOoX | US004Q | 2024-11-24T14:05:31.001Z | 2024-11-24T14:05:31.001Z |
5585499 | 5585499 | 20241123091519_KIbKH | US004Q | 2024-11-24T14:05:02.311Z | 2024-11-24T14:05:02.311Z |
5585398 | 5585398 | 20241123085449_owJZV | US004Q | 2024-11-24T14:04:39.929Z | 2024-11-24T14:04:39.929Z |
5585342 | 5585342 | 20241123083729_h31f2 | US004Q | 2024-11-24T14:04:24.691Z | 2024-11-24T14:04:24.691Z |
5585329 | 5585329 | 20241123083618_OrsqW | US004Q | 2024-11-24T14:04:22.468Z | 2024-11-24T14:04:22.468Z |
5585194 | 5585194 | 20241123075603_YYc2r | US004Q | 2024-11-24T14:03:45.945Z | 2024-11-24T14:03:45.945Z |
5585190 | 5585190 | 20241123075546_I2Vtd | US004Q | 2024-11-24T14:03:45.123Z | 2024-11-24T14:03:45.123Z |
5585141 | 5585141 | 20241123074838_bNP3w | US004Q | 2024-11-24T14:03:36.133Z | 2024-11-24T14:03:36.133Z |
5584983 | 5584983 | 20241123071204_0tUuR | US004Q | 2024-11-24T14:03:09.065Z | 2024-11-24T14:03:09.065Z |
5584947 | 5584947 | 20241123070037_EfAap | US004Q | 2024-11-24T14:03:03.462Z | 2024-11-24T14:03:03.462Z |
5584828 | 5584828 | 20241123063405_U6ZoP | US004Q | 2024-11-24T14:02:39.358Z | 2024-11-24T14:02:39.358Z |
5584812 | 5584812 | 20241123062805_N3Nsa | US004Q | 2024-11-24T14:02:36.749Z | 2024-11-24T14:02:36.749Z |
5584793 | 5584793 | 20241123062508_KePct | US004Q | 2024-11-24T14:02:33.274Z | 2024-11-24T14:02:33.274Z |
5584758 | 5584758 | 20241123061449_8stuW | US004Q | 2024-11-24T14:02:24.428Z | 2024-11-24T14:02:24.428Z |
5584720 | 5584720 | 20241123055705_422Wj | US004Q | 2024-11-24T14:02:11.908Z | 2024-11-24T14:02:11.908Z |
5584692 | 5584692 | 20241123054430_pdMTL | US004Q | 2024-11-24T14:02:05.155Z | 2024-11-24T14:02:05.155Z |
5584677 | 5584677 | 20241123054032_O0nGb | US004Q | 2024-11-24T14:02:02.043Z | 2024-11-24T14:02:02.043Z |
5584669 | 5584669 | 20241123053841_LgsxG | US004Q | 2024-11-24T14:02:00.257Z | 2024-11-24T14:02:00.257Z |
5584526 | 5584526 | 20241123045826_ZqFfA | US004Q | 2024-11-24T14:01:22.943Z | 2024-11-24T14:01:22.943Z |
5584264 | 5584264 | 20241123040555_TbU1P | US004Q | 2024-11-24T14:00:25.084Z | 2024-11-24T14:00:25.084Z |
5583324 | 5583324 | 20241121041113_2kbyB | US004Q | 2024-11-23T14:23:52.662Z | 2024-11-24T14:24:02.945Z |
5581957 | 5581957 | 20241122025048_Bgulf | US004Q | 2024-11-23T14:20:51.952Z | 2024-11-24T14:22:35.389Z |
5581742 | 5581742 | 20241122023153_ij2Sa | US004Q | 2024-11-23T14:20:41.474Z | 2024-11-24T14:22:33.221Z |
5581062 | 5581062 | 20241122013818_3rVXH | US004Q | 2024-11-23T14:20:02.592Z | 2024-11-24T14:22:30.653Z |
5580918 | 5580918 | 20241122012359_ZCsPm | US004Q | 2024-11-23T14:19:51.667Z | 2024-11-24T14:22:30.223Z |
5580592 | 5580592 | 20241122005635_pjmeA | US004Q | 2024-11-23T14:19:31.589Z | 2024-11-24T14:22:28.961Z |
5577178 | 5577178 | 20241121120453_9g19i | US004Q | 2024-11-23T14:13:52.079Z | 2024-11-24T14:22:00.222Z |
5577110 | 5577110 | 20241121092206_fA2Vn | US004Q | 2024-11-23T14:12:46.898Z | 2024-11-24T14:21:43.690Z |
5576386 | 5576386 | 20241122115629_T6Goj | US004Q | 2024-11-23T14:09:20.976Z | 2024-11-24T14:21:10.648Z |
5576280 | 5576280 | 20241122113859_YRFBE | US004Q | 2024-11-23T14:09:06.335Z | 2024-11-24T14:21:10.615Z |
5576256 | 5576256 | 20241122113634_IP3Up | US004Q | 2024-11-23T14:08:57.078Z | 2024-11-24T14:21:10.607Z |
5576190 | 5576190 | 20241122112750_rc8qy | US004Q | 2024-11-23T14:08:44.789Z | 2024-11-24T14:21:10.589Z |
5576094 | 5576094 | 20241122111427_m5pur | US004Q | 2024-11-23T14:08:33.644Z | 2024-11-24T14:21:10.556Z |
5576029 | 5576029 | 20241122110500_We3XR | US004Q | 2024-11-23T14:08:25.392Z | 2024-11-24T14:21:10.539Z |
5576027 | 5576027 | 20241122110500_OueFA | US004Q | 2024-11-23T14:08:24.463Z | 2024-11-24T14:21:10.538Z |
5575995 | 5575995 | 20241122105808_UnHeB | US004Q | 2024-11-23T14:08:13.734Z | 2024-11-24T14:21:10.527Z |
5575960 | 5575960 | 20241122105150_iQ1FD | US004Q | 2024-11-23T14:08:08.933Z | 2024-11-24T14:21:10.518Z |
5575943 | 5575943 | 20241122104942_Dm6GB | US004Q | 2024-11-23T14:08:06.136Z | 2024-11-24T14:21:10.513Z |
5575901 | 5575901 | 20241122104458_6qLv4 | US004Q | 2024-11-23T14:08:00.828Z | 2024-11-24T14:21:10.502Z |
5575706 | 5575706 | 20241122100306_ZPyrM | US004Q | 2024-11-23T14:07:22.147Z | 2024-11-24T14:21:10.411Z |
5575661 | 5575661 | 20241122095644_vHNFC | US004Q | 2024-11-23T14:07:11.159Z | 2024-11-24T14:21:10.390Z |
5575659 | 5575659 | 20241122095616_kPq6E | US004Q | 2024-11-23T14:07:09.827Z | 2024-11-24T14:21:10.390Z |
5575514 | 5575514 | 20241122093446_KKHcW | US004Q | 2024-11-23T14:06:42.736Z | 2024-11-24T14:21:10.342Z |
5575464 | 5575464 | 20241122092507_O2dD4 | US004Q | 2024-11-23T14:06:37.352Z | 2024-11-24T14:21:10.326Z |
5575446 | 5575446 | 20241122092259_h87Qu | US004Q | 2024-11-23T14:06:35.059Z | 2024-11-24T14:21:10.321Z |
5575274 | 5575274 | 20241122085617_xmNYW | US004Q | 2024-11-23T14:06:02.021Z | 2024-11-24T14:21:10.271Z |
5575084 | 5575084 | 20241122075959_lrq7N | US004Q | 2024-11-23T14:05:25.130Z | 2024-11-24T14:21:10.209Z |
5575037 | 5575037 | 20241122074424_S02n2 | US004Q | 2024-11-23T14:05:07.499Z | 2024-11-24T14:21:10.196Z |
5575025 | 5575025 | 20241122074017_6Zrhf | US004Q | 2024-11-23T14:05:06.025Z | 2024-11-24T14:21:10.193Z |
5574985 | 5574985 | 20241122072734_vmjrG | US004Q | 2024-11-23T14:05:00.389Z | 2024-11-24T14:21:10.183Z |
5574954 | 5574954 | 20241122071341_htdxm | US004Q | 2024-11-23T14:04:55.665Z | 2024-11-24T14:21:10.174Z |
5574950 | 5574950 | 20241122071302_z8p4W | US004Q | 2024-11-23T14:04:54.274Z | 2024-11-24T14:21:10.173Z |
5574948 | 5574948 | 20241122071230_SqMOq | US004Q | 2024-11-23T14:04:53.811Z | 2024-11-24T14:21:10.172Z |
5574676 | 5574676 | 20241122061214_O3wKb | US004Q | 2024-11-23T14:04:02.703Z | 2024-11-24T14:21:10.098Z |
5574425 | 5574425 | 20241122054400_14Y3b | US004Q | 2024-11-23T14:03:18.475Z | 2024-11-24T14:21:10.052Z |
5574292 | 5574292 | 20241122053224_hJSEe | US004Q | 2024-11-23T14:02:59.009Z | 2024-11-24T14:21:10.027Z |
5574272 | 5574272 | 20241122053056_R9svl | US004Q | 2024-11-23T14:02:57.484Z | 2024-11-24T14:21:10.024Z |
5574006 | 5574006 | 20241122045946_9t8TS | US004Q | 2024-11-23T14:02:08.191Z | 2024-11-24T14:21:09.929Z |
5573975 | 5573975 | 20241122045646_mKnqR | US004Q | 2024-11-23T14:02:03.447Z | 2024-11-24T14:21:09.923Z |
5573793 | 5573793 | 20241122044045_r5Xsd | US004Q | 2024-11-23T14:01:32.529Z | 2024-11-24T14:21:09.886Z |
5573791 | 5573791 | 20241122044018_3ybLn | US004Q | 2024-11-23T14:01:31.108Z | 2024-11-24T14:21:09.885Z |
5573763 | 5573763 | 20241122043849_dUXPt | US004Q | 2024-11-23T14:01:23.764Z | 2024-11-24T14:21:09.881Z |
5573726 | 5573726 | 20241122043634_3eEyE | US004Q | 2024-11-23T14:01:19.615Z | 2024-11-24T14:21:09.874Z |
5573670 | 5573670 | 20241122043400_0poXX | US004Q | 2024-11-23T14:01:13.618Z | 2024-11-24T14:21:09.868Z |
5573649 | 5573649 | 20241122043200_PQSzg | US004Q | 2024-11-23T14:01:11.381Z | 2024-11-24T14:21:09.865Z |
5573518 | 5573518 | 20241122042307_4Idkn | US004Q | 2024-11-23T14:00:43.878Z | 2024-11-24T14:21:09.845Z |
5573358 | 5573358 | 20241122041230_wj25Y | US004Q | 2024-11-23T14:00:22.239Z | 2024-11-24T14:21:09.821Z |
5573144 | 5573144 | 20241121035956_D33HU | US004Q | 2024-11-22T14:19:12.421Z | 2024-11-24T14:24:02.385Z |
5573066 | 5573066 | 20241121034743_7nUqn | US004Q | 2024-11-22T14:19:08.197Z | 2024-11-24T14:24:01.885Z |
5573002 | 5573002 | 20241121033744_RJElk | US004Q | 2024-11-22T14:19:03.438Z | 2024-11-24T14:24:01.379Z |
5572980 | 5572980 | 20241121033318_vESUW | US004Q | 2024-11-22T14:19:02.344Z | 2024-11-24T14:24:01.036Z |
5572851 | 5572851 | 20241121031718_5xfGU | US004Q | 2024-11-22T14:18:53.609Z | 2024-11-24T14:23:59.295Z |
5572364 | 5572364 | 20241121021402_NH3qN | US004Q | 2024-11-22T14:18:19.178Z | 2024-11-24T14:23:54.940Z |
5571922 | 5571922 | 20241121010822_55zBB | US004Q | 2024-11-22T14:17:47.219Z | 2024-11-24T14:23:48.387Z |
5568098 | 5568098 | 20241121114826_hGYmk | US004Q | 2024-11-22T14:08:05.709Z | 2024-11-24T14:21:58.724Z |
5568037 | 5568037 | 20241121114313_gvLFb | US004Q | 2024-11-22T14:07:59.089Z | 2024-11-24T14:21:58.102Z |
5567948 | 5567948 | 20241121113419_VJBhP | US004Q | 2024-11-22T14:07:50.503Z | 2024-11-24T14:21:57.181Z |
5567890 | 5567890 | 20241121112307_ykoZP | US004Q | 2024-11-22T14:07:30.296Z | 2024-11-24T14:21:56.352Z |
5567768 | 5567768 | 20241121110316_azwKT | US004Q | 2024-11-22T14:07:13.894Z | 2024-11-24T14:21:54.501Z |
5567755 | 5567755 | 20241121105948_392t3 | US004Q | 2024-11-22T14:07:12.109Z | 2024-11-24T14:21:53.880Z |
5567752 | 5567752 | 20241121105945_Aidyn | US004Q | 2024-11-22T14:07:11.911Z | 2024-11-24T14:21:53.870Z |
5567499 | 5567499 | 20241121102901_Y4Ckl | US004Q | 2024-11-22T14:06:24.694Z | 2024-11-24T14:21:50.525Z |
5567452 | 5567452 | 20241121102102_nyrGm | US004Q | 2024-11-22T14:06:18.713Z | 2024-11-24T14:21:49.773Z |
5567404 | 5567404 | 20241121101145_bFqX2 | US004Q | 2024-11-22T14:06:09.372Z | 2024-11-24T14:21:48.993Z |
5567399 | 5567399 | 20241121101036_h4ygC | US004Q | 2024-11-22T14:06:06.961Z | 2024-11-24T14:21:48.924Z |
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);