portals
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
183 rows where country = "FR" and tier = "local" sorted by id
This data as json, CSV (advanced)
Suggested facets: subregion, subregion_name, dcat_listed
software 11
- opendatasoft 146
- ckan 10
- datafair 10
- custom 8
- drupal 2
- typo3 2
- geonetwork 1
- joomla 1
- onegeosuite 1
- rudi 1
- wordpress 1
tier 1
- local · 183 ✖
country 1
- FR · 183 ✖
| id ▼ | name | homepage | country | country_name | tier | subregion | subregion_name | publisher | publisher_type | software | dcat_listed |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 4b943a85-8c32-4d71-acdd-168d2834a61e.portal.koumoul.com | Open Data Dunkerque Agglomération | https://4b943a85-8c32-4d71-acdd-168d2834a61e.portal.koumoul.com | FR | France | local | FR-HDF | Hauts-de-France | Communauté Urbaine de Dunkerque | Local government | datafair | 0 |
| 80537841-b7ca-493b-bb59-af904f86afae.portal.koumoul.com | BEGI - Open Data Tourisme Pays Basque | https://80537841-b7ca-493b-bb59-af904f86afae.portal.koumoul.com | FR | France | local | FR-NAQ | Nouvelle-Aquitaine | Communauté d'Agglomération Pays Basque | Local government | datafair | 0 |
| aix-en-provence.opendatasoft.com | Aix-en-Provence Open Data Portal | https://aix-en-provence.opendatasoft.com | FR | France | local | FR-13 | Bouches-du-Rhône | Mairie d'Aix en Provence | Local government | opendatasoft | 1 |
| anglet-opendatapaysbasque.opendatasoft.com | ANTIC Pays Basque | https://anglet-opendatapaysbasque.opendatasoft.com | FR | France | local | FR-64 | Pyrénées-Atlantiques | ANTIC Pays Basque | Local government | opendatasoft | 1 |
| b7ffb5b5-6476-4514-947a-4f78e4fefc08.portal.koumoul.com | ZABAL - Open Data Agriculture Pays Basque | https://b7ffb5b5-6476-4514-947a-4f78e4fefc08.portal.koumoul.com | FR | France | local | FR-NAQ | Nouvelle-Aquitaine | Communauté d'Agglomération Pays Basque | Local government | datafair | 0 |
| b9369b7b-b963-4044-9c19-a7cfd047071d.portal.koumoul.com | Open Data Aix-en-Provence | https://b9369b7b-b963-4044-9c19-a7cfd047071d.portal.koumoul.com | FR | France | local | FR-13 | Bouches-du-Rhône | Ville d'Aix-en-Provence | Local government | datafair | 0 |
| bastia-agglomeration.corsica-open-data | Bastia | https://www.bastia-agglomeration.corsica/open-data/ | FR | France | local | FR-20R | Corse | Bastia | Local government | wordpress | 0 |
| bondoufle-grandparissud.opendatasoft.com | Bondoufle | https://bondoufle-grandparissud.opendatasoft.com | FR | France | local | FR-IDF | Île-de-France | Bondoufle | Local government | opendatasoft | 1 |
| boucau-opendatapaysbasque.opendatasoft.com | Boucau Open Data Pays Basque | https://boucau-opendatapaysbasque.opendatasoft.com | FR | France | local | FR-64 | Pyrénées-Atlantiques | Ville de Boucau | Local government | opendatasoft | 1 |
| boulognebillancourt-seineouest.opendatasoft.com | Explore — data.seineouest.fr - Boulogne-Billancourt - Opendatasoft | https://boulognebillancourt-seineouest.opendatasoft.com | FR | France | local | FR-IDF | Île-de-France | Grand Paris Seine Ouest | Local government | opendatasoft | 1 |
| cachan.opendatasoft.com | Ville de Cachan Open data portal | https://cachan.opendatasoft.com | FR | France | local | FR-IDF | Île-de-France | Ville de Cachan | Local government | opendatasoft | 1 |
| cambo-les-bains-opendatapaysbasque.opendatasoft.com | Cambo-les-Bains Open Data Pays Basque | https://cambo-les-bains-opendatapaysbasque.opendatasoft.com | FR | France | local | FR-64 | Pyrénées-Atlantiques | Ville de Cambo-les-Bains | Local government | opendatasoft | 1 |
| cceg-loireatlantique.opendatasoft.com | CC Erdre et Gesvres Open Data | https://cceg-loireatlantique.opendatasoft.com | FR | France | local | FR-PDL | Pays-de-la-Loire | Communauté de communes Erdre et Gesvres | Local government | opendatasoft | 1 |
| ccphva.opendatasoft.com | Open Data CCPHVA | https://ccphva.opendatasoft.com | FR | France | local | FR-GES | Grand-Est | Communauté de communes Pays Haut Val d'Alzette | Local government | opendatasoft | 1 |
| cesson-grandparissud.opendatasoft.com | Cesson | https://cesson-grandparissud.opendatasoft.com | FR | France | local | FR-IDF | Île-de-France | Cesson | Local government | opendatasoft | 1 |
| chaville-seineouest.opendatasoft.com | Portail Open Data de Chaville | https://chaville-seineouest.opendatasoft.com | FR | France | local | FR-IDF | Île-de-France | Grand Paris Seine Ouest | Local government | opendatasoft | 1 |
| combslaville-grandparissud.opendatasoft.com | Combs-la-Ville | https://combslaville-grandparissud.opendatasoft.com | FR | France | local | FR-IDF | Île-de-France | Combs-la-Ville | Local government | opendatasoft | 1 |
| corbeil-essonnes-grandparissud.opendatasoft.com | Corbeil-Essonnes Grand Paris Sud Open Data | https://corbeil-essonnes-grandparissud.opendatasoft.com | FR | France | local | FR-IDF | Île-de-France | GPS - Grand Paris Sud | Local government | opendatasoft | 1 |
| d4c.agglo-larochelle.fr | Local Government of Agglo Larochelle Open data portal | https://d4c.agglo-larochelle.fr | FR | France | local | FR-NAQ | Nouvelle-Aquitaine | Local Government of Agglo Larochelle | Local government | ckan | 0 |
| dashboard.paris | City of Paris Open data portal | https://dashboard.paris | FR | France | local | FR-75C | Paris | City of Paris | Local government | opendatasoft | 1 |
| data.82numerique.fr | Tarn et Garonne Open Data catalog | https://data.82numerique.fr | FR | France | local | FR-OCC | Occitanie | Local Government of Numerique | Local government | opendatasoft | 0 |
| data.agen.fr | Données d Agen | https://data.agen.fr | FR | France | local | FR-NAQ | Nouvelle-Aquitaine | Ville d Agen | Local government | opendatasoft | 0 |
| data.agglo-carene.fr | Saint-Nazaire Agglo - Open Data catalog | https://data.agglo-carene.fr | FR | France | local | FR-PDL | Pays-de-la-Loire | Saint-Nazaire agglo - La CARENE | Local government | opendatasoft | 1 |
| data.agglo-montargoise.fr | Open Data Agglomeration Montargoise | https://data.agglo-montargoise.fr | FR | France | local | FR-CVL | Centre-Val de Loire | Agglomeration Montargoise et Rives du Loing | Local government | opendatasoft | 1 |
| data.ampmetropole.fr | DATA Métropole Aix-Marseille Provence catalog | https://data.ampmetropole.fr | FR | France | local | FR-PAC | Provence-Alpes-Côte-d’Azur | Métropole Aix-Marseille Provence | Local government | opendatasoft | 1 |
| data.angers.fr | Angers Loire Métropole - Open Data catalog | https://data.angers.fr | FR | France | local | FR-PDL | Pays-de-la-Loire | Angers Loire Métropole | Local government | opendatasoft | 1 |
| data.bassinpompey.fr | Bassin de Pompey | https://data.bassinpompey.fr | FR | France | local | FR-GES | Grand-Est | Bassin de Pompey | Local government | custom | 0 |
| data.biarritz.fr | Open Data Biarritz | https://data.biarritz.fr | FR | France | local | FR-64 | Pyrénées-Atlantiques | Ville de Biarritz | Local government | opendatasoft | 1 |
| data.blois.agglopolys.fr | Blois-Agglopolys catalog | https://data.blois.agglopolys.fr | FR | France | local | FR-CVL | Centre-Val de Loire | Blois-Agglopolys | Local government | opendatasoft | 1 |
| data.bourgesplus.fr | Bourges Plus Open Data Portal | https://data.bourgesplus.fr | FR | France | local | FR-CVL | Centre-Val de Loire | Bourges Plus (Communauté d'Agglomération de Bourges) | Local government | opendatasoft | 1 |
| data.bretagne-environnement.fr | Bretagne Environnement Open Data | https://data.bretagne-environnement.fr | FR | France | local | FR-BRE | Bretagne | OEB | Local government | datafair | 0 |
| data.cacl-guyane.fr | Data CACL | https://data.cacl-guyane.fr | FR | France | local | FR-973 | Guyane (française) | Data CACL | Local government | custom | 0 |
| data.cannes.com | CANNES DATA catalog | https://data.cannes.com | FR | France | local | FR-PAC | Provence-Alpes-Côte-d’Azur | La Mairie de Cannes | Local government | opendatasoft | 1 |
| data.cannes.fr | Ville de Cannes Open data portal | https://data.cannes.fr | FR | France | local | FR-PAC | Provence-Alpes-Côte-d’Azur | Ville de Cannes | Local government | opendatasoft | 1 |
| data.capatlantique.fr | Cap Atlantique - Open Data catalog | https://data.capatlantique.fr | FR | France | local | FR-PDL | Pays-de-la-Loire | Cap Atlantique | Local government | opendatasoft | 1 |
| data.cc-autourdechenonceaux.fr | Open Data CC Autour de Chenonceaux Bléré-Val de Cher | https://data.cc-autourdechenonceaux.fr | FR | France | local | FR-CVL | Centre-Val de Loire | Communauté de communes Autour de Chenonceaux Bléré-Val de Cher | Local government | opendatasoft | 1 |
| data.chateauroux-metropole.fr | chateauroux-metropole catalog | https://data.chateauroux-metropole.fr | FR | France | local | FR-CVL | Centre-Val de Loire | Châteauroux Métropole | Local government | opendatasoft | 1 |
| data.coeurcotefleurie.org | Cœur Côte Fleurie | http://data.coeurcotefleurie.org | FR | France | local | FR-NOR | Normandie | Cœur Côte Fleurie | Local government | ckan | 0 |
| data.combs-la-ville.fr | Combs-la-Ville - Open Data | https://data.combs-la-ville.fr | FR | France | local | FR-IDF | Île-de-France | Mairie de Combs-la-Ville | Local government | opendatasoft | 1 |
| data.coudray-montceaux.fr | Data Catalog of Coudray-Montceaux | https://data.coudray-montceaux.fr | FR | France | local | FR-IDF | Île-de-France | Coudray-Montceaux | Local government | opendatasoft | 1 |
| data.departement41.fr | departement41 catalog | https://data.departement41.fr | FR | France | local | FR-CVL | Centre-Val de Loire | Département du Loir-et-Cher | Local government | opendatasoft | 1 |
| data.dunkerque-agglo.fr | Open Data Dunkerque Agglomération catalog | https://data.dunkerque-agglo.fr | FR | France | local | FR-HDF | Hauts-de-France | Communauté urbaine de Dunkerque | Local government | opendatasoft | 1 |
| data.etiolles.fr | Explore — OpenData Etiolles | https://data.etiolles.fr | FR | France | local | FR-IDF | Île-de-France | Municipalité d'Étiolles | Local government | opendatasoft | 1 |
| data.eurelien.fr | Local Government of Eurelien Open data portal | https://data.eurelien.fr | FR | France | local | FR-NOR | Normandie | Local Government of Eurelien | Local government | opendatasoft | 1 |
| data.evrycourcouronnes.fr | Ville d'Evry-Courcouronnes Open data portal | https://data.evrycourcouronnes.fr | FR | France | local | FR-IDF | Île-de-France | Ville d'Evry-Courcouronnes | Local government | opendatasoft | 1 |
| data.fleurysurorne.fr | Portail Open Data de la Ville de Fleury-sur-Orne catalog | https://data.fleurysurorne.fr | FR | France | local | FR-NOR | Normandie | Ville de Fleury-sur-Orne | Local government | opendatasoft | 1 |
| data.gers.fr | Accueil — Gers-OpenData | https://data.gers.fr | FR | France | local | FR-OCC | Occitanie | Département du Gers et autres collectivités du territoire | Local government | opendatasoft | 1 |
| data.grandbesancon.fr | Grand Besançon | https://data.grandbesancon.fr | FR | France | local | FR-BFC | Bourgogne-Franche-Comté | Grand Besançon | Local government | custom | 0 |
| data.grandchambord.fr | Open Data Grand Chambord | https://www.data.grandchambord.fr/ | FR | France | local | FR-CVL | Centre-Val de Loire | Communaute de communes du Grand Chambord | Local government | opendatasoft | 1 |
| data.grandparisgrandest.fr | Grand Paris Grand Est | https://data.grandparisgrandest.fr | FR | France | local | FR-IDF | Île-de-France | Grand Paris Grand Est | Local government | opendatasoft | 1 |
| data.grandpoitiers.fr | Grand Poitiers Open Data catalog | https://data.grandpoitiers.fr | FR | France | local | FR-NAQ | Nouvelle-Aquitaine | Grand Poitiers | Local government | datafair | 0 |
| data.grandsoissons.com | GrandSoissons Agglomération catalog | https://data.grandsoissons.com | FR | France | local | FR-HDF | Hauts-de-France | GrandSoissons Agglomération et de la Ville de Soissons | Local government | opendatasoft | 0 |
| data.grigny91.fr | Grigny91 | Open Data catalog | https://www.data.grigny91.fr | FR | France | local | FR-IDF | Île-de-France | Ville de Grigny | Local government | opendatasoft | 1 |
| data.haute-garonne.fr | Open Data Haute-Garonne catalog | https://data.haute-garonne.fr | FR | France | local | FR-OCC | Occitanie | Conseil départemental de la Haute-Garonne | Local government | opendatasoft | 1 |
| data.idelis.fr | IDELIS catalog | https://data.idelis.fr | FR | France | local | FR-NAQ | Nouvelle-Aquitaine | IDELIS | Local government | opendatasoft | 1 |
| data.ille-et-vilaine.fr | Ille-et-Vilaine | https://data.ille-et-vilaine.fr | FR | France | local | FR-BRE | Bretagne | Ille-et-Vilaine | Local government | ckan | 0 |
| data.issy.com | Données d Issy-les-Moulineaux | https://data.issy.com | FR | France | local | FR-IDF | Île-de-France | Issy-les-Moulineaux | Local government | opendatasoft | 1 |
| data.lafibre64.fr | Open-Data La Fibre64 catalog | https://data.lafibre64.fr | FR | France | local | FR-NAQ | Nouvelle-Aquitaine | La Fibre64 | Local government | opendatasoft | 0 |
| data.lamayenne.fr | Département de la Mayenne Open data portal | https://data.lamayenne.fr | FR | France | local | FR-PDL | Pays-de-la-Loire | Département de la Mayenne | Local government | opendatasoft | 1 |
| data.larochesuryon.fr | Open Data La Roche-sur-Yon catalog | https://data.larochesuryon.fr | FR | France | local | FR-PDL | Pays-de-la-Loire | Agglomération de La Roche-sur-Yon | Local government | opendatasoft | 1 |
| data.le64.fr | data64 catalog | https://data.le64.fr | FR | France | local | FR-NAQ | Nouvelle-Aquitaine | Département | Local government | opendatasoft | 1 |
| data.lignesdazur.com | Data Lignes d'Azur | https://data.lignesdazur.com | FR | France | local | FR-PAC | Provence-Alpes-Côte-d’Azur | Régie Lignes d'Azur | Local government | ckan | 0 |
| data.lillemetropole.fr-geonetwork-srv-eng-catalog.search | Lille Métropole | https://data.lillemetropole.fr/geonetwork/srv/eng/catalog.search | FR | France | local | FR-HDF | Hauts-de-France | Lille Métropole | Local government | geonetwork | 0 |
| data.maine-et-loire.fr | Accueil - data.maine-et-loire.fr | https://data.maine-et-loire.fr | FR | France | local | FR-PDL | Pays-de-la-Loire | Département de Maine-et-Loire | Local government | opendatasoft | 1 |
| data.mairie-ris-orangis.fr | Local Government of Mairie Ris Orangis Open data portal | https://data.mairie-ris-orangis.fr | FR | France | local | FR-IDF | Île-de-France | Local Government of Mairie Ris Orangis | Local government | opendatasoft | 1 |
| data.maugescommunaute.fr | Data.maugescommunaute.fr catalog | https://data.maugescommunaute.fr | FR | France | local | FR-PDL | Pays-de-la-Loire | Mauges Communauté | Local government | opendatasoft | 1 |
| data.melunvaldeseine.fr | Open data Melun Val de Seine | https://data.melunvaldeseine.fr | FR | France | local | FR-IDF | Île-de-France | Communauté d'agglomération Melun Val de Seine | Local government | opendatasoft | 1 |
| 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 |
| data.metropole-rouen-normandie.fr | Métropole Rouen Normandie Open data portal | https://data.metropole-rouen-normandie.fr | FR | France | local | FR-NOR | Normandie | Métropole Rouen Normandie | Local government | opendatasoft | 1 |
| data.metropolegrenoble.fr | Grenoble-Alpes Métropole | https://data.metropolegrenoble.fr | FR | France | local | FR-ARA | Auvergne-Rhône-Alpes | Grenoble-Alpes Métropole | Local government | ckan | 0 |
| data.metropoletpm.fr | Open Data Portail de la Métropole TPM | https://data.metropoletpm.fr | FR | France | local | FR-PAC | Provence-Alpes-Côte-d’Azur | Métropole Toulon Provence Méditerranée (TPM) | Local government | opendatasoft | 0 |
| data.meudon.fr | Ville de Meudon catalog | https://data.meudon.fr | FR | France | local | FR-IDF | Île-de-France | City of Meudon | Local government | opendatasoft | 1 |
| data.moissy-cramayel.fr | Moissy-Cramayel: Explore — OpenData | https://data.moissy-cramayel.fr | FR | France | local | FR-IDF | Île-de-France | Moissy-Cramayel | Local government | opendatasoft | 1 |
| data.montreuil.fr | Montreuil Data catalog | https://data.montreuil.fr | FR | France | local | FR-IDF | Île-de-France | Ville de Montreuil | Local government | opendatasoft | 1 |
| data.mulhouse-alsace.fr | Mulhouse Alsace Agglomération — m2A Open Data | https://data.mulhouse-alsace.fr | FR | France | local | FR-GES | Grand-Est | Mulhouse Alsace Agglomération (m2A) | Local government | opendatasoft | 1 |
| data.nantesmetropole.fr | Catalogue des data.nantesmetropole.fr | https://data.nantesmetropole.fr | FR | France | local | FR-PDL | Pays-de-la-Loire | Nantes Métropole | Local government | opendatasoft | 1 |
| data.nimes-metropole.fr | data.nimes-metropole catalog | https://data.nimes-metropole.fr | FR | France | local | FR-OCC | Occitanie | Nîmes Métropole | Local government | opendatasoft | 1 |
| data.ofgl.fr | ofgl catalog | https://data.ofgl.fr | FR | France | local | FR-PAC | Provence-Alpes-Côte-d’Azur | Local Government of Ofgl | Local government | opendatasoft | 1 |
| data.orleans-metropole.fr | Portail Open Data Orléans Métropole catalog | https://data.orleans-metropole.fr | FR | France | local | FR-CVL | Centre-Val de Loire | Orléans Métropole | Local government | opendatasoft | 1 |
| data.osmontrouge.fr | Ville de Montrouge Open data portal | https://data.osmontrouge.fr | FR | France | local | FR-IDF | Île-de-France | Ville de Montrouge | Local government | opendatasoft | 0 |
| data.regionreunion.com | Portail Open Data de La Réunion catalog | https://data.regionreunion.com | FR | France | local | FR-974 | La Réunion | Region Reunion | Local government | opendatasoft | 1 |
| data.rennesmetropole.fr | Open Data Rennes Métropole | https://data.rennesmetropole.fr | FR | France | local | FR-BRE | Bretagne | Rennes Métropole | Local government | opendatasoft | 1 |
| data.saint-etienne-metropole.fr | Saint-Etienne Métropole | https://data.saint-etienne-metropole.fr | FR | France | local | FR-ARA | Auvergne-Rhône-Alpes | Saint-Etienne Métropole | Local government | custom | 0 |
| data.saint-maur.com | Saint-Maur | https://data.saint-maur.com | FR | France | local | FR-IDF | Île-de-France | Saint-Maur | Local government | opendatasoft | 1 |
| data.saint-pierre-du-perray.fr | Open Data - Saint-Pierre-du-Perray catalog | https://data.saint-pierre-du-perray.fr | FR | France | local | FR-IDF | Île-de-France | Commune de Saint-Pierre-du-Perray | Local government | opendatasoft | 1 |
| data.saintnazaireagglo.fr | Saint-Nazaire Agglo - Open Data | https://data.saintnazaireagglo.fr | FR | France | local | FR-PDL | Pays-de-la-Loire | Saint-Nazaire Agglo | Local government | opendatasoft | 1 |
| data.saintry-sur-seine.fr | saintry-sur-seine catalog | https://data.saintry-sur-seine.fr | FR | France | local | FR-IDF | Île-de-France | Commune de Saintry-sur-Seine | Local government | opendatasoft | 1 |
| data.sarthe.fr | Local Government of Sarthe Open data portal | https://data.sarthe.fr | FR | France | local | FR-PDL | Pays-de-la-Loire | Local Government of Sarthe | Local government | opendatasoft | 1 |
| data.savigny-le-temple.fr | Portail OpenData de Savigny-le-Temple catalog | https://data.savigny-le-temple.fr | FR | France | local | FR-IDF | Île-de-France | Ville de Savigny-le-Temple | Local government | opendatasoft | 1 |
| data.seineouest.fr | GPSO - Grand Paris Seine Ouest - OpenData catalog | https://data.seineouest.fr | FR | France | local | FR-IDF | Île-de-France | Grand Paris Seine Ouest | Local government | opendatasoft | 1 |
| data.seinesaintdenis.fr | Open Data Seine-Saint-Denis | https://data.seinesaintdenis.fr | FR | France | local | FR-IDF | Île-de-France | Seine-Saint-Denis | Local government | opendatasoft | 1 |
| data.sevres.fr | Sèvres - Open data | https://data.sevres.fr | FR | France | local | FR-IDF | Île-de-France | Ville de Sèvres | Local government | opendatasoft | 1 |
| data.sicoval.fr | OpenData Sicoval | https://data.sicoval.fr | FR | France | local | FR-OCC | Occitanie | Sicoval | Local government | opendatasoft | 1 |
| data.smartidf.services | Local Government of Smartidf Open data portal | https://data.smartidf.services | FR | France | local | FR-IDF | Île-de-France | Local Government of Smartidf | Local government | opendatasoft | 0 |
| data.stmalo-agglomeration.fr | Saint-Malo Agglo | https://data.stmalo-agglomeration.fr | FR | France | local | FR-BRE | Bretagne | Saint-Malo Agglo | Local government | opendatasoft | 1 |
| data.strasbourg.eu | Strasbourg Open Data | https://data.strasbourg.eu | FR | France | local | FR-67 | Bas-Rhin | Ville et Eurométropole de Strasbourg | Local government | opendatasoft | 0 |
| data.tco.re | Open Data du TCO | https://data.tco.re | FR | France | local | FR-974 | La Réunion | TCO Reunion | Local government | opendatasoft | 1 |
| data.te44.fr | Territoire d'énergie Loire-Atlantique - Open Data | https://data.te44.fr | FR | France | local | FR-PDL | Pays-de-la-Loire | Territoire d'énergie Loire-Atlantique | Local government | opendatasoft | 1 |
| data.tours-metropole.fr | Tours Métropole Val de Loire Open data portal | https://data.tours-metropole.fr | FR | France | local | FR-CVL | Centre-Val de Loire | Tours Métropole Val de Loire | Local government | opendatasoft | 1 |
| data.troyes-cm.fr | Troyes Champagne Métropole | https://data.troyes-cm.fr | FR | France | local | FR-GES | Grand-Est | Troyes Champagne Métropole | Local government | datafair | 0 |
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
);