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

6,227 rows where station_code = "NZ001Z" 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
9226656 9226656 20260119123956_sBBpM NZ001Z 2026-01-20T14:04:24.879Z 2026-01-28T14:55:20.330Z
9198015 9198015 20260112131716_jPawG NZ001Z 2026-01-14T14:36:49.759Z 2026-01-20T15:26:39.902Z
9197985 9197985 20260112101906_7PvXW NZ001Z 2026-01-14T14:34:10.662Z 2026-01-20T15:25:05.557Z
9165591 9165591 20260107130925_6sEHN NZ001Z 2026-01-08T14:17:00.180Z 2026-01-13T15:04:33.181Z
9165548 9165548 20260107122857_uFhbc NZ001Z 2026-01-08T14:16:49.987Z 2026-01-13T15:04:12.308Z
9165514 9165514 20260107114326_vCMPJ NZ001Z 2026-01-08T14:16:44.184Z 2026-01-13T15:04:00.896Z
9161843 9161843 20260105152701_37pZG NZ001Z 2026-01-07T14:25:05.817Z 2026-01-13T15:16:54.755Z
9161826 9161826 20260105144019_SizL2 NZ001Z 2026-01-07T14:24:55.092Z 2026-01-13T15:16:41.337Z
9161722 9161722 20260105112656_4Sl7g NZ001Z 2026-01-07T14:23:41.068Z 2026-01-13T15:15:56.976Z
9161718 9161718 20260105104352_fgKef NZ001Z 2026-01-07T14:23:29.054Z 2026-01-13T15:15:43.561Z
9161716 9161716 20260105102142_ovg2v NZ001Z 2026-01-07T14:23:23.266Z 2026-01-13T15:15:38.964Z
9156578 9156578 20260104115617_qlkey NZ001Z 2026-01-06T14:40:03.725Z 2026-01-12T15:12:16.552Z
9156570 9156570 20260104114423_522yW NZ001Z 2026-01-06T14:40:02.182Z 2026-01-12T15:12:16.046Z
9156438 9156438 20260104105112_wkoPT NZ001Z 2026-01-06T14:39:37.174Z 2026-01-12T15:12:10.517Z
9070248 9070248 20251226153956_pBKw2 NZ001Z 2025-12-29T14:47:27.350Z 2026-01-03T15:41:39.242Z
9070110 9070110 20251226151635_lrJbR NZ001Z 2025-12-29T14:47:06.318Z 2026-01-03T15:41:25.023Z
9070073 9070073 20251226151035_Tu2hA NZ001Z 2025-12-29T14:47:02.731Z 2026-01-03T15:41:24.189Z
9069625 9069625 20251226142503_NVCL4 NZ001Z 2025-12-29T14:46:19.666Z 2026-01-03T15:41:05.500Z
9046445 9046445 20251223135051_tt2c9 NZ001Z 2025-12-28T14:54:56.827Z 2025-12-31T15:43:05.311Z
8968481 8968481 20251216152327_mlGgF NZ001Z 2025-12-25T14:49:12.636Z 2025-12-25T14:49:12.636Z
8968211 8968211 20251216145722_R4ejR NZ001Z 2025-12-25T14:48:42.439Z 2025-12-25T14:48:42.439Z
8968127 8968127 20251216144516_zPWUn NZ001Z 2025-12-25T14:48:37.110Z 2025-12-25T14:48:37.110Z
8967581 8967581 20251216134212_Hpz6s NZ001Z 2025-12-25T14:47:45.724Z 2025-12-25T14:47:45.724Z
8967541 8967541 20251216133532_xtWVr NZ001Z 2025-12-25T14:47:42.974Z 2025-12-25T14:47:42.974Z
8967433 8967433 20251216132508_LNDFz NZ001Z 2025-12-25T14:47:32.521Z 2025-12-25T14:47:32.521Z
8764755 8764755 20251212144147_2fIyw NZ001Z 2025-12-14T14:48:35.467Z 2025-12-21T14:17:25.502Z
8764269 8764269 20251212142121_GmGWR NZ001Z 2025-12-14T14:47:38.009Z 2025-12-21T14:17:25.382Z
8763741 8763741 20251212135800_UZia1 NZ001Z 2025-12-14T14:46:24.086Z 2025-12-21T14:17:25.258Z
8763549 8763549 20251212134608_YzlQU NZ001Z 2025-12-14T14:46:06.627Z 2025-12-21T14:17:25.209Z
8763187 8763187 20251212132608_73t5h NZ001Z 2025-12-14T14:45:19.748Z 2025-12-21T14:17:25.108Z
8762948 8762948 20251212131412_l3IL3 NZ001Z 2025-12-14T14:44:38.362Z 2025-12-21T14:17:25.031Z
8762946 8762946 20251212131410_PrSc2 NZ001Z 2025-12-14T14:44:37.726Z 2025-12-21T14:17:25.030Z
8762727 8762727 20251212130336_R2G83 NZ001Z 2025-12-14T14:43:29.458Z 2025-12-21T14:17:24.941Z
8762692 8762692 20251212130142_dMw6V NZ001Z 2025-12-14T14:43:10.412Z 2025-12-21T14:17:24.931Z
8762365 8762365 20251212124200_QgXoO NZ001Z 2025-12-14T14:41:44.602Z 2025-12-21T14:17:24.793Z
8762064 8762064 20251212122934_I3eye NZ001Z 2025-12-14T14:40:39.966Z 2025-12-21T14:17:24.674Z
8761334 8761334 20251212114704_jh2W0 NZ001Z 2025-12-14T14:36:52.492Z 2025-12-21T14:17:24.329Z
8759872 8759872 20251212102345_RWPJU NZ001Z 2025-12-14T14:29:38.459Z 2025-12-21T14:17:23.369Z
8749763 8749763 20251209153815_wOHxs NZ001Z 2025-12-13T15:36:57.387Z 2025-12-17T15:26:13.490Z
8749156 8749156 20251209141438_iRNmV NZ001Z 2025-12-13T15:36:04.392Z 2025-12-17T15:25:58.084Z
8749121 8749121 20251209141007_E5EwL NZ001Z 2025-12-13T15:35:49.031Z 2025-12-17T15:25:53.255Z
8732711 8732711 20251211150314_mRZZL NZ001Z 2025-12-13T14:46:50.278Z 2025-12-20T14:23:58.219Z
8732527 8732527 20251211144835_BKQzm NZ001Z 2025-12-13T14:46:21.219Z 2025-12-20T14:23:53.810Z
8732424 8732424 20251211143837_fibht NZ001Z 2025-12-13T14:46:00.488Z 2025-12-20T14:23:50.455Z
8732272 8732272 20251211142608_Da2Os NZ001Z 2025-12-13T14:45:26.370Z 2025-12-20T14:23:49.460Z
8732087 8732087 20251211140743_anQbO NZ001Z 2025-12-13T14:44:49.349Z 2025-12-20T14:23:48.202Z
8732051 8732051 20251211140307_PB4ku NZ001Z 2025-12-13T14:44:40.084Z 2025-12-20T14:23:48.056Z
8731801 8731801 20251211132732_rxwTW NZ001Z 2025-12-13T14:43:44.818Z 2025-12-20T14:23:46.356Z
8724855 8724855 20251211113720_O8W2V NZ001Z 2025-12-12T14:16:23.318Z 2025-12-20T14:23:34.352Z
8724656 8724656 20251211112321_dGTcn NZ001Z 2025-12-12T14:15:59.967Z 2025-12-12T14:15:59.967Z
8719439 8719439 20251210140720_xgQbX NZ001Z 2025-12-11T14:20:07.319Z 2025-12-19T15:09:52.930Z
8719420 8719420 20251210140613_akl2D NZ001Z 2025-12-11T14:20:05.453Z 2025-12-19T15:09:52.134Z
8719316 8719316 20251210134526_alA2c NZ001Z 2025-12-11T14:19:49.057Z 2025-12-19T15:09:47.617Z
8718915 8718915 20251210130351_Y2Zu7 NZ001Z 2025-12-11T14:18:30.154Z 2025-12-19T15:09:21.442Z
8718774 8718774 20251210125027_QDf66 NZ001Z 2025-12-11T14:18:10.357Z 2025-12-19T15:09:14.887Z
8689037 8689037 20251205134916_IISXD NZ001Z 2025-12-06T14:06:49.788Z 2025-12-14T16:06:03.741Z
8688987 8688987 20251205133449_kSvo2 NZ001Z 2025-12-06T14:06:41.139Z 2025-12-14T16:06:02.637Z
8688801 8688801 20251205124937_wWmBM NZ001Z 2025-12-06T14:05:49.151Z 2025-12-14T16:05:58.267Z
8688787 8688787 20251205124347_QGHUF NZ001Z 2025-12-06T14:05:46.102Z 2025-12-14T16:05:58.020Z
8688519 8688519 20251205115155_O6im9 NZ001Z 2025-12-06T14:04:47.673Z 2025-12-14T16:05:38.357Z
8688517 8688517 20251205115053_S71QM NZ001Z 2025-12-06T14:04:46.716Z 2025-12-14T16:05:37.754Z
8688458 8688458 20251205113524_hTZLr NZ001Z 2025-12-06T14:04:39.700Z 2025-12-14T16:05:33.315Z
8688094 8688094 20251205101807_INIvi NZ001Z 2025-12-06T14:03:07.938Z 2025-12-14T16:05:13.226Z
8687942 8687942 20251205094938_1IQFy NZ001Z 2025-12-06T14:02:28.879Z 2025-12-14T16:05:06.472Z
8684606 8684606 20251204132316_dA233 NZ001Z 2025-12-05T14:04:02.408Z 2025-12-13T16:03:21.968Z
8684604 8684604 20251204132312_SJyVw NZ001Z 2025-12-05T14:04:02.036Z 2025-12-13T16:03:21.897Z
8684000 8684000 20251204100627_w49d8 NZ001Z 2025-12-05T14:01:31.050Z 2025-12-13T16:03:11.524Z
8683974 8683974 20251204095302_1xoR2 NZ001Z 2025-12-05T14:01:24.473Z 2025-12-13T16:03:09.497Z
8678214 8678214 20251203152923_Bd8Cw NZ001Z 2025-12-04T14:03:52.538Z 2025-12-11T14:40:35.686Z
8678178 8678178 20251203151621_fqYWe NZ001Z 2025-12-04T14:03:44.051Z 2025-12-11T14:40:33.943Z
8678034 8678034 20251203141114_xxQIW NZ001Z 2025-12-04T14:03:16.524Z 2025-12-11T14:40:23.757Z
8678021 8678021 20251203140615_SqYZj NZ001Z 2025-12-04T14:03:13.635Z 2025-12-11T14:40:18.116Z
8678015 8678015 20251203140414_iSw03 NZ001Z 2025-12-04T14:03:12.545Z 2025-12-11T14:40:15.727Z
8677706 8677706 20251203115306_SLMLt NZ001Z 2025-12-04T14:02:20.549Z 2025-12-11T14:39:55.054Z
8641282 8641282 20251128142116_a7pQB NZ001Z 2025-11-30T14:15:24.049Z 2025-12-07T14:54:25.241Z
8641239 8641239 20251128141235_Ku5SR NZ001Z 2025-11-30T14:15:08.814Z 2025-12-07T14:54:23.405Z
8641167 8641167 20251128140143_W9UhQ NZ001Z 2025-11-30T14:14:42.670Z 2025-12-07T14:54:20.284Z
8641050 8641050 20251128132634_M3VCM NZ001Z 2025-11-30T14:13:53.825Z 2025-12-07T14:54:13.458Z
8640800 8640800 20251128112747_ZoTuK NZ001Z 2025-11-30T14:10:49.165Z 2025-12-07T14:53:07.041Z
8640162 8640162 20251129125933_vug6Z NZ001Z 2025-11-30T14:07:24.945Z 2025-12-08T14:51:15.290Z
8639810 8639810 20251129120736_ZsW22 NZ001Z 2025-11-30T14:06:10.359Z 2025-12-08T14:51:08.207Z
8639747 8639747 20251129115406_hZAPG NZ001Z 2025-11-30T14:05:56.881Z 2025-12-08T14:50:56.282Z
8638969 8638969 20251129101225_66lJy NZ001Z 2025-11-30T14:03:13.321Z 2025-12-08T14:50:20.643Z
8630202 8630202 20251127151905_JJRSV NZ001Z 2025-11-29T14:12:04.945Z 2025-12-06T14:59:00.171Z
8619959 8619959 20251126112447_rle3F NZ001Z 2025-11-28T14:11:06.657Z 2025-12-05T15:01:14.044Z
8619621 8619621 20251126103636_l2G9t NZ001Z 2025-11-28T14:09:45.933Z 2025-12-05T15:01:03.131Z
8617161 8617161 20251124122420_CG46L NZ001Z 2025-11-27T14:35:59.651Z 2025-12-02T15:05:35.072Z
8595406 8595406 20251124153033_343Qu NZ001Z 2025-11-26T14:11:00.539Z 2025-12-02T15:05:55.964Z
8595389 8595389 20251124152656_TN6vO NZ001Z 2025-11-26T14:10:58.371Z 2025-12-02T15:05:55.128Z
8595374 8595374 20251124152052_7WvqF NZ001Z 2025-11-26T14:10:55.847Z 2025-12-02T15:05:53.990Z
8595343 8595343 20251124151308_0GMrq NZ001Z 2025-11-26T14:10:51.036Z 2025-12-02T15:05:52.878Z
8594959 8594959 20251124132918_xr5pe NZ001Z 2025-11-26T14:09:32.832Z 2025-12-02T15:05:39.761Z
8594747 8594747 20251124124304_q2iPY NZ001Z 2025-11-26T14:08:31.953Z 2025-12-02T15:05:37.148Z
8594589 8594589 20251124115501_IXQLI NZ001Z 2025-11-26T14:07:38.270Z 2025-12-02T15:05:33.566Z
8594585 8594585 20251124115337_Qt16k NZ001Z 2025-11-26T14:07:31.521Z 2025-12-02T15:05:33.500Z
8594492 8594492 20251124113006_QKsdV NZ001Z 2025-11-26T14:07:04.421Z 2025-12-02T15:05:32.267Z
8594294 8594294 20251124103410_FiODL NZ001Z 2025-11-26T14:05:46.383Z 2025-12-02T15:05:28.919Z
8584927 8584927 20251123140039_3R7Lc NZ001Z 2025-11-25T14:08:01.240Z 2025-12-02T15:09:52.761Z
8584753 8584753 20251123132005_UhWWh NZ001Z 2025-11-25T14:07:25.158Z 2025-12-02T15:09:51.579Z
8584499 8584499 20251123122732_WJteh NZ001Z 2025-11-25T14:06:37.137Z 2025-12-02T15:09:49.990Z

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