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,997 rows where station_code = "NZ003T" 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
8765585 8765585 20251212151846_ZtQIH NZ003T 2025-12-14T14:50:36.718Z 2025-12-14T15:16:08.599Z
8765527 8765527 20251212151634_3o0A9 NZ003T 2025-12-14T14:50:22.460Z 2025-12-14T15:16:08.589Z
8765471 8765471 20251212151440_2W2S3 NZ003T 2025-12-14T14:50:07.028Z 2025-12-14T15:16:08.580Z
8765220 8765220 20251212150350_jijc2 NZ003T 2025-12-14T14:49:44.176Z 2025-12-14T15:16:08.532Z
8765011 8765011 20251212145242_WrTqd NZ003T 2025-12-14T14:49:04.172Z 2025-12-14T15:16:08.465Z
8764999 8764999 20251212145212_3rKhS NZ003T 2025-12-14T14:49:03.282Z 2025-12-14T15:16:08.462Z
8764808 8764808 20251212144319_yG3E3 NZ003T 2025-12-14T14:48:38.392Z 2025-12-14T15:16:08.428Z
8764797 8764797 20251212144318_KjdYo NZ003T 2025-12-14T14:48:38.192Z 2025-12-14T15:16:08.427Z
8764782 8764782 20251212144246_oeqQl NZ003T 2025-12-14T14:48:37.064Z 2025-12-14T15:16:08.423Z
8764779 8764779 20251212144240_VPzTH NZ003T 2025-12-14T14:48:36.705Z 2025-12-14T15:16:08.422Z
8764704 8764704 20251212143924_zxzaq NZ003T 2025-12-14T14:48:30.911Z 2025-12-14T15:16:08.407Z
8764415 8764415 20251212142847_r3102 NZ003T 2025-12-14T14:47:47.674Z 2025-12-14T15:16:08.348Z
8764248 8764248 20251212142045_7Oqcc NZ003T 2025-12-14T14:47:34.915Z 2025-12-14T15:16:08.313Z
8764241 8764241 20251212142043_TtaXq NZ003T 2025-12-14T14:47:33.680Z 2025-12-14T15:16:08.312Z
8764137 8764137 20251212141636_pzw8G NZ003T 2025-12-14T14:47:10.912Z 2025-12-14T15:16:08.295Z
8764066 8764066 20251212141210_IBal3 NZ003T 2025-12-14T14:47:01.664Z 2025-12-14T15:16:08.276Z
8763989 8763989 20251212140925_E6IaS NZ003T 2025-12-14T14:46:55.601Z 2025-12-14T15:16:08.258Z
8763644 8763644 20251212135109_qimQf NZ003T 2025-12-14T14:46:16.639Z 2025-12-14T15:16:08.172Z
8763211 8763211 20251212132707_2qwc2 NZ003T 2025-12-14T14:45:21.395Z 2025-12-14T15:16:08.012Z
8763092 8763092 20251212132007_HKOyU NZ003T 2025-12-14T14:44:56.549Z 2025-12-14T15:16:07.985Z
8762785 8762785 20251212130650_xIwSK NZ003T 2025-12-14T14:44:03.000Z 2025-12-14T15:16:07.895Z
8762458 8762458 20251212124612_8LyqT NZ003T 2025-12-14T14:42:02.125Z 2025-12-14T15:16:07.792Z
8761699 8761699 20251212120520_CvNLG NZ003T 2025-12-14T14:38:43.197Z 2025-12-14T15:16:07.540Z
8761384 8761384 20251212114947_DzlI7 NZ003T 2025-12-14T14:37:25.413Z 2025-12-14T15:16:07.430Z
8761290 8761290 20251212114512_eHvm3 NZ003T 2025-12-14T14:36:45.041Z 2025-12-14T15:16:07.394Z
8760923 8760923 20251212112652_FkY9J NZ003T 2025-12-14T14:35:05.785Z 2025-12-14T15:16:06.644Z
8760628 8760628 20251212111034_OXOhc NZ003T 2025-12-14T14:33:37.352Z 2025-12-14T15:16:05.793Z
8760486 8760486 20251212110255_KPu0p NZ003T 2025-12-14T14:32:57.877Z 2025-12-14T15:16:05.694Z
8760339 8760339 20251212105352_1zBDE NZ003T 2025-12-14T14:32:18.407Z 2025-12-14T15:16:05.618Z
8759842 8759842 20251212102214_RKw6E NZ003T 2025-12-14T14:29:25.277Z 2025-12-14T15:16:05.293Z
8759394 8759394 20251212094822_Epg27 NZ003T 2025-12-14T14:26:29.097Z 2025-12-14T15:16:04.316Z
8759218 8759218 20251212093754_lOkTP NZ003T 2025-12-14T14:25:37.056Z 2025-12-14T15:16:04.192Z
8759009 8759009 20251212092124_XvI1T NZ003T 2025-12-14T14:24:01.377Z 2025-12-14T15:16:04.029Z
8758928 8758928 20251212091441_kTxoE NZ003T 2025-12-14T14:23:17.734Z 2025-12-14T15:16:03.945Z
8749626 8749626 20251209151752_zAMDz NZ003T 2025-12-13T15:36:50.441Z 2025-12-14T15:42:25.396Z
8749602 8749602 20251209151359_pFR52 NZ003T 2025-12-13T15:36:48.229Z 2025-12-14T15:42:24.433Z
8749537 8749537 20251209150731_3rRIF NZ003T 2025-12-13T15:36:28.897Z 2025-12-14T15:42:22.807Z
8749484 8749484 20251209145854_cMigY NZ003T 2025-12-13T15:36:22.946Z 2025-12-14T15:42:21.290Z
8749459 8749459 20251209145644_CheDW NZ003T 2025-12-13T15:36:22.206Z 2025-12-14T15:42:20.635Z
8749426 8749426 20251209145017_U4N4i NZ003T 2025-12-13T15:36:18.700Z 2025-12-14T15:42:19.437Z
8749218 8749218 20251209142337_VjsDW NZ003T 2025-12-13T15:36:08.015Z 2025-12-14T15:41:46.686Z
8749195 8749195 20251209142034_lYAR4 NZ003T 2025-12-13T15:36:06.334Z 2025-12-14T15:41:46.145Z
8749191 8749191 20251209142026_MyRnS NZ003T 2025-12-13T15:36:06.159Z 2025-12-14T15:41:45.990Z
8749169 8749169 20251209141733_F1r4T NZ003T 2025-12-13T15:36:05.085Z 2025-12-14T15:41:45.366Z
8748948 8748948 20251209134411_3SmTC NZ003T 2025-12-13T15:35:31.153Z 2025-12-14T15:41:34.698Z
8748849 8748849 20251209132649_rZ0xd NZ003T 2025-12-13T15:35:26.797Z 2025-12-14T15:41:30.717Z
8748774 8748774 20251209131530_54Z6Y NZ003T 2025-12-13T15:35:22.606Z 2025-12-14T15:41:28.137Z
8748543 8748543 20251209124539_7DDCz NZ003T 2025-12-13T15:34:33.766Z 2025-12-14T15:40:58.347Z
8748496 8748496 20251209123804_3ZvWY NZ003T 2025-12-13T15:34:29.846Z 2025-12-14T15:40:55.089Z
8748429 8748429 20251209122942_f7iQf NZ003T 2025-12-13T15:34:25.667Z 2025-12-14T15:40:52.153Z
8748037 8748037 20251209113604_uDZmf NZ003T 2025-12-13T15:33:34.327Z 2025-12-14T15:40:05.258Z
8747952 8747952 20251209112603_Jm3bm NZ003T 2025-12-13T15:33:29.702Z 2025-12-14T15:40:01.301Z
8747919 8747919 20251209111933_BFCF9 NZ003T 2025-12-13T15:33:22.771Z 2025-12-14T15:39:59.086Z
8747887 8747887 20251209111333_WMI5p NZ003T 2025-12-13T15:33:07.570Z 2025-12-14T15:39:56.464Z
8747863 8747863 20251209110555_I5XEk NZ003T 2025-12-13T15:33:05.171Z 2025-12-14T15:39:54.419Z
8747829 8747829 20251209110051_258F3 NZ003T 2025-12-13T15:33:01.002Z 2025-12-14T15:39:36.805Z
8747802 8747802 20251209105752_2GPPt NZ003T 2025-12-13T15:32:59.415Z 2025-12-14T15:39:30.819Z
8747781 8747781 20251209105638_FVVoD NZ003T 2025-12-13T15:32:58.134Z 2025-12-14T15:39:29.604Z
8747604 8747604 20251209102009_Iinwv NZ003T 2025-12-13T15:32:30.764Z 2025-12-14T15:39:14.579Z
8747589 8747589 20251209101545_hS2cV NZ003T 2025-12-13T15:32:29.395Z 2025-12-14T15:39:13.725Z
8747566 8747566 20251209100837_1LiBM NZ003T 2025-12-13T15:32:19.440Z 2025-12-14T15:39:10.964Z
8747465 8747465 20251209093304_8Di6B NZ003T 2025-12-13T15:31:54.497Z 2025-12-14T15:38:37.671Z
8747430 8747430 20251209092538_r6KF1 NZ003T 2025-12-13T15:31:51.501Z 2025-12-14T15:38:35.309Z
8747423 8747423 20251209092438_fiBWv NZ003T 2025-12-13T15:31:51.192Z 2025-12-14T15:38:35.058Z
8747415 8747415 20251209092435_tb2oo NZ003T 2025-12-13T15:31:50.619Z 2025-12-14T15:38:34.801Z
8739338 8739338 20251210151336_hRnq5 NZ003T 2025-12-13T15:16:07.431Z 2025-12-14T15:28:08.476Z
8739305 8739305 20251210150834_ygS5S NZ003T 2025-12-13T15:16:05.158Z 2025-12-14T15:28:07.370Z
8739175 8739175 20251210145055_lCYII NZ003T 2025-12-13T15:15:57.341Z 2025-12-14T15:27:55.353Z
8733098 8733098 20251211153847_VE8HM NZ003T 2025-12-13T14:47:41.841Z 2025-12-14T15:16:15.297Z
8732631 8732631 20251211145612_48UZB NZ003T 2025-12-13T14:46:36.623Z 2025-12-14T15:16:15.071Z
8732456 8732456 20251211144117_wQ0A2 NZ003T 2025-12-13T14:46:03.771Z 2025-12-14T15:16:15.017Z
8732366 8732366 20251211143325_rvJ9h NZ003T 2025-12-13T14:45:40.899Z 2025-12-14T15:16:14.991Z
8732364 8732364 20251211143325_Jzn14 NZ003T 2025-12-13T14:45:40.134Z 2025-12-14T15:16:14.990Z
8732355 8732355 20251211143223_uccUV NZ003T 2025-12-13T14:45:35.644Z 2025-12-14T15:16:14.986Z
8732139 8732139 20251211141457_E8kcn NZ003T 2025-12-13T14:44:55.935Z 2025-12-14T15:16:14.912Z
8732031 8732031 20251211135929_MwRrP NZ003T 2025-12-13T14:44:31.257Z 2025-12-14T15:16:14.875Z
8725847 8725847 20251211123215_SUVrB NZ003T 2025-12-12T14:18:55.308Z 2025-12-14T15:16:14.206Z
8725827 8725827 20251211123054_c96Ki NZ003T 2025-12-12T14:18:53.941Z 2025-12-14T15:16:14.203Z
8725695 8725695 20251211122403_Ncz7h NZ003T 2025-12-12T14:18:28.915Z 2025-12-14T15:16:14.170Z
8725604 8725604 20251211121948_4oBM3 NZ003T 2025-12-12T14:18:19.188Z 2025-12-14T15:16:14.151Z
8724943 8724943 20251211114248_kyVW2 NZ003T 2025-12-12T14:16:44.737Z 2025-12-14T15:16:13.952Z
8724730 8724730 20251211112851_oSMVh NZ003T 2025-12-12T14:16:10.590Z 2025-12-14T15:16:13.895Z
8723589 8723589 20251211095759_bg199 NZ003T 2025-12-12T14:12:42.766Z 2025-12-14T15:16:13.543Z
8723410 8723410 20251211094438_kiaCh NZ003T 2025-12-12T14:12:09.692Z 2025-12-14T15:16:13.486Z
8719610 8719610 20251210144130_E5GnJ NZ003T 2025-12-11T14:20:34.397Z 2025-12-14T15:27:44.433Z
8719378 8719378 20251210135855_wmbcl NZ003T 2025-12-11T14:20:00.548Z 2025-12-14T15:27:30.815Z
8719292 8719292 20251210134322_2dOj1 NZ003T 2025-12-11T14:19:44.824Z 2025-12-14T15:27:27.214Z
8719222 8719222 20251210133345_MLdXb NZ003T 2025-12-11T14:19:30.993Z 2025-12-14T15:27:24.200Z
8719121 8719121 20251210132450_5FG6I NZ003T 2025-12-11T14:19:12.310Z 2025-12-14T15:27:21.686Z
8719105 8719105 20251210132307_2ThDg NZ003T 2025-12-11T14:19:09.904Z 2025-12-14T15:27:20.984Z
8718790 8718790 20251210125153_SmPSL NZ003T 2025-12-11T14:18:12.357Z 2025-12-11T14:18:12.357Z
8718262 8718262 20251210121603_yvJDm NZ003T 2025-12-11T14:16:38.204Z 2025-12-14T15:26:13.720Z
8717734 8717734 20251210113555_n4G3F NZ003T 2025-12-11T14:14:59.895Z 2025-12-14T15:25:02.240Z
8717550 8717550 20251210112154_GYhiE NZ003T 2025-12-11T14:14:21.293Z 2025-12-14T15:24:40.006Z
8717383 8717383 20251210110926_12W52 NZ003T 2025-12-11T14:13:46.588Z 2025-12-14T15:24:18.586Z
8717371 8717371 20251210110910_B0qKL NZ003T 2025-12-11T14:13:45.298Z 2025-12-14T15:24:15.856Z
8716810 8716810 20251210102237_MYBmv NZ003T 2025-12-11T14:12:00.438Z 2025-12-14T15:23:16.742Z
8716498 8716498 20251210095546_FZTdi NZ003T 2025-12-11T14:10:59.402Z 2025-12-14T15:22:41.347Z
8716309 8716309 20251210093225_0pK08 NZ003T 2025-12-11T14:10:21.581Z 2025-12-14T15:22:12.168Z
8702578 8702578 20251208113659_mmtSa NZ003T 2025-12-09T14:09:02.562Z 2025-12-14T15:50:21.544Z

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