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

8 rows where harvest_id = 6, licence = "http://dcat-ap.de/def/licenses/odbl" and portal_id = "opendata.schleswig-holstein.de"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: publisher, issued, keywords, themes, issued (date), modified (date), keywords (array), themes (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)
);