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,979 rows where station_code = "UK00B2" 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
9273275 9273275 20260128052118_LZOzb UK00B2 2026-01-29T14:29:15.189Z 2026-01-29T14:30:25.780Z
9273267 9273267 20260128052041_P63t9 UK00B2 2026-01-29T14:29:14.716Z 2026-01-29T14:30:25.779Z
9273225 9273225 20260128051033_lXpw9 UK00B2 2026-01-29T14:29:02.431Z 2026-01-29T14:30:25.771Z
9272896 9272896 20260128035839_Ntba5 UK00B2 2026-01-29T14:28:12.984Z 2026-01-29T14:30:25.704Z
9272705 9272705 20260128030822_ixwzV UK00B2 2026-01-29T14:27:35.131Z 2026-01-29T14:30:25.440Z
9272606 9272606 20260128024815_s7qkO UK00B2 2026-01-29T14:27:13.641Z 2026-01-29T14:30:25.382Z
9272030 9272030 20260127230631_UaNKb UK00B2 2026-01-29T14:25:20.734Z 2026-01-29T14:30:25.267Z
9271949 9271949 20260127221520_IKNGN UK00B2 2026-01-29T14:25:01.595Z 2026-01-29T14:30:25.234Z
9271910 9271910 20260127214508_15UQ2 UK00B2 2026-01-29T14:24:54.316Z 2026-01-29T14:30:25.228Z
9271903 9271903 20260127214256_dZAVh UK00B2 2026-01-29T14:24:53.451Z 2026-01-29T14:30:25.227Z
9243152 9243152 20260121034916_zHbsp UK00B2 2026-01-22T14:20:47.644Z 2026-01-29T15:04:48.499Z
9236036 9236036 20260120022939_lGgtW UK00B2 2026-01-21T14:21:17.964Z 2026-01-28T14:59:41.973Z
9204546 9204546 20260114065952_PqwYh UK00B2 2026-01-15T14:27:33.447Z 2026-01-22T15:10:36.739Z
9204454 9204454 20260114064408_fLKCd UK00B2 2026-01-15T14:27:24.144Z 2026-01-22T15:10:28.522Z
9204184 9204184 20260114061351_E85dN UK00B2 2026-01-15T14:26:37.254Z 2026-01-22T15:10:21.894Z
9203944 9203944 20260114055832_N0VaQ UK00B2 2026-01-15T14:25:55.393Z 2026-01-22T15:10:15.990Z
9203774 9203774 20260114053712_6W7mW UK00B2 2026-01-15T14:25:22.939Z 2026-01-22T15:10:13.339Z
9203750 9203750 20260114053438_NIm3n UK00B2 2026-01-15T14:25:21.064Z 2026-01-22T15:10:13.083Z
9203507 9203507 20260114051354_P1d8V UK00B2 2026-01-15T14:24:37.053Z 2026-01-22T15:10:09.024Z
9203477 9203477 20260114050007_H2Cwq UK00B2 2026-01-15T14:24:30.673Z 2026-01-22T15:10:08.430Z
9203164 9203164 20260114043823_ROxDw UK00B2 2026-01-15T14:23:27.890Z 2026-01-22T15:10:02.866Z
9203046 9203046 20260114043023_V1nJT UK00B2 2026-01-15T14:23:13.574Z 2026-01-22T15:10:01.093Z
9202688 9202688 20260114040259_2kSzM UK00B2 2026-01-15T14:22:08.902Z 2026-01-22T15:09:26.977Z
9202170 9202170 20260114032201_3oRHQ UK00B2 2026-01-15T14:20:38.070Z 2026-01-22T15:09:14.407Z
9202113 9202113 20260114031742_13ncE UK00B2 2026-01-15T14:20:33.474Z 2026-01-22T15:09:13.789Z
9201994 9201994 20260114030932_9LW35 UK00B2 2026-01-15T14:20:13.560Z 2026-01-22T15:09:11.989Z
9201894 9201894 20260114030441_gLeWu UK00B2 2026-01-15T14:20:05.084Z 2026-01-22T15:09:11.079Z
9201593 9201593 20260114023422_cP9Yb UK00B2 2026-01-15T14:19:09.058Z 2026-01-22T15:09:06.485Z
9201301 9201301 20260114020630_ryPkP UK00B2 2026-01-15T14:18:12.140Z 2026-01-22T15:09:01.343Z
9200789 9200789 20260114010250_VKO2C UK00B2 2026-01-15T14:16:23.946Z 2026-01-22T15:08:25.547Z
9200371 9200371 20260113235347_FHAUQ UK00B2 2026-01-15T14:14:52.388Z 2026-01-22T15:08:14.768Z
9200271 9200271 20260113233129_il1Zf UK00B2 2026-01-15T14:14:27.958Z 2026-01-22T15:08:12.792Z
9200100 9200100 20260113225110_vvXgm UK00B2 2026-01-15T14:13:45.979Z 2026-01-22T15:08:09.554Z
9200045 9200045 20260113223902_R56Le UK00B2 2026-01-15T14:13:38.374Z 2026-01-22T15:08:08.610Z
9200019 9200019 20260113222539_6Ie22 UK00B2 2026-01-15T14:13:33.191Z 2026-01-22T15:08:07.811Z
9195620 9195620 20260113020453_x4tN9 UK00B2 2026-01-14T14:14:09.854Z 2026-01-21T15:04:43.073Z
9195587 9195587 20260113015707_mCpCa UK00B2 2026-01-14T14:13:56.914Z 2026-01-21T15:04:42.699Z
9195504 9195504 20260113013711_jJKaz UK00B2 2026-01-14T14:13:37.234Z 2026-01-21T15:04:41.475Z
9195477 9195477 20260113013409_gGmb1 UK00B2 2026-01-14T14:13:28.200Z 2026-01-21T15:04:41.116Z
9195458 9195458 20260113012924_RF5FB UK00B2 2026-01-14T14:13:23.613Z 2026-01-21T15:04:40.804Z
9195290 9195290 20260113005413_e5dmP UK00B2 2026-01-14T14:12:44.655Z 2026-01-21T15:04:38.545Z
9195204 9195204 20260113003545_pmaQT UK00B2 2026-01-14T14:12:22.679Z 2026-01-21T15:04:37.489Z
9195125 9195125 20260113002417_ih23J UK00B2 2026-01-14T14:12:06.266Z 2026-01-21T15:04:36.649Z
9194992 9194992 20260112235527_eKdty UK00B2 2026-01-14T14:11:37.132Z 2026-01-21T15:04:34.794Z
9194939 9194939 20260112233534_xCVVf UK00B2 2026-01-14T14:11:22.240Z 2026-01-21T15:04:34.162Z
9194599 9194599 20260112213215_b3ze0 UK00B2 2026-01-14T14:09:58.285Z 2026-01-21T15:04:19.168Z
9194451 9194451 20260112205211_JzhPD UK00B2 2026-01-14T14:09:16.523Z 2026-01-21T15:04:11.023Z
9194146 9194146 20260112182135_Qv2GW UK00B2 2026-01-14T14:07:35.849Z 2026-01-21T15:03:34.937Z
9180137 9180137 20260110191914_MBlTU UK00B2 2026-01-12T14:05:56.109Z 2026-01-19T15:15:48.067Z
9176896 9176896 20260110063720_UVIL8 UK00B2 2026-01-11T14:10:17.223Z 2026-01-18T15:09:06.507Z
9176757 9176757 20260110061901_KwR25 UK00B2 2026-01-11T14:09:52.961Z 2026-01-18T15:08:53.025Z
9176217 9176217 20260110050238_JL8SD UK00B2 2026-01-11T14:08:27.901Z 2026-01-18T15:08:24.082Z
9176201 9176201 20260110050107_M0Mo7 UK00B2 2026-01-11T14:08:26.815Z 2026-01-18T15:08:23.765Z
9175999 9175999 20260110043421_eBfwl UK00B2 2026-01-11T14:07:59.458Z 2026-01-18T15:08:16.180Z
9175900 9175900 20260110041220_K7afN UK00B2 2026-01-11T14:07:42.477Z 2026-01-18T15:08:12.612Z
9175295 9175295 20260110015845_I5Edp UK00B2 2026-01-11T14:05:59.307Z 2026-01-18T15:07:39.992Z
9175246 9175246 20260110014655_zFoT2 UK00B2 2026-01-11T14:05:48.550Z 2026-01-18T15:07:38.322Z
9175068 9175068 20260110005608_Sl7Zw UK00B2 2026-01-11T14:05:18.821Z 2026-01-18T15:07:24.857Z
9160343 9160343 20260106053401_3i6HM UK00B2 2026-01-07T14:12:18.881Z 2026-01-13T15:09:20.891Z
9160309 9160309 20260106052550_iR2gx UK00B2 2026-01-07T14:12:09.990Z 2026-01-13T15:09:19.136Z
9160011 9160011 20260106042946_En9fJ UK00B2 2026-01-07T14:11:04.728Z 2026-01-13T15:08:56.326Z
9159997 9159997 20260106042648_zhCoB UK00B2 2026-01-07T14:11:02.155Z 2026-01-13T15:08:55.726Z
9159794 9159794 20260106034740_nedP6 UK00B2 2026-01-07T14:10:24.728Z 2026-01-13T15:08:47.068Z
9159764 9159764 20260106034040_YgoX5 UK00B2 2026-01-07T14:10:20.151Z 2026-01-13T15:08:39.892Z
9158892 9158892 20260106004534_J3l9o UK00B2 2026-01-07T14:07:34.424Z 2026-01-13T15:07:49.856Z
9158833 9158833 20260106003648_vXD5b UK00B2 2026-01-07T14:07:23.658Z 2026-01-13T15:07:47.742Z
9158461 9158461 20260105223305_9tlGw UK00B2 2026-01-07T14:06:09.780Z 2026-01-13T15:07:23.273Z
9158402 9158402 20260105221443_Xbl6N UK00B2 2026-01-07T14:05:55.677Z 2026-01-13T15:07:20.345Z
9158149 9158149 20260105202552_GMw5k UK00B2 2026-01-07T14:05:02.186Z 2026-01-13T15:06:58.060Z
9158119 9158119 20260105200843_a1CpA UK00B2 2026-01-07T14:04:55.590Z 2026-01-13T15:06:56.288Z
9158105 9158105 20260105200555_lTdOY UK00B2 2026-01-07T14:04:51.949Z 2026-01-13T15:06:55.323Z
9158017 9158017 20260105193756_cpXyX UK00B2 2026-01-07T14:04:27.218Z 2026-01-13T15:06:49.215Z
9157551 9157551 20260105175253_rtepb UK00B2 2026-01-07T14:02:37.561Z 2026-01-13T15:06:17.397Z
9156108 9156108 20260104064658_ISdox UK00B2 2026-01-06T14:38:34.619Z 2026-01-12T15:11:38.317Z
9156083 9156083 20260104064342_JeqfE UK00B2 2026-01-06T14:38:31.485Z 2026-01-12T15:11:37.247Z
9155979 9155979 20260104063402_4KVTj UK00B2 2026-01-06T14:38:23.617Z 2026-01-12T15:11:33.782Z
9155737 9155737 20260104061827_B43Zf UK00B2 2026-01-06T14:37:57.922Z 2026-01-12T15:11:25.767Z
9155589 9155589 20260104060659_xHPV0 UK00B2 2026-01-06T14:37:43.335Z 2026-01-12T15:11:20.579Z
9155471 9155471 20260104055703_JxDy2 UK00B2 2026-01-06T14:37:24.720Z 2026-01-12T15:11:03.660Z
9155268 9155268 20260104054825_ncDaS UK00B2 2026-01-06T14:37:11.152Z 2026-01-12T15:10:55.402Z
9155199 9155199 20260104054246_zxzse UK00B2 2026-01-06T14:36:57.638Z 2026-01-12T15:10:53.410Z
9155169 9155169 20260104054023_obmsj UK00B2 2026-01-06T14:36:54.144Z 2026-01-12T15:10:51.741Z
9155035 9155035 20260104053145_lm8CR UK00B2 2026-01-06T14:36:41.665Z 2026-01-12T15:10:46.530Z
9154998 9154998 20260104052839_zhemS UK00B2 2026-01-06T14:36:28.903Z 2026-01-12T15:10:29.556Z
9154804 9154804 20260104051519_lfNLY UK00B2 2026-01-06T14:36:12.665Z 2026-01-12T15:10:20.273Z
9154735 9154735 20260104051135_ljwlc UK00B2 2026-01-06T14:36:07.201Z 2026-01-12T15:10:18.121Z
9154683 9154683 20260104050859_ykCjl UK00B2 2026-01-06T14:35:52.754Z 2026-01-12T15:10:15.463Z
9154627 9154627 20260104050431_QbHm5 UK00B2 2026-01-06T14:35:46.366Z 2026-01-12T15:10:12.471Z
9154546 9154546 20260104050153_3lCZh UK00B2 2026-01-06T14:35:42.016Z 2026-01-12T15:10:09.630Z
9154536 9154536 20260104050048_5fjXR UK00B2 2026-01-06T14:35:40.267Z 2026-01-12T15:10:08.968Z
9154507 9154507 20260104045940_wCi34 UK00B2 2026-01-06T14:35:38.474Z 2026-01-12T15:10:08.134Z
9154473 9154473 20260104045912_evmhq UK00B2 2026-01-06T14:35:36.275Z 2026-01-12T15:10:02.863Z
9154366 9154366 20260104045356_8i3Uo UK00B2 2026-01-06T14:35:22.175Z 2026-01-12T15:09:48.520Z
9154361 9154361 20260104045341_16rih UK00B2 2026-01-06T14:35:21.883Z 2026-01-12T15:09:48.311Z
9154287 9154287 20260104045112_2EEeM UK00B2 2026-01-06T14:35:16.798Z 2026-01-12T15:09:44.413Z
9154260 9154260 20260104044951_wBN6H UK00B2 2026-01-06T14:35:13.608Z 2026-01-12T15:09:43.266Z
9154049 9154049 20260104043207_0TKEB UK00B2 2026-01-06T14:34:41.850Z 2026-01-12T15:09:33.743Z
9154032 9154032 20260104043130_q2Hf2 UK00B2 2026-01-06T14:34:40.528Z 2026-01-12T15:09:32.903Z
9153967 9153967 20260104042652_cKGrW UK00B2 2026-01-06T14:34:26.494Z 2026-01-12T15:09:29.585Z
9153898 9153898 20260104042117_O9yGL UK00B2 2026-01-06T14:34:19.262Z 2026-01-12T15:09:12.263Z

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