home / gmn_data_store / participating_station

Menu
  • Dashboards

participating_station

Each row represents a station recording a meteor sighting.

Data license: CC BY 4.0 license · Data source: Global Meteor Network

1,082 rows where station_code = "UK005F" sorted by created_at descending

✎ View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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);
Powered by Datasette · Queries took 1.2ms · Data license: CC BY 4.0 license · Data source: Global Meteor Network