Latest harvest of each portal

Where coverage breaks down. Failed harvests say why.

Custom SQL query returning 17 rows (hide) 

SELECT p.country, p.tier, p.id AS portal, p.software, h.status, h.endpoint_type,
  CASE h.endpoint_listed WHEN 1 THEN 'listed' WHEN 0 THEN 'probed' END AS endpoint,
  h.datasets, h.pages, h.complete, h.error, h.started_at
FROM latest_harvests h JOIN portals p ON p.id = h.portal_id
ORDER BY p.country,
  CASE p.tier WHEN 'national' THEN 0 WHEN 'regional' THEN 1 ELSE 2 END, p.id

Edit SQL

This data as json, CSV

countrytierportalsoftwarestatusendpoint_typeendpointdatasetspagescompleteerrorstarted_at
DE national govdata.de ckan ok dcatap21 listed 9913 100 0 stopped after 100 pages 2026-11-11T21:49:50+00:00
DE regional opendata.bonn.de dkan ok dcatus11 listed 286 1 1   2026-11-11T21:53:47+00:00
DE regional opendata.schleswig-holstein.de ckan ok dcat:ttl listed 10000 100 0 stopped after 100 pages 2026-11-11T21:51:47+00:00
DE local hoferland-digital.de-app-catalog piveau failed     0 0 0 no DCAT endpoint listed, nor a default path known for piveau 2026-11-11T21:53:49+00:00
FR national data.gouv.fr udata ok dcat:ttl probed 9999 100 0 stopped after 100 pages 2026-11-11T21:45:28+00:00
FR regional data.laregion.fr opendatasoft ok dcat:xml listed 205 1 1   2026-11-11T21:49:41+00:00
FR local data.biarritz.fr opendatasoft ok dcat:xml listed 22 1 1   2026-11-11T21:49:47+00:00
FR local opendata.mairie-albi.fr ckan failed     0 0 0 HTTP 404 2026-11-11T21:49:49+00:00
GB national data.gov.uk ckan failed     0 0 0 HTTP 404 2026-11-11T21:53:49+00:00
GB regional admin.opendatani.gov.uk ckan failed     0 0 0 refused (HTTP 403) 2026-11-11T21:53:51+00:00
GB local cityobservatory.birmingham.gov.uk opendatasoft ok dcat:xml listed 712 1 1   2026-11-11T21:53:54+00:00
GB local data.london.gov.uk ckan ok dcatus11 listed 1310 1 1   2026-11-11T21:53:51+00:00
GB local observatory.leeds.gov.uk esridataobservatory failed     0 0 0 no DCAT endpoint listed, nor a default path known for esridataobservatory 2026-11-11T21:54:17+00:00
TH national catalog-dga.data.go.th ckan failed     0 0 0 refused (HTTP 403) 2026-11-11T21:54:17+00:00
TH national data.go.th ckan failed     0 0 0 refused (HTTP 403) 2026-11-11T21:54:17+00:00
TH regional data.bangkok.go.th ckan failed     0 0 0 network: ConnectError: [Errno 104] Connection reset by peer 2026-11-11T21:54:18+00:00
TH local amnatcharoen-local.gdcatalog.go.th ckan ok dcat:ttl listed 0 1 1   2026-11-11T21:56:02+00:00