Open data API for Köln

Open data for Köln (Nordrhein-Westfalen) through a free, keyless REST API: weather, air quality, electricity price and more, delivered as consistent JSON with source and license on every response. No API key, no sign-up.

This city is also available as a ChatGPT GPT: open Köln Live in ChatGPT . All InfraNode GPTs.

Data with a guide for Köln

These data types have an in-depth guide; all are retrievable for Köln via the slug:

• Weather API for German cities /api/v1/cities/koeln/weather
• Air quality API for German cities /api/v1/cities/koeln/air-uba
• Electricity price API for Germany /api/v1/cities/koeln/power-price
• Land values API for German cities /api/v1/cities/koeln/land-values
• Solar API for German cities /api/v1/cities/koeln/solar
• Solar cadastre API for German cities /api/v1/cities/koeln/solar-roofs
• Real-time public transport API for German cities /api/v1/cities/koeln/station-departures
• Public procurement API for German cities /api/v1/cities/koeln/public-tenders
• Council information API for German cities /api/v1/cities/koeln/council-papers

How to fetch data for Köln

A simple GET request, no key and no sign-up:

curl https://infranode.dev/api/v1/cities/koeln/weather

Or air quality:

curl https://infranode.dev/api/v1/cities/koeln/air-uba

All 69 data types for Köln

Using the same slug, all 69 city data types can be retrieved for Köln. Where a source has nothing for Köln (yet), the API honestly returns no_data instead of an error. Parameters and example responses for each data type are in the linked reference:

