This project cross-references Boston Police Department's spending, sourced from Boston's Checkbook Explorer, against companies listed on the Surveillance Industry Index.
The code is written in a Jupyter notebook and should hopefully be self-explanatory. A standard IPython 2.7 data analysis stack (including pandas) should be all that's necessary. The dependency on pandas can be eliminated with little effort.
Included in the repo:
ledger.csv
, a download of the Checkbook Explorer spreadsheet taken 2018-01-07;sii.html
, a copy of the Surveillance Industry Index's homepage saved 2018-01-07;bpd_sii.ipynb
, the actual code;purchases.csv
, a list of BPD purchases matching vendors listed on the Surveillance Industry Index, from the above two source files.
Because ledger.csv
is a large file, you may need to install Git Large File Storage in order to work with it.