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,251 rows where station_code = "UK0029" 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
9243274 9243274 20260121040715_uKfdz UK0029 2026-01-22T14:21:10.376Z 2026-01-29T15:04:53.330Z
9243170 9243170 20260121035340_hRA3P UK0029 2026-01-22T14:20:50.432Z 2026-01-29T15:04:49.505Z
9243088 9243088 20260121034149_DhFw3 UK0029 2026-01-22T14:20:32.511Z 2026-01-29T15:04:46.133Z
9242441 9242441 20260121015135_e5HDT UK0029 2026-01-22T14:17:52.369Z 2026-01-29T15:03:58.994Z
9237902 9237902 20260120062149_RDlih UK0029 2026-01-21T14:28:01.812Z 2026-01-28T15:01:58.222Z
9237209 9237209 20260120045038_ykxiq UK0029 2026-01-21T14:25:41.609Z 2026-01-28T15:01:03.031Z
9234476 9234476 20260119214626_8EVXt UK0029 2026-01-21T14:14:39.189Z 2026-01-28T14:57:49.207Z
9234453 9234453 20260119213240_TVipm UK0029 2026-01-21T14:14:31.794Z 2026-01-28T14:57:47.300Z
9234143 9234143 20260119194747_SSOcv UK0029 2026-01-21T14:12:32.329Z 2026-01-28T14:57:17.365Z
9218060 9218060 20260116231755_NGzTh UK0029 2026-01-18T14:10:13.739Z 2026-01-25T14:57:57.078Z
9218052 9218052 20260116230850_9qqn9 UK0029 2026-01-18T14:10:11.677Z 2026-01-25T14:57:56.787Z
9217915 9217915 20260116204401_f1Rmx UK0029 2026-01-18T14:09:35.076Z 2026-01-25T14:57:51.852Z
9214276 9214276 20260116060539_wUV92 UK0029 2026-01-17T14:20:55.181Z 2026-01-24T15:13:27.734Z
9214221 9214221 20260116055441_xLpkm UK0029 2026-01-17T14:20:37.505Z 2026-01-24T15:13:23.557Z
9214096 9214096 20260116053358_2fz6C UK0029 2026-01-17T14:20:02.916Z 2026-01-24T15:13:05.740Z
9214028 9214028 20260116052318_QawlA UK0029 2026-01-17T14:19:42.710Z 2026-01-24T15:12:58.592Z
9213979 9213979 20260116051137_Fl3Z5 UK0029 2026-01-17T14:19:28.423Z 2026-01-24T15:12:55.795Z
9207974 9207974 20260115034138_oZMYp UK0029 2026-01-16T14:10:52.560Z 2026-01-22T15:03:57.750Z
9207815 9207815 20260115031250_Dv3XP UK0029 2026-01-16T14:10:13.757Z 2026-01-22T15:03:53.538Z
9207702 9207702 20260115024848_uWd9H UK0029 2026-01-16T14:09:44.203Z 2026-01-22T15:03:30.378Z
9207411 9207411 20260115013230_Yxhf8 UK0029 2026-01-16T14:08:39.829Z 2026-01-22T15:03:21.234Z
9207378 9207378 20260115011829_UgBIq UK0029 2026-01-16T14:08:31.093Z 2026-01-22T15:03:20.329Z
9207353 9207353 20260115010859_vfKP1 UK0029 2026-01-16T14:08:23.409Z 2026-01-22T15:03:19.661Z
9207182 9207182 20260114232856_Mrw39 UK0029 2026-01-16T14:07:34.095Z 2026-01-22T15:03:13.836Z
9204180 9204180 20260114061351_E85dN UK0029 2026-01-15T14:26:37.254Z 2026-01-22T15:10:21.894Z
9202001 9202001 20260114031001_9Nbwj UK0029 2026-01-15T14:20:14.092Z 2026-01-22T15:09:12.024Z
9199565 9199565 20260113202632_rqK7o UK0029 2026-01-15T14:11:30.033Z 2026-01-22T15:07:31.498Z
9195014 9195014 20260112235937_fCxGl UK0029 2026-01-14T14:11:42.929Z 2026-01-21T15:04:35.164Z
9194081 9194081 20260112173913_WKzpO UK0029 2026-01-14T14:07:09.378Z 2026-01-21T15:03:28.310Z
9189063 9189063 20260112024842_kd6Yt UK0029 2026-01-13T14:15:34.387Z 2026-01-20T15:22:37.212Z
9188198 9188198 20260111212211_CwyaO UK0029 2026-01-13T14:10:57.906Z 2026-01-20T15:21:26.702Z
9180195 9180195 20260110193321_F6VIU UK0029 2026-01-12T14:06:10.570Z 2026-01-19T15:15:50.849Z
9180157 9180157 20260110192310_qk3bh UK0029 2026-01-12T14:06:01.000Z 2026-01-19T15:15:48.949Z
9176688 9176688 20260110060402_NjYQd UK0029 2026-01-11T14:09:43.523Z 2026-01-18T15:08:48.895Z
9151873 9151873 20260105064805_FPELp UK0029 2026-01-06T14:14:56.998Z 2026-01-13T15:15:10.139Z
9151848 9151848 20260105064418_G811Y UK0029 2026-01-06T14:14:54.333Z 2026-01-13T15:15:09.174Z
9151618 9151618 20260105060322_6PZ86 UK0029 2026-01-06T14:14:10.243Z 2026-01-13T15:14:57.872Z
9151541 9151541 20260105054546_s8wwO UK0029 2026-01-06T14:13:57.961Z 2026-01-13T15:14:48.356Z
9151469 9151469 20260105053543_Kvo2t UK0029 2026-01-06T14:13:48.302Z 2026-01-13T15:14:45.888Z
9151338 9151338 20260105052000_f8rMj UK0029 2026-01-06T14:13:23.953Z 2026-01-13T15:14:38.629Z
9151271 9151271 20260105050549_GRJch UK0029 2026-01-06T14:13:08.755Z 2026-01-13T15:14:34.301Z
9151102 9151102 20260105044146_FHi93 UK0029 2026-01-06T14:12:36.210Z 2026-01-13T15:14:19.094Z
9151004 9151004 20260105041506_oBfVT UK0029 2026-01-06T14:12:17.176Z 2026-01-13T15:14:13.048Z
9146292 9146292 20260104034346_Il37Y UK0029 2026-01-05T14:22:04.414Z 2026-01-12T15:08:24.845Z
9146282 9146282 20260104034328_WOXqB UK0029 2026-01-05T14:22:03.381Z 2026-01-12T15:08:24.402Z
9134155 9134155 20260103175342_XTSxJ UK0029 2026-01-05T14:01:00.462Z 2026-01-12T14:59:10.838Z
9124427 9124427 20251231062814_3u7gz UK0029 2026-01-02T14:45:38.219Z 2026-01-08T15:11:56.862Z
9124220 9124220 20251231052957_0cezf UK0029 2026-01-02T14:43:17.014Z 2026-01-08T15:11:12.574Z
9115798 9115798 20251231053000_qR9us UK0029 2026-01-01T14:26:30.609Z 2026-01-08T15:11:12.899Z
9056888 9056888 20251227043846_kVWBG UK0029 2025-12-29T14:21:46.822Z 2026-01-04T15:29:15.947Z
9054917 9054917 20251227025820_2YfjJ UK0029 2025-12-29T14:16:43.494Z 2026-01-04T15:27:36.370Z
9054840 9054840 20251227025358_UV7Ju UK0029 2025-12-29T14:16:29.041Z 2026-01-04T15:27:34.130Z
9017667 9017667 20251220053941_1Rupi UK0029 2025-12-27T15:01:28.138Z 2025-12-29T15:23:32.755Z
9016292 9016292 20251220035204_4RQYJ UK0029 2025-12-27T14:59:39.324Z 2025-12-29T15:23:22.057Z
8993644 8993644 20251218230424_BPjYO UK0029 2025-12-26T14:53:21.369Z 2025-12-27T15:28:03.866Z
8984287 8984287 20251219231840_rvfVa UK0029 2025-12-26T14:30:35.054Z 2025-12-28T15:23:49.700Z
8977964 8977964 20251219060417_gmY21 UK0029 2025-12-26T14:14:04.401Z 2025-12-28T15:17:36.464Z
8977246 8977246 20251219043757_Mt8c3 UK0029 2025-12-26T14:12:15.659Z 2025-12-28T15:17:31.833Z
8977207 8977207 20251219043342_SUC31 UK0029 2025-12-26T14:12:11.139Z 2025-12-28T15:17:31.639Z
8976925 8976925 20251219040024_x30JF UK0029 2025-12-26T14:11:14.343Z 2025-12-28T15:17:29.287Z
8976448 8976448 20251219031321_I9em8 UK0029 2025-12-26T14:09:55.530Z 2025-12-28T15:17:25.727Z
8975940 8975940 20251219021334_YkvlU UK0029 2025-12-26T14:08:25.767Z 2025-12-28T15:17:21.541Z
8975139 8975139 20251220031642_5c29o UK0029 2025-12-26T14:06:15.098Z 2025-12-29T15:23:04.588Z
8969715 8969715 20251216203426_I6DQD UK0029 2025-12-25T14:51:39.526Z 2025-12-25T14:51:39.526Z
8893205 8893205 20251214021402_2KW7w UK0029 2025-12-22T14:11:53.822Z 2025-12-23T14:27:49.253Z
8888842 8888842 20251214013951_0ehOf UK0029 2025-12-22T14:11:34.514Z 2025-12-23T14:27:42.606Z
8825747 8825747 20251213023056_CYSqK UK0029 2025-12-17T14:59:19.778Z 2025-12-21T14:17:36.756Z
8810023 8810023 20251213054201_hwIG6 UK0029 2025-12-17T14:11:27.498Z 2025-12-23T14:18:40.008Z
8797005 8797005 20251213045909_SYP3K UK0029 2025-12-16T14:09:26.521Z 2025-12-23T14:17:50.438Z
8796558 8796558 20251213045123_J3oZz UK0029 2025-12-16T14:08:54.504Z 2025-12-23T14:17:46.534Z
8796512 8796512 20251213045101_oyWj2 UK0029 2025-12-16T14:08:54.046Z 2025-12-23T14:17:46.320Z
8793564 8793564 20251213041154_gXT2c UK0029 2025-12-16T14:06:03.640Z 2025-12-23T14:16:48.786Z
8793260 8793260 20251213040710_KnVmt UK0029 2025-12-16T14:05:39.495Z 2025-12-23T14:16:39.858Z
8792886 8792886 20251213040126_jtmR3 UK0029 2025-12-16T14:05:05.507Z 2025-12-23T14:16:35.527Z
8792242 8792242 20251213035214_3deIM UK0029 2025-12-16T14:04:24.715Z 2025-12-23T14:16:25.098Z
8792208 8792208 20251213035145_PbV2u UK0029 2025-12-16T14:04:22.689Z 2025-12-23T14:16:24.988Z
8791532 8791532 20251213034342_W2BPe UK0029 2025-12-16T14:03:37.033Z 2025-12-23T14:16:23.611Z
8789323 8789323 20251213030910_1VfWr UK0029 2025-12-15T14:39:39.166Z 2025-12-21T14:17:38.178Z
8787417 8787417 20251213024400_k3eso UK0029 2025-12-15T14:38:20.549Z 2025-12-21T14:17:37.333Z
8785921 8785921 20251213022250_b0E2X UK0029 2025-12-15T14:37:08.362Z 2025-12-21T14:17:36.471Z
8785307 8785307 20251213021339_0TFRF UK0029 2025-12-15T14:36:49.932Z 2025-12-21T14:17:36.099Z
8785256 8785256 20251213021323_RhHfA UK0029 2025-12-15T14:36:47.048Z 2025-12-21T14:17:36.082Z
8783903 8783903 20251213015300_fNR3z UK0029 2025-12-15T14:35:32.241Z 2025-12-21T14:17:35.277Z
8783199 8783199 20251213013921_I2c3q UK0029 2025-12-15T14:34:33.889Z 2025-12-21T14:17:34.788Z
8781200 8781200 20251213010959_UrXBs UK0029 2025-12-15T14:33:22.574Z 2025-12-21T14:17:33.658Z
8780946 8780946 20251213010743_QrOQR UK0029 2025-12-15T14:33:16.154Z 2025-12-21T14:17:33.534Z
8780878 8780878 20251213010643_nnNE2 UK0029 2025-12-15T14:33:15.004Z 2025-12-21T14:17:33.498Z
8778177 8778177 20251213002127_S031n UK0029 2025-12-15T14:31:03.765Z 2025-12-21T14:17:32.012Z
8772141 8772141 20251212215856_qwXe3 UK0029 2025-12-15T14:24:39.518Z 2025-12-21T14:17:28.331Z
8771114 8771114 20251212210923_BJZJU UK0029 2025-12-15T14:23:03.135Z 2025-12-21T14:17:27.617Z
8768897 8768897 20251212174904_wVRyq UK0029 2025-12-15T14:18:18.557Z 2025-12-21T14:17:26.353Z
8753413 8753413 20251210003103_3BAq2 UK0029 2025-12-13T15:41:43.191Z 2025-12-17T15:27:45.660Z
8753157 8753157 20251210001428_vvsvF UK0029 2025-12-13T15:41:37.432Z 2025-12-17T15:27:39.026Z
8752875 8752875 20251209234028_w6H2p UK0029 2025-12-13T15:41:06.295Z 2025-12-17T15:27:36.364Z
8752284 8752284 20251209224445_shPwx UK0029 2025-12-13T15:40:46.681Z 2025-12-17T15:27:27.351Z
8751453 8751453 20251209211148_JVEPJ UK0029 2025-12-13T15:39:38.851Z 2025-12-17T15:27:19.403Z
8751411 8751411 20251209210451_VeKGB UK0029 2025-12-13T15:39:37.082Z 2025-12-17T15:27:18.749Z
8750770 8750770 20251209192927_eMMJQ UK0029 2025-12-13T15:38:43.084Z 2025-12-13T15:38:43.084Z
8750509 8750509 20251209184416_t039x UK0029 2025-12-13T15:38:09.551Z 2025-12-17T15:26:28.882Z
8733796 8733796 20251211171228_xr4L0 UK0029 2025-12-13T14:49:24.386Z 2025-12-20T14:24:20.702Z

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