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,354 rows where station_code = "UK008J" 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
8683225 8683225 20251203064326_Uh2Qq UK008J 2025-12-04T14:18:58.110Z 2025-12-05T14:23:12.166Z
8683086 8683086 20251203062616_3I3KG UK008J 2025-12-04T14:18:34.318Z 2025-12-05T14:23:07.685Z
8682981 8682981 20251203061840_2n14J UK008J 2025-12-04T14:18:26.216Z 2025-12-05T14:23:04.695Z
8682947 8682947 20251203061657_htRba UK008J 2025-12-04T14:18:23.389Z 2025-12-05T14:23:03.828Z
8682817 8682817 20251203060704_fkl1Q UK008J 2025-12-04T14:18:03.707Z 2025-12-05T14:22:53.178Z
8682056 8682056 20251203044552_bvOMY UK008J 2025-12-04T14:16:17.911Z 2025-12-05T14:22:13.074Z
8681375 8681375 20251203030138_keE2i UK008J 2025-12-04T14:14:35.807Z 2025-12-05T14:21:34.557Z
8681332 8681332 20251203025745_olBOe UK008J 2025-12-04T14:14:31.870Z 2025-12-05T14:21:33.349Z
8681278 8681278 20251203025225_t5qDJ UK008J 2025-12-04T14:14:14.902Z 2025-12-05T14:21:30.248Z
8680697 8680697 20251203010652_cFYcd UK008J 2025-12-04T14:12:45.976Z 2025-12-05T14:20:52.901Z
8680112 8680112 20251202214107_8tqR9 UK008J 2025-12-04T14:11:07.114Z 2025-12-05T14:20:17.820Z
8676874 8676874 20251202062834_wXBla UK008J 2025-12-03T14:25:54.315Z 2025-12-05T14:29:15.318Z
8676773 8676773 20251202062414_HIzOj UK008J 2025-12-03T14:25:34.351Z 2025-12-05T14:29:13.192Z
8676744 8676744 20251202062030_g0RX2 UK008J 2025-12-03T14:25:32.283Z 2025-12-05T14:29:12.354Z
8676707 8676707 20251202061516_X5jAV UK008J 2025-12-03T14:25:27.105Z 2025-12-05T14:29:11.174Z
8676440 8676440 20251202055303_rJE7O UK008J 2025-12-03T14:25:12.734Z 2025-12-05T14:28:56.468Z
8676421 8676421 20251202055148_BwZvy UK008J 2025-12-03T14:25:11.972Z 2025-12-05T14:28:56.189Z
8676290 8676290 20251202054442_6oaPE UK008J 2025-12-03T14:24:57.050Z 2025-12-05T14:28:53.844Z
8676169 8676169 20251202053942_XoT3u UK008J 2025-12-03T14:24:47.969Z 2025-12-05T14:28:49.808Z
8676051 8676051 20251202053410_JoXh5 UK008J 2025-12-03T14:24:38.311Z 2025-12-05T14:28:47.152Z
8675663 8675663 20251202050440_IjvhH UK008J 2025-12-03T14:23:59.208Z 2025-12-05T14:28:37.573Z
8675356 8675356 20251202043132_w7ZIK UK008J 2025-12-03T14:23:33.657Z 2025-12-05T14:28:20.907Z
8675296 8675296 20251202042601_vsoN5 UK008J 2025-12-03T14:23:30.010Z 2025-12-05T14:28:19.345Z
8675028 8675028 20251202035409_3obmf UK008J 2025-12-03T14:22:51.881Z 2025-12-05T14:28:09.706Z
8674965 8674965 20251202034514_bEb57 UK008J 2025-12-03T14:22:46.932Z 2025-12-05T14:28:07.984Z
8674893 8674893 20251202033652_pT7HE UK008J 2025-12-03T14:22:40.649Z 2025-12-05T14:28:05.953Z
8674832 8674832 20251202032821_Exk2D UK008J 2025-12-03T14:22:27.759Z 2025-12-05T14:28:03.995Z
8674727 8674727 20251202031440_owsin UK008J 2025-12-03T14:22:15.908Z 2025-12-05T14:28:01.134Z
8674556 8674556 20251202024751_6uxkr UK008J 2025-12-03T14:22:00.498Z 2025-12-05T14:27:55.674Z
8674540 8674540 20251202024330_YrlcO UK008J 2025-12-03T14:21:46.577Z 2025-12-05T14:27:54.777Z
8674499 8674499 20251202023659_SkhVu UK008J 2025-12-03T14:21:42.618Z 2025-12-05T14:27:44.988Z
8674485 8674485 20251202023306_d0ZQJ UK008J 2025-12-03T14:21:41.830Z 2025-12-05T14:27:42.991Z
8674376 8674376 20251202021337_rXUfK UK008J 2025-12-03T14:21:33.165Z 2025-12-05T14:27:39.562Z
8674219 8674219 20251202014759_9JXrz UK008J 2025-12-03T14:21:10.860Z 2025-12-05T14:27:32.923Z
8673841 8673841 20251201235812_BjBhz UK008J 2025-12-03T14:20:10.363Z 2025-12-05T14:27:19.566Z
8673780 8673780 20251201230314_K0KUQ UK008J 2025-12-03T14:20:01.784Z 2025-12-05T14:27:14.576Z
8673772 8673772 20251201230144_Wa2vC UK008J 2025-12-03T14:20:01.228Z 2025-12-05T14:27:14.390Z
8667360 8667360 20251130001756_LUoqu UK008J 2025-12-02T14:37:25.417Z 2025-12-05T14:42:05.792Z
8667305 8667305 20251129222235_vA3bj UK008J 2025-12-02T14:36:41.662Z 2025-12-05T14:41:26.118Z
8658114 8658114 20251130064213_NU3HU UK008J 2025-12-01T14:34:55.479Z 2025-12-05T14:46:02.864Z
8658019 8658019 20251130062857_neUUl UK008J 2025-12-01T14:34:50.079Z 2025-12-05T14:46:00.536Z
8657994 8657994 20251130062447_Y3ev9 UK008J 2025-12-01T14:34:48.952Z 2025-12-05T14:45:59.947Z
8657888 8657888 20251130061417_O8PyF UK008J 2025-12-01T14:34:44.661Z 2025-12-05T14:45:52.326Z
8657696 8657696 20251130060057_Uh59I UK008J 2025-12-01T14:34:38.613Z 2025-12-05T14:45:35.625Z
8657574 8657574 20251130055308_K8OsG UK008J 2025-12-01T14:34:33.566Z 2025-12-05T14:45:33.544Z
8657343 8657343 20251130053946_Tq5TP UK008J 2025-12-01T14:34:07.577Z 2025-12-05T14:45:28.409Z
8656937 8656937 20251130051838_Tiv6C UK008J 2025-12-01T14:33:49.352Z 2025-12-05T14:45:23.397Z
8656774 8656774 20251130050920_oDi0z UK008J 2025-12-01T14:28:59.866Z 2025-12-05T14:45:21.023Z
8656599 8656599 20251130050049_v70Ll UK008J 2025-12-01T14:28:46.613Z 2025-12-05T14:45:18.175Z
8656209 8656209 20251130044349_H96M9 UK008J 2025-12-01T14:28:10.677Z 2025-12-05T14:44:47.962Z
8656153 8656153 20251130044007_nc34g UK008J 2025-12-01T14:28:06.758Z 2025-12-05T14:44:46.798Z
8655936 8655936 20251130042541_Zo7Ss UK008J 2025-12-01T14:27:41.516Z 2025-12-05T14:44:41.278Z
8655704 8655704 20251130041158_vrx7E UK008J 2025-12-01T14:27:21.692Z 2025-12-05T14:44:37.255Z
8655597 8655597 20251130040815_GqLlJ UK008J 2025-12-01T14:27:15.360Z 2025-12-05T14:44:36.044Z
8655525 8655525 20251130040628_6jytl UK008J 2025-12-01T14:27:02.138Z 2025-12-05T14:44:34.902Z
8655447 8655447 20251130040216_pg5fn UK008J 2025-12-01T14:26:54.316Z 2025-12-05T14:44:33.693Z
8655302 8655302 20251130035347_dHxxi UK008J 2025-12-01T14:26:44.532Z 2025-12-05T14:44:31.625Z
8654663 8654663 20251130032455_hrwcX UK008J 2025-12-01T14:25:42.517Z 2025-12-05T14:44:19.991Z
8654573 8654573 20251130032031_09TIJ UK008J 2025-12-01T14:25:35.074Z 2025-12-05T14:44:12.321Z
8654490 8654490 20251130031821_3lSPZ UK008J 2025-12-01T14:25:29.159Z 2025-12-01T14:25:29.159Z
8654399 8654399 20251130031444_0DyC2 UK008J 2025-12-01T14:25:22.765Z 2025-12-05T14:43:55.190Z
8654267 8654267 20251130030706_bvFzu UK008J 2025-12-01T14:25:03.706Z 2025-12-05T14:43:52.407Z
8654187 8654187 20251130030236_i5D2b UK008J 2025-12-01T14:24:56.912Z 2025-12-05T14:43:48.584Z
8654006 8654006 20251130025159_qoEtY UK008J 2025-12-01T14:24:44.380Z 2025-12-05T14:43:44.939Z
8653253 8653253 20251130020508_ZVmWw UK008J 2025-12-01T14:23:07.833Z 2025-12-05T14:43:06.662Z
8653232 8653232 20251130020355_yr6i0 UK008J 2025-12-01T14:23:06.388Z 2025-12-05T14:43:05.977Z
8652964 8652964 20251130014804_2B2Nm UK008J 2025-12-01T14:22:35.487Z 2025-12-05T14:42:58.390Z
8652742 8652742 20251130012954_D6LL5 UK008J 2025-12-01T14:22:03.515Z 2025-12-05T14:42:51.324Z
8652718 8652718 20251130012839_FiUaZ UK008J 2025-12-01T14:22:01.729Z 2025-12-05T14:42:50.783Z
8652643 8652643 20251130012603_acxvx UK008J 2025-12-01T14:21:55.175Z 2025-12-05T14:42:49.348Z
8652628 8652628 20251130012501_9mbQ1 UK008J 2025-12-01T14:21:53.072Z 2025-12-05T14:42:48.927Z
8652603 8652603 20251130012250_ulDaA UK008J 2025-12-01T14:21:51.162Z 2025-12-05T14:42:48.561Z
8652483 8652483 20251130011229_26Ur0 UK008J 2025-12-01T14:21:29.968Z 2025-12-05T14:42:45.523Z
8652350 8652350 20251130010357_z43NI UK008J 2025-12-01T14:21:17.257Z 2025-12-05T14:42:43.019Z
8652188 8652188 20251130005418_2R3Z3 UK008J 2025-12-01T14:20:53.716Z 2025-12-05T14:42:31.285Z
8652130 8652130 20251130004916_tLlCX UK008J 2025-12-01T14:20:46.756Z 2025-12-05T14:42:25.780Z
8651905 8651905 20251130003243_fcdgj UK008J 2025-12-01T14:20:14.677Z 2025-12-05T14:42:11.050Z
8651778 8651778 20251130001756_3yTNn UK008J 2025-12-01T14:19:52.385Z 2025-12-05T14:42:05.845Z
8651752 8651752 20251130001635_FDdU7 UK008J 2025-12-01T14:19:49.199Z 2025-12-05T14:42:05.095Z
8651724 8651724 20251130001418_N0TZa UK008J 2025-12-01T14:19:45.703Z 2025-12-05T14:42:04.495Z
8651525 8651525 20251129235339_WXO5c UK008J 2025-12-01T14:19:15.976Z 2025-12-05T14:41:59.716Z
8651258 8651258 20251129231515_SkSL2 UK008J 2025-12-01T14:18:29.575Z 2025-12-05T14:41:53.145Z
8651156 8651156 20251129225228_8Vrjk UK008J 2025-12-01T14:18:08.929Z 2025-12-05T14:41:50.405Z
8651130 8651130 20251129224625_Ln573 UK008J 2025-12-01T14:18:04.315Z 2025-12-05T14:41:49.777Z
8650989 8650989 20251129222235_wJlbx UK008J 2025-12-01T14:17:43.542Z 2025-12-01T14:35:21.446Z
8650898 8650898 20251129215938_Q4RwG UK008J 2025-12-01T14:17:29.383Z 2025-12-05T14:41:22.180Z
8650840 8650840 20251129213938_q0Uzv UK008J 2025-12-01T14:17:17.169Z 2025-12-05T14:41:20.731Z
8650832 8650832 20251129213905_1csEq UK008J 2025-12-01T14:17:16.657Z 2025-12-05T14:41:20.617Z
8650804 8650804 20251129213347_67EGO UK008J 2025-12-01T14:17:12.563Z 2025-12-05T14:41:17.977Z
8650126 8650126 20251129192835_3abtN UK008J 2025-12-01T14:15:08.605Z 2025-12-05T14:40:57.235Z
8650017 8650017 20251129190706_o2WrO UK008J 2025-12-01T14:14:42.950Z 2025-12-05T14:40:49.526Z
8649899 8649899 20251129184941_CiKAt UK008J 2025-12-01T14:14:16.634Z 2025-12-05T14:40:26.351Z
8637615 8637615 20251128055952_3q2Ed UK008J 2025-11-29T14:27:37.702Z 2025-12-05T15:00:10.428Z
8637479 8637479 20251128054401_dvOgC UK008J 2025-11-29T14:27:29.835Z 2025-12-05T14:59:55.682Z
8637285 8637285 20251128052524_wBc37 UK008J 2025-11-29T14:27:03.044Z 2025-12-05T14:59:39.851Z
8637242 8637242 20251128051821_oKngv UK008J 2025-11-29T14:27:00.122Z 2025-12-05T14:59:39.102Z
8637216 8637216 20251128051634_2GqEc UK008J 2025-11-29T14:26:58.600Z 2025-12-05T14:59:38.912Z
8633448 8633448 20251127231833_lM7A0 UK008J 2025-11-29T14:19:43.766Z 2025-12-05T14:57:40.096Z
8633331 8633331 20251127230533_U5mM8 UK008J 2025-11-29T14:19:27.154Z 2025-12-05T14:57:30.441Z
8633204 8633204 20251127225145_0jHRR UK008J 2025-11-29T14:19:14.023Z 2025-12-05T14:57:18.374Z

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