• Administrative boundary per city (BKG VG250, Tier A) /api/v1/cities/koeln/geo
• Air quality per city (Federal Environment Agency) /api/v1/cities/koeln/air
• Air quality per city (Federal Environment Agency) /api/v1/cities/koeln/air-uba
• Autobahn webcams per city (Autobahn API, Tier A) /api/v1/cities/koeln/webcams
• Bathing water quality near a city (EEA, Tier A) /api/v1/cities/koeln/bathing-water
• Bicycle counting stations per city (municipal open data, Tier A) /api/v1/cities/koeln/bike-counts
• Bike/scooter sharing per city, aggregated (GBFS, Tier A) /api/v1/cities/koeln/sharing
• Building permits per city (GENESIS, Tier A) /api/v1/cities/koeln/construction
• Business registrations/deregistrations per district (Regionalstatistik, Tier A) /api/v1/cities/koeln/business-registrations
• Car stock and electric share per city (KBA, Tier A) /api/v1/cities/koeln/vehicle-registrations
• City master data from Wikidata /api/v1/cities/koeln/base
• City overview (catalog of all data types + live highlights) /api/v1/cities/koeln/overview
• City station catalog, all DB stations (StaDa, Tier A) /api/v1/cities/koeln/stations
• Current fuel prices per city, aggregated (Tankerkönig/MTS-K, Tier A) /api/v1/cities/koeln/fuel-prices
• Day-ahead wholesale electricity price, nationwide (SMARD, Tier A) /api/v1/cities/koeln/power-price
• Demographic time series per city (GENESIS/Regionalstatistik, Tier A) /api/v1/cities/koeln/demographics
• District-heating / heat-network supply per city, federated (Tier A) /api/v1/cities/koeln/district-heating
• Education facilities per city (OSM, Tier B) /api/v1/cities/koeln/education
• Election result per city (Federal Returning Officer, Tier A) /api/v1/cities/koeln/election
• Electricity consumption (grid load) per city's control zone (SMARD, Tier A) /api/v1/cities/koeln/power-load
• Elevator/escalator status at stations per city (DB FaSta, Tier A) /api/v1/cities/koeln/station-facilities
• Energy installations per city (MaStR, Tier A) /api/v1/cities/koeln/energy
• EV charging-station locations per city (BNetzA, Tier A) /api/v1/cities/koeln/charging
• Events per city (destination.one) /api/v1/cities/koeln/events
• Filed insolvencies per district (Regionalstatistik, Tier A) /api/v1/cities/koeln/insolvencies
• Flood warning levels per city (LHP, Tier A) /api/v1/cities/koeln/flood
• Forest-fire and grassland-fire danger index per city (DWD, Tier A) /api/v1/cities/koeln/fire-danger
• Government office wait times per city (live, keyless, Tier A) /api/v1/cities/koeln/office-wait-times
• Government offices per city (OSM, Tier B) /api/v1/cities/koeln/government-offices
• Heritage/listed monuments per city (state WFS, Tier A) /api/v1/cities/koeln/heritage
• Hospital locations per city (Bundes-Klinik-Atlas, fail-closed) /api/v1/cities/koeln/hospitals-atlas
• Hospital master data per city (Destatis directory, Tier A) /api/v1/cities/koeln/health
• Inner-city roadworks and closures per city (Tier A) /api/v1/cities/koeln/road-events
• Live arrival board for a city's main station, all categories (DB Timetables, Tier A) /api/v1/cities/koeln/station-arrivals
• Live departure board for a city's main station, all categories (DB Timetables, Tier A) /api/v1/cities/koeln/station-departures
• Live EV charging occupancy per city (eRound, CC0/Tier A) /api/v1/cities/koeln/charging-status
• Live ICU bed occupancy per city (DIVI, Tier C) /api/v1/cities/koeln/icu-live
• Local business/property tax rates per municipality (Regionalstatistik, Tier A) /api/v1/cities/koeln/tax-rates
• Markets per city (OSM, Tier B) /api/v1/cities/koeln/markets
• Municipal council information per city (OParl, Tier A) /api/v1/cities/koeln/council-papers
• Official BBK NINA civil protection warnings per city (Tier A) /api/v1/cities/koeln/civil-protection-warnings
• Official DWD weather warnings per city (Tier A) /api/v1/cities/koeln/weather-warnings
• Official land values per city, aggregated (BORIS, Tier A) /api/v1/cities/koeln/land-values
• Overnight stays and arrivals per city (GENESIS, Tier A) /api/v1/cities/koeln/tourism
• Parcel lockers per city (OSM, Tier B) /api/v1/cities/koeln/parcel-lockers
• Parking occupancy/catalogue per city (one endpoint, source fallback) /api/v1/cities/koeln/parking
• Playgrounds per city (OSM, Tier B) /api/v1/cities/koeln/playgrounds
• POIs per city, filtered by type (OSM, Tier B) /api/v1/cities/koeln/pois
• Police crime statistics per city (BKA PKS, Tier A) /api/v1/cities/koeln/crime-stats
• Pollen and UV index per city (DWD opendata, Tier A) /api/v1/cities/koeln/pollen-uv
• Population density per city (Census 2022 grid, Tier A) /api/v1/cities/koeln/population-density
• Post boxes per city, with collection times (OSM, Tier B) /api/v1/cities/koeln/post-boxes
• Post offices per city (OSM, Tier B) /api/v1/cities/koeln/post-offices
• Public drinking water fountains per city (OSM, Tier B) /api/v1/cities/koeln/drinking-water
• Public holidays and school vacations per city (seed, public domain) /api/v1/cities/koeln/holidays
• Public procurement notices per city (oeffentlichevergabe.de, Tier A) /api/v1/cities/koeln/public-tenders
• Public toilets per city (OSM, Tier B) /api/v1/cities/koeln/public-toilets
• Public Wi-Fi locations per city (OSM, Tier B) /api/v1/cities/koeln/public-wifi
• Public-transit stops per city (DELFI and HVV GTFS) /api/v1/cities/koeln/transit
• Recycling centres per city (OSM, Tier B) /api/v1/cities/koeln/recycling-centres
• Road traffic accidents per city (accident atlas, Tier A) /api/v1/cities/koeln/accidents
• Roadworks and traffic warnings per city (Autobahn API) /api/v1/cities/koeln/traffic
• Rooftop solar cadastre per city, federated (Tier A) /api/v1/cities/koeln/solar-roofs
• Socioeconomic indicators per city (INKAR/BBSR, Tier A) /api/v1/cities/koeln/indicators
• Solar irradiation + PV yield per city (PVGIS, Tier A) /api/v1/cities/koeln/solar
• Street-tree cadastre per city (municipal WFS, Tier A) /api/v1/cities/koeln/tree-cadastre
• Unemployment count and rate per city (GENESIS, Tier A) /api/v1/cities/koeln/unemployment
• Water level per city (PEGELONLINE, Tier A, partial coverage) /api/v1/cities/koeln/water-level
• Weather per city (DWD via Bright Sky) /api/v1/cities/koeln/weather

An overview of all cities is on the cities page. InfraNode is also available as an MCP server for AI assistants.

Köln via MCP server in Claude and ChatGPT

All open data for Köln is also available through the free, keyless InfraNode MCP server for AI agents. Connect it once to Claude or ChatGPT and ask in natural language, for example "Give me an overview of Köln" (calls get_city_overview, the catalog of all data types with live highlights) or more specifically "What is the weather in Köln?". Here is how to set it up: set up the MCP server.