no key · no human

koelner.de API, RSS and sitemap

Every article koelner.de publishes, as JSON, through an open API with no key and no signup. 772 of their articles are indexed right now, refreshed hourly.

GermanyGerman#3,499 by volume

Four ways to pull koelner.de

All four are ours, all four are live, and none of them needs a key.

JSON Search this publisher

Every article we hold from koelner.de, newest first. Add q= to search inside.

curl -s "https://freenewsapi.ai/v1/search?host=www.koelner.de&size=20"open it →

RSS Subscribe in any reader

The same articles as an RSS 2.0 feed. Works in Feedly, Inoreader, Thunderbird — anywhere.

curl -s "https://freenewsapi.ai/v1/rss?host=www.koelner.de&size=50"open it →

JSON Feed For apps

JSON Feed 1.1, the same content in a format apps parse natively.

curl -s "https://freenewsapi.ai/v1/feed.json?host=www.koelner.de&size=50"open it →

Trimmed For agents

Only the fields an agent needs — title, url, date, language — so the response stays small.

curl -s "https://freenewsapi.ai/v1/search?host=www.koelner.de&size=20&fields=title,url,published_at,lang"open it →

Call the API

A live request. Paste it into a terminal and koelner.de headlines come back as JSON.

bash
curl "https://freenewsapi.ai/v1/search?host=www.koelner.de&size=5"
772
articles indexed
146
in the last 30 days
4
median per day
1
languages
220 min
median crawl lag
08.06 → 04.09
archive depth

Publishing volume

Articles per day over the last 57 days. The busiest hour is 14:00 UTC — that is when the newsroom pushes its main batch.

2026-06-08: 6 articles2026-06-09: 1 articles2026-06-10: 1 articles2026-06-11: 1 articles2026-06-15: 6 articles2026-06-16: 2 articles2026-06-17: 4 articles2026-06-18: 3 articles2026-06-19: 2 articles2026-06-22: 2 articles2026-06-23: 1 articles2026-06-24: 28 articles2026-06-25: 5 articles2026-06-26: 4 articles2026-06-29: 6 articles2026-06-30: 5 articles2026-07-02: 13 articles2026-07-03: 54 articles2026-07-06: 30 articles2026-07-07: 4 articles2026-07-09: 4 articles2026-07-10: 5 articles2026-07-13: 14 articles2026-07-14: 2 articles2026-07-15: 4 articles2026-07-16: 17 articles2026-07-17: 2 articles2026-07-20: 1 articles2026-07-21: 2 articles2026-07-22: 38 articles2026-07-23: 28 articles2026-07-27: 3 articles2026-07-28: 5 articles2026-07-29: 190 articles2026-07-30: 116 articles2026-07-31: 5 articles2026-08-03: 9 articles2026-08-04: 4 articles2026-08-05: 5 articles2026-08-10: 6 articles2026-08-11: 16 articles2026-08-12: 2 articles2026-08-13: 15 articles2026-08-17: 10 articles2026-08-18: 3 articles2026-08-19: 2 articles2026-08-20: 2 articles2026-08-21: 1 articles2026-08-24: 1 articles2026-08-25: 2 articles2026-08-27: 3 articles2026-08-28: 2 articles2026-08-31: 5 articles2026-09-01: 6 articles2026-09-02: 4 articles2026-09-03: 13 articles2026-09-04: 53 articles06-0806-2207-0607-2008-0308-1909-0209-04
bash
curl "https://freenewsapi.ai/v1/stats?host=www.koelner.de&top=10"

Publishing rhythm

When koelner.de actually publishes, by hour of day (UTC) and by day of week — measured from 772 timestamps, not from a schedule they advertise.

00: 00001: 00102: 00203: 00304: 00405: 00506: 00607: 00708: 300809: 900910: 1001011: 1111112: 571213: 851314: 1241415: 1081516: 701617: 31718: 01819: 01920: 02021: 02122: 02223: 023
Mon: 99MonTue: 53TueWed: 278WedThu: 220ThuFri: 128FriSat: 0SatSun: 0Sun

Sections

Sections come from the publisher's own markup, present on 18% of their articles.

Languages

CodeLanguageArticlesShare
deGerman778100.8%

Latest articles

The 18 most recent koelner.de articles in the index — the same rows the API returns, rendered for humans.

