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-28943PRVNancy Carpenter1980-06-07—65966438537629 Ocean Ave # 426, Dallas, TX, 752460.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-22895PRVStephen A Harrison1963-08-13—82940077195551 Grand Ave, Seattle, WA, 981880.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-20272PRVJante Wright1966-09-20UHC-45348-0231531854164019 Maple Ave, Minneapolis, MN, 554150.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22653PRVEugene Colins2005-05-18UHC-77997-4186435028921653 Highland Ave, Tempe, AZ, 852210.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-29293PRVBrittany Diaz1969-02-18—4036052054242 Harbor Blvd, Tempe, AZ, 852470.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-27417PRVDebra Garza1968-12-21—29580227646122 Highland Ave, Austin, TX, 787560.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-27481PRVVictoria Wallace1984-12-10——2975 Cedar Ln, Denver, CO, 802040.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28790PRVBilly Adams2006-06-17UHC-87978-8486297866263663 Mountain View Dr, Charlotte, NC, 282740.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28198PRVStephanie Lewis1946-06-23UHC-31263-9983958511898137 Desert Sky Blvd, Tampa, FL, 336170.62Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
PRV-29444PRVCheryl Obrien1938-08-14UHC-58364-1174893567437836 Union St, Chandler, AZ, 852530.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28641PRVMaria Rose1969-09-16—75941340131103 Sunset Blvd, Seattle, WA, 981230.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-27062PRVWallace I Sara1992-04-20—94076144541117 Baseline Rd, Tempe, AZ, 852020.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-29451PRVDaniel Washington1997-03-02—70266233009153 Jefferson Ave, Denver, CO, 802260.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20629PRVCharles Chavez1988-04-02—80973463663476 Lake View Rd, Fresno, CA, 937530.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-27099PRVEdward George1983-06-17UHC-36356-27—3180 Elm St, Austin, TX, 787420.62Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
PRV-24133PRVFerguson Lori2006-08-26UHC-87498-5128490262762459 Highland Ave, Glendale, AZ, 853520.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-22331PRVAnn Wilson1979-12-03UHC-99469-9072556660841701 Main St, Miami, FL, 331440.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-27866PRVChriistian Patel1995-02-19—24965318351065 Maple Ave, Atlanta, GA, 303580.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-25983PRVAdam T Phillips1981-10-14UHC-19294-1029545015234287 Washington St, San Antonio, TX, 782730.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-20085PRVChristine Salazar1973-11-05—94478047857127 Sunset Blvd # 559, Plano, TX, 750200.62Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-21014PRVEdward Edwards1947-11-16—79670093053370 Baseline Rd, Jacksonville, FL, 322310.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-27817PRVJordan Walker1988-02-19UHC-96381-0425245092373465 Union St, Columbus, OH, 432910.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-20109PRVCharlie Willis1954-04-17UHC-75469-91—2631 Lincoln Way, Austin, TX0.62Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
PRV-21205PRVMaria Warren1940-06-28——4096 Canyon Rd, Fresno, CA, 937080.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-25243PRVEugene Graham2004-10-26—27425304571088 Maple Ave, Fresno, CA, 937250.62Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
PRV-24363PRVElizabeth George1960-05-24UHC-90127-8368746656612879 Sunset Blvd, Chandler, AZ, 852100.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28865PRVJanice H Schultz1957-01-08—54387815429863 Church St, Eden Prairie, MN, 553570.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-24929PRVCarlos Ford1973-06-22UHC-51499-0885447964463488 Palm Dr, Tucson, AZ, 857120.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-22008PRVMarilyn Peters2008-04-10UHC-57980-91—9318 Elm St, Plano, TX, 750460.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28401PRVDieo H Ford1945-10-27—77052624083131 Apache Blvd, Tempe, AZ0.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-27559PRVAngela Gonzalez1964-02-05—29230595091263 Meadow Ln, Tempe, AZ, 852550.62Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-25830PRVJennifer Russell2003-03-03UHC-52480-1521475763628600 Ridge Rd, Chandler, AZ, 852870.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-27603PRVAna H Williams1985-11-05UHC-92716-7634081085163549 Meadow Ln, Columbus, OH, 432310.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-25419PRVRyan M Soto1994-04-04—50527102803892 Hillcrest Rd, Seattle, WA, 981580.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-26419PRVLuis McDonald1940-06-07—87129621484096 Main St, Glendale, AZ0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28430PRVWalter Tucker1976-12-11—88791366327362 Desert Sky Blvd, Jacksonville, FL, 322530.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22375PRVSamul P Wheeler1959-09-23—55446163569508 Ridge Rd, Fresno, CA, 937580.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28903PRVLuis Watson—UHC-67075-454788053781844 Washington St, Gilbert, AZ, 852320.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
PRV-23080PRVNancy Valdez1952-03-12—8833553974963 Canyon Rd, Chandler, AZ, 852950.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23846PRVKarn Morrison2000-06-28—47641167755196 Cedar Ln, Miami, FL0.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-25235PRVLucia Smith1948-03-23—54887508734835 Church St, Nashville, TN, 372610.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-25221PRVKatherine Y Perry1959-03-27——5610 Sage Ct, Fresno, CA, 937130.62Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
PRV-22728PRVPatrick Webb——938751901431 Palm Dr, Jacksonville, FL, 322660.62Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more
PRV-27516PRVJoseph Bradley2005-11-16—68772264097644 Park Pl Apt 15, Charlotte, NC, 282370.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-28986PRVRachel Wagner1981-04-09—42452381368428 Indian School Rd # 972, Austin, TX, 787490.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
PRV-28774PRVLucia Oliver1978-03-13—78699404381236 Cedar Ln, Mesa, AZ, 852190.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22596PRVAustin Bryant1982-03-20—52755598753056 Willow Ct, Houston, TX, 770080.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28032PRVRoger Davis1994-04-28UHC-30457-0921141955144491 Elm St # 863, Miami, FL, 331680.62Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
PRV-27615PRVGrace Ortiz1939-09-27—41868798127871 Spring St, Orlando, FL, 328720.62Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more
PRV-22183PRVBobby Lee1939-06-16—89022976577975 Lincoln Way, Scottsdale, AZ, 852010.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
9,596 rows, page 38 of 192PreviousNext