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

5,863 rows where station_code = "HU000B" 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
8656613 8656613 20251130050138_L6QYH HU000B 2025-12-01T14:28:48.073Z 2025-12-01T14:28:48.073Z
8656527 8656527 20251130045743_6c7ox HU000B 2025-12-01T14:28:43.130Z 2025-12-05T14:45:17.204Z
8656523 8656523 20251130045743_NaDgw HU000B 2025-12-01T14:28:42.852Z 2025-12-05T14:45:17.167Z
8656118 8656118 20251130043815_uNLDQ HU000B 2025-12-01T14:28:04.737Z 2025-12-05T14:44:46.207Z
8655921 8655921 20251130042511_nTfMM HU000B 2025-12-01T14:27:40.830Z 2025-12-05T14:44:41.178Z
8655861 8655861 20251130042059_vllbI HU000B 2025-12-01T14:27:33.202Z 2025-12-05T14:44:40.105Z
8655837 8655837 20251130042038_9khIw HU000B 2025-12-01T14:27:32.283Z 2025-12-05T14:44:39.875Z
8655797 8655797 20251130041927_mly3M HU000B 2025-12-01T14:27:30.281Z 2025-12-05T14:44:39.232Z
8655777 8655777 20251130041731_NEPEd HU000B 2025-12-01T14:27:27.879Z 2025-12-05T14:44:38.848Z
8654635 8654635 20251130032402_3WXfF HU000B 2025-12-01T14:25:39.312Z 2025-12-05T14:44:18.983Z
8654289 8654289 20251130030730_7HtKI HU000B 2025-12-01T14:25:04.310Z 2025-12-05T14:43:52.567Z
8654075 8654075 20251130025554_PSSUN HU000B 2025-12-01T14:24:48.655Z 2025-12-05T14:43:46.097Z
8645875 8645875 20251129000813_HFnHj HU000B 2025-11-30T14:24:38.730Z 2025-12-05T14:51:27.206Z
8637159 8637159 20251128051030_pkbHl HU000B 2025-11-29T14:26:55.122Z 2025-12-05T14:59:38.073Z
8637048 8637048 20251128045440_ULkvR HU000B 2025-11-29T14:26:47.690Z 2025-12-05T14:59:36.518Z
8637046 8637046 20251128045402_TssTX HU000B 2025-11-29T14:26:47.415Z 2025-12-05T14:59:36.488Z
8637021 8637021 20251128045148_u4O2B HU000B 2025-11-29T14:26:33.684Z 2025-12-05T14:59:36.152Z
8636975 8636975 20251128044454_SFWPu HU000B 2025-11-29T14:26:28.891Z 2025-12-05T14:59:34.054Z
8636963 8636963 20251128044144_rzj1S HU000B 2025-11-29T14:26:23.907Z 2025-12-05T14:59:33.411Z
8636869 8636869 20251128043128_mLr03 HU000B 2025-11-29T14:26:16.678Z 2025-12-05T14:59:30.988Z
8636770 8636770 20251128042545_vNoLb HU000B 2025-11-29T14:26:11.007Z 2025-12-05T14:59:29.566Z
8636768 8636768 20251128042503_EYssv HU000B 2025-11-29T14:26:10.508Z 2025-12-05T14:59:29.451Z
8636760 8636760 20251128042334_IGDU6 HU000B 2025-11-29T14:26:09.737Z 2025-12-05T14:59:29.225Z
8636753 8636753 20251128042245_Xp6nT HU000B 2025-11-29T14:26:09.170Z 2025-12-05T14:59:29.070Z
8636723 8636723 20251128042003_svlDx HU000B 2025-11-29T14:26:07.704Z 2025-12-05T14:59:28.692Z
8636656 8636656 20251128041534_OXOYo HU000B 2025-11-29T14:25:57.799Z 2025-12-05T14:59:27.780Z
8636507 8636507 20251128035400_74cKx HU000B 2025-11-29T14:25:35.642Z 2025-12-05T14:59:25.218Z
8636471 8636471 20251128034829_52OVo HU000B 2025-11-29T14:25:32.542Z 2025-12-05T14:59:24.465Z
8636463 8636463 20251128034745_l3Hv3 HU000B 2025-11-29T14:25:32.243Z 2025-12-05T14:59:24.402Z
8636286 8636286 20251128033207_B0xEw HU000B 2025-11-29T14:25:20.545Z 2025-12-05T14:59:22.178Z
8636284 8636284 20251128033125_kZkVa HU000B 2025-11-29T14:25:20.310Z 2025-12-05T14:59:22.139Z
8636280 8636280 20251128033057_zqrkb HU000B 2025-11-29T14:25:20.155Z 2025-12-05T14:59:22.111Z
8636191 8636191 20251128032728_03ihZ HU000B 2025-11-29T14:25:03.561Z 2025-12-05T14:59:21.094Z
8636039 8636039 20251128030912_1nQaz HU000B 2025-11-29T14:24:49.475Z 2025-12-05T14:59:18.477Z
8635953 8635953 20251128030211_DYm2e HU000B 2025-11-29T14:24:41.850Z 2025-12-05T14:59:17.305Z
8635951 8635951 20251128030155_Coee0 HU000B 2025-11-29T14:24:41.571Z 2025-12-05T14:59:17.259Z
8635928 8635928 20251128025913_ufOlZ HU000B 2025-11-29T14:24:28.588Z 2025-12-05T14:59:16.708Z
8635904 8635904 20251128025758_TZ1uN HU000B 2025-11-29T14:24:22.077Z 2025-12-05T14:59:16.289Z
8635867 8635867 20251128025458_bpqn7 HU000B 2025-11-29T14:24:16.951Z 2025-12-05T14:59:15.752Z
8635797 8635797 20251128024805_4Kw2I HU000B 2025-11-29T14:24:09.824Z 2025-12-05T14:59:14.704Z
8635775 8635775 20251128024645_l0nJk HU000B 2025-11-29T14:24:08.889Z 2025-12-05T14:59:14.556Z
8635673 8635673 20251128023645_ewz38 HU000B 2025-11-29T14:24:00.110Z 2025-12-05T14:59:12.992Z
8635581 8635581 20251128022806_zK31A HU000B 2025-11-29T14:23:46.508Z 2025-12-05T14:59:07.754Z
8635578 8635578 20251128022751_eF7oh HU000B 2025-11-29T14:23:45.325Z 2025-12-05T14:59:07.542Z
8635539 8635539 20251128022343_H3E92 HU000B 2025-11-29T14:23:38.640Z 2025-12-05T14:58:58.690Z
8635497 8635497 20251128021911_DXvjg HU000B 2025-11-29T14:23:29.822Z 2025-12-05T14:58:48.039Z
8635447 8635447 20251128021330_25Bcn HU000B 2025-11-29T14:23:24.874Z 2025-12-05T14:58:40.391Z
8635399 8635399 20251128020933_AD6Ig HU000B 2025-11-29T14:23:20.694Z 2025-12-05T14:58:34.848Z
8635382 8635382 20251128020831_c85Fc HU000B 2025-11-29T14:23:18.864Z 2025-12-05T14:58:34.617Z
8635300 8635300 20251128020204_V6ZNm HU000B 2025-11-29T14:23:02.242Z 2025-12-05T14:58:33.841Z
8635212 8635212 20251128015309_J3ILW HU000B 2025-11-29T14:22:50.301Z 2025-12-05T14:58:32.161Z
8635203 8635203 20251128015251_BsLsc HU000B 2025-11-29T14:22:49.450Z 2025-12-05T14:58:31.961Z
8635198 8635198 20251128015110_EHYw5 HU000B 2025-11-29T14:22:48.615Z 2025-12-05T14:58:31.871Z
8635180 8635180 20251128014835_4Y0qj HU000B 2025-11-29T14:22:46.889Z 2025-12-05T14:58:31.647Z
8635134 8635134 20251128014506_MeLnh HU000B 2025-11-29T14:22:42.831Z 2025-12-05T14:58:30.978Z
8635132 8635132 20251128014452_3F732 HU000B 2025-11-29T14:22:42.710Z 2025-12-05T14:58:30.947Z
8635057 8635057 20251128013752_7h5CR HU000B 2025-11-29T14:22:36.332Z 2025-12-05T14:58:28.480Z
8635036 8635036 20251128013540_yPzxD HU000B 2025-11-29T14:22:27.087Z 2025-12-05T14:58:28.152Z
8634963 8634963 20251128012919_s84Mx HU000B 2025-11-29T14:22:17.826Z 2025-12-05T14:58:26.916Z
8634860 8634860 20251128012407_Fw0Qa HU000B 2025-11-29T14:22:07.912Z 2025-12-05T14:58:25.895Z
8634849 8634849 20251128012300_EGJFZ HU000B 2025-11-29T14:22:06.496Z 2025-12-05T14:58:25.670Z
8634837 8634837 20251128012130_d9EHB HU000B 2025-11-29T14:22:06.051Z 2025-12-05T14:58:25.573Z
8634831 8634831 20251128012058_rf9Ld HU000B 2025-11-29T14:22:05.939Z 2025-12-05T14:58:25.524Z
8634749 8634749 20251128011627_2Ig7u HU000B 2025-11-29T14:22:00.795Z 2025-12-05T14:58:24.414Z
8634700 8634700 20251128011048_RHzC3 HU000B 2025-11-29T14:21:57.151Z 2025-12-05T14:58:23.806Z
8634653 8634653 20251128010732_Y3naq HU000B 2025-11-29T14:21:48.179Z 2025-12-05T14:58:23.144Z
8634617 8634617 20251128010502_a0USZ HU000B 2025-11-29T14:21:40.401Z 2025-12-05T14:58:22.861Z
8634390 8634390 20251128004614_Ozd2r HU000B 2025-11-29T14:21:17.949Z 2025-12-05T14:58:20.196Z
8634386 8634386 20251128004542_XUTu4 HU000B 2025-11-29T14:21:17.421Z 2025-12-05T14:58:20.068Z
8634378 8634378 20251128004403_ydmdY HU000B 2025-11-29T14:21:16.075Z 2025-12-05T14:58:19.911Z
8634317 8634317 20251128003645_dB3N2 HU000B 2025-11-29T14:21:12.038Z 2025-12-05T14:58:19.037Z
8633343 8633343 20251127230556_0agu0 HU000B 2025-11-29T14:19:27.808Z 2025-12-05T14:57:32.310Z
8633240 8633240 20251127225630_aKccC HU000B 2025-11-29T14:19:17.997Z 2025-12-05T14:57:23.472Z
8633186 8633186 20251127224940_GOdkh HU000B 2025-11-29T14:19:12.688Z 2025-12-05T14:57:17.961Z
8633024 8633024 20251127223101_agZvL HU000B 2025-11-29T14:18:52.324Z 2025-12-05T14:56:57.507Z
8632999 8632999 20251127222837_hHpkm HU000B 2025-11-29T14:18:48.325Z 2025-12-05T14:56:55.411Z
8632980 8632980 20251127222516_CpIrA HU000B 2025-11-29T14:18:39.793Z 2025-12-05T14:56:54.414Z
8632740 8632740 20251127214626_78gDU HU000B 2025-11-29T14:18:09.879Z 2025-12-05T14:56:34.974Z
8632728 8632728 20251127214439_ZBQ4s HU000B 2025-11-29T14:18:08.339Z 2025-12-05T14:56:34.581Z
8632485 8632485 20251127211303_2MX98 HU000B 2025-11-29T14:17:43.462Z 2025-12-05T14:56:21.979Z
8632390 8632390 20251127210110_bOKpD HU000B 2025-11-29T14:17:25.285Z 2025-12-05T14:56:20.525Z
8632280 8632280 20251127204518_WbT8l HU000B 2025-11-29T14:17:12.329Z 2025-12-05T14:56:19.225Z
8632231 8632231 20251127204336_w0BJn HU000B 2025-11-29T14:17:10.306Z 2025-12-05T14:56:18.801Z
8632161 8632161 20251127203702_ZzSQm HU000B 2025-11-29T14:17:04.442Z 2025-12-05T14:56:16.504Z
8631720 8631720 20251127195354_pGzy7 HU000B 2025-11-29T14:16:10.728Z 2025-12-05T14:56:11.130Z
8631713 8631713 20251127195312_GJK39 HU000B 2025-11-29T14:16:07.596Z 2025-12-05T14:56:11.090Z
8631707 8631707 20251127194921_UEdbV HU000B 2025-11-29T14:16:05.065Z 2025-12-05T14:56:10.918Z
8631685 8631685 20251127194429_YkBlw HU000B 2025-11-29T14:16:02.047Z 2025-12-05T14:56:10.454Z
8631673 8631673 20251127194302_hbAUp HU000B 2025-11-29T14:16:00.411Z 2025-12-05T14:56:10.307Z
8631548 8631548 20251127192311_rPYHm HU000B 2025-11-29T14:15:44.356Z 2025-12-05T14:56:08.452Z
8631530 8631530 20251127192216_RNtiz HU000B 2025-11-29T14:15:41.540Z 2025-12-05T14:56:07.958Z
8631506 8631506 20251127191855_6M2OQ HU000B 2025-11-29T14:15:38.560Z 2025-12-05T14:56:07.590Z
8631413 8631413 20251127190352_uQrkx HU000B 2025-11-29T14:15:18.254Z 2025-12-05T14:56:06.223Z
8631324 8631324 20251127184919_J2Krs HU000B 2025-11-29T14:15:06.795Z 2025-12-05T14:56:05.169Z
8631304 8631304 20251127184622_dfyg7 HU000B 2025-11-29T14:15:05.257Z 2025-12-05T14:56:04.966Z
8631263 8631263 20251127184208_7RIpj HU000B 2025-11-29T14:15:01.624Z 2025-12-05T14:56:04.570Z
8630828 8630828 20251127173307_vRC36 HU000B 2025-11-29T14:13:50.413Z 2025-12-05T14:55:57.682Z
8630812 8630812 20251127173031_S2whd HU000B 2025-11-29T14:13:48.618Z 2025-12-05T14:55:57.437Z
8630747 8630747 20251127171238_3Okq8 HU000B 2025-11-29T14:13:39.222Z 2025-12-05T14:55:52.155Z
8630709 8630709 20251127170847_GFM5f HU000B 2025-11-29T14:13:30.694Z 2025-12-05T14:55:50.435Z

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