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

3,023 rows where station_code = "UK005U" 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
9254876 9254876 20260123221215_nqI3U UK005U 2026-01-25T14:11:01.218Z 2026-01-29T14:46:53.213Z
9243204 9243204 20260121035831_kvEE2 UK005U 2026-01-22T14:20:56.025Z 2026-01-29T15:04:50.772Z
9242644 9242644 20260121022929_fxXr8 UK005U 2026-01-22T14:18:40.053Z 2026-01-29T15:04:15.524Z
9213141 9213141 20260116022505_WGzxp UK005U 2026-01-17T14:15:37.704Z 2026-01-24T15:11:44.510Z
9212957 9212957 20260116014242_kjkze UK005U 2026-01-17T14:14:44.330Z 2026-01-24T15:11:35.595Z
9212902 9212902 20260116013607_eam1P UK005U 2026-01-17T14:14:30.239Z 2026-01-24T15:11:33.343Z
9203780 9203780 20260114053712_X80oV UK005U 2026-01-15T14:25:23.375Z 2026-01-22T15:10:13.423Z
9202851 9202851 20260114041313_TOge1 UK005U 2026-01-15T14:22:37.933Z 2026-01-22T15:09:57.869Z
9202750 9202750 20260114040731_o82KS UK005U 2026-01-15T14:22:18.057Z 2026-01-22T15:09:39.158Z
9202392 9202392 20260114033358_p918a UK005U 2026-01-15T14:21:11.614Z 2026-01-22T15:09:17.121Z
9202176 9202176 20260114032201_e54Vx UK005U 2026-01-15T14:20:39.005Z 2026-01-22T15:09:14.449Z
9202027 9202027 20260114031147_pK1Ey UK005U 2026-01-15T14:20:16.258Z 2026-01-22T15:09:12.242Z
9201598 9201598 20260114023423_SvAGS UK005U 2026-01-15T14:19:09.617Z 2026-01-22T15:09:06.578Z
9194746 9194746 20260112223006_c5PcY UK005U 2026-01-14T14:10:30.404Z 2026-01-21T15:04:20.532Z
9180417 9180417 20260110202101_I3wC2 UK005U 2026-01-12T14:07:03.259Z 2026-01-19T15:16:01.405Z
9158434 9158434 20260105222853_KRgNi UK005U 2026-01-07T14:06:05.820Z 2026-01-13T15:07:22.186Z
9158185 9158185 20260105205219_zk024 UK005U 2026-01-07T14:05:14.283Z 2026-01-13T15:07:02.842Z
9149584 9149584 20260104220810_u3NbS UK005U 2026-01-06T14:06:11.826Z 2026-01-13T15:12:19.526Z
9148328 9148328 20260103173927_UQsYA UK005U 2026-01-05T14:30:24.387Z 2026-01-10T15:04:25.653Z
9147369 9147369 20260104054046_2PF8n UK005U 2026-01-05T14:24:06.375Z 2026-01-12T15:10:51.918Z
9147189 9147189 20260104051521_4qtdC UK005U 2026-01-05T14:23:38.883Z 2026-01-12T15:10:20.393Z
9147110 9147110 20260104050426_CVMnE UK005U 2026-01-05T14:23:28.535Z 2026-01-12T15:10:12.168Z
9147092 9147092 20260104050233_BUwCa UK005U 2026-01-05T14:23:27.166Z 2026-01-12T15:10:10.953Z
9146952 9146952 20260104044951_xY3H2 UK005U 2026-01-05T14:23:18.875Z 2026-01-12T15:09:43.173Z
9146872 9146872 20260104043921_RQB2o UK005U 2026-01-05T14:23:03.394Z 2026-01-12T15:09:37.538Z
9146851 9146851 20260104043436_bOK6l UK005U 2026-01-05T14:22:57.221Z 2026-01-12T15:09:35.835Z
9146732 9146732 20260104041956_fXNy1 UK005U 2026-01-05T14:22:46.048Z 2026-01-12T15:09:11.258Z
9146690 9146690 20260104041513_7Fybu UK005U 2026-01-05T14:22:41.896Z 2026-01-12T15:09:06.445Z
9146662 9146662 20260104041239_xCcF3 UK005U 2026-01-05T14:22:40.222Z 2026-01-12T15:09:04.490Z
9139405 9139405 20260103233105_6ADGd UK005U 2026-01-05T14:11:37.117Z 2026-01-12T15:03:27.464Z
9138572 9138572 20260103223326_qjTTI UK005U 2026-01-05T14:10:10.835Z 2026-01-12T15:02:52.921Z
9138214 9138214 20260103221104_tKga0 UK005U 2026-01-05T14:09:40.513Z 2026-01-12T15:02:43.224Z
9137779 9137779 20260103213316_2WX3w UK005U 2026-01-05T14:08:56.392Z 2026-01-12T15:02:19.336Z
9136997 9136997 20260103203108_NSZBf UK005U 2026-01-05T14:07:42.855Z 2026-01-12T15:01:45.171Z
9131054 9131054 20260103044623_Pqzxn UK005U 2026-01-04T14:12:29.319Z 2026-01-10T14:59:56.927Z
9130942 9130942 20260103043613_gE9Gw UK005U 2026-01-04T14:12:08.010Z 2026-01-10T14:59:51.995Z
9130842 9130842 20260103042328_3fC3R UK005U 2026-01-04T14:11:50.046Z 2026-01-10T14:59:45.172Z
9130594 9130594 20260103034504_2j8aD UK005U 2026-01-04T14:10:51.690Z 2026-01-10T14:59:24.613Z
9123258 9123258 20251230222058_BsQqk UK005U 2026-01-02T14:22:53.721Z 2026-01-08T15:05:02.754Z
9111477 9111477 20251231011230_2j3wR UK005U 2026-01-01T14:11:39.840Z 2026-01-08T15:06:41.733Z
9110118 9110118 20251230222058_i2YX8 UK005U 2026-01-01T14:05:55.908Z 2026-01-08T15:05:02.934Z
9101482 9101482 20251230003702_Hj37V UK005U 2025-12-31T14:08:53.496Z 2026-01-07T15:06:23.171Z
9101280 9101280 20251229234550_QS8Xw UK005U 2025-12-31T14:07:37.889Z 2026-01-07T15:06:10.881Z
9058942 9058942 20251227062801_ty2nt UK005U 2025-12-29T14:25:39.969Z 2026-01-04T15:30:37.319Z
9058744 9058744 20251227061251_DZAx2 UK005U 2025-12-29T14:25:16.718Z 2026-01-04T15:30:30.935Z
9058302 9058302 20251227054309_g4w7C UK005U 2025-12-29T14:24:32.585Z 2026-01-04T15:30:19.024Z
9057495 9057495 20251227050452_fBRiz UK005U 2025-12-29T14:23:05.402Z 2026-01-04T15:29:47.461Z
9056936 9056936 20251227043950_bocXk UK005U 2025-12-29T14:21:57.561Z 2026-01-04T15:29:17.159Z
9056197 9056197 20251227040207_Fqfp2 UK005U 2025-12-29T14:20:07.406Z 2026-01-04T15:28:43.342Z
9056180 9056180 20251227040138_ylLmY UK005U 2025-12-29T14:20:04.918Z 2026-01-04T15:28:42.765Z
9055519 9055519 20251227032654_yxAA0 UK005U 2025-12-29T14:18:21.066Z 2026-01-04T15:28:06.820Z
9055141 9055141 20251227030805_0IFTM UK005U 2025-12-29T14:17:18.327Z 2026-01-04T15:27:44.605Z
9052875 9052875 20251227011719_6tIiN UK005U 2025-12-29T14:11:14.248Z 2026-01-04T15:25:48.522Z
9051276 9051276 20251226233408_ntUqF UK005U 2025-12-29T14:06:22.532Z 2025-12-30T14:57:28.721Z
9050758 9050758 20251226224922_5U3sC UK005U 2025-12-29T14:04:25.403Z 2026-01-04T15:23:52.046Z
9043894 9043894 20251224213551_59RY4 UK005U 2025-12-28T14:48:12.575Z 2026-01-01T15:57:24.360Z
9030700 9030700 20251225045524_letjx UK005U 2025-12-28T14:19:18.688Z 2026-01-02T15:44:57.982Z
9030391 9030391 20251225044224_hEF5b UK005U 2025-12-28T14:18:46.801Z 2026-01-02T15:44:54.485Z
9030086 9030086 20251225043043_2Mpbu UK005U 2025-12-28T14:18:03.233Z 2026-01-02T15:44:50.936Z
9029680 9029680 20251225040747_0cnny UK005U 2025-12-28T14:17:00.910Z 2026-01-02T15:44:28.244Z
9029494 9029494 20251225035418_NlEIk UK005U 2025-12-28T14:16:29.584Z 2026-01-02T15:44:23.227Z
9027447 9027447 20251225021801_HyOHm UK005U 2025-12-28T14:11:15.131Z 2026-01-02T15:43:33.353Z
9027274 9027274 20251225021058_RomHq UK005U 2025-12-28T14:10:38.358Z 2026-01-02T15:43:30.776Z
9026474 9026474 20251225011018_mKSHQ UK005U 2025-12-28T14:07:59.214Z 2026-01-02T15:42:56.070Z
9017003 9017003 20251220044646_pmgzp UK005U 2025-12-27T15:01:05.021Z 2025-12-29T15:23:27.721Z
9016843 9016843 20251220043559_318bd UK005U 2025-12-27T15:00:33.725Z 2025-12-29T15:23:26.380Z
8984801 8984801 20251220000347_siHYY UK005U 2025-12-26T14:31:23.452Z 2025-12-28T15:23:54.920Z
8984774 8984774 20251220000239_CrVZw UK005U 2025-12-26T14:31:22.433Z 2025-12-28T15:23:54.860Z
8984583 8984583 20251219234400_2wNTe UK005U 2025-12-26T14:31:01.505Z 2025-12-28T15:23:52.814Z
8974985 8974985 20251220030416_N8tPS UK005U 2025-12-26T14:05:47.671Z 2025-12-29T15:22:46.900Z
8974645 8974645 20251220023947_itZQt UK005U 2025-12-26T14:04:57.192Z 2025-12-29T15:22:43.610Z
8974098 8974098 20251220020325_paoL1 UK005U 2025-12-26T14:03:47.330Z 2025-12-29T15:22:38.938Z
8973750 8973750 20251220013701_P0yVv UK005U 2025-12-26T14:02:58.508Z 2025-12-29T15:22:36.361Z
8973654 8973654 20251220012741_tr214 UK005U 2025-12-26T14:02:43.132Z 2025-12-29T15:22:35.547Z
8973348 8973348 20251220011132_yglNn UK005U 2025-12-26T14:01:59.592Z 2025-12-29T15:22:33.456Z
8972238 8972238 20251217010744_1E0gU UK005U 2025-12-25T14:54:48.708Z 2025-12-25T14:54:48.708Z
8971912 8971912 20251217004355_iV3Bu UK005U 2025-12-25T14:54:38.217Z 2025-12-25T14:54:38.217Z
8971870 8971870 20251217004158_BJxtb UK005U 2025-12-25T14:54:37.214Z 2025-12-25T14:54:37.214Z
8971487 8971487 20251217001836_P2L45 UK005U 2025-12-25T14:53:52.629Z 2025-12-25T14:53:52.629Z
8971289 8971289 20251216235710_9QvAH UK005U 2025-12-25T14:53:43.055Z 2025-12-25T14:53:43.055Z
8970067 8970067 20251216214608_aH5HW UK005U 2025-12-25T14:52:04.612Z 2025-12-25T14:52:04.612Z
8970039 8970039 20251216214250_Z2ies UK005U 2025-12-25T14:52:03.471Z 2025-12-25T14:52:03.471Z
8952698 8952698 20251217021342_W4tTa UK005U 2025-12-25T14:02:03.147Z 2025-12-26T14:55:09.725Z
8952492 8952492 20251217015104_Sc8He UK005U 2025-12-25T14:00:52.561Z 2025-12-26T14:54:52.232Z
8897003 8897003 20251214024522_tS9f6 UK005U 2025-12-22T14:12:20.658Z 2025-12-23T14:27:56.127Z
8896799 8896799 20251214024401_e45hu UK005U 2025-12-22T14:12:19.393Z 2025-12-23T14:27:55.725Z
8896695 8896695 20251214024333_w9B6j UK005U 2025-12-22T14:12:18.823Z 2025-12-23T14:27:55.646Z
8896629 8896629 20251214024306_tEQKa UK005U 2025-12-22T14:12:18.662Z 2025-12-23T14:27:55.621Z
8895971 8895971 20251214023711_sGYS6 UK005U 2025-12-22T14:12:14.013Z 2025-12-23T14:27:54.630Z
8895489 8895489 20251214023314_dmTvz UK005U 2025-12-22T14:12:10.344Z 2025-12-23T14:27:53.842Z
8895324 8895324 20251214023145_W73zO UK005U 2025-12-22T14:12:09.280Z 2025-12-23T14:27:53.610Z
8895099 8895099 20251214022933_k9NkA UK005U 2025-12-22T14:12:07.708Z 2025-12-23T14:27:53.360Z
8895042 8895042 20251214022911_WKSSy UK005U 2025-12-22T14:12:06.904Z 2025-12-23T14:27:53.324Z
8894237 8894237 20251214022235_YxwRp UK005U 2025-12-22T14:12:01.994Z 2025-12-23T14:27:52.441Z
8894204 8894204 20251214022225_NBZXx UK005U 2025-12-22T14:12:01.954Z 2025-12-23T14:27:52.421Z
8893956 8893956 20251214022031_WXqQH UK005U 2025-12-22T14:12:00.574Z 2025-12-23T14:27:52.093Z
8893716 8893716 20251214021831_Ns4wG UK005U 2025-12-22T14:11:59.441Z 2025-12-23T14:27:51.722Z
8893563 8893563 20251214021715_IbJZ1 UK005U 2025-12-22T14:11:58.759Z 2025-12-23T14:27:51.166Z
8891987 8891987 20251214020523_g3iI6 UK005U 2025-12-22T14:11:48.757Z 2025-12-23T14:27:47.509Z
8891569 8891569 20251214020218_MCmV4 UK005U 2025-12-22T14:11:45.777Z 2025-12-23T14:27:46.921Z

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