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

7,817 rows where station_code = "UK007Z" 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
9831527 9831527 20260501014021_9IubH UK007Z 2026-05-02T12:07:10.919Z 2026-05-02T12:13:44.062Z
9830821 9830821 20260430235958_Msg70 UK007Z 2026-05-02T12:05:11.126Z 2026-05-02T12:13:43.842Z
9830543 9830543 20260430225958_rxnUu UK007Z 2026-05-02T12:04:20.616Z 2026-05-02T12:13:43.744Z
9830407 9830407 20260430223348_wZx13 UK007Z 2026-05-02T12:03:53.975Z 2026-05-02T12:13:43.698Z
9826652 9826652 20260430020850_UVnQb UK007Z 2026-05-01T12:12:06.585Z 2026-05-02T12:19:13.873Z
9826450 9826450 20260430015413_mQcPw UK007Z 2026-05-01T12:11:31.303Z 2026-05-02T12:18:55.653Z
9826258 9826258 20260430013224_EH1Vd UK007Z 2026-05-01T12:10:54.777Z 2026-05-02T12:18:41.784Z
9825944 9825944 20260430005500_glLFy UK007Z 2026-05-01T12:09:50.178Z 2026-05-02T12:18:08.781Z
9825798 9825798 20260430003947_DCOtn UK007Z 2026-05-01T12:09:27.293Z 2026-05-02T12:17:59.273Z
9825589 9825589 20260430000607_2sAul UK007Z 2026-05-01T12:08:39.531Z 2026-05-02T12:17:38.417Z
9820388 9820388 20260429005817_2Fqcq UK007Z 2026-04-30T12:14:50.878Z 2026-05-02T12:27:55.277Z
9820369 9820369 20260429005507_BE3lw UK007Z 2026-04-30T12:14:47.889Z 2026-05-02T12:27:53.796Z
9820242 9820242 20260429004206_9oI2t UK007Z 2026-04-30T12:14:20.846Z 2026-05-02T12:27:44.371Z
9819733 9819733 20260428232209_nVpQf UK007Z 2026-04-30T12:12:39.495Z 2026-05-02T12:27:02.163Z
9787455 9787455 20260425023718_J3lZq UK007Z 2026-04-26T12:22:33.793Z 2026-05-02T13:02:23.055Z
9786680 9786680 20260425014842_w4dQp UK007Z 2026-04-26T12:21:15.733Z 2026-05-02T13:01:46.420Z
9785374 9785374 20260425001942_2QspW UK007Z 2026-04-26T12:18:51.890Z 2026-05-02T13:00:44.485Z
9784084 9784084 20260424221833_kidPR UK007Z 2026-04-26T12:16:08.732Z 2026-05-02T12:59:51.446Z
9784011 9784011 20260424220938_9uv1N UK007Z 2026-04-26T12:16:02.760Z 2026-05-02T12:59:42.052Z
9768083 9768083 20260424011422_8PZa3 UK007Z 2026-04-25T12:26:24.275Z 2026-05-02T13:10:52.502Z
9768075 9768075 20260424011353_PTm37 UK007Z 2026-04-25T12:26:22.875Z 2026-05-02T13:10:52.334Z
9766308 9766308 20260423233539_6t6XS UK007Z 2026-04-25T12:21:37.978Z 2026-05-02T13:09:16.320Z
9757596 9757596 20260423030427_6t3Tf UK007Z 2026-04-24T12:07:16.198Z 2026-04-30T13:12:32.588Z
9757445 9757445 20260423025716_naFN6 UK007Z 2026-04-24T12:07:14.872Z 2026-04-30T13:12:31.057Z
9756679 9756679 20260423022807_2vK4N UK007Z 2026-04-24T12:07:05.257Z 2026-04-30T13:11:43.635Z
9756448 9756448 20260423022104_dvs1e UK007Z 2026-04-24T12:07:02.127Z 2026-04-30T13:11:30.040Z
9756357 9756357 20260423021729_71C77 UK007Z 2026-04-24T12:06:56.543Z 2026-04-30T13:11:29.175Z
9756123 9756123 20260423021004_xEQhQ UK007Z 2026-04-24T12:06:46.402Z 2026-04-30T13:11:27.052Z
9755923 9755923 20260423020437_pgkNF UK007Z 2026-04-24T12:06:42.780Z 2026-04-30T13:11:25.394Z
9755360 9755360 20260423015006_iT7hW UK007Z 2026-04-24T12:06:34.007Z 2026-04-30T13:11:13.352Z
9755162 9755162 20260423014636_iOi8d UK007Z 2026-04-24T12:06:31.351Z 2026-04-30T13:11:11.964Z
9753668 9753668 20260423010415_VhRHK UK007Z 2026-04-24T12:05:54.726Z 2026-04-30T13:10:36.054Z
9753586 9753586 20260423010230_W3B2d UK007Z 2026-04-24T12:05:53.104Z 2026-04-30T13:10:26.895Z
9753100 9753100 20260423004642_vrqyQ UK007Z 2026-04-24T12:05:36.513Z 2026-04-30T13:10:20.396Z
9752682 9752682 20260423003111_i04d3 UK007Z 2026-04-24T12:05:18.803Z 2026-04-30T13:10:16.325Z
9752395 9752395 20260423002216_uPJGf UK007Z 2026-04-24T12:05:12.736Z 2026-04-30T13:10:13.836Z
9751581 9751581 20260422235343_Tq6wX UK007Z 2026-04-24T12:04:55.781Z 2026-04-30T13:09:21.200Z
9751379 9751379 20260422234719_SvP5T UK007Z 2026-04-24T12:04:44.054Z 2026-04-30T13:09:18.059Z
9751304 9751304 20260422234444_WbWl2 UK007Z 2026-04-24T12:04:42.879Z 2026-04-30T13:09:17.422Z
9751233 9751233 20260422234220_2Xs3b UK007Z 2026-04-24T12:04:41.260Z 2026-04-30T13:09:16.687Z
9750988 9750988 20260422233413_iBFQK UK007Z 2026-04-24T12:04:35.527Z 2026-04-30T13:09:12.523Z
9750980 9750980 20260422233408_mlGoF UK007Z 2026-04-24T12:04:35.349Z 2026-04-30T13:09:12.473Z
9750799 9750799 20260422232527_TUlk5 UK007Z 2026-04-24T12:04:31.275Z 2026-04-30T13:09:10.936Z
9749149 9749149 20260422220130_ikJkO UK007Z 2026-04-24T12:03:46.577Z 2026-04-30T13:08:17.067Z
9749138 9749138 20260422220059_iwSQI UK007Z 2026-04-24T12:03:46.362Z 2026-04-30T13:08:16.905Z
9748735 9748735 20260422213401_2ptJK UK007Z 2026-04-24T12:03:30.169Z 2026-04-30T13:07:59.167Z
9720793 9720793 20260420031717_tPixc UK007Z 2026-04-21T12:28:43.230Z 2026-04-28T13:39:24.430Z
9720515 9720515 20260420025843_rYuRc UK007Z 2026-04-21T12:28:08.063Z 2026-04-28T13:39:21.411Z
9720279 9720279 20260420023455_sVQ1t UK007Z 2026-04-21T12:27:32.296Z 2026-04-28T13:39:17.793Z
9718397 9718397 20260419233436_OaX8o UK007Z 2026-04-21T12:22:27.545Z 2026-04-28T13:37:33.224Z
9717727 9717727 20260419222203_kE1Uo UK007Z 2026-04-21T12:20:39.443Z 2026-04-28T13:37:14.119Z
9717685 9717685 20260419221643_EnFsn UK007Z 2026-04-21T12:20:32.846Z 2026-04-28T13:37:13.663Z
9717327 9717327 20260419213348_BC3dt UK007Z 2026-04-21T12:19:25.833Z 2026-04-28T13:37:07.721Z
9711410 9711410 20260419030729_7b0LY UK007Z 2026-04-20T12:25:04.692Z 2026-04-27T13:49:43.810Z
9710966 9710966 20260419024158_dr0jq UK007Z 2026-04-20T12:24:12.395Z 2026-04-27T13:49:27.603Z
9710876 9710876 20260419023444_AiOY2 UK007Z 2026-04-20T12:23:51.829Z 2026-04-27T13:49:22.802Z
9710838 9710838 20260419023049_uOT5c UK007Z 2026-04-20T12:23:43.823Z 2026-04-27T13:49:21.589Z
9710293 9710293 20260419015144_FLjmO UK007Z 2026-04-20T12:22:24.140Z 2026-04-27T13:48:52.147Z
9709882 9709882 20260419012603_lt1uK UK007Z 2026-04-20T12:21:21.432Z 2026-04-27T13:48:24.750Z
9709215 9709215 20260419003638_60WvC UK007Z 2026-04-20T12:19:25.675Z 2026-04-27T13:47:52.171Z
9708879 9708879 20260419001026_BcTAx UK007Z 2026-04-20T12:18:21.190Z 2026-04-27T13:47:31.115Z
9708667 9708667 20260418235510_sHCVq UK007Z 2026-04-20T12:17:37.232Z 2026-04-27T13:47:23.841Z
9708361 9708361 20260418232639_0lElz UK007Z 2026-04-20T12:16:46.402Z 2026-04-27T13:47:16.256Z
9708204 9708204 20260418230748_DHgDL UK007Z 2026-04-20T12:16:15.724Z 2026-04-27T13:46:55.994Z
9708026 9708026 20260418224523_7XHBw UK007Z 2026-04-20T12:15:36.872Z 2026-04-27T13:46:48.223Z
9707624 9707624 20260418221346_AOKX2 UK007Z 2026-04-20T12:14:23.837Z 2026-04-27T13:46:38.181Z
9707523 9707523 20260418220110_BKNI6 UK007Z 2026-04-20T12:14:12.088Z 2026-04-27T13:46:35.604Z
9707424 9707424 20260418214902_jvko5 UK007Z 2026-04-20T12:13:52.612Z 2026-04-27T13:46:20.088Z
9707190 9707190 20260418211151_nQ3tD UK007Z 2026-04-20T12:13:10.068Z 2026-04-27T13:46:11.280Z
9707163 9707163 20260418210930_nHThA UK007Z 2026-04-20T12:13:06.496Z 2026-04-27T13:46:10.624Z
9702552 9702552 20260418023210_6zw06 UK007Z 2026-04-19T12:24:00.094Z 2026-04-26T13:11:36.948Z
9702548 9702548 20260418023045_1Duk1 UK007Z 2026-04-19T12:23:59.767Z 2026-04-26T13:11:36.704Z
9702503 9702503 20260418022728_eYVWu UK007Z 2026-04-19T12:23:53.930Z 2026-04-26T13:11:35.124Z
9702313 9702313 20260418020504_PA2iS UK007Z 2026-04-19T12:23:08.910Z 2026-04-26T13:11:26.875Z
9702225 9702225 20260418015530_Pt6O2 UK007Z 2026-04-19T12:22:51.807Z 2026-04-26T13:11:24.089Z
9701216 9701216 20260418000539_TIcAH UK007Z 2026-04-19T12:19:25.380Z 2026-04-26T13:10:49.239Z
9701018 9701018 20260417234515_YLET2 UK007Z 2026-04-19T12:18:37.844Z 2026-04-26T13:10:39.191Z
9700706 9700706 20260417225734_IKx2k UK007Z 2026-04-19T12:17:17.061Z 2026-04-26T13:10:35.994Z
9700389 9700389 20260417221409_FHWVr UK007Z 2026-04-19T12:16:00.828Z 2026-04-26T13:10:33.842Z
9700336 9700336 20260417220230_vSSb2 UK007Z 2026-04-19T12:15:43.933Z 2026-04-26T13:10:33.504Z
9675154 9675154 20260414034803_YGRfs UK007Z 2026-04-15T12:32:41.370Z 2026-04-22T13:16:15.306Z
9674942 9674942 20260414031812_s2gpx UK007Z 2026-04-15T12:32:25.526Z 2026-04-22T13:16:12.724Z
9674902 9674902 20260414031538_M1j7w UK007Z 2026-04-15T12:32:10.977Z 2026-04-22T13:16:12.532Z
9674584 9674584 20260414024305_hcQXu UK007Z 2026-04-15T12:31:47.255Z 2026-04-22T13:16:08.471Z
9674580 9674580 20260414024303_mJSbL UK007Z 2026-04-15T12:31:46.487Z 2026-04-22T13:16:08.437Z
9674555 9674555 20260414024013_CnaMN UK007Z 2026-04-15T12:31:32.650Z 2026-04-22T13:16:08.082Z
9674321 9674321 20260414021452_tairA UK007Z 2026-04-15T12:31:11.578Z 2026-04-22T13:16:05.028Z
9674169 9674169 20260414015246_0Tn4T UK007Z 2026-04-15T12:30:42.196Z 2026-04-22T13:16:03.212Z
9673855 9673855 20260414012706_r4ouv UK007Z 2026-04-15T12:30:11.472Z 2026-04-22T13:15:42.725Z
9673598 9673598 20260414010939_c7i48 UK007Z 2026-04-15T12:29:52.710Z 2026-04-22T13:15:20.665Z
9672233 9672233 20260413222644_qYW26 UK007Z 2026-04-15T12:27:00.414Z 2026-04-22T13:15:02.144Z
9665763 9665763 20260413032545_2fTjS UK007Z 2026-04-14T12:29:33.014Z 2026-04-21T13:18:19.085Z
9665630 9665630 20260413030349_Go2nr UK007Z 2026-04-14T12:29:12.029Z 2026-04-21T13:18:17.814Z
9665149 9665149 20260413020454_Q3WyI UK007Z 2026-04-14T12:28:21.848Z 2026-04-21T13:18:13.021Z
9664740 9664740 20260413012355_AcLui UK007Z 2026-04-14T12:27:29.192Z 2026-04-21T13:18:09.426Z
9664694 9664694 20260413011731_JrV8S UK007Z 2026-04-14T12:27:25.941Z 2026-04-21T13:18:08.889Z
9664417 9664417 20260413001808_P6zxr UK007Z 2026-04-14T12:26:48.202Z 2026-04-21T13:17:49.970Z
9664289 9664289 20260413000139_BdzoO UK007Z 2026-04-14T12:26:38.503Z 2026-04-21T13:17:48.583Z
9664156 9664156 20260412234642_e5Hte UK007Z 2026-04-14T12:26:16.332Z 2026-04-21T13:17:47.397Z
9664115 9664115 20260412233400_5YZTk UK007Z 2026-04-14T12:26:10.909Z 2026-04-21T13:17:46.754Z

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