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

4,378 rows where station_code = "UK005L" 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
8676870 8676870 20251202062834_wXBla UK005L 2025-12-03T14:25:54.315Z 2025-12-06T14:35:29.998Z
8676847 8676847 20251202062759_i9Ph2 UK005L 2025-12-03T14:25:52.815Z 2025-12-06T14:35:29.603Z
8676794 8676794 20251202062627_fBsOx UK005L 2025-12-03T14:25:40.360Z 2025-12-06T14:35:28.926Z
8676741 8676741 20251202062030_g0RX2 UK005L 2025-12-03T14:25:32.283Z 2025-12-06T14:35:28.070Z
8676677 8676677 20251202061146_hjmEM UK005L 2025-12-03T14:25:25.849Z 2025-12-06T14:35:26.959Z
8676655 8676655 20251202061034_pIsdl UK005L 2025-12-03T14:25:24.596Z 2025-12-06T14:35:26.335Z
8676628 8676628 20251202060933_T3bUR UK005L 2025-12-03T14:25:22.800Z 2025-12-06T14:35:25.148Z
8676438 8676438 20251202055303_rJE7O UK005L 2025-12-03T14:25:12.734Z 2025-12-06T14:35:21.800Z
8676417 8676417 20251202055148_BwZvy UK005L 2025-12-03T14:25:11.972Z 2025-12-06T14:35:21.528Z
8676287 8676287 20251202054442_6oaPE UK005L 2025-12-03T14:24:57.050Z 2025-12-06T14:35:19.637Z
8676166 8676166 20251202053942_XoT3u UK005L 2025-12-03T14:24:47.969Z 2025-12-06T14:35:17.997Z
8676016 8676016 20251202053251_hEamB UK005L 2025-12-03T14:24:36.265Z 2025-12-06T14:35:06.646Z
8676001 8676001 20251202053053_619Iu UK005L 2025-12-03T14:24:35.700Z 2025-12-06T14:35:06.422Z
8675979 8675979 20251202052834_5X6sK UK005L 2025-12-03T14:24:34.937Z 2025-12-06T14:35:06.200Z
8675912 8675912 20251202052257_DArRJ UK005L 2025-12-03T14:24:29.974Z 2025-12-06T14:35:04.714Z
8675852 8675852 20251202051854_2wpXN UK005L 2025-12-03T14:24:26.186Z 2025-12-06T14:35:03.420Z
8675797 8675797 20251202051517_lHN9U UK005L 2025-12-03T14:24:15.856Z 2025-12-06T14:35:00.423Z
8675660 8675660 20251202050440_IjvhH UK005L 2025-12-03T14:23:59.208Z 2025-12-06T14:34:57.833Z
8675541 8675541 20251202045557_6jwAO UK005L 2025-12-03T14:23:50.825Z 2025-12-06T14:34:56.023Z
8675342 8675342 20251202043004_dPeUY UK005L 2025-12-03T14:23:32.179Z 2025-12-06T14:34:49.827Z
8674554 8674554 20251202024751_6uxkr UK005L 2025-12-03T14:22:00.498Z 2025-12-06T14:34:11.984Z
8674539 8674539 20251202024330_YrlcO UK005L 2025-12-03T14:21:46.577Z 2025-12-06T14:34:11.441Z
8673884 8673884 20251202001700_5fMiy UK005L 2025-12-03T14:20:14.895Z 2025-12-06T14:33:39.345Z
8673875 8673875 20251202001019_7X0ts UK005L 2025-12-03T14:20:13.377Z 2025-12-06T14:33:38.659Z
8673777 8673777 20251201230314_K0KUQ UK005L 2025-12-03T14:20:01.753Z 2025-12-06T14:33:33.981Z
8673771 8673771 20251201230144_Wa2vC UK005L 2025-12-03T14:20:01.228Z 2025-12-06T14:33:33.770Z
8673761 8673761 20251201224206_QN3pb UK005L 2025-12-03T14:19:59.502Z 2025-12-06T14:33:32.616Z
8667304 8667304 20251129222235_vA3bj UK005L 2025-12-02T14:36:41.662Z 2025-12-06T14:46:37.823Z
8667298 8667298 20251129211742_fB6dU UK005L 2025-12-02T14:36:34.325Z 2025-12-06T14:46:32.919Z
8658111 8658111 20251130064213_NU3HU UK005L 2025-12-01T14:34:55.479Z 2025-12-06T14:50:26.771Z
8658016 8658016 20251130062857_neUUl UK005L 2025-12-01T14:34:50.079Z 2025-12-06T14:50:25.240Z
8657886 8657886 20251130061417_O8PyF UK005L 2025-12-01T14:34:44.661Z 2025-12-06T14:50:23.473Z
8657740 8657740 20251130060420_J1Vss UK005L 2025-12-01T14:34:39.618Z 2025-12-06T14:50:22.121Z
8657706 8657706 20251130060141_UOf6p UK005L 2025-12-01T14:34:38.768Z 2025-12-06T14:50:21.784Z
8657691 8657691 20251130060057_Uh59I UK005L 2025-12-01T14:34:38.613Z 2025-12-06T14:50:21.266Z
8657572 8657572 20251130055308_K8OsG UK005L 2025-12-01T14:34:33.566Z 2025-12-06T14:50:12.261Z
8657410 8657410 20251130054333_w6iI2 UK005L 2025-12-01T14:34:23.191Z 2025-12-06T14:49:58.549Z
8657340 8657340 20251130053946_Tq5TP UK005L 2025-12-01T14:34:07.577Z 2025-12-06T14:49:53.155Z
8657236 8657236 20251130053609_xUeUx UK005L 2025-12-01T14:34:02.327Z 2025-12-06T14:49:47.338Z
8657108 8657108 20251130053042_lhFBN UK005L 2025-12-01T14:33:54.828Z 2025-12-06T14:49:44.898Z
8656933 8656933 20251130051838_Tiv6C UK005L 2025-12-01T14:33:49.351Z 2025-12-06T14:49:42.976Z
8656596 8656596 20251130050049_v70Ll UK005L 2025-12-01T14:28:46.613Z 2025-12-06T14:49:36.701Z
8656151 8656151 20251130044007_nc34g UK005L 2025-12-01T14:28:06.758Z 2025-12-06T14:49:31.557Z
8655935 8655935 20251130042541_Zo7Ss UK005L 2025-12-01T14:27:41.515Z 2025-12-06T14:49:29.191Z
8655702 8655702 20251130041158_vrx7E UK005L 2025-12-01T14:27:21.692Z 2025-12-06T14:49:26.669Z
8655595 8655595 20251130040815_GqLlJ UK005L 2025-12-01T14:27:15.360Z 2025-12-06T14:49:25.705Z
8655546 8655546 20251130040648_Wzx2z UK005L 2025-12-01T14:27:02.794Z 2025-12-06T14:49:25.115Z
8655523 8655523 20251130040628_6jytl UK005L 2025-12-01T14:27:02.138Z 2025-12-06T14:49:24.928Z
8655443 8655443 20251130040216_pg5fn UK005L 2025-12-01T14:26:54.316Z 2025-12-06T14:49:16.830Z
8655236 8655236 20251130035002_brxYT UK005L 2025-12-01T14:26:41.013Z 2025-12-06T14:48:56.575Z
8655118 8655118 20251130034514_3lwWx UK005L 2025-12-01T14:26:24.055Z 2025-12-06T14:48:51.656Z
8654682 8654682 20251130032545_trfOA UK005L 2025-12-01T14:25:43.905Z 2025-12-06T14:48:45.647Z
8654571 8654571 20251130032031_09TIJ UK005L 2025-12-01T14:25:35.074Z 2025-12-06T14:48:44.126Z
8654489 8654489 20251130031821_3lSPZ UK005L 2025-12-01T14:25:29.159Z 2025-12-01T14:25:29.159Z
8654398 8654398 20251130031444_0DyC2 UK005L 2025-12-01T14:25:22.765Z 2025-12-06T14:48:42.001Z
8654183 8654183 20251130030236_i5D2b UK005L 2025-12-01T14:24:56.912Z 2025-12-06T14:48:38.543Z
8654146 8654146 20251130030122_P3pIF UK005L 2025-12-01T14:24:54.890Z 2025-12-06T14:48:38.156Z
8654089 8654089 20251130025715_R2cwn UK005L 2025-12-01T14:24:50.112Z 2025-12-06T14:48:37.127Z
8654080 8654080 20251130025610_k6sd6 UK005L 2025-12-01T14:24:49.253Z 2025-12-06T14:48:37.008Z
8654003 8654003 20251130025159_qoEtY UK005L 2025-12-01T14:24:44.380Z 2025-12-06T14:48:35.955Z
8653932 8653932 20251130024833_7iCgP UK005L 2025-12-01T14:24:30.501Z 2025-12-06T14:48:34.645Z
8653582 8653582 20251130022707_weCm0 UK005L 2025-12-01T14:23:44.019Z 2025-12-06T14:48:18.926Z
8653251 8653251 20251130020508_ZVmWw UK005L 2025-12-01T14:23:07.833Z 2025-12-06T14:47:52.290Z
8653226 8653226 20251130020355_yr6i0 UK005L 2025-12-01T14:23:06.370Z 2025-12-06T14:47:51.809Z
8652963 8652963 20251130014804_2B2Nm UK005L 2025-12-01T14:22:35.487Z 2025-12-06T14:47:47.069Z
8652828 8652828 20251130013652_eJE9k UK005L 2025-12-01T14:22:12.385Z 2025-12-06T14:47:43.050Z
8652740 8652740 20251130012954_D6LL5 UK005L 2025-12-01T14:22:03.515Z 2025-12-06T14:47:41.748Z
8652658 8652658 20251130012633_PA0ew UK005L 2025-12-01T14:21:56.191Z 2025-12-06T14:47:40.709Z
8652626 8652626 20251130012501_9mbQ1 UK005L 2025-12-01T14:21:53.072Z 2025-12-06T14:47:40.364Z
8652574 8652574 20251130012218_zuePk UK005L 2025-12-01T14:21:43.899Z 2025-12-06T14:47:39.628Z
8652545 8652545 20251130011821_2gizD UK005L 2025-12-01T14:21:40.188Z 2025-12-06T14:47:38.836Z
8652481 8652481 20251130011229_26Ur0 UK005L 2025-12-01T14:21:29.968Z 2025-12-06T14:47:37.669Z
8652349 8652349 20251130010357_z43NI UK005L 2025-12-01T14:21:17.257Z 2025-12-06T14:47:35.905Z
8652251 8652251 20251130005844_8DUzW UK005L 2025-12-01T14:21:03.056Z 2025-12-06T14:47:32.913Z
8652187 8652187 20251130005418_2R3Z3 UK005L 2025-12-01T14:20:53.716Z 2025-12-06T14:47:29.262Z
8652127 8652127 20251130004916_tLlCX UK005L 2025-12-01T14:20:46.756Z 2025-12-06T14:47:21.573Z
8651903 8651903 20251130003243_fcdgj UK005L 2025-12-01T14:20:14.676Z 2025-12-06T14:46:55.964Z
8651806 8651806 20251130002042_BaekV UK005L 2025-12-01T14:19:57.583Z 2025-12-06T14:46:54.277Z
8651776 8651776 20251130001756_3yTNn UK005L 2025-12-01T14:19:52.385Z 2025-12-06T14:46:53.769Z
8651748 8651748 20251130001635_FDdU7 UK005L 2025-12-01T14:19:49.199Z 2025-12-06T14:46:53.384Z
8651523 8651523 20251129235339_WXO5c UK005L 2025-12-01T14:19:15.976Z 2025-12-06T14:46:47.786Z
8651500 8651500 20251129234851_7y4wK UK005L 2025-12-01T14:19:13.461Z 2025-12-06T14:46:47.569Z
8651257 8651257 20251129231515_SkSL2 UK005L 2025-12-01T14:18:29.575Z 2025-12-06T14:46:42.653Z
8651246 8651246 20251129231135_49eeD UK005L 2025-12-01T14:18:28.492Z 2025-12-06T14:46:42.458Z
8651225 8651225 20251129230939_Fy3sG UK005L 2025-12-01T14:18:26.175Z 2025-12-06T14:46:42.171Z
8651220 8651220 20251129230908_qRCLi UK005L 2025-12-01T14:18:25.680Z 2025-12-06T14:46:42.122Z
8651155 8651155 20251129225228_8Vrjk UK005L 2025-12-01T14:18:08.929Z 2025-12-06T14:46:40.891Z
8651128 8651128 20251129224625_Ln573 UK005L 2025-12-01T14:18:04.315Z 2025-12-06T14:46:40.509Z
8650988 8650988 20251129222235_wJlbx UK005L 2025-12-01T14:17:43.542Z 2025-12-01T14:35:21.446Z
8650969 8650969 20251129221812_rwaH6 UK005L 2025-12-01T14:17:39.195Z 2025-12-06T14:46:37.322Z
8650897 8650897 20251129215938_Q4RwG UK005L 2025-12-01T14:17:29.383Z 2025-12-06T14:46:35.614Z
8650839 8650839 20251129213938_q0Uzv UK005L 2025-12-01T14:17:17.169Z 2025-12-06T14:46:34.549Z
8650802 8650802 20251129213347_67EGO UK005L 2025-12-01T14:17:12.563Z 2025-12-06T14:46:34.099Z
8650787 8650787 20251129212707_rfD8t UK005L 2025-12-01T14:17:10.533Z 2025-12-06T14:46:33.762Z
8650562 8650562 20251129204119_ZnC7J UK005L 2025-12-01T14:16:28.898Z 2025-12-06T14:46:12.738Z
8650124 8650124 20251129192835_3abtN UK005L 2025-12-01T14:15:08.605Z 2025-12-06T14:45:48.683Z
8649925 8649925 20251129185321_t04RW UK005L 2025-12-01T14:14:27.944Z 2025-12-06T14:45:43.196Z
8637736 8637736 20251128062841_P3ig0 UK005L 2025-11-29T14:27:47.122Z 2025-12-06T15:04:03.644Z
8637621 8637621 20251128060018_Doxzy UK005L 2025-11-29T14:27:37.827Z 2025-12-06T15:04:01.769Z
8637478 8637478 20251128054401_dvOgC UK005L 2025-11-29T14:27:29.835Z 2025-12-06T15:04:00.496Z

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