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

69 rows where station_code = "UK0048" 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
1229797 1229797 20220322024300_IfLm4 UK0048 2024-01-05T23:43:18.428Z 2024-01-05T23:43:18.428Z
1229121 1229121 20220321043400_lTJAe UK0048 2024-01-05T23:43:17.058Z 2024-01-05T23:43:17.058Z
1229105 1229105 20220321040824_na0vr UK0048 2024-01-05T23:43:17.055Z 2024-01-05T23:43:17.055Z
1229082 1229082 20220321032852_236rQ UK0048 2024-01-05T23:43:17.052Z 2024-01-05T23:43:17.052Z
1228914 1228914 20220321002513_7Fch4 UK0048 2024-01-05T23:43:17.030Z 2024-01-05T23:43:17.030Z
1228862 1228862 20220320233125_4tB6F UK0048 2024-01-05T23:43:17.023Z 2024-01-05T23:43:17.023Z
1228665 1228665 20220320204656_CMtBU UK0048 2024-01-05T23:43:15.660Z 2024-01-05T23:43:15.660Z
1228510 1228510 20220320045312_T53PS UK0048 2024-01-05T23:43:15.638Z 2024-01-05T23:43:15.638Z
1228286 1228286 20220320024349_APP2s UK0048 2024-01-05T23:43:15.616Z 2024-01-05T23:43:15.616Z
1228260 1228260 20220320023331_9T83i UK0048 2024-01-05T23:43:15.614Z 2024-01-05T23:43:15.614Z
1228126 1228126 20220320012305_Ytz5O UK0048 2024-01-05T23:43:15.600Z 2024-01-05T23:43:15.600Z
1228134 1228134 20220320012346_cFqu2 UK0048 2024-01-05T23:43:15.600Z 2024-01-05T23:43:15.600Z
1227735 1227735 20220319201034_UFg2j UK0048 2024-01-05T23:43:14.197Z 2024-01-05T23:43:14.197Z
1227315 1227315 20220319034856_Yewne UK0048 2024-01-05T23:43:14.143Z 2024-01-05T23:43:14.143Z
1227228 1227228 20220319032257_tTa5H UK0048 2024-01-05T23:43:14.134Z 2024-01-05T23:43:14.134Z
1227203 1227203 20220319031158_7YRYu UK0048 2024-01-05T23:43:14.131Z 2024-01-05T23:43:14.131Z
1227155 1227155 20220319025059_I1QBx UK0048 2024-01-05T23:43:14.127Z 2024-01-05T23:43:14.127Z
1227074 1227074 20220319021812_oybYT UK0048 2024-01-05T23:43:14.118Z 2024-01-05T23:43:14.118Z
1227015 1227015 20220319013847_c2K1r UK0048 2024-01-05T23:43:14.111Z 2024-01-05T23:43:14.111Z
1226975 1226975 20220319004749_pFvAP UK0048 2024-01-05T23:43:14.107Z 2024-01-05T23:43:14.107Z
1226394 1226394 20220318012353_D8Hq6 UK0048 2024-01-05T23:43:12.802Z 2024-01-05T23:43:12.802Z
1226075 1226075 20220317041851_Jtxtt UK0048 2024-01-05T23:43:11.079Z 2024-01-05T23:43:11.079Z
1226030 1226030 20220317040219_xOzE6 UK0048 2024-01-05T23:43:11.076Z 2024-01-05T23:43:11.076Z
1225998 1225998 20220317035010_GAu1c UK0048 2024-01-05T23:43:11.072Z 2024-01-05T23:43:11.072Z
1225983 1225983 20220317034739_fLfBP UK0048 2024-01-05T23:43:11.071Z 2024-01-05T23:43:11.071Z
1225886 1225886 20220317023922_xE2H7 UK0048 2024-01-05T23:43:11.062Z 2024-01-05T23:43:11.062Z
1225843 1225843 20220317020850_hFXtU UK0048 2024-01-05T23:43:11.057Z 2024-01-05T23:43:11.057Z
1225819 1225819 20220317013208_72Yln UK0048 2024-01-05T23:43:11.055Z 2024-01-05T23:43:11.055Z
1225744 1225744 20220316235515_gGHR6 UK0048 2024-01-05T23:43:11.046Z 2024-01-05T23:43:11.046Z
1225103 1225103 20220315051826_NS662 UK0048 2024-01-05T23:43:08.317Z 2024-01-05T23:43:08.317Z
1225047 1225047 20220315043523_aiHL9 UK0048 2024-01-05T23:43:08.311Z 2024-01-05T23:43:08.311Z
1224734 1224734 20220315014108_IcqOV UK0048 2024-01-05T23:43:08.278Z 2024-01-05T23:43:08.278Z
1224060 1224060 20220314045744_EQJQw UK0048 2024-01-05T23:43:06.906Z 2024-01-05T23:43:06.906Z
1223743 1223743 20220314030844_7EqiM UK0048 2024-01-05T23:43:06.844Z 2024-01-05T23:43:06.844Z
1223456 1223456 20220314014216_1xbE9 UK0048 2024-01-05T23:43:06.781Z 2024-01-05T23:43:06.781Z
1223322 1223322 20220314002112_PtyJj UK0048 2024-01-05T23:43:06.743Z 2024-01-05T23:43:06.743Z
1223310 1223310 20220314001535_r1DwY UK0048 2024-01-05T23:43:06.739Z 2024-01-05T23:43:06.739Z
1223272 1223272 20220313234053_r7X5Y UK0048 2024-01-05T23:43:06.727Z 2024-01-05T23:43:06.727Z
1223256 1223256 20220313231922_uSBws UK0048 2024-01-05T23:43:06.721Z 2024-01-05T23:43:06.721Z
1223208 1223208 20220313215031_t25Eq UK0048 2024-01-05T23:43:04.726Z 2024-01-05T23:43:04.726Z
1220630 1220630 20220312033501_OhvrI UK0048 2024-01-05T23:43:02.121Z 2024-01-05T23:43:02.121Z
1219056 1219056 20220311021311_H3DiZ UK0048 2024-01-05T23:43:00.083Z 2024-01-05T23:43:00.083Z
1218153 1218153 20220310051438_t8FbI UK0048 2024-01-05T23:42:57.892Z 2024-01-05T23:42:57.892Z
1213832 1213832 20220308035705_bDB7F UK0048 2024-01-05T23:42:54.302Z 2024-01-05T23:42:54.302Z
1213768 1213768 20220308034818_d2afc UK0048 2024-01-05T23:42:54.295Z 2024-01-05T23:42:54.295Z
1213632 1213632 20220308031742_A2o5W UK0048 2024-01-05T23:42:54.278Z 2024-01-05T23:42:54.278Z
1213538 1213538 20220308025653_Nb2Rd UK0048 2024-01-05T23:42:54.267Z 2024-01-05T23:42:54.267Z
1213547 1213547 20220308025742_ho07z UK0048 2024-01-05T23:42:54.267Z 2024-01-05T23:42:54.267Z
1211692 1211692 20220307050344_eRSoO UK0048 2024-01-05T23:42:52.551Z 2024-01-05T23:42:52.551Z
1211683 1211683 20220307050143_6Tftd UK0048 2024-01-05T23:42:52.548Z 2024-01-05T23:42:52.548Z
1211015 1211015 20220306221805_xn9dG UK0048 2024-01-05T23:42:52.275Z 2024-01-05T23:42:52.275Z
1209309 1209309 20220305045520_S8OOf UK0048 2024-01-05T23:42:48.530Z 2024-01-05T23:42:48.530Z
1208715 1208715 20220305005926_WYuA1 UK0048 2024-01-05T23:42:48.162Z 2024-01-05T23:42:48.162Z
1208613 1208613 20220305001025_XQPR0 UK0048 2024-01-05T23:42:48.122Z 2024-01-05T23:42:48.122Z
1208606 1208606 20220305000025_6FilX UK0048 2024-01-05T23:42:48.118Z 2024-01-05T23:42:48.118Z
1208507 1208507 20220304232410_QWqP7 UK0048 2024-01-05T23:42:48.084Z 2024-01-05T23:42:48.084Z
1208501 1208501 20220304232410_T7Duu UK0048 2024-01-05T23:42:48.083Z 2024-01-05T23:42:48.083Z
1208383 1208383 20220304214101_gdq3p UK0048 2024-01-05T23:42:46.101Z 2024-01-05T23:42:46.101Z
1208258 1208258 20220304200420_kcTV3 UK0048 2024-01-05T23:42:46.083Z 2024-01-05T23:42:46.083Z
1208204 1208204 20220304192203_c7wBj UK0048 2024-01-05T23:42:46.075Z 2024-01-05T23:42:46.075Z
1198705 1198705 20220227034030_tvdKw UK0048 2024-01-05T23:42:35.197Z 2024-01-05T23:42:35.197Z
1198503 1198503 20220227030203_QMn2q UK0048 2024-01-05T23:42:35.158Z 2024-01-05T23:42:35.158Z
1198404 1198404 20220227024348_w91yC UK0048 2024-01-05T23:42:35.138Z 2024-01-05T23:42:35.138Z
1198284 1198284 20220227022921_16Osh UK0048 2024-01-05T23:42:35.118Z 2024-01-05T23:42:35.118Z
1198194 1198194 20220227021136_hty0I UK0048 2024-01-05T23:42:35.100Z 2024-01-05T23:42:35.100Z
1198074 1198074 20220227014529_Ar2Do UK0048 2024-01-05T23:42:35.078Z 2024-01-05T23:42:35.078Z
1197881 1197881 20220227010201_stjYW UK0048 2024-01-05T23:42:35.034Z 2024-01-05T23:42:35.034Z
1194493 1194493 20220225224732_N2SSN UK0048 2024-01-05T23:42:31.441Z 2024-01-05T23:42:31.441Z
1194461 1194461 20220225224044_7730N UK0048 2024-01-05T23:42:29.641Z 2024-01-05T23:42:29.641Z

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