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

8,866 rows where station_code = "UK009L" 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
9273224 9273224 20260128051033_lXpw9 UK009L 2026-01-29T14:29:02.431Z 2026-01-29T14:30:25.771Z
9273167 9273167 20260128050159_6Lo1V UK009L 2026-01-29T14:28:53.862Z 2026-01-29T14:30:25.762Z
9273148 9273148 20260128045206_syodL UK009L 2026-01-29T14:28:51.251Z 2026-01-29T14:30:25.759Z
9273111 9273111 20260128044518_PeI8V UK009L 2026-01-29T14:28:46.079Z 2026-01-29T14:30:25.752Z
9272962 9272962 20260128041132_JT3M2 UK009L 2026-01-29T14:28:19.086Z 2026-01-29T14:30:25.724Z
9272903 9272903 20260128035850_h0dbG UK009L 2026-01-29T14:28:13.326Z 2026-01-29T14:30:25.705Z
9272893 9272893 20260128035839_Ntba5 UK009L 2026-01-29T14:28:12.984Z 2026-01-29T14:30:25.704Z
9272866 9272866 20260128035401_sM26T UK009L 2026-01-29T14:28:04.592Z 2026-01-29T14:30:25.700Z
9272443 9272443 20260128020653_lxFJ3 UK009L 2026-01-29T14:26:39.584Z 2026-01-29T14:30:25.346Z
9272413 9272413 20260128015909_T1k56 UK009L 2026-01-29T14:26:36.971Z 2026-01-29T14:30:25.343Z
9272403 9272403 20260128015556_R37vM UK009L 2026-01-29T14:26:35.735Z 2026-01-29T14:30:25.342Z
9272387 9272387 20260128015145_da7d6 UK009L 2026-01-29T14:26:34.220Z 2026-01-29T14:30:25.340Z
9272271 9272271 20260128010754_J9l4b UK009L 2026-01-29T14:26:09.409Z 2026-01-29T14:30:25.319Z
9272225 9272225 20260128004834_wVpQ2 UK009L 2026-01-29T14:25:57.876Z 2026-01-29T14:30:25.309Z
9272014 9272014 20260127225628_0WJWn UK009L 2026-01-29T14:25:17.715Z 2026-01-29T14:30:25.264Z
9260028 9260028 20260125020831_JpyJT UK009L 2026-01-26T14:19:49.855Z 2026-01-29T14:43:42.360Z
9254661 9254661 20260123204123_m9pAh UK009L 2026-01-25T14:10:17.711Z 2026-01-29T14:46:34.674Z
9254395 9254395 20260123185300_qgv2r UK009L 2026-01-25T14:08:58.723Z 2026-01-29T14:46:13.820Z
9251932 9251932 20260123000149_KNX93 UK009L 2026-01-24T14:13:45.344Z 2026-01-29T14:52:17.504Z
9251773 9251773 20260122223635_E9dnT UK009L 2026-01-24T14:13:10.191Z 2026-01-29T14:52:08.928Z
9251770 9251770 20260122223144_Jasug UK009L 2026-01-24T14:13:09.675Z 2026-01-29T14:52:08.671Z
9251682 9251682 20260122220354_N2Zcv UK009L 2026-01-24T14:12:53.147Z 2026-01-29T14:51:58.822Z
9243752 9243752 20260121051231_9qaXR UK009L 2026-01-22T14:22:54.959Z 2026-01-29T15:05:26.057Z
9237973 9237973 20260120064100_0qIuO UK009L 2026-01-21T14:28:10.259Z 2026-01-28T15:02:01.223Z
9235331 9235331 20260120005707_m7Ctx UK009L 2026-01-21T14:18:29.891Z 2026-01-28T14:58:49.599Z
9214504 9214504 20260116064602_2GprW UK009L 2026-01-17T14:21:48.544Z 2026-01-24T15:13:43.899Z
9212908 9212908 20260116013708_X4rQx UK009L 2026-01-17T14:14:31.479Z 2026-01-24T15:11:33.804Z
9204377 9204377 20260114063432_jOntL UK009L 2026-01-15T14:27:11.040Z 2026-01-22T15:10:26.670Z
9204362 9204362 20260114063012_sQYhw UK009L 2026-01-15T14:27:08.175Z 2026-01-22T15:10:25.378Z
9204332 9204332 20260114062801_oL1H9 UK009L 2026-01-15T14:27:04.336Z 2026-01-22T15:10:24.983Z
9204314 9204314 20260114062557_0wd6j UK009L 2026-01-15T14:27:02.378Z 2026-01-22T15:10:24.698Z
9204021 9204021 20260114060337_Buh3O UK009L 2026-01-15T14:26:16.497Z 2026-01-22T15:10:17.029Z
9203990 9203990 20260114060230_y1zPY UK009L 2026-01-15T14:26:09.283Z 2026-01-22T15:10:16.646Z
9203801 9203801 20260114053755_0mbQ3 UK009L 2026-01-15T14:25:24.539Z 2026-01-22T15:10:13.617Z
9203639 9203639 20260114052430_ixst9 UK009L 2026-01-15T14:25:03.319Z 2026-01-22T15:10:11.242Z
9203596 9203596 20260114052118_JZLHU UK009L 2026-01-15T14:24:58.820Z 2026-01-22T15:10:10.599Z
9203566 9203566 20260114051759_AsHcX UK009L 2026-01-15T14:24:48.010Z 2026-01-22T15:10:09.975Z
9203531 9203531 20260114051537_JA22l UK009L 2026-01-15T14:24:44.485Z 2026-01-22T15:10:09.564Z
9203471 9203471 20260114050007_PrHJA UK009L 2026-01-15T14:24:30.205Z 2026-01-22T15:10:08.402Z
9203375 9203375 20260114045313_QQs0A UK009L 2026-01-15T14:24:11.033Z 2026-01-22T15:10:06.435Z
9203301 9203301 20260114044939_ni9li UK009L 2026-01-15T14:24:01.335Z 2026-01-22T15:10:05.423Z
9203161 9203161 20260114043820_NvJD3 UK009L 2026-01-15T14:23:27.421Z 2026-01-22T15:10:02.779Z
9203136 9203136 20260114043642_Q6rA1 UK009L 2026-01-15T14:23:24.178Z 2026-01-22T15:10:02.350Z
9202993 9202993 20260114042411_zW7IG UK009L 2026-01-15T14:23:00.333Z 2026-01-22T15:10:00.450Z
9202862 9202862 20260114041403_ZHM2q UK009L 2026-01-15T14:22:39.958Z 2026-01-22T15:09:58.206Z
9202755 9202755 20260114040731_o82KS UK009L 2026-01-15T14:22:18.057Z 2026-01-22T15:09:39.158Z
9202693 9202693 20260114040259_rrbbs UK009L 2026-01-15T14:22:09.333Z 2026-01-22T15:09:27.300Z
9202658 9202658 20260114035846_BsIxg UK009L 2026-01-15T14:21:57.141Z 2026-01-22T15:09:24.382Z
9202439 9202439 20260114033811_yhIke UK009L 2026-01-15T14:21:18.712Z 2026-01-22T15:09:18.607Z
9202419 9202419 20260114033619_uZ0Io UK009L 2026-01-15T14:21:14.289Z 2026-01-22T15:09:17.411Z
9202395 9202395 20260114033358_p918a UK009L 2026-01-15T14:21:11.614Z 2026-01-22T15:09:17.121Z
9202367 9202367 20260114033321_zy7ae UK009L 2026-01-15T14:21:08.758Z 2026-01-22T15:09:16.792Z
9202207 9202207 20260114032340_dQMSU UK009L 2026-01-15T14:20:42.436Z 2026-01-22T15:09:14.880Z
9201901 9201901 20260114030533_eR9t2 UK009L 2026-01-15T14:20:05.664Z 2026-01-22T15:09:11.140Z
9201457 9201457 20260114021828_qKoF4 UK009L 2026-01-15T14:18:41.266Z 2026-01-22T15:09:04.098Z
9201348 9201348 20260114021131_Ba0W3 UK009L 2026-01-15T14:18:17.804Z 2026-01-22T15:09:02.140Z
9181586 9181586 20260111022141_5Vh6o UK009L 2026-01-12T14:11:21.684Z 2026-01-19T15:17:37.507Z
9181347 9181347 20260111012705_rd03S UK009L 2026-01-12T14:10:29.135Z 2026-01-19T15:17:13.846Z
9180609 9180609 20260110210852_Yxzac UK009L 2026-01-12T14:07:41.740Z 2026-01-19T15:16:24.498Z
9177024 9177024 20260110065655_cW34m UK009L 2026-01-11T14:10:39.153Z 2026-01-18T15:09:11.808Z
9176930 9176930 20260110064202_V2Esy UK009L 2026-01-11T14:10:25.044Z 2026-01-18T15:09:08.186Z
9176901 9176901 20260110063753_tAiqI UK009L 2026-01-11T14:10:18.286Z 2026-01-18T15:09:06.805Z
9176893 9176893 20260110063720_UVIL8 UK009L 2026-01-11T14:10:17.223Z 2026-01-18T15:09:06.507Z
9176881 9176881 20260110063503_KyoVs UK009L 2026-01-11T14:10:15.776Z 2026-01-18T15:09:06.142Z
9176680 9176680 20260110060402_GDPnB UK009L 2026-01-11T14:09:43.073Z 2026-01-18T15:08:48.831Z
9176647 9176647 20260110060132_Gfhlq UK009L 2026-01-11T14:09:37.492Z 2026-01-18T15:08:47.422Z
9176629 9176629 20260110055909_ppcTh UK009L 2026-01-11T14:09:33.407Z 2026-01-18T15:08:46.640Z
9176619 9176619 20260110055830_OhWEn UK009L 2026-01-11T14:09:30.231Z 2026-01-18T15:08:46.271Z
9176585 9176585 20260110054952_rIn77 UK009L 2026-01-11T14:09:23.583Z 2026-01-18T15:08:44.872Z
9176543 9176543 20260110054149_uudLN UK009L 2026-01-11T14:09:17.612Z 2026-01-18T15:08:43.291Z
9176488 9176488 20260110053725_h3Bdb UK009L 2026-01-11T14:09:09.615Z 2026-01-18T15:08:41.106Z
9176440 9176440 20260110053036_AD5Md UK009L 2026-01-11T14:09:01.714Z 2026-01-18T15:08:39.232Z
9176292 9176292 20260110051203_GDuxm UK009L 2026-01-11T14:08:39.236Z 2026-01-18T15:08:26.304Z
9176197 9176197 20260110050107_M0Mo7 UK009L 2026-01-11T14:08:26.814Z 2026-01-18T15:08:23.765Z
9176172 9176172 20260110045820_5BH1S UK009L 2026-01-11T14:08:22.129Z 2026-01-18T15:08:22.814Z
9176061 9176061 20260110043825_KkJHU UK009L 2026-01-11T14:08:08.002Z 2026-01-18T15:08:18.313Z
9175863 9175863 20260110040044_Fi6t3 UK009L 2026-01-11T14:07:33.691Z 2026-01-18T15:08:11.181Z
9175759 9175759 20260110034209_iDQ9t UK009L 2026-01-11T14:07:17.627Z 2026-01-18T15:08:07.137Z
9175733 9175733 20260110033854_JyVct UK009L 2026-01-11T14:07:15.251Z 2026-01-18T15:08:06.426Z
9175677 9175677 20260110032246_bay94 UK009L 2026-01-11T14:07:03.387Z 2026-01-18T15:07:55.952Z
9175615 9175615 20260110031046_S3WHS UK009L 2026-01-11T14:06:54.455Z 2026-01-18T15:07:53.526Z
9175601 9175601 20260110030832_kPSky UK009L 2026-01-11T14:06:52.994Z 2026-01-18T15:07:53.132Z
9175595 9175595 20260110030718_q04lW UK009L 2026-01-11T14:06:51.950Z 2026-01-18T15:07:52.850Z
9175572 9175572 20260110030115_aJ36F UK009L 2026-01-11T14:06:48.141Z 2026-01-18T15:07:50.868Z
9175560 9175560 20260110025821_J8kK7 UK009L 2026-01-11T14:06:45.628Z 2026-01-18T15:07:50.425Z
9175487 9175487 20260110023841_i6OF9 UK009L 2026-01-11T14:06:32.527Z 2026-01-18T15:07:47.220Z
9175472 9175472 20260110023507_ip3wE UK009L 2026-01-11T14:06:30.695Z 2026-01-18T15:07:46.789Z
9175456 9175456 20260110023052_veVQ8 UK009L 2026-01-11T14:06:28.320Z 2026-01-18T15:07:46.354Z
9175242 9175242 20260110014655_zFoT2 UK009L 2026-01-11T14:05:48.550Z 2026-01-18T15:07:38.322Z
9174839 9174839 20260109232700_jIUaI UK009L 2026-01-11T14:04:34.877Z 2026-01-18T15:07:13.276Z
9170370 9170370 20260105202553_960eZ UK009L 2026-01-09T14:21:51.069Z 2026-01-13T15:06:58.231Z
9160600 9160600 20260106063116_yXUjG UK009L 2026-01-07T14:13:07.157Z 2026-01-13T15:09:34.584Z
9160549 9160549 20260106061831_nv77u UK009L 2026-01-07T14:12:58.455Z 2026-01-13T15:09:32.249Z
9160366 9160366 20260106053836_nQwlY UK009L 2026-01-07T14:12:22.739Z 2026-01-13T15:09:22.306Z
9160104 9160104 20260106044712_iwAi1 UK009L 2026-01-07T14:11:24.927Z 2026-01-13T15:09:00.830Z
9160094 9160094 20260106044658_Sowf7 UK009L 2026-01-07T14:11:22.545Z 2026-01-13T15:09:00.230Z
9160051 9160051 20260106043515_y1ekK UK009L 2026-01-07T14:11:11.616Z 2026-01-13T15:08:58.048Z
9160018 9160018 20260106043026_d5ndc UK009L 2026-01-07T14:11:05.883Z 2026-01-13T15:08:56.673Z
9159761 9159761 20260106034040_YgoX5 UK009L 2026-01-07T14:10:20.150Z 2026-01-13T15:08:39.892Z
9159526 9159526 20260106025631_CK7iM UK009L 2026-01-07T14:09:37.314Z 2026-01-13T15:08:29.034Z

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