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

7,748 rows where station_code = "NZ005C" 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
9270659 9270659 20260128161832_Ke2nk NZ005C 2026-01-29T14:13:13.867Z 2026-01-29T14:13:13.867Z
9270519 9270519 20260128155725_QiqHE NZ005C 2026-01-29T14:12:31.209Z 2026-01-29T14:12:31.209Z
9270517 9270517 20260128155718_cipyb NZ005C 2026-01-29T14:12:30.721Z 2026-01-29T14:12:30.721Z
9270493 9270493 20260128155625_hrOrN NZ005C 2026-01-29T14:12:25.974Z 2026-01-29T14:12:25.974Z
9270464 9270464 20260128155303_CAD9P NZ005C 2026-01-29T14:12:20.853Z 2026-01-29T14:12:20.853Z
9270426 9270426 20260128154804_VpoVh NZ005C 2026-01-29T14:12:13.834Z 2026-01-29T14:12:13.834Z
9270400 9270400 20260128154302_wV52X NZ005C 2026-01-29T14:12:08.549Z 2026-01-29T14:12:08.549Z
9270392 9270392 20260128154217_dUeiz NZ005C 2026-01-29T14:12:01.086Z 2026-01-29T14:12:01.086Z
9270386 9270386 20260128154156_YEEuR NZ005C 2026-01-29T14:12:00.539Z 2026-01-29T14:12:00.539Z
9270353 9270353 20260128153538_QwZ1T NZ005C 2026-01-29T14:11:51.465Z 2026-01-29T14:11:51.465Z
9270335 9270335 20260128153238_3uVOn NZ005C 2026-01-29T14:11:47.485Z 2026-01-29T14:11:47.485Z
9270307 9270307 20260128152958_BZ6Ef NZ005C 2026-01-29T14:11:42.487Z 2026-01-29T14:11:42.487Z
9270252 9270252 20260128152023_CkuUd NZ005C 2026-01-29T14:11:24.261Z 2026-01-29T14:11:24.261Z
9270229 9270229 20260128151823_VRFwi NZ005C 2026-01-29T14:11:21.944Z 2026-01-29T14:11:21.944Z
9270208 9270208 20260128151450_TaQn7 NZ005C 2026-01-29T14:11:19.425Z 2026-01-29T14:11:19.425Z
9270169 9270169 20260128150446_ms3dz NZ005C 2026-01-29T14:11:10.233Z 2026-01-29T14:11:10.233Z
9270088 9270088 20260128145240_Z8QvE NZ005C 2026-01-29T14:10:48.839Z 2026-01-29T14:10:48.839Z
9270084 9270084 20260128145214_LGSv3 NZ005C 2026-01-29T14:10:48.381Z 2026-01-29T14:10:48.381Z
9270062 9270062 20260128145132_mLJuB NZ005C 2026-01-29T14:10:45.722Z 2026-01-29T14:10:45.722Z
9270057 9270057 20260128145058_UwiZd NZ005C 2026-01-29T14:10:44.522Z 2026-01-29T14:10:44.522Z
9269947 9269947 20260128143533_vBiJ0 NZ005C 2026-01-29T14:10:18.499Z 2026-01-29T14:10:18.499Z
9269858 9269858 20260128142534_WiDg1 NZ005C 2026-01-29T14:09:53.938Z 2026-01-29T14:09:53.938Z
9269774 9269774 20260128141109_NF318 NZ005C 2026-01-29T14:09:34.722Z 2026-01-29T14:09:34.722Z
9269755 9269755 20260128140907_enslc NZ005C 2026-01-29T14:09:30.889Z 2026-01-29T14:09:30.889Z
9269711 9269711 20260128135851_HzYvU NZ005C 2026-01-29T14:09:09.743Z 2026-01-29T14:09:09.743Z
9269703 9269703 20260128135756_SZQxG NZ005C 2026-01-29T14:09:08.130Z 2026-01-29T14:09:08.130Z
9269657 9269657 20260128135113_GedDu NZ005C 2026-01-29T14:08:59.317Z 2026-01-29T14:08:59.317Z
9269600 9269600 20260128134406_S10xd NZ005C 2026-01-29T14:08:41.396Z 2026-01-29T14:08:41.396Z
9269587 9269587 20260128133957_4hu56 NZ005C 2026-01-29T14:08:38.017Z 2026-01-29T14:08:38.017Z
9269558 9269558 20260128133318_QJKix NZ005C 2026-01-29T14:08:29.376Z 2026-01-29T14:08:29.376Z
9269532 9269532 20260128132957_sW7vn NZ005C 2026-01-29T14:08:23.996Z 2026-01-29T14:08:23.996Z
9269364 9269364 20260128130651_8wkZq NZ005C 2026-01-29T14:07:34.691Z 2026-01-29T14:07:34.691Z
9269214 9269214 20260128124611_SnyEL NZ005C 2026-01-29T14:07:01.252Z 2026-01-29T14:07:01.252Z
9269079 9269079 20260128122010_aLRy5 NZ005C 2026-01-29T14:06:20.542Z 2026-01-29T14:06:20.542Z
9269028 9269028 20260128120339_FGkoC NZ005C 2026-01-29T14:06:04.959Z 2026-01-29T14:06:04.959Z
9269013 9269013 20260128120025_AtZ2M NZ005C 2026-01-29T14:06:00.903Z 2026-01-29T14:06:00.903Z
9268974 9268974 20260128115614_cnuyq NZ005C 2026-01-29T14:05:47.234Z 2026-01-29T14:05:47.234Z
9268972 9268972 20260128115545_Hg3vU NZ005C 2026-01-29T14:05:46.786Z 2026-01-29T14:05:46.786Z
9268810 9268810 20260128112459_YBbbn NZ005C 2026-01-29T14:04:59.123Z 2026-01-29T14:04:59.123Z
9268693 9268693 20260128110254_OFSGE NZ005C 2026-01-29T14:04:22.610Z 2026-01-29T14:04:22.610Z
9268644 9268644 20260128105716_3GD9X NZ005C 2026-01-29T14:04:09.659Z 2026-01-29T14:04:09.659Z
9268600 9268600 20260128105018_q0E8e NZ005C 2026-01-29T14:03:56.028Z 2026-01-29T14:03:56.028Z
9268538 9268538 20260128104339_VaQwK NZ005C 2026-01-29T14:03:36.004Z 2026-01-29T14:03:36.004Z
9268452 9268452 20260128102219_uJHvN NZ005C 2026-01-29T14:03:11.288Z 2026-01-29T14:03:11.288Z
9268396 9268396 20260128100542_gcc2D NZ005C 2026-01-29T14:02:48.185Z 2026-01-29T14:02:48.185Z
9268388 9268388 20260128100505_mRCnR NZ005C 2026-01-29T14:02:45.699Z 2026-01-29T14:02:45.699Z
9268321 9268321 20260128094806_pSo6Z NZ005C 2026-01-29T14:02:22.179Z 2026-01-29T14:02:22.179Z
9268271 9268271 20260128093610_V7jY2 NZ005C 2026-01-29T14:02:09.343Z 2026-01-29T14:02:09.343Z
9268215 9268215 20260128092309_wDKvl NZ005C 2026-01-29T14:01:42.773Z 2026-01-29T14:01:42.773Z
9268204 9268204 20260128091857_uDF6I NZ005C 2026-01-29T14:01:40.009Z 2026-01-29T14:01:40.009Z
9268198 9268198 20260128091759_Ikh3c NZ005C 2026-01-29T14:01:37.701Z 2026-01-29T14:01:37.701Z
9268180 9268180 20260128090835_249dp NZ005C 2026-01-29T14:01:33.837Z 2026-01-29T14:01:33.837Z
9265993 9265993 20260127163011_hAN8g NZ005C 2026-01-28T14:12:00.678Z 2026-01-29T14:30:24.809Z
9265972 9265972 20260127162416_s3Wts NZ005C 2026-01-28T14:11:54.962Z 2026-01-29T14:30:24.803Z
9265950 9265950 20260127161823_IkSOZ NZ005C 2026-01-28T14:11:50.525Z 2026-01-29T14:30:24.743Z
9265879 9265879 20260127160939_l7YJX NZ005C 2026-01-28T14:11:39.425Z 2026-01-29T14:30:24.706Z
9265768 9265768 20260127155706_SdRKW NZ005C 2026-01-28T14:11:17.214Z 2026-01-29T14:30:24.671Z
9265660 9265660 20260127154548_u7wX2 NZ005C 2026-01-28T14:10:53.281Z 2026-01-29T14:30:24.648Z
9264126 9264126 20260127111722_emIjG NZ005C 2026-01-28T14:04:31.464Z 2026-01-29T14:30:20.067Z
9263825 9263825 20260127101933_wCnEF NZ005C 2026-01-28T14:03:01.673Z 2026-01-29T14:30:18.955Z
9262119 9262119 20260126161333_zz3eJ NZ005C 2026-01-27T14:07:41.722Z 2026-01-29T14:33:42.110Z
9262094 9262094 20260126160239_JH0hi NZ005C 2026-01-27T14:07:31.781Z 2026-01-29T14:33:39.812Z
9262090 9262090 20260126160217_EKSUR NZ005C 2026-01-27T14:07:30.752Z 2026-01-27T14:07:30.752Z
9262084 9262084 20260126160018_xYRxW NZ005C 2026-01-27T14:07:26.941Z 2026-01-29T14:33:39.112Z
9261909 9261909 20260126143346_uJlZU NZ005C 2026-01-27T14:06:21.990Z 2026-01-29T14:33:15.629Z
9261889 9261889 20260126142556_YfAaz NZ005C 2026-01-27T14:06:16.256Z 2026-01-29T14:33:14.375Z
9261835 9261835 20260126135021_7ZXy7 NZ005C 2026-01-27T14:05:55.299Z 2026-01-29T14:33:06.765Z
9261796 9261796 20260126132307_IGzcw NZ005C 2026-01-27T14:05:42.136Z 2026-01-29T14:33:03.256Z
9261762 9261762 20260126131119_42o3M NZ005C 2026-01-27T14:05:27.821Z 2026-01-29T14:32:55.944Z
9261738 9261738 20260126130342_XpBRJ NZ005C 2026-01-27T14:05:18.569Z 2026-01-29T14:32:54.225Z
9261681 9261681 20260126124809_JBTPI NZ005C 2026-01-27T14:05:05.852Z 2026-01-29T14:32:48.311Z
9261606 9261606 20260126122806_RfIzH NZ005C 2026-01-27T14:04:40.750Z 2026-01-29T14:32:42.987Z
9261457 9261457 20260126114642_OfNLz NZ005C 2026-01-27T14:03:48.014Z 2026-01-29T14:32:25.843Z
9261437 9261437 20260126113553_JSyNL NZ005C 2026-01-27T14:03:42.680Z 2026-01-29T14:32:24.486Z
9261432 9261432 20260126113430_wm23k NZ005C 2026-01-27T14:03:41.303Z 2026-01-29T14:32:24.051Z
9261401 9261401 20260126112751_xkicw NZ005C 2026-01-27T14:03:35.922Z 2026-01-29T14:32:16.167Z
9261394 9261394 20260126112558_fuinu NZ005C 2026-01-27T14:03:34.005Z 2026-01-29T14:32:15.815Z
9261386 9261386 20260126112105_JqEIO NZ005C 2026-01-27T14:03:31.792Z 2026-01-29T14:32:15.228Z
9261279 9261279 20260126105739_Rhk90 NZ005C 2026-01-27T14:02:58.796Z 2026-01-29T14:32:09.681Z
9261258 9261258 20260126104932_0bQNQ NZ005C 2026-01-27T14:02:51.777Z 2026-01-29T14:32:08.599Z
9261205 9261205 20260126102702_p6TeH NZ005C 2026-01-27T14:02:32.530Z 2026-01-29T14:32:04.083Z
9261166 9261166 20260126100726_E7WrI NZ005C 2026-01-27T14:02:19.717Z 2026-01-29T14:32:00.905Z
9261096 9261096 20260126095102_tQPvA NZ005C 2026-01-27T14:01:51.848Z 2026-01-29T14:31:52.227Z
9261076 9261076 20260126094451_0AVmy NZ005C 2026-01-27T14:01:45.969Z 2026-01-29T14:31:45.418Z
9261053 9261053 20260126093815_IjZay NZ005C 2026-01-27T14:01:38.998Z 2026-01-29T14:31:33.907Z
9261038 9261038 20260126093357_s6pic NZ005C 2026-01-27T14:01:35.597Z 2026-01-29T14:31:30.513Z
9261001 9261001 20260126091635_nBVmJ NZ005C 2026-01-27T14:01:20.410Z 2026-01-29T14:31:19.687Z
9260940 9260940 20260126085224_2JMCy NZ005C 2026-01-27T14:01:01.308Z 2026-01-29T14:31:14.887Z
9260901 9260901 20260126083045_SWWxr NZ005C 2026-01-27T14:00:42.507Z 2026-01-29T14:31:08.463Z
9257851 9257851 20260125162138_P4Xd5 NZ005C 2026-01-26T14:08:09.626Z 2026-01-29T14:37:44.711Z
9257825 9257825 20260125160425_GCtk2 NZ005C 2026-01-26T14:07:56.158Z 2026-01-29T14:37:43.412Z
9257759 9257759 20260125154921_tLBx3 NZ005C 2026-01-26T14:07:38.072Z 2026-01-29T14:37:38.314Z
9257657 9257657 20260125151606_jsqP9 NZ005C 2026-01-26T14:07:02.561Z 2026-01-29T14:37:33.169Z
9257592 9257592 20260125144814_vAnzg NZ005C 2026-01-26T14:06:32.999Z 2026-01-29T14:37:29.294Z
9257535 9257535 20260125142352_UhF99 NZ005C 2026-01-26T14:06:11.510Z 2026-01-29T14:37:26.020Z
9257522 9257522 20260125141732_Ll2a6 NZ005C 2026-01-26T14:06:05.277Z 2026-01-29T14:37:25.424Z
9257415 9257415 20260125132805_xibL8 NZ005C 2026-01-26T14:05:30.573Z 2026-01-29T14:37:11.141Z
9257279 9257279 20260125123958_iJHMc NZ005C 2026-01-26T14:04:33.165Z 2026-01-29T14:37:03.468Z
9257232 9257232 20260125122837_dfUQp NZ005C 2026-01-26T14:04:17.116Z 2026-01-29T14:37:00.461Z
9257209 9257209 20260125122101_sPqjg NZ005C 2026-01-26T14:04:08.834Z 2026-01-29T14:36:54.792Z

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