Newer
Older
DataReport / dataset-stats / size.ipynb
{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Gather some statistics about the datasets, vocabularies and codelists loaded into PMD."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from IPython.display import HTML"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Find the distinct datasets"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "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>Dataset</th>\n",
       "      <th>Label</th>\n",
       "      <th>Theme</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Graph</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>http://gss-data.org.uk/graph/gss_data/covid-19/ho-statistics-relating-to-covid-19-and-the-immigration-system-may-2020</th>\n",
       "      <td>http://gss-data.org.uk/data/gss_data/covid-19/ho-statistics-relating-to-covid-19-and-the-immigration-system-may-2020-catalog-entry</td>\n",
       "      <td>Statistics relating to Covid-19 and the immigration system</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://gss-data.org.uk/graph/gss_data/covid-19/nrs-deaths-involving-coronavirus-covid-19-in-scotland</th>\n",
       "      <td>http://gss-data.org.uk/data/gss_data/covid-19/nrs-deaths-involving-coronavirus-covid-19-in-scotland-catalog-entry</td>\n",
       "      <td>Deaths involving COVID-19 in Scotland</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://gss-data.org.uk/graph/gss_data/covid-19/wg-notifications-of-deaths-of-residents-related-to-covid-19-in-adult-care-homes</th>\n",
       "      <td>http://gss-data.org.uk/data/gss_data/covid-19/wg-notifications-of-deaths-of-residents-related-to-covid-19-in-adult-care-homes-catalog-entry</td>\n",
       "      <td>Notifications of deaths of residents related to COVID-19 in adult care homes</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://gss-data.org.uk/graph/gss_data/covid-19/ons-number-of-deaths-in-care-homes-notified-to-the-care-quality-commission-england</th>\n",
       "      <td>http://gss-data.org.uk/data/gss_data/covid-19/ons-number-of-deaths-in-care-homes-notified-to-the-care-quality-commission-england-catalog-entry</td>\n",
       "      <td>Number of deaths in care homes notified to the Care Quality Commission, England</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://gss-data.org.uk/graph/gss_data/covid-19/ons-deaths-involving-covid-19-in-the-care-sector-england-and-wales-deaths-occurring-up-to-1-may-2020-and-registered-up-to-9-may-2020-provisional</th>\n",
       "      <td>http://gss-data.org.uk/data/gss_data/covid-19/ons-deaths-involving-covid-19-in-the-care-sector-england-and-wales-deaths-occurring-up-to-1-may-2020-and-registered-up-to-9-may-2020-provisional-catalog-entry</td>\n",
       "      <td>Deaths involving COVID-19 in the care sector for England and Wales</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://gss-data.org.uk/graph/gss_data/homelessness/mhclg-families-in-bed-and-breakfast-accommodation-for-more-than-6-weeks</th>\n",
       "      <td>http://gss-data.org.uk/data/gss_data/homelessness/mhclg-families-in-bed-and-breakfast-accommodation-for-more-than-6-weeks-catalog-entry</td>\n",
       "      <td>Families in bed and breakfast accommodation for more than 6 weeks</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-cn8</th>\n",
       "      <td>http://gss-data.org.uk/data/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-cn8-catalog-entry</td>\n",
       "      <td>HMRC Overseas Trade Statistics - Combined Nomenclature 8</td>\n",
       "      <td>Trade</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics-cn8/200001</th>\n",
       "      <td>http://gss-data.org.uk/data/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-cn8-catalog-entry</td>\n",
       "      <td>HMRC Overseas Trade Statistics - Combined Nomenclature 8</td>\n",
       "      <td>Trade</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-sitc</th>\n",
       "      <td>http://gss-data.org.uk/data/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-sitc-catalog-entry</td>\n",
       "      <td>HMRC Overseas Trade Statistics - SITCv4</td>\n",
       "      <td>Trade</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics-sitc/200001</th>\n",
       "      <td>http://gss-data.org.uk/data/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-sitc-catalog-entry</td>\n",
       "      <td>HMRC Overseas Trade Statistics - SITCv4</td>\n",
       "      <td>Trade</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>155 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                                                                                                                                                                                                                                                                                                                                                      Dataset  \\\n",
       "Graph                                                                                                                                                                                                                                                                                                                                                                                                           \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/ho-statistics-relating-to-covid-19-and-the-immigration-system-may-2020                                                                            http://gss-data.org.uk/data/gss_data/covid-19/ho-statistics-relating-to-covid-19-and-the-immigration-system-may-2020-catalog-entry                                                                             \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/nrs-deaths-involving-coronavirus-covid-19-in-scotland                                                                                             http://gss-data.org.uk/data/gss_data/covid-19/nrs-deaths-involving-coronavirus-covid-19-in-scotland-catalog-entry                                                                                              \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/wg-notifications-of-deaths-of-residents-related-to-covid-19-in-adult-care-homes                                                                   http://gss-data.org.uk/data/gss_data/covid-19/wg-notifications-of-deaths-of-residents-related-to-covid-19-in-adult-care-homes-catalog-entry                                                                    \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/ons-number-of-deaths-in-care-homes-notified-to-the-care-quality-commission-england                                                                http://gss-data.org.uk/data/gss_data/covid-19/ons-number-of-deaths-in-care-homes-notified-to-the-care-quality-commission-england-catalog-entry                                                                 \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/ons-deaths-involving-covid-19-in-the-care-sector-england-and-wales-deaths-occurring-up-to-1-may-2020-and-registered-up-to-9-may-2020-provisional  http://gss-data.org.uk/data/gss_data/covid-19/ons-deaths-involving-covid-19-in-the-care-sector-england-and-wales-deaths-occurring-up-to-1-may-2020-and-registered-up-to-9-may-2020-provisional-catalog-entry   \n",
       "...                                                                                                                                                                                                                                                                                                                                         ...                                                                 \n",
       "http://gss-data.org.uk/graph/gss_data/homelessness/mhclg-families-in-bed-and-breakfast-accommodation-for-more-than-6-weeks                                                                       http://gss-data.org.uk/data/gss_data/homelessness/mhclg-families-in-bed-and-breakfast-accommodation-for-more-than-6-weeks-catalog-entry                                                                        \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-cn8                                                                                    http://gss-data.org.uk/data/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-cn8-catalog-entry                                                                                     \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics-cn8/200001                                                                                                            http://gss-data.org.uk/data/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-cn8-catalog-entry                                                                                     \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-sitc                                                                                   http://gss-data.org.uk/data/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-sitc-catalog-entry                                                                                    \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics-sitc/200001                                                                                                           http://gss-data.org.uk/data/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-sitc-catalog-entry                                                                                    \n",
       "\n",
       "                                                                                                                                                                                                                                                                           Label  \\\n",
       "Graph                                                                                                                                                                                                                                                                              \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/ho-statistics-relating-to-covid-19-and-the-immigration-system-may-2020                                                                            Statistics relating to Covid-19 and the immigration system                        \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/nrs-deaths-involving-coronavirus-covid-19-in-scotland                                                                                             Deaths involving COVID-19 in Scotland                                             \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/wg-notifications-of-deaths-of-residents-related-to-covid-19-in-adult-care-homes                                                                   Notifications of deaths of residents related to COVID-19 in adult care homes      \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/ons-number-of-deaths-in-care-homes-notified-to-the-care-quality-commission-england                                                                Number of deaths in care homes notified to the Care Quality Commission, England   \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/ons-deaths-involving-covid-19-in-the-care-sector-england-and-wales-deaths-occurring-up-to-1-may-2020-and-registered-up-to-9-may-2020-provisional  Deaths involving COVID-19 in the care sector for England and Wales                \n",
       "...                                                                                                                                                                                                                                                                          ...   \n",
       "http://gss-data.org.uk/graph/gss_data/homelessness/mhclg-families-in-bed-and-breakfast-accommodation-for-more-than-6-weeks                                                                       Families in bed and breakfast accommodation for more than 6 weeks                 \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-cn8                                                                                    HMRC Overseas Trade Statistics - Combined Nomenclature 8                          \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics-cn8/200001                                                                                                            HMRC Overseas Trade Statistics - Combined Nomenclature 8                          \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-sitc                                                                                   HMRC Overseas Trade Statistics - SITCv4                                           \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics-sitc/200001                                                                                                           HMRC Overseas Trade Statistics - SITCv4                                           \n",
       "\n",
       "                                                                                                                                                                                                 Theme  \n",
       "Graph                                                                                                                                                                                                   \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/ho-statistics-relating-to-covid-19-and-the-immigration-system-may-2020                                                                                   \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/nrs-deaths-involving-coronavirus-covid-19-in-scotland                                                                                                    \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/wg-notifications-of-deaths-of-residents-related-to-covid-19-in-adult-care-homes                                                                          \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/ons-number-of-deaths-in-care-homes-notified-to-the-care-quality-commission-england                                                                       \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/ons-deaths-involving-covid-19-in-the-care-sector-england-and-wales-deaths-occurring-up-to-1-may-2020-and-registered-up-to-9-may-2020-provisional         \n",
       "...                                                                                                                                                                                             ..      \n",
       "http://gss-data.org.uk/graph/gss_data/homelessness/mhclg-families-in-bed-and-breakfast-accommodation-for-more-than-6-weeks                                                                              \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-cn8                                                                                    Trade  \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics-cn8/200001                                                                                                            Trade  \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-sitc                                                                                   Trade  \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics-sitc/200001                                                                                                           Trade  \n",
       "\n",
       "[155 rows x 3 columns]"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from io import StringIO\n",
    "import requests\n",
    "\n",
    "session = requests.Session()\n",
    "result = session.post(\n",
    "    'https://staging.gss-data.org.uk/sparql',\n",
    "    headers={'Accept': 'text/csv; charset=utf-8'},\n",
    "    stream=True,\n",
    "    data={'query': '''\n",
    "PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\n",
    "PREFIX qb:   <http://purl.org/linked-data/cube#>\n",
    "PREFIX pmdcat:  <http://publishmydata.com/pmdcat#>\n",
    "PREFIX gdp:  <http://gss-data.org.uk/def/gdp#>\n",
    "PREFIX dcat: <http://www.w3.org/ns/dcat#>\n",
    "\n",
    "SELECT DISTINCT ?Dataset ?Label ?Graph ?Theme\n",
    "WHERE {\n",
    "  { ?Dataset a dcat:Dataset } UNION { ?Dataset a pmdcat:Dataset } .\n",
    "  ?Dataset\n",
    "         rdfs:label ?Label ;\n",
    "         pmdcat:graph ?Graph ;\n",
    "         pmdcat:datasetContents [ a qb:DataSet ] .\n",
    "  \n",
    "  OPTIONAL {\n",
    "    ?Dataset dcat:theme [rdfs:label ?Theme]\n",
    "  }\n",
    "}'''})\n",
    "\n",
    "datasets = pd.read_csv(StringIO(result.content.decode('utf-8')), index_col='Graph', keep_default_na=False, dtype='str', na_values=[])\n",
    "datasets"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Find the sizes of the cubes."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "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>Size</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Graph</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>http://purl.org/dc/terms/</th>\n",
       "      <td>627</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://xmlns.com/foaf/0.1/</th>\n",
       "      <td>639</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://gss-data.org.uk/graph/vocab/pmdcat-metadata</th>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://gss-data.org.uk/graph/pmdcat</th>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://gss-data.org.uk/graph/skos</th>\n",
       "      <td>252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-cn8</th>\n",
       "      <td>5267346</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-sitc-metadata</th>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-sitc</th>\n",
       "      <td>3536988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics-cn8/200001</th>\n",
       "      <td>5267286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics-sitc/200001</th>\n",
       "      <td>3536928</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>703 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                                                                            Size\n",
       "Graph                                                                                                                           \n",
       "http://purl.org/dc/terms/                                                                                                627    \n",
       "http://xmlns.com/foaf/0.1/                                                                                               639    \n",
       "http://gss-data.org.uk/graph/vocab/pmdcat-metadata                                                                       29     \n",
       "http://gss-data.org.uk/graph/pmdcat                                                                                      41     \n",
       "http://gss-data.org.uk/graph/skos                                                                                        252    \n",
       "...                                                                                                                      ..     \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-cn8            5267346\n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-sitc-metadata  32     \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-sitc           3536988\n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics-cn8/200001                                    5267286\n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics-sitc/200001                                   3536928\n",
       "\n",
       "[703 rows x 1 columns]"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result = session.post(\n",
    "    'https://staging.gss-data.org.uk/sparql',\n",
    "    headers={'Accept': 'text/csv; charset=utf-8'},\n",
    "    stream=True,\n",
    "    data={'query': '''\n",
    "SELECT (COUNT(*) as ?Size) ?Graph\n",
    "WHERE {\n",
    "  GRAPH ?Graph {\n",
    "    ?s ?p ?o\n",
    "  }\n",
    "} GROUP BY ?Graph\n",
    "'''})\n",
    "\n",
    "sizes = pd.read_csv(StringIO(result.content.decode('utf-8')), index_col='Graph')\n",
    "sizes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "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>Dataset</th>\n",
       "      <th>Label</th>\n",
       "      <th>Theme</th>\n",
       "      <th>Size</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Graph</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>http://gss-data.org.uk/graph/gss_data/covid-19/ho-statistics-relating-to-covid-19-and-the-immigration-system-may-2020</th>\n",
       "      <td>http://gss-data.org.uk/data/gss_data/covid-19/ho-statistics-relating-to-covid-19-and-the-immigration-system-may-2020-catalog-entry</td>\n",
       "      <td>Statistics relating to Covid-19 and the immigration system</td>\n",
       "      <td></td>\n",
       "      <td>3417</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://gss-data.org.uk/graph/gss_data/covid-19/nrs-deaths-involving-coronavirus-covid-19-in-scotland</th>\n",
       "      <td>http://gss-data.org.uk/data/gss_data/covid-19/nrs-deaths-involving-coronavirus-covid-19-in-scotland-catalog-entry</td>\n",
       "      <td>Deaths involving COVID-19 in Scotland</td>\n",
       "      <td></td>\n",
       "      <td>53605</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://gss-data.org.uk/graph/gss_data/covid-19/wg-notifications-of-deaths-of-residents-related-to-covid-19-in-adult-care-homes</th>\n",
       "      <td>http://gss-data.org.uk/data/gss_data/covid-19/wg-notifications-of-deaths-of-residents-related-to-covid-19-in-adult-care-homes-catalog-entry</td>\n",
       "      <td>Notifications of deaths of residents related to COVID-19 in adult care homes</td>\n",
       "      <td></td>\n",
       "      <td>249156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://gss-data.org.uk/graph/gss_data/covid-19/ons-number-of-deaths-in-care-homes-notified-to-the-care-quality-commission-england</th>\n",
       "      <td>http://gss-data.org.uk/data/gss_data/covid-19/ons-number-of-deaths-in-care-homes-notified-to-the-care-quality-commission-england-catalog-entry</td>\n",
       "      <td>Number of deaths in care homes notified to the Care Quality Commission, England</td>\n",
       "      <td></td>\n",
       "      <td>515016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://gss-data.org.uk/graph/gss_data/covid-19/ons-deaths-involving-covid-19-in-the-care-sector-england-and-wales-deaths-occurring-up-to-1-may-2020-and-registered-up-to-9-may-2020-provisional</th>\n",
       "      <td>http://gss-data.org.uk/data/gss_data/covid-19/ons-deaths-involving-covid-19-in-the-care-sector-england-and-wales-deaths-occurring-up-to-1-may-2020-and-registered-up-to-9-may-2020-provisional-catalog-entry</td>\n",
       "      <td>Deaths involving COVID-19 in the care sector for England and Wales</td>\n",
       "      <td></td>\n",
       "      <td>317055</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://gss-data.org.uk/graph/gss_data/homelessness/mhclg-families-in-bed-and-breakfast-accommodation-for-more-than-6-weeks</th>\n",
       "      <td>http://gss-data.org.uk/data/gss_data/homelessness/mhclg-families-in-bed-and-breakfast-accommodation-for-more-than-6-weeks-catalog-entry</td>\n",
       "      <td>Families in bed and breakfast accommodation for more than 6 weeks</td>\n",
       "      <td></td>\n",
       "      <td>22724</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-cn8</th>\n",
       "      <td>http://gss-data.org.uk/data/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-cn8-catalog-entry</td>\n",
       "      <td>HMRC Overseas Trade Statistics - Combined Nomenclature 8</td>\n",
       "      <td>Trade</td>\n",
       "      <td>5267346</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics-cn8/200001</th>\n",
       "      <td>http://gss-data.org.uk/data/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-cn8-catalog-entry</td>\n",
       "      <td>HMRC Overseas Trade Statistics - Combined Nomenclature 8</td>\n",
       "      <td>Trade</td>\n",
       "      <td>5267286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-sitc</th>\n",
       "      <td>http://gss-data.org.uk/data/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-sitc-catalog-entry</td>\n",
       "      <td>HMRC Overseas Trade Statistics - SITCv4</td>\n",
       "      <td>Trade</td>\n",
       "      <td>3536988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics-sitc/200001</th>\n",
       "      <td>http://gss-data.org.uk/data/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-sitc-catalog-entry</td>\n",
       "      <td>HMRC Overseas Trade Statistics - SITCv4</td>\n",
       "      <td>Trade</td>\n",
       "      <td>3536928</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>155 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                                                                                                                                                                                                                                                                                                                                                      Dataset  \\\n",
       "Graph                                                                                                                                                                                                                                                                                                                                                                                                           \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/ho-statistics-relating-to-covid-19-and-the-immigration-system-may-2020                                                                            http://gss-data.org.uk/data/gss_data/covid-19/ho-statistics-relating-to-covid-19-and-the-immigration-system-may-2020-catalog-entry                                                                             \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/nrs-deaths-involving-coronavirus-covid-19-in-scotland                                                                                             http://gss-data.org.uk/data/gss_data/covid-19/nrs-deaths-involving-coronavirus-covid-19-in-scotland-catalog-entry                                                                                              \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/wg-notifications-of-deaths-of-residents-related-to-covid-19-in-adult-care-homes                                                                   http://gss-data.org.uk/data/gss_data/covid-19/wg-notifications-of-deaths-of-residents-related-to-covid-19-in-adult-care-homes-catalog-entry                                                                    \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/ons-number-of-deaths-in-care-homes-notified-to-the-care-quality-commission-england                                                                http://gss-data.org.uk/data/gss_data/covid-19/ons-number-of-deaths-in-care-homes-notified-to-the-care-quality-commission-england-catalog-entry                                                                 \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/ons-deaths-involving-covid-19-in-the-care-sector-england-and-wales-deaths-occurring-up-to-1-may-2020-and-registered-up-to-9-may-2020-provisional  http://gss-data.org.uk/data/gss_data/covid-19/ons-deaths-involving-covid-19-in-the-care-sector-england-and-wales-deaths-occurring-up-to-1-may-2020-and-registered-up-to-9-may-2020-provisional-catalog-entry   \n",
       "...                                                                                                                                                                                                                                                                                                                                         ...                                                                 \n",
       "http://gss-data.org.uk/graph/gss_data/homelessness/mhclg-families-in-bed-and-breakfast-accommodation-for-more-than-6-weeks                                                                       http://gss-data.org.uk/data/gss_data/homelessness/mhclg-families-in-bed-and-breakfast-accommodation-for-more-than-6-weeks-catalog-entry                                                                        \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-cn8                                                                                    http://gss-data.org.uk/data/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-cn8-catalog-entry                                                                                     \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics-cn8/200001                                                                                                            http://gss-data.org.uk/data/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-cn8-catalog-entry                                                                                     \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-sitc                                                                                   http://gss-data.org.uk/data/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-sitc-catalog-entry                                                                                    \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics-sitc/200001                                                                                                           http://gss-data.org.uk/data/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-sitc-catalog-entry                                                                                    \n",
       "\n",
       "                                                                                                                                                                                                                                                                           Label  \\\n",
       "Graph                                                                                                                                                                                                                                                                              \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/ho-statistics-relating-to-covid-19-and-the-immigration-system-may-2020                                                                            Statistics relating to Covid-19 and the immigration system                        \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/nrs-deaths-involving-coronavirus-covid-19-in-scotland                                                                                             Deaths involving COVID-19 in Scotland                                             \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/wg-notifications-of-deaths-of-residents-related-to-covid-19-in-adult-care-homes                                                                   Notifications of deaths of residents related to COVID-19 in adult care homes      \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/ons-number-of-deaths-in-care-homes-notified-to-the-care-quality-commission-england                                                                Number of deaths in care homes notified to the Care Quality Commission, England   \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/ons-deaths-involving-covid-19-in-the-care-sector-england-and-wales-deaths-occurring-up-to-1-may-2020-and-registered-up-to-9-may-2020-provisional  Deaths involving COVID-19 in the care sector for England and Wales                \n",
       "...                                                                                                                                                                                                                                                                          ...   \n",
       "http://gss-data.org.uk/graph/gss_data/homelessness/mhclg-families-in-bed-and-breakfast-accommodation-for-more-than-6-weeks                                                                       Families in bed and breakfast accommodation for more than 6 weeks                 \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-cn8                                                                                    HMRC Overseas Trade Statistics - Combined Nomenclature 8                          \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics-cn8/200001                                                                                                            HMRC Overseas Trade Statistics - Combined Nomenclature 8                          \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-sitc                                                                                   HMRC Overseas Trade Statistics - SITCv4                                           \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics-sitc/200001                                                                                                           HMRC Overseas Trade Statistics - SITCv4                                           \n",
       "\n",
       "                                                                                                                                                                                                 Theme  \\\n",
       "Graph                                                                                                                                                                                                    \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/ho-statistics-relating-to-covid-19-and-the-immigration-system-may-2020                                                                                    \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/nrs-deaths-involving-coronavirus-covid-19-in-scotland                                                                                                     \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/wg-notifications-of-deaths-of-residents-related-to-covid-19-in-adult-care-homes                                                                           \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/ons-number-of-deaths-in-care-homes-notified-to-the-care-quality-commission-england                                                                        \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/ons-deaths-involving-covid-19-in-the-care-sector-england-and-wales-deaths-occurring-up-to-1-may-2020-and-registered-up-to-9-may-2020-provisional          \n",
       "...                                                                                                                                                                                             ..       \n",
       "http://gss-data.org.uk/graph/gss_data/homelessness/mhclg-families-in-bed-and-breakfast-accommodation-for-more-than-6-weeks                                                                               \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-cn8                                                                                    Trade   \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics-cn8/200001                                                                                                            Trade   \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-sitc                                                                                   Trade   \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics-sitc/200001                                                                                                           Trade   \n",
       "\n",
       "                                                                                                                                                                                                    Size  \n",
       "Graph                                                                                                                                                                                                     \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/ho-statistics-relating-to-covid-19-and-the-immigration-system-may-2020                                                                            3417     \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/nrs-deaths-involving-coronavirus-covid-19-in-scotland                                                                                             53605    \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/wg-notifications-of-deaths-of-residents-related-to-covid-19-in-adult-care-homes                                                                   249156   \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/ons-number-of-deaths-in-care-homes-notified-to-the-care-quality-commission-england                                                                515016   \n",
       "http://gss-data.org.uk/graph/gss_data/covid-19/ons-deaths-involving-covid-19-in-the-care-sector-england-and-wales-deaths-occurring-up-to-1-may-2020-and-registered-up-to-9-may-2020-provisional  317055   \n",
       "...                                                                                                                                                                                                 ...   \n",
       "http://gss-data.org.uk/graph/gss_data/homelessness/mhclg-families-in-bed-and-breakfast-accommodation-for-more-than-6-weeks                                                                       22724    \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-cn8                                                                                    5267346  \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics-cn8/200001                                                                                                            5267286  \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-sitc                                                                                   3536988  \n",
       "http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics-sitc/200001                                                                                                           3536928  \n",
       "\n",
       "[155 rows x 4 columns]"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "table = datasets.join(sizes)\n",
    "table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: left;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>Size</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Theme</th>\n",
       "      <th>Dataset</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"96\" valign=\"top\"></th>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fcensus-2011-catalog-entry\">CENSUS 2011 - LC3409EW Output Area (General health by tenure by age) - Nomis - Official Labour Market Statistics</a></th>\n",
       "      <td>78368322</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fcovid-19%2Fho-statistics-relating-to-covid-19-and-the-immigration-system-may-2020-catalog-entry\">Statistics relating to Covid-19 and the immigration system</a></th>\n",
       "      <td>3417</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fcovid-19%2Fmmo-ad-hoc-statistical-release-uk-sea-fisheries-statistics-catalog-entry\">Ad hoc statistical release UK Sea Fisheries Statistics - Quantity (t)</a></th>\n",
       "      <td>2611</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fcovid-19%2Fnhs-d-coronavirus-shielded-patient-list-summary-totals-england-catalog-entry\">Coronavirus Shielded Patient List Summary Totals, England by Clinical Commissioning Group and Local Authority</a></th>\n",
       "      <td>37489</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fcovid-19%2Fnisra-weekly-deaths-year-ni%2Foccurrences-catalog-entry\">Weekly deaths - Occurrences</a></th>\n",
       "      <td>20330</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fcovid-19%2Fnisra-weekly-deaths-year-ni%2Fregistrations-catalog-entry\">Weekly Deaths - Registrations</a></th>\n",
       "      <td>74653</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fcovid-19%2Fnrs-deaths-involving-coronavirus-covid-19-in-scotland-catalog-entry\">Deaths involving COVID-19 in Scotland</a></th>\n",
       "      <td>53605</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fcovid-19%2Fons-death-registrations-and-occurrences-by-local-authority-and-health-board%2Foccurrences-catalog-entry\">Death Occurrences by Local Authority and Health Board</a></th>\n",
       "      <td>1444777</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fcovid-19%2Fons-death-registrations-and-occurrences-by-local-authority-and-health-board%2Fregistrations-catalog-entry\">Death Registrations by Local Authority and Health Board</a></th>\n",
       "      <td>1444777</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fcovid-19%2Fons-deaths-involving-covid-19-in-the-care-sector-england-and-wales-deaths-occurring-up-to-1-may-2020-and-registered-up-to-9-may-2020-provisional-catalog-entry\">Deaths involving COVID-19 in the care sector for England and Wales</a></th>\n",
       "      <td>317055</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fcovid-19%2Fons-number-of-deaths-in-care-homes-notified-to-the-care-quality-commission-england-catalog-entry\">Number of deaths in care homes notified to the Care Quality Commission, England</a></th>\n",
       "      <td>515016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fcovid-19%2Fons-online-job-advert-estimates-catalog-entry\">Online job advert estimates</a></th>\n",
       "      <td>52876</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fcovid-19%2Fons-online-price-changes-for-high-demand-products-catalog-entry\">Online price changes for high-demand products</a></th>\n",
       "      <td>4621</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fcovid-19%2Fons-which-occupations-have-the-highest-potential-exposure-to-the-coronavirus-covid-19-catalog-entry\">Which occupations have the highest potential exposure to the coronavirus (COVID-19)?</a></th>\n",
       "      <td>5071</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fcovid-19%2Fphe-coronavirus-covid-19-in-the-uk-cases-catalog-entry\">Coronavirus COVID-19 in the UK - Cases by specimen date, by Nation, England: LTLA, UTLA, Region</a></th>\n",
       "      <td>756311</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fcovid-19%2Fphe-covid-19-number-of-outbreaks-in-care-homes-management-information-catalog-entry\">COVID-19: number of outbreaks in care homes - management information</a></th>\n",
       "      <td>87529</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fcovid-19%2Fphs-weekly-covid-19-statistical-data-in-scotland-catalog-entry\">Weekly COVID-19 Statistical Data in Scotland</a></th>\n",
       "      <td>3122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fcovid-19%2Fsg-coronavirus-covid-19-additional-data-about-adult-care-homes-in-scotland-catalog-entry\">Testing for COVID-19 in adult care homes in Scotland</a></th>\n",
       "      <td>7887</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fcovid-19%2Fwg-notifications-of-deaths-of-residents-related-to-covid-19-in-adult-care-homes-catalog-entry\">Notifications of deaths of residents related to COVID-19 in adult care homes</a></th>\n",
       "      <td>249156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fcovid-19%2Fwg-summary-data-about-coronavirus-covid-19-and-the-response-to-it-catalog-entry\">Summary data about Coronavirus COVID-19 and the response to it - Food Parcels</a></th>\n",
       "      <td>1982</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fcovid-19%2Fwg-survey-of-public-views-on-the-coronavirus-covid-19-catalog-entry\">Survey of public views on the coronavirus (COVID-19)</a></th>\n",
       "      <td>3164</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fbeis-fuel-poverty-detailed-tables-2020%2Fedc-fuelcosts-characteristicsagg-catalog-entry\">Fuel poverty detailed tables - Household Characteristics - Aggregate Gap</a></th>\n",
       "      <td>1633</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fbeis-fuel-poverty-detailed-tables-2020%2Fedc-fuelcosts-characteristicsavg-catalog-entry\">Fuel poverty detailed tables - Household Characteristics - Average Gap</a></th>\n",
       "      <td>1378</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fbeis-fuel-poverty-detailed-tables-2020%2Fedc-fuelcosts-eligibilityagg-catalog-entry\">Fuel poverty detailed tables - Eligibility - Aggregate Gap</a></th>\n",
       "      <td>154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fbeis-fuel-poverty-detailed-tables-2020%2Fedc-fuelcosts-eligibilityavg-catalog-entry\">Fuel poverty detailed tables - Eligibility - Average Gap</a></th>\n",
       "      <td>154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fbeis-fuel-poverty-detailed-tables-2020%2Fedc-fuelcosts-energyagg-catalog-entry\">Fuel poverty detailed tables - Energy Efficiency and Dwelling Characteristics - Aggregate Gap</a></th>\n",
       "      <td>2824</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fbeis-fuel-poverty-detailed-tables-2020%2Fedc-fuelcosts-energyavg-catalog-entry\">Fuel poverty detailed tables - Energy Efficiency and Dwelling Characteristics - Average Gap</a></th>\n",
       "      <td>2664</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fbeis-fuel-poverty-detailed-tables-2020%2Fedc-fuelcosts-incomeagg-catalog-entry\">Fuel poverty detailed tables - Household Income - Aggregate Gap</a></th>\n",
       "      <td>284</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fbeis-fuel-poverty-detailed-tables-2020%2Fedc-fuelcosts-incomeavg-catalog-entry\">Fuel poverty detailed tables - Household Income - Average Gap</a></th>\n",
       "      <td>266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fbeis-fuel-poverty-detailed-tables-2020%2Fedc-fuelcosts-paymentagg-catalog-entry\">Fuel poverty detailed tables - Fuel Payment Type - Aggregate Gap</a></th>\n",
       "      <td>130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fbeis-fuel-poverty-detailed-tables-2020%2Fedc-fuelcosts-paymentavg-catalog-entry\">Fuel poverty detailed tables - Fuel Payment Type - Average Gap</a></th>\n",
       "      <td>130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fbeis-fuel-poverty-supplementary-tables-2020%2Feedc-floorarea-catalog-entry\">Fuel poverty supplementary tables - Energy Efficiency and Dwelling Characteristics - Median floor area</a></th>\n",
       "      <td>1253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fbeis-fuel-poverty-supplementary-tables-2020%2Feedc-fpeer-catalog-entry\">Fuel poverty supplementary tables - Energy Efficiency and Dwelling Characteristics - Median Fuel Poverty Energy Efficiency Rating (FPEER)</a></th>\n",
       "      <td>1151</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fbeis-fuel-poverty-supplementary-tables-2020%2Feedc-fuelcosts-catalog-entry\">Fuel poverty supplementary tables - Energy Efficiency and Dwelling Characteristics - Median equivalised fuel costs</a></th>\n",
       "      <td>1253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fbeis-fuel-poverty-supplementary-tables-2020%2Feedc-housingcosts-catalog-entry\">Fuel poverty supplementary tables - Energy Efficiency and Dwelling Characteristics - Median after housing costs (AHC), equivalised income</a></th>\n",
       "      <td>1253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fbeis-fuel-poverty-supplementary-tables-2020%2Ffupt-floorarea-catalog-entry\">Fuel poverty supplementary tables - HFuel Payment Type - Median floor area</a></th>\n",
       "      <td>130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fbeis-fuel-poverty-supplementary-tables-2020%2Ffupt-fpeer-catalog-entry\">Fuel poverty supplementary tables - Fuel Payment Type - Median Fuel Poverty Energy Efficiency Rating (FPEER)</a></th>\n",
       "      <td>130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fbeis-fuel-poverty-supplementary-tables-2020%2Ffupt-fuelcosts-catalog-entry\">Fuel poverty supplementary tables - Fuel Payment Type - Median equivalised fuel costs</a></th>\n",
       "      <td>130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fbeis-fuel-poverty-supplementary-tables-2020%2Ffupt-housingcosts-catalog-entry\">Fuel poverty supplementary tables - Fuel Payment Type - Median after housing costs (AHC), equivalised income</a></th>\n",
       "      <td>130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fbeis-fuel-poverty-supplementary-tables-2020%2Fhoch-floorarea-catalog-entry\">Fuel poverty supplementary tables - Housing Characteristics - Median floor area</a></th>\n",
       "      <td>418</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fbeis-fuel-poverty-supplementary-tables-2020%2Fhoch-fpeer-catalog-entry\">Fuel poverty supplementary tables - Housing Characteristics - Median Fuel Poverty Energy Efficiency Rating (FPEER)</a></th>\n",
       "      <td>330</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fbeis-fuel-poverty-supplementary-tables-2020%2Fhoch-fuelcosts-catalog-entry\">Fuel poverty supplementary tables - Housing Characteristics - Median equivalised fuel costs</a></th>\n",
       "      <td>418</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fbeis-fuel-poverty-supplementary-tables-2020%2Fhoch-housingcosts-catalog-entry\">Fuel poverty supplementary tables - Housing Characteristics - Median after housing costs (AHC), equivalised income</a></th>\n",
       "      <td>418</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fbeis-fuel-poverty-supplementary-tables-2020%2Fhoin-floorarea-catalog-entry\">Fuel poverty supplementary tables - Housing Income - Median floor area</a></th>\n",
       "      <td>154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fbeis-fuel-poverty-supplementary-tables-2020%2Fhoin-fpeer-catalog-entry\">Fuel poverty supplementary tables - Housing Income - Median Fuel Poverty Energy Efficiency Rating (FPEER)</a></th>\n",
       "      <td>154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fbeis-fuel-poverty-supplementary-tables-2020%2Fhoin-fuelcosts-catalog-entry\">Fuel poverty supplementary tables - Housing Income - Median equivalised fuel costs</a></th>\n",
       "      <td>154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fbeis-fuel-poverty-supplementary-tables-2020%2Fhoin-housingcosts-catalog-entry\">Fuel poverty supplementary tables - Housing Income - Median after housing costs (AHC), equivalised income</a></th>\n",
       "      <td>154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fdft-electric-vehicle-charging-device-statistics-month-year-data-tables-catalog-entry\">Electric vehicle charging device statistics: January 2021</a></th>\n",
       "      <td>71791</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fofgem-cheapest-tariffs-by-payment-method-typical-domestic-dual-fuel-customer-gb-catalog-entry\">Cheapest tariffs by payment method: Typical domestic dual fuel customer (GB)</a></th>\n",
       "      <td>4537</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fofgem-retail-price-comparison-by-company-and-tariff-type-domestic-gb-catalog-entry\">Retail price comparison by company and tariff type: Domestic (GB)</a></th>\n",
       "      <td>3954</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fofgem-warm-home-discount-scheme%2Fgbpexpenditure-catalog-entry\">Warm Home Discount Scheme: Total expenditure by obligated suppliers</a></th>\n",
       "      <td>590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fofgem-warm-home-discount-scheme%2Fnationexpenditure-catalog-entry\">Warm Home Discount Scheme: Percentage spend by nation</a></th>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fofgem-warm-home-discount-scheme%2Fpercentageexpenditure-catalog-entry\">Warm Home Discount Scheme: Distribution of expenditure by year</a></th>\n",
       "      <td>343</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fenergy%2Fbeis-fuel-used-in-generation-dukes-5-3-catalog-entry\">Fuel used in generation (DUKES 5.3)</a></th>\n",
       "      <td>7548</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fenergy%2Fbeis-liquid-biofuels-for-transport-consumption-et-6-2-quarterly-catalog-entry\">Liquid biofuels for transport consumption (ET 6.2 - quarterly)</a></th>\n",
       "      <td>4995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fhomelessness%2Fmhclg-families-in-bed-and-breakfast-accommodation-for-more-than-6-weeks-catalog-entry\">Families in bed and breakfast accommodation for more than 6 weeks</a></th>\n",
       "      <td>22724</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fhomelessness%2Fmhclg-rough-sleeping-catalog-entry\">Rough Sleeping Snapshot in England</a></th>\n",
       "      <td>177652</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fsdg%2Findicators%2Fproportion-of-children-under-5-years-of-age-whose-births-have-been-registered-with-a-civil-authority-by-age-catalog-entry\">Proportion of children under 5 years of age whose births have been registered with a civil authority, by age</a></th>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fsdg%2Findicators%2Fpublicly-accessible-green-space-as-a-proportion-of-urban-area-catalog-entry\">Publicly accessible green space as a proportion of urban area</a></th>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fbeis-electric-prepayment-meter-statistics%2Fmean-catalog-entry\">Electric prepayment meter statistics - Mean Consumption</a></th>\n",
       "      <td>393000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fbeis-electric-prepayment-meter-statistics%2Fmedian-catalog-entry\">Electric prepayment meter statistics - Median Consumption</a></th>\n",
       "      <td>393000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fbeis-electric-prepayment-meter-statistics%2Fpostcode-sales-catalog-entry\">Electric prepayment meter statistics by Post Code - Sales</a></th>\n",
       "      <td>1533658</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fbeis-electric-prepayment-meter-statistics%2Fsales-catalog-entry\">Electric prepayment meter statistics - Sales</a></th>\n",
       "      <td>393000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fbeis-lower-and-middle-super-output-areas-electricity-consumption-catalog-entry\">Lower Super Output Areas (LSOA) electricity consumption</a></th>\n",
       "      <td>3379883</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fbeis-lower-and-middle-super-output-areas-gas-consumption-catalog-entry\">Lower Super Output Areas (LSOA) gas consumption</a></th>\n",
       "      <td>3251781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fbeis-sub-regional-fuel-poverty-data-year-catalog-entry\">Sub-regional fuel poverty data - England</a></th>\n",
       "      <td>541880</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fdft-journey-times-to-key-services-by-lower-super-output-area%2Femployment-centres-catalog-entry\">Journey times to key services by lower super output area: Employment Centres - JTS0501</a></th>\n",
       "      <td>2956043</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fdft-journey-times-to-key-services-by-lower-super-output-area%2Ffood-stores-catalog-entry\">Journey times to key services by lower super output area: Food Stores - JTS0507</a></th>\n",
       "      <td>3547224</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fdft-journey-times-to-key-services-by-lower-super-output-area%2Ffurther-education-catalog-entry\">Journey times to key services by lower super output area: Further Education - JTS0504</a></th>\n",
       "      <td>3547224</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fdft-journey-times-to-key-services-by-lower-super-output-area%2Fgeneral-practices-catalog-entry\">Journey times to key services by lower super output area: General Practices - JTS0505</a></th>\n",
       "      <td>3547224</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fdft-journey-times-to-key-services-by-lower-super-output-area%2Fhospitals-catalog-entry\">Journey times to key services by lower super output area: Hospitals - JTS0506</a></th>\n",
       "      <td>3547224</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fdft-journey-times-to-key-services-by-lower-super-output-area%2Fpharmacies-catalog-entry\">Journey times to key services by lower super output area: Pharmacies - JTS0509</a></th>\n",
       "      <td>591264</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fdft-journey-times-to-key-services-by-lower-super-output-area%2Fprimary-schools-catalog-entry\">Journey times to key services by lower super output area: Primary Schools - JTS0502</a></th>\n",
       "      <td>3547224</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fdft-journey-times-to-key-services-by-lower-super-output-area%2Fsecondary-schools-catalog-entry\">Journey times to key services by lower super output area: Secondary Schools - JTS0503</a></th>\n",
       "      <td>3547224</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fdft-journey-times-to-key-services-by-lower-super-output-area%2Ftown-centre-catalog-entry\">Journey times to key services by lower super output area: Town Centre - JTS0508</a></th>\n",
       "      <td>3547224</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fhmrc-child-benefit-small-area-data%2Fchildren-catalog-entry\">Child Benefit small area statistics - Children receiving Child benefit</a></th>\n",
       "      <td>4035338</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fhmrc-child-benefit-small-area-data%2Ffamilies-catalog-entry\">Child Benefit small area statistics - Families in receipt of Child benefit</a></th>\n",
       "      <td>1795428</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fmhclg-english-indices-of-deprivation-2019-catalog-entry\">English indices of deprivation</a></th>\n",
       "      <td>13925915</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fmhclg-tracking-economic-and-child-income-deprivation-at-neighbourhood-level-in-england-1999-to-2009%2Fcount-catalog-entry\">Tracking economic and child income deprivation at neighbourhood level in England: Total Population (all ages)</a></th>\n",
       "      <td>2858477</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fmhclg-tracking-economic-and-child-income-deprivation-at-neighbourhood-level-in-england-1999-to-2009%2Fdenominators-catalog-entry\">Tracking economic and child income deprivation at neighbourhood level in England: Denominators</a></th>\n",
       "      <td>9647243</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fmhclg-tracking-economic-and-child-income-deprivation-at-neighbourhood-level-in-england-1999-to-2009%2Fnumerators-catalog-entry\">Tracking economic and child income deprivation at neighbourhood level in England: Numerators</a></th>\n",
       "      <td>9709539</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fmhclg-tracking-economic-and-child-income-deprivation-at-neighbourhood-level-in-england-1999-to-2009%2Franks-catalog-entry\">Tracking economic and child income deprivation at neighbourhood level in England: Ranks</a></th>\n",
       "      <td>12862944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fmhclg-tracking-economic-and-child-income-deprivation-at-neighbourhood-level-in-england-1999-to-2009%2Fscores-catalog-entry\">Tracking economic and child income deprivation at neighbourhood level in England: Scores</a></th>\n",
       "      <td>12925257</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fnhs-d-patients-registered-at-a-gp-practice%2Fgp-catalog-entry\">Patients Registered at a GP Practice - GP</a></th>\n",
       "      <td>17100420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fnhs-d-patients-registered-at-a-gp-practice%2Forg-catalog-entry\">Patients Registered at a GP Practice - CCG, STP, Comm Region</a></th>\n",
       "      <td>428794</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fnhs-d-patients-registered-at-a-gp-practice%2Fpcn-catalog-entry\">Patients Registered at a GP Practice - PCN</a></th>\n",
       "      <td>2926554</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fons-population-estimates-by-output-areas-electoral-health-and-other-geographies-england-and-wales-catalog-entry\">Population estimates by Output Area Geographies, Gender and Age, England and Wales</a></th>\n",
       "      <td>49092727</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fsg-scottish-index-of-multiple-deprivation-2020%2Findicators-catalog-entry\">Scottish Index of Multiple Deprivation - Indicators</a></th>\n",
       "      <td>2457410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-high-streets%2Fsg-scottish-index-of-multiple-deprivation-2020%2Franks-catalog-entry\">Scottish Index of Multiple Deprivation - Ranks</a></th>\n",
       "      <td>502321</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fhmrc-rts-small-area%2Fhmrc-rts-small-area-business-count-catalog-entry\">Regional trade in goods statistics disaggregated by smaller geographical areas: 2019 Business Count</a></th>\n",
       "      <td>107228</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fhmrc-rts-small-area%2Fhmrc-rts-small-area-gbp-million-catalog-entry\">Regional trade in goods statistics disaggregated by smaller geographical areas: 2019: Statistical value (£ million)</a></th>\n",
       "      <td>107628</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fhmrc-trade-in-goods-by-business-characteristics-catalog-entry\">UK trade in goods by business characteristics 2019 - data tables</a></th>\n",
       "      <td>29632</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-foreign-direct-investment-involving-uk-companies-catalog-entry\">Foreign direct investment involving UK companies (directional)</a></th>\n",
       "      <td>406551</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-uk-total-trade-catalog-entry\">UK total trade: all countries, non-seasonally adjusted</a></th>\n",
       "      <td>520626</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-uk-trade-in-goods-by-industry-country-and-commodity-catalog-entry\">UK trade in goods by industry, country and commodity - Imports & Exports</a></th>\n",
       "      <td>1636251</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons_abs-catalog-entry\">Annual Business Survey exporters and importers</a></th>\n",
       "      <td>13585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">Balance of payments</th>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-balance-of-payments-catalog-entry\">Balance of payments</a></th>\n",
       "      <td>37343</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-uk-sa-trade-in-goods-catalog-entry\">Trade in goods: all countries, seasonally adjusted</a></th>\n",
       "      <td>1333936</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-uk-trade-in-services-by-industry-country-and-service-type-exports-catalog-entry\">UK trade in services by industry, country and service type, Imports & Exports</a></th>\n",
       "      <td>286035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons_mrets-catalog-entry\">UK trade time series - Chained Value Measures</a></th>\n",
       "      <td>2578968</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"7\" valign=\"top\">Energy</th>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Fbeis-renewable-electricity-capacity-and-generation-et-6-1-quarterly-catalog-entry\">Renewable electricity capacity and generation (ET 6.1 - quarterly)</a></th>\n",
       "      <td>59308</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fedvp%2Flccc-actual-ilr-income-catalog-entry\">Actual ILR Income</a></th>\n",
       "      <td>53548</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fenergy%2Fbeis-energy-trends-december-2020-special-feature-article-electricity-generation-and-supply-in-scotland-wales-northern-ireland-and-england-2016-to-2019%2Fgeneration-and-supply-of-electricity-in-scotland-england-wales-northern-ireland-and-england-2004-to-2019-catalog-entry\">Generation and supply of electricity in Scotland, England, Wales, Northern Ireland and England, 2004 to 2019</a></th>\n",
       "      <td>10216</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fenergy%2Fbeis-energy-trends-december-2020-special-feature-article-electricity-generation-and-supply-in-scotland-wales-northern-ireland-and-england-2016-to-2019%2Fgeneration-of-electricity-by-fuel-in-scotland-england-wales-northern-ireland-and-england-2004-to-2019-catalog-entry\">Generation of electricity by fuel in Scotland, England, Wales, Northern Ireland and England, 2004 to 2019</a></th>\n",
       "      <td>25354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fenergy%2Fbeis-final-uk-greenhouse-gas-emissions-national-statistics-1990-to-2019-catalog-entry\">Final UK greenhouse gas emissions national statistics: 1990 to 2019</a></th>\n",
       "      <td>163176</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fenergy%2Fbeis-renewables-obligation-certificates-and-generation-monthly-catalog-entry\">Renewables obligation: certificates and generation</a></th>\n",
       "      <td>67680</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Fenergy%2Fbeis-sub-regional-feed-in-tariffs-confirmed-on-the-cfr-statistics-catalog-entry\">Sub-regional Feed-in Tariffs confirmed on the CFR statistics</a></th>\n",
       "      <td>239520</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"7\" valign=\"top\">Gross Domestic Product (GDP)</th>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-quarterly-national-accounts%2Fgbp-data-tables-aggregates-catalog-entry\">GDP – data tables - National Accounts aggregates (A2)</a></th>\n",
       "      <td>23548</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-quarterly-national-accounts%2Fgbp-data-tables-change-in-inventories-catalog-entry\">GDP – data tables - Change in inventories at current prices and chained volume measures (G1, G2)</a></th>\n",
       "      <td>28407</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-quarterly-national-accounts%2Fgbp-data-tables-change-in-trade-catalog-entry\">GDP – data tables - Exports and Imports of goods and services at current prices and chained volume measures (H1, H2)</a></th>\n",
       "      <td>53994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-quarterly-national-accounts%2Fgbp-data-tables-cvm-output-catalog-entry\">GDP – data tables - Gross value added chained volume measures at basic prices, by category of output (B1 & B2)</a></th>\n",
       "      <td>32617</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-quarterly-national-accounts%2Fgbp-data-tables-expenditure-catalog-entry\">GDP – data tables - Household final consumption by purpose and goods and services at Current Prices & Chained Volume Measures (E1, E2, E3, E4)</a></th>\n",
       "      <td>75216</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-quarterly-national-accounts%2Fgbp-data-tables-gfcf-catalog-entry\">GDP – data tables - Gross fixed capital formation by sector and type of asset at current prices and chained volume measures (F1, F2)</a></th>\n",
       "      <td>40956</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-quarterly-national-accounts%2Fgbp-data-tables-income-catalog-entry\">GDP – data tables - Gross domestic product: by category of income at current prices (D)</a></th>\n",
       "      <td>36454</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">International trade</th>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-exports-of-services-by-country-by-modes-of-supply-catalog-entry\">Imports and Exports of services by country, by modes of supply</a></th>\n",
       "      <td>11625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-international-trade-in-services-by-subnational-areas-of-the-uk-catalog-entry\">International trade in services by subnational areas of the UK</a></th>\n",
       "      <td>91893</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-international-trade-in-services-catalog-entry\">International trade in services</a></th>\n",
       "      <td>248308</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">Towns & High Streets</th>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-and-high-streets%2Fons-employment-estimates-for-towns-for-2019-catalog-entry\">Employment estimates for towns for 2019</a></th>\n",
       "      <td>8346</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-and-high-streets%2Fons-employment-for-towns-by-broad-industry-groups-business-register-and-employment-survey-bres-catalog-entry\">Employment for towns by broad industry groups, Business Register and Employment Survey (BRES), 2018</a></th>\n",
       "      <td>608487</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftowns-and-high-streets%2Fons-towns-local-units-counts-by-size-bands-inter-departmental-business-register-idbr-2015-to-2018-catalog-entry\">Towns - local units counts by size bands, Inter-Departmental Business Register (IDBR), 2015 to 2018</a></th>\n",
       "      <td>189813</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"35\" valign=\"top\">Trade</th>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fdcms-sectors-economic-estimates-year-trade-in-services-catalog-entry\">Sectors Economic Estimates 2018: Trade in services</a></th>\n",
       "      <td>42442</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fhmrc-alcohol-bulletin%2Falcohol-bulletin-clearances-catalog-entry\">Alcohol Bulletin - Clearances</a></th>\n",
       "      <td>63855</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fhmrc-alcohol-bulletin%2Falcohol-bulletin-duty-receipts-catalog-entry\">Alcohol Bulletin - Duty Receipts</a></th>\n",
       "      <td>12255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fhmrc-alcohol-bulletin%2Falcohol-bulletin-production-catalog-entry\">Alcohol Bulletin - Production</a></th>\n",
       "      <td>5976</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fhmrc-overseas-trade-statistics%2Fhmrc-overseas-trade-statistics-cn8-catalog-entry\">HMRC Overseas Trade Statistics - Combined Nomenclature 8</a></th>\n",
       "      <td>5267346</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fhmrc-overseas-trade-statistics%2Fhmrc-overseas-trade-statistics-cn8-catalog-entry\">HMRC Overseas Trade Statistics - Combined Nomenclature 8</a></th>\n",
       "      <td>5267286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fhmrc-overseas-trade-statistics%2Fhmrc-overseas-trade-statistics-sitc-catalog-entry\">HMRC Overseas Trade Statistics - SITCv4</a></th>\n",
       "      <td>3536988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fhmrc-overseas-trade-statistics%2Fhmrc-overseas-trade-statistics-sitc-catalog-entry\">HMRC Overseas Trade Statistics - SITCv4</a></th>\n",
       "      <td>3536928</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fhmrc-regional-trade-statistics-catalog-entry\">HMRC Regional Trade Statistics</a></th>\n",
       "      <td>12071610</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fhmrc-regional-trade-statistics-catalog-entry\">HMRC Regional Trade Statistics</a></th>\n",
       "      <td>2057651</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fhmrc-regional-trade-statistics-catalog-entry\">HMRC Regional Trade Statistics</a></th>\n",
       "      <td>2047551</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fhmrc-regional-trade-statistics-catalog-entry\">HMRC Regional Trade Statistics</a></th>\n",
       "      <td>2080031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fhmrc-regional-trade-statistics-catalog-entry\">HMRC Regional Trade Statistics</a></th>\n",
       "      <td>2072331</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fhmrc-regional-trade-statistics-catalog-entry\">HMRC Regional Trade Statistics</a></th>\n",
       "      <td>2077851</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fhmrc-regional-trade-statistics-catalog-entry\">HMRC Regional Trade Statistics</a></th>\n",
       "      <td>2056171</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fhmrc-regional-trade-statistics-catalog-entry\">HMRC Regional Trade Statistics</a></th>\n",
       "      <td>2071231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fhmrc-regional-trade-statistics-catalog-entry\">HMRC Regional Trade Statistics</a></th>\n",
       "      <td>2056731</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fhmrc-regional-trade-statistics-catalog-entry\">HMRC Regional Trade Statistics</a></th>\n",
       "      <td>2053391</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fhmrc-regional-trade-statistics-interactive-analysis-catalog-entry\">Regional trade statistics interactive analysis: second quarter 2020</a></th>\n",
       "      <td>2179035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-international-exports-of-services-from-subnational-areas-of-the-uk-catalog-entry\">International exports of services from subnational areas of the UK</a></th>\n",
       "      <td>25578</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-pink-book-trade-in-services-catalog-entry\">The Pink Book, Trade in Services</a></th>\n",
       "      <td>53676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-quarterly-country-and-regional-gdp-catalog-entry\">Quarterly country and regional GDP</a></th>\n",
       "      <td>246972</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-regional-gross-domestic-product-city-regions-catalog-entry\">Regional Gross Domestic Product city regions - Chained Volume Measures annual growth rates</a></th>\n",
       "      <td>1104169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-reuk-service-catalog-entry\">Regionalised estimates of UK service exports</a></th>\n",
       "      <td>9580</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-uk-economic-accounts-balance-of-payments-current-account%2Fuk-economic-accounts-balance-of-payments-capital-account-catalog-entry\">UK Economic Accounts: balance of payments - Capital Account</a></th>\n",
       "      <td>83025</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-uk-economic-accounts-balance-of-payments-current-account%2Fuk-economic-accounts-balance-of-payments-current-account-primary-income-catalog-entry\">UK Economic Accounts: balance of payments - Current Account - Primary Income</a></th>\n",
       "      <td>107689</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-uk-economic-accounts-balance-of-payments-current-account%2Fuk-economic-accounts-balance-of-payments-current-account-secondary-income-catalog-entry\">UK Economic Accounts: balance of payments - Current Account - Secondary Income</a></th>\n",
       "      <td>59545</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-uk-economic-accounts-balance-of-payments-current-account%2Fuk-economic-accounts-balance-of-payments-current-account-summary-of-balance-of-payments-catalog-entry\">UK Economic Accounts: balance of payments - Current Account - Summary of balance of payments</a></th>\n",
       "      <td>36641</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-uk-economic-accounts-balance-of-payments-current-account%2Fuk-economic-accounts-balance-of-payments-current-account-trade-in-goods-and-services-catalog-entry\">UK Economic Accounts: balance of payments - Current Account - Trade in goods and services</a></th>\n",
       "      <td>155874</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-uk-economic-accounts-balance-of-payments-current-account%2Fuk-economic-accounts-balance-of-payments-current-account-transactions-with-non-eu-countries-catalog-entry\">UK Economic Accounts: balance of payments - Current Account - Transactions with non-EU countries</a></th>\n",
       "      <td>466633</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-uk-economic-accounts-balance-of-payments-current-account%2Fuk-economic-accounts-balance-of-payments-current-account-transactions-with-the-eu-and-emu-catalog-entry\">UK Economic Accounts: balance of payments - Current Account - Transactions with the EU and EMU</a></th>\n",
       "      <td>93392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-uk-trade-in-goods-cpa-08-catalog-entry\">UK trade in goods, CPA(08)</a></th>\n",
       "      <td>1131769</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-uk-trade-in-services-by-business-characteristics-catalog-entry\">UK trade in services by business characteristics</a></th>\n",
       "      <td>41653</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons-uk-trade-in-services-catalog-entry\">UK trade in services: service type by partner country, non-seasonally adjusted</a></th>\n",
       "      <td>1910023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th><a href=\"http://staging.gss-data.org.uk/cube/explore?uri=http%3A%2F%2Fgss-data.org.uk%2Fdata%2Fgss_data%2Ftrade%2Fons_cpa-catalog-entry\">UK trade in goods by classification of product by activity time series</a></th>\n",
       "      <td>6611963</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from urllib.parse import urlencode\n",
    "def gss_url(uri):\n",
    "    return 'http://staging.gss-data.org.uk/cube/explore?' + urlencode({\n",
    "        'uri': uri\n",
    "    })\n",
    "\n",
    "table['Dataset'] = table.apply(lambda x: f'<a href=\"{gss_url(x.Dataset)}\">{x.Label}</a>', axis=1)\n",
    "table.drop(columns=['Label'], inplace=True)\n",
    "table = table[['Dataset', 'Theme', 'Size']]\n",
    "table = table.sort_values(by=['Theme', 'Dataset'])\n",
    "table = table.set_index(['Theme', 'Dataset'])\n",
    "pd.set_option('max_colwidth', -1)\n",
    "with open('dataset-stats.html', 'w') as f:\n",
    "    f.write(table.to_html(escape=False, index=True))\n",
    "HTML(table.to_html(escape=False, index=True, justify='left'))"
   ]
  },
  {
   "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.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}