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. 1,403 of their articles are indexed right now, refreshed hourly.

GermanyGerman#4,482 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"
1,403
articles indexed
576
in the last 30 days
5
median per day
1
languages
208 min
median crawl lag
06.07 → 01.10
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-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 articles2026-09-07: 53 articles2026-09-08: 14 articles2026-09-09: 36 articles2026-09-10: 1 articles2026-09-14: 3 articles2026-09-15: 5 articles2026-09-16: 3 articles2026-09-17: 168 articles2026-09-18: 23 articles2026-09-21: 97 articles2026-09-22: 6 articles2026-09-23: 6 articles2026-09-24: 21 articles2026-09-25: 2 articles2026-09-28: 1 articles2026-09-29: 4 articles2026-09-30: 5 articles2026-10-01: 58 articles07-0607-2008-0308-1909-0209-1609-2910-01
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 1,403 timestamps, not from a schedule they advertise.

00: 00001: 00102: 00203: 00304: 00405: 00506: 00607: 00708: 310809: 830910: 1051011: 1191112: 651213: 1151314: 2711415: 1871516: 1501617: 141718: 01819: 01920: 02021: 02122: 02223: 023
Mon: 233MonTue: 73TueWed: 295WedThu: 446ThuFri: 93FriSat: 0SatSun: 0Sun

Sections

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

SectionArticles
Stadtleben47
Gewinnspiele20
Musik15
News13
Tipps10
Kultur7
Freizeit & Familie5
Theater5
Entertainment4
Essen & Trinken2
Konzerte2
Party2
Restaurants2
Kino1

Languages

CodeLanguageArticlesShare
deGerman1,14081.3%

Latest articles

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

