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

4 rows where licence = "https://www.govdata.de/dl-de/zero-2-0" and portal_id = "opendata.bonn.de"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: keywords, 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)
);