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

479 rows where station_code = "NZ006K" 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
9626473 9626473 20260408140456_iPY4W NZ006K 2026-04-09T12:08:23.877Z 2026-04-10T12:14:22.358Z
9626225 9626225 20260408132621_ALeQP NZ006K 2026-04-09T12:07:47.336Z 2026-04-10T12:14:22.319Z
9625920 9625920 20260408122428_yYO1J NZ006K 2026-04-09T12:07:06.718Z 2026-04-10T12:14:22.264Z
9625756 9625756 20260408114406_NSYyw NZ006K 2026-04-09T12:06:35.477Z 2026-04-10T12:14:22.234Z
9625685 9625685 20260408113421_md17c NZ006K 2026-04-09T12:06:16.959Z 2026-04-10T12:14:22.223Z
9625380 9625380 20260408104501_DROBS NZ006K 2026-04-09T12:05:18.292Z 2026-04-10T12:14:21.915Z
9625349 9625349 20260408103040_ERgS9 NZ006K 2026-04-09T12:05:11.676Z 2026-04-10T12:14:21.909Z
9625144 9625144 20260408094501_LiknW NZ006K 2026-04-09T12:04:29.485Z 2026-04-10T12:14:21.865Z
9612785 9612785 20260406162551_xuquB NZ006K 2026-04-07T12:02:44.798Z 2026-04-10T12:22:17.992Z
9612261 9612261 20260406091450_6AXzj NZ006K 2026-04-07T12:01:16.617Z 2026-04-10T12:22:02.881Z
9611870 9611870 20260401161228_XjRRt NZ006K 2026-04-06T12:25:15.680Z 2026-04-10T12:35:42.387Z
9610297 9610297 20260405155722_F0P57 NZ006K 2026-04-06T12:06:54.202Z 2026-04-10T12:27:03.372Z
9609994 9609994 20260405114044_n11OU NZ006K 2026-04-06T12:05:11.368Z 2026-04-10T12:26:32.039Z
9602012 9602012 20260401174852_Cooq3 NZ006K 2026-04-02T12:04:30.804Z 2026-04-10T12:35:52.395Z
9601969 9601969 20260401173739_YOkvn NZ006K 2026-04-02T12:04:20.960Z 2026-04-10T12:35:50.532Z
9601882 9601882 20260401171848_WacFg NZ006K 2026-04-02T12:04:01.035Z 2026-04-10T12:35:48.945Z
9601797 9601797 20260401170544_L2YFJ NZ006K 2026-04-02T12:03:43.894Z 2026-04-10T12:35:47.546Z
9601792 9601792 20260401170140_TgfBI NZ006K 2026-04-02T12:03:43.276Z 2026-04-10T12:35:47.463Z
9601731 9601731 20260401164640_RUcxD NZ006K 2026-04-02T12:03:32.761Z 2026-04-10T12:35:46.447Z
9601717 9601717 20260401163915_1SQGa NZ006K 2026-04-02T12:03:30.864Z 2026-04-10T12:35:46.191Z
9601702 9601702 20260401163145_wQScD NZ006K 2026-04-02T12:03:28.538Z 2026-04-10T12:35:43.783Z
9601536 9601536 20260401154117_rJK16 NZ006K 2026-04-02T12:03:02.270Z 2026-04-05T12:17:16.052Z
9601462 9601462 20260401152402_usFUd NZ006K 2026-04-02T12:02:51.311Z 2026-04-10T12:35:39.585Z
9601415 9601415 20260401150710_S8Sp1 NZ006K 2026-04-02T12:02:43.758Z 2026-04-10T12:35:38.637Z
9599354 9599354 20260331140707_fyZn2 NZ006K 2026-04-01T12:03:17.539Z 2026-04-09T12:46:46.471Z
9597972 9597972 20260330172410_HorX0 NZ006K 2026-03-31T12:07:22.754Z 2026-04-08T12:44:22.118Z
9597913 9597913 20260330171505_7zaKK NZ006K 2026-03-31T12:07:16.457Z 2026-04-08T12:44:20.568Z
9597828 9597828 20260330170326_uchQZ NZ006K 2026-03-31T12:07:03.658Z 2026-04-08T12:44:18.210Z
9597683 9597683 20260330165006_iLOiw NZ006K 2026-03-31T12:06:52.461Z 2026-04-08T12:44:15.260Z
9588746 9588746 20260325131015_c7jp9 NZ006K 2026-03-28T12:14:36.886Z 2026-04-03T12:38:15.579Z
9583765 9583765 20260326175017_kh6pK NZ006K 2026-03-27T12:09:42.240Z 2026-04-04T12:41:37.752Z
9583670 9583670 20260326170540_eQeC3 NZ006K 2026-03-27T12:09:27.686Z 2026-04-04T12:41:30.477Z
9583576 9583576 20260326161805_whDen NZ006K 2026-03-27T12:09:10.285Z 2026-04-04T12:41:25.674Z
9578968 9578968 20260325170318_IeeS7 NZ006K 2026-03-26T12:09:02.549Z 2026-04-03T12:38:48.267Z
9578845 9578845 20260325151247_5fQHz NZ006K 2026-03-26T12:08:40.272Z 2026-04-03T12:38:35.811Z
9578836 9578836 20260325151104_lVQuE NZ006K 2026-03-26T12:08:39.338Z 2026-04-03T12:38:35.587Z
9578809 9578809 20260325150236_Dheko NZ006K 2026-03-26T12:08:34.859Z 2026-04-03T12:38:34.252Z
9578785 9578785 20260325143512_OmRPo NZ006K 2026-03-26T12:08:31.780Z 2026-04-03T12:38:32.575Z
9578769 9578769 20260325143103_fG2pz NZ006K 2026-03-26T12:08:27.667Z 2026-04-03T12:38:31.932Z
9578728 9578728 20260325135621_5we26 NZ006K 2026-03-26T12:08:20.944Z 2026-04-03T12:38:24.958Z
9578703 9578703 20260325133934_OBxGU NZ006K 2026-03-26T12:08:17.052Z 2026-04-03T12:38:17.748Z
9578693 9578693 20260325133118_fGqly NZ006K 2026-03-26T12:08:15.793Z 2026-04-03T12:38:17.197Z
9578657 9578657 20260325131015_OCAg4 NZ006K 2026-03-26T12:08:11.108Z 2026-03-27T12:17:15.018Z
9578630 9578630 20260325124649_77Pk6 NZ006K 2026-03-26T12:08:07.432Z 2026-03-26T12:08:07.432Z
9578604 9578604 20260325123613_JdHuK NZ006K 2026-03-26T12:08:04.524Z 2026-04-03T12:38:10.480Z
9578112 9578112 20260325100245_QoyJ7 NZ006K 2026-03-26T12:06:46.092Z 2026-04-03T12:37:37.696Z
9574683 9574683 20260323125319_cLmuQ NZ006K 2026-03-25T12:15:21.223Z 2026-03-25T12:21:37.870Z
9567960 9567960 20260323160249_t9M0I NZ006K 2026-03-24T12:14:20.088Z 2026-03-31T12:28:21.137Z
9567840 9567840 20260323155257_wrHWS NZ006K 2026-03-24T12:14:12.860Z 2026-03-31T12:28:19.698Z
9567770 9567770 20260323154827_M1NEG NZ006K 2026-03-24T12:14:07.279Z 2026-03-31T12:28:18.452Z
9567122 9567122 20260323144145_vYbqZ NZ006K 2026-03-24T12:13:01.673Z 2026-03-31T12:28:08.655Z
9566678 9566678 20260323140300_wQGdS NZ006K 2026-03-24T12:12:17.298Z 2026-03-31T12:27:55.313Z
9566420 9566420 20260323133525_pc4sf NZ006K 2026-03-24T12:11:49.715Z 2026-03-31T12:27:50.514Z
9565938 9565938 20260323125302_Xs5uX NZ006K 2026-03-24T12:11:03.540Z 2026-03-31T12:27:43.720Z
9564792 9564792 20260323110839_u3q3H NZ006K 2026-03-24T12:08:49.055Z 2026-03-31T12:27:15.654Z
9564646 9564646 20260323105826_8z9jQ NZ006K 2026-03-24T12:08:30.400Z 2026-03-31T12:27:12.960Z
9564496 9564496 20260323104205_ukk3Y NZ006K 2026-03-24T12:08:11.972Z 2026-03-31T12:27:10.088Z
9564330 9564330 20260323102352_0DScG NZ006K 2026-03-24T12:07:51.800Z 2026-03-31T12:27:07.173Z
9564316 9564316 20260323102340_yekP3 NZ006K 2026-03-24T12:07:51.348Z 2026-03-31T12:27:07.033Z
9563828 9563828 20260323091736_zQvnb NZ006K 2026-03-24T12:06:48.862Z 2026-03-31T12:26:57.391Z
9563707 9563707 20260323090133_9PjcU NZ006K 2026-03-24T12:06:35.482Z 2026-03-31T12:26:49.595Z
9563534 9563534 20260323083021_BbK1M NZ006K 2026-03-24T12:06:11.068Z 2026-03-31T12:26:46.257Z
9563504 9563504 20260323082617_hlJtD NZ006K 2026-03-24T12:06:07.738Z 2026-03-31T12:26:45.297Z
9558709 9558709 20260322173220_1zwPI NZ006K 2026-03-23T12:06:56.374Z 2026-03-30T12:30:20.777Z
9558680 9558680 20260322172300_LwCOn NZ006K 2026-03-23T12:06:54.141Z 2026-03-30T12:30:20.118Z
9558635 9558635 20260322171506_bRzSC NZ006K 2026-03-23T12:06:52.316Z 2026-03-30T12:30:18.833Z
9558558 9558558 20260322165859_Oeamj NZ006K 2026-03-23T12:06:48.995Z 2026-03-30T12:30:16.626Z
9558458 9558458 20260322164624_krAWm NZ006K 2026-03-23T12:06:45.304Z 2026-03-30T12:30:14.474Z
9558376 9558376 20260322162955_AXlCX NZ006K 2026-03-23T12:06:40.587Z 2026-03-30T12:30:11.644Z
9558355 9558355 20260322162625_3ljQv NZ006K 2026-03-23T12:06:39.789Z 2026-03-30T12:30:11.379Z
9558169 9558169 20260322160015_d0ZHs NZ006K 2026-03-23T12:06:28.001Z 2026-03-30T12:30:06.608Z
9558133 9558133 20260322155306_V2Mqq NZ006K 2026-03-23T12:06:26.375Z 2026-03-30T12:30:05.572Z
9557863 9557863 20260322150751_8HDHj NZ006K 2026-03-23T12:06:13.165Z 2026-03-30T12:29:50.329Z
9557851 9557851 20260322150341_io25v NZ006K 2026-03-23T12:06:12.734Z 2026-03-23T12:12:22.793Z
9557657 9557657 20260322143655_aIttn NZ006K 2026-03-23T12:06:04.186Z 2026-03-30T12:29:43.960Z
9557609 9557609 20260322143006_u5aG0 NZ006K 2026-03-23T12:05:58.572Z 2026-03-30T12:29:42.865Z
9557491 9557491 20260322141548_2fRGn NZ006K 2026-03-23T12:05:53.010Z 2026-03-30T12:29:39.737Z
9557444 9557444 20260322140138_gRmLd NZ006K 2026-03-23T12:05:50.460Z 2026-03-23T12:12:22.722Z
9549122 9549122 20260321174631_taPZR NZ006K 2026-03-22T12:16:35.980Z 2026-03-29T12:20:40.347Z
9549116 9549116 20260321173626_1p48g NZ006K 2026-03-22T12:16:35.250Z 2026-03-29T12:20:40.120Z
9549111 9549111 20260321173156_IQ2LB NZ006K 2026-03-22T12:16:33.759Z 2026-03-29T12:20:40.044Z
9549094 9549094 20260321172045_mhXoi NZ006K 2026-03-22T12:16:32.292Z 2026-03-29T12:20:39.500Z
9548519 9548519 20260321151056_7sKHv NZ006K 2026-03-22T12:15:31.559Z 2026-03-29T12:20:26.908Z
9547843 9547843 20260321140347_DUt7P NZ006K 2026-03-22T12:14:23.931Z 2026-03-29T12:20:21.870Z
9544531 9544531 20260321085132_V0syj NZ006K 2026-03-22T12:07:06.016Z 2026-03-29T12:19:30.852Z
9544456 9544456 20260321083914_X6T3G NZ006K 2026-03-22T12:06:52.497Z 2026-03-29T12:19:30.062Z
9539626 9539626 20260320154018_1DX2X NZ006K 2026-03-21T12:19:53.902Z 2026-03-28T12:36:21.500Z
9539582 9539582 20260320152647_7q7bu NZ006K 2026-03-21T12:19:46.648Z 2026-03-28T12:36:12.895Z
9539572 9539572 20260320152225_eXDmB NZ006K 2026-03-21T12:19:45.567Z 2026-03-28T12:36:09.065Z
9539531 9539531 20260320151113_lfFYC NZ006K 2026-03-21T12:19:41.000Z 2026-03-28T12:36:05.709Z
9539517 9539517 20260320150441_cFx2k NZ006K 2026-03-21T12:19:39.805Z 2026-03-28T12:36:04.698Z
9539347 9539347 20260320143504_kljVg NZ006K 2026-03-21T12:19:19.313Z 2026-03-28T12:35:59.578Z
9539337 9539337 20260320143410_WWY6q NZ006K 2026-03-21T12:19:18.744Z 2026-03-28T12:35:59.472Z
9538998 9538998 20260320140213_Lx9Vt NZ006K 2026-03-21T12:18:44.411Z 2026-03-28T12:35:55.660Z
9538834 9538834 20260320134927_sS3aI NZ006K 2026-03-21T12:18:27.646Z 2026-03-28T12:35:53.288Z
9538763 9538763 20260320134318_PDMEq NZ006K 2026-03-21T12:18:19.867Z 2026-03-28T12:35:52.124Z
9538636 9538636 20260320132611_UdVVA NZ006K 2026-03-21T12:18:03.930Z 2026-03-28T12:35:50.898Z
9538621 9538621 20260320132527_IzwQk NZ006K 2026-03-21T12:18:03.064Z 2026-03-28T12:35:50.855Z
9538531 9538531 20260320131657_d0XcB NZ006K 2026-03-21T12:17:54.408Z 2026-03-21T12:30:06.505Z
9538408 9538408 20260320130033_FtVj1 NZ006K 2026-03-21T12:17:38.644Z 2026-03-28T12:35:48.098Z

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