Home > Data Services > Catalog . Restricted Data . Census . ACS

Search Data Services

Meta Search
search across all the following databases:

Data Catalog
Data and documentation

KnowledgeBase
Common questions and answers.

Resources
Entire collection of data resources.


Latest Data News

RSS Feed icon

Sage Stats and CQ Political Stats Trial

Breaking News: Protect the 2020 Census

The Fastest Growing US Cities Are Mostly In the West

Another rule from NIH: Demographers might get to ignore this one

Research on Health Disparities: Incarceration Matters

Data Services Knowledge Base

Q:  

I need many tables from the summary census data for 1990 at the census tract and block group level. I find American FactFinder difficult to use because I can only get data for a single tract at a time. I need all census tracts and block in Los Angeles county. Is there a better solution?

A:  

The easiest way to get data for many units of geography for the 1990 data is to use a statistical package. Here is an example from SAS the first 10 or so tables you want:

filename sf90 PIPE 'zcat 
 /usr/data/level2/data/s436/s436_ca06.Z';
data LA;
infile sf90 lrecl=7925;
input sumlev 11-13  blkgrp 51 @52 tract $char6. county 72-74 
P1 301-309  P4 337-345  P5 346-354  @409 (P8c1-P8c5) (9.)
@454 (P9c1-P9c25) (9.) P10 679-687 @688 (P11c1-P11c16) (9.)
@832 (P12c1-P12c10) (9.) @1201 (P14c1-P14c31) (9.)
@4612 (P17c1-P17c15) (9.) @4918 (P20c1-P20c35) (9.)
@5233 (P21c1-P21c7) (9.) @5539 (P24c1-P24c14) (9.)
@5764 (P27c1-P27c12) (9.) @7897 (P38c1-P38c3) (9.) #2
@301 (P38c4-P38c8) (9.) #4;
if county ne 37 then delete;
data tract;
  set LA;
if sumlev ne 140 then delete;
file 'LA-tracts' lrecl=1646;
   put @1 tract $char6.  P1 9-17  P4 18-26  P5 27-35
@36 (P8c1-P8c5) (9.) @81 (P9c1-P9c25) (9.) P10 306-314
@315 (P11c1-P11c16) (9.) @459 (P12c1-P12c10) (9.)
@549 (P14c1-P14c31) (9.) @828 (P17c1-P17c15) (9.)
@963 (P20c1-P20c35) (9.) @1278 (P21c1-P21c7) (9.)
@1341 (P24c1-P24c14) (9.) @1467 (P27c1-P27c12) (9.)
@1575 (P38c1-P38c8) (9.);
data blkgrp;
   set LA;
if sumlev ne 150 then delete;  
file 'LA-blkgrp' lrecl=1646;
 put @1 tract $char6. blkgrp 7-7 P1 9-17  P4 18-26  P5 27-35
@36 (P8c1-P8c5) (9.) @81 (P9c1-P9c25) (9.) P10 306-314
@315 (P11c1-P11c16) (9.) @459 (P12c1-P12c10) (9.) 
@549 (P14c1-P14c31) (9.) @828 (P17c1-P17c15) (9.) 
@963 (P20c1-P20c35) (9.) @1278 (P21c1-P21c7) (9.)
@1341 (P24c1-P24c14) (9.) @1467 (P27c1-P27c12) (9.)
@1575 (P38c1-P38c8) (9.);
run;

Annotated Resources:

Related Question Groups: