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,445 rows where station_code = "NZ004A" 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
9270680 9270680 20260128162240_TebOj NZ004A 2026-01-29T14:13:17.747Z 2026-01-29T14:13:17.747Z
9270543 9270543 20260128155900_PHuTt NZ004A 2026-01-29T14:12:42.910Z 2026-01-29T14:12:42.910Z
9270456 9270456 20260128155301_B3Tm2 NZ004A 2026-01-29T14:12:20.062Z 2026-01-29T14:12:20.062Z
9270446 9270446 20260128155000_p1xgq NZ004A 2026-01-29T14:12:17.747Z 2026-01-29T14:12:17.747Z
9270256 9270256 20260128152136_993Oj NZ004A 2026-01-29T14:11:24.965Z 2026-01-29T14:11:24.965Z
9270151 9270151 20260128150236_ogKps NZ004A 2026-01-29T14:11:06.801Z 2026-01-29T14:11:06.801Z
9270037 9270037 20260128145019_OISQU NZ004A 2026-01-29T14:10:42.259Z 2026-01-29T14:10:42.259Z
9269886 9269886 20260128142858_tNcju NZ004A 2026-01-29T14:10:05.382Z 2026-01-29T14:10:05.382Z
9269781 9269781 20260128141135_I84Qd NZ004A 2026-01-29T14:09:36.161Z 2026-01-29T14:09:36.161Z
9269695 9269695 20260128135503_73CHQ NZ004A 2026-01-29T14:09:05.573Z 2026-01-29T14:09:05.573Z
9269685 9269685 20260128135451_eRfj7 NZ004A 2026-01-29T14:09:04.026Z 2026-01-29T14:09:04.026Z
9269413 9269413 20260128131352_6tyxK NZ004A 2026-01-29T14:07:53.692Z 2026-01-29T14:07:53.692Z
9269406 9269406 20260128131256_Gv3ul NZ004A 2026-01-29T14:07:52.461Z 2026-01-29T14:07:52.461Z
9269127 9269127 20260128123343_qFfiP NZ004A 2026-01-29T14:06:37.955Z 2026-01-29T14:06:37.955Z
9269082 9269082 20260128122033_PnwXw NZ004A 2026-01-29T14:06:21.399Z 2026-01-29T14:06:21.399Z
9269054 9269054 20260128121407_cdZbB NZ004A 2026-01-29T14:06:11.690Z 2026-01-29T14:06:11.690Z
9269053 9269053 20260128121338_iQDTi NZ004A 2026-01-29T14:06:10.924Z 2026-01-29T14:06:10.924Z
9268666 9268666 20260128110008_tCrC2 NZ004A 2026-01-29T14:04:16.544Z 2026-01-29T14:04:16.544Z
9268658 9268658 20260128105909_B4hpt NZ004A 2026-01-29T14:04:15.815Z 2026-01-29T14:04:15.815Z
9268591 9268591 20260128104856_AEcdU NZ004A 2026-01-29T14:03:53.712Z 2026-01-29T14:03:53.712Z
9268531 9268531 20260128104211_O6vgN NZ004A 2026-01-29T14:03:30.545Z 2026-01-29T14:03:30.545Z
9268522 9268522 20260128104051_ePKU4 NZ004A 2026-01-29T14:03:28.394Z 2026-01-29T14:03:28.394Z
9268474 9268474 20260128102651_zYYTK NZ004A 2026-01-29T14:03:16.742Z 2026-01-29T14:03:16.742Z
9268469 9268469 20260128102543_5xaEp NZ004A 2026-01-29T14:03:16.046Z 2026-01-29T14:03:16.046Z
9268420 9268420 20260128101030_01CVp NZ004A 2026-01-29T14:02:54.117Z 2026-01-29T14:02:54.117Z
9268357 9268357 20260128100009_YTvkc NZ004A 2026-01-29T14:02:39.147Z 2026-01-29T14:02:39.147Z
9268117 9268117 20260128085137_ABXGF NZ004A 2026-01-29T14:01:10.389Z 2026-01-29T14:01:10.389Z
9265834 9265834 20260127160241_OuQr3 NZ004A 2026-01-28T14:11:29.529Z 2026-01-29T14:30:24.686Z
9265800 9265800 20260127160124_WdIX4 NZ004A 2026-01-28T14:11:22.558Z 2026-01-29T14:30:24.678Z
9265635 9265635 20260127154331_Oh23f NZ004A 2026-01-28T14:10:48.195Z 2026-01-29T14:30:24.637Z
9265461 9265461 20260127151733_5i2Pr NZ004A 2026-01-28T14:10:13.390Z 2026-01-29T14:30:24.553Z
9265369 9265369 20260127150730_V633r NZ004A 2026-01-28T14:09:57.167Z 2026-01-29T14:30:24.536Z
9265276 9265276 20260127145408_gKI3H NZ004A 2026-01-28T14:09:43.364Z 2026-01-29T14:30:24.519Z
9265061 9265061 20260127141021_t9cAb NZ004A 2026-01-28T14:08:53.330Z 2026-01-29T14:30:24.428Z
9264863 9264863 20260127132502_OSRhq NZ004A 2026-01-28T14:08:01.459Z 2026-01-29T14:30:24.316Z
9264804 9264804 20260127131525_eJtfD NZ004A 2026-01-28T14:07:44.888Z 2026-01-29T14:30:24.296Z
9264680 9264680 20260127125529_oynvE NZ004A 2026-01-28T14:07:08.667Z 2026-01-29T14:30:24.253Z
9264279 9264279 20260127115419_mwjcB NZ004A 2026-01-28T14:05:16.612Z 2026-01-29T14:30:20.575Z
9264062 9264062 20260127110717_7uTA3 NZ004A 2026-01-28T14:04:10.892Z 2026-01-29T14:30:20.033Z
9257752 9257752 20260125154813_XJVUb NZ004A 2026-01-26T14:07:36.131Z 2026-01-29T14:37:37.845Z
9257660 9257660 20260125151729_jDvNx NZ004A 2026-01-26T14:07:03.934Z 2026-01-29T14:37:33.503Z
9257559 9257559 20260125143556_MUVxF NZ004A 2026-01-26T14:06:23.208Z 2026-01-29T14:37:27.579Z
9257525 9257525 20260125141829_CtWQl NZ004A 2026-01-26T14:06:06.137Z 2026-01-29T14:37:25.579Z
9257370 9257370 20260125130922_S9g9Z NZ004A 2026-01-26T14:05:09.250Z 2026-01-29T14:37:08.068Z
9257202 9257202 20260125122044_BLQj8 NZ004A 2026-01-26T14:04:08.270Z 2026-01-29T14:36:54.619Z
9257095 9257095 20260125115133_yoQsK NZ004A 2026-01-26T14:03:39.356Z 2026-01-29T14:36:46.327Z
9257040 9257040 20260125114137_QrAIw NZ004A 2026-01-26T14:03:18.067Z 2026-01-29T14:36:42.840Z
9257013 9257013 20260125113430_l4PC7 NZ004A 2026-01-26T14:03:10.719Z 2026-01-29T14:36:41.545Z
9256989 9256989 20260125113101_rsY1K NZ004A 2026-01-26T14:03:07.533Z 2026-01-29T14:36:40.515Z
9253751 9253751 20260124142352_uJoni NZ004A 2026-01-25T14:04:14.295Z 2026-01-29T14:41:23.931Z
9253673 9253673 20260124133438_FruV3 NZ004A 2026-01-25T14:03:53.472Z 2026-01-29T14:41:15.448Z
9253660 9253660 20260124132526_5KUSz NZ004A 2026-01-25T14:03:47.825Z 2026-01-29T14:41:13.428Z
9253571 9253571 20260124124836_Ep1TC NZ004A 2026-01-25T14:03:21.645Z 2026-01-29T14:40:58.298Z
9253513 9253513 20260124121938_L0CpB NZ004A 2026-01-25T14:03:04.524Z 2026-01-29T14:40:54.251Z
9253449 9253449 20260124115207_BFGTO NZ004A 2026-01-25T14:02:48.367Z 2026-01-29T14:40:50.810Z
9253255 9253255 20260124103426_1SAsO NZ004A 2026-01-25T14:01:40.519Z 2026-01-29T14:40:30.665Z
9253193 9253193 20260124100359_LYx2k NZ004A 2026-01-25T14:01:13.887Z 2026-01-29T14:40:25.262Z
9253149 9253149 20260124094329_CrBjt NZ004A 2026-01-25T14:00:56.890Z 2026-01-29T14:40:21.206Z
9253097 9253097 20260124091920_5JmPa NZ004A 2026-01-25T14:00:41.220Z 2026-01-29T14:40:15.095Z
9250355 9250355 20260123133918_o8guf NZ004A 2026-01-24T14:02:29.116Z 2026-01-29T14:45:25.860Z
9249954 9249954 20260123091413_fgCeS NZ004A 2026-01-24T14:00:19.349Z 2026-01-29T14:44:44.881Z
9245602 9245602 20260122131955_VNiXH NZ004A 2026-01-23T14:02:35.445Z 2026-01-29T14:49:50.228Z
9245599 9245599 20260122131940_2mK3n NZ004A 2026-01-23T14:02:34.831Z 2026-01-29T14:49:50.045Z
9245149 9245149 20260122103654_L2qRo NZ004A 2026-01-23T14:00:47.791Z 2026-01-29T14:49:04.653Z
9225755 9225755 20260118105114_K8cFl NZ004A 2026-01-19T14:30:04.833Z 2026-01-26T15:04:43.974Z
9220901 9220901 20260118141706_413yz NZ004A 2026-01-19T14:06:03.057Z 2026-01-27T14:59:34.370Z
9220899 9220899 20260118141612_q8gss NZ004A 2026-01-19T14:06:02.339Z 2026-01-27T14:59:34.251Z
9220312 9220312 20260118123648_A9EHF NZ004A 2026-01-19T14:03:45.893Z 2026-01-27T14:59:01.376Z
9219683 9219683 20260116095910_wGFTM NZ004A 2026-01-18T14:25:29.181Z 2026-01-24T15:14:42.542Z
9211115 9211115 20260116161302_hY0tT NZ004A 2026-01-17T14:04:26.472Z 2026-01-25T14:57:22.170Z
9211065 9211065 20260116153137_DcUbR NZ004A 2026-01-17T14:04:07.855Z 2026-01-25T14:57:18.613Z
9210999 9210999 20260116143558_kd7Lt NZ004A 2026-01-17T14:03:45.310Z 2026-01-25T14:57:14.132Z
9210984 9210984 20260116142440_XhPHQ NZ004A 2026-01-17T14:03:41.644Z 2026-01-25T14:57:13.515Z
9210965 9210965 20260116141852_VBmUd NZ004A 2026-01-17T14:03:36.521Z 2026-01-25T14:57:12.961Z
9210962 9210962 20260116141747_0eXKe NZ004A 2026-01-17T14:03:35.859Z 2026-01-25T14:57:12.907Z
9210936 9210936 20260116141027_xBnMu NZ004A 2026-01-17T14:03:27.945Z 2026-01-25T14:57:12.311Z
9210925 9210925 20260116140709_M1gAa NZ004A 2026-01-17T14:03:25.038Z 2026-01-25T14:57:11.786Z
9210894 9210894 20260116134838_3lgeW NZ004A 2026-01-17T14:03:18.261Z 2026-01-25T14:57:10.796Z
9197544 9197544 20260113113557_ERvsL NZ004A 2026-01-14T14:23:23.634Z 2026-01-21T15:06:19.908Z
9193515 9193515 20260113154652_Gkffz NZ004A 2026-01-14T14:01:56.049Z 2026-01-22T15:06:23.643Z
9193385 9193385 20260113140906_0ivOg NZ004A 2026-01-14T14:01:03.510Z 2026-01-22T15:06:15.554Z
9192935 9192935 20260112131609_83TLe NZ004A 2026-01-13T14:29:41.181Z 2026-01-20T15:26:39.683Z
9192598 9192598 20260112124654_H1YXp NZ004A 2026-01-13T14:28:48.329Z 2026-01-20T15:26:26.837Z
9192499 9192499 20260112123851_jf871 NZ004A 2026-01-13T14:28:29.456Z 2026-01-20T15:26:23.458Z
9192197 9192197 20260112121146_QSxsh NZ004A 2026-01-13T14:27:41.948Z 2026-01-20T15:26:13.987Z
9192178 9192178 20260112121056_jBYcA NZ004A 2026-01-13T14:27:40.420Z 2026-01-20T15:26:12.032Z
9192095 9192095 20260112120445_bn4zY NZ004A 2026-01-13T14:27:25.436Z 2026-01-20T15:25:58.902Z
9191759 9191759 20260112114217_2wCeZ NZ004A 2026-01-13T14:26:19.368Z 2026-01-20T15:25:45.952Z
9191505 9191505 20260112111447_BmeHr NZ004A 2026-01-13T14:25:37.454Z 2026-01-20T15:25:36.505Z
9191269 9191269 20260112105005_rn0QO NZ004A 2026-01-13T14:24:55.672Z 2026-01-20T15:25:16.725Z
9191226 9191226 20260112104854_QbGhu NZ004A 2026-01-13T14:24:46.454Z 2026-01-20T15:25:15.188Z
9191204 9191204 20260112104542_QbWc3 NZ004A 2026-01-13T14:24:41.424Z 2026-01-20T15:25:14.463Z
9191079 9191079 20260112103139_MDwop NZ004A 2026-01-13T14:24:23.621Z 2026-01-20T15:25:09.397Z
9190983 9190983 20260112102320_Ff4LV NZ004A 2026-01-13T14:24:05.457Z 2026-01-20T15:25:06.404Z
9190875 9190875 20260112100841_Ao1K2 NZ004A 2026-01-13T14:23:43.101Z 2026-01-20T15:24:52.457Z
9190575 9190575 20260112092352_U1zBQ NZ004A 2026-01-13T14:22:47.506Z 2026-01-20T15:24:39.627Z
9190503 9190503 20260112091318_X3Eg1 NZ004A 2026-01-13T14:22:27.674Z 2026-01-20T15:24:36.252Z
9187209 9187209 20260111153953_xB37L NZ004A 2026-01-13T14:06:09.173Z 2026-01-20T15:20:09.342Z
9187155 9187155 20260111152500_YXNhJ NZ004A 2026-01-13T14:05:47.171Z 2026-01-20T15:20:03.618Z
9183312 9183312 20260111091345_LbGIr NZ004A 2026-01-12T14:17:25.682Z 2026-01-19T15:19:35.218Z

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