catalogue: portals: 10 rows where country = "GB" and tier = "regional" sorted by id

The portal directory, one row per portal.

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

10 rows where country = "GB" and tier = "regional" sorted by id

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼	name	homepage	country	country_name	tier	subregion	subregion_name	publisher	publisher_type	software	dcat_listed
admin.opendatani.gov.uk	Northern Ireland Open Data - Open Data Portal	https://admin.opendatani.gov.uk	GB	United Kingdom	regional	GB-NIR	Northern Ireland	Government of Northern Ireland	Regional government	ckan	1
data.england.nhs.uk	NHS England Data Catalogue	https://data.england.nhs.uk	GB	United Kingdom	regional	GB-ENG	England	National health service of England	Regional government	ckan	0
data.marine.gov.scot	Marine Scotland Data	https://data.marine.gov.scot	GB	United Kingdom	regional	GB-SCT	Scotland	Scotland Government	Regional government	dkan	1
data.nls.uk	Data Foundry (National Library of Scotland)	https://data.nls.uk/	GB	United Kingdom	regional	GB-SCT	Scotland	National Library of Scotland	Regional government	wordpress	0
data.parliament.scot	Scottish Parliament Open Data	https://data.parliament.scot/	GB	United Kingdom	regional	GB-SCT	Scotland	Scottish Parliament	Regional government	custom	0
infobasecymru.net	InfoBaseCymru	https://www.infobasecymru.net	GB	United Kingdom	regional	GB-WLS	Wales [Cymru GB-CYM]	Data Cymru	Regional government	custom	0
informatics.sepa.org.uk-spri	Scottish Pollution Release Inventory	https://informatics.sepa.org.uk/SPRI/	GB	United Kingdom	regional	GB-SCT	Scotland	Scottish Environment Protection Agency	Regional government	custom	0
opendata.nhs.scot	Scottish Health and Social Care Open Data	https://www.opendata.nhs.scot	GB	United Kingdom	regional	GB-SCT	Scotland	NHS Scotland	Regional government	ckan	0
opendata.wales	Open Data Wales	https://opendata.wales	GB	United Kingdom	regional	GB-WLS	Wales [Cymru GB-CYM]	Open Data Wales	Regional government	custom	0
statistics.gov.scot	Scotland Statistics - Open Data Portal	https://statistics.gov.scot	GB	United Kingdom	regional	GB-SCT	Scotland	Scottish Government	Regional government	publishmydata	1

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE portals (
    id TEXT PRIMARY KEY,
    name TEXT NOT NULL,
    homepage TEXT NOT NULL,
    country TEXT NOT NULL,
    country_name TEXT,
    tier TEXT NOT NULL,
    subregion TEXT,
    subregion_name TEXT,
    publisher TEXT,
    publisher_type TEXT,
    software TEXT,
    dcat_listed INTEGER NOT NULL
);