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

686 rows where station_code = "UK003K" 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
8681255 8681255 20251203025126_E6gxu UK003K 2025-12-04T14:14:11.952Z 2025-12-05T14:21:29.456Z
8681093 8681093 20251203022219_LqeBF UK003K 2025-12-04T14:13:49.532Z 2025-12-05T14:21:15.877Z
8680949 8680949 20251203015742_G0dTy UK003K 2025-12-04T14:13:25.825Z 2025-12-05T14:21:08.442Z
8655150 8655150 20251130034624_vlJCt UK003K 2025-12-01T14:26:35.965Z 2025-12-05T14:44:29.199Z
8655042 8655042 20251130034144_dBgfQ UK003K 2025-12-01T14:26:17.893Z 2025-12-05T14:44:27.204Z
8652665 8652665 20251130012636_YX2YB UK003K 2025-12-01T14:21:56.823Z 2025-12-05T14:42:49.711Z
8652524 8652524 20251130011456_RlEc7 UK003K 2025-12-01T14:21:38.269Z 2025-12-05T14:42:46.644Z
8652450 8652450 20251130010938_YY7t1 UK003K 2025-12-01T14:21:24.853Z 2025-12-05T14:42:44.790Z
8652362 8652362 20251130010408_5KLjK UK003K 2025-12-01T14:21:18.301Z 2025-12-05T14:42:43.234Z
8613821 8613821 20251126033512_cKLXT UK003K 2025-11-27T14:26:49.188Z 2025-12-04T15:09:52.119Z
8611971 8611971 20251126021121_F2Jaq UK003K 2025-11-27T14:23:10.759Z 2025-12-04T15:09:26.416Z
8611371 8611371 20251126013851_6nrYx UK003K 2025-11-27T14:22:04.729Z 2025-12-04T15:09:11.208Z
8611098 8611098 20251126012212_E6YrU UK003K 2025-11-27T14:21:11.322Z 2025-12-04T15:08:51.114Z
8600931 8600931 20251125032402_m1t5i UK003K 2025-11-26T14:23:09.792Z 2025-12-02T15:08:52.467Z
8600102 8600102 20251125024402_Faut2 UK003K 2025-11-26T14:22:02.811Z 2025-12-02T15:08:34.603Z
8599990 8599990 20251125023520_cuWo5 UK003K 2025-11-26T14:21:55.028Z 2025-12-02T15:08:33.334Z
8599686 8599686 20251125021804_zfuuP UK003K 2025-11-26T14:21:23.967Z 2025-12-02T15:08:30.938Z
8599311 8599311 20251125015740_ISm64 UK003K 2025-11-26T14:20:46.321Z 2025-12-02T15:08:22.206Z
8598823 8598823 20251125012901_eZTAF UK003K 2025-11-26T14:19:56.105Z 2025-12-02T15:08:09.502Z
8598775 8598775 20251125012340_obtJz UK003K 2025-11-26T14:19:50.953Z 2025-12-02T15:08:08.534Z
8598184 8598184 20251125004031_dvAtl UK003K 2025-11-26T14:18:25.225Z 2025-12-02T15:07:47.953Z
8590298 8590298 20251124023314_kEEbB UK003K 2025-11-25T14:21:38.248Z 2025-12-02T15:12:46.159Z
8589723 8589723 20251124014816_a1HVt UK003K 2025-11-25T14:20:25.842Z 2025-12-02T15:12:34.275Z
8589720 8589720 20251124014816_eDX1y UK003K 2025-11-25T14:20:25.594Z 2025-12-02T15:12:34.127Z
8589142 8589142 20251124010746_VQLjy UK003K 2025-11-25T14:19:08.863Z 2025-12-02T15:12:09.708Z
8355912 8355912 20251101183407_qHKmk UK003K 2025-11-03T14:38:48.944Z 2025-11-10T15:04:51.773Z
8354021 8354021 20251102051938_8lC3j UK003K 2025-11-03T14:20:27.451Z 2025-11-10T15:09:19.383Z
8349571 8349571 20251101183407_7GysH UK003K 2025-11-03T14:07:41.132Z 2025-11-10T15:04:51.308Z
8349516 8349516 20251101182854_C3WF2 UK003K 2025-11-03T14:07:33.847Z 2025-11-10T15:04:47.971Z
8320694 8320694 20251030030917_qHR5F UK003K 2025-11-01T12:26:46.028Z 2025-11-07T15:14:44.212Z
8260731 8260731 20251026033052_8uWMk UK003K 2025-10-28T12:34:00.102Z 2025-11-03T15:16:32.205Z
8222995 8222995 20251024050502_O6F6R UK003K 2025-10-26T12:40:03.434Z 2025-11-01T13:11:15.565Z
8221191 8221191 20251024041918_9gi4B UK003K 2025-10-26T12:38:16.709Z 2025-11-01T13:11:07.438Z
8220887 8220887 20251024041252_t7C9t UK003K 2025-10-26T12:38:09.669Z 2025-11-01T13:11:06.732Z
8220457 8220457 20251024040046_Mnopn UK003K 2025-10-26T12:37:30.787Z 2025-11-01T13:11:03.952Z
8216339 8216339 20251024020247_sOaJu UK003K 2025-10-26T12:32:15.764Z 2025-11-01T13:10:32.420Z
8216188 8216188 20251024015817_M2AVs UK003K 2025-10-26T12:31:52.971Z 2025-11-01T13:10:30.813Z
8177903 8177903 20251021182354_BQjIJ UK003K 2025-10-23T12:11:45.303Z 2025-10-30T13:12:45.712Z
8163878 8163878 20251021030621_ePjxA UK003K 2025-10-22T12:19:29.192Z 2025-10-22T12:45:00.282Z
8163277 8163277 20251021020743_3SMxC UK003K 2025-10-22T12:17:29.521Z 2025-10-29T13:07:19.776Z
8120505 8120505 20251016202804_NTDi3 UK003K 2025-10-18T12:16:50.302Z 2025-10-25T13:26:27.712Z
8119650 8119650 20251016183523_7nfhe UK003K 2025-10-18T12:13:46.862Z 2025-10-25T13:25:49.721Z
8074073 8074073 20251008214050_o2Ub8 UK003K 2025-10-10T12:05:14.922Z 2025-10-17T12:37:20.186Z
8073995 8073995 20251008211122_fix0a UK003K 2025-10-10T12:05:06.423Z 2025-10-17T12:37:17.351Z
8066455 8066455 20251005033821_Vrk08 UK003K 2025-10-07T12:32:56.877Z 2025-10-13T12:33:58.194Z
8056692 8056692 20251004043017_j7WEA UK003K 2025-10-05T12:17:26.258Z 2025-10-12T12:33:01.136Z
8020259 8020259 20250930032146_1NsWG UK003K 2025-10-01T12:46:37.329Z 2025-10-08T12:43:48.364Z
8020093 8020093 20250930031136_Uehtx UK003K 2025-10-01T12:46:30.870Z 2025-10-08T12:43:41.747Z
8016797 8016797 20250929224357_8f2R2 UK003K 2025-10-01T12:24:36.786Z 2025-10-08T12:42:37.259Z
8011483 8011483 20250929045726_2C3o2 UK003K 2025-09-30T12:33:47.050Z 2025-10-07T13:01:29.314Z
8000789 8000789 20250928193033_6uKi6 UK003K 2025-09-30T12:13:31.137Z 2025-10-07T13:00:09.713Z
7990034 7990034 20250926042925_6UOAg UK003K 2025-09-28T12:36:57.393Z 2025-10-04T13:07:25.494Z
7989947 7989947 20250926042433_RGWyw UK003K 2025-09-28T12:36:55.282Z 2025-10-04T13:07:25.386Z
7976953 7976953 20250926050120_uVVuR UK003K 2025-09-28T12:06:45.920Z 2025-10-05T13:08:15.350Z
7976933 7976933 20250926045448_RBz7T UK003K 2025-09-28T12:06:41.029Z 2025-10-05T13:08:15.052Z
7976895 7976895 20250926044957_oUcbM UK003K 2025-09-28T12:06:34.810Z 2025-10-05T13:08:14.466Z
7970685 7970685 20250925192932_FORbi UK003K 2025-09-27T12:09:40.037Z 2025-10-04T13:06:37.135Z
7952714 7952714 20250925044513_kJJi3 UK003K 2025-09-26T12:01:33.248Z 2025-10-04T13:05:17.247Z
7943975 7943975 20250923202406_8vxxn UK003K 2025-09-25T12:23:59.118Z 2025-10-02T13:26:21.960Z
7938292 7938292 20250924044543_MIwqa UK003K 2025-09-25T12:03:07.333Z 2025-10-03T13:02:38.955Z
7937522 7937522 20250924034315_ftzcb UK003K 2025-09-25T12:00:35.750Z 2025-10-03T13:02:25.884Z
7910618 7910618 20250923042807_HbxD0 UK003K 2025-09-24T12:03:35.762Z 2025-10-02T13:22:45.181Z
7829248 7829248 20250913200652_ASmEQ UK003K 2025-09-15T12:18:03.918Z 2025-09-21T13:09:56.919Z
7803971 7803971 20250910202210_sP4yc UK003K 2025-09-12T12:00:48.308Z 2025-09-19T12:56:36.795Z
7803902 7803902 20250910200520_n1EZG UK003K 2025-09-12T12:00:28.832Z 2025-09-19T12:56:35.338Z
7793607 7793607 20250908203700_9e3rK UK003K 2025-09-10T12:01:37.631Z 2025-09-17T12:56:14.798Z
7767643 7767643 20250904203247_6Y83I UK003K 2025-09-06T12:29:49.357Z 2025-09-13T12:55:06.807Z
7758549 7758549 20250903200819_yLcGJ UK003K 2025-09-05T12:06:23.486Z 2025-09-12T12:48:10.612Z
7738709 7738709 20250901221613_CdMl1 UK003K 2025-09-03T12:13:24.716Z 2025-09-10T12:45:55.283Z
7738509 7738509 20250901215757_r4yk9 UK003K 2025-09-03T12:12:43.825Z 2025-09-10T12:45:49.139Z
7737962 7737962 20250901210340_AGLSt UK003K 2025-09-03T12:11:09.308Z 2025-09-10T12:45:35.797Z
7711365 7711365 20250830213734_tvKyk UK003K 2025-09-01T12:11:20.557Z 2025-09-08T12:52:03.834Z
7711305 7711305 20250830212659_k5olg UK003K 2025-09-01T12:11:00.712Z 2025-09-08T12:52:03.049Z
7682163 7682163 20250827234608_G32Ny UK003K 2025-08-29T12:19:02.903Z 2025-09-05T13:05:22.307Z
7681379 7681379 20250827223633_VbIUj UK003K 2025-08-29T12:17:04.094Z 2025-09-05T13:05:17.425Z
7681369 7681369 20250827223554_eDKcw UK003K 2025-08-29T12:17:03.247Z 2025-09-05T13:05:17.395Z
7681353 7681353 20250827223534_jQ82G UK003K 2025-08-29T12:17:01.268Z 2025-09-05T13:05:17.335Z
7681192 7681192 20250827222344_TBTgo UK003K 2025-08-29T12:16:35.638Z 2025-09-05T13:05:16.725Z
7681028 7681028 20250827220713_QlZyd UK003K 2025-08-29T12:16:12.526Z 2025-09-05T13:05:11.260Z
7680521 7680521 20250827210931_httef UK003K 2025-08-29T12:14:46.073Z 2025-09-05T13:04:59.904Z
7645788 7645788 20250824230020_h1u20 UK003K 2025-08-26T12:23:58.569Z 2025-09-02T12:51:45.111Z
7633795 7633795 20250823225348_QxWAd UK003K 2025-08-25T12:21:44.732Z 2025-09-01T12:56:03.452Z
7633277 7633277 20250823220810_LGumq UK003K 2025-08-25T12:20:28.539Z 2025-09-01T12:56:02.028Z
7632214 7632214 20250823203051_Nc5ny UK003K 2025-08-25T12:17:36.724Z 2025-09-01T12:55:54.294Z
7625194 7625194 20250823010433_hXrEq UK003K 2025-08-24T12:25:34.869Z 2025-08-31T12:54:13.707Z
7623670 7623670 20250822223621_xKNPT UK003K 2025-08-24T12:22:39.709Z 2025-08-31T12:54:00.282Z
7622737 7622737 20250822204458_pupVr UK003K 2025-08-24T12:20:25.664Z 2025-08-31T12:53:54.899Z
7622691 7622691 20250822203723_z4LVs UK003K 2025-08-24T12:20:06.989Z 2025-08-31T12:53:54.577Z
7612752 7612752 20250822010914_hHyLo UK003K 2025-08-23T12:24:35.446Z 2025-08-30T12:59:34.134Z
7610675 7610675 20250821225132_CFi7F UK003K 2025-08-23T12:21:23.082Z 2025-08-30T12:59:22.008Z
7601018 7601018 20250821001901_6o2UX UK003K 2025-08-22T12:24:28.655Z 2025-08-29T12:56:45.185Z
7600725 7600725 20250820234645_A2gKs UK003K 2025-08-22T12:24:08.819Z 2025-08-29T12:56:43.561Z
7600514 7600514 20250820232336_asD1l UK003K 2025-08-22T12:23:30.856Z 2025-08-29T12:56:41.538Z
7600467 7600467 20250820231807_NlV1X UK003K 2025-08-22T12:23:27.873Z 2025-08-29T12:56:41.176Z
7600413 7600413 20250820231508_Ku97t UK003K 2025-08-22T12:23:25.531Z 2025-08-29T12:56:41.101Z
7504851 7504851 20250814004703_CjNy0 UK003K 2025-08-16T12:48:54.169Z 2025-08-22T12:46:45.826Z
7478263 7478263 20250812212543_1wonT UK003K 2025-08-15T12:07:57.528Z 2025-08-21T12:47:09.619Z
7430079 7430079 20250810221155_1Z70t UK003K 2025-08-12T12:06:01.142Z 2025-08-18T13:37:50.920Z
7429969 7429969 20250810220622_sXVwW UK003K 2025-08-12T12:05:52.208Z 2025-08-18T13:37:49.238Z
7429968 7429968 20250810220622_d6be8 UK003K 2025-08-12T12:05:51.957Z 2025-08-18T13:37:49.211Z

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