Age, Race, Sex and Ethnicity, by tract for San Diego county

sandiegodata.org-demographics-tract-1.1.1. Modified 2020-11-26T02:47:27

Resources

• tracts. San Diego county tract boundaries
• age_sex. Age and sex per San Diego tract
• total_populaltion. Total population of San Diego tracts
• raceeth. Race and Ethnicity for SaN Diego tracts

Documentation

The dataset includes three files all from the Census, detailing age and sex and race ethnicity. All of the files are built from Census data; see the References section for the specific dates and releases.

Maps Cenus zip-code tabulation areas to Counties

census.gov-zcta_county-2.1.2. Modified 2022-04-25T18:11:42

Resources

• county_zcta. County to Zcta Crosswalk

Documentation

This file links Ztca regions – the Census version of ZIP codes, to counties, by associating a Zcta with the county that contains the Zctas centroid.

There are only about 1/2 the number of Zctas in this file ( 33K ) as there are ZIP codes ( about 77K )

Caveats

Note that the ZCTA regions are joined to counties after converting the geometries to EPSG 4326 (WGS84), from the original 4269 (NAD 83). The discrepancy between these CRS is only a few meters, so this should not make a difference.

Crime incidents in San Diego, from 2016 though July 2020 inclusive, with UCR codes for the crime and the age, race and sex of the victim and suspect.

sandiegodata.org-crime_victims-1.1.3. Modified 2020-11-22T23:31:33

Resources

• sdcrime_16_20. San Diego crime suspects and victims, 2016 to 2020
• ucrcodes. UCR codes and detailed descriptions

Documentation

This dataset describes crime incidents from 2016 to 2020, with demographic information for both the victims and suspects. The file has multiple rows per incident, one for each suspect or victim. The primary key pk links records together into a single crime incident. The dataset is derived from data acquired for a PRA request and is processed to standardize geographic identifiers and racial categories.

Multi-year CRA disclosures for small business originations, per county, year and bank.

ffiec.gov-cra_disclosure-1996e2009-d11-3.1.1. Modified 2020-10-23T19:30:39

Resources

• sb_loan_orig. Table D1-1, small business disclosure records, for years 1996 through 2009

Documentation

The Community Reinvestment Act was enacted by congress in 1997 to encourage investment in underserved communities. The Act requires lenders record and publish data about loans on a per-community basis, specifically, Census tracts and MSAs. The Disclosure reports record individual lender’s loans for MSAs, broken out by loan value and the Median Family income of tracts.

Crime Victims in San Diego, from 2016 though July 2020, with UCR codes for the crime and the age, race and sex of the victim.

arjis.org-crime_victims-pra-1.1.1. Modified 2020-09-30T16:40:33

Resources

• sdcrime_16_20_allyears. San Diego crime suspects and victims, 2016 though July 2020,all records
• sdcrime_16_20_nosusp. San Diego crime victims, 2016 though July 2020, no suspects
• sdcrime_16_20_uniquecase. San Diego crime victims, 2016 though July 2020, unique case numbers
• ucrcodes. UCR codes and detailed descriptions

Documentation

There are important national conversations going on about criminal justice reform, aligning resources towards prevention and community support rather than primarily for policing, and calls to Defund or Abolish the Police. These are all valuable discussions about the communities in which we want to live. An important voice in that conversation is the voice of victims of crime. The data below is a complete data set for victims of violent crime from ARJIS (Automated Regional Justice Information System) for San Diego County, the nation’s fifth largest County, from 2016 through 2020. The complete data set, a cleaned version of the data, a data dictionary, the Public Records Act request on which the data was based and several maps are provided for review. A full conversation requires diverse voices and will help ensure that resources are realigned in a way that furthers the dual aims of equity and safety in our communities.

An Extract from the survey of consumer finances for studying networth and ineritance, from multiple years

federalreserve.gov-consumer_finances-2016e2019-inherit-1.2.6. Modified 2020-12-23T22:43:08

Resources

• inherit_scf_16_19. Extract of the 2016 and 2019 SCF for inheritance and networth,uninflated
• inherit_scf_16_19_i. Extract of the 2016 and 2019 SCF for inheritance and networth, inflated to 2020 dollars

Documentation

This is an extract of the 2016 and 2019 Survey of Consumer Finances, with extracted variables and recoded variables oriented toward studying inheritance.

Multi-year CRA disclosures for small business originations, per county, year and bank, for years 2010 on.

ffiec.gov-cra_disclosure-2010e-d11-2.1.1. Modified 2020-10-18T04:02:20

Resources

• sb_loan_orig. Table D1-1, small business disclosure records, for years 2010 to current

Documentation

The Community Reinvestment Act was enacted by congress in 1997 to encourage investment in underserved communities. The Act requires lenders record and publish data about loans on a per-community basis, specifically, Census tracts and MSAs. The Disclosure reports record individual lender’s loans for MSAs, broken out by loan value and the Median Family income of tracts.

References to the Survey of Consumer Finances

federalreserve.gov-consumer_finances-1.2.4. Modified 2020-12-22T22:08:50

Documentation

The data package provides references to the main SCF files. The package does not contain data.

• How Does Intergenerational Wealth Transmission Affect Wealth Concentration?
• The Dynamics of the Racial Wealth Gap

Feiveson and Sabelhaus calculate that 26% of welath is due to transfers, because they assume that all of the transfer is invested at 3%. THis is clearly nonsense0

The Atlas of Rural and Small-Town America provides statistics by broad categories of socioeconomic factors incluiding people, jobs, county characteristics, income, and veterans.

usda.gov-rural_atlas-1.1.1. Modified 2020-08-12T04:37:06

Resources

• jobs. Unemployment rates, labor force participation
• people. General demographics, such as population, race, ethinicity and migration.
• vets. Population of veterans, racial demographics, and when served.
• income. Median incomes and poverty rates
• counties. Classification of Counties for poverty, urban vs rural, poverty rates and economic structures.

Documentation

Source Document Notes

The following notes are included from the RuralAtlasData22.xls file.

Counts of FFEIC distressed tracts, by county.

civicknowledge.com-distressed-county-1.1.5. Modified 2020-08-12T04:36:30

Resources

• distressed_counties. Aggregation of FFEIC distressed tracts into counties

Documentation

The FFEIC publishes a very large dataset of Census variables and flags indicating ways in which housing and populations in tracts are distressed. This dataset aggregates those tract flags into counts of distressed tracts per county.

Documentation Links

• Documentation Page

Images

• Percentage of Poverty Distressed Population Per County

Contacts

• Wrangler

Eric Busboom, Civic Knowledge