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

2,909 rows where station_code = "NZ004Z" 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
9257300 9257300 20260125124305_z13KC NZ004Z 2026-01-26T14:04:38.024Z 2026-01-29T14:37:04.348Z
9257254 9257254 20260125123507_GNsgD NZ004Z 2026-01-26T14:04:27.460Z 2026-01-29T14:37:01.925Z
9257131 9257131 20260125120324_7Q9XO NZ004Z 2026-01-26T14:03:47.670Z 2026-01-29T14:36:50.174Z
9253928 9253928 20260124155537_il2qp NZ004Z 2026-01-25T14:05:02.332Z 2026-01-29T14:41:49.992Z
9253880 9253880 20260124153224_onFtB NZ004Z 2026-01-25T14:04:49.018Z 2026-01-29T14:41:45.353Z
9253877 9253877 20260124153207_MWrad NZ004Z 2026-01-25T14:04:47.011Z 2026-01-29T14:41:45.224Z
9253853 9253853 20260124151539_3UIkA NZ004Z 2026-01-25T14:04:40.071Z 2026-01-29T14:41:42.726Z
9253836 9253836 20260124150905_SJqj5 NZ004Z 2026-01-25T14:04:37.604Z 2026-01-29T14:41:41.035Z
9253786 9253786 20260124143450_igXkS NZ004Z 2026-01-25T14:04:23.983Z 2026-01-29T14:41:26.976Z
9253763 9253763 20260124142801_bc5Xa NZ004Z 2026-01-25T14:04:16.486Z 2026-01-29T14:41:25.309Z
9253707 9253707 20260124135726_R6W9E NZ004Z 2026-01-25T14:04:02.927Z 2026-01-29T14:41:18.678Z
9253617 9253617 20260124130847_Ey6q3 NZ004Z 2026-01-25T14:03:34.443Z 2026-01-29T14:41:04.247Z
9253603 9253603 20260124125804_2H8qP NZ004Z 2026-01-25T14:03:28.810Z 2026-01-29T14:41:02.286Z
9253594 9253594 20260124125718_ot94p NZ004Z 2026-01-25T14:03:27.249Z 2026-01-29T14:41:01.986Z
9253407 9253407 20260124113358_v2qqv NZ004Z 2026-01-25T14:02:34.673Z 2026-01-29T14:40:47.311Z
9253364 9253364 20260124111319_gZyfm NZ004Z 2026-01-25T14:02:16.023Z 2026-01-29T14:40:44.108Z
9253337 9253337 20260124110258_mN2DD NZ004Z 2026-01-25T14:02:08.143Z 2026-01-29T14:40:39.102Z
9253172 9253172 20260124095404_m3Aif NZ004Z 2026-01-25T14:01:06.930Z 2026-01-29T14:40:23.500Z
9253049 9253049 20260124085138_JcwWA NZ004Z 2026-01-25T14:00:20.843Z 2026-01-29T14:40:12.197Z
9252971 9252971 20260123084358_exgLk NZ004Z 2026-01-24T14:18:03.254Z 2026-01-29T14:53:45.368Z
9249975 9249975 20260123091907_JxNjb NZ004Z 2026-01-24T14:00:24.436Z 2026-01-29T14:44:45.780Z
9245968 9245968 20260122155038_mVonv NZ004Z 2026-01-23T14:04:10.382Z 2026-01-29T14:50:27.467Z
9245914 9245914 20260122152610_MViIV NZ004Z 2026-01-23T14:04:00.985Z 2026-01-29T14:50:22.266Z
9245890 9245890 20260122152005_tq0nX NZ004Z 2026-01-23T14:03:57.615Z 2026-01-29T14:50:21.012Z
9245827 9245827 20260122144829_EfIqW NZ004Z 2026-01-23T14:03:37.793Z 2026-01-29T14:50:15.598Z
9245776 9245776 20260122142300_01n37 NZ004Z 2026-01-23T14:03:27.849Z 2026-01-29T14:50:11.089Z
9245613 9245613 20260122132159_3uaaf NZ004Z 2026-01-23T14:02:37.418Z 2026-01-29T14:49:50.826Z
9245590 9245590 20260122131408_rZbIv NZ004Z 2026-01-23T14:02:29.876Z 2026-01-29T14:49:49.498Z
9211001 9211001 20260116143622_g784D NZ004Z 2026-01-17T14:03:46.040Z 2026-01-25T14:57:14.360Z
9196930 9196930 20260113094025_P44cX NZ004Z 2026-01-14T14:20:43.702Z 2026-01-21T15:06:08.522Z
9196883 9196883 20260113092640_Axrrt NZ004Z 2026-01-14T14:20:27.610Z 2026-01-21T15:06:03.367Z
9196735 9196735 20260113085246_UsvVS NZ004Z 2026-01-14T14:19:50.049Z 2026-01-21T15:05:37.381Z
9193084 9193084 20260112133527_OHYpg NZ004Z 2026-01-13T14:30:08.018Z 2026-01-20T15:26:58.779Z
9193071 9193071 20260112133347_ngRIv NZ004Z 2026-01-13T14:30:06.147Z 2026-01-20T15:26:58.176Z
9192994 9192994 20260112132426_8ezkS NZ004Z 2026-01-13T14:29:55.424Z 2026-01-20T15:26:53.928Z
9192858 9192858 20260112130945_GzLzW NZ004Z 2026-01-13T14:29:31.152Z 2026-01-20T15:26:37.222Z
9192757 9192757 20260112125729_hOmJa NZ004Z 2026-01-13T14:29:10.630Z 2026-01-20T15:26:31.914Z
9192755 9192755 20260112125725_2shvR NZ004Z 2026-01-13T14:29:10.170Z 2026-01-20T15:26:31.802Z
9192350 9192350 20260112122538_Gsv2x NZ004Z 2026-01-13T14:28:08.140Z 2026-01-20T15:26:19.443Z
9192058 9192058 20260112120339_vJvTe NZ004Z 2026-01-13T14:27:18.120Z 2026-01-20T15:25:57.916Z
9191445 9191445 20260112110738_Rjlr5 NZ004Z 2026-01-13T14:25:24.415Z 2026-01-20T15:25:25.598Z
9190871 9190871 20260112100836_PHBqz NZ004Z 2026-01-13T14:23:42.683Z 2026-01-20T15:24:52.283Z
9190739 9190739 20260112094847_VNHyC NZ004Z 2026-01-13T14:23:19.673Z 2026-01-20T15:24:46.104Z
9190351 9190351 20260112085138_9wxg6 NZ004Z 2026-01-13T14:21:54.567Z 2026-01-20T15:24:19.009Z
9187204 9187204 20260111153951_TPOQb NZ004Z 2026-01-13T14:06:08.098Z 2026-01-20T15:20:09.034Z
9187109 9187109 20260111151409_W5hnZ NZ004Z 2026-01-13T14:05:29.713Z 2026-01-20T15:20:00.283Z
9187042 9187042 20260111144919_rvTVm NZ004Z 2026-01-13T14:05:05.613Z 2026-01-20T15:19:54.785Z
9187023 9187023 20260111144631_fb2OK NZ004Z 2026-01-13T14:04:58.249Z 2026-01-20T15:19:53.410Z
9186973 9186973 20260111143358_vsU5m NZ004Z 2026-01-13T14:04:36.208Z 2026-01-20T15:19:39.301Z
9186869 9186869 20260112160706_y37A7 NZ004Z 2026-01-13T14:03:48.004Z 2026-01-21T15:03:08.465Z
9186867 9186867 20260112160310_By9GG NZ004Z 2026-01-13T14:03:47.275Z 2026-01-13T14:03:47.275Z
9186865 9186865 20260112155837_KuTes NZ004Z 2026-01-13T14:03:46.556Z 2026-01-21T15:03:07.911Z
9186421 9186421 20260112143408_UYt2h NZ004Z 2026-01-13T14:01:52.150Z 2026-01-21T15:02:30.549Z
9186384 9186384 20260112142931_EKbgj NZ004Z 2026-01-13T14:01:43.786Z 2026-01-21T15:02:27.860Z
9186300 9186300 20260112141213_CgERg NZ004Z 2026-01-13T14:01:17.736Z 2026-01-21T15:02:18.627Z
9186211 9186211 20260112135937_j8cjQ NZ004Z 2026-01-13T14:00:49.922Z 2026-01-21T15:02:13.153Z
9186155 9186155 20260112135401_jcTNX NZ004Z 2026-01-13T14:00:33.308Z 2026-01-21T15:02:12.528Z
9186108 9186108 20260112134916_uCFiv NZ004Z 2026-01-13T14:00:18.642Z 2026-01-21T15:02:12.053Z
9186104 9186104 20260112134851_S2xb4 NZ004Z 2026-01-13T14:00:16.485Z 2026-01-21T15:02:12.026Z
9185981 9185981 20260111140625_RaS91 NZ004Z 2026-01-12T14:26:31.706Z 2026-01-19T15:22:22.108Z
9185975 9185975 20260111140405_DuuhU NZ004Z 2026-01-12T14:26:26.375Z 2026-01-19T15:22:18.413Z
9185937 9185937 20260111135728_83227 NZ004Z 2026-01-12T14:26:19.998Z 2026-01-19T15:22:07.183Z
9185849 9185849 20260111132548_aOfDb NZ004Z 2026-01-12T14:26:07.830Z 2026-01-19T15:21:57.160Z
9185838 9185838 20260111132405_DWKxH NZ004Z 2026-01-12T14:26:06.364Z 2026-01-19T15:21:56.585Z
9185816 9185816 20260111131844_N0M4J NZ004Z 2026-01-12T14:26:03.319Z 2026-01-19T15:21:54.081Z
9185800 9185800 20260111131357_BWDJF NZ004Z 2026-01-12T14:26:01.790Z 2026-01-19T15:21:52.990Z
9185795 9185795 20260111131208_vEFx5 NZ004Z 2026-01-12T14:26:01.163Z 2026-01-19T15:21:52.386Z
9185534 9185534 20260111114224_2m1dU NZ004Z 2026-01-12T14:25:08.442Z 2026-01-19T15:21:00.687Z
9185519 9185519 20260111112911_DjR8O NZ004Z 2026-01-12T14:25:06.485Z 2026-01-19T15:20:58.325Z
9183971 9183971 20260111103146_GkOfG NZ004Z 2026-01-12T14:19:19.568Z 2026-01-19T15:20:18.341Z
9183914 9183914 20260111102748_6w83h NZ004Z 2026-01-12T14:19:12.381Z 2026-01-12T14:19:12.381Z
9183817 9183817 20260111101857_dOJS7 NZ004Z 2026-01-12T14:18:53.904Z 2026-01-19T15:20:12.539Z
9183394 9183394 20260111092404_1EqSq NZ004Z 2026-01-12T14:17:41.676Z 2026-01-19T15:19:37.876Z
9183356 9183356 20260111092139_9GBXP NZ004Z 2026-01-12T14:17:32.838Z 2026-01-19T15:19:36.755Z
9178937 9178937 20260110143000_3TBuz NZ004Z 2026-01-11T14:16:05.865Z 2026-01-18T15:11:25.111Z
9178797 9178797 20260110141140_0XLGF NZ004Z 2026-01-11T14:15:44.515Z 2026-01-18T15:11:17.443Z
9178717 9178717 20260110134918_Reajm NZ004Z 2026-01-11T14:15:35.800Z 2026-01-18T15:11:12.729Z
9178607 9178607 20260110133219_qxuYg NZ004Z 2026-01-11T14:15:18.690Z 2026-01-18T15:11:08.280Z
9178028 9178028 20260110120031_Q69a1 NZ004Z 2026-01-11T14:13:48.794Z 2026-01-18T15:10:22.128Z
9177953 9177953 20260110115016_tt2m3 NZ004Z 2026-01-11T14:13:38.478Z 2026-01-18T15:10:16.231Z
9177657 9177657 20260110104707_gzIFE NZ004Z 2026-01-11T14:12:35.635Z 2026-01-18T15:09:54.029Z
9177537 9177537 20260110101308_F4ZuT NZ004Z 2026-01-11T14:12:15.591Z 2026-01-18T15:09:47.334Z
9177319 9177319 20260110091844_qKY9W NZ004Z 2026-01-11T14:11:37.190Z 2026-01-18T15:09:37.161Z
9174252 9174252 20260110155632_tTmZw NZ004Z 2026-01-11T14:01:55.519Z 2026-01-19T15:14:45.512Z
9173807 9173807 20260110144805_FJy3I NZ004Z 2026-01-11T14:00:20.693Z 2026-01-19T15:14:12.091Z
9173591 9173591 20260109145743_NqNcv NZ004Z 2026-01-10T14:18:12.344Z 2026-01-17T15:26:53.760Z
9173331 9173331 20260109134051_CZUG3 NZ004Z 2026-01-10T14:17:06.244Z 2026-01-17T15:26:39.272Z
9173286 9173286 20260109133144_xWsih NZ004Z 2026-01-10T14:16:58.625Z 2026-01-17T15:26:36.497Z
9173204 9173204 20260109132239_rNZ00 NZ004Z 2026-01-10T14:16:43.342Z 2026-01-17T15:26:23.387Z
9173161 9173161 20260109131159_vBm27 NZ004Z 2026-01-10T14:16:28.215Z 2026-01-17T15:26:21.537Z
9173151 9173151 20260109130726_uehet NZ004Z 2026-01-10T14:16:25.331Z 2026-01-17T15:26:20.977Z
9173144 9173144 20260109130533_hQaJj NZ004Z 2026-01-10T14:16:21.025Z 2026-01-17T15:26:18.899Z
9173117 9173117 20260109130135_JdaWY NZ004Z 2026-01-10T14:16:13.951Z 2026-01-17T15:26:16.989Z
9173025 9173025 20260109124459_5ZqGX NZ004Z 2026-01-10T14:15:53.660Z 2026-01-17T15:26:12.185Z
9172558 9172558 20260109110643_HIthe NZ004Z 2026-01-10T14:13:53.862Z 2026-01-17T15:25:41.205Z
9172423 9172423 20260109103847_XhkdL NZ004Z 2026-01-10T14:13:17.859Z 2026-01-17T15:25:32.701Z
9172280 9172280 20260109094728_iGfSX NZ004Z 2026-01-10T14:12:34.797Z 2026-01-17T15:25:16.467Z
9170604 9170604 20260109155951_QMg8k NZ004Z 2026-01-10T14:01:38.192Z 2026-01-18T15:06:39.296Z
9170555 9170555 20260109154533_Q0WM9 NZ004Z 2026-01-10T14:01:18.619Z 2026-01-18T15:06:28.303Z
9170463 9170463 20260109152854_6ctbT NZ004Z 2026-01-10T14:00:42.381Z 2026-01-18T15:06:22.783Z

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