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 = "UK009G" 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
9272604 9272604 20260128024815_s7qkO UK009G 2026-01-29T14:27:13.641Z 2026-01-29T14:30:25.382Z
9272338 9272338 20260128013942_rA02f UK009G 2026-01-29T14:26:28.075Z 2026-01-29T14:30:25.332Z
9260659 9260659 20260125062724_aYnfo UK009G 2026-01-26T14:22:48.751Z 2026-01-29T14:44:33.864Z
9260652 9260652 20260125062143_PuRKV UK009G 2026-01-26T14:22:47.606Z 2026-01-29T14:44:33.558Z
9256439 9256439 20260122225229_f8yjl UK009G 2026-01-25T14:21:20.711Z 2026-01-29T14:52:10.023Z
9256268 9256268 20260124063312_ypWlb UK009G 2026-01-25T14:16:23.152Z 2026-01-29T14:48:33.506Z
9256057 9256057 20260124054810_GMJJ1 UK009G 2026-01-25T14:15:40.424Z 2026-01-29T14:48:20.736Z
9252460 9252460 20260123031557_YHB2s UK009G 2026-01-24T14:15:41.538Z 2026-01-29T14:52:55.410Z
9252107 9252107 20260123010358_R6Aa3 UK009G 2026-01-24T14:14:22.115Z 2026-01-29T14:52:33.616Z
9252038 9252038 20260123004322_585ec UK009G 2026-01-24T14:14:09.341Z 2026-01-29T14:52:25.451Z
9251916 9251916 20260122235937_KjQWt UK009G 2026-01-24T14:13:43.377Z 2026-01-29T14:52:17.067Z
9251778 9251778 20260122224011_4ah6p UK009G 2026-01-24T14:13:12.197Z 2026-01-29T14:52:09.306Z
9251668 9251668 20260122214926_2PFSM UK009G 2026-01-24T14:12:44.346Z 2026-01-29T14:51:57.815Z
9251647 9251647 20260122214505_SnNQK UK009G 2026-01-24T14:12:42.689Z 2026-01-29T14:51:57.110Z
9251617 9251617 20260122212819_zQ3al UK009G 2026-01-24T14:12:36.992Z 2026-01-29T14:51:55.132Z
9251501 9251501 20260122202900_As9Mz UK009G 2026-01-24T14:11:55.542Z 2026-01-29T14:51:44.661Z
9251445 9251445 20260122201541_o3JZJ UK009G 2026-01-24T14:11:45.923Z 2026-01-29T14:51:41.849Z
9251410 9251410 20260122200513_pSqe1 UK009G 2026-01-24T14:11:39.060Z 2026-01-29T14:51:39.886Z
9243464 9243464 20260121043459_1VNOQ UK009G 2026-01-22T14:22:01.268Z 2026-01-29T15:05:03.518Z
9243417 9243417 20260121043001_azrqI UK009G 2026-01-22T14:21:42.793Z 2026-01-29T15:05:01.457Z
9243001 9243001 20260121032950_gklbm UK009G 2026-01-22T14:20:16.952Z 2026-01-29T15:04:43.302Z
9242546 9242546 20260121021227_yC73t UK009G 2026-01-22T14:18:22.616Z 2026-01-29T15:04:06.845Z
9242529 9242529 20260121021013_itoN7 UK009G 2026-01-22T14:18:12.266Z 2026-01-29T15:04:03.138Z
9242464 9242464 20260121015518_oWcbU UK009G 2026-01-22T14:17:55.764Z 2026-01-29T15:03:59.727Z
9242444 9242444 20260121015135_e5HDT UK009G 2026-01-22T14:17:52.394Z 2026-01-29T15:03:58.994Z
9242009 9242009 20260121000033_aRHog UK009G 2026-01-22T14:15:50.597Z 2026-01-29T15:03:24.989Z
9237903 9237903 20260120062149_RDlih UK009G 2026-01-21T14:28:01.812Z 2026-01-28T15:01:58.222Z
9237744 9237744 20260120055858_ePcnq UK009G 2026-01-21T14:27:33.714Z 2026-01-28T15:01:38.969Z
9234454 9234454 20260119213240_TVipm UK009G 2026-01-21T14:14:31.794Z 2026-01-28T14:57:47.300Z
9218837 9218837 20260117060420_IDJdv UK009G 2026-01-18T14:13:54.448Z 2026-01-25T14:58:52.875Z
9218728 9218728 20260117053012_6QkRl UK009G 2026-01-18T14:13:26.897Z 2026-01-25T14:58:37.075Z
9218279 9218279 20260117022208_VqGhg UK009G 2026-01-18T14:11:24.245Z 2026-01-25T14:58:19.779Z
9214549 9214549 20260116065258_9njTW UK009G 2026-01-17T14:22:03.341Z 2026-01-24T15:13:51.145Z
9214461 9214461 20260116063849_jnD2Z UK009G 2026-01-17T14:21:36.992Z 2026-01-24T15:13:38.372Z
9214215 9214215 20260116055440_8hN1N UK009G 2026-01-17T14:20:37.082Z 2026-01-24T15:13:23.280Z
9214189 9214189 20260116055214_8Pj1w UK009G 2026-01-17T14:20:30.448Z 2026-01-24T15:13:21.009Z
9214181 9214181 20260116055013_RkA8j UK009G 2026-01-17T14:20:28.539Z 2026-01-24T15:13:20.237Z
9214166 9214166 20260116054845_HBekv UK009G 2026-01-17T14:20:25.793Z 2026-01-24T15:13:19.320Z
9212575 9212575 20260115231450_81meK UK009G 2026-01-17T14:12:45.054Z 2026-01-24T15:11:03.939Z
9207212 9207212 20260114235747_NFURG UK009G 2026-01-16T14:07:42.869Z 2026-01-22T15:03:14.796Z
9207192 9207192 20260114233753_h334F UK009G 2026-01-16T14:07:36.821Z 2026-01-22T15:03:14.088Z
9207180 9207180 20260114232719_OJc2W UK009G 2026-01-16T14:07:33.414Z 2026-01-22T15:03:13.318Z
9203039 9203039 20260114043022_B3Wvv UK009G 2026-01-15T14:23:13.088Z 2026-01-22T15:10:01.051Z
9202682 9202682 20260114040100_23LYp UK009G 2026-01-15T14:22:07.603Z 2026-01-22T15:09:24.836Z
9202612 9202612 20260114035447_QpcLR UK009G 2026-01-15T14:21:46.656Z 2026-01-22T15:09:23.663Z
9202475 9202475 20260114034208_7QnYh UK009G 2026-01-15T14:21:29.084Z 2026-01-22T15:09:20.984Z
9202135 9202135 20260114032010_z39Qj UK009G 2026-01-15T14:20:34.559Z 2026-01-22T15:09:13.968Z
9202125 9202125 20260114031742_KlUEl UK009G 2026-01-15T14:20:33.997Z 2026-01-22T15:09:13.837Z
9202059 9202059 20260114031258_EjR71 UK009G 2026-01-15T14:20:18.531Z 2026-01-22T15:09:12.564Z
9201881 9201881 20260114030441_B482B UK009G 2026-01-15T14:20:04.325Z 2026-01-22T15:09:11.047Z
9201837 9201837 20260114025831_NMcYt UK009G 2026-01-15T14:19:53.341Z 2026-01-22T15:09:10.389Z
9201643 9201643 20260114023739_4CGGn UK009G 2026-01-15T14:19:13.658Z 2026-01-22T15:09:06.969Z
9201474 9201474 20260114022026_nrLPh UK009G 2026-01-15T14:18:42.362Z 2026-01-22T15:09:04.227Z
9201387 9201387 20260114021211_7hEqR UK009G 2026-01-15T14:18:29.335Z 2026-01-22T15:09:02.834Z
9200871 9200871 20260114011555_J9HY1 UK009G 2026-01-15T14:16:44.166Z 2026-01-22T15:08:31.921Z
9189215 9189215 20260112032926_YBjPS UK009G 2026-01-13T14:16:23.938Z 2026-01-20T15:22:56.981Z
9180600 9180600 20260110210658_XtxkU UK009G 2026-01-12T14:07:40.231Z 2026-01-19T15:16:24.177Z
9180454 9180454 20260110202755_Z9I6s UK009G 2026-01-12T14:07:08.639Z 2026-01-19T15:16:03.339Z
9179825 9179825 20260110174744_37RYd UK009G 2026-01-12T14:04:29.524Z 2026-01-19T15:15:19.197Z
9176957 9176957 20260110065205_GoU2A UK009G 2026-01-11T14:10:30.512Z 2026-01-18T15:09:09.312Z
9176412 9176412 20260110052848_v6qDk UK009G 2026-01-11T14:08:56.118Z 2026-01-18T15:08:38.327Z
9176285 9176285 20260110051203_H8bLE UK009G 2026-01-11T14:08:38.717Z 2026-01-18T15:08:26.145Z
9176257 9176257 20260110051006_qR47z UK009G 2026-01-11T14:08:36.535Z 2026-01-18T15:08:25.515Z
9176148 9176148 20260110045236_IhKtQ UK009G 2026-01-11T14:08:18.805Z 2026-01-18T15:08:22.090Z
9176087 9176087 20260110044156_Wq2LY UK009G 2026-01-11T14:08:10.252Z 2026-01-18T15:08:18.973Z
9176069 9176069 20260110043834_lr280 UK009G 2026-01-11T14:08:08.447Z 2026-01-18T15:08:18.492Z
9175961 9175961 20260110043025_xBvD3 UK009G 2026-01-11T14:07:54.344Z 2026-01-18T15:08:14.937Z
9175956 9175956 20260110042715_0gjns UK009G 2026-01-11T14:07:52.914Z 2026-01-18T15:08:14.636Z
9175938 9175938 20260110042700_efkMK UK009G 2026-01-11T14:07:51.236Z 2026-01-18T15:08:14.193Z
9175872 9175872 20260110040122_Q2xvh UK009G 2026-01-11T14:07:35.124Z 2026-01-18T15:08:11.437Z
9175815 9175815 20260110035151_GwCxS UK009G 2026-01-11T14:07:26.538Z 2026-01-18T15:08:09.340Z
9175723 9175723 20260110033738_tK93o UK009G 2026-01-11T14:07:13.899Z 2026-01-18T15:08:06.291Z
9175719 9175719 20260110033523_miEeC UK009G 2026-01-11T14:07:13.466Z 2026-01-18T15:08:06.132Z
9175710 9175710 20260110033130_v24yq UK009G 2026-01-11T14:07:12.303Z 2026-01-18T15:08:05.903Z
9175504 9175504 20260110023943_o2hFO UK009G 2026-01-11T14:06:34.260Z 2026-01-18T15:07:47.601Z
9175446 9175446 20260110023007_wnDDR UK009G 2026-01-11T14:06:27.129Z 2026-01-18T15:07:46.004Z
9175402 9175402 20260110022250_E2LnS UK009G 2026-01-11T14:06:20.763Z 2026-01-18T15:07:44.381Z
9175302 9175302 20260110015932_u4X1G UK009G 2026-01-11T14:06:00.403Z 2026-01-18T15:07:40.296Z
9175279 9175279 20260110015351_ajI8W UK009G 2026-01-11T14:05:56.241Z 2026-01-18T15:07:39.451Z
9175188 9175188 20260110013353_3GrBE UK009G 2026-01-11T14:05:38.071Z 2026-01-18T15:07:36.144Z
9175156 9175156 20260110012520_Nw1a0 UK009G 2026-01-11T14:05:33.193Z 2026-01-18T15:07:29.659Z
9175047 9175047 20260110004905_Orv8F UK009G 2026-01-11T14:05:14.748Z 2026-01-18T15:07:23.978Z
9175032 9175032 20260110004758_2Wc5l UK009G 2026-01-11T14:05:12.666Z 2026-01-18T15:07:23.583Z
9174988 9174988 20260110003309_R5wq5 UK009G 2026-01-11T14:05:03.055Z 2026-01-18T15:07:20.649Z
9174863 9174863 20260109233846_yGYK3 UK009G 2026-01-11T14:04:38.545Z 2026-01-18T15:07:14.322Z
9174855 9174855 20260109233713_NAJ6O UK009G 2026-01-11T14:04:37.584Z 2026-01-18T15:07:14.104Z
9174830 9174830 20260109232144_QA9Zo UK009G 2026-01-11T14:04:32.375Z 2026-01-18T15:07:12.778Z
9174802 9174802 20260109230602_VKaYJ UK009G 2026-01-11T14:04:27.093Z 2026-01-18T15:07:11.552Z
9174783 9174783 20260109224935_n9EP6 UK009G 2026-01-11T14:04:23.548Z 2026-01-18T15:07:10.809Z
9174773 9174773 20260109223633_Z3MIy UK009G 2026-01-11T14:04:20.748Z 2026-01-18T15:07:10.255Z
9174680 9174680 20260109214001_s3q21 UK009G 2026-01-11T14:04:02.398Z 2026-01-18T15:06:57.909Z
9174609 9174609 20260109204804_SM5HX UK009G 2026-01-11T14:03:47.525Z 2026-01-18T15:06:54.741Z
9174597 9174597 20260109204710_MJdDe UK009G 2026-01-11T14:03:46.611Z 2026-01-18T15:06:54.332Z
9174560 9174560 20260109201844_9BzZG UK009G 2026-01-11T14:03:37.283Z 2026-01-18T15:06:51.377Z
9174439 9174439 20260109185554_4rLc8 UK009G 2026-01-11T14:03:12.215Z 2026-01-18T15:06:46.020Z
9163477 9163477 20260107065118_lXz3E UK009G 2026-01-08T14:09:14.222Z 2026-01-13T15:03:16.888Z
9163463 9163463 20260107064751_Sgmky UK009G 2026-01-08T14:09:12.724Z 2026-01-13T15:03:16.496Z
9163412 9163412 20260107063337_0PA06 UK009G 2026-01-08T14:09:05.186Z 2026-01-13T15:03:14.610Z
9163363 9163363 20260107062650_63hON UK009G 2026-01-08T14:08:53.453Z 2026-01-13T15:03:11.019Z
9163273 9163273 20260107061451_bc1s4 UK009G 2026-01-08T14:08:38.944Z 2026-01-13T15:03:07.746Z

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