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 = "UK003N" 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
9273472 9273472 20260128062741_CiWXN UK003N 2026-01-29T14:29:53.709Z 2026-01-29T14:30:25.820Z
9273284 9273284 20260128053132_NXZJ7 UK003N 2026-01-29T14:29:16.651Z 2026-01-29T14:30:25.782Z
9273241 9273241 20260128051318_RD6fp UK003N 2026-01-29T14:29:11.188Z 2026-01-29T14:30:25.775Z
9273208 9273208 20260128050834_EtOfh UK003N 2026-01-29T14:29:01.571Z 2026-01-29T14:30:25.770Z
9273173 9273173 20260128050306_eJ2MI UK003N 2026-01-29T14:28:54.630Z 2026-01-29T14:30:25.764Z
9272996 9272996 20260128041853_VO9NX UK003N 2026-01-29T14:28:24.057Z 2026-01-29T14:30:25.732Z
9272933 9272933 20260128040357_lyfl8 UK003N 2026-01-29T14:28:15.621Z 2026-01-29T14:30:25.708Z
9272436 9272436 20260128020544_zHzpa UK003N 2026-01-29T14:26:39.030Z 2026-01-29T14:30:25.346Z
9272431 9272431 20260128020543_paGhN UK003N 2026-01-29T14:26:38.414Z 2026-01-29T14:30:25.345Z
9272394 9272394 20260128015518_9LizT UK003N 2026-01-29T14:26:35.217Z 2026-01-29T14:30:25.341Z
9272361 9272361 20260128014426_ztbSH UK003N 2026-01-29T14:26:31.916Z 2026-01-29T14:30:25.336Z
9272258 9272258 20260128010344_3YbRp UK003N 2026-01-29T14:26:08.469Z 2026-01-29T14:30:25.317Z
9272198 9272198 20260128004249_zibmT UK003N 2026-01-29T14:25:54.941Z 2026-01-29T14:30:25.297Z
9272156 9272156 20260128002724_0v5np UK003N 2026-01-29T14:25:49.139Z 2026-01-29T14:30:25.291Z
9272080 9272080 20260127235419_EygzZ UK003N 2026-01-29T14:25:32.142Z 2026-01-29T14:30:25.277Z
9271974 9271974 20260127224305_lyPpi UK003N 2026-01-29T14:25:12.021Z 2026-01-29T14:30:25.257Z
9256144 9256144 20260124060302_cm8wo UK003N 2026-01-25T14:16:02.415Z 2026-01-29T14:48:25.688Z
9256061 9256061 20260124054826_r82EU UK003N 2026-01-25T14:15:40.998Z 2026-01-29T14:48:20.910Z
9255858 9255858 20260124050937_0Fnxa UK003N 2026-01-25T14:14:59.803Z 2026-01-29T14:48:01.869Z
9255851 9255851 20260124050917_ylGs6 UK003N 2026-01-25T14:14:59.255Z 2026-01-29T14:48:01.694Z
9255778 9255778 20260124045436_uaepa UK003N 2026-01-25T14:14:40.608Z 2026-01-29T14:47:56.948Z
9254961 9254961 20260123233746_wjmkR UK003N 2026-01-25T14:11:29.240Z 2026-01-29T14:46:57.699Z
9254885 9254885 20260123221846_8i862 UK003N 2026-01-25T14:11:03.524Z 2026-01-29T14:46:53.788Z
9254846 9254846 20260123215630_Vsu2x UK003N 2026-01-25T14:10:56.066Z 2026-01-29T14:46:45.448Z
9252219 9252219 20260123014818_MAkdM UK003N 2026-01-24T14:14:46.768Z 2026-01-29T14:52:40.372Z
9243714 9243714 20260121051047_NjMZV UK003N 2026-01-22T14:22:50.241Z 2026-01-29T15:05:24.833Z
9243506 9243506 20260121044149_iU2yt UK003N 2026-01-22T14:22:06.520Z 2026-01-29T15:05:16.200Z
9230605 9230605 20260119043951_emnOD UK003N 2026-01-20T14:28:53.201Z 2026-01-27T15:05:16.463Z
9230519 9230519 20260119042858_mGKpT UK003N 2026-01-20T14:28:21.116Z 2026-01-27T15:05:00.911Z
9228564 9228564 20260118225405_x6xju UK003N 2026-01-20T14:18:25.136Z 2026-01-27T15:02:08.005Z
9228484 9228484 20260118223241_ZGO3c UK003N 2026-01-20T14:18:00.115Z 2026-01-27T15:02:03.747Z
9228449 9228449 20260118222550_OGNBf UK003N 2026-01-20T14:17:52.335Z 2026-01-27T15:02:01.966Z
9219675 9219675 20260116000305_oIeAh UK003N 2026-01-18T14:21:10.708Z 2026-01-24T15:11:08.475Z
9204289 9204289 20260114062546_9thbQ UK003N 2026-01-15T14:27:01.177Z 2026-01-22T15:10:24.530Z
9204255 9204255 20260114062011_DSQD2 UK003N 2026-01-15T14:26:54.468Z 2026-01-22T15:10:23.168Z
9204229 9204229 20260114061718_CHORA UK003N 2026-01-15T14:26:51.701Z 2026-01-22T15:10:22.607Z
9204143 9204143 20260114061014_L47rf UK003N 2026-01-15T14:26:30.671Z 2026-01-22T15:10:21.020Z
9204028 9204028 20260114060417_MaPVB UK003N 2026-01-15T14:26:17.552Z 2026-01-22T15:10:17.179Z
9203943 9203943 20260114055832_N0VaQ UK003N 2026-01-15T14:25:55.393Z 2026-01-22T15:10:15.990Z
9203927 9203927 20260114055658_QEIZ6 UK003N 2026-01-15T14:25:53.973Z 2026-01-22T15:10:15.813Z
9203777 9203777 20260114053712_X80oV UK003N 2026-01-15T14:25:23.374Z 2026-01-22T15:10:13.423Z
9203736 9203736 20260114053336_O90hl UK003N 2026-01-15T14:25:17.569Z 2026-01-22T15:10:12.821Z
9203607 9203607 20260114052158_OBkfQ UK003N 2026-01-15T14:25:00.644Z 2026-01-22T15:10:10.759Z
9202971 9202971 20260114042337_g3vtJ UK003N 2026-01-15T14:22:57.118Z 2026-01-22T15:10:00.222Z
9202949 9202949 20260114042107_dkgVw UK003N 2026-01-15T14:22:52.028Z 2026-01-22T15:09:59.872Z
9202848 9202848 20260114041313_TOge1 UK003N 2026-01-15T14:22:37.933Z 2026-01-22T15:09:57.869Z
9202639 9202639 20260114035709_ta3R7 UK003N 2026-01-15T14:21:54.429Z 2026-01-22T15:09:24.109Z
9202583 9202583 20260114035221_ySoo6 UK003N 2026-01-15T14:21:44.255Z 2026-01-22T15:09:23.421Z
9202572 9202572 20260114035204_3fgFW UK003N 2026-01-15T14:21:43.122Z 2026-01-22T15:09:23.225Z
9202478 9202478 20260114034213_4wNCB UK003N 2026-01-15T14:21:29.839Z 2026-01-22T15:09:21.031Z
9202095 9202095 20260114031554_CdIOa UK003N 2026-01-15T14:20:31.192Z 2026-01-22T15:09:13.433Z
9201908 9201908 20260114030549_YOZdv UK003N 2026-01-15T14:20:06.764Z 2026-01-22T15:09:11.274Z
9201690 9201690 20260114024132_auZC1 UK003N 2026-01-15T14:19:18.037Z 2026-01-22T15:09:07.422Z
9182200 9182200 20260111044120_IIjWO UK003N 2026-01-12T14:13:42.110Z 2026-01-19T15:18:20.451Z
9182171 9182171 20260111043433_4JGgW UK003N 2026-01-12T14:13:34.216Z 2026-01-19T15:18:18.561Z
9181971 9181971 20260111035248_sOc8v UK003N 2026-01-12T14:12:46.640Z 2026-01-19T15:17:58.349Z
9181925 9181925 20260111034318_gH098 UK003N 2026-01-12T14:12:36.377Z 2026-01-19T15:17:54.381Z
9181880 9181880 20260111033550_xuibb UK003N 2026-01-12T14:12:27.940Z 2026-01-19T15:17:52.151Z
9181414 9181414 20260111014101_N9rJu UK003N 2026-01-12T14:10:43.997Z 2026-01-19T15:17:16.988Z
9180571 9180571 20260110205557_vsnO6 UK003N 2026-01-12T14:07:34.031Z 2026-01-19T15:16:22.976Z
9175828 9175828 20260110035524_0m6s3 UK003N 2026-01-11T14:07:27.708Z 2026-01-18T15:08:09.541Z
9175786 9175786 20260110034824_sIbUB UK003N 2026-01-11T14:07:22.010Z 2026-01-18T15:08:08.226Z
9175399 9175399 20260110022248_dmKwQ UK003N 2026-01-11T14:06:20.209Z 2026-01-18T15:07:44.259Z
9174715 9174715 20260109215602_6gpWO UK003N 2026-01-11T14:04:08.409Z 2026-01-18T15:07:07.217Z
9166507 9166507 20260107185624_fMvaF UK003N 2026-01-09T14:03:34.216Z 2026-01-16T15:09:58.984Z
9166367 9166367 20260107180341_ZOFzZ UK003N 2026-01-09T14:02:53.852Z 2026-01-16T15:09:49.864Z
9160504 9160504 20260106060436_k7kJS UK003N 2026-01-07T14:12:50.717Z 2026-01-13T15:09:28.907Z
9158588 9158588 20260105232956_BXnhd UK003N 2026-01-07T14:06:39.495Z 2026-01-13T15:07:31.557Z
9158502 9158502 20260105224818_5JgLU UK003N 2026-01-07T14:06:18.659Z 2026-01-13T15:07:25.386Z
9158446 9158446 20260105222913_MI7Od UK003N 2026-01-07T14:06:08.252Z 2026-01-13T15:07:22.701Z
9158444 9158444 20260105222854_7kjHX UK003N 2026-01-07T14:06:07.469Z 2026-01-13T15:07:22.521Z
9158431 9158431 20260105222853_KRgNi UK003N 2026-01-07T14:06:05.820Z 2026-01-13T15:07:22.186Z
9158418 9158418 20260105222632_tXVC9 UK003N 2026-01-07T14:06:02.388Z 2026-01-13T15:07:21.485Z
9158396 9158396 20260105221443_Xbl6N UK003N 2026-01-07T14:05:55.676Z 2026-01-13T15:07:20.345Z
9158225 9158225 20260105210524_0SPAf UK003N 2026-01-07T14:05:25.252Z 2026-01-13T15:07:12.117Z
9158181 9158181 20260105205219_zk024 UK003N 2026-01-07T14:05:14.261Z 2026-01-13T15:07:02.842Z
9157973 9157973 20260105193511_u2HVj UK003N 2026-01-07T14:04:22.300Z 2026-01-13T15:06:48.183Z
9157810 9157810 20260105184833_PWH2O UK003N 2026-01-07T14:03:38.167Z 2026-01-13T15:06:30.172Z
9157662 9157662 20260105181601_63AJw UK003N 2026-01-07T14:03:05.795Z 2026-01-13T15:06:23.157Z
9156140 9156140 20260104065325_AAd2P UK003N 2026-01-06T14:38:39.604Z 2026-01-12T15:11:41.202Z
9150193 9150193 20260105012806_1OA5O UK003N 2026-01-06T14:09:01.022Z 2026-01-13T15:13:10.125Z
9150011 9150011 20260105003010_jOkW1 UK003N 2026-01-06T14:08:09.994Z 2026-01-13T15:12:51.391Z
9149182 9149182 20260104191543_5i71I UK003N 2026-01-06T14:04:11.964Z 2026-01-13T15:11:47.108Z
9149166 9149166 20260104190909_h9iPu UK003N 2026-01-06T14:04:08.089Z 2026-01-13T15:11:46.233Z
9148958 9148958 20260104181828_sOU3u UK003N 2026-01-06T14:03:14.736Z 2026-01-13T15:11:28.975Z
9148325 9148325 20260103173927_UQsYA UK003N 2026-01-05T14:30:24.387Z 2026-01-10T15:04:25.653Z
9148186 9148186 20260103173322_8BGzV UK003N 2026-01-05T14:30:20.313Z 2026-01-10T15:04:19.684Z
9148009 9148009 20260103172721_Lwdhu UK003N 2026-01-05T14:30:07.953Z 2026-01-10T15:04:12.177Z
9147713 9147713 20260104063402_3hlta UK003N 2026-01-05T14:24:45.445Z 2026-01-12T15:11:33.644Z
9147683 9147683 20260104063011_3jc02 UK003N 2026-01-05T14:24:42.597Z 2026-01-12T15:11:31.547Z
9147656 9147656 20260104062329_Sk2al UK003N 2026-01-05T14:24:40.342Z 2026-01-12T15:11:28.153Z
9147636 9147636 20260104062048_NBceU UK003N 2026-01-05T14:24:39.199Z 2026-01-12T15:11:27.146Z
9147632 9147632 20260104062025_cI21q UK003N 2026-01-05T14:24:38.914Z 2026-01-12T15:11:26.880Z
9147490 9147490 20260104055654_oFF32 UK003N 2026-01-05T14:24:14.366Z 2026-01-12T15:11:02.979Z
9147457 9147457 20260104055225_2nvzS UK003N 2026-01-05T14:24:11.392Z 2026-01-12T15:10:58.082Z
9147441 9147441 20260104054948_yVDC4 UK003N 2026-01-05T14:24:10.686Z 2026-01-12T15:10:56.873Z
9147280 9147280 20260104052637_qJNLC UK003N 2026-01-05T14:23:59.010Z 2026-01-12T15:10:27.931Z
9147259 9147259 20260104052453_GF1dq UK003N 2026-01-05T14:23:57.805Z 2026-01-12T15:10:26.852Z
9147246 9147246 20260104052244_m602K UK003N 2026-01-05T14:23:56.344Z 2026-01-12T15:10:25.804Z
9147220 9147220 20260104052018_T0ZHu UK003N 2026-01-05T14:23:44.288Z 2026-01-12T15:10:22.658Z

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