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,313 rows where station_code = "NZ001N" 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
9270668 9270668 20260128162011_gc5bC NZ001N 2026-01-29T14:13:15.378Z 2026-01-29T14:13:15.378Z
9270656 9270656 20260128161827_RUhKm NZ001N 2026-01-29T14:13:13.382Z 2026-01-29T14:13:13.382Z
9270325 9270325 20260128153132_uTx08 NZ001N 2026-01-29T14:11:46.099Z 2026-01-29T14:11:46.099Z
9270215 9270215 20260128151739_bP5XR NZ001N 2026-01-29T14:11:20.455Z 2026-01-29T14:11:20.455Z
9270196 9270196 20260128151345_FLV2O NZ001N 2026-01-29T14:11:16.496Z 2026-01-29T14:11:16.496Z
9270131 9270131 20260128145842_HMpEf NZ001N 2026-01-29T14:10:58.125Z 2026-01-29T14:10:58.125Z
9269849 9269849 20260128142513_pM1Rj NZ001N 2026-01-29T14:09:53.441Z 2026-01-29T14:09:53.441Z
9269821 9269821 20260128141744_f0OxR NZ001N 2026-01-29T14:09:45.392Z 2026-01-29T14:09:45.392Z
9269813 9269813 20260128141730_5x3RH NZ001N 2026-01-29T14:09:44.068Z 2026-01-29T14:09:44.068Z
9269745 9269745 20260128140553_MJ3u3 NZ001N 2026-01-29T14:09:29.126Z 2026-01-29T14:09:29.126Z
9269646 9269646 20260128134907_p25nc NZ001N 2026-01-29T14:08:56.524Z 2026-01-29T14:08:56.524Z
9269546 9269546 20260128133059_jP2i2 NZ001N 2026-01-29T14:08:26.663Z 2026-01-29T14:08:26.663Z
9269453 9269453 20260128131929_igD8S NZ001N 2026-01-29T14:08:02.451Z 2026-01-29T14:08:02.451Z
9269430 9269430 20260128131708_hnE3l NZ001N 2026-01-29T14:07:58.412Z 2026-01-29T14:07:58.412Z
9269416 9269416 20260128131412_c0sUS NZ001N 2026-01-29T14:07:54.600Z 2026-01-29T14:07:54.600Z
9269377 9269377 20260128130958_QcIAN NZ001N 2026-01-29T14:07:42.648Z 2026-01-29T14:07:42.648Z
9269262 9269262 20260128125218_c3fLr NZ001N 2026-01-29T14:07:11.038Z 2026-01-29T14:07:11.038Z
9268842 9268842 20260128113213_b2rXJ NZ001N 2026-01-29T14:05:09.479Z 2026-01-29T14:05:09.479Z
9268771 9268771 20260128111752_sYej1 NZ001N 2026-01-29T14:04:49.729Z 2026-01-29T14:04:49.729Z
9268479 9268479 20260128102751_9NMN3 NZ001N 2026-01-29T14:03:18.269Z 2026-01-29T14:03:18.269Z
9265947 9265947 20260127161810_d7iZP NZ001N 2026-01-28T14:11:50.073Z 2026-01-29T14:30:24.742Z
9265861 9265861 20260127160650_45VsP NZ001N 2026-01-28T14:11:37.094Z 2026-01-29T14:30:24.703Z
9265852 9265852 20260127160510_yT6qZ NZ001N 2026-01-28T14:11:36.073Z 2026-01-29T14:30:24.692Z
9265733 9265733 20260127155417_6g26O NZ001N 2026-01-28T14:11:11.063Z 2026-01-29T14:30:24.664Z
9265181 9265181 20260127143215_lshub NZ001N 2026-01-28T14:09:21.671Z 2026-01-29T14:30:24.495Z
9265095 9265095 20260127141555_IaJuH NZ001N 2026-01-28T14:09:01.787Z 2026-01-29T14:30:24.447Z
9265011 9265011 20260127135451_lMAZO NZ001N 2026-01-28T14:08:38.890Z 2026-01-29T14:30:24.413Z
9265000 9265000 20260127135258_tiLex NZ001N 2026-01-28T14:08:34.724Z 2026-01-29T14:30:24.411Z
9257637 9257637 20260125150821_oPESF NZ001N 2026-01-26T14:06:53.667Z 2026-01-29T14:37:31.973Z
9257632 9257632 20260125150601_YaJ27 NZ001N 2026-01-26T14:06:51.914Z 2026-01-29T14:37:31.690Z
9257629 9257629 20260125150512_hQPbf NZ001N 2026-01-26T14:06:50.905Z 2026-01-29T14:37:31.484Z
9257545 9257545 20260125142729_7Ktr8 NZ001N 2026-01-26T14:06:15.085Z 2026-01-29T14:37:26.755Z
9257270 9257270 20260125123937_K09Vc NZ001N 2026-01-26T14:04:31.702Z 2026-01-29T14:37:03.145Z
9257253 9257253 20260125123507_GNsgD NZ001N 2026-01-26T14:04:27.460Z 2026-01-29T14:37:01.925Z
9257251 9257251 20260125123438_KniOp NZ001N 2026-01-26T14:04:26.929Z 2026-01-29T14:37:01.641Z
9257129 9257129 20260125120324_7Q9XO NZ001N 2026-01-26T14:03:47.670Z 2026-01-29T14:36:50.174Z
9257114 9257114 20260125115855_xuzXm NZ001N 2026-01-26T14:03:44.581Z 2026-01-29T14:36:47.455Z
9257090 9257090 20260125115014_7G69R NZ001N 2026-01-26T14:03:38.122Z 2026-01-29T14:36:45.901Z
9253951 9253951 20260124160828_s3SpF NZ001N 2026-01-25T14:05:08.361Z 2026-01-29T14:41:53.586Z
9253881 9253881 20260124153225_k2z3t NZ001N 2026-01-25T14:04:51.289Z 2026-01-29T14:41:45.551Z
9253875 9253875 20260124153207_MWrad NZ001N 2026-01-25T14:04:47.011Z 2026-01-29T14:41:45.224Z
9253835 9253835 20260124150905_SJqj5 NZ001N 2026-01-25T14:04:37.604Z 2026-01-29T14:41:41.035Z
9253754 9253754 20260124142442_foZ6O NZ001N 2026-01-25T14:04:14.872Z 2026-01-29T14:41:24.756Z
9253705 9253705 20260124135726_R6W9E NZ001N 2026-01-25T14:04:02.927Z 2026-01-29T14:41:18.678Z
9253633 9253633 20260124131447_32ED1 NZ001N 2026-01-25T14:03:39.092Z 2026-01-29T14:41:05.325Z
9253615 9253615 20260124130847_Ey6q3 NZ001N 2026-01-25T14:03:34.443Z 2026-01-29T14:41:04.247Z
9253611 9253611 20260124130725_p2oCP NZ001N 2026-01-25T14:03:32.072Z 2026-01-29T14:41:03.833Z
9253599 9253599 20260124125804_2H8qP NZ001N 2026-01-25T14:03:28.810Z 2026-01-29T14:41:02.286Z
9253584 9253584 20260124125216_9IYVS NZ001N 2026-01-25T14:03:25.026Z 2026-01-29T14:40:59.332Z
9253562 9253562 20260124124754_6vY1Q NZ001N 2026-01-25T14:03:20.891Z 2026-01-29T14:40:57.914Z
9253469 9253469 20260124120549_d827q NZ001N 2026-01-25T14:02:55.857Z 2026-01-29T14:40:52.223Z
9253361 9253361 20260124111319_gZyfm NZ001N 2026-01-25T14:02:16.023Z 2026-01-29T14:40:44.108Z
9253335 9253335 20260124110258_mN2DD NZ001N 2026-01-25T14:02:08.143Z 2026-01-29T14:40:39.102Z
9253170 9253170 20260124095404_m3Aif NZ001N 2026-01-25T14:01:06.930Z 2026-01-29T14:40:23.500Z
9250432 9250432 20260123145224_x66eE NZ001N 2026-01-24T14:02:54.761Z 2026-01-29T14:45:33.930Z
9250421 9250421 20260123144020_XdBE8 NZ001N 2026-01-24T14:02:51.917Z 2026-01-29T14:45:33.071Z
9250010 9250010 20260123093538_8colr NZ001N 2026-01-24T14:00:37.054Z 2026-01-29T14:44:47.683Z
9249974 9249974 20260123091907_JxNjb NZ001N 2026-01-24T14:00:24.436Z 2026-01-29T14:44:45.780Z
9249787 9249787 20260122084533_31LJa NZ001N 2026-01-23T14:16:14.598Z 2026-01-29T14:58:55.469Z
9245781 9245781 20260122142850_AcyCO NZ001N 2026-01-23T14:03:28.846Z 2026-01-29T14:50:12.010Z
9245735 9245735 20260122140645_y2QdH NZ001N 2026-01-23T14:03:12.192Z 2026-01-29T14:50:06.641Z
9245612 9245612 20260122132159_3uaaf NZ001N 2026-01-23T14:02:37.418Z 2026-01-29T14:49:50.826Z
9245577 9245577 20260122131123_9EIhZ NZ001N 2026-01-23T14:02:27.253Z 2026-01-29T14:49:48.797Z
9245417 9245417 20260122121820_757qD NZ001N 2026-01-23T14:01:53.349Z 2026-01-29T14:49:32.522Z
9225256 9225256 20260118085305_9U8Wp NZ001N 2026-01-19T14:28:16.681Z 2026-01-26T15:04:16.353Z
9216098 9216098 20260116114946_LDPvL NZ001N 2026-01-17T14:27:55.969Z 2026-01-24T15:15:28.139Z
9215700 9215700 20260116104852_sZq24 NZ001N 2026-01-17T14:26:37.606Z 2026-01-24T15:15:10.135Z
9215520 9215520 20260116102341_qJ7Kq NZ001N 2026-01-17T14:25:58.527Z 2026-01-24T15:15:01.119Z
9215440 9215440 20260116101358_SPkIH NZ001N 2026-01-17T14:25:35.669Z 2026-01-24T15:14:51.711Z
9214912 9214912 20260116084421_b9Qbe NZ001N 2026-01-17T14:23:43.609Z 2026-01-24T15:14:20.183Z
9205598 9205598 20260114121650_td0Id NZ001N 2026-01-15T14:31:38.824Z 2026-01-22T15:11:15.678Z
9196929 9196929 20260113094025_P44cX NZ001N 2026-01-14T14:20:43.702Z 2026-01-21T15:06:08.522Z
9196925 9196925 20260113093805_xtbLo NZ001N 2026-01-14T14:20:42.547Z 2026-01-21T15:06:08.061Z
9196791 9196791 20260113090442_1jHWA NZ001N 2026-01-14T14:20:08.652Z 2026-01-21T15:05:56.655Z
9196734 9196734 20260113085246_UsvVS NZ001N 2026-01-14T14:19:50.049Z 2026-01-21T15:05:37.380Z
9193159 9193159 20260112134238_tKxCz NZ001N 2026-01-13T14:30:18.840Z 2026-01-20T15:27:01.558Z
9192989 9192989 20260112132426_8ezkS NZ001N 2026-01-13T14:29:55.424Z 2026-01-20T15:26:53.928Z
9192855 9192855 20260112130945_GzLzW NZ001N 2026-01-13T14:29:31.152Z 2026-01-20T15:26:37.222Z
9192824 9192824 20260112130508_QYoSS NZ001N 2026-01-13T14:29:25.621Z 2026-01-20T15:26:34.347Z
9192752 9192752 20260112125725_2shvR NZ001N 2026-01-13T14:29:10.169Z 2026-01-20T15:26:31.802Z
9192400 9192400 20260112123129_w5PJA NZ001N 2026-01-13T14:28:15.694Z 2026-01-20T15:26:21.065Z
9192147 9192147 20260112120918_q8QF6 NZ001N 2026-01-13T14:27:36.522Z 2026-01-20T15:26:00.642Z
9192054 9192054 20260112120339_vJvTe NZ001N 2026-01-13T14:27:18.120Z 2026-01-20T15:25:57.916Z
9191403 9191403 20260112110401_hjIGu NZ001N 2026-01-13T14:25:16.620Z 2026-01-20T15:25:23.843Z
9191154 9191154 20260112104021_xXEin NZ001N 2026-01-13T14:24:34.320Z 2026-01-20T15:25:12.355Z
9190947 9190947 20260112101727_Isuja NZ001N 2026-01-13T14:23:58.888Z 2026-01-20T15:25:04.820Z
9190754 9190754 20260112095303_Vr5v7 NZ001N 2026-01-13T14:23:23.035Z 2026-01-20T15:24:46.951Z
9190588 9190588 20260112092622_3aXD0 NZ001N 2026-01-13T14:22:49.428Z 2026-01-20T15:24:40.095Z
9190558 9190558 20260112092256_mjQoU NZ001N 2026-01-13T14:22:42.860Z 2026-01-20T15:24:39.258Z
9187039 9187039 20260111144919_rvTVm NZ001N 2026-01-13T14:05:05.613Z 2026-01-20T15:19:54.785Z
9186863 9186863 20260112155837_KuTes NZ001N 2026-01-13T14:03:46.556Z 2026-01-21T15:03:07.911Z
9186746 9186746 20260112153219_wMbpq NZ001N 2026-01-13T14:03:20.965Z 2026-01-13T14:03:20.965Z
9186688 9186688 20260112152239_40Wvk NZ001N 2026-01-13T14:03:07.274Z 2026-01-21T15:02:53.427Z
9186647 9186647 20260112151436_92rkw NZ001N 2026-01-13T14:02:50.646Z 2026-01-21T15:02:49.110Z
9186381 9186381 20260112142931_EKbgj NZ001N 2026-01-13T14:01:43.786Z 2026-01-21T15:02:27.860Z
9186101 9186101 20260112134851_S2xb4 NZ001N 2026-01-13T14:00:16.349Z 2026-01-21T15:02:12.026Z
9185877 9185877 20260111133554_w2EVb NZ001N 2026-01-12T14:26:11.983Z 2026-01-19T15:21:59.942Z
9185834 9185834 20260111132405_DWKxH NZ001N 2026-01-12T14:26:06.364Z 2026-01-19T15:21:56.585Z
9185716 9185716 20260111125349_Z5ssp NZ001N 2026-01-12T14:25:45.281Z 2026-01-19T15:21:44.355Z
9185515 9185515 20260111112911_DjR8O NZ001N 2026-01-12T14:25:06.485Z 2026-01-19T15:20:58.325Z

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