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

8,975 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
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
6837031 6837031 20250531014246_V23yI UK005E 2025-06-01T12:19:13.279Z 2025-06-08T12:32:38.672Z
6837026 6837026 20250531014244_J2Lco UK005E 2025-06-01T12:19:11.375Z 2025-06-08T12:32:38.629Z
6836974 6836974 20250531013627_EBa23 UK005E 2025-06-01T12:18:58.925Z 2025-06-08T12:32:37.958Z
6836912 6836912 20250531012451_Yboij UK005E 2025-06-01T12:18:52.375Z 2025-06-08T12:32:36.672Z
6836849 6836849 20250531011636_TNPIg UK005E 2025-06-01T12:18:47.074Z 2025-06-08T12:32:35.631Z
6836607 6836607 20250531003545_PDrne UK005E 2025-06-01T12:18:03.812Z 2025-06-08T12:32:27.142Z
6836458 6836458 20250531001044_hmAau UK005E 2025-06-01T12:17:48.307Z 2025-06-08T12:32:22.937Z
6836193 6836193 20250530233022_2E3sv UK005E 2025-06-01T12:17:06.182Z 2025-06-08T12:32:15.822Z
6829706 6829706 20250530013054_7UM9Y UK005E 2025-05-31T12:19:08.035Z 2025-06-07T12:36:39.392Z
6829701 6829701 20250530013011_RHgx3 UK005E 2025-05-31T12:19:07.728Z 2025-06-07T12:36:39.266Z
6829688 6829688 20250530012824_ximJK UK005E 2025-05-31T12:19:04.790Z 2025-06-07T12:36:39.164Z
6829582 6829582 20250530010328_NHgLh UK005E 2025-05-31T12:18:52.111Z 2025-06-07T12:36:36.309Z
6829364 6829364 20250530003649_2ZsoT UK005E 2025-05-31T12:18:13.975Z 2025-06-07T12:36:32.680Z
6828674 6828674 20250529215548_BwV8f UK005E 2025-05-31T12:16:17.579Z 2025-06-07T12:36:19.342Z
6818902 6818902 20250528010116_uQVlU UK005E 2025-05-29T12:14:59.188Z 2025-06-05T12:54:55.594Z
6809688 6809688 20250526010042_Lgy62 UK005E 2025-05-27T12:17:09.893Z 2025-06-03T13:03:27.686Z
6809674 6809674 20250526005942_0ozh9 UK005E 2025-05-27T12:17:08.840Z 2025-06-03T13:03:27.197Z
6809655 6809655 20250526005843_Py2dI UK005E 2025-05-27T12:17:07.801Z 2025-06-03T13:03:26.401Z
6808999 6808999 20250525230823_LwImf UK005E 2025-05-27T12:15:38.758Z 2025-06-03T13:03:02.624Z
6808915 6808915 20250525225238_ahDA1 UK005E 2025-05-27T12:15:27.520Z 2025-06-03T13:03:00.051Z
6808898 6808898 20250525225154_XIJDm UK005E 2025-05-27T12:15:25.654Z 2025-06-03T13:02:59.743Z
6808840 6808840 20250525223917_rg5O1 UK005E 2025-05-27T12:15:08.567Z 2025-06-03T13:02:58.347Z
6788613 6788613 20250523022627_khADB UK005E 2025-05-24T12:23:05.178Z 2025-05-31T13:15:22.413Z
6788495 6788495 20250523020813_UQ3P9 UK005E 2025-05-24T12:22:56.502Z 2025-05-31T13:15:18.067Z
6788433 6788433 20250523020304_BNZmJ UK005E 2025-05-24T12:22:41.448Z 2025-05-31T13:15:15.812Z
6787438 6787438 20250523002247_SYjjT UK005E 2025-05-24T12:20:51.807Z 2025-05-31T13:14:28.698Z
6787064 6787064 20250522233937_n0lH2 UK005E 2025-05-24T12:20:02.273Z 2025-05-31T13:14:03.794Z
6786519 6786519 20250522214719_m6sS8 UK005E 2025-05-24T12:18:52.977Z 2025-05-31T13:13:34.384Z
6781177 6781177 20250522020211_K0h1u UK005E 2025-05-23T12:25:17.205Z 2025-05-30T13:10:06.642Z
6781152 6781152 20250522015941_Gtwtj UK005E 2025-05-23T12:25:12.275Z 2025-05-30T13:10:06.021Z
6780990 6780990 20250522013717_2kMGf UK005E 2025-05-23T12:24:45.848Z 2025-05-30T13:09:54.045Z
6780865 6780865 20250522011639_tebFn UK005E 2025-05-23T12:24:36.985Z 2025-05-30T13:09:39.759Z
6780789 6780789 20250522010532_CWrQH UK005E 2025-05-23T12:24:32.276Z 2025-05-30T13:09:32.136Z
6780685 6780685 20250522005512_L1wGz UK005E 2025-05-23T12:24:28.712Z 2025-05-30T13:09:25.303Z
6780485 6780485 20250522001621_1Xl2a UK005E 2025-05-23T12:24:19.991Z 2025-05-30T13:09:19.126Z
6779641 6779641 20250521214837_OfjDo UK005E 2025-05-23T12:22:57.941Z 2025-05-30T13:08:41.686Z
6762576 6762576 20250520013854_KGTBF UK005E 2025-05-21T12:23:02.896Z 2025-05-28T13:14:02.455Z
6762241 6762241 20250520005231_fBInv UK005E 2025-05-21T12:22:33.146Z 2025-05-28T13:13:53.392Z
6761896 6761896 20250520001731_lF9aQ UK005E 2025-05-21T12:22:01.371Z 2025-05-28T13:13:26.342Z
6761870 6761870 20250520001513_grXnL UK005E 2025-05-21T12:21:58.582Z 2025-05-28T13:13:25.708Z
6761819 6761819 20250520000820_F3LzA UK005E 2025-05-21T12:21:53.812Z 2025-05-28T13:13:24.534Z
6761469 6761469 20250519233643_933in UK005E 2025-05-21T12:21:35.453Z 2025-05-28T13:13:15.258Z
6754105 6754105 20250519011038_pTFcx UK005E 2025-05-20T12:20:08.920Z 2025-05-27T13:21:44.279Z
6737800 6737800 20250515222407_Rk8ZO UK005E 2025-05-17T12:22:38.881Z 2025-05-23T12:37:04.096Z
6737793 6737793 20250515222407_9l9eS UK005E 2025-05-17T12:22:38.171Z 2025-05-23T12:37:04.075Z
6731546 6731546 20250516010401_XCYH1 UK005E 2025-05-17T12:03:01.442Z 2025-05-24T12:40:04.483Z
6730852 6730852 20250515234214_2sbbU UK005E 2025-05-17T12:00:52.244Z 2025-05-24T12:39:55.996Z
6730665 6730665 20250515230646_UUIYd UK005E 2025-05-17T12:00:20.157Z 2025-05-24T12:39:53.831Z
6723681 6723681 20250514230945_ThZcn UK005E 2025-05-16T12:01:14.472Z 2025-05-23T12:35:56.705Z
6723328 6723328 20250514221933_L2Rrh UK005E 2025-05-16T12:00:20.167Z 2025-05-23T12:35:53.199Z
6720973 6720973 20250513235750_EvPWS UK005E 2025-05-15T12:02:27.466Z 2025-05-22T12:36:09.168Z
6720806 6720806 20250513232653_WwtJD UK005E 2025-05-15T12:02:03.583Z 2025-05-22T12:36:05.582Z

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