USER'S GUIDE

Ethington, Kooistra, and DeYoung

Los Angeles County Union Census Tract Data Series, 1940-1990

© 2000 University of Southern California.

Version 1.01

Release Date 7 July 2000

 

Introduction:

Ethington, Kooistra and DeYoung, Los Angeles County Union Census Tract Data Series, 1940-1990 was created with the support of a grant from the John Randolph Haynes and Dora Haynes Foundation. It is published and distributed by the University of Southern California to facilitate a wide range of research on the development and condition of Los Angeles County. Los Angeles County, the largest county in the United States, is of great interest to researchers from all disciplines of the human and natural sciences. Until now, no uniform census data were available to chart the development of this important metropolitan region through the period of its most important changes and critical decades. This data set is organized with the goal of providing maximum uniformity and comparability across all census years and census geographies. It includes aggregate data describing the characteristics of U.S. Census Tracts for race-ethnicity, occupation, education, housing, age and median household income, house value, and rent. It was assembled from two principal sources: 1) the print-published US Census tables for the years 1940, 1950 and 1960, and 2) the digitally distributed "Correspondence" data files created by the California State Department of Finance for the years 1970, 1980, and 1990. All data have been proportionally aggregated to fit the 1990 census tract geography. The boundary data are provided in ESRI's ArcView© shapefile format, and the numeric data are provided in the standard dBase© spreadsheet data file format (.dbf).

Citation and Use:

No fee is charged for the use of these data, and no fee may be charged for use or distribution. Publications and reports based on the data set must site it properly. The citation must include the following:

Philip J. Ethington, Anne Marie Kooistra, and Edward DeYoung, Los Angeles County Union Census Tract Data Series, 1940-1990, Version 1.01. Created with the support of the John Randolph Haynes and Dora Haynes Foundation. (Los Angeles: University of Southern California, 2000).

In addition, we request that users send us a copy of any publications, research reports, or educational material making use of the data or documentation. Printed matter should be sent to:

Philip J. Ethington

Department of History

University of Southern California

Los Angeles, CA 90089-0034

Electronic material or URLs for web sites should be sent to:

philipje@usc.edu

Documentation:

All available documentation for these data are included in this User's Guide document. No further support is available, but improved releases are planned, and users are invited send comments to the Principal Investigator, Philip J. Ethington, at philipje@usc.edu.

Format:

Ethington, Kooistra and DeYoung, Los Angeles County Union Census Tract Data Series, 1940-1990, Version 1.0, consists of a single table of 1,656 records (rows) and 252 variables (columns). The main data table, called la4090v101.dbf is in dBase IV © format and may be converted to any other format for quantitative analyses. The data set also includes the associated ArcView © shapefile to utilize these data in a Geographic Information System (GIS). These files must be kept together. They are called la4090v101.sbn, la4090v101.sbx, la4090v101.shp, and la4090v101.shx. ArcView © uses the la4090v101.dbf file as its "attribute table." Care should be taken when altering this file so that the shapefile continues to function with it. We recommend copying and renaming the main data file before beginning alterations.

Missing Data:

Missing data are only certain as such if the cell is empty. Users must beware of vestigial sources of missing data, however, in for the form of zero values. These are most likely to occur in the "median value" variables. Data were taken directly from the sources listed below. If the source reported zero, we collected that value, even though a zero median home value might be highly unlikely. Users must use their own judgement as to when and whether to code these zeroes as missing. Users must also beware of the blank cells when converting these data to other formats, because some software does not support empty cells.

Universe:

The data in la4090v101.dbf were prepared over the course of a four-year project, with the goal of assembling consistently comparable data from each of the six census years, 1940, 1950, 1960, 1970, 1980, and 1990. It is also intended that these data can be expanded backwards and forwards in time. Due to resource limitations, not all available tract-level data could be collected. The uniform method of collecting these data, however, make it possible to augment the data, so long as additions can be aggregated by census tracts. Further, not all variables are available in all census years. A core set of "union" variables, describing race-ethnicity, occupation, education, and median home rent and value information are available across all census years. In general, there are more variables describing occupations in the 1940-1960 years, and more variables describing median income, age, and marital characteristics in the 1970-1990 years.

The table below lists the variables by their generic variable names, and shows which are available for each year.

Sources:

The data in this data set were drawn from the following sources:

U.S. Bureau of the Census, Sixteenth Census of the United States: Population and Housing Statistics for Census Tracts. Los Angeles-Long Beach, California. (Wash, DC: GPO, 1942).

