participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,548 rows where station_code = "UK008U" 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 |
---|---|---|---|---|---|
5410820 | 5410820 | 20241027053828_3GkKk | UK008U | 2024-10-29T12:18:05.655Z | 2024-11-04T14:29:05.569Z |
5410638 | 5410638 | 20241027052518_2yvwL | UK008U | 2024-10-29T12:18:00.838Z | 2024-11-04T14:29:05.179Z |
5410489 | 5410489 | 20241027051501_HxJlR | UK008U | 2024-10-29T12:17:56.913Z | 2024-11-04T14:29:04.646Z |
5410447 | 5410447 | 20241027051311_2TBK8 | UK008U | 2024-10-29T12:17:55.799Z | 2024-11-04T14:29:04.602Z |
5409600 | 5409600 | 20241027042752_aw2D6 | UK008U | 2024-10-29T12:17:32.545Z | 2024-11-04T14:29:02.001Z |
5409429 | 5409429 | 20241027041736_2vA0o | UK008U | 2024-10-29T12:17:23.316Z | 2024-11-04T14:29:01.730Z |
5409291 | 5409291 | 20241027040956_UHaYu | UK008U | 2024-10-29T12:17:15.180Z | 2024-11-04T14:29:01.492Z |
5409216 | 5409216 | 20241027040600_j94Pm | UK008U | 2024-10-29T12:17:11.781Z | 2024-11-04T14:29:01.375Z |
5409143 | 5409143 | 20241027040225_JbaEG | UK008U | 2024-10-29T12:17:08.979Z | 2024-11-04T14:29:01.217Z |
5409086 | 5409086 | 20241027035928_Qzu63 | UK008U | 2024-10-29T12:17:05.186Z | 2024-11-04T14:29:01.040Z |
5409036 | 5409036 | 20241027035615_DQS0F | UK008U | 2024-10-29T12:17:02.070Z | 2024-11-04T14:29:00.952Z |
5409007 | 5409007 | 20241027035415_GA0Rd | UK008U | 2024-10-29T12:17:01.296Z | 2024-11-04T14:29:00.922Z |
5408827 | 5408827 | 20241027034455_G53lp | UK008U | 2024-10-29T12:16:54.328Z | 2024-11-04T14:29:00.607Z |
5408301 | 5408301 | 20241027032207_Qopv8 | UK008U | 2024-10-29T12:16:21.841Z | 2024-11-04T14:28:59.069Z |
5408248 | 5408248 | 20241027031918_2oFsU | UK008U | 2024-10-29T12:16:19.091Z | 2024-11-04T14:28:59.030Z |
5408204 | 5408204 | 20241027031618_MRFhN | UK008U | 2024-10-29T12:16:16.160Z | 2024-11-04T14:28:58.993Z |
5407242 | 5407242 | 20241027022801_VZzI4 | UK008U | 2024-10-29T12:15:18.396Z | 2024-11-04T14:28:57.259Z |
5407175 | 5407175 | 20241027022457_RalF2 | UK008U | 2024-10-29T12:15:15.865Z | 2024-11-04T14:28:57.168Z |
5407152 | 5407152 | 20241027022404_742y8 | UK008U | 2024-10-29T12:15:14.952Z | 2024-11-04T14:28:57.110Z |
5407121 | 5407121 | 20241027022310_alKaZ | UK008U | 2024-10-29T12:15:13.531Z | 2024-11-04T14:28:56.963Z |
5407036 | 5407036 | 20241027021751_ZtfmF | UK008U | 2024-10-29T12:15:09.757Z | 2024-11-04T14:28:56.791Z |
5406626 | 5406626 | 20241027015026_3kihp | UK008U | 2024-10-29T12:14:26.848Z | 2024-11-04T14:28:55.941Z |
5406523 | 5406523 | 20241027014237_CZ3Fi | UK008U | 2024-10-29T12:14:17.407Z | 2024-11-04T14:28:55.822Z |
5406300 | 5406300 | 20241027012637_mKDoj | UK008U | 2024-10-29T12:14:01.405Z | 2024-11-04T14:28:55.420Z |
5405649 | 5405649 | 20241027005213_mQwjZ | UK008U | 2024-10-29T12:13:07.403Z | 2024-11-04T14:28:53.747Z |
5405100 | 5405100 | 20241027001344_ckHDe | UK008U | 2024-10-29T12:12:27.469Z | 2024-11-04T14:28:52.678Z |
5404229 | 5404229 | 20241026231013_SK3sc | UK008U | 2024-10-29T12:11:02.298Z | 2024-11-04T14:28:50.522Z |
5402632 | 5402632 | 20241026200704_cNJ5P | UK008U | 2024-10-29T12:07:50.489Z | 2024-11-04T14:28:45.815Z |
5402520 | 5402520 | 20241026195042_B2kCL | UK008U | 2024-10-29T12:07:32.158Z | 2024-11-04T14:28:45.017Z |
5402438 | 5402438 | 20241026193709_Y7PnR | UK008U | 2024-10-29T12:07:17.303Z | 2024-11-04T14:28:44.444Z |
5402123 | 5402123 | 20241026184628_zrGwG | UK008U | 2024-10-29T12:06:28.219Z | 2024-11-04T14:28:42.383Z |
5402050 | 5402050 | 20241026183503_zAyMj | UK008U | 2024-10-29T12:06:10.599Z | 2024-11-04T14:28:41.855Z |
5400197 | 5400197 | 20241026055801_sQY19 | UK008U | 2024-10-28T12:20:27.320Z | 2024-11-03T14:27:41.626Z |
5400184 | 5400184 | 20241026055056_oCydi | UK008U | 2024-10-28T12:20:25.638Z | 2024-11-03T14:27:41.475Z |
5400180 | 5400180 | 20241026055029_ulbyN | UK008U | 2024-10-28T12:20:25.562Z | 2024-11-03T14:27:41.457Z |
5400174 | 5400174 | 20241026055019_eG88G | UK008U | 2024-10-28T12:20:25.540Z | 2024-11-03T14:27:41.455Z |
5400015 | 5400015 | 20241026052224_7tRj2 | UK008U | 2024-10-28T12:20:18.934Z | 2024-11-03T14:27:41.106Z |
5400003 | 5400003 | 20241026052135_PHSHr | UK008U | 2024-10-28T12:20:18.638Z | 2024-11-03T14:27:41.089Z |
5399985 | 5399985 | 20241026051859_o7xBp | UK008U | 2024-10-28T12:20:18.080Z | 2024-11-03T14:27:40.945Z |
5399853 | 5399853 | 20241026050713_jDlGu | UK008U | 2024-10-28T12:20:13.597Z | 2024-11-03T14:27:40.618Z |
5399768 | 5399768 | 20241026050042_xy1sv | UK008U | 2024-10-28T12:20:10.595Z | 2024-11-03T14:27:40.484Z |
5399672 | 5399672 | 20241026044705_5Z03f | UK008U | 2024-10-28T12:20:05.637Z | 2024-11-03T14:27:40.216Z |
5399421 | 5399421 | 20241026041722_Pa19H | UK008U | 2024-10-28T12:19:59.100Z | 2024-11-03T14:27:39.665Z |
5399049 | 5399049 | 20241026034658_XAPTn | UK008U | 2024-10-28T12:19:45.704Z | 2024-11-03T14:27:38.944Z |
5398765 | 5398765 | 20241026032649_4u1Of | UK008U | 2024-10-28T12:19:31.925Z | 2024-11-03T14:27:38.015Z |
5398686 | 5398686 | 20241026031856_0Ld6h | UK008U | 2024-10-28T12:19:28.467Z | 2024-11-03T14:27:37.707Z |
5398087 | 5398087 | 20241026022508_mFXe2 | UK008U | 2024-10-28T12:19:00.376Z | 2024-11-03T14:27:35.358Z |
5398042 | 5398042 | 20241026021956_zlsaw | UK008U | 2024-10-28T12:18:58.379Z | 2024-11-03T14:27:35.103Z |
5397952 | 5397952 | 20241026021014_cfCL9 | UK008U | 2024-10-28T12:18:52.126Z | 2024-11-03T14:27:34.693Z |
5397854 | 5397854 | 20241026020225_ICukr | UK008U | 2024-10-28T12:18:48.222Z | 2024-11-03T14:27:34.330Z |
5397847 | 5397847 | 20241026020215_MFn0G | UK008U | 2024-10-28T12:18:48.156Z | 2024-11-03T14:27:34.321Z |
5397809 | 5397809 | 20241026015947_g7Fuo | UK008U | 2024-10-28T12:18:43.914Z | 2024-11-03T14:27:34.169Z |
5397564 | 5397564 | 20241026014028_nsl8j | UK008U | 2024-10-28T12:18:27.973Z | 2024-11-03T14:27:33.405Z |
5397298 | 5397298 | 20241026011622_7nBQs | UK008U | 2024-10-28T12:18:14.887Z | 2024-11-03T14:27:32.551Z |
5397282 | 5397282 | 20241026011458_kUCHK | UK008U | 2024-10-28T12:18:14.217Z | 2024-11-03T14:27:32.511Z |
5397092 | 5397092 | 20241026010144_xnoUD | UK008U | 2024-10-28T12:18:07.543Z | 2024-11-03T14:27:32.018Z |
5397070 | 5397070 | 20241026010021_tmrGY | UK008U | 2024-10-28T12:18:05.900Z | 2024-11-03T14:27:31.987Z |
5396939 | 5396939 | 20241026004803_frqVE | UK008U | 2024-10-28T12:18:00.156Z | 2024-11-03T14:27:31.459Z |
5396913 | 5396913 | 20241026004541_PfkqP | UK008U | 2024-10-28T12:17:59.157Z | 2024-11-03T14:27:31.308Z |
5396907 | 5396907 | 20241026004441_kvqiH | UK008U | 2024-10-28T12:17:59.023Z | 2024-11-03T14:27:31.304Z |
5396855 | 5396855 | 20241026004150_l26nd | UK008U | 2024-10-28T12:17:57.884Z | 2024-11-03T14:27:31.239Z |
5396603 | 5396603 | 20241026001636_j0Q0c | UK008U | 2024-10-28T12:17:50.817Z | 2024-11-03T14:27:30.445Z |
5396517 | 5396517 | 20241026000918_ENyY7 | UK008U | 2024-10-28T12:17:48.263Z | 2024-11-03T14:27:30.051Z |
5375621 | 5375621 | 20241024032135_UFAkt | UK008U | 2024-10-26T12:21:33.633Z | 2024-11-01T12:27:01.111Z |
5372683 | 5372683 | 20241024010322_kVX3t | UK008U | 2024-10-26T12:19:38.331Z | 2024-11-01T12:26:57.810Z |
5372289 | 5372289 | 20241024004224_Ndi4o | UK008U | 2024-10-26T12:19:18.196Z | 2024-11-01T12:26:57.350Z |
5365197 | 5365197 | 20241023232006_mBPA2 | UK008U | 2024-10-25T12:17:50.647Z | 2024-11-01T12:26:55.964Z |
5365156 | 5365156 | 20241023231704_xp8Dq | UK008U | 2024-10-25T12:17:47.940Z | 2024-11-01T12:26:55.899Z |
5365141 | 5365141 | 20241023231628_o67Ak | UK008U | 2024-10-25T12:17:47.410Z | 2024-11-01T12:26:55.891Z |
5355870 | 5355870 | 20241023043127_Fjt0w | UK008U | 2024-10-24T12:21:40.673Z | 2024-10-31T12:30:09.139Z |
5355806 | 5355806 | 20241023042054_4VjvU | UK008U | 2024-10-24T12:21:37.495Z | 2024-10-31T12:30:08.923Z |
5355705 | 5355705 | 20241023040258_fpg5f | UK008U | 2024-10-24T12:21:32.999Z | 2024-10-31T12:30:08.543Z |
5355572 | 5355572 | 20241023035158_chn5i | UK008U | 2024-10-24T12:21:26.549Z | 2024-10-31T12:30:08.074Z |
5355528 | 5355528 | 20241023034754_cdyQK | UK008U | 2024-10-24T12:21:25.336Z | 2024-10-31T12:30:08.041Z |
5355495 | 5355495 | 20241023034604_wAC0H | UK008U | 2024-10-24T12:21:23.557Z | 2024-10-31T12:30:07.891Z |
5355148 | 5355148 | 20241023031818_DqG6s | UK008U | 2024-10-24T12:21:08.796Z | 2024-10-31T12:30:07.352Z |
5355138 | 5355138 | 20241023031649_pIfRg | UK008U | 2024-10-24T12:21:08.145Z | 2024-10-31T12:30:07.325Z |
5354754 | 5354754 | 20241023024356_N91Ri | UK008U | 2024-10-24T12:20:48.689Z | 2024-10-31T12:30:06.295Z |
5354450 | 5354450 | 20241023022650_AfE4j | UK008U | 2024-10-24T12:20:34.172Z | 2024-10-31T12:30:05.859Z |
5354410 | 5354410 | 20241023022538_Quqcr | UK008U | 2024-10-24T12:20:32.158Z | 2024-10-31T12:30:05.743Z |
5354198 | 5354198 | 20241023021015_M032Y | UK008U | 2024-10-24T12:20:22.050Z | 2024-10-31T12:30:05.503Z |
5354193 | 5354193 | 20241023021006_6Y4el | UK008U | 2024-10-24T12:20:21.263Z | 2024-10-31T12:30:05.499Z |
5354099 | 5354099 | 20241023020417_7Rz33 | UK008U | 2024-10-24T12:20:14.968Z | 2024-10-31T12:30:05.359Z |
5354015 | 5354015 | 20241023015956_O1GGT | UK008U | 2024-10-24T12:20:09.111Z | 2024-10-31T12:30:05.266Z |
5353828 | 5353828 | 20241023015056_F22Sd | UK008U | 2024-10-24T12:19:57.825Z | 2024-10-31T12:30:04.876Z |
5353421 | 5353421 | 20241023012522_753ZA | UK008U | 2024-10-24T12:19:42.461Z | 2024-10-31T12:30:04.240Z |
5353399 | 5353399 | 20241023012344_aLO31 | UK008U | 2024-10-24T12:19:41.479Z | 2024-10-31T12:30:04.225Z |
5353379 | 5353379 | 20241023012312_93uRa | UK008U | 2024-10-24T12:19:40.919Z | 2024-10-31T12:30:04.206Z |
5353167 | 5353167 | 20241023011157_367UV | UK008U | 2024-10-24T12:19:34.403Z | 2024-10-31T12:30:03.897Z |
5352694 | 5352694 | 20241023004424_E0x3o | UK008U | 2024-10-24T12:19:05.550Z | 2024-10-31T12:30:03.149Z |
5352686 | 5352686 | 20241023004356_79B1F | UK008U | 2024-10-24T12:19:05.232Z | 2024-10-31T12:30:03.143Z |
5352637 | 5352637 | 20241023004215_xQqDG | UK008U | 2024-10-24T12:19:02.154Z | 2024-10-31T12:30:03.009Z |
5352555 | 5352555 | 20241023003838_4FTes | UK008U | 2024-10-24T12:18:56.915Z | 2024-10-31T12:30:02.883Z |
5352190 | 5352190 | 20241023001644_CLdav | UK008U | 2024-10-24T12:18:29.419Z | 2024-10-31T12:30:02.281Z |
5351886 | 5351886 | 20241022235725_KBkTj | UK008U | 2024-10-24T12:18:07.469Z | 2024-10-31T12:30:01.179Z |
5351724 | 5351724 | 20241022234922_cmHPJ | UK008U | 2024-10-24T12:17:53.692Z | 2024-10-31T12:30:00.819Z |
5351516 | 5351516 | 20241022233500_A3AS2 | UK008U | 2024-10-24T12:17:37.687Z | 2024-10-31T12:30:00.489Z |
5351475 | 5351475 | 20241022233128_IIhgF | UK008U | 2024-10-24T12:17:34.036Z | 2024-10-31T12:30:00.436Z |
5351323 | 5351323 | 20241022231640_VaB93 | UK008U | 2024-10-24T12:17:26.366Z | 2024-10-31T12:30:00.189Z |
5351287 | 5351287 | 20241022231325_YEZlO | UK008U | 2024-10-24T12:17:24.163Z | 2024-10-31T12:29:59.747Z |
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);