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

1,273 rows where station_code = "UK00CK" 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
8683251 8683251 20251203064631_Y7XN2 UK00CK 2025-12-04T14:19:00.148Z 2025-12-05T14:23:12.869Z
8683229 8683229 20251203064326_Uh2Qq UK00CK 2025-12-04T14:18:58.110Z 2025-12-05T14:23:12.166Z
8683206 8683206 20251203064004_ii7NC UK00CK 2025-12-04T14:18:56.006Z 2025-12-05T14:23:11.409Z
8682991 8682991 20251203061840_2n14J UK00CK 2025-12-04T14:18:26.216Z 2025-12-05T14:23:04.695Z
8682949 8682949 20251203061657_htRba UK00CK 2025-12-04T14:18:23.389Z 2025-12-05T14:23:03.828Z
8682870 8682870 20251203061134_2jYU8 UK00CK 2025-12-04T14:18:10.224Z 2025-12-05T14:22:54.985Z
8682821 8682821 20251203060704_fkl1Q UK00CK 2025-12-04T14:18:03.707Z 2025-12-05T14:22:53.178Z
8682655 8682655 20251203055550_1qL7M UK00CK 2025-12-04T14:17:51.847Z 2025-12-05T14:22:46.589Z
8682347 8682347 20251203051832_xhwpw UK00CK 2025-12-04T14:16:50.918Z 2025-12-05T14:22:25.276Z
8682218 8682218 20251203050246_iIocV UK00CK 2025-12-04T14:16:38.383Z 2025-12-05T14:22:18.933Z
8681940 8681940 20251203043132_VvwKk UK00CK 2025-12-04T14:16:02.607Z 2025-12-05T14:22:09.005Z
8681600 8681600 20251203032921_T630U UK00CK 2025-12-04T14:15:06.577Z 2025-12-05T14:21:42.811Z
8681523 8681523 20251203032141_7g0RN UK00CK 2025-12-04T14:14:51.981Z 2025-12-05T14:21:40.114Z
8681410 8681410 20251203030522_l2iZg UK00CK 2025-12-04T14:14:40.041Z 2025-12-05T14:21:35.983Z
8681380 8681380 20251203030138_keE2i UK00CK 2025-12-04T14:14:35.817Z 2025-12-05T14:21:34.557Z
8681339 8681339 20251203025745_olBOe UK00CK 2025-12-04T14:14:31.870Z 2025-12-05T14:21:33.349Z
8681100 8681100 20251203022246_qWY27 UK00CK 2025-12-04T14:13:50.670Z 2025-12-05T14:21:16.334Z
8680728 8680728 20251203010958_ugOVs UK00CK 2025-12-04T14:12:48.870Z 2025-12-05T14:20:58.359Z
8680704 8680704 20251203010652_cFYcd UK00CK 2025-12-04T14:12:46.017Z 2025-12-05T14:20:52.901Z
8680607 8680607 20251203004654_7OKml UK00CK 2025-12-04T14:12:27.420Z 2025-12-05T14:20:48.816Z
8680538 8680538 20251203002604_96PLL UK00CK 2025-12-04T14:12:17.536Z 2025-12-05T14:20:43.410Z
8680492 8680492 20251203001904_84jI5 UK00CK 2025-12-04T14:12:11.212Z 2025-12-05T14:20:40.641Z
8680389 8680389 20251202234322_2voEr UK00CK 2025-12-04T14:11:54.535Z 2025-12-05T14:20:36.752Z
8680372 8680372 20251202233838_yxAUi UK00CK 2025-12-04T14:11:52.432Z 2025-12-05T14:20:35.969Z
8680212 8680212 20251202223051_FKn4q UK00CK 2025-12-04T14:11:25.363Z 2025-12-05T14:20:24.058Z
8680127 8680127 20251202215158_3hy3f UK00CK 2025-12-04T14:11:09.105Z 2025-12-05T14:20:18.551Z
8680054 8680054 20251202212803_JZ26Q UK00CK 2025-12-04T14:10:59.976Z 2025-12-05T14:20:15.683Z
8679977 8679977 20251202211301_tqBsS UK00CK 2025-12-04T14:10:49.817Z 2025-12-05T14:20:11.764Z
8679693 8679693 20251202203953_EUe3a UK00CK 2025-12-04T14:10:16.572Z 2025-12-05T14:19:53.941Z
8676985 8676985 20251202063619_F3JS8 UK00CK 2025-12-03T14:25:59.175Z 2025-12-05T14:29:17.374Z
8676852 8676852 20251202062759_i9Ph2 UK00CK 2025-12-03T14:25:52.815Z 2025-12-05T14:29:14.703Z
8676776 8676776 20251202062414_HIzOj UK00CK 2025-12-03T14:25:34.351Z 2025-12-05T14:29:13.193Z
8676711 8676711 20251202061516_X5jAV UK00CK 2025-12-03T14:25:27.105Z 2025-12-05T14:29:11.175Z
8676633 8676633 20251202060933_T3bUR UK00CK 2025-12-03T14:25:22.800Z 2025-12-05T14:29:09.245Z
8676625 8676625 20251202060852_GTz42 UK00CK 2025-12-03T14:25:22.449Z 2025-12-05T14:29:09.133Z
8676444 8676444 20251202055303_rJE7O UK00CK 2025-12-03T14:25:12.735Z 2025-12-05T14:28:56.468Z
8676426 8676426 20251202055148_BwZvy UK00CK 2025-12-03T14:25:11.972Z 2025-12-05T14:28:56.189Z
8676173 8676173 20251202053942_XoT3u UK00CK 2025-12-03T14:24:47.969Z 2025-12-05T14:28:49.808Z
8676057 8676057 20251202053410_JoXh5 UK00CK 2025-12-03T14:24:38.312Z 2025-12-05T14:28:47.152Z
8676036 8676036 20251202053346_SH1c8 UK00CK 2025-12-03T14:24:37.479Z 2025-12-05T14:28:46.821Z
8676020 8676020 20251202053251_hEamB UK00CK 2025-12-03T14:24:36.265Z 2025-12-05T14:28:46.226Z
8676009 8676009 20251202053053_619Iu UK00CK 2025-12-03T14:24:35.700Z 2025-12-05T14:28:45.949Z
8675920 8675920 20251202052257_DArRJ UK00CK 2025-12-03T14:24:29.975Z 2025-12-05T14:28:44.007Z
8675669 8675669 20251202050440_IjvhH UK00CK 2025-12-03T14:23:59.208Z 2025-12-05T14:28:37.573Z
8675539 8675539 20251202045507_Lbzry UK00CK 2025-12-03T14:23:50.385Z 2025-12-05T14:28:35.042Z
8675469 8675469 20251202044357_Kx77Z UK00CK 2025-12-03T14:23:45.215Z 2025-12-05T14:28:32.752Z
8675360 8675360 20251202043132_w7ZIK UK00CK 2025-12-03T14:23:33.657Z 2025-12-05T14:28:20.907Z
8675302 8675302 20251202042601_vsoN5 UK00CK 2025-12-03T14:23:30.010Z 2025-12-05T14:28:19.345Z
8674823 8674823 20251202032820_6pifZ UK00CK 2025-12-03T14:22:27.079Z 2025-12-05T14:28:03.872Z
8674042 8674042 20251202011559_aZDtO UK00CK 2025-12-03T14:20:47.138Z 2025-12-05T14:27:27.115Z
8674007 8674007 20251202010412_ExD5n UK00CK 2025-12-03T14:20:43.364Z 2025-12-05T14:27:25.786Z
8673886 8673886 20251202001700_5fMiy UK00CK 2025-12-03T14:20:14.895Z 2025-12-05T14:27:21.525Z
8673857 8673857 20251202000111_E2ztj UK00CK 2025-12-03T14:20:12.087Z 2025-12-05T14:27:20.423Z
8673844 8673844 20251201235812_BjBhz UK00CK 2025-12-03T14:20:10.363Z 2025-12-05T14:27:19.566Z
8668003 8668003 20251130053840_CBe9R UK00CK 2025-12-02T14:41:28.944Z 2025-12-05T14:45:28.162Z
8667692 8667692 20251130032031_hIJxC UK00CK 2025-12-02T14:39:45.161Z 2025-12-05T14:44:12.345Z
8658506 8658506 20251126024138_NAk8Q UK00CK 2025-12-01T15:03:37.928Z 2025-12-04T15:09:32.685Z
8658504 8658504 20251126024137_hY9Mh UK00CK 2025-12-01T15:03:37.558Z 2025-12-04T15:09:32.497Z
8657702 8657702 20251130060057_Uh59I UK00CK 2025-12-01T14:34:38.614Z 2025-12-05T14:45:35.625Z
8657439 8657439 20251130054522_D8Im5 UK00CK 2025-12-01T14:34:26.053Z 2025-12-05T14:45:30.113Z
8657403 8657403 20251130054122_ygds5 UK00CK 2025-12-01T14:34:22.023Z 2025-12-05T14:45:29.283Z
8657348 8657348 20251130053946_Tq5TP UK00CK 2025-12-01T14:34:07.577Z 2025-12-05T14:45:28.409Z
8656941 8656941 20251130051838_Tiv6C UK00CK 2025-12-01T14:33:49.352Z 2025-12-05T14:45:23.397Z
8656672 8656672 20251130050557_M6v3F UK00CK 2025-12-01T14:28:53.505Z 2025-12-05T14:45:19.766Z
8656158 8656158 20251130044007_nc34g UK00CK 2025-12-01T14:28:06.759Z 2025-12-05T14:44:46.798Z
8655940 8655940 20251130042541_Zo7Ss UK00CK 2025-12-01T14:27:41.516Z 2025-12-05T14:44:41.278Z
8655812 8655812 20251130041955_OHKix UK00CK 2025-12-01T14:27:31.201Z 2025-12-05T14:44:39.447Z
8655601 8655601 20251130040815_GqLlJ UK00CK 2025-12-01T14:27:15.360Z 2025-12-05T14:44:36.044Z
8655530 8655530 20251130040628_6jytl UK00CK 2025-12-01T14:27:02.138Z 2025-12-05T14:44:34.902Z
8655450 8655450 20251130040216_pg5fn UK00CK 2025-12-01T14:26:54.317Z 2025-12-05T14:44:33.693Z
8655305 8655305 20251130035347_dHxxi UK00CK 2025-12-01T14:26:44.532Z 2025-12-05T14:44:31.625Z
8655126 8655126 20251130034514_3lwWx UK00CK 2025-12-01T14:26:24.055Z 2025-12-05T14:44:28.101Z
8654670 8654670 20251130032455_hrwcX UK00CK 2025-12-01T14:25:42.517Z 2025-12-05T14:44:19.991Z
8654403 8654403 20251130031444_0DyC2 UK00CK 2025-12-01T14:25:22.765Z 2025-12-05T14:43:55.190Z
8654273 8654273 20251130030706_bvFzu UK00CK 2025-12-01T14:25:03.706Z 2025-12-05T14:43:52.407Z
8654190 8654190 20251130030236_i5D2b UK00CK 2025-12-01T14:24:56.912Z 2025-12-05T14:43:48.584Z
8654153 8654153 20251130030122_P3pIF UK00CK 2025-12-01T14:24:54.891Z 2025-12-05T14:43:47.950Z
8654084 8654084 20251130025610_k6sd6 UK00CK 2025-12-01T14:24:49.253Z 2025-12-05T14:43:46.342Z
8654011 8654011 20251130025159_qoEtY UK00CK 2025-12-01T14:24:44.380Z 2025-12-05T14:43:44.939Z
8653937 8653937 20251130024833_7iCgP UK00CK 2025-12-01T14:24:30.501Z 2025-12-05T14:43:42.914Z
8653694 8653694 20251130023510_Lfvs4 UK00CK 2025-12-01T14:23:56.411Z 2025-12-05T14:43:37.745Z
8653256 8653256 20251130020508_ZVmWw UK00CK 2025-12-01T14:23:07.833Z 2025-12-05T14:43:06.662Z
8653200 8653200 20251130020132_hfVYU UK00CK 2025-12-01T14:23:03.294Z 2025-12-05T14:43:05.279Z
8652968 8652968 20251130014804_2B2Nm UK00CK 2025-12-01T14:22:35.487Z 2025-12-05T14:42:58.390Z
8652663 8652663 20251130012633_PA0ew UK00CK 2025-12-01T14:21:56.191Z 2025-12-05T14:42:49.611Z
8652646 8652646 20251130012603_acxvx UK00CK 2025-12-01T14:21:55.175Z 2025-12-05T14:42:49.348Z
8652631 8652631 20251130012501_9mbQ1 UK00CK 2025-12-01T14:21:53.073Z 2025-12-05T14:42:48.927Z
8652608 8652608 20251130012250_ulDaA UK00CK 2025-12-01T14:21:51.162Z 2025-12-05T14:42:48.561Z
8652549 8652549 20251130011821_2gizD UK00CK 2025-12-01T14:21:40.188Z 2025-12-05T14:42:47.257Z
8652488 8652488 20251130011229_26Ur0 UK00CK 2025-12-01T14:21:29.968Z 2025-12-05T14:42:45.523Z
8652446 8652446 20251130010925_kG7ru UK00CK 2025-12-01T14:21:24.133Z 2025-12-05T14:42:44.619Z
8652352 8652352 20251130010357_z43NI UK00CK 2025-12-01T14:21:17.257Z 2025-12-05T14:42:43.019Z
8651782 8651782 20251130001756_3yTNn UK00CK 2025-12-01T14:19:52.385Z 2025-12-05T14:42:05.845Z
8651774 8651774 20251130001756_Vdyva UK00CK 2025-12-01T14:19:51.998Z 2025-12-05T14:42:05.661Z
8651529 8651529 20251129235339_WXO5c UK00CK 2025-12-01T14:19:16.007Z 2025-12-05T14:41:59.716Z
8651465 8651465 20251129234504_Ggy7R UK00CK 2025-12-01T14:19:09.329Z 2025-12-05T14:41:58.498Z
8651260 8651260 20251129231515_SkSL2 UK00CK 2025-12-01T14:18:29.599Z 2025-12-05T14:41:53.145Z
8651250 8651250 20251129231135_49eeD UK00CK 2025-12-01T14:18:28.515Z 2025-12-05T14:41:52.873Z
8651228 8651228 20251129230939_Fy3sG UK00CK 2025-12-01T14:18:26.175Z 2025-12-05T14:41:52.343Z
8650501 8650501 20251129203252_8cbrF UK00CK 2025-12-01T14:16:20.072Z 2025-12-05T14:41:09.085Z

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