Does anybody have "59sunburst's" spread sheet?

[autorank]

http://www.democraticunderground.com/discuss/duboard.php?az=show_topic&forum=203&topic_id=197869
From 59sunburst:

Were Bush's 2000 Vote Tallies Used to Fake 2004 Tallies?

First of all, I am not a statistician. I am a programmer. I've worked on projects for major corporations where I had to reverse-engineer calculations.

For the past month I've been analyzing presidential election results from Cuyahoga County, Ohio. I started by comparing precinct results from 2000 to 2004. Some where added and some were removed, so I narrowed my focus on precincts common to both years.

I also compared the results from 11/8/2004 with the results from 11/30/2004.

The first thing I noticed was that there were 46 precincts that recorded the same number of votes for George Bush in 2004 as in 2000, either in the preliminary or final results.

This compared with only 12 precincts that recorded the same number of votes for John Kerry in 2004 as for Al Gore in 2000.

[Chi]

1. Found the same post of his/hers at another forum

Maybe there's a contact there?

I tried a couple of searches, but didn't find anything.

http://www.bbvforums.org/forums/messages/8/1551.html?1105162569

(On Edit -- That's not posted by 59sunburst, it was a copy n paste. Sorry)

[Febble]

2. I was looking for the same thing

someone mentioned it a propos my calculatus eliminatus thread, but I can't find it. When the search function is working again I'll have a look. It could have been one of Land Shark's posts. Anyway, I was interested as my conclusion from the swing-shift non-correlation was that one possible loop-hole is an algorithm that stops Bush's vote dropping to far below a certain level relative to 2000, but doesn't let it go above.

[Chi]

3. Try his email, he made it pretty obvious 8)

[Steve A Play]

4. The .xls file has been removed from the AT&T server

Try this Google search for the DU threads.

http://www.google.com/search?q=59sunburst&hl=en&lr=&filter=0

[autorank]

5. Wow, thank you so much!!!!!!!!!!!!!!!!!!!!!! And Chi, thank you!!!!!!!!!!!

[adolfo]

6. Odd

The spreadsheet can be recreated based on 59sunburst's original post. I've already gathered 2000 data (precinct splits without summaries) but am unable to find the total ballots cast for 2004. -Presidential results are in the report but no totals.

Raw data comin right up!

[adolfo]

7. Cuyahoga Data

Here are the election results in Excel format.

2000
http://www.recountflorida.com/modules.php?op=modload&name=Downloads&file=index&req=viewsdownload&sid=5

2004
http://www.recountflorida.com/modules.php?op=modload&name=Downloads&file=index&req=viewsdownload&sid=3

[autorank]

8. Thanks. You are a gentleman and a scholar. Great site too!

[adolfo]

9. Thanks

Just finished making significant updates on both files. Please redownload for the newest version.

Notes:

-2000 needs registration totals but it is not available in the BOE data file.

[foo_bar]

10. here it is in one file

2000->2004 cuyahoga data (tab-separated) (html) (based on adolfo's .xls's)

(examples:

precinct G2000 B2000 K2004 B2004
CLEVELAND 6G 385 15 415 15
CLEVELAND 6H 367 9 438 11
CLEVELAND 10D 387 15 466 24
CLEVELAND 10E 329 8 476 14
EAST CLEVELAND 2-E 240 6 313 11
EAST CLEVELAND 2-F 333 15 379 23
EAST CLEVELAND 3-B 201 3 263 7
EAST CLEVELAND 3-C 292 17 312 20
EAST CLEVELAND 3-D 283 6 342 7)

So we're looking at precincts with fewer than 25 * votes in either election.