participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
813 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 |
---|---|---|---|---|---|
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 |
5353947 | 5353947 | 20241023015552_9Je5M | UK0055 | 2024-10-24T12:20:05.861Z | 2024-10-31T12:30:05.196Z |
5343274 | 5343274 | 20241022031932_2qFBY | UK0055 | 2024-10-23T12:17:41.105Z | 2024-10-30T12:26:49.793Z |
5343201 | 5343201 | 20241022031557_wbpKr | UK0055 | 2024-10-23T12:17:38.735Z | 2024-10-30T12:26:49.556Z |
5340748 | 5340748 | 20241022004631_gBfta | UK0055 | 2024-10-23T12:14:52.234Z | 2024-10-30T12:26:46.259Z |
5340389 | 5340389 | 20241022001011_sk02h | UK0055 | 2024-10-23T12:14:30.789Z | 2024-10-30T12:26:45.731Z |
5340299 | 5340299 | 20241022000421_hKoyh | UK0055 | 2024-10-23T12:14:27.906Z | 2024-10-30T12:26:45.668Z |
5326709 | 5326709 | 20241019194751_6LbHE | UK0055 | 2024-10-21T12:10:11.476Z | 2024-10-28T12:26:42.313Z |
5326672 | 5326672 | 20241019193838_Mvak5 | UK0055 | 2024-10-21T12:10:08.471Z | 2024-10-28T12:26:42.299Z |
5326424 | 5326424 | 20241019182539_BvCrh | UK0055 | 2024-10-21T12:09:24.842Z | 2024-10-28T12:26:41.649Z |
5319861 | 5319861 | 20241017213959_Rmbir | UK0055 | 2024-10-19T12:04:01.016Z | 2024-10-26T12:27:53.365Z |
5311494 | 5311494 | 20241015005456_PMbkC | UK0055 | 2024-10-16T12:08:58.136Z | 2024-10-23T12:24:43.640Z |
5310923 | 5310923 | 20241014214955_C3B6f | UK0055 | 2024-10-16T12:08:01.226Z | 2024-10-23T12:24:40.037Z |
5310850 | 5310850 | 20241014205536_nlgd7 | UK0055 | 2024-10-16T12:07:54.304Z | 2024-10-23T12:24:39.303Z |
5310838 | 5310838 | 20241014205018_wQ1fx | UK0055 | 2024-10-16T12:07:53.438Z | 2024-10-23T12:24:39.256Z |
5310593 | 5310593 | 20241014190906_Aeujf | UK0055 | 2024-10-16T12:07:17.692Z | 2024-10-23T12:24:35.770Z |
5306865 | 5306865 | 20241014043431_o5Ik6 | UK0055 | 2024-10-15T12:08:37.856Z | 2024-10-22T12:24:45.264Z |
5306862 | 5306862 | 20241014043251_0aY8O | UK0055 | 2024-10-15T12:08:37.304Z | 2024-10-22T12:24:45.256Z |
5306843 | 5306843 | 20241014042202_22jd7 | UK0055 | 2024-10-15T12:08:31.819Z | 2024-10-22T12:24:44.808Z |
5306424 | 5306424 | 20241014021904_fYdzP | UK0055 | 2024-10-15T12:07:23.267Z | 2024-10-22T12:24:39.269Z |
5304435 | 5304435 | 20241014052136_Ty8Ha | UK0055 | 2024-10-15T12:00:21.045Z | 2024-10-23T12:24:09.233Z |
5304387 | 5304387 | 20241014045945_GCIwm | UK0055 | 2024-10-15T12:00:11.417Z | 2024-10-23T12:24:07.764Z |
5304240 | 5304240 | 20241013043131_r4Mei | UK0055 | 2024-10-14T12:17:45.668Z | 2024-10-21T12:24:24.469Z |
5304180 | 5304180 | 20241013042512_XZuzi | UK0055 | 2024-10-14T12:17:44.238Z | 2024-10-21T12:24:24.041Z |
5302239 | 5302239 | 20241013004257_4dC1E | UK0055 | 2024-10-14T12:16:02.183Z | 2024-10-21T12:24:05.781Z |
5302224 | 5302224 | 20241013004149_FJ2Fr | UK0055 | 2024-10-14T12:16:01.323Z | 2024-10-21T12:24:05.485Z |
5302096 | 5302096 | 20241013003027_B7jZ3 | UK0055 | 2024-10-14T12:15:52.644Z | 2024-10-21T12:24:04.393Z |
5300974 | 5300974 | 20241012221943_zWAbe | UK0055 | 2024-10-14T12:14:40.366Z | 2024-10-21T12:23:54.263Z |
5300604 | 5300604 | 20241012210035_eTWiy | UK0055 | 2024-10-14T12:14:18.590Z | 2024-10-21T12:23:50.423Z |
5300555 | 5300555 | 20241012205228_gaS5o | UK0055 | 2024-10-14T12:14:15.309Z | 2024-10-21T12:23:49.894Z |
5300524 | 5300524 | 20241012204808_Whsvl | UK0055 | 2024-10-14T12:14:13.659Z | 2024-10-21T12:23:49.593Z |
5299866 | 5299866 | 20241012194202_mra3L | UK0055 | 2024-10-14T12:13:14.118Z | 2024-10-21T12:23:44.470Z |
5294985 | 5294985 | 20241013052130_7YuNw | UK0055 | 2024-10-14T12:00:44.571Z | 2024-10-22T12:24:07.146Z |
5294977 | 5294977 | 20241013051919_Zr1Kb | UK0055 | 2024-10-14T12:00:43.544Z | 2024-10-22T12:24:07.095Z |
5294967 | 5294967 | 20241013051821_ti37u | UK0055 | 2024-10-14T12:00:42.134Z | 2024-10-22T12:24:06.959Z |
5294883 | 5294883 | 20241013050621_z53fV | UK0055 | 2024-10-14T12:00:34.474Z | 2024-10-22T12:24:06.316Z |
5283036 | 5283036 | 20241011003226_z2P4k | UK0055 | 2024-10-12T12:16:21.089Z | 2024-10-19T12:27:48.320Z |
5282859 | 5282859 | 20241010235905_p023Z | UK0055 | 2024-10-12T12:16:09.181Z | 2024-10-19T12:27:46.977Z |
5282618 | 5282618 | 20241010224028_Ck3VV | UK0055 | 2024-10-12T12:15:49.033Z | 2024-10-19T12:27:44.896Z |
5275932 | 5275932 | 20241010034431_rsAKl | UK0055 | 2024-10-11T12:16:36.122Z | 2024-10-18T12:22:21.249Z |
5275812 | 5275812 | 20241010031250_ELzdr | UK0055 | 2024-10-11T12:16:26.597Z | 2024-10-18T12:22:20.610Z |
5275780 | 5275780 | 20241010030917_zAuCu | UK0055 | 2024-10-11T12:16:23.986Z | 2024-10-18T12:22:20.450Z |
5275714 | 5275714 | 20241010030157_MkYmS | UK0055 | 2024-10-11T12:16:18.336Z | 2024-10-18T12:22:19.961Z |
5275606 | 5275606 | 20241010024752_y2mxG | UK0055 | 2024-10-11T12:16:09.692Z | 2024-10-18T12:22:19.284Z |
5275546 | 5275546 | 20241010023706_Pcc70 | UK0055 | 2024-10-11T12:16:05.077Z | 2024-10-18T12:22:18.827Z |
5275399 | 5275399 | 20241010020715_ZMkTB | UK0055 | 2024-10-11T12:15:48.161Z | 2024-10-18T12:22:17.023Z |
5275331 | 5275331 | 20241010015211_sdLY1 | UK0055 | 2024-10-11T12:15:42.859Z | 2024-10-18T12:22:16.587Z |
5275298 | 5275298 | 20241010014340_Kgtcz | UK0055 | 2024-10-11T12:15:39.163Z | 2024-10-18T12:22:16.242Z |
5274526 | 5274526 | 20241009213558_sSGpa | UK0055 | 2024-10-11T12:14:35.955Z | 2024-10-18T12:22:09.872Z |
5274510 | 5274510 | 20241009212646_zDpsi | UK0055 | 2024-10-11T12:14:34.365Z | 2024-10-18T12:22:09.833Z |
5274441 | 5274441 | 20241009204307_2Jggv | UK0055 | 2024-10-11T12:14:23.751Z | 2024-10-18T12:22:08.544Z |
5269267 | 5269267 | 20241010045644_rNzXE | UK0055 | 2024-10-11T12:01:07.192Z | 2024-10-19T12:26:48.617Z |
5269099 | 5269099 | 20241010041814_RZ7n3 | UK0055 | 2024-10-11T12:00:31.202Z | 2024-10-19T12:26:46.802Z |
5245536 | 5245536 | 20241005232120_Zuaym | UK0055 | 2024-10-07T12:15:44.005Z | 2024-10-14T12:24:35.777Z |
5245479 | 5245479 | 20241005231034_T3lZQ | UK0055 | 2024-10-07T12:15:41.741Z | 2024-10-14T12:24:35.684Z |
5216828 | 5216828 | 20241003013010_l3lYz | UK0055 | 2024-10-04T12:13:50.599Z | 2024-10-11T12:23:37.803Z |
5216791 | 5216791 | 20241003012633_g4x23 | UK0055 | 2024-10-04T12:13:49.126Z | 2024-10-11T12:23:37.782Z |
5216694 | 5216694 | 20241003011647_XjqdE | UK0055 | 2024-10-04T12:13:42.349Z | 2024-10-11T12:23:37.679Z |
5216215 | 5216215 | 20241003004352_oHffj | UK0055 | 2024-10-04T12:12:56.749Z | 2024-10-11T12:23:36.684Z |
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);