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

147 rows where station_code = "NZ006P" 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
9611880 9611880 20260331112542_EWH5o NZ006P 2026-04-06T12:27:23.942Z 2026-04-09T12:46:40.866Z
9611856 9611856 20260402083532_aLcPL NZ006P 2026-04-06T12:21:42.670Z 2026-04-09T12:43:22.351Z
9610377 9610377 20260405173240_OEVWb NZ006P 2026-04-06T12:07:26.242Z 2026-04-09T12:36:46.630Z
9610369 9610369 20260405172047_zztRa NZ006P 2026-04-06T12:07:23.048Z 2026-04-09T12:36:46.086Z
9574831 9574831 20260323172441_WXQu3 NZ006P 2026-03-25T12:19:44.478Z 2026-03-31T12:28:42.793Z
9569202 9569202 20260322140419_3YNN2 NZ006P 2026-03-24T12:20:05.466Z 2026-03-30T12:29:38.337Z
9566889 9566889 20260323142338_ZoE9r NZ006P 2026-03-24T12:12:39.800Z 2026-03-31T12:28:05.734Z
9566617 9566617 20260323135717_X7W42 NZ006P 2026-03-24T12:12:12.725Z 2026-03-31T12:27:54.713Z
9566556 9566556 20260323135318_Fg3nw NZ006P 2026-03-24T12:12:04.664Z 2026-03-31T12:27:53.713Z
9566526 9566526 20260323134937_QxSty NZ006P 2026-03-24T12:12:02.013Z 2026-03-31T12:27:53.284Z
9566237 9566237 20260323131611_CB37r NZ006P 2026-03-24T12:11:28.811Z 2026-03-31T12:27:47.430Z
9565258 9565258 20260323115514_bdNAO NZ006P 2026-03-24T12:09:44.935Z 2026-03-31T12:27:31.977Z
9564856 9564856 20260323111330_Um8ca NZ006P 2026-03-24T12:08:54.117Z 2026-03-31T12:27:16.500Z
9564706 9564706 20260323110224_NmOfo NZ006P 2026-03-24T12:08:37.361Z 2026-03-31T12:27:13.972Z
9559208 9559208 20260321164639_apQst NZ006P 2026-03-23T12:10:57.679Z 2026-03-29T12:20:35.248Z
9559100 9559100 20260321163056_6C973 NZ006P 2026-03-23T12:10:53.930Z 2026-03-29T12:20:33.975Z
9559080 9559080 20260321162611_PEQW2 NZ006P 2026-03-23T12:10:53.266Z 2026-03-29T12:20:33.699Z
9559008 9559008 20260321161729_3jOLq NZ006P 2026-03-23T12:10:50.912Z 2026-03-29T12:20:33.023Z
9557472 9557472 20260322141101_iGwIc NZ006P 2026-03-23T12:05:51.653Z 2026-03-30T12:29:39.023Z
9557442 9557442 20260322140002_lw85o NZ006P 2026-03-23T12:05:50.311Z 2026-03-30T12:29:37.822Z
9556978 9556978 20260322122720_ymyd2 NZ006P 2026-03-23T12:05:25.767Z 2026-03-30T12:29:17.837Z
9556869 9556869 20260322120018_524FD NZ006P 2026-03-23T12:05:17.840Z 2026-03-30T12:29:13.344Z
9556843 9556843 20260322115355_LlSrM NZ006P 2026-03-23T12:05:16.643Z 2026-03-30T12:29:12.682Z
9556520 9556520 20260322105431_c3zgA NZ006P 2026-03-23T12:04:53.157Z 2026-03-30T12:29:03.362Z
9556254 9556254 20260322094533_0bn3Z NZ006P 2026-03-23T12:04:34.266Z 2026-03-30T12:28:54.465Z
9550812 9550812 20260320171251_j1PQd NZ006P 2026-03-22T12:25:46.217Z 2026-03-28T12:36:36.174Z
9550506 9550506 20260320164430_H2G6x NZ006P 2026-03-22T12:25:26.995Z 2026-03-28T12:36:31.871Z
9550489 9550489 20260320164402_6gjmS NZ006P 2026-03-22T12:25:25.908Z 2026-03-28T12:36:31.690Z
9550441 9550441 20260320164039_6GXWw NZ006P 2026-03-22T12:25:16.859Z 2026-03-28T12:36:31.068Z
9550184 9550184 20260320161458_MNPat NZ006P 2026-03-22T12:25:00.054Z 2026-03-28T12:36:27.929Z
9549851 9549851 20260320154855_uyYqN NZ006P 2026-03-22T12:24:32.824Z 2026-03-28T12:36:22.487Z
9548426 9548426 20260321150410_ROTAI NZ006P 2026-03-22T12:15:24.709Z 2026-03-29T12:20:26.351Z
9547836 9547836 20260321140335_KiAei NZ006P 2026-03-22T12:14:22.869Z 2026-03-29T12:20:21.665Z
9547780 9547780 20260321135759_w5YI6 NZ006P 2026-03-22T12:14:18.740Z 2026-03-22T12:27:38.539Z
9547347 9547347 20260321131939_LoaHy NZ006P 2026-03-22T12:13:28.078Z 2026-03-22T12:27:38.444Z
9547320 9547320 20260321131727_mYIq5 NZ006P 2026-03-22T12:13:24.991Z 2026-03-29T12:20:08.618Z
9547274 9547274 20260321131225_piyOm NZ006P 2026-03-22T12:13:19.024Z 2026-03-29T12:20:08.275Z
9547087 9547087 20260321125121_T9jxa NZ006P 2026-03-22T12:12:57.876Z 2026-03-29T12:20:06.644Z
9546715 9546715 20260321122153_xdwBj NZ006P 2026-03-22T12:12:16.604Z 2026-03-22T12:27:38.309Z
9545946 9545946 20260321112537_Touwj NZ006P 2026-03-22T12:10:42.296Z 2026-03-29T12:19:45.879Z
9545395 9545395 20260321103051_QQGd6 NZ006P 2026-03-22T12:09:19.750Z 2026-03-22T12:27:38.027Z
9545241 9545241 20260321101517_us5M2 NZ006P 2026-03-22T12:08:58.041Z 2026-03-29T12:19:38.463Z
9545088 9545088 20260321100018_3RXEU NZ006P 2026-03-22T12:08:34.434Z 2026-03-29T12:19:36.862Z
9544779 9544779 20260321092156_f55Gn NZ006P 2026-03-22T12:07:44.758Z 2026-03-29T12:19:33.872Z
9544210 9544210 20260321075846_HbDhH NZ006P 2026-03-22T12:06:06.104Z 2026-03-29T12:19:17.683Z
9544194 9544194 20260321075724_xPhE9 NZ006P 2026-03-22T12:06:03.531Z 2026-03-29T12:19:17.521Z
9544140 9544140 20260321074416_jTw1p NZ006P 2026-03-22T12:05:50.009Z 2026-03-29T12:19:16.718Z
9539820 9539820 20260320171004_8AGVD NZ006P 2026-03-21T12:20:17.133Z 2026-03-28T12:36:35.723Z
9539815 9539815 20260320171000_JlUur NZ006P 2026-03-21T12:20:16.833Z 2026-03-28T12:36:35.706Z
9539488 9539488 20260320145609_2Ic3P NZ006P 2026-03-21T12:19:36.574Z 2026-03-28T12:36:03.278Z
9539484 9539484 20260320145539_9Q6xg NZ006P 2026-03-21T12:19:36.301Z 2026-03-28T12:36:03.119Z
9539373 9539373 20260320143712_JHe3x NZ006P 2026-03-21T12:19:24.880Z 2026-03-28T12:35:59.900Z
9539151 9539151 20260320141316_U0chy NZ006P 2026-03-21T12:19:00.600Z 2026-03-28T12:35:56.987Z
9538934 9538934 20260320135747_H25LL NZ006P 2026-03-21T12:18:36.949Z 2026-03-28T12:35:54.858Z
9538833 9538833 20260320134834_0yFdB NZ006P 2026-03-21T12:18:27.325Z 2026-03-28T12:35:53.258Z
9538729 9538729 20260320133923_lVoYI NZ006P 2026-03-21T12:18:13.982Z 2026-03-28T12:35:51.937Z
9538676 9538676 20260320133411_thfhM NZ006P 2026-03-21T12:18:08.860Z 2026-03-28T12:35:51.613Z
9538606 9538606 20260320132330_Sn4LZ NZ006P 2026-03-21T12:18:01.483Z 2026-03-21T12:30:06.526Z
9538599 9538599 20260320132239_KmEEJ NZ006P 2026-03-21T12:18:00.414Z 2026-03-21T12:30:06.523Z
9538185 9538185 20260320124009_qFsRS NZ006P 2026-03-21T12:17:14.205Z 2026-03-21T12:30:06.398Z
9538053 9538053 20260320122844_VPHJC NZ006P 2026-03-21T12:17:00.599Z 2026-03-21T12:30:06.355Z
9537850 9537850 20260320120700_90qF8 NZ006P 2026-03-21T12:16:34.437Z 2026-03-28T12:35:29.974Z
9537832 9537832 20260320120631_H4xxy NZ006P 2026-03-21T12:16:33.766Z 2026-03-28T12:35:29.838Z
9537267 9537267 20260320112305_wO7n6 NZ006P 2026-03-21T12:15:27.190Z 2026-03-28T12:35:24.131Z
9536812 9536812 20260320103501_jpNY3 NZ006P 2026-03-21T12:14:26.928Z 2026-03-28T12:35:16.743Z
9536518 9536518 20260320100103_loYne NZ006P 2026-03-21T12:13:40.379Z 2026-03-28T12:35:02.996Z
9536196 9536196 20260320092218_Sy2vp NZ006P 2026-03-21T12:12:47.378Z 2026-03-21T12:30:05.764Z
9535748 9535748 20260320082928_DDVto NZ006P 2026-03-21T12:11:45.667Z 2026-03-28T12:34:50.414Z
9528723 9528723 20260318164106_5SrIL NZ006P 2026-03-20T12:22:29.010Z 2026-03-26T12:38:37.824Z
9528551 9528551 20260318162251_9m3iM NZ006P 2026-03-20T12:22:21.503Z 2026-03-26T12:38:36.776Z
9528085 9528085 20260318154214_yIdq6 NZ006P 2026-03-20T12:21:54.889Z 2026-03-26T12:38:32.981Z
9527984 9527984 20260318153230_oyZh1 NZ006P 2026-03-20T12:21:51.637Z 2026-03-26T12:38:32.450Z
9527952 9527952 20260318153057_qxKfH NZ006P 2026-03-20T12:21:50.073Z 2026-03-26T12:38:32.252Z
9527634 9527634 20260318150315_622WK NZ006P 2026-03-20T12:21:35.517Z 2026-03-26T12:38:30.160Z
9527084 9527084 20260318135654_hR3Md NZ006P 2026-03-20T12:20:58.611Z 2026-03-26T12:38:25.809Z
9526625 9526625 20260319170806_1aU7T NZ006P 2026-03-20T12:15:24.570Z 2026-03-27T12:42:28.556Z
9526526 9526526 20260319165423_8RrZt NZ006P 2026-03-20T12:15:18.879Z 2026-03-20T12:25:26.446Z
9526468 9526468 20260319164554_svwb6 NZ006P 2026-03-20T12:15:15.120Z 2026-03-27T12:42:26.470Z
9526461 9526461 20260319164518_hCUHT NZ006P 2026-03-20T12:15:14.570Z 2026-03-27T12:42:26.420Z
9526355 9526355 20260319163107_z51zF NZ006P 2026-03-20T12:15:08.570Z 2026-03-27T12:42:25.384Z
9526337 9526337 20260319162847_ga1ir NZ006P 2026-03-20T12:15:07.428Z 2026-03-20T12:25:26.380Z
9525837 9525837 20260319152435_0nTP2 NZ006P 2026-03-20T12:14:37.374Z 2026-03-27T12:42:20.404Z
9525824 9525824 20260319152230_TDtwe NZ006P 2026-03-20T12:14:36.450Z 2026-03-27T12:42:20.147Z
9525767 9525767 20260319151457_CQwN5 NZ006P 2026-03-20T12:14:31.423Z 2026-03-27T12:42:19.580Z
9525761 9525761 20260319151426_UYsxH NZ006P 2026-03-20T12:14:29.222Z 2026-03-27T12:42:19.540Z
9525736 9525736 20260319151026_GEgqQ NZ006P 2026-03-20T12:14:28.141Z 2026-03-27T12:42:19.363Z
9525719 9525719 20260319150952_Kysk6 NZ006P 2026-03-20T12:14:27.266Z 2026-03-27T12:42:19.249Z
9525709 9525709 20260319150905_g7SYX NZ006P 2026-03-20T12:14:26.508Z 2026-03-27T12:42:19.053Z
9525431 9525431 20260319143110_Gib4s NZ006P 2026-03-20T12:14:12.889Z 2026-03-27T12:42:03.687Z
9525405 9525405 20260319142407_LmuGJ NZ006P 2026-03-20T12:14:11.768Z 2026-03-27T12:42:03.459Z
9525402 9525402 20260319142404_uItna NZ006P 2026-03-20T12:14:11.586Z 2026-03-27T12:42:03.428Z
9525286 9525286 20260319140401_696uf NZ006P 2026-03-20T12:14:05.961Z 2026-03-27T12:42:02.443Z
9525190 9525190 20260319134255_iqfJY NZ006P 2026-03-20T12:13:55.608Z 2026-03-27T12:42:01.332Z
9525159 9525159 20260319133656_Ka4pG NZ006P 2026-03-20T12:13:52.790Z 2026-03-27T12:42:01.059Z
9525125 9525125 20260319132758_dinnZ NZ006P 2026-03-20T12:13:50.291Z 2026-03-27T12:41:59.978Z
9525054 9525054 20260319131352_nNXK4 NZ006P 2026-03-20T12:13:47.362Z 2026-03-27T12:41:59.350Z
9525014 9525014 20260319130908_PgrbJ NZ006P 2026-03-20T12:13:45.406Z 2026-03-27T12:41:58.968Z
9524903 9524903 20260319125236_PebuL NZ006P 2026-03-20T12:13:38.849Z 2026-03-27T12:41:58.097Z
9524644 9524644 20260319121928_zQQhi NZ006P 2026-03-20T12:13:18.135Z 2026-03-27T12:41:54.865Z
9524391 9524391 20260319115036_LUVD5 NZ006P 2026-03-20T12:12:55.530Z 2026-03-27T12:41:52.001Z

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