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

>10,000 rows count all where station_code = "UK009K" 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
8683218 8683218 20251203064314_FpBCE UK009K 2025-12-04T14:18:57.477Z 2025-12-05T14:23:11.905Z
8683158 8683158 20251203063341_RLR8q UK009K 2025-12-04T14:18:39.722Z 2025-12-05T14:23:09.475Z
8683119 8683119 20251203062811_Si9IK UK009K 2025-12-04T14:18:35.205Z 2025-12-05T14:23:08.023Z
8683101 8683101 20251203062758_uq4if UK009K 2025-12-04T14:18:34.878Z 2025-12-05T14:23:07.879Z
8683087 8683087 20251203062616_3I3KG UK009K 2025-12-04T14:18:34.318Z 2025-12-05T14:23:07.685Z
8683064 8683064 20251203062417_5Xe8t UK009K 2025-12-04T14:18:31.724Z 2025-12-05T14:23:06.837Z
8682983 8682983 20251203061840_2n14J UK009K 2025-12-04T14:18:26.216Z 2025-12-05T14:23:04.695Z
8682955 8682955 20251203061700_TDsgd UK009K 2025-12-04T14:18:23.830Z 2025-12-05T14:23:03.888Z
8682904 8682904 20251203061549_HKz8r UK009K 2025-12-04T14:18:19.780Z 2025-12-05T14:22:56.242Z
8682892 8682892 20251203061533_woNmB UK009K 2025-12-04T14:18:13.555Z 2025-12-05T14:22:55.973Z
8682772 8682772 20251203060230_2NDxJ UK009K 2025-12-04T14:17:59.484Z 2025-12-05T14:22:49.478Z
8682736 8682736 20251203060131_9N2KJ UK009K 2025-12-04T14:17:57.530Z 2025-12-05T14:22:48.593Z
8682731 8682731 20251203060113_Bz0H2 UK009K 2025-12-04T14:17:57.218Z 2025-12-05T14:22:48.493Z
8682672 8682672 20251203055818_xlyvB UK009K 2025-12-04T14:17:53.757Z 2025-12-05T14:22:47.393Z
8682649 8682649 20251203055550_1qL7M UK009K 2025-12-04T14:17:51.847Z 2025-12-05T14:22:46.589Z
8682494 8682494 20251203054014_T2Z8J UK009K 2025-12-04T14:17:18.943Z 2025-12-05T14:22:40.615Z
8680724 8680724 20251203010958_ugOVs UK009K 2025-12-04T14:12:48.854Z 2025-12-05T14:20:58.359Z
8680699 8680699 20251203010652_cFYcd UK009K 2025-12-04T14:12:45.977Z 2025-12-05T14:20:52.901Z
8680682 8680682 20251203005947_EnW8h UK009K 2025-12-04T14:12:38.395Z 2025-12-05T14:20:52.035Z
8680625 8680625 20251203004848_23q9l UK009K 2025-12-04T14:12:29.539Z 2025-12-05T14:20:49.665Z
8680603 8680603 20251203004654_7OKml UK009K 2025-12-04T14:12:27.420Z 2025-12-05T14:20:48.816Z
8680512 8680512 20251203001950_kSifl UK009K 2025-12-04T14:12:13.348Z 2025-12-05T14:20:41.071Z
8680405 8680405 20251202235333_Q7cip UK009K 2025-12-04T14:11:56.267Z 2025-12-05T14:20:37.383Z
8680385 8680385 20251202234322_2voEr UK009K 2025-12-04T14:11:54.535Z 2025-12-05T14:20:36.752Z
8680133 8680133 20251202215257_CPlP3 UK009K 2025-12-04T14:11:09.984Z 2025-12-05T14:20:18.810Z
8676982 8676982 20251202063619_F3JS8 UK009K 2025-12-03T14:25:59.174Z 2025-12-05T14:29:17.374Z
8676876 8676876 20251202062834_wXBla UK009K 2025-12-03T14:25:54.315Z 2025-12-05T14:29:15.318Z
8676848 8676848 20251202062759_i9Ph2 UK009K 2025-12-03T14:25:52.815Z 2025-12-05T14:29:14.703Z
8676765 8676765 20251202062246_LNmHC UK009K 2025-12-03T14:25:33.445Z 2025-12-05T14:29:12.826Z
8676492 8676492 20251202055527_gyFsG UK009K 2025-12-03T14:25:14.529Z 2025-12-05T14:28:57.255Z
8676470 8676470 20251202055341_ruDut UK009K 2025-12-03T14:25:13.513Z 2025-12-05T14:28:56.872Z
8676376 8676376 20251202054950_EwSxE UK009K 2025-12-03T14:25:09.839Z 2025-12-05T14:28:55.394Z
8676040 8676040 20251202053352_VIO33 UK009K 2025-12-03T14:24:37.831Z 2025-12-05T14:28:46.960Z
8667213 8667213 20251129184942_R62nr UK009K 2025-12-02T14:35:29.911Z 2025-12-05T14:40:26.482Z
8661936 8661936 20251130173403_UNMtq UK009K 2025-12-02T14:13:39.360Z 2025-12-05T14:32:42.680Z
8658006 8658006 20251130062708_h11XA UK009K 2025-12-01T14:34:49.194Z 2025-12-05T14:46:00.216Z
8657959 8657959 20251130062207_DRvvX UK009K 2025-12-01T14:34:47.456Z 2025-12-05T14:45:59.260Z
8657893 8657893 20251130061417_O8PyF UK009K 2025-12-01T14:34:44.661Z 2025-12-05T14:45:52.326Z
8657844 8657844 20251130061122_kvhIi UK009K 2025-12-01T14:34:42.882Z 2025-12-05T14:45:42.237Z
8657698 8657698 20251130060057_Uh59I UK009K 2025-12-01T14:34:38.614Z 2025-12-05T14:45:35.625Z
8657469 8657469 20251130054750_p9Dzq UK009K 2025-12-01T14:34:29.343Z 2025-12-05T14:45:31.670Z
8657436 8657436 20251130054522_D8Im5 UK009K 2025-12-01T14:34:26.053Z 2025-12-05T14:45:30.113Z
8657399 8657399 20251130054122_ygds5 UK009K 2025-12-01T14:34:22.022Z 2025-12-05T14:45:29.283Z
8657364 8657364 20251130054029_6HNo4 UK009K 2025-12-01T14:34:12.308Z 2025-12-05T14:45:28.720Z
8657345 8657345 20251130053946_Tq5TP UK009K 2025-12-01T14:34:07.577Z 2025-12-05T14:45:28.409Z
8657322 8657322 20251130053841_iaHjT UK009K 2025-12-01T14:34:04.315Z 2025-12-05T14:45:28.219Z
8657285 8657285 20251130053805_KOaXS UK009K 2025-12-01T14:34:03.156Z 2025-12-05T14:45:27.838Z
8657113 8657113 20251130053042_lhFBN UK009K 2025-12-01T14:33:54.828Z 2025-12-05T14:45:25.680Z
8657013 8657013 20251130052408_RUpO5 UK009K 2025-12-01T14:33:51.846Z 2025-12-05T14:45:24.545Z
8656927 8656927 20251130051818_GEpgT UK009K 2025-12-01T14:33:49.195Z 2025-12-05T14:45:23.290Z
8656863 8656863 20251130051453_AeqmQ UK009K 2025-12-01T14:33:47.123Z 2025-12-05T14:45:22.544Z
8656670 8656670 20251130050557_M6v3F UK009K 2025-12-01T14:28:53.505Z 2025-12-05T14:45:19.766Z
8656431 8656431 20251130045602_Nw3vd UK009K 2025-12-01T14:28:38.417Z 2025-12-05T14:45:16.041Z
8656242 8656242 20251130044514_ngvLX UK009K 2025-12-01T14:28:13.088Z 2025-12-01T14:28:13.088Z
8656196 8656196 20251130044217_sP3RQ UK009K 2025-12-01T14:28:09.663Z 2025-12-05T14:44:47.667Z
8655706 8655706 20251130041158_vrx7E UK009K 2025-12-01T14:27:21.692Z 2025-12-05T14:44:37.255Z
8655679 8655679 20251130041105_a6TzA UK009K 2025-12-01T14:27:20.795Z 2025-12-05T14:44:36.854Z
8655528 8655528 20251130040628_6jytl UK009K 2025-12-01T14:27:02.138Z 2025-12-05T14:44:34.902Z
8655448 8655448 20251130040216_pg5fn UK009K 2025-12-01T14:26:54.316Z 2025-12-05T14:44:33.693Z
8655288 8655288 20251130035240_QofwC UK009K 2025-12-01T14:26:43.403Z 2025-12-01T14:26:43.403Z
8655221 8655221 20251130034916_Tx8xv UK009K 2025-12-01T14:26:39.797Z 2025-12-05T14:44:29.903Z
8655123 8655123 20251130034514_3lwWx UK009K 2025-12-01T14:26:24.055Z 2025-12-05T14:44:28.100Z
8655024 8655024 20251130034109_FqO69 UK009K 2025-12-01T14:26:16.337Z 2025-12-05T14:44:26.922Z
8655011 8655011 20251130034107_Lz1dP UK009K 2025-12-01T14:26:15.888Z 2025-12-05T14:44:26.808Z
8654906 8654906 20251130033833_ekNHY UK009K 2025-12-01T14:26:10.200Z 2025-12-05T14:44:25.772Z
8654744 8654744 20251130033016_kD0nF UK009K 2025-12-01T14:25:57.362Z 2025-12-05T14:44:22.706Z
8654655 8654655 20251130032444_VbTDs UK009K 2025-12-01T14:25:40.688Z 2025-12-05T14:44:19.882Z
8654551 8654551 20251130031954_ZDXcZ UK009K 2025-12-01T14:25:34.444Z 2025-12-05T14:44:11.444Z
8654452 8654452 20251130031725_N2xbm UK009K 2025-12-01T14:25:26.679Z 2025-12-05T14:43:59.529Z
8654359 8654359 20251130031218_pGtiW UK009K 2025-12-01T14:25:11.337Z 2025-12-05T14:43:54.226Z
8654283 8654283 20251130030714_RJXRC UK009K 2025-12-01T14:25:04.073Z 2025-12-05T14:43:52.463Z
8654269 8654269 20251130030706_bvFzu UK009K 2025-12-01T14:25:03.706Z 2025-12-05T14:43:52.407Z
8654070 8654070 20251130025552_L2iKl UK009K 2025-12-01T14:24:48.352Z 2025-12-05T14:43:45.985Z
8651144 8651144 20251129224750_LeNV8 UK009K 2025-12-01T14:18:07.167Z 2025-12-05T14:41:50.068Z
8651132 8651132 20251129224625_Ln573 UK009K 2025-12-01T14:18:04.316Z 2025-12-05T14:41:49.777Z
8651093 8651093 20251129224047_GQ1jf UK009K 2025-12-01T14:17:59.429Z 2025-12-05T14:41:48.713Z
8651062 8651062 20251129223706_CWmuF UK009K 2025-12-01T14:17:55.841Z 2025-12-05T14:41:48.091Z
8651050 8651050 20251129223159_WGWDm UK009K 2025-12-01T14:17:53.995Z 2025-12-05T14:41:41.682Z
8650773 8650773 20251129212357_nId2x UK009K 2025-12-01T14:17:07.493Z 2025-12-05T14:41:16.772Z
8650729 8650729 20251129211449_rDa2G UK009K 2025-12-01T14:17:02.729Z 2025-12-05T14:41:15.789Z
8650703 8650703 20251129211154_Q4kBC UK009K 2025-12-01T14:17:00.172Z 2025-12-05T14:41:15.122Z
8650582 8650582 20251129204359_YMQbP UK009K 2025-12-01T14:16:32.366Z 2025-12-05T14:41:11.340Z
8650567 8650567 20251129204119_ZnC7J UK009K 2025-12-01T14:16:28.898Z 2025-12-05T14:41:10.849Z
8650555 8650555 20251129204113_amqYp UK009K 2025-12-01T14:16:28.225Z 2025-12-05T14:41:10.736Z
8650492 8650492 20251129203132_zvKTS UK009K 2025-12-01T14:16:19.149Z 2025-12-05T14:41:08.823Z
8650347 8650347 20251129195746_0niLL UK009K 2025-12-01T14:15:51.825Z 2025-12-05T14:41:04.545Z
8650284 8650284 20251129194842_6fLvp UK009K 2025-12-01T14:15:42.867Z 2025-12-05T14:41:02.493Z
8650143 8650143 20251129192858_F0TFJ UK009K 2025-12-01T14:15:13.784Z 2025-12-05T14:40:57.490Z
8650130 8650130 20251129192835_3abtN UK009K 2025-12-01T14:15:08.619Z 2025-12-05T14:40:57.235Z
8649901 8649901 20251129184941_CiKAt UK009K 2025-12-01T14:14:16.649Z 2025-12-05T14:40:26.351Z
8649653 8649653 20251129180342_dndso UK009K 2025-12-01T14:13:25.712Z 2025-12-05T14:40:15.641Z
8649492 8649492 20251129173302_v2wzq UK009K 2025-12-01T14:12:49.858Z 2025-12-05T14:40:10.164Z
8644538 8644538 20251128193145_YJTmf UK009K 2025-11-30T14:22:05.119Z 2025-12-05T14:50:23.362Z
8636389 8636389 20251128034137_H7cWS UK009K 2025-11-29T14:25:26.806Z 2025-12-05T14:59:23.506Z
8636260 8636260 20251128032953_V7dAi UK009K 2025-11-29T14:25:17.351Z 2025-12-05T14:59:21.953Z
8636210 8636210 20251128032753_Q1yJR UK009K 2025-11-29T14:25:05.114Z 2025-12-05T14:59:21.334Z
8635791 8635791 20251128024732_ZBXL2 UK009K 2025-11-29T14:24:09.654Z 2025-12-05T14:59:14.670Z
8635676 8635676 20251128023714_ualPK UK009K 2025-11-29T14:24:00.306Z 2025-12-05T14:59:13.053Z
8635642 8635642 20251128023423_8F4ca UK009K 2025-11-29T14:23:58.182Z 2025-12-05T14:59:12.463Z
8635439 8635439 20251128021255_0btpq UK009K 2025-11-29T14:23:24.343Z 2025-12-05T14:58:39.667Z

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