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

4,304 rows where station_code = "NZ005Z" 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
9626966 9626966 20260408153837_PIw6B NZ005Z 2026-04-09T12:09:38.220Z 2026-04-09T12:09:38.220Z
9626720 9626720 20260408145835_881v2 NZ005Z 2026-04-09T12:09:05.458Z 2026-04-09T12:09:05.458Z
9626442 9626442 20260408140357_8Aht2 NZ005Z 2026-04-09T12:08:21.472Z 2026-04-09T12:08:21.472Z
9626177 9626177 20260408132204_GRcum NZ005Z 2026-04-09T12:07:43.980Z 2026-04-09T12:07:43.980Z
9625854 9625854 20260408120950_tAvo8 NZ005Z 2026-04-09T12:06:59.442Z 2026-04-09T12:06:59.442Z
9625782 9625782 20260408114917_tDM7v NZ005Z 2026-04-09T12:06:41.951Z 2026-04-09T12:06:41.951Z
9625647 9625647 20260408113215_p3qXf NZ005Z 2026-04-09T12:06:12.095Z 2026-04-09T12:06:12.095Z
9625638 9625638 20260408113032_w5iGq NZ005Z 2026-04-09T12:06:10.720Z 2026-04-09T12:06:10.720Z
9625565 9625565 20260408112003_Htv2R NZ005Z 2026-04-09T12:05:58.941Z 2026-04-09T12:05:58.941Z
9625534 9625534 20260408111105_wEroA NZ005Z 2026-04-09T12:05:47.733Z 2026-04-09T12:05:47.733Z
9625452 9625452 20260408105510_rCj9N NZ005Z 2026-04-09T12:05:34.809Z 2026-04-09T12:05:34.809Z
9606074 9606074 20260403145125_egPfw NZ005Z 2026-04-04T12:05:15.394Z 2026-04-09T12:42:07.560Z
9606002 9606002 20260403140427_1nPOz NZ005Z 2026-04-04T12:04:55.001Z 2026-04-09T12:42:05.768Z
9605838 9605838 20260403121542_zS3T8 NZ005Z 2026-04-04T12:04:06.125Z 2026-04-09T12:42:00.909Z
9605436 9605436 20260403095755_0oMdV NZ005Z 2026-04-04T12:02:19.479Z 2026-04-09T12:41:22.239Z
9605164 9605164 20260403072154_kMxrY NZ005Z 2026-04-04T12:00:57.542Z 2026-04-09T12:41:15.854Z
9603517 9603517 20260402104540_FnOYq NZ005Z 2026-04-03T12:03:18.969Z 2026-04-09T12:43:58.588Z
9601030 9601030 20260401103856_8LgmW NZ005Z 2026-04-02T12:01:19.957Z 2026-04-09T12:45:22.209Z
9600923 9600923 20260401084628_0nXSn NZ005Z 2026-04-02T12:00:58.794Z 2026-04-09T12:45:20.219Z
9597955 9597955 20260330172307_4eT02 NZ005Z 2026-03-31T12:07:20.905Z 2026-04-08T12:44:21.568Z
9597876 9597876 20260330171157_BHDOh NZ005Z 2026-03-31T12:07:10.247Z 2026-04-08T12:44:19.679Z
9597848 9597848 20260330170850_ecVRO NZ005Z 2026-03-31T12:07:06.708Z 2026-04-08T12:44:18.753Z
9597790 9597790 20260330165952_7oxgy NZ005Z 2026-03-31T12:07:00.842Z 2026-04-08T12:44:17.550Z
9597645 9597645 20260330164723_rN3HG NZ005Z 2026-03-31T12:06:49.722Z 2026-04-08T12:44:12.726Z
9597631 9597631 20260330164622_R5o3R NZ005Z 2026-03-31T12:06:48.612Z 2026-04-08T12:44:07.452Z
9597350 9597350 20260330160909_hqh4J NZ005Z 2026-03-31T12:06:13.294Z 2026-04-08T12:43:41.066Z
9591584 9591584 20260328171604_35R3m NZ005Z 2026-03-29T12:04:39.157Z 2026-04-06T12:39:24.157Z
9591560 9591560 20260328170919_u38Ke NZ005Z 2026-03-29T12:04:36.598Z 2026-04-06T12:39:22.892Z
9591526 9591526 20260328170301_fmLoM NZ005Z 2026-03-29T12:04:32.527Z 2026-04-06T12:39:19.665Z
9591473 9591473 20260328164803_c4SLR NZ005Z 2026-03-29T12:04:28.906Z 2026-04-06T12:39:17.361Z
9591444 9591444 20260328163706_rKpqQ NZ005Z 2026-03-29T12:04:25.596Z 2026-04-06T12:39:15.860Z
9591378 9591378 20260328160734_BPXkC NZ005Z 2026-03-29T12:04:19.632Z 2026-04-06T12:39:13.101Z
9591294 9591294 20260328152504_pbklr NZ005Z 2026-03-29T12:04:10.575Z 2026-04-06T12:39:09.462Z
9591290 9591290 20260328152215_juVCR NZ005Z 2026-03-29T12:04:10.107Z 2026-04-06T12:39:09.254Z
9591253 9591253 20260328150221_xPzAy NZ005Z 2026-03-29T12:04:06.804Z 2026-04-06T12:39:07.803Z
9591225 9591225 20260328143959_SEKSB NZ005Z 2026-03-29T12:04:02.788Z 2026-04-06T12:39:06.293Z
9590162 9590162 20260328071855_rTZTM NZ005Z 2026-03-29T12:02:08.447Z 2026-04-06T12:37:54.375Z
9565308 9565308 20260323115921_eG4HN NZ005Z 2026-03-24T12:09:51.055Z 2026-03-31T12:27:32.992Z
9565125 9565125 20260323114522_FYf4Z NZ005Z 2026-03-24T12:09:26.807Z 2026-03-31T12:27:23.177Z
9564902 9564902 20260323112118_uF2tN NZ005Z 2026-03-24T12:08:59.608Z 2026-03-31T12:27:18.726Z
9564759 9564759 20260323110705_OenR6 NZ005Z 2026-03-24T12:08:45.151Z 2026-03-31T12:27:15.047Z
9564753 9564753 20260323110626_TtAyq NZ005Z 2026-03-24T12:08:44.810Z 2026-03-31T12:27:14.934Z
9564612 9564612 20260323105539_hHw4P NZ005Z 2026-03-24T12:08:27.332Z 2026-03-31T12:27:12.409Z
9564260 9564260 20260323101900_ZSUNL NZ005Z 2026-03-24T12:07:44.284Z 2026-03-31T12:27:06.159Z
9564166 9564166 20260323100602_6he0k NZ005Z 2026-03-24T12:07:32.570Z 2026-03-31T12:27:04.096Z
9564083 9564083 20260323095724_7Qjp3 NZ005Z 2026-03-24T12:07:23.840Z 2026-03-31T12:27:02.177Z
9563587 9563587 20260323084707_PYveW NZ005Z 2026-03-24T12:06:18.745Z 2026-03-31T12:26:47.490Z
9563250 9563250 20260323074635_98M1Y NZ005Z 2026-03-24T12:05:35.906Z 2026-03-31T12:26:39.212Z
9563180 9563180 20260323073013_Pliw0 NZ005Z 2026-03-24T12:05:22.659Z 2026-03-31T12:26:37.518Z
9559392 9559392 20260321170817_Cuf1X NZ005Z 2026-03-23T12:11:03.998Z 2026-03-29T12:20:38.458Z
9557199 9557199 20260322131445_eMpFC NZ005Z 2026-03-23T12:05:41.210Z 2026-03-30T12:29:31.513Z
9556660 9556660 20260322111651_UORnF NZ005Z 2026-03-23T12:05:05.193Z 2026-03-30T12:29:07.241Z
9556159 9556159 20260322092807_HROti NZ005Z 2026-03-23T12:04:25.455Z 2026-03-30T12:28:46.224Z
9549045 9549045 20260321165728_kdh0x NZ005Z 2026-03-22T12:16:28.183Z 2026-03-29T12:20:37.736Z
9548946 9548946 20260321160226_yqdRy NZ005Z 2026-03-22T12:16:16.660Z 2026-03-29T12:20:31.403Z
9547118 9547118 20260321125414_1DvHi NZ005Z 2026-03-22T12:13:02.485Z 2026-03-29T12:20:07.036Z
9546959 9546959 20260321124355_88AQ9 NZ005Z 2026-03-22T12:12:43.152Z 2026-03-29T12:20:05.539Z
9546920 9546920 20260321124032_c5b6I NZ005Z 2026-03-22T12:12:40.062Z 2026-03-29T12:20:05.294Z
9546759 9546759 20260321122503_3s2yL NZ005Z 2026-03-22T12:12:21.243Z 2026-03-29T12:20:04.026Z
9545958 9545958 20260321112707_Kb1ID NZ005Z 2026-03-22T12:10:43.679Z 2026-03-29T12:19:46.153Z
9545757 9545757 20260321110443_YOiIp NZ005Z 2026-03-22T12:10:09.512Z 2026-03-29T12:19:43.069Z
9545339 9545339 20260321102243_184D7 NZ005Z 2026-03-22T12:09:09.054Z 2026-03-29T12:19:39.314Z
9544686 9544686 20260321090927_cgrw3 NZ005Z 2026-03-22T12:07:29.646Z 2026-03-29T12:19:32.499Z
9544546 9544546 20260321085146_xSAS7 NZ005Z 2026-03-22T12:07:07.556Z 2026-03-29T12:19:30.926Z
9539791 9539791 20260320165638_Do4OU NZ005Z 2026-03-21T12:20:12.933Z 2026-03-28T12:36:33.591Z
9539770 9539770 20260320164424_Eb1wh NZ005Z 2026-03-21T12:20:10.993Z 2026-03-28T12:36:31.740Z
9539587 9539587 20260320152825_EQ8J3 NZ005Z 2026-03-21T12:19:46.924Z 2026-03-28T12:36:14.318Z
9539578 9539578 20260320152619_wzRO8 NZ005Z 2026-03-21T12:19:46.340Z 2026-03-28T12:36:11.039Z
9539554 9539554 20260320151614_KebRv NZ005Z 2026-03-21T12:19:43.200Z 2026-03-28T12:36:06.656Z
9539510 9539510 20260320150015_AyNfC NZ005Z 2026-03-21T12:19:39.104Z 2026-03-28T12:36:04.334Z
9539487 9539487 20260320145609_2Ic3P NZ005Z 2026-03-21T12:19:36.574Z 2026-03-28T12:36:03.278Z
9539473 9539473 20260320145325_u2x3g NZ005Z 2026-03-21T12:19:35.384Z 2026-03-28T12:36:01.919Z
9536207 9536207 20260320092243_2G2KO NZ005Z 2026-03-21T12:12:48.865Z 2026-03-28T12:34:58.554Z
9535817 9535817 20260320083529_vbwgR NZ005Z 2026-03-21T12:11:57.204Z 2026-03-28T12:34:51.732Z
9535809 9535809 20260320083528_g6j9F NZ005Z 2026-03-21T12:11:56.950Z 2026-03-28T12:34:51.630Z
9535595 9535595 20260320080545_MQx2y NZ005Z 2026-03-21T12:11:16.626Z 2026-03-28T12:34:47.507Z
9528780 9528780 20260318164357_aWi7w NZ005Z 2026-03-20T12:22:30.841Z 2026-03-26T12:38:38.049Z
9527901 9527901 20260318152351_Kucpp NZ005Z 2026-03-20T12:21:47.365Z 2026-03-26T12:38:31.890Z
9527889 9527889 20260318152238_u6XGj NZ005Z 2026-03-20T12:21:47.202Z 2026-03-26T12:38:31.873Z
9527775 9527775 20260318151355_fbwfR NZ005Z 2026-03-20T12:21:42.930Z 2026-03-26T12:38:31.231Z
9526921 9526921 20260318133544_TBDpX NZ005Z 2026-03-20T12:20:44.863Z 2026-03-26T12:38:24.618Z
9526728 9526728 20260319172522_lPGAU NZ005Z 2026-03-20T12:15:29.476Z 2026-03-27T12:42:29.830Z
9526460 9526460 20260319164518_hCUHT NZ005Z 2026-03-20T12:15:14.570Z 2026-03-27T12:42:26.420Z
9526005 9526005 20260319154235_dcVXr NZ005Z 2026-03-20T12:14:44.037Z 2026-03-27T12:42:21.893Z
9525987 9525987 20260319153904_MLbr8 NZ005Z 2026-03-20T12:14:43.544Z 2026-03-27T12:42:21.649Z
9525777 9525777 20260319151522_xXf8K NZ005Z 2026-03-20T12:14:32.732Z 2026-03-27T12:42:19.638Z
9525689 9525689 20260319150647_w9bdM NZ005Z 2026-03-20T12:14:25.568Z 2026-03-27T12:42:18.816Z
9525452 9525452 20260319143336_02lgI NZ005Z 2026-03-20T12:14:13.953Z 2026-03-27T12:42:03.786Z
9525350 9525350 20260319141437_yhhBv NZ005Z 2026-03-20T12:14:08.790Z 2026-03-27T12:42:02.905Z
9525227 9525227 20260319135124_Ibr2c NZ005Z 2026-03-20T12:13:59.049Z 2026-03-27T12:42:01.920Z
9525134 9525134 20260319132808_BOSl8 NZ005Z 2026-03-20T12:13:50.972Z 2026-03-27T12:42:00.045Z
9524980 9524980 20260319130531_HsdV2 NZ005Z 2026-03-20T12:13:43.566Z 2026-03-27T12:41:58.784Z
9524943 9524943 20260319130109_3ZS16 NZ005Z 2026-03-20T12:13:41.750Z 2026-03-27T12:41:58.458Z
9524740 9524740 20260319122810_J4KKM NZ005Z 2026-03-20T12:13:25.185Z 2026-03-27T12:41:55.915Z
9524671 9524671 20260319122106_zrI0l NZ005Z 2026-03-20T12:13:19.627Z 2026-03-27T12:41:55.117Z
9524609 9524609 20260319121758_XbwHB NZ005Z 2026-03-20T12:13:12.410Z 2026-03-27T12:41:54.590Z
9524369 9524369 20260319114802_kxklk NZ005Z 2026-03-20T12:12:54.229Z 2026-03-27T12:41:51.861Z
9524248 9524248 20260319113129_n5gpi NZ005Z 2026-03-20T12:12:40.112Z 2026-03-27T12:41:50.184Z
9524193 9524193 20260319112745_stZHb NZ005Z 2026-03-20T12:12:34.871Z 2026-03-27T12:41:49.496Z
9524126 9524126 20260319112329_1dPja NZ005Z 2026-03-20T12:12:30.083Z 2026-03-27T12:41:49.016Z

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