Dry Beans                       (Updated 11/2003)     Stock #86003
Economic Research Service, United States Department of Agriculture
******************************************************************

Note:  Data distributed with this product may include both 
published and unpublished statistics in the public domain.  
Distribution in this form does not imply U.S. Department of 
Agriculture approval of a particular data series or statistic, nor 
does the Department attest to their accuracy.  Moreover, the 
Economic Research Service makes no warranty that data supplied in 
this form are either accurate transcriptions from source materials 
or appropriate for a particular user purpose.

For comments or further information e-mail: 
       Gary Lucier  (202) 694-5253   e-mail: glucier@econ.ag.gov
       Charles Plummer (202) 694-5256 e-mail: cplummer@econ.ag.gov

Or contact the ERS Information Center at:Phone: 202-694-5050
e-mail: service@ers.usda.gov 

The ERS Information Center is the principal point of contact to 
respond to customer questions regarding ERS products and services. 
The ERS Information Center operates Monday through Friday from 8 
a.m. to 5 p.m., except Federal holidays. Staff answering the 
phones are trained to provide quality customer service. 

******************************************************************
   
       E C O N O M I C   R E S E A R C H   S E R V I C E
            
         ***** DRY EDIBLE BEAN BOOK DOCUMENTATION *****
                 ***** UPDATED 11/14/2003 *****

These statistical tables include much of the known published data 
series on U.S. dry edible beans. The database contains U.S. acreage, 
production, price, value, trade, and consumption statistics.  World 
acreage, production, and trade for round and broad dry beans are
also included.

The tables are stored as Excel 4.0 worksheets. The files can be 
retrieved by any software capable of reading .xls files such as 
Excel, Lotus, and Quatro.   Each file generally contains one 
table.

In the following documentation, 'filename' is the name of the file 
associated with a particular table.  To view the table, simply 
retrieve the worksheet name which corresponds to the table listed 
in the documentation.

The following file inventory should help you locate specific 
information:

Tab File                  
num name  Yrs/Freq Source      Description
-------------------------------------------------------------------
  1  Acres     69-03  A  NASS  US dry bean area plant & harvestd

Dry bean acrege, yield, prodn,value, by State
  2  DbAcreCA  19-03  A  NASS  California 
  3  DbAcreCO  09-03  A  NASS  Colorado 
  4  DbAcreID  09-03  A  NASS  Idaho 
  5  DbAcreKS  28-03  A  NASS  Kansas 
  6  DbAcreMI  09-03  A  NASS  Michigan
  7  DbAcreMN  09-03  A  NASS  Minnesota 
  8  DbAcreMT  16-03  A  NASS  Montana 
  9  DbAcreND  43-03  A  NASS  North Dakota 
 10  DbAcreNE  19-03  A  NASS  Nebraska 
 11  DbAcreNM  09-03  A  NASS  New Mexico 
 12  DbAcreNY  09-03  A  NASS  New York 
 13  DbAcreOR  29-03  A  NASS  Oregon 
 14  DbAcreTX  43-03  A  NASS  Texas 
 15  DbAcreUT  34-03  A  NASS  Utah 
 16  DbAcreWA  29-03  A  NASS  Washington 
 17  DbAcreWI  90-03  A  NASS  Wisconsin 
 18  DbAcreWY  19-03  A  NASS  Wyoming 
 19  DbAcreUS  09-03  A  NASS  United States 

