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,110 rows where station_code = "UK00C7" 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
9273179 9273179 20260128050306_eJ2MI UK00C7 2026-01-29T14:28:54.630Z 2026-01-29T14:30:25.764Z
9273099 9273099 20260128044352_T6A77 UK00C7 2026-01-29T14:28:44.620Z 2026-01-29T14:30:25.749Z
9273071 9273071 20260128043109_sYCQ2 UK00C7 2026-01-29T14:28:41.085Z 2026-01-29T14:30:25.744Z
9273062 9273062 20260128043057_g9png UK00C7 2026-01-29T14:28:39.966Z 2026-01-29T14:30:25.743Z
9273038 9273038 20260128042708_CMtUt UK00C7 2026-01-29T14:28:31.559Z 2026-01-29T14:30:25.739Z
9272944 9272944 20260128040733_DYhZy UK00C7 2026-01-29T14:28:16.878Z 2026-01-29T14:30:25.710Z
9272816 9272816 20260128034033_SIxrx UK00C7 2026-01-29T14:27:53.122Z 2026-01-29T14:30:25.566Z
9272806 9272806 20260128033928_uknpk UK00C7 2026-01-29T14:27:51.813Z 2026-01-29T14:30:25.564Z
9272714 9272714 20260128031042_XG9JP UK00C7 2026-01-29T14:27:37.126Z 2026-01-29T14:30:25.442Z
9272670 9272670 20260128025837_KfAhz UK00C7 2026-01-29T14:27:26.595Z 2026-01-29T14:30:25.436Z
9272507 9272507 20260128022119_LaYIc UK00C7 2026-01-29T14:27:01.067Z 2026-01-29T14:30:25.363Z
9272365 9272365 20260128014426_ztbSH UK00C7 2026-01-29T14:26:31.917Z 2026-01-29T14:30:25.336Z
9272162 9272162 20260128002724_0v5np UK00C7 2026-01-29T14:25:49.144Z 2026-01-29T14:30:25.291Z
9272086 9272086 20260127235419_EygzZ UK00C7 2026-01-29T14:25:32.165Z 2026-01-29T14:30:25.277Z
9271984 9271984 20260127224305_cxr1c UK00C7 2026-01-29T14:25:12.574Z 2026-01-29T14:30:25.257Z
9271981 9271981 20260127224305_lyPpi UK00C7 2026-01-29T14:25:12.063Z 2026-01-29T14:30:25.257Z
9271911 9271911 20260127214508_15UQ2 UK00C7 2026-01-29T14:24:54.316Z 2026-01-29T14:30:25.228Z
9271720 9271720 20260127193234_RCutz UK00C7 2026-01-29T14:22:50.888Z 2026-01-29T14:30:25.050Z
9271713 9271713 20260127192828_FHIWQ UK00C7 2026-01-29T14:22:45.976Z 2026-01-29T14:30:25.038Z
9271653 9271653 20260127185719_ufUbA UK00C7 2026-01-29T14:22:07.267Z 2026-01-29T14:30:24.998Z
9271630 9271630 20260127184451_iaQUN UK00C7 2026-01-29T14:21:54.092Z 2026-01-29T14:30:24.977Z
9256068 9256068 20260124054826_r82EU UK00C7 2026-01-25T14:15:41.022Z 2026-01-29T14:48:20.910Z
9256058 9256058 20260124054810_GMJJ1 UK00C7 2026-01-25T14:15:40.463Z 2026-01-29T14:48:20.736Z
9255780 9255780 20260124045436_uaepa UK00C7 2026-01-25T14:14:40.608Z 2026-01-29T14:47:56.948Z
9254978 9254978 20260123234545_n23pp UK00C7 2026-01-25T14:11:31.029Z 2026-01-29T14:46:58.129Z
9254971 9254971 20260123233746_wjmkR UK00C7 2026-01-25T14:11:29.240Z 2026-01-29T14:46:57.699Z
9254868 9254868 20260123220918_ihy0m UK00C7 2026-01-25T14:10:58.011Z 2026-01-29T14:46:52.807Z
9254856 9254856 20260123220127_Tvdgg UK00C7 2026-01-25T14:10:56.825Z 2026-01-29T14:46:51.742Z
9254851 9254851 20260123215630_Vsu2x UK00C7 2026-01-25T14:10:56.239Z 2026-01-29T14:46:45.454Z
9252362 9252362 20260123022723_troSq UK00C7 2026-01-24T14:15:15.527Z 2026-01-29T14:52:46.784Z
9251959 9251959 20260123000706_2ix2C UK00C7 2026-01-24T14:13:49.242Z 2026-01-29T14:52:18.820Z
9243991 9243991 20260121054738_j23Re UK00C7 2026-01-22T14:23:51.936Z 2026-01-29T15:05:37.721Z
9243879 9243879 20260121052926_j3qtf UK00C7 2026-01-22T14:23:25.127Z 2026-01-29T15:05:31.044Z
9243827 9243827 20260121052426_DprU3 UK00C7 2026-01-22T14:23:19.088Z 2026-01-29T15:05:29.238Z
9243684 9243684 20260121050503_rp2aj UK00C7 2026-01-22T14:22:44.341Z 2026-01-29T15:05:23.234Z
9230881 9230881 20260119052356_oysQe UK00C7 2026-01-20T14:30:11.713Z 2026-01-27T15:05:34.417Z
9230646 9230646 20260119044320_n66Yz UK00C7 2026-01-20T14:29:05.695Z 2026-01-27T15:05:18.540Z
9230487 9230487 20260119042544_u5KDu UK00C7 2026-01-20T14:28:06.795Z 2026-01-27T15:04:57.529Z
9229647 9229647 20260119021003_xQRPH UK00C7 2026-01-20T14:23:33.369Z 2026-01-27T15:03:46.710Z
9229595 9229595 20260119020514_bV7kb UK00C7 2026-01-20T14:23:16.484Z 2026-01-27T15:03:44.123Z
9229559 9229559 20260119020131_O4gnG UK00C7 2026-01-20T14:23:09.279Z 2026-01-27T15:03:42.338Z
9229400 9229400 20260119014020_I3An8 UK00C7 2026-01-20T14:22:22.119Z 2026-01-27T15:03:22.015Z
9229012 9229012 20260119003441_0F0P6 UK00C7 2026-01-20T14:20:36.944Z 2026-01-27T15:02:47.833Z
9228903 9228903 20260119001656_o0Xgh UK00C7 2026-01-20T14:20:06.041Z 2026-01-27T15:02:42.148Z
9228451 9228451 20260118222550_OGNBf UK00C7 2026-01-20T14:17:52.376Z 2026-01-27T15:02:01.966Z
9204457 9204457 20260114064408_fLKCd UK00C7 2026-01-15T14:27:24.144Z 2026-01-22T15:10:28.522Z
9204299 9204299 20260114062546_9s9xM UK00C7 2026-01-15T14:27:01.496Z 2026-01-22T15:10:24.569Z
9203945 9203945 20260114055832_N0VaQ UK00C7 2026-01-15T14:25:55.393Z 2026-01-22T15:10:15.990Z
9203775 9203775 20260114053712_6W7mW UK00C7 2026-01-15T14:25:22.939Z 2026-01-22T15:10:13.339Z
9203752 9203752 20260114053438_NIm3n UK00C7 2026-01-15T14:25:21.064Z 2026-01-22T15:10:13.083Z
9203732 9203732 20260114053245_rgL1r UK00C7 2026-01-15T14:25:15.684Z 2026-01-22T15:10:12.698Z
9203653 9203653 20260114052718_pUsRx UK00C7 2026-01-15T14:25:06.689Z 2026-01-22T15:10:11.614Z
9203490 9203490 20260114050633_z5IdK UK00C7 2026-01-15T14:24:33.361Z 2026-01-22T15:10:08.651Z
9203157 9203157 20260114043802_jZapu UK00C7 2026-01-15T14:23:26.938Z 2026-01-22T15:10:02.737Z
9203017 9203017 20260114042612_kQhkc UK00C7 2026-01-15T14:23:02.312Z 2026-01-22T15:10:00.572Z
9202845 9202845 20260114041313_d6xK7 UK00C7 2026-01-15T14:22:32.124Z 2026-01-22T15:09:57.820Z
9202723 9202723 20260114040607_SMnSf UK00C7 2026-01-15T14:22:15.243Z 2026-01-22T15:09:31.635Z
9202563 9202563 20260114034928_Dm3pi UK00C7 2026-01-15T14:21:41.022Z 2026-01-22T15:09:22.994Z
9202483 9202483 20260114034213_ZSjLz UK00C7 2026-01-15T14:21:30.457Z 2026-01-22T15:09:21.220Z
9202471 9202471 20260114034208_3JK6j UK00C7 2026-01-15T14:21:27.788Z 2026-01-22T15:09:20.876Z
9202195 9202195 20260114032224_wuWeK UK00C7 2026-01-15T14:20:40.663Z 2026-01-22T15:09:14.673Z
9202188 9202188 20260114032202_YpevM UK00C7 2026-01-15T14:20:39.512Z 2026-01-22T15:09:14.488Z
9202172 9202172 20260114032201_3oRHQ UK00C7 2026-01-15T14:20:38.070Z 2026-01-22T15:09:14.407Z
9202096 9202096 20260114031554_CdIOa UK00C7 2026-01-15T14:20:31.192Z 2026-01-22T15:09:13.433Z
9202087 9202087 20260114031525_Ig0Nc UK00C7 2026-01-15T14:20:24.372Z 2026-01-22T15:09:13.273Z
9201996 9201996 20260114030932_9LW35 UK00C7 2026-01-15T14:20:13.560Z 2026-01-22T15:09:11.989Z
9201954 9201954 20260114030722_xDmcx UK00C7 2026-01-15T14:20:10.780Z 2026-01-22T15:09:11.692Z
9201905 9201905 20260114030549_kb5Vf UK00C7 2026-01-15T14:20:06.288Z 2026-01-22T15:09:11.214Z
9201897 9201897 20260114030441_gLeWu UK00C7 2026-01-15T14:20:05.084Z 2026-01-22T15:09:11.080Z
9201584 9201584 20260114023406_o63f8 UK00C7 2026-01-15T14:19:08.424Z 2026-01-22T15:09:06.395Z
9180963 9180963 20260110233530_D1zyz UK00C7 2026-01-12T14:09:05.451Z 2026-01-19T15:16:42.264Z
9180606 9180606 20260110210716_xogxY UK00C7 2026-01-12T14:07:40.728Z 2026-01-19T15:16:24.269Z
9180456 9180456 20260110202755_Z9I6s UK00C7 2026-01-12T14:07:08.639Z 2026-01-19T15:16:03.339Z
9180341 9180341 20260110200021_vOMe6 UK00C7 2026-01-12T14:06:44.622Z 2026-01-19T15:15:58.306Z
9180107 9180107 20260110191253_hho85 UK00C7 2026-01-12T14:05:49.202Z 2026-01-19T15:15:46.666Z
9179827 9179827 20260110174744_37RYd UK00C7 2026-01-12T14:04:29.575Z 2026-01-19T15:15:19.197Z
9166774 9166774 20260107201646_EXWQU UK00C7 2026-01-09T14:04:51.225Z 2026-01-16T15:10:23.588Z
9159776 9159776 20260106034314_2KzXM UK00C7 2026-01-07T14:10:21.524Z 2026-01-13T15:08:42.774Z
9159473 9159473 20260106024515_jQi9F UK00C7 2026-01-07T14:09:24.804Z 2026-01-13T15:08:26.981Z
9159443 9159443 20260106024321_a2v0J UK00C7 2026-01-07T14:09:20.107Z 2026-01-13T15:08:26.166Z
9159429 9159429 20260106023928_WQ3De UK00C7 2026-01-07T14:09:18.867Z 2026-01-13T15:08:25.756Z
9159186 9159186 20260106020409_5WNA2 UK00C7 2026-01-07T14:08:37.884Z 2026-01-13T15:08:12.267Z
9159105 9159105 20260106014311_qTCK6 UK00C7 2026-01-07T14:08:17.766Z 2026-01-13T15:08:07.082Z
9159086 9159086 20260106014117_HlXdI UK00C7 2026-01-07T14:08:15.687Z 2026-01-13T15:08:01.362Z
9159052 9159052 20260106013532_HGCV0 UK00C7 2026-01-07T14:08:11.518Z 2026-01-13T15:07:59.028Z
9158839 9158839 20260106003648_MhJjV UK00C7 2026-01-07T14:07:24.363Z 2026-01-13T15:07:47.910Z
9158727 9158727 20260106001024_PaoBj UK00C7 2026-01-07T14:07:05.622Z 2026-01-13T15:07:44.151Z
9158592 9158592 20260105232956_BXnhd UK00C7 2026-01-07T14:06:39.495Z 2026-01-13T15:07:31.557Z
9158567 9158567 20260105231820_rgyVV UK00C7 2026-01-07T14:06:32.156Z 2026-01-13T15:07:29.745Z
9158560 9158560 20260105231636_p9C9B UK00C7 2026-01-07T14:06:31.209Z 2026-01-13T15:07:29.587Z
9158503 9158503 20260105224818_5JgLU UK00C7 2026-01-07T14:06:18.659Z 2026-01-13T15:07:25.386Z
9158442 9158442 20260105222853_E10r3 UK00C7 2026-01-07T14:06:06.838Z 2026-01-13T15:07:22.334Z
9158405 9158405 20260105221443_68yLj UK00C7 2026-01-07T14:05:56.502Z 2026-01-13T15:07:20.469Z
9158364 9158364 20260105220050_RfPxm UK00C7 2026-01-07T14:05:49.821Z 2026-01-13T15:07:19.269Z
9158089 9158089 20260105195948_3W1lA UK00C7 2026-01-07T14:04:48.278Z 2026-01-13T15:06:54.272Z
9157653 9157653 20260105181314_tymUs UK00C7 2026-01-07T14:03:03.179Z 2026-01-13T15:06:22.488Z
9155980 9155980 20260104063402_4KVTj UK00C7 2026-01-06T14:38:23.617Z 2026-01-12T15:11:33.782Z
9155972 9155972 20260104063355_3deiB UK00C7 2026-01-06T14:38:22.598Z 2026-01-12T15:11:33.192Z
9155904 9155904 20260104063011_oIk2w UK00C7 2026-01-06T14:38:10.269Z 2026-01-12T15:11:31.621Z
9155554 9155554 20260104060402_E6BG7 UK00C7 2026-01-06T14:37:31.698Z 2026-01-12T15:11:06.964Z

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