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,210 rows where station_code = "NZ0016" 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
9610254 9610254 20260405152802_p033T NZ0016 2026-04-06T12:06:43.427Z 2026-04-09T12:36:41.754Z
9610234 9610234 20260405150718_Wslqd NZ0016 2026-04-06T12:06:31.910Z 2026-04-09T12:36:40.815Z
9609840 9609840 20260405102910_9hxQX NZ0016 2026-04-06T12:04:13.354Z 2026-04-09T12:36:10.520Z
9609612 9609612 20260405084022_zmcJX NZ0016 2026-04-06T12:02:55.656Z 2026-04-09T12:36:02.647Z
9606362 9606362 20260403173037_aZ4PE NZ0016 2026-04-04T12:06:35.824Z 2026-04-09T12:42:15.178Z
9606353 9606353 20260403172602_329DN NZ0016 2026-04-04T12:06:33.861Z 2026-04-09T12:42:14.946Z
9606339 9606339 20260403171837_B4U7q NZ0016 2026-04-04T12:06:31.123Z 2026-04-09T12:42:14.580Z
9605884 9605884 20260403123542_ZKzK7 NZ0016 2026-04-04T12:04:20.918Z 2026-04-09T12:42:03.130Z
9605869 9605869 20260403122833_653hR NZ0016 2026-04-04T12:04:14.564Z 2026-04-09T12:42:02.814Z
9605759 9605759 20260403115508_lR8Dl NZ0016 2026-04-04T12:03:48.391Z 2026-04-09T12:41:31.035Z
9605614 9605614 20260403110935_EHZ9L NZ0016 2026-04-04T12:03:07.858Z 2026-04-09T12:41:27.875Z
9605554 9605554 20260403104151_dPEV4 NZ0016 2026-04-04T12:02:53.440Z 2026-04-09T12:41:25.026Z
9605408 9605408 20260403095043_96Imn NZ0016 2026-04-04T12:02:09.685Z 2026-04-09T12:41:21.868Z
9605129 9605129 20260403070108_oxH4a NZ0016 2026-04-04T12:00:51.988Z 2026-04-09T12:41:15.098Z
9605124 9605124 20260403070026_2bmgE NZ0016 2026-04-04T12:00:50.489Z 2026-04-09T12:41:14.944Z
9597321 9597321 20260330160358_eU3Ia NZ0016 2026-03-31T12:06:09.455Z 2026-04-08T12:43:40.445Z
9595635 9595635 20260330072342_2Yjhn NZ0016 2026-03-31T12:02:01.922Z 2026-04-08T12:42:27.769Z
9587665 9587665 20260327145757_z12Vd NZ0016 2026-03-28T12:06:03.493Z 2026-04-05T12:34:36.082Z
9587639 9587639 20260327144852_ntj9o NZ0016 2026-03-28T12:05:59.290Z 2026-04-05T12:34:34.754Z
9587500 9587500 20260327133226_6Hf8y NZ0016 2026-03-28T12:05:41.291Z 2026-04-05T12:34:29.118Z
9587460 9587460 20260327130010_dkSh1 NZ0016 2026-03-28T12:05:33.965Z 2026-04-05T12:34:27.403Z
9587444 9587444 20260327125057_0tsJD NZ0016 2026-03-28T12:05:31.971Z 2026-04-05T12:34:26.703Z
9587074 9587074 20260327110456_e4vNF NZ0016 2026-03-28T12:04:44.042Z 2026-04-05T12:34:01.002Z
9587062 9587062 20260327110142_ASWR3 NZ0016 2026-03-28T12:04:42.269Z 2026-04-05T12:34:00.529Z
9587053 9587053 20260327110010_rkQ2O NZ0016 2026-03-28T12:04:41.987Z 2026-04-05T12:34:00.397Z
9586596 9586596 20260327083636_coqlg NZ0016 2026-03-28T12:03:31.237Z 2026-04-05T12:33:32.116Z
9583683 9583683 20260326171315_wX6jH NZ0016 2026-03-27T12:09:30.157Z 2026-04-04T12:41:31.151Z
9583680 9583680 20260326171049_N3zbl NZ0016 2026-03-27T12:09:29.784Z 2026-04-04T12:41:31.050Z
9583673 9583673 20260326170706_w3AvI NZ0016 2026-03-27T12:09:28.488Z 2026-04-04T12:41:30.683Z
9583659 9583659 20260326170409_tbTs0 NZ0016 2026-03-27T12:09:26.544Z 2026-04-04T12:41:30.276Z
9583651 9583651 20260326165751_nbHHN NZ0016 2026-03-27T12:09:25.087Z 2026-04-04T12:41:29.826Z
9583643 9583643 20260326165347_ZPsZo NZ0016 2026-03-27T12:09:23.878Z 2026-04-04T12:41:29.455Z
9583595 9583595 20260326162836_59PEt NZ0016 2026-03-27T12:09:14.551Z 2026-04-04T12:41:27.074Z
9566523 9566523 20260323134937_QxSty NZ0016 2026-03-24T12:12:02.013Z 2026-03-31T12:27:53.284Z
9566482 9566482 20260323134319_sGFm9 NZ0016 2026-03-24T12:11:57.248Z 2026-03-31T12:27:52.653Z
9566399 9566399 20260323133320_57YZZ NZ0016 2026-03-24T12:11:47.109Z 2026-03-31T12:27:50.142Z
9566231 9566231 20260323131611_CB37r NZ0016 2026-03-24T12:11:28.772Z 2026-03-31T12:27:47.430Z
9566228 9566228 20260323131610_NfJsM NZ0016 2026-03-24T12:11:28.339Z 2026-03-31T12:27:47.392Z
9566031 9566031 20260323130059_I6z6b NZ0016 2026-03-24T12:11:14.658Z 2026-03-31T12:27:45.075Z
9565830 9565830 20260323124245_ehGkC NZ0016 2026-03-24T12:10:55.319Z 2026-03-31T12:27:42.175Z
9565451 9565451 20260323121011_Zgw33 NZ0016 2026-03-24T12:10:09.240Z 2026-03-31T12:27:35.530Z
9565257 9565257 20260323115514_bdNAO NZ0016 2026-03-24T12:09:44.935Z 2026-03-31T12:27:31.977Z
9564851 9564851 20260323111330_Um8ca NZ0016 2026-03-24T12:08:54.097Z 2026-03-31T12:27:16.500Z
9564704 9564704 20260323110224_NmOfo NZ0016 2026-03-24T12:08:37.361Z 2026-03-31T12:27:13.972Z
9564355 9564355 20260323102740_QTm4t NZ0016 2026-03-24T12:07:55.815Z 2026-03-31T12:27:07.776Z
9564270 9564270 20260323102006_L8uSH NZ0016 2026-03-24T12:07:47.190Z 2026-03-31T12:27:06.522Z
9559078 9559078 20260321162611_PEQW2 NZ0016 2026-03-23T12:10:53.266Z 2026-03-29T12:20:33.699Z
9557424 9557424 20260322135755_cEAXS NZ0016 2026-03-23T12:05:49.775Z 2026-03-30T12:29:37.267Z
9557404 9557404 20260322135046_Q06XG NZ0016 2026-03-23T12:05:48.965Z 2026-03-30T12:29:36.362Z
9556839 9556839 20260322115355_LlSrM NZ0016 2026-03-23T12:05:16.643Z 2026-03-30T12:29:12.682Z
9556614 9556614 20260322111358_HBOWX NZ0016 2026-03-23T12:05:00.093Z 2026-03-30T12:29:06.256Z
9550804 9550804 20260320171251_j1PQd NZ0016 2026-03-22T12:25:46.217Z 2026-03-28T12:36:36.174Z
9550178 9550178 20260320161458_MNPat NZ0016 2026-03-22T12:25:00.053Z 2026-03-28T12:36:27.929Z
9549792 9549792 20260320154206_RYf22 NZ0016 2026-03-22T12:24:29.979Z 2026-03-28T12:36:21.716Z
9548205 9548205 20260321144031_Pjlow NZ0016 2026-03-22T12:15:02.596Z 2026-03-29T12:20:24.640Z
9548026 9548026 20260321142623_L0zSs NZ0016 2026-03-22T12:14:46.276Z 2026-03-29T12:20:23.505Z
9547776 9547776 20260321135759_w5YI6 NZ0016 2026-03-22T12:14:18.740Z 2026-03-22T12:27:38.539Z
9547300 9547300 20260321131440_WCsTy NZ0016 2026-03-22T12:13:21.443Z 2026-03-29T12:20:08.464Z
9547088 9547088 20260321125125_okayC NZ0016 2026-03-22T12:12:58.150Z 2026-03-29T12:20:06.673Z
9546709 9546709 20260321122153_xdwBj NZ0016 2026-03-22T12:12:16.604Z 2026-03-22T12:27:38.309Z
9546382 9546382 20260321115638_HN9go NZ0016 2026-03-22T12:11:37.635Z 2026-03-29T12:20:00.559Z
9546334 9546334 20260321115457_qwCcI NZ0016 2026-03-22T12:11:31.216Z 2026-03-29T12:19:55.136Z
9546100 9546100 20260321113623_yiQDA NZ0016 2026-03-22T12:11:02.015Z 2026-03-22T12:27:38.185Z
9545940 9545940 20260321112537_Touwj NZ0016 2026-03-22T12:10:42.296Z 2026-03-29T12:19:45.879Z
9545810 9545810 20260321111000_uE8Di NZ0016 2026-03-22T12:10:19.661Z 2026-03-29T12:19:44.670Z
9545747 9545747 20260321110443_1XwOx NZ0016 2026-03-22T12:10:09.131Z 2026-03-29T12:19:43.018Z
9545648 9545648 20260321105703_eP67Q NZ0016 2026-03-22T12:09:56.201Z 2026-03-29T12:19:42.198Z
9545236 9545236 20260321101517_us5M2 NZ0016 2026-03-22T12:08:58.041Z 2026-03-29T12:19:38.463Z
9545111 9545111 20260321100234_ZMUl0 NZ0016 2026-03-22T12:08:36.592Z 2026-03-29T12:19:37.030Z
9539368 9539368 20260320143712_JHe3x NZ0016 2026-03-21T12:19:24.880Z 2026-03-28T12:35:59.900Z
9539140 9539140 20260320141316_U0chy NZ0016 2026-03-21T12:19:00.574Z 2026-03-28T12:35:56.987Z
9539098 9539098 20260320141014_60LGH NZ0016 2026-03-21T12:18:56.770Z 2026-03-28T12:35:56.752Z
9538326 9538326 20260320125216_6nWbo NZ0016 2026-03-21T12:17:30.768Z 2026-03-28T12:35:46.982Z
9538237 9538237 20260320124352_kvciK NZ0016 2026-03-21T12:17:22.437Z 2026-03-28T12:35:36.249Z
9538179 9538179 20260320124009_qFsRS NZ0016 2026-03-21T12:17:14.205Z 2026-03-21T12:30:06.398Z
9537963 9537963 20260320121854_p5xIZ NZ0016 2026-03-21T12:16:52.769Z 2026-03-28T12:35:32.850Z
9537947 9537947 20260320121741_v3EeO NZ0016 2026-03-21T12:16:51.137Z 2026-03-28T12:35:32.517Z
9537845 9537845 20260320120700_90qF8 NZ0016 2026-03-21T12:16:34.436Z 2026-03-28T12:35:29.974Z
9537830 9537830 20260320120631_H4xxy NZ0016 2026-03-21T12:16:33.766Z 2026-03-28T12:35:29.838Z
9537789 9537789 20260320120318_xEkoS NZ0016 2026-03-21T12:16:29.284Z 2026-03-28T12:35:29.374Z
9537641 9537641 20260320115305_p4XLh NZ0016 2026-03-21T12:16:10.029Z 2026-03-28T12:35:27.968Z
9537433 9537433 20260320113757_dSOVl NZ0016 2026-03-21T12:15:46.872Z 2026-03-28T12:35:26.021Z
9537396 9537396 20260320113526_p1yXH NZ0016 2026-03-21T12:15:41.126Z 2026-03-28T12:35:25.651Z
9537026 9537026 20260320105830_aSlOK NZ0016 2026-03-21T12:14:56.775Z 2026-03-21T12:30:06.040Z
9536807 9536807 20260320103501_jpNY3 NZ0016 2026-03-21T12:14:26.928Z 2026-03-28T12:35:16.743Z
9536602 9536602 20260320101027_6iuTf NZ0016 2026-03-21T12:13:52.512Z 2026-03-28T12:35:04.444Z
9536509 9536509 20260320100103_loYne NZ0016 2026-03-21T12:13:40.379Z 2026-03-28T12:35:02.996Z
9536184 9536184 20260320092218_E9U5C NZ0016 2026-03-21T12:12:47.119Z 2026-03-28T12:34:58.483Z
9535516 9535516 20260320075008_TC1fD NZ0016 2026-03-21T12:11:02.745Z 2026-03-28T12:34:45.713Z
9528724 9528724 20260318164140_3FEhJ NZ0016 2026-03-20T12:22:29.234Z 2026-03-26T12:38:37.838Z
9528722 9528722 20260318164106_5SrIL NZ0016 2026-03-20T12:22:29.010Z 2026-03-26T12:38:37.824Z
9528654 9528654 20260318163556_Qyh2w NZ0016 2026-03-20T12:22:26.127Z 2026-03-26T12:38:37.475Z
9528592 9528592 20260318162831_5e2k8 NZ0016 2026-03-20T12:22:23.476Z 2026-03-26T12:38:37.104Z
9528548 9528548 20260318162251_9m3iM NZ0016 2026-03-20T12:22:21.503Z 2026-03-26T12:38:36.776Z
9528489 9528489 20260318162014_v23eF NZ0016 2026-03-20T12:22:19.871Z 2026-03-26T12:38:36.533Z
9528308 9528308 20260318160350_qs3Il NZ0016 2026-03-20T12:22:11.927Z 2026-03-26T12:38:35.294Z
9528238 9528238 20260318155400_sKp7t NZ0016 2026-03-20T12:22:01.365Z 2026-03-26T12:38:34.807Z
9528079 9528079 20260318154214_yIdq6 NZ0016 2026-03-20T12:21:54.888Z 2026-03-26T12:38:32.981Z
9527978 9527978 20260318153230_oyZh1 NZ0016 2026-03-20T12:21:51.636Z 2026-03-26T12:38:32.450Z
9527947 9527947 20260318153057_qxKfH NZ0016 2026-03-20T12:21:50.072Z 2026-03-26T12:38:32.252Z

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