participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,047 rows where station_code = "UK00BK" 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 |
---|---|---|---|---|---|
5129758 | 5129758 | 20240917042512_YPcGy | UK00BK | 2024-09-19T12:12:02.895Z | 2024-09-19T12:12:02.895Z |
5129683 | 5129683 | 20240917042148_53vsL | UK00BK | 2024-09-19T12:12:00.538Z | 2024-09-19T12:12:00.538Z |
5129663 | 5129663 | 20240917042119_UWnWe | UK00BK | 2024-09-19T12:12:00.122Z | 2024-09-19T12:12:00.122Z |
5129551 | 5129551 | 20240917040919_MPPVs | UK00BK | 2024-09-19T12:11:48.640Z | 2024-09-19T12:11:48.640Z |
5129491 | 5129491 | 20240917040451_YYTpq | UK00BK | 2024-09-19T12:11:44.686Z | 2024-09-19T12:11:44.686Z |
5129136 | 5129136 | 20240917032432_DHV2X | UK00BK | 2024-09-19T12:11:16.363Z | 2024-09-19T12:11:16.363Z |
5129015 | 5129015 | 20240917030739_7PbCu | UK00BK | 2024-09-19T12:11:11.356Z | 2024-09-19T12:11:11.356Z |
5128931 | 5128931 | 20240917025710_dO20e | UK00BK | 2024-09-19T12:11:07.994Z | 2024-09-19T12:11:07.994Z |
5128596 | 5128596 | 20240917020759_7vm3g | UK00BK | 2024-09-19T12:10:46.472Z | 2024-09-19T12:10:46.472Z |
5128550 | 5128550 | 20240917020203_RMJQx | UK00BK | 2024-09-19T12:10:42.939Z | 2024-09-19T12:10:42.939Z |
5128258 | 5128258 | 20240917010944_y4nji | UK00BK | 2024-09-19T12:10:21.933Z | 2024-09-19T12:10:21.933Z |
5128098 | 5128098 | 20240917003554_INf3N | UK00BK | 2024-09-19T12:10:03.475Z | 2024-09-19T12:10:03.475Z |
5127994 | 5127994 | 20240917001818_Y0BQQ | UK00BK | 2024-09-19T12:09:53.011Z | 2024-09-19T12:09:53.011Z |
5127920 | 5127920 | 20240917000505_sC3Ql | UK00BK | 2024-09-19T12:09:46.715Z | 2024-09-19T12:09:46.715Z |
5127789 | 5127789 | 20240916232851_6zpE1 | UK00BK | 2024-09-19T12:09:38.237Z | 2024-09-19T12:09:38.237Z |
5127572 | 5127572 | 20240916223002_KjcOd | UK00BK | 2024-09-19T12:09:23.927Z | 2024-09-19T12:09:23.927Z |
5127540 | 5127540 | 20240916221936_snTPZ | UK00BK | 2024-09-19T12:09:19.041Z | 2024-09-19T12:09:19.041Z |
5127509 | 5127509 | 20240916221249_AmGNp | UK00BK | 2024-09-19T12:09:15.777Z | 2024-09-19T12:09:15.777Z |
5127039 | 5127039 | 20240916201356_2oguW | UK00BK | 2024-09-19T12:07:55.163Z | 2024-09-19T12:07:55.163Z |
5126902 | 5126902 | 20240916194827_mMq2i | UK00BK | 2024-09-19T12:07:36.456Z | 2024-09-19T12:07:36.456Z |
5125000 | 5125000 | 20240917232107_yIlo3 | UK00BK | 2024-09-19T12:01:55.280Z | 2024-09-19T12:06:41.960Z |
5124985 | 5124985 | 20240917231620_u9bFZ | UK00BK | 2024-09-19T12:01:54.553Z | 2024-09-19T12:06:41.959Z |
5124791 | 5124791 | 20240917220112_DZ7h4 | UK00BK | 2024-09-19T12:01:35.012Z | 2024-09-19T12:06:41.935Z |
5124659 | 5124659 | 20240917214518_pkmee | UK00BK | 2024-09-19T12:01:17.005Z | 2024-09-19T12:06:41.922Z |
5124640 | 5124640 | 20240917213954_J1UwB | UK00BK | 2024-09-19T12:01:14.862Z | 2024-09-19T12:06:41.919Z |
5124592 | 5124592 | 20240917212758_P1akd | UK00BK | 2024-09-19T12:01:11.720Z | 2024-09-19T12:06:41.915Z |
5122038 | 5122038 | 20240914042820_mJEfX | UK00BK | 2024-09-18T12:11:05.023Z | 2024-09-19T12:20:02.705Z |
5121935 | 5121935 | 20240914042122_nzVpm | UK00BK | 2024-09-18T12:11:03.135Z | 2024-09-19T12:20:02.522Z |
5121864 | 5121864 | 20240914041723_hHZoX | UK00BK | 2024-09-18T12:11:02.358Z | 2024-09-19T12:20:02.447Z |
5121741 | 5121741 | 20240914041320_c1Do2 | UK00BK | 2024-09-18T12:11:01.155Z | 2024-09-19T12:20:02.320Z |
5121710 | 5121710 | 20240914041223_Y2S4F | UK00BK | 2024-09-18T12:10:59.821Z | 2024-09-19T12:20:02.264Z |
5121672 | 5121672 | 20240914041155_QyLxn | UK00BK | 2024-09-18T12:10:59.188Z | 2024-09-19T12:20:02.207Z |
5121548 | 5121548 | 20240914040819_3SGHu | UK00BK | 2024-09-18T12:10:58.119Z | 2024-09-19T12:20:02.086Z |
5121245 | 5121245 | 20240914035618_03B7Q | UK00BK | 2024-09-18T12:10:52.843Z | 2024-09-19T12:20:01.520Z |
5120828 | 5120828 | 20240914033552_fwlf5 | UK00BK | 2024-09-18T12:10:47.149Z | 2024-09-19T12:20:00.904Z |
5120343 | 5120343 | 20240914031622_NOzQq | UK00BK | 2024-09-18T12:10:37.819Z | 2024-09-19T12:19:59.955Z |
5120298 | 5120298 | 20240914031222_xXJ8R | UK00BK | 2024-09-18T12:10:36.715Z | 2024-09-19T12:19:59.849Z |
5120270 | 5120270 | 20240914031053_j5fCe | UK00BK | 2024-09-18T12:10:36.491Z | 2024-09-19T12:19:59.846Z |
5119638 | 5119638 | 20240914024041_hBkgB | UK00BK | 2024-09-18T12:10:22.791Z | 2024-09-19T12:19:58.602Z |
5119506 | 5119506 | 20240914023634_WcZAw | UK00BK | 2024-09-18T12:10:21.786Z | 2024-09-19T12:19:58.392Z |
5119449 | 5119449 | 20240914023429_3r0OL | UK00BK | 2024-09-18T12:10:21.380Z | 2024-09-19T12:19:58.255Z |
5119320 | 5119320 | 20240914022258_gF0ug | UK00BK | 2024-09-18T12:10:19.875Z | 2024-09-19T12:19:57.916Z |
5119295 | 5119295 | 20240914022153_PDykK | UK00BK | 2024-09-18T12:10:19.550Z | 2024-09-19T12:19:57.632Z |
5117126 | 5117126 | 20240915040350_u04rH | UK00BK | 2024-09-18T12:07:33.119Z | 2024-09-19T12:19:13.449Z |
5116964 | 5116964 | 20240915035119_yDVH0 | UK00BK | 2024-09-18T12:07:26.631Z | 2024-09-19T12:19:12.813Z |
5116835 | 5116835 | 20240915034404_of2Bq | UK00BK | 2024-09-18T12:07:22.391Z | 2024-09-19T12:19:12.447Z |
5116721 | 5116721 | 20240915033724_p3md7 | UK00BK | 2024-09-18T12:07:17.601Z | 2024-09-19T12:19:12.115Z |
5116603 | 5116603 | 20240915033247_BBCVw | UK00BK | 2024-09-18T12:07:11.064Z | 2024-09-19T12:19:11.605Z |
5116457 | 5116457 | 20240915032640_CI2LX | UK00BK | 2024-09-18T12:07:03.972Z | 2024-09-19T12:19:11.202Z |
5116410 | 5116410 | 20240915032506_4lBjC | UK00BK | 2024-09-18T12:07:01.120Z | 2024-09-19T12:19:11.089Z |
5115090 | 5115090 | 20240915021853_UbQkD | UK00BK | 2024-09-18T12:05:57.467Z | 2024-09-19T12:19:01.536Z |
5115004 | 5115004 | 20240915021309_nvDxB | UK00BK | 2024-09-18T12:05:50.408Z | 2024-09-19T12:19:01.113Z |
5114775 | 5114775 | 20240915015743_9K7A3 | UK00BK | 2024-09-18T12:05:33.745Z | 2024-09-19T12:18:59.867Z |
5114470 | 5114470 | 20240915014359_AoEVk | UK00BK | 2024-09-18T12:05:19.175Z | 2024-09-19T12:18:58.450Z |
5114175 | 5114175 | 20240915013005_Ep2rP | UK00BK | 2024-09-18T12:05:05.080Z | 2024-09-19T12:18:56.578Z |
5113980 | 5113980 | 20240915012116_1VSgb | UK00BK | 2024-09-18T12:04:56.777Z | 2024-09-19T12:18:54.884Z |
5113503 | 5113503 | 20240915005320_mrhzA | UK00BK | 2024-09-18T12:04:24.896Z | 2024-09-19T12:18:49.754Z |
5113481 | 5113481 | 20240915005215_qlXTD | UK00BK | 2024-09-18T12:04:22.737Z | 2024-09-19T12:18:49.588Z |
5113144 | 5113144 | 20240915002437_TaEq6 | UK00BK | 2024-09-18T12:03:58.261Z | 2024-09-19T12:18:47.421Z |
5112930 | 5112930 | 20240915000653_3UA7I | UK00BK | 2024-09-18T12:03:47.607Z | 2024-09-19T12:18:45.881Z |
5112859 | 5112859 | 20240915000107_kBerQ | UK00BK | 2024-09-18T12:03:43.328Z | 2024-09-19T12:18:45.391Z |
5112579 | 5112579 | 20240914233020_Bsvf4 | UK00BK | 2024-09-18T12:03:15.244Z | 2024-09-19T12:18:41.498Z |
5112360 | 5112360 | 20240914230410_KjigL | UK00BK | 2024-09-18T12:03:00.974Z | 2024-09-19T12:18:40.686Z |
5112163 | 5112163 | 20240914222722_efnwZ | UK00BK | 2024-09-18T12:02:50.578Z | 2024-09-19T12:18:38.786Z |
5112122 | 5112122 | 20240914221653_IlpIA | UK00BK | 2024-09-18T12:02:48.816Z | 2024-09-19T12:18:38.503Z |
5112041 | 5112041 | 20240914220150_fcwLb | UK00BK | 2024-09-18T12:02:43.205Z | 2024-09-19T12:18:37.122Z |
5111883 | 5111883 | 20240914213012_Wk3ui | UK00BK | 2024-09-18T12:02:28.267Z | 2024-09-19T12:18:34.845Z |
5111824 | 5111824 | 20240914211815_Ejih7 | UK00BK | 2024-09-18T12:02:18.321Z | 2024-09-19T12:18:34.067Z |
5111793 | 5111793 | 20240914211708_tO7K3 | UK00BK | 2024-09-18T12:02:17.667Z | 2024-09-19T12:18:34.050Z |
5111775 | 5111775 | 20240914211540_3Jfn3 | UK00BK | 2024-09-18T12:02:16.119Z | 2024-09-19T12:18:33.917Z |
5111602 | 5111602 | 20240914205236_oBoDU | UK00BK | 2024-09-18T12:02:05.845Z | 2024-09-19T12:18:31.670Z |
5111550 | 5111550 | 20240914204553_cbHNA | UK00BK | 2024-09-18T12:02:02.259Z | 2024-09-19T12:18:31.271Z |
5111514 | 5111514 | 20240914204302_3jFoI | UK00BK | 2024-09-18T12:01:59.983Z | 2024-09-19T12:18:30.852Z |
5111465 | 5111465 | 20240914203952_gx6rh | UK00BK | 2024-09-18T12:01:57.836Z | 2024-09-19T12:18:30.436Z |
5111362 | 5111362 | 20240914202836_2MqV3 | UK00BK | 2024-09-18T12:01:52.447Z | 2024-09-19T12:18:29.519Z |
5108214 | 5108214 | 20240913043131_d3Xeq | UK00BK | 2024-09-17T12:13:32.534Z | 2024-09-19T12:20:47.917Z |
5107950 | 5107950 | 20240913041517_xTvtL | UK00BK | 2024-09-17T12:13:26.077Z | 2024-09-19T12:20:47.639Z |
5107794 | 5107794 | 20240913040948_zsbt0 | UK00BK | 2024-09-17T12:13:23.784Z | 2024-09-19T12:20:47.559Z |
5107734 | 5107734 | 20240913040923_Amflw | UK00BK | 2024-09-17T12:13:22.523Z | 2024-09-19T12:20:47.508Z |
5107613 | 5107613 | 20240913040428_u8c5x | UK00BK | 2024-09-17T12:13:18.887Z | 2024-09-19T12:20:47.330Z |
5107370 | 5107370 | 20240913035328_kCWOY | UK00BK | 2024-09-17T12:13:13.715Z | 2024-09-19T12:20:47.024Z |
5107145 | 5107145 | 20240913034535_Nfjnq | UK00BK | 2024-09-17T12:13:09.977Z | 2024-09-19T12:20:46.862Z |
5107094 | 5107094 | 20240913034428_WQOmY | UK00BK | 2024-09-17T12:13:09.060Z | 2024-09-19T12:20:46.809Z |
5107034 | 5107034 | 20240913034216_uUJpJ | UK00BK | 2024-09-17T12:13:08.238Z | 2024-09-19T12:20:46.785Z |
5106530 | 5106530 | 20240913032845_3pQuD | UK00BK | 2024-09-17T12:12:57.085Z | 2024-09-19T12:20:46.172Z |
5106366 | 5106366 | 20240913032113_vvVsw | UK00BK | 2024-09-17T12:12:51.052Z | 2024-09-19T12:20:46.000Z |
5105586 | 5105586 | 20240913025257_tw1aR | UK00BK | 2024-09-17T12:12:22.725Z | 2024-09-19T12:20:44.710Z |
5105522 | 5105522 | 20240913025033_oRid5 | UK00BK | 2024-09-17T12:12:20.305Z | 2024-09-19T12:20:44.645Z |
5105465 | 5105465 | 20240913024659_qtqmu | UK00BK | 2024-09-17T12:12:17.909Z | 2024-09-19T12:20:44.555Z |
5105450 | 5105450 | 20240913024656_Bg793 | UK00BK | 2024-09-17T12:12:17.751Z | 2024-09-19T12:20:44.553Z |
5105443 | 5105443 | 20240913024615_M9Fb2 | UK00BK | 2024-09-17T12:12:16.946Z | 2024-09-19T12:20:44.548Z |
5105336 | 5105336 | 20240913024200_xuBve | UK00BK | 2024-09-17T12:12:10.041Z | 2024-09-19T12:20:44.295Z |
5104981 | 5104981 | 20240913022502_GyngA | UK00BK | 2024-09-17T12:11:47.864Z | 2024-09-19T12:20:43.201Z |
5104369 | 5104369 | 20240913020602_8rNYg | UK00BK | 2024-09-17T12:11:33.885Z | 2024-09-19T12:20:41.425Z |
5104346 | 5104346 | 20240913020545_oMvux | UK00BK | 2024-09-17T12:11:33.793Z | 2024-09-19T12:20:41.419Z |
5104252 | 5104252 | 20240913020126_VBIjV | UK00BK | 2024-09-17T12:11:30.929Z | 2024-09-19T12:20:41.294Z |
5104009 | 5104009 | 20240913014710_Rac2v | UK00BK | 2024-09-17T12:11:21.845Z | 2024-09-19T12:20:40.824Z |
5103896 | 5103896 | 20240913014314_Wl639 | UK00BK | 2024-09-17T12:11:15.929Z | 2024-09-19T12:20:40.660Z |
5103479 | 5103479 | 20240913013113_8DvbC | UK00BK | 2024-09-17T12:10:59.110Z | 2024-09-19T12:20:40.202Z |
5103363 | 5103363 | 20240913012913_Dd5no | UK00BK | 2024-09-17T12:10:55.186Z | 2024-09-19T12:20:40.114Z |
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);