participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
871 rows where station_code = "UK0055" 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 |
---|---|---|---|---|---|
5573255 | 5573255 | 20241121041636_xYWe0 | UK0055 | 2024-11-22T14:19:18.566Z | 2024-11-22T14:19:22.478Z |
5572910 | 5572910 | 20241121032407_ZN3ZM | UK0055 | 2024-11-22T14:18:58.065Z | 2024-11-22T14:19:22.412Z |
5572838 | 5572838 | 20241121031508_gieeP | UK0055 | 2024-11-22T14:18:52.859Z | 2024-11-22T14:19:22.400Z |
5572740 | 5572740 | 20241121030409_hjZiI | UK0055 | 2024-11-22T14:18:47.035Z | 2024-11-22T14:19:22.384Z |
5572576 | 5572576 | 20241121024215_3k4U4 | UK0055 | 2024-11-22T14:18:37.712Z | 2024-11-22T14:19:22.355Z |
5572414 | 5572414 | 20241121022016_3yQoS | UK0055 | 2024-11-22T14:18:25.180Z | 2024-11-22T14:19:22.326Z |
5571879 | 5571879 | 20241121005946_JI1I8 | UK0055 | 2024-11-22T14:17:44.390Z | 2024-11-22T14:19:22.214Z |
5571802 | 5571802 | 20241121004851_TRVwJ | UK0055 | 2024-11-22T14:17:40.410Z | 2024-11-22T14:19:22.198Z |
5571780 | 5571780 | 20241121004529_VeDGk | UK0055 | 2024-11-22T14:17:39.361Z | 2024-11-22T14:19:22.193Z |
5571598 | 5571598 | 20241121001511_3TGaF | UK0055 | 2024-11-22T14:17:21.773Z | 2024-11-22T14:19:22.156Z |
5571445 | 5571445 | 20241120234822_3zDwu | UK0055 | 2024-11-22T14:17:07.326Z | 2024-11-22T14:19:22.127Z |
5571194 | 5571194 | 20241120225042_jlPNH | UK0055 | 2024-11-22T14:16:36.503Z | 2024-11-22T14:19:22.061Z |
5571057 | 5571057 | 20241120220624_alzdz | UK0055 | 2024-11-22T14:16:20.338Z | 2024-11-22T14:19:22.031Z |
5570990 | 5570990 | 20241120215210_XZLe3 | UK0055 | 2024-11-22T14:16:16.794Z | 2024-11-22T14:19:22.019Z |
5570814 | 5570814 | 20241120210550_sJyum | UK0055 | 2024-11-22T14:16:06.934Z | 2024-11-22T14:19:21.986Z |
5570333 | 5570333 | 20241120191947_65Z31 | UK0055 | 2024-11-22T14:15:10.330Z | 2024-11-22T14:19:21.899Z |
5570232 | 5570232 | 20241120190727_ZBeAY | UK0055 | 2024-11-22T14:15:03.283Z | 2024-11-22T14:19:21.885Z |
5570170 | 5570170 | 20241120185542_Qm231 | UK0055 | 2024-11-22T14:14:57.023Z | 2024-11-22T14:19:21.875Z |
5564445 | 5564445 | 20241120025826_5ZRss | UK0055 | 2024-11-21T14:17:37.634Z | 2024-11-22T14:21:31.980Z |
5564311 | 5564311 | 20241120024736_r9Dr5 | UK0055 | 2024-11-21T14:17:26.838Z | 2024-11-22T14:21:30.410Z |
5564293 | 5564293 | 20241120024644_RjdeP | UK0055 | 2024-11-21T14:17:25.607Z | 2024-11-22T14:21:30.073Z |
5564185 | 5564185 | 20241120023646_g4qf3 | UK0055 | 2024-11-21T14:17:16.850Z | 2024-11-22T14:21:28.574Z |
5564094 | 5564094 | 20241120022833_sBY62 | UK0055 | 2024-11-21T14:17:08.830Z | 2024-11-22T14:21:26.906Z |
5563618 | 5563618 | 20241120015311_PueTR | UK0055 | 2024-11-21T14:16:29.767Z | 2024-11-22T14:21:20.148Z |
5563557 | 5563557 | 20241120014152_5t7Ly | UK0055 | 2024-11-21T14:16:18.956Z | 2024-11-22T14:21:18.461Z |
5563443 | 5563443 | 20241120013102_xXW1g | UK0055 | 2024-11-21T14:16:06.967Z | 2024-11-22T14:21:15.782Z |
5563016 | 5563016 | 20241120004349_g2opd | UK0055 | 2024-11-21T14:15:31.977Z | 2024-11-22T14:21:07.837Z |
5562383 | 5562383 | 20241119233256_GOMIY | UK0055 | 2024-11-21T14:14:46.247Z | 2024-11-22T14:20:57.012Z |
5562297 | 5562297 | 20241119232008_qLdcr | UK0055 | 2024-11-21T14:14:41.152Z | 2024-11-22T14:20:55.411Z |
5562288 | 5562288 | 20241119231956_wMUFy | UK0055 | 2024-11-21T14:14:40.461Z | 2024-11-22T14:20:55.317Z |
5562071 | 5562071 | 20241119225602_nNigg | UK0055 | 2024-11-21T14:14:23.280Z | 2024-11-22T14:20:52.441Z |
5562007 | 5562007 | 20241119224229_AqWz2 | UK0055 | 2024-11-21T14:14:19.422Z | 2024-11-22T14:20:51.336Z |
5561703 | 5561703 | 20241119214354_aHx5M | UK0055 | 2024-11-21T14:13:48.984Z | 2024-11-22T14:20:43.643Z |
5561444 | 5561444 | 20241119203729_fWeTJ | UK0055 | 2024-11-21T14:13:17.829Z | 2024-11-22T14:20:36.866Z |
5561117 | 5561117 | 20241119182242_WTbDo | UK0055 | 2024-11-21T14:12:25.671Z | 2024-11-22T14:20:21.439Z |
5557492 | 5557492 | 20241120045144_AVxjP | UK0055 | 2024-11-21T14:01:00.970Z | 2024-11-22T14:19:21.079Z |
5553331 | 5553331 | 20241118020617_ujWsh | UK0055 | 2024-11-19T14:10:19.934Z | 2024-11-22T14:22:52.324Z |
5553187 | 5553187 | 20241118012908_DEomr | UK0055 | 2024-11-19T14:10:08.575Z | 2024-11-22T14:22:50.986Z |
5553131 | 5553131 | 20241118005718_CD007 | UK0055 | 2024-11-19T14:10:05.342Z | 2024-11-22T14:22:50.713Z |
5553096 | 5553096 | 20241118004116_yYjDy | UK0055 | 2024-11-19T14:10:02.979Z | 2024-11-22T14:22:50.452Z |
5552904 | 5552904 | 20241117231907_XIfJH | UK0055 | 2024-11-19T14:09:41.995Z | 2024-11-22T14:22:49.038Z |
5552837 | 5552837 | 20241117222247_0PbMx | UK0055 | 2024-11-19T14:09:24.077Z | 2024-11-22T14:22:47.632Z |
5552593 | 5552593 | 20241117190835_L2CC0 | UK0055 | 2024-11-19T14:08:43.816Z | 2024-11-22T14:22:42.630Z |
5552520 | 5552520 | 20241117181609_OlWlE | UK0055 | 2024-11-19T14:08:27.034Z | 2024-11-22T14:22:41.238Z |
5541829 | 5541829 | 20241114045011_JwsKV | UK0055 | 2024-11-15T14:08:32.700Z | 2024-11-22T14:24:20.518Z |
5541708 | 5541708 | 20241114035955_25YMQ | UK0055 | 2024-11-15T14:08:13.371Z | 2024-11-22T14:24:20.006Z |
5541687 | 5541687 | 20241114035409_8FLPu | UK0055 | 2024-11-15T14:08:10.854Z | 2024-11-22T14:24:19.965Z |
5541583 | 5541583 | 20241114025448_licqw | UK0055 | 2024-11-15T14:07:54.029Z | 2024-11-22T14:24:19.548Z |
5541432 | 5541432 | 20241114014715_KRO4v | UK0055 | 2024-11-15T14:07:37.471Z | 2024-11-22T14:24:18.917Z |
5539348 | 5539348 | 20241114062525_iz3Xb | UK0055 | 2024-11-15T14:00:47.274Z | 2024-11-22T14:23:43.176Z |
5539304 | 5539304 | 20241114061001_Gdi3l | UK0055 | 2024-11-15T14:00:38.273Z | 2024-11-22T14:23:42.938Z |
5539288 | 5539288 | 20241114060800_681Rw | UK0055 | 2024-11-15T14:00:36.414Z | 2024-11-22T14:23:42.878Z |
5539237 | 5539237 | 20241114055438_Ntpl8 | UK0055 | 2024-11-15T14:00:27.106Z | 2024-11-22T14:23:42.614Z |
5539173 | 5539173 | 20241114054615_YkIzn | UK0055 | 2024-11-15T14:00:17.606Z | 2024-11-22T14:23:42.311Z |
5538856 | 5538856 | 20241113050542_Tu9DE | UK0055 | 2024-11-14T14:14:00.866Z | 2024-11-21T14:26:29.221Z |
5528897 | 5528897 | 20241111230343_Nk9x0 | UK0055 | 2024-11-13T14:11:37.484Z | 2024-11-20T14:25:37.134Z |
5527698 | 5527698 | 20241111181844_SKSjG | UK0055 | 2024-11-13T14:08:56.236Z | 2024-11-20T14:25:18.250Z |
5527594 | 5527594 | 20241111174445_rUSWu | UK0055 | 2024-11-13T14:08:43.612Z | 2024-11-20T14:25:14.570Z |
5432411 | 5432411 | 20241029032919_ea3t1 | UK0055 | 2024-10-31T12:21:21.615Z | 2024-11-06T14:27:26.981Z |
5410674 | 5410674 | 20241027052632_7Q1Fv | UK0055 | 2024-10-29T12:18:02.258Z | 2024-11-04T14:29:05.207Z |
5407632 | 5407632 | 20241027024522_ZamG6 | UK0055 | 2024-10-29T12:15:31.985Z | 2024-11-04T14:28:57.955Z |
5407415 | 5407415 | 20241027023627_0TmIv | UK0055 | 2024-10-29T12:15:24.406Z | 2024-11-04T14:28:57.501Z |
5406689 | 5406689 | 20241027015414_7ctZo | UK0055 | 2024-10-29T12:14:32.615Z | 2024-11-04T14:28:56.036Z |
5406545 | 5406545 | 20241027014331_Zgd0J | UK0055 | 2024-10-29T12:14:18.759Z | 2024-11-04T14:28:55.846Z |
5406485 | 5406485 | 20241027014109_E8Bvi | UK0055 | 2024-10-29T12:14:12.878Z | 2024-11-04T14:28:55.760Z |
5406362 | 5406362 | 20241027013115_FPMVi | UK0055 | 2024-10-29T12:14:04.335Z | 2024-11-04T14:28:55.514Z |
5406317 | 5406317 | 20241027012728_I35oo | UK0055 | 2024-10-29T12:14:01.974Z | 2024-11-04T14:28:55.430Z |
5406081 | 5406081 | 20241027011435_8w85A | UK0055 | 2024-10-29T12:13:50.564Z | 2024-11-04T14:28:54.977Z |
5405576 | 5405576 | 20241027004600_Qle1n | UK0055 | 2024-10-29T12:13:03.211Z | 2024-11-04T14:28:53.630Z |
5405259 | 5405259 | 20241027002601_VvKUE | UK0055 | 2024-10-29T12:12:46.657Z | 2024-11-04T14:28:53.182Z |
5404894 | 5404894 | 20241026235927_cT0yD | UK0055 | 2024-10-29T12:12:05.583Z | 2024-11-04T14:28:52.375Z |
5404622 | 5404622 | 20241026234100_TL2Hf | UK0055 | 2024-10-29T12:11:46.814Z | 2024-11-04T14:28:51.443Z |
5404056 | 5404056 | 20241026225505_5tqjd | UK0055 | 2024-10-29T12:10:51.165Z | 2024-11-04T14:28:50.278Z |
5403988 | 5403988 | 20241026225145_8WsB7 | UK0055 | 2024-10-29T12:10:45.445Z | 2024-11-04T14:28:50.164Z |
5403647 | 5403647 | 20241026222058_GvZAY | UK0055 | 2024-10-29T12:10:04.843Z | 2024-11-04T14:28:49.399Z |
5403491 | 5403491 | 20241026220426_3Fte5 | UK0055 | 2024-10-29T12:09:37.416Z | 2024-11-04T14:28:49.008Z |
5403378 | 5403378 | 20241026214809_yDd8f | UK0055 | 2024-10-29T12:09:26.198Z | 2024-11-04T14:28:48.607Z |
5403102 | 5403102 | 20241026211907_v4vxC | UK0055 | 2024-10-29T12:08:56.192Z | 2024-11-04T14:28:47.716Z |
5402998 | 5402998 | 20241026210052_vMBFV | UK0055 | 2024-10-29T12:08:43.588Z | 2024-11-04T14:28:47.324Z |
5402902 | 5402902 | 20241026204215_BNY4h | UK0055 | 2024-10-29T12:08:34.312Z | 2024-11-04T14:28:46.924Z |
5400199 | 5400199 | 20241026060048_OMbqX | UK0055 | 2024-10-28T12:20:27.332Z | 2024-11-03T14:27:41.630Z |
5387521 | 5387521 | 20241025024853_4c3ZA | UK0055 | 2024-10-27T12:21:26.381Z | 2024-11-02T12:28:32.670Z |
5385589 | 5385589 | 20241024230453_0btiI | UK0055 | 2024-10-27T12:19:08.590Z | 2024-11-02T12:28:29.951Z |
5385565 | 5385565 | 20241024230126_OlYTn | UK0055 | 2024-10-27T12:19:06.875Z | 2024-11-02T12:28:29.941Z |
5385413 | 5385413 | 20241024223952_WfCLJ | UK0055 | 2024-10-27T12:18:53.159Z | 2024-11-02T12:28:29.719Z |
5385147 | 5385147 | 20241024215701_0DIf6 | UK0055 | 2024-10-27T12:18:28.780Z | 2024-11-02T12:28:29.210Z |
5384929 | 5384929 | 20241024211748_EJ3uv | UK0055 | 2024-10-27T12:17:59.507Z | 2024-11-02T12:28:28.706Z |
5356297 | 5356297 | 20241023053645_DgQ5Q | UK0055 | 2024-10-24T12:21:57.379Z | 2024-10-31T12:30:11.555Z |
5356180 | 5356180 | 20241023051230_SXOIv | UK0055 | 2024-10-24T12:21:55.033Z | 2024-10-31T12:30:10.764Z |
5356160 | 5356160 | 20241023051011_aHSzk | UK0055 | 2024-10-24T12:21:54.858Z | 2024-10-31T12:30:10.665Z |
5356120 | 5356120 | 20241023050237_Jq3vL | UK0055 | 2024-10-24T12:21:52.979Z | 2024-10-31T12:30:10.490Z |
5355902 | 5355902 | 20241023043355_biTGF | UK0055 | 2024-10-24T12:21:41.461Z | 2024-10-31T12:30:09.157Z |
5355851 | 5355851 | 20241023042823_LNJmR | UK0055 | 2024-10-24T12:21:39.461Z | 2024-10-31T12:30:09.072Z |
5355695 | 5355695 | 20241023040211_rtpOj | UK0055 | 2024-10-24T12:21:31.903Z | 2024-10-31T12:30:08.518Z |
5355563 | 5355563 | 20241023035046_Pyck4 | UK0055 | 2024-10-24T12:21:26.126Z | 2024-10-31T12:30:08.067Z |
5355513 | 5355513 | 20241023034654_N3hpw | UK0055 | 2024-10-24T12:21:24.534Z | 2024-10-31T12:30:07.905Z |
5355107 | 5355107 | 20241023031504_2tA7o | UK0055 | 2024-10-24T12:21:06.356Z | 2024-10-31T12:30:07.284Z |
5355079 | 5355079 | 20241023031320_hVSI3 | UK0055 | 2024-10-24T12:21:04.338Z | 2024-10-31T12:30:07.269Z |
5355022 | 5355022 | 20241023030527_TFnOG | UK0055 | 2024-10-24T12:21:00.445Z | 2024-10-31T12:30:07.013Z |
5354819 | 5354819 | 20241023024836_J2FVg | UK0055 | 2024-10-24T12:20:53.679Z | 2024-10-31T12:30:06.364Z |
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);