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

8,033 rows where station_code = "NZ001H" 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
9270539 9270539 20260128155857_f2V52 NZ001H 2026-01-29T14:12:42.186Z 2026-01-29T14:12:42.186Z
9270114 9270114 20260128145749_DrPJb NZ001H 2026-01-29T14:10:55.681Z 2026-01-29T14:10:55.681Z
9269801 9269801 20260128141617_Zbcxz NZ001H 2026-01-29T14:09:42.252Z 2026-01-29T14:09:42.252Z
9269760 9269760 20260128140910_UCJPu NZ001H 2026-01-29T14:09:32.153Z 2026-01-29T14:09:32.153Z
9269734 9269734 20260128140215_uZA0b NZ001H 2026-01-29T14:09:21.159Z 2026-01-29T14:09:21.159Z
9269663 9269663 20260128135217_SfQeS NZ001H 2026-01-29T14:09:00.801Z 2026-01-29T14:09:00.801Z
9269434 9269434 20260128131834_dSz7j NZ001H 2026-01-29T14:07:59.094Z 2026-01-29T14:07:59.094Z
9269322 9269322 20260128130216_Fn1s4 NZ001H 2026-01-29T14:07:28.166Z 2026-01-29T14:07:28.166Z
9269228 9269228 20260128124942_m3qY2 NZ001H 2026-01-29T14:07:03.646Z 2026-01-29T14:07:03.646Z
9269149 9269149 20260128123825_oxqXU NZ001H 2026-01-29T14:06:44.230Z 2026-01-29T14:06:44.230Z
9269142 9269142 20260128123800_ejW3Z NZ001H 2026-01-29T14:06:41.589Z 2026-01-29T14:06:41.589Z
9268793 9268793 20260128112346_vtp6Z NZ001H 2026-01-29T14:04:53.784Z 2026-01-29T14:04:53.784Z
9268742 9268742 20260128111357_o2D7o NZ001H 2026-01-29T14:04:42.089Z 2026-01-29T14:04:42.089Z
9268286 9268286 20260128094449_zDRlN NZ001H 2026-01-29T14:02:13.127Z 2026-01-29T14:02:13.127Z
9261678 9261678 20260126124708_yVCL0 NZ001H 2026-01-27T14:05:04.919Z 2026-01-29T14:32:48.162Z
9261156 9261156 20260126100421_Z2qgG NZ001H 2026-01-27T14:02:16.412Z 2026-01-29T14:32:00.128Z
9260909 9260909 20260126083705_69Qg6 NZ001H 2026-01-27T14:00:47.089Z 2026-01-29T14:31:13.098Z
9257663 9257663 20260125152000_CQgZ4 NZ001H 2026-01-26T14:07:04.958Z 2026-01-29T14:37:33.688Z
9257583 9257583 20260125144717_EBhhT NZ001H 2026-01-26T14:06:31.179Z 2026-01-29T14:37:29.001Z
9257567 9257567 20260125144111_sNRVb NZ001H 2026-01-26T14:06:26.305Z 2026-01-29T14:37:28.115Z
9256801 9256801 20260125103349_FSh7t NZ001H 2026-01-26T14:02:05.750Z 2026-01-29T14:36:25.003Z
9256694 9256694 20260125100246_xtkjd NZ001H 2026-01-26T14:01:28.557Z 2026-01-29T14:36:17.092Z
9253917 9253917 20260124154524_HzRYa NZ001H 2026-01-25T14:04:59.310Z 2026-01-29T14:41:48.581Z
9253869 9253869 20260124152438_Iqy37 NZ001H 2026-01-25T14:04:45.819Z 2026-01-29T14:41:44.401Z
9253734 9253734 20260124141347_9wVFh NZ001H 2026-01-25T14:04:09.908Z 2026-01-29T14:41:21.803Z
9253655 9253655 20260124132438_UjFHx NZ001H 2026-01-25T14:03:47.193Z 2026-01-29T14:41:13.118Z
9253637 9253637 20260124131559_Dh2r9 NZ001H 2026-01-25T14:03:41.973Z 2026-01-29T14:41:05.543Z
9253545 9253545 20260124123746_3TuJ3 NZ001H 2026-01-25T14:03:15.544Z 2026-01-29T14:40:56.952Z
9253538 9253538 20260124123728_AqVA0 NZ001H 2026-01-25T14:03:14.774Z 2026-01-29T14:40:56.871Z
9253503 9253503 20260124121624_5Mgpt NZ001H 2026-01-25T14:03:03.056Z 2026-01-29T14:40:54.158Z
9253482 9253482 20260124120750_2O9Li NZ001H 2026-01-25T14:02:57.676Z 2026-01-29T14:40:52.692Z
9253442 9253442 20260124114910_meEs5 NZ001H 2026-01-25T14:02:44.835Z 2026-01-29T14:40:50.467Z
9250497 9250497 20260123153553_Vuj23 NZ001H 2026-01-24T14:03:15.357Z 2026-01-29T14:45:41.178Z
9250289 9250289 20260123122131_j4Fcu NZ001H 2026-01-24T14:02:08.324Z 2026-01-29T14:45:13.251Z
9250226 9250226 20260123111523_LET30 NZ001H 2026-01-24T14:01:48.007Z 2026-01-29T14:45:06.782Z
9250210 9250210 20260123110515_bvk4t NZ001H 2026-01-24T14:01:42.023Z 2026-01-29T14:45:05.845Z
9245489 9245489 20260122124629_VA26s NZ001H 2026-01-23T14:02:12.138Z 2026-01-29T14:49:43.695Z
9245487 9245487 20260122124623_Rfr3P NZ001H 2026-01-23T14:02:11.724Z 2026-01-29T14:49:43.659Z
9185296 9185296 20260111135243_wMHP2 NZ001H 2026-01-12T14:22:59.508Z 2026-01-19T15:22:05.005Z
9185207 9185207 20260111132702_Q5Q8U NZ001H 2026-01-12T14:22:45.355Z 2026-01-19T15:21:57.789Z
9185115 9185115 20260111130924_IPJh0 NZ001H 2026-01-12T14:22:31.039Z 2026-01-19T15:21:50.752Z
9185005 9185005 20260111125606_3QOmH NZ001H 2026-01-12T14:22:11.306Z 2026-01-19T15:21:45.098Z
9184857 9184857 20260111122900_YXGfJ NZ001H 2026-01-12T14:21:46.782Z 2026-01-19T15:21:18.916Z
9184747 9184747 20260111121546_KXYrW NZ001H 2026-01-12T14:21:30.942Z 2026-01-19T15:21:11.793Z
9184157 9184157 20260111105018_Aozyd NZ001H 2026-01-12T14:19:49.031Z 2026-01-19T15:20:25.472Z
9183450 9183450 20260111093140_KuiC8 NZ001H 2026-01-12T14:17:50.833Z 2026-01-19T15:19:40.324Z
9183377 9183377 20260111092349_WZw7K NZ001H 2026-01-12T14:17:36.846Z 2026-01-19T15:19:37.548Z
9179320 9179320 20260111155125_61G0u NZ001H 2026-01-12T14:01:08.964Z 2026-01-20T15:20:11.053Z
9179300 9179300 20260111153126_B305I NZ001H 2026-01-12T14:01:04.559Z 2026-01-20T15:20:04.827Z
9179262 9179262 20260111151250_MLJ28 NZ001H 2026-01-12T14:00:54.628Z 2026-01-20T15:20:00.158Z
9179258 9179258 20260111150905_06CzC NZ001H 2026-01-12T14:00:53.915Z 2026-01-20T15:19:59.868Z
9179005 9179005 20260110124641_f0AYB NZ001H 2026-01-11T14:16:17.450Z 2026-01-18T15:10:44.009Z
9178650 9178650 20260110133730_XFe9q NZ001H 2026-01-11T14:15:25.015Z 2026-01-18T15:11:09.920Z
9178533 9178533 20260110132341_3yjyy NZ001H 2026-01-11T14:15:10.690Z 2026-01-18T15:11:04.885Z
9178525 9178525 20260110132154_wJIj5 NZ001H 2026-01-11T14:15:09.845Z 2026-01-18T15:10:59.308Z
9178359 9178359 20260110125629_szJq8 NZ001H 2026-01-11T14:14:41.669Z 2026-01-18T15:10:46.487Z
9178202 9178202 20260110123133_IQy2M NZ001H 2026-01-11T14:14:15.829Z 2026-01-18T15:10:39.013Z
9178042 9178042 20260110120339_l9I4K NZ001H 2026-01-11T14:13:52.648Z 2026-01-18T15:10:23.179Z
9177971 9177971 20260110115410_dsrzt NZ001H 2026-01-11T14:13:41.744Z 2026-01-18T15:10:17.498Z
9174103 9174103 20260110153211_SSm45 NZ001H 2026-01-11T14:01:25.058Z 2026-01-19T15:14:36.003Z
9173540 9173540 20260109143902_lZx6J NZ001H 2026-01-10T14:17:55.814Z 2026-01-17T15:26:47.612Z
9173264 9173264 20260109132906_5eTYf NZ001H 2026-01-10T14:16:54.967Z 2026-01-17T15:26:34.934Z
9173236 9173236 20260109132608_QenMM NZ001H 2026-01-10T14:16:49.765Z 2026-01-17T15:26:24.275Z
9172886 9172886 20260109122246_Bsmq0 NZ001H 2026-01-10T14:15:18.873Z 2026-01-17T15:26:06.707Z
9172481 9172481 20260109104853_tMm2h NZ001H 2026-01-10T14:13:32.974Z 2026-01-17T15:25:35.531Z
9172395 9172395 20260109103210_mGlBX NZ001H 2026-01-10T14:13:08.818Z 2026-01-17T15:25:24.745Z
9170532 9170532 20260109153810_6F8tl NZ001H 2026-01-10T14:01:06.198Z 2026-01-18T15:06:26.597Z
9170114 9170114 20260108142624_rWJRn NZ001H 2026-01-09T14:15:44.776Z 2026-01-16T15:13:56.513Z
9169898 9169898 20260108121939_fNk8U NZ001H 2026-01-09T14:15:13.235Z 2026-01-16T15:13:05.548Z
9169802 9169802 20260108104857_xt3vJ NZ001H 2026-01-09T14:14:39.582Z 2026-01-16T15:12:32.436Z
9169781 9169781 20260108103550_2U04y NZ001H 2026-01-09T14:14:37.190Z 2026-01-16T15:12:29.072Z
9169617 9169617 20260108150927_D06HY NZ001H 2026-01-09T14:14:07.151Z 2026-01-16T15:14:20.592Z
9169522 9169522 20260108145232_uQYbI NZ001H 2026-01-09T14:13:48.017Z 2026-01-16T15:14:05.209Z
9169331 9169331 20260108141232_TzWxO NZ001H 2026-01-09T14:13:17.723Z 2026-01-16T15:13:52.476Z
9169127 9169127 20260108132606_owJgP NZ001H 2026-01-09T14:12:48.788Z 2026-01-16T15:13:30.803Z
9168779 9168779 20260108121429_s9B1z NZ001H 2026-01-09T14:12:00.070Z 2026-01-16T15:13:03.926Z
9168497 9168497 20260108110825_QRIC2 NZ001H 2026-01-09T14:11:15.172Z 2026-01-16T15:12:47.858Z
9168382 9168382 20260108105151_YXc9D NZ001H 2026-01-09T14:10:59.416Z 2026-01-16T15:12:33.195Z
9168176 9168176 20260108101054_Pdb9W NZ001H 2026-01-09T14:10:33.200Z 2026-01-16T15:12:22.400Z
9164212 9164212 20260107123330_K9Bd7 NZ001H 2026-01-08T14:12:22.793Z 2026-01-13T15:04:20.751Z
9164156 9164156 20260107122147_vAELl NZ001H 2026-01-08T14:12:07.360Z 2026-01-13T15:04:09.709Z
9163872 9163872 20260107105833_wk82S NZ001H 2026-01-08T14:10:52.138Z 2026-01-13T15:03:44.159Z
9099873 9099873 20251224152210_ErxA8 NZ001H 2025-12-30T15:40:58.057Z 2026-01-01T15:56:26.012Z
9097267 9097267 20251227154837_CR4yt NZ001H 2025-12-30T15:08:30.532Z 2026-01-04T15:33:47.595Z
9097144 9097144 20251227153627_W2tLJ NZ001H 2025-12-30T15:08:24.529Z 2026-01-04T15:33:44.186Z
9097134 9097134 20251227153548_58mRa NZ001H 2025-12-30T15:08:24.047Z 2026-01-04T15:33:43.931Z
9097076 9097076 20251227153053_AOXaP NZ001H 2025-12-30T15:08:22.037Z 2026-01-04T15:33:42.129Z
9097044 9097044 20251227152523_OojSr NZ001H 2025-12-30T15:08:20.644Z 2026-01-04T15:33:36.605Z
9097021 9097021 20251227152416_ZJt4H NZ001H 2025-12-30T15:08:20.182Z 2026-01-04T15:33:30.076Z
9096697 9096697 20251227150151_OZigd NZ001H 2025-12-30T15:07:53.770Z 2026-01-04T15:33:20.822Z
9096518 9096518 20251227145203_GIl3A NZ001H 2025-12-30T15:07:46.467Z 2026-01-04T15:33:16.447Z
9096505 9096505 20251227145155_q1GJD NZ001H 2025-12-30T15:07:46.368Z 2026-01-04T15:33:16.302Z
9096502 9096502 20251227145155_On7wV NZ001H 2025-12-30T15:07:46.244Z 2026-01-04T15:33:16.120Z
9095901 9095901 20251227141712_imJTZ NZ001H 2025-12-30T15:07:05.260Z 2026-01-04T15:32:46.470Z
9095808 9095808 20251227141149_pHLzh NZ001H 2025-12-30T15:07:01.873Z 2026-01-04T15:32:44.611Z
9095610 9095610 20251227140116_f3uOW NZ001H 2025-12-30T15:06:39.597Z 2026-01-04T15:32:38.963Z
9095120 9095120 20251227132958_SR3RO NZ001H 2025-12-30T15:06:19.672Z 2026-01-04T15:32:15.616Z
9093445 9093445 20251227084924_Qc6Mi NZ001H 2025-12-30T15:03:44.855Z 2026-01-04T15:30:57.562Z
9075520 9075520 20251224102922_Q6hnr NZ001H 2025-12-29T15:05:04.421Z 2026-01-01T15:54:58.636Z
9041850 9041850 20251224154124_RuFUg NZ001H 2025-12-28T14:44:26.325Z 2026-01-01T15:56:28.234Z

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