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

5,081 rows where station_code = "UK000Y" 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
9271863 9271863 20260127211707_DsgGa UK000Y 2026-01-29T14:24:39.859Z 2026-01-29T14:30:25.216Z
9271832 9271832 20260127203419_unHB4 UK000Y 2026-01-29T14:24:09.965Z 2026-01-29T14:30:25.170Z
9271747 9271747 20260127194933_slUeQ UK000Y 2026-01-29T14:23:15.917Z 2026-01-29T14:30:25.097Z
9263388 9263388 20260124034709_4m3ID UK000Y 2026-01-27T14:27:27.748Z 2026-01-29T14:47:33.471Z
9217563 9217563 20260116175721_n6mU2 UK000Y 2026-01-18T14:07:58.460Z 2026-01-25T14:57:26.271Z
9203553 9203553 20260114051758_95CIY UK000Y 2026-01-15T14:24:47.631Z 2026-01-22T15:10:09.901Z
9203456 9203456 20260114045900_ejCGX UK000Y 2026-01-15T14:24:29.207Z 2026-01-22T15:10:08.260Z
9203330 9203330 20260114045113_c9iy4 UK000Y 2026-01-15T14:24:04.822Z 2026-01-22T15:10:05.830Z
9203198 9203198 20260114044236_WpIdz UK000Y 2026-01-15T14:23:39.527Z 2026-01-22T15:10:03.678Z
9203187 9203187 20260114044150_quUuR UK000Y 2026-01-15T14:23:36.364Z 2026-01-22T15:10:03.410Z
9203026 9203026 20260114043015_mjIIQ UK000Y 2026-01-15T14:23:11.333Z 2026-01-22T15:10:00.852Z
9202963 9202963 20260114042230_hFLkB UK000Y 2026-01-15T14:22:53.849Z 2026-01-22T15:10:00.106Z
9202873 9202873 20260114041432_JQDKp UK000Y 2026-01-15T14:22:40.978Z 2026-01-22T15:09:58.368Z
9202811 9202811 20260114041025_QFW2i UK000Y 2026-01-15T14:22:27.469Z 2026-01-22T15:09:52.264Z
9202764 9202764 20260114040800_VSFMj UK000Y 2026-01-15T14:22:19.794Z 2026-01-22T15:09:40.638Z
9202713 9202713 20260114040520_DdgJJ UK000Y 2026-01-15T14:22:13.989Z 2026-01-22T15:09:30.961Z
9202660 9202660 20260114035847_BaaGj UK000Y 2026-01-15T14:22:03.826Z 2026-01-22T15:09:24.456Z
9202555 9202555 20260114034851_s2wer UK000Y 2026-01-15T14:21:39.951Z 2026-01-22T15:09:22.920Z
9202503 9202503 20260114034410_8vkF1 UK000Y 2026-01-15T14:21:33.200Z 2026-01-22T15:09:21.543Z
9202314 9202314 20260114032847_OYN0J UK000Y 2026-01-15T14:21:03.875Z 2026-01-22T15:09:16.273Z
9201784 9201784 20260114025301_wPZwG UK000Y 2026-01-15T14:19:44.664Z 2026-01-22T15:09:09.772Z
9201495 9201495 20260114022158_V7KdN UK000Y 2026-01-15T14:18:44.518Z 2026-01-22T15:09:04.444Z
9201441 9201441 20260114021827_aLHrG UK000Y 2026-01-15T14:18:40.765Z 2026-01-22T15:09:04.029Z
9201413 9201413 20260114021606_RnSZD UK000Y 2026-01-15T14:18:36.164Z 2026-01-22T15:09:03.368Z
9201391 9201391 20260114021244_jiDzo UK000Y 2026-01-15T14:18:32.348Z 2026-01-22T15:09:02.949Z
9201360 9201360 20260114021131_Er34g UK000Y 2026-01-15T14:18:20.791Z 2026-01-22T15:09:02.300Z
9201238 9201238 20260114015924_I2G02 UK000Y 2026-01-15T14:18:02.597Z 2026-01-22T15:09:00.266Z
9201225 9201225 20260114015648_rfAMk UK000Y 2026-01-15T14:17:53.596Z 2026-01-22T15:08:59.871Z
9201027 9201027 20260114013511_Odqss UK000Y 2026-01-15T14:17:15.738Z 2026-01-22T15:08:51.157Z
9200998 9200998 20260114012905_oQFrb UK000Y 2026-01-15T14:17:11.732Z 2026-01-22T15:08:47.682Z
9200856 9200856 20260114011454_b68FL UK000Y 2026-01-15T14:16:41.786Z 2026-01-22T15:08:31.196Z
9200819 9200819 20260114010634_ySCXJ UK000Y 2026-01-15T14:16:35.426Z 2026-01-22T15:08:29.478Z
9200815 9200815 20260114010624_97AZD UK000Y 2026-01-15T14:16:34.321Z 2026-01-22T15:08:29.236Z
9200705 9200705 20260114005620_wqf84 UK000Y 2026-01-15T14:16:11.644Z 2026-01-22T15:08:24.466Z
9200700 9200700 20260114005553_L3mCD UK000Y 2026-01-15T14:16:10.547Z 2026-01-22T15:08:24.264Z
9200627 9200627 20260114003859_mrU8s UK000Y 2026-01-15T14:15:49.501Z 2026-01-22T15:08:22.175Z
9200524 9200524 20260114002025_0VB6s UK000Y 2026-01-15T14:15:27.548Z 2026-01-22T15:08:17.747Z
9200514 9200514 20260114001900_bw3sp UK000Y 2026-01-15T14:15:23.839Z 2026-01-22T15:08:17.439Z
9200471 9200471 20260114001329_F73ZG UK000Y 2026-01-15T14:15:17.284Z 2026-01-22T15:08:16.533Z
9200360 9200360 20260113235219_v5Fho UK000Y 2026-01-15T14:14:50.847Z 2026-01-22T15:08:14.637Z
9200351 9200351 20260113235103_ZyzzB UK000Y 2026-01-15T14:14:48.748Z 2026-01-22T15:08:14.468Z
9200304 9200304 20260113234053_J6dM6 UK000Y 2026-01-15T14:14:40.743Z 2026-01-22T15:08:13.622Z
9200183 9200183 20260113230612_65Oyv UK000Y 2026-01-15T14:14:06.978Z 2026-01-22T15:08:10.876Z
9200148 9200148 20260113230146_JSntF UK000Y 2026-01-15T14:14:03.489Z 2026-01-22T15:08:10.547Z
9200126 9200126 20260113225413_GAgzO UK000Y 2026-01-15T14:13:51.822Z 2026-01-22T15:08:09.909Z
9200010 9200010 20260113222252_1Qw9j UK000Y 2026-01-15T14:13:32.030Z 2026-01-22T15:08:07.700Z
9199972 9199972 20260113220716_bf5Uj UK000Y 2026-01-15T14:13:17.420Z 2026-01-22T15:08:06.817Z
9199932 9199932 20260113215851_jRo6u UK000Y 2026-01-15T14:13:06.886Z 2026-01-22T15:08:05.793Z
9199871 9199871 20260113214255_sz7n1 UK000Y 2026-01-15T14:12:54.598Z 2026-01-22T15:08:04.451Z
9199826 9199826 20260113212808_OcO2o UK000Y 2026-01-15T14:12:37.727Z 2026-01-22T15:08:03.487Z
9199709 9199709 20260113210609_YAwjB UK000Y 2026-01-15T14:12:06.851Z 2026-01-22T15:08:00.372Z
9199683 9199683 20260113205823_F6kfp UK000Y 2026-01-15T14:12:01.559Z 2026-01-22T15:07:59.630Z
9199671 9199671 20260113205800_AaAG7 UK000Y 2026-01-15T14:11:59.799Z 2026-01-22T15:07:59.511Z
9199607 9199607 20260113203535_tCyWb UK000Y 2026-01-15T14:11:39.319Z 2026-01-22T15:07:47.689Z
9199574 9199574 20260113203111_LXYFk UK000Y 2026-01-15T14:11:32.275Z 2026-01-22T15:07:35.665Z
9189386 9189386 20260112041359_YuVbC UK000Y 2026-01-13T14:17:19.884Z 2026-01-20T15:23:07.460Z
9188356 9188356 20260111225719_smTfS UK000Y 2026-01-13T14:11:53.215Z 2026-01-20T15:21:36.188Z
9176911 9176911 20260110063935_V9VS2 UK000Y 2026-01-11T14:10:20.342Z 2026-01-18T15:09:07.459Z
9176607 9176607 20260110055654_vuADD UK000Y 2026-01-11T14:09:28.770Z 2026-01-18T15:08:45.835Z
9176583 9176583 20260110054952_rIn77 UK000Y 2026-01-11T14:09:23.583Z 2026-01-18T15:08:44.872Z
9176483 9176483 20260110053725_h3Bdb UK000Y 2026-01-11T14:09:09.615Z 2026-01-18T15:08:41.106Z
9176305 9176305 20260110051248_30T0q UK000Y 2026-01-11T14:08:42.436Z 2026-01-18T15:08:33.920Z
9176289 9176289 20260110051203_GDuxm UK000Y 2026-01-11T14:08:39.236Z 2026-01-18T15:08:26.304Z
9176272 9176272 20260110051109_jZDPa UK000Y 2026-01-11T14:08:37.673Z 2026-01-18T15:08:25.865Z
9176203 9176203 20260110050238_M10mR UK000Y 2026-01-11T14:08:27.376Z 2026-01-18T15:08:23.903Z
9176031 9176031 20260110043518_n08eo UK000Y 2026-01-11T14:08:04.418Z 2026-01-18T15:08:17.308Z
9175969 9175969 20260110043142_5LKu6 UK000Y 2026-01-11T14:07:55.541Z 2026-01-18T15:08:15.231Z
9175911 9175911 20260110041549_WfCbb UK000Y 2026-01-11T14:07:46.575Z 2026-01-18T15:08:13.045Z
9175672 9175672 20260110032218_yY2fC UK000Y 2026-01-11T14:07:02.623Z 2026-01-18T15:07:55.767Z
9175639 9175639 20260110032025_zixrd UK000Y 2026-01-11T14:06:59.084Z 2026-01-18T15:07:54.517Z
9175527 9175527 20260110025101_kwyF2 UK000Y 2026-01-11T14:06:38.579Z 2026-01-18T15:07:48.946Z
9175514 9175514 20260110024059_rURoN UK000Y 2026-01-11T14:06:36.081Z 2026-01-18T15:07:47.998Z
9175512 9175512 20260110024034_tQMjz UK000Y 2026-01-11T14:06:35.580Z 2026-01-18T15:07:47.845Z
9175373 9175373 20260110021720_3Ds9S UK000Y 2026-01-11T14:06:16.207Z 2026-01-18T15:07:43.329Z
9175349 9175349 20260110021216_4rt8c UK000Y 2026-01-11T14:06:09.847Z 2026-01-18T15:07:42.062Z
9175264 9175264 20260110015326_XPl0a UK000Y 2026-01-11T14:05:54.316Z 2026-01-18T15:07:39.113Z
9175221 9175221 20260110014516_mp0NB UK000Y 2026-01-11T14:05:46.373Z 2026-01-18T15:07:37.684Z
9175125 9175125 20260110011231_TU6gJ UK000Y 2026-01-11T14:05:28.145Z 2026-01-18T15:07:26.664Z
9174990 9174990 20260110003825_eq3Wa UK000Y 2026-01-11T14:05:03.715Z 2026-01-18T15:07:20.820Z
9174971 9174971 20260110002545_tjVu4 UK000Y 2026-01-11T14:05:00.627Z 2026-01-18T15:07:19.875Z
9174922 9174922 20260110000301_iXH3K UK000Y 2026-01-11T14:04:51.695Z 2026-01-18T15:07:17.274Z
9174919 9174919 20260110000207_zUPdk UK000Y 2026-01-11T14:04:51.065Z 2026-01-18T15:07:17.135Z
9174897 9174897 20260109234840_3JsJV UK000Y 2026-01-11T14:04:46.881Z 2026-01-18T15:07:16.093Z
9174877 9174877 20260109234412_zStPl UK000Y 2026-01-11T14:04:42.099Z 2026-01-18T15:07:15.083Z
9174870 9174870 20260109234108_LVUha UK000Y 2026-01-11T14:04:40.429Z 2026-01-18T15:07:14.710Z
9174848 9174848 20260109233702_lyPsX UK000Y 2026-01-11T14:04:37.038Z 2026-01-18T15:07:13.987Z
9174698 9174698 20260109214326_nFdxx UK000Y 2026-01-11T14:04:04.903Z 2026-01-18T15:07:06.052Z
9156098 9156098 20260104064618_65l6z UK000Y 2026-01-06T14:38:33.609Z 2026-01-12T15:11:38.009Z
9155932 9155932 20260104063223_nHqVF UK000Y 2026-01-06T14:38:15.702Z 2026-01-12T15:11:32.606Z
9155121 9155121 20260104053707_zkSjd UK000Y 2026-01-06T14:36:50.764Z 2026-01-12T15:10:50.391Z
9154596 9154596 20260104050410_dJx7B UK000Y 2026-01-06T14:35:44.927Z 2026-01-12T15:10:11.479Z
9151673 9151673 20260105061655_DjjId UK000Y 2026-01-06T14:14:22.231Z 2026-01-13T15:15:00.763Z
9151488 9151488 20260105053954_16YJZ UK000Y 2026-01-06T14:13:51.490Z 2026-01-13T15:14:46.681Z
9151481 9151481 20260105053952_m2gZl UK000Y 2026-01-06T14:13:51.064Z 2026-01-13T15:14:46.507Z
9151286 9151286 20260105050905_c3MlM UK000Y 2026-01-06T14:13:12.216Z 2026-01-13T15:14:35.063Z
9151026 9151026 20260105042202_Pe7Nz UK000Y 2026-01-06T14:12:22.264Z 2026-01-13T15:14:14.296Z
9150903 9150903 20260105035818_2Lf33 UK000Y 2026-01-06T14:11:52.766Z 2026-01-13T15:14:07.590Z
9150835 9150835 20260105033843_o9Xum UK000Y 2026-01-06T14:11:36.060Z 2026-01-13T15:14:03.534Z
9150600 9150600 20260105025710_xX23Y UK000Y 2026-01-06T14:10:42.422Z 2026-01-13T15:13:43.812Z
9150552 9150552 20260105024527_sySqz UK000Y 2026-01-06T14:10:27.696Z 2026-01-13T15:13:41.119Z

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