The data and analysis in this repository fueled the CBS News California investigation into Caltrans claims. The data was provided by Caltrans via a California Public Records Act request, reference number R024170-062723, submitted on June 27, 2023.
The folders and files included in this repo are as follows:
-
caltrans-district-data: .csvs with information about caltrans districts
-
geo-data: Geographic data for county boundaries and state highways. (Source for highway data)
-
output: Output files from analysis.
- Includes a (relatively) clean version of the raw data from Caltrans. Cleaned/added columns include the incident date and year, a cleaned version of the "status," "route," and "amount" columns. Other added columns include whether or not the claim mention potholes or construction work, and if the amount paid/sought/status columns made sense in relation to each other.
-
scripts: All the R scripts used for analysis. They are numbered in the order they should be run in.
Contact grace.manthey@cbsnews.com with any questions.