6-7:30 p.m. Tuesday, 7 Oct. 2008- "Yup, it IS about following the money.  But how to make sense of those numbers?"

Every election season, new web sites come along that make it easier to follow the money -- election money.  Tonight we will look at some of those and focus on how to get that data off the web site and into a spreadsheet.  Then what?  A short intro to slicing-and-dicing the numbers.  (Even if you are a spreadsheet maven, please come and act as a coach.)

Notes:

• Federal Election Commisson www.fec.gov
  • Go to 2008 House and Senate Campaign Finance http://www.fec.gov/DisclosureSearch/mapHSApp.do
  • Click on the map and NM http://www.fec.gov/DisclosureSearch/mapHSApp.do?drillLevel=state&stateName=NM
  • Click on map and House Dist. NM-3 http://www.fec.gov/DisclosureSearch/HSRefreshCandList.do?category=disH&stateName=NM&congressId=03
  • Scroll down, noting the different variables as you do so.  Click on Lujan

    http://www.fec.gov/DisclosureSearch/HSRefreshContributorList.do?contComeFrom=candList&cand_id=H8NM03196&contCategory=PAC&category=disH&stateName=NM&congressId=03

  • Study the page, i.e. "interviewing the database." 
    • Why the + or - next to "Contributor Name"?  It indicates that by clicking, you can (or have) sort, usually alphabetically, the entire data set by SOME of the variables.  In fact, the Variable name often doesn't need the symbol.
    • Scroll through the records, somewhat casually looking for "curiosities."  The "Hmmmm, that's odd or interesting" stuff.
    • Most important -- and generous -- on the part of the agency is the big button upper right "Export to Excel."  But first, decide which variable you want sorted.  Yes, you can and will sort by the other later, but start by thinking about the question(s) you will initially ask:  i.e. Are we interested in the most to the least amount of contribution?  Or do we first want to find out how far afield are the contributions coming from.  (To what degree is Young Ben getting out-of-state money?)

    •