participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,228 rows where station_code = "HR001E" 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 |
---|---|---|---|---|---|
5573020 | 5573020 | 20241121034020_dr7KY | HR001E | 2024-11-22T14:19:04.953Z | 2024-11-22T14:19:22.435Z |
5572791 | 5572791 | 20241121031011_BvHos | HR001E | 2024-11-22T14:18:49.659Z | 2024-11-22T14:19:22.392Z |
5572753 | 5572753 | 20241121030546_XOMDd | HR001E | 2024-11-22T14:18:47.932Z | 2024-11-22T14:19:22.385Z |
5572574 | 5572574 | 20241121024150_R5lYK | HR001E | 2024-11-22T14:18:37.454Z | 2024-11-22T14:19:22.354Z |
5572536 | 5572536 | 20241121023349_aBSXL | HR001E | 2024-11-22T14:18:34.000Z | 2024-11-22T14:19:22.347Z |
5572408 | 5572408 | 20241121021901_Dxqd3 | HR001E | 2024-11-22T14:18:24.497Z | 2024-11-22T14:19:22.325Z |
5572096 | 5572096 | 20241121013216_tkCwj | HR001E | 2024-11-22T14:17:57.230Z | 2024-11-22T14:19:22.257Z |
5572066 | 5572066 | 20241121012816_ylukf | HR001E | 2024-11-22T14:17:55.658Z | 2024-11-22T14:19:22.252Z |
5572058 | 5572058 | 20241121012649_4uscR | HR001E | 2024-11-22T14:17:55.299Z | 2024-11-22T14:19:22.251Z |
5571939 | 5571939 | 20241121010951_E3U2m | HR001E | 2024-11-22T14:17:48.282Z | 2024-11-22T14:19:22.227Z |
5571866 | 5571866 | 20241121005812_8ZGaR | HR001E | 2024-11-22T14:17:43.808Z | 2024-11-22T14:19:22.211Z |
5571695 | 5571695 | 20241121003320_0hOJG | HR001E | 2024-11-22T14:17:35.298Z | 2024-11-22T14:19:22.176Z |
5571616 | 5571616 | 20241121001727_KR5yi | HR001E | 2024-11-22T14:17:26.369Z | 2024-11-22T14:19:22.160Z |
5571469 | 5571469 | 20241120235315_wq27Q | HR001E | 2024-11-22T14:17:09.078Z | 2024-11-22T14:19:22.132Z |
5570542 | 5570542 | 20241120195852_BMAUm | HR001E | 2024-11-22T14:15:43.807Z | 2024-11-22T14:19:21.934Z |
5570435 | 5570435 | 20241120193836_sSHCL | HR001E | 2024-11-22T14:15:25.782Z | 2024-11-22T14:19:21.916Z |
5570145 | 5570145 | 20241120185154_UZ8tV | HR001E | 2024-11-22T14:14:55.470Z | 2024-11-22T14:19:21.870Z |
5565945 | 5565945 | 20241121051015_L9Knx | HR001E | 2024-11-22T14:01:27.704Z | 2024-11-22T14:01:27.704Z |
5565923 | 5565923 | 20241121050652_z7Exx | HR001E | 2024-11-22T14:01:24.743Z | 2024-11-22T14:01:24.743Z |
5565648 | 5565648 | 20241121043140_2rlE2 | HR001E | 2024-11-22T14:00:35.291Z | 2024-11-22T14:00:35.291Z |
5549379 | 5549379 | 20241117043909_xW7Kn | HR001E | 2024-11-18T14:11:31.580Z | 2024-11-22T14:23:20.627Z |
5549367 | 5549367 | 20241117043549_sX1Hl | HR001E | 2024-11-18T14:11:30.810Z | 2024-11-22T14:23:20.564Z |
5549297 | 5549297 | 20241117041535_uBOli | HR001E | 2024-11-18T14:11:25.684Z | 2024-11-22T14:23:20.052Z |
5549169 | 5549169 | 20241117033644_CBvzm | HR001E | 2024-11-18T14:11:12.882Z | 2024-11-22T14:23:19.130Z |
5549002 | 5549002 | 20241117024043_9Vk28 | HR001E | 2024-11-18T14:10:37.206Z | 2024-11-22T14:23:17.469Z |
5548975 | 5548975 | 20241117023327_FlUwb | HR001E | 2024-11-18T14:10:34.540Z | 2024-11-22T14:23:17.371Z |
5548770 | 5548770 | 20241117013610_OYKg7 | HR001E | 2024-11-18T14:10:11.445Z | 2024-11-22T14:23:15.640Z |
5548755 | 5548755 | 20241117013223_raxgG | HR001E | 2024-11-18T14:10:10.182Z | 2024-11-22T14:23:15.447Z |
5548637 | 5548637 | 20241117004522_Rf2Rz | HR001E | 2024-11-18T14:09:41.079Z | 2024-11-22T14:23:14.868Z |
5548614 | 5548614 | 20241117003355_wFf9f | HR001E | 2024-11-18T14:09:35.422Z | 2024-11-22T14:23:14.618Z |
5548185 | 5548185 | 20241116205954_clNg1 | HR001E | 2024-11-18T14:08:25.188Z | 2024-11-22T14:23:10.831Z |
5548178 | 5548178 | 20241116205132_jANer | HR001E | 2024-11-18T14:08:24.195Z | 2024-11-22T14:23:10.755Z |
5548173 | 5548173 | 20241116204532_3WA2j | HR001E | 2024-11-18T14:08:23.393Z | 2024-11-22T14:23:10.724Z |
5548164 | 5548164 | 20241116204122_d681y | HR001E | 2024-11-18T14:08:22.604Z | 2024-11-22T14:23:10.620Z |
5548136 | 5548136 | 20241116200621_YNUsp | HR001E | 2024-11-18T14:08:18.948Z | 2024-11-22T14:23:10.254Z |
5548088 | 5548088 | 20241116193251_n733W | HR001E | 2024-11-18T14:08:01.651Z | 2024-11-22T14:23:09.325Z |
5548083 | 5548083 | 20241116192947_TOu8o | HR001E | 2024-11-18T14:08:01.228Z | 2024-11-22T14:23:09.253Z |
5548074 | 5548074 | 20241116191138_DkhhE | HR001E | 2024-11-18T14:07:59.762Z | 2024-11-22T14:23:09.067Z |
5548060 | 5548060 | 20241116185637_mTE2H | HR001E | 2024-11-18T14:07:56.733Z | 2024-11-22T14:23:08.857Z |
5548050 | 5548050 | 20241116185222_0by6V | HR001E | 2024-11-18T14:07:54.967Z | 2024-11-22T14:23:08.785Z |
5545325 | 5545325 | 20241116043958_I7DPO | HR001E | 2024-11-17T14:04:28.423Z | 2024-11-22T14:23:39.867Z |
5545310 | 5545310 | 20241116042248_J2uXH | HR001E | 2024-11-17T14:04:26.227Z | 2024-11-22T14:23:39.644Z |
5545267 | 5545267 | 20241116034307_K7OIF | HR001E | 2024-11-17T14:04:21.775Z | 2024-11-22T14:23:39.351Z |
5545189 | 5545189 | 20241116021740_g0J9w | HR001E | 2024-11-17T14:04:01.975Z | 2024-11-22T14:23:37.105Z |
5545185 | 5545185 | 20241116021401_yyrC9 | HR001E | 2024-11-17T14:04:01.314Z | 2024-11-22T14:23:37.101Z |
5545172 | 5545172 | 20241116015957_WZ58B | HR001E | 2024-11-17T14:03:57.741Z | 2024-11-22T14:23:36.989Z |
5545163 | 5545163 | 20241116014446_mPSo8 | HR001E | 2024-11-17T14:03:56.333Z | 2024-11-22T14:23:36.909Z |
5545150 | 5545150 | 20241116013528_TqGqe | HR001E | 2024-11-17T14:03:54.887Z | 2024-11-22T14:23:36.562Z |
5545145 | 5545145 | 20241116013252_6pT4M | HR001E | 2024-11-17T14:03:54.310Z | 2024-11-22T14:23:36.549Z |
5545120 | 5545120 | 20241116004016_6YG4p | HR001E | 2024-11-17T14:03:50.062Z | 2024-11-22T14:23:36.222Z |
5545094 | 5545094 | 20241116000129_WoSsV | HR001E | 2024-11-17T14:03:46.821Z | 2024-11-22T14:23:35.916Z |
5545064 | 5545064 | 20241115230706_kMWGK | HR001E | 2024-11-17T14:03:43.515Z | 2024-11-22T14:23:35.709Z |
5545006 | 5545006 | 20241115215136_02Zhk | HR001E | 2024-11-17T14:03:35.809Z | 2024-11-22T14:23:35.124Z |
5545001 | 5545001 | 20241115214603_ZJiFe | HR001E | 2024-11-17T14:03:35.138Z | 2024-11-22T14:23:35.073Z |
5544956 | 5544956 | 20241115193223_EYIbK | HR001E | 2024-11-17T14:03:28.974Z | 2024-11-22T14:23:34.095Z |
5544952 | 5544952 | 20241115190038_j1xu4 | HR001E | 2024-11-17T14:03:27.307Z | 2024-11-22T14:23:33.683Z |
5544944 | 5544944 | 20241115182151_RggkY | HR001E | 2024-11-17T14:03:24.380Z | 2024-11-22T14:23:33.389Z |
5544934 | 5544934 | 20241115174445_fRbjJ | HR001E | 2024-11-17T14:03:22.029Z | 2024-11-22T14:23:33.191Z |
5543991 | 5543991 | 20241115050319_wjl0g | HR001E | 2024-11-16T14:07:47.184Z | 2024-11-22T14:24:02.879Z |
5543980 | 5543980 | 20241115050149_gmt0V | HR001E | 2024-11-16T14:07:46.346Z | 2024-11-22T14:24:02.867Z |
5543916 | 5543916 | 20241115043341_KiTrV | HR001E | 2024-11-16T14:07:39.627Z | 2024-11-22T14:24:02.475Z |
5543790 | 5543790 | 20241115033631_r3ui2 | HR001E | 2024-11-16T14:07:14.125Z | 2024-11-22T14:24:01.543Z |
5543713 | 5543713 | 20241115030336_aIYP4 | HR001E | 2024-11-16T14:07:03.871Z | 2024-11-22T14:24:00.907Z |
5543693 | 5543693 | 20241115030013_Njn23 | HR001E | 2024-11-16T14:07:02.342Z | 2024-11-22T14:24:00.773Z |
5543687 | 5543687 | 20241115025926_928z0 | HR001E | 2024-11-16T14:07:01.464Z | 2024-11-22T14:24:00.745Z |
5543629 | 5543629 | 20241115023849_PnqNE | HR001E | 2024-11-16T14:06:57.262Z | 2024-11-22T14:24:00.530Z |
5543615 | 5543615 | 20241115023441_Mfmq3 | HR001E | 2024-11-16T14:06:56.421Z | 2024-11-22T14:24:00.496Z |
5543611 | 5543611 | 20241115023300_ma2Nu | HR001E | 2024-11-16T14:06:55.899Z | 2024-11-22T14:24:00.409Z |
5543609 | 5543609 | 20241115023228_f8tGs | HR001E | 2024-11-16T14:06:55.570Z | 2024-11-22T14:24:00.375Z |
5543445 | 5543445 | 20241115012434_ZICWP | HR001E | 2024-11-16T14:06:22.274Z | 2024-11-22T14:23:59.365Z |
5543405 | 5543405 | 20241115010932_FvStg | HR001E | 2024-11-16T14:06:14.802Z | 2024-11-22T14:23:58.850Z |
5543377 | 5543377 | 20241115004820_fT2m2 | HR001E | 2024-11-16T14:06:11.547Z | 2024-11-22T14:23:58.457Z |
5543211 | 5543211 | 20241114230340_LW6uk | HR001E | 2024-11-16T14:05:44.769Z | 2024-11-22T14:23:57.550Z |
5541160 | 5541160 | 20241113170827_A6A51 | HR001E | 2024-11-15T14:06:47.213Z | 2024-11-22T14:24:15.860Z |
5538758 | 5538758 | 20241113045140_Yikc0 | HR001E | 2024-11-14T14:13:55.670Z | 2024-11-21T14:26:28.693Z |
5538524 | 5538524 | 20241113040304_lJ1va | HR001E | 2024-11-14T14:13:35.494Z | 2024-11-21T14:26:26.977Z |
5538389 | 5538389 | 20241113032550_3mMRX | HR001E | 2024-11-14T14:13:22.232Z | 2024-11-21T14:26:25.091Z |
5538344 | 5538344 | 20241113031657_B0G7C | HR001E | 2024-11-14T14:13:17.271Z | 2024-11-21T14:26:24.258Z |
5538312 | 5538312 | 20241113030720_DpCEJ | HR001E | 2024-11-14T14:13:13.367Z | 2024-11-21T14:26:23.152Z |
5538294 | 5538294 | 20241113030047_asDyT | HR001E | 2024-11-14T14:13:11.827Z | 2024-11-21T14:26:22.937Z |
5538164 | 5538164 | 20241113022541_Vesdg | HR001E | 2024-11-14T14:12:58.663Z | 2024-11-21T14:26:21.215Z |
5538161 | 5538161 | 20241113022512_dK21g | HR001E | 2024-11-14T14:12:58.486Z | 2024-11-21T14:26:21.197Z |
5537964 | 5537964 | 20241113014410_YEa2Y | HR001E | 2024-11-14T14:12:40.380Z | 2024-11-21T14:26:17.659Z |
5537950 | 5537950 | 20241113013938_F548U | HR001E | 2024-11-14T14:12:39.518Z | 2024-11-21T14:26:17.471Z |
5537924 | 5537924 | 20241113013218_zf4Zq | HR001E | 2024-11-14T14:12:37.922Z | 2024-11-21T14:26:17.258Z |
5537889 | 5537889 | 20241113012321_0U4gK | HR001E | 2024-11-14T14:12:35.804Z | 2024-11-21T14:26:16.655Z |
5537859 | 5537859 | 20241113011027_bKUaN | HR001E | 2024-11-14T14:12:34.047Z | 2024-11-21T14:26:16.500Z |
5537846 | 5537846 | 20241113010506_6z4fu | HR001E | 2024-11-14T14:12:33.377Z | 2024-11-21T14:26:16.468Z |
5537802 | 5537802 | 20241113004127_Zxoz6 | HR001E | 2024-11-14T14:12:30.940Z | 2024-11-21T14:26:16.320Z |
5537626 | 5537626 | 20241112235554_PXY9Z | HR001E | 2024-11-14T14:12:19.651Z | 2024-11-21T14:26:15.010Z |
5537594 | 5537594 | 20241112235055_IgaIH | HR001E | 2024-11-14T14:12:15.314Z | 2024-11-21T14:26:14.902Z |
5537447 | 5537447 | 20241112230314_B8tE3 | HR001E | 2024-11-14T14:11:49.721Z | 2024-11-21T14:26:13.166Z |
5537432 | 5537432 | 20241112225553_zrBGj | HR001E | 2024-11-14T14:11:47.736Z | 2024-11-21T14:26:12.934Z |
5537324 | 5537324 | 20241112220654_WrIUD | HR001E | 2024-11-14T14:11:35.615Z | 2024-11-21T14:26:11.249Z |
5537303 | 5537303 | 20241112215930_pb9Bj | HR001E | 2024-11-14T14:11:33.146Z | 2024-11-21T14:26:11.076Z |
5537106 | 5537106 | 20241112202703_2tOdK | HR001E | 2024-11-14T14:11:02.726Z | 2024-11-21T14:26:08.846Z |
5536872 | 5536872 | 20241112193407_xiS97 | HR001E | 2024-11-14T14:10:38.774Z | 2024-11-21T14:26:06.663Z |
5536795 | 5536795 | 20241112191145_YNlvD | HR001E | 2024-11-14T14:10:33.597Z | 2024-11-21T14:26:05.730Z |
5536543 | 5536543 | 20241112182643_BVJjF | HR001E | 2024-11-14T14:10:14.172Z | 2024-11-21T14:26:02.619Z |
5536521 | 5536521 | 20241112182334_pHSfQ | HR001E | 2024-11-14T14:10:09.940Z | 2024-11-21T14:26:01.952Z |
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);