Spreadsheet of All County Jails and State Prisons Needed

PROJECT SUMMARY We are looking to create two excel spreadsheets – one for all the 2,900 county jail facilities in the United States and one for all the 1,800 state prison facilities in the United States. For each facility, the spreadsheets will have information about the facility, how to send mail to inmates, and how to send a money order to inmates. The uploaded “Facilities [login to view URL]” template contains a number of facility records as an example of how the fields should be entered. See the “FIELDS IN FACILITIES SPREADSHEET” section below for detailed information about the fields we need for each facility. All of the facility data that we need is public information that is available online. If you are interested in this project, please compile the information for the first 10 county jail facilities in the "Facilities Spreadsheet - All County Facilities in United [login to view URL]" document uploaded. Send the sample to us for review with your bid. DELIVERABLES This project will result in two excel spreadsheets: 1) One spreadsheet with every county facility: A spreadsheet with all the county facilities in the United States has been uploaded, titled “Facilities Spreadsheet - All County Facilities in United [login to view URL]”. 2) One spreadsheet for every state facility: A spreadsheet with all the state facilities in the United States has been uploaded, titled “Facilities Spreadsheet - All County Facilities in United [login to view URL]”. The following fields have already been populated in the spreadsheets: Facility – Name, Facility Location – Street Address 1, Facility Location - Street Address 2, Facility Location – City, Facility Location – State Abbreviation, Facility Location – Zip Code. POTENTIAL SOURCES OF DATA All of the facility data is public information that is available online. The links provided below are potential data sources that may be scraped when compiling the facility data. You may use any of these data sources or any other data source you find useful, as long as the data provided is accurate and complete. [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] MILESTONES The following milestone payments will be made: 1) 20% - Project Awarded 2) 20% - Submission of Facility Information – BLUE Columns in Facilities Spreadsheet 3) 20% - Submission of Inmate Mail Information – RED Columns in Facilities Spreadsheet 4) 40% - Submission of Inmate Money Orders Information – GREEN Columns in Facilities Spreadsheet For each milestone, the spreadsheet submitted by the freelancer will be tested for accuracy and completeness. Inaccuracies or missing fields will need to be resolved before the milestone is marked as complete. SCHEDULE Each milestone should be completed on or before the timeline provided below: 1) Project Awarded – N/A 2) Facility Information – within 7 days of project being awarded 3) Inmate Mail Information – within 10 days of project being awarded 4) Inmate Money Orders Information – within 14 days of project being awarded