County Subdivision Population Density, 2020

What follows is the transcript of this chat as State Planner generated it. It is here to show how the answer above was arrived at: every query State Planner ran, what each one returned, and where the data came from.

transcript.md

↑ Contents

State Planner chat · https://stateplanner.com

State: Washington (WA)
Started: November 6, 2026, 7:35 PM UTC
Runtime: 1 min 40 sec
Status: completed

Prompt

What is the land area in square miles of each Washington county subdivision, and how many people live per square mile?

Model: Anthropic: Claude Opus 5.5 (anthropic/claude-opus-5.5, via openrouter)

Response

How much land each Washington county subdivision covers, and how many people live on it

Washington has 242 county subdivisions. All of them are census county divisions (CCDs), areas the Census Bureau draws only for statistics. None of them has a local government (funcstat = S).

How the figures were built

Land area is the Census TIGER land area (aland_m2), converted to square miles. Water isn't counted.
Population is the 2020 census count. That is a full count, not a survey estimate. The Census Bureau's yearly population estimates only cover subdivisions that have a government, so there are no estimates for Washington's CCDs. Instead I added up the 2020 census counts of the block groups inside each subdivision, placing each block group by a point inside it.
The block groups nest almost exactly inside the subdivisions. All 5,311 block groups were placed and the total comes to 7,705,281, which is the state's 2020 count. Only 13 block groups, with 3,670 people between them, cross a subdivision line by more than 5% of their area.
Density is the 2020 population divided by land area.

County Subdivision Population Density, 2020

Map legend: subdivisions are shaded by people per square mile of land: pale yellow under 10, light green 10–49, teal 50–199, blue 200–999, and dark blue 1,000 or more. Click a subdivision to see its land area, population and density.

Highest density

Subdivision	County	Land (sq mi)	2020 pop.	People per sq mi
Seattle	King	186.8	1,139,259	6,100
Edmonds	Snohomish	58.5	274,548	4,692
Orchards	Clark	16.2	73,318	4,518
Everett	Snohomish	44.3	196,345	4,434
Federal Way-Auburn	King	55.5	192,023	3,459
Tacoma	Pierce	138.9	480,342	3,458
Seattle East	King	216.8	639,295	2,949
Vancouver	Clark	87.8	254,087	2,895

Lowest density

Subdivision	County	Land (sq mi)	2020 pop.	People per sq mi
Hanford Site	Benton	440.4	21	0.05
North Skamania	Skamania	1,378.7	104	0.08
Early Winters	Okanogan	1,056.9	529	0.5
West End	Jefferson	1,103.4	776	0.7
South Benton	Benton	597.6	835	1.4
Starbuck	Columbia	346.2	488	1.4

Size range

Largest: East Whatcom (1,635 sq mi) and South Yakima (1,784 sq mi).
Smallest: Point Roberts (4.9 sq mi) and Puget Island (7.9 sq mi).

Pattern on the map: subdivisions with 1,000 or more people per square mile are in the Puget Sound corridor from Everett to Olympia, plus Vancouver/Orchards, Spokane, Pasco, Longview-Kelso, Mount Vernon, Sedro-Woolley and Ellensburg. Most subdivisions east of the Cascades and in the mountains have fewer than 10 people per square mile.

Full table (all 242 subdivisions)

