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,114 rows where station_code = "UK00DH" 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
8690751 8690751 20251205014058_ZNTgE UK00DH 2025-12-06T14:15:23.187Z 2025-12-06T14:18:00.953Z
8689939 8689939 20251204184922_3mVmA UK00DH 2025-12-06T14:12:37.158Z 2025-12-06T14:18:00.765Z
8689924 8689924 20251204183210_vCVX4 UK00DH 2025-12-06T14:12:35.168Z 2025-12-06T14:18:00.759Z
8689915 8689915 20251204183058_fsEeh UK00DH 2025-12-06T14:12:32.937Z 2025-12-06T14:18:00.758Z
8689891 8689891 20251204175301_ARHl7 UK00DH 2025-12-06T14:12:27.602Z 2025-12-06T14:18:00.748Z
8683222 8683222 20251203064314_FpBCE UK00DH 2025-12-04T14:18:57.477Z 2025-12-06T14:29:46.603Z
8683148 8683148 20251203063337_Tapz2 UK00DH 2025-12-04T14:18:38.667Z 2025-12-06T14:29:42.950Z
8683076 8683076 20251203062502_WrQew UK00DH 2025-12-04T14:18:32.795Z 2025-12-06T14:29:41.126Z
8683071 8683071 20251203062422_TyjnK UK00DH 2025-12-04T14:18:32.149Z 2025-12-06T14:29:41.009Z
8683031 8683031 20251203061855_lab8K UK00DH 2025-12-04T14:18:27.106Z 2025-12-06T14:29:39.236Z
8682960 8682960 20251203061700_TDsgd UK00DH 2025-12-04T14:18:23.853Z 2025-12-06T14:29:33.609Z
8682916 8682916 20251203061601_Q7kvR UK00DH 2025-12-04T14:18:20.507Z 2025-12-06T14:29:31.813Z
8682883 8682883 20251203061259_ybsdp UK00DH 2025-12-04T14:18:11.340Z 2025-12-06T14:29:30.244Z
8682781 8682781 20251203060249_3Bvti UK00DH 2025-12-04T14:18:00.166Z 2025-12-06T14:29:24.878Z
8682397 8682397 20251203052443_Mi02K UK00DH 2025-12-04T14:17:05.492Z 2025-12-06T14:28:58.418Z
8682366 8682366 20251203052123_GuRKx UK00DH 2025-12-04T14:17:01.228Z 2025-12-06T14:28:56.358Z
8682314 8682314 20251203051538_yalU1 UK00DH 2025-12-04T14:16:48.249Z 2025-12-06T14:28:54.115Z
8682288 8682288 20251203051053_30b2M UK00DH 2025-12-04T14:16:44.009Z 2025-12-06T14:28:52.414Z
8682266 8682266 20251203050740_LBrNP UK00DH 2025-12-04T14:16:42.173Z 2025-12-06T14:28:51.464Z
8682260 8682260 20251203050730_exemh UK00DH 2025-12-04T14:16:41.538Z 2025-12-06T14:28:51.199Z
8682167 8682167 20251203045618_nk6Z2 UK00DH 2025-12-04T14:16:32.140Z 2025-12-06T14:28:48.330Z
8682091 8682091 20251203044749_ZhTZU UK00DH 2025-12-04T14:16:25.064Z 2025-12-06T14:28:45.977Z
8682028 8682028 20251203044152_2eMPE UK00DH 2025-12-04T14:16:14.646Z 2025-12-06T14:28:44.263Z
8682014 8682014 20251203044109_4G6t2 UK00DH 2025-12-04T14:16:10.242Z 2025-12-06T14:28:43.297Z
8681971 8681971 20251203043415_sSiPh UK00DH 2025-12-04T14:16:04.450Z 2025-12-06T14:28:41.442Z
8681962 8681962 20251203043348_dI3i0 UK00DH 2025-12-04T14:16:03.879Z 2025-12-06T14:28:41.211Z
8681956 8681956 20251203043347_1U0is UK00DH 2025-12-04T14:16:03.402Z 2025-12-06T14:28:41.102Z
8681808 8681808 20251203040912_zxa5A UK00DH 2025-12-04T14:15:38.986Z 2025-12-06T14:28:32.003Z
8681451 8681451 20251203031203_muCHB UK00DH 2025-12-04T14:14:44.474Z 2025-12-06T14:28:11.501Z
8681043 8681043 20251203021619_lCIfc UK00DH 2025-12-04T14:13:38.303Z 2025-12-06T14:27:47.288Z
8681032 8681032 20251203021400_dfWAJ UK00DH 2025-12-04T14:13:34.442Z 2025-12-06T14:27:46.844Z
8680626 8680626 20251203004848_23q9l UK00DH 2025-12-04T14:12:29.539Z 2025-12-06T14:27:20.237Z
8676472 8676472 20251202055341_ruDut UK00DH 2025-12-03T14:25:13.513Z 2025-12-06T14:35:22.043Z
8675865 8675865 20251202051859_Op3qC UK00DH 2025-12-03T14:24:26.545Z 2025-12-06T14:35:03.506Z
8675832 8675832 20251202051700_kiRfK UK00DH 2025-12-03T14:24:21.352Z 2025-12-06T14:35:01.232Z
8675782 8675782 20251202051410_c0ChF UK00DH 2025-12-03T14:24:14.919Z 2025-12-06T14:34:59.769Z
8675768 8675768 20251202051247_kJqhV UK00DH 2025-12-03T14:24:14.301Z 2025-12-06T14:34:59.617Z
8675476 8675476 20251202044420_to6Ji UK00DH 2025-12-03T14:23:45.391Z 2025-12-06T14:34:53.887Z
8675363 8675363 20251202043132_w7ZIK UK00DH 2025-12-03T14:23:33.657Z 2025-12-06T14:34:50.304Z
8675325 8675325 20251202042822_zF1OH UK00DH 2025-12-03T14:23:30.982Z 2025-12-06T14:34:49.411Z
8675228 8675228 20251202042009_EPGT9 UK00DH 2025-12-03T14:23:22.208Z 2025-12-06T14:34:47.619Z
8675147 8675147 20251202040541_3YLgJ UK00DH 2025-12-03T14:23:07.437Z 2025-12-06T14:34:35.792Z
8675087 8675087 20251202040004_1kj3S UK00DH 2025-12-03T14:23:01.180Z 2025-12-06T14:34:28.814Z
8674811 8674811 20251202032749_WIOGH UK00DH 2025-12-03T14:22:26.503Z 2025-12-06T14:34:19.595Z
8674723 8674723 20251202031132_hs5M3 UK00DH 2025-12-03T14:22:15.020Z 2025-12-06T14:34:16.719Z
8674682 8674682 20251202030653_G3pzT UK00DH 2025-12-03T14:22:12.245Z 2025-12-06T14:34:15.401Z
8674600 8674600 20251202025700_IpVFE UK00DH 2025-12-03T14:22:06.656Z 2025-12-06T14:34:13.438Z
8674479 8674479 20251202023152_1fI2d UK00DH 2025-12-03T14:21:40.974Z 2025-12-06T14:34:09.942Z
8674469 8674469 20251202023141_pNMMd UK00DH 2025-12-03T14:21:40.817Z 2025-12-06T14:34:09.902Z
8674313 8674313 20251202015812_ogGZp UK00DH 2025-12-03T14:21:22.894Z 2025-12-06T14:34:03.589Z
8674245 8674245 20251202015312_pHR02 UK00DH 2025-12-03T14:21:16.929Z 2025-12-06T14:34:02.366Z
8674204 8674204 20251202014536_XYICU UK00DH 2025-12-03T14:21:09.124Z 2025-12-06T14:34:01.235Z
8674181 8674181 20251202014340_YkC0A UK00DH 2025-12-03T14:21:07.718Z 2025-12-06T14:34:00.626Z
8674158 8674158 20251202013721_L6SpO UK00DH 2025-12-03T14:21:02.686Z 2025-12-06T14:34:00.089Z
8674152 8674152 20251202013605_1M2uR UK00DH 2025-12-03T14:21:00.989Z 2025-12-06T14:33:59.873Z
8674147 8674147 20251202013411_HRge4 UK00DH 2025-12-03T14:20:59.971Z 2025-12-06T14:33:59.594Z
8673925 8673925 20251202003610_0ka91 UK00DH 2025-12-03T14:20:23.631Z 2025-12-06T14:33:42.692Z
8673919 8673919 20251202002659_KF3Kx UK00DH 2025-12-03T14:20:20.890Z 2025-12-06T14:33:42.398Z
8673760 8673760 20251201224106_3cuak UK00DH 2025-12-03T14:19:59.032Z 2025-12-06T14:33:32.368Z
8658538 8658538 20251126033756_UvFcN UK00DH 2025-12-01T15:04:30.625Z 2025-12-04T15:09:52.943Z
8658526 8658526 20251126031221_XdlNm UK00DH 2025-12-01T15:04:16.323Z 2025-12-04T15:09:39.357Z
8658145 8658145 20251130065151_Yz7Ks UK00DH 2025-12-01T14:34:58.172Z 2025-12-06T14:50:27.719Z
8658063 8658063 20251130063254_ISE9l UK00DH 2025-12-01T14:34:53.076Z 2025-12-06T14:50:25.975Z
8657967 8657967 20251130062242_XZJ8T UK00DH 2025-12-01T14:34:47.705Z 2025-12-06T14:50:24.740Z
8657905 8657905 20251130061520_gY3iF UK00DH 2025-12-01T14:34:45.128Z 2025-12-06T14:50:23.672Z
8657799 8657799 20251130060842_NGTym UK00DH 2025-12-01T14:34:41.596Z 2025-12-06T14:50:22.680Z
8657736 8657736 20251130060405_xb680 UK00DH 2025-12-01T14:34:39.371Z 2025-12-06T14:50:22.051Z
8657663 8657663 20251130055628_qz2ZG UK00DH 2025-12-01T14:34:36.262Z 2025-12-06T14:50:16.775Z
8657643 8657643 20251130055554_4bhZm UK00DH 2025-12-01T14:34:35.595Z 2025-12-06T14:50:16.309Z
8657635 8657635 20251130055509_pMmVs UK00DH 2025-12-01T14:34:35.422Z 2025-12-06T14:50:16.160Z
8657624 8657624 20251130055451_vKoID UK00DH 2025-12-01T14:34:35.152Z 2025-12-06T14:50:16.038Z
8657325 8657325 20251130053841_iaHjT UK00DH 2025-12-01T14:34:04.315Z 2025-12-06T14:49:52.316Z
8656586 8656586 20251130050014_Z3ysx UK00DH 2025-12-01T14:28:45.953Z 2025-12-06T14:49:36.630Z
8655989 8655989 20251130042847_2j35z UK00DH 2025-12-01T14:27:43.493Z 2025-12-06T14:49:29.506Z
8655954 8655954 20251130042717_1byaU UK00DH 2025-12-01T14:27:41.856Z 2025-12-06T14:49:29.235Z
8655732 8655732 20251130041351_VOOUA UK00DH 2025-12-01T14:27:23.734Z 2025-12-06T14:49:26.902Z
8655538 8655538 20251130040641_WGfTZ UK00DH 2025-12-01T14:27:02.468Z 2025-12-06T14:49:24.975Z
8655416 8655416 20251130040130_cvDx4 UK00DH 2025-12-01T14:26:53.236Z 2025-12-06T14:49:14.999Z
8655225 8655225 20251130034916_Tx8xv UK00DH 2025-12-01T14:26:39.797Z 2025-12-06T14:48:53.784Z
8655160 8655160 20251130034624_vlJCt UK00DH 2025-12-01T14:26:35.966Z 2025-12-06T14:48:52.208Z
8655105 8655105 20251130034435_gH3bn UK00DH 2025-12-01T14:26:23.085Z 2025-12-06T14:48:51.465Z
8654982 8654982 20251130034005_ybsxo UK00DH 2025-12-01T14:26:13.872Z 2025-12-06T14:48:50.551Z
8654737 8654737 20251130032959_zMKYH UK00DH 2025-12-01T14:25:51.755Z 2025-12-06T14:48:47.476Z
8654609 8654609 20251130032225_KFfD3 UK00DH 2025-12-01T14:25:37.061Z 2025-12-06T14:48:44.687Z
8654555 8654555 20251130031954_ZDXcZ UK00DH 2025-12-01T14:25:34.444Z 2025-12-06T14:48:43.984Z
8654488 8654488 20251130031817_S5Epf UK00DH 2025-12-01T14:25:28.931Z 2025-12-06T14:48:43.200Z
8654479 8654479 20251130031747_TDET3 UK00DH 2025-12-01T14:25:27.224Z 2025-12-06T14:48:42.958Z
8654465 8654465 20251130031741_2bJ3E UK00DH 2025-12-01T14:25:26.878Z 2025-12-06T14:48:42.872Z
8654371 8654371 20251130031218_wSRxo UK00DH 2025-12-01T14:25:16.340Z 2025-12-06T14:48:41.198Z
8654304 8654304 20251130030858_T31rN UK00DH 2025-12-01T14:25:07.477Z 2025-12-06T14:48:40.381Z
8654302 8654302 20251130030857_G2f9e UK00DH 2025-12-01T14:25:07.117Z 2025-12-06T14:48:40.272Z
8654288 8654288 20251130030714_RJXRC UK00DH 2025-12-01T14:25:04.074Z 2025-12-06T14:48:39.753Z
8654275 8654275 20251130030706_bvFzu UK00DH 2025-12-01T14:25:03.706Z 2025-12-06T14:48:39.722Z
8654212 8654212 20251130030314_xihvI UK00DH 2025-12-01T14:24:57.789Z 2025-12-06T14:48:38.784Z
8654118 8654118 20251130025941_YAbUU UK00DH 2025-12-01T14:24:52.876Z 2025-12-06T14:48:37.857Z
8653928 8653928 20251130024816_QfCmd UK00DH 2025-12-01T14:24:29.967Z 2025-12-06T14:48:34.573Z
8653914 8653914 20251130024805_vUJ1S UK00DH 2025-12-01T14:24:28.615Z 2025-12-06T14:48:34.454Z
8653669 8653669 20251130023320_fb83X UK00DH 2025-12-01T14:23:54.246Z 2025-12-06T14:48:24.706Z
8653344 8653344 20251130021126_2ppAJ UK00DH 2025-12-01T14:23:15.600Z 2025-12-06T14:47:56.200Z
8653179 8653179 20251130020125_l3mxT UK00DH 2025-12-01T14:23:02.223Z 2025-12-06T14:47:51.131Z

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