Data Extraction Program and/Database Creation
I am open to discussions on price but within reason. The stated budget range is not the issue. The service and quality of the product and ease of use are. I know is actually high if the method is development of an extraction program. The budget is perhaps reasonable for creation of a database because of the volume of records. I am open to discuussion on which is the best way but time is important to me.
In any event my primary goal is to obtain a current searchable Florida Prisoners Database which is searchable and which may be sorted by various simple criteria. All the information to create this database for each prisoner is located on a single page for each prisoner. The single page is called the “Inmate Population Information Detail” sheet.
The database must be assembled individually from those single pages and this is why an extraction script is necessary.
To understand the project one must simply access the Florida Department of Corrections Website. Again, all the information to create this database for each prisoner is located on the Inmate Population Information Detail Sheet for each prisoner.
Prisoners in Florida Department of Corrections (a/k/a DOC) may be located here: [url removed, login to view]
Once here click Offender Search
Click ”Search All Corrections Offender Databases”
Locate all inmates in age range between 13 and 110
This should yield all records which number 98,000 records.
An example record is here: [url removed, login to view];From=list&SessionID=801767350
Below is a summary of the details for Billy R. Aaron are below:
DC Number: V12799
Name: AARON, BILLY R
Hair Color: BLONDE OR STRAWBERRY
Eye Color: GREEN
Weight: 196 lbs.
Birth Date: 06/21/1979
Initial Receipt Date: 06/15/2001
Current Facility: POLK C.I.
Current Custody: CLOSE
Current Release Date: 09/22/2027
The relevant fields for the desired database are:
DC Number, Name, Race, Sex, Birth Date, Initial Receipt Date, Current Facility, Custody Status, Current Release Date.
Note: Some prisoners may be sentenced to Life in Prison and this is noted as such for them.
I also want the database to have the current address of each inmate: A facility list for all correctional institutions is located here: [url removed, login to view]
So once the initial database is created and the current facility identified we need the address information to be added mailing purposes.
I am open to suggestions on how to best do this whether it be an extraction program and/or database creation.
I do not know the first thing about using a database program but I am under the impression that Access may be the best database program to use because it allows one to manipulate and examine data in various ways. However, I may be wrong and Excel may be sufficient however again, I would not know so I must rely upon the provider to suggest. I would also request assistance in learning how to use the database after it is completed due to my not being educated in the use of database programs.
Any Questions may be addressed through PM. Will pay a bonus to the provider who provides this database the fastest.
43 freelancere byder i gennemsnit $377 på dette job
Hello! We're a professional Russian and we're experts in the extraction area. We have couple variants of how to combine it and how to use it then. I'll provide you some details in PM. Regards. Sergey
No problem, I have my own web-scraping service and some dedicated servers just released for this task. I can obtain necessary database within some days and format as excel spreadsheet for you.