participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,908 rows where station_code = "UK006L" 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 |
---|---|---|---|---|---|
5572874 | 5572874 | 20241121031826_Lb44n | UK006L | 2024-11-22T14:18:55.308Z | 2024-11-22T14:19:22.405Z |
5572648 | 5572648 | 20241121025248_Oct7v | UK006L | 2024-11-22T14:18:41.216Z | 2024-11-22T14:19:22.367Z |
5572433 | 5572433 | 20241121022113_tXAie | UK006L | 2024-11-22T14:18:26.670Z | 2024-11-22T14:19:22.329Z |
5572218 | 5572218 | 20241121015154_SIeUT | UK006L | 2024-11-22T14:18:05.508Z | 2024-11-22T14:19:22.282Z |
5572202 | 5572202 | 20241121014654_x2ne8 | UK006L | 2024-11-22T14:18:04.710Z | 2024-11-22T14:19:22.279Z |
5572091 | 5572091 | 20241121013211_RN01c | UK006L | 2024-11-22T14:17:57.006Z | 2024-11-22T14:19:22.257Z |
5572017 | 5572017 | 20241121012102_n2T8O | UK006L | 2024-11-22T14:17:52.967Z | 2024-11-22T14:19:22.243Z |
5571851 | 5571851 | 20241121005622_e3tEZ | UK006L | 2024-11-22T14:17:42.811Z | 2024-11-22T14:19:22.208Z |
5571240 | 5571240 | 20241120230728_ZvYaI | UK006L | 2024-11-22T14:16:41.794Z | 2024-11-22T14:19:22.076Z |
5571138 | 5571138 | 20241120223332_qLfll | UK006L | 2024-11-22T14:16:30.104Z | 2024-11-22T14:19:22.050Z |
5571131 | 5571131 | 20241120223129_IEXK0 | UK006L | 2024-11-22T14:16:28.612Z | 2024-11-22T14:19:22.048Z |
5570856 | 5570856 | 20241120211906_i9kgS | UK006L | 2024-11-22T14:16:09.504Z | 2024-11-22T14:19:21.995Z |
5570813 | 5570813 | 20241120210549_mmWLM | UK006L | 2024-11-22T14:16:06.850Z | 2024-11-22T14:19:21.986Z |
5570694 | 5570694 | 20241120204416_MSzMq | UK006L | 2024-11-22T14:16:01.233Z | 2024-11-22T14:19:21.965Z |
5570500 | 5570500 | 20241120194904_XUquK | UK006L | 2024-11-22T14:15:37.370Z | 2024-11-22T14:19:21.927Z |
5570390 | 5570390 | 20241120193141_b32Gz | UK006L | 2024-11-22T14:15:19.210Z | 2024-11-22T14:19:21.910Z |
5569987 | 5569987 | 20241120182051_SfFxu | UK006L | 2024-11-22T14:14:43.440Z | 2024-11-22T14:19:21.843Z |
5565614 | 5565614 | 20241121042620_vq38K | UK006L | 2024-11-22T14:00:24.821Z | 2024-11-22T14:00:24.821Z |
5565580 | 5565580 | 20241121042334_ZTAtB | UK006L | 2024-11-22T14:00:19.937Z | 2024-11-22T14:00:19.937Z |
5564404 | 5564404 | 20241120025250_gdKlR | UK006L | 2024-11-21T14:17:33.048Z | 2024-11-22T14:21:31.220Z |
5563930 | 5563930 | 20241120021657_hKzAn | UK006L | 2024-11-21T14:16:59.251Z | 2024-11-22T14:21:25.537Z |
5562921 | 5562921 | 20241120002908_94bJo | UK006L | 2024-11-21T14:15:27.663Z | 2024-11-22T14:21:06.127Z |
5562371 | 5562371 | 20241119233131_9Nsyw | UK006L | 2024-11-21T14:14:45.463Z | 2024-11-22T14:20:56.840Z |
5562198 | 5562198 | 20241119230919_uMTyK | UK006L | 2024-11-21T14:14:31.654Z | 2024-11-22T14:20:53.891Z |
5562124 | 5562124 | 20241119230234_b6Dtf | UK006L | 2024-11-21T14:14:27.012Z | 2024-11-22T14:20:53.019Z |
5562078 | 5562078 | 20241119225836_Gb8zI | UK006L | 2024-11-21T14:14:23.585Z | 2024-11-22T14:20:52.447Z |
5552763 | 5552763 | 20241117211547_IICXr | UK006L | 2024-11-19T14:09:08.811Z | 2024-11-22T14:22:46.457Z |
5552708 | 5552708 | 20241117203932_TgbKh | UK006L | 2024-11-19T14:09:00.321Z | 2024-11-22T14:22:45.758Z |
5542057 | 5542057 | 20241114053453_7Fh4X | UK006L | 2024-11-15T14:08:51.613Z | 2024-11-22T14:24:21.918Z |
5542031 | 5542031 | 20241114053107_WRq72 | UK006L | 2024-11-15T14:08:49.061Z | 2024-11-22T14:24:21.851Z |
5541903 | 5541903 | 20241114050544_tnOXZ | UK006L | 2024-11-15T14:08:38.776Z | 2024-11-22T14:24:20.975Z |
5539213 | 5539213 | 20241114055001_1S7Kw | UK006L | 2024-11-15T14:00:22.632Z | 2024-11-22T14:23:42.462Z |
5539004 | 5539004 | 20241113053226_rMAwE | UK006L | 2024-11-14T14:14:08.205Z | 2024-11-21T14:26:31.008Z |
5538961 | 5538961 | 20241113052506_CiYf5 | UK006L | 2024-11-14T14:14:05.661Z | 2024-11-21T14:26:30.491Z |
5538861 | 5538861 | 20241113050542_DbGap | UK006L | 2024-11-14T14:14:00.983Z | 2024-11-21T14:26:29.277Z |
5538732 | 5538732 | 20241113044800_qaj6I | UK006L | 2024-11-14T14:13:53.750Z | 2024-11-21T14:26:28.638Z |
5538715 | 5538715 | 20241113044319_yPZ6F | UK006L | 2024-11-14T14:13:52.681Z | 2024-11-21T14:26:28.570Z |
5538615 | 5538615 | 20241113042233_zF4dm | UK006L | 2024-11-14T14:13:44.045Z | 2024-11-21T14:26:28.184Z |
5538595 | 5538595 | 20241113041713_S2me7 | UK006L | 2024-11-14T14:13:42.406Z | 2024-11-21T14:26:27.429Z |
5531188 | 5531188 | 20241112032051_ktgcI | UK006L | 2024-11-13T14:15:23.157Z | 2024-11-20T14:26:08.504Z |
5529359 | 5529359 | 20241112000642_0QOAy | UK006L | 2024-11-13T14:12:26.902Z | 2024-11-20T14:25:43.329Z |
5527972 | 5527972 | 20241111190849_nxAeH | UK006L | 2024-11-13T14:09:39.175Z | 2024-11-20T14:25:23.736Z |
5527749 | 5527749 | 20241111182803_wiDr2 | UK006L | 2024-11-13T14:09:02.315Z | 2024-11-20T14:25:19.657Z |
5524609 | 5524609 | 20241111044557_gKkPg | UK006L | 2024-11-12T14:17:46.005Z | 2024-11-19T14:22:22.852Z |
5524599 | 5524599 | 20241111044446_6rMFC | UK006L | 2024-11-12T14:17:44.955Z | 2024-11-19T14:22:22.711Z |
5524545 | 5524545 | 20241111043052_yHaSh | UK006L | 2024-11-12T14:17:39.375Z | 2024-11-19T14:22:22.129Z |
5524469 | 5524469 | 20241111041812_Prqwa | UK006L | 2024-11-12T14:17:23.936Z | 2024-11-19T14:22:21.505Z |
5524367 | 5524367 | 20241111040211_YI6x8 | UK006L | 2024-11-12T14:17:10.365Z | 2024-11-19T14:22:20.772Z |
5524342 | 5524342 | 20241111035837_JIi9v | UK006L | 2024-11-12T14:17:04.730Z | 2024-11-19T14:22:20.299Z |
5524277 | 5524277 | 20241111034527_2t6Ao | UK006L | 2024-11-12T14:16:54.053Z | 2024-11-19T14:22:19.677Z |
5523956 | 5523956 | 20241111025407_4R3t7 | UK006L | 2024-11-12T14:16:22.266Z | 2024-11-19T14:22:16.117Z |
5523785 | 5523785 | 20241111022313_pWOLK | UK006L | 2024-11-12T14:16:13.127Z | 2024-11-19T14:22:14.920Z |
5523642 | 5523642 | 20241111015918_YoAja | UK006L | 2024-11-12T14:16:05.456Z | 2024-11-19T14:22:14.031Z |
5523633 | 5523633 | 20241111015817_1WpG3 | UK006L | 2024-11-12T14:16:04.912Z | 2024-11-19T14:22:13.941Z |
5523584 | 5523584 | 20241111014944_gxQtI | UK006L | 2024-11-12T14:16:02.000Z | 2024-11-19T14:22:13.501Z |
5523499 | 5523499 | 20241111013718_JJpxI | UK006L | 2024-11-12T14:15:49.315Z | 2024-11-19T14:22:12.998Z |
5523191 | 5523191 | 20241111002835_8g3FJ | UK006L | 2024-11-12T14:14:57.831Z | 2024-11-19T14:22:10.468Z |
5442571 | 5442571 | 20241030015428_Xhofa | UK006L | 2024-11-01T12:20:02.099Z | 2024-11-07T14:26:47.034Z |
5442504 | 5442504 | 20241030014139_Pyv0T | UK006L | 2024-11-01T12:19:55.520Z | 2024-11-07T14:26:46.829Z |
5442488 | 5442488 | 20241030013755_U2R8w | UK006L | 2024-11-01T12:19:54.006Z | 2024-11-07T14:26:46.732Z |
5442381 | 5442381 | 20241030012250_8Y633 | UK006L | 2024-11-01T12:19:45.362Z | 2024-11-07T14:26:46.472Z |
5442172 | 5442172 | 20241030004725_xcHIm | UK006L | 2024-11-01T12:19:31.791Z | 2024-11-07T14:26:45.252Z |
5441512 | 5441512 | 20241029222823_kOgnn | UK006L | 2024-11-01T12:18:42.200Z | 2024-11-07T14:26:42.543Z |
5441383 | 5441383 | 20241029215808_7ebEv | UK006L | 2024-11-01T12:18:30.881Z | 2024-11-07T14:26:41.973Z |
5441262 | 5441262 | 20241029212256_Vo0R7 | UK006L | 2024-11-01T12:18:21.936Z | 2024-11-07T14:26:41.416Z |
5433649 | 5433649 | 20241029203618_4yN3D | UK006L | 2024-10-31T12:22:26.106Z | 2024-11-07T14:26:40.486Z |
5433621 | 5433621 | 20241029203219_4XbNW | UK006L | 2024-10-31T12:22:24.830Z | 2024-11-07T14:26:40.352Z |
5410735 | 5410735 | 20241027053323_lW3XN | UK006L | 2024-10-29T12:18:03.825Z | 2024-11-04T14:29:05.370Z |
5410313 | 5410313 | 20241027050611_2OoEJ | UK006L | 2024-10-29T12:17:52.897Z | 2024-11-04T14:29:04.327Z |
5410033 | 5410033 | 20241027044841_4kzLR | UK006L | 2024-10-29T12:17:46.303Z | 2024-11-04T14:29:03.620Z |
5409930 | 5409930 | 20241027044239_eUWQD | UK006L | 2024-10-29T12:17:44.176Z | 2024-11-04T14:29:02.941Z |
5409666 | 5409666 | 20241027042959_eyu1f | UK006L | 2024-10-29T12:17:36.363Z | 2024-11-04T14:29:02.061Z |
5409578 | 5409578 | 20241027042713_LUPXj | UK006L | 2024-10-29T12:17:31.751Z | 2024-11-04T14:29:01.964Z |
5409559 | 5409559 | 20241027042427_Knc8I | UK006L | 2024-10-29T12:17:30.271Z | 2024-11-04T14:29:01.954Z |
5409079 | 5409079 | 20241027035918_Ss0G2 | UK006L | 2024-10-29T12:17:05.048Z | 2024-11-04T14:29:01.037Z |
5409022 | 5409022 | 20241027035545_CacHo | UK006L | 2024-10-29T12:17:01.736Z | 2024-11-04T14:29:00.940Z |
5409014 | 5409014 | 20241027035431_D2JLe | UK006L | 2024-10-29T12:17:01.422Z | 2024-11-04T14:29:00.936Z |
5408956 | 5408956 | 20241027035107_0eFoe | UK006L | 2024-10-29T12:16:58.101Z | 2024-11-04T14:29:00.868Z |
5408473 | 5408473 | 20241027032805_oUwqC | UK006L | 2024-10-29T12:16:32.322Z | 2024-11-04T14:28:59.554Z |
5408403 | 5408403 | 20241027032534_834Qh | UK006L | 2024-10-29T12:16:26.787Z | 2024-11-04T14:28:59.321Z |
5407923 | 5407923 | 20241027025823_t2lcI | UK006L | 2024-10-29T12:15:53.598Z | 2024-11-04T14:28:58.412Z |
5407914 | 5407914 | 20241027025819_JBq2F | UK006L | 2024-10-29T12:15:52.334Z | 2024-11-04T14:28:58.350Z |
5407813 | 5407813 | 20241027025321_OXV63 | UK006L | 2024-10-29T12:15:44.351Z | 2024-11-04T14:28:58.170Z |
5406815 | 5406815 | 20241027020020_ATnTy | UK006L | 2024-10-29T12:14:44.361Z | 2024-11-04T14:28:56.464Z |
5403720 | 5403720 | 20241026222438_cNPbV | UK006L | 2024-10-29T12:10:09.578Z | 2024-11-04T14:28:49.519Z |
5403629 | 5403629 | 20241026221838_IxpdU | UK006L | 2024-10-29T12:10:03.126Z | 2024-11-04T14:28:49.363Z |
5403174 | 5403174 | 20241026212537_u5XAq | UK006L | 2024-10-29T12:09:10.195Z | 2024-11-04T14:28:47.923Z |
5402703 | 5402703 | 20241026201529_DEP2K | UK006L | 2024-10-29T12:07:58.721Z | 2024-11-04T14:28:46.257Z |
5402535 | 5402535 | 20241026195313_LVKHv | UK006L | 2024-10-29T12:07:34.956Z | 2024-11-04T14:28:45.114Z |
5402386 | 5402386 | 20241026192525_OezW0 | UK006L | 2024-10-29T12:07:07.723Z | 2024-11-04T14:28:44.171Z |
5402239 | 5402239 | 20241026190525_zPSdF | UK006L | 2024-10-29T12:06:43.391Z | 2024-11-04T14:28:43.326Z |
5402005 | 5402005 | 20241026182338_ydLlA | UK006L | 2024-10-29T12:06:03.309Z | 2024-11-04T14:28:41.538Z |
5401856 | 5401856 | 20241026175055_TH2Ez | UK006L | 2024-10-29T12:05:35.110Z | 2024-11-04T14:28:40.325Z |
5399759 | 5399759 | 20241026045955_jisPN | UK006L | 2024-10-28T12:20:10.386Z | 2024-11-03T14:27:40.420Z |
5399524 | 5399524 | 20241026043137_gyN99 | UK006L | 2024-10-28T12:20:01.528Z | 2024-11-03T14:27:39.924Z |
5399425 | 5399425 | 20241026041809_cA3bD | UK006L | 2024-10-28T12:19:59.420Z | 2024-11-03T14:27:39.701Z |
5399135 | 5399135 | 20241026035622_sp3tt | UK006L | 2024-10-28T12:19:49.755Z | 2024-11-03T14:27:39.117Z |
5399070 | 5399070 | 20241026034824_qfmVA | UK006L | 2024-10-28T12:19:47.164Z | 2024-11-03T14:27:38.960Z |
5399001 | 5399001 | 20241026034411_4L5Kh | UK006L | 2024-10-28T12:19:44.002Z | 2024-11-03T14:27:38.857Z |
5398996 | 5398996 | 20241026034411_0wBnx | UK006L | 2024-10-28T12:19:43.957Z | 2024-11-03T14:27:38.856Z |
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);