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

7,899 rows where station_code = "UK005S" 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
8676418 8676418 20251202055148_BwZvy UK005S 2025-12-03T14:25:11.972Z 2025-12-05T14:28:56.189Z
8676048 8676048 20251202053410_JoXh5 UK005S 2025-12-03T14:24:38.311Z 2025-12-05T14:28:47.152Z
8675635 8675635 20251202050326_3Zc6C UK005S 2025-12-03T14:23:57.612Z 2025-12-05T14:28:37.073Z
8675355 8675355 20251202043132_w7ZIK UK005S 2025-12-03T14:23:33.657Z 2025-12-05T14:28:20.907Z
8675076 8675076 20251202040004_1kj3S UK005S 2025-12-03T14:23:01.157Z 2025-12-05T14:28:10.715Z
8675010 8675010 20251202035228_JBv6E UK005S 2025-12-03T14:22:50.748Z 2025-12-05T14:28:09.296Z
8674890 8674890 20251202033652_pT7HE UK005S 2025-12-03T14:22:40.648Z 2025-12-05T14:28:05.953Z
8674756 8674756 20251202032036_oWjBH UK005S 2025-12-03T14:22:18.352Z 2025-12-05T14:28:02.019Z
8674276 8674276 20251202015624_GPLjI UK005S 2025-12-03T14:21:21.199Z 2025-12-05T14:27:34.886Z
8674237 8674237 20251202015312_pHR02 UK005S 2025-12-03T14:21:16.915Z 2025-12-05T14:27:33.632Z
8658087 8658087 20251130063643_VAtuD UK005S 2025-12-01T14:34:54.056Z 2025-12-05T14:46:02.039Z
8657840 8657840 20251130061122_kvhIi UK005S 2025-12-01T14:34:42.881Z 2025-12-05T14:45:42.237Z
8657785 8657785 20251130060814_vc7zj UK005S 2025-12-01T14:34:41.120Z 2025-12-05T14:45:36.730Z
8657692 8657692 20251130060057_Uh59I UK005S 2025-12-01T14:34:38.613Z 2025-12-05T14:45:35.625Z
8657341 8657341 20251130053946_Tq5TP UK005S 2025-12-01T14:34:07.577Z 2025-12-05T14:45:28.409Z
8657315 8657315 20251130053841_iaHjT UK005S 2025-12-01T14:34:04.315Z 2025-12-05T14:45:28.219Z
8654546 8654546 20251130031954_ZDXcZ UK005S 2025-12-01T14:25:34.444Z 2025-12-05T14:44:11.444Z
8653227 8653227 20251130020355_yr6i0 UK005S 2025-12-01T14:23:06.370Z 2025-12-05T14:43:05.977Z
8637101 8637101 20251128050116_RCwjW UK005S 2025-11-29T14:26:50.700Z 2025-12-05T14:59:37.185Z
8637058 8637058 20251128045551_a5L4D UK005S 2025-11-29T14:26:48.198Z 2025-12-05T14:59:36.613Z
8636858 8636858 20251128043128_L0fD8 UK005S 2025-11-29T14:26:16.457Z 2025-12-05T14:59:30.927Z
8636385 8636385 20251128034137_H7cWS UK005S 2025-11-29T14:25:26.805Z 2025-12-05T14:59:23.505Z
8635678 8635678 20251128023715_QKJUo UK005S 2025-11-29T14:24:00.416Z 2025-12-05T14:59:13.063Z
8635639 8635639 20251128023423_8F4ca UK005S 2025-11-29T14:23:58.182Z 2025-12-05T14:59:12.463Z
8635330 8635330 20251128020416_QNk0Z UK005S 2025-11-29T14:23:03.981Z 2025-12-05T14:58:34.167Z
8633244 8633244 20251127225640_uT8ei UK005S 2025-11-29T14:19:18.501Z 2025-12-05T14:57:23.555Z
8616647 8616647 20251126061408_ycoDp UK005S 2025-11-27T14:31:24.165Z 2025-12-04T15:11:41.492Z
8615657 8615657 20251126051212_2sPtS UK005S 2025-11-27T14:30:04.304Z 2025-12-04T15:11:31.136Z
8613516 8613516 20251126032007_0pjPm UK005S 2025-11-27T14:26:10.127Z 2025-12-04T15:09:41.431Z
8613021 8613021 20251126025852_J34Gq UK005S 2025-11-27T14:25:11.898Z 2025-12-04T15:09:36.461Z
8612227 8612227 20251126022157_k3pWK UK005S 2025-11-27T14:23:37.590Z 2025-12-04T15:09:28.313Z
8611736 8611736 20251126015734_8Cily UK005S 2025-11-27T14:22:32.929Z 2025-12-04T15:09:23.749Z
8610644 8610644 20251126010118_ghiPu UK005S 2025-11-27T14:20:30.077Z 2025-12-04T15:08:21.698Z
8610490 8610490 20251126005006_O6nxE UK005S 2025-11-27T14:20:14.686Z 2025-12-04T15:08:06.811Z
8610064 8610064 20251126002028_3YnFN UK005S 2025-11-27T14:19:25.030Z 2025-12-04T15:08:01.568Z
8609842 8609842 20251126000927_pl5Hy UK005S 2025-11-27T14:19:01.337Z 2025-12-04T15:07:57.689Z
8609762 8609762 20251126000401_2KVcW UK005S 2025-11-27T14:18:55.930Z 2025-12-04T15:07:57.189Z
8609437 8609437 20251125234031_Xa9Sm UK005S 2025-11-27T14:18:12.167Z 2025-12-04T15:07:54.270Z
8608864 8608864 20251125225522_QtZpb UK005S 2025-11-27T14:17:00.858Z 2025-12-04T15:07:49.568Z
8608633 8608633 20251125223200_na9ug UK005S 2025-11-27T14:16:24.993Z 2025-12-04T15:07:47.324Z
8608513 8608513 20251125222615_oEfmB UK005S 2025-11-27T14:16:14.024Z 2025-12-04T15:07:45.923Z
8607738 8607738 20251125211607_VilWS UK005S 2025-11-27T14:14:25.098Z 2025-12-04T15:07:26.551Z
8607530 8607530 20251125210042_7jqFB UK005S 2025-11-27T14:13:55.102Z 2025-12-04T15:07:03.480Z
8603428 8603428 20251125060929_PDaDL UK005S 2025-11-26T14:27:26.589Z 2025-12-02T15:09:35.842Z
8603387 8603387 20251125060305_rIie5 UK005S 2025-11-26T14:27:24.264Z 2025-12-02T15:09:35.601Z
8603381 8603381 20251125060300_fuZtX UK005S 2025-11-26T14:27:24.205Z 2025-12-02T15:09:35.599Z
8603310 8603310 20251125055535_OnVRq UK005S 2025-11-26T14:27:20.157Z 2025-12-02T15:09:35.293Z
8603249 8603249 20251125055255_XTd7m UK005S 2025-11-26T14:27:17.444Z 2025-12-02T15:09:35.072Z
8603143 8603143 20251125054459_EuKMy UK005S 2025-11-26T14:27:10.217Z 2025-12-02T15:09:34.569Z
8603109 8603109 20251125054346_qMVVy UK005S 2025-11-26T14:27:07.371Z 2025-12-02T15:09:34.513Z
8603089 8603089 20251125054206_4ekDZ UK005S 2025-11-26T14:26:58.076Z 2025-12-02T15:09:34.383Z
8598099 8598099 20251125003422_NTHnY UK005S 2025-11-26T14:18:18.867Z 2025-12-02T15:07:46.539Z
8598088 8598088 20251125003422_2H6u1 UK005S 2025-11-26T14:18:18.690Z 2025-12-02T15:07:46.512Z
8598042 8598042 20251125003042_Y2NZJ UK005S 2025-11-26T14:18:02.812Z 2025-12-02T15:07:44.093Z
8597603 8597603 20251124235046_b8O2P UK005S 2025-11-26T14:17:11.216Z 2025-12-02T15:07:37.884Z
8597046 8597046 20251124224932_bwc1q UK005S 2025-11-26T14:15:55.586Z 2025-12-02T15:07:22.713Z
8597011 8597011 20251124224356_iWwEV UK005S 2025-11-26T14:15:53.241Z 2025-12-02T15:07:22.327Z
8596965 8596965 20251124223947_EATDo UK005S 2025-11-26T14:15:50.081Z 2025-12-02T15:07:20.589Z
8591970 8591970 20251124052520_M67ec UK005S 2025-11-25T14:25:27.678Z 2025-12-02T15:13:01.259Z
8588105 8588105 20251123232202_a5MuZ UK005S 2025-11-25T14:16:54.570Z 2025-12-02T15:11:27.725Z
8587867 8587867 20251123225536_iY3N6 UK005S 2025-11-25T14:16:20.493Z 2025-12-02T15:11:21.833Z
8587317 8587317 20251123214715_Zo82t UK005S 2025-11-25T14:15:02.009Z 2025-12-02T15:11:10.962Z
8586690 8586690 20251123203148_CcCuW UK005S 2025-11-25T14:13:36.492Z 2025-12-02T15:10:58.854Z
8586426 8586426 20251123194138_qbXFA UK005S 2025-11-25T14:12:52.206Z 2025-12-02T15:10:47.100Z
8578769 8578769 20251122212415_CQjhR UK005S 2025-11-24T14:12:39.279Z 2025-12-01T15:19:52.705Z
8569798 8569798 20251121061406_mKQ3X UK005S 2025-11-23T14:32:29.045Z 2025-11-29T14:54:49.021Z
8569685 8569685 20251121060908_r5x2l UK005S 2025-11-23T14:32:24.819Z 2025-11-29T14:54:48.770Z
8569184 8569184 20251121054810_rn8wM UK005S 2025-11-23T14:32:01.113Z 2025-11-29T14:54:47.922Z
8569168 8569168 20251121054754_pUQg9 UK005S 2025-11-23T14:31:56.471Z 2025-11-29T14:54:47.879Z
8568999 8568999 20251121054240_o1qq8 UK005S 2025-11-23T14:31:50.793Z 2025-11-29T14:54:47.662Z
8568618 8568618 20251121052728_stCcc UK005S 2025-11-23T14:31:16.209Z 2025-11-29T14:54:47.099Z
8559181 8559181 20251121035634_oAcMI UK005S 2025-11-22T14:41:49.248Z 2025-11-29T14:54:37.411Z
8559044 8559044 20251121035126_o3BqX UK005S 2025-11-22T14:41:45.252Z 2025-11-29T14:54:37.074Z
8558886 8558886 20251121034441_0WRGM UK005S 2025-11-22T14:41:24.292Z 2025-11-29T14:54:36.808Z
8558807 8558807 20251121034339_klW2Z UK005S 2025-11-22T14:41:18.073Z 2025-11-29T14:54:36.705Z
8557957 8557957 20251121031010_KWLeK UK005S 2025-11-22T14:40:54.490Z 2025-11-29T14:54:34.977Z
8556838 8556838 20251121021611_DznXq UK005S 2025-11-22T14:39:45.448Z 2025-11-29T14:54:33.056Z
8555677 8555677 20251121011544_wZWKs UK005S 2025-11-22T14:38:49.179Z 2025-11-29T14:54:30.914Z
8550997 8550997 20251121001457_98xyg UK005S 2025-11-22T14:21:54.435Z 2025-11-29T14:54:27.992Z
8550983 8550983 20251121001358_69HjQ UK005S 2025-11-22T14:21:53.518Z 2025-11-29T14:54:27.964Z
8550926 8550926 20251121001123_g2BCt UK005S 2025-11-22T14:21:50.180Z 2025-11-29T14:54:27.873Z
8550532 8550532 20251120235120_Uf0Qk UK005S 2025-11-22T14:21:11.244Z 2025-11-29T14:54:27.106Z
8549899 8549899 20251120230204_3E9cV UK005S 2025-11-22T14:19:45.303Z 2025-11-29T14:54:25.834Z
8549104 8549104 20251120215149_OUNbv UK005S 2025-11-22T14:18:21.076Z 2025-11-29T14:54:23.987Z
8548754 8548754 20251120211503_EADK4 UK005S 2025-11-22T14:17:35.046Z 2025-11-29T14:54:23.247Z
8547531 8547531 20251120200010_tpLUI UK005S 2025-11-22T14:15:15.686Z 2025-11-29T14:54:20.259Z
8547517 8547517 20251120195946_hCu4y UK005S 2025-11-22T14:15:15.483Z 2025-11-29T14:54:20.253Z
8546460 8546460 20251120183307_qfmy4 UK005S 2025-11-22T14:12:48.511Z 2025-11-29T14:54:15.516Z
8540227 8540227 20251120004700_hLAdZ UK005S 2025-11-21T14:35:56.084Z 2025-11-28T14:56:08.692Z
8537211 8537211 20251120062703_eqH2f UK005S 2025-11-21T14:19:51.024Z 2025-11-28T14:58:42.354Z
8537141 8537141 20251120061307_56Ogd UK005S 2025-11-21T14:19:34.490Z 2025-11-28T14:58:35.778Z
8537022 8537022 20251120055001_nOt3G UK005S 2025-11-21T14:19:23.245Z 2025-11-28T14:58:29.730Z
8536988 8536988 20251120054259_XuafD UK005S 2025-11-21T14:19:21.849Z 2025-11-28T14:58:20.688Z
8536965 8536965 20251120053952_CsIa9 UK005S 2025-11-21T14:19:20.337Z 2025-11-28T14:58:20.021Z
8536848 8536848 20251120052257_OBE6F UK005S 2025-11-21T14:19:12.295Z 2025-11-28T14:58:00.005Z
8536770 8536770 20251120050842_bBiIW UK005S 2025-11-21T14:18:58.984Z 2025-11-28T14:57:50.826Z
8536681 8536681 20251120045310_6sdbS UK005S 2025-11-21T14:18:49.682Z 2025-11-28T14:57:48.536Z
8536445 8536445 20251120042226_76KkV UK005S 2025-11-21T14:18:18.560Z 2025-11-28T14:57:37.377Z
8536323 8536323 20251120040806_Gb4DR UK005S 2025-11-21T14:18:06.982Z 2025-11-28T14:57:31.189Z
8536162 8536162 20251120034322_5BNA2 UK005S 2025-11-21T14:17:41.089Z 2025-11-28T14:57:26.067Z

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