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

313 rows

View and edit SQL

Suggested facets: dataset_code, var_name, count, RelatedItem

Link rowid ▼ dataset_code var_name id name count Description RelatedItem
1 gbard_environment_nabs02_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": {}
            }
        ]
    }
]
2 gbard_environment_nabs02_eur_hab geo AT Austria 17 Observation related to Austria
[
    ""
]
3 gbard_environment_nabs02_eur_hab geo BE Belgium 17 Observation related to Belgium
[
    ""
]
4 gbard_environment_nabs02_eur_hab geo BG Bulgaria 17 Observation related to Bulgaria
[
    ""
]
5 gbard_environment_nabs02_eur_hab geo CH Switzerland 17 Observation related to Switzerland
[
    ""
]
6 gbard_environment_nabs02_eur_hab geo CY Cyprus 17 Observation related to Cyprus
[
    ""
]
7 gbard_environment_nabs02_eur_hab geo CZ Czechia 17 Observation related to Czechia
[
    ""
]
8 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)
[
    ""
]
9 gbard_environment_nabs02_eur_hab geo DK Denmark 17 Observation related to Denmark
[
    ""
]
10 gbard_environment_nabs02_eur_hab geo EA19 Euro area - 19 countries (from 2015) 17 Observation related to Euro area - 19 countries (from 2015)
[
    ""
]
11 gbard_environment_nabs02_eur_hab geo EE Estonia 17 Observation related to Estonia
[
    ""
]
12 gbard_environment_nabs02_eur_hab geo EL Greece 17 Observation related to Greece
[
    ""
]
13 gbard_environment_nabs02_eur_hab geo ES Spain 17 Observation related to Spain
[
    ""
]
14 gbard_environment_nabs02_eur_hab geo EU27_2020 European Union - 27 countries (from 2020) 17 Observation related to European Union - 27 countries (from 2020)
[
    ""
]
15 gbard_environment_nabs02_eur_hab geo EU28 European Union - 28 countries (2013-2020) 17 Observation related to European Union - 28 countries (2013-2020)
[
    ""
]
16 gbard_environment_nabs02_eur_hab geo FI Finland 17 Observation related to Finland
[
    ""
]
17 gbard_environment_nabs02_eur_hab geo FR France 17 Observation related to France
[
    ""
]
18 gbard_environment_nabs02_eur_hab geo HR Croatia 17 Observation related to Croatia
[
    ""
]
19 gbard_environment_nabs02_eur_hab geo HU Hungary 17 Observation related to Hungary
[
    ""
]
20 gbard_environment_nabs02_eur_hab geo IE Ireland 17 Observation related to Ireland
[
    ""
]
21 gbard_environment_nabs02_eur_hab geo IS Iceland 17 Observation related to Iceland
[
    ""
]
22 gbard_environment_nabs02_eur_hab geo IT Italy 17 Observation related to Italy
[
    ""
]
23 gbard_environment_nabs02_eur_hab geo JP Japan 17 Observation related to Japan
[
    ""
]
24 gbard_environment_nabs02_eur_hab geo KR South Korea 17 Observation related to South Korea
[
    ""
]
25 gbard_environment_nabs02_eur_hab geo LT Lithuania 17 Observation related to Lithuania
[
    ""
]
26 gbard_environment_nabs02_eur_hab geo LU Luxembourg 17 Observation related to Luxembourg
[
    ""
]
27 gbard_environment_nabs02_eur_hab geo LV Latvia 17 Observation related to Latvia
[
    ""
]
28 gbard_environment_nabs02_eur_hab geo MT Malta 17 Observation related to Malta
[
    ""
]
29 gbard_environment_nabs02_eur_hab geo NL Netherlands 17 Observation related to Netherlands
[
    ""
]
30 gbard_environment_nabs02_eur_hab geo NO Norway 17 Observation related to Norway
[
    ""
]
31 gbard_environment_nabs02_eur_hab geo PL Poland 17 Observation related to Poland
[
    ""
]
32 gbard_environment_nabs02_eur_hab geo PT Portugal 17 Observation related to Portugal
[
    ""
]
33 gbard_environment_nabs02_eur_hab geo RO Romania 17 Observation related to Romania
[
    ""
]
34 gbard_environment_nabs02_eur_hab geo RS Serbia 17 Observation related to Serbia
[
    ""
]
35 gbard_environment_nabs02_eur_hab geo RU Russia 17 Observation related to Russia
[
    ""
]
36 gbard_environment_nabs02_eur_hab geo SE Sweden 17 Observation related to Sweden
[
    ""
]
37 gbard_environment_nabs02_eur_hab geo SI Slovenia 17 Observation related to Slovenia
[
    ""
]
38 gbard_environment_nabs02_eur_hab geo SK Slovakia 17 Observation related to Slovakia
[
    ""
]
39 gbard_environment_nabs02_eur_hab geo TR Turkey 17 Observation related to Turkey
[
    ""
]
40 gbard_environment_nabs02_eur_hab geo UK United Kingdom 17 Observation related to United Kingdom
[
    ""
]
41 gbard_environment_nabs02_eur_hab geo US United States 17 Observation related to United States
[
    ""
]
42 gbard_environment_nabs02_eur_hab method A Actual values 592 No method applied.
[
    ""
]
43 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": {}
            }
        ]
    }
]
44 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": {}
            }
        ]
    }
]
45 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": {}
            }
        ]
    }
]
46 gbard_environment_nabs02_eur_hab method O Missing values 17 No method applied.
[
    ""
]
47 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": {}
            }
        ]
    }
]
48 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": {}
            }
        ]
    }
]
49 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": {}
            }
        ]
    }
]
50 gbard_environment_nabs02_eur_hab unit EUR_HAB Euro per inhabitant 17 Measured in euro per inhabitant
[
    ""
]

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