SQL/DATA MANIPULATION HOMEWORK
Qualifications
1. Make sure there are no dupes in file check by phone # if there are mark the one with the least amount of info Duplicate
2. Mark Incomplete if Record does not have one of the following Phone First Name Last Name Address City State Zip
3. If phone number is less than 10 digits Mark Bad Phone #
4. If record does not have the state as CA or TX mark Out of Area
5. If Phone number is in the TNB file Mark NQTNB
6. If Phone number is in the Prior File Mark NQPRIOR
7. If Age is 1 or 2 Mark NQAGE
8. After steps 1 thru 7 if blank mark Qualified
Date,Phone1 - Cell,Phone2 - Home,FirstName,LastName,FirstName2,LastName2,Address,City,State,Zip,Venue,Event,AgeRange,Income,Marital Status,Gender,Home/Rent,Market,Qualifications 7/12/2017,832-994-4768,,Natasha,,,,7575 Plum Creeck,Houston,TX,77084,SFFT,Six Flags Fiesta,4,4,1,,,San Antonio, 7/16/2017,956-739-7344,,Tanner,Perez,,,,Pharr,TX,78577,SFFT,Six Flags Fiesta,,,1,,,San Antonio, 7/16/2017,662-897-1021,,Juana,Cintora,Larry,S,319 Inspiration,North Carrollton,MS,38947,Six Flags,Six Flags,,,,,,Dallas, 7/15/2017,210-719-3751,,Antonio,Pratt,,,1207 Cullin Ave,San Antonio,TX,78228,SFFT,Crack Axle,3,,,,,San Antonio, 7/15/2017,254-466-6249,,D,Floyd,,,PO Box 48951,Killeen,TX,76549,SFFT,Crack Axle,3,3,1,,,San Antonio, 7/12/2017,214-288-9608,,Brixon,Layne,,,392 Hot Spring Valley,Dallas,TX,75204,Parks Mall,Parks Mall,3,2,2,,,Dallas, 7/10/2017,210-961-1032,,Brandon,O'Donnel,,,2830 Crest Point,San Antonio,TX,78230,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/14/2017,512-775-4866,,Jessica,P,,,2345 N Houston Apt # 315,Dripping Springs,TX,78620,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/11/2017,713-518-6099,,Kelly,Yslas,,,1600 N Ronney,Pasadena,TX,77503,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/16/2017,000-413-9187,,Vianey,R,,,604 Campbell,Laredo,TX,,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/14/2017,915-541-5981,,Regina,Bise,,,,Denver,CO,80249,SFFT,Six Flags Fiesta,1,,1,,,San Antonio, 7/16/2017,786-461-0989,,Kyle,Reese,,,,Hialeah,FL,33012,SFFT,Crack Axle,1,4,1,,,San Antonio, 7/16/2017,818-310-2256,,Maria Rosario,L,,,,Tempe,AZ,85281,,LA Lobster Fest,2,2,1,,,LA, 7/10/2017,337-246-0938,,Edgar,Scott,,,,Jennings,LA,70546,SFFT,Six Flags Fiesta,2,3,1,,,San Antonio, 7/16/2017,465-518-5544,,Harry,Foster,,,,Baltimore,MD,21287,SFFT,Crack Axle,2,3,,,,San Antonio, 7/14/2017,602-668-5879,,Joseph,Zamora,,,,New River,AZ,85087,SFFT,Six Flags Fiesta,3,4,1,,,San Antonio, 7/12/2017,541-954-7726,,John,De Alba,Desiree,Neet,,Springfield,OR,97478,Six Flags,Six Flags,3,3,2,,,Dallas, 7/11/2017,913-240-0686,,Polette,Rodriguez,,,,Kansas City,MO,64130,SFFT,Six Flags Fiesta,4,,,,,San Antonio, 7/10/2017,736-345-6081,,Kimberlyn,Plumer,Lina,D Barrett,,Alamo,TN,38001,Six Flags,Six Flags,4,,,,,Dallas, 7/15/2017,337-570-9382,,Edwing,R,Jimmy,Jones,,Lake Charles,LA,70601,SFFT,Crack Axle,5,2,2,,,San Antonio, 7/14/2017,702-595-1848,,Kasey,,Brandy,N,17222 Tunin Rdg,Las Vegas,NV,89124,SFFT,Six Flags Fiesta,5,3,2,,,San Antonio, 7/16/2017,205-200-9257,,A,Gonzales,,,,Hayden,AL,35079,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/11/2017,318-762-2769,,Dianne,Patterson,Bruce,,,Shreveport,LA,71103,Grapevine Mills,Grapevine Mills,,,,,,Dallas, 7/16/2017,318-789-3711,,Diego,,,,6219 Oxford Lake Dr,Monroe,LA,71211,Starplex,Third Eye Blind,,,,,,Dallas, 7/14/2017,318-612-6858,,Diana,Wilson,Bharti,Patel,,Minden,LA,71055,Grapevine Mills,Grapevine Mills,,,,,,Dallas, 7/15/2017,915-227-3580,,Q,Gutierrez,Ofelia,Muniz,,Chaparral,NM,88081,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/14/2017,905-686-3620,,Pedro,Rangel,,,,Farmington,NM,87402,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/16/2017,915-219-6026,,Priscilla,Quinones,,,,Chaparral,NM,88081,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/16/2017,918-429-6788,,Riday,Duncan,,,,McAlester,OK,74501,Grapevine Mills,Grapevine Mills,,,,,,Dallas, 7/16/2017,901-205-4440,,Nicole,Puente,,,,Memphis,TN,38128,Six Flags,Six Flags,,,,,,Dallas, 7/15/2017,512-308-2351,,Javier,Lacara,,,,Cedar Creek,TX,78612,SFFT,Six Flags Fiesta,3,4,3,,,San Antonio, 7/13/2017,210-627-5947,,Angeles,Santana,,,,Poteet,TX,78065,SFFT,Six Flags Fiesta,3,2,1,,,San Antonio, 7/13/2017,210-740-8705,,Arial,Galvan,,,,San Antonio,TX,78211,SFFT,Crack Axle,3,4,1,,,San Antonio, 7/14/2017,210-872-4606,,Beth,Wikenczy,Xavier,Arellano,1905 Nolas Ridge Dr,,,,SFFT,Six Flags Fiesta,3,3,2,,,San Antonio, 7/14/2017,210-501-6127,,Amy,Leedor,,,1207 South Mays,,,,SFFT,Crack Axle,1,3,1,,,San Antonio, 7/13/2017,210-584-0290,,Andrew,Galvan,,,1001 S 10th St 6-473rd,San Antonio,TX,,SFFT,Crack Axle,1,4,1,,,San Antonio, 7/11/2017,214-738-0879,,Chenee,Dunn,,,,Jarrell,TX,76537,SFFT,Six Flags Fiesta,1,4,1,,,San Antonio, 7/16/2017,210-524-3362,,Ana,Dunlap,,,562 Rattler Bluff,San Antonio,TX,,SFFT,Crack Axle,1,4,1,,,San Antonio, 7/16/2017,254-391-1823,,Cynthia,Worley,,,,Heighte,,76453,SFFT,SiX Flags Fiesta,1,,,,,San Antonio, 7/16/2017,619-721-0329,,Josue,Payton,,,,El Cajon,CA,92020,,LA Lobster Fest,2,4,1,,,LA, 7/13/2017,940-235-0395,,Romulo,Arellano,,,,Seymour,TX,76380,SFFT,Six Flags Fiesta,2,3,3,,,San Antonio, 3/13/2017,832-902-8301,,N,Ramirez,,,8901 Lonestar Rd,Austin,TX,,SFFT,Six Flags Fiesta,2,4,1,,,San Antonio, 7/16/2017,310-707-7237,,Deborah,Alvarado,,,3589 Hwy 51,,,,,LA Lobster Fest,2,4,1,,,LA, 7/15/2017,469-818-0227,,Jackie,Alondra,Denise,Najera,,Dallas,TX,75216,Grapevine Mills,Grapevine Mills,3,,1,,,Dallas, 7/15/2017,817-797-1982,,Mandell,Hudson,,,,Bedford,TX,76092,Starplex,Third Eye Blind,3,4,1,,,DFW, 7/16/2017,830-776-2661,,Matthew,Sellers,Ruth,Moreno,,Austin,TX,78701,SFFT,SiX Flags Fiesta,3,3,2,,,San Antonio, 7/14/2017,832-800-2686,,Monica,Apolinar,,,,San Antonio,TX,78245,SFFT,Crack Axle,3,1,1,,,San Antonio, 7/15/2017,956-205-3347,,Ryan,Peterson,Albert,Carrillo,,Mission,TX,78572,SFFT,Crack Axle,3,1,2,,,San Antonio, 7/10/2017,210-859-5590,,Ben,Estrada,,,,Austin,TX,78704,SFFT,Six Flags Fiesta,3,,1,,,San Antonio, 7/16/2017,001-608-5695,,A,Leal,,,,Dallas,TX,75116,Parks Mall,Parks Mall,3,4,2,,,Dallas, 7/15/2017,956-612-6102,,Summer,Martinez,Victor,Lopez,,Laredo,TX,78043,SFFT,Six Flags Fiesta,3,1,,,,San Antonio, 7/12/2017,214-206-6478,,Briana,Boffa,,,,Grand Prairie,TX,75052,Parks Mall,Parks Mall,3,4,1,,,Dallas, 7/15/2017,717-919-7799,,Kiley,Lujan,,,,Houston,TX,77048,Parks Mall,Parks Mall,3,,1,,,Dallas, 3/13/2017,210-787-9314,,Ashley,Cantu,Lenny,Miron,,San Antonio,TX,78201,SFFT,Six Flags Fiesta,3,,,,,San Antonio, 7/10/2017,713-677-9924,,Kendall,Cook,,,,San Antonio,TX,78238,SFFT,Six Flags Fiesta,3,4,1,,,San Antonio, 7/31/2017,210-391-9956,,Alisha,Sepulveda,,,,San Antonio,TX,78242,,Six Flags Fiesta,3,,1,,,San Antonio, 7/15/2017,323-363-1761,,Doltmer,Hipolito,,,1124 San Fernando,,,,Mesquite Rodeo,Mesquite Rodeo,3,1,1,,,Dallas, 7/16/2017,210-708-6220,,Anthony,Young,,,2332 San Paula Ave,,,,SFFT,Crack Axle,3,3,1,,,San Antonio, 7/10/2017,936-232-8173,,Roberto,Bailey,,,1008 W Felix St,,,,SFFT,Six Flags Fiesta,3,2,2,,,San Antonio, 7/13/2017,903-204-0118,,Noemi,Wiley,Thomas,Bean,,Mount Pleasant,TX,75455,Six Flags,Six Flags,4,4,2,,,Dallas, 7/19/2017,214-918-0793,,Christine,Herrera,,,,San Antonio,TX,78261,SFFT,Crack Axle,4,1,1,,,San Antonio, 7/16/2017,210-548-0850,,Andrea,Perez,Claudia,Estrada,2629 Pioneer St,San Antonio,TX,,SFFT,Crack Axle,4,4,,,,San Antonio, 7/11/2017,915-321-1636,,Raimah,T,,,,Fort Worth,TX,76119,Parks Mall,Parks Mall,4,4,,,,Arlington, 7/12/2017,903-497-2240,,Oscar,Jackson,,,,Mineola,TX,75773,Six Flags,Six Flags,4,4,1,,,Dallas, 7/14/2017,214-929-2461,,Christopher,Alvarado,,,1502 Belton Dr,Grand Saline,TX,,Six Flags,Six Flags,4,3,2,,,Dallas, 7/10/2017,210-365-2921,,Alexis,,,,1902 Winchester Dr,San Antonio,TX,78207,SFFT,Six Flags Fiesta,4,,,,,San Antonio, 7/15/2017,254-466-2933,,D,Hess,Amanda,Matthews,,Rosharon,TX,77583,SFFT,Crack Axle,4,1,2,,,San Antonio, 7/15/2017,903-742-3425,,Parks,Chavez,,,,Marshall,TX,75670,Six Flags,Six Flags,4,2,2,,,Dallas, 7/16/2017,832-602-5929,,Miguel,Gauna,,,,Houston,TX,77093,SFFT,Six Flags Fiesta,4,4,1,,,San Antonio, 7/15/2017,687-792-6457,,Karla,Vargas,,,,Cleburne,TX,76031,Starplex,Third Eye Blind,4,2,2,,,DFW, 7/10/2017,956-369-7281,,Sergio,A,Garza,,,Edcouch,TX,78538,SFFT,Six Flags Fiesta,4,,2,,,San Antonio, 7/14/2017,817-233-9707,,Lexi,Z,,,,Fort Worth,TX,76179,Grapevine Mills Mall,Grapevine Mills,4,3,1,,,Dallas, 7/11/2017,214-850-3112,,Christian,Franco,,,,Mesquite,TX,75149,American Airlines Center,Hall And Oates Concert,5,3,1,,,Dallas, 7/12/2017,409-939-4094,,Gary,F,,,,Arlington,TX,76002,Parks Mall,Parks Mall,5,,,,,Dallas, 7/14/2017,321-266-6962,,Dipen,F,Raymore,,,Georgetown,TX,78626,SFFT,Crack Axle,5,1,2,,,San Antonio, 7/15/2017,713-443-9331,,Keena,Vasquez,,,,Humble,TX,77396,SFFT,Six Flags Fiesta,5,,,,,San Antonio, 7/10/2017,817-923-0363,,Maria,Rodriguez,,,,Fort Worth,TX,76110,Parks Mall,Parks Mall,,,,,,Dallas, 7/16/2017,210-290-0665,,Akinwale,Barrett,,,,San Antonio,TX,78212,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/11/2017,214-980-0793,,Chuntalle,,,,8820 Westeimer Rd Apt #1403,Waxahachie,TX,75165,Six Flags,Six Flags,,,,,,Dallas, 7/16/2017,210-473-1348,,Ami,Garza,,,,San Antonio,TX,78209,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/10/2017,972-940-1381,,Ursula,Robles,,,107 Vivian Dr,Fort Worth,TX,,Parks Mall,Parks Mall,,,,,,Dallas, 7/15/2017,956-778-1484,,Taylor,Soto,,,,Santa Rosa,TX,78593,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/15/2017,001-255-1800,,A,Cruz Soto,,,,Dallas,TX,75215,Parks Mall,Parks Mall,,,,,,Dallas, 7/12/2017,210-584-1805,,Andrew,Flores,,,,San Antonio,TX,78232,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/15/2017,956-415-2141,,Sharon,Fuller,Priscilla,Fuentes,,McAllen,TX,78504,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/13/2017,214-913-2212,,Christine,Farias,,,,Dallas,TX,75231,Grapevine Mills,Grapevine Mills,,,,,,Dallas, 7/13/2017,281-691-2229,,Danny,Vannoy,,,,Spring,TX,77386,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/13/2017,682-202-2298,,Judith,Lopez,,,,Fort Worth,TX,76133,Six Flags,Six Flags,,,,,,Dallas, 7/15/2017,409-363-2317,,Gabriel,McKinney,,,,Plano,TX,75024,Starplex,Third Eye Blind,,,,,,Dallas, 7/16/2017,225-772-2462,,Concepaon,Digoo,,,,Pflugerville,TX,78660,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/16/2017,737-247-2559,,Kinsey,Solis,,,302 Benedict Rd,Austin,TX,,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/10/2017,361-759-2566,,Ever,,,,1905 W 19th St,Corpus Christi,TX,78411,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/16/2017,956-472-2599,,Silvestre,Well,,,,Weslaco,TX,78599,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/10/2017,210-394-2644,,Allie,N,Marissa,Enriquez,,San Antonio,TX,78258,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/11/2017,956-309-2826,,Sarah,,,,234 W Montana Ave,Mission,TX,78572,SFFT,Six Flags Fiesta,,2,,,,San Antonio, 7/11/2017,325-206-2930,,Don Jamie,Horrice,,,12465 Crow Ranch Rd,San Angelo,TX,,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/12/2017,832-660-2949,,Mike,Hill,,,,Dickinson,TX,77539,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/12/2017,512-758-3052,,Jesol,V,,,,Pflugerville,TX,78660,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/15/2017,972-965-3353,,V,Lujan,,,,Denton,TX,76208,Starplex,Third Eye Blind,,,,,,DFW, 7/16/2017,915-222-3356,,Prisila,Campos,,,,San Elizario,TX,79849,SFFT,Crack Axle,,,,,,San Antonio, 7/11/2017,682-204-3544,,Judy,Cotten,,,,Fort Worth,TX,76119,Six Flags,Six Flags,,,,,,Dallas, 7/13/2017,214-694-3554,,Charla,Kalk,,,PO Box 681,Dallas,TX,,Grapevine Mills,Grapevine Mills,,,,,,Dallas, 7/16/2017,318-663-3965,,Diana,H,Ramon,Stetson,,San Antonio,TX,,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/16/2017,361-208-4448,,Elizabeth,Rios,Travis,Randazzo,,Yoakum,TX,77995,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/13/2017,915-253-4598,,Rachael,Rodriguez,,,2108 Mayfield Ville Dr Apt #2106,El Paso,TX,,Six Flags,Six Flags,,,,,,Dallas, 7/16/2017,469-810-4754,,Jack,P,,,,Dallas,TX,75220,Grapevine Mills,Grapevine Mills,,,,,,Dallas, 7/16/2017,832-768-4846,,Mitchell,Hartfield,,,,Humble,TX,77346,Starplex,Third Eye Blind,,,,,,Dallas, 7/11/2017,210-904-5043,,Blanca,,,,1315 Loma Verde,San Antonio,TX,78202,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/15/2017,956-436-5769,,Shawn,Smith,,,10714 Brahmer,Laredo,TX,,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/15/2017,210-723-5801,,April,Jimenez,,,2613 Franklin Apt #914,Austin,TX,,Starplex,Third Eye Blind,,,,,,DFW, 7/11/2017,956-470-6148,,Silvester,L,Kassy,Garcia,4202 Emerson Dr,San Antonio,TX,,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/16/2017,361-429-6332,,Eric,,,,1801 Lova Dr Apt # 127,Corpus Christi,TX,78411,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/11/2017,903-681-6355,,Pam,Meraviglia,,,,Grand Saline,TX,75140,Six Flags,Six Flags,,,,,,Dallas, 3/13/2017,915-676-6550,,Rene,Diaz,,,,El Paso,TX,79924,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/15/2017,561-885-6551,,John,Collins,,,,San Antonio,TX,78252,SFFT,Six Flags Fiesta,,,,,,San Antonio, 6/12/2017,361-389-6756,,Enrique,Cobabe,,,,Inez,TX,77340,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/15/2017,214-687-6898,,Channing,M,,,,The Colony,TX,75056,Starplex,Third Eye Blind,,,,,,Dallas, 7/11/2017,210-454-6916,,Amber,Hernandez,,,,San Antonio,TX,78245,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/11/2017,682-307-7020,,Junio,C,,,950 E Bitters Rd Apt #411,Arlington,TX,,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/12/2017,214-642-7068,,Cecilia,Sanchez,,,,Desoto,TX,75115,Parks Mall,Parks Mall,,,,,,Dallas, 7/13/2017,832-706-7115,,Mina,Thomas,,,,La Porte,TX,77571,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/16/2017,210-859-7118,,Ben,Rogers,,,,San Antonio,TX,78280,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/14/2017,281-691-7360,,Danny,Markum,Erika,Castaneda,,Baytown,TX,77520,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/15/2017,586-838-7556,,Jose,Cordova,,,,Addison,TX,75001,Grapevine Mills,Grapevine Mills,,,,,,Dallas, 7/16/2017,956-371-7653,,Sergio,Conn,,,12 Latern Cir,San Antonio,TX,,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/8/2017,219-601-7899,,Claudia,Disbro,,,,Dallas,TX,75065,Grapevine Mills,Grapevine Mills,,,,,,Dallas, 7/15/2017,214-450-8005,,Caleb,Lincoln,Donaciano,Rios,2110 NW School St,Dallas,TX,,Grapevine Mills,Grapevine Mills,,,,,,Dallas, 7/10/2017,210-929-8334,,Brandi,Castro,Marianna,Hernandez,,Atascosa,TX,78002,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/16/2017,956-346-8731,,Selene,Lebron,Rosie,De La Crus,,Brownsville,TX,78521,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/14/2017,509-551-8798,,Jasmine,Lema,,,,Humble,TX,77338,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/16/2017,956-251-8833,,Samantha,,,,1154 Heavenly Harvest Pl #3,Laredo,TX,78043,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/10/2017,936-332-9081,,Robyn,Fraire,Alex,Rodriguez,,Center,TX,75935,SFFT,Six Flags Fiesta,,,,,,San Antonio, 4/14/2017,210-574-9248,,Andrew,Rodriguez,,,,San Antonio,TX,78242,Ingram Mall,Ingram Mall,,,,,,San Antonio, 7/12/2017,210-280-9972,,Ahly,Brown,,,6109 Dinos Dr,San Antonio,TX,,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/15/2017,817-822-0102,,Manuel,Wright,,,3003 Woodland,,,,Grapevine Mills,Grapevine Mills,,,,,,Dallas, 7/15/2017,254-334-0184,,Crystal,Phelan,Ronnie,Evans,8838 Dyas Rol Apt #23306,,,,Grapevine Mills,Grapevine Mills,,,,,,Dallas, 7/16/2017,832-359-1360,,Mercedes,Wade,,,8102 Greenwich Ct,,,,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/16/2017,001-309-1416,,A,Acosta,,,1416 Terminal Rd,,,,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/13/2017,817-658-1853,,Lydia,Dang,,,119 Alicia Ave,,,,Six Flags,Six Flags,,,,,,Dallas, 7/16/2017,504-914-1879,,Janine,Lambert,,,704 Hopkins,,,,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/16/2017,830-352-2330,,Mark,Garza,,,4440 Burnhill Dr,,,,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/12/2017,972-571-2569,,Tonya,De La Garza,,,13875 Ella Blvd Apt #203,,,,Six Flags,Six Flags,,3,,,,Dallas, 7/10/2017,919-478-2897,,Robert,Bryant,,,35643 Night Blvd,,,,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/11/2017,214-902-3398,,Christina,Ortiz,,,921 Brown Trl,,,,Six Flags,Six Flags,,,,,,Dallas, 7/12/2017,906-440-3828,,Yulenia,Jones,,,9821 Summerwood Cir Apt #304,,,,SFFT,Six Flags Fiesta,,4,,,,San Antonio, 7/13/2017,817-263-4536,,Lillie,Cueva,,,4315 S Aldredge St,,,,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/15/2017,601-927-5025,,Jose Luis,Goins,,,4404 Snady Dr,,,,Six Flags,Six Flags,,3,,,,DFW, 7/15/2017,972-804-6132,,Trish,Roca,,,15710 Ensenada Dr,,,,Grapevine Mills,Grapevine Mills,,,,,,Dallas, 7/11/2017,318-532-7188,,Diana,Lira,,,1320 N Fairgrand Rd #612,,,,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/13/2017,575-680-8019,,Jorge,Miller,,,,,,,Six Flags,Six Flags,,,,,,Dallas, 7/15/2017,817-495-8357,,Loriauna,Fleming,Shera,Levis,1049 Country Folks Ln,,,,Grapevine Mills,Grapevine Mills,,,,,,Dallas, 7/16/2017,601-410-8682,,Jose,Lozano,,,2511 Wedglen Dr Apt #510,,,,Grapevine Mills,Grapevine Mills,,,,,,Dallas, 7/16/2017,210-585-8722,,Andrew,Thomas,,,4411 Bardendale,,,,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/11/2017,917-696-9098,,Rick,Ozuna,,,6607 Surrey Meadow Ct,,,,Grapevine Mills,Grapevine Mills,,,,,,Dallas, 7/15/2017,254-421-9170,,Cynthia,,Wendy,Jennings,1113 Foster St,,,,Starplex,Third Eye Blind,,,,,,Dallas, 7/15/2017,512-717-9493,,Jeremy,Moncivals,,,,,,,SFFT,Crack Axle,,,,,,San Antonio, 7/12/2017,210-473-9865,,Amina,Telles,,,603 Neches St,,,,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/15/2017,580-399-3018,,Jose,Montz,,,410 Bardin Greene Dr Apt # 721,Ada,OK,74820,Starplex,Third Eye Blind,3,2,3,,,Dallas, 7/15/2017,580-743-5600,,Jose,Banda,Tommy,Boswell,5024 River Rock Blvd,Millerton,OK,74750,Six Flags,Six Flags,4,4,2,,,DFW, 7/11/2017,954-993-1099,,Ruth,Alexander,,,3241 Rich Acres,Pembroke Pines,FL,33028,SFFT,Six Flags Fiesta,1,,,,,San Antonio, 7/10/2017,337-365-4725,,Eduardo,Nunez,,,105 Tansyl Dr,Jennings,LA,70546,SFFT,Six Flags Fiesta,1,4,1,,,San Antonio, 7/16/2017,225-347-7765,,Clint,Rangel,,,12823 Borcas,Livingston,LA,70754,Grapevine Mills,Grapevine Mills,1,3,1,,,Dallas, 7/13/2017,541-286-8070,,Johanna,Greenwood,,,8903 Levelland,Corvallis,OR,97330,SFFT,Six Flags Fiesta,1,3,1,,,San Antonio, 7/11/2017,505-860-2572,,Jasmie,Garcia,,,5615 Brookview Ct Apt #B,Flora Vista,NM,87415,SFFT,Six Flags Fiesta,2,3,1,,,San Antonio, 7/16/2017,631-935-2715,,Juan,Barcenas,,,603 San Carlos St,Congers,NY,10920,SFFT,Six Flags Fiesta,2,,,,,San Antonio, 7/14/2017,907-412-1602,,Pedro,Alvarez,Brian,Bailey,4214 Cap Rock Ct,Kotzebue,AK,99752,SFFT,Six Flags Fiesta,3,3,2,,,San Antonio, 7/15/2017,561-331-1482,,John,De La Cruz,,,34180 Hillside Dr,West Park,FL,33023,Parks Mall,Parks Mall,3,3,1,,,Dallas, 7/10/2017,316-990-3298,,Derrak,Long,Anchar,Cooper,626 Lagoun Ave,Wichita,KS,67207,Six Flags,Six Flags,3,3,1,,,Dallas, 7/16/2017,318-268-1388,,Desirre,Williams,,,1016 Calle San Marcos,Springhill,LA,71075,Six Flags,Six Flags,3,3,1,,,Dallas, 7/15/2017,225-954-2167,,Conny,Strawn,Michael,Johnson,1316 Pr 448G,Baton Rouge,LA,70808,Six Flags,Six Flags,3,2,,,,Dallas, 7/15/2017,318-732-2786,,Diane,Woodrum,Marcus,Moss,3210 Junction St Apt #119,Monroe,LA,71203,Parks Mall,Parks Mall,3,4,2,,,Dallas, 7/16/2017,985-855-4920,,Veronica,Martinez,,,354 Hub,Houma,LA,70364,SFFT,Six Flags Fiesta,3,4,2,,,San Antonio, 7/16/2017,314-503-6762,,Delma,Stevenson,,,2800 Waterview Pkwy Apt #5521,Florissant,MO,63031,Six Flags,Six Flags,3,4,1,,,Dallas, 7/14/2017,601-786-1908,,Jose,Vincent,Tracy,Beals,1610 Primrose Trl,Canton,MS,39046,Grapevine Mills Mall,Grapevine Mills,3,,2,,,Dallas, 7/15/2017,601-214-6396,,Jose,Taylor,,,2511 Wayne Dr,Jackson,MS,39213,Parks Mall,Parks Mall,3,4,1,,,Dallas, 7/11/2017,575-202-1517,,Jonathan,Porter,,,9884 Los Sonoma Rio,Clovis,NM,88101,SFFT,Six Flags Fiesta,3,4,1,,,San Antonio, 7/10/2017,505-948-2636,,Jasmin,Segura,,,6990 Windhaven Apt #204,Albuquerque,NM,87123,SFFT,Six Flags Fiesta,3,1,1,,,San Antonio, 7/16/2017,702-505-7550,,Kary,Vargas Gonzalez,,,1806 Texas St,Henderson,NV,89002,Six Flags,Six Flags,3,4,1,,,Dallas, 7/16/2017,845-705-5899,,Nayely,Nugent,,,1205 Essex Dr,Fishkill,NY,12524,Starplex,Third Eye Blind,3,3,1,,,Dallas, 7/15/2017,918-815-1250,,Robbin,Trevino,Jeff,Barney,2300 Greyson Dr Apt #527,Broken