Skip to content
czechdatasets

Czech register of schools and school facilities

The register of the Czech ministry of education (MŠMT) in six relational tables: schools and school facilities, capacities, fields of study and teaching sites with address and GPS.

Free sample

One-time payment, final price for a personal licence, switch to business at checkout · data as of 9 November 2026

You are buying the Elections 1996–2026 + schools bundle. It also includes: Election results 1996–2026.

An island with a village school with a bell tower and a wooden ballot box on a table in the schoolyardAn island with a village school with a bell tower and a wooden ballot box on a table in the schoolyard

How much work it saves

Flattening the hierarchical JSON-LD into tables, expanding eight MŠMT code lists into text, removing personal data and matching teaching sites to RÚIAN, the Czech register of addresses, buildings, parcels and territorial units (98.4%).

Measured on our own build

Lines of code and tests
676

We measured AI agent usage on 6 other datasets: the first working version of the code took 10m to 40m tokens and 21–62 mins of agent run time.

  • Free sample: all tables cut down to the Kutná Hora area, in CSV and Parquet. Download the sample
Data as of
9 November 2026
Rows
127,930
Tables
6
Formats
PostgreSQL, Parquet, CSV, JSON
Source licence
Free use (NKOD), addresses CC BY 4.0

What’s inside

All schools and school facilities in the Czech Republic from the MŠMT register: legal entities, founders, schools and facilities, capacities, places of activity matched to RÚIAN with GPS, fields of study. Codes from the code lists are expanded into text.

TableRows
pravnicke_osobyLegal entities running schools and school facilities (head offices), with the registered office address linked to RÚIAN9,977
zrizovateleFounders of the legal entities. For natural persons (including self-employed ones) the name and the IČO, the Czech company ID number, are left out; only the type of person remains8,946
skoly_zarizeniSchools and school facilities (IZO, the facility identifier) with kind/type expanded, language and capacity27,386
kapacityCapacities of schools and school facilities (a facility may have several units of measure)27,353
mista_vykonuPlaces of activity (teaching sites) of schools and facilities, with an address linked to RÚIAN and GPS38,743
oboryFields of study taught at schools (secondary schools, tertiary professional schools, primary schools, conservatoires …)15,525

Downloads

Every format contains the same data. Download only the one you need; verify its integrity with the SHA256SUMS file.

FormatFilesSize
PostgreSQLschema.sql with types, keys, indexes and comments, and import.sh, which loads the data from CSV214 kB
ParquetOne file per table (zstd). DuckDB, Polars and pandas read it without an import.62.5 MB
CSVUTF-8, comma-separated, with a header; large tables as .csv.gz616 MB
JSONAn array of objects; large tables as JSON Lines (.jsonl.gz)643 MB

Code example

More examples for SQL, DuckDB, Python and Node.js are in the README.md inside the bundle.

Primary schools in BrnoDuckDB
-- základní školy v Brně s GPS
SELECT s.izo, s.nazev, m.ulice, m.cislo_orientacni, m.lat, m.lon
FROM 'parquet/skoly_zarizeni.parquet' s
JOIN 'parquet/mista_vykonu.parquet' m USING (izo)
WHERE s.druh_kod = 'B00' AND m.obec = 'Brno';
Grammar schools (gymnázia)Node.js
import fs from "node:fs";
const skoly = JSON.parse(fs.readFileSync("json/skoly_zarizeni.json", "utf8"));
const gymnazia = skoly.filter(s => s.druh_kod === "C00" && /gymnázium/i.test(s.nazev));

Source and licence

Processed by
czechdatasets.com. The data is modified and is not an official output of the authority; the required attribution is in LICENCE.txt.

Joins with

Datasets share RÚIAN codes and IČO, so one JOIN connects them.

RÚIAN with history

Complete RÚIAN data: Czech parcels, buildings, addresses, streets and territorial units for the whole country. The current state and every version since August 2015, month by month.

1,990 CZKDataset details

Population of municipalities 2000–2026

Population of every Czech municipality as of 1 January 2026 and every 1 January since 2000, by sex and age group. Plus regions, districts, ORP areas and city districts, all with national (RÚIAN) codes.

190 CZK in a bundleDataset details

More datasets

Elections 1996–2026 + schools for 390 CZK.

One-time payment, download right after paying, no account and no subscription. Updates to the dataset are included in the price. All 15 paid datasets together cost 2,490 CZK, 3,510 CZK less than buying them one by one.