participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,126 rows where station_code = "UK0074" 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 |
---|---|---|---|---|---|
5133811 | 5133811 | 20240916040726_LvkS6 | UK0074 | 2024-09-19T12:17:08.347Z | 2024-09-19T12:17:08.347Z |
5133791 | 5133791 | 20240916040537_hv4M6 | UK0074 | 2024-09-19T12:17:08.083Z | 2024-09-19T12:17:08.083Z |
5133546 | 5133546 | 20240916033902_lg4Xv | UK0074 | 2024-09-19T12:17:01.291Z | 2024-09-19T12:17:01.291Z |
5133466 | 5133466 | 20240916033130_5v03X | UK0074 | 2024-09-19T12:16:57.404Z | 2024-09-19T12:16:57.404Z |
5133430 | 5133430 | 20240916032951_wW9CU | UK0074 | 2024-09-19T12:16:56.299Z | 2024-09-19T12:16:56.299Z |
5133390 | 5133390 | 20240916032749_bSoYG | UK0074 | 2024-09-19T12:16:55.901Z | 2024-09-19T12:16:55.901Z |
5133169 | 5133169 | 20240916030336_0Hf2T | UK0074 | 2024-09-19T12:16:46.091Z | 2024-09-19T12:16:46.091Z |
5133105 | 5133105 | 20240916025621_vpekO | UK0074 | 2024-09-19T12:16:44.228Z | 2024-09-19T12:16:44.228Z |
5133016 | 5133016 | 20240916024227_DaFIN | UK0074 | 2024-09-19T12:16:40.984Z | 2024-09-19T12:16:40.984Z |
5132955 | 5132955 | 20240916023252_h1jBd | UK0074 | 2024-09-19T12:16:38.657Z | 2024-09-19T12:16:38.657Z |
5132862 | 5132862 | 20240916022338_51p7l | UK0074 | 2024-09-19T12:16:34.830Z | 2024-09-19T12:16:34.830Z |
5132809 | 5132809 | 20240916021515_8gZYt | UK0074 | 2024-09-19T12:16:33.366Z | 2024-09-19T12:16:33.366Z |
5132132 | 5132132 | 20240915232953_du1W3 | UK0074 | 2024-09-19T12:15:52.168Z | 2024-09-19T12:15:52.168Z |
5125810 | 5125810 | 20240918040043_GsvGV | UK0074 | 2024-09-19T12:04:09.394Z | 2024-09-19T12:06:42.089Z |
5125722 | 5125722 | 20240918033037_kEVxL | UK0074 | 2024-09-19T12:03:57.366Z | 2024-09-19T12:06:42.075Z |
5125527 | 5125527 | 20240918025434_wsLK5 | UK0074 | 2024-09-19T12:03:27.256Z | 2024-09-19T12:06:42.047Z |
5125398 | 5125398 | 20240918022835_IQf3K | UK0074 | 2024-09-19T12:03:09.420Z | 2024-09-19T12:06:42.026Z |
5107708 | 5107708 | 20240913040843_C1k02 | UK0074 | 2024-09-17T12:13:22.109Z | 2024-09-19T12:20:47.477Z |
5107623 | 5107623 | 20240913040525_03EZb | UK0074 | 2024-09-17T12:13:19.689Z | 2024-09-19T12:20:47.369Z |
5106678 | 5106678 | 20240913033221_VNeiw | UK0074 | 2024-09-17T12:12:59.366Z | 2024-09-19T12:20:46.276Z |
5104408 | 5104408 | 20240913020724_aCtMY | UK0074 | 2024-09-17T12:11:34.712Z | 2024-09-19T12:20:41.449Z |
5097394 | 5097394 | 20240913004503_V9g8l | UK0074 | 2024-09-16T12:17:12.044Z | 2024-09-19T12:20:38.467Z |
5094353 | 5094353 | 20240912035747_oN3vz | UK0074 | 2024-09-16T12:14:41.750Z | 2024-09-19T12:21:16.077Z |
5094200 | 5094200 | 20240912035231_PGOdk | UK0074 | 2024-09-16T12:14:38.818Z | 2024-09-19T12:21:16.015Z |
5093830 | 5093830 | 20240912033846_7WtuD | UK0074 | 2024-09-16T12:14:26.598Z | 2024-09-19T12:21:15.688Z |
5093770 | 5093770 | 20240912033425_adhEa | UK0074 | 2024-09-16T12:14:25.034Z | 2024-09-19T12:21:15.642Z |
5093425 | 5093425 | 20240912032035_Qdqhk | UK0074 | 2024-09-16T12:14:16.842Z | 2024-09-19T12:21:15.313Z |
5093357 | 5093357 | 20240912031928_4Y5NZ | UK0074 | 2024-09-16T12:14:16.055Z | 2024-09-19T12:21:15.296Z |
5092920 | 5092920 | 20240912030140_a5chr | UK0074 | 2024-09-16T12:14:07.127Z | 2024-09-19T12:21:14.709Z |
5092508 | 5092508 | 20240912024830_JTMxq | UK0074 | 2024-09-16T12:13:58.451Z | 2024-09-19T12:21:14.283Z |
5092469 | 5092469 | 20240912024703_Ty3OD | UK0074 | 2024-09-16T12:13:57.752Z | 2024-09-19T12:21:14.267Z |
5092138 | 5092138 | 20240912023729_nfB2s | UK0074 | 2024-09-16T12:13:41.367Z | 2024-09-19T12:21:13.661Z |
5091868 | 5091868 | 20240912022558_vgYRn | UK0074 | 2024-09-16T12:13:28.421Z | 2024-09-19T12:21:13.430Z |
5091592 | 5091592 | 20240912021440_VW7Wo | UK0074 | 2024-09-16T12:13:12.251Z | 2024-09-19T12:21:13.241Z |
5091506 | 5091506 | 20240912021102_vGA9H | UK0074 | 2024-09-16T12:13:08.530Z | 2024-09-19T12:21:13.099Z |
5090979 | 5090979 | 20240912015517_Dgu91 | UK0074 | 2024-09-16T12:12:46.105Z | 2024-09-19T12:21:12.442Z |
5090614 | 5090614 | 20240912013436_rxc4i | UK0074 | 2024-09-16T12:12:26.504Z | 2024-09-19T12:21:11.463Z |
5090499 | 5090499 | 20240912012814_Zl3Rq | UK0074 | 2024-09-16T12:12:22.072Z | 2024-09-19T12:21:11.356Z |
5090337 | 5090337 | 20240912012130_1TI2u | UK0074 | 2024-09-16T12:12:14.456Z | 2024-09-19T12:21:11.221Z |
5090028 | 5090028 | 20240912010718_oZHrf | UK0074 | 2024-09-16T12:11:56.725Z | 2024-09-19T12:21:10.934Z |
5090001 | 5090001 | 20240912010611_z5v1o | UK0074 | 2024-09-16T12:11:55.022Z | 2024-09-19T12:21:10.919Z |
5089581 | 5089581 | 20240912004920_5CiHx | UK0074 | 2024-09-16T12:11:30.636Z | 2024-09-19T12:21:10.071Z |
5089443 | 5089443 | 20240912004208_euSb7 | UK0074 | 2024-09-16T12:11:25.557Z | 2024-09-19T12:21:09.966Z |
5089248 | 5089248 | 20240912003002_1oHpV | UK0074 | 2024-09-16T12:11:18.385Z | 2024-09-19T12:21:09.841Z |
5089120 | 5089120 | 20240912002637_8HVRz | UK0074 | 2024-09-16T12:11:15.396Z | 2024-09-19T12:21:09.747Z |
5087610 | 5087610 | 20240912233440_TqjaQ | UK0074 | 2024-09-16T12:07:06.973Z | 2024-09-19T12:20:35.511Z |
5087348 | 5087348 | 20240912232406_fvdz3 | UK0074 | 2024-09-16T12:06:52.789Z | 2024-09-19T12:20:34.682Z |
5087219 | 5087219 | 20240912231627_BIa4M | UK0074 | 2024-09-16T12:06:47.583Z | 2024-09-19T12:20:34.206Z |
5087118 | 5087118 | 20240912230849_iiMFc | UK0074 | 2024-09-16T12:06:40.099Z | 2024-09-19T12:20:34.036Z |
5085922 | 5085922 | 20240912215747_F0Rw8 | UK0074 | 2024-09-16T12:05:02.851Z | 2024-09-19T12:20:29.793Z |
5080658 | 5080658 | 20240911041939_va566 | UK0074 | 2024-09-15T12:17:09.645Z | 2024-09-19T12:21:43.378Z |
5080347 | 5080347 | 20240911035105_xeqiQ | UK0074 | 2024-09-15T12:16:58.807Z | 2024-09-19T12:21:43.187Z |
5080311 | 5080311 | 20240911034816_LgAAs | UK0074 | 2024-09-15T12:16:57.139Z | 2024-09-19T12:21:43.170Z |
5079703 | 5079703 | 20240911030815_2bPQc | UK0074 | 2024-09-15T12:16:33.379Z | 2024-09-19T12:21:42.561Z |
5079525 | 5079525 | 20240911030043_JCHOJ | UK0074 | 2024-09-15T12:16:24.372Z | 2024-09-19T12:21:42.320Z |
5079416 | 5079416 | 20240911025418_Wluhb | UK0074 | 2024-09-15T12:16:20.157Z | 2024-09-19T12:21:42.195Z |
5079400 | 5079400 | 20240911025318_Kau3W | UK0074 | 2024-09-15T12:16:19.624Z | 2024-09-19T12:21:41.680Z |
5079173 | 5079173 | 20240911023817_uHZz0 | UK0074 | 2024-09-15T12:16:09.452Z | 2024-09-19T12:21:41.236Z |
5078847 | 5078847 | 20240911021655_vM3oG | UK0074 | 2024-09-15T12:15:53.139Z | 2024-09-19T12:21:40.738Z |
5078189 | 5078189 | 20240911014228_5VWqD | UK0074 | 2024-09-15T12:15:22.801Z | 2024-09-19T12:21:40.053Z |
5077736 | 5077736 | 20240911011309_SW1Z5 | UK0074 | 2024-09-15T12:15:02.360Z | 2024-09-19T12:21:39.585Z |
5077545 | 5077545 | 20240911010335_fgfZw | UK0074 | 2024-09-15T12:14:52.340Z | 2024-09-19T12:21:39.374Z |
5077444 | 5077444 | 20240911005326_jfFqt | UK0074 | 2024-09-15T12:14:45.437Z | 2024-09-19T12:21:38.999Z |
5077047 | 5077047 | 20240911002232_UOycP | UK0074 | 2024-09-15T12:14:19.012Z | 2024-09-19T12:21:37.984Z |
5077001 | 5077001 | 20240911002012_uloq7 | UK0074 | 2024-09-15T12:14:17.230Z | 2024-09-19T12:21:37.940Z |
5076763 | 5076763 | 20240911000728_4J33f | UK0074 | 2024-09-15T12:14:00.732Z | 2024-09-19T12:21:37.552Z |
5076728 | 5076728 | 20240911000621_y6zfu | UK0074 | 2024-09-15T12:13:58.921Z | 2024-09-19T12:21:37.521Z |
5076680 | 5076680 | 20240910235843_mD2s9 | UK0074 | 2024-09-15T12:13:54.668Z | 2024-09-19T12:21:37.456Z |
5076477 | 5076477 | 20240910233917_00geA | UK0074 | 2024-09-15T12:13:37.716Z | 2024-09-19T12:21:37.289Z |
5076315 | 5076315 | 20240910232023_QZp5G | UK0074 | 2024-09-15T12:13:27.465Z | 2024-09-19T12:21:36.706Z |
5076111 | 5076111 | 20240910230738_weRAL | UK0074 | 2024-09-15T12:13:18.231Z | 2024-09-19T12:21:36.452Z |
5075408 | 5075408 | 20240911234709_nUHQd | UK0074 | 2024-09-15T12:09:42.858Z | 2024-09-19T12:21:09.207Z |
5074757 | 5074757 | 20240911230126_NoehX | UK0074 | 2024-09-15T12:08:50.002Z | 2024-09-19T12:21:07.705Z |
5070098 | 5070098 | 20240910223342_6lxPN | UK0074 | 2024-09-14T12:20:14.292Z | 2024-09-19T12:21:35.757Z |
5069389 | 5069389 | 20240910213719_AiJCX | UK0074 | 2024-09-14T12:19:55.409Z | 2024-09-19T12:21:34.810Z |
5060634 | 5060634 | 20240910204619_V3kaX | UK0074 | 2024-09-14T12:09:15.136Z | 2024-09-19T12:21:33.157Z |
5060566 | 5060566 | 20240910203836_K04qQ | UK0074 | 2024-09-14T12:09:09.480Z | 2024-09-19T12:21:32.838Z |
5060516 | 5060516 | 20240910203426_AeJcB | UK0074 | 2024-09-14T12:08:55.252Z | 2024-09-19T12:21:32.468Z |
5060282 | 5060282 | 20240910201426_kTgxH | UK0074 | 2024-09-14T12:08:35.135Z | 2024-09-19T12:21:32.063Z |
5010873 | 5010873 | 20240904035441_ZJpu5 | UK0074 | 2024-09-09T12:09:06.668Z | 2024-09-12T12:19:29.556Z |
5010695 | 5010695 | 20240904033412_zWZov | UK0074 | 2024-09-09T12:08:57.859Z | 2024-09-12T12:19:28.706Z |
5010240 | 5010240 | 20240904024704_2v44w | UK0074 | 2024-09-09T12:08:30.864Z | 2024-09-12T12:19:26.574Z |
5010166 | 5010166 | 20240904023959_6fjYm | UK0074 | 2024-09-09T12:08:25.726Z | 2024-09-12T12:19:26.110Z |
5009772 | 5009772 | 20240904020019_Rkr34 | UK0074 | 2024-09-09T12:08:00.825Z | 2024-09-12T12:19:24.331Z |
5009703 | 5009703 | 20240904015137_822tp | UK0074 | 2024-09-09T12:07:56.108Z | 2024-09-12T12:19:24.066Z |
5009624 | 5009624 | 20240904014158_8zjp6 | UK0074 | 2024-09-09T12:07:52.573Z | 2024-09-12T12:19:23.716Z |
5009448 | 5009448 | 20240904012545_8a4YY | UK0074 | 2024-09-09T12:07:45.359Z | 2024-09-12T12:19:22.843Z |
5009363 | 5009363 | 20240904011532_GT3Cc | UK0074 | 2024-09-09T12:07:36.688Z | 2024-09-12T12:19:22.476Z |
5008899 | 5008899 | 20240904003405_nHCk6 | UK0074 | 2024-09-09T12:07:10.848Z | 2024-09-12T12:19:20.582Z |
5007777 | 5007777 | 20240903221906_gdPOz | UK0074 | 2024-09-09T12:06:07.263Z | 2024-09-12T12:19:14.829Z |
4998796 | 4998796 | 20240903040002_WHYCl | UK0074 | 2024-09-08T12:08:05.480Z | 2024-09-11T12:21:14.911Z |
4998736 | 4998736 | 20240903034118_noLSO | UK0074 | 2024-09-08T12:08:02.233Z | 2024-09-11T12:21:14.580Z |
4998725 | 4998725 | 20240903034042_2tUgu | UK0074 | 2024-09-08T12:08:01.678Z | 2024-09-11T12:21:14.507Z |
4997803 | 4997803 | 20240903012929_28D3V | UK0074 | 2024-09-08T12:06:49.644Z | 2024-09-11T12:21:09.057Z |
4997731 | 4997731 | 20240903011649_xzdM6 | UK0074 | 2024-09-08T12:06:44.595Z | 2024-09-11T12:21:08.028Z |
4997621 | 4997621 | 20240903005345_8Vobl | UK0074 | 2024-09-08T12:06:30.662Z | 2024-09-11T12:21:06.586Z |
4997496 | 4997496 | 20240903002922_UX04h | UK0074 | 2024-09-08T12:06:22.316Z | 2024-09-11T12:21:05.049Z |
4990739 | 4990739 | 20240901010319_7ymN3 | UK0074 | 2024-09-07T12:11:00.265Z | 2024-09-09T12:26:34.799Z |
4990058 | 4990058 | 20240831231840_SpRZA | UK0074 | 2024-09-07T12:09:57.717Z | 2024-09-09T12:26:09.684Z |
4982065 | 4982065 | 20240812002945_lc6jq | UK0074 | 2024-09-06T12:14:42.104Z | 2024-09-06T12:14:42.104Z |
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);