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

6,884 rows where station_code = "UK00AK" 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
8689913 8689913 20251204183058_fsEeh UK00AK 2025-12-06T14:12:32.937Z 2025-12-06T14:18:00.758Z
8689889 8689889 20251204175301_ARHl7 UK00AK 2025-12-06T14:12:27.602Z 2025-12-06T14:18:00.748Z
8682285 8682285 20251203051053_30b2M UK00AK 2025-12-04T14:16:44.009Z 2025-12-06T14:28:52.414Z
8681970 8681970 20251203043415_sSiPh UK00AK 2025-12-04T14:16:04.450Z 2025-12-06T14:28:41.442Z
8681954 8681954 20251203043347_1U0is UK00AK 2025-12-04T14:16:03.402Z 2025-12-06T14:28:41.102Z
8681851 8681851 20251203041554_3ZcMh UK00AK 2025-12-04T14:15:47.422Z 2025-12-06T14:28:33.947Z
8681715 8681715 20251203034946_YnL5u UK00AK 2025-12-04T14:15:19.723Z 2025-12-06T14:28:26.900Z
8681530 8681530 20251203032227_FAE3q UK00AK 2025-12-04T14:14:58.780Z 2025-12-06T14:28:16.907Z
8681464 8681464 20251203031246_0J0d3 UK00AK 2025-12-04T14:14:45.648Z 2025-12-06T14:28:13.219Z
8681367 8681367 20251203025919_kuJjd UK00AK 2025-12-04T14:14:34.093Z 2025-12-06T14:28:04.728Z
8681029 8681029 20251203021400_dfWAJ UK00AK 2025-12-04T14:13:34.407Z 2025-12-06T14:27:46.844Z
8680994 8680994 20251203021010_C7WPw UK00AK 2025-12-04T14:13:31.287Z 2025-12-06T14:27:43.473Z
8680985 8680985 20251203020653_9qvY0 UK00AK 2025-12-04T14:13:30.469Z 2025-12-06T14:27:40.914Z
8680923 8680923 20251203015317_lvpqf UK00AK 2025-12-04T14:13:22.038Z 2025-12-06T14:27:33.134Z
8680894 8680894 20251203014256_PXI7d UK00AK 2025-12-04T14:13:11.492Z 2025-12-06T14:27:32.089Z
8680857 8680857 20251203013335_7u3Q9 UK00AK 2025-12-04T14:13:06.046Z 2025-12-06T14:27:29.562Z
8680826 8680826 20251203012354_XJ8x4 UK00AK 2025-12-04T14:13:00.431Z 2025-12-06T14:27:28.056Z
8680798 8680798 20251203012149_Q3AX6 UK00AK 2025-12-04T14:12:57.130Z 2025-12-06T14:27:27.194Z
8680793 8680793 20251203012041_P5Nrv UK00AK 2025-12-04T14:12:56.151Z 2025-12-06T14:27:26.992Z
8680586 8680586 20251203004343_rrg1v UK00AK 2025-12-04T14:12:25.036Z 2025-12-06T14:27:18.717Z
8680577 8680577 20251203003315_i2fdj UK00AK 2025-12-04T14:12:23.540Z 2025-12-06T14:27:18.264Z
8680562 8680562 20251203003035_0cDKk UK00AK 2025-12-04T14:12:21.723Z 2025-12-06T14:27:17.770Z
8680479 8680479 20251203001618_YkE1l UK00AK 2025-12-04T14:12:07.126Z 2025-12-06T14:27:13.699Z
8680331 8680331 20251202232217_Sl3um UK00AK 2025-12-04T14:11:47.228Z 2025-12-06T14:27:02.570Z
8680202 8680202 20251202222516_3zuvJ UK00AK 2025-12-04T14:11:24.583Z 2025-12-06T14:26:56.085Z
8678831 8678831 20251202174415_m82b8 UK00AK 2025-12-04T14:08:19.039Z 2025-12-06T14:25:31.252Z
8677066 8677066 20251202064407_icCFz UK00AK 2025-12-03T14:26:15.762Z 2025-12-06T14:35:33.976Z
8676891 8676891 20251202063038_GdwId UK00AK 2025-12-03T14:25:55.165Z 2025-12-06T14:35:30.234Z
8676863 8676863 20251202062822_oafOS UK00AK 2025-12-03T14:25:53.881Z 2025-12-06T14:35:29.909Z
8676792 8676792 20251202062616_G0bKO UK00AK 2025-12-03T14:25:39.363Z 2025-12-06T14:35:28.844Z
8676787 8676787 20251202062501_mERB2 UK00AK 2025-12-03T14:25:35.206Z 2025-12-06T14:35:28.749Z
8676598 8676598 20251202060505_OIxQJ UK00AK 2025-12-03T14:25:20.746Z 2025-12-06T14:35:24.284Z
8676553 8676553 20251202060159_H4kHu UK00AK 2025-12-03T14:25:18.415Z 2025-12-06T14:35:23.493Z
8676509 8676509 20251202055733_HDZJ3 UK00AK 2025-12-03T14:25:15.535Z 2025-12-06T14:35:22.644Z
8676392 8676392 20251202055102_AvoZv UK00AK 2025-12-03T14:25:10.783Z 2025-12-06T14:35:21.092Z
8676148 8676148 20251202053846_pR7uL UK00AK 2025-12-03T14:24:46.848Z 2025-12-06T14:35:17.114Z
8675974 8675974 20251202052755_89g4R UK00AK 2025-12-03T14:24:34.479Z 2025-12-06T14:35:06.145Z
8675887 8675887 20251202052136_8LnQC UK00AK 2025-12-03T14:24:28.935Z 2025-12-06T14:35:04.189Z
8675863 8675863 20251202051859_Op3qC UK00AK 2025-12-03T14:24:26.545Z 2025-12-06T14:35:03.506Z
8675780 8675780 20251202051410_c0ChF UK00AK 2025-12-03T14:24:14.919Z 2025-12-06T14:34:59.769Z
8675579 8675579 20251202045712_PzSvr UK00AK 2025-12-03T14:23:52.459Z 2025-12-06T14:34:56.548Z
8675400 8675400 20251202043526_LkBOe UK00AK 2025-12-03T14:23:40.166Z 2025-12-06T14:34:51.242Z
8675369 8675369 20251202043223_zmvpC UK00AK 2025-12-03T14:23:34.350Z 2025-12-06T14:34:50.540Z
8675338 8675338 20251202042952_ijeLw UK00AK 2025-12-03T14:23:31.906Z 2025-12-06T14:34:49.686Z
8674954 8674954 20251202034334_bmmag UK00AK 2025-12-03T14:22:46.071Z 2025-12-06T14:34:25.514Z
8580699 8580699 20251121201659_mkZAb UK00AK 2025-11-24T14:21:32.235Z 2025-11-30T15:04:53.986Z
8567741 8567741 20251121020502_j4U4Z UK00AK 2025-11-23T14:27:38.848Z 2025-11-29T14:54:32.708Z
8565313 8565313 20251121201659_XQ7TC UK00AK 2025-11-23T14:12:58.462Z 2025-11-30T15:04:53.983Z
8560447 8560447 20251121045509_GZrKG UK00AK 2025-11-22T14:42:52.681Z 2025-11-29T14:54:45.760Z
8559967 8559967 20251121043311_yiXSz UK00AK 2025-11-22T14:42:07.975Z 2025-11-29T14:54:44.825Z
8559963 8559963 20251121043230_NDkR1 UK00AK 2025-11-22T14:42:07.814Z 2025-11-29T14:54:44.812Z
8559502 8559502 20251121041314_A2Nvo UK00AK 2025-11-22T14:41:56.962Z 2025-11-29T14:54:39.181Z
8559020 8559020 20251121034944_teKYv UK00AK 2025-11-22T14:41:43.677Z 2025-11-29T14:54:36.961Z
8558952 8558952 20251121034642_MfjLG UK00AK 2025-11-22T14:41:29.029Z 2025-11-29T14:54:36.871Z
8558687 8558687 20251121033748_AszFb UK00AK 2025-11-22T14:41:09.947Z 2025-11-29T14:54:36.533Z
8558241 8558241 20251121032046_eTQl2 UK00AK 2025-11-22T14:41:01.433Z 2025-11-29T14:54:35.640Z
8558103 8558103 20251121031517_V3IIW UK00AK 2025-11-22T14:40:58.869Z 2025-11-29T14:54:35.286Z
8557881 8557881 20251121030809_WNRIk UK00AK 2025-11-22T14:40:51.347Z 2025-11-29T14:54:34.832Z
8557665 8557665 20251121025532_LJc63 UK00AK 2025-11-22T14:40:30.195Z 2025-11-29T14:54:34.423Z
8557657 8557657 20251121025503_M0cD9 UK00AK 2025-11-22T14:40:29.027Z 2025-11-29T14:54:34.420Z
8557364 8557364 20251121024633_TyWEc UK00AK 2025-11-22T14:40:03.057Z 2025-11-29T14:54:34.100Z
8557188 8557188 20251121023619_paWxD UK00AK 2025-11-22T14:39:53.387Z 2025-11-29T14:54:33.586Z
8556994 8556994 20251121022655_oTCZ9 UK00AK 2025-11-22T14:39:48.738Z 2025-11-29T14:54:33.313Z
8556980 8556980 20251121022635_oMia3 UK00AK 2025-11-22T14:39:48.642Z 2025-11-29T14:54:33.309Z
8556970 8556970 20251121022606_Q3GhZ UK00AK 2025-11-22T14:39:48.358Z 2025-11-29T14:54:33.304Z
8556948 8556948 20251121022500_6ljQW UK00AK 2025-11-22T14:39:48.116Z 2025-11-29T14:54:33.268Z
8556910 8556910 20251121022039_xyMsg UK00AK 2025-11-22T14:39:46.929Z 2025-11-29T14:54:33.154Z
8556906 8556906 20251121022031_pALsQ UK00AK 2025-11-22T14:39:46.747Z 2025-11-29T14:54:33.147Z
8556817 8556817 20251121021512_NCLHV UK00AK 2025-11-22T14:39:44.991Z 2025-11-29T14:54:33.049Z
8556547 8556547 20251121015947_Q9P3X UK00AK 2025-11-22T14:39:36.433Z 2025-11-29T14:54:32.515Z
8556475 8556475 20251121015623_6vbVK UK00AK 2025-11-22T14:39:34.211Z 2025-11-29T14:54:32.392Z
8556120 8556120 20251121013822_q9DMM UK00AK 2025-11-22T14:39:02.687Z 2025-11-29T14:54:31.845Z
8556026 8556026 20251121013402_dzcJW UK00AK 2025-11-22T14:38:59.470Z 2025-11-29T14:54:31.688Z
8555419 8555419 20251121010621_aUcv8 UK00AK 2025-11-22T14:38:43.825Z 2025-11-29T14:54:30.467Z
8554797 8554797 20251121003901_zDFDV UK00AK 2025-11-22T14:37:20.498Z 2025-11-29T14:54:28.893Z
8554740 8554740 20251121003652_hgA2x UK00AK 2025-11-22T14:37:17.914Z 2025-11-29T14:54:28.825Z
8553978 8553978 20251120062400_C7QxX UK00AK 2025-11-22T14:34:36.939Z 2025-11-28T14:58:41.907Z
8553958 8553958 20251120062321_0JaJ2 UK00AK 2025-11-22T14:34:36.023Z 2025-11-28T14:58:40.347Z
8553941 8553941 20251120062149_goorS UK00AK 2025-11-22T14:34:34.930Z 2025-11-28T14:58:39.834Z
8553908 8553908 20251120061422_ogIYz UK00AK 2025-11-22T14:34:32.554Z 2025-11-28T14:58:37.575Z
8553886 8553886 20251120061344_kA0uR UK00AK 2025-11-22T14:34:31.781Z 2025-11-28T14:58:35.882Z
8553806 8553806 20251120060733_D5ojx UK00AK 2025-11-22T14:34:29.109Z 2025-11-28T14:58:34.783Z
8553711 8553711 20251120055747_4MIVR UK00AK 2025-11-22T14:34:10.039Z 2025-11-28T14:58:31.456Z
8553699 8553699 20251120055642_1dGuE UK00AK 2025-11-22T14:34:09.527Z 2025-11-28T14:58:31.436Z
8553688 8553688 20251120055626_9t5Vb UK00AK 2025-11-22T14:34:09.140Z 2025-11-28T14:58:31.120Z
8553670 8553670 20251120055556_AZnaR UK00AK 2025-11-22T14:34:08.162Z 2025-11-28T14:58:30.982Z
8553660 8553660 20251120055411_PMR1r UK00AK 2025-11-22T14:34:07.916Z 2025-11-28T14:58:30.960Z
8553589 8553589 20251120054925_3BP5X UK00AK 2025-11-22T14:34:05.181Z 2025-11-28T14:58:29.508Z
8553525 8553525 20251120054216_Ae4Uh UK00AK 2025-11-22T14:34:01.881Z 2025-11-28T14:58:20.651Z
8553330 8553330 20251120052403_8w625 UK00AK 2025-11-22T14:33:50.768Z 2025-11-28T14:58:00.945Z
8553322 8553322 20251120052352_yYmUf UK00AK 2025-11-22T14:33:50.538Z 2025-11-28T14:58:00.055Z
8553151 8553151 20251120050608_DDBmg UK00AK 2025-11-22T14:33:24.867Z 2025-11-28T14:57:50.335Z
8553035 8553035 20251120045237_uRg2C UK00AK 2025-11-22T14:33:17.927Z 2025-11-28T14:57:48.409Z
8553006 8553006 20251120044924_334Vv UK00AK 2025-11-22T14:33:16.602Z 2025-11-28T14:57:48.169Z
8552904 8552904 20251120043817_SZM0o UK00AK 2025-11-22T14:33:11.134Z 2025-11-28T14:57:43.543Z
8552891 8552891 20251120043756_3veEH UK00AK 2025-11-22T14:33:10.691Z 2025-11-28T14:57:42.386Z
8552834 8552834 20251120043441_oH3DR UK00AK 2025-11-22T14:33:07.182Z 2025-11-28T14:57:41.692Z
8552744 8552744 20251120042730_uA7pl UK00AK 2025-11-22T14:32:56.005Z 2025-11-28T14:57:38.882Z
8551261 8551261 20251121003143_Qs2Y1 UK00AK 2025-11-22T14:22:20.393Z 2025-11-29T14:54:28.433Z
8551228 8551228 20251121003054_eCaOD UK00AK 2025-11-22T14:22:19.119Z 2025-11-29T14:54:28.353Z

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