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

3,885 rows where station_code = "UK0090" 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
9611172 9611172 20260405003907_GvnAl UK0090 2026-04-06T12:13:23.101Z 2026-04-06T12:16:14.747Z
9609165 9609165 20260405034917_JvLRl UK0090 2026-04-06T12:00:30.304Z 2026-04-06T12:00:30.304Z
9608539 9608539 20260403233238_eK4nX UK0090 2026-04-05T12:10:46.406Z 2026-04-06T12:20:19.282Z
9608371 9608371 20260403224039_lXkxl UK0090 2026-04-05T12:10:16.446Z 2026-04-06T12:20:08.903Z
9608132 9608132 20260403200924_uq6G6 UK0090 2026-04-05T12:09:00.028Z 2026-04-06T12:19:44.499Z
9594450 9594450 20260328222428_YV0QV UK0090 2026-03-30T12:09:34.413Z 2026-04-06T12:39:52.542Z
9594445 9594445 20260328222427_3PAlz UK0090 2026-03-30T12:09:33.773Z 2026-04-06T12:39:52.253Z
9594374 9594374 20260328215751_JIXT0 UK0090 2026-03-30T12:09:25.491Z 2026-04-06T12:39:49.922Z
9594173 9594173 20260328194224_ImLr8 UK0090 2026-03-30T12:08:53.491Z 2026-04-06T12:39:40.956Z
9591864 9591864 20260327225400_hhi9k UK0090 2026-03-29T12:06:53.054Z 2026-04-05T12:35:18.020Z
9591840 9591840 20260327223007_86vd3 UK0090 2026-03-29T12:06:50.665Z 2026-04-05T12:35:16.444Z
9590034 9590034 20260328042939_QMMfv UK0090 2026-03-29T12:01:53.714Z 2026-04-06T12:37:47.702Z
9589816 9589816 20260328040906_Q7ble UK0090 2026-03-29T12:01:39.241Z 2026-04-06T12:37:35.644Z
9589619 9589619 20260328035159_If0L3 UK0090 2026-03-29T12:01:29.700Z 2026-04-06T12:37:29.229Z
9584959 9584959 20260325225442_oOgY3 UK0090 2026-03-27T12:16:26.774Z 2026-04-03T12:39:45.264Z
9584475 9584475 20260325200334_PUfkc UK0090 2026-03-27T12:15:25.357Z 2026-04-03T12:39:15.901Z
9584473 9584473 20260325200059_IBDSc UK0090 2026-03-27T12:15:24.474Z 2026-04-03T12:39:15.646Z
9581953 9581953 20260326041429_07fzY UK0090 2026-03-27T12:04:14.827Z 2026-04-04T12:39:32.426Z
9581804 9581804 20260326035927_aH004 UK0090 2026-03-27T12:03:52.970Z 2026-04-04T12:39:21.065Z
9581784 9581784 20260326035617_PIqPo UK0090 2026-03-27T12:03:50.691Z 2026-04-04T12:39:20.438Z
9581567 9581567 20260326033113_OwaM9 UK0090 2026-03-27T12:03:25.278Z 2026-04-04T12:39:10.831Z
9576882 9576882 20260325032228_nXUeD UK0090 2026-03-26T12:03:33.559Z 2026-04-03T12:36:24.393Z
9576796 9576796 20260325030906_5WwpU UK0090 2026-03-26T12:03:18.992Z 2026-04-03T12:36:21.312Z
9570876 9570876 20260322230541_kyBDS UK0090 2026-03-24T12:23:57.654Z 2026-03-30T12:30:50.970Z
9561528 9561528 20260322235759_7OSyF UK0090 2026-03-24T12:00:17.973Z 2026-03-31T12:25:46.031Z
9561085 9561085 20260321225532_iJNAV UK0090 2026-03-23T12:12:11.405Z 2026-03-29T12:21:05.123Z
9560038 9560038 20260321202522_0sNKt UK0090 2026-03-23T12:11:36.480Z 2026-03-29T12:20:57.499Z
9559899 9559899 20260321200812_xls3O UK0090 2026-03-23T12:11:33.433Z 2026-03-29T12:20:56.459Z
9559848 9559848 20260321200157_nvpeH UK0090 2026-03-23T12:11:31.978Z 2026-03-29T12:20:56.085Z
9553985 9553985 20260322023008_IzhMY UK0090 2026-03-23T12:02:04.925Z 2026-03-30T12:27:56.403Z
9553334 9553334 20260322013144_r1lAU UK0090 2026-03-23T12:01:24.525Z 2026-03-30T12:27:39.556Z
9542080 9542080 20260319224751_16XbN UK0090 2026-03-21T12:29:39.502Z 2026-03-27T12:42:45.107Z
9541486 9541486 20260319204410_hUM5o UK0090 2026-03-21T12:29:00.367Z 2026-03-27T12:42:38.210Z
9531416 9531416 20260318230554_0a80A UK0090 2026-03-20T12:25:09.948Z 2026-03-26T12:39:19.265Z
9531137 9531137 20260318223507_pG3ED UK0090 2026-03-20T12:24:58.912Z 2026-03-26T12:39:17.682Z
9530731 9530731 20260318213338_gZ795 UK0090 2026-03-20T12:24:44.446Z 2026-03-26T12:39:15.036Z
9530373 9530373 20260318204410_tO8p6 UK0090 2026-03-20T12:24:19.978Z 2026-03-26T12:39:11.582Z
9529800 9529800 20260318193315_Reaw7 UK0090 2026-03-20T12:23:39.566Z 2026-03-26T12:39:06.641Z
9521864 9521864 20260319045001_9BncR UK0090 2026-03-20T12:08:40.956Z 2026-03-27T12:41:11.387Z
9520632 9520632 20260319032917_l1QVM UK0090 2026-03-20T12:06:43.135Z 2026-03-27T12:40:45.692Z
9520539 9520539 20260319032150_oYxSL UK0090 2026-03-20T12:06:31.030Z 2026-03-27T12:40:44.536Z
9520315 9520315 20260319031014_O53tf UK0090 2026-03-20T12:06:13.577Z 2026-03-27T12:40:41.974Z
9520272 9520272 20260319030722_dWWnb UK0090 2026-03-20T12:06:06.535Z 2026-03-27T12:40:41.358Z
9519977 9519977 20260319024642_bWJc6 UK0090 2026-03-20T12:05:28.401Z 2026-03-27T12:40:37.625Z
9519564 9519564 20260319021714_EWIv4 UK0090 2026-03-20T12:04:39.169Z 2026-03-27T12:40:32.536Z
9519197 9519197 20260319015416_M2G9N UK0090 2026-03-20T12:04:05.000Z 2026-03-27T12:40:18.961Z
9518293 9518293 20260319004739_LQAlu UK0090 2026-03-20T12:02:15.964Z 2026-03-27T12:40:08.230Z
9517711 9517711 20260318235627_FNwcz UK0090 2026-03-20T12:01:04.370Z 2026-03-27T12:40:02.536Z
9517377 9517377 20260318232103_0CmWQ UK0090 2026-03-20T12:00:14.533Z 2026-03-27T12:39:58.835Z
9516403 9516403 20260317204530_9U9VL UK0090 2026-03-19T12:26:08.047Z 2026-03-25T12:42:57.937Z
9516364 9516364 20260317203825_M5hJ1 UK0090 2026-03-19T12:26:04.025Z 2026-03-25T12:42:54.619Z
9511552 9511552 20260318040114_wjY0U UK0090 2026-03-19T12:10:27.368Z 2026-03-26T12:37:37.816Z
9511102 9511102 20260318033611_pwqq4 UK0090 2026-03-19T12:09:28.521Z 2026-03-26T12:37:20.426Z
9510513 9510513 20260318025645_Knt5a UK0090 2026-03-19T12:07:50.884Z 2026-03-26T12:37:13.445Z
9510511 9510511 20260318025645_cWcJd UK0090 2026-03-19T12:07:50.488Z 2026-03-26T12:37:13.119Z
9509875 9509875 20260318021935_Fn57z UK0090 2026-03-19T12:06:23.279Z 2026-03-26T12:37:08.326Z
9509857 9509857 20260318021934_3ex93 UK0090 2026-03-19T12:06:22.774Z 2026-03-26T12:37:08.325Z
9509668 9509668 20260318020609_F71Jc UK0090 2026-03-19T12:05:56.021Z 2026-03-26T12:37:06.930Z
9509602 9509602 20260318020031_0fh7o UK0090 2026-03-19T12:05:45.599Z 2026-03-26T12:37:06.612Z
9509521 9509521 20260318015541_FKx8B UK0090 2026-03-19T12:05:31.728Z 2026-03-26T12:37:05.999Z
9509517 9509517 20260318015541_gGK1I UK0090 2026-03-19T12:05:31.269Z 2026-03-26T12:37:05.964Z
9508507 9508507 20260318010218_bpybM UK0090 2026-03-19T12:03:15.878Z 2026-03-26T12:36:59.124Z
9508501 9508501 20260318010218_0EYk5 UK0090 2026-03-19T12:03:15.652Z 2026-03-26T12:36:59.108Z
9508319 9508319 20260318004511_JM2j2 UK0090 2026-03-19T12:02:52.135Z 2026-03-26T12:36:57.724Z
9508257 9508257 20260318003749_fk3YI UK0090 2026-03-19T12:02:45.100Z 2026-03-26T12:36:57.372Z
9508116 9508116 20260318001853_Z2oGL UK0090 2026-03-19T12:02:17.211Z 2026-03-26T12:36:55.971Z
9507940 9507940 20260317235640_Tt2sG UK0090 2026-03-19T12:01:45.006Z 2026-03-26T12:36:54.580Z
9507480 9507480 20260317230934_rHY95 UK0090 2026-03-19T12:00:15.149Z 2026-03-26T12:36:37.285Z
9507473 9507473 20260317230849_13g7N UK0090 2026-03-19T12:00:13.100Z 2026-03-26T12:36:37.199Z
9501622 9501622 20260315225347_MhF67 UK0090 2026-03-17T12:25:19.863Z 2026-03-23T12:22:45.230Z
9501593 9501593 20260315224725_hmZW7 UK0090 2026-03-17T12:25:16.826Z 2026-03-23T12:22:45.036Z
9501558 9501558 20260315223935_cGISb UK0090 2026-03-17T12:25:14.096Z 2026-03-23T12:22:44.878Z
9501060 9501060 20260315204842_Y7P4j UK0090 2026-03-17T12:24:21.701Z 2026-03-23T12:22:42.868Z
9501000 9501000 20260315203453_KOERs UK0090 2026-03-17T12:24:16.904Z 2026-03-23T12:22:42.706Z
9494302 9494302 20260316015320_jTuO8 UK0090 2026-03-17T12:03:34.438Z 2026-03-24T12:40:46.745Z
9494259 9494259 20260316014554_3JBP2 UK0090 2026-03-17T12:03:27.483Z 2026-03-24T12:40:46.315Z
9494178 9494178 20260316013530_r4ARU UK0090 2026-03-17T12:03:12.630Z 2026-03-24T12:40:44.936Z
9493833 9493833 20260316004544_KwSii UK0090 2026-03-17T12:02:11.258Z 2026-03-24T12:40:42.325Z
9493277 9493277 20260315225805_a35Om UK0090 2026-03-17T12:00:11.210Z 2026-03-24T12:40:38.224Z
9477032 9477032 20260314040759_Zp2q8 UK0090 2026-03-15T12:07:29.924Z 2026-03-22T12:42:00.794Z
9477002 9477002 20260314040501_7W9DB UK0090 2026-03-15T12:07:24.521Z 2026-03-22T12:42:00.529Z
9476934 9476934 20260314035655_AgNvw UK0090 2026-03-15T12:07:15.164Z 2026-03-22T12:42:00.259Z
9476097 9476097 20260314023753_peYTt UK0090 2026-03-15T12:05:04.800Z 2026-03-22T12:41:54.240Z
9475533 9475533 20260314013723_fypEX UK0090 2026-03-15T12:03:23.751Z 2026-03-22T12:41:41.910Z
9470059 9470059 20260313042640_li9Wq UK0090 2026-03-14T12:06:21.732Z 2026-03-21T12:49:05.505Z
9470030 9470030 20260313042136_sawBP UK0090 2026-03-14T12:06:16.437Z 2026-03-21T12:49:05.248Z
9469932 9469932 20260313040517_Cs7P9 UK0090 2026-03-14T12:06:00.437Z 2026-03-21T12:49:04.401Z
9469874 9469874 20260313035543_2FHk9 UK0090 2026-03-14T12:05:47.710Z 2026-03-21T12:49:03.498Z
9469807 9469807 20260313034558_fGTDX UK0090 2026-03-14T12:05:35.801Z 2026-03-21T12:49:02.474Z
9469688 9469688 20260313032947_sC2ED UK0090 2026-03-14T12:05:13.594Z 2026-03-21T12:49:00.588Z
9469627 9469627 20260313032127_JsKXT UK0090 2026-03-14T12:05:00.459Z 2026-03-21T12:48:52.903Z
9469553 9469553 20260313030836_ejGrK UK0090 2026-03-14T12:04:43.798Z 2026-03-21T12:48:41.693Z
9457707 9457707 20260311045635_7JMjk UK0090 2026-03-12T12:04:24.619Z 2026-03-19T12:44:51.197Z
9457664 9457664 20260311044520_AOJKR UK0090 2026-03-12T12:04:20.511Z 2026-03-19T12:44:50.493Z
9457536 9457536 20260311041212_OyTe5 UK0090 2026-03-12T12:04:00.907Z 2026-03-19T12:44:46.544Z
9457455 9457455 20260311040055_ofgUe UK0090 2026-03-12T12:03:52.662Z 2026-03-19T12:44:44.087Z
9457346 9457346 20260311033931_QXbhN UK0090 2026-03-12T12:03:37.570Z 2026-03-19T12:44:39.872Z
9457307 9457307 20260311032608_VsbYO UK0090 2026-03-12T12:03:31.669Z 2026-03-19T12:44:37.195Z
9457233 9457233 20260311030911_63ror UK0090 2026-03-12T12:03:16.414Z 2026-03-19T12:44:34.271Z
9430700 9430700 20260304203617_URuZV UK0090 2026-03-06T14:24:02.428Z 2026-03-12T12:33:40.272Z

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