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

8,080 rows where station_code = "NZ002H" 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
8394006 8394006 20251107104007_zvXAX NZ002H 2025-11-08T14:22:34.808Z 2025-11-11T14:50:23.653Z
8393817 8393817 20251107100528_rlL9f NZ002H 2025-11-08T14:21:58.155Z 2025-11-11T14:50:19.861Z
8340579 8340579 20251031120812_DfY6K NZ002H 2025-11-02T14:35:30.410Z 2025-11-08T15:18:13.955Z
8340343 8340343 20251031114628_P8RS3 NZ002H 2025-11-02T14:35:21.639Z 2025-11-08T15:18:05.898Z
8340109 8340109 20251031112039_Bad1L NZ002H 2025-11-02T14:35:12.729Z 2025-11-08T15:17:54.771Z
8339124 8339124 20251031095835_cwpUW NZ002H 2025-11-02T14:33:30.022Z 2025-11-08T15:17:29.024Z
8338430 8338430 20251031084158_ocknp NZ002H 2025-11-02T14:32:37.521Z 2025-11-08T15:16:44.525Z
8338351 8338351 20251031083459_bNnHr NZ002H 2025-11-02T14:32:34.475Z 2025-11-08T15:16:41.385Z
8338302 8338302 20251031083105_eG8Yj NZ002H 2025-11-02T14:32:26.245Z 2025-11-08T15:16:39.520Z
8338257 8338257 20251031082726_Nuq6p NZ002H 2025-11-02T14:32:03.173Z 2025-11-08T15:16:37.934Z
8329702 8329702 20251031160323_UllBF NZ002H 2025-11-02T14:03:36.416Z 2025-11-09T14:58:12.980Z
8329641 8329641 20251031155659_Ftcrl NZ002H 2025-11-02T14:03:28.237Z 2025-11-09T14:58:12.347Z
8329616 8329616 20251031155107_gnK51 NZ002H 2025-11-02T14:03:25.418Z 2025-11-09T14:58:12.089Z
8329551 8329551 20251031153822_Sq5HJ NZ002H 2025-11-02T14:03:15.804Z 2025-11-09T14:58:11.127Z
8329488 8329488 20251031153155_szvVQ NZ002H 2025-11-02T14:02:57.364Z 2025-11-09T14:58:10.567Z
8329437 8329437 20251031152713_3d2MJ NZ002H 2025-11-02T14:02:51.304Z 2025-11-09T14:58:10.058Z
8329405 8329405 20251031152237_7snX3 NZ002H 2025-11-02T14:02:47.773Z 2025-11-09T14:58:09.771Z
8329257 8329257 20251031145614_383kz NZ002H 2025-11-02T14:02:18.082Z 2025-11-09T14:58:06.688Z
8329110 8329110 20251031143905_ySOHS NZ002H 2025-11-02T14:01:58.123Z 2025-11-09T14:58:04.942Z
8329096 8329096 20251031143610_IGGf2 NZ002H 2025-11-02T14:01:52.206Z 2025-11-09T14:58:04.774Z
8329084 8329084 20251031143440_Zi1vl NZ002H 2025-11-02T14:01:49.439Z 2025-11-09T14:58:04.662Z
8328907 8328907 20251031141332_vqBET NZ002H 2025-11-02T14:01:21.605Z 2025-11-09T14:58:02.680Z
8328871 8328871 20251031140318_VqcL4 NZ002H 2025-11-02T14:01:16.617Z 2025-11-09T14:58:02.280Z
8328788 8328788 20251031134914_kHPfb NZ002H 2025-11-02T14:01:01.164Z 2025-11-09T14:58:01.584Z
8295832 8295832 20251028121631_qWRxF NZ002H 2025-10-30T12:43:12.172Z 2025-11-05T15:25:27.101Z
8294665 8294665 20251028105114_SKEFO NZ002H 2025-10-30T12:41:13.466Z 2025-11-05T15:24:44.281Z
8293124 8293124 20251028091813_7LNND NZ002H 2025-10-30T12:38:48.157Z 2025-11-05T15:23:46.604Z
8292974 8292974 20251028090503_bH4al NZ002H 2025-10-30T12:38:36.596Z 2025-11-05T15:23:41.403Z
8292669 8292669 20251028084344_1iC0C NZ002H 2025-10-30T12:38:22.377Z 2025-11-05T15:23:33.399Z
8286941 8286941 20251028151940_73H25 NZ002H 2025-10-30T12:05:30.727Z 2025-11-06T15:10:30.086Z
8286727 8286727 20251028150538_Xsgoh NZ002H 2025-10-30T12:04:45.109Z 2025-11-06T15:10:27.732Z
8286700 8286700 20251028150433_ha7r2 NZ002H 2025-10-30T12:04:42.114Z 2025-11-06T15:10:26.545Z
8286532 8286532 20251028144803_0NuHX NZ002H 2025-10-30T12:04:08.188Z 2025-11-06T15:10:25.268Z
8286498 8286498 20251028144605_L6z0r NZ002H 2025-10-30T12:03:52.983Z 2025-11-06T15:10:24.966Z
8286188 8286188 20251028141928_UMkk4 NZ002H 2025-10-30T12:03:00.171Z 2025-11-06T15:10:22.303Z
8286021 8286021 20251028140755_gpu2D NZ002H 2025-10-30T12:02:29.848Z 2025-11-06T15:10:20.800Z
8285946 8285946 20251028135925_QGtJA NZ002H 2025-10-30T12:02:12.649Z 2025-11-06T15:10:19.274Z
8285775 8285775 20251028134647_N2VGz NZ002H 2025-10-30T12:01:38.249Z 2025-11-06T15:10:15.238Z
8285655 8285655 20251028133358_Q4KPz NZ002H 2025-10-30T12:01:12.331Z 2025-11-06T15:10:13.814Z
8285488 8285488 20251028131610_BrfFS NZ002H 2025-10-30T12:00:44.519Z 2025-11-06T15:10:11.871Z
8248157 8248157 20251026131110_aLQs1 NZ002H 2025-10-28T12:00:43.379Z 2025-11-04T15:38:42.344Z
8247315 8247315 20251025114026_IGrAe NZ002H 2025-10-27T12:42:28.485Z 2025-11-02T15:05:52.742Z
8245552 8245552 20251025092135_EuNZY NZ002H 2025-10-27T12:39:59.200Z 2025-11-02T15:05:47.255Z
8244866 8244866 20251025083619_mhte0 NZ002H 2025-10-27T12:38:32.569Z 2025-11-02T15:05:44.788Z
8244441 8244441 20251025080037_Mw4Ta NZ002H 2025-10-27T12:37:51.443Z 2025-11-02T15:05:43.311Z
8230960 8230960 20251025161727_X0iKD NZ002H 2025-10-27T12:06:09.471Z 2025-11-03T15:15:29.882Z
8230698 8230698 20251025155214_ZoU28 NZ002H 2025-10-27T12:05:28.589Z 2025-11-03T15:15:22.383Z
8230577 8230577 20251025154356_gHOYP NZ002H 2025-10-27T12:05:04.877Z 2025-11-03T15:15:21.601Z
8230530 8230530 20251025153724_sJXsF NZ002H 2025-10-27T12:04:56.303Z 2025-11-03T15:15:21.064Z
8230448 8230448 20251025152708_3BQY7 NZ002H 2025-10-27T12:04:34.123Z 2025-11-03T15:15:20.703Z
8230370 8230370 20251025152108_Fth4d NZ002H 2025-10-27T12:04:27.115Z 2025-11-03T15:15:20.461Z
8230317 8230317 20251025151617_DOmBX NZ002H 2025-10-27T12:04:21.573Z 2025-11-03T15:15:20.221Z
8230238 8230238 20251025150447_Aue2G NZ002H 2025-10-27T12:04:00.907Z 2025-11-03T15:15:18.800Z
8229525 8229525 20251025133219_XVwLt NZ002H 2025-10-27T12:01:26.059Z 2025-11-03T15:15:04.369Z
8229480 8229480 20251025132750_sneSB NZ002H 2025-10-27T12:01:20.531Z 2025-11-03T15:15:03.633Z
8229382 8229382 20251025131022_W4XHk NZ002H 2025-10-27T12:01:07.325Z 2025-11-03T15:15:01.214Z
8229216 8229216 20251025125007_pAJyh NZ002H 2025-10-27T12:00:32.752Z 2025-11-03T15:14:59.215Z
8229206 8229206 20251025124841_mcazH NZ002H 2025-10-27T12:00:31.819Z 2025-11-03T15:14:59.111Z
8229195 8229195 20251025124839_CNNo8 NZ002H 2025-10-27T12:00:30.486Z 2025-11-03T15:14:59.063Z
8229098 8229098 20251025123653_oRAZz NZ002H 2025-10-27T12:00:09.488Z 2025-11-03T15:14:57.996Z
8229091 8229091 20251025123652_Pmxu9 NZ002H 2025-10-27T12:00:09.109Z 2025-11-03T15:14:57.994Z
8206307 8206307 20251024142923_G0gGv NZ002H 2025-10-26T12:04:10.262Z 2025-11-02T15:04:53.154Z
8206267 8206267 20251024142344_ZnKJi NZ002H 2025-10-26T12:04:01.206Z 2025-11-02T15:04:53.004Z
8206229 8206229 20251024142044_4Y25u NZ002H 2025-10-26T12:03:48.480Z 2025-11-02T15:04:52.864Z
8206003 8206003 20251024135954_gwvI1 NZ002H 2025-10-26T12:03:01.276Z 2025-11-02T15:04:52.121Z
8205804 8205804 20251024133101_6ceX3 NZ002H 2025-10-26T12:02:14.168Z 2025-11-02T15:04:50.849Z
8205735 8205735 20251024132434_SHExz NZ002H 2025-10-26T12:01:49.383Z 2025-11-02T15:04:50.527Z
8205475 8205475 20251024124648_zlT3i NZ002H 2025-10-26T12:00:46.727Z 2025-11-02T15:04:46.963Z
8197208 8197208 20251022104153_n37Hg NZ002H 2025-10-24T12:35:37.410Z 2025-10-30T13:13:52.851Z
8196223 8196223 20251022090223_RMyjO NZ002H 2025-10-24T12:33:43.422Z 2025-10-30T13:13:46.396Z
8188168 8188168 20251022152626_ZLAiU NZ002H 2025-10-24T12:03:04.322Z 2025-10-31T13:07:59.855Z
8188166 8188166 20251022152544_lyGnx NZ002H 2025-10-24T12:03:03.261Z 2025-10-31T13:07:59.851Z
8188155 8188155 20251022152326_1Opj8 NZ002H 2025-10-24T12:03:01.165Z 2025-10-31T13:07:59.801Z
8188079 8188079 20251022150929_CqW02 NZ002H 2025-10-24T12:02:50.096Z 2025-10-31T13:07:59.381Z
8160348 8160348 20251020153947_ehAaN NZ002H 2025-10-22T12:05:45.234Z 2025-10-29T13:06:47.848Z
8160296 8160296 20251020153253_WK0wL NZ002H 2025-10-22T12:05:33.559Z 2025-10-29T13:06:45.440Z
8160142 8160142 20251020150914_hbnnL NZ002H 2025-10-22T12:04:57.578Z 2025-10-29T13:06:43.038Z
8160111 8160111 20251020150625_H3iUy NZ002H 2025-10-22T12:04:50.871Z 2025-10-29T13:06:42.804Z
8154328 8154328 20251019161359_Tadxb NZ002H 2025-10-21T12:08:55.556Z 2025-10-28T13:07:26.546Z
8154256 8154256 20251019160950_BI6EN NZ002H 2025-10-21T12:08:48.204Z 2025-10-28T13:07:26.167Z
8154235 8154235 20251019160855_DILB2 NZ002H 2025-10-21T12:08:45.790Z 2025-10-28T13:07:26.055Z
8154195 8154195 20251019160652_9K2pd NZ002H 2025-10-21T12:08:34.431Z 2025-10-28T13:07:25.839Z
8154042 8154042 20251019155707_c6dA8 NZ002H 2025-10-21T12:08:15.295Z 2025-10-28T13:07:23.715Z
8153870 8153870 20251019154614_LtlBZ NZ002H 2025-10-21T12:07:47.438Z 2025-10-28T13:07:20.693Z
8153816 8153816 20251019154130_JSc21 NZ002H 2025-10-21T12:07:40.428Z 2025-10-28T13:07:20.534Z
8153722 8153722 20251019153406_JXFRe NZ002H 2025-10-21T12:07:21.798Z 2025-10-28T13:07:19.503Z
8153578 8153578 20251019152157_A29NH NZ002H 2025-10-21T12:07:01.547Z 2025-10-28T13:07:18.253Z
8153526 8153526 20251019151859_T4us4 NZ002H 2025-10-21T12:06:47.705Z 2025-10-28T13:07:17.682Z
8151041 8151041 20251018081015_r7ubq NZ002H 2025-10-20T12:40:25.444Z 2025-10-26T13:16:14.790Z
8139215 8139215 20251017110113_saEr1 NZ002H 2025-10-19T12:33:06.696Z 2025-10-25T13:31:25.653Z
8130575 8130575 20251017162032_S3XhU NZ002H 2025-10-19T12:04:56.332Z 2025-10-26T13:14:52.881Z
8130245 8130245 20251017153538_2go3g NZ002H 2025-10-19T12:04:13.876Z 2025-10-26T13:14:49.328Z
8130235 8130235 20251017153538_Aj3qx NZ002H 2025-10-19T12:04:13.767Z 2025-10-26T13:14:49.209Z
8130069 8130069 20251017150651_gS4zE NZ002H 2025-10-19T12:04:01.720Z 2025-10-26T13:14:44.857Z
8129867 8129867 20251017144832_LIyJo NZ002H 2025-10-19T12:03:33.233Z 2025-10-26T13:14:42.423Z
8129712 8129712 20251017142917_yYoh3 NZ002H 2025-10-19T12:03:05.541Z 2025-10-26T13:14:40.861Z
8129680 8129680 20251017142558_lKhNU NZ002H 2025-10-19T12:03:01.967Z 2025-10-26T13:14:40.782Z
8129637 8129637 20251017142225_VPTD1 NZ002H 2025-10-19T12:02:58.961Z 2025-10-26T13:14:40.661Z
8129467 8129467 20251017135047_yc94s NZ002H 2025-10-19T12:02:45.333Z 2025-10-26T13:14:37.920Z
8129383 8129383 20251017133723_hRCZ9 NZ002H 2025-10-19T12:02:30.676Z 2025-10-26T13:14:37.421Z

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