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

2,015 rows where station_code = "UK009R" 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
9606765 9606765 20260402204458_2hMTX UK009R 2026-04-04T12:11:32.231Z 2026-04-06T12:23:40.064Z
9595501 9595501 20260330042247_2tlzY UK009R 2026-03-31T12:01:35.699Z 2026-04-06T12:30:06.523Z
9595466 9595466 20260330040906_4bcEw UK009R 2026-03-31T12:01:29.265Z 2026-04-06T12:30:05.054Z
9595350 9595350 20260330034609_cDtVb UK009R 2026-03-31T12:01:12.030Z 2026-04-06T12:29:59.056Z
9595222 9595222 20260330030729_P1356 UK009R 2026-03-31T12:00:50.037Z 2026-04-06T12:29:48.794Z
9594645 9594645 20260328234304_2hkxH UK009R 2026-03-30T12:10:02.810Z 2026-04-06T12:40:02.464Z
9594620 9594620 20260328233442_81lpJ UK009R 2026-03-30T12:10:00.231Z 2026-04-06T12:40:01.842Z
9592981 9592981 20260329040850_6yRg7 UK009R 2026-03-30T12:02:29.988Z 2026-04-06T12:34:43.396Z
9592856 9592856 20260329034014_CFq3h UK009R 2026-03-30T12:02:06.981Z 2026-04-06T12:34:37.393Z
9592794 9592794 20260329032309_QDQok UK009R 2026-03-30T12:01:56.355Z 2026-04-06T12:34:28.364Z
9592626 9592626 20260329024807_ieG6s UK009R 2026-03-30T12:01:27.201Z 2026-04-06T12:34:18.091Z
9592616 9592616 20260329024726_pm2hD UK009R 2026-03-30T12:01:26.701Z 2026-04-06T12:34:17.964Z
9592439 9592439 20260329020546_sQRZL UK009R 2026-03-30T12:00:57.746Z 2026-04-06T12:34:10.355Z
9592430 9592430 20260329020531_Fpecy UK009R 2026-03-30T12:00:57.086Z 2026-04-06T12:34:10.104Z
9592386 9592386 20260329015937_nK405 UK009R 2026-03-30T12:00:51.299Z 2026-04-06T12:34:08.723Z
9592343 9592343 20260329015637_KVxci UK009R 2026-03-30T12:00:44.489Z 2026-04-06T12:34:01.555Z
9592310 9592310 20260329014942_jcNi0 UK009R 2026-03-30T12:00:38.599Z 2026-04-06T12:33:59.922Z
9589992 9589992 20260328042607_RoJ2b UK009R 2026-03-29T12:01:49.064Z 2026-04-06T12:37:40.205Z
9589831 9589831 20260328041052_Y9CFb UK009R 2026-03-29T12:01:39.505Z 2026-04-06T12:37:35.804Z
9589660 9589660 20260328035735_9zHgL UK009R 2026-03-29T12:01:32.697Z 2026-04-06T12:37:30.805Z
9589600 9589600 20260328034818_e8Hvl UK009R 2026-03-29T12:01:27.771Z 2026-04-06T12:37:28.516Z
9589524 9589524 20260328034219_4h8qC UK009R 2026-03-29T12:01:23.616Z 2026-04-06T12:37:26.796Z
9589427 9589427 20260328032850_c1neJ UK009R 2026-03-29T12:01:13.744Z 2026-04-06T12:37:23.275Z
9586174 9586174 20260327042608_ELvrE UK009R 2026-03-28T12:02:25.786Z 2026-04-05T12:33:06.344Z
9585362 9585362 20260326002430_sSswi UK009R 2026-03-27T12:17:11.676Z 2026-04-03T12:39:57.963Z
9584996 9584996 20260325230013_1hU9C UK009R 2026-03-27T12:16:29.865Z 2026-04-03T12:39:46.019Z
9581985 9581985 20260326041922_VHYsD UK009R 2026-03-27T12:04:19.821Z 2026-04-04T12:39:33.836Z
9581729 9581729 20260326035326_vn6Hn UK009R 2026-03-27T12:03:45.839Z 2026-04-04T12:39:17.221Z
9581454 9581454 20260326031446_o0HWz UK009R 2026-03-27T12:03:10.095Z 2026-04-04T12:39:06.584Z
9581264 9581264 20260326024455_KoNt3 UK009R 2026-03-27T12:02:34.775Z 2026-04-04T12:38:51.012Z
9581222 9581222 20260326023740_j6nKa UK009R 2026-03-27T12:02:25.475Z 2026-04-04T12:38:46.578Z
9581217 9581217 20260326023740_kSqBq UK009R 2026-03-27T12:02:25.086Z 2026-04-04T12:38:46.407Z
9581202 9581202 20260326023624_qmkxj UK009R 2026-03-27T12:02:21.843Z 2026-04-04T12:38:45.577Z
9581107 9581107 20260326022412_AFJOx UK009R 2026-03-27T12:02:09.543Z 2026-04-04T12:38:42.990Z
9581082 9581082 20260326022107_uBcJx UK009R 2026-03-27T12:02:05.336Z 2026-04-04T12:38:41.933Z
9581072 9581072 20260326022027_enCu2 UK009R 2026-03-27T12:02:03.759Z 2026-04-04T12:38:41.505Z
9580937 9580937 20260326015506_ZOL3Z UK009R 2026-03-27T12:01:43.233Z 2026-04-04T12:38:34.699Z
9580884 9580884 20260326014843_VF9Ao UK009R 2026-03-27T12:01:37.499Z 2026-04-04T12:38:32.142Z
9580867 9580867 20260326014801_J51nm UK009R 2026-03-27T12:01:36.282Z 2026-04-04T12:38:31.620Z
9580497 9580497 20260326005550_XGAs2 UK009R 2026-03-27T12:00:39.162Z 2026-04-04T12:38:12.395Z
9580488 9580488 20260326005524_l1kWK UK009R 2026-03-27T12:00:36.789Z 2026-04-04T12:38:12.049Z
9580093 9580093 20260325000306_TSz4X UK009R 2026-03-26T12:15:04.100Z 2026-04-02T12:37:41.809Z
9580019 9580019 20260324234848_aRIe7 UK009R 2026-03-26T12:14:53.476Z 2026-04-02T12:37:39.110Z
9576569 9576569 20260325023439_Vf37I UK009R 2026-03-26T12:02:38.549Z 2026-04-03T12:36:12.784Z
9576552 9576552 20260325023110_8VIh6 UK009R 2026-03-26T12:02:35.948Z 2026-04-03T12:36:12.331Z
9576455 9576455 20260325021009_XeKMh UK009R 2026-03-26T12:02:19.305Z 2026-04-03T12:35:59.778Z
9576120 9576120 20260325011810_5Y3Vd UK009R 2026-03-26T12:01:22.174Z 2026-04-03T12:35:45.117Z
9575734 9575734 20260321202326_PKpff UK009R 2026-03-25T12:31:32.286Z 2026-03-29T12:20:57.406Z
9575714 9575714 20260321031555_EhFTG UK009R 2026-03-25T12:28:02.766Z 2026-03-29T12:19:05.090Z
9575693 9575693 20260321002017_5yZNL UK009R 2026-03-25T12:27:33.106Z 2026-03-29T12:18:46.230Z
9562529 9562529 20260323022921_T5z57 UK009R 2026-03-24T12:03:19.809Z 2026-03-31T12:26:13.518Z
9561318 9561318 20260321232120_c0cq0 UK009R 2026-03-23T12:12:16.321Z 2026-03-29T12:21:06.326Z
9560958 9560958 20260321223916_oekKm UK009R 2026-03-23T12:12:08.425Z 2026-03-29T12:21:04.174Z
9560427 9560427 20260321212207_5dyIC UK009R 2026-03-23T12:11:46.645Z 2026-03-29T12:21:00.098Z
9560234 9560234 20260321204918_HjP3E UK009R 2026-03-23T12:11:40.463Z 2026-03-29T12:20:58.710Z
9560116 9560116 20260321203259_DUxv6 UK009R 2026-03-23T12:11:38.230Z 2026-03-29T12:20:58.034Z
9555175 9555175 20260322041337_ZFqaA UK009R 2026-03-23T12:03:13.285Z 2026-03-30T12:28:22.191Z
9554369 9554369 20260322030253_FJRnl UK009R 2026-03-23T12:02:28.662Z 2026-03-30T12:28:02.960Z
9554044 9554044 20260322023432_VoXm0 UK009R 2026-03-23T12:02:10.874Z 2026-03-30T12:27:57.363Z
9553838 9553838 20260322022019_jfMDm UK009R 2026-03-23T12:01:54.996Z 2026-03-30T12:27:53.451Z
9553476 9553476 20260322014439_rqHGI UK009R 2026-03-23T12:01:32.508Z 2026-03-30T12:27:41.848Z
9553191 9553191 20260322012339_lUY3w UK009R 2026-03-23T12:01:18.693Z 2026-03-30T12:27:36.222Z
9552204 9552204 20260320231851_ANgHk UK009R 2026-03-22T12:27:32.581Z 2026-03-28T12:37:07.877Z
9552103 9552103 20260320225822_xH5vb UK009R 2026-03-22T12:27:27.477Z 2026-03-28T12:37:06.959Z
9551638 9551638 20260320203913_gIPrX UK009R 2026-03-22T12:26:53.198Z 2026-03-28T12:36:59.265Z
9551619 9551619 20260320203537_fdym5 UK009R 2026-03-22T12:26:51.879Z 2026-03-28T12:36:58.774Z
9551488 9551488 20260320195534_QVWN7 UK009R 2026-03-22T12:26:43.033Z 2026-03-28T12:36:56.049Z
9542813 9542813 20260321012717_S3nFD UK009R 2026-03-22T12:01:41.773Z 2026-03-29T12:18:58.622Z
9542771 9542771 20260321012143_fFGE3 UK009R 2026-03-22T12:01:35.466Z 2026-03-29T12:18:58.120Z
9542134 9542134 20260319224925_Q3EAW UK009R 2026-03-21T12:29:41.869Z 2026-03-27T12:42:45.379Z
9534326 9534326 20260320034200_Udwqh UK009R 2026-03-21T12:07:42.689Z 2026-03-28T12:34:17.369Z
9533942 9533942 20260320031004_ZWyJQ UK009R 2026-03-21T12:06:42.066Z 2026-03-28T12:34:02.462Z
9533517 9533517 20260320023611_j4hN9 UK009R 2026-03-21T12:05:34.961Z 2026-03-28T12:33:54.402Z
9533516 9533516 20260320023606_9QPqJ UK009R 2026-03-21T12:05:34.413Z 2026-03-28T12:33:54.242Z
9533253 9533253 20260320021821_6xBhc UK009R 2026-03-21T12:04:56.091Z 2026-03-28T12:33:51.098Z
9532036 9532036 20260320001205_jW2DC UK009R 2026-03-21T12:01:32.705Z 2026-03-28T12:33:24.144Z
9531952 9531952 20260320000540_hiQCA UK009R 2026-03-21T12:01:16.575Z 2026-03-28T12:33:23.071Z
9531669 9531669 20260319233450_hcrxd UK009R 2026-03-21T12:00:27.079Z 2026-03-28T12:33:19.963Z
9531422 9531422 20260318230759_tX12m UK009R 2026-03-20T12:25:10.111Z 2026-03-26T12:39:19.290Z
9530996 9530996 20260318221220_zde2H UK009R 2026-03-20T12:24:53.975Z 2026-03-26T12:39:16.861Z
9530967 9530967 20260318221109_3gsvD UK009R 2026-03-20T12:24:53.347Z 2026-03-26T12:39:16.733Z
9530821 9530821 20260318214555_dM64r UK009R 2026-03-20T12:24:48.043Z 2026-03-26T12:39:15.799Z
9530712 9530712 20260318213114_0IHp3 UK009R 2026-03-20T12:24:36.892Z 2026-03-26T12:39:15.002Z
9530624 9530624 20260318211813_FjHFf UK009R 2026-03-20T12:24:32.606Z 2026-03-26T12:39:14.325Z
9529753 9529753 20260318192552_PLzbT UK009R 2026-03-20T12:23:37.265Z 2026-03-26T12:39:06.208Z
9521921 9521921 20260319045654_YJemY UK009R 2026-03-20T12:08:44.618Z 2026-03-27T12:41:11.825Z
9521351 9521351 20260319040806_vAt1S UK009R 2026-03-20T12:07:52.446Z 2026-03-27T12:40:54.020Z
9521185 9521185 20260319035639_AG5SH UK009R 2026-03-20T12:07:40.454Z 2026-03-27T12:40:52.399Z
9521108 9521108 20260319035419_EYGdl UK009R 2026-03-20T12:07:32.156Z 2026-03-27T12:40:51.737Z
9520909 9520909 20260319034428_43iMH UK009R 2026-03-20T12:07:13.410Z 2026-03-27T12:40:48.913Z
9520873 9520873 20260319034310_JqM1R UK009R 2026-03-20T12:07:09.859Z 2026-03-27T12:40:48.418Z
9520848 9520848 20260319034115_6Plg2 UK009R 2026-03-20T12:07:04.364Z 2026-03-27T12:40:48.013Z
9520773 9520773 20260319033604_636lt UK009R 2026-03-20T12:06:57.207Z 2026-03-27T12:40:47.276Z
9520439 9520439 20260319031614_Ow8FK UK009R 2026-03-20T12:06:22.985Z 2026-03-27T12:40:43.202Z
9519418 9519418 20260319020929_0cRsz UK009R 2026-03-20T12:04:26.768Z 2026-03-27T12:40:30.934Z
9518537 9518537 20260319010630_eI1u0 UK009R 2026-03-20T12:02:46.583Z 2026-03-27T12:40:11.159Z
9518407 9518407 20260319005711_9v9Mv UK009R 2026-03-20T12:02:29.214Z 2026-03-27T12:40:09.293Z
9518403 9518403 20260319005711_8k1SP UK009R 2026-03-20T12:02:28.596Z 2026-03-27T12:40:09.262Z
9518285 9518285 20260319004736_M18nB UK009R 2026-03-20T12:02:15.492Z 2026-03-27T12:40:08.182Z
9518251 9518251 20260319004625_jKy71 UK009R 2026-03-20T12:02:12.417Z 2026-03-27T12:40:07.929Z

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