Loading ...
Sorry, an error occurred while loading the content.

Re: [govtrack] Re: Coding projects

Expand Messages
  • Leonard Linde
    I just sent you a zip file with the data and program. ... From: Roger Williams Subject: [govtrack] Re: Coding projects To:
    Message 1 of 6 , Jul 24, 2008
    • 0 Attachment
      I just sent you a zip file with the data and program.

      --- On Thu, 7/24/08, Roger Williams <dbsearch04@...> wrote:
      From: Roger Williams <dbsearch04@...>
      Subject: [govtrack] Re: Coding projects
      To: govtrack@yahoogroups.com
      Date: Thursday, July 24, 2008, 11:30 AM

      --- In govtrack@yahoogroup s.com, Leonard Linde <llinde@...> wrote:
      >
      > I exported it to csv and wrote a python (django framework) program
      to match, by name, to the govtrack.us people file, which I already
      have in a MySQL table.
      >
      > It was an iterative process because the excel file formatting is
      not 100%:  some names were misspelled, some punctuation was missing,
      etc.  IIRC, I had to edit one or two lines in the file.
      >
      > I did not treat the program as something I'd re-use, because I
      assumed that the Taxpayers for Common Sense file format will change,
      and even if it doesn't, next years' file will have a different set of
      formatting errors.
      >
      > I think my result at least 99% correct.   I'd be happy to export
      the resulting data in any format you'd like and send it to you, as
      long as you follow the attribution policy of TCS.   I'll send you the
      program, too, for what it's worth.
      >
      > <snipped/>
      Hello Leonard:

      I am interested in the .csv version of the data as well as the
      program. I think I saw somewhere that Josh wants to get stuff in perl
      [for consistency with the other parts of the GovTrack implmentation] .
      So I can use the program as a guide.

      TIA.

      Regards..RogerW


    Your message has been successfully submitted and would be delivered to recipients shortly.