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

9,346 rows where station_code = "UK00AT" 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
9273085 9273085 20260128043246_DQmhn UK00AT 2026-01-29T14:28:42.749Z 2026-01-29T14:30:25.746Z
9273036 9273036 20260128042708_CMtUt UK00AT 2026-01-29T14:28:31.559Z 2026-01-29T14:30:25.739Z
9272641 9272641 20260128025154_22RYK UK00AT 2026-01-29T14:27:17.586Z 2026-01-29T14:30:25.405Z
9272627 9272627 20260128024926_Y2F2u UK00AT 2026-01-29T14:27:15.436Z 2026-01-29T14:30:25.403Z
9272228 9272228 20260128004834_wVpQ2 UK00AT 2026-01-29T14:25:57.876Z 2026-01-29T14:30:25.309Z
9256281 9256281 20260124063722_9TF42 UK00AT 2026-01-25T14:16:25.250Z 2026-01-29T14:48:34.238Z
9256269 9256269 20260124063312_ypWlb UK00AT 2026-01-25T14:16:23.152Z 2026-01-29T14:48:33.506Z
9256122 9256122 20260124055909_eXz27 UK00AT 2026-01-25T14:15:55.040Z 2026-01-29T14:48:24.340Z
9256070 9256070 20260124054848_O9kTO UK00AT 2026-01-25T14:15:41.649Z 2026-01-29T14:48:21.004Z
9255925 9255925 20260124052111_248V7 UK00AT 2026-01-25T14:15:09.732Z 2026-01-29T14:48:08.195Z
9255902 9255902 20260124051524_jBzms UK00AT 2026-01-25T14:15:06.035Z 2026-01-29T14:48:06.701Z
9255865 9255865 20260124050937_0Fnxa UK00AT 2026-01-25T14:14:59.803Z 2026-01-29T14:48:01.869Z
9255827 9255827 20260124050400_093ac UK00AT 2026-01-25T14:14:55.048Z 2026-01-29T14:48:00.091Z
9255377 9255377 20260124031112_Pi3Ks UK00AT 2026-01-25T14:13:07.812Z 2026-01-29T14:47:26.791Z
9255302 9255302 20260124024234_XS7PS UK00AT 2026-01-25T14:12:46.186Z 2026-01-29T14:47:22.328Z
9255299 9255299 20260124024049_hTFCM UK00AT 2026-01-25T14:12:45.588Z 2026-01-29T14:47:22.163Z
9255279 9255279 20260124022708_PQLX2 UK00AT 2026-01-25T14:12:39.070Z 2026-01-29T14:47:14.809Z
9255251 9255251 20260124021043_aLAI4 UK00AT 2026-01-25T14:12:31.956Z 2026-01-29T14:47:12.197Z
9255224 9255224 20260124015400_EorFu UK00AT 2026-01-25T14:12:26.536Z 2026-01-29T14:47:11.123Z
9255221 9255221 20260124015400_4dyew UK00AT 2026-01-25T14:12:25.870Z 2026-01-29T14:47:10.965Z
9255219 9255219 20260124015312_rVXUG UK00AT 2026-01-25T14:12:25.190Z 2026-01-29T14:47:10.786Z
9255085 9255085 20260124004504_pQKwC UK00AT 2026-01-25T14:11:50.605Z 2026-01-29T14:47:01.661Z
9255051 9255051 20260124003614_lrqlF UK00AT 2026-01-25T14:11:44.223Z 2026-01-29T14:47:00.661Z
9255026 9255026 20260124002628_iOr35 UK00AT 2026-01-25T14:11:39.553Z 2026-01-29T14:46:59.991Z
9255002 9255002 20260124001003_awVGz UK00AT 2026-01-25T14:11:36.425Z 2026-01-29T14:46:59.305Z
9254969 9254969 20260123233746_wjmkR UK00AT 2026-01-25T14:11:29.240Z 2026-01-29T14:46:57.699Z
9254939 9254939 20260123231822_Aa5QU UK00AT 2026-01-25T14:11:22.475Z 2026-01-29T14:46:56.246Z
9252766 9252766 20260123061453_by3J1 UK00AT 2026-01-24T14:17:04.032Z 2026-01-29T14:53:23.684Z
9244074 9244074 20260121060734_bMF2f UK00AT 2026-01-22T14:24:05.050Z 2026-01-29T15:05:50.629Z
9243980 9243980 20260121054704_NIcR6 UK00AT 2026-01-22T14:23:41.768Z 2026-01-29T15:05:37.310Z
9243908 9243908 20260121053133_WZa6G UK00AT 2026-01-22T14:23:29.196Z 2026-01-29T15:05:34.041Z
9243796 9243796 20260121051758_unO0A UK00AT 2026-01-22T14:23:04.385Z 2026-01-29T15:05:27.664Z
9243755 9243755 20260121051231_9qaXR UK00AT 2026-01-22T14:22:54.984Z 2026-01-29T15:05:26.057Z
9243732 9243732 20260121051126_WpNVv UK00AT 2026-01-22T14:22:51.781Z 2026-01-29T15:05:25.253Z
9243683 9243683 20260121050503_rp2aj UK00AT 2026-01-22T14:22:44.341Z 2026-01-29T15:05:23.234Z
9243673 9243673 20260121050404_MPh3p UK00AT 2026-01-22T14:22:42.863Z 2026-01-29T15:05:22.753Z
9243655 9243655 20260121050052_V5oZ2 UK00AT 2026-01-22T14:22:39.826Z 2026-01-29T15:05:21.751Z
9243535 9243535 20260121044644_kPC8Q UK00AT 2026-01-22T14:22:09.674Z 2026-01-29T15:05:17.186Z
9243471 9243471 20260121043626_Kss22 UK00AT 2026-01-22T14:22:02.488Z 2026-01-29T15:05:03.844Z
9243398 9243398 20260121042758_dhGNg UK00AT 2026-01-22T14:21:37.931Z 2026-01-29T15:05:00.590Z
9231168 9231168 20260119061639_ke3X3 UK00AT 2026-01-20T14:31:39.422Z 2026-01-27T15:06:03.158Z
9230989 9230989 20260119053921_PoFh5 UK00AT 2026-01-20T14:30:44.497Z 2026-01-27T15:05:51.567Z
9230972 9230972 20260119053553_zy6EP UK00AT 2026-01-20T14:30:39.539Z 2026-01-27T15:05:50.662Z
9218054 9218054 20260116230850_9qqn9 UK00AT 2026-01-18T14:10:11.677Z 2026-01-25T14:57:56.787Z
9217925 9217925 20260116204738_irElL UK00AT 2026-01-18T14:09:36.878Z 2026-01-25T14:57:52.153Z
9217886 9217886 20260116202015_ADj5Z UK00AT 2026-01-18T14:09:28.650Z 2026-01-25T14:57:50.922Z
9217620 9217620 20260116183129_n7LDf UK00AT 2026-01-18T14:08:12.315Z 2026-01-25T14:57:28.159Z
9214217 9214217 20260116055440_8hN1N UK00AT 2026-01-17T14:20:37.082Z 2026-01-24T15:13:23.280Z
9214100 9214100 20260116053358_euOmm UK00AT 2026-01-17T14:20:03.379Z 2026-01-24T15:13:05.855Z
9214033 9214033 20260116052342_JNAyL UK00AT 2026-01-17T14:19:43.907Z 2026-01-24T15:12:58.874Z
9213984 9213984 20260116051137_rBHbz UK00AT 2026-01-17T14:19:31.470Z 2026-01-24T15:12:56.053Z
9213919 9213919 20260116045839_FfSQA UK00AT 2026-01-17T14:19:09.540Z 2026-01-24T15:12:51.458Z
9213884 9213884 20260116045714_Fj5oJ UK00AT 2026-01-17T14:18:59.653Z 2026-01-24T15:12:50.292Z
9213817 9213817 20260116044634_2ujlL UK00AT 2026-01-17T14:18:41.086Z 2026-01-24T15:12:47.836Z
9213784 9213784 20260116044036_O0W3K UK00AT 2026-01-17T14:18:29.041Z 2026-01-24T15:12:46.417Z
9213728 9213728 20260116043043_f6Q0L UK00AT 2026-01-17T14:18:15.626Z 2026-01-24T15:12:32.339Z
9213612 9213612 20260116040831_Dutgi UK00AT 2026-01-17T14:17:45.619Z 2026-01-24T15:12:24.712Z
9213588 9213588 20260116040514_2TZcG UK00AT 2026-01-17T14:17:40.540Z 2026-01-24T15:12:23.399Z
9213561 9213561 20260116040205_ZKr2p UK00AT 2026-01-17T14:17:36.462Z 2026-01-24T15:12:22.567Z
9213340 9213340 20260116031034_zGKh4 UK00AT 2026-01-17T14:16:30.059Z 2026-01-24T15:12:10.052Z
9213258 9213258 20260116025314_2ExxG UK00AT 2026-01-17T14:16:11.686Z 2026-01-24T15:12:06.077Z
9208807 9208807 20260115065451_JLqON UK00AT 2026-01-16T14:14:03.873Z 2026-01-22T15:04:40.489Z
9208732 9208732 20260115063929_3Mxm4 UK00AT 2026-01-16T14:13:47.185Z 2026-01-22T15:04:38.428Z
9208706 9208706 20260115063354_W6y3p UK00AT 2026-01-16T14:13:43.220Z 2026-01-22T15:04:37.789Z
9208414 9208414 20260115051743_2iMlw UK00AT 2026-01-16T14:12:34.544Z 2026-01-22T15:04:13.082Z
9208390 9208390 20260115051502_Z7Jeo UK00AT 2026-01-16T14:12:29.124Z 2026-01-22T15:04:12.253Z
9208359 9208359 20260115051134_6pTgb UK00AT 2026-01-16T14:12:19.857Z 2026-01-22T15:04:11.197Z
9208310 9208310 20260115050111_MxtGb UK00AT 2026-01-16T14:12:06.327Z 2026-01-22T15:04:07.024Z
9208270 9208270 20260115045010_Ujrwa UK00AT 2026-01-16T14:11:57.702Z 2026-01-22T15:04:05.923Z
9208195 9208195 20260115043207_3jquF UK00AT 2026-01-16T14:11:39.362Z 2026-01-22T15:04:03.705Z
9208161 9208161 20260115042237_aQUxK UK00AT 2026-01-16T14:11:33.819Z 2026-01-22T15:04:02.688Z
9208129 9208129 20260115041813_2FMUk UK00AT 2026-01-16T14:11:24.866Z 2026-01-22T15:04:02.003Z
9208065 9208065 20260115040824_16PP1 UK00AT 2026-01-16T14:11:11.890Z 2026-01-22T15:04:00.424Z
9208054 9208054 20260115040601_BEnzn UK00AT 2026-01-16T14:11:09.018Z 2026-01-22T15:03:59.908Z
9208008 9208008 20260115035419_Vta9R UK00AT 2026-01-16T14:10:58.232Z 2026-01-22T15:03:58.483Z
9207880 9207880 20260115032618_z8L4w UK00AT 2026-01-16T14:10:30.975Z 2026-01-22T15:03:55.589Z
9207678 9207678 20260115024110_HjYKk UK00AT 2026-01-16T14:09:37.874Z 2026-01-22T15:03:29.626Z
9207563 9207563 20260115021616_yEwt6 UK00AT 2026-01-16T14:09:14.444Z 2026-01-22T15:03:24.946Z
9207555 9207555 20260115021532_LeJ18 UK00AT 2026-01-16T14:09:13.932Z 2026-01-22T15:03:24.883Z
9207486 9207486 20260115014926_W0t3D UK00AT 2026-01-16T14:08:57.475Z 2026-01-22T15:03:23.023Z
9204477 9204477 20260114064730_J28JA UK00AT 2026-01-15T14:27:25.473Z 2026-01-22T15:10:29.417Z
9204422 9204422 20260114063757_rjJ1e UK00AT 2026-01-15T14:27:14.177Z 2026-01-22T15:10:27.521Z
9204177 9204177 20260114061351_rS9rc UK00AT 2026-01-15T14:26:36.428Z 2026-01-22T15:10:21.826Z
9204161 9204161 20260114061100_v1xuN UK00AT 2026-01-15T14:26:31.953Z 2026-01-22T15:10:21.261Z
9204097 9204097 20260114060620_3xRAY UK00AT 2026-01-15T14:26:23.073Z 2026-01-22T15:10:17.812Z
9204078 9204078 20260114060533_iWEAJ UK00AT 2026-01-15T14:26:21.393Z 2026-01-22T15:10:17.649Z
9204064 9204064 20260114060516_17ggT UK00AT 2026-01-15T14:26:20.392Z 2026-01-22T15:10:17.512Z
9203803 9203803 20260114053755_0mbQ3 UK00AT 2026-01-15T14:25:24.539Z 2026-01-22T15:10:13.617Z
9203764 9203764 20260114053525_kPJoE UK00AT 2026-01-15T14:25:21.609Z 2026-01-22T15:10:13.158Z
9203662 9203662 20260114052726_LybBy UK00AT 2026-01-15T14:25:07.816Z 2026-01-22T15:10:11.721Z
9203599 9203599 20260114052118_JZLHU UK00AT 2026-01-15T14:24:58.820Z 2026-01-22T15:10:10.599Z
9203520 9203520 20260114051459_rFzBZ UK00AT 2026-01-15T14:24:39.053Z 2026-01-22T15:10:09.248Z
9203473 9203473 20260114050007_PrHJA UK00AT 2026-01-15T14:24:30.205Z 2026-01-22T15:10:08.402Z
9203430 9203430 20260114045622_G2HJf UK00AT 2026-01-15T14:24:23.602Z 2026-01-22T15:10:07.414Z
9203284 9203284 20260114044755_sjvGQ UK00AT 2026-01-15T14:23:57.293Z 2026-01-22T15:10:04.973Z
9203138 9203138 20260114043642_Q6rA1 UK00AT 2026-01-15T14:23:24.178Z 2026-01-22T15:10:02.350Z
9203089 9203089 20260114043249_Hdy8P UK00AT 2026-01-15T14:23:17.226Z 2026-01-22T15:10:01.378Z
9202945 9202945 20260114041929_JOoUz UK00AT 2026-01-15T14:22:50.988Z 2026-01-22T15:09:59.684Z
9202863 9202863 20260114041403_ZHM2q UK00AT 2026-01-15T14:22:39.958Z 2026-01-22T15:09:58.206Z
9202758 9202758 20260114040731_o82KS UK00AT 2026-01-15T14:22:18.057Z 2026-01-22T15:09:39.158Z

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