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

466 rows where station_code = "NZ006F" 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
9627312 9627312 20260408170513_b8DKm NZ006F 2026-04-09T12:10:37.276Z 2026-04-10T12:14:22.520Z
9627221 9627221 20260408164611_AmgaH NZ006F 2026-04-09T12:10:20.500Z 2026-04-10T12:14:22.504Z
9627137 9627137 20260408163047_g23jG NZ006F 2026-04-09T12:10:09.446Z 2026-04-10T12:14:22.489Z
9626472 9626472 20260408140456_iPY4W NZ006F 2026-04-09T12:08:23.877Z 2026-04-10T12:14:22.358Z
9626224 9626224 20260408132621_ALeQP NZ006F 2026-04-09T12:07:47.336Z 2026-04-10T12:14:22.319Z
9626151 9626151 20260408131849_5nvwW NZ006F 2026-04-09T12:07:41.284Z 2026-04-10T12:14:22.310Z
9626098 9626098 20260408131043_Nm3Ei NZ006F 2026-04-09T12:07:34.801Z 2026-04-10T12:14:22.295Z
9626071 9626071 20260408130332_G0aHx NZ006F 2026-04-09T12:07:31.346Z 2026-04-10T12:14:22.291Z
9625755 9625755 20260408114406_NSYyw NZ006F 2026-04-09T12:06:35.477Z 2026-04-10T12:14:22.234Z
9625726 9625726 20260408113953_g9cA3 NZ006F 2026-04-09T12:06:24.521Z 2026-04-10T12:14:22.229Z
9625684 9625684 20260408113421_md17c NZ006F 2026-04-09T12:06:16.959Z 2026-04-10T12:14:22.223Z
9625379 9625379 20260408104501_DROBS NZ006F 2026-04-09T12:05:18.292Z 2026-04-10T12:14:21.915Z
9624760 9624760 20260408082438_S5gRK NZ006F 2026-04-09T12:02:50.796Z 2026-04-10T12:14:21.456Z
9612852 9612852 20260406172433_FlFPI NZ006F 2026-04-07T12:03:04.088Z 2026-04-10T12:22:22.815Z
9612845 9612845 20260406171344_wpTde NZ006F 2026-04-07T12:03:02.917Z 2026-04-10T12:22:22.646Z
9612784 9612784 20260406162551_xuquB NZ006F 2026-04-07T12:02:44.798Z 2026-04-10T12:22:17.992Z
9612778 9612778 20260406161847_dX6H9 NZ006F 2026-04-07T12:02:43.798Z 2026-04-10T12:22:17.772Z
9612709 9612709 20260406153919_kJ8eq NZ006F 2026-04-07T12:02:36.231Z 2026-04-10T12:22:16.334Z
9611869 9611869 20260401161228_XjRRt NZ006F 2026-04-06T12:25:15.680Z 2026-04-10T12:35:42.387Z
9610335 9610335 20260405162920_bxF6H NZ006F 2026-04-06T12:07:08.424Z 2026-04-10T12:27:04.600Z
9610327 9610327 20260405162058_nmH7a NZ006F 2026-04-06T12:07:06.681Z 2026-04-10T12:27:04.368Z
9610296 9610296 20260405155722_F0P57 NZ006F 2026-04-06T12:06:54.202Z 2026-04-10T12:27:03.372Z
9610269 9610269 20260405153458_GCSMw NZ006F 2026-04-06T12:06:47.122Z 2026-04-10T12:27:02.621Z
9610227 9610227 20260405145313_Y89dN NZ006F 2026-04-06T12:06:27.071Z 2026-04-10T12:27:01.039Z
9610150 9610150 20260405135716_wmokH NZ006F 2026-04-06T12:06:02.542Z 2026-04-10T12:26:55.110Z
9610046 9610046 20260405120714_WUSRN NZ006F 2026-04-06T12:05:24.019Z 2026-04-10T12:26:33.600Z
9607806 9607806 20260404151952_idULq NZ006F 2026-04-05T12:04:09.957Z 2026-04-10T12:29:36.065Z
9604197 9604197 20260402163046_Cd3Vo NZ006F 2026-04-03T12:06:20.993Z 2026-04-10T12:34:45.027Z
9602020 9602020 20260401175648_HQbJv NZ006F 2026-04-02T12:04:32.945Z 2026-04-10T12:35:53.955Z
9601881 9601881 20260401171848_WacFg NZ006F 2026-04-02T12:04:01.035Z 2026-04-10T12:35:48.945Z
9601843 9601843 20260401171455_fHbHd NZ006F 2026-04-02T12:03:55.055Z 2026-04-05T12:17:37.173Z
9601795 9601795 20260401170544_L2YFJ NZ006F 2026-04-02T12:03:43.894Z 2026-04-10T12:35:47.546Z
9601771 9601771 20260401165726_oPiGh NZ006F 2026-04-02T12:03:40.404Z 2026-04-10T12:35:47.202Z
9601726 9601726 20260401164533_2H9Lb NZ006F 2026-04-02T12:03:32.404Z 2026-04-05T12:17:28.402Z
9601701 9601701 20260401163145_wQScD NZ006F 2026-04-02T12:03:28.538Z 2026-04-10T12:35:43.783Z
9601535 9601535 20260401154117_rJK16 NZ006F 2026-04-02T12:03:02.270Z 2026-04-05T12:17:16.052Z
9601515 9601515 20260401153914_kMBSX NZ006F 2026-04-02T12:02:58.868Z 2026-04-10T12:35:40.513Z
9601466 9601466 20260401152502_JKfVI NZ006F 2026-04-02T12:02:52.186Z 2026-04-10T12:35:39.731Z
9601461 9601461 20260401152402_usFUd NZ006F 2026-04-02T12:02:51.311Z 2026-04-10T12:35:39.585Z
9601407 9601407 20260401150531_rAXVw NZ006F 2026-04-02T12:02:41.511Z 2026-04-10T12:35:38.486Z
9599962 9599962 20260331174421_nsAGt NZ006F 2026-04-01T12:05:25.086Z 2026-04-09T12:48:03.787Z
9598097 9598097 20260330175612_wZnNY NZ006F 2026-03-31T12:07:37.008Z 2026-04-08T12:44:25.712Z
9598078 9598078 20260330174225_3kWJs NZ006F 2026-03-31T12:07:33.495Z 2026-04-08T12:44:24.992Z
9598005 9598005 20260330172837_dU9aS NZ006F 2026-03-31T12:07:25.827Z 2026-04-08T12:44:22.861Z
9597688 9597688 20260330165007_5yeVQ NZ006F 2026-03-31T12:06:52.679Z 2026-04-08T12:44:15.414Z
9597147 9597147 20260330152442_A1TS2 NZ006F 2026-03-31T12:05:44.840Z 2026-04-08T12:43:34.007Z
9597135 9597135 20260330152240_cJ7Yt NZ006F 2026-03-31T12:05:42.838Z 2026-04-08T12:43:33.512Z
9597081 9597081 20260330151010_A7bGL NZ006F 2026-03-31T12:05:37.444Z 2026-04-08T12:43:32.396Z
9595671 9595671 20260330075357_UOsPC NZ006F 2026-03-31T12:02:09.633Z 2026-04-08T12:42:29.007Z
9588745 9588745 20260325131015_c7jp9 NZ006F 2026-03-28T12:14:36.886Z 2026-04-03T12:38:15.579Z
9588193 9588193 20260326162459_gzlET NZ006F 2026-03-28T12:10:15.647Z 2026-04-04T12:41:26.956Z
9583574 9583574 20260326161805_whDen NZ006F 2026-03-27T12:09:10.277Z 2026-04-04T12:41:25.674Z
9578967 9578967 20260325170318_IeeS7 NZ006F 2026-03-26T12:09:02.549Z 2026-04-03T12:38:48.267Z
9578898 9578898 20260325154352_30jOr NZ006F 2026-03-26T12:08:46.935Z 2026-04-03T12:38:39.305Z
9578875 9578875 20260325152827_6wgBE NZ006F 2026-03-26T12:08:44.464Z 2026-04-03T12:38:37.621Z
9578844 9578844 20260325151247_5fQHz NZ006F 2026-03-26T12:08:40.272Z 2026-04-03T12:38:35.811Z
9578821 9578821 20260325150702_sduEz NZ006F 2026-03-26T12:08:37.595Z 2026-04-03T12:38:34.992Z
9578808 9578808 20260325150236_Dheko NZ006F 2026-03-26T12:08:34.859Z 2026-04-03T12:38:34.252Z
9578789 9578789 20260325143614_X6Vsq NZ006F 2026-03-26T12:08:32.180Z 2026-04-03T12:38:32.680Z
9578656 9578656 20260325131015_OCAg4 NZ006F 2026-03-26T12:08:11.108Z 2026-03-27T12:17:15.018Z
9578603 9578603 20260325123613_JdHuK NZ006F 2026-03-26T12:08:04.524Z 2026-04-03T12:38:10.480Z
9578506 9578506 20260325120710_8i7CF NZ006F 2026-03-26T12:07:46.727Z 2026-04-03T12:38:06.171Z
9578480 9578480 20260325115920_NOaw3 NZ006F 2026-03-26T12:07:43.435Z 2026-04-03T12:38:05.086Z
9578440 9578440 20260325115103_lH33z NZ006F 2026-03-26T12:07:38.648Z 2026-04-03T12:38:03.703Z
9578025 9578025 20260325093253_i6xze NZ006F 2026-03-26T12:06:35.953Z 2026-04-03T12:37:34.218Z
9572481 9572481 20260324091219_Otc21 NZ006F 2026-03-25T12:05:18.337Z 2026-04-02T12:35:26.515Z
9569662 9569662 20260322164225_tLtbm NZ006F 2026-03-24T12:21:43.848Z 2026-03-30T12:30:13.862Z
9569624 9569624 20260322162955_xEFI3 NZ006F 2026-03-24T12:21:31.820Z 2026-03-30T12:30:11.745Z
9567839 9567839 20260323155257_wrHWS NZ006F 2026-03-24T12:14:12.860Z 2026-03-31T12:28:19.698Z
9566688 9566688 20260323140445_JtaKd NZ006F 2026-03-24T12:12:19.019Z 2026-03-25T12:21:37.979Z
9566677 9566677 20260323140300_wQGdS NZ006F 2026-03-24T12:12:17.298Z 2026-03-31T12:27:55.313Z
9565948 9565948 20260323125319_V9n6h NZ006F 2026-03-24T12:11:05.583Z 2026-03-31T12:27:43.867Z
9565937 9565937 20260323125302_Xs5uX NZ006F 2026-03-24T12:11:03.540Z 2026-03-31T12:27:43.720Z
9564877 9564877 20260323111856_Ad2n3 NZ006F 2026-03-24T12:08:56.845Z 2026-03-31T12:27:17.079Z
9563827 9563827 20260323091736_zQvnb NZ006F 2026-03-24T12:06:48.862Z 2026-03-31T12:26:57.391Z
9563533 9563533 20260323083021_BbK1M NZ006F 2026-03-24T12:06:11.068Z 2026-03-31T12:26:46.257Z
9563503 9563503 20260323082617_hlJtD NZ006F 2026-03-24T12:06:07.738Z 2026-03-31T12:26:45.297Z
9563465 9563465 20260323082341_xEcKA NZ006F 2026-03-24T12:06:03.746Z 2026-03-31T12:26:43.718Z
9563351 9563351 20260323080405_3lRHT NZ006F 2026-03-24T12:05:47.591Z 2026-03-31T12:26:41.199Z
9559410 9559410 20260321171401_6O04S NZ006F 2026-03-23T12:11:05.031Z 2026-03-29T12:20:38.840Z
9558679 9558679 20260322172300_LwCOn NZ006F 2026-03-23T12:06:54.141Z 2026-03-30T12:30:20.118Z
9558570 9558570 20260322170056_JVIHp NZ006F 2026-03-23T12:06:49.357Z 2026-03-30T12:30:16.846Z
9558490 9558490 20260322165137_Vfn1Z NZ006F 2026-03-23T12:06:46.628Z 2026-03-30T12:30:15.328Z
9558437 9558437 20260322164225_WCCt2 NZ006F 2026-03-23T12:06:44.191Z 2026-03-23T12:12:22.903Z
9558415 9558415 20260322163659_J3cVw NZ006F 2026-03-23T12:06:42.965Z 2026-03-30T12:30:13.003Z
9558346 9558346 20260322162450_U9sC3 NZ006F 2026-03-23T12:06:39.435Z 2026-03-30T12:30:11.144Z
9558271 9558271 20260322161524_gaLoQ NZ006F 2026-03-23T12:06:36.030Z 2026-03-30T12:30:09.691Z
9558153 9558153 20260322155804_bK8oX NZ006F 2026-03-23T12:06:27.138Z 2026-03-30T12:30:06.143Z
9557990 9557990 20260322152839_uI5qt NZ006F 2026-03-23T12:06:18.784Z 2026-03-30T12:29:53.959Z
9557932 9557932 20260322151856_CSHDI NZ006F 2026-03-23T12:06:16.782Z 2026-03-30T12:29:52.217Z
9557850 9557850 20260322150341_io25v NZ006F 2026-03-23T12:06:12.734Z 2026-03-23T12:12:22.793Z
9557680 9557680 20260322144044_khmD1 NZ006F 2026-03-23T12:06:05.095Z 2026-03-30T12:29:44.850Z
9557656 9557656 20260322143655_aIttn NZ006F 2026-03-23T12:06:04.186Z 2026-03-30T12:29:43.960Z
9557490 9557490 20260322141548_2fRGn NZ006F 2026-03-23T12:05:53.010Z 2026-03-30T12:29:39.737Z
9557443 9557443 20260322140138_gRmLd NZ006F 2026-03-23T12:05:50.460Z 2026-03-23T12:12:22.722Z
9549745 9549745 20260320153349_8LSK9 NZ006F 2026-03-22T12:24:26.131Z 2026-03-28T12:36:18.515Z
9549101 9549101 20260321172103_SAD2o NZ006F 2026-03-22T12:16:32.857Z 2026-03-29T12:20:39.561Z
9549078 9549078 20260321171401_XR13l NZ006F 2026-03-22T12:16:30.573Z 2026-03-29T12:20:38.744Z
9549042 9549042 20260321165639_nSp2F NZ006F 2026-03-22T12:16:27.801Z 2026-03-29T12:20:37.509Z
9547842 9547842 20260321140347_DUt7P NZ006F 2026-03-22T12:14:23.931Z 2026-03-29T12:20:21.870Z

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