DATABASE CAN BE ACCESSED BY THIS:

www.papademas.net/phpmyadmin

username = "db411";

password = "411";

Objective To write a program that creates a Loan analysis report from class objects created in lab #2/3.

PROJECT DESCRIPTION

Bank of IIT now needs your help in deciphering whom from its records should be exlusive to premium loans versus those offered micro or less premium loans.

Use a database to store then present Loan analysis information from your data BankRecords objects you worked on in prior labs.

Project Details

For this lab you will continue using your current project folder created for labs 2 & 3 and create a new file called Dao where Dao stands for Data Access Object. This will allow for CRUD database connectivity and operations. Create also a file called LoanProcessing as well which will act as a driver file (i.e., includes main function) to call your database CRUD methods and create some resulting output.

To start working with a database you will need a JDBC driver to allow for any connectivity within your app.

To include a driver for your MySQL database, you need to create a folder called libs within your project. The MySQL driver for JDBC connections packages in the form of a jar file which you can download here:

You will find a JDBC driver for connecting to a MySQL database located here:

https://dev.mysql.com/downloads/connector/j/

Depending on your OS you will need to download a windows zip file or a tar file if you are a Mac/Linux user. Unzip or untar the DOWNLOADED file and locate the needed .jar file and copy it into into your libsfolder.

Make sure to include the jar file in your Build Path by right clicking on your project folder and then choose Build Path > Configure Build Path....

Once the dialog box opens make sure to click on the Libraries tab then click Add JARs

Drill down to the libs folder within your project and then choose the jar file to add.

Click OK to commit.

Start coding your Dao class file. Include the following methods for your file.

-A method to create a database table called createTable. createTable merely creates a table when called. Include an id field, an income field and a pep field when building your table setup.

[ Note when creating a table it is IMPERATIVE to include the following name:

yourFirstinitial_First4LettersOfYourLastName_tab ]

-A method to insert records called insertRecords().

-A method to retrieve records for display called retrieveRecords().

In order to communicate or connect with your database (which will be located on the papaserver) for CRUD operations, youll need to include certain credentials. Use the data below for establishing a JDBC connection to the papaserver.

url = "jdbc:mysql://www.papademas.net:3306/411labs?autoReconnect=true&useSSL=false";

username = "db411";

password = "411";

Methods breakdown

insertRecords(BankRecords [] arrayName) will allow for the array of BankRecord objects, to be passed to your method which will allow for the insertion of all the id, income and pep data from your BankRecords array (or whatever you named it) into your database table when called. Make sure then to extend your Dao class to include your BankRecords class to allow data to be obtained.

retrieveRecords() will return a ResultSet object used for creating output. Have the result set contain the record data consisting of the id, income and pep fields. Sort the pep field in descending order to allow for premium loan candidates to appear first in the record set for reporting purposes (i.e., those with data values of YES). The resultset query string to build can be something like:

String sql =

"select id,income, pep from your_table_name order by pep desc";

Make sure to always close out of your connections and any statements when through with any processing!

Make sure to include error trapping using SQLException handling for all your database operations and connection logic.

Also include messages to the console when your methods trigger. Ex. Table created, Inserting records into database, etc.

For your LoanProcessing source file also extend BankRecords. Include in main() your readData() method call which will process your BankRecord objects. Then instantiate a Dao object and trigger your createTable(), insertRecords(your BankRecords array object) and retrieveRecords() methods in that order.

Once you have retrieved a recordset, print out all the records from the recordset to the console in a nice columnar format included with heading names for id, income and pep. Doesnt hurt to have a title too, like Loan Analysis Report.

BankRecords.java

/*

Shan Shazad

03/06/17

BankRecords.java

Lab 4

*/

package lab4;

import java.io.BufferedReader; //import necessary classes for program

import java.io.FileReader;

import java.io.IOException;

import java.text.SimpleDateFormat;

import java.util.ArrayList;

import java.util.Arrays;

import java.util.Calendar;

import java.util.List;

public class BankRecords implements Client // using client methods reads and processes data

{

//this makes the objects for processing & controlling information

static BankRecords shazad[]= new BankRecords[600]; //this means that the fields are about 600

static List> array = new ArrayList<>(); // used for array listing

// from the csv file, using the instance field these are the names. we are addressing this private variables

private String id;

private int age;

private String sex;

private String region;

private double income;

private String married;

private int children;

private String car;

private String save_act;

private String current_act;

private String mortgage;

private String pep;

// these are the bank records constructors for the following from above.

public BankRecords()

{

}

public BankRecords(String id, int age, String sex, String region, double income, String married, int children, String car, String save_act, String current_act, String mortgage, String pep)

// list for the strings

{

super();

this.id = id;

this.age = age;

this.sex = sex;

this.region = region;

this.income = income;

this.married = married;

this.children = children;

this.car = car;

this.save_act = save_act;

this.current_act = current_act;

this.mortgage = mortgage;

this.pep = pep;

}

// this is how the main setup of the program for sending and getting

public String getId() {

return id;

}

public void setId(String id) {

this.id = id;

}

public int getAge() {

return age;

}

public void setAge(int age) {

this.age = age;

}

public String getSex() {

return sex;

}

public void setSex(String sex) {

this.sex = sex;

}

public String getRegion() {

return region;

}

public void setRegion(String region) {

this.region = region;

}

public double getIncome() {

return income;

}

public void setIncome(double income) {

this.income = income;

}

public String getMarried() {

return married;

}

public void setMarried(String married) {

this.married = married;

}

public int getChildren() {

return children;

}

public void setChildren(int children) {

this.children = children;

}

public String getCar() {

return car;

}

public void setCar(String car) {

this.car = car;

}

public String getSave_act() {

return save_act;

}

public void setSave_act(String save_act) {

this.save_act = save_act;

}

public String getCurrent_act() {

return current_act;

}

public void setCurrent_act(String current_act) {

this.current_act = current_act;

}

public String getMortgage() {

return mortgage;

}

public void setMortgage(String mortgage_act) {

this.mortgage = mortgage_act;

}

public String getPep() {

return pep;

}

public void setPep(String pep) {

this.pep = pep;

}

public static void readData() // the public static void reads the data from the location for the csv

{

String line = "";

// the buffered processes the files by reading it

try (BufferedReader br = new BufferedReader(new FileReader("/Users/shanshahzad/Desktop/Eclipse/lab4/src/lab4/bank-Detail.csv"))) { //try catch

while ((line=br.readLine())!=null) // gets data from file

array.add(Arrays.asList(line.split(",")));

// marks from the data

} catch (IOException e) { // this is the exception only for the catch

e.printStackTrace();

}

processData(); //this then runs the data

}

public static void processData() {

// process data runs the data again...

int idx=0;

for (List rowData: array){

// the array for string and lists

// using of setters to show the array of objects

shazad[idx] = new BankRecords();

shazad[idx].setId(rowData.get(0));

shazad[idx].setAge(Integer.parseInt(rowData.get(1)));

// translate it to a string

shazad[idx].setSex(rowData.get(2));

shazad[idx].setRegion(rowData.get(3));

shazad[idx].setIncome(Double.parseDouble(rowData.get(4)));

// double to a string

shazad[idx].setMarried(rowData.get(5));

shazad[idx].setChildren(Integer.parseInt(rowData.get(6)));

// int to a string

shazad[idx].setCar(rowData.get(7));

shazad[idx].setSave_act(rowData.get(8));

shazad[idx].setCurrent_act(rowData.get(9));

shazad[idx].setMortgage(rowData.get(10));

shazad[idx].setPep(rowData.get(11));

idx++;

}

// displays the data, and to actually show the next step to display it

Records derp = new Records();

derp.dataAnalytic();

}

public static void printData() //method for printing the data

{

System.out.printf("%-13s%13s%13s%13s%13s%13s%n", "ID" , "AGE", "SEX", "REGION", "INCOME", "MORTGAGE", "CAR");

//display the headings for columns

// shows the headings for columns

// generates the loop to show each object current value

for(int i=0;i<25;i++) // loops for the first 25

// shows the loop

System.out.printf("%-13s%13s%13s%13s%13s%13s%n", shazad[i].getId(), shazad[i].getAge(), shazad[i].getSex(), shazad[i].getRegion(), shazad[i].getIncome(), shazad[i].getMortgage(), shazad[i].getCar());

// format with 6 columns for the id, age, sex, region, income, and mortgage

System.out.println("------------------------------------------------------------------");

Records foo = new Records();

foo.dataAnalytic();

}

public static void main(String[] args) // method

{

readData(); // read data is the first method being used here

System.out.println();

String timeStamp = new SimpleDateFormat("yyyy/MM/dd HH:mm:ss").format(Calendar.getInstance().getTime()); // time format

System.out.println("Cur dt=" + timeStamp + " Programmed by Shan Shazad "); // lastly, this will then show my name and the current time!

} //end method

} //end

Client.java

package lab4;

/*

Shan Shazad

02/09/2017

Client.java

Lab 3

*/

public interface Client {

public static void readData(){} // looks up the file details

public static void processData() {} // goes over the main file detail

public static void printData() {} // displays the file detail

//end

}

Records.java

/* Shan Shazad 03/01/17 Records.java Lab 4 */

package lab4;

import java.io.FileNotFoundException; import java.io.PrintStream; import java.text.DecimalFormat; import java.util.Arrays; import java.util.Collections; import java.util.Comparator; import java.util.HashMap;

// using information from BankRecords file

