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

>10,000 rows count all where station_code = "UK002F" 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
9273163 9273163 20260128050159_6Lo1V UK002F 2026-01-29T14:28:53.861Z 2026-01-29T14:30:25.762Z
9273119 9273119 20260128044827_K6YC0 UK002F 2026-01-29T14:28:47.440Z 2026-01-29T14:30:25.754Z
9273107 9273107 20260128044518_PeI8V UK002F 2026-01-29T14:28:46.079Z 2026-01-29T14:30:25.752Z
9272920 9272920 20260128040221_isBvr UK002F 2026-01-29T14:28:15.245Z 2026-01-29T14:30:25.708Z
9272861 9272861 20260128035401_sM26T UK002F 2026-01-29T14:28:04.592Z 2026-01-29T14:30:25.700Z
9272733 9272733 20260128031328_n2F6y UK002F 2026-01-29T14:27:39.348Z 2026-01-29T14:30:25.444Z
9272673 9272673 20260128030051_2Ey2F UK002F 2026-01-29T14:27:27.840Z 2026-01-29T14:30:25.437Z
9272637 9272637 20260128025145_xOK50 UK002F 2026-01-29T14:27:16.953Z 2026-01-29T14:30:25.404Z
9272614 9272614 20260128024909_Af6ae UK002F 2026-01-29T14:27:14.824Z 2026-01-29T14:30:25.383Z
9272558 9272558 20260128023651_kyrCs UK002F 2026-01-29T14:27:10.560Z 2026-01-29T14:30:25.378Z
9272513 9272513 20260128022243_E4M0G UK002F 2026-01-29T14:27:02.841Z 2026-01-29T14:30:25.369Z
9272456 9272456 20260128021100_Df6GL UK002F 2026-01-29T14:26:47.746Z 2026-01-29T14:30:25.350Z
9272371 9272371 20260128014920_nQsCb UK002F 2026-01-29T14:26:32.854Z 2026-01-29T14:30:25.338Z
9271946 9271946 20260127221520_IKNGN UK002F 2026-01-29T14:25:01.595Z 2026-01-29T14:30:25.234Z
9271865 9271865 20260127211707_DsgGa UK002F 2026-01-29T14:24:39.859Z 2026-01-29T14:30:25.216Z
9255330 9255330 20260124025526_wZf4C UK002F 2026-01-25T14:12:56.421Z 2026-01-29T14:47:23.956Z
9255319 9255319 20260124024830_x8J09 UK002F 2026-01-25T14:12:53.946Z 2026-01-29T14:47:23.347Z
9254408 9254408 20260123190116_nLTCx UK002F 2026-01-25T14:09:02.141Z 2026-01-29T14:46:14.431Z
9254393 9254393 20260123185300_qgv2r UK002F 2026-01-25T14:08:58.698Z 2026-01-29T14:46:13.820Z
9252653 9252653 20260123045959_gPc4T UK002F 2026-01-24T14:16:33.763Z 2026-01-29T14:53:13.692Z
9252292 9252292 20260123020549_SN2mF UK002F 2026-01-24T14:14:58.660Z 2026-01-29T14:52:44.007Z
9252208 9252208 20260123014605_WnA3A UK002F 2026-01-24T14:14:44.996Z 2026-01-29T14:52:39.838Z
9252079 9252079 20260123005351_L1K9S UK002F 2026-01-24T14:14:18.588Z 2026-01-29T14:52:27.504Z
9251930 9251930 20260123000149_KNX93 UK002F 2026-01-24T14:13:45.334Z 2026-01-29T14:52:17.504Z
9251791 9251791 20260122225657_vuPFg UK002F 2026-01-24T14:13:14.931Z 2026-01-29T14:52:10.307Z
9244025 9244025 20260121055647_hNzwS UK002F 2026-01-22T14:23:58.258Z 2026-01-29T15:05:49.027Z
9243669 9243669 20260121050404_MPh3p UK002F 2026-01-22T14:22:42.862Z 2026-01-29T15:05:22.753Z
9243644 9243644 20260121045924_a6yvj UK002F 2026-01-22T14:22:38.329Z 2026-01-29T15:05:21.468Z
9243558 9243558 20260121044809_GYHe6 UK002F 2026-01-22T14:22:13.031Z 2026-01-29T15:05:18.058Z
9243367 9243367 20260121042306_jlCpP UK002F 2026-01-22T14:21:33.168Z 2026-01-29T15:04:57.282Z
9243222 9243222 20260121040045_M9eBq UK002F 2026-01-22T14:20:59.447Z 2026-01-29T15:04:51.443Z
9243217 9243217 20260121040033_ftUZ7 UK002F 2026-01-22T14:20:59.001Z 2026-01-29T15:04:51.393Z
9236023 9236023 20260120022837_E70O7 UK002F 2026-01-21T14:21:16.317Z 2026-01-28T14:59:37.703Z
9235036 9235036 20260120001646_FQIMM UK002F 2026-01-21T14:17:14.796Z 2026-01-28T14:58:26.097Z
9222840 9222840 20260117210319_IJ1FH UK002F 2026-01-19T14:16:28.154Z 2026-01-26T15:01:22.937Z
9217611 9217611 20260116183129_rWnfN UK002F 2026-01-18T14:08:11.426Z 2026-01-25T14:57:28.080Z
9217592 9217592 20260116181641_hhYGg UK002F 2026-01-18T14:08:06.678Z 2026-01-25T14:57:27.407Z
9216332 9216332 20260114040250_qA3RQ UK002F 2026-01-17T14:44:55.643Z 2026-01-22T15:09:25.733Z
9212907 9212907 20260116013707_zYTNb UK002F 2026-01-17T14:14:30.962Z 2026-01-24T15:11:33.642Z
9212888 9212888 20260116013453_79sV0 UK002F 2026-01-17T14:14:26.179Z 2026-01-24T15:11:32.579Z
9212840 9212840 20260116012051_Iz1R2 UK002F 2026-01-17T14:14:13.822Z 2026-01-24T15:11:29.293Z
9212632 9212632 20260115234951_0CbzI UK002F 2026-01-17T14:13:02.334Z 2026-01-24T15:11:07.914Z
9207341 9207341 20260115010534_5o2GA UK002F 2026-01-16T14:08:20.851Z 2026-01-22T15:03:19.340Z
9207228 9207228 20260115000234_nDRMF UK002F 2026-01-16T14:07:48.450Z 2026-01-22T15:03:15.221Z
9204433 9204433 20260114064357_2U5zM UK002F 2026-01-15T14:27:23.238Z 2026-01-22T15:10:28.328Z
9204371 9204371 20260114063432_jOntL UK002F 2026-01-15T14:27:11.040Z 2026-01-22T15:10:26.670Z
9204358 9204358 20260114063012_sQYhw UK002F 2026-01-15T14:27:08.175Z 2026-01-22T15:10:25.378Z
9204328 9204328 20260114062801_oL1H9 UK002F 2026-01-15T14:27:04.336Z 2026-01-22T15:10:24.983Z
9204307 9204307 20260114062557_0wd6j UK002F 2026-01-15T14:27:02.378Z 2026-01-22T15:10:24.698Z
9204284 9204284 20260114062514_nVxvP UK002F 2026-01-15T14:27:00.691Z 2026-01-22T15:10:24.499Z
9204215 9204215 20260114061616_qhG6f UK002F 2026-01-15T14:26:50.702Z 2026-01-22T15:10:22.516Z
9204159 9204159 20260114061100_v1xuN UK002F 2026-01-15T14:26:31.953Z 2026-01-22T15:10:21.261Z
9204020 9204020 20260114060337_Buh3O UK002F 2026-01-15T14:26:16.497Z 2026-01-22T15:10:17.029Z
9203988 9203988 20260114060230_y1zPY UK002F 2026-01-15T14:26:09.283Z 2026-01-22T15:10:16.646Z
9203695 9203695 20260114053051_jYNp7 UK002F 2026-01-15T14:25:13.099Z 2026-01-22T15:10:12.404Z
9203641 9203641 20260114052435_U6rp1 UK002F 2026-01-15T14:25:03.897Z 2026-01-22T15:10:11.287Z
9203591 9203591 20260114052118_JZLHU UK002F 2026-01-15T14:24:58.820Z 2026-01-22T15:10:10.599Z
9203561 9203561 20260114051759_AsHcX UK002F 2026-01-15T14:24:48.010Z 2026-01-22T15:10:09.975Z
9203527 9203527 20260114051537_JA22l UK002F 2026-01-15T14:24:44.485Z 2026-01-22T15:10:09.564Z
9203465 9203465 20260114050007_PrHJA UK002F 2026-01-15T14:24:30.205Z 2026-01-22T15:10:08.401Z
9203441 9203441 20260114045740_d5Aeq UK002F 2026-01-15T14:24:26.444Z 2026-01-22T15:10:07.841Z
9203424 9203424 20260114045622_G2HJf UK002F 2026-01-15T14:24:23.601Z 2026-01-22T15:10:07.414Z
9203300 9203300 20260114044939_ni9li UK002F 2026-01-15T14:24:01.335Z 2026-01-22T15:10:05.423Z
9203204 9203204 20260114044238_6gMFl UK002F 2026-01-15T14:23:40.042Z 2026-01-22T15:10:03.714Z
9203158 9203158 20260114043820_NvJD3 UK002F 2026-01-15T14:23:27.421Z 2026-01-22T15:10:02.779Z
9203129 9203129 20260114043642_Q6rA1 UK002F 2026-01-15T14:23:24.178Z 2026-01-22T15:10:02.350Z
9202990 9202990 20260114042411_zW7IG UK002F 2026-01-15T14:23:00.333Z 2026-01-22T15:10:00.450Z
9202769 9202769 20260114040800_3zk0J UK002F 2026-01-15T14:22:20.331Z 2026-01-22T15:09:40.834Z
9202653 9202653 20260114035846_BsIxg UK002F 2026-01-15T14:21:57.141Z 2026-01-22T15:09:24.382Z
9202580 9202580 20260114035209_DGaYN UK002F 2026-01-15T14:21:43.816Z 2026-01-22T15:09:23.358Z
9202510 9202510 20260114034411_JyVtx UK002F 2026-01-15T14:21:33.842Z 2026-01-22T15:09:21.603Z
9202411 9202411 20260114033619_uZ0Io UK002F 2026-01-15T14:21:14.289Z 2026-01-22T15:09:17.411Z
9202360 9202360 20260114033321_zy7ae UK002F 2026-01-15T14:21:08.758Z 2026-01-22T15:09:16.792Z
9202287 9202287 20260114032626_3IpLs UK002F 2026-01-15T14:20:53.844Z 2026-01-22T15:09:16.017Z
9202204 9202204 20260114032340_dQMSU UK002F 2026-01-15T14:20:42.436Z 2026-01-22T15:09:14.880Z
9202055 9202055 20260114031242_OUbY3 UK002F 2026-01-15T14:20:17.919Z 2026-01-22T15:09:12.508Z
9201925 9201925 20260114030716_huTcI UK002F 2026-01-15T14:20:08.985Z 2026-01-22T15:09:11.562Z
9201729 9201729 20260114024626_VXyh0 UK002F 2026-01-15T14:19:35.041Z 2026-01-22T15:09:08.416Z
9201611 9201611 20260114023530_mgvai UK002F 2026-01-15T14:19:10.799Z 2026-01-22T15:09:06.673Z
9201560 9201560 20260114023143_E2gE4 UK002F 2026-01-15T14:18:58.355Z 2026-01-22T15:09:06.125Z
9201541 9201541 20260114022849_XKCqq UK002F 2026-01-15T14:18:54.878Z 2026-01-22T15:09:05.683Z
9201449 9201449 20260114021828_qKoF4 UK002F 2026-01-15T14:18:41.266Z 2026-01-22T15:09:04.098Z
9201432 9201432 20260114021750_Z4DLx UK002F 2026-01-15T14:18:39.615Z 2026-01-22T15:09:03.904Z
9201342 9201342 20260114021131_Ba0W3 UK002F 2026-01-15T14:18:17.804Z 2026-01-22T15:09:02.140Z
9201307 9201307 20260114020641_sO0so UK002F 2026-01-15T14:18:12.694Z 2026-01-22T15:09:01.388Z
9201265 9201265 20260114020217_rJ3I6 UK002F 2026-01-15T14:18:06.587Z 2026-01-22T15:09:00.738Z
9201234 9201234 20260114015824_sD2AQ UK002F 2026-01-15T14:17:56.450Z 2026-01-22T15:09:00.214Z
9201202 9201202 20260114015350_y4ivK UK002F 2026-01-15T14:17:46.659Z 2026-01-22T15:08:59.447Z
9201139 9201139 20260114014844_2KlaO UK002F 2026-01-15T14:17:38.034Z 2026-01-22T15:08:58.402Z
9201032 9201032 20260114013512_Qk6EE UK002F 2026-01-15T14:17:16.423Z 2026-01-22T15:08:51.712Z
9201005 9201005 20260114012905_rGecj UK002F 2026-01-15T14:17:12.236Z 2026-01-22T15:08:47.746Z
9200992 9200992 20260114012854_EteLX UK002F 2026-01-15T14:17:10.182Z 2026-01-22T15:08:45.410Z
9200905 9200905 20260114011929_NWmKO UK002F 2026-01-15T14:16:50.456Z 2026-01-22T15:08:34.056Z
9200884 9200884 20260114011738_QIviF UK002F 2026-01-15T14:16:46.011Z 2026-01-22T15:08:32.893Z
9200834 9200834 20260114010844_7UTAQ UK002F 2026-01-15T14:16:38.073Z 2026-01-22T15:08:30.490Z
9200772 9200772 20260114010248_YJOf5 UK002F 2026-01-15T14:16:23.410Z 2026-01-22T15:08:25.470Z
9200674 9200674 20260114004859_kxVqo UK002F 2026-01-15T14:16:05.325Z 2026-01-22T15:08:23.224Z
9200667 9200667 20260114004654_77F2m UK002F 2026-01-15T14:16:04.137Z 2026-01-22T15:08:23.107Z
9200656 9200656 20260114004554_IFLBd UK002F 2026-01-15T14:15:57.323Z 2026-01-22T15:08:22.852Z
9200617 9200617 20260114003633_7CCmT UK002F 2026-01-15T14:15:47.653Z 2026-01-22T15:08:22.015Z

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