Guatemala Open Data: Free Datasets from Official Sources (CSV and JSON)

Download the data files behind this site. Each one is compiled from an official or openly licensed source, which is named and linked below, and shows the date it was last refreshed.

14 datasets, 23 files. Every refresh date comes from our data monitor, not typed by hand.

Prices and money

Guatemala key statistics (CSV)

One tidy table of headline figures: exchange rate, food basket, fuel, electricity and minimum wage. Every row carries its unit, period, source, source URL and retrieval date. The three national fuel rows (their names end in _national_avg_estimated) are our estimates from MEM's Guatemala City prices, not MEM values.

Source: INE, Banguat, MEM, CNEE, MINTRAB (named on each row) · See the page built on this data

US dollar to quetzal reference rate

Banco de Guatemala's daily reference rate (tipo de cambio de referencia) for USD/GTQ.

Fuel prices

Prices per gallon of regular, premium and diesel that the Ministry of Energy and Mines (MEM) monitors in Guatemala City. The national and by-department figures in the file are our estimates, not MEM values; the file marks them in its departmentBasis field and its note.

Basic food basket (Canasta Básica Alimentaria)

INE's monthly cost of the basic food basket, urban and rural, per person and per family, plus the expanded basket.

Food basket prices by department

Average retail price of each basic-basket product in the markets DIACO checked, by department. One DIACO publication per file.

Wholesale farm-produce prices

Wholesale prices from the Ministry of Agriculture (MAGA): its monthly open-data file and its weekly report for La Terminal market in Guatemala City.

Construction materials price index (IPMC)

INE's monthly price index for construction materials (December 2018 = 100): the latest month overall, by section and per material, and the monthly series per material.

People

Population

INE's population estimates and projections for the country and its 22 departments, 2015 to 2035 (mid-year), and the World Bank's total, growth and urban-share series for Guatemala.

Weather, water and hazards

Earthquakes

Recent events from Guatemala's national seismic network (INSIVUMEH, local magnitude) and from the USGS for Guatemala and its surroundings. The two networks can report different magnitudes for the same event.

Hurricanes and tropical storms near Guatemala

Every storm in NOAA's HURDAT2 best-track record that passed within 200 km of Guatemala's centre point: Atlantic from 1851, Pacific from 1949. Parts of the country, such as the north of Petén, lie farther than 200 km from that point, so this is a list of storms near the centre, not of every storm that affected Guatemala. Stan (2005) and Eta (2020), for example, are not in it.

Wildfire hotspots

NASA FIRMS satellite fire detections over Guatemala in the last 24 hours, by department, and our daily record of the counts. NASA's requested acknowledgement is inside each file.

River levels

Station readings from INSIVUMEH's daily hydrology bulletin, by watershed. The status field (above, normal, below) is derived by us from the bulletin's own normal range; INSIVUMEH does not publish flood stages in this bulletin.

Chixoy reservoir

Reservoir readings and the generation limits on Chixoy's units, read from the daily and monthly post-dispatch reports of the wholesale power market administrator (AMM).

30-year climate averages for 35 places

Thirty-year monthly means (1996 to 2025) of high and low temperature, rainy days, rainfall and humidity for 35 places in Guatemala. These are gridded model values (ERA5 and ERA5-Land reanalysis, with ECMWF IFS analysis from 2017, through Open-Meteo, CC BY 4.0), not weather-station records.

How to load them

Every file is a plain URL, so a browser, a spreadsheet or a script can fetch it. One thing to know: our firewall turns away Python’s built-in downloader, so pandas.read_csv(url) on its own returns a 403 error. Fetch the file with requests first:

import io
import requests
import pandas as pd

base = "https://livinginguatemala.com/data/"

# Daily USD/GTQ reference rate (Banguat)
fx = pd.DataFrame(requests.get(base + "exchange-rates/history.json").json()["rates"])

# Headline figures, one row each
stats = pd.read_csv(io.StringIO(requests.get(base + "statistics/guatemala-key-stats.csv").text))

The JSON files are nested, not flat tables. Open one in a browser first to see its shape; most name their source and a date near the top (the key names vary from file to file), with the rows underneath.

Reuse terms

You are free to use, chart and republish these files. When you use our compiled files, we ask that you credit Living in Guatemala (livinginguatemala.com) with a link to this page.

The figures themselves come from the institutions named on each dataset, and we cannot grant or restrict rights over them. Cite the institution as the primary source and follow its terms where it sets any: the World Bank and Open-Meteo series are CC BY 4.0, the climate file also credits the Copernicus Climate Change Service for ERA5, and NASA asks for the FIRMS acknowledgement that is included in the wildfire files.

The files are compiled automatically and can contain errors. For anything that matters, check the figure at the source, which is linked on each dataset (for the CSV, on each row of the file).

How to cite

Living in Guatemala, [dataset name], livinginguatemala.com/open-data/, retrieved [date]. Original source: [institution named on the dataset].

What is not here

This page lists only files compiled from official or openly licensed sources. It leaves out prices we collect from the websites of shops and other businesses, and it leaves out files built on our own ratings, such as the scores on the map. Where a listed file carries a value we estimated or derived ourselves, its description above says which one.

A file also drops off this list by itself when its source stops answering and the data goes stale, and it returns when the data is fresh again. Its address keeps working in the meantime.

For the raw official files, go to the institutions directly. Data Sources lists the ones we read and how often. Found an error, or need another file? Write to us.