Dry bean production by class & State:
 20  Prod70    1970   A  NASS  US 
 21  Prod71    1971   A  NASS  US 
 22  Prod72    1972   A  NASS  US 
 23  Prod73    1973   A  NASS  US 
 24  Prod74    1974   A  NASS  US 
 25  Prod75    1975   A  NASS  US 
 26  Prod76    1976   A  NASS  US 
 27  Prod77    1977   A  NASS  US 
 28  Prod78    1978   A  NASS  US 
 29  Prod79    1979   A  NASS  US 
 30  Prod80    1980   A  NASS  US 
 31  Prod81    1981   A  NASS  US 
 32  Prod82    1982   A  NASS  US 
 33  Prod83    1983   A  NASS  US 
 34  Prod84    1984   A  NASS  US 
 35  Prod85    1985   A  NASS  US 
 36  Prod86    1986   A  NASS  US 
 37  Prod87    1987   A  NASS  US 
 38  Prod88    1988   A  NASS  US 
 39  Prod89    1989   A  NASS  US 
 40  Prod90    1990   A  NASS  US 
 41  Prod91    1991   A  NASS  US 
 42  Prod92    1992   A  NASS  US 
 43  Prod93    1993   A  NASS  US 
 44  Prod94    1994   A  NASS  US 
 45  Prod95    1995   A  NASS  US 
 46  Prod96    1996   A  NASS  US 
 47  Prod97    1997   A  NASS  US 
 48  Prod98    1998   A  NASS  US 
 49  Prod99    1999   A  NASS  US 
 50  Prod00    2000   A  NASS  US 
 51  Prod01    2001   A  NASS  US
 52  Prod02    2002   A  NASS  US

Dry bean production by class:
 53  DbProdCA  19-02  A  NASS  California 
 54  DbProdCO  19-02  A  NASS  Colorado 
 55  DbProdID  19-02  A  NASS  Idaho 
 56  DbProdKS  66-02  A  NASS  Kansas 
 57  DbProdMI  19-02  A  NASS  Michigan 
 58  DbProdMN  64-02  A  NASS  Minnesota 
 59  DbProdMT  19-02  A  NASS  Montana 
 60  DbProdND  64-02  A  NASS  North Dakota 
 61  DbProdNE  19-02  A  NASS  Nebraska 
 62  DbProdNM  19-02  A  NASS  New Mexico 
 63  DbProdNY  19-02  A  NASS  New York 
 64  DbProdOR  90-02  A  NASS  Oregon 
 65  DbProdSD  00-02  A  NASS  South Dakota 
 66  DbProdTX  90-02  A  NASS  Texas 
 67  DbProdUT  59-02  A  NASS  Utah 
 68  DbProdWA  37-02  A  NASS  Washington 
 69  DbProdWI  90-02  A  NASS  Wisconsin 
 70  DbProdWY  19-02  A  NASS  Wyoming 
 71  DbProdUS  19-02  A  NASS  United States 

U.S. monthly f.o.b.dealer prices by bean class:
 72  DrPrBabL  79-03  M  AMS   Baby Lima beans
 73  DrPrBlkE  79-03  M  AMS   Blackeye beans
 74  DrPrGarb  79-03  M  AMS   Garbanzo beans
 75  DrPrLgtR  79-03  M  AMS   Light-red kidney beans
 76  DrPrDkRd  91-03  M  AMS   Dark-red kidney beans
 77  DrPrLrgL  79-03  M  AMS   Large Lima beans
 78  DrPrPBea  79-03  M  AMS   Pea beans (navy)
 79  DrPrPnks  79-03  M  AMS   Pink beans
 80  DrPrSmRd  79-03  M  AMS   Small red beans
 81  DrPrCrBy  90-03  M  AMS   Cranberry beans
 82  DrPrSmWh  79-03  M  AMS   Small white beans
 83  DrPrGN    79-03  M  AMS   Great Northern beans
 84  DrPrPto   79-03  M  AMS   Pinto beans
 85  DrPrBlk   89-03  M  AMS   Black beans

US dry beans: Weekly dealer price by class:
 86  Price81   1981   W  AMS 
 87  Price82   1982   W  AMS 
 88  Price83   1983   W  AMS 
 89  Price84   1984   W  AMS 
 90  Price85   1985   W  AMS 
 91  Price86   1986   W  AMS 
 92  Price87   1987   W  AMS 
 93  Price88   1988   W  AMS 
 94  Price89   1989   W  AMS 
 95  Price90   1990   W  AMS 
 96  Price91   1991   W  AMS 
 97  Price92   1992   W  AMS 
 98  Price93   1993   W  AMS 
 99  Price94   1994   W  AMS 
