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

5,309 rows where station_code = "UK00CA" 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
9273476 9273476 20260128062741_CiWXN UK00CA 2026-01-29T14:29:53.709Z 2026-01-29T14:30:25.820Z
9273444 9273444 20260128061319_zxva4 UK00CA 2026-01-29T14:29:48.071Z 2026-01-29T14:30:25.813Z
9273383 9273383 20260128055746_o59JW UK00CA 2026-01-29T14:29:30.825Z 2026-01-29T14:30:25.799Z
9273378 9273378 20260128055633_ht5ax UK00CA 2026-01-29T14:29:29.845Z 2026-01-29T14:30:25.797Z
9272908 9272908 20260128035850_h0dbG UK00CA 2026-01-29T14:28:13.326Z 2026-01-29T14:30:25.705Z
9272508 9272508 20260128022119_LaYIc UK00CA 2026-01-29T14:27:01.067Z 2026-01-29T14:30:25.363Z
9272407 9272407 20260128015556_R37vM UK00CA 2026-01-29T14:26:35.735Z 2026-01-29T14:30:25.342Z
9272391 9272391 20260128015145_da7d6 UK00CA 2026-01-29T14:26:34.220Z 2026-01-29T14:30:25.340Z
9272366 9272366 20260128014426_ztbSH UK00CA 2026-01-29T14:26:31.917Z 2026-01-29T14:30:25.336Z
9272346 9272346 20260128014149_vJRPJ UK00CA 2026-01-29T14:26:29.341Z 2026-01-29T14:30:25.333Z
9272344 9272344 20260128014119_CQ1NT UK00CA 2026-01-29T14:26:28.788Z 2026-01-29T14:30:25.333Z
9272274 9272274 20260128010754_J9l4b UK00CA 2026-01-29T14:26:09.409Z 2026-01-29T14:30:25.319Z
9272261 9272261 20260128010344_3YbRp UK00CA 2026-01-29T14:26:08.469Z 2026-01-29T14:30:25.317Z
9272012 9272012 20260127225628_T9mkn UK00CA 2026-01-29T14:25:17.217Z 2026-01-29T14:30:25.263Z
9271982 9271982 20260127224305_lyPpi UK00CA 2026-01-29T14:25:12.063Z 2026-01-29T14:30:25.257Z
9260627 9260627 20260125060010_z2M2a UK00CA 2026-01-26T14:22:39.202Z 2026-01-29T14:44:32.042Z
9255303 9255303 20260124024234_XS7PS UK00CA 2026-01-25T14:12:46.186Z 2026-01-29T14:47:22.328Z
9252264 9252264 20260123015935_Teh9e UK00CA 2026-01-24T14:14:52.904Z 2026-01-29T14:52:42.712Z
9252248 9252248 20260123015714_Ov0k4 UK00CA 2026-01-24T14:14:50.653Z 2026-01-29T14:52:41.578Z
9252224 9252224 20260123014818_MAkdM UK00CA 2026-01-24T14:14:46.797Z 2026-01-29T14:52:40.372Z
9252199 9252199 20260123014011_12Xx4 UK00CA 2026-01-24T14:14:42.752Z 2026-01-29T14:52:38.895Z
9251998 9251998 20260123002524_HZsMg UK00CA 2026-01-24T14:13:56.383Z 2026-01-29T14:52:21.226Z
9251963 9251963 20260123000716_iOJA0 UK00CA 2026-01-24T14:13:49.795Z 2026-01-29T14:52:19.022Z
9251941 9251941 20260123000248_tJk9D UK00CA 2026-01-24T14:13:45.968Z 2026-01-29T14:52:17.822Z
9251846 9251846 20260122232059_O7JuJ UK00CA 2026-01-24T14:13:22.082Z 2026-01-29T14:52:12.654Z
9243757 9243757 20260121051231_9qaXR UK00CA 2026-01-22T14:22:54.984Z 2026-01-29T15:05:26.057Z
9243720 9243720 20260121051047_NjMZV UK00CA 2026-01-22T14:22:50.242Z 2026-01-29T15:05:24.834Z
9242947 9242947 20260121032040_QlBz3 UK00CA 2026-01-22T14:19:57.022Z 2026-01-29T15:04:31.864Z
9242802 9242802 20260121024653_rokKi UK00CA 2026-01-22T14:19:17.431Z 2026-01-29T15:04:21.455Z
9242646 9242646 20260121022929_fxXr8 UK00CA 2026-01-22T14:18:40.053Z 2026-01-29T15:04:15.524Z
9242541 9242541 20260121021115_3TTES UK00CA 2026-01-22T14:18:14.514Z 2026-01-29T15:04:04.968Z
9242502 9242502 20260121020726_F30lq UK00CA 2026-01-22T14:18:05.383Z 2026-01-29T15:04:02.169Z
9242425 9242425 20260121014850_nwZcW UK00CA 2026-01-22T14:17:49.507Z 2026-01-29T15:03:58.161Z
9242299 9242299 20260121012407_0Yg1O UK00CA 2026-01-22T14:17:16.799Z 2026-01-29T15:03:42.967Z
9242285 9242285 20260121012246_1nTMy UK00CA 2026-01-22T14:17:11.405Z 2026-01-29T15:03:42.438Z
9218930 9218930 20260117063725_qDaYI UK00CA 2026-01-18T14:14:16.647Z 2026-01-25T14:58:55.892Z
9204032 9204032 20260114060417_MaPVB UK00CA 2026-01-15T14:26:17.552Z 2026-01-22T15:10:17.179Z
9203992 9203992 20260114060231_3q50Q UK00CA 2026-01-15T14:26:13.228Z 2026-01-22T15:10:16.737Z
9203895 9203895 20260114054819_AAbMg UK00CA 2026-01-15T14:25:48.303Z 2026-01-22T15:10:15.116Z
9203767 9203767 20260114053525_16qZy UK00CA 2026-01-15T14:25:21.969Z 2026-01-22T15:10:13.203Z
9202760 9202760 20260114040731_MRtfV UK00CA 2026-01-15T14:22:18.638Z 2026-01-22T15:09:39.995Z
9202689 9202689 20260114040259_2kSzM UK00CA 2026-01-15T14:22:08.902Z 2026-01-22T15:09:26.977Z
9201699 9201699 20260114024133_rsedA UK00CA 2026-01-15T14:19:18.578Z 2026-01-22T15:09:07.495Z
9201595 9201595 20260114023422_cP9Yb UK00CA 2026-01-15T14:19:09.058Z 2026-01-22T15:09:06.485Z
9200940 9200940 20260114012422_rA3db UK00CA 2026-01-15T14:17:04.523Z 2026-01-22T15:08:40.123Z
9200833 9200833 20260114010844_6vzul UK00CA 2026-01-15T14:16:37.470Z 2026-01-22T15:08:30.307Z
9195283 9195283 20260113005227_bfIpj UK00CA 2026-01-14T14:12:43.475Z 2026-01-21T15:04:38.457Z
9194926 9194926 20260112233521_AQKNH UK00CA 2026-01-14T14:11:20.857Z 2026-01-21T15:04:34.098Z
9194782 9194782 20260112223856_pzIvZ UK00CA 2026-01-14T14:10:40.018Z 2026-01-21T15:04:20.966Z
9181972 9181972 20260111035248_sOc8v UK00CA 2026-01-12T14:12:46.641Z 2026-01-19T15:17:58.349Z
9181594 9181594 20260111022227_XfeRY UK00CA 2026-01-12T14:11:23.557Z 2026-01-19T15:17:39.211Z
9181348 9181348 20260111012705_rd03S UK00CA 2026-01-12T14:10:29.135Z 2026-01-19T15:17:13.846Z
9180610 9180610 20260110210852_Yxzac UK00CA 2026-01-12T14:07:41.740Z 2026-01-19T15:16:24.498Z
9180576 9180576 20260110205557_vsnO6 UK00CA 2026-01-12T14:07:34.053Z 2026-01-19T15:16:22.976Z
9180420 9180420 20260110202101_I3wC2 UK00CA 2026-01-12T14:07:03.293Z 2026-01-19T15:16:01.405Z
9176925 9176925 20260110063958_XbT0x UK00CA 2026-01-11T14:10:21.305Z 2026-01-18T15:09:07.729Z
9176867 9176867 20260110063338_frhbr UK00CA 2026-01-11T14:10:12.896Z 2026-01-18T15:09:05.556Z
9176863 9176863 20260110063337_A5b2j UK00CA 2026-01-11T14:10:12.477Z 2026-01-18T15:09:05.450Z
9176693 9176693 20260110060605_r9zD5 UK00CA 2026-01-11T14:09:44.534Z 2026-01-18T15:08:49.311Z
9176650 9176650 20260110060132_Gfhlq UK00CA 2026-01-11T14:09:37.492Z 2026-01-18T15:08:47.422Z
9176525 9176525 20260110054042_hE1S4 UK00CA 2026-01-11T14:09:14.756Z 2026-01-18T15:08:42.453Z
9176476 9176476 20260110053612_WrtlD UK00CA 2026-01-11T14:09:08.379Z 2026-01-18T15:08:40.695Z
9176452 9176452 20260110053125_l3aWh UK00CA 2026-01-11T14:09:04.461Z 2026-01-18T15:08:39.713Z
9176175 9176175 20260110045820_5BH1S UK00CA 2026-01-11T14:08:22.129Z 2026-01-18T15:08:22.815Z
9175679 9175679 20260110032246_bay94 UK00CA 2026-01-11T14:07:03.387Z 2026-01-18T15:07:55.952Z
9175603 9175603 20260110030832_kPSky UK00CA 2026-01-11T14:06:52.994Z 2026-01-18T15:07:53.132Z
9174986 9174986 20260110003245_1AQZ6 UK00CA 2026-01-11T14:05:02.479Z 2026-01-18T15:07:20.537Z
9166370 9166370 20260107180341_ZOFzZ UK00CA 2026-01-09T14:02:53.921Z 2026-01-16T15:09:49.864Z
9163375 9163375 20260107062724_UHSyn UK00CA 2026-01-08T14:08:57.349Z 2026-01-13T15:03:11.170Z
9163351 9163351 20260107062627_httt0 UK00CA 2026-01-08T14:08:50.464Z 2026-01-13T15:03:10.262Z
9163337 9163337 20260107062312_PQjIr UK00CA 2026-01-08T14:08:47.091Z 2026-01-13T15:03:09.870Z
9163330 9163330 20260107062234_sdVtt UK00CA 2026-01-08T14:08:46.334Z 2026-01-13T15:03:09.687Z
9163224 9163224 20260107060930_3ncrS UK00CA 2026-01-08T14:08:33.056Z 2026-01-13T15:03:06.358Z
9163045 9163045 20260107053504_4i5Va UK00CA 2026-01-08T14:08:00.097Z 2026-01-13T15:02:59.517Z
9163009 9163009 20260107052243_sw4He UK00CA 2026-01-08T14:07:41.759Z 2026-01-13T15:02:51.281Z
9162968 9162968 20260107051342_K6bZ3 UK00CA 2026-01-08T14:07:35.023Z 2026-01-13T15:02:49.753Z
9162900 9162900 20260107045929_6O3wx UK00CA 2026-01-08T14:07:15.973Z 2026-01-13T15:02:44.900Z
9162888 9162888 20260107045341_d9DHd UK00CA 2026-01-08T14:07:10.719Z 2026-01-13T15:02:44.012Z
9162856 9162856 20260107044549_k7KTM UK00CA 2026-01-08T14:07:05.530Z 2026-01-13T15:02:42.552Z
9162816 9162816 20260107043935_2sjkW UK00CA 2026-01-08T14:06:58.821Z 2026-01-13T15:02:40.642Z
9162734 9162734 20260107042004_PxjcH UK00CA 2026-01-08T14:06:38.347Z 2026-01-13T15:02:36.813Z
9162715 9162715 20260107041702_OgYQQ UK00CA 2026-01-08T14:06:34.624Z 2026-01-13T15:02:35.890Z
9162705 9162705 20260107041528_W4mXd UK00CA 2026-01-08T14:06:32.118Z 2026-01-13T15:02:35.430Z
9162580 9162580 20260107033527_Jrhop UK00CA 2026-01-08T14:05:54.138Z 2026-01-13T15:02:20.187Z
9151878 9151878 20260105064951_HZ6Jj UK00CA 2026-01-06T14:14:58.152Z 2026-01-13T15:15:10.416Z
9151785 9151785 20260105063052_0YOvf UK00CA 2026-01-06T14:14:39.415Z 2026-01-13T15:15:05.323Z
9151761 9151761 20260105062831_LcUgd UK00CA 2026-01-06T14:14:35.572Z 2026-01-13T15:15:04.564Z
9151221 9151221 20260105045900_kDl6c UK00CA 2026-01-06T14:13:00.433Z 2026-01-13T15:14:32.290Z
9149587 9149587 20260104220810_u3NbS UK00CA 2026-01-06T14:06:11.867Z 2026-01-13T15:12:19.526Z
9149448 9149448 20260104211156_2hy2G UK00CA 2026-01-06T14:05:31.078Z 2026-01-13T15:12:11.819Z
9149378 9149378 20260104203210_ZiLbl UK00CA 2026-01-06T14:05:10.805Z 2026-01-13T15:12:07.278Z
9149374 9149374 20260104203010_3S2oc UK00CA 2026-01-06T14:05:10.122Z 2026-01-13T15:12:07.109Z
9149136 9149136 20260104185437_KLNUw UK00CA 2026-01-06T14:03:57.445Z 2026-01-13T15:11:43.861Z
9133937 9133937 20260102172403_0KleN UK00CA 2026-01-04T14:29:48.750Z 2026-01-09T14:51:06.336Z
9132465 9132465 20260103064321_OOjB0 UK00CA 2026-01-04T14:16:46.847Z 2026-01-10T15:01:31.845Z
9132209 9132209 20260103062349_8Ivuk UK00CA 2026-01-04T14:16:06.415Z 2026-01-10T15:01:16.958Z
9132124 9132124 20260103061935_j1IZL UK00CA 2026-01-04T14:15:54.088Z 2026-01-10T15:01:13.063Z
9131840 9131840 20260103055955_fatlF UK00CA 2026-01-04T14:15:01.008Z 2026-01-10T15:00:56.257Z
9131828 9131828 20260103055913_E6Cle UK00CA 2026-01-04T14:15:00.106Z 2026-01-10T15:00:55.704Z
9131757 9131757 20260103055155_gc6RD UK00CA 2026-01-04T14:14:50.077Z 2026-01-10T15:00:50.901Z

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