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

876 rows where station_code = "UK00C0" 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
9200296 9200296 20260113233756_0VpWX UK00C0 2026-01-15T14:14:38.815Z 2026-01-22T15:08:13.402Z
9162232 9162232 20260107005740_Lk3lN UK00C0 2026-01-08T14:03:50.231Z 2026-01-13T15:01:48.052Z
9162189 9162189 20260107001012_87OvB UK00C0 2026-01-08T14:03:26.536Z 2026-01-13T15:01:44.034Z
9162170 9162170 20260106234848_Oy5Tb UK00C0 2026-01-08T14:03:19.342Z 2026-01-13T15:01:41.866Z
9162164 9162164 20260106234839_Xwz11 UK00C0 2026-01-08T14:03:18.386Z 2026-01-13T15:01:41.554Z
9158771 9158771 20260106002334_SLuGf UK00C0 2026-01-07T14:07:15.049Z 2026-01-13T15:07:45.794Z
9153174 9153174 20260103233459_XJUg3 UK00C0 2026-01-06T14:25:04.866Z 2026-01-12T15:03:34.260Z
9148378 9148378 20260103174125_vZQSx UK00C0 2026-01-05T14:30:27.540Z 2026-01-10T15:04:28.402Z
9139614 9139614 20260103233551_QTJar UK00C0 2026-01-05T14:11:51.257Z 2026-01-12T15:03:34.880Z
9139596 9139596 20260103233459_6VdWK UK00C0 2026-01-05T14:11:50.216Z 2026-01-05T14:30:32.670Z
9139348 9139348 20260103232919_vZPAM UK00C0 2026-01-05T14:11:31.263Z 2026-01-12T15:03:26.438Z
9139110 9139110 20260103231225_ZDZOU UK00C0 2026-01-05T14:11:15.298Z 2026-01-12T15:03:20.986Z
9138916 9138916 20260103230034_qvUXu UK00C0 2026-01-05T14:10:48.065Z 2026-01-12T15:03:15.631Z
9138470 9138470 20260103222717_mR6UV UK00C0 2026-01-05T14:09:57.961Z 2026-01-12T15:02:50.159Z
9138249 9138249 20260103221309_dpzVi UK00C0 2026-01-05T14:09:44.025Z 2026-01-12T15:02:44.361Z
9138132 9138132 20260103220152_LzC2I UK00C0 2026-01-05T14:09:25.210Z 2026-01-12T15:02:40.839Z
9137656 9137656 20260103212226_08grM UK00C0 2026-01-05T14:08:47.673Z 2026-01-12T15:02:15.633Z
9136697 9136697 20260103201104_j1diT UK00C0 2026-01-05T14:07:10.913Z 2026-01-12T15:01:36.978Z
9135829 9135829 20260103191526_hrzck UK00C0 2026-01-05T14:05:24.098Z 2026-01-12T15:00:48.320Z
9134517 9134517 20260103181033_dOiSD UK00C0 2026-01-05T14:02:11.385Z 2026-01-12T14:59:35.566Z
9134479 9134479 20260103180935_ncb4f UK00C0 2026-01-05T14:02:06.119Z 2026-01-12T14:59:34.421Z
9115425 9115425 20251231050532_O9rYs UK00C0 2026-01-01T14:25:21.156Z 2026-01-08T15:10:47.146Z
9115155 9115155 20251231045124_9qIso UK00C0 2026-01-01T14:24:31.496Z 2026-01-08T15:10:27.928Z
9114969 9114969 20251231043756_vTp4c UK00C0 2026-01-01T14:23:55.424Z 2026-01-08T15:10:16.860Z
9114279 9114279 20251231041014_EL4WL UK00C0 2026-01-01T14:22:02.599Z 2026-01-08T15:09:40.778Z
9113942 9113942 20251231035602_RJtbE UK00C0 2026-01-01T14:20:55.634Z 2026-01-08T15:09:17.009Z
9113460 9113460 20251231033058_kXPE3 UK00C0 2026-01-01T14:19:03.625Z 2026-01-08T15:08:45.536Z
9113224 9113224 20251231031700_P5YUa UK00C0 2026-01-01T14:18:00.165Z 2026-01-08T15:08:35.229Z
9099794 9099794 20251225185822_Oaufi UK00C0 2025-12-30T15:36:06.480Z 2026-01-02T15:48:03.435Z
9099307 9099307 20251226201432_qWkoQ UK00C0 2025-12-30T15:23:18.627Z 2026-01-03T15:43:39.324Z
9093225 9093225 20251227044928_bdLom UK00C0 2025-12-30T15:02:25.377Z 2026-01-04T15:29:25.361Z
9093086 9093086 20251227042338_rTrKT UK00C0 2025-12-30T15:01:55.253Z 2026-01-04T15:29:05.981Z
9093078 9093078 20251227042335_63ZAa UK00C0 2025-12-30T15:01:51.963Z 2026-01-04T15:29:05.783Z
9092458 9092458 20251227011616_XNpKc UK00C0 2025-12-30T14:58:54.054Z 2026-01-04T15:25:47.736Z
9092083 9092083 20251226223707_Kc3TO UK00C0 2025-12-30T14:56:44.072Z 2025-12-30T14:56:44.072Z
9075409 9075409 20251225213325_uBnUn UK00C0 2025-12-29T15:02:03.578Z 2026-01-02T15:48:51.384Z
9075251 9075251 20251225212041_ZyL3H UK00C0 2025-12-29T15:01:38.086Z 2026-01-02T15:48:47.165Z
9074538 9074538 20251225201054_LSuWa UK00C0 2025-12-29T15:01:07.476Z 2026-01-02T15:48:33.088Z
9074513 9074513 20251225200952_wVc5Q UK00C0 2025-12-29T15:00:58.047Z 2026-01-02T15:48:32.646Z
9073986 9073986 20251225185822_mJ9Gb UK00C0 2025-12-29T15:00:01.386Z 2026-01-02T15:48:03.908Z
9073857 9073857 20251225183708_TqGPr UK00C0 2025-12-29T14:59:55.821Z 2026-01-02T15:47:59.213Z
9072087 9072087 20251226201803_raaoi UK00C0 2025-12-29T14:50:22.244Z 2026-01-03T15:43:41.167Z
9072069 9072069 20251226201432_49gtb UK00C0 2025-12-29T14:50:21.534Z 2025-12-29T14:51:19.179Z
9071639 9071639 20251226190640_qErIR UK00C0 2025-12-29T14:49:40.241Z 2026-01-03T15:43:05.320Z
9071498 9071498 20251226184700_Rgs22 UK00C0 2025-12-29T14:49:33.225Z 2026-01-03T15:42:57.384Z
9066810 9066810 20251226065230_4ZSln UK00C0 2025-12-29T14:40:33.307Z 2026-01-03T15:38:04.353Z
9066759 9066759 20251226064604_sdo9V UK00C0 2025-12-29T14:40:30.134Z 2026-01-03T15:38:01.649Z
9066704 9066704 20251226064039_Dbbgr UK00C0 2025-12-29T14:40:26.857Z 2026-01-03T15:37:59.439Z
9066590 9066590 20251226062540_NHs3M UK00C0 2025-12-29T14:40:21.206Z 2026-01-03T15:37:54.230Z
9066390 9066390 20251226061119_QOxAy UK00C0 2025-12-29T14:39:56.094Z 2026-01-03T15:37:48.584Z
9065815 9065815 20251226053239_j30KW UK00C0 2025-12-29T14:39:05.363Z 2026-01-03T15:37:20.167Z
9065690 9065690 20251226052416_dOVDD UK00C0 2025-12-29T14:38:58.928Z 2026-01-03T15:37:12.134Z
9065223 9065223 20251226050048_W8Zzd UK00C0 2025-12-29T14:38:18.758Z 2026-01-03T15:36:48.334Z
9065186 9065186 20251226045830_rVKy5 UK00C0 2025-12-29T14:38:05.129Z 2026-01-03T15:36:47.397Z
9064840 9064840 20251226043610_x2uD9 UK00C0 2025-12-29T14:37:41.223Z 2026-01-03T15:36:28.231Z
9063757 9063757 20251226033104_xVLQ8 UK00C0 2025-12-29T14:35:52.538Z 2026-01-03T15:35:38.591Z
9063649 9063649 20251226032546_Je5Im UK00C0 2025-12-29T14:35:36.962Z 2026-01-03T15:35:25.178Z
9063374 9063374 20251226030819_LyDG3 UK00C0 2025-12-29T14:35:17.329Z 2026-01-03T15:35:14.467Z
9063225 9063225 20251226030228_joVWm UK00C0 2025-12-29T14:34:51.839Z 2026-01-03T15:35:07.857Z
9063207 9063207 20251226030206_ZFx77 UK00C0 2025-12-29T14:34:49.947Z 2025-12-29T14:51:14.470Z
9061367 9061367 20251226005502_tAvGg UK00C0 2025-12-29T14:31:06.325Z 2026-01-03T15:33:34.774Z
9060841 9060841 20251226001459_rgj3D UK00C0 2025-12-29T14:30:12.130Z 2026-01-03T15:33:09.977Z
9060446 9060446 20251225235052_lzL0d UK00C0 2025-12-29T14:29:32.846Z 2026-01-03T15:32:56.488Z
9060212 9060212 20251225233449_obo2p UK00C0 2025-12-29T14:29:02.530Z 2026-01-03T15:32:38.519Z
9058911 9058911 20251227062459_JPzaB UK00C0 2025-12-29T14:25:36.226Z 2026-01-04T15:30:36.312Z
9058507 9058507 20251227055629_8kf9s UK00C0 2025-12-29T14:24:50.348Z 2026-01-04T15:30:24.564Z
9058129 9058129 20251227053652_IjB2m UK00C0 2025-12-29T14:24:18.167Z 2026-01-04T15:30:15.499Z
9057864 9057864 20251227052444_yI7u5 UK00C0 2025-12-29T14:23:48.624Z 2026-01-04T15:29:58.152Z
9057199 9057199 20251227045203_lxhwy UK00C0 2025-12-29T14:22:30.554Z 2026-01-04T15:29:26.944Z
9057160 9057160 20251227044928_De1BN UK00C0 2025-12-29T14:22:25.721Z 2026-01-04T15:29:25.207Z
9056719 9056719 20251227042853_0rBMw UK00C0 2025-12-29T14:21:25.871Z 2026-01-04T15:29:09.521Z
9056576 9056576 20251227042336_32yVI UK00C0 2025-12-29T14:21:06.476Z 2026-01-04T15:29:05.877Z
9055970 9055970 20251227035005_UDTNB UK00C0 2025-12-29T14:19:31.084Z 2026-01-04T15:28:34.962Z
9055841 9055841 20251227034223_2aOzz UK00C0 2025-12-29T14:19:06.727Z 2026-01-04T15:28:19.690Z
9055552 9055552 20251227032937_Ek0DD UK00C0 2025-12-29T14:18:26.863Z 2026-01-04T15:28:08.567Z
9055051 9055051 20251227030447_vTm7r UK00C0 2025-12-29T14:16:59.348Z 2026-01-04T15:27:39.994Z
9054530 9054530 20251227024124_qaqrm UK00C0 2025-12-29T14:15:49.895Z 2026-01-04T15:27:10.607Z
9053647 9053647 20251227015344_lSAhV UK00C0 2025-12-29T14:13:09.994Z 2025-12-30T14:59:32.064Z
9052916 9052916 20251227011826_CJhkz UK00C0 2025-12-29T14:11:19.617Z 2026-01-04T15:25:49.667Z
9052840 9052840 20251227011616_ondQQ UK00C0 2025-12-29T14:11:11.169Z 2025-12-29T14:51:08.035Z
9052613 9052613 20251227005940_uUc93 UK00C0 2025-12-29T14:10:24.577Z 2026-01-04T15:25:38.118Z
9052130 9052130 20251227003444_kSUnF UK00C0 2025-12-29T14:09:07.805Z 2026-01-04T15:25:13.160Z
9051826 9051826 20251227001312_l3KCn UK00C0 2025-12-29T14:08:04.449Z 2026-01-04T15:24:53.758Z
9051340 9051340 20251226233625_jsIkh UK00C0 2025-12-29T14:06:31.977Z 2026-01-04T15:24:33.446Z
9051224 9051224 20251226233013_VGRfG UK00C0 2025-12-29T14:06:08.951Z 2026-01-04T15:24:22.195Z
9051057 9051057 20251226231526_jnDZg UK00C0 2025-12-29T14:05:31.017Z 2026-01-04T15:24:14.104Z
9050563 9050563 20251226223707_cznVy UK00C0 2025-12-29T14:03:44.166Z 2025-12-29T14:51:07.373Z
9050253 9050253 20251226220558_KEii1 UK00C0 2025-12-29T14:02:16.154Z 2026-01-04T15:23:31.924Z
9042867 9042867 20251224191113_bJNoD UK00C0 2025-12-28T14:46:39.802Z 2026-01-01T15:57:11.294Z
9042855 9042855 20251224191112_PMvls UK00C0 2025-12-28T14:46:39.623Z 2025-12-29T15:07:50.377Z
9037351 9037351 20251224064702_xf9H6 UK00C0 2025-12-28T14:36:56.696Z 2026-01-01T15:54:46.826Z
9037327 9037327 20251224064318_o2BNV UK00C0 2025-12-28T14:36:55.196Z 2026-01-01T15:54:46.592Z
9037058 9037058 20251224055753_Dn30G UK00C0 2025-12-28T14:36:26.962Z 2026-01-01T15:54:43.574Z
9032253 9032253 20251225061202_ac6o4 UK00C0 2025-12-28T14:22:25.311Z 2026-01-02T15:45:41.262Z
9031197 9031197 20251225052029_b8Ab5 UK00C0 2025-12-28T14:20:30.365Z 2026-01-02T15:45:07.209Z
9016962 9016962 20251220044348_0CyJH UK00C0 2025-12-27T15:01:03.202Z 2025-12-29T15:23:27.420Z
9016900 9016900 20251220044034_36Asg UK00C0 2025-12-27T15:00:50.767Z 2025-12-29T15:23:26.892Z
9016823 9016823 20251220043343_EEFY1 UK00C0 2025-12-27T15:00:27.957Z 2025-12-29T15:23:26.211Z
9016247 9016247 20251220034829_1MW47 UK00C0 2025-12-27T14:59:37.765Z 2025-12-29T15:23:21.646Z
9016161 9016161 20251220034450_PCwDU UK00C0 2025-12-27T14:59:34.935Z 2025-12-29T15:23:21.154Z

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