EXTRACT

EXTRACT is a general purpose MS-DOS-based data display and extraction tool that works with a number of archival Census Bureau CD-ROMs recorded in dBASE format, most of which were issued prior to 1997.

If you have the 1992 Economic Census CD-ROMs or any of several other discs, you need only install the EXTRACT software below.

If you have one of the CD-ROMs listed below, you will also need to the computerized documentation ("auxiliary files") that EXTRACT requires in order to work with these specific discs, then install them following the instructions in ....READ.TXT files associated with each file.

EXTRACT software

Auxiliary Files:
* 1990 Census STFs and EEO files
* County and City Data Book, 1994 and 1988
* USA Counties, 1996, 1994 and 1992
* County Business Patterns, 1986 to 1997 (required for selected years only)
* Consolidated Federal Funds Report (required for 1983-1992 disc only)
* Exports and Imports (special instructions required for DVD users)
* 1992 Census of Agriculture (required for Disc 1c only)

EXTRACT user support is available by e-mail, but phone usually works better.
Call Paul Zeisset (301) 763-4151 or Bob Marske (301) 763-2547.

To perform data extractions on Census 2000 or 1997 Economic Census data, use American FactFinder online.


EXTRACT Software

The latest version of the software is compressed inside EXT15P.EXE. Once you have downloaded it, create an \EXTRACT directory on your PC, and, with that directory as the default, run EXT15P to uncompress the software, documentation, and tutorials. The installation process is described further in EXT_READ.TXT.

Full documentation is available. New users can get the best start by working through a
tutorial using the 1992 Economic Census CDs (retail trade) or a
tutorial on using 1990 Census STFs (featuring STF 1A). Maintenance updates of the software are made from time to time, as described in FEATURES.NEW.

Check out our "frequently asked questions" FAQ.

1990 Census STFs and EEO files

Auxiliary files are available for STFs 1 and 3 and the EEO CD-ROMs. EXTRACT does not work with the Subject STFs (SSTFs) because they were not created in dBase format.

To install, read STF_READ.TXT. Once installed, auxiliary files for STFs 1A, 1B, 1C, 1D, 3A, 3B 3C, and 3D, plus PL 94-171 and EEO, take up 8 megs of hard disk space. The fewer types of CDs you use, the less hard disk space is required.

* STFAUX.EXE Auxiliary files needed for all STFs and EEO files (updated Jun 1994)
* STFAUX1A.EXE Additional files needed for STF 1A (updated Aug 1993)
* STFAUX1B.EXE Additional files needed for STF 1B (updated Sep 1993)
* STFAUX1C.EXE Additional files needed for STF 1C (updated Aug 1993)
* STFAUX3A.EXE Additional files needed for STF 3A (updated Feb 1994)
* STFAUX3B.EXE Additional files needed for STF 3B (updated Sep 1993)
* STFAUX3C.EXE Additional files needed for STF 3C (updated Aug 1993)
* STFAU3C2.EXE Optional index files for STF 3C that speed access to data for particular MAs, AIANAs or UAs (issued May 1993)
* STFAUX_D.EXE Additional files needed for STF 1D and STF 3D CD-ROM's. Covers both 103rd and 104th Congress CDs. (updated Oct 1996)
* EEOAUXIL.EXE Additional files needed for the EEO file CD-ROMs (updated Sep 1993)
* PL94AUX3.EXE Additional files needed for the PL94-171 discs.

See also the note on creating national files.


County and City Data Book

* CCDAUX94.EXE provides auxiliary files for the 1994 disc. To install, see CCD_READ.TXT.
* CCDBAUX.EXE provides auxiliary files for the 1988 disc. To install, see CCD_READ.TXT.

USA Counties CD-ROMs

* USA96AUX.EXE provides auxiliary files for the 1996 disc (issued Sep 1996). To install, see USA_READ.TXT.
* USA94AUX.EXE provides auxiliary files for the 1994 disc. To install, see USA_READ.TXT.
* USACOAUX.EXE provides auxiliary files for the 1992 disc. To install, see USA_READ.TXT.

County Business Patterns

EXTRACT and auxiliary files are right on the 1992-1993, 1993-1994 and 1994-1995 CD-ROMs.

The 1995-1996 CD-ROM includes an an outdated master catalog that fails to show 1996 files. The following workaround suffices for all files except the US summary (where the total employment is truncated): Start EXTRACT with the command (or create a .bat file)
EXTRACT c d:\auxil c:\extract\work mstr95_6.ctg
where d: is your CD-ROM drive letter.
A more complete fix can be installed using CBPAUX96.EXE. Installation instructions are in CBP96_RD.TXT.
* CBPAUX92.EXE provides auxiliary files for the 1991-92 disc. To install, see CBP92_RD.TXT.
* CBP90SUP.EXE provides auxiliary files needed to correct catalog errors on the 1989-1990 and 1988-1989 discs. To install, see CBP90_RD.TXT.
* CBPAUXIL.EXE provides auxiliary files for all years 1986 to 1993. To install, see CBP_READ.TXT.

See also the note on creating national files.

If EXTRACT's INSTALL utility generates an error message, follow these installation instructions instead.


Consolidated Federal Funds Report

EXTRACT and auxiliary files are right on most CFFR CD-ROMs.

