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

510 rows where station_code = "NZ007F" 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
9627517 9627517 20260408181058_GkgWr NZ007F 2026-04-09T12:11:14.173Z 2026-04-10T12:14:22.557Z
9627469 9627469 20260408175344_DDEyy NZ007F 2026-04-09T12:11:07.438Z 2026-04-10T12:14:22.549Z
9627439 9627439 20260408173744_Yb2hs NZ007F 2026-04-09T12:11:03.309Z 2026-04-10T12:14:22.544Z
9627408 9627408 20260408172605_4Nn3J NZ007F 2026-04-09T12:10:51.604Z 2026-04-10T12:14:22.538Z
9627295 9627295 20260408170127_493cY NZ007F 2026-04-09T12:10:34.192Z 2026-04-10T12:14:22.517Z
9627225 9627225 20260408164621_UHSul NZ007F 2026-04-09T12:10:20.912Z 2026-04-10T12:14:22.505Z
9627210 9627210 20260408164303_EqSyC NZ007F 2026-04-09T12:10:19.348Z 2026-04-10T12:14:22.502Z
9627181 9627181 20260408163714_2korx NZ007F 2026-04-09T12:10:14.571Z 2026-04-10T12:14:22.495Z
9626603 9626603 20260408142333_OvmFx NZ007F 2026-04-09T12:08:45.422Z 2026-04-10T12:14:22.381Z
9626349 9626349 20260408134518_5I4ut NZ007F 2026-04-09T12:08:11.193Z 2026-04-10T12:14:22.338Z
9626327 9626327 20260408134211_MM8ZF NZ007F 2026-04-09T12:08:00.487Z 2026-04-10T12:14:22.333Z
9626245 9626245 20260408133004_pLbxY NZ007F 2026-04-09T12:07:49.237Z 2026-04-10T12:14:22.322Z
9626020 9626020 20260408125302_jhkCp NZ007F 2026-04-09T12:07:18.774Z 2026-04-10T12:14:22.281Z
9625884 9625884 20260408122140_Td8Wi NZ007F 2026-04-09T12:07:02.866Z 2026-04-10T12:14:22.259Z
9625635 9625635 20260408113027_MNEOJ NZ007F 2026-04-09T12:06:10.150Z 2026-04-10T12:14:22.216Z
9625113 9625113 20260408093920_5EJRJ NZ007F 2026-04-09T12:04:17.779Z 2026-04-10T12:14:21.857Z
9625096 9625096 20260408093510_XI7Om NZ007F 2026-04-09T12:04:11.463Z 2026-04-10T12:14:21.853Z
9624840 9624840 20260408084318_PnCvS NZ007F 2026-04-09T12:03:07.187Z 2026-04-10T12:14:21.796Z
9624717 9624717 20260408081428_Gd6rX NZ007F 2026-04-09T12:02:36.870Z 2026-04-10T12:14:21.442Z
9613230 9613230 20260405101433_2EHxM NZ007F 2026-04-07T12:05:11.917Z 2026-04-10T12:26:25.273Z
9612334 9612334 20260406095631_6S3Eo NZ007F 2026-04-07T12:01:31.959Z 2026-04-10T12:22:05.193Z
9610302 9610302 20260405155913_3RCOD NZ007F 2026-04-06T12:06:55.065Z 2026-04-10T12:27:03.437Z
9610189 9610189 20260405142053_LH0Ys NZ007F 2026-04-06T12:06:16.696Z 2026-04-10T12:26:59.527Z
9605221 9605221 20260403080310_KUrLw NZ007F 2026-04-04T12:01:15.736Z 2026-04-10T12:31:31.134Z
9603248 9603248 20260402090308_Lk247 NZ007F 2026-04-03T12:02:17.323Z 2026-04-10T12:33:58.652Z
9601994 9601994 20260401174641_6fXeb NZ007F 2026-04-02T12:04:26.959Z 2026-04-05T12:17:45.517Z
9599711 9599711 20260331162727_3Bh97 NZ007F 2026-04-01T12:04:34.732Z 2026-04-09T12:47:16.212Z
9599597 9599597 20260331155911_CEH78 NZ007F 2026-04-01T12:04:11.836Z 2026-04-09T12:47:04.058Z
9599537 9599537 20260331153513_w0hy0 NZ007F 2026-04-01T12:03:58.956Z 2026-04-09T12:46:55.255Z
9599478 9599478 20260331145609_fmea9 NZ007F 2026-04-01T12:03:44.986Z 2026-04-09T12:46:48.296Z
9599459 9599459 20260331144603_rG5JQ NZ007F 2026-04-01T12:03:41.098Z 2026-04-09T12:46:47.943Z
9599422 9599422 20260331143026_NXiQt NZ007F 2026-04-01T12:03:32.034Z 2026-04-09T12:46:47.282Z
9598093 9598093 20260330175039_6KDNF NZ007F 2026-03-31T12:07:36.400Z 2026-04-08T12:44:25.529Z
9598082 9598082 20260330174544_8Rym2 NZ007F 2026-03-31T12:07:34.472Z 2026-04-08T12:44:25.107Z
9598053 9598053 20260330173535_EDIOf NZ007F 2026-03-31T12:07:30.718Z 2026-04-08T12:44:24.335Z
9597442 9597442 20260330161810_tMtI3 NZ007F 2026-03-31T12:06:23.901Z 2026-04-08T12:43:43.098Z
9597387 9597387 20260330161316_p9Yu2 NZ007F 2026-03-31T12:06:17.924Z 2026-04-08T12:43:41.843Z
9597140 9597140 20260330152306_vRf3u NZ007F 2026-03-31T12:05:43.529Z 2026-04-08T12:43:33.716Z
9596743 9596743 20260330135226_Mehu2 NZ007F 2026-03-31T12:04:52.306Z 2026-04-08T12:43:23.431Z
9596593 9596593 20260330131726_8tHPz NZ007F 2026-03-31T12:04:33.251Z 2026-04-08T12:43:20.003Z
9596545 9596545 20260330131045_UDytS NZ007F 2026-03-31T12:04:29.671Z 2026-04-08T12:43:19.381Z
9596011 9596011 20260330103900_RilRy NZ007F 2026-03-31T12:03:07.743Z 2026-04-08T12:42:38.424Z
9595868 9595868 20260330093233_7AGCo NZ007F 2026-03-31T12:02:43.623Z 2026-04-08T12:42:34.861Z
9595861 9595861 20260330092932_VvmCM NZ007F 2026-03-31T12:02:42.718Z 2026-03-31T12:02:42.718Z
9595776 9595776 20260330083505_z0Nq1 NZ007F 2026-03-31T12:02:27.532Z 2026-04-08T12:42:31.825Z
9595720 9595720 20260330081245_RFZDR NZ007F 2026-03-31T12:02:17.523Z 2026-04-08T12:42:30.351Z
9595708 9595708 20260330081118_Ua08f NZ007F 2026-03-31T12:02:15.887Z 2026-03-31T12:02:15.887Z
9593762 9593762 20260329150143_smJRz NZ007F 2026-03-30T12:05:02.714Z 2026-04-07T12:27:35.154Z
9593731 9593731 20260329142657_9JxhV NZ007F 2026-03-30T12:04:55.863Z 2026-04-07T12:27:34.084Z
9591126 9591126 20260328133350_pdlzY NZ007F 2026-03-29T12:03:52.946Z 2026-04-06T12:39:01.987Z
9591103 9591103 20260328131733_YW8lL NZ007F 2026-03-29T12:03:50.500Z 2026-04-06T12:39:00.683Z
9579128 9579128 20260324100614_S2UDF NZ007F 2026-03-26T12:11:01.494Z 2026-04-02T12:35:37.151Z
9578793 9578793 20260325143713_RZAPd NZ007F 2026-03-26T12:08:32.707Z 2026-04-03T12:38:32.800Z
9578743 9578743 20260325135843_nlu2H NZ007F 2026-03-26T12:08:22.601Z 2026-04-03T12:38:29.045Z
9578718 9578718 20260325134747_bihBo NZ007F 2026-03-26T12:08:19.518Z 2026-04-03T12:38:18.239Z
9578653 9578653 20260325130623_rUh2V NZ007F 2026-03-26T12:08:10.377Z 2026-04-03T12:38:15.347Z
9574952 9574952 20260323174800_gEvrG NZ007F 2026-03-25T12:19:56.233Z 2026-03-31T12:28:45.040Z
9574874 9574874 20260323173126_NEK1R NZ007F 2026-03-25T12:19:48.603Z 2026-03-31T12:28:43.656Z
9574848 9574848 20260323172727_WMHpQ NZ007F 2026-03-25T12:19:46.056Z 2026-03-31T12:28:43.168Z
9574562 9574562 20260324174507_c0yY0 NZ007F 2026-03-25T12:10:54.650Z 2026-04-02T12:37:02.756Z
9574515 9574515 20260324172919_5UQXz NZ007F 2026-03-25T12:10:48.312Z 2026-03-25T12:10:48.312Z
9574463 9574463 20260324170943_AAzrQ NZ007F 2026-03-25T12:10:40.721Z 2026-04-02T12:36:59.691Z
9574359 9574359 20260324163307_jZKsQ NZ007F 2026-03-25T12:10:23.492Z 2026-04-02T12:36:48.762Z
9574342 9574342 20260324163151_dKqWD NZ007F 2026-03-25T12:10:22.107Z 2026-04-02T12:36:48.216Z
9574157 9574157 20260324153025_3l2bx NZ007F 2026-03-25T12:09:49.829Z 2026-04-02T12:36:40.632Z
9574136 9574136 20260324152502_uLo2I NZ007F 2026-03-25T12:09:44.798Z 2026-04-02T12:36:39.631Z
9574035 9574035 20260324145723_HQYZL NZ007F 2026-03-25T12:09:28.589Z 2026-04-02T12:36:35.403Z
9574022 9574022 20260324145155_JbKhA NZ007F 2026-03-25T12:09:27.602Z 2026-04-02T12:36:34.730Z
9573991 9573991 20260324144426_si9Ow NZ007F 2026-03-25T12:09:21.259Z 2026-04-02T12:36:33.725Z
9573942 9573942 20260324143043_v9jQH NZ007F 2026-03-25T12:09:14.477Z 2026-04-02T12:36:32.326Z
9573928 9573928 20260324142636_S6Lhq NZ007F 2026-03-25T12:09:12.524Z 2026-03-25T12:09:12.524Z
9573080 9573080 20260324111540_wqkCA NZ007F 2026-03-25T12:07:08.131Z 2026-04-02T12:35:54.811Z
9573006 9573006 20260324110549_cABrp NZ007F 2026-03-25T12:06:59.923Z 2026-04-02T12:35:52.696Z
9572901 9572901 20260324104802_wz3j4 NZ007F 2026-03-25T12:06:40.051Z 2026-04-02T12:35:42.989Z
9572690 9572690 20260324094905_lgvKT NZ007F 2026-03-25T12:05:59.309Z 2026-04-02T12:35:34.321Z
9572453 9572453 20260324090433_83G6x NZ007F 2026-03-25T12:05:12.597Z 2026-04-02T12:35:25.278Z
9569500 9569500 20260322155633_q97Jv NZ007F 2026-03-24T12:21:14.350Z 2026-03-30T12:30:05.973Z
9569482 9569482 20260322155240_Nura7 NZ007F 2026-03-24T12:21:08.176Z 2026-03-30T12:30:05.306Z
9569394 9569394 20260322152130_AN3bd NZ007F 2026-03-24T12:20:51.710Z 2026-03-30T12:29:52.612Z
9569364 9569364 20260322150615_JvI2R NZ007F 2026-03-24T12:20:45.333Z 2026-03-30T12:29:50.166Z
9569344 9569344 20260322150009_68UFe NZ007F 2026-03-24T12:20:38.148Z 2026-03-30T12:29:48.611Z
9569341 9569341 20260322145934_2mVBn NZ007F 2026-03-24T12:20:37.621Z 2026-03-30T12:29:48.455Z
9569239 9569239 20260322142107_3qr2I NZ007F 2026-03-24T12:20:15.825Z 2026-03-30T12:29:40.676Z
9569208 9569208 20260322140900_uqqJB NZ007F 2026-03-24T12:20:06.826Z 2026-03-30T12:29:38.914Z
9569009 9569009 20260322122214_5w5zD NZ007F 2026-03-24T12:19:22.529Z 2026-03-30T12:29:17.061Z
9568989 9568989 20260322120949_u4CPc NZ007F 2026-03-24T12:19:18.254Z 2026-03-30T12:29:14.504Z
9568984 9568984 20260322120739_vhWBR NZ007F 2026-03-24T12:19:17.612Z 2026-03-30T12:29:14.261Z
9568976 9568976 20260322120310_c2TRW NZ007F 2026-03-24T12:19:16.607Z 2026-03-30T12:29:13.820Z
9568964 9568964 20260322115817_373Aj NZ007F 2026-03-24T12:19:13.955Z 2026-03-30T12:29:13.097Z
9568956 9568956 20260322115238_K9h2I NZ007F 2026-03-24T12:19:08.960Z 2026-03-30T12:29:12.275Z
9568951 9568951 20260322114154_j2Bdm NZ007F 2026-03-24T12:19:06.763Z 2026-03-30T12:29:11.129Z
9568914 9568914 20260322111823_MSjlJ NZ007F 2026-03-24T12:18:56.540Z 2026-03-30T12:29:07.569Z
9568816 9568816 20260322091625_Lq937 NZ007F 2026-03-24T12:18:16.206Z 2026-03-30T12:28:44.837Z
9568797 9568797 20260322083136_oOnDJ NZ007F 2026-03-24T12:18:01.035Z 2026-03-30T12:28:38.134Z
9568727 9568727 20260323171607_itau3 NZ007F 2026-03-24T12:15:38.221Z 2026-03-31T12:28:41.028Z
9568663 9568663 20260323170948_ggJAz NZ007F 2026-03-24T12:15:28.728Z 2026-03-31T12:28:39.825Z
9568599 9568599 20260323170046_VDNng NZ007F 2026-03-24T12:15:21.170Z 2026-03-31T12:28:38.302Z
9568441 9568441 20260323164438_ybGB0 NZ007F 2026-03-24T12:15:07.542Z 2026-03-24T12:24:25.458Z
9568438 9568438 20260323164421_lse3Q NZ007F 2026-03-24T12:15:07.279Z 2026-03-24T12:24:25.457Z
9568300 9568300 20260323162757_mTNGq NZ007F 2026-03-24T12:14:51.175Z 2026-03-31T12:28:26.965Z

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