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

746 rows where station_code = "HU0008" 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
8656822 8656822 20251130051057_o5ZGM HU0008 2025-12-01T14:29:03.143Z 2025-12-05T14:45:21.777Z
8656233 8656233 20251130044511_I8yU2 HU0008 2025-12-01T14:28:12.759Z 2025-12-05T14:44:48.331Z
8656221 8656221 20251130044359_BBO42 HU0008 2025-12-01T14:28:11.183Z 2025-12-05T14:44:48.037Z
8654926 8654926 20251130033838_LEoOj HU0008 2025-12-01T14:26:10.879Z 2025-12-05T14:44:25.963Z
8654321 8654321 20251130031045_T7lN5 HU0008 2025-12-01T14:25:09.041Z 2025-12-05T14:43:53.735Z
8647632 8647632 20251129045924_ozQrc HU0008 2025-11-30T14:28:40.434Z 2025-12-05T14:52:44.417Z
8647546 8647546 20251129044927_4hoBX HU0008 2025-11-30T14:28:34.893Z 2025-12-05T14:52:42.514Z
8647472 8647472 20251129044014_PSHwZ HU0008 2025-11-30T14:28:28.438Z 2025-12-05T14:52:40.916Z
8647043 8647043 20251129033223_TEdlR HU0008 2025-11-30T14:27:22.209Z 2025-12-05T14:52:26.433Z
8647035 8647035 20251129033029_fj7kX HU0008 2025-11-30T14:27:21.461Z 2025-12-05T14:52:25.951Z
8647008 8647008 20251129032547_MgwuA HU0008 2025-11-30T14:27:15.655Z 2025-12-05T14:52:18.885Z
8646846 8646846 20251129030114_jO3sL HU0008 2025-11-30T14:27:01.568Z 2025-12-05T14:51:55.285Z
8646834 8646834 20251129030017_2qa4F HU0008 2025-11-30T14:27:01.006Z 2025-12-05T14:51:55.151Z
8646793 8646793 20251129025532_tSkg3 HU0008 2025-11-30T14:26:58.388Z 2025-12-05T14:51:54.366Z
8646764 8646764 20251129025121_xE3kf HU0008 2025-11-30T14:26:55.899Z 2025-12-05T14:51:53.673Z
8646755 8646755 20251129024901_WOy1a HU0008 2025-11-30T14:26:48.081Z 2025-12-05T14:51:53.341Z
8646586 8646586 20251129022553_HWI33 HU0008 2025-11-30T14:26:13.874Z 2025-12-05T14:51:45.015Z
8646434 8646434 20251129020608_BNxmE HU0008 2025-11-30T14:25:58.935Z 2025-12-05T14:51:41.954Z
8646156 8646156 20251129011545_SyxGU HU0008 2025-11-30T14:25:17.546Z 2025-12-05T14:51:34.399Z
8646134 8646134 20251129011058_o8XV3 HU0008 2025-11-30T14:25:15.301Z 2025-12-05T14:51:33.826Z
8645652 8645652 20251128231722_eKg3n HU0008 2025-11-30T14:24:20.956Z 2025-12-05T14:51:04.338Z
8645634 8645634 20251128231402_c8j2S HU0008 2025-11-30T14:24:19.157Z 2025-12-05T14:50:59.595Z
8645591 8645591 20251128230229_Z2DFZ HU0008 2025-11-30T14:24:14.968Z 2025-12-05T14:50:52.912Z
8644719 8644719 20251128194800_jH8vI HU0008 2025-11-30T14:22:20.605Z 2025-12-05T14:50:26.130Z
8644620 8644620 20251128193737_yaB4h HU0008 2025-11-30T14:22:09.917Z 2025-12-05T14:50:24.698Z
8643075 8643075 20251128171728_T4kWZ HU0008 2025-11-30T14:19:17.623Z 2025-12-05T14:49:09.405Z
8636540 8636540 20251128035558_LgKKJ HU0008 2025-11-29T14:25:38.312Z 2025-12-05T14:59:25.695Z
8636371 8636371 20251128033921_064N1 HU0008 2025-11-29T14:25:25.761Z 2025-12-05T14:59:23.330Z
8635708 8635708 20251128024012_3RSYJ HU0008 2025-11-29T14:24:02.847Z 2025-12-05T14:59:13.422Z
8634481 8634481 20251128005242_TihyH HU0008 2025-11-29T14:21:23.497Z 2025-12-05T14:58:21.117Z
8632319 8632319 20251127205213_BmN63 HU0008 2025-11-29T14:17:15.824Z 2025-12-05T14:56:19.702Z
8631865 8631865 20251127200839_T25A2 HU0008 2025-11-29T14:16:29.502Z 2025-12-05T14:56:12.644Z
8631692 8631692 20251127194524_rBnHV HU0008 2025-11-29T14:16:03.109Z 2025-12-05T14:56:10.595Z
8624465 8624465 20251127045841_z89NO HU0008 2025-11-28T14:24:43.554Z 2025-12-05T15:05:06.152Z
8624440 8624440 20251127045448_fGlWG HU0008 2025-11-28T14:24:42.199Z 2025-12-05T15:05:05.275Z
8624155 8624155 20251127031933_CI2PE HU0008 2025-11-28T14:23:53.078Z 2025-12-05T15:04:48.545Z
8624037 8624037 20251127025447_4K7Ho HU0008 2025-11-28T14:23:39.833Z 2025-12-05T15:04:39.920Z
8624009 8624009 20251127024450_Jgr6R HU0008 2025-11-28T14:23:36.868Z 2025-12-05T15:04:34.045Z
8623624 8623624 20251127012956_BGXZb HU0008 2025-11-28T14:22:17.350Z 2025-12-05T15:04:05.357Z
8623188 8623188 20251126231433_232fs HU0008 2025-11-28T14:21:03.330Z 2025-12-05T15:03:37.775Z
8622579 8622579 20251126200123_JGfHs HU0008 2025-11-28T14:19:25.037Z 2025-12-05T15:03:03.685Z
8588915 8588915 20251124004438_MxUhU HU0008 2025-11-25T14:18:46.568Z 2025-12-02T15:12:01.123Z
8588904 8588904 20251124004236_DceT7 HU0008 2025-11-25T14:18:45.223Z 2025-12-02T15:12:01.045Z
8588492 8588492 20251124000146_ptyKq HU0008 2025-11-25T14:17:38.400Z 2025-12-02T15:11:44.941Z
8587939 8587939 20251123230103_Otv3d HU0008 2025-11-25T14:16:27.882Z 2025-12-02T15:11:22.784Z
8587223 8587223 20251123213714_dOA33 HU0008 2025-11-25T14:14:52.859Z 2025-12-02T15:11:09.587Z
8586522 8586522 20251123195936_2BisL HU0008 2025-11-25T14:13:07.091Z 2025-12-02T15:10:52.135Z
8586057 8586057 20251123183715_WfKZX HU0008 2025-11-25T14:11:43.935Z 2025-12-02T15:10:40.078Z
8585905 8585905 20251123181544_Cn3hp HU0008 2025-11-25T14:11:18.063Z 2025-12-02T15:10:38.012Z
8585514 8585514 20251123164232_XQBjZ HU0008 2025-11-25T14:09:55.877Z 2025-12-02T15:10:01.504Z
8585484 8585484 20251123161838_4N8os HU0008 2025-11-25T14:09:43.107Z 2025-12-02T15:09:58.674Z
8580209 8580209 20251123025452_u3HeB HU0008 2025-11-24T14:16:22.284Z 2025-12-01T15:21:55.097Z
8560548 8560548 20251118220450_QZNE2 HU0008 2025-11-22T14:47:11.434Z 2025-11-27T15:11:43.167Z
8560545 8560545 20251118210258_LaPhK HU0008 2025-11-22T14:47:04.411Z 2025-11-27T15:11:39.118Z
8560544 8560544 20251118175222_ITcn9 HU0008 2025-11-22T14:45:33.652Z 2025-11-27T15:11:28.450Z
8560541 8560541 20251118163837_L17pB HU0008 2025-11-22T14:44:56.626Z 2025-11-27T15:11:25.581Z
8541707 8541707 20251119050308_kopkm HU0008 2025-11-21T14:37:54.414Z 2025-11-27T15:13:12.192Z
8541705 8541705 20251119045014_d82Uq HU0008 2025-11-21T14:37:53.778Z 2025-11-27T15:13:10.610Z
8541703 8541703 20251119035217_SbMky HU0008 2025-11-21T14:37:52.771Z 2025-11-27T15:12:56.406Z
8541701 8541701 20251119032626_e27mG HU0008 2025-11-21T14:37:51.859Z 2025-11-27T15:12:47.987Z
8541700 8541700 20251119031543_eqioG HU0008 2025-11-21T14:37:51.388Z 2025-11-27T15:12:45.826Z
8541698 8541698 20251119031345_GU7s8 HU0008 2025-11-21T14:37:51.021Z 2025-11-27T15:12:45.353Z
8541696 8541696 20251119030607_1El89 HU0008 2025-11-21T14:37:48.342Z 2025-11-27T15:12:38.132Z
8541694 8541694 20251119011653_Irqtm HU0008 2025-11-21T14:37:46.967Z 2025-11-27T15:12:08.383Z
8541692 8541692 20251119010309_63soU HU0008 2025-11-21T14:37:46.656Z 2025-11-27T15:12:07.374Z
8438088 8438088 20251112012144_ycJZb HU0008 2025-11-13T14:22:52.277Z 2025-11-20T15:24:13.633Z
8435730 8435730 20251111200537_yHEs1 HU0008 2025-11-13T14:16:16.230Z 2025-11-20T15:22:30.086Z
8435202 8435202 20251111191829_x9t31 HU0008 2025-11-13T14:14:54.882Z 2025-11-20T15:22:06.343Z
8424735 8424735 20251111004401_2UCKq HU0008 2025-11-12T14:21:01.950Z 2025-11-19T15:16:23.417Z
8424671 8424671 20251111004103_2MWtU HU0008 2025-11-12T14:20:47.920Z 2025-11-19T15:16:21.224Z
8424484 8424484 20251111002217_ID2tH HU0008 2025-11-12T14:20:25.598Z 2025-11-19T15:16:17.730Z
8423869 8423869 20251110233631_TvmPI HU0008 2025-11-12T14:19:07.359Z 2025-11-19T15:16:04.072Z
8421864 8421864 20251110211534_HJ2iz HU0008 2025-11-12T14:14:55.370Z 2025-11-19T15:14:50.830Z
8421461 8421461 20251110204307_7YTyl HU0008 2025-11-12T14:14:06.643Z 2025-11-19T15:14:34.769Z
8420947 8420947 20251110195105_bj3Gl HU0008 2025-11-12T14:12:30.779Z 2025-11-19T15:14:17.972Z
8420675 8420675 20251110192644_kohNM HU0008 2025-11-12T14:11:37.539Z 2025-11-19T15:14:13.054Z
8420593 8420593 20251110192257_y39Ti HU0008 2025-11-12T14:11:25.887Z 2025-11-19T15:14:11.764Z
8420542 8420542 20251110191635_uyXXz HU0008 2025-11-12T14:11:10.915Z 2025-11-19T15:14:10.924Z
8420133 8420133 20251110181839_fgiuc HU0008 2025-11-12T14:09:39.186Z 2025-11-19T15:13:36.877Z
8396331 8396331 20251107202617_YarIw HU0008 2025-11-09T14:08:11.346Z 2025-11-16T15:03:26.936Z
8389972 8389972 20251106230939_MJrvm HU0008 2025-11-08T14:09:06.925Z 2025-11-15T14:59:50.413Z
8389732 8389732 20251106221302_THQKz HU0008 2025-11-08T14:08:12.504Z 2025-11-15T14:59:47.120Z
8389534 8389534 20251106211945_o6A7R HU0008 2025-11-08T14:07:24.548Z 2025-11-15T14:59:41.020Z
8389361 8389361 20251106203506_SVk8z HU0008 2025-11-08T14:06:34.114Z 2025-11-15T14:59:36.604Z
8385232 8385232 20251105223242_3Cg3B HU0008 2025-11-07T14:05:55.369Z 2025-11-14T15:08:05.251Z
8385210 8385210 20251105222713_lVi0x HU0008 2025-11-07T14:05:52.151Z 2025-11-14T15:08:05.078Z
8385116 8385116 20251105214408_YMHWD HU0008 2025-11-07T14:05:25.565Z 2025-11-14T15:08:01.429Z
8385021 8385021 20251105204645_7AB89 HU0008 2025-11-07T14:04:52.670Z 2025-11-14T15:07:51.173Z
8384925 8384925 20251105193935_ICGoj HU0008 2025-11-07T14:04:35.470Z 2025-11-14T15:07:49.626Z
8384883 8384883 20251105190818_j3b13 HU0008 2025-11-07T14:04:14.824Z 2025-11-14T15:07:46.587Z
8384881 8384881 20251105190241_26DxY HU0008 2025-11-07T14:04:14.274Z 2025-11-14T15:07:46.551Z
8383084 8383084 20251103212040_VRwx8 HU0008 2025-11-06T14:23:22.491Z 2025-11-12T15:09:23.996Z
8383080 8383080 20251103212039_HBxsj HU0008 2025-11-06T14:23:22.419Z 2025-11-12T15:09:23.986Z
8383075 8383075 20251103211408_L2mNg HU0008 2025-11-06T14:23:21.585Z 2025-11-12T15:09:23.202Z
8383024 8383024 20251103183624_v3QlJ HU0008 2025-11-06T14:22:25.554Z 2025-11-12T15:08:49.763Z
8381197 8381197 20251105042013_nbIz1 HU0008 2025-11-06T14:14:12.198Z 2025-11-13T15:15:20.797Z
8381180 8381180 20251105041349_rTGGJ HU0008 2025-11-06T14:14:09.817Z 2025-11-13T15:15:20.049Z
8381139 8381139 20251105040630_UePyy HU0008 2025-11-06T14:14:03.854Z 2025-11-13T15:15:18.664Z
8381117 8381117 20251105040244_w4g40 HU0008 2025-11-06T14:14:01.328Z 2025-11-13T15:15:18.192Z
8381106 8381106 20251105040137_CZo9I HU0008 2025-11-06T14:14:00.137Z 2025-11-13T15:15:17.102Z

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