Computer Assisted Reporting

Technical Analysis of Kansas Voter Registration Data

By
Wednesday, March 21st, 2012

Computer Assisted Reporting

This article describes technical analysis of the Kansas voter registration file from February 2012. (more…)

How many pages in Scott Walker Recall Petition PDF files?

By
Friday, February 3rd, 2012

Computer Assisted Reporting

In an online press release on Tuesday the Wisconsin Government Accountability Board announced they would put all 153,335 pages of PDF copies of the Scott Walker recall petition online later that day.

(more…)

BatchGeo.com Google map of organizations losing IRS tax exempt status

By
Wednesday, December 21st, 2011

Computer Assisted Reporting

This article describes how to download a file from the IRS with a list of organizations losing their tax-exempt status and create a Google map using BatchGeo.com to display them. (more…)

Working with Wisconsin Voter Data in Access 2007; Analysis with R.

By
Friday, December 2nd, 2011

Computer Assisted Reporting

This technical note describes manipulation/analysis of Wisconsin voter registration data from June 2011. (more…)

Displaying Missouri sex offender/child day care facility proximity map using batchgeo.com

By
Thursday, July 28th, 2011

Computer Assisted Reporting

This is the last of four articles about analyzing distances between sex offenders and church child daycare centers in Missouri as part of a joint project with KSHB NBC Action News in Kansas City.

The previous two articles gave details about how to use Google Geocoding to convert an address to geolocation coordinates, and then how to use those coordinates to compute a distance matrix between sex offenders and child care facilities. (more…)

Computing distance matrix between Missouri sex offenders and child daycare facilities

By
Thursday, July 28th, 2011

Computer Assisted Reporting

This is the third of four articles about analyzing distances between sex offenders and child daycare centers in Missouri as part of a joint project with KSHB NBC Action News in Kansas City.

The previous article explained how to use Google geocoding to find the longitude-latitude coordinates from street addresses in a file.  That article focused on finding the coordinates of registered Missouri sex offenders. (more…)

Geocoding addresses from Missouri Sex Offender Registry

By
Tuesday, July 19th, 2011

Computer Assisted Reporting

This is the second of four articles about analyzing distances between sex offenders and child daycare centers in Missouri as part of a joint project with KSHB NBC Action News in Kansas City.

The previous article gave details of analyzing the Missouri Sex Offender Registry and preparing a data file for geocoding. (more…)

Analysis of Missouri Sex Offender Registry Data

By
Monday, July 18th, 2011

Computer Assisted Reporting

This is the first of four articles about analyzing distances between sex offenders and child daycare centers in Missouri as part of a joint project with KSHB NBC Action News in Kansas City.

(more…)

Word Clouds from #AskObama Tweets

By
Thursday, July 7th, 2011

Computer Assisted Reporting

How could anyone make sense of all the tweets at President Obama’s Twitter Townhall?

At his high tech townhall on Wednesday President Obama responded to 140-character questions in tweets from people on the Internet around the world.

Each tweet intended for President Obama was given a hashtag #AskObama. (more…)

Simple Statistics to Analyze Data Files

By
Monday, June 6th, 2011

Computer Assisted Reporting

After your open records request you receive a computer data file, possibly with little or no documentation.  How do you make sense of 10,000 lines or a million lines of data? (more…)