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,707 rows where station_code = "UK00B6" 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
8676541 8676541 20251202060101_SXPEA UK00B6 2025-12-03T14:25:17.423Z 2025-12-06T14:35:23.241Z
8675467 8675467 20251202044357_Kx77Z UK00B6 2025-12-03T14:23:45.215Z 2025-12-06T14:34:53.694Z
8674477 8674477 20251202023152_1fI2d UK00B6 2025-12-03T14:21:40.973Z 2025-12-06T14:34:09.942Z
8674465 8674465 20251202022852_8uqgC UK00B6 2025-12-03T14:21:40.483Z 2025-12-06T14:34:09.691Z
8674281 8674281 20251202015624_GPLjI UK00B6 2025-12-03T14:21:21.200Z 2025-12-06T14:34:02.985Z
8674228 8674228 20251202015014_Hs2R8 UK00B6 2025-12-03T14:21:15.950Z 2025-12-06T14:34:02.178Z
8674040 8674040 20251202011559_aZDtO UK00B6 2025-12-03T14:20:47.138Z 2025-12-06T14:33:46.429Z
8673952 8673952 20251202004617_EGpAI UK00B6 2025-12-03T14:20:25.829Z 2025-12-06T14:33:43.105Z
8667359 8667359 20251130001656_G9bjA UK00B6 2025-12-02T14:37:24.879Z 2025-12-06T14:46:53.621Z
8656965 8656965 20251130052232_o6sTk UK00B6 2025-12-01T14:33:51.041Z 2025-12-06T14:49:43.717Z
8656627 8656627 20251130050218_1rpzC UK00B6 2025-12-01T14:28:48.973Z 2025-12-06T14:49:37.201Z
8655698 8655698 20251130041152_4eH3J UK00B6 2025-12-01T14:27:21.460Z 2025-12-06T14:49:26.576Z
8655400 8655400 20251130040048_N1CRV UK00B6 2025-12-01T14:26:52.957Z 2025-12-06T14:49:13.841Z
8654768 8654768 20251130033222_RLBpt UK00B6 2025-12-01T14:25:59.394Z 2025-12-06T14:48:48.128Z
8653465 8653465 20251130021724_Iaxik UK00B6 2025-12-01T14:23:32.809Z 2025-12-06T14:47:58.789Z
8653197 8653197 20251130020132_hfVYU UK00B6 2025-12-01T14:23:03.283Z 2025-12-06T14:47:51.274Z
8637655 8637655 20251128060634_RIkq1 UK00B6 2025-11-29T14:27:40.124Z 2025-12-06T15:04:02.106Z
8637589 8637589 20251128055558_H61gU UK00B6 2025-11-29T14:27:36.175Z 2025-12-06T15:04:01.499Z
8637105 8637105 20251128050116_RCwjW UK00B6 2025-11-29T14:26:50.700Z 2025-12-06T15:03:56.483Z
8637037 8637037 20251128045258_NxzHh UK00B6 2025-11-29T14:26:40.960Z 2025-12-06T15:03:55.930Z
8636865 8636865 20251128043128_L0fD8 UK00B6 2025-11-29T14:26:16.458Z 2025-12-06T15:03:46.784Z
8634813 8634813 20251128011957_HtUbV UK00B6 2025-11-29T14:22:04.704Z 2025-12-06T15:02:36.179Z
8634355 8634355 20251128004133_5vxQ3 UK00B6 2025-11-29T14:21:14.540Z 2025-12-06T15:02:00.785Z
8634295 8634295 20251128003424_DmZK9 UK00B6 2025-11-29T14:21:10.122Z 2025-12-06T15:01:58.038Z
8633795 8633795 20251127235453_VwQft UK00B6 2025-11-29T14:20:23.661Z 2025-12-06T15:01:48.674Z
8633535 8633535 20251127233002_eSqpX UK00B6 2025-11-29T14:19:50.889Z 2025-12-06T15:01:45.240Z
8633179 8633179 20251127224915_2xKdh UK00B6 2025-11-29T14:19:11.858Z 2025-12-06T15:01:40.810Z
8632020 8632020 20251127202340_Qda5V UK00B6 2025-11-29T14:16:40.948Z 2025-12-06T15:00:49.935Z
8615679 8615679 20251126051245_cv8ct UK00B6 2025-11-27T14:30:04.593Z 2025-12-04T15:11:31.152Z
8615651 8615651 20251126051211_veiAP UK00B6 2025-11-27T14:30:04.017Z 2025-12-04T15:11:31.112Z
8615412 8615412 20251126050146_qjh82 UK00B6 2025-11-27T14:29:30.665Z 2025-12-04T15:11:28.411Z
8615335 8615335 20251126045704_d4qFL UK00B6 2025-11-27T14:29:27.808Z 2025-12-04T15:11:27.944Z
8615321 8615321 20251126045631_8g0iL UK00B6 2025-11-27T14:29:27.208Z 2025-12-04T15:11:27.793Z
8614696 8614696 20251126042346_4o5Dx UK00B6 2025-11-27T14:28:27.740Z 2025-12-04T15:10:57.894Z
8614441 8614441 20251126040850_IkmD2 UK00B6 2025-11-27T14:27:52.264Z 2025-12-04T15:10:40.799Z
8613350 8613350 20251126031415_djwQO UK00B6 2025-11-27T14:25:39.096Z 2025-12-04T15:09:39.803Z
8612839 8612839 20251126025006_TPfc7 UK00B6 2025-11-27T14:24:53.764Z 2025-12-04T15:09:34.726Z
8612577 8612577 20251126023804_nmVKI UK00B6 2025-11-27T14:24:22.620Z 2025-12-04T15:09:32.070Z
8612222 8612222 20251126022157_SkEVY UK00B6 2025-11-27T14:23:37.340Z 2025-12-04T15:09:28.277Z
8612141 8612141 20251126021923_4Ig3x UK00B6 2025-11-27T14:23:32.592Z 2025-12-04T15:09:27.867Z
8611858 8611858 20251126020246_8mpj0 UK00B6 2025-11-27T14:22:58.748Z 2025-12-04T15:09:24.842Z
8611813 8611813 20251126020104_mqQsL UK00B6 2025-11-27T14:22:54.947Z 2025-12-04T15:09:24.359Z
8611753 8611753 20251126015757_WTW23 UK00B6 2025-11-27T14:22:35.269Z 2025-12-04T15:09:23.839Z
8611557 8611557 20251126015117_eivmt UK00B6 2025-11-27T14:22:19.015Z 2025-12-04T15:09:22.498Z
8610907 8610907 20251126011353_LJygi UK00B6 2025-11-27T14:20:56.856Z 2025-12-04T15:08:45.099Z
8610246 8610246 20251126003126_Vk3pt UK00B6 2025-11-27T14:19:39.222Z 2025-12-04T15:08:03.604Z
8610228 8610228 20251126003100_8YP8D UK00B6 2025-11-27T14:19:37.894Z 2025-12-04T15:08:03.434Z
8609536 8609536 20251125234644_ET5ya UK00B6 2025-11-27T14:18:19.344Z 2025-12-04T15:07:54.981Z
8609236 8609236 20251125232244_v5IIn UK00B6 2025-11-27T14:17:48.572Z 2025-12-04T15:07:52.814Z
8608630 8608630 20251125223200_zAl82 UK00B6 2025-11-27T14:16:24.561Z 2025-12-04T15:07:47.250Z
8608383 8608383 20251125221132_Crk7S UK00B6 2025-11-27T14:15:52.115Z 2025-12-04T15:07:44.503Z
8608358 8608358 20251125220947_DEBS3 UK00B6 2025-11-27T14:15:44.890Z 2025-12-04T15:07:44.029Z
8607662 8607662 20251125210904_oZYMy UK00B6 2025-11-27T14:14:08.951Z 2025-12-04T15:07:10.965Z
8607462 8607462 20251125205205_jMYrT UK00B6 2025-11-27T14:13:41.916Z 2025-12-04T15:07:02.272Z
8607340 8607340 20251125204126_75IYq UK00B6 2025-11-27T14:13:23.287Z 2025-12-04T15:07:00.662Z
8606628 8606628 20251125191651_BHyDV UK00B6 2025-11-27T14:10:45.878Z 2025-12-04T15:06:47.707Z
8606322 8606322 20251125183610_rW4x3 UK00B6 2025-11-27T14:09:51.178Z 2025-12-04T15:06:43.946Z
8603502 8603502 20251125061055_fdakh UK00B6 2025-11-26T14:27:28.805Z 2025-12-02T15:09:36.049Z
8603223 8603223 20251125055056_afnE3 UK00B6 2025-11-26T14:27:15.718Z 2025-12-02T15:09:34.933Z
8601720 8601720 20251125041011_QOsdC UK00B6 2025-11-26T14:24:37.492Z 2025-12-02T15:09:21.260Z
8601172 8601172 20251125033723_0vI57 UK00B6 2025-11-26T14:23:46.151Z 2025-12-02T15:09:05.412Z
8600082 8600082 20251125024003_KxE37 UK00B6 2025-11-26T14:22:01.330Z 2025-12-02T15:08:34.489Z
8599334 8599334 20251125015831_g1y7H UK00B6 2025-11-26T14:20:47.113Z 2025-12-02T15:08:22.288Z
8599190 8599190 20251125015240_SrlIE UK00B6 2025-11-26T14:20:38.534Z 2025-12-02T15:08:20.841Z
8598708 8598708 20251125012031_lbTgB UK00B6 2025-11-26T14:19:31.265Z 2025-12-02T15:08:06.004Z
8598167 8598167 20251125003919_DABpO UK00B6 2025-11-26T14:18:23.418Z 2025-12-02T15:07:47.467Z
8598128 8598128 20251125003522_Cbk75 UK00B6 2025-11-26T14:18:19.891Z 2025-12-02T15:07:46.752Z
8597821 8597821 20251125001403_DUzoE UK00B6 2025-11-26T14:17:45.142Z 2025-12-02T15:07:40.855Z
8597805 8597805 20251125001342_94TN7 UK00B6 2025-11-26T14:17:44.615Z 2025-12-02T15:07:40.798Z
8597587 8597587 20251124235045_H5cVe UK00B6 2025-11-26T14:17:11.055Z 2025-12-02T15:07:37.880Z
8596975 8596975 20251124223947_HrH6i UK00B6 2025-11-26T14:15:50.355Z 2025-12-02T15:07:21.132Z
8596871 8596871 20251124222051_t1fKQ UK00B6 2025-11-26T14:15:40.016Z 2025-12-02T15:07:15.451Z
8596104 8596104 20251124195415_sfLi7 UK00B6 2025-11-26T14:13:34.020Z 2025-12-02T15:06:40.764Z
8592061 8592061 20251124054026_1iGWR UK00B6 2025-11-25T14:25:49.152Z 2025-12-02T15:13:01.659Z
8588929 8588929 20251124004615_AJPeV UK00B6 2025-11-25T14:18:47.000Z 2025-12-02T15:12:01.142Z
8588850 8588850 20251124003641_i0IbW UK00B6 2025-11-25T14:18:25.253Z 2025-12-02T15:11:56.769Z
8588268 8588268 20251123233629_Q3qoh UK00B6 2025-11-25T14:17:10.309Z 2025-12-02T15:11:38.851Z
8588069 8588069 20251123231748_dts0w UK00B6 2025-11-25T14:16:50.242Z 2025-12-02T15:11:25.064Z
8586906 8586906 20251123210302_qrW6g UK00B6 2025-11-25T14:14:06.616Z 2025-12-02T15:11:04.019Z
8586641 8586641 20251123202358_umxs3 UK00B6 2025-11-25T14:13:31.466Z 2025-12-02T15:10:56.612Z
8586459 8586459 20251123194916_2JaJ3 UK00B6 2025-11-25T14:12:55.672Z 2025-12-02T15:10:48.658Z
8586347 8586347 20251123193046_30IGi UK00B6 2025-11-25T14:12:42.370Z 2025-12-02T15:10:46.512Z
8586207 8586207 20251123185837_5owwh UK00B6 2025-11-25T14:12:17.447Z 2025-12-02T15:10:44.906Z
8586187 8586187 20251123185620_t3tui UK00B6 2025-11-25T14:12:15.599Z 2025-12-02T15:10:44.852Z
8585603 8585603 20251123171444_6yRaO UK00B6 2025-11-25T14:10:15.613Z 2025-12-02T15:10:05.343Z
8569944 8569944 20251121063235_gvXjs UK00B6 2025-11-23T14:32:51.087Z 2025-11-29T14:54:49.937Z
8569747 8569747 20251121061224_Sll90 UK00B6 2025-11-23T14:32:27.188Z 2025-11-29T14:54:48.941Z
8569701 8569701 20251121060909_gOppW UK00B6 2025-11-23T14:32:25.001Z 2025-11-29T14:54:48.799Z
8569689 8569689 20251121060908_r5x2l UK00B6 2025-11-23T14:32:24.819Z 2025-11-29T14:54:48.770Z
8568574 8568574 20251121052544_JMEdA UK00B6 2025-11-23T14:31:13.894Z 2025-11-29T14:54:47.011Z
8567874 8567874 20251121033418_908Fv UK00B6 2025-11-23T14:28:49.621Z 2025-11-29T14:54:36.324Z
8567487 8567487 20251120205639_yfOt8 UK00B6 2025-11-23T14:24:31.985Z 2025-11-29T14:54:22.720Z
8564178 8564178 20251121180156_BbMKK UK00B6 2025-11-23T14:10:13.071Z 2025-11-30T15:04:08.264Z
8564050 8564050 20251121175025_XckJf UK00B6 2025-11-23T14:09:57.346Z 2025-11-30T15:04:00.418Z
8564001 8564001 20251121174613_0O4s9 UK00B6 2025-11-23T14:09:44.813Z 2025-11-30T15:03:58.634Z
8563723 8563723 20251121171705_UJjjb UK00B6 2025-11-23T14:09:05.750Z 2025-11-30T15:03:43.937Z
8560263 8560263 20251121044805_zVDsU UK00B6 2025-11-22T14:42:45.525Z 2025-11-29T14:54:45.422Z
8559909 8559909 20251121043013_uIJmk UK00B6 2025-11-22T14:42:06.641Z 2025-11-29T14:54:44.513Z
8559859 8559859 20251121042813_VkeNX UK00B6 2025-11-22T14:42:05.689Z 2025-11-29T14:54:44.376Z
8559700 8559700 20251121042252_Q63tg UK00B6 2025-11-22T14:42:01.855Z 2025-11-29T14:54:43.311Z

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