County	Subdivision	Land sq mi	2020 pop.	Per sq mi
Adams	Lind-Washtucna	1016.3	1,804	1.8
Adams	Othello	286.1	16,230	56.7
Adams	Ritzville	622.6	2,579	4.1
Asotin	Asotin	517.5	4,392	8.5
Asotin	Clarkston	118.6	17,893	150.9
Benton	Benton City	63.7	6,355	99.7
Benton	Hanford Site	440.4	21	0.0
Benton	Northwest Benton	352.0	13,977	39.7
Benton	Richland-Kennewick	246.3	185,685	753.9
Benton	South Benton	597.6	835	1.4
Chelan	Cashmere	324.8	11,462	35.3
Chelan	Chelan	175.5	7,084	40.4
Chelan	Entiat	467.1	1,482	3.2
Chelan	Leavenworth-Lake Wenatchee	982.8	6,930	7.1
Chelan	Malaga	121.8	4,531	37.2
Chelan	Manson	52.9	4,034	76.3
Chelan	Stehekin	710.5	1,179	1.7
Chelan	Wenatchee	85.8	42,372	493.9
Clallam	Agnew-Carlsborg	106.5	11,820	111.0
Clallam	Clallam Bay-Neah Bay	401.1	3,399	8.5
Clallam	Crescent	411.7	3,451	8.4
Clallam	Forks	432.7	6,365	14.7
Clallam	Port Angeles	250.9	31,103	124.0
Clallam	Sequim	135.8	21,017	154.7
Clark	Battle Ground	154.3	72,056	467.0
Clark	Camas	113.5	64,125	565.2
Clark	La Center	73.6	16,547	224.9
Clark	Orchards	16.2	73,318	4518.0
Clark	Ridgefield	33.6	13,669	407.0
Clark	Vancouver	87.8	254,087	2894.7
Clark	Yacolt	149.6	9,509	63.6
Columbia	Dayton	522.4	3,464	6.6
Columbia	Starbuck	346.2	488	1.4
Cowlitz	Castle Rock	274.3	15,981	58.3
Cowlitz	Kalama	41.7	7,271	174.3
Cowlitz	Longview-Kelso	45.5	66,339	1457.5
Cowlitz	Northeast Cowlitz	443.7	2,144	4.8
Cowlitz	Rose Valley	152.0	5,857	38.5
Cowlitz	Woodland	184.0	13,138	71.4
Douglas	Bridgeport	832.2	6,638	8.0
Douglas	East Wenatchee	81.5	33,848	415.6
Douglas	Waterville	905.6	2,452	2.7
Ferry	Colville Reservation	1084.0	1,713	1.6
Ferry	Curlew	304.3	1,291	4.2
Ferry	East Ferry	469.7	1,238	2.6
Ferry	Republic	345.2	2,936	8.5
Franklin	Connell	454.5	9,679	21.3
Franklin	Kahlotus	543.7	1,499	2.8
Franklin	Pasco	34.5	61,826	1794.5
Franklin	Pasco North	209.0	23,745	113.6
Garfield	Pomeroy	204.6	1,430	7.0
Garfield	Snake River	506.2	856	1.7
Grant	Coulee City	485.2	1,483	3.1
Grant	Ephrata-Soap Lake	310.0	19,645	63.4
Grant	George	329.6	3,327	10.1
Grant	Gloyd	103.1	2,304	22.3
Grant	Grand Coulee	40.4	2,150	53.3
Grant	Mattawa-Royal City	634.5	15,058	23.7
Grant	Moses Lake	67.0	39,517	589.7
Grant	Quincy	279.9	10,942	39.1
Grant	Warden	110.0	3,687	33.5
Grant	Wilson Creek	319.9	1,010	3.2
Grays Harbor	Aberdeen-Hoquiam	85.0	32,571	383.1
Grays Harbor	Elma	52.2	7,186	137.7
Grays Harbor	Humptulips	177.2	1,270	7.2
Grays Harbor	Malone-Porter	113.6	1,785	15.7
Grays Harbor	McCleary	38.3	4,110	107.4
Grays Harbor	Montesano	250.7	6,905	27.5
Grays Harbor	Neilton	207.0	557	2.7
Grays Harbor	North River	165.2	579	3.5
Grays Harbor	Oakville	99.5	2,376	23.9
Grays Harbor	Ocean Shores	122.7	8,746	71.3
Grays Harbor	Quinault Reservation	302.3	1,369	4.5
Grays Harbor	Westport	113.8	6,701	58.9
Grays Harbor	Wishkah	174.9	1,481	8.5
Island	Camano Island	39.9	17,356	434.8
Island	Central Whidbey Island	52.6	13,605	258.7
Island	North Whidbey Island	57.1	40,814	714.6
Island	South Whidbey Island	59.1	15,082	255.2
Jefferson	Discovery Bay-Port Townsend	70.3	17,757	252.7
Jefferson	Oak Bay-Port Ludlow	93.8	11,167	119.0
Jefferson	Quilcene Bay-Brinnon	536.2	3,277	6.1
Jefferson	West End	1103.4	776	0.7
King	Enumclaw Plateau	556.3	71,804	129.1
King	Federal Way-Auburn	55.5	192,023	3458.5
King	Issaquah Plateau	79.7	88,088	1105.2
King	Seattle	186.8	1,139,259	6100.0
King	Seattle East	216.8	639,295	2949.3
King	Snoqualmie Valley	893.9	56,276	63.0
King	Tahoma-Maple Valley	89.8	71,875	800.2
King	Vashon Island	37.0	11,055	298.9
Kitsap	Bainbridge Island	27.6	24,825	899.0
Kitsap	Bremerton	135.9	116,318	856.0
Kitsap	Kingston	36.6	12,564	343.3
Kitsap	Port Orchard	119.8	75,331	628.7
Kitsap	Poulsbo	75.2	46,573	619.5
Kittitas	Cle Elum	682.2	7,465	10.9
Kittitas	Ellensburg	17.3	21,224	1229.5
Kittitas	Kittitas	410.2	4,727	11.5
Kittitas	Manastash Ridge	594.4	5,675	9.5
Kittitas	Northeast Kittitas	593.2	5,246	8.8
Klickitat	Dallesport-Klickitat	350.0	4,524	12.9
Klickitat	Goldendale	416.2	7,525	18.1
Klickitat	Horse Heaven Hills Plateau	649.4	949	1.5
Klickitat	White Salmon	244.1	9,279	38.0
Klickitat	Yakama Nation Reservation	211.9	458	2.2
Lewis	Big Bottom	675.1	2,877	4.3
Lewis	Bunker	174.1	3,670	21.1
Lewis	Centralia-Chehalis	58.2	34,206	588.0
Lewis	Ethel	55.1	3,828	69.5
Lewis	Logan Hill	136.0	4,398	32.3
Lewis	Mineral	432.1	4,612	10.7
Lewis	Morton	208.6	2,865	13.7
Lewis	Mossyrock	257.7	5,079	19.7
Lewis	Napavine	41.2	5,983	145.2
Lewis	Newaukum Prairie	21.2	2,923	138.1
Lewis	Toledo-Vader	70.5	4,046	57.4
Lewis	Winlock-Pe Ell	273.0	7,662	28.1
Lincoln	Davenport	546.3	5,037	9.2
Lincoln	Odessa	1026.7	2,987	2.9
Lincoln	Wilbur	737.6	2,852	3.9
Mason	Belfair-Tahuya	105.0	9,439	89.9
Mason	Kamilche	68.4	3,680	53.8
Mason	Shelton	50.2	21,958	437.5
Mason	Skokomish Reservation	8.3	723	87.2
Mason	Timber Lake-Harstine Island	55.3	8,340	150.9
Mason	Union-Grapeview	88.7	14,831	167.3
Mason	West Mason	583.8	6,755	11.6
Okanogan	Brewster-Wakefield	208.8	4,680	22.4
Okanogan	Colville Reservation	1031.8	6,091	5.9
Okanogan	Conconully-Riverside	398.9	2,511	6.3
Okanogan	Early Winters	1056.9	529	0.5
Okanogan	Methow Valley	1025.9	6,353	6.2
Okanogan	Okanogan	33.7	4,036	119.7
Okanogan	Omak	15.6	6,715	431.7
Okanogan	Oroville	1268.5	7,306	5.8
Okanogan	Tonasket	226.3	3,883	17.2
Pacific	Long Beach-North Beach Peninsula	52.7	10,955	207.8
Pacific	Naselle	331.2	2,377	7.2
Pacific	Raymond	300.5	8,385	27.9
Pacific	Willapa Valley	249.0	1,648	6.6
Pend Oreille	Ione-Metaline Falls	672.3	2,079	3.1
Pend Oreille	Newport	727.9	11,322	15.6
Pierce	Buckley	50.9	28,995	570.1
Pierce	Eatonville	211.4	6,418	30.4
Pierce	Fort Lewis-DuPont	120.7	34,248	283.7
Pierce	Gig Harbor Peninsula	54.3	56,353	1037.5
Pierce	Graham-Thrift	106.5	97,274	913.1
Pierce	Key Peninsula-Anderson Island	69.1	15,548	225.1
Pierce	Mount Rainier	732.4	3,900	5.3
Pierce	Puyallup	92.2	181,567	1969.4
Pierce	Roy	91.6	16,485	179.9
Pierce	Tacoma	138.9	480,342	3458.4
San Juan	Lopez	48.1	3,156	65.6
San Juan	Orcas	64.6	6,000	92.8
San Juan	San Juan Island	61.2	8,632	141.0
Skagit	Anacortes	49.6	22,735	458.2
Skagit	Bay View	22.6	3,874	171.6
Skagit	Bow	73.5	6,568	89.4
Skagit	Burlington	18.1	13,427	740.1
Skagit	Clear Lake	23.7	2,155	90.9
Skagit	Conway	63.1	3,873	61.4
Skagit	East Skagit	903.0	5,099	5.6
Skagit	La Conner	32.8	3,521	107.5
Skagit	Lake Cavanaugh	293.0	3,604	12.3
Skagit	Lyman-Hamilton	142.2	3,086	21.7
Skagit	Mount Vernon	21.5	38,580	1794.7
Skagit	Sedro-Woolley	12.7	15,326	1202.4
Skagit	Swinomish Reservation	11.9	3,228	271.0
Skagit	Upper Samish River	62.5	4,447	71.2
Skamania	Carson-Underwood	120.6	4,869	40.4
Skamania	North Bonneville	128.9	5,048	39.2
Skamania	North Skamania	1378.7	104	0.1
Skamania	Stevenson	30.0	2,015	67.1
Snohomish	Arlington	134.4	32,120	239.0
Snohomish	Darrington	651.3	3,282	5.0
Snohomish	Edmonds	58.5	274,548	4692.1
Snohomish	Everett	44.3	196,345	4434.4
Snohomish	Granite Falls	228.2	16,432	72.0
Snohomish	Lake Stevens	15.1	27,232	1800.2
Snohomish	Maltby	47.6	57,605	1210.0
Snohomish	Marysville	42.1	77,689	1846.7
Snohomish	Monroe	59.9	33,467	558.8
Snohomish	Snohomish	77.9	42,329	543.1
Snohomish	Stanwood	140.6	40,097	285.2
Snohomish	Sultan	551.9	15,842	28.7
Snohomish	Tulalip Reservation	34.7	10,969	316.1
Spokane	Airway Heights	182.7	16,869	92.3
Spokane	Amber-Cheney South	249.1	3,795	15.2
Spokane	Cheney-Medical Lake	141.4	27,921	197.5
Spokane	Colbert	151.6	11,807	77.9
Spokane	Deer Park	178.9	35,365	197.7
Spokane	Liberty Lake	32.7	20,321	621.4
Spokane	Mount Spokane	152.5	6,333	41.5
Spokane	Rockford	332.6	3,417	10.3
Spokane	Spokane	206.1	399,752	1939.7
Spokane	Spokane South	58.1	10,309	177.3
Spokane	Valleyford	78.6	3,450	43.9
Stevens	Chewelah	321.9	5,825	18.1
Stevens	Colville	469.9	11,654	24.8
Stevens	Hunters-Gifford	262.0	1,659	6.3
Stevens	Kettle Falls	670.6	7,935	11.8
Stevens	Loon Lake	175.4	11,322	64.5
Stevens	Spokane Reservation	238.0	2,541	10.7
Stevens	Springdale	339.4	5,509	16.2
Thurston	Olympia	124.6	189,652	1522.0
Thurston	Olympia East	69.7	41,062	589.1
Thurston	Olympia West	152.8	20,700	135.4
Thurston	Thurston South	375.4	43,379	115.6
Wahkiakum	Cathlamet	28.5	1,758	61.8
Wahkiakum	Grays River	101.0	864	8.6
Wahkiakum	Puget Island	7.9	929	117.9
Wahkiakum	Skamokawa	125.6	871	6.9
Walla Walla	Burbank	121.3	4,040	33.3
Walla Walla	Eureka Flat	510.5	1,678	3.3
Walla Walla	Touchet	117.7	2,130	18.1
Walla Walla	Waitsburg	450.5	2,947	6.5
Walla Walla	Walla Walla-College Place	70.1	51,789	739.2
Whatcom	Bellingham	145.2	122,006	840.2
Whatcom	Blaine	61.9	22,324	360.5
Whatcom	East Whatcom	1635.2	8,589	5.3
Whatcom	Ferndale	114.2	36,789	322.2
Whatcom	Lummi Island	9.3	934	100.9
Whatcom	Lummi Reservation	20.9	5,748	275.3
Whatcom	Lynden	46.4	20,184	434.9
Whatcom	Point Roberts	4.9	1,191	243.8
Whatcom	Sumas	70.0	9,082	129.8
Whitman	Colfax-Palouse	235.2	5,063	21.5
Whitman	Garfield-Oakesdale	250.5	1,957	7.8
Whitman	LaCrosse	509.0	864	1.7
Whitman	Pullman	191.0	34,988	183.1
Whitman	Rock Lake	608.9	1,722	2.8
Whitman	Rosalia	127.2	1,147	9.0
Whitman	Tekoa	56.9	972	17.1
Whitman	Uniontown	180.5	1,260	7.0
Yakima	Mabton	150.2	3,010	20.0
Yakima	Northeast Yakima	427.7	10,335	24.2
Yakima	Northwest Yakima	1177.6	8,608	7.3
Yakima	South Yakima	1784.3	3,553	2.0
Yakima	Sunnyside	302.2	52,868	174.9
Yakima	Toppenish-Wapato	214.5	27,548	128.4
Yakima	Yakima	237.9	150,806	633.8

