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

4,007 rows where station_code = "UK001H" 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
8683292 8683292 20251203065311_paGgM UK001H 2025-12-04T14:19:05.502Z 2025-12-05T14:23:15.065Z
8683241 8683241 20251203064422_d2G2C UK001H 2025-12-04T14:18:58.980Z 2025-12-05T14:23:12.489Z
8683130 8683130 20251203062844_ezPHV UK001H 2025-12-04T14:18:35.762Z 2025-12-05T14:23:08.237Z
8682785 8682785 20251203060308_cU6Fs UK001H 2025-12-04T14:18:00.652Z 2025-12-05T14:22:51.920Z
8680426 8680426 20251202235454_KyltJ UK001H 2025-12-04T14:11:58.382Z 2025-12-05T14:20:37.882Z
8680422 8680422 20251202235402_VFJIs UK001H 2025-12-04T14:11:57.886Z 2025-12-05T14:20:37.692Z
8680267 8680267 20251202225145_2KguX UK001H 2025-12-04T14:11:31.409Z 2025-12-05T14:20:26.588Z
8676808 8676808 20251202062700_m0xOy UK001H 2025-12-03T14:25:51.470Z 2025-12-05T14:29:14.290Z
8676639 8676639 20251202060936_YuXV3 UK001H 2025-12-03T14:25:23.718Z 2025-12-05T14:29:09.527Z
8676272 8676272 20251202054412_uOxod UK001H 2025-12-03T14:24:55.389Z 2025-12-05T14:28:53.746Z
8675989 8675989 20251202052922_VBv5q UK001H 2025-12-03T14:24:35.072Z 2025-12-05T14:28:45.707Z
8675757 8675757 20251202051221_62GXu UK001H 2025-12-03T14:24:14.144Z 2025-12-05T14:28:40.236Z
8675700 8675700 20251202051017_M951F UK001H 2025-12-03T14:24:11.182Z 2025-12-05T14:28:38.958Z
8675410 8675410 20251202043645_wANAB UK001H 2025-12-03T14:23:41.310Z 2025-12-05T14:28:31.333Z
8675381 8675381 20251202043404_4Fhv9 UK001H 2025-12-03T14:23:39.461Z 2025-12-05T14:28:29.343Z
8675162 8675162 20251202041050_zU6aO UK001H 2025-12-03T14:23:14.170Z 2025-12-05T14:28:13.865Z
8674899 8674899 20251202033727_jAqMX UK001H 2025-12-03T14:22:41.875Z 2025-12-05T14:28:06.091Z
8674699 8674699 20251202030755_TVArG UK001H 2025-12-03T14:22:13.758Z 2025-12-05T14:28:00.091Z
8674247 8674247 20251202015430_FBiZ3 UK001H 2025-12-03T14:21:17.149Z 2025-12-05T14:27:33.680Z
8674189 8674189 20251202014528_ak0oi UK001H 2025-12-03T14:21:08.256Z 2025-12-05T14:27:31.779Z
8674172 8674172 20251202014324_d42jt UK001H 2025-12-03T14:21:07.470Z 2025-12-05T14:27:31.519Z
8661968 8661968 20251130173734_UjVZ2 UK001H 2025-12-02T14:13:45.268Z 2025-12-05T14:32:44.220Z
8658123 8658123 20251130064455_7avO9 UK001H 2025-12-01T14:34:56.008Z 2025-12-05T14:46:03.149Z
8654556 8654556 20251130032023_5iayK UK001H 2025-12-01T14:25:34.894Z 2025-12-05T14:44:12.225Z
8653842 8653842 20251130024432_i7wT7 UK001H 2025-12-01T14:24:22.619Z 2025-12-05T14:43:41.373Z
8653752 8653752 20251130023837_Ws56T UK001H 2025-12-01T14:24:10.662Z 2025-12-05T14:43:39.018Z
8653147 8653147 20251130020029_s2Wup UK001H 2025-12-01T14:22:56.828Z 2025-12-05T14:43:04.669Z
8651946 8651946 20251130003702_ouY2F UK001H 2025-12-01T14:20:19.313Z 2025-12-05T14:42:12.194Z
8651817 8651817 20251130002314_pLlZU UK001H 2025-12-01T14:19:59.918Z 2025-12-05T14:42:07.206Z
8651683 8651683 20251130000955_73079 UK001H 2025-12-01T14:19:40.855Z 2025-12-05T14:42:03.449Z
8646609 8646609 20251129023015_9LVTQ UK001H 2025-11-30T14:26:15.652Z 2025-12-05T14:51:45.430Z
8645416 8645416 20251128220233_XrxFh UK001H 2025-11-30T14:23:42.033Z 2025-12-05T14:50:38.493Z
8643340 8643340 20251128174425_V94Sx UK001H 2025-11-30T14:19:55.010Z 2025-12-05T14:49:16.046Z
8643278 8643278 20251128174017_OKDUr UK001H 2025-11-30T14:19:49.558Z 2025-12-05T14:49:14.846Z
8637731 8637731 20251128062520_jBv5g UK001H 2025-11-29T14:27:46.942Z 2025-12-05T15:00:21.691Z
8637288 8637288 20251128052539_TJ4JR UK001H 2025-11-29T14:27:03.163Z 2025-12-05T14:59:39.861Z
8636702 8636702 20251128041835_FwaqJ UK001H 2025-11-29T14:26:06.462Z 2025-12-05T14:59:28.381Z
8636014 8636014 20251128030639_t832W UK001H 2025-11-29T14:24:46.674Z 2025-12-05T14:59:18.154Z
8634971 8634971 20251128013051_O1xSz UK001H 2025-11-29T14:22:20.036Z 2025-12-05T14:58:27.092Z
8634955 8634955 20251128012912_vM2wc UK001H 2025-11-29T14:22:16.841Z 2025-12-05T14:58:26.866Z
8634938 8634938 20251128012756_brTmY UK001H 2025-11-29T14:22:13.255Z 2025-12-05T14:58:26.603Z
8634725 8634725 20251128011328_yQSd2 UK001H 2025-11-29T14:21:58.772Z 2025-12-05T14:58:24.090Z
8634111 8634111 20251128002158_uf5l1 UK001H 2025-11-29T14:20:47.529Z 2025-12-05T14:58:16.517Z
8632566 8632566 20251127211912_2h8xu UK001H 2025-11-29T14:17:48.082Z 2025-12-05T14:56:22.984Z
8631896 8631896 20251127201323_f82HV UK001H 2025-11-29T14:16:32.077Z 2025-12-05T14:56:13.093Z
8625961 8625961 20251126064551_xb4aO UK001H 2025-11-28T14:37:27.452Z 2025-12-04T15:11:44.751Z
8616579 8616579 20251126061045_rjJ2A UK001H 2025-11-27T14:31:18.329Z 2025-12-04T15:11:41.038Z
8616097 8616097 20251126053855_Hq2rE UK001H 2025-11-27T14:30:30.784Z 2025-12-04T15:11:35.721Z
8614604 8614604 20251126042011_32aAF UK001H 2025-11-27T14:28:05.616Z 2025-12-04T15:10:56.328Z
8614217 8614217 20251126035916_ypRYh UK001H 2025-11-27T14:27:40.479Z 2025-12-04T15:10:32.815Z
8614020 8614020 20251126034740_hFAbl UK001H 2025-11-27T14:27:06.146Z 2025-12-04T15:10:11.132Z
8613623 8613623 20251126032609_K9VLc UK001H 2025-11-27T14:26:18.478Z 2025-12-04T15:09:49.925Z
8613384 8613384 20251126031550_l0P1l UK001H 2025-11-27T14:25:46.156Z 2025-12-04T15:09:40.116Z
8612947 8612947 20251126025719_mx3cn UK001H 2025-11-27T14:25:02.270Z 2025-12-04T15:09:36.066Z
8611527 8611527 20251126015024_NdgjD UK001H 2025-11-27T14:22:16.680Z 2025-12-04T15:09:22.114Z
8611360 8611360 20251126013823_GDwsB UK001H 2025-11-27T14:22:01.065Z 2025-12-04T15:09:10.546Z
8610535 8610535 20251126005254_MeHTM UK001H 2025-11-27T14:20:17.220Z 2025-12-04T15:08:13.346Z
8609265 8609265 20251125232616_MU57N UK001H 2025-11-27T14:17:54.181Z 2025-12-04T15:07:52.925Z
8609157 8609157 20251125231544_UHteA UK001H 2025-11-27T14:17:37.172Z 2025-12-04T15:07:51.946Z
8608702 8608702 20251125223556_f2GSI UK001H 2025-11-27T14:16:33.245Z 2025-12-04T15:07:47.846Z
8608457 8608457 20251125221820_DwKZL UK001H 2025-11-27T14:16:08.391Z 2025-12-04T15:07:45.170Z
8607887 8607887 20251125213120_ZqkeA UK001H 2025-11-27T14:14:44.715Z 2025-12-04T15:07:38.653Z
8607581 8607581 20251125210403_NgtlE UK001H 2025-11-27T14:13:58.838Z 2025-12-04T15:07:03.971Z
8607509 8607509 20251125205907_3nm5c UK001H 2025-11-27T14:13:53.815Z 2025-12-04T15:07:03.307Z
8606501 8606501 20251125190044_2ne4b UK001H 2025-11-27T14:10:21.910Z 2025-12-04T15:06:46.084Z
8606485 8606485 20251125185822_5NJqR UK001H 2025-11-27T14:10:20.817Z 2025-12-04T15:06:45.964Z
8606125 8606125 20251125180005_4Nj00 UK001H 2025-11-27T14:09:09.291Z 2025-12-04T15:06:17.284Z
8603727 8603727 20251125063114_vMFXF UK001H 2025-11-26T14:27:44.802Z 2025-12-02T15:09:36.951Z
8603415 8603415 20251125060739_W6exG UK001H 2025-11-26T14:27:26.082Z 2025-12-02T15:09:35.741Z
8602729 8602729 20251125051935_xSaw3 UK001H 2025-11-26T14:26:17.264Z 2025-12-02T15:09:32.526Z
8602372 8602372 20251125045054_e96d6 UK001H 2025-11-26T14:25:35.990Z 2025-12-02T15:09:30.715Z
8601744 8601744 20251125041218_aXHwv UK001H 2025-11-26T14:24:39.638Z 2025-12-02T15:09:23.433Z
8601286 8601286 20251125034306_glGka UK001H 2025-11-26T14:23:52.186Z 2025-12-02T15:09:07.148Z
8600692 8600692 20251125031256_RoCI5 UK001H 2025-11-26T14:22:53.421Z 2025-12-02T15:08:49.753Z
8600646 8600646 20251125031042_g7tP7 UK001H 2025-11-26T14:22:51.364Z 2025-12-02T15:08:48.037Z
8600643 8600643 20251125031042_d3iWz UK001H 2025-11-26T14:22:51.281Z 2025-12-02T15:08:48.029Z
8596607 8596607 20251124214141_OBebA UK001H 2025-11-26T14:14:59.578Z 2025-12-02T15:07:03.347Z
8581819 8581819 20251123024039_7PMg1 UK001H 2025-11-24T14:32:40.137Z 2025-12-01T15:21:43.169Z
8569874 8569874 20251121062112_JlX1b UK001H 2025-11-23T14:32:41.150Z 2025-11-29T14:54:49.180Z
8569835 8569835 20251121061754_NaACz UK001H 2025-11-23T14:32:30.935Z 2025-11-29T14:54:49.097Z
8569401 8569401 20251121055626_l6Me1 UK001H 2025-11-23T14:32:14.464Z 2025-11-29T14:54:48.257Z
8568847 8568847 20251121053847_kdqL5 UK001H 2025-11-23T14:31:45.597Z 2025-11-29T14:54:47.524Z
8568140 8568140 20251121050304_yT5Bf UK001H 2025-11-23T14:30:54.301Z 2025-11-29T14:54:46.120Z
8567745 8567745 20251121020626_8m9Bq UK001H 2025-11-23T14:27:39.894Z 2025-11-29T14:54:32.762Z
8567474 8567474 20251120203332_x9hAD UK001H 2025-11-23T14:24:10.343Z 2025-11-29T14:54:21.754Z
8560408 8560408 20251121045321_GQFos UK001H 2025-11-22T14:42:52.212Z 2025-11-29T14:54:45.677Z
8560359 8560359 20251121045100_gY7cC UK001H 2025-11-22T14:42:51.320Z 2025-11-29T14:54:45.637Z
8559542 8559542 20251121041647_TTtdr UK001H 2025-11-22T14:41:58.156Z 2025-11-29T14:54:40.743Z
8559528 8559528 20251121041608_GYCmM UK001H 2025-11-22T14:41:57.972Z 2025-11-29T14:54:40.729Z
8559505 8559505 20251121041335_xzNFV UK001H 2025-11-22T14:41:57.063Z 2025-11-29T14:54:39.301Z
8559398 8559398 20251121040936_lChvH UK001H 2025-11-22T14:41:54.825Z 2025-11-29T14:54:38.428Z
8559318 8559318 20251121040524_gxM9A UK001H 2025-11-22T14:41:52.814Z 2025-11-29T14:54:37.790Z
8559291 8559291 20251121040408_TK7rm UK001H 2025-11-22T14:41:51.850Z 2025-11-29T14:54:37.774Z
8559212 8559212 20251121035905_C5SU1 UK001H 2025-11-22T14:41:50.142Z 2025-11-29T14:54:37.606Z
8557783 8557783 20251121030038_lhKXl UK001H 2025-11-22T14:40:39.768Z 2025-11-29T14:54:34.716Z
8556675 8556675 20251121020626_0PPzg UK001H 2025-11-22T14:39:40.194Z 2025-11-22T14:39:40.194Z
8556582 8556582 20251121020306_OZoLz UK001H 2025-11-22T14:39:37.658Z 2025-11-29T14:54:32.601Z
8552389 8552389 20251120040803_Wg7Lj UK001H 2025-11-22T14:32:23.346Z 2025-11-28T14:57:31.179Z
8551310 8551310 20251121003414_8tcTC UK001H 2025-11-22T14:22:24.430Z 2025-11-29T14:54:28.643Z
8551164 8551164 20251121002647_7I61j UK001H 2025-11-22T14:22:15.521Z 2025-11-22T14:22:15.521Z

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