Data Sources and Software

Online Data Extraction

• American FactFinder
  Choose the Summary File you need to build a custom table. The best selection option when covering many topics is "Custom Tables."
• New York City
  These products highlight sub-city areas including tracts and community districts. For complete information on NYC data, see the NYC Numeric and Spatial Data page.
  • InfoShare (interactive site for creating custom tables)
  • New York City Planning Department
    - New York City Planning Department Census Tables
        (Excel tables reporting socio-demographic characteristics)
    - New York City Planning, Newest New Yorkers 2000
        (Excel tables analyzing the NYC foreign born population).
• New York State Data Center
  Provides summarized data for the state, counties, communities, and school districts. Demographic profiles are available in csv format.
• Department of Education, School District Demographics
  Select and extract data tables through the web interface at this site, view maps, or download state-wide data in comma delimited format.
• Integrated Public Use Microdata Series (IPUMS)
  At this site custom extractions of public use microdata can be done. For a description of microdata and when it is appropriate to use is refer to the guide on Census Microdata.
• Census Bureau Special Tabulations
  These includes table produced by the census that are not in the Summary Files and some done for other government agencies. Topics here include race, place of birth, migration, worker flow, education, and transportation.

GIS and Mapping Products

• For New York City
  This guide details sources for demographic data for New York together with sources for the corresponding boundary files.
• For the United States
  This pages lists sources for Census boundaries from both a national a New York State perspective.

CD/DVD Products on EDS Network

• Summary File Products from Bureau of Census
  Summary files are published on DVD/CD-ROM together with a powerful Windows-based extraction program for making both simple and complex data requests. All the Summary Files are available with this interface; the most frequently used files are on the DSSC workstations in the Data Apps folder in the Program Menu and the rest can be used in EDS.
• Geolytics CensusCD 2000 ReDistricting File
  This offers Windows-based extraction program for making simple data requests. Has a feature has standard geographies down to the block group plus voting districts and state legislative districts. It is available on the DSSC machines in Data Apps folder within the Program Menu.
• Public Use Microdata (PUMS)
  PUMS data on CD-ROM come with a Windows-based program that for easily doing a cross tabulation using either the 1% or 5% sample. It is available in EDS.

Files for FTP

Because of the size of these files, locally available sources either in DataGate or in EDS on DVD/CD, may be easier to use. Also the structure of the summary files is complex with retrieval of data for a single geography requiring accessing and merging data from multiple files. Extraction software on the DVD/CD products and at American FactFinder can meet most needs.

• DataGate
  Searching for EDS Study ID# 2000 will generate a list of titles for 2000 products. Most titles will reference non-ftp formats (urls or CDs) since these are the usually the most efficient way to access the data. One exception is the PUMS 5%, Study 2000-PA. This study contains files that are subset of census microdata, a file for each of the five boroughs and one for all of NYC.
• Census Bureau's Census 2000 Gateway
  Links to each of the available data products are listed in the "Data Releases" list. Links to the American FactFinder interface for creating custom tables are also given.
• ICPSR Census Home Page
  Committed to archiving all the Census 2000 files, the full files, program code (SAS and SPSS), meta-data, and tips for working with the files are found here. There is a time lag between when files appear here and when they are first published on the Bureau's site.

Overview of Products

This section explains the way the files were published regardless of the access methods as described above. Refer to the Census Bureau's 2000 Census Overview for a breakdown of what was asked on the short and long form.

Selected Products From the Short Form

Counts reported from the short form represent exact counts as these questions were asked of 100% of the population. They are reported on the following products:

• Re-Districting File (PL-94)
  Selected topics tabulated for the purpose of congressional reapportionment.
• Summary File 1 (SF1)
  Data for all topics tabulated for the nation and by basic race categories and Hispanic/non-Hispanic populations.
• Summary File 2 (SF2)
  Data for all topics tabulated for the nation and by detailed race categories and Hispanic/non-Hispanic populations.
• Demographic Profiles (DP1)
  Preformatted reports summarizing, for named geographic locations, data reported on the short form. Data are derived from SF1.

Selected Products From the Long Form

Counts reported from the long form represent estimated counts based on the large sample of the population asked to complete the long form. The topics cover those asked on the short form plus a wide range socio-demographic topics. They are reported on the following products:

• Summary File 3 (SF3)
  Data for all topics tabulated for the nation and by basic race categories and Hispanic/non-Hispanic populations.
• Summary File 4 (SF4)
  Data for all topics tabulated for the nation for 336 population groups (groups included detailed race and Hispanic origin groups, and selected ancestry).
• Demographic Profiles
  Preformatted reports summarizing, for named geographic locations, data reported on the short form. Data are derived from SF3.
• Microdata
  The responses from individual questionnaires are released as ASCII file called Public Use Microdata (PUMS) For details about microdata, refer the Census 2000 Microdata overview page.
  • PUMS 1% - a sample of 1% of the housing units that filled out the long form questionnaire.
  • PUMS 5% - a sample of 5% of the housing units that filled out the long form questionnaire.

Special Topic Products

These are analysis based on either a subject or geography
  -Worker Flow
  -School Districts
  -Migration
  -Transportation Planning
  -Congressional District (has both 100% and sample data)

Maps and Spatial Data

All the geographies supported by the Census Bureau were originally published in the TIGER® Line Files product. These are the basis for the spatial data products described above.

Census 2000 Data Products At a Glance

A list of all 2000 Data products with their release date, medium in which they are published, and their geographic coverage.

General Information

Documentation Files and Codes

• Complete Technical Documentation (PDF format)
  • Summary File 1
  • Summary File 2
  • Summary File 3
• Census 2000 Microdata Overview
• Geographic Terms and Concepts
• NY County FIPS Codes - Census 2000
• Metropolitan Areas Definitions (current and past lists of MSAs)
• Geographic Correspondence Engine with Census 2000 Geography
• New York State School District Codes
• Place, County Subdivision, and ZCTA Codes
• Obtaining Data by Congressional District

Race and Hispanic Origin

• Sources for Data on Ethnicity
• Coding of Race (from the Population Studies Center, U. of Michigan)
• Tabulating Data on Race and Hispanic Origin from the 2000 Census

Comparing 1990 and 2000

• Comparing Census Data Variables between 2000 and 1990
• Differences between 1990 and 2000 Questionnaires
• Tract Comparison Tables, New York City
• Census Block Relationship Files
• Census Tract Relationship Files
• Significant Changes to Counties: 1970-Present

Columbia Library Holdings

Includes print, CD/DVD, and Internet data resources, plus reference guides and links to useful sites and sources that summarize the results.