Home > IdeaLab, ManyEyes, visualization > Visualizing overlapping ‘double dipping’ hours from state comptroller’s report

Visualizing overlapping ‘double dipping’ hours from state comptroller’s report

I’m playing around with some visualization tools during my spare time as of late, using ManyEyes.

The concept is simple, upload a document and choose the visualization method. It’s a bit tricky, and I’ll get better as I get comfortable with it.

But the potential is there. Here’s a simple chart from the state Comptroller’s preliminary report on overlapping hours in the double-dipping scandal.

If I get the hang of it, you’ll see this more often.

Overlapping hours Many Eyes
UPDATE: I was asked in the comments if we could upload the time sheet with ‘double dip’ on it. Here is one:


UPDATE 2: Microsoft Excel does charts, of course, so let’s add Wages, Overtime with URGENT, School money and benefits and make some CHARTICLES!

Detective Lt. Timothy Matthews wages 2007-2010 http://d1.scribdassets.com/ScribdViewer.swf?document_id=49266888&access_key=key-xa1w1xygj0xe6m41n4&page=1&viewMode=slideshow

Advertisements
  1. February 21, 2011 at 3:56 pm

    Can the 20088-09 timesheets with "denied for double dipping" and Pitchard's initials be published?

  2. February 21, 2011 at 4:30 pm

    This is an interesting graph, but an even more interesting story would be to graph the actual start and end times for when he worked for the City and for the school and have those hours shown side by side for each day.

  3. February 21, 2011 at 4:37 pm

    I'll see what I can do.

  4. February 21, 2011 at 5:30 pm

    thanks for the timesheet

  5. February 21, 2011 at 6:08 pm

    Just curious?Most people submit timesheets weekly or bi-weekly. It appears this timesheet(s) cover a few months time. Is that correct? Is that the procedure (if there is one)? Just seems unusual.

  6. February 21, 2011 at 7:42 pm

    Why is it necessary to publish the home address of a police officer since the protections of the US Constitution (including the right to be presumed innocent) also apply to law enforcement officers and he should still have the right to be secure in his home during this investigation.I also don't believe that his home address has anything to do with the story anyway.Cheers.

  7. February 21, 2011 at 8:16 pm

    Dear Tin,You are correct. It is not necessary to publish such information.Although we routinely publish addresses in the police blotter, if available, the purpose of such disclosures is to identify the individuals (If, say, someone with your name is arrested that's not you, the address differentiates the you and the perp).Alas, there is no such need with Timothy Matthews. We received the document as part of a Freedom of Information Act request, and the only information redacted from it was the social security number. I uploaded the file as we received it after it was requested in these comments.The information IS available for those who want it, but it is not pertinent to this story, and thus, I have redacted the address from the image.Thanks for bringing this up to my attention.

  8. February 21, 2011 at 8:44 pm

    All I can say is " Get a life freeeman" Let the next story be when you get something new to write about please.

  9. February 21, 2011 at 9:01 pm

    Glad you asked! (?)Freeman reporters are currently working on stories which will contain new information and will be posted when they are ready and as they develop.As I've written in the post, "I'm playing around with some visualization tools," which was the point of the post. The idea is to hopefully make upcoming stories easier to understand, as things get more complex. I fail to see how helping in this endeavor doesn't add some value to those pieces.Note also that this is my blog, and not the "freeeman." And, thus, I get to write things like "I," "CHARTICLES" and "freeeman."And I can also be snarky. 😀

  10. February 22, 2011 at 2:24 am

    if u were the average joe your name and address would be in the paper so get over it.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: