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

8,357 rows where station_code = "UK0079" 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
9272814 9272814 20260128034033_SIxrx UK0079 2026-01-29T14:27:53.122Z 2026-01-29T14:30:25.566Z
9272794 9272794 20260128033830_T4RZG UK0079 2026-01-29T14:27:51.085Z 2026-01-29T14:30:25.563Z
9272719 9272719 20260128031058_EX559 UK0079 2026-01-29T14:27:37.627Z 2026-01-29T14:30:25.442Z
9271977 9271977 20260127224305_lyPpi UK0079 2026-01-29T14:25:12.032Z 2026-01-29T14:30:25.257Z
9256262 9256262 20260124063227_3Rkzt UK0079 2026-01-25T14:16:22.621Z 2026-01-29T14:48:33.317Z
9256253 9256253 20260124063007_XeDIl UK0079 2026-01-25T14:16:18.942Z 2026-01-29T14:48:31.060Z
9256158 9256158 20260124060431_oiJTZ UK0079 2026-01-25T14:16:04.357Z 2026-01-29T14:48:26.567Z
9256146 9256146 20260124060302_cm8wo UK0079 2026-01-25T14:16:02.415Z 2026-01-29T14:48:25.688Z
9256128 9256128 20260124060137_P9rKN UK0079 2026-01-25T14:15:59.693Z 2026-01-29T14:48:24.635Z
9256063 9256063 20260124054826_r82EU UK0079 2026-01-25T14:15:40.998Z 2026-01-29T14:48:20.910Z
9255860 9255860 20260124050937_0Fnxa UK0079 2026-01-25T14:14:59.803Z 2026-01-29T14:48:01.869Z
9255853 9255853 20260124050917_ylGs6 UK0079 2026-01-25T14:14:59.255Z 2026-01-29T14:48:01.694Z
9255603 9255603 20260124041907_ONViK UK0079 2026-01-25T14:14:05.332Z 2026-01-29T14:47:42.461Z
9255499 9255499 20260124035121_klKcz UK0079 2026-01-25T14:13:38.678Z 2026-01-29T14:47:34.537Z
9255470 9255470 20260124034259_zmw3J UK0079 2026-01-25T14:13:33.326Z 2026-01-29T14:47:32.505Z
9252146 9252146 20260123011315_HuV3l UK0079 2026-01-24T14:14:30.573Z 2026-01-29T14:52:36.132Z
9252136 9252136 20260123010903_ymXek UK0079 2026-01-24T14:14:28.089Z 2026-01-29T14:52:35.374Z
9252093 9252093 20260123010017_9VhYJ UK0079 2026-01-24T14:14:20.425Z 2026-01-29T14:52:30.577Z
9251868 9251868 20260122233659_Ia29L UK0079 2026-01-24T14:13:26.976Z 2026-01-29T14:52:14.266Z
9251858 9251858 20260122233421_Q3v33 UK0079 2026-01-24T14:13:25.169Z 2026-01-29T14:52:13.697Z
9242501 9242501 20260121020726_F30lq UK0079 2026-01-22T14:18:05.383Z 2026-01-29T15:04:02.169Z
9242485 9242485 20260121020342_Hiolu UK0079 2026-01-22T14:18:01.377Z 2026-01-29T15:04:00.913Z
9242283 9242283 20260121012246_1nTMy UK0079 2026-01-22T14:17:11.405Z 2026-01-29T15:03:42.438Z
9242210 9242210 20260121010132_IO9jI UK0079 2026-01-22T14:16:54.094Z 2026-01-29T15:03:36.954Z
9237438 9237438 20260120051850_zuHcK UK0079 2026-01-21T14:26:30.774Z 2026-01-28T15:01:25.810Z
9237105 9237105 20260120043820_1tnVp UK0079 2026-01-21T14:25:17.135Z 2026-01-28T15:00:58.164Z
9236712 9236712 20260120035056_SmM8B UK0079 2026-01-21T14:23:44.940Z 2026-01-28T15:00:31.719Z
9228565 9228565 20260118225405_x6xju UK0079 2026-01-20T14:18:25.136Z 2026-01-27T15:02:08.005Z
9228450 9228450 20260118222550_OGNBf UK0079 2026-01-20T14:17:52.374Z 2026-01-27T15:02:01.966Z
9218530 9218530 20260117042758_tm04r UK0079 2026-01-18T14:12:33.100Z 2026-01-25T14:58:29.152Z
9218391 9218391 20260117033421_OKsM3 UK0079 2026-01-18T14:11:54.394Z 2026-01-25T14:58:24.263Z
9218301 9218301 20260117024738_qB4rK UK0079 2026-01-18T14:11:31.517Z 2026-01-25T14:58:20.643Z
9213212 9213212 20260116023621_kHGfA UK0079 2026-01-17T14:15:54.662Z 2026-01-24T15:11:49.503Z
9213004 9213004 20260116014937_xC1W6 UK0079 2026-01-17T14:14:54.761Z 2026-01-24T15:11:36.943Z
9212904 9212904 20260116013607_eam1P UK0079 2026-01-17T14:14:30.241Z 2026-01-24T15:11:33.343Z
9212805 9212805 20260116010501_cCduP UK0079 2026-01-17T14:13:59.586Z 2026-01-24T15:11:27.384Z
9212716 9212716 20260116003040_kpsac UK0079 2026-01-17T14:13:27.344Z 2026-01-24T15:11:11.405Z
9212710 9212710 20260116003015_REOOp UK0079 2026-01-17T14:13:25.911Z 2026-01-24T15:11:10.981Z
9204247 9204247 20260114062010_zEb7K UK0079 2026-01-15T14:26:53.985Z 2026-01-22T15:10:23.076Z
9204231 9204231 20260114061718_CHORA UK0079 2026-01-15T14:26:51.701Z 2026-01-22T15:10:22.607Z
9204145 9204145 20260114061014_L47rf UK0079 2026-01-15T14:26:30.671Z 2026-01-22T15:10:21.020Z
9203930 9203930 20260114055658_QEIZ6 UK0079 2026-01-15T14:25:53.973Z 2026-01-22T15:10:15.813Z
9203865 9203865 20260114054537_gPSPn UK0079 2026-01-15T14:25:43.369Z 2026-01-22T15:10:14.635Z
9203757 9203757 20260114053525_kPJoE UK0079 2026-01-15T14:25:21.609Z 2026-01-22T15:10:13.158Z
9203609 9203609 20260114052158_OBkfQ UK0079 2026-01-15T14:25:00.644Z 2026-01-22T15:10:10.759Z
9202973 9202973 20260114042337_g3vtJ UK0079 2026-01-15T14:22:57.118Z 2026-01-22T15:10:00.222Z
9202953 9202953 20260114042107_dkgVw UK0079 2026-01-15T14:22:52.028Z 2026-01-22T15:09:59.872Z
9202838 9202838 20260114041254_2dO5K UK0079 2026-01-15T14:22:30.682Z 2026-01-22T15:09:57.327Z
9202587 9202587 20260114035221_ySoo6 UK0079 2026-01-15T14:21:44.255Z 2026-01-22T15:09:23.421Z
9202574 9202574 20260114035204_3fgFW UK0079 2026-01-15T14:21:43.122Z 2026-01-22T15:09:23.225Z
9181030 9181030 20260110235657_Xgjbn UK0079 2026-01-12T14:09:18.452Z 2026-01-19T15:16:44.837Z
9180635 9180635 20260110211632_CrlgH UK0079 2026-01-12T14:07:49.704Z 2026-01-19T15:16:25.640Z
9176246 9176246 20260110050850_7NpmI UK0079 2026-01-11T14:08:34.031Z 2026-01-18T15:08:25.194Z
9175670 9175670 20260110032201_arzxo UK0079 2026-01-11T14:07:01.770Z 2026-01-18T15:07:55.672Z
9175593 9175593 20260110030628_ie158 UK0079 2026-01-11T14:06:51.272Z 2026-01-18T15:07:52.668Z
9175582 9175582 20260110030218_ylbYH UK0079 2026-01-11T14:06:49.727Z 2026-01-18T15:07:52.110Z
9175438 9175438 20260110022934_HhNrP UK0079 2026-01-11T14:06:26.449Z 2026-01-18T15:07:45.807Z
9158447 9158447 20260105222913_MI7Od UK0079 2026-01-07T14:06:08.252Z 2026-01-13T15:07:22.701Z
9158421 9158421 20260105222632_tXVC9 UK0079 2026-01-07T14:06:02.389Z 2026-01-13T15:07:21.485Z
9158358 9158358 20260105220050_RfPxm UK0079 2026-01-07T14:05:49.821Z 2026-01-13T15:07:19.268Z
9157977 9157977 20260105193511_u2HVj UK0079 2026-01-07T14:04:22.313Z 2026-01-13T15:06:48.183Z
9155986 9155986 20260104063439_u5Z3h UK0079 2026-01-06T14:38:24.178Z 2026-01-12T15:11:34.114Z
9155919 9155919 20260104063129_1Pg9t UK0079 2026-01-06T14:38:11.683Z 2026-01-12T15:11:32.266Z
9155908 9155908 20260104063038_qw6KQ UK0079 2026-01-06T14:38:11.189Z 2026-01-12T15:11:31.882Z
9155897 9155897 20260104063011_oIk2w UK0079 2026-01-06T14:38:10.268Z 2026-01-12T15:11:31.621Z
9155776 9155776 20260104062101_XlMYk UK0079 2026-01-06T14:38:00.396Z 2026-01-12T15:11:27.308Z
9155770 9155770 20260104062049_gZ5Mk UK0079 2026-01-06T14:38:00.170Z 2026-01-12T15:11:27.222Z
9155571 9155571 20260104060615_lRvSv UK0079 2026-01-06T14:37:42.474Z 2026-01-12T15:11:20.059Z
9155549 9155549 20260104060402_E6BG7 UK0079 2026-01-06T14:37:31.698Z 2026-01-12T15:11:06.964Z
9155486 9155486 20260104055824_RrVqc UK0079 2026-01-06T14:37:25.854Z 2026-01-12T15:11:04.419Z
9155362 9155362 20260104055225_UE0nD UK0079 2026-01-06T14:37:16.732Z 2026-01-12T15:10:58.128Z
9155314 9155314 20260104054948_hRVQj UK0079 2026-01-06T14:37:13.796Z 2026-01-12T15:10:56.709Z
9154963 9154963 20260104052637_AetPy UK0079 2026-01-06T14:36:25.450Z 2026-01-12T15:10:27.845Z
9153085 9153085 20260103180049_KxMHK UK0079 2026-01-06T14:20:29.342Z 2026-01-12T14:59:20.303Z
9149167 9149167 20260104190909_h9iPu UK0079 2026-01-06T14:04:08.089Z 2026-01-13T15:11:46.233Z
9149159 9149159 20260104190707_IaV9f UK0079 2026-01-06T14:04:05.648Z 2026-01-13T15:11:45.606Z
9148960 9148960 20260104181828_GzAdu UK0079 2026-01-06T14:03:15.470Z 2026-01-13T15:11:29.132Z
9148934 9148934 20260104181021_wPsdQ UK0079 2026-01-06T14:03:09.527Z 2026-01-13T15:11:27.956Z
9148109 9148109 20260103173039_uLE98 UK0079 2026-01-05T14:30:17.165Z 2026-01-10T15:04:15.543Z
9137962 9137962 20260103214904_mOpwM UK0079 2026-01-05T14:09:14.858Z 2026-01-12T15:02:26.495Z
9137680 9137680 20260103212621_fQ0aU UK0079 2026-01-05T14:08:50.053Z 2026-01-12T15:02:16.609Z
9137501 9137501 20260103211610_U8YpE UK0079 2026-01-05T14:08:33.754Z 2026-01-12T15:02:12.615Z
9137188 9137188 20260103204941_D2fVf UK0079 2026-01-05T14:08:00.140Z 2026-01-12T15:01:52.625Z
9136608 9136608 20260103200734_nHs2m UK0079 2026-01-05T14:07:03.203Z 2026-01-12T15:01:24.502Z
9136577 9136577 20260103200456_Z5hkA UK0079 2026-01-05T14:07:01.432Z 2026-01-12T15:01:23.701Z
9136556 9136556 20260103200212_Xv41M UK0079 2026-01-05T14:06:56.168Z 2026-01-12T15:01:23.016Z
9136521 9136521 20260103200035_C15x3 UK0079 2026-01-05T14:06:53.395Z 2026-01-12T15:01:22.222Z
9136416 9136416 20260103195355_sAfNg UK0079 2026-01-05T14:06:39.490Z 2026-01-12T15:01:17.026Z
9136371 9136371 20260103195127_lrKcT UK0079 2026-01-05T14:06:37.667Z 2026-01-12T15:01:16.325Z
9136088 9136088 20260103193516_zfGb0 UK0079 2026-01-05T14:06:06.923Z 2026-01-12T15:01:06.904Z
9135725 9135725 20260103190845_0paGZ UK0079 2026-01-05T14:05:09.788Z 2026-01-12T15:00:45.143Z
9135706 9135706 20260103190757_jT1UA UK0079 2026-01-05T14:05:08.329Z 2026-01-12T15:00:44.568Z
9135670 9135670 20260103190645_Wsjf0 UK0079 2026-01-05T14:05:05.011Z 2026-01-12T15:00:43.573Z
9135374 9135374 20260103185355_JFK0U UK0079 2026-01-05T14:04:26.011Z 2026-01-12T15:00:29.062Z
9134930 9134930 20260103183218_2fEez UK0079 2026-01-05T14:03:17.643Z 2026-01-12T14:59:55.935Z
9134470 9134470 20260103180840_xmWdh UK0079 2026-01-05T14:02:05.197Z 2026-01-12T14:59:34.115Z
9134363 9134363 20260103180223_97gIB UK0079 2026-01-05T14:01:45.601Z 2026-01-12T14:59:27.917Z
9134331 9134331 20260103180049_PbAuh UK0079 2026-01-05T14:01:36.440Z 2026-01-12T14:59:20.181Z
9134278 9134278 20260103175803_xgulW UK0079 2026-01-05T14:01:25.998Z 2026-01-12T14:59:17.874Z
9133945 9133945 20260102172459_KxTkT UK0079 2026-01-04T14:29:49.742Z 2026-01-09T14:51:06.934Z

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