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-21798PRVRandy X McCoy1974-02-12—2436270035—0.80Email lower-casedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-23290PRVKelly F Wheeler1975-11-17UHC-91238-9295798729024067 Washington St, Orlando, FL, 328550.80Phone reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-20602PRVNatalie T Palmer1973-09-04UHC-30236-517367744331—0.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-23443PRVCynthia P Elliott1961-02-13—83850300868657 Mountain View Dr, San Diego, CA, 921720.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-20096PRVPhilip Cole1991-03-27—41380169404966 Forest Ave, Denver, CO, 802830.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-28535PRVJocye Baker——6037111101—0.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-20944PRVSamuel V Santiago1981-08-01UHC-16102-103854959264—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-21940PRVSean Bradley1941-10-28—42131292598159 Ridge Rd # 853, San Diego, CA, 921680.80Date of birth reformattedPhone reformattedUnit split from streetPlaceholder values cleared
PRV-27360PRVAshley Moore1966-04-16—2739035923—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-27359PRVAshley Moore1966-04-16—2739035923—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-20837PRVPatrick McDonald1961-09-01UHC-20249-5764355007288384 Baseline Rd, Jacksonville, FL, 322860.80Name re-casedTwo-digit birth yearPhone reformattedPlaceholder values cleared
PRV-24514PRVBrandon Rivera1991-04-07UHC-19255-3377355219655041 Jefferson Ave, Glendale, AZ, 853280.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-26802PRVDavid A Singh1940-09-12UHC-97681-4979669277756257 Canyon Rd # 356, Houston, TX, 770510.80Name re-casedUnit split from streetWhitespace trimmedPlaceholder values cleared
PRV-27739PRVStephen Morrison1999-05-03UHC-09325-936654978473141 Indian School Rd, Las Vegas, NV, 891450.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25034PRVKenneth Henry2001-05-17—52455426234427 Forest Ave, Dallas, TX, 752080.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-22211PRVStven Ellis1944-12-28UHC-97673-7649180304326255 Park Pl, Jacksonville, FL, 322720.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21447PRVCarl Dean1972-03-28—57684437609585 Oak St, Tampa, FL, 336420.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
PRV-23874PRVKeith V Smith1997-05-06UHC-42383-6841348457368139 Washington St, Jacksonville, FL, 322750.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-24768PRVSandra O Campbell——57264508168853 Hillcrest Rd, Tampa, FL, 336780.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
PRV-26248PRVSharonJunk1980-02-01—5148055266653 Ocean Ave, San Diego, CA, 921670.80Name re-casedPhone reformattedPlaceholder values clearedNo usable name (quarantined)
PRV-27204PRVGerald Olson2002-01-08—31046446295297 Pine Dr, Jacksonville, FL, 322460.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-24385PRVHiroshi H Parker1979-07-03UHC-03341-1926930587338871 Ocean Ave, Houston, TX, 770280.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23535PRVMelssa I Yaang1987-12-10UHC-44188-6558587993685216 Bayshore Dr, Orlando, FL, 328970.80Phone reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-27462PRVThomas Gonzalez1975-09-24UHC-73038-5689239219821811 Indian School Rd, Phoenix, AZ, 850240.80Phone reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-28315PRVSandra Johnston1987-04-23—37064069718467 Sunset Blvd, Austin, TX, 787170.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
PRV-27718PRVMark M Marquez1953-02-28—71064276613821 Ridge Rd, Las Vegas, NV, 891330.80Name re-casedCity re-casedState name converted to codePlaceholder values cleared
PRV-21732PRVPeter Sullivan1991-10-16—26831553409057 Broadway, Charlotte, NC, 282560.80Name re-casedCity re-casedGender normalisedPlaceholder values cleared
PRV-24240PRVEmma McDonald2004-12-11UHC-13241-2534730941692008 Central Ave, Jacksonville, FL, 322170.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26515PRVJanet Tran1986-08-20UHC-03218-9667090171222658 Broadway, Phoenix, AZ, 850180.80Name re-casedPhone reformattedState name converted to codePlaceholder values cleared
PRV-26514PRVJanet Tran1986-08-20UHC-03218-9667090171222658 Broadway, Phoenix, AZ, 850180.80Name re-casedPhone reformattedState name converted to codePlaceholder values cleared
PRV-27798PRVGerald Robertson1945-09-20UHC-52253-1438079006152789 Palm Dr Apt 26, Phoenix, AZ, 850830.80Date of birth reformattedMember ID reformattedUnit split from streetPlaceholder values cleared
PRV-20005PRVSophia Ramirez——7196681436—0.80Date of birth missingEmail lower-casedWhitespace trimmedPlaceholder values cleared
PRV-26488PRVGary Hill1955-03-23—48967133631930 Apache Blvd, Seattle, WA, 981480.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-28162PRVCarol Baker1956-10-28UHC-48163-5285382495523917 Maple Ave, Houston, TX, 770060.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-22707PRVTerry Rvera1993-04-10UHC-56476-0523394556834242 Hillcrest Rd, Miami, FL, 331590.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-24727PRVLucia Hawkins2008-01-14UHC-18251-3743453739506889 Ocean Ave, Tempe, AZ, 852180.80Date of birth reformattedPhone reformattedZIP+4 trimmedPlaceholder values cleared
PRV-21621PRVGeorge Sanchez1978-02-18—43698334652945 Elm St, Miami, FL0.80Name re-casedPhone reformattedZIP missingPlaceholder values cleared
PRV-23629PRVWei Alexander2000-09-27—47898909915244 Camelback Rd, Phoenix, AZ, 850190.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-24609PRVFrank Bishop1987-09-21—30866369325597 Willow Ct, Las Vegas, NV, 891240.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25805PRVBradley F Patterson1990-01-05—2059186356859 Valley View Dr, Scottsdale, AZ, 852410.80Date of birth reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-27869PRVGeorge Gonzzales1944-02-26UHC-26152-277047922841—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-27396PRVTim Clark1948-06-25—70489758601128 Broadway, Phoenix, AZ, 850740.80Phone reformattedCity re-casedZIP+4 trimmedPlaceholder values cleared
PRV-25796PRVBryan Walker1962-11-10—8027789037385 Oak St, Miami, FL, 331440.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-29519PRVStephen West1942-02-06UHC-89184-9336598074901006 Market St, Houston, TX, 770650.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-24959PRVKayla Riley2002-07-20UHC-81765-334152342567—0.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-26232PRVAlexis Bowman2006-05-09UHC-55664-0774422020714239 Ridge Rd, Chandler, AZ, 852580.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25048PRVFrank Knight1986-12-16———0.80Date of birth reformattedPhone missing area codeWhitespace trimmedPlaceholder values cleared
PRV-28998PRVNatalie Fisher1947-12-27——1004 Valley View Dr, Austin, TX, 787570.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
PRV-28554PRVAisha I Powell1963-07-22—5429453518—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-25071PRVSusan Jakkson1997-01-05—86780209464616 Sunset Blvd, Chandler, AZ, 852900.80Name re-casedPhone reformattedState name converted to codePlaceholder values cleared
9,596 rows, page 139 of 192PreviousNext