County

Dataset

Description

A county is the largest territorial division for local government in the US. There are a total of 3,144 counties. in the US.

County Use

When administering properties, counties are typically recognized as being the next level below states. States may set some laws governing the ownership and transfer of properties, but it is usually up to individual counties to administer land ownership and transfer. Parcels of land must fit within the boundaries of a county.

Naming

While the term county is used in most states, Alaska uses the term borough and Louisiana uses the term parish.

Independent Cities

There are presently 41 independent cities in the US that are not considered to be part of a county. Of these, 38 are in Virginia. The other three cities are Baltimore MD, Carson City NV, and ST Louis MO. ATTOM has created additional (pseudo)counties to handle properties located in independent cities.

County Aggregations

The US Government has defined geographic areas comprising multiple counties that are considered to be economically connected. These include:

• Combined Statistica Area (CSA) - Defined by the Office of Management and Budget (OMB) as a collection of MSAs and µSA that demonstrate economic and social linkages and having an employment interchange of at least 15%.
• Core-Based Statistical Area (CBSA) - Defined by the Office of Management and Budget (OMB) as an urban area of at least 10,000 people that are socioeconomically tied to the urban center based on the patterns for commuting.

Tables/Views

The following tables can be used to access County information. When delivering solutions to customers, some or all of the information found in these tables may be consolidated into one or more views.

DimCounty

Profile for each county (or county equivalent). Includes details of any CSA or CBSA to which they belong.

Rows: 3.2K
Columns: 27
Family: Boundary
Type: Area
Geography Type: 37

DimCountySubdivision

Profile of county subdivisions, which include census collection divisions (CCDs), census subareas, minor civil divisions (MCDs), and unorganized territories. Each county has one or more subdivisions. They are established cooperatively by the Census Bureau, State government, and local government. Minor Civil Divisions are organized around towns and townships, with census collection units defined for other areas. Census subareas are used in Alaska, where there are no counties and no minor civil divisions.

Rows: 
Columns: 
Family: Boundary
Type: Area
Geography Type: 38

Dimension Tables

This dataset does not make use of any additional dimension tables

Demographics by CBSA and County

/*
 * ATTOM Cloud Sample Query
 * 
 * Selected demographics by county for each CBSA
 * 
 * Datasets
 * 	County
 * 	Demographics
 * 	Geocodes
 */
Select
	Dc.CBSAName As CBSA,
	cd.GeographyName As 'County',
	cd.population,
	cd.Population_5_Yr_Projection,
	cd.Households,
	cd.Households_5_Yr_Projection,
	cd.Population_In_Poverty_Pct,
	cd.Householder_Median_Age,
	cd.Housing_Units_Renter_Occupied,
	cd.Avg_Household_Income
	
From adw.CommunityDemographics cd 
Left Join Adw.DimCounty dc on cd.GeoID = dc.CountyGeoID 

Where cd.GeographyTypeKey = 37 And CBSAName is not NULL 

Order By dc.CBSAName, cd.GeographyName