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

7,317 rows where station_code = "UK0083" 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
9273512 9273512 20260128064756_x23gd UK0083 2026-01-29T14:30:02.475Z 2026-01-29T14:30:25.827Z
9273487 9273487 20260128063141_Px5G3 UK0083 2026-01-29T14:29:59.877Z 2026-01-29T14:30:25.823Z
9273420 9273420 20260128060825_bc7FB UK0083 2026-01-29T14:29:43.756Z 2026-01-29T14:30:25.807Z
9272424 9272424 20260128020533_Ei6a5 UK0083 2026-01-29T14:26:37.908Z 2026-01-29T14:30:25.344Z
9271892 9271892 20260127214109_c9KsP UK0083 2026-01-29T14:24:52.689Z 2026-01-29T14:30:25.227Z
9271847 9271847 20260127205625_FSrZ2 UK0083 2026-01-29T14:24:26.454Z 2026-01-29T14:30:25.209Z
9213093 9213093 20260116020931_m452d UK0083 2026-01-17T14:15:24.033Z 2026-01-24T15:11:40.428Z
9213049 9213049 20260116020150_jUNiI UK0083 2026-01-17T14:15:09.587Z 2026-01-24T15:11:38.570Z
9208231 9208231 20260115044228_BbYnv UK0083 2026-01-16T14:11:48.402Z 2026-01-22T15:04:05.026Z
9207268 9207268 20260115003200_uoJde UK0083 2026-01-16T14:08:02.102Z 2026-01-22T15:03:16.920Z
9204425 9204425 20260114063759_qeh7L UK0083 2026-01-15T14:27:15.061Z 2026-01-22T15:10:27.745Z
9204049 9204049 20260114060430_kBXtr UK0083 2026-01-15T14:26:19.421Z 2026-01-22T15:10:17.372Z
9203707 9203707 20260114053054_LRhQ6 UK0083 2026-01-15T14:25:13.461Z 2026-01-22T15:10:12.549Z
9203665 9203665 20260114052749_WXTjM UK0083 2026-01-15T14:25:08.295Z 2026-01-22T15:10:11.767Z
9203494 9203494 20260114050910_VM62F UK0083 2026-01-15T14:24:34.192Z 2026-01-22T15:10:08.703Z
9203321 9203321 20260114045027_qyXsS UK0083 2026-01-15T14:24:03.483Z 2026-01-22T15:10:05.701Z
9203231 9203231 20260114044407_3b1Kl UK0083 2026-01-15T14:23:52.535Z 2026-01-22T15:10:04.180Z
9203064 9203064 20260114043113_ai005 UK0083 2026-01-15T14:23:14.691Z 2026-01-22T15:10:01.153Z
9202921 9202921 20260114041838_TSxdt UK0083 2026-01-15T14:22:48.384Z 2026-01-22T15:09:59.434Z
9202793 9202793 20260114040826_l5qbF UK0083 2026-01-15T14:22:21.995Z 2026-01-22T15:09:41.110Z
9202671 9202671 20260114035955_DWOnW UK0083 2026-01-15T14:22:05.953Z 2026-01-22T15:09:24.604Z
9202227 9202227 20260114032429_hg2mX UK0083 2026-01-15T14:20:43.577Z 2026-01-22T15:09:15.078Z
9202049 9202049 20260114031230_ZqlFv UK0083 2026-01-15T14:20:17.293Z 2026-01-22T15:09:12.405Z
9201791 9201791 20260114025316_wiYvW UK0083 2026-01-15T14:19:45.305Z 2026-01-22T15:09:09.820Z
9201764 9201764 20260114024813_80hlf UK0083 2026-01-15T14:19:40.025Z 2026-01-22T15:09:09.127Z
9201679 9201679 20260114024103_opGwK UK0083 2026-01-15T14:19:16.775Z 2026-01-22T15:09:07.294Z
9201472 9201472 20260114022026_nrLPh UK0083 2026-01-15T14:18:42.362Z 2026-01-22T15:09:04.227Z
9201328 9201328 20260114021037_v1HXK UK0083 2026-01-15T14:18:16.849Z 2026-01-22T15:09:01.968Z
9201132 9201132 20260114014646_tisYl UK0083 2026-01-15T14:17:36.106Z 2026-01-22T15:08:58.071Z
9201094 9201094 20260114014246_p5T7e UK0083 2026-01-15T14:17:33.405Z 2026-01-22T15:08:57.718Z
9201072 9201072 20260114014013_fMuK9 UK0083 2026-01-15T14:17:31.660Z 2026-01-22T15:08:57.508Z
9200950 9200950 20260114012554_VgaJw UK0083 2026-01-15T14:17:06.074Z 2026-01-22T15:08:40.649Z
9200596 9200596 20260114003009_l1jPS UK0083 2026-01-15T14:15:42.944Z 2026-01-22T15:08:21.341Z
9200555 9200555 20260114002415_jII8o UK0083 2026-01-15T14:15:35.498Z 2026-01-22T15:08:18.238Z
9200451 9200451 20260114001234_63k2I UK0083 2026-01-15T14:15:14.526Z 2026-01-22T15:08:16.216Z
9200412 9200412 20260114000623_DX36d UK0083 2026-01-15T14:15:10.035Z 2026-01-22T15:08:15.697Z
9200185 9200185 20260113230741_fQ0YU UK0083 2026-01-15T14:14:07.589Z 2026-01-22T15:08:10.936Z
9200075 9200075 20260113224721_e4dHi UK0083 2026-01-15T14:13:42.615Z 2026-01-22T15:08:09.127Z
9200049 9200049 20260113224117_r93FR UK0083 2026-01-15T14:13:39.732Z 2026-01-22T15:08:08.745Z
9199726 9199726 20260113210733_boc2I UK0083 2026-01-15T14:12:08.449Z 2026-01-22T15:08:00.530Z
9199407 9199407 20260113195610_qrzIQ UK0083 2026-01-15T14:10:43.673Z 2026-01-22T15:07:23.600Z
9199338 9199338 20260113194737_1soDa UK0083 2026-01-15T14:10:28.053Z 2026-01-22T15:07:22.293Z
9195648 9195648 20260113021057_OPhUI UK0083 2026-01-14T14:14:16.454Z 2026-01-21T15:04:44.986Z
9195409 9195409 20260113012021_7qNk6 UK0083 2026-01-14T14:13:12.282Z 2026-01-21T15:04:40.104Z
9195383 9195383 20260113011606_Z6L2M UK0083 2026-01-14T14:13:07.160Z 2026-01-21T15:04:39.733Z
9195372 9195372 20260113011330_K2N2w UK0083 2026-01-14T14:13:05.908Z 2026-01-21T15:04:39.646Z
9195223 9195223 20260113004227_298kX UK0083 2026-01-14T14:12:26.057Z 2026-01-21T15:04:37.653Z
9195058 9195058 20260113000854_qBOA3 UK0083 2026-01-14T14:11:51.655Z 2026-01-21T15:04:35.680Z
9194719 9194719 20260112221653_pm5Hh UK0083 2026-01-14T14:10:23.951Z 2026-01-21T15:04:20.310Z
9194668 9194668 20260112214350_sCU33 UK0083 2026-01-14T14:10:12.969Z 2026-01-21T15:04:19.749Z
9189241 9189241 20260112033940_jdOmJ UK0083 2026-01-13T14:16:33.480Z 2026-01-20T15:22:59.062Z
9189221 9189221 20260112033253_LxOPt UK0083 2026-01-13T14:16:29.094Z 2026-01-20T15:22:57.841Z
9176996 9176996 20260110065520_8xspx UK0083 2026-01-11T14:10:34.809Z 2026-01-18T15:09:10.591Z
9176783 9176783 20260110062238_MWiLV UK0083 2026-01-11T14:09:58.794Z 2026-01-18T15:08:54.142Z
9176662 9176662 20260110060306_sLZ1p UK0083 2026-01-11T14:09:40.198Z 2026-01-18T15:08:48.151Z
9176660 9176660 20260110060239_I6Ncs UK0083 2026-01-11T14:09:39.675Z 2026-01-18T15:08:47.997Z
9176454 9176454 20260110053154_7cA0W UK0083 2026-01-11T14:09:05.042Z 2026-01-18T15:08:39.839Z
9176434 9176434 20260110052946_p1mUg UK0083 2026-01-11T14:09:00.905Z 2026-01-18T15:08:39.098Z
9176179 9176179 20260110045843_PNX7y UK0083 2026-01-11T14:08:23.189Z 2026-01-18T15:08:23.069Z
9176101 9176101 20260110044600_sXHXD UK0083 2026-01-11T14:08:11.741Z 2026-01-18T15:08:19.278Z
9175985 9175985 20260110043321_U2fkq UK0083 2026-01-11T14:07:57.919Z 2026-01-18T15:08:15.760Z
9175954 9175954 20260110042715_0gjns UK0083 2026-01-11T14:07:52.914Z 2026-01-18T15:08:14.636Z
9175660 9175660 20260110032155_ZpT80 UK0083 2026-01-11T14:07:00.927Z 2026-01-18T15:07:55.307Z
9175605 9175605 20260110031035_SbOVW UK0083 2026-01-11T14:06:53.469Z 2026-01-18T15:07:53.262Z
9175463 9175463 20260110023310_BAPdp UK0083 2026-01-11T14:06:29.592Z 2026-01-18T15:07:46.577Z
9175388 9175388 20260110021929_32PN2 UK0083 2026-01-11T14:06:19.299Z 2026-01-18T15:07:43.991Z
9175379 9175379 20260110021910_b0PqC UK0083 2026-01-11T14:06:18.076Z 2026-01-18T15:07:43.723Z
9175360 9175360 20260110021414_qhwIk UK0083 2026-01-11T14:06:11.735Z 2026-01-18T15:07:42.617Z
9175276 9175276 20260110015351_ajI8W UK0083 2026-01-11T14:05:56.241Z 2026-01-18T15:07:39.451Z
9175212 9175212 20260110014005_oqcPn UK0083 2026-01-11T14:05:42.550Z 2026-01-18T15:07:37.182Z
9175211 9175211 20260110014004_4wuQL UK0083 2026-01-11T14:05:41.985Z 2026-01-18T15:07:37.002Z
9175202 9175202 20260110013614_Sc5BN UK0083 2026-01-11T14:05:40.768Z 2026-01-18T15:07:36.781Z
9175055 9175055 20260110005303_E42pZ UK0083 2026-01-11T14:05:17.586Z 2026-01-18T15:07:24.527Z
9175013 9175013 20260110004558_pftd6 UK0083 2026-01-11T14:05:08.554Z 2026-01-18T15:07:22.935Z
9174738 9174738 20260109220525_tiwXi UK0083 2026-01-11T14:04:14.327Z 2026-01-18T15:07:08.713Z
9162827 9162827 20260107044125_3sQ2N UK0083 2026-01-08T14:07:01.461Z 2026-01-13T15:02:41.402Z
9162253 9162253 20260107011230_WKsrK UK0083 2026-01-08T14:03:59.629Z 2026-01-13T15:01:56.308Z
9159909 9159909 20260106041704_yB9Gw UK0083 2026-01-07T14:10:47.318Z 2026-01-13T15:08:52.658Z
9159635 9159635 20260106031744_1PWaU UK0083 2026-01-07T14:09:59.674Z 2026-01-13T15:08:34.835Z
9159280 9159280 20260106021641_BOGpP UK0083 2026-01-07T14:08:54.961Z 2026-01-13T15:08:19.783Z
9158765 9158765 20260106002334_SLuGf UK0083 2026-01-07T14:07:15.049Z 2026-01-13T15:07:45.794Z
9158377 9158377 20260105220633_Wxwh3 UK0083 2026-01-07T14:05:53.211Z 2026-01-13T15:07:19.813Z
9158343 9158343 20260105215728_fLdBD UK0083 2026-01-07T14:05:47.835Z 2026-01-13T15:07:18.892Z
9158335 9158335 20260105215559_98F9M UK0083 2026-01-07T14:05:46.338Z 2026-01-13T15:07:18.565Z
9158325 9158325 20260105215558_p36mL UK0083 2026-01-07T14:05:45.678Z 2026-01-13T15:07:18.362Z
9158299 9158299 20260105214723_3TDG2 UK0083 2026-01-07T14:05:43.142Z 2026-01-13T15:07:17.613Z
9158074 9158074 20260105195710_fZjPh UK0083 2026-01-07T14:04:44.476Z 2026-01-13T15:06:53.701Z
9153169 9153169 20260103233459_XJUg3 UK0083 2026-01-06T14:25:04.866Z 2026-01-12T15:03:34.260Z
9153127 9153127 20260103201301_q2j2P UK0083 2026-01-06T14:22:46.791Z 2026-01-12T15:01:37.621Z
9153090 9153090 20260103181033_6kyBs UK0083 2026-01-06T14:20:38.985Z 2026-01-12T14:59:35.713Z
9150794 9150794 20260105033118_ksw5R UK0083 2026-01-06T14:11:27.123Z 2026-01-13T15:14:01.522Z
9150774 9150774 20260105032735_0lUW1 UK0083 2026-01-06T14:11:20.121Z 2026-01-13T15:14:00.305Z
9150616 9150616 20260105025835_iO8lH UK0083 2026-01-06T14:10:43.911Z 2026-01-13T15:13:44.085Z
9150501 9150501 20260105023334_OvYxM UK0083 2026-01-06T14:10:15.635Z 2026-01-13T15:13:36.173Z
9148788 9148788 20260104173215_F97N6 UK0083 2026-01-06T14:02:24.284Z 2026-01-13T15:11:19.771Z
9148358 9148358 20260103174023_KgpjI UK0083 2026-01-05T14:30:26.487Z 2026-01-10T15:04:27.704Z
9148251 9148251 20260103173807_ZlGIO UK0083 2026-01-05T14:30:23.490Z 2026-01-10T15:04:24.057Z
9146061 9146061 20260104033524_XDAyz UK0083 2026-01-05T14:21:37.011Z 2026-01-12T15:08:19.019Z
9145482 9145482 20260104031759_2vGjt UK0083 2026-01-05T14:20:46.600Z 2026-01-12T15:07:50.278Z
9145277 9145277 20260104031148_EsHoa UK0083 2026-01-05T14:20:23.764Z 2026-01-12T15:07:45.441Z

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