Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Washington loader #149

Open
ghing opened this issue Jun 9, 2014 · 2 comments
Open

Washington loader #149

ghing opened this issue Jun 9, 2014 · 2 comments
Assignees

Comments

@ghing
Copy link
Contributor

ghing commented Jun 9, 2014

Washington has a diversity of results in varying formats and data structure, especially at the precinct level.

However, through 2007, the results are from the same database dump and have a consistent format. Following that there are consistently county-level results available in CSV. Starting in 2012, there are precinct-level CSV files available.

When implementing the loader, get the 2000-2007 results working first, then county/precinct-level CSV. Excel/PDF precinct level data should be the last priority.

@ericlagergren
Copy link
Member

I ran into this today with my loader: most of Washington's CSV files for the counties don't have any relevant information. Since openstates doesn't really want "SCHOOL DISTRICT 128 - LAMONT Position 5", the loader ends up ignoring like 2/3 of all the files.

@ericlagergren
Copy link
Member

Initial pull for refactoring: #186

ghing added a commit that referenced this issue Oct 8, 2014
Update the Washington loader to use _xls_file_path property of
BaseDatasource instead of the old, poorly named _xls_file_handle
method.  The Datasource API was changed in
5870dd6

Addresses #149
ghing added a commit that referenced this issue Oct 9, 2014
Add comment specifying that the CSVs are missing and the Excel
files are hard to deal with.  Order files by election, in
ascending order, for easier future review.

Addresses #149
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants