Dry Beans                       (Updated 9/2001)  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@econ.ag.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. 

******************************************************************
NOTE: Dry Peas & Lentils are no longer a part of this product.   
              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 09/05/2001 *****

These statistical tables include much of the known published data 
on U.S. dry edible beans.  The database contains U.S. acreage, 
production, price, value, import, and export statistics.  World 
acreage and production for aggregate dry beans are also included.

The tables are stored as LOTUS (.wk1) worksheets.  The files can 
be retrieved by any software capable of reading .WK1 files such as 
Excel, Lotus, and Quatro.   Each file generally represents 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-01  A  NASS  US dry bean acreage planted & harvested

Dry bean acrege, yield, prodn,value, by State
2 DbAcreCA 19-01  A  NASS  CA 
3 DbAcreCO 09-01  A  NASS  CO 
4 DbAcreID 09-01  A  NASS  ID 
5 DbAcreKS 28-01  A  NASS  KS 
6    DbAcreMI  09-01  A  NASS  MI 
7    DbAcreMN 09-01  A  NASS  MN 
8    DbAcreMT 16-01  A  NASS  MT 
9    DbAcreND 43-01  A  NASS  ND 
10   DbAcreNE  19-01  A  NASS  NE 
11   DbAcreNM 09-01  A  NASS  NM 
12   DbAcreNY  09-01  A  NASS  NY 
13   DbAcreOR  29-01  A  NASS  OR 
14   DbAcreTX  43-01  A  NASS  TX 
15   DbAcreUT  34-01  A  NASS  UT 
16   DbAcreWA 29-01  A  NASS  WA 
17   DbAcreWI  90-01  A  NASS  WI 
18   DbAcreWY 19-01  A  NASS  WY 
19   DbAcreUS   09-01  A  NASS  US 

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 

Dry bean production by class:
 51   DbProdCA  19-00 A  NASS  CA 
 52   DbProdCO  19-00 A  NASS  CO 
 53   DbProdID    19-00 A  NASS  ID 
 54   DbProdKS   66-00 A  NASS  KS 
 55   DbProdMI   19-00 A  NASS  MI 
 56   DbProdMN 64-00 A  NASS  MN 
 57   DbProdMT  19-00 A  NASS  MT 
 58   DbProdND  64-00 A  NASS  ND 
 59   DbProdNE   19-00 A  NASS  NE 
 60   DbProdNM  19-00 A  NASS  NM 
 61   DbProdNY   19-00 A  NASS  NY 
 62   DbProdOR  90-00 A  NASS  OR 
 63   DbProdTX   90-00 A  NASS  TX 
 64   DbProdUT   59-00 A  NASS  UT 
 65   DbProdWA  37-00 A  NASS  WA 
 66   DbProdWI   90-00 A  NASS  WI 
 67   DbProdWY  19-00 A  NASS  WY 
 68   DbProdUS    19-00 A  NASS  US 
 69   DryBnPPI     60-01  M  USDL  US 

indexes

 70   DbRetPri      95-01  M  USDL  US dry pack beans: Ave retail price 
 71   DbValue      70-00  A  NASS  US dry bean value of production
 72   DbPerCap    70-01  A  ERS   US dry bean per capita use, by 
class
 73   GrPrBabL    79-01  M  AMS   Baby Limas: US mo ave fob dealer 
price
 74   GrPrBlkE    79-01  M  AMS   Blackeyes: US mo ave fob dealer 
price
 75   GrPrGarb    79-01  M  AMS   Garbanzos: US mo ave fob dealer 
price
 76   GrPrLgtR    79-01  M  AMS   Light-red kidneys: US mo ave fob 
dlr price
 77   GrPrDkRd   91-01  M  AMS   Dark-red kidneys: US mo ave fob 
dlr price
 78   GrPrLrgL    79-01  M  AMS   Large Limas: US mo ave fob 
dealer price
 79   GrPrPBea    79-01  M  AMS   Pea (navy): US mo ave fob dealer 
price

 80   GrPrPnks    79-01  M  AMS   Pinks: US monthly ave fob dealer 
price
 81   GrPrSmRd  79-01  M  AMS   Small reds: US mo ave fob dealer 
price
 82   GrPrCrBy    90-01  M  AMS   Cranberry beans: US mo ave fob 
dealer price
83   GrPrSmWh  79-01  M  AMS   Small whites: US mo ave fob dealer 
price
 84   GrPrGN       79-01  M  AMS   Great Northerns: US mo ave fob 
dealer price
 85   GrPrPto       79-01  M  AMS   Pintos: US monthly ave fob 
dealer price
 86   GrPrBlk       89-01  M  AMS   Blacks: US monthly ave fob 
dealer price

US dry beans: Weekly dealer price by class:
87   Price81       1981  W  AMS 
88   Price82       1982  W  AMS 
89   Price83       1983  W  AMS 
90   Price84       1984  W  AMS 
91   Price85       1985  W  AMS 
92   Price86       1986  W  AMS 
93   Price87       1987  W  AMS 
94   Price88       1988  W  AMS 
95   Price89       1989  W  AMS 
96   Price90       1990  W  AMS 
97   Price91       1991  W  AMS 
98   Price92       1992  W  AMS 
99   Price93       1993  W  AMS 
100  Price94       1994  W  AMS 
101  Price95       1995  W  AMS 
100  Price96       1996  W  AMS 
101  Price97       1997  W  AMS 
102  Price98       1998  W  AMS 
103  Price99       1999  W  AMS 
104  Price00       2000  W  AMS 
105  Price01       2001  W  AMS 

Mo & season ave grower price:
106  CADbGrPr 60-01  M  NASS  California: 
107  CODbGrPr 60-01  M  NASS  Colorado: 
108  IDDbGrPr  60-01  M  NASS  Idaho: 
109  MIDbGrPr 60-01  M  NASS  Michigan: 
110  MNDbGrPr 60-01  M  NASS   Minnesota: 
111  NDDbGrPr 60-01  M  NASS   N. Dakota: 
112  NEDbGrPr  60-01  M  NASS   Nebraska: 
113  USDbGrPr  60-01  M  NASS   U.S.: 
114  WADbGrPr 60-96  M  NASS  Washington: 
115  WYDbGrPr 60-94  M  NASS   Wyoming: 

116  DbExport    78-01  M  CNSUS US dry bean monthly exports by 
class
117  DbImport    78-01  M  CNSUS US dry bean monthly imports by 
class
118  DbXVCtry   95-00  A  CNSUS US dry bean export value by 
country
119  FAODbPro  61-00  A  FAO     World aggregate dry bean 
production

120  FAODbAcr     61-00  A  FAO    World aggregate dry bean acres 
harvested
121  DbWrldEx      82-99  A  FAO    World dry bean exports by 
country
122  DbWrldIm      82-99  A  FAO    World dry bean imports by 
country
123  BrDbWrldEx   82-99  A  FAO   World dry broad bean exports by 
country
124  BrDbWrldIm   82-99  A  FAO   World dry broad bean imports by 
country
125  FAOBrDbPro  61-00  A  FAO   World aggregate dry broad bean 
production
126  MarkPrcnt       90-00  M  NAS   Marketings: Percent of sales 
by month & 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 ---