search

michalgm / state_dem

Oil Change International State DEM Project
1 stars 0 forks source link

More CSV download options #70

Closed dturnbull closed 10 years ago

dturnbull commented 10 years ago

Right now there is no easy way to do an analysis of how much DEM is behind a vote for/against dirty energy in a given state house/legislature.

To help, we need the following additional csv downloads to be possible. Examples of what we need to be able to see are included in an excel workbook (note multiple worksheets and the column headings) I will send to Stan.

(note, this issue was somehow closed but I don't think it is resolved)

michalgm commented 10 years ago

Can I get a copy of that spreadsheet? The various reports are not that hard to generate, but the tricky part is figuring out how to integrate them into the UI so that it all makes sense.

dturnbull commented 10 years ago

Sure thing. Just forwarded!

Sent from my iPhone

On Sep 24, 2013, at 5:10 PM, Greg Michalec notifications@github.com wrote:

Can I get a copy of that spreadsheet? The various reports are not that hard to generate, but the tricky part is figuring out how to integrate them into the UI so that it all makes sense.

— Reply to this email directly or view it on GitHub.

stanleyjones commented 10 years ago

When this is ready, I'll put a button in the navbar to download the csv for the current view.

michalgm commented 10 years ago

Ok - I've added an additional csv method for a "all members of a chamber" report. The url should be like this: request.php?method=csv&type=chamber&cycle=2012&state=CA&chamber=state:upper

David - I'll need some more information about the other two sheets in that spreadsheet you sent - it wasn't entirely clear what you'd like to see. Are you looking for all companies that give to a legislator during their lifetime (and vice versa)?

dturnbull commented 10 years ago

I would like to reopen this (but can't figure out how). The CSV files should include "sector" (oil/gas, coal, etc.) for individuals.

As an example -- I went to look up Fran Pavley in CA Senate and noticed she gets lots of coal money according to the graphs on her popup page. That seemed surprising to me given there's not much coal interest in California, so I downloaded the CSV...and can't tell whether the companies are coal, oil or gas when I look at the CSV. Suggest reviewing the spreadsheet I sent previously.

michalgm commented 10 years ago

Ok - I've added the company industry field. The spreadsheet you sent before I don't think applies here. Correct me if I'm wrong, but that was meant to show contribution summaries grouped by company/legislator over the lifetime of a company/legislator . The csv I just changed shows all the individual contributions made to/from the selected node for the current graph only (state/chamber/year). Since it is individual contributions, it shows extra fields such as contributor name. Does that make sense?

dturnbull commented 10 years ago

Maybe it wasn't clear that there were three tabs on the spreadsheet/workbook I sent? There were three examples in that excel workbook:

1) for downloading the full legislature 2) for downloading the full information for a company (e.g. within a state chamber in a given year) 3) for downloading full information for a specific legislator/person

The third (individuals) applies here I think. Either way, it's important to include the sector/industry field so that people can sort by that column and analyze the data that way. I don't necessarily know what companies in our database are coal vs. oil etc. and I can't imagine most of our partners would either in a lot of cases, so good to have that information so it's clear how the sectors break down.

On Mon, Oct 7, 2013 at 10:13 AM, Greg Michalec notifications@github.comwrote:

Ok - I've added the company industry field. The spreadsheet you sent before I don't think applies here. Correct me if I'm wrong, but that was meant to show contribution summaries grouped by company/legislator over the lifetime of a company/legislator . The csv I just changed shows all the individual contributions made to/from the selected node for the current graph only (state/chamber/year). Since it is individual contributions, it shows extra fields such as contributor name. Does that make sense?

— Reply to this email directly or view it on GitHubhttps://github.com/michalgm/state_dem/issues/70#issuecomment-25826869 .