US Census

Maps that look at the US Census at the macro-perspective of all counties in the United States.

Population of State Capital Metro Regions

|

Population of State Capital Metro Regions

   NAMEASCII      ADM1NAME       POP_MAX
 * <chr>          <chr>            <dbl>
 1 Atlanta        Georgia        4506000
 2 Boston         Massachusetts  4467000
 3 Phoenix        Arizona        3551000
 4 Denver         Colorado       2313000
 5 Sacramento     California     1604000
 6 Indianapolis   Indiana        1436000
 7 Providence     Rhode Island   1277000
 8 Columbus       Ohio           1270000
 9 Raleigh        North Carolina 1163515
10 Austin         Texas          1161000
11 Salt Lake City Utah            966000
12 Hartford       Connecticut     913000
13 Richmond       Virginia        912000
14 Nashville      Tennessee       877000
15 Albany         New York        870716
16 Oklahoma City  Oklahoma        788000
17 Honolulu       Hawaii          786000
18 St. Paul       Minnesota       734854
19 Harrisburg     Pennsylvania    528892
20 Baton Rouge    Louisiana       422072
21 Columbia       South Carolina  398093
22 Des Moines     Iowa            380655
23 Trenton        New Jersey      366513
24 Boise          Idaho           338071
25 Madison        Wisconsin       327447
26 Lansing        Michigan        279952
27 Little Rock    Arkansas        270893
28 Jackson        Mississippi     250902
29 Lincoln        Nebraska        246220
30 Salem          Oregon          229010
31 Tallahassee    Florida         221222
32 Montgomery     Alabama         198325
33 Olympia        Washington      156984
34 Springfield    Illinois        134715
35 Topeka         Kansas          132091
36 Charleston     West Virginia   123799
37 Santa Fe       New Mexico       92681
38 Annapolis      Maryland         81300
39 Dover          Delaware         76039
40 Cheyenne       Wyoming          72927
41 Bismarck       North Dakota     63871
42 Carson City    Nevada           57341
43 Jefferson City Missouri         55139
44 Concord        New Hampshire    44606
45 Helena         Montana          38725
46 Frankfort      Kentucky         36688
47 Juneau         Alaska           30711
48 Augusta        Maine            24042
49 Pierre         South Dakota     13879
50 Montpelier     Vermont           8538

 

Median Income Distribution by State

|

Median Income Distribution by State

When you look at Census Tracts in Vermont, you will notice that most of them are close to $60k for the medium household income, with it tapering off quickly in both directions. Connecticut on the other hand, has some very wealthy and very poor census tracts, and a few exceptionally wealthy ones.

New York Needs More Immigrants !

|

If there is anything one can read from today’s census numbers it is that.

Domestic out-migration remains high, as it has been for generations, attracted by lower taxes, friendlier business climate, and nicer weather in other parts of the country, while international immigration remains moderate but below other immigrant-friendly states like Massachusetts, Maryland and New Jersey.

Blue states can’t compete by pretending to be red states, cutting taxes and business regulation. But what they can do is attract people from overseas — be it highly educated individuals attracted to the high quality educational institutions and knowledge-based businesses of blue states, or migrants and asylum seekers seeking a better life in a blue states. When Florida or Texas says no, we should be saying yes.

It’s not just about doing what’s right for people who are truly in need, but also the federal dollars and representation that immigrants bring in. Otherwise, blue states like New York risk becoming increasingly irrelevant as far as governing is concerned and cut off from federal funding in the coming decades.

Classifying Similiar States for Income Distribution

|

Classifying Similiar States for Income Distribution

I've been playing with different ways to use K-Means classification to find related classes of states when it comes to income distribution. I tried dividing up the states into four groups, which came up some interesting income distributions, as shown below.

Class Less than $10,000 $10,000 to $14,999 $15,000 to $19,999 $20,000 to $24,999 $25,000 to $29,999 $30,000 to $34,999 $35,000 to $39,999 $40,000 to $44,999
Low – 1 8 5.5 5.5 5.7 5.3 5.2 4.7 4.7
Higher – 2 5.5 3.7 3.3 3.3 3.2 3.4 3.1 3.2
High – 3 4.6 3.3 3.2 3.5 3.5 3.8 3.6 3.8
Moderate – 4 5.6 4.2 4.3 4.6 4.6 4.8 4.4 4.6
                 
Class $45,000 to $49,999 $50,000 to $59,999 $60,000 to $74,999 $75,000 to $99,999 $100,000 to $124,999 $125,000 to $149,999 $150,000 to $199,999 $200,000 or more
Low – 1 4.2 8 9.8 11.9 7.9 4.8 4.6 4.3
Higher – 2 3 6.1 8.4 12.1 10 7.4 9.9 14.3
High – 3 3.5 7.1 10.1 13.8 10.7 7.5 8.7 9.2
Moderate – 4 4.1 8.1 10.5 13.5 9.4 5.9 5.9 5.7

2020 Census Under Counts

|

2020 Census Under Counts

In 2020, there was a meme about the importance of New Yorkers being counted in the Census, so not to be under-counted as compared to Idaho. But when the Census Bureau took a final review of 2020 Census, it turns out New York over-counted by 3.44% or 695,000 residents while Idaho under-counted by 1.55% or 29,000 residents.
 
Southern States -- especially Texas and Florida had big under counts, it looks due to low participation rates of Hispanic voters, which the Census reports were under counted. Ultimately when the history books were finalized on the census, it was President Trump's messing around with the census that hurt red states more then blue states. Go figure.