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

313 rows

View and edit SQL

Link rowid ▼ dataset_code var_name id name count Description RelatedItem
101 gbard_environment_nabs02_eur_hab geo AT Austria 17 Observation related to Austria
[
    ""
]
102 gbard_environment_nabs02_eur_hab geo BE Belgium 17 Observation related to Belgium
[
    ""
]
103 gbard_environment_nabs02_eur_hab geo BG Bulgaria 17 Observation related to Bulgaria
[
    ""
]
104 gbard_environment_nabs02_eur_hab geo CH Switzerland 17 Observation related to Switzerland
[
    ""
]
105 gbard_environment_nabs02_eur_hab geo CY Cyprus 17 Observation related to Cyprus
[
    ""
]
106 gbard_environment_nabs02_eur_hab geo CZ Czechia 17 Observation related to Czechia
[
    ""
]
107 gbard_environment_nabs02_eur_hab geo DE Germany (until 1990 former territory of the FRG) 17 Observation related to Germany (until 1990 former territory of the FRG)
[
    ""
]
108 gbard_environment_nabs02_eur_hab geo DK Denmark 17 Observation related to Denmark
[
    ""
]
109 gbard_environment_nabs02_eur_hab geo EA19 Euro area - 19 countries (from 2015) 17 Observation related to Euro area - 19 countries (from 2015)
[
    ""
]
110 gbard_environment_nabs02_eur_hab geo EE Estonia 17 Observation related to Estonia
[
    ""
]
111 gbard_environment_nabs02_eur_hab geo EL Greece 17 Observation related to Greece
[
    ""
]
112 gbard_environment_nabs02_eur_hab geo ES Spain 17 Observation related to Spain
[
    ""
]
113 gbard_environment_nabs02_eur_hab geo EU27_2020 European Union - 27 countries (from 2020) 17 Observation related to European Union - 27 countries (from 2020)
[
    ""
]
114 gbard_environment_nabs02_eur_hab geo EU28 European Union - 28 countries (2013-2020) 17 Observation related to European Union - 28 countries (2013-2020)
[
    ""
]
115 gbard_environment_nabs02_eur_hab geo FI Finland 17 Observation related to Finland
[
    ""
]
116 gbard_environment_nabs02_eur_hab geo FR France 17 Observation related to France
[
    ""
]
117 gbard_environment_nabs02_eur_hab geo HR Croatia 17 Observation related to Croatia
[
    ""
]
118 gbard_environment_nabs02_eur_hab geo HU Hungary 17 Observation related to Hungary
[
    ""
]
119 gbard_environment_nabs02_eur_hab geo IE Ireland 17 Observation related to Ireland
[
    ""
]
120 gbard_environment_nabs02_eur_hab geo IS Iceland 17 Observation related to Iceland
[
    ""
]
121 gbard_environment_nabs02_eur_hab geo IT Italy 17 Observation related to Italy
[
    ""
]
122 gbard_environment_nabs02_eur_hab geo JP Japan 17 Observation related to Japan
[
    ""
]
123 gbard_environment_nabs02_eur_hab geo KR South Korea 17 Observation related to South Korea
[
    ""
]
124 gbard_environment_nabs02_eur_hab geo LT Lithuania 17 Observation related to Lithuania
[
    ""
]
125 gbard_environment_nabs02_eur_hab geo LU Luxembourg 17 Observation related to Luxembourg
[
    ""
]
126 gbard_environment_nabs02_eur_hab geo LV Latvia 17 Observation related to Latvia
[
    ""
]
127 gbard_environment_nabs02_eur_hab geo MT Malta 17 Observation related to Malta
[
    ""
]
128 gbard_environment_nabs02_eur_hab geo NL Netherlands 17 Observation related to Netherlands
[
    ""
]
129 gbard_environment_nabs02_eur_hab geo NO Norway 17 Observation related to Norway
[
    ""
]
130 gbard_environment_nabs02_eur_hab geo PL Poland 17 Observation related to Poland
[
    ""
]
131 gbard_environment_nabs02_eur_hab geo PT Portugal 17 Observation related to Portugal
[
    ""
]
132 gbard_environment_nabs02_eur_hab geo RO Romania 17 Observation related to Romania
[
    ""
]
133 gbard_environment_nabs02_eur_hab geo RS Serbia 17 Observation related to Serbia
[
    ""
]
134 gbard_environment_nabs02_eur_hab geo RU Russia 17 Observation related to Russia
[
    ""
]
135 gbard_environment_nabs02_eur_hab geo SE Sweden 17 Observation related to Sweden
[
    ""
]
136 gbard_environment_nabs02_eur_hab geo SI Slovenia 17 Observation related to Slovenia
[
    ""
]
137 gbard_environment_nabs02_eur_hab geo SK Slovakia 17 Observation related to Slovakia
[
    ""
]
138 gbard_environment_nabs02_eur_hab geo TR Turkey 17 Observation related to Turkey
[
    ""
]
139 gbard_environment_nabs02_eur_hab geo UK United Kingdom 17 Observation related to United Kingdom
[
    ""
]
140 gbard_environment_nabs02_eur_hab geo US United States 17 Observation related to United States
[
    ""
]
141 gbard_environment_nabs02_eur_hab method A Actual values 592 No method applied.
[
    ""
]
142 gbard_environment_nabs02_eur_hab method approx Linear Approximation 9 Replacing each missing item with interpolated values.
[
    {},
    {
        "RelatedItem": [
            "zoo: S3 Infrastructure for Regular and Irregular Time Series"
        ],
        "relatedItemType": [
            "Dataset"
        ],
        "relationType": [
            "isCompiledBy"
        ],
        "relatedItemIdentifier": [
            {},
            {
                "id": {},
                "dataset_code": {},
                "URI": {},
                "DOI": [
                    "10.18637/jss.v014.i06"
                ],
                "Version": {},
                "idAtSource": {},
                "Other": {}
            }
        ]
    }
]
143 gbard_environment_nabs02_eur_hab method locf Last Observation Carry Forward 44 Replacing each missing item with the most recent non-missing prior to it.
[
    {},
    {
        "RelatedItem": [
            "zoo: S3 Infrastructure for Regular and Irregular Time Series"
        ],
        "relatedItemType": [
            "Dataset"
        ],
        "relationType": [
            "isCompiledBy"
        ],
        "relatedItemIdentifier": [
            {},
            {
                "id": {},
                "dataset_code": {},
                "URI": {},
                "DOI": [
                    "10.18637/jss.v014.i06"
                ],
                "Version": {},
                "idAtSource": {},
                "Other": {}
            }
        ]
    }
]
144 gbard_environment_nabs02_eur_hab method nocb Next Observation Carry Backwards 35 Replacing each missing item with the next non-missing prior after it.
[
    {},
    {
        "RelatedItem": [
            "zoo: S3 Infrastructure for Regular and Irregular Time Series"
        ],
        "relatedItemType": [
            "Dataset"
        ],
        "relationType": [
            "isCompiledBy"
        ],
        "relatedItemIdentifier": [
            {},
            {
                "id": {},
                "dataset_code": {},
                "URI": {},
                "DOI": [
                    "10.18637/jss.v014.i06"
                ],
                "Version": {},
                "idAtSource": {},
                "Other": {}
            }
        ]
    }
]
145 gbard_environment_nabs02_eur_hab method O Missing values 17 No method applied.
[
    ""
]
146 gbard_environment_nabs02_eur_hab obs_status A Normal value 592 To be used as default value if no value is provided or when no special coded qualification is assumed. Usually, it can be assumed that the source agency assigns sufficient confidence to the provided observation and/or the value is not expected to be dramatically revised.
[
    {},
    {
        "RelatedItem": [
            "SDMX Code List for Observation Status"
        ],
        "relatedItemType": [
            "Dataset"
        ],
        "relationType": [
            "IsDocumentedBy"
        ],
        "relatedItemIdentifier": [
            {},
            {
                "id": [
                    " CL_OBS_STATUS"
                ],
                "dataset_code": {},
                "URI": [
                    "https://sdmx.org/?sdmx_news=new-version-of-code-list-for-observation-status-version-2-2/"
                ],
                "DOI": {},
                "Version": [
                    "2.2"
                ],
                "idAtSource": {},
                "Other": {}
            }
        ]
    }
]
147 gbard_environment_nabs02_eur_hab obs_status E Estimated value 88 Observation obtained through an estimation methodology (e.g. to produce back-casts) or based on the use of a limited amount of data or ad hoc sampling and through additional calculations (e.g. to produce a value at an early stage of the production stage while not all data are available). It may also be used in case of experimental data (e.g. in the context of a pilot ahead of a full scale producti…
[
    {},
    {
        "RelatedItem": [
            "SDMX Code List for Observation Status"
        ],
        "relatedItemType": [
            "Dataset"
        ],
        "relationType": [
            "IsDocumentedBy"
        ],
        "relatedItemIdentifier": [
            {},
            {
                "id": [
                    " CL_OBS_STATUS"
                ],
                "dataset_code": {},
                "URI": [
                    "https://sdmx.org/?sdmx_news=new-version-of-code-list-for-observation-status-version-2-2/"
                ],
                "DOI": {},
                "Version": [
                    "2.2"
                ],
                "idAtSource": {},
                "Other": {}
            }
        ]
    }
]
148 gbard_environment_nabs02_eur_hab obs_status O Missing value 17 This code is to be used when no breakdown is made between the reasons why data are missing. Data can be missing due to many reasons: data cannot exist, data exist but are not collected (e.g. because they are below a certain threshold or subject to a derogation clause), data are unreliable, etc.
[
    {},
    {
        "RelatedItem": [
            "SDMX Code List for Observation Status"
        ],
        "relatedItemType": [
            "Dataset"
        ],
        "relationType": [
            "IsDocumentedBy"
        ],
        "relatedItemIdentifier": [
            {},
            {
                "id": [
                    " CL_OBS_STATUS"
                ],
                "dataset_code": {},
                "URI": [
                    "https://sdmx.org/?sdmx_news=new-version-of-code-list-for-observation-status-version-2-2/"
                ],
                "DOI": {},
                "Version": [
                    "2.2"
                ],
                "idAtSource": {},
                "Other": {}
            }
        ]
    }
]
149 gbard_environment_nabs02_eur_hab unit EUR_HAB Euro per inhabitant 17 Measured in euro per inhabitant
[
    ""
]
150 gbard_environment_total_eur_hab freq A Annual 697 To be used for data collected or disseminated every year
[
    {},
    {
        "RelatedItem": [
            "SDMX Code List for Frequency"
        ],
        "relatedItemType": [
            "Dataset"
        ],
        "relationType": [
            "IsDocumentedBy"
        ],
        "relatedItemIdentifier": [
            {},
            {
                "id": [
                    " CL_FREQ"
                ],
                "dataset_code": {},
                "URI": [
                    "https://sdmx.org/?page_id=3215/"
                ],
                "DOI": {},
                "Version": [
                    "2.1"
                ],
                "idAtSource": {},
                "Other": {}
            }
        ]
    }
]

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "codebook" (
"dataset_code" TEXT,
  "var_name" TEXT,
  "id" TEXT,
  "name" TEXT,
  "count" INTEGER,
  "Description" TEXT,
  "RelatedItem" TEXT
);