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 publicly-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

 

Faculty Lead: Paul Bendich

Client: Budget and Tax Center, North Carolina Justice Center

Project Manager: Tyler Ransom, post-doc, SSRI

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: Austin Talbot

Investigating oil and gas production in the United Kingdom

Aaron Chai (Computer Sciece, Math) and Victoria Worsham (Economics, Math) spent ten weeks building tools to understand characteristics of successful oil and gas licenses in the North Sea. The team used data-scraping, merging, and OCR method to create a dataset containing license information and work obligations, and they also produced ArcGIS visualizations of license and well locations. They had the chance to consult frequently with analytics professionals at ExxonMobil.

Click here to read the Executive Summary

 

Project Lead: Kyle Bradbury

Project Manager: Artem Streltsov

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

Yueru Li (Math) and Jiacheng Fan (Economics, Finance) spent ten weeks investigating abnormal behavior by companies bidding for oil and gas rights in the Gulf of Mexico. Working with data provided by the Bureau of Ocean Energy Management and ExxonMobil, the team used outlier detection methods to automate the flagging of abnormal behavior, and then used statistical methods to examine various factors that might predict such behavior. They had the chance to consult frequently with analytics professionals at ExxonMobil.

 

Click here to read the Executive Summary

 

Project Lead: Kyle Bradbury

Project Manager: Hyeongyul Roh

See all Research