U.S. Bureau of the Census, U.S. Census of Population: 1950 Vol. III, Census Tract Statistics, Chapter 28 Los Angeles California and Adjacent Area Selected Population and Housing Characteristics (Wash, DC: US GPO, 1952).

U.S. Bureau of the Census, U.S. Censuses of Population and Housing: 1960 Census Tracts Final Report PH(1)082 Los Angeles-Long Beach, California. Standard Metropolitan Statistical Area (Wash, DC: US GPO, 1962).

State of California, Department of Finance 1970-1980-1990 Correspondence Data Series (Sacramento: California State Census Data Center, 915 L. Street, Lower level, Sacramento, California, 95814, 1996).

Methods:

The unique feature of the Ethington, Kooistra and DeYoung, Los Angeles County Union Census Tract Data Series, 1940-1990 is that all data can be studied according to a common geography for every year, from 1940 through 1990. In order to achieve this uniformity, all data were fitted to the geography of the 1990 census tracts. Census data or the years 1940, 1950, and 1960 were originally collected and stored in GIS shapefiles according to the census tract boundaries of those years. The 1970 1980 and 1990 data had already been fitted to the 1990 tracts by the California State Department of Finance (see specific methods below). We performed the fitting operation on the 1940, 1950, and 1960 data by imposing the 1990 tract boundaries on top of the boundaries for each of those years, and, using the "Union" function in ArcInfo ©, calculated a proportional distribution of data into the 1990 tracts. Obviously, certain assumptions and drawbacks are involved in this method. For the most part, census tracts in earlier years were geographically larger than those in following years. Thus, a 1940 tract with 1000 persons might have been split the Census Bureau into two or more tracts in 1950, to reflect growing population, again in 1960, and so on through 1990. Those original 1000 persons are assumed by our method to be spread uniformly across the space of the 1940 tract, and to land proportionally, by area, in the 1990 tracts that overlay that 1940 tract. Thus, assume that hypothetical 1940 Tract A was split over the years into five 1990 tracts, called Tract V, W, X, Y, and Z. Tract A was 100 square kilometers. 1990 Tract V lies completely within 1940 Tract A, and is 25 square kilometers. 1990 Tract W also lies completely within 1940 Tract A, and is 30 square kilometers. 1990 Tract X, Y, and Z lie both inside and outside of 1940 Tract A, however. Only 2% 1990 Tract X lies within 1940 Tract A (call that 2 square kilometers), 50% of Tract Y lies within 1940 Tract A (call that 30 square kilometers), and 80% of 1990 Tract Z lies within 1940 Tract A. The following person counts would have been assigned to the 1990 tracts: V=250; W=300; X=20; Y=300; Z=130. Note that 1990 Tracts X, Y, and Z will also pick up data assigned from the other 1940 tracts they overlap.

The 1970 and 1980 data were fitted to the 1990 census tracts by a different method. Below we have reproduced verbatim the State Department of Finance's description of its method:

" The 1970 – 80 – 90 database was created to simplify thematic mapping of historical California data for the years 1970, 1980 & 1990. The data for all three years are assigned to 1990 census tracts. Census geography has changed since 1970 making the process of relating 1970/1980 data to 1990 census tracts more difficult. The result of this effort, however, eliminates much of the difficulty and allows the user to easily compare census tract data between 1970 and 1990. The data, as assigned to 1990 census tracts, will accurately depict the demographic and economic changes for this period.

To help the user of this file better understand the relationship of 1990 census tracts and the 1970/1980 geography, a correspondence file is available that indicates how the 1970-1980 data were assigned to 1990 census tracts. If the user wanted to produce a tabular report of the data for 1970 or 1980, beware of the fact that the data cannot be considered OFFICIAL U.S. Census Bureau data or California Department of Finance data.

