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

965 rows where station_code = "NZ007C" 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
9627513 9627513 20260408181037_AFznG NZ007C 2026-04-09T12:11:13.802Z 2026-04-10T12:14:22.556Z
9627472 9627472 20260408175359_Dgor3 NZ007C 2026-04-09T12:11:08.093Z 2026-04-10T12:14:22.550Z
9627462 9627462 20260408174414_nn4WA NZ007C 2026-04-09T12:11:06.429Z 2026-04-10T12:14:22.548Z
9627457 9627457 20260408174259_t2tCf NZ007C 2026-04-09T12:11:06.054Z 2026-04-10T12:14:22.547Z
9627277 9627277 20260408165654_zxYq7 NZ007C 2026-04-09T12:10:31.290Z 2026-04-10T12:14:22.514Z
9627267 9627267 20260408165527_8dPXj NZ007C 2026-04-09T12:10:29.778Z 2026-04-10T12:14:22.511Z
9627218 9627218 20260408164335_ihUEG NZ007C 2026-04-09T12:10:20.025Z 2026-04-10T12:14:22.504Z
9627148 9627148 20260408163142_9RTsp NZ007C 2026-04-09T12:10:10.486Z 2026-04-10T12:14:22.490Z
9627102 9627102 20260408161642_8YsDl NZ007C 2026-04-09T12:10:03.241Z 2026-04-10T12:14:22.480Z
9627005 9627005 20260408155118_yfZ2Q NZ007C 2026-04-09T12:09:43.984Z 2026-04-10T12:14:22.456Z
9626707 9626707 20260408145343_2M676 NZ007C 2026-04-09T12:09:03.808Z 2026-04-10T12:14:22.402Z
9626534 9626534 20260408141137_IWNEi NZ007C 2026-04-09T12:08:38.433Z 2026-04-10T12:14:22.369Z
9626474 9626474 20260408140456_iPY4W NZ007C 2026-04-09T12:08:23.877Z 2026-04-10T12:14:22.358Z
9626464 9626464 20260408140441_Ol7Ah NZ007C 2026-04-09T12:08:23.394Z 2026-04-10T12:14:22.357Z
9626434 9626434 20260408140305_DX31f NZ007C 2026-04-09T12:08:20.897Z 2026-04-10T12:14:22.353Z
9626422 9626422 20260408140002_A5O4N NZ007C 2026-04-09T12:08:18.507Z 2026-04-10T12:14:22.350Z
9626401 9626401 20260408135400_gBp2S NZ007C 2026-04-09T12:08:15.962Z 2026-04-10T12:14:22.346Z
9626131 9626131 20260408131538_9iK5b NZ007C 2026-04-09T12:07:39.424Z 2026-04-10T12:14:22.306Z
9626094 9626094 20260408130958_f8w9a NZ007C 2026-04-09T12:07:34.347Z 2026-04-10T12:14:22.294Z
9626066 9626066 20260408130248_iMrJX NZ007C 2026-04-09T12:07:25.772Z 2026-04-10T12:14:22.289Z
9625949 9625949 20260408123257_NlBA2 NZ007C 2026-04-09T12:07:10.398Z 2026-04-10T12:14:22.269Z
9625921 9625921 20260408122428_yYO1J NZ007C 2026-04-09T12:07:06.718Z 2026-04-10T12:14:22.264Z
9625787 9625787 20260408114917_sG553 NZ007C 2026-04-09T12:06:42.456Z 2026-04-10T12:14:22.241Z
9625738 9625738 20260408114122_1trxe NZ007C 2026-04-09T12:06:32.957Z 2026-04-10T12:14:22.232Z
9625704 9625704 20260408113640_L2uvP NZ007C 2026-04-09T12:06:20.705Z 2026-04-10T12:14:22.225Z
9625463 9625463 20260408105649_OcGbV NZ007C 2026-04-09T12:05:36.369Z 2026-04-10T12:14:21.929Z
9625387 9625387 20260408104544_NBrFm NZ007C 2026-04-09T12:05:18.830Z 2026-04-10T12:14:21.916Z
9625252 9625252 20260408100649_2he3h NZ007C 2026-04-09T12:04:48.387Z 2026-04-10T12:14:21.888Z
9625241 9625241 20260408100611_zdLOv NZ007C 2026-04-09T12:04:46.404Z 2026-04-10T12:14:21.885Z
9625189 9625189 20260408095257_woG3k NZ007C 2026-04-09T12:04:36.617Z 2026-04-10T12:14:21.874Z
9625177 9625177 20260408095001_dSCfO NZ007C 2026-04-09T12:04:34.675Z 2026-04-10T12:14:21.871Z
9625158 9625158 20260408094616_FCXYG NZ007C 2026-04-09T12:04:31.630Z 2026-04-10T12:14:21.867Z
9625153 9625153 20260408094606_du1Gk NZ007C 2026-04-09T12:04:30.564Z 2026-04-10T12:14:21.866Z
9625108 9625108 20260408093756_Y9BZP NZ007C 2026-04-09T12:04:17.247Z 2026-04-10T12:14:21.857Z
9624906 9624906 20260408085349_sHCiy NZ007C 2026-04-09T12:03:24.111Z 2026-04-10T12:14:21.808Z
9624565 9624565 20260408074343_b7WOo NZ007C 2026-04-09T12:01:59.912Z 2026-04-10T12:14:21.410Z
9613244 9613244 20260405130140_lgf26 NZ007C 2026-04-07T12:05:36.761Z 2026-04-10T12:26:36.218Z
9610353 9610353 20260405165217_NQZc2 NZ007C 2026-04-06T12:07:18.030Z 2026-04-10T12:27:05.131Z
9610336 9610336 20260405162920_bxF6H NZ007C 2026-04-06T12:07:08.424Z 2026-04-10T12:27:04.600Z
9610328 9610328 20260405162058_nmH7a NZ007C 2026-04-06T12:07:06.681Z 2026-04-10T12:27:04.368Z
9610322 9610322 20260405161426_xqJp2 NZ007C 2026-04-06T12:07:00.473Z 2026-04-10T12:27:04.134Z
9610311 9610311 20260405160331_vcb1e NZ007C 2026-04-06T12:06:57.301Z 2026-04-10T12:27:03.702Z
9610237 9610237 20260405150747_rjVNk NZ007C 2026-04-06T12:06:32.651Z 2026-04-10T12:27:01.432Z
9610220 9610220 20260405144746_2lRay NZ007C 2026-04-06T12:06:25.412Z 2026-04-10T12:27:00.619Z
9610214 9610214 20260405144418_BMOqu NZ007C 2026-04-06T12:06:24.017Z 2026-04-10T12:27:00.458Z
9610169 9610169 20260405140520_9gWeU NZ007C 2026-04-06T12:06:08.044Z 2026-04-10T12:26:58.278Z
9610157 9610157 20260405135915_kdD8q NZ007C 2026-04-06T12:06:05.772Z 2026-04-10T12:26:56.530Z
9610145 9610145 20260405135006_BjkAm NZ007C 2026-04-06T12:06:01.200Z 2026-04-10T12:26:50.583Z
9610142 9610142 20260405134703_CMfK9 NZ007C 2026-04-06T12:06:00.571Z 2026-04-10T12:26:50.005Z
9610114 9610114 20260405130402_b9nw2 NZ007C 2026-04-06T12:05:51.873Z 2026-04-10T12:26:38.411Z
9610095 9610095 20260405125424_buq1v NZ007C 2026-04-06T12:05:43.170Z 2026-04-10T12:26:35.210Z
9605976 9605976 20260403133817_Y0TjY NZ007C 2026-04-04T12:04:44.618Z 2026-04-10T12:32:17.809Z
9605957 9605957 20260403132902_rp9o2 NZ007C 2026-04-04T12:04:36.892Z 2026-04-10T12:32:15.620Z
9605624 9605624 20260403111200_ft7Kb NZ007C 2026-04-04T12:03:09.319Z 2026-04-10T12:31:40.276Z
9604380 9604380 20260402173830_JC4XO NZ007C 2026-04-03T12:07:11.764Z 2026-04-10T12:34:49.476Z
9604360 9604360 20260402172114_NoRbF NZ007C 2026-04-03T12:07:03.716Z 2026-04-10T12:34:49.000Z
9604067 9604067 20260402152537_zxg53 NZ007C 2026-04-03T12:05:47.750Z 2026-04-10T12:34:18.700Z
9603937 9603937 20260402140814_8lGiR NZ007C 2026-04-03T12:05:13.287Z 2026-04-10T12:34:15.959Z
9603859 9603859 20260402131213_SxGJa NZ007C 2026-04-03T12:04:53.470Z 2026-04-10T12:34:10.996Z
9603627 9603627 20260402112525_YzZoK NZ007C 2026-04-03T12:03:50.950Z 2026-04-10T12:34:05.672Z
9603559 9603559 20260402110233_YKwgA NZ007C 2026-04-03T12:03:39.548Z 2026-04-10T12:34:04.178Z
9601703 9601703 20260401163145_wQScD NZ007C 2026-04-02T12:03:28.538Z 2026-04-10T12:35:43.783Z
9601600 9601600 20260401160129_jmA5q NZ007C 2026-04-02T12:03:13.924Z 2026-04-10T12:35:41.905Z
9601537 9601537 20260401154117_rJK16 NZ007C 2026-04-02T12:03:02.270Z 2026-04-05T12:17:16.052Z
9601518 9601518 20260401153958_RMX8f NZ007C 2026-04-02T12:02:59.311Z 2026-04-10T12:35:40.573Z
9601498 9601498 20260401153013_mraoi NZ007C 2026-04-02T12:02:56.178Z 2026-04-10T12:35:40.183Z
9601467 9601467 20260401152502_JKfVI NZ007C 2026-04-02T12:02:52.186Z 2026-04-10T12:35:39.731Z
9601460 9601460 20260401152401_SZ5gD NZ007C 2026-04-02T12:02:50.702Z 2026-04-10T12:35:39.475Z
9601432 9601432 20260401151831_BNzuC NZ007C 2026-04-02T12:02:46.383Z 2026-04-10T12:35:38.936Z
9601369 9601369 20260401145447_VQu46 NZ007C 2026-04-02T12:02:34.589Z 2026-04-10T12:35:37.899Z
9601095 9601095 20260401114452_rXcqV NZ007C 2026-04-02T12:01:32.926Z 2026-04-10T12:35:33.011Z
9601063 9601063 20260401111149_322Ka NZ007C 2026-04-02T12:01:27.721Z 2026-04-10T12:35:32.479Z
9601020 9601020 20260401103300_Mthp1 NZ007C 2026-04-02T12:01:18.449Z 2026-04-10T12:35:31.805Z
9600981 9600981 20260401101431_YB6zY NZ007C 2026-04-02T12:01:11.562Z 2026-04-10T12:35:31.050Z
9599905 9599905 20260331172031_98gTh NZ007C 2026-04-01T12:05:13.021Z 2026-04-09T12:48:00.296Z
9599898 9599898 20260331171830_2352K NZ007C 2026-04-01T12:05:11.758Z 2026-04-09T12:47:59.665Z
9599786 9599786 20260331164910_4F21P NZ007C 2026-04-01T12:04:49.265Z 2026-04-09T12:47:30.443Z
9599744 9599744 20260331163426_RXI5i NZ007C 2026-04-01T12:04:41.145Z 2026-04-09T12:47:22.668Z
9599728 9599728 20260331163219_wnvr4 NZ007C 2026-04-01T12:04:38.112Z 2026-04-09T12:47:18.322Z
9599725 9599725 20260331163135_InSmi NZ007C 2026-04-01T12:04:37.572Z 2026-04-09T12:47:18.043Z
9599697 9599697 20260331162514_q9PS6 NZ007C 2026-04-01T12:04:32.624Z 2026-04-09T12:47:15.676Z
9599631 9599631 20260331160515_rmDsg NZ007C 2026-04-01T12:04:17.271Z 2026-04-09T12:47:07.538Z
9599614 9599614 20260331160129_cKG3J NZ007C 2026-04-01T12:04:14.607Z 2026-04-09T12:47:06.163Z
9599603 9599603 20260331160057_C20Jg NZ007C 2026-04-01T12:04:13.285Z 2026-04-09T12:47:04.390Z
9599594 9599594 20260331155644_Etypi NZ007C 2026-04-01T12:04:11.137Z 2026-04-09T12:47:03.767Z
9599532 9599532 20260331153034_G2m1t NZ007C 2026-04-01T12:03:57.146Z 2026-04-09T12:46:55.070Z
9599316 9599316 20260331135401_EDmFA NZ007C 2026-04-01T12:03:09.766Z 2026-04-09T12:46:45.816Z
9599301 9599301 20260331134414_k8SGX NZ007C 2026-04-01T12:03:05.238Z 2026-04-09T12:46:45.660Z
9599231 9599231 20260331130533_KlBed NZ007C 2026-04-01T12:02:49.225Z 2026-04-09T12:46:44.430Z
9599163 9599163 20260331121441_23cUR NZ007C 2026-04-01T12:02:35.265Z 2026-04-09T12:46:42.595Z
9598947 9598947 20260331091959_emmdY NZ007C 2026-04-01T12:01:41.756Z 2026-04-09T12:46:38.645Z
9598896 9598896 20260331083614_tgVN6 NZ007C 2026-04-01T12:01:27.358Z 2026-04-09T12:46:37.513Z
9598893 9598893 20260331083614_8IpKC NZ007C 2026-04-01T12:01:26.850Z 2026-04-09T12:46:37.455Z
9598814 9598814 20260331073428_42bhV NZ007C 2026-04-01T12:01:11.153Z 2026-04-09T12:46:36.201Z
9598807 9598807 20260331073401_ZpsO1 NZ007C 2026-04-01T12:01:09.875Z 2026-04-09T12:46:36.106Z
9598099 9598099 20260330175612_wZnNY NZ007C 2026-03-31T12:07:37.008Z 2026-04-08T12:44:25.712Z
9598087 9598087 20260330174553_e3Jti NZ007C 2026-03-31T12:07:35.282Z 2026-04-08T12:44:25.252Z
9598073 9598073 20260330174038_V1PNZ NZ007C 2026-03-31T12:07:32.734Z 2026-04-08T12:44:24.776Z
9598064 9598064 20260330173734_30uhK NZ007C 2026-03-31T12:07:32.018Z 2026-04-08T12:44:24.628Z
9598016 9598016 20260330173102_ZVpY8 NZ007C 2026-03-31T12:07:27.049Z 2026-04-08T12:44:23.305Z

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