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,007 rows where station_code = "NZ001S" 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
9610066 9610066 20260405122642_YGHV3 NZ001S 2026-04-06T12:05:29.959Z 2026-04-09T12:36:20.091Z
9610063 9610063 20260405122215_3O4Qh NZ001S 2026-04-06T12:05:29.183Z 2026-04-09T12:36:19.997Z
9610038 9610038 20260405120528_m62fs NZ001S 2026-04-06T12:05:22.535Z 2026-04-09T12:36:19.041Z
9609054 9609054 20260401153043_IqZxw NZ001S 2026-04-05T12:17:13.631Z 2026-04-09T12:45:30.015Z
9606044 9606044 20260403144045_PXHy8 NZ001S 2026-04-04T12:05:04.965Z 2026-04-09T12:42:06.812Z
9606032 9606032 20260403143136_O389c NZ001S 2026-04-04T12:05:02.499Z 2026-04-09T12:42:06.551Z
9606023 9606023 20260403142616_yHAM6 NZ001S 2026-04-04T12:05:00.279Z 2026-04-09T12:42:06.331Z
9605970 9605970 20260403133605_m6zxi NZ001S 2026-04-04T12:04:43.394Z 2026-04-09T12:42:05.205Z
9605774 9605774 20260403120133_6q2uo NZ001S 2026-04-04T12:03:53.442Z 2026-04-09T12:41:31.375Z
9605617 9605617 20260403110935_EHZ9L NZ001S 2026-04-04T12:03:07.858Z 2026-04-09T12:41:27.875Z
9605484 9605484 20260403101601_U4JDb NZ001S 2026-04-04T12:02:31.169Z 2026-04-09T12:41:23.381Z
9605431 9605431 20260403095753_LXxH8 NZ001S 2026-04-04T12:02:18.949Z 2026-04-09T12:41:22.214Z
9605410 9605410 20260403095043_96Imn NZ001S 2026-04-04T12:02:09.685Z 2026-04-09T12:41:21.869Z
9605132 9605132 20260403070409_U4jDI NZ001S 2026-04-04T12:00:52.507Z 2026-04-09T12:41:15.172Z
9604265 9604265 20260402164835_Zh8vX NZ001S 2026-04-03T12:06:35.181Z 2026-04-09T12:44:19.121Z
9604231 9604231 20260402164317_WrG33 NZ001S 2026-04-03T12:06:27.862Z 2026-04-09T12:44:18.517Z
9603792 9603792 20260402123747_yR8xl NZ001S 2026-04-03T12:04:35.598Z 2026-04-09T12:44:09.425Z
9603567 9603567 20260402110413_9qfHO NZ001S 2026-04-03T12:03:40.985Z 2026-04-09T12:44:04.140Z
9603533 9603533 20260402105352_EUMkL NZ001S 2026-04-03T12:03:26.410Z 2026-04-09T12:44:01.266Z
9603508 9603508 20260402104540_I6Qi2 NZ001S 2026-04-03T12:03:18.378Z 2026-04-09T12:43:57.826Z
9603433 9603433 20260402101817_1PacD NZ001S 2026-04-03T12:03:04.422Z 2026-04-09T12:43:43.902Z
9603193 9603193 20260402084145_iL5SL NZ001S 2026-04-03T12:02:06.938Z 2026-04-09T12:43:22.837Z
9603081 9603081 20260402073905_HAAuk NZ001S 2026-04-03T12:01:41.159Z 2026-04-09T12:43:19.443Z
9601757 9601757 20260401165230_ScKq6 NZ001S 2026-04-02T12:03:37.821Z 2026-04-09T12:45:35.722Z
9601691 9601691 20260401162923_N8kun NZ001S 2026-04-02T12:03:28.100Z 2026-04-09T12:45:33.625Z
9601663 9601663 20260401162759_upULf NZ001S 2026-04-02T12:03:24.935Z 2026-04-09T12:45:33.130Z
9601574 9601574 20260401155117_W3KHi NZ001S 2026-04-02T12:03:10.322Z 2026-04-09T12:45:31.480Z
9601441 9601441 20260401151938_AZwGY NZ001S 2026-04-02T12:02:47.865Z 2026-04-09T12:45:29.135Z
9601416 9601416 20260401150812_EeU8A NZ001S 2026-04-02T12:02:44.262Z 2026-04-09T12:45:28.745Z
9601362 9601362 20260401145145_hla2B NZ001S 2026-04-02T12:02:33.151Z 2026-04-09T12:45:27.797Z
9601284 9601284 20260401134803_gQjtz NZ001S 2026-04-02T12:02:16.631Z 2026-04-09T12:45:26.151Z
9601271 9601271 20260401134242_nXCX2 NZ001S 2026-04-02T12:02:12.050Z 2026-04-09T12:45:25.868Z
9601253 9601253 20260401133230_TmqwC NZ001S 2026-04-02T12:02:08.124Z 2026-04-09T12:45:25.556Z
9599638 9599638 20260331160930_3F4DE NZ001S 2026-04-01T12:04:19.917Z 2026-04-09T12:47:08.204Z
9599558 9599558 20260331154506_D0NW8 NZ001S 2026-04-01T12:04:03.150Z 2026-04-09T12:46:58.037Z
9599544 9599544 20260331153628_UDSmY NZ001S 2026-04-01T12:04:00.832Z 2026-04-09T12:46:56.708Z
9599395 9599395 20260331142435_WrtWn NZ001S 2026-04-01T12:03:26.869Z 2026-04-09T12:46:46.980Z
9599327 9599327 20260331135953_rlnZ9 NZ001S 2026-04-01T12:03:13.174Z 2026-04-09T12:46:46.068Z
9599320 9599320 20260331135514_339ed NZ001S 2026-04-01T12:03:11.095Z 2026-04-09T12:46:45.910Z
9599288 9599288 20260331134239_TOJvN NZ001S 2026-04-01T12:03:04.275Z 2026-04-09T12:46:45.528Z
9599251 9599251 20260331131924_e69u5 NZ001S 2026-04-01T12:02:54.456Z 2026-04-09T12:46:44.706Z
9599242 9599242 20260331131041_3mqBU NZ001S 2026-04-01T12:02:52.333Z 2026-04-09T12:46:44.591Z
9599214 9599214 20260331125334_3O16C NZ001S 2026-04-01T12:02:46.251Z 2026-04-09T12:46:44.163Z
9599192 9599192 20260331124235_C6S2w NZ001S 2026-04-01T12:02:42.317Z 2026-04-09T12:46:43.858Z
9599059 9599059 20260331112056_JYIyp NZ001S 2026-04-01T12:02:13.890Z 2026-04-09T12:46:40.726Z
9599019 9599019 20260331104656_wuMzR NZ001S 2026-04-01T12:02:04.211Z 2026-04-09T12:46:40.008Z
9598920 9598920 20260331090118_CS3NP NZ001S 2026-04-01T12:01:35.255Z 2026-04-09T12:46:38.023Z
9598794 9598794 20260331072053_tNtrd NZ001S 2026-04-01T12:01:07.012Z 2026-04-09T12:46:35.860Z
9595761 9595761 20260330083057_nMvqt NZ001S 2026-03-31T12:02:25.581Z 2026-04-08T12:42:31.451Z
9594147 9594147 20260328145355_Tirzx NZ001S 2026-03-30T12:08:23.725Z 2026-04-06T12:39:07.125Z
9593920 9593920 20260329165102_5sEZx NZ001S 2026-03-30T12:05:31.391Z 2026-04-07T12:27:39.892Z
9593886 9593886 20260329162926_BrXEi NZ001S 2026-03-30T12:05:23.635Z 2026-04-07T12:27:38.958Z
9591623 9591623 20260328173752_L2iTu NZ001S 2026-03-29T12:04:45.761Z 2026-04-06T12:39:25.883Z
9591619 9591619 20260328173230_sWEAQ NZ001S 2026-03-29T12:04:45.247Z 2026-04-06T12:39:25.649Z
9591605 9591605 20260328172547_sYEqz NZ001S 2026-03-29T12:04:44.695Z 2026-04-06T12:39:25.302Z
9591599 9591599 20260328172516_ovEpc NZ001S 2026-03-29T12:04:44.524Z 2026-04-06T12:39:25.121Z
9591597 9591597 20260328172445_QdyiZ NZ001S 2026-03-29T12:04:43.618Z 2026-04-06T12:39:24.969Z
9591585 9591585 20260328171604_mHbfq NZ001S 2026-03-29T12:04:39.436Z 2026-04-06T12:39:24.287Z
9591543 9591543 20260328170402_QmZwk NZ001S 2026-03-29T12:04:34.399Z 2026-04-06T12:39:22.291Z
9591527 9591527 20260328170302_Fh5xF NZ001S 2026-03-29T12:04:32.779Z 2026-04-06T12:39:19.790Z
9591503 9591503 20260328165745_leTNp NZ001S 2026-03-29T12:04:31.037Z 2026-04-06T12:39:18.807Z
9591474 9591474 20260328164803_R5X8V NZ001S 2026-03-29T12:04:29.046Z 2026-04-06T12:39:17.454Z
9591453 9591453 20260328164339_jfaXg NZ001S 2026-03-29T12:04:26.826Z 2026-04-06T12:39:16.375Z
9591389 9591389 20260328161342_C2dop NZ001S 2026-03-29T12:04:20.644Z 2026-04-06T12:39:13.633Z
9591374 9591374 20260328160734_xSou2 NZ001S 2026-03-29T12:04:19.466Z 2026-04-06T12:39:12.972Z
9591367 9591367 20260328155743_e2wjP NZ001S 2026-03-29T12:04:18.757Z 2026-04-06T12:39:12.607Z
9591349 9591349 20260328154842_wfeX8 NZ001S 2026-03-29T12:04:17.522Z 2026-04-06T12:39:12.022Z
9591344 9591344 20260328154722_bbbxL NZ001S 2026-03-29T12:04:17.122Z 2026-04-06T12:39:11.758Z
9591309 9591309 20260328153213_RkCLB NZ001S 2026-03-29T12:04:13.780Z 2026-04-06T12:39:10.549Z
9591264 9591264 20260328150431_xsTl5 NZ001S 2026-03-29T12:04:07.885Z 2026-04-06T12:39:08.308Z
9591179 9591179 20260328140024_dU2ig NZ001S 2026-03-29T12:03:58.256Z 2026-04-06T12:39:04.263Z
9591172 9591172 20260328140002_ILpVE NZ001S 2026-03-29T12:03:57.823Z 2026-04-06T12:39:04.046Z
9591164 9591164 20260328135500_U5jLG NZ001S 2026-03-29T12:03:57.123Z 2026-04-06T12:39:03.675Z
9591141 9591141 20260328134610_F2VvI NZ001S 2026-03-29T12:03:54.922Z 2026-04-06T12:39:02.713Z
9591116 9591116 20260328132750_aiO0E NZ001S 2026-03-29T12:03:51.950Z 2026-04-06T12:39:01.625Z
9591062 9591062 20260328125316_LPzg2 NZ001S 2026-03-29T12:03:46.868Z 2026-04-06T12:38:49.276Z
9590933 9590933 20260328120136_MmrWL NZ001S 2026-03-29T12:03:30.714Z 2026-04-06T12:38:41.126Z
9590656 9590656 20260328103630_Cam4P NZ001S 2026-03-29T12:03:05.173Z 2026-04-06T12:38:29.503Z
9590647 9590647 20260328103317_peqpO NZ001S 2026-03-29T12:03:04.366Z 2026-04-06T12:38:28.733Z
9590545 9590545 20260328095854_AQa8w NZ001S 2026-03-29T12:02:53.437Z 2026-04-06T12:38:23.481Z
9590512 9590512 20260328094823_klN1Q NZ001S 2026-03-29T12:02:50.227Z 2026-04-06T12:38:13.778Z
9590353 9590353 20260328082819_sN8Nb NZ001S 2026-03-29T12:02:28.177Z 2026-04-06T12:38:02.649Z
9587829 9587829 20260327162110_nq6oJ NZ001S 2026-03-28T12:06:28.801Z 2026-04-05T12:34:45.601Z
9587813 9587813 20260327161159_C8J40 NZ001S 2026-03-28T12:06:24.291Z 2026-04-05T12:34:44.602Z
9587788 9587788 20260327155927_lBrFp NZ001S 2026-03-28T12:06:21.048Z 2026-04-05T12:34:42.405Z
9587786 9587786 20260327155313_9bIjd NZ001S 2026-03-28T12:06:20.678Z 2026-04-05T12:34:42.328Z
9587784 9587784 20260327155143_OtK2y NZ001S 2026-03-28T12:06:20.401Z 2026-04-05T12:34:42.213Z
9587765 9587765 20260327153607_Rrzg9 NZ001S 2026-03-28T12:06:17.579Z 2026-04-05T12:34:41.099Z
9587725 9587725 20260327152248_po30Z NZ001S 2026-03-28T12:06:12.928Z 2026-04-05T12:34:38.831Z
9587717 9587717 20260327152019_lYhN9 NZ001S 2026-03-28T12:06:12.161Z 2026-04-05T12:34:38.609Z
9587689 9587689 20260327150741_W2vg9 NZ001S 2026-03-28T12:06:08.592Z 2026-04-05T12:34:37.462Z
9587623 9587623 20260327143848_ufxZP NZ001S 2026-03-28T12:05:56.244Z 2026-04-05T12:34:34.154Z
9587580 9587580 20260327142030_RDcTJ NZ001S 2026-03-28T12:05:51.572Z 2026-04-05T12:34:32.430Z
9587570 9587570 20260327141321_ai9Sj NZ001S 2026-03-28T12:05:50.490Z 2026-04-05T12:34:31.953Z
9587543 9587543 20260327135312_C9z2o NZ001S 2026-03-28T12:05:47.053Z 2026-04-05T12:34:30.823Z
9587539 9587539 20260327135307_zxXbB NZ001S 2026-03-28T12:05:46.771Z 2026-04-05T12:34:30.783Z
9587526 9587526 20260327134438_d46cu NZ001S 2026-03-28T12:05:45.014Z 2026-04-05T12:34:30.160Z
9587524 9587524 20260327134356_Bmyl1 NZ001S 2026-03-28T12:05:44.751Z 2026-04-05T12:34:30.033Z
9587513 9587513 20260327133947_qfVtt NZ001S 2026-03-28T12:05:43.867Z 2026-04-05T12:34:29.755Z
9587478 9587478 20260327131640_em6sC NZ001S 2026-03-28T12:05:38.325Z 2026-04-05T12:34:28.231Z

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