There are seven possible types of geographical changes between 1970 and 1990:

    1. A census tract existed in 1970 and has not been subdivided:

    1970

    1980

    1990

    0001

    0001

    0001

    The actual data appears for this tract in each year.

  1. A census tract existed in 1970 and was subdivided in 1980:

    1970

    1980

    1990

    0001

    0001.01

    0001.01

    0001

    0001.02

    0001.02

  2. A census tract existed in 1970 and was subdivided in 1980 and 1990:

    1970

    1980

    1990

    0001

    0001.01

    0001.11

    0001

    0001.01

    0001.12

    0001

    0001.02

    0001.21

    0001

    0001.02

    0001.22

    The actual data appears for these tracts in 1990 only. The 1980 data were assigned to the 1990 tracts based upon the population split of the 1990 tracts. The 1970 data was assigned to the four 1990 census tracts based upon the population split of the two subdivided 1980 tracts. The 1982 and 1970 medians are assigned without change.

  3. A census tract existed in 1970 and was subdivided in 1990:

    1970

    1980

    1990

    0001

    0001

    0001.01

    0001

    0001

    0001.02

    0001

    0001

    0001.03

    The actual data appears for this tract in1990 only. The 1980 and 1970 data were assigned to the three 1990 tracts based upon the population split of the three 1990 tracts. The 1980 and 1970 medians are assigned without change.

  4. A census tract existed in 1970 and was merged with another tract in 1990:

    1970

    1980

    1990

    0001.01

    0001.01

    0001

    0001.02

    0001.02

    0001

    In this situation the 1970 and 1980 data are aggregated and the medians are re-calculated.

  5. Actual adjustments (other than subdivision) were made to a census tract boundary in 1980 and/or 1990. In these situations the boundary adjustments have been ignored. The assumption is that these changes are insignificant in respect to thematic mapping purposes and do not distract from interpreting change between 1970 and 1990 in a particular geographic area. Users must be cautioned that the boundaries in this file accurately describe 1990 census tract areas BUT may not accurately describe 1980 or 1970 census tract areas.
  6. Census tracts did not exist in 1970 and/or 1980. In this situation Enumeration districts (Eds) or Census County Divisions (CCDs) were matched to 1990 tracts according to the following steps:

Step one. Determine all census county divisions (CCDs) that match directly with 1990 tracts. For the remaining areas go to step two.

Step two. Determine enumeration districts (one or more) that match directly with 1990 tracts. For the remaining areas go to step three.

Step three. Determine enumeration districts (one or more) that closely match with 1990 tracts. For the remaining areas go to step four.

Step four. Using CCDs as a geographical control, match 1970/1980 enumeration districts to 1990 census tracts based upon median family income and the percent non-white population."

Data Dictionary

Below is a table with short descriptions of all variables. The "YY" in variable names stands for the census year: "40" (or 50, 60, etc) will appear in place of the YY in the variable containing the 1940 (or 1950, 1960, etc) data for that variable, if available.

This table is hyperlinked to the detailed data descriptions for each variable. Users are strongly recommended to read the extended descriptions carefully before analyzing these data.

Ethington, Kooistra, and DeYoung

LOS ANGELES COUNTY UNIFIED CENSUS DATA SERIES, 1940-1990

(Shaded variables indicate consistent availability for all years)

VARIABLE NAMES

SHORT DESCRIPTION

AVAILABILITY

(X=YES)

VARIABLES

SUBTOTAL VARIABLES

1940

1950

1960

1970

1980

1990

CTBNA CENSUS TRACT NUMBER

X

X

X

X

X

X

PYYT POPULATION TOTAL

X

X

X

X

X

X

PYYWNH POPULATION WHITE NON HISPANIC

X

X

X

X

X

X

PYYBNH POPULATION BLACK NON HISPANIC

X

X

X

X

X

X

PYYONH POPULATION OTHER NON HISPANIC

X

X

X

X

X

X

PYYHIS POPULATION HISPANIC

X

X

X

X

X

X

PYYTW POPULATION TOTAL WHITE

X

X

X

no

no

no

PYYNATW POPULATION NATIVE WHITE

X

X

no

no

no

no

PYYFBW POPULATION FOREIGN-BORN WHITE

X

X

no

no

no

no

PYYTOTNW POPULATION TOTAL NON-WHITE

X

X

X

no

no

no

PYYB POPULATION BLACK, NON-WHITE

X

X

X

no

no

no

PYYNBNW POPULATION OTHER NON-WHITE

X

X

X

no

no

no

PYYSST POPULATION TOTAL WITH SPANISH SURNAMES

no

X

X

no

no

no

PYYSSN POPULATION NATIVE WITH SPANISH SURNAMES

no

X

X

no

no

no

PYYSSFB POPULATION FOREIGN-BORN WITH SPANISH SURNAMES

no

X

X

no

no

no

PYYMEX POPULATION BORN IN MEXICO

X

X

X

no

no

no

PYYCSA POPULATION BORN IN CENTRAL OR SOUTH AMERICA

X

X

no

no

no

no

EYYH EDUCATION COMPLETED HIGH SCHOOL

X

X

X

X

X

X

EYYC EDUCATION COMPLETED COLLEGE

X

X

X

X

X

X

OYYWC OCCUPATION WHITE COLLAR

X

X

X

X

X

X

