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

6,936 rows where station_code = "NZ005E" 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
9270590 9270590 20260128160821_oaDTS NZ005E 2026-01-29T14:12:52.897Z 2026-01-29T14:12:52.897Z
9270484 9270484 20260128155510_MXn6P NZ005E 2026-01-29T14:12:24.374Z 2026-01-29T14:12:24.374Z
9270381 9270381 20260128154131_rlj7z NZ005E 2026-01-29T14:11:59.680Z 2026-01-29T14:11:59.680Z
9270373 9270373 20260128154013_vy4US NZ005E 2026-01-29T14:11:57.759Z 2026-01-29T14:11:57.759Z
9270360 9270360 20260128153905_qz1vB NZ005E 2026-01-29T14:11:52.848Z 2026-01-29T14:11:52.848Z
9270358 9270358 20260128153639_BcDCj NZ005E 2026-01-29T14:11:52.452Z 2026-01-29T14:11:52.452Z
9270326 9270326 20260128153132_uTx08 NZ005E 2026-01-29T14:11:46.099Z 2026-01-29T14:11:46.099Z
9270319 9270319 20260128153109_fXf0U NZ005E 2026-01-29T14:11:44.932Z 2026-01-29T14:11:44.932Z
9270276 9270276 20260128152315_DVU0W NZ005E 2026-01-29T14:11:30.475Z 2026-01-29T14:11:30.475Z
9270224 9270224 20260128151751_0BU18 NZ005E 2026-01-29T14:11:21.441Z 2026-01-29T14:11:21.441Z
9270217 9270217 20260128151739_bP5XR NZ005E 2026-01-29T14:11:20.455Z 2026-01-29T14:11:20.455Z
9270192 9270192 20260128151144_ZQStZ NZ005E 2026-01-29T14:11:15.194Z 2026-01-29T14:11:15.194Z
9270177 9270177 20260128150547_nXx2f NZ005E 2026-01-29T14:11:11.487Z 2026-01-29T14:11:11.487Z
9270133 9270133 20260128145842_HMpEf NZ005E 2026-01-29T14:10:58.125Z 2026-01-29T14:10:58.125Z
9270045 9270045 20260128145026_fAr5n NZ005E 2026-01-29T14:10:43.539Z 2026-01-29T14:10:43.539Z
9269986 9269986 20260128144046_jHFHS NZ005E 2026-01-29T14:10:26.908Z 2026-01-29T14:10:26.908Z
9269856 9269856 20260128142513_pM1Rj NZ005E 2026-01-29T14:09:53.441Z 2026-01-29T14:09:53.441Z
9269815 9269815 20260128141730_5x3RH NZ005E 2026-01-29T14:09:44.068Z 2026-01-29T14:09:44.068Z
9269746 9269746 20260128140553_MJ3u3 NZ005E 2026-01-29T14:09:29.126Z 2026-01-29T14:09:29.126Z
9269717 9269717 20260128135858_hoNMh NZ005E 2026-01-29T14:09:11.326Z 2026-01-29T14:09:11.326Z
9269713 9269713 20260128135858_UvGHQ NZ005E 2026-01-29T14:09:10.396Z 2026-01-29T14:09:10.396Z
9269696 9269696 20260128135503_73CHQ NZ005E 2026-01-29T14:09:05.573Z 2026-01-29T14:09:05.573Z
9269647 9269647 20260128134907_p25nc NZ005E 2026-01-29T14:08:56.524Z 2026-01-29T14:08:56.524Z
9269583 9269583 20260128133951_hluLL NZ005E 2026-01-29T14:08:33.823Z 2026-01-29T14:08:33.823Z
9269547 9269547 20260128133059_jP2i2 NZ005E 2026-01-29T14:08:26.663Z 2026-01-29T14:08:26.663Z
9269514 9269514 20260128132856_2tmi5 NZ005E 2026-01-29T14:08:20.831Z 2026-01-29T14:08:20.831Z
9269505 9269505 20260128132820_eNEjZ NZ005E 2026-01-29T14:08:18.958Z 2026-01-29T14:08:18.958Z
9269459 9269459 20260128131951_BsJy4 NZ005E 2026-01-29T14:08:03.019Z 2026-01-29T14:08:03.019Z
9269455 9269455 20260128131929_igD8S NZ005E 2026-01-29T14:08:02.451Z 2026-01-29T14:08:02.451Z
9269417 9269417 20260128131412_c0sUS NZ005E 2026-01-29T14:07:54.600Z 2026-01-29T14:07:54.600Z
9269396 9269396 20260128131227_Lkj5j NZ005E 2026-01-29T14:07:50.587Z 2026-01-29T14:07:50.587Z
9269386 9269386 20260128131215_ktYe9 NZ005E 2026-01-29T14:07:48.828Z 2026-01-29T14:07:48.828Z
9269378 9269378 20260128130958_QcIAN NZ005E 2026-01-29T14:07:42.648Z 2026-01-29T14:07:42.648Z
9269363 9269363 20260128130620_oCg3N NZ005E 2026-01-29T14:07:34.222Z 2026-01-29T14:07:34.222Z
9269331 9269331 20260128130226_OmACH NZ005E 2026-01-29T14:07:28.636Z 2026-01-29T14:07:28.636Z
9269326 9269326 20260128130216_Fn1s4 NZ005E 2026-01-29T14:07:28.166Z 2026-01-29T14:07:28.166Z
9269315 9269315 20260128130214_hRGts NZ005E 2026-01-29T14:07:27.157Z 2026-01-29T14:07:27.157Z
9269291 9269291 20260128125810_jrntE NZ005E 2026-01-29T14:07:23.351Z 2026-01-29T14:07:23.351Z
9269267 9269267 20260128125355_G9pJq NZ005E 2026-01-29T14:07:12.782Z 2026-01-29T14:07:12.782Z
9269246 9269246 20260128125024_YcajY NZ005E 2026-01-29T14:07:05.843Z 2026-01-29T14:07:05.843Z
9269207 9269207 20260128124527_Cg29U NZ005E 2026-01-29T14:06:59.346Z 2026-01-29T14:06:59.346Z
9269097 9269097 20260128122440_1YyiV NZ005E 2026-01-29T14:06:30.156Z 2026-01-29T14:06:30.156Z
9269050 9269050 20260128121304_5BgoR NZ005E 2026-01-29T14:06:09.799Z 2026-01-29T14:06:09.799Z
9269021 9269021 20260128120155_GoWU7 NZ005E 2026-01-29T14:06:02.687Z 2026-01-29T14:06:02.687Z
9268747 9268747 20260128111357_o2D7o NZ005E 2026-01-29T14:04:42.095Z 2026-01-29T14:04:42.095Z
9268632 9268632 20260128105623_5AnKe NZ005E 2026-01-29T14:04:06.545Z 2026-01-29T14:04:06.545Z
9268407 9268407 20260128100702_i9J07 NZ005E 2026-01-29T14:02:50.660Z 2026-01-29T14:02:50.660Z
9268183 9268183 20260128091202_AB99x NZ005E 2026-01-29T14:01:34.976Z 2026-01-29T14:01:34.976Z
9265892 9265892 20260127161107_qq6nU NZ005E 2026-01-28T14:11:41.530Z 2026-01-29T14:30:24.709Z
9265889 9265889 20260127161032_sviC5 NZ005E 2026-01-28T14:11:40.977Z 2026-01-29T14:30:24.708Z
9265883 9265883 20260127161004_gmPK5 NZ005E 2026-01-28T14:11:39.932Z 2026-01-29T14:30:24.707Z
9265868 9265868 20260127160813_0QbMN NZ005E 2026-01-28T14:11:37.556Z 2026-01-29T14:30:24.704Z
9265867 9265867 20260127160650_45VsP NZ005E 2026-01-28T14:11:37.103Z 2026-01-29T14:30:24.703Z
9265854 9265854 20260127160510_yT6qZ NZ005E 2026-01-28T14:11:36.073Z 2026-01-29T14:30:24.692Z
9265836 9265836 20260127160241_OuQr3 NZ005E 2026-01-28T14:11:29.529Z 2026-01-29T14:30:24.686Z
9265806 9265806 20260127160126_u2g8I NZ005E 2026-01-28T14:11:24.578Z 2026-01-29T14:30:24.680Z
9265781 9265781 20260127155903_J4LJA NZ005E 2026-01-28T14:11:19.132Z 2026-01-29T14:30:24.674Z
9265734 9265734 20260127155417_6g26O NZ005E 2026-01-28T14:11:11.063Z 2026-01-29T14:30:24.665Z
9265692 9265692 20260127154924_PzL5m NZ005E 2026-01-28T14:11:00.477Z 2026-01-29T14:30:24.655Z
9262092 9262092 20260126160218_3gsrt NZ005E 2026-01-27T14:07:31.324Z 2026-01-29T14:33:39.651Z
9261622 9261622 20260126123314_Xda71 NZ005E 2026-01-27T14:04:45.323Z 2026-01-29T14:32:44.343Z
9261588 9261588 20260126122127_YkN7d NZ005E 2026-01-27T14:04:30.200Z 2026-01-29T14:32:41.657Z
9261499 9261499 20260126115827_dGvdB NZ005E 2026-01-27T14:04:04.702Z 2026-01-29T14:32:36.130Z
9261188 9261188 20260126102120_HWC5Z NZ005E 2026-01-27T14:02:25.113Z 2026-01-29T14:32:02.596Z
9261150 9261150 20260126100241_n3W0n NZ005E 2026-01-27T14:02:13.559Z 2026-01-29T14:31:59.611Z
9261009 9261009 20260126092030_XKiuK NZ005E 2026-01-27T14:01:22.769Z 2026-01-29T14:31:22.318Z
9260962 9260962 20260126090158_K2ROp NZ005E 2026-01-27T14:01:09.340Z 2026-01-29T14:31:16.222Z
9260913 9260913 20260126083705_iHop2 NZ005E 2026-01-27T14:00:48.023Z 2026-01-29T14:31:13.232Z
9257786 9257786 20260125155710_U36g2 NZ005E 2026-01-26T14:07:44.607Z 2026-01-29T14:37:39.997Z
9257783 9257783 20260125155710_ZMjQa NZ005E 2026-01-26T14:07:44.071Z 2026-01-29T14:37:39.617Z
9257763 9257763 20260125155125_h3aHP NZ005E 2026-01-26T14:07:38.921Z 2026-01-29T14:37:38.433Z
9257733 9257733 20260125154418_CnEC2 NZ005E 2026-01-26T14:07:30.522Z 2026-01-29T14:37:37.446Z
9257639 9257639 20260125150821_oPESF NZ005E 2026-01-26T14:06:53.667Z 2026-01-29T14:37:31.973Z
9257631 9257631 20260125150512_hQPbf NZ005E 2026-01-26T14:06:50.905Z 2026-01-29T14:37:31.485Z
9257578 9257578 20260125144403_Y2aah NZ005E 2026-01-26T14:06:29.555Z 2026-01-29T14:37:28.684Z
9257560 9257560 20260125143556_MUVxF NZ005E 2026-01-26T14:06:23.208Z 2026-01-29T14:37:27.579Z
9257558 9257558 20260125143325_wLNMs NZ005E 2026-01-26T14:06:22.253Z 2026-01-29T14:37:27.436Z
9257497 9257497 20260125140748_nlvon NZ005E 2026-01-26T14:06:00.037Z 2026-01-29T14:37:23.215Z
9257488 9257488 20260125140530_xwH7L NZ005E 2026-01-26T14:05:57.251Z 2026-01-29T14:37:16.975Z
9257468 9257468 20260125135803_RYlLL NZ005E 2026-01-26T14:05:48.122Z 2026-01-29T14:37:14.137Z
9257333 9257333 20260125124915_fLWMl NZ005E 2026-01-26T14:04:46.379Z 2026-01-29T14:37:05.866Z
9257317 9257317 20260125124544_c2bkj NZ005E 2026-01-26T14:04:42.444Z 2026-01-29T14:37:05.324Z
9257311 9257311 20260125124455_7gKAd NZ005E 2026-01-26T14:04:40.174Z 2026-01-29T14:37:04.785Z
9257302 9257302 20260125124305_z13KC NZ005E 2026-01-26T14:04:38.024Z 2026-01-29T14:37:04.348Z
9257164 9257164 20260125121256_6U2gQ NZ005E 2026-01-26T14:03:59.133Z 2026-01-29T14:36:51.700Z
9257099 9257099 20260125115255_PnGU0 NZ005E 2026-01-26T14:03:39.878Z 2026-01-29T14:36:46.532Z
9257077 9257077 20260125114948_aSJDq NZ005E 2026-01-26T14:03:34.786Z 2026-01-29T14:36:45.161Z
9257020 9257020 20260125113545_ZixjN NZ005E 2026-01-26T14:03:11.337Z 2026-01-29T14:36:41.689Z
9256995 9256995 20260125113245_Dqz3U NZ005E 2026-01-26T14:03:08.137Z 2026-01-29T14:36:40.716Z
9256623 9256623 20260125093110_ZLqbv NZ005E 2026-01-26T14:00:58.618Z 2026-01-29T14:36:12.248Z
9256610 9256610 20260125093023_ChKHN NZ005E 2026-01-26T14:00:56.896Z 2026-01-29T14:36:11.916Z
9253578 9253578 20260124125047_xA8aR NZ005E 2026-01-25T14:03:23.242Z 2026-01-29T14:40:58.570Z
9253573 9253573 20260124124836_Ep1TC NZ005E 2026-01-25T14:03:21.645Z 2026-01-29T14:40:58.298Z
9253102 9253102 20260124091926_UPJG8 NZ005E 2026-01-25T14:00:42.153Z 2026-01-29T14:40:15.271Z
9252973 9252973 20260123084358_exgLk NZ005E 2026-01-24T14:18:03.254Z 2026-01-29T14:53:45.368Z
9250495 9250495 20260123153552_8292X NZ005E 2026-01-24T14:03:14.859Z 2026-01-29T14:45:41.051Z
9250486 9250486 20260123153217_c2coc NZ005E 2026-01-24T14:03:10.666Z 2026-01-29T14:45:38.396Z
9250483 9250483 20260123153038_UYaQo NZ005E 2026-01-24T14:03:09.994Z 2026-01-29T14:45:38.284Z
9250160 9250160 20260123105412_g512c NZ005E 2026-01-24T14:01:30.012Z 2026-01-29T14:45:02.684Z
9250071 9250071 20260123100338_KeDHO NZ005E 2026-01-24T14:00:59.124Z 2026-01-29T14:44:57.030Z

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