participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
464 rows where station_code = "UK00C3" 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 |
---|---|---|---|---|---|
5573113 | 5573113 | 20241121035320_WF3jE | UK00C3 | 2024-11-22T14:19:10.135Z | 2024-11-22T14:19:22.451Z |
5573101 | 5573101 | 20241121035131_mA1A2 | UK00C3 | 2024-11-22T14:19:09.713Z | 2024-11-22T14:19:22.449Z |
5572674 | 5572674 | 20241121025509_RJJJy | UK00C3 | 2024-11-22T14:18:42.006Z | 2024-11-22T14:19:22.371Z |
5572629 | 5572629 | 20241121025101_yvK3x | UK00C3 | 2024-11-22T14:18:40.183Z | 2024-11-22T14:19:22.364Z |
5571524 | 5571524 | 20241121000025_51w2D | UK00C3 | 2024-11-22T14:17:13.768Z | 2024-11-22T14:19:22.141Z |
5571347 | 5571347 | 20241120232601_M6fG2 | UK00C3 | 2024-11-22T14:16:54.487Z | 2024-11-22T14:19:22.106Z |
5571296 | 5571296 | 20241120231703_YCwUT | UK00C3 | 2024-11-22T14:16:48.659Z | 2024-11-22T14:19:22.093Z |
5571185 | 5571185 | 20241120224532_HNmbB | UK00C3 | 2024-11-22T14:16:35.238Z | 2024-11-22T14:19:22.058Z |
5570925 | 5570925 | 20241120213139_ZT8Uv | UK00C3 | 2024-11-22T14:16:12.166Z | 2024-11-22T14:19:22.005Z |
5570528 | 5570528 | 20241120195537_WXlii | UK00C3 | 2024-11-22T14:15:40.904Z | 2024-11-22T14:19:21.932Z |
5570089 | 5570089 | 20241120183904_2zVkh | UK00C3 | 2024-11-22T14:14:50.135Z | 2024-11-22T14:19:21.859Z |
5569936 | 5569936 | 20241120180140_spbp7 | UK00C3 | 2024-11-22T14:14:37.981Z | 2024-11-22T14:19:21.832Z |
5566441 | 5566441 | 20241121061138_fE4Kn | UK00C3 | 2024-11-22T14:02:54.009Z | 2024-11-22T14:02:54.009Z |
5566360 | 5566360 | 20241121060453_BdFmC | UK00C3 | 2024-11-22T14:02:31.647Z | 2024-11-22T14:02:31.647Z |
5566334 | 5566334 | 20241121060125_O7x8Y | UK00C3 | 2024-11-22T14:02:28.775Z | 2024-11-22T14:02:28.775Z |
5566207 | 5566207 | 20241121054618_MFRUT | UK00C3 | 2024-11-22T14:02:12.957Z | 2024-11-22T14:02:12.957Z |
5565668 | 5565668 | 20241121043305_85RQf | UK00C3 | 2024-11-22T14:00:37.756Z | 2024-11-22T14:00:37.756Z |
5565554 | 5565554 | 20241121042109_zmJni | UK00C3 | 2024-11-22T14:00:15.837Z | 2024-11-22T14:00:15.837Z |
5561426 | 5561426 | 20241119203021_yvGts | UK00C3 | 2024-11-21T14:13:15.764Z | 2024-11-22T14:20:35.908Z |
5561407 | 5561407 | 20241119202611_mfrx7 | UK00C3 | 2024-11-21T14:13:13.959Z | 2024-11-22T14:20:34.959Z |
5561286 | 5561286 | 20241119193428_4QRf2 | UK00C3 | 2024-11-21T14:13:00.215Z | 2024-11-22T14:20:30.013Z |
5557746 | 5557746 | 20241120050922_2dXxz | UK00C3 | 2024-11-21T14:01:38.017Z | 2024-11-22T14:19:21.120Z |
5557434 | 5557434 | 20241120044510_U7lFI | UK00C3 | 2024-11-21T14:00:49.513Z | 2024-11-22T14:19:21.068Z |
5553807 | 5553807 | 20241118042312_at51j | UK00C3 | 2024-11-19T14:11:27.738Z | 2024-11-22T14:22:56.378Z |
5553731 | 5553731 | 20241118040339_zvDiP | UK00C3 | 2024-11-19T14:11:21.955Z | 2024-11-22T14:22:55.905Z |
5553485 | 5553485 | 20241118025503_5WQ1z | UK00C3 | 2024-11-19T14:10:41.645Z | 2024-11-22T14:22:53.533Z |
5549725 | 5549725 | 20241118061018_nQTwp | UK00C3 | 2024-11-19T14:00:40.608Z | 2024-11-22T14:21:51.780Z |
5549675 | 5549675 | 20241118055713_O5OZt | UK00C3 | 2024-11-19T14:00:33.181Z | 2024-11-22T14:21:51.130Z |
5549612 | 5549612 | 20241118053756_ZAOU3 | UK00C3 | 2024-11-19T14:00:25.416Z | 2024-11-22T14:21:50.704Z |
5549565 | 5549565 | 20241118053047_qVIdR | UK00C3 | 2024-11-19T14:00:19.131Z | 2024-11-22T14:21:50.327Z |
5549542 | 5549542 | 20241118051555_8ygns | UK00C3 | 2024-11-19T14:00:15.500Z | 2024-11-22T14:21:49.975Z |
5549489 | 5549489 | 20241117050327_oidc8 | UK00C3 | 2024-11-18T14:11:44.315Z | 2024-11-22T14:23:21.314Z |
5549457 | 5549457 | 20241117045615_3Ak8l | UK00C3 | 2024-11-18T14:11:37.843Z | 2024-11-22T14:23:21.069Z |
5549452 | 5549452 | 20241117045522_a6n5U | UK00C3 | 2024-11-18T14:11:37.519Z | 2024-11-22T14:23:21.064Z |
5549366 | 5549366 | 20241117043444_EYXxW | UK00C3 | 2024-11-18T14:11:30.446Z | 2024-11-22T14:23:20.418Z |
5549282 | 5549282 | 20241117040757_xzDyB | UK00C3 | 2024-11-18T14:11:24.741Z | 2024-11-22T14:23:20.017Z |
5549182 | 5549182 | 20241117033811_iZ72G | UK00C3 | 2024-11-18T14:11:13.914Z | 2024-11-22T14:23:19.172Z |
5549146 | 5549146 | 20241117032642_rgh2Z | UK00C3 | 2024-11-18T14:11:06.694Z | 2024-11-22T14:23:18.906Z |
5549045 | 5549045 | 20241117024916_jbr2h | UK00C3 | 2024-11-18T14:10:45.986Z | 2024-11-22T14:23:17.681Z |
5545601 | 5545601 | 20241117053504_OQ5Er | UK00C3 | 2024-11-18T14:00:24.394Z | 2024-11-22T14:22:25.034Z |
5545593 | 5545593 | 20241117053232_eNrxX | UK00C3 | 2024-11-18T14:00:23.186Z | 2024-11-22T14:22:25.014Z |
5545573 | 5545573 | 20241117052547_IaQXl | UK00C3 | 2024-11-18T14:00:19.589Z | 2024-11-22T14:22:24.901Z |
5545541 | 5545541 | 20241117051813_0uoIh | UK00C3 | 2024-11-18T14:00:13.308Z | 2024-11-22T14:22:24.678Z |
5541638 | 5541638 | 20241114032618_7PVLc | UK00C3 | 2024-11-15T14:08:00.850Z | 2024-11-22T14:24:19.735Z |
5539014 | 5539014 | 20241113053244_a8ori | UK00C3 | 2024-11-14T14:14:08.379Z | 2024-11-21T14:26:31.009Z |
5538250 | 5538250 | 20241113024705_fLAGF | UK00C3 | 2024-11-14T14:13:08.574Z | 2024-11-21T14:26:22.650Z |
5538129 | 5538129 | 20241113021658_syo06 | UK00C3 | 2024-11-14T14:12:53.262Z | 2024-11-21T14:26:20.881Z |
5537986 | 5537986 | 20241113014759_sAr8v | UK00C3 | 2024-11-14T14:12:41.439Z | 2024-11-21T14:26:18.334Z |
5537615 | 5537615 | 20241112235400_DIf16 | UK00C3 | 2024-11-14T14:12:16.673Z | 2024-11-21T14:26:14.939Z |
5537424 | 5537424 | 20241112224638_8au42 | UK00C3 | 2024-11-14T14:11:46.918Z | 2024-11-21T14:26:12.847Z |
5537260 | 5537260 | 20241112213857_L99pa | UK00C3 | 2024-11-14T14:11:28.361Z | 2024-11-21T14:26:10.714Z |
5531388 | 5531388 | 20241112033505_sqR22 | UK00C3 | 2024-11-13T14:15:36.840Z | 2024-11-20T14:26:10.782Z |
5530721 | 5530721 | 20241112023953_DMH7F | UK00C3 | 2024-11-13T14:14:30.655Z | 2024-11-20T14:26:02.876Z |
5530643 | 5530643 | 20241112023555_MaLpu | UK00C3 | 2024-11-13T14:14:25.733Z | 2024-11-20T14:26:02.185Z |
5524187 | 5524187 | 20241111032501_ruGG1 | UK00C3 | 2024-11-12T14:16:42.626Z | 2024-11-19T14:22:17.851Z |
5524135 | 5524135 | 20241111031801_j8Vce | UK00C3 | 2024-11-12T14:16:34.962Z | 2024-11-19T14:22:17.516Z |
5523863 | 5523863 | 20241111023910_fgYx3 | UK00C3 | 2024-11-12T14:16:17.763Z | 2024-11-19T14:22:15.606Z |
5523792 | 5523792 | 20241111022404_wBPSf | UK00C3 | 2024-11-12T14:16:13.269Z | 2024-11-19T14:22:14.922Z |
5523721 | 5523721 | 20241111021046_cJaEn | UK00C3 | 2024-11-12T14:16:08.996Z | 2024-11-19T14:22:14.531Z |
5523710 | 5523710 | 20241111021008_UWbC3 | UK00C3 | 2024-11-12T14:16:08.650Z | 2024-11-19T14:22:14.489Z |
5523669 | 5523669 | 20241111020317_uBlPv | UK00C3 | 2024-11-12T14:16:06.733Z | 2024-11-19T14:22:14.300Z |
5523654 | 5523654 | 20241111020052_rnuBB | UK00C3 | 2024-11-12T14:16:06.158Z | 2024-11-19T14:22:14.267Z |
5523134 | 5523134 | 20241111001220_1p6Lm | UK00C3 | 2024-11-12T14:14:48.581Z | 2024-11-19T14:22:10.124Z |
5522891 | 5522891 | 20241110224133_FKZS8 | UK00C3 | 2024-11-12T14:14:27.252Z | 2024-11-19T14:22:08.626Z |
5522775 | 5522775 | 20241110212645_HrbQM | UK00C3 | 2024-11-12T14:14:14.274Z | 2024-11-19T14:22:06.217Z |
5521854 | 5521854 | 20241110182341_Ov2uP | UK00C3 | 2024-11-12T14:12:04.337Z | 2024-11-19T14:21:55.774Z |
5521622 | 5521622 | 20241110174241_fHSEb | UK00C3 | 2024-11-12T14:11:44.533Z | 2024-11-19T14:21:53.860Z |
5454680 | 5454680 | 20241031045456_RJh0U | UK00C3 | 2024-11-02T12:23:16.701Z | 2024-11-08T14:23:24.748Z |
5451920 | 5451920 | 20241101012740_K4y3Y | UK00C3 | 2024-11-02T12:18:06.114Z | 2024-11-09T14:24:26.660Z |
5451765 | 5451765 | 20241101010026_OXYq7 | UK00C3 | 2024-11-02T12:17:56.256Z | 2024-11-09T14:24:25.381Z |
5442968 | 5442968 | 20241030030635_bUcHx | UK00C3 | 2024-11-01T12:20:14.602Z | 2024-11-07T14:26:49.066Z |
5442663 | 5442663 | 20241030021054_XXJIb | UK00C3 | 2024-11-01T12:20:04.485Z | 2024-11-07T14:26:47.485Z |
5442373 | 5442373 | 20241030012217_OwfwL | UK00C3 | 2024-11-01T12:19:45.035Z | 2024-11-07T14:26:46.380Z |
5442280 | 5442280 | 20241030010615_1gnFi | UK00C3 | 2024-11-01T12:19:37.811Z | 2024-11-07T14:26:45.827Z |
5441809 | 5441809 | 20241029234053_o9cN8 | UK00C3 | 2024-11-01T12:19:03.110Z | 2024-11-07T14:26:43.476Z |
5441552 | 5441552 | 20241029223520_qrrYT | UK00C3 | 2024-11-01T12:18:44.472Z | 2024-11-07T14:26:42.648Z |
5441298 | 5441298 | 20241029213341_3Xhn1 | UK00C3 | 2024-11-01T12:18:25.155Z | 2024-11-07T14:26:41.596Z |
5432704 | 5432704 | 20241029042139_gfI9V | UK00C3 | 2024-10-31T12:21:31.821Z | 2024-11-06T14:27:28.501Z |
5410800 | 5410800 | 20241027053748_lNw7V | UK00C3 | 2024-10-29T12:18:05.218Z | 2024-11-04T14:29:05.500Z |
5410079 | 5410079 | 20241027045207_1TjLi | UK00C3 | 2024-10-29T12:17:47.179Z | 2024-11-04T14:29:03.669Z |
5409575 | 5409575 | 20241027042546_KOBrQ | UK00C3 | 2024-10-29T12:17:30.908Z | 2024-11-04T14:29:01.962Z |
5409380 | 5409380 | 20241027041326_SJ6bX | UK00C3 | 2024-10-29T12:17:18.693Z | 2024-11-04T14:29:01.608Z |
5409184 | 5409184 | 20241027040510_L5r1i | UK00C3 | 2024-10-29T12:17:10.493Z | 2024-11-04T14:29:01.355Z |
5408964 | 5408964 | 20241027035134_DaS3U | UK00C3 | 2024-10-29T12:16:58.206Z | 2024-11-04T14:29:00.872Z |
5407478 | 5407478 | 20241027023830_WjmaM | UK00C3 | 2024-10-29T12:15:26.065Z | 2024-11-04T14:28:57.655Z |
5407160 | 5407160 | 20241027022410_d8omz | UK00C3 | 2024-10-29T12:15:15.135Z | 2024-11-04T14:28:57.116Z |
5407056 | 5407056 | 20241027021848_2V2Rh | UK00C3 | 2024-10-29T12:15:10.300Z | 2024-11-04T14:28:56.815Z |
5406619 | 5406619 | 20241027014857_VuRt8 | UK00C3 | 2024-10-29T12:14:25.250Z | 2024-11-04T14:28:55.924Z |
5406069 | 5406069 | 20241027011402_IEdi6 | UK00C3 | 2024-10-29T12:13:49.976Z | 2024-11-04T14:28:54.916Z |
5406036 | 5406036 | 20241027011245_Lj2ZT | UK00C3 | 2024-10-29T12:13:48.660Z | 2024-11-04T14:28:54.896Z |
5404755 | 5404755 | 20241026235057_U75k9 | UK00C3 | 2024-10-29T12:11:56.082Z | 2024-11-04T14:28:51.905Z |
5404713 | 5404713 | 20241026234709_lYqMt | UK00C3 | 2024-10-29T12:11:53.948Z | 2024-11-04T14:28:51.689Z |
5404578 | 5404578 | 20241026233905_qFuyg | UK00C3 | 2024-10-29T12:11:43.932Z | 2024-11-04T14:28:51.349Z |
5404553 | 5404553 | 20241026233627_UriQw | UK00C3 | 2024-10-29T12:11:42.161Z | 2024-11-04T14:28:51.318Z |
5385311 | 5385311 | 20241024222101_Hul7N | UK00C3 | 2024-10-27T12:18:43.709Z | 2024-11-02T12:28:29.539Z |
5372271 | 5372271 | 20241024004204_iXmt9 | UK00C3 | 2024-10-26T12:19:17.433Z | 2024-11-01T12:26:57.334Z |
5365182 | 5365182 | 20241023231952_lvqb2 | UK00C3 | 2024-10-25T12:17:50.396Z | 2024-11-01T12:26:55.959Z |
5365066 | 5365066 | 20241023231206_2woE1 | UK00C3 | 2024-10-25T12:17:44.884Z | 2024-11-01T12:26:55.846Z |
5364671 | 5364671 | 20241023224535_3czGB | UK00C3 | 2024-10-25T12:17:29.062Z | 2024-11-01T12:26:55.351Z |
5348957 | 5348957 | 20241022191151_McGs9 | UK00C3 | 2024-10-24T12:12:38.418Z | 2024-10-31T12:29:54.233Z |
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);