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,542 rows where station_code = "HU0006" 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
9232058 9232058 20260117212509_QjQXO HU0006 2026-01-20T14:40:22.676Z 2026-01-26T15:01:26.110Z
9189232 9189232 20260112033751_5AZ83 HU0006 2026-01-13T14:16:31.563Z 2026-01-20T15:22:58.481Z
9189136 9189136 20260112030831_pK3Wz HU0006 2026-01-13T14:15:59.114Z 2026-01-20T15:22:43.639Z
9189092 9189092 20260112030152_L5CMy HU0006 2026-01-13T14:15:44.319Z 2026-01-20T15:22:38.903Z
9188985 9188985 20260112023215_OFqBR HU0006 2026-01-13T14:15:12.718Z 2026-01-20T15:22:32.776Z
9188947 9188947 20260112022637_EnQbz HU0006 2026-01-13T14:15:00.949Z 2026-01-20T15:22:31.075Z
9188932 9188932 20260112022442_sZcZQ HU0006 2026-01-13T14:14:57.345Z 2026-01-20T15:22:30.485Z
9188821 9188821 20260112015427_UFbsU HU0006 2026-01-13T14:14:23.758Z 2026-01-20T15:22:19.013Z
9188360 9188360 20260111225825_RVDM7 HU0006 2026-01-13T14:11:53.904Z 2026-01-20T15:21:36.377Z
9182005 9182005 20260111040010_BJ6bv HU0006 2026-01-12T14:12:54.978Z 2026-01-19T15:17:59.739Z
9181875 9181875 20260111033450_ZxHgS HU0006 2026-01-12T14:12:26.630Z 2026-01-19T15:17:51.916Z
9181616 9181616 20260111022713_2oIjU HU0006 2026-01-12T14:11:29.080Z 2026-01-19T15:17:40.384Z
9181293 9181293 20260111011400_QXIEU HU0006 2026-01-12T14:10:17.026Z 2026-01-19T15:17:11.586Z
9181213 9181213 20260111005615_Bz29P HU0006 2026-01-12T14:09:58.987Z 2026-01-19T15:17:08.256Z
9180816 9180816 20260110224446_grAj2 HU0006 2026-01-12T14:08:28.528Z 2026-01-19T15:16:33.884Z
9171529 9171529 20260108223905_f110q HU0006 2026-01-10T14:07:55.671Z 2026-01-17T15:24:05.482Z
9171497 9171497 20260108222222_P3kjf HU0006 2026-01-10T14:07:44.066Z 2026-01-17T15:24:03.347Z
9171408 9171408 20260108213454_xXiIW HU0006 2026-01-10T14:07:16.038Z 2026-01-17T15:23:48.041Z
9171225 9171225 20260108201231_1q2FK HU0006 2026-01-10T14:06:05.210Z 2026-01-17T15:23:37.656Z
9167818 9167818 20260108052351_MUVao HU0006 2026-01-09T14:09:22.346Z 2026-01-16T15:11:53.247Z
9167630 9167630 20260108034033_f8wZN HU0006 2026-01-09T14:08:33.490Z 2026-01-16T15:11:32.817Z
9167472 9167472 20260108020232_m7Pgs HU0006 2026-01-09T14:07:53.008Z 2026-01-16T15:11:21.522Z
9167283 9167283 20260108000553_i2gT2 HU0006 2026-01-09T14:07:00.605Z 2026-01-16T15:11:00.241Z
9167025 9167025 20260107214415_2taie HU0006 2026-01-09T14:05:54.175Z 2026-01-16T15:10:36.489Z
9150983 9150983 20260105041152_5xTr2 HU0006 2026-01-06T14:12:14.606Z 2026-01-13T15:14:12.448Z
9150442 9150442 20260105021320_810eO HU0006 2026-01-06T14:10:03.565Z 2026-01-13T15:13:33.225Z
9150288 9150288 20260105014657_iF3L3 HU0006 2026-01-06T14:09:26.810Z 2026-01-13T15:13:15.097Z
9150235 9150235 20260105013841_2eg3F HU0006 2026-01-06T14:09:12.672Z 2026-01-13T15:13:12.603Z
9150218 9150218 20260105013230_r7DNT HU0006 2026-01-06T14:09:05.739Z 2026-01-13T15:13:11.466Z
9149992 9149992 20260105002412_nPLIP HU0006 2026-01-06T14:08:04.271Z 2026-01-13T15:12:50.255Z
9149891 9149891 20260105000420_0ka6l HU0006 2026-01-06T14:07:41.146Z 2026-01-13T15:12:44.553Z
9149262 9149262 20260104194642_OWDUi HU0006 2026-01-06T14:04:41.731Z 2026-01-13T15:11:53.864Z
9149177 9149177 20260104191014_rKgVr HU0006 2026-01-06T14:04:11.228Z 2026-01-13T15:11:46.946Z
9147821 9147821 20260103162932_1BIDz HU0006 2026-01-05T14:29:46.236Z 2026-01-10T15:03:49.826Z
9147811 9147811 20260103162026_qDYK2 HU0006 2026-01-05T14:29:45.675Z 2026-01-10T15:03:49.038Z
9131489 9131489 20260103052814_gIV04 HU0006 2026-01-04T14:14:09.552Z 2026-01-10T15:00:31.005Z
9131141 9131141 20260103045259_5BJ0K HU0006 2026-01-04T14:12:47.141Z 2026-01-10T15:00:03.387Z
9119982 9119982 20251229173608_3kkwL HU0006 2026-01-01T15:17:57.222Z 2026-01-06T15:21:06.537Z
9119328 9119328 20251230173636_3YG6k HU0006 2026-01-01T14:55:43.922Z 2026-01-07T15:12:26.946Z
9114628 9114628 20251231042233_r6A44 HU0006 2026-01-01T14:23:01.799Z 2026-01-08T15:09:57.839Z
9114411 9114411 20251231041517_YbLdA HU0006 2026-01-01T14:22:23.962Z 2026-01-08T15:09:45.555Z
9114027 9114027 20251231040052_03v9m HU0006 2026-01-01T14:21:17.269Z 2026-01-08T15:09:21.698Z
9113866 9113866 20251231035213_rzg3p HU0006 2026-01-01T14:20:36.855Z 2026-01-08T15:09:13.098Z
9113488 9113488 20251231033209_b13Aj HU0006 2026-01-01T14:19:07.524Z 2026-01-08T15:08:46.650Z
9113065 9113065 20251231030913_ySOrv HU0006 2026-01-01T14:17:24.589Z 2026-01-08T15:08:21.957Z
9112977 9112977 20251231030411_sgN1Q HU0006 2026-01-01T14:17:00.076Z 2026-01-08T15:08:16.260Z
9112013 9112013 20251231015611_81Bl7 HU0006 2026-01-01T14:13:32.697Z 2026-01-08T15:07:12.958Z
9111803 9111803 20251231014507_knQut HU0006 2026-01-01T14:12:53.178Z 2026-01-08T15:07:04.441Z
9111515 9111515 20251231011558_KCD9r HU0006 2026-01-01T14:11:47.934Z 2026-01-08T15:06:43.392Z
9111257 9111257 20251231005615_7udUV HU0006 2026-01-01T14:10:45.961Z 2026-01-08T15:06:25.580Z
9111051 9111051 20251231003242_eaUbB HU0006 2026-01-01T14:09:55.107Z 2026-01-08T15:06:13.186Z
9110717 9110717 20251230235235_OFk8j HU0006 2026-01-01T14:08:32.258Z 2026-01-08T15:05:46.819Z
9110613 9110613 20251230234103_2WDWS HU0006 2026-01-01T14:08:03.381Z 2026-01-08T15:05:41.874Z
9110188 9110188 20251230222931_BDgdd HU0006 2026-01-01T14:06:15.108Z 2026-01-08T15:05:11.475Z
9109737 9109737 20251230203735_u3F2t HU0006 2026-01-01T14:03:19.790Z 2026-01-08T15:04:25.474Z
9108343 9108343 20251229183518_DfMV4 HU0006 2025-12-31T14:43:23.509Z 2026-01-06T15:21:32.054Z
9108213 9108213 20251229181512_WhzKg HU0006 2025-12-31T14:43:04.378Z 2026-01-06T15:21:27.391Z
9107947 9107947 20251229173609_o0PJr HU0006 2025-12-31T14:42:22.757Z 2026-01-06T15:21:06.714Z
9106937 9106937 20251229040705_Yl6x1 HU0006 2025-12-31T14:36:06.364Z 2026-01-06T15:17:48.360Z
9101176 9101176 20251229231020_cj1Uk HU0006 2025-12-31T14:06:59.960Z 2026-01-07T15:06:05.188Z
9101020 9101020 20251229220854_EABDC HU0006 2025-12-31T14:06:05.583Z 2026-01-07T15:05:47.896Z
9100876 9100876 20251229213152_yZaLk HU0006 2025-12-31T14:05:13.517Z 2026-01-07T15:05:42.547Z
9100531 9100531 20251229202113_Wbq3O HU0006 2025-12-31T14:03:23.545Z 2026-01-07T15:05:20.693Z
9098470 9098470 20251227190926_pVMSV HU0006 2025-12-30T15:10:31.383Z 2026-01-04T15:35:04.531Z
9098397 9098397 20251227185955_1w2Va HU0006 2025-12-30T15:10:27.563Z 2026-01-04T15:34:59.690Z
9098100 9098100 20251227181127_VSi6r HU0006 2025-12-30T15:09:51.983Z 2026-01-04T15:34:33.426Z
9097794 9097794 20251227173424_MsbC3 HU0006 2025-12-30T15:09:18.578Z 2026-01-04T15:34:21.613Z
9097591 9097591 20251227170118_KSYax HU0006 2025-12-30T15:09:05.586Z 2026-01-04T15:34:13.954Z
9097412 9097412 20251227162103_jsNES HU0006 2025-12-30T15:08:39.376Z 2026-01-04T15:33:53.505Z
9092773 9092773 20251227024818_CKYXG HU0006 2025-12-30T15:00:27.693Z 2026-01-04T15:27:30.700Z
9092486 9092486 20251227012807_scVK8 HU0006 2025-12-30T14:59:01.659Z 2026-01-04T15:25:56.849Z
9092273 9092273 20251227000037_6wdu7 HU0006 2025-12-30T14:57:51.825Z 2026-01-04T15:24:46.117Z
9092241 9092241 20251226234851_oVpqi HU0006 2025-12-30T14:57:36.364Z 2026-01-04T15:24:39.359Z
9092156 9092156 20251226230349_gheKl HU0006 2025-12-30T14:56:56.658Z 2026-01-04T15:24:08.802Z
9092001 9092001 20251226215128_VK14q HU0006 2025-12-30T14:55:14.304Z 2026-01-04T15:23:28.359Z
9091990 9091990 20251226214126_VndWY HU0006 2025-12-30T14:54:56.656Z 2026-01-04T15:23:18.544Z
9091979 9091979 20251226213230_G53Y2 HU0006 2025-12-30T14:54:39.374Z 2026-01-04T15:23:12.920Z
9085774 9085774 20251228040056_Sfjao HU0006 2025-12-30T14:39:21.426Z 2026-01-05T15:09:44.827Z
9084731 9084731 20251228021228_V5l2T HU0006 2025-12-30T14:36:39.519Z 2026-01-05T15:08:53.876Z
9084569 9084569 20251228015628_bRAmj HU0006 2025-12-30T14:36:09.758Z 2026-01-05T15:08:47.097Z
9084483 9084483 20251228014817_6Ik0c HU0006 2025-12-30T14:35:48.315Z 2026-01-05T15:08:44.455Z
9084342 9084342 20251228013434_2PG6U HU0006 2025-12-30T14:35:30.211Z 2026-01-05T15:08:39.815Z
9084228 9084228 20251228012220_cAi2i HU0006 2025-12-30T14:35:04.548Z 2026-01-05T15:08:36.093Z
9083140 9083140 20251227230335_OX2ex HU0006 2025-12-30T14:31:45.999Z 2026-01-05T15:07:38.350Z
9082935 9082935 20251227220733_qKxcH HU0006 2025-12-30T14:31:09.782Z 2026-01-05T15:07:31.497Z
9082771 9082771 20251227214131_1sDUV HU0006 2025-12-30T14:30:35.829Z 2026-01-05T15:07:18.201Z
9082688 9082688 20251227212921_U1t32 HU0006 2025-12-30T14:30:16.361Z 2026-01-05T15:07:13.730Z
9080915 9080915 20251229051924_H5E7A HU0006 2025-12-30T14:23:05.048Z 2026-01-06T15:18:44.418Z
9080661 9080661 20251229045841_XVHH7 HU0006 2025-12-30T14:22:07.843Z 2026-01-06T15:18:24.082Z
9080228 9080228 20251229042450_K66Gd HU0006 2025-12-30T14:20:24.118Z 2026-01-06T15:17:57.416Z
9079898 9079898 20251229035512_rxPqm HU0006 2025-12-30T14:18:53.002Z 2026-01-06T15:17:43.503Z
9079726 9079726 20251229033918_RUKtY HU0006 2025-12-30T14:18:11.291Z 2026-01-06T15:17:36.486Z
9079657 9079657 20251229033455_4Rs06 HU0006 2025-12-30T14:17:53.713Z 2026-01-06T15:17:21.328Z
9079510 9079510 20251229032317_8qo6i HU0006 2025-12-30T14:17:23.064Z 2026-01-06T15:17:15.618Z
9079454 9079454 20251229031909_2UbE0 HU0006 2025-12-30T14:17:11.268Z 2026-01-06T15:17:13.835Z
9079418 9079418 20251229031641_ui423 HU0006 2025-12-30T14:17:01.791Z 2026-01-06T15:17:12.629Z
9079360 9079360 20251229031240_5SuZx HU0006 2025-12-30T14:16:48.479Z 2026-01-06T15:17:10.732Z
9079334 9079334 20251229031044_OkGrN HU0006 2025-12-30T14:16:43.078Z 2026-01-06T15:17:09.558Z
9079046 9079046 20251229025130_1TH2o HU0006 2025-12-30T14:15:31.448Z 2026-01-06T15:16:58.894Z
9078819 9078819 20251229023220_LITei HU0006 2025-12-30T14:14:35.520Z 2026-01-06T15:16:42.683Z

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