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

>10,000 rows count all where station_code = "UK002K" 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
9611547 9611547 20260405023351_332WH UK002K 2026-04-06T12:15:03.606Z 2026-04-06T12:16:14.820Z
9611433 9611433 20260405015749_Vi2pC UK002K 2026-04-06T12:14:34.434Z 2026-04-06T12:16:14.799Z
9611389 9611389 20260405014418_VLfbV UK002K 2026-04-06T12:14:15.746Z 2026-04-06T12:16:14.791Z
9611383 9611383 20260405014121_mDGt7 UK002K 2026-04-06T12:14:14.605Z 2026-04-06T12:16:14.790Z
9611341 9611341 20260405013056_y8Lu7 UK002K 2026-04-06T12:14:04.032Z 2026-04-06T12:16:14.782Z
9611204 9611204 20260405004907_hpRXf UK002K 2026-04-06T12:13:28.922Z 2026-04-06T12:16:14.754Z
9610981 9610981 20260404231319_DwIJT UK002K 2026-04-06T12:12:26.144Z 2026-04-06T12:16:14.705Z
9610944 9610944 20260404230047_wFJjN UK002K 2026-04-06T12:12:11.963Z 2026-04-06T12:16:14.696Z
9609232 9609232 20260405040330_4dkes UK002K 2026-04-06T12:00:47.185Z 2026-04-06T12:00:47.185Z
9609185 9609185 20260405035527_nGGrT UK002K 2026-04-06T12:00:39.052Z 2026-04-06T12:00:39.052Z
9609142 9609142 20260405034450_IOS6y UK002K 2026-04-06T12:00:26.053Z 2026-04-06T12:00:26.053Z
9609102 9609102 20260405033411_LHVFk UK002K 2026-04-06T12:00:15.504Z 2026-04-06T12:00:15.504Z
9608994 9608994 20260404030205_hmqpl UK002K 2026-04-05T12:12:32.691Z 2026-04-06T12:20:56.008Z
9608670 9608670 20260404003514_22qps UK002K 2026-04-05T12:11:14.999Z 2026-04-06T12:20:29.573Z
9608465 9608465 20260403231210_EMbP6 UK002K 2026-04-05T12:10:29.651Z 2026-04-06T12:20:14.276Z
9608315 9608315 20260403214956_f3W1a UK002K 2026-04-05T12:10:00.704Z 2026-04-06T12:20:05.480Z
9608253 9608253 20260403212433_zxYil UK002K 2026-04-05T12:09:50.117Z 2026-04-06T12:20:02.083Z
9608155 9608155 20260403201944_ORDdZ UK002K 2026-04-05T12:09:06.892Z 2026-04-06T12:19:46.539Z
9607172 9607172 20260404041632_qYUzM UK002K 2026-04-05T12:00:44.142Z 2026-04-06T12:16:14.377Z
9598372 9598372 20260329233753_Px365 UK002K 2026-03-31T12:10:29.252Z 2026-04-06T12:36:27.990Z
9595445 9595445 20260330040711_r4ygq UK002K 2026-03-31T12:01:26.490Z 2026-04-06T12:30:03.996Z
9595283 9595283 20260330031457_n3uVX UK002K 2026-03-31T12:00:58.422Z 2026-04-06T12:29:51.310Z
9594937 9594937 20260329010620_ZQSXq UK002K 2026-03-30T12:10:39.800Z 2026-04-06T12:40:21.149Z
9594879 9594879 20260329005422_33g5K UK002K 2026-03-30T12:10:31.366Z 2026-04-06T12:40:19.427Z
9594538 9594538 20260328225457_haPpj UK002K 2026-03-30T12:09:47.384Z 2026-04-06T12:39:56.462Z
9594508 9594508 20260328224601_20gsz UK002K 2026-03-30T12:09:43.315Z 2026-04-06T12:39:55.160Z
9594451 9594451 20260328222513_bTYen UK002K 2026-03-30T12:09:34.741Z 2026-04-06T12:39:52.708Z
9594379 9594379 20260328215951_csZpy UK002K 2026-03-30T12:09:26.415Z 2026-04-06T12:39:50.188Z
9594265 9594265 20260328205018_V9wpp UK002K 2026-03-30T12:09:09.944Z 2026-04-06T12:39:45.548Z
9592568 9592568 20260329023522_LRttM UK002K 2026-03-30T12:01:20.216Z 2026-04-06T12:34:15.793Z
9592542 9592542 20260329022700_cXfD1 UK002K 2026-03-30T12:01:15.406Z 2026-04-06T12:34:14.789Z
9592111 9592111 20260328003742_QnuKr UK002K 2026-03-29T12:07:11.028Z 2026-04-05T12:35:37.169Z
9592085 9592085 20260328002600_x65GA UK002K 2026-03-29T12:07:09.627Z 2026-04-05T12:35:28.229Z
9591973 9591973 20260327233720_lREwl UK002K 2026-03-29T12:07:03.593Z 2026-04-05T12:35:23.076Z
9591937 9591937 20260327231700_YQPAv UK002K 2026-03-29T12:07:00.133Z 2026-04-05T12:35:21.496Z
9591892 9591892 20260327230010_qi34L UK002K 2026-03-29T12:06:54.429Z 2026-04-05T12:35:18.932Z
9591880 9591880 20260327225525_T3ii4 UK002K 2026-03-29T12:06:53.799Z 2026-04-05T12:35:18.488Z
9591799 9591799 20260327214149_5sLzX UK002K 2026-03-29T12:06:46.282Z 2026-04-05T12:35:14.286Z
9589974 9589974 20260328042334_2HNOf UK002K 2026-03-29T12:01:47.659Z 2026-04-06T12:37:39.462Z
9589459 9589459 20260328033059_NJrnc UK002K 2026-03-29T12:01:17.010Z 2026-04-06T12:37:24.442Z
9589224 9589224 20260328025549_Q4vjD UK002K 2026-03-29T12:00:55.657Z 2026-04-06T12:37:08.448Z
9589171 9589171 20260328023959_lgWkm UK002K 2026-03-29T12:00:48.961Z 2026-04-06T12:37:04.145Z
9589118 9589118 20260328022742_3ZEAC UK002K 2026-03-29T12:00:44.068Z 2026-04-06T12:37:02.108Z
9589062 9589062 20260328022203_zO9Sf UK002K 2026-03-29T12:00:41.600Z 2026-04-06T12:37:00.999Z
9589025 9589025 20260328021320_6xRWy UK002K 2026-03-29T12:00:38.121Z 2026-04-06T12:36:59.498Z
9588839 9588839 20260328013333_JZ4GM UK002K 2026-03-29T12:00:21.721Z 2026-04-06T12:36:53.737Z
9588824 9588824 20260328012825_2ynwd UK002K 2026-03-29T12:00:19.687Z 2026-04-06T12:36:52.990Z
9585241 9585241 20260325235222_kFlLC UK002K 2026-03-27T12:16:57.957Z 2026-04-03T12:39:52.406Z
9585021 9585021 20260325230656_Ha3wx UK002K 2026-03-27T12:16:33.034Z 2026-04-03T12:39:46.844Z
9584947 9584947 20260325225344_zbphe UK002K 2026-03-27T12:16:26.009Z 2026-04-03T12:39:45.082Z
9584814 9584814 20260325222152_Kj3J5 UK002K 2026-03-27T12:16:10.442Z 2026-04-03T12:39:41.628Z
9584726 9584726 20260325215038_ep3bt UK002K 2026-03-27T12:16:01.188Z 2026-04-03T12:39:30.982Z
9582158 9582158 20260326044244_kSlFq UK002K 2026-03-27T12:04:44.617Z 2026-04-04T12:39:39.068Z
9582130 9582130 20260326044055_FeCwM UK002K 2026-03-27T12:04:42.839Z 2026-04-04T12:39:38.587Z
9581615 9581615 20260326033505_96EFy UK002K 2026-03-27T12:03:29.830Z 2026-04-04T12:39:12.190Z
9581582 9581582 20260326033246_5tDNt UK002K 2026-03-27T12:03:26.862Z 2026-04-04T12:39:11.295Z
9581500 9581500 20260326032000_wPrfj UK002K 2026-03-27T12:03:18.081Z 2026-04-04T12:39:08.916Z
9581321 9581321 20260326025331_9qpnc UK002K 2026-03-27T12:02:43.196Z 2026-04-04T12:38:52.620Z
9581277 9581277 20260326024601_2wnfv UK002K 2026-03-27T12:02:37.211Z 2026-04-04T12:38:51.468Z
9581189 9581189 20260326023416_zUB2z UK002K 2026-03-27T12:02:20.569Z 2026-04-04T12:38:45.264Z
9580895 9580895 20260326015205_Vkhf6 UK002K 2026-03-27T12:01:39.633Z 2026-04-04T12:38:33.120Z
9580756 9580756 20260326012729_Yrky3 UK002K 2026-03-27T12:01:21.828Z 2026-04-04T12:38:27.955Z
9580721 9580721 20260326012234_fGn3C UK002K 2026-03-27T12:01:14.937Z 2026-04-04T12:38:21.530Z
9580348 9580348 20260326003906_bYRGT UK002K 2026-03-27T12:00:15.581Z 2026-04-04T12:38:07.135Z
9577065 9577065 20260325034949_9bkdu UK002K 2026-03-26T12:04:01.172Z 2026-04-03T12:36:33.104Z
9576941 9576941 20260325032731_JWTFp UK002K 2026-03-26T12:03:43.628Z 2026-04-03T12:36:26.535Z
9576594 9576594 20260325023730_qlGZN UK002K 2026-03-26T12:02:43.420Z 2026-04-03T12:36:13.895Z
9560680 9560680 20260321220124_066y3 UK002K 2026-03-23T12:12:01.016Z 2026-03-29T12:21:02.138Z
9560516 9560516 20260321213440_2aQRG UK002K 2026-03-23T12:11:50.243Z 2026-03-29T12:21:00.935Z
9560512 9560512 20260321213419_W3OBH UK002K 2026-03-23T12:11:50.123Z 2026-03-29T12:21:00.897Z
9559923 9559923 20260321201003_KAXAh UK002K 2026-03-23T12:11:33.883Z 2026-03-29T12:20:56.638Z
9559715 9559715 20260321193404_ivPyn UK002K 2026-03-23T12:11:28.127Z 2026-03-29T12:20:47.166Z
9555293 9555293 20260322043730_SgnCs UK002K 2026-03-23T12:03:19.601Z 2026-03-30T12:28:24.480Z
9555026 9555026 20260322035608_fAV9w UK002K 2026-03-23T12:03:03.430Z 2026-03-30T12:28:13.448Z
9554779 9554779 20260322033436_l8M8c UK002K 2026-03-23T12:02:50.691Z 2026-03-30T12:28:08.821Z
9554203 9554203 20260322024921_1P3Z5 UK002K 2026-03-23T12:02:20.041Z 2026-03-30T12:28:00.358Z
9554112 9554112 20260322024020_7dtGZ UK002K 2026-03-23T12:02:14.631Z 2026-03-30T12:27:58.541Z
9553919 9553919 20260322022449_K6i2w UK002K 2026-03-23T12:02:00.304Z 2026-03-30T12:27:55.206Z
9553811 9553811 20260322021543_tCgEl UK002K 2026-03-23T12:01:52.822Z 2026-03-30T12:27:52.871Z
9553735 9553735 20260322020943_MJdEF UK002K 2026-03-23T12:01:48.807Z 2026-03-30T12:27:51.776Z
9553697 9553697 20260322020702_Deskm UK002K 2026-03-23T12:01:46.592Z 2026-03-30T12:27:51.133Z
9553620 9553620 20260322020137_k0p5C UK002K 2026-03-23T12:01:43.563Z 2026-03-30T12:27:50.341Z
9553569 9553569 20260322015456_lo73F UK002K 2026-03-23T12:01:40.827Z 2026-03-30T12:27:49.442Z
9552838 9552838 20260322004621_o3Bm2 UK002K 2026-03-23T12:00:55.466Z 2026-03-30T12:27:31.191Z
9552296 9552296 20260321234845_vj5o3 UK002K 2026-03-23T12:00:12.589Z 2026-03-30T12:27:21.976Z
9552252 9552252 20260320232851_adM2d UK002K 2026-03-22T12:27:35.029Z 2026-03-28T12:37:08.235Z
9543324 9543324 20260321033155_8gNEz UK002K 2026-03-22T12:03:26.857Z 2026-03-29T12:19:06.214Z
9543192 9543192 20260321025943_8w2ev UK002K 2026-03-22T12:02:58.990Z 2026-03-29T12:19:04.042Z
9543060 9543060 20260321022647_rsHqS UK002K 2026-03-22T12:02:33.245Z 2026-03-29T12:19:02.219Z
9542836 9542836 20260321013335_6Nw6r UK002K 2026-03-22T12:01:45.991Z 2026-03-29T12:18:58.982Z
9542703 9542703 20260321005205_kgZWU UK002K 2026-03-22T12:01:18.849Z 2026-03-29T12:18:57.231Z
9542663 9542663 20260321003742_saBIY UK002K 2026-03-22T12:01:10.494Z 2026-03-29T12:18:56.795Z
9542565 9542565 20260321001421_uFtcn UK002K 2026-03-22T12:00:47.903Z 2026-03-29T12:18:45.707Z
9542422 9542422 20260320233219_JBxDq UK002K 2026-03-22T12:00:10.904Z 2026-03-29T12:18:43.704Z
9531224 9531224 20260318224756_U543u UK002K 2026-03-20T12:25:02.479Z 2026-03-26T12:39:18.213Z
9531049 9531049 20260318222119_6Ovkw UK002K 2026-03-20T12:24:55.909Z 2026-03-26T12:39:17.183Z
9530771 9530771 20260318214138_qpGkc UK002K 2026-03-20T12:24:46.030Z 2026-03-26T12:39:15.389Z
9530317 9530317 20260318203902_PlWKh UK002K 2026-03-20T12:24:18.282Z 2026-03-26T12:39:11.350Z
9529743 9529743 20260318192425_rF2fS UK002K 2026-03-20T12:23:36.900Z 2026-03-26T12:39:06.152Z
9521696 9521696 20260319043514_OWSmi UK002K 2026-03-20T12:08:24.394Z 2026-03-27T12:41:04.336Z

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