2007 Census of Agriculture Energy (2009) - Issued February 2011 by the National Agricultural Statistics Service (NASS), U.S. Department of Agriculture.

You have downloaded "comma-separated value" (CSV) files which contain delimited-record representations of the tables in the report referenced above. These CSV files can be imported into spreadsheets, or can be processed easily by other types of software.

Each line in a given CSV file represents one line in the published table (exception: there is a separate line for each footnote, regardless of how the footnotes are presented in the published table).

The first three values on the line are not part of the table. The first value is the chapter and the second value is the table number. The third value is a line "type", as follows:

t = title line
h = column heading line
d = data line
f = footnote

Examples:

  Title Line
  1,17,"t","Table 17. Irrigation Pumps on Farms: 2008 and 2003"

  Column Heading Lines
  1,17,"h","","","","Farms with -","Farms with -","Farms with -","Farms with -","Farms with -","Farms with -","Farms with -","Farms with -","Farms with -","Farms with -"
  1,17,"h","","","","","","","","","","","","",""
  1,17,"h","","","Total","","","","","","6 or 7","8 or 9","10 to 19","20 to 29","30 pumps"
  1,17,"h","Geographic area","Farms","pumps 1/","1 pump","2 pumps","3 pumps","4 pumps","5 pumps","pumps","pumps","pumps","pumps","or more"
  1,17,"h","","","","","","","","","","","","",""

  Data Lines
  1,17,"d","Alabama",665,1250,427,127,40,27,14,13,8,9,-,-
  1,17,"d","",,,,,,,,,,,,
  1,17,"d","Region 01 New England",1130,2790,634,265,75,41,33,39,18,12,7,6

  Footnote
  1,17,"f","1/ Data include only well pumps for wells used."