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

8,829 rows where station_code = "UK00AL" 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
8691437 8691437 20251205053458_FRYad UK00AL 2025-12-06T14:17:46.571Z 2025-12-06T14:18:01.114Z
8691407 8691407 20251205051528_ZMMeE UK00AL 2025-12-06T14:17:40.983Z 2025-12-06T14:18:01.105Z
8691342 8691342 20251205044959_tjRey UK00AL 2025-12-06T14:17:25.436Z 2025-12-06T14:18:01.091Z
8691274 8691274 20251205042105_gzFAB UK00AL 2025-12-06T14:17:05.542Z 2025-12-06T14:18:01.074Z
8691216 8691216 20251205040830_maG5g UK00AL 2025-12-06T14:16:54.836Z 2025-12-06T14:18:01.061Z
8691178 8691178 20251205035849_I2HY7 UK00AL 2025-12-06T14:16:48.383Z 2025-12-06T14:18:01.050Z
8691166 8691166 20251205035623_7Hnem UK00AL 2025-12-06T14:16:46.494Z 2025-12-06T14:18:01.047Z
8691095 8691095 20251205032829_UKSmR UK00AL 2025-12-06T14:16:28.404Z 2025-12-06T14:18:01.030Z
8691087 8691087 20251205032800_NtAKc UK00AL 2025-12-06T14:16:27.218Z 2025-12-06T14:18:01.029Z
8691077 8691077 20251205032400_GbB4M UK00AL 2025-12-06T14:16:25.625Z 2025-12-06T14:18:01.027Z
8690989 8690989 20251205024349_LYzXt UK00AL 2025-12-06T14:16:11.884Z 2025-12-06T14:18:01.006Z
8690917 8690917 20251205022234_2SlVY UK00AL 2025-12-06T14:15:50.645Z 2025-12-06T14:18:00.988Z
8690869 8690869 20251205020639_ZVVHh UK00AL 2025-12-06T14:15:44.169Z 2025-12-06T14:18:00.976Z
8690829 8690829 20251205015741_hJ1MY UK00AL 2025-12-06T14:15:37.845Z 2025-12-06T14:18:00.967Z
8690792 8690792 20251205015115_0vFyY UK00AL 2025-12-06T14:15:27.023Z 2025-12-06T14:18:00.960Z
8690783 8690783 20251205014622_eYBpL UK00AL 2025-12-06T14:15:26.068Z 2025-12-06T14:18:00.959Z
8690766 8690766 20251205014530_rWO8k UK00AL 2025-12-06T14:15:25.301Z 2025-12-06T14:18:00.957Z
8690742 8690742 20251205014001_L5TmA UK00AL 2025-12-06T14:15:18.539Z 2025-12-06T14:18:00.950Z
8690695 8690695 20251205011945_icDCR UK00AL 2025-12-06T14:15:11.199Z 2025-12-06T14:18:00.938Z
8690643 8690643 20251205011427_4JNb6 UK00AL 2025-12-06T14:15:03.699Z 2025-12-06T14:18:00.928Z
8690596 8690596 20251205004124_0zOyU UK00AL 2025-12-06T14:14:48.940Z 2025-12-06T14:18:00.917Z
8690542 8690542 20251205002007_nkQWK UK00AL 2025-12-06T14:14:39.303Z 2025-12-06T14:18:00.904Z
8690531 8690531 20251205001825_CJv5a UK00AL 2025-12-06T14:14:37.934Z 2025-12-06T14:18:00.902Z
8690458 8690458 20251204234046_7S37L UK00AL 2025-12-06T14:14:26.554Z 2025-12-06T14:18:00.884Z
8690456 8690456 20251204233828_jmpCI UK00AL 2025-12-06T14:14:26.136Z 2025-12-06T14:18:00.883Z
8690446 8690446 20251204233828_w0rAS UK00AL 2025-12-06T14:14:25.503Z 2025-12-06T14:18:00.882Z
8690422 8690422 20251204233222_SOl8T UK00AL 2025-12-06T14:14:15.721Z 2025-12-06T14:18:00.878Z
8690260 8690260 20251204222537_wk6xL UK00AL 2025-12-06T14:13:54.065Z 2025-12-06T14:18:00.851Z
8690166 8690166 20251204213718_1XaLn UK00AL 2025-12-06T14:13:33.947Z 2025-12-06T14:18:00.832Z
8687455 8687455 20251205062814_pc8yo UK00AL 2025-12-06T14:00:18.967Z 2025-12-06T14:00:18.967Z
8680840 8680840 20251203012912_2HnKA UK00AL 2025-12-04T14:13:02.691Z 2025-12-06T14:27:28.740Z
8680764 8680764 20251203011317_u399P UK00AL 2025-12-04T14:12:52.499Z 2025-12-06T14:27:25.482Z
8680735 8680735 20251203011133_qdCkw UK00AL 2025-12-04T14:12:49.634Z 2025-12-06T14:27:24.038Z
8680692 8680692 20251203010216_PCdx2 UK00AL 2025-12-04T14:12:45.225Z 2025-12-06T14:27:22.786Z
8680571 8680571 20251203003045_aLtii UK00AL 2025-12-04T14:12:22.393Z 2025-12-06T14:27:18.023Z
8680555 8680555 20251203002727_fqzs3 UK00AL 2025-12-04T14:12:20.977Z 2025-12-06T14:27:17.556Z
8680548 8680548 20251203002722_d3XaX UK00AL 2025-12-04T14:12:19.465Z 2025-12-06T14:27:17.188Z
8680460 8680460 20251203000421_rhkuc UK00AL 2025-12-04T14:12:04.548Z 2025-12-06T14:27:12.739Z
8680453 8680453 20251203000318_aPx4w UK00AL 2025-12-04T14:12:03.838Z 2025-12-06T14:27:12.501Z
8680441 8680441 20251202235926_sSsXW UK00AL 2025-12-04T14:12:00.435Z 2025-12-06T14:27:11.982Z
8680382 8680382 20251202234155_43FIX UK00AL 2025-12-04T14:11:54.240Z 2025-12-06T14:27:10.371Z
8680351 8680351 20251202233333_0YeSd UK00AL 2025-12-04T14:11:50.109Z 2025-12-06T14:27:05.446Z
8680326 8680326 20251202232004_3kH6Q UK00AL 2025-12-04T14:11:46.863Z 2025-12-06T14:27:02.460Z
8680307 8680307 20251202230956_oXOkU UK00AL 2025-12-04T14:11:39.675Z 2025-12-06T14:27:01.546Z
8680276 8680276 20251202225601_htE7y UK00AL 2025-12-04T14:11:33.248Z 2025-12-06T14:27:00.208Z
8680274 8680274 20251202225458_Rwe25 UK00AL 2025-12-04T14:11:32.851Z 2025-12-06T14:27:00.142Z
8679754 8679754 20251202204739_TLo5x UK00AL 2025-12-04T14:10:22.935Z 2025-12-06T14:26:38.702Z
8677014 8677014 20251202064010_12j3o UK00AL 2025-12-03T14:26:11.642Z 2025-12-06T14:35:32.943Z
8676929 8676929 20251202063108_mb3Ug UK00AL 2025-12-03T14:25:56.392Z 2025-12-06T14:35:30.759Z
8676900 8676900 20251202063049_mlP9C UK00AL 2025-12-03T14:25:55.509Z 2025-12-06T14:35:30.312Z
8676601 8676601 20251202060704_2I4GT UK00AL 2025-12-03T14:25:21.153Z 2025-12-06T14:35:24.417Z
8676588 8676588 20251202060414_X52Ag UK00AL 2025-12-03T14:25:20.321Z 2025-12-06T14:35:24.139Z
8676461 8676461 20251202055316_kWRxG UK00AL 2025-12-03T14:25:13.211Z 2025-12-06T14:35:21.943Z
8676434 8676434 20251202055207_MmdIZ UK00AL 2025-12-03T14:25:12.459Z 2025-12-06T14:35:21.686Z
8676159 8676159 20251202053907_eBwmt UK00AL 2025-12-03T14:24:47.195Z 2025-12-06T14:35:17.454Z
8676135 8676135 20251202053845_NKTYF UK00AL 2025-12-03T14:24:44.835Z 2025-12-06T14:35:16.676Z
8676114 8676114 20251202053707_eUJbc UK00AL 2025-12-03T14:24:43.169Z 2025-12-06T14:35:10.269Z
8676101 8676101 20251202053701_ezluA UK00AL 2025-12-03T14:24:42.235Z 2025-12-06T14:35:08.141Z
8675962 8675962 20251202052706_x3khz UK00AL 2025-12-03T14:24:34.096Z 2025-12-06T14:35:05.953Z
8675936 8675936 20251202052435_m8kMj UK00AL 2025-12-03T14:24:31.909Z 2025-12-06T14:35:05.197Z
8675925 8675925 20251202052301_Wb9sl UK00AL 2025-12-03T14:24:30.663Z 2025-12-06T14:35:04.796Z
8675915 8675915 20251202052257_DArRJ UK00AL 2025-12-03T14:24:29.974Z 2025-12-06T14:35:04.714Z
8675812 8675812 20251202051530_NIBeK UK00AL 2025-12-03T14:24:16.363Z 2025-12-06T14:35:00.655Z
8675746 8675746 20251202051218_RyOBY UK00AL 2025-12-03T14:24:13.604Z 2025-12-06T14:34:59.480Z
8675628 8675628 20251202050216_B6IWq UK00AL 2025-12-03T14:23:56.710Z 2025-12-06T14:34:57.355Z
8675606 8675606 20251202050128_S5DXD UK00AL 2025-12-03T14:23:55.401Z 2025-12-06T14:34:57.194Z
8675512 8675512 20251202045107_vcp34 UK00AL 2025-12-03T14:23:48.675Z 2025-12-06T14:34:55.069Z
8675285 8675285 20251202042551_jyIyC UK00AL 2025-12-03T14:23:29.300Z 2025-12-06T14:34:48.913Z
8675277 8675277 20251202042534_5tP7y UK00AL 2025-12-03T14:23:28.331Z 2025-12-06T14:34:48.734Z
8675129 8675129 20251202040334_abF74 UK00AL 2025-12-03T14:23:05.569Z 2025-12-06T14:34:30.479Z
8675109 8675109 20251202040145_3N9aL UK00AL 2025-12-03T14:23:03.405Z 2025-12-06T14:34:29.709Z
8674646 8674646 20251202030317_q3Aif UK00AL 2025-12-03T14:22:10.640Z 2025-12-06T14:34:14.717Z
8674617 8674617 20251202025849_l3X15 UK00AL 2025-12-03T14:22:08.293Z 2025-12-06T14:34:13.989Z
8674482 8674482 20251202023204_Tiw6l UK00AL 2025-12-03T14:21:41.417Z 2025-12-06T14:34:10.104Z
8674448 8674448 20251202022457_m79hg UK00AL 2025-12-03T14:21:39.005Z 2025-12-06T14:34:09.332Z
8674437 8674437 20251202022429_jtmem UK00AL 2025-12-03T14:21:38.128Z 2025-12-06T14:34:09.069Z
8674361 8674361 20251202021100_4yO6i UK00AL 2025-12-03T14:21:32.191Z 2025-12-06T14:34:06.422Z
8674331 8674331 20251202020238_WLTzp UK00AL 2025-12-03T14:21:25.233Z 2025-12-06T14:34:04.691Z
8674315 8674315 20251202015900_FIHcE UK00AL 2025-12-03T14:21:23.278Z 2025-12-06T14:34:03.722Z
8674262 8674262 20251202015509_tper3 UK00AL 2025-12-03T14:21:18.177Z 2025-12-06T14:34:02.713Z
8674256 8674256 20251202015502_mvK3V UK00AL 2025-12-03T14:21:17.742Z 2025-12-06T14:34:02.565Z
8674185 8674185 20251202014411_jBvNF UK00AL 2025-12-03T14:21:08.063Z 2025-12-06T14:34:00.674Z
8674127 8674127 20251202013014_ZXstA UK00AL 2025-12-03T14:20:57.929Z 2025-12-06T14:33:59.038Z
8674102 8674102 20251202012838_GGdn9 UK00AL 2025-12-03T14:20:56.067Z 2025-12-06T14:33:57.297Z
8674058 8674058 20251202012304_R3o83 UK00AL 2025-12-03T14:20:52.307Z 2025-12-06T14:33:48.745Z
8673965 8673965 20251202004859_H5sJb UK00AL 2025-12-03T14:20:26.577Z 2025-12-06T14:33:43.398Z
8668169 8668169 20251130062857_YiPjO UK00AL 2025-12-02T14:42:07.731Z 2025-12-06T14:50:25.276Z
8667969 8667969 20251130053154_J01fv UK00AL 2025-12-02T14:41:25.060Z 2025-12-06T14:49:45.256Z
8667887 8667887 20251130045700_Er8sS UK00AL 2025-12-02T14:41:12.060Z 2025-12-06T14:49:35.193Z
8667859 8667859 20251130043928_UWNsL UK00AL 2025-12-02T14:40:39.147Z 2025-12-06T14:49:31.300Z
8667833 8667833 20251130042032_YFOKn UK00AL 2025-12-02T14:40:31.594Z 2025-12-06T14:49:28.309Z
8667808 8667808 20251130041056_aa1b2 UK00AL 2025-12-02T14:40:27.393Z 2025-12-06T14:49:26.365Z
8667795 8667795 20251130040648_55BxB UK00AL 2025-12-02T14:40:25.043Z 2025-12-06T14:49:25.039Z
8667766 8667766 20251130035215_m8RxE UK00AL 2025-12-02T14:40:18.121Z 2025-12-06T14:48:59.069Z
8667685 8667685 20251130031904_VjI6N UK00AL 2025-12-02T14:39:44.117Z 2025-12-06T14:48:43.565Z
8667659 8667659 20251130031127_3hxKc UK00AL 2025-12-02T14:39:38.528Z 2025-12-06T14:48:41.029Z
8667526 8667526 20251130020508_c2e7Q UK00AL 2025-12-02T14:38:47.622Z 2025-12-06T14:47:52.354Z
8667525 8667525 20251130020449_ROMOU UK00AL 2025-12-02T14:38:47.327Z 2025-12-06T14:47:52.239Z
8667455 8667455 20251130013641_Da63a UK00AL 2025-12-02T14:38:18.136Z 2025-12-06T14:47:42.986Z
8667453 8667453 20251130013431_xxseE UK00AL 2025-12-02T14:38:15.120Z 2025-12-06T14:47:42.464Z

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