The Sector Profiles the US Border Patrol is released for each Fiscal Year containing statistics releated to border staffing, apprehensions, and seizures.
This repository was created to update the statistics for the Border Wall project at San Diego non-profit news organization inewsource.org. This is also my first test of a completely programtic scrape and clean of a dataset.
The current workflow scrapes the first table in each fiscal year's PDF and specifically focuses on the apprehensions and agent staffing at the southern border.
2017 Southern Border Apprehensions and Staffing Statistics by Sector:
Workflow for replicating the tasks:
-
run camelot_scrape.py in sector_profiles directory
-
run cleaning.py in camelot_scrape directory
-
run cleaning_analysis.py in sheets/camelot_scrape directory