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

1,962 rows where station_code = "UK002Y" 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
8681743 8681743 20251203035137_aSfqT UK002Y 2025-12-04T14:15:29.479Z 2025-12-06T14:28:27.889Z
8681513 8681513 20251203031949_Dwbqv UK002Y 2025-12-04T14:14:51.321Z 2025-12-06T14:28:15.841Z
8681390 8681390 20251203030313_AzjK2 UK002Y 2025-12-04T14:14:37.145Z 2025-12-06T14:28:05.367Z
8681304 8681304 20251203025549_ilb3X UK002Y 2025-12-04T14:14:26.837Z 2025-12-06T14:28:00.518Z
8681137 8681137 20251203022749_IbgeO UK002Y 2025-12-04T14:13:56.401Z 2025-12-06T14:27:50.977Z
8681121 8681121 20251203022606_yDy6a UK002Y 2025-12-04T14:13:53.925Z 2025-12-06T14:27:50.279Z
8681071 8681071 20251203021807_5Lly7 UK002Y 2025-12-04T14:13:41.121Z 2025-12-06T14:27:48.178Z
8681001 8681001 20251203021139_bKW1C UK002Y 2025-12-04T14:13:32.202Z 2025-12-06T14:27:44.832Z
8680952 8680952 20251203020219_53LnG UK002Y 2025-12-04T14:13:26.218Z 2025-12-06T14:27:34.475Z
8680937 8680937 20251203015657_QOfq3 UK002Y 2025-12-04T14:13:24.511Z 2025-12-06T14:27:33.842Z
8680827 8680827 20251203012408_6geIg UK002Y 2025-12-04T14:13:00.995Z 2025-12-06T14:27:28.192Z
8680811 8680811 20251203012339_ng0Yn UK002Y 2025-12-04T14:12:58.770Z 2025-12-06T14:27:27.647Z
8680631 8680631 20251203005107_1G8dH UK002Y 2025-12-04T14:12:30.523Z 2025-12-06T14:27:20.604Z
8680336 8680336 20251202232813_9G6h6 UK002Y 2025-12-04T14:11:48.442Z 2025-12-06T14:27:03.008Z
8667237 8667237 20251129191504_s6PT2 UK002Y 2025-12-02T14:35:53.440Z 2025-12-06T14:45:46.952Z
8663494 8663494 20251130205019_0TFZK UK002Y 2025-12-02T14:18:22.394Z 2025-12-06T14:40:01.644Z
8657825 8657825 20251130061105_U9pvH UK002Y 2025-12-01T14:34:42.673Z 2025-12-06T14:50:22.931Z
8657627 8657627 20251130055509_pMmVs UK002Y 2025-12-01T14:34:35.422Z 2025-12-06T14:50:16.160Z
8657519 8657519 20251130055059_E4Wha UK002Y 2025-12-01T14:34:32.057Z 2025-12-06T14:50:05.226Z
8657152 8657152 20251130053213_2LOvZ UK002Y 2025-12-01T14:33:56.520Z 2025-12-06T14:49:45.343Z
8657080 8657080 20251130052915_wt8fP UK002Y 2025-12-01T14:33:53.777Z 2025-12-06T14:49:44.593Z
8657074 8657074 20251130052838_oi2BT UK002Y 2025-12-01T14:33:53.292Z 2025-12-06T14:49:44.461Z
8656725 8656725 20251130050728_4hmfK UK002Y 2025-12-01T14:28:58.216Z 2025-12-06T14:49:39.279Z
8656323 8656323 20251130044932_F24pN UK002Y 2025-12-01T14:28:20.491Z 2025-12-06T14:49:33.469Z
8655515 8655515 20251130040608_OjS2S UK002Y 2025-12-01T14:27:01.758Z 2025-12-06T14:49:24.665Z
8650872 8650872 20251129214747_MW0fw UK002Y 2025-12-01T14:17:25.466Z 2025-12-06T14:46:35.039Z
8650432 8650432 20251129201710_jVQWY UK002Y 2025-12-01T14:16:11.572Z 2025-12-06T14:45:56.412Z
8650061 8650061 20251129191503_8gPBm UK002Y 2025-12-01T14:14:57.682Z 2025-12-06T14:45:46.835Z
8644385 8644385 20251128192417_Dyrji UK002Y 2025-11-30T14:21:56.249Z 2025-12-06T14:54:41.592Z
8616660 8616660 20251126061416_l4KB2 UK002Y 2025-11-27T14:31:24.946Z 2025-12-04T15:11:41.646Z
8616631 8616631 20251126061405_8VxTA UK002Y 2025-11-27T14:31:23.588Z 2025-12-04T15:11:41.442Z
8616229 8616229 20251126054723_1ozdI UK002Y 2025-11-27T14:30:57.979Z 2025-12-04T15:11:37.107Z
8614833 8614833 20251126043058_HLS7l UK002Y 2025-11-27T14:28:36.870Z 2025-12-04T15:11:14.194Z
8614001 8614001 20251126034645_1KeON UK002Y 2025-11-27T14:27:04.405Z 2025-12-04T15:10:07.258Z
8612463 8612463 20251126023326_l4u2U UK002Y 2025-11-27T14:24:15.277Z 2025-12-04T15:09:31.046Z
8611445 8611445 20251126014319_0Mmf2 UK002Y 2025-11-27T14:22:09.471Z 2025-12-04T15:09:20.324Z
8611088 8611088 20251126012020_xjRE1 UK002Y 2025-11-27T14:21:10.612Z 2025-12-04T15:08:50.488Z
8610697 8610697 20251126010301_fY0oj UK002Y 2025-11-27T14:20:44.437Z 2025-12-04T15:08:33.308Z
8610328 8610328 20251126003848_FD6XP UK002Y 2025-11-27T14:19:50.905Z 2025-12-04T15:08:04.228Z
8609216 8609216 20251125232208_wRC2U UK002Y 2025-11-27T14:17:47.672Z 2025-12-04T15:07:52.736Z
8608442 8608442 20251125221741_NM3J7 UK002Y 2025-11-27T14:16:06.886Z 2025-12-04T15:07:45.028Z
8607864 8607864 20251125212906_ezqIr UK002Y 2025-11-27T14:14:38.225Z 2025-12-04T15:07:36.947Z
8606613 8606613 20251125191638_SqqBQ UK002Y 2025-11-27T14:10:45.195Z 2025-12-04T15:06:47.659Z
8603189 8603189 20251125054850_zGo2D UK002Y 2025-11-26T14:27:13.320Z 2025-12-02T15:09:34.750Z
8601570 8601570 20251125035741_IYqKB UK002Y 2025-11-26T14:24:27.438Z 2025-12-02T15:09:15.676Z
8601430 8601430 20251125034724_Mlkb3 UK002Y 2025-11-26T14:23:59.135Z 2025-12-02T15:09:09.225Z
8601332 8601332 20251125034445_gaCnv UK002Y 2025-11-26T14:23:55.089Z 2025-12-02T15:09:07.752Z
8601270 8601270 20251125034250_3rWKN UK002Y 2025-11-26T14:23:51.406Z 2025-12-02T15:09:06.455Z
8600252 8600252 20251125024949_LqTzA UK002Y 2025-11-26T14:22:11.413Z 2025-12-02T15:08:40.264Z
8600053 8600053 20251125023931_i3iLi UK002Y 2025-11-26T14:22:00.536Z 2025-12-02T15:08:34.253Z
8599769 8599769 20251125022312_VI1ey UK002Y 2025-11-26T14:21:28.754Z 2025-12-02T15:08:31.952Z
8591628 8591628 20251124043747_1Agog UK002Y 2025-11-25T14:24:40.659Z 2025-12-02T15:12:59.741Z
8591450 8591450 20251124041533_59mpA UK002Y 2025-11-25T14:24:23.166Z 2025-12-02T15:12:58.738Z
8591221 8591221 20251124035357_45ifr UK002Y 2025-11-25T14:23:45.933Z 2025-12-02T15:12:57.475Z
8591213 8591213 20251124035348_nwPVe UK002Y 2025-11-25T14:23:45.469Z 2025-12-02T15:12:57.474Z
8591170 8591170 20251124035219_dfXv7 UK002Y 2025-11-25T14:23:43.069Z 2025-12-02T15:12:57.276Z
8588285 8588285 20251123233833_G68pt UK002Y 2025-11-25T14:17:12.755Z 2025-12-02T15:11:38.909Z
8587885 8587885 20251123225625_dCpmS UK002Y 2025-11-25T14:16:21.880Z 2025-12-02T15:11:22.271Z
8587420 8587420 20251123220134_WsLkK UK002Y 2025-11-25T14:15:17.823Z 2025-12-02T15:11:12.648Z
8587234 8587234 20251123213841_bxCTa UK002Y 2025-11-25T14:14:54.026Z 2025-12-02T15:11:09.643Z
8586813 8586813 20251123205458_k3e0V UK002Y 2025-11-25T14:13:59.898Z 2025-12-02T15:11:03.389Z
8586699 8586699 20251123203319_eKN0f UK002Y 2025-11-25T14:13:37.200Z 2025-12-02T15:10:58.884Z
8586396 8586396 20251123193858_sUxWg UK002Y 2025-11-25T14:12:49.106Z 2025-12-02T15:10:46.843Z
7217862 7217862 20250726224212_8OUbU UK002Y 2025-07-28T12:25:16.071Z 2025-08-04T12:48:53.312Z
7217846 7217846 20250726223946_ELMKV UK002Y 2025-07-28T12:25:14.925Z 2025-08-04T12:48:53.275Z
7217830 7217830 20250726223209_ROEmC UK002Y 2025-07-28T12:25:09.848Z 2025-08-04T12:48:53.171Z
7217676 7217676 20250726214121_nIrdg UK002Y 2025-07-28T12:24:46.572Z 2025-08-04T12:48:51.536Z
7204586 7204586 20250726024452_AFXGb UK002Y 2025-07-28T12:01:42.173Z 2025-08-04T12:47:55.603Z
7204548 7204548 20250726023536_WC6IC UK002Y 2025-07-28T12:01:36.781Z 2025-08-04T12:47:55.571Z
7204499 7204499 20250726022820_FZ353 UK002Y 2025-07-28T12:01:28.432Z 2025-08-04T12:47:55.168Z
7204386 7204386 20250726021432_hJAIn UK002Y 2025-07-28T12:01:02.575Z 2025-08-04T12:47:51.878Z
7204186 7204186 20250726015054_PiANl UK002Y 2025-07-28T12:00:34.381Z 2025-08-04T12:47:45.875Z
7203685 7203685 20250726011328_1DtGC UK002Y 2025-07-27T12:36:11.039Z 2025-08-03T13:06:06.265Z
7203534 7203534 20250726005937_tbM0g UK002Y 2025-07-27T12:36:07.643Z 2025-08-03T13:06:05.745Z
7203257 7203257 20250726003629_KL2Wp UK002Y 2025-07-27T12:36:01.048Z 2025-08-03T13:06:04.352Z
7202592 7202592 20250725233205_6SnyC UK002Y 2025-07-27T12:35:34.875Z 2025-08-03T13:06:01.374Z
7202405 7202405 20250725231913_3hWoE UK002Y 2025-07-27T12:35:29.675Z 2025-08-03T13:06:00.716Z
7202042 7202042 20250725225530_C5skf UK002Y 2025-07-27T12:35:22.520Z 2025-08-03T13:05:58.958Z
7140274 7140274 20250722011539_7M4mv UK002Y 2025-07-23T12:00:42.728Z 2025-07-30T12:08:59.936Z
7139090 7139090 20250721230818_eBlsb UK002Y 2025-07-23T12:00:19.013Z 2025-07-30T12:08:56.694Z
7138457 7138457 20250721213158_UReHn UK002Y 2025-07-23T12:00:10.632Z 2025-07-30T12:08:52.360Z
7129227 7129227 20250721003239_3uVaK UK002Y 2025-07-22T12:00:36.213Z 2025-07-29T12:47:08.102Z
7128349 7128349 20250720233242_0OeBv UK002Y 2025-07-22T12:00:23.012Z 2025-07-29T12:46:59.537Z
7108726 7108726 20250717222534_2YIvI UK002Y 2025-07-20T12:13:22.460Z 2025-07-26T12:45:40.756Z
7108664 7108664 20250717221032_aB84j UK002Y 2025-07-20T12:13:11.091Z 2025-07-26T12:45:39.627Z
7093242 7093242 20250716012011_eHHzU UK002Y 2025-07-17T12:07:17.017Z 2025-07-24T12:01:21.431Z
7089866 7089866 20250715015911_LzwM1 UK002Y 2025-07-16T12:14:13.705Z 2025-07-23T12:05:02.946Z
7089640 7089640 20250715012020_mEtaA UK002Y 2025-07-16T12:13:42.561Z 2025-07-23T12:05:02.354Z
7089322 7089322 20250715004215_P7Te5 UK002Y 2025-07-16T12:13:02.223Z 2025-07-23T12:05:01.872Z
7088871 7088871 20250714234616_Gfg9U UK002Y 2025-07-16T12:12:06.535Z 2025-07-23T12:05:00.746Z
7088774 7088774 20250714233220_HNnvd UK002Y 2025-07-16T12:11:52.883Z 2025-07-23T12:05:00.485Z
7088423 7088423 20250714224055_pHNNL UK002Y 2025-07-16T12:10:47.048Z 2025-07-23T12:04:59.817Z
7088267 7088267 20250714221447_96LzD UK002Y 2025-07-16T12:10:32.852Z 2025-07-23T12:04:59.636Z
7088140 7088140 20250714214606_GjvaA UK002Y 2025-07-16T12:10:04.454Z 2025-07-23T12:04:59.390Z
7079749 7079749 20250713001056_gQXvU UK002Y 2025-07-14T12:11:26.739Z 2025-07-21T12:03:02.306Z
7079344 7079344 20250712232544_veoDY UK002Y 2025-07-14T12:10:14.646Z 2025-07-21T12:03:00.662Z
7079182 7079182 20250712231036_Gnb5c UK002Y 2025-07-14T12:09:53.831Z 2025-07-21T12:03:00.008Z
7078956 7078956 20250712222452_UCpPB UK002Y 2025-07-14T12:08:59.416Z 2025-07-21T12:02:58.837Z
7076672 7076672 20250712021012_JlZ8e UK002Y 2025-07-13T12:13:07.191Z 2025-07-20T12:25:18.986Z
7076390 7076390 20250712013514_Bw7uH UK002Y 2025-07-13T12:12:25.787Z 2025-07-20T12:25:18.117Z

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