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

5,931 rows where station_code = "NZ003Q" 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
9625278 9625278 20260408101423_Pj8k5 NZ003Q 2026-04-09T12:04:57.825Z 2026-04-09T12:04:57.825Z
9605679 9605679 20260403112641_y4qD3 NZ003Q 2026-04-04T12:03:26.543Z 2026-04-09T12:41:29.270Z
9605557 9605557 20260403104151_dPEV4 NZ003Q 2026-04-04T12:02:53.440Z 2026-04-09T12:41:25.026Z
9605547 9605547 20260403104054_793Ma NZ003Q 2026-04-04T12:02:51.394Z 2026-04-09T12:41:24.823Z
9605131 9605131 20260403070108_oxH4a NZ003Q 2026-04-04T12:00:51.988Z 2026-04-09T12:41:15.098Z
9603456 9603456 20260402102524_TYRMm NZ003Q 2026-04-03T12:03:08.329Z 2026-04-09T12:43:48.116Z
9599647 9599647 20260331160956_kndkd NZ003Q 2026-04-01T12:04:20.991Z 2026-04-09T12:47:08.850Z
9593989 9593989 20260329173002_HONyI NZ003Q 2026-03-30T12:05:44.539Z 2026-04-07T12:27:42.004Z
9593930 9593930 20260329165606_5WJt6 NZ003Q 2026-03-30T12:05:32.965Z 2026-04-07T12:27:40.194Z
9591477 9591477 20260328164838_KJ2lJ NZ003Q 2026-03-29T12:04:29.296Z 2026-04-06T12:39:17.586Z
9591358 9591358 20260328155307_QjlKc NZ003Q 2026-03-29T12:04:18.097Z 2026-04-06T12:39:12.238Z
9591318 9591318 20260328153424_JyHBr NZ003Q 2026-03-29T12:04:14.765Z 2026-04-06T12:39:10.762Z
9591276 9591276 20260328150916_WaJra NZ003Q 2026-03-29T12:04:09.222Z 2026-04-06T12:39:08.754Z
9591247 9591247 20260328150006_F7LMH NZ003Q 2026-03-29T12:04:05.325Z 2026-04-06T12:39:07.669Z
9591235 9591235 20260328144921_Di1vj NZ003Q 2026-03-29T12:04:04.053Z 2026-04-06T12:39:06.877Z
9591213 9591213 20260328143221_DfTqN NZ003Q 2026-03-29T12:04:01.561Z 2026-04-06T12:39:05.791Z
9591211 9591211 20260328143015_PZZop NZ003Q 2026-03-29T12:04:01.177Z 2026-04-06T12:39:05.616Z
9591145 9591145 20260328134715_8QARZ NZ003Q 2026-03-29T12:03:55.161Z 2026-04-06T12:39:02.825Z
9587846 9587846 20260327162514_K25dr NZ003Q 2026-03-28T12:06:31.168Z 2026-04-05T12:34:46.401Z
9587836 9587836 20260327162343_mO8QB NZ003Q 2026-03-28T12:06:29.806Z 2026-04-05T12:34:45.972Z
9587768 9587768 20260327153712_2RWgB NZ003Q 2026-03-28T12:06:17.920Z 2026-04-05T12:34:41.223Z
9587741 9587741 20260327152937_hpQjg NZ003Q 2026-03-28T12:06:14.016Z 2026-04-05T12:34:39.291Z
9587698 9587698 20260327151007_dtNT8 NZ003Q 2026-03-28T12:06:09.493Z 2026-04-05T12:34:37.668Z
9587640 9587640 20260327144852_ntj9o NZ003Q 2026-03-28T12:05:59.290Z 2026-04-05T12:34:34.754Z
9587503 9587503 20260327133226_6Hf8y NZ003Q 2026-03-28T12:05:41.291Z 2026-04-05T12:34:29.118Z
9587355 9587355 20260327121526_kHICd NZ003Q 2026-03-28T12:05:20.756Z 2026-04-05T12:34:23.341Z
9587344 9587344 20260327121203_ybSOZ NZ003Q 2026-03-28T12:05:19.403Z 2026-04-05T12:34:22.792Z
9586834 9586834 20260327095319_X7SU1 NZ003Q 2026-03-28T12:04:11.182Z 2026-04-05T12:33:51.037Z
9586642 9586642 20260327085041_1cWvc NZ003Q 2026-03-28T12:03:37.750Z 2026-04-05T12:33:35.391Z
9583682 9583682 20260326171049_N3zbl NZ003Q 2026-03-27T12:09:29.784Z 2026-04-04T12:41:31.050Z
9583674 9583674 20260326170706_w3AvI NZ003Q 2026-03-27T12:09:28.488Z 2026-04-04T12:41:30.683Z
9583438 9583438 20260326145849_uH2ZX NZ003Q 2026-03-27T12:08:47.521Z 2026-04-04T12:41:12.066Z
9583373 9583373 20260326135351_n19Td NZ003Q 2026-03-27T12:08:36.088Z 2026-04-04T12:41:05.590Z
9574829 9574829 20260323172441_WXQu3 NZ003Q 2026-03-25T12:19:44.449Z 2026-03-31T12:28:42.793Z
9568687 9568687 20260323171158_FwWx7 NZ003Q 2026-03-24T12:15:34.065Z 2026-03-31T12:28:40.287Z
9568643 9568643 20260323170823_Pt6yQ NZ003Q 2026-03-24T12:15:26.943Z 2026-03-31T12:28:39.564Z
9568402 9568402 20260323164049_yJi7t NZ003Q 2026-03-24T12:15:03.907Z 2026-03-31T12:28:28.699Z
9568120 9568120 20260323161527_vZGtV NZ003Q 2026-03-24T12:14:35.862Z 2026-03-31T12:28:23.265Z
9567168 9567168 20260323144728_B3u5Y NZ003Q 2026-03-24T12:13:09.216Z 2026-03-31T12:28:09.520Z
9567068 9567068 20260323143617_I5aHo NZ003Q 2026-03-24T12:12:54.832Z 2026-03-24T12:24:25.204Z
9566904 9566904 20260323142405_SR6q0 NZ003Q 2026-03-24T12:12:41.039Z 2026-03-31T12:28:05.904Z
9566888 9566888 20260323142338_ZoE9r NZ003Q 2026-03-24T12:12:39.800Z 2026-03-31T12:28:05.734Z
9566555 9566555 20260323135318_Fg3nw NZ003Q 2026-03-24T12:12:04.664Z 2026-03-31T12:27:53.713Z
9566401 9566401 20260323133320_57YZZ NZ003Q 2026-03-24T12:11:47.109Z 2026-03-31T12:27:50.142Z
9565741 9565741 20260323123638_jqUCb NZ003Q 2026-03-24T12:10:45.477Z 2026-03-31T12:27:40.490Z
9565453 9565453 20260323121011_Zgw33 NZ003Q 2026-03-24T12:10:09.240Z 2026-03-31T12:27:35.530Z
9564855 9564855 20260323111330_Um8ca NZ003Q 2026-03-24T12:08:54.117Z 2026-03-31T12:27:16.500Z
9564705 9564705 20260323110224_NmOfo NZ003Q 2026-03-24T12:08:37.361Z 2026-03-31T12:27:13.972Z
9563222 9563222 20260323074329_RpMGF NZ003Q 2026-03-24T12:05:32.097Z 2026-03-31T12:26:38.661Z
9556842 9556842 20260322115355_LlSrM NZ003Q 2026-03-23T12:05:16.643Z 2026-03-30T12:29:12.682Z
9555861 9555861 20260322082326_UAVKF NZ003Q 2026-03-23T12:04:03.887Z 2026-03-30T12:28:37.597Z
9550986 9550986 20260320173457_2AedX NZ003Q 2026-03-22T12:26:03.192Z 2026-03-28T12:36:38.609Z
9550809 9550809 20260320171251_j1PQd NZ003Q 2026-03-22T12:25:46.217Z 2026-03-28T12:36:36.174Z
9550754 9550754 20260320171004_NzuYd NZ003Q 2026-03-22T12:25:42.129Z 2026-03-28T12:36:35.756Z
9550610 9550610 20260320165519_gajyC NZ003Q 2026-03-22T12:25:32.959Z 2026-03-28T12:36:33.337Z
9550504 9550504 20260320164430_H2G6x NZ003Q 2026-03-22T12:25:26.995Z 2026-03-28T12:36:31.871Z
9550487 9550487 20260320164402_6gjmS NZ003Q 2026-03-22T12:25:25.908Z 2026-03-28T12:36:31.690Z
9550180 9550180 20260320161458_MNPat NZ003Q 2026-03-22T12:25:00.053Z 2026-03-28T12:36:27.929Z
9549766 9549766 20260320153659_BbzZ1 NZ003Q 2026-03-22T12:24:27.723Z 2026-03-28T12:36:20.536Z
9547319 9547319 20260321131727_mYIq5 NZ003Q 2026-03-22T12:13:24.991Z 2026-03-29T12:20:08.618Z
9547270 9547270 20260321131225_piyOm NZ003Q 2026-03-22T12:13:19.024Z 2026-03-29T12:20:08.275Z
9547085 9547085 20260321125121_T9jxa NZ003Q 2026-03-22T12:12:57.876Z 2026-03-29T12:20:06.644Z
9546809 9546809 20260321122930_wBFeb NZ003Q 2026-03-22T12:12:26.085Z 2026-03-22T12:27:38.331Z
9546713 9546713 20260321122153_xdwBj NZ003Q 2026-03-22T12:12:16.604Z 2026-03-22T12:27:38.309Z
9546617 9546617 20260321121221_r8XQO NZ003Q 2026-03-22T12:12:08.528Z 2026-03-29T12:20:02.807Z
9546597 9546597 20260321121056_73NlN NZ003Q 2026-03-22T12:12:03.027Z 2026-03-22T12:27:38.284Z
9546530 9546530 20260321120818_Wbs9R NZ003Q 2026-03-22T12:11:57.062Z 2026-03-29T12:20:02.072Z
9546243 9546243 20260321114615_IbGaA NZ003Q 2026-03-22T12:11:22.776Z 2026-03-29T12:19:48.771Z
9546107 9546107 20260321113644_I3eVr NZ003Q 2026-03-22T12:11:05.132Z 2026-03-29T12:19:47.510Z
9545944 9545944 20260321112537_Touwj NZ003Q 2026-03-22T12:10:42.296Z 2026-03-29T12:19:45.879Z
9545394 9545394 20260321103051_QQGd6 NZ003Q 2026-03-22T12:09:19.730Z 2026-03-22T12:27:38.027Z
9539206 9539206 20260320142207_5tPvZ NZ003Q 2026-03-21T12:19:08.103Z 2026-03-21T12:30:06.814Z
9539147 9539147 20260320141316_U0chy NZ003Q 2026-03-21T12:19:00.599Z 2026-03-28T12:35:56.987Z
9538933 9538933 20260320135747_H25LL NZ003Q 2026-03-21T12:18:36.949Z 2026-03-28T12:35:54.858Z
9538832 9538832 20260320134834_0yFdB NZ003Q 2026-03-21T12:18:27.324Z 2026-03-28T12:35:53.258Z
9538745 9538745 20260320134216_tIx6J NZ003Q 2026-03-21T12:18:15.444Z 2026-03-28T12:35:52.033Z
9538727 9538727 20260320133923_lVoYI NZ003Q 2026-03-21T12:18:13.982Z 2026-03-28T12:35:51.937Z
9538674 9538674 20260320133411_thfhM NZ003Q 2026-03-21T12:18:08.860Z 2026-03-28T12:35:51.613Z
9538632 9538632 20260320132550_SNAn0 NZ003Q 2026-03-21T12:18:03.601Z 2026-03-21T12:30:06.537Z
9538605 9538605 20260320132330_Sn4LZ NZ003Q 2026-03-21T12:18:01.483Z 2026-03-21T12:30:06.526Z
9538601 9538601 20260320132239_Fd43F NZ003Q 2026-03-21T12:18:00.701Z 2026-03-21T12:30:06.524Z
9538598 9538598 20260320132239_KmEEJ NZ003Q 2026-03-21T12:18:00.414Z 2026-03-21T12:30:06.523Z
9538518 9538518 20260320131533_lL2YK NZ003Q 2026-03-21T12:17:53.437Z 2026-03-28T12:35:49.354Z
9538239 9538239 20260320124352_kvciK NZ003Q 2026-03-21T12:17:22.437Z 2026-03-28T12:35:36.249Z
9538183 9538183 20260320124009_qFsRS NZ003Q 2026-03-21T12:17:14.205Z 2026-03-21T12:30:06.398Z
9538052 9538052 20260320122844_VPHJC NZ003Q 2026-03-21T12:17:00.599Z 2026-03-21T12:30:06.355Z
9537970 9537970 20260320121854_p5xIZ NZ003Q 2026-03-21T12:16:52.769Z 2026-03-28T12:35:32.850Z
9537848 9537848 20260320120700_90qF8 NZ003Q 2026-03-21T12:16:34.437Z 2026-03-28T12:35:29.974Z
9536515 9536515 20260320100103_loYne NZ003Q 2026-03-21T12:13:40.379Z 2026-03-28T12:35:02.996Z
9536340 9536340 20260320093554_Tnvyy NZ003Q 2026-03-21T12:13:09.214Z 2026-03-21T12:30:05.810Z
9535510 9535510 20260320074901_dMdgY NZ003Q 2026-03-21T12:11:01.531Z 2026-03-28T12:34:45.408Z
9527983 9527983 20260318153230_oyZh1 NZ003Q 2026-03-20T12:21:51.637Z 2026-03-26T12:38:32.450Z
9527970 9527970 20260318153202_qhZNb NZ003Q 2026-03-20T12:21:50.943Z 2026-03-26T12:38:32.389Z
9527083 9527083 20260318135654_hR3Md NZ003Q 2026-03-20T12:20:58.611Z 2026-03-26T12:38:25.809Z
9526633 9526633 20260319170816_wtqg1 NZ003Q 2026-03-20T12:15:24.806Z 2026-03-27T12:42:28.647Z
9526621 9526621 20260319170806_1aU7T NZ003Q 2026-03-20T12:15:24.570Z 2026-03-27T12:42:28.556Z
9526525 9526525 20260319165423_8RrZt NZ003Q 2026-03-20T12:15:18.879Z 2026-03-20T12:25:26.446Z
9526466 9526466 20260319164554_svwb6 NZ003Q 2026-03-20T12:15:15.119Z 2026-03-27T12:42:26.470Z
9526458 9526458 20260319164518_hCUHT NZ003Q 2026-03-20T12:15:14.570Z 2026-03-27T12:42:26.420Z
9526339 9526339 20260319162917_dH3yg NZ003Q 2026-03-20T12:15:07.637Z 2026-03-27T12:42:25.251Z

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