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

4,464 rows where station_code = "UK00A2" 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
8681849 8681849 20251203041554_3ZcMh UK00A2 2025-12-04T14:15:47.422Z 2025-12-06T14:28:33.947Z
8681628 8681628 20251203033319_o3FO4 UK00A2 2025-12-04T14:15:10.007Z 2025-12-06T14:28:21.600Z
8681537 8681537 20251203032248_5HhVl UK00A2 2025-12-04T14:15:00.687Z 2025-12-06T14:28:17.402Z
8681365 8681365 20251203025919_kuJjd UK00A2 2025-12-04T14:14:34.093Z 2025-12-06T14:28:04.728Z
8680988 8680988 20251203020755_iZEKE UK00A2 2025-12-04T14:13:31.092Z 2025-12-06T14:27:43.235Z
8680983 8680983 20251203020653_9qvY0 UK00A2 2025-12-04T14:13:30.469Z 2025-12-06T14:27:40.914Z
8680927 8680927 20251203015357_RbaTv UK00A2 2025-12-04T14:13:22.978Z 2025-12-06T14:27:33.379Z
8680892 8680892 20251203014256_PXI7d UK00A2 2025-12-04T14:13:11.492Z 2025-12-06T14:27:32.089Z
8680560 8680560 20251203003035_0cDKk UK00A2 2025-12-04T14:12:21.711Z 2025-12-06T14:27:17.770Z
8675972 8675972 20251202052755_89g4R UK00A2 2025-12-03T14:24:34.479Z 2025-12-06T14:35:06.145Z
8675765 8675765 20251202051247_kJqhV UK00A2 2025-12-03T14:24:14.300Z 2025-12-06T14:34:59.617Z
8675577 8675577 20251202045712_PzSvr UK00A2 2025-12-03T14:23:52.459Z 2025-12-06T14:34:56.548Z
8675397 8675397 20251202043526_LkBOe UK00A2 2025-12-03T14:23:40.166Z 2025-12-06T14:34:51.242Z
8675336 8675336 20251202042952_ijeLw UK00A2 2025-12-03T14:23:31.906Z 2025-12-06T14:34:49.686Z
8675186 8675186 20251202041407_g9Twc UK00A2 2025-12-03T14:23:16.218Z 2025-12-06T14:34:46.909Z
8675052 8675052 20251202035623_aVEhM UK00A2 2025-12-03T14:22:53.011Z 2025-12-06T14:34:28.236Z
8667508 8667508 20251130020100_bqpj2 UK00A2 2025-12-02T14:38:44.647Z 2025-12-06T14:47:50.944Z
8667397 8667397 20251130010109_YEHsy UK00A2 2025-12-02T14:37:58.544Z 2025-12-06T14:47:33.291Z
8667311 8667311 20251129231640_3a4IW UK00A2 2025-12-02T14:36:52.797Z 2025-12-06T14:46:42.945Z
8656987 8656987 20251130052356_5Ikoa UK00A2 2025-12-01T14:33:51.451Z 2025-12-06T14:49:43.940Z
8656976 8656976 20251130052350_fbqoj UK00A2 2025-12-01T14:33:51.234Z 2025-12-06T14:49:43.884Z
8656362 8656362 20251130045150_bPox3 UK00A2 2025-12-01T14:28:28.051Z 2025-12-06T14:49:34.019Z
8656059 8656059 20251130043351_Lw63u UK00A2 2025-12-01T14:27:59.794Z 2025-12-06T14:49:30.155Z
8655412 8655412 20251130040130_cvDx4 UK00A2 2025-12-01T14:26:53.236Z 2025-12-06T14:49:14.999Z
8655101 8655101 20251130034435_gH3bn UK00A2 2025-12-01T14:26:23.085Z 2025-12-06T14:48:51.465Z
8654845 8654845 20251130033607_f0tws UK00A2 2025-12-01T14:26:06.190Z 2025-12-01T14:26:06.190Z
8654530 8654530 20251130031921_p3lvk UK00A2 2025-12-01T14:25:32.824Z 2025-12-06T14:48:43.661Z
8654042 8654042 20251130025437_k2mlZ UK00A2 2025-12-01T14:24:46.405Z 2025-12-06T14:48:36.386Z
8653950 8653950 20251130024836_SBFXG UK00A2 2025-12-01T14:24:31.900Z 2025-12-06T14:48:34.881Z
8653926 8653926 20251130024816_QfCmd UK00A2 2025-12-01T14:24:29.967Z 2025-12-06T14:48:34.573Z
8653910 8653910 20251130024805_vUJ1S UK00A2 2025-12-01T14:24:28.615Z 2025-12-06T14:48:34.453Z
8653165 8653165 20251130020100_pBLJy UK00A2 2025-12-01T14:23:01.165Z 2025-12-01T14:35:22.227Z
8652840 8652840 20251130013707_XhlBL UK00A2 2025-12-01T14:22:13.030Z 2025-12-06T14:47:43.147Z
8652498 8652498 20251130011301_4GsYK UK00A2 2025-12-01T14:21:31.445Z 2025-12-06T14:47:37.797Z
8652428 8652428 20251130010838_q8LyU UK00A2 2025-12-01T14:21:22.916Z 2025-12-06T14:47:36.902Z
8652366 8652366 20251130010408_5KLjK UK00A2 2025-12-01T14:21:18.320Z 2025-12-06T14:47:36.171Z
8652174 8652174 20251130005130_EIUQ2 UK00A2 2025-12-01T14:20:51.275Z 2025-12-06T14:47:26.995Z
8652107 8652107 20251130004808_P9MOO UK00A2 2025-12-01T14:20:43.787Z 2025-12-06T14:47:18.720Z
8651998 8651998 20251130004006_UF6c2 UK00A2 2025-12-01T14:20:25.747Z 2025-12-06T14:46:57.482Z
8651968 8651968 20251130003824_OPcRw UK00A2 2025-12-01T14:20:21.610Z 2025-12-06T14:46:56.985Z
8651945 8651945 20251130003603_THoeC UK00A2 2025-12-01T14:20:18.842Z 2025-12-06T14:46:56.571Z
8651854 8651854 20251130002509_FHH3E UK00A2 2025-12-01T14:20:07.682Z 2025-12-06T14:46:54.959Z
8651788 8651788 20251130001809_9Krn3 UK00A2 2025-12-01T14:19:53.298Z 2025-12-06T14:46:53.902Z
8651321 8651321 20251129232620_e1c3T UK00A2 2025-12-01T14:18:44.835Z 2025-12-06T14:46:43.812Z
8651232 8651232 20251129231021_sBf6B UK00A2 2025-12-01T14:18:26.966Z 2025-12-06T14:46:42.239Z
8650858 8650858 20251129214109_cOmfJ UK00A2 2025-12-01T14:17:19.066Z 2025-12-06T14:46:34.756Z
8635110 8635110 20251128014223_BZsIc UK00A2 2025-11-29T14:22:41.252Z 2025-12-06T15:02:40.718Z
8634165 8634165 20251128002927_u4FaX UK00A2 2025-11-29T14:20:51.118Z 2025-12-06T15:01:51.956Z
8633692 8633692 20251127234616_roh6q UK00A2 2025-11-29T14:20:06.472Z 2025-12-06T15:01:47.961Z
8633654 8633654 20251127234434_BIhsx UK00A2 2025-11-29T14:20:03.034Z 2025-12-06T15:01:47.601Z
8633504 8633504 20251127232645_xB2cv UK00A2 2025-11-29T14:19:48.939Z 2025-12-06T15:01:44.914Z
8633485 8633485 20251127232251_ZH2YH UK00A2 2025-11-29T14:19:47.248Z 2025-12-06T15:01:44.531Z
8633396 8633396 20251127231157_JS2wc UK00A2 2025-11-29T14:19:40.765Z 2025-12-06T15:01:43.498Z
8633167 8633167 20251127224845_faiT2 UK00A2 2025-11-29T14:19:11.695Z 2025-12-06T15:01:40.776Z
8632904 8632904 20251127221552_iSPqS UK00A2 2025-11-29T14:18:33.909Z 2025-12-06T15:01:35.356Z
8614588 8614588 20251126041928_V8aVX UK00A2 2025-11-27T14:28:04.045Z 2025-12-04T15:10:53.210Z
8614331 8614331 20251126040441_2e60y UK00A2 2025-11-27T14:27:47.083Z 2025-12-04T15:10:36.794Z
8614085 8614085 20251126035019_yWgBJ UK00A2 2025-11-27T14:27:12.030Z 2025-12-04T15:10:18.893Z
8613032 8613032 20251126025942_RllBo UK00A2 2025-11-27T14:25:19.288Z 2025-12-04T15:09:36.568Z
8612679 8612679 20251126024138_2m4LS UK00A2 2025-11-27T14:24:27.408Z 2025-12-04T15:09:32.682Z
8612671 8612671 20251126024138_GUh6e UK00A2 2025-11-27T14:24:27.138Z 2025-12-04T15:09:32.648Z
8612151 8612151 20251126021950_7jeiF UK00A2 2025-11-27T14:23:33.292Z 2025-12-04T15:09:27.925Z
8612111 8612111 20251126021901_cWnUP UK00A2 2025-11-27T14:23:31.521Z 2025-12-04T15:09:27.767Z
8611673 8611673 20251126015535_xvdh7 UK00A2 2025-11-27T14:22:28.581Z 2025-12-04T15:09:23.185Z
8611372 8611372 20251126013851_6nrYx UK00A2 2025-11-27T14:22:04.729Z 2025-12-04T15:09:11.208Z
8611194 8611194 20251126013036_0z75P UK00A2 2025-11-27T14:21:37.748Z 2025-12-04T15:08:56.860Z
8610885 8610885 20251126011301_D9Zjh UK00A2 2025-11-27T14:20:55.142Z 2025-12-04T15:08:44.397Z
8610057 8610057 20251126001940_kzyfL UK00A2 2025-11-27T14:19:24.728Z 2025-12-04T15:08:01.532Z
8609947 8609947 20251126001321_Eduol UK00A2 2025-11-27T14:19:16.030Z 2025-12-04T15:07:58.367Z
8609645 8609645 20251125235735_3IOxb UK00A2 2025-11-27T14:18:46.291Z 2025-12-04T15:07:56.361Z
8608906 8608906 20251125225811_eanRU UK00A2 2025-11-27T14:17:03.265Z 2025-12-04T15:07:49.815Z
8608688 8608688 20251125223544_w2pAC UK00A2 2025-11-27T14:16:32.493Z 2025-12-04T15:07:47.750Z
8608364 8608364 20251125221001_BhXqj UK00A2 2025-11-27T14:15:45.731Z 2025-12-04T15:07:44.120Z
8608202 8608202 20251125220143_M2Dy4 UK00A2 2025-11-27T14:15:33.780Z 2025-12-04T15:07:42.698Z
8608148 8608148 20251125215214_0OaZy UK00A2 2025-11-27T14:15:27.172Z 2025-12-04T15:07:41.601Z
8607772 8607772 20251125211851_RGcrn UK00A2 2025-11-27T14:14:27.820Z 2025-12-04T15:07:29.577Z
8607714 8607714 20251125211455_lEMY2 UK00A2 2025-11-27T14:14:23.814Z 2025-12-04T15:07:23.056Z
8607633 8607633 20251125210812_lujbH UK00A2 2025-11-27T14:14:06.986Z 2025-12-04T15:07:07.012Z
8607599 8607599 20251125210602_6C7Xe UK00A2 2025-11-27T14:14:00.810Z 2025-12-04T15:07:04.179Z
8607506 8607506 20251125205832_pY3HC UK00A2 2025-11-27T14:13:53.299Z 2025-12-04T15:07:03.220Z
8607403 8607403 20251125205047_S3FR6 UK00A2 2025-11-27T14:13:34.362Z 2025-12-04T15:07:01.831Z
8606304 8606304 20251125183250_tHEKD UK00A2 2025-11-27T14:09:48.321Z 2025-12-04T15:06:43.787Z
8606257 8606257 20251125182605_Uk2o1 UK00A2 2025-11-27T14:09:40.088Z 2025-12-04T15:06:43.036Z
8606168 8606168 20251125180907_La62n UK00A2 2025-11-27T14:09:15.526Z 2025-12-04T15:06:28.773Z
8606078 8606078 20251125175111_n4zfB UK00A2 2025-11-27T14:08:52.883Z 2025-12-04T15:06:03.354Z
8601963 8601963 20251125042817_wnRlg UK00A2 2025-11-26T14:25:13.966Z 2025-12-02T15:09:28.994Z
8601754 8601754 20251125041235_vGuoO UK00A2 2025-11-26T14:24:40.207Z 2025-12-02T15:09:23.640Z
8599466 8599466 20251125020651_O0zjo UK00A2 2025-11-26T14:20:57.557Z 2025-12-02T15:08:24.516Z
8599226 8599226 20251125015443_rylXe UK00A2 2025-11-26T14:20:41.096Z 2025-12-02T15:08:21.732Z
8598955 8598955 20251125013730_43gGJ UK00A2 2025-11-26T14:20:06.552Z 2025-12-02T15:08:15.064Z
8598865 8598865 20251125013143_jxOf5 UK00A2 2025-11-26T14:20:00.334Z 2025-12-02T15:08:09.947Z
8598818 8598818 20251125012901_MaQKr UK00A2 2025-11-26T14:19:55.765Z 2025-12-02T15:08:09.495Z
8598813 8598813 20251125012750_w0vM5 UK00A2 2025-11-26T14:19:55.205Z 2025-12-02T15:08:09.456Z
8598802 8598802 20251125012451_b0EC9 UK00A2 2025-11-26T14:19:54.198Z 2025-12-02T15:08:09.386Z
8598481 8598481 20251125010033_78emm UK00A2 2025-11-26T14:19:10.968Z 2025-12-02T15:07:55.355Z
8597899 8597899 20251125001720_9GoH2 UK00A2 2025-11-26T14:17:51.450Z 2025-12-02T15:07:43.217Z
8597520 8597520 20251124234020_8IAHE UK00A2 2025-11-26T14:16:54.853Z 2025-12-02T15:07:36.941Z
8597309 8597309 20251124232516_IcOAV UK00A2 2025-11-26T14:16:30.791Z 2025-12-02T15:07:28.145Z
8596884 8596884 20251124222252_2km34 UK00A2 2025-11-26T14:15:41.373Z 2025-12-02T15:07:17.196Z
8596536 8596536 20251124212911_IpdJ3 UK00A2 2025-11-26T14:14:42.502Z 2025-12-02T15:07:02.230Z

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