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

2,912 rows where station_code = "UK004H" 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
9272899 9272899 20260128035850_h0dbG UK004H 2026-01-29T14:28:13.325Z 2026-01-29T14:30:25.705Z
9272269 9272269 20260128010754_J9l4b UK004H 2026-01-29T14:26:09.380Z 2026-01-29T14:30:25.318Z
9213086 9213086 20260116020854_b8C7l UK004H 2026-01-17T14:15:19.944Z 2026-01-24T15:11:40.059Z
9212889 9212889 20260116013453_79sV0 UK004H 2026-01-17T14:14:26.179Z 2026-01-24T15:11:32.579Z
9166636 9166636 20260107193357_tXyFs UK004H 2026-01-09T14:04:12.769Z 2026-01-16T15:10:07.902Z
9102783 9102783 20251230033353_2nVPo UK004H 2025-12-31T14:15:21.688Z 2026-01-07T15:08:06.005Z
9101074 9101074 20251229222747_lCFp6 UK004H 2025-12-31T14:06:25.035Z 2026-01-07T15:05:51.710Z
9058860 9058860 20251227062200_rEYrF UK004H 2025-12-29T14:25:25.958Z 2026-01-04T15:30:34.046Z
9056893 9056893 20251227043846_kVWBG UK004H 2025-12-29T14:21:46.822Z 2026-01-04T15:29:15.947Z
9056589 9056589 20251227042340_zWgKz UK004H 2025-12-29T14:21:08.071Z 2026-01-04T15:29:06.344Z
9031791 9031791 20251225054408_sMdPK UK004H 2025-12-28T14:21:36.072Z 2026-01-02T15:45:34.400Z
9029418 9029418 20251225035147_DelWE UK004H 2025-12-28T14:16:23.513Z 2026-01-02T15:44:22.194Z
9026665 9026665 20251225012417_qgipH UK004H 2025-12-28T14:08:35.292Z 2026-01-02T15:42:59.385Z
9026572 9026572 20251225011659_n3CZi UK004H 2025-12-28T14:08:19.298Z 2026-01-02T15:42:57.879Z
9016260 9016260 20251220034903_hAi6E UK004H 2025-12-27T14:59:38.284Z 2025-12-29T15:23:21.792Z
9016062 9016062 20251220033804_mukW8 UK004H 2025-12-27T14:59:31.794Z 2025-12-29T15:23:20.740Z
8983626 8983626 20251219221303_NTxMQ UK004H 2025-12-26T14:29:27.962Z 2025-12-28T15:23:41.889Z
8982343 8982343 20251219193024_shNSi UK004H 2025-12-26T14:26:51.686Z 2025-12-28T15:22:07.969Z
8975231 8975231 20251220032241_3MlGW UK004H 2025-12-26T14:06:22.345Z 2025-12-29T15:23:12.943Z
8974530 8974530 20251220023030_Isjzp UK004H 2025-12-26T14:04:36.854Z 2025-12-29T15:22:42.483Z
8974152 8974152 20251220020733_RJjKK UK004H 2025-12-26T14:03:53.033Z 2025-12-29T15:22:39.202Z
8972841 8972841 20251220003825_Tg3UL UK004H 2025-12-26T14:00:39.288Z 2025-12-29T15:22:30.085Z
8972428 8972428 20251217011906_INQN7 UK004H 2025-12-25T14:54:54.086Z 2025-12-25T14:54:54.086Z
8971898 8971898 20251217004300_maYvf UK004H 2025-12-25T14:54:37.703Z 2025-12-25T14:54:37.703Z
8953758 8953758 20251217044654_CmmX5 UK004H 2025-12-25T14:07:41.898Z 2025-12-26T14:57:32.758Z
8953605 8953605 20251217042325_6d8Y3 UK004H 2025-12-25T14:07:01.792Z 2025-12-26T14:57:07.772Z
8953407 8953407 20251217034956_88Ajj UK004H 2025-12-25T14:06:03.466Z 2025-12-26T14:56:43.298Z
8953231 8953231 20251217032114_OPsqh UK004H 2025-12-25T14:05:02.678Z 2025-12-26T14:56:21.701Z
8953124 8953124 20251217030713_Ev5F3 UK004H 2025-12-25T14:04:27.330Z 2025-12-26T14:56:04.820Z
8952844 8952844 20251217023415_xVjrS UK004H 2025-12-25T14:02:50.281Z 2025-12-26T14:55:27.286Z
8945418 8945418 20251214210043_lQXl7 UK004H 2025-12-24T15:02:43.648Z 2025-12-24T15:02:43.648Z
8940056 8940056 20251214181406_Jx1ks UK004H 2025-12-24T14:56:07.886Z 2025-12-24T14:56:07.886Z
8901028 8901028 20251214044115_32Vm3 UK004H 2025-12-23T14:05:42.551Z 2025-12-24T14:18:40.055Z
8900704 8900704 20251214043812_fWSgh UK004H 2025-12-23T14:05:19.596Z 2025-12-24T14:18:20.407Z
8900649 8900649 20251214043736_fuxi1 UK004H 2025-12-23T14:05:17.893Z 2025-12-24T14:18:19.062Z
8898712 8898712 20251214041806_3HWDp UK004H 2025-12-23T14:04:02.435Z 2025-12-24T14:17:08.563Z
8898363 8898363 20251214041507_M4FmR UK004H 2025-12-23T14:03:59.944Z 2025-12-24T14:17:03.841Z
8898341 8898341 20251214041456_tzh80 UK004H 2025-12-23T14:03:59.656Z 2025-12-24T14:17:01.919Z
8895307 8895307 20251214023129_63bX1 UK004H 2025-12-22T14:12:09.253Z 2025-12-23T14:27:53.600Z
8894134 8894134 20251214022152_qA6T5 UK004H 2025-12-22T14:12:01.778Z 2025-12-23T14:27:52.331Z
8892297 8892297 20251214020748_ZIYAn UK004H 2025-12-22T14:11:50.070Z 2025-12-23T14:27:48.010Z
8890020 8890020 20251214014928_uaxjP UK004H 2025-12-22T14:11:40.024Z 2025-12-23T14:27:44.856Z
8889628 8889628 20251214014613_xbAUN UK004H 2025-12-22T14:11:37.892Z 2025-12-23T14:27:44.046Z
8889094 8889094 20251214014142_9nRnV UK004H 2025-12-22T14:11:35.367Z 2025-12-23T14:27:42.995Z
8888908 8888908 20251214014023_dIxw1 UK004H 2025-12-22T14:11:34.613Z 2025-12-23T14:27:42.658Z
8884637 8884637 20251214040538_S7G63 UK004H 2025-12-22T14:03:26.084Z 2025-12-24T14:16:24.639Z
8882572 8882572 20251214034935_pE3cZ UK004H 2025-12-22T14:03:12.348Z 2025-12-24T14:15:41.091Z
8882539 8882539 20251214034924_am3a2 UK004H 2025-12-22T14:03:12.185Z 2025-12-24T14:15:40.719Z
8882359 8882359 20251214034801_S3TyY UK004H 2025-12-22T14:03:10.542Z 2025-12-24T14:15:38.611Z
8882341 8882341 20251214034751_UKVT4 UK004H 2025-12-22T14:03:09.896Z 2025-12-24T14:15:38.355Z
8882317 8882317 20251214034739_uDrBP UK004H 2025-12-22T14:03:08.938Z 2025-12-24T14:15:37.889Z
8882097 8882097 20251214034548_KUi6z UK004H 2025-12-22T14:03:04.601Z 2025-12-24T14:15:35.348Z
8881984 8881984 20251214034513_JHP4B UK004H 2025-12-22T14:02:59.178Z 2025-12-24T14:15:33.721Z
8881165 8881165 20251214033905_lN83r UK004H 2025-12-22T14:02:36.481Z 2025-12-24T14:15:00.307Z
8879298 8879298 20251214032641_Iq6Gw UK004H 2025-12-22T14:02:03.924Z 2025-12-24T14:14:16.032Z
8879093 8879093 20251214032516_rKVMV UK004H 2025-12-22T14:02:01.562Z 2025-12-24T14:14:12.784Z
8878822 8878822 20251214032304_3jLSo UK004H 2025-12-22T14:01:58.744Z 2025-12-24T14:14:07.839Z
8878581 8878581 20251214032112_YcFu2 UK004H 2025-12-22T14:01:56.464Z 2025-12-24T14:14:02.527Z
8875554 8875554 20251214030156_BTulZ UK004H 2025-12-22T14:00:35.043Z 2025-12-24T14:12:45.185Z
8874813 8874813 20251214025704_uYI2T UK004H 2025-12-22T14:00:15.045Z 2025-12-24T14:12:25.755Z
8873781 8873781 20251214010749_5KGo9 UK004H 2025-12-21T14:11:03.741Z 2025-12-23T14:27:36.582Z
8872392 8872392 20251214005845_xMO5Y UK004H 2025-12-21T14:10:52.486Z 2025-12-23T14:27:35.148Z
8870619 8870619 20251214004643_QLV5s UK004H 2025-12-21T14:10:36.527Z 2025-12-23T14:27:32.824Z
8869943 8869943 20251214004245_UaLQ9 UK004H 2025-12-21T14:10:28.066Z 2025-12-23T14:27:31.614Z
8868207 8868207 20251214003018_Aeuo6 UK004H 2025-12-21T14:10:08.761Z 2025-12-23T14:27:29.613Z
8861804 8861804 20251213223854_49QQ5 UK004H 2025-12-21T14:08:32.455Z 2025-12-23T14:25:21.046Z
8860097 8860097 20251213215229_HlUpi UK004H 2025-12-21T14:07:28.161Z 2025-12-23T14:25:11.078Z
8859632 8859632 20251213214000_TLUko UK004H 2025-12-21T14:07:09.163Z 2025-12-23T14:25:08.386Z
8858817 8858817 20251213211732_3NfJS UK004H 2025-12-21T14:06:56.258Z 2025-12-23T14:25:03.862Z
8856607 8856607 20251213214000_QWfhT UK004H 2025-12-20T14:12:15.581Z 2025-12-20T14:21:16.713Z
8854449 8854449 20251213180224_jbVTn UK004H 2025-12-20T14:07:56.497Z 2025-12-23T14:23:05.019Z
8851708 8851708 20251214000410_pQvZW UK004H 2025-12-19T14:21:31.783Z 2025-12-23T14:26:51.260Z
8849889 8849889 20251213234720_pjm3r UK004H 2025-12-19T14:19:56.197Z 2025-12-23T14:26:27.007Z
8848542 8848542 20251213233551_W6e63 UK004H 2025-12-19T14:18:39.218Z 2025-12-23T14:26:08.137Z
8842561 8842561 20251213224007_UgkVm UK004H 2025-12-18T14:44:03.770Z 2025-12-23T14:25:21.216Z
8842421 8842421 20251213223854_KkTYz UK004H 2025-12-18T14:44:01.929Z 2025-12-20T14:21:19.162Z
8841864 8841864 20251213223328_qRWrR UK004H 2025-12-18T14:43:51.954Z 2025-12-23T14:25:20.319Z
8840212 8840212 20251213221521_rDuC0 UK004H 2025-12-18T14:42:20.497Z 2025-12-23T14:25:15.162Z
8839847 8839847 20251213221206_s5enq UK004H 2025-12-18T14:41:37.209Z 2025-12-23T14:25:14.448Z
8838919 8838919 20251213220227_4lzVp UK004H 2025-12-18T14:40:36.543Z 2025-12-23T14:25:12.651Z
8838882 8838882 20251213220200_zRBKY UK004H 2025-12-18T14:40:35.821Z 2025-12-23T14:25:12.605Z
8838206 8838206 20251213215229_19pRH UK004H 2025-12-18T14:40:24.875Z 2025-12-20T14:21:17.265Z
8837800 8837800 20251213214708_QyyRV UK004H 2025-12-18T14:39:52.224Z 2025-12-23T14:25:10.186Z
8837469 8837469 20251213214248_A2Ewc UK004H 2025-12-18T14:39:25.692Z 2025-12-23T14:25:09.191Z
8837244 8837244 20251213214000_sONta UK004H 2025-12-18T14:38:52.220Z 2025-12-19T14:49:51.912Z
8836640 8836640 20251213213228_ngzjf UK004H 2025-12-18T14:38:38.652Z 2025-12-23T14:25:06.909Z
8836125 8836125 20251213212625_76Gw3 UK004H 2025-12-18T14:38:29.655Z 2025-12-23T14:25:05.600Z
8835703 8835703 20251213212059_a75aR UK004H 2025-12-18T14:37:57.375Z 2025-12-23T14:25:04.680Z
8835497 8835497 20251213211732_pycCG UK004H 2025-12-18T14:37:34.908Z 2025-12-20T14:21:15.818Z
8835181 8835181 20251213211333_ydE0S UK004H 2025-12-18T14:37:28.285Z 2025-12-23T14:25:02.884Z
8834186 8834186 20251213205901_Xrq3Q UK004H 2025-12-18T14:36:16.826Z 2025-12-23T14:25:00.829Z
8833931 8833931 20251213205547_EX8Qt UK004H 2025-12-18T14:36:10.520Z 2025-12-23T14:25:00.462Z
8831544 8831544 20251213201334_n0MYj UK004H 2025-12-18T14:34:26.701Z 2025-12-23T14:24:40.812Z
8830674 8830674 20251213195704_4ZrnH UK004H 2025-12-18T14:33:27.934Z 2025-12-23T14:24:24.708Z
8830421 8830421 20251213194919_2MzW3 UK004H 2025-12-18T14:32:57.418Z 2025-12-23T14:24:13.785Z
8827303 8827303 20251213180224_fECaQ UK004H 2025-12-18T14:27:08.766Z 2025-12-19T14:49:47.714Z
8795770 8795770 20251213044119_XtxMm UK004H 2025-12-16T14:08:17.395Z 2025-12-23T14:17:34.376Z
8795458 8795458 20251213043750_3DX2f UK004H 2025-12-16T14:08:06.710Z 2025-12-23T14:17:30.477Z
8794711 8794711 20251213042738_1FqDl UK004H 2025-12-16T14:07:21.613Z 2025-12-23T14:17:12.118Z
8794505 8794505 20251213042556_klcpm UK004H 2025-12-16T14:07:11.953Z 2025-12-23T14:17:09.470Z

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