These are 2020 census counts, not current figures. If you want present-day density, it's available for counties (from the 2024 county estimates) or for incorporated cities (from the place estimates), but not for these subdivisions.

Exploratory Queries

Query 1 — Check whether Washington subdivisions are statistical and have estimates.

   SELECT (
             SELECT string_agg(DISTINCT funcstat, ',')
               FROM wa_census_county_subdivisions
          ) f,
          (
             SELECT count(*)
               FROM wa_census_local_pop_est
              WHERE geo_type = 'county_subdivision'
          ) n

f	n
S	0

data/turn-1-query-1.csv

Query 2 — Test assigning 2020 block group counts to subdivisions by interior point.

     WITH bg AS (
             SELECT b.geoid,
                    ST_PointOnSurface(b.geom) p,
                    d.pop_total
               FROM wa_census_block_groups b
               JOIN wa_census_bg_decennial d ON d.geoid = b.geoid
                AND d.year = 2020
          ),
          a AS (
             SELECT s.geoid,
                    bg.pop_total
               FROM bg
               JOIN wa_census_county_subdivisions s ON ST_Intersects(s.geom, bg.p)
          )
   SELECT count(*) bgs,
          sum(pop_total) pop,
          count(DISTINCT geoid) subs
     FROM a

bgs	pop	subs
5311	7705281	242

data/turn-1-query-2.csv

Query 3 — Check how many block groups cross subdivision lines.

     WITH bg AS (
             SELECT b.geoid,
                    b.geom,
                    ST_PointOnSurface(b.geom) p,
                    d.pop_total
               FROM wa_census_block_groups b
               JOIN wa_census_bg_decennial d ON d.geoid = b.geoid
                AND d.year = 2020
          ),
          a AS (
             SELECT bg.pop_total,
                    ST_Area(ST_Intersection(s.geom, bg.geom)) / NULLIF(ST_Area(bg.geom), 0) f
               FROM bg
               JOIN wa_census_county_subdivisions s ON ST_Intersects(s.geom, bg.p)
          )
   SELECT count(*) FILTER (
              WHERE f < 0.95
          ) straddle,
          sum(pop_total) FILTER (
              WHERE f < 0.95
          ) straddle_pop
     FROM a

straddle	straddle_pop
13	3670

data/turn-1-query-3.csv

Query 4 — Land area and 2020 population density for each county subdivision.

     WITH bg AS (
             SELECT ST_PointOnSurface(b.geom) p,
                    d.pop_total
               FROM wa_census_block_groups b
               JOIN wa_census_bg_decennial d ON d.geoid = b.geoid
                AND d.year = 2020
          ),
          pop AS (
             SELECT s.geoid,
                    sum(bg.pop_total) pop
               FROM bg
               JOIN wa_census_county_subdivisions s ON ST_Intersects(s.geom, bg.p)
           GROUP BY s.geoid
          )
   SELECT s.basename,
          replace(c.name, ' County', '') county,
          round(s.aland_m2 / 2589988.11::numeric, 1) sqmi,
          p.pop,
          round(p.pop / (s.aland_m2 / 2589988.11::numeric), 1) dens
     FROM wa_census_county_subdivisions s
     JOIN pop p USING (geoid)
     JOIN wa_census_counties c ON c.geoid = s.county_geoid
 ORDER BY county,
          s.basename

