ncopenpass / campaignfinance Goto Github PK

migration etl and server setup

Other NC Open Pass projects seem to use MIT license. I've reached out to Chris Matthews on Slack to ask if there is a preferred license for use to use

When I search for a company, then I can see a list of which candidates they have contributed to, and how much and when, so that I can assess candidates relative to a specific interest.

When I search for a specific candidate, then I can see a list of all contributions they have received and the total, so that I can understand how much support that candidate is getting overall and from whom.

This is partially implemented in the '/candidate/:ncsbeID' route. Another join needs to be made against the candidates table

https://www.figma.com/proto/OcC48DWJjwCsPigGa9vb82/Campaign-Finance-Dashboard-Wireframes?node-id=16%3A2204&viewport=-1320%2C-986%2C0.3811715841293335&scaling=scale-down-width

Create or modify an endpoint that will return a list of donors by year.

Ensure route can be limited and paginated

https://designsystem.digital.gov

Create Sketches for the Primary User Stories.

Notes:

• Sketches for each of the views represented in #12
• Will want multiple versions of the main screen types (Search Screen, Search Results Screen, Candidate page, PAC page, Individual Donor page, Race page)

Sub Tasks:

• Page: Search by Candidate, PAC, Donor, Race
• Page: Search Results for Candidate, PAC, Donor, Race
• Page: Candidate
• Page: PAC
• Page: Race
• Page: Individual Donor
• Page: Company Donor

When I look up a candidate, I can see all the donations/spending/expenditures associated with that candidate.

Unsure if this needs to be done before or after September 1. We can definitely deploy to Heroku and use the generated URL for the initial soft launch

Use context api to manage current search data, dynamically change route information based on context api.

Utilized the existing search functions to create an aggregate search endpoint. Probably structure a response like this:

{
  "pac": [],
  "donor": [],
  "candidate": []
}

Ensure route supports pagination.

PAC data isn't available yet. For now just return empty data

Create or modify a route that will return a list of candidates by contest year.
Ensure route can be limited, paginated

Find some examples representative of the pages we want to use for inspiration in the low-fidelity mocks and wireframes and add them as slides in this doc: https://drive.google.com/open?id=1AZ_O8uDVTWz4NzBkJI0DEgHyxPxcSpF1f7XSbh_zX5g

Waiting on data

Example: https://openstates.org

Waiting on design

This route should return a list of contributions for a given contributorID.

Ensure route works wit Pagination. You can look at other existing routes, for an example. Other ideas are welcome.

https://www.figma.com/file/OcC48DWJjwCsPigGa9vb82/Campaign-Finance-Dashboard-Wireframes?node-id=2%3A58

When I go to the NC Campaign Finance Dashboard, I get a good understanding of totals and expenditures across active races and the most recent reports.

https://www.figma.com/file/OcC48DWJjwCsPigGa9vb82/Campaign-Finance-Dashboard-Wireframes?node-id=2%3A58

Determine whether or not there's a way to map SBoE id to an election type. We'll need that reference data to create this view: https://www.figma.com/proto/OcC48DWJjwCsPigGa9vb82/Campaign-Finance-Dashboard-Wireframes?node-id=16%3A2204&viewport=-1320%2C-986%2C0.3811715841293335&scaling=scale-down-width

Potential Source Data:
https://www.ncsbe.gov/Elections/Candidate-Filing#Lists

When I search for a specific office race (governor, senate, etc), I can see a breakdown of where each candidate got their support ( by employer) so I can know where each candidate received support from (and how much support).

(More details need to be added to this issues, e.g. sample files, details about the data expected in the files).

Request key raw data files from the NC Board of Elections:

