portals

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

2 rows where software = "drupal" and tier = "local" sorted by id

✎ View and edit SQL

This data as json, CSV (advanced)

tier 1

  • local · 2 ✖

software 1

  • drupal · 2 ✖

country 1

id ▼ name homepage country country_name tier subregion subregion_name publisher publisher_type software dcat_listed
data.metropole-dijon.fr Dijon Métropole https://data.metropole-dijon.fr FR France local FR-BFC Bourgogne-Franche-Comté Dijon Métropole Local government drupal 0
opendata.agglo-larochelle.fr La Rochelle https://opendata.agglo-larochelle.fr FR France local FR-NAQ Nouvelle-Aquitaine La Rochelle Local government drupal 0

Advanced export

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

CSV options: 

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
);