Project Detail
Extraction Program and/or and Database Creation
Extraction Program and/or and Database Creation is project number 260672
posted at Freelancer.com. Click here to post your own project.
Bid Count: 44
Average Bid:
$ 375
05/14/2008 at 11:49 EDT
Project Creator:
dmlamos
Employer Rating: 
(14 reviews)
Description
Data Extraction Program and/Database CreationI 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: http://www.dc.state.fl.us/index.html
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: http://www.dc.state.fl.us/ActiveInmates/detail.asp?Bookmark=1&From=list&SessionID=801767350
Below is a summary of the details for Billy R. Aaron are below:
DC Number: V12799
Name: AARON, BILLY R
Race: WHITE
Sex: MALE
Hair Color: BLONDE OR STRAWBERRY
Eye Color: GREEN
Height: 5'09''
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: http://www.dc.state.fl.us/orginfo/facilitydir.html
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.
Provider Rating
WHAT IS FREELANCER.COM?
Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!
We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started!
Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.
- Plendo Sweden AB © 2004-2009
- PRIVACY POLICY
- TERMS
- AFFILIATES
- API
- QUOTES
- CONTACT
Freelancer™ is a trademark of Ignition Networks Pty Limited (ACN 134 845 748)
Newly Outsourced Projects fed by 
Follow our Freelance Jobs on Twitter 
Add to your
Google search results
Software & Free Downloads * Webmaster Resources * Webmaster Forum