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

6,405 rows where station_code = "UK005P" 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
9411955 9411955 20260226003511_tyPiW UK005P 2026-03-01T14:09:49.727Z 2026-03-06T14:43:00.038Z
9401140 9401140 20260225222441_gBZR3 UK005P 2026-02-27T14:16:29.803Z 2026-03-05T14:39:07.805Z
9398154 9398154 20260226031153_n2K3B UK005P 2026-02-27T14:04:33.126Z 2026-03-06T14:43:36.330Z
9397965 9397965 20260226024748_F51fO UK005P 2026-02-27T14:04:01.534Z 2026-03-06T14:43:31.059Z
9397084 9397084 20260226003511_9AKrg UK005P 2026-02-27T14:01:21.439Z 2026-03-06T14:42:59.963Z
9394963 9394963 20260224222525_g9bgC UK005P 2026-02-26T14:20:56.054Z 2026-03-04T14:19:28.749Z
9394951 9394951 20260224222223_LPqzl UK005P 2026-02-26T14:20:55.030Z 2026-03-04T14:19:28.663Z
9394113 9394113 20260224184349_b3bas UK005P 2026-02-26T14:18:52.039Z 2026-03-04T14:19:16.436Z
9392753 9392753 20260225054553_5tqbc UK005P 2026-02-26T14:08:12.815Z 2026-03-05T14:37:06.284Z
9392746 9392746 20260225054250_Qbb11 UK005P 2026-02-26T14:08:11.741Z 2026-03-05T14:37:06.036Z
9392581 9392581 20260225044823_ka9kk UK005P 2026-02-26T14:07:41.544Z 2026-03-05T14:37:01.556Z
9392052 9392052 20260225033829_lxZn7 UK005P 2026-02-26T14:06:17.420Z 2026-03-05T14:36:42.287Z
9391786 9391786 20260225031538_3vANh UK005P 2026-02-26T14:05:23.762Z 2026-03-05T14:36:31.192Z
9391698 9391698 20260225030851_R63vk UK005P 2026-02-26T14:05:05.063Z 2026-03-05T14:36:28.136Z
9391600 9391600 20260225025940_61vqM UK005P 2026-02-26T14:04:48.475Z 2026-03-05T14:36:25.160Z
9391246 9391246 20260225021836_5gfEV UK005P 2026-02-26T14:03:50.917Z 2026-03-05T14:36:15.398Z
9390409 9390409 20260225002751_pIvej UK005P 2026-02-26T14:01:20.355Z 2026-03-05T14:35:40.851Z
9390297 9390297 20260225000919_kS0vK UK005P 2026-02-26T14:01:03.411Z 2026-03-05T14:35:37.838Z
9390232 9390232 20260225000147_6l08V UK005P 2026-02-26T14:00:50.495Z 2026-03-05T14:35:35.666Z
9390176 9390176 20260224235355_ZFpo7 UK005P 2026-02-26T14:00:43.327Z 2026-03-05T14:35:34.774Z
9381102 9381102 20260222205916_o2lRT UK005P 2026-02-24T14:24:15.804Z 2026-02-24T14:24:15.804Z
9373870 9373870 20260223043845_HDaKx UK005P 2026-02-24T14:04:10.669Z 2026-03-03T14:31:10.913Z
9372972 9372972 20260223014712_B0hhV UK005P 2026-02-24T14:01:51.036Z 2026-03-03T14:30:49.361Z
9372606 9372606 20260223004351_Cr41e UK005P 2026-02-24T14:01:00.303Z 2026-03-03T14:30:43.241Z
9372447 9372447 20260223001653_oKIfx UK005P 2026-02-24T14:00:38.927Z 2026-03-03T14:30:40.632Z
9372299 9372299 20260222234506_npGui UK005P 2026-02-24T14:00:10.137Z 2026-03-03T14:30:38.379Z
9340381 9340381 20260216235848_4WdN3 UK005P 2026-02-18T14:24:46.046Z 2026-02-25T14:42:53.840Z
9339934 9339934 20260216220445_jo60l UK005P 2026-02-18T14:23:31.353Z 2026-02-25T14:42:48.544Z
9337034 9337034 20260217045750_PfqVZ UK005P 2026-02-18T14:06:12.472Z 2026-02-26T14:39:23.646Z
9336958 9336958 20260217044804_nSXUV UK005P 2026-02-18T14:05:57.038Z 2026-02-26T14:39:22.924Z
9336946 9336946 20260217044509_2tsqT UK005P 2026-02-18T14:05:55.127Z 2026-02-26T14:39:22.857Z
9336121 9336121 20260217031407_J54Ty UK005P 2026-02-18T14:03:23.151Z 2026-02-26T14:39:15.722Z
9335796 9335796 20260217023853_rCAp9 UK005P 2026-02-18T14:02:22.521Z 2026-02-26T14:38:58.671Z
9335659 9335659 20260217022643_BW2dY UK005P 2026-02-18T14:01:56.516Z 2026-02-26T14:38:57.866Z
9335388 9335388 20260217013400_lNUVL UK005P 2026-02-18T14:00:58.538Z 2026-02-26T14:38:53.573Z
9334390 9334390 20260215214125_CtxbU UK005P 2026-02-17T14:24:04.936Z 2026-02-24T14:43:08.895Z
9334307 9334307 20260215212353_8fvZI UK005P 2026-02-17T14:23:48.750Z 2026-02-24T14:43:07.277Z
9330942 9330942 20260216031818_PhRX2 UK005P 2026-02-17T14:03:47.454Z 2026-02-25T14:41:35.585Z
9330690 9330690 20260216022247_wL2tr UK005P 2026-02-17T14:02:31.075Z 2026-02-25T14:41:30.316Z
9330551 9330551 20260216015608_smW8K UK005P 2026-02-17T14:01:58.551Z 2026-02-25T14:41:28.870Z
9323421 9323421 20260214052024_GAHUT UK005P 2026-02-15T14:06:13.083Z 2026-02-23T14:46:32.033Z
9323159 9323159 20260214045320_92A4y UK005P 2026-02-15T14:05:29.088Z 2026-02-23T14:46:28.434Z
9322831 9322831 20260214040609_BYp1q UK005P 2026-02-15T14:04:08.446Z 2026-02-23T14:46:23.079Z
9322778 9322778 20260214035856_8tIBs UK005P 2026-02-15T14:03:56.623Z 2026-02-23T14:46:22.152Z
9319484 9319484 20260213020156_hsvG5 UK005P 2026-02-14T14:00:18.897Z 2026-02-22T14:41:21.346Z
9306273 9306273 20260207223832_763hv UK005P 2026-02-09T14:23:14.590Z 2026-02-16T15:00:09.462Z
9302470 9302470 20260206221757_WGw8B UK005P 2026-02-08T14:22:37.309Z 2026-02-15T15:00:35.644Z
9302395 9302395 20260206211916_KhVEF UK005P 2026-02-08T14:22:21.540Z 2026-02-15T15:00:32.014Z
9288920 9288920 20260204060442_Qh8Oz UK005P 2026-02-05T14:01:45.793Z 2026-02-13T14:53:13.873Z
9288779 9288779 20260204045734_NY41h UK005P 2026-02-05T14:00:35.737Z 2026-02-13T14:52:55.939Z
9284662 9284662 20260131034700_nfxvM UK005P 2026-02-01T14:16:34.967Z 2026-02-08T14:50:17.983Z
9284645 9284645 20260131034413_rWa4E UK005P 2026-02-01T14:16:31.776Z 2026-02-08T14:50:15.870Z
9284563 9284563 20260131024128_1gxS2 UK005P 2026-02-01T14:16:12.673Z 2026-02-08T14:50:10.255Z
9284548 9284548 20260131023735_eqkAU UK005P 2026-02-01T14:16:09.728Z 2026-02-08T14:50:09.106Z
9277996 9277996 20260129045513_pr2xb UK005P 2026-01-30T14:24:03.372Z 2026-02-06T14:48:18.221Z
9277994 9277994 20260129045144_QekvQ UK005P 2026-01-30T14:24:02.973Z 2026-02-06T14:48:18.041Z
9277821 9277821 20260129024249_YsaMT UK005P 2026-01-30T14:23:24.800Z 2026-02-06T14:48:06.874Z
9277813 9277813 20260129024023_5peSM UK005P 2026-01-30T14:23:22.973Z 2026-02-06T14:48:06.377Z
9273473 9273473 20260128062741_CiWXN UK005P 2026-01-29T14:29:53.709Z 2026-02-05T14:50:51.927Z
9273379 9273379 20260128055724_2W6Fj UK005P 2026-01-29T14:29:30.383Z 2026-02-05T14:50:45.556Z
9273243 9273243 20260128051318_RD6fp UK005P 2026-01-29T14:29:11.188Z 2026-02-05T14:50:38.419Z
9273233 9273233 20260128051207_7S5fS UK005P 2026-01-29T14:29:10.145Z 2026-02-05T14:50:33.095Z
9273162 9273162 20260128050149_fIto2 UK005P 2026-01-29T14:28:53.272Z 2026-02-05T14:50:29.887Z
9272770 9272770 20260128032323_88ant UK005P 2026-01-29T14:27:45.684Z 2026-02-05T14:50:03.710Z
9272717 9272717 20260128031058_EX559 UK005P 2026-01-29T14:27:37.627Z 2026-02-05T14:50:01.256Z
9272588 9272588 20260128024144_0dMYA UK005P 2026-01-29T14:27:12.476Z 2026-02-05T14:49:54.986Z
9272432 9272432 20260128020543_paGhN UK005P 2026-01-29T14:26:38.414Z 2026-02-05T14:49:47.917Z
9272408 9272408 20260128015906_58SK9 UK005P 2026-01-29T14:26:36.278Z 2026-02-05T14:49:47.180Z
9272279 9272279 20260128011633_VuKB2 UK005P 2026-01-29T14:26:10.930Z 2026-02-05T14:49:36.314Z
9271876 9271876 20260127212449_H81Jq UK005P 2026-01-29T14:24:42.231Z 2026-02-05T14:49:02.714Z
9256252 9256252 20260124063007_XeDIl UK005P 2026-01-25T14:16:18.942Z 2026-02-01T14:51:15.144Z
9256127 9256127 20260124060137_P9rKN UK005P 2026-01-25T14:15:59.692Z 2026-02-01T14:51:10.459Z
9254946 9254946 20260123232635_G4cpg UK005P 2026-01-25T14:11:25.791Z 2026-02-01T14:50:02.119Z
9254869 9254869 20260123221017_QQGUu UK005P 2026-01-25T14:10:58.661Z 2026-02-01T14:49:58.238Z
9254865 9254865 20260123220918_ihy0m UK005P 2026-01-25T14:10:58.006Z 2026-02-01T14:49:58.060Z
9252245 9252245 20260123015714_Ov0k4 UK005P 2026-01-24T14:14:50.638Z 2026-01-31T15:01:24.265Z
9251962 9251962 20260123000716_iOJA0 UK005P 2026-01-24T14:13:49.794Z 2026-01-31T15:01:04.127Z
9243944 9243944 20260121053746_21zEs UK005P 2026-01-22T14:23:38.089Z 2026-01-29T15:05:35.722Z
9242800 9242800 20260121024653_rokKi UK005P 2026-01-22T14:19:17.416Z 2026-01-29T15:04:21.455Z
9242643 9242643 20260121022929_fxXr8 UK005P 2026-01-22T14:18:40.044Z 2026-01-29T15:04:15.524Z
9237385 9237385 20260120050912_ODFmy UK005P 2026-01-21T14:26:23.121Z 2026-01-28T15:01:23.017Z
9230521 9230521 20260119042858_mGKpT UK005P 2026-01-20T14:28:21.117Z 2026-01-27T15:05:00.911Z
9230517 9230517 20260119042858_NBc1a UK005P 2026-01-20T14:28:20.479Z 2026-01-27T15:05:00.561Z
9213322 9213322 20260116030811_y5DIW UK005P 2026-01-17T14:16:24.538Z 2026-01-24T15:12:09.279Z
9213210 9213210 20260116023621_kHGfA UK005P 2026-01-17T14:15:54.662Z 2026-01-24T15:11:49.503Z
9213041 9213041 20260116020050_6y73Y UK005P 2026-01-17T14:15:07.343Z 2026-01-24T15:11:38.341Z
9212956 9212956 20260116014242_kjkze UK005P 2026-01-17T14:14:44.330Z 2026-01-24T15:11:35.595Z
9212893 9212893 20260116013601_Juvbx UK005P 2026-01-17T14:14:27.536Z 2026-01-24T15:11:32.992Z
9207515 9207515 20260115015959_E31xw UK005P 2026-01-16T14:09:03.332Z 2026-01-22T15:03:23.893Z
9204188 9204188 20260114061408_9ClZb UK005P 2026-01-15T14:26:37.779Z 2026-01-22T15:10:21.979Z
9204001 9204001 20260114060328_xuoHY UK005P 2026-01-15T14:26:14.664Z 2026-01-22T15:10:16.895Z
9203864 9203864 20260114054537_gPSPn UK005P 2026-01-15T14:25:43.369Z 2026-01-22T15:10:14.635Z
9203847 9203847 20260114054440_VmhaT UK005P 2026-01-15T14:25:40.933Z 2026-01-22T15:10:14.318Z
9203825 9203825 20260114053909_JZVPX UK005P 2026-01-15T14:25:37.075Z 2026-01-22T15:10:13.917Z
9203482 9203482 20260114050234_Jt679 UK005P 2026-01-15T14:24:31.796Z 2026-01-22T15:10:08.540Z
9202951 9202951 20260114042107_dkgVw UK005P 2026-01-15T14:22:52.028Z 2026-01-22T15:09:59.872Z
9202836 9202836 20260114041254_2dO5K UK005P 2026-01-15T14:22:30.682Z 2026-01-22T15:09:57.327Z
9202643 9202643 20260114035750_MmN0r UK005P 2026-01-15T14:21:54.958Z 2026-01-22T15:09:24.206Z
9202585 9202585 20260114035221_ySoo6 UK005P 2026-01-15T14:21:44.255Z 2026-01-22T15:09:23.421Z
9202349 9202349 20260114033311_zJIYq UK005P 2026-01-15T14:21:07.806Z 2026-01-22T15:09:16.659Z

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