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

3,462 rows where station_code = "UK008D" 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
9608817 9608817 20260404014528_F8krG UK008D 2026-04-05T12:11:50.765Z 2026-04-06T12:20:40.663Z
9602530 9602530 20260331224457_n5aga UK008D 2026-04-02T12:09:12.781Z 2026-04-06T12:29:16.996Z
9594831 9594831 20260329004013_4jjvv UK008D 2026-03-30T12:10:24.332Z 2026-04-06T12:40:17.497Z
9592803 9592803 20260329032421_xz4dM UK008D 2026-03-30T12:01:57.045Z 2026-04-06T12:34:28.619Z
9592295 9592295 20260329014504_oJdK6 UK008D 2026-03-30T12:00:35.475Z 2026-04-06T12:33:59.121Z
9589897 9589897 20260328041640_2fScY UK008D 2026-03-29T12:01:42.790Z 2026-04-06T12:37:37.482Z
9589534 9589534 20260328034437_3N1A1 UK008D 2026-03-29T12:01:24.663Z 2026-04-06T12:37:27.128Z
9589052 9589052 20260328021921_OTnDO UK008D 2026-03-29T12:00:41.213Z 2026-04-06T12:37:00.868Z
9584650 9584650 20260325212810_SuSmQ UK008D 2026-03-27T12:15:54.637Z 2026-04-03T12:39:25.511Z
9582035 9582035 20260326042255_ceDiy UK008D 2026-03-27T12:04:26.564Z 2026-04-04T12:39:35.492Z
9581706 9581706 20260326034648_I3GDI UK008D 2026-03-27T12:03:43.251Z 2026-04-04T12:39:16.071Z
9581252 9581252 20260326024359_3RV1o UK008D 2026-03-27T12:02:32.701Z 2026-04-04T12:38:49.066Z
9581149 9581149 20260326023003_rdGbr UK008D 2026-03-27T12:02:15.123Z 2026-04-04T12:38:44.123Z
9580106 9580106 20260325000458_9ClUt UK008D 2026-03-26T12:15:05.851Z 2026-04-02T12:37:42.336Z
9562151 9562151 20260323013745_5sBi6 UK008D 2026-03-24T12:02:18.627Z 2026-03-31T12:26:02.395Z
9561248 9561248 20260321231207_Fomo6 UK008D 2026-03-23T12:12:14.799Z 2026-03-29T12:21:05.913Z
9561240 9561240 20260321231207_9SltZ UK008D 2026-03-23T12:12:14.742Z 2026-03-29T12:21:05.902Z
9561123 9561123 20260321230307_yNYQL UK008D 2026-03-23T12:12:11.993Z 2026-03-29T12:21:05.261Z
9561063 9561063 20260321225158_dsu3T UK008D 2026-03-23T12:12:10.919Z 2026-03-29T12:21:04.963Z
9560651 9560651 20260321215623_wHXNZ UK008D 2026-03-23T12:12:00.264Z 2026-03-29T12:21:01.940Z
9560263 9560263 20260321205504_o8ZeS UK008D 2026-03-23T12:11:40.790Z 2026-03-29T12:20:58.859Z
9559938 9559938 20260321201236_OpWN9 UK008D 2026-03-23T12:11:34.232Z 2026-03-29T12:20:56.706Z
9555138 9555138 20260322041001_DRLrz UK008D 2026-03-23T12:03:11.636Z 2026-03-30T12:28:14.966Z
9555092 9555092 20260322040324_FGCGC UK008D 2026-03-23T12:03:09.716Z 2026-03-30T12:28:14.351Z
9554568 9554568 20260322031759_3yktZ UK008D 2026-03-23T12:02:41.129Z 2026-03-30T12:28:05.760Z
9554077 9554077 20260322023709_fA41B UK008D 2026-03-23T12:02:12.554Z 2026-03-30T12:27:57.892Z
9553493 9553493 20260322014547_jLmKy UK008D 2026-03-23T12:01:34.406Z 2026-03-30T12:27:42.224Z
9552803 9552803 20260322004441_OaShs UK008D 2026-03-23T12:00:52.873Z 2026-03-30T12:27:30.607Z
9552378 9552378 20260321235806_OqLBC UK008D 2026-03-23T12:00:19.111Z 2026-03-30T12:27:23.079Z
9543594 9543594 20260321042503_QgH7F UK008D 2026-03-22T12:04:14.400Z 2026-03-29T12:19:09.215Z
9543274 9543274 20260321032112_XTO1D UK008D 2026-03-22T12:03:15.165Z 2026-03-29T12:19:05.402Z
9534291 9534291 20260320034005_MkxGP UK008D 2026-03-21T12:07:38.495Z 2026-03-28T12:34:17.041Z
9533154 9533154 20260320020416_PQ3U2 UK008D 2026-03-21T12:04:36.043Z 2026-03-28T12:33:49.317Z
9532012 9532012 20260320000744_k5utO UK008D 2026-03-21T12:01:25.239Z 2026-03-28T12:33:23.725Z
9531369 9531369 20260318230117_R3MQu UK008D 2026-03-20T12:25:08.515Z 2026-03-26T12:39:19.053Z
9520389 9520389 20260319031248_z2Q62 UK008D 2026-03-20T12:06:18.876Z 2026-03-27T12:40:42.553Z
9517061 9517061 20260317223530_LN9Kq UK008D 2026-03-19T12:27:09.067Z 2026-03-25T12:43:08.414Z
9509125 9509125 20260318012722_CSZO0 UK008D 2026-03-19T12:04:36.474Z 2026-03-26T12:37:03.359Z
9509117 9509117 20260318012722_MVIYn UK008D 2026-03-19T12:04:36.066Z 2026-03-26T12:37:03.329Z
9508979 9508979 20260318011918_vsyxe UK008D 2026-03-19T12:04:13.133Z 2026-03-26T12:37:02.313Z
9508542 9508542 20260318010244_oUwja UK008D 2026-03-19T12:03:18.239Z 2026-03-26T12:36:59.208Z
9508385 9508385 20260318005038_hz12b UK008D 2026-03-19T12:02:59.093Z 2026-03-26T12:36:58.171Z
9507762 9507762 20260317234045_Z2BjB UK008D 2026-03-19T12:01:12.301Z 2026-03-26T12:36:53.294Z
9494334 9494334 20260316015726_YwmOz UK008D 2026-03-17T12:03:39.762Z 2026-03-24T12:40:46.978Z
9492655 9492655 20260314213325_BzDKw UK008D 2026-03-16T12:28:54.896Z 2026-03-22T12:42:53.769Z
9485699 9485699 20260315034156_f2vLJ UK008D 2026-03-16T12:07:19.152Z 2026-03-23T12:21:53.530Z
9485465 9485465 20260315030906_cx3R5 UK008D 2026-03-16T12:06:31.347Z 2026-03-23T12:21:52.349Z
9484548 9484548 20260315005906_ESD4j UK008D 2026-03-16T12:03:17.393Z 2026-03-23T12:21:47.250Z
9484208 9484208 20260315000424_0DbdS UK008D 2026-03-16T12:01:57.620Z 2026-03-23T12:21:45.824Z
9483657 9483657 20260314230240_3d3ng UK008D 2026-03-16T12:00:21.869Z 2026-03-23T12:21:43.504Z
9477450 9477450 20260314045805_DHql3 UK008D 2026-03-15T12:08:19.785Z 2026-03-22T12:42:02.849Z
9475380 9475380 20260314012012_mjn5w UK008D 2026-03-15T12:02:59.996Z 2026-03-22T12:41:37.399Z
9467645 9467645 20260311222834_Bvq2c UK008D 2026-03-13T12:19:38.511Z 2026-03-19T12:45:53.973Z
9463529 9463529 20260312020508_YqJVm UK008D 2026-03-13T12:04:27.277Z 2026-03-20T12:36:23.141Z
9462454 9462454 20260311232025_eVsjR UK008D 2026-03-13T12:01:04.150Z 2026-03-20T12:36:16.091Z
9425933 9425933 20260305012242_cPhKv UK008D 2026-03-06T14:02:28.197Z 2026-03-13T12:34:40.273Z
9425479 9425479 20260303220001_zkb62 UK008D 2026-03-05T14:15:09.946Z 2026-03-11T12:29:05.039Z
9415793 9415793 20260302040731_v3QOh UK008D 2026-03-03T14:01:38.528Z 2026-03-10T12:35:50.442Z
9395013 9395013 20260224223559_261C4 UK008D 2026-02-26T14:20:59.526Z 2026-03-04T14:19:29.149Z
9392203 9392203 20260225035226_6xq2c UK008D 2026-02-26T14:06:45.505Z 2026-03-05T14:36:51.509Z
9390906 9390906 20260225013904_LEZYG UK008D 2026-02-26T14:02:53.218Z 2026-03-05T14:35:59.426Z
9390220 9390220 20260225000052_71r1P UK008D 2026-02-26T14:00:49.589Z 2026-03-05T14:35:35.552Z
9373456 9373456 20260223030852_oqIdi UK008D 2026-02-24T14:03:01.732Z 2026-03-03T14:31:03.588Z
9373260 9373260 20260223023500_2jimJ UK008D 2026-02-24T14:02:33.064Z 2026-03-03T14:31:00.478Z
9373147 9373147 20260223021632_VUxh0 UK008D 2026-02-24T14:02:18.934Z 2026-03-03T14:30:54.708Z
9373119 9373119 20260223021329_Sy22b UK008D 2026-02-24T14:02:14.805Z 2026-03-03T14:30:52.321Z
9372563 9372563 20260223003310_6rg24 UK008D 2026-02-24T14:00:51.788Z 2026-03-03T14:30:42.290Z
9364666 9364666 20260220233616_vXF2V UK008D 2026-02-22T14:21:56.366Z 2026-03-01T14:22:55.968Z
9340413 9340413 20260217000509_aYsrE UK008D 2026-02-18T14:24:49.875Z 2026-02-25T14:42:54.064Z
9340351 9340351 20260216235206_hMZs4 UK008D 2026-02-18T14:24:42.199Z 2026-02-25T14:42:53.542Z
9340340 9340340 20260216234956_5h63B UK008D 2026-02-18T14:24:40.461Z 2026-02-25T14:42:53.441Z
9340325 9340325 20260216234523_a55aW UK008D 2026-02-18T14:24:38.273Z 2026-02-25T14:42:53.306Z
9340157 9340157 20260216230540_85UCn UK008D 2026-02-18T14:24:08.254Z 2026-02-25T14:42:51.372Z
9337260 9337260 20260217052135_5KXJj UK008D 2026-02-18T14:06:47.843Z 2026-02-26T14:39:25.350Z
9336861 9336861 20260217043950_wYqcN UK008D 2026-02-18T14:05:41.589Z 2026-02-26T14:39:22.307Z
9335227 9335227 20260217010233_f4ACR UK008D 2026-02-18T14:00:17.547Z 2026-02-26T14:38:51.887Z
9335084 9335084 20260216003342_3GgS9 UK008D 2026-02-17T14:26:18.786Z 2026-02-24T14:43:35.579Z
9334384 9334384 20260215214112_C19xu UK008D 2026-02-17T14:24:04.408Z 2026-02-24T14:43:08.712Z
9330864 9330864 20260216025950_zn3O3 UK008D 2026-02-17T14:03:22.482Z 2026-02-25T14:41:33.146Z
9330724 9330724 20260216022814_amcm9 UK008D 2026-02-17T14:02:41.035Z 2026-02-25T14:41:30.606Z
9330578 9330578 20260216020237_tyaVz UK008D 2026-02-17T14:02:05.351Z 2026-02-25T14:41:29.175Z
9326671 9326671 20260214012620_fP1JZ UK008D 2026-02-15T14:24:10.981Z 2026-02-22T14:42:54.402Z
9326400 9326400 20260213235849_h2sBX UK008D 2026-02-15T14:23:05.650Z 2026-02-22T14:42:48.277Z
9326341 9326341 20260213231536_Z02WK UK008D 2026-02-15T14:22:46.745Z 2026-02-22T14:42:47.021Z
9323259 9323259 20260214045848_OD3ev UK008D 2026-02-15T14:05:46.701Z 2026-02-23T14:46:29.647Z
9323205 9323205 20260214045707_CK92u UK008D 2026-02-15T14:05:38.087Z 2026-02-23T14:46:29.092Z
9322995 9322995 20260214043229_Tj6iB UK008D 2026-02-15T14:04:50.164Z 2026-02-23T14:46:25.880Z
9322796 9322796 20260214040046_5NDAo UK008D 2026-02-15T14:04:00.599Z 2026-02-23T14:46:22.405Z
9307007 9307007 20260208030756_5737U UK008D 2026-02-09T14:26:00.749Z 2026-02-16T15:01:20.402Z
9306662 9306662 20260208005100_jOJIL UK008D 2026-02-09T14:24:38.310Z 2026-02-16T15:00:48.013Z
9306655 9306655 20260208004934_X3WOA UK008D 2026-02-09T14:24:37.324Z 2026-02-16T15:00:47.674Z
9306490 9306490 20260208000423_wnlyb UK008D 2026-02-09T14:24:03.440Z 2026-02-16T15:00:33.385Z
9306246 9306246 20260207222226_fESoQ UK008D 2026-02-09T14:23:09.496Z 2026-02-16T15:00:06.200Z
9306108 9306108 20260207203710_IbbMU UK008D 2026-02-09T14:22:15.635Z 2026-02-16T14:59:51.384Z
9302792 9302792 20260207015212_WUG5N UK008D 2026-02-08T14:23:52.319Z 2026-02-15T15:01:03.181Z
9302499 9302499 20260206225014_74EPt UK008D 2026-02-08T14:22:41.580Z 2026-02-15T15:00:36.974Z
9294381 9294381 20260204191624_VQWIX UK008D 2026-02-06T14:19:00.865Z 2026-02-13T14:57:23.053Z
9278207 9278207 20260129062437_hmnPd UK008D 2026-01-30T14:24:56.597Z 2026-02-06T14:48:40.076Z
9278099 9278099 20260129053956_d3bhs UK008D 2026-01-30T14:24:22.739Z 2026-02-06T14:48:33.357Z
9278077 9278077 20260129052655_0Yh4e UK008D 2026-01-30T14:24:16.594Z 2026-02-06T14:48:25.153Z

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