Columbia County Spotlight API, RSS and sitemap
Every article Columbia County Spotlight publishes, as JSON, through an open API with no key and no signup. 95 of their articles are indexed right now, refreshed hourly.
United StatesEnglish#12,268 by volume
Four ways to pull columbiacountyspotlight.com
All four are ours, all four are live, and none of them needs a key.
JSON Search this publisher
Every article we hold from columbiacountyspotlight.com, newest first. Add q= to search inside.
curl -s "https://freenewsapi.ai/v1/search?host=columbiacountyspotlight.com&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=columbiacountyspotlight.com&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=columbiacountyspotlight.com&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=columbiacountyspotlight.com&size=20&fields=title,url,published_at,lang"open it →What this outlet covers, by share of its recent output:
Call the API
A live request. Paste it into a terminal and Columbia County Spotlight headlines come back as JSON.
curl "https://freenewsapi.ai/v1/search?host=columbiacountyspotlight.com&size=5"Publishing volume
Articles per day over the last 11 days. The busiest hour is 18:00 UTC — that is when the newsroom pushes its main batch.
curl "https://freenewsapi.ai/v1/stats?host=columbiacountyspotlight.com&top=10"Publishing rhythm
When Columbia County Spotlight actually publishes, by hour of day (UTC) and by day of week — measured from 95 timestamps, not from a schedule they advertise.
Sections
Sections come from the publisher's own markup, present on 21% of their articles.
Languages
| Code | Language | Articles | Share |
|---|---|---|---|
en | English | 77 | 81.1% |
Latest articles
The 18 most recent Columbia County Spotlight articles in the index — the same rows the API returns, rendered for humans.
Harvest it all
Page through the archive by date. from and to accept
YYYY-MM-DD or relative values such as now-7d.
curl "https://freenewsapi.ai/v1/search?host=columbiacountyspotlight.com&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:
curl "https://freenewsapi.ai/v1/search?host=columbiacountyspotlight.com&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 Columbia County Spotlight marks up its own pages — useful if you are deciding whether to parse them yourself.
Crawl lag — the delay between publication and the article reaching this index — is 647 min at the median, 4540 minutes at the 90th percentile.
FAQ
Does Columbia County Spotlight 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 95 of
their articles and lets you filter by date, language and section.
How many articles does Columbia County Spotlight publish per day?
5 on a median day, measured across 11 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.
