distributions
Data license: CC BY 4.0 (portal directory, derived from Dateno); dataset metadata as each portal publishes it · Data source: Dateno, DataPortals.org, data.europa.eu, opendatArchives, and each portal's DCAT catalogue
77 rows where media_type = "application/xml"
This data as json, CSV (advanced)
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE distributions (
portal_id TEXT NOT NULL,
dataset_key TEXT NOT NULL,
position INTEGER NOT NULL,
title TEXT,
format TEXT,
media_type TEXT,
access_url TEXT,
download_url TEXT,
licence TEXT,
PRIMARY KEY (portal_id, dataset_key, position),
FOREIGN KEY (portal_id, dataset_key) REFERENCES datasets(portal_id, key)
);