Open data files
Download the CSV files that power Skolkoll for analysis and reproducibility. Source- and field-specific rights terms apply. See the glossary for the distinction between data source and data file.
API status
API access is included in Kommunlicens Premium, Data and Koncern Enterprise when the organization has an active agreement with the API service. An organization administrator manages API keys. Contracted API access uses the organization's key and is not activated through public self-service. Without an API agreement, use the CSV files below or contact us about a curated Data export.
A private pilot for a specific integration may be agreed separately. Contacting us does not activate API access.
Available data files
Choose version
The current version downloads as CSV. If you choose an earlier date, the links switch to historical JSON plus metadata for that specific run.
Current version selected. Downloads use the standard CSV files.
Variable documentation
Key columns in each data file. Column names match the download files.
School units
| Column |
|---|
skolenhetskod |
skolenhetNamn |
huvudmanNamn |
huvudmanOrgNr |
municipalityName |
municipalityCode |
schoolTypes |
status |
totalPupils |
meritRating9 |
certifiedTeachersPercent |
studentsPerTeacher |
Municipality indicators
| Column |
|---|
kommunkod |
kommunName |
costPerPupilGrundskola |
avgMerit |
certifiedTeachers |
pupilsPerTeacher |
independentShare |
salsaResidual |
populationGrowth |
Historical municipality series
| Column |
|---|
kommunkod |
kommunName |
year |
kpiId |
value |
Upper-secondary admissions
| Column |
|---|
schoolCode |
schoolName |
municipality |
programme |
programmeCode |
specialisation |
year |
admissionsScore |
scoreMeasure |
How to import
Excel / Google Sheets
Open Excel or Google Sheets, go to Data, then From Text/CSV (or File, then Import in Sheets). Select the downloaded CSV file. Set delimiter to comma and encoding to UTF-8.
Python (pandas)
import pandas as pddf = pd.read_csv("skolor.csv")
The files use UTF-8 encoding and comma delimiters.
R
library(readr)schools <- read_csv("skolor.csv")
What the files are for
Who are these files useful for?
Researchers, journalists, municipalities, school organisers and anyone who wants reproducible data files behind Skolkoll's views.
Are the files raw?
No. They are processed exports from the same pipeline that powers the site, which means that identifiers, joins and fallbacks have already been normalised.
Where do the numbers come from?
Primarily Skolverket, Kolada, SCB, Bolagsverket and regional admissions sources. See the method and settings pages for source notes.
What licence applies?
Rights and attribution vary by source and field. Skolkoll grants no blanket sublicence to third-party data. Review the versioned rights matrix before reuse.
How often are the files updated?
The CSV files are regenerated on every site build. Skolverket data updates daily, Kolada monthly, SCB annually. See the data source table for details.
More data sources
Want to know more about which data sources Skolkoll uses and how the data is collected? See Data sources for a full list.
Want all data files with full metadata, previews and a DCAT catalogue? Visit the open-data portal (currently Swedish-only).
Building an AI agent or browser agent? See theAI guide for Skolkoll's open data, with machine-readable descriptions of the open data files.
Missing data, or have suggestions for new data files? Email info@skolspegeln.se.