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

1,773 rows where station_code = "UA0001" 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
9611359 9611359 20260405013403_38Xo1 UA0001 2026-04-06T12:14:06.512Z 2026-04-06T12:16:14.785Z
9611301 9611301 20260405012045_ApVnA UA0001 2026-04-06T12:13:56.567Z 2026-04-06T12:16:14.774Z
9611246 9611246 20260405010130_1gtwE UA0001 2026-04-06T12:13:38.154Z 2026-04-06T12:16:14.762Z
9611067 9611067 20260404235546_wImkK UA0001 2026-04-06T12:12:54.273Z 2026-04-06T12:16:14.725Z
9610953 9610953 20260404230227_ie7xr UA0001 2026-04-06T12:12:13.820Z 2026-04-06T12:16:14.698Z
9610428 9610428 20260404184252_qTri4 UA0001 2026-04-06T12:09:23.424Z 2026-04-06T12:16:14.554Z
9592114 9592114 20260328003815_R8WTG UA0001 2026-03-29T12:07:11.253Z 2026-04-05T12:35:37.270Z
9588709 9588709 20260327003633_NfxhU UA0001 2026-03-28T12:11:41.794Z 2026-04-04T12:42:28.483Z
9588561 9588561 20260326235313_gmeZw UA0001 2026-03-28T12:11:23.061Z 2026-04-04T12:42:19.372Z
9588341 9588341 20260326215606_Z7amM UA0001 2026-03-28T12:10:54.890Z 2026-04-04T12:41:59.880Z
9588325 9588325 20260326214100_GvX6r UA0001 2026-03-28T12:10:53.223Z 2026-04-04T12:41:58.669Z
9585801 9585801 20260327023847_QtyYV UA0001 2026-03-28T12:01:23.214Z 2026-04-05T12:32:46.473Z
9585537 9585537 20260327013220_HIr3Z UA0001 2026-03-28T12:00:35.900Z 2026-04-05T12:32:26.234Z
9585401 9585401 20260327005013_69gVY UA0001 2026-03-28T12:00:13.953Z 2026-04-05T12:32:19.720Z
9580135 9580135 20260325000901_QcgaX UA0001 2026-03-26T12:15:09.059Z 2026-04-02T12:37:43.259Z
9579978 9579978 20260324234208_hrcU8 UA0001 2026-03-26T12:14:48.030Z 2026-04-02T12:37:37.397Z
9579974 9579974 20260324234036_KAHEW UA0001 2026-03-26T12:14:47.526Z 2026-04-02T12:37:37.214Z
9579719 9579719 20260324222519_aI22q UA0001 2026-03-26T12:14:15.845Z 2026-04-02T12:37:27.033Z
9579643 9579643 20260324220200_pS6tt UA0001 2026-03-26T12:14:06.939Z 2026-04-02T12:37:18.692Z
9579506 9579506 20260324210347_U23Mh UA0001 2026-03-26T12:13:50.278Z 2026-04-02T12:37:13.072Z
9579403 9579403 20260324200200_5Ky3p UA0001 2026-03-26T12:13:34.976Z 2026-04-02T12:37:08.310Z
9579364 9579364 20260324185026_Hk43X UA0001 2026-03-26T12:13:22.095Z 2026-04-02T12:37:05.478Z
9576241 9576241 20260325014422_s01w2 UA0001 2026-03-26T12:01:41.373Z 2026-04-03T12:35:50.027Z
9576224 9576224 20260325014059_ByNy1 UA0001 2026-03-26T12:01:37.407Z 2026-04-03T12:35:49.109Z
9575803 9575803 20260325001939_bTc29 UA0001 2026-03-26T12:00:16.510Z 2026-04-03T12:35:23.034Z
9574854 9574854 20260323172900_fcWIy UA0001 2026-03-25T12:19:47.326Z 2026-03-31T12:28:43.430Z
9571533 9571533 20260324024552_NR8p7 UA0001 2026-03-25T12:01:50.515Z 2026-04-02T12:34:30.869Z
9571347 9571347 20260324013148_Q3MqR UA0001 2026-03-25T12:01:08.454Z 2026-04-02T12:34:22.186Z
9533176 9533176 20260320020850_PEA6g UA0001 2026-03-21T12:04:41.196Z 2026-03-28T12:33:49.808Z
9533023 9533023 20260320014803_CwPdI UA0001 2026-03-21T12:04:14.856Z 2026-03-28T12:33:47.678Z
9532449 9532449 20260320005827_zutNe UA0001 2026-03-21T12:02:45.727Z 2026-03-28T12:33:31.513Z
9531103 9531103 20260318222601_x4XFd UA0001 2026-03-20T12:24:57.842Z 2026-03-26T12:39:17.447Z
9531022 9531022 20260318221838_AwcRg UA0001 2026-03-20T12:24:55.134Z 2026-03-26T12:39:17.045Z
9519441 9519441 20260319021035_v927d UA0001 2026-03-20T12:04:29.242Z 2026-03-27T12:40:31.195Z
9518485 9518485 20260319010343_cgOYp UA0001 2026-03-20T12:02:41.670Z 2026-03-27T12:40:10.500Z
9517259 9517259 20260317225855_DwUTw UA0001 2026-03-19T12:27:23.073Z 2026-03-25T12:43:09.656Z
9516744 9516744 20260317215011_C53ES UA0001 2026-03-19T12:26:44.015Z 2026-03-25T12:43:06.576Z
9509496 9509496 20260318015327_8LdH6 UA0001 2026-03-19T12:05:26.837Z 2026-03-26T12:37:05.735Z
9508481 9508481 20260318005906_BS8jY UA0001 2026-03-19T12:03:12.920Z 2026-03-26T12:36:58.900Z
9507813 9507813 20260317234531_o03e4 UA0001 2026-03-19T12:01:22.490Z 2026-03-26T12:36:53.682Z
9492817 9492817 20260314220008_xSaxP UA0001 2026-03-16T12:29:04.556Z 2026-03-22T12:42:54.928Z
9492544 9492544 20260314211404_nJhLK UA0001 2026-03-16T12:28:41.241Z 2026-03-22T12:42:52.912Z
9485418 9485418 20260315030223_qssOp UA0001 2026-03-16T12:06:23.592Z 2026-03-23T12:21:52.215Z
9485037 9485037 20260315021627_GMmEi UA0001 2026-03-16T12:05:01.880Z 2026-03-23T12:21:49.659Z
9484980 9484980 20260315020858_IJUrI UA0001 2026-03-16T12:04:49.943Z 2026-03-23T12:21:49.394Z
9484912 9484912 20260315015906_QM09d UA0001 2026-03-16T12:04:36.054Z 2026-03-23T12:21:48.995Z
9484306 9484306 20260315001754_2zm35 UA0001 2026-03-16T12:02:22.460Z 2026-03-23T12:21:46.218Z
9484235 9484235 20260315000724_PNZkf UA0001 2026-03-16T12:02:04.141Z 2026-03-23T12:21:45.979Z
9484225 9484225 20260315000557_vomlg UA0001 2026-03-16T12:02:01.895Z 2026-03-23T12:21:45.924Z
9482902 9482902 20260313194158_OAB5E UA0001 2026-03-15T12:25:30.334Z 2026-03-21T12:50:08.186Z
9476092 9476092 20260314023721_J8bNC UA0001 2026-03-15T12:05:03.638Z 2026-03-22T12:41:54.170Z
9476074 9476074 20260314023611_hugnX UA0001 2026-03-15T12:04:59.895Z 2026-03-22T12:41:54.055Z
9476037 9476037 20260314023304_wNNXE UA0001 2026-03-15T12:04:55.899Z 2026-03-22T12:41:53.870Z
9475758 9475758 20260314020316_uzkjq UA0001 2026-03-15T12:04:02.475Z 2026-03-22T12:41:51.133Z
9474593 9474593 20260313232102_6gZNH UA0001 2026-03-15T12:00:40.302Z 2026-03-22T12:41:21.659Z
9474162 9474162 20260312211817_R3KcF UA0001 2026-03-14T12:22:13.922Z 2026-03-20T12:37:16.477Z
9469420 9469420 20260313024719_e4F8h UA0001 2026-03-14T12:04:11.921Z 2026-03-21T12:48:38.829Z
9469327 9469327 20260313022929_NEzfh UA0001 2026-03-14T12:03:53.180Z 2026-03-21T12:48:37.567Z
9469214 9469214 20260313021419_WDoER UA0001 2026-03-14T12:03:27.944Z 2026-03-21T12:48:35.258Z
9468999 9468999 20260313013032_UhlYp UA0001 2026-03-14T12:02:37.279Z 2026-03-21T12:48:32.426Z
9468857 9468857 20260313010138_8FrP0 UA0001 2026-03-14T12:02:03.491Z 2026-03-21T12:48:30.363Z
9468799 9468799 20260313004257_ZRMak UA0001 2026-03-14T12:01:50.031Z 2026-03-21T12:48:29.217Z
9468601 9468601 20260312235147_MEatO UA0001 2026-03-14T12:00:56.680Z 2026-03-21T12:48:26.851Z
9468467 9468467 20260312225134_ETPVm UA0001 2026-03-14T12:00:17.719Z 2026-03-21T12:48:24.978Z
9468457 9468457 20260312224932_2pDCJ UA0001 2026-03-14T12:00:14.994Z 2026-03-21T12:48:24.833Z
9467172 9467172 20260311203737_bBglG UA0001 2026-03-13T12:18:38.386Z 2026-03-19T12:45:49.925Z
9466914 9466914 20260311184050_OOUCx UA0001 2026-03-13T12:17:36.082Z 2026-03-19T12:45:43.713Z
9466902 9466902 20260311181942_vlM8I UA0001 2026-03-13T12:17:32.188Z 2026-03-19T12:45:40.144Z
9466891 9466891 20260311173036_l6kNc UA0001 2026-03-13T12:17:23.760Z 2026-03-19T12:45:35.988Z
9460656 9460656 20260310212644_KMSKG UA0001 2026-03-12T12:14:51.190Z 2026-03-18T12:40:17.489Z
9460580 9460580 20260310205201_yTejG UA0001 2026-03-12T12:14:36.455Z 2026-03-18T12:40:15.493Z
9460530 9460530 20260310202507_eDEyD UA0001 2026-03-12T12:14:29.299Z 2026-03-18T12:40:08.594Z
9460436 9460436 20260310192658_ti3W3 UA0001 2026-03-12T12:14:07.701Z 2026-03-18T12:39:57.438Z
9456619 9456619 20260311001504_KzBb0 UA0001 2026-03-12T12:01:16.420Z 2026-03-19T12:44:19.194Z
9456592 9456592 20260311000521_2O3EW UA0001 2026-03-12T12:01:11.290Z 2026-03-19T12:44:18.838Z
9456583 9456583 20260311000214_Q3eQ2 UA0001 2026-03-12T12:01:09.876Z 2026-03-19T12:44:18.728Z
9456278 9456278 20260309223707_letrF UA0001 2026-03-11T12:15:58.725Z 2026-03-17T12:43:02.546Z
9455992 9455992 20260309212002_7J2Fv UA0001 2026-03-11T12:15:23.634Z 2026-03-17T12:42:45.426Z
9455817 9455817 20260309203210_v4q6r UA0001 2026-03-11T12:15:05.534Z 2026-03-17T12:42:39.512Z
9455778 9455778 20260309200948_9A7co UA0001 2026-03-11T12:15:00.917Z 2026-03-17T12:42:38.865Z
9451567 9451567 20260310025050_iUrgC UA0001 2026-03-11T12:03:11.943Z 2026-03-18T12:38:52.475Z
9451385 9451385 20260310020137_vzhGK UA0001 2026-03-11T12:02:38.985Z 2026-03-18T12:38:45.665Z
9451348 9451348 20260310015445_ZFgrR UA0001 2026-03-11T12:02:32.819Z 2026-03-18T12:38:45.166Z
9451260 9451260 20260310013032_XJGA9 UA0001 2026-03-11T12:02:17.358Z 2026-03-18T12:38:43.896Z
9451245 9451245 20260310012804_7FAlD UA0001 2026-03-11T12:02:14.056Z 2026-03-18T12:38:43.715Z
9451163 9451163 20260310010032_2y2iV UA0001 2026-03-11T12:01:55.436Z 2026-03-18T12:38:41.455Z
9450940 9450940 20260309235745_CYJgn UA0001 2026-03-11T12:01:13.361Z 2026-03-18T12:38:38.109Z
9450824 9450824 20260309232331_Ke9zO UA0001 2026-03-11T12:00:49.199Z 2026-03-18T12:38:36.426Z
9450812 9450812 20260309232056_AFcdp UA0001 2026-03-11T12:00:46.497Z 2026-03-18T12:38:36.241Z
9450769 9450769 20260309230907_y7jc8 UA0001 2026-03-11T12:00:36.611Z 2026-03-18T12:38:35.472Z
9450767 9450767 20260309230906_WB9xI UA0001 2026-03-11T12:00:36.413Z 2026-03-18T12:38:35.458Z
9450763 9450763 20260309230756_QzMEj UA0001 2026-03-11T12:00:35.277Z 2026-03-18T12:38:35.407Z
9450697 9450697 20260309224632_IvE2C UA0001 2026-03-11T12:00:17.388Z 2026-03-18T12:38:34.053Z
9450431 9450431 20260308212933_ZSxrR UA0001 2026-03-10T12:19:38.369Z 2026-03-16T12:44:42.430Z
9450376 9450376 20260308210001_yseik UA0001 2026-03-10T12:19:30.492Z 2026-03-16T12:44:41.539Z
9450312 9450312 20260308200722_xsWx3 UA0001 2026-03-10T12:19:12.888Z 2026-03-16T12:44:39.941Z
9450223 9450223 20260308191319_PhNcZ UA0001 2026-03-10T12:18:55.089Z 2026-03-16T12:44:37.855Z
9450186 9450186 20260308181552_Cy4lP UA0001 2026-03-10T12:18:43.453Z 2026-03-16T12:44:36.239Z
9446774 9446774 20260309025727_SqGEV UA0001 2026-03-10T12:03:49.128Z 2026-03-17T12:41:42.688Z
9446767 9446767 20260309025351_JF16V UA0001 2026-03-10T12:03:46.918Z 2026-03-17T12:41:42.508Z

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