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

2,759 rows where station_code = "UK008H" 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
8681285 8681285 20251203025337_mwb1J UK008H 2025-12-04T14:14:15.926Z 2025-12-06T14:27:59.420Z
8681220 8681220 20251203024244_c2vDt UK008H 2025-12-04T14:14:05.082Z 2025-12-06T14:27:56.238Z
8681215 8681215 20251203024043_yyoRh UK008H 2025-12-04T14:14:04.568Z 2025-12-06T14:27:55.956Z
8680658 8680658 20251203005642_fYRdO UK008H 2025-12-04T14:12:35.642Z 2025-12-06T14:27:21.307Z
8677002 8677002 20251202063730_T2BVM UK008H 2025-12-03T14:26:00.995Z 2025-12-06T14:35:32.569Z
8676665 8676665 20251202061107_Y3jbD UK008H 2025-12-03T14:25:25.242Z 2025-12-06T14:35:26.774Z
8676642 8676642 20251202060936_YuXV3 UK008H 2025-12-03T14:25:23.750Z 2025-12-06T14:35:25.764Z
8675992 8675992 20251202052922_VBv5q UK008H 2025-12-03T14:24:35.072Z 2025-12-06T14:35:06.287Z
8675867 8675867 20251202051903_bGZ6G UK008H 2025-12-03T14:24:26.934Z 2025-12-06T14:35:03.630Z
8675759 8675759 20251202051221_62GXu UK008H 2025-12-03T14:24:14.144Z 2025-12-06T14:34:59.590Z
8675412 8675412 20251202043645_wANAB UK008H 2025-12-03T14:23:41.310Z 2025-12-06T14:34:51.700Z
8675389 8675389 20251202043404_4Fhv9 UK008H 2025-12-03T14:23:39.461Z 2025-12-06T14:34:50.943Z
8675282 8675282 20251202042536_XKKLE UK008H 2025-12-03T14:23:28.978Z 2025-12-06T14:34:48.786Z
8675141 8675141 20251202040505_WAX13 UK008H 2025-12-03T14:23:07.010Z 2025-12-06T14:34:33.656Z
8649757 8649757 20251129181910_xCO5k UK008H 2025-12-01T14:13:46.272Z 2025-12-06T14:45:38.804Z
8636592 8636592 20251128040741_ewFTg UK008H 2025-11-29T14:25:44.175Z 2025-12-06T15:03:31.848Z
8634641 8634641 20251128010602_XuaYC UK008H 2025-11-29T14:21:42.510Z 2025-12-06T15:02:26.476Z
8614782 8614782 20251126042626_k1owS UK008H 2025-11-27T14:28:32.600Z 2025-12-04T15:11:08.025Z
8614621 8614621 20251126042040_2Nz1g UK008H 2025-11-27T14:28:07.181Z 2025-12-04T15:10:56.674Z
8612502 8612502 20251126023336_r8Znt UK008H 2025-11-27T14:24:16.532Z 2025-12-04T15:09:31.224Z
8611918 8611918 20251126020749_rwSOF UK008H 2025-11-27T14:23:03.799Z 2025-12-04T15:09:25.516Z
8611245 8611245 20251126013344_arCHm UK008H 2025-11-27T14:21:43.457Z 2025-12-04T15:09:00.065Z
8611237 8611237 20251126013249_73s22 UK008H 2025-11-27T14:21:42.724Z 2025-12-04T15:08:59.648Z
8610540 8610540 20251126005254_DF6hj UK008H 2025-11-27T14:20:17.468Z 2025-12-04T15:08:13.386Z
8610449 8610449 20251126004645_mv6bn UK008H 2025-11-27T14:20:09.311Z 2025-12-04T15:08:05.848Z
8610318 8610318 20251126003828_57H6b UK008H 2025-11-27T14:19:45.054Z 2025-12-04T15:08:04.133Z
8610186 8610186 20251126003007_2GbLy UK008H 2025-11-27T14:19:33.977Z 2025-12-04T15:08:03.206Z
8603834 8603834 20251125065318_itk9U UK008H 2025-11-26T14:28:18.019Z 2025-12-02T15:09:37.793Z
8601782 8601782 20251125041553_Qek18 UK008H 2025-11-26T14:24:42.614Z 2025-12-02T15:09:24.463Z
8600812 8600812 20251125031743_x2v5u UK008H 2025-11-26T14:22:58.871Z 2025-12-02T15:08:50.742Z
8599710 8599710 20251125022021_cbIg6 UK008H 2025-11-26T14:21:25.453Z 2025-12-02T15:08:31.286Z
8599521 8599521 20251125020944_xsZCg UK008H 2025-11-26T14:21:13.505Z 2025-12-02T15:08:28.346Z
8599156 8599156 20251125015029_45LYZ UK008H 2025-11-26T14:20:36.201Z 2025-12-02T15:08:20.450Z
8598537 8598537 20251125010311_cqkcI UK008H 2025-11-26T14:19:14.143Z 2025-12-02T15:08:00.758Z
8598223 8598223 20251125004355_KKVTT UK008H 2025-11-26T14:18:28.434Z 2025-12-02T15:07:48.785Z
8598134 8598134 20251125003621_FjM97 UK008H 2025-11-26T14:18:20.567Z 2025-12-02T15:07:46.846Z
8597089 8597089 20251124225415_VAec6 UK008H 2025-11-26T14:15:58.951Z 2025-12-02T15:07:22.904Z
8596611 8596611 20251124214141_OBebA UK008H 2025-11-26T14:14:59.578Z 2025-12-02T15:07:03.347Z
8498193 8498193 20251117060949_q2AyT UK008H 2025-11-18T14:29:50.291Z 2025-11-25T15:10:58.405Z
8497820 8497820 20251117055117_A0ajK UK008H 2025-11-18T14:29:33.020Z 2025-11-25T15:10:54.058Z
8497644 8497644 20251117054140_013Ja UK008H 2025-11-18T14:29:25.039Z 2025-11-25T15:10:51.691Z
8497143 8497143 20251117051354_KlA4R UK008H 2025-11-18T14:28:40.203Z 2025-11-25T15:10:33.639Z
8496285 8496285 20251117043139_jwaRF UK008H 2025-11-18T14:27:34.857Z 2025-11-25T15:10:12.933Z
8495826 8495826 20251117041158_exKg6 UK008H 2025-11-18T14:26:51.169Z 2025-11-25T15:10:03.783Z
8495550 8495550 20251117035539_O6n33 UK008H 2025-11-18T14:26:19.111Z 2025-11-25T15:09:55.383Z
8495236 8495236 20251117033633_utOW2 UK008H 2025-11-18T14:25:42.044Z 2025-11-25T15:09:49.121Z
8494984 8494984 20251117032314_t7Btb UK008H 2025-11-18T14:25:23.615Z 2025-11-25T15:09:43.273Z
8494936 8494936 20251117032027_OD2V2 UK008H 2025-11-18T14:25:19.382Z 2025-11-25T15:09:42.476Z
8494157 8494157 20251117023056_OkoXk UK008H 2025-11-18T14:23:39.470Z 2025-11-25T15:09:28.541Z
8494039 8494039 20251117022403_DxRVa UK008H 2025-11-18T14:23:30.031Z 2025-11-25T15:09:27.967Z
8493487 8493487 20251117014555_96Lm8 UK008H 2025-11-18T14:22:21.550Z 2025-11-25T15:09:18.166Z
8493368 8493368 20251117013929_yk0Yo UK008H 2025-11-18T14:22:02.394Z 2025-11-25T15:09:09.275Z
8493364 8493364 20251117013920_3Wqz3 UK008H 2025-11-18T14:22:02.245Z 2025-11-25T15:09:09.270Z
8491745 8491745 20251116230646_WdB62 UK008H 2025-11-18T14:18:15.986Z 2025-11-25T15:08:41.779Z
8491354 8491354 20251116222026_qsnye UK008H 2025-11-18T14:17:09.416Z 2025-11-25T15:08:37.039Z
8467131 8467131 20251114194314_y4ujA UK008H 2025-11-16T14:13:54.208Z 2025-11-23T15:17:07.088Z
8440128 8440128 20251112052610_3DXVv UK008H 2025-11-13T14:28:10.330Z 2025-11-13T14:28:10.330Z
8439959 8439959 20251112050024_TAGM7 UK008H 2025-11-13T14:27:42.300Z 2025-11-20T15:25:39.247Z
8438620 8438620 20251112021911_28NEQ UK008H 2025-11-13T14:24:21.635Z 2025-11-20T15:24:43.135Z
8438475 8438475 20251112020328_4wexE UK008H 2025-11-13T14:23:51.642Z 2025-11-20T15:24:36.727Z
8438098 8438098 20251112012221_74xSh UK008H 2025-11-13T14:22:52.584Z 2025-11-20T15:24:13.652Z
8437889 8437889 20251112005446_Rn3Zx UK008H 2025-11-13T14:22:15.291Z 2025-11-20T15:23:56.566Z
8427772 8427772 20251111050959_GFXTy UK008H 2025-11-12T14:29:05.276Z 2025-11-19T15:18:04.857Z
8427726 8427726 20251111050500_L4rUK UK008H 2025-11-12T14:29:00.666Z 2025-11-19T15:17:59.657Z
8427695 8427695 20251111050202_BJhyY UK008H 2025-11-12T14:28:57.065Z 2025-11-19T15:17:59.440Z
8427479 8427479 20251111044503_FXjud UK008H 2025-11-12T14:28:12.316Z 2025-11-19T15:17:54.217Z
8403084 8403084 20251108222242_oAC3U UK008H 2025-11-10T14:08:17.283Z 2025-11-17T14:58:31.592Z
8402607 8402607 20251108203553_sFFUi UK008H 2025-11-10T14:07:23.508Z 2025-11-17T14:58:26.480Z
8402479 8402479 20251108200705_GN2kn UK008H 2025-11-10T14:06:59.759Z 2025-11-17T14:58:19.086Z
8402278 8402278 20251108191213_u4jxa UK008H 2025-11-10T14:06:10.564Z 2025-11-17T14:58:13.688Z
8401929 8401929 20251108175330_Eeun5 UK008H 2025-11-10T14:04:58.810Z 2025-11-17T14:58:06.169Z
8371526 8371526 20251104043155_cxNKq UK008H 2025-11-05T14:15:17.188Z 2025-11-12T15:11:02.744Z
8353917 8353917 20251102043916_5arxx UK008H 2025-11-03T14:20:09.738Z 2025-11-10T15:09:08.216Z
8353451 8353451 20251102024402_fU4iz UK008H 2025-11-03T14:18:34.100Z 2025-11-10T15:08:02.619Z
8351777 8351777 20251101234344_dSWFO UK008H 2025-11-03T14:14:42.541Z 2025-11-10T15:05:55.334Z
8351221 8351221 20251101223616_6loV3 UK008H 2025-11-03T14:13:00.847Z 2025-11-10T15:05:48.096Z
8337076 8337076 20251031055353_dPrRd UK008H 2025-11-02T14:30:41.456Z 2025-11-08T15:16:18.721Z
8336929 8336929 20251031053127_IqnNh UK008H 2025-11-02T14:30:18.674Z 2025-11-08T15:16:16.875Z
8336886 8336886 20251031052701_lq7Rh UK008H 2025-11-02T14:30:16.855Z 2025-11-08T15:16:16.514Z
8336321 8336321 20251031043313_0LEuf UK008H 2025-11-02T14:29:14.026Z 2025-11-08T15:15:46.425Z
8336238 8336238 20251031042647_3GAzv UK008H 2025-11-02T14:29:09.617Z 2025-11-08T15:15:42.822Z
8335926 8335926 20251031035956_sRk3D UK008H 2025-11-02T14:28:17.995Z 2025-11-08T15:15:16.195Z
8335878 8335878 20251031035515_w8TS9 UK008H 2025-11-02T14:28:13.647Z 2025-11-08T15:15:14.105Z
8335800 8335800 20251031035010_M0840 UK008H 2025-11-02T14:28:08.716Z 2025-11-08T15:15:08.929Z
8335552 8335552 20251031033044_HpMor UK008H 2025-11-02T14:27:38.040Z 2025-11-08T15:14:53.960Z
8335395 8335395 20251031031512_aIcrA UK008H 2025-11-02T14:27:18.166Z 2025-11-08T15:14:49.338Z
8323964 8323964 20251030051658_SR9WP UK008H 2025-11-01T12:31:34.636Z 2025-11-07T15:16:49.501Z
8323931 8323931 20251030051554_cOZtO UK008H 2025-11-01T12:31:32.485Z 2025-11-07T15:16:45.123Z
8322458 8322458 20251030041304_2YSTG UK008H 2025-11-01T12:29:25.846Z 2025-11-07T15:15:40.532Z
8318532 8318532 20251030012751_Iu632 UK008H 2025-11-01T12:22:47.769Z 2025-11-07T15:13:29.229Z
8314423 8314423 20251030005327_yhw2T UK008H 2025-10-31T12:39:05.331Z 2025-11-07T15:13:21.200Z
8313979 8313979 20251030003150_imdaT UK008H 2025-10-31T12:38:15.098Z 2025-11-07T15:13:15.465Z
8313687 8313687 20251030001943_sKqUM UK008H 2025-10-31T12:38:07.648Z 2025-11-07T15:12:57.997Z
8313495 8313495 20251030000944_Nbnfr UK008H 2025-10-31T12:38:01.994Z 2025-11-07T15:12:39.182Z
8313338 8313338 20251030000119_t2YSs UK008H 2025-10-31T12:37:57.340Z 2025-11-07T15:12:34.173Z
8312300 8312300 20251029230057_X22SZ UK008H 2025-10-31T12:36:43.319Z 2025-11-07T15:11:41.860Z
8310185 8310185 20251029185711_UbLKf UK008H 2025-10-31T12:34:00.745Z 2025-11-07T15:10:30.541Z
8300351 8300351 20251029055832_AoVhx UK008H 2025-10-30T12:53:32.606Z 2025-11-06T15:14:43.816Z
8300183 8300183 20251029045640_yVk6G UK008H 2025-10-30T12:53:10.748Z 2025-11-06T15:14:25.422Z
8299997 8299997 20251029041923_9gxpT UK008H 2025-10-30T12:52:48.574Z 2025-11-06T15:14:13.242Z

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