100  Price95   1995   W  AMS 
101  Price96   1996   W  AMS 
102  Price97   1997   W  AMS 
103  Price98   1998   W  AMS 
104  Price99   1999   W  AMS 
105  Price00   2000   W  AMS 
106  Price01   2001   W  AMS 
107  Price02   2002   W  AMS 
108  Price03   2003   W  AMS 

Monthly & season ave grower price by State:
109  CADbGrPr  60-03  M  NASS  California 
110  CODbGrPr  60-03  M  NASS  Colorado 
111  IDDbGrPr  60-03  M  NASS  Idaho 
112  MIDbGrPr  60-03  M  NASS  Michigan 
113  MNDbGrPr  60-03  M  NASS  Minnesota 
114  NDDbGrPr  60-03  M  NASS  North Dakota 
115  NEDbGrPr  60-03  M  NASS  Nebraska 
116  USDbGrPr  60-03  M  NASS  United States 
117  WADbGrPr  60-96  M  NASS  Washington 
118  WYDbGrPr  60-94  M  NASS  Wyoming 

Other U.S. statistics:
119  DbGrPrCla 95-03  M  AMS   U.S. grower prices by class
120  DryBnPPI  60-03  M  USDL  Producer Price index by class 
121  DbRetPri  95-03  M  USDL  Dry pack bean ave retail price 
122  DbValue   70-02  A  NASS  Dry bean value of production
123  DbPerCap  70-03  A  ERS   Dry bean per capita use, by class
124  MarkPrcnt 90-02  M  NAS   Percent of sales by month & State

U.S. dry bean trade data:
125  DbExport  78-03  M  CNSUS Monthly exports by class
126  DbImport  78-03  M  CNSUS Monthly imports by class
127  DbXVCtry  95-02  A  CNSUS Export value by country

World dry bean (round-types) statistics:
128  DbWrldProd   61-02  A  FAO   Production (MT)
129  DbWrldArea   61-02  A  FAO   Area harvested (Ha)
130  DbWrldEx     82-01  A  FAO   Export volume by country
131  DbWrldIm     82-01  A  FAO   Import volume by country

World broad (flat) dry bean statistics:
132  BrDbWrldArea 90-02  A  FAO   Area harvested (Ha)
133  BrDbWrldProd 90-02  A  FAO   Production
134  BrDbWrldEx   82-01  A  FAO   Exports by country
135  BrDbWrldIm   82-01  A  FAO   Imports by country

136  WrldCkpeaPd  90-02  A  FAO   World chickpea production
137  Yields       60-03  A  NASS  U.S. dry bean yield by State

'Year/Freq' refers to the years covered and the frequency
of the data(A=Annual, M=Monthly).  'Source' documents
where the data was produced.  The source abbreviations
stand for the following: 
 
     ERS - Economic Research Service (USDA)
     NASS - National Agricultural Statistics Service (USDA)
     AMS - Agricultural Marketing Service (USDA)
     CNSUS - Bureau of the Census (US Dept of Commerce)
     FAO - Food and Agriculture Organization (United Nations)
     USDL - Bureau of Labor Statistics (US Dept of Labor)

ERS updates and attempts to improve the dry bean data set 
regularly. Your suggestions regarding content and style
are welcome.

For comments or further information about U.S. pulse data, 
contact:
  
   Subject matter questions: Gary Lucier  (202) 694-5253
                              e-mail: glucier@ers.usda.gov
                             Charles Plummer (202) 694-5256
                              e-mail: cplummer@ers.usda.gov

   Technical questions:      Gary Lucier  (202) 694-5253

For current information on dry beans, please refer to
the ERS electronic publication titled 'Vegetables and Melons
Outlook.'   For a free subscription, call the ERS information center
at (202) 694-5050 or visit the ERS web site (www.ers.usda.gov)
using the following link: 
  http://www.ers.usda.gov/publications/vgs/

--- END OF FILE ---