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

7,693 rows where station_code = "UK003D" 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
8691389 8691389 20251205051329_YiJqg UK003D 2025-12-06T14:17:33.818Z 2025-12-06T14:18:01.102Z
8691262 8691262 20251205041819_I6DyW UK003D 2025-12-06T14:17:03.775Z 2025-12-06T14:18:01.071Z
8683019 8683019 20251203061855_Iw81H UK003D 2025-12-04T14:18:26.939Z 2025-12-06T14:29:38.829Z
8682965 8682965 20251203061701_diBO9 UK003D 2025-12-04T14:18:24.053Z 2025-12-06T14:29:33.870Z
8682920 8682920 20251203061601_TwH62 UK003D 2025-12-04T14:18:20.930Z 2025-12-06T14:29:31.972Z
8682826 8682826 20251203060704_CexYB UK003D 2025-12-04T14:18:03.946Z 2025-12-06T14:29:26.820Z
8682756 8682756 20251203060229_3c3xR UK003D 2025-12-04T14:17:58.843Z 2025-12-06T14:29:24.397Z
8682663 8682663 20251203055810_JD02g UK003D 2025-12-04T14:17:52.749Z 2025-12-06T14:29:21.764Z
8682261 8682261 20251203050731_Kxzfr UK003D 2025-12-04T14:16:41.919Z 2025-12-06T14:28:51.338Z
8682103 8682103 20251203045156_NvXF5 UK003D 2025-12-04T14:16:27.507Z 2025-12-06T14:28:46.815Z
8681457 8681457 20251203031203_kAjMs UK003D 2025-12-04T14:14:45.361Z 2025-12-06T14:28:12.907Z
8681019 8681019 20251203021400_9J8ed UK003D 2025-12-04T14:13:34.054Z 2025-12-06T14:27:46.705Z
8675645 8675645 20251202050332_znz02 UK003D 2025-12-03T14:23:57.787Z 2025-12-06T14:34:57.483Z
8674451 8674451 20251202022610_mDRxj UK003D 2025-12-03T14:21:39.184Z 2025-12-06T14:34:09.406Z
8657939 8657939 20251130062133_CaprW UK003D 2025-12-01T14:34:47.223Z 2025-12-06T14:50:24.697Z
8657591 8657591 20251130055350_QlzsI UK003D 2025-12-01T14:34:34.216Z 2025-12-06T14:50:15.337Z
8657584 8657584 20251130055324_U0ICI UK003D 2025-12-01T14:34:33.838Z 2025-12-06T14:50:15.206Z
8657482 8657482 20251130054850_KEH3S UK003D 2025-12-01T14:34:30.589Z 2025-12-06T14:50:04.064Z
8657161 8657161 20251130053213_jVUGf UK003D 2025-12-01T14:33:57.213Z 2025-12-06T14:49:45.360Z
8656996 8656996 20251130052359_ST4xC UK003D 2025-12-01T14:33:51.655Z 2025-12-06T14:49:43.978Z
8656887 8656887 20251130051533_Nlcsd UK003D 2025-12-01T14:33:48.356Z 2025-12-06T14:49:42.736Z
8655687 8655687 20251130041152_4eH3J UK003D 2025-12-01T14:27:21.459Z 2025-12-06T14:49:26.576Z
8655641 8655641 20251130041032_qzGAS UK003D 2025-12-01T14:27:19.708Z 2025-12-06T14:49:26.186Z
8654951 8654951 20251130033941_XW6tZ UK003D 2025-12-01T14:26:12.726Z 2025-12-06T14:48:50.439Z
8654862 8654862 20251130033610_3kN7Y UK003D 2025-12-01T14:26:07.574Z 2025-12-06T14:48:49.216Z
8654600 8654600 20251130032225_KFfD3 UK003D 2025-12-01T14:25:37.061Z 2025-12-06T14:48:44.687Z
8654237 8654237 20251130030510_ZUwV9 UK003D 2025-12-01T14:25:00.832Z 2025-12-06T14:48:39.311Z
8653963 8653963 20251130024934_8KXez UK003D 2025-12-01T14:24:33.344Z 2025-12-06T14:48:35.130Z
8653492 8653492 20251130022034_QgluH UK003D 2025-12-01T14:23:35.451Z 2025-12-06T14:48:02.884Z
8653130 8653130 20251130015926_rTlnS UK003D 2025-12-01T14:22:52.043Z 2025-12-06T14:47:50.616Z
8653048 8653048 20251130015318_aE23X UK003D 2025-12-01T14:22:42.207Z 2025-12-06T14:47:48.771Z
8652938 8652938 20251130014610_D3wQI UK003D 2025-12-01T14:22:33.903Z 2025-12-06T14:47:46.543Z
8652897 8652897 20251130014428_Mv12R UK003D 2025-12-01T14:22:29.521Z 2025-12-06T14:47:45.239Z
8652891 8652891 20251130014419_Ln2oV UK003D 2025-12-01T14:22:29.172Z 2025-12-06T14:47:44.995Z
8649815 8649815 20251129183449_rwFZ1 UK003D 2025-12-01T14:14:02.515Z 2025-12-06T14:45:40.445Z
8637762 8637762 20251128063208_836Ow UK003D 2025-11-29T14:27:48.666Z 2025-12-06T15:04:03.925Z
8636776 8636776 20251128042730_UkMTm UK003D 2025-11-29T14:26:11.457Z 2025-12-06T15:03:41.929Z
8635478 8635478 20251128021642_l7gn2 UK003D 2025-11-29T14:23:27.896Z 2025-12-06T15:02:45.069Z
8634806 8634806 20251128011957_HtUbV UK003D 2025-11-29T14:22:04.704Z 2025-12-06T15:02:36.179Z
8634286 8634286 20251128003424_DmZK9 UK003D 2025-11-29T14:21:10.095Z 2025-12-06T15:01:58.037Z
8633785 8633785 20251127235453_VwQft UK003D 2025-11-29T14:20:23.660Z 2025-12-06T15:01:48.674Z
8633399 8633399 20251127231236_qUIdX UK003D 2025-11-29T14:19:40.878Z 2025-12-06T15:01:43.545Z
8616160 8616160 20251126054406_N3wKI UK003D 2025-11-27T14:30:39.076Z 2025-12-04T15:11:36.499Z
8615977 8615977 20251126053038_0kuOp UK003D 2025-11-27T14:30:19.632Z 2025-12-04T15:11:34.184Z
8615609 8615609 20251126051137_sSgUe UK003D 2025-11-27T14:30:01.462Z 2025-12-04T15:11:30.835Z
8614485 8614485 20251126041518_nYntk UK003D 2025-11-27T14:27:55.094Z 2025-12-04T15:10:45.129Z
8614251 8614251 20251126040031_Egc4o UK003D 2025-11-27T14:27:42.191Z 2025-12-04T15:10:33.463Z
8613333 8613333 20251126031415_Q6cNz UK003D 2025-11-27T14:25:38.789Z 2025-12-04T15:09:39.784Z
8613060 8613060 20251126030024_SBJpr UK003D 2025-11-27T14:25:21.248Z 2025-12-04T15:09:36.822Z
8610936 8610936 20251126011414_J2ge1 UK003D 2025-11-27T14:20:58.007Z 2025-12-04T15:08:45.267Z
8609520 8609520 20251125234644_krEAo UK003D 2025-11-27T14:18:18.854Z 2025-12-04T15:07:54.959Z
8609270 8609270 20251125232815_72Gzd UK003D 2025-11-27T14:17:59.694Z 2025-12-04T15:07:52.982Z
8608583 8608583 20251125223036_XPR7h UK003D 2025-11-27T14:16:21.463Z 2025-12-04T15:07:46.767Z
8607646 8607646 20251125210903_zFlMi UK003D 2025-11-27T14:14:08.687Z 2025-12-04T15:07:10.723Z
8604337 8604337 20251123185838_k35Xu UK003D 2025-11-26T14:33:09.820Z 2025-12-02T15:10:44.912Z
8603509 8603509 20251125061055_s810u UK003D 2025-11-26T14:27:28.963Z 2025-12-02T15:09:36.062Z
8603471 8603471 20251125061031_iAvK1 UK003D 2025-11-26T14:27:28.020Z 2025-12-02T15:09:35.963Z
8603461 8603461 20251125061031_ihZvP UK003D 2025-11-26T14:27:27.835Z 2025-12-02T15:09:35.962Z
8603427 8603427 20251125060929_PDaDL UK003D 2025-11-26T14:27:26.589Z 2025-12-02T15:09:35.842Z
8603325 8603325 20251125055718_tVb6C UK003D 2025-11-26T14:27:21.515Z 2025-12-02T15:09:35.381Z
8602924 8602924 20251125053250_zal5U UK003D 2025-11-26T14:26:28.097Z 2025-12-02T15:09:33.536Z
8602904 8602904 20251125053240_L0EN3 UK003D 2025-11-26T14:26:26.736Z 2025-12-02T15:09:33.434Z
8602401 8602401 20251125045440_F5Vbe UK003D 2025-11-26T14:25:37.169Z 2025-12-02T15:09:30.791Z
8602297 8602297 20251125044633_UwbpX UK003D 2025-11-26T14:25:30.703Z 2025-12-02T15:09:30.329Z
8601707 8601707 20251125041011_G8D80 UK003D 2025-11-26T14:24:37.305Z 2025-12-02T15:09:21.217Z
8601670 8601670 20251125040735_7TIKU UK003D 2025-11-26T14:24:35.073Z 2025-12-02T15:09:18.171Z
8600133 8600133 20251125024512_egB0r UK003D 2025-11-26T14:22:03.941Z 2025-12-02T15:08:34.766Z
8600067 8600067 20251125024003_zKEmm UK003D 2025-11-26T14:22:01.045Z 2025-12-02T15:08:34.473Z
8599994 8599994 20251125023538_s8eNP UK003D 2025-11-26T14:21:55.701Z 2025-12-02T15:08:33.339Z
8599535 8599535 20251125021006_3Uh0s UK003D 2025-11-26T14:21:14.644Z 2025-12-02T15:08:29.150Z
8599419 8599419 20251125020441_JuovZ UK003D 2025-11-26T14:20:54.129Z 2025-12-02T15:08:23.850Z
8599321 8599321 20251125015831_g1y7H UK003D 2025-11-26T14:20:47.112Z 2025-12-02T15:08:22.288Z
8599131 8599131 20251125014831_ikIrV UK003D 2025-11-26T14:20:33.915Z 2025-12-02T15:08:20.204Z
8599035 8599035 20251125014136_paE39 UK003D 2025-11-26T14:20:14.196Z 2025-12-02T15:08:17.140Z
8598625 8598625 20251125011033_GbOCR UK003D 2025-11-26T14:19:21.123Z 2025-12-02T15:08:01.411Z
8597514 8597514 20251124233955_CGIPI UK003D 2025-11-26T14:16:54.530Z 2025-12-02T15:07:36.878Z
8596998 8596998 20251124224335_2Q9cd UK003D 2025-11-26T14:15:52.875Z 2025-12-02T15:07:22.323Z
8596670 8596670 20251124215051_STbuf UK003D 2025-11-26T14:15:04.959Z 2025-12-02T15:07:04.545Z
8596413 8596413 20251124210316_wFoOC UK003D 2025-11-26T14:14:31.332Z 2025-12-02T15:06:54.728Z
8596400 8596400 20251124210300_3HsET UK003D 2025-11-26T14:14:30.073Z 2025-12-02T15:06:54.637Z
8596099 8596099 20251124195411_Cemtz UK003D 2025-11-26T14:13:33.719Z 2025-12-02T15:06:39.570Z
8591182 8591182 20251124035236_nMoHh UK003D 2025-11-25T14:23:43.659Z 2025-12-02T15:12:57.340Z
8591157 8591157 20251124035058_JRoAr UK003D 2025-11-25T14:23:42.169Z 2025-12-02T15:12:57.268Z
8590551 8590551 20251124025240_MyvFw UK003D 2025-11-25T14:22:12.823Z 2025-12-02T15:12:50.042Z
8590443 8590443 20251124024213_eIotF UK003D 2025-11-25T14:22:03.949Z 2025-12-02T15:12:47.707Z
8590361 8590361 20251124023835_rzs2z UK003D 2025-11-25T14:21:45.311Z 2025-12-02T15:12:47.200Z
8590349 8590349 20251124023629_F4UlR UK003D 2025-11-25T14:21:44.717Z 2025-12-02T15:12:47.135Z
8590336 8590336 20251124023538_m7avU UK003D 2025-11-25T14:21:44.203Z 2025-12-02T15:12:46.931Z
8589495 8589495 20251124013716_zlpAP UK003D 2025-11-25T14:20:08.077Z 2025-12-02T15:12:31.353Z
8589024 8589024 20251124005410_PsKDF UK003D 2025-11-25T14:18:53.631Z 2025-12-02T15:12:03.717Z
8588843 8588843 20251124003641_i0IbW UK003D 2025-11-25T14:18:25.253Z 2025-12-02T15:11:56.769Z
8588550 8588550 20251124000725_sJFpI UK003D 2025-11-25T14:17:45.189Z 2025-12-02T15:11:49.234Z
8588418 8588418 20251123235540_QjAAc UK003D 2025-11-25T14:17:32.456Z 2025-12-02T15:11:41.722Z
8588260 8588260 20251123233629_Q3qoh UK003D 2025-11-25T14:17:10.309Z 2025-12-02T15:11:38.851Z
8588232 8588232 20251123233434_VkExE UK003D 2025-11-25T14:17:06.935Z 2025-12-02T15:11:38.486Z
8588060 8588060 20251123231748_dts0w UK003D 2025-11-25T14:16:50.241Z 2025-12-02T15:11:25.064Z
8587549 8587549 20251123221545_FBYi3 UK003D 2025-11-25T14:15:30.901Z 2025-12-02T15:11:17.191Z
8586365 8586365 20251123193229_tWUC5 UK003D 2025-11-25T14:12:43.833Z 2025-12-02T15:10:46.603Z
8586213 8586213 20251123185928_vpJc2 UK003D 2025-11-25T14:12:18.035Z 2025-12-02T15:10:45.014Z
8586196 8586196 20251123185837_5owwh UK003D 2025-11-25T14:12:17.446Z 2025-12-02T15:10:44.905Z

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