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

5,979 rows where station_code = "UK007U" 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
9609209 9609209 20260405035832_ji2qv UK007U 2026-04-06T12:00:42.880Z 2026-04-06T12:00:42.880Z
9609106 9609106 20260405033451_rrgDA UK007U 2026-04-06T12:00:16.481Z 2026-04-06T12:00:16.481Z
9600853 9600853 20260401040100_cMrEw UK007U 2026-04-02T12:00:38.269Z 2026-04-06T12:24:17.255Z
9600849 9600849 20260401035712_r9YxR UK007U 2026-04-02T12:00:36.232Z 2026-04-06T12:24:16.751Z
9600837 9600837 20260401033831_Y7q08 UK007U 2026-04-02T12:00:32.464Z 2026-04-06T12:24:13.020Z
9600833 9600833 20260401033747_9wgY5 UK007U 2026-04-02T12:00:31.482Z 2026-04-06T12:24:12.654Z
9600782 9600782 20260401025155_HQCdj UK007U 2026-04-02T12:00:15.947Z 2026-04-06T12:24:08.974Z
9595499 9595499 20260330042247_2tlzY UK007U 2026-03-31T12:01:35.699Z 2026-04-06T12:30:06.523Z
9595391 9595391 20260330034817_uitvy UK007U 2026-03-31T12:01:15.722Z 2026-04-06T12:30:00.431Z
9595349 9595349 20260330034609_cDtVb UK007U 2026-03-31T12:01:12.030Z 2026-04-06T12:29:59.056Z
9595247 9595247 20260330030826_ednWw UK007U 2026-03-31T12:00:52.682Z 2026-04-06T12:29:49.726Z
9594363 9594363 20260328214926_dAST3 UK007U 2026-03-30T12:09:23.559Z 2026-04-06T12:39:49.459Z
9594278 9594278 20260328205901_JLBiI UK007U 2026-03-30T12:09:11.539Z 2026-04-06T12:39:46.091Z
9592980 9592980 20260329040850_6yRg7 UK007U 2026-03-30T12:02:29.988Z 2026-04-06T12:34:43.396Z
9592614 9592614 20260329024726_pm2hD UK007U 2026-03-30T12:01:26.701Z 2026-04-06T12:34:17.964Z
9592384 9592384 20260329015937_nK405 UK007U 2026-03-30T12:00:51.299Z 2026-04-06T12:34:08.723Z
9592340 9592340 20260329015637_KVxci UK007U 2026-03-30T12:00:44.406Z 2026-04-06T12:34:01.555Z
9589829 9589829 20260328041052_Y9CFb UK007U 2026-03-29T12:01:39.505Z 2026-04-06T12:37:35.804Z
9589281 9589281 20260328030552_7fQAJ UK007U 2026-03-29T12:01:02.048Z 2026-04-06T12:37:11.032Z
9589256 9589256 20260328030225_Wf1Uo UK007U 2026-03-29T12:00:59.739Z 2026-04-06T12:37:10.118Z
9585117 9585117 20260325233236_cowHx UK007U 2026-03-27T12:16:46.705Z 2026-04-03T12:39:50.028Z
9581726 9581726 20260326035326_vn6Hn UK007U 2026-03-27T12:03:45.839Z 2026-04-04T12:39:17.221Z
9581470 9581470 20260326031617_46F3t UK007U 2026-03-27T12:03:12.295Z 2026-04-04T12:39:07.316Z
9581451 9581451 20260326031446_o0HWz UK007U 2026-03-27T12:03:10.095Z 2026-04-04T12:39:06.584Z
9581375 9581375 20260326030104_tytl5 UK007U 2026-03-27T12:02:54.117Z 2026-04-04T12:38:54.697Z
9581263 9581263 20260326024455_KoNt3 UK007U 2026-03-27T12:02:34.775Z 2026-04-04T12:38:51.012Z
9581215 9581215 20260326023740_kSqBq UK007U 2026-03-27T12:02:25.086Z 2026-04-04T12:38:46.407Z
9581201 9581201 20260326023624_qmkxj UK007U 2026-03-27T12:02:21.843Z 2026-04-04T12:38:45.577Z
9581070 9581070 20260326022027_enCu2 UK007U 2026-03-27T12:02:03.759Z 2026-04-04T12:38:41.505Z
9580999 9580999 20260326020802_CgEyr UK007U 2026-03-27T12:01:52.379Z 2026-04-04T12:38:38.914Z
9580982 9580982 20260326020253_aHjcG UK007U 2026-03-27T12:01:48.602Z 2026-04-04T12:38:37.576Z
9580863 9580863 20260326014801_J51nm UK007U 2026-03-27T12:01:36.282Z 2026-04-04T12:38:31.620Z
9580714 9580714 20260326012133_Hm285 UK007U 2026-03-27T12:01:14.261Z 2026-04-04T12:38:21.397Z
9580487 9580487 20260326005524_l1kWK UK007U 2026-03-27T12:00:36.777Z 2026-04-04T12:38:12.049Z
9580153 9580153 20260325001307_2aDfr UK007U 2026-03-26T12:15:11.020Z 2026-04-02T12:37:44.096Z
9576852 9576852 20260325031656_WArMS UK007U 2026-03-26T12:03:30.023Z 2026-04-03T12:36:23.668Z
9576810 9576810 20260325031252_aOmgq UK007U 2026-03-26T12:03:22.265Z 2026-04-03T12:36:21.920Z
9576568 9576568 20260325023439_Vf37I UK007U 2026-03-26T12:02:38.549Z 2026-04-03T12:36:12.784Z
9576551 9576551 20260325023110_8VIh6 UK007U 2026-03-26T12:02:35.948Z 2026-04-03T12:36:12.331Z
9576066 9576066 20260325010856_06yUV UK007U 2026-03-26T12:01:10.771Z 2026-04-03T12:35:42.995Z
9576043 9576043 20260325010420_5fk0j UK007U 2026-03-26T12:01:05.586Z 2026-04-03T12:35:42.229Z
9575814 9575814 20260325002103_k2NyJ UK007U 2026-03-26T12:00:17.739Z 2026-04-03T12:35:23.230Z
9562723 9562723 20260323030535_lOy0I UK007U 2026-03-24T12:03:51.509Z 2026-03-31T12:26:24.090Z
9562550 9562550 20260323023200_xS1Uy UK007U 2026-03-24T12:03:23.405Z 2026-03-31T12:26:13.885Z
9562515 9562515 20260323022733_nPM7G UK007U 2026-03-24T12:03:18.157Z 2026-03-31T12:26:13.282Z
9562505 9562505 20260323022616_USxVe UK007U 2026-03-24T12:03:17.255Z 2026-03-31T12:26:13.136Z
9561977 9561977 20260323010557_4Yxyi UK007U 2026-03-24T12:01:44.601Z 2026-03-31T12:25:57.879Z
9561168 9561168 20260321230424_S3ZIX UK007U 2026-03-23T12:12:12.726Z 2026-03-29T12:21:05.430Z
9560956 9560956 20260321223916_oekKm UK007U 2026-03-23T12:12:08.425Z 2026-03-29T12:21:04.174Z
9560231 9560231 20260321204918_HjP3E UK007U 2026-03-23T12:11:40.463Z 2026-03-29T12:20:58.710Z
9560203 9560203 20260321204652_YRSEA UK007U 2026-03-23T12:11:40.182Z 2026-03-29T12:20:58.556Z
9554666 9554666 20260322032353_gKlQC UK007U 2026-03-23T12:02:45.050Z 2026-03-30T12:28:06.982Z
9553649 9553649 20260322020408_QC4Gf UK007U 2026-03-23T12:01:44.563Z 2026-03-30T12:27:50.601Z
9553189 9553189 20260322012339_lUY3w UK007U 2026-03-23T12:01:18.693Z 2026-03-30T12:27:36.222Z
9553048 9553048 20260322010753_4jevh UK007U 2026-03-23T12:01:10.617Z 2026-03-30T12:27:34.100Z
9552807 9552807 20260322004501_fWHtP UK007U 2026-03-23T12:00:53.112Z 2026-03-30T12:27:30.672Z
9551412 9551412 20260320194318_Q2wym UK007U 2026-03-22T12:26:38.836Z 2026-03-28T12:36:50.918Z
9542250 9542250 20260319230513_KYSvI UK007U 2026-03-21T12:29:53.933Z 2026-03-27T12:42:51.429Z
9534143 9534143 20260320033037_rtDrT UK007U 2026-03-21T12:07:15.620Z 2026-03-28T12:34:14.795Z
9534003 9534003 20260320031707_eVajr UK007U 2026-03-21T12:06:53.270Z 2026-03-28T12:34:03.505Z
9533558 9533558 20260320024302_t0F82 UK007U 2026-03-21T12:05:44.060Z 2026-03-28T12:33:56.015Z
9533515 9533515 20260320023606_9QPqJ UK007U 2026-03-21T12:05:34.413Z 2026-03-28T12:33:54.242Z
9533122 9533122 20260320020328_2scFY UK007U 2026-03-21T12:04:31.648Z 2026-03-28T12:33:49.068Z
9532301 9532301 20260320004426_8Hx9S UK007U 2026-03-21T12:02:19.157Z 2026-03-28T12:33:27.285Z
9531996 9531996 20260320000706_Tx6BV UK007U 2026-03-21T12:01:23.238Z 2026-03-28T12:33:23.570Z
9531668 9531668 20260319233450_hcrxd UK007U 2026-03-21T12:00:27.078Z 2026-03-28T12:33:19.963Z
9531421 9531421 20260318230759_tX12m UK007U 2026-03-20T12:25:10.110Z 2026-03-26T12:39:19.290Z
9531039 9531039 20260318222044_MEnh0 UK007U 2026-03-20T12:24:55.409Z 2026-03-26T12:39:17.136Z
9530711 9530711 20260318213114_0IHp3 UK007U 2026-03-20T12:24:36.892Z 2026-03-26T12:39:15.002Z
9521523 9521523 20260319042500_ZrtfM UK007U 2026-03-20T12:08:10.347Z 2026-03-27T12:40:55.459Z
9521349 9521349 20260319040806_vAt1S UK007U 2026-03-20T12:07:52.446Z 2026-03-27T12:40:54.020Z
9520760 9520760 20260319033518_B8jBA UK007U 2026-03-20T12:06:56.069Z 2026-03-27T12:40:47.147Z
9520419 9520419 20260319031434_jSaIP UK007U 2026-03-20T12:06:21.800Z 2026-03-27T12:40:42.824Z
9518533 9518533 20260319010630_eI1u0 UK007U 2026-03-20T12:02:46.583Z 2026-03-27T12:40:11.159Z
9518508 9518508 20260319010529_kpPAT UK007U 2026-03-20T12:02:44.126Z 2026-03-27T12:40:10.810Z
9517732 9517732 20260318235926_4EAcs UK007U 2026-03-20T12:01:08.898Z 2026-03-27T12:40:02.784Z
9517277 9517277 20260317230149_J3vqJ UK007U 2026-03-19T12:27:24.670Z 2026-03-25T12:43:09.807Z
9516757 9516757 20260317215345_AN1t2 UK007U 2026-03-19T12:26:45.044Z 2026-03-25T12:43:06.730Z
9516518 9516518 20260317210453_0Q2Uf UK007U 2026-03-19T12:26:19.422Z 2026-03-25T12:43:00.408Z
9516508 9516508 20260317210237_mbPNX UK007U 2026-03-19T12:26:18.923Z 2026-03-25T12:43:00.274Z
9512127 9512127 20260318044530_ZL0M3 UK007U 2026-03-19T12:11:46.006Z 2026-03-26T12:37:42.561Z
9511684 9511684 20260318040919_iMhJr UK007U 2026-03-19T12:10:45.135Z 2026-03-26T12:37:38.870Z
9511500 9511500 20260318035655_68VZG UK007U 2026-03-19T12:10:20.953Z 2026-03-26T12:37:37.456Z
9511200 9511200 20260318034002_3asMD UK007U 2026-03-19T12:09:39.100Z 2026-03-26T12:37:26.927Z
9511196 9511196 20260318034002_aYKwF UK007U 2026-03-19T12:09:38.765Z 2026-03-26T12:37:26.846Z
9510302 9510302 20260318024257_zSgYN UK007U 2026-03-19T12:07:18.682Z 2026-03-26T12:37:11.454Z
9508729 9508729 20260318010815_PU42n UK007U 2026-03-19T12:03:42.124Z 2026-03-26T12:37:00.425Z
9508432 9508432 20260318005351_Wk7as UK007U 2026-03-19T12:03:04.826Z 2026-03-26T12:36:58.426Z
9508430 9508430 20260318005351_eF2pa UK007U 2026-03-19T12:03:04.575Z 2026-03-26T12:36:58.408Z
9508243 9508243 20260318003608_PPrmm UK007U 2026-03-19T12:02:42.161Z 2026-03-26T12:36:57.191Z
9508119 9508119 20260318001858_9sOh3 UK007U 2026-03-19T12:02:17.913Z 2026-03-26T12:36:56.016Z
9494245 9494245 20260316014453_kaX7w UK007U 2026-03-17T12:03:26.140Z 2026-03-24T12:40:46.174Z
9494071 9494071 20260316012255_AIOIz UK007U 2026-03-17T12:02:55.084Z 2026-03-24T12:40:44.307Z
9494036 9494036 20260316011524_R9lA0 UK007U 2026-03-17T12:02:50.391Z 2026-03-24T12:40:44.163Z
9493409 9493409 20260315232711_eENzt UK007U 2026-03-17T12:00:45.424Z 2026-03-24T12:40:39.519Z
9492536 9492536 20260314211221_kd6k8 UK007U 2026-03-16T12:28:40.699Z 2026-03-22T12:42:52.881Z
9492465 9492465 20260314205545_56ZQY UK007U 2026-03-16T12:28:35.849Z 2026-03-22T12:42:52.499Z
9492251 9492251 20260314195148_BBbZM UK007U 2026-03-16T12:28:13.045Z 2026-03-22T12:42:51.215Z
9492219 9492219 20260314194153_gYs6d UK007U 2026-03-16T12:28:09.083Z 2026-03-22T12:42:50.843Z
9492136 9492136 20260314192726_VvRv3 UK007U 2026-03-16T12:28:04.205Z 2026-03-22T12:42:50.437Z

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