basename	county	sqmi	pop	dens
Lind-Washtucna	Adams	1016.3	1804	1.8
Othello	Adams	286.1	16230	56.7
Ritzville	Adams	622.6	2579	4.1
Asotin	Asotin	517.5	4392	8.5
Clarkston	Asotin	118.6	17893	150.9
Benton City	Benton	63.7	6355	99.7
Hanford Site	Benton	440.4	21	0.0
Northwest Benton	Benton	352.0	13977	39.7
Richland-Kennewick	Benton	246.3	185685	753.9
South Benton	Benton	597.6	835	1.4
Cashmere	Chelan	324.8	11462	35.3
Chelan	Chelan	175.5	7084	40.4
Entiat	Chelan	467.1	1482	3.2
Leavenworth-Lake Wenatchee	Chelan	982.8	6930	7.1
Malaga	Chelan	121.8	4531	37.2
Manson	Chelan	52.9	4034	76.3
Stehekin	Chelan	710.5	1179	1.7
Wenatchee	Chelan	85.8	42372	493.9
Agnew-Carlsborg	Clallam	106.5	11820	111.0
Clallam Bay-Neah Bay	Clallam	401.1	3399	8.5
Crescent	Clallam	411.7	3451	8.4
Forks	Clallam	432.7	6365	14.7
Port Angeles	Clallam	250.9	31103	124.0
Sequim	Clallam	135.8	21017	154.7
Battle Ground	Clark	154.3	72056	467.0

25 out of 242 are listed here.

data/turn-1-query-4.csv

Map Layer Queries

