participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,707 rows where station_code = "UK002R" 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 |
---|---|---|---|---|---|
2259897 | 2259897 | 20230205060141_pi3ED | UK002R | 2024-01-05T23:55:01.421Z | 2024-01-05T23:55:01.421Z |
2259350 | 2259350 | 20230205014440_ui4G3 | UK002R | 2024-01-05T23:55:01.375Z | 2024-01-05T23:55:01.375Z |
2259279 | 2259279 | 20230205001634_12Hvd | UK002R | 2024-01-05T23:55:01.367Z | 2024-01-05T23:55:01.367Z |
2249275 | 2249275 | 20230130061627_fL3ir | UK002R | 2024-01-05T23:54:50.551Z | 2024-01-05T23:54:50.551Z |
2249196 | 2249196 | 20230130060539_OWIkp | UK002R | 2024-01-05T23:54:50.544Z | 2024-01-05T23:54:50.544Z |
2249126 | 2249126 | 20230130055352_KhYvp | UK002R | 2024-01-05T23:54:50.537Z | 2024-01-05T23:54:50.537Z |
2235407 | 2235407 | 20230126045824_uB38c | UK002R | 2024-01-05T23:54:43.799Z | 2024-01-05T23:54:43.799Z |
2235392 | 2235392 | 20230126045725_3ScKa | UK002R | 2024-01-05T23:54:43.796Z | 2024-01-05T23:54:43.796Z |
2235328 | 2235328 | 20230126044537_QAYSh | UK002R | 2024-01-05T23:54:43.784Z | 2024-01-05T23:54:43.784Z |
2235323 | 2235323 | 20230126044532_GjpdB | UK002R | 2024-01-05T23:54:43.783Z | 2024-01-05T23:54:43.783Z |
2235256 | 2235256 | 20230126043515_5KLik | UK002R | 2024-01-05T23:54:43.773Z | 2024-01-05T23:54:43.773Z |
2233352 | 2233352 | 20230125184202_tnSTk | UK002R | 2024-01-05T23:54:43.400Z | 2024-01-05T23:54:43.400Z |
2228569 | 2228569 | 20230124044520_ZgLf2 | UK002R | 2024-01-05T23:54:39.065Z | 2024-01-05T23:54:39.065Z |
2228337 | 2228337 | 20230124040614_adSzZ | UK002R | 2024-01-05T23:54:38.930Z | 2024-01-05T23:54:38.930Z |
2228148 | 2228148 | 20230124032618_lwl2I | UK002R | 2024-01-05T23:54:38.878Z | 2024-01-05T23:54:38.878Z |
2228087 | 2228087 | 20230124030650_GSq3p | UK002R | 2024-01-05T23:54:38.859Z | 2024-01-05T23:54:38.859Z |
2227993 | 2227993 | 20230124024620_JXVDG | UK002R | 2024-01-05T23:54:38.714Z | 2024-01-05T23:54:38.714Z |
2227736 | 2227736 | 20230124012718_78avV | UK002R | 2024-01-05T23:54:38.576Z | 2024-01-05T23:54:38.576Z |
2227732 | 2227732 | 20230124012535_jVsSo | UK002R | 2024-01-05T23:54:38.575Z | 2024-01-05T23:54:38.575Z |
2226702 | 2226702 | 20230123175626_IqCwR | UK002R | 2024-01-05T23:54:38.106Z | 2024-01-05T23:54:38.106Z |
2219406 | 2219406 | 20230121054727_lVeP3 | UK002R | 2024-01-05T23:54:31.707Z | 2024-01-05T23:54:31.707Z |
2219199 | 2219199 | 20230121052557_NsMGm | UK002R | 2024-01-05T23:54:31.617Z | 2024-01-05T23:54:31.617Z |
2202184 | 2202184 | 20230117211829_7bw5y | UK002R | 2024-01-05T23:54:21.817Z | 2024-01-05T23:54:21.817Z |
2200823 | 2200823 | 20230117050444_NAulX | UK002R | 2024-01-05T23:54:20.501Z | 2024-01-05T23:54:20.501Z |
2200721 | 2200721 | 20230117045053_OR3WE | UK002R | 2024-01-05T23:54:20.493Z | 2024-01-05T23:54:20.493Z |
2200642 | 2200642 | 20230117043304_ZzFAO | UK002R | 2024-01-05T23:54:20.485Z | 2024-01-05T23:54:20.485Z |
2196453 | 2196453 | 20230115030020_ijk6l | UK002R | 2024-01-05T23:54:17.732Z | 2024-01-05T23:54:17.732Z |
2191578 | 2191578 | 20230112184052_2R125 | UK002R | 2024-01-05T23:54:13.812Z | 2024-01-05T23:54:13.812Z |
2189228 | 2189228 | 20230111060800_4TlpM | UK002R | 2024-01-05T23:54:12.426Z | 2024-01-05T23:54:12.426Z |
2189002 | 2189002 | 20230111042936_FfF0S | UK002R | 2024-01-05T23:54:12.404Z | 2024-01-05T23:54:12.404Z |
2188914 | 2188914 | 20230111035823_hYQBQ | UK002R | 2024-01-05T23:54:12.395Z | 2024-01-05T23:54:12.395Z |
2188893 | 2188893 | 20230111035525_Gtxj0 | UK002R | 2024-01-05T23:54:12.394Z | 2024-01-05T23:54:12.394Z |
2188837 | 2188837 | 20230111033857_wmAwc | UK002R | 2024-01-05T23:54:12.388Z | 2024-01-05T23:54:12.388Z |
2188198 | 2188198 | 20230110235618_Hg7m8 | UK002R | 2024-01-05T23:54:12.321Z | 2024-01-05T23:54:12.321Z |
2186790 | 2186790 | 20230109175220_9f91W | UK002R | 2024-01-05T23:54:09.889Z | 2024-01-05T23:54:09.889Z |
2185671 | 2185671 | 20230109030845_9adP1 | UK002R | 2024-01-05T23:54:09.769Z | 2024-01-05T23:54:09.769Z |
2179843 | 2179843 | 20230104054415_u2AjS | UK002R | 2024-01-05T23:54:03.341Z | 2024-01-05T23:54:03.341Z |
2179744 | 2179744 | 20230104052536_qO3Vw | UK002R | 2024-01-05T23:54:03.329Z | 2024-01-05T23:54:03.329Z |
2179699 | 2179699 | 20230104051805_fvAj5 | UK002R | 2024-01-05T23:54:03.323Z | 2024-01-05T23:54:03.323Z |
2179416 | 2179416 | 20230104041047_wNknG | UK002R | 2024-01-05T23:54:03.283Z | 2024-01-05T23:54:03.283Z |
2178341 | 2178341 | 20230102184304_I3wMg | UK002R | 2024-01-05T23:54:01.986Z | 2024-01-05T23:54:01.986Z |
2177559 | 2177559 | 20230102062839_8yyng | UK002R | 2024-01-05T23:54:01.896Z | 2024-01-05T23:54:01.896Z |
2177451 | 2177451 | 20230102060925_tpKaz | UK002R | 2024-01-05T23:54:01.887Z | 2024-01-05T23:54:01.887Z |
2177415 | 2177415 | 20230102060138_7qNOq | UK002R | 2024-01-05T23:54:01.883Z | 2024-01-05T23:54:01.883Z |
2177094 | 2177094 | 20230102050812_pSxiq | UK002R | 2024-01-05T23:54:01.855Z | 2024-01-05T23:54:01.855Z |
2174742 | 2174742 | 20230101043337_8crWl | UK002R | 2024-01-05T23:54:00.445Z | 2024-01-05T23:54:00.445Z |
2174064 | 2174064 | 20221231233240_E2Tp6 | UK002R | 2024-01-05T23:53:59.231Z | 2024-01-05T23:53:59.231Z |
2169051 | 2169051 | 20221229040651_rJw25 | UK002R | 2024-01-05T23:53:56.358Z | 2024-01-05T23:53:56.358Z |
2164229 | 2164229 | 20221227034340_AfUuY | UK002R | 2024-01-05T23:53:53.440Z | 2024-01-05T23:53:53.440Z |
2158323 | 2158323 | 20221226070023_9RKpV | UK002R | 2024-01-05T23:53:51.737Z | 2024-01-05T23:53:51.737Z |
2158242 | 2158242 | 20221226065035_2SU3B | UK002R | 2024-01-05T23:53:51.730Z | 2024-01-05T23:53:51.730Z |
2157965 | 2157965 | 20221226062319_nksFu | UK002R | 2024-01-05T23:53:51.710Z | 2024-01-05T23:53:51.710Z |
2157891 | 2157891 | 20221226061556_nAJI1 | UK002R | 2024-01-05T23:53:51.703Z | 2024-01-05T23:53:51.703Z |
2157228 | 2157228 | 20221226050927_RZw5z | UK002R | 2024-01-05T23:53:51.647Z | 2024-01-05T23:53:51.647Z |
2156313 | 2156313 | 20221226032630_hwlRE | UK002R | 2024-01-05T23:53:51.565Z | 2024-01-05T23:53:51.565Z |
2152254 | 2152254 | 20221225030754_r9yfS | UK002R | 2024-01-05T23:53:48.632Z | 2024-01-05T23:53:48.632Z |
2152202 | 2152202 | 20221225025559_47Zu2 | UK002R | 2024-01-05T23:53:48.625Z | 2024-01-05T23:53:48.625Z |
2152069 | 2152069 | 20221225023131_hf6Rw | UK002R | 2024-01-05T23:53:48.610Z | 2024-01-05T23:53:48.610Z |
2148222 | 2148222 | 20221224064203_G4xpl | UK002R | 2024-01-05T23:53:48.205Z | 2024-01-05T23:53:48.205Z |
2148196 | 2148196 | 20221224064027_vFdXr | UK002R | 2024-01-05T23:53:48.204Z | 2024-01-05T23:53:48.204Z |
2148056 | 2148056 | 20221224062057_6SCBp | UK002R | 2024-01-05T23:53:48.193Z | 2024-01-05T23:53:48.193Z |
2147711 | 2147711 | 20221224054010_y0ORQ | UK002R | 2024-01-05T23:53:48.164Z | 2024-01-05T23:53:48.164Z |
2147149 | 2147149 | 20221224043453_ApTVc | UK002R | 2024-01-05T23:53:48.123Z | 2024-01-05T23:53:48.123Z |
2146960 | 2146960 | 20221224041212_tBrRe | UK002R | 2024-01-05T23:53:46.879Z | 2024-01-05T23:53:46.879Z |
2146861 | 2146861 | 20221224040217_BCu6x | UK002R | 2024-01-05T23:53:46.873Z | 2024-01-05T23:53:46.873Z |
2146791 | 2146791 | 20221224035618_79BgY | UK002R | 2024-01-05T23:53:46.867Z | 2024-01-05T23:53:46.867Z |
2146301 | 2146301 | 20221224024639_Nzgyc | UK002R | 2024-01-05T23:53:46.834Z | 2024-01-05T23:53:46.834Z |
2145947 | 2145947 | 20221224012707_LrSzn | UK002R | 2024-01-05T23:53:46.805Z | 2024-01-05T23:53:46.805Z |
2140282 | 2140282 | 20221222043624_iUGhM | UK002R | 2024-01-05T23:53:43.363Z | 2024-01-05T23:53:43.363Z |
2139839 | 2139839 | 20221222031610_FPuDv | UK002R | 2024-01-05T23:53:43.317Z | 2024-01-05T23:53:43.317Z |
2133981 | 2133981 | 20221220070254_0s206 | UK002R | 2024-01-05T23:53:41.485Z | 2024-01-05T23:53:41.485Z |
2133784 | 2133784 | 20221220062711_5pQPL | UK002R | 2024-01-05T23:53:41.465Z | 2024-01-05T23:53:41.465Z |
2133725 | 2133725 | 20221220061537_rQOai | UK002R | 2024-01-05T23:53:41.460Z | 2024-01-05T23:53:41.460Z |
2133263 | 2133263 | 20221220041625_2Yh7H | UK002R | 2024-01-05T23:53:40.218Z | 2024-01-05T23:53:40.218Z |
2120962 | 2120962 | 20221217040110_245tn | UK002R | 2024-01-05T23:53:35.023Z | 2024-01-05T23:53:35.023Z |
2120871 | 2120871 | 20221217033949_tZ5DY | UK002R | 2024-01-05T23:53:35.013Z | 2024-01-05T23:53:35.013Z |
2120745 | 2120745 | 20221217031318_AYtWp | UK002R | 2024-01-05T23:53:35.000Z | 2024-01-05T23:53:35.000Z |
2116618 | 2116618 | 20221216070329_HugtI | UK002R | 2024-01-05T23:53:33.261Z | 2024-01-05T23:53:33.261Z |
2116406 | 2116406 | 20221216064136_a2DB5 | UK002R | 2024-01-05T23:53:33.244Z | 2024-01-05T23:53:33.244Z |
2116263 | 2116263 | 20221216062211_0Mv85 | UK002R | 2024-01-05T23:53:33.234Z | 2024-01-05T23:53:33.234Z |
2116229 | 2116229 | 20221216061755_WOmxh | UK002R | 2024-01-05T23:53:33.231Z | 2024-01-05T23:53:33.231Z |
2115826 | 2115826 | 20221216053754_ii620 | UK002R | 2024-01-05T23:53:33.198Z | 2024-01-05T23:53:33.198Z |
2115743 | 2115743 | 20221216052253_vicMa | UK002R | 2024-01-05T23:53:33.189Z | 2024-01-05T23:53:33.189Z |
2115713 | 2115713 | 20221216052025_LKAv3 | UK002R | 2024-01-05T23:53:33.187Z | 2024-01-05T23:53:33.187Z |
2115612 | 2115612 | 20221216051433_gvGMb | UK002R | 2024-01-05T23:53:33.123Z | 2024-01-05T23:53:33.123Z |
2115401 | 2115401 | 20221216045108_o3JyK | UK002R | 2024-01-05T23:53:33.106Z | 2024-01-05T23:53:33.106Z |
2115374 | 2115374 | 20221216044553_fnASG | UK002R | 2024-01-05T23:53:33.103Z | 2024-01-05T23:53:33.103Z |
2115303 | 2115303 | 20221216044126_VdIrn | UK002R | 2024-01-05T23:53:33.098Z | 2024-01-05T23:53:33.098Z |
2115223 | 2115223 | 20221216043737_iqP9K | UK002R | 2024-01-05T23:53:33.093Z | 2024-01-05T23:53:33.093Z |
2115187 | 2115187 | 20221216043233_oGdam | UK002R | 2024-01-05T23:53:33.090Z | 2024-01-05T23:53:33.090Z |
2115084 | 2115084 | 20221216042802_sjvJy | UK002R | 2024-01-05T23:53:33.083Z | 2024-01-05T23:53:33.083Z |
2114906 | 2114906 | 20221216041337_WiKAk | UK002R | 2024-01-05T23:53:33.069Z | 2024-01-05T23:53:33.069Z |
2114731 | 2114731 | 20221216040041_NLJ2M | UK002R | 2024-01-05T23:53:33.057Z | 2024-01-05T23:53:33.057Z |
2114721 | 2114721 | 20221216040025_02wMD | UK002R | 2024-01-05T23:53:33.056Z | 2024-01-05T23:53:33.056Z |
2114240 | 2114240 | 20221216032427_nNEaV | UK002R | 2024-01-05T23:53:33.021Z | 2024-01-05T23:53:33.021Z |
2113236 | 2113236 | 20221216020019_hTFfj | UK002R | 2024-01-05T23:53:32.944Z | 2024-01-05T23:53:32.944Z |
2109569 | 2109569 | 20221215181621_PjJz9 | UK002R | 2024-01-05T23:53:32.648Z | 2024-01-05T23:53:32.648Z |
2109522 | 2109522 | 20221215181115_CKLkF | UK002R | 2024-01-05T23:53:32.644Z | 2024-01-05T23:53:32.644Z |
2105699 | 2105699 | 20221215065958_ZMivn | UK002R | 2024-01-05T23:53:30.904Z | 2024-01-05T23:53:30.904Z |
2105466 | 2105466 | 20221215064508_w2oAr | UK002R | 2024-01-05T23:53:30.883Z | 2024-01-05T23:53:30.883Z |
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);