participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
253 rows where station_code = "UK00C6" 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 |
---|---|---|---|---|---|
5462912 | 5462912 | 20241102015558_YW3hi | UK00C6 | 2024-11-03T14:18:09.692Z | 2024-11-09T14:23:36.805Z |
5462819 | 5462819 | 20241102013912_ztztj | UK00C6 | 2024-11-03T14:18:06.206Z | 2024-11-09T14:23:36.359Z |
5462775 | 5462775 | 20241102012910_AgchP | UK00C6 | 2024-11-03T14:18:04.405Z | 2024-11-09T14:23:36.117Z |
5452607 | 5452607 | 20241101035123_iU596 | UK00C6 | 2024-11-02T12:19:04.821Z | 2024-11-09T14:24:32.084Z |
5452601 | 5452601 | 20241101034849_JWhxN | UK00C6 | 2024-11-02T12:19:04.432Z | 2024-11-09T14:24:31.962Z |
5452559 | 5452559 | 20241101034040_iaLCM | UK00C6 | 2024-11-02T12:19:00.425Z | 2024-11-09T14:24:31.506Z |
5452539 | 5452539 | 20241101033718_tGeu0 | UK00C6 | 2024-11-02T12:18:57.899Z | 2024-11-09T14:24:31.404Z |
5452523 | 5452523 | 20241101032951_W0ZXq | UK00C6 | 2024-11-02T12:18:55.267Z | 2024-11-09T14:24:31.335Z |
5452186 | 5452186 | 20241101022004_o9au3 | UK00C6 | 2024-11-02T12:18:24.830Z | 2024-11-09T14:24:28.732Z |
5452174 | 5452174 | 20241101021437_qoIzr | UK00C6 | 2024-11-02T12:18:23.109Z | 2024-11-09T14:24:28.596Z |
5451992 | 5451992 | 20241101014214_o2cky | UK00C6 | 2024-11-02T12:18:09.890Z | 2024-11-09T14:24:27.526Z |
5451831 | 5451831 | 20241101011241_TznCs | UK00C6 | 2024-11-02T12:18:00.193Z | 2024-11-09T14:24:25.807Z |
5440622 | 5440622 | 20241030223520_hzh43 | UK00C6 | 2024-11-01T12:15:39.633Z | 2024-11-08T14:23:10.075Z |
5432997 | 5432997 | 20241029053857_6mRdw | UK00C6 | 2024-10-31T12:21:42.430Z | 2024-11-06T14:27:29.499Z |
5431944 | 5431944 | 20241029021940_2E2zC | UK00C6 | 2024-10-31T12:20:51.712Z | 2024-11-06T14:27:25.565Z |
5431911 | 5431911 | 20241029021518_uasN5 | UK00C6 | 2024-10-31T12:20:48.466Z | 2024-11-06T14:27:25.287Z |
5410877 | 5410877 | 20241027054405_DzBhN | UK00C6 | 2024-10-29T12:18:07.641Z | 2024-11-04T14:29:05.945Z |
5408687 | 5408687 | 20241027033632_5i8Gg | UK00C6 | 2024-10-29T12:16:45.112Z | 2024-11-04T14:29:00.304Z |
5407991 | 5407991 | 20241027030058_62XJv | UK00C6 | 2024-10-29T12:15:57.179Z | 2024-11-04T14:28:58.553Z |
5407191 | 5407191 | 20241027022509_NvqtG | UK00C6 | 2024-10-29T12:15:16.314Z | 2024-11-04T14:28:57.232Z |
5406165 | 5406165 | 20241027011957_dHLCG | UK00C6 | 2024-10-29T12:13:55.100Z | 2024-11-04T14:28:55.173Z |
5406163 | 5406163 | 20241027011956_OYwy8 | UK00C6 | 2024-10-29T12:13:54.765Z | 2024-11-04T14:28:55.170Z |
5406116 | 5406116 | 20241027011737_X8fXu | UK00C6 | 2024-10-29T12:13:52.586Z | 2024-11-04T14:28:55.137Z |
5406044 | 5406044 | 20241027011257_HfAjS | UK00C6 | 2024-10-29T12:13:48.836Z | 2024-11-04T14:28:54.897Z |
5405573 | 5405573 | 20241027004554_7kUXO | UK00C6 | 2024-10-29T12:13:02.829Z | 2024-11-04T14:28:53.625Z |
5405542 | 5405542 | 20241027004239_dypN2 | UK00C6 | 2024-10-29T12:13:00.921Z | 2024-11-04T14:28:53.598Z |
5405430 | 5405430 | 20241027003316_GPrPl | UK00C6 | 2024-10-29T12:12:55.430Z | 2024-11-04T14:28:53.467Z |
5405132 | 5405132 | 20241027001501_r8A7I | UK00C6 | 2024-10-29T12:12:31.081Z | 2024-11-04T14:28:52.716Z |
5405019 | 5405019 | 20241027000921_6ZDWj | UK00C6 | 2024-10-29T12:12:17.252Z | 2024-11-04T14:28:52.593Z |
5401935 | 5401935 | 20241026181000_EOdeR | UK00C6 | 2024-10-29T12:05:52.212Z | 2024-11-04T14:28:41.076Z |
5400168 | 5400168 | 20241026054809_zM12p | UK00C6 | 2024-10-28T12:20:25.275Z | 2024-11-03T14:27:41.451Z |
5400085 | 5400085 | 20241026053722_jV2o3 | UK00C6 | 2024-10-28T12:20:21.857Z | 2024-11-03T14:27:41.269Z |
5400012 | 5400012 | 20241026052210_xBNw2 | UK00C6 | 2024-10-28T12:20:18.931Z | 2024-11-03T14:27:41.104Z |
5399794 | 5399794 | 20241026050301_Q7xhn | UK00C6 | 2024-10-28T12:20:11.247Z | 2024-11-03T14:27:40.529Z |
5398579 | 5398579 | 20241026030948_QNEmv | UK00C6 | 2024-10-28T12:19:22.822Z | 2024-11-03T14:27:36.874Z |
5398414 | 5398414 | 20241026025525_lvjcQ | UK00C6 | 2024-10-28T12:19:14.513Z | 2024-11-03T14:27:36.346Z |
5398281 | 5398281 | 20241026024056_wYzIq | UK00C6 | 2024-10-28T12:19:09.111Z | 2024-11-03T14:27:35.813Z |
5398028 | 5398028 | 20241026021849_RmeXY | UK00C6 | 2024-10-28T12:18:57.572Z | 2024-11-03T14:27:34.918Z |
5397990 | 5397990 | 20241026021322_moNS3 | UK00C6 | 2024-10-28T12:18:55.007Z | 2024-11-03T14:27:34.781Z |
5397770 | 5397770 | 20241026015553_vw3I8 | UK00C6 | 2024-10-28T12:18:40.357Z | 2024-11-03T14:27:34.117Z |
5397139 | 5397139 | 20241026010515_qeq7S | UK00C6 | 2024-10-28T12:18:09.160Z | 2024-11-03T14:27:32.078Z |
5396827 | 5396827 | 20241026003929_uEpU2 | UK00C6 | 2024-10-28T12:17:56.767Z | 2024-11-03T14:27:31.013Z |
5395851 | 5395851 | 20241025231533_RicEh | UK00C6 | 2024-10-28T12:16:59.684Z | 2024-11-03T14:27:27.305Z |
5395339 | 5395339 | 20241025223349_Q8NCm | UK00C6 | 2024-10-28T12:16:09.823Z | 2024-11-03T14:27:25.144Z |
5394685 | 5394685 | 20241025210812_fdcm4 | UK00C6 | 2024-10-28T12:15:13.624Z | 2024-11-03T14:27:22.240Z |
5374710 | 5374710 | 20241024024109_drQ9C | UK00C6 | 2024-10-26T12:20:59.615Z | 2024-11-01T12:26:59.550Z |
5374157 | 5374157 | 20241024021336_6I3B0 | UK00C6 | 2024-10-26T12:20:38.137Z | 2024-11-01T12:26:58.713Z |
5373860 | 5373860 | 20241024015712_2vFr7 | UK00C6 | 2024-10-26T12:20:28.203Z | 2024-11-01T12:26:58.535Z |
5373548 | 5373548 | 20241024014310_kP8M1 | UK00C6 | 2024-10-26T12:20:16.528Z | 2024-11-01T12:26:58.322Z |
5373466 | 5373466 | 20241024013900_T3zWm | UK00C6 | 2024-10-26T12:20:12.257Z | 2024-11-01T12:26:58.275Z |
5373029 | 5373029 | 20241024012019_Et5Dq | UK00C6 | 2024-10-26T12:19:54.600Z | 2024-11-01T12:26:58.099Z |
5372796 | 5372796 | 20241024010848_3uEws | UK00C6 | 2024-10-26T12:19:43.340Z | 2024-11-01T12:26:57.920Z |
5364464 | 5364464 | 20241023222938_RkPvW | UK00C6 | 2024-10-25T12:17:21.369Z | 2024-11-01T12:26:55.086Z |
5362375 | 5362375 | 20241023192816_XZ6uU | UK00C6 | 2024-10-25T12:14:22.043Z | 2024-11-01T12:26:51.356Z |
5355344 | 5355344 | 20241023033333_jL439 | UK00C6 | 2024-10-24T12:21:15.466Z | 2024-10-31T12:30:07.553Z |
5355033 | 5355033 | 20241023030540_OurKM | UK00C6 | 2024-10-24T12:21:00.635Z | 2024-10-31T12:30:07.017Z |
5354878 | 5354878 | 20241023025212_58SEA | UK00C6 | 2024-10-24T12:20:55.058Z | 2024-10-31T12:30:06.468Z |
5354759 | 5354759 | 20241023024406_ZRKD6 | UK00C6 | 2024-10-24T12:20:48.757Z | 2024-10-31T12:30:06.310Z |
5354633 | 5354633 | 20241023023727_Td5q7 | UK00C6 | 2024-10-24T12:20:44.480Z | 2024-10-31T12:30:06.199Z |
5354584 | 5354584 | 20241023023410_p58Yo | UK00C6 | 2024-10-24T12:20:41.489Z | 2024-10-31T12:30:06.019Z |
5354558 | 5354558 | 20241023023255_ntqxt | UK00C6 | 2024-10-24T12:20:40.767Z | 2024-10-31T12:30:05.979Z |
5354506 | 5354506 | 20241023022908_O5TW7 | UK00C6 | 2024-10-24T12:20:36.981Z | 2024-10-31T12:30:05.880Z |
5354443 | 5354443 | 20241023022641_auzQf | UK00C6 | 2024-10-24T12:20:33.978Z | 2024-10-31T12:30:05.855Z |
5353304 | 5353304 | 20241023011912_cXj4b | UK00C6 | 2024-10-24T12:19:38.635Z | 2024-10-31T12:30:04.120Z |
5353063 | 5353063 | 20241023010508_I9cpm | UK00C6 | 2024-10-24T12:19:30.942Z | 2024-10-31T12:30:03.754Z |
5352396 | 5352396 | 20241023003102_TFqam | UK00C6 | 2024-10-24T12:18:44.119Z | 2024-10-31T12:30:02.589Z |
5351728 | 5351728 | 20241022234932_ZaU5A | UK00C6 | 2024-10-24T12:17:54.124Z | 2024-10-31T12:30:00.835Z |
5351579 | 5351579 | 20241022233909_MJt1D | UK00C6 | 2024-10-24T12:17:40.479Z | 2024-10-31T12:30:00.558Z |
5351149 | 5351149 | 20241022230125_28scq | UK00C6 | 2024-10-24T12:17:16.050Z | 2024-10-31T12:29:59.547Z |
5350666 | 5350666 | 20241022221402_1ylaS | UK00C6 | 2024-10-24T12:16:13.332Z | 2024-10-31T12:29:58.638Z |
5350315 | 5350315 | 20241022213437_lYI4A | UK00C6 | 2024-10-24T12:15:35.445Z | 2024-10-31T12:29:57.741Z |
5342365 | 5342365 | 20241022022220_skh9I | UK00C6 | 2024-10-23T12:16:49.646Z | 2024-10-30T12:26:48.314Z |
5340531 | 5340531 | 20241022002559_CHEGA | UK00C6 | 2024-10-23T12:14:37.303Z | 2024-10-30T12:26:45.960Z |
5340325 | 5340325 | 20241022000513_h8Zw7 | UK00C6 | 2024-10-23T12:14:28.552Z | 2024-10-30T12:26:45.678Z |
5340313 | 5340313 | 20241022000454_7IN1h | UK00C6 | 2024-10-23T12:14:28.225Z | 2024-10-30T12:26:45.673Z |
5340016 | 5340016 | 20241021233606_pGvEy | UK00C6 | 2024-10-23T12:14:14.366Z | 2024-10-30T12:26:45.252Z |
5339584 | 5339584 | 20241021225612_AECML | UK00C6 | 2024-10-23T12:13:21.442Z | 2024-10-30T12:26:44.493Z |
5339567 | 5339567 | 20241021225428_XOx2I | UK00C6 | 2024-10-23T12:13:20.258Z | 2024-10-30T12:26:44.453Z |
5339444 | 5339444 | 20241021223931_0w4DL | UK00C6 | 2024-10-23T12:13:07.400Z | 2024-10-30T12:26:44.193Z |
5319830 | 5319830 | 20241017211307_toKgR | UK00C6 | 2024-10-19T12:03:54.007Z | 2024-10-26T12:27:53.191Z |
5302828 | 5302828 | 20241013014851_x8kzl | UK00C6 | 2024-10-14T12:16:49.998Z | 2024-10-21T12:24:13.347Z |
5301862 | 5301862 | 20241013001203_2e1U5 | UK00C6 | 2024-10-14T12:15:41.071Z | 2024-10-21T12:24:02.621Z |
5301825 | 5301825 | 20241013000855_vCuAD | UK00C6 | 2024-10-14T12:15:40.100Z | 2024-10-21T12:24:02.234Z |
5301382 | 5301382 | 20241012231627_7SuBy | UK00C6 | 2024-10-14T12:15:22.584Z | 2024-10-21T12:23:57.908Z |
5285549 | 5285549 | 20241011040400_5QEXj | UK00C6 | 2024-10-12T12:18:14.189Z | 2024-10-19T12:28:03.487Z |
5284832 | 5284832 | 20241011031244_rxn7c | UK00C6 | 2024-10-12T12:17:40.893Z | 2024-10-19T12:27:58.404Z |
5284579 | 5284579 | 20241011025500_e8Sv8 | UK00C6 | 2024-10-12T12:17:28.393Z | 2024-10-19T12:27:56.409Z |
5284519 | 5284519 | 20241011025103_qLNzv | UK00C6 | 2024-10-12T12:17:26.877Z | 2024-10-19T12:27:56.141Z |
5284346 | 5284346 | 20241011023714_vJcyK | UK00C6 | 2024-10-12T12:17:17.936Z | 2024-10-19T12:27:55.478Z |
5284260 | 5284260 | 20241011023333_5rL2r | UK00C6 | 2024-10-12T12:17:15.608Z | 2024-10-19T12:27:54.882Z |
5284121 | 5284121 | 20241011022129_Aw1Z7 | UK00C6 | 2024-10-12T12:17:09.210Z | 2024-10-19T12:27:54.022Z |
5284099 | 5284099 | 20241011022103_CZlFr | UK00C6 | 2024-10-12T12:17:08.353Z | 2024-10-19T12:27:53.959Z |
5284090 | 5284090 | 20241011022039_5BOel | UK00C6 | 2024-10-12T12:17:07.631Z | 2024-10-19T12:27:53.954Z |
5283266 | 5283266 | 20241011010758_s2rn2 | UK00C6 | 2024-10-12T12:16:33.797Z | 2024-10-19T12:27:50.198Z |
5276856 | 5276856 | 20241011051343_lr3BY | UK00C6 | 2024-10-12T12:01:55.490Z | 2024-10-20T12:23:14.410Z |
5276848 | 5276848 | 20241011051336_cg4aP | UK00C6 | 2024-10-12T12:01:52.687Z | 2024-10-20T12:23:14.347Z |
5276504 | 5276504 | 20241011044607_D2yuC | UK00C6 | 2024-10-12T12:01:17.106Z | 2024-10-20T12:23:10.292Z |
5275999 | 5275999 | 20241011041006_Tm7W1 | UK00C6 | 2024-10-12T12:00:10.645Z | 2024-10-20T12:23:03.735Z |
5275127 | 5275127 | 20241010010641_FOh3c | UK00C6 | 2024-10-11T12:15:17.424Z | 2024-10-18T12:22:14.093Z |
5274894 | 5274894 | 20241010000127_hhbVI | UK00C6 | 2024-10-11T12:14:57.612Z | 2024-10-18T12:22:12.107Z |
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);