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

>10,000 rows count all where station_code = "UK0050" 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
9204467 9204467 20260114064730_J28JA UK0050 2026-01-15T14:27:25.472Z 2026-01-22T15:10:29.417Z
9204045 9204045 20260114060430_kBXtr UK0050 2026-01-15T14:26:19.421Z 2026-01-22T15:10:17.372Z
9204034 9204034 20260114060422_n8Xx2 UK0050 2026-01-15T14:26:18.038Z 2026-01-22T15:10:17.262Z
9203702 9203702 20260114053054_LRhQ6 UK0050 2026-01-15T14:25:13.460Z 2026-01-22T15:10:12.549Z
9203663 9203663 20260114052749_WXTjM UK0050 2026-01-15T14:25:08.295Z 2026-01-22T15:10:11.767Z
9203315 9203315 20260114045027_qyXsS UK0050 2026-01-15T14:24:03.483Z 2026-01-22T15:10:05.701Z
9203260 9203260 20260114044656_C3uUu UK0050 2026-01-15T14:23:55.427Z 2026-01-22T15:10:04.642Z
9203085 9203085 20260114043249_Hdy8P UK0050 2026-01-15T14:23:17.226Z 2026-01-22T15:10:01.378Z
9203062 9203062 20260114043113_ai005 UK0050 2026-01-15T14:23:14.691Z 2026-01-22T15:10:01.153Z
9202918 9202918 20260114041838_TSxdt UK0050 2026-01-15T14:22:48.383Z 2026-01-22T15:09:59.434Z
9202791 9202791 20260114040826_l5qbF UK0050 2026-01-15T14:22:21.995Z 2026-01-22T15:09:41.110Z
9202740 9202740 20260114040637_bYouw UK0050 2026-01-15T14:22:16.931Z 2026-01-22T15:09:34.394Z
9202606 9202606 20260114035447_QpcLR UK0050 2026-01-15T14:21:46.656Z 2026-01-22T15:09:23.663Z
9202528 9202528 20260114034433_ovbaD UK0050 2026-01-15T14:21:34.875Z 2026-01-22T15:09:21.737Z
9202295 9202295 20260114032711_ICfP4 UK0050 2026-01-15T14:21:01.716Z 2026-01-22T15:09:16.126Z
9202223 9202223 20260114032429_hg2mX UK0050 2026-01-15T14:20:43.577Z 2026-01-22T15:09:15.078Z
9202199 9202199 20260114032253_tQNPN UK0050 2026-01-15T14:20:41.489Z 2026-01-22T15:09:14.791Z
9202046 9202046 20260114031230_ZqlFv UK0050 2026-01-15T14:20:17.293Z 2026-01-22T15:09:12.405Z
9201787 9201787 20260114025316_wiYvW UK0050 2026-01-15T14:19:45.305Z 2026-01-22T15:09:09.820Z
9201762 9201762 20260114024813_80hlf UK0050 2026-01-15T14:19:40.025Z 2026-01-22T15:09:09.127Z
9201467 9201467 20260114022026_nrLPh UK0050 2026-01-15T14:18:42.362Z 2026-01-22T15:09:04.227Z
9201266 9201266 20260114020217_rJ3I6 UK0050 2026-01-15T14:18:06.588Z 2026-01-22T15:09:00.738Z
9201129 9201129 20260114014646_tisYl UK0050 2026-01-15T14:17:36.105Z 2026-01-22T15:08:58.071Z
9201069 9201069 20260114014013_fMuK9 UK0050 2026-01-15T14:17:31.660Z 2026-01-22T15:08:57.508Z
9200946 9200946 20260114012554_VgaJw UK0050 2026-01-15T14:17:06.074Z 2026-01-22T15:08:40.648Z
9200553 9200553 20260114002415_jII8o UK0050 2026-01-15T14:15:35.497Z 2026-01-22T15:08:18.238Z
9200530 9200530 20260114002151_vkE8t UK0050 2026-01-15T14:15:28.654Z 2026-01-22T15:08:17.881Z
9200409 9200409 20260114000623_DX36d UK0050 2026-01-15T14:15:10.035Z 2026-01-22T15:08:15.697Z
9200072 9200072 20260113224721_e4dHi UK0050 2026-01-15T14:13:42.592Z 2026-01-22T15:08:09.127Z
9195208 9195208 20260113003847_IRcrD UK0050 2026-01-14T14:12:24.006Z 2026-01-21T15:04:37.550Z
9195111 9195111 20260113002133_Gx7C7 UK0050 2026-01-14T14:12:04.271Z 2026-01-21T15:04:36.518Z
9195056 9195056 20260113000854_qBOA3 UK0050 2026-01-14T14:11:51.655Z 2026-01-21T15:04:35.680Z
9194716 9194716 20260112221653_pm5Hh UK0050 2026-01-14T14:10:23.951Z 2026-01-21T15:04:20.310Z
9194663 9194663 20260112214350_sCU33 UK0050 2026-01-14T14:10:12.968Z 2026-01-21T15:04:19.749Z
9194419 9194419 20260112203730_CBMZz UK0050 2026-01-14T14:09:08.451Z 2026-01-21T15:03:59.458Z
9189277 9189277 20260112034506_FCF2t UK0050 2026-01-13T14:16:42.243Z 2026-01-20T15:23:01.189Z
9189240 9189240 20260112033940_jdOmJ UK0050 2026-01-13T14:16:33.479Z 2026-01-20T15:22:59.062Z
9189149 9189149 20260112031245_NQ66N UK0050 2026-01-13T14:16:05.097Z 2026-01-20T15:22:44.447Z
9176995 9176995 20260110065520_0DN4Y UK0050 2026-01-11T14:10:34.462Z 2026-01-18T15:09:10.490Z
9176987 9176987 20260110065320_88ZHV UK0050 2026-01-11T14:10:32.854Z 2026-01-18T15:09:10.016Z
9176952 9176952 20260110065205_GoU2A UK0050 2026-01-11T14:10:30.512Z 2026-01-18T15:09:09.312Z
9176789 9176789 20260110062238_bv4QL UK0050 2026-01-11T14:09:59.130Z 2026-01-18T15:08:54.228Z
9176738 9176738 20260110061458_BU3w4 UK0050 2026-01-11T14:09:50.268Z 2026-01-18T15:08:52.329Z
9176462 9176462 20260110053155_vg2OW UK0050 2026-01-11T14:09:06.109Z 2026-01-18T15:08:40.119Z
9176432 9176432 20260110052946_XEqu4 UK0050 2026-01-11T14:09:00.386Z 2026-01-18T15:08:38.994Z
9176191 9176191 20260110045941_HV0MY UK0050 2026-01-11T14:08:25.167Z 2026-01-18T15:08:23.457Z
9175668 9175668 20260110032155_lFmv6 UK0050 2026-01-11T14:07:01.322Z 2026-01-18T15:07:55.549Z
9175478 9175478 20260110023804_W2PZc UK0050 2026-01-11T14:06:31.276Z 2026-01-18T15:07:46.957Z
9175427 9175427 20260110022528_U9DXc UK0050 2026-01-11T14:06:23.616Z 2026-01-18T15:07:45.108Z
9175386 9175386 20260110021928_mFn36 UK0050 2026-01-11T14:06:18.520Z 2026-01-18T15:07:43.880Z
9175366 9175366 20260110021414_knE70 UK0050 2026-01-11T14:06:14.613Z 2026-01-18T15:07:42.801Z
9175028 9175028 20260110004758_2Wc5l UK0050 2026-01-11T14:05:12.572Z 2026-01-18T15:07:23.583Z
9175024 9175024 20260110004755_JOTvI UK0050 2026-01-11T14:05:10.677Z 2026-01-18T15:07:23.485Z
9175016 9175016 20260110004558_Nd9gC UK0050 2026-01-11T14:05:09.194Z 2026-01-18T15:07:23.057Z
9174996 9174996 20260110003945_esipw UK0050 2026-01-11T14:05:05.233Z 2026-01-18T15:07:21.136Z
9163292 9163292 20260107061719_do6d8 UK0050 2026-01-08T14:08:41.149Z 2026-01-13T15:03:08.302Z
9163209 9163209 20260107060751_CrZ2G UK0050 2026-01-08T14:08:26.735Z 2026-01-13T15:03:05.798Z
9163164 9163164 20260107060002_s8Qge UK0050 2026-01-08T14:08:17.516Z 2026-01-13T15:03:03.938Z
9163018 9163018 20260107052741_iNqdh UK0050 2026-01-08T14:07:44.784Z 2026-01-13T15:02:57.702Z
9162985 9162985 20260107052049_fQUJj UK0050 2026-01-08T14:07:39.502Z 2026-01-13T15:02:50.710Z
9162874 9162874 20260107044937_6pNMh UK0050 2026-01-08T14:07:08.455Z 2026-01-13T15:02:43.305Z
9162825 9162825 20260107044125_3sQ2N UK0050 2026-01-08T14:07:01.461Z 2026-01-13T15:02:41.402Z
9162766 9162766 20260107042229_FcMrP UK0050 2026-01-08T14:06:43.809Z 2026-01-13T15:02:37.859Z
9162747 9162747 20260107042143_gC6wl UK0050 2026-01-08T14:06:39.791Z 2026-01-13T15:02:37.264Z
9162591 9162591 20260107033914_2KYMT UK0050 2026-01-08T14:05:56.866Z 2026-01-13T15:02:20.813Z
9162520 9162520 20260107031729_OuyYA UK0050 2026-01-08T14:05:33.595Z 2026-01-13T15:02:14.842Z
9162501 9162501 20260107031028_mdffB UK0050 2026-01-08T14:05:30.463Z 2026-01-13T15:02:14.199Z
9162494 9162494 20260107030826_lUFi7 UK0050 2026-01-08T14:05:29.771Z 2026-01-13T15:02:14.021Z
9159953 9159953 20260106042141_zHoGU UK0050 2026-01-07T14:10:56.360Z 2026-01-13T15:08:54.261Z
9159904 9159904 20260106041704_yB9Gw UK0050 2026-01-07T14:10:47.318Z 2026-01-13T15:08:52.658Z
9159812 9159812 20260106035651_RbdNl UK0050 2026-01-07T14:10:30.365Z 2026-01-13T15:08:48.562Z
9159631 9159631 20260106031744_1PWaU UK0050 2026-01-07T14:09:59.674Z 2026-01-13T15:08:34.835Z
9159513 9159513 20260106025621_pU7Zo UK0050 2026-01-07T14:09:35.053Z 2026-01-13T15:08:28.537Z
9159450 9159450 20260106024355_7aSuM UK0050 2026-01-07T14:09:21.390Z 2026-01-13T15:08:26.481Z
9158763 9158763 20260106002334_SLuGf UK0050 2026-01-07T14:07:15.049Z 2026-01-13T15:07:45.793Z
9158340 9158340 20260105215728_fLdBD UK0050 2026-01-07T14:05:47.835Z 2026-01-13T15:07:18.892Z
9158295 9158295 20260105214723_3TDG2 UK0050 2026-01-07T14:05:43.135Z 2026-01-13T15:07:17.613Z
9158072 9158072 20260105195710_fZjPh UK0050 2026-01-07T14:04:44.476Z 2026-01-13T15:06:53.701Z
9157776 9157776 20260105184623_N3pGX UK0050 2026-01-07T14:03:33.627Z 2026-01-13T15:06:29.024Z
9157684 9157684 20260105182430_aVuu7 UK0050 2026-01-07T14:03:11.043Z 2026-01-13T15:06:24.280Z
9153100 9153100 20260103182255_CWpqs UK0050 2026-01-06T14:20:57.373Z 2026-01-12T14:59:50.389Z
9151407 9151407 20260105052851_HCS3Q UK0050 2026-01-06T14:13:35.927Z 2026-01-13T15:14:41.501Z
9151343 9151343 20260105052013_5mBOt UK0050 2026-01-06T14:13:24.622Z 2026-01-13T15:14:38.744Z
9151326 9151326 20260105051721_AdFNV UK0050 2026-01-06T14:13:22.151Z 2026-01-13T15:14:38.028Z
9151279 9151279 20260105050905_TVUtC UK0050 2026-01-06T14:13:11.564Z 2026-01-13T15:14:34.874Z
9149560 9149560 20260104215549_04Vnm UK0050 2026-01-06T14:06:03.939Z 2026-01-13T15:12:18.302Z
9149505 9149505 20260104213258_82Krm UK0050 2026-01-06T14:05:46.696Z 2026-01-13T15:12:14.956Z
9149330 9149330 20260104201155_79VR9 UK0050 2026-01-06T14:05:02.188Z 2026-01-13T15:12:05.036Z
9146392 9146392 20260104034756_Q235q UK0050 2026-01-05T14:22:11.182Z 2026-01-12T15:08:27.440Z
9145491 9145491 20260104031759_ytJfj UK0050 2026-01-05T14:20:46.796Z 2026-01-12T15:07:50.320Z
9145274 9145274 20260104031148_EsHoa UK0050 2026-01-05T14:20:23.764Z 2026-01-12T15:07:45.440Z
9145209 9145209 20260104030819_EkNQW UK0050 2026-01-05T14:20:18.177Z 2026-01-12T15:07:43.902Z
9145177 9145177 20260104030806_cuLwW UK0050 2026-01-05T14:20:17.636Z 2026-01-12T15:07:43.532Z
9144978 9144978 20260104030018_xxUGB UK0050 2026-01-05T14:19:47.006Z 2026-01-12T15:07:20.720Z
9144868 9144868 20260104025702_4ZtHw UK0050 2026-01-05T14:19:39.057Z 2026-01-12T15:07:18.766Z
9144799 9144799 20260104025408_IBxuI UK0050 2026-01-05T14:19:35.708Z 2026-01-12T15:07:17.189Z
9144778 9144778 20260104025401_7sQja UK0050 2026-01-05T14:19:35.037Z 2026-01-12T15:07:17.019Z
9144604 9144604 20260104025015_gtQ9o UK0050 2026-01-05T14:19:25.707Z 2026-01-12T15:07:11.547Z
9144492 9144492 20260104024618_0nLRz UK0050 2026-01-05T14:19:11.893Z 2026-01-12T15:07:08.610Z
9144118 9144118 20260104023353_RZD3T UK0050 2026-01-05T14:18:35.384Z 2026-01-12T15:06:59.287Z

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