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,793 rows where station_code = "UK00BA" 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
9273311 9273311 20260128053654_Z7VXr UK00BA 2026-01-29T14:29:18.628Z 2026-01-29T14:30:25.785Z
9260572 9260572 20260125053225_ERTut UK00BA 2026-01-26T14:22:26.215Z 2026-01-29T14:44:28.213Z
9260559 9260559 20260125052752_7nruR UK00BA 2026-01-26T14:22:23.474Z 2026-01-29T14:44:27.413Z
9260485 9260485 20260125044802_psI02 UK00BA 2026-01-26T14:21:57.130Z 2026-01-29T14:44:17.588Z
9260481 9260481 20260125044431_EnQgq UK00BA 2026-01-26T14:21:56.708Z 2026-01-29T14:44:17.428Z
9260378 9260378 20260125040656_fYVvC UK00BA 2026-01-26T14:21:27.528Z 2026-01-29T14:44:09.155Z
9260257 9260257 20260125031517_sL5i3 UK00BA 2026-01-26T14:20:56.942Z 2026-01-29T14:44:02.284Z
9260123 9260123 20260125023834_Lwd8n UK00BA 2026-01-26T14:20:20.692Z 2026-01-29T14:43:49.785Z
9252501 9252501 20260123034057_9NHyi UK00BA 2026-01-24T14:15:53.906Z 2026-01-29T14:53:04.599Z
9252456 9252456 20260123031522_Me0rI UK00BA 2026-01-24T14:15:40.468Z 2026-01-29T14:52:55.031Z
9252373 9252373 20260123023336_HuOr3 UK00BA 2026-01-24T14:15:16.605Z 2026-01-29T14:52:47.131Z
9252283 9252283 20260123020334_3vc0Y UK00BA 2026-01-24T14:14:54.388Z 2026-01-29T14:52:43.327Z
9252261 9252261 20260123015825_BM058 UK00BA 2026-01-24T14:14:52.425Z 2026-01-29T14:52:42.585Z
9251831 9251831 20260122231805_Lt9JM UK00BA 2026-01-24T14:13:20.556Z 2026-01-29T14:52:12.129Z
9251824 9251824 20260122231717_CAGTo UK00BA 2026-01-24T14:13:20.101Z 2026-01-29T14:52:11.840Z
9251796 9251796 20260122225719_bDuWd UK00BA 2026-01-24T14:13:15.592Z 2026-01-29T14:52:10.505Z
9251719 9251719 20260122221140_gZzQY UK00BA 2026-01-24T14:12:59.774Z 2026-01-29T14:52:04.468Z
9251669 9251669 20260122214926_2PFSM UK00BA 2026-01-24T14:12:44.346Z 2026-01-29T14:51:57.815Z
9251650 9251650 20260122214505_SnNQK UK00BA 2026-01-24T14:12:42.689Z 2026-01-29T14:51:57.115Z
9251638 9251638 20260122214242_dfOYM UK00BA 2026-01-24T14:12:41.526Z 2026-01-29T14:51:56.831Z
9251326 9251326 20260122194210_X1Z5x UK00BA 2026-01-24T14:11:17.721Z 2026-01-29T14:51:28.930Z
9242754 9242754 20260121023919_6MEO0 UK00BA 2026-01-22T14:19:08.183Z 2026-01-29T15:04:19.543Z
9242730 9242730 20260121023714_O12oR UK00BA 2026-01-22T14:19:03.872Z 2026-01-29T15:04:18.483Z
9242713 9242713 20260121023641_KEdSz UK00BA 2026-01-22T14:19:02.217Z 2026-01-29T15:04:18.112Z
9242654 9242654 20260121023001_Qc07M UK00BA 2026-01-22T14:18:40.935Z 2026-01-29T15:04:15.678Z
9242599 9242599 20260121022336_Evb5a UK00BA 2026-01-22T14:18:31.078Z 2026-01-29T15:04:13.148Z
9242550 9242550 20260121021227_yC73t UK00BA 2026-01-22T14:18:22.616Z 2026-01-29T15:04:06.845Z
9242465 9242465 20260121015518_oWcbU UK00BA 2026-01-22T14:17:55.764Z 2026-01-29T15:03:59.727Z
9242446 9242446 20260121015135_e5HDT UK00BA 2026-01-22T14:17:52.394Z 2026-01-29T15:03:58.994Z
9242351 9242351 20260121013619_GGGxl UK00BA 2026-01-22T14:17:26.469Z 2026-01-29T15:03:45.533Z
9242346 9242346 20260121013507_f5JP2 UK00BA 2026-01-22T14:17:25.142Z 2026-01-29T15:03:45.278Z
9242019 9242019 20260121000224_l8wI2 UK00BA 2026-01-22T14:15:52.212Z 2026-01-29T15:03:25.331Z
9242010 9242010 20260121000033_aRHog UK00BA 2026-01-22T14:15:50.619Z 2026-01-29T15:03:24.989Z
9241981 9241981 20260120234854_6Hks4 UK00BA 2026-01-22T14:15:38.453Z 2026-01-29T15:03:20.392Z
9237904 9237904 20260120062149_RDlih UK00BA 2026-01-21T14:28:01.812Z 2026-01-28T15:01:58.222Z
9237762 9237762 20260120060059_Jw1oo UK00BA 2026-01-21T14:27:35.738Z 2026-01-28T15:01:39.773Z
9237413 9237413 20260120051517_5zsXB UK00BA 2026-01-21T14:26:27.434Z 2026-01-28T15:01:24.573Z
9236493 9236493 20260120032640_JI4Fi UK00BA 2026-01-21T14:22:58.578Z 2026-01-28T15:00:04.871Z
9236047 9236047 20260120023005_pp0P9 UK00BA 2026-01-21T14:21:18.897Z 2026-01-28T14:59:42.361Z
9234144 9234144 20260119194747_SSOcv UK00BA 2026-01-21T14:12:32.341Z 2026-01-28T14:57:17.365Z
9222857 9222857 20260117210603_IMVZ5 UK00BA 2026-01-19T14:16:35.463Z 2026-01-26T15:01:23.538Z
9222683 9222683 20260117201902_iUEj5 UK00BA 2026-01-19T14:15:48.360Z 2026-01-26T15:01:17.150Z
9222231 9222231 20260117184453_XUQd4 UK00BA 2026-01-19T14:13:52.253Z 2026-01-26T15:00:44.602Z
9222140 9222140 20260117182508_ARWd1 UK00BA 2026-01-19T14:13:28.094Z 2026-01-26T15:00:41.369Z
9222060 9222060 20260117175457_o3RJn UK00BA 2026-01-19T14:13:01.996Z 2026-01-26T15:00:36.415Z
9222003 9222003 20260117174447_qX2NN UK00BA 2026-01-19T14:12:51.640Z 2026-01-26T15:00:34.152Z
9218964 9218964 20260117064631_auPyf UK00BA 2026-01-18T14:14:24.771Z 2026-01-25T14:58:56.728Z
9218959 9218959 20260117064519_8odQS UK00BA 2026-01-18T14:14:24.035Z 2026-01-25T14:58:56.668Z
9218071 9218071 20260116232829_g3iNL UK00BA 2026-01-18T14:10:17.765Z 2026-01-25T14:57:57.505Z
9214413 9214413 20260116062942_3RuP5 UK00BA 2026-01-17T14:21:26.707Z 2026-01-24T15:13:35.657Z
9214410 9214410 20260116062941_Lfo9V UK00BA 2026-01-17T14:21:26.261Z 2026-01-24T15:13:35.491Z
9214395 9214395 20260116062737_0Ao3c UK00BA 2026-01-17T14:21:19.937Z 2026-01-24T15:13:33.816Z
9214219 9214219 20260116055440_8hN1N UK00BA 2026-01-17T14:20:37.082Z 2026-01-24T15:13:23.280Z
9214173 9214173 20260116054849_tzbVb UK00BA 2026-01-17T14:20:26.717Z 2026-01-24T15:13:19.799Z
9213949 9213949 20260116050457_QNXb7 UK00BA 2026-01-17T14:19:18.456Z 2026-01-24T15:12:53.165Z
9213819 9213819 20260116044634_2ujlL UK00BA 2026-01-17T14:18:41.086Z 2026-01-24T15:12:47.836Z
9213589 9213589 20260116040514_2TZcG UK00BA 2026-01-17T14:17:40.540Z 2026-01-24T15:12:23.399Z
9212664 9212664 20260116001117_aqc5M UK00BA 2026-01-17T14:13:10.802Z 2026-01-24T15:11:09.267Z
9212561 9212561 20260115231237_W3E98 UK00BA 2026-01-17T14:12:42.431Z 2026-01-24T15:11:03.163Z
9204547 9204547 20260114065952_PqwYh UK00BA 2026-01-15T14:27:33.447Z 2026-01-22T15:10:36.739Z
9204535 9204535 20260114065804_3Pa3D UK00BA 2026-01-15T14:27:31.804Z 2026-01-22T15:10:34.100Z
9204485 9204485 20260114064732_HmOTB UK00BA 2026-01-15T14:27:25.941Z 2026-01-22T15:10:29.581Z
9204196 9204196 20260114061452_ru2rd UK00BA 2026-01-15T14:26:38.829Z 2026-01-22T15:10:22.102Z
9204105 9204105 20260114060718_g1z9I UK00BA 2026-01-15T14:26:25.021Z 2026-01-22T15:10:18.104Z
9203923 9203923 20260114055531_MT3cY UK00BA 2026-01-15T14:25:52.992Z 2026-01-22T15:10:15.720Z
9203907 9203907 20260114055221_Vgrup UK00BA 2026-01-15T14:25:50.313Z 2026-01-22T15:10:15.386Z
9203291 9203291 20260114044921_1oVNH UK00BA 2026-01-15T14:23:59.125Z 2026-01-22T15:10:05.130Z
9203096 9203096 20260114043249_jetAf UK00BA 2026-01-15T14:23:17.615Z 2026-01-22T15:10:01.407Z
9203047 9203047 20260114043023_V1nJT UK00BA 2026-01-15T14:23:13.574Z 2026-01-22T15:10:01.093Z
9202736 9202736 20260114040637_kfNnc UK00BA 2026-01-15T14:22:16.406Z 2026-01-22T15:09:34.290Z
9202620 9202620 20260114035448_Mv7CJ UK00BA 2026-01-15T14:21:47.207Z 2026-01-22T15:09:23.712Z
9202525 9202525 20260114034432_FOhnA UK00BA 2026-01-15T14:21:34.365Z 2026-01-22T15:09:21.688Z
9202491 9202491 20260114034225_L8opz UK00BA 2026-01-15T14:21:31.052Z 2026-01-22T15:09:21.267Z
9202307 9202307 20260114032713_xoe10 UK00BA 2026-01-15T14:21:02.377Z 2026-01-22T15:09:16.135Z
9202275 9202275 20260114032506_iolXY UK00BA 2026-01-15T14:20:50.562Z 2026-01-22T15:09:15.443Z
9202240 9202240 20260114032429_gSKye UK00BA 2026-01-15T14:20:44.073Z 2026-01-22T15:09:15.124Z
9202145 9202145 20260114032011_msxWS UK00BA 2026-01-15T14:20:35.093Z 2026-01-22T15:09:14.061Z
9201948 9201948 20260114030717_F9aeY UK00BA 2026-01-15T14:20:09.975Z 2026-01-22T15:09:11.652Z
9201896 9201896 20260114030441_gLeWu UK00BA 2026-01-15T14:20:05.084Z 2026-01-22T15:09:11.080Z
9201864 9201864 20260114030251_IHKaC UK00BA 2026-01-15T14:19:56.713Z 2026-01-22T15:09:10.841Z
9201844 9201844 20260114025833_77bBR UK00BA 2026-01-15T14:19:53.953Z 2026-01-22T15:09:10.470Z
9201756 9201756 20260114024811_UZzPQ UK00BA 2026-01-15T14:19:39.604Z 2026-01-22T15:09:09.043Z
9201655 9201655 20260114023743_A0fL9 UK00BA 2026-01-15T14:19:14.186Z 2026-01-22T15:09:07.010Z
9201631 9201631 20260114023654_8O5e2 UK00BA 2026-01-15T14:19:13.097Z 2026-01-22T15:09:06.884Z
9201487 9201487 20260114022028_Yi6z0 UK00BA 2026-01-15T14:18:42.930Z 2026-01-22T15:09:04.278Z
9201260 9201260 20260114020217_TyLM9 UK00BA 2026-01-15T14:18:06.102Z 2026-01-22T15:09:00.678Z
9201188 9201188 20260114015341_crS3U UK00BA 2026-01-15T14:17:45.041Z 2026-01-22T15:08:59.204Z
9201124 9201124 20260114014645_U3Z0P UK00BA 2026-01-15T14:17:35.612Z 2026-01-22T15:08:58.042Z
9200730 9200730 20260114005733_L6PKz UK00BA 2026-01-15T14:16:14.536Z 2026-01-22T15:08:24.740Z
9200538 9200538 20260114002153_CuP7z UK00BA 2026-01-15T14:15:29.310Z 2026-01-22T15:08:17.954Z
9200502 9200502 20260114001412_WUk6Y UK00BA 2026-01-15T14:15:21.245Z 2026-01-22T15:08:17.091Z
9200422 9200422 20260114000624_x1VEn UK00BA 2026-01-15T14:15:10.540Z 2026-01-22T15:08:15.738Z
9200232 9200232 20260113232117_IDN9N UK00BA 2026-01-15T14:14:17.739Z 2026-01-22T15:08:11.911Z
9200177 9200177 20260113230253_sClSF UK00BA 2026-01-15T14:14:05.398Z 2026-01-22T15:08:10.759Z
9199348 9199348 20260113194737_A7m7N UK00BA 2026-01-15T14:10:28.734Z 2026-01-22T15:07:22.377Z
9199232 9199232 20260113193054_FLTIr UK00BA 2026-01-15T14:10:03.101Z 2026-01-22T15:07:17.651Z
9199123 9199123 20260113190724_bEq7D UK00BA 2026-01-15T14:09:19.943Z 2026-01-22T15:07:14.491Z
9195374 9195374 20260113011330_K2N2w UK00BA 2026-01-14T14:13:05.908Z 2026-01-21T15:04:39.646Z
9195127 9195127 20260113002417_ih23J UK00BA 2026-01-14T14:12:06.266Z 2026-01-21T15:04:36.649Z
9194670 9194670 20260112214350_sCU33 UK00BA 2026-01-14T14:10:12.999Z 2026-01-21T15:04:19.749Z

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