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

3,047 rows where station_code = "UK001M" 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
8066930 8066930 20251005041907_efiE8 UK001M 2025-10-07T12:33:28.074Z 2025-10-13T12:34:03.814Z
8019910 8019910 20250930025322_eoKai UK001M 2025-10-01T12:46:22.838Z 2025-10-08T12:43:36.965Z
8016953 8016953 20250929225504_JRsdr UK001M 2025-10-01T12:24:57.155Z 2025-10-08T12:42:40.056Z
8011488 8011488 20250929045858_PbZHq UK001M 2025-09-30T12:33:47.320Z 2025-10-07T13:01:30.036Z
8008722 8008722 20250929025155_cIeI4 UK001M 2025-09-30T12:30:26.139Z 2025-10-07T13:01:15.012Z
8007961 8007961 20250929022311_kXX3P UK001M 2025-09-30T12:29:26.871Z 2025-10-07T13:01:09.315Z
8007831 8007831 20250929021801_532XW UK001M 2025-09-30T12:29:03.743Z 2025-10-07T13:01:08.898Z
8007827 8007827 20250929021800_Wdjmc UK001M 2025-09-30T12:29:03.477Z 2025-10-07T13:01:08.882Z
8007301 8007301 20250929015655_AjA3I UK001M 2025-09-30T12:28:06.123Z 2025-10-07T13:01:03.409Z
8007069 8007069 20250929014946_1jJkR UK001M 2025-09-30T12:27:52.382Z 2025-10-07T13:01:01.967Z
8006819 8006819 20250929014051_Isr57 UK001M 2025-09-30T12:27:26.407Z 2025-10-07T13:01:01.276Z
8006802 8006802 20250929014022_LcXlR UK001M 2025-09-30T12:27:23.250Z 2025-10-07T13:01:01.245Z
8006449 8006449 20250929012723_emFIv UK001M 2025-09-30T12:26:54.666Z 2025-10-07T13:00:59.411Z
8005842 8005842 20250929005736_PXuXW UK001M 2025-09-30T12:25:38.614Z 2025-10-07T13:00:56.934Z
8005110 8005110 20250929002226_kfKu4 UK001M 2025-09-30T12:24:05.898Z 2025-10-07T13:00:51.810Z
8005082 8005082 20250929002151_n8ezn UK001M 2025-09-30T12:24:04.198Z 2025-10-07T13:00:51.782Z
8004768 8004768 20250929000652_ATFLf UK001M 2025-09-30T12:23:21.911Z 2025-10-07T13:00:49.210Z
8004595 8004595 20250928235758_Nd7YM UK001M 2025-09-30T12:23:06.251Z 2025-10-07T13:00:47.964Z
8004471 8004471 20250928235357_h8FFb UK001M 2025-09-30T12:22:45.239Z 2025-10-07T13:00:47.265Z
8003442 8003442 20250928225144_HrCj9 UK001M 2025-09-30T12:20:27.428Z 2025-10-07T13:00:40.157Z
8003428 8003428 20250928225144_3EMwU UK001M 2025-09-30T12:20:27.236Z 2025-10-07T13:00:40.154Z
8002712 8002712 20250928220711_n3v3V UK001M 2025-09-30T12:18:36.422Z 2025-10-07T13:00:35.269Z
7997711 7997711 20250924193709_Gpe6T UK001M 2025-09-29T12:46:23.053Z 2025-10-03T13:03:55.497Z
7996643 7996643 20250928024539_HJHjD UK001M 2025-09-29T12:26:37.191Z 2025-10-05T13:07:39.779Z
7996560 7996560 20250928023948_OESci UK001M 2025-09-29T12:26:28.817Z 2025-10-05T13:07:39.078Z
7996097 7996097 20250928015710_MqOqM UK001M 2025-09-29T12:25:30.478Z 2025-10-05T13:07:27.608Z
7995435 7995435 20250928005513_uzfMD UK001M 2025-09-29T12:23:48.825Z 2025-10-05T13:07:15.457Z
7995081 7995081 20250928001822_ecCXq UK001M 2025-09-29T12:22:58.351Z 2025-10-05T13:07:07.708Z
7994724 7994724 20250927233152_lDQNu UK001M 2025-09-29T12:21:56.183Z 2025-10-05T13:07:01.890Z
7994644 7994644 20250927232103_Ak5E2 UK001M 2025-09-29T12:21:46.904Z 2025-10-05T13:06:58.379Z
7994113 7994113 20250927221206_HRWqR UK001M 2025-09-29T12:20:26.429Z 2025-10-05T13:06:49.559Z
7993943 7993943 20250927213721_Rg5tR UK001M 2025-09-29T12:19:52.359Z 2025-10-05T13:06:46.345Z
7993936 7993936 20250927213630_xIBuU UK001M 2025-09-29T12:19:51.477Z 2025-10-05T13:06:46.282Z
7990030 7990030 20250926042904_SjhYO UK001M 2025-09-28T12:36:57.340Z 2025-10-04T13:07:25.492Z
7989758 7989758 20250926041024_efmwZ UK001M 2025-09-28T12:36:51.347Z 2025-10-04T13:07:23.976Z
7989755 7989755 20250926040950_vCwLp UK001M 2025-09-28T12:36:51.294Z 2025-10-04T13:07:23.974Z
7989605 7989605 20250926040209_nOiDe UK001M 2025-09-28T12:36:49.564Z 2025-10-04T13:07:23.677Z
7989386 7989386 20250926034556_0UySM UK001M 2025-09-28T12:36:46.756Z 2025-10-04T13:07:22.764Z
7989297 7989297 20250926034149_gRF2b UK001M 2025-09-28T12:36:45.202Z 2025-10-04T13:07:22.074Z
7989267 7989267 20250926034031_h9zfg UK001M 2025-09-28T12:36:44.891Z 2025-10-04T13:07:22.022Z
7989234 7989234 20250926033948_aeksG UK001M 2025-09-28T12:36:44.627Z 2025-10-04T13:07:21.770Z
7989224 7989224 20250926033933_t7GTY UK001M 2025-09-28T12:36:44.379Z 2025-10-04T13:07:21.739Z
7989195 7989195 20250926033826_0kDfx UK001M 2025-09-28T12:36:44.094Z 2025-10-04T13:07:21.711Z
7988525 7988525 20250926030319_1AVD8 UK001M 2025-09-28T12:36:26.737Z 2025-10-04T13:07:18.793Z
7988431 7988431 20250926025628_0XCae UK001M 2025-09-28T12:36:22.061Z 2025-10-04T13:07:17.964Z
7987682 7987682 20250926021933_TzRdX UK001M 2025-09-28T12:35:35.909Z 2025-10-04T13:07:13.348Z
7987572 7987572 20250926021328_cj5Ir UK001M 2025-09-28T12:35:30.766Z 2025-10-04T13:07:13.075Z
7986996 7986996 20250926013736_Ywm1z UK001M 2025-09-28T12:35:03.561Z 2025-10-04T13:07:09.116Z
7986402 7986402 20250926005926_3jaXs UK001M 2025-09-28T12:34:50.816Z 2025-10-04T13:07:05.146Z
7983190 7983190 20250926210504_SyZAH UK001M 2025-09-28T12:21:25.007Z 2025-10-05T13:10:33.526Z
7982925 7982925 20250926201014_bJIHS UK001M 2025-09-28T12:20:43.409Z 2025-10-05T13:10:26.723Z
7982908 7982908 20250926200920_YsiO2 UK001M 2025-09-28T12:20:42.094Z 2025-10-05T13:10:26.687Z
7982803 7982803 20250926195608_5Fj4C UK001M 2025-09-28T12:20:33.162Z 2025-10-05T13:10:25.277Z
7976721 7976721 20250926043719_tG0r9 UK001M 2025-09-28T12:06:10.786Z 2025-10-05T13:08:07.367Z
7974473 7974473 20250926002248_J9L1k UK001M 2025-09-27T12:13:44.093Z 2025-10-04T13:07:03.077Z
7974380 7974380 20250926001820_B3zCf UK001M 2025-09-27T12:13:40.770Z 2025-10-04T13:07:02.525Z
7974331 7974331 20250926001417_19TzC UK001M 2025-09-27T12:13:38.990Z 2025-10-04T13:07:02.040Z
7974202 7974202 20250926000707_9Oak2 UK001M 2025-09-27T12:13:33.072Z 2025-10-04T13:07:00.938Z
7974189 7974189 20250926000526_2O4dc UK001M 2025-09-27T12:13:32.633Z 2025-10-04T13:07:00.912Z
7973942 7973942 20250925234804_AJgoE UK001M 2025-09-27T12:13:22.600Z 2025-10-04T13:06:59.571Z
7973377 7973377 20250925231316_b2Yhw UK001M 2025-09-27T12:12:49.088Z 2025-10-04T13:06:56.725Z
7972113 7972113 20250925213724_W3W3S UK001M 2025-09-27T12:11:26.059Z 2025-10-04T13:06:48.245Z
7971983 7971983 20250925212637_KMqa5 UK001M 2025-09-27T12:11:20.738Z 2025-10-04T13:06:47.600Z
7971975 7971975 20250925212623_7gAEx UK001M 2025-09-27T12:11:20.475Z 2025-10-04T13:06:47.566Z
7971738 7971738 20250925210700_ZQ5AS UK001M 2025-09-27T12:11:02.291Z 2025-10-04T13:06:46.466Z
7971261 7971261 20250925202213_DAzr2 UK001M 2025-09-27T12:10:29.632Z 2025-10-04T13:06:43.593Z
7971149 7971149 20250925201000_FhT9e UK001M 2025-09-27T12:10:20.642Z 2025-10-04T13:06:43.024Z
7970863 7970863 20250925194803_BVFUz UK001M 2025-09-27T12:10:03.866Z 2025-10-04T13:06:39.578Z
7963899 7963899 20250925034321_EvlYF UK001M 2025-09-26T12:29:14.788Z 2025-10-03T13:04:41.456Z
7963828 7963828 20250925034014_RtuyH UK001M 2025-09-26T12:29:11.736Z 2025-10-03T13:04:39.746Z
7963669 7963669 20250925033037_3gyye UK001M 2025-09-26T12:29:02.692Z 2025-10-03T13:04:38.215Z
7963646 7963646 20250925032945_EtRHe UK001M 2025-09-26T12:29:01.562Z 2025-10-03T13:04:38.171Z
7963552 7963552 20250925032406_WqBgx UK001M 2025-09-26T12:28:56.942Z 2025-10-03T13:04:37.347Z
7963514 7963514 20250925032223_x2HVK UK001M 2025-09-26T12:28:54.295Z 2025-10-03T13:04:37.164Z
7963389 7963389 20250925031716_nAJKH UK001M 2025-09-26T12:28:35.165Z 2025-10-03T13:04:35.739Z
7963323 7963323 20250925031316_ZCtxj UK001M 2025-09-26T12:28:30.210Z 2025-10-03T13:04:33.553Z
7963014 7963014 20250925025802_JGTcm UK001M 2025-09-26T12:28:13.621Z 2025-10-03T13:04:30.169Z
7956889 7956889 20250924195423_bSSUv UK001M 2025-09-26T12:18:06.713Z 2025-10-03T13:03:56.120Z
7956849 7956849 20250924195049_yMgAa UK001M 2025-09-26T12:18:03.407Z 2025-10-03T13:03:55.977Z
7956788 7956788 20250924194633_V3U7J UK001M 2025-09-26T12:17:57.633Z 2025-10-03T13:03:55.784Z
7956722 7956722 20250924193708_uk4vQ UK001M 2025-09-26T12:17:40.485Z 2025-10-03T13:03:55.483Z
7956647 7956647 20250924192730_XaOdH UK001M 2025-09-26T12:17:33.063Z 2025-10-03T13:03:55.213Z
7956602 7956602 20250924192028_BAOd3 UK001M 2025-09-26T12:17:28.563Z 2025-10-03T13:03:55.029Z
7952774 7952774 20250925045108_5mSLA UK001M 2025-09-26T12:01:38.502Z 2025-10-04T13:05:17.669Z
7952514 7952514 20250925043015_2ur5B UK001M 2025-09-26T12:01:12.381Z 2025-10-04T13:05:15.922Z
7952307 7952307 20250925041809_3USIH UK001M 2025-09-26T12:00:43.554Z 2025-10-04T13:05:15.046Z
7952298 7952298 20250925041758_amHN6 UK001M 2025-09-26T12:00:42.780Z 2025-10-04T13:05:14.964Z
7951190 7951190 20250924032718_Lh5Se UK001M 2025-09-25T12:36:17.411Z 2025-10-02T13:28:11.025Z
7950841 7950841 20250924030844_MlvmB UK001M 2025-09-25T12:35:31.523Z 2025-10-02T13:28:02.670Z
7950664 7950664 20250924030023_2Yob2 UK001M 2025-09-25T12:35:24.657Z 2025-10-02T13:28:00.225Z
7950324 7950324 20250924024016_ZD73I UK001M 2025-09-25T12:34:55.185Z 2025-10-02T13:27:54.490Z
7950243 7950243 20250924023624_sQFNS UK001M 2025-09-25T12:34:49.393Z 2025-10-02T13:27:53.922Z
7950211 7950211 20250924023600_uHw21 UK001M 2025-09-25T12:34:48.302Z 2025-10-02T13:27:53.692Z
7950050 7950050 20250924022922_4akWC UK001M 2025-09-25T12:34:40.331Z 2025-10-02T13:27:44.845Z
7949491 7949491 20250924015825_Fsr2g UK001M 2025-09-25T12:33:41.130Z 2025-10-02T13:27:27.196Z
7948895 7948895 20250924012503_GvA7Q UK001M 2025-09-25T12:32:42.715Z 2025-10-02T13:27:17.582Z
7948778 7948778 20250924012028_6lOvb UK001M 2025-09-25T12:32:36.026Z 2025-10-02T13:27:13.726Z
7947989 7947989 20250924003627_8GFO1 UK001M 2025-09-25T12:31:29.977Z 2025-10-02T13:26:56.128Z
7946696 7946696 20250923232123_GVIzd UK001M 2025-09-25T12:29:16.274Z 2025-10-02T13:26:42.017Z
7946596 7946596 20250923231730_rfMx2 UK001M 2025-09-25T12:29:10.891Z 2025-10-02T13:26:41.562Z

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