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,395 rows where station_code = "UK00C1" 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
9272915 9272915 20260128035910_nPqXZ UK00C1 2026-01-29T14:28:14.239Z 2026-01-29T14:30:25.706Z
9272644 9272644 20260128025234_Y96ol UK00C1 2026-01-29T14:27:18.385Z 2026-01-29T14:30:25.406Z
9272043 9272043 20260127232037_xg8dm UK00C1 2026-01-29T14:25:23.707Z 2026-01-29T14:30:25.269Z
9271849 9271849 20260127205625_FSrZ2 UK00C1 2026-01-29T14:24:26.475Z 2026-01-29T14:30:25.209Z
9271814 9271814 20260127202405_jLen0 UK00C1 2026-01-29T14:23:59.832Z 2026-01-29T14:30:25.154Z
9271664 9271664 20260127190543_YFQoW UK00C1 2026-01-29T14:22:13.413Z 2026-01-29T14:30:25.006Z
9271603 9271603 20260127182817_W8iBN UK00C1 2026-01-29T14:21:43.066Z 2026-01-29T14:30:24.962Z
9256237 9256237 20260124062546_CcxcZ UK00C1 2026-01-25T14:16:16.802Z 2026-01-29T14:48:30.352Z
9256133 9256133 20260124060200_MgjRA UK00C1 2026-01-25T14:16:00.183Z 2026-01-29T14:48:24.827Z
9256071 9256071 20260124054848_O9kTO UK00C1 2026-01-25T14:15:41.649Z 2026-01-29T14:48:21.004Z
9255772 9255772 20260124045257_8qjCq UK00C1 2026-01-25T14:14:39.451Z 2026-01-29T14:47:56.641Z
9255028 9255028 20260124002628_iOr35 UK00C1 2026-01-25T14:11:39.595Z 2026-01-29T14:46:59.991Z
9244156 9244156 20260121062715_dc69X UK00C1 2026-01-22T14:24:27.061Z 2026-01-29T15:05:54.187Z
9243893 9243893 20260121053025_bMU6n UK00C1 2026-01-22T14:23:27.778Z 2026-01-29T15:05:32.283Z
9243174 9243174 20260121035340_hRA3P UK00C1 2026-01-22T14:20:50.432Z 2026-01-29T15:04:49.505Z
9222832 9222832 20260117210018_0P2WB UK00C1 2026-01-19T14:16:26.237Z 2026-01-26T15:01:22.555Z
9222720 9222720 20260117202703_5wpd0 UK00C1 2026-01-19T14:15:55.812Z 2026-01-26T15:01:18.355Z
9222669 9222669 20260117201637_MRJ0s UK00C1 2026-01-19T14:15:46.113Z 2026-01-26T15:01:16.819Z
9222597 9222597 20260117200408_ZvfKC UK00C1 2026-01-19T14:15:26.713Z 2026-01-26T15:01:14.645Z
9222553 9222553 20260117195532_lISmn UK00C1 2026-01-19T14:15:15.078Z 2026-01-26T15:01:13.323Z
9222232 9222232 20260117184453_XUQd4 UK00C1 2026-01-19T14:13:52.253Z 2026-01-26T15:00:44.602Z
9217955 9217955 20260116205916_S8ZXu UK00C1 2026-01-18T14:09:44.027Z 2026-01-25T14:57:53.108Z
9217908 9217908 20260116203729_77XN2 UK00C1 2026-01-18T14:09:33.831Z 2026-01-25T14:57:51.600Z
9217887 9217887 20260116202015_ADj5Z UK00C1 2026-01-18T14:09:28.650Z 2026-01-25T14:57:50.922Z
9208809 9208809 20260115065519_3kFS4 UK00C1 2026-01-16T14:14:04.818Z 2026-01-22T15:04:40.585Z
9208295 9208295 20260115045827_7BZkW UK00C1 2026-01-16T14:12:02.974Z 2026-01-22T15:04:06.731Z
9208271 9208271 20260115045010_Ujrwa UK00C1 2026-01-16T14:11:57.702Z 2026-01-22T15:04:05.923Z
9208162 9208162 20260115042237_aQUxK UK00C1 2026-01-16T14:11:33.819Z 2026-01-22T15:04:02.688Z
9208131 9208131 20260115041813_2FMUk UK00C1 2026-01-16T14:11:24.866Z 2026-01-22T15:04:02.003Z
9208080 9208080 20260115041004_X63rD UK00C1 2026-01-16T14:11:14.842Z 2026-01-22T15:04:00.675Z
9208055 9208055 20260115040601_BEnzn UK00C1 2026-01-16T14:11:09.018Z 2026-01-22T15:03:59.908Z
9208009 9208009 20260115035419_Vta9R UK00C1 2026-01-16T14:10:58.232Z 2026-01-22T15:03:58.483Z
9207975 9207975 20260115034138_oZMYp UK00C1 2026-01-16T14:10:52.560Z 2026-01-22T15:03:57.750Z
9207680 9207680 20260115024110_HjYKk UK00C1 2026-01-16T14:09:37.874Z 2026-01-22T15:03:29.626Z
9207661 9207661 20260115024024_xeJ76 UK00C1 2026-01-16T14:09:35.472Z 2026-01-22T15:03:29.371Z
9207621 9207621 20260115022948_wcmUv UK00C1 2026-01-16T14:09:25.278Z 2026-01-22T15:03:28.100Z
9207556 9207556 20260115021532_LeJ18 UK00C1 2026-01-16T14:09:13.932Z 2026-01-22T15:03:24.883Z
9207471 9207471 20260115014535_cEYtx UK00C1 2026-01-16T14:08:53.748Z 2026-01-22T15:03:22.774Z
9207464 9207464 20260115014357_An0LJ UK00C1 2026-01-16T14:08:51.313Z 2026-01-22T15:03:22.510Z
9207412 9207412 20260115013230_Yxhf8 UK00C1 2026-01-16T14:08:39.829Z 2026-01-22T15:03:21.234Z
9207382 9207382 20260115011922_C0uhy UK00C1 2026-01-16T14:08:31.802Z 2026-01-22T15:03:20.422Z
9207351 9207351 20260115010747_a1sOs UK00C1 2026-01-16T14:08:22.770Z 2026-01-22T15:03:19.578Z
9207271 9207271 20260115003200_uoJde UK00C1 2026-01-16T14:08:02.127Z 2026-01-22T15:03:16.920Z
9204489 9204489 20260114064732_HmOTB UK00C1 2026-01-15T14:27:25.941Z 2026-01-22T15:10:29.581Z
9204085 9204085 20260114060535_vKFHf UK00C1 2026-01-15T14:26:21.984Z 2026-01-22T15:10:17.707Z
9203908 9203908 20260114055221_Vgrup UK00C1 2026-01-15T14:25:50.313Z 2026-01-22T15:10:15.386Z
9203496 9203496 20260114050910_VM62F UK00C1 2026-01-15T14:24:34.192Z 2026-01-22T15:10:08.703Z
9203327 9203327 20260114045027_qyXsS UK00C1 2026-01-15T14:24:03.483Z 2026-01-22T15:10:05.701Z
9203098 9203098 20260114043249_jetAf UK00C1 2026-01-15T14:23:17.615Z 2026-01-22T15:10:01.407Z
9202870 9202870 20260114041403_oVo5B UK00C1 2026-01-15T14:22:40.389Z 2026-01-22T15:09:58.294Z
9202738 9202738 20260114040637_kfNnc UK00C1 2026-01-15T14:22:16.406Z 2026-01-22T15:09:34.290Z
9202527 9202527 20260114034432_FOhnA UK00C1 2026-01-15T14:21:34.366Z 2026-01-22T15:09:21.688Z
9202493 9202493 20260114034225_L8opz UK00C1 2026-01-15T14:21:31.052Z 2026-01-22T15:09:21.267Z
9202451 9202451 20260114033811_gHrAD UK00C1 2026-01-15T14:21:19.310Z 2026-01-22T15:09:19.389Z
9202310 9202310 20260114032713_xoe10 UK00C1 2026-01-15T14:21:02.377Z 2026-01-22T15:09:16.135Z
9202243 9202243 20260114032429_gSKye UK00C1 2026-01-15T14:20:44.073Z 2026-01-22T15:09:15.124Z
9202146 9202146 20260114032011_msxWS UK00C1 2026-01-15T14:20:35.093Z 2026-01-22T15:09:14.061Z
9202042 9202042 20260114031230_qz3FI UK00C1 2026-01-15T14:20:16.816Z 2026-01-22T15:09:12.317Z
9201949 9201949 20260114030717_F9aeY UK00C1 2026-01-15T14:20:09.975Z 2026-01-22T15:09:11.652Z
9201669 9201669 20260114024102_e40PR UK00C1 2026-01-15T14:19:16.322Z 2026-01-22T15:09:07.228Z
9201262 9201262 20260114020217_TyLM9 UK00C1 2026-01-15T14:18:06.102Z 2026-01-22T15:09:00.678Z
9201125 9201125 20260114014645_U3Z0P UK00C1 2026-01-15T14:17:35.612Z 2026-01-22T15:08:58.042Z
9201110 9201110 20260114014247_ydBzl UK00C1 2026-01-15T14:17:33.949Z 2026-01-22T15:08:57.782Z
9201013 9201013 20260114012957_GTQfp UK00C1 2026-01-15T14:17:12.767Z 2026-01-22T15:08:48.402Z
9200970 9200970 20260114012554_kOdIv UK00C1 2026-01-15T14:17:06.611Z 2026-01-22T15:08:40.840Z
9200592 9200592 20260114003008_yHT2V UK00C1 2026-01-15T14:15:42.650Z 2026-01-22T15:08:21.271Z
9200424 9200424 20260114000624_x1VEn UK00C1 2026-01-15T14:15:10.540Z 2026-01-22T15:08:15.738Z
9200255 9200255 20260113232703_NCen7 UK00C1 2026-01-15T14:14:23.285Z 2026-01-22T15:08:12.330Z
9200066 9200066 20260113224721_8g23B UK00C1 2026-01-15T14:13:41.943Z 2026-01-22T15:08:09.063Z
9198990 9198990 20260113184701_1OmjL UK00C1 2026-01-15T14:08:42.910Z 2026-01-22T15:07:11.082Z
9198730 9198730 20260113174501_x5voj UK00C1 2026-01-15T14:06:46.314Z 2026-01-22T15:07:02.138Z
9195652 9195652 20260113021057_OPhUI UK00C1 2026-01-14T14:14:16.455Z 2026-01-21T15:04:44.986Z
9195376 9195376 20260113011330_K2N2w UK00C1 2026-01-14T14:13:05.908Z 2026-01-21T15:04:39.646Z
9195308 9195308 20260113010000_Egx31 UK00C1 2026-01-14T14:12:49.061Z 2026-01-21T15:04:38.861Z
9195061 9195061 20260113000854_qBOA3 UK00C1 2026-01-14T14:11:51.655Z 2026-01-21T15:04:35.680Z
9195025 9195025 20260113000018_FAh3e UK00C1 2026-01-14T14:11:43.651Z 2026-01-21T15:04:35.216Z
9195023 9195023 20260112235937_fCxGl UK00C1 2026-01-14T14:11:42.929Z 2026-01-21T15:04:35.164Z
9176437 9176437 20260110052946_p1mUg UK00C1 2026-01-11T14:09:00.905Z 2026-01-18T15:08:39.098Z
9175506 9175506 20260110023943_o2hFO UK00C1 2026-01-11T14:06:34.260Z 2026-01-18T15:07:47.601Z
9175465 9175465 20260110023310_BAPdp UK00C1 2026-01-11T14:06:29.592Z 2026-01-18T15:07:46.577Z
9175422 9175422 20260110022528_isknY UK00C1 2026-01-11T14:06:23.086Z 2026-01-18T15:07:44.951Z
9175338 9175338 20260110020542_2vre8 UK00C1 2026-01-11T14:06:05.754Z 2026-01-18T15:07:41.448Z
9175205 9175205 20260110013614_Sc5BN UK00C1 2026-01-11T14:05:40.768Z 2026-01-18T15:07:36.781Z
9175078 9175078 20260110010139_XgyS9 UK00C1 2026-01-11T14:05:20.031Z 2026-01-18T15:07:25.182Z
9175057 9175057 20260110005303_E42pZ UK00C1 2026-01-11T14:05:17.586Z 2026-01-18T15:07:24.527Z
9175035 9175035 20260110004758_2Wc5l UK00C1 2026-01-11T14:05:12.667Z 2026-01-18T15:07:23.583Z
9175014 9175014 20260110004558_pftd6 UK00C1 2026-01-11T14:05:08.554Z 2026-01-18T15:07:22.935Z
9174999 9174999 20260110003947_uCPkF UK00C1 2026-01-11T14:05:05.651Z 2026-01-18T15:07:21.275Z
9174896 9174896 20260109234829_mVQNu UK00C1 2026-01-11T14:04:46.362Z 2026-01-18T15:07:15.874Z
9174758 9174758 20260109222031_P0yps UK00C1 2026-01-11T14:04:16.961Z 2026-01-18T15:07:09.457Z
9174530 9174530 20260109195848_hy7At UK00C1 2026-01-11T14:03:30.553Z 2026-01-18T15:06:49.909Z
9167132 9167132 20260107225654_NiPH1 UK00C1 2026-01-09T14:06:22.868Z 2026-01-16T15:10:51.484Z
9159068 9159068 20260106013859_vVdbe UK00C1 2026-01-07T14:08:12.846Z 2026-01-13T15:07:59.358Z
9158802 9158802 20260106003405_QTyBT UK00C1 2026-01-07T14:07:21.370Z 2026-01-13T15:07:47.169Z
9158484 9158484 20260105224036_gJtpd UK00C1 2026-01-07T14:06:15.153Z 2026-01-13T15:07:24.333Z
9158302 9158302 20260105214723_3TDG2 UK00C1 2026-01-07T14:05:43.142Z 2026-01-13T15:07:17.613Z
9158121 9158121 20260105200843_a1CpA UK00C1 2026-01-07T14:04:55.590Z 2026-01-13T15:06:56.288Z
9158077 9158077 20260105195710_fZjPh UK00C1 2026-01-07T14:04:44.495Z 2026-01-13T15:06:53.701Z
9157941 9157941 20260105193053_UCc3c UK00C1 2026-01-07T14:04:15.439Z 2026-01-13T15:06:46.983Z
9157839 9157839 20260105185854_ZcSiH UK00C1 2026-01-07T14:03:48.655Z 2026-01-13T15:06:33.932Z

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