Input-Output Accounts Tables Help

Choose a help topic:

Using the interactive I-O accounts Web site

This is an interactive feature that allows the user to customize a selection of data from the U.S. I-O accounts.

Step 1: Select a table by clicking on the title of the table.
After choosing a table, a new page will open with a list of options related to the selected table.

Use Table
Make Table
Direct Requirement
Total Requirements

Step 2: Select a year from the drop-down menu.
The I-O accounts database includes benchmark tables as well as annual updates for those tables.

Step 3: Select a level of aggregation.
There are three levels of aggregation to choose from: Sector, Summary and Detail.(Detail is used by Benchmark years only)

  • Sector is the most aggregated and displays data by major industry (i.e., agriculture, manufacturing, etc.); Purchaser value data and
    margin data are not available at this level.
  • Data at the division and summary levels are available for all years listed.
  • The detailed data are available for benchmark years only.

 Example of industry breakout.
The 1987 benchmark sector level industry construction consists of three summary elements and 54 detail elements.

Step 4: Select the rows for the table.
Depending on the table selected, the rows can either be industries or commodities.

  • Select an AGGREGATION. You can choose to use a standard aggregation or create your own user-defined aggregation.


Standard Aggregation:
there are three standard aggregations		 Choose the industries/commodities that you are interested in viewing. You also have the option to select all rows;
OR
Search by keyword. Type in the keyword(s) and select whether matching on all words (AND) or matching on any word (OR);
OR
For summary and detailed data, you can also select by industry group. The subgroup of the selected industry group level will be highlighted in the industry/commodity list at the top and all other industries/commodities will show in the list below them.
 
User-defined Aggregation: Access existing aggregates (if you created aggregates in the past and logged in with your user name and password) and/or create new aggregates
To select an existing aggregate, find the aggregate from your list and check the box in the "selected" column. You can select more than one aggregate as long as there is no overlap in codes between the
aggregations. Then press OK.
OR
To create an aggregate for Make, Direct and Total Requirements Tables, click on Create new aggregate link. For Use Tables, click on either Create new Commodity aggregate link or Create new Value Added aggregate link.
 
 
  		•  Give a name and a description for your aggregation in the space provided at the top of the page.
     
    Check off the boxes next to the codes you want to aggregate. You can also use a word search or industry group list to aid you by
    pressing Use word search or industry groups to add to list
    This will take you to a page that works like the standard aggregation page described above in step 4, section I.
      When you've finished making your selections, press OK.
     
    You will be taken to the initial row selection page listing your aggregate and all other codes not in your aggregate. Select any or all the remaining
    codes you want displayed and press OK.
     


    Step 5: Select the columns for the table.
    The directions are the same as in Step 4.

    Step 6: Select the valuation (for the Use Tables only).
    There are three valuations to select from: Producers' prices, purchasers' prices, and margins.

    • Producers' price is the basic value (i.e. price of a good or service to the point of production) plus commodity tax (i.e. excise tax).
    • Purchasers' price are the producers' prices plus domestic transportation charges plus trade margins.
    • Margins are domestic transportation charges plus trade margins.

    Step 7: Select orientation.
    Select Normal to view the table in its published form or Transposed to view the table with the rows and columns reversed.

    Step 8: Click "View Table" or "Download Table".

    "View Table"
    Click this button to view the selected data. Once the data has been retrieved, the order in which the selected data appear can be changed by clicking column headers (IO Code, Name
    or the codes for commodities/industries). An arrow will appear, showing the sort order. The upward arrow indicates ascending sort;
    the downward arrow indicates descending sort order.
    "Download Table".
    This will download the data you can save to a CSV file or open into a spreadsheet.

    Glossary

    Top

    Commodity-by-Commodity Total Requirements Table: Shows output required, directly and indirectly, of each commodity to deliver
    a dollar of final demand of a commodity.

    Commodity-by-Industry Direct Requirements Table: Shows the input coefficients for each commodity that an industry requires
    to produce a dollar of output.

    Establishment: A business or industrial unit at a single physical location which produces or distributes goods or performs services.
    A company is a business organization consisting of all establishments under common ownership or control.

    Final Use: Goods and services used by final consumers and not used by industries as inputs for intermediate production.

    GDP: The market value of the goods and services produced by labor and property in the United States.

    Industry-by-Commodity Total Requirements Table: Shows output required, directly and indirectly, by each industry to deliver a
    dollar of final demand of a commodity.

    Industry-by-Industry Total Requirements Table: Shows the output required, directly, and indirectly, by each industry to deliver a
    dollar of final demand of industry output to final users.

    I-O Definition: Industry classification following either the North American Classification System (NAICS) or an
    approximate Standard Industrial Classification (SIC) definition of industries adjusted for redefinitions of secondary output.

    Intermediate Use: Consumption of goods or services by industries as inputs in the production of other goods or services.

    Make Table: Shows the value in producers' prices of each commodity produced by each industry.

    Margin: The difference between transactions valued in purchasers' prices and producers' prices.

    NAICS Definition: Industry classification following the 1997 North American Classification System (NAICS). Under the system establishments
    are grouped according to the similarities of the production processes. The definition applies to the 1997 benchmark I-O accounts.

    Producers' Price: Price received by producer, including excise and sales taxes.

    Purchasers' Price: Price paid by industries and final users. The equivalent of
    producers' price plus trade (wholesale and retail) margins and transportation costs.

    Redefinition: Secondary output and related inputs of an industry redefined to the industry where the output is primary.

    SIC Definition: Industry classification following an approximate 1987 Standard Industrial Classification (SIC) definition of industries. The SIC system
    classifies establishments into industries on the basis of the primary activities of the establishment. This definition applies to all tables prior to the 1997
    benchmark I-O accounts and the 1996 through 1998 annual I-O accounts.

    Use Table: Shows the value in producers' prices of each commodity used by each industry or by each final user. Also gives value added
    and the total intermediate inputs that are used by each industry to produce its output.

    Value Added: Contribution of primary inputs (mainly labor and capital) to total output.