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-25615PRVJoseph Carpenter1942-01-28UHC-79380-692197361619874 Main St, Tucson, AZ, 857130.80Name re-casedPhone reformattedState name converted to codePlaceholder values cleared
PRV-29257PRVRoger Luna1960-10-11—83080530372436 Indian School Rd, Miami, FL, 331480.80Phone reformattedCity re-casedState name converted to codePlaceholder values cleared
PRV-20495PRVMartha Simmons2002-02-09——1191 Park Pl, Atlanta, GA, 303060.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26260PRVBrittany Mendez1946-05-27——5701 Baseline Rd, Columbus, OH, 432340.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-25968PRVCatherine Sanders1942-02-06——6972 Apache Blvd, Minneapolis, MN, 554180.80Date of birth reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
PRV-23693PRVChristina M Herrera1954-09-19—44222180096995 Pine Dr, Plano, TX, 750520.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27592PRVBill Ellis2002-02-14—92356400028506 Sunset Blvd, Gilbert, AZ, 852720.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-28619PRVMichael Montgomery1992-03-02UHC-33107-3422344608883406 Union St, Nashville, TN, 372730.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25943PRVMei R Barnes1960-11-03—92027422732888 Mountain View Dr, Nashville, TN, 372770.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
PRV-28242PRVPriya Lopez1947-04-09——6000 Harbor Blvd, Chandler, AZ, 852960.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
PRV-22120PRVBeverly E Burns1955-03-05—59227488069202 Palm Dr, Seattle, WA, 981980.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23821PRVNathan Fernandez1993-03-22UHC-35679-2659199239605278 River Rd, Jacksonville, FL, 322470.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26976PRVNatalie H Duncan1972-03-22UHC-88287-196413717461930 Meadow Ln, Las Vegas, NV, 891250.80Middle initial moved out of first nameName re-casedDate of birth reformattedPlaceholder values cleared
PRV-26977PRVNatalie H Duncan1972-03-22UHC-88287-196413717461930 Meadow Ln, Las Vegas, NV, 891250.80Middle initial moved out of first nameName re-casedDate of birth reformattedPlaceholder values cleared
PRV-24533PRVAlbert Carter1973-12-23—51599767589426 Baseline Rd, Tempe, AZ, 852010.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-23159PRVJese Wrren2008-11-17UHC-51170-4646383016877100 Hillcrest Rd, Gilbert, AZ, 852430.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
PRV-23477PRVRebecca Greene2006-05-05UHC-66153-41—3070 Palm Dr, Tampa, FL, 336940.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
PRV-23476PRVRebecca Greene2006-05-05UHC-66153-41—3070 Palm Dr, Tampa, FL, 336940.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
PRV-20252PRVAmanda P Williams1987-12-15UHC-27644-83—3506 Hillcrest Rd, Houston, TX, 770930.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
PRV-28510PRVCynthia Weber1989-03-13—69786756984461 Pine Dr, Tampa, FL, 336450.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-24629PRVTheresa Young1940-01-10—237823605697 Broadway, Sacramento, CA, 958430.80Date of birth reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
PRV-28051PRVMateo Park1945-02-10UHC-91913-608946156013485 Jefferson Ave, Glendale, AZ, 853960.80Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased
PRV-21929PRVLori Weber1995-02-02——432 Ridge Rd, Plano, TX, 750900.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-29413PRVMichelle Ramos1976-07-08UHC-95677-2259081194627537 Park Pl, Charlotte, NC, 282460.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-24340PRVWei Cooper1944-01-22—55068335449506 Sunset Blvd # 218, Orlando, FL, 328080.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
PRV-20076PRVAlexander Medina1962-10-09—75984846123388 Forest Ave, Atlanta, GA, 303720.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-28755PRVLarry Z Ramos1943-02-14—5382622198—0.80Phone reformattedSSN last four extractedWhitespace trimmedPlaceholder values cleared
PRV-28143PRVShirley Vasquez1997-08-15UHC-77814-6870128625739094 Apache Blvd, Atlanta, GA, 303200.80Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased
PRV-28142PRVShirley Vasquez1997-08-15UHC-77814-6870128625739094 Apache Blvd, Atlanta, GA, 303200.80Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased
PRV-26394PRVSophia Ray1999-10-03—7377922231707 Valley View Dr, Austin, TX, 787370.80Date of birth reformattedCity re-casedZIP+4 trimmedPlaceholder values cleared
PRV-25803PRVChristine Fuller1976-04-25UHC-04747-1534174509379726 Valley View Dr, Glendale, AZ, 853230.80Phone reformattedCity re-casedState name converted to codePlaceholder values cleared
PRV-29350PRVJacqueline Sandoval1954-11-17—7052189275—0.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-28576PRVAlan McDonald1978-06-07—7688792119775 Jefferson Ave, Orlando, FL, 328140.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27025PRVAmanda Rogers1938-02-02UHC-77469-1391777480466473 Spring St, Glendale, AZ, 853310.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-23148PRVKenneth Johnston1958-01-24UHC-37545-66—7999 Oak St, Tempe, AZ, 852010.80Name re-casedDate of birth reformattedPhone missing area codePlaceholder values cleared
PRV-23037PRVFrank O Stephens1983-04-08—36280981968890 Lincoln Way, Chandler, AZ, 852230.80Name re-casedCity re-casedGender normalisedPlaceholder values cleared
PRV-22300PRVPriya I Price————0.80Name re-casedDate of birth missingWhitespace trimmedPlaceholder values cleared
PRV-27356PRVRalph H Morris1971-12-28—47197397932055 Forest Ave Apt 20, Austin, TX, 787180.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
PRV-20992PRVRuth Carr2006-04-27—9594544279692 Bayshore Dr, Dallas, TX, 752070.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26263PRVJosaph Stephens1975-05-21—3204081111—0.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
PRV-29330PRVIsabella Rose1991-01-19UHC-86613-44773242316823 Bayshore Dr, San Diego, CA, 921130.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23025PRVLauren Young1984-01-17——9538 Main St, Eden Prairie, MN, 553610.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-29385PRVJacob Garcia1988-02-20——4780 Meadow Ln, Seattle, WA, 981260.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-20813PRVMartha Sanchez1992-08-24UHC-34396-4572898754903891 Camelback Rd, Seattle, WA, 981860.80Name re-casedMember ID reformattedGender normalisedPlaceholder values cleared
PRV-26240PRVSofia Thompson1987-07-21—64393130664099 Willow Ct, Charlotte, NC, 282680.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-23517PRVHiroshi Martinez1946-08-27—37421498104432 Spring St # 758, Las Vegas, NV, 891820.80Date of birth reformattedPhone reformattedUnit split from streetPlaceholder values cleared
PRV-27070PRVDavid Weber1980-04-08—75568440587188 Jefferson Ave, Denver, CO, 802110.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27775PRVMegan Pena1972-03-24—38964388455555 River Rd, Nashville, TN, 372850.80City re-casedState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-29438PRVJerry Y Watson1983-04-17—68338210247251 Grand Ave, Sacramento, CA, 958400.80Name split from “Last, First”Date of birth reformattedState code upper-casedPlaceholder values cleared
PRV-24684PRVSara R Little1981-10-12UHC-34139-987209361742—0.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
9,596 rows, page 133 of 192PreviousNext