datasets

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

key

What identifies the dataset in its portal

landing_page

The publisher's page for the dataset

keywords

JSON list

themes

JSON list of theme IRIs

20 rows where harvest_id = 5 and licence = "http://dcat-ap.de/def/licenses/cc-zero"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: issued (date), modified (date), keywords (array)

CREATE TABLE datasets (
    portal_id TEXT NOT NULL REFERENCES portals(id),
    key TEXT NOT NULL,
    harvest_id INTEGER NOT NULL REFERENCES harvests(id),
    title TEXT,
    description TEXT,
    landing_page TEXT,
    publisher TEXT,
    licence TEXT,
    issued TEXT,
    modified TEXT,
    keywords TEXT NOT NULL,
    themes TEXT NOT NULL,
    uri TEXT,
    identifier TEXT,
    PRIMARY KEY (portal_id, key)
);