Linked Regionalstatistik

Welcome to the EXPERIMENTAL Regionaldatenbank Deutschland / Regionalstatistik wrapper to Linked Data — the German regional statistics served by the GENESIS platform, down to district (Kreis, AGS / NUTS-3) level. Data is modelled with the RDF Data Cube vocabulary; the data is open (dl-de/by-2.0).

We provide a table of contents of all tables (also available: table of contents as RDF). The catalogue is crawled from GENESIS and cached; the first request after startup may return 503 while it is being built. A ?selection={pattern} query returns a single statistic's tables immediately.

Nearby: code at Github.

Some Example Tables

Selected with the GRANERGIZE use case (energy data on individual buildings) in mind — building permits and completions broken down by heating energy carrier (district level), industrial energy use, and final energy consumption including private households.

./id/31111-06-01-4

Genehmigungen zur Errichtung neuer Wohngebäude und Nichtwohngebäude sowie Wohnungen in Wohngebäuden nach Zahl der Wohnungen und primär verwendeter Heizenergie — Jahressumme, Kreise und kreisfreie Städte (GENESIS)

./id/31121-06-01-4

Fertigstellungen neuer Wohngebäude und Nichtwohngebäude sowie Wohnungen in Wohngebäuden nach Zahl der Wohnungen und primär verwendeter Heizenergie — Jahressumme, Kreise und kreisfreie Städte (GENESIS)

./id/43531-01-02-4

Energieverbrauch im Verarbeitenden Gewerbe (industrial energy use), Kreise (GENESIS)

./id/86231-Z-01

Endenergieverbrauch insgesamt und der privaten Haushalte — Bundesländer (GENESIS)

./id/86251-Z-02

Anteil erneuerbarer Energien am Bruttostromverbrauch — Bundesländer (GENESIS)

Table IRIs follow the pattern ./id/{tableId} (RFC 6570); content negotiation resolves them to ./page/{tableId} (HTML) or ./data/{tableId} (RDF Data Cube — Turtle, or N-Triples with Accept: application/n-triples). A GENESIS account token (env GENESIS_API_TOKEN) is required for the data endpoints.

Some Example Codelists

./cl/geo

Shared SKOS code list of regional units (AGS Kreise, from the GENESIS KREISE variable); members are the shared ags/{code} resources referenced by the datasets.

./cl/ENRNW1

Energy carriers (a GENESIS classification variable).

./cl/VBR001

A further classification variable. Any GENESIS classification variable code works under ./cl/{varCode}.

Experimental Services

We provide a SPARQL query interface. Put bounded wrapper graphs in FROM (e.g. FROM <data/43531-01-02-4>, FROM <cl/geo>) and query them with the RDF Data Cube vocabulary; the endpoint fetches the named graphs as N-Triples and runs the query against them. See the per-table page for a ready-made example.

Documentation

For project updates and changes, see the CHANGELOG.

Source: Statistische Ämter des Bundes und der Länder. Licence: dl-de/by-2.0.