participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,686 rows where station_code = "UK00AF" 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 |
---|---|---|---|---|---|
5591522 | 5591522 | 20241122233638_jp1oU | UK00AF | 2024-11-24T14:19:57.566Z | 2024-11-24T14:21:11.512Z |
5590564 | 5590564 | 20241122193607_N7Lq0 | UK00AF | 2024-11-24T14:18:42.918Z | 2024-11-24T14:21:11.239Z |
5590182 | 5590182 | 20241122184505_rWxTX | UK00AF | 2024-11-24T14:18:12.242Z | 2024-11-24T14:21:11.146Z |
5583187 | 5583187 | 20241120225755_7DR2E | UK00AF | 2024-11-23T14:23:25.656Z | 2024-11-24T14:23:42.539Z |
5582853 | 5582853 | 20241122040249_7cP3d | UK00AF | 2024-11-23T14:21:21.765Z | 2024-11-24T14:22:38.185Z |
5582447 | 5582447 | 20241122033354_S0CcP | UK00AF | 2024-11-23T14:21:05.126Z | 2024-11-24T14:22:36.949Z |
5582209 | 5582209 | 20241122031138_Ya3aH | UK00AF | 2024-11-23T14:20:59.345Z | 2024-11-24T14:22:36.148Z |
5582162 | 5582162 | 20241122030729_I7Cn6 | UK00AF | 2024-11-23T14:20:58.125Z | 2024-11-24T14:22:36.024Z |
5581899 | 5581899 | 20241122024553_6xSdW | UK00AF | 2024-11-23T14:20:49.352Z | 2024-11-24T14:22:35.101Z |
5581784 | 5581784 | 20241122023432_rrQXx | UK00AF | 2024-11-23T14:20:43.151Z | 2024-11-24T14:22:33.321Z |
5581516 | 5581516 | 20241122020932_PdS0a | UK00AF | 2024-11-23T14:20:28.937Z | 2024-11-24T14:22:32.009Z |
5581296 | 5581296 | 20241122015235_2Q0FL | UK00AF | 2024-11-23T14:20:14.034Z | 2024-11-24T14:22:31.282Z |
5581258 | 5581258 | 20241122014725_6lirh | UK00AF | 2024-11-23T14:20:11.653Z | 2024-11-24T14:22:31.120Z |
5580825 | 5580825 | 20241122011627_Hr3Bq | UK00AF | 2024-11-23T14:19:43.000Z | 2024-11-24T14:22:29.899Z |
5580570 | 5580570 | 20241122005542_rZyVZ | UK00AF | 2024-11-23T14:19:30.263Z | 2024-11-24T14:22:28.818Z |
5580352 | 5580352 | 20241122003209_H2ZrO | UK00AF | 2024-11-23T14:19:17.836Z | 2024-11-24T14:22:28.099Z |
5580290 | 5580290 | 20241122002642_AeI9f | UK00AF | 2024-11-23T14:19:15.849Z | 2024-11-24T14:22:27.879Z |
5579873 | 5579873 | 20241121233107_5YSCg | UK00AF | 2024-11-23T14:18:54.259Z | 2024-11-24T14:22:26.367Z |
5579186 | 5579186 | 20241121215851_vCn6A | UK00AF | 2024-11-23T14:17:57.288Z | 2024-11-24T14:22:23.841Z |
5579131 | 5579131 | 20241121214813_I89Ib | UK00AF | 2024-11-23T14:17:52.588Z | 2024-11-24T14:22:23.631Z |
5578662 | 5578662 | 20241121204047_fnEg3 | UK00AF | 2024-11-23T14:17:27.044Z | 2024-11-24T14:22:21.547Z |
5578537 | 5578537 | 20241121202104_FEjlM | UK00AF | 2024-11-23T14:17:21.522Z | 2024-11-24T14:22:20.951Z |
5578318 | 5578318 | 20241121192655_yWjRU | UK00AF | 2024-11-23T14:16:46.402Z | 2024-11-24T14:22:19.734Z |
5578284 | 5578284 | 20241121192108_4LWnN | UK00AF | 2024-11-23T14:16:42.333Z | 2024-11-24T14:22:19.644Z |
5578245 | 5578245 | 20241121191533_5ZZM6 | UK00AF | 2024-11-23T14:16:37.872Z | 2024-11-24T14:22:19.551Z |
5578186 | 5578186 | 20241121190456_r8Imb | UK00AF | 2024-11-23T14:16:33.856Z | 2024-11-24T14:22:19.300Z |
5577615 | 5577615 | 20241121172354_y86pz | UK00AF | 2024-11-23T14:15:31.071Z | 2024-11-24T14:22:15.937Z |
5573800 | 5573800 | 20241122044229_xZ5Ah | UK00AF | 2024-11-23T14:01:38.239Z | 2024-11-24T14:21:09.888Z |
5573737 | 5573737 | 20241122043753_twCes | UK00AF | 2024-11-23T14:01:21.441Z | 2024-11-24T14:21:09.877Z |
5573667 | 5573667 | 20241122043344_Yh0mA | UK00AF | 2024-11-23T14:01:13.098Z | 2024-11-24T14:21:09.867Z |
5573463 | 5573463 | 20241122041908_crsFZ | UK00AF | 2024-11-23T14:00:36.707Z | 2024-11-24T14:21:09.836Z |
5570592 | 5570592 | 20241120202149_2a37A | UK00AF | 2024-11-22T14:15:51.456Z | 2024-11-24T14:23:35.584Z |
5570406 | 5570406 | 20241120193252_DUphZ | UK00AF | 2024-11-22T14:15:19.707Z | 2024-11-24T14:23:33.302Z |
5569838 | 5569838 | 20241120174329_PMpiD | UK00AF | 2024-11-22T14:14:24.001Z | 2024-11-24T14:23:25.201Z |
5569760 | 5569760 | 20241120171935_qxzMm | UK00AF | 2024-11-22T14:14:05.359Z | 2024-11-24T14:23:23.582Z |
5564568 | 5564568 | 20241120030951_osvKU | UK00AF | 2024-11-21T14:17:49.722Z | 2024-11-24T14:24:43.449Z |
5564507 | 5564507 | 20241120030420_tcm7Q | UK00AF | 2024-11-21T14:17:42.904Z | 2024-11-24T14:24:43.185Z |
5564131 | 5564131 | 20241120023232_bHGjO | UK00AF | 2024-11-21T14:17:12.692Z | 2024-11-24T14:24:40.857Z |
5564092 | 5564092 | 20241120022802_6GTcR | UK00AF | 2024-11-21T14:17:08.765Z | 2024-11-24T14:24:40.573Z |
5563365 | 5563365 | 20241120012133_83ekw | UK00AF | 2024-11-21T14:15:59.148Z | 2024-11-24T14:24:37.420Z |
5563277 | 5563277 | 20241120011409_2s8Zj | UK00AF | 2024-11-21T14:15:50.390Z | 2024-11-24T14:24:36.994Z |
5563252 | 5563252 | 20241120011155_CZCtJ | UK00AF | 2024-11-21T14:15:46.237Z | 2024-11-24T14:24:36.894Z |
5563073 | 5563073 | 20241120004819_Pyamh | UK00AF | 2024-11-21T14:15:34.521Z | 2024-11-24T14:24:36.019Z |
5562812 | 5562812 | 20241120001505_2Vhud | UK00AF | 2024-11-21T14:15:23.327Z | 2024-11-24T14:24:33.959Z |
5562673 | 5562673 | 20241120000341_X7YVy | UK00AF | 2024-11-21T14:15:16.192Z | 2024-11-24T14:24:33.264Z |
5562432 | 5562432 | 20241119233622_oWshd | UK00AF | 2024-11-21T14:14:49.067Z | 2024-11-24T14:24:32.093Z |
5562414 | 5562414 | 20241119233416_5D2o4 | UK00AF | 2024-11-21T14:14:47.168Z | 2024-11-24T14:24:32.063Z |
5562317 | 5562317 | 20241119232153_a15jI | UK00AF | 2024-11-21T14:14:41.809Z | 2024-11-24T14:24:31.754Z |
5561744 | 5561744 | 20241119215756_ZwhYp | UK00AF | 2024-11-21T14:13:55.987Z | 2024-11-24T14:24:28.817Z |
5561477 | 5561477 | 20241119204457_5vouy | UK00AF | 2024-11-21T14:13:20.311Z | 2024-11-24T14:24:27.046Z |
5561260 | 5561260 | 20241119192426_y9mqs | UK00AF | 2024-11-21T14:12:51.616Z | 2024-11-24T14:24:23.891Z |
5561204 | 5561204 | 20241119190315_fEy3y | UK00AF | 2024-11-21T14:12:36.132Z | 2024-11-24T14:24:22.987Z |
5558452 | 5558452 | 20241120060552_0RyG1 | UK00AF | 2024-11-21T14:03:17.251Z | 2024-11-24T14:22:51.963Z |
5558412 | 5558412 | 20241120060228_5NrA2 | UK00AF | 2024-11-21T14:03:13.141Z | 2024-11-24T14:22:51.435Z |
5558336 | 5558336 | 20241120055637_J45jA | UK00AF | 2024-11-21T14:03:03.071Z | 2024-11-24T14:22:50.730Z |
5558279 | 5558279 | 20241120055139_S2cac | UK00AF | 2024-11-21T14:02:55.232Z | 2024-11-24T14:22:49.723Z |
5558144 | 5558144 | 20241120054046_2VdIJ | UK00AF | 2024-11-21T14:02:35.908Z | 2024-11-24T14:22:48.487Z |
5558133 | 5558133 | 20241120053912_RZl1O | UK00AF | 2024-11-21T14:02:34.123Z | 2024-11-24T14:22:48.409Z |
5557927 | 5557927 | 20241120052353_T2V04 | UK00AF | 2024-11-21T14:02:04.617Z | 2024-11-24T14:22:46.022Z |
5557839 | 5557839 | 20241120051721_wS6c8 | UK00AF | 2024-11-21T14:01:53.811Z | 2024-11-24T14:22:45.387Z |
5557804 | 5557804 | 20241120051312_2zbrh | UK00AF | 2024-11-21T14:01:47.974Z | 2024-11-24T14:22:45.020Z |
5557590 | 5557590 | 20241120045909_ut2Fp | UK00AF | 2024-11-21T14:01:17.183Z | 2024-11-24T14:22:42.922Z |
5557341 | 5557341 | 20241120043939_s6VBt | UK00AF | 2024-11-21T14:00:34.235Z | 2024-11-24T14:22:40.029Z |
5557333 | 5557333 | 20241120043934_HcyN3 | UK00AF | 2024-11-21T14:00:33.563Z | 2024-11-24T14:22:40.022Z |
5557310 | 5557310 | 20241120043531_ICooJ | UK00AF | 2024-11-21T14:00:28.563Z | 2024-11-24T14:22:39.885Z |
5545352 | 5545352 | 20241116045630_dVcZR | UK00AF | 2024-11-17T14:04:30.553Z | 2024-11-24T14:25:43.536Z |
5545339 | 5545339 | 20241116045008_8Vr79 | UK00AF | 2024-11-17T14:04:29.900Z | 2024-11-24T14:25:43.516Z |
5545322 | 5545322 | 20241116042937_uhzyD | UK00AF | 2024-11-17T14:04:27.672Z | 2024-11-24T14:25:43.323Z |
5545316 | 5545316 | 20241116042440_4tR3E | UK00AF | 2024-11-17T14:04:26.822Z | 2024-11-24T14:25:43.301Z |
5439791 | 5439791 | 20241030203300_HkYnL | UK00AF | 2024-11-01T12:14:29.395Z | 2024-11-08T14:23:05.705Z |
5439710 | 5439710 | 20241030202109_Nr1Qd | UK00AF | 2024-11-01T12:14:12.959Z | 2024-11-08T14:23:04.964Z |
5430894 | 5430894 | 20241028235940_5HrwS | UK00AF | 2024-10-31T12:19:15.970Z | 2024-11-06T14:27:22.139Z |
5430867 | 5430867 | 20241028235410_efkh2 | UK00AF | 2024-10-31T12:19:12.142Z | 2024-11-06T14:27:21.940Z |
5430860 | 5430860 | 20241028235319_27tOC | UK00AF | 2024-10-31T12:19:11.443Z | 2024-11-06T14:27:21.849Z |
5430852 | 5430852 | 20241028235237_FtEm0 | UK00AF | 2024-10-31T12:19:10.374Z | 2024-11-06T14:27:21.815Z |
5422999 | 5422999 | 20241027033453_49xrV | UK00AF | 2024-10-30T12:22:58.323Z | 2024-11-04T14:28:59.809Z |
5422990 | 5422990 | 20241027013029_R2UDR | UK00AF | 2024-10-30T12:22:38.855Z | 2024-11-04T14:28:55.509Z |
5418172 | 5418172 | 20241027200445_wisrL | UK00AF | 2024-10-30T12:15:02.656Z | 2024-11-05T14:27:09.414Z |
5417699 | 5417699 | 20241027190231_u4h2Z | UK00AF | 2024-10-30T12:14:14.150Z | 2024-11-05T14:27:08.086Z |
5410506 | 5410506 | 20241027051551_t69Ip | UK00AF | 2024-10-29T12:17:57.133Z | 2024-11-04T14:29:04.656Z |
5410104 | 5410104 | 20241027045401_25B5I | UK00AF | 2024-10-29T12:17:48.055Z | 2024-11-04T14:29:03.786Z |
5410077 | 5410077 | 20241027045200_Qcfdh | UK00AF | 2024-10-29T12:17:47.152Z | 2024-11-04T14:29:03.660Z |
5410020 | 5410020 | 20241027044750_J1byC | UK00AF | 2024-10-29T12:17:45.924Z | 2024-11-04T14:29:03.445Z |
5409955 | 5409955 | 20241027044414_ziM9D | UK00AF | 2024-10-29T12:17:44.918Z | 2024-11-04T14:29:03.108Z |
5409446 | 5409446 | 20241027041830_tIy3I | UK00AF | 2024-10-29T12:17:24.251Z | 2024-11-04T14:29:01.741Z |
5409349 | 5409349 | 20241027041203_ktV9o | UK00AF | 2024-10-29T12:17:17.074Z | 2024-11-04T14:29:01.595Z |
5409328 | 5409328 | 20241027041115_SFESB | UK00AF | 2024-10-29T12:17:16.723Z | 2024-11-04T14:29:01.584Z |
5409164 | 5409164 | 20241027040335_t2uFM | UK00AF | 2024-10-29T12:17:09.339Z | 2024-11-04T14:29:01.230Z |
5408934 | 5408934 | 20241027035037_CA3NZ | UK00AF | 2024-10-29T12:16:57.440Z | 2024-11-04T14:29:00.828Z |
5408833 | 5408833 | 20241027034515_XxIix | UK00AF | 2024-10-29T12:16:54.393Z | 2024-11-04T14:29:00.613Z |
5408672 | 5408672 | 20241027033536_LwT62 | UK00AF | 2024-10-29T12:16:43.888Z | 2024-11-04T14:28:59.829Z |
5408652 | 5408652 | 20241027033431_fnzhI | UK00AF | 2024-10-29T12:16:42.323Z | 2024-11-04T14:28:59.779Z |
5408619 | 5408619 | 20241027033232_wxbnM | UK00AF | 2024-10-29T12:16:39.508Z | 2024-11-04T14:28:59.678Z |
5408293 | 5408293 | 20241027032153_H745r | UK00AF | 2024-10-29T12:16:21.220Z | 2024-11-04T14:28:59.065Z |
5408255 | 5408255 | 20241027031943_YdRX2 | UK00AF | 2024-10-29T12:16:19.995Z | 2024-11-04T14:28:59.037Z |
5408154 | 5408154 | 20241027031142_IB6ey | UK00AF | 2024-10-29T12:16:12.462Z | 2024-11-04T14:28:58.935Z |
5408149 | 5408149 | 20241027031142_2Iczn | UK00AF | 2024-10-29T12:16:12.105Z | 2024-11-04T14:28:58.920Z |
5408074 | 5408074 | 20241027030532_rtsX5 | UK00AF | 2024-10-29T12:16:03.739Z | 2024-11-04T14:28:58.750Z |
5407971 | 5407971 | 20241027030048_OBkfw | UK00AF | 2024-10-29T12:15:55.978Z | 2024-11-04T14:28:58.535Z |
5407967 | 5407967 | 20241027030033_2mrzP | UK00AF | 2024-10-29T12:15:55.667Z | 2024-11-04T14:28:58.534Z |
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);