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 = "UK009P" 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
9272976 9272976 20260128041333_sPwFt UK009P 2026-01-29T14:28:21.069Z 2026-01-29T14:30:25.727Z
9272913 9272913 20260128035910_nPqXZ UK009P 2026-01-29T14:28:14.239Z 2026-01-29T14:30:25.706Z
9272643 9272643 20260128025234_Y96ol UK009P 2026-01-29T14:27:18.385Z 2026-01-29T14:30:25.406Z
9272594 9272594 20260128024654_eW3DW UK009P 2026-01-29T14:27:13.053Z 2026-01-29T14:30:25.381Z
9272501 9272501 20260128021846_YGfFL UK009P 2026-01-29T14:27:00.489Z 2026-01-29T14:30:25.362Z
9271812 9271812 20260127202405_jLen0 UK009P 2026-01-29T14:23:59.798Z 2026-01-29T14:30:25.154Z
9260571 9260571 20260125053225_ERTut UK009P 2026-01-26T14:22:26.215Z 2026-01-29T14:44:28.213Z
9260480 9260480 20260125044431_EnQgq UK009P 2026-01-26T14:21:56.708Z 2026-01-29T14:44:17.428Z
9252108 9252108 20260123010358_R6Aa3 UK009P 2026-01-24T14:14:22.115Z 2026-01-29T14:52:33.616Z
9252096 9252096 20260123010032_aBzqa UK009P 2026-01-24T14:14:21.009Z 2026-01-29T14:52:32.876Z
9251918 9251918 20260122235937_KjQWt UK009P 2026-01-24T14:13:43.377Z 2026-01-29T14:52:17.067Z
9251822 9251822 20260122231717_CAGTo UK009P 2026-01-24T14:13:20.078Z 2026-01-29T14:52:11.839Z
9243891 9243891 20260121053025_bMU6n UK009P 2026-01-22T14:23:27.778Z 2026-01-29T15:05:32.283Z
9243863 9243863 20260121052708_2le1Y UK009P 2026-01-22T14:23:23.189Z 2026-01-29T15:05:30.551Z
9243270 9243270 20260121040703_Q48z5 UK009P 2026-01-22T14:21:09.568Z 2026-01-29T15:04:53.114Z
9243262 9243262 20260121040636_v9zmM UK009P 2026-01-22T14:21:09.073Z 2026-01-29T15:04:53.024Z
9243111 9243111 20260121034323_ZR1WR UK009P 2026-01-22T14:20:35.567Z 2026-01-29T15:04:46.812Z
9242958 9242958 20260121032057_YX3Lb UK009P 2026-01-22T14:20:07.109Z 2026-01-29T15:04:32.451Z
9242681 9242681 20260121023358_AXQzO UK009P 2026-01-22T14:18:48.546Z 2026-01-29T15:04:16.650Z
9242589 9242589 20260121022235_fThI5 UK009P 2026-01-22T14:18:30.212Z 2026-01-29T15:04:12.792Z
9242547 9242547 20260121021227_yC73t UK009P 2026-01-22T14:18:22.616Z 2026-01-29T15:04:06.845Z
9242437 9242437 20260121015119_5j3qq UK009P 2026-01-22T14:17:51.732Z 2026-01-29T15:03:58.807Z
9242428 9242428 20260121015012_lGsWD UK009P 2026-01-22T14:17:50.080Z 2026-01-29T15:03:58.272Z
9242350 9242350 20260121013619_GGGxl UK009P 2026-01-22T14:17:26.469Z 2026-01-29T15:03:45.533Z
9242326 9242326 20260121012747_iDK6v UK009P 2026-01-22T14:17:21.023Z 2026-01-29T15:03:44.253Z
9242272 9242272 20260121012014_RUONv UK009P 2026-01-22T14:17:07.262Z 2026-01-29T15:03:41.550Z
9237975 9237975 20260120064237_lpgVG UK009P 2026-01-21T14:28:10.584Z 2026-01-28T15:02:01.427Z
9237761 9237761 20260120060059_Jw1oo UK009P 2026-01-21T14:27:35.738Z 2026-01-28T15:01:39.773Z
9237739 9237739 20260120055823_vF2Cr UK009P 2026-01-21T14:27:32.768Z 2026-01-28T15:01:38.662Z
9237723 9237723 20260120055545_Whd68 UK009P 2026-01-21T14:27:29.937Z 2026-01-28T15:01:37.834Z
9234824 9234824 20260119233340_BlBxX UK009P 2026-01-21T14:16:24.262Z 2026-01-28T14:58:15.556Z
9234479 9234479 20260119214828_Fw7Lf UK009P 2026-01-21T14:14:40.176Z 2026-01-28T14:57:49.510Z
9222830 9222830 20260117210018_0P2WB UK009P 2026-01-19T14:16:26.237Z 2026-01-26T15:01:22.555Z
9222718 9222718 20260117202703_5wpd0 UK009P 2026-01-19T14:15:55.812Z 2026-01-26T15:01:18.355Z
9222663 9222663 20260117201541_Zq3IJ UK009P 2026-01-19T14:15:44.826Z 2026-01-26T15:01:16.605Z
9222552 9222552 20260117195532_lISmn UK009P 2026-01-19T14:15:15.078Z 2026-01-26T15:01:13.323Z
9222230 9222230 20260117184453_XUQd4 UK009P 2026-01-19T14:13:52.253Z 2026-01-26T15:00:44.602Z
9222002 9222002 20260117174447_qX2NN UK009P 2026-01-19T14:12:51.616Z 2026-01-26T15:00:34.152Z
9218484 9218484 20260117040655_Lq3OD UK009P 2026-01-18T14:12:20.392Z 2026-01-25T14:58:27.210Z
9218470 9218470 20260117040029_34tS1 UK009P 2026-01-18T14:12:15.729Z 2026-01-25T14:58:26.706Z
9218445 9218445 20260117035426_PL2LP UK009P 2026-01-18T14:12:09.070Z 2026-01-25T14:58:25.832Z
9218443 9218443 20260117035426_abqE2 UK009P 2026-01-18T14:12:08.403Z 2026-01-25T14:58:25.692Z
9218375 9218375 20260117032236_4Zimx UK009P 2026-01-18T14:11:50.578Z 2026-01-25T14:58:23.661Z
9218305 9218305 20260117025008_ZA21U UK009P 2026-01-18T14:11:32.771Z 2026-01-25T14:58:20.833Z
9214392 9214392 20260116062737_0Ao3c UK009P 2026-01-17T14:21:19.937Z 2026-01-24T15:13:33.816Z
9214362 9214362 20260116062248_jNfIg UK009P 2026-01-17T14:21:11.650Z 2026-01-24T15:13:31.492Z
9212816 9212816 20260116010902_23AIY UK009P 2026-01-17T14:14:04.995Z 2026-01-24T15:11:27.923Z
9204475 9204475 20260114064730_J28JA UK009P 2026-01-15T14:27:25.473Z 2026-01-22T15:10:29.417Z
9204426 9204426 20260114063759_qeh7L UK009P 2026-01-15T14:27:15.062Z 2026-01-22T15:10:27.745Z
9204076 9204076 20260114060533_iWEAJ UK009P 2026-01-15T14:26:21.393Z 2026-01-22T15:10:17.649Z
9204052 9204052 20260114060430_kBXtr UK009P 2026-01-15T14:26:19.421Z 2026-01-22T15:10:17.372Z
9203890 9203890 20260114054726_Bf3wn UK009P 2026-01-15T14:25:47.313Z 2026-01-22T15:10:15.032Z
9203712 9203712 20260114053054_LRhQ6 UK009P 2026-01-15T14:25:13.461Z 2026-01-22T15:10:12.549Z
9203324 9203324 20260114045027_qyXsS UK009P 2026-01-15T14:24:03.483Z 2026-01-22T15:10:05.701Z
9203267 9203267 20260114044656_C3uUu UK009P 2026-01-15T14:23:55.427Z 2026-01-22T15:10:04.642Z
9203234 9203234 20260114044407_3b1Kl UK009P 2026-01-15T14:23:52.536Z 2026-01-22T15:10:04.181Z
9203088 9203088 20260114043249_Hdy8P UK009P 2026-01-15T14:23:17.226Z 2026-01-22T15:10:01.378Z
9203068 9203068 20260114043113_ai005 UK009P 2026-01-15T14:23:14.691Z 2026-01-22T15:10:01.153Z
9202925 9202925 20260114041838_TSxdt UK009P 2026-01-15T14:22:48.384Z 2026-01-22T15:09:59.434Z
9202796 9202796 20260114040826_l5qbF UK009P 2026-01-15T14:22:21.995Z 2026-01-22T15:09:41.110Z
9202674 9202674 20260114035955_DWOnW UK009P 2026-01-15T14:22:05.953Z 2026-01-22T15:09:24.604Z
9202531 9202531 20260114034433_ovbaD UK009P 2026-01-15T14:21:34.875Z 2026-01-22T15:09:21.737Z
9202300 9202300 20260114032711_ICfP4 UK009P 2026-01-15T14:21:01.716Z 2026-01-22T15:09:16.128Z
9202232 9202232 20260114032429_hg2mX UK009P 2026-01-15T14:20:43.577Z 2026-01-22T15:09:15.078Z
9202161 9202161 20260114032140_QXRa8 UK009P 2026-01-15T14:20:36.727Z 2026-01-22T15:09:14.334Z
9202054 9202054 20260114031230_ZqlFv UK009P 2026-01-15T14:20:17.293Z 2026-01-22T15:09:12.405Z
9201937 9201937 20260114030716_VLfwf UK009P 2026-01-15T14:20:09.472Z 2026-01-22T15:09:11.583Z
9201859 9201859 20260114030019_P3f3k UK009P 2026-01-15T14:19:55.604Z 2026-01-22T15:09:10.708Z
9201839 9201839 20260114025831_NMcYt UK009P 2026-01-15T14:19:53.341Z 2026-01-22T15:09:10.389Z
9201794 9201794 20260114025316_wiYvW UK009P 2026-01-15T14:19:45.305Z 2026-01-22T15:09:09.820Z
9201767 9201767 20260114024813_80hlf UK009P 2026-01-15T14:19:40.026Z 2026-01-22T15:09:09.127Z
9201682 9201682 20260114024103_opGwK UK009P 2026-01-15T14:19:16.775Z 2026-01-22T15:09:07.294Z
9201512 9201512 20260114022410_UkTuI UK009P 2026-01-15T14:18:46.848Z 2026-01-22T15:09:04.698Z
9201476 9201476 20260114022026_nrLPh UK009P 2026-01-15T14:18:42.362Z 2026-01-22T15:09:04.227Z
9201319 9201319 20260114021016_iG6uC UK009P 2026-01-15T14:18:15.004Z 2026-01-22T15:09:01.796Z
9201196 9201196 20260114015341_TFbPk UK009P 2026-01-15T14:17:45.547Z 2026-01-22T15:08:59.327Z
9201133 9201133 20260114014646_tisYl UK009P 2026-01-15T14:17:36.106Z 2026-01-22T15:08:58.071Z
9201097 9201097 20260114014246_p5T7e UK009P 2026-01-15T14:17:33.422Z 2026-01-22T15:08:57.718Z
9201075 9201075 20260114014013_fMuK9 UK009P 2026-01-15T14:17:31.660Z 2026-01-22T15:08:57.508Z
9200954 9200954 20260114012554_VgaJw UK009P 2026-01-15T14:17:06.074Z 2026-01-22T15:08:40.649Z
9200808 9200808 20260114010508_IAeyh UK009P 2026-01-15T14:16:33.238Z 2026-01-22T15:08:28.908Z
9200728 9200728 20260114005733_S8mHE UK009P 2026-01-15T14:16:14.021Z 2026-01-22T15:08:24.720Z
9200654 9200654 20260114004510_mxnnB UK009P 2026-01-15T14:15:56.702Z 2026-01-22T15:08:22.758Z
9200557 9200557 20260114002415_jII8o UK009P 2026-01-15T14:15:35.498Z 2026-01-22T15:08:18.238Z
9200532 9200532 20260114002151_vkE8t UK009P 2026-01-15T14:15:28.654Z 2026-01-22T15:08:17.881Z
9200454 9200454 20260114001234_63k2I UK009P 2026-01-15T14:15:14.526Z 2026-01-22T15:08:16.216Z
9200414 9200414 20260114000623_DX36d UK009P 2026-01-15T14:15:10.035Z 2026-01-22T15:08:15.697Z
9200311 9200311 20260113234111_aVVhL UK009P 2026-01-15T14:14:42.084Z 2026-01-22T15:08:13.685Z
9200278 9200278 20260113233312_Vrt0K UK009P 2026-01-15T14:14:35.475Z 2026-01-22T15:08:13.125Z
9200165 9200165 20260113230146_l2I6V UK009P 2026-01-15T14:14:03.993Z 2026-01-22T15:08:10.642Z
9200078 9200078 20260113224721_e4dHi UK009P 2026-01-15T14:13:42.615Z 2026-01-22T15:08:09.127Z
9200051 9200051 20260113224117_r93FR UK009P 2026-01-15T14:13:39.732Z 2026-01-22T15:08:08.745Z
9200030 9200030 20260113223141_2P9cN UK009P 2026-01-15T14:13:35.302Z 2026-01-22T15:08:08.063Z
9199985 9199985 20260113221304_rsD5D UK009P 2026-01-15T14:13:20.205Z 2026-01-22T15:08:07.082Z
9199940 9199940 20260113215950_G8RK8 UK009P 2026-01-15T14:13:08.196Z 2026-01-22T15:08:05.925Z
9194722 9194722 20260112221653_pm5Hh UK009P 2026-01-14T14:10:23.979Z 2026-01-21T15:04:20.310Z
9194674 9194674 20260112214351_24Lbf UK009P 2026-01-14T14:10:13.640Z 2026-01-21T15:04:19.831Z
9189722 9189722 20260112060218_l2S2w UK009P 2026-01-13T14:19:00.738Z 2026-01-20T15:23:37.049Z
9180438 9180438 20260110202659_vSUWx UK009P 2026-01-12T14:07:06.622Z 2026-01-19T15:16:02.119Z
9180425 9180425 20260110202226_sPMC7 UK009P 2026-01-12T14:07:04.511Z 2026-01-19T15:16:01.617Z

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