participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,869 rows where station_code = "UK0045" 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 |
---|---|---|---|---|---|
5422989 | 5422989 | 20241027013029_R2UDR | UK0045 | 2024-10-30T12:22:38.855Z | 2024-11-04T14:28:55.509Z |
5417696 | 5417696 | 20241027190231_u4h2Z | UK0045 | 2024-10-30T12:14:14.002Z | 2024-11-05T14:27:08.086Z |
5410742 | 5410742 | 20241027053338_M6zDp | UK0045 | 2024-10-29T12:18:04.018Z | 2024-11-04T14:29:05.375Z |
5410521 | 5410521 | 20241027051628_JiLam | UK0045 | 2024-10-29T12:17:57.483Z | 2024-11-04T14:29:04.730Z |
5410473 | 5410473 | 20241027051435_8G2ZC | UK0045 | 2024-10-29T12:17:56.713Z | 2024-11-04T14:29:04.638Z |
5410100 | 5410100 | 20241027045401_25B5I | UK0045 | 2024-10-29T12:17:48.055Z | 2024-11-04T14:29:03.786Z |
5410017 | 5410017 | 20241027044750_J1byC | UK0045 | 2024-10-29T12:17:45.923Z | 2024-11-04T14:29:03.445Z |
5409617 | 5409617 | 20241027042822_BqxLZ | UK0045 | 2024-10-29T12:17:33.873Z | 2024-11-04T14:29:02.017Z |
5409327 | 5409327 | 20241027041115_SFESB | UK0045 | 2024-10-29T12:17:16.723Z | 2024-11-04T14:29:01.584Z |
5409255 | 5409255 | 20241027040735_CKqZO | UK0045 | 2024-10-29T12:17:14.336Z | 2024-11-04T14:29:01.440Z |
5408882 | 5408882 | 20241027034757_LEst2 | UK0045 | 2024-10-29T12:16:55.729Z | 2024-11-04T14:29:00.767Z |
5408850 | 5408850 | 20241027034607_3iyT8 | UK0045 | 2024-10-29T12:16:54.823Z | 2024-11-04T14:29:00.680Z |
5408830 | 5408830 | 20241027034515_XxIix | UK0045 | 2024-10-29T12:16:54.393Z | 2024-11-04T14:29:00.613Z |
5408760 | 5408760 | 20241027034205_8ZCpx | UK0045 | 2024-10-29T12:16:49.206Z | 2024-11-04T14:29:00.463Z |
5408615 | 5408615 | 20241027033232_wxbnM | UK0045 | 2024-10-29T12:16:39.508Z | 2024-11-04T14:28:59.678Z |
5408252 | 5408252 | 20241027031943_YdRX2 | UK0045 | 2024-10-29T12:16:19.995Z | 2024-11-04T14:28:59.037Z |
5408183 | 5408183 | 20241027031414_pK9kX | UK0045 | 2024-10-29T12:16:14.791Z | 2024-11-04T14:28:58.952Z |
5407961 | 5407961 | 20241027030033_2mrzP | UK0045 | 2024-10-29T12:15:55.667Z | 2024-11-04T14:28:58.534Z |
5407947 | 5407947 | 20241027025847_95Suf | UK0045 | 2024-10-29T12:15:54.575Z | 2024-11-04T14:28:58.526Z |
5407745 | 5407745 | 20241027025023_O1W3U | UK0045 | 2024-10-29T12:15:36.986Z | 2024-11-04T14:28:58.092Z |
5407481 | 5407481 | 20241027023845_UqzIV | UK0045 | 2024-10-29T12:15:26.626Z | 2024-11-04T14:28:57.767Z |
5407397 | 5407397 | 20241027023438_s3aUe | UK0045 | 2024-10-29T12:15:23.661Z | 2024-11-04T14:28:57.489Z |
5406989 | 5406989 | 20241027021551_326ji | UK0045 | 2024-10-29T12:15:06.048Z | 2024-11-04T14:28:56.759Z |
5406798 | 5406798 | 20241027020000_RsDrd | UK0045 | 2024-10-29T12:14:43.350Z | 2024-11-04T14:28:56.400Z |
5406608 | 5406608 | 20241027014745_gYKFl | UK0045 | 2024-10-29T12:14:24.107Z | 2024-11-04T14:28:55.909Z |
5406571 | 5406571 | 20241027014608_S6zYW | UK0045 | 2024-10-29T12:14:22.328Z | 2024-11-04T14:28:55.884Z |
5406452 | 5406452 | 20241027013824_kkpkl | UK0045 | 2024-10-29T12:14:10.696Z | 2024-11-04T14:28:55.715Z |
5406121 | 5406121 | 20241027011754_A24cT | UK0045 | 2024-10-29T12:13:52.832Z | 2024-11-04T14:28:55.149Z |
5405589 | 5405589 | 20241027004711_mp5yq | UK0045 | 2024-10-29T12:13:03.710Z | 2024-11-04T14:28:53.648Z |
5405348 | 5405348 | 20241027002923_N3J0M | UK0045 | 2024-10-29T12:12:50.675Z | 2024-11-04T14:28:53.318Z |
5405345 | 5405345 | 20241027002923_pvn6Y | UK0045 | 2024-10-29T12:12:50.509Z | 2024-11-04T14:28:53.313Z |
5404889 | 5404889 | 20241026235904_JgdKl | UK0045 | 2024-10-29T12:12:05.493Z | 2024-11-04T14:28:52.372Z |
5404507 | 5404507 | 20241026233229_n25yi | UK0045 | 2024-10-29T12:11:38.849Z | 2024-11-04T14:28:51.271Z |
5403005 | 5403005 | 20241026210152_4Davd | UK0045 | 2024-10-29T12:08:44.141Z | 2024-11-04T14:28:47.346Z |
5398498 | 5398498 | 20241026030319_Mlyo6 | UK0045 | 2024-10-28T12:19:20.051Z | 2024-11-03T14:27:36.615Z |
5397650 | 5397650 | 20241026014543_c6IEs | UK0045 | 2024-10-28T12:18:31.034Z | 2024-11-03T14:27:33.666Z |
5397395 | 5397395 | 20241026012513_qNFwW | UK0045 | 2024-10-28T12:18:19.510Z | 2024-11-03T14:27:32.774Z |
5397038 | 5397038 | 20241026005836_gvWzk | UK0045 | 2024-10-28T12:18:04.295Z | 2024-11-03T14:27:31.946Z |
5396994 | 5396994 | 20241026005514_5o4vq | UK0045 | 2024-10-28T12:18:01.791Z | 2024-11-03T14:27:31.659Z |
5396921 | 5396921 | 20241026004645_A43DX | UK0045 | 2024-10-28T12:17:59.516Z | 2024-11-03T14:27:31.342Z |
5396690 | 5396690 | 20241026002254_lZXQk | UK0045 | 2024-10-28T12:17:53.273Z | 2024-11-03T14:27:30.695Z |
5396652 | 5396652 | 20241026001954_3IKcj | UK0045 | 2024-10-28T12:17:52.154Z | 2024-11-03T14:27:30.546Z |
5396609 | 5396609 | 20241026001645_6L32Y | UK0045 | 2024-10-28T12:17:51.080Z | 2024-11-03T14:27:30.448Z |
5393572 | 5393572 | 20241025181330_UkDFQ | UK0045 | 2024-10-28T12:12:47.878Z | 2024-11-03T14:27:16.366Z |
5386454 | 5386454 | 20241025004454_Wl1NR | UK0045 | 2024-10-27T12:20:05.804Z | 2024-11-02T12:28:31.260Z |
5386345 | 5386345 | 20241025002759_mOXIH | UK0045 | 2024-10-27T12:20:00.978Z | 2024-11-02T12:28:31.104Z |
5386176 | 5386176 | 20241025001148_jxwvP | UK0045 | 2024-10-27T12:19:54.033Z | 2024-11-02T12:28:30.825Z |
5385949 | 5385949 | 20241024234617_bINre | UK0045 | 2024-10-27T12:19:39.465Z | 2024-11-02T12:28:30.517Z |
5378018 | 5378018 | 20241024052400_4aHkL | UK0045 | 2024-10-26T12:22:52.883Z | 2024-11-01T12:27:03.228Z |
5377982 | 5377982 | 20241024052142_IQBWk | UK0045 | 2024-10-26T12:22:51.580Z | 2024-11-01T12:27:03.212Z |
5377759 | 5377759 | 20241024050757_s0IkZ | UK0045 | 2024-10-26T12:22:46.430Z | 2024-11-01T12:27:02.774Z |
5376867 | 5376867 | 20241024042013_nqbi4 | UK0045 | 2024-10-26T12:22:15.230Z | 2024-11-01T12:27:01.902Z |
5376710 | 5376710 | 20241024040959_bqUzU | UK0045 | 2024-10-26T12:22:11.000Z | 2024-11-01T12:27:01.748Z |
5376696 | 5376696 | 20241024040930_urofi | UK0045 | 2024-10-26T12:22:10.624Z | 2024-11-01T12:27:01.745Z |
5376626 | 5376626 | 20241024040541_3ZABv | UK0045 | 2024-10-26T12:22:07.550Z | 2024-11-01T12:27:01.623Z |
5376248 | 5376248 | 20241024034727_LY5cB | UK0045 | 2024-10-26T12:21:54.953Z | 2024-11-01T12:27:01.473Z |
5374685 | 5374685 | 20241024024006_E0CVW | UK0045 | 2024-10-26T12:20:56.830Z | 2024-11-01T12:26:59.533Z |
5374618 | 5374618 | 20241024023706_Jeq2M | UK0045 | 2024-10-26T12:20:54.836Z | 2024-11-01T12:26:59.520Z |
5373783 | 5373783 | 20241024015354_yHnOi | UK0045 | 2024-10-26T12:20:25.618Z | 2024-11-01T12:26:58.476Z |
5372658 | 5372658 | 20241024010056_3W6y7 | UK0045 | 2024-10-26T12:19:36.745Z | 2024-11-01T12:26:57.801Z |
5372553 | 5372553 | 20241024005415_mF60X | UK0045 | 2024-10-26T12:19:30.238Z | 2024-11-01T12:26:57.513Z |
5372471 | 5372471 | 20241024004937_phqqG | UK0045 | 2024-10-26T12:19:25.961Z | 2024-11-01T12:26:57.473Z |
5372216 | 5372216 | 20241024003900_yq8BJ | UK0045 | 2024-10-26T12:19:15.121Z | 2024-11-01T12:26:57.312Z |
5366429 | 5366429 | 20241024002026_if98W | UK0045 | 2024-10-25T12:18:26.369Z | 2024-11-01T12:26:56.957Z |
5366197 | 5366197 | 20241024000900_YpNEG | UK0045 | 2024-10-25T12:18:18.856Z | 2024-11-01T12:26:56.791Z |
5365916 | 5365916 | 20241023235639_bgCkf | UK0045 | 2024-10-25T12:18:10.443Z | 2024-11-01T12:26:56.487Z |
5364384 | 5364384 | 20241023222427_7mnoX | UK0045 | 2024-10-25T12:17:19.063Z | 2024-11-01T12:26:55.029Z |
5364366 | 5364366 | 20241023222339_Sua7D | UK0045 | 2024-10-25T12:17:18.533Z | 2024-11-01T12:26:55.020Z |
5364313 | 5364313 | 20241023222009_IJBID | UK0045 | 2024-10-25T12:17:16.507Z | 2024-11-01T12:26:54.667Z |
5362854 | 5362854 | 20241023200554_KgJYB | UK0045 | 2024-10-25T12:15:13.448Z | 2024-11-01T12:26:52.480Z |
5351281 | 5351281 | 20241022231317_q2SOj | UK0045 | 2024-10-24T12:17:23.894Z | 2024-10-31T12:29:59.742Z |
5351190 | 5351190 | 20241022230417_MRsFm | UK0045 | 2024-10-24T12:17:19.264Z | 2024-10-31T12:29:59.593Z |
5351124 | 5351124 | 20241022230002_rSyLQ | UK0045 | 2024-10-24T12:17:14.677Z | 2024-10-31T12:29:59.515Z |
5349641 | 5349641 | 20241022201833_m0LEd | UK0045 | 2024-10-24T12:14:18.721Z | 2024-10-31T12:29:55.931Z |
5344607 | 5344607 | 20241022043411_Zv5Vq | UK0045 | 2024-10-23T12:18:43.081Z | 2024-10-30T12:26:51.399Z |
5344544 | 5344544 | 20241022043133_gp8du | UK0045 | 2024-10-23T12:18:40.991Z | 2024-10-30T12:26:51.356Z |
5344509 | 5344509 | 20241022042825_zbr22 | UK0045 | 2024-10-23T12:18:40.083Z | 2024-10-30T12:26:51.299Z |
5344344 | 5344344 | 20241022041607_KcEH0 | UK0045 | 2024-10-23T12:18:32.799Z | 2024-10-30T12:26:51.190Z |
5344142 | 5344142 | 20241022040800_dwW6I | UK0045 | 2024-10-23T12:18:26.186Z | 2024-10-30T12:26:50.962Z |
5343394 | 5343394 | 20241022032650_y8e5R | UK0045 | 2024-10-23T12:17:45.571Z | 2024-10-30T12:26:49.996Z |
5343022 | 5343022 | 20241022030111_MMzed | UK0045 | 2024-10-23T12:17:32.298Z | 2024-10-30T12:26:49.154Z |
5342718 | 5342718 | 20241022024158_jGcX7 | UK0045 | 2024-10-23T12:17:17.225Z | 2024-10-30T12:26:48.841Z |
5341906 | 5341906 | 20241022015842_r270I | UK0045 | 2024-10-23T12:16:20.572Z | 2024-10-30T12:26:47.693Z |
5341851 | 5341851 | 20241022015601_mYorb | UK0045 | 2024-10-23T12:16:17.713Z | 2024-10-30T12:26:47.571Z |
5341846 | 5341846 | 20241022015601_Jipfe | UK0045 | 2024-10-23T12:16:17.677Z | 2024-10-30T12:26:47.568Z |
5341444 | 5341444 | 20241022013554_8YDqK | UK0045 | 2024-10-23T12:15:50.607Z | 2024-10-30T12:26:47.032Z |
5341137 | 5341137 | 20241022011652_g1Sm3 | UK0045 | 2024-10-23T12:15:24.349Z | 2024-10-30T12:26:46.632Z |
5340921 | 5340921 | 20241022010100_5y9Da | UK0045 | 2024-10-23T12:15:03.208Z | 2024-10-30T12:26:46.353Z |
5340330 | 5340330 | 20241022000531_qTXo3 | UK0045 | 2024-10-23T12:14:28.806Z | 2024-10-30T12:26:45.688Z |
5340050 | 5340050 | 20241021233957_JAHCi | UK0045 | 2024-10-23T12:14:15.983Z | 2024-10-30T12:26:45.326Z |
5339873 | 5339873 | 20241021232544_2ovKU | UK0045 | 2024-10-23T12:13:59.095Z | 2024-10-30T12:26:45.026Z |
5339813 | 5339813 | 20241021231805_8Qf4X | UK0045 | 2024-10-23T12:13:53.170Z | 2024-10-30T12:26:44.957Z |
5339693 | 5339693 | 20241021230537_TqGBi | UK0045 | 2024-10-23T12:13:34.971Z | 2024-10-30T12:26:44.777Z |
5339644 | 5339644 | 20241021230112_TzP20 | UK0045 | 2024-10-23T12:13:28.700Z | 2024-10-30T12:26:44.680Z |
5339552 | 5339552 | 20241021225315_S1N07 | UK0045 | 2024-10-23T12:13:18.545Z | 2024-10-30T12:26:44.431Z |
5338548 | 5338548 | 20241021195527_9uzdQ | UK0045 | 2024-10-23T12:11:21.773Z | 2024-10-30T12:26:42.465Z |
5323020 | 5323020 | 20241018181908_xL5iB | UK0045 | 2024-10-20T12:04:45.661Z | 2024-10-27T12:28:48.966Z |
5303899 | 5303899 | 20241013034656_ouv7G | UK0045 | 2024-10-14T12:17:37.276Z | 2024-10-21T12:24:21.819Z |
5303628 | 5303628 | 20241013031851_XtUTp | UK0045 | 2024-10-14T12:17:30.408Z | 2024-10-21T12:24:19.043Z |
5302822 | 5302822 | 20241013014850_gA2Ct | UK0045 | 2024-10-14T12:16:49.813Z | 2024-10-21T12:24:13.338Z |
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);