Data license: ODbL · Data source: Green Deal Data Observatory

1 row where GeoLocation = "[{"id":"ES","name":"Spain"},{"id":"HR","name":"Croatia"},{"id":"NL","name":"Netherlands"},{"id":"AT","name":"Austria"},{"id":"BE","name":"Belgium"},{"id":"BG","name":"Bulgaria"},{"id":"CZ","name":"Czechia"},{"id":"DE","name":"Germany (until 1990 former territory of the FRG)"},{"id":"DK","name":"Denmark"},{"id":"EE","name":"Estonia"},{"id":"FI","name":"Finland"},{"id":"FR","name":"France"},{"id":"IE","name":"Ireland"},{"id":"IT","name":"Italy"},{"id":"LT","name":"Lithuania"},{"id":"LU","name":"Luxembourg"},{"id":"LV","name":"Latvia"},{"id":"MT","name":"Malta"},{"id":"PL","name":"Poland"},{"id":"PT","name":"Portugal"},{"id":"RO","name":"Romania"},{"id":"RS","name":"Serbia"},{"id":"SE","name":"Sweden"},{"id":"SI","name":"Slovenia"},{"id":"UK","name":"United Kingdom"},{"id":"CY","name":"Cyprus"},{"id":"EL","name":"Greece"},{"id":"HU","name":"Hungary"},{"id":"SK","name":"Slovakia"}]" sorted by dataset_code

View and edit SQL

Link rowid dataset_code ▼ Identifier Creator Title Publisher PublicationYear ResourceType Subject Contributor Date Language AlternateIdentifier RelatedIdentifier Size Format Version Rights Description GeoLocation FundingReference RelatedItem
7 gbard_environment_total_total_p6_tot_egss_pc_gdp
[
    {},
    {
        "id": [
            "gbard_environment_total_total_p6_tot_egss_pc_gdp"
        ],
        "dataset_code": [
            "gbard_environment_total_total_p6_tot_egss_pc_gdp"
        ],
        "URI": {},
        "DOI": {},
        "Version": {},
        "idAtSource": {},
        "Other": {}
    }
]
[
    {
        "creatorName": [
            "Antal, Daniel"
        ],
        "nameType": [
            "Person"
        ],
        "affiliation": [
            "reprex.nl"
        ],
        "orcid": [
            "0000-0001-7513-6760"
        ]
    }
]
Relative Size of the Environmental Goods and Services Sector nace_r2: Total - all NACE activities; ceparema: Total environmental protection and resource management activities; na_item: Exports of goods and services; ty: Total environmental goods and services sector [unit: Percentage of gross domestic product (GDP)] Reprex 2021.0 Dataset Climate Change Mitigation
[
    {
        "contributorName": [
            "Kantanen, Pyry"
        ],
        "nameType": [
            "Person"
        ],
        "contributorType": [
            "DataCurator"
        ],
        "orcid": [
            "0000-0003-2853-2765"
        ]
    }
]
{
    "Updated": [
        "2021-07-19"
    ],
    "UpdatedAtSource": [
        "2021-03-10"
    ],
    "EarliestObservation": [
        "2007-01-01"
    ],
    "LatestObservation": [
        "2019-01-01"
    ]
}
eng     42265 bytes in CSV format    
{
    "rightsIdentifier": [
        "CC-BY-NC-SA-4.0"
    ],
    "rightsURI": [
        "https://spdx.org/licenses/CC-BY-NC-SA-4.0.html"
    ]
}
{
    "Abstract": [
        "Relative Size of the Environmental Goods and Services Sector nace_r2: Total - all NACE activities; ceparema: Total environmental protection and resource management activities; na_item: Exports of goods and services; ty: Total environmental goods and services sector [unit: Percentage of gross domestic product (GDP)] \nTotal environmental goods and services sector (in percentage of the GDP) \nBased on Eurostat GBARD by socioeconomic objectives (NABS 2007)  \nMissing at source: Eurostat code=gba_nabsfin07:149.86% \nMissing in our dataset: [gbard_environment_total_total_p6_tot_egss_pc_gdp]: 9.38%"
    ],
    "Other": {
        "id": [
            "keyword1",
            "keyword2",
            "keyword3"
        ],
        "name": [
            "greendeal",
            "mitigation",
            "environmental sector"
        ]
    }
}
[
    {
        "id": "ES",
        "name": "Spain"
    },
    {
        "id": "HR",
        "name": "Croatia"
    },
    {
        "id": "NL",
        "name": "Netherlands"
    },
    {
        "id": "AT",
        "name": "Austria"
    },
    {
        "id": "BE",
        "name": "Belgium"
    },
    {
        "id": "BG",
        "name": "Bulgaria"
    },
    {
        "id": "CZ",
        "name": "Czechia"
    },
    {
        "id": "DE",
        "name": "Germany (until 1990 former territory of the FRG)"
    },
    {
        "id": "DK",
        "name": "Denmark"
    },
    {
        "id": "EE",
        "name": "Estonia"
    },
    {
        "id": "FI",
        "name": "Finland"
    },
    {
        "id": "FR",
        "name": "France"
    },
    {
        "id": "IE",
        "name": "Ireland"
    },
    {
        "id": "IT",
        "name": "Italy"
    },
    {
        "id": "LT",
        "name": "Lithuania"
    },
    {
        "id": "LU",
        "name": "Luxembourg"
    },
    {
        "id": "LV",
        "name": "Latvia"
    },
    {
        "id": "MT",
        "name": "Malta"
    },
    {
        "id": "PL",
        "name": "Poland"
    },
    {
        "id": "PT",
        "name": "Portugal"
    },
    {
        "id": "RO",
        "name": "Romania"
    },
    {
        "id": "RS",
        "name": "Serbia"
    },
    {
        "id": "SE",
        "name": "Sweden"
    },
    {
        "id": "SI",
        "name": "Slovenia"
    },
    {
        "id": "UK",
        "name": "United Kingdom"
    },
    {
        "id": "CY",
        "name": "Cyprus"
    },
    {
        "id": "EL",
        "name": "Greece"
    },
    {
        "id": "HU",
        "name": "Hungary"
    },
    {
        "id": "SK",
        "name": "Slovakia"
    }
]
 
