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

2,665 rows where station_code = "UK00D7" 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
9258898 9258898 20260124175313_BtvDK UK00D7 2026-01-26T14:14:56.133Z 2026-01-29T14:42:17.460Z
9256260 9256260 20260124063032_E28Mw UK00D7 2026-01-25T14:16:19.416Z 2026-01-29T14:48:32.874Z
9256179 9256179 20260124060620_s8L4z UK00D7 2026-01-25T14:16:06.475Z 2026-01-29T14:48:27.133Z
9256136 9256136 20260124060213_SR6bT UK00D7 2026-01-25T14:16:00.797Z 2026-01-29T14:48:25.075Z
9256016 9256016 20260124054236_xhwhE UK00D7 2026-01-25T14:15:33.931Z 2026-01-29T14:48:18.402Z
9255466 9255466 20260124034238_exuot UK00D7 2026-01-25T14:13:32.775Z 2026-01-29T14:47:32.363Z
9255245 9255245 20260124021010_Q7mFs UK00D7 2026-01-25T14:12:30.568Z 2026-01-29T14:47:11.985Z
9255072 9255072 20260124003933_mULw4 UK00D7 2026-01-25T14:11:46.472Z 2026-01-29T14:47:01.169Z
9255066 9255066 20260124003730_fvqu6 UK00D7 2026-01-25T14:11:45.525Z 2026-01-29T14:47:01.022Z
9255039 9255039 20260124002827_TWGF5 UK00D7 2026-01-25T14:11:42.590Z 2026-01-29T14:47:00.288Z
9255022 9255022 20260124002237_YcetE UK00D7 2026-01-25T14:11:38.963Z 2026-01-29T14:46:59.818Z
9254984 9254984 20260123235544_sAF2R UK00D7 2026-01-25T14:11:31.530Z 2026-01-29T14:46:58.268Z
9254814 9254814 20260123213546_23Q6x UK00D7 2026-01-25T14:10:49.496Z 2026-01-29T14:46:43.620Z
9254663 9254663 20260123204123_m9pAh UK00D7 2026-01-25T14:10:17.711Z 2026-01-29T14:46:34.674Z
9254411 9254411 20260123190116_nLTCx UK00D7 2026-01-25T14:09:02.180Z 2026-01-29T14:46:14.431Z
9225986 9225986 20260115014255_CmyxN UK00D7 2026-01-19T14:48:21.892Z 2026-01-22T15:03:22.196Z
9225984 9225984 20260115013619_X6ElH UK00D7 2026-01-19T14:48:20.497Z 2026-01-22T15:03:21.737Z
9216340 9216340 20260114053051_Qp2li UK00D7 2026-01-17T14:46:11.123Z 2026-01-22T15:10:12.446Z
9216335 9216335 20260114052436_inGc6 UK00D7 2026-01-17T14:46:05.076Z 2026-01-22T15:10:11.320Z
9216333 9216333 20260114040250_qA3RQ UK00D7 2026-01-17T14:44:55.643Z 2026-01-22T15:09:25.733Z
9213498 9213498 20260116034704_YhsxW UK00D7 2026-01-17T14:17:10.542Z 2026-01-24T15:12:18.110Z
9213484 9213484 20260116034645_lwVk5 UK00D7 2026-01-17T14:17:08.859Z 2026-01-24T15:12:17.462Z
9213388 9213388 20260116031908_abTmb UK00D7 2026-01-17T14:16:42.060Z 2026-01-24T15:12:11.534Z
9213300 9213300 20260116030552_I6dKt UK00D7 2026-01-17T14:16:20.551Z 2026-01-24T15:12:08.073Z
9213201 9213201 20260116023316_LLqNI UK00D7 2026-01-17T14:15:52.304Z 2026-01-24T15:11:48.668Z
9213019 9213019 20260116015448_AVAA6 UK00D7 2026-01-17T14:15:00.670Z 2026-01-24T15:11:37.481Z
9195570 9195570 20260113014628_lDPDd UK00D7 2026-01-14T14:13:49.560Z 2026-01-21T15:04:42.329Z
9195043 9195043 20260113000554_oZoTV UK00D7 2026-01-14T14:11:47.794Z 2026-01-21T15:04:35.453Z
9194968 9194968 20260112234913_OQ4n6 UK00D7 2026-01-14T14:11:32.362Z 2026-01-21T15:04:34.472Z
9194928 9194928 20260112233533_dbyP3 UK00D7 2026-01-14T14:11:21.621Z 2026-01-21T15:04:34.130Z
9194695 9194695 20260112220408_2pfHY UK00D7 2026-01-14T14:10:19.817Z 2026-01-21T15:04:20.142Z
9194578 9194578 20260112212739_UejCo UK00D7 2026-01-14T14:09:53.009Z 2026-01-21T15:04:18.977Z
9194551 9194551 20260112212302_OMgpX UK00D7 2026-01-14T14:09:41.669Z 2026-01-21T15:04:18.541Z
9170375 9170375 20260105230858_qW7sG UK00D7 2026-01-09T14:22:16.781Z 2026-01-13T15:07:28.735Z
9170371 9170371 20260105202553_960eZ UK00D7 2026-01-09T14:21:51.081Z 2026-01-13T15:06:58.231Z
9166857 9166857 20260107204510_fQJgH UK00D7 2026-01-09T14:05:12.363Z 2026-01-16T15:10:26.887Z
9157275 9157275 20260102060450_YU5WW UK00D7 2026-01-06T14:50:14.981Z 2026-01-09T14:50:21.185Z
9157273 9157273 20260102055318_zdeFP UK00D7 2026-01-06T14:50:10.848Z 2026-01-09T14:50:18.343Z
9157271 9157271 20260102000310_Bd9ro UK00D7 2026-01-06T14:48:40.392Z 2026-01-09T14:48:57.466Z
9157265 9157265 20260101225916_thBrg UK00D7 2026-01-06T14:48:32.876Z 2026-01-09T14:48:51.730Z
9156061 9156061 20260104064008_V2vpN UK00D7 2026-01-06T14:38:29.006Z 2026-01-12T15:11:36.073Z
9156042 9156042 20260104063849_ZbPu6 UK00D7 2026-01-06T14:38:26.194Z 2026-01-12T15:11:35.162Z
9156009 9156009 20260104063605_HYeOx UK00D7 2026-01-06T14:38:25.086Z 2026-01-12T15:11:34.457Z
9155892 9155892 20260104062852_mQr24 UK00D7 2026-01-06T14:38:09.816Z 2026-01-12T15:11:31.357Z
9155874 9155874 20260104062808_h0c5o UK00D7 2026-01-06T14:38:08.949Z 2026-01-12T15:11:31.014Z
9155862 9155862 20260104062648_1vlIk UK00D7 2026-01-06T14:38:06.522Z 2026-01-12T15:11:30.277Z
9155813 9155813 20260104062350_V8fC3 UK00D7 2026-01-06T14:38:02.692Z 2026-01-12T15:11:28.513Z
9155804 9155804 20260104062318_vhJ7U UK00D7 2026-01-06T14:38:01.639Z 2026-01-12T15:11:28.049Z
9155729 9155729 20260104061808_07SeM UK00D7 2026-01-06T14:37:57.649Z 2026-01-12T15:11:25.587Z
9155643 9155643 20260104060857_FVl90 UK00D7 2026-01-06T14:37:51.175Z 2026-01-12T15:11:22.512Z
9155638 9155638 20260104060838_FATQT UK00D7 2026-01-06T14:37:46.553Z 2026-01-12T15:11:22.165Z
9155527 9155527 20260104060048_11enC UK00D7 2026-01-06T14:37:29.018Z 2026-01-12T15:11:05.545Z
9155463 9155463 20260104055702_oVfgu UK00D7 2026-01-06T14:37:24.184Z 2026-01-12T15:11:03.404Z
9155410 9155410 20260104055442_0ifjz UK00D7 2026-01-06T14:37:20.467Z 2026-01-12T15:10:59.949Z
9155334 9155334 20260104055045_vT363 UK00D7 2026-01-06T14:37:14.990Z 2026-01-12T15:10:57.334Z
9155235 9155235 20260104054510_NL0DV UK00D7 2026-01-06T14:36:59.874Z 2026-01-12T15:10:54.220Z
9155101 9155101 20260104053544_lR78H UK00D7 2026-01-06T14:36:48.865Z 2026-01-12T15:10:49.339Z
9155022 9155022 20260104053130_fgVZT UK00D7 2026-01-06T14:36:40.445Z 2026-01-12T15:10:45.968Z
9154919 9154919 20260104052409_2I322 UK00D7 2026-01-06T14:36:22.139Z 2026-01-12T15:10:26.364Z
9154719 9154719 20260104051117_hK5A2 UK00D7 2026-01-06T14:36:06.150Z 2026-01-12T15:10:17.551Z
9154642 9154642 20260104050522_y13ri UK00D7 2026-01-06T14:35:47.908Z 2026-01-12T15:10:13.239Z
9154612 9154612 20260104050412_54PKb UK00D7 2026-01-06T14:35:45.255Z 2026-01-12T15:10:11.664Z
9154587 9154587 20260104050300_O23th UK00D7 2026-01-06T14:35:44.088Z 2026-01-12T15:10:11.008Z
9154565 9154565 20260104050222_c66jX UK00D7 2026-01-06T14:35:43.536Z 2026-01-12T15:10:10.581Z
9154445 9154445 20260104045717_fHcTD UK00D7 2026-01-06T14:35:35.145Z 2026-01-12T15:09:55.238Z
9154342 9154342 20260104045317_dlmoo UK00D7 2026-01-06T14:35:21.278Z 2026-01-12T15:09:48.081Z
9154314 9154314 20260104045231_FiF2p UK00D7 2026-01-06T14:35:19.246Z 2026-01-12T15:09:46.871Z
9154194 9154194 20260104044200_Eu3JJ UK00D7 2026-01-06T14:35:00.188Z 2026-01-12T15:09:39.725Z
9154158 9154158 20260104044115_aTclI UK00D7 2026-01-06T14:34:57.402Z 2026-01-12T15:09:38.717Z
9154005 9154005 20260104042955_DIGMQ UK00D7 2026-01-06T14:34:29.473Z 2026-01-12T15:09:31.275Z
9153941 9153941 20260104042437_Jr1W7 UK00D7 2026-01-06T14:34:23.531Z 2026-01-12T15:09:23.558Z
9153919 9153919 20260104042256_L5mqp UK00D7 2026-01-06T14:34:21.837Z 2026-01-12T15:09:13.147Z
9153839 9153839 20260104041602_qTyno UK00D7 2026-01-06T14:34:11.801Z 2026-01-12T15:09:06.903Z
9153732 9153732 20260104041105_3z9H5 UK00D7 2026-01-06T14:33:54.187Z 2026-01-12T15:09:03.247Z
9153718 9153718 20260104041033_V9AMp UK00D7 2026-01-06T14:33:53.275Z 2026-01-12T15:09:02.737Z
9153710 9153710 20260104041014_EhRnp UK00D7 2026-01-06T14:33:52.727Z 2026-01-12T15:09:02.482Z
9153699 9153699 20260104041006_nXAEN UK00D7 2026-01-06T14:33:52.324Z 2026-01-12T15:09:02.283Z
9153640 9153640 20260104040514_ZCwib UK00D7 2026-01-06T14:33:44.575Z 2026-01-12T15:08:58.732Z
9153586 9153586 20260104040312_9xvgM UK00D7 2026-01-06T14:33:41.428Z 2026-01-12T15:08:57.211Z
9153540 9153540 20260104040043_mlUA7 UK00D7 2026-01-06T14:33:29.962Z 2026-01-12T15:08:55.340Z
9153488 9153488 20260104035803_XQUK8 UK00D7 2026-01-06T14:33:24.993Z 2026-01-12T15:08:52.683Z
9153390 9153390 20260104035338_O8oWD UK00D7 2026-01-06T14:33:18.943Z 2026-01-12T15:08:35.207Z
9153377 9153377 20260104035333_Orqnu UK00D7 2026-01-06T14:33:18.383Z 2026-01-12T15:08:34.905Z
9153317 9153317 20260104034952_4lxyq UK00D7 2026-01-06T14:33:11.492Z 2026-01-12T15:08:31.525Z
9153292 9153292 20260104034920_qQBrR UK00D7 2026-01-06T14:33:02.290Z 2026-01-12T15:08:28.918Z
9153201 9153201 20260104004538_Ugd2T UK00D7 2026-01-06T14:26:25.800Z 2026-01-12T15:04:43.160Z
9150002 9150002 20260105002727_JheI4 UK00D7 2026-01-06T14:08:07.048Z 2026-01-13T15:12:50.649Z
9149642 9149642 20260104224314_RR6XH UK00D7 2026-01-06T14:06:28.513Z 2026-01-13T15:12:24.476Z
9146118 9146118 20260104033632_gHvvd UK00D7 2026-01-05T14:21:46.172Z 2026-01-12T15:08:19.860Z
9146028 9146028 20260104033428_HJGRZ UK00D7 2026-01-05T14:21:34.760Z 2026-01-12T15:08:18.424Z
9145908 9145908 20260104033047_tfjpJ UK00D7 2026-01-05T14:21:25.478Z 2026-01-12T15:08:15.540Z
9145852 9145852 20260104032917_SGki7 UK00D7 2026-01-05T14:21:21.282Z 2026-01-12T15:08:12.501Z
9145824 9145824 20260104032854_nqXDw UK00D7 2026-01-05T14:21:19.895Z 2026-01-12T15:08:01.179Z
9145797 9145797 20260104032821_diblE UK00D7 2026-01-05T14:21:18.735Z 2026-01-12T15:08:00.766Z
9145738 9145738 20260104032724_C7j0m UK00D7 2026-01-05T14:21:07.115Z 2026-01-12T15:07:59.655Z
9145473 9145473 20260104031733_Et5Kx UK00D7 2026-01-05T14:20:46.029Z 2026-01-12T15:07:50.007Z
9145363 9145363 20260104031444_6Zl2p UK00D7 2026-01-05T14:20:28.498Z 2026-01-12T15:07:47.116Z
9145129 9145129 20260104030515_9hK7R UK00D7 2026-01-05T14:20:12.210Z 2026-01-12T15:07:41.800Z
9145054 9145054 20260104030240_SzlGV UK00D7 2026-01-05T14:20:06.975Z 2026-01-12T15:07:39.999Z
9145031 9145031 20260104030150_02ZKE UK00D7 2026-01-05T14:20:04.787Z 2026-01-12T15:07:36.450Z

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