* CFFRAUX.EXE provides auxiliary files for the 1983-1992 disc and corrects a problem on the 1986-1995 disc. To install, read CFFR_RD.TXT.

Foreign Trade--Imports and Exports

EXTRACT works with data sets on CD-ROM, but not on DVD-ROM, due to a difference in the way Windows operating systems deal with the two types of media. To continue using EXTRACT with these data, you must copy the most of the DVD contents to your hard disc or to a network drive and follow these instructions.

EXTRACT and auxiliary files are right on most CDs starting with December 1994 discs (exceptions: 1990-1994 Exports History disc, Mar 1996 Imports disc, 1993-1997 Imports History disc, 1994-1998 Exports History disc, December 2000 Imports disc). EXTRACT does not work with import and export data recorded on DVD.

* FTDEXH98.EXE provides substitute auxiliary files for the 1994-1998 Exports History disc. (Without them, 97 and 98 data are not visible.) To install, read FTD98ERD.TXT.

* FTDIMP98.EXE provides substitute auxiliary files for monthly Imports discs issued for November 1997 through November 1998. Without them, you cannot select detailed data by country. (Indexes that previously sped access to data by country were removed from the CDs starting in November 1997 to accommodate the growing size of the detailed database.) To install, read FTD98_RD.TXT.

* FTDIMH97.EXE provides auxiliary files for the 1993-1997 Imports History disc. To install, read FTD97_RD.TXT.

* FTDAUX.EXE provides auxiliary files for both monthly and historical discs with data prior to December 1994, for the December 2000 Imports disc, and corrections useful for subsequent discs through March 1996. To install, read FTD_READ.TXT.

If EXTRACT's INSTALL utility on the CD-ROM generates an error message, follow these installation instructions instead.


Agriculture Census CD-ROMs

EXTRACT software and auxiliary files are right on the 1992 State and County data CD-ROMs 1a through 1c.

* AG92SSUP.EXE provides supplementary files needed to access the AG_ST_01.dbf (historical summary) on disc 1c. To install, read AG92READ.TXT.

See also the note on creating national files.


Economic Census CD-ROMs

1992 Economic Census CD-ROM 1j is a consistent source for all of the latest auxiliary files. If EXTRACT's INSTALL utility generates an error message, follow these installation instructions instead.

* EC92FIX4.EXE fixes access to all-manufacturing totals on historical geographic area series files for 1987 on 1992 Economic Census, Volume 4, Nonemployer Statistics CD-ROMs.

* CD2BSUPL.EXE 1987 ZIP Code (Disk 2b) users are missing manufactures totals and 2-digit summaries for ZIP codes in part of New York, garbled on the CD. (The file with 4-digit summaries is just fine.) You may either install CD2BSUPL.EXE or else use the replacement for MC87LZ2.dbf that is included on 1987 Economic Census Disc 1e. CD2BSUPL.EXE also installs a corrected SVC87KB.dbf. To install, read CD2BREAD.TXT.

Creating national extracts from CD-ROMs with state by state files

Certain CD-ROMs store information separately in state-specific files: 1990 Census STFs, County Business Patterns, and the 1992 Census of Agriculture. If you need to create a national file from parts of all state files, that can be very tedious with EXTRACT or any other interactive software, where you have to perform the same operation 50 times. Users with access to Visual dBase or dBase III+, and willing to dabble with a little programming, can adapt allstate.prg to perform the repetitive operations for you.

Other CD-ROMs from which EXTRACT auxiliary files can be installed

The following CD-ROMs include auxiliary files for other discs (e.g., 1990 STFs) available as of the date of issue.

Census of Agriculture, 1992, discs 1a, 1b, 1c
County Business Patterns, 1992-1993
US Imports of Merchandise (1995 and later)
US Exports of Merchandise (1995 and later)
Consolidated Federal Funds report, 1984-1993

Certain of the most recent auxiliary files, such as for the County and City Data Book, 1994, or USA Counties, 1994, may not be on these discs.

If EXTRACT's INSTALL utility generates an error message, follow these installation instructions instead.


Census CD-ROMs EXTRACT does not support

EXTRACT does not support a few Census CD-ROMs in dBASE format, because of lack of resources to create the needed auxiliary files:
* TIGER/Census Tract Street Index
* 1990 Census Geographic Identification Code Scheme (GICS)
* 1990 Census STF 1A, 1B and 3A for Puerto Rico
* Comprehensive Housing Affordability Strategy (CHAS)
* 1990 Special Tabulation on Aging (STP 14)

In addition, EXTRACT does not support CDs that do not use dBASE format:
* Statistical Abstract (Lotus 1-2-3, Adobe Acrobat and proprietary formats)
* TIGER/Line
* Landview
* 1990 Census subject report "SSTF" CD-ROMs
* 1990 County-to-County Migration
* 1990 School District Data Book
* 1990 Census Public-Use Microdata
* MICRODATA from the Current Population Survey, American Housing Survey, Survey of Income and Program Participation, Residential Finance Survey, and Truck Inventory and Use Survey
* Agriculture Specialty Publications (some 1-2-3, some ASCII, only one file in dBASE)
* Agriculture Atlas (Map Image Metafile format)
* 1992 Census of Governments, Finance Statistics (Preliminary)
* U.S. Exports Commodity Classifications (coding manual in proprietary format)

revised 08/21/01