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

9,661 rows where station_code = "UK004E" 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
8691454 8691454 20251205054454_jnU2r UK004E 2025-12-06T14:17:49.222Z 2025-12-06T14:18:01.118Z
8691335 8691335 20251205044705_qMJtO UK004E 2025-12-06T14:17:24.258Z 2025-12-06T14:18:01.089Z
8691308 8691308 20251205043154_9nHjO UK004E 2025-12-06T14:17:18.092Z 2025-12-06T14:18:01.081Z
8691306 8691306 20251205043056_VWedB UK004E 2025-12-06T14:17:17.417Z 2025-12-06T14:18:01.081Z
8691294 8691294 20251205042544_Nmfk2 UK004E 2025-12-06T14:17:15.676Z 2025-12-06T14:18:01.077Z
8691241 8691241 20251205041237_e0vyL UK004E 2025-12-06T14:17:01.464Z 2025-12-06T14:18:01.067Z
8691220 8691220 20251205040956_zJ4pH UK004E 2025-12-06T14:16:55.591Z 2025-12-06T14:18:01.062Z
8691182 8691182 20251205040003_q23FH UK004E 2025-12-06T14:16:48.913Z 2025-12-06T14:18:01.051Z
8691110 8691110 20251205033451_vZH2L UK004E 2025-12-06T14:16:30.938Z 2025-12-06T14:18:01.034Z
8691082 8691082 20251205032444_R832o UK004E 2025-12-06T14:16:26.340Z 2025-12-06T14:18:01.028Z
8691039 8691039 20251205025919_lKMHd UK004E 2025-12-06T14:16:20.304Z 2025-12-06T14:18:01.018Z
8690942 8690942 20251205022802_J6Xhp UK004E 2025-12-06T14:15:55.380Z 2025-12-06T14:18:00.994Z
8690904 8690904 20251205021702_Uqtnj UK004E 2025-12-06T14:15:48.641Z 2025-12-06T14:18:00.985Z
8690758 8690758 20251205014412_DylAm UK004E 2025-12-06T14:15:24.328Z 2025-12-06T14:18:00.955Z
8690737 8690737 20251205013847_MbQZa UK004E 2025-12-06T14:15:18.224Z 2025-12-06T14:18:00.950Z
8690664 8690664 20251205011646_aj46v UK004E 2025-12-06T14:15:06.861Z 2025-12-06T14:18:00.932Z
8690618 8690618 20251205010559_Z0NGI UK004E 2025-12-06T14:14:59.227Z 2025-12-06T14:18:00.923Z
8690616 8690616 20251205010429_23mbk UK004E 2025-12-06T14:14:58.796Z 2025-12-06T14:18:00.922Z
8690563 8690563 20251205002846_G1Iyv UK004E 2025-12-06T14:14:43.260Z 2025-12-06T14:18:00.909Z
8690430 8690430 20251204233623_HBuEd UK004E 2025-12-06T14:14:23.894Z 2025-12-06T14:18:00.880Z
8690423 8690423 20251204233233_OGQZF UK004E 2025-12-06T14:14:17.700Z 2025-12-06T14:18:00.878Z
8690234 8690234 20251204222108_uCVB8 UK004E 2025-12-06T14:13:51.156Z 2025-12-06T14:18:00.845Z
8683011 8683011 20251203061846_7zBlW UK004E 2025-12-04T14:18:26.788Z 2025-12-06T14:29:38.767Z
8682979 8682979 20251203061825_s0je4 UK004E 2025-12-04T14:18:25.962Z 2025-12-06T14:29:37.009Z
8682513 8682513 20251203054201_37RN8 UK004E 2025-12-04T14:17:20.106Z 2025-12-06T14:29:12.737Z
8682282 8682282 20251203051050_FMTfL UK004E 2025-12-04T14:16:43.812Z 2025-12-06T14:28:52.276Z
8682128 8682128 20251203045319_AFSA2 UK004E 2025-12-04T14:16:29.068Z 2025-12-06T14:28:47.241Z
8681810 8681810 20251203040917_0r93f UK004E 2025-12-04T14:15:39.309Z 2025-12-06T14:28:32.066Z
8681792 8681792 20251203040715_17LqG UK004E 2025-12-04T14:15:36.710Z 2025-12-06T14:28:31.421Z
8681746 8681746 20251203035514_WUVrP UK004E 2025-12-04T14:15:29.798Z 2025-12-06T14:28:27.951Z
8681622 8681622 20251203033315_Bmw6U UK004E 2025-12-04T14:15:09.673Z 2025-12-06T14:28:21.341Z
8681472 8681472 20251203031538_Etj3d UK004E 2025-12-04T14:14:48.125Z 2025-12-06T14:28:13.789Z
8681434 8681434 20251203030941_x0cIa UK004E 2025-12-04T14:14:43.025Z 2025-12-06T14:28:07.815Z
8681423 8681423 20251203030821_3C3eB UK004E 2025-12-04T14:14:41.821Z 2025-12-06T14:28:06.947Z
8681222 8681222 20251203024516_OM2VN UK004E 2025-12-04T14:14:05.411Z 2025-12-06T14:27:56.560Z
8681157 8681157 20251203022845_YdyOb UK004E 2025-12-04T14:13:57.995Z 2025-12-06T14:27:51.436Z
8680812 8680812 20251203012339_ng0Yn UK004E 2025-12-04T14:12:58.770Z 2025-12-06T14:27:27.647Z
8680806 8680806 20251203012339_f5Or1 UK004E 2025-12-04T14:12:58.372Z 2025-12-06T14:27:27.518Z
8680752 8680752 20251203011254_Giu3q UK004E 2025-12-04T14:12:51.729Z 2025-12-06T14:27:25.010Z
8680650 8680650 20251203005555_JBFOi UK004E 2025-12-04T14:12:35.078Z 2025-12-06T14:27:21.163Z
8663349 8663349 20251130203627_0Gobs UK004E 2025-12-02T14:18:01.746Z 2025-12-06T14:39:58.827Z
8661804 8661804 20251130171255_qFW9z UK004E 2025-12-02T14:13:05.127Z 2025-12-06T14:38:35.335Z
8657846 8657846 20251130061206_RsFc6 UK004E 2025-12-01T14:34:43.165Z 2025-12-06T14:50:23.040Z
8657721 8657721 20251130060341_wMa93 UK004E 2025-12-01T14:34:39.221Z 2025-12-06T14:50:22.011Z
8657542 8657542 20251130055153_ba6OR UK004E 2025-12-01T14:34:32.735Z 2025-12-06T14:50:08.047Z
8657253 8657253 20251130053727_kpfIq UK004E 2025-12-01T14:34:02.523Z 2025-12-06T14:49:47.966Z
8657187 8657187 20251130053314_3QQm7 UK004E 2025-12-01T14:33:59.996Z 2025-12-06T14:49:45.623Z
8657102 8657102 20251130052954_GTKmd UK004E 2025-12-01T14:33:54.630Z 2025-12-06T14:49:44.845Z
8657046 8657046 20251130052620_TvXo6 UK004E 2025-12-01T14:33:52.497Z 2025-12-06T14:49:44.181Z
8656727 8656727 20251130050728_4hmfK UK004E 2025-12-01T14:28:58.216Z 2025-12-06T14:49:39.279Z
8656402 8656402 20251130045328_cAUlM UK004E 2025-12-01T14:28:36.187Z 2025-12-06T14:49:34.350Z
8656354 8656354 20251130045136_lwFpJ UK004E 2025-12-01T14:28:23.780Z 2025-12-01T14:28:23.780Z
8655759 8655759 20251130041641_2eJFK UK004E 2025-12-01T14:27:26.937Z 2025-12-01T14:27:26.937Z
8655561 8655561 20251130040715_9Rsze UK004E 2025-12-01T14:27:03.971Z 2025-12-06T14:49:25.272Z
8655462 8655462 20251130040317_WJtXd UK004E 2025-12-01T14:26:55.778Z 2025-12-06T14:49:20.632Z
8655455 8655455 20251130040311_f5jWu UK004E 2025-12-01T14:26:55.032Z 2025-12-01T14:26:55.032Z
8655452 8655452 20251130040255_CLLX6 UK004E 2025-12-01T14:26:54.547Z 2025-12-01T14:26:54.547Z
8655215 8655215 20251130034858_G6FvE UK004E 2025-12-01T14:26:39.348Z 2025-12-06T14:48:53.691Z
8655037 8655037 20251130034117_2fZcZ UK004E 2025-12-01T14:26:17.186Z 2025-12-01T14:26:17.186Z
8654959 8654959 20251130033953_l5rOB UK004E 2025-12-01T14:26:13.018Z 2025-12-06T14:48:50.502Z
8654632 8654632 20251130032329_ith1L UK004E 2025-12-01T14:25:38.986Z 2025-12-06T14:48:45.119Z
8654418 8654418 20251130031453_yqFas UK004E 2025-12-01T14:25:23.563Z 2025-12-06T14:48:42.125Z
8651380 8651380 20251129233435_SHM0X UK004E 2025-12-01T14:18:55.755Z 2025-12-06T14:46:45.194Z
8651076 8651076 20251129223954_0qvQe UK004E 2025-12-01T14:17:58.051Z 2025-12-06T14:46:39.491Z
8651042 8651042 20251129222914_W0iZY UK004E 2025-12-01T14:17:53.538Z 2025-12-06T14:46:38.709Z
8650920 8650920 20251129220631_fkz77 UK004E 2025-12-01T14:17:32.127Z 2025-12-06T14:46:35.989Z
8650809 8650809 20251129213405_Hlw3x UK004E 2025-12-01T14:17:13.445Z 2025-12-06T14:46:34.190Z
8650542 8650542 20251129203724_qGoDz UK004E 2025-12-01T14:16:26.034Z 2025-12-06T14:46:06.751Z
8650503 8650503 20251129203314_r5n7H UK004E 2025-12-01T14:16:20.532Z 2025-12-06T14:45:58.018Z
8650446 8650446 20251129202114_qtBnd UK004E 2025-12-01T14:16:13.323Z 2025-12-06T14:45:56.720Z
8645212 8645212 20251128205206_rZK5H UK004E 2025-11-30T14:23:12.858Z 2025-12-06T14:54:51.547Z
8635151 8635151 20251128014723_Bwq1u UK004E 2025-11-29T14:22:45.038Z 2025-12-06T15:02:41.212Z
8621937 8621937 20251126171438_vcO7i UK004E 2025-11-28T14:17:05.281Z 2025-12-05T15:02:49.636Z
8616083 8616083 20251126053734_2SJoa UK004E 2025-11-27T14:30:29.191Z 2025-12-04T15:11:35.424Z
8616073 8616073 20251126053631_I3aYn UK004E 2025-11-27T14:30:28.199Z 2025-12-04T15:11:35.223Z
8616067 8616067 20251126053503_YM9C2 UK004E 2025-11-27T14:30:27.424Z 2025-12-04T15:11:35.072Z
8615788 8615788 20251126051907_bIt5B UK004E 2025-11-27T14:30:10.683Z 2025-12-04T15:11:32.353Z
8615368 8615368 20251126045846_NYw4T UK004E 2025-11-27T14:29:28.945Z 2025-12-04T15:11:28.069Z
8615175 8615175 20251126044911_3gtCZ UK004E 2025-11-27T14:29:18.345Z 2025-12-04T15:11:26.522Z
8615089 8615089 20251126044508_12eWG UK004E 2025-11-27T14:29:06.718Z 2025-11-27T14:32:46.590Z
8614789 8614789 20251126042731_5lh4k UK004E 2025-11-27T14:28:33.339Z 2025-12-04T15:11:08.987Z
8614707 8614707 20251126042430_P1mlP UK004E 2025-11-27T14:28:28.655Z 2025-12-04T15:11:00.335Z
8614502 8614502 20251126041559_Ey14H UK004E 2025-11-27T14:27:56.065Z 2025-12-04T15:10:46.910Z
8614128 8614128 20251126035237_7N3a1 UK004E 2025-11-27T14:27:15.554Z 2025-12-04T15:10:22.989Z
8614110 8614110 20251126035150_BxJ8O UK004E 2025-11-27T14:27:13.814Z 2025-12-04T15:10:21.802Z
8614039 8614039 20251126034814_xYFJD UK004E 2025-11-27T14:27:07.670Z 2025-12-04T15:10:11.838Z
8613998 8613998 20251126034644_OlOxU UK004E 2025-11-27T14:27:04.221Z 2025-12-04T15:10:07.025Z
8613976 8613976 20251126034406_MAXNU UK004E 2025-11-27T14:27:02.051Z 2025-12-04T15:10:01.923Z
8613956 8613956 20251126034301_paf3z UK004E 2025-11-27T14:27:00.169Z 2025-12-04T15:09:56.937Z
8613554 8613554 20251126032326_D44Y0 UK004E 2025-11-27T14:26:12.866Z 2025-12-04T15:09:47.708Z
8613468 8613468 20251126031855_kqobI UK004E 2025-11-27T14:26:07.240Z 2025-12-04T15:09:40.975Z
8613463 8613463 20251126031849_VqMnr UK004E 2025-11-27T14:26:06.575Z 2025-12-04T15:09:40.818Z
8613115 8613115 20251126030236_0mCG2 UK004E 2025-11-27T14:25:24.398Z 2025-12-04T15:09:37.329Z
8612874 8612874 20251126025324_2osDh UK004E 2025-11-27T14:24:57.151Z 2025-12-04T15:09:35.397Z
8612582 8612582 20251126023849_Hcny5 UK004E 2025-11-27T14:24:23.200Z 2025-12-04T15:09:32.127Z
8611840 8611840 20251126020150_gYHTM UK004E 2025-11-27T14:22:56.705Z 2025-12-04T15:09:24.602Z
8611600 8611600 20251126015233_1lFUx UK004E 2025-11-27T14:22:21.550Z 2025-12-04T15:09:22.881Z
8611561 8611561 20251126015118_HgLuk UK004E 2025-11-27T14:22:19.328Z 2025-12-04T15:09:22.547Z
8610131 8610131 20251126002518_aP89w UK004E 2025-11-27T14:19:29.296Z 2025-12-04T15:08:02.721Z
8609274 8609274 20251125232820_BmGFE UK004E 2025-11-27T14:18:00.154Z 2025-12-04T15:07:53.048Z

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