E Leech zom Chressfess
2026-10-01 15:58 UTC
Hänneschen Theater Eisenmarkt 2-4, 50667 Köln Ein Weihnachtsmärchen von Heike Huhmann Skip to main content E Leech zom Chressfess Hänneschen Theater Eisenmarkt 2-4, 50667
Master Boot Record + Fulci + Arottenbit
2026-10-01 15:53 UTC
20.11.2026 19:30 Gebäude 9 Deutz-Mülheimer Str. 117, 51063 Köln 1. Oktober 2026 15:53 Computer Metal, Death Metal, Chiptune, Hardcore Punk Zurück zu den Suchergebnissen I
The Sheepdogs - Live 2026
2026-10-01 15:52 UTC
18.11.2026 20:00 Gebäude 9 Deutz-Mülheimer Str. 117, 51063 Köln 1. Oktober 2026 15:52 Classic Rock, Southern Rock, Psychedelic Rock Zurück zu den Suchergebnissen Info Sta
Bulgarian Cartrader
2026-10-01 15:52 UTC
17.11.2026 20:00 Gebäude 9 Deutz-Mülheimer Str. 117, 51063 Köln 1. Oktober 2026 15:52 Indie-Pop, Jazz, Soul Zurück zu den Suchergebnissen Info StandortGebäude 9 Deutz-Mül
David Eugene Edwards - Tour 2026
2026-10-01 15:51 UTC
16.11.2026 20:00 Gebäude 9 Deutz-Mülheimer Str. 117, 51063 Köln 1. Oktober 2026 15:51 Gothic Americana, Alternative Country, Folk-Rock Zurück zu den Suchergebnissen Info
Die Verlierer
2026-10-01 15:50 UTC
13.11.2026 20:00 Gebäude 9 Deutz-Mülheimer Str. 117, 51063 Köln 1. Oktober 2026 15:50 Punk, Post-Punk Zurück zu den Suchergebnissen Info StandortGebäude 9 Deutz-Mülheimer
Ignite & Cancer Bats + Outspoken + Mean Season + To The Wire
2026-10-01 15:50 UTC
12.11.2026 18:30 Gebäude 9 Deutz-Mülheimer Str. 117, 51063 Köln 1. Oktober 2026 15:50 Hardcore Punk, Metalcore Zurück zu den Suchergebnissen Info StandortGebäude 9 Deutz-
Ash - 1977 30th Anniversary Tour
2026-10-01 15:49 UTC
11.11.2026 20:00 Gebäude 9 Deutz-Mülheimer Str. 117, 51063 Köln 1. Oktober 2026 15:49 Britpop, Indie-Rock, Power-Pop Zurück zu den Suchergebnissen Info StandortGebäude 9
Dirty Three
2026-10-01 15:49 UTC
06.11.2026 20:00 Gebäude 9 Deutz-Mülheimer Str. 117, 51063 Köln 1. Oktober 2026 15:49 Instrumental Rock, Post-Rock Zurück zu den Suchergebnissen Info StandortGebäude 9 De
Nasty + Crawlspace + Pintglass
2026-10-01 15:48 UTC
01.11.2026 20:00 Gebäude 9 Deutz-Mülheimer Str. 117, 51063 Köln 1. Oktober 2026 15:48 Beatdown Hardcore, Metalcore Zurück zu den Suchergebnissen Info StandortGebäude 9 De
Jutta Wilbertz
2026-10-01 15:40 UTC
Bürgerzentrum Engelshof Oberstr. 96, 51149 Köln Musikalische Krimilesung, 18 € Skip to main content Jutta Wilbertz Bürgerzentrum Engelshof Oberstr. 96, 51149 Köln Musikal
Fee Brembeck: How to Frau – Das Tutorial, nach dem niemand gefragt hat
2026-10-01 15:27 UTC
Atelier Theater Roonstr. 78, 50674 Köln Stand-up-Comedy Skip to main content Fee Brembeck: How to Frau – Das Tutorial, nach dem niemand gefragt hat Atelier Theater Roonst
Jochen Prang: Immer is was!
2026-10-01 15:26 UTC
Atelier Theater Roonstr. 78, 50674 Köln Stand-up-Comedy Skip to main content Jochen Prang: Immer is was! Atelier Theater Roonstr. 78, 50674 Köln Stand-up-Comedy
25 Jahre Ulan & Bator: Überraschungszwei
2026-10-01 15:25 UTC
Atelier Theater Roonstr. 78, 50674 Köln Kabarett Skip to main content 25 Jahre Ulan & Bator: Überraschungszwei Atelier Theater Roonstr. 78, 50674 Köln Kabarett
Jess Jochimsen: von allen guten Geistern
2026-10-01 15:24 UTC
Atelier Theater Roonstr. 78, 50674 Köln Kabarett, politische Satire Skip to main content Jess Jochimsen: von allen guten Geistern Atelier Theater Roonstr. 78, 50674 Köln
Cologne Comedy Festival 2026: Nele Mathew - Ist das so üblich?
2026-10-01 15:22 UTC
Atelier Theater Roonstr. 78, 50674 Köln Stand-up-Comedy Skip to main content Cologne Comedy Festival 2026: Nele Mathew - Ist das so üblich? Atelier Theater Roonstr. 78, 5
Cologne Comedy Festival 2026: Hennes Bender – Alter Falter!
2026-10-01 15:22 UTC
Atelier Theater Roonstr. 78, 50674 Köln Stand-up-Comedy Skip to main content Cologne Comedy Festival 2026: Hennes Bender – Alter Falter! Atelier Theater Roonstr. 78, 5067
Wanderlustig: Die Comedy-Show
2026-10-01 15:20 UTC
03.11.2026 20:00 Atelier Theater Roonstr. 78, 50674 Köln 1. Oktober 2026 15:20 Comedy Zurück zu den Suchergebnissen Info Robbi Pawlik StandortAtelier Theater Roonstr. 78,

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.

12%
dates from JSON-LD
12%
articles with a byline
12%
articles with sections
39 KB
average page weight

Crawl lag — the delay between publication and the article reaching this index — is 208 min at the median, 483 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.

Mallorca Magazin
1,464 articles
Radio Zurisee
1,453 articles
DIGITAL FERNSEHEN
1,429 articles
t3n.de - News
1,429 articles
Celler Presse
1,401 articles
Schlager.de
1,344 articles
Deutsche Wirtschafts Nachrichten
1,339 articles
FCBinside - Aktuelle FC Bayern News
1,331 articles

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 1,403 of their articles and lets you filter by date, language and section.

How many articles does koelner.de publish per day?

5 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.