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

2,917 rows where station_code = "UK00CH" 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
8683274 8683274 20251203064853_1u66r UK00CH 2025-12-04T14:19:02.917Z 2025-12-05T14:23:13.776Z
8683263 8683263 20251203064710_kTU05 UK00CH 2025-12-04T14:19:01.122Z 2025-12-05T14:23:13.200Z
8683165 8683165 20251203063341_RLR8q UK00CH 2025-12-04T14:18:39.723Z 2025-12-05T14:23:09.475Z
8683121 8683121 20251203062811_Si9IK UK00CH 2025-12-04T14:18:35.205Z 2025-12-05T14:23:08.023Z
8683106 8683106 20251203062758_uq4if UK00CH 2025-12-04T14:18:34.878Z 2025-12-05T14:23:07.879Z
8683095 8683095 20251203062616_3I3KG UK00CH 2025-12-04T14:18:34.318Z 2025-12-05T14:23:07.685Z
8682908 8682908 20251203061549_HKz8r UK00CH 2025-12-04T14:18:19.780Z 2025-12-05T14:22:56.242Z
8682896 8682896 20251203061533_woNmB UK00CH 2025-12-04T14:18:13.555Z 2025-12-05T14:22:55.973Z
8682850 8682850 20251203061003_nfMe2 UK00CH 2025-12-04T14:18:08.034Z 2025-12-05T14:22:54.179Z
8682842 8682842 20251203060931_2KzRb UK00CH 2025-12-04T14:18:05.593Z 2025-12-05T14:22:53.913Z
8682838 8682838 20251203060911_WIlz3 UK00CH 2025-12-04T14:18:05.114Z 2025-12-05T14:22:53.742Z
8682807 8682807 20251203060645_BV89K UK00CH 2025-12-04T14:18:03.028Z 2025-12-05T14:22:52.918Z
8682679 8682679 20251203055818_xlyvB UK00CH 2025-12-04T14:17:53.757Z 2025-12-05T14:22:47.393Z
8682654 8682654 20251203055550_1qL7M UK00CH 2025-12-04T14:17:51.847Z 2025-12-05T14:22:46.589Z
8682579 8682579 20251203054630_dtMS3 UK00CH 2025-12-04T14:17:28.500Z 2025-12-05T14:22:43.139Z
8682295 8682295 20251203051106_jTB1a UK00CH 2025-12-04T14:16:44.614Z 2025-12-05T14:22:23.258Z
8682152 8682152 20251203045505_Zd6Qx UK00CH 2025-12-04T14:16:30.913Z 2025-12-05T14:22:16.038Z
8676966 8676966 20251202063529_Xfr8P UK00CH 2025-12-03T14:25:58.213Z 2025-12-05T14:29:16.885Z
8676683 8676683 20251202061146_hjmEM UK00CH 2025-12-03T14:25:25.849Z 2025-12-05T14:29:10.563Z
8675857 8675857 20251202051854_2wpXN UK00CH 2025-12-03T14:24:26.186Z 2025-12-05T14:28:42.448Z
8675787 8675787 20251202051412_dSr97 UK00CH 2025-12-03T14:24:15.116Z 2025-12-05T14:28:40.599Z
8675711 8675711 20251202051034_RQ5uj UK00CH 2025-12-03T14:24:11.856Z 2025-12-05T14:28:39.223Z
8675621 8675621 20251202050215_fgICz UK00CH 2025-12-03T14:23:56.044Z 2025-12-05T14:28:36.885Z
8675599 8675599 20251202050055_6Dvll UK00CH 2025-12-03T14:23:54.310Z 2025-12-05T14:28:36.678Z
8675552 8675552 20251202045610_OthRE UK00CH 2025-12-03T14:23:51.195Z 2025-12-05T14:28:35.326Z
8675527 8675527 20251202045502_Hhe5v UK00CH 2025-12-03T14:23:50.038Z 2025-12-05T14:28:34.794Z
8675034 8675034 20251202035409_3obmf UK00CH 2025-12-03T14:22:51.882Z 2025-12-05T14:28:09.706Z
8674947 8674947 20251202034221_W5IpE UK00CH 2025-12-03T14:22:44.936Z 2025-12-05T14:28:07.284Z
8674656 8674656 20251202030352_gWsbT UK00CH 2025-12-03T14:22:10.972Z 2025-12-05T14:27:58.995Z
8658119 8658119 20251130064213_NU3HU UK00CH 2025-12-01T14:34:55.479Z 2025-12-05T14:46:02.864Z
8657580 8657580 20251130055308_K8OsG UK00CH 2025-12-01T14:34:33.566Z 2025-12-05T14:45:33.544Z
8657261 8657261 20251130053736_ulgN7 UK00CH 2025-12-01T14:34:02.683Z 2025-12-05T14:45:27.652Z
8657128 8657128 20251130053140_CdYG0 UK00CH 2025-12-01T14:33:55.687Z 2025-12-05T14:45:25.857Z
8656300 8656300 20251130044853_7hH8l UK00CH 2025-12-01T14:28:19.358Z 2025-12-05T14:45:03.469Z
8656226 8656226 20251130044422_2WNQF UK00CH 2025-12-01T14:28:11.879Z 2025-12-05T14:44:48.212Z
8656046 8656046 20251130043208_eW9Zk UK00CH 2025-12-01T14:27:58.671Z 2025-12-05T14:44:44.776Z
8655875 8655875 20251130042123_4JR5F UK00CH 2025-12-01T14:27:34.022Z 2025-12-05T14:44:40.289Z
8655242 8655242 20251130035002_brxYT UK00CH 2025-12-01T14:26:41.013Z 2025-12-05T14:44:30.222Z
8654669 8654669 20251130032455_hrwcX UK00CH 2025-12-01T14:25:42.517Z 2025-12-05T14:44:19.991Z
8654453 8654453 20251130031725_N2xbm UK00CH 2025-12-01T14:25:26.679Z 2025-12-05T14:43:59.529Z
8653653 8653653 20251130023317_5nbeo UK00CH 2025-12-01T14:23:54.015Z 2025-12-05T14:43:37.108Z
8653537 8653537 20251130022407_WGzYC UK00CH 2025-12-01T14:23:40.034Z 2025-12-05T14:43:34.390Z
8652832 8652832 20251130013652_eJE9k UK00CH 2025-12-01T14:22:12.385Z 2025-12-05T14:42:53.972Z
8652768 8652768 20251130013220_0Jyfw UK00CH 2025-12-01T14:22:06.351Z 2025-12-05T14:42:52.007Z
8652581 8652581 20251130012218_zuePk UK00CH 2025-12-01T14:21:43.912Z 2025-12-05T14:42:48.108Z
8652440 8652440 20251130010923_CsMTu UK00CH 2025-12-01T14:21:23.718Z 2025-12-05T14:42:44.518Z
8652351 8652351 20251130010357_z43NI UK00CH 2025-12-01T14:21:17.257Z 2025-12-05T14:42:43.019Z
8651826 8651826 20251130002431_NGX61 UK00CH 2025-12-01T14:20:05.649Z 2025-12-05T14:42:07.429Z
8644835 8644835 20251128200248_Zmcc2 UK00CH 2025-11-30T14:22:46.162Z 2025-12-05T14:50:27.775Z
8643588 8643588 20251128180802_8crWN UK00CH 2025-11-30T14:20:14.849Z 2025-12-05T14:49:28.234Z
8637661 8637661 20251128060709_7sCtt UK00CH 2025-11-29T14:27:40.708Z 2025-12-05T15:00:12.288Z
8637626 8637626 20251128060018_Doxzy UK00CH 2025-11-29T14:27:37.827Z 2025-12-05T15:00:10.954Z
8637556 8637556 20251128055224_4YEY0 UK00CH 2025-11-29T14:27:33.859Z 2025-12-05T15:00:02.023Z
8637536 8637536 20251128054828_PkFrk UK00CH 2025-11-29T14:27:32.872Z 2025-12-05T14:59:58.605Z
8637463 8637463 20251128054134_Fr43Z UK00CH 2025-11-29T14:27:25.258Z 2025-12-05T14:59:53.815Z
8637434 8637434 20251128054001_CUn6G UK00CH 2025-11-29T14:27:14.680Z 2025-12-05T14:59:52.248Z
8637225 8637225 20251128051634_2GqEc UK00CH 2025-11-29T14:26:58.600Z 2025-12-05T14:59:38.912Z
8637055 8637055 20251128045551_3fJSk UK00CH 2025-11-29T14:26:48.083Z 2025-12-05T14:59:36.585Z
8636520 8636520 20251128035515_39ifw UK00CH 2025-11-29T14:25:36.714Z 2025-12-05T14:59:25.434Z
8636481 8636481 20251128035008_I8Zkr UK00CH 2025-11-29T14:25:33.257Z 2025-12-05T14:59:24.579Z
8636254 8636254 20251128032951_mmBG3 UK00CH 2025-11-29T14:25:14.735Z 2025-12-05T14:59:21.918Z
8636247 8636247 20251128032951_1ZC2V UK00CH 2025-11-29T14:25:11.547Z 2025-12-05T14:59:21.788Z
8636231 8636231 20251128032849_Ion2T UK00CH 2025-11-29T14:25:06.265Z 2025-12-05T14:59:21.554Z
8636206 8636206 20251128032753_X1jun UK00CH 2025-11-29T14:25:04.593Z 2025-12-05T14:59:21.253Z
8635982 8635982 20251128030353_wZsdA UK00CH 2025-11-29T14:24:43.218Z 2025-12-05T14:59:17.506Z
8635815 8635815 20251128025019_jb3kL UK00CH 2025-11-29T14:24:11.674Z 2025-12-05T14:59:14.922Z
8635596 8635596 20251128022856_Y33Yx UK00CH 2025-11-29T14:23:53.619Z 2025-12-05T14:59:08.403Z
8635419 8635419 20251128021107_fqdHM UK00CH 2025-11-29T14:23:22.603Z 2025-12-05T14:58:35.152Z
8635322 8635322 20251128020327_2w7Wq UK00CH 2025-11-29T14:23:03.233Z 2025-12-05T14:58:34.056Z
8635236 8635236 20251128015601_ZZJup UK00CH 2025-11-29T14:22:52.731Z 2025-12-05T14:58:32.718Z
8634777 8634777 20251128011721_SzBLL UK00CH 2025-11-29T14:22:02.732Z 2025-12-05T14:58:24.738Z
8634276 8634276 20251128003348_nihnO UK00CH 2025-11-29T14:21:09.231Z 2025-12-05T14:58:18.539Z
8634248 8634248 20251128003132_Kc7VB UK00CH 2025-11-29T14:21:07.135Z 2025-12-05T14:58:18.121Z
8634201 8634201 20251128003023_HX8Ht UK00CH 2025-11-29T14:20:54.590Z 2025-12-05T14:58:17.269Z
8634037 8634037 20251128001633_4nqEV UK00CH 2025-11-29T14:20:38.785Z 2025-12-05T14:58:15.624Z
8633954 8633954 20251128000814_VnwV8 UK00CH 2025-11-29T14:20:32.691Z 2025-12-05T14:58:14.520Z
8633887 8633887 20251128000109_Pciak UK00CH 2025-11-29T14:20:28.682Z 2025-12-05T14:58:13.681Z
8633618 8633618 20251127233952_PwfEQ UK00CH 2025-11-29T14:19:58.780Z 2025-12-05T14:57:50.188Z
8633599 8633599 20251127233659_HbSNR UK00CH 2025-11-29T14:19:57.428Z 2025-12-05T14:57:48.880Z
8633452 8633452 20251127231833_lM7A0 UK00CH 2025-11-29T14:19:43.766Z 2025-12-05T14:57:40.096Z
8632761 8632761 20251127215037_Kt0TE UK00CH 2025-11-29T14:18:19.355Z 2025-12-05T14:56:36.072Z
8632735 8632735 20251127214527_xLkUq UK00CH 2025-11-29T14:18:08.941Z 2025-12-05T14:56:34.790Z
8632316 8632316 20251127205021_tcAQe UK00CH 2025-11-29T14:17:15.573Z 2025-12-05T14:56:19.635Z
8631932 8631932 20251127201530_7cXFk UK00CH 2025-11-29T14:16:35.027Z 2025-12-05T14:56:13.562Z
8617178 8617178 20251125023326_nje28 UK00CH 2025-11-27T14:39:50.803Z 2025-12-02T15:08:33.041Z
8616425 8616425 20251126055824_IIvOc UK00CH 2025-11-27T14:31:10.879Z 2025-12-04T15:11:39.352Z
8616287 8616287 20251126054902_lC72I UK00CH 2025-11-27T14:31:01.082Z 2025-12-04T15:11:37.431Z
8615955 8615955 20251126053018_zykEu UK00CH 2025-11-27T14:30:18.585Z 2025-12-04T15:11:34.031Z
8615911 8615911 20251126052734_RRBDH UK00CH 2025-11-27T14:30:16.709Z 2025-12-04T15:11:33.701Z
8615879 8615879 20251126052541_p5P4M UK00CH 2025-11-27T14:30:14.795Z 2025-12-04T15:11:33.282Z
8615450 8615450 20251126050325_tCTYl UK00CH 2025-11-27T14:29:32.645Z 2025-12-04T15:11:28.980Z
8614346 8614346 20251126040646_jm0pM UK00CH 2025-11-27T14:27:48.440Z 2025-12-04T15:10:38.102Z
8614293 8614293 20251126040231_z72X1 UK00CH 2025-11-27T14:27:44.083Z 2025-12-04T15:10:34.204Z
8613285 8613285 20251126031303_KWTui UK00CH 2025-11-27T14:25:36.336Z 2025-12-04T15:09:39.521Z
8613192 8613192 20251126030901_ZFFJR UK00CH 2025-11-27T14:25:29.674Z 2025-12-04T15:09:38.371Z
8613067 8613067 20251126030042_FHUw1 UK00CH 2025-11-27T14:25:21.699Z 2025-12-04T15:09:36.902Z
8612494 8612494 20251126023334_bFUUj UK00CH 2025-11-27T14:24:16.049Z 2025-12-04T15:09:31.172Z
8612294 8612294 20251126022443_ZbvRw UK00CH 2025-11-27T14:23:44.050Z 2025-12-04T15:09:29.201Z
8611432 8611432 20251126014229_M167G UK00CH 2025-11-27T14:22:07.941Z 2025-12-04T15:09:15.124Z
8611331 8611331 20251126013737_gjpzr UK00CH 2025-11-27T14:21:52.264Z 2025-12-04T15:09:10.142Z

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