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

806 rows where station_code = "UK008K" 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
9260386 9260386 20260125041059_HPCIJ UK008K 2026-01-26T14:21:29.163Z 2026-01-29T14:44:09.698Z
9237082 9237082 20260120043458_wRZSD UK008K 2026-01-21T14:25:14.769Z 2026-01-28T15:00:57.530Z
9236713 9236713 20260120035056_SmM8B UK008K 2026-01-21T14:23:44.966Z 2026-01-28T15:00:31.719Z
9218925 9218925 20260117063725_izRb1 UK008K 2026-01-18T14:14:15.294Z 2026-01-25T14:58:55.851Z
9213944 9213944 20260116050457_QNXb7 UK008K 2026-01-17T14:19:18.439Z 2026-01-24T15:12:53.165Z
9203761 9203761 20260114053525_kPJoE UK008K 2026-01-15T14:25:21.609Z 2026-01-22T15:10:13.158Z
9202976 9202976 20260114042337_g3vtJ UK008K 2026-01-15T14:22:57.118Z 2026-01-22T15:10:00.222Z
9202417 9202417 20260114033619_uZ0Io UK008K 2026-01-15T14:21:14.289Z 2026-01-22T15:09:17.411Z
9200091 9200091 20260113225110_HaZho UK008K 2026-01-15T14:13:45.229Z 2026-01-22T15:08:09.491Z
9176677 9176677 20260110060402_GDPnB UK008K 2026-01-11T14:09:43.072Z 2026-01-18T15:08:48.831Z
9176340 9176340 20260110051754_KAEbU UK008K 2026-01-11T14:08:46.193Z 2026-01-18T15:08:35.278Z
9176106 9176106 20260110044838_b8mAD UK008K 2026-01-11T14:08:12.266Z 2026-01-18T15:08:19.407Z
9174508 9174508 20260109195739_Y4USf UK008K 2026-01-11T14:03:27.858Z 2026-01-18T15:06:49.323Z
9116749 9116749 20251231064607_dinrW UK008K 2026-01-01T14:28:52.574Z 2026-01-08T15:12:09.962Z
9116613 9116613 20251231062814_2cjn7 UK008K 2026-01-01T14:28:29.779Z 2026-01-08T15:11:56.713Z
9116579 9116579 20251231062520_LTalo UK008K 2026-01-01T14:28:25.294Z 2026-01-08T15:11:55.489Z
9116214 9116214 20251231055742_AFSd6 UK008K 2026-01-01T14:27:32.145Z 2026-01-08T15:11:39.325Z
9115584 9115584 20251231051617_nmSTS UK008K 2026-01-01T14:25:50.104Z 2026-01-08T15:10:56.250Z
9115241 9115241 20251231045502_kJJBa UK008K 2026-01-01T14:24:46.815Z 2026-01-08T15:10:38.191Z
9114870 9114870 20251231043346_navTp UK008K 2026-01-01T14:23:42.383Z 2026-01-08T15:10:11.990Z
9114842 9114842 20251231043303_U2ue3 UK008K 2026-01-01T14:23:40.957Z 2026-01-08T15:10:11.418Z
9114548 9114548 20251231042031_fVo3Q UK008K 2026-01-01T14:22:54.923Z 2026-01-08T15:09:53.659Z
9114368 9114368 20251231041417_2pllz UK008K 2026-01-01T14:22:18.914Z 2026-01-08T15:09:44.291Z
9099223 9099223 20251226191721_T28sK UK008K 2025-12-30T15:23:05.777Z 2026-01-03T15:43:20.097Z
9093347 9093347 20251227054256_uRSwd UK008K 2025-12-30T15:03:06.235Z 2026-01-04T15:30:18.713Z
9074485 9074485 20251225200555_RiMbH UK008K 2025-12-29T15:00:56.860Z 2026-01-02T15:48:32.252Z
9072842 9072842 20251225045042_3UTdd UK008K 2025-12-29T14:56:14.730Z 2026-01-02T15:44:57.199Z
9072243 9072243 20251226204011_AWMGf UK008K 2025-12-29T14:50:30.150Z 2026-01-03T15:43:47.815Z
9071818 9071818 20251226193549_TuT0A UK008K 2025-12-29T14:50:06.081Z 2026-01-03T15:43:28.232Z
9071709 9071709 20251226191721_OmKzr UK008K 2025-12-29T14:49:44.209Z 2025-12-29T14:51:19.028Z
9058288 9058288 20251227054256_bJvSa UK008K 2025-12-29T14:24:32.188Z 2025-12-29T14:51:09.343Z
9056875 9056875 20251227043749_L23kC UK008K 2025-12-29T14:21:45.187Z 2026-01-04T15:29:15.306Z
9051962 9051962 20251227002300_lwNu7 UK008K 2025-12-29T14:08:33.256Z 2026-01-04T15:25:06.471Z
9050052 9050052 20251226213908_gw13g UK008K 2025-12-29T14:01:25.603Z 2026-01-04T15:23:16.178Z
9042588 9042588 20251224183139_U3FyR UK008K 2025-12-28T14:45:58.923Z 2026-01-01T15:57:07.098Z
9032645 9032645 20251225064730_nOFAQ UK008K 2025-12-28T14:23:19.952Z 2026-01-02T15:45:46.272Z
9032055 9032055 20251225055752_UOWqL UK008K 2025-12-28T14:22:08.417Z 2026-01-02T15:45:38.142Z
9031796 9031796 20251225054408_sMdPK UK008K 2025-12-28T14:21:36.072Z 2026-01-02T15:45:34.400Z
9030706 9030706 20251225045524_letjx UK008K 2025-12-28T14:19:18.688Z 2026-01-02T15:44:57.982Z
9030620 9030620 20251225045042_Z7lPP UK008K 2025-12-28T14:19:08.727Z 2025-12-28T14:48:30.897Z
9027504 9027504 20251225022039_Xpcbi UK008K 2025-12-28T14:11:23.879Z 2026-01-02T15:43:34.572Z
9026123 9026123 20251225004635_fEgaC UK008K 2025-12-28T14:06:43.499Z 2026-01-02T15:42:49.337Z
9024455 9024455 20251224222120_Ok53e UK008K 2025-12-28T14:00:35.024Z 2026-01-02T15:41:58.764Z
8969172 8969172 20251216185151_lMdjm UK008K 2025-12-25T14:50:44.670Z 2025-12-25T14:50:44.670Z
8887913 8887913 20251214013214_GHVVc UK008K 2025-12-22T14:11:31.127Z 2025-12-23T14:27:41.061Z
8886145 8886145 20251214011755_lnox3 UK008K 2025-12-22T14:11:15.778Z 2025-12-23T14:27:38.303Z
8885804 8885804 20251214011524_t83Hs UK008K 2025-12-22T14:11:13.714Z 2025-12-23T14:27:37.940Z
8885509 8885509 20251214011320_2HaIE UK008K 2025-12-22T14:11:10.363Z 2025-12-23T14:27:37.465Z
8868897 8868897 20251214003511_n23gU UK008K 2025-12-21T14:10:15.405Z 2025-12-23T14:27:30.634Z
8866886 8866886 20251214001718_46PzU UK008K 2025-12-21T14:10:01.216Z 2025-12-23T14:27:12.402Z
8866606 8866606 20251214001357_vZwaJ UK008K 2025-12-21T14:09:59.299Z 2025-12-23T14:27:06.715Z
8857465 8857465 20251213234737_M3RUG UK008K 2025-12-20T14:13:25.088Z 2025-12-23T14:26:27.302Z
8853414 8853414 20251214002035_EbMaU UK008K 2025-12-19T14:22:39.300Z 2025-12-23T14:27:22.326Z
8852998 8852998 20251214001717_tX4Mu UK008K 2025-12-19T14:22:31.283Z 2025-12-23T14:27:12.399Z
8852805 8852805 20251214001543_SU5Go UK008K 2025-12-19T14:22:26.105Z 2025-12-23T14:27:10.367Z
8852606 8852606 20251214001356_kzPB0 UK008K 2025-12-19T14:22:08.275Z 2025-12-23T14:27:06.713Z
8851990 8851990 20251214000657_NyREv UK008K 2025-12-19T14:21:38.854Z 2025-12-20T14:21:21.956Z
8834371 8834371 20251213210151_33iPC UK008K 2025-12-18T14:36:22.842Z 2025-12-23T14:25:01.459Z
8801164 8801164 20251213061711_P30fx UK008K 2025-12-16T14:13:22.442Z 2025-12-23T14:19:20.546Z
8800038 8800038 20251213055437_UgAcu UK008K 2025-12-16T14:12:25.812Z 2025-12-23T14:19:07.501Z
8770980 8770980 20251212210437_QibUw UK008K 2025-12-15T14:22:58.568Z 2025-12-21T14:17:27.532Z
8667355 8667355 20251130001656_G9bjA UK008K 2025-12-02T14:37:24.866Z 2025-12-08T14:54:01.999Z
8651710 8651710 20251130001333_Mq62O UK008K 2025-12-01T14:19:44.326Z 2025-12-08T14:54:00.996Z
8651673 8651673 20251130000929_cdbxU UK008K 2025-12-01T14:19:40.033Z 2025-12-08T14:53:54.238Z
8651561 8651561 20251129235617_Adjej UK008K 2025-12-01T14:19:20.577Z 2025-12-08T14:53:47.173Z
8651421 8651421 20251129234055_sT2Vq UK008K 2025-12-01T14:19:01.778Z 2025-12-08T14:53:45.206Z
8650938 8650938 20251129220836_zhUy3 UK008K 2025-12-01T14:17:34.637Z 2025-12-08T14:53:09.064Z
8650464 8650464 20251129202513_942aj UK008K 2025-12-01T14:16:16.242Z 2025-12-08T14:53:00.120Z
8616699 8616699 20251126061648_5Ytq3 UK008K 2025-11-27T14:31:31.055Z 2025-12-04T15:11:41.962Z
8613341 8613341 20251126031415_djwQO UK008K 2025-11-27T14:25:39.096Z 2025-12-04T15:09:39.803Z
8612906 8612906 20251126025507_dvq4L UK008K 2025-11-27T14:24:59.117Z 2025-12-04T15:09:35.726Z
8612130 8612130 20251126021923_4Ig3x UK008K 2025-11-27T14:23:32.592Z 2025-12-04T15:09:27.867Z
8611548 8611548 20251126015117_eivmt UK008K 2025-11-27T14:22:19.015Z 2025-12-04T15:09:22.498Z
8611275 8611275 20251126013558_117MJ UK008K 2025-11-27T14:21:47.981Z 2025-12-04T15:09:07.213Z
8610995 8610995 20251126011730_fVLSl UK008K 2025-11-27T14:21:03.083Z 2025-12-04T15:08:48.093Z
8608214 8608214 20251125220143_KZt4E UK008K 2025-11-27T14:15:34.040Z 2025-12-04T15:07:42.723Z
8607816 8607816 20251125212516_YH3gS UK008K 2025-11-27T14:14:33.955Z 2025-12-04T15:07:33.131Z
8603476 8603476 20251125061031_iAvK1 UK008K 2025-11-26T14:27:28.021Z 2025-12-02T15:09:35.963Z
8603136 8603136 20251125054436_7zVxJ UK008K 2025-11-26T14:27:09.509Z 2025-12-02T15:09:34.543Z
8603115 8603115 20251125054346_qMVVy UK008K 2025-11-26T14:27:07.372Z 2025-12-02T15:09:34.513Z
8602337 8602337 20251125044833_alAO3 UK008K 2025-11-26T14:25:33.932Z 2025-12-02T15:09:30.503Z
8601438 8601438 20251125034724_Mlkb3 UK008K 2025-11-26T14:23:59.135Z 2025-12-02T15:09:09.225Z
8601420 8601420 20251125034644_umdJN UK008K 2025-11-26T14:23:58.765Z 2025-12-02T15:09:09.096Z
8600165 8600165 20251125024627_n1g4k UK008K 2025-11-26T14:22:05.571Z 2025-12-02T15:08:34.966Z
8600059 8600059 20251125023931_i3iLi UK008K 2025-11-26T14:22:00.536Z 2025-12-02T15:08:34.253Z
8599897 8599897 20251125022941_sXCbg UK008K 2025-11-26T14:21:35.225Z 2025-12-02T15:08:32.592Z
8599256 8599256 20251125015647_Atz9S UK008K 2025-11-26T14:20:43.873Z 2025-12-02T15:08:22.066Z
8599205 8599205 20251125015241_p4HnY UK008K 2025-11-26T14:20:38.977Z 2025-12-02T15:08:20.870Z
8599046 8599046 20251125014139_3Khh5 UK008K 2025-11-26T14:20:14.656Z 2025-12-02T15:08:17.243Z
8599000 8599000 20251125014105_HprQB UK008K 2025-11-26T14:20:10.765Z 2025-12-02T15:08:15.773Z
8598996 8598996 20251125014104_VA4dS UK008K 2025-11-26T14:20:10.451Z 2025-12-02T15:08:15.751Z
8598160 8598160 20251125003919_gwcyO UK008K 2025-11-26T14:18:23.069Z 2025-12-02T15:07:47.283Z
8597847 8597847 20251125001444_a1lFN UK008K 2025-11-26T14:17:45.797Z 2025-12-02T15:07:41.082Z
8597835 8597835 20251125001403_Yz3LF UK008K 2025-11-26T14:17:45.322Z 2025-12-02T15:07:41.062Z
8597814 8597814 20251125001343_siLJw UK008K 2025-11-26T14:17:44.806Z 2025-12-02T15:07:40.806Z
8597675 8597675 20251125000006_9VWvy UK008K 2025-11-26T14:17:19.397Z 2025-12-02T15:07:39.274Z
8597435 8597435 20251124233533_aRwvc UK008K 2025-11-26T14:16:49.288Z 2025-12-02T15:07:32.680Z
8597393 8597393 20251124233123_a733t UK008K 2025-11-26T14:16:45.518Z 2025-12-02T15:07:31.191Z
8597277 8597277 20251124231914_ruhO0 UK008K 2025-11-26T14:16:28.376Z 2025-12-02T15:07:27.888Z
8597076 8597076 20251124225107_rR13T UK008K 2025-11-26T14:15:56.542Z 2025-12-02T15:07:22.756Z

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