EUROSTAT.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "![This is an image](Quant-Trading.jpg)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<font size=\"3\">\n",
    "Please visit our website <a href=\"https://www.quant-trading.co\" target=\"_blank\">quant-trading.co</a> for more tools on quantitative finance and data science.\n",
    "</font>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# !pip install pandasdmx"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## **How to download data from the EUROSTAT database?**\n",
    "\n",
    "\n",
    "<font size=\"3\"> Eurostat is the statistical office of the European Union. To download data from the EUROSTAT database you can use the python library pandaSDMX. pandaSDMX is an Apache 2.0-licensed Python library that implements SDMX 2.1, a format for exchange of statistical data and metadata used by national statistical agencies, central banks, and international organisations.<br><br>\n",
    "\n",
    "<font size=\"3\">pandaSDMX can be used to:<br><br>\n",
    "\n",
    "<font size=\"3\">*Explore the data available from over 20 data providers such as the World Bank, BIS, ILO, ECB, Eurostat, OECD, UNICEF and United Nations. <br><br>\n",
    "\n",
    "<font size=\"3\">*Parse data and metadata in SDMX-ML (XML) or SDMX-JSON formats. <br><br>\n",
    "\n",
    "<font size=\"3\">*Convert data and metadata into pandas objects, for use with the analysis, plotting, and other tools in the Python data science ecosystem. <br><br>\n",
    "\n",
    "<font size=\"3\">…and much more.<br><br>\n",
    "\n",
    "<font size=\"3\"> You can even use pandaSDMX to download data from the European Central Bank \"ECB\", The Bank for International Settlement \"BIS\" and some other organizations. At the end of this notebook we will show an exmaple on how to do that for the BIS data. \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import warnings\n",
    "warnings.filterwarnings('ignore')\n",
    "\n",
    "import pandasdmx as pdmx\n",
    "import datetime"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## **Initiate an instance of the specific database**\n",
    "\n",
    "\n",
    "<font size=\"3\">\n",
    "In this example we show how to download data for the ESTAT database. Below is an example using the Request method from the pandasDMX library."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<class 'pandasdmx.api.Request'> instance, source:                ESTAT (Eurostat)"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Initialize with ESTAT data\n",
    "estat = pdmx.Request(\"ESTAT\")\n",
    "estat"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<font size=\"3\">\n",
    "Then we need to use the method dataflow to get a flow message."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pandasdmx.StructureMessage>\n",
       "  <Header>\n",
       "    id: 'DF1706875049'\n",
       "    prepared: '2024-02-02T12:57:29.853000+01:00'\n",
       "    sender: <Agency ESTAT>\n",
       "    source: \n",
       "    test: False\n",
       "  response: <Response [200]>\n",
       "  DataflowDefinition (7666): MAR_GO_QM_MT MAR_GO_QM_NL MAR_GO_QM_NO MAR...\n",
       "  DataStructureDefinition (7216): MAR_GO_QM_MT MAR_GO_QM_NL MAR_GO_QM_N..."
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "flow_msg = estat.dataflow()\n",
    "flow_msg"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<font size=\"3\">\n",
    "And then, using dataflow again we can check the different indicators contained in the database."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'MAR_GO_QM_MT': <DataflowDefinition ESTAT:MAR_GO_QM_MT(1.0): Gross weight of goods transported to/from main ports - Malta - quarterly data>,\n",
       " 'MAR_GO_QM_NL': <DataflowDefinition ESTAT:MAR_GO_QM_NL(1.0): Gross weight of goods transported to/from main ports - Netherlands - quarterly data>,\n",
       " 'MAR_GO_QM_NO': <DataflowDefinition ESTAT:MAR_GO_QM_NO(1.0): Gross weight of goods transported to/from main ports - Norway - quarterly data>,\n",
       " 'MAR_GO_QM_PL': <DataflowDefinition ESTAT:MAR_GO_QM_PL(1.0): Gross weight of goods transported to/from main ports - Poland - quarterly data>,\n",
       " 'MAR_GO_QM_PT': <DataflowDefinition ESTAT:MAR_GO_QM_PT(1.0): Gross weight of goods transported to/from main ports - Portugal - quarterly data>,\n",
       " 'MAR_GO_QM_RO': <DataflowDefinition ESTAT:MAR_GO_QM_RO(1.0): Gross weight of goods transported to/from main ports - Romania - quarterly data>,\n",
       " 'MAR_GO_QM_SE': <DataflowDefinition ESTAT:MAR_GO_QM_SE(1.0): Gross weight of goods transported to/from main ports - Sweden - quarterly data>,\n",
       " 'MAR_GO_QM_SI': <DataflowDefinition ESTAT:MAR_GO_QM_SI(1.0): Gross weight of goods transported to/from main ports - Slovenia - quarterly data>,\n",
       " 'MAR_GO_QM_TR': <DataflowDefinition ESTAT:MAR_GO_QM_TR(1.0): Gross weight of goods transported to/from main ports - Türkiye - quarterly data>,\n",
       " 'MAR_GO_QM_UK': <DataflowDefinition ESTAT:MAR_GO_QM_UK(1.0): Gross weight of goods transported to/from main ports - United Kingdom - quarterly data>,\n",
       " 'MAR_MG_AA_CWH': <DataflowDefinition ESTAT:MAR_MG_AA_CWH(1.0): Country level - gross weight of goods handled in all ports>,\n",
       " 'MAR_MG_AA_CWHD': <DataflowDefinition ESTAT:MAR_MG_AA_CWHD(1.0): Country level - gross weight of goods handled in all ports, by direction>,\n",
       " 'MAR_MG_AA_PWHD': <DataflowDefinition ESTAT:MAR_MG_AA_PWHD(1.0): Gross weight of goods handled in the top 20 EU ports by direction>,\n",
       " 'MAR_MG_AM_CVH': <DataflowDefinition ESTAT:MAR_MG_AM_CVH(1.0): Country level - volume (in TEUs) of containers handled in main ports, by loading status>,\n",
       " 'MAR_MG_AM_CWHC': <DataflowDefinition ESTAT:MAR_MG_AM_CWHC(1.0): Country level - gross weight of goods handled in main ports, by type of cargo>,\n",
       " 'MAR_MG_AM_CWHG': <DataflowDefinition ESTAT:MAR_MG_AM_CWHG(1.0): Country level - Gross weight of goods handled in main ports, by type of goods>,\n",
       " 'MAR_MG_AM_CWT': <DataflowDefinition ESTAT:MAR_MG_AM_CWT(1.0): Country level - gross weight of goods transported to/from main ports>,\n",
       " 'MAR_MG_AM_CWTT': <DataflowDefinition ESTAT:MAR_MG_AM_CWTT(1.0): Country level - gross weight of goods transported to/from main ports, by type of traffic>,\n",
       " 'MAR_MG_AM_PVH': <DataflowDefinition ESTAT:MAR_MG_AM_PVH(1.0): Volume of containers handled in the top 20 EU main ports by loading status>,\n",
       " 'MAR_MG_AM_PWHC': <DataflowDefinition ESTAT:MAR_MG_AM_PWHC(1.0): Gross weight of goods handled in the top 20 EU main ports by type of cargo>,\n",
       " 'MAR_MP_AA_CPH': <DataflowDefinition ESTAT:MAR_MP_AA_CPH(1.0): Country level - passengers embarked and disembarked in all ports>,\n",
       " 'MAR_MP_AA_CPHD': <DataflowDefinition ESTAT:MAR_MP_AA_CPHD(1.0): Country level - passengers embarked and disembarked in all ports, by direction>,\n",
       " 'MAR_MP_AA_PPHD': <DataflowDefinition ESTAT:MAR_MP_AA_PPHD(1.0): Passengers embarked and disembarked in the top 20 EU ports>,\n",
       " 'MAR_MP_AM_CFT': <DataflowDefinition ESTAT:MAR_MP_AM_CFT(1.0): Passengers (excluding cruise passengers) transported from/to the main ports>,\n",
       " 'MAR_MP_AM_CFTT': <DataflowDefinition ESTAT:MAR_MP_AM_CFTT(1.0): Passengers (excluding cruise passengers) transported from/to the main ports by transport coverage>,\n",
       " 'MAR_MT_AM_CSVI': <DataflowDefinition ESTAT:MAR_MT_AM_CSVI(1.0): Country level - number and gross tonnage of vessels in the main ports (based on inwards declarations), by type of vessel>,\n",
       " 'MAR_PA_AA': <DataflowDefinition ESTAT:MAR_PA_AA(1.0): Passengers embarked and disembarked in all ports by direction - annual data>,\n",
       " 'MAR_PA_QM': <DataflowDefinition ESTAT:MAR_PA_QM(1.0): Passengers (excluding cruise passengers) transported from/to the main ports by direction and transport coverage - quarterly data>,\n",
       " 'MAR_PA_QM_BE': <DataflowDefinition ESTAT:MAR_PA_QM_BE(1.0): Passengers (excluding cruise passengers) transported from/to the main ports - Belgium - quarterly data>,\n",
       " 'MAR_PA_QM_DE': <DataflowDefinition ESTAT:MAR_PA_QM_DE(1.0): Passengers (excluding cruise passengers) transported from/to the main ports - Germany - quarterly data>,\n",
       " 'MAR_PA_QM_DK': <DataflowDefinition ESTAT:MAR_PA_QM_DK(1.0): Passengers (excluding cruise passengers) transported from/to the main ports - Denmark - quarterly data>,\n",
       " 'MAR_PA_QM_EE': <DataflowDefinition ESTAT:MAR_PA_QM_EE(1.0): Passengers (excluding cruise passengers) transported from/to the main ports - Estonia - quarterly data>,\n",
       " 'MAR_PA_QM_EL': <DataflowDefinition ESTAT:MAR_PA_QM_EL(1.0): Passengers (excluding cruise passengers) transported from/to the main ports - Greece - quarterly data>,\n",
       " 'MAR_PA_QM_ES': <DataflowDefinition ESTAT:MAR_PA_QM_ES(1.0): Passengers (excluding cruise passengers) transported from/to the main ports - Spain - quarterly data>,\n",
       " 'MAR_PA_QM_FI': <DataflowDefinition ESTAT:MAR_PA_QM_FI(1.0): Passengers (excluding cruise passengers) transported from/to the main ports - Finland - quarterly data>,\n",
       " 'MAR_PA_QM_FR': <DataflowDefinition ESTAT:MAR_PA_QM_FR(1.0): Passengers (excluding cruise passengers) transported from/to the main ports - France - quarterly data>,\n",
       " 'MAR_PA_QM_HR': <DataflowDefinition ESTAT:MAR_PA_QM_HR(1.0): Passengers (excluding cruise passengers) transported from/to the main ports - Croatia - quarterly data>,\n",
       " 'MAR_PA_QM_IE': <DataflowDefinition ESTAT:MAR_PA_QM_IE(1.0): Passengers (excluding cruise passengers) transported from/to the main ports - Ireland - quarterly data>,\n",
       " 'MAR_PA_QM_IT': <DataflowDefinition ESTAT:MAR_PA_QM_IT(1.0): Passengers (excluding cruise passengers) transported from/to the main ports - Italy - quarterly data>,\n",
       " 'MAR_PA_QM_LT': <DataflowDefinition ESTAT:MAR_PA_QM_LT(1.0): Passengers (excluding cruise passengers) transported from/to the main ports - Lithuania - quarterly data>,\n",
       " 'MAR_PA_QM_LV': <DataflowDefinition ESTAT:MAR_PA_QM_LV(1.0): Passengers (excluding cruise passengers) transported from/to the main ports - Latvia- quarterly data>,\n",
       " 'MAR_PA_QM_ME': <DataflowDefinition ESTAT:MAR_PA_QM_ME(1.0): Passengers (excluding cruise passengers) transported from/to the main ports - Montenegro - quarterly data>,\n",
       " 'MAR_PA_QM_MT': <DataflowDefinition ESTAT:MAR_PA_QM_MT(1.0): Passengers (excluding cruise passengers) transported from/to the main ports - Malta - quarterly data>,\n",
       " 'MAR_PA_QM_NL': <DataflowDefinition ESTAT:MAR_PA_QM_NL(1.0): Passengers (excluding cruise passengers) transported from/to the main ports - Netherlands - quarterly data>,\n",
       " 'MAR_PA_QM_NO': <DataflowDefinition ESTAT:MAR_PA_QM_NO(1.0): Passengers (excluding cruise passengers) transported from/to the main ports - Norway - quarterly data>,\n",
       " 'MAR_PA_QM_PL': <DataflowDefinition ESTAT:MAR_PA_QM_PL(1.0): Passengers (excluding cruise passengers) transported from/to the main ports - Poland - quarterly data>,\n",
       " 'MAR_PA_QM_PT': <DataflowDefinition ESTAT:MAR_PA_QM_PT(1.0): Passengers (excluding cruise passengers) transported from/to the main ports - Portugal - quarterly data>,\n",
       " 'MAR_PA_QM_SE': <DataflowDefinition ESTAT:MAR_PA_QM_SE(1.0): Passengers (excluding cruise passengers) transported from/to the main ports - Sweden - quarterly data>,\n",
       " 'MAR_PA_QM_TR': <DataflowDefinition ESTAT:MAR_PA_QM_TR(1.0): Passengers (excluding cruise passengers) transported from/to the main ports - Türkiye - quarterly data>,\n",
       " 'MAR_PA_QM_UK': <DataflowDefinition ESTAT:MAR_PA_QM_UK(1.0): Passengers (excluding cruise passengers) transported from/to the main ports - United Kingdom - quarterly data>,\n",
       " 'MAR_QG_QM_CWH': <DataflowDefinition ESTAT:MAR_QG_QM_CWH(1.0): Country level - gross weight of goods handled in main ports>,\n",
       " 'MAR_QG_QM_EWH': <DataflowDefinition ESTAT:MAR_QG_QM_EWH(1.0): EU level - top 20 extra-EU maritime trade flows by gross weight of goods handled in EU main ports>,\n",
       " 'MAR_QG_QM_EWHD': <DataflowDefinition ESTAT:MAR_QG_QM_EWHD(1.0): Eu level - gross weight of goods handled in main ports, by direction>,\n",
       " 'MAR_QG_QM_EWHG': <DataflowDefinition ESTAT:MAR_QG_QM_EWHG(1.0): Eu level - gross weight of goods handled in main ports, by various types of partner geographical areas>,\n",
       " 'MAR_QG_QM_EWHK': <DataflowDefinition ESTAT:MAR_QG_QM_EWHK(1.0): Eu level - gross weight of goods handled in main ports, by type of cargo>,\n",
       " 'MAR_QG_QM_EWHP': <DataflowDefinition ESTAT:MAR_QG_QM_EWHP(1.0): EU level - top 10 extra-EU partner countries by gross weight of goods handled in EU main ports>,\n",
       " 'MAR_QG_QM_EWHT': <DataflowDefinition ESTAT:MAR_QG_QM_EWHT(1.0): Eu level - gross weight of goods handled in main ports, by type of traffic>,\n",
       " 'MAR_QG_QM_PVH': <DataflowDefinition ESTAT:MAR_QG_QM_PVH(1.0): Top 5 ports for volume of containers - volume (in TEUs) of containers handled in each port>,\n",
       " 'MAR_QG_QM_PWH': <DataflowDefinition ESTAT:MAR_QG_QM_PWH(1.0): Top 5 ports - gross weight of goods handled in each port>,\n",
       " 'MAR_QG_QM_PWHB': <DataflowDefinition ESTAT:MAR_QG_QM_PWHB(1.0): Top 5 ports for dry bulk- gross weight of dry bulk goods handled in each port>,\n",
       " 'MAR_QG_QM_PWHC': <DataflowDefinition ESTAT:MAR_QG_QM_PWHC(1.0): Top 5 ports for containers - gross weight of goods in containers handled in each port>,\n",
       " 'MAR_QG_QM_PWHL': <DataflowDefinition ESTAT:MAR_QG_QM_PWHL(1.0): Top 5 ports for liquid bulk - gross weight of liquid bulk goods handled in each port>,\n",
       " 'MAR_QG_QM_PWHO': <DataflowDefinition ESTAT:MAR_QG_QM_PWHO(1.0): Top 5 ports for other cargo not elsewhere specified - gross weight of goods in other cargo not elsewhere specified handled in each port>,\n",
       " 'MAR_QG_QM_PWHR': <DataflowDefinition ESTAT:MAR_QG_QM_PWHR(1.0): Top 5 ports for Ro-ro units - gross weight of goods in Ro-Ro units handled in each port>,\n",
       " 'MAR_SG_AM_CV': <DataflowDefinition ESTAT:MAR_SG_AM_CV(1.0): Short sea shipping - country level - volume (in TEU's) of containers transported to/from main ports, by loading status>,\n",
       " 'MAR_SG_AM_CW': <DataflowDefinition ESTAT:MAR_SG_AM_CW(1.0): Short sea shipping - country level - gross weight of goods transported to/from main ports>,\n",
       " 'MAR_SG_AM_CWD': <DataflowDefinition ESTAT:MAR_SG_AM_CWD(1.0): Short sea shipping - country level - gross weight of goods transported to/from main ports, by direction>,\n",
       " 'MAR_SG_AM_CWK': <DataflowDefinition ESTAT:MAR_SG_AM_CWK(1.0): Short sea shipping - country level - gross weight of goods transported to/from main ports, by type of cargo>,\n",
       " 'MAR_SG_AM_CWS': <DataflowDefinition ESTAT:MAR_SG_AM_CWS(1.0): Short sea shipping - country level - gross weight of goods transported to/from main ports, by sea region of partner ports>,\n",
       " 'MAR_SG_AM_EWX': <DataflowDefinition ESTAT:MAR_SG_AM_EWX(1.0): Short sea shipping - EU level - gross weight of goods transported to/from main ports, by type of cargo for each sea region of partner ports>,\n",
       " 'MAR_SG_AM_PW': <DataflowDefinition ESTAT:MAR_SG_AM_PW(1.0): Gross weight of goods transported in short sea shipping from/to the top 20 EU ports>,\n",
       " 'MAR_SG_AM_PWB': <DataflowDefinition ESTAT:MAR_SG_AM_PWB(1.0): Gross weight of dry bulk goods transported in short sea shipping from/to the top 5 EU ports for dry bulk goods>,\n",
       " 'MAR_SG_AM_PWC': <DataflowDefinition ESTAT:MAR_SG_AM_PWC(1.0): Gross weight of goods in containers transported in short sea shipping from/to the top 5 EU ports for goods in containers>,\n",
       " 'MAR_SG_AM_PWL': <DataflowDefinition ESTAT:MAR_SG_AM_PWL(1.0): Gross weight of liquid bulk goods transported in short sea shipping from/to the top 5 EU ports for liquid bulk goods>,\n",
       " 'MAR_SG_AM_PWR': <DataflowDefinition ESTAT:MAR_SG_AM_PWR(1.0): Gross weight of goods in Ro-ro units transported in short sea shipping from/to the top 5 EU ports for goods in Ro-ro units>,\n",
       " 'MAR_TF_QM': <DataflowDefinition ESTAT:MAR_TF_QM(1.0): Vessels in main ports by type and size of vessels (based on inwards declarations) - quarterly data>,\n",
       " 'MAR_TP_GO': <DataflowDefinition ESTAT:MAR_TP_GO(1.0): Maritime goods transport performed in the Exclusive Economic Zone (EEZ) of the countries>,\n",
       " 'MAR_TP_PA': <DataflowDefinition ESTAT:MAR_TP_PA(1.0): Maritime passenger transport performed in the Exclusive Economic Zone (EEZ) of the countries>,\n",
       " 'MAR_TP_SSS': <DataflowDefinition ESTAT:MAR_TP_SSS(1.0): Maritime goods short-sea shipping performed in the Exclusive Economic Zone (EEZ) of the countries>,\n",
       " 'MED_AG1': <DataflowDefinition ESTAT:MED_AG1(1.0): Structural information>,\n",
       " 'MED_AG2': <DataflowDefinition ESTAT:MED_AG2(1.0): Crop production>,\n",
       " 'MED_AG31': <DataflowDefinition ESTAT:MED_AG31(1.0): Meat (total production)>,\n",
       " 'MED_AG32': <DataflowDefinition ESTAT:MED_AG32(1.0): Annual production and utilisation of milk on the farm>,\n",
       " 'MED_AG33': <DataflowDefinition ESTAT:MED_AG33(1.0): Livestock in number of heads>,\n",
       " 'MED_AG34': <DataflowDefinition ESTAT:MED_AG34(1.0): Poultry farming>,\n",
       " 'MED_AG41': <DataflowDefinition ESTAT:MED_AG41(1.0): Annual captures of fish - live weight in tonnes - by fishing areas>,\n",
       " 'MED_AG42': <DataflowDefinition ESTAT:MED_AG42(1.0): Annual aquaculture production - live weight in tonnes>,\n",
       " 'MED_AG50': <DataflowDefinition ESTAT:MED_AG50(1.0): Economic accounts for agriculture (EAA)>,\n",
       " 'MED_AG51': <DataflowDefinition ESTAT:MED_AG51(1.0): Price indices of agricultural input/output at nominal value (2000 = 100)>,\n",
       " 'MED_AIR1': <DataflowDefinition ESTAT:MED_AIR1(1.0): Air transport infrastructure: airports>,\n",
       " 'MED_AIR2': <DataflowDefinition ESTAT:MED_AIR2(1.0): Air transport infrastructure: length of paved runways>,\n",
       " 'MED_AIR3': <DataflowDefinition ESTAT:MED_AIR3(1.0): Air transport equipment: number of aircrafts>,\n",
       " 'MED_AIR4': <DataflowDefinition ESTAT:MED_AIR4(1.0): Air transport traffic: number of aircraft movements>,\n",
       " 'MED_AIR5': <DataflowDefinition ESTAT:MED_AIR5(1.0): Air transport traffic: freight and passengers>,\n",
       " 'MED_EC0': <DataflowDefinition ESTAT:MED_EC0(1.0): Additional indicators>,\n",
       " 'MED_EC1': <DataflowDefinition ESTAT:MED_EC1(1.0): Gross domestic product>,\n",
       " 'MED_EC2': <DataflowDefinition ESTAT:MED_EC2(1.0): Final consumption expenditure>,\n",
       " 'MED_EC3': <DataflowDefinition ESTAT:MED_EC3(1.0): Gross capital formation>,\n",
       " 'MED_EC4': <DataflowDefinition ESTAT:MED_EC4(1.0): International trade as a share of GDP>,\n",
       " 'MED_EC5': <DataflowDefinition ESTAT:MED_EC5(1.0): Gross value added>,\n",
       " 'MED_EC6': <DataflowDefinition ESTAT:MED_EC6(1.0): Balancing items>,\n",
       " 'MED_EC7': <DataflowDefinition ESTAT:MED_EC7(1.0): Debts>,\n",
       " 'MED_EC8': <DataflowDefinition ESTAT:MED_EC8(1.0): Prices (annual series)>,\n",
       " 'MED_EC9': <DataflowDefinition ESTAT:MED_EC9(1.0): Exchange rates>,\n",
       " 'MED_ECBP': <DataflowDefinition ESTAT:MED_ECBP(1.0): Balance of payments>,\n",
       " 'MED_ECET': <DataflowDefinition ESTAT:MED_ECET(1.0): International trade by SITC - 1 000 EUR>,\n",
       " 'MED_EG10': <DataflowDefinition ESTAT:MED_EG10(1.0): Primary energy production>,\n",
       " 'MED_EG20': <DataflowDefinition ESTAT:MED_EG20(1.0): Secondary energy production (transformation)>,\n",
       " 'MED_EG30': <DataflowDefinition ESTAT:MED_EG30(1.0): Energy consumption>,\n",
       " 'MED_EG_ALL': <DataflowDefinition ESTAT:MED_EG_ALL(1.0): Energy - historical data (2004-2007, former methodology and source)>,\n",
       " 'MED_EN1': <DataflowDefinition ESTAT:MED_EN1(1.0): GHG (Green House Gases) emissions>,\n",
       " 'MED_EN2': <DataflowDefinition ESTAT:MED_EN2(1.0): Air emissions per sector and per gas>,\n",
       " 'MED_EN21': <DataflowDefinition ESTAT:MED_EN21(1.0): Municipal waste>,\n",
       " 'MED_EN22': <DataflowDefinition ESTAT:MED_EN22(1.0): Generation of waste by sector>,\n",
       " 'MED_EN23': <DataflowDefinition ESTAT:MED_EN23(1.0): Composition of municipal waste>,\n",
       " 'MED_EN24': <DataflowDefinition ESTAT:MED_EN24(1.0): Treatment and disposal facilities>,\n",
       " 'MED_EN25': <DataflowDefinition ESTAT:MED_EN25(1.0): Management of waste>,\n",
       " 'MED_EN3': <DataflowDefinition ESTAT:MED_EN3(1.0): Local pollution>,\n",
       " 'MED_EN41': <DataflowDefinition ESTAT:MED_EN41(1.0): Renewable freshwater resources>,\n",
       " 'MED_EN42': <DataflowDefinition ESTAT:MED_EN42(1.0): Water use balance>,\n",
       " 'MED_EN43': <DataflowDefinition ESTAT:MED_EN43(1.0): Freshwater abstraction>,\n",
       " 'MED_EN44': <DataflowDefinition ESTAT:MED_EN44(1.0): Water supplied and used by economic sectors>,\n",
       " 'MED_EN46': <DataflowDefinition ESTAT:MED_EN46(1.0): Urban wastewater treatment>,\n",
       " 'MED_EN47': <DataflowDefinition ESTAT:MED_EN47(1.0): Population connected to Wastewater Treatment>,\n",
       " 'MED_EN51': <DataflowDefinition ESTAT:MED_EN51(1.0): Protected areas>,\n",
       " 'MED_EN52': <DataflowDefinition ESTAT:MED_EN52(1.0): Number of known species>,\n",
       " 'MED_EN53': <DataflowDefinition ESTAT:MED_EN53(1.0): Percentage of threatened species>,\n",
       " 'MED_EN61': <DataflowDefinition ESTAT:MED_EN61(1.0): Landuse>,\n",
       " 'MED_EN62': <DataflowDefinition ESTAT:MED_EN62(1.0): Forest and irrigated land>,\n",
       " 'MED_EN63': <DataflowDefinition ESTAT:MED_EN63(1.0): Erosion>,\n",
       " 'MED_MA1': <DataflowDefinition ESTAT:MED_MA1(1.0): Maritime transport infrastructure: ports>,\n",
       " 'MED_MA2': <DataflowDefinition ESTAT:MED_MA2(1.0): Maritime equipment - number of ships of 1 000 grt and over>,\n",
       " 'MED_MA3': <DataflowDefinition ESTAT:MED_MA3(1.0): Maritime equipment - number of ships of 300 grt and over>,\n",
       " 'MED_MA4': <DataflowDefinition ESTAT:MED_MA4(1.0): Maritime equipment - carrying capacity of ships of 1 000 grt and over>,\n",
       " 'MED_MA5': <DataflowDefinition ESTAT:MED_MA5(1.0): Maritime equipment - carrying capacity of ships of 300 grt and over>,\n",
       " 'MED_MA6': <DataflowDefinition ESTAT:MED_MA6(1.0): Maritime traffic: ship movements>,\n",
       " 'MED_MA7': <DataflowDefinition ESTAT:MED_MA7(1.0): Maritime traffic: passengers and freight>,\n",
       " 'MED_PS111': <DataflowDefinition ESTAT:MED_PS111(1.0): General indicators>,\n",
       " 'MED_PS112': <DataflowDefinition ESTAT:MED_PS112(1.0): Population on 1 January by sex and by age group>,\n",
       " 'MED_PS115': <DataflowDefinition ESTAT:MED_PS115(1.0): Average population (mid-year)>,\n",
       " 'MED_PS12': <DataflowDefinition ESTAT:MED_PS12(1.0): Demographic indicators>,\n",
       " 'MED_PS21': <DataflowDefinition ESTAT:MED_PS21(1.0): Literacy>,\n",
       " 'MED_PS22': <DataflowDefinition ESTAT:MED_PS22(1.0): General education>,\n",
       " 'MED_PS23': <DataflowDefinition ESTAT:MED_PS23(1.0): Higher education>,\n",
       " 'MED_PS24': <DataflowDefinition ESTAT:MED_PS24(1.0): Quality of education>,\n",
       " 'MED_PS25': <DataflowDefinition ESTAT:MED_PS25(1.0): Technical and vocational education training (TVET)>,\n",
       " 'MED_PS26': <DataflowDefinition ESTAT:MED_PS26(1.0): Public expenditure on education>,\n",
       " 'MED_PS311': <DataflowDefinition ESTAT:MED_PS311(1.0): Poverty lines>,\n",
       " 'MED_PS312': <DataflowDefinition ESTAT:MED_PS312(1.0): At-risk-of poverty rate>,\n",
       " 'MED_PS313': <DataflowDefinition ESTAT:MED_PS313(1.0): Poverty ratio>,\n",
       " 'MED_PS32': <DataflowDefinition ESTAT:MED_PS32(1.0): Access to basic services and housing>,\n",
       " 'MED_PS33': <DataflowDefinition ESTAT:MED_PS33(1.0): Communication>,\n",
       " 'MED_PS411': <DataflowDefinition ESTAT:MED_PS411(1.0): Employment>,\n",
       " 'MED_PS412': <DataflowDefinition ESTAT:MED_PS412(1.0): Economic activity>,\n",
       " 'MED_PS413': <DataflowDefinition ESTAT:MED_PS413(1.0): Employment characteristics>,\n",
       " 'MED_PS414': <DataflowDefinition ESTAT:MED_PS414(1.0): Employment and economic activity branches>,\n",
       " 'MED_PS421': <DataflowDefinition ESTAT:MED_PS421(1.0): Unemployment rate>,\n",
       " 'MED_PS422': <DataflowDefinition ESTAT:MED_PS422(1.0): Unemployment rate by education level>,\n",
       " 'MED_PS423': <DataflowDefinition ESTAT:MED_PS423(1.0): Proportion of persons living in jobless households>,\n",
       " 'MED_PS43': <DataflowDefinition ESTAT:MED_PS43(1.0): Wages>,\n",
       " 'MED_RA1': <DataflowDefinition ESTAT:MED_RA1(1.0): Rail infrastructure: length of network>,\n",
       " 'MED_RA2': <DataflowDefinition ESTAT:MED_RA2(1.0): Rail equipment: number of locomotives and passenger railways vehicles>,\n",
       " 'MED_RA3': <DataflowDefinition ESTAT:MED_RA3(1.0): Rail equipment: number and capacity of railways vehicles>,\n",
       " 'MED_RA4': <DataflowDefinition ESTAT:MED_RA4(1.0): Rail equipment: number and load capacity of goods transport wagons>,\n",
       " 'MED_RA5': <DataflowDefinition ESTAT:MED_RA5(1.0): Rail passenger and freight traffic>,\n",
       " 'MED_RD1': <DataflowDefinition ESTAT:MED_RD1(1.0): Road infrastructure: lenght of road network>,\n",
       " 'MED_RD2': <DataflowDefinition ESTAT:MED_RD2(1.0): Road equipment: number of road vehicles by categories>,\n",
       " 'MED_RD3': <DataflowDefinition ESTAT:MED_RD3(1.0): Road equipment: number of road vehicles by age>,\n",
       " 'MED_RD4': <DataflowDefinition ESTAT:MED_RD4(1.0): Road equipment: load capacity of lorries>,\n",
       " 'MED_RD5': <DataflowDefinition ESTAT:MED_RD5(1.0): Road equipment: new registrations by categories>,\n",
       " 'MED_RD6': <DataflowDefinition ESTAT:MED_RD6(1.0): Road traffic: road freight transport in volume>,\n",
       " 'MED_RD7': <DataflowDefinition ESTAT:MED_RD7(1.0): Road accidents: persons killed>,\n",
       " 'MED_TO11': <DataflowDefinition ESTAT:MED_TO11(1.0): Main flows>,\n",
       " 'MED_TO12': <DataflowDefinition ESTAT:MED_TO12(1.0): Arrivals by type of accommodation>,\n",
       " 'MED_TO13': <DataflowDefinition ESTAT:MED_TO13(1.0): Nights spent by type of accommodation>,\n",
       " 'MED_TO21': <DataflowDefinition ESTAT:MED_TO21(1.0): Accommodation establishments>,\n",
       " 'MED_TO22': <DataflowDefinition ESTAT:MED_TO22(1.0): Number of bed-places>,\n",
       " 'MET_10R_3EMP': <DataflowDefinition ESTAT:MET_10R_3EMP(1.0): Employment by NACE Rev. 2 activity and metropolitan typology>,\n",
       " 'MET_10R_3GDP': <DataflowDefinition ESTAT:MET_10R_3GDP(1.0): Gross domestic product (GDP) at current market prices by metropolitan regions>,\n",
       " 'MET_10R_3GVA': <DataflowDefinition ESTAT:MET_10R_3GVA(1.0): Gross value added at basic prices by metropolitan regions>,\n",
       " 'MET_10R_3PGDP': <DataflowDefinition ESTAT:MET_10R_3PGDP(1.0): Average annual population to calculate regional GDP data by metropolitan regions>,\n",
       " 'MET_BD_EN2': <DataflowDefinition ESTAT:MET_BD_EN2(1.0): Employer business demography by NACE Rev. 2activity and metropolitan regions>,\n",
       " 'MET_BD_ESIZE': <DataflowDefinition ESTAT:MET_BD_ESIZE(1.0): Employer business demography by size class and metropolitan regions>,\n",
       " 'MET_BD_HGN2': <DataflowDefinition ESTAT:MET_BD_HGN2(1.0): Business demography and high growth enterprise by NACE Rev. 2 activity and metropolitan regions>,\n",
       " 'MET_BD_SIZE': <DataflowDefinition ESTAT:MET_BD_SIZE(1.0): Business demography by size class and metropolitan regions>,\n",
       " 'MET_BIRTHS': <DataflowDefinition ESTAT:MET_BIRTHS(1.0): Live births (total) by metropolitan regions>,\n",
       " 'MET_CRIM_GEN': <DataflowDefinition ESTAT:MET_CRIM_GEN(1.0): Crimes recorded by the police by metropolitan regions>,\n",
       " 'MET_D3AREA': <DataflowDefinition ESTAT:MET_D3AREA(1.0): Area of the regions by metropolitan regions>,\n",
       " 'MET_D3DENS': <DataflowDefinition ESTAT:MET_D3DENS(1.0): Population density by metropolitan regions>,\n",
       " 'MET_DEATHS': <DataflowDefinition ESTAT:MET_DEATHS(1.0): Deaths (total) by metropolitan regions>,\n",
       " 'MET_EDAT_LFSE4': <DataflowDefinition ESTAT:MET_EDAT_LFSE4(1.0): Population aged 25-64 by educational attainment level, sex and metropolitan regions>,\n",
       " 'MET_GIND3': <DataflowDefinition ESTAT:MET_GIND3(1.0): Demographic balance and crude rates by metropolitan regions>,\n",
       " 'MET_IPR_DA': <DataflowDefinition ESTAT:MET_IPR_DA(1.0): Community design (CD) applications by metropolitan regions>,\n",
       " 'MET_IPR_DAGDP': <DataflowDefinition ESTAT:MET_IPR_DAGDP(1.0): Community design (CD) applications per billion GDP by metropolitan regions>,\n",
       " 'MET_IPR_DAPOP': <DataflowDefinition ESTAT:MET_IPR_DAPOP(1.0): Community design (CD) applications per million population by metropolitan regions>,\n",
       " 'MET_IPR_DFA': <DataflowDefinition ESTAT:MET_IPR_DFA(1.0): Community designs (CD) by metropolitan regions>,\n",
       " 'MET_IPR_DFAGDP': <DataflowDefinition ESTAT:MET_IPR_DFAGDP(1.0): Community designs (CD) per billion GDP by metropolitan regions>,\n",
       " 'MET_IPR_DFAPOP': <DataflowDefinition ESTAT:MET_IPR_DFAPOP(1.0): Community designs (CD) per million population by metropolitan regions>,\n",
       " 'MET_IPR_DR': <DataflowDefinition ESTAT:MET_IPR_DR(1.0): Registered Community designs (RCD) by metropolitan regions>,\n",
       " 'MET_IPR_TA': <DataflowDefinition ESTAT:MET_IPR_TA(1.0): European Union trade mark (EUTM) applications by metropolitan regions>,\n",
       " 'MET_IPR_TAGDP': <DataflowDefinition ESTAT:MET_IPR_TAGDP(1.0): European Union trade mark (EUTM) applications per billion GDP by metropolitan regions>,\n",
       " 'MET_IPR_TAPOP': <DataflowDefinition ESTAT:MET_IPR_TAPOP(1.0): European Union trade mark (EUTM) applications per million population by metropolitan regions>,\n",
       " 'MET_LFE3EMP': <DataflowDefinition ESTAT:MET_LFE3EMP(1.0): Employment by sex, age and metropolitan regions>,\n",
       " 'MET_LFE3EMPRT': <DataflowDefinition ESTAT:MET_LFE3EMPRT(1.0): Employment rates by sex and age and metropolitan regions>,\n",
       " 'MET_LFP3POP': <DataflowDefinition ESTAT:MET_LFP3POP(1.0): Economically active population by sex, age and metropolitan regions>,\n",
       " 'MET_LFSD3POP': <DataflowDefinition ESTAT:MET_LFSD3POP(1.0): Population by sex, age and metropolitan regions>,\n",
       " 'MET_LFU3PERS': <DataflowDefinition ESTAT:MET_LFU3PERS(1.0): Unemployment by sex, age and metropolitan regions>,\n",
       " 'MET_LFU3RT': <DataflowDefinition ESTAT:MET_LFU3RT(1.0): Unemployment rates by sex, age and metropolitan regions>,\n",
       " 'MET_PAT_EPIPC': <DataflowDefinition ESTAT:MET_PAT_EPIPC(1.0): Patent applications to the EPO by priority year, by international patent classification (IPC) sections, classes and metropolitan regions>,\n",
       " 'MET_PAT_EPTEC': <DataflowDefinition ESTAT:MET_PAT_EPTEC(1.0): High-tech patent applications to the EPO by priority year and metropolitan regions>,\n",
       " 'MET_PAT_EPTOT': <DataflowDefinition ESTAT:MET_PAT_EPTOT(1.0): Patent applications to the EPO by priority year and metropolitan regions>,\n",
       " 'MET_PJANAGGR3': <DataflowDefinition ESTAT:MET_PJANAGGR3(1.0): Population on 1 January by broad age group, sex and metropolitan regions>,\n",
       " 'MET_PJANGRP3': <DataflowDefinition ESTAT:MET_PJANGRP3(1.0): Population on 1 January by five year age group, sex and metropolitan regions>,\n",
       " 'MET_PROJ_19RANMIG': <DataflowDefinition ESTAT:MET_PROJ_19RANMIG(1.0): Assumptions for net migration by age, sex, type of projection and metropolitan regions>,\n",
       " 'MET_PROJ_19RDBI': <DataflowDefinition ESTAT:MET_PROJ_19RDBI(1.0): Demographic balances and indicators by type of projection and metropolitan regions>,\n",
       " 'MET_PROJ_19RDTH': <DataflowDefinition ESTAT:MET_PROJ_19RDTH(1.0): Projected deaths by age, sex, type of projection and metropolitan regions>,\n",
       " 'MET_PROJ_19RP': <DataflowDefinition ESTAT:MET_PROJ_19RP(1.0): Population on 1st January by age, sex, type of projection and metropolitan regions>,\n",
       " 'MET_ROAD_GONL': <DataflowDefinition ESTAT:MET_ROAD_GONL(1.0): National annual road freight transport by regions of loading, group of goods and metropolitan regions>,\n",
       " 'MET_ROAD_GONU': <DataflowDefinition ESTAT:MET_ROAD_GONU(1.0): National annual road freight transport by regions of unloading, group of goods and metropolitan regions>,\n",
       " 'MIGR_ACQ': <DataflowDefinition ESTAT:MIGR_ACQ(1.0): Acquisition of citizenship by age group, sex and former citizenship>,\n",
       " 'MIGR_ACQ1CTZ': <DataflowDefinition ESTAT:MIGR_ACQ1CTZ(1.0): Acquisition of citizenship by age group, sex and level of human development of former citizenship>,\n",
       " 'MIGR_ACQS': <DataflowDefinition ESTAT:MIGR_ACQS(1.0): Residents who acquired citizenship as a share of resident non-citizens by former citizenship and sex>,\n",
       " 'MIGR_ASYACCM': <DataflowDefinition ESTAT:MIGR_ASYACCM(1.0): Asylum applicants having had their applications processed under the accelerated procedure, by age, sex and citizenship - monthly data>,\n",
       " 'MIGR_ASYACCM$DV_961': <DataflowDefinition ESTAT:MIGR_ASYACCM$DV_961(1.0): Asylum applicants having had their applications processed under the accelerated procedure, by age, sex and citizenship - monthly data>,\n",
       " 'MIGR_ASYAPP1MP': <DataflowDefinition ESTAT:MIGR_ASYAPP1MP(1.0): First time asylum applicants - per million persons>,\n",
       " 'MIGR_ASYAPP1PC': <DataflowDefinition ESTAT:MIGR_ASYAPP1PC(1.0): First time asylum applicants - % of total asylum applicants>,\n",
       " 'MIGR_ASYAPP1UP': <DataflowDefinition ESTAT:MIGR_ASYAPP1UP(1.0): First time asylum applications of unaccompanied minors  - % of total first time asylum applications of minors>,\n",
       " 'MIGR_ASYAPPCTZA': <DataflowDefinition ESTAT:MIGR_ASYAPPCTZA(1.0): Asylum applicants by type of applicant, citizenship, age and sex - annual aggregated data>,\n",
       " 'MIGR_ASYAPPCTZA$DV_618': <DataflowDefinition ESTAT:MIGR_ASYAPPCTZA$DV_618(1.0): Asylum applicants by type of applicant, citizenship, age and sex - annual aggregated data>,\n",
       " 'MIGR_ASYAPPCTZM': <DataflowDefinition ESTAT:MIGR_ASYAPPCTZM(1.0): Asylum applicants by type of applicant, citizenship, age and sex - monthly data>,\n",
       " 'MIGR_ASYAPPCTZM$DV_721': <DataflowDefinition ESTAT:MIGR_ASYAPPCTZM$DV_721(1.0): Asylum applicants by type of applicant, citizenship, age and sex - monthly data>,\n",
       " 'MIGR_ASYCTZ': <DataflowDefinition ESTAT:MIGR_ASYCTZ(1.0): Asylum applicants by citizenship till 2007 - annual data>,\n",
       " 'MIGR_ASYCTZM': <DataflowDefinition ESTAT:MIGR_ASYCTZM(1.0): First time asylum applicants by citizenship till December 2007 - monthly data>,\n",
       " 'MIGR_ASYDCFINA': <DataflowDefinition ESTAT:MIGR_ASYDCFINA(1.0): Final decisions in appeal or review on applications by citizenship, age and sex - annual data>,\n",
       " 'MIGR_ASYDCFINA$DV_620': <DataflowDefinition ESTAT:MIGR_ASYDCFINA$DV_620(1.0): Final decisions in appeal or review on applications by citizenship, age and sex - annual data>,\n",
       " 'MIGR_ASYDCFSTA': <DataflowDefinition ESTAT:MIGR_ASYDCFSTA(1.0): First instance decisions on applications by citizenship, age and sex - annual aggregated data>,\n",
       " 'MIGR_ASYDCFSTA$DV_621': <DataflowDefinition ESTAT:MIGR_ASYDCFSTA$DV_621(1.0): First instance decisions on applications by citizenship, age and sex - annual aggregated data>,\n",
       " 'MIGR_ASYDCFSTQ': <DataflowDefinition ESTAT:MIGR_ASYDCFSTQ(1.0): First instance decisions on applications by citizenship, age and sex - quarterly data>,\n",
       " 'MIGR_ASYDCFSTQ$DV_722': <DataflowDefinition ESTAT:MIGR_ASYDCFSTQ$DV_722(1.0): First instance decisions on applications by citizenship, age and sex - quarterly data>,\n",
       " 'MIGR_ASYDCTZM': <DataflowDefinition ESTAT:MIGR_ASYDCTZM(1.0): Decisions on asylum applications by citizenship till December 2007 - monthly data>,\n",
       " 'MIGR_ASYDCTZY': <DataflowDefinition ESTAT:MIGR_ASYDCTZY(1.0): Decisions on asylum applications by citizenship till 2007 - annual data>,\n",
       " 'MIGR_ASYDEC1P': <DataflowDefinition ESTAT:MIGR_ASYDEC1P(1.0): Positive first instance decisions - per million persons>,\n",
       " 'MIGR_ASYDEC1PC': <DataflowDefinition ESTAT:MIGR_ASYDEC1PC(1.0): Asylum decisions at first instance by type of decision - % of total decisions at first instance>,\n",
       " 'MIGR_ASYDECFP': <DataflowDefinition ESTAT:MIGR_ASYDECFP(1.0): Asylum decisions at final instance by type of decision  - % of total decisions at final instance>,\n",
       " 'MIGR_ASYMRCA': <DataflowDefinition ESTAT:MIGR_ASYMRCA(1.0): Applicants having benefited from material reception conditions at the end of the reference year - annual data>,\n",
       " 'MIGR_ASYPENCTZM': <DataflowDefinition ESTAT:MIGR_ASYPENCTZM(1.0): Persons subject of asylum applications pending at the end of the month by citizenship, age and sex - monthly data>,\n",
       " 'MIGR_ASYPENCTZM$DV_723': <DataflowDefinition ESTAT:MIGR_ASYPENCTZM$DV_723(1.0): Persons subject of asylum applications pending at the end of the month by citizenship, age and sex - monthly data>,\n",
       " 'MIGR_ASYRELFA': <DataflowDefinition ESTAT:MIGR_ASYRELFA(1.0): Resettled persons by age, sex, citizenship and resettlement framework - annual data>,\n",
       " 'MIGR_ASYRESA': <DataflowDefinition ESTAT:MIGR_ASYRESA(1.0): Resettled persons by age, sex and citizenship - annual data>,\n",
       " 'MIGR_ASYRESA$DV_629': <DataflowDefinition ESTAT:MIGR_ASYRESA$DV_629(1.0): Resettled persons by age, sex and citizenship - annual data>,\n",
       " 'MIGR_ASYRESCRA': <DataflowDefinition ESTAT:MIGR_ASYRESCRA(1.0): Resettled persons by age, sex, citizenship and country of previous residence - annual data>,\n",
       " 'MIGR_ASYRESDA': <DataflowDefinition ESTAT:MIGR_ASYRESDA(1.0): Resettled persons by age, sex, citizenship and decision - annual data>,\n",
       " 'MIGR_ASYTPFA': <DataflowDefinition ESTAT:MIGR_ASYTPFA(1.0): Decisions granting temporary protection by citizenship, age and sex – annual data>,\n",
       " 'MIGR_ASYTPFA$DV_1381': <DataflowDefinition ESTAT:MIGR_ASYTPFA$DV_1381(1.0): Decisions granting temporary protection by citizenship, age and sex – annual data>,\n",
       " 'MIGR_ASYTPFM': <DataflowDefinition ESTAT:MIGR_ASYTPFM(1.0): Decisions granting temporary protection by citizenship, age and sex – monthly data>,\n",
       " 'MIGR_ASYTPFM$DV_1383': <DataflowDefinition ESTAT:MIGR_ASYTPFM$DV_1383(1.0): Decisions granting temporary protection by citizenship, age and sex – monthly data>,\n",
       " 'MIGR_ASYTPFPOP': <DataflowDefinition ESTAT:MIGR_ASYTPFPOP(1.0): Decisions granting temporary protection by citizenship - per thousand persons>,\n",
       " 'MIGR_ASYTPFQ': <DataflowDefinition ESTAT:MIGR_ASYTPFQ(1.0): Decisions granting temporary protection by citizenship, age and sex – quarterly data>,\n",
       " 'MIGR_ASYTPFQ$DV_1382': <DataflowDefinition ESTAT:MIGR_ASYTPFQ$DV_1382(1.0): Decisions granting temporary protection by citizenship, age and sex – quarterly data>,\n",
       " 'MIGR_ASYTPSM': <DataflowDefinition ESTAT:MIGR_ASYTPSM(1.0): Beneficiaries of temporary protection at the end of the month by citizenship, age and sex – monthly data>,\n",
       " 'MIGR_ASYTPSM$DV_1384': <DataflowDefinition ESTAT:MIGR_ASYTPSM$DV_1384(1.0): Beneficiaries of temporary protection at the end of the month by citizenship, age and sex – monthly data>,\n",
       " 'MIGR_ASYTPSPOP': <DataflowDefinition ESTAT:MIGR_ASYTPSPOP(1.0): Beneficiaries from temporary protection by citizenship - per thousand persons>,\n",
       " 'MIGR_ASYTPWQ': <DataflowDefinition ESTAT:MIGR_ASYTPWQ(1.0): Decisions withdrawing temporary protection by citizenship and reason – quarterly data>,\n",
       " 'MIGR_ASYUMACCM': <DataflowDefinition ESTAT:MIGR_ASYUMACCM(1.0): Unaccompanied minor asylum applicants having had their applications processed under the accelerated procedure, by age, sex and citizenship - monthly data>,\n",
       " 'MIGR_ASYUMACTA': <DataflowDefinition ESTAT:MIGR_ASYUMACTA(1.0): Unaccompanied minor asylum applicants by type of applicant, citizenship, age and sex - annual aggregated data>,\n",
       " 'MIGR_ASYUMACTM': <DataflowDefinition ESTAT:MIGR_ASYUMACTM(1.0): Unaccompanied minor asylum applicants by type of applicant, citizenship, age and sex - monthly data>,\n",
       " 'MIGR_ASYUMDCFA': <DataflowDefinition ESTAT:MIGR_ASYUMDCFA(1.0): First instance decisions on applications of unaccompanied minors by citizenship, age and sex - annual aggregated data>,\n",
       " 'MIGR_ASYUMDCFNA': <DataflowDefinition ESTAT:MIGR_ASYUMDCFNA(1.0): Final decisions in appeal or review on applications of unaccompanied minors by citizenship, age and sex - annual data>,\n",
       " 'MIGR_ASYUMDCFQ': <DataflowDefinition ESTAT:MIGR_ASYUMDCFQ(1.0): First instance decisions on applications of unaccompanied minors by citizenship, age and sex - quarterly data>,\n",
       " 'MIGR_ASYUMPCTM': <DataflowDefinition ESTAT:MIGR_ASYUMPCTM(1.0): Unaccompanied minors subject of asylum applications pending at the end of the month by citizenship, age and sex - monthly data>,\n",
       " 'MIGR_ASYUMRESA': <DataflowDefinition ESTAT:MIGR_ASYUMRESA(1.0): Resettled unaccompanied minors by age, sex and citizenship - annual data>,\n",
       " 'MIGR_ASYUMTPFA': <DataflowDefinition ESTAT:MIGR_ASYUMTPFA(1.0): Decisions granting temporary protection to unaccompanied minors by citizenship, age and sex – annual data>,\n",
       " 'MIGR_ASYUMTPFM': <DataflowDefinition ESTAT:MIGR_ASYUMTPFM(1.0): Decisions granting temporary protection to unaccompanied minors by citizenship, age and sex – monthly data>,\n",
       " 'MIGR_ASYUMTPFQ': <DataflowDefinition ESTAT:MIGR_ASYUMTPFQ(1.0): Decisions granting temporary protection to unaccompanied minors by citizenship, age and sex – quarterly data>,\n",
       " 'MIGR_ASYUMTPSM': <DataflowDefinition ESTAT:MIGR_ASYUMTPSM(1.0): Unaccompanied minors benefiting from temporary protection at the end of the month by citizenship, age and sex – monthly data>,\n",
       " 'MIGR_ASYUMTPWQ': <DataflowDefinition ESTAT:MIGR_ASYUMTPWQ(1.0): Decisions withdrawing temporary protection to unaccompanied minors by citizenship and reason – quarterly data>,\n",
       " 'MIGR_ASYUMWFNA': <DataflowDefinition ESTAT:MIGR_ASYUMWFNA(1.0): Decisions withdrawing status granted as final decision in appeal or review to unaccompanied minors by type of status withdrawn, citizenship and reason - annual data>,\n",
       " 'MIGR_ASYUMWIFA': <DataflowDefinition ESTAT:MIGR_ASYUMWIFA(1.0): Decisions withdrawing status granted at first instance decision to an unaccompanied minor by type of status withdrawn, citizenship and reason - annual aggregated data>,\n",
       " 'MIGR_ASYUMWIFQ': <DataflowDefinition ESTAT:MIGR_ASYUMWIFQ(1.0): Decisions withdrawing status granted at first instance decision to an unaccompanied minor by type of status withdrawn, citizenship and reason - quarterly data>,\n",
       " 'MIGR_ASYUMWITA': <DataflowDefinition ESTAT:MIGR_ASYUMWITA(1.0): Asylum applications of unaccompanied minors withdrawn by citizenship, age, sex and type of withdrawal - annual aggregated data>,\n",
       " 'MIGR_ASYUMWITM': <DataflowDefinition ESTAT:MIGR_ASYUMWITM(1.0): Asylum applications of unaccompanied minors withdrawn by citizenship, age, sex and type of withdrawal - monthly data>,\n",
       " 'MIGR_ASYUNAA': <DataflowDefinition ESTAT:MIGR_ASYUNAA(1.0): Asylum applicants considered to be unaccompanied minors by citizenship, age and sex - annual data>,\n",
       " 'MIGR_ASYWITFINA': <DataflowDefinition ESTAT:MIGR_ASYWITFINA(1.0): Decisions withdrawing status granted as final decision in appeal or review by type of status withdrawn - annual data>,\n",
       " 'MIGR_ASYWITFSTA': <DataflowDefinition ESTAT:MIGR_ASYWITFSTA(1.0): Decisions withdrawing status granted at first instance decision by type of status withdrawn, citizenship and reason - annual aggregated data>,\n",
       " 'MIGR_ASYWITFSTQ': <DataflowDefinition ESTAT:MIGR_ASYWITFSTQ(1.0): Decisions withdrawing status granted at first instance decision by type of status withdrawn, citizenship and reason- quarterly data>,\n",
       " 'MIGR_ASYWITHA': <DataflowDefinition ESTAT:MIGR_ASYWITHA(1.0): Asylum applications withdrawn by citizenship, age, sex and type of withdrawal - annual aggregated data>,\n",
       " 'MIGR_ASYWITHA$DV_1021': <DataflowDefinition ESTAT:MIGR_ASYWITHA$DV_1021(1.0): Asylum applications withdrawn by citizenship, age, sex and type of withdrawal - annual aggregated data>,\n",
       " 'MIGR_ASYWITHM': <DataflowDefinition ESTAT:MIGR_ASYWITHM(1.0): Asylum applications withdrawn by citizenship, age, sex and type of withdrawal - monthly data>,\n",
       " 'MIGR_ASYWITHM$DV_941': <DataflowDefinition ESTAT:MIGR_ASYWITHM$DV_941(1.0): Asylum applications withdrawn by citizenship, age, sex and type of withdrawal - monthly data>,\n",
       " 'MIGR_DUBDEDACI': <DataflowDefinition ESTAT:MIGR_DUBDEDACI(1.0): Decisions on incoming 'Dublin' requests based on EURODAC by submitting country (PARTNER), type of request, sex and type of applicant>,\n",
       " 'MIGR_DUBDEDACO': <DataflowDefinition ESTAT:MIGR_DUBDEDACO(1.0): Decisions on outgoing 'Dublin' requests based on EURODAC by receiving country (PARTNER), type of request, sex and type of applicant>,\n",
       " 'MIGR_DUBDI': <DataflowDefinition ESTAT:MIGR_DUBDI(1.0): Decisions on incoming 'Dublin' requests by submitting country (PARTNER), type of decision, type of request, legal provision, sex and type of applicant>,\n",
       " 'MIGR_DUBDO': <DataflowDefinition ESTAT:MIGR_DUBDO(1.0): Decisions on outgoing 'Dublin' requests by receiving country (PARTNER), type of decision, type of request, legal provision, sex and type of applicant>,\n",
       " 'MIGR_DUBDUNI': <DataflowDefinition ESTAT:MIGR_DUBDUNI(1.0): Unilateral 'Dublin' decisions by partner country, type of decision, sex and type of applicant>,\n",
       " 'MIGR_DUBREDACI': <DataflowDefinition ESTAT:MIGR_DUBREDACI(1.0): Incoming 'Dublin' requests based on EURODAC by submitting country (PARTNER), type of request, legal provision, sex and type of applicant>,\n",
       " 'MIGR_DUBREDACO': <DataflowDefinition ESTAT:MIGR_DUBREDACO(1.0): Outgoing 'Dublin' requests based on EURODAC by receiving country (PARTNER), type of request, legal provision, sex and type of applicant>,\n",
       " 'MIGR_DUBRESI': <DataflowDefinition ESTAT:MIGR_DUBRESI(1.0): Incoming responses to 'Dublin' requests for information by submitting country (PARTNER), legal provision, duration of response, sex and type of applicant>,\n",
       " 'MIGR_DUBRESO': <DataflowDefinition ESTAT:MIGR_DUBRESO(1.0): Outgoing responses to 'Dublin' requests for information by receiving country (PARTNER), legal provision, duration of response, sex and type of applicant>,\n",
       " 'MIGR_DUBRI': <DataflowDefinition ESTAT:MIGR_DUBRI(1.0): Incoming 'Dublin' requests by submitting country (PARTNER), type of request, legal provision, sex and type of applicant>,\n",
       " 'MIGR_DUBRINFI': <DataflowDefinition ESTAT:MIGR_DUBRINFI(1.0): Incoming 'Dublin' requests for information by submitting country (PARTNER), legal provision, sex and type of applicant>,\n",
       " 'MIGR_DUBRINFO': <DataflowDefinition ESTAT:MIGR_DUBRINFO(1.0): Outgoing 'Dublin' requests for information by receiving country (PARTNER), legal provision, sex and type of applicant>,\n",
       " 'MIGR_DUBRO': <DataflowDefinition ESTAT:MIGR_DUBRO(1.0): Outgoing 'Dublin' requests by receiving country (PARTNER), type of request, legal provision, sex and type of applicant>,\n",
       " 'MIGR_DUBRPENI': <DataflowDefinition ESTAT:MIGR_DUBRPENI(1.0): Pending 'Dublin' incoming requests by submitting country (PARTNER), type of request, sex and type of applicant>,\n",
       " 'MIGR_DUBRPENO': <DataflowDefinition ESTAT:MIGR_DUBRPENO(1.0): Pending 'Dublin' outgoing requests by receiving country (PARTNER), type of request, sex and type of applicant>,\n",
       " 'MIGR_DUBTI': <DataflowDefinition ESTAT:MIGR_DUBTI(1.0): Incoming 'Dublin' transfers by submitting country (PARTNER), legal provision, duration of transfer, sex and type of applicant>,\n",
       " 'MIGR_DUBTO': <DataflowDefinition ESTAT:MIGR_DUBTO(1.0): Outgoing 'Dublin' transfers by receiving country (PARTNER), legal provision, duration of transfer, sex and type of applicant>,\n",
       " 'MIGR_DUBTPENI': <DataflowDefinition ESTAT:MIGR_DUBTPENI(1.0): Pending incoming 'Dublin' transfers by submitting country (PARTNER), sex and type of applicant>,\n",
       " 'MIGR_DUBTPENO': <DataflowDefinition ESTAT:MIGR_DUBTPENO(1.0): Pending outgoing 'Dublin' transfers by receiving country (PARTNER), sex and type of applicant>,\n",
       " 'MIGR_EILPOP': <DataflowDefinition ESTAT:MIGR_EILPOP(1.0): Persons subject to immigration law enforcement - per thousand persons>,\n",
       " 'MIGR_EILRETPC': <DataflowDefinition ESTAT:MIGR_EILRETPC(1.0): Returns by type of return - % of total returns>,\n",
       " 'MIGR_EIORD': <DataflowDefinition ESTAT:MIGR_EIORD(1.0): Third country nationals ordered to leave - annual data (rounded)>,\n",
       " 'MIGR_EIORD$DV_1261': <DataflowDefinition ESTAT:MIGR_EIORD$DV_1261(1.0): Third country nationals ordered to leave - annual data (rounded)>,\n",
       " 'MIGR_EIORD1': <DataflowDefinition ESTAT:MIGR_EIORD1(1.0): Third country nationals ordered to leave by citizenship, age and sex - quarterly data (rounded)>,\n",
       " 'MIGR_EIORD2': <DataflowDefinition ESTAT:MIGR_EIORD2(1.0): Third-country unaccompanied minors ordered to leave, by citizenship, age and sex of the minor – quarterly data (rounded)>,\n",
       " 'MIGR_EIPRE': <DataflowDefinition ESTAT:MIGR_EIPRE(1.0): Third country nationals found to be illegally present - annual data (rounded)>,\n",
       " 'MIGR_EIPRE$DV_1221': <DataflowDefinition ESTAT:MIGR_EIPRE$DV_1221(1.0): Third country nationals found to be illegally present - annual data (rounded)>,\n",
       " 'MIGR_EIRFS': <DataflowDefinition ESTAT:MIGR_EIRFS(1.0): Third country nationals refused entry at the external borders - annual data (rounded)>,\n",
       " 'MIGR_EIRTN': <DataflowDefinition ESTAT:MIGR_EIRTN(1.0): Third country nationals returned following an order to leave - annual data (rounded)>,\n",
       " 'MIGR_EIRTN$DV_1241': <DataflowDefinition ESTAT:MIGR_EIRTN$DV_1241(1.0): Third country nationals returned following an order to leave - annual data (rounded)>,\n",
       " 'MIGR_EIRTN1': <DataflowDefinition ESTAT:MIGR_EIRTN1(1.0): Third-country nationals returned following an order to leave, by type of return, citizenship, country of destination, age and sex – quarterly data>,\n",
       " 'MIGR_EIRTN2': <DataflowDefinition ESTAT:MIGR_EIRTN2(1.0): Third-country unaccompanied minors returned following an order to leave, by type of return, citizenship, country of destination, age and sex of the minor – quarterly data (rounded)>,\n",
       " 'MIGR_EIRT_AGR': <DataflowDefinition ESTAT:MIGR_EIRT_AGR(1.0): Third-country nationals who have left the territory to a third country by type of agreement procedure and citizenship>,\n",
       " 'MIGR_EIRT_ASS': <DataflowDefinition ESTAT:MIGR_EIRT_ASS(1.0): Third-country nationals who have left the territory by type of assistance received and citizenship>,\n",
       " 'MIGR_EIRT_DES': <DataflowDefinition ESTAT:MIGR_EIRT_DES(1.0): Third-country nationals who have left the territory to a third country by destination country and citizenship>,\n",
       " 'MIGR_EIRT_VOL': <DataflowDefinition ESTAT:MIGR_EIRT_VOL(1.0): Third-country nationals who have left the territory by type of return and citizenship>,\n",
       " 'MIGR_EMI1CTZ': <DataflowDefinition ESTAT:MIGR_EMI1CTZ(1.0): Emigration by age group, sex and citizenship>,\n",
       " 'MIGR_EMI2': <DataflowDefinition ESTAT:MIGR_EMI2(1.0): Emigration by age and sex>,\n",
       " 'MIGR_EMI3NXT': <DataflowDefinition ESTAT:MIGR_EMI3NXT(1.0): Emigration by age group, sex and country of next usual residence>,\n",
       " 'MIGR_EMI4CTB': <DataflowDefinition ESTAT:MIGR_EMI4CTB(1.0): Emigration by age group, sex and country of birth>,\n",
       " 'MIGR_EMI5NXT': <DataflowDefinition ESTAT:MIGR_EMI5NXT(1.0): Emigration by group of country of next usual residence>,\n",
       " 'MIGR_EMICTZNXT': <DataflowDefinition ESTAT:MIGR_EMICTZNXT(1.0): Emigration by age group, sex, group of citizenship and group of country of next residence - ad hoc data collection (2015-2020)>,\n",
       " 'MIGR_IMM10CTB': <DataflowDefinition ESTAT:MIGR_IMM10CTB(1.0): Immigration by age group, sex and level of human development of the country of birth>,\n",
       " 'MIGR_IMM11PRV': <DataflowDefinition ESTAT:MIGR_IMM11PRV(1.0): Immigration by age group, sex and level of human development of the country of previous residence>,\n",
       " 'MIGR_IMM12PRV': <DataflowDefinition ESTAT:MIGR_IMM12PRV(1.0): Immigration by broad group of country of previous residence>,\n",
       " 'MIGR_IMM1CTZ': <DataflowDefinition ESTAT:MIGR_IMM1CTZ(1.0): Immigration by age group, sex and citizenship>,\n",
       " 'MIGR_IMM2CTZ': <DataflowDefinition ESTAT:MIGR_IMM2CTZ(1.0): Immigration by age, sex and group of citizenship>,\n",
       " 'MIGR_IMM3CTB': <DataflowDefinition ESTAT:MIGR_IMM3CTB(1.0): Immigration by age group, sex and country of birth>,\n",
       " 'MIGR_IMM4CTB': <DataflowDefinition ESTAT:MIGR_IMM4CTB(1.0): Immigration by age, sex and group of country of birth>,\n",
       " 'MIGR_IMM5PRV': <DataflowDefinition ESTAT:MIGR_IMM5PRV(1.0): Immigration by age group, sex and country of previous residence>,\n",
       " 'MIGR_IMM6CTZ': <DataflowDefinition ESTAT:MIGR_IMM6CTZ(1.0): Immigration by sex, citizenship and group of country of birth>,\n",
       " 'MIGR_IMM7CTB': <DataflowDefinition ESTAT:MIGR_IMM7CTB(1.0): Immigration by sex, country of birth and group of citizenship>,\n",
       " 'MIGR_IMM8': <DataflowDefinition ESTAT:MIGR_IMM8(1.0): Immigration by age and sex>,\n",
       " 'MIGR_IMM9CTZ': <DataflowDefinition ESTAT:MIGR_IMM9CTZ(1.0): Immigration by age group, sex and level of human development of the country of citizenship>,\n",
       " 'MIGR_IMMCTZPRV': <DataflowDefinition ESTAT:MIGR_IMMCTZPRV(1.0): Immigration by age group, sex, group of citizenship and group of country of previous residence - ad hoc data collection (2015-2020)>,\n",
       " 'MIGR_LCT': <DataflowDefinition ESTAT:MIGR_LCT(1.0): Loss of citizenship by sex and new citizenship>,\n",
       " 'MIGR_NETMIGR': <DataflowDefinition ESTAT:MIGR_NETMIGR(1.0): Net migration by age and sex>,\n",
       " 'MIGR_POP1CTZ': <DataflowDefinition ESTAT:MIGR_POP1CTZ(1.0): Population on 1 January by age group, sex and citizenship>,\n",
       " 'MIGR_POP1CTZ$DV_1764': <DataflowDefinition ESTAT:MIGR_POP1CTZ$DV_1764(1.0): Population on 1 January by age group, sex and citizenship>,\n",
       " 'MIGR_POP2CTZ': <DataflowDefinition ESTAT:MIGR_POP2CTZ(1.0): Population on 1 January by age, sex and broad group of citizenship>,\n",
       " 'MIGR_POP3CTB': <DataflowDefinition ESTAT:MIGR_POP3CTB(1.0): Population on 1 January by age group, sex and country of birth>,\n",
       " 'MIGR_POP4CTB': <DataflowDefinition ESTAT:MIGR_POP4CTB(1.0): Population on 1 January by age, sex and group of country of birth>,\n",
       " 'MIGR_POP5CTZ': <DataflowDefinition ESTAT:MIGR_POP5CTZ(1.0): Population on 1 January by sex, citizenship and group of country of birth>,\n",
       " 'MIGR_POP6CTB': <DataflowDefinition ESTAT:MIGR_POP6CTB(1.0): Population on 1 January by sex, country of birth and group of citizenship>,\n",
       " 'MIGR_POP7CTZ': <DataflowDefinition ESTAT:MIGR_POP7CTZ(1.0): Population on 1 January by age group, sex and level of human development of the country of citizenship>,\n",
       " 'MIGR_POP8CTB': <DataflowDefinition ESTAT:MIGR_POP8CTB(1.0): Population on 1 January by age group, sex and level of human development of the country of birth>,\n",
       " 'MIGR_POP9CTZ': <DataflowDefinition ESTAT:MIGR_POP9CTZ(1.0): EU and EFTA citizens who are usual residents in another EU/EFTA country as of 1 January>,\n",
       " 'MIGR_RESBC1': <DataflowDefinition ESTAT:MIGR_RESBC1(1.0): EU Blue Cards by type of decision, occupation and citizenship>,\n",
       " 'MIGR_RESBC2': <DataflowDefinition ESTAT:MIGR_RESBC2(1.0): Admitted family members of EU Blue Cards holders by type of decision and citizenship>,\n",
       " 'MIGR_RESBC3': <DataflowDefinition ESTAT:MIGR_RESBC3(1.0): EU Blue Cards holders and family members by Member State of previous residence>,\n",
       " 'MIGR_RESCHANGE': <DataflowDefinition ESTAT:MIGR_RESCHANGE(1.0): Change of immigration status permits by reason and citizenship>,\n",
       " 'MIGR_RESCHST': <DataflowDefinition ESTAT:MIGR_RESCHST(1.0): Change of immigration status permits by age, sex and citizenship>,\n",
       " 'MIGR_RESCHST$DV_1285': <DataflowDefinition ESTAT:MIGR_RESCHST$DV_1285(1.0): Change of immigration status permits by age, sex and citizenship>,\n",
       " 'MIGR_RESEDU': <DataflowDefinition ESTAT:MIGR_RESEDU(1.0): First permits issued for education reasons by reason, length of validity and citizenship>,\n",
       " 'MIGR_RESFAM': <DataflowDefinition ESTAT:MIGR_RESFAM(1.0): First permits issued for family reasons by reason, length of validity and citizenship>,\n",
       " 'MIGR_RESFAS': <DataflowDefinition ESTAT:MIGR_RESFAS(1.0): First permits by reason, age, sex and citizenship>,\n",
       " 'MIGR_RESFAS$DV_1281': <DataflowDefinition ESTAT:MIGR_RESFAS$DV_1281(1.0): First permits by reason, age, sex and citizenship>,\n",
       " 'MIGR_RESFIRST': <DataflowDefinition ESTAT:MIGR_RESFIRST(1.0): First permits by reason, length of validity and citizenship>,\n",
       " 'MIGR_RESFPC': <DataflowDefinition ESTAT:MIGR_RESFPC(1.0): First residence permits by reasons - % of total first residence permits>,\n",
       " 'MIGR_RESFRPS1': <DataflowDefinition ESTAT:MIGR_RESFRPS1(1.0): First permits issued for family reunification with a beneficiary of protection status>,\n",
       " 'MIGR_RESFRPS2': <DataflowDefinition ESTAT:MIGR_RESFRPS2(1.0): Permits valid at the end of the year for family reunification with a beneficiary of protection status>,\n",
       " 'MIGR_RESICT1_1': <DataflowDefinition ESTAT:MIGR_RESICT1_1(1.0): Intra-corporate transferee permits issued, renewed and withdrawn by type of permit, length of validity and citizenship>,\n",
       " 'MIGR_RESICT1_2': <DataflowDefinition ESTAT:MIGR_RESICT1_2(1.0): Intra-corporate transferee permits issued by type of permit, economic sector and citizenship>,\n",
       " 'MIGR_RESICT1_3': <DataflowDefinition ESTAT:MIGR_RESICT1_3(1.0): Intra-corporate transferee permits issued by type of permit, length of validity, transferee position and citizenship>,\n",
       " 'MIGR_RESICT2_1': <DataflowDefinition ESTAT:MIGR_RESICT2_1(1.0): Intra-corporate notifications received by length of validity and citizenship>,\n",
       " 'MIGR_RESICT2_2': <DataflowDefinition ESTAT:MIGR_RESICT2_2(1.0): Intra-corporate notifications received by economic sector and citizenship>,\n",
       " 'MIGR_RESLAS': <DataflowDefinition ESTAT:MIGR_RESLAS(1.0): Long-term residents by age, sex and citizenship on 31 December of each year>,\n",
       " 'MIGR_RESLAS$DV_1283': <DataflowDefinition ESTAT:MIGR_RESLAS$DV_1283(1.0): Long-term residents by age, sex and citizenship on 31 December of each year>,\n",
       " 'MIGR_RESLONG': <DataflowDefinition ESTAT:MIGR_RESLONG(1.0): Long-term residents by citizenship on 31 December of each year>,\n",
       " 'MIGR_RESLTR': <DataflowDefinition ESTAT:MIGR_RESLTR(1.0): Long-term residence permits issued during the year>,\n",
       " 'MIGR_RESLTRA': <DataflowDefinition ESTAT:MIGR_RESLTRA(1.0): Long-term residence permits issued during the year by age, sex and citizenship>,\n",
       " 'MIGR_RESLTRA$DV_1284': <DataflowDefinition ESTAT:MIGR_RESLTRA$DV_1284(1.0): Long-term residence permits issued during the year by age, sex and citizenship>,\n",
       " 'MIGR_RESOCC': <DataflowDefinition ESTAT:MIGR_RESOCC(1.0): First permits issued for remunerated activities by reason, length of validity and citizenship>,\n",
       " 'MIGR_RESOTH': <DataflowDefinition ESTAT:MIGR_RESOTH(1.0): First permits issued for other reasons by reason, length of validity and citizenship>,\n",
       " 'MIGR_RESPOP': <DataflowDefinition ESTAT:MIGR_RESPOP(1.0): First residence permits - per thousand persons>,\n",
       " 'MIGR_RESSHARE': <DataflowDefinition ESTAT:MIGR_RESSHARE(1.0): Long-term residents among all non-EU citizens holding residence permits by citizenship on 31 December (%)>,\n",
       " 'MIGR_RESSING': <DataflowDefinition ESTAT:MIGR_RESSING(1.0): Single Permits issued by type of decision, length of validity>,\n",
       " 'MIGR_RESSPC': <DataflowDefinition ESTAT:MIGR_RESSPC(1.0): Valid permits by reasons - % of total valid permits>,\n",
       " 'MIGR_RESSRATH': <DataflowDefinition ESTAT:MIGR_RESSRATH(1.0): Authorisations for study and research by reason, type of decision, citizenship and length of validity>,\n",
       " 'MIGR_RESSRLTM': <DataflowDefinition ESTAT:MIGR_RESSRLTM(1.0): Authorisations for long-term mobility of researchers by reason, type of decision, citizenship and length of validity>,\n",
       " 'MIGR_RESSRNTF': <DataflowDefinition ESTAT:MIGR_RESSRNTF(1.0): Notifications for research and study by reason, decision, citizenship and length of validity>,\n",
       " 'MIGR_RESSW1_1': <DataflowDefinition ESTAT:MIGR_RESSW1_1(1.0): Authorisations for the purpose of seasonal work by status, length of validity, economic sector and citizenship>,\n",
       " 'MIGR_RESSW2': <DataflowDefinition ESTAT:MIGR_RESSW2(1.0): Authorisations issued for the purpose of seasonal work by economic sector, sex and citizenship>,\n",
       " 'MIGR_RESVALID': <DataflowDefinition ESTAT:MIGR_RESVALID(1.0): All valid permits by reason, length of validity and citizenship on 31 December of each year>,\n",
       " 'MIGR_RESVAS': <DataflowDefinition ESTAT:MIGR_RESVAS(1.0): All valid permits by age, sex and citizenship on 31 December of each year>,\n",
       " 'MIGR_RESVAS$DV_1282': <DataflowDefinition ESTAT:MIGR_RESVAS$DV_1282(1.0): All valid permits by age, sex and citizenship on 31 December of each year>,\n",
       " 'MIPS_SA': <DataflowDefinition ESTAT:MIPS_SA(1.0): Macroeconomic imbalance procedure - Statistical annex indicators>,\n",
       " 'NAIDA_10_A10': <DataflowDefinition ESTAT:NAIDA_10_A10(1.0): Gross value added by A*10 industry- international data cooperation annual data>,\n",
       " 'NAIDA_10_GDP': <DataflowDefinition ESTAT:NAIDA_10_GDP(1.0): GDP and main aggregates- international data cooperation annual data>,\n",
       " 'NAIDA_10_PE': <DataflowDefinition ESTAT:NAIDA_10_PE(1.0): Employment and population- international data cooperation annual data>,\n",
       " 'NAIDQ_10_A10': <DataflowDefinition ESTAT:NAIDQ_10_A10(1.0): Gross value added by A*10 industry- international data cooperation quarterly data>,\n",
       " 'NAIDQ_10_GDP': <DataflowDefinition ESTAT:NAIDQ_10_GDP(1.0): GDP and main aggregates - international data cooperation quarterly data>,\n",
       " 'NAIDQ_10_PE': <DataflowDefinition ESTAT:NAIDQ_10_PE(1.0): Employment and population - international data cooperation quarterly data>,\n",
       " 'NAIDSA_10_F_BS': <DataflowDefinition ESTAT:NAIDSA_10_F_BS(1.0): Financial balance sheets – international data cooperation>,\n",
       " 'NAIDSA_10_F_TR': <DataflowDefinition ESTAT:NAIDSA_10_F_TR(1.0): Financial transactions – international data cooperation>,\n",
       " 'NAIDSA_10_NF_TR': <DataflowDefinition ESTAT:NAIDSA_10_NF_TR(1.0): Non-financial transactions - selected international annual data>,\n",
       " 'NAIDSQ_10_F_BS': <DataflowDefinition ESTAT:NAIDSQ_10_F_BS(1.0): Financial balance sheets – international data cooperation - quarterly data>,\n",
       " 'NAIDSQ_10_F_TR': <DataflowDefinition ESTAT:NAIDSQ_10_F_TR(1.0): Financial transactions – international data cooperation - quarterly data>,\n",
       " 'NAIDSQ_10_NF_TR': <DataflowDefinition ESTAT:NAIDSQ_10_NF_TR(1.0): Non-financial transactions - selected international quarterly data>,\n",
       " 'NAIO_10_COIN': <DataflowDefinition ESTAT:NAIO_10_COIN(1.0): Input coefficients>,\n",
       " 'NAIO_10_COOUT': <DataflowDefinition ESTAT:NAIO_10_COOUT(1.0): Output multipliers>,\n",
       " 'NAIO_10_CP15': <DataflowDefinition ESTAT:NAIO_10_CP15(1.0): Supply table at basic prices incl. transformation into purchasers' prices>,\n",
       " 'NAIO_10_CP15A10': <DataflowDefinition ESTAT:NAIO_10_CP15A10(1.0): Supply table at basic prices incl. transformation into purchasers' prices - A*10 industry breakdowns>,\n",
       " 'NAIO_10_CP16': <DataflowDefinition ESTAT:NAIO_10_CP16(1.0): Use table at purchasers' prices>,\n",
       " 'NAIO_10_CP1610': <DataflowDefinition ESTAT:NAIO_10_CP1610(1.0): Use table at basic prices>,\n",
       " 'NAIO_10_CP1610A10': <DataflowDefinition ESTAT:NAIO_10_CP1610A10(1.0): Use table at basic prices - A*10 industry breakdowns>,\n",
       " 'NAIO_10_CP1620': <DataflowDefinition ESTAT:NAIO_10_CP1620(1.0): Table of trade and transport margins>,\n",
       " 'NAIO_10_CP1630': <DataflowDefinition ESTAT:NAIO_10_CP1630(1.0): Table of taxes less subsidies on product>,\n",
       " 'NAIO_10_CP1700': <DataflowDefinition ESTAT:NAIO_10_CP1700(1.0): Symmetric input-output table at basic prices (product by product)>,\n",
       " 'NAIO_10_CP1750': <DataflowDefinition ESTAT:NAIO_10_CP1750(1.0): Symmetric input-output table at basic prices (industry by industry)>,\n",
       " 'NAIO_10_FAEX': <DataflowDefinition ESTAT:NAIO_10_FAEX(1.0): Employment generated by EU exports (FIGARO application)>,\n",
       " 'NAIO_10_FAVX': <DataflowDefinition ESTAT:NAIO_10_FAVX(1.0): Value-added generated by EU exports (FIGARO application)>,\n",
       " 'NAIO_10_FCP_II1': <DataflowDefinition ESTAT:NAIO_10_FCP_II1(1.0): EU inter-country input-output table at basic prices, industry by industry (2010-2014)>,\n",
       " 'NAIO_10_FCP_II2': <DataflowDefinition ESTAT:NAIO_10_FCP_II2(1.0): EU inter-country input-output table at basic prices, industry by industry (2015-2019)>,\n",
       " 'NAIO_10_FCP_II3': <DataflowDefinition ESTAT:NAIO_10_FCP_II3(1.0): EU inter-country input-output table at basic prices, industry by industry (2020 and onwards)>,\n",
       " 'NAIO_10_FCP_IP1': <DataflowDefinition ESTAT:NAIO_10_FCP_IP1(1.0): EU inter-country input-output table at basic prices, product by product (2010-2014)>,\n",
       " 'NAIO_10_FCP_IP2': <DataflowDefinition ESTAT:NAIO_10_FCP_IP2(1.0): EU inter-country input-output table at basic prices, product by product (2015-2019)>,\n",
       " 'NAIO_10_FCP_IP3': <DataflowDefinition ESTAT:NAIO_10_FCP_IP3(1.0): EU inter-country input-output table at basic prices, product by product (2020 and onwards)>,\n",
       " 'NAIO_10_FCP_S1': <DataflowDefinition ESTAT:NAIO_10_FCP_S1(1.0): EU inter-country supply table at basic prices (2010-2014)>,\n",
       " 'NAIO_10_FCP_S2': <DataflowDefinition ESTAT:NAIO_10_FCP_S2(1.0): EU inter-country supply table at basic prices (2015-2019)>,\n",
       " 'NAIO_10_FCP_S3': <DataflowDefinition ESTAT:NAIO_10_FCP_S3(1.0): EU inter-country supply table at basic prices (2020 and onwards)>,\n",
       " 'NAIO_10_FCP_U1': <DataflowDefinition ESTAT:NAIO_10_FCP_U1(1.0): EU inter-country use table at basic prices (2010-2014)>,\n",
       " 'NAIO_10_FCP_U2': <DataflowDefinition ESTAT:NAIO_10_FCP_U2(1.0): EU inter-country use table at basic prices (2015-2019)>,\n",
       " 'NAIO_10_FCP_U3': <DataflowDefinition ESTAT:NAIO_10_FCP_U3(1.0): EU inter-country use table at basic prices (2020 and onwards)>,\n",
       " 'NAIO_10_PYP15': <DataflowDefinition ESTAT:NAIO_10_PYP15(1.0): Supply table at basic prices incl. transformation into purchasers' prices (previous years prices)>,\n",
       " 'NAIO_10_PYP16': <DataflowDefinition ESTAT:NAIO_10_PYP16(1.0): Use table at purchasers' prices (previous years prices)>,\n",
       " 'NAIO_10_PYP1610': <DataflowDefinition ESTAT:NAIO_10_PYP1610(1.0): Use table at basic prices (previous years prices)>,\n",
       " 'NAIO_10_PYP1620': <DataflowDefinition ESTAT:NAIO_10_PYP1620(1.0): Table of trade and transport margins (previous years prices)>,\n",
       " 'NAIO_10_PYP1630': <DataflowDefinition ESTAT:NAIO_10_PYP1630(1.0): Table of taxes less subsidies on products (previous years prices)>,\n",
       " 'NAIO_10_PYP1700': <DataflowDefinition ESTAT:NAIO_10_PYP1700(1.0): Symmetric input-output table at basic prices (product by product) (previous years prices)>,\n",
       " 'NAIO_10_PYP1750': <DataflowDefinition ESTAT:NAIO_10_PYP1750(1.0): Symmetric input-output table at basic prices (industry by industry) (previous years prices)>,\n",
       " 'NAMA_10R_2COE': <DataflowDefinition ESTAT:NAMA_10R_2COE(1.0): Compensation of employees by NUTS 2 regions>,\n",
       " 'NAMA_10R_2EMHRW': <DataflowDefinition ESTAT:NAMA_10R_2EMHRW(1.0): Employment (thousand hours worked) by NUTS 2 regions>,\n",
       " 'NAMA_10R_2GDP': <DataflowDefinition ESTAT:NAMA_10R_2GDP(1.0): Gross domestic product (GDP) at current market prices by NUTS 2 regions>,\n",
       " 'NAMA_10R_2GFCF': <DataflowDefinition ESTAT:NAMA_10R_2GFCF(1.0): Gross fixed capital formation by NUTS 2 regions>,\n",
       " 'NAMA_10R_2GVAGR': <DataflowDefinition ESTAT:NAMA_10R_2GVAGR(1.0): Gross domestic product (GDP) and Gross value added (GVA) in volume by NUTS 2 regions>,\n",
       " 'NAMA_10R_2HHINC': <DataflowDefinition ESTAT:NAMA_10R_2HHINC(1.0): Income of households by NUTS 2 regions>,\n",
       " 'NAMA_10R_2LP10': <DataflowDefinition ESTAT:NAMA_10R_2LP10(1.0): Compensation per employee and hours worked per employed person by NUTS 2 regions and by industry>,\n",
       " 'NAMA_10R_2NLP': <DataflowDefinition ESTAT:NAMA_10R_2NLP(1.0): Nominal Labour productivity by NUTS 2 regions>,\n",
       " 'NAMA_10R_2RLP': <DataflowDefinition ESTAT:NAMA_10R_2RLP(1.0): Real Labour productivity by NUTS 2 regions>,\n",
       " 'NAMA_10R_3EMPERS': <DataflowDefinition ESTAT:NAMA_10R_3EMPERS(1.0): Employment (thousand persons) by NUTS 3 regions>,\n",
       " 'NAMA_10R_3EMPERS$DV_1564': <DataflowDefinition ESTAT:NAMA_10R_3EMPERS$DV_1564(1.0): Employment (thousand persons) by NUTS 3 regions>,\n",
       " 'NAMA_10R_3GDP': <DataflowDefinition ESTAT:NAMA_10R_3GDP(1.0): Gross domestic product (GDP) at current market prices by NUTS 3 regions>,\n",
       " 'NAMA_10R_3GDP$DV_1562': <DataflowDefinition ESTAT:NAMA_10R_3GDP$DV_1562(1.0): Gross domestic product (GDP) at current market prices by NUTS 3 regions>,\n",
       " 'NAMA_10R_3GVA': <DataflowDefinition ESTAT:NAMA_10R_3GVA(1.0): Gross value added at basic prices by NUTS 3 regions>,\n",
       " 'NAMA_10R_3GVA$DV_1563': <DataflowDefinition ESTAT:NAMA_10R_3GVA$DV_1563(1.0): Gross value added at basic prices by NUTS 3 regions>,\n",
       " 'NAMA_10R_3NLP': <DataflowDefinition ESTAT:NAMA_10R_3NLP(1.0): Nominal Labour productivity by NUTS 3 regions>,\n",
       " 'NAMA_10R_3POPGDP': <DataflowDefinition ESTAT:NAMA_10R_3POPGDP(1.0): Average annual population to calculate regional GDP data (thousand persons) by NUTS 3 regions>,\n",
       " 'NAMA_10_A10': <DataflowDefinition ESTAT:NAMA_10_A10(1.0): Gross value added and income by A*10 industry breakdowns>,\n",
       " 'NAMA_10_A10_E': <DataflowDefinition ESTAT:NAMA_10_A10_E(1.0): Employment by A*10 industry breakdowns>,\n",
       " 'NAMA_10_A64': <DataflowDefinition ESTAT:NAMA_10_A64(1.0): National accounts aggregates by industry (up to NACE A*64)>,\n",
       " 'NAMA_10_A64_E': <DataflowDefinition ESTAT:NAMA_10_A64_E(1.0): National accounts employment data by industry (up to NACE A*64)>,\n",
       " 'NAMA_10_A64_P5': <DataflowDefinition ESTAT:NAMA_10_A64_P5(1.0): Gross capital formation by industry (up to NACE A*64)>,\n",
       " 'NAMA_10_AN6': <DataflowDefinition ESTAT:NAMA_10_AN6(1.0): Gross fixed capital formation by AN_F6 asset type>,\n",
       " 'NAMA_10_CO3_P3': <DataflowDefinition ESTAT:NAMA_10_CO3_P3(1.0): Final consumption expenditure of households by consumption purpose (COICOP 3 digit)>,\n",
       " 'NAMA_10_CO3_P3$DV_1002': <DataflowDefinition ESTAT:NAMA_10_CO3_P3$DV_1002(1.0): Final consumption expenditure of households by consumption purpose (COICOP 3 digit)>,\n",
       " 'NAMA_10_CP_A21': <DataflowDefinition ESTAT:NAMA_10_CP_A21(1.0): Capital stock based productivity indicators at industry level>,\n",
       " 'NAMA_10_EXI': <DataflowDefinition ESTAT:NAMA_10_EXI(1.0): Exports and imports by Member States of the EU/third countries>,\n",
       " 'NAMA_10_FCS': <DataflowDefinition ESTAT:NAMA_10_FCS(1.0): Final consumption aggregates by durability>,\n",
       " 'NAMA_10_FTE': <DataflowDefinition ESTAT:NAMA_10_FTE(1.0): Average full time adjusted salary per employee>,\n",
       " 'NAMA_10_GDP': <DataflowDefinition ESTAT:NAMA_10_GDP(1.0): GDP and main components (output, expenditure and income)>,\n",
       " 'NAMA_10_LP_A21': <DataflowDefinition ESTAT:NAMA_10_LP_A21(1.0): Labour productivity and unit labour costs at industry level>,\n",
       " 'NAMA_10_LP_ULC': <DataflowDefinition ESTAT:NAMA_10_LP_ULC(1.0): Labour productivity and unit labour costs>,\n",
       " 'NAMA_10_NFA_BS': <DataflowDefinition ESTAT:NAMA_10_NFA_BS(1.0): Balance sheets for non-financial assets>,\n",
       " 'NAMA_10_NFA_FL': <DataflowDefinition ESTAT:NAMA_10_NFA_FL(1.0): Cross-classification of gross fixed capital formation by industry and by asset (flows)>,\n",
       " 'NAMA_10_NFA_ST': <DataflowDefinition ESTAT:NAMA_10_NFA_ST(1.0): Cross-classification of fixed assets by industry and by asset (stocks)>,\n",
       " 'NAMA_10_NFA_ST$DV_647': <DataflowDefinition ESTAT:NAMA_10_NFA_ST$DV_647(1.0): Cross-classification of fixed assets by industry and by asset (stocks)>,\n",
       " 'NAMA_10_PC': <DataflowDefinition ESTAT:NAMA_10_PC(1.0): Main GDP aggregates per capita>,\n",
       " 'NAMA_10_PC$DV_648': <DataflowDefinition ESTAT:NAMA_10_PC$DV_648(1.0): Main GDP aggregates per capita>,\n",
       " 'NAMA_10_PE': <DataflowDefinition ESTAT:NAMA_10_PE(1.0): Population and employment>,\n",
       " 'NAMA_10_PP': <DataflowDefinition ESTAT:NAMA_10_PP(1.0): GNI (gross national income) per capita in PPS>,\n",
       " 'NAMQ_10_A10': <DataflowDefinition ESTAT:NAMQ_10_A10(1.0): Gross value added and income A*10 industry breakdowns>,\n",
       " 'NAMQ_10_A10_E': <DataflowDefinition ESTAT:NAMQ_10_A10_E(1.0): Employment A*10 industry breakdowns>,\n",
       " 'NAMQ_10_AN6': <DataflowDefinition ESTAT:NAMQ_10_AN6(1.0): Gross fixed capital formation with AN_F6 asset breakdowns>,\n",
       " 'NAMQ_10_EXI': <DataflowDefinition ESTAT:NAMQ_10_EXI(1.0): Exports and imports by Member States of the EU/third countries>,\n",
       " 'NAMQ_10_FCS': <DataflowDefinition ESTAT:NAMQ_10_FCS(1.0): Final consumption aggregates>,\n",
       " 'NAMQ_10_GDP': <DataflowDefinition ESTAT:NAMQ_10_GDP(1.0): GDP and main components (output, expenditure and income)>,\n",
       " 'NAMQ_10_LP_ULC': <DataflowDefinition ESTAT:NAMQ_10_LP_ULC(1.0): Labour productivity and unit labour costs>,\n",
       " 'NAMQ_10_PC': <DataflowDefinition ESTAT:NAMQ_10_PC(1.0): Main GDP aggregates per capita>,\n",
       " 'NAMQ_10_PE': <DataflowDefinition ESTAT:NAMQ_10_PE(1.0): Population and employment>,\n",
       " 'NASA_10_F_BS': <DataflowDefinition ESTAT:NASA_10_F_BS(1.0): Financial balance sheets - annual data>,\n",
       " 'NASA_10_F_CP': <DataflowDefinition ESTAT:NASA_10_F_CP(1.0): Financial accounts: counterpart information -- annual data>,\n",
       " 'NASA_10_F_GL': <DataflowDefinition ESTAT:NASA_10_F_GL(1.0): Revaluation account - annual data>,\n",
       " 'NASA_10_F_OC': <DataflowDefinition ESTAT:NASA_10_F_OC(1.0): Other changes in volume - annual data>,\n",
       " 'NASA_10_F_TR': <DataflowDefinition ESTAT:NASA_10_F_TR(1.0): Financial transactions - annual data>,\n",
       " 'NASA_10_KI': <DataflowDefinition ESTAT:NASA_10_KI(1.0): Key indicators - annual data>,\n",
       " 'NASA_10_NF_TR': <DataflowDefinition ESTAT:NASA_10_NF_TR(1.0): Non-financial transactions - annual data>,\n",
       " 'NASA_10_PENS1': <DataflowDefinition ESTAT:NASA_10_PENS1(1.0): Accrued-to-date pension entitlements in social insurance - annual data>,\n",
       " 'NASA_10_PENS2': <DataflowDefinition ESTAT:NASA_10_PENS2(1.0): Sensitivity analysis of accrued-to-date pension entitlements in general government pension schemes outside of core national accounts - annual data>,\n",
       " 'NASQ_10_F_BS': <DataflowDefinition ESTAT:NASQ_10_F_BS(1.0): Financial balance sheets - quarterly data>,\n",
       " 'NASQ_10_F_CP': <DataflowDefinition ESTAT:NASQ_10_F_CP(1.0): Financial accounts: counterpart information - quarterly data>,\n",
       " 'NASQ_10_F_GL': <DataflowDefinition ESTAT:NASQ_10_F_GL(1.0): Revaluation account - quarterly data>,\n",
       " 'NASQ_10_F_OC': <DataflowDefinition ESTAT:NASQ_10_F_OC(1.0): Other changes in volume -  quarterly data>,\n",
       " 'NASQ_10_F_TR': <DataflowDefinition ESTAT:NASQ_10_F_TR(1.0): Financial transactions - quarterly data>,\n",
       " 'NASQ_10_KI': <DataflowDefinition ESTAT:NASQ_10_KI(1.0): Key indicators - quarterly data>,\n",
       " 'NASQ_10_NF_TR': <DataflowDefinition ESTAT:NASQ_10_NF_TR(1.0): Non-financial transactions - quarterly data>,\n",
       " 'NRG_101M': <DataflowDefinition ESTAT:NRG_101M(1.0): Supply and transformation of solid fuels - monthly data>,\n",
       " 'NRG_102M': <DataflowDefinition ESTAT:NRG_102M(1.0): Supply and transformation of oil - monthly data>,\n",
       " 'NRG_103M': <DataflowDefinition ESTAT:NRG_103M(1.0): Supply of gas - monthly data>,\n",
       " 'NRG_105M': <DataflowDefinition ESTAT:NRG_105M(1.0): Supply of electricity - monthly data>,\n",
       " 'NRG_122M': <DataflowDefinition ESTAT:NRG_122M(1.0): Imports - solid fuels - monthly data>,\n",
       " 'NRG_123M': <DataflowDefinition ESTAT:NRG_123M(1.0): Imports - oil - monthly data>,\n",
       " 'NRG_124M': <DataflowDefinition ESTAT:NRG_124M(1.0): Imports - gas - monthly data>,\n",
       " 'NRG_125M': <DataflowDefinition ESTAT:NRG_125M(1.0): Imports - electricity - monthly data>,\n",
       " 'NRG_132M': <DataflowDefinition ESTAT:NRG_132M(1.0): Exports - solid fuels - monthly data>,\n",
       " 'NRG_133M': <DataflowDefinition ESTAT:NRG_133M(1.0): Exports - oil - monthly data>,\n",
       " 'NRG_134M': <DataflowDefinition ESTAT:NRG_134M(1.0): Exports - gas - monthly data>,\n",
       " 'NRG_135M': <DataflowDefinition ESTAT:NRG_135M(1.0): Exports - electricity - monthly data>,\n",
       " 'NRG_141M': <DataflowDefinition ESTAT:NRG_141M(1.0): Oil stocks - stock levels - monthly data>,\n",
       " 'NRG_142M': <DataflowDefinition ESTAT:NRG_142M(1.0): Oil stocks - stocks held for other countries and stocks held abroad - monthly data>,\n",
       " 'NRG_143M': <DataflowDefinition ESTAT:NRG_143M(1.0): Oil stocks - emergency stocks in days equivalent - monthly data>,\n",
       " 'NRG_BAL_C': <DataflowDefinition ESTAT:NRG_BAL_C(1.0): Complete energy balances>,\n",
       " 'NRG_BAL_CV': <DataflowDefinition ESTAT:NRG_BAL_CV(1.0): Calorific values>,\n",
       " 'NRG_BAL_PEH': <DataflowDefinition ESTAT:NRG_BAL_PEH(1.0): Production of electricity and derived heat by type of fuel>,\n",
       " 'NRG_BAL_S': <DataflowDefinition ESTAT:NRG_BAL_S(1.0): Simplified energy balances>,\n",
       " 'NRG_BAL_S$DV_650': <DataflowDefinition ESTAT:NRG_BAL_S$DV_650(1.0): Simplified energy balances>,\n",
       " 'NRG_BAL_SD': <DataflowDefinition ESTAT:NRG_BAL_SD(1.0): Energy flow - Sankey diagram data>,\n",
       " 'NRG_CB_BM': <DataflowDefinition ESTAT:NRG_CB_BM(1.0): Supply of biomass - annual data>,\n",
       " 'NRG_CB_COSM': <DataflowDefinition ESTAT:NRG_CB_COSM(1.0): Crude oil supply - monthly data>,\n",
       " 'NRG_CB_E': <DataflowDefinition ESTAT:NRG_CB_E(1.0): Supply, transformation and consumption of electricity>,\n",
       " 'NRG_CB_EIM': <DataflowDefinition ESTAT:NRG_CB_EIM(1.0): Electricity available to internal market>,\n",
       " 'NRG_CB_EM': <DataflowDefinition ESTAT:NRG_CB_EM(1.0): Supply, transformation and consumption of electricity - monthly data>,\n",
       " 'NRG_CB_GAS': <DataflowDefinition ESTAT:NRG_CB_GAS(1.0): Supply, transformation and consumption of gas>,\n",
       " 'NRG_CB_GASM': <DataflowDefinition ESTAT:NRG_CB_GASM(1.0): Supply, transformation and consumption of gas - monthly data>,\n",
       " 'NRG_CB_H': <DataflowDefinition ESTAT:NRG_CB_H(1.0): Supply, transformation and consumption of derived heat>,\n",
       " 'NRG_CB_OIL': <DataflowDefinition ESTAT:NRG_CB_OIL(1.0): Supply, transformation and consumption of oil and petroleum products>,\n",
       " 'NRG_CB_OILM': <DataflowDefinition ESTAT:NRG_CB_OILM(1.0): Supply and transformation of oil and petroleum products - monthly data>,\n",
       " 'NRG_CB_PEM': <DataflowDefinition ESTAT:NRG_CB_PEM(1.0): Net electricity generation by type of fuel - monthly data>,\n",
       " 'NRG_CB_RW': <DataflowDefinition ESTAT:NRG_CB_RW(1.0): Supply, transformation and consumption of renewables and wastes>,\n",
       " 'NRG_CB_SFF': <DataflowDefinition ESTAT:NRG_CB_SFF(1.0): Supply, transformation and consumption of solid fossil fuels>,\n",
       " 'NRG_CB_SFFM': <DataflowDefinition ESTAT:NRG_CB_SFFM(1.0): Supply and transformation of solid fossil fuels - monthly data>,\n",
       " 'NRG_CHDDR2_A': <DataflowDefinition ESTAT:NRG_CHDDR2_A(1.0): Cooling and heating degree days by NUTS 3 regions - annual data>,\n",
       " 'NRG_CHDDR2_M': <DataflowDefinition ESTAT:NRG_CHDDR2_M(1.0): Cooling and heating degree days by NUTS 3 regions - monthly data>,\n",
       " 'NRG_CHDD_A': <DataflowDefinition ESTAT:NRG_CHDD_A(1.0): Cooling and heating degree days by country - annual data>,\n",
       " 'NRG_CHDD_M': <DataflowDefinition ESTAT:NRG_CHDD_M(1.0): Cooling and heating degree days by country - monthly data>,\n",
       " 'NRG_CHP_CPFE': <DataflowDefinition ESTAT:NRG_CHP_CPFE(1.0): Capacities, production, fuel used and energy savings in combined heat and power (CHP) by type of plant, generation technologies and primary energy savings levels>,\n",
       " 'NRG_CHP_F': <DataflowDefinition ESTAT:NRG_CHP_F(1.0): Fuel used in combined heat and power>,\n",
       " 'NRG_CHP_N': <DataflowDefinition ESTAT:NRG_CHP_N(1.0): Number of combined heat and power (CHP) units by type of plant, generation technologies and primary energy savings levels>,\n",
       " 'NRG_DHDC_C': <DataflowDefinition ESTAT:NRG_DHDC_C(1.0): Customers by type of district network and efficiency of network>,\n",
       " 'NRG_DHDC_CPL': <DataflowDefinition ESTAT:NRG_DHDC_CPL(1.0): Capacities, productions and losses in district networks by type of network and type of plant>,\n",
       " 'NRG_DHDC_E': <DataflowDefinition ESTAT:NRG_DHDC_E(1.0): Energy removed from district networks by customers, type of networks and efficiency of network>,\n",
       " 'NRG_DHDC_N': <DataflowDefinition ESTAT:NRG_DHDC_N(1.0): Number and length of district networks by type of network and efficiency of network>,\n",
       " 'NRG_D_HHCV': <DataflowDefinition ESTAT:NRG_D_HHCV(1.0): Disaggregated final energy consumption in households - calorific values>,\n",
       " 'NRG_D_HHQ': <DataflowDefinition ESTAT:NRG_D_HHQ(1.0): Disaggregated final energy consumption in households - quantities>,\n",
       " 'NRG_D_INDCV': <DataflowDefinition ESTAT:NRG_D_INDCV(1.0): Disaggregated final energy consumption in industry - calorific values>,\n",
       " 'NRG_D_INDQ_N': <DataflowDefinition ESTAT:NRG_D_INDQ_N(1.0): Disaggregated final energy consumption in industry - quantities by NACE Rev. 2 activity>,\n",
       " 'NRG_IND_342M': <DataflowDefinition ESTAT:NRG_IND_342M(1.0): Supply electricity - short term monthly data>,\n",
       " 'NRG_IND_343M': <DataflowDefinition ESTAT:NRG_IND_343M(1.0): Supply natural gas - short term monthly data>,\n",
       " 'NRG_IND_AHBTC': <DataflowDefinition ESTAT:NRG_IND_AHBTC(1.0): Heat pumps - ambient heat captured by technology and climate>,\n",
       " 'NRG_IND_COTD': <DataflowDefinition ESTAT:NRG_IND_COTD(1.0): Calculation of overall target - details>,\n",
       " 'NRG_IND_DI': <DataflowDefinition ESTAT:NRG_IND_DI(1.0): Diversity index of energy supply>,\n",
       " 'NRG_IND_DIFEC': <DataflowDefinition ESTAT:NRG_IND_DIFEC(1.0): Diversity index of final energy consumption by sector>,\n",
       " 'NRG_IND_EBMG': <DataflowDefinition ESTAT:NRG_IND_EBMG(1.0): Exports of biomethane through the grid>,\n",
       " 'NRG_IND_EFF': <DataflowDefinition ESTAT:NRG_IND_EFF(1.0): Energy efficiency>,\n",
       " 'NRG_IND_EI': <DataflowDefinition ESTAT:NRG_IND_EI(1.0): Energy intensity>,\n",
       " 'NRG_IND_EP': <DataflowDefinition ESTAT:NRG_IND_EP(1.0): Energy productivity>,\n",
       " 'NRG_IND_EPSC': <DataflowDefinition ESTAT:NRG_IND_EPSC(1.0): Electricity production and self-consumption by sector and fuel>,\n",
       " 'NRG_IND_ESC': <DataflowDefinition ESTAT:NRG_IND_ESC(1.0): Available energy, energy supply and final energy consumption per capita>,\n",
       " 'NRG_IND_ESR': <DataflowDefinition ESTAT:NRG_IND_ESR(1.0): Energy self-reliance>,\n",
       " 'NRG_IND_FECF': <DataflowDefinition ESTAT:NRG_IND_FECF(1.0): Share of fuels in final energy consumption>,\n",
       " 'NRG_IND_FFGAE': <DataflowDefinition ESTAT:NRG_IND_FFGAE(1.0): Share of fossil fuels in gross available energy>,\n",
       " 'NRG_IND_HPTCTC': <DataflowDefinition ESTAT:NRG_IND_HPTCTC(1.0): Heat pumps - technical characteristics by technology and climate>,\n",
       " 'NRG_IND_IBMG': <DataflowDefinition ESTAT:NRG_IND_IBMG(1.0): Imports of biomethane through the grid>,\n",
       " 'NRG_IND_ID': <DataflowDefinition ESTAT:NRG_IND_ID(1.0): Energy imports dependency>,\n",
       " 'NRG_IND_ID3CF': <DataflowDefinition ESTAT:NRG_IND_ID3CF(1.0): Import dependency on third countries by fuel type>,\n",
       " 'NRG_IND_IDOGAS': <DataflowDefinition ESTAT:NRG_IND_IDOGAS(1.0): Natural gas import dependency by country of origin>,\n",
       " 'NRG_IND_IDOOIL': <DataflowDefinition ESTAT:NRG_IND_IDOOIL(1.0): Oil and petroleum products import dependency by country of origin>,\n",
       " 'NRG_IND_IOC': <DataflowDefinition ESTAT:NRG_IND_IOC(1.0): Energy import origin concentration index by fuel>,\n",
       " 'NRG_IND_MARKET': <DataflowDefinition ESTAT:NRG_IND_MARKET(1.0): Energy market indicator>,\n",
       " 'NRG_IND_PEH': <DataflowDefinition ESTAT:NRG_IND_PEH(1.0): Gross and net production of electricity and derived heat by type of plant and operator>,\n",
       " 'NRG_IND_PEHAP': <DataflowDefinition ESTAT:NRG_IND_PEHAP(1.0): Production of electricity and heat by autoproducers, by type of plant>,\n",
       " 'NRG_IND_PEHCF': <DataflowDefinition ESTAT:NRG_IND_PEHCF(1.0): Gross production of electricity and derived heat from combustible fuels by type of plant and operator>,\n",
       " 'NRG_IND_PEHNF': <DataflowDefinition ESTAT:NRG_IND_PEHNF(1.0): Gross production of electricity and derived heat from non-combustible fuels by type of plant and operator>,\n",
       " 'NRG_IND_RCAEBT': <DataflowDefinition ESTAT:NRG_IND_RCAEBT(1.0): Renewable cooling - ambient energy by technology>,\n",
       " 'NRG_IND_RCTCBT': <DataflowDefinition ESTAT:NRG_IND_RCTCBT(1.0): Renewable cooling - technical characteristics by technology>,\n",
       " 'NRG_IND_REN': <DataflowDefinition ESTAT:NRG_IND_REN(1.0): Share of energy from renewable sources>,\n",
       " 'NRG_IND_RFCE': <DataflowDefinition ESTAT:NRG_IND_RFCE(1.0): Contribution of renewable fuels to gross final consumption of energy>,\n",
       " 'NRG_IND_RFCER': <DataflowDefinition ESTAT:NRG_IND_RFCER(1.0): Share of renewable fuels in gross final consumption of energy from renewables>,\n",
       " 'NRG_IND_RFTCE': <DataflowDefinition ESTAT:NRG_IND_RFTCE(1.0): Share of renewable fuels in total gross final consumption of energy>,\n",
       " 'NRG_IND_STJPJSS': <DataflowDefinition ESTAT:NRG_IND_STJPJSS(1.0): Statistical transfers, joint projects and joint support schemes>,\n",
       " 'NRG_IND_URED': <DataflowDefinition ESTAT:NRG_IND_URED(1.0): Use of renewables for electricity - details>,\n",
       " 'NRG_IND_URHCD': <DataflowDefinition ESTAT:NRG_IND_URHCD(1.0): Use of renewables for heating and cooling - details>,\n",
       " 'NRG_IND_URTD': <DataflowDefinition ESTAT:NRG_IND_URTD(1.0): Use of renewables for transport - details>,\n",
       " 'NRG_INF_BT': <DataflowDefinition ESTAT:NRG_INF_BT(1.0): Batteries power capacities and energy storage>,\n",
       " 'NRG_INF_EPC': <DataflowDefinition ESTAT:NRG_INF_EPC(1.0): Electricity production capacities by main fuel groups and operator>,\n",
       " 'NRG_INF_EPCRW': <DataflowDefinition ESTAT:NRG_INF_EPCRW(1.0): Electricity production capacities for renewables and wastes>,\n",
       " 'NRG_INF_EPCT': <DataflowDefinition ESTAT:NRG_INF_EPCT(1.0): Electricity production capacities for combustible fuels by technology and operator>,\n",
       " 'NRG_INF_HPTC': <DataflowDefinition ESTAT:NRG_INF_HPTC(1.0): Heat pumps - technical characteristics by technologies>,\n",
       " 'NRG_INF_LBPC': <DataflowDefinition ESTAT:NRG_INF_LBPC(1.0): Liquid biofuels production capacities>,\n",
       " 'NRG_INF_NUC': <DataflowDefinition ESTAT:NRG_INF_NUC(1.0): Nuclear energy facilities>,\n",
       " 'NRG_INF_STCS': <DataflowDefinition ESTAT:NRG_INF_STCS(1.0): Solar thermal collectors' surface>,\n",
       " 'NRG_JODI': <DataflowDefinition ESTAT:NRG_JODI(1.0): Supply oil - short term monthly data>,\n",
       " 'NRG_PC_202': <DataflowDefinition ESTAT:NRG_PC_202(1.0): Gas prices for household consumers - bi-annual data (from 2007 onwards)>,\n",
       " 'NRG_PC_202_C': <DataflowDefinition ESTAT:NRG_PC_202_C(1.0): Gas prices components for household consumers - annual data>,\n",
       " 'NRG_PC_202_H': <DataflowDefinition ESTAT:NRG_PC_202_H(1.0): Gas prices for domestic consumers - bi-annual data (until 2007)>,\n",
       " 'NRG_PC_202_V': <DataflowDefinition ESTAT:NRG_PC_202_V(1.0): Household consumption volumes of gas by consumption bands>,\n",
       " 'NRG_PC_203': <DataflowDefinition ESTAT:NRG_PC_203(1.0): Gas prices for non-household consumers - bi-annual data (from 2007 onwards)>,\n",
       " 'NRG_PC_203_C': <DataflowDefinition ESTAT:NRG_PC_203_C(1.0): Gas prices components for non-household consumers - annual data>,\n",
       " 'NRG_PC_203_H': <DataflowDefinition ESTAT:NRG_PC_203_H(1.0): Gas prices for industrial consumers - bi-annual data (until 2007)>,\n",
       " 'NRG_PC_203_V': <DataflowDefinition ESTAT:NRG_PC_203_V(1.0): Non-household consumption volumes of gas by consumption bands>,\n",
       " 'NRG_PC_204': <DataflowDefinition ESTAT:NRG_PC_204(1.0): Electricity prices for household consumers - bi-annual data (from 2007 onwards)>,\n",
       " 'NRG_PC_204_C': <DataflowDefinition ESTAT:NRG_PC_204_C(1.0): Electricity prices components for household consumers - annual data (from 2007 onwards)>,\n",
       " 'NRG_PC_204_H': <DataflowDefinition ESTAT:NRG_PC_204_H(1.0): Electricity prices for domestic consumers - bi-annual data (until 2007)>,\n",
       " 'NRG_PC_204_V': <DataflowDefinition ESTAT:NRG_PC_204_V(1.0): Household consumption volumes of electricity by consumption bands>,\n",
       " 'NRG_PC_205': <DataflowDefinition ESTAT:NRG_PC_205(1.0): Electricity prices for non-household consumers - bi-annual data (from 2007 onwards)>,\n",
       " 'NRG_PC_205_C': <DataflowDefinition ESTAT:NRG_PC_205_C(1.0): Electricity prices components for non-household consumers - annual data (from 2007 onwards)>,\n",
       " 'NRG_PC_205_H': <DataflowDefinition ESTAT:NRG_PC_205_H(1.0): Electricity prices for industrial consumers - bi-annual data (until 2007)>,\n",
       " 'NRG_PC_205_V': <DataflowDefinition ESTAT:NRG_PC_205_V(1.0): Non-household consumption volumes of electricity by consumption bands>,\n",
       " 'NRG_PC_206': <DataflowDefinition ESTAT:NRG_PC_206(1.0): Share for transmission and distribution in the network cost for gas and electricity - annual data>,\n",
       " 'NRG_PC_206_H': <DataflowDefinition ESTAT:NRG_PC_206_H(1.0): Electricity - marker prices - bi-annual data (until 2007)>,\n",
       " 'NRG_STK_GAS': <DataflowDefinition ESTAT:NRG_STK_GAS(1.0): Stock levels for gaseous and liquefied natural gas>,\n",
       " 'NRG_STK_GASM': <DataflowDefinition ESTAT:NRG_STK_GASM(1.0): Stock levels for gas products - monthly data>,\n",
       " 'NRG_STK_OAM': <DataflowDefinition ESTAT:NRG_STK_OAM(1.0): Oil stocks held abroad - monthly data>,\n",
       " 'NRG_STK_OEM': <DataflowDefinition ESTAT:NRG_STK_OEM(1.0): Emergency oil stocks in days equivalent - monthly data>,\n",
       " 'NRG_STK_OIL': <DataflowDefinition ESTAT:NRG_STK_OIL(1.0): Stock levels for oil products>,\n",
       " 'NRG_STK_OILM': <DataflowDefinition ESTAT:NRG_STK_OILM(1.0): Stock levels for oil products - monthly data>,\n",
       " 'NRG_STK_OOM': <DataflowDefinition ESTAT:NRG_STK_OOM(1.0): Oil stocks held for other countries - monthly data>,\n",
       " 'NRG_TE_BIO': <DataflowDefinition ESTAT:NRG_TE_BIO(1.0): Exports of biofuels by partner country>,\n",
       " 'NRG_TE_EH': <DataflowDefinition ESTAT:NRG_TE_EH(1.0): Exports of electricity and derived heat by partner country>,\n",
       " 'NRG_TE_GAS': <DataflowDefinition ESTAT:NRG_TE_GAS(1.0): Exports of natural gas by partner country>,\n",
       " 'NRG_TE_GASM': <DataflowDefinition ESTAT:NRG_TE_GASM(1.0): Exports of natural gas by partner country - monthly data>,\n",
       " 'NRG_TE_OIL': <DataflowDefinition ESTAT:NRG_TE_OIL(1.0): Exports of oil and petroleum products by partner country>,\n",
       " 'NRG_TE_OILM': <DataflowDefinition ESTAT:NRG_TE_OILM(1.0): Exports of oil and petroleum products by partner country - monthly data>,\n",
       " 'NRG_TE_SFF': <DataflowDefinition ESTAT:NRG_TE_SFF(1.0): Exports of solid fossil fuels by partner country>,\n",
       " 'NRG_TI_BIO': <DataflowDefinition ESTAT:NRG_TI_BIO(1.0): Imports of biofuels by partner country>,\n",
       " 'NRG_TI_COIFPM': <DataflowDefinition ESTAT:NRG_TI_COIFPM(1.0): Crude oil imports by field of production - monthly data>,\n",
       " 'NRG_TI_EH': <DataflowDefinition ESTAT:NRG_TI_EH(1.0): Imports of electricity and derived heat by partner country>,\n",
       " 'NRG_TI_GAS': <DataflowDefinition ESTAT:NRG_TI_GAS(1.0): Imports of natural gas by partner country>,\n",
       " 'NRG_TI_GASM': <DataflowDefinition ESTAT:NRG_TI_GASM(1.0): Imports of natural gas by partner country - monthly data>,\n",
       " 'NRG_TI_OIL': <DataflowDefinition ESTAT:NRG_TI_OIL(1.0): Imports of oil and petroleum products by partner country>,\n",
       " 'NRG_TI_OILM': <DataflowDefinition ESTAT:NRG_TI_OILM(1.0): Imports of oil and petroleum products by partner country - monthly data>,\n",
       " 'NRG_TI_SFF': <DataflowDefinition ESTAT:NRG_TI_SFF(1.0): Imports of solid fossil fuels by partner country>,\n",
       " 'ORCH_APPLES1': <DataflowDefinition ESTAT:ORCH_APPLES1(1.0): Apple and pears trees - Area by age classes and group of varieties (area in ha)>,\n",
       " 'ORCH_APPLES2': <DataflowDefinition ESTAT:ORCH_APPLES2(1.0): Apple and pear trees - Area by density classes and group of varieties (area in ha)>,\n",
       " 'ORCH_APPLES3': <DataflowDefinition ESTAT:ORCH_APPLES3(1.0): Apple and pear trees - Area by age and density classes (area in ha)>,\n",
       " 'ORCH_GRAPES1': <DataflowDefinition ESTAT:ORCH_GRAPES1(1.0): Table grape vines - Area by age classes (area in ha)>,\n",
       " 'ORCH_GRAPES2': <DataflowDefinition ESTAT:ORCH_GRAPES2(1.0): Table grape vines - Area by density classes (area in ha)>,\n",
       " 'ORCH_GRAPES3': <DataflowDefinition ESTAT:ORCH_GRAPES3(1.0): Table grape vines - Area by age and density classes (area in ha)>,\n",
       " 'ORCH_OLIVES1': <DataflowDefinition ESTAT:ORCH_OLIVES1(1.0): Olive trees - Area by age classes (area in ha)>,\n",
       " 'ORCH_OLIVES2': <DataflowDefinition ESTAT:ORCH_OLIVES2(1.0): Olive trees - Area by density classes (area in ha)>,\n",
       " 'ORCH_OLIVES3': <DataflowDefinition ESTAT:ORCH_OLIVES3(1.0): Olive trees - Area by age and density classes (area in ha)>,\n",
       " 'ORCH_ORANGES1': <DataflowDefinition ESTAT:ORCH_ORANGES1(1.0): Orange, lemon and small citrus fruit trees - Area by age classes and group of varieties (area in ha)>,\n",
       " 'ORCH_ORANGES2': <DataflowDefinition ESTAT:ORCH_ORANGES2(1.0): Orange, lemon and small citrus fruit trees - Area by density classes and group of varieties (area in ha)>,\n",
       " 'ORCH_ORANGES3': <DataflowDefinition ESTAT:ORCH_ORANGES3(1.0): Orange, lemon and small citrus fruit trees - Area by age and density classes (area in ha)>,\n",
       " 'ORCH_PEACH1': <DataflowDefinition ESTAT:ORCH_PEACH1(1.0): Peach and apricot trees - Area by age classes and group of varieties (area in ha)>,\n",
       " 'ORCH_PEACH2': <DataflowDefinition ESTAT:ORCH_PEACH2(1.0): Peach and apricot trees - Area by density classes and group of varieties (area in ha)>,\n",
       " 'ORCH_PEACH3': <DataflowDefinition ESTAT:ORCH_PEACH3(1.0): Peach and apricot trees - Area by age and density classes (area in ha)>,\n",
       " 'ORCH_TOTAL': <DataflowDefinition ESTAT:ORCH_TOTAL(1.0): Total area by species (area in ha)>,\n",
       " 'ORG_APROD': <DataflowDefinition ESTAT:ORG_APROD(1.0): Organic production of animal products>,\n",
       " 'ORG_APROD_H': <DataflowDefinition ESTAT:ORG_APROD_H(1.0): Organic production of animal products (until 2011)>,\n",
       " 'ORG_AQTSPEC': <DataflowDefinition ESTAT:ORG_AQTSPEC(1.0): Organic production of aquaculture products>,\n",
       " 'ORG_COPTYP': <DataflowDefinition ESTAT:ORG_COPTYP(1.0): Organic operators by status of the registration process>,\n",
       " 'ORG_COPTYP_H': <DataflowDefinition ESTAT:ORG_COPTYP_H(1.0): Organic operators by status of the registration process (until 2011)>,\n",
       " 'ORG_CPREACT': <DataflowDefinition ESTAT:ORG_CPREACT(1.0): Processors of organic products by NACE Rev. 2 activity (C)>,\n",
       " 'ORG_CPREACT_H': <DataflowDefinition ESTAT:ORG_CPREACT_H(1.0): Processors of organic products by NACE Rev. 2 activity (C) (2008 -2011)>,\n",
       " 'ORG_CPREACT_NR1': <DataflowDefinition ESTAT:ORG_CPREACT_NR1(1.0): Processors and importers of organic products by NACE Rev. 1.1 activity (D) (until 2007)>,\n",
       " 'ORG_CROPAR': <DataflowDefinition ESTAT:ORG_CROPAR(1.0): Organic crop area by agricultural production methods and crops>,\n",
       " 'ORG_CROPAR_H1': <DataflowDefinition ESTAT:ORG_CROPAR_H1(1.0): Organic crop area by agricultural production methods and crops (until 2011)>,\n",
       " 'ORG_CROPAR_H2': <DataflowDefinition ESTAT:ORG_CROPAR_H2(1.0): Share of organic crop area out of the total utilised agricultural area (UAA) (until 2011)>,\n",
       " 'ORG_CROPPRO': <DataflowDefinition ESTAT:ORG_CROPPRO(1.0): Organic crop production by crops>,\n",
       " 'ORG_CROPPRO_H': <DataflowDefinition ESTAT:ORG_CROPPRO_H(1.0): Organic crop production by crops (until 2011)>,\n",
       " 'ORG_LSTSPEC': <DataflowDefinition ESTAT:ORG_LSTSPEC(1.0): Organic livestock>,\n",
       " 'ORG_LSTSPEC_H': <DataflowDefinition ESTAT:ORG_LSTSPEC_H(1.0): Organic livestock (until 2011)>,\n",
       " 'PAT_EP_CP': <DataflowDefinition ESTAT:PAT_EP_CP(1.0): Co-patenting at the EPO according to applicants'/inventors' country of residence - number (1977-2013)>,\n",
       " 'PAT_EP_IPC': <DataflowDefinition ESTAT:PAT_EP_IPC(1.0): EU co-patenting at the EPO according to applicants'/ inventors' country of residence by international patent classification (IPC) sections - number (1977-2013)>,\n",
       " 'PAT_EP_NIC': <DataflowDefinition ESTAT:PAT_EP_NIC(1.0): Patent applications to the EPO by priority year by institutional sector (1977-2012)>,\n",
       " 'PAT_EP_NIPC': <DataflowDefinition ESTAT:PAT_EP_NIPC(1.0): Patent applications to the EPO by priority year by international patent classification (IPC) sections and classes (1977-2012)>,\n",
       " 'PAT_EP_NNAC2': <DataflowDefinition ESTAT:PAT_EP_NNAC2(1.0): Patent applications to the EPO by priority year by NACE Rev. 2 activity (1977-2012)>,\n",
       " 'PAT_EP_NPCT': <DataflowDefinition ESTAT:PAT_EP_NPCT(1.0): Patent cooperation treaty (PCT) applications designated to the EPO by priority year by international patent classification (IPC) sections and classes (1978-2013)>,\n",
       " 'PAT_EP_NPTN': <DataflowDefinition ESTAT:PAT_EP_NPTN(1.0): Patent applications to the EPO with foreign co-inventors, by priority year (1977-2013)>,\n",
       " 'PAT_EP_NTEC': <DataflowDefinition ESTAT:PAT_EP_NTEC(1.0): High-tech patent applications to the EPO by priority year>,\n",
       " 'PAT_EP_NTOT': <DataflowDefinition ESTAT:PAT_EP_NTOT(1.0): Patent applications to the EPO by priority year (1977-2017)>,\n",
       " 'PAT_EP_RIPC': <DataflowDefinition ESTAT:PAT_EP_RIPC(1.0): Patent applications to the EPO by priority year by NUTS 3 regions, international patent classification (IPC) sections and classes>,\n",
       " 'PAT_EP_RTEC': <DataflowDefinition ESTAT:PAT_EP_RTEC(1.0): High-tech patent applications to the EPO by priority year by NUTS 3 regions>,\n",
       " 'PAT_EP_RTOT': <DataflowDefinition ESTAT:PAT_EP_RTOT(1.0): Patent applications to the EPO by priority year by NUTS 3 regions>,\n",
       " 'PAT_EP_TOT': <DataflowDefinition ESTAT:PAT_EP_TOT(1.0): Patent applications to the EPO by country of applicants and inventors (2004 and onwards; source: EPO)>,\n",
       " 'PAT_TD_NTOT': <DataflowDefinition ESTAT:PAT_TD_NTOT(1.0): Triadic patent families by earliest priority year (1977-2012)>,\n",
       " 'PIPE_EC_EMPLOY': <DataflowDefinition ESTAT:PIPE_EC_EMPLOY(1.0): Persons employed in oil pipeline enterprises by sex (2003-2012)>,\n",
       " 'PIPE_EC_ENT': <DataflowDefinition ESTAT:PIPE_EC_ENT(1.0): Oil pipeline enterprises (1990-2012)>,\n",
       " 'PIPE_EC_INVEST': <DataflowDefinition ESTAT:PIPE_EC_INVEST(1.0): Investment and maintenance in oil pipeline infrastructure>,\n",
       " 'PIPE_GO_TTKM': <DataflowDefinition ESTAT:PIPE_GO_TTKM(1.0): Oil pipeline transport measurements within the national territory by transport coverage and energy products>,\n",
       " 'PIPE_IF_CAPAC': <DataflowDefinition ESTAT:PIPE_IF_CAPAC(1.0): Carrying capacity of pipelines operated>,\n",
       " 'PIPE_IF_LENGHT': <DataflowDefinition ESTAT:PIPE_IF_LENGHT(1.0): Length of pipelines operated>,\n",
       " 'PRC_COLC_EXT': <DataflowDefinition ESTAT:PRC_COLC_EXT(1.0): Correction coefficients outside the European Union (Duty stations) - index (Brussels = 100)>,\n",
       " 'PRC_COLC_EXTM': <DataflowDefinition ESTAT:PRC_COLC_EXTM(1.0): Correction coefficients outside the European Union (Duty stations) - index (Brussels = 100) (Monthly data)>,\n",
       " 'PRC_COLC_NAT': <DataflowDefinition ESTAT:PRC_COLC_NAT(1.0): Correction coefficients in the European Union (Countries) - index (Belgium = 100)>,\n",
       " 'PRC_COLC_PPPNAT': <DataflowDefinition ESTAT:PRC_COLC_PPPNAT(1.0): Purchasing Power Parities in the European Union (Countries) - index (Belgium = 1)>,\n",
       " 'PRC_COLC_PPPTOT': <DataflowDefinition ESTAT:PRC_COLC_PPPTOT(1.0): Purchasing Power Parities in the European Union (Duty stations) - index (Brussels = 1)>,\n",
       " 'PRC_COLC_PPSM': <DataflowDefinition ESTAT:PRC_COLC_PPSM(1.0): Purchasing Power Parities outside the European Union (Duty stations) - index (Brussels = 1) (Monthly data)>,\n",
       " 'PRC_COLC_RENTS': <DataflowDefinition ESTAT:PRC_COLC_RENTS(1.0): Average rent per month in cities by type of dwelling>,\n",
       " 'PRC_COLC_SURF': <DataflowDefinition ESTAT:PRC_COLC_SURF(1.0): Typical dwelling sizes by type of dwelling in each surveyed city>,\n",
       " 'PRC_COLC_TOT': <DataflowDefinition ESTAT:PRC_COLC_TOT(1.0): Correction coefficients in the European Union (Duty stations) - index (Brussels = 100)>,\n",
       " 'PRC_DAP12': <DataflowDefinition ESTAT:PRC_DAP12(1.0): Detailed average prices - 2012>,\n",
       " 'PRC_DAP13': <DataflowDefinition ESTAT:PRC_DAP13(1.0): Detailed average prices - 2013>,\n",
       " 'PRC_DAP14': <DataflowDefinition ESTAT:PRC_DAP14(1.0): Detailed average prices - 2014>,\n",
       " 'PRC_DAP15': <DataflowDefinition ESTAT:PRC_DAP15(1.0): Detailed average prices - 2015>,\n",
       " 'PRC_FSC_IDX': <DataflowDefinition ESTAT:PRC_FSC_IDX(1.0): Food price monitoring tool>,\n",
       " 'PRC_HICP_AIND': <DataflowDefinition ESTAT:PRC_HICP_AIND(1.0): HICP - annual data (average index and rate of change)>,\n",
       " 'PRC_HICP_AIND$DV_316': <DataflowDefinition ESTAT:PRC_HICP_AIND$DV_316(1.0): HICP - annual data (average index and rate of change)>,\n",
       " 'PRC_HICP_AIND$DV_320': <DataflowDefinition ESTAT:PRC_HICP_AIND$DV_320(1.0): HICP - annual data (average index and rate of change)>,\n",
       " 'PRC_HICP_APC': <DataflowDefinition ESTAT:PRC_HICP_APC(1.0): HICP - administered prices (composition)>,\n",
       " 'PRC_HICP_CANN': <DataflowDefinition ESTAT:PRC_HICP_CANN(1.0): HICP at constant tax rates - monthly data (annual rate of change)>,\n",
       " 'PRC_HICP_CIND': <DataflowDefinition ESTAT:PRC_HICP_CIND(1.0): HICP at constant tax rates - monthly data (index)>,\n",
       " 'PRC_HICP_CMON': <DataflowDefinition ESTAT:PRC_HICP_CMON(1.0): HICP at constant tax rates - monthly data (monthly rate of change)>,\n",
       " 'PRC_HICP_COW': <DataflowDefinition ESTAT:PRC_HICP_COW(1.0): HICP - country weights>,\n",
       " 'PRC_HICP_CTRB': <DataflowDefinition ESTAT:PRC_HICP_CTRB(1.0): HICP - contributions to EA annual inflation (in percentage points)>,\n",
       " 'PRC_HICP_FP': <DataflowDefinition ESTAT:PRC_HICP_FP(1.0): HICP - first published data (monthly index and annual rate of change)>,\n",
       " 'PRC_HICP_INW': <DataflowDefinition ESTAT:PRC_HICP_INW(1.0): HICP - item weights>,\n",
       " 'PRC_HICP_MANR': <DataflowDefinition ESTAT:PRC_HICP_MANR(1.0): HICP - monthly data (annual rate of change)>,\n",
       " 'PRC_HICP_MIDX': <DataflowDefinition ESTAT:PRC_HICP_MIDX(1.0): HICP - monthly data (index)>,\n",
       " 'PRC_HICP_MIDX$DV_1082': <DataflowDefinition ESTAT:PRC_HICP_MIDX$DV_1082(1.0): HICP - monthly data (index)>,\n",
       " 'PRC_HICP_MIDX$DV_651': <DataflowDefinition ESTAT:PRC_HICP_MIDX$DV_651(1.0): HICP - monthly data (index)>,\n",
       " 'PRC_HICP_MMOR': <DataflowDefinition ESTAT:PRC_HICP_MMOR(1.0): HICP - monthly data (monthly rate of change)>,\n",
       " 'PRC_HICP_MV12R': <DataflowDefinition ESTAT:PRC_HICP_MV12R(1.0): HICP - monthly data (12-month average rate of change)>,\n",
       " 'PRC_HPI_A': <DataflowDefinition ESTAT:PRC_HPI_A(1.0): House price index (2015 = 100) - annual data>,\n",
       " 'PRC_HPI_COW': <DataflowDefinition ESTAT:PRC_HPI_COW(1.0): House price index - country weights>,\n",
       " 'PRC_HPI_HSNA': <DataflowDefinition ESTAT:PRC_HPI_HSNA(1.0): House sales - number and index (2015=100), annual data>,\n",
       " 'PRC_HPI_HSNQ': <DataflowDefinition ESTAT:PRC_HPI_HSNQ(1.0): House sales - number and index (2015=100), quarterly data>,\n",
       " 'PRC_HPI_HSVA': <DataflowDefinition ESTAT:PRC_HPI_HSVA(1.0): House sales - value and index (2015=100), annual data>,\n",
       " 'PRC_HPI_HSVQ': <DataflowDefinition ESTAT:PRC_HPI_HSVQ(1.0): House sales - value and index (2015=100), quarterly data>,\n",
       " 'PRC_HPI_INW': <DataflowDefinition ESTAT:PRC_HPI_INW(1.0): House price index - Item weights>,\n",
       " 'PRC_HPI_OOA': <DataflowDefinition ESTAT:PRC_HPI_OOA(1.0): Owner-occupied housing price index (2015=100) - annual data>,\n",
       " 'PRC_HPI_OOCOW': <DataflowDefinition ESTAT:PRC_HPI_OOCOW(1.0): Owner-occupied housing price index - country weights>,\n",
       " 'PRC_HPI_OOINW': <DataflowDefinition ESTAT:PRC_HPI_OOINW(1.0): Owner-occupied housing price index - item weights>,\n",
       " 'EARN_SES_HFTPT': <DataflowDefinition ESTAT:EARN_SES_HFTPT(1.0): Hourly earnings by economic activity and contractual working time (enterprises with 10 employed persons or more)>,\n",
       " 'PRC_HPI_OOQ': <DataflowDefinition ESTAT:PRC_HPI_OOQ(1.0): Owner-occupied housing price index (2015=100) - quarterly data>,\n",
       " 'EARN_SES_HOURLY': <DataflowDefinition ESTAT:EARN_SES_HOURLY(1.0): Structure of earnings survey: hourly earnings>,\n",
       " 'PRC_HPI_Q': <DataflowDefinition ESTAT:PRC_HPI_Q(1.0): House price index (2015 = 100) - quarterly data>,\n",
       " 'EARN_SES_HOURLY$DV_243': <DataflowDefinition ESTAT:EARN_SES_HOURLY$DV_243(1.0): Structure of earnings survey: hourly earnings>,\n",
       " 'PRC_IPC_G20': <DataflowDefinition ESTAT:PRC_IPC_G20(1.0): G20 CPI all-items - Group of Twenty - Consumer price index>,\n",
       " 'EARN_SES_HOURLY$DV_244': <DataflowDefinition ESTAT:EARN_SES_HOURLY$DV_244(1.0): Structure of earnings survey: hourly earnings>,\n",
       " 'PRC_PPP_CONV': <DataflowDefinition ESTAT:PRC_PPP_CONV(1.0): Convergence indicators>,\n",
       " 'EARN_SES_MCTRL': <DataflowDefinition ESTAT:EARN_SES_MCTRL(1.0): Monthly earnings by economic control (enterprises with 10 employed persons or more) - NACE Rev. 1.1, C-O excluding L>,\n",
       " 'PRC_PPP_IND': <DataflowDefinition ESTAT:PRC_PPP_IND(1.0): Purchasing power parities (PPPs), price level indices and real expenditures for ESA 2010 aggregates>,\n",
       " 'EARN_SES_MDECI': <DataflowDefinition ESTAT:EARN_SES_MDECI(1.0): Monthly earnings by quantiles and contractual working time (enterprises with 10 employed persons or more) - NACE Rev. 1.1, C-O excluding L>,\n",
       " 'PRC_REM_AVG': <DataflowDefinition ESTAT:PRC_REM_AVG(1.0): Average remuneration of national civil servants in central public administration>,\n",
       " 'EARN_SES_MONTHLY': <DataflowDefinition ESTAT:EARN_SES_MONTHLY(1.0): Structure of earnings survey: monthly earnings>,\n",
       " 'PRC_REM_CS': <DataflowDefinition ESTAT:PRC_REM_CS(1.0): Remuneration indexes of national civil servants in central public administration>,\n",
       " 'PRC_REM_GDP': <DataflowDefinition ESTAT:PRC_REM_GDP(1.0): GDP weights used in the calculation of the global specific indicator>,\n",
       " 'PRC_REM_IDX': <DataflowDefinition ESTAT:PRC_REM_IDX(1.0): Joint Index>,\n",
       " 'PRC_REM_NR': <DataflowDefinition ESTAT:PRC_REM_NR(1.0): National civil servants in central public administration>,\n",
       " 'PROJ_19NAASFR': <DataflowDefinition ESTAT:PROJ_19NAASFR(1.0): Assumptions for fertility rates by age and type of projection>,\n",
       " 'PROJ_19NAASMR': <DataflowDefinition ESTAT:PROJ_19NAASMR(1.0): Assumptions for probability of dying by age, sex and type of projection>,\n",
       " 'PROJ_19NALEXP': <DataflowDefinition ESTAT:PROJ_19NALEXP(1.0): Projected life expectancy by age (in completed years), sex and type of projection>,\n",
       " 'PROJ_19NANMIG': <DataflowDefinition ESTAT:PROJ_19NANMIG(1.0): Assumptions for net migration by age, sex and type of projection>,\n",
       " 'PROJ_19NDBI': <DataflowDefinition ESTAT:PROJ_19NDBI(1.0): Demographic balances and indicators by type of projection>,\n",
       " 'PROJ_19NP': <DataflowDefinition ESTAT:PROJ_19NP(1.0): Population on 1st January by age, sex and type of projection>,\n",
       " 'EARN_SES_MONTHLY$DV_121': <DataflowDefinition ESTAT:EARN_SES_MONTHLY$DV_121(1.0): Structure of earnings survey: monthly earnings>,\n",
       " 'PROJ_19RAASFR3': <DataflowDefinition ESTAT:PROJ_19RAASFR3(1.0): Assumptions for fertility rates by age, type of projection and NUTS 3 region>,\n",
       " 'EARN_SES_MONTHLY$DV_221': <DataflowDefinition ESTAT:EARN_SES_MONTHLY$DV_221(1.0): Structure of earnings survey: monthly earnings>,\n",
       " 'PROJ_19RAASMR3': <DataflowDefinition ESTAT:PROJ_19RAASMR3(1.0): Assumptions for probability of dying by age, sex, type of projection and NUTS 3 region>,\n",
       " 'EARN_SES_PUB1A': <DataflowDefinition ESTAT:EARN_SES_PUB1A(1.0): Low-wage earners as a proportion of all employees (excluding apprentices) by age>,\n",
       " 'EARN_SES_PUB1A$DV_1878': <DataflowDefinition ESTAT:EARN_SES_PUB1A$DV_1878(1.0): Low-wage earners as a proportion of all employees (excluding apprentices) by age>,\n",
       " 'EARN_SES_PUB1A$DV_352': <DataflowDefinition ESTAT:EARN_SES_PUB1A$DV_352(1.0): Low-wage earners as a proportion of all employees (excluding apprentices) by age>,\n",
       " 'PROJ_19RALEXP3': <DataflowDefinition ESTAT:PROJ_19RALEXP3(1.0): Projected life expectancy by age (reached during the year), sex, type of projection and NUTS 3 region>,\n",
       " 'EARN_SES_PUB1I': <DataflowDefinition ESTAT:EARN_SES_PUB1I(1.0): Low-wage earners as a proportion of all employees (excluding apprentices) by educational attainment level>,\n",
       " 'PROJ_19RANMIG3': <DataflowDefinition ESTAT:PROJ_19RANMIG3(1.0): Assumptions for net migration by age, sex, type of projection and NUTS 3 region>,\n",
       " 'EARN_SES_PUB1I$DV_353': <DataflowDefinition ESTAT:EARN_SES_PUB1I$DV_353(1.0): Low-wage earners as a proportion of all employees (excluding apprentices) by educational attainment level>,\n",
       " 'PROJ_19RDBI3': <DataflowDefinition ESTAT:PROJ_19RDBI3(1.0): Demographic balances and indicators by type of projection and NUTS 3 region>,\n",
       " 'PROJ_19RDTH3': <DataflowDefinition ESTAT:PROJ_19RDTH3(1.0): Projected deaths by age, sex, type of projection and NUTS 3 region>,\n",
       " 'EARN_SES_PUB1N': <DataflowDefinition ESTAT:EARN_SES_PUB1N(1.0): Low-wage earners as a proportion of all employees (excluding apprentices) by economic activity>,\n",
       " 'PROJ_19RP3': <DataflowDefinition ESTAT:PROJ_19RP3(1.0): Population on 1st January by age, sex, type of projection and NUTS 3 region>,\n",
       " 'PROJ_23NAASFR': <DataflowDefinition ESTAT:PROJ_23NAASFR(1.0): Assumptions for fertility rates by age and type of projection>,\n",
       " 'EARN_SES_PUB1S': <DataflowDefinition ESTAT:EARN_SES_PUB1S(1.0): Low-wage earners as a proportion of all employees (excluding apprentices) by sex>,\n",
       " 'EARN_SES_PUB1S$DV_1877': <DataflowDefinition ESTAT:EARN_SES_PUB1S$DV_1877(1.0): Low-wage earners as a proportion of all employees (excluding apprentices) by sex>,\n",
       " 'PROJ_23NAASMR': <DataflowDefinition ESTAT:PROJ_23NAASMR(1.0): Assumptions for mortality rates by age, sex and type of projection>,\n",
       " 'EARN_SES_PUB1S$DV_354': <DataflowDefinition ESTAT:EARN_SES_PUB1S$DV_354(1.0): Low-wage earners as a proportion of all employees (excluding apprentices) by sex>,\n",
       " 'PROJ_23NALEXP': <DataflowDefinition ESTAT:PROJ_23NALEXP(1.0): Projected life expectancy by age (in completed years), sex and type of projection>,\n",
       " 'EARN_SES_PUB1T': <DataflowDefinition ESTAT:EARN_SES_PUB1T(1.0): Low-wage earners as a proportion of all employees (excluding apprentices) by employment contract>,\n",
       " 'EARN_SES_PUB2A': <DataflowDefinition ESTAT:EARN_SES_PUB2A(1.0): Median hourly earnings, all employees (excluding apprentices) by age>,\n",
       " 'PROJ_23NANMIG': <DataflowDefinition ESTAT:PROJ_23NANMIG(1.0): Assumptions for net migration by age, sex and type of projection>,\n",
       " 'EARN_SES_PUB2A$DV_1880': <DataflowDefinition ESTAT:EARN_SES_PUB2A$DV_1880(1.0): Median hourly earnings, all employees (excluding apprentices) by age>,\n",
       " 'PROJ_23NDBI': <DataflowDefinition ESTAT:PROJ_23NDBI(1.0): Demographic balances and indicators by type of projection>,\n",
       " 'EARN_SES_PUB2I': <DataflowDefinition ESTAT:EARN_SES_PUB2I(1.0): Median hourly earnings, all employees (excluding apprentices) by educational attainment level>,\n",
       " 'PROJ_23NP': <DataflowDefinition ESTAT:PROJ_23NP(1.0): Population on 1st January by age, sex and type of projection>,\n",
       " 'EARN_SES_PUB2N': <DataflowDefinition ESTAT:EARN_SES_PUB2N(1.0): Median hourly earnings, all employees (excluding apprentices) by economic activity>,\n",
       " 'PROJ_STP22': <DataflowDefinition ESTAT:PROJ_STP22(1.0): Short-term update of the projected population (2022-2032)>,\n",
       " 'EARN_SES_PUB2S': <DataflowDefinition ESTAT:EARN_SES_PUB2S(1.0): Median hourly earnings, all employees (excluding apprentices) by sex>,\n",
       " 'QOE_EWCS_1C3': <DataflowDefinition ESTAT:QOE_EWCS_1C3(1.0): Employed persons discriminated at work during the last 12 months by sex and age (source: Eurofound)>,\n",
       " 'EARN_SES_PUB2S$DV_1879': <DataflowDefinition ESTAT:EARN_SES_PUB2S$DV_1879(1.0): Median hourly earnings, all employees (excluding apprentices) by sex>,\n",
       " 'QOE_EWCS_3C3': <DataflowDefinition ESTAT:QOE_EWCS_3C3(1.0): Mean duration of commuting time one-way between work and home by sex and age (source: Eurofound)>,\n",
       " 'EARN_SES_PUB2T': <DataflowDefinition ESTAT:EARN_SES_PUB2T(1.0): Median hourly earnings, all employees (excluding apprentices) by employment contract>,\n",
       " 'QOE_EWCS_4A5': <DataflowDefinition ESTAT:QOE_EWCS_4A5(1.0): Employed persons expecting a possible loss of their job in the next 6 months by sex and age (source: Eurofound)>,\n",
       " 'EDAT_AES_L21': <DataflowDefinition ESTAT:EDAT_AES_L21(1.0): Number of foreign languages known (self-reported) by sex>,\n",
       " 'QOE_EWCS_6_1': <DataflowDefinition ESTAT:QOE_EWCS_6_1(1.0): Employed persons participating in job-related non-formal education and training in the past 12 months by sex and age (source: Eurofound)>,\n",
       " 'EDAT_AES_L21$DV_1602': <DataflowDefinition ESTAT:EDAT_AES_L21$DV_1602(1.0): Number of foreign languages known (self-reported) by sex>,\n",
       " 'QOE_EWCS_6_2': <DataflowDefinition ESTAT:QOE_EWCS_6_2(1.0): Volume of job-related non-formal education and training per participant in the last 12 months by duration, sex and age (source: Eurofound)>,\n",
       " 'EDAT_AES_L22': <DataflowDefinition ESTAT:EDAT_AES_L22(1.0): Number of foreign languages known (self-reported) by age>,\n",
       " 'EDAT_AES_L23': <DataflowDefinition ESTAT:EDAT_AES_L23(1.0): Number of foreign languages known (self-reported) by educational attainment level>,\n",
       " 'QOE_EWCS_6_3': <DataflowDefinition ESTAT:QOE_EWCS_6_3(1.0): Employed persons perceiving that their job-related non-formal education and training helped to improve the way they work by sex and age (source: Eurofound)>,\n",
       " 'EDAT_AES_L24': <DataflowDefinition ESTAT:EDAT_AES_L24(1.0): Number of foreign languages known (self-reported) by labour status>,\n",
       " 'QOE_EWCS_6_4': <DataflowDefinition ESTAT:QOE_EWCS_6_4(1.0): Employed persons whose job involves improving their skills by sex and age (source: Eurofound)>,\n",
       " 'EDAT_AES_L25': <DataflowDefinition ESTAT:EDAT_AES_L25(1.0): Number of foreign languages known (self-reported) by occupation>,\n",
       " 'QOE_EWCS_6_5': <DataflowDefinition ESTAT:QOE_EWCS_6_5(1.0): Employed persons whose work experience and job skills would be helpful to find another job by sex and age (source: Eurofound)>,\n",
       " 'EDAT_AES_L26': <DataflowDefinition ESTAT:EDAT_AES_L26(1.0): Number of foreign languages known (self-reported) by degree of urbanisation>,\n",
       " 'QOE_EWCS_6_6': <DataflowDefinition ESTAT:QOE_EWCS_6_6(1.0): Employed persons having the opportunity to use their knowledge and skills in their current job by sex and age (source: Eurofound)>,\n",
       " 'QOE_EWCS_7A1': <DataflowDefinition ESTAT:QOE_EWCS_7A1(1.0): Employed persons having a good relationship with their colleagues by sex and age (source: Eurofound)>,\n",
       " 'EDAT_AES_L31': <DataflowDefinition ESTAT:EDAT_AES_L31(1.0): Level of the best-known foreign language (self-reported) by sex>,\n",
       " 'QOE_EWCS_7A2': <DataflowDefinition ESTAT:QOE_EWCS_7A2(1.0): Employees having a good relationship with their supervisor by sex and age (source: Eurofound)>,\n",
       " 'EDAT_AES_L32': <DataflowDefinition ESTAT:EDAT_AES_L32(1.0): Level of the best-known foreign language (self-reported) by age>,\n",
       " 'QOE_EWCS_7A3': <DataflowDefinition ESTAT:QOE_EWCS_7A3(1.0): Employed persons exposed to employment-related physical, psychological or sexual violence in the last 12 months by sex and age (source: Eurofound)>,\n",
       " 'EDAT_AES_L33': <DataflowDefinition ESTAT:EDAT_AES_L33(1.0): Level of the best-known foreign language (self-reported) by educational attainment level>,\n",
       " 'QOE_EWCS_7B1': <DataflowDefinition ESTAT:QOE_EWCS_7B1(1.0): Employed persons being able to choose their methods of work or to influence their pace of work by sex and age (source: Eurofound)>,\n",
       " 'EDAT_AES_L34': <DataflowDefinition ESTAT:EDAT_AES_L34(1.0): Level of the best-known foreign language (self-reported) by labour status>,\n",
       " 'QOE_EWCS_7B2': <DataflowDefinition ESTAT:QOE_EWCS_7B2(1.0): Employees receiving regular feedback from their supervisor by sex and age (source: Eurofound)>,\n",
       " 'QOE_EWCS_7B3': <DataflowDefinition ESTAT:QOE_EWCS_7B3(1.0): Employed persons thinking that they do useful work by sex and age (source: Eurofound)>,\n",
       " 'EDAT_AES_L35': <DataflowDefinition ESTAT:EDAT_AES_L35(1.0): Level of the best-known foreign language (self-reported) by occupation>,\n",
       " 'QOE_EWCS_7B4': <DataflowDefinition ESTAT:QOE_EWCS_7B4(1.0): Employed persons having to work at very high speed or to tight deadlines by sex and age (source: Eurofound)>,\n",
       " 'EDAT_AES_L36': <DataflowDefinition ESTAT:EDAT_AES_L36(1.0): Level of the best-known foreign language (self-reported) by degree of urbanisation>,\n",
       " 'QOE_EWCS_7B5': <DataflowDefinition ESTAT:QOE_EWCS_7B5(1.0): Employed persons being able to influence decisions that affect their work by sex and age (source: Eurofound)>,\n",
       " 'RAIL_AC_CATNMBR': <DataflowDefinition ESTAT:RAIL_AC_CATNMBR(1.0): Railway accidents by type of accident - annual data (2004-2015)>,\n",
       " 'EDAT_AES_L51': <DataflowDefinition ESTAT:EDAT_AES_L51(1.0): Level of the foreign language reported as best-known in the country (self-reported) by sex>,\n",
       " 'RAIL_AC_CATVICT': <DataflowDefinition ESTAT:RAIL_AC_CATVICT(1.0): Railway victims by type of accident - annual data (2004-2015)>,\n",
       " 'EDAT_AES_L52': <DataflowDefinition ESTAT:EDAT_AES_L52(1.0): Level of the foreign language reported as best-known in the country (self-reported) by age>,\n",
       " 'EDAT_AES_L53': <DataflowDefinition ESTAT:EDAT_AES_L53(1.0): Level of the foreign language reported as best-known in the country (self-reported) by educational attainment level>,\n",
       " 'RAIL_AC_DNGGOOD': <DataflowDefinition ESTAT:RAIL_AC_DNGGOOD(1.0): Accidents involving the transport of dangerous goods - annual data (2004-2015)>,\n",
       " 'EDAT_AES_L54': <DataflowDefinition ESTAT:EDAT_AES_L54(1.0): Level of the foreign language reported as best-known in the country (self-reported) by labour status>,\n",
       " 'RAIL_EC_EMPLO_A': <DataflowDefinition ESTAT:RAIL_EC_EMPLO_A(1.0): Employment in principal railway enterprises, by type of railway activity (until 2012)>,\n",
       " 'RAIL_EC_EMPLO_S': <DataflowDefinition ESTAT:RAIL_EC_EMPLO_S(1.0): Persons employed in principal railway enterprises by sex (until 2012)>,\n",
       " 'RAIL_EC_ENT': <DataflowDefinition ESTAT:RAIL_EC_ENT(1.0): Railway enterprises by type of enterprise>,\n",
       " 'RAIL_EC_EXPEND': <DataflowDefinition ESTAT:RAIL_EC_EXPEND(1.0): Expenditure on rolling stock and railway infrastructure>,\n",
       " 'EDAT_AES_L55': <DataflowDefinition ESTAT:EDAT_AES_L55(1.0): Level of the foreign language reported as best-known in the country (self-reported) by occupation>,\n",
       " 'RAIL_EQ_LOCON': <DataflowDefinition ESTAT:RAIL_EQ_LOCON(1.0): Locomotives and railcars by source of energy>,\n",
       " 'EDAT_AES_L56': <DataflowDefinition ESTAT:EDAT_AES_L56(1.0): Level of the foreign language reported as best-known in the country (self-reported) by degree of urbanisation>,\n",
       " 'RAIL_EQ_LOCOP': <DataflowDefinition ESTAT:RAIL_EQ_LOCOP(1.0): Tractive power of locomotives and railcars by source of energy>,\n",
       " 'EDAT_LFSE_01': <DataflowDefinition ESTAT:EDAT_LFSE_01(1.0): Early leavers from education and training by sex and citizenship>,\n",
       " 'RAIL_EQ_PA_CSB': <DataflowDefinition ESTAT:RAIL_EQ_PA_CSB(1.0): Seat/berth capacity of passenger railway vehicles>,\n",
       " 'EDAT_LFSE_01$DV_1866': <DataflowDefinition ESTAT:EDAT_LFSE_01$DV_1866(1.0): Early leavers from education and training by sex and citizenship>,\n",
       " 'RAIL_EQ_PA_CTY': <DataflowDefinition ESTAT:RAIL_EQ_PA_CTY(1.0): Seat capacity of passenger railway vehicles by type of vehicles>,\n",
       " 'EDAT_LFSE_02': <DataflowDefinition ESTAT:EDAT_LFSE_02(1.0): Early leavers from education and training by sex and country of birth>,\n",
       " 'EDAT_LFSE_02$DV_1868': <DataflowDefinition ESTAT:EDAT_LFSE_02$DV_1868(1.0): Early leavers from education and training by sex and country of birth>,\n",
       " 'EDAT_LFSE_03': <DataflowDefinition ESTAT:EDAT_LFSE_03(1.0): Population by educational attainment level, sex and age (%) - main indicators>,\n",
       " 'RAIL_EQ_PA_NCA': <DataflowDefinition ESTAT:RAIL_EQ_PA_NCA(1.0): Passenger railway vehicles by category of vehicle (until 2012)>,\n",
       " 'EDAT_LFSE_03$DV_1701': <DataflowDefinition ESTAT:EDAT_LFSE_03$DV_1701(1.0): Population by educational attainment level, sex and age (%) - main indicators>,\n",
       " 'RAIL_EQ_PA_NTY': <DataflowDefinition ESTAT:RAIL_EQ_PA_NTY(1.0): Passenger railway vehicles, by type of vehicle>,\n",
       " 'EDAT_LFSE_03$DV_596': <DataflowDefinition ESTAT:EDAT_LFSE_03$DV_596(1.0): Population by educational attainment level, sex and age (%) - main indicators>,\n",
       " 'RAIL_EQ_TRSET': <DataflowDefinition ESTAT:RAIL_EQ_TRSET(1.0): Trainsets and capacity by type of speed>,\n",
       " 'EDAT_LFSE_03$DV_597': <DataflowDefinition ESTAT:EDAT_LFSE_03$DV_597(1.0): Population by educational attainment level, sex and age (%) - main indicators>,\n",
       " 'RAIL_EQ_VANS': <DataflowDefinition ESTAT:RAIL_EQ_VANS(1.0): Railway transport vans>,\n",
       " 'EDAT_LFSE_03$DV_598': <DataflowDefinition ESTAT:EDAT_LFSE_03$DV_598(1.0): Population by educational attainment level, sex and age (%) - main indicators>,\n",
       " 'RAIL_EQ_WAGON': <DataflowDefinition ESTAT:RAIL_EQ_WAGON(1.0): Wagons and their load capacity by type of wagons>,\n",
       " 'EDAT_LFSE_04': <DataflowDefinition ESTAT:EDAT_LFSE_04(1.0): Population by educational attainment level, sex and NUTS 2 regions (%)>,\n",
       " 'RAIL_GO_CONSGMT': <DataflowDefinition ESTAT:RAIL_GO_CONSGMT(1.0): Goods transported by type of consignment>,\n",
       " 'EDAT_LFSE_14': <DataflowDefinition ESTAT:EDAT_LFSE_14(1.0): Early leavers from education and training by sex and labour status>,\n",
       " 'RAIL_GO_CONTNBR': <DataflowDefinition ESTAT:RAIL_GO_CONTNBR(1.0): Volume of containers transported>,\n",
       " 'EDAT_LFSE_14$DV_1864': <DataflowDefinition ESTAT:EDAT_LFSE_14$DV_1864(1.0): Early leavers from education and training by sex and labour status>,\n",
       " 'RAIL_GO_CONTOLD': <DataflowDefinition ESTAT:RAIL_GO_CONTOLD(1.0): Transport of containers or road vehicles (1982-2002)>,\n",
       " 'RAIL_GO_CONTWGT': <DataflowDefinition ESTAT:RAIL_GO_CONTWGT(1.0): Goods transported in intermodal transport units>,\n",
       " 'EDAT_LFSE_14$DV_356': <DataflowDefinition ESTAT:EDAT_LFSE_14$DV_356(1.0): Early leavers from education and training by sex and labour status>,\n",
       " 'RAIL_GO_DNGGOOD': <DataflowDefinition ESTAT:RAIL_GO_DNGGOOD(1.0): Transport of dangerous goods>,\n",
       " 'RAIL_GO_GRGOOD7': <DataflowDefinition ESTAT:RAIL_GO_GRGOOD7(1.0): Goods transported by group of goods - until 2007 based on NST/R>,\n",
       " 'EDAT_LFSE_15': <DataflowDefinition ESTAT:EDAT_LFSE_15(1.0): Early leavers from formal education by sex and labour status>,\n",
       " 'EDAT_LFSE_16': <DataflowDefinition ESTAT:EDAT_LFSE_16(1.0): Early leavers from education and training by sex and NUTS 2 regions>,\n",
       " 'RAIL_GO_GRPGOOD': <DataflowDefinition ESTAT:RAIL_GO_GRPGOOD(1.0): Goods transported by group of goods - from 2008 onwards based on NST 2007>,\n",
       " 'EDAT_LFSE_17': <DataflowDefinition ESTAT:EDAT_LFSE_17(1.0): Population aged 15-34 by sex and age (1 000)>,\n",
       " 'RAIL_GO_INTCMGN': <DataflowDefinition ESTAT:RAIL_GO_INTCMGN(1.0): International transport of goods from the loading country to the reporting country>,\n",
       " 'EDAT_LFSE_18': <DataflowDefinition ESTAT:EDAT_LFSE_18(1.0): Participation rate of young people in education and training by sex, age and labour status (incl. NEET rates)>,\n",
       " 'RAIL_GO_INTGONG': <DataflowDefinition ESTAT:RAIL_GO_INTGONG(1.0): International transport of goods from the reporting country to the unloading country>,\n",
       " 'EDAT_LFSE_19': <DataflowDefinition ESTAT:EDAT_LFSE_19(1.0): Participation rate of young people in formal education by sex, age and labour status>,\n",
       " 'RAIL_GO_INTLD': <DataflowDefinition ESTAT:RAIL_GO_INTLD(1.0): International transport of goods from the loading country to the reporting country (Monthly data) (1982-2002)>,\n",
       " 'EDAT_LFSE_20': <DataflowDefinition ESTAT:EDAT_LFSE_20(1.0): Young people neither in employment nor in education and training by sex, age and labour status (NEET rates)>,\n",
       " 'RAIL_GO_INTUNLD': <DataflowDefinition ESTAT:RAIL_GO_INTUNLD(1.0): International transport of goods from the reporting country to the unloading country (Monthly data) (1982-2002)>,\n",
       " 'EDAT_LFSE_20$DV_1101': <DataflowDefinition ESTAT:EDAT_LFSE_20$DV_1101(1.0): Young people neither in employment nor in education and training by sex, age and labour status (NEET rates)>,\n",
       " 'RAIL_GO_ITU': <DataflowDefinition ESTAT:RAIL_GO_ITU(1.0): Empty and loaded intermodal transport units>,\n",
       " 'EDAT_LFSE_20$DV_1807': <DataflowDefinition ESTAT:EDAT_LFSE_20$DV_1807(1.0): Young people neither in employment nor in education and training by sex, age and labour status (NEET rates)>,\n",
       " 'RAIL_GO_NATDIST': <DataflowDefinition ESTAT:RAIL_GO_NATDIST(1.0): National transport of goods by distance class and group of goods (1982-2002)>,\n",
       " 'EDAT_LFSE_21': <DataflowDefinition ESTAT:EDAT_LFSE_21(1.0): Young people neither in employment nor in education and training by sex, age and educational attainment level (NEET rates)>,\n",
       " 'EDAT_LFSE_22': <DataflowDefinition ESTAT:EDAT_LFSE_22(1.0): Young people neither in employment nor in education and training by sex and NUTS 2 regions (NEET rates)>,\n",
       " 'RAIL_GO_NATLREG': <DataflowDefinition ESTAT:RAIL_GO_NATLREG(1.0): National transport by loading region and by group of goods (Directive 80/1177/EEC) (1982-2002)>,\n",
       " 'EDAT_LFSE_23': <DataflowDefinition ESTAT:EDAT_LFSE_23(1.0): Young people neither in employment nor in education and training by sex, age and citizenship (NEET rates)>,\n",
       " 'EDAT_LFSE_23$DV_1844': <DataflowDefinition ESTAT:EDAT_LFSE_23$DV_1844(1.0): Young people neither in employment nor in education and training by sex, age and citizenship (NEET rates)>,\n",
       " 'RAIL_GO_NATMNTH': <DataflowDefinition ESTAT:RAIL_GO_NATMNTH(1.0): National transport (Directive 80/1177/EEC) (monthly data) (1982-2002)>,\n",
       " 'EDAT_LFSE_24': <DataflowDefinition ESTAT:EDAT_LFSE_24(1.0): Employment rates of young people not in education and training by sex, educational attainment level and years since completion of highest level of education>,\n",
       " 'RAIL_GO_NATUREG': <DataflowDefinition ESTAT:RAIL_GO_NATUREG(1.0): National transport of goods by unloading region and by group of goods (1982-2002)>,\n",
       " 'EDAT_LFSE_25': <DataflowDefinition ESTAT:EDAT_LFSE_25(1.0): Unemployment rates of young people not in education and training by sex, educational attainment level and years since completion of highest level of education>,\n",
       " 'RAIL_GO_QUARTAL': <DataflowDefinition ESTAT:RAIL_GO_QUARTAL(1.0): Goods transported (detailed reporting only ) - Quarterly data>,\n",
       " 'EDAT_LFSE_26': <DataflowDefinition ESTAT:EDAT_LFSE_26(1.0): Activity rates of young people not in education and training by sex, educational attainment level and years since completion of highest level of education>,\n",
       " 'RAIL_GO_TOTAL': <DataflowDefinition ESTAT:RAIL_GO_TOTAL(1.0): Goods transported>,\n",
       " 'EDAT_LFSE_27': <DataflowDefinition ESTAT:EDAT_LFSE_27(1.0): Inactivity rates of young people not in education and training by sex, educational attainment level and years since completion of highest level of education>,\n",
       " 'RAIL_GO_TRSGGDS': <DataflowDefinition ESTAT:RAIL_GO_TRSGGDS(1.0): Transit transport by group of goods (1982-2002)>,\n",
       " 'RAIL_GO_TRSORDE': <DataflowDefinition ESTAT:RAIL_GO_TRSORDE(1.0): Transit transport of goods by loading and unloading countries>,\n",
       " 'EDAT_LFSE_28': <DataflowDefinition ESTAT:EDAT_LFSE_28(1.0): Young people neither in employment nor in education and training by sex, age and country of birth (NEET rates)>,\n",
       " 'RAIL_GO_TYPEALL': <DataflowDefinition ESTAT:RAIL_GO_TYPEALL(1.0): Goods transported by type of transport (2004-2016)>,\n",
       " 'EDAT_LFSE_28$DV_1849': <DataflowDefinition ESTAT:EDAT_LFSE_28$DV_1849(1.0): Young people neither in employment nor in education and training by sex, age and country of birth (NEET rates)>,\n",
       " 'RAIL_GO_TYPEPAS': <DataflowDefinition ESTAT:RAIL_GO_TYPEPAS(1.0): Goods transported by type of transport (detailed reporting only )>,\n",
       " 'RAIL_IF_ELECTRI': <DataflowDefinition ESTAT:RAIL_IF_ELECTRI(1.0): Length of electrified railway lines by type of current>,\n",
       " 'EDAT_LFSE_29': <DataflowDefinition ESTAT:EDAT_LFSE_29(1.0): Young people neither in employment nor in education and training by sex, age and degree of urbanisation (NEET rates)>,\n",
       " 'RAIL_IF_LINE_GA': <DataflowDefinition ESTAT:RAIL_IF_LINE_GA(1.0): Length of electrified and non-electrified railway lines by track gauge>,\n",
       " 'EDAT_LFSE_30': <DataflowDefinition ESTAT:EDAT_LFSE_30(1.0): Early leavers from education and training by sex and degree of urbanisation>,\n",
       " 'RAIL_IF_LINE_NA': <DataflowDefinition ESTAT:RAIL_IF_LINE_NA(1.0): Length of electric and non-electric railway lines by nature of transport>,\n",
       " 'EDAT_LFSE_31': <DataflowDefinition ESTAT:EDAT_LFSE_31(1.0): Employment rates of young people not in education and training by sex, educational attainment level, years since completion of highest level of education and citizenship>,\n",
       " 'RAIL_IF_LINE_SP': <DataflowDefinition ESTAT:RAIL_IF_LINE_SP(1.0): Length of railway lines by maximum permitted speed>,\n",
       " 'EDAT_LFSE_32': <DataflowDefinition ESTAT:EDAT_LFSE_32(1.0): Employment rates of young people not in education and training by sex, educational attainment level, years since completion of highest level of education and country of birth>,\n",
       " 'RAIL_IF_LINE_TR': <DataflowDefinition ESTAT:RAIL_IF_LINE_TR(1.0): Length of railway lines by number of tracks and electrification of lines>,\n",
       " 'RAIL_IF_LVLCROS': <DataflowDefinition ESTAT:RAIL_IF_LVLCROS(1.0): Level crossings by type (source: ERA)>,\n",
       " 'EDAT_LFSE_33': <DataflowDefinition ESTAT:EDAT_LFSE_33(1.0): Employment rates of young people not in education and training by sex, educational attainment level, years since completion of highest level of education and NUTS 2 regions>,\n",
       " 'RAIL_IF_TRACKS': <DataflowDefinition ESTAT:RAIL_IF_TRACKS(1.0): Length of railway tracks by electrification of tracks>,\n",
       " 'EDAT_LFSE_34': <DataflowDefinition ESTAT:EDAT_LFSE_34(1.0): Employment rates of young people not in education and training by sex, educational attainment level, years since completion of highest level of education and degree of urbanisation>,\n",
       " 'RAIL_IF_TRAFF': <DataflowDefinition ESTAT:RAIL_IF_TRAFF(1.0): Length of railway lines equipped with the railway traffic management system by type of signalling (source: ERA)>,\n",
       " 'EDAT_LFSE_35': <DataflowDefinition ESTAT:EDAT_LFSE_35(1.0): Young people neither in employment nor in education and training by sex, age, country of birth and degree of urbanisation (NEET rates)>,\n",
       " 'RAIL_PA_INTCMNG': <DataflowDefinition ESTAT:RAIL_PA_INTCMNG(1.0): International transport of passengers from the country of embarkation to the reporting country>,\n",
       " 'EDAT_LFSE_36': <DataflowDefinition ESTAT:EDAT_LFSE_36(1.0): Young people neither in employment nor in education and training by sex, age, citizenship and degree of urbanisation (NEET rates)>,\n",
       " 'RAIL_PA_INTGONG': <DataflowDefinition ESTAT:RAIL_PA_INTGONG(1.0): International transport of passengers from the reporting country to the country of disembarkation>,\n",
       " 'EDAT_LFSE_37': <DataflowDefinition ESTAT:EDAT_LFSE_37(1.0): Young people neither in employment nor in education and training by sex, age, country of birth and NUTS 2 regions (NEET rates)>,\n",
       " 'RAIL_PA_NBCAR': <DataflowDefinition ESTAT:RAIL_PA_NBCAR(1.0): Passenger cars in accompanied passenger car railway transport, by type of transport>,\n",
       " 'RAIL_PA_NBPASS': <DataflowDefinition ESTAT:RAIL_PA_NBPASS(1.0): Passengers in accompanied passenger car railway transport, by type of transport>,\n",
       " 'EDAT_LFSE_38': <DataflowDefinition ESTAT:EDAT_LFSE_38(1.0): Young people neither in employment nor in education and training by sex, age, citizenship and NUTS 2 regions (NEET rates)>,\n",
       " 'RAIL_PA_QUARTAL': <DataflowDefinition ESTAT:RAIL_PA_QUARTAL(1.0): Passengers transported (detailed reporting only) - (quarterly data)>,\n",
       " 'EDAT_LFSO_00T1': <DataflowDefinition ESTAT:EDAT_LFSO_00T1(1.0): Youth transitions from education to working life in Europe (in number of months)>,\n",
       " 'RAIL_PA_SPEED': <DataflowDefinition ESTAT:RAIL_PA_SPEED(1.0): Passengers transported by type of train speed>,\n",
       " 'RAIL_PA_TOTAL': <DataflowDefinition ESTAT:RAIL_PA_TOTAL(1.0): Passengers transported>,\n",
       " 'EDAT_LFSO_00T2': <DataflowDefinition ESTAT:EDAT_LFSO_00T2(1.0): Employed in service sector and occupational status of recent school-leavers>,\n",
       " 'RAIL_PA_TYPEPAS': <DataflowDefinition ESTAT:RAIL_PA_TYPEPAS(1.0): Passenger transport by type of transport (detailed reporting only)>,\n",
       " 'EDAT_LFSO_00T3': <DataflowDefinition ESTAT:EDAT_LFSO_00T3(1.0): Young people's social origin, educational attainment level and labour outcomes in Europe>,\n",
       " 'RAIL_TF_HAULMOV': <DataflowDefinition ESTAT:RAIL_TF_HAULMOV(1.0): Hauled railway vehicle traffic performance by train category and source of energy (gross tkm hauled)>,\n",
       " 'RAIL_TF_HAUSEAT': <DataflowDefinition ESTAT:RAIL_TF_HAUSEAT(1.0): Hauled passenger railway vehicle traffic performance by type of railway vehicle speed - seat km (until 2012)>,\n",
       " 'EDAT_LFSO_00T4': <DataflowDefinition ESTAT:EDAT_LFSO_00T4(1.0): Parents educational attainment level>,\n",
       " 'RAIL_TF_HAUTKMO': <DataflowDefinition ESTAT:RAIL_TF_HAUTKMO(1.0): Hauled vehicle traffic performance - tkm (until 2012)>,\n",
       " 'EDAT_LFSO_00T5': <DataflowDefinition ESTAT:EDAT_LFSO_00T5(1.0): Job mismatches and their labour market effects among school-leavers in Europe>,\n",
       " 'RAIL_TF_HAUTYPE': <DataflowDefinition ESTAT:RAIL_TF_HAUTYPE(1.0): Hauled railway vehicle traffic performance by type of railway vehicle (vehicle-km)>,\n",
       " 'EDAT_LFSO_09T1': <DataflowDefinition ESTAT:EDAT_LFSO_09T1(1.0): Average age when leaving formal education by sex and educational attainment level for persons who left within the last 3 or 5 years>,\n",
       " 'RAIL_TF_NS10_AT': <DataflowDefinition ESTAT:RAIL_TF_NS10_AT(1.0): Train traffic on the rail network - Austria (2010)>,\n",
       " 'EDAT_LFSO_09T2': <DataflowDefinition ESTAT:EDAT_LFSO_09T2(1.0): Average time between leaving formal education and starting the first job by age, sex and educational attainment level for persons who left within the last 3 or 5 years - (months)>,\n",
       " 'RAIL_TF_NS10_BE': <DataflowDefinition ESTAT:RAIL_TF_NS10_BE(1.0): Train traffic on the rail network - Belgium (2010)>,\n",
       " 'EDAT_LFSO_09T3': <DataflowDefinition ESTAT:EDAT_LFSO_09T3(1.0): Employment rates by age, sex, educational attainment level and number of years after leaving formal education>,\n",
       " 'RAIL_TF_NS10_BG': <DataflowDefinition ESTAT:RAIL_TF_NS10_BG(1.0): Train traffic on the rail network - Bulgaria (2010)>,\n",
       " 'EDAT_LFS_9901': <DataflowDefinition ESTAT:EDAT_LFS_9901(1.0): Population by educational attainment level, sex and age (1 000)>,\n",
       " 'EDAT_LFS_9902': <DataflowDefinition ESTAT:EDAT_LFS_9902(1.0): Population by educational attainment level, sex, age and labour status (1 000)>,\n",
       " 'RAIL_TF_NS10_CH': <DataflowDefinition ESTAT:RAIL_TF_NS10_CH(1.0): Train traffic on the rail network - Switzerland (2010)>,\n",
       " 'EDAT_LFS_9903': <DataflowDefinition ESTAT:EDAT_LFS_9903(1.0): Population by educational attainment level, sex and age (%)>,\n",
       " 'EDAT_LFS_9904': <DataflowDefinition ESTAT:EDAT_LFS_9904(1.0): Population by educational attainment level, sex, age and labour status (%)>,\n",
       " 'RAIL_TF_NS10_CZ': <DataflowDefinition ESTAT:RAIL_TF_NS10_CZ(1.0): Train traffic on the rail network - Czech Republic (2010)>,\n",
       " 'EDAT_LFS_9905': <DataflowDefinition ESTAT:EDAT_LFS_9905(1.0): Employees by educational attainment level, sex, age and occupation (%)>,\n",
       " 'RAIL_TF_NS10_DE': <DataflowDefinition ESTAT:RAIL_TF_NS10_DE(1.0): Train traffic on the rail network - Germany (2010)>,\n",
       " 'EDAT_LFS_9906': <DataflowDefinition ESTAT:EDAT_LFS_9906(1.0): Employees by educational attainment level, sex, age and employment contract (%)>,\n",
       " 'RAIL_TF_NS10_DK': <DataflowDefinition ESTAT:RAIL_TF_NS10_DK(1.0): Train traffic on the rail network - Denmark (2010)>,\n",
       " 'RAIL_TF_NS10_EE': <DataflowDefinition ESTAT:RAIL_TF_NS10_EE(1.0): Train traffic on the rail network - Estonia (2010)>,\n",
       " 'EDAT_LFS_9907': <DataflowDefinition ESTAT:EDAT_LFS_9907(1.0): Employees by educational attainment level, sex, age and full-time/part-time employment (%)>,\n",
       " 'RAIL_TF_NS10_EL': <DataflowDefinition ESTAT:RAIL_TF_NS10_EL(1.0): Train traffic on the rail network - Greece (2010)>,\n",
       " 'EDAT_LFS_9908': <DataflowDefinition ESTAT:EDAT_LFS_9908(1.0): Employees by educational attainment level, sex, age and size of the local unit (%)>,\n",
       " 'RAIL_TF_NS10_ES': <DataflowDefinition ESTAT:RAIL_TF_NS10_ES(1.0): Train traffic on the rail network - Spain (2010)>,\n",
       " 'EDAT_LFS_9909': <DataflowDefinition ESTAT:EDAT_LFS_9909(1.0): Employees by educational attainment level, sex, age and NACE Rev. 1.1 activity (%)>,\n",
       " 'RAIL_TF_NS10_FI': <DataflowDefinition ESTAT:RAIL_TF_NS10_FI(1.0): Train traffic on the rail network - Finland (2010)>,\n",
       " 'RAIL_TF_NS10_FR': <DataflowDefinition ESTAT:RAIL_TF_NS10_FR(1.0): Train traffic on the rail network - France (2010)>,\n",
       " 'EDAT_LFS_9910': <DataflowDefinition ESTAT:EDAT_LFS_9910(1.0): Employees by educational attainment level, sex, age and NACE Rev. 2 activity (%)>,\n",
       " 'RAIL_TF_NS10_HR': <DataflowDefinition ESTAT:RAIL_TF_NS10_HR(1.0): Train traffic on the rail network - Croatia (2010)>,\n",
       " 'EDAT_LFS_9911': <DataflowDefinition ESTAT:EDAT_LFS_9911(1.0): Population by educational attainment level, sex, age and citizenship (%)>,\n",
       " 'RAIL_TF_NS10_HU': <DataflowDefinition ESTAT:RAIL_TF_NS10_HU(1.0): Train traffic on the rail network - Hungary (2010)>,\n",
       " 'HLTH_EHIS_PA6I': <DataflowDefinition ESTAT:HLTH_EHIS_PA6I(1.0): Self-reported last colonoscopy by sex, age and income quintile>,\n",
       " 'EDAT_LFS_9911$DV_1702': <DataflowDefinition ESTAT:EDAT_LFS_9911$DV_1702(1.0): Population by educational attainment level, sex, age and citizenship (%)>,\n",
       " 'RAIL_TF_NS10_IE': <DataflowDefinition ESTAT:RAIL_TF_NS10_IE(1.0): Train traffic on the rail network - Ireland (2010)>,\n",
       " 'EDAT_LFS_9912': <DataflowDefinition ESTAT:EDAT_LFS_9912(1.0): Population by educational attainment level, sex, age and country of birth (%)>,\n",
       " 'RAIL_TF_NS10_IT': <DataflowDefinition ESTAT:RAIL_TF_NS10_IT(1.0): Train traffic on the rail network - Italia (2010)>,\n",
       " 'EDAT_LFS_9912$DV_1703': <DataflowDefinition ESTAT:EDAT_LFS_9912$DV_1703(1.0): Population by educational attainment level, sex, age and country of birth (%)>,\n",
       " 'RAIL_TF_NS10_LI': <DataflowDefinition ESTAT:RAIL_TF_NS10_LI(1.0): Train traffic on the rail network - Liechtenstein (2010)>,\n",
       " 'HLTH_EHIS_PA6U': <DataflowDefinition ESTAT:HLTH_EHIS_PA6U(1.0): Self-reported last colonoscopy by sex, age and degree of urbanisation>,\n",
       " 'EDAT_LFS_9913': <DataflowDefinition ESTAT:EDAT_LFS_9913(1.0): Population by educational attainment level, sex, age and degree of urbanisation (%)>,\n",
       " 'RAIL_TF_NS10_LT': <DataflowDefinition ESTAT:RAIL_TF_NS10_LT(1.0): Train traffic on the rail network - Lithuania (2010)>,\n",
       " 'EDAT_LFS_9914': <DataflowDefinition ESTAT:EDAT_LFS_9914(1.0): Population aged 15-34 by educational attainment level, sex, age and programme orientation (%)>,\n",
       " 'HLTH_EHIS_PA7E': <DataflowDefinition ESTAT:HLTH_EHIS_PA7E(1.0): Self-reported last breast examination by X-ray among women by age and educational attainment level>,\n",
       " 'RAIL_TF_NS10_LU': <DataflowDefinition ESTAT:RAIL_TF_NS10_LU(1.0): Train traffic on the rail network - Luxembourg (2010)>,\n",
       " 'RAIL_TF_NS10_LV': <DataflowDefinition ESTAT:RAIL_TF_NS10_LV(1.0): Train traffic on the rail network - Latvia (2010)>,\n",
       " 'HLTH_EHIS_PA7I': <DataflowDefinition ESTAT:HLTH_EHIS_PA7I(1.0): Self-reported last breast examination by X-ray among women by age and income quintile>,\n",
       " 'RAIL_TF_NS10_MK': <DataflowDefinition ESTAT:RAIL_TF_NS10_MK(1.0): Train traffic on the rail network - the Former Yugoslav Republic of Macedonia (2010)>,\n",
       " 'EDAT_LFS_9915': <DataflowDefinition ESTAT:EDAT_LFS_9915(1.0): Population by educational attainment level, sex, age, country of birth and degree of urbanisation (%)>,\n",
       " 'RAIL_TF_NS10_NL': <DataflowDefinition ESTAT:RAIL_TF_NS10_NL(1.0): Train traffic on the rail network - Netherlands (2010)>,\n",
       " 'HLTH_EHIS_PA7U': <DataflowDefinition ESTAT:HLTH_EHIS_PA7U(1.0): Self-reported last breast examination by X-ray among women by age and degree of urbanisation>,\n",
       " 'EDAT_LFS_9916': <DataflowDefinition ESTAT:EDAT_LFS_9916(1.0): Population by educational attainment level, sex, age, citizenship and degree of urbanisation (%)>,\n",
       " 'RAIL_TF_NS10_NO': <DataflowDefinition ESTAT:RAIL_TF_NS10_NO(1.0): Train traffic on the rail network - Norway (2010)>,\n",
       " 'HLTH_EHIS_PA8E': <DataflowDefinition ESTAT:HLTH_EHIS_PA8E(1.0): Self-reported last cervical smear test among women by age and educational attainment level>,\n",
       " 'RAIL_TF_NS10_PL': <DataflowDefinition ESTAT:RAIL_TF_NS10_PL(1.0): Train traffic on the rail network - Poland (2010)>,\n",
       " 'EDAT_LFS_9917': <DataflowDefinition ESTAT:EDAT_LFS_9917(1.0): Population by educational attainment level, sex, age, country of birth and NUTS 2 regions (%)>,\n",
       " 'RAIL_TF_NS10_PT': <DataflowDefinition ESTAT:RAIL_TF_NS10_PT(1.0): Train traffic on the rail network - Portugal (2010)>,\n",
       " 'HLTH_EHIS_PA8I': <DataflowDefinition ESTAT:HLTH_EHIS_PA8I(1.0): Self-reported last cervical smear test among women by age and income quintile>,\n",
       " 'EDAT_LFS_9918': <DataflowDefinition ESTAT:EDAT_LFS_9918(1.0): Population by educational attainment level, sex, age, citizenship and NUTS 2 regions (%)>,\n",
       " 'RAIL_TF_NS10_RO': <DataflowDefinition ESTAT:RAIL_TF_NS10_RO(1.0): Train traffic on the rail network - Romania (2010)>,\n",
       " 'HLTH_EHIS_PA8U': <DataflowDefinition ESTAT:HLTH_EHIS_PA8U(1.0): Self-reported last cervical smear test among women by age and degree of urbanisation>,\n",
       " 'EDAT_LFS_9919': <DataflowDefinition ESTAT:EDAT_LFS_9919(1.0): Population aged 20-34 with work experience while studying by sex, age, educational attainment level and years since completion of highest level of education>,\n",
       " 'RAIL_TF_NS10_SE': <DataflowDefinition ESTAT:RAIL_TF_NS10_SE(1.0): Train traffic on the rail network - Sweden (2010)>,\n",
       " 'HLTH_EHIS_PC1D': <DataflowDefinition ESTAT:HLTH_EHIS_PC1D(1.0): Difficulties in personal care activities by sex, age and level of disability (activity limitation)>,\n",
       " 'EDUC_ENRL1AD': <DataflowDefinition ESTAT:EDUC_ENRL1AD(1.0): Students by ISCED level, study intensity and sex>,\n",
       " 'RAIL_TF_NS10_SI': <DataflowDefinition ESTAT:RAIL_TF_NS10_SI(1.0): Train traffic on the rail network - Slovenia (2010)>,\n",
       " 'EDUC_ENRL1AT': <DataflowDefinition ESTAT:EDUC_ENRL1AT(1.0): Students by ISCED level, type of institution and study intensity>,\n",
       " 'HLTH_EHIS_PC1E': <DataflowDefinition ESTAT:HLTH_EHIS_PC1E(1.0): Difficulties in personal care activities by sex, age and educational attainment level>,\n",
       " 'RAIL_TF_NS10_SK': <DataflowDefinition ESTAT:RAIL_TF_NS10_SK(1.0): Train traffic on the rail network - Slovakia (2010)>,\n",
       " 'HLTH_EHIS_PC1HCS': <DataflowDefinition ESTAT:HLTH_EHIS_PC1HCS(1.0): Difficulties in personal care activities by sex, age and use of home care services>,\n",
       " 'EDUC_ENRL1TL': <DataflowDefinition ESTAT:EDUC_ENRL1TL(1.0): Students by ISCED level, age and sex>,\n",
       " 'RAIL_TF_NS10_TR': <DataflowDefinition ESTAT:RAIL_TF_NS10_TR(1.0): Train traffic on the rail network - Türkiye (2010)>,\n",
       " 'HLTH_EHIS_PC1I': <DataflowDefinition ESTAT:HLTH_EHIS_PC1I(1.0): Difficulties in personal care activities by sex, age and income quintile>,\n",
       " 'RAIL_TF_NS10_UK': <DataflowDefinition ESTAT:RAIL_TF_NS10_UK(1.0): Train traffic on the rail network - United Kingdom (2010)>,\n",
       " 'HLTH_EHIS_PC1U': <DataflowDefinition ESTAT:HLTH_EHIS_PC1U(1.0): Difficulties in personal care activities by sex, age and degree of urbanisation>,\n",
       " ...}"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "flow_msg.dataflow"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<font size=\"3\">\n",
    "It is probably easier to look at them from a pandas DataFrame as shown below:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "MAR_GO_QM_MT      Gross weight of goods transported to/from main...\n",
       "MAR_GO_QM_NL      Gross weight of goods transported to/from main...\n",
       "MAR_GO_QM_NO      Gross weight of goods transported to/from main...\n",
       "MAR_GO_QM_PL      Gross weight of goods transported to/from main...\n",
       "MAR_GO_QM_PT      Gross weight of goods transported to/from main...\n",
       "                                        ...                        \n",
       "HLTH_EHIS_PA2U    Self-reported screening of cardiovascular dise...\n",
       "HLTH_EHIS_PA5E    Self-reported last colorectal cancer screening...\n",
       "HLTH_EHIS_PA5I    Self-reported last colorectal cancer screening...\n",
       "HLTH_EHIS_PA5U    Self-reported last colorectal cancer screening...\n",
       "HLTH_EHIS_PA6E    Self-reported last colonoscopy by sex, age and...\n",
       "Length: 7666, dtype: object"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataflows = pdmx.to_pandas(flow_msg.dataflow)\n",
    "dataflows"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<font size=\"3\">\n",
    "As you can see there are a lot of indicators. We can check if there are any related with GDP growth. For that, we can use the function str.contains() "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "TEC00115    Real GDP growth rate - volume\n",
       "dtype: object"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataflows[dataflows.str.contains('gdp growth', case=False)].head(30)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<font size=\"3\">\n",
    "Fortunately we found one indicator. Its name is \"Real GDP growth rate - volume\" and it has the identification code \"TEC00115\". We will use thise code to get the metadata related to it as shown below"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pandasdmx.StructureMessage>\n",
       "  <Header>\n",
       "    id: 'DSD1706813388'\n",
       "    prepared: '2024-02-01T18:49:48.756000+00:00'\n",
       "    sender: <Agency ESTAT>\n",
       "    source: \n",
       "    test: False\n",
       "  response: <Response [200]>\n",
       "  Codelist (5): FREQ UNIT NA_ITEM GEO OBS_FLAG\n",
       "  ConceptScheme (1): TEC00115\n",
       "  DataStructureDefinition (1): TEC00115"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "metadata = estat.datastructure('TEC00115')\n",
    "metadata"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<font size=\"3\">\n",
    "From the metadata information we can look at the last row, which is called DataStructureDefinition. In this case is the same identification code we found before. We need to use that code to download the data. We can also use the metadata to get the information of the different fields in the database using the method codelist."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'FREQ': <Codelist ESTAT:FREQ(3.2) (11 items): Time frequency>,\n",
       " 'UNIT': <Codelist ESTAT:UNIT(24.0) (714 items): Unit of measure>,\n",
       " 'NA_ITEM': <Codelist ESTAT:NA_ITEM(15.0) (665 items): National accounts indicator (ESA 2010)>,\n",
       " 'GEO': <Codelist ESTAT:GEO(17.0) (4089 items): Geopolitical entity (reporting)>,\n",
       " 'OBS_FLAG': <Codelist ESTAT:OBS_FLAG(1.33) (46 items): Observation status (Flag)>}"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "metadata.codelist"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<font size=\"3\">\n",
    "To download the information we can use the method \"data\". We can use the identification code we found before, and also a parameter to indicate which is the starting date"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "resp = estat.data(\n",
    "    'TEC00115',    \n",
    "    params={'startPeriod': '2000'},\n",
    "    )"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<font size=\"3\">\n",
    "We can transform the information into a pandas DataFrame to have a better visualization"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th>geo</th>\n",
       "      <th>AL</th>\n",
       "      <th>AT</th>\n",
       "      <th>BA</th>\n",
       "      <th>BE</th>\n",
       "      <th>BG</th>\n",
       "      <th>CH</th>\n",
       "      <th>CY</th>\n",
       "      <th>CZ</th>\n",
       "      <th>DE</th>\n",
       "      <th>DK</th>\n",
       "      <th>...</th>\n",
       "      <th>NO</th>\n",
       "      <th>PL</th>\n",
       "      <th>PT</th>\n",
       "      <th>RO</th>\n",
       "      <th>RS</th>\n",
       "      <th>SE</th>\n",
       "      <th>SI</th>\n",
       "      <th>SK</th>\n",
       "      <th>TR</th>\n",
       "      <th>UK</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>na_item</th>\n",
       "      <th>B1GQ</th>\n",
       "      <th>B1GQ</th>\n",
       "      <th>B1GQ</th>\n",
       "      <th>B1GQ</th>\n",
       "      <th>B1GQ</th>\n",
       "      <th>B1GQ</th>\n",
       "      <th>B1GQ</th>\n",
       "      <th>B1GQ</th>\n",
       "      <th>B1GQ</th>\n",
       "      <th>B1GQ</th>\n",
       "      <th>...</th>\n",
       "      <th>B1GQ</th>\n",
       "      <th>B1GQ</th>\n",
       "      <th>B1GQ</th>\n",
       "      <th>B1GQ</th>\n",
       "      <th>B1GQ</th>\n",
       "      <th>B1GQ</th>\n",
       "      <th>B1GQ</th>\n",
       "      <th>B1GQ</th>\n",
       "      <th>B1GQ</th>\n",
       "      <th>B1GQ</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unit</th>\n",
       "      <th>CLV_PCH_PRE</th>\n",
       "      <th>CLV_PCH_PRE</th>\n",
       "      <th>CLV_PCH_PRE</th>\n",
       "      <th>CLV_PCH_PRE</th>\n",
       "      <th>CLV_PCH_PRE</th>\n",
       "      <th>CLV_PCH_PRE</th>\n",
       "      <th>CLV_PCH_PRE</th>\n",
       "      <th>CLV_PCH_PRE</th>\n",
       "      <th>CLV_PCH_PRE</th>\n",
       "      <th>CLV_PCH_PRE</th>\n",
       "      <th>...</th>\n",
       "      <th>CLV_PCH_PRE_HAB</th>\n",
       "      <th>CLV_PCH_PRE_HAB</th>\n",
       "      <th>CLV_PCH_PRE_HAB</th>\n",
       "      <th>CLV_PCH_PRE_HAB</th>\n",
       "      <th>CLV_PCH_PRE_HAB</th>\n",
       "      <th>CLV_PCH_PRE_HAB</th>\n",
       "      <th>CLV_PCH_PRE_HAB</th>\n",
       "      <th>CLV_PCH_PRE_HAB</th>\n",
       "      <th>CLV_PCH_PRE_HAB</th>\n",
       "      <th>CLV_PCH_PRE_HAB</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TIME_PERIOD</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2012</th>\n",
       "      <td>1.4</td>\n",
       "      <td>0.7</td>\n",
       "      <td>-0.8</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.7</td>\n",
       "      <td>1.2</td>\n",
       "      <td>-3.4</td>\n",
       "      <td>-0.8</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.2</td>\n",
       "      <td>...</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.5</td>\n",
       "      <td>-3.7</td>\n",
       "      <td>2.4</td>\n",
       "      <td>-0.2</td>\n",
       "      <td>-1.3</td>\n",
       "      <td>-2.8</td>\n",
       "      <td>1.2</td>\n",
       "      <td>3.5</td>\n",
       "      <td>0.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.3</td>\n",
       "      <td>0.5</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>1.8</td>\n",
       "      <td>-6.6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.9</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.2</td>\n",
       "      <td>0.9</td>\n",
       "      <td>-0.4</td>\n",
       "      <td>0.6</td>\n",
       "      <td>3.4</td>\n",
       "      <td>0.3</td>\n",
       "      <td>-1.2</td>\n",
       "      <td>0.5</td>\n",
       "      <td>7.1</td>\n",
       "      <td>1.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014</th>\n",
       "      <td>1.8</td>\n",
       "      <td>0.7</td>\n",
       "      <td>1.2</td>\n",
       "      <td>1.6</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2.3</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.2</td>\n",
       "      <td>1.6</td>\n",
       "      <td>...</td>\n",
       "      <td>0.9</td>\n",
       "      <td>3.9</td>\n",
       "      <td>1.3</td>\n",
       "      <td>4.5</td>\n",
       "      <td>-1.1</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.6</td>\n",
       "      <td>3.5</td>\n",
       "      <td>2.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015</th>\n",
       "      <td>2.2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>1.6</td>\n",
       "      <td>3.4</td>\n",
       "      <td>5.4</td>\n",
       "      <td>1.5</td>\n",
       "      <td>2.3</td>\n",
       "      <td>...</td>\n",
       "      <td>0.8</td>\n",
       "      <td>4.5</td>\n",
       "      <td>2.2</td>\n",
       "      <td>3.7</td>\n",
       "      <td>2.3</td>\n",
       "      <td>3.4</td>\n",
       "      <td>2.1</td>\n",
       "      <td>5.1</td>\n",
       "      <td>4.7</td>\n",
       "      <td>1.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016</th>\n",
       "      <td>3.3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.2</td>\n",
       "      <td>1.3</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>6.6</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.2</td>\n",
       "      <td>3.2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.3</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.3</td>\n",
       "      <td>3.5</td>\n",
       "      <td>3.9</td>\n",
       "      <td>0.8</td>\n",
       "      <td>3.1</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.9</td>\n",
       "      <td>0.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017</th>\n",
       "      <td>3.8</td>\n",
       "      <td>2.3</td>\n",
       "      <td>3.2</td>\n",
       "      <td>1.6</td>\n",
       "      <td>2.7</td>\n",
       "      <td>1.4</td>\n",
       "      <td>5.7</td>\n",
       "      <td>5.2</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.8</td>\n",
       "      <td>...</td>\n",
       "      <td>1.7</td>\n",
       "      <td>5.2</td>\n",
       "      <td>3.8</td>\n",
       "      <td>8.8</td>\n",
       "      <td>2.6</td>\n",
       "      <td>1.2</td>\n",
       "      <td>4.8</td>\n",
       "      <td>2.8</td>\n",
       "      <td>6.1</td>\n",
       "      <td>1.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018</th>\n",
       "      <td>4.0</td>\n",
       "      <td>2.4</td>\n",
       "      <td>3.8</td>\n",
       "      <td>1.8</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.9</td>\n",
       "      <td>5.6</td>\n",
       "      <td>3.2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.2</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.6</td>\n",
       "      <td>5.1</td>\n",
       "      <td>0.8</td>\n",
       "      <td>4.1</td>\n",
       "      <td>3.9</td>\n",
       "      <td>1.6</td>\n",
       "      <td>0.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019</th>\n",
       "      <td>2.1</td>\n",
       "      <td>1.5</td>\n",
       "      <td>2.9</td>\n",
       "      <td>2.2</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.1</td>\n",
       "      <td>5.5</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.1</td>\n",
       "      <td>1.5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.4</td>\n",
       "      <td>4.5</td>\n",
       "      <td>2.7</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4.9</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.4</td>\n",
       "      <td>-0.6</td>\n",
       "      <td>0.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020</th>\n",
       "      <td>-3.5</td>\n",
       "      <td>-6.6</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>-5.3</td>\n",
       "      <td>-4.0</td>\n",
       "      <td>-2.1</td>\n",
       "      <td>-3.4</td>\n",
       "      <td>-5.5</td>\n",
       "      <td>-3.8</td>\n",
       "      <td>-2.4</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.8</td>\n",
       "      <td>-1.9</td>\n",
       "      <td>-8.4</td>\n",
       "      <td>-3.2</td>\n",
       "      <td>-0.2</td>\n",
       "      <td>-2.9</td>\n",
       "      <td>-4.9</td>\n",
       "      <td>-3.5</td>\n",
       "      <td>0.9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021</th>\n",
       "      <td>NaN</td>\n",
       "      <td>4.2</td>\n",
       "      <td>7.4</td>\n",
       "      <td>6.9</td>\n",
       "      <td>7.7</td>\n",
       "      <td>5.4</td>\n",
       "      <td>9.9</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.2</td>\n",
       "      <td>6.8</td>\n",
       "      <td>...</td>\n",
       "      <td>3.4</td>\n",
       "      <td>7.5</td>\n",
       "      <td>5.8</td>\n",
       "      <td>6.6</td>\n",
       "      <td>8.7</td>\n",
       "      <td>5.5</td>\n",
       "      <td>8.0</td>\n",
       "      <td>5.2</td>\n",
       "      <td>10.4</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022</th>\n",
       "      <td>NaN</td>\n",
       "      <td>4.8</td>\n",
       "      <td>4.2</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.9</td>\n",
       "      <td>2.6</td>\n",
       "      <td>5.1</td>\n",
       "      <td>2.4</td>\n",
       "      <td>1.8</td>\n",
       "      <td>2.7</td>\n",
       "      <td>...</td>\n",
       "      <td>2.1</td>\n",
       "      <td>6.2</td>\n",
       "      <td>6.8</td>\n",
       "      <td>4.5</td>\n",
       "      <td>5.2</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2.4</td>\n",
       "      <td>0.9</td>\n",
       "      <td>4.5</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>12 rows × 80 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "geo                  AL          AT          BA          BE          BG  \\\n",
       "na_item            B1GQ        B1GQ        B1GQ        B1GQ        B1GQ   \n",
       "unit        CLV_PCH_PRE CLV_PCH_PRE CLV_PCH_PRE CLV_PCH_PRE CLV_PCH_PRE   \n",
       "TIME_PERIOD                                                               \n",
       "2012                1.4         0.7        -0.8         0.7         0.7   \n",
       "2013                1.0         0.0         2.3         0.5        -0.5   \n",
       "2014                1.8         0.7         1.2         1.6         0.9   \n",
       "2015                2.2         1.0         4.3         2.0         3.4   \n",
       "2016                3.3         2.0         3.2         1.3         3.0   \n",
       "2017                3.8         2.3         3.2         1.6         2.7   \n",
       "2018                4.0         2.4         3.8         1.8         2.7   \n",
       "2019                2.1         1.5         2.9         2.2         4.0   \n",
       "2020               -3.5        -6.6        -3.0        -5.3        -4.0   \n",
       "2021                NaN         4.2         7.4         6.9         7.7   \n",
       "2022                NaN         4.8         4.2         3.0         3.9   \n",
       "2023                NaN         NaN         NaN         NaN         NaN   \n",
       "\n",
       "geo                  CH          CY          CZ          DE          DK  ...  \\\n",
       "na_item            B1GQ        B1GQ        B1GQ        B1GQ        B1GQ  ...   \n",
       "unit        CLV_PCH_PRE CLV_PCH_PRE CLV_PCH_PRE CLV_PCH_PRE CLV_PCH_PRE  ...   \n",
       "TIME_PERIOD                                                              ...   \n",
       "2012                1.2        -3.4        -0.8         0.4         0.2  ...   \n",
       "2013                1.8        -6.6         0.0         0.4         0.9  ...   \n",
       "2014                2.3        -1.8         2.3         2.2         1.6  ...   \n",
       "2015                1.6         3.4         5.4         1.5         2.3  ...   \n",
       "2016                2.1         6.6         2.5         2.2         3.2  ...   \n",
       "2017                1.4         5.7         5.2         2.7         2.8  ...   \n",
       "2018                2.9         5.6         3.2         1.0         2.0  ...   \n",
       "2019                1.1         5.5         3.0         1.1         1.5  ...   \n",
       "2020               -2.1        -3.4        -5.5        -3.8        -2.4  ...   \n",
       "2021                5.4         9.9         3.6         3.2         6.8  ...   \n",
       "2022                2.6         5.1         2.4         1.8         2.7  ...   \n",
       "2023                NaN         NaN         NaN        -0.3         NaN  ...   \n",
       "\n",
       "geo                      NO              PL              PT              RO  \\\n",
       "na_item                B1GQ            B1GQ            B1GQ            B1GQ   \n",
       "unit        CLV_PCH_PRE_HAB CLV_PCH_PRE_HAB CLV_PCH_PRE_HAB CLV_PCH_PRE_HAB   \n",
       "TIME_PERIOD                                                                   \n",
       "2012                    1.4             1.5            -3.7             2.4   \n",
       "2013                   -0.2             0.9            -0.4             0.6   \n",
       "2014                    0.9             3.9             1.3             4.5   \n",
       "2015                    0.8             4.5             2.2             3.7   \n",
       "2016                    0.3             3.0             2.3             3.5   \n",
       "2017                    1.7             5.2             3.8             8.8   \n",
       "2018                    0.2             6.0             3.0             6.6   \n",
       "2019                    0.4             4.5             2.7             4.3   \n",
       "2020                   -1.8            -1.9            -8.4            -3.2   \n",
       "2021                    3.4             7.5             5.8             6.6   \n",
       "2022                    2.1             6.2             6.8             4.5   \n",
       "2023                    NaN             NaN             NaN             NaN   \n",
       "\n",
       "geo                      RS              SE              SI              SK  \\\n",
       "na_item                B1GQ            B1GQ            B1GQ            B1GQ   \n",
       "unit        CLV_PCH_PRE_HAB CLV_PCH_PRE_HAB CLV_PCH_PRE_HAB CLV_PCH_PRE_HAB   \n",
       "TIME_PERIOD                                                                   \n",
       "2012                   -0.2            -1.3            -2.8             1.2   \n",
       "2013                    3.4             0.3            -1.2             0.5   \n",
       "2014                   -1.1             1.6             2.7             2.6   \n",
       "2015                    2.3             3.4             2.1             5.1   \n",
       "2016                    3.9             0.8             3.1             1.8   \n",
       "2017                    2.6             1.2             4.8             2.8   \n",
       "2018                    5.1             0.8             4.1             3.9   \n",
       "2019                    4.9             1.0             2.7             2.4   \n",
       "2020                   -0.2            -2.9            -4.9            -3.5   \n",
       "2021                    8.7             5.5             8.0             5.2   \n",
       "2022                    5.2             2.2             2.4             0.9   \n",
       "2023                    NaN             NaN             NaN             NaN   \n",
       "\n",
       "geo                      TR              UK  \n",
       "na_item                B1GQ            B1GQ  \n",
       "unit        CLV_PCH_PRE_HAB CLV_PCH_PRE_HAB  \n",
       "TIME_PERIOD                                  \n",
       "2012                    3.5             0.8  \n",
       "2013                    7.1             1.5  \n",
       "2014                    3.5             2.1  \n",
       "2015                    4.7             1.6  \n",
       "2016                    1.9             0.9  \n",
       "2017                    6.1             1.1  \n",
       "2018                    1.6             0.6  \n",
       "2019                   -0.6             0.8  \n",
       "2020                    0.9             NaN  \n",
       "2021                   10.4             NaN  \n",
       "2022                    4.5             NaN  \n",
       "2023                    NaN             NaN  \n",
       "\n",
       "[12 rows x 80 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = resp.to_pandas(datetime={'dim': 'TIME_PERIOD', 'freq': 'freq'})\n",
    "data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<font size=\"3\">\n",
    "We can use the pandas xs method to return a specified section of the DataFrame. In this case we will filter by country, selecting only \"DE\" which stands for Germany"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th>geo</th>\n",
       "      <th colspan=\"2\" halign=\"left\">DE</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>na_item</th>\n",
       "      <th colspan=\"2\" halign=\"left\">B1GQ</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unit</th>\n",
       "      <th>CLV_PCH_PRE</th>\n",
       "      <th>CLV_PCH_PRE_HAB</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TIME_PERIOD</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2012</th>\n",
       "      <td>0.4</td>\n",
       "      <td>0.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>0.4</td>\n",
       "      <td>0.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014</th>\n",
       "      <td>2.2</td>\n",
       "      <td>1.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015</th>\n",
       "      <td>1.5</td>\n",
       "      <td>0.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016</th>\n",
       "      <td>2.2</td>\n",
       "      <td>1.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017</th>\n",
       "      <td>2.7</td>\n",
       "      <td>2.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019</th>\n",
       "      <td>1.1</td>\n",
       "      <td>0.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020</th>\n",
       "      <td>-3.8</td>\n",
       "      <td>-3.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021</th>\n",
       "      <td>3.2</td>\n",
       "      <td>3.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022</th>\n",
       "      <td>1.8</td>\n",
       "      <td>1.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023</th>\n",
       "      <td>-0.3</td>\n",
       "      <td>-1.2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "geo                  DE                \n",
       "na_item            B1GQ                \n",
       "unit        CLV_PCH_PRE CLV_PCH_PRE_HAB\n",
       "TIME_PERIOD                            \n",
       "2012                0.4             0.2\n",
       "2013                0.4             0.2\n",
       "2014                2.2             1.8\n",
       "2015                1.5             0.6\n",
       "2016                2.2             1.4\n",
       "2017                2.7             2.3\n",
       "2018                1.0             0.7\n",
       "2019                1.1             0.8\n",
       "2020               -3.8            -3.9\n",
       "2021                3.2             3.1\n",
       "2022                1.8             1.1\n",
       "2023               -0.3            -1.2"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.xs('DE',  axis=1, drop_level=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<font size=\"3\">\n",
    "Here we got the historical dataseries of the GDP growth of Germany. However, we got 2 different dataseries. To explore what they are, we can apply a simple filter using the code below"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>UNIT</th>\n",
       "      <th>name</th>\n",
       "      <th>parent</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>688</th>\n",
       "      <td>CLV_PCH_PRE</td>\n",
       "      <td>Chain linked volumes, percentage change on pre...</td>\n",
       "      <td>UNIT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>691</th>\n",
       "      <td>CLV_PCH_PRE_HAB</td>\n",
       "      <td>Chain linked volumes, percentage change on pre...</td>\n",
       "      <td>UNIT</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                UNIT                                               name parent\n",
       "688      CLV_PCH_PRE  Chain linked volumes, percentage change on pre...   UNIT\n",
       "691  CLV_PCH_PRE_HAB  Chain linked volumes, percentage change on pre...   UNIT"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df  = pdmx.to_pandas(metadata.codelist['UNIT'])\n",
    "df.reset_index(inplace=True)\n",
    "df1 = df.loc[(df['UNIT']=='CLV_PCH_PRE_HAB')|(df['UNIT']=='CLV_PCH_PRE')]\n",
    "df1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<font size=\"3\">\n",
    "In the previous code we put the information into a pandas DataFrame first. Then we used the reset_index() method and finally used the \"UNIT\" column to apply a filter on it. The filter used the or operator | on both names we got. And to identifie the detail of those name we can do the following"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Chain linked volumes, percentage change on previous period\n",
      "Chain linked volumes, percentage change on previous period, per capita\n"
     ]
    }
   ],
   "source": [
    "print(df1.iloc[0]['name'])\n",
    "print(df1.iloc[1]['name'])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## **Download information from the BIS database**\n",
    "\n",
    "\n",
    "<font size=\"3\">\n",
    "To download information from the BIS database we can do pretty much the same. Follow the steps we showed before"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'WS_CBPOL_D': <DataflowDefinition BIS:WS_CBPOL_D(1.0): Policy rates daily>,\n",
       " 'WS_CBPOL_M': <DataflowDefinition BIS:WS_CBPOL_M(1.0): Policy rates monthly>,\n",
       " 'WS_CBS_PUB': <DataflowDefinition BIS:WS_CBS_PUB(1.0): BIS consolidated banking>,\n",
       " 'WS_CPMI_CASHLESS': <DataflowDefinition BIS:WS_CPMI_CASHLESS(1.0): CPMI cashless payments (T5-6)>,\n",
       " 'WS_CPMI_CT1': <DataflowDefinition BIS:WS_CPMI_CT1(1.0): CPMI comparative tables type 1>,\n",
       " 'WS_CPMI_CT2': <DataflowDefinition BIS:WS_CPMI_CT2(1.0): CPMI comparative tables type 2>,\n",
       " 'WS_CPMI_DEVICES': <DataflowDefinition BIS:WS_CPMI_DEVICES(1.0): CPMI payment devices>,\n",
       " 'WS_CPMI_INSTITUTIONS': <DataflowDefinition BIS:WS_CPMI_INSTITUTIONS(1.0): CPMI institutions>,\n",
       " 'WS_CPMI_MACRO': <DataflowDefinition BIS:WS_CPMI_MACRO(1.0): CPMI Macro>,\n",
       " 'WS_CPMI_PARTICIPANTS': <DataflowDefinition BIS:WS_CPMI_PARTICIPANTS(1.0): CPMI participants>,\n",
       " 'WS_CPMI_SYSTEMS': <DataflowDefinition BIS:WS_CPMI_SYSTEMS(1.0): CPMI systems (T8-9-11-13-14-16-17-18-19)>,\n",
       " 'WS_CPP': <DataflowDefinition BIS:WS_CPP(1.0): Commercial property prices>,\n",
       " 'WS_CREDIT_GAP': <DataflowDefinition BIS:WS_CREDIT_GAP(1.0): BIS credit-to-GDP gaps>,\n",
       " 'WS_DEBT_SEC2_PUB': <DataflowDefinition BIS:WS_DEBT_SEC2_PUB(1.0): BIS debt securities>,\n",
       " 'WS_DER_OTC_TOV': <DataflowDefinition BIS:WS_DER_OTC_TOV(1.0): OTC derivatives turnover>,\n",
       " 'WS_DPP': <DataflowDefinition BIS:WS_DPP(1.0): Detailed residential property prices>,\n",
       " 'WS_DSR': <DataflowDefinition BIS:WS_DSR(1.0): BIS debt service ratio>,\n",
       " 'WS_EER_D': <DataflowDefinition BIS:WS_EER_D(1.0): BIS effective exchange rates daily>,\n",
       " 'WS_EER_M': <DataflowDefinition BIS:WS_EER_M(1.0): BIS effective exchange rates monthly>,\n",
       " 'WS_GLI': <DataflowDefinition BIS:WS_GLI(1.0): Global liquidity indicators>,\n",
       " 'WS_LBS_D_PUB': <DataflowDefinition BIS:WS_LBS_D_PUB(1.0): BIS locational banking>,\n",
       " 'WS_LONG_CPI': <DataflowDefinition BIS:WS_LONG_CPI(1.0): BIS long consumer prices>,\n",
       " 'WS_NA_SEC_DSS': <DataflowDefinition BIS:WS_NA_SEC_DSS(1.0): Debt securities statistics>,\n",
       " 'WS_OTC_DERIV2': <DataflowDefinition BIS:WS_OTC_DERIV2(1.0): OTC derivatives outstanding>,\n",
       " 'WS_SPP': <DataflowDefinition BIS:WS_SPP(1.0): BIS property prices: selected series>,\n",
       " 'WS_TC': <DataflowDefinition BIS:WS_TC(2.0): BIS long series on total credit>,\n",
       " 'WS_XRU': <DataflowDefinition BIS:WS_XRU(1.0): US dollar exchange rates, m,q,a>,\n",
       " 'WS_XRU_D': <DataflowDefinition BIS:WS_XRU_D(1.0): US dollar exchange rates, daily>,\n",
       " 'WS_XTD_DERIV': <DataflowDefinition BIS:WS_XTD_DERIV(1.0): Exchange traded derivatives>}"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bis = pdmx.Request(\"BIS\")\n",
    "flow_msg1 = bis.dataflow()\n",
    "flow_msg1.dataflow"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<font size=\"3\">\n",
    "Here we selected the BIS effective exchange rate daily with identification code \"WS_EER_D\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pandasdmx.StructureMessage>\n",
       "  <Header>\n",
       "    id: 'IDREFb132ffdd-9d8b-4aaf-b73b-f1d9457afa40'\n",
       "    prepared: '2024-02-02T12:02:30+00:00'\n",
       "    receiver: <Agency not_supplied>\n",
       "    sender: <Agency UNKNOWN>\n",
       "    source: \n",
       "    test: False\n",
       "  response: <Response [200]>\n",
       "  Categorisation (1): 2fa0f830-cd9c-632e-dffd-bceebf593440\n",
       "  CategoryScheme (1): BISWEB_CATSCHEME\n",
       "  Codelist (9): CL_AREA CL_BIS_UNIT CL_COLLECTION CL_CONF_STATUS CL_EER...\n",
       "  ConceptScheme (1): STANDALONE_CONCEPT_SCHEME\n",
       "  ContentConstraint (2): EER_D_NOM_BRO EER_D_NOM_NAR\n",
       "  DataflowDefinition (1): WS_EER_D\n",
       "  DataStructureDefinition (1): BIS_EER\n",
       "  AgencyScheme (1): AGENCIES"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "WS_EER_D_msg = bis.dataflow('WS_EER_D')\n",
    "WS_EER_D_msg"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "metadata2 = bis.datastructure('BIS_EER')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<font size=\"3\">\n",
    "From the metadata information we will also get the dimensions. This is a little different than we did before, but we need that information for the BIS database, since the identification code refers to one of the components of the dimensions."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "dsd = WS_EER_D_msg.dataflow.WS_EER_D.structure"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<font size=\"3\">\n",
    "Here we can see that one dimension component if REF_AREA. This probably is related to the country. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[<Dimension FREQ>,\n",
       " <Dimension EER_TYPE>,\n",
       " <Dimension EER_BASKET>,\n",
       " <Dimension REF_AREA>,\n",
       " <TimeDimension TIME_PERIOD>]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dsd.dimensions.components"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<font size=\"3\">\n",
    "Let's confirm if that is indeed the case"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CL_AREA</th>\n",
       "      <th>name</th>\n",
       "      <th>parent</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1X</td>\n",
       "      <td>ECB</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4T</td>\n",
       "      <td>Emerging market economies (aggregate)</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5A</td>\n",
       "      <td>All reporting economies</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5R</td>\n",
       "      <td>Advanced economies</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AE</td>\n",
       "      <td>United Arab Emirates</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>AL</td>\n",
       "      <td>Albania</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>AR</td>\n",
       "      <td>Argentina</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>AT</td>\n",
       "      <td>Austria</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>AU</td>\n",
       "      <td>Australia</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>BA</td>\n",
       "      <td>Bosnia &amp; Herzegovina</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>BE</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>BE2</td>\n",
       "      <td>Flanders</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>BE3</td>\n",
       "      <td>Wallonia</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>BG</td>\n",
       "      <td>Bulgaria</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>BH</td>\n",
       "      <td>Bahrain</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>BM</td>\n",
       "      <td>Bermuda</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>BR</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>BS</td>\n",
       "      <td>Bahamas</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>BY</td>\n",
       "      <td>Belarus</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>CA</td>\n",
       "      <td>Canada</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>CH</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>CL</td>\n",
       "      <td>Chile</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>CN</td>\n",
       "      <td>China</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>CO</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>CS</td>\n",
       "      <td>Serbia &amp; Montenegro</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>CY</td>\n",
       "      <td>Cyprus</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>CZ</td>\n",
       "      <td>Czechia</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>DE</td>\n",
       "      <td>Germany</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>DEZ1</td>\n",
       "      <td>West Germany</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>DEZ2</td>\n",
       "      <td>East Germany</td>\n",
       "      <td>CL_AREA</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   CL_AREA                                   name   parent\n",
       "0       1X                                    ECB  CL_AREA\n",
       "1       4T  Emerging market economies (aggregate)  CL_AREA\n",
       "2       5A                All reporting economies  CL_AREA\n",
       "3       5R                     Advanced economies  CL_AREA\n",
       "4       AE                   United Arab Emirates  CL_AREA\n",
       "5       AL                                Albania  CL_AREA\n",
       "6       AR                              Argentina  CL_AREA\n",
       "7       AT                                Austria  CL_AREA\n",
       "8       AU                              Australia  CL_AREA\n",
       "9       BA                   Bosnia & Herzegovina  CL_AREA\n",
       "10      BE                                Belgium  CL_AREA\n",
       "11     BE2                               Flanders  CL_AREA\n",
       "12     BE3                               Wallonia  CL_AREA\n",
       "13      BG                               Bulgaria  CL_AREA\n",
       "14      BH                                Bahrain  CL_AREA\n",
       "15      BM                                Bermuda  CL_AREA\n",
       "16      BR                                 Brazil  CL_AREA\n",
       "17      BS                                Bahamas  CL_AREA\n",
       "18      BY                                Belarus  CL_AREA\n",
       "19      CA                                 Canada  CL_AREA\n",
       "20      CH                            Switzerland  CL_AREA\n",
       "21      CL                                  Chile  CL_AREA\n",
       "22      CN                                  China  CL_AREA\n",
       "23      CO                               Colombia  CL_AREA\n",
       "24      CS                    Serbia & Montenegro  CL_AREA\n",
       "25      CY                                 Cyprus  CL_AREA\n",
       "26      CZ                                Czechia  CL_AREA\n",
       "27      DE                                Germany  CL_AREA\n",
       "28    DEZ1                           West Germany  CL_AREA\n",
       "29    DEZ2                           East Germany  CL_AREA"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cl = dsd.dimensions.get('REF_AREA').local_representation.enumerated\n",
    "pdmx.to_pandas(cl).reset_index().head(30)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<font size=\"3\">\n",
    "Now we are ready to download the information as we did before with the EUROSTAT database. Here we will show that we can download the information for specific values of the indicator. In this case we are only downloading information for 2 countries: Germany and Austria, \"DE\" and \"AT\"."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th>EER_TYPE</th>\n",
       "      <th colspan=\"4\" halign=\"left\">N</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EER_BASKET</th>\n",
       "      <th colspan=\"2\" halign=\"left\">N</th>\n",
       "      <th colspan=\"2\" halign=\"left\">B</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>REF_AREA</th>\n",
       "      <th>DE</th>\n",
       "      <th>AT</th>\n",
       "      <th>DE</th>\n",
       "      <th>AT</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TIME_PERIOD</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2016-01-01</th>\n",
       "      <td>97.71</td>\n",
       "      <td>98.90</td>\n",
       "      <td>94.39</td>\n",
       "      <td>96.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-01-02</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-01-03</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-01-04</th>\n",
       "      <td>97.82</td>\n",
       "      <td>98.97</td>\n",
       "      <td>94.63</td>\n",
       "      <td>96.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-01-05</th>\n",
       "      <td>97.38</td>\n",
       "      <td>98.73</td>\n",
       "      <td>94.06</td>\n",
       "      <td>96.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-01-25</th>\n",
       "      <td>100.02</td>\n",
       "      <td>99.70</td>\n",
       "      <td>102.64</td>\n",
       "      <td>101.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-01-26</th>\n",
       "      <td>99.92</td>\n",
       "      <td>99.64</td>\n",
       "      <td>102.53</td>\n",
       "      <td>101.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-01-27</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-01-28</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-01-29</th>\n",
       "      <td>99.77</td>\n",
       "      <td>99.54</td>\n",
       "      <td>102.36</td>\n",
       "      <td>101.11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2951 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "EER_TYPE          N                       \n",
       "EER_BASKET        N              B        \n",
       "REF_AREA         DE     AT      DE      AT\n",
       "TIME_PERIOD                               \n",
       "2016-01-01    97.71  98.90   94.39   96.72\n",
       "2016-01-02      NaN    NaN     NaN     NaN\n",
       "2016-01-03      NaN    NaN     NaN     NaN\n",
       "2016-01-04    97.82  98.97   94.63   96.87\n",
       "2016-01-05    97.38  98.73   94.06   96.51\n",
       "...             ...    ...     ...     ...\n",
       "2024-01-25   100.02  99.70  102.64  101.28\n",
       "2024-01-26    99.92  99.64  102.53  101.21\n",
       "2024-01-27      NaN    NaN     NaN     NaN\n",
       "2024-01-28      NaN    NaN     NaN     NaN\n",
       "2024-01-29    99.77  99.54  102.36  101.11\n",
       "\n",
       "[2951 rows x 4 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "key = dict(REF_AREA =['DE', 'AT'])\n",
    "params = dict(startPeriod='2016')\n",
    "\n",
    "bis = pdmx.Request('BIS')\n",
    "data_msg2 = bis.data('WS_EER_D', key=key, params=params)\n",
    "data = data_msg2.to_pandas(datetime={'dim': 'TIME_PERIOD', 'freq': 'FREQ'})\n",
    "data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "If this content is helpful and you want to make a donation please click on the button\n",
    "\n",
    "[![paypal](https://www.paypalobjects.com/en_US/i/btn/btn_donateCC_LG.gif)](https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=29CVY97MEQ9BY)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}