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

4,634 rows where station_code = "UK000U" 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
8683210 8683210 20251203064042_Eqjg6 UK000U 2025-12-04T14:18:56.757Z 2025-12-06T14:29:46.216Z
8683109 8683109 20251203062758_iS9Fv UK000U 2025-12-04T14:18:35.016Z 2025-12-06T14:29:41.743Z
8682873 8682873 20251203061135_BZoM0 UK000U 2025-12-04T14:18:10.529Z 2025-12-06T14:29:30.033Z
8677010 8677010 20251202064010_12j3o UK000U 2025-12-03T14:26:11.642Z 2025-12-06T14:35:32.943Z
8676301 8676301 20251202054523_MYtSy UK000U 2025-12-03T14:25:01.698Z 2025-12-06T14:35:19.958Z
8675540 8675540 20251202045557_6jwAO UK000U 2025-12-03T14:23:50.825Z 2025-12-06T14:34:56.023Z
8675530 8675530 20251202045507_Lbzry UK000U 2025-12-03T14:23:50.385Z 2025-12-06T14:34:55.835Z
8675479 8675479 20251202044716_Hh7YH UK000U 2025-12-03T14:23:45.917Z 2025-12-06T14:34:54.105Z
8675261 8675261 20251202042435_Ih9Ow UK000U 2025-12-03T14:23:25.078Z 2025-12-06T14:34:48.448Z
8675257 8675257 20251202042339_d47qo UK000U 2025-12-03T14:23:24.694Z 2025-12-06T14:34:48.314Z
8674900 8674900 20251202033756_e25Cu UK000U 2025-12-03T14:22:42.117Z 2025-12-06T14:34:22.589Z
8674495 8674495 20251202023659_SkhVu UK000U 2025-12-03T14:21:42.550Z 2025-12-06T14:34:10.407Z
8661780 8661780 20251130171132_gSbPV UK000U 2025-12-02T14:13:01.810Z 2025-12-06T14:38:31.963Z
8658306 8658306 20251127210050_LQmLX UK000U 2025-12-01T14:50:10.776Z 2025-12-06T15:01:14.588Z
8658297 8658297 20251127205641_bRYge UK000U 2025-12-01T14:50:10.399Z 2025-12-06T15:01:14.375Z
8656144 8656144 20251130044007_nc34g UK000U 2025-12-01T14:28:06.758Z 2025-12-06T14:49:31.557Z
8656073 8656073 20251130043513_7te73 UK000U 2025-12-01T14:28:01.105Z 2025-12-06T14:49:30.298Z
8655863 8655863 20251130042122_4iK7M UK000U 2025-12-01T14:27:33.669Z 2025-12-06T14:49:28.604Z
8655326 8655326 20251130035446_2vv5a UK000U 2025-12-01T14:26:46.309Z 2025-12-06T14:49:07.983Z
8654929 8654929 20251130033844_ZvoEJ UK000U 2025-12-01T14:26:11.181Z 2025-12-06T14:48:50.166Z
8652463 8652463 20251130011101_L8Gal UK000U 2025-12-01T14:21:27.852Z 2025-12-06T14:47:37.456Z
8652336 8652336 20251130010341_0HTog UK000U 2025-12-01T14:21:16.831Z 2025-12-06T14:47:35.676Z
8652097 8652097 20251130004730_XrnWE UK000U 2025-12-01T14:20:42.804Z 2025-12-06T14:47:16.793Z
8651208 8651208 20251129230525_0ouIG UK000U 2025-12-01T14:18:24.066Z 2025-12-06T14:46:41.966Z
8644492 8644492 20251128192854_3nxOY UK000U 2025-11-30T14:22:02.682Z 2025-12-06T14:54:43.071Z
8644390 8644390 20251128192444_GknT0 UK000U 2025-11-30T14:21:56.715Z 2025-12-06T14:54:41.715Z
8643580 8643580 20251128180722_2pEE0 UK000U 2025-11-30T14:20:14.145Z 2025-12-06T14:53:51.552Z
8637630 8637630 20251128060124_s2Is2 UK000U 2025-11-29T14:27:38.104Z 2025-12-06T15:04:01.843Z
8637517 8637517 20251128054637_Ii0Ll UK000U 2025-11-29T14:27:31.976Z 2025-12-06T15:04:00.803Z
8637361 8637361 20251128053328_9wAT0 UK000U 2025-11-29T14:27:07.114Z 2025-12-06T15:03:59.315Z
8637168 8637168 20251128051129_00Dml UK000U 2025-11-29T14:26:55.762Z 2025-12-06T15:03:57.225Z
8637115 8637115 20251128050209_5cLQL UK000U 2025-11-29T14:26:51.541Z 2025-12-06T15:03:56.631Z
8636595 8636595 20251128040813_cA8rU UK000U 2025-11-29T14:25:44.400Z 2025-12-06T15:03:32.054Z
8635411 8635411 20251128021049_pENuY UK000U 2025-11-29T14:23:22.138Z 2025-12-06T15:02:44.287Z
8635288 8635288 20251128020039_tfP20 UK000U 2025-11-29T14:23:00.945Z 2025-12-06T15:02:43.019Z
8633700 8633700 20251127234640_1MA2I UK000U 2025-11-29T14:20:07.005Z 2025-12-06T15:01:48.022Z
8633592 8633592 20251127233629_6uLBF UK000U 2025-11-29T14:19:56.980Z 2025-12-06T15:01:46.005Z
8633467 8633467 20251127232056_jCpSJ UK000U 2025-11-29T14:19:45.994Z 2025-12-06T15:01:44.221Z
8632702 8632702 20251127213953_Xq32l UK000U 2025-11-29T14:18:05.294Z 2025-12-06T15:01:32.555Z
8632674 8632674 20251127213446_HR9Be UK000U 2025-11-29T14:17:59.150Z 2025-12-06T15:01:32.266Z
8632362 8632362 20251127205641_1iHym UK000U 2025-11-29T14:17:19.584Z 2025-11-30T14:35:13.453Z
8631572 8631572 20251127192732_7SxYD UK000U 2025-11-29T14:15:46.738Z 2025-12-06T15:00:20.851Z
8616049 8616049 20251126053426_fwCiL UK000U 2025-11-27T14:30:23.856Z 2025-12-04T15:11:34.896Z
8614936 8614936 20251126043703_6z7Mw UK000U 2025-11-27T14:28:43.758Z 2025-12-04T15:11:22.153Z
8611660 8611660 20251126015521_kt3Y7 UK000U 2025-11-27T14:22:25.354Z 2025-12-04T15:09:23.135Z
8610633 8610633 20251126010045_7rAFo UK000U 2025-11-27T14:20:28.830Z 2025-12-04T15:08:21.603Z
8610189 8610189 20251126003026_kvoYk UK000U 2025-11-27T14:19:34.308Z 2025-12-04T15:08:03.222Z
8609689 8609689 20251125235953_w2WGs UK000U 2025-11-27T14:18:50.086Z 2025-12-04T15:07:56.674Z
8609602 8609602 20251125235028_YDu2a UK000U 2025-11-27T14:18:30.678Z 2025-12-04T15:07:55.661Z
8609105 8609105 20251125231434_lUsLo UK000U 2025-11-27T14:17:34.851Z 2025-12-04T15:07:51.624Z
8609088 8609088 20251125231407_INhiU UK000U 2025-11-27T14:17:33.169Z 2025-12-04T15:07:51.430Z
8609035 8609035 20251125230807_rk2JS UK000U 2025-11-27T14:17:28.690Z 2025-12-04T15:07:50.911Z
8607918 8607918 20251125213307_GWkbc UK000U 2025-11-27T14:14:47.896Z 2025-12-04T15:07:39.143Z
8606803 8606803 20251125194508_waZoi UK000U 2025-11-27T14:11:29.394Z 2025-12-04T15:06:50.864Z
8606766 8606766 20251125193841_I9OY7 UK000U 2025-11-27T14:11:20.107Z 2025-12-04T15:06:50.007Z
8602951 8602951 20251125053505_Dgh18 UK000U 2025-11-26T14:26:30.034Z 2025-12-02T15:09:33.691Z
8602886 8602886 20251125053120_Gdhu4 UK000U 2025-11-26T14:26:26.332Z 2025-12-02T15:09:33.401Z
8602356 8602356 20251125045031_iV3vY UK000U 2025-11-26T14:25:35.164Z 2025-12-02T15:09:30.597Z
8599847 8599847 20251125022740_pgE3E UK000U 2025-11-26T14:21:32.793Z 2025-12-02T15:08:32.399Z
8597347 8597347 20251124232757_H3327 UK000U 2025-11-26T14:16:42.576Z 2025-12-02T15:07:30.280Z
8596549 8596549 20251124213054_ShePO UK000U 2025-11-26T14:14:44.556Z 2025-12-02T15:07:02.505Z
8596147 8596147 20251124200516_j2AB3 UK000U 2025-11-26T14:13:49.781Z 2025-12-02T15:06:45.210Z
8574492 8574492 20251120000132_Dsv2v UK000U 2025-11-23T14:49:14.561Z 2025-11-28T14:55:55.059Z
8568162 8568162 20251121050338_Z8lcU UK000U 2025-11-23T14:30:55.791Z 2025-11-29T14:54:46.182Z
8568119 8568119 20251121050238_Goplu UK000U 2025-11-23T14:30:53.826Z 2025-11-29T14:54:46.116Z
8568063 8568063 20251121050042_bDjxe UK000U 2025-11-23T14:30:40.494Z 2025-11-29T14:54:45.990Z
8567704 8567704 20251121014049_P8sBf UK000U 2025-11-23T14:27:12.319Z 2025-11-29T14:54:31.915Z
8567533 8567533 20251120215946_jd1QR UK000U 2025-11-23T14:25:02.256Z 2025-11-29T14:54:24.099Z
8567467 8567467 20251120202155_BHf7M UK000U 2025-11-23T14:24:06.275Z 2025-11-29T14:54:21.290Z
8560485 8560485 20251121045757_lyp8v UK000U 2025-11-22T14:42:53.415Z 2025-11-29T14:54:45.846Z
8560450 8560450 20251121045526_B53je UK000U 2025-11-22T14:42:52.730Z 2025-11-22T14:42:52.730Z
8559726 8559726 20251121042410_QHBBY UK000U 2025-11-22T14:42:02.630Z 2025-11-29T14:54:43.729Z
8559549 8559549 20251121041659_psjUn UK000U 2025-11-22T14:41:58.316Z 2025-11-29T14:54:40.755Z
8555991 8555991 20251121013307_5EnIX UK000U 2025-11-22T14:38:58.114Z 2025-11-29T14:54:31.663Z
8555672 8555672 20251121011515_L5Pz6 UK000U 2025-11-22T14:38:49.018Z 2025-11-29T14:54:30.895Z
8555649 8555649 20251121011346_jTcnP UK000U 2025-11-22T14:38:48.679Z 2025-11-29T14:54:30.831Z
8555308 8555308 20251121010312_0Zt63 UK000U 2025-11-22T14:38:24.272Z 2025-11-29T14:54:30.316Z
8551213 8551213 20251121003034_RkhVc UK000U 2025-11-22T14:22:18.940Z 2025-11-29T14:54:28.350Z
8551083 8551083 20251121002001_E84sa UK000U 2025-11-22T14:21:59.027Z 2025-11-29T14:54:28.146Z
8550867 8550867 20251121000756_IKldF UK000U 2025-11-22T14:21:47.010Z 2025-11-29T14:54:27.766Z
8549152 8549152 20251120215813_uB2Tk UK000U 2025-11-22T14:18:24.021Z 2025-11-29T14:54:24.093Z
8548135 8548135 20251120203838_whaBL UK000U 2025-11-22T14:16:21.214Z 2025-11-29T14:54:22.031Z
8546569 8546569 20251120184014_Ooh7k UK000U 2025-11-22T14:13:08.288Z 2025-11-29T14:54:16.441Z
8540745 8540745 20251120012721_HWFXB UK000U 2025-11-21T14:36:47.761Z 2025-11-28T14:56:20.224Z
8539729 8539729 20251120000019_FNckV UK000U 2025-11-21T14:35:39.717Z 2025-11-28T14:55:53.321Z
8539007 8539007 20251119225518_t8AK5 UK000U 2025-11-21T14:34:43.033Z 2025-11-28T14:55:40.734Z
8537842 8537842 20251119192112_7t7FZ UK000U 2025-11-21T14:33:11.137Z 2025-11-28T14:54:52.285Z
8536996 8536996 20251120054725_p1ZRu UK000U 2025-11-21T14:19:22.428Z 2025-11-28T14:58:25.782Z
8536944 8536944 20251120053834_oh1on UK000U 2025-11-21T14:19:19.401Z 2025-11-28T14:58:19.879Z
8536874 8536874 20251120052900_lamXY UK000U 2025-11-21T14:19:14.523Z 2025-11-28T14:58:02.157Z
8536683 8536683 20251120045423_0HDRr UK000U 2025-11-21T14:18:50.029Z 2025-11-28T14:57:48.551Z
8536380 8536380 20251120041701_3v3LA UK000U 2025-11-21T14:18:11.070Z 2025-11-28T14:57:35.411Z
8536337 8536337 20251120041052_fVrpE UK000U 2025-11-21T14:18:08.399Z 2025-11-28T14:57:32.034Z
8535103 8535103 20251120011514_7oEg2 UK000U 2025-11-21T14:15:17.792Z 2025-11-28T14:56:17.525Z
8534603 8534603 20251119235115_6jMhR UK000U 2025-11-21T14:14:15.536Z 2025-11-28T14:55:51.502Z
8534500 8534500 20251119233100_f5iOx UK000U 2025-11-21T14:13:58.112Z 2025-11-28T14:55:47.465Z
8534393 8534393 20251119231438_tJatN UK000U 2025-11-21T14:13:46.732Z 2025-11-28T14:55:45.464Z
8534102 8534102 20251119220529_0wbHb UK000U 2025-11-21T14:13:06.230Z 2025-11-28T14:55:36.266Z
8534073 8534073 20251119215223_iQbUd UK000U 2025-11-21T14:13:02.345Z 2025-11-28T14:55:35.428Z
8533117 8533117 20251119175404_bQcx8 UK000U 2025-11-21T14:09:45.561Z 2025-11-28T14:54:16.233Z

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