public class Records extends BankRecords {

// number printout PrintStream out; private static DecimalFormat df2 = new DecimalFormat(".##");

public void dataAnalytic() { // the whole number for average income // the max and min age for every point // amount of females that have mortgages

// generates and shows data to a text file named bankrecrods.txt // try and catches for the file

try {

out = new PrintStream("bankrecords.txt");

} catch (FileNotFoundException e) {

e.printStackTrace();

}

// this array is sorting records based on location Arrays.sort(BankRecords.shazad, new BankRecordsComp());

// total for average income overallAverageIncome(); // max and min per location

maxAndMinAgePerLocation(); // amount of females with mortgages

numberOfFemalesWithMortgages();

maleAndCar(); // displays programmers name

out.println("Stamp: Shan Shazad / 03/01/17 ");

}

public void overallAverageIncome() {

double sum = 0;

for (BankRecords br : shazad) {

sum = sum + br.getIncome();

} // shows the amount for average income

double avg = sum / shazad.length;

System.out.println("- The overall avaerage income is: $ " + df2.format(avg));

out.println("- The overall avaerage income is: $ " + df2.format(avg));

} // code for max and min for the location, also gets the information

public void maxAndMinAgePerLocation() {

HashMap minMap = new HashMap<>();

HashMap maxMap = new HashMap<>();

for (BankRecords br : shazad) {

if (!minMap.containsKey(br.getRegion())) {

minMap.put(br.getRegion(), br.getAge());

} else {

if (minMap.get(br.getRegion()) > br.getAge())

minMap.put(br.getRegion(), br.getAge());

}

if (!maxMap.containsKey(br.getRegion())) {

maxMap.put(br.getRegion(), br.getAge());

} else {

if (maxMap.get(br.getRegion()) < br.getAge())

maxMap.put(br.getRegion(), br.getAge());

}

} // shows location

System.out.println("* Biggest max age per place: " + maxMap);

System.out.println("* Min age per place : " + minMap);

out.println("* Biggest max age per place: " + maxMap);

out.println("* Min age per place : " + minMap);

} // code for record mortgages

public void numberOfFemalesWithMortgages() {

int sum = 0;

for (BankRecords br : shazad) {

if (br.getSex().contentEquals("FEMALE") && br.getMortgage().equals("YES"))

sum++;

}

System.out.println("* Amount of females that have mortgages: " + sum);

out.println("* Amount of females that have mortgages: " + sum);

}

public void maleAndCar() {

// amount of men that have a car and one child for every location

HashMap maleCarChild = new HashMap<>();

for (BankRecords br : shazad) {

if (br.getSex().contentEquals("MALE") && br.getCar().equals("YES") && br.getChildren() == 1) {

if (!maleCarChild.containsKey(br.getRegion())) {

maleCarChild.put(br.getRegion(), 1);

} else {

maleCarChild.put(br.getRegion(), maleCarChild.get(br.getRegion()) + 1);

}

}

}

System.out.println("* Amount of men that have a car and one child per place: " + maleCarChild);

out.println("* Amount of men that have a car and one child per place: " + maleCarChild);

}

} class BankRecordsComp implements Comparator {

@Override

public int compare(BankRecords o1, BankRecords o2) {

return o1.getRegion().compareToIgnoreCase(o2.getRegion());

}

}

// end

bank-Detail.csv

