USER http://dig.csail.mit.edu/2009/IARPA-PIR/test/bob.n3
SELECT BANKACCOUNT,BIRTHSTATE,HEIGHT FROM people WHERE FIRSTNAME = 'Nathaniel';
EXECUTE
SELECT MIDDLENAME,SUFFIX,BIRTHSTATE FROM people WHERE INTERESTS = 'Sacramento Kings |Minnesota Wild ';
EXECUTE
SELECT WORKPHONE,CITIZENSHIP,SECURITYANSWER FROM people WHERE INTERESTS = 'Dallas Stars |Minnesota Wild ';
EXECUTE
SELECT WORKEMAIL FROM people WHERE CERTIFICATION = '03/09/2002';
EXECUTE
SELECT HAIRCOLOR,GENDER,COUNTRY FROM people WHERE CERTIFICATION = '02/09/2006';
EXECUTE
SELECT EDUCATION FROM people WHERE FIRSTNAME = 'Rhonda';
EXECUTE
SELECT HEIGHT,INTERESTS,PASSWORD FROM people WHERE CERTIFICATION = '07/03/2000';
EXECUTE
SELECT PASSWORDHASH,DOB FROM people WHERE FIRSTNAME = 'Phillip';
EXECUTE
SELECT PUBLICKEYHASH FROM people WHERE INTERESTS = 'Portland Trail Blazers |Minnesota Twins ';
EXECUTE
SELECT ZIPCODE,CERTIFICATION,CITIZENSHIP FROM people WHERE INTERESTS = 'Portland Trail Blazers |St Louis Rams ';
EXECUTE
SELECT PASSWORDHASH,DOB,ADDRESS FROM people WHERE FIRSTNAME = 'Sherri';
EXECUTE
SELECT INTERESTS FROM people WHERE LASTNAME = 'Mendez';
EXECUTE
SELECT MARITALSTATUS,USERNAME FROM people WHERE CERTIFICATION = '01/16/2002';
EXECUTE
SELECT BANKACCOUNT,DOB FROM people WHERE MIDDLENAME = 'Orlando';
EXECUTE
SELECT ZIPCODE,HOMEPHONE,PASSWORD FROM people WHERE INTERESTS = 'Seattle Mariners |Indianapolis Colts ';
EXECUTE
SELECT DOB,PUBLICKEYHASH,LASTNAME FROM people WHERE FIRSTNAME = 'April';
EXECUTE
SELECT WORKPHONE FROM people WHERE LASTNAME = 'Rhodes';
EXECUTE
SELECT SSN,BIRTHCOUNTRY,SECURITYANSWER FROM people WHERE CERTIFICATION = '03/07/2001';
EXECUTE
SELECT IDNUMBER FROM people WHERE PROJECT = 'Thames';
EXECUTE
SELECT SECURITYANSWER,FIRSTNAME,TITLE FROM people WHERE LASTNAME = 'Ball';
EXECUTE
SELECT GENDER,SUFFIX,PASSWORDHASH FROM people WHERE INTERESTS = 'San Francisco Giants |Dallas Burn ';
EXECUTE
SELECT DOB,ZIPCODE FROM people WHERE ENTRYDATE = '05/06/2003';
EXECUTE
SELECT ADDRESS,COUNTRY FROM people WHERE BIRTHCITY = 'BRADFORD';
EXECUTE
SELECT IDSTATE,EYECOLOR FROM people WHERE INTERESTS = 'San Francisco Giants |Atlanta Thrashers ';
EXECUTE
SELECT MARITALSTATUS,EDUCATION,USERNAME FROM people WHERE IDSTATE = 'AR';
EXECUTE
SELECT DIRECTDEPOSIT,RELIGION FROM people WHERE MIDDLENAME = 'Marlene';
EXECUTE
SELECT ENTRYDATE,SSN,TITLE FROM people WHERE CERTIFICATION = '11/28/2003';
EXECUTE
SELECT PROJECT,BIRTHCOUNTRY,STATE FROM people WHERE BIRTHCOUNTRY = 'Scotland';
EXECUTE
SELECT BANKACCOUNT FROM people WHERE MIDDLENAME = 'Beverly';
EXECUTE
SELECT BIRTHSTATE FROM people WHERE LASTNAME = 'Hardin';
EXECUTE
SELECT BIRTHSTATE,ETHNICITY FROM people WHERE CERTIFICATION = '01/16/2006';
EXECUTE
SELECT MOBILEPHONE FROM people WHERE BIRTHCITY = 'Europe City';
EXECUTE
SELECT INTERESTS,PASSWORDHASH,PASSWORD FROM people WHERE MIDDLENAME = 'Duane';
EXECUTE
SELECT INTERESTS FROM people WHERE CERTIFICATION = '10/25/2002';
EXECUTE
SELECT IDSTATE FROM people WHERE BIRTHSTATE = 'MO';
EXECUTE
SELECT IDSTATE FROM people WHERE MIDDLENAME = 'Leon';
EXECUTE
SELECT STATE,SSN FROM people WHERE CERTIFICATION = '10/24/2008';
EXECUTE
SELECT DEPENDENTS,ENTRYDATE,BIRTHCITY FROM people WHERE INTERESTS = 'San Francisco 49'ers |Minnesota Timberwolves ';
EXECUTE
SELECT SUFFIX,WEIGHT FROM people WHERE ZIPCODE = '55319';
EXECUTE
SELECT HOMEPHONE,IDSTATE FROM people WHERE MIDDLENAME = 'Marian';
EXECUTE
SELECT BIRTHSTATE,TITLE,HOMEPHONE FROM people WHERE ZIPCODE = '93561';
EXECUTE
SELECT ZIPCODE,PROJECT FROM people WHERE MIDDLENAME = 'Jeff';
EXECUTE
SELECT PASSWORDHASH FROM people WHERE CERTIFICATION = '01/24/2006';
EXECUTE
SELECT MOBILEPHONE,DIRECTDEPOSIT,BIRTHCITY FROM people WHERE INTERESTS = 'Baltimore Orioles |Indianapolis Colts ';
EXECUTE
SELECT CERTIFICATION FROM people WHERE CERTIFICATION = '11/11/2005';
EXECUTE
SELECT SECURITYQUESTION FROM people WHERE INTERESTS = 'Detroit Red Wings |Indiana Pacers ';
EXECUTE
SELECT IDSTATE FROM people WHERE ZIPCODE = '63069';
EXECUTE
SELECT ZIPCODE,WEIGHT,WORKEMAIL FROM people WHERE ZIPCODE = '59101';
EXECUTE
SELECT MOBILEPHONE FROM people WHERE FIRSTNAME = 'Brandy';
EXECUTE
SELECT DEPENDENTS,MOBILEPHONE,INTERESTS FROM people WHERE CERTIFICATION = '01/24/2006';
EXECUTE
SELECT ETHNICITY,EYECOLOR,PASSWORDHASH FROM people WHERE INTERESTS = 'Utah Jazz |Seattle Mariners ';
EXECUTE
SELECT HEIGHT,PASSWORDHASH,LASTNAME FROM people WHERE WEIGHT = '133';
EXECUTE
SELECT EDUCATION,HOMEEMAIL FROM people WHERE ZIPCODE = '12072';
EXECUTE
SELECT BANKACCOUNT,STATE,BIRTHCITY FROM people WHERE CERTIFICATION = '11/03/2006';
EXECUTE
SELECT IDNUMBER,BIRTHSTATE,MARITALSTATUS FROM people WHERE CERTIFICATION = '04/27/2004';
EXECUTE
SELECT CERTIFICATION,DEPENDENTS FROM people WHERE CERTIFICATION = '09/16/2001';
EXECUTE
SELECT HOMEPHONE FROM people WHERE ZIPCODE = '77833';
EXECUTE
SELECT STATE,TITLE FROM people WHERE CERTIFICATION = '08/09/2007';
EXECUTE
SELECT ZIPCODE,SECURITYANSWER FROM people WHERE ZIPCODE = '75644';
EXECUTE
SELECT INTERESTS,HEIGHT FROM people WHERE MIDDLENAME = 'Ollie';
EXECUTE
SELECT PASSWORD FROM people WHERE ZIPCODE = '36862';
EXECUTE
SELECT INTERESTS FROM people WHERE STATE = 'OH';
EXECUTE
SELECT MIDDLENAME FROM people WHERE LASTNAME = 'Vazquez';
EXECUTE
SELECT SECURITYANSWER,SSN FROM people WHERE INTERESTS = 'Pittsburgh Steelers |Carolina Hurricanes ';
EXECUTE
SELECT COUNTRY,ETHNICITY,PASSWORD FROM people WHERE CITIZENSHIP = 'Nigeria';
EXECUTE
SELECT DIRECTDEPOSIT FROM people WHERE FIRSTNAME = 'Caroline';
EXECUTE
SELECT SSN FROM people WHERE PROJECT = 'North Utsire';
EXECUTE
SELECT ENTRYDATE,CERTIFICATION,STATE FROM people WHERE ZIPCODE = '97524';
EXECUTE
SELECT BIRTHSTATE,HAIRCOLOR FROM people WHERE CERTIFICATION = '07/21/2005';
EXECUTE
SELECT BIRTHSTATE,ETHNICITY,BANKACCOUNT FROM people WHERE BIRTHCITY = 'MESA';
EXECUTE
SELECT HOMEPHONE,EYECOLOR,BIRTHCITY FROM people WHERE EDUCATION = 'Associate degree';
EXECUTE
SELECT LASTNAME,BIRTHCOUNTRY,IDSTATE FROM people WHERE WEIGHT = '149';
EXECUTE
SELECT COUNTRY,DOB,IDNUMBER FROM people WHERE LASTNAME = 'Glenn';
EXECUTE
SELECT DOB FROM people WHERE CERTIFICATION = '11/11/2007';
EXECUTE
SELECT COUNTRY,SECURITYQUESTION,TITLE FROM people WHERE ZIPCODE = '48843';
EXECUTE
SELECT ZIPCODE,EYECOLOR FROM people WHERE CERTIFICATION = '09/12/2008';
EXECUTE
SELECT WORKEMAIL FROM people WHERE FIRSTNAME = 'Alison';
EXECUTE
SELECT PROJECT,SSN,MARITALSTATUS FROM people WHERE CERTIFICATION = '03/28/2005';
EXECUTE
SELECT ETHNICITY,IDSTATE FROM people WHERE BIRTHCITY = 'GOSHEN';
EXECUTE
SELECT STATE FROM people WHERE INTERESTS = 'Pittsburgh Pirates |Milwaukee Bucks ';
EXECUTE
SELECT WORKEMAIL,TITLE FROM people WHERE LASTNAME = 'Shepard';
EXECUTE
SELECT CITIZENSHIP,PROJECT FROM people WHERE CERTIFICATION = '07/19/2005';
EXECUTE
SELECT BIRTHCOUNTRY,FIRSTNAME,IDSTATE FROM people WHERE CERTIFICATION = '01/22/2004';
EXECUTE
SELECT ZIPCODE,TITLE,DIRECTDEPOSIT FROM people WHERE LASTNAME = 'Stevens';
EXECUTE
SELECT WORKPHONE,EYECOLOR FROM people WHERE MIDDLENAME = 'Gwendolyn';
EXECUTE
SELECT ETHNICITY FROM people WHERE MIDDLENAME = 'Wanda';
EXECUTE
SELECT EYECOLOR,HAIRCOLOR FROM people WHERE CERTIFICATION = '01/30/2003';
EXECUTE
SELECT IDNUMBER,SUFFIX FROM people WHERE CERTIFICATION = '07/29/2004';
EXECUTE
SELECT BANKACCOUNT FROM people WHERE CERTIFICATION = '11/10/2003';
EXECUTE
SELECT BIRTHCOUNTRY FROM people WHERE INTERESTS = 'MetroStars |New England Revolution ';
EXECUTE
SELECT RELIGION FROM people WHERE CERTIFICATION = '01/24/2004';
EXECUTE
SELECT CERTIFICATION,CITIZENSHIP,PASSWORDHASH FROM people WHERE CERTIFICATION = '08/18/2004';
EXECUTE
SELECT IDSTATE FROM people WHERE CERTIFICATION = '04/14/2000';
EXECUTE
SELECT STATE,PUBLICKEYHASH,BIRTHCITY FROM people WHERE CERTIFICATION = '06/18/2001';
EXECUTE
SELECT DOB,RELIGION FROM people WHERE FIRSTNAME = 'Opal';
EXECUTE
SELECT SUFFIX FROM people WHERE INTERESTS = 'Detroit Tigers |Milwaukee Bucks ';
EXECUTE
SELECT PASSWORDHASH FROM people WHERE CERTIFICATION = '10/20/2007';
EXECUTE
SELECT ENTRYDATE FROM people WHERE ZIPCODE = '49058';
EXECUTE
SELECT IDNUMBER,HOMEPHONE,SECURITYQUESTION FROM people WHERE ZIPCODE = '12834';
EXECUTE
SELECT DEPENDENTS FROM people WHERE CERTIFICATION = '12/19/2002';
EXECUTE
