variables

This table contains all the variables of all the datasets we have at Our World In Data. Note that this includes only the information about the variables like name and default display settings, not the data itself.

Data license: CC-BY

83 rows where datasetId = 4905 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: description, createdAt, updatedAt, createdAt (date), updatedAt (date)

id ▲ name unit description createdAt updatedAt code coverage timespan datasetId sourceId shortUnit display columnOrder originalMetadata grapherConfigAdmin shortName catalogPath dimensions schemaVersion processingLevel processingLog titlePublic titleVariant attributionShort attribution descriptionShort descriptionFromProducer descriptionKey descriptionProcessing licenses license grapherConfigETL type sort dataChecksum metadataChecksum
110115 Real GDP per capita     2020-01-21 23:03:15 2023-07-06 14:28:18       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "constant 2013 GBP",
    "shortUnit": "\u00a3",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
110114 Current account deficit including estimated non-monetary bullion flows prior to 1946 (% of nominal GDP)   Using conformable measure of nominal GDP 2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "% of nominal GDP"
}
 0           1                                  
110113 Current account deficit including estimated non-monetary bullion flows prior to 1946     2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "\u00a3"
}
 0           1                                  
110112 Current account (% of nominal GDP)   Using conformable measure of nominal GDP 2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "% of nominal GDP"
}
 0           1                                  
110111 Current account   GB only before 1816 2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "\u00a3"
}
 0           1                                  
110110 Trade deficit (% of nominal GDP)   Using conformable measure of nominal GDP 2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "% of nominal GDP"
}
 0           1                                  
110109 Trade deficit     2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "\u00a3"
}
 0           1                                  
110108 Central Government Gross Debt (market value)   Includes estimated capital value of terminable annuities 2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "Financial year end, market value \u00a3"
}
 0           1                                  
110107 Central Government Gross Debt (nominal par value)   Includes estimated capital value of terminable annuities 2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "Financial year end, nominal par value \u00a3"
}
 0           1                                  
110106 UK Public sector debt (% of nominal GDP: measure 2)   Based on GB funded debt and GB GDP before 1817 2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "% of nominal GDP: measure 2"
}
 0           1                                  
110105 UK Public sector debt (% of nominal GDP: measure 1)   Using GB+Ireland GDP before 1920 2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "% of nominal GDP: measure 1"
}
 0           1                                  
110104 UK Public sector debt (calendar year end)   Excluding public sector banks. Includes estimated capital value of terminable annuities 2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "Calendar Year end nominal par value outstanding, \u00a3"
}
 0           1                                  
110103 Public Sector Net Lending(+)/Borrowing(-) (% of nominal GDP)   Using GDP based on political boundaries 2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "% of nominal GDP"
}
 0           1                                  
110102 Public Sector Net Lending(+)/Borrowing(-) (calendar year total)   Excluding the temporary effects of financial interventions. Central government only prior to 1900. 2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "Calendar year total, \u00a3"
}
 0           1                                  
110101 Public Sector Total Receipts (% of nominal GDP)   Using GB+NI nominal GDP 2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "% of nominal GDP"
}
 0           1                                  
110100 Public Sector Total Receipts (calendar year total)   Excluding the temporary effects of financial interventions. 2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "Calendar year total, \u00a3"
}
 0           1                                  
110099 Public sector Total Managed Expenditure (% of nominal GDP)   Using GB+NI nominal GDP 2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "% of nominal GDP"
}
 0           1                                  
110098 Public sector Total Managed Expenditure (calendar year total)   Excluding the temporary effects of financial interventions. 2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "Calendar year total, \u00a3"
}
 0           1                                  
110097 Broad Money   Spliced break-adjusted broad money measure based on M3/M4/M4x 2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "Year end, \u00a3"
}
 0           1                                  
110096 M1   Spliced break-adjusted stock 2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "Year end, \u00a3"
}
 0           1                                  
110095 Monetary base   M0 2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "Year end, \u00a3"
}
 0           1                                  
110094 Notes and coin in circulation     2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "Year end, \u00a3"
}
 0           1                                  
110093 Coin in circulation outside the Bank of England     2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "Year end, \u00a3"
}
 0           1                                  
110092 Bank of England Balance sheet, using consolidated balance sheet   Using consolidated balance sheet and GB+NI nominal GDP 2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "% of nominal GDP"
}
 0           1                                  
110091 Bank of England Balance sheet, using unconsolidated balance sheet   Using unconsolidated balance sheet and GB+NI nominal GDP 2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "% of nominal GDP"
}
 0           1                                  
110090 Secured credit   Break-adjusted stock of bank and building society lending secured on dwellings, excluding impact of securitisations 2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "Year end, \u00a3"
}
 0           1                                  
110089 Credit   Break-adjusted stock of bank and building society lending, M4Lx 2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "Year end, \u00a3"
}
 0           1                                  
110088 House price index   NB uses building costs as a rough proxy prior to 1895 2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "Calendar year average, Jan 2015 =100"
}
 0           1                                  
110087 Real ERI     2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "Calendar year average, 1913=100"
}
 0           1                                  
110086 Nominal ERI     2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "Calendar year average, 1913=100"
}
 0           1                                  
110085 Real $/£ exchange rate     2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "Calendar year average, 1913=100"
}
 0           1                                  
110084 $/£ exchange rate     2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "Calendar year average"
}
 0           1                                  
110083 Share prices     2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "April 1962=100, Year end"
}
 0           1                                  
110082 Corporate bond yields     2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "%, calendar year average"
}
 0           1                                  
110081 Corporate borrowing rate from banks   NB Possible break in the mean of around +1% in 1977 reflecting a shift from the rate charged to blue chip companies to one covering the whole of the PNFC sector. 2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "%, calendar year average"
}
 0           1                                  
110080 Mortgage rates     2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "%, calendar year average"
}
 0           1                                  
110079 Consols / long-term government bond yields     2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "%, calendar year average"
}
 0           1                                  
110078 10 year/medium-term government bond yields     2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "%, calendar year average"
}
 0           1                                  
110077 Bank Rate (% calendar year average)     2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "% calendar year average"
}
 0           1                                  
110076 Bank Rate (% end period)     2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "% end period"
}
 0           1                                  
110075 Wholesale/producer price index     2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "2010=100"
}
 0           1                                  
110074 Real consumption wages     2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "1900=100"
}
 0           1                                  
110073 Consumer price inflation     2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "%"
}
 0           1                                  
110072 Consumer price index     2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "2015=100"
}
 0           1                                  
110071 Earnings per head     2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "Average weekly earnings, \u00a3"
}
 0           1                                  
110070 $ Oil prices     2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "$ per barrel"
}
 0           1                                  
110069 Terms of Trade     2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "2013=100"
}
 0           1                                  
110068 Import prices     2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "2013=100"
}
 0           1                                  
110067 Export prices     2020-01-21 23:03:15 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "2013=100"
}
 0           1                                  
110018 GDP deflator at market prices     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "2013=100"
}
 0           1                                  
110017 Labour share, whole economy excluding rents     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "share of GDP excluding rents"
}
 0           1                                  
110016 Labour productivity (real GDP per hour)     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "2013 prices"
}
 0           1                                  
110015 Labour productivity (real GDP per head)     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "2013 prices"
}
 0           1                                  
110014 TFP growth     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "%"
}
 0           1                                  
110013 Capital Services, whole economy     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "2013 prices"
}
 0           1                                  
110012 Average weekly hours worked     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "hours"
}
 0           1                                  
110011 Unemployment rate   LFS consistent measure, rough GB estimates prior to 1855. 2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "%"
}
 0           1                                  
110010 Employment   Break-adjusted measure of employment. 2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{}
 0           1                                  
110009 Population (England)     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{}
 0           1                                  
110008 Population (GB+NI)   GB+NI population, using Broadberry et al (2015) GB estimates 2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{}
 0           1                                  
110007 Nominal UK GDP at market prices, based on political definition   Nominal UK GDP at market prices based on the political definition of the UK: GB before 1801, GB+I 1801-1920, GB+NI 1921-present 2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "\u00a3"
}
 0           1                                  
110006 Nominal UK GDP at market prices, constant border UK (GB + NI)     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "\u00a3"
}
 0           1                                  
110005 Nominal GDP of England at market prices     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "\u00a3"
}
 0           1                                  
110004 Import volumes     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "Chained Volume measure, 2013 prices.  "
}
 0           1                                  
110003 Export volumes     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "Chained Volume measure, 2013 prices. "
}
 0           1                                  
110002 Real government consumption of goods and services     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "Chained Volume measure, 2013 prices"
}
 0           1                                  
110001 Stockbuilding contribution     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "pp contribution to GDP(E)"
}
 0           1                                  
110000 Real investment     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "Chained Volume measure, 2013 prices"
}
 0           1                                  
109999 Real consumption     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "Chained Volume measure, 2013 prices"
}
 0           1                                  
109998 Real UK gross disposable national income at market prices, constant border estimate     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "Chained Volume measure, 2013 prices.  Nominal GDI divided by private and public consumption deflator"
}
 0           1                                  
109997 HP-filter of log of real composite estimate of English and UK real GDP at factor cost     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "approx. % difference from trend"
}
 0           1                                  
109996 Growth rate of composite estimate of English and (geographically-consistent) UK real GDP at factor cost     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "%"
}
 0           1                                  
109995 Composite estimate of English and (geographically-consistent) UK real GDP at factor cost     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "2013=100"
}
 0           1                                  
109994 Growth rate of real GDP of England at factor cost     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "%"
}
 0           1                                  
109993 Real GDP of England at factor cost     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "Chained Volume measure, 2013 prices"
}
 0           1                                  
109992 Growth rate of real GDP of England at market prices     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "%"
}
 0           1                                  
109991 Real GDP of England at market prices     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "Chained Volume measure, 2013 prices"
}
 0           1                                  
109990 Growth rate of index of real UK GDP at market prices cost - based on changing political boundaries     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "%"
}
 0           1                                  
109989 Index of real UK GDP at market prices cost - based on changing political boundaries     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "GB before 1801, GB+Ireland 1801-1920, GB + Northern Ireland after 1920.  Indexed to 100 in 1920"
}
 0           1                                  
109988 Growth rate of real UK GDP at factor cost, geographically-consistent estimate based on post-1922 borders     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "%"
}
 0           1                                  
109987 Real UK GDP at factor cost, geographically-consistent estimate based on post-1922 borders     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "Chained Volume measure, 2013 prices"
}
 0           1                                  
109986 Growth rate of real UK GDP at market prices, geographically-consistent estimate based on post-1922 borders     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "%"
}
 0           1                                  
109985 Real UK GDP at market prices, geographically-consistent estimate based on post-1922 borders     2020-01-21 16:54:55 2023-06-15 05:05:42       A Millennium of Macroeconomic Data - Bank of England (2016) 4905 A Millennium of Macroeconomic Data - Bank of England 17636   
{
    "unit": "Chained Volume measure, 2013 prices"
}
 0           1                                  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "variables" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"name" VARCHAR(750) NULL  ,
	"unit" VARCHAR(255) NOT NULL  ,
	"description" TEXT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL  ,
	"code" VARCHAR(255) NULL  ,
	"coverage" VARCHAR(255) NOT NULL  ,
	"timespan" VARCHAR(255) NOT NULL  ,
	"datasetId" INTEGER NOT NULL  ,
	"sourceId" INTEGER NULL  ,
	"shortUnit" VARCHAR(255) NULL  ,
	"display" TEXT NOT NULL  ,
	"columnOrder" INTEGER NOT NULL DEFAULT '0' ,
	"originalMetadata" TEXT NULL  ,
	"grapherConfigAdmin" TEXT NULL  ,
	"shortName" VARCHAR(255) NULL  ,
	"catalogPath" VARCHAR(767) NULL  ,
	"dimensions" TEXT NULL  ,
	"schemaVersion" INTEGER NOT NULL DEFAULT '1' ,
	"processingLevel" VARCHAR(30) NULL  ,
	"processingLog" TEXT NULL  ,
	"titlePublic" VARCHAR(512) NULL  ,
	"titleVariant" VARCHAR(255) NULL  ,
	"attributionShort" VARCHAR(512) NULL  ,
	"attribution" TEXT NULL  ,
	"descriptionShort" TEXT NULL  ,
	"descriptionFromProducer" TEXT NULL  ,
	"descriptionKey" TEXT NULL  ,
	"descriptionProcessing" TEXT NULL  ,
	"licenses" TEXT NULL  ,
	"license" TEXT NULL  ,
	"grapherConfigETL" TEXT NULL  ,
	"type" TEXT NULL  ,
	"sort" TEXT NULL  ,
	"dataChecksum" VARCHAR(64) NULL  ,
	"metadataChecksum" VARCHAR(64) NULL,
	FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT,
	FOREIGN KEY("sourceId") REFERENCES "sources" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE UNIQUE INDEX "idx_catalogPath" ON "variables" ("catalogPath");
CREATE UNIQUE INDEX "unique_short_name_per_dataset" ON "variables" ("shortName", "datasetId");
CREATE UNIQUE INDEX "variables_code_fk_dst_id_7bde8c2a_uniq" ON "variables" ("code", "datasetId");
CREATE INDEX "variables_datasetId_50a98bfd_fk_datasets_id" ON "variables" ("datasetId");
CREATE UNIQUE INDEX "variables_name_fk_dst_id_f7453c33_uniq" ON "variables" ("name", "datasetId");
CREATE INDEX "variables_sourceId_31fce80a_fk_sources_id" ON "variables" ("sourceId");