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

4,973 rows where station_code = "UK000Z" 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
9608595 9608595 20260403235002_rn5BE UK000Z 2026-04-05T12:10:52.806Z 2026-04-06T12:20:23.803Z
9608548 9608548 20260403233613_P42BT UK000Z 2026-04-05T12:10:48.113Z 2026-04-06T12:20:19.860Z
9608510 9608510 20260403232828_KBD4y UK000Z 2026-04-05T12:10:42.473Z 2026-04-06T12:20:17.942Z
9608299 9608299 20260403214323_I2XVV UK000Z 2026-04-05T12:09:59.367Z 2026-04-06T12:20:05.175Z
9589673 9589673 20260328035906_SO7di UK000Z 2026-03-29T12:01:33.578Z 2026-04-06T12:37:31.405Z
9589594 9589594 20260328034814_msn76 UK000Z 2026-03-29T12:01:27.386Z 2026-04-06T12:37:28.338Z
9589573 9589573 20260328034710_4edJ6 UK000Z 2026-03-29T12:01:26.332Z 2026-04-06T12:37:27.875Z
9589477 9589477 20260328033503_BxrgB UK000Z 2026-03-29T12:01:19.606Z 2026-04-06T12:37:25.492Z
9585120 9585120 20260325233255_S5b7r UK000Z 2026-03-27T12:16:47.359Z 2026-04-03T12:39:50.215Z
9584963 9584963 20260325225639_NvVP2 UK000Z 2026-03-27T12:16:27.065Z 2026-04-03T12:39:45.335Z
9581945 9581945 20260326041429_07fzY UK000Z 2026-03-27T12:04:14.827Z 2026-04-04T12:39:32.426Z
9581665 9581665 20260326034146_6EhqR UK000Z 2026-03-27T12:03:37.644Z 2026-04-04T12:39:14.132Z
9581558 9581558 20260326033113_OwaM9 UK000Z 2026-03-27T12:03:25.278Z 2026-04-04T12:39:10.830Z
9581542 9581542 20260326033021_6ux4t UK000Z 2026-03-27T12:03:24.212Z 2026-04-04T12:39:10.480Z
9580671 9580671 20260326011457_wfDbY UK000Z 2026-03-27T12:01:08.057Z 2026-04-04T12:38:20.329Z
9555324 9555324 20260322044034_InYWt UK000Z 2026-03-23T12:03:20.882Z 2026-03-30T12:28:24.918Z
9554841 9554841 20260322033930_3lIQz UK000Z 2026-03-23T12:02:53.373Z 2026-03-30T12:28:10.408Z
9554375 9554375 20260322030255_V68ZC UK000Z 2026-03-23T12:02:28.880Z 2026-03-30T12:28:03.037Z
9551918 9551918 20260320221347_zheMm UK000Z 2026-03-22T12:27:17.874Z 2026-03-28T12:37:04.310Z
9541707 9541707 20260319213158_UJ206 UK000Z 2026-03-21T12:29:17.784Z 2026-03-27T12:42:40.994Z
9541630 9541630 20260319211236_pEN6e UK000Z 2026-03-21T12:29:13.685Z 2026-03-27T12:42:40.365Z
9529868 9529868 20260318193840_l71hU UK000Z 2026-03-20T12:23:46.767Z 2026-03-26T12:39:07.084Z
9521858 9521858 20260319045001_9BncR UK000Z 2026-03-20T12:08:40.956Z 2026-03-27T12:41:11.386Z
9520326 9520326 20260319031029_SmG3T UK000Z 2026-03-20T12:06:14.503Z 2026-03-27T12:40:42.094Z
9519987 9519987 20260319024700_PPRk8 UK000Z 2026-03-20T12:05:29.508Z 2026-03-27T12:40:37.704Z
9519866 9519866 20260319024139_zVJzg UK000Z 2026-03-20T12:05:20.533Z 2026-03-27T12:40:36.755Z
9516810 9516810 20260317220104_Oxm7t UK000Z 2026-03-19T12:26:48.755Z 2026-03-25T12:43:07.119Z
9516277 9516277 20260317202349_RlWE7 UK000Z 2026-03-19T12:25:53.021Z 2026-03-25T12:42:53.098Z
9509841 9509841 20260318021934_3ex93 UK000Z 2026-03-19T12:06:22.774Z 2026-03-26T12:37:08.324Z
9509637 9509637 20260318020323_RxUyW UK000Z 2026-03-19T12:05:51.176Z 2026-03-26T12:37:06.779Z
9508706 9508706 20260318010801_tCIam UK000Z 2026-03-19T12:03:40.500Z 2026-03-26T12:37:00.342Z
9508669 9508669 20260318010801_YsaIz UK000Z 2026-03-19T12:03:38.688Z 2026-03-26T12:37:00.197Z
9507589 9507589 20260317232417_lL24d UK000Z 2026-03-19T12:00:42.431Z 2026-03-26T12:36:45.738Z
9500843 9500843 20260315194505_3zOu9 UK000Z 2026-03-17T12:23:59.179Z 2026-03-23T12:22:41.942Z
9492206 9492206 20260314193926_r38Xj UK000Z 2026-03-16T12:28:08.696Z 2026-03-22T12:42:50.825Z
9470309 9470309 20260313050918_ILrAV UK000Z 2026-03-14T12:06:59.897Z 2026-03-21T12:49:07.333Z
9470246 9470246 20260313050035_da7Jn UK000Z 2026-03-14T12:06:48.355Z 2026-03-21T12:49:06.990Z
9469845 9469845 20260313035323_2AwjI UK000Z 2026-03-14T12:05:45.021Z 2026-03-21T12:49:03.196Z
9469801 9469801 20260313034558_fGTDX UK000Z 2026-03-14T12:05:35.773Z 2026-03-21T12:49:02.474Z
9469783 9469783 20260313034504_OQOVz UK000Z 2026-03-14T12:05:32.959Z 2026-03-21T12:49:02.324Z
9467408 9467408 20260311214041_NUFes UK000Z 2026-03-13T12:19:11.756Z 2026-03-19T12:45:52.107Z
9460312 9460312 20260310005922_5om4b UK000Z 2026-03-12T12:10:50.267Z 2026-03-18T12:38:41.429Z
9204478 9204478 20260114064732_HmOTB UK000Z 2026-01-15T14:27:25.940Z 2026-01-22T15:10:29.581Z
9204403 9204403 20260114063756_9fvey UK000Z 2026-01-15T14:27:13.783Z 2026-01-22T15:10:27.428Z
9203902 9203902 20260114055221_Vgrup UK000Z 2026-01-15T14:25:50.313Z 2026-01-22T15:10:15.386Z
9203805 9203805 20260114053756_Wkz4u UK000Z 2026-01-15T14:25:25.779Z 2026-01-22T15:10:13.710Z
9203717 9203717 20260114053054_KXRbz UK000Z 2026-01-15T14:25:13.881Z 2026-01-22T15:10:12.563Z
9203492 9203492 20260114050910_VM62F UK000Z 2026-01-15T14:24:34.192Z 2026-01-22T15:10:08.703Z
9203092 9203092 20260114043249_jetAf UK000Z 2026-01-15T14:23:17.615Z 2026-01-22T15:10:01.407Z
9202485 9202485 20260114034225_L8opz UK000Z 2026-01-15T14:21:31.051Z 2026-01-22T15:09:21.261Z
9202236 9202236 20260114032429_gSKye UK000Z 2026-01-15T14:20:44.073Z 2026-01-22T15:09:15.124Z
9202141 9202141 20260114032011_msxWS UK000Z 2026-01-15T14:20:35.093Z 2026-01-22T15:09:14.061Z
9202037 9202037 20260114031230_qz3FI UK000Z 2026-01-15T14:20:16.816Z 2026-01-22T15:09:12.317Z
9201480 9201480 20260114022028_Yi6z0 UK000Z 2026-01-15T14:18:42.930Z 2026-01-22T15:09:04.277Z
9201101 9201101 20260114014247_ydBzl UK000Z 2026-01-15T14:17:33.948Z 2026-01-22T15:08:57.782Z
9201079 9201079 20260114014013_pFGoz UK000Z 2026-01-15T14:17:32.218Z 2026-01-22T15:08:57.567Z
9200960 9200960 20260114012554_kOdIv UK000Z 2026-01-15T14:17:06.598Z 2026-01-22T15:08:40.840Z
9200417 9200417 20260114000624_x1VEn UK000Z 2026-01-15T14:15:10.540Z 2026-01-22T15:08:15.738Z
9200173 9200173 20260113230253_sClSF UK000Z 2026-01-15T14:14:05.398Z 2026-01-22T15:08:10.758Z
9200060 9200060 20260113224721_8g23B UK000Z 2026-01-15T14:13:41.943Z 2026-01-22T15:08:09.063Z
9199343 9199343 20260113194737_A7m7N UK000Z 2026-01-15T14:10:28.708Z 2026-01-22T15:07:22.377Z
9195119 9195119 20260113002417_ih23J UK000Z 2026-01-14T14:12:06.234Z 2026-01-21T15:04:36.649Z
9195053 9195053 20260113000854_qBOA3 UK000Z 2026-01-14T14:11:51.645Z 2026-01-21T15:04:35.680Z
9195013 9195013 20260112235937_fCxGl UK000Z 2026-01-14T14:11:42.928Z 2026-01-21T15:04:35.164Z
9194953 9194953 20260112234053_DUL1C UK000Z 2026-01-14T14:11:28.925Z 2026-01-21T15:04:34.335Z
9194661 9194661 20260112214350_sCU33 UK000Z 2026-01-14T14:10:12.968Z 2026-01-21T15:04:19.749Z
9176740 9176740 20260110061458_JsFDv UK000Z 2026-01-11T14:09:50.583Z 2026-01-18T15:08:52.566Z
9175498 9175498 20260110023943_o2hFO UK000Z 2026-01-11T14:06:34.260Z 2026-01-18T15:07:47.601Z
9175272 9175272 20260110015351_ajI8W UK000Z 2026-01-11T14:05:56.241Z 2026-01-18T15:07:39.451Z
9175200 9175200 20260110013614_Sc5BN UK000Z 2026-01-11T14:05:40.768Z 2026-01-18T15:07:36.781Z
9175027 9175027 20260110004758_2Wc5l UK000Z 2026-01-11T14:05:12.571Z 2026-01-18T15:07:23.583Z
9175012 9175012 20260110004558_pftd6 UK000Z 2026-01-11T14:05:08.554Z 2026-01-18T15:07:22.935Z
9174957 9174957 20260110002211_gVe3p UK000Z 2026-01-11T14:04:59.137Z 2026-01-18T15:07:19.479Z
9153098 9153098 20260103182255_CWpqs UK000Z 2026-01-06T14:20:57.372Z 2026-01-12T14:59:50.389Z
9139723 9139723 20260103234142_TNYyY UK000Z 2026-01-05T14:11:59.352Z 2026-01-12T15:03:49.329Z
9139282 9139282 20260103232655_ax37p UK000Z 2026-01-05T14:11:27.433Z 2026-01-12T15:03:25.247Z
9138970 9138970 20260103230553_cM8et UK000Z 2026-01-05T14:11:01.089Z 2026-01-12T15:03:17.274Z
9138908 9138908 20260103230034_qvUXu UK000Z 2026-01-05T14:10:48.064Z 2026-01-12T15:03:15.631Z
9138742 9138742 20260103225053_Hxq66 UK000Z 2026-01-05T14:10:34.516Z 2026-01-12T15:02:58.953Z
9138536 9138536 20260103223145_rCDrl UK000Z 2026-01-05T14:10:04.150Z 2026-01-12T15:02:51.979Z
9138425 9138425 20260103222511_IeR0O UK000Z 2026-01-05T14:09:55.460Z 2026-01-12T15:02:49.031Z
9138098 9138098 20260103215842_FobkW UK000Z 2026-01-05T14:09:22.427Z 2026-01-12T15:02:38.865Z
9137424 9137424 20260103211225_wNI1r UK000Z 2026-01-05T14:08:29.202Z 2026-01-12T15:02:10.770Z
9137343 9137343 20260103210608_lpSh7 UK000Z 2026-01-05T14:08:20.919Z 2026-01-12T15:02:07.714Z
9137290 9137290 20260103210012_Dnmyo UK000Z 2026-01-05T14:08:17.661Z 2026-01-12T15:01:56.060Z
9136873 9136873 20260103202320_FQd75 UK000Z 2026-01-05T14:07:25.234Z 2026-01-12T15:01:42.089Z
9136287 9136287 20260103194543_VsTpf UK000Z 2026-01-05T14:06:31.700Z 2026-01-12T15:01:14.093Z
9135686 9135686 20260103190755_Zj3Bk UK000Z 2026-01-05T14:05:07.531Z 2026-01-12T15:00:44.294Z
9135417 9135417 20260103185445_vtVXO UK000Z 2026-01-05T14:04:28.049Z 2026-01-12T15:00:29.985Z
9134784 9134784 20260103182249_ugf9T UK000Z 2026-01-05T14:02:53.808Z 2026-01-12T14:59:50.279Z
9134750 9134750 20260103182038_3j2tV UK000Z 2026-01-05T14:02:45.671Z 2026-01-12T14:59:49.429Z
9132356 9132356 20260103063646_RCpum UK000Z 2026-01-04T14:16:26.490Z 2026-01-10T15:01:24.606Z
9132230 9132230 20260103062449_2d2vB UK000Z 2026-01-04T14:16:09.959Z 2026-01-10T15:01:18.487Z
9129350 9129350 20260102212431_vI2ym UK000Z 2026-01-04T14:03:29.912Z 2026-01-10T14:57:32.737Z
9128302 9128302 20260102070125_TRHA0 UK000Z 2026-01-03T14:14:15.809Z 2026-01-09T14:50:41.234Z
9128276 9128276 20260102064820_9MXLq UK000Z 2026-01-03T14:14:09.512Z 2026-01-09T14:50:40.106Z
9128106 9128106 20260102061502_cNDWf UK000Z 2026-01-03T14:13:19.773Z 2026-01-09T14:50:24.967Z
9127812 9127812 20260102052349_pVnOb UK000Z 2026-01-03T14:12:02.406Z 2026-01-09T14:50:13.049Z
9124415 9124415 20251231062520_QqH5u UK000Z 2026-01-02T14:45:33.330Z 2026-01-08T15:11:55.574Z
9124366 9124366 20251231060748_Zg8u8 UK000Z 2026-01-02T14:45:01.472Z 2026-01-08T15:11:46.539Z

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