reiheM präsentiert: Pedro A. Ramirez / Luis Antunes Pena & Anders Førisdal
2026-09-04 15:16 UTC
06.10.2026 20:00 Loft Wißmannstr. 30, 50823 Köln 4. September 2026 15:16 Klangkunst, Elektronik, Modularsynthesizer Zurück zu den Suchergebnissen Info StandortLoft Wißman
Hinterhofchor
2026-09-04 15:01 UTC
Lutherkirche Südstadt Martin-Luther-Platz 4, 50677 Köln Popkonzert Skip to main content Hinterhofchor Lutherkirche Südstadt Martin-Luther-Platz 4, 50677 Köln Popkonzert
7. Kölner Percussion Festival - Konzert mediterran - persisch
2026-09-04 15:00 UTC
Lutherkirche Südstadt Martin-Luther-Platz 4, 50677 Köln Percussion, Weltmusik Skip to main content 7. Kölner Percussion Festival - Konzert mediterran - persisch Lutherkir
7. Kölner Percussion Festival - griechisch-persischer Konzertabend
2026-09-04 15:00 UTC
Lutherkirche Südstadt Martin-Luther-Platz 4, 50677 Köln Percussion, Weltmusik Skip to main content 7. Kölner Percussion Festival - griechisch-persischer Konzertabend Luth
Science Slam Köln
2026-09-04 14:55 UTC
Volksbühne am Rudolfplatz Aachener Str. 5, 50674 Köln Science Slam Skip to main content Science Slam Köln Volksbühne am Rudolfplatz Aachener Str. 5, 50674 Köln Science Sl
Paul Heller – Andy Haderer Quintet
2026-09-04 14:55 UTC
bistro verde Maternusstr. 6, 50996 Köln Live Jazz Skip to main content Paul Heller – Andy Haderer Quintet bistro verde Maternusstr. 6, 50996 Köln Live Jazz
Cards & Games
2026-09-04 14:53 UTC
Sammlermesse Cards and Games in der Stadthalle. Auf über 1.500 m² entsteht ein neuer Treffpunkt für alle, die Trading Cards, Retro-Games, Konsolen, Collectibles und echte
Sven Garrecht: Kann man machen!
2026-09-04 14:48 UTC
Atelier Theater Roonstr. 78, 50674 Köln Musik-Kabarett Skip to main content Sven Garrecht: Kann man machen! Atelier Theater Roonstr. 78, 50674 Köln Musik-Kabarett
Sezer Oglu: Reisst euch zusammen!
2026-09-04 14:48 UTC
Atelier Theater Roonstr. 78, 50674 Köln Stand-Up-Comedy Skip to main content Sezer Oglu: Reisst euch zusammen! Atelier Theater Roonstr. 78, 50674 Köln Stand-Up-Comedy
Max Beier: Love & Order
2026-09-04 14:48 UTC
Atelier Theater Roonstr. 78, 50674 Köln Stand-Up-Comedy Skip to main content Max Beier: Love & Order Atelier Theater Roonstr. 78, 50674 Köln Stand-Up-Comedy
Lena Beermann: Sex sells
2026-09-04 14:47 UTC
Atelier Theater Roonstr. 78, 50674 Köln Stand-Up-Comedy Skip to main content Lena Beermann: Sex sells Atelier Theater Roonstr. 78, 50674 Köln Stand-Up-Comedy
Knacki Deuser: Humorintelligenz
2026-09-04 14:46 UTC
Atelier Theater Roonstr. 78, 50674 Köln Stand-Up-Comedy Skip to main content Knacki Deuser: Humorintelligenz Atelier Theater Roonstr. 78, 50674 Köln Stand-Up-Comedy
Jochen Falck: Betreutes Lachen
2026-09-04 14:45 UTC
Atelier Theater Roonstr. 78, 50674 Köln Absurde Comedy Skip to main content Jochen Falck: Betreutes Lachen Atelier Theater Roonstr. 78, 50674 Köln Absurde Comedy
Feli Rockt: Mensch, Feli! Zuckerspeck und Rollmops - Köln-Premiere
2026-09-04 14:44 UTC
Atelier Theater Roonstr. 78, 50674 Köln Musik-Kabarett Skip to main content Feli Rockt: Mensch, Feli! Zuckerspeck und Rollmops - Köln-Premiere Atelier Theater Roonstr. 78
Eva Adamski - Königin in Moll - Lieder für die Krise
2026-09-04 14:44 UTC
Atelier Theater Roonstr. 78, 50674 Köln Drag-Chanson Skip to main content Eva Adamski - Königin in Moll - Lieder für die Krise Atelier Theater Roonstr. 78, 50674 Köln Dra
Dagmar Schönleber: Endlich 50! So jung...
2026-09-04 14:43 UTC
Atelier Theater Roonstr. 78, 50674 Köln Musik-Kabarett Skip to main content Dagmar Schönleber: Endlich 50! So jung... Atelier Theater Roonstr. 78, 50674 Köln Musik-Kabare
Alicja Heldt: Alicja im Wunderland
2026-09-04 14:42 UTC
Atelier Theater Roonstr. 78, 50674 Köln Stand-Up-Comedy Skip to main content Alicja Heldt: Alicja im Wunderland Atelier Theater Roonstr. 78, 50674 Köln Stand-Up-Comedy
Wer hat meinen Vater umgebracht?
2026-09-04 14:36 UTC
Studio Trafique Merheimer Str. 292, 50733 Köln Live-Film-Performance vom Studio Trafique Skip to main content Wer hat meinen Vater umgebracht? Studio Trafique Merheimer S

Harvest it all

Page through the archive by date. from and to accept YYYY-MM-DD or relative values such as now-7d.

bash
curl "https://freenewsapi.ai/v1/search?host=www.koelner.de&from=now-7d&size=100"

To poll for new material, keep the timestamp of the newest article you saw and ask only for what came after it:

bash
curl "https://freenewsapi.ai/v1/search?host=www.koelner.de&from=now-1h&sort=date_asc"

Article bodies come with full_text=true. No key, no quota tier, no header — see the search endpoint for every parameter.

Metadata quality

How well koelner.de marks up its own pages — useful if you are deciding whether to parse them yourself.

19%
dates from JSON-LD
19%
articles with a byline
18%
articles with sections
40 KB
average page weight

Crawl lag — the delay between publication and the article reaching this index — is 220 min at the median, 958 minutes at the 90th percentile.

Similar publishers

Comparable outlets in the same language. Those without a page here yet link straight to their slice of the API.

FAQ

Does koelner.de have an official API?

Not a public one. This endpoint is the practical alternative: their articles as structured JSON, with title, lead, publication time, section, byline and a link back to the original.

How do I get their RSS feed?

Most publishers expose one at /rss or /feed, but feeds carry only the last few dozen items and drop them within hours. This index keeps 772 of their articles and lets you filter by date, language and section.

How many articles does koelner.de publish per day?

4 on a median day, measured across 57 days.

Can I use this commercially?

The API is free and unauthenticated. What you may do with the content is between you and the publisher: we return metadata, a lead paragraph and a link, not a licence.