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,079 rows where station_code = "NZ005A" 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
9626547 9626547 20260408141428_Awfkk NZ005A 2026-04-09T12:08:39.715Z 2026-04-09T12:08:39.715Z
9626229 9626229 20260408132812_w8qoa NZ005A 2026-04-09T12:07:47.825Z 2026-04-09T12:07:47.825Z
9625932 9625932 20260408122743_6l3I1 NZ005A 2026-04-09T12:07:08.182Z 2026-04-09T12:07:08.182Z
9625866 9625866 20260408121539_C8UsI NZ005A 2026-04-09T12:07:01.361Z 2026-04-09T12:07:01.361Z
9611875 9611875 20260331111151_IS28Q NZ005A 2026-04-06T12:27:22.460Z 2026-04-09T12:46:40.517Z
9609070 9609070 20260330083722_BTZwO NZ005A 2026-04-05T12:22:36.917Z 2026-04-08T12:42:31.984Z
9606259 9606259 20260403164328_Xoo8X NZ005A 2026-04-04T12:06:11.529Z 2026-04-09T12:42:12.786Z
9606165 9606165 20260403154956_8vqFq NZ005A 2026-04-04T12:05:40.483Z 2026-04-09T12:42:09.993Z
9606143 9606143 20260403153907_lmBuh NZ005A 2026-04-04T12:05:35.278Z 2026-04-09T12:42:09.292Z
9606135 9606135 20260403152605_o89xi NZ005A 2026-04-04T12:05:32.709Z 2026-04-09T12:42:08.888Z
9606116 9606116 20260403152101_Rtn6K NZ005A 2026-04-04T12:05:29.561Z 2026-04-09T12:42:08.614Z
9606103 9606103 20260403151552_Ofx3t NZ005A 2026-04-04T12:05:26.810Z 2026-04-09T12:42:08.204Z
9606097 9606097 20260403151119_Uxzge NZ005A 2026-04-04T12:05:25.417Z 2026-04-09T12:42:08.128Z
9606071 9606071 20260403145006_vqDRm NZ005A 2026-04-04T12:05:14.706Z 2026-04-09T12:42:07.471Z
9606051 9606051 20260403144221_7gJgp NZ005A 2026-04-04T12:05:07.320Z 2026-04-09T12:42:06.990Z
9606009 9606009 20260403140630_SAxnG NZ005A 2026-04-04T12:04:57.083Z 2026-04-09T12:42:05.913Z
9606007 9606007 20260403140540_2RTPx NZ005A 2026-04-04T12:04:56.477Z 2026-04-09T12:42:05.876Z
9605997 9605997 20260403135344_OQTpo NZ005A 2026-04-04T12:04:53.309Z 2026-04-09T12:42:05.674Z
9605994 9605994 20260403135124_U51ao NZ005A 2026-04-04T12:04:52.512Z 2026-04-09T12:42:05.594Z
9605934 9605934 20260403131812_0aVMH NZ005A 2026-04-04T12:04:31.284Z 2026-04-09T12:42:04.184Z
9605875 9605875 20260403122945_tws3K NZ005A 2026-04-04T12:04:16.420Z 2026-04-09T12:42:02.943Z
9605356 9605356 20260403085823_NyUu1 NZ005A 2026-04-04T12:01:52.669Z 2026-04-09T12:41:20.493Z
9603187 9603187 20260402083840_shEvK NZ005A 2026-04-03T12:02:05.579Z 2026-04-09T12:43:22.695Z
9603101 9603101 20260402074929_aI9o3 NZ005A 2026-04-03T12:01:44.668Z 2026-04-09T12:43:20.790Z
9599455 9599455 20260331144515_GcQEM NZ005A 2026-04-01T12:03:40.061Z 2026-04-09T12:46:47.800Z
9599441 9599441 20260331143915_sKKDN NZ005A 2026-04-01T12:03:37.166Z 2026-04-09T12:46:47.512Z
9599432 9599432 20260331143700_62i42 NZ005A 2026-04-01T12:03:34.432Z 2026-04-09T12:46:47.471Z
9599357 9599357 20260331140755_wrP2N NZ005A 2026-04-01T12:03:17.989Z 2026-04-09T12:46:46.503Z
9599267 9599267 20260331132957_Fr4Pi NZ005A 2026-04-01T12:02:57.568Z 2026-04-09T12:46:44.978Z
9599074 9599074 20260331112938_kHzNC NZ005A 2026-04-01T12:02:15.313Z 2026-04-09T12:46:40.913Z
9598019 9598019 20260330173210_rxHA2 NZ005A 2026-03-31T12:07:27.461Z 2026-04-08T12:44:23.450Z
9597986 9597986 20260330172726_AJPKL NZ005A 2026-03-31T12:07:24.121Z 2026-04-08T12:44:22.513Z
9597902 9597902 20260330171413_0k6JV NZ005A 2026-03-31T12:07:14.367Z 2026-04-08T12:44:20.114Z
9597838 9597838 20260330170428_4SK2K NZ005A 2026-03-31T12:07:05.055Z 2026-04-08T12:44:18.580Z
9597793 9597793 20260330170026_JG2ns NZ005A 2026-03-31T12:07:01.255Z 2026-04-08T12:44:17.619Z
9597732 9597732 20260330165506_20gYf NZ005A 2026-03-31T12:06:56.329Z 2026-04-08T12:44:16.305Z
9597558 9597558 20260330163558_fB1xl NZ005A 2026-03-31T12:06:38.121Z 2026-04-08T12:43:49.696Z
9597554 9597554 20260330163540_x0QME NZ005A 2026-03-31T12:06:37.825Z 2026-04-08T12:43:49.516Z
9597517 9597517 20260330162745_Wnn3g NZ005A 2026-03-31T12:06:31.553Z 2026-04-08T12:43:44.717Z
9597226 9597226 20260330154140_XTuVg NZ005A 2026-03-31T12:05:58.162Z 2026-04-08T12:43:36.238Z
9597196 9597196 20260330153401_I3UWK NZ005A 2026-03-31T12:05:52.995Z 2026-04-08T12:43:35.295Z
9596883 9596883 20260330142225_yo2lH NZ005A 2026-03-31T12:05:09.167Z 2026-04-08T12:43:26.942Z
9596835 9596835 20260330141109_yRR3d NZ005A 2026-03-31T12:05:02.973Z 2026-04-08T12:43:25.428Z
9596580 9596580 20260330131622_0WSd0 NZ005A 2026-03-31T12:04:32.394Z 2026-04-08T12:43:19.861Z
9596457 9596457 20260330124040_SMCzP NZ005A 2026-03-31T12:04:18.210Z 2026-04-08T12:43:13.083Z
9596424 9596424 20260330123255_21z3k NZ005A 2026-03-31T12:04:13.157Z 2026-04-08T12:42:58.023Z
9596344 9596344 20260330122042_Mmq3a NZ005A 2026-03-31T12:04:04.077Z 2026-04-08T12:42:50.069Z
9596218 9596218 20260330114820_3tQpJ NZ005A 2026-03-31T12:03:45.402Z 2026-04-08T12:42:44.347Z
9596146 9596146 20260330112448_WMeET NZ005A 2026-03-31T12:03:35.708Z 2026-04-08T12:42:42.459Z
9591436 9591436 20260328163332_VBSWv NZ005A 2026-03-29T12:04:24.745Z 2026-04-06T12:39:15.462Z
9591423 9591423 20260328162649_SXgql NZ005A 2026-03-29T12:04:23.372Z 2026-04-06T12:39:14.866Z
9591420 9591420 20260328162557_15H3f NZ005A 2026-03-29T12:04:23.164Z 2026-04-06T12:39:14.717Z
9591328 9591328 20260328153657_7YmzC NZ005A 2026-03-29T12:04:15.173Z 2026-04-06T12:39:10.946Z
9591288 9591288 20260328151449_2Z6tA NZ005A 2026-03-29T12:04:09.845Z 2026-04-06T12:39:09.135Z
9591281 9591281 20260328150952_puL3M NZ005A 2026-03-29T12:04:09.467Z 2026-04-06T12:39:08.862Z
9590804 9590804 20260328112113_p4CBZ NZ005A 2026-03-29T12:03:18.520Z 2026-04-06T12:38:35.045Z
9590771 9590771 20260328111259_gDIr3 NZ005A 2026-03-29T12:03:16.590Z 2026-04-06T12:38:34.072Z
9590365 9590365 20260328083756_GTrDo NZ005A 2026-03-29T12:02:29.248Z 2026-04-06T12:38:03.197Z
9567809 9567809 20260323155122_BrYGQ NZ005A 2026-03-24T12:14:10.645Z 2026-03-31T12:28:19.222Z
9565290 9565290 20260323115759_LY1cV NZ005A 2026-03-24T12:09:49.335Z 2026-03-31T12:27:32.585Z
9565194 9565194 20260323114946_cQAJN NZ005A 2026-03-24T12:09:36.013Z 2026-03-31T12:27:30.694Z
9564309 9564309 20260323102300_8MCDr NZ005A 2026-03-24T12:07:50.731Z 2026-03-31T12:27:06.977Z
9558196 9558196 20260322160644_O4qw2 NZ005A 2026-03-23T12:06:29.106Z 2026-03-30T12:30:07.566Z
9550819 9550819 20260320171424_xEdhW NZ005A 2026-03-22T12:25:46.668Z 2026-03-28T12:36:36.203Z
9548140 9548140 20260321143740_htxUS NZ005A 2026-03-22T12:14:56.803Z 2026-03-29T12:20:24.212Z
9547664 9547664 20260321135004_Y630T NZ005A 2026-03-22T12:14:04.305Z 2026-03-29T12:20:11.092Z
9547358 9547358 20260321132039_ZJnC0 NZ005A 2026-03-22T12:13:29.911Z 2026-03-29T12:20:08.972Z
9546718 9546718 20260321122158_NXBla NZ005A 2026-03-22T12:12:17.268Z 2026-03-29T12:20:03.418Z
9546673 9546673 20260321121646_x4AjM NZ005A 2026-03-22T12:12:12.532Z 2026-03-29T12:20:03.140Z
9545488 9545488 20260321103947_MZUv3 NZ005A 2026-03-22T12:09:32.204Z 2026-03-29T12:19:40.565Z
9545456 9545456 20260321103806_nWLiI NZ005A 2026-03-22T12:09:27.855Z 2026-03-29T12:19:40.362Z
9544737 9544737 20260321091641_HeVvZ NZ005A 2026-03-22T12:07:38.646Z 2026-03-29T12:19:33.474Z
9544704 9544704 20260321091147_V0nll NZ005A 2026-03-22T12:07:32.534Z 2026-03-29T12:19:32.694Z
9539774 9539774 20260320164905_8N0SM NZ005A 2026-03-21T12:20:11.570Z 2026-03-28T12:36:32.173Z
9539744 9539744 20260320163724_mFFlH NZ005A 2026-03-21T12:20:08.053Z 2026-03-28T12:36:30.662Z
9539679 9539679 20260320160507_Dkpuu NZ005A 2026-03-21T12:19:59.934Z 2026-03-28T12:36:26.716Z
9539637 9539637 20260320154915_0hSs1 NZ005A 2026-03-21T12:19:55.101Z 2026-03-28T12:36:22.815Z
9539618 9539618 20260320153729_5y9Ct NZ005A 2026-03-21T12:19:50.003Z 2026-03-28T12:36:20.820Z
9539526 9539526 20260320150833_C0qe8 NZ005A 2026-03-21T12:19:40.618Z 2026-03-28T12:36:05.492Z
9539520 9539520 20260320150734_V0D4o NZ005A 2026-03-21T12:19:40.005Z 2026-03-28T12:36:05.193Z
9539512 9539512 20260320150017_IjBjh NZ005A 2026-03-21T12:19:39.330Z 2026-03-28T12:36:04.368Z
9539169 9539169 20260320141654_7l4eN NZ005A 2026-03-21T12:19:03.731Z 2026-03-28T12:35:57.569Z
9538989 9538989 20260320140122_o2NH2 NZ005A 2026-03-21T12:18:43.397Z 2026-03-28T12:35:55.531Z
9538869 9538869 20260320135308_Udj4q NZ005A 2026-03-21T12:18:31.760Z 2026-03-28T12:35:53.944Z
9537923 9537923 20260320121436_DWe4G NZ005A 2026-03-21T12:16:44.788Z 2026-03-28T12:35:32.106Z
9537325 9537325 20260320112901_DRmkq NZ005A 2026-03-21T12:15:33.138Z 2026-03-28T12:35:24.860Z
9536646 9536646 20260320101146_H6q9k NZ005A 2026-03-21T12:14:00.018Z 2026-03-21T12:30:05.910Z
9536267 9536267 20260320092837_NCMo2 NZ005A 2026-03-21T12:12:58.502Z 2026-03-28T12:34:59.083Z
9535884 9535884 20260320083919_pEdlN NZ005A 2026-03-21T12:12:06.284Z 2026-03-28T12:34:52.925Z
9535744 9535744 20260320082911_RpaAg NZ005A 2026-03-21T12:11:45.108Z 2026-03-28T12:34:50.384Z
9535695 9535695 20260320082053_Mm6L2 NZ005A 2026-03-21T12:11:36.494Z 2026-03-28T12:34:49.397Z
9529172 9529172 20260318172107_Z2nWN NZ005A 2026-03-20T12:22:56.110Z 2026-03-26T12:38:48.391Z
9527243 9527243 20260318141953_ACOpw NZ005A 2026-03-20T12:21:07.131Z 2026-03-26T12:38:27.119Z
9527234 9527234 20260318141944_X6lmK NZ005A 2026-03-20T12:21:06.430Z 2026-03-26T12:38:27.024Z
9527130 9527130 20260318140421_FinnB NZ005A 2026-03-20T12:21:01.222Z 2026-03-26T12:38:26.204Z
9527001 9527001 20260318134523_eOnZs NZ005A 2026-03-20T12:20:53.961Z 2026-03-26T12:38:25.232Z
9526850 9526850 20260318131955_tIlW7 NZ005A 2026-03-20T12:20:39.653Z 2026-03-26T12:38:24.002Z
9526655 9526655 20260319171321_UwUIZ NZ005A 2026-03-20T12:15:25.928Z 2026-03-27T12:42:29.021Z
9526644 9526644 20260319170848_Bv301 NZ005A 2026-03-20T12:15:25.179Z 2026-03-27T12:42:28.734Z
9526604 9526604 20260319170405_JgNx2 NZ005A 2026-03-20T12:15:22.802Z 2026-03-27T12:42:28.200Z

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