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,599 rows where station_code = "NZ005D" 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
9626785 9626785 20260408150357_FkMEG NZ005D 2026-04-09T12:09:10.693Z 2026-04-10T12:14:22.413Z
9626779 9626779 20260408150342_7YVaY NZ005D 2026-04-09T12:09:10.208Z 2026-04-10T12:14:22.412Z
9626718 9626718 20260408145835_881v2 NZ005D 2026-04-09T12:09:05.458Z 2026-04-10T12:14:22.404Z
9626640 9626640 20260408142950_eMgQo NZ005D 2026-04-09T12:08:49.868Z 2026-04-10T12:14:22.387Z
9626568 9626568 20260408141710_3DEFL NZ005D 2026-04-09T12:08:41.997Z 2026-04-10T12:14:22.374Z
9626494 9626494 20260408140624_9MS0k NZ005D 2026-04-09T12:08:27.470Z 2026-04-10T12:14:22.361Z
9626483 9626483 20260408140549_675cc NZ005D 2026-04-09T12:08:25.859Z 2026-04-10T12:14:22.359Z
9626456 9626456 20260408140421_cD5Fo NZ005D 2026-04-09T12:08:22.938Z 2026-04-10T12:14:22.356Z
9626440 9626440 20260408140357_8Aht2 NZ005D 2026-04-09T12:08:21.472Z 2026-04-10T12:14:22.353Z
9626403 9626403 20260408135554_7TgxX NZ005D 2026-04-09T12:08:16.387Z 2026-04-10T12:14:22.347Z
9626309 9626309 20260408134018_S283M NZ005D 2026-04-09T12:07:57.505Z 2026-04-10T12:14:22.331Z
9626297 9626297 20260408133926_FNYeo NZ005D 2026-04-09T12:07:55.724Z 2026-04-10T12:14:22.330Z
9626175 9626175 20260408132204_GRcum NZ005D 2026-04-09T12:07:43.980Z 2026-04-10T12:14:22.314Z
9625907 9625907 20260408122303_JDVGy NZ005D 2026-04-09T12:07:05.305Z 2026-04-10T12:14:22.262Z
9625848 9625848 20260408120619_q2sYu NZ005D 2026-04-09T12:06:58.795Z 2026-04-10T12:14:22.253Z
9610206 9610206 20260405143855_CmMhJ NZ005D 2026-04-06T12:06:21.356Z 2026-04-10T12:27:00.138Z
9610204 9610204 20260405143412_Q3O3j NZ005D 2026-04-06T12:06:20.615Z 2026-04-10T12:27:00.082Z
9610202 9610202 20260405143246_Cudcv NZ005D 2026-04-06T12:06:19.738Z 2026-04-10T12:26:59.916Z
9610197 9610197 20260405142658_vWvVW NZ005D 2026-04-06T12:06:18.610Z 2026-04-10T12:26:59.740Z
9606037 9606037 20260403143138_YWVIH NZ005D 2026-04-04T12:05:02.975Z 2026-04-10T12:32:19.514Z
9606001 9606001 20260403140427_1nPOz NZ005D 2026-04-04T12:04:55.001Z 2026-04-10T12:32:18.593Z
9605968 9605968 20260403133603_vwgTu NZ005D 2026-04-04T12:04:42.821Z 2026-04-10T12:32:17.264Z
9605939 9605939 20260403131959_5XTjv NZ005D 2026-04-04T12:04:32.343Z 2026-04-10T12:32:13.839Z
9605912 9605912 20260403125219_qFssu NZ005D 2026-04-04T12:04:25.808Z 2026-04-10T12:32:06.859Z
9605779 9605779 20260403120133_6q2uo NZ005D 2026-04-04T12:03:53.442Z 2026-04-10T12:31:45.722Z
9605738 9605738 20260403114521_7mz8K NZ005D 2026-04-04T12:03:39.363Z 2026-04-10T12:31:44.721Z
9605652 9605652 20260403111833_IEtqM NZ005D 2026-04-04T12:03:19.006Z 2026-04-10T12:31:41.997Z
9605639 9605639 20260403111451_rgIM5 NZ005D 2026-04-04T12:03:16.807Z 2026-04-10T12:31:41.409Z
9605545 9605545 20260403103753_KBSI5 NZ005D 2026-04-04T12:02:50.880Z 2026-04-10T12:31:38.351Z
9605525 9605525 20260403103114_7WnlR NZ005D 2026-04-04T12:02:46.792Z 2026-04-10T12:31:37.807Z
9605446 9605446 20260403100136_ki2pr NZ005D 2026-04-04T12:02:22.443Z 2026-04-10T12:31:36.149Z
9605398 9605398 20260403094512_DtCmY NZ005D 2026-04-04T12:02:03.475Z 2026-04-10T12:31:35.021Z
9605185 9605185 20260403073140_foocq NZ005D 2026-04-04T12:01:02.417Z 2026-04-10T12:31:30.206Z
9605141 9605141 20260403070510_Ygczr NZ005D 2026-04-04T12:00:53.527Z 2026-04-10T12:31:29.377Z
9603713 9603713 20260402115729_g2jtr NZ005D 2026-04-03T12:04:16.959Z 2026-04-10T12:34:07.834Z
9603515 9603515 20260402104540_FnOYq NZ005D 2026-04-03T12:03:18.969Z 2026-04-10T12:34:03.421Z
9603467 9603467 20260402103117_pzx8f NZ005D 2026-04-03T12:03:10.367Z 2026-04-10T12:34:02.566Z
9603379 9603379 20260402094633_02o3e NZ005D 2026-04-03T12:02:44.482Z 2026-04-10T12:34:00.800Z
9603361 9603361 20260402094359_3TDJX NZ005D 2026-04-03T12:02:42.613Z 2026-04-10T12:34:00.575Z
9603336 9603336 20260402093639_33WeT NZ005D 2026-04-03T12:02:39.045Z 2026-04-10T12:34:00.202Z
9603239 9603239 20260402090108_ffPqb NZ005D 2026-04-03T12:02:15.512Z 2026-04-10T12:33:58.453Z
9603209 9603209 20260402084341_HvYD1 NZ005D 2026-04-03T12:02:08.437Z 2026-04-10T12:33:57.923Z
9603202 9603202 20260402084146_xVpOT NZ005D 2026-04-03T12:02:07.395Z 2026-04-10T12:33:57.799Z
9599843 9599843 20260331170702_6IXUu NZ005D 2026-04-01T12:05:02.192Z 2026-04-09T12:47:38.953Z
9599494 9599494 20260331150417_1dKVE NZ005D 2026-04-01T12:03:48.193Z 2026-04-09T12:46:49.443Z
9599470 9599470 20260331145417_Ndw26 NZ005D 2026-04-01T12:03:42.817Z 2026-04-09T12:46:48.162Z
9599383 9599383 20260331142152_bZIKA NZ005D 2026-04-01T12:03:24.117Z 2026-04-09T12:46:46.822Z
9599380 9599380 20260331142151_3Z5dM NZ005D 2026-04-01T12:03:23.516Z 2026-04-09T12:46:46.818Z
9599352 9599352 20260331140547_k5nd9 NZ005D 2026-04-01T12:03:17.127Z 2026-04-09T12:46:46.430Z
9599326 9599326 20260331135855_3f83R NZ005D 2026-04-01T12:03:12.325Z 2026-04-09T12:46:46.006Z
9599319 9599319 20260331135445_XJ38o NZ005D 2026-04-01T12:03:10.391Z 2026-04-09T12:46:45.876Z
9599291 9599291 20260331134239_TOJvN NZ005D 2026-04-01T12:03:04.275Z 2026-04-09T12:46:45.528Z
9599285 9599285 20260331134206_qOXqC NZ005D 2026-04-01T12:03:03.006Z 2026-04-09T12:46:45.470Z
9599217 9599217 20260331125334_3O16C NZ005D 2026-04-01T12:02:46.251Z 2026-04-09T12:46:44.163Z
9599202 9599202 20260331124604_Gf7tK NZ005D 2026-04-01T12:02:43.727Z 2026-04-09T12:46:43.962Z
9599191 9599191 20260331124235_FvErj NZ005D 2026-04-01T12:02:41.967Z 2026-04-09T12:46:43.798Z
9599187 9599187 20260331123332_FXIco NZ005D 2026-04-01T12:02:40.790Z 2026-04-09T12:46:43.648Z
9599178 9599178 20260331122826_etXpx NZ005D 2026-04-01T12:02:38.165Z 2026-04-09T12:46:43.395Z
9599171 9599171 20260331122432_cDW6S NZ005D 2026-04-01T12:02:36.746Z 2026-04-09T12:46:42.695Z
9599064 9599064 20260331112056_JYIyp NZ005D 2026-04-01T12:02:13.890Z 2026-04-09T12:46:40.726Z
9599054 9599054 20260331111555_OwwmI NZ005D 2026-04-01T12:02:11.286Z 2026-04-09T12:46:40.643Z
9599028 9599028 20260331105448_SXtyM NZ005D 2026-04-01T12:02:06.047Z 2026-04-09T12:46:40.184Z
9599011 9599011 20260331104002_vRDJ1 NZ005D 2026-04-01T12:02:01.374Z 2026-04-09T12:46:39.813Z
9598909 9598909 20260331084725_YlZmk NZ005D 2026-04-01T12:01:31.199Z 2026-04-09T12:46:37.794Z
9598878 9598878 20260331081912_jPkQb NZ005D 2026-04-01T12:01:23.203Z 2026-04-09T12:46:37.286Z
9598857 9598857 20260331080102_HsBih NZ005D 2026-04-01T12:01:19.856Z 2026-04-09T12:46:36.872Z
9598837 9598837 20260331074549_dQvM3 NZ005D 2026-04-01T12:01:15.579Z 2026-04-09T12:46:36.617Z
9598831 9598831 20260331074144_ev6yy NZ005D 2026-04-01T12:01:14.373Z 2026-04-09T12:46:36.551Z
9598826 9598826 20260331074010_p6EmH NZ005D 2026-04-01T12:01:13.102Z 2026-04-09T12:46:36.405Z
9598797 9598797 20260331072053_tNtrd NZ005D 2026-04-01T12:01:07.071Z 2026-04-09T12:46:35.861Z
9598026 9598026 20260330173233_6DwqN NZ005D 2026-03-31T12:07:28.293Z 2026-04-08T12:44:23.675Z
9597935 9597935 20260330171820_qSRSV NZ005D 2026-03-31T12:07:18.472Z 2026-04-08T12:44:21.058Z
9597924 9597924 20260330171611_iXmv8 NZ005D 2026-03-31T12:07:17.501Z 2026-04-08T12:44:20.782Z
9597875 9597875 20260330171157_BHDOh NZ005D 2026-03-31T12:07:10.247Z 2026-04-08T12:44:19.679Z
9597736 9597736 20260330165520_jATY8 NZ005D 2026-03-31T12:06:56.757Z 2026-04-08T12:44:16.407Z
9597630 9597630 20260330164622_R5o3R NZ005D 2026-03-31T12:06:48.612Z 2026-04-08T12:44:07.452Z
9597512 9597512 20260330162725_VStAC NZ005D 2026-03-31T12:06:30.743Z 2026-04-08T12:43:44.568Z
9597459 9597459 20260330162215_mto2A NZ005D 2026-03-31T12:06:26.249Z 2026-04-08T12:43:43.572Z
9597349 9597349 20260330160909_hqh4J NZ005D 2026-03-31T12:06:13.294Z 2026-04-08T12:43:41.066Z
9597121 9597121 20260330151847_XBEXr NZ005D 2026-03-31T12:05:41.517Z 2026-04-08T12:43:33.227Z
9596409 9596409 20260330123106_J17nD NZ005D 2026-03-31T12:04:11.014Z 2026-04-08T12:42:53.480Z
9596387 9596387 20260330122634_cZvfZ NZ005D 2026-03-31T12:04:08.938Z 2026-04-08T12:42:50.907Z
9596369 9596369 20260330122505_wztWu NZ005D 2026-03-31T12:04:07.115Z 2026-04-08T12:42:50.649Z
9596320 9596320 20260330121858_9s25n NZ005D 2026-03-31T12:04:01.641Z 2026-04-08T12:42:49.489Z
9596271 9596271 20260330120038_eG9gl NZ005D 2026-03-31T12:03:54.462Z 2026-04-08T12:42:48.066Z
9596228 9596228 20260330115209_8xk85 NZ005D 2026-03-31T12:03:48.000Z 2026-04-08T12:42:46.982Z
9596220 9596220 20260330115016_Ih5iB NZ005D 2026-03-31T12:03:45.750Z 2026-04-08T12:42:46.110Z
9596213 9596213 20260330114641_N88lA NZ005D 2026-03-31T12:03:44.545Z 2026-04-08T12:42:44.218Z
9596159 9596159 20260330113027_A5OWl NZ005D 2026-03-31T12:03:37.566Z 2026-04-08T12:42:42.818Z
9596154 9596154 20260330112833_7gPs3 NZ005D 2026-03-31T12:03:36.652Z 2026-04-08T12:42:42.631Z
9596028 9596028 20260330104516_YuL3i NZ005D 2026-03-31T12:03:10.282Z 2026-04-08T12:42:38.845Z
9595978 9595978 20260330102228_vLtu0 NZ005D 2026-03-31T12:03:02.857Z 2026-04-08T12:42:37.791Z
9595972 9595972 20260330102020_z3waP NZ005D 2026-03-31T12:03:01.747Z 2026-04-08T12:42:37.580Z
9595950 9595950 20260330101330_Ya3Tk NZ005D 2026-03-31T12:02:58.885Z 2026-04-08T12:42:37.097Z
9595925 9595925 20260330101101_9ouOz NZ005D 2026-03-31T12:02:51.923Z 2026-04-08T12:42:36.317Z
9595919 9595919 20260330100551_Wpdqf NZ005D 2026-03-31T12:02:50.925Z 2026-04-08T12:42:36.154Z
9595783 9595783 20260330083847_i3YpF NZ005D 2026-03-31T12:02:29.568Z 2026-04-08T12:42:32.170Z
9595765 9595765 20260330083057_wcD5l NZ005D 2026-03-31T12:02:26.071Z 2026-04-08T12:42:31.485Z
9595649 9595649 20260330073807_ZR39V NZ005D 2026-03-31T12:02:04.407Z 2026-04-08T12:42:28.154Z
9591472 9591472 20260328164803_c4SLR NZ005D 2026-03-29T12:04:28.906Z 2026-04-06T12:39:17.361Z

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