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

7,125 rows where station_code = "NZ001S" 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
9270692 9270692 20260128162951_7LL3M NZ001S 2026-01-29T14:13:21.184Z 2026-01-29T14:13:21.184Z
9270682 9270682 20260128162240_3QKeC NZ001S 2026-01-29T14:13:18.265Z 2026-01-29T14:13:18.265Z
9270643 9270643 20260128161755_YAayj NZ001S 2026-01-29T14:13:11.255Z 2026-01-29T14:13:11.255Z
9270627 9270627 20260128161510_NCbQG NZ001S 2026-01-29T14:13:03.742Z 2026-01-29T14:13:03.742Z
9270589 9270589 20260128160821_oaDTS NZ001S 2026-01-29T14:12:52.897Z 2026-01-29T14:12:52.897Z
9270437 9270437 20260128154914_d5mGz NZ001S 2026-01-29T14:12:16.402Z 2026-01-29T14:12:16.402Z
9270318 9270318 20260128153109_fXf0U NZ001S 2026-01-29T14:11:44.932Z 2026-01-29T14:11:44.932Z
9269096 9269096 20260128122440_1YyiV NZ001S 2026-01-29T14:06:30.155Z 2026-01-29T14:06:30.155Z
9268772 9268772 20260128111752_sYej1 NZ001S 2026-01-29T14:04:49.729Z 2026-01-29T14:04:49.729Z
9268695 9268695 20260128110320_tCHP2 NZ001S 2026-01-29T14:04:23.747Z 2026-01-29T14:04:23.747Z
9268633 9268633 20260128105646_zCC9Q NZ001S 2026-01-29T14:04:07.504Z 2026-01-29T14:04:07.504Z
9268524 9268524 20260128104052_ep7V8 NZ001S 2026-01-29T14:03:29.060Z 2026-01-29T14:03:29.060Z
9261587 9261587 20260126122127_YkN7d NZ001S 2026-01-27T14:04:30.200Z 2026-01-29T14:32:41.657Z
9261497 9261497 20260126115827_dGvdB NZ001S 2026-01-27T14:04:04.702Z 2026-01-29T14:32:36.130Z
9260928 9260928 20260126084827_jU4qp NZ001S 2026-01-27T14:00:55.071Z 2026-01-29T14:31:14.199Z
9257761 9257761 20260125155125_h3aHP NZ001S 2026-01-26T14:07:38.921Z 2026-01-29T14:37:38.433Z
9257748 9257748 20260125154813_XJVUb NZ001S 2026-01-26T14:07:36.131Z 2026-01-29T14:37:37.845Z
9257653 9257653 20260125151606_jsqP9 NZ001S 2026-01-26T14:07:02.561Z 2026-01-29T14:37:33.169Z
9257633 9257633 20260125150601_YaJ27 NZ001S 2026-01-26T14:06:51.914Z 2026-01-29T14:37:31.690Z
9257504 9257504 20260125141116_Pc2jb NZ001S 2026-01-26T14:06:01.971Z 2026-01-29T14:37:23.648Z
9257494 9257494 20260125140748_63mAm NZ001S 2026-01-26T14:05:59.470Z 2026-01-29T14:37:22.494Z
9257373 9257373 20260125131307_Z3ZYV NZ001S 2026-01-26T14:05:11.044Z 2026-01-29T14:37:08.647Z
9257368 9257368 20260125130922_S9g9Z NZ001S 2026-01-26T14:05:09.250Z 2026-01-29T14:37:08.068Z
9257320 9257320 20260125124544_B93Y8 NZ001S 2026-01-26T14:04:43.219Z 2026-01-29T14:37:05.410Z
9257271 9257271 20260125123937_K09Vc NZ001S 2026-01-26T14:04:31.703Z 2026-01-29T14:37:03.146Z
9253981 9253981 20260123101018_4Jv9x NZ001S 2026-01-25T14:05:38.850Z 2026-01-29T14:44:57.936Z
9253882 9253882 20260124153225_k2z3t NZ001S 2026-01-25T14:04:51.289Z 2026-01-29T14:41:45.551Z
9253795 9253795 20260124144206_2I1PI NZ001S 2026-01-25T14:04:27.610Z 2026-01-29T14:41:30.923Z
9253521 9253521 20260124122743_v4DaK NZ001S 2026-01-25T14:03:07.725Z 2026-01-29T14:40:55.177Z
9253476 9253476 20260124120705_X2L48 NZ001S 2026-01-25T14:02:57.065Z 2026-01-29T14:40:52.524Z
9253421 9253421 20260124114158_3jHEp NZ001S 2026-01-25T14:02:39.084Z 2026-01-29T14:40:48.712Z
9253415 9253415 20260124114039_9JqfQ NZ001S 2026-01-25T14:02:37.794Z 2026-01-29T14:40:48.457Z
9253313 9253313 20260124105129_h4ShC NZ001S 2026-01-25T14:02:01.031Z 2026-01-29T14:40:36.974Z
9253099 9253099 20260124091926_UPJG8 NZ001S 2026-01-25T14:00:42.136Z 2026-01-29T14:40:15.271Z
9250517 9250517 20260123155300_D2obM NZ001S 2026-01-24T14:03:21.344Z 2026-01-29T14:45:44.507Z
9250498 9250498 20260123153553_Vuj23 NZ001S 2026-01-24T14:03:15.357Z 2026-01-29T14:45:41.178Z
9250161 9250161 20260123105413_WDfDS NZ001S 2026-01-24T14:01:30.593Z 2026-01-29T14:45:02.791Z
9250083 9250083 20260123101018_fypz1 NZ001S 2026-01-24T14:01:04.365Z 2026-01-29T14:44:57.789Z
9250072 9250072 20260123100605_2mQsC NZ001S 2026-01-24T14:01:00.386Z 2026-01-29T14:44:57.120Z
9250011 9250011 20260123093538_8colr NZ001S 2026-01-24T14:00:37.054Z 2026-01-29T14:44:47.683Z
9249825 9249825 20260122090749_tZDXn NZ001S 2026-01-23T14:16:19.594Z 2026-01-29T14:58:59.729Z
9246698 9246698 20260121134747_guszD NZ001S 2026-01-23T14:07:37.209Z 2026-01-29T14:55:05.649Z
9246668 9246668 20260121133110_FMiHe NZ001S 2026-01-23T14:07:32.613Z 2026-01-29T14:55:03.916Z
9246581 9246581 20260121123927_ApLsw NZ001S 2026-01-23T14:07:11.665Z 2026-01-29T14:54:44.087Z
9245945 9245945 20260122154205_2ITnF NZ001S 2026-01-23T14:04:07.032Z 2026-01-29T14:50:26.319Z
9245943 9245943 20260122153943_26HTv NZ001S 2026-01-23T14:04:06.699Z 2026-01-29T14:50:26.160Z
9245933 9245933 20260122153625_IcZuv NZ001S 2026-01-23T14:04:04.642Z 2026-01-29T14:50:25.675Z
9245632 9245632 20260122132831_ZZL2v NZ001S 2026-01-23T14:02:48.712Z 2026-01-29T14:49:52.103Z
9245527 9245527 20260122125420_6ZVsg NZ001S 2026-01-23T14:02:17.943Z 2026-01-29T14:49:45.339Z
9245515 9245515 20260122125340_8R2Xt NZ001S 2026-01-23T14:02:16.297Z 2026-01-29T14:49:45.144Z
9245466 9245466 20260122123710_pnZEE NZ001S 2026-01-23T14:02:04.447Z 2026-01-29T14:49:42.240Z
9245413 9245413 20260122121818_yIjxv NZ001S 2026-01-23T14:01:52.778Z 2026-01-29T14:49:32.356Z
9245386 9245386 20260122120824_qfIgK NZ001S 2026-01-23T14:01:48.369Z 2026-01-29T14:49:29.953Z
9245333 9245333 20260122114843_ELk7Y NZ001S 2026-01-23T14:01:31.047Z 2026-01-29T14:49:24.454Z
9205604 9205604 20260114123744_lJi7w NZ001S 2026-01-15T14:31:41.220Z 2026-01-22T15:11:17.483Z
9205602 9205602 20260114123307_rXnUw NZ001S 2026-01-15T14:31:39.418Z 2026-01-22T15:11:17.057Z
9196926 9196926 20260113093805_xtbLo NZ001S 2026-01-14T14:20:42.547Z 2026-01-21T15:06:08.061Z
9185830 9185830 20260111132115_sDAOA NZ001S 2026-01-12T14:26:05.598Z 2026-01-19T15:21:55.677Z
9185717 9185717 20260111125349_Z5ssp NZ001S 2026-01-12T14:25:45.281Z 2026-01-19T15:21:44.355Z
9185648 9185648 20260111122200_bSrlA NZ001S 2026-01-12T14:25:24.402Z 2026-01-19T15:21:14.767Z
9185347 9185347 20260111140221_ZY1nl NZ001S 2026-01-12T14:23:04.651Z 2026-01-19T15:22:09.558Z
9185312 9185312 20260111135434_9ocZ1 NZ001S 2026-01-12T14:23:01.276Z 2026-01-19T15:22:05.557Z
9185227 9185227 20260111133109_ema6L NZ001S 2026-01-12T14:22:49.712Z 2026-01-19T15:21:58.976Z
9185223 9185223 20260111132853_wexGJ NZ001S 2026-01-12T14:22:47.004Z 2026-01-19T15:21:58.620Z
9185089 9185089 20260111130603_g2EUZ NZ001S 2026-01-12T14:22:27.954Z 2026-01-19T15:21:48.865Z
9184871 9184871 20260111123149_WuLJG NZ001S 2026-01-12T14:21:48.113Z 2026-01-19T15:21:19.512Z
9184860 9184860 20260111122900_YXGfJ NZ001S 2026-01-12T14:21:46.782Z 2026-01-19T15:21:18.916Z
9184822 9184822 20260111122425_wumyT NZ001S 2026-01-12T14:21:40.275Z 2026-01-19T15:21:16.774Z
9184808 9184808 20260111122300_PDwXv NZ001S 2026-01-12T14:21:38.160Z 2026-01-19T15:21:14.882Z
9184752 9184752 20260111121554_O74nj NZ001S 2026-01-12T14:21:31.380Z 2026-01-19T15:21:12.020Z
9184740 9184740 20260111121455_rkvPW NZ001S 2026-01-12T14:21:30.068Z 2026-01-19T15:21:11.445Z
9184681 9184681 20260111120821_CSu5a NZ001S 2026-01-12T14:21:18.004Z 2026-01-19T15:21:08.291Z
9184653 9184653 20260111120502_E9Mn7 NZ001S 2026-01-12T14:21:13.644Z 2026-01-19T15:21:07.145Z
9184618 9184618 20260111115823_WrWl2 NZ001S 2026-01-12T14:21:08.708Z 2026-01-19T15:21:05.816Z
9184490 9184490 20260111114224_2MDjO NZ001S 2026-01-12T14:20:44.074Z 2026-01-19T15:21:00.812Z
9184263 9184263 20260111110242_F95uH NZ001S 2026-01-12T14:20:08.800Z 2026-01-19T15:20:31.079Z
9183954 9183954 20260111102938_Kr67w NZ001S 2026-01-12T14:19:17.000Z 2026-01-19T15:20:17.746Z
9183828 9183828 20260111102049_b81Vt NZ001S 2026-01-12T14:18:56.835Z 2026-01-19T15:20:13.547Z
9183663 9183663 20260111095643_2MnQh NZ001S 2026-01-12T14:18:28.555Z 2026-01-19T15:20:05.646Z
9183661 9183661 20260111095643_8k6mx NZ001S 2026-01-12T14:18:28.246Z 2026-01-19T15:20:03.810Z
9183470 9183470 20260111093317_2XUvQ NZ001S 2026-01-12T14:17:52.807Z 2026-01-19T15:19:40.741Z
9179307 9179307 20260111153127_976mI NZ001S 2026-01-12T14:01:05.632Z 2026-01-20T15:20:05.240Z
9179290 9179290 20260111152629_Gpwg4 NZ001S 2026-01-12T14:01:01.331Z 2026-01-20T15:20:03.751Z
9179279 9179279 20260111151921_n1uMW NZ001S 2026-01-12T14:00:58.601Z 2026-01-20T15:20:01.924Z
9179276 9179276 20260111151916_cmQMI NZ001S 2026-01-12T14:00:57.921Z 2026-01-20T15:20:01.559Z
9179223 9179223 20260111145350_k2PDO NZ001S 2026-01-12T14:00:44.575Z 2026-01-20T15:19:55.815Z
9179170 9179170 20260111143231_SEajB NZ001S 2026-01-12T14:00:33.155Z 2026-01-20T15:19:38.498Z
9179134 9179134 20260111142129_BpYuc NZ001S 2026-01-12T14:00:24.212Z 2026-01-20T15:19:32.976Z
9178886 9178886 20260110142509_jXXG2 NZ001S 2026-01-11T14:15:56.863Z 2026-01-18T15:11:23.321Z
9178851 9178851 20260110142041_dtoK6 NZ001S 2026-01-11T14:15:51.227Z 2026-01-18T15:11:20.536Z
9178828 9178828 20260110141607_IQdey NZ001S 2026-01-11T14:15:48.498Z 2026-01-18T15:11:19.038Z
9178706 9178706 20260110134841_nYnm9 NZ001S 2026-01-11T14:15:34.842Z 2026-01-18T15:11:12.413Z
9178642 9178642 20260110133722_Z2Lxp NZ001S 2026-01-11T14:15:24.249Z 2026-01-18T15:11:09.691Z
9178429 9178429 20260110130817_X2A4A NZ001S 2026-01-11T14:14:52.960Z 2026-01-18T15:10:50.663Z
9178205 9178205 20260110123133_IQy2M NZ001S 2026-01-11T14:14:15.829Z 2026-01-18T15:10:39.013Z
9178194 9178194 20260110122948_WsFvW NZ001S 2026-01-11T14:14:14.835Z 2026-01-18T15:10:38.549Z
9178125 9178125 20260110122157_vw9h9 NZ001S 2026-01-11T14:14:05.391Z 2026-01-18T15:10:35.333Z
9178016 9178016 20260110120021_sIeBR NZ001S 2026-01-11T14:13:47.935Z 2026-01-18T15:10:21.373Z
9177872 9177872 20260110113551_wcQQ2 NZ001S 2026-01-11T14:13:22.802Z 2026-01-18T15:10:13.341Z
9177782 9177782 20260110111826_I2hRi NZ001S 2026-01-11T14:13:02.156Z 2026-01-18T15:10:08.641Z

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