participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,471 rows where station_code = "UK00AA" 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 |
---|---|---|---|---|---|
5497536 | 5497536 | 20241107035735_Wba42 | UK00AA | 2024-11-08T14:13:56.718Z | 2024-11-08T14:14:35.366Z |
5497358 | 5497358 | 20241107032757_FhudJ | UK00AA | 2024-11-08T14:13:37.673Z | 2024-11-08T14:14:35.321Z |
5497317 | 5497317 | 20241107032142_bmmQb | UK00AA | 2024-11-08T14:13:31.932Z | 2024-11-08T14:14:35.309Z |
5497115 | 5497115 | 20241107024425_625pd | UK00AA | 2024-11-08T14:13:11.406Z | 2024-11-08T14:14:35.260Z |
5433231 | 5433231 | 20241029182515_hNiTW | UK00AA | 2024-10-31T12:21:59.931Z | 2024-11-07T14:26:36.992Z |
5433199 | 5433199 | 20241029180921_C0T1F | UK00AA | 2024-10-31T12:21:56.666Z | 2024-11-07T14:26:36.480Z |
5422970 | 5422970 | 20241027010124_7Aa2f | UK00AA | 2024-10-30T12:22:32.680Z | 2024-11-04T14:28:54.410Z |
5410816 | 5410816 | 20241027053826_w1Glx | UK00AA | 2024-10-29T12:18:05.508Z | 2024-11-04T14:29:05.566Z |
5409962 | 5409962 | 20241027044421_dpcfG | UK00AA | 2024-10-29T12:17:44.940Z | 2024-11-04T14:29:03.110Z |
5409693 | 5409693 | 20241027043052_za9cF | UK00AA | 2024-10-29T12:17:37.998Z | 2024-11-04T14:29:02.155Z |
5409647 | 5409647 | 20241027042922_3n8Bg | UK00AA | 2024-10-29T12:17:35.930Z | 2024-11-04T14:29:02.044Z |
5409555 | 5409555 | 20241027042425_9kHyr | UK00AA | 2024-10-29T12:17:29.974Z | 2024-11-04T14:29:01.952Z |
5409494 | 5409494 | 20241027042210_e6uaU | UK00AA | 2024-10-29T12:17:26.435Z | 2024-11-04T14:29:01.912Z |
5409483 | 5409483 | 20241027042043_mwgwH | UK00AA | 2024-10-29T12:17:25.724Z | 2024-11-04T14:29:01.853Z |
5409414 | 5409414 | 20241027041659_Vot6b | UK00AA | 2024-10-29T12:17:22.478Z | 2024-11-04T14:29:01.652Z |
5408949 | 5408949 | 20241027035101_vr3cI | UK00AA | 2024-10-29T12:16:57.866Z | 2024-11-04T14:29:00.850Z |
5408819 | 5408819 | 20241027034415_Ilfc7 | UK00AA | 2024-10-29T12:16:53.446Z | 2024-11-04T14:29:00.560Z |
5408742 | 5408742 | 20241027034110_gueNq | UK00AA | 2024-10-29T12:16:48.022Z | 2024-11-04T14:29:00.376Z |
5408565 | 5408565 | 20241027033030_vnuBv | UK00AA | 2024-10-29T12:16:36.124Z | 2024-11-04T14:28:59.618Z |
5408492 | 5408492 | 20241027032811_eSJI6 | UK00AA | 2024-10-29T12:16:33.053Z | 2024-11-04T14:28:59.560Z |
5408400 | 5408400 | 20241027032527_oJUey | UK00AA | 2024-10-29T12:16:26.612Z | 2024-11-04T14:28:59.317Z |
5408085 | 5408085 | 20241027030646_AYde8 | UK00AA | 2024-10-29T12:16:04.457Z | 2024-11-04T14:28:58.840Z |
5407800 | 5407800 | 20241027025303_FRLVV | UK00AA | 2024-10-29T12:15:42.504Z | 2024-11-04T14:28:58.162Z |
5407675 | 5407675 | 20241027024651_pn9Md | UK00AA | 2024-10-29T12:15:33.945Z | 2024-11-04T14:28:58.025Z |
5407614 | 5407614 | 20241027024416_ENltf | UK00AA | 2024-10-29T12:15:31.328Z | 2024-11-04T14:28:57.934Z |
5407551 | 5407551 | 20241027024129_ZWMSq | UK00AA | 2024-10-29T12:15:28.703Z | 2024-11-04T14:28:57.866Z |
5407530 | 5407530 | 20241027024051_zc2yN | UK00AA | 2024-10-29T12:15:28.249Z | 2024-11-04T14:28:57.842Z |
5407395 | 5407395 | 20241027023431_3Qr7X | UK00AA | 2024-10-29T12:15:23.586Z | 2024-11-04T14:28:57.488Z |
5407382 | 5407382 | 20241027023423_05cST | UK00AA | 2024-10-29T12:15:23.073Z | 2024-11-04T14:28:57.462Z |
5407053 | 5407053 | 20241027021846_CCLDK | UK00AA | 2024-10-29T12:15:10.139Z | 2024-11-04T14:28:56.813Z |
5406983 | 5406983 | 20241027021544_5IMa5 | UK00AA | 2024-10-29T12:15:04.259Z | 2024-11-04T14:28:56.748Z |
5406724 | 5406724 | 20241027015629_eguTw | UK00AA | 2024-10-29T12:14:34.696Z | 2024-11-04T14:28:56.306Z |
5406714 | 5406714 | 20241027015627_EOuer | UK00AA | 2024-10-29T12:14:34.383Z | 2024-11-04T14:28:56.302Z |
5406637 | 5406637 | 20241027015121_e4x6F | UK00AA | 2024-10-29T12:14:27.693Z | 2024-11-04T14:28:55.961Z |
5406503 | 5406503 | 20241027014130_Efvt8 | UK00AA | 2024-10-29T12:14:14.043Z | 2024-11-04T14:28:55.782Z |
5406323 | 5406323 | 20241027012728_I35oo | UK00AA | 2024-10-29T12:14:01.974Z | 2024-11-04T14:28:55.430Z |
5406267 | 5406267 | 20241027012414_P3opI | UK00AA | 2024-10-29T12:13:59.984Z | 2024-11-04T14:28:55.274Z |
5406247 | 5406247 | 20241027012331_BbnsN | UK00AA | 2024-10-29T12:13:59.057Z | 2024-11-04T14:28:55.249Z |
5406146 | 5406146 | 20241027011856_sK82K | UK00AA | 2024-10-29T12:13:53.413Z | 2024-11-04T14:28:55.160Z |
5406083 | 5406083 | 20241027011435_8w85A | UK00AA | 2024-10-29T12:13:50.564Z | 2024-11-04T14:28:54.977Z |
5405842 | 5405842 | 20241027010300_HEfvA | UK00AA | 2024-10-29T12:13:22.082Z | 2024-11-04T14:28:54.423Z |
5405825 | 5405825 | 20241027010123_llt5F | UK00AA | 2024-10-29T12:13:20.070Z | 2024-11-04T14:28:54.406Z |
5405745 | 5405745 | 20241027005515_H1z5l | UK00AA | 2024-10-29T12:13:11.528Z | 2024-11-04T14:28:54.130Z |
5405369 | 5405369 | 20241027002952_3WxUx | UK00AA | 2024-10-29T12:12:51.763Z | 2024-11-04T14:28:53.353Z |
5405137 | 5405137 | 20241027001536_kD0yB | UK00AA | 2024-10-29T12:12:32.021Z | 2024-11-04T14:28:52.720Z |
5405093 | 5405093 | 20241027001255_6GNj0 | UK00AA | 2024-10-29T12:12:25.807Z | 2024-11-04T14:28:52.665Z |
5404879 | 5404879 | 20241026235809_Hbz7b | UK00AA | 2024-10-29T12:12:04.627Z | 2024-11-04T14:28:52.233Z |
5404762 | 5404762 | 20241026235100_g3gOd | UK00AA | 2024-10-29T12:11:56.357Z | 2024-11-04T14:28:51.907Z |
5404655 | 5404655 | 20241026234218_KmOy2 | UK00AA | 2024-10-29T12:11:48.565Z | 2024-11-04T14:28:51.463Z |
5404624 | 5404624 | 20241026234100_TL2Hf | UK00AA | 2024-10-29T12:11:46.814Z | 2024-11-04T14:28:51.443Z |
5404584 | 5404584 | 20241026233937_xD3rB | UK00AA | 2024-10-29T12:11:44.608Z | 2024-11-04T14:28:51.358Z |
5404448 | 5404448 | 20241026232650_31hau | UK00AA | 2024-10-29T12:11:27.911Z | 2024-11-04T14:28:51.056Z |
5400200 | 5400200 | 20241026060048_OMbqX | UK00AA | 2024-10-28T12:20:27.350Z | 2024-11-03T14:27:41.630Z |
5400096 | 5400096 | 20241026053911_5smiy | UK00AA | 2024-10-28T12:20:22.908Z | 2024-11-03T14:27:41.299Z |
5400075 | 5400075 | 20241026053607_D5Hb6 | UK00AA | 2024-10-28T12:20:21.764Z | 2024-11-03T14:27:41.266Z |
5400025 | 5400025 | 20241026052238_facmO | UK00AA | 2024-10-28T12:20:19.233Z | 2024-11-03T14:27:41.114Z |
5399969 | 5399969 | 20241026051807_R1307 | UK00AA | 2024-10-28T12:20:17.648Z | 2024-11-03T14:27:40.899Z |
5399947 | 5399947 | 20241026051545_UyWv1 | UK00AA | 2024-10-28T12:20:17.305Z | 2024-11-03T14:27:40.888Z |
5399944 | 5399944 | 20241026051438_31Uik | UK00AA | 2024-10-28T12:20:17.253Z | 2024-11-03T14:27:40.883Z |
5399871 | 5399871 | 20241026050800_xn3ww | UK00AA | 2024-10-28T12:20:14.015Z | 2024-11-03T14:27:40.641Z |
5399824 | 5399824 | 20241026050517_HM2FP | UK00AA | 2024-10-28T12:20:12.318Z | 2024-11-03T14:27:40.576Z |
5399699 | 5399699 | 20241026044915_5kil2 | UK00AA | 2024-10-28T12:20:08.161Z | 2024-11-03T14:27:40.294Z |
5399676 | 5399676 | 20241026044706_BjUw1 | UK00AA | 2024-10-28T12:20:05.641Z | 2024-11-03T14:27:40.221Z |
5399638 | 5399638 | 20241026044312_Ixke8 | UK00AA | 2024-10-28T12:20:04.561Z | 2024-11-03T14:27:40.158Z |
5399544 | 5399544 | 20241026043330_T2J2E | UK00AA | 2024-10-28T12:20:01.760Z | 2024-11-03T14:27:39.943Z |
5399407 | 5399407 | 20241026041545_XJ0ic | UK00AA | 2024-10-28T12:19:58.479Z | 2024-11-03T14:27:39.617Z |
5399343 | 5399343 | 20241026041140_R376e | UK00AA | 2024-10-28T12:19:55.327Z | 2024-11-03T14:27:39.506Z |
5399227 | 5399227 | 20241026040325_OaDjC | UK00AA | 2024-10-28T12:19:51.838Z | 2024-11-03T14:27:39.269Z |
5399220 | 5399220 | 20241026040219_cdA3y | UK00AA | 2024-10-28T12:19:51.594Z | 2024-11-03T14:27:39.253Z |
5399183 | 5399183 | 20241026035937_oYHlK | UK00AA | 2024-10-28T12:19:50.784Z | 2024-11-03T14:27:39.194Z |
5399169 | 5399169 | 20241026035758_sfM3v | UK00AA | 2024-10-28T12:19:50.313Z | 2024-11-03T14:27:39.167Z |
5399114 | 5399114 | 20241026035415_3DSX9 | UK00AA | 2024-10-28T12:19:48.821Z | 2024-11-03T14:27:39.052Z |
5399025 | 5399025 | 20241026034526_9a8Io | UK00AA | 2024-10-28T12:19:44.692Z | 2024-11-03T14:27:38.906Z |
5399007 | 5399007 | 20241026034428_IxtRF | UK00AA | 2024-10-28T12:19:44.041Z | 2024-11-03T14:27:38.862Z |
5398904 | 5398904 | 20241026033659_pKDuf | UK00AA | 2024-10-28T12:19:39.733Z | 2024-11-03T14:27:38.385Z |
5398873 | 5398873 | 20241026033425_gjJXo | UK00AA | 2024-10-28T12:19:38.159Z | 2024-11-03T14:27:38.313Z |
5398749 | 5398749 | 20241026032516_wFRR8 | UK00AA | 2024-10-28T12:19:30.214Z | 2024-11-03T14:27:37.967Z |
5398742 | 5398742 | 20241026032349_hdf7j | UK00AA | 2024-10-28T12:19:30.069Z | 2024-11-03T14:27:37.942Z |
5398690 | 5398690 | 20241026031900_tYto2 | UK00AA | 2024-10-28T12:19:28.487Z | 2024-11-03T14:27:37.732Z |
5398610 | 5398610 | 20241026031113_Sr2hc | UK00AA | 2024-10-28T12:19:23.753Z | 2024-11-03T14:27:36.921Z |
5398547 | 5398547 | 20241026030600_My2El | UK00AA | 2024-10-28T12:19:21.085Z | 2024-11-03T14:27:36.769Z |
5398372 | 5398372 | 20241026025047_KUrZ5 | UK00AA | 2024-10-28T12:19:13.032Z | 2024-11-03T14:27:36.138Z |
5398357 | 5398357 | 20241026024928_OVUy1 | UK00AA | 2024-10-28T12:19:12.141Z | 2024-11-03T14:27:36.048Z |
5398092 | 5398092 | 20241026022550_kEx2M | UK00AA | 2024-10-28T12:19:00.679Z | 2024-11-03T14:27:35.374Z |
5397902 | 5397902 | 20241026020619_C4SMr | UK00AA | 2024-10-28T12:18:49.860Z | 2024-11-03T14:27:34.458Z |
5397631 | 5397631 | 20241026014401_WmO0e | UK00AA | 2024-10-28T12:18:30.447Z | 2024-11-03T14:27:33.622Z |
5397626 | 5397626 | 20241026014401_kfMnR | UK00AA | 2024-10-28T12:18:30.360Z | 2024-11-03T14:27:33.621Z |
5397510 | 5397510 | 20241026013556_PAgLj | UK00AA | 2024-10-28T12:18:25.871Z | 2024-11-03T14:27:33.292Z |
5397475 | 5397475 | 20241026013248_pQQM4 | UK00AA | 2024-10-28T12:18:24.430Z | 2024-11-03T14:27:33.141Z |
5397459 | 5397459 | 20241026013130_9KjkZ | UK00AA | 2024-10-28T12:18:23.304Z | 2024-11-03T14:27:33.032Z |
5397452 | 5397452 | 20241026013125_od88K | UK00AA | 2024-10-28T12:18:23.018Z | 2024-11-03T14:27:33.026Z |
5397310 | 5397310 | 20241026011649_g33Cl | UK00AA | 2024-10-28T12:18:15.465Z | 2024-11-03T14:27:32.560Z |
5397248 | 5397248 | 20241026011311_udF3Z | UK00AA | 2024-10-28T12:18:13.062Z | 2024-11-03T14:27:32.433Z |
5397164 | 5397164 | 20241026010705_2UWgg | UK00AA | 2024-10-28T12:18:10.011Z | 2024-11-03T14:27:32.127Z |
5397025 | 5397025 | 20241026005711_CGvRJ | UK00AA | 2024-10-28T12:18:03.616Z | 2024-11-03T14:27:31.779Z |
5396859 | 5396859 | 20241026004245_5IlXr | UK00AA | 2024-10-28T12:17:58.115Z | 2024-11-03T14:27:31.269Z |
5396760 | 5396760 | 20241026003053_MeuLc | UK00AA | 2024-10-28T12:17:55.169Z | 2024-11-03T14:27:30.859Z |
5396497 | 5396497 | 20241026000809_cadJN | UK00AA | 2024-10-28T12:17:47.224Z | 2024-11-03T14:27:30.018Z |
5396213 | 5396213 | 20241025234759_NWo1d | UK00AA | 2024-10-28T12:17:25.850Z | 2024-11-03T14:27:28.871Z |
5396052 | 5396052 | 20241025233600_xBX62 | UK00AA | 2024-10-28T12:17:16.184Z | 2024-11-03T14:27:28.298Z |
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);