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

8,852 rows where station_code = "UK0045" 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
9273372 9273372 20260128055439_ihrXX UK0045 2026-01-29T14:29:29.384Z 2026-01-29T14:30:25.797Z
9273242 9273242 20260128051318_RD6fp UK0045 2026-01-29T14:29:11.188Z 2026-01-29T14:30:25.775Z
9273161 9273161 20260128050149_fIto2 UK0045 2026-01-29T14:28:53.272Z 2026-01-29T14:30:25.762Z
9272934 9272934 20260128040357_lyfl8 UK0045 2026-01-29T14:28:15.621Z 2026-01-29T14:30:25.708Z
9272750 9272750 20260128031610_QyJGA UK0045 2026-01-29T14:27:42.111Z 2026-01-29T14:30:25.447Z
9272400 9272400 20260128015556_R37vM UK0045 2026-01-29T14:26:35.735Z 2026-01-29T14:30:25.342Z
9272383 9272383 20260128015145_da7d6 UK0045 2026-01-29T14:26:34.220Z 2026-01-29T14:30:25.339Z
9272267 9272267 20260128010754_J9l4b UK0045 2026-01-29T14:26:09.380Z 2026-01-29T14:30:25.318Z
9272209 9272209 20260128004829_Kka6d UK0045 2026-01-29T14:25:56.773Z 2026-01-29T14:30:25.308Z
9256145 9256145 20260124060302_cm8wo UK0045 2026-01-25T14:16:02.415Z 2026-01-29T14:48:25.688Z
9255859 9255859 20260124050937_0Fnxa UK0045 2026-01-25T14:14:59.803Z 2026-01-29T14:48:01.869Z
9255852 9255852 20260124050917_ylGs6 UK0045 2026-01-25T14:14:59.255Z 2026-01-29T14:48:01.694Z
9254864 9254864 20260123220918_ihy0m UK0045 2026-01-25T14:10:57.988Z 2026-01-29T14:46:52.807Z
9252220 9252220 20260123014818_MAkdM UK0045 2026-01-24T14:14:46.797Z 2026-01-29T14:52:40.372Z
9252193 9252193 20260123014011_12Xx4 UK0045 2026-01-24T14:14:42.719Z 2026-01-29T14:52:38.895Z
9243715 9243715 20260121051047_NjMZV UK0045 2026-01-22T14:22:50.242Z 2026-01-29T15:05:24.833Z
9230520 9230520 20260119042858_mGKpT UK0045 2026-01-20T14:28:21.116Z 2026-01-27T15:05:00.911Z
9230516 9230516 20260119042858_NBc1a UK0045 2026-01-20T14:28:20.467Z 2026-01-27T15:05:00.561Z
9204245 9204245 20260114062010_zEb7K UK0045 2026-01-15T14:26:53.985Z 2026-01-22T15:10:23.076Z
9204144 9204144 20260114061014_L47rf UK0045 2026-01-15T14:26:30.671Z 2026-01-22T15:10:21.020Z
9204000 9204000 20260114060328_xuoHY UK0045 2026-01-15T14:26:14.664Z 2026-01-22T15:10:16.895Z
9203928 9203928 20260114055658_QEIZ6 UK0045 2026-01-15T14:25:53.973Z 2026-01-22T15:10:15.813Z
9203381 9203381 20260114045330_6qnOR UK0045 2026-01-15T14:24:12.408Z 2026-01-22T15:10:06.622Z
9202950 9202950 20260114042107_dkgVw UK0045 2026-01-15T14:22:52.028Z 2026-01-22T15:09:59.872Z
9202584 9202584 20260114035221_ySoo6 UK0045 2026-01-15T14:21:44.255Z 2026-01-22T15:09:23.421Z
9202413 9202413 20260114033619_uZ0Io UK0045 2026-01-15T14:21:14.289Z 2026-01-22T15:09:17.411Z
9202391 9202391 20260114033358_p918a UK0045 2026-01-15T14:21:11.614Z 2026-01-22T15:09:17.121Z
9202323 9202323 20260114032903_UckTi UK0045 2026-01-15T14:21:04.496Z 2026-01-22T15:09:16.331Z
9201691 9201691 20260114024132_auZC1 UK0045 2026-01-15T14:19:18.049Z 2026-01-22T15:09:07.422Z
9182201 9182201 20260111044120_IIjWO UK0045 2026-01-12T14:13:42.110Z 2026-01-19T15:18:20.451Z
9180803 9180803 20260110224022_92C8T UK0045 2026-01-12T14:08:25.848Z 2026-01-19T15:16:33.359Z
9180572 9180572 20260110205557_vsnO6 UK0045 2026-01-12T14:07:34.038Z 2026-01-19T15:16:22.976Z
9166368 9166368 20260107180341_ZOFzZ UK0045 2026-01-09T14:02:53.873Z 2026-01-16T15:09:49.864Z
9163200 9163200 20260107060600_Ibl9y UK0045 2026-01-08T14:08:24.587Z 2026-01-13T15:03:05.240Z
9163005 9163005 20260107052243_sw4He UK0045 2026-01-08T14:07:41.759Z 2026-01-13T15:02:51.281Z
9162853 9162853 20260107044549_k7KTM UK0045 2026-01-08T14:07:05.525Z 2026-01-13T15:02:42.552Z
9160594 9160594 20260106062901_FITHW UK0045 2026-01-07T14:13:06.490Z 2026-01-13T15:09:34.383Z
9160505 9160505 20260106060436_k7kJS UK0045 2026-01-07T14:12:50.717Z 2026-01-13T15:09:28.907Z
9160398 9160398 20260106054620_FTwiC UK0045 2026-01-07T14:12:29.945Z 2026-01-13T15:09:24.748Z
9160335 9160335 20260106053340_tiAZI UK0045 2026-01-07T14:12:18.353Z 2026-01-13T15:09:20.710Z
9158182 9158182 20260105205219_zk024 UK0045 2026-01-07T14:05:14.261Z 2026-01-13T15:07:02.842Z
9156011 9156011 20260104063704_j4lbs UK0045 2026-01-06T14:38:25.430Z 2026-01-12T15:11:34.708Z
9155372 9155372 20260104055252_W2O4J UK0045 2026-01-06T14:37:17.727Z 2026-01-12T15:10:58.540Z
9147627 9147627 20260104061958_7GbN5 UK0045 2026-01-05T14:24:38.691Z 2026-01-12T15:11:26.562Z
9147590 9147590 20260104061105_aS7gy UK0045 2026-01-05T14:24:36.152Z 2026-01-12T15:11:23.356Z
9147463 9147463 20260104055335_3yoZP UK0045 2026-01-05T14:24:12.159Z 2026-01-12T15:10:59.388Z
9147342 9147342 20260104053608_G8TZt UK0045 2026-01-05T14:24:05.293Z 2026-01-12T15:10:49.658Z
9147260 9147260 20260104052453_GF1dq UK0045 2026-01-05T14:23:57.805Z 2026-01-12T15:10:26.852Z
9147221 9147221 20260104052018_T0ZHu UK0045 2026-01-05T14:23:44.288Z 2026-01-12T15:10:22.658Z
9147088 9147088 20260104050233_BUwCa UK0045 2026-01-05T14:23:27.166Z 2026-01-12T15:10:10.953Z
9147048 9147048 20260104045800_xPSJY UK0045 2026-01-05T14:23:24.695Z 2026-01-12T15:10:01.539Z
9147025 9147025 20260104045546_NfgWM UK0045 2026-01-05T14:23:23.620Z 2026-01-12T15:09:50.211Z
9146976 9146976 20260104045238_LzUqW UK0045 2026-01-05T14:23:20.637Z 2026-01-12T15:09:46.937Z
9146966 9146966 20260104045200_Ewzvd UK0045 2026-01-05T14:23:20.368Z 2026-01-12T15:09:46.540Z
9146833 9146833 20260104043312_9jsHM UK0045 2026-01-05T14:22:54.714Z 2026-01-12T15:09:34.624Z
9146738 9146738 20260104042107_fibaO UK0045 2026-01-05T14:22:46.984Z 2026-01-12T15:09:11.977Z
9146735 9146735 20260104042104_viF8e UK0045 2026-01-05T14:22:46.840Z 2026-01-12T15:09:11.654Z
9146627 9146627 20260104040921_iMWts UK0045 2026-01-05T14:22:37.551Z 2026-01-12T15:09:01.781Z
9146474 9146474 20260104035304_Qi5e3 UK0045 2026-01-05T14:22:17.908Z 2026-01-12T15:08:33.946Z
9146386 9146386 20260104034750_2d3Cm UK0045 2026-01-05T14:22:10.943Z 2026-01-12T15:08:27.334Z
9145652 9145652 20260104032344_5pyvv UK0045 2026-01-05T14:20:57.790Z 2026-01-12T15:07:56.796Z
9145494 9145494 20260104031803_e2mCA UK0045 2026-01-05T14:20:46.978Z 2026-01-12T15:07:50.420Z
9145393 9145393 20260104031514_ZcJbh UK0045 2026-01-05T14:20:31.589Z 2026-01-12T15:07:48.108Z
9145118 9145118 20260104030503_2y48M UK0045 2026-01-05T14:20:12.014Z 2026-01-12T15:07:41.714Z
9144939 9144939 20260104025949_2F4HV UK0045 2026-01-05T14:19:44.962Z 2026-01-12T15:07:20.013Z
9144416 9144416 20260104024342_PR6SH UK0045 2026-01-05T14:19:03.362Z 2026-01-12T15:07:06.752Z
9143944 9143944 20260104022919_3x529 UK0045 2026-01-05T14:18:27.251Z 2026-01-12T15:06:55.552Z
9143153 9143153 20260104015741_qFc5C UK0045 2026-01-05T14:17:01.393Z 2026-01-12T15:06:15.229Z
9142996 9142996 20260104015228_N7usG UK0045 2026-01-05T14:16:46.629Z 2026-01-12T15:06:10.628Z
9132200 9132200 20260103062349_8Ivuk UK0045 2026-01-04T14:16:06.414Z 2026-01-10T15:01:16.958Z
9132114 9132114 20260103061935_j1IZL UK0045 2026-01-04T14:15:54.088Z 2026-01-10T15:01:13.063Z
9131801 9131801 20260103055800_LOIkn UK0045 2026-01-04T14:14:57.772Z 2026-01-10T15:00:54.264Z
9131780 9131780 20260103055452_uYWHi UK0045 2026-01-04T14:14:54.055Z 2026-01-10T15:00:53.253Z
9131602 9131602 20260103053941_MLX8t UK0045 2026-01-04T14:14:27.992Z 2026-01-10T15:00:44.041Z
9131443 9131443 20260103052543_EV2a5 UK0045 2026-01-04T14:13:56.360Z 2026-01-10T15:00:27.946Z
9131304 9131304 20260103051057_yYMOU UK0045 2026-01-04T14:13:25.525Z 2026-01-10T15:00:20.462Z
9131275 9131275 20260103050827_VFnoI UK0045 2026-01-04T14:13:21.370Z 2026-01-10T15:00:18.972Z
9131266 9131266 20260103050649_YAxoZ UK0045 2026-01-04T14:13:19.074Z 2026-01-10T15:00:18.675Z
9131100 9131100 20260103045029_2efmn UK0045 2026-01-04T14:12:41.657Z 2026-01-10T15:00:00.471Z
9130915 9130915 20260103043022_MkcqG UK0045 2026-01-04T14:12:03.787Z 2026-01-10T14:59:51.110Z
9126928 9126928 20260102013926_Zg42m UK0045 2026-01-03T14:07:30.138Z 2026-01-09T14:49:18.964Z
9126708 9126708 20260102001441_TghYY UK0045 2026-01-03T14:06:15.744Z 2026-01-09T14:48:58.314Z
9126697 9126697 20260102001234_6LKx1 UK0045 2026-01-03T14:06:06.716Z 2026-01-09T14:48:57.824Z
9126660 9126660 20260101235202_2FdGv UK0045 2026-01-03T14:05:55.782Z 2026-01-09T14:48:56.209Z
9123957 9123957 20251231041459_Z2gG1 UK0045 2026-01-02T14:38:54.712Z 2026-01-08T15:09:45.485Z
9123887 9123887 20251231040106_k04W3 UK0045 2026-01-02T14:37:56.192Z 2026-01-08T15:09:22.287Z
9123539 9123539 20251231015340_7wuqm UK0045 2026-01-02T14:30:20.475Z 2026-01-08T15:07:10.990Z
9123431 9123431 20251231004806_EriBZ UK0045 2026-01-02T14:27:38.119Z 2026-01-08T15:06:20.613Z
9123306 9123306 20251230225425_aOpCD UK0045 2026-01-02T14:24:04.344Z 2026-01-08T15:05:19.378Z
9115681 9115681 20251231052230_7I3Tp UK0045 2026-01-01T14:26:09.255Z 2026-01-08T15:11:07.966Z
9114401 9114401 20251231041459_RHIOf UK0045 2026-01-01T14:22:23.460Z 2026-01-01T14:57:53.649Z
9114239 9114239 20251231040832_xGTEL UK0045 2026-01-01T14:21:56.727Z 2026-01-08T15:09:39.427Z
9114221 9114221 20251231040730_S2hav UK0045 2026-01-01T14:21:53.319Z 2026-01-08T15:09:38.470Z
9114038 9114038 20251231040106_M5Hk6 UK0045 2026-01-01T14:21:18.976Z 2026-01-01T14:57:53.485Z
9112659 9112659 20251231024519_bAKY2 UK0045 2026-01-01T14:15:55.184Z 2026-01-01T14:57:52.272Z
9112071 9112071 20251231020304_n0sCd UK0045 2026-01-01T14:13:54.209Z 2026-01-08T15:07:17.450Z
9111953 9111953 20251231015340_tTFUe UK0045 2026-01-01T14:13:24.855Z 2026-01-08T15:07:10.924Z
9111651 9111651 20251231013250_DC2K1 UK0045 2026-01-01T14:12:20.356Z 2026-01-08T15:06:49.425Z
9111199 9111199 20251231004806_BWXA8 UK0045 2026-01-01T14:10:27.210Z 2026-01-08T15:06:20.470Z
9110954 9110954 20251231002412_2kv2J UK0045 2026-01-01T14:09:32.917Z 2026-01-08T15:06:08.514Z

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