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

761 rows where station_code = "UK006M" 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
1732387 1732387 20221003043237_nSTSk UK006M 2024-01-05T23:50:42.910Z 2024-01-05T23:50:42.910Z
1732355 1732355 20221003042729_8RO3p UK006M 2024-01-05T23:50:42.907Z 2024-01-05T23:50:42.907Z
1732284 1732284 20221003041446_1e6Cw UK006M 2024-01-05T23:50:42.898Z 2024-01-05T23:50:42.898Z
1732253 1732253 20221003040913_MkNKV UK006M 2024-01-05T23:50:42.895Z 2024-01-05T23:50:42.895Z
1731844 1731844 20221003025943_XoU4F UK006M 2024-01-05T23:50:42.847Z 2024-01-05T23:50:42.847Z
1731584 1731584 20221003020810_8IZGx UK006M 2024-01-05T23:50:42.816Z 2024-01-05T23:50:42.816Z
1731385 1731385 20221003014213_LeJcj UK006M 2024-01-05T23:50:42.795Z 2024-01-05T23:50:42.795Z
1731314 1731314 20221003013304_TbfMA UK006M 2024-01-05T23:50:42.787Z 2024-01-05T23:50:42.787Z
1731237 1731237 20221003012123_8YHdC UK006M 2024-01-05T23:50:42.779Z 2024-01-05T23:50:42.779Z
1731083 1731083 20221003010307_rSEKy UK006M 2024-01-05T23:50:42.763Z 2024-01-05T23:50:42.763Z
1730989 1730989 20221003005047_5BTO1 UK006M 2024-01-05T23:50:42.754Z 2024-01-05T23:50:42.754Z
1730854 1730854 20221003003249_7lth0 UK006M 2024-01-05T23:50:42.740Z 2024-01-05T23:50:42.740Z
1730281 1730281 20221002231015_KRO9j UK006M 2024-01-05T23:50:42.687Z 2024-01-05T23:50:42.687Z
1730122 1730122 20221002223742_6UCAF UK006M 2024-01-05T23:50:42.672Z 2024-01-05T23:50:42.672Z
1729970 1729970 20221002221943_Jox7b UK006M 2024-01-05T23:50:42.662Z 2024-01-05T23:50:42.662Z
1729830 1729830 20221002215105_MUlYG UK006M 2024-01-05T23:50:42.648Z 2024-01-05T23:50:42.648Z
1729602 1729602 20221002205711_aQHns UK006M 2024-01-05T23:50:42.626Z 2024-01-05T23:50:42.626Z
1729574 1729574 20221002204629_If3mP UK006M 2024-01-05T23:50:42.622Z 2024-01-05T23:50:42.622Z
1729535 1729535 20221002203428_AWIBU UK006M 2024-01-05T23:50:42.617Z 2024-01-05T23:50:42.617Z
1729461 1729461 20221002201550_deFUY UK006M 2024-01-05T23:50:42.611Z 2024-01-05T23:50:42.611Z
1729409 1729409 20221002201318_3wz3V UK006M 2024-01-05T23:50:42.608Z 2024-01-05T23:50:42.608Z
1729285 1729285 20221002193325_SRpCW UK006M 2024-01-05T23:50:42.594Z 2024-01-05T23:50:42.594Z
1727264 1727264 20221002041010_xpQIS UK006M 2024-01-05T23:50:41.059Z 2024-01-05T23:50:41.059Z
1726619 1726619 20221002020014_1QFhZ UK006M 2024-01-05T23:50:40.977Z 2024-01-05T23:50:40.977Z
1726449 1726449 20221002010729_lOccM UK006M 2024-01-05T23:50:40.953Z 2024-01-05T23:50:40.953Z
1726209 1726209 20221002001029_TIhjU UK006M 2024-01-05T23:50:40.920Z 2024-01-05T23:50:40.920Z
1726201 1726201 20221002000722_2Bgqj UK006M 2024-01-05T23:50:40.919Z 2024-01-05T23:50:40.919Z
1726032 1726032 20221001231915_cbBTC UK006M 2024-01-05T23:50:40.897Z 2024-01-05T23:50:40.897Z
1725665 1725665 20221001210326_Qkb6m UK006M 2024-01-05T23:50:40.847Z 2024-01-05T23:50:40.847Z
1725484 1725484 20221001192426_ybUWs UK006M 2024-01-05T23:50:40.822Z 2024-01-05T23:50:40.822Z
1722883 1722883 20221001043548_2RdY9 UK006M 2024-01-05T23:50:39.239Z 2024-01-05T23:50:39.239Z
1722194 1722194 20221001032328_CE5uB UK006M 2024-01-05T23:50:39.182Z 2024-01-05T23:50:39.182Z
1722042 1722042 20221001030351_QDp7V UK006M 2024-01-05T23:50:39.167Z 2024-01-05T23:50:39.167Z
1721910 1721910 20221001025219_dSHhI UK006M 2024-01-05T23:50:39.155Z 2024-01-05T23:50:39.155Z
1721797 1721797 20221001023337_O5lW3 UK006M 2024-01-05T23:50:39.144Z 2024-01-05T23:50:39.144Z
1721795 1721795 20221001023251_nanfW UK006M 2024-01-05T23:50:39.143Z 2024-01-05T23:50:39.143Z
1721396 1721396 20221001014041_UYsRT UK006M 2024-01-05T23:50:39.109Z 2024-01-05T23:50:39.109Z
1721365 1721365 20221001013416_PcBOW UK006M 2024-01-05T23:50:39.106Z 2024-01-05T23:50:39.106Z
1721294 1721294 20221001012850_dh002 UK006M 2024-01-05T23:50:39.101Z 2024-01-05T23:50:39.101Z
1717311 1717311 20220930043234_JZ9ut UK006M 2024-01-05T23:50:37.458Z 2024-01-05T23:50:37.458Z
1717175 1717175 20220930041422_091jX UK006M 2024-01-05T23:50:37.443Z 2024-01-05T23:50:37.443Z
1717093 1717093 20220930040122_Ip81Y UK006M 2024-01-05T23:50:37.434Z 2024-01-05T23:50:37.434Z
1716953 1716953 20220930035257_wRWCL UK006M 2024-01-05T23:50:37.420Z 2024-01-05T23:50:37.420Z
1716911 1716911 20220930034943_XObJs UK006M 2024-01-05T23:50:37.417Z 2024-01-05T23:50:37.417Z
1716788 1716788 20220930033240_g0PAM UK006M 2024-01-05T23:50:37.404Z 2024-01-05T23:50:37.404Z
1716764 1716764 20220930033133_cUTxe UK006M 2024-01-05T23:50:37.402Z 2024-01-05T23:50:37.402Z
1716270 1716270 20220930024607_xNgXu UK006M 2024-01-05T23:50:37.360Z 2024-01-05T23:50:37.360Z
1715985 1715985 20220930022229_cMglH UK006M 2024-01-05T23:50:37.333Z 2024-01-05T23:50:37.333Z
1715662 1715662 20220930014801_BzaHW UK006M 2024-01-05T23:50:37.301Z 2024-01-05T23:50:37.301Z
1715459 1715459 20220930012127_g6itu UK006M 2024-01-05T23:50:37.284Z 2024-01-05T23:50:37.284Z
1715401 1715401 20220930011624_WEZlc UK006M 2024-01-05T23:50:37.278Z 2024-01-05T23:50:37.278Z
1715365 1715365 20220930010954_fhX1c UK006M 2024-01-05T23:50:37.274Z 2024-01-05T23:50:37.274Z
1715148 1715148 20220930004917_T1zwM UK006M 2024-01-05T23:50:37.253Z 2024-01-05T23:50:37.253Z
1714894 1714894 20220930002329_HoiFN UK006M 2024-01-05T23:50:37.235Z 2024-01-05T23:50:37.235Z
1714874 1714874 20220930002313_TA9W3 UK006M 2024-01-05T23:50:37.234Z 2024-01-05T23:50:37.234Z
1714818 1714818 20220930001822_p3XAt UK006M 2024-01-05T23:50:37.230Z 2024-01-05T23:50:37.230Z
1714750 1714750 20220930000412_JqwBf UK006M 2024-01-05T23:50:37.222Z 2024-01-05T23:50:37.222Z
1714667 1714667 20220929235636_LEEKI UK006M 2024-01-05T23:50:37.215Z 2024-01-05T23:50:37.215Z
1714443 1714443 20220929233752_S62qn UK006M 2024-01-05T23:50:37.195Z 2024-01-05T23:50:37.195Z
1714185 1714185 20220929230446_2uDkA UK006M 2024-01-05T23:50:37.172Z 2024-01-05T23:50:37.172Z
1713970 1713970 20220929223656_bs8Nd UK006M 2024-01-05T23:50:37.153Z 2024-01-05T23:50:37.153Z
1713822 1713822 20220929221652_rcKsJ UK006M 2024-01-05T23:50:37.139Z 2024-01-05T23:50:37.139Z
1713456 1713456 20220929211841_yC05K UK006M 2024-01-05T23:50:37.105Z 2024-01-05T23:50:37.105Z
1710892 1710892 20220929042631_Rxmw5 UK006M 2024-01-05T23:50:35.332Z 2024-01-05T23:50:35.332Z
1710622 1710622 20220929031810_FTaPU UK006M 2024-01-05T23:50:35.302Z 2024-01-05T23:50:35.302Z
1710546 1710546 20220929025724_9Hi4x UK006M 2024-01-05T23:50:35.294Z 2024-01-05T23:50:35.294Z
1710284 1710284 20220929015450_TBGOw UK006M 2024-01-05T23:50:35.262Z 2024-01-05T23:50:35.262Z
1709258 1709258 20220928214704_3VUJY UK006M 2024-01-05T23:50:35.155Z 2024-01-05T23:50:35.155Z
1709229 1709229 20220928213154_gymXX UK006M 2024-01-05T23:50:35.153Z 2024-01-05T23:50:35.153Z
1709077 1709077 20220928204148_8Kzvq UK006M 2024-01-05T23:50:35.137Z 2024-01-05T23:50:35.137Z
1706311 1706311 20220928034606_JZ9Ew UK006M 2024-01-05T23:50:33.403Z 2024-01-05T23:50:33.403Z
1689214 1689214 20220924033944_35UiT UK006M 2024-01-05T23:50:25.210Z 2024-01-05T23:50:25.210Z
1688852 1688852 20220924024245_tkYZ2 UK006M 2024-01-05T23:50:25.174Z 2024-01-05T23:50:25.174Z
1688318 1688318 20220924012010_y5tp6 UK006M 2024-01-05T23:50:25.119Z 2024-01-05T23:50:25.119Z
1688184 1688184 20220924005819_3XPNn UK006M 2024-01-05T23:50:25.103Z 2024-01-05T23:50:25.103Z
1687044 1687044 20220923202314_oHRVC UK006M 2024-01-05T23:50:24.971Z 2024-01-05T23:50:24.971Z
1686898 1686898 20220923191252_3nsDE UK006M 2024-01-05T23:50:24.954Z 2024-01-05T23:50:24.954Z
1659870 1659870 20220916212442_31r2x UK006M 2024-01-05T23:50:11.650Z 2024-01-05T23:50:11.650Z
1659466 1659466 20220916193631_oeaq2 UK006M 2024-01-05T23:50:11.611Z 2024-01-05T23:50:11.611Z
1657873 1657873 20220916040855_i0ZhU UK006M 2024-01-05T23:50:10.161Z 2024-01-05T23:50:10.161Z
1656570 1656570 20220915231158_C3rXT UK006M 2024-01-05T23:50:10.013Z 2024-01-05T23:50:10.013Z
1656104 1656104 20220915201454_eICy1 UK006M 2024-01-05T23:50:09.967Z 2024-01-05T23:50:09.967Z
1654557 1654557 20220915034613_EkYV6 UK006M 2024-01-05T23:50:08.530Z 2024-01-05T23:50:08.530Z
1654552 1654552 20220915033849_YAarv UK006M 2024-01-05T23:50:08.529Z 2024-01-05T23:50:08.529Z
1654518 1654518 20220915032458_qmgqS UK006M 2024-01-05T23:50:08.525Z 2024-01-05T23:50:08.525Z
1654489 1654489 20220915031323_UAe3y UK006M 2024-01-05T23:50:08.521Z 2024-01-05T23:50:08.521Z
1654164 1654164 20220914222138_OB3yi UK006M 2024-01-05T23:50:08.475Z 2024-01-05T23:50:08.475Z
1654091 1654091 20220914204313_Z4Amv UK006M 2024-01-05T23:50:08.465Z 2024-01-05T23:50:08.465Z
1650208 1650208 20220911033246_bXxx8 UK006M 2024-01-05T23:50:04.436Z 2024-01-05T23:50:04.436Z
1650077 1650077 20220911020226_tdDnR UK006M 2024-01-05T23:50:04.419Z 2024-01-05T23:50:04.419Z
1649966 1649966 20220911010357_n7HpS UK006M 2024-01-05T23:50:03.276Z 2024-01-05T23:50:03.276Z
1648040 1648040 20220909020844_XELCr UK006M 2024-01-05T23:50:01.834Z 2024-01-05T23:50:01.834Z
1648032 1648032 20220909020603_Ca93x UK006M 2024-01-05T23:50:01.833Z 2024-01-05T23:50:01.833Z
1647903 1647903 20220909002445_yYBY7 UK006M 2024-01-05T23:50:01.811Z 2024-01-05T23:50:01.811Z
1647874 1647874 20220909000639_KzOf6 UK006M 2024-01-05T23:50:01.807Z 2024-01-05T23:50:01.807Z
1647838 1647838 20220908231520_OLvpC UK006M 2024-01-05T23:50:00.634Z 2024-01-05T23:50:00.634Z
1646680 1646680 20220907223042_RO4TS UK006M 2024-01-05T23:49:59.326Z 2024-01-05T23:49:59.326Z
1646522 1646522 20220907200434_vt1EO UK006M 2024-01-05T23:49:59.304Z 2024-01-05T23:49:59.304Z
1644921 1644921 20220907033058_bZuNe UK006M 2024-01-05T23:49:59.114Z 2024-01-05T23:49:59.114Z
1644894 1644894 20220907032530_2u3kO UK006M 2024-01-05T23:49:59.110Z 2024-01-05T23:49:59.110Z

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