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 = "UK0006" 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
9273202 9273202 20260128050635_KXhEA UK0006 2026-01-29T14:29:01.112Z 2026-01-29T14:30:25.769Z
9273028 9273028 20260128042708_CMtUt UK0006 2026-01-29T14:28:31.559Z 2026-01-29T14:30:25.739Z
9272941 9272941 20260128040733_DYhZy UK0006 2026-01-29T14:28:16.878Z 2026-01-29T14:30:25.710Z
9272803 9272803 20260128033928_uknpk UK0006 2026-01-29T14:27:51.813Z 2026-01-29T14:30:25.564Z
9272761 9272761 20260128031746_etVVe UK0006 2026-01-29T14:27:43.996Z 2026-01-29T14:30:25.549Z
9272747 9272747 20260128031352_61Aji UK0006 2026-01-29T14:27:41.290Z 2026-01-29T14:30:25.446Z
9272694 9272694 20260128030822_ixwzV UK0006 2026-01-29T14:27:35.131Z 2026-01-29T14:30:25.440Z
9272598 9272598 20260128024815_s7qkO UK0006 2026-01-29T14:27:13.641Z 2026-01-29T14:30:25.381Z
9272571 9272571 20260128024006_2WYj3 UK0006 2026-01-29T14:27:11.392Z 2026-01-29T14:30:25.379Z
9272478 9272478 20260128021329_vLEln UK0006 2026-01-29T14:26:50.417Z 2026-01-29T14:30:25.353Z
9272337 9272337 20260128013942_rA02f UK0006 2026-01-29T14:26:28.075Z 2026-01-29T14:30:25.332Z
9272326 9272326 20260128013712_gT4Rf UK0006 2026-01-29T14:26:26.482Z 2026-01-29T14:30:25.330Z
9271895 9271895 20260127214256_dZAVh UK0006 2026-01-29T14:24:53.408Z 2026-01-29T14:30:25.227Z
9271743 9271743 20260127194836_XFjFc UK0006 2026-01-29T14:23:14.750Z 2026-01-29T14:30:25.087Z
9271650 9271650 20260127185719_ufUbA UK0006 2026-01-29T14:22:07.256Z 2026-01-29T14:30:24.998Z
9271641 9271641 20260127185145_p8ddO UK0006 2026-01-29T14:22:03.821Z 2026-01-29T14:30:24.994Z
9271633 9271633 20260127184736_i2TAA UK0006 2026-01-29T14:21:55.843Z 2026-01-29T14:30:24.985Z
9260538 9260538 20260125051657_wQxrV UK0006 2026-01-26T14:22:08.956Z 2026-01-29T14:44:20.529Z
9260535 9260535 20260125051650_6zGnE UK0006 2026-01-26T14:22:08.330Z 2026-01-29T14:44:20.293Z
9252630 9252630 20260123045144_jp5Dl UK0006 2026-01-24T14:16:30.778Z 2026-01-29T14:53:12.741Z
9252368 9252368 20260123023336_HuOr3 UK0006 2026-01-24T14:15:16.605Z 2026-01-29T14:52:47.127Z
9252300 9252300 20260123020804_NDv3l UK0006 2026-01-24T14:15:00.429Z 2026-01-29T14:52:44.376Z
9251911 9251911 20260122235937_KjQWt UK0006 2026-01-24T14:13:43.366Z 2026-01-29T14:52:17.067Z
9251847 9251847 20260122232138_qzZN9 UK0006 2026-01-24T14:13:22.827Z 2026-01-29T14:52:12.900Z
9251826 9251826 20260122231805_Lt9JM UK0006 2026-01-24T14:13:20.534Z 2026-01-29T14:52:12.129Z
9243648 9243648 20260121050052_V5oZ2 UK0006 2026-01-22T14:22:39.826Z 2026-01-29T15:05:21.751Z
9243463 9243463 20260121043459_1VNOQ UK0006 2026-01-22T14:22:01.268Z 2026-01-29T15:05:03.518Z
9243414 9243414 20260121043001_azrqI UK0006 2026-01-22T14:21:42.754Z 2026-01-29T15:05:01.457Z
9243380 9243380 20260121042539_HIGo3 UK0006 2026-01-22T14:21:35.714Z 2026-01-29T15:04:59.796Z
9243267 9243267 20260121040703_Q48z5 UK0006 2026-01-22T14:21:09.568Z 2026-01-29T15:04:53.114Z
9242874 9242874 20260121030717_4phD3 UK0006 2026-01-22T14:19:38.139Z 2026-01-29T15:04:25.785Z
9242842 9242842 20260121025826_3aAAJ UK0006 2026-01-22T14:19:32.084Z 2026-01-29T15:04:24.103Z
9242725 9242725 20260121023714_O12oR UK0006 2026-01-22T14:19:03.871Z 2026-01-29T15:04:18.483Z
9242705 9242705 20260121023639_3nfyi UK0006 2026-01-22T14:19:01.714Z 2026-01-29T15:04:17.980Z
9242595 9242595 20260121022336_Evb5a UK0006 2026-01-22T14:18:31.078Z 2026-01-29T15:04:13.148Z
9242524 9242524 20260121021013_itoN7 UK0006 2026-01-22T14:18:12.212Z 2026-01-29T15:04:03.138Z
9236944 9236944 20260120042114_N1FvC UK0006 2026-01-21T14:24:34.441Z 2026-01-28T15:00:50.014Z
9236096 9236096 20260120023406_tPog9 UK0006 2026-01-21T14:21:25.865Z 2026-01-28T14:59:44.669Z
9236091 9236091 20260120023348_yjijZ UK0006 2026-01-21T14:21:25.306Z 2026-01-28T14:59:44.411Z
9235624 9235624 20260120013953_TWrN2 UK0006 2026-01-21T14:19:43.033Z 2026-01-28T14:59:13.056Z
9234863 9234863 20260119234406_Z1lMo UK0006 2026-01-21T14:16:30.958Z 2026-01-28T14:58:17.796Z
9218961 9218961 20260117064631_auPyf UK0006 2026-01-18T14:14:24.771Z 2026-01-25T14:58:56.728Z
9218953 9218953 20260117064519_8odQS UK0006 2026-01-18T14:14:24.035Z 2026-01-25T14:58:56.668Z
9218938 9218938 20260117063916_vAWyx UK0006 2026-01-18T14:14:19.195Z 2026-01-25T14:58:56.242Z
9218831 9218831 20260117060420_IDJdv UK0006 2026-01-18T14:13:54.427Z 2026-01-25T14:58:52.875Z
9217756 9217756 20260116193347_i9gmG UK0006 2026-01-18T14:08:51.004Z 2026-01-25T14:57:46.664Z
9217725 9217725 20260116192423_NyB3G UK0006 2026-01-18T14:08:43.692Z 2026-01-25T14:57:45.968Z
9217664 9217664 20260116185700_XQ76p UK0006 2026-01-18T14:08:27.006Z 2026-01-25T14:57:38.211Z
9212774 9212774 20260116005811_ThUo4 UK0006 2026-01-17T14:13:49.335Z 2026-01-24T15:11:26.042Z
9212750 9212750 20260116004800_TxTYW UK0006 2026-01-17T14:13:38.634Z 2026-01-24T15:11:24.969Z
9212719 9212719 20260116003203_dckzH UK0006 2026-01-17T14:13:28.628Z 2026-01-24T15:11:17.446Z
9212692 9212692 20260116002452_Ek6Su UK0006 2026-01-17T14:13:20.274Z 2026-01-24T15:11:10.324Z
9212682 9212682 20260116002158_aBu5k UK0006 2026-01-17T14:13:16.253Z 2026-01-24T15:11:09.978Z
9212592 9212592 20260115234051_ZHSPD UK0006 2026-01-17T14:12:51.076Z 2026-01-24T15:11:06.778Z
9207318 9207318 20260115005422_DGApl UK0006 2026-01-16T14:08:16.611Z 2026-01-22T15:03:18.661Z
9207306 9207306 20260115004657_uMrPA UK0006 2026-01-16T14:08:13.789Z 2026-01-22T15:03:18.264Z
9207303 9207303 20260115004627_0VrVi UK0006 2026-01-16T14:08:11.775Z 2026-01-22T15:03:18.172Z
9207286 9207286 20260115003732_LLAHh UK0006 2026-01-16T14:08:06.474Z 2026-01-22T15:03:17.571Z
9207211 9207211 20260114235747_NFURG UK0006 2026-01-16T14:07:42.869Z 2026-01-22T15:03:14.796Z
9207191 9207191 20260114233753_h334F UK0006 2026-01-16T14:07:36.821Z 2026-01-22T15:03:14.088Z
9207178 9207178 20260114232719_OJc2W UK0006 2026-01-16T14:07:33.398Z 2026-01-22T15:03:13.318Z
9204548 9204548 20260114065952_rLFor UK0006 2026-01-15T14:27:34.026Z 2026-01-22T15:10:37.196Z
9204528 9204528 20260114065635_ObUD3 UK0006 2026-01-15T14:27:31.309Z 2026-01-22T15:10:31.661Z
9204523 9204523 20260114065552_ukxkS UK0006 2026-01-15T14:27:30.147Z 2026-01-22T15:10:31.253Z
9204510 9204510 20260114065459_uTXpV UK0006 2026-01-15T14:27:29.202Z 2026-01-22T15:10:30.613Z
9204466 9204466 20260114064730_J28JA UK0006 2026-01-15T14:27:25.472Z 2026-01-22T15:10:29.417Z
9204463 9204463 20260114064527_CLbPm UK0006 2026-01-15T14:27:25.109Z 2026-01-22T15:10:28.716Z
9204437 9204437 20260114064408_TQStq UK0006 2026-01-15T14:27:23.741Z 2026-01-22T15:10:28.489Z
9204401 9204401 20260114063756_9fvey UK0006 2026-01-15T14:27:13.783Z 2026-01-22T15:10:27.428Z
9204256 9204256 20260114062101_BcVJE UK0006 2026-01-15T14:26:54.970Z 2026-01-22T15:10:23.317Z
9204197 9204197 20260114061454_Yg3vd UK0006 2026-01-15T14:26:39.290Z 2026-01-22T15:10:22.194Z
9204164 9204164 20260114061225_vpyUR UK0006 2026-01-15T14:26:33.070Z 2026-01-22T15:10:21.484Z
9204102 9204102 20260114060717_5DjCg UK0006 2026-01-15T14:26:24.542Z 2026-01-22T15:10:17.991Z
9204056 9204056 20260114060512_qDjkK UK0006 2026-01-15T14:26:19.977Z 2026-01-22T15:10:17.480Z
9203981 9203981 20260114060153_bjjXo UK0006 2026-01-15T14:26:01.472Z 2026-01-22T15:10:16.542Z
9203959 9203959 20260114060040_NwZ3d UK0006 2026-01-15T14:25:59.490Z 2026-01-22T15:10:16.407Z
9203412 9203412 20260114045437_KBnRL UK0006 2026-01-15T14:24:21.850Z 2026-01-22T15:10:07.213Z
9203354 9203354 20260114045245_xGLxR UK0006 2026-01-15T14:24:09.495Z 2026-01-22T15:10:06.256Z
9203292 9203292 20260114044921_bS4Do UK0006 2026-01-15T14:23:59.601Z 2026-01-22T15:10:05.188Z
9203149 9203149 20260114043700_E3Fhu UK0006 2026-01-15T14:23:26.361Z 2026-01-22T15:10:02.613Z
9203100 9203100 20260114043251_dvO0v UK0006 2026-01-15T14:23:18.082Z 2026-01-22T15:10:01.475Z
9203035 9203035 20260114043022_B3Wvv UK0006 2026-01-15T14:23:13.087Z 2026-01-22T15:10:01.051Z
9203000 9203000 20260114042610_4szaq UK0006 2026-01-15T14:23:01.482Z 2026-01-22T15:10:00.532Z
9202905 9202905 20260114041735_CN1BB UK0006 2026-01-15T14:22:45.513Z 2026-01-22T15:09:59.064Z
9202898 9202898 20260114041728_MFaXC UK0006 2026-01-15T14:22:44.459Z 2026-01-22T15:09:58.967Z
9202846 9202846 20260114041313_TOge1 UK0006 2026-01-15T14:22:37.933Z 2026-01-22T15:09:57.869Z
9202680 9202680 20260114040100_23LYp UK0006 2026-01-15T14:22:07.603Z 2026-01-22T15:09:24.836Z
9202604 9202604 20260114035447_QpcLR UK0006 2026-01-15T14:21:46.656Z 2026-01-22T15:09:23.663Z
9202473 9202473 20260114034208_7QnYh UK0006 2026-01-15T14:21:29.084Z 2026-01-22T15:09:20.984Z
9202331 9202331 20260114033053_MXxyf UK0006 2026-01-15T14:21:05.721Z 2026-01-22T15:09:16.437Z
9202267 9202267 20260114032506_gZd5J UK0006 2026-01-15T14:20:49.982Z 2026-01-22T15:09:15.390Z
9202246 9202246 20260114032445_SmcTs UK0006 2026-01-15T14:20:44.617Z 2026-01-22T15:09:15.148Z
9202210 9202210 20260114032347_GpkHq UK0006 2026-01-15T14:20:43.008Z 2026-01-22T15:09:15.001Z
9202117 9202117 20260114031742_KlUEl UK0006 2026-01-15T14:20:33.997Z 2026-01-22T15:09:13.837Z
9202089 9202089 20260114031527_ibGf2 UK0006 2026-01-15T14:20:30.560Z 2026-01-22T15:09:13.365Z
9201975 9201975 20260114030932_cHnlD UK0006 2026-01-15T14:20:13.061Z 2026-01-22T15:09:11.939Z
9201673 9201673 20260114024103_opGwK UK0006 2026-01-15T14:19:16.775Z 2026-01-22T15:09:07.294Z
9201634 9201634 20260114023739_4CGGn UK0006 2026-01-15T14:19:13.657Z 2026-01-22T15:09:06.969Z
9201620 9201620 20260114023653_S5TII UK0006 2026-01-15T14:19:12.607Z 2026-01-22T15:09:06.865Z
9201465 9201465 20260114022026_nrLPh UK0006 2026-01-15T14:18:42.347Z 2026-01-22T15:09:04.227Z

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