participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,082 rows where station_code = "UK005F" 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 |
---|---|---|---|---|---|
1649992 | 1649992 | 20220911011635_bs8ea | UK005F | 2024-01-05T23:50:03.279Z | 2024-01-05T23:50:03.279Z |
1649691 | 1649691 | 20220910224002_uZuj2 | UK005F | 2024-01-05T23:50:03.244Z | 2024-01-05T23:50:03.244Z |
1649385 | 1649385 | 20220910194230_qo23n | UK005F | 2024-01-05T23:50:03.214Z | 2024-01-05T23:50:03.214Z |
1649123 | 1649123 | 20220910022121_Pxhs0 | UK005F | 2024-01-05T23:50:03.179Z | 2024-01-05T23:50:03.179Z |
1649101 | 1649101 | 20220910021005_d2oPx | UK005F | 2024-01-05T23:50:03.177Z | 2024-01-05T23:50:03.177Z |
1649015 | 1649015 | 20220910011304_7vgvm | UK005F | 2024-01-05T23:50:03.168Z | 2024-01-05T23:50:03.168Z |
1649004 | 1649004 | 20220910010413_5arUO | UK005F | 2024-01-05T23:50:03.167Z | 2024-01-05T23:50:03.167Z |
1648942 | 1648942 | 20220910002151_kSCBF | UK005F | 2024-01-05T23:50:01.959Z | 2024-01-05T23:50:01.959Z |
1648903 | 1648903 | 20220909235311_8Zs7l | UK005F | 2024-01-05T23:50:01.953Z | 2024-01-05T23:50:01.953Z |
1648888 | 1648888 | 20220909233702_OD2CH | UK005F | 2024-01-05T23:50:01.952Z | 2024-01-05T23:50:01.952Z |
1645028 | 1645028 | 20220907040229_VNvLc | UK005F | 2024-01-05T23:49:59.127Z | 2024-01-05T23:49:59.127Z |
1645011 | 1645011 | 20220907035810_FEl6c | UK005F | 2024-01-05T23:49:59.126Z | 2024-01-05T23:49:59.126Z |
1645000 | 1645000 | 20220907035342_AJnn2 | UK005F | 2024-01-05T23:49:59.124Z | 2024-01-05T23:49:59.124Z |
1644988 | 1644988 | 20220907035257_7xMXT | UK005F | 2024-01-05T23:49:59.123Z | 2024-01-05T23:49:59.123Z |
1644996 | 1644996 | 20220907035337_YEv4y | UK005F | 2024-01-05T23:49:59.123Z | 2024-01-05T23:49:59.123Z |
1644887 | 1644887 | 20220907032408_ZQpIF | UK005F | 2024-01-05T23:49:59.109Z | 2024-01-05T23:49:59.109Z |
1644809 | 1644809 | 20220907030617_nc7HL | UK005F | 2024-01-05T23:49:59.099Z | 2024-01-05T23:49:59.099Z |
1644662 | 1644662 | 20220907023927_6eNt2 | UK005F | 2024-01-05T23:49:59.081Z | 2024-01-05T23:49:59.081Z |
1644454 | 1644454 | 20220907015725_qP83o | UK005F | 2024-01-05T23:49:59.058Z | 2024-01-05T23:49:59.058Z |
1644260 | 1644260 | 20220907012244_m90W7 | UK005F | 2024-01-05T23:49:59.036Z | 2024-01-05T23:49:59.036Z |
1644041 | 1644041 | 20220907004210_M5zVI | UK005F | 2024-01-05T23:49:59.010Z | 2024-01-05T23:49:59.010Z |
1643989 | 1643989 | 20220907002545_MrOMb | UK005F | 2024-01-05T23:49:59.003Z | 2024-01-05T23:49:59.003Z |
1643937 | 1643937 | 20220907001135_6lM3M | UK005F | 2024-01-05T23:49:58.996Z | 2024-01-05T23:49:58.996Z |
1643830 | 1643830 | 20220906232929_UDaPY | UK005F | 2024-01-05T23:49:58.982Z | 2024-01-05T23:49:58.982Z |
1643692 | 1643692 | 20220906222519_7V0aY | UK005F | 2024-01-05T23:49:57.638Z | 2024-01-05T23:49:57.638Z |
1643662 | 1643662 | 20220906215444_WXMgR | UK005F | 2024-01-05T23:49:57.629Z | 2024-01-05T23:49:57.629Z |
1643556 | 1643556 | 20220906210557_S6Il2 | UK005F | 2024-01-05T23:49:57.604Z | 2024-01-05T23:49:57.604Z |
1643549 | 1643549 | 20220906210349_khUMT | UK005F | 2024-01-05T23:49:57.603Z | 2024-01-05T23:49:57.603Z |
1643536 | 1643536 | 20220906205814_IaPXv | UK005F | 2024-01-05T23:49:57.600Z | 2024-01-05T23:49:57.600Z |
1643526 | 1643526 | 20220906204406_4DCKe | UK005F | 2024-01-05T23:49:57.599Z | 2024-01-05T23:49:57.599Z |
1641746 | 1641746 | 20220906035625_4hm9A | UK005F | 2024-01-05T23:49:57.192Z | 2024-01-05T23:49:57.192Z |
1641724 | 1641724 | 20220906035307_ZRVKu | UK005F | 2024-01-05T23:49:57.188Z | 2024-01-05T23:49:57.188Z |
1641650 | 1641650 | 20220906034456_xff3G | UK005F | 2024-01-05T23:49:57.176Z | 2024-01-05T23:49:57.176Z |
1641524 | 1641524 | 20220906032640_W1n9C | UK005F | 2024-01-05T23:49:57.149Z | 2024-01-05T23:49:57.149Z |
1641202 | 1641202 | 20220906024009_D9D2E | UK005F | 2024-01-05T23:49:57.077Z | 2024-01-05T23:49:57.077Z |
1641181 | 1641181 | 20220906023848_fDb2I | UK005F | 2024-01-05T23:49:57.074Z | 2024-01-05T23:49:57.074Z |
1640983 | 1640983 | 20220906020449_i0qWE | UK005F | 2024-01-05T23:49:57.027Z | 2024-01-05T23:49:57.027Z |
1640945 | 1640945 | 20220906015857_4GDMg | UK005F | 2024-01-05T23:49:57.018Z | 2024-01-05T23:49:57.018Z |
1635982 | 1635982 | 20220904223438_zW3qh | UK005F | 2024-01-05T23:49:53.690Z | 2024-01-05T23:49:53.690Z |
1633623 | 1633623 | 20220904005946_SJ0WV | UK005F | 2024-01-05T23:49:51.465Z | 2024-01-05T23:49:51.465Z |
1630859 | 1630859 | 20220903020619_qe8aE | UK005F | 2024-01-05T23:49:49.786Z | 2024-01-05T23:49:49.786Z |
1630814 | 1630814 | 20220903015753_ZWddy | UK005F | 2024-01-05T23:49:49.781Z | 2024-01-05T23:49:49.781Z |
1630596 | 1630596 | 20220903011414_FcgCx | UK005F | 2024-01-05T23:49:49.753Z | 2024-01-05T23:49:49.753Z |
1630497 | 1630497 | 20220903004916_GCbWt | UK005F | 2024-01-05T23:49:49.739Z | 2024-01-05T23:49:49.739Z |
1630488 | 1630488 | 20220903004750_idvYR | UK005F | 2024-01-05T23:49:49.737Z | 2024-01-05T23:49:49.737Z |
1630291 | 1630291 | 20220902235154_jbPLs | UK005F | 2024-01-05T23:49:49.712Z | 2024-01-05T23:49:49.712Z |
1626998 | 1626998 | 20220902015051_Oqc6a | UK005F | 2024-01-05T23:49:47.983Z | 2024-01-05T23:49:47.983Z |
1619306 | 1619306 | 20220831040032_mAv5y | UK005F | 2024-01-05T23:49:44.396Z | 2024-01-05T23:49:44.396Z |
1619230 | 1619230 | 20220831034912_KGfop | UK005F | 2024-01-05T23:49:44.374Z | 2024-01-05T23:49:44.374Z |
1619141 | 1619141 | 20220831034434_QKOZG | UK005F | 2024-01-05T23:49:44.352Z | 2024-01-05T23:49:44.352Z |
1619134 | 1619134 | 20220831034406_LXpme | UK005F | 2024-01-05T23:49:44.351Z | 2024-01-05T23:49:44.351Z |
1619086 | 1619086 | 20220831034200_otfil | UK005F | 2024-01-05T23:49:44.340Z | 2024-01-05T23:49:44.340Z |
1619002 | 1619002 | 20220831033336_cf8MQ | UK005F | 2024-01-05T23:49:44.326Z | 2024-01-05T23:49:44.326Z |
1618981 | 1618981 | 20220831033223_CeQ88 | UK005F | 2024-01-05T23:49:44.323Z | 2024-01-05T23:49:44.323Z |
1618860 | 1618860 | 20220831031159_NLG8g | UK005F | 2024-01-05T23:49:44.297Z | 2024-01-05T23:49:44.297Z |
1618680 | 1618680 | 20220831025809_5mYiN | UK005F | 2024-01-05T23:49:44.265Z | 2024-01-05T23:49:44.265Z |
1618565 | 1618565 | 20220831024603_0n2JY | UK005F | 2024-01-05T23:49:44.245Z | 2024-01-05T23:49:44.245Z |
1618445 | 1618445 | 20220831023531_HfZ3s | UK005F | 2024-01-05T23:49:44.220Z | 2024-01-05T23:49:44.220Z |
1618328 | 1618328 | 20220831022055_0ItJe | UK005F | 2024-01-05T23:49:44.192Z | 2024-01-05T23:49:44.192Z |
1618294 | 1618294 | 20220831021416_IqFRN | UK005F | 2024-01-05T23:49:44.184Z | 2024-01-05T23:49:44.184Z |
1618242 | 1618242 | 20220831020820_Vp2Ak | UK005F | 2024-01-05T23:49:44.171Z | 2024-01-05T23:49:44.171Z |
1618204 | 1618204 | 20220831020310_qwA7u | UK005F | 2024-01-05T23:49:44.161Z | 2024-01-05T23:49:44.161Z |
1617992 | 1617992 | 20220831014141_EEy0B | UK005F | 2024-01-05T23:49:44.113Z | 2024-01-05T23:49:44.113Z |
1617923 | 1617923 | 20220831013611_eEluq | UK005F | 2024-01-05T23:49:44.098Z | 2024-01-05T23:49:44.098Z |
1617885 | 1617885 | 20220831013409_WKye7 | UK005F | 2024-01-05T23:49:44.092Z | 2024-01-05T23:49:44.092Z |
1617864 | 1617864 | 20220831013111_92iht | UK005F | 2024-01-05T23:49:44.082Z | 2024-01-05T23:49:44.082Z |
1617854 | 1617854 | 20220831013017_kxROd | UK005F | 2024-01-05T23:49:44.080Z | 2024-01-05T23:49:44.080Z |
1617795 | 1617795 | 20220831012542_4uDzX | UK005F | 2024-01-05T23:49:44.058Z | 2024-01-05T23:49:44.058Z |
1617718 | 1617718 | 20220831011628_wc4Jy | UK005F | 2024-01-05T23:49:44.030Z | 2024-01-05T23:49:44.030Z |
1617602 | 1617602 | 20220831010354_Rrjoj | UK005F | 2024-01-05T23:49:43.997Z | 2024-01-05T23:49:43.997Z |
1617305 | 1617305 | 20220831002302_oVUYm | UK005F | 2024-01-05T23:49:43.924Z | 2024-01-05T23:49:43.924Z |
1617287 | 1617287 | 20220831002105_f5ba6 | UK005F | 2024-01-05T23:49:43.922Z | 2024-01-05T23:49:43.922Z |
1617239 | 1617239 | 20220831001501_z032o | UK005F | 2024-01-05T23:49:43.914Z | 2024-01-05T23:49:43.914Z |
1617183 | 1617183 | 20220831000117_QPR4J | UK005F | 2024-01-05T23:49:43.903Z | 2024-01-05T23:49:43.903Z |
1617021 | 1617021 | 20220830233216_Ng54N | UK005F | 2024-01-05T23:49:43.872Z | 2024-01-05T23:49:43.872Z |
1616901 | 1616901 | 20220830231013_X5Imt | UK005F | 2024-01-05T23:49:43.847Z | 2024-01-05T23:49:43.847Z |
1616890 | 1616890 | 20220830230857_ptAfG | UK005F | 2024-01-05T23:49:43.845Z | 2024-01-05T23:49:43.845Z |
1616727 | 1616727 | 20220830224058_LV3jO | UK005F | 2024-01-05T23:49:43.814Z | 2024-01-05T23:49:43.814Z |
1616641 | 1616641 | 20220830221621_h539j | UK005F | 2024-01-05T23:49:43.796Z | 2024-01-05T23:49:43.796Z |
1616593 | 1616593 | 20220830220832_IIFrl | UK005F | 2024-01-05T23:49:43.789Z | 2024-01-05T23:49:43.789Z |
1616242 | 1616242 | 20220830203319_6wL2V | UK005F | 2024-01-05T23:49:43.719Z | 2024-01-05T23:49:43.719Z |
1605540 | 1605540 | 20220828035206_ZtBte | UK005F | 2024-01-05T23:49:36.981Z | 2024-01-05T23:49:36.981Z |
1605466 | 1605466 | 20220828033914_s72bj | UK005F | 2024-01-05T23:49:36.973Z | 2024-01-05T23:49:36.973Z |
1605371 | 1605371 | 20220828033228_dKGgL | UK005F | 2024-01-05T23:49:36.964Z | 2024-01-05T23:49:36.964Z |
1605337 | 1605337 | 20220828032520_lkpvx | UK005F | 2024-01-05T23:49:36.961Z | 2024-01-05T23:49:36.961Z |
1605251 | 1605251 | 20220828031839_ysAjh | UK005F | 2024-01-05T23:49:36.952Z | 2024-01-05T23:49:36.952Z |
1605050 | 1605050 | 20220828025116_doUgt | UK005F | 2024-01-05T23:49:36.926Z | 2024-01-05T23:49:36.926Z |
1604849 | 1604849 | 20220828022856_W1Ch4 | UK005F | 2024-01-05T23:49:36.884Z | 2024-01-05T23:49:36.884Z |
1604725 | 1604725 | 20220828021425_cjfpV | UK005F | 2024-01-05T23:49:36.860Z | 2024-01-05T23:49:36.860Z |
1604680 | 1604680 | 20220828021111_F9cJi | UK005F | 2024-01-05T23:49:36.851Z | 2024-01-05T23:49:36.851Z |
1604410 | 1604410 | 20220828014129_sIOLq | UK005F | 2024-01-05T23:49:36.824Z | 2024-01-05T23:49:36.824Z |
1604164 | 1604164 | 20220828011327_uS3BC | UK005F | 2024-01-05T23:49:36.802Z | 2024-01-05T23:49:36.802Z |
1604136 | 1604136 | 20220828011205_Qz0rm | UK005F | 2024-01-05T23:49:36.801Z | 2024-01-05T23:49:36.801Z |
1603977 | 1603977 | 20220828005333_SL2nF | UK005F | 2024-01-05T23:49:36.785Z | 2024-01-05T23:49:36.785Z |
1603908 | 1603908 | 20220828004422_Es3c2 | UK005F | 2024-01-05T23:49:36.779Z | 2024-01-05T23:49:36.779Z |
1603695 | 1603695 | 20220828002039_M6zrO | UK005F | 2024-01-05T23:49:36.761Z | 2024-01-05T23:49:36.761Z |
1603669 | 1603669 | 20220828001802_4CI2J | UK005F | 2024-01-05T23:49:36.758Z | 2024-01-05T23:49:36.758Z |
1603656 | 1603656 | 20220828001706_rpZhO | UK005F | 2024-01-05T23:49:36.756Z | 2024-01-05T23:49:36.756Z |
1603539 | 1603539 | 20220827235144_SvlQv | UK005F | 2024-01-05T23:49:36.745Z | 2024-01-05T23:49:36.745Z |
1603353 | 1603353 | 20220827231845_R7ikX | UK005F | 2024-01-05T23:49:36.726Z | 2024-01-05T23:49:36.726Z |
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);