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

2,047 rows where station_code = "UK003H" 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
1763915 1763915 20221013033822_TMIP5 UK003H 2024-01-05T23:51:01.851Z 2024-01-05T23:51:01.851Z
1763852 1763852 20221013032532_Jx4xP UK003H 2024-01-05T23:51:01.845Z 2024-01-05T23:51:01.845Z
1761136 1761136 20221011223100_31y8u UK003H 2024-01-05T23:51:00.326Z 2024-01-05T23:51:00.326Z
1760853 1760853 20221011194844_92PBL UK003H 2024-01-05T23:51:00.297Z 2024-01-05T23:51:00.297Z
1760811 1760811 20221011192748_H0K4z UK003H 2024-01-05T23:51:00.292Z 2024-01-05T23:51:00.292Z
1758820 1758820 20221011005451_GJ9nP UK003H 2024-01-05T23:50:58.855Z 2024-01-05T23:50:58.855Z
1758496 1758496 20221010220544_e9DBS UK003H 2024-01-05T23:50:58.824Z 2024-01-05T23:50:58.824Z
1758427 1758427 20221010205354_xmyQO UK003H 2024-01-05T23:50:58.817Z 2024-01-05T23:50:58.817Z
1758411 1758411 20221010204852_CYNgn UK003H 2024-01-05T23:50:58.816Z 2024-01-05T23:50:58.816Z
1758301 1758301 20221010190547_w00Qm UK003H 2024-01-05T23:50:58.806Z 2024-01-05T23:50:58.806Z
1756543 1756543 20221009051338_3oCof UK003H 2024-01-05T23:50:55.375Z 2024-01-05T23:50:55.375Z
1756055 1756055 20221009035627_03GCL UK003H 2024-01-05T23:50:55.339Z 2024-01-05T23:50:55.339Z
1755822 1755822 20221009031216_oLszX UK003H 2024-01-05T23:50:55.315Z 2024-01-05T23:50:55.315Z
1755666 1755666 20221009024613_Dd29i UK003H 2024-01-05T23:50:55.301Z 2024-01-05T23:50:55.301Z
1755205 1755205 20221009004250_Zkv7S UK003H 2024-01-05T23:50:55.253Z 2024-01-05T23:50:55.253Z
1755177 1755177 20221009003549_rq7W2 UK003H 2024-01-05T23:50:55.251Z 2024-01-05T23:50:55.251Z
1755159 1755159 20221009003243_NyuQ2 UK003H 2024-01-05T23:50:55.249Z 2024-01-05T23:50:55.249Z
1755014 1755014 20221008235322_TGYna UK003H 2024-01-05T23:50:55.236Z 2024-01-05T23:50:55.236Z
1754989 1754989 20221008234540_u4lpY UK003H 2024-01-05T23:50:55.233Z 2024-01-05T23:50:55.233Z
1754919 1754919 20221008232831_43kNG UK003H 2024-01-05T23:50:55.227Z 2024-01-05T23:50:55.227Z
1754860 1754860 20221008231333_T3MF9 UK003H 2024-01-05T23:50:55.220Z 2024-01-05T23:50:55.220Z
1753256 1753256 20221008043211_guuNh UK003H 2024-01-05T23:50:53.261Z 2024-01-05T23:50:53.261Z
1753112 1753112 20221008042202_luju7 UK003H 2024-01-05T23:50:53.251Z 2024-01-05T23:50:53.251Z
1752906 1752906 20221008040918_XunFF UK003H 2024-01-05T23:50:53.235Z 2024-01-05T23:50:53.235Z
1752891 1752891 20221008040722_OaZBT UK003H 2024-01-05T23:50:53.234Z 2024-01-05T23:50:53.234Z
1752810 1752810 20221008040213_Gl2XO UK003H 2024-01-05T23:50:53.229Z 2024-01-05T23:50:53.229Z
1752247 1752247 20221008030842_MwcEO UK003H 2024-01-05T23:50:53.181Z 2024-01-05T23:50:53.181Z
1752220 1752220 20221008030419_Njjzs UK003H 2024-01-05T23:50:53.179Z 2024-01-05T23:50:53.179Z
1751401 1751401 20221008012441_aUQtk UK003H 2024-01-05T23:50:53.111Z 2024-01-05T23:50:53.111Z
1750953 1750953 20221007233811_V5U2R UK003H 2024-01-05T23:50:53.076Z 2024-01-05T23:50:53.076Z
1750813 1750813 20221007223333_HEIBq UK003H 2024-01-05T23:50:53.062Z 2024-01-05T23:50:53.062Z
1750657 1750657 20221007212552_6RiNm UK003H 2024-01-05T23:50:53.046Z 2024-01-05T23:50:53.046Z
1750591 1750591 20221007210231_rAba0 UK003H 2024-01-05T23:50:53.040Z 2024-01-05T23:50:53.040Z
1750462 1750462 20221007201411_rRZ6O UK003H 2024-01-05T23:50:53.026Z 2024-01-05T23:50:53.026Z
1750425 1750425 20221007200337_d7w2N UK003H 2024-01-05T23:50:53.022Z 2024-01-05T23:50:53.022Z
1748552 1748552 20221007024520_iY1Ex UK003H 2024-01-05T23:50:51.251Z 2024-01-05T23:50:51.251Z
1745689 1745689 20221006045120_DX505 UK003H 2024-01-05T23:50:49.497Z 2024-01-05T23:50:49.497Z
1745670 1745670 20221006045033_PN1RN UK003H 2024-01-05T23:50:49.495Z 2024-01-05T23:50:49.495Z
1745049 1745049 20221006041819_s27nO UK003H 2024-01-05T23:50:49.454Z 2024-01-05T23:50:49.454Z
1744748 1744748 20221006040025_t0NJs UK003H 2024-01-05T23:50:49.431Z 2024-01-05T23:50:49.431Z
1744585 1744585 20221006035606_3sR21 UK003H 2024-01-05T23:50:49.421Z 2024-01-05T23:50:49.421Z
1744296 1744296 20221006034122_vduvP UK003H 2024-01-05T23:50:49.403Z 2024-01-05T23:50:49.403Z
1744098 1744098 20221006033450_dRyv6 UK003H 2024-01-05T23:50:49.392Z 2024-01-05T23:50:49.392Z
1742994 1742994 20221006022101_Ie2Vi UK003H 2024-01-05T23:50:49.303Z 2024-01-05T23:50:49.303Z
1742864 1742864 20221006021407_TRarZ UK003H 2024-01-05T23:50:49.294Z 2024-01-05T23:50:49.294Z
1742600 1742600 20221006015927_ISVXn UK003H 2024-01-05T23:50:49.273Z 2024-01-05T23:50:49.273Z
1742538 1742538 20221006015700_DFgI0 UK003H 2024-01-05T23:50:49.269Z 2024-01-05T23:50:49.269Z
1742467 1742467 20221006015218_YqGtU UK003H 2024-01-05T23:50:49.264Z 2024-01-05T23:50:49.264Z
1742272 1742272 20221006014144_1D9mJ UK003H 2024-01-05T23:50:49.247Z 2024-01-05T23:50:49.247Z
1742080 1742080 20221006013147_UwcRY UK003H 2024-01-05T23:50:49.233Z 2024-01-05T23:50:49.233Z
1742058 1742058 20221006013011_SqJVa UK003H 2024-01-05T23:50:49.231Z 2024-01-05T23:50:49.231Z
1741534 1741534 20221006004310_t7eU3 UK003H 2024-01-05T23:50:49.189Z 2024-01-05T23:50:49.189Z
1741375 1741375 20221006002119_VzhcE UK003H 2024-01-05T23:50:49.172Z 2024-01-05T23:50:49.172Z
1740672 1740672 20221005223739_2InQC UK003H 2024-01-05T23:50:49.110Z 2024-01-05T23:50:49.110Z
1740566 1740566 20221005222538_TndV7 UK003H 2024-01-05T23:50:49.102Z 2024-01-05T23:50:49.102Z
1740486 1740486 20221005221338_yA6ER UK003H 2024-01-05T23:50:49.096Z 2024-01-05T23:50:49.096Z
1740391 1740391 20221005215304_aheKv UK003H 2024-01-05T23:50:49.089Z 2024-01-05T23:50:49.089Z
1739955 1739955 20221005195622_wNMsz UK003H 2024-01-05T23:50:49.046Z 2024-01-05T23:50:49.046Z
1730628 1730628 20221003000253_8ZPhZ UK003H 2024-01-05T23:50:42.721Z 2024-01-05T23:50:42.721Z
1730546 1730546 20221002234448_Mk0ns UK003H 2024-01-05T23:50:42.713Z 2024-01-05T23:50:42.713Z
1729874 1729874 20221002215801_HgnTm UK003H 2024-01-05T23:50:42.653Z 2024-01-05T23:50:42.653Z
1729636 1729636 20221002210819_f9JYJ UK003H 2024-01-05T23:50:42.630Z 2024-01-05T23:50:42.630Z
1729580 1729580 20221002204848_7aZzk UK003H 2024-01-05T23:50:42.623Z 2024-01-05T23:50:42.623Z
1729544 1729544 20221002203924_C0yBq UK003H 2024-01-05T23:50:42.619Z 2024-01-05T23:50:42.619Z
1729341 1729341 20221002195009_xc83N UK003H 2024-01-05T23:50:42.600Z 2024-01-05T23:50:42.600Z
1722232 1722232 20221001032543_dP8rV UK003H 2024-01-05T23:50:39.185Z 2024-01-05T23:50:39.185Z
1722057 1722057 20221001030505_lFDpp UK003H 2024-01-05T23:50:39.169Z 2024-01-05T23:50:39.169Z
1722060 1722060 20221001030839_MelKI UK003H 2024-01-05T23:50:39.169Z 2024-01-05T23:50:39.169Z
1721569 1721569 20221001020032_MS3hS UK003H 2024-01-05T23:50:39.122Z 2024-01-05T23:50:39.122Z
1721465 1721465 20221001015046_JcRi9 UK003H 2024-01-05T23:50:39.115Z 2024-01-05T23:50:39.115Z
1721388 1721388 20221001013930_I45A3 UK003H 2024-01-05T23:50:39.108Z 2024-01-05T23:50:39.108Z
1721327 1721327 20221001013214_zGp3i UK003H 2024-01-05T23:50:39.104Z 2024-01-05T23:50:39.104Z
1720749 1720749 20220930232851_ao0fo UK003H 2024-01-05T23:50:39.050Z 2024-01-05T23:50:39.050Z
1717376 1717376 20220930044134_ik8S0 UK003H 2024-01-05T23:50:37.466Z 2024-01-05T23:50:37.466Z
1717320 1717320 20220930043427_lNBF0 UK003H 2024-01-05T23:50:37.459Z 2024-01-05T23:50:37.459Z
1717151 1717151 20220930041247_W3yV6 UK003H 2024-01-05T23:50:37.440Z 2024-01-05T23:50:37.440Z
1717154 1717154 20220930041318_kn3bM UK003H 2024-01-05T23:50:37.440Z 2024-01-05T23:50:37.440Z
1716884 1716884 20220930034513_aTiZb UK003H 2024-01-05T23:50:37.414Z 2024-01-05T23:50:37.414Z
1716711 1716711 20220930032829_tzTpK UK003H 2024-01-05T23:50:37.398Z 2024-01-05T23:50:37.398Z
1716142 1716142 20220930023420_xVt8e UK003H 2024-01-05T23:50:37.348Z 2024-01-05T23:50:37.348Z
1716021 1716021 20220930022423_Uw9OT UK003H 2024-01-05T23:50:37.336Z 2024-01-05T23:50:37.336Z
1715845 1715845 20220930020656_rXH7Y UK003H 2024-01-05T23:50:37.319Z 2024-01-05T23:50:37.319Z
1715470 1715470 20220930012229_rC5HK UK003H 2024-01-05T23:50:37.285Z 2024-01-05T23:50:37.285Z
1715343 1715343 20220930010849_blWvT UK003H 2024-01-05T23:50:37.273Z 2024-01-05T23:50:37.273Z
1714289 1714289 20220929231919_2IPcY UK003H 2024-01-05T23:50:37.182Z 2024-01-05T23:50:37.182Z
1714095 1714095 20220929225244_aY65R UK003H 2024-01-05T23:50:37.164Z 2024-01-05T23:50:37.164Z
1713851 1713851 20220929222345_3lF2S UK003H 2024-01-05T23:50:37.144Z 2024-01-05T23:50:37.144Z
1713794 1713794 20220929221452_agqKW UK003H 2024-01-05T23:50:37.137Z 2024-01-05T23:50:37.137Z
1713743 1713743 20220929220447_MQYGb UK003H 2024-01-05T23:50:37.131Z 2024-01-05T23:50:37.131Z
1713729 1713729 20220929220409_4N6lH UK003H 2024-01-05T23:50:37.130Z 2024-01-05T23:50:37.130Z
1713660 1713660 20220929215805_zMyo9 UK003H 2024-01-05T23:50:37.125Z 2024-01-05T23:50:37.125Z
1713488 1713488 20220929212948_r28PX UK003H 2024-01-05T23:50:37.108Z 2024-01-05T23:50:37.108Z
1713205 1713205 20220929202405_cwm1R UK003H 2024-01-05T23:50:37.076Z 2024-01-05T23:50:37.076Z
1713188 1713188 20220929202031_3aGlE UK003H 2024-01-05T23:50:37.075Z 2024-01-05T23:50:37.075Z
1713021 1713021 20220929194751_cpHcb UK003H 2024-01-05T23:50:37.058Z 2024-01-05T23:50:37.058Z
1709909 1709909 20220929002245_TwK6O UK003H 2024-01-05T23:50:35.215Z 2024-01-05T23:50:35.215Z
1709882 1709882 20220929001606_U9yIm UK003H 2024-01-05T23:50:35.212Z 2024-01-05T23:50:35.212Z
1709798 1709798 20220929000157_2ag6H UK003H 2024-01-05T23:50:35.205Z 2024-01-05T23:50:35.205Z
1709596 1709596 20220928231729_RU2F4 UK003H 2024-01-05T23:50:35.184Z 2024-01-05T23:50:35.184Z
1709582 1709582 20220928231133_HYZlc UK003H 2024-01-05T23:50:35.183Z 2024-01-05T23:50:35.183Z

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