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

3,554 rows where station_code = "NZ001C" 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
9233187 9233187 20260120133526_6xtlI NZ001C 2026-01-21T14:04:49.413Z 2026-01-29T15:00:48.754Z
9233097 9233097 20260120131955_2mPbU NZ001C 2026-01-21T14:04:30.723Z 2026-01-29T15:00:45.185Z
9233088 9233088 20260120131953_sA7pu NZ001C 2026-01-21T14:04:29.516Z 2026-01-29T15:00:44.941Z
9233058 9233058 20260120131708_12JMl NZ001C 2026-01-21T14:04:21.678Z 2026-01-29T15:00:43.769Z
9233017 9233017 20260120130622_9lms3 NZ001C 2026-01-21T14:04:14.491Z 2026-01-29T15:00:35.986Z
9232994 9232994 20260120130345_AEN26 NZ001C 2026-01-21T14:04:11.227Z 2026-01-29T15:00:34.575Z
9220625 9220625 20260118131535_vSUWH NZ001C 2026-01-19T14:04:58.217Z 2026-01-27T14:59:23.232Z
9220579 9220579 20260118131106_KxF3I NZ001C 2026-01-19T14:04:51.076Z 2026-01-27T14:59:21.275Z
9220539 9220539 20260118130726_3EEHY NZ001C 2026-01-19T14:04:41.237Z 2026-01-27T14:59:20.015Z
9220480 9220480 20260118125615_g93AT NZ001C 2026-01-19T14:04:24.137Z 2026-01-27T14:59:16.962Z
9220405 9220405 20260118124540_cRyO8 NZ001C 2026-01-19T14:04:02.098Z 2026-01-27T14:59:13.974Z
9220396 9220396 20260118124540_UiPNY NZ001C 2026-01-19T14:04:01.447Z 2026-01-27T14:59:13.866Z
9220368 9220368 20260118124301_uvEMp NZ001C 2026-01-19T14:03:56.641Z 2026-01-27T14:59:02.917Z
9089688 9089688 20251228133558_9GIn6 NZ001C 2025-12-30T14:48:58.813Z 2026-01-05T15:12:50.680Z
9089638 9089638 20251228133342_yhQkk NZ001C 2025-12-30T14:48:49.149Z 2026-01-05T15:12:49.735Z
9089174 9089174 20251228130015_2jYWb NZ001C 2025-12-30T14:48:02.592Z 2026-01-05T15:12:23.627Z
9088946 9088946 20251228123501_lh8Ru NZ001C 2025-12-30T14:47:30.671Z 2025-12-31T14:54:39.102Z
9088599 9088599 20251228120334_iqNz9 NZ001C 2025-12-30T14:46:48.138Z 2026-01-05T15:12:07.504Z
9088425 9088425 20251228114914_l4Qie NZ001C 2025-12-30T14:46:23.582Z 2026-01-05T15:11:51.322Z
9087716 9087716 20251228101921_wQcAE NZ001C 2025-12-30T14:44:48.948Z 2026-01-05T15:11:28.108Z
9087696 9087696 20251228101759_0h2at NZ001C 2025-12-30T14:44:47.562Z 2026-01-05T15:11:27.765Z
8968549 8968549 20251216153508_NLCcH NZ001C 2025-12-25T14:49:16.529Z 2025-12-25T14:49:16.529Z
8968523 8968523 20251216152917_fwtrr NZ001C 2025-12-25T14:49:14.941Z 2025-12-25T14:49:14.941Z
8965747 8965747 20251216110455_YUgWI NZ001C 2025-12-25T14:44:25.334Z 2025-12-25T14:44:25.334Z
8815939 8815939 20251213112708_26qem NZ001C 2025-12-17T14:27:26.598Z 2025-12-23T14:22:05.851Z
8815930 8815930 20251213112643_EtwNo NZ001C 2025-12-17T14:27:26.013Z 2025-12-23T14:22:05.841Z
8815578 8815578 20251213110840_V2Fpp NZ001C 2025-12-17T14:26:33.978Z 2025-12-23T14:21:49.368Z
8814018 8814018 20251213094332_1qPPJ NZ001C 2025-12-17T14:23:17.648Z 2025-12-23T14:20:29.052Z
8462741 8462741 20251114115435_r8g5n NZ001C 2025-11-16T14:00:25.680Z 2025-11-23T15:15:31.095Z
8367412 8367412 20251102122651_igNZg NZ001C 2025-11-04T14:37:14.937Z 2025-11-10T15:10:42.614Z
8367275 8367275 20251102121253_yUviP NZ001C 2025-11-04T14:37:04.839Z 2025-11-10T15:10:41.066Z
8360313 8360313 20251102151122_pYevQ NZ001C 2025-11-04T14:04:13.464Z 2025-11-11T15:02:30.505Z
8360120 8360120 20251102145345_65E2S NZ001C 2025-11-04T14:03:31.536Z 2025-11-11T15:02:27.894Z
8359904 8359904 20251102142736_NEy2S NZ001C 2025-11-04T14:02:34.414Z 2025-11-11T15:02:24.862Z
8359805 8359805 20251102141205_tY2f4 NZ001C 2025-11-04T14:02:12.266Z 2025-11-11T15:02:23.164Z
8359546 8359546 20251102132705_cC0HA NZ001C 2025-11-04T14:01:12.579Z 2025-11-11T15:02:19.709Z
8359497 8359497 20251102131636_cQ4AT NZ001C 2025-11-04T14:00:57.513Z 2025-11-11T15:02:18.861Z
8359431 8359431 20251102130619_eUTTZ NZ001C 2025-11-04T14:00:41.413Z 2025-11-11T15:02:17.923Z
8338923 8338923 20251031093716_qCNvU NZ001C 2025-11-02T14:33:21.178Z 2025-11-08T15:17:22.174Z
8329731 8329731 20251031161039_kTLsb NZ001C 2025-11-02T14:03:44.795Z 2025-11-09T14:58:13.270Z
8329651 8329651 20251031155735_DuWaC NZ001C 2025-11-02T14:03:29.644Z 2025-11-09T14:58:12.472Z
8329598 8329598 20251031154635_ZNSZ8 NZ001C 2025-11-02T14:03:24.026Z 2025-11-09T14:58:11.920Z
8329579 8329579 20251031154339_2OPNl NZ001C 2025-11-02T14:03:21.108Z 2025-11-09T14:58:11.673Z
8329502 8329502 20251031153232_ob40r NZ001C 2025-11-02T14:02:58.255Z 2025-11-09T14:58:10.663Z
8329402 8329402 20251031152146_OwN0Q NZ001C 2025-11-02T14:02:47.309Z 2025-11-09T14:58:09.748Z
8329383 8329383 20251031152001_TW7Zn NZ001C 2025-11-02T14:02:45.042Z 2025-11-09T14:58:09.499Z
8229008 8229008 20251023114816_OOgTg NZ001C 2025-10-26T12:54:50.522Z 2025-10-31T13:09:16.412Z
8228934 8228934 20251023100437_mbPVq NZ001C 2025-10-26T12:54:02.298Z 2025-10-31T13:09:05.125Z
8208824 8208824 20251023153419_YtFg0 NZ001C 2025-10-26T12:15:13.339Z 2025-11-01T13:09:21.109Z
8208774 8208774 20251023152251_jd93C NZ001C 2025-10-26T12:15:02.238Z 2025-11-01T13:09:20.190Z
8208757 8208757 20251023151806_aTdNq NZ001C 2025-10-26T12:14:58.052Z 2025-11-01T13:09:18.299Z
8208743 8208743 20251023151612_i6KWQ NZ001C 2025-10-26T12:14:44.919Z 2025-11-01T13:09:17.737Z
8208400 8208400 20251023132108_BTqdU NZ001C 2025-10-26T12:12:40.965Z 2025-11-01T13:09:01.741Z
8208377 8208377 20251023131233_PYxbX NZ001C 2025-10-26T12:12:27.202Z 2025-11-01T13:09:01.486Z
8198106 8198106 20251018110459_2pnTm NZ001C 2025-10-24T13:08:48.205Z 2025-10-26T13:16:29.328Z
8151247 8151247 20251018110459_mqpkt NZ001C 2025-10-20T12:43:48.626Z 2025-10-23T12:59:08.484Z
8151219 8151219 20251018104957_hG26J NZ001C 2025-10-20T12:43:21.377Z 2025-10-26T13:16:28.504Z
8151188 8151188 20251018102648_rA1FR NZ001C 2025-10-20T12:42:55.137Z 2025-10-26T13:16:27.369Z
8140523 8140523 20251018132357_fLwPO NZ001C 2025-10-20T12:03:16.882Z 2025-10-27T13:09:25.268Z
8140441 8140441 20251018125913_1KUrA NZ001C 2025-10-20T12:03:01.830Z 2025-10-27T13:09:24.579Z
8107959 8107959 20251014081702_0V2QR NZ001C 2025-10-16T12:31:46.890Z 2025-10-22T13:10:21.741Z
8102671 8102671 20251014151556_48DsI NZ001C 2025-10-16T12:07:53.843Z 2025-10-23T13:07:44.874Z
8071272 8071272 20251005164213_v6ld1 NZ001C 2025-10-08T12:13:20.967Z 2025-10-14T12:33:28.749Z
8071264 8071264 20251005163913_0dN8d NZ001C 2025-10-08T12:13:20.018Z 2025-10-14T12:33:28.690Z
8060031 8060031 20251005165049_dYfPp NZ001C 2025-10-07T12:08:07.138Z 2025-10-14T12:33:28.927Z
8059966 8059966 20251005162124_vSnWu NZ001C 2025-10-07T12:07:47.594Z 2025-10-14T12:33:28.182Z
8056897 8056897 20251002161359_YQp7J NZ001C 2025-10-05T12:21:01.774Z 2025-10-11T12:39:07.097Z
8049808 8049808 20251002143950_tLikE NZ001C 2025-10-04T12:39:25.327Z 2025-10-11T12:38:50.048Z
8036774 8036774 20251001165852_xiEoA NZ001C 2025-10-03T12:15:59.237Z 2025-10-10T12:38:45.502Z
8036746 8036746 20251001165607_LW3OA NZ001C 2025-10-03T12:15:56.675Z 2025-10-10T12:38:44.450Z
8034956 8034956 20251001120232_WsGu6 NZ001C 2025-10-03T12:10:47.925Z 2025-10-10T12:37:32.121Z
8015074 8015074 20250929164958_iPsPC NZ001C 2025-10-01T12:18:46.619Z 2025-10-08T12:42:03.054Z
8014535 8014535 20250929153654_IaV3e NZ001C 2025-10-01T12:17:00.682Z 2025-10-08T12:41:59.664Z
8014484 8014484 20250929153218_1lRWR NZ001C 2025-10-01T12:16:54.611Z 2025-10-08T12:41:59.341Z
8014459 8014459 20250929152648_GXvne NZ001C 2025-10-01T12:16:51.305Z 2025-10-08T12:41:59.215Z
8013672 8013672 20250929133259_UZEgQ NZ001C 2025-10-01T12:14:39.940Z 2025-10-08T12:41:54.199Z
8013423 8013423 20250929130048_s105V NZ001C 2025-10-01T12:14:03.995Z 2025-10-08T12:41:52.694Z
8013323 8013323 20250929124155_fCFJd NZ001C 2025-10-01T12:13:44.712Z 2025-10-08T12:41:52.298Z
8013072 8013072 20250929121404_wZ9JQ NZ001C 2025-10-01T12:13:05.985Z 2025-10-08T12:41:50.824Z
7979551 7979551 20250926135527_D8RGh NZ001C 2025-09-28T12:14:25.511Z 2025-10-05T13:09:22.052Z
7966203 7966203 20250925095831_R2IQV NZ001C 2025-09-27T12:03:45.978Z 2025-10-04T13:05:45.912Z
7965578 7965578 20250925083528_jCIqd NZ001C 2025-09-27T12:02:52.951Z 2025-10-04T13:05:36.946Z
7891214 7891214 20250919165625_mhPtw NZ001C 2025-09-21T12:31:05.258Z 2025-09-28T12:54:06.836Z
7888142 7888142 20250919123746_d62n5 NZ001C 2025-09-21T12:26:38.562Z 2025-09-28T12:53:54.471Z
7888084 7888084 20250919123435_XWvlp NZ001C 2025-09-21T12:26:32.788Z 2025-09-28T12:53:54.004Z
7887600 7887600 20250919114556_KTNgP NZ001C 2025-09-21T12:25:47.926Z 2025-09-28T12:53:50.829Z
7887293 7887293 20250919105917_QXfOV NZ001C 2025-09-21T12:25:00.257Z 2025-09-28T12:53:47.277Z
7887240 7887240 20250919105350_MmdAA NZ001C 2025-09-21T12:24:55.838Z 2025-09-28T12:53:47.108Z
7887177 7887177 20250919104240_2Pu7R NZ001C 2025-09-21T12:24:33.011Z 2025-09-28T12:53:45.808Z
7886844 7886844 20250919093742_CIZnT NZ001C 2025-09-21T12:23:31.246Z 2025-09-28T12:53:42.916Z
7877431 7877431 20250918122950_iwvxC NZ001C 2025-09-20T12:25:56.788Z 2025-09-27T12:47:07.385Z
7877413 7877413 20250918122529_V1kAL NZ001C 2025-09-20T12:25:55.787Z 2025-09-27T12:47:07.245Z
7877265 7877265 20250918115350_ZZmKq NZ001C 2025-09-20T12:25:30.507Z 2025-09-27T12:47:03.454Z
7877171 7877171 20250918113130_J0sm0 NZ001C 2025-09-20T12:25:14.654Z 2025-09-27T12:47:02.100Z
7877082 7877082 20250918111517_fe7Me NZ001C 2025-09-20T12:24:55.807Z 2025-09-27T12:46:57.330Z
7876808 7876808 20250918102614_FS00x NZ001C 2025-09-20T12:24:12.043Z 2025-09-27T12:46:53.124Z
6393210 6393210 20250325090940_FHSy8 NZ001C 2025-03-27T12:18:14.537Z 2025-04-02T13:36:28.534Z
6393202 6393202 20250325090619_ogyR2 NZ001C 2025-03-27T12:18:12.644Z 2025-04-02T13:36:27.593Z
6387110 6387110 20250324085132_OmJ9B NZ001C 2025-03-26T12:17:28.726Z 2025-04-01T13:00:39.685Z
6381272 6381272 20250323131309_gK50F NZ001C 2025-03-25T12:15:59.103Z 2025-03-31T13:07:59.761Z

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