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

4,207 rows where station_code = "NZ003G" 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
9270257 9270257 20260128152301_I6NOk NZ003G 2026-01-29T14:11:27.700Z 2026-01-29T14:11:27.700Z
9269824 9269824 20260128141812_6GorN NZ003G 2026-01-29T14:09:45.906Z 2026-01-29T14:09:45.906Z
9269796 9269796 20260128141516_9es8O NZ003G 2026-01-29T14:09:40.350Z 2026-01-29T14:09:40.350Z
9269457 9269457 20260128131951_BsJy4 NZ003G 2026-01-29T14:08:03.019Z 2026-01-29T14:08:03.019Z
9269328 9269328 20260128130226_OmACH NZ003G 2026-01-29T14:07:28.636Z 2026-01-29T14:07:28.636Z
9269098 9269098 20260128122642_rhmOO NZ003G 2026-01-29T14:06:30.732Z 2026-01-29T14:06:30.732Z
9265985 9265985 20260127162831_xrExR NZ003G 2026-01-28T14:11:58.712Z 2026-01-29T14:30:24.806Z
9265916 9265916 20260127161607_WXRPa NZ003G 2026-01-28T14:11:45.036Z 2026-01-29T14:30:24.737Z
9265560 9265560 20260127153243_yzkOU NZ003G 2026-01-28T14:10:34.435Z 2026-01-29T14:30:24.612Z
9265538 9265538 20260127153037_3FUcU NZ003G 2026-01-28T14:10:28.777Z 2026-01-29T14:30:24.601Z
9265481 9265481 20260127152116_lJeDl NZ003G 2026-01-28T14:10:20.649Z 2026-01-29T14:30:24.590Z
9265406 9265406 20260127151225_lSK4M NZ003G 2026-01-28T14:10:03.556Z 2026-01-29T14:30:24.543Z
9264685 9264685 20260127125712_OxdkO NZ003G 2026-01-28T14:07:10.477Z 2026-01-29T14:30:24.255Z
9264273 9264273 20260127115330_82zEK NZ003G 2026-01-28T14:05:15.208Z 2026-01-29T14:30:20.574Z
9264015 9264015 20260127105701_Ajf8F NZ003G 2026-01-28T14:03:57.425Z 2026-01-29T14:30:19.999Z
9257731 9257731 20260125154418_CnEC2 NZ003G 2026-01-26T14:07:30.522Z 2026-01-29T14:37:37.446Z
9257593 9257593 20260125144827_efSR6 NZ003G 2026-01-26T14:06:33.567Z 2026-01-29T14:37:29.423Z
9257336 9257336 20260125125337_Q98UA NZ003G 2026-01-26T14:04:48.324Z 2026-01-29T14:37:06.136Z
9256933 9256933 20260125111111_ia7es NZ003G 2026-01-26T14:02:50.169Z 2026-01-29T14:36:37.126Z
9256686 9256686 20260125100012_MUe9g NZ003G 2026-01-26T14:01:25.411Z 2026-01-29T14:36:16.376Z
9253912 9253912 20260124154355_RGPJY NZ003G 2026-01-25T14:04:58.000Z 2026-01-29T14:41:47.839Z
9253846 9253846 20260124151115_C0C2W NZ003G 2026-01-25T14:04:38.809Z 2026-01-29T14:41:41.558Z
9250442 9250442 20260123150018_DVLGM NZ003G 2026-01-24T14:02:58.216Z 2026-01-29T14:45:35.122Z
9250128 9250128 20260123103722_H3WYn NZ003G 2026-01-24T14:01:19.447Z 2026-01-29T14:45:00.910Z
9246060 9246060 20260122161850_3qjY3 NZ003G 2026-01-23T14:04:37.699Z 2026-01-29T14:50:40.723Z
9245678 9245678 20260122134218_5xSdk NZ003G 2026-01-23T14:02:57.898Z 2026-01-29T14:49:56.891Z
9245616 9245616 20260122132238_3lrCU NZ003G 2026-01-23T14:02:37.958Z 2026-01-29T14:49:51.005Z
9245479 9245479 20260122124009_TbZbU NZ003G 2026-01-23T14:02:10.142Z 2026-01-29T14:49:43.105Z
9239919 9239919 20260121140446_f3fv4 NZ003G 2026-01-22T14:03:46.882Z 2026-01-29T14:55:08.299Z
9211097 9211097 20260116155506_vmJQ4 NZ003G 2026-01-17T14:04:19.694Z 2026-01-25T14:57:20.960Z
9193422 9193422 20260113143956_CiJko NZ003G 2026-01-14T14:01:19.443Z 2026-01-22T15:06:17.770Z
9185571 9185571 20260111120235_RidSa NZ003G 2026-01-12T14:25:13.063Z 2026-01-19T15:21:06.493Z
9185568 9185568 20260111120142_giYVb NZ003G 2026-01-12T14:25:12.749Z 2026-01-19T15:21:06.396Z
9185479 9185479 20260111111845_91Fvi NZ003G 2026-01-12T14:25:02.235Z 2026-01-19T15:20:53.844Z
9185448 9185448 20260111110920_xa23m NZ003G 2026-01-12T14:24:49.346Z 2026-01-19T15:20:32.765Z
9184060 9184060 20260111103836_NSe1v NZ003G 2026-01-12T14:19:34.678Z 2026-01-12T14:19:34.678Z
9183804 9183804 20260111101719_414Dc NZ003G 2026-01-12T14:18:50.462Z 2026-01-12T14:18:50.462Z
9183792 9183792 20260111101614_jhuZC NZ003G 2026-01-12T14:18:49.059Z 2026-01-19T15:20:11.944Z
9183463 9183463 20260111093159_RkR2c NZ003G 2026-01-12T14:17:51.860Z 2026-01-19T15:19:40.494Z
9183418 9183418 20260111092745_NVZ6n NZ003G 2026-01-12T14:17:45.229Z 2026-01-12T14:17:45.229Z
9178983 9178983 20260110143804_byNSu NZ003G 2026-01-11T14:16:10.607Z 2026-01-18T15:11:31.679Z
9178820 9178820 20260110141457_Cg1nO NZ003G 2026-01-11T14:15:47.755Z 2026-01-18T15:11:18.661Z
9178756 9178756 20260110140334_RcNlV NZ003G 2026-01-11T14:15:40.646Z 2026-01-18T15:11:15.829Z
9178746 9178746 20260110140014_NqR0f NZ003G 2026-01-11T14:15:39.152Z 2026-01-18T15:11:15.210Z
9178406 9178406 20260110130524_3A8Z3 NZ003G 2026-01-11T14:14:46.605Z 2026-01-18T15:10:48.519Z
9178069 9178069 20260110120800_YT7Pu NZ003G 2026-01-11T14:13:55.377Z 2026-01-18T15:10:27.585Z
9177887 9177887 20260110113809_3d8OS NZ003G 2026-01-11T14:13:24.587Z 2026-01-18T15:10:13.741Z
9177757 9177757 20260110111433_3XGgN NZ003G 2026-01-11T14:12:58.187Z 2026-01-18T15:10:07.495Z
9177751 9177751 20260110111315_VYluQ NZ003G 2026-01-11T14:12:57.328Z 2026-01-18T15:10:07.168Z
9177342 9177342 20260110092514_WefDN NZ003G 2026-01-11T14:11:41.341Z 2026-01-18T15:09:38.333Z
9174289 9174289 20260110160208_0efAc NZ003G 2026-01-11T14:02:02.634Z 2026-01-19T15:14:47.401Z
9174150 9174150 20260110154041_NtPkr NZ003G 2026-01-11T14:01:34.953Z 2026-01-19T15:14:37.927Z
9173927 9173927 20260110150350_uivkW NZ003G 2026-01-11T14:00:45.353Z 2026-01-19T15:14:27.988Z
9173074 9173074 20260109125555_CKkgX NZ003G 2026-01-10T14:16:03.023Z 2026-01-17T15:26:14.523Z
9172411 9172411 20260109103441_4PdzY NZ003G 2026-01-10T14:13:12.744Z 2026-01-17T15:25:28.502Z
9170542 9170542 20260109153859_X3meC NZ003G 2026-01-10T14:01:11.474Z 2026-01-18T15:06:27.249Z
9169701 9169701 20260108153112_K8YF8 NZ003G 2026-01-09T14:14:23.803Z 2026-01-16T15:14:26.383Z
9169557 9169557 20260108145752_eGieP NZ003G 2026-01-09T14:13:58.314Z 2026-01-16T15:14:07.854Z
9169419 9169419 20260108142709_LSt6N NZ003G 2026-01-09T14:13:31.831Z 2026-01-16T15:13:57.307Z
9169352 9169352 20260108141823_mzIN9 NZ003G 2026-01-09T14:13:20.552Z 2026-01-16T15:13:54.052Z
9169309 9169309 20260108140724_LROq1 NZ003G 2026-01-09T14:13:14.113Z 2026-01-16T15:13:50.930Z
9169300 9169300 20260108140632_LQbIw NZ003G 2026-01-09T14:13:13.234Z 2026-01-16T15:13:50.303Z
9169190 9169190 20260108134047_g3Gf4 NZ003G 2026-01-09T14:12:56.465Z 2026-01-16T15:13:34.734Z
9169090 9169090 20260108132000_uHMja NZ003G 2026-01-09T14:12:44.185Z 2026-01-16T15:13:28.873Z
9168927 9168927 20260108124406_m58Qb NZ003G 2026-01-09T14:12:22.553Z 2026-01-16T15:13:21.442Z
9168696 9168696 20260108120144_BAZGB NZ003G 2026-01-09T14:11:46.747Z 2026-01-16T15:12:58.621Z
9168671 9168671 20260108115553_ekCmf NZ003G 2026-01-09T14:11:43.468Z 2026-01-16T15:12:57.667Z
9168599 9168599 20260108112949_mYa52 NZ003G 2026-01-09T14:11:30.686Z 2026-01-16T15:12:52.831Z
9168596 9168596 20260108112803_zHWrC NZ003G 2026-01-09T14:11:29.081Z 2026-01-16T15:12:52.643Z
9168274 9168274 20260108102715_utKZw NZ003G 2026-01-09T14:10:44.847Z 2026-01-16T15:12:26.853Z
9168124 9168124 20260108095844_4hPot NZ003G 2026-01-09T14:10:22.323Z 2026-01-16T15:12:19.645Z
9168113 9168113 20260108095624_1uZ05 NZ003G 2026-01-09T14:10:20.897Z 2026-01-16T15:12:18.977Z
9168074 9168074 20260108094800_mrRWY NZ003G 2026-01-09T14:10:16.090Z 2026-01-16T15:12:17.545Z
9168052 9168052 20260108094336_cY2JZ NZ003G 2026-01-09T14:10:13.469Z 2026-01-16T15:12:16.654Z
9166026 9166026 20260108161633_HxRSR NZ003G 2026-01-09T14:00:59.973Z 2026-01-17T15:22:54.434Z
9165916 9165916 20260108153716_0nETC NZ003G 2026-01-09T14:00:18.571Z 2026-01-17T15:22:43.777Z
9165420 9165420 20260107154552_MrflM NZ003G 2026-01-08T14:16:21.036Z 2026-01-13T15:05:54.851Z
9165087 9165087 20260107150341_Mc9lU NZ003G 2026-01-08T14:15:23.504Z 2026-01-13T15:05:28.154Z
9164929 9164929 20260107144532_ya3pA NZ003G 2026-01-08T14:14:49.943Z 2026-01-13T15:05:20.058Z
9164402 9164402 20260107130934_sBES2 NZ003G 2026-01-08T14:13:02.975Z 2026-01-13T15:04:33.319Z
9164281 9164281 20260107124348_pPAF6 NZ003G 2026-01-08T14:12:33.526Z 2026-01-13T15:04:23.980Z
9156486 9156486 20260104111407_djYaq NZ003G 2026-01-06T14:39:43.444Z 2026-01-12T15:12:12.378Z
9153069 9153069 20260105160155_1Ly5c NZ003G 2026-01-06T14:19:29.763Z 2026-01-13T15:16:57.750Z
9132986 9132986 20260103114222_SokhM NZ003G 2026-01-04T14:19:20.726Z 2026-01-10T15:02:19.645Z
9132830 9132830 20260103105800_uO3Rz NZ003G 2026-01-04T14:18:31.817Z 2026-01-10T15:02:03.954Z
9132748 9132748 20260103101247_MYtQk NZ003G 2026-01-04T14:18:05.661Z 2026-01-10T15:01:55.943Z
9128510 9128510 20260102143037_Eo6N0 NZ003G 2026-01-03T14:15:56.526Z 2026-01-09T14:50:56.500Z
9123026 9123026 20260101161219_eYvnq NZ003G 2026-01-02T14:16:14.303Z 2026-01-09T14:54:08.446Z
9122912 9122912 20260101150916_n6umx NZ003G 2026-01-02T14:15:44.587Z 2026-01-09T14:54:01.402Z
9122836 9122836 20260101140925_pwP3M NZ003G 2026-01-02T14:15:21.330Z 2026-01-09T14:53:56.799Z
9122786 9122786 20260101130830_1bGoU NZ003G 2026-01-02T14:15:04.033Z 2026-01-09T14:53:53.841Z
9122778 9122778 20260101130709_WZuMl NZ003G 2026-01-02T14:15:01.294Z 2026-01-09T14:53:53.361Z
9118467 9118467 20251231152115_oCXWX NZ003G 2026-01-01T14:35:40.206Z 2026-01-08T15:14:41.348Z
9118391 9118391 20251231145300_OAhv2 NZ003G 2026-01-01T14:35:17.295Z 2026-01-01T14:57:56.219Z
9118323 9118323 20251231143620_Vj25N NZ003G 2026-01-01T14:35:07.195Z 2026-01-01T14:57:56.172Z
9118295 9118295 20251231142847_22vk6 NZ003G 2026-01-01T14:35:01.549Z 2026-01-08T15:14:20.493Z
9118238 9118238 20251231140507_f2sir NZ003G 2026-01-01T14:34:39.255Z 2026-01-01T14:57:56.106Z
9105937 9105937 20251230143013_ol9QL NZ003G 2025-12-31T14:27:05.381Z 2026-01-07T15:11:25.269Z
9094236 9094236 20251227115817_m53v2 NZ003G 2025-12-30T15:05:05.989Z 2025-12-30T15:05:05.989Z
9093905 9093905 20251227110410_U3t9A NZ003G 2025-12-30T15:04:29.967Z 2026-01-04T15:31:14.866Z

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