Coding Challenge

I made this to try to help a friend, using ruby 3.0.5 or node 18.16.0.

After installing ruby, run:

• ruby services/legislator-votes-exporter.rb
• ruby services/legislator-bills-exporter.rb

Or after installing node, run:

• node services/legislator-votes-exporter.js
• node services/legislator-bills-exporter.js

Overview

We collect and organize a large amount of publicly available government data. For example, we provide our clients the ability to visualize all of the bills that legislators voted for or against. To represent this data, we have the following important data models:

Person - An individual legislator elected to government. This includes everyone from President Joe Biden to Representative. David McKinley from West Virginia.

Bill - A piece of legislation introduced in the United States Congress.

Vote - A vote on a particular Bill. Bills can be voted on multiple times, as the Bill itself can undergo changes over the course of its life. For the purposes of this challenge, there will only be up to 1 Vote provided for each Bill.

VoteResult - A vote cast by an individual legislator for or against a piece of legislation. Each vote cast is associated with a specific Vote.

See the provided data for schema information for each of the data models.

Provided Data

You will be provided with a dataset comprised of the following four files: bills.csv, legislators.csv, votes.csv, vote_results.csv

vote_results.csv

Field	Type	Description
id	integer	The id of the VoteResult
legislator_id	integer	The id of the legislator casting a vote
vote_id	integer	The id of the Vote associated with this cast
vote_type	integer	The type of vote cast 1 for yea and 2 for nay

Deliverables

You will be provided with a list of legislators, bills, votes, and vote results as specified above. You’ll be asked to answer the following questions:

1. For every legislator in the dataset, how many bills did the legislator support (voted for the bill)? How many bills did the legislator oppose?
2. For every bill in the dataset, how many legislators supported the bill? How many legislators opposed the bill? Who was the primary sponsor of the bill?

Your program should take in the data provided and output a CSV for each of the questions in Part 1. For example, you might name the first file legislators-support-oppose-count.csv.

Field	Type	Description
id	integer	The id of the legislator
name	string	The name of the legislator
num_supported_bills	integer	The number of bills the legislator voted Yea on from the dataset
num_opposed_bills	integer	The number of bills the legislator voted Nay on from the dataset

You might name the second file bills.csv. Each row in this CSV should represent a bill and have the following columns:

Field	Type	Description
id	integer	The id of the bill
title	string	The title of the bill
supporter_count	integer	The number of legislators that supported this bill in the vote for it
opposer_count	integer	The number of legislators that opposed this bill in the vote for it
primary_sponsor	string	The name of the primary sponsor of the bill. If the name of the sponsor is not available in the dataset, the cell should be “Unknown”