Chapter 4 - Notebook¶

In [1]:

import psycopg2

import psycopg2

Connect to database¶

In [2]:

conn_string="dbname='dataengineering' host='206.189.46.156' user='postgres' password='jdW9IuFFztFJhHdMEuI3'"

conn_string="dbname='dataengineering' host='206.189.46.156' user='postgres' password='jdW9IuFFztFJhHdMEuI3'"

In [3]:

conn=psycopg2.connect(conn_string)
cur=conn.cursor()

conn=psycopg2.connect(conn_string) cur=conn.cursor()

Insert a row of data¶

In [10]:

query = "insert into users (id,name,street,city,zip) values({},'{}','{}','{}','{}')".format(1,'Big Bird','Sesame Street','Fakeville','12345')

query = "insert into users (id,name,street,city,zip) values({},'{}','{}','{}','{}')".format(1,'Big Bird','Sesame Street','Fakeville','12345')

In [11]:

cur.mogrify(query)

cur.mogrify(query)

Out[11]:

b"insert into users (id,name,street,city,zip) values(1,'Big Bird','Sesame Street','Fakeville','12345')"

In [8]:

cur.execute(query)

cur.execute(query)

In [9]:

conn.commit() # save changes to database

conn.commit() # save changes to database

Insert a row of data using tuples¶

In [12]:

query2 = "insert into users (id,name,street,city,zip) values(%s,%s,%s,%s,%s)"
data=(2,'Grouch','Sesame Street','Fakeville','12345')

query2 = "insert into users (id,name,street,city,zip) values(%s,%s,%s,%s,%s)" data=(2,'Grouch','Sesame Street','Fakeville','12345')

In [13]:

cur.mogrify(query2,data)

cur.mogrify(query2,data)

Out[13]:

b"insert into users (id,name,street,city,zip) values(2,'Grouch','Sesame Street','Fakeville','12345')"

In [12]:

cur.execute(query2,data)
conn.commit()

cur.execute(query2,data) conn.commit()

Inserting Multiple Records¶

In [4]:

from faker import Faker

from faker import Faker

In [15]:

fake = Faker()
data = []
i = 3

fake = Faker() data = [] i = 3

In [16]:

# create data to load to database
for r in range(1000):
    data.append((i,
                fake.name(),
                fake.street_address(),
                fake.city(),
                fake.zipcode()))
    i = i + 1
    
data_for_db=tuple(data)

# create data to load to database for r in range(1000): data.append((i, fake.name(), fake.street_address(), fake.city(), fake.zipcode())) i = i + 1 data_for_db=tuple(data)

In [17]:

query = "INSERT INTO users (id, name, street, city, zip) values(%s, %s, %s, %s, %s)"

query = "INSERT INTO users (id, name, street, city, zip) values(%s, %s, %s, %s, %s)"

In [18]:

data_for_db[1]

data_for_db[1]

Out[18]:

(4,
 'Christopher Rodriguez',
 '662 Hancock Ville Apt. 046',
 'New Justin',
 '48470')

In [19]:

# see the query for a single row
cur.mogrify(query, data_for_db[1])

# see the query for a single row cur.mogrify(query, data_for_db[1])

Out[19]:

b"INSERT INTO users (id, name, street, city, zip) values(4, 'Christopher Rodriguez', '662 Hancock Ville Apt. 046', 'New Justin', '48470')"

In [20]:

cur.executemany(query, data_for_db)

cur.executemany(query, data_for_db)

In [21]:

conn.commit()

conn.commit()

Extracting data from PostgreSQL¶

Using Python¶

In [22]:

query = "SELECT * FROM users"

query = "SELECT * FROM users"

In [45]:

cur.execute(query)

cur.execute(query)

In [24]:

# One option is to iterate over the results
for record in cur:
    print(record)

# One option is to iterate over the results for record in cur: print(record)

