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

8,324 rows where station_code = "NZ001V" 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
9627386 9627386 20260408172311_Wj3La NZ001V 2026-04-09T12:10:47.250Z 2026-04-10T12:14:22.534Z
9627373 9627373 20260408172212_FUOYd NZ001V 2026-04-09T12:10:46.408Z 2026-04-10T12:14:22.533Z
9627368 9627368 20260408172202_FOVxe NZ001V 2026-04-09T12:10:46.022Z 2026-04-10T12:14:22.532Z
9627290 9627290 20260408170127_493cY NZ001V 2026-04-09T12:10:34.192Z 2026-04-10T12:14:22.517Z
9627231 9627231 20260408165002_IfMui NZ001V 2026-04-09T12:10:21.725Z 2026-04-10T12:14:22.506Z
9627115 9627115 20260408162122_0PAmK NZ001V 2026-04-09T12:10:05.973Z 2026-04-10T12:14:22.484Z
9626978 9626978 20260408154350_LnIPr NZ001V 2026-04-09T12:09:40.902Z 2026-04-10T12:14:22.451Z
9626820 9626820 20260408151035_5qJZV NZ001V 2026-04-09T12:09:15.121Z 2026-04-10T12:14:22.419Z
9626486 9626486 20260408140549_1mtvZ NZ001V 2026-04-09T12:08:26.365Z 2026-04-10T12:14:22.360Z
9626447 9626447 20260408140410_nN9qX NZ001V 2026-04-09T12:08:22.383Z 2026-04-10T12:14:22.355Z
9626375 9626375 20260408134841_33sqP NZ001V 2026-04-09T12:08:13.668Z 2026-04-10T12:14:22.341Z
9626208 9626208 20260408132542_CYDpU NZ001V 2026-04-09T12:07:46.439Z 2026-04-10T12:14:22.318Z
9626180 9626180 20260408132247_nVUHv NZ001V 2026-04-09T12:07:44.327Z 2026-04-10T12:14:22.314Z
9626049 9626049 20260408130202_ziiaQ NZ001V 2026-04-09T12:07:24.709Z 2026-04-10T12:14:22.288Z
9626036 9626036 20260408125655_MCjdI NZ001V 2026-04-09T12:07:22.846Z 2026-04-10T12:14:22.285Z
9625994 9625994 20260408124724_49t56 NZ001V 2026-04-09T12:07:16.419Z 2026-04-10T12:14:22.277Z
9625894 9625894 20260408122303_BTFwd NZ001V 2026-04-09T12:07:04.723Z 2026-04-10T12:14:22.261Z
9625868 9625868 20260408121946_hJNuM NZ001V 2026-04-09T12:07:01.869Z 2026-04-10T12:14:22.257Z
9625746 9625746 20260408114344_jUROd NZ001V 2026-04-09T12:06:34.850Z 2026-04-10T12:14:22.234Z
9625740 9625740 20260408114200_1j6mP NZ001V 2026-04-09T12:06:33.582Z 2026-04-10T12:14:22.233Z
9625671 9625671 20260408113400_JUUP3 NZ001V 2026-04-09T12:06:16.276Z 2026-04-10T12:14:22.222Z
9625613 9625613 20260408112636_vruU1 NZ001V 2026-04-09T12:06:07.595Z 2026-04-10T12:14:22.213Z
9625536 9625536 20260408111159_H8K5R NZ001V 2026-04-09T12:05:48.191Z 2026-04-10T12:14:22.198Z
9625216 9625216 20260408095913_frzpS NZ001V 2026-04-09T12:04:41.317Z 2026-04-10T12:14:21.881Z
9625165 9625165 20260408094743_t12pr NZ001V 2026-04-09T12:04:33.270Z 2026-04-10T12:14:21.870Z
9624982 9624982 20260408090818_Hfibk NZ001V 2026-04-09T12:03:39.925Z 2026-04-10T12:14:21.826Z
9624908 9624908 20260408085351_C37pd NZ001V 2026-04-09T12:03:24.783Z 2026-04-10T12:14:21.809Z
9624740 9624740 20260408081954_4D28d NZ001V 2026-04-09T12:02:46.081Z 2026-04-10T12:14:21.450Z
9624689 9624689 20260408080944_3Jp5J NZ001V 2026-04-09T12:02:31.912Z 2026-04-10T12:14:21.438Z
9624643 9624643 20260408080244_ktgd6 NZ001V 2026-04-09T12:02:23.346Z 2026-04-10T12:14:21.427Z
9624463 9624463 20260408070244_d2Ssc NZ001V 2026-04-09T12:01:34.053Z 2026-04-10T12:14:21.381Z
9605923 9605923 20260403131023_xb8xH NZ001V 2026-04-04T12:04:28.617Z 2026-04-10T12:32:08.691Z
9605910 9605910 20260403125102_gkCfE NZ001V 2026-04-04T12:04:25.364Z 2026-04-10T12:32:05.961Z
9605745 9605745 20260403114657_vcmGK NZ001V 2026-04-04T12:03:41.001Z 2026-04-10T12:31:44.923Z
9605700 9605700 20260403113145_HDjMm NZ001V 2026-04-04T12:03:30.868Z 2026-04-10T12:31:44.008Z
9605573 9605573 20260403105030_tnpY8 NZ001V 2026-04-04T12:02:56.554Z 2026-04-10T12:31:38.951Z
9605334 9605334 20260403084522_N12xR NZ001V 2026-04-04T12:01:50.069Z 2026-04-10T12:31:33.753Z
9605303 9605303 20260403083454_gBA3Y NZ001V 2026-04-04T12:01:41.539Z 2026-04-10T12:31:33.150Z
9605264 9605264 20260403081817_VtGEa NZ001V 2026-04-04T12:01:29.331Z 2026-04-10T12:31:32.234Z
9605229 9605229 20260403080544_mTTA3 NZ001V 2026-04-04T12:01:19.780Z 2026-04-10T12:31:31.343Z
9603924 9603924 20260402134620_FeiX8 NZ001V 2026-04-03T12:05:06.720Z 2026-04-10T12:34:15.623Z
9603754 9603754 20260402120955_mRbhw NZ001V 2026-04-03T12:04:25.788Z 2026-04-10T12:34:08.849Z
9603726 9603726 20260402115833_2GSM3 NZ001V 2026-04-03T12:04:19.111Z 2026-04-10T12:34:08.100Z
9603629 9603629 20260402112644_ZSomM NZ001V 2026-04-03T12:03:51.495Z 2026-04-10T12:34:05.710Z
9603493 9603493 20260402103550_suCHQ NZ001V 2026-04-03T12:03:13.998Z 2026-04-10T12:34:03.026Z
9603292 9603292 20260402092304_WDRGn NZ001V 2026-04-03T12:02:31.284Z 2026-04-10T12:33:59.350Z
9603282 9603282 20260402091717_qJO78 NZ001V 2026-04-03T12:02:30.223Z 2026-04-10T12:33:59.298Z
9601955 9601955 20260401173609_veg71 NZ001V 2026-04-02T12:04:19.084Z 2026-04-10T12:35:50.415Z
9601137 9601137 20260401122815_o8BjS NZ001V 2026-04-02T12:01:43.526Z 2026-04-10T12:35:33.785Z
9601074 9601074 20260401112324_JOs3H NZ001V 2026-04-02T12:01:29.523Z 2026-04-10T12:35:32.703Z
9601022 9601022 20260401103722_HHIDD NZ001V 2026-04-02T12:01:19.158Z 2026-04-10T12:35:31.834Z
9600937 9600937 20260401091137_4nLa6 NZ001V 2026-04-02T12:01:01.904Z 2026-04-10T12:35:30.100Z
9600926 9600926 20260401085658_Ekuix NZ001V 2026-04-02T12:00:59.968Z 2026-04-10T12:35:29.867Z
9599878 9599878 20260331171223_MSqmL NZ001V 2026-04-01T12:05:08.029Z 2026-04-09T12:47:58.404Z
9599748 9599748 20260331163601_2UM8Y NZ001V 2026-04-01T12:04:42.136Z 2026-04-09T12:47:23.079Z
9596819 9596819 20260330141030_fNOFS NZ001V 2026-03-31T12:05:01.626Z 2026-04-08T12:43:25.288Z
9596671 9596671 20260330133950_xyYs3 NZ001V 2026-03-31T12:04:41.304Z 2026-04-08T12:43:21.878Z
9596559 9596559 20260330131353_CzEss NZ001V 2026-03-31T12:04:30.984Z 2026-04-08T12:43:19.639Z
9596544 9596544 20260330131045_UDytS NZ001V 2026-03-31T12:04:29.671Z 2026-04-08T12:43:19.381Z
9596477 9596477 20260330124835_o0xmq NZ001V 2026-03-31T12:04:22.859Z 2026-04-08T12:43:16.670Z
9596471 9596471 20260330124439_WN5bw NZ001V 2026-03-31T12:04:20.038Z 2026-04-08T12:43:15.581Z
9596332 9596332 20260330121949_uvnSg NZ001V 2026-03-31T12:04:03.238Z 2026-04-08T12:42:49.835Z
9596282 9596282 20260330120507_KeC3T NZ001V 2026-03-31T12:03:55.739Z 2026-04-08T12:42:48.354Z
9596001 9596001 20260330103519_11V3U NZ001V 2026-03-31T12:03:06.120Z 2026-04-08T12:42:38.160Z
9595988 9595988 20260330103034_DK16l NZ001V 2026-03-31T12:03:04.555Z 2026-04-08T12:42:37.964Z
9595944 9595944 20260330101303_l82TU NZ001V 2026-03-31T12:02:57.771Z 2026-04-08T12:42:36.962Z
9595940 9595940 20260330101302_qAxQq NZ001V 2026-03-31T12:02:55.912Z 2026-04-08T12:42:36.920Z
9594002 9594002 20260329173811_5cCcS NZ001V 2026-03-30T12:05:48.362Z 2026-04-07T12:27:42.406Z
9593997 9593997 20260329173128_aNDti NZ001V 2026-03-30T12:05:46.574Z 2026-04-07T12:27:42.239Z
9593990 9593990 20260329173100_Fos38 NZ001V 2026-03-30T12:05:44.960Z 2026-04-07T12:27:42.042Z
9593976 9593976 20260329172245_eC2nM NZ001V 2026-03-30T12:05:42.026Z 2026-04-07T12:27:41.619Z
9593900 9593900 20260329163843_kP3pQ NZ001V 2026-03-30T12:05:27.990Z 2026-04-07T12:27:39.408Z
9593892 9593892 20260329163722_pupb5 NZ001V 2026-03-30T12:05:24.972Z 2026-04-07T12:27:39.199Z
9593829 9593829 20260329155755_Dcvmy NZ001V 2026-03-30T12:05:13.817Z 2026-04-07T12:27:37.224Z
9593825 9593825 20260329155010_e7SPt NZ001V 2026-03-30T12:05:13.132Z 2026-04-07T12:27:36.914Z
9593822 9593822 20260329154951_2oetH NZ001V 2026-03-30T12:05:12.677Z 2026-04-07T12:27:36.872Z
9593779 9593779 20260329151512_URgXV NZ001V 2026-03-30T12:05:05.617Z 2026-04-07T12:27:35.688Z
9591127 9591127 20260328133351_3q3M9 NZ001V 2026-03-29T12:03:53.346Z 2026-04-06T12:39:02.113Z
9591098 9591098 20260328131631_cpFFi NZ001V 2026-03-29T12:03:50.305Z 2026-04-06T12:39:00.453Z
9591081 9591081 20260328130906_jfewM NZ001V 2026-03-29T12:03:48.441Z 2026-04-06T12:38:59.427Z
9591043 9591043 20260328124034_ChOhy NZ001V 2026-03-29T12:03:42.520Z 2026-04-06T12:38:48.171Z
9591014 9591014 20260328122347_nsIyg NZ001V 2026-03-29T12:03:39.669Z 2026-04-06T12:38:46.742Z
9590999 9590999 20260328122114_Rkg58 NZ001V 2026-03-29T12:03:36.754Z 2026-04-06T12:38:45.935Z
9590247 9590247 20260328074855_Z04zs NZ001V 2026-03-29T12:02:19.528Z 2026-04-06T12:37:58.389Z
9574782 9574782 20260323172107_uf330 NZ001V 2026-03-25T12:19:40.342Z 2026-03-31T12:28:41.912Z
9574771 9574771 20260323172048_tv41E NZ001V 2026-03-25T12:19:39.977Z 2026-03-31T12:28:41.882Z
9574472 9574472 20260324171224_2YhQO NZ001V 2026-03-25T12:10:42.704Z 2026-04-02T12:37:00.078Z
9574458 9574458 20260324170919_Anqon NZ001V 2026-03-25T12:10:40.366Z 2026-04-02T12:36:59.545Z
9574312 9574312 20260324162605_zyG15 NZ001V 2026-03-25T12:10:16.837Z 2026-04-02T12:36:47.438Z
9574264 9574264 20260324161452_E7xEl NZ001V 2026-03-25T12:10:09.601Z 2026-04-02T12:36:44.701Z
9574248 9574248 20260324160604_65loc NZ001V 2026-03-25T12:10:06.563Z 2026-04-02T12:36:44.112Z
9574220 9574220 20260324155706_zh4Oi NZ001V 2026-03-25T12:10:01.741Z 2026-04-02T12:36:42.849Z
9574208 9574208 20260324155317_8gCQy NZ001V 2026-03-25T12:09:59.434Z 2026-04-02T12:36:42.271Z
9574194 9574194 20260324154945_s03J7 NZ001V 2026-03-25T12:09:57.533Z 2026-04-02T12:36:41.825Z
9574131 9574131 20260324152342_ngbWN NZ001V 2026-03-25T12:09:44.319Z 2026-04-02T12:36:39.555Z
9574123 9574123 20260324152227_R8ZSW NZ001V 2026-03-25T12:09:43.443Z 2026-04-02T12:36:39.338Z
9574087 9574087 20260324151047_Olubl NZ001V 2026-03-25T12:09:37.207Z 2026-04-02T12:36:37.564Z
9574084 9574084 20260324151038_tUkAg NZ001V 2026-03-25T12:09:36.668Z 2026-04-02T12:36:37.448Z
9574068 9574068 20260324150639_Xg5tq NZ001V 2026-03-25T12:09:34.153Z 2026-04-02T12:36:36.741Z
9574060 9574060 20260324150620_qBhBg NZ001V 2026-03-25T12:09:32.991Z 2026-04-02T12:36:36.498Z

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