participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,088 rows where station_code = "UK00BN" 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 |
---|---|---|---|---|---|
5497864 | 5497864 | 20241107053846_jPF0O | UK00BN | 2024-11-08T14:14:28.157Z | 2024-11-09T14:18:52.845Z |
5497850 | 5497850 | 20241107053454_cHXOH | UK00BN | 2024-11-08T14:14:27.570Z | 2024-11-09T14:18:52.752Z |
5497836 | 5497836 | 20241107052923_yC719 | UK00BN | 2024-11-08T14:14:25.712Z | 2024-11-09T14:18:52.588Z |
5497824 | 5497824 | 20241107052331_hGOyG | UK00BN | 2024-11-08T14:14:25.261Z | 2024-11-09T14:18:52.464Z |
5497799 | 5497799 | 20241107051855_gTdAQ | UK00BN | 2024-11-08T14:14:22.935Z | 2024-11-09T14:18:52.278Z |
5497746 | 5497746 | 20241107045536_SZLzh | UK00BN | 2024-11-08T14:14:17.860Z | 2024-11-09T14:18:51.341Z |
5497681 | 5497681 | 20241107042808_WZk8x | UK00BN | 2024-11-08T14:14:10.486Z | 2024-11-09T14:18:50.484Z |
5443367 | 5443367 | 20241030053540_X9BLq | UK00BN | 2024-11-01T12:20:28.777Z | 2024-11-07T14:26:51.037Z |
5443342 | 5443342 | 20241030052532_Hdc31 | UK00BN | 2024-11-01T12:20:28.303Z | 2024-11-07T14:26:50.899Z |
5443333 | 5443333 | 20241030052127_K8VHQ | UK00BN | 2024-11-01T12:20:28.081Z | 2024-11-07T14:26:50.856Z |
5443326 | 5443326 | 20241030051807_s3dsY | UK00BN | 2024-11-01T12:20:27.982Z | 2024-11-07T14:26:50.851Z |
5433001 | 5433001 | 20241029054134_ZLKbr | UK00BN | 2024-10-31T12:21:42.615Z | 2024-11-06T14:27:29.546Z |
5410817 | 5410817 | 20241027053826_w1Glx | UK00BN | 2024-10-29T12:18:05.508Z | 2024-11-04T14:29:05.566Z |
5410675 | 5410675 | 20241027052632_7Q1Fv | UK00BN | 2024-10-29T12:18:02.258Z | 2024-11-04T14:29:05.207Z |
5410573 | 5410573 | 20241027051845_S5IQ8 | UK00BN | 2024-10-29T12:17:58.393Z | 2024-11-04T14:29:04.984Z |
5410323 | 5410323 | 20241027050625_vPQi5 | UK00BN | 2024-10-29T12:17:53.094Z | 2024-11-04T14:29:04.333Z |
5410250 | 5410250 | 20241027050243_o80p7 | UK00BN | 2024-10-29T12:17:51.357Z | 2024-11-04T14:29:04.241Z |
5410238 | 5410238 | 20241027050204_re8Ki | UK00BN | 2024-10-29T12:17:51.241Z | 2024-11-04T14:29:04.236Z |
5410235 | 5410235 | 20241027050113_74bfP | UK00BN | 2024-10-29T12:17:51.161Z | 2024-11-04T14:29:04.226Z |
5410146 | 5410146 | 20241027045531_797HB | UK00BN | 2024-10-29T12:17:48.934Z | 2024-11-04T14:29:03.887Z |
5410130 | 5410130 | 20241027045507_S3k7g | UK00BN | 2024-10-29T12:17:48.435Z | 2024-11-04T14:29:03.799Z |
5409994 | 5409994 | 20241027044717_36PkH | UK00BN | 2024-10-29T12:17:45.573Z | 2024-11-04T14:29:03.239Z |
5409967 | 5409967 | 20241027044605_QRYEH | UK00BN | 2024-10-29T12:17:45.093Z | 2024-11-04T14:29:03.119Z |
5409963 | 5409963 | 20241027044421_dpcfG | UK00BN | 2024-10-29T12:17:44.940Z | 2024-11-04T14:29:03.110Z |
5409950 | 5409950 | 20241027044413_INwZK | UK00BN | 2024-10-29T12:17:44.866Z | 2024-11-04T14:29:03.025Z |
5409694 | 5409694 | 20241027043052_za9cF | UK00BN | 2024-10-29T12:17:37.998Z | 2024-11-04T14:29:02.155Z |
5409556 | 5409556 | 20241027042425_9kHyr | UK00BN | 2024-10-29T12:17:29.974Z | 2024-11-04T14:29:01.952Z |
5409468 | 5409468 | 20241027041935_hpkCl | UK00BN | 2024-10-29T12:17:25.190Z | 2024-11-04T14:29:01.832Z |
5409416 | 5409416 | 20241027041659_Vot6b | UK00BN | 2024-10-29T12:17:22.478Z | 2024-11-04T14:29:01.652Z |
5409331 | 5409331 | 20241027041116_OMjLM | UK00BN | 2024-10-29T12:17:16.750Z | 2024-11-04T14:29:01.585Z |
5409322 | 5409322 | 20241027041058_2SDUI | UK00BN | 2024-10-29T12:17:16.405Z | 2024-11-04T14:29:01.522Z |
5409308 | 5409308 | 20241027041028_E71nu | UK00BN | 2024-10-29T12:17:15.853Z | 2024-11-04T14:29:01.514Z |
5409110 | 5409110 | 20241027040049_3YJYj | UK00BN | 2024-10-29T12:17:06.779Z | 2024-11-04T14:29:01.169Z |
5408820 | 5408820 | 20241027034415_Ilfc7 | UK00BN | 2024-10-29T12:16:53.446Z | 2024-11-04T14:29:00.560Z |
5408576 | 5408576 | 20241027033044_BE6qm | UK00BN | 2024-10-29T12:16:37.324Z | 2024-11-04T14:28:59.631Z |
5408568 | 5408568 | 20241027033031_gWzFc | UK00BN | 2024-10-29T12:16:36.135Z | 2024-11-04T14:28:59.620Z |
5408493 | 5408493 | 20241027032811_eSJI6 | UK00BN | 2024-10-29T12:16:33.053Z | 2024-11-04T14:28:59.560Z |
5408273 | 5408273 | 20241027032036_soOuV | UK00BN | 2024-10-29T12:16:20.853Z | 2024-11-04T14:28:59.045Z |
5408271 | 5408271 | 20241027032014_T5b7e | UK00BN | 2024-10-29T12:16:20.574Z | 2024-11-04T14:28:59.043Z |
5408080 | 5408080 | 20241027030545_Dv2fB | UK00BN | 2024-10-29T12:16:04.166Z | 2024-11-04T14:28:58.832Z |
5407763 | 5407763 | 20241027025121_54k71 | UK00BN | 2024-10-29T12:15:39.272Z | 2024-11-04T14:28:58.109Z |
5407761 | 5407761 | 20241027025052_UFwmU | UK00BN | 2024-10-29T12:15:38.712Z | 2024-11-04T14:28:58.104Z |
5407759 | 5407759 | 20241027025048_CgtGC | UK00BN | 2024-10-29T12:15:38.466Z | 2024-11-04T14:28:58.103Z |
5407753 | 5407753 | 20241027025031_XY1B6 | UK00BN | 2024-10-29T12:15:37.926Z | 2024-11-04T14:28:58.100Z |
5407461 | 5407461 | 20241027023745_T2zx2 | UK00BN | 2024-10-29T12:15:25.652Z | 2024-11-04T14:28:57.622Z |
5407438 | 5407438 | 20241027023655_7JtgN | UK00BN | 2024-10-29T12:15:24.684Z | 2024-11-04T14:28:57.569Z |
5407421 | 5407421 | 20241027023627_0TmIv | UK00BN | 2024-10-29T12:15:24.406Z | 2024-11-04T14:28:57.501Z |
5407196 | 5407196 | 20241027022518_F4HLU | UK00BN | 2024-10-29T12:15:16.404Z | 2024-11-04T14:28:57.233Z |
5407128 | 5407128 | 20241027022314_LhLdT | UK00BN | 2024-10-29T12:15:13.642Z | 2024-11-04T14:28:56.964Z |
5406725 | 5406725 | 20241027015629_eguTw | UK00BN | 2024-10-29T12:14:34.696Z | 2024-11-04T14:28:56.306Z |
5406715 | 5406715 | 20241027015627_EOuer | UK00BN | 2024-10-29T12:14:34.383Z | 2024-11-04T14:28:56.302Z |
5406691 | 5406691 | 20241027015414_7ctZo | UK00BN | 2024-10-29T12:14:32.615Z | 2024-11-04T14:28:56.037Z |
5406562 | 5406562 | 20241027014445_Xiihl | UK00BN | 2024-10-29T12:14:21.270Z | 2024-11-04T14:28:55.873Z |
5406546 | 5406546 | 20241027014331_Zgd0J | UK00BN | 2024-10-29T12:14:18.759Z | 2024-11-04T14:28:55.847Z |
5406510 | 5406510 | 20241027014157_3hseu | UK00BN | 2024-10-29T12:14:15.584Z | 2024-11-04T14:28:55.789Z |
5406345 | 5406345 | 20241027012953_iubf2 | UK00BN | 2024-10-29T12:14:03.179Z | 2024-11-04T14:28:55.483Z |
5406324 | 5406324 | 20241027012728_I35oo | UK00BN | 2024-10-29T12:14:01.974Z | 2024-11-04T14:28:55.430Z |
5406138 | 5406138 | 20241027011855_Mdjx3 | UK00BN | 2024-10-29T12:13:53.233Z | 2024-11-04T14:28:55.158Z |
5406084 | 5406084 | 20241027011435_8w85A | UK00BN | 2024-10-29T12:13:50.564Z | 2024-11-04T14:28:54.977Z |
5405893 | 5405893 | 20241027010600_ZRU9Z | UK00BN | 2024-10-29T12:13:28.189Z | 2024-11-04T14:28:54.567Z |
5405579 | 5405579 | 20241027004600_Qle1n | UK00BN | 2024-10-29T12:13:03.212Z | 2024-11-04T14:28:53.630Z |
5405260 | 5405260 | 20241027002601_VvKUE | UK00BN | 2024-10-29T12:12:46.657Z | 2024-11-04T14:28:53.182Z |
5404895 | 5404895 | 20241026235927_cT0yD | UK00BN | 2024-10-29T12:12:05.583Z | 2024-11-04T14:28:52.375Z |
5404870 | 5404870 | 20241026235744_nLEn3 | UK00BN | 2024-10-29T12:12:04.037Z | 2024-11-04T14:28:52.219Z |
5404857 | 5404857 | 20241026235707_At5p3 | UK00BN | 2024-10-29T12:12:03.373Z | 2024-11-04T14:28:52.212Z |
5404807 | 5404807 | 20241026235248_O05HD | UK00BN | 2024-10-29T12:11:58.644Z | 2024-11-04T14:28:51.976Z |
5404707 | 5404707 | 20241026234643_YMvKD | UK00BN | 2024-10-29T12:11:53.687Z | 2024-11-04T14:28:51.661Z |
5404691 | 5404691 | 20241026234532_2FfP2 | UK00BN | 2024-10-29T12:11:52.017Z | 2024-11-04T14:28:51.528Z |
5404625 | 5404625 | 20241026234100_TL2Hf | UK00BN | 2024-10-29T12:11:46.814Z | 2024-11-04T14:28:51.443Z |
5404568 | 5404568 | 20241026233828_rtpDu | UK00BN | 2024-10-29T12:11:43.465Z | 2024-11-04T14:28:51.337Z |
5404538 | 5404538 | 20241026233450_4GU65 | UK00BN | 2024-10-29T12:11:41.320Z | 2024-11-04T14:28:51.305Z |
5404420 | 5404420 | 20241026232447_21Uaj | UK00BN | 2024-10-29T12:11:22.214Z | 2024-11-04T14:28:50.916Z |
5404414 | 5404414 | 20241026232430_ZGAWD | UK00BN | 2024-10-29T12:11:21.086Z | 2024-11-04T14:28:50.862Z |
5404368 | 5404368 | 20241026231946_N9IPk | UK00BN | 2024-10-29T12:11:13.741Z | 2024-11-04T14:28:50.813Z |
5404233 | 5404233 | 20241026231034_TkSKh | UK00BN | 2024-10-29T12:11:02.664Z | 2024-11-04T14:28:50.545Z |
5404174 | 5404174 | 20241026230355_6HyWI | UK00BN | 2024-10-29T12:10:57.725Z | 2024-11-04T14:28:50.395Z |
5404059 | 5404059 | 20241026225505_5tqjd | UK00BN | 2024-10-29T12:10:51.165Z | 2024-11-04T14:28:50.278Z |
5403993 | 5403993 | 20241026225145_8WsB7 | UK00BN | 2024-10-29T12:10:45.445Z | 2024-11-04T14:28:50.164Z |
5403980 | 5403980 | 20241026225030_2Sp1V | UK00BN | 2024-10-29T12:10:41.690Z | 2024-11-04T14:28:50.148Z |
5403935 | 5403935 | 20241026224650_UHPFo | UK00BN | 2024-10-29T12:10:31.152Z | 2024-11-04T14:28:50.049Z |
5403756 | 5403756 | 20241026222848_6eqA5 | UK00BN | 2024-10-29T12:10:11.925Z | 2024-11-04T14:28:49.563Z |
5403650 | 5403650 | 20241026222058_GvZAY | UK00BN | 2024-10-29T12:10:04.843Z | 2024-11-04T14:28:49.399Z |
5403570 | 5403570 | 20241026221155_nNKTq | UK00BN | 2024-10-29T12:09:57.911Z | 2024-11-04T14:28:49.224Z |
5403362 | 5403362 | 20241026214617_N41iv | UK00BN | 2024-10-29T12:09:24.760Z | 2024-11-04T14:28:48.570Z |
5399950 | 5399950 | 20241026051545_UyWv1 | UK00BN | 2024-10-28T12:20:17.305Z | 2024-11-03T14:27:40.888Z |
5399872 | 5399872 | 20241026050800_xn3ww | UK00BN | 2024-10-28T12:20:14.015Z | 2024-11-03T14:27:40.641Z |
5399639 | 5399639 | 20241026044312_Ixke8 | UK00BN | 2024-10-28T12:20:04.561Z | 2024-11-03T14:27:40.158Z |
5399436 | 5399436 | 20241026041824_5KRJa | UK00BN | 2024-10-28T12:19:59.470Z | 2024-11-03T14:27:39.708Z |
5399184 | 5399184 | 20241026035937_oYHlK | UK00BN | 2024-10-28T12:19:50.784Z | 2024-11-03T14:27:39.194Z |
5399115 | 5399115 | 20241026035415_3DSX9 | UK00BN | 2024-10-28T12:19:48.821Z | 2024-11-03T14:27:39.052Z |
5387864 | 5387864 | 20241025033246_nvuiN | UK00BN | 2024-10-27T12:21:46.689Z | 2024-11-02T12:28:33.347Z |
5387620 | 5387620 | 20241025030239_97d2z | UK00BN | 2024-10-27T12:21:31.080Z | 2024-11-02T12:28:32.832Z |
5387609 | 5387609 | 20241025030050_gxNBR | UK00BN | 2024-10-27T12:21:30.516Z | 2024-11-02T12:28:32.817Z |
5387580 | 5387580 | 20241025025743_xwOSg | UK00BN | 2024-10-27T12:21:29.394Z | 2024-11-02T12:28:32.790Z |
5386133 | 5386133 | 20241025000618_D1DO6 | UK00BN | 2024-10-27T12:19:52.014Z | 2024-11-02T12:28:30.721Z |
5386039 | 5386039 | 20241024235623_4ZYXO | UK00BN | 2024-10-27T12:19:46.822Z | 2024-11-02T12:28:30.598Z |
5385999 | 5385999 | 20241024235247_vLFWc | UK00BN | 2024-10-27T12:19:45.092Z | 2024-11-02T12:28:30.572Z |
5385148 | 5385148 | 20241024215701_0DIf6 | UK00BN | 2024-10-27T12:18:28.780Z | 2024-11-02T12:28:29.210Z |
5384932 | 5384932 | 20241024211748_EJ3uv | UK00BN | 2024-10-27T12:17:59.543Z | 2024-11-02T12:28:28.706Z |
5384649 | 5384649 | 20241024203208_3LPur | UK00BN | 2024-10-27T12:17:21.896Z | 2024-11-02T12:28:27.524Z |
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);