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 = "UK009S" 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
9608646 9608646 20260404001632_LtfqJ UK009S 2026-04-05T12:11:07.602Z 2026-04-06T12:20:28.152Z
9608625 9608625 20260404000215_UazG0 UK009S 2026-04-05T12:11:01.921Z 2026-04-06T12:20:26.935Z
9604763 9604763 20260402003134_rcxuY UK009S 2026-04-03T12:11:29.177Z 2026-04-06T12:26:17.909Z
9604696 9604696 20260401234827_ykXeb UK009S 2026-04-03T12:11:16.170Z 2026-04-06T12:26:12.189Z
9604673 9604673 20260401232516_W2Vs3 UK009S 2026-04-03T12:11:06.125Z 2026-04-06T12:26:10.776Z
9602821 9602821 20260402033206_7pN3p UK009S 2026-04-03T12:00:47.033Z 2026-04-06T12:21:14.533Z
9602753 9602753 20260402025935_WGuJU UK009S 2026-04-03T12:00:27.825Z 2026-04-06T12:21:08.003Z
9602744 9602744 20260402025814_O8An9 UK009S 2026-04-03T12:00:26.154Z 2026-04-06T12:21:07.374Z
9602717 9602717 20260402024916_ZFXHj UK009S 2026-04-03T12:00:20.191Z 2026-04-06T12:21:05.437Z
9602687 9602687 20260402023312_2mufk UK009S 2026-04-03T12:00:12.744Z 2026-04-06T12:21:01.923Z
9600572 9600572 20260330233813_s7Zqo UK009S 2026-04-01T12:11:13.130Z 2026-04-06T12:33:35.223Z
9600538 9600538 20260330231535_AV0eS UK009S 2026-04-01T12:11:07.285Z 2026-04-06T12:33:33.243Z
9600522 9600522 20260330230730_V2f2v UK009S 2026-04-01T12:11:02.474Z 2026-04-06T12:33:32.121Z
9598570 9598570 20260330012026_TdOOw UK009S 2026-03-31T12:10:57.008Z 2026-04-06T12:36:46.576Z
9598560 9598560 20260330011826_5VlO9 UK009S 2026-03-31T12:10:55.709Z 2026-04-06T12:36:46.078Z
9598541 9598541 20260330010356_Xwhkl UK009S 2026-03-31T12:10:50.526Z 2026-04-06T12:36:45.055Z
9595276 9595276 20260330031448_uDaOj UK009S 2026-03-31T12:00:57.538Z 2026-04-06T12:29:51.102Z
9594486 9594486 20260328223709_LpHpF UK009S 2026-03-30T12:09:40.388Z 2026-04-06T12:39:54.142Z
9592083 9592083 20260328002259_xTGFB UK009S 2026-03-29T12:07:09.442Z 2026-04-05T12:35:26.094Z
9592071 9592071 20260328000948_g0c3C UK009S 2026-03-29T12:07:09.063Z 2026-04-05T12:35:25.854Z
9592046 9592046 20260328000336_BWFVg UK009S 2026-03-29T12:07:07.775Z 2026-04-05T12:35:25.119Z
9591932 9591932 20260327231421_dpKI7 UK009S 2026-03-29T12:06:59.956Z 2026-04-05T12:35:21.353Z
9589956 9589956 20260328042300_swGSF UK009S 2026-03-29T12:01:46.951Z 2026-04-06T12:37:39.149Z
9589900 9589900 20260328041640_2fScY UK009S 2026-03-29T12:01:42.790Z 2026-04-06T12:37:37.483Z
9589756 9589756 20260328040521_c2MCt UK009S 2026-03-29T12:01:36.869Z 2026-04-06T12:37:32.722Z
9589550 9589550 20260328034548_v3o6J UK009S 2026-03-29T12:01:25.335Z 2026-04-06T12:37:27.451Z
9589412 9589412 20260328032804_L72Mn UK009S 2026-03-29T12:01:12.511Z 2026-04-06T12:37:22.697Z
9589055 9589055 20260328021921_OTnDO UK009S 2026-03-29T12:00:41.225Z 2026-04-06T12:37:00.868Z
9588962 9588962 20260328020019_fCseD UK009S 2026-03-29T12:00:33.638Z 2026-04-06T12:36:57.765Z
9588958 9588958 20260328015805_ujuUa UK009S 2026-03-29T12:00:33.299Z 2026-04-06T12:36:57.597Z
9588866 9588866 20260328013919_v3B2J UK009S 2026-03-29T12:00:24.089Z 2026-04-06T12:36:54.768Z
9588850 9588850 20260328013746_dwrOv UK009S 2026-03-29T12:00:23.076Z 2026-04-06T12:36:54.208Z
9588822 9588822 20260328012756_BUODt UK009S 2026-03-29T12:00:19.278Z 2026-04-06T12:36:52.882Z
9585144 9585144 20260325233302_zGkxv UK009S 2026-03-27T12:16:50.374Z 2026-04-03T12:39:50.346Z
9585098 9585098 20260325232713_6yWfV UK009S 2026-03-27T12:16:43.810Z 2026-04-03T12:39:49.448Z
9585052 9585052 20260325231306_2pACJ UK009S 2026-03-27T12:16:36.874Z 2026-04-03T12:39:47.870Z
9584863 9584863 20260325223130_U4O1A UK009S 2026-03-27T12:16:17.114Z 2026-04-03T12:39:42.785Z
9584551 9584551 20260325203814_c2XJx UK009S 2026-03-27T12:15:37.467Z 2026-04-03T12:39:19.479Z
9584431 9584431 20260325195058_5UwN2 UK009S 2026-03-27T12:15:17.913Z 2026-04-03T12:39:13.866Z
9581045 9581045 20260326021450_zKwN1 UK009S 2026-03-27T12:01:57.926Z 2026-04-04T12:38:40.447Z
9581033 9581033 20260326021450_6yOQx UK009S 2026-03-27T12:01:57.564Z 2026-04-04T12:38:40.327Z
9579804 9579804 20260324225820_ZrGhu UK009S 2026-03-26T12:14:29.942Z 2026-04-02T12:37:30.979Z
9577190 9577190 20260325040849_QjWiQ UK009S 2026-03-26T12:04:20.957Z 2026-04-03T12:36:40.199Z
9576182 9576182 20260325013153_usdti UK009S 2026-03-26T12:01:30.111Z 2026-04-03T12:35:47.424Z
9575970 9575970 20260325005101_EUp0t UK009S 2026-03-26T12:00:50.376Z 2026-04-03T12:35:38.405Z
9571116 9571116 20260322234801_ksRwO UK009S 2026-03-24T12:24:21.454Z 2026-03-30T12:30:55.418Z
9570728 9570728 20260322223615_tDt6f UK009S 2026-03-24T12:23:41.261Z 2026-03-30T12:30:48.443Z
9570686 9570686 20260322223144_KxJVf UK009S 2026-03-24T12:23:38.189Z 2026-03-30T12:30:47.762Z
9570664 9570664 20260322222524_weFtQ UK009S 2026-03-24T12:23:36.849Z 2026-03-30T12:30:47.349Z
9570660 9570660 20260322222443_U3xLH UK009S 2026-03-24T12:23:36.093Z 2026-03-30T12:30:47.269Z
9570560 9570560 20260322220131_oQWaz UK009S 2026-03-24T12:23:27.786Z 2026-03-30T12:30:45.467Z
9570489 9570489 20260322213900_QIwHO UK009S 2026-03-24T12:23:21.398Z 2026-03-30T12:30:44.096Z
9561875 9561875 20260323005158_aZn5w UK009S 2026-03-24T12:01:29.744Z 2026-03-31T12:25:55.459Z
9561861 9561861 20260323005124_fgZtu UK009S 2026-03-24T12:01:28.594Z 2026-03-31T12:25:55.219Z
9560578 9560578 20260321214146_ZSQ4n UK009S 2026-03-23T12:11:53.621Z 2026-03-29T12:21:01.507Z
9559756 9559756 20260321193936_mjK18 UK009S 2026-03-23T12:11:29.104Z 2026-03-29T12:20:50.826Z
9555382 9555382 20260322044706_WGEn4 UK009S 2026-03-23T12:03:23.132Z 2026-03-30T12:28:25.747Z
9555014 9555014 20260322035437_hH22p UK009S 2026-03-23T12:03:02.672Z 2026-03-30T12:28:13.209Z
9554794 9554794 20260322033455_L3FIy UK009S 2026-03-23T12:02:51.131Z 2026-03-30T12:28:08.968Z
9554279 9554279 20260322025436_fI5js UK009S 2026-03-23T12:02:24.123Z 2026-03-30T12:28:01.563Z
9553855 9553855 20260322022107_fXomb UK009S 2026-03-23T12:01:55.440Z 2026-03-30T12:27:53.549Z
9553805 9553805 20260322021514_CrcFW UK009S 2026-03-23T12:01:52.653Z 2026-03-30T12:27:52.801Z
9553776 9553776 20260322021301_KfKho UK009S 2026-03-23T12:01:51.339Z 2026-03-30T12:27:52.440Z
9553731 9553731 20260322020928_2Ch0u UK009S 2026-03-23T12:01:48.567Z 2026-03-30T12:27:51.733Z
9553663 9553663 20260322020524_egWsG UK009S 2026-03-23T12:01:45.246Z 2026-03-30T12:27:50.811Z
9553633 9553633 20260322020225_xjoJh UK009S 2026-03-23T12:01:43.859Z 2026-03-30T12:27:50.390Z
9553410 9553410 20260322014112_9uEEG UK009S 2026-03-23T12:01:28.463Z 2026-03-30T12:27:40.524Z
9553279 9553279 20260322012928_jP3GY UK009S 2026-03-23T12:01:22.664Z 2026-03-30T12:27:38.921Z
9553161 9553161 20260322012215_eitRi UK009S 2026-03-23T12:01:17.726Z 2026-03-30T12:27:35.898Z
9552894 9552894 20260322005112_2Glao UK009S 2026-03-23T12:00:58.653Z 2026-03-30T12:27:31.842Z
9552530 9552530 20260322001614_ClFZf UK009S 2026-03-23T12:00:30.539Z 2026-03-30T12:27:25.581Z
9552505 9552505 20260322001511_k6PBJ UK009S 2026-03-23T12:00:29.238Z 2026-03-30T12:27:25.188Z
9552493 9552493 20260322001509_s5MJS UK009S 2026-03-23T12:00:28.920Z 2026-03-30T12:27:25.101Z
9552144 9552144 20260320230404_OGs4w UK009S 2026-03-22T12:27:29.503Z 2026-03-28T12:37:07.247Z
9552026 9552026 20260320224033_Xdw5W UK009S 2026-03-22T12:27:23.313Z 2026-03-28T12:37:05.648Z
9551987 9551987 20260320223057_1YRv1 UK009S 2026-03-22T12:27:21.495Z 2026-03-28T12:37:05.407Z
9551966 9551966 20260320222414_IGddj UK009S 2026-03-22T12:27:20.026Z 2026-03-28T12:37:05.043Z
9551801 9551801 20260320214117_3FLHW UK009S 2026-03-22T12:27:03.487Z 2026-03-28T12:37:02.314Z
9551749 9551749 20260320212016_SVwi9 UK009S 2026-03-22T12:27:00.494Z 2026-03-28T12:37:01.492Z
9551734 9551734 20260320211622_kaYgJ UK009S 2026-03-22T12:26:59.609Z 2026-03-28T12:37:01.252Z
9551530 9551530 20260320200942_478UN UK009S 2026-03-22T12:26:45.835Z 2026-03-28T12:36:57.395Z
9549138 9549138 20260319234912_zGaBY UK009S 2026-03-22T12:16:49.365Z 2026-03-28T12:33:21.534Z
9542229 9542229 20260319230302_rm353 UK009S 2026-03-21T12:29:52.861Z 2026-03-27T12:42:50.419Z
9542176 9542176 20260319225536_7JP73 UK009S 2026-03-21T12:29:49.746Z 2026-03-27T12:42:46.195Z
9542094 9542094 20260319224755_mtNbm UK009S 2026-03-21T12:29:39.748Z 2026-03-27T12:42:45.136Z
9541925 9541925 20260319220724_QlX0H UK009S 2026-03-21T12:29:29.946Z 2026-03-27T12:42:43.039Z
9541696 9541696 20260319212747_ohBii UK009S 2026-03-21T12:29:16.874Z 2026-03-27T12:42:40.881Z
9541466 9541466 20260319204101_3TLwo UK009S 2026-03-21T12:28:58.477Z 2026-03-27T12:42:37.978Z
9541168 9541168 20260319194839_sZtQp UK009S 2026-03-21T12:28:41.060Z 2026-03-27T12:42:34.842Z
9534375 9534375 20260320034527_uFdFQ UK009S 2026-03-21T12:07:49.070Z 2026-03-28T12:34:17.748Z
9534261 9534261 20260320033853_bnSjm UK009S 2026-03-21T12:07:35.038Z 2026-03-28T12:34:16.733Z
9534213 9534213 20260320033646_QbBhR UK009S 2026-03-21T12:07:28.028Z 2026-03-28T12:34:16.122Z
9533741 9533741 20260320025357_3ecKh UK009S 2026-03-21T12:06:08.881Z 2026-03-28T12:33:59.956Z
9533634 9533634 20260320024726_7xtGq UK009S 2026-03-21T12:05:55.255Z 2026-03-28T12:33:57.274Z
9533616 9533616 20260320024603_H79z2 UK009S 2026-03-21T12:05:53.147Z 2026-03-28T12:33:56.969Z
9533490 9533490 20260320023226_yuqcX UK009S 2026-03-21T12:05:30.400Z 2026-03-28T12:33:53.454Z
9533462 9533462 20260320023057_8ME9K UK009S 2026-03-21T12:05:27.622Z 2026-03-28T12:33:53.131Z
9533443 9533443 20260320023052_zWKQQ UK009S 2026-03-21T12:05:26.633Z 2026-03-28T12:33:53.070Z
9532728 9532728 20260320012046_SyIvn UK009S 2026-03-21T12:03:28.925Z 2026-03-28T12:33:35.637Z
9532679 9532679 20260320011743_mDIYH UK009S 2026-03-21T12:03:22.668Z 2026-03-28T12:33:35.124Z

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