Normalised records

Normalised records (silver)

Each raw row is parsed into consistently formatted fields. Every change from the raw value is recorded as a data-quality flag.

Normalised rows
99,495
usable in matching
Flagged rows
99,881
99.9% carry at least one flag
Junk quarantined
505
no usable last name
Average quality score
0.75
1.00 = no corrections needed

Quality flags

What normalisation had to do, and how often. Select a flag to filter the table.

Normalised records

Provider network, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
PRV-26580PRVMaria Cunningham1959-10-20—89880858327075 Pine Dr, Los Angeles, CA, 900080.50Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+3 more
PRV-29504PRVSophia Reid1987-11-27—92831380424481 Bayshore Dr Apt 28, Las Vegas, NV, 891210.50Date of birth reformattedPhone reformattedSSN last four extractedUnit split from street+3 more
PRV-25207PRVFatima Daniels2007-06-08UHC-51636-636599382100500 Desert Sky Blvd # 185, Plano, TX0.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-21706PRVPaul Patel—UHC-58061-8526491382173976 Park Pl, Tampa, FL, 336460.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-24205PRVWei Castillo——90624394682397 Willow Ct, Eden Prairie, MN, 553920.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-26425PRVNancy J Graham—UHC-43007-2270946051284350 Apache Blvd # 543, Seattle, WA, 981970.50Date of birth missingPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-27502PRVWillie Suullivan2005-02-28UHC-03086-9043369757066475 Elm St, Tampa, FL, 336360.50Name split from “Last, First”Two-digit birth yearMember ID reformattedStreet suffix standardised+3 more
PRV-23151PRVMichael L Graham1991-04-09UHC-80630-5571288805445523 Main St, Plano, TX0.50Name split from “Last, First”Phone reformattedState name converted to codeZIP missing+3 more
PRV-26789PRVCarol Pierce1957-02-09UHC-80359-2482151225177677 Baseline Rd, Fresno, CA, 937730.50Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
PRV-28368PRVPaul Y Ross—UHC-15295-38—3208 Lincoln Way, Plano, TX, 750290.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
PRV-28949PRVDenise Thomas2003-03-03—21084597994212 Church St # 332, Phoenix, AZ, 850090.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-24788PRVKaren Cook—UHC-61680-9960469586937461 Mountain View Dr, Fresno, CA0.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
PRV-23161PRVMadison Ellis1974-10-12—63931161935893 Central Ave # 221, Atlanta, GA, 303850.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-21537PRVValentina Montgomery1983-04-19UHC-94649-4091481295569150 Forest Ave, Nashville, TN, 372380.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-21281PRVLogan N Bell1970-08-22—22475983458447 River Rd Apt 1, Miami, FL, 331450.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-27057PRVAaron Nguyen1980-01-03UHC-97529-0926449346967123 Baseline Rd, Minneapolis, MN, 554180.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-25380PRVSantiago Q Warren——2874099329542 Harbor Blvd, Mesa, AZ, 852480.50Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more
PRV-27770PRVHawkins Maria1994-06-26UHC-12919-0974188383687375 Forest Ave Apt 10, Columbus, OH, 432330.50Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-20333PRVStephanie Hayes2007-10-20UHC-72841-28—403 Washington St, Houston, TX0.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-20173PRVJose C Peterson2007-07-18UHC-04323-58—6822 Baseline Rd Apt 27, Mesa, AZ, 852470.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-26751PRVBenjamin Brooks2008-12-09UHC-58222-5544891666179416 Desert Sky Blvd, San Diego, CA0.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-25831PRVSamuel Fields1973-02-01UHC-70900-7769082291532094 Desert Sky Blvd # 366, Fresno, CA, 937250.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-27998PRVKimberly Larson2003-08-24—81175877132152 Desert Sky Blvd, Glendale, AZ, 853610.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
PRV-29154PRVEdward K Burton2004-10-20—83390891931763 Palm Dr, Mesa, AZ, 852440.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28354PRVSteven P Black1977-09-05—82580223367645 Sage Ct # 969, Scottsdale, AZ, 852510.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-25298PRVBenjamin Taylor2001-12-08UHC-67866-6594059082626565 Cedar Ln, Las Vegas, NV0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-25687PRVVincent Gilbert2005-03-11—41743291605120 Cedar Ln, San Diego, CA, 921580.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-23359PRVWayne Rice1999-12-05—3802391706103 Sunset Blvd, Fresno, CA, 937290.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-26445PRVDennis Diaz2005-06-03—93034902236178 Ocean Ave, Las Vegas, NV, 891290.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-27914PRVElijah Campbell1959-10-22—34096784476580 Central Ave, Sacramento, CA, 958860.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20117PRVChristine Bennett1991-08-23UHC-46148-5964251554251835 Sunset Blvd, Glendale, AZ, 853040.50Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+3 more
PRV-22456PRVMark Sanchez1989-03-12UHC-08088-3835261111547775 Desert Sky Blvd, Columbus, OH, 432780.50Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
PRV-24196PRVJess Simpson1942-12-23UHC-26563-4436289128776565 Jefferson Ave, Seattle, WA0.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-29470PRVDiana Pena1978-11-05—94161715818865 Sunset Blvd, Atlanta, GA, 303090.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-27098PRVJean Owens1956-07-14—93428361894511 Cedar Ln, San Diego, CA0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-25168PRVJames Crawford1974-01-28UHC-30066-1392255689123463 Washington St, Tampa, FL, 336700.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-23229PRVBJunk1962-08-14UHC-74741-2562423121313629 Park Pl, Tucson, AZ, 857710.50Two-digit birth yearPhone reformattedMember ID reformattedZIP+4 trimmed+3 more
PRV-26800PRVLuis Gonzales1939-08-26UHC-00878-25—4733 Canyon Rd, Atlanta, GA, 303390.50Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+3 more
PRV-26002PRVKeith Gordon1965-09-11UHC-14722-6639362931229536 Lake View Rd, Dallas, TX, 752400.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
PRV-26188PRVMariana Montgomery1998-05-26UHC-54015-8681287250365809 Baseline Rd, Fresno, CA, 937150.52Name split from “Last, First”State name converted to codeEmail lower-casedGender normalised+2 more
PRV-20748PRVChristian Webb1970-03-12UHC-18196-2593064516162076 Mountain View Dr Apt 36, San Antonio, TX, 782590.52Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-26322PRVMaria Delgado1996-06-14—24659137799693 Highland Ave Apt 24, Nashville, TN, 372850.52Name re-casedPhone reformattedUnit split from streetState name converted to code+2 more
PRV-25757PRVEthan Simmons1947-08-08UHC-10103-539273792900922 Palm Dr Apt 24, Tempe, AZ, 852590.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-28228PRVAmber Cruz1943-10-18UHC-42078-47—7339 Oak St, Austin, TX, 787070.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-25210PRVNicole M Butler1997-01-10UHC-48354-10—6720 Bayshore Dr, Eden Prairie, MN, 553160.52Middle initial moved out of first nameStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-20022PRVJoyce A Contreras1966-07-03UHC-09400-7262245470082980 Park Pl, Mesa, AZ0.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-25779PRVRaymond Sullivan1989-08-22—48742313135591 Sage Ct # 134, Chandler, AZ, 852010.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-29099PRVJoe Vargas1973-02-28UHC-09497-5577451754594634 Lake View Rd, Dallas, TX0.52Phone reformattedSSN last four extractedCity re-casedZIP missing+2 more
PRV-21059PRVAmber G Nichols1993-03-03UHC-10935-8646250934601003 Sage Ct, Scottsdale, AZ0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-28169PRVEric Bell—UHC-32632-4032463459777210 Mountain View Dr Apt 39, Miami, FL, 331910.52Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+2 more
9,596 rows, page 15 of 192PreviousNext