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,549 rows where station_code = "NZ005D" 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
9270683 9270683 20260128162240_3QKeC NZ005D 2026-01-29T14:13:18.265Z 2026-01-29T14:13:18.265Z
9270629 9270629 20260128161510_NCbQG NZ005D 2026-01-29T14:13:03.742Z 2026-01-29T14:13:03.742Z
9270547 9270547 20260128155905_A23Xy NZ005D 2026-01-29T14:12:43.387Z 2026-01-29T14:12:43.387Z
9270507 9270507 20260128155652_CakTe NZ005D 2026-01-29T14:12:27.993Z 2026-01-29T14:12:27.993Z
9270447 9270447 20260128155000_p1xgq NZ005D 2026-01-29T14:12:17.747Z 2026-01-29T14:12:17.747Z
9270438 9270438 20260128154914_d5mGz NZ005D 2026-01-29T14:12:16.402Z 2026-01-29T14:12:16.402Z
9270427 9270427 20260128154804_VpoVh NZ005D 2026-01-29T14:12:13.834Z 2026-01-29T14:12:13.834Z
9270376 9270376 20260128154013_vNGMX NZ005D 2026-01-29T14:11:58.243Z 2026-01-29T14:11:58.243Z
9270259 9270259 20260128152301_I6NOk NZ005D 2026-01-29T14:11:27.700Z 2026-01-29T14:11:27.700Z
9270253 9270253 20260128152023_CkuUd NZ005D 2026-01-29T14:11:24.261Z 2026-01-29T14:11:24.261Z
9270139 9270139 20260128150031_E1OJJ NZ005D 2026-01-29T14:11:04.625Z 2026-01-29T14:11:04.625Z
9270122 9270122 20260128145826_FL3k1 NZ005D 2026-01-29T14:10:56.336Z 2026-01-29T14:10:56.336Z
9270038 9270038 20260128145019_OISQU NZ005D 2026-01-29T14:10:42.259Z 2026-01-29T14:10:42.259Z
9269993 9269993 20260128144245_kDINc NZ005D 2026-01-29T14:10:28.872Z 2026-01-29T14:10:28.872Z
9269945 9269945 20260128143519_9U2LA NZ005D 2026-01-29T14:10:18.107Z 2026-01-29T14:10:18.107Z
9269887 9269887 20260128142858_tNcju NZ005D 2026-01-29T14:10:05.382Z 2026-01-29T14:10:05.382Z
9269873 9269873 20260128142546_Xndp1 NZ005D 2026-01-29T14:09:56.129Z 2026-01-29T14:09:56.129Z
9269797 9269797 20260128141516_FQpGZ NZ005D 2026-01-29T14:09:40.964Z 2026-01-29T14:09:40.964Z
9269756 9269756 20260128140907_enslc NZ005D 2026-01-29T14:09:30.889Z 2026-01-29T14:09:30.889Z
9269697 9269697 20260128135503_anLaU NZ005D 2026-01-29T14:09:06.126Z 2026-01-29T14:09:06.126Z
9269686 9269686 20260128135451_7L3TW NZ005D 2026-01-29T14:09:04.503Z 2026-01-29T14:09:04.503Z
9269660 9269660 20260128135140_9C9OJ NZ005D 2026-01-29T14:08:59.801Z 2026-01-29T14:08:59.801Z
9269575 9269575 20260128133916_xAUfo NZ005D 2026-01-29T14:08:32.299Z 2026-01-29T14:08:32.299Z
9269572 9269572 20260128133826_yDhec NZ005D 2026-01-29T14:08:31.651Z 2026-01-29T14:08:31.651Z
9269513 9269513 20260128132856_2tmi5 NZ005D 2026-01-29T14:08:20.831Z 2026-01-29T14:08:20.831Z
9269408 9269408 20260128131256_Gv3ul NZ005D 2026-01-29T14:07:52.461Z 2026-01-29T14:07:52.461Z
9269176 9269176 20260128124146_o4Uti NZ005D 2026-01-29T14:06:53.624Z 2026-01-29T14:06:53.624Z
9269100 9269100 20260128122642_rhmOO NZ005D 2026-01-29T14:06:30.732Z 2026-01-29T14:06:30.732Z
9269055 9269055 20260128121407_cdZbB NZ005D 2026-01-29T14:06:11.690Z 2026-01-29T14:06:11.690Z
9268966 9268966 20260128115521_caQOT NZ005D 2026-01-29T14:05:45.528Z 2026-01-29T14:05:45.528Z
9268694 9268694 20260128110254_OFSGE NZ005D 2026-01-29T14:04:22.610Z 2026-01-29T14:04:22.610Z
9268670 9268670 20260128110009_iQh93 NZ005D 2026-01-29T14:04:17.137Z 2026-01-29T14:04:17.137Z
9268592 9268592 20260128104856_AEcdU NZ005D 2026-01-29T14:03:53.712Z 2026-01-29T14:03:53.712Z
9268572 9268572 20260128104740_nshMf NZ005D 2026-01-29T14:03:50.659Z 2026-01-29T14:03:50.659Z
9268467 9268467 20260128102540_piYNM NZ005D 2026-01-29T14:03:15.472Z 2026-01-29T14:03:15.472Z
9268424 9268424 20260128101030_edKpg NZ005D 2026-01-29T14:02:54.762Z 2026-01-29T14:02:54.762Z
9268328 9268328 20260128095042_nc1tO NZ005D 2026-01-29T14:02:24.495Z 2026-01-29T14:02:24.495Z
9268272 9268272 20260128093610_V7jY2 NZ005D 2026-01-29T14:02:09.343Z 2026-01-29T14:02:09.343Z
9268205 9268205 20260128091857_uDF6I NZ005D 2026-01-29T14:01:40.009Z 2026-01-29T14:01:40.009Z
9268182 9268182 20260128091202_AB99x NZ005D 2026-01-29T14:01:34.976Z 2026-01-29T14:01:34.976Z
9268082 9268082 20260128084339_NYQQR NZ005D 2026-01-29T14:00:57.322Z 2026-01-29T14:00:57.322Z
9265922 9265922 20260127161622_D2xm4 NZ005D 2026-01-28T14:11:46.743Z 2026-01-29T14:30:24.738Z
9265919 9265919 20260127161622_9u8MW NZ005D 2026-01-28T14:11:45.726Z 2026-01-29T14:30:24.738Z
9265918 9265918 20260127161607_WXRPa NZ005D 2026-01-28T14:11:45.036Z 2026-01-29T14:30:24.737Z
9265835 9265835 20260127160241_OuQr3 NZ005D 2026-01-28T14:11:29.529Z 2026-01-29T14:30:24.686Z
9265802 9265802 20260127160124_2163x NZ005D 2026-01-28T14:11:23.183Z 2026-01-29T14:30:24.679Z
9265747 9265747 20260127155621_0Vx7t NZ005D 2026-01-28T14:11:13.804Z 2026-01-29T14:30:24.668Z
9265567 9265567 20260127153430_KLFWU NZ005D 2026-01-28T14:10:36.309Z 2026-01-29T14:30:24.613Z
9265462 9265462 20260127151733_5i2Pr NZ005D 2026-01-28T14:10:13.390Z 2026-01-29T14:30:24.553Z
9262117 9262117 20260126161215_T2Iix NZ005D 2026-01-27T14:07:40.992Z 2026-01-29T14:33:41.968Z
9262107 9262107 20260126161119_Jk2ey NZ005D 2026-01-27T14:07:34.345Z 2026-01-29T14:33:41.316Z
9262105 9262105 20260126161039_M9hjz NZ005D 2026-01-27T14:07:33.960Z 2026-01-29T14:33:41.175Z
9262082 9262082 20260126155528_gYvru NZ005D 2026-01-27T14:07:26.397Z 2026-01-29T14:33:38.735Z
9262079 9262079 20260126155520_jXc9t NZ005D 2026-01-27T14:07:25.737Z 2026-01-29T14:33:38.621Z
9262067 9262067 20260126154806_thSgM NZ005D 2026-01-27T14:07:22.347Z 2026-01-29T14:33:37.473Z
9262065 9262065 20260126154737_1iWkH NZ005D 2026-01-27T14:07:21.517Z 2026-01-29T14:33:37.319Z
9262057 9262057 20260126154231_QeG5o NZ005D 2026-01-27T14:07:18.836Z 2026-01-29T14:33:35.540Z
9261964 9261964 20260126150005_MqPSY NZ005D 2026-01-27T14:06:48.973Z 2026-01-29T14:33:20.980Z
9261912 9261912 20260126143502_tosa2 NZ005D 2026-01-27T14:06:22.685Z 2026-01-29T14:33:15.842Z
9261639 9261639 20260126123755_wR2j0 NZ005D 2026-01-27T14:04:48.607Z 2026-01-29T14:32:45.325Z
9261434 9261434 20260126113515_xew7B NZ005D 2026-01-27T14:03:41.954Z 2026-01-29T14:32:24.268Z
9261396 9261396 20260126112631_VQ95S NZ005D 2026-01-27T14:03:35.165Z 2026-01-29T14:32:16.014Z
9261198 9261198 20260126102316_39EBK NZ005D 2026-01-27T14:02:29.057Z 2026-01-29T14:32:03.722Z
9261194 9261194 20260126102204_Lj0Sv NZ005D 2026-01-27T14:02:26.841Z 2026-01-29T14:32:03.207Z
9261114 9261114 20260126095422_w3eDe NZ005D 2026-01-27T14:01:59.593Z 2026-01-29T14:31:57.251Z
9261097 9261097 20260126095102_tQPvA NZ005D 2026-01-27T14:01:51.848Z 2026-01-29T14:31:52.227Z
9257832 9257832 20260125160513_gznFE NZ005D 2026-01-26T14:07:58.809Z 2026-01-29T14:37:43.843Z
9257746 9257746 20260125154813_glHeX NZ005D 2026-01-26T14:07:33.878Z 2026-01-29T14:37:37.686Z
9257661 9257661 20260125151729_jDvNx NZ005D 2026-01-26T14:07:03.934Z 2026-01-29T14:37:33.503Z
9257507 9257507 20260125141116_Bg2E4 NZ005D 2026-01-26T14:06:02.501Z 2026-01-29T14:37:23.771Z
9257496 9257496 20260125140748_nlvon NZ005D 2026-01-26T14:06:00.037Z 2026-01-29T14:37:23.215Z
9257493 9257493 20260125140625_OIDGc NZ005D 2026-01-26T14:05:58.597Z 2026-01-29T14:37:21.436Z
9257436 9257436 20260125133256_H2oXZ NZ005D 2026-01-26T14:05:36.301Z 2026-01-29T14:37:12.158Z
9257396 9257396 20260125131912_X8XdW NZ005D 2026-01-26T14:05:23.473Z 2026-01-29T14:37:10.292Z
9257372 9257372 20260125131150_V6t9m NZ005D 2026-01-26T14:05:10.350Z 2026-01-29T14:37:08.260Z
9257268 9257268 20260125123933_oLNRO NZ005D 2026-01-26T14:04:30.893Z 2026-01-29T14:37:02.897Z
9257203 9257203 20260125122044_BLQj8 NZ005D 2026-01-26T14:04:08.270Z 2026-01-29T14:36:54.619Z
9257166 9257166 20260125121303_fDyAu NZ005D 2026-01-26T14:03:59.756Z 2026-01-29T14:36:51.821Z
9257143 9257143 20260125120646_xQ3iK NZ005D 2026-01-26T14:03:55.124Z 2026-01-29T14:36:50.937Z
9257096 9257096 20260125115133_yoQsK NZ005D 2026-01-26T14:03:39.356Z 2026-01-29T14:36:46.327Z
9257014 9257014 20260125113430_l4PC7 NZ005D 2026-01-26T14:03:10.719Z 2026-01-29T14:36:41.545Z
9256772 9256772 20260125102320_KkEyk NZ005D 2026-01-26T14:01:54.797Z 2026-01-29T14:36:23.462Z
9256602 9256602 20260125091712_cMM0U NZ005D 2026-01-26T14:00:51.377Z 2026-01-29T14:36:11.498Z
9253945 9253945 20260124160625_O1p6u NZ005D 2026-01-25T14:05:06.320Z 2026-01-29T14:41:52.454Z
9253922 9253922 20260124154706_BBJV3 NZ005D 2026-01-25T14:05:00.000Z 2026-01-29T14:41:49.249Z
9253572 9253572 20260124124836_Ep1TC NZ005D 2026-01-25T14:03:21.645Z 2026-01-29T14:40:58.298Z
9253281 9253281 20260124104355_yjeb2 NZ005D 2026-01-25T14:01:47.825Z 2026-01-29T14:40:32.310Z
9253194 9253194 20260124100359_LYx2k NZ005D 2026-01-25T14:01:13.887Z 2026-01-29T14:40:25.262Z
9252958 9252958 20260123083822_suy5s NZ005D 2026-01-24T14:18:00.045Z 2026-01-29T14:53:44.585Z
9250529 9250529 20260123161135_vAJXT NZ005D 2026-01-24T14:03:23.849Z 2026-01-29T14:45:53.709Z
9250502 9250502 20260123154428_PsO48 NZ005D 2026-01-24T14:03:16.149Z 2026-01-29T14:45:42.391Z
9250424 9250424 20260123144507_gvCDR NZ005D 2026-01-24T14:02:52.470Z 2026-01-29T14:45:33.385Z
9250276 9250276 20260123120133_NkvfC NZ005D 2026-01-24T14:02:04.356Z 2026-01-29T14:45:12.328Z
9250274 9250274 20260123120038_5BwWJ NZ005D 2026-01-24T14:02:03.601Z 2026-01-29T14:45:12.001Z
9250157 9250157 20260123105048_i5u31 NZ005D 2026-01-24T14:01:29.355Z 2026-01-29T14:45:02.571Z
9219993 9219993 20260118114745_RLwg6 NZ005D 2026-01-19T14:02:02.075Z 2026-01-27T14:58:44.593Z
9219991 9219991 20260118114708_4nraY NZ005D 2026-01-19T14:01:59.732Z 2026-01-27T14:58:44.502Z
9216146 9216146 20260116115646_YFnqI NZ005D 2026-01-17T14:28:02.569Z 2026-01-24T15:15:39.441Z
9216134 9216134 20260116115435_hI9d3 NZ005D 2026-01-17T14:28:00.196Z 2026-01-24T15:15:34.689Z
9216127 9216127 20260116115308_5c2FQ NZ005D 2026-01-17T14:27:59.626Z 2026-01-24T15:15:34.493Z

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