participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,868 rows where station_code = "UK0024" 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 |
---|---|---|---|---|---|
5564934 | 5564934 | 20241120034010_Iiau5 | UK0024 | 2024-11-21T14:18:15.598Z | 2024-11-22T14:21:39.661Z |
5564920 | 5564920 | 20241120033942_ViV6y | UK0024 | 2024-11-21T14:18:15.380Z | 2024-11-22T14:21:39.653Z |
5564902 | 5564902 | 20241120033803_0OxdL | UK0024 | 2024-11-21T14:18:14.703Z | 2024-11-22T14:21:39.454Z |
5564898 | 5564898 | 20241120033741_QQUXz | UK0024 | 2024-11-21T14:18:14.468Z | 2024-11-22T14:21:39.420Z |
5564764 | 5564764 | 20241120032522_PLRQM | UK0024 | 2024-11-21T14:18:02.523Z | 2024-11-22T14:21:36.329Z |
5564733 | 5564733 | 20241120032404_SX2pG | UK0024 | 2024-11-21T14:18:01.085Z | 2024-11-22T14:21:36.072Z |
5564515 | 5564515 | 20241120030524_q8bDr | UK0024 | 2024-11-21T14:17:44.796Z | 2024-11-22T14:21:33.099Z |
5564064 | 5564064 | 20241120022632_o9Nde | UK0024 | 2024-11-21T14:17:07.441Z | 2024-11-22T14:21:26.765Z |
5564033 | 5564033 | 20241120022453_GprHU | UK0024 | 2024-11-21T14:17:05.627Z | 2024-11-22T14:21:26.632Z |
5563541 | 5563541 | 20241120013927_h9RaX | UK0024 | 2024-11-21T14:16:16.200Z | 2024-11-22T14:21:17.892Z |
5563463 | 5563463 | 20241120013131_MTPl8 | UK0024 | 2024-11-21T14:16:07.542Z | 2024-11-22T14:21:16.012Z |
5563114 | 5563114 | 20241120005415_rN32y | UK0024 | 2024-11-21T14:15:37.313Z | 2024-11-22T14:21:09.840Z |
5563023 | 5563023 | 20241120004416_o30XE | UK0024 | 2024-11-21T14:15:32.127Z | 2024-11-22T14:21:07.905Z |
5562874 | 5562874 | 20241120002259_ApmAp | UK0024 | 2024-11-21T14:15:25.869Z | 2024-11-22T14:21:05.766Z |
5562647 | 5562647 | 20241120000139_AeqYk | UK0024 | 2024-11-21T14:15:15.297Z | 2024-11-22T14:21:01.694Z |
5562535 | 5562535 | 20241119234903_NDZLV | UK0024 | 2024-11-21T14:15:06.632Z | 2024-11-22T14:21:00.014Z |
5562377 | 5562377 | 20241119233209_QQk1C | UK0024 | 2024-11-21T14:14:45.772Z | 2024-11-22T14:20:56.873Z |
5562353 | 5562353 | 20241119232929_K8iSJ | UK0024 | 2024-11-21T14:14:44.396Z | 2024-11-22T14:20:56.551Z |
5562225 | 5562225 | 20241119231214_kx2wC | UK0024 | 2024-11-21T14:14:34.230Z | 2024-11-22T14:20:54.394Z |
5562205 | 5562205 | 20241119230935_2b2gR | UK0024 | 2024-11-21T14:14:32.173Z | 2024-11-22T14:20:53.992Z |
5562135 | 5562135 | 20241119230258_L3Qrs | UK0024 | 2024-11-21T14:14:28.483Z | 2024-11-22T14:20:53.257Z |
5561972 | 5561972 | 20241119224031_iKoUY | UK0024 | 2024-11-21T14:14:17.782Z | 2024-11-22T14:20:50.827Z |
5561795 | 5561795 | 20241119221150_0MOWD | UK0024 | 2024-11-21T14:14:06.889Z | 2024-11-22T14:20:46.649Z |
5561438 | 5561438 | 20241119203345_8CO4l | UK0024 | 2024-11-21T14:13:16.717Z | 2024-11-22T14:20:36.215Z |
5561305 | 5561305 | 20241119194138_0pbk5 | UK0024 | 2024-11-21T14:13:03.008Z | 2024-11-22T14:20:30.482Z |
5561195 | 5561195 | 20241119190059_FVj91 | UK0024 | 2024-11-21T14:12:35.434Z | 2024-11-22T14:20:25.484Z |
5557779 | 5557779 | 20241120051129_xm8eO | UK0024 | 2024-11-21T14:01:44.657Z | 2024-11-22T14:19:21.127Z |
5557757 | 5557757 | 20241120051032_O5jIp | UK0024 | 2024-11-21T14:01:41.188Z | 2024-11-22T14:19:21.124Z |
5557658 | 5557658 | 20241120050356_gCno8 | UK0024 | 2024-11-21T14:01:26.618Z | 2024-11-22T14:19:21.106Z |
5557295 | 5557295 | 20241120043408_HlMfl | UK0024 | 2024-11-21T14:00:27.134Z | 2024-11-22T14:19:21.049Z |
5557266 | 5557266 | 20241120043240_3d995 | UK0024 | 2024-11-21T14:00:19.246Z | 2024-11-22T14:19:21.040Z |
5552615 | 5552615 | 20241117191658_hnfeB | UK0024 | 2024-11-19T14:08:45.880Z | 2024-11-22T14:22:42.923Z |
5544974 | 5544974 | 20241115204754_sOqLx | UK0024 | 2024-11-17T14:03:33.033Z | 2024-11-22T14:23:34.974Z |
5544949 | 5544949 | 20241115184131_o32Vq | UK0024 | 2024-11-17T14:03:25.608Z | 2024-11-22T14:23:33.498Z |
5544947 | 5544947 | 20241115183044_DWL38 | UK0024 | 2024-11-17T14:03:25.059Z | 2024-11-22T14:23:33.481Z |
5543140 | 5543140 | 20241114214953_HFqqh | UK0024 | 2024-11-16T14:05:36.885Z | 2024-11-22T14:23:57.176Z |
5543077 | 5543077 | 20241114194847_YmkL2 | UK0024 | 2024-11-16T14:05:29.364Z | 2024-11-22T14:23:56.746Z |
5541223 | 5541223 | 20241113204726_Fvv2b | UK0024 | 2024-11-15T14:06:58.620Z | 2024-11-22T14:24:17.143Z |
5541212 | 5541212 | 20241113194715_QUcYb | UK0024 | 2024-11-15T14:06:56.964Z | 2024-11-22T14:24:16.928Z |
5541172 | 5541172 | 20241113184445_RF1Bl | UK0024 | 2024-11-15T14:06:50.266Z | 2024-11-22T14:24:16.267Z |
5532722 | 5532722 | 20241112055442_TXWVr | UK0024 | 2024-11-13T14:17:12.408Z | 2024-11-20T14:26:25.823Z |
5532650 | 5532650 | 20241112054811_8UcpU | UK0024 | 2024-11-13T14:17:07.250Z | 2024-11-20T14:26:25.475Z |
5532491 | 5532491 | 20241112052922_J6BCI | UK0024 | 2024-11-13T14:16:52.695Z | 2024-11-20T14:26:23.928Z |
5532407 | 5532407 | 20241112051854_pPpoi | UK0024 | 2024-11-13T14:16:43.189Z | 2024-11-20T14:26:22.734Z |
5531920 | 5531920 | 20241112041953_jwbWW | UK0024 | 2024-11-13T14:16:02.612Z | 2024-11-20T14:26:15.938Z |
5531841 | 5531841 | 20241112041246_z2lyL | UK0024 | 2024-11-13T14:15:58.408Z | 2024-11-20T14:26:15.158Z |
5531804 | 5531804 | 20241112041027_pHKRI | UK0024 | 2024-11-13T14:15:55.694Z | 2024-11-20T14:26:14.619Z |
5531693 | 5531693 | 20241112040019_CnnY7 | UK0024 | 2024-11-13T14:15:50.961Z | 2024-11-20T14:26:13.556Z |
5531591 | 5531591 | 20241112035024_NVoHD | UK0024 | 2024-11-13T14:15:45.853Z | 2024-11-20T14:26:12.600Z |
5531472 | 5531472 | 20241112034137_8FFEJ | UK0024 | 2024-11-13T14:15:41.564Z | 2024-11-20T14:26:11.602Z |
5531416 | 5531416 | 20241112033848_bGux5 | UK0024 | 2024-11-13T14:15:38.370Z | 2024-11-20T14:26:11.170Z |
5531071 | 5531071 | 20241112031046_6Vq24 | UK0024 | 2024-11-13T14:15:08.496Z | 2024-11-20T14:26:06.993Z |
5530956 | 5530956 | 20241112030233_IQ3LL | UK0024 | 2024-11-13T14:14:55.128Z | 2024-11-20T14:26:05.643Z |
5530858 | 5530858 | 20241112025511_dL4uw | UK0024 | 2024-11-13T14:14:44.911Z | 2024-11-20T14:26:04.053Z |
5530817 | 5530817 | 20241112025032_6ROow | UK0024 | 2024-11-13T14:14:41.838Z | 2024-11-20T14:26:03.895Z |
5530804 | 5530804 | 20241112024948_GzbJj | UK0024 | 2024-11-13T14:14:40.119Z | 2024-11-20T14:26:03.694Z |
5529072 | 5529072 | 20241111232525_DMIC8 | UK0024 | 2024-11-13T14:12:02.689Z | 2024-11-20T14:25:39.461Z |
5528518 | 5528518 | 20241111212059_LRjjU | UK0024 | 2024-11-13T14:11:00.926Z | 2024-11-20T14:25:31.780Z |
5528333 | 5528333 | 20241111202454_1tv5h | UK0024 | 2024-11-13T14:10:27.953Z | 2024-11-20T14:25:28.539Z |
5528242 | 5528242 | 20241111200349_B3fEi | UK0024 | 2024-11-13T14:10:19.086Z | 2024-11-20T14:25:27.223Z |
5528039 | 5528039 | 20241111192108_kGuc5 | UK0024 | 2024-11-13T14:09:44.528Z | 2024-11-20T14:25:24.570Z |
5527815 | 5527815 | 20241111183849_7UY69 | UK0024 | 2024-11-13T14:09:18.557Z | 2024-11-20T14:25:21.219Z |
5525673 | 5525673 | 20241112060352_milqF | UK0024 | 2024-11-13T14:00:18.302Z | 2024-11-21T14:25:24.882Z |
5522698 | 5522698 | 20241110210500_6AfDd | UK0024 | 2024-11-12T14:13:58.424Z | 2024-11-19T14:22:05.340Z |
5454586 | 5454586 | 20241031044138_E1Lby | UK0024 | 2024-11-02T12:23:13.297Z | 2024-11-08T14:23:24.290Z |
5454339 | 5454339 | 20241031041119_6UlUN | UK0024 | 2024-11-02T12:23:01.626Z | 2024-11-08T14:23:22.411Z |
5453985 | 5453985 | 20241031032552_X64j1 | UK0024 | 2024-11-02T12:22:46.799Z | 2024-11-08T14:23:19.827Z |
5453964 | 5453964 | 20241031032311_a1MQY | UK0024 | 2024-11-02T12:22:46.257Z | 2024-11-08T14:23:19.793Z |
5453917 | 5453917 | 20241031031617_9qK6N | UK0024 | 2024-11-02T12:22:44.935Z | 2024-11-08T14:23:19.663Z |
5453850 | 5453850 | 20241031031011_0uimx | UK0024 | 2024-11-02T12:22:43.735Z | 2024-11-08T14:23:19.541Z |
5453776 | 5453776 | 20241031025835_68J4T | UK0024 | 2024-11-02T12:22:42.472Z | 2024-11-08T14:23:19.036Z |
5453764 | 5453764 | 20241031025737_Azrbe | UK0024 | 2024-11-02T12:22:42.138Z | 2024-11-08T14:23:19.014Z |
5453669 | 5453669 | 20241031024101_xFdXo | UK0024 | 2024-11-02T12:22:39.716Z | 2024-11-08T14:23:18.632Z |
5453621 | 5453621 | 20241031023313_67EM2 | UK0024 | 2024-11-02T12:22:37.303Z | 2024-11-08T14:23:18.269Z |
5453603 | 5453603 | 20241031022946_fJq2a | UK0024 | 2024-11-02T12:22:36.855Z | 2024-11-08T14:23:18.176Z |
5453563 | 5453563 | 20241031022525_5xCyh | UK0024 | 2024-11-02T12:22:36.145Z | 2024-11-08T14:23:18.100Z |
5452522 | 5452522 | 20241101032951_W0ZXq | UK0024 | 2024-11-02T12:18:55.267Z | 2024-11-09T14:24:31.335Z |
5450525 | 5450525 | 20241031193924_YUDc6 | UK0024 | 2024-11-02T12:15:34.227Z | 2024-11-09T14:24:16.400Z |
5450440 | 5450440 | 20241031191901_yzeql | UK0024 | 2024-11-02T12:15:19.082Z | 2024-11-09T14:24:15.984Z |
5444387 | 5444387 | 20241031011530_3Sdwk | UK0024 | 2024-11-01T12:21:15.302Z | 2024-11-08T14:23:15.263Z |
5444313 | 5444313 | 20241031010744_mp9u2 | UK0024 | 2024-11-01T12:21:12.473Z | 2024-11-08T14:23:14.325Z |
5444150 | 5444150 | 20241031005305_TVn3d | UK0024 | 2024-11-01T12:21:07.852Z | 2024-11-08T14:23:14.026Z |
5443892 | 5443892 | 20241031002552_F3uSb | UK0024 | 2024-11-01T12:20:55.866Z | 2024-11-08T14:23:13.032Z |
5443886 | 5443886 | 20241031002414_iY322 | UK0024 | 2024-11-01T12:20:55.362Z | 2024-11-08T14:23:12.997Z |
5443850 | 5443850 | 20241031002028_bRhO6 | UK0024 | 2024-11-01T12:20:54.411Z | 2024-11-08T14:23:12.731Z |
5443792 | 5443792 | 20241031001542_P31Ct | UK0024 | 2024-11-01T12:20:51.767Z | 2024-11-08T14:23:12.476Z |
5443769 | 5443769 | 20241031001224_8FaBC | UK0024 | 2024-11-01T12:20:49.925Z | 2024-11-08T14:23:12.170Z |
5443724 | 5443724 | 20241031000917_gSzIr | UK0024 | 2024-11-01T12:20:47.926Z | 2024-11-08T14:23:12.098Z |
5443704 | 5443704 | 20241031000722_uL24G | UK0024 | 2024-11-01T12:20:47.164Z | 2024-11-08T14:23:12.015Z |
5443691 | 5443691 | 20241031000525_nXwxN | UK0024 | 2024-11-01T12:20:46.488Z | 2024-11-08T14:23:11.997Z |
5443672 | 5443672 | 20241031000253_aR9vF | UK0024 | 2024-11-01T12:20:45.707Z | 2024-11-08T14:23:11.975Z |
5443641 | 5443641 | 20241030235825_rFWTk | UK0024 | 2024-11-01T12:20:43.688Z | 2024-11-08T14:23:11.845Z |
5440901 | 5440901 | 20241030232203_YJQtQ | UK0024 | 2024-11-01T12:15:58.710Z | 2024-11-08T14:23:11.004Z |
5440699 | 5440699 | 20241030225207_cnf2R | UK0024 | 2024-11-01T12:15:45.359Z | 2024-11-08T14:23:10.447Z |
5440684 | 5440684 | 20241030224748_3GSWN | UK0024 | 2024-11-01T12:15:44.162Z | 2024-11-08T14:23:10.323Z |
5440503 | 5440503 | 20241030222117_IjmIG | UK0024 | 2024-11-01T12:15:33.764Z | 2024-11-08T14:23:09.743Z |
5440479 | 5440479 | 20241030221825_QP3OS | UK0024 | 2024-11-01T12:15:32.673Z | 2024-11-08T14:23:09.564Z |
5440382 | 5440382 | 20241030220526_2eN0B | UK0024 | 2024-11-01T12:15:28.122Z | 2024-11-08T14:23:09.300Z |
5440229 | 5440229 | 20241030214503_T1IKv | UK0024 | 2024-11-01T12:15:02.929Z | 2024-11-08T14:23:08.090Z |
5440184 | 5440184 | 20241030213846_GVFSz | UK0024 | 2024-11-01T12:14:56.183Z | 2024-11-08T14:23:07.676Z |
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);