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

5,923 rows where station_code = "UK004N" 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
9615826 9615826 20260406015903_t2qQ2 UK004N 2026-04-07T12:11:37.407Z 2026-04-07T12:13:19.871Z
9615503 9615503 20260406012616_2ZzH3 UK004N 2026-04-07T12:10:56.700Z 2026-04-07T12:13:19.813Z
9615223 9615223 20260406004935_6BT3j UK004N 2026-04-07T12:10:17.943Z 2026-04-07T12:13:19.760Z
9615129 9615129 20260406004012_Xu2ub UK004N 2026-04-07T12:10:04.482Z 2026-04-07T12:13:19.741Z
9614998 9614998 20260406002007_bFF0H UK004N 2026-04-07T12:09:51.946Z 2026-04-07T12:13:19.713Z
9614806 9614806 20260405235537_Q5TVO UK004N 2026-04-07T12:09:25.431Z 2026-04-07T12:13:19.676Z
9614784 9614784 20260405235235_HjWMT UK004N 2026-04-07T12:09:23.707Z 2026-04-07T12:13:19.672Z
9602962 9602962 20260402042124_5hGY7 UK004N 2026-04-03T12:01:20.889Z 2026-04-07T12:18:49.916Z
9602946 9602946 20260402041437_r1GZX UK004N 2026-04-03T12:01:19.684Z 2026-04-07T12:18:49.746Z
9595077 9595077 20260330021434_l32IR UK004N 2026-03-31T12:00:23.896Z 2026-04-07T12:23:47.859Z
9592062 9592062 20260328000948_E2Ydr UK004N 2026-03-29T12:07:08.922Z 2026-04-05T12:35:25.796Z
9591955 9591955 20260327232120_Ks3PF UK004N 2026-03-29T12:07:01.579Z 2026-04-05T12:35:22.191Z
9591869 9591869 20260327225400_2vrCG UK004N 2026-03-29T12:06:53.303Z 2026-04-05T12:35:18.138Z
9589809 9589809 20260328040906_KIy3m UK004N 2026-03-29T12:01:39.059Z 2026-04-06T12:37:35.507Z
9589484 9589484 20260328033503_BxrgB UK004N 2026-03-29T12:01:19.664Z 2026-04-06T12:37:25.492Z
9589001 9589001 20260328021247_Q158g UK004N 2026-03-29T12:00:37.222Z 2026-04-06T12:36:59.054Z
9584958 9584958 20260325225442_oOgY3 UK004N 2026-03-27T12:16:26.774Z 2026-04-03T12:39:45.264Z
9582116 9582116 20260326044012_vIzfz UK004N 2026-03-27T12:04:40.848Z 2026-04-04T12:39:38.175Z
9581949 9581949 20260326041429_07fzY UK004N 2026-03-27T12:04:14.827Z 2026-04-04T12:39:32.426Z
9581562 9581562 20260326033113_OwaM9 UK004N 2026-03-27T12:03:25.278Z 2026-04-04T12:39:10.831Z
9581545 9581545 20260326033021_6ux4t UK004N 2026-03-27T12:03:24.212Z 2026-04-04T12:39:10.481Z
9580797 9580797 20260326013431_XdW6Y UK004N 2026-03-27T12:01:26.866Z 2026-04-04T12:38:29.830Z
9571019 9571019 20260322233813_Ae6Vi UK004N 2026-03-24T12:24:10.319Z 2026-03-30T12:30:53.963Z
9570874 9570874 20260322230541_kyBDS UK004N 2026-03-24T12:23:57.629Z 2026-03-30T12:30:50.970Z
9561083 9561083 20260321225532_iJNAV UK004N 2026-03-23T12:12:11.404Z 2026-03-29T12:21:05.123Z
9553289 9553289 20260322012954_wc23u UK004N 2026-03-23T12:01:23.171Z 2026-03-30T12:27:39.071Z
9542395 9542395 20260319232118_ywD88 UK004N 2026-03-21T12:30:01.615Z 2026-03-27T12:43:01.963Z
9542312 9542312 20260319230930_YeWW0 UK004N 2026-03-21T12:29:57.221Z 2026-03-27T12:42:55.216Z
9542079 9542079 20260319224751_16XbN UK004N 2026-03-21T12:29:39.502Z 2026-03-27T12:42:45.107Z
9534806 9534806 20260320042650_ynDQr UK004N 2026-03-21T12:08:57.268Z 2026-03-28T12:34:22.387Z
9534670 9534670 20260320041032_2R98l UK004N 2026-03-21T12:08:35.075Z 2026-03-28T12:34:20.658Z
9534650 9534650 20260320041017_7uMuA UK004N 2026-03-21T12:08:33.350Z 2026-03-28T12:34:20.519Z
9534632 9534632 20260320040924_GAA27 UK004N 2026-03-21T12:08:31.626Z 2026-03-28T12:34:20.382Z
9533773 9533773 20260320025730_xfiQE UK004N 2026-03-21T12:06:14.772Z 2026-03-28T12:34:00.376Z
9533698 9533698 20260320025209_wi9m0 UK004N 2026-03-21T12:06:02.909Z 2026-03-28T12:33:58.753Z
9532981 9532981 20260320014329_R6Ac3 UK004N 2026-03-21T12:04:08.344Z 2026-03-28T12:33:47.165Z
9532835 9532835 20260320013210_nUGNT UK004N 2026-03-21T12:03:46.573Z 2026-03-28T12:33:44.765Z
9532473 9532473 20260320010105_l1tI3 UK004N 2026-03-21T12:02:51.083Z 2026-03-28T12:33:32.192Z
9532098 9532098 20260320001816_RQnGj UK004N 2026-03-21T12:01:43.103Z 2026-03-28T12:33:24.606Z
9530727 9530727 20260318213338_gZ795 UK004N 2026-03-20T12:24:44.445Z 2026-03-26T12:39:15.036Z
9521861 9521861 20260319045001_9BncR UK004N 2026-03-20T12:08:40.956Z 2026-03-27T12:41:11.387Z
9521325 9521325 20260319040705_DxR1Z UK004N 2026-03-20T12:07:51.252Z 2026-03-27T12:40:53.864Z
9520535 9520535 20260319032150_oYxSL UK004N 2026-03-20T12:06:31.030Z 2026-03-27T12:40:44.536Z
9520025 9520025 20260319024808_WQUGJ UK004N 2026-03-20T12:05:33.656Z 2026-03-27T12:40:38.064Z
9519870 9519870 20260319024139_zVJzg UK004N 2026-03-20T12:05:20.555Z 2026-03-27T12:40:36.755Z
9519196 9519196 20260319015416_M2G9N UK004N 2026-03-20T12:04:05.000Z 2026-03-27T12:40:18.961Z
9519162 9519162 20260319015352_CmsTF UK004N 2026-03-20T12:04:02.542Z 2026-03-27T12:40:18.771Z
9518849 9518849 20260319012947_K0v1B UK004N 2026-03-20T12:03:30.265Z 2026-03-27T12:40:15.737Z
9517703 9517703 20260318235627_RxWaH UK004N 2026-03-20T12:01:03.647Z 2026-03-27T12:40:02.485Z
9517375 9517375 20260318232103_0CmWQ UK004N 2026-03-20T12:00:14.519Z 2026-03-27T12:39:58.835Z
9508315 9508315 20260318004511_JM2j2 UK004N 2026-03-19T12:02:52.135Z 2026-03-26T12:36:57.724Z
9508254 9508254 20260318003749_fk3YI UK004N 2026-03-19T12:02:45.100Z 2026-03-26T12:36:57.372Z
9508190 9508190 20260318003259_1vdP0 UK004N 2026-03-19T12:02:34.616Z 2026-03-26T12:36:56.853Z
9501325 9501325 20260315215740_dmV2n UK004N 2026-03-17T12:24:49.837Z 2026-03-23T12:22:43.928Z
9477066 9477066 20260314041042_utEoF UK004N 2026-03-15T12:07:32.009Z 2026-03-22T12:42:00.911Z
9476757 9476757 20260314033921_BwJw3 UK004N 2026-03-15T12:06:48.764Z 2026-03-22T12:41:59.128Z
9470248 9470248 20260313050035_da7Jn UK004N 2026-03-14T12:06:48.355Z 2026-03-21T12:49:06.990Z
9470111 9470111 20260313043703_xiTwI UK004N 2026-03-14T12:06:31.191Z 2026-03-21T12:49:06.038Z
9469804 9469804 20260313034558_fGTDX UK004N 2026-03-14T12:05:35.801Z 2026-03-21T12:49:02.474Z
9469769 9469769 20260313034331_dLE3v UK004N 2026-03-14T12:05:28.940Z 2026-03-21T12:49:02.115Z
9469625 9469625 20260313032127_JsKXT UK004N 2026-03-14T12:05:00.459Z 2026-03-21T12:48:52.903Z
9469575 9469575 20260313031151_9vevB UK004N 2026-03-14T12:04:49.106Z 2026-03-21T12:48:43.634Z
9467611 9467611 20260311222106_jYrWP UK004N 2026-03-13T12:19:35.458Z 2026-03-19T12:45:53.696Z
9457602 9457602 20260311043300_I1F3R UK004N 2026-03-12T12:04:08.576Z 2026-03-19T12:44:48.150Z
9445791 9445791 20260307214801_0O25b UK004N 2026-03-09T12:20:49.488Z 2026-03-15T12:42:14.404Z
9442662 9442662 20260308044511_IuC2R UK004N 2026-03-09T12:04:55.116Z 2026-03-16T12:43:54.623Z
9426933 9426933 20260305051321_1JrIU UK004N 2026-03-06T14:06:57.236Z 2026-03-13T12:34:52.618Z
9426916 9426916 20260305050759_34T0F UK004N 2026-03-06T14:06:52.745Z 2026-03-13T12:34:52.517Z
9426605 9426605 20260305040043_nT62P UK004N 2026-03-06T14:05:35.739Z 2026-03-13T12:34:48.499Z
9425269 9425269 20260303192653_pN3kc UK004N 2026-03-05T14:14:28.135Z 2026-03-11T12:28:49.363Z
9394779 9394779 20260224214809_ZOV6u UK004N 2026-02-26T14:20:38.427Z 2026-03-04T14:19:27.167Z
9392318 9392318 20260225040432_8hunh UK004N 2026-02-26T14:07:03.199Z 2026-03-05T14:36:54.449Z
9391843 9391843 20260225032130_ZE4Y8 UK004N 2026-02-26T14:05:38.378Z 2026-03-05T14:36:33.112Z
9390530 9390530 20260225004212_t3X7X UK004N 2026-02-26T14:01:39.659Z 2026-03-05T14:35:49.030Z
9390471 9390471 20260225003529_Gkowi UK004N 2026-02-26T14:01:30.227Z 2026-03-05T14:35:47.517Z
9390145 9390145 20260224235117_dz3wW UK004N 2026-02-26T14:00:38.472Z 2026-03-05T14:35:34.063Z
9381346 9381346 20260222215850_m4RE4 UK004N 2026-02-24T14:24:33.526Z 2026-02-24T14:24:33.526Z
9372521 9372521 20260223002856_wddaI UK004N 2026-02-24T14:00:47.698Z 2026-03-03T14:30:41.706Z
9372506 9372506 20260223002856_TiiOJ UK004N 2026-02-24T14:00:47.325Z 2026-03-03T14:30:41.660Z
9340397 9340397 20260217000203_rws8f UK004N 2026-02-18T14:24:48.212Z 2026-02-25T14:42:53.994Z
9340010 9340010 20260216223012_cVf79 UK004N 2026-02-18T14:23:45.504Z 2026-02-25T14:42:49.677Z
9339824 9339824 20260216211716_0VU9Q UK004N 2026-02-18T14:23:11.703Z 2026-02-25T14:42:46.927Z
9337508 9337508 20260217054748_iQcgj UK004N 2026-02-18T14:07:26.268Z 2026-02-26T14:39:27.412Z
9337407 9337407 20260217053509_chgBR UK004N 2026-02-18T14:07:07.246Z 2026-02-26T14:39:26.416Z
9337284 9337284 20260217052158_T0URs UK004N 2026-02-18T14:06:50.780Z 2026-02-26T14:39:25.543Z
9336512 9336512 20260217035709_ZkQNp UK004N 2026-02-18T14:04:35.994Z 2026-02-26T14:39:19.062Z
9336066 9336066 20260217030614_Oneay UK004N 2026-02-18T14:03:15.405Z 2026-02-26T14:39:14.765Z
9335961 9335961 20260217025603_XR7bo UK004N 2026-02-18T14:02:52.964Z 2026-02-26T14:39:00.309Z
9335313 9335313 20260217012334_2PkR0 UK004N 2026-02-18T14:00:42.540Z 2026-02-26T14:38:52.858Z
9335277 9335277 20260217011931_xh4Bj UK004N 2026-02-18T14:00:35.872Z 2026-02-26T14:38:52.745Z
9330277 9330277 20260213231644_oTfe9 UK004N 2026-02-16T14:29:08.071Z 2026-02-22T14:42:47.053Z
9326706 9326706 20260214013623_VtEew UK004N 2026-02-15T14:24:21.520Z 2026-02-22T14:42:54.977Z
9326494 9326494 20260214003049_4isjE UK004N 2026-02-15T14:23:30.085Z 2026-02-22T14:42:50.377Z
9323762 9323762 20260214060044_dOZJI UK004N 2026-02-15T14:07:09.674Z 2026-02-23T14:46:44.997Z
9323266 9323266 20260214045910_zE7G4 UK004N 2026-02-15T14:05:48.243Z 2026-02-23T14:46:29.781Z
9323227 9323227 20260214045755_WPkVK UK004N 2026-02-15T14:05:41.858Z 2026-02-23T14:46:29.350Z
9323132 9323132 20260214045001_vc4Nd UK004N 2026-02-15T14:05:23.941Z 2026-02-23T14:46:28.118Z
9323114 9323114 20260214044843_AJdCm UK004N 2026-02-15T14:05:20.602Z 2026-02-23T14:46:27.879Z
9323076 9323076 20260214044438_jmsVi UK004N 2026-02-15T14:05:10.677Z 2026-02-23T14:46:27.200Z
9323038 9323038 20260214043602_rcBnY UK004N 2026-02-15T14:05:02.893Z 2026-02-23T14:46:26.533Z

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