participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,014 rows where station_code = "UK0020" 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 |
---|---|---|---|---|---|
5454795 | 5454795 | 20241031051718_3x5Mv | UK0020 | 2024-11-02T12:23:23.508Z | 2024-11-08T14:23:25.671Z |
5454625 | 5454625 | 20241031044701_SCl33 | UK0020 | 2024-11-02T12:23:14.635Z | 2024-11-08T14:23:24.484Z |
5453314 | 5453314 | 20241031020151_O3cL5 | UK0020 | 2024-11-02T12:22:31.753Z | 2024-11-08T14:23:16.590Z |
5453067 | 5453067 | 20241031013303_Ny1pg | UK0020 | 2024-11-02T12:22:25.550Z | 2024-11-08T14:23:15.854Z |
5452568 | 5452568 | 20241101034306_XH2eP | UK0020 | 2024-11-02T12:19:01.657Z | 2024-11-08T14:22:37.764Z |
5452267 | 5452267 | 20241101024026_bZLf9 | UK0020 | 2024-11-02T12:18:33.040Z | 2024-11-08T14:22:34.743Z |
5452173 | 5452173 | 20241101021437_qoIzr | UK0020 | 2024-11-02T12:18:23.109Z | 2024-11-08T14:22:33.695Z |
5452169 | 5452169 | 20241101021413_lZHXF | UK0020 | 2024-11-02T12:18:22.609Z | 2024-11-08T14:22:33.690Z |
5452007 | 5452007 | 20241101014319_zMpIN | UK0020 | 2024-11-02T12:18:10.832Z | 2024-11-08T14:22:32.421Z |
5451944 | 5451944 | 20241101013146_7wb3U | UK0020 | 2024-11-02T12:18:07.332Z | 2024-11-08T14:22:32.159Z |
5451876 | 5451876 | 20241101011923_uoO2Z | UK0020 | 2024-11-02T12:18:03.563Z | 2024-11-08T14:22:31.719Z |
5451830 | 5451830 | 20241101011241_TznCs | UK0020 | 2024-11-02T12:18:00.193Z | 2024-11-08T14:22:31.303Z |
5451586 | 5451586 | 20241101002342_HWovU | UK0020 | 2024-11-02T12:17:37.722Z | 2024-11-08T14:22:29.999Z |
5451572 | 5451572 | 20241101001943_DMsNb | UK0020 | 2024-11-02T12:17:34.134Z | 2024-11-08T14:22:29.927Z |
5444389 | 5444389 | 20241031011553_zYtgX | UK0020 | 2024-11-01T12:21:15.440Z | 2024-11-08T14:23:15.299Z |
5444386 | 5444386 | 20241031011530_3Sdwk | UK0020 | 2024-11-01T12:21:15.302Z | 2024-11-08T14:23:15.263Z |
5444322 | 5444322 | 20241031010828_TfB38 | UK0020 | 2024-11-01T12:21:12.733Z | 2024-11-08T14:23:14.348Z |
5444312 | 5444312 | 20241031010744_mp9u2 | UK0020 | 2024-11-01T12:21:12.473Z | 2024-11-08T14:23:14.325Z |
5444297 | 5444297 | 20241031010540_vvAxm | UK0020 | 2024-11-01T12:21:12.258Z | 2024-11-08T14:23:14.289Z |
5444289 | 5444289 | 20241031010528_ZzFGc | UK0020 | 2024-11-01T12:21:12.158Z | 2024-11-08T14:23:14.282Z |
5443849 | 5443849 | 20241031002028_bRhO6 | UK0020 | 2024-11-01T12:20:54.411Z | 2024-11-08T14:23:12.731Z |
5443750 | 5443750 | 20241031001103_GDQlG | UK0020 | 2024-11-01T12:20:48.758Z | 2024-11-08T14:23:12.135Z |
5443723 | 5443723 | 20241031000917_gSzIr | UK0020 | 2024-11-01T12:20:47.926Z | 2024-11-08T14:23:12.098Z |
5443703 | 5443703 | 20241031000722_uL24G | UK0020 | 2024-11-01T12:20:47.164Z | 2024-11-08T14:23:12.015Z |
5443671 | 5443671 | 20241031000253_aR9vF | UK0020 | 2024-11-01T12:20:45.707Z | 2024-11-08T14:23:11.975Z |
5440502 | 5440502 | 20241030222117_IjmIG | UK0020 | 2024-11-01T12:15:33.764Z | 2024-11-08T14:23:09.743Z |
5440478 | 5440478 | 20241030221825_QP3OS | UK0020 | 2024-11-01T12:15:32.673Z | 2024-11-08T14:23:09.563Z |
5440439 | 5440439 | 20241030221300_bZf3w | UK0020 | 2024-11-01T12:15:30.905Z | 2024-11-08T14:23:09.437Z |
5440381 | 5440381 | 20241030220526_2eN0B | UK0020 | 2024-11-01T12:15:28.122Z | 2024-11-08T14:23:09.300Z |
5440228 | 5440228 | 20241030214503_T1IKv | UK0020 | 2024-11-01T12:15:02.929Z | 2024-11-08T14:23:08.090Z |
5440183 | 5440183 | 20241030213846_GVFSz | UK0020 | 2024-11-01T12:14:56.183Z | 2024-11-08T14:23:07.676Z |
5440089 | 5440089 | 20241030212229_vDP3B | UK0020 | 2024-11-01T12:14:49.642Z | 2024-11-08T14:23:07.318Z |
5433005 | 5433005 | 20241029054238_DpWzr | UK0020 | 2024-10-31T12:21:42.717Z | 2024-11-06T14:27:29.600Z |
5432883 | 5432883 | 20241029050615_EiyHx | UK0020 | 2024-10-31T12:21:37.712Z | 2024-11-06T14:27:29.090Z |
5432769 | 5432769 | 20241029043450_MUKn4 | UK0020 | 2024-10-31T12:21:34.420Z | 2024-11-06T14:27:28.673Z |
5432173 | 5432173 | 20241029025203_bS91s | UK0020 | 2024-10-31T12:21:09.634Z | 2024-11-06T14:27:26.163Z |
5432047 | 5432047 | 20241029023523_u3Hvg | UK0020 | 2024-10-31T12:20:58.057Z | 2024-11-06T14:27:25.809Z |
5431835 | 5431835 | 20241029020311_Jy73P | UK0020 | 2024-10-31T12:20:43.000Z | 2024-11-06T14:27:25.037Z |
5431821 | 5431821 | 20241029020154_9RCte | UK0020 | 2024-10-31T12:20:42.410Z | 2024-11-06T14:27:24.991Z |
5431456 | 5431456 | 20241029011517_B2aPg | UK0020 | 2024-10-31T12:20:10.553Z | 2024-11-06T14:27:23.776Z |
5430926 | 5430926 | 20241029000523_3tcRN | UK0020 | 2024-10-31T12:19:19.125Z | 2024-11-06T14:27:22.279Z |
5430763 | 5430763 | 20241028233512_7Tcjg | UK0020 | 2024-10-31T12:18:59.449Z | 2024-11-06T14:27:21.470Z |
5430596 | 5430596 | 20241028231107_cE292 | UK0020 | 2024-10-31T12:18:41.687Z | 2024-11-06T14:27:20.625Z |
5338134 | 5338134 | 20241021184355_JPQUU | UK0020 | 2024-10-23T12:10:21.609Z | 2024-10-30T12:26:41.783Z |
5275720 | 5275720 | 20241010030240_qRTpf | UK0020 | 2024-10-11T12:16:18.925Z | 2024-10-18T12:22:19.983Z |
5269310 | 5269310 | 20241010050618_13yTN | UK0020 | 2024-10-11T12:01:14.446Z | 2024-10-19T12:26:49.011Z |
5269304 | 5269304 | 20241010050541_XG3rD | UK0020 | 2024-10-11T12:01:13.095Z | 2024-10-19T12:26:48.991Z |
5269270 | 5269270 | 20241010045714_XTBUG | UK0020 | 2024-10-11T12:01:07.938Z | 2024-10-19T12:26:48.723Z |
5269213 | 5269213 | 20241010044350_Ygf27 | UK0020 | 2024-10-11T12:00:57.293Z | 2024-10-19T12:26:48.002Z |
5268183 | 5268183 | 20241009003924_KGYm4 | UK0020 | 2024-10-10T12:15:22.584Z | 2024-10-17T12:20:15.424Z |
5268156 | 5268156 | 20241009003450_UbrrE | UK0020 | 2024-10-10T12:15:18.711Z | 2024-10-17T12:20:15.231Z |
5267880 | 5267880 | 20241008225518_4jOdR | UK0020 | 2024-10-10T12:14:44.248Z | 2024-10-17T12:20:12.519Z |
5267793 | 5267793 | 20241008222521_hUL13 | UK0020 | 2024-10-10T12:14:35.021Z | 2024-10-17T12:20:11.148Z |
5267624 | 5267624 | 20241008212425_AOWH3 | UK0020 | 2024-10-10T12:14:13.423Z | 2024-10-17T12:20:10.093Z |
5261840 | 5261840 | 20241007224140_mJLmx | UK0020 | 2024-10-09T12:14:45.016Z | 2024-10-16T12:21:16.309Z |
5253661 | 5253661 | 20241007003150_omlnE | UK0020 | 2024-10-08T12:13:30.554Z | 2024-10-15T12:29:10.271Z |
5253107 | 5253107 | 20241006224730_jxRZt | UK0020 | 2024-10-08T12:12:57.320Z | 2024-10-15T12:29:07.239Z |
5252884 | 5252884 | 20241006215852_yKMVR | UK0020 | 2024-10-08T12:12:45.050Z | 2024-10-15T12:29:05.276Z |
5252409 | 5252409 | 20241006192950_OLzHN | UK0020 | 2024-10-08T12:11:32.942Z | 2024-10-15T12:28:59.358Z |
5247634 | 5247634 | 20241007030041_rUV9A | UK0020 | 2024-10-08T12:00:16.343Z | 2024-10-16T12:20:55.831Z |
5247133 | 5247133 | 20241005014028_KU5dC | UK0020 | 2024-10-07T12:18:50.979Z | 2024-10-13T12:26:25.763Z |
5246847 | 5246847 | 20241005012025_IaYi3 | UK0020 | 2024-10-07T12:18:47.429Z | 2024-10-13T12:26:25.353Z |
5239667 | 5239667 | 20241005041848_CbMA3 | UK0020 | 2024-10-07T12:06:58.191Z | 2024-10-14T12:24:20.497Z |
5239324 | 5239324 | 20241005035023_uBJkP | UK0020 | 2024-10-07T12:06:16.466Z | 2024-10-14T12:24:19.030Z |
5239289 | 5239289 | 20241005034858_At0CT | UK0020 | 2024-10-07T12:06:14.463Z | 2024-10-14T12:24:19.022Z |
5239110 | 5239110 | 20241005032839_FPjy9 | UK0020 | 2024-10-07T12:05:50.567Z | 2024-10-14T12:24:18.282Z |
5236153 | 5236153 | 20241005002617_7BEas | UK0020 | 2024-10-06T12:17:14.324Z | 2024-10-13T12:26:24.739Z |
5235499 | 5235499 | 20241004233932_wcDm9 | UK0020 | 2024-10-06T12:16:07.897Z | 2024-10-13T12:26:24.305Z |
5234890 | 5234890 | 20241004222525_04K06 | UK0020 | 2024-10-06T12:15:36.679Z | 2024-10-13T12:26:22.989Z |
5234240 | 5234240 | 20241004211630_frCQp | UK0020 | 2024-10-06T12:14:44.884Z | 2024-10-13T12:26:22.359Z |
5234215 | 5234215 | 20241004211031_QBRjW | UK0020 | 2024-10-06T12:14:43.239Z | 2024-10-13T12:26:22.334Z |
5233961 | 5233961 | 20241004203322_tip2c | UK0020 | 2024-10-06T12:14:08.845Z | 2024-10-13T12:26:21.731Z |
5220210 | 5220210 | 20241003045458_BN2d8 | UK0020 | 2024-10-05T12:10:32.101Z | 2024-10-12T12:24:56.982Z |
5220194 | 5220194 | 20241003045414_13Vbu | UK0020 | 2024-10-05T12:10:27.890Z | 2024-10-12T12:24:56.951Z |
5220187 | 5220187 | 20241003045223_tTe2w | UK0020 | 2024-10-05T12:10:25.617Z | 2024-10-12T12:24:56.933Z |
5219912 | 5219912 | 20241003042953_p23ax | UK0020 | 2024-10-05T12:09:54.494Z | 2024-10-12T12:24:56.480Z |
5219695 | 5219695 | 20241003041024_7wMbU | UK0020 | 2024-10-05T12:09:28.553Z | 2024-10-12T12:24:56.066Z |
5219132 | 5219132 | 20241004044604_LATCx | UK0020 | 2024-10-05T12:06:11.038Z | 2024-10-13T12:26:09.762Z |
5219078 | 5219078 | 20241004043820_dpPNp | UK0020 | 2024-10-05T12:06:02.265Z | 2024-10-13T12:26:09.629Z |
5218318 | 5218318 | 20241004033025_0sf7Q | UK0020 | 2024-10-05T12:04:06.571Z | 2024-10-13T12:26:08.362Z |
5218219 | 5218219 | 20241004032215_jttZy | UK0020 | 2024-10-05T12:03:49.735Z | 2024-10-13T12:26:08.265Z |
5218146 | 5218146 | 20241004031809_8eNqW | UK0020 | 2024-10-05T12:03:40.112Z | 2024-10-13T12:26:08.069Z |
5216818 | 5216818 | 20241003012952_1ykbh | UK0020 | 2024-10-04T12:13:50.224Z | 2024-10-11T12:23:37.797Z |
5216726 | 5216726 | 20241003012039_Mcev7 | UK0020 | 2024-10-04T12:13:44.934Z | 2024-10-11T12:23:37.721Z |
5216315 | 5216315 | 20241003005023_cfJlH | UK0020 | 2024-10-04T12:13:01.832Z | 2024-10-11T12:23:36.803Z |
5215620 | 5215620 | 20241002234534_5j2sS | UK0020 | 2024-10-04T12:12:08.824Z | 2024-10-11T12:23:35.631Z |
5215517 | 5215517 | 20241002233730_AIArd | UK0020 | 2024-10-04T12:11:57.906Z | 2024-10-11T12:23:35.493Z |
5215353 | 5215353 | 20241002232002_stB1e | UK0020 | 2024-10-04T12:11:44.657Z | 2024-10-11T12:23:35.285Z |
5214775 | 5214775 | 20241002221711_KKx06 | UK0020 | 2024-10-04T12:10:45.211Z | 2024-10-11T12:23:34.080Z |
5213208 | 5213208 | 20241003034923_PEzn6 | UK0020 | 2024-10-04T12:04:38.914Z | 2024-10-12T12:24:55.602Z |
5212207 | 5212207 | 20241003024216_fCIOh | UK0020 | 2024-10-04T12:02:30.553Z | 2024-10-12T12:24:54.453Z |
5211676 | 5211676 | 20241003020930_o4QxO | UK0020 | 2024-10-04T12:01:12.022Z | 2024-10-12T12:24:53.783Z |
5211420 | 5211420 | 20241003014810_lu3Pd | UK0020 | 2024-10-04T12:00:30.941Z | 2024-10-12T12:24:53.466Z |
5210226 | 5210226 | 20241001194517_03mot | UK0020 | 2024-10-03T12:14:49.863Z | 2024-10-10T12:24:45.799Z |
5205809 | 5205809 | 20241001004706_Van7X | UK0020 | 2024-10-02T12:13:01.330Z | 2024-10-09T12:29:16.887Z |
5205792 | 5205792 | 20241001004441_BeGkL | UK0020 | 2024-10-02T12:13:00.658Z | 2024-10-09T12:29:16.867Z |
5205630 | 5205630 | 20241001001740_3ddJJ | UK0020 | 2024-10-02T12:12:53.039Z | 2024-10-09T12:29:16.610Z |
5205455 | 5205455 | 20240930234808_B7Hhw | UK0020 | 2024-10-02T12:12:43.398Z | 2024-10-09T12:29:16.325Z |
5205431 | 5205431 | 20240930234256_i5atf | UK0020 | 2024-10-02T12:12:42.414Z | 2024-10-09T12:29:16.302Z |
5205412 | 5205412 | 20240930233952_uID0v | UK0020 | 2024-10-02T12:12:41.635Z | 2024-10-09T12:29:16.277Z |
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);