ncopenpass / campaignfinance Goto Github PK

View Code? Open in Web Editor NEW

NC Campaign Finance Dashboard. Making NC Campaign Funds visible to all citizens

License: MIT License

HTML 0.61% JavaScript 62.20% Makefile 0.78% Shell 0.47% SCSS 2.92% TypeScript 33.02%

campaignfinance's Introduction

Campaign Finance Dashboard

Join the Google Group to join the discussion. Join us on Slack Questions? Email [email protected].

After registering join the #campaign-finance-dash-dev, #campaign-finance-dash-ux, and #campaign-finance-dash-data channels

Getting Started

See the contributing guide for instructions on running the project and more. See the project board for open tasks

Code of Conduct

All contributors are asked to follow the NC Open Pass code of conduct.

About

A lack of easy access to campaign finance data — that any citizen can search, sort and understand — undermines a transparent democracy. Our ability as voters and citizens to understand the people and corporations who fund the campaigns of our elected officials is key to making sense of policy outcomes and ensuring our elected officials have the public interest in mind when making vital decisions.

This project will put campaign finance for the General Assembly and statewide offices into an easily sortable and searchable dashboard to make sense of those who are funding campaigns of state leaders for use by citizens, journalists, activists, academics and others.

When this project is completed, the dashboard will provide both a comprehensive and — with only key search terms — granular look at a candidate’s contributors, expenses and outside independent group spending.

While this data is currently available through the N.C. State Board of Elections website, it is difficult to get answers to basic questions people might have about campaign finance here, such as: Who are this candidate’s biggest contributors? What industries give the most to North Carolina politicians? During the last election cycle, how much did a candidate spend on certain expenses, such as advertising?

See this presentation for a more detailed walk-through of the current SBE site and improvements this campaign finance Dashboard envisions.

There are three models that we can look to as instructive about the kind of dashboard we want to build. They are Illinois Sunshine, the Virginia Public Access Project (VPAP.org) and the National Institute on Money in Politics (FollowtheMoney.org).

These sites help you focus on what’s important and give you context for what it means.

Key aspects of those sites that make state campaign finance accessible:

Dynamic searching capacity. Ability to type in contributor, candidate, expense and see results across all data. Data likely combined for similar names by address or similar identifiers.

Data analysis at a glance, including: donations by industry, top contributors and expenses for each candidate, listing of ALL of a candidate’s relevant PACs and fundraising entities, listing of both candidate and outside PAC (Super PAC - see definition) spending. (See links for how those items are displayed).

campaignfinance's People

Contributors

Stargazers

Watchers

campaignfinance's Issues

Add disclaimer to site about data and accuracy

Search/Home Page: Search Bar & Quick Search Buttons

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

Route to get list of donations for a given contributor

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.

API Donations by Candidate

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

MVP User Flows

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:

[Spike] Candidate to Candidate PAC Reference

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

Pull in USWDS libraries

https://designsystem.digital.gov

Top user story: Support by employer

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).

Add info to contributing.md

[blocked] Create PAC Search function

Waiting on data

Donor and company search

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.

Upload Finance Extracts to AWS

Office search with all candidate

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.

Top user story: Companies support these candidates

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.

Top user story: Overall candidate support

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.

Submit request for 10 years of candidate finance data

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

Add styling to index.scss

Acquire domain name

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

Create Table component

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

MVP Sketches

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:

Connect with Democracy NC

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

About Page Redesign

Waiting on design

Totals and expenditures across active races

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.

Request and secure key raw data files

(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

MVP Wireframes

Create Wireframes for the 3 Primary User Stories:

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.
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).
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)

All candidate donations, spending, and expenditures

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

Add search bar to home page

Add NC outline as the background image to home/search page

Industry search

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.

Campaign Finance Dashboard Inspiration

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

Duplicate IDs and strange values in contributors table

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.

Aggregate search for Donor, Candidate, and PAC

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

Call Endpoint on Search/ add search query to route/ Changed candidate to donor for test data/ update table to display donor data

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

Setup frontend for the react app

Search Results Page: Search Bar, Quick Search Buttons and 3 Tab Table

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

API Quicksearch 2020 candidates

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

Users should be able to report inaccurate info

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

Header and footer

Example: https://openstates.org

Setup backend

migration etl and server setup

Private Policy

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

Create Candidates search function

Waiting on data from Jeremy

Add license to project

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

[Spike] Candidates, Contest, Election Cycle Reference Data

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

Data Dictionary and Glossary Pages

Waiting on content and design

Candidate Page: Candidate Info, Donors Table, and Download Results Button

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

Donors Table has filter options for each column.

Route search page, search results page, candidate page

Create Donor search function

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

Summarized Numbers for Candidate Pages

Summary info:
Total number of donations
Median donation
Largest donation

Add User Analytics

Shaun suggested looking into Hot Jar

API Quick search 2020 Donors

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

Ensure route can be limited and paginated

Recommend Projects

ncopenpass / campaignfinance Goto Github PK

campaignfinance's Introduction

Campaign Finance Dashboard

Getting Started

Code of Conduct

About

campaignfinance's People

Contributors

Stargazers

Watchers

Forkers

campaignfinance's Issues

Recommend Projects

Recommend Topics

Recommend Org