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

4,540 rows where station_code = "UK0088" 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
9272314 9272314 20260128013415_SPa4R UK0088 2026-01-29T14:26:24.089Z 2026-01-29T14:30:25.327Z
9272309 9272309 20260128013402_rMv5r UK0088 2026-01-29T14:26:23.585Z 2026-01-29T14:30:25.326Z
9244230 9244230 20260121065243_pwNzv UK0088 2026-01-22T14:24:39.793Z 2026-01-29T15:05:56.654Z
9244063 9244063 20260121060557_TnZtP UK0088 2026-01-22T14:24:03.794Z 2026-01-29T15:05:50.391Z
9236257 9236257 20260120025159_wFz8q UK0088 2026-01-21T14:22:11.495Z 2026-01-28T14:59:52.196Z
9233903 9233903 20260119184225_TiqNZ UK0088 2026-01-21T14:11:17.401Z 2026-01-28T14:56:51.948Z
9231206 9231206 20260119063324_2AvWh UK0088 2026-01-20T14:31:52.046Z 2026-01-27T15:06:07.217Z
9231195 9231195 20260119062756_29LYc UK0088 2026-01-20T14:31:49.202Z 2026-01-27T15:06:04.669Z
9231160 9231160 20260119061450_WP5D8 UK0088 2026-01-20T14:31:37.173Z 2026-01-27T15:06:02.790Z
9231057 9231057 20260119055131_2n4aI UK0088 2026-01-20T14:31:03.771Z 2026-01-27T15:05:55.428Z
9230757 9230757 20260119050158_lLr0J UK0088 2026-01-20T14:29:37.118Z 2026-01-27T15:05:24.629Z
9230661 9230661 20260119044704_s2HcS UK0088 2026-01-20T14:29:09.086Z 2026-01-27T15:05:19.306Z
9230465 9230465 20260119042352_2LA6V UK0088 2026-01-20T14:28:00.973Z 2026-01-27T15:04:56.400Z
9230414 9230414 20260119041635_mcE2Y UK0088 2026-01-20T14:27:42.377Z 2026-01-27T15:04:53.466Z
9230000 9230000 20260119030804_Yrrpk UK0088 2026-01-20T14:25:24.015Z 2026-01-27T15:04:19.340Z
9229759 9229759 20260119022859_5RFdZ UK0088 2026-01-20T14:24:06.359Z 2026-01-27T15:03:53.504Z
9229600 9229600 20260119020535_etRpY UK0088 2026-01-20T14:23:17.904Z 2026-01-27T15:03:44.372Z
9228375 9228375 20260118215756_FCwmZ UK0088 2026-01-20T14:17:29.563Z 2026-01-27T15:01:57.399Z
9224444 9224444 20260118044642_FYUgi UK0088 2026-01-19T14:24:24.303Z 2026-01-26T15:03:19.132Z
9224424 9224424 20260118044219_vINdJ UK0088 2026-01-19T14:24:20.339Z 2026-01-26T15:03:18.390Z
9224421 9224421 20260118044052_1HyKc UK0088 2026-01-19T14:24:19.870Z 2026-01-26T15:03:18.280Z
9224377 9224377 20260118042900_9WJzc UK0088 2026-01-19T14:24:08.311Z 2026-01-26T15:03:16.349Z
9224204 9224204 20260118035120_7HQ3T UK0088 2026-01-19T14:23:18.917Z 2026-01-26T15:03:08.697Z
9224144 9224144 20260118033433_Alb7a UK0088 2026-01-19T14:23:04.252Z 2026-01-26T15:03:06.501Z
9223652 9223652 20260118015640_3gTQt UK0088 2026-01-19T14:20:30.849Z 2026-01-26T15:02:30.905Z
9223566 9223566 20260118012602_XicZm UK0088 2026-01-19T14:19:59.151Z 2026-01-26T15:02:14.747Z
9223458 9223458 20260118004925_H6oGm UK0088 2026-01-19T14:19:25.868Z 2026-01-26T15:02:07.640Z
9223281 9223281 20260118000535_DfaOI UK0088 2026-01-19T14:18:30.313Z 2026-01-26T15:02:00.811Z
9223084 9223084 20260117225831_XIULx UK0088 2026-01-19T14:17:34.894Z 2026-01-26T15:01:41.765Z
9223034 9223034 20260117222545_jJUF1 UK0088 2026-01-19T14:17:22.087Z 2026-01-26T15:01:32.758Z
9222947 9222947 20260117213839_2cfHG UK0088 2026-01-19T14:16:55.382Z 2026-01-26T15:01:28.983Z
9217927 9217927 20260116204800_hlbNn UK0088 2026-01-18T14:09:37.545Z 2026-01-25T14:57:52.244Z
9213681 9213681 20260116042352_7ysNa UK0088 2026-01-17T14:18:08.111Z 2026-01-24T15:12:30.954Z
9213478 9213478 20260116034549_6HhlL UK0088 2026-01-17T14:17:07.661Z 2026-01-24T15:12:17.062Z
9213417 9213417 20260116032500_1ifZF UK0088 2026-01-17T14:16:49.619Z 2026-01-24T15:12:12.823Z
9213277 9213277 20260116030020_k3sW3 UK0088 2026-01-17T14:16:15.067Z 2026-01-24T15:12:06.940Z
9213273 9213273 20260116025917_yPxQl UK0088 2026-01-17T14:16:14.479Z 2026-01-24T15:12:06.781Z
9213174 9213174 20260116022925_MM8FV UK0088 2026-01-17T14:15:44.451Z 2026-01-24T15:11:47.657Z
9212819 9212819 20260116010948_M2aul UK0088 2026-01-17T14:14:05.708Z 2026-01-24T15:11:28.011Z
9212726 9212726 20260116003221_iAnm9 UK0088 2026-01-17T14:13:30.255Z 2026-01-24T15:11:22.359Z
9212722 9212722 20260116003214_i07EI UK0088 2026-01-17T14:13:29.459Z 2026-01-24T15:11:20.565Z
9212573 9212573 20260115231430_rBvzg UK0088 2026-01-17T14:12:44.297Z 2026-01-24T15:11:03.760Z
9212487 9212487 20260115221416_RTFuj UK0088 2026-01-17T14:12:11.508Z 2026-01-24T15:10:57.431Z
9212478 9212478 20260115220459_S7Peg UK0088 2026-01-17T14:12:07.773Z 2026-01-24T15:10:56.760Z
9212452 9212452 20260115213252_iTupM UK0088 2026-01-17T14:11:55.461Z 2026-01-24T15:10:55.117Z
9212448 9212448 20260115213218_QmoOD UK0088 2026-01-17T14:11:53.545Z 2026-01-24T15:10:54.732Z
9212409 9212409 20260115210800_ajvoe UK0088 2026-01-17T14:11:39.603Z 2026-01-24T15:10:51.457Z
9212378 9212378 20260115205744_CmJx2 UK0088 2026-01-17T14:11:29.508Z 2026-01-24T15:10:50.135Z
9211987 9211987 20260115183843_iMHLR UK0088 2026-01-17T14:09:22.422Z 2026-01-24T15:10:17.315Z
9211888 9211888 20260115181632_6MH39 UK0088 2026-01-17T14:08:56.087Z 2026-01-24T15:10:08.910Z
9208138 9208138 20260115041914_gGi1j UK0088 2026-01-16T14:11:27.939Z 2026-01-22T15:04:02.137Z
9207968 9207968 20260115034103_WqyQf UK0088 2026-01-16T14:10:51.951Z 2026-01-22T15:03:57.690Z
9204226 9204226 20260114061619_Dr2zR UK0088 2026-01-15T14:26:51.208Z 2026-01-22T15:10:22.537Z
9203862 9203862 20260114054520_E5bh4 UK0088 2026-01-15T14:25:42.854Z 2026-01-22T15:10:14.553Z
9203250 9203250 20260114044523_VeXSp UK0088 2026-01-15T14:23:54.506Z 2026-01-22T15:10:04.454Z
9203141 9203141 20260114043650_pVb3z UK0088 2026-01-15T14:23:25.187Z 2026-01-22T15:10:02.503Z
9200382 9200382 20260113235513_1rjWR UK0088 2026-01-15T14:14:54.368Z 2026-01-22T15:08:15.036Z
9200291 9200291 20260113233643_vJHVi UK0088 2026-01-15T14:14:38.233Z 2026-01-22T15:08:13.370Z
9200286 9200286 20260113233406_FEyY6 UK0088 2026-01-15T14:14:37.080Z 2026-01-22T15:08:13.233Z
9200106 9200106 20260113225241_V3Mru UK0088 2026-01-15T14:13:46.804Z 2026-01-22T15:08:09.709Z
9199914 9199914 20260113215531_pU9TU UK0088 2026-01-15T14:13:02.665Z 2026-01-22T15:08:05.338Z
9199908 9199908 20260113215336_26oDr UK0088 2026-01-15T14:13:01.445Z 2026-01-22T15:08:05.243Z
9198914 9198914 20260113183046_ksQsj UK0088 2026-01-15T14:08:18.543Z 2026-01-22T15:07:09.124Z
9176707 9176707 20260110061051_o8iQa UK0088 2026-01-11T14:09:46.799Z 2026-01-18T15:08:51.317Z
9162958 9162958 20260107050956_EJLtN UK0088 2026-01-08T14:07:31.752Z 2026-01-13T15:02:48.887Z
9158083 9158083 20260105195910_28R2X UK0088 2026-01-07T14:04:46.535Z 2026-01-13T15:06:54.107Z
9157753 9157753 20260105184333_L9kkC UK0088 2026-01-07T14:03:25.508Z 2026-01-13T15:06:27.518Z
9157740 9157740 20260105183952_8bUwI UK0088 2026-01-07T14:03:22.172Z 2026-01-13T15:06:26.842Z
9156018 9156018 20260104063719_nYUeP UK0088 2026-01-06T14:38:25.547Z 2026-01-12T15:11:34.807Z
9155943 9155943 20260104063231_RerRr UK0088 2026-01-06T14:38:16.311Z 2026-01-12T15:11:32.667Z
9155529 9155529 20260104060051_Y4HMW UK0088 2026-01-06T14:37:29.835Z 2026-01-12T15:11:05.895Z
9155454 9155454 20260104055655_e9L0i UK0088 2026-01-06T14:37:24.072Z 2026-01-12T15:11:03.212Z
9155206 9155206 20260104054317_sNdJa UK0088 2026-01-06T14:36:58.215Z 2026-01-12T15:10:53.600Z
9155137 9155137 20260104053717_nYmOg UK0088 2026-01-06T14:36:51.141Z 2026-01-12T15:10:50.521Z
9154972 9154972 20260104052649_xNXmO UK0088 2026-01-06T14:36:26.477Z 2026-01-12T15:10:28.178Z
9154949 9154949 20260104052544_WlOw4 UK0088 2026-01-06T14:36:24.138Z 2026-01-12T15:10:27.571Z
9154900 9154900 20260104052302_DPHZq UK0088 2026-01-06T14:36:21.321Z 2026-01-12T15:10:25.991Z
9154810 9154810 20260104051608_jy88H UK0088 2026-01-06T14:36:12.981Z 2026-01-12T15:10:20.522Z
9154779 9154779 20260104051417_XM76g UK0088 2026-01-06T14:36:11.060Z 2026-01-12T15:10:19.671Z
9154689 9154689 20260104050922_jXyH3 UK0088 2026-01-06T14:35:53.006Z 2026-01-12T15:10:15.683Z
9154589 9154589 20260104050319_AEe42 UK0088 2026-01-06T14:35:44.518Z 2026-01-12T15:10:11.259Z
9154528 9154528 20260104050008_GlElG UK0088 2026-01-06T14:35:39.557Z 2026-01-12T15:10:08.674Z
9153903 9153903 20260104042210_USqnD UK0088 2026-01-06T14:34:20.817Z 2026-01-12T15:09:12.724Z
9153679 9153679 20260104040909_bBZXS UK0088 2026-01-06T14:33:50.223Z 2026-01-12T15:09:01.299Z
9153667 9153667 20260104040742_3VE3B UK0088 2026-01-06T14:33:48.977Z 2026-01-12T15:09:00.828Z
9153611 9153611 20260104040354_gkSp7 UK0088 2026-01-06T14:33:43.183Z 2026-01-12T15:08:57.963Z
9153530 9153530 20260104040006_mwW6h UK0088 2026-01-06T14:33:28.878Z 2026-01-12T15:08:54.781Z
9151570 9151570 20260105055502_sVncc UK0088 2026-01-06T14:14:04.162Z 2026-01-13T15:14:56.365Z
9151561 9151561 20260105055446_0cwtM UK0088 2026-01-06T14:14:02.937Z 2026-01-13T15:14:49.454Z
9151548 9151548 20260105054928_YUwDj UK0088 2026-01-06T14:13:59.956Z 2026-01-13T15:14:48.830Z
9151172 9151172 20260105044826_bh0M0 UK0088 2026-01-06T14:12:50.764Z 2026-01-13T15:14:29.924Z
9151020 9151020 20260105042201_HHbrV UK0088 2026-01-06T14:12:21.580Z 2026-01-13T15:14:14.197Z
9150846 9150846 20260105034042_QTM2O UK0088 2026-01-06T14:11:38.876Z 2026-01-13T15:14:04.193Z
9150563 9150563 20260105024557_KWWOT UK0088 2026-01-06T14:10:30.737Z 2026-01-13T15:13:41.700Z
9150506 9150506 20260105023409_5CAxy UK0088 2026-01-06T14:10:16.291Z 2026-01-13T15:13:36.380Z
9150479 9150479 20260105022155_S27Rw UK0088 2026-01-06T14:10:11.675Z 2026-01-13T15:13:35.036Z
9150461 9150461 20260105021928_PaCY5 UK0088 2026-01-06T14:10:09.176Z 2026-01-13T15:13:34.181Z
9150424 9150424 20260105021102_0h0OA UK0088 2026-01-06T14:09:58.766Z 2026-01-13T15:13:32.077Z
9150058 9150058 20260105004441_ikkKK UK0088 2026-01-06T14:08:22.709Z 2026-01-13T15:12:53.985Z
9146258 9146258 20260104034235_AmhLa UK0088 2026-01-05T14:22:02.735Z 2026-01-12T15:08:23.969Z

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