Re: [govtrack] Re: Coding projects
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
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
> 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.
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.