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

1,134 rows where station_code = "UK00BQ" 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
8681090 8681090 20251203022125_5T8qG UK00BQ 2025-12-04T14:13:49.113Z 2025-12-06T14:27:48.858Z
8680442 8680442 20251202235926_sSsXW UK00BQ 2025-12-04T14:12:00.435Z 2025-12-06T14:27:11.982Z
8680380 8680380 20251202234016_qX4eL UK00BQ 2025-12-04T14:11:53.812Z 2025-12-06T14:27:10.232Z
8680174 8680174 20251202220720_MZugi UK00BQ 2025-12-04T14:11:21.014Z 2025-12-06T14:26:53.809Z
8680104 8680104 20251202213515_8eyk8 UK00BQ 2025-12-04T14:11:04.544Z 2025-12-06T14:26:50.667Z
8679979 8679979 20251202211318_fTW4Y UK00BQ 2025-12-04T14:10:50.364Z 2025-12-06T14:26:46.023Z
8676368 8676368 20251202054947_N0G4M UK00BQ 2025-12-03T14:25:09.529Z 2025-12-06T14:35:20.753Z
8676321 8676321 20251202054545_314Qg UK00BQ 2025-12-03T14:25:06.145Z 2025-12-06T14:35:20.159Z
8676220 8676220 20251202054219_2KqKt UK00BQ 2025-12-03T14:24:49.774Z 2025-12-06T14:35:18.989Z
8676137 8676137 20251202053845_4Py0l UK00BQ 2025-12-03T14:24:46.567Z 2025-12-06T14:35:17.059Z
8676074 8676074 20251202053451_XJvfn UK00BQ 2025-12-03T14:24:40.000Z 2025-12-06T14:35:07.678Z
8661900 8661900 20251130173013_3GTHD UK00BQ 2025-12-02T14:13:34.185Z 2025-12-06T14:38:41.472Z
8654135 8654135 20251130030000_2HcR7 UK00BQ 2025-12-01T14:24:53.956Z 2025-12-06T14:48:38.001Z
8654128 8654128 20251130025958_Xm0PE UK00BQ 2025-12-01T14:24:53.640Z 2025-12-06T14:48:37.936Z
8654019 8654019 20251130025159_Lgilc UK00BQ 2025-12-01T14:24:44.629Z 2025-12-06T14:48:35.969Z
8648672 8648672 20251128045627_zgJIp UK00BQ 2025-11-30T14:37:54.201Z 2025-12-06T15:03:56.190Z
8637761 8637761 20251128063137_vwgcA UK00BQ 2025-11-29T14:27:48.428Z 2025-12-06T15:04:03.899Z
8637723 8637723 20251128062359_kwG5w UK00BQ 2025-11-29T14:27:46.219Z 2025-12-06T15:04:03.387Z
8637643 8637643 20251128060421_l9NzO UK00BQ 2025-11-29T14:27:39.351Z 2025-12-06T15:04:02.011Z
8637411 8637411 20251128053813_xEaEH UK00BQ 2025-11-29T14:27:13.049Z 2025-12-06T15:03:59.833Z
8637374 8637374 20251128053409_CuLPc UK00BQ 2025-11-29T14:27:10.317Z 2025-12-06T15:03:59.392Z
8637372 8637372 20251128053345_RE4sZ UK00BQ 2025-11-29T14:27:07.257Z 2025-12-06T15:03:59.372Z
8636973 8636973 20251128044249_XKNk5 UK00BQ 2025-11-29T14:26:28.687Z 2025-12-06T15:03:53.359Z
8636430 8636430 20251128034437_D6mSq UK00BQ 2025-11-29T14:25:29.695Z 2025-12-06T15:03:18.270Z
8635707 8635707 20251128023959_ayvhI UK00BQ 2025-11-29T14:24:02.616Z 2025-12-06T15:02:49.109Z
8635524 8635524 20251128022239_6933H UK00BQ 2025-11-29T14:23:34.686Z 2025-12-06T15:02:45.977Z
8633932 8633932 20251128000724_QvS7l UK00BQ 2025-11-29T14:20:31.904Z 2025-12-06T15:01:49.779Z
8633406 8633406 20251127231406_pYFF3 UK00BQ 2025-11-29T14:19:41.211Z 2025-12-06T15:01:43.589Z
8633404 8633404 20251127231344_pNL1M UK00BQ 2025-11-29T14:19:41.076Z 2025-12-06T15:01:43.549Z
8633087 8633087 20251127223731_H2LHv UK00BQ 2025-11-29T14:18:57.776Z 2025-12-06T15:01:39.787Z
8633058 8633058 20251127223348_wcTgw UK00BQ 2025-11-29T14:18:55.321Z 2025-12-06T15:01:39.429Z
8632997 8632997 20251127222706_5zOJH UK00BQ 2025-11-29T14:18:47.492Z 2025-12-06T15:01:36.948Z
8632974 8632974 20251127222327_xAvxT UK00BQ 2025-11-29T14:18:37.394Z 2025-12-06T15:01:36.338Z
8632910 8632910 20251127221747_Cny20 UK00BQ 2025-11-29T14:18:34.182Z 2025-12-06T15:01:35.511Z
8632611 8632611 20251127212539_N9yrJ UK00BQ 2025-11-29T14:17:51.379Z 2025-12-06T15:01:31.403Z
8632194 8632194 20251127203950_nBL4d UK00BQ 2025-11-29T14:17:06.361Z 2025-12-06T15:00:58.640Z
8631993 8631993 20251127201821_bf0en UK00BQ 2025-11-29T14:16:38.989Z 2025-12-06T15:00:49.199Z
8631624 8631624 20251127193521_stnNi UK00BQ 2025-11-29T14:15:52.154Z 2025-12-06T15:00:29.147Z
8615073 8615073 20251126044433_olmlo UK00BQ 2025-11-27T14:28:58.462Z 2025-12-04T15:11:25.773Z
8614820 8614820 20251126043004_mTfbn UK00BQ 2025-11-27T14:28:35.100Z 2025-12-04T15:11:12.844Z
8614761 8614761 20251126042546_k3HeM UK00BQ 2025-11-27T14:28:31.284Z 2025-12-04T15:11:05.856Z
8614336 8614336 20251126040605_lN8Ya UK00BQ 2025-11-27T14:27:47.771Z 2025-12-04T15:10:37.976Z
8614298 8614298 20251126040253_m4XJu UK00BQ 2025-11-27T14:27:44.957Z 2025-12-04T15:10:34.593Z
8613851 8613851 20251126033728_zQZrb UK00BQ 2025-11-27T14:26:51.884Z 2025-12-04T15:09:52.666Z
8613723 8613723 20251126033140_wLb2g UK00BQ 2025-11-27T14:26:27.785Z 2025-12-04T15:09:51.264Z
8613711 8613711 20251126033121_Lp2kR UK00BQ 2025-11-27T14:26:27.201Z 2025-12-04T15:09:51.187Z
8613630 8613630 20251126032645_Vc2X5 UK00BQ 2025-11-27T14:26:19.265Z 2025-12-04T15:09:49.989Z
8613626 8613626 20251126032644_KrURW UK00BQ 2025-11-27T14:26:18.890Z 2025-12-04T15:09:49.969Z
8613246 8613246 20251126031202_DrGx0 UK00BQ 2025-11-27T14:25:35.125Z 2025-12-04T15:09:39.256Z
8612864 8612864 20251126025251_KmuS9 UK00BQ 2025-11-27T14:24:56.103Z 2025-12-04T15:09:35.287Z
8612755 8612755 20251126024400_n1n6t UK00BQ 2025-11-27T14:24:35.990Z 2025-12-04T15:09:33.576Z
8612557 8612557 20251126023753_tRSCe UK00BQ 2025-11-27T14:24:22.046Z 2025-12-04T15:09:31.968Z
8612499 8612499 20251126023336_WgB4H UK00BQ 2025-11-27T14:24:16.297Z 2025-12-04T15:09:31.199Z
8612277 8612277 20251126022420_372Yd UK00BQ 2025-11-27T14:23:42.966Z 2025-12-04T15:09:28.941Z
8612262 8612262 20251126022351_Z0Bgg UK00BQ 2025-11-27T14:23:41.847Z 2025-12-04T15:09:28.764Z
8611955 8611955 20251126021006_1BCwa UK00BQ 2025-11-27T14:23:06.935Z 2025-12-04T15:09:26.131Z
8611872 8611872 20251126020407_VNnPd UK00BQ 2025-11-27T14:23:00.355Z 2025-12-04T15:09:25.042Z
8611649 8611649 20251126015347_0PjEC UK00BQ 2025-11-27T14:22:23.553Z 2025-12-04T15:09:23.053Z
8609890 8609890 20251126001200_Px7OH UK00BQ 2025-11-27T14:19:04.129Z 2025-12-04T15:07:58.014Z
8609741 8609741 20251126000205_dIJdm UK00BQ 2025-11-27T14:18:53.753Z 2025-12-04T15:07:56.968Z
8609739 8609739 20251126000148_2Gmgq UK00BQ 2025-11-27T14:18:53.160Z 2025-12-04T15:07:56.941Z
8608707 8608707 20251125223633_16Tjc UK00BQ 2025-11-27T14:16:33.811Z 2025-12-04T15:07:47.866Z
8608073 8608073 20251125214741_tADyf UK00BQ 2025-11-27T14:15:11.573Z 2025-12-04T15:07:40.822Z
8608069 8608069 20251125214645_bA3Ln UK00BQ 2025-11-27T14:15:10.984Z 2025-12-04T15:07:40.749Z
8607778 8607778 20251125212013_vdBob UK00BQ 2025-11-27T14:14:28.279Z 2025-12-04T15:07:29.651Z
8607316 8607316 20251125203832_m2w30 UK00BQ 2025-11-27T14:13:13.102Z 2025-12-04T15:07:00.182Z
8607095 8607095 20251125201142_mDp13 UK00BQ 2025-11-27T14:12:23.005Z 2025-12-04T15:06:54.570Z
8606762 8606762 20251125193754_yYoxq UK00BQ 2025-11-27T14:11:18.374Z 2025-12-04T15:06:49.941Z
8606324 8606324 20251125183610_AzBxy UK00BQ 2025-11-27T14:09:51.756Z 2025-12-04T15:06:44.006Z
8605823 8605823 20251125172000_328Gf UK00BQ 2025-11-27T14:08:02.942Z 2025-12-04T15:05:45.322Z
8603786 8603786 20251125064005_RNC56 UK00BQ 2025-11-26T14:27:59.256Z 2025-12-02T15:09:37.469Z
8602944 8602944 20251125053446_hAxO2 UK00BQ 2025-11-26T14:26:29.608Z 2025-12-02T15:09:33.625Z
8602391 8602391 20251125045356_WN50T UK00BQ 2025-11-26T14:25:36.585Z 2025-12-02T15:09:30.747Z
8602070 8602070 20251125043535_VqeIa UK00BQ 2025-11-26T14:25:19.738Z 2025-12-02T15:09:29.367Z
8601545 8601545 20251125035440_Yyh4H UK00BQ 2025-11-26T14:24:25.375Z 2025-12-02T15:09:12.019Z
8600814 8600814 20251125031751_kRJSw UK00BQ 2025-11-26T14:22:59.165Z 2025-12-02T15:08:50.752Z
8600716 8600716 20251125031430_5Vupm UK00BQ 2025-11-26T14:22:55.212Z 2025-12-02T15:08:49.839Z
8600377 8600377 20251125025517_90Vrn UK00BQ 2025-11-26T14:22:24.429Z 2025-12-02T15:08:41.700Z
8599488 8599488 20251125020750_XtxWi UK00BQ 2025-11-26T14:21:09.687Z 2025-12-02T15:08:27.047Z
8599451 8599451 20251125020628_Ic0ca UK00BQ 2025-11-26T14:20:56.228Z 2025-12-02T15:08:23.895Z
8599077 8599077 20251125014320_7XBF5 UK00BQ 2025-11-26T14:20:16.700Z 2025-12-02T15:08:19.722Z
8598423 8598423 20251125005618_yx0Uq UK00BQ 2025-11-26T14:18:48.450Z 2025-12-02T15:07:54.023Z
8598135 8598135 20251125003621_FjM97 UK00BQ 2025-11-26T14:18:20.567Z 2025-12-02T15:07:46.846Z
8597627 8597627 20251124235321_vMCZ4 UK00BQ 2025-11-26T14:17:13.194Z 2025-12-02T15:07:38.246Z
8597168 8597168 20251124230946_joay9 UK00BQ 2025-11-26T14:16:18.248Z 2025-12-02T15:07:23.821Z
8596888 8596888 20251124222335_LMhr4 UK00BQ 2025-11-26T14:15:42.169Z 2025-12-02T15:07:17.221Z
8592132 8592132 20251124055214_0YT70 UK00BQ 2025-11-25T14:25:55.462Z 2025-12-02T15:13:01.976Z
8579294 8579294 20251122230609_pfLBs UK00BQ 2025-11-24T14:13:56.916Z 2025-12-01T15:20:13.661Z
8578806 8578806 20251122212858_plqPA UK00BQ 2025-11-24T14:12:43.699Z 2025-12-01T15:19:53.165Z
8578799 8578799 20251122212738_x38kU UK00BQ 2025-11-24T14:12:42.374Z 2025-12-01T15:19:53.100Z
8578658 8578658 20251122210633_tmjMH UK00BQ 2025-11-24T14:12:17.039Z 2025-12-01T15:19:49.439Z
8578561 8578561 20251122205233_PF2FQ UK00BQ 2025-11-24T14:12:06.136Z 2025-12-01T15:19:48.251Z
8577931 8577931 20251122191236_DspJV UK00BQ 2025-11-24T14:10:12.033Z 2025-12-01T15:19:03.392Z
8569896 8569896 20251121062453_96iNI UK00BQ 2025-11-23T14:32:48.887Z 2025-11-29T14:54:49.811Z
8569355 8569355 20251121055427_vnvbr UK00BQ 2025-11-23T14:32:11.897Z 2025-11-29T14:54:48.183Z
8569062 8569062 20251121054447_n1IoZ UK00BQ 2025-11-23T14:31:53.096Z 2025-11-29T14:54:47.730Z
8568655 8568655 20251121052833_eL7IP UK00BQ 2025-11-23T14:31:17.792Z 2025-11-29T14:54:47.156Z
8568597 8568597 20251121052657_ZrWns UK00BQ 2025-11-23T14:31:15.366Z 2025-11-29T14:54:47.071Z
8568096 8568096 20251121050129_yYT45 UK00BQ 2025-11-23T14:30:52.096Z 2025-11-29T14:54:46.071Z
8567955 8567955 20251121043347_SQJen UK00BQ 2025-11-23T14:29:44.375Z 2025-11-29T14:54:44.864Z

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