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

1,474 rows where station_code = "UK00DA" 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
9272917 9272917 20260128035910_nPqXZ UK00DA 2026-01-29T14:28:14.239Z 2026-01-29T14:30:25.706Z
9272766 9272766 20260128031800_8ByYB UK00DA 2026-01-29T14:27:44.589Z 2026-01-29T14:30:25.549Z
9272582 9272582 20260128024006_2WYj3 UK00DA 2026-01-29T14:27:11.422Z 2026-01-29T14:30:25.379Z
9272489 9272489 20260128021329_vLEln UK00DA 2026-01-29T14:26:50.453Z 2026-01-29T14:30:25.354Z
9272428 9272428 20260128020533_Ei6a5 UK00DA 2026-01-29T14:26:37.908Z 2026-01-29T14:30:25.344Z
9271905 9271905 20260127214256_dZAVh UK00DA 2026-01-29T14:24:53.454Z 2026-01-29T14:30:25.227Z
9271894 9271894 20260127214109_c9KsP UK00DA 2026-01-29T14:24:52.689Z 2026-01-29T14:30:25.227Z
9271850 9271850 20260127205625_FSrZ2 UK00DA 2026-01-29T14:24:26.475Z 2026-01-29T14:30:25.209Z
9271666 9271666 20260127190543_YFQoW UK00DA 2026-01-29T14:22:13.413Z 2026-01-29T14:30:25.006Z
9254531 9254531 20260123195741_W663W UK00DA 2026-01-25T14:09:39.167Z 2026-01-29T14:46:28.715Z
9252814 9252814 20260123063923_R8pFu UK00DA 2026-01-24T14:17:16.609Z 2026-01-29T14:53:34.581Z
9252811 9252811 20260123063904_2zH6Y UK00DA 2026-01-24T14:17:15.952Z 2026-01-29T14:53:34.475Z
9252706 9252706 20260123052832_h7NMQ UK00DA 2026-01-24T14:16:52.037Z 2026-01-29T14:53:17.522Z
9252536 9252536 20260123035444_LtI1H UK00DA 2026-01-24T14:16:04.481Z 2026-01-29T14:53:06.649Z
9252504 9252504 20260123034216_rTeWc UK00DA 2026-01-24T14:15:54.410Z 2026-01-29T14:53:04.827Z
9252502 9252502 20260123034057_9NHyi UK00DA 2026-01-24T14:15:53.906Z 2026-01-29T14:53:04.599Z
9243797 9243797 20260121051758_unO0A UK00DA 2026-01-22T14:23:04.385Z 2026-01-29T15:05:27.664Z
9243764 9243764 20260121051349_ZOGHF UK00DA 2026-01-22T14:22:55.897Z 2026-01-29T15:05:26.325Z
9243733 9243733 20260121051126_WpNVv UK00DA 2026-01-22T14:22:51.781Z 2026-01-29T15:05:25.253Z
9243725 9243725 20260121051102_9W0ME UK00DA 2026-01-22T14:22:50.691Z 2026-01-29T15:05:24.967Z
9243685 9243685 20260121050503_rp2aj UK00DA 2026-01-22T14:22:44.347Z 2026-01-29T15:05:23.234Z
9243656 9243656 20260121050052_V5oZ2 UK00DA 2026-01-22T14:22:39.826Z 2026-01-29T15:05:21.751Z
9243586 9243586 20260121044948_nvhZw UK00DA 2026-01-22T14:22:16.073Z 2026-01-29T15:05:18.697Z
9243466 9243466 20260121043459_1VNOQ UK00DA 2026-01-22T14:22:01.268Z 2026-01-29T15:05:03.518Z
9243265 9243265 20260121040636_v9zmM UK00DA 2026-01-22T14:21:09.074Z 2026-01-29T15:04:53.024Z
9243246 9243246 20260121040526_QQ7iD UK00DA 2026-01-22T14:21:07.194Z 2026-01-29T15:04:52.449Z
9243175 9243175 20260121035340_hRA3P UK00DA 2026-01-22T14:20:50.451Z 2026-01-29T15:04:49.505Z
9243084 9243084 20260121034111_YliDK UK00DA 2026-01-22T14:20:32.042Z 2026-01-29T15:04:46.042Z
9243065 9243065 20260121034002_fUHM0 UK00DA 2026-01-22T14:20:27.016Z 2026-01-29T15:04:45.544Z
9242755 9242755 20260121023919_6MEO0 UK00DA 2026-01-22T14:19:08.183Z 2026-01-29T15:04:19.543Z
9242716 9242716 20260121023641_KEdSz UK00DA 2026-01-22T14:19:02.217Z 2026-01-29T15:04:18.112Z
9242684 9242684 20260121023358_AXQzO UK00DA 2026-01-22T14:18:48.546Z 2026-01-29T15:04:16.650Z
9237244 9237244 20260120045417_HZUJX UK00DA 2026-01-21T14:25:45.956Z 2026-01-28T15:01:05.672Z
9237083 9237083 20260120043458_wRZSD UK00DA 2026-01-21T14:25:14.769Z 2026-01-28T15:00:57.530Z
9237051 9237051 20260120043127_1XkoE UK00DA 2026-01-21T14:25:01.908Z 2026-01-28T15:00:55.668Z
9234480 9234480 20260119214828_Fw7Lf UK00DA 2026-01-21T14:14:40.198Z 2026-01-28T14:57:49.510Z
9222722 9222722 20260117202703_5wpd0 UK00DA 2026-01-19T14:15:55.813Z 2026-01-26T15:01:18.355Z
9222671 9222671 20260117201637_MRJ0s UK00DA 2026-01-19T14:15:46.113Z 2026-01-26T15:01:16.819Z
9222599 9222599 20260117200408_ZvfKC UK00DA 2026-01-19T14:15:26.713Z 2026-01-26T15:01:14.645Z
9222554 9222554 20260117195532_lISmn UK00DA 2026-01-19T14:15:15.078Z 2026-01-26T15:01:13.323Z
9222234 9222234 20260117184453_XUQd4 UK00DA 2026-01-19T14:13:52.260Z 2026-01-26T15:00:44.602Z
9222005 9222005 20260117174447_qX2NN UK00DA 2026-01-19T14:12:51.650Z 2026-01-26T15:00:34.152Z
9217888 9217888 20260116202015_ADj5Z UK00DA 2026-01-18T14:09:28.650Z 2026-01-25T14:57:50.922Z
9214414 9214414 20260116062942_3RuP5 UK00DA 2026-01-17T14:21:26.707Z 2026-01-24T15:13:35.657Z
9214412 9214412 20260116062941_Lfo9V UK00DA 2026-01-17T14:21:26.261Z 2026-01-24T15:13:35.491Z
9208398 9208398 20260115051544_XQHDn UK00DA 2026-01-16T14:12:31.349Z 2026-01-22T15:04:12.601Z
9208360 9208360 20260115051134_6pTgb UK00DA 2026-01-16T14:12:19.857Z 2026-01-22T15:04:11.197Z
9208316 9208316 20260115050204_TYqHx UK00DA 2026-01-16T14:12:07.608Z 2026-01-22T15:04:07.161Z
9208296 9208296 20260115045827_7BZkW UK00DA 2026-01-16T14:12:02.974Z 2026-01-22T15:04:06.731Z
9207904 9207904 20260115033036_M96cJ UK00DA 2026-01-16T14:10:35.371Z 2026-01-22T15:03:56.164Z
9207889 9207889 20260115032840_pP3LZ UK00DA 2026-01-16T14:10:32.993Z 2026-01-22T15:03:55.915Z
9207881 9207881 20260115032618_z8L4w UK00DA 2026-01-16T14:10:30.975Z 2026-01-22T15:03:55.589Z
9207816 9207816 20260115031250_Dv3XP UK00DA 2026-01-16T14:10:13.757Z 2026-01-22T15:03:53.538Z
9207709 9207709 20260115024922_Pn93C UK00DA 2026-01-16T14:09:44.782Z 2026-01-22T15:03:30.423Z
9207703 9207703 20260115024848_uWd9H UK00DA 2026-01-16T14:09:44.203Z 2026-01-22T15:03:30.378Z
9207667 9207667 20260115024024_3C3fJ UK00DA 2026-01-16T14:09:36.082Z 2026-01-22T15:03:29.450Z
9207500 9207500 20260115015630_hKhus UK00DA 2026-01-16T14:08:59.245Z 2026-01-22T15:03:23.362Z
9207487 9207487 20260115014926_W0t3D UK00DA 2026-01-16T14:08:57.475Z 2026-01-22T15:03:23.023Z
9207480 9207480 20260115014649_zqQc6 UK00DA 2026-01-16T14:08:56.726Z 2026-01-22T15:03:22.990Z
9207472 9207472 20260115014535_cEYtx UK00DA 2026-01-16T14:08:53.748Z 2026-01-22T15:03:22.774Z
9207466 9207466 20260115014357_An0LJ UK00DA 2026-01-16T14:08:51.313Z 2026-01-22T15:03:22.510Z
9207419 9207419 20260115013347_O5B41 UK00DA 2026-01-16T14:08:41.083Z 2026-01-22T15:03:21.433Z
9207413 9207413 20260115013230_Yxhf8 UK00DA 2026-01-16T14:08:39.829Z 2026-01-22T15:03:21.234Z
9207399 9207399 20260115012407_EG80F UK00DA 2026-01-16T14:08:36.469Z 2026-01-22T15:03:20.815Z
9207354 9207354 20260115010859_vfKP1 UK00DA 2026-01-16T14:08:23.409Z 2026-01-22T15:03:19.662Z
9204497 9204497 20260114064903_aPsSV UK00DA 2026-01-15T14:27:26.825Z 2026-01-22T15:10:29.947Z
9204491 9204491 20260114064732_HmOTB UK00DA 2026-01-15T14:27:25.941Z 2026-01-22T15:10:29.581Z
9204088 9204088 20260114060535_vKFHf UK00DA 2026-01-15T14:26:21.985Z 2026-01-22T15:10:17.707Z
9203972 9203972 20260114060041_JI21g UK00DA 2026-01-15T14:25:59.956Z 2026-01-22T15:10:16.491Z
9203910 9203910 20260114055221_Vgrup UK00DA 2026-01-15T14:25:50.314Z 2026-01-22T15:10:15.386Z
9203891 9203891 20260114054726_Bf3wn UK00DA 2026-01-15T14:25:47.313Z 2026-01-22T15:10:15.032Z
9203542 9203542 20260114051659_iw0yf UK00DA 2026-01-15T14:24:45.468Z 2026-01-22T15:10:09.736Z
9203099 9203099 20260114043249_jetAf UK00DA 2026-01-15T14:23:17.615Z 2026-01-22T15:10:01.407Z
9202623 9202623 20260114035448_Mv7CJ UK00DA 2026-01-15T14:21:47.207Z 2026-01-22T15:09:23.712Z
9202311 9202311 20260114032713_xoe10 UK00DA 2026-01-15T14:21:02.377Z 2026-01-22T15:09:16.135Z
9202245 9202245 20260114032429_gSKye UK00DA 2026-01-15T14:20:44.074Z 2026-01-22T15:09:15.124Z
9202147 9202147 20260114032011_msxWS UK00DA 2026-01-15T14:20:35.093Z 2026-01-22T15:09:14.062Z
9202115 9202115 20260114031742_13ncE UK00DA 2026-01-15T14:20:33.474Z 2026-01-22T15:09:13.789Z
9202045 9202045 20260114031230_qz3FI UK00DA 2026-01-15T14:20:16.816Z 2026-01-22T15:09:12.317Z
9201951 9201951 20260114030717_F9aeY UK00DA 2026-01-15T14:20:09.975Z 2026-01-22T15:09:11.652Z
9201898 9201898 20260114030441_gLeWu UK00DA 2026-01-15T14:20:05.084Z 2026-01-22T15:09:11.080Z
9201761 9201761 20260114024811_UZzPQ UK00DA 2026-01-15T14:19:39.605Z 2026-01-22T15:09:09.044Z
9201671 9201671 20260114024102_e40PR UK00DA 2026-01-15T14:19:16.322Z 2026-01-22T15:09:07.228Z
9201656 9201656 20260114023743_A0fL9 UK00DA 2026-01-15T14:19:14.186Z 2026-01-22T15:09:07.010Z
9201517 9201517 20260114022410_aP2aj UK00DA 2026-01-15T14:18:47.303Z 2026-01-22T15:09:04.765Z
9201303 9201303 20260114020630_ryPkP UK00DA 2026-01-15T14:18:12.140Z 2026-01-22T15:09:01.343Z
9201190 9201190 20260114015341_crS3U UK00DA 2026-01-15T14:17:45.041Z 2026-01-22T15:08:59.204Z
9201127 9201127 20260114014645_U3Z0P UK00DA 2026-01-15T14:17:35.612Z 2026-01-22T15:08:58.042Z
9200810 9200810 20260114010508_IAeyh UK00DA 2026-01-15T14:16:33.238Z 2026-01-22T15:08:28.908Z
9200655 9200655 20260114004510_mxnnB UK00DA 2026-01-15T14:15:56.702Z 2026-01-22T15:08:22.758Z
9200644 9200644 20260114004248_Q2sFW UK00DA 2026-01-15T14:15:54.544Z 2026-01-22T15:08:22.562Z
9200594 9200594 20260114003008_yHT2V UK00DA 2026-01-15T14:15:42.650Z 2026-01-22T15:08:21.271Z
9200542 9200542 20260114002153_CuP7z UK00DA 2026-01-15T14:15:29.310Z 2026-01-22T15:08:17.954Z
9200503 9200503 20260114001412_WUk6Y UK00DA 2026-01-15T14:15:21.245Z 2026-01-22T15:08:17.091Z
9200427 9200427 20260114000624_x1VEn UK00DA 2026-01-15T14:15:10.540Z 2026-01-22T15:08:15.739Z
9200374 9200374 20260113235347_FHAUQ UK00DA 2026-01-15T14:14:52.389Z 2026-01-22T15:08:14.769Z
9200347 9200347 20260113235058_kFL9z UK00DA 2026-01-15T14:14:47.256Z 2026-01-22T15:08:14.301Z
9200191 9200191 20260113230741_t8N0h UK00DA 2026-01-15T14:14:08.245Z 2026-01-22T15:08:10.992Z
9200103 9200103 20260113225110_vvXgm UK00DA 2026-01-15T14:13:45.979Z 2026-01-22T15:08:09.554Z
9200032 9200032 20260113223142_DLVic UK00DA 2026-01-15T14:13:35.731Z 2026-01-22T15:08:08.218Z

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