participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,202 rows where station_code = "UK008S" 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 |
---|---|---|---|---|---|
5410498 | 5410498 | 20241027051544_zFtsH | UK008S | 2024-10-29T12:17:56.983Z | 2024-11-04T14:29:04.651Z |
5409190 | 5409190 | 20241027040511_pf95o | UK008S | 2024-10-29T12:17:10.694Z | 2024-11-04T14:29:01.357Z |
5409157 | 5409157 | 20241027040324_piW2n | UK008S | 2024-10-29T12:17:09.260Z | 2024-11-04T14:29:01.228Z |
5409006 | 5409006 | 20241027035415_GA0Rd | UK008S | 2024-10-29T12:17:01.296Z | 2024-11-04T14:29:00.921Z |
5408968 | 5408968 | 20241027035141_O3X66 | UK008S | 2024-10-29T12:16:58.445Z | 2024-11-04T14:29:00.879Z |
5408608 | 5408608 | 20241027033204_cQPv8 | UK008S | 2024-10-29T12:16:39.108Z | 2024-11-04T14:28:59.674Z |
5408564 | 5408564 | 20241027033030_vnuBv | UK008S | 2024-10-29T12:16:36.124Z | 2024-11-04T14:28:59.618Z |
5408546 | 5408546 | 20241027033015_S6h1q | UK008S | 2024-10-29T12:16:35.713Z | 2024-11-04T14:28:59.614Z |
5408359 | 5408359 | 20241027032326_g33z3 | UK008S | 2024-10-29T12:16:24.794Z | 2024-11-04T14:28:59.284Z |
5402631 | 5402631 | 20241026200704_cNJ5P | UK008S | 2024-10-29T12:07:50.489Z | 2024-11-04T14:28:45.815Z |
5402437 | 5402437 | 20241026193709_Y7PnR | UK008S | 2024-10-29T12:07:17.284Z | 2024-11-04T14:28:44.444Z |
5399342 | 5399342 | 20241026041140_R376e | UK008S | 2024-10-28T12:19:55.327Z | 2024-11-03T14:27:39.506Z |
5399325 | 5399325 | 20241026041019_VVEFi | UK008S | 2024-10-28T12:19:54.718Z | 2024-11-03T14:27:39.448Z |
5399048 | 5399048 | 20241026034658_XAPTn | UK008S | 2024-10-28T12:19:45.704Z | 2024-11-03T14:27:38.944Z |
5399024 | 5399024 | 20241026034526_9a8Io | UK008S | 2024-10-28T12:19:44.692Z | 2024-11-03T14:27:38.906Z |
5398938 | 5398938 | 20241026033936_W3sJg | UK008S | 2024-10-28T12:19:40.644Z | 2024-11-03T14:27:38.663Z |
5398755 | 5398755 | 20241026032600_aDLHv | UK008S | 2024-10-28T12:19:31.368Z | 2024-11-03T14:27:37.986Z |
5398741 | 5398741 | 20241026032349_hdf7j | UK008S | 2024-10-28T12:19:30.069Z | 2024-11-03T14:27:37.942Z |
5398726 | 5398726 | 20241026032150_7NVzB | UK008S | 2024-10-28T12:19:29.672Z | 2024-11-03T14:27:37.899Z |
5398447 | 5398447 | 20241026025829_7JpiW | UK008S | 2024-10-28T12:19:17.614Z | 2024-11-03T14:27:36.380Z |
5397900 | 5397900 | 20241026020619_C4SMr | UK008S | 2024-10-28T12:18:49.860Z | 2024-11-03T14:27:34.458Z |
5397846 | 5397846 | 20241026020215_MFn0G | UK008S | 2024-10-28T12:18:48.156Z | 2024-11-03T14:27:34.321Z |
5397527 | 5397527 | 20241026013752_5bShE | UK008S | 2024-10-28T12:18:26.336Z | 2024-11-03T14:27:33.346Z |
5397509 | 5397509 | 20241026013556_PAgLj | UK008S | 2024-10-28T12:18:25.871Z | 2024-11-03T14:27:33.292Z |
5397473 | 5397473 | 20241026013248_pQQM4 | UK008S | 2024-10-28T12:18:24.430Z | 2024-11-03T14:27:33.141Z |
5397467 | 5397467 | 20241026013143_eEpEZ | UK008S | 2024-10-28T12:18:24.089Z | 2024-11-03T14:27:33.119Z |
5397378 | 5397378 | 20241026012420_u8aPb | UK008S | 2024-10-28T12:18:18.726Z | 2024-11-03T14:27:32.758Z |
5397281 | 5397281 | 20241026011458_kUCHK | UK008S | 2024-10-28T12:18:14.217Z | 2024-11-03T14:27:32.511Z |
5396906 | 5396906 | 20241026004441_kvqiH | UK008S | 2024-10-28T12:17:59.023Z | 2024-11-03T14:27:31.304Z |
5396602 | 5396602 | 20241026001636_j0Q0c | UK008S | 2024-10-28T12:17:50.817Z | 2024-11-03T14:27:30.445Z |
5396534 | 5396534 | 20241026000955_0KhG3 | UK008S | 2024-10-28T12:17:48.938Z | 2024-11-03T14:27:30.157Z |
5396361 | 5396361 | 20241025235922_nVCp2 | UK008S | 2024-10-28T12:17:36.147Z | 2024-11-03T14:27:29.633Z |
5396358 | 5396358 | 20241025235919_BiiW2 | UK008S | 2024-10-28T12:17:35.937Z | 2024-11-03T14:27:29.621Z |
5395951 | 5395951 | 20241025232523_8TT0E | UK008S | 2024-10-28T12:17:06.860Z | 2024-11-03T14:27:27.735Z |
5395871 | 5395871 | 20241025231656_HM7e3 | UK008S | 2024-10-28T12:17:02.129Z | 2024-11-03T14:27:27.445Z |
5395819 | 5395819 | 20241025231248_uGeg7 | UK008S | 2024-10-28T12:16:55.082Z | 2024-11-03T14:27:26.785Z |
5395594 | 5395594 | 20241025225743_SQKAS | UK008S | 2024-10-28T12:16:30.636Z | 2024-11-03T14:27:26.084Z |
5395283 | 5395283 | 20241025222924_jrEqm | UK008S | 2024-10-28T12:16:04.448Z | 2024-11-03T14:27:24.575Z |
5395275 | 5395275 | 20241025222922_9Fo8Q | UK008S | 2024-10-28T12:16:04.280Z | 2024-11-03T14:27:24.553Z |
5394691 | 5394691 | 20241025210951_UpMI2 | UK008S | 2024-10-28T12:15:14.307Z | 2024-11-03T14:27:22.306Z |
5388009 | 5388009 | 20241025035244_svhEE | UK008S | 2024-10-27T12:21:53.361Z | 2024-11-02T12:28:33.589Z |
5384948 | 5384948 | 20241024212057_UR2Q4 | UK008S | 2024-10-27T12:18:02.604Z | 2024-11-02T12:28:28.777Z |
5383574 | 5383574 | 20241024183428_PrrJU | UK008S | 2024-10-27T12:15:47.673Z | 2024-11-02T12:28:25.767Z |
5383533 | 5383533 | 20241024183025_DLq7v | UK008S | 2024-10-27T12:15:42.084Z | 2024-11-02T12:28:25.737Z |
5378192 | 5378192 | 20241024053517_0jG65 | UK008S | 2024-10-26T12:22:57.678Z | 2024-11-01T12:27:03.390Z |
5378058 | 5378058 | 20241024052542_Uh2EC | UK008S | 2024-10-26T12:22:53.814Z | 2024-11-01T12:27:03.268Z |
5377644 | 5377644 | 20241024050148_gwgbN | UK008S | 2024-10-26T12:22:43.046Z | 2024-11-01T12:27:02.691Z |
5377482 | 5377482 | 20241024045330_4HpFi | UK008S | 2024-10-26T12:22:38.224Z | 2024-11-01T12:27:02.456Z |
5375553 | 5375553 | 20241024031938_Lq2K0 | UK008S | 2024-10-26T12:21:31.145Z | 2024-11-01T12:27:00.773Z |
5375009 | 5375009 | 20241024025230_p5XVt | UK008S | 2024-10-26T12:21:09.642Z | 2024-11-01T12:27:00.113Z |
5374992 | 5374992 | 20241024025209_9NBxw | UK008S | 2024-10-26T12:21:08.973Z | 2024-11-01T12:27:00.109Z |
5374767 | 5374767 | 20241024024302_HFeeo | UK008S | 2024-10-26T12:21:00.615Z | 2024-11-01T12:26:59.591Z |
5366036 | 5366036 | 20241024000215_5XyOC | UK008S | 2024-10-25T12:18:14.957Z | 2024-11-01T12:26:56.550Z |
5365606 | 5365606 | 20241023233942_7LjrD | UK008S | 2024-10-25T12:18:02.938Z | 2024-11-01T12:26:56.276Z |
5365155 | 5365155 | 20241023231704_xp8Dq | UK008S | 2024-10-25T12:17:47.940Z | 2024-11-01T12:26:55.899Z |
5365140 | 5365140 | 20241023231628_o67Ak | UK008S | 2024-10-25T12:17:47.410Z | 2024-11-01T12:26:55.891Z |
5365136 | 5365136 | 20241023231628_MNXVc | UK008S | 2024-10-25T12:17:47.240Z | 2024-11-01T12:26:55.889Z |
5364568 | 5364568 | 20241023223829_Q3TOu | UK008S | 2024-10-25T12:17:25.075Z | 2024-11-01T12:26:55.221Z |
5364405 | 5364405 | 20241023222624_1OVvW | UK008S | 2024-10-25T12:17:19.771Z | 2024-11-01T12:26:55.042Z |
5363860 | 5363860 | 20241023215256_osM0r | UK008S | 2024-10-25T12:16:55.440Z | 2024-11-01T12:26:53.898Z |
5363634 | 5363634 | 20241023212918_83DBZ | UK008S | 2024-10-25T12:16:30.666Z | 2024-11-01T12:26:53.473Z |
5363622 | 5363622 | 20241023212822_0pzHN | UK008S | 2024-10-25T12:16:28.680Z | 2024-11-01T12:26:53.470Z |
5363529 | 5363529 | 20241023211640_z6uzg | UK008S | 2024-10-25T12:16:20.305Z | 2024-11-01T12:26:53.349Z |
5363501 | 5363501 | 20241023211443_QFGkG | UK008S | 2024-10-25T12:16:16.838Z | 2024-11-01T12:26:53.327Z |
5363239 | 5363239 | 20241023203900_2msb3 | UK008S | 2024-10-25T12:15:43.984Z | 2024-11-01T12:26:52.987Z |
5362576 | 5362576 | 20241023194401_7Su2p | UK008S | 2024-10-25T12:14:46.184Z | 2024-11-01T12:26:52.051Z |
5362262 | 5362262 | 20241023192106_VMH67 | UK008S | 2024-10-25T12:14:06.215Z | 2024-11-01T12:26:51.149Z |
5362240 | 5362240 | 20241023192041_sxBEu | UK008S | 2024-10-25T12:14:03.480Z | 2024-11-01T12:26:51.138Z |
5362144 | 5362144 | 20241023191132_WW2cI | UK008S | 2024-10-25T12:13:56.245Z | 2024-11-01T12:26:51.041Z |
5356310 | 5356310 | 20241023054021_HEUAG | UK008S | 2024-10-24T12:21:57.907Z | 2024-10-31T12:30:11.630Z |
5356288 | 5356288 | 20241023053100_PsK4t | UK008S | 2024-10-24T12:21:56.996Z | 2024-10-31T12:30:11.240Z |
5356279 | 5356279 | 20241023052916_399lk | UK008S | 2024-10-24T12:21:56.965Z | 2024-10-31T12:30:11.214Z |
5355869 | 5355869 | 20241023043127_Fjt0w | UK008S | 2024-10-24T12:21:40.673Z | 2024-10-31T12:30:09.139Z |
5353634 | 5353634 | 20241023013635_lrfbm | UK008S | 2024-10-24T12:19:49.866Z | 2024-10-31T12:30:04.433Z |
5353477 | 5353477 | 20241023012731_zkWg1 | UK008S | 2024-10-24T12:19:43.968Z | 2024-10-31T12:30:04.289Z |
5353420 | 5353420 | 20241023012522_753ZA | UK008S | 2024-10-24T12:19:42.461Z | 2024-10-31T12:30:04.240Z |
5353378 | 5353378 | 20241023012312_93uRa | UK008S | 2024-10-24T12:19:40.919Z | 2024-10-31T12:30:04.206Z |
5353245 | 5353245 | 20241023011700_srGHX | UK008S | 2024-10-24T12:19:36.873Z | 2024-10-31T12:30:04.054Z |
5352955 | 5352955 | 20241023005801_32Eg7 | UK008S | 2024-10-24T12:19:27.732Z | 2024-10-31T12:30:03.577Z |
5352784 | 5352784 | 20241023004954_5bo6B | UK008S | 2024-10-24T12:19:11.945Z | 2024-10-31T12:30:03.288Z |
5352693 | 5352693 | 20241023004424_E0x3o | UK008S | 2024-10-24T12:19:05.550Z | 2024-10-31T12:30:03.149Z |
5352685 | 5352685 | 20241023004356_79B1F | UK008S | 2024-10-24T12:19:05.232Z | 2024-10-31T12:30:03.143Z |
5352636 | 5352636 | 20241023004215_xQqDG | UK008S | 2024-10-24T12:19:02.154Z | 2024-10-31T12:30:03.009Z |
5352215 | 5352215 | 20241023001829_f4xcd | UK008S | 2024-10-24T12:18:32.180Z | 2024-10-31T12:30:02.302Z |
5352189 | 5352189 | 20241023001644_CLdav | UK008S | 2024-10-24T12:18:29.419Z | 2024-10-31T12:30:02.280Z |
5351885 | 5351885 | 20241022235725_KBkTj | UK008S | 2024-10-24T12:18:07.469Z | 2024-10-31T12:30:01.179Z |
5351723 | 5351723 | 20241022234922_cmHPJ | UK008S | 2024-10-24T12:17:53.692Z | 2024-10-31T12:30:00.819Z |
5351641 | 5351641 | 20241022234215_uuuSO | UK008S | 2024-10-24T12:17:45.939Z | 2024-10-31T12:30:00.638Z |
5351595 | 5351595 | 20241022234000_g4Qvy | UK008S | 2024-10-24T12:17:41.353Z | 2024-10-31T12:30:00.579Z |
5351201 | 5351201 | 20241022230510_C3twf | UK008S | 2024-10-24T12:17:20.130Z | 2024-10-31T12:29:59.602Z |
5350894 | 5350894 | 20241022223852_aXm2X | UK008S | 2024-10-24T12:16:45.678Z | 2024-10-31T12:29:58.994Z |
5350845 | 5350845 | 20241022223309_DGhEa | UK008S | 2024-10-24T12:16:41.492Z | 2024-10-31T12:29:58.848Z |
5350405 | 5350405 | 20241022214305_tRICp | UK008S | 2024-10-24T12:15:42.259Z | 2024-10-31T12:29:58.130Z |
5350141 | 5350141 | 20241022211610_kIL1X | UK008S | 2024-10-24T12:15:24.280Z | 2024-10-31T12:29:57.374Z |
5350036 | 5350036 | 20241022210424_iqvo2 | UK008S | 2024-10-24T12:15:08.499Z | 2024-10-31T12:29:57.215Z |
5349963 | 5349963 | 20241022205419_hnDCl | UK008S | 2024-10-24T12:14:57.623Z | 2024-10-31T12:29:57.040Z |
5349875 | 5349875 | 20241022204356_AL0rS | UK008S | 2024-10-24T12:14:44.857Z | 2024-10-31T12:29:56.812Z |
5349731 | 5349731 | 20241022203049_BBkkZ | UK008S | 2024-10-24T12:14:33.713Z | 2024-10-31T12:29:56.196Z |
5349564 | 5349564 | 20241022201243_kzxkg | UK008S | 2024-10-24T12:13:58.609Z | 2024-10-31T12:29:55.823Z |
5348943 | 5348943 | 20241022191119_uZrpv | UK008S | 2024-10-24T12:12:37.284Z | 2024-10-31T12:29:54.183Z |
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);