participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
372 rows where station_code = "UK0037" 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 |
---|---|---|---|---|---|
2473558 | 2473558 | 20230521013047_hNHA2 | UK0037 | 2024-01-05T23:57:53.990Z | 2024-01-05T23:57:53.990Z |
2375337 | 2375337 | 20230411034953_xxLp0 | UK0037 | 2024-01-05T23:56:48.406Z | 2024-01-05T23:56:48.406Z |
2374976 | 2374976 | 20230411022243_E4gg7 | UK0037 | 2024-01-05T23:56:48.309Z | 2024-01-05T23:56:48.309Z |
2374905 | 2374905 | 20230411021334_TC2Ic | UK0037 | 2024-01-05T23:56:48.290Z | 2024-01-05T23:56:48.290Z |
2374758 | 2374758 | 20230411012723_Vtr1X | UK0037 | 2024-01-05T23:56:48.247Z | 2024-01-05T23:56:48.247Z |
2374710 | 2374710 | 20230411010810_jQIY2 | UK0037 | 2024-01-05T23:56:48.230Z | 2024-01-05T23:56:48.230Z |
2374295 | 2374295 | 20230410234722_CMiA2 | UK0037 | 2024-01-05T23:56:48.063Z | 2024-01-05T23:56:48.063Z |
2374285 | 2374285 | 20230410234629_EuPJb | UK0037 | 2024-01-05T23:56:48.062Z | 2024-01-05T23:56:48.062Z |
2374195 | 2374195 | 20230410232235_Q3gj2 | UK0037 | 2024-01-05T23:56:48.040Z | 2024-01-05T23:56:48.040Z |
2373933 | 2373933 | 20230410213638_LAf2B | UK0037 | 2024-01-05T23:56:47.973Z | 2024-01-05T23:56:47.973Z |
2371291 | 2371291 | 20230409040217_x2rLi | UK0037 | 2024-01-05T23:56:43.379Z | 2024-01-05T23:56:43.379Z |
2369978 | 2369978 | 20230408024335_pOoUX | UK0037 | 2024-01-05T23:56:41.814Z | 2024-01-05T23:56:41.814Z |
2369711 | 2369711 | 20230408011206_4sOeV | UK0037 | 2024-01-05T23:56:41.792Z | 2024-01-05T23:56:41.792Z |
2369334 | 2369334 | 20230407221528_naNvX | UK0037 | 2024-01-05T23:56:41.754Z | 2024-01-05T23:56:41.754Z |
2368256 | 2368256 | 20230407033445_2CxJk | UK0037 | 2024-01-05T23:56:40.493Z | 2024-01-05T23:56:40.493Z |
2367779 | 2367779 | 20230407000057_AtAet | UK0037 | 2024-01-05T23:56:40.449Z | 2024-01-05T23:56:40.449Z |
2367768 | 2367768 | 20230406235236_eupo1 | UK0037 | 2024-01-05T23:56:40.447Z | 2024-01-05T23:56:40.447Z |
2367687 | 2367687 | 20230406224605_6m3LZ | UK0037 | 2024-01-05T23:56:40.438Z | 2024-01-05T23:56:40.438Z |
2365144 | 2365144 | 20230404035845_qv8tZ | UK0037 | 2024-01-05T23:56:36.830Z | 2024-01-05T23:56:36.830Z |
2365100 | 2365100 | 20230404035345_AKjhF | UK0037 | 2024-01-05T23:56:36.828Z | 2024-01-05T23:56:36.828Z |
2365000 | 2365000 | 20230404033200_UFABI | UK0037 | 2024-01-05T23:56:36.819Z | 2024-01-05T23:56:36.819Z |
2364949 | 2364949 | 20230404032616_3PVwM | UK0037 | 2024-01-05T23:56:36.816Z | 2024-01-05T23:56:36.816Z |
2364586 | 2364586 | 20230404021058_MI30N | UK0037 | 2024-01-05T23:56:36.786Z | 2024-01-05T23:56:36.786Z |
2362757 | 2362757 | 20230403031941_2vzXF | UK0037 | 2024-01-05T23:56:35.441Z | 2024-01-05T23:56:35.441Z |
2362306 | 2362306 | 20230403004803_UW33P | UK0037 | 2024-01-05T23:56:35.393Z | 2024-01-05T23:56:35.393Z |
2362066 | 2362066 | 20230402232215_mivC3 | UK0037 | 2024-01-05T23:56:35.374Z | 2024-01-05T23:56:35.374Z |
2362057 | 2362057 | 20230402231413_4F7W1 | UK0037 | 2024-01-05T23:56:35.373Z | 2024-01-05T23:56:35.373Z |
2356833 | 2356833 | 20230330042607_DXPYF | UK0037 | 2024-01-05T23:56:30.301Z | 2024-01-05T23:56:30.301Z |
2356753 | 2356753 | 20230330032725_p8DiR | UK0037 | 2024-01-05T23:56:30.292Z | 2024-01-05T23:56:30.292Z |
2351805 | 2351805 | 20230327205142_qka7S | UK0037 | 2024-01-05T23:56:27.316Z | 2024-01-05T23:56:27.316Z |
2345043 | 2345043 | 20230324045825_g3Qb6 | UK0037 | 2024-01-05T23:56:21.069Z | 2024-01-05T23:56:21.069Z |
2344984 | 2344984 | 20230324042945_JYYCV | UK0037 | 2024-01-05T23:56:21.061Z | 2024-01-05T23:56:21.061Z |
2344808 | 2344808 | 20230324035248_zdUK3 | UK0037 | 2024-01-05T23:56:21.037Z | 2024-01-05T23:56:21.037Z |
2344670 | 2344670 | 20230324032545_DCsee | UK0037 | 2024-01-05T23:56:21.016Z | 2024-01-05T23:56:21.016Z |
2344661 | 2344661 | 20230324032403_lO1bX | UK0037 | 2024-01-05T23:56:21.014Z | 2024-01-05T23:56:21.014Z |
2344555 | 2344555 | 20230324030750_bq13x | UK0037 | 2024-01-05T23:56:20.997Z | 2024-01-05T23:56:20.997Z |
2344395 | 2344395 | 20230324023836_aI3ln | UK0037 | 2024-01-05T23:56:20.972Z | 2024-01-05T23:56:20.972Z |
2343953 | 2343953 | 20230324005821_rBy5D | UK0037 | 2024-01-05T23:56:20.913Z | 2024-01-05T23:56:20.913Z |
2342371 | 2342371 | 20230323043800_f2oXR | UK0037 | 2024-01-05T23:56:19.419Z | 2024-01-05T23:56:19.419Z |
2342069 | 2342069 | 20230323030802_KyPbo | UK0037 | 2024-01-05T23:56:19.354Z | 2024-01-05T23:56:19.354Z |
2341955 | 2341955 | 20230323021800_aQ2tL | UK0037 | 2024-01-05T23:56:19.319Z | 2024-01-05T23:56:19.319Z |
2332660 | 2332660 | 20230317234935_xz42H | UK0037 | 2024-01-05T23:56:11.705Z | 2024-01-05T23:56:11.705Z |
2328368 | 2328368 | 20230315042103_OaTz7 | UK0037 | 2024-01-05T23:56:07.707Z | 2024-01-05T23:56:07.707Z |
2328259 | 2328259 | 20230315035807_5EPBR | UK0037 | 2024-01-05T23:56:07.694Z | 2024-01-05T23:56:07.694Z |
2328118 | 2328118 | 20230315033056_wUGbv | UK0037 | 2024-01-05T23:56:07.684Z | 2024-01-05T23:56:07.684Z |
2328021 | 2328021 | 20230315031230_6bXsk | UK0037 | 2024-01-05T23:56:07.676Z | 2024-01-05T23:56:07.676Z |
2327879 | 2327879 | 20230315023644_bgbeV | UK0037 | 2024-01-05T23:56:07.661Z | 2024-01-05T23:56:07.661Z |
2327830 | 2327830 | 20230315021807_FhPur | UK0037 | 2024-01-05T23:56:07.655Z | 2024-01-05T23:56:07.655Z |
2327776 | 2327776 | 20230315020400_XYfKI | UK0037 | 2024-01-05T23:56:07.648Z | 2024-01-05T23:56:07.648Z |
2327646 | 2327646 | 20230315013213_ZzCTU | UK0037 | 2024-01-05T23:56:07.633Z | 2024-01-05T23:56:07.633Z |
2327552 | 2327552 | 20230315011134_S9i8i | UK0037 | 2024-01-05T23:56:07.624Z | 2024-01-05T23:56:07.624Z |
2327513 | 2327513 | 20230315010309_FukA5 | UK0037 | 2024-01-05T23:56:07.620Z | 2024-01-05T23:56:07.620Z |
2327137 | 2327137 | 20230314225914_dPCvT | UK0037 | 2024-01-05T23:56:07.569Z | 2024-01-05T23:56:07.569Z |
2324770 | 2324770 | 20230314051130_Qig4O | UK0037 | 2024-01-05T23:56:06.985Z | 2024-01-05T23:56:06.985Z |
2324751 | 2324751 | 20230314050738_LTR8F | UK0037 | 2024-01-05T23:56:06.981Z | 2024-01-05T23:56:06.981Z |
2324745 | 2324745 | 20230314050718_nNLly | UK0037 | 2024-01-05T23:56:06.980Z | 2024-01-05T23:56:06.980Z |
2324733 | 2324733 | 20230314050314_I0kjD | UK0037 | 2024-01-05T23:56:06.978Z | 2024-01-05T23:56:06.978Z |
2324614 | 2324614 | 20230314042004_Mq3zM | UK0037 | 2024-01-05T23:56:06.951Z | 2024-01-05T23:56:06.951Z |
2324507 | 2324507 | 20230314034621_2ged2 | UK0037 | 2024-01-05T23:56:05.654Z | 2024-01-05T23:56:05.654Z |
2324436 | 2324436 | 20230314025800_PQpTA | UK0037 | 2024-01-05T23:56:05.627Z | 2024-01-05T23:56:05.627Z |
2321687 | 2321687 | 20230312035823_RJvcj | UK0037 | 2024-01-05T23:56:01.940Z | 2024-01-05T23:56:01.940Z |
2321613 | 2321613 | 20230312022928_UdLvn | UK0037 | 2024-01-05T23:56:01.909Z | 2024-01-05T23:56:01.909Z |
2321607 | 2321607 | 20230312022611_DV3Jb | UK0037 | 2024-01-05T23:56:01.907Z | 2024-01-05T23:56:01.907Z |
2320878 | 2320878 | 20230311024854_dgUrs | UK0037 | 2024-01-05T23:56:00.139Z | 2024-01-05T23:56:00.139Z |
2320836 | 2320836 | 20230311022545_G1CsS | UK0037 | 2024-01-05T23:56:00.125Z | 2024-01-05T23:56:00.125Z |
2320731 | 2320731 | 20230311012613_2BxTH | UK0037 | 2024-01-05T23:56:00.093Z | 2024-01-05T23:56:00.093Z |
2320661 | 2320661 | 20230310234734_nuseU | UK0037 | 2024-01-05T23:56:00.066Z | 2024-01-05T23:56:00.066Z |
2309178 | 2309178 | 20230228030505_tLJNo | UK0037 | 2024-01-05T23:55:44.574Z | 2024-01-05T23:55:44.574Z |
2309000 | 2309000 | 20230228022648_sNQap | UK0037 | 2024-01-05T23:55:44.558Z | 2024-01-05T23:55:44.558Z |
2308779 | 2308779 | 20230228013306_7FxWK | UK0037 | 2024-01-05T23:55:44.538Z | 2024-01-05T23:55:44.538Z |
2306273 | 2306273 | 20230227050605_GmLpy | UK0037 | 2024-01-05T23:55:44.279Z | 2024-01-05T23:55:44.279Z |
2306173 | 2306173 | 20230227045030_ZYyf9 | UK0037 | 2024-01-05T23:55:44.271Z | 2024-01-05T23:55:44.271Z |
2305803 | 2305803 | 20230227034202_xZPWv | UK0037 | 2024-01-05T23:55:43.088Z | 2024-01-05T23:55:43.088Z |
2305173 | 2305173 | 20230227013836_X3fSR | UK0037 | 2024-01-05T23:55:43.030Z | 2024-01-05T23:55:43.030Z |
2305179 | 2305179 | 20230227013838_BUqib | UK0037 | 2024-01-05T23:55:43.030Z | 2024-01-05T23:55:43.030Z |
2304688 | 2304688 | 20230226232554_s3MfF | UK0037 | 2024-01-05T23:55:42.980Z | 2024-01-05T23:55:42.980Z |
2304659 | 2304659 | 20230226232052_yU748 | UK0037 | 2024-01-05T23:55:42.977Z | 2024-01-05T23:55:42.977Z |
2304261 | 2304261 | 20230226210328_mLBx0 | UK0037 | 2024-01-05T23:55:42.938Z | 2024-01-05T23:55:42.938Z |
2302608 | 2302608 | 20230226041155_PkDKN | UK0037 | 2024-01-05T23:55:41.574Z | 2024-01-05T23:55:41.574Z |
2302585 | 2302585 | 20230226040714_2ms3F | UK0037 | 2024-01-05T23:55:41.572Z | 2024-01-05T23:55:41.572Z |
2302185 | 2302185 | 20230226022059_HHAt5 | UK0037 | 2024-01-05T23:55:41.528Z | 2024-01-05T23:55:41.528Z |
2301467 | 2301467 | 20230225224732_fGDRY | UK0037 | 2024-01-05T23:55:41.460Z | 2024-01-05T23:55:41.460Z |
2301325 | 2301325 | 20230225211626_SdDDG | UK0037 | 2024-01-05T23:55:41.444Z | 2024-01-05T23:55:41.444Z |
2299190 | 2299190 | 20230225030352_iz6NI | UK0037 | 2024-01-05T23:55:40.025Z | 2024-01-05T23:55:40.025Z |
2298544 | 2298544 | 20230224230054_qOlHw | UK0037 | 2024-01-05T23:55:39.963Z | 2024-01-05T23:55:39.963Z |
2296764 | 2296764 | 20230224025346_Yq6bk | UK0037 | 2024-01-05T23:55:38.179Z | 2024-01-05T23:55:38.179Z |
2296708 | 2296708 | 20230224022205_Scj9M | UK0037 | 2024-01-05T23:55:38.174Z | 2024-01-05T23:55:38.174Z |
2296632 | 2296632 | 20230224003640_3lpW3 | UK0037 | 2024-01-05T23:55:38.166Z | 2024-01-05T23:55:38.166Z |
2296578 | 2296578 | 20230224000609_bcJdL | UK0037 | 2024-01-05T23:55:38.162Z | 2024-01-05T23:55:38.162Z |
2296536 | 2296536 | 20230223235819_s420v | UK0037 | 2024-01-05T23:55:38.159Z | 2024-01-05T23:55:38.159Z |
2286531 | 2286531 | 20230219030254_bu4do | UK0037 | 2024-01-05T23:55:31.274Z | 2024-01-05T23:55:31.274Z |
2286472 | 2286472 | 20230219024856_Wdvqe | UK0037 | 2024-01-05T23:55:31.268Z | 2024-01-05T23:55:31.268Z |
2286408 | 2286408 | 20230219020618_Kyle2 | UK0037 | 2024-01-05T23:55:31.262Z | 2024-01-05T23:55:31.262Z |
2278089 | 2278089 | 20230214220437_lc9S2 | UK0037 | 2024-01-05T23:55:23.604Z | 2024-01-05T23:55:23.604Z |
2277785 | 2277785 | 20230214191202_zAt5l | UK0037 | 2024-01-05T23:55:23.378Z | 2024-01-05T23:55:23.378Z |
2276741 | 2276741 | 20230214031013_S3Sk4 | UK0037 | 2024-01-05T23:55:20.845Z | 2024-01-05T23:55:20.845Z |
2276613 | 2276613 | 20230214024313_KeNUV | UK0037 | 2024-01-05T23:55:20.772Z | 2024-01-05T23:55:20.772Z |
2276388 | 2276388 | 20230214015857_OLw5x | UK0037 | 2024-01-05T23:55:20.666Z | 2024-01-05T23:55:20.666Z |
2276186 | 2276186 | 20230214010915_wF2Yq | UK0037 | 2024-01-05T23:55:20.540Z | 2024-01-05T23:55:20.540Z |
2276104 | 2276104 | 20230214004605_ET2Xx | UK0037 | 2024-01-05T23:55:20.471Z | 2024-01-05T23:55:20.471Z |
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);