NC Budget Data and Policy

Project Summary

Artem Streltsov (Masters Economics) and IIT Mechanical Engineering major Vinod Ramakrishnan spent ten weeks exploring North Carolina state budget documents. Working closely with the Budget and Tax Center, part of the North Carolina Justice Center, their goal was to help build a keystone tool that can be used for analysis of the state budget as well as future budget proposals.

Themes and Categories
Public Policy
Data+
Year
2016

Project Results

The team used the statistical programming language R to transform publically-available state budget documents from a very awkward .pdf file format into an analyzable data frame. They then used Tableau to construct a data visualization tool capable of simulating the effect of proposed policy changes on past, present, and future budget allocations.

Download Executive Summary (PDF)

Video

 

Client

Project Manager

Participants

  • Artem Streltsov, Master's student in Economics
  • Vinod Ramakrishnan, Indian Institute of Technology

"It was really wonderful experience for me. And, especially this foreign exposure only at the end of my sophomore year is a huge confidence booster. All the projects were interesting and it was awesome to work in a productive and collaborative environment." Vinod Ramakrishnan, Indian Institute of Technology

Disciplines Involved

  • Public Policy
  • Political Science
  • Economics
  • All quantitative STEM

Related People

Related Projects

Getting Granular on Social Determinants of Health

Social and environmental contexts are increasingly recognized as factors that impact health outcomes of patients. This team will have the opportunity to collaborate directly with clinicians and medical data in a real-world setting. They will examine the association between social determinants with risk prediction for hospital admissions, and to assess whether social determinants bias that risk in a systematic way. Applied methods will include machine learning, risk prediction, and assessment of bias. This Data+ project is sponsored by the Forge, Duke's center for actionable data science.

Project Leads: Shelly Rusincovitch, Ricardo Henao, Azalea Kim

Project Manager: TBD

Investigating oil and gas production in the United Kingdom

Producing oil and gas in the North Sea, off the coast of the United Kingdom, requires a lease to extract resources from beneath the ocean floor and companies bid for those rights. This team will consult with professionals at ExxonMobil to understand why these leases are acquired and who benefits. This requires historical data on bid history to investigate what leads to an increase in the number of (a) leases acquired and (b) companies participating in auctions. The goal of this team is to create a well-structured dataset based on company bid history from the U.K. Oil and Gas Authority; data which will come from many different file structures and formats (tabular, pdf, etc.). The team will curate these data to create a single, tabular database of U.K. bid history and work programs.

On the Shelf: exploring oil and gas production in the Gulf of Mexico

Producing oil and gas in the Gulf of Mexico requires rights to extract these resources from beneath the ocean floor and companies bid into the market for those rights. The top bids are sometimes significantly larger than the next highest bids, but it’s not always clear why this differential exists and some companies seemingly overbid by large margins. This team will consult with professionals at ExxonMobil to curate and analyze historical bid data from the Bureau of Ocean Energy Management that contains information on company bid history, infrastructure, wells, and seismic survey data as well as data from the companies themselves and geopolitical events. The stretch goal of the team will be to see if they can uncover the rationale behind historic bidding patterns. What do the highest bidders know that other bidders to not (if anything)? What characteristics might incentivize overbidding to minimize the risk of losing the right to produce (i.e. ambiguity aversion)?