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,504 rows where station_code = "UK006H" 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
8675777 8675777 20251202051410_c0ChF UK006H 2025-12-03T14:24:14.919Z 2025-12-05T14:28:40.498Z
8675764 8675764 20251202051247_kJqhV UK006H 2025-12-03T14:24:14.288Z 2025-12-05T14:28:40.280Z
8667370 8667370 20251130002509_TG2j3 UK006H 2025-12-02T14:37:28.187Z 2025-12-05T14:42:07.785Z
8667346 8667346 20251130001313_ESKcQ UK006H 2025-12-02T14:37:23.243Z 2025-12-05T14:42:04.088Z
8657733 8657733 20251130060405_xb680 UK006H 2025-12-01T14:34:39.371Z 2025-12-05T14:45:36.181Z
8657638 8657638 20251130055554_4bhZm UK006H 2025-12-01T14:34:35.594Z 2025-12-05T14:45:34.442Z
8657617 8657617 20251130055451_vKoID UK006H 2025-12-01T14:34:35.152Z 2025-12-05T14:45:34.192Z
8656785 8656785 20251130050940_U6fpW UK006H 2025-12-01T14:29:00.551Z 2025-12-05T14:45:21.295Z
8656711 8656711 20251130050653_3EzjQ UK006H 2025-12-01T14:28:57.339Z 2025-12-01T14:28:57.339Z
8656568 8656568 20251130050007_teo9z UK006H 2025-12-01T14:28:45.662Z 2025-12-05T14:45:18.041Z
8656498 8656498 20251130045726_3b8p7 UK006H 2025-12-01T14:28:41.968Z 2025-12-05T14:45:16.893Z
8656390 8656390 20251130045234_OZs2r UK006H 2025-12-01T14:28:35.281Z 2025-12-05T14:45:14.648Z
8655945 8655945 20251130042717_1byaU UK006H 2025-12-01T14:27:41.855Z 2025-12-05T14:44:41.368Z
8655424 8655424 20251130040154_uXuER UK006H 2025-12-01T14:26:53.664Z 2025-12-05T14:44:33.502Z
8655098 8655098 20251130034435_gH3bn UK006H 2025-12-01T14:26:23.085Z 2025-12-05T14:44:27.845Z
8654470 8654470 20251130031747_TDET3 UK006H 2025-12-01T14:25:27.223Z 2025-12-05T14:44:01.124Z
8654460 8654460 20251130031741_2bJ3E UK006H 2025-12-01T14:25:26.878Z 2025-12-05T14:44:00.332Z
8654410 8654410 20251130031446_JA7Ta UK006H 2025-12-01T14:25:23.201Z 2025-12-05T14:43:55.339Z
8654367 8654367 20251130031218_wSRxo UK006H 2025-12-01T14:25:16.338Z 2025-12-05T14:43:54.287Z
8653922 8653922 20251130024816_QfCmd UK006H 2025-12-01T14:24:29.967Z 2025-12-05T14:43:42.801Z
8653907 8653907 20251130024805_vUJ1S UK006H 2025-12-01T14:24:28.615Z 2025-12-05T14:43:42.624Z
8653436 8653436 20251130021618_FiJmh UK006H 2025-12-01T14:23:31.280Z 2025-12-05T14:43:31.510Z
8653262 8653262 20251130020509_pZe2h UK006H 2025-12-01T14:23:08.189Z 2025-12-05T14:43:06.850Z
8653041 8653041 20251130015220_3w6II UK006H 2025-12-01T14:22:41.480Z 2025-12-05T14:42:59.878Z
8652838 8652838 20251130013707_XhlBL UK006H 2025-12-01T14:22:13.029Z 2025-12-05T14:42:54.137Z
8652666 8652666 20251130012636_YX2YB UK006H 2025-12-01T14:21:56.823Z 2025-12-05T14:42:49.711Z
8652651 8652651 20251130012626_EuZ2K UK006H 2025-12-01T14:21:55.831Z 2025-12-05T14:42:49.527Z
8652496 8652496 20251130011301_4GsYK UK006H 2025-12-01T14:21:31.444Z 2025-12-05T14:42:45.718Z
8652364 8652364 20251130010408_5KLjK UK006H 2025-12-01T14:21:18.320Z 2025-12-05T14:42:43.234Z
8651944 8651944 20251130003603_THoeC UK006H 2025-12-01T14:20:18.842Z 2025-12-05T14:42:12.053Z
8651848 8651848 20251130002509_FHH3E UK006H 2025-12-01T14:20:07.682Z 2025-12-05T14:42:07.757Z
8651786 8651786 20251130001809_9Krn3 UK006H 2025-12-01T14:19:53.298Z 2025-12-05T14:42:06.040Z
8651700 8651700 20251130001313_w4yXd UK006H 2025-12-01T14:19:43.450Z 2025-12-01T14:35:21.742Z
8651317 8651317 20251129232620_e1c3T UK006H 2025-12-01T14:18:44.807Z 2025-12-05T14:41:54.888Z
8615619 8615619 20251126051137_5Fjfk UK006H 2025-11-27T14:30:02.920Z 2025-12-04T15:11:30.859Z
8615038 8615038 20251126044224_80rMb UK006H 2025-11-27T14:28:55.173Z 2025-12-04T15:11:25.564Z
8614454 8614454 20251126041110_5C4JU UK006H 2025-11-27T14:27:53.358Z 2025-12-04T15:10:42.035Z
8613898 8613898 20251126033912_DXdwn UK006H 2025-11-27T14:26:55.257Z 2025-12-04T15:09:53.351Z
8613860 8613860 20251126033755_v2B5J UK006H 2025-11-27T14:26:52.861Z 2025-12-04T15:09:52.892Z
8613458 8613458 20251126031836_lVayz UK006H 2025-11-27T14:26:06.349Z 2025-12-04T15:09:40.770Z
8613436 8613436 20251126031734_MAFSf UK006H 2025-11-27T14:26:04.550Z 2025-12-04T15:09:40.534Z
8613361 8613361 20251126031505_Lpqs1 UK006H 2025-11-27T14:25:44.063Z 2025-12-04T15:09:39.934Z
8612903 8612903 20251126025507_dvq4L UK006H 2025-11-27T14:24:59.117Z 2025-12-04T15:09:35.726Z
8612303 8612303 20251126022552_PEg2R UK006H 2025-11-27T14:23:45.796Z 2025-12-04T15:09:29.403Z
8612149 8612149 20251126021950_7jeiF UK006H 2025-11-27T14:23:33.292Z 2025-12-04T15:09:27.925Z
8612100 8612100 20251126021901_m7ycn UK006H 2025-11-27T14:23:31.257Z 2025-12-04T15:09:27.693Z
8611300 8611300 20251126013629_WhRMN UK006H 2025-11-27T14:21:49.859Z 2025-12-04T15:09:07.979Z
8611272 8611272 20251126013558_117MJ UK006H 2025-11-27T14:21:47.981Z 2025-12-04T15:09:07.213Z
8611200 8611200 20251126013036_eXYk3 UK006H 2025-11-27T14:21:38.031Z 2025-12-04T15:08:56.960Z
8610365 8610365 20251126004011_NwTEa UK006H 2025-11-27T14:20:01.104Z 2025-12-04T15:08:04.734Z
8610104 8610104 20251126002133_fN5Jl UK006H 2025-11-27T14:19:26.883Z 2025-12-04T15:08:02.123Z
8609321 8609321 20251125233244_0leFN UK006H 2025-11-27T14:18:04.318Z 2025-12-04T15:07:53.380Z
8608696 8608696 20251125223545_MXcgl UK006H 2025-11-27T14:16:32.885Z 2025-12-04T15:07:47.785Z
8608566 8608566 20251125222803_kUgiA UK006H 2025-11-27T14:16:18.207Z 2025-12-04T15:07:46.439Z
8607701 8607701 20251125211455_5EitK UK006H 2025-11-27T14:14:23.399Z 2025-12-04T15:07:18.809Z
8607602 8607602 20251125210603_TW5AU UK006H 2025-11-27T14:14:01.086Z 2025-11-27T14:32:43.003Z
8607592 8607592 20251125210602_G2aZ3 UK006H 2025-11-27T14:14:00.473Z 2025-12-04T15:07:04.133Z
8607410 8607410 20251125205048_IS6jH UK006H 2025-11-27T14:13:34.823Z 2025-12-04T15:07:01.869Z
8606580 8606580 20251125191456_slN9t UK006H 2025-11-27T14:10:41.579Z 2025-12-04T15:06:47.273Z
8602181 8602181 20251125043946_DWUh6 UK006H 2025-11-26T14:25:25.116Z 2025-12-02T15:09:29.792Z
8601373 8601373 20251125034452_Eo93d UK006H 2025-11-26T14:23:56.547Z 2025-12-02T15:09:08.514Z
8601193 8601193 20251125033755_SwsD3 UK006H 2025-11-26T14:23:47.200Z 2025-12-02T15:09:05.518Z
8601149 8601149 20251125033626_AP2cX UK006H 2025-11-26T14:23:44.630Z 2025-12-02T15:09:00.525Z
8600339 8600339 20251125025437_VlG8o UK006H 2025-11-26T14:22:17.244Z 2025-12-02T15:08:40.918Z
8600298 8600298 20251125025217_Q6R3s UK006H 2025-11-26T14:22:14.899Z 2025-12-02T15:08:40.666Z
8600231 8600231 20251125024919_6Fut4 UK006H 2025-11-26T14:22:10.060Z 2025-12-02T15:08:40.093Z
8600189 8600189 20251125024727_xNPVG UK006H 2025-11-26T14:22:07.731Z 2025-12-02T15:08:39.750Z
8600143 8600143 20251125024547_Sy5aH UK006H 2025-11-26T14:22:04.410Z 2025-12-02T15:08:34.774Z
8600103 8600103 20251125024402_Faut2 UK006H 2025-11-26T14:22:02.811Z 2025-12-02T15:08:34.603Z
8599693 8599693 20251125021817_D9ZGX UK006H 2025-11-26T14:21:24.253Z 2025-12-02T15:08:30.961Z
8597987 8597987 20251125002549_QMKYc UK006H 2025-11-26T14:17:59.113Z 2025-12-02T15:07:43.811Z
8597925 8597925 20251125001914_gem7J UK006H 2025-11-26T14:17:53.643Z 2025-12-02T15:07:43.478Z
8597713 8597713 20251125000334_Ptj7F UK006H 2025-11-26T14:17:25.920Z 2025-12-02T15:07:40.133Z
8597519 8597519 20251124234020_8IAHE UK006H 2025-11-26T14:16:54.853Z 2025-12-02T15:07:36.941Z
8597391 8597391 20251124233123_a733t UK006H 2025-11-26T14:16:45.518Z 2025-12-02T15:07:31.191Z
8597315 8597315 20251124232516_Wfjcm UK006H 2025-11-26T14:16:31.110Z 2025-12-02T15:07:28.167Z
8597273 8597273 20251124231914_ruhO0 UK006H 2025-11-26T14:16:28.376Z 2025-12-02T15:07:27.888Z
8595895 8595895 20251124185720_p2Wr4 UK006H 2025-11-26T14:12:53.911Z 2025-12-02T15:06:21.575Z
8590617 8590617 20251124025817_7D2Yn UK006H 2025-11-25T14:22:18.203Z 2025-12-02T15:12:53.131Z
8590375 8590375 20251124023847_V655X UK006H 2025-11-25T14:21:46.221Z 2025-12-02T15:12:47.212Z
8590095 8590095 20251124022201_c78wA UK006H 2025-11-25T14:21:22.916Z 2025-12-02T15:12:42.253Z
8590087 8590087 20251124022045_0yt69 UK006H 2025-11-25T14:21:22.272Z 2025-12-02T15:12:42.235Z
8589883 8589883 20251124020158_bmQSi UK006H 2025-11-25T14:20:52.403Z 2025-12-02T15:12:39.003Z
8589518 8589518 20251124013758_naJuu UK006H 2025-11-25T14:20:09.173Z 2025-12-02T15:12:32.093Z
8588806 8588806 20251124003246_xQP0Q UK006H 2025-11-25T14:18:19.947Z 2025-12-02T15:11:56.372Z
8588434 8588434 20251123235651_BF0CO UK006H 2025-11-25T14:17:33.798Z 2025-12-02T15:11:42.045Z
8587909 8587909 20251123225943_m3mfh UK006H 2025-11-25T14:16:25.501Z 2025-12-02T15:11:22.701Z
8587695 8587695 20251123223314_j2aRt UK006H 2025-11-25T14:15:55.305Z 2025-12-02T15:11:19.036Z
8587594 8587594 20251123222047_aygSL UK006H 2025-11-25T14:15:37.275Z 2025-12-02T15:11:17.723Z
8587399 8587399 20251123220017_RiBK2 UK006H 2025-11-25T14:15:16.084Z 2025-12-02T15:11:12.336Z
8586982 8586982 20251123211049_v8aqX UK006H 2025-11-25T14:14:20.904Z 2025-12-02T15:11:05.447Z
8586766 8586766 20251123204837_3acrm UK006H 2025-11-25T14:13:50.897Z 2025-12-02T15:11:02.589Z
8585712 8585712 20251123173337_ceyx2 UK006H 2025-11-25T14:10:37.947Z 2025-12-02T15:10:11.473Z
8579257 8579257 20251122225616_kLS8b UK006H 2025-11-24T14:13:52.739Z 2025-12-01T15:20:11.699Z
8578966 8578966 20251122215933_M3Myj UK006H 2025-11-24T14:13:12.217Z 2025-12-01T15:19:57.342Z
8568657 8568657 20251121052900_0taYt UK006H 2025-11-23T14:31:17.989Z 2025-11-29T14:54:47.162Z
8568367 8568367 20251121051459_2Vp2Z UK006H 2025-11-23T14:31:05.268Z 2025-11-29T14:54:46.612Z
8568101 8568101 20251121050130_ClAK9 UK006H 2025-11-23T14:30:52.980Z 2025-11-29T14:54:46.089Z
8567738 8567738 20251121020502_j4U4Z UK006H 2025-11-23T14:27:38.827Z 2025-11-29T14:54:32.708Z
8559957 8559957 20251121043230_NDkR1 UK006H 2025-11-22T14:42:07.814Z 2025-11-29T14:54:44.812Z

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