ID12101,48,FEMALE,INNER_CITY,22467,YES,0,YES,YES,NO,YES,YES ID12102,40,MALE,TOWN,32825,NO,3,NO,YES,YES,NO,YES ID12103,51,FEMALE,INNER_CITY,16575.4,NO,1,NO,NO,YES,YES,YES ID12104,23,FEMALE,TOWN,20375.4,NO,0,YES,YES,YES,YES,NO ID12105,57,FEMALE,RURAL,50576.3,NO,2,YES,NO,NO,YES,NO ID12106,57,FEMALE,TOWN,37869.6,YES,3,NO,YES,YES,YES,YES ID12107,22,MALE,RURAL,8877.07,YES,1,YES,NO,YES,NO,YES ID12108,58,MALE,TOWN,24946.6,NO,2,NO,YES,YES,NO,NO ID12109,37,FEMALE,SUBURBAN,25304.3,YES,3,NO,NO,NO,NO,NO ID12110,54,MALE,TOWN,24212.1,YES,2,YES,YES,YES,NO,NO ID12111,66,FEMALE,TOWN,59803.9,YES,0,NO,YES,YES,NO,NO ID12112,52,FEMALE,INNER_CITY,266222.8,NO,0,YES,YES,YES,YES,NO ID12113,44,FEMALE,TOWN,15735.8,YES,1,NO,YES,YES,YES,YES ID12114,66,FEMALE,TOWN,55204.7,YES,1,YES,YES,YES,YES,YES ID12115,36,MALE,RURAL,19474.6,YES,0,NO,YES,YES,YES,NO ID12116,38,FEMALE,INNER_CITY,22342.1,YES,0,YES,YES,YES,YES,NO ID12117,37,FEMALE,TOWN,17729.8,YES,2,NO,NO,NO,YES,NO ID12118,46,FEMALE,SUBURBAN,41016,YES,0,NO,YES,NO,YES,NO ID12119,62,FEMALE,INNER_CITY,26909.2,YES,0,NO,YES,NO,NO,YES ID12120,31,MALE,TOWN,22522.8,YES,0,YES,YES,YES,NO,NO ID12121,61,MALE,INNER_CITY,57880.7,YES,2,NO,YES,NO,NO,YES ID12122,50,MALE,TOWN,16497.3,YES,2,NO,YES,YES,NO,NO ID12123,54,MALE,INNER_CITY,38446.6,YES,0,NO,YES,YES,NO,NO ID12124,27,FEMALE,TOWN,15538.8,NO,0,YES,YES,YES,YES,NO ID12125,22,MALE,INNER_CITY,12640.3,NO,2,YES,YES,YES,NO,NO ID12126,56,MALE,INNER_CITY,41034,YES,0,YES,YES,YES,YES,NO ID12127,45,MALE,INNER_CITY,20809.7,YES,0,NO,YES,YES,YES,NO ID12128,39,FEMALE,TOWN,20114,YES,1,NO,NO,YES,NO,YES ID12129,39,FEMALE,INNER_CITY,29359.1,NO,3,YES,NO,YES,YES,NO ID12130,61,MALE,RURAL,24270.1,YES,1,NO,NO,YES,NO,YES ID12131,61,FEMALE,RURAL,22942.9,YES,2,NO,YES,YES,NO,NO ID12132,20,FEMALE,TOWN,16325.8,YES,2,NO,YES,NO,NO,NO ID12133,45,MALE,SUBURBAN,23443.2,YES,1,YES,YES,YES,NO,YES ID12134,33,FEMALE,INNER_CITY,29921.3,NO,3,YES,YES,NO,NO,NO ID12135,43,MALE,SUBURBAN,37521.9,NO,0,NO,YES,YES,NO,YES ID12136,27,FEMALE,INNER_CITY,19868,YES,2,NO,YES,YES,NO,NO ID12137,19,MALE,RURAL,10953,YES,3,YES,YES,YES,NO,NO ID12138,36,FEMALE,RURAL,13381,NO,0,YES,NO,YES,NO,YES ID12139,43,FEMALE,TOWN,18504.3,YES,0,YES,YES,YES,NO,NO ID12140,66,FEMALE,SUBURBAN,25391.5,NO,2,NO,NO,YES,NO,NO ID12141,55,MALE,TOWN,26774.2,YES,0,NO,NO,YES,YES,YES ID12142,47,FEMALE,INNER_CITY,26952.6,YES,0,YES,NO,YES,NO,NO ID12143,67,MALE,TOWN,55716.5,NO,2,YES,YES,NO,NO,YES ID12144,32,FEMALE,TOWN,27571.5,YES,0,YES,NO,YES,YES,NO ID12145,20,MALE,INNER_CITY,13740,NO,2,YES,YES,YES,YES,NO ID12146,64,MALE,INNER_CITY,52670.6,YES,2,NO,YES,YES,YES,YES ID12147,50,FEMALE,INNER_CITY,13283.9,NO,1,YES,YES,YES,NO,YES ID12148,29,MALE,INNER_CITY,13106.6,NO,2,NO,YES,YES,YES,YES ID12149,52,MALE,INNER_CITY,39547.8,NO,2,YES,NO,YES,NO,YES ID12150,47,FEMALE,RURAL,17867.3,YES,2,YES,YES,NO,NO,NO ID12151,24,MALE,TOWN,14309.7,NO,2,YES,YES,NO,NO,NO ID12152,36,MALE,TOWN,23894.8,YES,0,NO,NO,NO,NO,NO ID12153,43,MALE,TOWN,16259.7,YES,1,NO,YES,YES,NO,YES ID12154,48,MALE,SUBURBAN,29794.1,NO,1,NO,YES,YES,NO,YES ID12155,63,MALE,TOWN,56842.5,YES,0,NO,YES,YES,YES,NO ID12156,52,FEMALE,RURAL,47835.8,NO,3,NO,YES,NO,NO,YES ID12157,58,FEMALE,INNER_CITY,24977.5,NO,0,NO,NO,YES,NO,YES ID12158,28,MALE,INNER_CITY,23124.9,YES,0,NO,YES,YES,NO,YES ID12159,29,FEMALE,INNER_CITY,15143.8,YES,0,NO,NO,YES,NO,NO ID12160,34,MALE,INNER_CITY,25334.3,NO,1,YES,YES,YES,YES,YES ID12161,42,FEMALE,INNER_CITY,24763.3,YES,1,NO,YES,YES,YES,YES ID12162,65,FEMALE,INNER_CITY,36589,NO,1,YES,NO,YES,NO,YES ID12163,47,MALE,INNER_CITY,27022.6,YES,2,NO,YES,YES,NO,NO ID12164,20,MALE,INNER_CITY,11700.4,YES,0,NO,YES,NO,NO,NO ID12165,21,MALE,TOWN,5014.21,NO,0,YES,YES,YES,YES,NO ID12166,42,MALE,INNER_CITY,17390.1,YES,0,NO,YES,YES,NO,NO ID12167,19,MALE,TOWN,10861,NO,2,NO,YES,YES,NO,NO ID12168,41,FEMALE,TOWN,34892.9,NO,0,NO,YES,YES,YES,NO ID12169,30,MALE,TOWN,19403.1,NO,2,NO,YES,YES,NO,NO ID12170,31,FEMALE,RURAL,10441.9,YES,2,NO,NO,YES,NO,YES ID12171,25,MALE,INNER_CITY,14064.9,YES,3,YES,YES,YES,NO,NO ID12172,21,MALE,INNER_CITY,8062.73,NO,0,NO,NO,YES,NO,YES ID12173,36,MALE,INNER_CITY,31982,YES,3,YES,YES,YES,YES,YES ID12174,58,FEMALE,INNER_CITY,23197.5,YES,2,NO,YES,NO,YES,NO ID12175,64,FEMALE,INNER_CITY,52674,NO,2,YES,YES,YES,NO,YES ID12176,59,FEMALE,RURAL,35610.5,NO,2,YES,NO,NO,NO,YES ID12177,45,FEMALE,TOWN,26948,NO,0,NO,YES,YES,YES,NO ID12178,61,MALE,INNER_CITY,49456.7,YES,1,YES,YES,YES,YES,YES ID12179,30,FEMALE,INNER_CITY,14724.5,YES,0,YES,NO,YES,NO,NO ID12180,58,FEMALE,TOWN,34524.9,YES,2,YES,YES,NO,NO,YES ID12181,50,FEMALE,TOWN,22052.1,NO,3,NO,YES,YES,NO,YES ID12182,30,MALE,INNER_CITY,27808.1,NO,3,NO,NO,YES,NO,NO ID12183,29,FEMALE,INNER_CITY,12591.4,YES,1,NO,YES,YES,NO,NO ID12184,35,MALE,INNER_CITY,16394.4,YES,1,NO,YES,YES,NO,YES ID12185,62,MALE,INNER_CITY,24026.1,YES,0,NO,NO,YES,YES,YES ID12186,36,MALE,INNER_CITY,31683.1,YES,1,YES,YES,YES,NO,YES ID12187,25,FEMALE,INNER_CITY,15525,YES,0,NO,YES,YES,NO,NO ID12188,66,FEMALE,TOWN,22562.2,NO,0,YES,YES,YES,YES,NO ID12189,30,MALE,SUBURBAN,15848.7,YES,0,YES,YES,NO,YES,NO ID12190,54,FEMALE,INNER_CITY,31095.6,YES,2,NO,NO,YES,NO,YES ID12191,37,MALE,TOWN,24814.5,YES,1,YES,NO,YES,YES,YES ID12192,28,FEMALE,INNER_CITY,25429.3,NO,2,NO,YES,YES,YES,NO ID12193,53,FEMALE,RURAL,34866.5,NO,0,NO,NO,YES,NO,YES ID12194,61,MALE,INNER_CITY,42579.1,YES,2,YES,YES,YES,NO,NO ID12195,61,FEMALE,INNER_CITY,41127.4,YES,0,YES,YES,NO,NO,NO ID12196,18,FEMALE,INNER_CITY,9990.11,YES,0,NO,YES,YES,NO,NO ID12197,22,MALE,INNER_CITY,7948.62,YES,1,NO,NO,NO,YES,NO ID12198,34,MALE,TOWN,30870.8,YES,2,YES,YES,YES,YES,YES ID12199,35,FEMALE,INNER_CITY,12125.8,NO,2,NO,YES,YES,NO,NO ID12200,18,FEMALE,RURAL,15348.9,YES,0,YES,NO,YES,NO,NO ID12201,54,MALE,INNER_CITY,26707.9,YES,1,NO,YES,YES,YES,YES ID12202,27,FEMALE,INNER_CITY,11604.4,YES,2,YES,YES,YES,NO,NO ID12203,42,MALE,INNER_CITY,15499.9,YES,0,YES,NO,YES,YES,YES ID12204,43,MALE,TOWN,33088.5,NO,0,NO,YES,YES,YES,NO ID12205,64,FEMALE,INNER_CITY,34513.6,YES,1,NO,YES,YES,NO,YES ID12206,43,MALE,TOWN,32395.5,YES,3,YES,YES,YES,NO,NO ID12207,49,MALE,RURAL,46633,YES,0,YES,YES,NO,NO,NO ID12208,23,MALE,INNER_CITY,13039.9,YES,0,NO,NO,YES,NO,NO ID12209,23,MALE,INNER_CITY,12681.9,NO,0,NO,YES,YES,NO,YES ID12210,30,FEMALE,INNER_CITY,24031.5,YES,2,YES,YES,YES,YES,NO ID12211,36,MALE,TOWN,37330.5,NO,2,NO,YES,YES,NO,YES ID12212,34,MALE,INNER_CITY,25333.2,YES,3,YES,NO,NO,YES,NO ID12213,51,FEMALE,INNER_CITY,37094.2,YES,0,YES,NO,YES,NO,NO ID12214,36,MALE,TOWN,33630.6,NO,2,YES,YES,YES,NO,YES ID12215,56,MALE,INNER_CITY,43228.2,YES,1,YES,YES,YES,NO,YES ID12216,54,FEMALE,INNER_CITY,47796.8,YES,0,NO,YES,YES,NO,NO ID12217,56,FEMALE,TOWN,21730.3,YES,2,NO,YES,NO,NO,NO ID12218,26,MALE,INNER_CITY,10044.1,YES,3,NO,YES,YES,YES,NO ID12219,39,MALE,TOWN,17270.1,NO,0,YES,NO,NO,NO,YES ID12220,64,FEMALE,RURAL,45765,YES,3,YES,YES,YES,NO,YES ID12221,46,MALE,RURAL,29525.5,NO,2,NO,YES,NO,YES,NO ID12222,62,FEMALE,RURAL,54863.8,YES,1,YES,YES,YES,NO,YES ID12223,36,FEMALE,TOWN,20799,YES,1,NO,YES,NO,YES,YES ID12224,35,FEMALE,RURAL,33028.3,NO,1,NO,YES,YES,NO,YES ID12225,47,MALE,RURAL,45031.9,NO,3,YES,YES,NO,NO,YES ID12226,47,MALE,INNER_CITY,39010.8,YES,2,NO,NO,YES,NO,YES ID12227,37,FEMALE,TOWN,25257.7,YES,0,YES,YES,YES,NO,NO ID12228,48,FEMALE,INNER_CITY,42603.9,YES,0,NO,YES,YES,NO,NO ID12229,41,MALE,TOWN,14092.7,YES,3,YES,YES,YES,NO,NO ID12230,27,FEMALE,RURAL,21350.3,NO,0,YES,YES,YES,NO,YES ID12231,43,MALE,INNER_CITY,23246.4,NO,2,NO,NO,YES,NO,NO ID12232,61,MALE,RURAL,41609.5,YES,3,NO,YES,YES,YES,NO ID12233,52,FEMALE,SUBURBAN,16716.1,NO,2,YES,YES,YES,NO,NO ID12234,64,FEMALE,SUBURBAN,36436.4,YES,0,YES,NO,YES,NO,NO ID12235,66,FEMALE,TOWN,59503.8,YES,2,YES,YES,YES,YES,YES ID12236,53,FEMALE,TOWN,31334.8,YES,1,YES,YES,YES,NO,YES ID12237,20,FEMALE,INNER_CITY,14048.9,YES,2,YES,NO,YES,YES,NO ID12238,57,FEMALE,INNER_CITY,39205.3,NO,0,NO,YES,YES,NO,YES ID12239,65,FEMALE,RURAL,42173.9,YES,0,NO,YES,YES,NO,NO ID12240,64,FEMALE,INNER_CITY,55263,NO,1,NO,YES,YES,NO,YES ID12241,52,MALE,INNER_CITY,37095.2,YES,3,NO,YES,YES,NO,NO ID12242,47,FEMALE,INNER_CITY,22791.4,YES,0,NO,NO,YES,NO,NO ID12243,28,FEMALE,TOWN,17240.6,YES,1,YES,NO,NO,YES,NO ID12244,64,MALE,TOWN,48974.8,YES,0,YES,YES,YES,YES,NO ID12245,25,MALE,INNER_CITY,18923,YES,1,NO,YES,YES,NO,YES ID12246,58,MALE,SUBURBAN,51204.2,YES,0,NO,YES,NO,YES,YES ID12247,34,MALE,TOWN,20236.2,YES,2,YES,NO,YES,NO,NO ID12248,20,FEMALE,INNER_CITY,18860.3,NO,2,NO,YES,YES,NO,NO ID12249,63,MALE,RURAL,25732.5,YES,0,YES,YES,NO,NO,NO ID12250,30,FEMALE,SUBURBAN,28240.4,YES,3,YES,YES,YES,NO,NO ID12251,53,MALE,RURAL,28193.6,YES,1,YES,YES,YES,NO,YES ID12252,43,MALE,TOWN,36432.8,NO,2,YES,NO,YES,NO,YES ID12253,63,MALE,TOWN,54618.8,YES,2,NO,YES,NO,YES,YES ID12254,33,MALE,INNER_CITY,24760.8,YES,1,NO,YES,YES,YES,YES ID12255,41,MALE,RURAL,23356.1,NO,2,YES,NO,NO,NO,NO ID12256,20,FEMALE,SUBURBAN,8143.75,YES,2,NO,YES,YES,NO,YES ID12257,50,MALE,TOWN,26462.5,YES,0,YES,YES,YES,NO,NO ID12258,24,MALE,RURAL,20467.3,YES,2,YES,YES,YES,NO,NO ID12259,60,FEMALE,TOWN,21506.2,YES,0,NO,NO,YES,NO,YES ID12260,44,FEMALE,TOWN,15315.3,YES,1,NO,YES,YES,NO,YES ID12261,23,MALE,INNER_CITY,18875.7,YES,2,YES,YES,YES,NO,NO ID12262,40,FEMALE,INNER_CITY,12977.2,YES,0,NO,NO,NO,NO,NO ID12263,49,FEMALE,TOWN,20708.5,NO,3,NO,NO,YES,NO,NO ID12264,21,FEMALE,TOWN,7549.38,NO,1,YES,NO,YES,NO,NO ID12265,40,FEMALE,INNER_CITY,24904,YES,0,NO,NO,NO,NO,NO ID12266,26,MALE,RURAL,24071.8,YES,1,NO,NO,YES,YES,YES ID12267,20,MALE,TOWN,9589.91,NO,1,NO,YES,YES,YES,NO ID12268,24,MALE,INNER_CITY,8562.86,NO,1,NO,NO,NO,YES,NO ID12269,37,FEMALE,TOWN,26707.5,NO,0,YES,YES,YES,NO,NO ID12270,56,MALE,INNER_CITY,34020.5,YES,0,NO,NO,YES,NO,NO ID12271,52,MALE,INNER_CITY,49175.7,YES,0,YES,YES,YES,NO,NO ID12272,22,MALE,INNER_CITY,19726.3,YES,2,NO,NO,YES,NO,NO ID12273,35,MALE,INNER_CITY,24346.6,YES,3,YES,YES,YES,NO,NO ID12274,34,MALE,RURAL,26999.4,YES,1,YES,YES,YES,NO,YES ID12275,67,FEMALE,TOWN,41558.1,YES,2,NO,YES,YES,NO,YES ID12276,58,FEMALE,INNER_CITY,56340.3,NO,0,NO,YES,YES,NO,YES ID12277,40,MALE,TOWN,37558.5,YES,0,YES,YES,YES,NO,NO ID12278,41,FEMALE,INNER_CITY,30099.3,YES,0,YES,YES,YES,YES,YES ID12279,43,MALE,INNER_CITY,15254.8,YES,0,NO,NO,NO,NO,YES ID12280,63,MALE,INNER_CITY,36086.1,YES,2,NO,NO,YES,NO,YES ID12281,22,FEMALE,INNER_CITY,17655,YES,1,NO,YES,YES,YES,YES ID12282,60,MALE,RURAL,56658.9,NO,0,NO,YES,YES,NO,YES ID12283,65,FEMALE,INNER_CITY,37706.5,NO,0,YES,YES,YES,YES,NO ID12284,48,FEMALE,INNER_CITY,18516,YES,2,YES,YES,YES,YES,NO ID12285,38,FEMALE,INNER_CITY,29622,NO,0,YES,YES,NO,YES,NO ID12286,49,MALE,RURAL,32669.9,YES,1,YES,YES,YES,YES,YES ID12287,20,FEMALE,INNER_CITY,18275.5,YES,0,NO,NO,NO,YES,YES ID12288,48,FEMALE,TOWN,34410,YES,1,NO,NO,YES,NO,YES ID12289,38,MALE,INNER_CITY,34866.9,YES,2,YES,NO,YES,YES,NO ID12290,41,FEMALE,INNER_CITY,21796.6,YES,0,NO,NO,YES,NO,NO ID12291,67,FEMALE,SUBURBAN,63130.1,YES,2,YES,YES,YES,NO,YES ID12292,39,MALE,INNER_CITY,14996.4,YES,1,YES,YES,NO,NO,NO ID12293,64,FEMALE,RURAL,49024.9,YES,3,NO,YES,YES,NO,YES ID12294,41,MALE,INNER_CITY,16249.8,YES,0,YES,NO,YES,YES,YES ID12295,55,MALE,SUBURBAN,36192.1,YES,2,YES,NO,YES,NO,YES ID12296,52,MALE,INNER_CITY,17839.9,YES,1,NO,YES,NO,YES,YES ID12297,30,FEMALE,INNER_CITY,18802.4,NO,0,NO,NO,YES,YES,YES ID12298,52,MALE,INNER_CITY,48720.3,YES,2,YES,YES,YES,NO,YES ID12299,26,MALE,INNER_CITY,14585.9,NO,2,NO,NO,YES,YES,NO ID12300,26,FEMALE,INNER_CITY,20819,YES,0,NO,YES,YES,NO,YES ID12301,46,MALE,TOWN,26077.8,YES,1,YES,YES,YES,NO,YES ID12302,46,FEMALE,TOWN,41627.1,YES,0,NO,YES,YES,YES,NO ID12303,52,MALE,INNER_CITY,16977.3,YES,0,NO,NO,YES,NO,NO ID12304,37,MALE,INNER_CITY,19012.8,NO,3,YES,NO,YES,NO,NO ID12305,22,MALE,INNER_CITY,12764.8,YES,1,NO,YES,YES,YES,YES ID12306,18,MALE,INNER_CITY,14388.6,NO,0,YES,NO,YES,YES,YES ID12307,63,MALE,INNER_CITY,59409.1,NO,0,YES,YES,YES,NO,YES ID12308,25,FEMALE,INNER_CITY,14960.2,YES,0,NO,YES,YES,YES,NO ID12309,67,MALE,INNER_CITY,39666.6,YES,0,YES,YES,YES,NO,NO ID12310,27,MALE,INNER_CITY,20771.9,NO,0,NO,YES,NO,NO,YES ID12311,61,MALE,INNER_CITY,24474.1,NO,0,YES,NO,NO,NO,YES ID12312,58,MALE,TOWN,33123.7,YES,1,YES,YES,YES,NO,YES ID12313,22,MALE,INNER_CITY,14433.4,YES,0,YES,YES,YES,NO,YES ID12314,28,MALE,TOWN,13175.5,NO,1,NO,NO,YES,NO,YES ID12315,23,MALE,INNER_CITY,9824.37,YES,0,NO,YES,YES,NO,NO ID12316,27,MALE,SUBURBAN,17610.3,YES,0,NO,YES,YES,NO,NO ID12317,27,FEMALE,SUBURBAN,15156.2,YES,0,YES,NO,YES,NO,NO ID12318,40,FEMALE,INNER_CITY,31774.1,YES,3,YES,YES,YES,YES,NO ID12319,39,MALE,TOWN,31693.5,NO,0,YES,YES,NO,NO,YES ID12320,35,FEMALE,INNER_CITY,28598.7,YES,0,YES,YES,YES,NO,NO ID12321,37,FEMALE,INNER_CITY,26261.7,NO,2,YES,NO,NO,NO,NO ID12322,47,MALE,INNER_CITY,42124.1,YES,2,NO,YES,YES,NO,YES ID12323,42,FEMALE,INNER_CITY,39308.7,YES,1,NO,YES,YES,NO,YES ID12324,67,FEMALE,INNER_CITY,43530,YES,0,NO,YES,YES,YES,NO ID12325,57,MALE,RURAL,49874.4,YES,3,NO,YES,YES,NO,YES ID12326,47,FEMALE,RURAL,27434.8,NO,0,YES,YES,YES,NO,YES ID12327,67,MALE,INNER_CITY,50474.6,YES,2,YES,YES,YES,NO,YES ID12328,56,MALE,TOWN,24888.2,NO,0,NO,YES,YES,NO,YES ID12329,37,MALE,RURAL,28021.6,NO,0,YES,NO,YES,YES,YES ID12330,27,MALE,INNER_CITY,12279.5,NO,0,YES,NO,NO,NO,YES ID12331,59,FEMALE,INNER_CITY,30189.4,YES,0,YES,NO,YES,YES,YES ID12332,31,MALE,INNER_CITY,28969.4,NO,1,NO,NO,YES,YES,NO ID12333,31,MALE,SUBURBAN,14058.5,YES,0,NO,NO,YES,YES,YES ID12334,32,FEMALE,TOWN,30404.3,YES,0,YES,YES,YES,NO,NO ID12335,57,FEMALE,RURAL,41438.2,NO,3,NO,YES,NO,NO,NO ID12336,49,FEMALE,INNER_CITY,16711.3,NO,1,NO,YES,YES,YES,YES ID12337,65,MALE,TOWN,52255.9,NO,2,YES,YES,YES,NO,YES ID12338,22,FEMALE,INNER_CITY,17866.9,YES,2,NO,YES,YES,YES,NO ID12339,26,FEMALE,RURAL,18067.5,YES,2,NO,YES,NO,NO,NO ID12340,23,MALE,INNER_CITY,12823.7,YES,0,YES,YES,YES,NO,NO ID12341,26,FEMALE,RURAL,11299.3,YES,2,YES,NO,NO,NO,NO ID12342,59,FEMALE,INNER_CITY,56031.1,NO,0,YES,YES,YES,NO,YES ID12343,67,MALE,INNER_CITY,35263.5,YES,1,YES,YES,YES,NO,YES ID12344,34,FEMALE,INNER_CITY,19968.1,YES,0,YES,YES,YES,NO,NO ID12345,50,MALE,RURAL,27825.5,YES,2,YES,YES,NO,NO,NO ID12346,46,MALE,SUBURBAN,37773.9,NO,0,YES,YES,YES,YES,NO ID12347,23,FEMALE,INNER_CITY,7606.25,NO,3,YES,NO,NO,NO,NO ID12348,26,MALE,RURAL,21384.4,YES,0,NO,NO,YES,NO,NO ID12349,40,MALE,TOWN,20347,YES,3,NO,YES,YES,NO,NO ID12350,36,MALE,TOWN,21332.3,YES,3,YES,NO,YES,NO,NO ID12351,65,MALE,INNER_CITY,57671.7,NO,0,NO,YES,YES,YES,NO ID12352,45,FEMALE,TOWN,36057.8,YES,1,YES,YES,YES,YES,YES ID12353,23,MALE,INNER_CITY,14290.5,YES,2,NO,NO,YES,YES,NO ID12354,42,FEMALE,TOWN,17882.9,YES,1,NO,NO,NO,NO,YES ID12355,21,FEMALE,RURAL,10629.1,NO,3,NO,YES,YES,YES,NO ID12356,62,FEMALE,INNER_CITY,24262.8,NO,0,YES,NO,YES,NO,YES ID12357,49,FEMALE,SUBURBAN,26097.9,NO,2,NO,YES,YES,NO,NO ID12358,28,FEMALE,TOWN,23371,YES,2,NO,NO,YES,YES,NO ID12359,38,FEMALE,TOWN,21495.6,NO,3,NO,NO,YES,YES,NO ID12360,36,MALE,TOWN,12166.9,NO,0,NO,NO,NO,NO,NO ID12361,22,MALE,SUBURBAN,17180.2,YES,0,NO,YES,YES,NO,NO ID12362,40,FEMALE,TOWN,28882.3,YES,1,NO,YES,YES,YES,YES ID12363,40,FEMALE,TOWN,21612.2,YES,0,NO,NO,YES,NO,NO ID12364,60,FEMALE,INNER_CITY,46358.4,YES,0,YES,YES,YES,YES,NO ID12365,23,MALE,INNER_CITY,19166,NO,0,YES,YES,NO,NO,YES ID12366,21,MALE,INNER_CITY,17921.8,YES,1,YES,NO,NO,NO,YES ID12367,58,MALE,TOWN,33229,NO,0,YES,YES,YES,NO,YES ID12368,48,FEMALE,SUBURBAN,30396.1,NO,0,NO,YES,YES,NO,YES ID12369,63,FEMALE,TOWN,34625.2,YES,0,YES,NO,YES,NO,NO ID12370,20,MALE,TOWN,16672.8,NO,3,YES,NO,YES,YES,NO ID12371,67,FEMALE,SUBURBAN,60747.5,NO,2,NO,YES,YES,YES,YES ID12372,62,FEMALE,INNER_CITY,56394.3,NO,0,YES,YES,YES,NO,YES ID12373,36,MALE,TOWN,13236.4,YES,0,NO,YES,YES,NO,NO ID12374,31,MALE,INNER_CITY,28409.4,YES,1,YES,NO,YES,NO,YES ID12375,42,FEMALE,INNER_CITY,27056.5,YES,0,YES,YES,YES,NO,NO ID12376,18,MALE,RURAL,9362.58,YES,0,YES,NO,YES,YES,YES ID12377,46,FEMALE,SUBURBAN,28702.7,NO,1,NO,YES,YES,YES,YES ID12378,25,MALE,TOWN,22366.1,YES,1,YES,YES,YES,NO,YES ID12379,65,FEMALE,RURAL,24477.5,NO,0,NO,YES,NO,YES,NO ID12380,40,MALE,TOWN,36972.4,YES,1,NO,NO,YES,YES,YES ID12381,32,MALE,INNER_CITY,22327.8,YES,1,NO,NO,NO,NO,YES ID12382,18,FEMALE,INNER_CITY,15610.2,YES,0,NO,YES,YES,NO,NO ID12383,64,MALE,INNER_CITY,54314.5,YES,1,YES,YES,NO,NO,YES ID12384,43,FEMALE,INNER_CITY,39175.8,YES,3,NO,YES,YES,YES,NO ID12385,22,FEMALE,INNER_CITY,13739,YES,3,NO,YES,YES,NO,NO ID12386,25,MALE,TOWN,9485.84,YES,0,NO,NO,NO,NO,NO ID12387,39,MALE,INNER_CITY,24675.7,YES,1,YES,YES,YES,YES,YES ID12388,58,FEMALE,INNER_CITY,28253.6,YES,3,NO,NO,YES,NO,NO ID12389,33,MALE,INNER_CITY,14136.5,YES,1,NO,YES,NO,NO,NO ID12390,52,FEMALE,RURAL,37162.1,YES,1,YES,YES,YES,NO,YES ID12391,23,MALE,INNER_CITY,13519.2,NO,0,NO,YES,YES,NO,YES ID12392,44,FEMALE,INNER_CITY,39253.6,NO,0,YES,YES,NO,NO,YES ID12393,51,MALE,RURAL,46323.8,YES,2,YES,YES,YES,YES,YES ID12394,26,FEMALE,TOWN,20950.7,YES,0,NO,YES,YES,NO,NO ID12395,42,MALE,TOWN,22495.7,YES,0,NO,YES,NO,YES,NO ID12396,34,MALE,TOWN,32548.9,YES,0,YES,YES,YES,YES,NO ID12397,54,FEMALE,RURAL,24583.4,NO,2,YES,YES,YES,YES,NO ID12398,18,MALE,RURAL,8639.24,YES,2,NO,NO,NO,NO,NO ID12399,47,FEMALE,INNER_CITY,17139.5,NO,2,YES,NO,YES,NO,NO ID12400,24,FEMALE,INNER_CITY,13667.7,YES,0,NO,YES,YES,NO,NO ID12401,19,FEMALE,INNER_CITY,8162.42,YES,1,YES,YES,YES,YES,NO ID12402,37,FEMALE,TOWN,15349.6,YES,0,NO,YES,NO,NO,NO ID12403,45,FEMALE,TOWN,29231.4,YES,0,NO,YES,NO,NO,NO ID12404,49,MALE,RURAL,41462.3,YES,3,NO,YES,YES,YES,NO ID12405,67,FEMALE,RURAL,57398.1,NO,3,NO,YES,YES,NO,YES ID12406,35,FEMALE,RURAL,11520.8,YES,0,NO,NO,YES,NO,NO ID12407,63,MALE,INNER_CITY,52117.3,NO,2,YES,YES,YES,NO,YES ID12408,38,MALE,RURAL,26281.4,NO,0,YES,YES,YES,NO,YES ID12409,48,MALE,TOWN,25683.4,NO,2,YES,YES,YES,NO,NO ID12410,28,FEMALE,INNER_CITY,11920.7,NO,1,NO,YES,YES,NO,NO ID12411,46,MALE,TOWN,30658.7,YES,0,NO,YES,YES,NO,NO ID12412,66,MALE,INNER_CITY,36646.4,NO,1,NO,YES,YES,NO,YES ID12413,61,FEMALE,TOWN,30760.4,NO,2,YES,NO,YES,NO,YES ID12414,18,FEMALE,RURAL,16109.9,NO,2,YES,YES,YES,NO,NO ID12415,54,FEMALE,TOWN,18036.7,YES,0,YES,YES,NO,NO,NO ID12416,45,MALE,RURAL,42628.3,NO,0,YES,YES,YES,YES,NO ID12417,60,MALE,INNER_CITY,22110.1,NO,2,YES,YES,YES,NO,NO ID12418,45,FEMALE,TOWN,37689.1,NO,1,NO,YES,YES,YES,YES ID12419,31,FEMALE,INNER_CITY,23171.8,NO,2,NO,YES,NO,NO,NO ID12420,39,MALE,SUBURBAN,21951.3,NO,0,YES,YES,YES,YES,NO ID12421,53,MALE,INNER_CITY,38103.4,NO,2,YES,YES,YES,NO,YES ID12422,35,MALE,RURAL,22882.9,YES,0,YES,NO,NO,YES,YES ID12423,25,FEMALE,TOWN,11043.7,YES,1,YES,YES,NO,YES,NO ID12424,32,MALE,TOWN,24027.6,NO,0,NO,YES,YES,NO,YES ID12425,36,MALE,SUBURBAN,28495.1,YES,0,NO,YES,YES,NO,NO ID12426,24,FEMALE,TOWN,9465.21,NO,0,NO,NO,YES,NO,YES ID12427,39,MALE,INNER_CITY,34852.3,YES,1,NO,YES,NO,YES,YES ID12428,24,MALE,INNER_CITY,21268.4,YES,0,NO,NO,YES,YES,YES ID12429,57,FEMALE,RURAL,50849.2,NO,1,NO,YES,NO,YES,YES ID12430,27,FEMALE,TOWN,18555.9,YES,3,NO,NO,YES,NO,NO ID12431,66,FEMALE,RURAL,52769.9,YES,3,YES,YES,YES,NO,YES ID12432,18,FEMALE,INNER_CITY,11601.4,YES,2,NO,YES,YES,YES,NO ID12433,33,FEMALE,TOWN,29541.7,YES,0,NO,YES,NO,NO,NO ID12434,48,MALE,SUBURBAN,17861,YES,2,NO,YES,YES,NO,NO ID12435,23,FEMALE,SUBURBAN,21042,YES,1,NO,NO,YES,NO,YES ID12436,44,MALE,TOWN,26688.1,YES,1,NO,YES,NO,YES,YES ID12437,39,MALE,INNER_CITY,26900.6,YES,2,NO,NO,NO,YES,NO ID12438,65,MALE,INNER_CITY,38080.9,YES,1,YES,YES,NO,YES,NO ID12439,60,MALE,SUBURBAN,37554.1,YES,2,YES,YES,YES,YES,YES ID12440,20,MALE,INNER_CITY,18184.6,YES,0,NO,NO,YES,YES,YES ID12441,45,FEMALE,SUBURBAN,28864.9,YES,0,NO,YES,YES,NO,NO ID12442,66,MALE,RURAL,48346.1,YES,1,YES,YES,NO,NO,YES ID12443,64,MALE,INNER_CITY,53104.3,YES,0,YES,YES,YES,NO,NO ID12444,51,FEMALE,INNER_CITY,19416.8,YES,0,NO,YES,YES,NO,NO ID12445,34,MALE,RURAL,23638.1,YES,2,YES,YES,YES,NO,NO ID12446,65,FEMALE,TOWN,42378.2,YES,1,NO,YES,YES,NO,YES ID12447,50,MALE,RURAL,39745.3,YES,0,YES,YES,NO,YES,NO ID12448,66,FEMALE,INNER_CITY,45189.8,YES,0,NO,YES,NO,NO,NO ID12449,63,MALE,INNER_CITY,37930.9,YES,0,NO,YES,NO,YES,NO ID12450,53,FEMALE,INNER_CITY,24042,NO,1,NO,NO,YES,NO,YES ID12451,33,FEMALE,INNER_CITY,31207.1,NO,0,YES,NO,YES,YES,YES ID12452,38,MALE,TOWN,24424.3,YES,0,NO,YES,YES,YES,NO ID12453,56,FEMALE,RURAL,24607.8,NO,1,NO,YES,YES,YES,NO ID12454,48,MALE,TOWN,43057,NO,1,YES,YES,YES,NO,YES ID12455,49,FEMALE,SUBURBAN,30198.5,YES,0,YES,NO,YES,YES,YES ID12456,54,FEMALE,RURAL,50186.1,YES,2,NO,YES,YES,YES,YES ID12457,41,FEMALE,SUBURBAN,22916.1,YES,0,NO,NO,YES,NO,NO ID12458,19,MALE,RURAL,9592.73,NO,0,NO,YES,YES,NO,YES ID12459,52,FEMALE,INNER_CITY,34253.6,NO,3,YES,NO,YES,NO,NO ID12460,52,FEMALE,INNER_CITY,22792.3,YES,1,YES,YES,NO,NO,YES ID12461,64,FEMALE,TOWN,51620.8,NO,2,YES,YES,YES,NO,YES ID12462,56,MALE,TOWN,19918.9,YES,3,NO,YES,YES,YES,NO ID12463,56,MALE,TOWN,29625.1,YES,2,NO,NO,YES,NO,NO ID12464,19,FEMALE,TOWN,12549,YES,0,NO,YES,YES,NO,NO ID12465,56,FEMALE,TOWN,51299.3,YES,1,YES,YES,NO,NO,YES ID12466,27,MALE,INNER_CITY,17364.8,YES,2,YES,YES,NO,NO,YES ID12467,59,FEMALE,INNER_CITY,29866.9,NO,1,YES,NO,YES,NO,YES ID12468,56,MALE,INNER_CITY,47750.2,YES,0,YES,YES,YES,YES,NO ID12469,21,MALE,TOWN,11281.5,YES,0,NO,YES,YES,YES,NO ID12470,64,MALE,INNER_CITY,34073.8,YES,3,NO,YES,NO,YES,NO ID12471,62,MALE,INNER_CITY,46870.4,YES,0,NO,YES,YES,NO,NO ID12472,44,FEMALE,INNER_CITY,38453.7,NO,2,NO,YES,YES,NO,YES ID12473,24,FEMALE,INNER_CITY,7756.36,NO,0,NO,NO,NO,NO,YES ID12474,52,FEMALE,INNER_CITY,28413.8,YES,0,NO,NO,YES,NO,NO ID12475,67,FEMALE,SUBURBAN,47198.6,YES,2,NO,YES,YES,NO,YES ID12476,41,MALE,INNER_CITY,20866.3,YES,0,YES,YES,YES,NO,NO ID12477,58,FEMALE,TOWN,33204.3,NO,1,NO,NO,NO,YES,YES ID12478,40,MALE,INNER_CITY,24823.5,NO,2,NO,NO,YES,NO,NO ID12479,19,MALE,SUBURBAN,17986.8,YES,0,NO,NO,YES,YES,YES ID12480,20,FEMALE,INNER_CITY,9909.82,YES,3,NO,NO,YES,NO,NO ID12481,56,FEMALE,TOWN,26542.8,NO,0,YES,YES,YES,NO,YES ID12482,46,FEMALE,INNER_CITY,32583.5,YES,2,YES,YES,YES,NO,NO ID12483,30,MALE,INNER_CITY,14606.6,YES,1,NO,NO,YES,NO,NO ID12484,40,FEMALE,TOWN,34836.8,YES,1,YES,YES,YES,NO,YES ID12485,36,FEMALE,TOWN,26920.8,YES,0,NO,NO,YES,NO,NO ID12486,57,FEMALE,INNER_CITY,38248.3,NO,3,YES,NO,YES,YES,NO ID12487,49,MALE,INNER_CITY,15689.1,NO,0,NO,NO,YES,NO,NO ID12488,61,MALE,INNER_CITY,30157.7,NO,1,YES,NO,NO,NO,YES ID12489,29,MALE,INNER_CITY,14642.2,NO,0,YES,NO,YES,NO,YES ID12490,48,FEMALE,INNER_CITY,15933.3,YES,0,NO,YES,NO,NO,NO ID12491,56,FEMALE,INNER_CITY,44288.3,YES,0,NO,YES,YES,NO,NO ID12492,40,MALE,TOWN,22197.1,NO,0,YES,NO,YES,NO,YES ID12493,58,FEMALE,TOWN,38248.3,YES,3,YES,YES,NO,NO,NO ID12494,60,FEMALE,INNER_CITY,22053.2,YES,2,YES,YES,NO,YES,NO ID12495,58,FEMALE,SUBURBAN,25468.5,NO,0,YES,NO,NO,YES,YES ID12496,67,FEMALE,TOWN,23485.9,YES,3,YES,NO,NO,YES,NO ID12497,40,MALE,RURAL,25768.6,YES,0,YES,YES,NO,NO,NO ID12498,48,MALE,INNER_CITY,34182.2,YES,2,NO,YES,YES,NO,YES ID12499,64,FEMALE,INNER_CITY,57444.5,NO,1,NO,YES,YES,NO,YES ID12500,43,MALE,TOWN,38059.8,YES,0,YES,YES,NO,YES,NO ID12501,34,FEMALE,RURAL,19481.3,NO,0,NO,NO,YES,YES,YES ID12502,26,MALE,RURAL,19563.8,NO,3,YES,NO,NO,YES,NO ID12503,48,MALE,INNER_CITY,38598.4,YES,0,YES,NO,YES,NO,NO ID12504,35,MALE,INNER_CITY,20754.3,NO,0,NO,NO,NO,YES,YES ID12505,24,FEMALE,INNER_CITY,13864.6,YES,3,NO,YES,YES,NO,YES ID12506,47,MALE,SUBURBAN,36599,YES,3,YES,YES,YES,NO,YES ID12507,52,MALE,SUBURBAN,45856.1,NO,1,NO,YES,YES,NO,YES ID12508,31,MALE,SUBURBAN,22362.3,NO,0,NO,YES,YES,NO,YES ID12509,41,FEMALE,SUBURBAN,21984,YES,1,YES,NO,NO,NO,YES ID12510,23,MALE,SUBURBAN,11073,YES,2,NO,YES,NO,NO,NO ID12511,27,FEMALE,INNER_CITY,18158.5,NO,1,YES,NO,YES,YES,YES ID12512,22,MALE,INNER_CITY,7304.2,NO,0,YES,YES,YES,YES,NO ID12513,67,FEMALE,INNER_CITY,58092,NO,2,YES,YES,YES,NO,YES ID12514,26,FEMALE,INNER_CITY,16518.6,YES,0,YES,NO,YES,NO,YES ID12515,58,FEMALE,SUBURBAN,46461.5,YES,0,NO,YES,YES,NO,NO ID12516,27,MALE,RURAL,20058.7,YES,0,NO,YES,YES,YES,NO ID12517,36,MALE,INNER_CITY,12533.2,NO,1,NO,YES,NO,YES,NO ID12518,31,MALE,RURAL,22848.5,YES,1,YES,NO,NO,NO,YES ID12519,28,FEMALE,TOWN,25699.4,YES,2,YES,YES,NO,NO,YES ID12520,57,MALE,TOWN,21612.6,YES,0,NO,YES,YES,YES,NO ID12521,64,MALE,INNER_CITY,48950.9,YES,0,YES,YES,YES,YES,NO ID12522,49,MALE,INNER_CITY,41438,NO,1,NO,YES,NO,NO,YES ID12523,22,MALE,INNER_CITY,11411,YES,1,YES,NO,YES,NO,NO ID12524,58,FEMALE,INNER_CITY,43940.6,YES,0,YES,YES,YES,NO,NO ID12525,20,MALE,TOWN,17239.5,NO,1,YES,NO,YES,NO,YES ID12526,44,FEMALE,RURAL,30488.7,YES,0,NO,YES,YES,NO,NO ID12527,65,FEMALE,TOWN,29866.3,YES,3,NO,YES,NO,NO,NO ID12528,53,FEMALE,INNER_CITY,32184.4,YES,2,YES,NO,NO,NO,YES ID12529,34,FEMALE,INNER_CITY,17308.7,YES,1,YES,NO,YES,YES,YES ID12530,35,MALE,RURAL,27863.9,NO,2,NO,YES,YES,YES,NO ID12531,48,MALE,TOWN,28920.6,YES,0,NO,YES,NO,YES,NO ID12532,64,FEMALE,TOWN,58367.3,YES,1,YES,YES,YES,NO,YES ID12533,46,MALE,TOWN,16849.3,NO,0,YES,YES,YES,YES,NO ID12534,42,FEMALE,RURAL,28138.5,YES,0,NO,NO,YES,YES,YES ID12535,47,MALE,INNER_CITY,23038.2,YES,0,YES,YES,NO,NO,NO ID12536,23,MALE,TOWN,11736.9,NO,2,YES,YES,YES,YES,NO ID12537,35,MALE,INNER_CITY,16479.5,YES,0,YES,NO,NO,YES,YES ID12538,64,FEMALE,INNER_CITY,31415.7,NO,1,YES,YES,NO,YES,YES ID12539,18,FEMALE,SUBURBAN,12117.3,YES,1,NO,NO,YES,NO,NO ID12540,19,MALE,INNER_CITY,15417.1,YES,1,YES,NO,YES,NO,NO ID12541,40,MALE,INNER_CITY,29414.6,YES,1,NO,YES,NO,YES,YES ID12542,47,MALE,INNER_CITY,44682.1,YES,0,YES,YES,YES,NO,NO ID12543,43,FEMALE,RURAL,36281,YES,0,YES,YES,YES,NO,NO ID12544,38,MALE,TOWN,33302.8,NO,0,YES,NO,YES,YES,YES ID12545,21,FEMALE,RURAL,15797.1,YES,0,NO,YES,YES,NO,YES ID12546,40,MALE,RURAL,31864.8,YES,0,YES,YES,YES,NO,NO ID12547,52,FEMALE,TOWN,43719.5,YES,0,NO,YES,YES,NO,NO ID12548,35,FEMALE,TOWN,30799.5,YES,2,NO,NO,YES,NO,YES ID12549,53,MALE,RURAL,48971.6,YES,3,YES,YES,NO,NO,YES ID12550,38,FEMALE,RURAL,34061.4,NO,0,YES,YES,YES,NO,YES ID12551,42,MALE,INNER_CITY,28938.6,YES,3,YES,NO,NO,NO,NO ID12552,43,MALE,TOWN,38540,NO,0,YES,YES,NO,YES,NO ID12553,59,FEMALE,INNER_CITY,27045.1,NO,0,NO,NO,YES,NO,YES ID12554,59,FEMALE,RURAL,51284.3,NO,0,YES,YES,YES,YES,NO ID12555,24,MALE,INNER_CITY,16352.2,NO,0,NO,YES,YES,YES,NO ID12556,27,FEMALE,INNER_CITY,11866.4,YES,0,YES,YES,YES,NO,NO ID12557,32,FEMALE,TOWN,13267.6,YES,0,YES,YES,YES,YES,NO ID12558,65,FEMALE,INNER_CITY,61554.6,YES,0,NO,YES,YES,NO,NO ID12559,18,MALE,SUBURBAN,13700.2,NO,1,NO,YES,YES,NO,NO ID12560,66,MALE,TOWN,46963.9,YES,1,NO,YES,YES,NO,YES ID12561,41,MALE,INNER_CITY,23475.6,YES,0,YES,NO,YES,YES,YES ID12562,64,FEMALE,SUBURBAN,24554.1,YES,0,YES,YES,NO,YES,NO ID12563,23,FEMALE,INNER_CITY,18050,YES,0,YES,NO,YES,YES,YES ID12564,29,FEMALE,RURAL,15237.6,YES,2,YES,NO,YES,NO,NO ID12565,28,MALE,TOWN,20555,NO,0,YES,YES,YES,NO,YES ID12566,57,FEMALE,TOWN,28421.7,YES,2,YES,YES,YES,YES,NO ID12567,38,MALE,INNER_CITY,21876.5,YES,0,NO,NO,YES,NO,NO ID12568,34,FEMALE,SUBURBAN,12810.2,NO,3,NO,YES,YES,NO,YES ID12569,43,MALE,SUBURBAN,15109.4,YES,0,NO,NO,YES,NO,YES ID12570,63,MALE,TOWN,37414.7,NO,3,YES,YES,YES,NO,NO ID12571,62,FEMALE,INNER_CITY,41521.6,YES,0,NO,YES,YES,YES,NO ID12572,51,FEMALE,INNER_CITY,25372.8,YES,0,YES,YES,YES,NO,NO ID12573,61,MALE,INNER_CITY,21139.8,YES,2,YES,YES,NO,NO,NO ID12574,41,FEMALE,TOWN,27757.6,NO,0,NO,YES,YES,NO,YES ID12575,31,FEMALE,TOWN,22678.1,NO,1,YES,YES,YES,YES,YES ID12576,33,FEMALE,TOWN,12178.5,YES,2,NO,YES,YES,YES,NO ID12577,43,MALE,RURAL,26106.7,NO,1,NO,NO,YES,NO,YES ID12578,40,MALE,INNER_CITY,27417.6,YES,0,NO,YES,YES,YES,NO ID12579,47,MALE,TOWN,23337.2,YES,2,NO,YES,YES,YES,NO ID12580,46,MALE,TOWN,43395.5,NO,1,YES,YES,YES,NO,YES ID12581,30,MALE,RURAL,11536.2,YES,2,NO,NO,YES,YES,NO ID12582,47,MALE,INNER_CITY,44658.6,NO,2,YES,YES,YES,NO,YES ID12583,44,MALE,RURAL,32762.5,NO,0,NO,YES,YES,YES,NO ID12584,23,MALE,RURAL,16403.8,YES,0,YES,YES,NO,NO,NO ID12585,28,FEMALE,INNER_CITY,21184.7,YES,1,YES,YES,YES,NO,YES ID12586,64,FEMALE,INNER_CITY,49917.3,YES,0,YES,YES,YES,YES,NO ID12587,35,FEMALE,TOWN,21623.8,YES,0,NO,YES,NO,YES,NO ID12588,19,MALE,RURAL,16625.9,YES,1,NO,NO,YES,NO,YES ID12589,27,FEMALE,TOWN,14014.5,YES,3,NO,YES,NO,NO,NO ID12590,27,MALE,INNER_CITY,20409.3,YES,2,NO,YES,NO,NO,YES ID12591,58,FEMALE,INNER_CITY,31671.3,YES,1,YES,YES,NO,YES,YES ID12592,46,FEMALE,TOWN,17149.2,NO,1,YES,YES,YES,NO,YES ID12593,61,FEMALE,TOWN,27756.3,YES,0,YES,YES,NO,YES,YES ID12594,59,MALE,INNER_CITY,40949.9,NO,0,NO,YES,YES,NO,YES ID12595,47,FEMALE,RURAL,43743.2,YES,3,NO,YES,YES,NO,NO ID12596,44,MALE,INNER_CITY,38459.9,YES,0,NO,NO,NO,YES,YES ID12597,50,MALE,TOWN,40972.9,NO,2,YES,YES,YES,YES,YES ID12598,64,MALE,INNER_CITY,46587.9,NO,0,NO,YES,YES,NO,YES ID12599,51,FEMALE,TOWN,43799.6,NO,0,NO,YES,YES,YES,NO ID12600,46,FEMALE,TOWN,18912.2,YES,0,YES,NO,YES,NO,YES ID12601,39,FEMALE,INNER_CITY,27765.8,YES,3,YES,YES,NO,NO,NO ID12602,58,FEMALE,INNER_CITY,33007.3,NO,1,YES,NO,YES,NO,YES ID12603,32,FEMALE,TOWN,26325.3,YES,0,YES,NO,NO,NO,NO ID12604,22,FEMALE,INNER_CITY,15308.2,NO,0,YES,YES,YES,YES,NO ID12605,63,FEMALE,INNER_CITY,59805.6,YES,1,YES,YES,YES,NO,YES ID12606,35,FEMALE,TOWN,28658.3,YES,0,YES,YES,YES,NO,NO ID12607,59,FEMALE,INNER_CITY,23175,YES,0,NO,NO,NO,YES,YES ID12608,22,FEMALE,SUBURBAN,11595.4,NO,0,YES,YES,YES,NO,YES ID12609,60,MALE,SUBURBAN,50409.9,NO,2,NO,YES,YES,YES,YES ID12610,23,FEMALE,RURAL,11215.3,YES,2,YES,YES,YES,NO,YES ID12611,29,FEMALE,TOWN,13327.8,YES,0,NO,YES,NO,NO,NO ID12612,44,MALE,INNER_CITY,16088.8,YES,3,NO,YES,YES,NO,NO ID12613,63,FEMALE,TOWN,43943,YES,0,YES,YES,YES,YES,NO ID12614,25,FEMALE,RURAL,14505.3,NO,3,NO,YES,YES,NO,NO ID12615,37,MALE,INNER_CITY,33886.4,NO,0,YES,YES,NO,NO,YES ID12616,48,FEMALE,INNER_CITY,16662.5,YES,1,NO,YES,YES,NO,YES ID12617,35,FEMALE,TOWN,20262.6,NO,0,NO,YES,NO,NO,YES ID12618,51,MALE,TOWN,33615.4,YES,1,NO,YES,NO,YES,YES ID12619,27,FEMALE,TOWN,22007.1,NO,3,NO,NO,YES,NO,NO ID12620,56,FEMALE,INNER_CITY,28981.1,YES,3,YES,YES,YES,YES,NO ID12621,38,FEMALE,INNER_CITY,12163.9,YES,2,YES,NO,YES,NO,YES ID12622,36,FEMALE,TOWN,17247.7,YES,2,YES,YES,YES,NO,NO ID12623,27,MALE,SUBURBAN,12683.6,NO,3,NO,YES,YES,YES,NO ID12624,34,FEMALE,TOWN,16291,YES,0,YES,YES,NO,YES,NO ID12625,44,MALE,SUBURBAN,18707.3,YES,0,YES,YES,YES,YES,YES ID12626,43,FEMALE,INNER_CITY,19326.9,YES,1,NO,NO,YES,NO,YES ID12627,32,MALE,INNER_CITY,14511.8,NO,2,NO,YES,NO,YES,NO ID12628,21,FEMALE,TOWN,10672,NO,1,NO,YES,YES,YES,NO ID12629,30,FEMALE,INNER_CITY,25830.5,YES,2,NO,NO,YES,NO,NO ID12630,55,MALE,RURAL,43499.5,YES,1,YES,YES,YES,NO,NO ID12631,64,MALE,SUBURBAN,59175.1,YES,1,NO,YES,YES,NO,YES ID12632,36,FEMALE,INNER_CITY,27642.9,NO,1,YES,NO,NO,NO,YES ID12633,59,MALE,INNER_CITY,30067.5,NO,1,NO,YES,YES,NO,YES ID12634,60,MALE,INNER_CITY,29714.4,YES,0,YES,NO,YES,YES,YES ID12635,27,FEMALE,TOWN,13950.4,NO,1,YES,YES,YES,YES,NO ID12636,29,MALE,INNER_CITY,10072.6,YES,0,NO,NO,YES,NO,NO ID12637,53,FEMALE,INNER_CITY,37850.6,NO,1,NO,YES,YES,NO,YES ID12638,61,FEMALE,RURAL,57176.4,NO,2,NO,YES,YES,NO,YES ID12639,43,FEMALE,INNER_CITY,38784,YES,0,NO,YES,YES,NO,NO ID12640,19,MALE,INNER_CITY,10191.8,YES,0,NO,YES,YES,YES,YES ID12641,48,FEMALE,INNER_CITY,21821.4,YES,1,YES,YES,NO,YES,YES ID12642,39,MALE,RURAL,37389,YES,2,NO,YES,YES,NO,YES ID12643,32,MALE,INNER_CITY,14627.9,YES,2,YES,YES,YES,NO,NO ID12644,63,MALE,SUBURBAN,48770.5,YES,1,YES,YES,NO,YES,YES ID12645,46,MALE,RURAL,21096.2,YES,1,YES,YES,YES,NO,YES ID12646,40,MALE,INNER_CITY,36256.9,NO,0,NO,NO,YES,YES,YES ID12647,27,FEMALE,INNER_CITY,15281.8,NO,0,YES,NO,NO,YES,YES ID12648,22,MALE,SUBURBAN,9316.98,YES,2,YES,YES,YES,NO,NO ID12649,42,MALE,RURAL,20736.2,YES,1,YES,YES,YES,NO,YES ID12650,58,FEMALE,TOWN,52662.5,YES,1,YES,YES,YES,YES,YES ID12651,23,FEMALE,INNER_CITY,8020.19,YES,1,YES,NO,YES,NO,NO ID12652,58,MALE,SUBURBAN,32245.4,YES,3,NO,NO,NO,NO,NO ID12653,45,MALE,INNER_CITY,41107.2,YES,2,YES,YES,YES,NO,NO ID12654,49,FEMALE,SUBURBAN,39358.3,YES,0,YES,NO,NO,YES,NO ID12655,67,FEMALE,INNER_CITY,36095.9,YES,3,YES,YES,YES,NO,NO ID12656,20,FEMALE,TOWN,7723.93,YES,2,YES,YES,YES,NO,NO ID12657,43,FEMALE,RURAL,18565.8,YES,1,YES,YES,YES,YES,YES ID12658,41,MALE,RURAL,25132.9,YES,0,NO,NO,YES,NO,NO ID12659,38,FEMALE,SUBURBAN,31290.6,YES,0,NO,YES,YES,NO,NO ID12660,67,FEMALE,SUBURBAN,24858.4,YES,0,NO,NO,YES,YES,YES ID12661,40,MALE,INNER_CITY,16398.8,NO,1,NO,YES,YES,NO,YES ID12662,25,FEMALE,SUBURBAN,23287.9,NO,0,NO,NO,YES,YES,YES ID12663,57,FEMALE,RURAL,50897.6,YES,0,NO,YES,YES,NO,NO ID12664,32,FEMALE,INNER_CITY,22446.5,NO,1,NO,NO,YES,YES,YES ID12665,44,MALE,SUBURBAN,23092.1,YES,0,YES,NO,YES,YES,YES ID12666,30,MALE,TOWN,24867.6,YES,0,YES,YES,NO,NO,NO ID12667,43,MALE,TOWN,22234.7,YES,0,NO,NO,YES,YES,NO ID12668,19,FEMALE,INNER_CITY,17371.1,YES,2,YES,YES,YES,NO,NO ID12669,37,FEMALE,TOWN,29574,YES,0,YES,YES,YES,NO,NO ID12670,49,MALE,INNER_CITY,17944.2,NO,1,YES,YES,YES,YES,YES ID12671,49,FEMALE,RURAL,33665.5,NO,3,YES,NO,YES,NO,NO ID12672,40,MALE,INNER_CITY,36166.2,YES,0,NO,NO,NO,NO,NO ID12673,33,FEMALE,SUBURBAN,27712.9,NO,2,NO,YES,YES,NO,YES ID12674,39,MALE,TOWN,22400.7,YES,2,YES,YES,YES,NO,NO ID12675,43,FEMALE,INNER_CITY,28469.9,YES,0,YES,YES,YES,NO,NO ID12676,37,MALE,TOWN,30488,YES,0,NO,YES,YES,YES,NO ID12677,24,FEMALE,TOWN,19160.3,YES,1,YES,YES,YES,NO,YES ID12678,62,MALE,TOWN,45342.5,YES,0,YES,YES,NO,NO,YES ID12679,18,MALE,INNER_CITY,6294.21,NO,0,NO,YES,YES,YES,NO ID12680,47,FEMALE,TOWN,25127.7,YES,0,YES,NO,NO,NO,NO ID12681,63,MALE,SUBURBAN,51879.3,YES,2,YES,YES,NO,YES,YES ID12682,20,MALE,TOWN,12644.9,YES,2,YES,NO,YES,YES,NO ID12683,46,FEMALE,TOWN,21984.4,NO,3,NO,YES,NO,NO,NO ID12684,47,FEMALE,RURAL,29093.1,NO,2,YES,YES,YES,NO,NO ID12685,33,MALE,TOWN,23528.4,YES,1,NO,YES,YES,YES,YES ID12686,20,MALE,TOWN,9516.91,NO,3,YES,YES,YES,NO,NO ID12687,20,MALE,INNER_CITY,18364.9,YES,1,NO,NO,YES,NO,YES ID12688,43,FEMALE,TOWN,31273.8,NO,1,YES,YES,NO,NO,YES ID12689,58,MALE,RURAL,49673.6,YES,0,NO,YES,YES,NO,NO ID12690,29,MALE,SUBURBAN,12623.4,YES,1,YES,YES,YES,NO,NO ID12691,25,MALE,INNER_CITY,23818.6,YES,0,NO,NO,NO,NO,NO ID12692,40,FEMALE,INNER_CITY,31473.9,NO,2,NO,YES,YES,YES,YES ID12693,48,MALE,TOWN,20268,YES,0,NO,YES,YES,NO,NO ID12694,65,MALE,SUBURBAN,51417,YES,2,NO,YES,YES,NO,YES ID12695,59,FEMALE,RURAL,30971.8,YES,3,YES,YES,YES,YES,NO ID12696,61,FEMALE,INNER_CITY,47025,NO,2,YES,YES,YES,YES,NO ID12697,30,FEMALE,INNER_CITY,9672.25,YES,0,YES,YES,YES,NO,NO ID12698,31,FEMALE,TOWN,15976.3,YES,0,YES,YES,NO,NO,YES ID12699,29,MALE,INNER_CITY,14711.8,YES,0,NO,YES,NO,YES,NO ID12700,38,MALE,TOWN,26671.6,NO,0,YES,NO,YES,YES,YES