what works · what's broken · what's on the way
visualization gallery

Partnerships--Selected Items by Industry: 2004 (Statistical Abstract 2008 Table 0726)

Photo of a Chimpanzee

Size: 7.1 KB (approx) Downloaded: 0 times
Available in: csv, yaml, and xls Category: demographics/us

About

The Statistical Abstract of the United States is the standard summary of statistics on the social, political, and economic organization of the United States. It is also designed to serve as a guide to other statistical publications and sources. The latter function is served by the introductory text to each section, the source note appearing below each table, and Appendix I, which comprises the Guide to Sources of Statistics, the Guide to State Statistical Abstracts, and the Guide to Foreign Statistical Abstracts.
This volume includes a selection of data from many statistical sources, both government and private. Publications cited as sources usually contain additional statistical detail and more comprehensive discussions of definitions and concepts. Data not available in publications issued by the contributing agency but obtained from the Internet or unpublished records are identified in the source notes. More information on the subjects covered in the tables so noted may generally be obtained from the source.

Although emphasis in the Statistical Abstract is primarily given to national data, many tables present data for regions and individual states and a smaller number for metropolitan areas and cities. Appendix II, Metropolitan and Micropolitan Statistical Areas: Concepts, Components, and Population, presents explanatory text, a complete current listing and population data for metropolitan and micropolitan areas defined as of December 2005. Statistics for the Commonwealth of Puerto Rico and for island areas of the United States are included in many state tables and are supplemented by information in Section 29. Additional information for states, cities, counties, metropolitan areas, and other small units, as well as more historical data are available in various supplements to the Abstract.

Fields

nametypeunitstags

Credits

US Census Bureau source http://www.census.gov/statab/www

U.S. Census Bureau,
Statistical Abstract of the United States: 2008 (127th Edition)
Washington, DC, 2007;
http://www.census.gov/statab/www/

Philip (flip) Kromer converted http://infochimp.org/flip
U.S. Internal Revenue Service,

U.S. Internal Revenue Service,

Statistics of Income various issues.

referenced on dataset section data (#1)

U.S. Internal Revenue Service, http://www.irs.gov/taxstats/index.html

U.S. Internal Revenue Service,

Statistics of Income various issues.

For more information:

http://www.irs.gov/taxstats/index.html

referenced on dataset section notes (#2)

U.S. Internal Revenue Service,

U.S. Internal Revenue Service,

Statistics of Income various issues.

referenced on dataset section 2000 (#3)

Usage Notes

[none]

Rights Info

All US Census Bureau materials, regardless of the media, are entirely in the public domain. There are no user fees, site licenses, or any special agreements etc for the public or private use, and or reuse of any census title. As tax funded product, it’s all in the public record.
Some of our products, however, are special cases. […] The Statistical Abstract has some data covered by copyright law. Check the table’s footnotes to determine if the data are covered by copyright law.

File structure

The Statistical Abstract files are distributed by the census department as excel files. These files have data mixed with notes and references, multiple tables per sheet, and worst of all the table headers aren’t easily matched to their rows and columns.
The excel files in this collection are unmolested copies of the census originals, with the following exceptions:

  1. A few files had extraneous characters in the title. These were
    corrected to be consistent. A few files have a sheet of crufty
    gibberish in the first slot. The sheet order was shuffled but no
    data were changed.
The tables that were changed: 0166 0257 0362 0429 0445 0446 0459 0461 0462 0464 0465 0466 0467 0469 0479 0480 0481 0482 0483 0484 0485 0486 0487 0559 0628 0629 1144 1227 1231
  1. The first four files have been restructured to allow full
    comprehension of the table. If you’d like to help clean up the data
    follow along with what’s there.

The CSV files, and the payload portions of the yaml files, have not been processed beyond extracting an array (excel sheets) of 2-D arrays (each sheet’s cells).

Some metadata (title, footnotes, symbols, and sources) has been copied (without molesting the imported stream) into the appropriate slot in this schema. This metadata identification was purposefully done to be strict and simple, and the original files are somewhat irregular, so it’s possible that some metadata fields were missed

These files have been tagged by hand and received cursory inspection, but you’re advised to check against the originals before you go lauching any Mars rovers.

Footnotes

notes (pg 2)

  1. Total assets are understated because not all partnerships file
    complete balance sheets.
  2. Finance and insurance, real estate,
    and management of companies includes investment income for partnerships.

Headnotes

[In millions of dollars, except as indicated (11,607,698 represents $11,607,698,000,000).
Covers active partnerships only. Includes partnerships not
allocable by industry. Figures are estimates based on samples.
Based on the North American Industry Classification System (NAICS) 2002; see text, this section.
See Appendix III]

Shape

table: [38, 12]

Snippet

Industry
Total (1,000) With net income (1,000) With net loss (1,000)
Total (X) 2547 1441 1106 15557 11607698.14 3141639.40716 2875561.301 384738.394 566231.686 181493.292
Raw materials and energy production 150 84 66 970 417798.051 234044.505024 223485.024 28619.875 43341.292 14721.417
Agriculture, forestry, fishing and hunting 11 120 64 55 443 95354.185 21432.30001 27668.071 27.059 5227.494 5200.435
Mining 21 26 18 8 461 173453.481 77012.609752 58476.816 27244.573 31808.44 4563.868
Utilities 22 4 2 2 66 148990.386 135599.595261 137340.138 1348.243 6305.358 4957.115
Goods Production 197 106 91 668 627381.778 842377.645855 809177.895 56706.464 73934.089 17227.625
Construction 23 155 87 68 444 200265.423 226164.861136 213797.68 19044.946 24538.49 5493.544
Manufacturing 31-33 43 19 24 225 427116.355 616212.784719 595380.216 37661.518 49395.599 11734.081
Distribution and transportation of goods 214 100 114 1496 311297.603 710126.912738 710345.989 17043.238 28538.163 11494.925
12=. … snip
Source: U.S. Internal Revenue Service,
Statistics of Income various issues.

Symbols

notes (pg 2)

  • (X) Not applicable.
  • (Z) Less than 500 for number of partnerships/Less than $500,000 for money amounts

Tablenum

0726

Year

2008

History

Uploaded by (admin) Modified by (admin)