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

9,027 rows where station_code = "UK005E" 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
9611785 9611785 20260405032412_hWkxn UK005E 2026-04-06T12:16:00.350Z 2026-04-06T12:16:14.863Z
9609233 9609233 20260405040330_4dkes UK005E 2026-04-06T12:00:47.185Z 2026-04-06T12:00:47.185Z
9609018 9609018 20260404030618_OyA8K UK005E 2026-04-05T12:12:37.404Z 2026-04-06T12:20:57.429Z
9608915 9608915 20260404023938_vJLQu UK005E 2026-04-05T12:12:17.932Z 2026-04-06T12:20:51.032Z
9608849 9608849 20260404015954_mwVRf UK005E 2026-04-05T12:11:57.026Z 2026-04-06T12:20:43.274Z
9608728 9608728 20260404010220_phfxT UK005E 2026-04-05T12:11:27.596Z 2026-04-06T12:20:34.148Z
9607130 9607130 20260404034726_okBM4 UK005E 2026-04-05T12:00:32.467Z 2026-04-06T12:16:14.369Z
9602568 9602568 20260331233920_CXqUx UK005E 2026-04-02T12:09:23.097Z 2026-04-06T12:29:23.688Z
9598498 9598498 20260330005215_xpO4J UK005E 2026-03-31T12:10:46.233Z 2026-04-06T12:36:35.644Z
9595295 9595295 20260330031912_M7XIk UK005E 2026-03-31T12:01:00.743Z 2026-04-06T12:29:51.925Z
9594664 9594664 20260328235038_252Tu UK005E 2026-03-30T12:10:08.498Z 2026-04-06T12:40:03.419Z
9594386 9594386 20260328220610_Ya9PO UK005E 2026-03-30T12:09:27.659Z 2026-04-06T12:39:50.536Z
9592864 9592864 20260329034230_CGJoy UK005E 2026-03-30T12:02:08.986Z 2026-04-06T12:34:38.061Z
9592551 9592551 20260329022859_VhOYz UK005E 2026-03-30T12:01:17.406Z 2026-04-06T12:34:15.116Z
9592505 9592505 20260329021944_iLH7U UK005E 2026-03-30T12:01:09.384Z 2026-04-06T12:34:13.241Z
9592235 9592235 20260329012928_23dfk UK005E 2026-03-30T12:00:26.465Z 2026-04-06T12:33:54.712Z
9591938 9591938 20260327231700_YQPAv UK005E 2026-03-29T12:07:00.133Z 2026-04-05T12:35:21.496Z
9589511 9589511 20260328033840_L7jUP UK005E 2026-03-29T12:01:23.072Z 2026-04-06T12:37:26.505Z
9589449 9589449 20260328033024_R3Y8V UK005E 2026-03-29T12:01:15.592Z 2026-04-06T12:37:24.026Z
9589345 9589345 20260328031739_YHQzl UK005E 2026-03-29T12:01:07.629Z 2026-04-06T12:37:20.593Z
9588882 9588882 20260328014711_0jM1I UK005E 2026-03-29T12:00:26.382Z 2026-04-06T12:36:55.555Z
9582154 9582154 20260326044233_3wgLX UK005E 2026-03-27T12:04:44.049Z 2026-04-04T12:39:38.874Z
9581330 9581330 20260326025417_ajLMT UK005E 2026-03-27T12:02:44.801Z 2026-04-04T12:38:52.972Z
9580350 9580350 20260326003906_bYRGT UK005E 2026-03-27T12:00:15.589Z 2026-04-04T12:38:07.135Z
9579785 9579785 20260324224955_5RHHi UK005E 2026-03-26T12:14:24.158Z 2026-04-02T12:37:30.042Z
9576842 9576842 20260325031535_fyv8C UK005E 2026-03-26T12:03:27.870Z 2026-04-03T12:36:23.224Z
9576595 9576595 20260325023730_qlGZN UK005E 2026-03-26T12:02:43.500Z 2026-04-03T12:36:13.895Z
9576509 9576509 20260325022456_9V7fi UK005E 2026-03-26T12:02:29.408Z 2026-04-03T12:36:10.890Z
9576464 9576464 20260325021453_dNIKn UK005E 2026-03-26T12:02:20.881Z 2026-04-03T12:36:00.235Z
9576441 9576441 20260325020739_aUGqY UK005E 2026-03-26T12:02:14.912Z 2026-04-03T12:35:58.945Z
9576278 9576278 20260325014713_vf4uS UK005E 2026-03-26T12:01:47.981Z 2026-04-03T12:35:51.467Z
9576266 9576266 20260325014552_z5HKQ UK005E 2026-03-26T12:01:46.318Z 2026-04-03T12:35:51.108Z
9576126 9576126 20260325011937_qi3Gg UK005E 2026-03-26T12:01:23.113Z 2026-04-03T12:35:45.374Z
9562799 9562799 20260323031603_JG55x UK005E 2026-03-24T12:04:06.147Z 2026-03-31T12:26:26.333Z
9562677 9562677 20260323030028_qtZJQ UK005E 2026-03-24T12:03:45.241Z 2026-03-31T12:26:17.247Z
9562593 9562593 20260323024425_z2XnV UK005E 2026-03-24T12:03:30.889Z 2026-03-31T12:26:15.223Z
9562587 9562587 20260323024208_XiyOj UK005E 2026-03-24T12:03:30.397Z 2026-03-31T12:26:15.177Z
9562474 9562474 20260323022344_rbaBA UK005E 2026-03-24T12:03:13.295Z 2026-03-31T12:26:10.961Z
9561919 9561919 20260323005727_5cQ7c UK005E 2026-03-24T12:01:36.682Z 2026-03-31T12:25:56.536Z
9561710 9561710 20260323003111_oJZgF UK005E 2026-03-24T12:01:01.732Z 2026-03-31T12:25:51.594Z
9561361 9561361 20260321232535_WyWd8 UK005E 2026-03-23T12:12:17.253Z 2026-03-29T12:21:06.630Z
9561339 9561339 20260321232411_tD7cI UK005E 2026-03-23T12:12:17.018Z 2026-03-29T12:21:06.565Z
9561005 9561005 20260321224508_Gnmmi UK005E 2026-03-23T12:12:09.332Z 2026-03-29T12:21:04.587Z
9560887 9560887 20260321223136_OdI9d UK005E 2026-03-23T12:12:06.624Z 2026-03-29T12:21:03.708Z
9560865 9560865 20260321223002_4QiV3 UK005E 2026-03-23T12:12:05.989Z 2026-03-29T12:21:03.502Z
9554611 9554611 20260322032036_0s3MO UK005E 2026-03-23T12:02:43.184Z 2026-03-30T12:28:06.448Z
9554131 9554131 20260322024247_4tP3P UK005E 2026-03-23T12:02:15.818Z 2026-03-30T12:27:58.893Z
9553961 9553961 20260322022919_w7VZ8 UK005E 2026-03-23T12:02:03.911Z 2026-03-30T12:27:56.067Z
9553738 9553738 20260322020943_MJdEF UK005E 2026-03-23T12:01:48.807Z 2026-03-30T12:27:51.776Z
9553671 9553671 20260322020526_L9eqd UK005E 2026-03-23T12:01:45.496Z 2026-03-30T12:27:50.863Z
9553429 9553429 20260322014146_5JLnP UK005E 2026-03-23T12:01:29.407Z 2026-03-30T12:27:40.901Z
9552665 9552665 20260322002921_D0kwZ UK005E 2026-03-23T12:00:41.641Z 2026-03-30T12:27:27.860Z
6922006 6922006 20250619013539_tD31T UK005E 2025-06-20T12:15:57.206Z 2025-06-27T12:39:55.924Z
6921556 6921556 20250619010025_OxvhI UK005E 2025-06-20T12:14:53.903Z 2025-06-27T12:39:51.501Z
6920979 6920979 20250619001330_lBRaC UK005E 2025-06-20T12:13:37.313Z 2025-06-27T12:39:45.375Z
6920962 6920962 20250619001205_l8gyF UK005E 2025-06-20T12:13:35.690Z 2025-06-27T12:39:45.321Z
6920600 6920600 20250618234636_8Y0s2 UK005E 2025-06-20T12:12:45.170Z 2025-06-27T12:39:41.657Z
6920411 6920411 20250618232830_7i0bV UK005E 2025-06-20T12:12:13.589Z 2025-06-27T12:39:39.651Z
6920133 6920133 20250618225425_iqUjc UK005E 2025-06-20T12:11:21.590Z 2025-06-27T12:39:36.771Z
6915636 6915636 20250618011946_42Z8M UK005E 2025-06-19T12:17:32.371Z 2025-06-26T12:36:44.656Z
6914371 6914371 20250617225527_C2lN4 UK005E 2025-06-19T12:14:30.836Z 2025-06-26T12:36:38.016Z
6910544 6910544 20250617001205_tGC2c UK005E 2025-06-18T12:20:58.473Z 2025-06-25T12:36:42.604Z
6910404 6910404 20250616235631_3G9gs UK005E 2025-06-18T12:20:45.057Z 2025-06-25T12:36:41.707Z
6897405 6897405 20250616012257_2QQih UK005E 2025-06-16T12:10:53.705Z 2025-06-24T12:59:44.356Z
6897364 6897364 20250616010413_J5BYs UK005E 2025-06-16T12:10:44.779Z 2025-06-24T12:59:39.942Z
6896956 6896956 20250615225530_wbBN0 UK005E 2025-06-16T12:09:51.926Z 2025-06-24T12:59:11.153Z
6896837 6896837 20250615221050_4WXM3 UK005E 2025-06-16T12:09:33.237Z 2025-06-24T12:59:08.884Z
6892917 6892917 20250615014020_OWG20 UK005E 2025-06-15T12:12:45.432Z 2025-06-23T13:01:13.011Z
6892808 6892808 20250615010548_RaMeQ UK005E 2025-06-15T12:12:26.453Z 2025-06-23T13:01:10.867Z
6892750 6892750 20250615004805_affbG UK005E 2025-06-15T12:12:17.638Z 2025-06-23T13:01:09.491Z
6892689 6892689 20250615002755_o826r UK005E 2025-06-15T12:12:12.070Z 2025-06-23T13:01:09.064Z
6892573 6892573 20250615000221_GpBvo UK005E 2025-06-15T12:11:51.778Z 2025-06-23T13:01:08.022Z
6892561 6892561 20250615000039_eZj2O UK005E 2025-06-15T12:11:50.670Z 2025-06-23T13:01:07.880Z
6885642 6885642 20250613012359_lJvL9 UK005E 2025-06-13T12:08:31.804Z 2025-06-21T12:37:07.210Z
6885302 6885302 20250612235743_ajh32 UK005E 2025-06-13T12:07:25.237Z 2025-06-21T12:37:03.134Z
6885003 6885003 20250612230143_j4CQt UK005E 2025-06-13T12:06:33.407Z 2025-06-21T12:37:00.263Z
6884984 6884984 20250612225744_O2Dji UK005E 2025-06-13T12:06:30.419Z 2025-06-21T12:37:00.201Z
6884938 6884938 20250612224641_i2kCJ UK005E 2025-06-13T12:06:18.833Z 2025-06-21T12:36:59.913Z
6883005 6883005 20250611231701_VE2Ow UK005E 2025-06-12T12:06:22.999Z 2025-06-20T12:54:24.320Z
6881376 6881376 20250611004928_KTteF UK005E 2025-06-12T12:00:42.987Z 2025-06-20T12:52:41.872Z
6880930 6880930 20250610235023_slVRQ UK005E 2025-06-11T12:09:50.280Z 2025-06-18T12:42:10.019Z
6865779 6865779 20250606012136_9IEnS UK005E 2025-06-07T12:03:42.282Z 2025-06-14T12:28:24.516Z
6858157 6858157 20250604013403_OG9GO UK005E 2025-06-05T12:05:20.173Z 2025-06-12T12:24:44.991Z
6858081 6858081 20250604011556_XMJRt UK005E 2025-06-05T12:05:09.243Z 2025-06-12T12:24:40.957Z
6858055 6858055 20250604010735_qIfnE UK005E 2025-06-05T12:05:00.147Z 2025-06-12T12:24:39.725Z
6858036 6858036 20250604005636_5eDYH UK005E 2025-06-05T12:04:50.563Z 2025-06-12T12:24:38.950Z
6857822 6857822 20250603232813_0pThT UK005E 2025-06-05T12:03:56.518Z 2025-06-12T12:24:29.140Z
6857749 6857749 20250603224746_HFLbr UK005E 2025-06-05T12:03:33.456Z 2025-06-12T12:24:25.870Z
6855105 6855105 20250603005348_jTdp2 UK005E 2025-06-04T12:08:41.459Z 2025-06-11T12:27:42.822Z
6854780 6854780 20250603001034_hhLC9 UK005E 2025-06-04T12:07:47.720Z 2025-06-11T12:27:34.380Z
6854636 6854636 20250602234936_Zze9g UK005E 2025-06-04T12:07:24.755Z 2025-06-11T12:27:30.347Z
6854378 6854378 20250602230706_szkWj UK005E 2025-06-04T12:06:35.554Z 2025-06-11T12:27:21.543Z
6854256 6854256 20250602225054_8MTvj UK005E 2025-06-04T12:06:17.423Z 2025-06-11T12:27:19.002Z
6854212 6854212 20250602224137_HLm1H UK005E 2025-06-04T12:06:11.612Z 2025-06-11T12:27:17.774Z
6854037 6854037 20250602222125_2ZFSH UK005E 2025-06-04T12:05:43.905Z 2025-06-11T12:27:11.385Z
6848899 6848899 20250602020233_es3kn UK005E 2025-06-03T12:12:27.303Z 2025-06-10T12:29:25.843Z
6848429 6848429 20250602002729_LtetV UK005E 2025-06-03T12:11:10.245Z 2025-06-10T12:29:12.815Z
6848355 6848355 20250602001532_BevvD UK005E 2025-06-03T12:10:54.780Z 2025-06-10T12:29:11.337Z
6848343 6848343 20250602001518_tybti UK005E 2025-06-03T12:10:53.851Z 2025-06-10T12:29:10.928Z
6841390 6841390 20250531232843_mwz5V UK005E 2025-06-02T12:11:46.830Z 2025-06-09T12:45:15.191Z

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