('Big Bird', 1, 'Sesame Street', 'Fakeville', '12345')
('Grouch', 2, 'Sesame Street', 'Fakeville', '12345')
('Lucas Bryant', 3, '96205 Robinson Underpass', 'North Cherylland', '35412')
('Christopher Rodriguez', 4, '662 Hancock Ville Apt. 046', 'New Justin', '48470')
('Thomas Thompson', 5, '5051 Figueroa Park', 'Tylerton', '22303')
('Randy Carpenter', 6, '1477 James Park', 'Lake Robert', '26465')
('Angela Skinner', 7, '0529 Jones Ville Apt. 227', 'West Alexandraport', '97811')
('Justin Clements', 8, '9470 Benjamin Well', 'Tommyview', '10460')
('Kimberly Walker', 9, '5496 Zuniga Roads Apt. 515', 'Bullockton', '16231')
('Vanessa Hunt', 10, '016 Veronica Mountains Apt. 870', 'West Tylerburgh', '85953')
('Gabrielle Whitehead', 11, '13431 Dixon Common', 'South Nicholas', '33700')
('Brent Martinez', 12, '322 Joseph Alley', 'Lake Jenniferchester', '66185')
('Charlotte Leonard MD', 13, '301 Joseph Vista Apt. 937', 'South Brandonmouth', '42103')
('James Williams', 14, '710 Ann Mission Apt. 588', 'Rossstad', '66738')
('Scott Rosario', 15, '511 Haley Spring', 'Port Troy', '68244')
('Jose Gonzales', 16, '4350 Molly Mountains', 'Elijahmouth', '87157')
('Christopher Adams', 17, '11289 Rowland Turnpike', 'Port Lisa', '95215')
('Sarah Jimenez', 18, '2526 White Court', 'New Shelbyshire', '46465')
('Emily Martin', 19, '80191 Christian Lock', 'South Edward', '06137')
('Kevin Rodgers', 20, '65205 Amy Crest', 'Johnview', '54550')
('Abigail Wagner', 21, '87877 Kenneth Inlet', 'Sandovalland', '60988')
('Beth Miller', 22, '28058 Soto Streets Suite 620', 'Paulside', '22447')
('Michael Jennings MD', 23, '721 Davidson Mountains', 'East Jenniferport', '92545')
('Isabella Pearson MD', 24, '2180 White Loaf Suite 110', 'East Tyler', '02250')
('Maria Conway', 25, '676 Jimmy Hollow', 'Wolffort', '31135')
('Melissa Garcia', 26, '567 John Brooks', 'East Patricia', '50870')
('Paula Elliott', 27, '6284 Thomas Extension', 'East Dennis', '26771')
('Barbara Phillips', 28, '982 Alvarez Vista Apt. 335', 'South Katie', '43315')
('Mary Johnson', 29, '1303 Julia Park', 'Lake Benjamin', '84423')
('Keith Osborne', 30, '57063 Torres Drives', 'East Christopher', '79353')
('David Morse DVM', 31, '9019 Christian Green', 'Larryberg', '05721')
('Kathryn Burke', 32, '84866 Crawford Drives', 'Autumnside', '95537')
('Kyle Myers', 33, '96865 Bolton Ways Apt. 851', 'Michelleport', '21665')
('Kristie Chang', 34, '3071 Juarez Park Apt. 344', 'Evansview', '21110')
('John Nunez', 35, '1060 Lamb Green Suite 328', 'Hughesview', '07737')
('Alison Garrett', 36, '2818 Latoya Harbors Suite 152', 'West Rachaelchester', '80274')
('Kyle Walter', 37, '334 Raymond Haven Suite 971', 'Rileyshire', '89381')
('Christopher Williams', 38, '89061 Steven Fall', 'Melissamouth', '92327')
('Thomas Allen', 39, '953 Shannon Camp', 'Smithstad', '52841')
('Patricia Ortiz', 40, '176 Moore Viaduct', 'Schaeferton', '85550')
('Kathryn Allen', 41, '2121 Matthew Square Suite 535', 'South Don', '52200')
('Cole Moody', 42, '372 Jesse Fields Apt. 499', 'Fisherbury', '88210')
('Mr. Alexander Wood', 43, '3267 Alicia Pine', 'Salasborough', '57873')
('Jennifer Young', 44, '8372 Robert Valleys', 'Lake Julie', '37441')
('Melinda Perkins', 45, '1894 Cordova Ways', 'Johnsonmouth', '43796')
('James Watkins', 46, '203 Joshua Village', 'Port Patrick', '29068')
('Aaron Miller', 47, '9460 Kylie Summit', 'Martintown', '52143')
('Patricia Reynolds', 48, '65029 Navarro Crescent Apt. 337', 'Sandraland', '65368')
('Colleen Olson', 49, '8705 Wolf Grove', 'Port Bradleyfort', '52941')
('Alexander Stanley', 50, '800 Katherine Brooks', 'Emilyfort', '83178')
('Luis Barnett', 51, '1643 Thornton Valleys', 'Port Karenmouth', '36329')
('Daniel Schmidt MD', 52, '983 Smith Extension', 'Garciaview', '03999')
('Monica Castro', 53, '679 Peterson Alley Suite 473', 'South Kevinport', '41438')
('Patricia Williamson', 54, '448 Moore Burg', 'Lindahaven', '08771')
('Maria Mckee', 55, '564 Walter Motorway Apt. 254', 'East Danielshire', '62721')
('Casey Valencia', 56, '8370 Gilbert Circles', 'New Anthonyville', '17262')
('Eric Willis', 57, '3454 Jones Oval Suite 632', 'South Amandaport', '73156')
('Joshua Oneill', 58, '3140 Edward Overpass', 'Port Susanview', '73715')
('William Vaughn', 59, '2813 James Flats', 'Marshallland', '58294')
('Trevor Valdez', 60, '0170 Richards Lakes', 'Thompsonton', '76561')
('Robert Jackson', 61, '347 Robert Pine', 'Walterhaven', '79825')
('Lori Hill', 62, '50271 White Fork Apt. 040', 'Reyeston', '86292')
('Aaron Jones', 63, '3051 Bailey Heights Suite 407', 'Amandaton', '74552')
('Amanda Franklin', 64, '6153 Fox Ridges Suite 338', 'Ashleystad', '71256')
('Brittany Daniels', 65, '125 Joseph Field', 'South Aprilburgh', '48123')
('Vicki Cummings', 66, '2964 Kane Rapids', 'Justinborough', '05988')
('Joseph Graham', 67, '172 Sawyer Extension', 'Robertmouth', '65735')
('Bethany Miller', 68, '7486 Cynthia Stream Suite 603', 'Phelpsland', '06317')
('Stephen Taylor', 69, '0653 John Lodge Suite 289', 'Port Krystalside', '54276')
('Mr. Bobby Fuentes', 70, '70650 Mccarty Spring', 'Port Nancyshire', '48842')
('Jennifer Johnston', 71, '399 Autumn Tunnel Apt. 661', 'Danielview', '43891')
('Linda Beck', 72, '34460 Laura Parks', 'Dominicstad', '53854')
('Maria Nichols', 73, '34193 Tara Expressway', 'East William', '21565')
('Brad Atkinson', 74, '872 Dawson Landing Suite 925', 'North Brianborough', '75494')
('Katrina Hutchinson', 75, '3864 Marshall Forest Apt. 150', 'Jesseville', '90074')
('Ronald Torres', 76, '255 Austin Trafficway Apt. 398', 'Stevenport', '90998')
('Crystal Brown', 77, '16453 Brown Tunnel Suite 065', 'Lauraberg', '46352')
('Michelle Nelson', 78, '608 Johnson Cliffs', 'Amandaton', '60068')
('Bryan Rodriguez', 79, '690 Brandon Ports', 'Alexanderstad', '46755')
('Shannon Maldonado', 80, '568 Laura Point Apt. 462', 'Thompsonborough', '07151')
('David Mendoza', 81, '0076 Kyle Grove', 'Melissabury', '07295')
('Jennifer Reed', 82, '41838 Christopher Rue', 'Murphyport', '23243')
('John Crawford', 83, '804 Brett Manor', 'North Victoriatown', '04252')
('Megan Obrien', 84, '60615 Jasmine Glen Suite 464', 'Martinport', '98413')
('Daniel Gates', 85, '7638 Katie Point', 'Port Markhaven', '09239')
('Stacy Green', 86, '0432 Wolfe Stream', 'North Jasonborough', '10726')
('Samantha Garrett', 87, '09729 Dorsey Estate', 'Lake Sandraview', '42076')
('Grace Brown', 88, '89102 Young Crest Suite 117', 'Johnsonmouth', '99379')
('Kimberly Greene', 89, '821 Austin Bridge Apt. 531', 'Jamesberg', '09217')
('Gabrielle Wilson', 90, '6955 Scott Glens', 'Jakeland', '68585')
('Jennifer Mathews', 91, '5727 George Unions', 'Lake Corymouth', '52546')
('William Whitney', 92, '545 Scott Meadow', 'Roweland', '32113')
('Austin James', 93, '085 Paul Divide', 'Riverastad', '78376')
('Alexander Ramsey', 94, '2288 Lisa View', 'Lake Jacob', '93258')
('Aaron Smith', 95, '2048 May Square', 'West Timothy', '79478')
('James Johnson DDS', 96, '8754 Jerry Rapid Suite 152', 'Richardsonport', '64606')
('Mark Brown', 97, '144 Baker Harbor', 'Millertown', '98371')
('Troy Fisher', 98, '857 Jake Trace Suite 067', 'Joycebury', '90044')
('Michelle Diaz', 99, '49177 Lowe Highway Apt. 671', 'Natashaside', '43405')
('Jesus Clarke', 100, '449 Brian Dale', 'Brownmouth', '08554')
('Matthew Acosta', 101, '05251 Webb Ridges', 'New Ashley', '11412')
('Lori Maddox', 102, '820 Kidd Loaf', 'Webstershire', '09456')
('Audrey Chapman', 103, '159 Black Lodge Apt. 161', 'West John', '82136')
('Samantha Nunez', 104, '1688 Joseph Field Apt. 180', 'North Ryanport', '69472')
('Christine Wagner', 105, '74861 Ryan Loaf Apt. 601', 'Port Ethan', '24140')
('Sarah Davis', 106, '63889 Dana Pines', 'West Christophertown', '63635')
('Brenda Sullivan', 107, '6108 Jennings Overpass', 'Robertshire', '87542')
('Daniel Bryant', 108, '42625 Martin Gateway', 'West Michael', '38999')
('James Kelly', 109, '2759 Kevin Drives', 'East Johnland', '10914')
('Todd Rogers', 110, '013 Hernandez Corner', 'Lake Lesliemouth', '29122')
('Janet Thompson', 111, '893 James Route Suite 312', 'Davidhaven', '97393')
('Antonio Garcia', 112, '602 Amanda Lodge Suite 643', 'Nancytown', '19161')
('Fernando West', 113, '361 Randall Oval Apt. 208', 'New Thomasborough', '97640')
('Thomas Ward', 114, '90214 Jordan Skyway Apt. 987', 'Lake Michaelfurt', '18259')
('Mark Ramirez', 115, '612 Beth Ford', 'Richardfort', '85192')
('Theresa Johnson', 116, '273 Lori Fields Suite 450', 'North Joelport', '50852')
('Tiffany Levine', 117, '3811 Clarke Burg', 'Bautistaside', '84471')
('Barbara Johnson', 118, '491 Cindy Port', 'Martinezfort', '21968')
('Sarah Haley', 119, '7589 Brittany Village Suite 815', 'Anthonyville', '50267')
('Andrew Ray', 120, '662 Andrews Tunnel', 'East Elizabethhaven', '04932')
('Christian Leon', 121, '1156 Hensley Turnpike Suite 423', 'Lake Travis', '75511')
('Joseph Johnson', 122, '4789 Dawn Mills Suite 645', 'Port Alexishaven', '18198')
('Alan Cobb', 123, '60978 Johnson Plain', 'Jameston', '92829')
('Dr. Sarah Craig DVM', 124, '273 Angelica Port', 'North Jessica', '53327')
('Daniel Yang', 125, '2918 Alec Village', 'West Dylan', '16718')
('Melanie Brown', 126, '3745 David Landing', 'Michaelmouth', '02381')
('Theresa Morales', 127, '01921 Huynh Avenue', 'New Alyssaton', '35815')
('Tiffany Rivera', 128, '2988 Kerr Lock', 'Lake Laura', '39194')
('Nicole Lynch', 129, '0706 Daniel Falls Suite 845', 'Torresmouth', '54022')
('Jesse Parks', 130, '219 Paul Path Apt. 455', 'Amberville', '69627')
('Dana Schultz', 131, '4978 Michael Bridge', 'West Brian', '94583')
('Lisa Miller', 132, '81999 Baxter Dam Apt. 104', 'Scottton', '15628')
('Kathryn Taylor', 133, '8470 David Point Suite 364', 'Sharontown', '26595')
('Joshua Wright', 134, '0225 Brian Common', 'West Brenda', '74583')
('Kenneth Morales', 135, '10583 Jeffrey Street', 'Andreaton', '01657')
('Amy Wilson', 136, '38774 Micheal Freeway Suite 225', 'West Deantown', '65991')
('Matthew Morgan', 137, '9955 Patel Turnpike', 'Andrewshaven', '59602')
('Jennifer Thompson', 138, '34297 Fowler Canyon', 'East Russellbury', '45287')
('Alexander Garza', 139, '6496 Jennifer Haven', 'East Denise', '63899')
('Jessica Logan', 140, '83664 Martinez Ferry Apt. 145', 'Port Jeffshire', '52861')
('Donna Quinn', 141, '3955 Donald Dam', 'Lambertport', '50758')
('Megan Mcguire', 142, '490 Petersen Trail Suite 945', 'Lake Patricia', '67715')
('Michael Roman', 143, '724 Nicole Trail Apt. 154', 'Rodneyfort', '30425')
('Jeffrey Byrd', 144, '028 Michelle Field', 'Earlside', '16941')
('Mrs. Paige Warren', 145, '4303 Davidson Roads', 'Lake Lesliehaven', '85604')
('Holly Martin', 146, '0782 Snyder Views', 'North Jasonville', '89442')
('Michael Kerr', 147, '19963 Jeremy Forge Suite 755', 'East Joshuashire', '25115')
('Kim Bryan', 148, '899 Glass Vista', 'Janicestad', '39304')
('Alexandra Smith MD', 149, '7684 Jensen Lake Apt. 202', 'Ballchester', '27323')
('Michelle Taylor', 150, '8663 Thomas Village', 'East Courtney', '91711')
('Jane Bailey', 151, '0444 Jennifer Freeway', 'South Amandashire', '68474')
('Craig Robinson', 152, '953 Watkins Burgs Suite 572', 'Smithville', '93669')
('Teresa Lambert', 153, '242 Chad Forks Suite 017', 'West Stuartbury', '90322')
('Mr. Chad Clay', 154, '125 Salazar Gateway Suite 142', 'Lewisbury', '22103')
('Angelica Kelley', 155, '1480 Cox Well Suite 946', 'Austinside', '95101')
('Sandra Rodriguez', 156, '652 Johnson Rapids', 'Hamiltonport', '49519')
('Michael Floyd', 157, '3503 Mcmahon Mews', 'Gallowayland', '84740')
('Tracey Olson', 158, '86487 Smith Stravenue Suite 079', 'East Samantha', '87062')
('Lauren Kaufman', 159, '098 Williams Radial', 'Ortizbury', '04949')
('Laura Kane', 160, '415 Brittany Islands', 'Port Kathleen', '18861')
('Andrew Fry', 161, '40006 Fox Roads Apt. 543', 'East Bruce', '67779')
('Charles Garza', 162, '1076 David Motorway', 'East Ashleyborough', '27989')
('Stephen Walker', 163, '794 Brittany Trafficway', 'West Rachael', '80730')
('Caleb Gregory', 164, '5363 David Prairie', 'North Rachelfurt', '17057')
('Catherine Hall', 165, '150 Kenneth Forks Apt. 577', 'New Holly', '44806')
('Wanda Beck', 166, '737 Ruiz Tunnel', 'East Michael', '94716')
('Anthony Doyle', 167, '382 Bradford Gateway Suite 515', 'Kennedytown', '01134')
('Abigail Stanton', 168, '68789 Murphy Vista', 'Josephtown', '47358')
('Michael Hoffman', 169, '65151 Beverly Hill', 'South Ryan', '53524')
('Nicole Moore', 170, '6568 Angela Circle Suite 310', 'New Cynthia', '44482')
('Dustin Stewart', 171, '1030 Elliott Locks', 'East Eric', '92419')
('Teresa Kelly', 172, '8607 William Hollow', 'West Samantha', '55638')
('Jill Perez', 173, '2007 Wheeler Village Apt. 542', 'Carrside', '09533')
('Joseph Martinez', 174, '5515 Martinez Dam Apt. 112', 'East Anthony', '85077')
('Donald Carroll', 175, '026 Smith Village Apt. 187', 'West Joseph', '10926')
('Breanna Hendrix', 176, '44969 Lisa Common', 'Angelamouth', '58483')
('Timothy Murphy', 177, '858 Howard Landing Suite 459', 'Penningtonstad', '06199')
('Timothy Phillips', 178, '8400 Tina Falls Suite 816', 'Port Michelle', '77098')
('David King', 179, '9076 King Rapids Suite 855', 'East Markchester', '93188')
('Richard Garcia', 180, '778 Gardner Key', 'Connieport', '07302')
('Ronald Thomas DDS', 181, '898 Tara Squares Apt. 932', 'Jacksonberg', '72962')
('Michael Contreras', 182, '998 Michelle Mall Suite 131', 'Lawrencetown', '19536')
('John Walker', 183, '25129 Walker Garden Suite 603', 'Jacquelineside', '96566')
('Jacob Moore', 184, '5390 Shaw Shoals Suite 007', 'Lake Spencer', '15028')
('Robert Miller', 185, '67819 Alex Shoal Apt. 555', 'Josephfort', '23820')
('Kathleen Cooke', 186, '084 Hodge Radial', 'Kaiserport', '50493')
('Diana Ross', 187, '0481 Young Meadows', 'Arellanoshire', '55475')
('Samantha Davis', 188, '2114 Elizabeth Roads', 'Catherineview', '51225')
('Richard Calderon', 189, '56156 Catherine Neck Apt. 901', 'Markshire', '08674')
('Emily Jordan', 190, '049 Harris Expressway Suite 144', 'Kevinstad', '86937')
('Kyle Lin', 191, '2667 Stephanie Point', 'East Rachelstad', '29961')
('Vincent Garcia', 192, '7191 Alexander Course Suite 167', 'West Barbaramouth', '18317')
('Michelle Rios', 193, '1768 Jason Loaf', 'Maybury', '45893')
('Margaret Jones', 194, '736 Miller Coves Suite 321', 'North Kimberlytown', '35221')
('Donald Boyle', 195, '964 Griffin Ramp', 'Middletonfort', '11578')
('Elizabeth Davis', 196, '75104 Melissa Island', 'North Susan', '44962')
('Todd Russell', 197, '832 Cooper Wells Apt. 748', 'East Jason', '92538')
('Kenneth Harper', 198, '6216 Patel Flats Apt. 021', 'New Sherry', '12204')
('Tyler Dorsey', 199, '2821 Jackson Track', 'Port Shelley', '32670')
('Jeffrey Harris', 200, '58321 Brenda Ridges Suite 906', 'Russellview', '83398')
('William Foster', 201, '779 Gutierrez Road', 'Piercemouth', '89240')
('Tracy Ramirez', 202, '12832 Matthew Island Suite 952', 'North Donaldbury', '65891')
('David Clarke', 203, '833 Russell Oval', 'Davidhaven', '51415')
('Larry Fleming', 204, '11545 Gonzales Estate', 'West Natalieshire', '15962')
('Jake Jones', 205, '11110 Smith Mission', 'New Barry', '47216')
('Mathew Sparks', 206, '28124 Cheryl Stream', 'Edwardsmouth', '90843')
('Johnny Wallace', 207, '0698 Bryan Ferry', 'West Andrea', '31840')
('Alexander Melton', 208, '3773 Jennings Estate', 'New Kimberlyborough', '78977')
('Gabriel Jackson', 209, '804 Simpson Summit Apt. 379', 'Deniseton', '96173')
('Matthew Henderson', 210, '35189 Camacho Rue', 'Lake Crystal', '75681')
('Thomas Lindsey', 211, '700 Roberts Flats Apt. 393', 'Port Samanthashire', '94375')
('Dorothy Woods', 212, '6216 Graham Haven', 'Port Angela', '88303')
('Deanna Hopkins', 213, '5527 Anna Roads', 'North Rebeccashire', '98628')
('Kathleen Fleming', 214, '32661 Andrea Divide', 'Normaborough', '49609')
('Michael Lewis', 215, '3944 Christopher Mall', 'West Shane', '62476')
('Rhonda Clarke', 216, '1504 Jessica Inlet', 'Hernandezfurt', '88740')
('Christopher Snow', 217, '41286 Palmer Dam Apt. 689', 'Blackville', '97758')
('Michael Leon', 218, '76802 Powers Rapid', 'Port Ashleyburgh', '80462')
('Rhonda Schultz', 219, '9247 Dominique Flats Apt. 991', 'West Katherineton', '79974')
('Whitney Hamilton', 220, '802 Kyle Village Apt. 495', 'North Thomasbury', '76121')
('Meghan Brown', 221, '0169 John Parkway Apt. 432', 'Dunnport', '26001')
('Jessica Hansen', 222, '2680 Webb Valley', 'Stewartburgh', '03921')
('Kevin Leblanc', 223, '6512 Baker Ridges Apt. 006', 'Clarkview', '67899')
('Jeremiah Cole', 224, '63527 Sabrina Mount', 'Lake Donaldhaven', '01375')
('John Collins', 225, '8969 Townsend Island', 'East Emilyland', '77156')
('George Adams', 226, '283 Tanya Oval', 'Joshuabury', '00937')
('Andrea Lee', 227, '081 Reynolds Passage', 'West Edwardshire', '50979')
('Stephen Patrick', 228, '10969 Judy Walk', 'Danielborough', '21620')
('Alexis Wilson', 229, '8853 Briana Loop', 'Evanberg', '79693')
('Tracy Wheeler', 230, '1445 Thompson Road Suite 421', 'Michaelview', '95677')
('Chloe Stevens', 231, '3345 Medina Brook', 'Browntown', '32146')
('Amanda Blair', 232, '771 John Drive Suite 740', 'North Elizabethtown', '19840')
('Christopher Edwards', 233, '48627 Jason Creek Suite 584', 'Port Brandonberg', '41155')
('Tina Cole', 234, '6851 Tristan Tunnel Apt. 829', 'Port Nicole', '03126')
('Michael Robinson', 235, '05130 Amber Ways', 'Kaitlynbury', '51253')
('Donald Anthony', 236, '428 Mullins Roads', 'Mooreport', '82021')
('Terri Martinez', 237, '555 Maldonado Drive', 'Port Miguelmouth', '94067')
('Theresa Adkins MD', 238, '401 Garcia Parks Suite 161', 'East Richard', '79960')
('Matthew Mckinney', 239, '955 Rice Square', 'West Andrew', '18705')
('Michael Lozano', 240, '345 Holly Glen Apt. 028', 'Robertmouth', '88217')
('Gail Carr', 241, '7722 Jeffrey Plaza', 'Wesleytown', '55395')
('Shawn Harris', 242, '359 Zimmerman Lakes', 'Mercedesburgh', '81240')
('Emily Richardson', 243, '80215 Mackenzie Fall Suite 733', 'Port Thomas', '56176')
('Thomas Cunningham', 244, '57854 Nelson Squares', 'Barryview', '61469')
('Ryan Carter', 245, '2369 Patrick Point', 'Reevesshire', '26056')
('Julie Kent', 246, '917 Richardson Harbor', 'Stevensonview', '89981')
('Beth Graham', 247, '67902 Leslie Passage', 'Woodfurt', '92113')
('Christie Edwards', 248, '1442 Newton Rapids Apt. 249', 'Lindseyside', '18509')
('Lauren Boone', 249, '78032 Sherman Flats', 'North Clayton', '48429')
('Zachary Parker', 250, '6756 Reginald Pine', 'Courtneyland', '42063')
('Abigail Mann', 251, '4353 Cooper Overpass', 'Port Johnmouth', '02854')
('Rebecca Gillespie', 252, '572 Steve Crossroad', 'Blackstad', '94304')
('Anthony Compton', 253, '930 Sara Hollow Apt. 982', 'East Jake', '76070')
('Keith Salazar', 254, '652 Jones Village Apt. 471', 'West Virginiaberg', '32129')
('Victoria Davidson', 255, '95315 Perez Dale', 'Juanview', '33885')
('Margaret Figueroa', 256, '8258 Daniel Island', 'East Jenniferland', '37821')
('Allen Ramirez', 257, '07480 Oscar Parks', 'Leemouth', '66505')
('Joseph Mckenzie', 258, '793 Lee Mills', 'Foxborough', '94018')
('Michael Butler', 259, '82550 Hill Fall Apt. 570', 'Walkerview', '25907')
('Amy Martin', 260, '79280 Erica Lights', 'Whiteside', '18617')
('Elizabeth Johns', 261, '70390 Manning Bypass Apt. 691', 'Ramosborough', '95718')
('Susan Garcia', 262, '45862 Ryan Rapid', 'Brianchester', '11851')
('Terry Reynolds', 263, '73475 Stephenson Drive', 'Kennedyton', '41555')
('Seth Gomez', 264, '1427 Kevin Pike', 'Jeanburgh', '46269')
('Robert Hayes', 265, '600 Graves Point Apt. 482', 'Robertburgh', '05110')
('Ralph Myers', 266, '86273 Scott Lakes Suite 526', 'North Rachel', '79442')
('Eric Chen', 267, '40224 Vang River', 'New Robert', '86966')
('Mallory Hayes', 268, '636 Chavez Ferry', 'North Melindachester', '52484')
('Crystal Little', 269, '57719 Andrew Manors', 'Jacksonview', '88761')
('Yolanda Acosta', 270, '857 Burke Lake Suite 861', 'New Wesleymouth', '19256')
('Matthew Buckley', 271, '9976 Thompson Drive Suite 502', 'South Donnatown', '30145')
('Cameron Powell', 272, '5593 Hayes Trail', 'South William', '37817')
('Alejandro Jarvis', 273, '807 Walter Inlet', 'North Rebeccafurt', '52647')
('Daniel Gutierrez', 274, '47860 Burgess Drive Suite 845', 'Ruizburgh', '23505')
('Amanda Burke', 275, '368 Charles Crossing Apt. 300', 'East Maryborough', '80092')
('Lisa Meza', 276, '937 Pierce Harbor', 'New Chloe', '02388')
('John Wallace', 277, '46661 Robles Stream Apt. 162', 'Wendyfurt', '71571')
('John Wood', 278, '9328 Olson Centers Suite 766', 'Karentown', '75615')
('Tiffany Gardner', 279, '4186 David Views Suite 003', 'North Tiffany', '05213')
('Anthony Wilson', 280, '88564 Hoffman Curve Apt. 290', 'Villatown', '63292')
('Claire Rose', 281, '6211 Aaron Ridge Apt. 735', 'Murphybury', '38240')
('John Smith', 282, '56757 Taylor Summit Suite 023', 'Ashleymouth', '66715')
('Rebecca Cox', 283, '065 Sherman Gardens', 'East Stephaniemouth', '57103')
('Alison Cortez', 284, '4250 Jonathan Fort Apt. 153', 'Lake Gregory', '82991')
('David Mooney', 285, '79543 Bush Mission Apt. 874', 'Johnsonton', '11413')
('Kenneth Anderson', 286, '71759 Sherri Gardens Suite 459', 'Tammyport', '79462')
('Christopher Daniels', 287, '193 Sanchez Junction', 'Lorihaven', '30452')
('Randall Perry', 288, '74608 Mary Glen', 'Amberborough', '20553')
('Donna Thomas', 289, '457 Tyler Curve', 'Youngmouth', '32798')
('Joel Daniel', 290, '548 Velasquez River Suite 300', 'Curryview', '94627')
('Kristen Ware', 291, '26384 Walker Curve Suite 911', 'Lake Mark', '43423')
('Brian Sellers', 292, '3023 Claudia Pass Apt. 677', 'West Kathyview', '92261')
('Felicia James', 293, '52273 Cole Brooks', 'Serranoland', '17615')
('John Barron', 294, '81875 Diane Brooks', 'North Justin', '26738')
('Kenneth Perry', 295, '119 Ruiz Rue', 'New Gregorytown', '60544')
('Alicia Simmons', 296, '937 Sydney Cliff Apt. 121', 'Lake Patrick', '63334')
('David Lopez', 297, '78657 Patrick Isle', 'Yvonnehaven', '94076')
('Tracy Reeves', 298, '44685 Jeffrey Ridge', 'North Kristen', '91181')
('John Sanchez', 299, '7070 Charles Fork', 'Spencershire', '60027')
('Melissa White', 300, '753 Lauren Dale', 'North Stevenstad', '85170')
('Mary Potter', 301, '4426 Smith Skyway Apt. 377', 'East Kevinstad', '16395')
('Chelsea Kirk', 302, '60875 Suarez Inlet', 'Williamfurt', '23111')
('Derek Howard', 303, '8554 Kevin Isle', 'New Leahmouth', '86074')
('Kelly Evans', 304, '753 Anderson Estate Suite 106', 'New Jonathan', '41631')
('Dennis Black', 305, '38671 Mendoza Field Apt. 236', 'Torresbury', '17379')
('Lisa Carter', 306, '590 Goodwin Mall', 'New Kathleen', '54604')
('Daniel West', 307, '711 Henderson Cove', 'Lake Davidfort', '59408')
('Jennifer Anderson', 308, '053 Johnson Crescent Suite 503', 'Port Theresatown', '09199')
('Deborah Pearson', 309, '00429 Tucker Meadows Apt. 087', 'Arellanomouth', '23920')
('Troy Barton', 310, '7186 Riddle Path', 'East Tonya', '57597')
('Mario Rich', 311, '1200 Pineda Grove Apt. 106', 'Lake Andre', '39744')
('Erin Tran', 312, '50375 Roth Trail', 'Foleyhaven', '33523')
('Steven Proctor', 313, '2722 Jennifer Springs', 'Richardsonbury', '85794')
('Brittney Richards', 314, '6432 Guerrero Coves', 'Melissaburgh', '81961')
('Patricia Campbell', 315, '578 Powell Drive Suite 164', 'East Madisonburgh', '72626')
('Lawrence Owens', 316, '5354 Abbott Drive Apt. 328', 'Toddborough', '01078')
('Lori Roy', 317, '8729 Jennifer Mountains', 'Port John', '32103')
('Jesse Erickson', 318, '41877 Jennifer Plaza', 'South Donnaview', '58787')
('Julie Buck', 319, '6141 Jon Harbors', 'Gregoryhaven', '39951')
('William Clark', 320, '596 Sanchez Meadow Apt. 977', 'Craigville', '98695')
('Tammy Lewis', 321, '16123 Newton Forks', 'Mullentown', '05509')
('Mr. Richard Johnson', 322, '17222 Kim Place', 'South Dawn', '35092')
('Andrew Nguyen', 323, '583 Andrew Pike', 'South Sean', '91318')
('John Bond', 324, '934 Jones Light Suite 547', 'Port Anthony', '11080')
('Tamara Woods', 325, '372 Fernandez Walks Suite 149', 'New Tracy', '59751')
('Kirk Sanchez', 326, '35014 Coleman Parkway', 'North Ashleytown', '40219')
('Joshua Smith', 327, '11103 Hess Points Suite 331', 'Port Zacharyfort', '89765')
('Nathan Smith', 328, '1592 Dawn Mountain Suite 886', 'Lake Seanside', '77969')
('Joseph Brennan', 329, '67151 Johnson Canyon Suite 417', 'New Alexander', '78822')
('Jerry Patel', 330, '43411 Janet Junctions', 'Jamesberg', '05758')
('Mary Ferrell', 331, '334 Douglas Heights', 'Kevinton', '69297')
('Brooke Lester', 332, '300 Andrea Knoll Suite 471', 'South Robertshire', '31190')
('Alec Lewis', 333, '00245 Jeffery Trafficway', 'Lake Heather', '40149')
('Jeffrey Phillips', 334, '121 Paul Row', 'New Bobbymouth', '27483')
('Amy Wright', 335, '0438 Madison Plain Apt. 781', 'Moyertown', '77781')
('Erik Goodwin', 336, '7245 Renee Mount', 'New Rita', '23984')
('Kristen Byrd', 337, '7160 Lori Village Suite 445', 'Scottberg', '60616')
('Ariel Morse', 338, '60745 Michael Streets Apt. 320', 'Matthewville', '61687')
('Stephanie Newman', 339, '23329 Jessica Road', 'Lake Adamstad', '57528')
('Elizabeth Mitchell', 340, '673 John Gateway Suite 153', 'Port Jasonton', '43798')
('Jesse Sutton', 341, '93480 Ann Coves', 'Salazarburgh', '62723')
('David Moreno', 342, '1598 Lewis Station', 'Brittanychester', '86577')
('Robyn Wilson', 343, '9680 Rodney Knolls', 'Alexmouth', '74935')
('Joann White', 344, '5089 West Track', 'Clarkfort', '02697')
('Donald Barker', 345, '50256 Myers Flats Suite 614', 'Martintown', '62694')
('Jeffrey Baker', 346, '4015 Christian Plains', 'Oscarport', '66778')
('Isabella Brooks', 347, '52543 Theodore Groves Apt. 334', 'Bauermouth', '31992')
('Beth Rice', 348, '717 Lee Land', 'Nelsonborough', '89953')
('Shannon Coleman', 349, '7595 Lauren Pike Apt. 337', 'Kathyside', '24585')
('Shawn Haley Jr.', 350, '369 Benjamin Shore', 'Port James', '71375')
('Chad Garcia', 351, '21948 Joy Green', 'Port Lukeside', '76654')
('Cody Martin', 352, '3219 Hernandez Pine Suite 596', 'West Paul', '64902')
('Donald White', 353, '89296 Mark Prairie Apt. 165', 'Matthewshire', '01340')
('Andrew Jones', 354, '233 Frank Hill Suite 096', 'Benjaminland', '45675')
('Kelsey Pham', 355, '29391 Parker Ports', 'Charlesfort', '88632')
('Bonnie Rivera', 356, '362 Daniel Hollow', 'Geraldburgh', '58995')
('Brad Owen', 357, '203 Michael Knolls Apt. 409', 'North Robert', '26525')
('Katherine Moon', 358, '315 Ryan Route', 'Wattsberg', '58654')
('Stephen Richmond', 359, '9156 Perkins Ways Suite 905', 'New Cynthiaborough', '81185')
('Marcus Davis', 360, '0243 Perez Station', 'North Laurenview', '78873')
('Michael White', 361, '96712 Karen Isle Apt. 547', 'Thomasside', '62791')
('Tanya Morton', 362, '0269 Joseph Trace Suite 843', 'Laurieberg', '09743')
('Richard Perez', 363, '69766 Reid Trafficway', 'Bellside', '07525')
('Elizabeth Anderson', 364, '2520 Amber Lock', 'Priceville', '73013')
('James Figueroa', 365, '0652 Pamela Inlet', 'North Mary', '05380')
('Crystal Davies', 366, '305 Wendy Springs Apt. 576', 'Smithshire', '25418')
('George Smith', 367, '2692 Pierce Lock Apt. 243', 'New Laceyborough', '51821')
('John Ellis', 368, '4504 Cory Crescent', 'East Whitneyhaven', '25393')
('Katie Anderson', 369, '855 Brown Viaduct Suite 469', 'Lopezstad', '12843')
('Christina Robles', 370, '460 Bell Lodge Suite 966', 'Deannaburgh', '44471')
('Charles Harrington', 371, '27430 Cortez Track Apt. 477', 'North Michelle', '15836')
('Claire Rosales', 372, '6622 Carter Rapids', 'West Richardborough', '90000')
('Tiffany Lee', 373, '1239 Kristin Alley Suite 006', 'Ivanchester', '44311')
('Kari Arroyo', 374, '036 Julie Unions', 'Stevenbury', '37304')
('Lori Martinez', 375, '1946 Hicks Crossing Apt. 786', 'Port Charles', '08581')
('Jennifer Garcia', 376, '73894 Paul Mountains Apt. 465', 'South Andre', '69299')
('Maxwell Cooper', 377, '1981 Tina Vista', 'Diazmouth', '93865')
('Andrew Thomas', 378, '44739 Samuel Manors', 'Johnsonport', '27419')
('Kayla Frederick', 379, '02347 Nash Village', 'Oconnorborough', '90743')
('Jordan Price', 380, '589 Maria Drive Suite 379', 'South Alejandro', '04690')
('Jason Figueroa', 381, '19208 Day Inlet Suite 129', 'South Brandonview', '99519')
('Crystal Flores', 382, '652 Gibson Forge', 'North Rachel', '38479')
('Laurie Hartman', 383, '99684 Karen Freeway Apt. 068', 'Port Audreybury', '52010')
('Karen Moore', 384, '39547 Anderson Alley', 'Brooksstad', '66063')
('Kevin Thomas', 385, '803 Douglas Expressway Apt. 000', 'West Paultown', '08577')
('Angela Torres', 386, '846 Jeffrey Forges Suite 604', 'Lake Crystalside', '55786')
('Anthony Hernandez', 387, '52865 Jessica Garden', 'Diazland', '24738')
('Charles Pittman', 388, '9285 Scott Course Suite 295', 'New Kennethberg', '65007')
('Ann Cline', 389, '15010 Nancy Pass Suite 388', 'Englishland', '28892')
('Nathan Mueller', 390, '34471 Robbins Burgs Apt. 265', 'New Daniel', '07118')
('Patricia Lopez', 391, '7518 Mason Hills', 'Edwardsfort', '99577')
('Alicia Powell', 392, '28814 Jessica Mountains Apt. 250', 'Paulahaven', '22931')
('Lindsey Cruz', 393, '498 King Mission Apt. 603', 'Ericfort', '10783')
('Christine Mercado', 394, '58566 Sara Vista', 'West Christopherberg', '06058')
('Tanya Alexander', 395, '945 Ronald Freeway', 'Jonathanstad', '12667')
('Joseph Dunlap', 396, '9841 Pamela Drives', 'West Larrytown', '74564')
('Anne Weber', 397, '17991 Rodriguez Island', 'South Heatherbury', '23415')
('Carolyn Leach', 398, '167 Lee Plaza', 'Lake Stephenview', '48926')
('Stephen Harris', 399, '0321 Kimberly Hills', 'North Daniel', '95614')
('Alejandro Hughes', 400, '180 Andrew Mission Suite 391', 'East Williamburgh', '04442')
('Madison Taylor', 401, '8845 Curtis Extension Suite 677', 'New Kimberly', '41177')
('Nicole Valdez', 402, '116 Andrew Key', 'Williamhaven', '24107')
('Johnny Fletcher', 403, '63028 Shannon Prairie Apt. 615', 'Stevensstad', '69092')
('Michael Ali', 404, '327 Mitchell Road', 'Lake Jessicafurt', '08639')
('Adriana Hudson', 405, '8696 Johnson Villages Suite 331', 'North Margaret', '19871')
('Tony West', 406, '1112 Valerie Manors Suite 524', 'Lake Joseph', '06449')
('Victoria Powers', 407, '4567 Jenkins Points Suite 720', 'Port Carol', '42922')
('Jennifer Adams', 408, '673 Singleton Plains', 'Scottbury', '93302')
('Kathryn Anderson', 409, '67554 Noah Vista', 'Robertmouth', '65105')
('Johnny Green', 410, '1380 Jade Meadows Apt. 933', 'Lake Angelicatown', '83007')
('David Craig', 411, '28651 Michael Plaza', 'Dylanborough', '27664')
('Sara Bennett', 412, '433 Short Points', 'North Courtney', '97031')
('Shawn Clark', 413, '9270 Tonya Fords Suite 013', 'South Elizabeth', '89906')
('Nicole Hansen', 414, '20128 Johnson Haven', 'Smithside', '66134')
('Melissa Hoffman', 415, '3259 Ramirez Inlet Apt. 343', 'South Christopherfurt', '92890')
('Casey Olson', 416, '7201 Lauren Rest', 'New Kara', '57806')
('Christine Gonzales', 417, '670 Bishop Rue Suite 522', 'South Jessicaborough', '02132')
('Shelby Townsend', 418, '18761 Huff Forges Apt. 358', 'New Chrismouth', '41986')
('Justin Moran', 419, '8345 Lopez Crossing', 'Reneeberg', '03184')
('Donna Taylor', 420, '84229 Christine Fall', 'Timview', '69322')
('Russell Wood', 421, '57117 Smith Plains', 'Walkerhaven', '88889')
('Ethan Tran', 422, '72129 Ebony Expressway', 'New Jacobborough', '07587')
('David Lucero', 423, '6691 Bender Villages', 'Janiceside', '34087')
('Matthew Wise', 424, '83167 Ballard Crest', 'New Melody', '64140')
('Sara Newman', 425, '8169 Vance Ports', 'West Robert', '17992')
('Melinda Kemp', 426, '281 Kristina Valley Apt. 913', 'Cooleytown', '37078')
('Katie Schmidt', 427, '3483 Green Corners Apt. 902', 'East Beverlyhaven', '63388')
('Stephen Carter', 428, '0793 Brittany Drive', 'Campbellfurt', '68492')
('Dana Keller', 429, '1541 Wilson Wall', 'Coreyside', '74952')
('Tracy Harris', 430, '2371 Griffin Knolls', 'Michelleport', '73669')
('Patricia Bass', 431, '632 Thomas Valleys Apt. 319', 'Mcclurestad', '11834')
('Gary Sanders', 432, '77747 Hunt Summit', 'New Jacob', '65694')
('Jacob Lee', 433, '1751 Jennifer Way', 'East Aaron', '69698')
('Maurice Romero', 434, '84097 Wendy Bypass Suite 072', 'Chavezmouth', '18805')
('April Boyd', 435, '0018 Erika Extension Apt. 196', 'West Cherylside', '15675')
('Isaac Valenzuela', 436, '0396 Andrew Island Suite 411', 'Priceborough', '37996')
('Emily Greene', 437, '74620 Grant Plain Apt. 398', 'East Daniel', '87139')
('Brandon Hernandez', 438, '9342 Mooney Parkways', 'Vazquezmouth', '36817')
('Patricia Kelley', 439, '3053 Catherine Mills Apt. 322', 'South Kristiton', '10774')
('Deborah Farmer', 440, '0125 Knapp Pines', 'Robinsonberg', '62163')
('Suzanne Williams', 441, '343 Joshua Place Apt. 624', 'South Nicoleside', '13544')
('Robert Cook', 442, '7030 Kendra Viaduct Suite 889', 'New Jasmine', '38619')
('Amy Barnes', 443, '8071 George Greens', 'Danielshire', '02289')
('Dylan Mitchell Jr.', 444, '03661 Jessica Cliffs Apt. 722', 'Lake Eddieview', '54594')
('Courtney Reynolds', 445, '42800 Robinson Mission', 'New Erinfort', '45382')
('Paula Garrison', 446, '1332 Owen Isle Apt. 623', 'Kennethshire', '35935')
('Sara Newton', 447, '19014 Tina Light', 'North Miranda', '73647')
('Thomas Young', 448, '53195 James Via Suite 013', 'East Nicoletown', '27430')
('Gregory King', 449, '9621 Walters Ranch', 'East Pamelahaven', '15588')
('Shawn Floyd', 450, '435 Barrett Drive', 'East Austinville', '35241')
('Virginia Collins', 451, '9447 Jason Pine Apt. 478', 'Amandafurt', '82413')
('Carrie Fisher', 452, '884 Anthony Manors', 'South Mary', '14249')
('Tammy Rogers', 453, '485 Hansen Trafficway Suite 628', 'Hamptonfurt', '95703')
('Sarah Bishop', 454, '74982 Gonzales Cliff Apt. 616', 'New Josephhaven', '51216')
('Drew Miller', 455, '224 Kristy Alley', 'Phamfurt', '06034')
('Charles Scott', 456, '414 Morris Isle', 'Morrisshire', '72087')
('Shane Cuevas', 457, '79785 Hudson Radial', 'West Amber', '19088')
('Justin Tran', 458, '74987 Nancy Isle Suite 800', 'Hannahchester', '40750')
('Alexandra Buchanan', 459, '59150 Michele Fork', 'South Melissatown', '20044')
('Sue Nelson', 460, '9213 Kenneth Glens Apt. 574', 'Jacksonberg', '20517')
('Robert Carter', 461, '125 Wilson Turnpike', 'North Alicia', '25288')
('Cole Reyes', 462, '7694 Wong Knoll Apt. 530', 'Lanebury', '16823')
('Patricia Poole', 463, '724 Romero Plaza', 'North Ryan', '85811')
('Walter Richards', 464, '254 Fischer Crossroad', 'Collinsstad', '53004')
('Tina Harris', 465, '49589 Abigail Parkways Apt. 525', 'West Lindsay', '71197')
('Russell Rodriguez', 466, '13180 Petty Springs Suite 696', 'Lake James', '84280')
('Raymond Bruce', 467, '3471 Joseph Ports Suite 952', 'Stacyburgh', '02992')
('Cassandra Williams', 468, '963 Edwards Plain', 'Jennaport', '29088')
('Margaret Mckay', 469, '84511 Jacqueline Island', 'Stevensonhaven', '31581')
('Patricia Ellison', 470, '0896 Alvarado Cliffs', 'East Ryanmouth', '21650')
('Sharon Townsend', 471, '60209 Jose Mission', 'South Jessicabury', '78345')
('Angelica Richardson', 472, '8928 Justin Meadows', 'North Thomastown', '08627')
('Jennifer Wilkins', 473, '3521 Justin Highway', 'Selenaburgh', '04845')
('Katherine Hammond', 474, '254 Victor Spur', 'Destinyport', '75703')
('Douglas Nelson', 475, '195 Frank Key Apt. 915', 'Johnmouth', '76200')
('Jennifer Bender', 476, '77834 Williams Pike Apt. 562', 'New Jennifer', '27533')
('Jamie Byrd', 477, '754 Gonzalez Course', 'Barbaratown', '22335')
('Adam Campbell', 478, '406 Rios Field', 'Alexanderburgh', '28564')
('Peter Mccann', 479, '86003 Cory Ford', 'Chavezmouth', '72945')
('Francisco Harding', 480, '8594 Burton Lights', 'North Scott', '60810')
('Caitlin Warner', 481, '263 Clayton Course Suite 084', 'North Annfort', '61838')
('Linda Barrett', 482, '6555 Harris Track', 'Lake Edward', '10014')
('Kenneth Hamilton', 483, '525 Erik Road', 'Lake Isaacshire', '88182')
('Alan Phillips', 484, '80227 Matthew Mountains Apt. 393', 'Johnsonton', '84852')
('Deborah Baker', 485, '336 Howard Shoals Apt. 561', 'Davidfurt', '79515')
('George Taylor', 486, '207 Amy View Apt. 124', 'Christopherton', '29001')
('Jared Johnson', 487, '8999 Kent Glen Apt. 007', 'South Kristen', '91712')
('Rebecca West', 488, '575 Kaitlin Lights Apt. 969', 'East Stacy', '14204')
('Zachary Schultz', 489, '191 Brooks Squares Apt. 319', 'Lake Kevinville', '25690')
('Connor Romero', 490, '917 Keith Islands', 'South Russell', '98166')
('Michael Medina', 491, '3210 Fowler Village Apt. 189', 'Reynoldsport', '71796')
('Beth Hardin', 492, '355 Jo Meadows', 'Port Cody', '91067')
('Shawn Carter', 493, '0995 Jason Park Apt. 131', 'Port Richard', '47412')
('Joanna Robinson', 494, '04636 Michael Highway Suite 203', 'Nicolechester', '17868')
('Emily Walker', 495, '74913 James Vista Apt. 958', 'Port Anthony', '95958')
('Christopher Luna', 496, '1975 Hunt Parkway', 'Howellfurt', '09968')
('Karla White', 497, '1600 Elizabeth Wall Apt. 102', 'Flowersberg', '81536')
('David Weiss', 498, '7563 Brian Passage Suite 698', 'Port Tiffanystad', '54772')
('Brittany Mcdowell', 499, '479 Robinson Mission Apt. 317', 'New Donna', '16460')
('Phillip Spencer', 500, '895 Moore Summit', 'Lake Eric', '31393')
('Shelly Sanchez', 501, '94619 Debra Parkways', 'New Billy', '20673')
('Grant Yoder', 502, '7006 Fuller Viaduct Suite 101', 'Jamesmouth', '49906')
('Bonnie Lewis', 503, '3522 Roberts Fall Apt. 895', 'Hinesstad', '82713')
('Katie Hunt', 504, '87691 Villarreal Vista Apt. 179', 'South Michaelfort', '07982')
('Justin Frazier', 505, '335 Kirby Coves Suite 653', 'New Alec', '18555')
('Michelle Pearson', 506, '8291 Debra Skyway', 'West Bonnie', '11679')
('Tina Mayer', 507, '2395 Horn Key', 'East Austin', '27608')
('Christine Malone', 508, '986 Howell Lake', 'East Cristinamouth', '09766')
('Karen Wade', 509, '86001 Omar Terrace Apt. 172', 'New Brooke', '35219')
('Kevin Murphy', 510, '605 Bauer Hills Suite 410', 'Jennifermouth', '94362')
('Kerri Garcia', 511, '93992 Mcdonald Crossroad', 'New Sabrinaview', '93039')
('Wendy Woodard', 512, '1301 Williams Vista', 'New Sharon', '83425')
('Laura Jackson', 513, '149 Amy Plain', 'New John', '61776')
('Wyatt Rice', 514, '972 Jennifer Court', 'Klineshire', '90059')
('Rebecca Byrd', 515, '7661 Leah Fields Suite 132', 'North Melissaville', '86526')
('Nicholas Ferguson', 516, '94653 Erica Fort', 'Ericville', '75238')
('James Palmer', 517, '260 Carol Lake Suite 971', 'East Kara', '72817')
('Tammy Turner', 518, '8014 Dawson Circle', 'North Tonyatown', '99531')
('Shannon Edwards', 519, '2301 Harris Prairie', 'Dorseystad', '89329')
('Peter Robertson', 520, '5198 Porter Extension', 'Hensleyview', '15816')
('Kelly Harrison', 521, '084 Thompson Shoals Suite 113', 'Mcconnellview', '08462')
('Jerry Ellis', 522, '082 Hamilton Mills', 'Johnsonhaven', '84801')
('Kevin White', 523, '45782 Jennifer Unions', 'Port Leah', '59051')
('Kelli Contreras', 524, '61186 Angela Centers', 'Ryanport', '54101')
('Mr. William Martinez', 525, '3568 Rodriguez Pines', 'Lake Julialand', '15105')
('Nancy Johnston', 526, '29770 Adam Gardens Apt. 482', 'Whiteberg', '23210')
('Richard Kelley', 527, '259 Fox Mill', 'Mezaton', '89248')
('Dustin Shelton', 528, '6759 Breanna Curve Apt. 244', 'Raymondview', '80773')
('Crystal Pacheco', 529, '75780 Jackson Springs', 'Jonesfurt', '55671')
('Jennifer Riley', 530, '69017 Long Points', 'Amandaland', '23843')
('Hannah May', 531, '778 Paul Brooks Suite 730', 'Davisborough', '10833')
('Jade Weaver', 532, '9237 Gabriela Ramp', 'Sandraborough', '23026')
('Kevin Moore', 533, '91591 Smith Rue', 'Dianamouth', '36644')
('Laura James', 534, '188 David Street Apt. 873', 'North Eric', '53479')
('Ashley Sanchez', 535, '92029 Christopher Crossing', 'Bridgesshire', '65022')
('Sylvia Potter', 536, '662 Jerry Islands', 'Fletcherville', '24093')
('Ronald Figueroa', 537, '0012 Tyler Villages', 'Timothyville', '60853')
('Michael Robinson', 538, '322 Ian Road Suite 616', 'Wangville', '10509')
('Jacob Green', 539, '00599 Fleming Branch', 'Victorstad', '21290')
('Jonathan Griffin', 540, '579 Andrew Spur Apt. 246', 'New Barbarachester', '12217')
('Matthew Bell', 541, '65781 Walton Cliffs Suite 053', 'Rebeccahaven', '04021')
('Miranda Cain', 542, '05493 Diaz Stravenue', 'Andrewstown', '71263')
('Brian Vasquez', 543, '84864 Moore Fords', 'Lake Brenda', '79667')
('Ronald Newton', 544, '63372 John Center Suite 206', 'East Laura', '23186')
('Jacob Hansen', 545, '8496 Kevin Camp', 'Moorefurt', '96841')
('Krystal Mcmahon', 546, '178 Brandon Forks', 'Port Jordan', '54636')
('Maria Munoz', 547, '483 Sean Crest Suite 064', 'Vargasburgh', '89978')
('Mr. Brandon Dennis MD', 548, '9925 Brown Unions Suite 053', 'Hardymouth', '26783')
('Tim Wood', 549, '3838 Young Grove Apt. 172', 'Brownborough', '04559')
('Jamie Ross', 550, '197 Smith Crossroad Apt. 660', 'West Taylor', '54208')
('Kathy Spence', 551, '693 Taylor Vista', 'West Lynnland', '07965')
('Heidi Smith', 552, '6159 Smith Islands Suite 835', 'Sandovalview', '94551')
('Stephanie Hall', 553, '95839 Cohen Mountains', 'Chavezland', '85250')
('Amy Richmond', 554, '3227 Craig Plain Apt. 456', 'Lake Anntown', '40576')
('Sarah Johnson', 555, '4020 Deleon Crossroad Apt. 010', 'Sanchezport', '23036')
('Thomas Smith', 556, '81994 Amanda Point Apt. 933', 'Deborahview', '00850')
('Casey Lyons', 557, '62949 John Cape Suite 006', 'Porterbury', '29578')
('Marissa Buck', 558, '47060 Mary Rest Apt. 867', 'Lake Michelle', '05622')
('Crystal Flores', 559, '96374 Samuel Ways Apt. 921', 'Martinfort', '90729')
('Laura Hunt', 560, '55481 Burns Crescent', 'Port Molly', '69275')
('Karen Ward', 561, '827 Perez Run', 'Port Maria', '98529')
('Gerald Johnson', 562, '595 Karen Pass', 'Barnesstad', '13460')
('Rebecca Baker', 563, '3241 Janice Knolls Suite 548', 'Silvafurt', '83868')
('Mason Mooney', 564, '2294 Kelly Keys Apt. 184', 'New Walterberg', '06168')
('Cody Mills', 565, '9438 Michael Park Apt. 055', 'Ronaldberg', '89706')
('Olivia Hensley', 566, '9105 Tammy Parkway Suite 705', 'Austinshire', '61036')
('Norman Jones', 567, '290 Green Lakes Apt. 076', 'South Morgan', '58898')
('Darren Rodriguez', 568, '063 Taylor Cliffs', 'West Alicia', '99536')
('Candace Davis', 569, '076 Wilson Grove Apt. 954', 'Sandraton', '70072')
('Brooke Davis', 570, '4548 Lopez Vista', 'North Debbiemouth', '99452')
('Stephanie Hall', 571, '5538 Swanson Spurs', 'Fishermouth', '79150')
('Brian Smith', 572, '25911 Harris Forges', 'Donnachester', '03940')
('Dale Wallace', 573, '3313 Sandoval Trace Apt. 268', 'Bakershire', '10069')
('Kimberly Ruiz', 574, '077 Morgan Branch', 'Deannachester', '67161')
('Monica Kelly', 575, '046 Steele Ferry', 'Sanchezport', '43928')
('Charles Dennis', 576, '35741 Hoffman Brook', 'North Tara', '51694')
('Jenny Kennedy', 577, '36003 Hill Brooks Suite 565', 'North Tiffanyville', '26457')
('Alicia Walker', 578, '1786 Sandra Camp', 'Port Michael', '69822')
('Robert Bass', 579, '9501 Welch Ville Apt. 446', 'East Brookeport', '36375')
('Sarah Ware', 580, '39707 Thompson Viaduct', 'South Johnport', '03387')
('Christina Franco', 581, '59052 Timothy Motorway', 'Jesseburgh', '49674')
('Benjamin Wright', 582, '713 Melissa Tunnel Suite 843', 'Elaineside', '94771')
('Nicholas Gomez', 583, '0811 Nunez Gateway', 'Webstertown', '90442')
('Brian Russell', 584, '4266 Melanie Greens Apt. 293', 'Port Vanessa', '27783')
('Nicole Hartman', 585, '124 Cheryl Port', 'East Jaime', '94012')
('Bruce Greene', 586, '95028 Jones Keys Apt. 769', 'West Thomasside', '26790')
('Kim Waters', 587, '2739 Yates Cliff', 'Port Frederick', '36298')
('Marie Freeman', 588, '38560 Davis Springs Suite 678', 'Port Bobbyton', '51393')
('Jennifer Harris', 589, '0390 Henson Garden Apt. 465', 'North Christina', '07538')
('Matthew Johnson', 590, '768 Angela Mountain Apt. 610', 'Markside', '65497')
('Rachel Barton', 591, '56027 Brenda Club Suite 897', 'Port Carlabury', '19889')
('Kevin Sanders', 592, '364 Sanchez Stravenue Suite 250', 'Lake Monicaview', '89378')
('Crystal Lee', 593, '57368 David Course', 'Kristenstad', '21640')
('Andrea Johnson', 594, '36607 Denise Skyway', 'Port Kellyshire', '44891')
('Shari Singleton', 595, '42978 Ricky Light', 'Parkerfort', '48846')
('Michael Carpenter', 596, '0820 Velez Bypass Apt. 017', 'New Robert', '69917')
('Jacob Weiss', 597, '65019 Stevens Forge Suite 085', 'Thomasport', '04513')
('Anthony Colon', 598, '3956 Stewart Manors', 'Port William', '72352')
('Glen Wallace', 599, '43168 Caroline Junction', 'North Lorettachester', '68886')
('Vincent King', 600, '2381 Bonilla Skyway Suite 192', 'Christensenchester', '32768')
('Tara Mullins', 601, '707 Amy Ranch', 'Jamieshire', '98248')
('Alan Anderson', 602, '7345 Gonzales Brooks', 'New Stephen', '08728')
('Benjamin Leach', 603, '9013 Corey Well Suite 560', 'Lauratown', '14501')
('Paul Parks', 604, '2176 Elizabeth Burgs Suite 648', 'Mooreport', '26109')
('Robert Lambert', 605, '83310 Gordon Cliffs Suite 885', 'Cookstad', '06110')
('Terry Ortiz', 606, '19482 Martin Points', 'Port Brandybury', '90372')
('Michael Bowen', 607, '77730 Jason Views', 'Meltonstad', '44367')
('Brianna Ali', 608, '9007 Henderson Manor', 'Lake Andrewberg', '71893')
('Andrew Smith', 609, '69164 Price Parks Apt. 113', 'East Edwintown', '53407')
('Chad Perez', 610, '9163 Jessica Circle', 'Port Nathanshire', '32530')
('Kenneth Singh', 611, '927 Davis Junctions', 'Heathertown', '86401')
('Christine Brown', 612, '839 Holmes Stravenue', 'South Katie', '64140')
('Paul Davis', 613, '9504 Ramirez Squares Suite 613', 'New David', '08548')
('Brenda Randolph', 614, '389 Patrick Pine Suite 768', 'West Perry', '90598')
('Jennifer Jacobs', 615, '98877 Myers Path', 'North Sarah', '69711')
('Kendra Lambert', 616, '45601 King Crest', 'West David', '64155')
('Amanda Barajas', 617, '52433 Valerie Meadows', 'Romerohaven', '49967')
('Logan Holmes', 618, '0103 Proctor Hills', 'West Justinstad', '63089')
('Samantha Escobar', 619, '81833 Christopher Mount Suite 747', 'Heatherberg', '62972')
('Kevin King', 620, '68091 Brown Pike', 'Port Shawn', '80520')
('Donald Morales', 621, '58709 Wayne Locks Suite 031', 'Carterland', '99851')
('Rebekah Phillips', 622, '47428 Mason Rapid Suite 794', 'Jonathanfort', '97618')
('Jason Harris', 623, '4045 William Shores', 'Port Joelville', '21252')
('Lisa Washington', 624, '13727 Rodriguez Turnpike', 'East Michaeltown', '68049')
('Grace Chang', 625, '22016 Robin Meadow', 'East Christianside', '85534')
('Lori Zuniga', 626, '316 Stephanie Highway Apt. 158', 'Allenton', '04681')
('James Young', 627, '230 Jason Prairie', 'Jamieborough', '41795')
('Eric Gilmore', 628, '8329 Peters Coves Apt. 999', 'Lake Ryan', '81375')
('Ryan Palmer', 629, '617 Christina Burgs Suite 146', 'Johnbury', '62475')
('Scott Garcia', 630, '517 Philip Manors Suite 110', 'Heatherport', '06648')
('Jeffrey Chase', 631, '150 Molina Mall Suite 489', 'Lake Lukeport', '30069')
('Kayla Banks', 632, '58065 Linda Village', 'North Michael', '17913')
('Jason Davidson', 633, '59843 Walker Landing Apt. 889', 'Perezstad', '18873')
('Brian Gross', 634, '9696 West Lodge', 'West Kelly', '22651')
('James Hill', 635, '8702 Long Mews', 'Lake Gregoryview', '44059')
('Richard Hinton', 636, '333 Harris Street', 'North Jennifertown', '76276')
('Dominic Smith', 637, '8376 Bailey Mews Suite 906', 'Tylerburgh', '79434')
('Edwin Gilbert', 638, '49385 Ford Springs Apt. 144', 'North Maryfurt', '55486')
('Christopher Mclaughlin', 639, '357 Jones Terrace', 'North Michealland', '21025')
('Connie Day', 640, '806 Alison View Suite 973', 'West Danielmouth', '30844')
('David Gray', 641, '5354 Johnson Orchard Apt. 291', 'Port Courtneyborough', '20048')
('Nancy Garner', 642, '548 Dawn Keys', 'Boothbury', '64866')
('Michael Coleman', 643, '7142 Julie Dale Suite 367', 'East Michaelport', '52353')
('Stacy Sparks', 644, '1943 Kristen Turnpike Apt. 790', 'Warnermouth', '39665')
('Joshua Lewis', 645, '75068 Janice Lights', 'Michaelville', '28021')
('Daniel Watson', 646, '61535 Kyle Islands Suite 766', 'Lake Joseshire', '85763')
('Jeffrey Davis', 647, '525 Jones Parkways', 'Laurenmouth', '92030')
('Susan Miller', 648, '42888 Thompson Mountains', 'Wangchester', '64670')
('Angela Davis', 649, '7345 Carlos Place', 'Lake Amberborough', '82361')
('James Lang', 650, '336 Dodson Drives Suite 751', 'West Dianeland', '62045')
('Wyatt Reyes', 651, '1176 Martinez Rest', 'Nataliefort', '59801')
('Jeff Walker', 652, '288 Thompson Plain', 'Jillland', '02933')
('Michael Yu', 653, '57154 Derek Shoals', 'Laurieview', '92933')
('Dawn Savage', 654, '97679 Spencer Camp Apt. 363', 'Emilyton', '85745')
('Jamie Torres', 655, '403 Martin Throughway Suite 246', 'Davidtown', '54694')
('John Brown', 656, '96242 Pamela Route', 'Turnerland', '59335')
('Michael Brown', 657, '13653 Clayton Parkway Suite 833', 'South Victortown', '81601')
('Robert Hansen', 658, '271 Reese Burg', 'Zacharyborough', '45622')
('Christopher Mclaughlin', 659, '3653 Mccall Forest', 'Lake Suzanneberg', '15485')
('Rachel Aguilar', 660, '67668 Harry Port Apt. 765', 'East Shannon', '31969')
('Julie Wiley', 661, '9443 Day Rapids', 'Port Gina', '99562')
('Christopher Christensen', 662, '15483 Peter Well Suite 816', 'Andersonchester', '20824')
('Beth Ross', 663, '11428 Beth Square Apt. 226', 'Lauriefort', '43125')
('Karen Leon', 664, '622 Mary Pines Apt. 648', 'Onealport', '90912')
('Kenneth Davenport', 665, '6429 Ashley Mountains Apt. 913', 'Dennisfort', '98703')
('Samantha Parsons', 666, '0295 Rachel Wells Apt. 897', 'Port Brittanyville', '92379')
('Dawn Farmer', 667, '87543 Nelson Squares Suite 612', 'East Larry', '10517')
('Rebecca Schmidt', 668, '2657 Harmon Squares Suite 179', 'Mejiaberg', '85628')
('Morgan Garrett', 669, '10803 Craig Glens', 'New Sylviatown', '34820')
('Kaitlin Tucker', 670, '54057 Margaret Land', 'New Randallborough', '35824')
('Matthew Mcdaniel', 671, '087 Espinoza Mountain', 'Amandachester', '52873')
('Ann Coleman', 672, '559 Anthony Burg Apt. 712', 'Garyview', '49015')
('Christopher Davis', 673, '951 Frank Vista Suite 801', 'East Deborahshire', '82803')
('Michelle Rodriguez MD', 674, '639 Amanda Mews', 'West Markchester', '05708')
('Micheal Howell', 675, '4843 Bailey Way Apt. 410', 'Sanchezberg', '67682')
('Tammy Watkins', 676, '854 Patricia Overpass Suite 573', 'Moniquefurt', '86972')
('Justin Mays', 677, '3150 Cory Wall Apt. 150', 'Josephfort', '67870')
('Darren Jackson', 678, '77684 Janet Field Apt. 396', 'Davidland', '29981')
('Heather Wade', 679, '8072 Amanda Viaduct', 'Pooleberg', '71822')
('Caroline Wright', 680, '0946 Collins Extensions Suite 130', 'North Annafurt', '46005')
('Leslie Perry', 681, '89349 Long Ramp', 'New Ronaldmouth', '55525')
('Amanda Taylor', 682, '1189 Sullivan Trail', 'Jonesberg', '03370')
('Shane Miles', 683, '24852 Jillian Forges Apt. 037', 'Tammyland', '63492')
('Keith Fox', 684, '2771 Jason Glens', 'Patriciaton', '47977')
('Mark Barron', 685, '72487 Lopez Skyway', 'New Richard', '08324')
('Alice Reilly', 686, '9356 Glover Vista', 'Wallaceberg', '67828')
('Steven Campbell', 687, '9391 Jocelyn Overpass Apt. 030', 'East Maryfort', '10265')
('Ryan Johnson', 688, '851 Carrie Port', 'North Kennethfort', '31556')
('Victor Morrison', 689, '020 Donald Grove Apt. 845', 'North Matthew', '30754')
('Tracy Vargas', 690, '52520 Jack View Apt. 094', 'East Andrewview', '89295')
('Anthony Hurley', 691, '5159 Page Viaduct Suite 584', 'Walkerberg', '31696')
('Elizabeth Thompson', 692, '995 Johnson Drives Apt. 492', 'Shannonside', '87384')
('Kevin Williams', 693, '735 Kelsey Mountain', 'West Wendystad', '24253')
('Kimberly Kim', 694, '030 Acosta Glen Suite 122', 'Port Lauraburgh', '41760')
('Patty Howell', 695, '005 Smith Lane', 'Duncanview', '28947')
('Lauren Skinner', 696, '389 Wagner Isle Apt. 534', 'Hillland', '60542')
('Jason Mills', 697, '133 Rodriguez Wall', 'East Angela', '45967')
('Susan Oneal', 698, '5829 Jessica Place Apt. 961', 'Riversfurt', '61227')
('Tara Jones', 699, '706 Hill Courts', 'East Loriton', '62050')
('Dawn Collins', 700, '93683 Lam Plaza Suite 627', 'East Jenniferview', '36072')
('Carol Hodges', 701, '9136 Julie Run', 'Stewartmouth', '88158')
('Joseph Torres', 702, '126 Henry Mills Suite 770', 'Matthewburgh', '91803')
('Brenda Camacho', 703, '615 Nicole Mills Suite 565', 'West Donaldmouth', '24163')
('Jennifer Hartman', 704, '782 Brittany Locks', 'Matthewsshire', '62155')
('Brian Daniels', 705, '154 Molly Plain', 'Mathiston', '24740')
('Stephanie Miller', 706, '61751 Figueroa Isle Suite 295', 'Olsonhaven', '14877')
('Timothy Jackson', 707, '3654 Cynthia Circle Suite 474', 'Brendaberg', '40315')
('Dawn Jennings', 708, '44281 John Manors Apt. 395', 'North Angelaview', '89746')
('Bill Schmidt', 709, '380 Johnson Forest Apt. 536', 'Lake Kiarabury', '86899')
('John Gibson', 710, '40948 Park Oval Suite 505', 'Scottbury', '03243')
('Scott Larsen', 711, '62824 Thomas Vista', 'Jensenside', '37133')
('Melinda Holmes', 712, '0272 Marshall Fork', 'West Aprilmouth', '48325')
('Aaron Phillips', 713, '320 Samantha Mill', 'Natashafort', '69094')
('Joseph Reid', 714, '41336 Vickie Turnpike', 'East Ronaldville', '71577')
('Natasha Elliott', 715, '20430 Adams Square', 'Victoriaside', '33496')
('Garrett Jenkins', 716, '4340 Jeffrey Point Suite 363', 'Lake Bradley', '78115')
('Mr. Michael Craig PhD', 717, '25639 Kimberly Ranch', 'Port Jessicabury', '78614')
('Danielle Hall', 718, '935 Daniel Tunnel', 'Lake Meganport', '01402')
('Eric Hood', 719, '5543 Wagner Mall', 'South Lisaville', '98288')
('Steven Mitchell', 720, '513 Ryan Parkway Apt. 936', 'East Gina', '94739')
('Jennifer Johnson', 721, '80110 Smith Cape', 'South Michelleville', '44127')
('Joseph White', 722, '06699 Odonnell Gateway Apt. 957', 'New Kaylabury', '29640')
('Kenneth Archer V', 723, '95374 Gregory Plains Suite 181', 'Cynthiaview', '47977')
('Amanda Mcbride', 724, '2517 Charlotte Groves Apt. 348', 'South Paula', '20175')
('Jeffrey Davis', 725, '8351 Green Villages', 'Bettytown', '52835')
('Charles Moore', 726, '66604 Courtney Parkway', 'Heatherchester', '34569')
('Lauren Davis', 727, '700 Brett Villages Apt. 634', 'New Jimmyhaven', '14969')
('Andrea Miller', 728, '60493 Ryan Lakes Apt. 512', 'Riveramouth', '50349')
('Gary Gray', 729, '9565 Johnathan Mountains Apt. 519', 'South Brianbury', '18577')
('Mark Hubbard', 730, '900 Kayla Meadows Apt. 702', 'Cuevasshire', '45932')
('Daniel Baker', 731, '7343 Diaz Drive', 'Wardfort', '14148')
('Dustin Hodges', 732, '89468 Nicholas Tunnel Suite 939', 'Barrerafurt', '48556')
('William Allen', 733, '759 Mike Gardens Suite 287', 'West Carolbury', '92596')
('David Knox', 734, '548 Eddie Centers Suite 021', 'Dudleymouth', '28987')
('Ivan Gardner', 735, '20021 Mark Drive', 'Lake Danielstad', '35840')
('Donna Jackson', 736, '243 Gallegos Ridge Apt. 035', 'East Mark', '08535')
('John Robinson', 737, '62633 Allen View', 'East Laurenbury', '18142')
('Timothy Smith DDS', 738, '52501 Anthony Route Apt. 270', 'East Michaelchester', '22744')
('Yolanda Mcguire', 739, '50730 Olivia Mountain', 'North Brianbury', '19403')
('Kelli Delacruz', 740, '4037 Alyssa Trail Apt. 617', 'Lake Eric', '44138')
('Jennifer Gordon', 741, '5190 Luis Hill', 'Lake Kylehaven', '39552')
('Jeanette Patel', 742, '5815 Ryan Estates', 'Smithport', '96982')
('Adrienne Jones', 743, '4429 Miranda Heights Suite 028', 'Davidville', '56250')
('Mrs. Allison Donaldson DDS', 744, '42826 Anderson Junction', 'Mariahaven', '50690')
('Brian Matthews', 745, '2930 Smith Harbor', 'Candiceberg', '31719')
('Hannah Thompson', 746, '8863 Nichols Courts Apt. 925', 'Lake Willieborough', '53645')
('Robert Burnett', 747, '1325 Jessica Shores', 'North Kellyton', '50301')
('Brett Sullivan', 748, '6540 James Ridge Apt. 186', 'North Rickymouth', '51820')
('Whitney Hays', 749, '51033 Kristen Cliffs Suite 797', 'East Brianburgh', '23368')
('Nicole Thompson', 750, '1086 Jacob Fords', 'Michaelstad', '93752')
('Steven Holt', 751, '668 Mary Trace Suite 471', 'Port Keithstad', '51512')
('Mrs. Stacy Ortiz', 752, '26090 Kennedy Tunnel Suite 018', 'New Isaachaven', '35708')
('Jennifer Hubbard', 753, '40320 Hernandez Summit', 'Christianstad', '37256')
('Jamie Jones', 754, '800 Andrea Mountains Apt. 766', 'Lake Brooke', '96275')
('Cheryl Rogers', 755, '8262 Ashley Extension Suite 560', 'Brittanychester', '51287')
('Jeffrey Woods', 756, '09958 Harrison Corners', 'Hobbsside', '64019')
('Keith Sims', 757, '84505 Randall Lodge Apt. 620', 'East Amanda', '10305')
('Omar Li', 758, '56262 Fry Key', 'Lake Janetton', '82517')
('Beth Shah', 759, '228 Rodriguez Shores', 'Morganmouth', '45680')
('Ms. Nicole Garcia', 760, '370 Newton Lodge Suite 408', 'Port Travisborough', '23858')
('Ryan Cunningham', 761, '29734 Mitchell Haven', 'Michaelview', '08449')
('William Knapp', 762, '725 Wells Mountain Apt. 912', 'Waltersport', '45613')
('Ryan Thomas', 763, '39419 Parsons Unions Suite 337', 'Lake Angelafort', '91273')
('Jocelyn Yates', 764, '48095 Hanson Hill Apt. 171', 'Lake Adam', '69945')
('Melanie Oneal', 765, '212 John Fork Apt. 795', 'Owensborough', '82230')
('Steven Diaz', 766, '9565 Thomas Club Suite 762', 'Jamesborough', '94424')
('William Hill DDS', 767, '962 Walker Springs', 'Lisaside', '69248')
('Andrew Patton', 768, '256 Joan Inlet', 'Webbville', '40721')
('Lauren Jackson', 769, '84947 Karen Loop Apt. 522', 'Ambershire', '09792')
('Theresa Giles', 770, '4742 David Gateway', 'Lake Christopher', '03645')
('Michael Parrish', 771, '5974 Victoria Overpass Suite 648', 'New Samanthaland', '46179')
('Michael Moore', 772, '5987 Steve Skyway', 'Heatherchester', '88761')
('Joel Benson', 773, '09893 David Drives Apt. 857', 'West Jeanette', '85967')
('Jeffrey Morales', 774, '36686 Holmes Glen', 'Ginafurt', '51098')
('George Leon', 775, '70601 Thompson Crossroad', 'Lake Ashley', '30097')
('Barbara Hill', 776, '444 Emma Ranch', 'Kevinside', '48921')
('Marie Marshall', 777, '72101 Adam Spurs Apt. 331', 'Danielleton', '63199')
('Mario Little DDS', 778, '6787 Christina Cove Apt. 074', 'Ibarrafurt', '02011')
('Diana Conley', 779, '695 Buchanan Locks Suite 833', 'East Brent', '74471')
('Brendan Johnson', 780, '284 Hill Prairie Suite 800', 'Leefort', '21326')
('Dylan Price', 781, '718 Garcia Hills', 'Port Joseph', '36115')
('Keith Ramirez', 782, '125 Ramirez Station Apt. 273', 'Port Jeffreyberg', '18475')
('Jennifer Todd', 783, '448 Hudson Park', 'West Michaelborough', '97476')
('Robert Rivera', 784, '515 Moreno Skyway Suite 643', 'Michaelside', '39841')
('Mr. David Thomas DDS', 785, '8051 Nicole Pines', 'Scottborough', '56049')
('Amanda Mueller', 786, '71610 Marks Plaza Suite 675', 'Ramosville', '99830')
('Teresa Jones', 787, '625 Benjamin Divide', 'North Andreastad', '75292')
('Eric Malone', 788, '732 Emily Heights Apt. 665', 'Port Paul', '05208')
('Jacob Osborn', 789, '1098 Roberto Green', 'Morganchester', '24088')
('Dennis Sullivan', 790, '717 Malone Springs', 'New Anthonyview', '21527')
('Julie Durham', 791, '08442 Gonzalez Walks', 'Port Brittneyside', '62754')
('Nathan Watson Jr.', 792, '267 Giles Summit Apt. 346', 'Kerrland', '13624')
('Charles Brown', 793, '6099 Erika Tunnel Suite 613', 'Jamieshire', '46116')
('Nicolas Ward', 794, '42455 Cynthia Freeway Suite 707', 'West Charlesburgh', '56873')
('Paul Bridges', 795, '69749 Nicole Plains', 'Karachester', '80941')
('Emily Cole', 796, '8993 Espinoza Lodge', 'West Rachelton', '09504')
('Adrian Smith', 797, '107 Stone Groves Suite 524', 'West Billfurt', '10340')
('Vanessa Bryant', 798, '6433 James Hollow Suite 348', 'New Stephanieborough', '43564')
('Stephen Cook', 799, '7782 Ramirez Lane', 'Sawyermouth', '82461')
('Joyce Richardson', 800, '33902 Huynh Shoal', 'Kelleyport', '58670')
('Allen Oconnell', 801, '3328 Carla Rapid', 'Annland', '77877')
('Amber Phelps', 802, '48497 Sheila Pines Suite 100', 'Connieberg', '18050')
('Whitney Salazar', 803, '947 Jessica Crescent Suite 792', 'Port Caleb', '43763')
('Gregory Sharp', 804, '5765 Ryan Isle', 'East Carrie', '45739')
('Andrea Martin', 805, '262 Wallace Forks Apt. 870', 'North James', '94241')
('Angela Ross', 806, '619 Smith Inlet Apt. 285', 'Teresaport', '34702')
('Nicole Juarez', 807, '48529 Barr Parkway Apt. 246', 'New Christopherton', '13586')
('Denise Davis', 808, '7788 Brooks Fields Apt. 954', 'North Victoria', '36466')
('Ian Walton', 809, '333 Jones Valleys', 'South Elizabeth', '24725')
('Jeffrey Mann', 810, '599 Long Oval Suite 365', 'Sheltonmouth', '61515')
('David King', 811, '2253 Mayo Freeway', 'Wilsonburgh', '49851')
('Cynthia Goodwin', 812, '480 Nicholas Groves', 'South Devinchester', '05457')
('Dawn Blake', 813, '666 Newman Throughway', 'South Jerryport', '02712')
('Wendy Williams', 814, '8491 Lauren Lodge', 'Elizabethmouth', '05159')
('Erica Burke', 815, '2574 Andrews Vista', 'Stefanieside', '38274')
('Michelle Foster', 816, '10646 Sandy Light', 'South Thomas', '78803')
('Edward Williams', 817, '92599 Jordan Circle', 'Lake Josephhaven', '68547')
('Brenda Hernandez', 818, '8360 Walker Pine', 'North Harold', '34001')
('Erik Nash', 819, '448 Hill Passage Suite 711', 'Davidborough', '40162')
('Angela Sanders', 820, '9739 Jennifer Branch Apt. 972', 'Roberttown', '32645')
('Karen Green', 821, '6802 Jennifer Inlet', 'East Frances', '01335')
('Tina Roy', 822, '0953 Barbara Centers Apt. 217', 'Chadshire', '76378')
('Tyler Yang', 823, '251 Guerra Oval', 'Gibsonhaven', '29556')
('Taylor Rogers', 824, '6473 Katherine Brooks', 'Brownmouth', '36941')
('Mrs. Amy Good', 825, '560 Brian Loop Apt. 718', 'Kellyshire', '48949')
('Eric Kim', 826, '054 Jamie Falls Apt. 023', 'Port Brittney', '27476')
('Brianna Martin', 827, '827 Brown Mall Suite 872', 'Johnmouth', '48936')
('Jeffrey Miller', 828, '753 Lori Run Suite 143', 'East Richardland', '32239')
('Lisa Jordan', 829, '0685 William Creek Suite 343', 'Lisabury', '02922')
('David Wilson', 830, '17426 Jennifer Ways Apt. 542', 'Jonesmouth', '90665')
('Kayla Haney', 831, '70199 Jenna Viaduct', 'West Tricia', '99162')
('Steven Romero', 832, '43085 Lori Stream', 'Mccannshire', '00965')
('Christopher Carpenter', 833, '18634 Amanda Prairie', 'Tiffanyburgh', '62164')
('Matthew Williams', 834, '9822 Chang Stravenue Apt. 277', 'Weaverville', '49004')
('Lisa King', 835, '4746 Angelica Club', 'Lake Michaelland', '49598')
('Shane Jones', 836, '2922 Kathy Meadows Apt. 241', 'North Bradley', '49155')
('Daniel Gould', 837, '0780 Joseph Lodge', 'East Dakota', '88830')
('Anthony Barrera', 838, '193 Adams Estates Apt. 006', 'Morganburgh', '60972')
('Daniel Gibson', 839, '47015 Adrian Trace', 'East Shannon', '18657')
('Heather Reyes', 840, '084 Horton Islands', 'New Jill', '38565')
('Brooke Jones MD', 841, '2274 Peterson Forge', 'Morrowbury', '85624')
('Jennifer Lewis', 842, '06810 Joshua Lane Suite 146', 'New Franciscofort', '40997')
('Eric Knapp', 843, '71050 Cameron Unions', 'Port Rebecca', '09386')
('Ashley Price', 844, '638 Jennifer Mountains', 'West Amy', '36742')
('Taylor Cohen', 845, '4460 Elizabeth Canyon Apt. 933', 'Kristytown', '76942')
('Raymond Merritt', 846, '25583 Fox Prairie Apt. 909', 'Jennyburgh', '37486')
('Matthew Marshall', 847, '64416 Rodriguez Walk', 'East Angelafort', '77384')
('Debbie Byrd', 848, '55587 Shirley Camp', 'Walkertown', '89516')
('Stephanie Brandt', 849, '29672 Michael Station', 'Whiteview', '00807')
('Margaret Potts', 850, '6348 Albert Roads Apt. 593', 'South Kimberly', '98582')
('Bonnie Hall', 851, '0857 Andersen Vista', 'North Chadmouth', '62660')
('Suzanne Leonard', 852, '1035 Atkinson Ville Suite 536', 'New Lauraview', '39051')
('Kayla Richards', 853, '1894 Laura Springs', 'East Michele', '11928')
('Shelby Neal', 854, '580 Jesse Lane Apt. 836', 'North Bonniefurt', '54692')
('Beth Foster', 855, '429 Katherine Ford', 'Alisonhaven', '72639')
('Roger Olson', 856, '59720 Russell Meadow Suite 332', 'South Charlesborough', '08449')
('Todd Small', 857, '082 Michael Ramp', 'Aguilarland', '53010')
('Brent Steele', 858, '72938 Benjamin Mill Suite 481', 'Port Lisa', '24530')
('Jordan Watson', 859, '272 Taylor Mill Suite 749', 'Markton', '44617')
('Diane Sandoval', 860, '9724 Harrison Shoals Apt. 662', 'North Stephanie', '89699')
('Amy Mcdonald', 861, '521 Simmons Shores Apt. 568', 'Barnestown', '86312')
('Scott Bates', 862, '922 Jamie River Apt. 520', 'Franklinstad', '83560')
('Rachael Benson', 863, '42489 Watson Island', 'Julieland', '23886')
('Amanda Henderson', 864, '8383 Dawn Port Apt. 788', 'Singhchester', '77196')
('John Benjamin', 865, '008 Bush Valleys', 'Tammieberg', '94644')
('Jeremy Clark', 866, '9612 Charlotte Way Suite 722', 'Lauraport', '15767')
('Jordan Moody', 867, '183 Jennifer Mill Apt. 233', 'Wheelerton', '69673')
('Stephen Hoffman', 868, '196 Jason Brooks', 'Cassandraborough', '48487')
('Maria Reed', 869, '4614 William Mews', 'North Karen', '20947')
('Angela Kelley', 870, '51025 David Shore', 'Hudsonfurt', '13138')
('Sarah Greer', 871, '529 Ryan Gateway', 'New Chad', '63121')
('Sydney Brown', 872, '0984 Patricia Cape Apt. 001', 'Port James', '41975')
('Clayton Stephenson Jr.', 873, '9812 Sandra Rue', 'Jonesfurt', '41653')
('Victoria Becker', 874, '757 Lawrence Hollow', 'Murraybury', '88297')
('David Jenkins', 875, '220 Bowen Garden', 'Lake Amandaton', '04679')
('Emily Mcdaniel', 876, '701 Evans Ramp Suite 145', 'East Alexville', '45174')
('John Hunter', 877, '035 Hall Shoal', 'Masonshire', '45355')
('Faith Rhodes', 878, '7912 Terri Branch', 'West Kimberlystad', '61199')
('Edward Williams', 879, '8655 Ann Roads Suite 750', 'Clarkfort', '42725')
('Amanda Vargas', 880, '2370 Williams Cove', 'North Patricktown', '29486')
('Sabrina Sutton', 881, '35387 Campbell Corner', 'New Kim', '56654')
('Julia Patel', 882, '31730 Randy Park', 'Michelleport', '90859')
('Angela Scott', 883, '3109 Dixon Mall Apt. 955', 'Gonzalesville', '81451')
('Kimberly Anderson', 884, '2055 Williams Station', 'Downsmouth', '12764')
('Heather Farmer', 885, '710 Miguel Spurs Apt. 441', 'North Zacharyville', '73589')
('Eric Warren', 886, '332 Reeves Keys Apt. 301', 'New Jessicamouth', '84268')
('Brian Kramer', 887, '749 Fletcher Villages Suite 020', 'Micheleland', '90905')
('Krista Baker', 888, '615 Emily Street Suite 181', 'North Jonathan', '44401')
('Robert Russell', 889, '24931 Cunningham Extension', 'Charlesville', '11505')
('Stacey Morgan', 890, '4268 Alex Creek Suite 970', 'West Janicechester', '56852')
('Meredith Mosley', 891, '259 Holly Village', 'Robertton', '15243')
('David Valdez', 892, '68104 Nunez Forges', 'Rogersview', '29428')
('Connor Tucker', 893, '2716 Fitzgerald Viaduct', 'Parkerside', '12503')
('Suzanne Reyes', 894, '6661 Herbert Extensions', 'Port Mary', '62392')
('Samantha Lewis', 895, '436 Jason Plain', 'Paulhaven', '94185')
('Christopher Lester', 896, '64577 Harris Fork', 'Lake Jenniferfort', '20823')
('Katherine Mitchell', 897, '4866 Smith Islands', 'North Phillipfort', '71253')
('Craig Shepherd', 898, '527 Krystal Creek Apt. 177', 'Davidside', '97859')
('Michael Rivera', 899, '5714 Tara Dale Apt. 589', 'Toddside', '11332')
('Christopher Norton', 900, '90603 Snyder Light', 'Hansenmouth', '77729')
('Rebecca Stone', 901, '72225 Scott Lights', 'Carrville', '53408')
('James Harper', 902, '172 Thomas Route', 'Marshallmouth', '98415')
('Gary Sutton', 903, '79075 Pugh Terrace', 'Clarkville', '12940')
('Michael Richard', 904, '777 Nelson Point', 'Joshuamouth', '10392')
('Amy Wilson', 905, '0582 Collins River', 'Port Daniel', '87238')
('Paul Walker', 906, '1882 Kelly Island Suite 174', 'New Chadside', '75024')
('Jamie Cruz', 907, '4121 Parker Estate Suite 436', 'East Andrew', '64240')
('Dennis Cohen', 908, '38570 Larry Lake Suite 908', 'Lake Richardhaven', '47854')
('Julie Crawford MD', 909, '531 Courtney Island', 'New Alisonview', '86167')
('Michael Vaughan', 910, '5876 Jason Summit Apt. 138', 'East Megan', '20297')
('Laurie Baker', 911, '98099 Mackenzie Village', 'East Matthewbury', '30098')
('Wyatt Ballard', 912, '72104 Adam Stravenue', 'West Jennifermouth', '53911')
('Diane Robbins', 913, '75880 Shawn Flat', 'Lake Ritaview', '52912')
('Angela Reese', 914, '7403 Logan Meadows Suite 755', 'North Jillchester', '37055')
('Danielle Castro', 915, '071 Emma Mission Apt. 526', 'Lake Stephenburgh', '33028')
('James Butler', 916, '4913 Rivera Parks Apt. 921', 'Smithstad', '91176')
('Matthew Barker', 917, '623 Tanya Valley', 'East Tina', '94799')
('Justin Freeman', 918, '10519 Mendez Road', 'South Jesse', '46474')
('Erin Cruz', 919, '487 Christy Avenue', 'South Frank', '21415')
('Sarah Guerrero', 920, '62502 Tapia Light Suite 868', 'Brandtside', '88728')
('Dylan Russell', 921, '894 Daniel Dale', 'Port Rita', '26750')
('Kathleen Ashley', 922, '33711 Sandoval Stream Apt. 947', 'Laneburgh', '29544')
('Ariana Williams', 923, '67092 Jasmine Rapid', 'Lisaside', '83809')
('Curtis Bennett', 924, '8686 Benjamin Mountain Suite 906', 'Williamsmouth', '19951')
('Robert Collins', 925, '973 Sarah Flats', 'Woodshire', '56313')
('Chase Hunter', 926, '661 Anthony Lake', 'North Adam', '32636')
('Susan Trujillo', 927, '17065 Johnson Trail Apt. 738', 'Lake Tiffany', '41409')
('Betty Bishop', 928, '933 Albert Hills Apt. 762', 'New Paul', '36211')
('Brittany Bautista', 929, '864 Johnson Plains Apt. 574', 'Garrettport', '07683')
('Karen Herrera', 930, '3006 Natalie Meadows Suite 980', 'Youngton', '26432')
('Eddie Gray', 931, '843 Hayes Harbor Apt. 073', 'Sampsonville', '92769')
('William Davis', 932, '287 Amanda Loaf', 'Danielland', '31545')
('Edward Anderson', 933, '27947 Brewer Ways Suite 031', 'Roweview', '90182')
('Kathryn Whitaker', 934, '5387 Chelsea Cove Suite 784', 'Jamesmouth', '46303')
('Denise Walker', 935, '6396 Murphy Ramp Suite 770', 'North Dwayneburgh', '73020')
('Susan Harrington', 936, '56013 David Turnpike', 'New Mariaton', '71389')
('Sandra Lawrence', 937, '427 Daniel Crest Suite 481', 'North Abigail', '94560')
('Katherine Reed', 938, '01997 Monica Common Suite 163', 'Sullivanhaven', '28538')
('Amanda Campbell', 939, '486 Tyler Rue Apt. 389', 'West Robert', '14337')
('Mary Rangel', 940, '8894 Crawford Stream', 'North Brandychester', '66486')
('Brandi Wu', 941, '4962 Whitney Isle', 'North Carolland', '34510')
('Renee Chandler', 942, '1686 Hughes Well', 'Markhaven', '19759')
('Rebecca Davis', 943, '873 Mitchell Mountain', 'Taylorstad', '59997')
('Allison King', 944, '550 Angela Ford Suite 350', 'East Jonathanchester', '61237')
('Tammy Hardin', 945, '335 Lauren Pines', 'Grantchester', '65853')
('James Cummings', 946, '7745 Bryan Branch', 'Jasonton', '53865')
('Victor Mcintyre', 947, '547 Mueller Shoals Apt. 434', 'Lisafurt', '15959')
('Andrea Rhodes', 948, '5262 Jennifer Haven', 'East Markfurt', '78755')
('Brianna Lee', 949, '5150 Timothy Freeway', 'Bennettberg', '04072')
('Brittany Pena', 950, '7275 Mitchell Route Apt. 528', 'West Michealport', '52498')
('Jennifer Wang', 951, '78315 Erin Prairie', 'East Vanessaside', '71744')
('Julia Stewart', 952, '9198 Jacobs Drives Suite 430', 'South Tonyaburgh', '55168')
('Sheila Smith', 953, '074 Stephanie Stravenue Apt. 589', 'Lesliebury', '11277')
('Ryan Mason', 954, '423 Russo Forges Suite 523', 'Andersonland', '98158')
('Sean Gaines', 955, '796 Craig Village Apt. 138', 'Port Joseph', '10029')
('Lauren James', 956, '51336 Thomas Glens', 'South Timothyburgh', '49053')
('Christy Brown', 957, '6856 Dawson Mount Suite 638', 'Garciaside', '61807')
('Jeremy Arnold', 958, '5329 Andrew Valley', 'Melissaton', '77683')
('Joanne Boyd', 959, '1133 Brenda Mission Suite 099', 'Michellestad', '23606')
('Howard Smith', 960, '2801 Weaver Wells Apt. 157', 'Lake Marcus', '79752')
('Michael Powers', 961, '30538 Angelica Lakes Apt. 727', 'North Allenburgh', '64471')
('Danielle Anderson', 962, '4189 Eugene Crescent', 'South Kevin', '28900')
('Jessica Robles', 963, '246 Martin Cape', 'North Chad', '77624')
('Thomas Bell', 964, '6839 James Mount Suite 178', 'Port Dwayne', '97894')
('Michael Anderson', 965, '91390 Jimenez Harbors', 'Jessicamouth', '97796')
('Charles Shaw', 966, '55749 Jessica Neck Suite 449', 'Jonesburgh', '06672')
('Justin Allen', 967, '3750 Miles Fork', 'Port Allen', '45415')
('Robert Morrison', 968, '81526 Jessica Courts', 'New Valeriemouth', '93926')
('Carrie Owen', 969, '262 Kendra Streets Suite 888', 'Reyesborough', '61960')
('Tina Shelton', 970, '297 Madison Stream', 'Port Marcusmouth', '54876')
('Thomas Goodwin', 971, '752 Spencer River Apt. 903', 'Bishopstad', '32228')
('Kimberly Mcclain', 972, '163 Gonzalez Terrace', 'West Patricia', '62189')
('Phillip Thompson', 973, '49340 Rubio Landing', 'South Jamesfort', '95765')
('Michael Hammond', 974, '85490 Khan Cove Apt. 636', 'Zacharyfurt', '75905')
('Jenna Mora', 975, '1472 James Hills Apt. 937', 'Aliciamouth', '16435')
('Keith Gomez', 976, '280 Mercado Glen', 'East Rachelshire', '17392')
('Donald Young', 977, '946 Lucero Courts', 'Amyfurt', '41483')
('Scott Shah', 978, '7350 Hart Springs Suite 228', 'Lake James', '67006')
('Derek Wilson', 979, '829 Jeffrey Isle Apt. 319', 'Port Gregory', '52068')
('James Anderson', 980, '932 Hall Curve', 'Lake Levi', '14325')
('Ashley Preston', 981, '2350 Stephanie Causeway Apt. 026', 'Coreyside', '67316')
('Jill Mora', 982, '125 Huang Lodge', 'Victoriahaven', '60100')
('Russell Rodriguez', 983, '25115 Schultz Street Apt. 327', 'West Nicholasview', '95251')
('Mary Jacobs', 984, '9442 Perry Glen Apt. 435', 'Burtonmouth', '24693')
('Cody Thompson', 985, '1504 Melissa Creek Apt. 523', 'West Samanthafurt', '70971')
('Nathan Cooley', 986, '7939 Robert Lodge', 'East Jacobview', '59917')
('Sara Davis', 987, '54390 Michael Well Suite 731', 'New Tracy', '06572')
('Rebecca Taylor', 988, '32272 Smith Ports', 'Racheltown', '86699')
('Jonathan Figueroa', 989, '64712 Denise Glen', 'North Christine', '92533')
('Kimberly Page', 990, '7746 Hood Glen Apt. 124', 'West Stephaniehaven', '30355')
('Alisha Rosales', 991, '8376 Joseph Turnpike', 'Tommymouth', '02189')
('William Larson', 992, '8659 Meyer Plaza Apt. 650', 'New Kelli', '64199')
('Mario Miller', 993, '59632 Mathew Causeway Suite 735', 'New Mitchellshire', '14032')
('Sarah Clark', 994, '71268 Williams Mount Suite 758', 'New Edwardport', '16889')
('Joseph Owen', 995, '116 Johnson Ferry', 'New Caseyberg', '38358')
('Daniel Garcia', 996, '34614 Kenneth Common Suite 792', 'Chambersview', '22732')
('Kaitlyn Jones', 997, '4950 Frank Coves', 'Scotthaven', '79372')
('Andrew Clay', 998, '553 Brian Drive Suite 924', 'South Margaret', '25910')
('Yolanda Shields', 999, '765 Joseph Islands Suite 336', 'New Benjaminburgh', '99762')
('Ryan Payne', 1000, '37862 Glenn Streets Suite 674', 'New Mike', '47150')
('David King', 1001, '2867 Mary Glens', 'Brandonberg', '03944')
('Kimberly Sandoval', 1002, '997 Christopher Village Suite 711', 'Lake Emilyfurt', '18185')

