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

1,222 rows where station_code = "UK00CU" 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
8681240 8681240 20251203024800_tY6RW UK00CU 2025-12-04T14:14:06.943Z 2025-12-05T14:21:28.416Z
8676161 8676161 20251202053907_eBwmt UK00CU 2025-12-03T14:24:47.195Z 2025-12-05T14:28:49.702Z
8676103 8676103 20251202053701_ezluA UK00CU 2025-12-03T14:24:42.235Z 2025-12-05T14:28:48.593Z
8675048 8675048 20251202035519_DVknV UK00CU 2025-12-03T14:22:52.634Z 2025-12-05T14:28:09.948Z
8674743 8674743 20251202031907_ukCzG UK00CU 2025-12-03T14:22:17.247Z 2025-12-05T14:28:01.712Z
8674522 8674522 20251202024058_7TYTd UK00CU 2025-12-03T14:21:44.003Z 2025-12-05T14:27:52.212Z
8661901 8661901 20251130173013_3GTHD UK00CU 2025-12-02T14:13:34.185Z 2025-12-05T14:32:40.971Z
8658025 8658025 20251130062941_ERpmy UK00CU 2025-12-01T14:34:51.672Z 2025-12-05T14:46:00.856Z
8655774 8655774 20251130041716_FBBEC UK00CU 2025-12-01T14:27:27.600Z 2025-12-05T14:44:38.667Z
8655634 8655634 20251130041025_AjbhP UK00CU 2025-12-01T14:27:19.071Z 2025-12-05T14:44:36.582Z
8655060 8655060 20251130034210_NHNlI UK00CU 2025-12-01T14:26:19.485Z 2025-12-05T14:44:27.268Z
8654591 8654591 20251130032105_vb2YR UK00CU 2025-12-01T14:25:36.007Z 2025-12-05T14:44:12.580Z
8654136 8654136 20251130030000_2HcR7 UK00CU 2025-12-01T14:24:53.956Z 2025-12-05T14:43:47.745Z
8654129 8654129 20251130025958_Xm0PE UK00CU 2025-12-01T14:24:53.640Z 2025-12-05T14:43:47.683Z
8653988 8653988 20251130025036_Jz3bE UK00CU 2025-12-01T14:24:34.352Z 2025-12-05T14:43:44.243Z
8653683 8653683 20251130023353_aFu7a UK00CU 2025-12-01T14:23:55.589Z 2025-12-05T14:43:37.540Z
8653094 8653094 20251130015540_3dMTR UK00CU 2025-12-01T14:22:46.007Z 2025-12-05T14:43:03.177Z
8653065 8653065 20251130015339_LXacU UK00CU 2025-12-01T14:22:43.607Z 2025-12-05T14:43:02.286Z
8652334 8652334 20251130010316_tv79o UK00CU 2025-12-01T14:21:16.466Z 2025-12-05T14:42:42.895Z
8644657 8644657 20251128194031_qNLYp UK00CU 2025-11-30T14:22:12.664Z 2025-12-05T14:50:25.272Z
8633301 8633301 20251127225959_mwPkj UK00CU 2025-11-29T14:19:22.498Z 2025-12-05T14:57:26.059Z
8632940 8632940 20251127222013_MIFk2 UK00CU 2025-11-29T14:18:35.363Z 2025-12-05T14:56:49.574Z
8632692 8632692 20251127213931_6Efm7 UK00CU 2025-11-29T14:18:01.386Z 2025-12-05T14:56:32.884Z
8632195 8632195 20251127203950_nBL4d UK00CU 2025-11-29T14:17:06.361Z 2025-12-05T14:56:16.841Z
8616443 8616443 20251126060019_l9ba6 UK00CU 2025-11-27T14:31:12.084Z 2025-12-04T15:11:39.541Z
8614799 8614799 20251126042748_W9Gbp UK00CU 2025-11-27T14:28:34.015Z 2025-12-04T15:11:10.879Z
8614644 8614644 20251126042249_qMXQT UK00CU 2025-11-27T14:28:13.449Z 2025-12-04T15:10:57.312Z
8614318 8614318 20251126040332_Y8Wg0 UK00CU 2025-11-27T14:27:45.833Z 2025-12-04T15:10:34.880Z
8614058 8614058 20251126034922_SAzLo UK00CU 2025-11-27T14:27:08.558Z 2025-12-04T15:10:14.718Z
8613852 8613852 20251126033728_zQZrb UK00CU 2025-11-27T14:26:51.884Z 2025-12-04T15:09:52.666Z
8613809 8613809 20251126033415_BeVwB UK00CU 2025-11-27T14:26:44.680Z 2025-12-04T15:09:51.951Z
8613627 8613627 20251126032644_KrURW UK00CU 2025-11-27T14:26:18.890Z 2025-12-04T15:09:49.969Z
8612408 8612408 20251126023020_prBFu UK00CU 2025-11-27T14:24:07.304Z 2025-12-04T15:09:30.500Z
8612368 8612368 20251126022832_X6YVC UK00CU 2025-11-27T14:23:52.675Z 2025-12-04T15:09:30.093Z
8612088 8612088 20251126021844_zFdqV UK00CU 2025-11-27T14:23:30.190Z 2025-11-27T14:32:44.419Z
8611651 8611651 20251126015347_0PjEC UK00CU 2025-11-27T14:22:23.553Z 2025-12-04T15:09:23.053Z
8610692 8610692 20251126010232_77Y8c UK00CU 2025-11-27T14:20:43.375Z 2025-12-04T15:08:30.539Z
8609812 8609812 20251126000814_6NTMb UK00CU 2025-11-27T14:18:57.710Z 2025-12-04T15:07:57.491Z
8608604 8608604 20251125223121_nnU1v UK00CU 2025-11-27T14:16:22.420Z 2025-12-04T15:07:46.883Z
8608341 8608341 20251125220841_wIS3L UK00CU 2025-11-27T14:15:42.925Z 2025-12-04T15:07:43.765Z
8608009 8608009 20251125214402_nL90v UK00CU 2025-11-27T14:15:04.934Z 2025-12-04T15:07:40.094Z
8606709 8606709 20251125193031_jd5Pb UK00CU 2025-11-27T14:11:00.267Z 2025-12-04T15:06:49.041Z
8602140 8602140 20251125043701_otQqw UK00CU 2025-11-26T14:25:21.841Z 2025-12-02T15:09:29.561Z
8601546 8601546 20251125035440_Yyh4H UK00CU 2025-11-26T14:24:25.375Z 2025-12-02T15:09:12.019Z
8600751 8600751 20251125031649_1xcFv UK00CU 2025-11-26T14:22:57.161Z 2025-12-02T15:08:50.048Z
8600717 8600717 20251125031430_5Vupm UK00CU 2025-11-26T14:22:55.212Z 2025-12-02T15:08:49.839Z
8599452 8599452 20251125020628_Ic0ca UK00CU 2025-11-26T14:20:56.228Z 2025-12-02T15:08:23.895Z
8597710 8597710 20251125000259_dpQeP UK00CU 2025-11-26T14:17:25.200Z 2025-12-02T15:07:40.102Z
8597247 8597247 20251124231618_ym39y UK00CU 2025-11-26T14:16:25.868Z 2025-12-02T15:07:27.397Z
8596603 8596603 20251124214058_KOlIL UK00CU 2025-11-26T14:14:58.896Z 2025-12-02T15:07:03.209Z
8596511 8596511 20251124212104_U1Glk UK00CU 2025-11-26T14:14:40.051Z 2025-12-02T15:07:01.393Z
8596260 8596260 20251124203422_37rIF UK00CU 2025-11-26T14:14:05.063Z 2025-12-02T15:06:51.697Z
8591401 8591401 20251124041118_PCVcL UK00CU 2025-11-25T14:24:18.803Z 2025-12-02T15:12:58.565Z
8591288 8591288 20251124040141_qSLFa UK00CU 2025-11-25T14:23:50.503Z 2025-12-02T15:12:57.771Z
8591259 8591259 20251124035541_ahTgi UK00CU 2025-11-25T14:23:48.095Z 2025-12-02T15:12:57.619Z
8591205 8591205 20251124035259_9Tp9f UK00CU 2025-11-25T14:23:44.631Z 2025-12-02T15:12:57.419Z
8591038 8591038 20251124033924_Cd8No UK00CU 2025-11-25T14:23:20.471Z 2025-12-02T15:12:56.758Z
8590318 8590318 20251124023358_4hkW2 UK00CU 2025-11-25T14:21:39.650Z 2025-12-02T15:12:46.291Z
8590220 8590220 20251124022927_BGbLl UK00CU 2025-11-25T14:21:33.190Z 2025-12-02T15:12:43.332Z
8589475 8589475 20251124013705_Q0WAZ UK00CU 2025-11-25T14:20:06.936Z 2025-12-02T15:12:31.306Z
8588795 8588795 20251124003115_oS0A8 UK00CU 2025-11-25T14:18:18.566Z 2025-12-02T15:11:56.266Z
8588742 8588742 20251124002822_IzrLF UK00CU 2025-11-25T14:18:13.545Z 2025-12-02T15:11:51.494Z
8588402 8588402 20251123235217_unEBd UK00CU 2025-11-25T14:17:30.364Z 2025-12-02T15:11:41.200Z
8588340 8588340 20251123234227_3Odph UK00CU 2025-11-25T14:17:16.831Z 2025-12-02T15:11:40.387Z
8587742 8587742 20251123223727_TCazm UK00CU 2025-11-25T14:15:58.478Z 2025-12-02T15:11:19.320Z
8587578 8587578 20251123221827_xgIpG UK00CU 2025-11-25T14:15:34.179Z 2025-12-02T15:11:17.491Z
8587214 8587214 20251123213610_CA2Zz UK00CU 2025-11-25T14:14:51.238Z 2025-12-02T15:11:09.299Z
8569861 8569861 20251121061950_GyF9J UK00CU 2025-11-23T14:32:33.404Z 2025-11-29T14:54:49.157Z
8569471 8569471 20251121055728_cRpWd UK00CU 2025-11-23T14:32:15.940Z 2025-11-29T14:54:48.304Z
8569137 8569137 20251121054632_AzZFG UK00CU 2025-11-23T14:31:55.271Z 2025-11-29T14:54:47.832Z
8568923 8568923 20251121054126_rzEyO UK00CU 2025-11-23T14:31:48.427Z 2025-11-29T14:54:47.633Z
8564675 8564675 20251121185418_3hJfD UK00CU 2025-11-23T14:11:29.957Z 2025-11-30T15:04:25.726Z
8564378 8564378 20251121182158_v5y5m UK00CU 2025-11-23T14:10:39.367Z 2025-11-30T15:04:17.035Z
8558554 8558554 20251121033217_rROs6 UK00CU 2025-11-22T14:41:07.631Z 2025-11-29T14:54:36.284Z
8557378 8557378 20251121024707_IWEhO UK00CU 2025-11-22T14:40:03.444Z 2025-11-29T14:54:34.105Z
8557319 8557319 20251121024423_oStQP UK00CU 2025-11-22T14:39:58.662Z 2025-11-29T14:54:33.815Z
8556454 8556454 20251121015436_93n3G UK00CU 2025-11-22T14:39:33.876Z 2025-11-29T14:54:32.374Z
8556163 8556163 20251121014006_BK63b UK00CU 2025-11-22T14:39:03.722Z 2025-11-29T14:54:31.867Z
8555711 8555711 20251121011722_dblsg UK00CU 2025-11-22T14:38:49.747Z 2025-11-29T14:54:30.925Z
8554847 8554847 20251121004058_Krd36 UK00CU 2025-11-22T14:37:26.739Z 2025-11-29T14:54:29.090Z
8553900 8553900 20251120061347_C3kQz UK00CU 2025-11-22T14:34:31.928Z 2025-11-28T14:58:36.311Z
8553295 8553295 20251120052044_7vPva UK00CU 2025-11-22T14:33:49.425Z 2025-11-28T14:57:59.633Z
8552848 8552848 20251120043532_nvhHw UK00CU 2025-11-22T14:33:07.896Z 2025-11-28T14:57:41.934Z
8552824 8552824 20251120043256_rS3bE UK00CU 2025-11-22T14:33:06.563Z 2025-11-28T14:57:41.449Z
8552550 8552550 20251120041549_jY2tk UK00CU 2025-11-22T14:32:28.779Z 2025-11-28T14:57:34.860Z
8552108 8552108 20251120033827_FlzUY UK00CU 2025-11-22T14:31:49.957Z 2025-11-28T14:57:25.694Z
8552059 8552059 20251120032949_OuDpI UK00CU 2025-11-22T14:31:44.502Z 2025-11-28T14:57:24.209Z
8552015 8552015 20251120032737_AKmQG UK00CU 2025-11-22T14:31:42.331Z 2025-11-28T14:57:19.727Z
8552012 8552012 20251120032737_kkTft UK00CU 2025-11-22T14:31:42.121Z 2025-11-28T14:57:19.718Z
8551788 8551788 20251120031237_XBHxK UK00CU 2025-11-22T14:31:09.647Z 2025-11-28T14:57:13.091Z
8551408 8551408 20251120003155_4hyvO UK00CU 2025-11-22T14:27:53.824Z 2025-11-28T14:56:03.289Z
8551269 8551269 20251121003146_X3BF5 UK00CU 2025-11-22T14:22:20.721Z 2025-11-29T14:54:28.476Z
8551099 8551099 20251121002041_bKezi UK00CU 2025-11-22T14:22:00.217Z 2025-11-29T14:54:28.147Z
8550512 8550512 20251120235004_W53Is UK00CU 2025-11-22T14:21:02.836Z 2025-11-29T14:54:27.067Z
8549697 8549697 20251120225045_OuMMp UK00CU 2025-11-22T14:19:19.285Z 2025-11-29T14:54:25.329Z
8549263 8549263 20251120221253_asKxk UK00CU 2025-11-22T14:18:36.997Z 2025-11-29T14:54:24.388Z
8549097 8549097 20251120215033_B3tGk UK00CU 2025-11-22T14:18:20.825Z 2025-11-29T14:54:23.975Z
8546517 8546517 20251120183621_M93wc UK00CU 2025-11-22T14:12:54.028Z 2025-11-29T14:54:15.850Z
8546411 8546411 20251120183005_NDhkD UK00CU 2025-11-22T14:12:42.450Z 2025-11-29T14:54:15.317Z
8546261 8546261 20251120181229_n0i6G UK00CU 2025-11-22T14:12:15.397Z 2025-11-29T14:54:10.151Z

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