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,666 rows where station_code = "UK009S" 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
8683219 8683219 20251203064314_FpBCE UK009S 2025-12-04T14:18:57.477Z 2025-12-05T14:23:11.905Z
8683160 8683160 20251203063341_RLR8q UK009S 2025-12-04T14:18:39.722Z 2025-12-05T14:23:09.475Z
8682956 8682956 20251203061700_TDsgd UK009S 2025-12-04T14:18:23.830Z 2025-12-05T14:23:03.888Z
8682773 8682773 20251203060230_2NDxJ UK009S 2025-12-04T14:17:59.484Z 2025-12-05T14:22:49.478Z
8682737 8682737 20251203060131_9N2KJ UK009S 2025-12-04T14:17:57.530Z 2025-12-05T14:22:48.593Z
8682732 8682732 20251203060113_Bz0H2 UK009S 2025-12-04T14:17:57.218Z 2025-12-05T14:22:48.493Z
8682535 8682535 20251203054352_XoNdP UK009S 2025-12-04T14:17:25.142Z 2025-12-05T14:22:41.934Z
8682495 8682495 20251203054014_T2Z8J UK009S 2025-12-04T14:17:18.943Z 2025-12-05T14:22:40.615Z
8682362 8682362 20251203052123_GuRKx UK009S 2025-12-04T14:17:01.228Z 2025-12-05T14:22:25.907Z
8682083 8682083 20251203044702_c94mT UK009S 2025-12-04T14:16:22.115Z 2025-12-05T14:22:13.699Z
8682027 8682027 20251203044152_2eMPE UK009S 2025-12-04T14:16:14.646Z 2025-12-05T14:22:12.137Z
8681939 8681939 20251203043132_VvwKk UK009S 2025-12-04T14:16:02.607Z 2025-12-05T14:22:09.005Z
8681910 8681910 20251203042704_QSlR0 UK009S 2025-12-04T14:15:59.382Z 2025-12-05T14:22:06.939Z
8681807 8681807 20251203040912_zxa5A UK009S 2025-12-04T14:15:38.986Z 2025-12-05T14:22:02.027Z
8681696 8681696 20251203034829_h3JhH UK009S 2025-12-04T14:15:18.255Z 2025-12-05T14:21:49.699Z
8681572 8681572 20251203032552_Ogp2S UK009S 2025-12-04T14:15:04.206Z 2025-12-05T14:21:41.705Z
8681519 8681519 20251203032141_7g0RN UK009S 2025-12-04T14:14:51.958Z 2025-12-05T14:21:40.114Z
8681490 8681490 20251203031551_ZB9Pb UK009S 2025-12-04T14:14:48.761Z 2025-12-05T14:21:38.837Z
8681453 8681453 20251203031203_XUJWE UK009S 2025-12-04T14:14:44.923Z 2025-12-05T14:21:37.820Z
8680530 8680530 20251203002536_l9Se2 UK009S 2025-12-04T14:12:16.678Z 2025-12-05T14:20:43.082Z
8680513 8680513 20251203001950_kSifl UK009S 2025-12-04T14:12:13.348Z 2025-12-05T14:20:41.071Z
8680407 8680407 20251202235333_Q7cip UK009S 2025-12-04T14:11:56.267Z 2025-12-05T14:20:37.383Z
8680369 8680369 20251202233838_yxAUi UK009S 2025-12-04T14:11:52.432Z 2025-12-05T14:20:35.969Z
8676493 8676493 20251202055527_gyFsG UK009S 2025-12-03T14:25:14.529Z 2025-12-05T14:28:57.255Z
8676266 8676266 20251202054246_u2aGA UK009S 2025-12-03T14:24:52.128Z 2025-12-05T14:28:51.124Z
8675971 8675971 20251202052755_89g4R UK009S 2025-12-03T14:24:34.479Z 2025-12-05T14:28:45.465Z
8675299 8675299 20251202042601_vsoN5 UK009S 2025-12-03T14:23:30.010Z 2025-12-05T14:28:19.345Z
8675217 8675217 20251202041801_1TvKz UK009S 2025-12-03T14:23:21.465Z 2025-12-05T14:28:17.003Z
8675208 8675208 20251202041758_3s3pA UK009S 2025-12-03T14:23:20.672Z 2025-12-05T14:28:16.802Z
8675082 8675082 20251202040004_1kj3S UK009S 2025-12-03T14:23:01.157Z 2025-12-05T14:28:10.715Z
8674688 8674688 20251202030654_KY8Fp UK009S 2025-12-03T14:22:12.546Z 2025-12-05T14:27:59.656Z
8674606 8674606 20251202025839_pN8co UK009S 2025-12-03T14:22:07.499Z 2025-12-05T14:27:57.709Z
8674517 8674517 20251202023944_rV4gr UK009S 2025-12-03T14:21:43.815Z 2025-12-05T14:27:51.395Z
8674505 8674505 20251202023708_Vt95J UK009S 2025-12-03T14:21:42.982Z 2025-12-05T14:27:45.269Z
8674488 8674488 20251202023306_d0ZQJ UK009S 2025-12-03T14:21:41.831Z 2025-12-05T14:27:42.991Z
8674474 8674474 20251202023152_1fI2d UK009S 2025-12-03T14:21:40.973Z 2025-12-05T14:27:42.663Z
8674355 8674355 20251202020727_2o3qX UK009S 2025-12-03T14:21:27.557Z 2025-12-05T14:27:38.794Z
8674347 8674347 20251202020608_eXtt3 UK009S 2025-12-03T14:21:26.997Z 2025-12-05T14:27:38.463Z
8674312 8674312 20251202015812_ogGZp UK009S 2025-12-03T14:21:22.894Z 2025-12-05T14:27:35.650Z
8674038 8674038 20251202011559_aZDtO UK009S 2025-12-03T14:20:47.128Z 2025-12-05T14:27:27.115Z
8668000 8668000 20251130053805_r65tp UK009S 2025-12-02T14:41:28.617Z 2025-12-05T14:45:27.906Z
8667291 8667291 20251129204119_JN1Vw UK009S 2025-12-02T14:36:28.568Z 2025-12-05T14:41:10.949Z
8658118 8658118 20251130064213_NU3HU UK009S 2025-12-01T14:34:55.479Z 2025-12-05T14:46:02.864Z
8658058 8658058 20251130063254_ISE9l UK009S 2025-12-01T14:34:53.076Z 2025-12-05T14:46:01.583Z
8657960 8657960 20251130062207_DRvvX UK009S 2025-12-01T14:34:47.456Z 2025-12-05T14:45:59.260Z
8657872 8657872 20251130061352_My5yj UK009S 2025-12-01T14:34:44.238Z 2025-12-05T14:45:46.718Z
8657662 8657662 20251130055628_qz2ZG UK009S 2025-12-01T14:34:36.262Z 2025-12-05T14:45:34.647Z
8657365 8657365 20251130054029_6HNo4 UK009S 2025-12-01T14:34:12.308Z 2025-12-05T14:45:28.720Z
8657014 8657014 20251130052408_RUpO5 UK009S 2025-12-01T14:33:51.846Z 2025-12-05T14:45:24.545Z
8656951 8656951 20251130052028_qI00i UK009S 2025-12-01T14:33:49.767Z 2025-12-05T14:45:23.873Z
8656928 8656928 20251130051818_GEpgT UK009S 2025-12-01T14:33:49.195Z 2025-12-05T14:45:23.290Z
8656432 8656432 20251130045602_Nw3vd UK009S 2025-12-01T14:28:38.417Z 2025-12-05T14:45:16.041Z
8656312 8656312 20251130044904_2thUo UK009S 2025-12-01T14:28:19.681Z 2025-12-05T14:45:04.449Z
8655730 8655730 20251130041351_VOOUA UK009S 2025-12-01T14:27:23.734Z 2025-12-05T14:44:37.709Z
8654979 8654979 20251130034005_ybsxo UK009S 2025-12-01T14:26:13.872Z 2025-12-05T14:44:26.516Z
8654907 8654907 20251130033833_ekNHY UK009S 2025-12-01T14:26:10.201Z 2025-12-05T14:44:25.772Z
8654734 8654734 20251130032959_zMKYH UK009S 2025-12-01T14:25:51.755Z 2025-12-05T14:44:22.430Z
8654284 8654284 20251130030714_RJXRC UK009S 2025-12-01T14:25:04.073Z 2025-12-05T14:43:52.463Z
8652943 8652943 20251130014610_D3wQI UK009S 2025-12-01T14:22:33.903Z 2025-12-05T14:42:58.018Z
8652744 8652744 20251130012954_D6LL5 UK009S 2025-12-01T14:22:03.515Z 2025-12-05T14:42:51.324Z
8652687 8652687 20251130012713_7hhQX UK009S 2025-12-01T14:21:58.801Z 2025-12-05T14:42:50.137Z
8652207 8652207 20251130005516_PQ6dv UK009S 2025-12-01T14:20:54.885Z 2025-12-05T14:42:36.103Z
8652113 8652113 20251130004831_fX0K1 UK009S 2025-12-01T14:20:44.425Z 2025-12-05T14:42:23.302Z
8651606 8651606 20251129235948_n0n2x UK009S 2025-12-01T14:19:26.950Z 2025-12-05T14:42:01.776Z
8651019 8651019 20251129222348_Rd1qM UK009S 2025-12-01T14:17:51.410Z 2025-12-05T14:41:34.201Z
8650568 8650568 20251129204119_ZnC7J UK009S 2025-12-01T14:16:28.898Z 2025-12-05T14:41:10.849Z
8633627 8633627 20251127234104_VlR3x UK009S 2025-11-29T14:19:59.740Z 2025-12-05T14:57:51.088Z
8632638 8632638 20251127212750_K7ObK UK009S 2025-11-29T14:17:55.225Z 2025-12-05T14:56:28.050Z
8617181 8617181 20251125052100_XyyaW UK009S 2025-11-27T14:41:30.442Z 2025-12-02T15:09:32.830Z
8617175 8617175 20251125022337_uPEE8 UK009S 2025-11-27T14:39:48.598Z 2025-12-02T15:08:32.140Z
8616761 8616761 20251126062533_b30jH UK009S 2025-11-27T14:31:48.384Z 2025-12-04T15:11:43.087Z
8616626 8616626 20251126061405_1nZkY UK009S 2025-11-27T14:31:23.247Z 2025-12-04T15:11:41.406Z
8616523 8616523 20251126060424_oAUDz UK009S 2025-11-27T14:31:15.456Z 2025-12-04T15:11:40.505Z
8616293 8616293 20251126054902_8zPLY UK009S 2025-11-27T14:31:01.469Z 2025-12-04T15:11:37.458Z
8615973 8615973 20251126053038_Kr31n UK009S 2025-11-27T14:30:19.399Z 2025-12-04T15:11:34.118Z
8615943 8615943 20251126052850_JwF8M UK009S 2025-11-27T14:30:18.010Z 2025-12-04T15:11:33.894Z
8615696 8615696 20251126051305_9eqfH UK009S 2025-11-27T14:30:05.446Z 2025-12-04T15:11:31.279Z
8614034 8614034 20251126034809_hk3QH UK009S 2025-11-27T14:27:07.279Z 2025-12-04T15:10:11.743Z
8614023 8614023 20251126034759_I8D1B UK009S 2025-11-27T14:27:06.525Z 2025-12-04T15:10:11.512Z
8613756 8613756 20251126033321_uaNlR UK009S 2025-11-27T14:26:29.730Z 2025-12-04T15:09:51.522Z
8613599 8613599 20251126032522_Svkqk UK009S 2025-11-27T14:26:16.767Z 2025-12-04T15:09:49.675Z
8613496 8613496 20251126031947_l7o7F UK009S 2025-11-27T14:26:08.906Z 2025-12-04T15:09:41.284Z
8613446 8613446 20251126031829_oRp9Q UK009S 2025-11-27T14:26:05.674Z 2025-12-04T15:09:40.669Z
8613344 8613344 20251126031415_djwQO UK009S 2025-11-27T14:25:39.096Z 2025-12-04T15:09:39.803Z
8613220 8613220 20251126031049_4JCIV UK009S 2025-11-27T14:25:32.761Z 2025-12-04T15:09:38.793Z
8613089 8613089 20251126030101_lyW1k UK009S 2025-11-27T14:25:22.359Z 2025-12-04T15:09:37.066Z
8613016 8613016 20251126025852_y8gla UK009S 2025-11-27T14:25:10.138Z 2025-12-04T15:09:36.456Z
8612742 8612742 20251126024400_47F2j UK009S 2025-11-27T14:24:35.298Z 2025-12-04T15:09:33.523Z
8612667 8612667 20251126024137_TQycr UK009S 2025-11-27T14:24:26.747Z 2025-12-04T15:09:32.616Z
8612644 8612644 20251126024036_Low24 UK009S 2025-11-27T14:24:25.530Z 2025-12-04T15:09:32.343Z
8612605 8612605 20251126023902_0l3CJ UK009S 2025-11-27T14:24:24.199Z 2025-12-04T15:09:32.198Z
8612571 8612571 20251126023804_nmVKI UK009S 2025-11-27T14:24:22.620Z 2025-12-04T15:09:32.070Z
8612518 8612518 20251126023435_DnFNB UK009S 2025-11-27T14:24:17.131Z 2025-12-04T15:09:31.267Z
8612423 8612423 20251126023103_2ym32 UK009S 2025-11-27T14:24:09.000Z 2025-12-04T15:09:30.591Z
8612219 8612219 20251126022157_SkEVY UK009S 2025-11-27T14:23:37.340Z 2025-12-04T15:09:28.277Z
8612135 8612135 20251126021923_4Ig3x UK009S 2025-11-27T14:23:32.592Z 2025-12-04T15:09:27.867Z
8611727 8611727 20251126015734_lAFBU UK009S 2025-11-27T14:22:32.697Z 2025-12-04T15:09:23.725Z
8611627 8611627 20251126015343_flc72 UK009S 2025-11-27T14:22:22.784Z 2025-12-04T15:09:22.961Z
8611608 8611608 20251126015239_zO2kh UK009S 2025-11-27T14:22:22.182Z 2025-12-04T15:09:22.922Z
8611594 8611594 20251126015219_OSZ3v UK009S 2025-11-27T14:22:21.208Z 2025-12-04T15:09:22.819Z

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