• Contributions file with SBoE ID (https://drive.google.com/file/d/1kA45LKhC_FSC7rogO4MD9Sgt8R7zWoCv/view)
• List of candidates by race
• Candidates file with associated PACs

Date Range: from 2018 to present

create a donor search function that allows for searching by first and last name.
This function should work standalone or within an endpoint.
Utilize the pg_trgm function to allow for fuzzy matching. Results should be ordered by match accuracy

Contributions will flow into a Candidate's PAC, we will need the associated PAC for each candidate in order to produce the view shown here: https://www.figma.com/proto/OcC48DWJjwCsPigGa9vb82/Campaign-Finance-Dashboard-Wireframes?node-id=16%3A2204&viewport=-1320%2C-986%2C0.3811715841293335&scaling=scale-down-width

https://nc-campaign-finance.s3.amazonaws.com/finance-extracts/transinq_results_2010.csv
https://nc-campaign-finance.s3.amazonaws.com/finance-extracts/transinq_results_2011.csv
https://nc-campaign-finance.s3.amazonaws.com/finance-extracts/transinq_results_2012.csv
https://nc-campaign-finance.s3.amazonaws.com/finance-extracts/transinq_results_2013.csv
https://nc-campaign-finance.s3.amazonaws.com/finance-extracts/transinq_results_2014.csv
https://nc-campaign-finance.s3.amazonaws.com/finance-extracts/transinq_results_2015.csv
https://nc-campaign-finance.s3.amazonaws.com/finance-extracts/transinq_results_2016.csv
https://nc-campaign-finance.s3.amazonaws.com/finance-extracts/transinq_results_2017.csv
https://nc-campaign-finance.s3.amazonaws.com/finance-extracts/transinq_results_2018-2020-0415.csv

Create User Flows for the 3 Primary User Stories:

• User flow: When I search for a specific candidate, then I can see a list of all contributions they have received and the total, so that I can understand how much support that candidate is getting overall and from whom.
• User flow: When I search for a specific office race (governor, senate, etc), I can see a breakdown of where each candidate got their support (by donor/Donor) so I can know where each candidate received support from (and how much support).
• User flow: When I search for a company, then I can see a list of which candidates they have contributed to, and how much and when, so that I can assess candidates relative to a specific interest.

Good information on user flows here:

• https://www.youtube.com/watch?v=-MqBBvw6wBY
• https://www.skillshare.com/classes/UX-Design-Crafting-a-Userflow-with-Psychology-and-Empathy/364262441
• http://www.jjg.net/ia/visvocab/files/garrett_ia_quickref.pdf
• https://hackernoon.com/ux-design-on-an-agile-team-incremental-user-flows-b9f551a9f096
• https://medium.muz.li/red-routes-critical-design-paths-that-make-or-break-your-app-a642ebe0940a\

When I search for a specific industry (healthcare, farm, etc), then I can see a list of the contributions they have made, so I can understand what candidates are being supported by these interest groups.

Table component should display the fields from the wireframe.
Should also include selections and filtering.

https://www.figma.com/file/OcC48DWJjwCsPigGa9vb82/Campaign-Finance-Dashboard-Wireframes?node-id=2%3A58

When I look up a donor or a specific company then I can see all candidates they’ve contributed to so that I can better educate my community about their options.

Don't have content for it yet, but can make a page for it and link it in footer.

For the MVP we can probably use a google form to report. The form should have free text field for the user to explain what is inaccurate.
We should prompt the user to provide links and screenshots to the inaccurate data if possible
We should optionally collect the user's email

Doing some exploration of the data in Pandas, I found that the contributors table has duplicate IDs.

Suspect this may be an artifact of being early in dev process, but figured i'd file an issue.

Waiting on content and design

When I look up an office, I can see all the candidates for that office, so that I can make sure I’m assessing all the options.

• Zach Ambrose to connect Jeremy Borden to Democracy NC contact
• Jeremy Borden to reach out to Democracy NC to explain project and recruit help
• Jeremy Borden to inquire how much open data the group Democracy NC has gotten from the State Board of Elections

https://www.figma.com/file/OcC48DWJjwCsPigGa9vb82/Campaign-Finance-Dashboard-Wireframes?node-id=2%3A58

Donors Table has filter options for each column.

Waiting on data from Jeremy

Shaun suggested looking into Hot Jar

Create Wireframes for the 3 Primary User Stories:

1. When I search for a specific candidate, then I can see a list of all contributions they have received and the total, so that I can understand how much support that candidate is getting overall and from whom.
2. When I search for a specific office race (governor, senate, etc), I can see a breakdown of where each candidate got their support (by donor/Donor) so I can know where each candidate received support from (and how much support).
3. When I search for a company, then I can see a list of which candidates they have contributed to, and how much and when, so that I can assess candidates relative to a specific interest.

Notes:

• Wireframes will be based on sketches in #13
• Will want wireframe for each of the main screen types (Search Screen, Search Results Screen, Candidate page, PAC page, Individual Donor page, Race page)

Best way to request 10 years worth of data based on the response from SBoE

From: Puffenberger, Michelle [email protected]
Date: Mon, Apr 13, 2020 at 1:34 PM
Subject: RE: [External] Re: Campaign finance data
To: Jeremy Borden [email protected]

Good afternoon,

All of the information should be publicly available at this location https://www.ncsbe.gov/Campaign-Finance/Report-Search. If you have specific information you are looking for, go to https://www.ncsbe.gov/Public-Records-Data-Info/Election-Results-Data and select the Request Data or Public Records link.

Thank you,
Michelle

Summary info:
Total number of donations
Median donation
Largest donation