Nomis API Tutorial.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Nomis API Tutorial\n",
    "\n",
    "This is a tutorial on accessing data from the NOMIS API. Nomis is a service provided by the Office for National Statistics, ONS, to give you free access to the most detailed and up-to-date UK labour market statistics from official sources.\n",
    "\n",
    "https://www.nomisweb.co.uk/api/v01/help"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests as rq\n",
    "import pandas as pd\n",
    "from fuzzywuzzy import fuzz\n",
    "\n",
    "pd.set_option('display.max_rows', 100)\n",
    "pd.set_option('display.max_columns', None)\n",
    "pd.set_option('display.width', None)\n",
    "pd.set_option('display.max_colwidth', None)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Listing all data in NOMIS\n",
    "\n",
    "Data sets in NOMIS have an ID, name, and description which are useful parameters to use when searching for different data sets. NOMIS stores this uesful information in objects it calls \"key families\". We can build a function that will get the ID, name, and description of all the data sets in NOMIS so that we can search them locally on our computer. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "def list_data_sets():\n",
    "    \n",
    "    # This function obtains a list of all the NOMIS datasets available\n",
    "    \n",
    "    # Make the request to the API\n",
    "    root = \"http://www.nomisweb.co.uk\"\n",
    "    ext = \"/api/v01/dataset/def.sdmx.json\"\n",
    "    response = rq.get(root + ext).json()\n",
    "    \n",
    "    # Process the response to get the useful info from the key families if it is available\n",
    "    keyFams = response['structure']['keyfamilies']['keyfamily']\n",
    "    data_sets = []\n",
    "    meta_data = {}\n",
    "    for keyFam in keyFams:\n",
    "\n",
    "        row = {}\n",
    "        \n",
    "        try:\n",
    "            row['description'] = keyFam['description']['value']         \n",
    "        except:\n",
    "            pass\n",
    "            \n",
    "\n",
    "        try:\n",
    "            row['id'] = keyFam['id']\n",
    "            meta_data[keyFam['id']] = {}\n",
    "        except:\n",
    "            pass\n",
    "            \n",
    "\n",
    "        try:\n",
    "            row['name'] = keyFam['name']['value']       \n",
    "        except:\n",
    "            pass\n",
    "        \n",
    "        \n",
    "        data_sets.append(row)\n",
    "           \n",
    "            \n",
    "        try:\n",
    "            annotations = keyFam['annotations']['annotation']\n",
    "            for anotation in annotations:\n",
    "                meta_data[keyFam['id']][anotation['annotationtitle']] = anotation['annotationtext']\n",
    "        except:\n",
    "            pass\n",
    "\n",
    "        \n",
    "        try:\n",
    "            components = keyFam['components']\n",
    "            meta_data[keyFam['id']]['dimensions'] = []\n",
    "            for dimension in components['dimension']:\n",
    "                meta_data[keyFam['id']]['dimensions'].append(dimension['conceptref'])\n",
    "\n",
    "            meta_data[keyFam['id']]['primarymeasure'] = components['primarymeasure']['conceptref']\n",
    "            meta_data[keyFam['id']]['timedimension'] = components['timedimension']['conceptref']\n",
    "        except:\n",
    "            pass\n",
    "\n",
    "                    \n",
    "    return data_sets, meta_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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 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>description</th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Records the number of people claiming Jobseeker's Allowance (JSA) and National Insurance credits at Jobcentre Plus local offices. This is not an official measure of unemployment, but is the only indicative statistic available for areas smaller than Local Authorities.</td>\n",
       "      <td>NM_1_1</td>\n",
       "      <td>Jobseeker's Allowance with rates and proportions</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>A quartery count of claimants who were claiming Jobseeker's Allowance on the count date analysed by their age and the duration.</td>\n",
       "      <td>NM_2_1</td>\n",
       "      <td>claimant count - age and duration</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>A monthly count of Jobseeker's Allowance (JSA) claimants broken down by age and the duration of claim. Totals exclude non-computerised clerical claims (approx. 1%). Available for areas smaller than Local Authorities.</td>\n",
       "      <td>NM_4_1</td>\n",
       "      <td>Jobseeker's Allowance by age and duration</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>A midyear estimate of the workforce (the denominator) which was used for calculating claimant count rates prior to January 2003. The estimates are broken down by sex but not age.</td>\n",
       "      <td>NM_5_1</td>\n",
       "      <td>claimant count denominators - historical workforce series</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>A quarterly count of  Jobseeker's Allowance claimants analysed by their sought and usual occupation.</td>\n",
       "      <td>NM_6_1</td>\n",
       "      <td>claimant count - occupation</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                                                                                                                                                                                                                   description  \\\n",
       "0  Records the number of people claiming Jobseeker's Allowance (JSA) and National Insurance credits at Jobcentre Plus local offices. This is not an official measure of unemployment, but is the only indicative statistic available for areas smaller than Local Authorities.   \n",
       "1                                                                                                                                              A quartery count of claimants who were claiming Jobseeker's Allowance on the count date analysed by their age and the duration.   \n",
       "2                                                     A monthly count of Jobseeker's Allowance (JSA) claimants broken down by age and the duration of claim. Totals exclude non-computerised clerical claims (approx. 1%). Available for areas smaller than Local Authorities.   \n",
       "3                                                                                           A midyear estimate of the workforce (the denominator) which was used for calculating claimant count rates prior to January 2003. The estimates are broken down by sex but not age.   \n",
       "4                                                                                                                                                                         A quarterly count of  Jobseeker's Allowance claimants analysed by their sought and usual occupation.   \n",
       "\n",
       "       id                                                       name  \n",
       "0  NM_1_1           Jobseeker's Allowance with rates and proportions  \n",
       "1  NM_2_1                          claimant count - age and duration  \n",
       "2  NM_4_1                  Jobseeker's Allowance by age and duration  \n",
       "3  NM_5_1  claimant count denominators - historical workforce series  \n",
       "4  NM_6_1                                claimant count - occupation  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_sets, meta_data = list_data_sets()\n",
    "df_data_sets_list = pd.DataFrame(data_sets)\n",
    "df_data_sets_list.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Searching the list of data sets\n",
    "\n",
    "We can search for data on different topics by looking in the list of data sets for key words. We can search either the id, the description, or the name. We can build a function to do help with this."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "def search_data_list(df_data_sets_list, search_field, search_term):\n",
    "    \n",
    "    # This function will search a filed (e.g., id, description or name) to see \n",
    "    # how well it matches the terms in the search_term\n",
    "    # Results are returned in a table with the best matches at the top\n",
    "    \n",
    "    df = df_data_sets_list.copy()\n",
    "    df['search_score'] = df[search_field].apply(lambda x: fuzz.token_sort_ratio(x, search_term))\n",
    "    df = df.sort_values('search_score', ascending=False)\n",
    "    \n",
    "    return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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 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>description</th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "      <th>search_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NM_127_1</td>\n",
       "      <td>model-based estimates of unemployment</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NM_509_1</td>\n",
       "      <td>Population</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NM_589_1</td>\n",
       "      <td>Occupation</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>951</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NM_1613_1</td>\n",
       "      <td>KS011a - Industry of employment</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>A residence based labour market survey encompassing population, economic activity (employment and unemployment), economic inactivity and qualifications. These are broken down where possible by gender, age, ethnicity, industry and occupation. Available at Local Authority level and above. Updated quarterly.</td>\n",
       "      <td>NM_17_1</td>\n",
       "      <td>annual population survey</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NM_129_1</td>\n",
       "      <td>Annual Civil Service Employment Survey</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NM_586_1</td>\n",
       "      <td>Economic Position - Females</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>527</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NM_918_1</td>\n",
       "      <td>ST606EWla - Occupation</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1022</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NM_1684_1</td>\n",
       "      <td>UV068 - Household type</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>952</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NM_1614_1</td>\n",
       "      <td>KS011b - Industry of employment - males</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>953</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NM_1615_1</td>\n",
       "      <td>KS011c - Industry of employment - females</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>877</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NM_1507_1</td>\n",
       "      <td>KS402UK - Tenure</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>891</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NM_1521_1</td>\n",
       "      <td>KS611UK - NS-SeC</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NM_516_1</td>\n",
       "      <td>QS116EW - Household type</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>982</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NM_1644_1</td>\n",
       "      <td>UV015 - Religion</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>945</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NM_1607_1</td>\n",
       "      <td>KS007 - Religion</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>525</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NM_916_1</td>\n",
       "      <td>ST604EWla - Hours worked</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>894</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NM_1530_1</td>\n",
       "      <td>QS101UK - Residence type</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>A monthly count of claimants who either a) were claiming benefit (stocks, flow=1) on the count date; this count is the same as that in USJ, B)  ceased to be unemployed (off-flows, flow=2) during the previous accounting month, c) became claimants (on-flows, flow=3) during the previous accounting month</td>\n",
       "      <td>NM_85_1</td>\n",
       "      <td>claimant flows</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>245</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NM_590_1</td>\n",
       "      <td>Qualifications</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                                                                                                                                                                                                                                                             description  \\\n",
       "96                                                                                                                                                                                                                                                                                                                   NaN   \n",
       "166                                                                                                                                                                                                                                                                                                                  NaN   \n",
       "244                                                                                                                                                                                                                                                                                                                  NaN   \n",
       "951                                                                                                                                                                                                                                                                                                                  NaN   \n",
       "11    A residence based labour market survey encompassing population, economic activity (employment and unemployment), economic inactivity and qualifications. These are broken down where possible by gender, age, ethnicity, industry and occupation. Available at Local Authority level and above. Updated quarterly.   \n",
       "97                                                                                                                                                                                                                                                                                                                   NaN   \n",
       "241                                                                                                                                                                                                                                                                                                                  NaN   \n",
       "527                                                                                                                                                                                                                                                                                                                  NaN   \n",
       "1022                                                                                                                                                                                                                                                                                                                 NaN   \n",
       "952                                                                                                                                                                                                                                                                                                                  NaN   \n",
       "953                                                                                                                                                                                                                                                                                                                  NaN   \n",
       "877                                                                                                                                                                                                                                                                                                                  NaN   \n",
       "891                                                                                                                                                                                                                                                                                                                  NaN   \n",
       "173                                                                                                                                                                                                                                                                                                                  NaN   \n",
       "982                                                                                                                                                                                                                                                                                                                  NaN   \n",
       "945                                                                                                                                                                                                                                                                                                                  NaN   \n",
       "525                                                                                                                                                                                                                                                                                                                  NaN   \n",
       "894                                                                                                                                                                                                                                                                                                                  NaN   \n",
       "61         A monthly count of claimants who either a) were claiming benefit (stocks, flow=1) on the count date; this count is the same as that in USJ, B)  ceased to be unemployed (off-flows, flow=2) during the previous accounting month, c) became claimants (on-flows, flow=3) during the previous accounting month   \n",
       "245                                                                                                                                                                                                                                                                                                                  NaN   \n",
       "\n",
       "             id                                       name  search_score  \n",
       "96     NM_127_1      model-based estimates of unemployment            36  \n",
       "166    NM_509_1                                 Population            33  \n",
       "244    NM_589_1                                 Occupation            33  \n",
       "951   NM_1613_1            KS011a - Industry of employment            32  \n",
       "11      NM_17_1                   annual population survey            31  \n",
       "97     NM_129_1     Annual Civil Service Employment Survey            30  \n",
       "241    NM_586_1                Economic Position - Females            30  \n",
       "527    NM_918_1                     ST606EWla - Occupation            29  \n",
       "1022  NM_1684_1                     UV068 - Household type            29  \n",
       "952   NM_1614_1    KS011b - Industry of employment - males            28  \n",
       "953   NM_1615_1  KS011c - Industry of employment - females            27  \n",
       "877   NM_1507_1                           KS402UK - Tenure            27  \n",
       "891   NM_1521_1                           KS611UK - NS-SeC            27  \n",
       "173    NM_516_1                   QS116EW - Household type            27  \n",
       "982   NM_1644_1                           UV015 - Religion            27  \n",
       "945   NM_1607_1                           KS007 - Religion            27  \n",
       "525    NM_916_1                   ST604EWla - Hours worked            27  \n",
       "894   NM_1530_1                   QS101UK - Residence type            27  \n",
       "61      NM_85_1                             claimant flows            27  \n",
       "245    NM_590_1                             Qualifications            27  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_search_results = search_data_list(df_data_sets_list, 'name', 'unemploy')\n",
    "df_search_results.head(20)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Checking which dimensions are available on a particular data set"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Status': 'Current (being actively updated)',\n",
       " 'Units': 'Persons',\n",
       " 'contenttype/sources': 'aps',\n",
       " 'SubDescription': 'previously unavailable',\n",
       " 'Mnemonic': 'umb',\n",
       " 'FirstReleased': '2006-03-29 09:30:00',\n",
       " 'LastUpdated': '2019-07-16 09:30:00',\n",
       " 'LastRevised': '2019-04-16 09:30:00',\n",
       " 'dimensions': ['GEOGRAPHY', 'ITEM', 'MEASURES', 'FREQ'],\n",
       " 'primarymeasure': 'OBS_VALUE',\n",
       " 'timedimension': 'TIME'}"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "meta_data['NM_127_1']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "def dimension_values(data_set_id, dimension):\n",
    "    \n",
    "    root = \"http://www.nomisweb.co.uk\"\n",
    "    ext = f'/api/v01/dataset/{data_set_id}/{dimension}.def.sdmx.json'\n",
    "    response = rq.get(root + ext).json()\n",
    "    dim_vals = [\n",
    "        {\n",
    "            'description': item['description']['value'],\n",
    "            'value': item['value'],\n",
    "            'dimension': dimension\n",
    "        } for item in response['structure']['codelists']['codelist'][0]['code']\n",
    "    ]\n",
    "    return dim_vals\n",
    "\n",
    "\n",
    "def all_dimension_values(meta_data, data_set_id):\n",
    "    \n",
    "    # This function gets the values that are available for different dimensions on a data set\n",
    "    \n",
    "    dimensions = meta_data[data_set_id]['dimensions']\n",
    "    all_dim_vals = []\n",
    "    for dimension in dimensions:\n",
    "        all_dim_vals += dimension_values(data_set_id, dimension)\n",
    "        \n",
    "    return all_dim_vals"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>description</th>\n",
       "      <th>value</th>\n",
       "      <th>dimension</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Great Britain</td>\n",
       "      <td>2092957698</td>\n",
       "      <td>GEOGRAPHY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>England</td>\n",
       "      <td>2092957699</td>\n",
       "      <td>GEOGRAPHY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Wales</td>\n",
       "      <td>2092957700</td>\n",
       "      <td>GEOGRAPHY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Scotland</td>\n",
       "      <td>2092957701</td>\n",
       "      <td>GEOGRAPHY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>England and Wales</td>\n",
       "      <td>2092957703</td>\n",
       "      <td>GEOGRAPHY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>ITEM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Unemployment rate (model based)</td>\n",
       "      <td>2</td>\n",
       "      <td>ITEM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>value</td>\n",
       "      <td>20100</td>\n",
       "      <td>MEASURES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>confidence</td>\n",
       "      <td>20701</td>\n",
       "      <td>MEASURES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Quarterly</td>\n",
       "      <td>Q</td>\n",
       "      <td>FREQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Half-yearly, semester</td>\n",
       "      <td>S</td>\n",
       "      <td>FREQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Annually</td>\n",
       "      <td>A</td>\n",
       "      <td>FREQ</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         description       value  dimension\n",
       "0                      Great Britain  2092957698  GEOGRAPHY\n",
       "1                            England  2092957699  GEOGRAPHY\n",
       "2                              Wales  2092957700  GEOGRAPHY\n",
       "3                           Scotland  2092957701  GEOGRAPHY\n",
       "4                  England and Wales  2092957703  GEOGRAPHY\n",
       "5   Unemployment count (model based)           1       ITEM\n",
       "6    Unemployment rate (model based)           2       ITEM\n",
       "7                              value       20100   MEASURES\n",
       "8                         confidence       20701   MEASURES\n",
       "9                          Quarterly           Q       FREQ\n",
       "10             Half-yearly, semester           S       FREQ\n",
       "11                          Annually           A       FREQ"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(all_dimension_values(meta_data, 'NM_127_1'))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Available geography levels for a data set"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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 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>description</th>\n",
       "      <th>value</th>\n",
       "      <th>dimension</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>England</td>\n",
       "      <td>2092957699</td>\n",
       "      <td>geography/2092957699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>local authorities: county / unitary (as of April 2021) within England</td>\n",
       "      <td>2092957699TYPE431</td>\n",
       "      <td>geography/2092957699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>local authorities: district / unitary (as of April 2021) within England</td>\n",
       "      <td>2092957699TYPE432</td>\n",
       "      <td>geography/2092957699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>local authorities: district / unitary (as of April 2019) within England</td>\n",
       "      <td>2092957699TYPE434</td>\n",
       "      <td>geography/2092957699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>combined authorities within England</td>\n",
       "      <td>2092957699TYPE442</td>\n",
       "      <td>geography/2092957699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>local enterprise partnerships (as of April 2021) within England</td>\n",
       "      <td>2092957699TYPE459</td>\n",
       "      <td>geography/2092957699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>local authorities: county / unitary (prior to April 2015) within England</td>\n",
       "      <td>2092957699TYPE463</td>\n",
       "      <td>geography/2092957699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>local authorities: district / unitary (prior to April 2015) within England</td>\n",
       "      <td>2092957699TYPE464</td>\n",
       "      <td>geography/2092957699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>english counties within England</td>\n",
       "      <td>2092957699TYPE469</td>\n",
       "      <td>geography/2092957699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>regions within England</td>\n",
       "      <td>2092957699TYPE480</td>\n",
       "      <td>geography/2092957699</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                  description  \\\n",
       "0                                                                     England   \n",
       "1       local authorities: county / unitary (as of April 2021) within England   \n",
       "2     local authorities: district / unitary (as of April 2021) within England   \n",
       "3     local authorities: district / unitary (as of April 2019) within England   \n",
       "4                                         combined authorities within England   \n",
       "5             local enterprise partnerships (as of April 2021) within England   \n",
       "6    local authorities: county / unitary (prior to April 2015) within England   \n",
       "7  local authorities: district / unitary (prior to April 2015) within England   \n",
       "8                                             english counties within England   \n",
       "9                                                      regions within England   \n",
       "\n",
       "               value             dimension  \n",
       "0         2092957699  geography/2092957699  \n",
       "1  2092957699TYPE431  geography/2092957699  \n",
       "2  2092957699TYPE432  geography/2092957699  \n",
       "3  2092957699TYPE434  geography/2092957699  \n",
       "4  2092957699TYPE442  geography/2092957699  \n",
       "5  2092957699TYPE459  geography/2092957699  \n",
       "6  2092957699TYPE463  geography/2092957699  \n",
       "7  2092957699TYPE464  geography/2092957699  \n",
       "8  2092957699TYPE469  geography/2092957699  \n",
       "9  2092957699TYPE480  geography/2092957699  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(dimension_values('NM_127_1', 'geography/2092957699')).head(100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>description</th>\n",
       "      <th>value</th>\n",
       "      <th>dimension</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Darlington</td>\n",
       "      <td>1811939329</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>County Durham</td>\n",
       "      <td>1811939330</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>1811939331</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Middlesbrough</td>\n",
       "      <td>1811939332</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Northumberland</td>\n",
       "      <td>1811939334</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Redcar and Cleveland</td>\n",
       "      <td>1811939335</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Stockton-on-Tees</td>\n",
       "      <td>1811939336</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Gateshead</td>\n",
       "      <td>1811939338</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Newcastle upon Tyne</td>\n",
       "      <td>1811939339</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>North Tyneside</td>\n",
       "      <td>1811939340</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>South Tyneside</td>\n",
       "      <td>1811939341</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Sunderland</td>\n",
       "      <td>1811939342</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Blackburn with Darwen</td>\n",
       "      <td>1811939343</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Blackpool</td>\n",
       "      <td>1811939344</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Cheshire East</td>\n",
       "      <td>1811939345</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Cheshire West and Chester</td>\n",
       "      <td>1811939346</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Halton</td>\n",
       "      <td>1811939347</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Warrington</td>\n",
       "      <td>1811939348</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Allerdale</td>\n",
       "      <td>1811939349</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Barrow-in-Furness</td>\n",
       "      <td>1811939350</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Carlisle</td>\n",
       "      <td>1811939351</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Copeland</td>\n",
       "      <td>1811939352</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Eden</td>\n",
       "      <td>1811939353</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>South Lakeland</td>\n",
       "      <td>1811939354</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Bolton</td>\n",
       "      <td>1811939355</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Bury</td>\n",
       "      <td>1811939356</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Manchester</td>\n",
       "      <td>1811939357</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Oldham</td>\n",
       "      <td>1811939358</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Rochdale</td>\n",
       "      <td>1811939359</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Salford</td>\n",
       "      <td>1811939360</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Stockport</td>\n",
       "      <td>1811939361</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Tameside</td>\n",
       "      <td>1811939362</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Trafford</td>\n",
       "      <td>1811939363</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Wigan</td>\n",
       "      <td>1811939364</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Burnley</td>\n",
       "      <td>1811939365</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Chorley</td>\n",
       "      <td>1811939366</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Fylde</td>\n",
       "      <td>1811939367</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Hyndburn</td>\n",
       "      <td>1811939368</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Lancaster</td>\n",
       "      <td>1811939369</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Pendle</td>\n",
       "      <td>1811939370</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Preston</td>\n",
       "      <td>1811939371</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Ribble Valley</td>\n",
       "      <td>1811939372</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Rossendale</td>\n",
       "      <td>1811939373</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>South Ribble</td>\n",
       "      <td>1811939374</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>West Lancashire</td>\n",
       "      <td>1811939375</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Wyre</td>\n",
       "      <td>1811939376</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Knowsley</td>\n",
       "      <td>1811939377</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Liverpool</td>\n",
       "      <td>1811939378</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Sefton</td>\n",
       "      <td>1811939379</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>St. Helens</td>\n",
       "      <td>1811939380</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Wirral</td>\n",
       "      <td>1811939381</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>East Riding of Yorkshire</td>\n",
       "      <td>1811939382</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>Kingston upon Hull, City of</td>\n",
       "      <td>1811939383</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>North East Lincolnshire</td>\n",
       "      <td>1811939384</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>North Lincolnshire</td>\n",
       "      <td>1811939385</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>York</td>\n",
       "      <td>1811939386</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Craven</td>\n",
       "      <td>1811939387</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Hambleton</td>\n",
       "      <td>1811939388</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Harrogate</td>\n",
       "      <td>1811939389</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>Richmondshire</td>\n",
       "      <td>1811939390</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Ryedale</td>\n",
       "      <td>1811939391</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>Scarborough</td>\n",
       "      <td>1811939392</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>Selby</td>\n",
       "      <td>1811939393</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>Barnsley</td>\n",
       "      <td>1811939394</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>Doncaster</td>\n",
       "      <td>1811939395</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Rotherham</td>\n",
       "      <td>1811939396</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>Sheffield</td>\n",
       "      <td>1811939397</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>Bradford</td>\n",
       "      <td>1811939398</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>Calderdale</td>\n",
       "      <td>1811939399</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>Kirklees</td>\n",
       "      <td>1811939400</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>Leeds</td>\n",
       "      <td>1811939401</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Wakefield</td>\n",
       "      <td>1811939402</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Derby</td>\n",
       "      <td>1811939403</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>Leicester</td>\n",
       "      <td>1811939404</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Nottingham</td>\n",
       "      <td>1811939405</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>Rutland</td>\n",
       "      <td>1811939406</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Amber Valley</td>\n",
       "      <td>1811939407</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>Bolsover</td>\n",
       "      <td>1811939408</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Chesterfield</td>\n",
       "      <td>1811939409</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>Derbyshire Dales</td>\n",
       "      <td>1811939410</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>Erewash</td>\n",
       "      <td>1811939411</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>High Peak</td>\n",
       "      <td>1811939412</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>North East Derbyshire</td>\n",
       "      <td>1811939413</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>South Derbyshire</td>\n",
       "      <td>1811939414</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>Blaby</td>\n",
       "      <td>1811939415</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>Charnwood</td>\n",
       "      <td>1811939416</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>Harborough</td>\n",
       "      <td>1811939417</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>Hinckley and Bosworth</td>\n",
       "      <td>1811939418</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>Melton</td>\n",
       "      <td>1811939419</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>North West Leicestershire</td>\n",
       "      <td>1811939420</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>Oadby and Wigston</td>\n",
       "      <td>1811939421</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>Boston</td>\n",
       "      <td>1811939422</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>East Lindsey</td>\n",
       "      <td>1811939423</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>Lincoln</td>\n",
       "      <td>1811939424</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>North Kesteven</td>\n",
       "      <td>1811939425</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>South Holland</td>\n",
       "      <td>1811939426</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>South Kesteven</td>\n",
       "      <td>1811939427</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>West Lindsey</td>\n",
       "      <td>1811939428</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>Ashfield</td>\n",
       "      <td>1811939436</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>Bassetlaw</td>\n",
       "      <td>1811939437</td>\n",
       "      <td>geography/2092957699TYPE432</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    description       value                    dimension\n",
       "0                    Darlington  1811939329  geography/2092957699TYPE432\n",
       "1                 County Durham  1811939330  geography/2092957699TYPE432\n",
       "2                    Hartlepool  1811939331  geography/2092957699TYPE432\n",
       "3                 Middlesbrough  1811939332  geography/2092957699TYPE432\n",
       "4                Northumberland  1811939334  geography/2092957699TYPE432\n",
       "5          Redcar and Cleveland  1811939335  geography/2092957699TYPE432\n",
       "6              Stockton-on-Tees  1811939336  geography/2092957699TYPE432\n",
       "7                     Gateshead  1811939338  geography/2092957699TYPE432\n",
       "8           Newcastle upon Tyne  1811939339  geography/2092957699TYPE432\n",
       "9                North Tyneside  1811939340  geography/2092957699TYPE432\n",
       "10               South Tyneside  1811939341  geography/2092957699TYPE432\n",
       "11                   Sunderland  1811939342  geography/2092957699TYPE432\n",
       "12        Blackburn with Darwen  1811939343  geography/2092957699TYPE432\n",
       "13                    Blackpool  1811939344  geography/2092957699TYPE432\n",
       "14                Cheshire East  1811939345  geography/2092957699TYPE432\n",
       "15    Cheshire West and Chester  1811939346  geography/2092957699TYPE432\n",
       "16                       Halton  1811939347  geography/2092957699TYPE432\n",
       "17                   Warrington  1811939348  geography/2092957699TYPE432\n",
       "18                    Allerdale  1811939349  geography/2092957699TYPE432\n",
       "19            Barrow-in-Furness  1811939350  geography/2092957699TYPE432\n",
       "20                     Carlisle  1811939351  geography/2092957699TYPE432\n",
       "21                     Copeland  1811939352  geography/2092957699TYPE432\n",
       "22                         Eden  1811939353  geography/2092957699TYPE432\n",
       "23               South Lakeland  1811939354  geography/2092957699TYPE432\n",
       "24                       Bolton  1811939355  geography/2092957699TYPE432\n",
       "25                         Bury  1811939356  geography/2092957699TYPE432\n",
       "26                   Manchester  1811939357  geography/2092957699TYPE432\n",
       "27                       Oldham  1811939358  geography/2092957699TYPE432\n",
       "28                     Rochdale  1811939359  geography/2092957699TYPE432\n",
       "29                      Salford  1811939360  geography/2092957699TYPE432\n",
       "30                    Stockport  1811939361  geography/2092957699TYPE432\n",
       "31                     Tameside  1811939362  geography/2092957699TYPE432\n",
       "32                     Trafford  1811939363  geography/2092957699TYPE432\n",
       "33                        Wigan  1811939364  geography/2092957699TYPE432\n",
       "34                      Burnley  1811939365  geography/2092957699TYPE432\n",
       "35                      Chorley  1811939366  geography/2092957699TYPE432\n",
       "36                        Fylde  1811939367  geography/2092957699TYPE432\n",
       "37                     Hyndburn  1811939368  geography/2092957699TYPE432\n",
       "38                    Lancaster  1811939369  geography/2092957699TYPE432\n",
       "39                       Pendle  1811939370  geography/2092957699TYPE432\n",
       "40                      Preston  1811939371  geography/2092957699TYPE432\n",
       "41                Ribble Valley  1811939372  geography/2092957699TYPE432\n",
       "42                   Rossendale  1811939373  geography/2092957699TYPE432\n",
       "43                 South Ribble  1811939374  geography/2092957699TYPE432\n",
       "44              West Lancashire  1811939375  geography/2092957699TYPE432\n",
       "45                         Wyre  1811939376  geography/2092957699TYPE432\n",
       "46                     Knowsley  1811939377  geography/2092957699TYPE432\n",
       "47                    Liverpool  1811939378  geography/2092957699TYPE432\n",
       "48                       Sefton  1811939379  geography/2092957699TYPE432\n",
       "49                   St. Helens  1811939380  geography/2092957699TYPE432\n",
       "50                       Wirral  1811939381  geography/2092957699TYPE432\n",
       "51     East Riding of Yorkshire  1811939382  geography/2092957699TYPE432\n",
       "52  Kingston upon Hull, City of  1811939383  geography/2092957699TYPE432\n",
       "53      North East Lincolnshire  1811939384  geography/2092957699TYPE432\n",
       "54           North Lincolnshire  1811939385  geography/2092957699TYPE432\n",
       "55                         York  1811939386  geography/2092957699TYPE432\n",
       "56                       Craven  1811939387  geography/2092957699TYPE432\n",
       "57                    Hambleton  1811939388  geography/2092957699TYPE432\n",
       "58                    Harrogate  1811939389  geography/2092957699TYPE432\n",
       "59                Richmondshire  1811939390  geography/2092957699TYPE432\n",
       "60                      Ryedale  1811939391  geography/2092957699TYPE432\n",
       "61                  Scarborough  1811939392  geography/2092957699TYPE432\n",
       "62                        Selby  1811939393  geography/2092957699TYPE432\n",
       "63                     Barnsley  1811939394  geography/2092957699TYPE432\n",
       "64                    Doncaster  1811939395  geography/2092957699TYPE432\n",
       "65                    Rotherham  1811939396  geography/2092957699TYPE432\n",
       "66                    Sheffield  1811939397  geography/2092957699TYPE432\n",
       "67                     Bradford  1811939398  geography/2092957699TYPE432\n",
       "68                   Calderdale  1811939399  geography/2092957699TYPE432\n",
       "69                     Kirklees  1811939400  geography/2092957699TYPE432\n",
       "70                        Leeds  1811939401  geography/2092957699TYPE432\n",
       "71                    Wakefield  1811939402  geography/2092957699TYPE432\n",
       "72                        Derby  1811939403  geography/2092957699TYPE432\n",
       "73                    Leicester  1811939404  geography/2092957699TYPE432\n",
       "74                   Nottingham  1811939405  geography/2092957699TYPE432\n",
       "75                      Rutland  1811939406  geography/2092957699TYPE432\n",
       "76                 Amber Valley  1811939407  geography/2092957699TYPE432\n",
       "77                     Bolsover  1811939408  geography/2092957699TYPE432\n",
       "78                 Chesterfield  1811939409  geography/2092957699TYPE432\n",
       "79             Derbyshire Dales  1811939410  geography/2092957699TYPE432\n",
       "80                      Erewash  1811939411  geography/2092957699TYPE432\n",
       "81                    High Peak  1811939412  geography/2092957699TYPE432\n",
       "82        North East Derbyshire  1811939413  geography/2092957699TYPE432\n",
       "83             South Derbyshire  1811939414  geography/2092957699TYPE432\n",
       "84                        Blaby  1811939415  geography/2092957699TYPE432\n",
       "85                    Charnwood  1811939416  geography/2092957699TYPE432\n",
       "86                   Harborough  1811939417  geography/2092957699TYPE432\n",
       "87        Hinckley and Bosworth  1811939418  geography/2092957699TYPE432\n",
       "88                       Melton  1811939419  geography/2092957699TYPE432\n",
       "89    North West Leicestershire  1811939420  geography/2092957699TYPE432\n",
       "90            Oadby and Wigston  1811939421  geography/2092957699TYPE432\n",
       "91                       Boston  1811939422  geography/2092957699TYPE432\n",
       "92                 East Lindsey  1811939423  geography/2092957699TYPE432\n",
       "93                      Lincoln  1811939424  geography/2092957699TYPE432\n",
       "94               North Kesteven  1811939425  geography/2092957699TYPE432\n",
       "95                South Holland  1811939426  geography/2092957699TYPE432\n",
       "96               South Kesteven  1811939427  geography/2092957699TYPE432\n",
       "97                 West Lindsey  1811939428  geography/2092957699TYPE432\n",
       "98                     Ashfield  1811939436  geography/2092957699TYPE432\n",
       "99                    Bassetlaw  1811939437  geography/2092957699TYPE432"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(dimension_values('NM_127_1', 'geography/2092957699TYPE432')).head(100)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Available time periods for a data set\n",
    "\n",
    "Time/date info from nomis API docs.\n",
    "Useful time options:\n",
    " - \"latest\" - the latest available data for this dataset\n",
    " - \"previous\" - the date prior to \"latest\"\n",
    " - \"prevyear\" - the date one year prior to \"latest\"\n",
    " - \"first\" - the oldest available data for this dataset\n",
    "\n",
    "Using the \"time\" concept you are limited to entering two dates, a start and end. All dates between these are returned.\n",
    "        \n",
    "Date is more flexible for range. With the \"date\" parameter you can specify relative dates, so for example if you wanted the latest date, three months and six months prior to that you could specify \"date=latest,latestMINUS3,latestMINUS6\". \n",
    "You can use ranges with the \"date\" parameter, e.g. if you wanted data for 12 months ago, together with all dates in the last six month up to latest you could specify \"date=prevyear,latestMINUS5-latest\". To illustrate the difference between using \"date\" and \"time\"; if you specified \"time=first,latest\" in your URI you would get all dates from first to latest inclusive, whereas with \"date=first,latest\" your output would contain only the first and latest dates."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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 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>description</th>\n",
       "      <th>value</th>\n",
       "      <th>dimension</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Jan 2004-Dec 2004</td>\n",
       "      <td>2004-12</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Apr 2004-Mar 2005</td>\n",
       "      <td>2005-03</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Jul 2004-Jun 2005</td>\n",
       "      <td>2005-06</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Oct 2004-Sep 2005</td>\n",
       "      <td>2005-09</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Jan 2005-Dec 2005</td>\n",
       "      <td>2005-12</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Apr 2005-Mar 2006</td>\n",
       "      <td>2006-03</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Jul 2005-Jun 2006</td>\n",
       "      <td>2006-06</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Oct 2005-Sep 2006</td>\n",
       "      <td>2006-09</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Jan 2006-Dec 2006</td>\n",
       "      <td>2006-12</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Apr 2006-Mar 2007</td>\n",
       "      <td>2007-03</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Jul 2006-Jun 2007</td>\n",
       "      <td>2007-06</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Oct 2006-Sep 2007</td>\n",
       "      <td>2007-09</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Jan 2007-Dec 2007</td>\n",
       "      <td>2007-12</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Apr 2007-Mar 2008</td>\n",
       "      <td>2008-03</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Jul 2007-Jun 2008</td>\n",
       "      <td>2008-06</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Oct 2007-Sep 2008</td>\n",
       "      <td>2008-09</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Jan 2008-Dec 2008</td>\n",
       "      <td>2008-12</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Apr 2008-Mar 2009</td>\n",
       "      <td>2009-03</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Jul 2008-Jun 2009</td>\n",
       "      <td>2009-06</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Oct 2008-Sep 2009</td>\n",
       "      <td>2009-09</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Jan 2009-Dec 2009</td>\n",
       "      <td>2009-12</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Apr 2009-Mar 2010</td>\n",
       "      <td>2010-03</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Jul 2009-Jun 2010</td>\n",
       "      <td>2010-06</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Oct 2009-Sep 2010</td>\n",
       "      <td>2010-09</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Jan 2010-Dec 2010</td>\n",
       "      <td>2010-12</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Apr 2010-Mar 2011</td>\n",
       "      <td>2011-03</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Jul 2010-Jun 2011</td>\n",
       "      <td>2011-06</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Oct 2010-Sep 2011</td>\n",
       "      <td>2011-09</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Jan 2011-Dec 2011</td>\n",
       "      <td>2011-12</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Apr 2011-Mar 2012</td>\n",
       "      <td>2012-03</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Jul 2011-Jun 2012</td>\n",
       "      <td>2012-06</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Oct 2011-Sep 2012</td>\n",
       "      <td>2012-09</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Jan 2012-Dec 2012</td>\n",
       "      <td>2012-12</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Apr 2012-Mar 2013</td>\n",
       "      <td>2013-03</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Jul 2012-Jun 2013</td>\n",
       "      <td>2013-06</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Oct 2012-Sep 2013</td>\n",
       "      <td>2013-09</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Jan 2013-Dec 2013</td>\n",
       "      <td>2013-12</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Apr 2013-Mar 2014</td>\n",
       "      <td>2014-03</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Jul 2013-Jun 2014</td>\n",
       "      <td>2014-06</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Oct 2013-Sep 2014</td>\n",
       "      <td>2014-09</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Jan 2014-Dec 2014</td>\n",
       "      <td>2014-12</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Apr 2014-Mar 2015</td>\n",
       "      <td>2015-03</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Jul 2014-Jun 2015</td>\n",
       "      <td>2015-06</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Oct 2014-Sep 2015</td>\n",
       "      <td>2015-09</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Jan 2015-Dec 2015</td>\n",
       "      <td>2015-12</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Apr 2015-Mar 2016</td>\n",
       "      <td>2016-03</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Jul 2015-Jun 2016</td>\n",
       "      <td>2016-06</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Oct 2015-Sep 2016</td>\n",
       "      <td>2016-09</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Jan 2016-Dec 2016</td>\n",
       "      <td>2016-12</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Apr 2016-Mar 2017</td>\n",
       "      <td>2017-03</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Jul 2016-Jun 2017</td>\n",
       "      <td>2017-06</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>Oct 2016-Sep 2017</td>\n",
       "      <td>2017-09</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>Jan 2017-Dec 2017</td>\n",
       "      <td>2017-12</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>Apr 2017-Mar 2018</td>\n",
       "      <td>2018-03</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>Jul 2017-Jun 2018</td>\n",
       "      <td>2018-06</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Oct 2017-Sep 2018</td>\n",
       "      <td>2018-09</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Apr 2018-Mar 2019</td>\n",
       "      <td>2019-03</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Jul 2018-Jun 2019</td>\n",
       "      <td>2019-06</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>Oct 2018-Sep 2019</td>\n",
       "      <td>2019-09</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Jan 2019-Dec 2019</td>\n",
       "      <td>2019-12</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>Apr 2019-Mar 2020</td>\n",
       "      <td>2020-03</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>Jul 2019-Jun 2020</td>\n",
       "      <td>2020-06</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>Oct 2019-Sep 2020</td>\n",
       "      <td>2020-09</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>Jan 2020-Dec 2020</td>\n",
       "      <td>2020-12</td>\n",
       "      <td>time</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          description    value dimension\n",
       "0   Jan 2004-Dec 2004  2004-12      time\n",
       "1   Apr 2004-Mar 2005  2005-03      time\n",
       "2   Jul 2004-Jun 2005  2005-06      time\n",
       "3   Oct 2004-Sep 2005  2005-09      time\n",
       "4   Jan 2005-Dec 2005  2005-12      time\n",
       "5   Apr 2005-Mar 2006  2006-03      time\n",
       "6   Jul 2005-Jun 2006  2006-06      time\n",
       "7   Oct 2005-Sep 2006  2006-09      time\n",
       "8   Jan 2006-Dec 2006  2006-12      time\n",
       "9   Apr 2006-Mar 2007  2007-03      time\n",
       "10  Jul 2006-Jun 2007  2007-06      time\n",
       "11  Oct 2006-Sep 2007  2007-09      time\n",
       "12  Jan 2007-Dec 2007  2007-12      time\n",
       "13  Apr 2007-Mar 2008  2008-03      time\n",
       "14  Jul 2007-Jun 2008  2008-06      time\n",
       "15  Oct 2007-Sep 2008  2008-09      time\n",
       "16  Jan 2008-Dec 2008  2008-12      time\n",
       "17  Apr 2008-Mar 2009  2009-03      time\n",
       "18  Jul 2008-Jun 2009  2009-06      time\n",
       "19  Oct 2008-Sep 2009  2009-09      time\n",
       "20  Jan 2009-Dec 2009  2009-12      time\n",
       "21  Apr 2009-Mar 2010  2010-03      time\n",
       "22  Jul 2009-Jun 2010  2010-06      time\n",
       "23  Oct 2009-Sep 2010  2010-09      time\n",
       "24  Jan 2010-Dec 2010  2010-12      time\n",
       "25  Apr 2010-Mar 2011  2011-03      time\n",
       "26  Jul 2010-Jun 2011  2011-06      time\n",
       "27  Oct 2010-Sep 2011  2011-09      time\n",
       "28  Jan 2011-Dec 2011  2011-12      time\n",
       "29  Apr 2011-Mar 2012  2012-03      time\n",
       "30  Jul 2011-Jun 2012  2012-06      time\n",
       "31  Oct 2011-Sep 2012  2012-09      time\n",
       "32  Jan 2012-Dec 2012  2012-12      time\n",
       "33  Apr 2012-Mar 2013  2013-03      time\n",
       "34  Jul 2012-Jun 2013  2013-06      time\n",
       "35  Oct 2012-Sep 2013  2013-09      time\n",
       "36  Jan 2013-Dec 2013  2013-12      time\n",
       "37  Apr 2013-Mar 2014  2014-03      time\n",
       "38  Jul 2013-Jun 2014  2014-06      time\n",
       "39  Oct 2013-Sep 2014  2014-09      time\n",
       "40  Jan 2014-Dec 2014  2014-12      time\n",
       "41  Apr 2014-Mar 2015  2015-03      time\n",
       "42  Jul 2014-Jun 2015  2015-06      time\n",
       "43  Oct 2014-Sep 2015  2015-09      time\n",
       "44  Jan 2015-Dec 2015  2015-12      time\n",
       "45  Apr 2015-Mar 2016  2016-03      time\n",
       "46  Jul 2015-Jun 2016  2016-06      time\n",
       "47  Oct 2015-Sep 2016  2016-09      time\n",
       "48  Jan 2016-Dec 2016  2016-12      time\n",
       "49  Apr 2016-Mar 2017  2017-03      time\n",
       "50  Jul 2016-Jun 2017  2017-06      time\n",
       "51  Oct 2016-Sep 2017  2017-09      time\n",
       "52  Jan 2017-Dec 2017  2017-12      time\n",
       "53  Apr 2017-Mar 2018  2018-03      time\n",
       "54  Jul 2017-Jun 2018  2018-06      time\n",
       "55  Oct 2017-Sep 2018  2018-09      time\n",
       "56  Jan 2018-Dec 2018  2018-12      time\n",
       "57  Apr 2018-Mar 2019  2019-03      time\n",
       "58  Jul 2018-Jun 2019  2019-06      time\n",
       "59  Oct 2018-Sep 2019  2019-09      time\n",
       "60  Jan 2019-Dec 2019  2019-12      time\n",
       "61  Apr 2019-Mar 2020  2020-03      time\n",
       "62  Jul 2019-Jun 2020  2020-06      time\n",
       "63  Oct 2019-Sep 2020  2020-09      time\n",
       "64  Jan 2020-Dec 2020  2020-12      time"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(dimension_values('NM_127_1', 'time')).head(100)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Downloading a data set\n",
    "\n",
    "To get a data set from the NOMIS API we put together a query. A query is a string that contains the information on the data we are requesting such as the dataset id, the gegraphical area, and the time period. We can define a function to build the query string based on this information and then pass the query string to pandas to request the data."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "def make_query(data_set_id, dimension_filters={}):\n",
    "    \n",
    "    # This function makes a query string for requesting data from the NOMIS API\n",
    "    \n",
    "    root = \"http://www.nomisweb.co.uk\"\n",
    "    ext = \"/api/v01/dataset/\"\n",
    "    \n",
    "    params = '&'.join([f'{dimension.lower()}={dimension_filters[dimension]}' for dimension in dimension_filters.keys()])\n",
    "    if len(params) > 0:\n",
    "        params = f'?{params}'\n",
    "        \n",
    "    query = f'{root}{ext}{data_set_id}.data.csv{params}'\n",
    "\n",
    "    return query"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'http://www.nomisweb.co.uk/api/v01/dataset/NM_127_1.data.csv?geography=2092957699TYPE432&measures=20100&time=2020-12,2019-12,2018-12&item=1'"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dimension_filters = {\n",
    "    'GEOGRAPHY': '2092957699TYPE432',\n",
    "    'MEASURES': '20100',\n",
    "    'TIME': '2020-12,2019-12,2018-12',\n",
    "    'ITEM': '1'\n",
    "}\n",
    "\n",
    "query_string = make_query('NM_127_1', dimension_filters)\n",
    "query_string"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv(query_string)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(2781, 28)"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['DATE', 'DATE_NAME', 'DATE_CODE', 'DATE_TYPE', 'DATE_TYPECODE',\n",
       "       'DATE_SORTORDER', 'GEOGRAPHY', 'GEOGRAPHY_NAME', 'GEOGRAPHY_CODE',\n",
       "       'GEOGRAPHY_TYPE', 'GEOGRAPHY_TYPECODE', 'GEOGRAPHY_SORTORDER', 'ITEM',\n",
       "       'ITEM_NAME', 'ITEM_CODE', 'ITEM_TYPE', 'ITEM_TYPECODE',\n",
       "       'ITEM_SORTORDER', 'MEASURES', 'MEASURES_NAME', 'OBS_VALUE',\n",
       "       'OBS_STATUS', 'OBS_STATUS_NAME', 'OBS_CONF', 'OBS_CONF_NAME', 'URN',\n",
       "       'RECORD_OFFSET', 'RECORD_COUNT'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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 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>DATE</th>\n",
       "      <th>DATE_NAME</th>\n",
       "      <th>DATE_CODE</th>\n",
       "      <th>DATE_TYPE</th>\n",
       "      <th>DATE_TYPECODE</th>\n",
       "      <th>DATE_SORTORDER</th>\n",
       "      <th>GEOGRAPHY</th>\n",
       "      <th>GEOGRAPHY_NAME</th>\n",
       "      <th>GEOGRAPHY_CODE</th>\n",
       "      <th>GEOGRAPHY_TYPE</th>\n",
       "      <th>GEOGRAPHY_TYPECODE</th>\n",
       "      <th>GEOGRAPHY_SORTORDER</th>\n",
       "      <th>ITEM</th>\n",
       "      <th>ITEM_NAME</th>\n",
       "      <th>ITEM_CODE</th>\n",
       "      <th>ITEM_TYPE</th>\n",
       "      <th>ITEM_TYPECODE</th>\n",
       "      <th>ITEM_SORTORDER</th>\n",
       "      <th>MEASURES</th>\n",
       "      <th>MEASURES_NAME</th>\n",
       "      <th>OBS_VALUE</th>\n",
       "      <th>OBS_STATUS</th>\n",
       "      <th>OBS_STATUS_NAME</th>\n",
       "      <th>OBS_CONF</th>\n",
       "      <th>OBS_CONF_NAME</th>\n",
       "      <th>URN</th>\n",
       "      <th>RECORD_OFFSET</th>\n",
       "      <th>RECORD_COUNT</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939329</td>\n",
       "      <td>Darlington</td>\n",
       "      <td>E06000005</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939329d1d20100</td>\n",
       "      <td>0</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939330</td>\n",
       "      <td>County Durham</td>\n",
       "      <td>E06000047</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>12200.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939330d1d20100</td>\n",
       "      <td>1</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939331</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>E06000001</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>3700.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939331d1d20100</td>\n",
       "      <td>2</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939332</td>\n",
       "      <td>Middlesbrough</td>\n",
       "      <td>E06000002</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939332d1d20100</td>\n",
       "      <td>3</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939334</td>\n",
       "      <td>Northumberland</td>\n",
       "      <td>E06000057</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>6300.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939334d1d20100</td>\n",
       "      <td>4</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939335</td>\n",
       "      <td>Redcar and Cleveland</td>\n",
       "      <td>E06000003</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>3200.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939335d1d20100</td>\n",
       "      <td>5</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939336</td>\n",
       "      <td>Stockton-on-Tees</td>\n",
       "      <td>E06000004</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>5200.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939336d1d20100</td>\n",
       "      <td>6</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939338</td>\n",
       "      <td>Gateshead</td>\n",
       "      <td>E08000037</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>4800.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939338d1d20100</td>\n",
       "      <td>7</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939339</td>\n",
       "      <td>Newcastle upon Tyne</td>\n",
       "      <td>E08000021</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939339d1d20100</td>\n",
       "      <td>8</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939340</td>\n",
       "      <td>North Tyneside</td>\n",
       "      <td>E08000022</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>4700.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939340d1d20100</td>\n",
       "      <td>9</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939341</td>\n",
       "      <td>South Tyneside</td>\n",
       "      <td>E08000023</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939341d1d20100</td>\n",
       "      <td>10</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939342</td>\n",
       "      <td>Sunderland</td>\n",
       "      <td>E08000024</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>8200.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939342d1d20100</td>\n",
       "      <td>11</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939343</td>\n",
       "      <td>Blackburn with Darwen</td>\n",
       "      <td>E06000008</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>3500.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939343d1d20100</td>\n",
       "      <td>12</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939344</td>\n",
       "      <td>Blackpool</td>\n",
       "      <td>E06000009</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>3600.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939344d1d20100</td>\n",
       "      <td>13</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939345</td>\n",
       "      <td>Cheshire East</td>\n",
       "      <td>E06000049</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>14</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939345d1d20100</td>\n",
       "      <td>14</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939346</td>\n",
       "      <td>Cheshire West and Chester</td>\n",
       "      <td>E06000050</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>6100.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939346d1d20100</td>\n",
       "      <td>15</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939347</td>\n",
       "      <td>Halton</td>\n",
       "      <td>E06000006</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>16</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>2800.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939347d1d20100</td>\n",
       "      <td>16</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939348</td>\n",
       "      <td>Warrington</td>\n",
       "      <td>E06000007</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>4200.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939348d1d20100</td>\n",
       "      <td>17</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939349</td>\n",
       "      <td>Allerdale</td>\n",
       "      <td>E07000026</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939349d1d20100</td>\n",
       "      <td>18</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939350</td>\n",
       "      <td>Barrow-in-Furness</td>\n",
       "      <td>E07000027</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>19</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939350d1d20100</td>\n",
       "      <td>19</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939351</td>\n",
       "      <td>Carlisle</td>\n",
       "      <td>E07000028</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939351d1d20100</td>\n",
       "      <td>20</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939352</td>\n",
       "      <td>Copeland</td>\n",
       "      <td>E07000029</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>21</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>1300.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939352d1d20100</td>\n",
       "      <td>21</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939353</td>\n",
       "      <td>Eden</td>\n",
       "      <td>E07000030</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>22</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>500.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939353d1d20100</td>\n",
       "      <td>22</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939354</td>\n",
       "      <td>South Lakeland</td>\n",
       "      <td>E07000031</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>900.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939354d1d20100</td>\n",
       "      <td>23</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939355</td>\n",
       "      <td>Bolton</td>\n",
       "      <td>E08000001</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>6500.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939355d1d20100</td>\n",
       "      <td>24</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939356</td>\n",
       "      <td>Bury</td>\n",
       "      <td>E08000002</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>3700.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939356d1d20100</td>\n",
       "      <td>25</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939357</td>\n",
       "      <td>Manchester</td>\n",
       "      <td>E08000003</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>26</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>14900.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939357d1d20100</td>\n",
       "      <td>26</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939358</td>\n",
       "      <td>Oldham</td>\n",
       "      <td>E08000004</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>5600.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939358d1d20100</td>\n",
       "      <td>27</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939359</td>\n",
       "      <td>Rochdale</td>\n",
       "      <td>E08000005</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>5200.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939359d1d20100</td>\n",
       "      <td>28</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939360</td>\n",
       "      <td>Salford</td>\n",
       "      <td>E08000006</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>29</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>6800.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939360d1d20100</td>\n",
       "      <td>29</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939361</td>\n",
       "      <td>Stockport</td>\n",
       "      <td>E08000007</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>4600.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939361d1d20100</td>\n",
       "      <td>30</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939362</td>\n",
       "      <td>Tameside</td>\n",
       "      <td>E08000008</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>31</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>5300.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939362d1d20100</td>\n",
       "      <td>31</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939363</td>\n",
       "      <td>Trafford</td>\n",
       "      <td>E08000009</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>4300.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939363d1d20100</td>\n",
       "      <td>32</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939364</td>\n",
       "      <td>Wigan</td>\n",
       "      <td>E08000010</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>6600.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939364d1d20100</td>\n",
       "      <td>33</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939365</td>\n",
       "      <td>Burnley</td>\n",
       "      <td>E07000117</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>34</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>2300.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939365d1d20100</td>\n",
       "      <td>34</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939366</td>\n",
       "      <td>Chorley</td>\n",
       "      <td>E07000118</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>35</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>1800.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939366d1d20100</td>\n",
       "      <td>35</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939367</td>\n",
       "      <td>Fylde</td>\n",
       "      <td>E07000119</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>36</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>900.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939367d1d20100</td>\n",
       "      <td>36</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939368</td>\n",
       "      <td>Hyndburn</td>\n",
       "      <td>E07000120</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>37</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>1800.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939368d1d20100</td>\n",
       "      <td>37</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939369</td>\n",
       "      <td>Lancaster</td>\n",
       "      <td>E07000121</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>38</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>3400.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939369d1d20100</td>\n",
       "      <td>38</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939370</td>\n",
       "      <td>Pendle</td>\n",
       "      <td>E07000122</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>39</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>1800.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939370d1d20100</td>\n",
       "      <td>39</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939371</td>\n",
       "      <td>Preston</td>\n",
       "      <td>E07000123</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>3300.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939371d1d20100</td>\n",
       "      <td>40</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939372</td>\n",
       "      <td>Ribble Valley</td>\n",
       "      <td>E07000124</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>41</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>700.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939372d1d20100</td>\n",
       "      <td>41</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939373</td>\n",
       "      <td>Rossendale</td>\n",
       "      <td>E07000125</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>42</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939373d1d20100</td>\n",
       "      <td>42</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939374</td>\n",
       "      <td>South Ribble</td>\n",
       "      <td>E07000126</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>43</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939374d1d20100</td>\n",
       "      <td>43</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939375</td>\n",
       "      <td>West Lancashire</td>\n",
       "      <td>E07000127</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>44</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>2300.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939375d1d20100</td>\n",
       "      <td>44</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939376</td>\n",
       "      <td>Wyre</td>\n",
       "      <td>E07000128</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>45</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939376d1d20100</td>\n",
       "      <td>45</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939377</td>\n",
       "      <td>Knowsley</td>\n",
       "      <td>E08000011</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>46</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939377d1d20100</td>\n",
       "      <td>46</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939378</td>\n",
       "      <td>Liverpool</td>\n",
       "      <td>E08000012</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>47</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>9600.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939378d1d20100</td>\n",
       "      <td>47</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939379</td>\n",
       "      <td>Sefton</td>\n",
       "      <td>E08000014</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>48</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>4100.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939379d1d20100</td>\n",
       "      <td>48</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939380</td>\n",
       "      <td>St. Helens</td>\n",
       "      <td>E08000013</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>49</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>2900.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939380d1d20100</td>\n",
       "      <td>49</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939381</td>\n",
       "      <td>Wirral</td>\n",
       "      <td>E08000015</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>4200.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939381d1d20100</td>\n",
       "      <td>50</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939382</td>\n",
       "      <td>East Riding of Yorkshire</td>\n",
       "      <td>E06000011</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>51</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>5400.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939382d1d20100</td>\n",
       "      <td>51</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939383</td>\n",
       "      <td>Kingston upon Hull, City of</td>\n",
       "      <td>E06000010</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>52</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>7800.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939383d1d20100</td>\n",
       "      <td>52</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939384</td>\n",
       "      <td>North East Lincolnshire</td>\n",
       "      <td>E06000012</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>53</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>4400.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939384d1d20100</td>\n",
       "      <td>53</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939385</td>\n",
       "      <td>North Lincolnshire</td>\n",
       "      <td>E06000013</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>54</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>4300.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939385d1d20100</td>\n",
       "      <td>54</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939386</td>\n",
       "      <td>York</td>\n",
       "      <td>E06000014</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>55</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>3500.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939386d1d20100</td>\n",
       "      <td>55</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939387</td>\n",
       "      <td>Craven</td>\n",
       "      <td>E07000163</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>56</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>800.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939387d1d20100</td>\n",
       "      <td>56</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939388</td>\n",
       "      <td>Hambleton</td>\n",
       "      <td>E07000164</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>57</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>1300.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939388d1d20100</td>\n",
       "      <td>57</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939389</td>\n",
       "      <td>Harrogate</td>\n",
       "      <td>E07000165</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>58</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>2600.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939389d1d20100</td>\n",
       "      <td>58</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939390</td>\n",
       "      <td>Richmondshire</td>\n",
       "      <td>E07000166</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>59</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>800.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939390d1d20100</td>\n",
       "      <td>59</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939391</td>\n",
       "      <td>Ryedale</td>\n",
       "      <td>E07000167</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>60</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>700.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939391d1d20100</td>\n",
       "      <td>60</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939392</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>E07000168</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>61</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>1700.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939392d1d20100</td>\n",
       "      <td>61</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939393</td>\n",
       "      <td>Selby</td>\n",
       "      <td>E07000169</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>62</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939393d1d20100</td>\n",
       "      <td>62</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939394</td>\n",
       "      <td>Barnsley</td>\n",
       "      <td>E08000016</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>63</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>5900.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939394d1d20100</td>\n",
       "      <td>63</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939395</td>\n",
       "      <td>Doncaster</td>\n",
       "      <td>E08000017</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>64</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>8300.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939395d1d20100</td>\n",
       "      <td>64</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939396</td>\n",
       "      <td>Rotherham</td>\n",
       "      <td>E08000018</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>65</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>6100.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939396d1d20100</td>\n",
       "      <td>65</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939397</td>\n",
       "      <td>Sheffield</td>\n",
       "      <td>E08000019</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>66</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>14400.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939397d1d20100</td>\n",
       "      <td>66</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939398</td>\n",
       "      <td>Bradford</td>\n",
       "      <td>E08000032</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>67</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>11700.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939398d1d20100</td>\n",
       "      <td>67</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939399</td>\n",
       "      <td>Calderdale</td>\n",
       "      <td>E08000033</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>68</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>4400.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939399d1d20100</td>\n",
       "      <td>68</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939400</td>\n",
       "      <td>Kirklees</td>\n",
       "      <td>E08000034</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>69</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>10300.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939400d1d20100</td>\n",
       "      <td>69</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939401</td>\n",
       "      <td>Leeds</td>\n",
       "      <td>E08000035</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>70</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>16300.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939401d1d20100</td>\n",
       "      <td>70</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939402</td>\n",
       "      <td>Wakefield</td>\n",
       "      <td>E08000036</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>71</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>8100.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939402d1d20100</td>\n",
       "      <td>71</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939403</td>\n",
       "      <td>Derby</td>\n",
       "      <td>E06000015</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>72</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>5900.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939403d1d20100</td>\n",
       "      <td>72</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939404</td>\n",
       "      <td>Leicester</td>\n",
       "      <td>E06000016</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>73</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>9300.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939404d1d20100</td>\n",
       "      <td>73</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939405</td>\n",
       "      <td>Nottingham</td>\n",
       "      <td>E06000018</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>74</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>10900.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939405d1d20100</td>\n",
       "      <td>74</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939406</td>\n",
       "      <td>Rutland</td>\n",
       "      <td>E06000017</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>75</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>600.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939406d1d20100</td>\n",
       "      <td>75</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939407</td>\n",
       "      <td>Amber Valley</td>\n",
       "      <td>E07000032</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>76</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939407d1d20100</td>\n",
       "      <td>76</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939408</td>\n",
       "      <td>Bolsover</td>\n",
       "      <td>E07000033</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>77</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>1900.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939408d1d20100</td>\n",
       "      <td>77</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939409</td>\n",
       "      <td>Chesterfield</td>\n",
       "      <td>E07000034</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>78</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>2700.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939409d1d20100</td>\n",
       "      <td>78</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939410</td>\n",
       "      <td>Derbyshire Dales</td>\n",
       "      <td>E07000035</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>79</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>1100.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939410d1d20100</td>\n",
       "      <td>79</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939411</td>\n",
       "      <td>Erewash</td>\n",
       "      <td>E07000036</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>80</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939411d1d20100</td>\n",
       "      <td>80</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939412</td>\n",
       "      <td>High Peak</td>\n",
       "      <td>E07000037</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>81</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>1800.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939412d1d20100</td>\n",
       "      <td>81</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939413</td>\n",
       "      <td>North East Derbyshire</td>\n",
       "      <td>E07000038</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>82</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939413d1d20100</td>\n",
       "      <td>82</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939414</td>\n",
       "      <td>South Derbyshire</td>\n",
       "      <td>E07000039</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>83</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>1800.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939414d1d20100</td>\n",
       "      <td>83</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939415</td>\n",
       "      <td>Blaby</td>\n",
       "      <td>E07000129</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>84</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>1800.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939415d1d20100</td>\n",
       "      <td>84</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939416</td>\n",
       "      <td>Charnwood</td>\n",
       "      <td>E07000130</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>85</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>3800.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939416d1d20100</td>\n",
       "      <td>85</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939417</td>\n",
       "      <td>Harborough</td>\n",
       "      <td>E07000131</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>86</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939417d1d20100</td>\n",
       "      <td>86</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939418</td>\n",
       "      <td>Hinckley and Bosworth</td>\n",
       "      <td>E07000132</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>87</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>2200.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939418d1d20100</td>\n",
       "      <td>87</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939419</td>\n",
       "      <td>Melton</td>\n",
       "      <td>E07000133</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>88</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>1100.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939419d1d20100</td>\n",
       "      <td>88</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939420</td>\n",
       "      <td>North West Leicestershire</td>\n",
       "      <td>E07000134</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>89</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>2100.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939420d1d20100</td>\n",
       "      <td>89</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939421</td>\n",
       "      <td>Oadby and Wigston</td>\n",
       "      <td>E07000135</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>90</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939421d1d20100</td>\n",
       "      <td>90</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939422</td>\n",
       "      <td>Boston</td>\n",
       "      <td>E07000136</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>91</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939422d1d20100</td>\n",
       "      <td>91</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939423</td>\n",
       "      <td>East Lindsey</td>\n",
       "      <td>E07000137</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>92</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>2700.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939423d1d20100</td>\n",
       "      <td>92</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939424</td>\n",
       "      <td>Lincoln</td>\n",
       "      <td>E07000138</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>93</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>3200.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939424d1d20100</td>\n",
       "      <td>93</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939425</td>\n",
       "      <td>North Kesteven</td>\n",
       "      <td>E07000139</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>94</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939425d1d20100</td>\n",
       "      <td>94</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939426</td>\n",
       "      <td>South Holland</td>\n",
       "      <td>E07000140</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>95</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>1800.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939426d1d20100</td>\n",
       "      <td>95</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939427</td>\n",
       "      <td>South Kesteven</td>\n",
       "      <td>E07000141</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>96</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>2900.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939427d1d20100</td>\n",
       "      <td>96</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939428</td>\n",
       "      <td>West Lindsey</td>\n",
       "      <td>E07000142</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>97</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>2100.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939428d1d20100</td>\n",
       "      <td>97</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939436</td>\n",
       "      <td>Ashfield</td>\n",
       "      <td>E07000170</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>98</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939436d1d20100</td>\n",
       "      <td>98</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>2018-12</td>\n",
       "      <td>Jan 2018-Dec 2018</td>\n",
       "      <td>2018-12</td>\n",
       "      <td>date</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1811939437</td>\n",
       "      <td>Bassetlaw</td>\n",
       "      <td>E07000171</td>\n",
       "      <td>local authorities: district / unitary (as of April 2021)</td>\n",
       "      <td>432</td>\n",
       "      <td>99</td>\n",
       "      <td>1</td>\n",
       "      <td>Unemployment count (model based)</td>\n",
       "      <td>1</td>\n",
       "      <td>item</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20100</td>\n",
       "      <td>Value</td>\n",
       "      <td>2800.0</td>\n",
       "      <td>A</td>\n",
       "      <td>Normal Value</td>\n",
       "      <td>F</td>\n",
       "      <td>Free (free for publication)</td>\n",
       "      <td>Nm-127d1d32300e0d1811939437d1d20100</td>\n",
       "      <td>99</td>\n",
       "      <td>2781</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       DATE          DATE_NAME DATE_CODE DATE_TYPE  DATE_TYPECODE  \\\n",
       "0   2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "1   2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "2   2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "3   2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "4   2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "5   2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "6   2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "7   2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "8   2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "9   2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "10  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "11  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "12  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "13  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "14  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "15  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "16  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "17  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "18  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "19  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "20  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "21  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "22  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "23  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "24  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "25  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "26  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "27  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "28  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "29  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "30  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "31  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "32  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "33  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "34  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "35  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "36  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "37  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "38  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "39  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "40  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "41  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "42  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "43  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "44  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "45  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "46  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "47  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "48  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "49  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "50  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "51  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "52  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "53  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "54  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "55  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "56  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "57  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "58  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "59  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "60  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "61  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "62  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "63  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "64  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "65  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "66  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "67  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "68  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "69  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "70  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "71  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "72  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "73  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "74  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "75  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "76  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "77  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "78  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "79  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "80  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "81  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "82  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "83  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "84  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "85  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "86  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "87  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "88  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "89  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "90  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "91  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "92  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "93  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "94  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "95  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "96  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "97  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "98  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "99  2018-12  Jan 2018-Dec 2018   2018-12      date              0   \n",
       "\n",
       "    DATE_SORTORDER   GEOGRAPHY               GEOGRAPHY_NAME GEOGRAPHY_CODE  \\\n",
       "0                0  1811939329                   Darlington      E06000005   \n",
       "1                0  1811939330                County Durham      E06000047   \n",
       "2                0  1811939331                   Hartlepool      E06000001   \n",
       "3                0  1811939332                Middlesbrough      E06000002   \n",
       "4                0  1811939334               Northumberland      E06000057   \n",
       "5                0  1811939335         Redcar and Cleveland      E06000003   \n",
       "6                0  1811939336             Stockton-on-Tees      E06000004   \n",
       "7                0  1811939338                    Gateshead      E08000037   \n",
       "8                0  1811939339          Newcastle upon Tyne      E08000021   \n",
       "9                0  1811939340               North Tyneside      E08000022   \n",
       "10               0  1811939341               South Tyneside      E08000023   \n",
       "11               0  1811939342                   Sunderland      E08000024   \n",
       "12               0  1811939343        Blackburn with Darwen      E06000008   \n",
       "13               0  1811939344                    Blackpool      E06000009   \n",
       "14               0  1811939345                Cheshire East      E06000049   \n",
       "15               0  1811939346    Cheshire West and Chester      E06000050   \n",
       "16               0  1811939347                       Halton      E06000006   \n",
       "17               0  1811939348                   Warrington      E06000007   \n",
       "18               0  1811939349                    Allerdale      E07000026   \n",
       "19               0  1811939350            Barrow-in-Furness      E07000027   \n",
       "20               0  1811939351                     Carlisle      E07000028   \n",
       "21               0  1811939352                     Copeland      E07000029   \n",
       "22               0  1811939353                         Eden      E07000030   \n",
       "23               0  1811939354               South Lakeland      E07000031   \n",
       "24               0  1811939355                       Bolton      E08000001   \n",
       "25               0  1811939356                         Bury      E08000002   \n",
       "26               0  1811939357                   Manchester      E08000003   \n",
       "27               0  1811939358                       Oldham      E08000004   \n",
       "28               0  1811939359                     Rochdale      E08000005   \n",
       "29               0  1811939360                      Salford      E08000006   \n",
       "30               0  1811939361                    Stockport      E08000007   \n",
       "31               0  1811939362                     Tameside      E08000008   \n",
       "32               0  1811939363                     Trafford      E08000009   \n",
       "33               0  1811939364                        Wigan      E08000010   \n",
       "34               0  1811939365                      Burnley      E07000117   \n",
       "35               0  1811939366                      Chorley      E07000118   \n",
       "36               0  1811939367                        Fylde      E07000119   \n",
       "37               0  1811939368                     Hyndburn      E07000120   \n",
       "38               0  1811939369                    Lancaster      E07000121   \n",
       "39               0  1811939370                       Pendle      E07000122   \n",
       "40               0  1811939371                      Preston      E07000123   \n",
       "41               0  1811939372                Ribble Valley      E07000124   \n",
       "42               0  1811939373                   Rossendale      E07000125   \n",
       "43               0  1811939374                 South Ribble      E07000126   \n",
       "44               0  1811939375              West Lancashire      E07000127   \n",
       "45               0  1811939376                         Wyre      E07000128   \n",
       "46               0  1811939377                     Knowsley      E08000011   \n",
       "47               0  1811939378                    Liverpool      E08000012   \n",
       "48               0  1811939379                       Sefton      E08000014   \n",
       "49               0  1811939380                   St. Helens      E08000013   \n",
       "50               0  1811939381                       Wirral      E08000015   \n",
       "51               0  1811939382     East Riding of Yorkshire      E06000011   \n",
       "52               0  1811939383  Kingston upon Hull, City of      E06000010   \n",
       "53               0  1811939384      North East Lincolnshire      E06000012   \n",
       "54               0  1811939385           North Lincolnshire      E06000013   \n",
       "55               0  1811939386                         York      E06000014   \n",
       "56               0  1811939387                       Craven      E07000163   \n",
       "57               0  1811939388                    Hambleton      E07000164   \n",
       "58               0  1811939389                    Harrogate      E07000165   \n",
       "59               0  1811939390                Richmondshire      E07000166   \n",
       "60               0  1811939391                      Ryedale      E07000167   \n",
       "61               0  1811939392                  Scarborough      E07000168   \n",
       "62               0  1811939393                        Selby      E07000169   \n",
       "63               0  1811939394                     Barnsley      E08000016   \n",
       "64               0  1811939395                    Doncaster      E08000017   \n",
       "65               0  1811939396                    Rotherham      E08000018   \n",
       "66               0  1811939397                    Sheffield      E08000019   \n",
       "67               0  1811939398                     Bradford      E08000032   \n",
       "68               0  1811939399                   Calderdale      E08000033   \n",
       "69               0  1811939400                     Kirklees      E08000034   \n",
       "70               0  1811939401                        Leeds      E08000035   \n",
       "71               0  1811939402                    Wakefield      E08000036   \n",
       "72               0  1811939403                        Derby      E06000015   \n",
       "73               0  1811939404                    Leicester      E06000016   \n",
       "74               0  1811939405                   Nottingham      E06000018   \n",
       "75               0  1811939406                      Rutland      E06000017   \n",
       "76               0  1811939407                 Amber Valley      E07000032   \n",
       "77               0  1811939408                     Bolsover      E07000033   \n",
       "78               0  1811939409                 Chesterfield      E07000034   \n",
       "79               0  1811939410             Derbyshire Dales      E07000035   \n",
       "80               0  1811939411                      Erewash      E07000036   \n",
       "81               0  1811939412                    High Peak      E07000037   \n",
       "82               0  1811939413        North East Derbyshire      E07000038   \n",
       "83               0  1811939414             South Derbyshire      E07000039   \n",
       "84               0  1811939415                        Blaby      E07000129   \n",
       "85               0  1811939416                    Charnwood      E07000130   \n",
       "86               0  1811939417                   Harborough      E07000131   \n",
       "87               0  1811939418        Hinckley and Bosworth      E07000132   \n",
       "88               0  1811939419                       Melton      E07000133   \n",
       "89               0  1811939420    North West Leicestershire      E07000134   \n",
       "90               0  1811939421            Oadby and Wigston      E07000135   \n",
       "91               0  1811939422                       Boston      E07000136   \n",
       "92               0  1811939423                 East Lindsey      E07000137   \n",
       "93               0  1811939424                      Lincoln      E07000138   \n",
       "94               0  1811939425               North Kesteven      E07000139   \n",
       "95               0  1811939426                South Holland      E07000140   \n",
       "96               0  1811939427               South Kesteven      E07000141   \n",
       "97               0  1811939428                 West Lindsey      E07000142   \n",
       "98               0  1811939436                     Ashfield      E07000170   \n",
       "99               0  1811939437                    Bassetlaw      E07000171   \n",
       "\n",
       "                                              GEOGRAPHY_TYPE  \\\n",
       "0   local authorities: district / unitary (as of April 2021)   \n",
       "1   local authorities: district / unitary (as of April 2021)   \n",
       "2   local authorities: district / unitary (as of April 2021)   \n",
       "3   local authorities: district / unitary (as of April 2021)   \n",
       "4   local authorities: district / unitary (as of April 2021)   \n",
       "5   local authorities: district / unitary (as of April 2021)   \n",
       "6   local authorities: district / unitary (as of April 2021)   \n",
       "7   local authorities: district / unitary (as of April 2021)   \n",
       "8   local authorities: district / unitary (as of April 2021)   \n",
       "9   local authorities: district / unitary (as of April 2021)   \n",
       "10  local authorities: district / unitary (as of April 2021)   \n",
       "11  local authorities: district / unitary (as of April 2021)   \n",
       "12  local authorities: district / unitary (as of April 2021)   \n",
       "13  local authorities: district / unitary (as of April 2021)   \n",
       "14  local authorities: district / unitary (as of April 2021)   \n",
       "15  local authorities: district / unitary (as of April 2021)   \n",
       "16  local authorities: district / unitary (as of April 2021)   \n",
       "17  local authorities: district / unitary (as of April 2021)   \n",
       "18  local authorities: district / unitary (as of April 2021)   \n",
       "19  local authorities: district / unitary (as of April 2021)   \n",
       "20  local authorities: district / unitary (as of April 2021)   \n",
       "21  local authorities: district / unitary (as of April 2021)   \n",
       "22  local authorities: district / unitary (as of April 2021)   \n",
       "23  local authorities: district / unitary (as of April 2021)   \n",
       "24  local authorities: district / unitary (as of April 2021)   \n",
       "25  local authorities: district / unitary (as of April 2021)   \n",
       "26  local authorities: district / unitary (as of April 2021)   \n",
       "27  local authorities: district / unitary (as of April 2021)   \n",
       "28  local authorities: district / unitary (as of April 2021)   \n",
       "29  local authorities: district / unitary (as of April 2021)   \n",
       "30  local authorities: district / unitary (as of April 2021)   \n",
       "31  local authorities: district / unitary (as of April 2021)   \n",
       "32  local authorities: district / unitary (as of April 2021)   \n",
       "33  local authorities: district / unitary (as of April 2021)   \n",
       "34  local authorities: district / unitary (as of April 2021)   \n",
       "35  local authorities: district / unitary (as of April 2021)   \n",
       "36  local authorities: district / unitary (as of April 2021)   \n",
       "37  local authorities: district / unitary (as of April 2021)   \n",
       "38  local authorities: district / unitary (as of April 2021)   \n",
       "39  local authorities: district / unitary (as of April 2021)   \n",
       "40  local authorities: district / unitary (as of April 2021)   \n",
       "41  local authorities: district / unitary (as of April 2021)   \n",
       "42  local authorities: district / unitary (as of April 2021)   \n",
       "43  local authorities: district / unitary (as of April 2021)   \n",
       "44  local authorities: district / unitary (as of April 2021)   \n",
       "45  local authorities: district / unitary (as of April 2021)   \n",
       "46  local authorities: district / unitary (as of April 2021)   \n",
       "47  local authorities: district / unitary (as of April 2021)   \n",
       "48  local authorities: district / unitary (as of April 2021)   \n",
       "49  local authorities: district / unitary (as of April 2021)   \n",
       "50  local authorities: district / unitary (as of April 2021)   \n",
       "51  local authorities: district / unitary (as of April 2021)   \n",
       "52  local authorities: district / unitary (as of April 2021)   \n",
       "53  local authorities: district / unitary (as of April 2021)   \n",
       "54  local authorities: district / unitary (as of April 2021)   \n",
       "55  local authorities: district / unitary (as of April 2021)   \n",
       "56  local authorities: district / unitary (as of April 2021)   \n",
       "57  local authorities: district / unitary (as of April 2021)   \n",
       "58  local authorities: district / unitary (as of April 2021)   \n",
       "59  local authorities: district / unitary (as of April 2021)   \n",
       "60  local authorities: district / unitary (as of April 2021)   \n",
       "61  local authorities: district / unitary (as of April 2021)   \n",
       "62  local authorities: district / unitary (as of April 2021)   \n",
       "63  local authorities: district / unitary (as of April 2021)   \n",
       "64  local authorities: district / unitary (as of April 2021)   \n",
       "65  local authorities: district / unitary (as of April 2021)   \n",
       "66  local authorities: district / unitary (as of April 2021)   \n",
       "67  local authorities: district / unitary (as of April 2021)   \n",
       "68  local authorities: district / unitary (as of April 2021)   \n",
       "69  local authorities: district / unitary (as of April 2021)   \n",
       "70  local authorities: district / unitary (as of April 2021)   \n",
       "71  local authorities: district / unitary (as of April 2021)   \n",
       "72  local authorities: district / unitary (as of April 2021)   \n",
       "73  local authorities: district / unitary (as of April 2021)   \n",
       "74  local authorities: district / unitary (as of April 2021)   \n",
       "75  local authorities: district / unitary (as of April 2021)   \n",
       "76  local authorities: district / unitary (as of April 2021)   \n",
       "77  local authorities: district / unitary (as of April 2021)   \n",
       "78  local authorities: district / unitary (as of April 2021)   \n",
       "79  local authorities: district / unitary (as of April 2021)   \n",
       "80  local authorities: district / unitary (as of April 2021)   \n",
       "81  local authorities: district / unitary (as of April 2021)   \n",
       "82  local authorities: district / unitary (as of April 2021)   \n",
       "83  local authorities: district / unitary (as of April 2021)   \n",
       "84  local authorities: district / unitary (as of April 2021)   \n",
       "85  local authorities: district / unitary (as of April 2021)   \n",
       "86  local authorities: district / unitary (as of April 2021)   \n",
       "87  local authorities: district / unitary (as of April 2021)   \n",
       "88  local authorities: district / unitary (as of April 2021)   \n",
       "89  local authorities: district / unitary (as of April 2021)   \n",
       "90  local authorities: district / unitary (as of April 2021)   \n",
       "91  local authorities: district / unitary (as of April 2021)   \n",
       "92  local authorities: district / unitary (as of April 2021)   \n",
       "93  local authorities: district / unitary (as of April 2021)   \n",
       "94  local authorities: district / unitary (as of April 2021)   \n",
       "95  local authorities: district / unitary (as of April 2021)   \n",
       "96  local authorities: district / unitary (as of April 2021)   \n",
       "97  local authorities: district / unitary (as of April 2021)   \n",
       "98  local authorities: district / unitary (as of April 2021)   \n",
       "99  local authorities: district / unitary (as of April 2021)   \n",
       "\n",
       "    GEOGRAPHY_TYPECODE  GEOGRAPHY_SORTORDER  ITEM  \\\n",
       "0                  432                    0     1   \n",
       "1                  432                    1     1   \n",
       "2                  432                    2     1   \n",
       "3                  432                    3     1   \n",
       "4                  432                    4     1   \n",
       "5                  432                    5     1   \n",
       "6                  432                    6     1   \n",
       "7                  432                    7     1   \n",
       "8                  432                    8     1   \n",
       "9                  432                    9     1   \n",
       "10                 432                   10     1   \n",
       "11                 432                   11     1   \n",
       "12                 432                   12     1   \n",
       "13                 432                   13     1   \n",
       "14                 432                   14     1   \n",
       "15                 432                   15     1   \n",
       "16                 432                   16     1   \n",
       "17                 432                   17     1   \n",
       "18                 432                   18     1   \n",
       "19                 432                   19     1   \n",
       "20                 432                   20     1   \n",
       "21                 432                   21     1   \n",
       "22                 432                   22     1   \n",
       "23                 432                   23     1   \n",
       "24                 432                   24     1   \n",
       "25                 432                   25     1   \n",
       "26                 432                   26     1   \n",
       "27                 432                   27     1   \n",
       "28                 432                   28     1   \n",
       "29                 432                   29     1   \n",
       "30                 432                   30     1   \n",
       "31                 432                   31     1   \n",
       "32                 432                   32     1   \n",
       "33                 432                   33     1   \n",
       "34                 432                   34     1   \n",
       "35                 432                   35     1   \n",
       "36                 432                   36     1   \n",
       "37                 432                   37     1   \n",
       "38                 432                   38     1   \n",
       "39                 432                   39     1   \n",
       "40                 432                   40     1   \n",
       "41                 432                   41     1   \n",
       "42                 432                   42     1   \n",
       "43                 432                   43     1   \n",
       "44                 432                   44     1   \n",
       "45                 432                   45     1   \n",
       "46                 432                   46     1   \n",
       "47                 432                   47     1   \n",
       "48                 432                   48     1   \n",
       "49                 432                   49     1   \n",
       "50                 432                   50     1   \n",
       "51                 432                   51     1   \n",
       "52                 432                   52     1   \n",
       "53                 432                   53     1   \n",
       "54                 432                   54     1   \n",
       "55                 432                   55     1   \n",
       "56                 432                   56     1   \n",
       "57                 432                   57     1   \n",
       "58                 432                   58     1   \n",
       "59                 432                   59     1   \n",
       "60                 432                   60     1   \n",
       "61                 432                   61     1   \n",
       "62                 432                   62     1   \n",
       "63                 432                   63     1   \n",
       "64                 432                   64     1   \n",
       "65                 432                   65     1   \n",
       "66                 432                   66     1   \n",
       "67                 432                   67     1   \n",
       "68                 432                   68     1   \n",
       "69                 432                   69     1   \n",
       "70                 432                   70     1   \n",
       "71                 432                   71     1   \n",
       "72                 432                   72     1   \n",
       "73                 432                   73     1   \n",
       "74                 432                   74     1   \n",
       "75                 432                   75     1   \n",
       "76                 432                   76     1   \n",
       "77                 432                   77     1   \n",
       "78                 432                   78     1   \n",
       "79                 432                   79     1   \n",
       "80                 432                   80     1   \n",
       "81                 432                   81     1   \n",
       "82                 432                   82     1   \n",
       "83                 432                   83     1   \n",
       "84                 432                   84     1   \n",
       "85                 432                   85     1   \n",
       "86                 432                   86     1   \n",
       "87                 432                   87     1   \n",
       "88                 432                   88     1   \n",
       "89                 432                   89     1   \n",
       "90                 432                   90     1   \n",
       "91                 432                   91     1   \n",
       "92                 432                   92     1   \n",
       "93                 432                   93     1   \n",
       "94                 432                   94     1   \n",
       "95                 432                   95     1   \n",
       "96                 432                   96     1   \n",
       "97                 432                   97     1   \n",
       "98                 432                   98     1   \n",
       "99                 432                   99     1   \n",
       "\n",
       "                           ITEM_NAME  ITEM_CODE ITEM_TYPE  ITEM_TYPECODE  \\\n",
       "0   Unemployment count (model based)          1      item              0   \n",
       "1   Unemployment count (model based)          1      item              0   \n",
       "2   Unemployment count (model based)          1      item              0   \n",
       "3   Unemployment count (model based)          1      item              0   \n",
       "4   Unemployment count (model based)          1      item              0   \n",
       "5   Unemployment count (model based)          1      item              0   \n",
       "6   Unemployment count (model based)          1      item              0   \n",
       "7   Unemployment count (model based)          1      item              0   \n",
       "8   Unemployment count (model based)          1      item              0   \n",
       "9   Unemployment count (model based)          1      item              0   \n",
       "10  Unemployment count (model based)          1      item              0   \n",
       "11  Unemployment count (model based)          1      item              0   \n",
       "12  Unemployment count (model based)          1      item              0   \n",
       "13  Unemployment count (model based)          1      item              0   \n",
       "14  Unemployment count (model based)          1      item              0   \n",
       "15  Unemployment count (model based)          1      item              0   \n",
       "16  Unemployment count (model based)          1      item              0   \n",
       "17  Unemployment count (model based)          1      item              0   \n",
       "18  Unemployment count (model based)          1      item              0   \n",
       "19  Unemployment count (model based)          1      item              0   \n",
       "20  Unemployment count (model based)          1      item              0   \n",
       "21  Unemployment count (model based)          1      item              0   \n",
       "22  Unemployment count (model based)          1      item              0   \n",
       "23  Unemployment count (model based)          1      item              0   \n",
       "24  Unemployment count (model based)          1      item              0   \n",
       "25  Unemployment count (model based)          1      item              0   \n",
       "26  Unemployment count (model based)          1      item              0   \n",
       "27  Unemployment count (model based)          1      item              0   \n",
       "28  Unemployment count (model based)          1      item              0   \n",
       "29  Unemployment count (model based)          1      item              0   \n",
       "30  Unemployment count (model based)          1      item              0   \n",
       "31  Unemployment count (model based)          1      item              0   \n",
       "32  Unemployment count (model based)          1      item              0   \n",
       "33  Unemployment count (model based)          1      item              0   \n",
       "34  Unemployment count (model based)          1      item              0   \n",
       "35  Unemployment count (model based)          1      item              0   \n",
       "36  Unemployment count (model based)          1      item              0   \n",
       "37  Unemployment count (model based)          1      item              0   \n",
       "38  Unemployment count (model based)          1      item              0   \n",
       "39  Unemployment count (model based)          1      item              0   \n",
       "40  Unemployment count (model based)          1      item              0   \n",
       "41  Unemployment count (model based)          1      item              0   \n",
       "42  Unemployment count (model based)          1      item              0   \n",
       "43  Unemployment count (model based)          1      item              0   \n",
       "44  Unemployment count (model based)          1      item              0   \n",
       "45  Unemployment count (model based)          1      item              0   \n",
       "46  Unemployment count (model based)          1      item              0   \n",
       "47  Unemployment count (model based)          1      item              0   \n",
       "48  Unemployment count (model based)          1      item              0   \n",
       "49  Unemployment count (model based)          1      item              0   \n",
       "50  Unemployment count (model based)          1      item              0   \n",
       "51  Unemployment count (model based)          1      item              0   \n",
       "52  Unemployment count (model based)          1      item              0   \n",
       "53  Unemployment count (model based)          1      item              0   \n",
       "54  Unemployment count (model based)          1      item              0   \n",
       "55  Unemployment count (model based)          1      item              0   \n",
       "56  Unemployment count (model based)          1      item              0   \n",
       "57  Unemployment count (model based)          1      item              0   \n",
       "58  Unemployment count (model based)          1      item              0   \n",
       "59  Unemployment count (model based)          1      item              0   \n",
       "60  Unemployment count (model based)          1      item              0   \n",
       "61  Unemployment count (model based)          1      item              0   \n",
       "62  Unemployment count (model based)          1      item              0   \n",
       "63  Unemployment count (model based)          1      item              0   \n",
       "64  Unemployment count (model based)          1      item              0   \n",
       "65  Unemployment count (model based)          1      item              0   \n",
       "66  Unemployment count (model based)          1      item              0   \n",
       "67  Unemployment count (model based)          1      item              0   \n",
       "68  Unemployment count (model based)          1      item              0   \n",
       "69  Unemployment count (model based)          1      item              0   \n",
       "70  Unemployment count (model based)          1      item              0   \n",
       "71  Unemployment count (model based)          1      item              0   \n",
       "72  Unemployment count (model based)          1      item              0   \n",
       "73  Unemployment count (model based)          1      item              0   \n",
       "74  Unemployment count (model based)          1      item              0   \n",
       "75  Unemployment count (model based)          1      item              0   \n",
       "76  Unemployment count (model based)          1      item              0   \n",
       "77  Unemployment count (model based)          1      item              0   \n",
       "78  Unemployment count (model based)          1      item              0   \n",
       "79  Unemployment count (model based)          1      item              0   \n",
       "80  Unemployment count (model based)          1      item              0   \n",
       "81  Unemployment count (model based)          1      item              0   \n",
       "82  Unemployment count (model based)          1      item              0   \n",
       "83  Unemployment count (model based)          1      item              0   \n",
       "84  Unemployment count (model based)          1      item              0   \n",
       "85  Unemployment count (model based)          1      item              0   \n",
       "86  Unemployment count (model based)          1      item              0   \n",
       "87  Unemployment count (model based)          1      item              0   \n",
       "88  Unemployment count (model based)          1      item              0   \n",
       "89  Unemployment count (model based)          1      item              0   \n",
       "90  Unemployment count (model based)          1      item              0   \n",
       "91  Unemployment count (model based)          1      item              0   \n",
       "92  Unemployment count (model based)          1      item              0   \n",
       "93  Unemployment count (model based)          1      item              0   \n",
       "94  Unemployment count (model based)          1      item              0   \n",
       "95  Unemployment count (model based)          1      item              0   \n",
       "96  Unemployment count (model based)          1      item              0   \n",
       "97  Unemployment count (model based)          1      item              0   \n",
       "98  Unemployment count (model based)          1      item              0   \n",
       "99  Unemployment count (model based)          1      item              0   \n",
       "\n",
       "    ITEM_SORTORDER  MEASURES MEASURES_NAME  OBS_VALUE OBS_STATUS  \\\n",
       "0                0     20100         Value     2500.0          A   \n",
       "1                0     20100         Value    12200.0          A   \n",
       "2                0     20100         Value     3700.0          A   \n",
       "3                0     20100         Value     4500.0          A   \n",
       "4                0     20100         Value     6300.0          A   \n",
       "5                0     20100         Value     3200.0          A   \n",
       "6                0     20100         Value     5200.0          A   \n",
       "7                0     20100         Value     4800.0          A   \n",
       "8                0     20100         Value     8000.0          A   \n",
       "9                0     20100         Value     4700.0          A   \n",
       "10               0     20100         Value     4500.0          A   \n",
       "11               0     20100         Value     8200.0          A   \n",
       "12               0     20100         Value     3500.0          A   \n",
       "13               0     20100         Value     3600.0          A   \n",
       "14               0     20100         Value     6000.0          A   \n",
       "15               0     20100         Value     6100.0          A   \n",
       "16               0     20100         Value     2800.0          A   \n",
       "17               0     20100         Value     4200.0          A   \n",
       "18               0     20100         Value     1500.0          A   \n",
       "19               0     20100         Value     1400.0          A   \n",
       "20               0     20100         Value     1400.0          A   \n",
       "21               0     20100         Value     1300.0          A   \n",
       "22               0     20100         Value      500.0          A   \n",
       "23               0     20100         Value      900.0          A   \n",
       "24               0     20100         Value     6500.0          A   \n",
       "25               0     20100         Value     3700.0          A   \n",
       "26               0     20100         Value    14900.0          A   \n",
       "27               0     20100         Value     5600.0          A   \n",
       "28               0     20100         Value     5200.0          A   \n",
       "29               0     20100         Value     6800.0          A   \n",
       "30               0     20100         Value     4600.0          A   \n",
       "31               0     20100         Value     5300.0          A   \n",
       "32               0     20100         Value     4300.0          A   \n",
       "33               0     20100         Value     6600.0          A   \n",
       "34               0     20100         Value     2300.0          A   \n",
       "35               0     20100         Value     1800.0          A   \n",
       "36               0     20100         Value      900.0          A   \n",
       "37               0     20100         Value     1800.0          A   \n",
       "38               0     20100         Value     3400.0          A   \n",
       "39               0     20100         Value     1800.0          A   \n",
       "40               0     20100         Value     3300.0          A   \n",
       "41               0     20100         Value      700.0          A   \n",
       "42               0     20100         Value     1500.0          A   \n",
       "43               0     20100         Value     2000.0          A   \n",
       "44               0     20100         Value     2300.0          A   \n",
       "45               0     20100         Value     1600.0          A   \n",
       "46               0     20100         Value     2500.0          A   \n",
       "47               0     20100         Value     9600.0          A   \n",
       "48               0     20100         Value     4100.0          A   \n",
       "49               0     20100         Value     2900.0          A   \n",
       "50               0     20100         Value     4200.0          A   \n",
       "51               0     20100         Value     5400.0          A   \n",
       "52               0     20100         Value     7800.0          A   \n",
       "53               0     20100         Value     4400.0          A   \n",
       "54               0     20100         Value     4300.0          A   \n",
       "55               0     20100         Value     3500.0          A   \n",
       "56               0     20100         Value      800.0          A   \n",
       "57               0     20100         Value     1300.0          A   \n",
       "58               0     20100         Value     2600.0          A   \n",
       "59               0     20100         Value      800.0          A   \n",
       "60               0     20100         Value      700.0          A   \n",
       "61               0     20100         Value     1700.0          A   \n",
       "62               0     20100         Value     1400.0          A   \n",
       "63               0     20100         Value     5900.0          A   \n",
       "64               0     20100         Value     8300.0          A   \n",
       "65               0     20100         Value     6100.0          A   \n",
       "66               0     20100         Value    14400.0          A   \n",
       "67               0     20100         Value    11700.0          A   \n",
       "68               0     20100         Value     4400.0          A   \n",
       "69               0     20100         Value    10300.0          A   \n",
       "70               0     20100         Value    16300.0          A   \n",
       "71               0     20100         Value     8100.0          A   \n",
       "72               0     20100         Value     5900.0          A   \n",
       "73               0     20100         Value     9300.0          A   \n",
       "74               0     20100         Value    10900.0          A   \n",
       "75               0     20100         Value      600.0          A   \n",
       "76               0     20100         Value     2500.0          A   \n",
       "77               0     20100         Value     1900.0          A   \n",
       "78               0     20100         Value     2700.0          A   \n",
       "79               0     20100         Value     1100.0          A   \n",
       "80               0     20100         Value     3000.0          A   \n",
       "81               0     20100         Value     1800.0          A   \n",
       "82               0     20100         Value     2000.0          A   \n",
       "83               0     20100         Value     1800.0          A   \n",
       "84               0     20100         Value     1800.0          A   \n",
       "85               0     20100         Value     3800.0          A   \n",
       "86               0     20100         Value     1600.0          A   \n",
       "87               0     20100         Value     2200.0          A   \n",
       "88               0     20100         Value     1100.0          A   \n",
       "89               0     20100         Value     2100.0          A   \n",
       "90               0     20100         Value     1000.0          A   \n",
       "91               0     20100         Value     1400.0          A   \n",
       "92               0     20100         Value     2700.0          A   \n",
       "93               0     20100         Value     3200.0          A   \n",
       "94               0     20100         Value     2000.0          A   \n",
       "95               0     20100         Value     1800.0          A   \n",
       "96               0     20100         Value     2900.0          A   \n",
       "97               0     20100         Value     2100.0          A   \n",
       "98               0     20100         Value     3000.0          A   \n",
       "99               0     20100         Value     2800.0          A   \n",
       "\n",
       "   OBS_STATUS_NAME OBS_CONF                OBS_CONF_NAME  \\\n",
       "0     Normal Value        F  Free (free for publication)   \n",
       "1     Normal Value        F  Free (free for publication)   \n",
       "2     Normal Value        F  Free (free for publication)   \n",
       "3     Normal Value        F  Free (free for publication)   \n",
       "4     Normal Value        F  Free (free for publication)   \n",
       "5     Normal Value        F  Free (free for publication)   \n",
       "6     Normal Value        F  Free (free for publication)   \n",
       "7     Normal Value        F  Free (free for publication)   \n",
       "8     Normal Value        F  Free (free for publication)   \n",
       "9     Normal Value        F  Free (free for publication)   \n",
       "10    Normal Value        F  Free (free for publication)   \n",
       "11    Normal Value        F  Free (free for publication)   \n",
       "12    Normal Value        F  Free (free for publication)   \n",
       "13    Normal Value        F  Free (free for publication)   \n",
       "14    Normal Value        F  Free (free for publication)   \n",
       "15    Normal Value        F  Free (free for publication)   \n",
       "16    Normal Value        F  Free (free for publication)   \n",
       "17    Normal Value        F  Free (free for publication)   \n",
       "18    Normal Value        F  Free (free for publication)   \n",
       "19    Normal Value        F  Free (free for publication)   \n",
       "20    Normal Value        F  Free (free for publication)   \n",
       "21    Normal Value        F  Free (free for publication)   \n",
       "22    Normal Value        F  Free (free for publication)   \n",
       "23    Normal Value        F  Free (free for publication)   \n",
       "24    Normal Value        F  Free (free for publication)   \n",
       "25    Normal Value        F  Free (free for publication)   \n",
       "26    Normal Value        F  Free (free for publication)   \n",
       "27    Normal Value        F  Free (free for publication)   \n",
       "28    Normal Value        F  Free (free for publication)   \n",
       "29    Normal Value        F  Free (free for publication)   \n",
       "30    Normal Value        F  Free (free for publication)   \n",
       "31    Normal Value        F  Free (free for publication)   \n",
       "32    Normal Value        F  Free (free for publication)   \n",
       "33    Normal Value        F  Free (free for publication)   \n",
       "34    Normal Value        F  Free (free for publication)   \n",
       "35    Normal Value        F  Free (free for publication)   \n",
       "36    Normal Value        F  Free (free for publication)   \n",
       "37    Normal Value        F  Free (free for publication)   \n",
       "38    Normal Value        F  Free (free for publication)   \n",
       "39    Normal Value        F  Free (free for publication)   \n",
       "40    Normal Value        F  Free (free for publication)   \n",
       "41    Normal Value        F  Free (free for publication)   \n",
       "42    Normal Value        F  Free (free for publication)   \n",
       "43    Normal Value        F  Free (free for publication)   \n",
       "44    Normal Value        F  Free (free for publication)   \n",
       "45    Normal Value        F  Free (free for publication)   \n",
       "46    Normal Value        F  Free (free for publication)   \n",
       "47    Normal Value        F  Free (free for publication)   \n",
       "48    Normal Value        F  Free (free for publication)   \n",
       "49    Normal Value        F  Free (free for publication)   \n",
       "50    Normal Value        F  Free (free for publication)   \n",
       "51    Normal Value        F  Free (free for publication)   \n",
       "52    Normal Value        F  Free (free for publication)   \n",
       "53    Normal Value        F  Free (free for publication)   \n",
       "54    Normal Value        F  Free (free for publication)   \n",
       "55    Normal Value        F  Free (free for publication)   \n",
       "56    Normal Value        F  Free (free for publication)   \n",
       "57    Normal Value        F  Free (free for publication)   \n",
       "58    Normal Value        F  Free (free for publication)   \n",
       "59    Normal Value        F  Free (free for publication)   \n",
       "60    Normal Value        F  Free (free for publication)   \n",
       "61    Normal Value        F  Free (free for publication)   \n",
       "62    Normal Value        F  Free (free for publication)   \n",
       "63    Normal Value        F  Free (free for publication)   \n",
       "64    Normal Value        F  Free (free for publication)   \n",
       "65    Normal Value        F  Free (free for publication)   \n",
       "66    Normal Value        F  Free (free for publication)   \n",
       "67    Normal Value        F  Free (free for publication)   \n",
       "68    Normal Value        F  Free (free for publication)   \n",
       "69    Normal Value        F  Free (free for publication)   \n",
       "70    Normal Value        F  Free (free for publication)   \n",
       "71    Normal Value        F  Free (free for publication)   \n",
       "72    Normal Value        F  Free (free for publication)   \n",
       "73    Normal Value        F  Free (free for publication)   \n",
       "74    Normal Value        F  Free (free for publication)   \n",
       "75    Normal Value        F  Free (free for publication)   \n",
       "76    Normal Value        F  Free (free for publication)   \n",
       "77    Normal Value        F  Free (free for publication)   \n",
       "78    Normal Value        F  Free (free for publication)   \n",
       "79    Normal Value        F  Free (free for publication)   \n",
       "80    Normal Value        F  Free (free for publication)   \n",
       "81    Normal Value        F  Free (free for publication)   \n",
       "82    Normal Value        F  Free (free for publication)   \n",
       "83    Normal Value        F  Free (free for publication)   \n",
       "84    Normal Value        F  Free (free for publication)   \n",
       "85    Normal Value        F  Free (free for publication)   \n",
       "86    Normal Value        F  Free (free for publication)   \n",
       "87    Normal Value        F  Free (free for publication)   \n",
       "88    Normal Value        F  Free (free for publication)   \n",
       "89    Normal Value        F  Free (free for publication)   \n",
       "90    Normal Value        F  Free (free for publication)   \n",
       "91    Normal Value        F  Free (free for publication)   \n",
       "92    Normal Value        F  Free (free for publication)   \n",
       "93    Normal Value        F  Free (free for publication)   \n",
       "94    Normal Value        F  Free (free for publication)   \n",
       "95    Normal Value        F  Free (free for publication)   \n",
       "96    Normal Value        F  Free (free for publication)   \n",
       "97    Normal Value        F  Free (free for publication)   \n",
       "98    Normal Value        F  Free (free for publication)   \n",
       "99    Normal Value        F  Free (free for publication)   \n",
       "\n",
       "                                    URN  RECORD_OFFSET  RECORD_COUNT  \n",
       "0   Nm-127d1d32300e0d1811939329d1d20100              0          2781  \n",
       "1   Nm-127d1d32300e0d1811939330d1d20100              1          2781  \n",
       "2   Nm-127d1d32300e0d1811939331d1d20100              2          2781  \n",
       "3   Nm-127d1d32300e0d1811939332d1d20100              3          2781  \n",
       "4   Nm-127d1d32300e0d1811939334d1d20100              4          2781  \n",
       "5   Nm-127d1d32300e0d1811939335d1d20100              5          2781  \n",
       "6   Nm-127d1d32300e0d1811939336d1d20100              6          2781  \n",
       "7   Nm-127d1d32300e0d1811939338d1d20100              7          2781  \n",
       "8   Nm-127d1d32300e0d1811939339d1d20100              8          2781  \n",
       "9   Nm-127d1d32300e0d1811939340d1d20100              9          2781  \n",
       "10  Nm-127d1d32300e0d1811939341d1d20100             10          2781  \n",
       "11  Nm-127d1d32300e0d1811939342d1d20100             11          2781  \n",
       "12  Nm-127d1d32300e0d1811939343d1d20100             12          2781  \n",
       "13  Nm-127d1d32300e0d1811939344d1d20100             13          2781  \n",
       "14  Nm-127d1d32300e0d1811939345d1d20100             14          2781  \n",
       "15  Nm-127d1d32300e0d1811939346d1d20100             15          2781  \n",
       "16  Nm-127d1d32300e0d1811939347d1d20100             16          2781  \n",
       "17  Nm-127d1d32300e0d1811939348d1d20100             17          2781  \n",
       "18  Nm-127d1d32300e0d1811939349d1d20100             18          2781  \n",
       "19  Nm-127d1d32300e0d1811939350d1d20100             19          2781  \n",
       "20  Nm-127d1d32300e0d1811939351d1d20100             20          2781  \n",
       "21  Nm-127d1d32300e0d1811939352d1d20100             21          2781  \n",
       "22  Nm-127d1d32300e0d1811939353d1d20100             22          2781  \n",
       "23  Nm-127d1d32300e0d1811939354d1d20100             23          2781  \n",
       "24  Nm-127d1d32300e0d1811939355d1d20100             24          2781  \n",
       "25  Nm-127d1d32300e0d1811939356d1d20100             25          2781  \n",
       "26  Nm-127d1d32300e0d1811939357d1d20100             26          2781  \n",
       "27  Nm-127d1d32300e0d1811939358d1d20100             27          2781  \n",
       "28  Nm-127d1d32300e0d1811939359d1d20100             28          2781  \n",
       "29  Nm-127d1d32300e0d1811939360d1d20100             29          2781  \n",
       "30  Nm-127d1d32300e0d1811939361d1d20100             30          2781  \n",
       "31  Nm-127d1d32300e0d1811939362d1d20100             31          2781  \n",
       "32  Nm-127d1d32300e0d1811939363d1d20100             32          2781  \n",
       "33  Nm-127d1d32300e0d1811939364d1d20100             33          2781  \n",
       "34  Nm-127d1d32300e0d1811939365d1d20100             34          2781  \n",
       "35  Nm-127d1d32300e0d1811939366d1d20100             35          2781  \n",
       "36  Nm-127d1d32300e0d1811939367d1d20100             36          2781  \n",
       "37  Nm-127d1d32300e0d1811939368d1d20100             37          2781  \n",
       "38  Nm-127d1d32300e0d1811939369d1d20100             38          2781  \n",
       "39  Nm-127d1d32300e0d1811939370d1d20100             39          2781  \n",
       "40  Nm-127d1d32300e0d1811939371d1d20100             40          2781  \n",
       "41  Nm-127d1d32300e0d1811939372d1d20100             41          2781  \n",
       "42  Nm-127d1d32300e0d1811939373d1d20100             42          2781  \n",
       "43  Nm-127d1d32300e0d1811939374d1d20100             43          2781  \n",
       "44  Nm-127d1d32300e0d1811939375d1d20100             44          2781  \n",
       "45  Nm-127d1d32300e0d1811939376d1d20100             45          2781  \n",
       "46  Nm-127d1d32300e0d1811939377d1d20100             46          2781  \n",
       "47  Nm-127d1d32300e0d1811939378d1d20100             47          2781  \n",
       "48  Nm-127d1d32300e0d1811939379d1d20100             48          2781  \n",
       "49  Nm-127d1d32300e0d1811939380d1d20100             49          2781  \n",
       "50  Nm-127d1d32300e0d1811939381d1d20100             50          2781  \n",
       "51  Nm-127d1d32300e0d1811939382d1d20100             51          2781  \n",
       "52  Nm-127d1d32300e0d1811939383d1d20100             52          2781  \n",
       "53  Nm-127d1d32300e0d1811939384d1d20100             53          2781  \n",
       "54  Nm-127d1d32300e0d1811939385d1d20100             54          2781  \n",
       "55  Nm-127d1d32300e0d1811939386d1d20100             55          2781  \n",
       "56  Nm-127d1d32300e0d1811939387d1d20100             56          2781  \n",
       "57  Nm-127d1d32300e0d1811939388d1d20100             57          2781  \n",
       "58  Nm-127d1d32300e0d1811939389d1d20100             58          2781  \n",
       "59  Nm-127d1d32300e0d1811939390d1d20100             59          2781  \n",
       "60  Nm-127d1d32300e0d1811939391d1d20100             60          2781  \n",
       "61  Nm-127d1d32300e0d1811939392d1d20100             61          2781  \n",
       "62  Nm-127d1d32300e0d1811939393d1d20100             62          2781  \n",
       "63  Nm-127d1d32300e0d1811939394d1d20100             63          2781  \n",
       "64  Nm-127d1d32300e0d1811939395d1d20100             64          2781  \n",
       "65  Nm-127d1d32300e0d1811939396d1d20100             65          2781  \n",
       "66  Nm-127d1d32300e0d1811939397d1d20100             66          2781  \n",
       "67  Nm-127d1d32300e0d1811939398d1d20100             67          2781  \n",
       "68  Nm-127d1d32300e0d1811939399d1d20100             68          2781  \n",
       "69  Nm-127d1d32300e0d1811939400d1d20100             69          2781  \n",
       "70  Nm-127d1d32300e0d1811939401d1d20100             70          2781  \n",
       "71  Nm-127d1d32300e0d1811939402d1d20100             71          2781  \n",
       "72  Nm-127d1d32300e0d1811939403d1d20100             72          2781  \n",
       "73  Nm-127d1d32300e0d1811939404d1d20100             73          2781  \n",
       "74  Nm-127d1d32300e0d1811939405d1d20100             74          2781  \n",
       "75  Nm-127d1d32300e0d1811939406d1d20100             75          2781  \n",
       "76  Nm-127d1d32300e0d1811939407d1d20100             76          2781  \n",
       "77  Nm-127d1d32300e0d1811939408d1d20100             77          2781  \n",
       "78  Nm-127d1d32300e0d1811939409d1d20100             78          2781  \n",
       "79  Nm-127d1d32300e0d1811939410d1d20100             79          2781  \n",
       "80  Nm-127d1d32300e0d1811939411d1d20100             80          2781  \n",
       "81  Nm-127d1d32300e0d1811939412d1d20100             81          2781  \n",
       "82  Nm-127d1d32300e0d1811939413d1d20100             82          2781  \n",
       "83  Nm-127d1d32300e0d1811939414d1d20100             83          2781  \n",
       "84  Nm-127d1d32300e0d1811939415d1d20100             84          2781  \n",
       "85  Nm-127d1d32300e0d1811939416d1d20100             85          2781  \n",
       "86  Nm-127d1d32300e0d1811939417d1d20100             86          2781  \n",
       "87  Nm-127d1d32300e0d1811939418d1d20100             87          2781  \n",
       "88  Nm-127d1d32300e0d1811939419d1d20100             88          2781  \n",
       "89  Nm-127d1d32300e0d1811939420d1d20100             89          2781  \n",
       "90  Nm-127d1d32300e0d1811939421d1d20100             90          2781  \n",
       "91  Nm-127d1d32300e0d1811939422d1d20100             91          2781  \n",
       "92  Nm-127d1d32300e0d1811939423d1d20100             92          2781  \n",
       "93  Nm-127d1d32300e0d1811939424d1d20100             93          2781  \n",
       "94  Nm-127d1d32300e0d1811939425d1d20100             94          2781  \n",
       "95  Nm-127d1d32300e0d1811939426d1d20100             95          2781  \n",
       "96  Nm-127d1d32300e0d1811939427d1d20100             96          2781  \n",
       "97  Nm-127d1d32300e0d1811939428d1d20100             97          2781  \n",
       "98  Nm-127d1d32300e0d1811939436d1d20100             98          2781  \n",
       "99  Nm-127d1d32300e0d1811939437d1d20100             99          2781  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "309"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(set(df.GEOGRAPHY))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(set(df.MEASURES_NAME))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['DATE', 'DATE_NAME', 'DATE_CODE', 'DATE_TYPE', 'DATE_TYPECODE',\n",
       "       'DATE_SORTORDER', 'GEOGRAPHY', 'GEOGRAPHY_NAME', 'GEOGRAPHY_CODE',\n",
       "       'GEOGRAPHY_TYPE', 'GEOGRAPHY_TYPECODE', 'GEOGRAPHY_SORTORDER', 'ITEM',\n",
       "       'ITEM_NAME', 'ITEM_CODE', 'ITEM_TYPE', 'ITEM_TYPECODE',\n",
       "       'ITEM_SORTORDER', 'MEASURES', 'MEASURES_NAME', 'OBS_VALUE',\n",
       "       'OBS_STATUS', 'OBS_STATUS_NAME', 'OBS_CONF', 'OBS_CONF_NAME', 'URN',\n",
       "       'RECORD_OFFSET', 'RECORD_COUNT'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}