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 = "UK000S" 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
9260667 9260667 20260125063837_JY2u9 UK000S 2026-01-26T14:22:50.811Z 2026-01-29T14:44:34.479Z
9260656 9260656 20260125062724_aYnfo UK000S 2026-01-26T14:22:48.751Z 2026-01-29T14:44:33.864Z
9260650 9260650 20260125062143_PuRKV UK000S 2026-01-26T14:22:47.606Z 2026-01-29T14:44:33.558Z
9260626 9260626 20260125060010_z2M2a UK000S 2026-01-26T14:22:39.202Z 2026-01-29T14:44:32.042Z
9260565 9260565 20260125053011_o6aIc UK000S 2026-01-26T14:22:25.218Z 2026-01-29T14:44:27.879Z
9260529 9260529 20260125051628_1yx4m UK000S 2026-01-26T14:22:07.707Z 2026-01-29T14:44:20.171Z
9260187 9260187 20260125025946_Bdvg3 UK000S 2026-01-26T14:20:35.882Z 2026-01-29T14:43:56.892Z
9260118 9260118 20260125023834_Lwd8n UK000S 2026-01-26T14:20:20.692Z 2026-01-29T14:43:49.785Z
9260096 9260096 20260125023308_MPn2B UK000S 2026-01-26T14:20:15.929Z 2026-01-29T14:43:46.405Z
9256452 9256452 20260121000119_rppAs UK000S 2026-01-25T14:32:26.151Z 2026-01-29T15:03:25.252Z
9256434 9256434 20260122201541_90NC6 UK000S 2026-01-25T14:20:52.241Z 2026-01-29T14:51:42.018Z
9256010 9256010 20260124054236_xhwhE UK000S 2026-01-25T14:15:33.927Z 2026-01-29T14:48:18.402Z
9252444 9252444 20260123030956_QZtnm UK000S 2026-01-24T14:15:38.121Z 2026-01-29T14:52:54.552Z
9252318 9252318 20260123021338_oEYcf UK000S 2026-01-24T14:15:06.546Z 2026-01-29T14:52:45.049Z
9252274 9252274 20260123020334_3vc0Y UK000S 2026-01-24T14:14:54.337Z 2026-01-29T14:52:43.327Z
9252102 9252102 20260123010358_R6Aa3 UK000S 2026-01-24T14:14:22.087Z 2026-01-29T14:52:33.616Z
9252078 9252078 20260123005351_L1K9S UK000S 2026-01-24T14:14:18.588Z 2026-01-29T14:52:27.504Z
9252032 9252032 20260123004322_585ec UK000S 2026-01-24T14:14:09.341Z 2026-01-29T14:52:25.451Z
9251929 9251929 20260123000149_KNX93 UK000S 2026-01-24T14:13:45.334Z 2026-01-29T14:52:17.504Z
9251922 9251922 20260123000101_r2zxy UK000S 2026-01-24T14:13:44.735Z 2026-01-29T14:52:17.298Z
9251883 9251883 20260122234545_UWUuv UK000S 2026-01-24T14:13:29.803Z 2026-01-29T14:52:15.207Z
9251827 9251827 20260122231805_Lt9JM UK000S 2026-01-24T14:13:20.556Z 2026-01-29T14:52:12.129Z
9251713 9251713 20260122221140_gZzQY UK000S 2026-01-24T14:12:59.764Z 2026-01-29T14:52:04.467Z
9251679 9251679 20260122220354_N2Zcv UK000S 2026-01-24T14:12:53.128Z 2026-01-29T14:51:58.822Z
9251665 9251665 20260122214926_2PFSM UK000S 2026-01-24T14:12:44.346Z 2026-01-29T14:51:57.815Z
9251641 9251641 20260122214505_SnNQK UK000S 2026-01-24T14:12:42.689Z 2026-01-29T14:51:57.110Z
9251615 9251615 20260122212819_zQ3al UK000S 2026-01-24T14:12:36.973Z 2026-01-29T14:51:55.132Z
9251536 9251536 20260122204725_fVFIK UK000S 2026-01-24T14:12:10.897Z 2026-01-29T14:51:47.487Z
9251498 9251498 20260122202900_As9Mz UK000S 2026-01-24T14:11:55.533Z 2026-01-29T14:51:44.661Z
9251443 9251443 20260122201541_o3JZJ UK000S 2026-01-24T14:11:45.917Z 2026-01-29T14:51:41.849Z
9242875 9242875 20260121030717_4phD3 UK000S 2026-01-22T14:19:38.139Z 2026-01-29T15:04:25.785Z
9242657 9242657 20260121023001_Yjcb4 UK000S 2026-01-22T14:18:41.528Z 2026-01-29T15:04:15.840Z
9242015 9242015 20260121000119_Imw2Q UK000S 2026-01-22T14:15:51.595Z 2026-01-24T14:32:15.388Z
9237743 9237743 20260120055858_ePcnq UK000S 2026-01-21T14:27:33.714Z 2026-01-28T15:01:38.969Z
9237242 9237242 20260120045417_HZUJX UK000S 2026-01-21T14:25:45.956Z 2026-01-28T15:01:05.672Z
9234418 9234418 20260119212036_i1ei6 UK000S 2026-01-21T14:14:22.147Z 2026-01-28T14:57:44.752Z
9218789 9218789 20260117054845_EmbUq UK000S 2026-01-18T14:13:42.053Z 2026-01-25T14:58:51.377Z
9214501 9214501 20260116064602_oJaNB UK000S 2026-01-17T14:21:48.006Z 2026-01-24T15:13:43.229Z
9214437 9214437 20260116063436_13nJc UK000S 2026-01-17T14:21:33.377Z 2026-01-24T15:13:37.537Z
9214397 9214397 20260116062739_PIiRZ UK000S 2026-01-17T14:21:20.577Z 2026-01-24T15:13:34.065Z
9214185 9214185 20260116055037_JW0fi UK000S 2026-01-17T14:20:29.060Z 2026-01-24T15:13:20.477Z
9214126 9214126 20260116054112_jh33v UK000S 2026-01-17T14:20:10.481Z 2026-01-24T15:13:16.806Z
9214027 9214027 20260116052318_QawlA UK000S 2026-01-17T14:19:42.710Z 2026-01-24T15:12:58.592Z
9213050 9213050 20260116020211_XcUyn UK000S 2026-01-17T14:15:10.876Z 2026-01-24T15:11:38.676Z
9213048 9213048 20260116020150_jUNiI UK000S 2026-01-17T14:15:09.586Z 2026-01-24T15:11:38.570Z
9212970 9212970 20260116014518_HapiL UK000S 2026-01-17T14:14:46.414Z 2026-01-24T15:11:35.907Z
9212780 9212780 20260116005813_q6Nzt UK000S 2026-01-17T14:13:50.995Z 2026-01-24T15:11:26.261Z
9212667 9212667 20260116001117_J2VE2 UK000S 2026-01-17T14:13:11.401Z 2026-01-24T15:11:09.385Z
9212619 9212619 20260115234708_QDaTe UK000S 2026-01-17T14:12:57.496Z 2026-01-24T15:11:07.592Z
9212593 9212593 20260115234051_ZHSPD UK000S 2026-01-17T14:12:51.121Z 2026-01-24T15:11:06.778Z
9212578 9212578 20260115231450_ERxw4 UK000S 2026-01-17T14:12:46.006Z 2026-01-24T15:11:04.057Z
9207193 9207193 20260114233900_P6RDs UK000S 2026-01-16T14:07:37.423Z 2026-01-22T15:03:14.175Z
9204450 9204450 20260114064408_fLKCd UK000S 2026-01-15T14:27:24.144Z 2026-01-22T15:10:28.522Z
9204179 9204179 20260114061351_E85dN UK000S 2026-01-15T14:26:37.254Z 2026-01-22T15:10:21.894Z
9203804 9203804 20260114053756_Wkz4u UK000S 2026-01-15T14:25:25.779Z 2026-01-22T15:10:13.710Z
9203749 9203749 20260114053438_NIm3n UK000S 2026-01-15T14:25:21.063Z 2026-01-22T15:10:13.083Z
9203091 9203091 20260114043249_jetAf UK000S 2026-01-15T14:23:17.615Z 2026-01-22T15:10:01.407Z
9203043 9203043 20260114043023_V1nJT UK000S 2026-01-15T14:23:13.574Z 2026-01-22T15:10:01.093Z
9202967 9202967 20260114042327_OiLVe UK000S 2026-01-15T14:22:54.538Z 2026-01-22T15:10:00.146Z
9202864 9202864 20260114041403_oVo5B UK000S 2026-01-15T14:22:40.388Z 2026-01-22T15:09:58.293Z
9202687 9202687 20260114040259_2kSzM UK000S 2026-01-15T14:22:08.902Z 2026-01-22T15:09:26.977Z
9202518 9202518 20260114034432_FOhnA UK000S 2026-01-15T14:21:34.365Z 2026-01-22T15:09:21.688Z
9202469 9202469 20260114034208_3JK6j UK000S 2026-01-15T14:21:27.788Z 2026-01-22T15:09:20.876Z
9202443 9202443 20260114033811_gHrAD UK000S 2026-01-15T14:21:19.310Z 2026-01-22T15:09:19.389Z
9202372 9202372 20260114033321_5l185 UK000S 2026-01-15T14:21:09.330Z 2026-01-22T15:09:16.868Z
9202194 9202194 20260114032224_wuWeK UK000S 2026-01-15T14:20:40.663Z 2026-01-22T15:09:14.673Z
9202140 9202140 20260114032011_msxWS UK000S 2026-01-15T14:20:35.093Z 2026-01-22T15:09:14.061Z
9202109 9202109 20260114031742_13ncE UK000S 2026-01-15T14:20:33.474Z 2026-01-22T15:09:13.789Z
9202077 9202077 20260114031524_VA9xk UK000S 2026-01-15T14:20:23.734Z 2026-01-22T15:09:13.183Z
9202000 9202000 20260114031001_9Nbwj UK000S 2026-01-15T14:20:14.092Z 2026-01-22T15:09:12.024Z
9201889 9201889 20260114030441_gLeWu UK000S 2026-01-15T14:20:05.084Z 2026-01-22T15:09:11.079Z
9201648 9201648 20260114023743_A0fL9 UK000S 2026-01-15T14:19:14.186Z 2026-01-22T15:09:07.010Z
9201588 9201588 20260114023422_cP9Yb UK000S 2026-01-15T14:19:09.058Z 2026-01-22T15:09:06.485Z
9201537 9201537 20260114022848_2xsSU UK000S 2026-01-15T14:18:53.905Z 2026-01-22T15:09:05.502Z
9201479 9201479 20260114022028_Yi6z0 UK000S 2026-01-15T14:18:42.930Z 2026-01-22T15:09:04.277Z
9201440 9201440 20260114021827_aLHrG UK000S 2026-01-15T14:18:40.765Z 2026-01-22T15:09:04.029Z
9201382 9201382 20260114021210_OPezr UK000S 2026-01-15T14:18:24.582Z 2026-01-22T15:09:02.755Z
9201354 9201354 20260114021131_fSojh UK000S 2026-01-15T14:18:20.185Z 2026-01-22T15:09:02.233Z
9201252 9201252 20260114020217_TyLM9 UK000S 2026-01-15T14:18:06.101Z 2026-01-22T15:09:00.678Z
9194143 9194143 20260112182135_Qv2GW UK000S 2026-01-14T14:07:35.827Z 2026-01-21T15:03:34.937Z
9180670 9180670 20260110213001_FXibK UK000S 2026-01-12T14:07:57.024Z 2026-01-19T15:16:26.958Z
9180599 9180599 20260110210658_XtxkU UK000S 2026-01-12T14:07:40.231Z 2026-01-19T15:16:24.177Z
9180450 9180450 20260110202755_Z9I6s UK000S 2026-01-12T14:07:08.605Z 2026-01-19T15:16:03.339Z
9179822 9179822 20260110174744_37RYd UK000S 2026-01-12T14:04:29.517Z 2026-01-19T15:15:19.197Z
9176951 9176951 20260110065205_GoU2A UK000S 2026-01-11T14:10:30.511Z 2026-01-18T15:09:09.312Z
9176752 9176752 20260110061901_KwR25 UK000S 2026-01-11T14:09:52.960Z 2026-01-18T15:08:53.025Z
9176687 9176687 20260110060402_NjYQd UK000S 2026-01-11T14:09:43.522Z 2026-01-18T15:08:48.895Z
9176674 9176674 20260110060402_GDPnB UK000S 2026-01-11T14:09:43.072Z 2026-01-18T15:08:48.831Z
9176539 9176539 20260110054149_uudLN UK000S 2026-01-11T14:09:17.612Z 2026-01-18T15:08:43.291Z
9176409 9176409 20260110052848_v6qDk UK000S 2026-01-11T14:08:56.118Z 2026-01-18T15:08:38.327Z
9176378 9176378 20260110052400_K2gGb UK000S 2026-01-11T14:08:51.554Z 2026-01-18T15:08:36.914Z
9176210 9176210 20260110050238_JL8SD UK000S 2026-01-11T14:08:27.901Z 2026-01-18T15:08:24.082Z
9176082 9176082 20260110044156_Wq2LY UK000S 2026-01-11T14:08:10.252Z 2026-01-18T15:08:18.973Z
9176066 9176066 20260110043834_lr280 UK000S 2026-01-11T14:08:08.447Z 2026-01-18T15:08:18.492Z
9175959 9175959 20260110043025_xBvD3 UK000S 2026-01-11T14:07:54.344Z 2026-01-18T15:08:14.937Z
9175847 9175847 20260110035711_FVtb6 UK000S 2026-01-11T14:07:30.743Z 2026-01-18T15:08:10.460Z
9175811 9175811 20260110035151_GwCxS UK000S 2026-01-11T14:07:26.538Z 2026-01-18T15:08:09.340Z
9175721 9175721 20260110033738_tK93o UK000S 2026-01-11T14:07:13.898Z 2026-01-18T15:08:06.291Z
9175716 9175716 20260110033523_miEeC UK000S 2026-01-11T14:07:13.466Z 2026-01-18T15:08:06.132Z
9175650 9175650 20260110032101_rA93o UK000S 2026-01-11T14:07:00.410Z 2026-01-18T15:07:55.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