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", + " Dataset\n", " Label\n", + " Theme\n", + " \n", + " \n", " Graph\n", - " Family\n", + " \n", + " \n", + " \n", " \n", " \n", " \n", " \n", - " http://gss-data.org.uk/data/ons-pink-book-chapter-3\n", - " ONS Pink Book Chapter 3\n", - " http://gss-data.org.uk/graph/ons-pink-book-cha...\n", - " Trade\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/data/gss_data/covid-19/ho-statistics-relating-to-covid-19-and-the-immigration-system-may-2020-catalog-entry\n", + " Statistics relating to Covid-19 and the immigration system\n", + " \n", " \n", " \n", - " http://gss-data.org.uk/data/ons-bop-individual-country-data\n", - " ONS BoP Individual Country Data\n", - " http://gss-data.org.uk/graph/ons-bop-individua...\n", - " Trade\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/data/gss_data/covid-19/nrs-deaths-involving-coronavirus-covid-19-in-scotland-catalog-entry\n", + " Deaths involving COVID-19 in Scotland\n", + " \n", " \n", " \n", - " http://gss-data.org.uk/data/gss_data/migration/nisra-ni-migration-estimates\n", - " Mid-Year Population Estimates\n", - " http://gss-data.org.uk/graph/gss_data/migratio...\n", - " Migration\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/data/gss_data/covid-19/wg-notifications-of-deaths-of-residents-related-to-covid-19-in-adult-care-homes-catalog-entry\n", + " Notifications of deaths of residents related to COVID-19 in adult care homes\n", + " \n", " \n", " \n", - " http://gss-data.org.uk/data/gss_data/migration/scotland-overseas\n", - " Migration between Scotland and Overseas\n", - " http://gss-data.org.uk/graph/gss_data/migratio...\n", - " Migration\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/data/gss_data/covid-19/ons-number-of-deaths-in-care-homes-notified-to-the-care-quality-commission-england-catalog-entry\n", + " Number of deaths in care homes notified to the Care Quality Commission, England\n", + " \n", " \n", " \n", - " http://gss-data.org.uk/data/gss_data/migration/dwp-nin-registrations-to-overseas-nationals\n", - " National Insurance number allocations to adult...\n", - " http://gss-data.org.uk/graph/gss_data/migratio...\n", - " Migration\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/migration/ons-local-area-migration-indicators\n", - " Local area migration indicators, UK\n", - " http://gss-data.org.uk/graph/gss_data/migratio...\n", - " Migration\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/migration/ons-ltim-age-and-sex\n", - " Long-term international migration 2.07, age an...\n", - " http://gss-data.org.uk/graph/gss_data/migratio...\n", - " Migration\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/migration/ons-ltim-uk-destination-or-origin\n", - " Long-term international migration 2.06, area o...\n", - " http://gss-data.org.uk/graph/gss_data/migratio...\n", - " Migration\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/migration/ons-ltim-citizenship\n", - " Long-term international migration 2.01a, citiz...\n", - " http://gss-data.org.uk/graph/gss_data/migratio...\n", - " Migration\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/migration/ons-ltim-country-of-residence\n", - " Long-term international migration 2.02, countr...\n", - " http://gss-data.org.uk/graph/gss_data/migratio...\n", - " Migration\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/migration/ons-ltim-occupation\n", - " Long-term international migration 2.05, usual ...\n", - " http://gss-data.org.uk/graph/gss_data/migratio...\n", - " Migration\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/migration/ons-ltim-reason-for-migration\n", - " Long-term international migration 2.04, main r...\n", - " http://gss-data.org.uk/graph/gss_data/migratio...\n", - " Migration\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/migration/ons-ltim-passenger-survey-4-02\n", - " International Passenger Survey 4.02, main reas...\n", - " http://gss-data.org.uk/graph/gss_data/migratio...\n", - " Migration\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/migration/ons-ltim-passenger-survey-4-04\n", - " International Passenger Survey 4.04, area of d...\n", - " http://gss-data.org.uk/graph/gss_data/migratio...\n", - " Migration\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/migration/ons-ltim-passenger-survey-4-01\n", - " International Passenger Survey 4.01, citizensh...\n", - " http://gss-data.org.uk/graph/gss_data/migratio...\n", - " Migration\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/migration/ho-entry-visas\n", - " Immigration statistics, October to December 20...\n", - " http://gss-data.org.uk/graph/gss_data/migratio...\n", - " Migration\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/health/hmrc_alcohol_bulletin\n", - " Alcohol Duty\n", - " http://gss-data.org.uk/graph/gss_data/health/h...\n", - " Health\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/health/doh-ni-drug-alcohol-treatment-services\n", - " Census of drug and alcohol treatment services ...\n", - " http://gss-data.org.uk/graph/gss_data/health/d...\n", - " Health\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/trade/ons_bop\n", - " Balance of payments\n", - " http://gss-data.org.uk/graph/gss_data/trade/on...\n", - " Trade\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/health/ons_alcohol_deaths_uk\n", - " Alcohol-specific deaths in the UK\n", - " http://gss-data.org.uk/graph/gss_data/health/o...\n", - " Health\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/trade/hmrc_trade\n", - " UK Trade in Goods by Business Characteristics ...\n", - " http://gss-data.org.uk/graph/gss_data/trade/hm...\n", - " Trade\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/trade/ons-trade-in-goods\n", - " Trade in goods: country-by-commodity imports a...\n", - " http://gss-data.org.uk/graph/gss_data/trade/on...\n", - " Trade\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/trade/ons-uk-trade-in-services\n", - " UK trade in services: service type by partner ...\n", - " http://gss-data.org.uk/graph/gss_data/trade/on...\n", - " Trade\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/trade/ons_mrets\n", - " UK trade time series\n", - " http://gss-data.org.uk/graph/gss_data/trade/on...\n", - " Trade\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/trade/ons_abs\n", - " Annual Business Survey importers and exporters\n", - " http://gss-data.org.uk/graph/gss_data/trade/on...\n", - " Trade\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/trade/ons-fdi\n", - " Foreign direct investment involving UK companies\n", - " http://gss-data.org.uk/graph/gss_data/trade/on...\n", - " Trade\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/trade/ons-international-trade-in-services\n", - " International trade in services\n", - " http://gss-data.org.uk/graph/gss_data/trade/on...\n", - " Trade\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/trade/hmrc_rts\n", - " UK Regional Trade Statistics (RTS\n", - " http://gss-data.org.uk/graph/gss_data/trade/hm...\n", - " Trade\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/trade/ons_cpa\n", - " UK trade in goods by classification of product...\n", - " http://gss-data.org.uk/graph/gss_data/trade/on...\n", - " Trade\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/trade/ons-reuk-service\n", - " Regionalised estimates of UK service exports\n", - " http://gss-data.org.uk/graph/gss_data/trade/on...\n", - " Trade\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", + " 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", + " Deaths involving COVID-19 in the care sector for England and Wales\n", + " \n", " \n", " \n", " ...\n", @@ -247,436 +99,134 @@ " ...\n", " \n", " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues-district-ua-deprivation-deciles-in-england-imd2015-419-geog\n", - " Co-occurring substance misuse and mental healt...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\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/data/gss_data/homelessness/mhclg-families-in-bed-and-breakfast-accommodation-for-more-than-6-weeks-catalog-entry\n", + " Families in bed and breakfast accommodation for more than 6 weeks\n", + " \n", " \n", " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues-district-ua-deprivation-deciles-in-england-imd2019-419-geog\n", - " Co-occurring substance misuse and mental healt...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\n", + " http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-cn8\n", + " http://gss-data.org.uk/data/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-cn8-catalog-entry\n", + " HMRC Overseas Trade Statistics - Combined Nomenclature 8\n", + " Trade\n", " \n", " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues-district-ua-pre-apr2019-deprivation-deciles-in-england-imd2015\n", - " Co-occurring substance misuse and mental healt...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\n", + " http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics-cn8/200001\n", + " http://gss-data.org.uk/data/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-cn8-catalog-entry\n", + " HMRC Overseas Trade Statistics - Combined Nomenclature 8\n", + " Trade\n", " \n", " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues-ethnic-groups\n", - " Co-occurring substance misuse and mental healt...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\n", + " http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-sitc\n", + " http://gss-data.org.uk/data/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-sitc-catalog-entry\n", + " HMRC Overseas Trade Statistics - SITCv4\n", + " Trade\n", " \n", " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues-health-status\n", - " Co-occurring substance misuse and mental healt...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues-lsoa11-deprivation-deciles-in-england-imd2015\n", - " Co-occurring substance misuse and mental healt...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues-religion-8-categories\n", - " Co-occurring substance misuse and mental healt...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues-sexuality-5-categories\n", - " Co-occurring substance misuse and mental healt...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues-socioeconomic-group-18-64-yrs\n", - " Co-occurring substance misuse and mental healt...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues\n", - " Co-occurring substance misuse and mental healt...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/sg-homelessness-in-scotland-annual-publication/homelessness-in-scotland-applications-main-reason-for-making-an-application-for-homelenessness-to-a-local-authority\n", - " Homelessness in Scotland: Applications: Main r...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/sg-homelessness-in-scotland-annual-publication/homelessness-in-scotland-applications-reasons-for-failing-to-maintain-accommodation-prior-to-application\n", - " Homelessness in Scotland: Applications: Reason...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/sg-homelessness-in-scotland-annual-publication/homelessness-in-scotland-applications-support-need-identified-for-those-homeless-or-threatened-with-homelessness-households\n", - " Homelessness in Scotland: Applications: Suppor...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/sg-homelessness-in-scotland-annual-publication/homelessness-in-scotland-identified-support-needs-of-homeless-households\n", - " Homelessness in Scotland: Identified Support N...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/sg-homelessness-in-scotland-annual-publication/homelessness-in-scotland-reason-for-failing-to-maintain-accommodation\n", - " Homelessness in Scotland: Reason(s) for failin...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/country-of-birth\n", - " Co-occurring substance misuse and mental healt...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/county-ua-deprivation-deciles-in-england-imd2010\n", - " Co-occurring substance misuse and mental healt...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/county-ua-deprivation-deciles-in-england-imd2015-419-geog\n", - " Co-occurring substance misuse and mental healt...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/county-ua-deprivation-deciles-in-england-imd2019-419-geog\n", - " Co-occurring substance misuse and mental healt...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/county-ua-pre-apr2019-deprivation-deciles-in-england-imd2015\n", - " Co-occurring substance misuse and mental healt...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/district-ua-deprivation-deciles-in-england-imd2010\n", - " Co-occurring substance misuse and mental healt...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/district-ua-deprivation-deciles-in-england-imd2015-419-geog\n", - " Co-occurring substance misuse and mental healt...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/district-ua-deprivation-deciles-in-england-imd2019-419-geog\n", - " Co-occurring substance misuse and mental healt...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/district-ua-pre-apr2019-deprivation-deciles-in-england-imd2015\n", - " Co-occurring substance misuse and mental healt...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/ethnic-groups\n", - " Co-occurring substance misuse and mental healt...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/health-status\n", - " Co-occurring substance misuse and mental healt...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/lsoa11-deprivation-deciles-in-england-imd2015\n", - " Co-occurring substance misuse and mental healt...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/religion-8-categories\n", - " Co-occurring substance misuse and mental healt...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/sexuality-5-categories\n", - " Co-occurring substance misuse and mental healt...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/socioeconomic-group-18-64-yrs\n", - " Co-occurring substance misuse and mental healt...\n", - " http://gss-data.org.uk/graph/gss_data/disabili...\n", - " Disability\n", + " http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics-sitc/200001\n", + " http://gss-data.org.uk/data/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-sitc-catalog-entry\n", + " HMRC Overseas Trade Statistics - SITCv4\n", + " Trade\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: \n", "PREFIX qb: \n", - "PREFIX pmd: \n", + "PREFIX pmdcat: \n", "PREFIX gdp: \n", + "PREFIX dcat: \n", "\n", - "SELECT DISTINCT ?dataset ?datasetLabel ?graph ?family\n", + "SELECT DISTINCT ?Dataset ?Label ?Graph ?Theme\n", "WHERE {\n", - " ?dataset a qb:DataSet ;\n", - " rdfs:label ?datasetLabel ;\n", - " pmd:graph ?graph .\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 gdp:family [rdfs:label ?family]\n", + " ?Dataset dcat:theme [rdfs:label ?Theme]\n", " }\n", - "}\n", - "\"\"\")\n", + "}'''})\n", "\n", - "results = sparql.query().bindings\n", - "\n", - "table = pd.DataFrame()\n", - "table['Label'] = pd.Series({\n", - " res['dataset'].value: res['datasetLabel'].value\n", - " for res in results\n", - "})\n", - "\n", - "table['Graph'] = pd.Series({\n", - " res['dataset'].value: res['graph'].value\n", - " for res in results\n", - "})\n", - "\n", - "table['Family'] = pd.Series({\n", - " res['dataset'].value: res['family'].value if 'family' in res else 'Trade'\n", - " for res in results\n", - "})\n", - "table" + "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 graphs." + "Find the sizes of the cubes." ] }, { "cell_type": "code", - "execution_count": 3, + "execution_count": 38, "metadata": {}, "outputs": [ { @@ -700,352 +250,107 @@ " \n", " \n", " \n", - " Triples\n", + " Size\n", + " \n", + " \n", + " Graph\n", + " \n", " \n", " \n", " \n", " \n", " http://purl.org/dc/terms/\n", - " 866\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/semstats/cpav2008-cpav21\n", - " 28071\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/semstats/cpav2008\n", - " 47707\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/semstats/cpav21\n", - " 44275\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/semstats/cpcv11\n", - " 29269\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/semstats/cpcv2\n", - " 44159\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/semstats/cpcv21\n", - " 36837\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/semstats/cpcv11-cpcv2\n", - " 15202\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/semstats/cpcv2-cpcv21\n", - " 14788\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/semstats/isicr31\n", - " 5438\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/semstats/isicr31-cpcv11\n", - " 13350\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/semstats/isicr31-isicr4\n", - " 4116\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/semstats/isicr4\n", - " 9249\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/semstats/isicr4-cpcv21\n", - " 13320\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/semstats/isicr4-cpcv2\n", - " 12305\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/semstats/isicr4-nacer2\n", - " 4311\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/semstats/isicr4-naics2012\n", - " 7591\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/semstats/nacer11\n", - " 9605\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/semstats/nacer2\n", - " 12806\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/semstats/nacer2-cpav21\n", - " 16066\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/semstats/nacer2-cpav2008\n", - " 15716\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/semstats/nacer11-nacer2\n", - " 5096\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/semstats/naics2012\n", - " 17756\n", + " 627\n", " \n", " \n", " http://xmlns.com/foaf/0.1/\n", - " 631\n", + " 639\n", " \n", " \n", - " http://publishmydata.com/graph/vocabulary/22-rdf-syntax-ns\n", - " 102\n", + " http://gss-data.org.uk/graph/vocab/pmdcat-metadata\n", + " 29\n", " \n", " \n", - " http://publishmydata.com/graph/vocabulary/admingeo\n", - " 3369\n", + " http://gss-data.org.uk/graph/pmdcat\n", + " 41\n", " \n", " \n", - " http://publishmydata.com/graph/vocabulary/sdmx\n", - " 120\n", - " \n", - " \n", - " http://publishmydata.com/graph/vocabulary/skos\n", - " 273\n", - " \n", - " \n", - " http://publishmydata.com/graph/vocabulary/sdmx-subject\n", - " 295\n", - " \n", - " \n", - " http://publishmydata.com/graph/vocabulary/statistical-quality\n", - " 32\n", + " http://gss-data.org.uk/graph/skos\n", + " 252\n", " \n", " \n", " ...\n", " ...\n", " \n", " \n", - " http://gss-data.org.uk/graph/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/county-ua-deprivation-deciles-in-england-imd2015-419-geog/metadata\n", - " 16\n", + " http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-cn8\n", + " 5267346\n", " \n", " \n", - " http://gss-data.org.uk/graph/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/county-ua-deprivation-deciles-in-england-imd2015-419-geog\n", - " 8964\n", + " http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-sitc-metadata\n", + " 32\n", " \n", " \n", - " http://gss-data.org.uk/graph/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/county-ua-deprivation-deciles-in-england-imd2019-419-geog/metadata\n", - " 16\n", + " http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-sitc\n", + " 3536988\n", " \n", " \n", - " http://gss-data.org.uk/graph/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/county-ua-deprivation-deciles-in-england-imd2019-419-geog\n", - " 17376\n", + " http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics-cn8/200001\n", + " 5267286\n", " \n", " \n", - " http://gss-data.org.uk/graph/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/county-ua-pre-apr2019-deprivation-deciles-in-england-imd2015/metadata\n", - " 16\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/county-ua-pre-apr2019-deprivation-deciles-in-england-imd2015\n", - " 38862\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/district-ua-deprivation-deciles-in-england-imd2010/metadata\n", - " 16\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/district-ua-deprivation-deciles-in-england-imd2010\n", - " 2059\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/district-ua-deprivation-deciles-in-england-imd2015-419-geog/metadata\n", - " 16\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/district-ua-deprivation-deciles-in-england-imd2015-419-geog\n", - " 2783\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/district-ua-deprivation-deciles-in-england-imd2019-419-geog/metadata\n", - " 16\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/district-ua-deprivation-deciles-in-england-imd2019-419-geog\n", - " 11199\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/district-ua-pre-apr2019-deprivation-deciles-in-england-imd2015/metadata\n", - " 16\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/district-ua-pre-apr2019-deprivation-deciles-in-england-imd2015\n", - " 28329\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/ethnic-groups/metadata\n", - " 16\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/ethnic-groups\n", - " 810\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/health-status/metadata\n", - " 16\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/health-status\n", - " 270\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/lsoa11-deprivation-deciles-in-england-imd2015/metadata\n", - " 16\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/lsoa11-deprivation-deciles-in-england-imd2015\n", - " 862\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/religion-8-categories/metadata\n", - " 16\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/religion-8-categories\n", - " 810\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/sexuality-5-categories/metadata\n", - " 16\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/sexuality-5-categories\n", - " 113\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/socioeconomic-group-18-64-yrs/metadata\n", - " 16\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/socioeconomic-group-18-64-yrs\n", - " 62889\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/uncategorised\n", - " 775784\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/uncategorised/metadata\n", - " 2\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/dwp-frs-people\n", - " 27\n", - " \n", - " \n", - " http://gss-data.org.uk/graph/phe-group\n", - " 51\n", + " http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics-sitc/200001\n", + " 3536928\n", " \n", " \n", "\n", - "

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", " \n", " \n", + " Dataset\n", " Label\n", - " Family\n", - " Triples\n", + " Theme\n", + " Size\n", + " \n", + " \n", + " Graph\n", + " \n", + " \n", + " \n", + " \n", " \n", " \n", " \n", " \n", - " http://gss-data.org.uk/data/ons-pink-book-chapter-3\n", - " ONS Pink Book Chapter 3\n", - " Trade\n", - " 150770\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/data/gss_data/covid-19/ho-statistics-relating-to-covid-19-and-the-immigration-system-may-2020-catalog-entry\n", + " Statistics relating to Covid-19 and the immigration system\n", + " \n", + " 3417\n", " \n", " \n", - " http://gss-data.org.uk/data/ons-bop-individual-country-data\n", - " ONS BoP Individual Country Data\n", - " Trade\n", - " 1777303\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/data/gss_data/covid-19/nrs-deaths-involving-coronavirus-covid-19-in-scotland-catalog-entry\n", + " Deaths involving COVID-19 in Scotland\n", + " \n", + " 53605\n", " \n", " \n", - " http://gss-data.org.uk/data/gss_data/migration/nisra-ni-migration-estimates\n", - " Mid-Year Population Estimates\n", - " Migration\n", - " 194613\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/data/gss_data/covid-19/wg-notifications-of-deaths-of-residents-related-to-covid-19-in-adult-care-homes-catalog-entry\n", + " Notifications of deaths of residents related to COVID-19 in adult care homes\n", + " \n", + " 249156\n", " \n", " \n", - " http://gss-data.org.uk/data/gss_data/migration/scotland-overseas\n", - " Migration between Scotland and Overseas\n", - " Migration\n", - " 219560\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/data/gss_data/covid-19/ons-number-of-deaths-in-care-homes-notified-to-the-care-quality-commission-england-catalog-entry\n", + " Number of deaths in care homes notified to the Care Quality Commission, England\n", + " \n", + " 515016\n", " \n", " \n", - " http://gss-data.org.uk/data/gss_data/migration/dwp-nin-registrations-to-overseas-nationals\n", - " National Insurance number allocations to adult...\n", - " Migration\n", - " 53874\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/migration/ons-local-area-migration-indicators\n", - " Local area migration indicators, UK\n", - " Migration\n", - " 153643\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/migration/ons-ltim-age-and-sex\n", - " Long-term international migration 2.07, age an...\n", - " Migration\n", - " 35264\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/migration/ons-ltim-uk-destination-or-origin\n", - " Long-term international migration 2.06, area o...\n", - " Migration\n", - " 13223\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/migration/ons-ltim-citizenship\n", - " Long-term international migration 2.01a, citiz...\n", - " Migration\n", - " 20269\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/migration/ons-ltim-country-of-residence\n", - " Long-term international migration 2.02, countr...\n", - " Migration\n", - " 17579\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/migration/ons-ltim-occupation\n", - " Long-term international migration 2.05, usual ...\n", - " Migration\n", - " 10954\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/migration/ons-ltim-reason-for-migration\n", - " Long-term international migration 2.04, main r...\n", - " Migration\n", - " 8769\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/migration/ons-ltim-passenger-survey-4-02\n", - " International Passenger Survey 4.02, main reas...\n", - " Migration\n", - " 13460\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/migration/ons-ltim-passenger-survey-4-04\n", - " International Passenger Survey 4.04, area of d...\n", - " Migration\n", - " 63279\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/migration/ons-ltim-passenger-survey-4-01\n", - " International Passenger Survey 4.01, citizensh...\n", - " Migration\n", - " 2661663\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/migration/ho-entry-visas\n", - " Immigration statistics, October to December 20...\n", - " Migration\n", - " 279852\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/health/hmrc_alcohol_bulletin\n", - " Alcohol Duty\n", - " Health\n", - " 264090\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/health/doh-ni-drug-alcohol-treatment-services\n", - " Census of drug and alcohol treatment services ...\n", - " Health\n", - " 5912\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/trade/ons_bop\n", - " Balance of payments\n", - " Trade\n", - " 10588\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/health/ons_alcohol_deaths_uk\n", - " Alcohol-specific deaths in the UK\n", - " Health\n", - " 34711\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/trade/hmrc_trade\n", - " UK Trade in Goods by Business Characteristics ...\n", - " Trade\n", - " 8903\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/trade/ons-trade-in-goods\n", - " Trade in goods: country-by-commodity imports a...\n", - " Trade\n", - " 147999181\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/trade/ons-uk-trade-in-services\n", - " UK trade in services: service type by partner ...\n", - " Trade\n", - " 1216327\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/trade/ons_mrets\n", - " UK trade time series\n", - " Trade\n", - " 4983049\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/trade/ons_abs\n", - " Annual Business Survey importers and exporters\n", - " Trade\n", - " 24402\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/trade/ons-fdi\n", - " Foreign direct investment involving UK companies\n", - " Trade\n", - " 224702\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/trade/ons-international-trade-in-services\n", - " International trade in services\n", - " Trade\n", - " 191582\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/trade/hmrc_rts\n", - " UK Regional Trade Statistics (RTS\n", - " Trade\n", - " 40633124\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/trade/ons_cpa\n", - " UK trade in goods by classification of product...\n", - " Trade\n", - " 5949765\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/trade/ons-reuk-service\n", - " Regionalised estimates of UK service exports\n", - " Trade\n", - " 9596\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", + " 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", + " Deaths involving COVID-19 in the care sector for England and Wales\n", + " \n", + " 317055\n", " \n", " \n", " ...\n", " ...\n", " ...\n", " ...\n", + " ...\n", " \n", " \n", - " http://gss-data.org.uk/data/gss_data/housing/scotland-housing-empty-property-and-second-home\n", - " Empty properties and second homes\n", - " Housing\n", - " 17255\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/data/gss_data/homelessness/mhclg-families-in-bed-and-breakfast-accommodation-for-more-than-6-weeks-catalog-entry\n", + " Families in bed and breakfast accommodation for more than 6 weeks\n", + " \n", + " 22724\n", " \n", " \n", - " http://gss-data.org.uk/data/gss_data/trade/ons-uk-trade-in-goods-by-industry-country-and-commodity\n", - " UK trade in goods by industry, country and com...\n", + " http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-cn8\n", + " http://gss-data.org.uk/data/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-cn8-catalog-entry\n", + " HMRC Overseas Trade Statistics - Combined Nomenclature 8\n", " Trade\n", - " 4837341\n", + " 5267346\n", " \n", " \n", - " http://gss-data.org.uk/data/gss_data/housing/wg-social-housing-vacancies\n", - " Social housing vacancies\n", - " Housing\n", - " 2991203\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/health/nisra_alcohol_deaths\n", - " Alcohol-Specific Deaths 2007-2017\n", - " Health\n", - " 1861\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/housing/wg-chargeable-homes\n", - " Council tax dwellings\n", - " Housing\n", - " 832568\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/trade/ons-uk-total-trade\n", - " UK total trade: all countries, non-seasonally ...\n", + " http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics-cn8/200001\n", + " http://gss-data.org.uk/data/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-cn8-catalog-entry\n", + " HMRC Overseas Trade Statistics - Combined Nomenclature 8\n", " Trade\n", - " 442049\n", + " 5267286\n", " \n", " \n", - " http://gss-data.org.uk/data/gss_data/disability/dwp-family-resources-survey-disability\n", - " Family Resources Survey: financial year 2017/18\n", - " Disability\n", - " 2657\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/trade/ons-uk-sa-trade-in-goods\n", - " Trade in goods: all countries, seasonally adju...\n", + " http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-sitc\n", + " http://gss-data.org.uk/data/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-sitc-catalog-entry\n", + " HMRC Overseas Trade Statistics - SITCv4\n", " Trade\n", - " 1064823\n", + " 3536988\n", " \n", " \n", - " http://gss-data.org.uk/data/gss_data/disability/ons-children-living-in-long-term-workless-households-by-disability-status\n", - " Children living in long-term workless househol...\n", - " Disability\n", - " 917\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/ons-labour-force-survey\n", - " A08: Labour market status of disabled people\n", - " Disability\n", - " 61872\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/sg-homelessness-in-scotland-annual-publication/homelessness-in-scotland-applications-main-reason-for-making-an-application-for-homelenessness-to-a-local-authority\n", - " Homelessness in Scotland: Applications: Main r...\n", - " Disability\n", - " 1657\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/sg-homelessness-in-scotland-annual-publication/homelessness-in-scotland-applications-reasons-for-failing-to-maintain-accommodation-prior-to-application\n", - " Homelessness in Scotland: Applications: Reason...\n", - " Disability\n", - " 1062\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/sg-homelessness-in-scotland-annual-publication/homelessness-in-scotland-applications-support-need-identified-for-those-homeless-or-threatened-with-homelessness-households\n", - " Homelessness in Scotland: Applications: Suppor...\n", - " Disability\n", - " 807\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/sg-homelessness-in-scotland-annual-publication/homelessness-in-scotland-identified-support-needs-of-homeless-households\n", - " Homelessness in Scotland: Identified Support N...\n", - " Disability\n", - " 87\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/sg-homelessness-in-scotland-annual-publication/homelessness-in-scotland-reason-for-failing-to-maintain-accommodation\n", - " Homelessness in Scotland: Reason(s) for failin...\n", - " Disability\n", - " 182\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/country-of-birth\n", - " Co-occurring substance misuse and mental healt...\n", - " Disability\n", - " 732\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/county-ua-deprivation-deciles-in-england-imd2010\n", - " Co-occurring substance misuse and mental healt...\n", - " Disability\n", - " 3503\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/county-ua-deprivation-deciles-in-england-imd2015-419-geog\n", - " Co-occurring substance misuse and mental healt...\n", - " Disability\n", - " 8964\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/county-ua-deprivation-deciles-in-england-imd2019-419-geog\n", - " Co-occurring substance misuse and mental healt...\n", - " Disability\n", - " 17376\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/county-ua-pre-apr2019-deprivation-deciles-in-england-imd2015\n", - " Co-occurring substance misuse and mental healt...\n", - " Disability\n", - " 38862\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/district-ua-deprivation-deciles-in-england-imd2010\n", - " Co-occurring substance misuse and mental healt...\n", - " Disability\n", - " 2059\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/district-ua-deprivation-deciles-in-england-imd2015-419-geog\n", - " Co-occurring substance misuse and mental healt...\n", - " Disability\n", - " 2783\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/district-ua-deprivation-deciles-in-england-imd2019-419-geog\n", - " Co-occurring substance misuse and mental healt...\n", - " Disability\n", - " 11199\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/district-ua-pre-apr2019-deprivation-deciles-in-england-imd2015\n", - " Co-occurring substance misuse and mental healt...\n", - " Disability\n", - " 28329\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/ethnic-groups\n", - " Co-occurring substance misuse and mental healt...\n", - " Disability\n", - " 810\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/health-status\n", - " Co-occurring substance misuse and mental healt...\n", - " Disability\n", - " 270\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/lsoa11-deprivation-deciles-in-england-imd2015\n", - " Co-occurring substance misuse and mental healt...\n", - " Disability\n", - " 862\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/religion-8-categories\n", - " Co-occurring substance misuse and mental healt...\n", - " Disability\n", - " 810\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/sexuality-5-categories\n", - " Co-occurring substance misuse and mental healt...\n", - " Disability\n", - " 113\n", - " \n", - " \n", - " http://gss-data.org.uk/data/gss_data/disability/phe-co-occurring-substance-misuse-and-mental-health-issues/socioeconomic-group-18-64-yrs\n", - " Co-occurring substance misuse and mental healt...\n", - " Disability\n", - " 62889\n", + " http://gss-data.org.uk/graph/gss_data/trade/hmrc-overseas-trade-statistics-sitc/200001\n", + " http://gss-data.org.uk/data/gss_data/trade/hmrc-overseas-trade-statistics/hmrc-overseas-trade-statistics-sitc-catalog-entry\n", + " HMRC Overseas Trade Statistics - SITCv4\n", + " Trade\n", + " 3536928\n", " \n", " \n", "\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": [ "\n", " \n", - " \n", + " \n", " \n", " \n", - " \n", + " \n", " \n", " \n", - " \n", + " \n", " \n", " \n", " \n", " \n", " \n", " \n", - " \n", - " \n", - " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", - " \n", - " \n", + " \n", + " \n", " \n", " \n", "
TriplesSize
FamilyThemeDataset
DisabilityFamily Resources Survey: financial year 2017/182657CENSUS 2011 - LC3409EW Output Area (General health by tenure by age) - Nomis - Official Labour Market Statistics78368322
Statistics relating to Covid-19 and the immigration system3417
Ad hoc statistical release UK Sea Fisheries Statistics - Quantity (t)2611
Coronavirus Shielded Patient List Summary Totals, England by Clinical Commissioning Group and Local Authority37489
Weekly deaths - Occurrences20330
Weekly Deaths - Registrations74653
Deaths involving COVID-19 in Scotland53605
Death Occurrences by Local Authority and Health Board1444777
Death Registrations by Local Authority and Health Board1444777
Deaths involving COVID-19 in the care sector for England and Wales317055
Number of deaths in care homes notified to the Care Quality Commission, England515016
Online job advert estimates52876
Online price changes for high-demand products4621
Which occupations have the highest potential exposure to the coronavirus (COVID-19)?5071
Coronavirus COVID-19 in the UK - Cases by specimen date, by Nation, England: LTLA, UTLA, Region756311
COVID-19: number of outbreaks in care homes - management information87529
Weekly COVID-19 Statistical Data in Scotland3122
Testing for COVID-19 in adult care homes in Scotland7887
Notifications of deaths of residents related to COVID-19 in adult care homes249156
Summary data about Coronavirus COVID-19 and the response to it - Food Parcels1982
Survey of public views on the coronavirus (COVID-19)3164
Fuel poverty detailed tables - Household Characteristics - Aggregate Gap1633
Fuel poverty detailed tables - Household Characteristics - Average Gap1378
Fuel poverty detailed tables - Eligibility - Aggregate Gap154
Fuel poverty detailed tables - Eligibility - Average Gap154
Fuel poverty detailed tables - Energy Efficiency and Dwelling Characteristics - Aggregate Gap2824
Fuel poverty detailed tables - Energy Efficiency and Dwelling Characteristics - Average Gap2664
Fuel poverty detailed tables - Household Income - Aggregate Gap284
Fuel poverty detailed tables - Household Income - Average Gap266
Fuel poverty detailed tables - Fuel Payment Type - Aggregate Gap130
Fuel poverty detailed tables - Fuel Payment Type - Average Gap130
Fuel poverty supplementary tables - Energy Efficiency and Dwelling Characteristics - Median floor area1253
Fuel poverty supplementary tables - Energy Efficiency and Dwelling Characteristics - Median Fuel Poverty Energy Efficiency Rating (FPEER)1151
Fuel poverty supplementary tables - Energy Efficiency and Dwelling Characteristics - Median equivalised fuel costs1253
Fuel poverty supplementary tables - Energy Efficiency and Dwelling Characteristics - Median after housing costs (AHC), equivalised income1253
Fuel poverty supplementary tables - HFuel Payment Type - Median floor area130
Fuel poverty supplementary tables - Fuel Payment Type - Median Fuel Poverty Energy Efficiency Rating (FPEER)130
Fuel poverty supplementary tables - Fuel Payment Type - Median equivalised fuel costs130
Fuel poverty supplementary tables - Fuel Payment Type - Median after housing costs (AHC), equivalised income130
Fuel poverty supplementary tables - Housing Characteristics - Median floor area418
Fuel poverty supplementary tables - Housing Characteristics - Median Fuel Poverty Energy Efficiency Rating (FPEER)330
Fuel poverty supplementary tables - Housing Characteristics - Median equivalised fuel costs418
Fuel poverty supplementary tables - Housing Characteristics - Median after housing costs (AHC), equivalised income418
Fuel poverty supplementary tables - Housing Income - Median floor area154
Fuel poverty supplementary tables - Housing Income - Median Fuel Poverty Energy Efficiency Rating (FPEER)154
Fuel poverty supplementary tables - Housing Income - Median equivalised fuel costs154
Fuel poverty supplementary tables - Housing Income - Median after housing costs (AHC), equivalised income154
Electric vehicle charging device statistics: January 202171791
Cheapest tariffs by payment method: Typical domestic dual fuel customer (GB)4537
Retail price comparison by company and tariff type: Domestic (GB)3954
Warm Home Discount Scheme: Total expenditure by obligated suppliers590
Warm Home Discount Scheme: Percentage spend by nation78
Warm Home Discount Scheme: Distribution of expenditure by year343
Fuel used in generation (DUKES 5.3)7548
Liquid biofuels for transport consumption (ET 6.2 - quarterly)4995
Families in bed and breakfast accommodation for more than 6 weeks22724
Rough Sleeping Snapshot in England177652
Proportion of children under 5 years of age whose births have been registered with a civil authority, by age75
Publicly accessible green space as a proportion of urban area89
Electric prepayment meter statistics - Mean Consumption393000
Electric prepayment meter statistics - Median Consumption393000
Electric prepayment meter statistics by Post Code - Sales1533658
Electric prepayment meter statistics - Sales393000
Lower Super Output Areas (LSOA) electricity consumption3379883
Lower Super Output Areas (LSOA) gas consumption3251781
Sub-regional fuel poverty data - England541880
Journey times to key services by lower super output area: Employment Centres - JTS05012956043
Journey times to key services by lower super output area: Food Stores - JTS05073547224
Journey times to key services by lower super output area: Further Education - JTS05043547224
Journey times to key services by lower super output area: General Practices - JTS05053547224
Journey times to key services by lower super output area: Hospitals - JTS05063547224
Journey times to key services by lower super output area: Pharmacies - JTS0509591264
Journey times to key services by lower super output area: Primary Schools - JTS05023547224
Journey times to key services by lower super output area: Secondary Schools - JTS05033547224
Journey times to key services by lower super output area: Town Centre - JTS05083547224
Child Benefit small area statistics - Children receiving Child benefit4035338
Child Benefit small area statistics - Families in receipt of Child benefit1795428
English indices of deprivation13925915
Tracking economic and child income deprivation at neighbourhood level in England: Total Population (all ages)2858477
Children living in long-term workless households, by disability status (Table H)917Tracking economic and child income deprivation at neighbourhood level in England: Denominators9647243
A08: Labour market status of disabled people61872Tracking economic and child income deprivation at neighbourhood level in England: Numerators9709539
Co-occurring substance misuse and mental health issues: Country of birth732Tracking economic and child income deprivation at neighbourhood level in England: Ranks12862944
Co-occurring substance misuse and mental health issues: County & UA deprivation deciles in England (IMD2010)3503Tracking economic and child income deprivation at neighbourhood level in England: Scores12925257
Co-occurring substance misuse and mental health issues: County & UA deprivation deciles in England (IMD2015, 419 geog)8964Patients Registered at a GP Practice - GP17100420
Co-occurring substance misuse and mental health issues: County & UA deprivation deciles in England (IMD2019, 419 geog)17376Patients Registered at a GP Practice - CCG, STP, Comm Region428794
Co-occurring substance misuse and mental health issues: County & UA (pre Apr2019) deprivation deciles in England (IMD2015)38862Patients Registered at a GP Practice - PCN2926554
Co-occurring substance misuse and mental health issues: District & UA deprivation deciles in England (IMD2010)2059Population estimates by Output Area Geographies, Gender and Age, England and Wales49092727
Co-occurring substance misuse and mental health issues: District & UA deprivation deciles in England (IMD2015, 419 geog)2783Scottish Index of Multiple Deprivation - Indicators2457410
Co-occurring substance misuse and mental health issues: District & UA deprivation deciles in England (IMD2019, 419 geog)11199Scottish Index of Multiple Deprivation - Ranks502321
Co-occurring substance misuse and mental health issues: District & UA (pre Apr2019) deprivation deciles in England (IMD2015)28329Regional trade in goods statistics disaggregated by smaller geographical areas: 2019 Business Count107228
Co-occurring substance misuse and mental health issues: Ethnic groups810Regional trade in goods statistics disaggregated by smaller geographical areas: 2019: Statistical value (£ million)107628
Co-occurring substance misuse and mental health issues: Health status270UK trade in goods by business characteristics 2019 - data tables29632
Co-occurring substance misuse and mental health issues: LSOA11 deprivation deciles in England (IMD2015)862Foreign direct investment involving UK companies (directional)406551
Co-occurring substance misuse and mental health issues: Religion - 8 categories810UK total trade: all countries, non-seasonally adjusted520626
Co-occurring substance misuse and mental health issues: Sexuality - 5 categories113UK trade in goods by industry, country and commodity - Imports & Exports1636251
Co-occurring substance misuse and mental health issues: Socioeconomic group (18-64 yrs)62889Annual Business Survey exporters and importers13585
Homelessness in Scotland: Applications: Main reason for making an application for homelenessness to a Local Authority1657Balance of paymentsBalance of payments37343
Homelessness in Scotland: Applications: Reasons for failing to maintain accommodation prior to application1062Trade in goods: all countries, seasonally adjusted1333936
Homelessness in Scotland: Applications: Support need identified for those homeless (or threatened with homelessness) households807UK trade in services by industry, country and service type, Imports & Exports286035
Homelessness in Scotland: Identified Support Needs of Homeless Households87UK trade time series - Chained Value Measures2578968
Homelessness in Scotland: Reason(s) for failing to maintain accommodation182EnergyRenewable electricity capacity and generation (ET 6.1 - quarterly)59308
HealthReported drinking and driving (RAS51)2276Actual ILR Income53548
Census of drug and alcohol treatment services in Northern Ireland 20175912Generation and supply of electricity in Scotland, England, Wales, Northern Ireland and England, 2004 to 201910216
Alcohol Duty264090Generation of electricity by fuel in Scotland, England, Wales, Northern Ireland and England, 2004 to 201925354
Alcohol Affordability1611Final UK greenhouse gas emissions national statistics: 1990 to 2019163176
Alcohol Specific Deaths439Renewables obligation: certificates and generation67680
Household Expenditure Alcohol716Sub-regional Feed-in Tariffs confirmed on the CFR statistics239520
Prescription Items Community1946Gross Domestic Product (GDP)GDP – data tables - National Accounts aggregates (A2)23548
Prescription Items Region16545GDP – data tables - Change in inventories at current prices and chained volume measures (G1, G2)28407
Alcohol-Specific Deaths 2007-20171861GDP – data tables - Exports and Imports of goods and services at current prices and chained volume measures (H1, H2)53994
Alcohol-specific deaths in the UK34711GDP – data tables - Gross value added chained volume measures at basic prices, by category of output (B1 & B2)32617
Local Alcohol Profiles for England: August 2019 data update1271161GDP – data tables - Household final consumption by purpose and goods and services at Current Prices & Chained Volume Measures (E1, E2, E3, E4)75216
HousingEmpty properties and second homes17255GDP – data tables - Gross fixed capital formation by sector and type of asset at current prices and chained volume measures (F1, F2)40956
Housing Statistics for Scotland - Public sector vacant stock234891GDP – data tables - Gross domestic product: by category of income at current prices (D)36454
Stock by tenure4023International tradeImports and Exports of services by country, by modes of supply11625
Council tax dwellings832568International trade in services by subnational areas of the UK91893
Dwelling Stock Estimates15283International trade in services248308
Social housing vacancies2991203Towns & High StreetsEmployment estimates for towns for 20198346
MigrationNational Insurance number allocations to adult overseas nationals to March 201853874Employment for towns by broad industry groups, Business Register and Employment Survey (BRES), 2018608487
Immigration statistics, October to December 2017: data tables second edition279852Towns - local units counts by size bands, Inter-Departmental Business Register (IDBR), 2015 to 2018189813
Mid-Year Population Estimates194613TradeSectors Economic Estimates 2018: Trade in services42442
Local area migration indicators, UK153643Alcohol Bulletin - Clearances63855
Long-term international migration 2.07, age and sex, UK and England and Wales35264Alcohol Bulletin - Duty Receipts12255
Long-term international migration 2.01a, citizenship, UK and England and Wales20269Alcohol Bulletin - Production5976
Long-term international migration 2.02, country of last or next residence, UK and England and Wales17579HMRC Overseas Trade Statistics - Combined Nomenclature 85267346
Long-term international migration 2.05, usual occupation prior to migration, UK and England and Wales10954HMRC Overseas Trade Statistics - Combined Nomenclature 85267286
International Passenger Survey 4.01, citizenship group by sex by age by country of last or next residence2661663HMRC Overseas Trade Statistics - SITCv43536988
International Passenger Survey 4.02, main reason for migration by citizenship13460HMRC Overseas Trade Statistics - SITCv43536928
International Passenger Survey 4.04, area of destination or origin within the UK by citizenship63279HMRC Regional Trade Statistics12071610
Long-term international migration 2.04, main reason for migration, UK and England and Wales8769HMRC Regional Trade Statistics2057651
Long-term international migration 2.06, area of destination or origin within the UK13223HMRC Regional Trade Statistics2047551
Migration between Scotland and Overseas219560HMRC Regional Trade Statistics2080031
Asylum applications and initial decisions for main applicants, by country of nationality2492510HMRC Regional Trade Statistics2072331
Asylum applications from main applicants and dependants, by age, sex and country of nationality719126HMRC Regional Trade Statistics2077851
Asylum seekers in receipt of Section 95 support, by local authority, as at end of quarter676899HMRC Regional Trade Statistics2056171
Refugees (and others) resettled, including dependants, by country of nationality4508HMRC Regional Trade Statistics2071231
Arrivals, and requests for transfer into the UK under the Dublin Regulation, by article and country of transfer96869HMRC Regional Trade Statistics2056731
TradeRegional trade in goods statistics disaggregated by smaller geographical areas: 2017210513HMRC Regional Trade Statistics2053391
HMRC Overseas Trade Statistics13543677Regional trade statistics interactive analysis: second quarter 20202179035
UK Regional Trade Statistics (RTS40633124International exports of services from subnational areas of the UK25578
UK Trade in Goods by Business Characteristics - Experimental Statistics8903The Pink Book, Trade in Services53676
Foreign direct investment involving UK companies224702Quarterly country and regional GDP246972
International trade in services191582Regional Gross Domestic Product city regions - Chained Volume Measures annual growth rates1104169
Regionalised estimates of UK service exports9596Regionalised estimates of UK service exports9580
Trade in goods: country-by-commodity imports and exports147999181UK Economic Accounts: balance of payments - Capital Account83025
Trade in goods: all countries, seasonally adjusted1064823UK Economic Accounts: balance of payments - Current Account - Primary Income107689
UK total trade: all countries, non-seasonally adjusted442049UK Economic Accounts: balance of payments - Current Account - Secondary Income59545
UK trade in goods by industry, country and commodity, imports and exports4837341UK Economic Accounts: balance of payments - Current Account - Summary of balance of payments36641
UK trade in services: service type by partner country, non-seasonally adjusted1216327UK Economic Accounts: balance of payments - Current Account - Trade in goods and services155874
Annual Business Survey importers and exporters24402UK Economic Accounts: balance of payments - Current Account - Transactions with non-EU countries466633
Balance of payments10588UK Economic Accounts: balance of payments - Current Account - Transactions with the EU and EMU93392
UK trade in goods by classification of product by activity time series5949765UK trade in goods, CPA(08)1131769
UK trade time series4983049UK trade in services by business characteristics41653
ONS BoP Individual Country Data1777303UK trade in services: service type by partner country, non-seasonally adjusted1910023
ONS Pink Book Chapter 3150770UK trade in goods by classification of product by activity time series6611963
" @@ -1929,7 +1196,7 @@ "" ] }, - "execution_count": 5, + "execution_count": 54, "metadata": {}, "output_type": "execute_result" } @@ -1937,19 +1204,19 @@ "source": [ "from urllib.parse import urlencode\n", "def gss_url(uri):\n", - " return 'http://gss-data.org.uk/resource?' + urlencode({\n", + " return 'http://staging.gss-data.org.uk/cube/explore?' + urlencode({\n", " 'uri': uri\n", " })\n", "\n", - "table['Dataset'] = table.apply(lambda x: f'{x.Label}', axis=1)\n", + "table['Dataset'] = table.apply(lambda x: f'{x.Label}', axis=1)\n", "table.drop(columns=['Label'], inplace=True)\n", - "table = table[['Dataset', 'Family', 'Triples']]\n", - "table = table.sort_values(by=['Family', 'Dataset'])\n", - "table = table.set_index(['Family', 'Dataset'])\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))" + "HTML(table.to_html(escape=False, index=True, justify='left'))" ] }, { @@ -1976,7 +1243,7 @@ "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", - "version": "3.7.5" + "version": "3.8.9" } }, "nbformat": 4,