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

1 row where dataset_code = "gbard_environment_total_total_p1_tot_egss_pc_gdp" 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
6 gbard_environment_total_total_p1_tot_egss_pc_gdp
[
    {},
    {
        "id": [
            "gbard_environment_total_total_p1_tot_egss_pc_gdp"
        ],
        "dataset_code": [
            "gbard_environment_total_total_p1_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: Output; 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": [
        "2000-01-01"
    ],
    "LatestObservation": [
        "2019-01-01"
    ]
}
eng     65010 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: Output; 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:199.68% \nMissing in our dataset: [gbard_environment_total_total_p1_tot_egss_pc_gdp]: 12.5%"
    ],
    "Other": {
        "id": [
            "keyword1",
            "keyword2",
            "keyword3"
        ],
        "name": [
            "greendeal",
            "mitigation",
            "environmental sector"
        ]
    }
}
[
    {
        "id": "CH",
        "name": "Switzerland"
    },
    {
        "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": "EU27_2020",
        "name": "European Union - 27 countries (from 2020)"
    },
    {
        "id": "EU28",
        "name": "European Union - 28 countries (2013-2020)"
    },
    {
        "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"
    }
]
 
[
    {
        "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
);