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,600 rows where station_code = "UK00CE" 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
8657735 8657735 20251130060405_xb680 UK00CE 2025-12-01T14:34:39.371Z 2025-12-06T14:50:22.051Z
8657622 8657622 20251130055451_vKoID UK00CE 2025-12-01T14:34:35.152Z 2025-12-06T14:50:16.038Z
8656573 8656573 20251130050007_teo9z UK00CE 2025-12-01T14:28:45.663Z 2025-12-06T14:49:36.441Z
8656061 8656061 20251130043351_Lw63u UK00CE 2025-12-01T14:27:59.794Z 2025-12-06T14:49:30.155Z
8655953 8655953 20251130042717_1byaU UK00CE 2025-12-01T14:27:41.856Z 2025-12-06T14:49:29.235Z
8655426 8655426 20251130040154_uXuER UK00CE 2025-12-01T14:26:53.664Z 2025-12-06T14:49:15.676Z
8655414 8655414 20251130040130_cvDx4 UK00CE 2025-12-01T14:26:53.236Z 2025-12-06T14:49:14.999Z
8655325 8655325 20251130035443_QuHlb UK00CE 2025-12-01T14:26:45.959Z 2025-12-06T14:49:06.449Z
8655104 8655104 20251130034435_gH3bn UK00CE 2025-12-01T14:26:23.085Z 2025-12-06T14:48:51.465Z
8654875 8654875 20251130033641_W1q3m UK00CE 2025-12-01T14:26:07.916Z 2025-12-06T14:48:49.600Z
8651592 8651592 20251129235817_gX5d1 UK00CE 2025-12-01T14:19:25.324Z 2025-12-06T14:46:49.101Z
8651457 8651457 20251129234421_tGo1N UK00CE 2025-12-01T14:19:09.231Z 2025-12-06T14:46:46.909Z
8651322 8651322 20251129232620_e1c3T UK00CE 2025-12-01T14:18:44.835Z 2025-12-06T14:46:43.812Z
8635030 8635030 20251128013452_vZgrK UK00CE 2025-11-29T14:22:23.837Z 2025-12-06T15:02:39.910Z
8634908 8634908 20251128012518_AZNNp UK00CE 2025-11-29T14:22:10.717Z 2025-12-06T15:02:37.306Z
8634903 8634903 20251128012517_DKb3h UK00CE 2025-11-29T14:22:10.495Z 2025-12-06T15:02:37.283Z
8634595 8634595 20251128010124_54ztf UK00CE 2025-11-29T14:21:35.680Z 2025-12-06T15:02:23.110Z
8615045 8615045 20251126044224_BQ80O UK00CE 2025-11-27T14:28:55.421Z 2025-12-04T15:11:25.607Z
8614928 8614928 20251126043653_P5hyR UK00CE 2025-11-27T14:28:43.021Z 2025-12-04T15:11:21.850Z
8614880 8614880 20251126043343_K9M25 UK00CE 2025-11-27T14:28:40.380Z 2025-12-04T15:11:17.459Z
8614087 8614087 20251126035019_yWgBJ UK00CE 2025-11-27T14:27:12.031Z 2025-12-04T15:10:18.893Z
8613434 8613434 20251126031734_2jnKq UK00CE 2025-11-27T14:26:03.791Z 2025-12-04T15:09:40.480Z
8612681 8612681 20251126024138_2m4LS UK00CE 2025-11-27T14:24:27.408Z 2025-12-04T15:09:32.682Z
8612673 8612673 20251126024138_GUh6e UK00CE 2025-11-27T14:24:27.138Z 2025-12-04T15:09:32.648Z
8612531 8612531 20251126023504_zaLPX UK00CE 2025-11-27T14:24:17.732Z 2025-12-04T15:09:31.391Z
8612311 8612311 20251126022552_3RFrA UK00CE 2025-11-27T14:23:46.148Z 2025-12-04T15:09:29.433Z
8611298 8611298 20251126013628_TJGmC UK00CE 2025-11-27T14:21:49.493Z 2025-12-04T15:09:07.468Z
8610380 8610380 20251126004011_SgaDP UK00CE 2025-11-27T14:20:01.488Z 2025-12-04T15:08:04.762Z
8610103 8610103 20251126002133_PIwxL UK00CE 2025-11-27T14:19:26.678Z 2025-12-04T15:08:02.066Z
8609134 8609134 20251125231456_UjoNf UK00CE 2025-11-27T14:17:35.541Z 2025-12-04T15:07:51.780Z
8608691 8608691 20251125223544_w2pAC UK00CE 2025-11-27T14:16:32.493Z 2025-12-04T15:07:47.750Z
8608366 8608366 20251125221001_BhXqj UK00CE 2025-11-27T14:15:45.731Z 2025-12-04T15:07:44.120Z
8606170 8606170 20251125180907_La62n UK00CE 2025-11-27T14:09:15.526Z 2025-12-04T15:06:28.773Z
8601200 8601200 20251125033755_D3lfP UK00CE 2025-11-26T14:23:47.388Z 2025-12-02T15:09:05.559Z
8600302 8600302 20251125025217_22dgX UK00CE 2025-11-26T14:22:15.139Z 2025-12-02T15:08:40.788Z
8600236 8600236 20251125024919_ho0nD UK00CE 2025-11-26T14:22:10.190Z 2025-12-02T15:08:40.118Z
8600192 8600192 20251125024728_0fOYn UK00CE 2025-11-26T14:22:07.824Z 2025-12-02T15:08:39.778Z
8600138 8600138 20251125024546_kUESw UK00CE 2025-11-26T14:22:04.241Z 2025-12-02T15:08:34.767Z
8600113 8600113 20251125024402_1D535 UK00CE 2025-11-26T14:22:02.935Z 2025-12-02T15:08:34.619Z
8599982 8599982 20251125023446_LDLc8 UK00CE 2025-11-26T14:21:54.411Z 2025-12-02T15:08:33.286Z
8599682 8599682 20251125021804_UCgcc UK00CE 2025-11-26T14:21:23.886Z 2025-12-02T15:08:30.934Z
8599469 8599469 20251125020651_O0zjo UK00CE 2025-11-26T14:20:57.557Z 2025-12-02T15:08:24.516Z
8598958 8598958 20251125013730_43gGJ UK00CE 2025-11-26T14:20:06.552Z 2025-12-02T15:08:15.064Z
8598867 8598867 20251125013143_jxOf5 UK00CE 2025-11-26T14:20:00.335Z 2025-12-02T15:08:09.947Z
8598820 8598820 20251125012901_MaQKr UK00CE 2025-11-26T14:19:55.766Z 2025-12-02T15:08:09.495Z
8598805 8598805 20251125012451_b0EC9 UK00CE 2025-11-26T14:19:54.198Z 2025-12-02T15:08:09.386Z
8598482 8598482 20251125010033_78emm UK00CE 2025-11-26T14:19:10.968Z 2025-12-02T15:07:55.355Z
8598140 8598140 20251125003709_WMvdR UK00CE 2025-11-26T14:18:21.121Z 2025-12-02T15:07:46.914Z
8597918 8597918 20251125001913_3mCXV UK00CE 2025-11-26T14:17:53.267Z 2025-12-02T15:07:43.477Z
8597716 8597716 20251125000334_Ptj7F UK00CE 2025-11-26T14:17:25.920Z 2025-12-02T15:07:40.133Z
8597280 8597280 20251124231915_f1u6T UK00CE 2025-11-26T14:16:28.565Z 2025-12-02T15:07:27.893Z
8597211 8597211 20251124231418_amqif UK00CE 2025-11-26T14:16:22.066Z 2025-12-02T15:07:24.309Z
8591505 8591505 20251124042028_2yYT4 UK00CE 2025-11-25T14:24:26.838Z 2025-12-02T15:12:58.971Z
8591468 8591468 20251124041713_UvP9z UK00CE 2025-11-25T14:24:24.060Z 2025-12-02T15:12:58.766Z
8591114 8591114 20251124034729_3s297 UK00CE 2025-11-25T14:23:37.647Z 2025-12-02T15:12:57.129Z
8591067 8591067 20251124034051_9PMp6 UK00CE 2025-11-25T14:23:33.135Z 2025-12-02T15:12:56.869Z
8590381 8590381 20251124023847_V655X UK00CE 2025-11-25T14:21:46.222Z 2025-12-02T15:12:47.212Z
8589532 8589532 20251124013816_J4Uku UK00CE 2025-11-25T14:20:09.534Z 2025-12-02T15:12:32.107Z
8589078 8589078 20251124005958_uVKwP UK00CE 2025-11-25T14:18:58.393Z 2025-12-02T15:12:04.601Z
8588938 8588938 20251124004616_jr6Wg UK00CE 2025-11-25T14:18:47.323Z 2025-12-02T15:12:01.810Z
8588442 8588442 20251123235651_BF0CO UK00CE 2025-11-25T14:17:33.799Z 2025-12-02T15:11:42.045Z
8579994 8579994 20251123021239_CNZb3 UK00CE 2025-11-24T14:15:47.317Z 2025-12-01T15:21:31.150Z
8559964 8559964 20251121043230_NDkR1 UK00CE 2025-11-22T14:42:07.814Z 2025-11-29T14:54:44.813Z
8559687 8559687 20251121042246_saxxP UK00CE 2025-11-22T14:42:01.733Z 2025-11-29T14:54:43.244Z
8559654 8559654 20251121042029_kJqUo UK00CE 2025-11-22T14:42:00.738Z 2025-11-29T14:54:43.163Z
8559504 8559504 20251121041314_A2Nvo UK00CE 2025-11-22T14:41:56.962Z 2025-11-29T14:54:39.181Z
8559137 8559137 20251121035517_L3wSJ UK00CE 2025-11-22T14:41:48.504Z 2025-11-29T14:54:37.306Z
8558567 8558567 20251121033315_Q7tzK UK00CE 2025-11-22T14:41:07.964Z 2025-11-29T14:54:36.292Z
8556996 8556996 20251121022655_oTCZ9 UK00CE 2025-11-22T14:39:48.738Z 2025-11-29T14:54:33.313Z
8556982 8556982 20251121022635_oMia3 UK00CE 2025-11-22T14:39:48.642Z 2025-11-29T14:54:33.309Z
8556661 8556661 20251121020502_3EKyN UK00CE 2025-11-22T14:39:39.273Z 2025-11-29T14:54:32.704Z
8554798 8554798 20251121003901_zDFDV UK00CE 2025-11-22T14:37:20.498Z 2025-11-29T14:54:28.893Z
8553152 8553152 20251120050608_DDBmg UK00CE 2025-11-22T14:33:24.867Z 2025-11-28T14:57:50.335Z
8553009 8553009 20251120044924_334Vv UK00CE 2025-11-22T14:33:16.602Z 2025-11-28T14:57:48.169Z
8552489 8552489 20251120041120_uxKMv UK00CE 2025-11-22T14:32:25.700Z 2025-11-28T14:57:32.543Z
8552203 8552203 20251120034810_1H0KO UK00CE 2025-11-22T14:31:58.378Z 2025-11-28T14:57:26.434Z
8552098 8552098 20251120033709_p3y7g UK00CE 2025-11-22T14:31:47.984Z 2025-11-28T14:57:25.526Z
8552095 8552095 20251120033701_8tNg6 UK00CE 2025-11-22T14:31:47.541Z 2025-11-28T14:57:25.506Z
8551985 8551985 20251120032600_vD9ga UK00CE 2025-11-22T14:31:40.847Z 2025-11-28T14:57:19.434Z
8551129 8551129 20251121002346_e3s1L UK00CE 2025-11-22T14:22:03.692Z 2025-11-22T14:22:03.692Z
8550947 8550947 20251121001300_QQb32 UK00CE 2025-11-22T14:21:51.211Z 2025-11-22T14:21:51.211Z
8550549 8550549 20251120235154_KotMp UK00CE 2025-11-22T14:21:13.047Z 2025-11-29T14:54:27.110Z
8550428 8550428 20251120234155_bu6tj UK00CE 2025-11-22T14:20:54.188Z 2025-11-29T14:54:26.879Z
8550394 8550394 20251120234041_BSTzm UK00CE 2025-11-22T14:20:52.214Z 2025-11-29T14:54:26.835Z
8549895 8549895 20251120230155_NqMiJ UK00CE 2025-11-22T14:19:44.942Z 2025-11-29T14:54:25.786Z
8548296 8548296 20251120204802_3WxW5 UK00CE 2025-11-22T14:16:42.892Z 2025-11-29T14:54:22.319Z
8548122 8548122 20251120203758_HJN0D UK00CE 2025-11-22T14:16:20.017Z 2025-11-29T14:54:22.018Z
8547767 8547767 20251120201128_O2Xc4 UK00CE 2025-11-22T14:15:41.046Z 2025-11-29T14:54:20.936Z
8547299 8547299 20251120193938_uLzT7 UK00CE 2025-11-22T14:14:48.642Z 2025-11-29T14:54:19.320Z
8547250 8547250 20251120193442_qK0uP UK00CE 2025-11-22T14:14:38.712Z 2025-11-29T14:54:19.076Z
8547069 8547069 20251120191918_pRZnr UK00CE 2025-11-22T14:14:15.167Z 2025-11-29T14:54:18.515Z
8546989 8546989 20251120191548_8Q1l8 UK00CE 2025-11-22T14:13:59.454Z 2025-11-29T14:54:18.259Z
8541387 8541387 20251120021526_bIQlQ UK00CE 2025-11-21T14:37:15.256Z 2025-11-28T14:56:46.440Z
8541329 8541329 20251120021422_sqSmM UK00CE 2025-11-21T14:37:13.967Z 2025-11-28T14:56:45.898Z
8540914 8540914 20251120014222_5YdTf UK00CE 2025-11-21T14:37:01.920Z 2025-11-28T14:56:27.738Z
8540567 8540567 20251120011347_xJWoM UK00CE 2025-11-21T14:36:07.590Z 2025-11-28T14:56:15.721Z
8540463 8540463 20251120010446_ZfHIb UK00CE 2025-11-21T14:36:02.438Z 2025-11-28T14:56:12.160Z
8540385 8540385 20251120005717_01b7y UK00CE 2025-11-21T14:36:00.527Z 2025-11-28T14:56:11.347Z
8540351 8540351 20251120005358_CnKG4 UK00CE 2025-11-21T14:35:58.778Z 2025-11-28T14:56:10.416Z
8540259 8540259 20251120004728_F3Wnm UK00CE 2025-11-21T14:35:56.392Z 2025-11-28T14:56:09.359Z

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