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,447 rows where station_code = "UK0080" 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
8679143 8679143 20251202190334_m23PN UK0080 2025-12-04T14:09:05.788Z 2025-12-06T14:25:57.290Z
8658161 8658161 20251130065859_rBEdl UK0080 2025-12-01T14:35:03.671Z 2025-12-06T14:50:28.744Z
8658065 8658065 20251130063342_3RmBD UK0080 2025-12-01T14:34:53.282Z 2025-12-06T14:50:26.077Z
8657922 8657922 20251130061907_1CP5k UK0080 2025-12-01T14:34:46.323Z 2025-12-06T14:50:24.199Z
8657650 8657650 20251130055622_B6QR0 UK0080 2025-12-01T14:34:35.952Z 2025-12-06T14:50:16.401Z
8657462 8657462 20251130054706_Bo1nk UK0080 2025-12-01T14:34:29.063Z 2025-12-06T14:50:02.239Z
8657215 8657215 20251130053345_xEdbh UK0080 2025-12-01T14:34:00.847Z 2025-12-06T14:49:45.877Z
8656943 8656943 20251130052017_gLVMo UK0080 2025-12-01T14:33:49.561Z 2025-12-06T14:49:43.348Z
8656710 8656710 20251130050636_9oZUP UK0080 2025-12-01T14:28:56.934Z 2025-12-06T14:49:39.121Z
8656643 8656643 20251130050430_WT1pd UK0080 2025-12-01T14:28:51.318Z 2025-12-06T14:49:38.042Z
8656040 8656040 20251130043202_njIc5 UK0080 2025-12-01T14:27:58.466Z 2025-12-06T14:49:30.061Z
8654816 8654816 20251130033412_5ncyq UK0080 2025-12-01T14:26:04.088Z 2025-12-06T14:48:48.780Z
8654679 8654679 20251130032518_F8beG UK0080 2025-12-01T14:25:43.497Z 2025-12-01T14:25:43.497Z
8654628 8654628 20251130032314_HAhlz UK0080 2025-12-01T14:25:38.688Z 2025-12-06T14:48:45.097Z
8654218 8654218 20251130030346_XyRVS UK0080 2025-12-01T14:24:58.618Z 2025-12-06T14:48:38.945Z
8654087 8654087 20251130025656_0g433 UK0080 2025-12-01T14:24:49.661Z 2025-12-06T14:48:37.076Z
8653718 8653718 20251130023757_2E5Lb UK0080 2025-12-01T14:24:07.456Z 2025-12-06T14:48:31.036Z
8653139 8653139 20251130015937_BXx4g UK0080 2025-12-01T14:22:52.439Z 2025-12-06T14:47:50.675Z
8652706 8652706 20251130012825_IxEAR UK0080 2025-12-01T14:22:01.051Z 2025-12-06T14:47:41.348Z
8652034 8652034 20251130004218_jyF1I UK0080 2025-12-01T14:20:30.309Z 2025-12-06T14:47:01.344Z
8651959 8651959 20251130003727_33Peu UK0080 2025-12-01T14:20:20.017Z 2025-12-06T14:46:56.773Z
8651896 8651896 20251130003223_es2Qu UK0080 2025-12-01T14:20:13.674Z 2025-12-06T14:46:55.872Z
8651625 8651625 20251130000254_3QN1s UK0080 2025-12-01T14:19:34.365Z 2025-12-06T14:46:49.584Z
8651163 8651163 20251129225427_m3HsV UK0080 2025-12-01T14:18:10.114Z 2025-12-06T14:46:41.021Z
8651159 8651159 20251129225336_c93nG UK0080 2025-12-01T14:18:09.183Z 2025-12-06T14:46:40.920Z
8650889 8650889 20251129215601_ZFjej UK0080 2025-12-01T14:17:27.463Z 2025-12-06T14:46:35.286Z
8650710 8650710 20251129211302_QstM5 UK0080 2025-12-01T14:17:01.247Z 2025-12-06T14:46:32.624Z
8650364 8650364 20251129200036_kfffV UK0080 2025-12-01T14:15:54.196Z 2025-12-06T14:45:54.942Z
8650211 8650211 20251129193940_spsLJ UK0080 2025-12-01T14:15:26.523Z 2025-12-06T14:45:50.652Z
8650059 8650059 20251129191424_3M3cA UK0080 2025-12-01T14:14:53.231Z 2025-12-06T14:45:46.695Z
8648132 8648132 20251129064338_agSVP UK0080 2025-11-30T14:29:39.170Z 2025-12-06T14:57:14.644Z
8647987 8647987 20251129061649_zn2Mz UK0080 2025-11-30T14:29:27.425Z 2025-12-06T14:57:05.634Z
8647920 8647920 20251129060318_m37sv UK0080 2025-11-30T14:29:23.579Z 2025-12-06T14:56:56.192Z
8647755 8647755 20251129052030_v4uAE UK0080 2025-11-30T14:28:51.850Z 2025-12-06T14:56:46.544Z
8647709 8647709 20251129051331_uTGQ5 UK0080 2025-11-30T14:28:47.366Z 2025-12-06T14:56:44.793Z
8646627 8646627 20251129023325_jxzt6 UK0080 2025-11-30T14:26:35.028Z 2025-12-06T14:56:21.246Z
8646532 8646532 20251129021750_Vmpqj UK0080 2025-11-30T14:26:07.398Z 2025-12-06T14:56:12.968Z
8609631 8609631 20251125235652_XtUmB UK0080 2025-11-27T14:18:44.288Z 2025-12-04T15:07:56.100Z
8607583 8607583 20251125210403_NgtlE UK0080 2025-11-27T14:13:58.838Z 2025-12-04T15:07:03.971Z
8607336 8607336 20251125204026_d6S4e UK0080 2025-11-27T14:13:22.684Z 2025-12-04T15:07:00.585Z
8606920 8606920 20251125195545_2GvNs UK0080 2025-11-27T14:11:48.091Z 2025-12-04T15:06:52.151Z
8606735 8606735 20251125193359_0SZ4V UK0080 2025-11-27T14:11:12.654Z 2025-12-04T15:06:49.527Z
8606449 8606449 20251125185617_M57XY UK0080 2025-11-27T14:10:17.661Z 2025-12-04T15:06:45.627Z
8606183 8606183 20251125181132_LZWz1 UK0080 2025-11-27T14:09:18.494Z 2025-12-04T15:06:30.586Z
8605903 8605903 20251125172950_hLcfX UK0080 2025-11-27T14:08:14.584Z 2025-12-04T15:05:49.844Z
8603726 8603726 20251125063110_2mppk UK0080 2025-11-26T14:27:44.271Z 2025-12-02T15:09:36.948Z
8603018 8603018 20251125053821_eF6wq UK0080 2025-11-26T14:26:35.376Z 2025-12-02T15:09:33.970Z
8602866 8602866 20251125052903_b48VZ UK0080 2025-11-26T14:26:25.219Z 2025-12-02T15:09:33.263Z
8602842 8602842 20251125052450_wV5SF UK0080 2025-11-26T14:26:23.648Z 2025-12-02T15:09:33.092Z
8602506 8602506 20251125045959_IcgEY UK0080 2025-11-26T14:26:04.456Z 2025-12-02T15:09:31.282Z
8602342 8602342 20251125044842_2GLXQ UK0080 2025-11-26T14:25:34.064Z 2025-12-02T15:09:30.515Z
8602288 8602288 20251125044613_Su93n UK0080 2025-11-26T14:25:29.831Z 2025-12-02T15:09:30.259Z
8602282 8602282 20251125044603_w2csR UK0080 2025-11-26T14:25:29.449Z 2025-12-02T15:09:30.219Z
8602043 8602043 20251125043411_yJILj UK0080 2025-11-26T14:25:18.421Z 2025-12-02T15:09:29.244Z
8602014 8602014 20251125043212_IsasM UK0080 2025-11-26T14:25:17.325Z 2025-12-02T15:09:29.124Z
8601970 8601970 20251125042843_zH42z UK0080 2025-11-26T14:25:14.331Z 2025-12-02T15:09:29.014Z
8601821 8601821 20251125041932_3HkkO UK0080 2025-11-26T14:24:47.472Z 2025-12-02T15:09:25.880Z
8601684 8601684 20251125040920_Y216l UK0080 2025-11-26T14:24:36.080Z 2025-12-02T15:09:18.813Z
8601657 8601657 20251125040500_36wE2 UK0080 2025-11-26T14:24:34.279Z 2025-12-02T15:09:17.406Z
8601593 8601593 20251125035953_o67Cc UK0080 2025-11-26T14:24:29.240Z 2025-12-02T15:09:16.309Z
8600952 8600952 20251125032623_Kn17w UK0080 2025-11-26T14:23:16.849Z 2025-12-02T15:08:53.240Z
8600565 8600565 20251125030745_Th23n UK0080 2025-11-26T14:22:48.127Z 2025-12-02T15:08:47.006Z
8599629 8599629 20251125021300_ike1Y UK0080 2025-11-26T14:21:20.601Z 2025-12-02T15:08:30.631Z
8599623 8599623 20251125021245_hiYdu UK0080 2025-11-26T14:21:20.020Z 2025-12-02T15:08:30.608Z
8599234 8599234 20251125015526_8FnkI UK0080 2025-11-26T14:20:41.741Z 2025-12-02T15:08:21.760Z
8599014 8599014 20251125014129_v12Pw UK0080 2025-11-26T14:20:12.900Z 2025-12-02T15:08:17.089Z
8598817 8598817 20251125012850_0nLnX UK0080 2025-11-26T14:19:55.520Z 2025-12-02T15:08:09.464Z
8598785 8598785 20251125012405_biV0h UK0080 2025-11-26T14:19:52.620Z 2025-12-02T15:08:08.779Z
8598595 8598595 20251125010735_bODth UK0080 2025-11-26T14:19:18.551Z 2025-12-02T15:08:01.182Z
8598449 8598449 20251125005736_lmzu2 UK0080 2025-11-26T14:19:07.355Z 2025-12-02T15:07:54.655Z
8598293 8598293 20251125004803_Yj2Uh UK0080 2025-11-26T14:18:35.156Z 2025-12-02T15:07:51.741Z
8598068 8598068 20251125003225_lj1Xo UK0080 2025-11-26T14:18:16.742Z 2025-12-02T15:07:44.897Z
8598065 8598065 20251125003130_1WXX1 UK0080 2025-11-26T14:18:15.654Z 2025-12-02T15:07:44.852Z
8597863 8597863 20251125001507_wv78N UK0080 2025-11-26T14:17:47.591Z 2025-12-02T15:07:41.187Z
8597689 8597689 20251125000103_4ejEl UK0080 2025-11-26T14:17:21.609Z 2025-12-02T15:07:39.750Z
8597646 8597646 20251124235647_1y299 UK0080 2025-11-26T14:17:16.241Z 2025-12-02T15:07:39.074Z
8597629 8597629 20251124235321_jMj23 UK0080 2025-11-26T14:17:13.484Z 2025-12-02T15:07:38.274Z
8597572 8597572 20251124234925_jXsTF UK0080 2025-11-26T14:17:09.894Z 2025-12-02T15:07:37.810Z
8597135 8597135 20251124230534_xuhLn UK0080 2025-11-26T14:16:15.189Z 2025-12-02T15:07:23.451Z
8596822 8596822 20251124221253_r2T6h UK0080 2025-11-26T14:15:23.600Z 2025-12-02T15:07:15.145Z
8596705 8596705 20251124215821_Ejv4I UK0080 2025-11-26T14:15:10.230Z 2025-12-02T15:07:07.435Z
8596697 8596697 20251124215753_4GSbf UK0080 2025-11-26T14:15:08.998Z 2025-12-02T15:07:05.086Z
8596696 8596696 20251124215712_0KLgJ UK0080 2025-11-26T14:15:08.836Z 2025-12-02T15:07:04.949Z
8596010 8596010 20251124192635_sFO54 UK0080 2025-11-26T14:13:20.410Z 2025-12-02T15:06:28.472Z
8595986 8595986 20251124192132_lexjk UK0080 2025-11-26T14:13:16.535Z 2025-12-02T15:06:24.735Z
8595920 8595920 20251124190132_OXrOQ UK0080 2025-11-26T14:12:56.230Z 2025-12-02T15:06:21.749Z
8595833 8595833 20251124183750_wd5C9 UK0080 2025-11-26T14:12:44.363Z 2025-12-02T15:06:14.788Z
8595807 8595807 20251124183324_3ZbBz UK0080 2025-11-26T14:12:31.983Z 2025-12-02T15:06:12.306Z
8592326 8592326 20251124064427_1XFUr UK0080 2025-11-25T14:26:31.481Z 2025-12-02T15:13:03.242Z
8592308 8592308 20251124063558_5IhFz UK0080 2025-11-25T14:26:20.795Z 2025-12-02T15:13:03.124Z
8592303 8592303 20251124063509_LanBw UK0080 2025-11-25T14:26:18.793Z 2025-12-02T15:13:03.100Z
8592101 8592101 20251124054801_1K8uc UK0080 2025-11-25T14:25:52.470Z 2025-12-02T15:13:01.897Z
8592006 8592006 20251124053234_2nF8e UK0080 2025-11-25T14:25:39.365Z 2025-12-02T15:13:01.381Z
8591434 8591434 20251124041416_9NQj6 UK0080 2025-11-25T14:24:22.288Z 2025-12-02T15:12:58.718Z
8588501 8588501 20251124000210_ZI0yV UK0080 2025-11-25T14:17:39.696Z 2025-12-02T15:11:47.569Z
8587749 8587749 20251123224014_dBODt UK0080 2025-11-25T14:15:59.690Z 2025-12-02T15:11:19.538Z
8587367 8587367 20251123215630_qQxln UK0080 2025-11-25T14:15:05.269Z 2025-12-02T15:11:11.537Z
8574460 8574460 20251122065259_8RmGQ UK0080 2025-11-23T14:43:36.170Z 2025-11-30T15:07:09.524Z
8574409 8574409 20251122062556_roi2G UK0080 2025-11-23T14:43:30.170Z 2025-11-30T15:07:08.100Z
8574403 8574403 20251122062132_NHMzr UK0080 2025-11-23T14:43:26.850Z 2025-11-30T15:07:08.093Z

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