[
    {
        "RelatedItem": [
            "dataobservaotry"
        ],
        "relatedItemType": [
            "Software"
        ],
        "relationType": [
            "isCompiledBy"
        ],
        "relatedItemIdentifier": {
            "id": "dataobservatory",
            "URI": "https://r.dataobservatory.eu/",
            "DOI": "10.5281/zenodo.5034752"
        }
    },
    {
        "RelatedItem": [
            "Retrieval and Analysis of Eurostat Open Data with the eurostat Package "
        ],
        "relatedItemType": [
            "Software"
        ],
        "relationType": [
            "isCompiledBy"
        ],
        "relatedItemIdentifier": {
            "id": "eurostat",
            "URI": "https://ropengov.github.io/eurostat/"
        }
    }
]

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "metadata" (
"dataset_code" TEXT,
  "Identifier" TEXT,
  "Creator" TEXT,
  "Title" TEXT,
  "Publisher" TEXT,
  "PublicationYear" REAL,
  "ResourceType" TEXT,
  "Subject" TEXT,
  "Contributor" TEXT,
  "Date" TEXT,
  "Language" TEXT,
  "AlternateIdentifier" TEXT,
  "RelatedIdentifier" TEXT,
  "Size" TEXT,
  "Format" TEXT,
  "Version" TEXT,
  "Rights" TEXT,
  "Description" TEXT,
  "GeoLocation" TEXT,
  "FundingReference" TEXT,
  "RelatedItem" TEXT
);