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

4,949 rows where station_code = "UK0078" 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
8691244 8691244 20251205041334_ozTfk UK0078 2025-12-06T14:17:01.712Z 2025-12-06T14:18:01.068Z
8690810 8690810 20251205015522_Ockp3 UK0078 2025-12-06T14:15:36.601Z 2025-12-06T14:18:00.965Z
8686036 8686036 20251203181605_bTje6 UK0078 2025-12-05T14:10:46.323Z 2025-12-06T14:21:26.983Z
8683021 8683021 20251203061855_Iw81H UK0078 2025-12-04T14:18:26.940Z 2025-12-06T14:29:38.829Z
8682923 8682923 20251203061601_TwH62 UK0078 2025-12-04T14:18:20.930Z 2025-12-06T14:29:31.972Z
8682795 8682795 20251203060402_1FaRd UK0078 2025-12-04T14:18:01.564Z 2025-12-06T14:29:25.748Z
8682710 8682710 20251203060047_YWiWS UK0078 2025-12-04T14:17:55.933Z 2025-12-06T14:29:23.448Z
8682505 8682505 20251203054046_y4B8l UK0078 2025-12-04T14:17:19.217Z 2025-12-06T14:29:12.223Z
8682017 8682017 20251203044109_AOoA0 UK0078 2025-12-04T14:16:10.605Z 2025-12-06T14:28:43.468Z
8682003 8682003 20251203043637_IWl3P UK0078 2025-12-04T14:16:08.105Z 2025-12-06T14:28:42.594Z
8681983 8681983 20251203043419_M6c18 UK0078 2025-12-04T14:16:05.034Z 2025-12-06T14:28:41.620Z
8681168 8681168 20251203023202_LHYky UK0078 2025-12-04T14:13:59.279Z 2025-12-06T14:27:51.992Z
8681023 8681023 20251203021400_9J8ed UK0078 2025-12-04T14:13:34.072Z 2025-12-06T14:27:46.705Z
8680822 8680822 20251203012354_Z2zsC UK0078 2025-12-04T14:13:00.046Z 2025-12-06T14:27:27.936Z
8680796 8680796 20251203012041_LjenE UK0078 2025-12-04T14:12:56.482Z 2025-12-06T14:27:27.067Z
8680531 8680531 20251203002554_f0uHf UK0078 2025-12-04T14:12:17.065Z 2025-12-06T14:27:16.662Z
8680486 8680486 20251203001619_iwjQ1 UK0078 2025-12-04T14:12:07.528Z 2025-12-06T14:27:13.868Z
8667368 8667368 20251130002302_bWeFA UK0078 2025-12-02T14:37:27.444Z 2025-12-06T14:46:54.583Z
8667352 8667352 20251130001647_WMT5I UK0078 2025-12-02T14:37:24.648Z 2025-12-06T14:46:53.477Z
8658071 8658071 20251130063456_2tChW UK0078 2025-12-01T14:34:53.714Z 2025-12-06T14:50:26.186Z
8657943 8657943 20251130062133_CaprW UK0078 2025-12-01T14:34:47.224Z 2025-12-06T14:50:24.697Z
8657932 8657932 20251130062016_MvnE2 UK0078 2025-12-01T14:34:47.033Z 2025-12-06T14:50:24.524Z
8657608 8657608 20251130055403_eR3QM UK0078 2025-12-01T14:34:34.777Z 2025-12-06T14:50:15.616Z
8657561 8657561 20251130055157_fnNnI UK0078 2025-12-01T14:34:33.166Z 2025-12-06T14:50:08.898Z
8657551 8657551 20251130055156_NnVDT UK0078 2025-12-01T14:34:32.885Z 2025-12-06T14:50:08.339Z
8657474 8657474 20251130054822_Gct7u UK0078 2025-12-01T14:34:29.976Z 2025-12-06T14:50:03.773Z
8657294 8657294 20251130053809_BPSQW UK0078 2025-12-01T14:34:03.327Z 2025-12-06T14:49:51.197Z
8657023 8657023 20251130052410_sFxKD UK0078 2025-12-01T14:33:51.918Z 2025-12-06T14:49:44.044Z
8656757 8656757 20251130050821_qV42l UK0078 2025-12-01T14:28:59.387Z 2025-12-06T14:49:39.691Z
8656456 8656456 20251130045632_iB93j UK0078 2025-12-01T14:28:39.579Z 2025-12-06T14:49:34.930Z
8656444 8656444 20251130045626_ij6t5 UK0078 2025-12-01T14:28:39.178Z 2025-12-06T14:49:34.883Z
8656125 8656125 20251130043901_z3H7Z UK0078 2025-12-01T14:28:05.325Z 2025-12-06T14:49:31.254Z
8655982 8655982 20251130042847_2j35z UK0078 2025-12-01T14:27:43.493Z 2025-12-06T14:49:29.506Z
8655791 8655791 20251130041831_nzoIe UK0078 2025-12-01T14:27:29.699Z 2025-12-06T14:49:27.957Z
8655486 8655486 20251130040409_L7XH8 UK0078 2025-12-01T14:26:59.617Z 2025-12-06T14:49:23.738Z
8655320 8655320 20251130035443_QuHlb UK0078 2025-12-01T14:26:45.958Z 2025-12-06T14:49:06.449Z
8654722 8654722 20251130032833_Wdx0O UK0078 2025-12-01T14:25:47.356Z 2025-12-06T14:48:47.254Z
8654602 8654602 20251130032225_KFfD3 UK0078 2025-12-01T14:25:37.061Z 2025-12-06T14:48:44.687Z
8651638 8651638 20251130000745_cp9Iw UK0078 2025-12-01T14:19:36.783Z 2025-12-06T14:46:49.872Z
8650945 8650945 20251129221016_SYMrh UK0078 2025-12-01T14:17:35.745Z 2025-12-06T14:46:36.265Z
8649936 8649936 20251129185408_gj3wn UK0078 2025-12-01T14:14:30.081Z 2025-12-06T14:45:43.366Z
8649796 8649796 20251129182708_OSvmd UK0078 2025-12-01T14:13:58.205Z 2025-12-06T14:45:39.611Z
8616783 8616783 20251126062706_X0i1L UK0078 2025-11-27T14:31:49.309Z 2025-12-04T15:11:43.285Z
8616738 8616738 20251126062301_mV8P4 UK0078 2025-11-27T14:31:47.075Z 2025-12-04T15:11:42.659Z
8616472 8616472 20251126060145_hRicP UK0078 2025-11-27T14:31:12.879Z 2025-12-04T15:11:39.782Z
8616417 8616417 20251126055809_otggj UK0078 2025-11-27T14:31:10.396Z 2025-12-04T15:11:39.251Z
8616163 8616163 20251126054406_N3wKI UK0078 2025-11-27T14:30:39.076Z 2025-12-04T15:11:36.499Z
8616038 8616038 20251126053349_Yax8B UK0078 2025-11-27T14:30:23.012Z 2025-12-04T15:11:34.811Z
8615775 8615775 20251126051904_2co2n UK0078 2025-11-27T14:30:10.198Z 2025-12-04T15:11:32.279Z
8615612 8615612 20251126051137_sSgUe UK0078 2025-11-27T14:30:01.462Z 2025-12-04T15:11:30.835Z
8615186 8615186 20251126044940_HnQah UK0078 2025-11-27T14:29:19.239Z 2025-12-04T15:11:26.634Z
8615143 8615143 20251126044636_xLQx6 UK0078 2025-11-27T14:29:16.408Z 2025-12-04T15:11:26.247Z
8614925 8614925 20251126043653_P5hyR UK0078 2025-11-27T14:28:43.021Z 2025-12-04T15:11:21.850Z
8614714 8614714 20251126042452_2Gb7Y UK0078 2025-11-27T14:28:29.326Z 2025-12-04T15:11:00.378Z
8614551 8614551 20251126041750_uQgw3 UK0078 2025-11-27T14:28:02.514Z 2025-12-04T15:10:50.917Z
8613729 8613729 20251126033214_rgN2b UK0078 2025-11-27T14:26:28.301Z 2025-12-04T15:09:51.333Z
8613578 8613578 20251126032418_s2cmc UK0078 2025-11-27T14:26:15.263Z 2025-12-04T15:09:49.407Z
8613563 8613563 20251126032400_5dXtc UK0078 2025-11-27T14:26:13.814Z 2025-12-04T15:09:49.227Z
8613412 8613412 20251126031638_WxpHb UK0078 2025-11-27T14:25:48.696Z 2025-12-04T15:09:40.277Z
8612918 8612918 20251126025507_81YRR UK0078 2025-11-27T14:24:59.416Z 2025-12-04T15:09:35.751Z
8612779 8612779 20251126024535_3Zp35 UK0078 2025-11-27T14:24:38.537Z 2025-12-04T15:09:33.976Z
8612528 8612528 20251126023504_zaLPX UK0078 2025-11-27T14:24:17.732Z 2025-12-04T15:09:31.391Z
8611979 8611979 20251126021236_2967d UK0078 2025-11-27T14:23:10.988Z 2025-12-04T15:09:26.471Z
8611685 8611685 20251126015610_e9j3d UK0078 2025-11-27T14:22:30.276Z 2025-12-04T15:09:23.431Z
8610376 8610376 20251126004011_SgaDP UK0078 2025-11-27T14:20:01.488Z 2025-12-04T15:08:04.762Z
8610163 8610163 20251126002716_9iskr UK0078 2025-11-27T14:19:32.162Z 2025-12-04T15:08:03.007Z
8609863 8609863 20251126001103_vmTiI UK0078 2025-11-27T14:19:03.062Z 2025-12-04T15:07:57.798Z
8609752 8609752 20251126000323_2lg2m UK0078 2025-11-27T14:18:55.054Z 2025-12-04T15:07:57.115Z
8609470 8609470 20251125234423_hvqM8 UK0078 2025-11-27T14:18:14.476Z 2025-12-04T15:07:54.657Z
8609144 8609144 20251125231515_dk6U1 UK0078 2025-11-27T14:17:36.464Z 2025-12-04T15:07:51.896Z
8608686 8608686 20251125223544_w2pAC UK0078 2025-11-27T14:16:32.493Z 2025-12-04T15:07:47.750Z
8608452 8608452 20251125221741_RQiS2 UK0078 2025-11-27T14:16:07.283Z 2025-12-04T15:07:45.084Z
8608086 8608086 20251125214819_9GJhm UK0078 2025-11-27T14:15:16.963Z 2025-12-04T15:07:41.094Z
8603260 8603260 20251125055256_RH17M UK0078 2025-11-26T14:27:17.913Z 2025-12-02T15:09:35.113Z
8602876 8602876 20251125052932_278A9 UK0078 2025-11-26T14:26:25.826Z 2025-12-02T15:09:33.336Z
8602772 8602772 20251125052057_gLmrS UK0078 2025-11-26T14:26:19.818Z 2025-12-02T15:09:32.795Z
8602486 8602486 20251125045902_HZeM8 UK0078 2025-11-26T14:26:03.738Z 2025-12-02T15:09:31.180Z
8602063 8602063 20251125043441_D22bD UK0078 2025-11-26T14:25:19.215Z 2025-12-02T15:09:29.318Z
8602057 8602057 20251125043433_q0qel UK0078 2025-11-26T14:25:18.982Z 2025-12-02T15:09:29.299Z
8601883 8601883 20251125042223_kDIGR UK0078 2025-11-26T14:24:53.735Z 2025-12-02T15:09:26.134Z
8601606 8601606 20251125040307_3cY3d UK0078 2025-11-26T14:24:30.969Z 2025-12-02T15:09:16.578Z
8598591 8598591 20251125010721_PNWeR UK0078 2025-11-26T14:19:18.066Z 2025-12-02T15:08:01.132Z
8592045 8592045 20251124053606_kYNlQ UK0078 2025-11-25T14:25:47.522Z 2025-12-02T15:13:01.507Z
8591801 8591801 20251124050021_YBD44 UK0078 2025-11-25T14:25:10.029Z 2025-12-02T15:13:00.594Z
8591619 8591619 20251124043558_kV2Sx UK0078 2025-11-25T14:24:39.629Z 2025-12-02T15:12:59.677Z
8591608 8591608 20251124043314_CqZX9 UK0078 2025-11-25T14:24:37.337Z 2025-12-02T15:12:59.634Z
8591579 8591579 20251124042630_S1K5D UK0078 2025-11-25T14:24:33.830Z 2025-12-02T15:12:59.447Z
8591465 8591465 20251124041713_UvP9z UK0078 2025-11-25T14:24:24.060Z 2025-12-02T15:12:58.766Z
8591186 8591186 20251124035236_nMoHh UK0078 2025-11-25T14:23:43.659Z 2025-12-02T15:12:57.340Z
8590405 8590405 20251124023914_P3um0 UK0078 2025-11-25T14:21:47.485Z 2025-12-02T15:12:47.299Z
8590320 8590320 20251124023358_B3xsW UK0078 2025-11-25T14:21:40.824Z 2025-12-02T15:12:46.311Z
8590273 8590273 20251124023246_kgzSI UK0078 2025-11-25T14:21:37.191Z 2025-12-02T15:12:44.195Z
8587646 8587646 20251123222637_9Lxa5 UK0078 2025-11-25T14:15:50.614Z 2025-12-02T15:11:18.757Z
8587360 8587360 20251123215250_bElAO UK0078 2025-11-25T14:15:04.032Z 2025-12-02T15:11:11.269Z
8587293 8587293 20251123214142_E0QTu UK0078 2025-11-25T14:14:58.055Z 2025-12-02T15:11:10.896Z
8587055 8587055 20251123211736_H00t9 UK0078 2025-11-25T14:14:29.547Z 2025-12-02T15:11:05.826Z
8586971 8586971 20251123210957_9t3Kx UK0078 2025-11-25T14:14:19.974Z 2025-12-02T15:11:05.322Z
8586802 8586802 20251123205326_8hRQy UK0078 2025-11-25T14:13:58.250Z 2025-12-02T15:11:03.319Z
8586767 8586767 20251123204837_3acrm UK0078 2025-11-25T14:13:50.897Z 2025-12-02T15:11:02.589Z
8586014 8586014 20251123183011_7f7Dk UK0078 2025-11-25T14:11:37.184Z 2025-12-02T15:10:39.445Z

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