People per sq mi of land (2020 census) — colored by "cls": Under 10 (#ffffcc), 10 to 49 (#a1dab4), 50 to 199 (#41b6c4), 200 to 999 (#2c7fb8), 1,000 or more (#253494)

     WITH bg AS (
             SELECT ST_PointOnSurface(b.geom) p,
                    d.pop_total
               FROM wa_census_block_groups b
               JOIN wa_census_bg_decennial d ON d.geoid = b.geoid
                AND d.year = 2020
          ),
          pop AS (
             SELECT s.geoid,
                    sum(bg.pop_total) pop
               FROM bg
               JOIN wa_census_county_subdivisions s ON ST_Intersects(s.geom, bg.p)
           GROUP BY s.geoid
          ),
          t AS (
             SELECT s.geom,
                    s.name,
                    replace(c.name, ' County', '') county,
                    round(s.aland_m2 / 2589988.11::numeric, 1) sqmi,
                    p.pop,
                    round(p.pop / (s.aland_m2 / 2589988.11::numeric), 1) dens
               FROM wa_census_county_subdivisions s
               JOIN pop p USING (geoid)
               JOIN wa_census_counties c ON c.geoid = s.county_geoid
          )
   SELECT geom,
          name AS "Subdivision",
          county AS "County",
          sqmi AS "Land area(sq mi)",
          pop AS "Population(2020 census)",
          dens AS "People per sq mi",
          CASE
                    WHEN dens < 10 THEN 'a'
                    WHEN dens < 50 THEN 'b'
                    WHEN dens < 200 THEN 'c'
                    WHEN dens < 1000 THEN 'd'
                    ELSE 'e'
          END AS cls
     FROM t

Picture: maps/turn-1-subdivision-population-density.png

Used Data Sets

wa_census_bg_decennial — last synced 2026-10-16 · 21,229 rows
wa_census_block_groups — last synced 2026-09-27 · 5,311 rows
wa_census_counties — last synced 2026-09-27 · 39 rows
wa_census_county_subdivisions — last synced 2026-10-09 · 242 rows
wa_census_local_pop_est — last synced 2026-10-15 · 22,926 rows

data/turn-1-query-1.csv

↑ Contents

f	n
S	0

1 row.

data/turn-1-query-2.csv

↑ Contents

bgs	pop	subs
5311	7705281	242

1 row.

data/turn-1-query-3.csv

↑ Contents

straddle	straddle_pop
13	3670

1 row.

data/turn-1-query-4.csv

↑ Contents

basename	county	sqmi	pop	dens
Lind-Washtucna	Adams	1016.3	1804	1.8
Othello	Adams	286.1	16230	56.7
Ritzville	Adams	622.6	2579	4.1
Asotin	Asotin	517.5	4392	8.5
Clarkston	Asotin	118.6	17893	150.9
Benton City	Benton	63.7	6355	99.7
Hanford Site	Benton	440.4	21	0.0
Northwest Benton	Benton	352.0	13977	39.7
Richland-Kennewick	Benton	246.3	185685	753.9
South Benton	Benton	597.6	835	1.4
Cashmere	Chelan	324.8	11462	35.3
Chelan	Chelan	175.5	7084	40.4
Entiat	Chelan	467.1	1482	3.2
Leavenworth-Lake Wenatchee	Chelan	982.8	6930	7.1
Malaga	Chelan	121.8	4531	37.2
Manson	Chelan	52.9	4034	76.3
Stehekin	Chelan	710.5	1179	1.7
Wenatchee	Chelan	85.8	42372	493.9
Agnew-Carlsborg	Clallam	106.5	11820	111.0
Clallam Bay-Neah Bay	Clallam	401.1	3399	8.5
Crescent	Clallam	411.7	3451	8.4
Forks	Clallam	432.7	6365	14.7
Port Angeles	Clallam	250.9	31103	124.0
Sequim	Clallam	135.8	21017	154.7
Battle Ground	Clark	154.3	72056	467.0
Camas	Clark	113.5	64125	565.2
La Center	Clark	73.6	16547	224.9
Orchards	Clark	16.2	73318	4518.0
Ridgefield	Clark	33.6	13669	407.0
Vancouver	Clark	87.8	254087	2894.7
Yacolt	Clark	149.6	9509	63.6
Dayton	Columbia	522.4	3464	6.6
Starbuck	Columbia	346.2	488	1.4
Castle Rock	Cowlitz	274.3	15981	58.3
Kalama	Cowlitz	41.7	7271	174.3
Longview-Kelso	Cowlitz	45.5	66339	1457.5
Northeast Cowlitz	Cowlitz	443.7	2144	4.8
Rose Valley	Cowlitz	152.0	5857	38.5
Woodland	Cowlitz	184.0	13138	71.4
Bridgeport	Douglas	832.2	6638	8.0
East Wenatchee	Douglas	81.5	33848	415.6
Waterville	Douglas	905.6	2452	2.7
Colville Reservation	Ferry	1084.0	1713	1.6
Curlew	Ferry	304.3	1291	4.2
East Ferry	Ferry	469.7	1238	2.6
Republic	Ferry	345.2	2936	8.5
Connell	Franklin	454.5	9679	21.3
Kahlotus	Franklin	543.7	1499	2.8
Pasco	Franklin	34.5	61826	1794.5
Pasco North	Franklin	209.0	23745	113.6
Pomeroy	Garfield	204.6	1430	7.0
Snake River	Garfield	506.2	856	1.7
Coulee City	Grant	485.2	1483	3.1
Ephrata-Soap Lake	Grant	310.0	19645	63.4
George	Grant	329.6	3327	10.1
Gloyd	Grant	103.1	2304	22.3
Grand Coulee	Grant	40.4	2150	53.3
Mattawa-Royal City	Grant	634.5	15058	23.7
Moses Lake	Grant	67.0	39517	589.7
Quincy	Grant	279.9	10942	39.1
Warden	Grant	110.0	3687	33.5
Wilson Creek	Grant	319.9	1010	3.2
Aberdeen-Hoquiam	Grays Harbor	85.0	32571	383.1
Elma	Grays Harbor	52.2	7186	137.7
Humptulips	Grays Harbor	177.2	1270	7.2
Malone-Porter	Grays Harbor	113.6	1785	15.7
McCleary	Grays Harbor	38.3	4110	107.4
Montesano	Grays Harbor	250.7	6905	27.5
Neilton	Grays Harbor	207.0	557	2.7
North River	Grays Harbor	165.2	579	3.5
Oakville	Grays Harbor	99.5	2376	23.9
Ocean Shores	Grays Harbor	122.7	8746	71.3
Quinault Reservation	Grays Harbor	302.3	1369	4.5
Westport	Grays Harbor	113.8	6701	58.9
Wishkah	Grays Harbor	174.9	1481	8.5
Camano Island	Island	39.9	17356	434.8
Central Whidbey Island	Island	52.6	13605	258.7
North Whidbey Island	Island	57.1	40814	714.6
South Whidbey Island	Island	59.1	15082	255.2
Discovery Bay-Port Townsend	Jefferson	70.3	17757	252.7
Oak Bay-Port Ludlow	Jefferson	93.8	11167	119.0
Quilcene Bay-Brinnon	Jefferson	536.2	3277	6.1
West End	Jefferson	1103.4	776	0.7
Enumclaw Plateau	King	556.3	71804	129.1
Federal Way-Auburn	King	55.5	192023	3458.5
Issaquah Plateau	King	79.7	88088	1105.2
Seattle	King	186.8	1139259	6100.0
Seattle East	King	216.8	639295	2949.3
Snoqualmie Valley	King	893.9	56276	63.0
Tahoma-Maple Valley	King	89.8	71875	800.2
Vashon Island	King	37.0	11055	298.9
Bainbridge Island	Kitsap	27.6	24825	899.0
Bremerton	Kitsap	135.9	116318	856.0
Kingston	Kitsap	36.6	12564	343.3
Port Orchard	Kitsap	119.8	75331	628.7
Poulsbo	Kitsap	75.2	46573	619.5
Cle Elum	Kittitas	682.2	7465	10.9
Ellensburg	Kittitas	17.3	21224	1229.5
Kittitas	Kittitas	410.2	4727	11.5
Manastash Ridge	Kittitas	594.4	5675	9.5
Northeast Kittitas	Kittitas	593.2	5246	8.8
Dallesport-Klickitat	Klickitat	350.0	4524	12.9
Goldendale	Klickitat	416.2	7525	18.1
Horse Heaven Hills Plateau	Klickitat	649.4	949	1.5
White Salmon	Klickitat	244.1	9279	38.0
Yakama Nation Reservation	Klickitat	211.9	458	2.2
Big Bottom	Lewis	675.1	2877	4.3
Bunker	Lewis	174.1	3670	21.1
Centralia-Chehalis	Lewis	58.2	34206	588.0
Ethel	Lewis	55.1	3828	69.5
Logan Hill	Lewis	136.0	4398	32.3
Mineral	Lewis	432.1	4612	10.7
Morton	Lewis	208.6	2865	13.7
Mossyrock	Lewis	257.7	5079	19.7
Napavine	Lewis	41.2	5983	145.2
Newaukum Prairie	Lewis	21.2	2923	138.1
Toledo-Vader	Lewis	70.5	4046	57.4
Winlock-Pe Ell	Lewis	273.0	7662	28.1
Davenport	Lincoln	546.3	5037	9.2
Odessa	Lincoln	1026.7	2987	2.9
Wilbur	Lincoln	737.6	2852	3.9
Belfair-Tahuya	Mason	105.0	9439	89.9
Kamilche	Mason	68.4	3680	53.8
Shelton	Mason	50.2	21958	437.5
Skokomish Reservation	Mason	8.3	723	87.2
Timber Lake-Harstine Island	Mason	55.3	8340	150.9
Union-Grapeview	Mason	88.7	14831	167.3
West Mason	Mason	583.8	6755	11.6
Brewster-Wakefield	Okanogan	208.8	4680	22.4
Colville Reservation	Okanogan	1031.8	6091	5.9
Conconully-Riverside	Okanogan	398.9	2511	6.3
Early Winters	Okanogan	1056.9	529	0.5
Methow Valley	Okanogan	1025.9	6353	6.2
Okanogan	Okanogan	33.7	4036	119.7
Omak	Okanogan	15.6	6715	431.7
Oroville	Okanogan	1268.5	7306	5.8
Tonasket	Okanogan	226.3	3883	17.2
Long Beach-North Beach Peninsula	Pacific	52.7	10955	207.8
Naselle	Pacific	331.2	2377	7.2
Raymond	Pacific	300.5	8385	27.9
Willapa Valley	Pacific	249.0	1648	6.6
Ione-Metaline Falls	Pend Oreille	672.3	2079	3.1
Newport	Pend Oreille	727.9	11322	15.6
Buckley	Pierce	50.9	28995	570.1
Eatonville	Pierce	211.4	6418	30.4
Fort Lewis-DuPont	Pierce	120.7	34248	283.7
Gig Harbor Peninsula	Pierce	54.3	56353	1037.5
Graham-Thrift	Pierce	106.5	97274	913.1
Key Peninsula-Anderson Island	Pierce	69.1	15548	225.1
Mount Rainier	Pierce	732.4	3900	5.3
Puyallup	Pierce	92.2	181567	1969.4
Roy	Pierce	91.6	16485	179.9
Tacoma	Pierce	138.9	480342	3458.4
Lopez	San Juan	48.1	3156	65.6
Orcas	San Juan	64.6	6000	92.8
San Juan Island	San Juan	61.2	8632	141.0
Anacortes	Skagit	49.6	22735	458.2
Bay View	Skagit	22.6	3874	171.6
Bow	Skagit	73.5	6568	89.4
Burlington	Skagit	18.1	13427	740.1
Clear Lake	Skagit	23.7	2155	90.9
Conway	Skagit	63.1	3873	61.4
East Skagit	Skagit	903.0	5099	5.6
La Conner	Skagit	32.8	3521	107.5
Lake Cavanaugh	Skagit	293.0	3604	12.3
Lyman-Hamilton	Skagit	142.2	3086	21.7
Mount Vernon	Skagit	21.5	38580	1794.7
Sedro-Woolley	Skagit	12.7	15326	1202.4
Swinomish Reservation	Skagit	11.9	3228	271.0
Upper Samish River	Skagit	62.5	4447	71.2
Carson-Underwood	Skamania	120.6	4869	40.4
North Bonneville	Skamania	128.9	5048	39.2
North Skamania	Skamania	1378.7	104	0.1
Stevenson	Skamania	30.0	2015	67.1
Arlington	Snohomish	134.4	32120	239.0
Darrington	Snohomish	651.3	3282	5.0
Edmonds	Snohomish	58.5	274548	4692.1
Everett	Snohomish	44.3	196345	4434.4
Granite Falls	Snohomish	228.2	16432	72.0
Lake Stevens	Snohomish	15.1	27232	1800.2
Maltby	Snohomish	47.6	57605	1210.0
Marysville	Snohomish	42.1	77689	1846.7
Monroe	Snohomish	59.9	33467	558.8
Snohomish	Snohomish	77.9	42329	543.1
Stanwood	Snohomish	140.6	40097	285.2
Sultan	Snohomish	551.9	15842	28.7
Tulalip Reservation	Snohomish	34.7	10969	316.1
Airway Heights	Spokane	182.7	16869	92.3
Amber-Cheney South	Spokane	249.1	3795	15.2
Cheney-Medical Lake	Spokane	141.4	27921	197.5
Colbert	Spokane	151.6	11807	77.9
Deer Park	Spokane	178.9	35365	197.7
Liberty Lake	Spokane	32.7	20321	621.4
Mount Spokane	Spokane	152.5	6333	41.5
Rockford	Spokane	332.6	3417	10.3
Spokane	Spokane	206.1	399752	1939.7
Spokane South	Spokane	58.1	10309	177.3
Valleyford	Spokane	78.6	3450	43.9
Chewelah	Stevens	321.9	5825	18.1
Colville	Stevens	469.9	11654	24.8

The first 200 of 242 rows.

maps/turn-1-subdivision-population-density.png

↑ Contents

provenance/wa_census_bg_decennial.md

↑ Contents

Provenance: `wa_census_bg_decennial`

This file describes how the rows in PostgreSQL table wa_census_bg_decennial were obtained from an external source: where they were fetched and how fields were renamed and typed. Field meanings are in the mapping table below.

Identity

Table: wa_census_bg_decennial
Family: Census
Display name: Decennial Census by Block Group (1990/2000/2010/2020)
Source URL: https://api.census.gov; 1990: https://www2.census.gov/census_1990/STF1B_ASCII/ and https://www2.census.gov/geo/relfiles/t9t2/
Geometry (source / stored): none
Update cycle: Manual

Pipeline (Census family)

US Census Bureau sources, loaded into 2020 Washington block-group geography.

census_block_groups — TIGERweb MapServer layer 10 (where=STATE='53'), GeoJSON, outSR=4326. County names from api.census.gov. Join key geoid (12 characters).
census_bg_decennial — Census API 2000 / 2010 / 2020 population, race, and housing; 1990 from each block's record in the 1990 Summary Tape File 1B (P1 persons, P10 Hispanic origin by race, P11 age, H1 housing units, H2 occupancy). Older years are standardized onto 2020 block-group boundaries using the Bureau's published block relationship files (target-density weighting; no polygon overlay). 1990 blocks reach 2020 through their 2000 blocks: the 1990 → 2000 files carry no areas, so a split 1990 block is divided by its 2000 blocks' 2000 population, then follows the 2000 weights.
census_bg_acs — ACS 5-year estimates (releases ending 2014, 2019, 2021, 2022, 2023, 2024). Sentinels at or below -1e8 become NULL. There are no _moe columns.

A Census API key is required to fetch the tabular releases. All three tables load together.

Field → column mapping

Source field	Column	Esri type	Description
geoid	`geoid`	varchar(12)	Block group — joins `census_block_groups.geoid`
year	`year`	smallint	Census year: 1990, 2000, 2010 or 2020
pop_total	`pop_total`	integer	Total population
pop_18_plus	`pop_18_plus`	integer	Population 18 years and over
pop_hispanic	`pop_hispanic`	integer	Hispanic or Latino, any race
pop_white_nh	`pop_white_nh`	integer	White alone, not Hispanic
pop_black_nh	`pop_black_nh`	integer	Black or African American alone, not Hispanic
pop_amind_nh	`pop_amind_nh`	integer	American Indian and Alaska Native alone, not Hispanic
pop_asian_nh	`pop_asian_nh`	integer	Asian alone, not Hispanic. NULL in 1990
pop_nhpi_nh	`pop_nhpi_nh`	integer	Native Hawaiian and Other Pacific Islander alone, not Hispanic. NULL in 1990
pop_other_nh	`pop_other_nh`	integer	Some other race alone, not Hispanic
pop_two_plus_nh	`pop_two_plus_nh`	integer	Two or more races, not Hispanic. NULL in 1990
housing_units	`housing_units`	integer	Total housing units
housing_occupied	`housing_occupied`	integer	Occupied housing units
housing_vacant	`housing_vacant`	integer	Vacant housing units
pop_under_18	`pop_under_18`	integer	Population under 18 (derived: `pop_total - pop_18_plus`)
est_share	`est_share`	real	Share of this row that was apportioned rather than counted. `0` = exact; always `0` for 2020
pop_total_lower	`pop_total_lower`	integer	Lower bound on `pop_total` — blocks wholly inside only
pop_total_upper	`pop_total_upper`	integer	Upper bound — plus every straddling block counted in full

Geometry

No geometry column.

Attribution

US Census Bureau. This product uses the Census Bureau Data API but is not endorsed or certified by the Census Bureau.

provenance/wa_census_block_groups.md

↑ Contents

Provenance: `wa_census_block_groups`

This file describes how the rows in PostgreSQL table wa_census_block_groups were obtained from an external source: where they were fetched and how fields were renamed and typed. Field meanings are in the mapping table below.

Identity

Table: wa_census_block_groups
Family: Census
Display name: Census Block Groups (2020, Washington)
Source URL: https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/tigerWMS_Current/MapServer/10
Geometry (source / stored): polygon / geometry(MultiPolygon, 4326)
Update cycle: Manual

Pipeline (Census family)

US Census Bureau sources, loaded into 2020 Washington block-group geography.

census_block_groups — TIGERweb MapServer layer 10 (where=STATE='53'), GeoJSON, outSR=4326. County names from api.census.gov. Join key geoid (12 characters).
census_bg_decennial — Census API 2000 / 2010 / 2020 population, race, and housing. Older years are standardized onto 2020 block-group boundaries using the Bureau's published block relationship files (target-density weighting; no polygon overlay).
census_bg_acs — ACS 5-year estimates (releases ending 2014, 2019, 2021, 2022, 2023, 2024). Sentinels at or below -1e8 become NULL. There are no _moe columns.

A Census API key is required to fetch the tabular releases. All three tables load together.

Field → column mapping

Source field	Column	Esri type	Description
geoid	`geoid`	varchar(12)	Block-group identifier: state+county+tract+block group
state_fips	`state_fips`	varchar(2)	State FIPS — always `53` (Washington)
county_fips	`county_fips`	varchar(3)	County FIPS code
county_name	`county_name`	varchar(60)	County name, e.g. `King`
tract_geoid	`tract_geoid`	varchar(11)	Census tract identifier (first 11 chars of `geoid`)
bg_number	`bg_number`	varchar(1)	Block group number within the tract
namelsad	`namelsad`	varchar(60)	Census name, e.g. `Block Group 2`
aland_m2	`aland_m2`	bigint	Land area, square metres
awater_m2	`awater_m2`	bigint	Water area, square metres
intptlat	`intptlat`	double precision	Internal point latitude (inside the polygon)
intptlon	`intptlon`	double precision	Internal point longitude
geom	`geom`	geometry(MultiPolygon, 4326)	Block-group boundary

Geometry

SRID 4326 (WGS84). GIST index on geom.
Empty / null geometries stored as SQL NULL.

Attribution

US Census Bureau. This product uses the Census Bureau Data API but is not endorsed or certified by the Census Bureau.

provenance/wa_census_counties.md

↑ Contents

Provenance: `wa_census_counties`

This file describes how the rows in PostgreSQL table wa_census_counties were obtained from an external source: where they were fetched and how fields were renamed and typed. Field meanings are in the mapping table below.

Identity

Table: wa_census_counties
Family: Census
Display name: Census Counties (Washington)
Source URL: https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/tigerWMS_Current/MapServer/82
Also from: https://www2.census.gov/programs-surveys/cfs/technical-documentation/geographies/list2022.xlsx
Geometry (source / stored): polygon / geometry(MultiPolygon, 4326)
Update cycle: Yearly

Pipeline

Two Census Bureau sources, joined on the county's 5-digit FIPS code:

Boundaries: TIGERweb tigerWMS_Current layer 82 ("Counties"), where=STATE='53', GeoJSON, outSR=4326, keyset-paged on GEOID.
CFS areas: sheet CFSAreas of the 2022 Commodity Flow Survey county list, the Washington rows (ST = 53). Only the 2022 columns are kept.

The two must name the same counties, or the sync fails. FAF's wa_faf_county_xwalk is built from this table: each county's cfs_geoid is the CFS22_ID of one FAF6 zone.

Field → column mapping

Source field	Column	Type	Description
TIGER `GEOID`	`geoid`	varchar(5)	state + county FIPS
TIGER `GEOID`, last 3	`county_fips`	varchar(3)	county FIPS
TIGER `NAME`	`name`	varchar(60)	e.g. `King County`
CFS `CFS22_AREA`	`cfs_area`	varchar(5)	CSA/MSA code, or `99999`
CFS `CFS22_TYPE`	`cfs_area_type`	varchar(1)	C, M or R
CFS `CFS22_NAME`, whitespace collapsed	`cfs_area_name`	varchar(120)	the workbook pads some names with doubled and trailing spaces
CFS `CFS22_GEOID`	`cfs_geoid`	varchar(19)	e.g. `E330000US5350000000`
TIGER `AREALAND`	`aland_m2`	bigint	square meters
TIGER `AREAWATER`	`awater_m2`	bigint	square meters
TIGER `INTPTLAT`	`intptlat`	double precision	internal point
TIGER `INTPTLON`	`intptlon`	double precision	internal point
geometry	`geom`	geometry(MultiPolygon, 4326)	`ST_Multi(ST_GeomFromGeoJSON)`

Geometry

SRID 4326 (WGS84). GIST index on geom.

Change detection

The Census sync's check compares the layer's vintage ("January 1, 2026 vintage") and Washington's row count, and the county list's Last-Modified and length. A change to either marks Census stale, and the next Census sync rebuilds this table, then FAF's crosswalk.

Attribution

US Census Bureau. TIGER products are free to use with acknowledgement of the U.S. Census Bureau as the source; the CFS county list states no terms.

provenance/wa_census_county_subdivisions.md

↑ Contents

Provenance: `wa_census_county_subdivisions`

This file describes how the rows in PostgreSQL table wa_census_county_subdivisions were obtained from an external source: where they were fetched and how fields were renamed and typed. Field meanings are in the mapping table below.

Identity

Table: wa_census_county_subdivisions
Family: Census
Display name: Census County Subdivisions (Washington)
Source URL: https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/tigerWMS_Current/MapServer/22
Geometry (source / stored): polygon / geometry(MultiPolygon, 4326)
Update cycle: Yearly (TIGER vintage)

Pipeline

TIGERweb tigerWMS_Current layer 22 ("County Subdivisions"), asked for STATE='53' AND COUSUB <> '00000', keyset-paged on GEOID (1,000 features a page), GeoJSON, outSR=4326. The download must return exactly the count the check saw under the same filter, or the sync fails. Subdivision 00000 is each county's area no subdivision covers, which is water.

Field → column mapping

Source field	Column	Type	Description
TIGER `GEOID`	`geoid`	varchar(10)	state + county + subdivision FIPS
TIGER `GEOID`, first 5	`county_geoid`	varchar(5)	state + county FIPS
TIGER `GEOID`, last 5	`cousub_fips`	varchar(5)	subdivision FIPS
TIGER `NAME`	`name`	varchar(100)	with its kind
TIGER `BASENAME`	`basename`	varchar(100)	without it
TIGER `LSADC`	`lsad`	varchar(2)
TIGER `FUNCSTAT`	`funcstat`	varchar(1)
TIGER `AREALAND`	`aland_m2`	bigint	square meters
TIGER `AREAWATER`	`awater_m2`	bigint	square meters
TIGER `INTPTLAT`	`intptlat`	double precision	internal point
TIGER `INTPTLON`	`intptlon`	double precision	internal point
geometry	`geom`	geometry(MultiPolygon, 4326)	`ST_Multi(ST_GeomFromGeoJSON)`

Geometry

SRID 4326 (WGS84). GIST index on geom.

Change detection

The Census sync's check compares the layer's vintage ("January 1, 2026 vintage") and Washington's row count under the filter above. A change to either marks this table stale, and the next Census sync rebuilds it.

Attribution

US Census Bureau. TIGER products are free to use with acknowledgement of the U.S. Census Bureau as the source.

provenance/wa_census_local_pop_est.md

↑ Contents

Provenance: `wa_census_local_pop_est`

This file describes how the rows in PostgreSQL table wa_census_local_pop_est were obtained from an external source: where they were fetched and how fields were renamed and typed. Field meanings are in the mapping table below.

Identity

Table: wa_census_local_pop_est
Family: Census
Display name: Annual Population Estimates by Place and County Subdivision
Source URL: https://www2.census.gov/programs-surveys/popest/datasets/2020-2025/cities/totals/sub-est2025.csv (vintage 2025; each vintage <V> is 2020-<V>/cities/totals/sub-est<V>.csv), for 2020 on
History (2000–2019): under the same datasets/ directory, 2000-2010/intercensal/cities/sub-est00int.csv and 2010-2020/intercensal/cities/sub-est2020int.csv
History (1990–1999): https://www2.census.gov/programs-surveys/popest/tables/1990-2000/cities/totals/su-99-10_wa.txt
Census counts (1980, 1990): Summary Tape File 1A, https://www2.census.gov/census_1980/stf1a/stf1axwa.zip and https://www2.census.gov/census_1990/STF1A_ASCII/90STF1A-WA.ZIP
Geometry (source / stored): none / none
Update cycle: Yearly (each May)

Pipeline

The Population Estimates Program's national file of places and county subdivisions, CSV, one row per area with a column per year. The sync keeps Washington's rows (STATE 53) at three summary levels and turns each into one row per year, the years read off the file's POPESTIMATE<year> columns:

`SUMLEV`	`geo_type`	`geoid`	`county_geoid`
162	`place`	`STATE` + `PLACE`	none
061	`county_subdivision`	`STATE` + `COUNTY` + `COUSUB`	`STATE` + `COUNTY`
157	`place_in_county`	`STATE` + `PLACE`	`STATE` + `COUNTY`

Dropped: 040 and 050 (the state and county totals, which the county file has), 071 (a place's part of a county subdivision), and 170 and 172 (consolidated cities and the places inside them). A file that is not valid UTF-8 is read as Latin-1. The sync logs how many places have no outline in the current TIGER layers. These rows are series postcensal.

The years before 2020 are series intercensal, from the Bureau's revised files for each decade, read the same way at the same three summary levels: sub-est00int.csv for 2000–2009 (vintage 2010; it has no FUNCSTAT, so funcstat is empty, and its POPESTIMATE2010 is left to the 2010s file) and sub-est2020int.csv for 2010–2019 (vintage 2020; its CENSUS2020POP is not loaded). estimates_base is each file's own ESTIMATESBASE<first year>. Areas dissolved since keep their rows.

1990–1999 are series postcensal, vintage 1999: the Bureau's 1999 release, which no later release revised. su-99-10_wa.txt is fixed-width text in two blocks, July 1999 back to July 1994, then July 1993 back to July 1990 and the April 1, 1990 estimates base (estimates_base on the 1990 row); each line is the summary level, state, county, county subdivision and place codes, the state's abbreviation, the name, and one figure per column of its block, newest first. Kept: 060, a county subdivision, and 157, a place's part of a county, whose parts are also added up into the place's own place row (the name without (pt.)), as the later files' 162 is. A 157 line with no place code is the county's people outside every place, kept as place code 99990 and named Balance of … as the later files have it. Dropped: 071 (a place's part of a county subdivision). The file gives no functional status, so funcstat is empty.

The census rows, series census, year and vintage 1980 or 1990, are what each census counted on April 1 in the places and county subdivisions that were governments: every functional status but S (statistical: census designated places and census county divisions). pop_estimate is the count; estimates_base is empty.

1990: 90STF1A-WA.ZIP holds several files of 4,809-character records; only part 0001 is read. Summary level 160 is a place, 060 a county_subdivision (its FIPS code under its county) and 155 a place's part of a county, a place_in_county row, named with (pt.) when the place lies in more than one county. The population is POP100, characters 291–299; the FIPS codes and FUNCSTAT are in the record's geographic header. A few places serving as their own subdivision carry the code of the township around them (Ohio's Chardon village has Chardon township's): of two areas with one code, the one that is not a false entity (F) keeps it; any other clash leaves both out, and the sync logs them.
1980: stf1axwa.zip, 3,277-character records. Summary level 27 is a place, 12 a county subdivision and 13 a place's part of one, added up by county into the place_in_county rows. The population is characters 253–261. The 1980 tape has only the census's own area codes, not FIPS, so each 1980 area is matched to a 1990 one: the area with the same census code whose name is the same once its kind ("city", "township", …) and spacing are set aside, failing which the one 1990 area of that name (in the same county, for a subdivision). A row carries the 1990 area's FIPS code and name, the 1980 FUNCSTAT. A 1980 area matching none, or one whose 1990 area another 1980 area has already taken, is left out and logged.

Field → column mapping

Source field	Column	Type	Description
`SUMLEV`	`geo_type`	varchar(20)	as above
as above	`geoid`	varchar(10)
as above	`county_geoid`	varchar(5)
`NAME`	`name`	varchar(120)	the 1990 census's name on the census rows
`FUNCSTAT`	`funcstat`	varchar(1)	empty 1990–2009; that census's code on the census rows
the `<year>` suffix	`year`	smallint
the newest `<year>`	`vintage`	smallint	2010 or 2020 on history rows, 1999 on the 1990s rows, the year on the census rows
	`series`	varchar(12)	`postcensal` (with the 1990s rows), `intercensal` (2000–2019) or `census`
`POPESTIMATE<year>`	`pop_estimate`	integer
`ESTIMATESBASE2020`	`estimates_base`	integer	2020 row only (`ESTIMATESBASE2000`, `ESTIMATESBASE2010` on the 2000 and 2010 rows; the 1990s file's base on the 1990 `postcensal` row)

Geometry

No geometry column.

Change detection

The Census sync's check asks for the next vintage's file each time and moves to it once it is published; otherwise it compares the current file's Last-Modified and length, and each history file's, the 1990s file's and the two census tapes' included. Any of them marks this table stale, and the next Census sync rebuilds it whole, every year from 2020 replaced by the new release.

Attribution

US Census Bureau, Population Estimates Program.

County Subdivision Population Density, 2020

How much land each Washington county subdivision covers, and how many people live on it

Layers

Data sets used

Ask your own question about Washington

Transcript

State Planner chat · https://stateplanner.com

Prompt

Response

How much land each Washington county subdivision covers, and how many people live on it

Exploratory Queries

Query 1 — Check whether Washington subdivisions are statistical and have estimates.

Query 2 — Test assigning 2020 block group counts to subdivisions by interior point.

Query 3 — Check how many block groups cross subdivision lines.

Query 4 — Land area and 2020 population density for each county subdivision.

Map Layer Queries

People per sq mi of land (2020 census) — colored by "cls": Under 10 (#ffffcc), 10 to 49 (#a1dab4), 50 to 199 (#41b6c4), 200 to 999 (#2c7fb8), 1,000 or more (#253494)

Used Data Sets

Provenance: wa_census_bg_decennial

Identity

Pipeline (Census family)

Field → column mapping

Geometry

Attribution

Provenance: wa_census_block_groups

Identity

Pipeline (Census family)

Field → column mapping

Geometry

Attribution

Provenance: wa_census_counties

Identity

Pipeline

Field → column mapping

Geometry

Change detection

Attribution

Provenance: wa_census_county_subdivisions

Identity

Pipeline

Field → column mapping

Geometry

Change detection

Attribution

Provenance: wa_census_local_pop_est

Identity

Pipeline

Field → column mapping

Geometry

Change detection

Attribution

Provenance: `wa_census_bg_decennial`

Provenance: `wa_census_block_groups`

Provenance: `wa_census_counties`

Provenance: `wa_census_county_subdivisions`

Provenance: `wa_census_local_pop_est`