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,218 rows where station_code = "UK008S" 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
9611652 9611652 20260405025815_JOzGp UK008S 2026-04-06T12:15:29.534Z 2026-04-06T12:16:14.841Z
9609005 9609005 20260404030436_WhUfW UK008S 2026-04-05T12:12:35.318Z 2026-04-06T12:20:56.536Z
9608949 9608949 20260404024713_tBg5Q UK008S 2026-04-05T12:12:22.858Z 2026-04-06T12:20:53.013Z
9608538 9608538 20260403233238_eK4nX UK008S 2026-04-05T12:10:46.406Z 2026-04-06T12:20:19.282Z
9608403 9608403 20260403225849_ezHtU UK008S 2026-04-05T12:10:22.106Z 2026-04-06T12:20:11.216Z
9608370 9608370 20260403224039_lXkxl UK008S 2026-04-05T12:10:16.446Z 2026-04-06T12:20:08.903Z
9608131 9608131 20260403200924_uq6G6 UK008S 2026-04-05T12:09:00.028Z 2026-04-06T12:19:44.499Z
9604813 9604813 20260402005423_xJ3eZ UK008S 2026-04-03T12:11:38.207Z 2026-04-06T12:26:20.460Z
9604655 9604655 20260401231135_qRb0X UK008S 2026-04-03T12:11:03.158Z 2026-04-06T12:26:09.697Z
9591794 9591794 20260327213826_kc0tr UK008S 2026-03-29T12:06:45.884Z 2026-04-05T12:35:14.092Z
9590033 9590033 20260328042939_QMMfv UK008S 2026-03-29T12:01:53.686Z 2026-04-06T12:37:47.702Z
9584647 9584647 20260325212604_oMeeI UK008S 2026-03-27T12:15:54.318Z 2026-04-03T12:39:25.453Z
9584474 9584474 20260325200334_PUfkc UK008S 2026-03-27T12:15:25.357Z 2026-04-03T12:39:15.901Z
9584472 9584472 20260325200059_IBDSc UK008S 2026-03-27T12:15:24.474Z 2026-04-03T12:39:15.646Z
9581952 9581952 20260326041429_07fzY UK008S 2026-03-27T12:04:14.827Z 2026-04-04T12:39:32.426Z
9581803 9581803 20260326035927_aH004 UK008S 2026-03-27T12:03:52.970Z 2026-04-04T12:39:21.065Z
9581783 9581783 20260326035617_PIqPo UK008S 2026-03-27T12:03:50.691Z 2026-04-04T12:39:20.438Z
9581751 9581751 20260326035503_8PtcB UK008S 2026-03-27T12:03:48.201Z 2026-04-04T12:39:18.307Z
9581566 9581566 20260326033113_OwaM9 UK008S 2026-03-27T12:03:25.278Z 2026-04-04T12:39:10.831Z
9580910 9580910 20260326015235_iQv3F UK008S 2026-03-27T12:01:40.732Z 2026-04-04T12:38:33.363Z
9575653 9575653 20260322013140_tPo8w UK008S 2026-03-25T12:22:26.012Z 2026-03-30T12:27:39.482Z
9561084 9561084 20260321225532_iJNAV UK008S 2026-03-23T12:12:11.404Z 2026-03-29T12:21:05.123Z
9560781 9560781 20260321221404_760j3 UK008S 2026-03-23T12:12:03.428Z 2026-03-29T12:21:02.826Z
9560037 9560037 20260321202522_0sNKt UK008S 2026-03-23T12:11:36.480Z 2026-03-29T12:20:57.499Z
9559898 9559898 20260321200812_xls3O UK008S 2026-03-23T12:11:33.433Z 2026-03-29T12:20:56.459Z
9559847 9559847 20260321200157_nvpeH UK008S 2026-03-23T12:11:31.978Z 2026-03-29T12:20:56.085Z
9555216 9555216 20260322042617_42wSc UK008S 2026-03-23T12:03:15.761Z 2026-03-30T12:28:23.013Z
9553984 9553984 20260322023008_IzhMY UK008S 2026-03-23T12:02:04.925Z 2026-03-30T12:27:56.403Z
9553485 9553485 20260322014515_Qst4t UK008S 2026-03-23T12:01:33.784Z 2026-03-30T12:27:41.987Z
9553384 9553384 20260322013551_y9QOl UK008S 2026-03-23T12:01:26.841Z 2026-03-30T12:27:40.192Z
9553333 9553333 20260322013144_r1lAU UK008S 2026-03-23T12:01:24.525Z 2026-03-30T12:27:39.556Z
9552632 9552632 20260322002508_ldDiX UK008S 2026-03-23T12:00:38.494Z 2026-03-30T12:27:27.273Z
9552502 9552502 20260322001511_k6PBJ UK008S 2026-03-23T12:00:29.237Z 2026-03-30T12:27:25.188Z
9551905 9551905 20260320221003_5ABw3 UK008S 2026-03-22T12:27:16.783Z 2026-03-28T12:37:04.046Z
9534520 9534520 20260320035730_nv1ym UK008S 2026-03-21T12:08:11.586Z 2026-03-28T12:34:19.021Z
9534097 9534097 20260320032517_dPUCM UK008S 2026-03-21T12:07:08.804Z 2026-03-28T12:34:13.761Z
9533923 9533923 20260320030919_4KlJQ UK008S 2026-03-21T12:06:39.857Z 2026-03-28T12:34:02.284Z
9533885 9533885 20260320030700_E9Klw UK008S 2026-03-21T12:06:33.141Z 2026-03-28T12:34:01.887Z
9533376 9533376 20260320022606_Z4HMs UK008S 2026-03-21T12:05:16.929Z 2026-03-28T12:33:52.514Z
9533274 9533274 20260320022122_lLuYE UK008S 2026-03-21T12:05:00.251Z 2026-03-28T12:33:51.350Z
9533031 9533031 20260320015205_8djfh UK008S 2026-03-21T12:04:16.244Z 2026-03-28T12:33:47.896Z
9532564 9532564 20260320010633_WvyPl UK008S 2026-03-21T12:03:03.821Z 2026-03-28T12:33:33.959Z
9531748 9531748 20260319234348_1acDg UK008S 2026-03-21T12:00:44.769Z 2026-03-28T12:33:21.115Z
9531415 9531415 20260318230554_0a80A UK008S 2026-03-20T12:25:09.948Z 2026-03-26T12:39:19.265Z
9531295 9531295 20260318225528_zAD88 UK008S 2026-03-20T12:25:05.668Z 2026-03-26T12:39:18.641Z
9531136 9531136 20260318223507_pG3ED UK008S 2026-03-20T12:24:58.912Z 2026-03-26T12:39:17.682Z
9530972 9530972 20260318221116_p7DTI UK008S 2026-03-20T12:24:53.541Z 2026-03-26T12:39:16.775Z
9530850 9530850 20260318215321_torbX UK008S 2026-03-20T12:24:49.564Z 2026-03-26T12:39:16.199Z
9530730 9530730 20260318213338_gZ795 UK008S 2026-03-20T12:24:44.446Z 2026-03-26T12:39:15.036Z
9530372 9530372 20260318204410_tO8p6 UK008S 2026-03-20T12:24:19.977Z 2026-03-26T12:39:11.582Z
9521749 9521749 20260319044135_5OE1t UK008S 2026-03-20T12:08:30.114Z 2026-03-27T12:41:10.474Z
9521630 9521630 20260319043029_QbMyQ UK008S 2026-03-20T12:08:18.789Z 2026-03-27T12:40:56.431Z
9521224 9521224 20260319035824_TWp68 UK008S 2026-03-20T12:07:43.619Z 2026-03-27T12:40:52.799Z
9520537 9520537 20260319032150_oYxSL UK008S 2026-03-20T12:06:31.030Z 2026-03-27T12:40:44.536Z
9520333 9520333 20260319031029_SmG3T UK008S 2026-03-20T12:06:14.504Z 2026-03-27T12:40:42.094Z
9520313 9520313 20260319031014_O53tf UK008S 2026-03-20T12:06:13.577Z 2026-03-27T12:40:41.974Z
9520271 9520271 20260319030722_dWWnb UK008S 2026-03-20T12:06:06.535Z 2026-03-27T12:40:41.358Z
9519874 9519874 20260319024139_zVJzg UK008S 2026-03-20T12:05:20.555Z 2026-03-27T12:40:36.755Z
9519563 9519563 20260319021714_EWIv4 UK008S 2026-03-20T12:04:39.169Z 2026-03-27T12:40:32.536Z
9519106 9519106 20260319015048_nkuYA UK008S 2026-03-20T12:03:56.494Z 2026-03-27T12:40:18.324Z
9518292 9518292 20260319004739_LQAlu UK008S 2026-03-20T12:02:15.964Z 2026-03-27T12:40:08.230Z
9517973 9517973 20260319001754_6zFl1 UK008S 2026-03-20T12:01:38.647Z 2026-03-27T12:40:05.088Z
9517376 9517376 20260318232103_0CmWQ UK008S 2026-03-20T12:00:14.519Z 2026-03-27T12:39:58.835Z
9517244 9517244 20260317225851_nDE2k UK008S 2026-03-19T12:27:21.856Z 2026-03-25T12:43:09.528Z
9516688 9516688 20260317213654_dKk25 UK008S 2026-03-19T12:26:39.608Z 2026-03-25T12:43:06.159Z
9516402 9516402 20260317204530_9U9VL UK008S 2026-03-19T12:26:08.047Z 2026-03-25T12:42:57.937Z
9516363 9516363 20260317203825_M5hJ1 UK008S 2026-03-19T12:26:04.025Z 2026-03-25T12:42:54.619Z
9516224 9516224 20260317201549_m3CNR UK008S 2026-03-19T12:25:47.671Z 2026-03-25T12:42:51.749Z
9511710 9511710 20260318041229_vTfY6 UK008S 2026-03-19T12:10:49.131Z 2026-03-26T12:37:39.082Z
9511551 9511551 20260318040114_wjY0U UK008S 2026-03-19T12:10:27.368Z 2026-03-26T12:37:37.816Z
9509874 9509874 20260318021935_Fn57z UK008S 2026-03-19T12:06:23.279Z 2026-03-26T12:37:08.326Z
9509856 9509856 20260318021934_3ex93 UK008S 2026-03-19T12:06:22.774Z 2026-03-26T12:37:08.325Z
9509601 9509601 20260318020031_0fh7o UK008S 2026-03-19T12:05:45.599Z 2026-03-26T12:37:06.612Z
9509520 9509520 20260318015541_FKx8B UK008S 2026-03-19T12:05:31.728Z 2026-03-26T12:37:05.999Z
9509516 9509516 20260318015541_gGK1I UK008S 2026-03-19T12:05:31.269Z 2026-03-26T12:37:05.964Z
9508863 9508863 20260318011244_gUUFY UK008S 2026-03-19T12:03:56.838Z 2026-03-26T12:37:01.287Z
9508318 9508318 20260318004511_JM2j2 UK008S 2026-03-19T12:02:52.135Z 2026-03-26T12:36:57.724Z
9508256 9508256 20260318003749_fk3YI UK008S 2026-03-19T12:02:45.100Z 2026-03-26T12:36:57.372Z
9508191 9508191 20260318003259_1vdP0 UK008S 2026-03-19T12:02:34.647Z 2026-03-26T12:36:56.854Z
9508100 9508100 20260318001423_EVCxj UK008S 2026-03-19T12:02:12.817Z 2026-03-26T12:36:55.756Z
9507973 9507973 20260317235848_nIlTd UK008S 2026-03-19T12:01:49.707Z 2026-03-26T12:36:54.787Z
9475429 9475429 20260314012741_TWn2v UK008S 2026-03-15T12:03:09.494Z 2026-03-22T12:41:39.060Z
9470313 9470313 20260313050918_ILrAV UK008S 2026-03-14T12:06:59.897Z 2026-03-21T12:49:07.333Z
9470267 9470267 20260313050129_xN4Xq UK008S 2026-03-14T12:06:49.221Z 2026-03-21T12:49:07.037Z
9470150 9470150 20260313044239_x5F2d UK008S 2026-03-14T12:06:34.776Z 2026-03-21T12:49:06.197Z
9469962 9469962 20260313041208_RQwXy UK008S 2026-03-14T12:06:06.185Z 2026-03-21T12:49:04.582Z
9469873 9469873 20260313035543_2FHk9 UK008S 2026-03-14T12:05:47.710Z 2026-03-21T12:49:03.498Z
9469848 9469848 20260313035323_2AwjI UK008S 2026-03-14T12:05:45.021Z 2026-03-21T12:49:03.196Z
9469806 9469806 20260313034558_fGTDX UK008S 2026-03-14T12:05:35.801Z 2026-03-21T12:49:02.474Z
9469697 9469697 20260313033140_Yq2S2 UK008S 2026-03-14T12:05:14.885Z 2026-03-21T12:49:00.861Z
9469626 9469626 20260313032127_JsKXT UK008S 2026-03-14T12:05:00.459Z 2026-03-21T12:48:52.903Z
9469400 9469400 20260313024240_vCb7U UK008S 2026-03-14T12:04:07.206Z 2026-03-21T12:48:38.485Z
9469208 9469208 20260313021339_yWNbm UK008S 2026-03-14T12:03:26.760Z 2026-03-21T12:48:35.146Z
9467248 9467248 20260311205834_j18kn UK008S 2026-03-13T12:18:50.269Z 2026-03-19T12:45:50.901Z
9430699 9430699 20260304203617_URuZV UK008S 2026-03-06T14:24:02.428Z 2026-03-12T12:33:40.272Z
9430624 9430624 20260304202029_ZTFqE UK008S 2026-03-06T14:23:48.129Z 2026-03-12T12:33:39.283Z
9398229 9398229 20260226031931_b3YSF UK008S 2026-02-27T14:04:46.046Z 2026-03-06T14:43:38.572Z
9394844 9394844 20260224215714_yT0Zu UK008S 2026-02-26T14:20:43.706Z 2026-03-04T14:19:27.649Z
9394153 9394153 20260224185855_I5bQc UK008S 2026-02-26T14:19:00.570Z 2026-03-04T14:19:17.405Z
9391667 9391667 20260225030554_1S5Lb UK008S 2026-02-26T14:04:59.027Z 2026-03-05T14:36:27.363Z

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