diff --git a/dataset-stats/size.ipynb b/dataset-stats/size.ipynb
index 80f6897..3fa471d 100644
--- a/dataset-stats/size.ipynb
+++ b/dataset-stats/size.ipynb
@@ -13,12 +13,8 @@
"metadata": {},
"outputs": [],
"source": [
- "from SPARQLWrapper import SPARQLWrapper2\n",
"import pandas as pd\n",
- "from IPython.display import HTML\n",
- "\n",
- "endpoint = \"https://production-drafter-ons-alpha.publishmydata.com/v1/sparql/live\"\n",
- "sparql = SPARQLWrapper2(endpoint)"
+ "from IPython.display import HTML"
]
},
{
@@ -30,7 +26,7 @@
},
{
"cell_type": "code",
- "execution_count": 2,
+ "execution_count": 46,
"metadata": {},
"outputs": [
{
@@ -54,191 +50,47 @@
" \n",
" \n",
" \n",
+ " \n",
+ " Dataset \n",
" Label \n",
+ " Theme \n",
+ " \n",
" \n",
" \n",
" Graph \n",
- " Family \n",
+ " \n",
+ " \n",
+ " \n",
"
94 rows × 3 columns
\n", + "155 rows × 3 columns
\n", "" ], "text/plain": [ - " Label \\\n", - "http://gss-data.org.uk/data/ons-pink-book-chapt... ONS Pink Book Chapter 3 \n", - "http://gss-data.org.uk/data/ons-bop-individual-... ONS BoP Individual Country Data \n", - "http://gss-data.org.uk/data/gss_data/migration/... Mid-Year Population Estimates \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration between Scotland and Overseas \n", - "http://gss-data.org.uk/data/gss_data/migration/... National Insurance number allocations to adult... \n", - "http://gss-data.org.uk/data/gss_data/migration/... Local area migration indicators, UK \n", - "http://gss-data.org.uk/data/gss_data/migration/... Long-term international migration 2.07, age an... \n", - "http://gss-data.org.uk/data/gss_data/migration/... Long-term international migration 2.06, area o... \n", - "http://gss-data.org.uk/data/gss_data/migration/... Long-term international migration 2.01a, citiz... \n", - "http://gss-data.org.uk/data/gss_data/migration/... Long-term international migration 2.02, countr... \n", - "http://gss-data.org.uk/data/gss_data/migration/... Long-term international migration 2.05, usual ... \n", - "http://gss-data.org.uk/data/gss_data/migration/... Long-term international migration 2.04, main r... \n", - "http://gss-data.org.uk/data/gss_data/migration/... International Passenger Survey 4.02, main reas... \n", - "http://gss-data.org.uk/data/gss_data/migration/... International Passenger Survey 4.04, area of d... \n", - "http://gss-data.org.uk/data/gss_data/migration/... International Passenger Survey 4.01, citizensh... \n", - "http://gss-data.org.uk/data/gss_data/migration/... Immigration statistics, October to December 20... \n", - "http://gss-data.org.uk/data/gss_data/health/hmr... Alcohol Duty \n", - "http://gss-data.org.uk/data/gss_data/health/doh... Census of drug and alcohol treatment services ... \n", - "http://gss-data.org.uk/data/gss_data/trade/ons_bop Balance of payments \n", - "http://gss-data.org.uk/data/gss_data/health/ons... Alcohol-specific deaths in the UK \n", - "http://gss-data.org.uk/data/gss_data/trade/hmrc... UK Trade in Goods by Business Characteristics ... \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-... Trade in goods: country-by-commodity imports a... \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-... UK trade in services: service type by partner ... \n", - "http://gss-data.org.uk/data/gss_data/trade/ons_... UK trade time series \n", - "http://gss-data.org.uk/data/gss_data/trade/ons_abs Annual Business Survey importers and exporters \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-fdi Foreign direct investment involving UK companies \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-... International trade in services \n", - "http://gss-data.org.uk/data/gss_data/trade/hmrc... UK Regional Trade Statistics (RTS \n", - "http://gss-data.org.uk/data/gss_data/trade/ons_cpa UK trade in goods by classification of product... \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-... Regionalised estimates of UK service exports \n", - "... ... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Homelessness in Scotland: Applications: Main r... \n", - "http://gss-data.org.uk/data/gss_data/disability... Homelessness in Scotland: Applications: Reason... \n", - "http://gss-data.org.uk/data/gss_data/disability... Homelessness in Scotland: Applications: Suppor... \n", - "http://gss-data.org.uk/data/gss_data/disability... Homelessness in Scotland: Identified Support N... \n", - "http://gss-data.org.uk/data/gss_data/disability... Homelessness in Scotland: Reason(s) for failin... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", + " 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", - " Graph \\\n", - "http://gss-data.org.uk/data/ons-pink-book-chapt... http://gss-data.org.uk/graph/ons-pink-book-cha... \n", - "http://gss-data.org.uk/data/ons-bop-individual-... http://gss-data.org.uk/graph/ons-bop-individua... \n", - "http://gss-data.org.uk/data/gss_data/migration/... http://gss-data.org.uk/graph/gss_data/migratio... \n", - "http://gss-data.org.uk/data/gss_data/migration/... http://gss-data.org.uk/graph/gss_data/migratio... \n", - "http://gss-data.org.uk/data/gss_data/migration/... http://gss-data.org.uk/graph/gss_data/migratio... \n", - "http://gss-data.org.uk/data/gss_data/migration/... http://gss-data.org.uk/graph/gss_data/migratio... \n", - "http://gss-data.org.uk/data/gss_data/migration/... http://gss-data.org.uk/graph/gss_data/migratio... \n", - "http://gss-data.org.uk/data/gss_data/migration/... http://gss-data.org.uk/graph/gss_data/migratio... \n", - "http://gss-data.org.uk/data/gss_data/migration/... http://gss-data.org.uk/graph/gss_data/migratio... \n", - "http://gss-data.org.uk/data/gss_data/migration/... http://gss-data.org.uk/graph/gss_data/migratio... \n", - "http://gss-data.org.uk/data/gss_data/migration/... http://gss-data.org.uk/graph/gss_data/migratio... \n", - "http://gss-data.org.uk/data/gss_data/migration/... http://gss-data.org.uk/graph/gss_data/migratio... \n", - "http://gss-data.org.uk/data/gss_data/migration/... http://gss-data.org.uk/graph/gss_data/migratio... \n", - "http://gss-data.org.uk/data/gss_data/migration/... http://gss-data.org.uk/graph/gss_data/migratio... \n", - "http://gss-data.org.uk/data/gss_data/migration/... http://gss-data.org.uk/graph/gss_data/migratio... \n", - "http://gss-data.org.uk/data/gss_data/migration/... http://gss-data.org.uk/graph/gss_data/migratio... \n", - "http://gss-data.org.uk/data/gss_data/health/hmr... http://gss-data.org.uk/graph/gss_data/health/h... \n", - "http://gss-data.org.uk/data/gss_data/health/doh... http://gss-data.org.uk/graph/gss_data/health/d... \n", - "http://gss-data.org.uk/data/gss_data/trade/ons_bop http://gss-data.org.uk/graph/gss_data/trade/on... \n", - "http://gss-data.org.uk/data/gss_data/health/ons... http://gss-data.org.uk/graph/gss_data/health/o... \n", - "http://gss-data.org.uk/data/gss_data/trade/hmrc... http://gss-data.org.uk/graph/gss_data/trade/hm... \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-... http://gss-data.org.uk/graph/gss_data/trade/on... \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-... http://gss-data.org.uk/graph/gss_data/trade/on... \n", - "http://gss-data.org.uk/data/gss_data/trade/ons_... http://gss-data.org.uk/graph/gss_data/trade/on... \n", - "http://gss-data.org.uk/data/gss_data/trade/ons_abs http://gss-data.org.uk/graph/gss_data/trade/on... \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-fdi http://gss-data.org.uk/graph/gss_data/trade/on... \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-... http://gss-data.org.uk/graph/gss_data/trade/on... \n", - "http://gss-data.org.uk/data/gss_data/trade/hmrc... http://gss-data.org.uk/graph/gss_data/trade/hm... \n", - "http://gss-data.org.uk/data/gss_data/trade/ons_cpa http://gss-data.org.uk/graph/gss_data/trade/on... \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-... http://gss-data.org.uk/graph/gss_data/trade/on... \n", - "... ... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \n", - "http://gss-data.org.uk/data/gss_data/disability... http://gss-data.org.uk/graph/gss_data/disabili... \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", - " Family \n", - "http://gss-data.org.uk/data/ons-pink-book-chapt... Trade \n", - "http://gss-data.org.uk/data/ons-bop-individual-... Trade \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration \n", - "http://gss-data.org.uk/data/gss_data/health/hmr... Health \n", - "http://gss-data.org.uk/data/gss_data/health/doh... Health \n", - "http://gss-data.org.uk/data/gss_data/trade/ons_bop Trade \n", - "http://gss-data.org.uk/data/gss_data/health/ons... Health \n", - "http://gss-data.org.uk/data/gss_data/trade/hmrc... Trade \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-... Trade \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-... Trade \n", - "http://gss-data.org.uk/data/gss_data/trade/ons_... Trade \n", - "http://gss-data.org.uk/data/gss_data/trade/ons_abs Trade \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-fdi Trade \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-... Trade \n", - "http://gss-data.org.uk/data/gss_data/trade/hmrc... Trade \n", - "http://gss-data.org.uk/data/gss_data/trade/ons_cpa Trade \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-... Trade \n", - "... ... \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability \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", - "[94 rows x 3 columns]" + "[155 rows x 3 columns]" ] }, - "execution_count": 2, + "execution_count": 46, "metadata": {}, "output_type": "execute_result" } ], "source": [ - "sparql.setQuery(\"\"\"\n", + "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:540 rows × 1 columns
\n", + "703 rows × 1 columns
\n", "" ], "text/plain": [ - " Triples\n", - "http://purl.org/dc/terms/ 866\n", - "http://gss-data.org.uk/graph/semstats/cpav2008-... 28071\n", - "http://gss-data.org.uk/graph/semstats/cpav2008 47707\n", - "http://gss-data.org.uk/graph/semstats/cpav21 44275\n", - "http://gss-data.org.uk/graph/semstats/cpcv11 29269\n", - "http://gss-data.org.uk/graph/semstats/cpcv2 44159\n", - "http://gss-data.org.uk/graph/semstats/cpcv21 36837\n", - "http://gss-data.org.uk/graph/semstats/cpcv11-cpcv2 15202\n", - "http://gss-data.org.uk/graph/semstats/cpcv2-cpcv21 14788\n", - "http://gss-data.org.uk/graph/semstats/isicr31 5438\n", - "http://gss-data.org.uk/graph/semstats/isicr31-c... 13350\n", - "http://gss-data.org.uk/graph/semstats/isicr31-i... 4116\n", - "http://gss-data.org.uk/graph/semstats/isicr4 9249\n", - "http://gss-data.org.uk/graph/semstats/isicr4-cp... 13320\n", - "http://gss-data.org.uk/graph/semstats/isicr4-cpcv2 12305\n", - "http://gss-data.org.uk/graph/semstats/isicr4-na... 4311\n", - "http://gss-data.org.uk/graph/semstats/isicr4-na... 7591\n", - "http://gss-data.org.uk/graph/semstats/nacer11 9605\n", - "http://gss-data.org.uk/graph/semstats/nacer2 12806\n", - "http://gss-data.org.uk/graph/semstats/nacer2-cp... 16066\n", - "http://gss-data.org.uk/graph/semstats/nacer2-cp... 15716\n", - "http://gss-data.org.uk/graph/semstats/nacer11-n... 5096\n", - "http://gss-data.org.uk/graph/semstats/naics2012 17756\n", - "http://xmlns.com/foaf/0.1/ 631\n", - "http://publishmydata.com/graph/vocabulary/22-rd... 102\n", - "http://publishmydata.com/graph/vocabulary/admingeo 3369\n", - "http://publishmydata.com/graph/vocabulary/sdmx 120\n", - "http://publishmydata.com/graph/vocabulary/skos 273\n", - "http://publishmydata.com/graph/vocabulary/sdmx-... 295\n", - "http://publishmydata.com/graph/vocabulary/stati... 32\n", - "... ...\n", - "http://gss-data.org.uk/graph/gss_data/disabilit... 16\n", - "http://gss-data.org.uk/graph/gss_data/disabilit... 8964\n", - "http://gss-data.org.uk/graph/gss_data/disabilit... 16\n", - "http://gss-data.org.uk/graph/gss_data/disabilit... 17376\n", - "http://gss-data.org.uk/graph/gss_data/disabilit... 16\n", - "http://gss-data.org.uk/graph/gss_data/disabilit... 38862\n", - "http://gss-data.org.uk/graph/gss_data/disabilit... 16\n", - "http://gss-data.org.uk/graph/gss_data/disabilit... 2059\n", - "http://gss-data.org.uk/graph/gss_data/disabilit... 16\n", - "http://gss-data.org.uk/graph/gss_data/disabilit... 2783\n", - "http://gss-data.org.uk/graph/gss_data/disabilit... 16\n", - "http://gss-data.org.uk/graph/gss_data/disabilit... 11199\n", - "http://gss-data.org.uk/graph/gss_data/disabilit... 16\n", - "http://gss-data.org.uk/graph/gss_data/disabilit... 28329\n", - "http://gss-data.org.uk/graph/gss_data/disabilit... 16\n", - "http://gss-data.org.uk/graph/gss_data/disabilit... 810\n", - "http://gss-data.org.uk/graph/gss_data/disabilit... 16\n", - "http://gss-data.org.uk/graph/gss_data/disabilit... 270\n", - "http://gss-data.org.uk/graph/gss_data/disabilit... 16\n", - "http://gss-data.org.uk/graph/gss_data/disabilit... 862\n", - "http://gss-data.org.uk/graph/gss_data/disabilit... 16\n", - "http://gss-data.org.uk/graph/gss_data/disabilit... 810\n", - "http://gss-data.org.uk/graph/gss_data/disabilit... 16\n", - "http://gss-data.org.uk/graph/gss_data/disabilit... 113\n", - "http://gss-data.org.uk/graph/gss_data/disabilit... 16\n", - "http://gss-data.org.uk/graph/gss_data/disabilit... 62889\n", - "http://gss-data.org.uk/graph/gss_data/disabilit... 775784\n", - "http://gss-data.org.uk/graph/gss_data/disabilit... 2\n", - "http://gss-data.org.uk/graph/dwp-frs-people 27\n", - "http://gss-data.org.uk/graph/phe-group 51\n", + " 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", - "[540 rows x 1 columns]" + "[703 rows x 1 columns]" ] }, - "execution_count": 3, + "execution_count": 38, "metadata": {}, "output_type": "execute_result" } ], "source": [ - "sparql.setQuery(\"\"\"\n", - "SELECT (COUNT(*) as ?size) ?graph\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", + "SELECT (COUNT(*) as ?Size) ?Graph\n", "WHERE {\n", - " GRAPH ?graph {\n", + " GRAPH ?Graph {\n", " ?s ?p ?o\n", " }\n", - "} GROUP BY ?graph\n", - "\"\"\")\n", + "} GROUP BY ?Graph\n", + "'''})\n", "\n", - "sizes = pd.DataFrame()\n", - "sizes['Triples'] = pd.Series({\n", - " res['graph'].value : int(res['size'].value)\n", - " for res in sparql.query().bindings\n", - "})\n", + "sizes = pd.read_csv(StringIO(result.content.decode('utf-8')), index_col='Graph')\n", "sizes" ] }, { "cell_type": "code", - "execution_count": 4, + "execution_count": 53, "metadata": {}, "outputs": [ { @@ -1069,527 +374,175 @@ " \n", "77 rows × 3 columns
\n", + "155 rows × 4 columns
\n", "" ], "text/plain": [ - " Label \\\n", - "http://gss-data.org.uk/data/ons-pink-book-chapt... ONS Pink Book Chapter 3 \n", - "http://gss-data.org.uk/data/ons-bop-individual-... ONS BoP Individual Country Data \n", - "http://gss-data.org.uk/data/gss_data/migration/... Mid-Year Population Estimates \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration between Scotland and Overseas \n", - "http://gss-data.org.uk/data/gss_data/migration/... National Insurance number allocations to adult... \n", - "http://gss-data.org.uk/data/gss_data/migration/... Local area migration indicators, UK \n", - "http://gss-data.org.uk/data/gss_data/migration/... Long-term international migration 2.07, age an... \n", - "http://gss-data.org.uk/data/gss_data/migration/... Long-term international migration 2.06, area o... \n", - "http://gss-data.org.uk/data/gss_data/migration/... Long-term international migration 2.01a, citiz... \n", - "http://gss-data.org.uk/data/gss_data/migration/... Long-term international migration 2.02, countr... \n", - "http://gss-data.org.uk/data/gss_data/migration/... Long-term international migration 2.05, usual ... \n", - "http://gss-data.org.uk/data/gss_data/migration/... Long-term international migration 2.04, main r... \n", - "http://gss-data.org.uk/data/gss_data/migration/... International Passenger Survey 4.02, main reas... \n", - "http://gss-data.org.uk/data/gss_data/migration/... International Passenger Survey 4.04, area of d... \n", - "http://gss-data.org.uk/data/gss_data/migration/... International Passenger Survey 4.01, citizensh... \n", - "http://gss-data.org.uk/data/gss_data/migration/... Immigration statistics, October to December 20... \n", - "http://gss-data.org.uk/data/gss_data/health/hmr... Alcohol Duty \n", - "http://gss-data.org.uk/data/gss_data/health/doh... Census of drug and alcohol treatment services ... \n", - "http://gss-data.org.uk/data/gss_data/trade/ons_bop Balance of payments \n", - "http://gss-data.org.uk/data/gss_data/health/ons... Alcohol-specific deaths in the UK \n", - "http://gss-data.org.uk/data/gss_data/trade/hmrc... UK Trade in Goods by Business Characteristics ... \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-... Trade in goods: country-by-commodity imports a... \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-... UK trade in services: service type by partner ... \n", - "http://gss-data.org.uk/data/gss_data/trade/ons_... UK trade time series \n", - "http://gss-data.org.uk/data/gss_data/trade/ons_abs Annual Business Survey importers and exporters \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-fdi Foreign direct investment involving UK companies \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-... International trade in services \n", - "http://gss-data.org.uk/data/gss_data/trade/hmrc... UK Regional Trade Statistics (RTS \n", - "http://gss-data.org.uk/data/gss_data/trade/ons_cpa UK trade in goods by classification of product... \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-... Regionalised estimates of UK service exports \n", - "... ... \n", - "http://gss-data.org.uk/data/gss_data/housing/sc... Empty properties and second homes \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-... UK trade in goods by industry, country and com... \n", - "http://gss-data.org.uk/data/gss_data/housing/wg... Social housing vacancies \n", - "http://gss-data.org.uk/data/gss_data/health/nis... Alcohol-Specific Deaths 2007-2017 \n", - "http://gss-data.org.uk/data/gss_data/housing/wg... Council tax dwellings \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-... UK total trade: all countries, non-seasonally ... \n", - "http://gss-data.org.uk/data/gss_data/disability... Family Resources Survey: financial year 2017/18 \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-... Trade in goods: all countries, seasonally adju... \n", - "http://gss-data.org.uk/data/gss_data/disability... Children living in long-term workless househol... \n", - "http://gss-data.org.uk/data/gss_data/disability... A08: Labour market status of disabled people \n", - "http://gss-data.org.uk/data/gss_data/disability... Homelessness in Scotland: Applications: Main r... \n", - "http://gss-data.org.uk/data/gss_data/disability... Homelessness in Scotland: Applications: Reason... \n", - "http://gss-data.org.uk/data/gss_data/disability... Homelessness in Scotland: Applications: Suppor... \n", - "http://gss-data.org.uk/data/gss_data/disability... Homelessness in Scotland: Identified Support N... \n", - "http://gss-data.org.uk/data/gss_data/disability... Homelessness in Scotland: Reason(s) for failin... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", - "http://gss-data.org.uk/data/gss_data/disability... Co-occurring substance misuse and mental healt... \n", + " 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", - " Family Triples \n", - "http://gss-data.org.uk/data/ons-pink-book-chapt... Trade 150770 \n", - "http://gss-data.org.uk/data/ons-bop-individual-... Trade 1777303 \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration 194613 \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration 219560 \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration 53874 \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration 153643 \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration 35264 \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration 13223 \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration 20269 \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration 17579 \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration 10954 \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration 8769 \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration 13460 \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration 63279 \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration 2661663 \n", - "http://gss-data.org.uk/data/gss_data/migration/... Migration 279852 \n", - "http://gss-data.org.uk/data/gss_data/health/hmr... Health 264090 \n", - "http://gss-data.org.uk/data/gss_data/health/doh... Health 5912 \n", - "http://gss-data.org.uk/data/gss_data/trade/ons_bop Trade 10588 \n", - "http://gss-data.org.uk/data/gss_data/health/ons... Health 34711 \n", - "http://gss-data.org.uk/data/gss_data/trade/hmrc... Trade 8903 \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-... Trade 147999181 \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-... Trade 1216327 \n", - "http://gss-data.org.uk/data/gss_data/trade/ons_... Trade 4983049 \n", - "http://gss-data.org.uk/data/gss_data/trade/ons_abs Trade 24402 \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-fdi Trade 224702 \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-... Trade 191582 \n", - "http://gss-data.org.uk/data/gss_data/trade/hmrc... Trade 40633124 \n", - "http://gss-data.org.uk/data/gss_data/trade/ons_cpa Trade 5949765 \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-... Trade 9596 \n", - "... ... ... \n", - "http://gss-data.org.uk/data/gss_data/housing/sc... Housing 17255 \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-... Trade 4837341 \n", - "http://gss-data.org.uk/data/gss_data/housing/wg... Housing 2991203 \n", - "http://gss-data.org.uk/data/gss_data/health/nis... Health 1861 \n", - "http://gss-data.org.uk/data/gss_data/housing/wg... Housing 832568 \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-... Trade 442049 \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability 2657 \n", - "http://gss-data.org.uk/data/gss_data/trade/ons-... Trade 1064823 \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability 917 \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability 61872 \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability 1657 \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability 1062 \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability 807 \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability 87 \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability 182 \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability 732 \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability 3503 \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability 8964 \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability 17376 \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability 38862 \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability 2059 \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability 2783 \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability 11199 \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability 28329 \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability 810 \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability 270 \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability 862 \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability 810 \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability 113 \n", - "http://gss-data.org.uk/data/gss_data/disability... Disability 62889 \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", - "[77 rows x 3 columns]" + " 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": 4, + "execution_count": 53, "metadata": {}, "output_type": "execute_result" } ], "source": [ - "table = table.merge(sizes, left_on='Graph', right_index=True)\n", - "table.drop(columns=['Graph'], inplace=True)\n", + "table = datasets.join(sizes)\n", "table" ] }, { "cell_type": "code", - "execution_count": 5, + "execution_count": 54, "metadata": {}, "outputs": [ { @@ -1597,330 +550,644 @@ "text/html": [ "