participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,606 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 |
---|---|---|---|---|---|
5605183 | 5605183 | 20241125031338_8zbbB | UK008U | 2024-11-26T14:18:40.469Z | 2024-11-26T14:18:45.265Z |
5605158 | 5605158 | 20241125030939_BueZO | UK008U | 2024-11-26T14:18:38.048Z | 2024-11-26T14:18:45.257Z |
5604812 | 5604812 | 20241125012641_mhM2z | UK008U | 2024-11-26T14:17:53.111Z | 2024-11-26T14:18:45.135Z |
5604595 | 5604595 | 20241125001257_IHC1N | UK008U | 2024-11-26T14:17:23.313Z | 2024-11-26T14:18:45.073Z |
5604591 | 5604591 | 20241125001228_EWs2l | UK008U | 2024-11-26T14:17:22.695Z | 2024-11-26T14:18:45.072Z |
5600422 | 5600422 | 20241125045050_zh8Ft | UK008U | 2024-11-26T14:01:49.957Z | 2024-11-26T14:01:49.957Z |
5600305 | 5600305 | 20241125042500_5JU0W | UK008U | 2024-11-26T14:01:20.207Z | 2024-11-26T14:01:20.207Z |
5600057 | 5600057 | 20241125032928_Kfzqy | UK008U | 2024-11-26T14:00:20.078Z | 2024-11-26T14:00:20.078Z |
5583134 | 5583134 | 20241120200743_as3dS | UK008U | 2024-11-23T14:23:12.106Z | 2024-11-26T14:26:22.910Z |
5574450 | 5574450 | 20241122054555_RrgtA | UK008U | 2024-11-23T14:03:24.472Z | 2024-11-26T14:22:22.481Z |
5570443 | 5570443 | 20241120194114_p6uiR | UK008U | 2024-11-22T14:15:26.390Z | 2024-11-26T14:26:21.009Z |
5570373 | 5570373 | 20241120192742_Fyvgr | UK008U | 2024-11-22T14:15:16.551Z | 2024-11-26T14:26:18.591Z |
5570302 | 5570302 | 20241120191432_Pc3Tr | UK008U | 2024-11-22T14:15:06.605Z | 2024-11-26T14:26:16.682Z |
5570279 | 5570279 | 20241120191243_3Vaop | UK008U | 2024-11-22T14:15:05.925Z | 2024-11-26T14:26:15.991Z |
5569832 | 5569832 | 20241120174131_z3zlo | UK008U | 2024-11-22T14:14:21.885Z | 2024-11-26T14:26:11.038Z |
5561500 | 5561500 | 20241119205006_29Yyd | UK008U | 2024-11-21T14:13:21.910Z | 2024-11-26T14:27:29.606Z |
5561360 | 5561360 | 20241119201134_q0Zv5 | UK008U | 2024-11-21T14:13:09.173Z | 2024-11-26T14:27:28.322Z |
5557748 | 5557748 | 20241120050927_spIoY | UK008U | 2024-11-21T14:01:38.801Z | 2024-11-26T14:25:38.513Z |
5557700 | 5557700 | 20241120050517_GLhx3 | UK008U | 2024-11-21T14:01:32.054Z | 2024-11-26T14:25:37.884Z |
5553903 | 5553903 | 20241118044533_DeMuw | UK008U | 2024-11-19T14:11:32.850Z | 2024-11-26T14:28:55.170Z |
5553892 | 5553892 | 20241118044302_PC8WY | UK008U | 2024-11-19T14:11:32.045Z | 2024-11-26T14:28:55.139Z |
5553640 | 5553640 | 20241118033852_O3eQo | UK008U | 2024-11-19T14:11:07.855Z | 2024-11-26T14:28:53.953Z |
5553602 | 5553602 | 20241118033107_hQPxr | UK008U | 2024-11-19T14:11:03.802Z | 2024-11-26T14:28:52.338Z |
5553578 | 5553578 | 20241118032408_lLnJM | UK008U | 2024-11-19T14:10:57.138Z | 2024-11-26T14:28:51.766Z |
5549536 | 5549536 | 20241118051451_xWA3B | UK008U | 2024-11-19T14:00:15.042Z | 2024-11-26T14:27:57.028Z |
5541655 | 5541655 | 20241114033711_Az0fT | UK008U | 2024-11-15T14:08:06.137Z | 2024-11-22T14:24:19.827Z |
5539215 | 5539215 | 20241114055001_1S7Kw | UK008U | 2024-11-15T14:00:22.637Z | 2024-11-23T14:26:01.255Z |
5538154 | 5538154 | 20241113022500_93u2e | UK008U | 2024-11-14T14:12:57.259Z | 2024-11-21T14:26:21.117Z |
5537969 | 5537969 | 20241113014523_eBPlx | UK008U | 2024-11-14T14:12:40.534Z | 2024-11-21T14:26:17.912Z |
5537841 | 5537841 | 20241113010209_Wf33R | UK008U | 2024-11-14T14:12:32.799Z | 2024-11-21T14:26:16.419Z |
5537817 | 5537817 | 20241113004524_hAT2v | UK008U | 2024-11-14T14:12:31.588Z | 2024-11-21T14:26:16.358Z |
5537787 | 5537787 | 20241113003745_e9Xlz | UK008U | 2024-11-14T14:12:29.925Z | 2024-11-21T14:26:15.923Z |
5537775 | 5537775 | 20241113003349_oOR1D | UK008U | 2024-11-14T14:12:29.572Z | 2024-11-21T14:26:15.910Z |
5537738 | 5537738 | 20241113002624_oFKD3 | UK008U | 2024-11-14T14:12:27.518Z | 2024-11-21T14:26:15.619Z |
5537462 | 5537462 | 20241112230859_22ki5 | UK008U | 2024-11-14T14:11:52.590Z | 2024-11-21T14:26:13.215Z |
5537438 | 5537438 | 20241112230034_OgL9R | UK008U | 2024-11-14T14:11:47.909Z | 2024-11-21T14:26:12.989Z |
5537400 | 5537400 | 20241112224059_iFFnY | UK008U | 2024-11-14T14:11:44.427Z | 2024-11-21T14:26:12.681Z |
5537329 | 5537329 | 20241112220850_ekY8o | UK008U | 2024-11-14T14:11:35.846Z | 2024-11-21T14:26:11.267Z |
5532610 | 5532610 | 20241112054358_jkDzG | UK008U | 2024-11-13T14:17:03.114Z | 2024-11-20T14:26:25.117Z |
5531789 | 5531789 | 20241112040906_atty8 | UK008U | 2024-11-13T14:15:55.054Z | 2024-11-20T14:26:14.329Z |
5531747 | 5531747 | 20241112040702_fgKQ8 | UK008U | 2024-11-13T14:15:53.565Z | 2024-11-20T14:26:13.779Z |
5531702 | 5531702 | 20241112040133_lboCb | UK008U | 2024-11-13T14:15:51.411Z | 2024-11-20T14:26:13.569Z |
5531464 | 5531464 | 20241112034106_iqT1h | UK008U | 2024-11-13T14:15:40.955Z | 2024-11-20T14:26:11.558Z |
5531014 | 5531014 | 20241112030602_T89rQ | UK008U | 2024-11-13T14:15:01.667Z | 2024-11-20T14:26:06.169Z |
5530727 | 5530727 | 20241112024048_NS4K6 | UK008U | 2024-11-13T14:14:31.558Z | 2024-11-20T14:26:02.902Z |
5530304 | 5530304 | 20241112020711_GV1ij | UK008U | 2024-11-13T14:14:07.897Z | 2024-11-20T14:25:56.816Z |
5530099 | 5530099 | 20241112014309_oKyEJ | UK008U | 2024-11-13T14:13:51.736Z | 2024-11-20T14:25:54.296Z |
5529981 | 5529981 | 20241112013231_2fAAn | UK008U | 2024-11-13T14:13:33.586Z | 2024-11-20T14:25:52.008Z |
5529967 | 5529967 | 20241112012939_pQEH8 | UK008U | 2024-11-13T14:13:30.364Z | 2024-11-20T14:25:51.639Z |
5529856 | 5529856 | 20241112011121_jN3us | UK008U | 2024-11-13T14:13:15.865Z | 2024-11-20T14:25:50.000Z |
5529537 | 5529537 | 20241112003131_73v1t | UK008U | 2024-11-13T14:12:56.939Z | 2024-11-20T14:25:46.174Z |
5529239 | 5529239 | 20241111235359_tFAp4 | UK008U | 2024-11-13T14:12:15.403Z | 2024-11-20T14:25:42.167Z |
5529200 | 5529200 | 20241111234632_kacXY | UK008U | 2024-11-13T14:12:13.334Z | 2024-11-20T14:25:41.774Z |
5529081 | 5529081 | 20241111232737_uSEUo | UK008U | 2024-11-13T14:12:03.596Z | 2024-11-20T14:25:39.576Z |
5528881 | 5528881 | 20241111230026_5gBub | UK008U | 2024-11-13T14:11:34.775Z | 2024-11-20T14:25:36.916Z |
5528763 | 5528763 | 20241111223341_zZfkX | UK008U | 2024-11-13T14:11:24.125Z | 2024-11-20T14:25:35.154Z |
5525744 | 5525744 | 20241112062133_i3qZR | UK008U | 2024-11-13T14:00:36.363Z | 2024-11-21T14:25:26.134Z |
5525615 | 5525615 | 20241112055638_AqEy8 | UK008U | 2024-11-13T14:00:08.855Z | 2024-11-21T14:25:24.341Z |
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 |
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);