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

1,377 rows where station_code = "NZ005Q" 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
9626710 9626710 20260408145413_2wzPu NZ005Q 2026-04-09T12:09:04.306Z 2026-04-09T12:09:04.306Z
9626676 9626676 20260408144823_2A3B7 NZ005Q 2026-04-09T12:08:55.498Z 2026-04-09T12:08:55.498Z
9626571 9626571 20260408141748_2jcyo NZ005Q 2026-04-09T12:08:42.423Z 2026-04-09T12:08:42.423Z
9626479 9626479 20260408140535_hNkNu NZ005Q 2026-04-09T12:08:25.248Z 2026-04-09T12:08:25.248Z
9626427 9626427 20260408140228_v2S38 NZ005Q 2026-04-09T12:08:19.750Z 2026-04-09T12:08:19.750Z
9626337 9626337 20260408134352_pbOuN NZ005Q 2026-04-09T12:08:09.807Z 2026-04-09T12:08:09.807Z
9626113 9626113 20260408131144_4Qq9i NZ005Q 2026-04-09T12:07:36.208Z 2026-04-09T12:07:36.208Z
9626059 9626059 20260408130223_RdWgj NZ005Q 2026-04-09T12:07:25.141Z 2026-04-09T12:07:25.141Z
9626026 9626026 20260408125330_Gs3Yz NZ005Q 2026-04-09T12:07:20.904Z 2026-04-09T12:07:20.904Z
9625993 9625993 20260408124716_QX8Jr NZ005Q 2026-04-09T12:07:15.863Z 2026-04-09T12:07:15.863Z
9625952 9625952 20260408123327_NsjwK NZ005Q 2026-04-09T12:07:10.976Z 2026-04-09T12:07:10.976Z
9606326 9606326 20260403170507_Ih9WI NZ005Q 2026-04-04T12:06:23.847Z 2026-04-09T12:42:14.104Z
9606299 9606299 20260403165930_nWwuk NZ005Q 2026-04-04T12:06:18.366Z 2026-04-09T12:42:13.616Z
9606241 9606241 20260403163407_J06hl NZ005Q 2026-04-04T12:06:08.064Z 2026-04-09T12:42:12.236Z
9606158 9606158 20260403154825_JIOV3 NZ005Q 2026-04-04T12:05:39.156Z 2026-04-09T12:42:09.835Z
9605897 9605897 20260403124331_PlBlI NZ005Q 2026-04-04T12:04:23.138Z 2026-04-09T12:42:03.280Z
9605826 9605826 20260403121054_rURBB NZ005Q 2026-04-04T12:04:02.971Z 2026-04-09T12:41:54.930Z
9604308 9604308 20260402170508_lH0bC NZ005Q 2026-04-03T12:06:49.005Z 2026-04-09T12:44:20.043Z
9604254 9604254 20260402164747_zOusG NZ005Q 2026-04-03T12:06:33.501Z 2026-04-09T12:44:18.895Z
9604101 9604101 20260402154714_GsW9o NZ005Q 2026-04-03T12:05:55.280Z 2026-04-09T12:44:15.605Z
9603968 9603968 20260402142441_OAVKa NZ005Q 2026-04-03T12:05:21.882Z 2026-04-09T12:44:12.602Z
9603961 9603961 20260402142213_GV662 NZ005Q 2026-04-03T12:05:20.662Z 2026-04-09T12:44:12.516Z
9603795 9603795 20260402123747_u0jIv NZ005Q 2026-04-03T12:04:35.940Z 2026-04-09T12:44:09.454Z
9603768 9603768 20260402121523_A6fuO NZ005Q 2026-04-03T12:04:29.156Z 2026-04-09T12:44:08.691Z
9603741 9603741 20260402115953_d45Gu NZ005Q 2026-04-03T12:04:21.311Z 2026-04-09T12:44:07.957Z
9603565 9603565 20260402110412_IWCCb NZ005Q 2026-04-03T12:03:40.688Z 2026-04-09T12:44:04.054Z
9603474 9603474 20260402103120_UgtO5 NZ005Q 2026-04-03T12:03:10.699Z 2026-04-09T12:43:50.318Z
9603468 9603468 20260402103117_pzx8f NZ005Q 2026-04-03T12:03:10.367Z 2026-04-09T12:43:49.733Z
9603375 9603375 20260402094414_wwIrT NZ005Q 2026-04-03T12:02:43.999Z 2026-04-09T12:43:30.623Z
9601860 9601860 20260401171538_hRJ13 NZ005Q 2026-04-02T12:03:57.024Z 2026-04-09T12:45:37.155Z
9601670 9601670 20260401162823_TN3dt NZ005Q 2026-04-02T12:03:25.706Z 2026-04-09T12:45:33.252Z
9601465 9601465 20260401152406_d21ba NZ005Q 2026-04-02T12:02:51.699Z 2026-04-09T12:45:29.461Z
9601344 9601344 20260401143442_HZ8NF NZ005Q 2026-04-02T12:02:29.083Z 2026-04-09T12:45:27.318Z
9601336 9601336 20260401142258_of4zX NZ005Q 2026-04-02T12:02:27.529Z 2026-04-09T12:45:27.203Z
9601270 9601270 20260401134111_evPtU NZ005Q 2026-04-02T12:02:11.349Z 2026-04-09T12:45:25.848Z
9598035 9598035 20260330173323_x4eEL NZ005Q 2026-03-31T12:07:28.937Z 2026-04-08T12:44:23.830Z
9597916 9597916 20260330171512_ttJcl NZ005Q 2026-03-31T12:07:16.854Z 2026-04-08T12:44:20.608Z
9597903 9597903 20260330171413_0k6JV NZ005Q 2026-03-31T12:07:14.367Z 2026-04-08T12:44:20.114Z
9597796 9597796 20260330170026_JG2ns NZ005Q 2026-03-31T12:07:01.255Z 2026-04-08T12:44:17.619Z
9597784 9597784 20260330165841_Oe3TU NZ005Q 2026-03-31T12:06:59.939Z 2026-04-08T12:44:17.270Z
9597771 9597771 20260330165826_7Z2Qx NZ005Q 2026-03-31T12:06:59.182Z 2026-04-08T12:44:16.971Z
9597730 9597730 20260330165340_2IBpE NZ005Q 2026-03-31T12:06:55.937Z 2026-04-08T12:44:16.224Z
9597677 9597677 20260330164947_TtclC NZ005Q 2026-03-31T12:06:51.894Z 2026-04-08T12:44:14.910Z
9597656 9597656 20260330164749_AjywN NZ005Q 2026-03-31T12:06:50.281Z 2026-04-08T12:44:13.089Z
9597612 9597612 20260330164206_RZd4u NZ005Q 2026-03-31T12:06:46.606Z 2026-04-08T12:44:04.211Z
9597588 9597588 20260330163805_XLy3X NZ005Q 2026-03-31T12:06:41.007Z 2026-04-08T12:43:54.006Z
9597495 9597495 20260330162528_9BU9M NZ005Q 2026-03-31T12:06:28.776Z 2026-04-08T12:43:44.184Z
9597478 9597478 20260330162312_ji33w NZ005Q 2026-03-31T12:06:27.401Z 2026-04-08T12:43:43.901Z
9597374 9597374 20260330161126_42jDm NZ005Q 2026-03-31T12:06:16.099Z 2026-04-08T12:43:41.471Z
9597316 9597316 20260330155942_9fFlg NZ005Q 2026-03-31T12:06:07.200Z 2026-04-08T12:43:40.300Z
9597296 9597296 20260330155830_4uDIo NZ005Q 2026-03-31T12:06:05.684Z 2026-04-08T12:43:37.906Z
9597080 9597080 20260330150918_BJ3iY NZ005Q 2026-03-31T12:05:37.075Z 2026-04-08T12:43:32.107Z
9596846 9596846 20260330141538_R3PMN NZ005Q 2026-03-31T12:05:04.254Z 2026-04-08T12:43:25.869Z
9596794 9596794 20260330140409_8sQto NZ005Q 2026-03-31T12:04:58.190Z 2026-04-08T12:43:24.706Z
9596718 9596718 20260330134734_eIrhf NZ005Q 2026-03-31T12:04:47.925Z 2026-04-08T12:43:22.942Z
9596711 9596711 20260330134618_wEKSQ NZ005Q 2026-03-31T12:04:46.975Z 2026-04-08T12:43:22.862Z
9596679 9596679 20260330134100_r0q37 NZ005Q 2026-03-31T12:04:42.377Z 2026-04-08T12:43:22.227Z
9596587 9596587 20260330131719_kSBDx NZ005Q 2026-03-31T12:04:32.853Z 2026-04-08T12:43:19.909Z
9596489 9596489 20260330124837_r8E3B NZ005Q 2026-03-31T12:04:23.757Z 2026-04-08T12:43:17.417Z
9596381 9596381 20260330122544_Uaovx NZ005Q 2026-03-31T12:04:08.103Z 2026-04-08T12:42:50.801Z
9596370 9596370 20260330122505_wztWu NZ005Q 2026-03-31T12:04:07.115Z 2026-04-08T12:42:50.649Z
9596148 9596148 20260330112448_WMeET NZ005Q 2026-03-31T12:03:35.719Z 2026-04-08T12:42:42.459Z
9595962 9595962 20260330101552_71OCh NZ005Q 2026-03-31T12:03:00.393Z 2026-04-08T12:42:37.344Z
9587497 9587497 20260327132843_chmsm NZ005Q 2026-03-28T12:05:40.343Z 2026-04-05T12:34:28.891Z
9587477 9587477 20260327131525_8mKlg NZ005Q 2026-03-28T12:05:38.017Z 2026-04-05T12:34:28.092Z
9587475 9587475 20260327131049_26Gh5 NZ005Q 2026-03-28T12:05:37.722Z 2026-04-05T12:34:28.003Z
9587435 9587435 20260327124614_MR9U7 NZ005Q 2026-03-28T12:05:30.606Z 2026-04-05T12:34:26.331Z
9587429 9587429 20260327124013_oTQhw NZ005Q 2026-03-28T12:05:29.723Z 2026-04-05T12:34:26.024Z
9587421 9587421 20260327123815_kpt6z NZ005Q 2026-03-28T12:05:28.458Z 2026-04-05T12:34:25.853Z
9587315 9587315 20260327120210_hrhi0 NZ005Q 2026-03-28T12:05:15.030Z 2026-04-05T12:34:12.670Z
9587271 9587271 20260327115808_QABwV NZ005Q 2026-03-28T12:05:10.237Z 2026-04-05T12:34:10.885Z
9587260 9587260 20260327115628_zBLFu NZ005Q 2026-03-28T12:05:09.226Z 2026-04-05T12:34:10.521Z
9587005 9587005 20260327104340_bsMD5 NZ005Q 2026-03-28T12:04:32.856Z 2026-04-05T12:33:58.138Z
9578280 9578280 20260325110746_eAJ5z NZ005Q 2026-03-26T12:07:12.351Z 2026-04-03T12:37:55.338Z
9572880 9572880 20260324104346_Xsh63 NZ005Q 2026-03-25T12:06:35.418Z 2026-04-02T12:35:42.109Z
9569581 9569581 20260322161706_KPfad NZ005Q 2026-03-24T12:21:26.344Z 2026-03-30T12:30:10.069Z
9568333 9568333 20260323163157_ww0bN NZ005Q 2026-03-24T12:14:53.246Z 2026-03-31T12:28:27.395Z
9567807 9567807 20260323155108_a9j3g NZ005Q 2026-03-24T12:14:10.388Z 2026-03-31T12:28:19.152Z
9567672 9567672 20260323153930_jM8Fo NZ005Q 2026-03-24T12:13:56.858Z 2026-03-31T12:28:17.326Z
9567060 9567060 20260323143538_TXlfg NZ005Q 2026-03-24T12:12:54.132Z 2026-03-31T12:28:07.708Z
9566843 9566843 20260323141818_ApYe1 NZ005Q 2026-03-24T12:12:32.072Z 2026-03-31T12:28:05.032Z
9566553 9566553 20260323135058_c41ku NZ005Q 2026-03-24T12:12:04.155Z 2026-03-31T12:27:53.595Z
9566367 9566367 20260323132914_dvqm3 NZ005Q 2026-03-24T12:11:43.637Z 2026-03-31T12:27:49.440Z
9566047 9566047 20260323130059_HWWkC NZ005Q 2026-03-24T12:11:15.003Z 2026-03-31T12:27:45.177Z
9565925 9565925 20260323125136_Ya1hC NZ005Q 2026-03-24T12:11:01.660Z 2026-03-31T12:27:43.494Z
9565878 9565878 20260323124755_ehlJ0 NZ005Q 2026-03-24T12:10:58.058Z 2026-03-31T12:27:42.646Z
9565805 9565805 20260323124140_11O7D NZ005Q 2026-03-24T12:10:53.109Z 2026-03-31T12:27:41.719Z
9565684 9565684 20260323123311_WDD6P NZ005Q 2026-03-24T12:10:38.892Z 2026-03-31T12:27:39.789Z
9565356 9565356 20260323120234_byFNF NZ005Q 2026-03-24T12:09:56.889Z 2026-03-31T12:27:33.687Z
9565349 9565349 20260323120233_MjRyc NZ005Q 2026-03-24T12:09:56.427Z 2026-03-31T12:27:33.606Z
9565213 9565213 20260323115015_spt3j NZ005Q 2026-03-24T12:09:37.639Z 2026-03-31T12:27:30.987Z
9565155 9565155 20260323114738_Yr2PS NZ005Q 2026-03-24T12:09:30.598Z 2026-03-31T12:27:23.926Z
9565102 9565102 20260323114514_6aWAj NZ005Q 2026-03-24T12:09:25.480Z 2026-03-31T12:27:22.982Z
9564986 9564986 20260323113402_UVMCh NZ005Q 2026-03-24T12:09:11.848Z 2026-03-31T12:27:20.332Z
9564920 9564920 20260323112304_tquP1 NZ005Q 2026-03-24T12:09:01.873Z 2026-03-31T12:27:19.045Z
9564751 9564751 20260323110626_TtAyq NZ005Q 2026-03-24T12:08:44.810Z 2026-03-31T12:27:14.933Z
9564732 9564732 20260323110406_QiIYT NZ005Q 2026-03-24T12:08:39.585Z 2026-03-31T12:27:14.326Z
9564558 9564558 20260323104959_s80Da NZ005Q 2026-03-24T12:08:22.907Z 2026-03-31T12:27:11.661Z
9564461 9564461 20260323103737_I44ZV NZ005Q 2026-03-24T12:08:08.909Z 2026-03-31T12:27:09.541Z
9563873 9563873 20260323092423_5dxwf NZ005Q 2026-03-24T12:06:53.747Z 2026-03-31T12:26:58.183Z

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