OYYBC OCCUPATION BLUE COLLAR

X

X

X

X

X

X

OYY01 OCCUPATION WAGE WORKERS TOTAL

X

X

X

no

no

no

OYY01M OCCUPATION WAGE WORKERS MALE

no

X

no

no

no

no

OYY01F OCCUPATION WAGE WORKERS FEMALE

no

X

no

no

no

no

OYY02 OCCUPATION GOVERNMENT WORKERS TOTAL

X

X

X

no

no

no

OYY02M OCCUPATION GOVERNMENT WORKERS MALE

no

X

no

no

no

no

OYY02F OCCUPATION GOVERNMENT WORKERS FEMALE

no

X

no

no

no

no

OYY03 OCCUPATION SELF-EMPLOYED TOTAL

X

X

X

no

no

no

OYY03M OCCUPATION SELF-EMPLOYED MALE

no

X

no

no

no

no

OYY03F OCCUPATION SELF-EMPLOYED FEMALE

no

X

no

no

no

no

OYY04 OCCUPATION UNPAID FAMILY TOTAL

X

X

X

no

no

no

OYY04M OCCUPATION UNPAID FAMILY MALE

no

X

no

no

no

no

OYY04F OCCUPATION UNPAID FAMILY FEMALE

no

X

no

no

no

no

OYY05 OCCUPATION PROFESSIONAL TOTAL

X

X

X

no

no

no

OYY05PRM OCCUPATION PROFESSIONAL MALE

no

X

X

no

no

no

OYY05PRF OCCUPATION PROFESSIONAL FEMALE

no

X

X

no

no

no

OYY05SPS OCCUPATION SEMI-PROFESSIONAL SUBTOTAL

X

no

no

no

no

no

OYY05PRS OCCUPATION PROFESSIONAL SUBTOTAL

X

no

no

no

no

no

OYY06 OCCUPATION MANAGER TOTAL

X

X

X

no

no

no

OYY06M OCCUPATION MANAGER MALE

no

X

X

no

no

no

OYY06F OCCUPATION MANAGER FEMALE

no

X

X

no

no

no

 

VARIABLE NAMES

SHORT DESCRIPTION

AVAILABILITY (X=YES)

VARIABLES

SUBTOTAL VARIABLES

1940

1950

1960

1970

1980

1990

OYY07 OCCUPATION CLERICAL/SALES TOTAL

X

X

X

no

no

no

OYY07CLM OCCUPATION CLERICAL MALE

no

X

X

no

no

no

OYY07CLF OCCUPATION CLERICAL FEMALE

no

X

X

no

no

no

OYY07SLM OCCUPATION SALES MALE

no

X

X

no

no

no

OYY07SLF OCCUPATION SALES FEMALE

no

X

X

no

no

no

OYY08 OCCUPATION CRAFT TOTAL

X

X

X

no

no

no

OYY08M OCCUPATION CRAFT MALE

no

X

X

no

no

no

OYY08F OCCUPATION CRAFT FEMALE

no

X

X

no

no

no

OYY09 OCCUPATION OPERATIVES TOTAL

X

X

X

no

no

no

OYY09M OCCUPATION OPERATIVES MALE

no

X

X

no

no

no

OYY09F OCCUPATION OPERATIVES FEMALE

no

X

X

no

no

no

OYY10 OCCUPATION DOMESTIC TOTAL

X

X

X

no

no

no

OYY10M OCCUPATION DOMESTIC MALE

no

X

X

no

no

no

OYY10F OCCUPATION DOMESTIC FEMALE

no

X

X

no

no

no

OYY11 OCCUPATION SERVICE TOTAL

X

X

X

no

no

no

OYY11M OCCUPATION SERVICE MALE

no

X

X

no

no

no

OYY11F OCCUPATION SERVICE FEMALE

no

X

X

no

no

no

OYY12 OCCUPATION LABORERS TOTAL

X

X

X

no

no

no

OYY12M OCCUPATION LABORERS MALE

no

X

X

no

no

no

OYY12F OCCUPATION LABORERS FEMALE

no

X

X

no

no

no

OYY13 OCCUPATION NOT REPORTED TOTAL

X

X

X

no

no

no

OYY13M OCCUPATION NOT REPORTED MALE

no

X

X

no

no

no

OYY13F OCCUPATION NOT REPORTED FEMALE

no

X

X

no

no

no

HYYTOT HOUSING TOTAL UNITS

X

X

X

X

X

X

HYYNWT HOUSING NONWHITE UNITS

X

X

X

no

no

no

