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

317 rows where station_code = "NZ006J" 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
9627482 9627482 20260408175942_U762o NZ006J 2026-04-09T12:11:10.411Z 2026-04-10T12:14:22.552Z
9627429 9627429 20260408173407_2GK30 NZ006J 2026-04-09T12:10:54.873Z 2026-04-10T12:14:22.542Z
9627222 9627222 20260408164611_AmgaH NZ006J 2026-04-09T12:10:20.500Z 2026-04-10T12:14:22.504Z
9627203 9627203 20260408164219_JXSE4 NZ006J 2026-04-09T12:10:18.953Z 2026-04-10T12:14:22.501Z
9626580 9626580 20260408141812_sLQbL NZ006J 2026-04-09T12:08:43.417Z 2026-04-10T12:14:22.377Z
9626316 9626316 20260408134144_QSqyi NZ006J 2026-04-09T12:07:58.119Z 2026-04-10T12:14:22.332Z
9626260 9626260 20260408133236_Rgaqe NZ006J 2026-04-09T12:07:50.864Z 2026-04-10T12:14:22.324Z
9626188 9626188 20260408132307_FTBRd NZ006J 2026-04-09T12:07:44.674Z 2026-04-10T12:14:22.315Z
9626019 9626019 20260408125302_jhkCp NZ006J 2026-04-09T12:07:18.774Z 2026-04-10T12:14:22.281Z
9625974 9625974 20260408124303_BJAHm NZ006J 2026-04-09T12:07:13.094Z 2026-04-10T12:14:22.273Z
9625627 9625627 20260408112759_rKwnG NZ006J 2026-04-09T12:06:09.491Z 2026-04-10T12:14:22.215Z
9625473 9625473 20260408105847_pSdVM NZ006J 2026-04-09T12:05:38.053Z 2026-04-10T12:14:21.931Z
9625348 9625348 20260408103040_ERgS9 NZ006J 2026-04-09T12:05:11.676Z 2026-04-10T12:14:21.909Z
9625325 9625325 20260408102432_EW0jP NZ006J 2026-04-09T12:05:08.230Z 2026-04-10T12:14:21.904Z
9625190 9625190 20260408095300_RyJLq NZ006J 2026-04-09T12:04:37.122Z 2026-04-10T12:14:21.875Z
9625143 9625143 20260408094501_LiknW NZ006J 2026-04-09T12:04:29.485Z 2026-04-10T12:14:21.865Z
9624976 9624976 20260408090640_Zy2Y6 NZ006J 2026-04-09T12:03:38.011Z 2026-04-10T12:14:21.824Z
9624790 9624790 20260408082800_ijHIh NZ006J 2026-04-09T12:02:55.718Z 2026-04-10T12:14:21.463Z
9613248 9613248 20260405131512_McDfP NZ006J 2026-04-07T12:05:39.347Z 2026-04-10T12:26:42.541Z
9612818 9612818 20260406164555_iHWAb NZ006J 2026-04-07T12:02:55.197Z 2026-04-10T12:22:19.245Z
9612652 9612652 20260406150957_2BDD2 NZ006J 2026-04-07T12:02:29.295Z 2026-04-10T12:22:14.884Z
9612260 9612260 20260406091450_6AXzj NZ006J 2026-04-07T12:01:16.617Z 2026-04-10T12:22:02.881Z
9610345 9610345 20260405163705_UKekN NZ006J 2026-04-06T12:07:16.195Z 2026-04-10T12:27:04.915Z
9610106 9610106 20260405130233_b9c3T NZ006J 2026-04-06T12:05:50.525Z 2026-04-10T12:26:37.274Z
9609993 9609993 20260405114044_n11OU NZ006J 2026-04-06T12:05:11.359Z 2026-04-10T12:26:32.039Z
9604256 9604256 20260402164752_ic66B NZ006J 2026-04-03T12:06:33.917Z 2026-04-10T12:34:46.322Z
9601922 9601922 20260401172654_jSkej NZ006J 2026-04-02T12:04:10.864Z 2026-04-10T12:35:49.726Z
9601796 9601796 20260401170544_L2YFJ NZ006J 2026-04-02T12:03:43.894Z 2026-04-10T12:35:47.546Z
9588727 9588727 20260325091415_DPwCA NZ006J 2026-03-28T12:13:47.602Z 2026-04-03T12:37:30.997Z
9588202 9588202 20260326163313_yvYpb NZ006J 2026-03-28T12:10:17.184Z 2026-04-04T12:41:27.764Z
9583588 9583588 20260326162123_Oj0xO NZ006J 2026-03-27T12:09:11.901Z 2026-04-04T12:41:26.542Z
9583575 9583575 20260326161805_whDen NZ006J 2026-03-27T12:09:10.285Z 2026-04-04T12:41:25.674Z
9578991 9578991 20260325171529_5wKwg NZ006J 2026-03-26T12:09:05.114Z 2026-04-03T12:38:49.083Z
9578862 9578862 20260325151512_vaYrz NZ006J 2026-03-26T12:08:42.681Z 2026-04-03T12:38:36.618Z
9578727 9578727 20260325135621_5we26 NZ006J 2026-03-26T12:08:20.944Z 2026-04-03T12:38:24.958Z
9578692 9578692 20260325133118_fGqly NZ006J 2026-03-26T12:08:15.793Z 2026-04-03T12:38:17.197Z
9578629 9578629 20260325124649_77Pk6 NZ006J 2026-03-26T12:08:07.432Z 2026-03-26T12:08:07.432Z
9578490 9578490 20260325120100_bwLX8 NZ006J 2026-03-26T12:07:44.388Z 2026-04-03T12:38:05.451Z
9578436 9578436 20260325115020_9NEC2 NZ006J 2026-03-26T12:07:37.615Z 2026-04-03T12:38:03.531Z
9578353 9578353 20260325112452_1BVap NZ006J 2026-03-26T12:07:23.284Z 2026-04-03T12:37:59.678Z
9578329 9578329 20260325112039_CB3rD NZ006J 2026-03-26T12:07:19.914Z 2026-04-03T12:37:58.764Z
9578111 9578111 20260325100245_QoyJ7 NZ006J 2026-03-26T12:06:46.092Z 2026-04-03T12:37:37.696Z
9577792 9577792 20260325083812_V64fw NZ006J 2026-03-26T12:06:06.559Z 2026-04-03T12:37:27.268Z
9569304 9569304 20260322144534_1ZB94 NZ006J 2026-03-24T12:20:29.363Z 2026-03-30T12:29:46.024Z
9567121 9567121 20260323144145_vYbqZ NZ006J 2026-03-24T12:13:01.673Z 2026-03-31T12:28:08.655Z
9567108 9567108 20260323144114_4mqtl NZ006J 2026-03-24T12:13:01.016Z 2026-03-31T12:28:08.528Z
9566419 9566419 20260323133525_pc4sf NZ006J 2026-03-24T12:11:49.715Z 2026-03-31T12:27:50.514Z
9566273 9566273 20260323132147_0pcXE NZ006J 2026-03-24T12:11:34.017Z 2026-03-31T12:27:48.066Z
9565732 9565732 20260323123602_UYahN NZ006J 2026-03-24T12:10:44.732Z 2026-03-31T12:27:40.341Z
9564495 9564495 20260323104205_ukk3Y NZ006J 2026-03-24T12:08:11.972Z 2026-03-31T12:27:10.088Z
9564345 9564345 20260323102400_rnHvD NZ006J 2026-03-24T12:07:53.139Z 2026-03-31T12:27:07.418Z
9564341 9564341 20260323102400_0DvUD NZ006J 2026-03-24T12:07:52.807Z 2026-03-31T12:27:07.353Z
9564329 9564329 20260323102352_0DScG NZ006J 2026-03-24T12:07:51.800Z 2026-03-31T12:27:07.173Z
9564315 9564315 20260323102340_yekP3 NZ006J 2026-03-24T12:07:51.348Z 2026-03-31T12:27:07.033Z
9563689 9563689 20260323090116_geiTm NZ006J 2026-03-24T12:06:34.543Z 2026-03-25T12:21:37.508Z
9558713 9558713 20260322173247_YX9ZP NZ006J 2026-03-23T12:06:56.537Z 2026-03-30T12:30:20.898Z
9558557 9558557 20260322165859_Oeamj NZ006J 2026-03-23T12:06:48.995Z 2026-03-30T12:30:16.626Z
9558523 9558523 20260322165405_y3CJm NZ006J 2026-03-23T12:06:47.886Z 2026-03-30T12:30:16.010Z
9558507 9558507 20260322165252_029aa NZ006J 2026-03-23T12:06:47.296Z 2026-03-30T12:30:15.717Z
9558457 9558457 20260322164624_krAWm NZ006J 2026-03-23T12:06:45.304Z 2026-03-30T12:30:14.474Z
9558168 9558168 20260322160015_d0ZHs NZ006J 2026-03-23T12:06:28.001Z 2026-03-30T12:30:06.608Z
9558143 9558143 20260322155512_QHfrD NZ006J 2026-03-23T12:06:26.653Z 2026-03-30T12:30:05.855Z
9558130 9558130 20260322155224_dYx6p NZ006J 2026-03-23T12:06:26.309Z 2026-03-30T12:30:05.218Z
9558112 9558112 20260322154749_vhPKy NZ006J 2026-03-23T12:06:25.307Z 2026-03-30T12:30:04.918Z
9558039 9558039 20260322153512_Kn5io NZ006J 2026-03-23T12:06:20.708Z 2026-03-30T12:30:02.138Z
9557834 9557834 20260322150134_ZFzKJ NZ006J 2026-03-23T12:06:12.200Z 2026-03-30T12:29:48.996Z
9557759 9557759 20260322145348_NJCRb NZ006J 2026-03-23T12:06:08.944Z 2026-03-30T12:29:46.990Z
9557621 9557621 20260322143321_1376B NZ006J 2026-03-23T12:05:59.261Z 2026-03-30T12:29:43.288Z
9557550 9557550 20260322142444_pTm2r NZ006J 2026-03-23T12:05:56.096Z 2026-03-30T12:29:41.705Z
9557463 9557463 20260322140649_3kCMl NZ006J 2026-03-23T12:05:51.334Z 2026-03-30T12:29:38.611Z
9557402 9557402 20260322135040_To8RR NZ006J 2026-03-23T12:05:48.787Z 2026-03-30T12:29:36.230Z
9555898 9555898 20260322083332_02vQT NZ006J 2026-03-23T12:04:07.047Z 2026-03-30T12:28:38.596Z
9549755 9549755 20260320153452_JyVTz NZ006J 2026-03-22T12:24:26.872Z 2026-03-28T12:36:19.161Z
9549075 9549075 20260321171359_uZ4MO NZ006J 2026-03-22T12:16:30.274Z 2026-03-29T12:20:38.666Z
9549039 9549039 20260321165204_3BX2G NZ006J 2026-03-22T12:16:27.614Z 2026-03-29T12:20:36.041Z
9547766 9547766 20260321135705_jQG6U NZ006J 2026-03-22T12:14:17.275Z 2026-03-29T12:20:21.062Z
9539625 9539625 20260320154018_1DX2X NZ006J 2026-03-21T12:19:53.902Z 2026-03-28T12:36:21.500Z
9539604 9539604 20260320153134_3a3xx NZ006J 2026-03-21T12:19:48.428Z 2026-03-28T12:36:16.375Z
9539588 9539588 20260320152906_ffWZ3 NZ006J 2026-03-21T12:19:47.133Z 2026-03-28T12:36:14.763Z
9539581 9539581 20260320152647_7q7bu NZ006J 2026-03-21T12:19:46.648Z 2026-03-28T12:36:12.895Z
9539540 9539540 20260320151435_THfmR NZ006J 2026-03-21T12:19:42.085Z 2026-03-28T12:36:06.170Z
9539443 9539443 20260320144532_w7eFW NZ006J 2026-03-21T12:19:33.114Z 2026-03-28T12:36:01.165Z
9539416 9539416 20260320144047_FpSuJ NZ006J 2026-03-21T12:19:30.755Z 2026-03-28T12:36:00.679Z
9539266 9539266 20260320142926_QuqfG NZ006J 2026-03-21T12:19:12.942Z 2026-03-28T12:35:58.946Z
9539247 9539247 20260320142843_Xa522 NZ006J 2026-03-21T12:19:11.218Z 2026-03-28T12:35:58.719Z
9539070 9539070 20260320140729_Mcusb NZ006J 2026-03-21T12:18:54.581Z 2026-03-28T12:35:56.580Z
9538818 9538818 20260320134723_aBFPG NZ006J 2026-03-21T12:18:26.132Z 2026-03-28T12:35:52.907Z
9538670 9538670 20260320133335_QoFzT NZ006J 2026-03-21T12:18:08.572Z 2026-03-28T12:35:51.558Z
9538560 9538560 20260320132008_pR2DN NZ006J 2026-03-21T12:17:56.585Z 2026-03-28T12:35:49.967Z
9538215 9538215 20260320124108_iH94Z NZ006J 2026-03-21T12:17:17.264Z 2026-03-28T12:35:35.941Z
9537883 9537883 20260320120947_XAc5r NZ006J 2026-03-21T12:16:38.115Z 2026-03-28T12:35:30.240Z
9537722 9537722 20260320115754_BUkHp NZ006J 2026-03-21T12:16:21.750Z 2026-03-28T12:35:28.677Z
9537403 9537403 20260320113530_mnqKS NZ006J 2026-03-21T12:15:41.489Z 2026-03-28T12:35:25.680Z
9536722 9536722 20260320102206_KS4yQ NZ006J 2026-03-21T12:14:10.319Z 2026-03-28T12:35:05.580Z
9536097 9536097 20260320091100_l34WN NZ006J 2026-03-21T12:12:36.015Z 2026-03-28T12:34:57.445Z
9536090 9536090 20260320091100_0lbac NZ006J 2026-03-21T12:12:35.684Z 2026-03-28T12:34:57.415Z
9535955 9535955 20260320085118_uu1R4 NZ006J 2026-03-21T12:12:14.306Z 2026-03-28T12:34:54.539Z
9529151 9529151 20260318172011_N7s9X NZ006J 2026-03-20T12:22:55.794Z 2026-03-26T12:38:47.750Z
9528380 9528380 20260318160939_W3gIS NZ006J 2026-03-20T12:22:14.582Z 2026-03-26T12:38:35.751Z
9528282 9528282 20260318155810_MO2wr NZ006J 2026-03-20T12:22:03.352Z 2026-03-26T12:38:35.067Z

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