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 = "UK00B0" 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
8690675 8690675 20251205011857_0Y44L UK00B0 2025-12-06T14:15:08.743Z 2025-12-06T14:18:00.935Z
8690583 8690583 20251205003608_mDxl1 UK00B0 2025-12-06T14:14:46.656Z 2025-12-06T14:18:00.913Z
8690504 8690504 20251205000728_v5UJm UK00B0 2025-12-06T14:14:34.010Z 2025-12-06T14:18:00.896Z
8690405 8690405 20251204232531_5CTIE UK00B0 2025-12-06T14:14:12.469Z 2025-12-06T14:18:00.873Z
8690395 8690395 20251204231836_jezR5 UK00B0 2025-12-06T14:14:10.978Z 2025-12-06T14:18:00.872Z
8690375 8690375 20251204231626_STJm1 UK00B0 2025-12-06T14:14:05.905Z 2025-12-06T14:18:00.867Z
8690348 8690348 20251204231309_WGtN6 UK00B0 2025-12-06T14:14:04.382Z 2025-12-06T14:18:00.864Z
8690331 8690331 20251204230814_BW7OM UK00B0 2025-12-06T14:14:02.954Z 2025-12-06T14:18:00.862Z
8690288 8690288 20251204223618_xou8r UK00B0 2025-12-06T14:13:57.566Z 2025-12-06T14:18:00.855Z
8690273 8690273 20251204223138_iGH38 UK00B0 2025-12-06T14:13:56.602Z 2025-12-06T14:18:00.854Z
8690194 8690194 20251204214833_tvXCU UK00B0 2025-12-06T14:13:39.162Z 2025-12-06T14:18:00.838Z
8690068 8690068 20251204200803_cMuSB UK00B0 2025-12-06T14:13:08.905Z 2025-12-06T14:18:00.799Z
8690062 8690062 20251204200446_NJPio UK00B0 2025-12-06T14:13:07.128Z 2025-12-06T14:18:00.797Z
8690024 8690024 20251204195437_VxJVS UK00B0 2025-12-06T14:13:02.656Z 2025-12-06T14:18:00.792Z
8689995 8689995 20251204193237_wqp7a UK00B0 2025-12-06T14:12:54.408Z 2025-12-06T14:18:00.782Z
8689936 8689936 20251204184922_3mVmA UK00B0 2025-12-06T14:12:37.158Z 2025-12-06T14:18:00.765Z
8689872 8689872 20251204172940_fr6lb UK00B0 2025-12-06T14:12:23.473Z 2025-12-06T14:18:00.741Z
8683249 8683249 20251203064631_Y7XN2 UK00B0 2025-12-04T14:19:00.148Z 2025-12-06T14:29:47.886Z
8683161 8683161 20251203063341_RLR8q UK00B0 2025-12-04T14:18:39.722Z 2025-12-06T14:29:43.228Z
8683104 8683104 20251203062758_uq4if UK00B0 2025-12-04T14:18:34.878Z 2025-12-06T14:29:41.691Z
8683089 8683089 20251203062616_3I3KG UK00B0 2025-12-04T14:18:34.318Z 2025-12-06T14:29:41.487Z
8682986 8682986 20251203061840_2n14J UK00B0 2025-12-04T14:18:26.216Z 2025-12-06T14:29:38.479Z
8682739 8682739 20251203060131_9N2KJ UK00B0 2025-12-04T14:17:57.530Z 2025-12-06T14:29:23.875Z
8682675 8682675 20251203055818_xlyvB UK00B0 2025-12-04T14:17:53.757Z 2025-12-06T14:29:22.677Z
8681702 8681702 20251203034848_tB74B UK00B0 2025-12-04T14:15:18.606Z 2025-12-06T14:28:26.474Z
8681573 8681573 20251203032552_Ogp2S UK00B0 2025-12-04T14:15:04.206Z 2025-12-06T14:28:18.830Z
8681556 8681556 20251203032542_IhDcd UK00B0 2025-12-04T14:15:03.217Z 2025-12-06T14:28:18.393Z
8681520 8681520 20251203032141_7g0RN UK00B0 2025-12-04T14:14:51.958Z 2025-12-06T14:28:16.509Z
8681409 8681409 20251203030522_l2iZg UK00B0 2025-12-04T14:14:40.041Z 2025-12-06T14:28:06.314Z
8681336 8681336 20251203025745_olBOe UK00B0 2025-12-04T14:14:31.870Z 2025-12-06T14:28:03.832Z
8680917 8680917 20251203014907_3qUeH UK00B0 2025-12-04T14:13:21.073Z 2025-12-06T14:27:32.888Z
8680725 8680725 20251203010958_ugOVs UK00B0 2025-12-04T14:12:48.854Z 2025-12-06T14:27:23.831Z
8680700 8680700 20251203010652_cFYcd UK00B0 2025-12-04T14:12:45.977Z 2025-12-06T14:27:23.016Z
8680683 8680683 20251203005947_EnW8h UK00B0 2025-12-04T14:12:38.395Z 2025-12-06T14:27:22.053Z
8680605 8680605 20251203004654_7OKml UK00B0 2025-12-04T14:12:27.420Z 2025-12-06T14:27:19.500Z
8680546 8680546 20251203002658_KjV3c UK00B0 2025-12-04T14:12:18.989Z 2025-12-06T14:27:17.057Z
8680536 8680536 20251203002604_96PLL UK00B0 2025-12-04T14:12:17.536Z 2025-12-06T14:27:16.803Z
8680491 8680491 20251203001904_84jI5 UK00B0 2025-12-04T14:12:11.212Z 2025-12-06T14:27:14.040Z
8680387 8680387 20251202234322_2voEr UK00B0 2025-12-04T14:11:54.535Z 2025-12-06T14:27:10.475Z
8680370 8680370 20251202233838_yxAUi UK00B0 2025-12-04T14:11:52.432Z 2025-12-06T14:27:09.832Z
8680277 8680277 20251202225601_htE7y UK00B0 2025-12-04T14:11:33.264Z 2025-12-06T14:27:00.208Z
8680240 8680240 20251202224132_oPb3O UK00B0 2025-12-04T14:11:28.632Z 2025-12-06T14:26:58.880Z
8680211 8680211 20251202223051_FKn4q UK00B0 2025-12-04T14:11:25.363Z 2025-12-06T14:26:56.492Z
8680185 8680185 20251202222105_pzJVB UK00B0 2025-12-04T14:11:23.077Z 2025-12-06T14:26:54.920Z
8680147 8680147 20251202215408_2ep4w UK00B0 2025-12-04T14:11:11.690Z 2025-12-06T14:26:52.157Z
8680115 8680115 20251202214107_8tqR9 UK00B0 2025-12-04T14:11:07.135Z 2025-12-06T14:26:50.936Z
8679974 8679974 20251202211301_tqBsS UK00B0 2025-12-04T14:10:49.817Z 2025-12-06T14:26:45.769Z
8679077 8679077 20251202185054_l4SS9 UK00B0 2025-12-04T14:08:52.942Z 2025-12-06T14:25:53.048Z
8679010 8679010 20251202183305_mgbSI UK00B0 2025-12-04T14:08:46.260Z 2025-12-06T14:25:49.332Z
8677049 8677049 20251202064220_Unh26 UK00B0 2025-12-03T14:26:13.271Z 2025-12-06T14:35:33.397Z
8676983 8676983 20251202063619_F3JS8 UK00B0 2025-12-03T14:25:59.174Z 2025-12-06T14:35:32.182Z
8676878 8676878 20251202062834_wXBla UK00B0 2025-12-03T14:25:54.315Z 2025-12-06T14:35:29.998Z
8676755 8676755 20251202062049_J6dUj UK00B0 2025-12-03T14:25:32.615Z 2025-12-06T14:35:28.209Z
8676621 8676621 20251202060852_GTz42 UK00B0 2025-12-03T14:25:22.448Z 2025-12-06T14:35:24.872Z
8676495 8676495 20251202055527_gyFsG UK00B0 2025-12-03T14:25:14.529Z 2025-12-06T14:35:22.355Z
8676442 8676442 20251202055303_rJE7O UK00B0 2025-12-03T14:25:12.735Z 2025-12-06T14:35:21.800Z
8676171 8676171 20251202053942_XoT3u UK00B0 2025-12-03T14:24:47.969Z 2025-12-06T14:35:17.997Z
8676054 8676054 20251202053410_JoXh5 UK00B0 2025-12-03T14:24:38.312Z 2025-12-06T14:35:07.325Z
8676034 8676034 20251202053346_SH1c8 UK00B0 2025-12-03T14:24:37.479Z 2025-12-06T14:35:07.110Z
8676017 8676017 20251202053251_hEamB UK00B0 2025-12-03T14:24:36.265Z 2025-12-06T14:35:06.646Z
8675994 8675994 20251202052922_VBv5q UK00B0 2025-12-03T14:24:35.073Z 2025-12-06T14:35:06.287Z
8675986 8675986 20251202052834_5X6sK UK00B0 2025-12-03T14:24:34.937Z 2025-12-06T14:35:06.200Z
8675917 8675917 20251202052257_DArRJ UK00B0 2025-12-03T14:24:29.975Z 2025-12-06T14:35:04.714Z
8675666 8675666 20251202050440_IjvhH UK00B0 2025-12-03T14:23:59.208Z 2025-12-06T14:34:57.833Z
8675619 8675619 20251202050215_fgICz UK00B0 2025-12-03T14:23:56.044Z 2025-12-06T14:34:57.250Z
8675546 8675546 20251202045557_6jwAO UK00B0 2025-12-03T14:23:50.825Z 2025-12-06T14:34:56.024Z
8675357 8675357 20251202043132_w7ZIK UK00B0 2025-12-03T14:23:33.657Z 2025-12-06T14:34:50.304Z
8675300 8675300 20251202042601_vsoN5 UK00B0 2025-12-03T14:23:30.010Z 2025-12-06T14:34:49.133Z
8675218 8675218 20251202041801_1TvKz UK00B0 2025-12-03T14:23:21.465Z 2025-12-06T14:34:47.446Z
8673806 8673806 20251201233821_HSMwa UK00B0 2025-12-03T14:20:05.260Z 2025-12-06T14:33:35.597Z
8668162 8668162 20251130062448_c4bxm UK00B0 2025-12-02T14:42:07.120Z 2025-12-06T14:50:25.124Z
8668088 8668088 20251130060056_c3ECC UK00B0 2025-12-02T14:42:00.284Z 2025-12-06T14:50:21.216Z
8668072 8668072 20251130055308_ldldB UK00B0 2025-12-02T14:41:55.761Z 2025-12-06T14:50:14.699Z
8668045 8668045 20251130054522_Z3TJl UK00B0 2025-12-02T14:41:32.337Z 2025-12-06T14:50:01.380Z
8668037 8668037 20251130054123_cj2mg UK00B0 2025-12-02T14:41:31.324Z 2025-12-06T14:49:56.981Z
8668005 8668005 20251130053946_qEOBN UK00B0 2025-12-02T14:41:29.434Z 2025-12-06T14:49:53.337Z
8668002 8668002 20251130053840_CBe9R UK00B0 2025-12-02T14:41:28.944Z 2025-12-06T14:49:52.196Z
8667952 8667952 20251130052408_dmPNE UK00B0 2025-12-02T14:41:22.906Z 2025-12-06T14:49:44.028Z
8667938 8667938 20251130051453_SepUV UK00B0 2025-12-02T14:41:20.296Z 2025-12-06T14:49:42.523Z
8667906 8667906 20251130050557_rv5pa UK00B0 2025-12-02T14:41:16.285Z 2025-12-06T14:49:38.464Z
8667861 8667861 20251130044007_PvZBH UK00B0 2025-12-02T14:40:41.008Z 2025-12-06T14:49:31.655Z
8667813 8667813 20251130041156_S2kmr UK00B0 2025-12-02T14:40:28.165Z 2025-12-06T14:49:26.644Z
8667803 8667803 20251130040813_lompV UK00B0 2025-12-02T14:40:26.187Z 2025-12-06T14:49:25.605Z
8667789 8667789 20251130040218_Id2Yb UK00B0 2025-12-02T14:40:22.893Z 2025-12-06T14:49:18.438Z
8667786 8667786 20251130040216_4lDhN UK00B0 2025-12-02T14:40:22.745Z 2025-12-06T14:49:17.741Z
8667775 8667775 20251130035349_k7j9X UK00B0 2025-12-02T14:40:19.643Z 2025-12-06T14:49:05.501Z
8667757 8667757 20251130035002_2GEn6 UK00B0 2025-12-02T14:40:16.743Z 2025-12-06T14:48:56.906Z
8667703 8667703 20251130032545_904ca UK00B0 2025-12-02T14:39:47.767Z 2025-12-06T14:48:45.719Z
8667701 8667701 20251130032444_W6wqb UK00B0 2025-12-02T14:39:47.236Z 2025-12-06T14:48:45.423Z
8667691 8667691 20251130032031_hIJxC UK00B0 2025-12-02T14:39:45.161Z 2025-12-06T14:48:44.145Z
8667642 8667642 20251130030236_dq3jk UK00B0 2025-12-02T14:39:33.687Z 2025-12-06T14:48:38.508Z
8667617 8667617 20251130025000_1mYgb UK00B0 2025-12-02T14:39:27.607Z 2025-12-06T14:48:35.326Z
8667570 8667570 20251130021722_W78H7 UK00B0 2025-12-02T14:38:55.150Z 2025-12-06T14:47:58.546Z
8667562 8667562 20251130021628_ORtAr UK00B0 2025-12-02T14:38:54.538Z 2025-12-06T14:47:58.311Z
8667527 8667527 20251130020508_c2e7Q UK00B0 2025-12-02T14:38:47.622Z 2025-12-06T14:47:52.354Z
8667519 8667519 20251130020400_20J1J UK00B0 2025-12-02T14:38:46.743Z 2025-12-06T14:47:52.006Z
8667514 8667514 20251130020132_ibYbz UK00B0 2025-12-02T14:38:45.377Z 2025-12-06T14:47:51.348Z
8667445 8667445 20251130012459_2eZYH UK00B0 2025-12-02T14:38:11.384Z 2025-12-06T14:47:40.356Z
8667442 8667442 20251130012250_IQ5mJ UK00B0 2025-12-02T14:38:10.799Z 2025-12-06T14:47:40.070Z
8667440 8667440 20251130012218_80mCm UK00B0 2025-12-02T14:38:10.099Z 2025-12-06T14:47:39.724Z

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