HYYOWN HOUSING TOTAL OWNER OCCUPIED UNITS

X

X

X

no

no

no

HYYNWO HOUSING NONWHITE OWNER OCCUPIED UNITS

X

X

X

no

no

no

HYYRNT HOUSING TOTAL RENTER OCCUPIED UNITS

X

X

X

no

no

no

HYYWRN HOUSING WHITE RENTER OCCUPIED UNITS

X

no

no

no

no

no

HYYNRN HOUSING NONWHITE RENTER OCCUPIED UNITS

X

X

X

no

no

no

HYYMVL HOUSING MEDIAN VALUE OF UNIT

X

X

X

X

X

X

HYYMRN HOUSING MEDIAN RENT OF UNIT

X

X

X

X

X

X

INCYYMED MEDIAN FAMILY/HOUSEHOLD INCOME

no

no

no

X

X

X

RYYSHYY RESIDENCE IN YY SAME HOUSE AS FIVE YEARS PREVIOUS

no

no

no

X

X

X

RYYSCYY RESIDENCE IN YY SAME COUNTY AS FIVE YEARS PREVIOUS

no

no

no

X

X

X

RYYOTYY RESIDENCE IN YY OTHER LOCATION THAN SAME HOUSE OR SAME COUNTY, AS FIVE YEARS PREVIOUS

no

no

no

X

X

X

 

VARIABLE NAMES

SHORT DESCRIPTION

AVAILABILITY (X=YES)

VARIABLES

SUBTOTAL VARIABLES

1940

1950

1960

1970

1980

1990

AYY0004 PERSONS AGED 0-4 YEARS

no

no

no

X

X

X

AYY0517 PERSONS AGED 5-17 YEARS

no

no

no

X

X

X

AYY1864 PERSONS AGED 18-64 YEARS

no

no

no

X

X

X

AYY65UP PERSONS AGED 65 YEARS AND UP

no

no

no

X

X

X

AYYMEDN AGE MEDIAN WITHIN CENSUS TRACT

no

no

no

X

X

X

MYYSINGL PERSONS OF MARITAL STATUS SINGLE

no

no

no

X

X

X

MYYMAR PERSONS OF MARITAL STATUS MARRIED

no

no

no

X

X

X

MYYOTH PERSONS OF MARITAL STATUS OTHER

no

no

no

X

X

X

 

Extended Variable Descriptions

(Note: Hyperlinks are not operable in this portion of the document)

NAME AYY0004
SHORT

DESCRIPTION

Persons aged 0 to 4 years.
AVAILABILITY

1940

1950

1960

1970

1980

1990

no

no

no

A700004

A800004

A900004

SOURCE: CSDF, 1970-1990.
FULL DESCRIPTION: Persons aged 0 to 4 years. See also AYY0517, AYY1864, AYY65UP, AYYMEDN.

 

 

NAME AYY0517
SHORT

DESCRIPTION

Persons aged 5 to 17 years.
AVAILABILITY

1940

1950

1960

1970

1980

1990

no

no

no

A705017

A805017

A905017

SOURCE: CSDF, 1970-1990.
FULL DESCRIPTION: Persons aged 5 to 17 years. See also AYY0004, AYY1864, AYY65UP, AYYMEDN.

 

 

 

 

NAME AYY1864
SHORT

DESCRIPTION

Persons aged 18 to 64 years.
AVAILABILITY

1940

1950

1960

1970

1980

1990

no

no

no

A701864

A801864

A901864

SOURCE: CSDF, 1970-1990.
FULL DESCRIPTION: Persons aged 18 to 64 years. See also AYY0004, AYY0517, AYY65UP, AYYMEDN.

 

 

NAME AYY65UP
SHORT

DESCRIPTION

Persons aged 65 years and older.
AVAILABILITY

1940

1950

1960

1970

1980

1990

no

no

no

A7065UP

A8065UP

A9065UP

SOURCE: CSDF, 1970-1990.
FULL DESCRIPTION: Persons aged 65 years and older. See also AYY0004, AYY0517, AYY1864, AYYMEDN.

 

 

NAME AYYMEDN
SHORT

DESCRIPTION

Median age within census tract.
AVAILABILITY

1940

1950

1960

1970

1980

1990

no

no

no

A70MEDN

A80MEDN

A90MEDN

SOURCE: CSDF, 1970-1990.
FULL DESCRIPTION: Median age within census tract. See also AYY0004, AYY0517, AYY1864, AYY65UP.

 

 

 

 

NAME CTBNA
SHORT

DESCRIPTION

Census Tract
AVAILABILITY

1940