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

>10,000 rows count all where station_code = "UK004E" 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
9273327 9273327 20260128054018_xWRB3 UK004E 2026-01-29T14:29:20.857Z 2026-01-29T14:30:25.788Z
9272831 9272831 20260128034244_XsXiS UK004E 2026-01-29T14:27:56.828Z 2026-01-29T14:30:25.578Z
9272726 9272726 20260128031059_A8FxD UK004E 2026-01-29T14:27:38.143Z 2026-01-29T14:30:25.443Z
9272219 9272219 20260128004829_urbi1 UK004E 2026-01-29T14:25:57.319Z 2026-01-29T14:30:25.308Z
9258853 9258853 20260124173731_UK1TX UK004E 2026-01-26T14:14:48.865Z 2026-01-29T14:42:15.131Z
9254993 9254993 20260124000638_qG4mM UK004E 2026-01-25T14:11:34.998Z 2026-01-29T14:46:58.999Z
9254945 9254945 20260123232635_G4cpg UK004E 2026-01-25T14:11:25.791Z 2026-01-29T14:46:56.801Z
9254796 9254796 20260123212411_Sidw2 UK004E 2026-01-25T14:10:46.515Z 2026-01-29T14:46:43.041Z
9254667 9254667 20260123204125_NgFjt UK004E 2026-01-25T14:10:18.327Z 2026-01-29T14:46:34.805Z
9254623 9254623 20260123203101_rmhbu UK004E 2026-01-25T14:10:05.298Z 2026-01-29T14:46:32.784Z
9252256 9252256 20260123015822_Vtc6C UK004E 2026-01-24T14:14:51.988Z 2026-01-29T14:52:42.264Z
9252055 9252055 20260123004830_YsNhP UK004E 2026-01-24T14:14:13.032Z 2026-01-29T14:52:26.095Z
9251984 9251984 20260123001924_FHuAE UK004E 2026-01-24T14:13:52.867Z 2026-01-29T14:52:20.093Z
9214156 9214156 20260116054809_O2di3 UK004E 2026-01-17T14:20:21.685Z 2026-01-24T15:13:18.812Z
9214136 9214136 20260116054510_0iIVm UK004E 2026-01-17T14:20:14.779Z 2026-01-24T15:13:17.314Z
9213389 9213389 20260116031932_DmUDP UK004E 2026-01-17T14:16:42.516Z 2026-01-24T15:12:11.614Z
9213379 9213379 20260116031905_13niA UK004E 2026-01-17T14:16:40.927Z 2026-01-24T15:12:11.328Z
9213069 9213069 20260116020635_Xtxmy UK004E 2026-01-17T14:15:16.579Z 2026-01-24T15:11:39.306Z
9212955 9212955 20260116014242_kjkze UK004E 2026-01-17T14:14:44.330Z 2026-01-24T15:11:35.595Z
9212928 9212928 20260116014028_cnMhe UK004E 2026-01-17T14:14:38.187Z 2026-01-24T15:11:34.527Z
9212874 9212874 20260116012716_Tpsoy UK004E 2026-01-17T14:14:21.029Z 2026-01-24T15:11:31.893Z
9205589 9205589 20260114061742_Ct2Gb UK004E 2026-01-15T14:31:35.992Z 2026-01-22T15:10:22.860Z
9204237 9204237 20260114061741_awTup UK004E 2026-01-15T14:26:52.205Z 2026-01-22T15:10:22.686Z
9204193 9204193 20260114061408_I5cfw UK004E 2026-01-15T14:26:38.294Z 2026-01-22T15:10:22.038Z
9203855 9203855 20260114054440_74pV3 UK004E 2026-01-15T14:25:41.322Z 2026-01-22T15:10:14.335Z
9203448 9203448 20260114045753_o2Z5k UK004E 2026-01-15T14:24:27.377Z 2026-01-22T15:10:07.992Z
9203390 9203390 20260114045330_VR2Cb UK004E 2026-01-15T14:24:12.911Z 2026-01-22T15:10:06.675Z
9202649 9202649 20260114035750_wiXep UK004E 2026-01-15T14:21:55.445Z 2026-01-22T15:09:24.294Z
9195600 9195600 20260113015914_yYQxk UK004E 2026-01-14T14:13:59.625Z 2026-01-21T15:04:42.853Z
9195262 9195262 20260113004927_ltVHO UK004E 2026-01-14T14:12:40.200Z 2026-01-21T15:04:38.299Z
9195149 9195149 20260113003035_IF0jW UK004E 2026-01-14T14:12:12.965Z 2026-01-21T15:04:37.011Z
9194691 9194691 20260112220216_CbuII UK004E 2026-01-14T14:10:19.009Z 2026-01-21T15:04:20.126Z
9162997 9162997 20260107052200_ThaCf UK004E 2026-01-08T14:07:40.227Z 2026-01-13T15:02:50.888Z
9160663 9160663 20260106064444_Aw3v4 UK004E 2026-01-07T14:13:20.610Z 2026-01-13T15:09:45.026Z
9160605 9160605 20260106063127_VSN8t UK004E 2026-01-07T14:13:08.346Z 2026-01-13T15:09:35.012Z
9160507 9160507 20260106060436_k7kJS UK004E 2026-01-07T14:12:50.717Z 2026-01-13T15:09:28.907Z
9160399 9160399 20260106054620_FTwiC UK004E 2026-01-07T14:12:29.945Z 2026-01-13T15:09:24.748Z
9160362 9160362 20260106053725_u5VxV UK004E 2026-01-07T14:12:22.104Z 2026-01-13T15:09:22.131Z
9159977 9159977 20260106042424_mrfCa UK004E 2026-01-07T14:10:58.738Z 2026-01-13T15:08:54.900Z
9159974 9159974 20260106042345_Cx2jQ UK004E 2026-01-07T14:10:57.947Z 2026-01-13T15:08:54.663Z
9159608 9159608 20260106031339_TOlNO UK004E 2026-01-07T14:09:54.647Z 2026-01-13T15:08:33.145Z
9159579 9159579 20260106030925_6jcAD UK004E 2026-01-07T14:09:48.603Z 2026-01-13T15:08:31.759Z
9159547 9159547 20260106030317_UnyHu UK004E 2026-01-07T14:09:42.437Z 2026-01-13T15:08:30.243Z
9159527 9159527 20260106025731_2AhM3 UK004E 2026-01-07T14:09:38.075Z 2026-01-13T15:08:29.187Z
9159153 9159153 20260106015348_samfq UK004E 2026-01-07T14:08:29.706Z 2026-01-13T15:08:10.403Z
9157948 9157948 20260105193346_onrrC UK004E 2026-01-07T14:04:18.438Z 2026-01-13T15:06:47.597Z
9155747 9155747 20260104061939_IL39k UK004E 2026-01-06T14:37:58.529Z 2026-01-12T15:11:26.239Z
9155653 9155653 20260104061046_mCLG0 UK004E 2026-01-06T14:37:52.252Z 2026-01-12T15:11:23.281Z
9155402 9155402 20260104055429_f8scH UK004E 2026-01-06T14:37:20.144Z 2026-01-12T15:10:59.806Z
9155147 9155147 20260104053807_5SS2p UK004E 2026-01-06T14:36:51.677Z 2026-01-12T15:10:50.709Z
9154737 9154737 20260104051145_QxHYa UK004E 2026-01-06T14:36:07.554Z 2026-01-12T15:10:18.288Z
9154726 9154726 20260104051122_Yp0r3 UK004E 2026-01-06T14:36:07.066Z 2026-01-12T15:10:18.048Z
9154662 9154662 20260104050651_QblGV UK004E 2026-01-06T14:35:50.656Z 2026-01-12T15:10:14.191Z
9153806 9153806 20260104041502_Ps7oZ UK004E 2026-01-06T14:34:09.318Z 2026-01-12T15:09:05.753Z
9150418 9150418 20260105020916_2dy8d UK004E 2026-01-06T14:09:56.210Z 2026-01-13T15:13:31.482Z
9150324 9150324 20260105014938_1x3LU UK004E 2026-01-06T14:09:33.931Z 2026-01-13T15:13:16.580Z
9150206 9150206 20260105012943_dV2w9 UK004E 2026-01-06T14:09:03.737Z 2026-01-13T15:13:10.966Z
9150165 9150165 20260105011705_dDXu8 UK004E 2026-01-06T14:08:51.362Z 2026-01-13T15:13:08.758Z
9148972 9148972 20260104181833_m98OB UK004E 2026-01-06T14:03:16.467Z 2026-01-13T15:11:33.514Z
9148898 9148898 20260104175534_ULws1 UK004E 2026-01-06T14:02:55.802Z 2026-01-13T15:11:25.619Z
9148055 9148055 20260103172849_zkSEn UK004E 2026-01-05T14:30:15.379Z 2026-01-10T15:04:13.531Z
9147692 9147692 20260104063059_a9Ij4 UK004E 2026-01-05T14:24:43.388Z 2026-01-12T15:11:32.107Z
9147623 9147623 20260104061917_aRfnI UK004E 2026-01-05T14:24:37.906Z 2026-01-12T15:11:25.970Z
9147592 9147592 20260104061105_aS7gy UK004E 2026-01-05T14:24:36.152Z 2026-01-12T15:11:23.356Z
9147570 9147570 20260104060728_TLha7 UK004E 2026-01-05T14:24:23.897Z 2026-01-12T15:11:21.639Z
9147530 9147530 20260104060152_dcLx2 UK004E 2026-01-05T14:24:20.852Z 2026-01-12T15:11:06.296Z
9147509 9147509 20260104055835_wztIn UK004E 2026-01-05T14:24:15.778Z 2026-01-12T15:11:04.521Z
9147465 9147465 20260104055335_3yoZP UK004E 2026-01-05T14:24:12.159Z 2026-01-12T15:10:59.388Z
9147433 9147433 20260104054945_TlnTF UK004E 2026-01-05T14:24:09.849Z 2026-01-12T15:10:56.577Z
9147430 9147430 20260104054943_gwu3d UK004E 2026-01-05T14:24:09.277Z 2026-01-12T15:10:56.182Z
9147372 9147372 20260104054127_0MOdp UK004E 2026-01-05T14:24:06.586Z 2026-01-12T15:10:52.722Z
9147353 9147353 20260104053643_fjos1 UK004E 2026-01-05T14:24:05.654Z 2026-01-12T15:10:50.037Z
9147344 9147344 20260104053608_G8TZt UK004E 2026-01-05T14:24:05.294Z 2026-01-12T15:10:49.658Z
9147303 9147303 20260104053049_VBXNC UK004E 2026-01-05T14:24:01.544Z 2026-01-12T15:10:40.533Z
9147226 9147226 20260104052022_TrwdE UK004E 2026-01-05T14:23:49.276Z 2026-01-12T15:10:22.786Z
9147196 9147196 20260104051637_32X1v UK004E 2026-01-05T14:23:39.328Z 2026-01-12T15:10:21.102Z
9147090 9147090 20260104050233_BUwCa UK004E 2026-01-05T14:23:27.166Z 2026-01-12T15:10:10.953Z
9147050 9147050 20260104045800_xPSJY UK004E 2026-01-05T14:23:24.695Z 2026-01-12T15:10:01.539Z
9147026 9147026 20260104045546_NfgWM UK004E 2026-01-05T14:23:23.620Z 2026-01-12T15:09:50.211Z
9147006 9147006 20260104045409_icaLZ UK004E 2026-01-05T14:23:22.621Z 2026-01-12T15:09:48.924Z
9147001 9147001 20260104045339_fuCDV UK004E 2026-01-05T14:23:22.324Z 2026-01-12T15:09:48.220Z
9146980 9146980 20260104045244_n7T93 UK004E 2026-01-05T14:23:21.108Z 2026-01-12T15:09:47.412Z
9146978 9146978 20260104045238_LzUqW UK004E 2026-01-05T14:23:20.637Z 2026-01-12T15:09:46.937Z
9146739 9146739 20260104042107_fibaO UK004E 2026-01-05T14:22:46.984Z 2026-01-12T15:09:11.977Z
9146730 9146730 20260104041952_VDJsB UK004E 2026-01-05T14:22:45.918Z 2026-01-12T15:09:11.085Z
9146672 9146672 20260104041435_wClRK UK004E 2026-01-05T14:22:40.764Z 2026-01-12T15:09:05.074Z
9146525 9146525 20260104035730_3xuss UK004E 2026-01-05T14:22:21.100Z 2026-01-12T15:08:50.232Z
9146517 9146517 20260104035708_wFLGu UK004E 2026-01-05T14:22:20.834Z 2026-01-12T15:08:48.867Z
9146448 9146448 20260104035040_m02yo UK004E 2026-01-05T14:22:15.074Z 2026-01-12T15:08:32.076Z
9146149 9146149 20260104033708_wcb4y UK004E 2026-01-05T14:21:48.675Z 2026-01-12T15:08:20.840Z
9145986 9145986 20260104033243_qdShL UK004E 2026-01-05T14:21:29.831Z 2026-01-12T15:08:17.457Z
9145933 9145933 20260104033132_hkXl2 UK004E 2026-01-05T14:21:26.539Z 2026-01-05T14:30:34.193Z
9145901 9145901 20260104033045_fVz22 UK004E 2026-01-05T14:21:24.635Z 2026-01-12T15:08:15.246Z
9145772 9145772 20260104032813_uBbeT UK004E 2026-01-05T14:21:17.796Z 2026-01-05T14:30:34.163Z
9145654 9145654 20260104032344_5pyvv UK004E 2026-01-05T14:20:57.790Z 2026-01-12T15:07:56.796Z
9145621 9145621 20260104032241_PzvIw UK004E 2026-01-05T14:20:55.599Z 2026-01-12T15:07:54.697Z
9145566 9145566 20260104032016_WxNea UK004E 2026-01-05T14:20:51.394Z 2026-01-12T15:07:52.618Z
9145555 9145555 20260104031939_xZ54G UK004E 2026-01-05T14:20:50.638Z 2026-01-12T15:07:52.403Z
9145552 9145552 20260104031934_Ap9B3 UK004E 2026-01-05T14:20:50.428Z 2026-01-05T14:30:34.120Z
9145546 9145546 20260104031907_2B2Bu UK004E 2026-01-05T14:20:49.619Z 2026-01-12T15:07:51.950Z

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