In [40]:

cur.fetchall() # returns a list of tuples for all results

cur.fetchmany(10) # returns a list of tuples for the first n specified

cur.fetchone() # returns a single entry as a tuple

cur.fetchall() # returns a list of tuples for all results cur.fetchmany(10) # returns a list of tuples for the first n specified cur.fetchone() # returns a single entry as a tuple

Out[40]:

('Big Bird', 1, 'Sesame Street', 'Fakeville', '12345')

In [41]:

data=cur.fetchone()
print(data[0])

data=cur.fetchone() print(data[0])

Grouch

In [42]:

data

data

Out[42]:

('Grouch', 2, 'Sesame Street', 'Fakeville', '12345')

In [44]:

# see how many rows are returned
cur.rowcount

# see how many rows are returned cur.rowcount

Out[44]:

1002

In [46]:

### Write query results directly to a csv file 
f=open('data/fromdb.csv','w')
cur.copy_to(f,'users',sep=',')
f.close()

### Write query results directly to a csv file f=open('data/fromdb.csv','w') cur.copy_to(f,'users',sep=',') f.close()

Using pandas¶

In [47]:

import pandas as pd

import pandas as pd

In [48]:

df = pd.read_sql("SELECT * FROM USERS", conn)

df = pd.read_sql("SELECT * FROM USERS", conn)

In [49]:

df.head()

df.head()

Out[49]:

	name	id	street	city	zip
0	Big Bird	1	Sesame Street	Fakeville	12345
1	Grouch	2	Sesame Street	Fakeville	12345
2	Lucas Bryant	3	96205 Robinson Underpass	North Cherylland	35412
3	Christopher Rodriguez	4	662 Hancock Ville Apt. 046	New Justin	48470
4	Thomas Thompson	5	5051 Figueroa Park	Tylerton	22303

In [ ]: