Recessions in the United Kingdom SQL Database Dump for MySQL, Microsoft Access and Oracle

Preview
CREATE TABLE `recessions` (
  `id` int(11) NOT NULL auto_increment,
  `Name` varchar(255) NOT NULL,
  `Dates` varchar(255) NOT NULL,
  `Duration` varchar(255) NOT NULL,
  `GDP_reduction` varchar(255) NOT NULL,
  `Causes` varchar(255) NOT NULL,
  `Other_data` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

INSERT INTO `recessions` VALUES (1,'Earlier recessions','pre-1919','','(To be added)');
INSERT INTO `recessions` VALUES (2,'1919-21 depression','1919-21','~3 years','10.9% 1919\n6.0% 1920\n8.1% 1921','The end of World War I','Deflation ~10% in 1921, and ~14% in 1922.');
INSERT INTO `recessions` VALUES (3,'Great Depression','1930-1','~2years','0.7% 1930\n5.1% 1931','US Depression. Reducing demand for UK exports, also high interest rate defending the gold standard.','UK came off gold standard Sept 1931. 3-5% deflation pa. UK much less affected than US. Took 16 quarters for GDP to recover to that at start of recession after a \'double dip\'.');
INSERT INTO `recessions` VALUES (4,'Mid 1970s recession','1973-5','2 years\n(6 out of 9 Qtr)','3.9% \n3.37%','1973 oil crisis','Took 14 quarters for GDP to recover to that at start of recession after a \'double dip\'.');
INSERT INTO `recessions` VALUES (5,'Early 1980s recession','1980-2','~2 years\n(6 - 7 Qtr)','5.8%\n5.9%','Cause - possibly monetarist government policies to reduce inflationÂ ? See 1979-1983','Company earnings decline 35%. Unemployment rises 124% from 5.3% of the working population in Aug 1979 to 11.9% in 1984 Took 13 quarters for GDP to recover to that at start of 1980 Took 18 quarters for GDP to recover to that at start of recession.');
INSERT INTO `recessions` VALUES (6,'Early 1990s recession','1990-2','~2 years\n(5 Qtr)','2.5%','US savings and loan crisis leading to the Early 1990s recession.','Company earnings decline 25%. Peak budget deficit ~8% of GDP. Unemployment rises 55% from 6.9% of the working population in 1990 to 10.7% in 1993 Took 13 quarters for GDP to recover to that at start of recession');
INSERT INTO `recessions` VALUES (7,'Late-2000s recession','2008-9','~1.5 years\n(6 Qtr)','6.0%\n6.03%\n6.4%\n7.1%','Late-2000s financial crisis','Manufacturing output down 7% by end 2008.\nIt was the deepest recession since the war. It has affected many sectors including banks and investment firms, and seen many well known and established businesses fold. Britain has notably struggled to come out of the latest recession, wi
To view the full dump, please login
SQL database dumps

Recessions in the United Kingdom

Navigation

Popular databases
