John Friedman Email & Phone Number

Los Angeles, Ca, Us

Los Angeles, Ca, Us

Berkeley, California, United States

Strengthening State Capacity - American Economic Review: Delivered dataset used for paper on civilservice exam $30,000 under budget and months ahead of time by utilizing machine learning and regex to clean and link extremely messy civil servant name and job strings with US census data. Additionally, geocoded messy historical post office location strings by creating a custom Wikipedia Geocoder package in R.Ideology and Performance in Public Organizations - Econometrica: Enabled research on ideological alignment’s impact on government performance by scraping and processing 5TB of federal contract data. Delivered a comprehensive dataset covering all federal contracts from 1997 to 2022, surpassing expectations which initially called for a smaller dataset.The Costs of Employment Segregation - Quarterly Journal of Economics: Utilized fuzzy matching andregex techniques to link 700,000 messy job title strings extracted from federal records to the US Census.Results surpassed the Census Linking Project, the academic gold standard, in accuracy and percent linked.A Glimpse of Freedom: Political Resistance in East Germany - American Economic Journal: Facilitateddata visualization of political resistance to Soviets by using advanced visualization techniques in ggplot2.Beyond the War - Forthcoming: Enabled the tracking of generational effects by employing specialized web scraping techniques to gather family tree data. Utilized advanced statistical methodologies including linear models with multiple levels of fixed effects and coarsened exact matching to isolate and analyze generational effects with precision.Forthcoming Paper : Constructed a comprehensive database of US government regulations for a research paper, surpassing commercial alternatives in accuracy and scope. Uniquely, enabled regulation lookup by civil servant signature.

Berkeley, California, United States

Bureaucratic Representation and State Responsiveness - Review of Economics & Statistics: Accelerated research progress by several months by learning how to use Google Cloud Vision to convert 100,000 scans of historical British Blue Book tables into text format. Additionally, I learned PyQt so I could construct a GUI that facilitated manual verification of data accuracy, thus enhancing productivity. Secured $300 in free Google credit to enable utilization of the tool.Provided research and editing support for The Glittering Prizes (Review of Economic Studies), The Colonial Origins of Fiscal Capacity (Journal of Comparative Economics), and The Costs of Patronage (American Economic Review).

Berkeley, California, United States

Manually cleaned datasets for use analysing the effects of bureaucratic representation.Used R’s ‘rvest’ package and Javascript to ‘scrape’ data on British Governors into a dataset for use in patronage analysis.Searched library archives, including microfiche, and the internet for data on British India’s District Commissioners.

Berkeley, California, United States

Evaluated manuscripts to be sent for peer review

Berkeley, California, United States

Wrote a guidebook to the Korean CDC’s government playbook on Covid-19 for quick reading by academics, politicians, and medical professionals.Recorded and contributed information about current testing efforts, and known aspects of the Coronavirus, at online meetings of Massachusetts medical professionals, government officials leading contact-tracing efforts, and members of the Governor’s coronavirus committee, such as Professor Simon Johnson.

Cambridge, Massachusetts, United States

I worked for Professor Simon Johnson (MIT Sloan) and Jon Gruber (MIT Economics).Conducted research on education policies, and wrote a policy paper examining their effects that was included in an MIT report circulated within Congress.Constructed a dataset of Amazon warehouses and fulfillment centers, and analyzed their price effects on land value.Supervised a team of high school interns collecting economic data on metropolitan areas.Used RShiny to create and deploy apps to compare metropolitan areas by economic indicators.

Berkeley, California, United States

I worked for Professor Simon Johnson (MIT Sloan) and Jon Gruber (MIT Economics).Edited and researched material for the book Jump-Starting America, as well as writing one paragraph.

Doctor Of Philosophy - Phd, Economics

Activities and Societies: Salsa Society @ UCLAPhD student focusing on Applied Microeconomics.

Bachelor'S Degree, Economics, 3.5

Activities and Societies: Salsa @ CalI double majored in Economics and Statistics. Due to covid-19, I dropped out a year early to work.