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 = "UK00B1" 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
9272568 9272568 20260128023651_kyrCs UK00B1 2026-01-29T14:27:10.560Z 2026-01-29T14:30:25.378Z
9272390 9272390 20260128015145_da7d6 UK00B1 2026-01-29T14:26:34.220Z 2026-01-29T14:30:25.340Z
9272184 9272184 20260128003754_4bqrj UK00B1 2026-01-29T14:25:52.767Z 2026-01-29T14:30:25.295Z
9260660 9260660 20260125062724_aYnfo UK00B1 2026-01-26T14:22:48.751Z 2026-01-29T14:44:33.864Z
9260566 9260566 20260125053011_o6aIc UK00B1 2026-01-26T14:22:25.218Z 2026-01-29T14:44:27.879Z
9260534 9260534 20260125051628_1yx4m UK00B1 2026-01-26T14:22:07.711Z 2026-01-29T14:44:20.172Z
9260342 9260342 20260125035011_kWxew UK00B1 2026-01-26T14:21:20.466Z 2026-01-29T14:44:06.821Z
9260306 9260306 20260125033051_MRYXq UK00B1 2026-01-26T14:21:07.353Z 2026-01-29T14:44:04.740Z
9260256 9260256 20260125031517_sL5i3 UK00B1 2026-01-26T14:20:56.942Z 2026-01-29T14:44:02.284Z
9260248 9260248 20260125031511_tdxNk UK00B1 2026-01-26T14:20:55.952Z 2026-01-29T14:44:01.944Z
9260218 9260218 20260125031001_RtpWq UK00B1 2026-01-26T14:20:49.324Z 2026-01-29T14:44:00.178Z
9260191 9260191 20260125025946_Bdvg3 UK00B1 2026-01-26T14:20:35.884Z 2026-01-29T14:43:56.892Z
9260080 9260080 20260125023022_Tsw8H UK00B1 2026-01-26T14:20:11.917Z 2026-01-29T14:43:45.614Z
9252347 9252347 20260123022434_UJ4MH UK00B1 2026-01-24T14:15:12.701Z 2026-01-29T14:52:46.155Z
9252083 9252083 20260123005351_L1K9S UK00B1 2026-01-24T14:14:18.588Z 2026-01-29T14:52:27.504Z
9251771 9251771 20260122223144_Jasug UK00B1 2026-01-24T14:13:09.675Z 2026-01-29T14:52:08.671Z
9251718 9251718 20260122221140_gZzQY UK00B1 2026-01-24T14:12:59.774Z 2026-01-29T14:52:04.468Z
9251684 9251684 20260122220354_N2Zcv UK00B1 2026-01-24T14:12:53.156Z 2026-01-29T14:51:58.822Z
9251619 9251619 20260122212819_zQ3al UK00B1 2026-01-24T14:12:37.016Z 2026-01-29T14:51:55.132Z
9243399 9243399 20260121042758_dhGNg UK00B1 2026-01-22T14:21:37.931Z 2026-01-29T15:05:00.590Z
9241980 9241980 20260120234854_6Hks4 UK00B1 2026-01-22T14:15:38.453Z 2026-01-29T15:03:20.392Z
9236415 9236415 20260120031213_Dtulr UK00B1 2026-01-21T14:22:45.781Z 2026-01-28T14:59:59.059Z
9236409 9236409 20260120031158_Zix8M UK00B1 2026-01-21T14:22:45.439Z 2026-01-28T14:59:58.899Z
9236394 9236394 20260120030932_LgBjf UK00B1 2026-01-21T14:22:37.427Z 2026-01-28T14:59:58.257Z
9236219 9236219 20260120024805_SA3N3 UK00B1 2026-01-21T14:21:59.946Z 2026-01-28T14:59:50.650Z
9236056 9236056 20260120023024_ftLnx UK00B1 2026-01-21T14:21:19.763Z 2026-01-28T14:59:42.623Z
9236050 9236050 20260120023023_cJ6iZ UK00B1 2026-01-21T14:21:19.237Z 2026-01-28T14:59:42.467Z
9236000 9236000 20260120022558_dRv2n UK00B1 2026-01-21T14:21:12.428Z 2026-01-28T14:59:32.273Z
9218367 9218367 20260117031901_uFZgq UK00B1 2026-01-18T14:11:49.227Z 2026-01-25T14:58:23.526Z
9218360 9218360 20260117031820_2m8KC UK00B1 2026-01-18T14:11:47.879Z 2026-01-25T14:58:23.302Z
9218302 9218302 20260117024738_qB4rK UK00B1 2026-01-18T14:11:31.517Z 2026-01-25T14:58:20.643Z
9214524 9214524 20260116064817_x4QqO UK00B1 2026-01-17T14:21:51.774Z 2026-01-24T15:13:48.464Z
9214506 9214506 20260116064602_2GprW UK00B1 2026-01-17T14:21:48.545Z 2026-01-24T15:13:43.899Z
9214275 9214275 20260116060538_cBleF UK00B1 2026-01-17T14:20:51.375Z 2026-01-24T15:13:27.485Z
9213885 9213885 20260116045714_Fj5oJ UK00B1 2026-01-17T14:18:59.653Z 2026-01-24T15:12:50.292Z
9212969 9212969 20260116014331_HGkL3 UK00B1 2026-01-17T14:14:45.451Z 2026-01-24T15:11:35.812Z
9212869 9212869 20260116012632_2r3Ck UK00B1 2026-01-17T14:14:18.917Z 2026-01-24T15:11:31.654Z
9212598 9212598 20260115234054_HgnEu UK00B1 2026-01-17T14:12:51.613Z 2026-01-24T15:11:06.913Z
9207184 9207184 20260114232856_Mrw39 UK00B1 2026-01-16T14:07:34.095Z 2026-01-22T15:03:13.836Z
9207169 9207169 20260114230956_u3Fwb UK00B1 2026-01-16T14:07:29.783Z 2026-01-22T15:03:12.830Z
9202007 9202007 20260114031001_9Nbwj UK00B1 2026-01-15T14:20:14.092Z 2026-01-22T15:09:12.024Z
9201893 9201893 20260114030441_gLeWu UK00B1 2026-01-15T14:20:05.084Z 2026-01-22T15:09:11.079Z
9201592 9201592 20260114023422_cP9Yb UK00B1 2026-01-15T14:19:09.058Z 2026-01-22T15:09:06.485Z
9200832 9200832 20260114010844_6vzul UK00B1 2026-01-15T14:16:37.470Z 2026-01-22T15:08:30.307Z
9200788 9200788 20260114010250_VKO2C UK00B1 2026-01-15T14:16:23.944Z 2026-01-22T15:08:25.547Z
9194772 9194772 20260112223715_r2HZu UK00B1 2026-01-14T14:10:38.588Z 2026-01-21T15:04:20.803Z
9194145 9194145 20260112182135_Qv2GW UK00B1 2026-01-14T14:07:35.845Z 2026-01-21T15:03:34.937Z
9180673 9180673 20260110213001_FXibK UK00B1 2026-01-12T14:07:57.024Z 2026-01-19T15:16:26.958Z
9180603 9180603 20260110210658_XtxkU UK00B1 2026-01-12T14:07:40.231Z 2026-01-19T15:16:24.177Z
9176895 9176895 20260110063720_UVIL8 UK00B1 2026-01-11T14:10:17.223Z 2026-01-18T15:09:06.507Z
9176883 9176883 20260110063503_KyoVs UK00B1 2026-01-11T14:10:15.776Z 2026-01-18T15:09:06.150Z
9176804 9176804 20260110062304_tPcO9 UK00B1 2026-01-11T14:10:02.182Z 2026-01-18T15:08:54.561Z
9176756 9176756 20260110061901_KwR25 UK00B1 2026-01-11T14:09:52.961Z 2026-01-18T15:08:53.025Z
9176632 9176632 20260110055909_ppcTh UK00B1 2026-01-11T14:09:33.407Z 2026-01-18T15:08:46.640Z
9176621 9176621 20260110055830_OhWEn UK00B1 2026-01-11T14:09:30.231Z 2026-01-18T15:08:46.271Z
9176588 9176588 20260110054952_rIn77 UK00B1 2026-01-11T14:09:23.583Z 2026-01-18T15:08:44.872Z
9176545 9176545 20260110054149_uudLN UK00B1 2026-01-11T14:09:17.612Z 2026-01-18T15:08:43.291Z
9176475 9176475 20260110053612_WrtlD UK00B1 2026-01-11T14:09:08.379Z 2026-01-18T15:08:40.695Z
9176390 9176390 20260110052528_NvZNN UK00B1 2026-01-11T14:08:52.759Z 2026-01-18T15:08:37.411Z
9176344 9176344 20260110051754_KAEbU UK00B1 2026-01-11T14:08:46.193Z 2026-01-18T15:08:35.278Z
9176295 9176295 20260110051203_GDuxm UK00B1 2026-01-11T14:08:39.236Z 2026-01-18T15:08:26.304Z
9176252 9176252 20260110050851_suNdC UK00B1 2026-01-11T14:08:35.838Z 2026-01-18T15:08:25.397Z
9176216 9176216 20260110050238_JL8SD UK00B1 2026-01-11T14:08:27.901Z 2026-01-18T15:08:24.082Z
9176200 9176200 20260110050107_M0Mo7 UK00B1 2026-01-11T14:08:26.815Z 2026-01-18T15:08:23.765Z
9175489 9175489 20260110023841_i6OF9 UK00B1 2026-01-11T14:06:32.527Z 2026-01-18T15:07:47.220Z
9175475 9175475 20260110023507_ip3wE UK00B1 2026-01-11T14:06:30.695Z 2026-01-18T15:07:46.789Z
9175450 9175450 20260110023007_wnDDR UK00B1 2026-01-11T14:06:27.129Z 2026-01-18T15:07:46.004Z
9175323 9175323 20260110020348_NqxE2 UK00B1 2026-01-11T14:06:04.717Z 2026-01-18T15:07:41.209Z
9175245 9175245 20260110014655_zFoT2 UK00B1 2026-01-11T14:05:48.550Z 2026-01-18T15:07:38.322Z
9175157 9175157 20260110012730_T9L9X UK00B1 2026-01-11T14:05:33.987Z 2026-01-18T15:07:30.259Z
9175109 9175109 20260110010705_o94vU UK00B1 2026-01-11T14:05:24.164Z 2026-01-18T15:07:25.945Z
9175096 9175096 20260110010313_Qxd7a UK00B1 2026-01-11T14:05:22.118Z 2026-01-18T15:07:25.594Z
9175077 9175077 20260110010139_XgyS9 UK00B1 2026-01-11T14:05:20.031Z 2026-01-18T15:07:25.182Z
9175067 9175067 20260110005608_Sl7Zw UK00B1 2026-01-11T14:05:18.821Z 2026-01-18T15:07:24.857Z
9174980 9174980 20260110002559_AVsuy UK00B1 2026-01-11T14:05:01.133Z 2026-01-18T15:07:20.012Z
9174876 9174876 20260109234311_TX0NS UK00B1 2026-01-11T14:04:41.572Z 2026-01-18T15:07:14.971Z
9174842 9174842 20260109232934_ny42i UK00B1 2026-01-11T14:04:35.593Z 2026-01-18T15:07:13.452Z
9174840 9174840 20260109232700_jIUaI UK00B1 2026-01-11T14:04:34.877Z 2026-01-18T15:07:13.276Z
9174836 9174836 20260109232349_1XVju UK00B1 2026-01-11T14:04:34.367Z 2026-01-18T15:07:13.091Z
9174826 9174826 20260109231908_QhyCW UK00B1 2026-01-11T14:04:31.186Z 2026-01-18T15:07:12.518Z
9174445 9174445 20260109190715_QkSby UK00B1 2026-01-11T14:03:13.138Z 2026-01-18T15:06:46.206Z
9174399 9174399 20260109174302_ita7H UK00B1 2026-01-11T14:03:00.181Z 2026-01-18T15:06:43.336Z
9163350 9163350 20260107062627_httt0 UK00B1 2026-01-08T14:08:50.464Z 2026-01-13T15:03:10.262Z
9163288 9163288 20260107061655_kmqil UK00B1 2026-01-08T14:08:40.346Z 2026-01-13T15:03:08.080Z
9163263 9163263 20260107061409_UAGso UK00B1 2026-01-08T14:08:37.516Z 2026-01-13T15:03:07.348Z
9163252 9163252 20260107061243_itZ8p UK00B1 2026-01-08T14:08:36.866Z 2026-01-13T15:03:07.180Z
9163187 9163187 20260107060206_DYIR2 UK00B1 2026-01-08T14:08:18.833Z 2026-01-13T15:03:04.462Z
9163132 9163132 20260107054613_fPV08 UK00B1 2026-01-08T14:08:11.477Z 2026-01-13T15:03:02.300Z
9163106 9163106 20260107054445_Jf4wR UK00B1 2026-01-08T14:08:08.540Z 2026-01-13T15:03:01.542Z
9163100 9163100 20260107054351_8XrNE UK00B1 2026-01-08T14:08:07.824Z 2026-01-13T15:03:01.332Z
9163030 9163030 20260107053029_tQM3v UK00B1 2026-01-08T14:07:51.051Z 2026-01-13T15:02:58.320Z
9162945 9162945 20260107050451_RQEEl UK00B1 2026-01-08T14:07:29.348Z 2026-01-13T15:02:48.260Z
9162899 9162899 20260107045929_6O3wx UK00B1 2026-01-08T14:07:15.973Z 2026-01-13T15:02:44.900Z
9162887 9162887 20260107045341_d9DHd UK00B1 2026-01-08T14:07:10.719Z 2026-01-13T15:02:44.012Z
9162870 9162870 20260107044617_uonUQ UK00B1 2026-01-08T14:07:06.973Z 2026-01-13T15:02:42.931Z
9162840 9162840 20260107044222_vGQuP UK00B1 2026-01-08T14:07:02.106Z 2026-01-13T15:02:41.526Z
9162733 9162733 20260107042004_PxjcH UK00B1 2026-01-08T14:06:38.347Z 2026-01-13T15:02:36.813Z
9162679 9162679 20260107040319_hjuKO UK00B1 2026-01-08T14:06:20.617Z 2026-01-13T15:02:33.439Z
9162614 9162614 20260107034538_TMcRd UK00B1 2026-01-08T14:05:59.239Z 2026-01-13T15:02:21.338Z
9162579 9162579 20260107033527_Jrhop UK00B1 2026-01-08T14:05:54.138Z 2026-01-13T15:02:20.187Z

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