Skip to comments.
Recent Years' Federal Government Economic Data
Federal government agencies ^
| Nov. 2, 2015
| Free Republic
Posted on 11/02/2015 5:04:29 PM PST by WilliamofCarmichael
This updates years 2007 - 2015 of an earlier post of Federal Government Economic Data covering several decades. Both include links to the government agencies' tables. Updates include additional foreign-born data and annualized data for 2015 using 3rd quarter data.
TOPICS: Reference
KEYWORDS: debt; economy; gdp; labor
Skip to table columns.The original table (here) and this update covering years 2007 to current year show critical economic data from the federal government itself. The tables can be used to compare administrations over the decades.
Labor force statistics native/foreign born; noninstitutional population native/foreign born; labor force participation rate native/foreign born; unemployment rate native/foreign born; household annual income; federal debt; annual federal debt as a percentage of GDP; real GDP comparison of year-to-year percentages and dollars; GDP vs. deficit; real GDP annual changes; U-6 unemployment rate; personal consumption expenditures percentage of real gross domestic product; contributions to percent change in real gross domestic product from defense and non-defense spending, percentages and dollar amounts; Social Security's Disability awards; federal receipts, outlays, and surpluses or deficits. If the data are available from the federal government I should be able to easily add new columns to the table.
Notes.
- the columns hyperlink directly to notes at the end and
- the notes contain links directly to the original data in
- the Bureau of Labor Statistics,
- the Bureau of Economic Analysis,
- the United States Census Bureau,
- the Treasury Department,
- the National Bureau of Economic Research, Inc. (considered an official source for recessions authority),
- the Office of Management and Budget,
- the Social Security Administration (SSA) and
- a couple of columns that I developed using the federal data.
- I am hoping to keep the table current quarterly with annualized data through election 2016.
|
You hover the column headings in the table to see the description and you hover column data to see if there are additional data in columns. All data are from BLS, BEA, U.S. Census, OMB, SSA, and additional federal sources. |
Click to jump to the table. The numbered column headings are for:
- 2. Civilian noninstitutional population [thousands] beginning in 2007 hover for Civilian noninstitutional population foreign born
- 3. Civilian labor force [thousands]. beginning in 2007 hover for Civilian labor force foreign born
- 4. Civilian labor force participation rate; beginning in 2007 hover for Civilian labor force participation rate foreign born or see Column PR (if present) beginning in 2007
- 5. Employed [thousands]
- 6. Employment-population ratio
- 7. Employed full time (persons who usually work 35 hours or more) [thousands]
- 8. Employed part time (persons who usually work less than 35 hours. Hover Col 7. to access if not present
- 9. Unemployed [thousands]
- 10. Unemployed looking for full-time work [thousands]
- 11. Unemployment rate
- 12. Unemployment rate of the full-time labor force
- 13. Not in labor force; hover for foreign born not in labor force [thousands]
Click to jump to the table. The rest of the columns are:
- pop. Population
- labor. (Unadj) Employment Level - Native born; hover for (Unadj) Employment Level - foreign born;
- labor(Unadj) Employment Level - Foreign born;
- PR (Unadj) Labor Force Participation Rate - Foreign born
- UR (Unadj) Unemployment Rate - Foreign born;
- income. Median income;
- Recession. Recessions;
- GDP-$ (billions), GDP in 2009 dollars;
- DEBT (federal in billions), the current fiscal year Oct.-Sept. was adopted in 1977;
- %GDP percent DEBT of nominal GDP hover GDP-$ to see nominal values that are used to compute DEBT percent of nominal GDP;
- GDP. Percent Change From Preceding Period in Real Gross Domestic Product (annual rates) 2009 dollars, see GDP-$;
- PCE. Personal consumption expenditures portion of the Real Gross Domestic Product (annual rates) 2009 dollars percentage change;
- Def% National Defense portion of the Real Gross Domestic Product (annual rates) 2009 dollars percentage change;
- Def$ National Defense portion of the Real Gross Domestic Product (annual rates) 2009 dollars;
- NDef% NonNational Defense portion of the Real Gross Domestic Product (annual rates) 2009 dollars percentage change;
- NDef$ NonNational Defense portion of the Real Gross Domestic Product (annual rates) 2009 dollars;
- U-6. U-6 unemployment rate (hover U-6. for U-2 rate);
- SSDI Selected Data from Social Security's Disability Program, number of awards (could be some duplications), hover for number applying for SSDI;
- Series and
Permits New Privately Owned Housing Units Authorized by Building Permits (thousands) in Permit-Issuing Places (Series) |
- Recpts SUMMARY OF RECEIPTS,
- Out OUTLAYS, and
- +/- SURPLUSES OR DEFICITS (â) AS PERCENTAGES OF GDP;
Year |
2007 |
2008 |
2009 |
2010 |
2011 |
2012 |
2013 |
2014 |
2015 |
Year |
2. |
232937 |
234825 |
236739 |
238712 |
240431 |
244169 |
246564 |
248843 |
251099 |
2. |
3. |
153645 |
154723 |
153591 |
153803 |
153995 |
155450 |
154989 |
156258 |
156962 |
3. |
4. |
66.0 |
65.9 |
64.9 |
64.4 |
64.0 |
63.7 |
62.9 |
62.8 |
62.5 |
4. |
5. |
146272 |
144091 |
138368 |
139155 |
140669 |
143303 |
144205 |
147344 |
148892 |
5. |
6. |
62.8 |
61.4 |
58.4 |
58.3 |
58.5 |
58.7 |
58.5 |
59.2 |
59.3 |
6. |
7. |
121621 |
118281 |
110906 |
111655 |
113269 |
115610 |
116826 |
119707 |
121817 |
7. |
8. |
24727 |
25836 |
27423 |
27444 |
27355 |
27684 |
27378 |
27657 |
27050 |
8. |
9. |
7374 |
10633 |
15223 |
14649 |
13326 |
12146 |
10784 |
8914 |
8070 |
9. |
10. |
6009 |
9009 |
13444 |
12867 |
11521 |
10338 |
9171 |
7478 |
6680 |
10. |
11. |
4.8 |
6.9 |
9.9 |
9.5 |
8.7 |
7.8 |
7.0 |
5.7 |
5.1 |
11. |
12. |
4.7 |
7.1 |
10.8 |
10.3 |
9.2 |
8.2 |
7.3 |
5.9 |
5.2 |
12. |
13. |
79291 |
80102 |
83148 |
84908 |
86436 |
88719 |
91575 |
92584 |
94137 |
13. |
pop. |
301230 |
304090 |
306770 |
309330 |
311590 |
313910 |
316160 |
319470 |
321363 |
pop. |
labor |
labor |
123524 |
22810 |
121211 |
22138 |
116663 |
21290 |
117006 |
22153 |
118033 |
22647 |
119844 |
23216 |
120636 |
23787 |
122300 |
24890 |
124052 |
24928 |
labor |
labor |
PR |
68.2 |
67.9 |
67.2 |
67.8 |
67.4 |
66.4 |
66.1 |
65.9 |
64.8 |
PR |
UR |
4.7 |
7.6 |
11.0 |
10.6 |
8.8 |
8.0 |
6.5 |
5.3 |
4.6 |
UR |
income |
57,357 |
55,313 |
54,925 |
53,507 |
52,690 |
52,605 |
52,789 |
53,657 |
N |
income |
Cont'd
Year |
2007 |
2008 |
2009 |
2010 |
2011 |
2012 |
2013 |
2014 |
2015 |
Year |
GDP-$ |
14,873.70 |
14,830.40 |
14,418.70 |
14,783.80 |
15,020.60 |
15,354.60 |
15,583.30 |
15,961.70 |
16,394.20 |
GDP-$ |
DEBT |
%GDP |
9,007.65 |
62.22% |
10,024.72 |
68.11% |
11,909.83 |
82.60% |
13,561.62 |
90.63% |
14,790.34 |
95.31% |
16,066.24 |
99.40% |
16,738.18 |
99.82% |
17,824.07 |
102.32% |
18,150.60 |
100.60% |
DEBT |
%GDP |
GDP |
1.8 |
-0.3 |
-2.8 |
2.5 |
1.6 |
2.2 |
1.5 |
2.4 |
1.5 |
GDP |
PCE |
1.5 |
-0.23 |
-1.08 |
1.32 |
1.55 |
1.01 |
1.16 |
1.84 |
2.19 |
PCE |
Def% |
0.11 |
0.36 |
0.27 |
0.18 |
-0.13 |
-0.18 |
-0.34 |
-0.18 |
-0.06 |
Def% |
Def$ |
695.6 |
748.1 |
788.3 |
813.5 |
795 |
768.2 |
716.6 |
689.1 |
678.4 |
Def$ |
NDef% |
0.01 |
0.14 |
0.17 |
0.19 |
-0.11 |
0.03 |
-0.12 |
0 |
0.08 |
NDef% |
NDef$ |
383.1 |
404.2 |
429.4 |
457.1 |
441.4 |
445.3 |
427.5 |
427.0 |
433.2 |
NDef$ |
U-6 |
8.8 |
13.6 |
17.1 |
16.6 |
15.2 |
14.4 |
13.1 |
11.2 |
10.0 |
U-6 |
SSDI |
823,106 |
895,011 |
985,940 |
1,052,551 |
1,025,003 |
979,973 |
884,894 |
810,973 |
588,756 |
SSDI |
Rcpts |
Out |
+/- |
17.9 |
19.1 |
-1.1 |
17.1 |
20.2 |
-3.1 |
14.6 |
24.4 |
-9.8 |
14.6 |
23.4 |
-8.7 |
15.0 |
23.4 |
-8.5 |
15.3 |
22.1 |
-6.8 |
16.7 |
20.8 |
-4.1 |
17.5 |
20.3 |
-2.8 |
17.7 |
20.9 |
-3.2 |
Rcpts |
Out |
+/- |
All values are from annualized yearly/quarterly/monthly sources. The quarterly/monthly values displayed are for the last available quarter/month of the year. The federal government constantly revises values especially for recent years.
Footnotes
N Not available.
Z Represents or rounds to zero.
Column headings 2 to 13 |
Bureau of Labor Statistics |
See above or BLS for list of tables. These tables were obtained here: go to Bureau of Labor Statistics (BLS) Labor Force Statistics from the Current Population Survey (CPS). Requires Java. Make your selections. I asked for quarterly data and took the fourth (or last available) quarter annualized data from each table and combined them into the table above. |
See labor below for Civilian noninstitutional population foreign born source (Col 2.). |
See labor below for Civilian labor force foreign born source (Col 3.). |
See labor below for foreign born not in labor force source (Col 13.). |
;
labor |
Bureau of Labor Statistics |
- Labor force domestic born;
- Labor force foreign born (hover labor domestic born if column is missing);
Source:
- to find the tables go here
- Data Retrieval: Labor Force Statistics (CPS),
- HOUSEHOLD DATA Table A-7, Employment status of the civilian population by nativity and sex, not seasonally adjusted [Numbers in thousands]
- Employment status, and nativity;
- then check desired data
- scroll down to "Retrieve Data".
|
PR |
Bureau of Labor Statistics |
Civilian labor force participation rate, foreign born. See labor above for source. |
UR |
Bureau of Labor Statistics |
Civilian labor force unemployment rate, foreign born. See labor above for source. |
income |
United States Census Bureau |
Median income go here.
- Scroll down and choose
- Income and Poverty in the United States: 2014 September 2015
- then scroll down and choose "Households by Total Money Income, Race, and Hispanic Origin of Householder: 1967 to 2014 [PDF - 459k]";
- see ALL RACES, median income
|
GDP |
Bureau of Economic Analysis |
Percent Change From Preceding Period in Real Gross Domestic Product (annual rates) 2009 dollars, see GDP-$; seePCE |
- Table 1.1.2. Contributions to Percent Change in Real Gross Domestic Product
- Annual data from 1969 To yyyy
- Bureau of Economic Analysis
- Data published beginning at the end of the month following the end of the quarter.
|
%GDP |
Bureau of Economic Analysis |
%GDP is DEBT percentage of GDP. The percentages were computed in my spreadsheet using Table 1.1.5. Gross Domestic Product [Billions of dollars] Annual data from 1969 To yyyy; see GDP-$ and DEBT. |
PCE |
Bureau of Economic Analysis |
The GDP Personal consumption expenditures percentage Source: US Department of Commerce, Bureau of Economic Analysis (BEA) Gross Domestic Product (GDP) If you are not at Gross Domestic Product (GDP) search for it. It should be on page http://www.bea.gov/national/index.htm. Then click on
- "Interactive Tables: GDP and the National Income and Product Account (NIPA) Historical Tables"; that page should be
- National Data GDP & Personal Income;
- click on "Begin using the data"; that page should be
- National Data National Income and Product Accounts Tables; click on Advanced Download Section; that page should be
- Download NIPA Tables and it is where you can download series of tables.
I chose to download (csv format) Section 1 (file size). Data published beginning at the end of the month following the end of the quarter. For both GDP and PCE I used Table 1.1.2. Contributions to Percent Change in Real Gross Domestic Product Seasonally adjusted at annual rates Quarterly data from 1969 To yyyy Bureau of Economic Analysis. Data published beginning at the end of the month following the end of the quarter. |
Gross Domestic Product (GDP) is also the source for the tables that GDP-$ uses
- Table 1.1.6. Real Gross Domestic Product, Chained Dollars [Billions of chained (2009) dollars]
- Annual data from 1969 To yyyy
- Bureau of Economic Analysis
- Data published beginning at the end of the month following the end of the quarter.
and |
- Table 1.1.5. Gross Domestic Product [Billions of dollars]
- Annual data from 1969 To yyyy
- Bureau of Economic Analysis
- Data published beginning at the end of the month following the end of the quarter.
|
Def%, Def$, NDef%, and NDef$ use these tables |
Table 1.5.2. Contributions to Percent Change in Real Gross Domestic Product, Expanded Detail Annual data from 1969 To yyyy Bureau of Economic Analysis Data; Data published beginning at the end of the month following the end of the quarter. |
Table 1.5.6. Real Gross Domestic Product, Expanded Detail, Chained Dollars[Billions of chained (2009) dollars] Annual data from 1999 To yyyy Bureau of Economic Analysis Data; Data published beginning at the end of the month following the end of the quarter. |
U-6 |
Hover column for U-2 data. |
Bureau of Labor Statistics |
U-1 to U-6 unemployment rates. We know how the "official unemployment rate" (U-3 I think) is manipulated so I won't include it here. These are annualized monthly data for December. |
Series Id: LNS13327709 Seasonally Adjusted Series title: (seas) Total unemployed, plus all marginally attached workers plus total employed part time for economic reasons, as a percent of all civilian labor force plus all marginally attached workers Labor force status: Aggregated totals unemployed Type of data: Percent or rate Age: 16 years and over Percent/rates: Unemployed and mrg attached and pt for econ reas as percent of labor force plus marg attached. |
SSDI |
Social Security Administration |
Selected Data from Social Security's Disability Program |
The following table presents unedited data (including corrections, if any) on disabled worker beneficiaries paid from Social Security's Disability Insurance Trust Fund. In particular, unedited award data may contain duplicate cases. |
Permits |
United States Census Bureau |
New Privately Owned Housing Units Authorized by Building Permits in Permit-Issuing Places |
Series refers to Place Series; i.e., universe "defined as all unique permit offices at the time the last sample was selected."
- 20,000-place universe - jurisdictions identified as of 2003
- 19,000-place universe - jurisdictions identified as of 1993
- 17,000-place universe - jurisdictions identified as of 1983
- 16,000-place universe - jurisdictions identified as of 1977
- 14,000-place universe - jurisdictions identified as of 1971
- 13,000-place universe - jurisdictions identified as of 1966
- 10,000-place universe - jurisdictions identified as of 1958
Alternate documentation for Series and Permits, April 2015
- start
- In the Topics dropdown menu select Economy
- You are here: Census.govâºBusiness & Industry:
On the Business & Industry page click Data by Survey - You are here: Census.govâºBusiness & IndustryâºData by Survey
On the Business & Industry, Economic data by survey page choose Title, under Economic data by survey title choose Building Permits - You are here: Census.govâºBusiness & IndustryâºConstructionâºBuilding Permits
- On the Building Permits Survey page, under Building Permits, choose United States and Regions
- You are here: Census.govâºBusiness & IndustryâºConstructionâºBuilding PermitsâºUnited States Permits
On the Building Permits Survey, United States and Census Regions page, under Units and Valuation choose United States XLS [56kb] or PDF [17kb]
in the pdf file see Table 1a. New Privately Owned Housing Units Authorized Unadjusted Data for United States
|
|
GDP-$ |
Bureau of Economic Analysis |
GDP-$ (billions) is GDP in 2009 dollars; Hover GDP-$ to see nominal GDP dollars that I use with federal public DEBT to calculate the debt percentage. |
GDP-$ is
- Table 1.1.6. Real Gross Domestic Product, Chained Dollars [Billions of chained (2009) dollars]
- Annual data from 1969 To yyyy
- Bureau of Economic Analysis
- Data published beginning at the end of the month following the end of the quarter.
|
- Hover GDP-$ to see
Table 1.1.5. Gross Domestic Product [Billions of dollars] - Annual data from 1969 To yyyy
- Bureau of Economic Analysis
- Data published beginning at the end of the month following the end of the quarter.
|
see PCE |
Table 1.1.6. Real Gross Domestic Product is inflation adjusted GDP and Table 1.1.5. is the nominal GDP that I use with federal public DEBT to calculate the percentage (DEBT) is of GDP. |
DEBT (federal in billions) |
Treasury Department |
http://www.treasury.gov/ |
from menu bar select Services |
- Select Government Shared Services
- Services Government Shared Services
- select TreasuryDirect Services for Governments
- Welcome to the Government Section of TreasuryDirect
- select from the column on the left The Debt of the United States
- Public Debt Reports
- select Historical Debt Outstanding
- Historical Debt Outstanding â Annual
- I used both 2000 - yyyy and 1950 - 1999
|
The DEBT percentages %GDP of GDP were computed in my spreadsheet using Table 1.1.5. Gross Domestic Product [Billions of dollars] Annual data from 1969 To yyyy; see GDP-$ |
http://www.treasury.gov/ |
from menu bar select Services |
Recent day's DEBT Select Government Shared Services
- Services Government Shared Services
- select TreasuryDirect Services for Governments
- Welcome to the Government Section of TreasuryDirect
- select from the column on the left The Debt of the United States
- Public Debt Reports
- select Historical Debt Outstanding
- from column on left choose Debt to the Penny
- pick a day that represents a specific calendar quarter
|
Def% and Def$ |
Bureau of Economic Analysis |
see PCE |
National Defense component of the Real GDP increase/decrease percent, year-to-year |
Example. GDP-$ Figures are in billions. Years are 2011 and 2012 and prior years are 2010 and 2011 respectively. Prior years are shown in the example.
- (14,783.8 * -0.13%) + 813.5 =
- (-19.21894)+ 813.5 = 794.2906 (BEA table shows 795.0)
-
- (15,020.6 * -0.18%) + 795.0 =
- (-27.03708)+ 795.0 = 767.96292 (BEA table shows 768.7)
Take
- last year's Real GDP
- times current year's National Defense increase/decrease percent
- (an addend of current year's Real GDP increase/decrease percentage)
- and add (+/-) the result to last year's National Defense budget.
This simple illustration is off a few hundred millions (budget dust :) ) I guess because of the more complicated procedures used by BEA. |
Table 1.5.2. Contributions to Percent Change in Real Gross Domestic Product, Expanded Detail Annual data from 1969 To yyyy Bureau of Economic Analysis Data; Data published beginning at the end of the month following the end of the quarter. |
Table 1.5.6. Real Gross Domestic Product, Expanded Detail, Chained Dollars [Billions of chained (2009) dollars] Annual data from 1999 To yyyy Bureau of Economic Analysis Data; Data published beginning at the end of the month following the end of the quarter. |
NDef% and NDef$ |
Bureau of Economic Analysis |
see PCE |
National NonDefense component of the Real GDP increase/decrease percent, year-to-year |
see example in Def% (National Defense component of the Real GDP increase/decrease percent, year-to-year) |
Table 1.5.2. Contributions to Percent Change in Real Gross Domestic Product, Expanded Detail Annual data from 1969 To yyyy Bureau of Economic Analysis Data; Data published beginning at the end of the month following the end of the quarter. |
Table 1.5.6. Real Gross Domestic Product, Expanded Detail, Chained Dollars [Billions of chained (2009) dollars] Annual data from 1999 To yyyy Bureau of Economic Analysis Data; Data published beginning at the end of the month following the end of the quarter. |
Rcpts |
Office of Management and Budget |
go to
- www.whitehouse.gov/
- Under Executive Offices
- select Office of Management and Budget
- at Office of Management and Budget
- select Historical Tables
- at Historical Tables
- select Table 1.2 Summary of Receipts, Outlays, and Surpluses or Deficits (-) as Percentages of GDP: 1930-2020
|
Note about Obama White House liars.. http://research.stlouisfed.org/fred2/series/FYFRGDA188S the Federal Reserve Bank of St. Louis shows Federal Reserve Economoic Date (FRED) figures very similar to OMB figures on its (FRED) Federal Receipts as Percent of Gross Domestic Product graph. |
Out |
Office of Management and Budget |
See Rcpts |
+/- |
Office of Management and Budget |
See Rcpts |
To: All
BTW it just occurred to me to acknowledge a text tool that makes this stuff a heck of a lot easier. It's called
Notepad++ With the help of Notepad++ it is relatively easy to add to the table -- which is actually 30+ tables almost all of which are single column tables.
Great for many programming languages as well as HTML and stuff.
2
posted on
11/02/2015 5:09:16 PM PST
by
WilliamofCarmichael
(If modern America's Man on Horseback is out there, Get on the damn horse already!)
To: WilliamofCarmichael
3
posted on
11/02/2015 5:34:10 PM PST
by
Misterioso
(Altruism is a sin.)
Disclaimer:
Opinions posted on Free Republic are those of the individual
posters and do not necessarily represent the opinion of Free Republic or its
management. All materials posted herein are protected by copyright law and the
exemption for fair use of copyrighted works.
FreeRepublic.com is powered by software copyright 2000-2008 John Robinson