Saturday, April 4, 2009

Commence the Census

We had a visit from a nice young lady representing the 2010 Census yesterday who wanted to know if we live in a single-family house (well, duh! Plano has the strictiest zoning laws you can imagine and nothing else is allowed here.) It was the first puff of wind in the coming deluge of census taking for the constitutionally-mandated decenial enumeration of the US of A.

So I got to thinking about it all and made a visit to the Census web site where I did a little digging on the name, Ashurst. In the 2000 Census there were 751 of us (not counting those that were not recognized as valid – too complex to define here, but you can read all you wanted to know and MUCH MORE on the Census web site.) There were 26 names with 751 people, and 751 was the 29,598th highest in the US. Ashursts were about 88% white, 8% black, 3.5% hispanic, and less than 1% of the other races. There were 0.28 of us in each 100,000 people in the US (or about 1 in 357,143).

Now, don’t that make you proud?

BTW, Smith is by far the most commnon name is the country, but Jones is all the way down at #5.

The top ten surnames are:

NAME

Number of occurrences

Smith

2,376,206

Johnson

1,857,160

Williams

1,534,042

Brown

1,380,145

Jones

1,362,755

Miller

1,127,803

Davis

1,072,335

Garcia

858,289

Rodriguez

804,240

Wilson

783,051

6 comments:

Nancy Sabina said...

There was another Ashurst in my graduating class. A tall, snobby boy as I recall.

angela michelle said...

But how many Ashurst-McGees are in the census? :)

bill said...

Hi Earl:

Could you tell us the link to do these queries? The census website is a vast place.

I'm interested in knowing about, oh, the name Benac for example.

Thanks,

Bill

Grampa Earl said...

To find the data:
- go to www.census.gov
- Click on Genealogy
- Click on "Frequently Occurring Surnames"
- Select File B: "Surnames occurring 100 or more times" and save the .ZIP file
- double click on the zipfile name and when given the choice, open it as a .csv (Comma Separated Variables) file. It will open in Excel, but since a CSV is a non-formatted file, it can be larger than a formatted Excel file. This file is so big that if you try to open it as an excel file it won't load enough data to get down to the Benacs and Ashursts. Even opening it as a CSV, you will get a message that the file didn't load completely, but don't worry, it will load enough for our purposes.

TIP: it will be easier to interpret if you click on row 2 (highlight the row) then click "Window", then "Freeze Panes". That will make it so the title row will stay put while you scroll down. Do CTRL-F to find Benac or whoever you want.

Grampa Earl said...

Poor Angela. Hyphenated names are considered (by the census, not by me) as errors and are left out of the most-common-name statistics files. Sorry.

bill said...

Thanks, Earl. 291 Benacs! We're a rarefied bunch.

By the way, Excel 2007 can open that CSV file just fine.