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 = "UK005N" 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
9273376 9273376 20260128055633_ht5ax UK005N 2026-01-29T14:29:29.845Z 2026-01-29T14:30:25.797Z
9273352 9273352 20260128054901_7VxJ9 UK005N 2026-01-29T14:29:24.777Z 2026-01-29T14:30:25.793Z
9273332 9273332 20260128054155_kRwkH UK005N 2026-01-29T14:29:21.600Z 2026-01-29T14:30:25.789Z
9273168 9273168 20260128050254_212R0 UK005N 2026-01-29T14:28:54.160Z 2026-01-29T14:30:25.763Z
9273144 9273144 20260128045206_syodL UK005N 2026-01-29T14:28:51.251Z 2026-01-29T14:30:25.759Z
9273078 9273078 20260128043246_DQmhn UK005N 2026-01-29T14:28:42.732Z 2026-01-29T14:30:25.746Z
9273001 9273001 20260128041935_Wgr7Q UK005N 2026-01-29T14:28:24.603Z 2026-01-29T14:30:25.733Z
9272805 9272805 20260128033928_uknpk UK005N 2026-01-29T14:27:51.813Z 2026-01-29T14:30:25.564Z
9272505 9272505 20260128022119_LaYIc UK005N 2026-01-29T14:27:01.067Z 2026-01-29T14:30:25.363Z
9272259 9272259 20260128010344_3YbRp UK005N 2026-01-29T14:26:08.469Z 2026-01-29T14:30:25.317Z
9271626 9271626 20260127184451_iaQUN UK005N 2026-01-29T14:21:54.061Z 2026-01-29T14:30:24.977Z
9256169 9256169 20260124060554_T2Joy UK005N 2026-01-25T14:16:06.074Z 2026-01-29T14:48:27.050Z
9255920 9255920 20260124052111_248V7 UK005N 2026-01-25T14:15:09.732Z 2026-01-29T14:48:08.186Z
9254976 9254976 20260123234545_n23pp UK005N 2026-01-25T14:11:31.029Z 2026-01-29T14:46:58.129Z
9254963 9254963 20260123233746_wjmkR UK005N 2026-01-25T14:11:29.240Z 2026-01-29T14:46:57.699Z
9254887 9254887 20260123221846_8i862 UK005N 2026-01-25T14:11:03.524Z 2026-01-29T14:46:53.788Z
9254853 9254853 20260123220127_Tvdgg UK005N 2026-01-25T14:10:56.816Z 2026-01-29T14:46:51.742Z
9254394 9254394 20260123185300_qgv2r UK005N 2026-01-25T14:08:58.714Z 2026-01-29T14:46:13.820Z
9253023 9253023 20260119031953_4rx39 UK005N 2026-01-24T14:53:41.791Z 2026-01-27T15:04:22.927Z
9252244 9252244 20260123015714_Ov0k4 UK005N 2026-01-24T14:14:50.638Z 2026-01-29T14:52:41.578Z
9251716 9251716 20260122221140_gZzQY UK005N 2026-01-24T14:12:59.772Z 2026-01-29T14:52:04.468Z
9244095 9244095 20260121061202_2a3na UK005N 2026-01-22T14:24:08.601Z 2026-01-29T15:05:51.585Z
9243990 9243990 20260121054738_j23Re UK005N 2026-01-22T14:23:51.936Z 2026-01-29T15:05:37.721Z
9243866 9243866 20260121052728_NaVD3 UK005N 2026-01-22T14:23:23.668Z 2026-01-29T15:05:30.676Z
9242628 9242628 20260121022550_vcAE7 UK005N 2026-01-22T14:18:37.601Z 2026-01-29T15:04:14.881Z
9235858 9235858 20260120020749_a8pnv UK005N 2026-01-21T14:20:34.975Z 2026-01-28T14:59:24.743Z
9235821 9235821 20260120020335_k37uD UK005N 2026-01-21T14:20:29.133Z 2026-01-28T14:59:22.565Z
9230880 9230880 20260119052356_oysQe UK005N 2026-01-20T14:30:11.713Z 2026-01-27T15:05:34.417Z
9230867 9230867 20260119051955_iBzoY UK005N 2026-01-20T14:30:09.144Z 2026-01-27T15:05:33.778Z
9229847 9229847 20260119024430_c7FZu UK005N 2026-01-20T14:24:36.924Z 2026-01-27T15:04:00.670Z
9229646 9229646 20260119021003_xQRPH UK005N 2026-01-20T14:23:33.369Z 2026-01-27T15:03:46.710Z
9229593 9229593 20260119020514_bV7kb UK005N 2026-01-20T14:23:16.474Z 2026-01-27T15:03:44.123Z
9229011 9229011 20260119003441_0F0P6 UK005N 2026-01-20T14:20:36.935Z 2026-01-27T15:02:47.833Z
9213304 9213304 20260116030606_80ZyN UK005N 2026-01-17T14:16:21.617Z 2026-01-24T15:12:08.337Z
9213290 9213290 20260116030435_Eefut UK005N 2026-01-17T14:16:19.469Z 2026-01-24T15:12:07.822Z
9213250 9213250 20260116024918_pLGHI UK005N 2026-01-17T14:16:07.033Z 2026-01-24T15:11:53.994Z
9213248 9213248 20260116024657_lAcVo UK005N 2026-01-17T14:16:05.719Z 2026-01-24T15:11:51.449Z
9212964 9212964 20260116014329_j8Sys UK005N 2026-01-17T14:14:44.897Z 2026-01-24T15:11:35.735Z
9204439 9204439 20260114064408_TQStq UK005N 2026-01-15T14:27:23.741Z 2026-01-22T15:10:28.489Z
9204172 9204172 20260114061351_rS9rc UK005N 2026-01-15T14:26:36.427Z 2026-01-22T15:10:21.826Z
9204029 9204029 20260114060417_MaPVB UK005N 2026-01-15T14:26:17.552Z 2026-01-22T15:10:17.179Z
9203946 9203946 20260114055832_Y4yqj UK005N 2026-01-15T14:25:56.790Z 2026-01-22T15:10:16.029Z
9203893 9203893 20260114054806_DuRZu UK005N 2026-01-15T14:25:47.785Z 2026-01-22T15:10:15.055Z
9203779 9203779 20260114053712_X80oV UK005N 2026-01-15T14:25:23.375Z 2026-01-22T15:10:13.423Z
9203744 9203744 20260114053438_4DmQV UK005N 2026-01-15T14:25:20.628Z 2026-01-22T15:10:13.044Z
9203737 9203737 20260114053336_O90hl UK005N 2026-01-15T14:25:17.569Z 2026-01-22T15:10:12.821Z
9203394 9203394 20260114045346_QKRZd UK005N 2026-01-15T14:24:18.193Z 2026-01-22T15:10:06.832Z
9203003 9203003 20260114042610_4szaq UK005N 2026-01-15T14:23:01.482Z 2026-01-22T15:10:00.532Z
9202850 9202850 20260114041313_TOge1 UK005N 2026-01-15T14:22:37.933Z 2026-01-22T15:09:57.869Z
9202293 9202293 20260114032641_fM7mr UK005N 2026-01-15T14:20:59.397Z 2026-01-22T15:09:16.052Z
9202190 9202190 20260114032224_DXn0O UK005N 2026-01-15T14:20:40.102Z 2026-01-22T15:09:14.537Z
9202175 9202175 20260114032201_e54Vx UK005N 2026-01-15T14:20:39.005Z 2026-01-22T15:09:14.449Z
9202120 9202120 20260114031742_KlUEl UK005N 2026-01-15T14:20:33.997Z 2026-01-22T15:09:13.837Z
9202011 9202011 20260114031002_0HwCL UK005N 2026-01-15T14:20:14.499Z 2026-01-22T15:09:12.097Z
9201978 9201978 20260114030932_cHnlD UK005N 2026-01-15T14:20:13.061Z 2026-01-22T15:09:11.939Z
9201957 9201957 20260114030722_BkT8y UK005N 2026-01-15T14:20:11.357Z 2026-01-22T15:09:11.758Z
9201875 9201875 20260114030441_B482B UK005N 2026-01-15T14:20:04.325Z 2026-01-22T15:09:11.047Z
9201539 9201539 20260114022848_hJgCT UK005N 2026-01-15T14:18:54.412Z 2026-01-22T15:09:05.588Z
9201507 9201507 20260114022348_D6Yvm UK005N 2026-01-15T14:18:46.196Z 2026-01-22T15:09:04.630Z
9195500 9195500 20260113013711_jJKaz UK005N 2026-01-14T14:13:37.233Z 2026-01-21T15:04:41.475Z
9195103 9195103 20260113001929_Tn5mF UK005N 2026-01-14T14:12:02.215Z 2026-01-21T15:04:36.226Z
9194947 9194947 20260112234038_n0Si9 UK005N 2026-01-14T14:11:25.571Z 2026-01-21T15:04:34.306Z
9194914 9194914 20260112233005_fnVZ7 UK005N 2026-01-14T14:11:16.851Z 2026-01-21T15:04:33.959Z
9194769 9194769 20260112223715_r2HZu UK005N 2026-01-14T14:10:38.588Z 2026-01-21T15:04:20.802Z
9194745 9194745 20260112223006_c5PcY UK005N 2026-01-14T14:10:30.404Z 2026-01-21T15:04:20.532Z
9179823 9179823 20260110174744_37RYd UK005N 2026-01-12T14:04:29.517Z 2026-01-19T15:15:19.197Z
9162788 9162788 20260107042919_33xSj UK005N 2026-01-08T14:06:51.477Z 2026-01-13T15:02:38.860Z
9159772 9159772 20260106034314_2KzXM UK005N 2026-01-07T14:10:21.524Z 2026-01-13T15:08:42.774Z
9159759 9159759 20260106034040_YgoX5 UK005N 2026-01-07T14:10:20.150Z 2026-01-13T15:08:39.892Z
9159648 9159648 20260106032135_zoOk8 UK005N 2026-01-07T14:10:02.023Z 2026-01-13T15:08:36.206Z
9159095 9159095 20260106014310_IqIEj UK005N 2026-01-07T14:08:17.063Z 2026-01-13T15:08:03.144Z
9159051 9159051 20260106013532_HGCV0 UK005N 2026-01-07T14:08:11.518Z 2026-01-13T15:07:59.028Z
9158723 9158723 20260106001024_QxLaL UK005N 2026-01-07T14:07:04.956Z 2026-01-13T15:07:43.947Z
9158589 9158589 20260105232956_BXnhd UK005N 2026-01-07T14:06:39.495Z 2026-01-13T15:07:31.557Z
9158433 9158433 20260105222853_KRgNi UK005N 2026-01-07T14:06:05.820Z 2026-01-13T15:07:22.186Z
9158051 9158051 20260105194456_38mmE UK005N 2026-01-07T14:04:36.492Z 2026-01-13T15:06:51.184Z
9157664 9157664 20260105181601_63AJw UK005N 2026-01-07T14:03:05.833Z 2026-01-13T15:06:23.157Z
9150530 9150530 20260105024010_XbR5A UK005N 2026-01-06T14:10:22.410Z 2026-01-13T15:13:38.909Z
9150525 9150525 20260105023811_rojbG UK005N 2026-01-06T14:10:20.573Z 2026-01-13T15:13:38.108Z
9149583 9149583 20260104220810_u3NbS UK005N 2026-01-06T14:06:11.826Z 2026-01-13T15:12:19.526Z
9149135 9149135 20260104185437_KLNUw UK005N 2026-01-06T14:03:57.445Z 2026-01-13T15:11:43.861Z
9147491 9147491 20260104055654_oFF32 UK005N 2026-01-05T14:24:14.366Z 2026-01-12T15:11:02.979Z
9147388 9147388 20260104054245_dRyzb UK005N 2026-01-05T14:24:07.252Z 2026-01-12T15:10:53.338Z
9147322 9147322 20260104053144_ZoK0N UK005N 2026-01-05T14:24:02.876Z 2026-01-12T15:10:46.444Z
9142528 9142528 20260104013745_wHrPd UK005N 2026-01-05T14:16:09.863Z 2026-01-12T15:05:45.715Z
9142453 9142453 20260104013513_6W558 UK005N 2026-01-05T14:16:06.162Z 2026-01-12T15:05:43.667Z
9140193 9140193 20260104000258_ew6ZD UK005N 2026-01-05T14:12:40.608Z 2026-01-12T15:04:01.418Z
9139973 9139973 20260103235228_vcRlg UK005N 2026-01-05T14:12:19.599Z 2026-01-12T15:03:54.645Z
9139956 9139956 20260103235228_OzxzO UK005N 2026-01-05T14:12:19.142Z 2026-01-12T15:03:54.489Z
9139443 9139443 20260103233239_hROCx UK005N 2026-01-05T14:11:40.080Z 2026-01-12T15:03:29.170Z
9138949 9138949 20260103230358_zfpxx UK005N 2026-01-05T14:10:59.391Z 2026-01-12T15:03:16.573Z
9138213 9138213 20260103221104_tKga0 UK005N 2026-01-05T14:09:40.513Z 2026-01-12T15:02:43.224Z
9137993 9137993 20260103215114_sxxD6 UK005N 2026-01-05T14:09:16.520Z 2026-01-12T15:02:27.192Z
9137908 9137908 20260103214640_bNW4L UK005N 2026-01-05T14:09:10.690Z 2026-01-12T15:02:24.072Z
9137230 9137230 20260103205336_AVKUc UK005N 2026-01-05T14:08:04.514Z 2026-01-12T15:01:53.810Z
9137045 9137045 20260103203512_fDy51 UK005N 2026-01-05T14:07:45.972Z 2026-01-12T15:01:46.442Z
9136996 9136996 20260103203108_NSZBf UK005N 2026-01-05T14:07:42.855Z 2026-01-12T15:01:45.171Z
9136607 9136607 20260103200734_HBY36 UK005N 2026-01-05T14:07:02.858Z 2026-01-12T15:01:24.367Z
9136517 9136517 20260103200014_nUYhv UK005N 2026-01-05T14:06:53.089Z 2026-01-12T15:01:22.117Z
9136351 9136351 20260103195056_hgcrk UK005N 2026-01-05T14:06:35.973Z 2026-01-12T15:01:15.915Z

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