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

9,311 rows where station_code = "NZ0044" 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
9273591 9273591 20260126152454_wLEPr NZ0044 2026-01-29T14:33:28.726Z 2026-01-29T14:33:28.726Z
9262044 9262044 20260126152837_3Tde2 NZ0044 2026-01-27T14:07:14.892Z 2026-01-29T14:33:29.665Z
9262026 9262026 20260126152454_cw0Y8 NZ0044 2026-01-27T14:07:06.245Z 2026-01-28T14:24:04.799Z
9261991 9261991 20260126150715_aJQdh NZ0044 2026-01-27T14:06:55.259Z 2026-01-29T14:33:22.878Z
9261980 9261980 20260126150417_bcGwg NZ0044 2026-01-27T14:06:52.543Z 2026-01-29T14:33:22.089Z
9261930 9261930 20260126144505_CSKiN NZ0044 2026-01-27T14:06:32.572Z 2026-01-29T14:33:17.754Z
9261853 9261853 20260126135527_uWSVY NZ0044 2026-01-27T14:06:06.503Z 2026-01-29T14:33:10.685Z
9261773 9261773 20260126131617_fXnR3 NZ0044 2026-01-27T14:05:36.017Z 2026-01-29T14:32:57.152Z
9261688 9261688 20260126124849_TrpkX NZ0044 2026-01-27T14:05:07.661Z 2026-01-29T14:32:48.641Z
9261672 9261672 20260126124604_c98zf NZ0044 2026-01-27T14:04:59.266Z 2026-01-29T14:32:47.614Z
9261613 9261613 20260126123200_MtD9a NZ0044 2026-01-27T14:04:43.346Z 2026-01-29T14:32:43.824Z
9261454 9261454 20260126114622_13Egu NZ0044 2026-01-27T14:03:47.455Z 2026-01-29T14:32:25.700Z
9233392 9233392 20260120150523_0Y32A NZ0044 2026-01-21T14:05:39.944Z 2026-01-29T15:01:04.556Z
9233391 9233391 20260120150516_PSEy2 NZ0044 2026-01-21T14:05:39.446Z 2026-01-29T15:01:04.459Z
9233313 9233313 20260120143553_jesKt NZ0044 2026-01-21T14:05:19.596Z 2026-01-29T15:00:56.819Z
9233236 9233236 20260120135038_nLGmA NZ0044 2026-01-21T14:04:55.359Z 2026-01-29T15:00:51.086Z
9233218 9233218 20260120133839_gRRCo NZ0044 2026-01-21T14:04:52.276Z 2026-01-29T15:00:49.891Z
9233113 9233113 20260120132225_DPlof NZ0044 2026-01-21T14:04:37.075Z 2026-01-29T15:00:45.962Z
9233104 9233104 20260120132050_bM0eN NZ0044 2026-01-21T14:04:31.321Z 2026-01-29T15:00:45.335Z
9233091 9233091 20260120131953_sA7pu NZ0044 2026-01-21T14:04:29.516Z 2026-01-29T15:00:44.941Z
9233072 9233072 20260120131815_yyUtQ NZ0044 2026-01-21T14:04:23.294Z 2026-01-29T15:00:44.074Z
9232997 9232997 20260120130345_AEN26 NZ0044 2026-01-21T14:04:11.227Z 2026-01-29T15:00:34.575Z
9225453 9225453 20260118094724_rhjj0 NZ0044 2026-01-19T14:28:59.994Z 2026-01-26T15:04:34.771Z
9221278 9221278 20260118151249_IogSC NZ0044 2026-01-19T14:07:20.183Z 2026-01-27T14:59:59.863Z
9221239 9221239 20260118151015_Z3BKb NZ0044 2026-01-19T14:07:14.447Z 2026-01-27T14:59:58.442Z
9221224 9221224 20260118150640_DZjgf NZ0044 2026-01-19T14:07:08.115Z 2026-01-27T14:59:57.884Z
9221217 9221217 20260118150620_rmqzO NZ0044 2026-01-19T14:07:07.665Z 2026-01-27T14:59:57.750Z
9221215 9221215 20260118150535_QZNa5 NZ0044 2026-01-19T14:07:07.106Z 2026-01-27T14:59:57.550Z
9221210 9221210 20260118150359_nXKSH NZ0044 2026-01-19T14:07:05.877Z 2026-01-27T14:59:57.260Z
9221199 9221199 20260118150134_0UFPy NZ0044 2026-01-19T14:07:02.666Z 2026-01-27T14:59:56.798Z
9221185 9221185 20260118150031_vgRpo NZ0044 2026-01-19T14:06:59.412Z 2026-01-27T14:59:56.417Z
9221166 9221166 20260118145625_e1h2n NZ0044 2026-01-19T14:06:55.517Z 2026-01-27T14:59:55.660Z
9221130 9221130 20260118145243_e4EFu NZ0044 2026-01-19T14:06:51.040Z 2026-01-27T14:59:54.696Z
9221120 9221120 20260118145156_V3gtY NZ0044 2026-01-19T14:06:49.253Z 2026-01-27T14:59:54.442Z
9221080 9221080 20260118144858_alL1u NZ0044 2026-01-19T14:06:43.800Z 2026-01-27T14:59:52.751Z
9221066 9221066 20260118144520_Agr0W NZ0044 2026-01-19T14:06:42.576Z 2026-01-27T14:59:52.520Z
9221009 9221009 20260118144231_yEGKz NZ0044 2026-01-19T14:06:27.073Z 2026-01-27T14:59:50.518Z
9220967 9220967 20260118143034_fbi72 NZ0044 2026-01-19T14:06:18.721Z 2026-01-27T14:59:48.397Z
9220949 9220949 20260118142326_g3q4M NZ0044 2026-01-19T14:06:15.538Z 2026-01-27T14:59:47.824Z
9220910 9220910 20260118141845_2q260 NZ0044 2026-01-19T14:06:08.744Z 2026-01-27T14:59:34.950Z
9220886 9220886 20260118141246_JsAHq NZ0044 2026-01-19T14:05:59.465Z 2026-01-27T14:59:33.601Z
9220858 9220858 20260118140652_g3UGH NZ0044 2026-01-19T14:05:53.032Z 2026-01-27T14:59:32.796Z
9220813 9220813 20260118135549_30B3f NZ0044 2026-01-19T14:05:44.719Z 2026-01-27T14:59:31.119Z
9220777 9220777 20260118134823_EJlBD NZ0044 2026-01-19T14:05:34.390Z 2026-01-27T14:59:28.140Z
9220766 9220766 20260118134359_1NJBk NZ0044 2026-01-19T14:05:27.875Z 2026-01-27T14:59:27.591Z
9220704 9220704 20260118133035_wEb9V NZ0044 2026-01-19T14:05:16.455Z 2026-01-27T14:59:25.291Z
9220555 9220555 20260118130840_7XIAS NZ0044 2026-01-19T14:04:45.945Z 2026-01-27T14:59:20.495Z
9220500 9220500 20260118130038_hZj9T NZ0044 2026-01-19T14:04:27.858Z 2026-01-27T14:59:17.715Z
9220391 9220391 20260118124502_W0MJt NZ0044 2026-01-19T14:04:00.722Z 2026-01-27T14:59:13.650Z
9220371 9220371 20260118124301_uvEMp NZ0044 2026-01-19T14:03:56.650Z 2026-01-27T14:59:02.917Z
9210301 9210301 20260112125539_VAHCl NZ0044 2026-01-16T14:47:47.137Z 2026-01-20T15:26:30.964Z
9193116 9193116 20260112133825_dQ3Dm NZ0044 2026-01-13T14:30:12.064Z 2026-01-20T15:26:59.948Z
9193110 9193110 20260112133713_YAgWo NZ0044 2026-01-13T14:30:11.047Z 2026-01-20T15:26:59.725Z
9193093 9193093 20260112133612_al02H NZ0044 2026-01-13T14:30:09.255Z 2026-01-20T15:26:59.214Z
9193045 9193045 20260112132933_WbESm NZ0044 2026-01-13T14:30:03.057Z 2026-01-20T15:26:57.484Z
9192695 9192695 20260112125342_c1td8 NZ0044 2026-01-13T14:29:03.659Z 2026-01-20T15:26:30.224Z
9192658 9192658 20260112125117_CfOIv NZ0044 2026-01-13T14:28:59.766Z 2026-01-20T15:26:28.764Z
9192565 9192565 20260112124442_qi0L9 NZ0044 2026-01-13T14:28:41.684Z 2026-01-20T15:26:25.876Z
9192526 9192526 20260112124015_o9ySu NZ0044 2026-01-13T14:28:34.284Z 2026-01-20T15:26:24.551Z
9192462 9192462 20260112123656_oMdZH NZ0044 2026-01-13T14:28:26.192Z 2026-01-20T15:26:22.786Z
9192214 9192214 20260112121246_LFEnR NZ0044 2026-01-13T14:27:44.313Z 2026-01-20T15:26:14.688Z
9192083 9192083 20260112120436_a4xBZ NZ0044 2026-01-13T14:27:23.631Z 2026-01-20T15:25:58.467Z
9192029 9192029 20260112120112_4ch89 NZ0044 2026-01-13T14:27:14.246Z 2026-01-20T15:25:57.093Z
9192026 9192026 20260112120110_bGsKD NZ0044 2026-01-13T14:27:13.761Z 2026-01-15T14:49:23.918Z
9191948 9191948 20260112115504_F0Ynu NZ0044 2026-01-13T14:26:59.088Z 2026-01-20T15:25:52.891Z
9191906 9191906 20260112115033_eV6VC NZ0044 2026-01-13T14:26:48.588Z 2026-01-20T15:25:50.848Z
9191846 9191846 20260112114702_pRfFj NZ0044 2026-01-13T14:26:40.203Z 2026-01-20T15:25:48.578Z
9191782 9191782 20260112114532_UD0QG NZ0044 2026-01-13T14:26:22.970Z 2026-01-20T15:25:46.819Z
9191689 9191689 20260112113428_hChm2 NZ0044 2026-01-13T14:26:10.177Z 2026-01-20T15:25:43.660Z
9191648 9191648 20260112113155_rzYAc NZ0044 2026-01-13T14:25:58.396Z 2026-01-20T15:25:42.090Z
9191318 9191318 20260112105741_rrcXH NZ0044 2026-01-13T14:25:03.051Z 2026-01-20T15:25:20.206Z
9191300 9191300 20260112105655_BwL2c NZ0044 2026-01-13T14:25:01.266Z 2026-01-20T15:25:18.521Z
9191255 9191255 20260112104953_34IMx NZ0044 2026-01-13T14:24:53.854Z 2026-01-20T15:25:16.215Z
9191165 9191165 20260112104151_F4NYD NZ0044 2026-01-13T14:24:35.968Z 2026-01-20T15:25:12.792Z
9191038 9191038 20260112102838_CQjgm NZ0044 2026-01-13T14:24:14.288Z 2026-01-20T15:25:07.865Z
9190941 9190941 20260112101701_C8IzK NZ0044 2026-01-13T14:23:57.884Z 2026-01-20T15:25:04.513Z
9190919 9190919 20260112101427_CtrAu NZ0044 2026-01-13T14:23:55.917Z 2026-01-20T15:25:03.624Z
9190913 9190913 20260112101409_FvP1J NZ0044 2026-01-13T14:23:54.835Z 2026-01-20T15:24:54.649Z
9190866 9190866 20260112100754_Qqrbl NZ0044 2026-01-13T14:23:41.557Z 2026-01-20T15:24:51.984Z
9190831 9190831 20260112100353_BSJBX NZ0044 2026-01-13T14:23:35.053Z 2026-01-20T15:24:51.116Z
9190811 9190811 20260112100140_YgYyQ NZ0044 2026-01-13T14:23:32.551Z 2026-01-20T15:24:50.362Z
9187085 9187085 20260111150650_QSW8w NZ0044 2026-01-13T14:05:22.263Z 2026-01-20T15:19:58.354Z
9187069 9187069 20260111150059_a3h1D NZ0044 2026-01-13T14:05:15.647Z 2026-01-20T15:19:56.969Z
9187056 9187056 20260111145524_j3S0D NZ0044 2026-01-13T14:05:12.352Z 2026-01-20T15:19:56.163Z
9187045 9187045 20260111145102_mt3bv NZ0044 2026-01-13T14:05:06.611Z 2026-01-20T15:19:55.043Z
9187030 9187030 20260111144653_XLmo5 NZ0044 2026-01-13T14:05:01.197Z 2026-01-20T15:19:54.091Z
9186580 9186580 20260112145934_siH5c NZ0044 2026-01-13T14:02:37.618Z 2026-01-21T15:02:44.725Z
9186507 9186507 20260112144900_5NVs0 NZ0044 2026-01-13T14:02:18.507Z 2026-01-21T15:02:38.989Z
9186500 9186500 20260112144521_jyzBc NZ0044 2026-01-13T14:02:16.811Z 2026-01-21T15:02:37.696Z
9186434 9186434 20260112143559_wIja9 NZ0044 2026-01-13T14:01:54.470Z 2026-01-21T15:02:31.498Z
9186286 9186286 20260112140934_3D9kB NZ0044 2026-01-13T14:01:13.565Z 2026-01-21T15:02:17.517Z
9186272 9186272 20260112140714_fGjYH NZ0044 2026-01-13T14:01:09.588Z 2026-01-21T15:02:16.463Z
9186178 9186178 20260112135652_YVhwi NZ0044 2026-01-13T14:00:42.128Z 2026-01-21T15:02:12.877Z
9185995 9185995 20260111141109_S0fZL NZ0044 2026-01-12T14:26:35.010Z 2026-01-19T15:22:28.139Z
9185976 9185976 20260111140419_ZFTN6 NZ0044 2026-01-12T14:26:26.819Z 2026-01-19T15:22:21.370Z
9185970 9185970 20260111140357_jtq6U NZ0044 2026-01-12T14:26:25.561Z 2026-01-19T15:22:17.569Z
9185875 9185875 20260111133331_JChCp NZ0044 2026-01-12T14:26:11.349Z 2026-01-19T15:21:59.682Z
9185793 9185793 20260111131034_H8Ejn NZ0044 2026-01-12T14:26:00.399Z 2026-01-19T15:21:51.595Z
9185786 9185786 20260111130902_W1nuk NZ0044 2026-01-12T14:25:52.977Z 2026-01-19T15:21:50.499Z
9185704 9185704 20260111124108_mor8h NZ0044 2026-01-12T14:25:43.274Z 2026-01-19T15:21:38.120Z

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