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,921 rows where station_code = "UK001T" 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
9271830 9271830 20260127203329_3shab UK001T 2026-01-29T14:24:09.352Z 2026-01-30T14:30:59.144Z
9202504 9202504 20260114034410_8vkF1 UK001T 2026-01-15T14:21:33.200Z 2026-01-22T15:09:21.543Z
9202385 9202385 20260114033329_0FbDv UK001T 2026-01-15T14:21:10.956Z 2026-01-22T15:09:17.091Z
9201209 9201209 20260114015359_3s8Ns UK001T 2026-01-15T14:17:47.346Z 2026-01-22T15:08:59.528Z
9200508 9200508 20260114001750_4Aog8 UK001T 2026-01-15T14:15:22.490Z 2026-01-22T15:08:17.219Z
9200472 9200472 20260114001329_F73ZG UK001T 2026-01-15T14:15:17.284Z 2026-01-22T15:08:16.533Z
9199872 9199872 20260113214255_sz7n1 UK001T 2026-01-15T14:12:54.598Z 2026-01-22T15:08:04.451Z
9194553 9194553 20260112212500_9Fwwt UK001T 2026-01-14T14:09:45.424Z 2026-01-21T15:04:18.651Z
9144365 9144365 20260104024224_UR6jT UK001T 2026-01-05T14:18:59.127Z 2026-01-12T15:07:05.478Z
9142663 9142663 20260104014439_TzMx8 UK001T 2026-01-05T14:16:17.393Z 2026-01-12T15:05:49.249Z
9142236 9142236 20260104012653_GNdZG UK001T 2026-01-05T14:15:42.280Z 2026-01-12T15:05:37.602Z
9141288 9141288 20260104004815_YcERY UK001T 2026-01-05T14:14:23.873Z 2026-01-12T15:04:54.805Z
9139786 9139786 20260103234552_1vbv2 UK001T 2026-01-05T14:12:11.817Z 2026-01-12T15:03:50.929Z
9139412 9139412 20260103233139_kr5jN UK001T 2026-01-05T14:11:38.138Z 2026-01-12T15:03:27.886Z
9138525 9138525 20260103223137_f9gY1 UK001T 2026-01-05T14:10:03.494Z 2026-01-12T15:02:51.767Z
9131873 9131873 20260103060154_egyuo UK001T 2026-01-04T14:15:09.719Z 2026-01-10T15:00:59.478Z
9131712 9131712 20260103054638_Wlg1U UK001T 2026-01-04T14:14:44.720Z 2026-01-10T15:00:48.197Z
9130933 9130933 20260103043404_D8uIZ UK001T 2026-01-04T14:12:07.352Z 2026-01-10T14:59:51.890Z
9127940 9127940 20260102055205_XQSFF UK001T 2026-01-03T14:12:42.023Z 2026-01-09T14:50:18.188Z
9123972 9123972 20251231041639_CHSwj UK001T 2026-01-02T14:39:02.909Z 2026-01-08T15:09:47.900Z
9114429 9114429 20251231041637_yDmtz UK001T 2026-01-01T14:22:29.533Z 2026-01-08T15:09:47.553Z
9073453 9073453 20251225174715_VpDvT UK001T 2025-12-29T14:59:18.282Z 2026-01-02T15:47:51.630Z
9066688 9066688 20251226064038_w3vjS UK001T 2025-12-29T14:40:26.669Z 2026-01-03T15:37:59.152Z
9065390 9065390 20251226050949_u5lXI UK001T 2025-12-29T14:38:31.202Z 2026-01-03T15:36:53.302Z
9052777 9052777 20251227011219_kz8gp UK001T 2025-12-29T14:11:02.916Z 2026-01-04T15:25:45.379Z
9052093 9052093 20251227003341_w0xJa UK001T 2025-12-29T14:09:05.531Z 2026-01-04T15:25:12.555Z
9037110 9037110 20251224060408_87dxr UK001T 2025-12-28T14:36:39.379Z 2026-01-01T15:54:44.158Z
8983754 8983754 20251219222803_3wCJD UK001T 2025-12-26T14:29:37.963Z 2025-12-28T15:23:43.662Z
8983219 8983219 20251219213011_n1A4y UK001T 2025-12-26T14:28:41.839Z 2025-12-28T15:23:35.586Z
8981380 8981380 20251219172643_LmLTK UK001T 2025-12-26T14:24:37.128Z 2025-12-27T15:16:18.330Z
8976663 8976663 20251219032738_cKgU7 UK001T 2025-12-26T14:10:27.710Z 2025-12-28T15:17:27.166Z
8974049 8974049 20251220015825_gXs9x UK001T 2025-12-26T14:03:42.861Z 2025-12-29T15:22:38.618Z
8968980 8968980 20251216180610_YjNZd UK001T 2025-12-25T14:50:13.354Z 2025-12-25T14:50:13.354Z
8827431 8827431 20251213180949_ZNlF4 UK001T 2025-12-18T14:27:46.373Z 2025-12-23T14:23:08.221Z
8802596 8802596 20251213064926_WpDnf UK001T 2025-12-16T14:14:33.133Z 2025-12-23T14:19:25.450Z
8802492 8802492 20251213064544_acTTC UK001T 2025-12-16T14:14:25.723Z 2025-12-23T14:19:25.038Z
8802327 8802327 20251213064050_2Ztmw UK001T 2025-12-16T14:14:19.954Z 2025-12-23T14:19:24.520Z
8801862 8801862 20251213062900_Mj50G UK001T 2025-12-16T14:14:05.739Z 2025-12-23T14:19:22.760Z
8801499 8801499 20251213062330_aN2NF UK001T 2025-12-16T14:13:30.280Z 2025-12-23T14:19:21.599Z
8801325 8801325 20251213062001_sRv1D UK001T 2025-12-16T14:13:27.679Z 2025-12-23T14:19:21.158Z
8801298 8801298 20251213061941_a5syw UK001T 2025-12-16T14:13:27.143Z 2025-12-23T14:19:21.063Z
8798562 8798562 20251213052604_tJMc5 UK001T 2025-12-16T14:11:02.489Z 2025-12-23T14:18:24.657Z
8797753 8797753 20251213051137_4YcH0 UK001T 2025-12-16T14:10:13.958Z 2025-12-23T14:18:10.226Z
8797137 8797137 20251213050148_qgDUr UK001T 2025-12-16T14:09:33.765Z 2025-12-23T14:17:55.644Z
8794728 8794728 20251213042743_nKB90 UK001T 2025-12-16T14:07:22.257Z 2025-12-23T14:17:14.121Z
8794671 8794671 20251213042721_Rr6Z4 UK001T 2025-12-16T14:07:19.623Z 2025-12-23T14:17:11.851Z
8791372 8791372 20251213034210_suQUR UK001T 2025-12-16T14:03:23.248Z 2025-12-23T14:16:23.260Z
8786601 8786601 20251213023224_PiDcd UK001T 2025-12-15T14:37:39.436Z 2025-12-21T14:17:36.823Z
8785298 8785298 20251213021336_4wUJk UK001T 2025-12-15T14:36:49.929Z 2025-12-21T14:17:36.097Z
8782069 8782069 20251213012320_TPOrg UK001T 2025-12-15T14:33:59.392Z 2025-12-21T14:17:34.122Z
8779480 8779480 20251213004128_t4jXO UK001T 2025-12-15T14:32:06.002Z 2025-12-21T14:17:32.709Z
8778460 8778460 20251213002626_3TG6e UK001T 2025-12-15T14:31:09.506Z 2025-12-21T14:17:32.173Z
8777270 8777270 20251213000314_SQi7d UK001T 2025-12-15T14:29:55.465Z 2025-12-21T14:17:31.417Z
8776774 8776774 20251212235305_hXChm UK001T 2025-12-15T14:29:35.354Z 2025-12-21T14:17:31.085Z
8776670 8776670 20251212235100_MsZ37 UK001T 2025-12-15T14:29:33.611Z 2025-12-21T14:17:31.034Z
8775122 8775122 20251212232008_cd9CR UK001T 2025-12-15T14:27:54.988Z 2025-12-21T14:17:30.154Z
8773705 8773705 20251212224602_NDU7j UK001T 2025-12-15T14:26:16.381Z 2025-12-21T14:17:29.244Z
8772354 8772354 20251212220249_LL7OL UK001T 2025-12-15T14:24:50.186Z 2025-12-21T14:17:28.418Z
8772026 8772026 20251212215253_cX326 UK001T 2025-12-15T14:24:09.432Z 2025-12-21T14:17:28.240Z
8769688 8769688 20251212193628_26BmG UK001T 2025-12-15T14:20:53.243Z 2025-12-21T14:17:26.861Z
8769596 8769596 20251212192735_eNyxl UK001T 2025-12-15T14:20:36.314Z 2025-12-21T14:17:26.797Z
8754209 8754209 20251210013842_mo5I2 UK001T 2025-12-13T15:42:47.864Z 2025-12-17T15:28:41.340Z
8742821 8742821 20251210224643_WhibL UK001T 2025-12-13T15:23:10.627Z 2025-12-19T15:13:24.409Z
8714258 8714258 20251210050021_vRW0V UK001T 2025-12-11T14:02:03.004Z 2025-12-19T15:05:28.538Z
8708296 8708296 20251208035434_DXlkN UK001T 2025-12-09T14:29:17.216Z 2025-12-16T15:13:20.936Z
8680594 8680594 20251203004542_Uz3LO UK001T 2025-12-04T14:12:26.336Z 2025-12-11T14:45:44.654Z
8675904 8675904 20251202052254_3tSqW UK001T 2025-12-03T14:24:29.605Z 2025-12-10T14:39:41.259Z
8674845 8674845 20251202033137_wgy1J UK001T 2025-12-03T14:22:29.334Z 2025-12-10T14:39:12.227Z
8674712 8674712 20251202031046_Uo44H UK001T 2025-12-03T14:22:14.360Z 2025-12-10T14:39:10.289Z
8653311 8653311 20251130021009_lLHsm UK001T 2025-12-01T14:23:12.826Z 2025-12-08T14:54:54.550Z
8643548 8643548 20251128180612_lIx2p UK001T 2025-11-30T14:20:12.763Z 2025-12-07T14:56:04.175Z
8634798 8634798 20251128011953_9ieo9 UK001T 2025-11-29T14:22:04.556Z 2025-12-06T15:02:36.112Z
8632911 8632911 20251127221839_AUMCr UK001T 2025-11-29T14:18:34.389Z 2025-12-06T15:01:35.529Z
8625307 8625307 20251125174810_lV6Tb UK001T 2025-11-28T14:30:21.559Z 2025-12-04T15:06:02.458Z
8609060 8609060 20251125231110_AXI9v UK001T 2025-11-27T14:17:31.436Z 2025-12-04T15:07:51.127Z
8607874 8607874 20251125212932_8ltjm UK001T 2025-11-27T14:14:40.201Z 2025-12-04T15:07:38.112Z
8585953 8585953 20251123181907_MoO9H UK001T 2025-11-25T14:11:29.102Z 2025-12-02T15:10:38.683Z
8569626 8569626 20251121060507_xRugR UK001T 2025-11-23T14:32:22.738Z 2025-11-29T14:54:48.601Z
8558802 8558802 20251121034300_bs5zC UK001T 2025-11-22T14:41:17.238Z 2025-11-29T14:54:36.704Z
8549704 8549704 20251120225107_HuNhc UK001T 2025-11-22T14:19:28.248Z 2025-11-29T14:54:25.337Z
8541520 8541520 20251120022835_dPWK7 UK001T 2025-11-21T14:37:20.782Z 2025-11-28T14:56:51.770Z
8538080 8538080 20251119201829_8T2Kc UK001T 2025-11-21T14:33:20.609Z 2025-11-28T14:55:06.349Z
8536827 8536827 20251120052043_3d1KP UK001T 2025-11-21T14:19:11.262Z 2025-11-28T14:57:59.631Z
8535280 8535280 20251120014522_3Oay5 UK001T 2025-11-21T14:15:46.417Z 2025-11-28T14:56:28.371Z
8534957 8534957 20251120004934_Z2NT8 UK001T 2025-11-21T14:14:56.772Z 2025-11-21T14:35:57.066Z
8534253 8534253 20251119224754_3yEdM UK001T 2025-11-21T14:13:24.805Z 2025-11-28T14:55:40.152Z
8511034 8511034 20251117175039_d4Mc2 UK001T 2025-11-19T14:32:14.640Z 2025-11-26T15:06:43.676Z
8506381 8506381 20251117212630_kYkjH UK001T 2025-11-19T14:12:45.750Z 2025-11-26T15:07:41.562Z
8505732 8505732 20251117203954_VlnhR UK001T 2025-11-19T14:11:16.954Z 2025-11-26T15:07:39.547Z
8495706 8495706 20251117040505_FmVzS UK001T 2025-11-18T14:26:33.666Z 2025-11-25T15:09:59.277Z
8491201 8491201 20251116215204_7lEv2 UK001T 2025-11-18T14:16:40.117Z 2025-11-25T15:08:33.599Z
8442335 8442335 20251110194337_v8pVs UK001T 2025-11-13T14:43:15.534Z 2025-11-19T15:14:16.615Z
8421349 8421349 20251110203047_RDzY2 UK001T 2025-11-12T14:13:42.010Z 2025-11-19T15:14:31.030Z
8344560 8344560 20251101045904_dZ3mR UK001T 2025-11-02T14:42:02.514Z 2025-11-09T15:03:32.968Z
8336034 8336034 20251031040947_tIeGS UK001T 2025-11-02T14:28:50.325Z 2025-11-08T15:15:29.436Z
8324226 8324226 20251030052938_ffETx UK001T 2025-11-01T12:32:13.173Z 2025-11-07T15:17:04.461Z
8319986 8319986 20251030023635_3LiX2 UK001T 2025-11-01T12:25:43.263Z 2025-11-07T15:13:55.596Z
8310274 8310274 20251029192018_ObsRZ UK001T 2025-10-31T12:34:13.714Z 2025-11-07T15:10:39.146Z
8263508 8263508 20251026045140_jI2eZ UK001T 2025-10-28T12:36:08.913Z 2025-11-03T15:16:53.337Z
8259450 8259450 20251026024951_DJVNN UK001T 2025-10-28T12:32:47.944Z 2025-11-03T15:16:26.294Z

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