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 = "UK0098" 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
8686334 8686334 20251203193519_gDdIT UK0098 2025-12-05T14:11:44.757Z 2025-12-06T14:21:46.888Z
8686097 8686097 20251203183345_iExE3 UK0098 2025-12-05T14:11:02.007Z 2025-12-06T14:21:29.431Z
8686014 8686014 20251203180907_eRLt9 UK0098 2025-12-05T14:10:43.005Z 2025-12-06T14:21:26.121Z
8685944 8685944 20251203174920_YoNHk UK0098 2025-12-05T14:10:33.669Z 2025-12-06T14:21:22.832Z
8685938 8685938 20251203174727_H0xBi UK0098 2025-12-05T14:10:31.994Z 2025-12-06T14:21:22.005Z
8685890 8685890 20251203172345_NDh7q UK0098 2025-12-05T14:10:23.919Z 2025-12-06T14:21:09.973Z
8681333 8681333 20251203025745_olBOe UK0098 2025-12-04T14:14:31.870Z 2025-12-06T14:28:03.832Z
8681275 8681275 20251203025135_gcaTl UK0098 2025-12-04T14:14:14.575Z 2025-12-06T14:27:58.930Z
8681201 8681201 20251203023829_VxYK3 UK0098 2025-12-04T14:14:03.092Z 2025-12-06T14:27:54.842Z
8680839 8680839 20251203012912_2HnKA UK0098 2025-12-04T14:13:02.691Z 2025-12-06T14:27:28.740Z
8679106 8679106 20251202185511_P5M9r UK0098 2025-12-04T14:08:58.737Z 2025-12-06T14:25:55.228Z
8679034 8679034 20251202183857_pZsRf UK0098 2025-12-04T14:08:48.308Z 2025-12-06T14:25:50.623Z
8678904 8678904 20251202180835_lCOTf UK0098 2025-12-04T14:08:30.237Z 2025-12-06T14:25:38.065Z
8678886 8678886 20251202180044_AHaYO UK0098 2025-12-04T14:08:25.116Z 2025-12-06T14:25:34.161Z
8677013 8677013 20251202064010_12j3o UK0098 2025-12-03T14:26:11.642Z 2025-12-06T14:35:32.943Z
8676926 8676926 20251202063108_mb3Ug UK0098 2025-12-03T14:25:56.392Z 2025-12-06T14:35:30.759Z
8676745 8676745 20251202062030_g0RX2 UK0098 2025-12-03T14:25:32.283Z 2025-12-06T14:35:28.070Z
8676600 8676600 20251202060704_2I4GT UK0098 2025-12-03T14:25:21.153Z 2025-12-06T14:35:24.417Z
8676457 8676457 20251202055315_g4Ivq UK0098 2025-12-03T14:25:13.099Z 2025-12-06T14:35:21.882Z
8676409 8676409 20251202055146_9QRie UK0098 2025-12-03T14:25:11.575Z 2025-12-06T14:35:21.421Z
8676374 8676374 20251202054950_EwSxE UK0098 2025-12-03T14:25:09.839Z 2025-12-06T14:35:20.875Z
8676306 8676306 20251202054523_MYtSy UK0098 2025-12-03T14:25:01.699Z 2025-12-06T14:35:19.958Z
8676132 8676132 20251202053845_NKTYF UK0098 2025-12-03T14:24:44.835Z 2025-12-06T14:35:16.676Z
8676112 8676112 20251202053707_eUJbc UK0098 2025-12-03T14:24:43.169Z 2025-12-06T14:35:10.269Z
8675960 8675960 20251202052706_x3khz UK0098 2025-12-03T14:24:34.096Z 2025-12-06T14:35:05.953Z
8675935 8675935 20251202052435_m8kMj UK0098 2025-12-03T14:24:31.909Z 2025-12-06T14:35:05.197Z
8675923 8675923 20251202052301_Wb9sl UK0098 2025-12-03T14:24:30.663Z 2025-12-06T14:35:04.796Z
8675811 8675811 20251202051530_NIBeK UK0098 2025-12-03T14:24:16.363Z 2025-12-06T14:35:00.655Z
8675745 8675745 20251202051218_RyOBY UK0098 2025-12-03T14:24:13.604Z 2025-12-06T14:34:59.480Z
8675510 8675510 20251202045107_vcp34 UK0098 2025-12-03T14:23:48.675Z 2025-12-06T14:34:55.069Z
8675128 8675128 20251202040334_abF74 UK0098 2025-12-03T14:23:05.569Z 2025-12-06T14:34:30.479Z
8675117 8675117 20251202040248_4zPIK UK0098 2025-12-03T14:23:04.081Z 2025-12-06T14:34:29.837Z
8675040 8675040 20251202035437_9q5Vl UK0098 2025-12-03T14:22:52.322Z 2025-12-06T14:34:27.798Z
8674996 8674996 20251202035043_n0KM4 UK0098 2025-12-03T14:22:49.061Z 2025-12-06T14:34:26.856Z
8674973 8674973 20251202034519_a42MO UK0098 2025-12-03T14:22:47.350Z 2025-12-06T14:34:26.301Z
8674902 8674902 20251202033756_e25Cu UK0098 2025-12-03T14:22:42.117Z 2025-12-06T14:34:22.589Z
8674875 8674875 20251202033543_3zk3u UK0098 2025-12-03T14:22:39.988Z 2025-12-06T14:34:21.874Z
8674868 8674868 20251202033535_vw4A2 UK0098 2025-12-03T14:22:38.053Z 2025-12-06T14:34:21.683Z
8674798 8674798 20251202032748_B3lMQ UK0098 2025-12-03T14:22:26.282Z 2025-12-06T14:34:19.533Z
8674769 8674769 20251202032048_nj9aN UK0098 2025-12-03T14:22:19.479Z 2025-12-06T14:34:18.392Z
8674708 8674708 20251202031041_Wfl7t UK0098 2025-12-03T14:22:13.958Z 2025-12-06T14:34:16.202Z
8674616 8674616 20251202025849_l3X15 UK0098 2025-12-03T14:22:08.293Z 2025-12-06T14:34:13.989Z
8674462 8674462 20251202022852_8uqgC UK0098 2025-12-03T14:21:40.483Z 2025-12-06T14:34:09.691Z
8674429 8674429 20251202022413_ZcjRh UK0098 2025-12-03T14:21:37.697Z 2025-12-06T14:34:08.972Z
8674135 8674135 20251202013226_PMQ9b UK0098 2025-12-03T14:20:58.973Z 2025-12-06T14:33:59.316Z
8658615 8658615 20251126055957_jadbj UK0098 2025-12-01T15:05:21.764Z 2025-12-04T15:11:39.446Z
8658611 8658611 20251126054644_hwbJO UK0098 2025-12-01T15:05:06.338Z 2025-12-04T15:11:36.951Z
8658600 8658600 20251126052541_KE7Ba UK0098 2025-12-01T15:04:55.862Z 2025-12-04T15:11:33.370Z
8658595 8658595 20251126052002_QUzha UK0098 2025-12-01T15:04:52.634Z 2025-12-04T15:11:32.642Z
8658585 8658585 20251126045631_HQARs UK0098 2025-12-01T15:04:48.680Z 2025-12-04T15:11:27.808Z
8658583 8658583 20251126045446_Rg9Mq UK0098 2025-12-01T15:04:47.455Z 2025-12-04T15:11:27.543Z
8658571 8658571 20251126042548_niEUx UK0098 2025-12-01T15:04:40.414Z 2025-12-04T15:11:07.673Z
8658565 8658565 20251126042020_Jes8s UK0098 2025-12-01T15:04:39.160Z 2025-12-04T15:10:56.445Z
8658555 8658555 20251126040529_NF1Fp UK0098 2025-12-01T15:04:36.958Z 2025-12-04T15:10:37.007Z
8658548 8658548 20251126040030_xX6JU UK0098 2025-12-01T15:04:35.920Z 2025-12-04T15:10:33.420Z
8658541 8658541 20251126034501_Sa6pk UK0098 2025-12-01T15:04:32.654Z 2025-12-04T15:10:03.365Z
8658533 8658533 20251126033324_llPkh UK0098 2025-12-01T15:04:29.170Z 2025-12-04T15:09:51.604Z
8658509 8658509 20251126025010_QQmYd UK0098 2025-12-01T15:03:39.958Z 2025-12-04T15:09:34.801Z
8658505 8658505 20251126024138_NAk8Q UK0098 2025-12-01T15:03:37.928Z 2025-12-04T15:09:32.685Z
8658501 8658501 20251126023436_V7b7w UK0098 2025-12-01T15:03:36.390Z 2025-12-04T15:09:31.317Z
8658493 8658493 20251126011731_DG3ie UK0098 2025-12-01T15:02:56.071Z 2025-12-04T15:08:48.387Z
8658480 8658480 20251126001804_8EzDx UK0098 2025-12-01T15:02:20.383Z 2025-12-04T15:07:59.010Z
8658477 8658477 20251126001657_SOR2n UK0098 2025-12-01T15:02:20.221Z 2025-12-04T15:07:58.897Z
8658469 8658469 20251126000515_PDd8W UK0098 2025-12-01T15:02:16.273Z 2025-12-04T15:07:57.339Z
8658459 8658459 20251125233729_7zufw UK0098 2025-12-01T15:02:12.499Z 2025-12-04T15:07:53.686Z
8658457 8658457 20251125231434_39aH2 UK0098 2025-12-01T15:02:10.446Z 2025-12-04T15:07:51.584Z
8658454 8658454 20251125231407_375XI UK0098 2025-12-01T15:02:10.148Z 2025-12-04T15:07:51.387Z
8658450 8658450 20251125225913_Kle1G UK0098 2025-12-01T15:02:08.676Z 2025-12-04T15:07:50.041Z
8658448 8658448 20251125225858_vwujr UK0098 2025-12-01T15:02:08.530Z 2025-12-04T15:07:49.987Z
8658444 8658444 20251125225730_g8ah2 UK0098 2025-12-01T15:02:08.105Z 2025-12-04T15:07:49.732Z
8658442 8658442 20251125225210_lNh08 UK0098 2025-12-01T15:02:07.467Z 2025-12-04T15:07:49.249Z
8658437 8658437 20251125223929_VQk7N UK0098 2025-12-01T15:02:06.046Z 2025-12-04T15:07:48.205Z
8658435 8658435 20251125223834_nax7Z UK0098 2025-12-01T15:02:05.826Z 2025-12-04T15:07:47.979Z
8658404 8658404 20251125210103_vH3Jt UK0098 2025-12-01T15:01:32.076Z 2025-12-04T15:07:03.516Z
8658388 8658388 20251125193841_nju7t UK0098 2025-12-01T15:01:02.515Z 2025-12-04T15:06:50.025Z
8658382 8658382 20251125191118_HUVfA UK0098 2025-12-01T15:00:58.967Z 2025-12-04T15:06:46.731Z
8658375 8658375 20251125175455_0ocKE UK0098 2025-12-01T15:00:50.255Z 2025-12-04T15:06:12.056Z
8603750 8603750 20251125063522_UuAkP UK0098 2025-11-26T14:27:48.675Z 2025-12-02T15:09:37.137Z
8603553 8603553 20251125061337_eSDwS UK0098 2025-11-26T14:27:30.946Z 2025-12-02T15:09:36.206Z
8603292 8603292 20251125055446_GI0MP UK0098 2025-11-26T14:27:19.603Z 2025-12-02T15:09:35.218Z
8603234 8603234 20251125055056_iIIEo UK0098 2025-11-26T14:27:16.055Z 2025-12-02T15:09:34.936Z
8603211 8603211 20251125055013_7ntOb UK0098 2025-11-26T14:27:14.777Z 2025-12-02T15:09:34.827Z
8603179 8603179 20251125054802_W2A3b UK0098 2025-11-26T14:27:12.258Z 2025-12-02T15:09:34.674Z
8602898 8602898 20251125053120_Gdhu4 UK0098 2025-11-26T14:26:26.333Z 2025-12-02T15:09:33.401Z
8602783 8602783 20251125052100_LqInh UK0098 2025-11-26T14:26:20.199Z 2025-12-02T15:09:32.806Z
8602697 8602697 20251125051658_xJeD3 UK0098 2025-11-26T14:26:15.563Z 2025-12-02T15:09:32.255Z
8601300 8601300 20251125034404_i6F64 UK0098 2025-11-26T14:23:53.676Z 2025-12-02T15:09:07.210Z
8601168 8601168 20251125033723_0vI57 UK0098 2025-11-26T14:23:46.150Z 2025-12-02T15:09:05.412Z
8601084 8601084 20251125033245_tN3vn UK0098 2025-11-26T14:23:39.811Z 2025-12-02T15:08:56.889Z
8600907 8600907 20251125032115_5198o UK0098 2025-11-26T14:23:05.372Z 2025-12-02T15:08:51.928Z
8600764 8600764 20251125031711_DPLNR UK0098 2025-11-26T14:22:57.473Z 2025-12-02T15:08:50.289Z
8600740 8600740 20251125031548_3WW7k UK0098 2025-11-26T14:22:56.306Z 2025-12-02T15:08:49.956Z
8600411 8600411 20251125025840_Cfidn UK0098 2025-11-26T14:22:39.407Z 2025-12-02T15:08:43.517Z
8600220 8600220 20251125024916_tbeai UK0098 2025-11-26T14:22:09.808Z 2025-12-02T15:08:40.074Z
8600199 8600199 20251125024734_WmWZL UK0098 2025-11-26T14:22:08.115Z 2025-12-02T15:08:39.816Z
8599825 8599825 20251125022440_nuXOZ UK0098 2025-11-26T14:21:30.293Z 2025-12-02T15:08:32.203Z
8599341 8599341 20251125015903_oGOcN UK0098 2025-11-26T14:20:47.805Z 2025-12-02T15:08:22.348Z
8599276 8599276 20251125015703_5XvTF UK0098 2025-11-26T14:20:44.341Z 2025-12-02T15:08:22.072Z
8599119 8599119 20251125014800_UR2GW UK0098 2025-11-26T14:20:33.129Z 2025-12-02T15:08:20.077Z
8598975 8598975 20251125013919_ioydO UK0098 2025-11-26T14:20:08.095Z 2025-12-02T15:08:15.095Z

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