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-27873PRVChristina T Lawrence2006-09-09—92470996078599 Sage Ct, Chandler, AZ, 852790.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21200PRVJulia Hunt1965-02-23——9025 Cedar Ln, Seattle, WA, 981610.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-28247PRVRuth Meier2005-06-19UHC-88349-278647358107—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-29229PRVEmma Richardson1980-10-14—7188204004877 Central Ave, Phoenix, AZ, 850580.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
PRV-29228PRVEmma Richardson1980-10-14—7188204004877 Central Ave, Phoenix, AZ, 850580.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
PRV-21694PRVJulia McDonald1999-01-04—90390039889310 Washington St, Houston, TX, 770280.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-24969PRVDorothy Johnson1991-08-11——2664 Elm St, Orlando, FL, 328800.80Name re-casedCity re-casedGender normalisedPlaceholder values cleared
PRV-28982PRVOlivia Myers2008-06-12UHC-72847-859597923349369 Apache Blvd, Los Angeles, CA, 900230.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28114PRVMargaret Yang1987-12-28UHC-98394-52972382051345 Park Pl, Tucson, AZ, 857170.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27340PRVCarol C Meyer1979-07-21UHC-67181-8424294895813897 Camelback Rd, Nashville, TN, 372650.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
PRV-26970PRVCarol M Franklin1938-04-22UHC-98866-3022453071408103 Union St, Tempe, AZ, 852920.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27987PRVSandra L Wilson1938-12-11—39980360073901 Forest Ave, Dallas, TX, 752450.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
PRV-21139PRVKathryn Bowman1949-01-08—9587770732—0.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
PRV-21138PRVKathryn Bowman1949-01-08—9587770732—0.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
PRV-26633PRVDanielle Lawrence1983-11-02—76986632169652 Mesa Dr, Houston, TX, 770690.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25590PRVMartha Gardner1995-11-13—40332811795940 Pine Dr, Columbus, OH, 432070.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-22806PRVKevin Willis1965-03-08—33498203883862 Washington St, Denver, CO, 802310.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21307PRVSusan Perez1949-07-28UHC-63932-3376326151464019 Sage Ct, Nashville, TN, 372550.80Phone reformattedCity re-casedZIP+4 trimmedPlaceholder values cleared
PRV-28381PRVDebra Rios1947-12-07——9593 Valley View Dr, San Antonio, TX, 782440.80Name re-casedState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-24991PRVMichael Barnes1951-12-12UHC-61882-3828837898988521 Desert Sky Blvd, Jacksonville, FL, 322200.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-29367PRVSantiago Burton1998-05-26—44283023083029 Willow Ct, Orlando, FL, 328970.80Phone reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
PRV-23830PRVJeffrey Black1992-05-01—58152226304422 Palm Dr, Eden Prairie, MN, 553070.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
PRV-26367PRVFrank Carpenter1999-02-27UHC-16808-1272227783461999 Cedar Ln, Austin, TX, 787370.80Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared
PRV-22383PRVRyan Robinnson1946-08-04—5448338811—0.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
PRV-21609PRVTimothy T Soto2005-11-09—37067303425441 Sunset Blvd, Phoenix, AZ, 850680.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-27731PRVPatrick D Lewis1939-02-28UHC-79870-1033998182139157 Camelback Rd, Dallas, TX, 752860.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-26966PRVRandy Soto1943-12-07UHC-23233-3283369148748000 Pine Dr, Dallas, TX, 752310.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21445PRVSamuel K Cruz1982-01-09—8487267946—0.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-26700PRVLori P Hamilton1961-09-04—84935195585330 Main St, Columbus, OH, 432050.80Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased
PRV-26671PRVLawrence M Gonzalez1989-09-19—31140868874187 Spring St, Phoenix, AZ, 850360.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-23957PRVAngela Mills1960-06-23UHC-64930-033153350659293 Indian School Rd, Atlanta, GA, 303920.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-29363PRVRandy Scott1973-03-08UHC-99947-2043261789202010 Sunset Blvd, Tampa, FL, 336250.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28107PRVAlexis Bennett1968-06-04UHC-65598-1496743338538577 Broadway, Sacramento, CA, 958820.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-26781PRVDoris Meija1971-01-16—30233891225866 Maple Ave, Atlanta, GA, 303150.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21154PRVGreg Barnes2008-07-05—41023281431753 Bayshore Dr, Dallas, TX, 752410.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26579PRVMaria Cunningham1959-10-20UHC-51601-8589880858327075 Pine Dr, Los Angeles, CA, 900080.80Name re-casedTwo-digit birth yearPhone reformattedPlaceholder values cleared
PRV-27432PRVMariana Campbell2008-05-15———0.80Name re-casedDate of birth reformattedPhone missing area codePlaceholder values cleared
PRV-29194PRVWalter Munoz2002-05-12—50253521406152 Sage Ct Apt 24, Seattle, WA, 981560.80Name re-casedPhone reformattedUnit split from streetPlaceholder values cleared
PRV-23022PRVHeather Q Crawford1966-01-27——5137 Ridge Rd Apt 5, Chandler, AZ, 852860.80Name re-casedUnit split from streetWhitespace trimmedPlaceholder values cleared
PRV-24379PRVKathryn T Gonzalez1988-08-13——4472 Main St, Minneapolis, MN, 554830.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-26550PRVWei Smith1975-11-07—29633207835845 Camelback Rd, Nashville, TN, 372260.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-21429PRVJosh Castro2008-03-20—61659942105488 Union St, Denver, CO, 802180.80Phone reformattedState name converted to codeEmail lower-casedPlaceholder values cleared
PRV-27932PRVDaniel Y Jensen1974-09-12UHC-77446-0591780225373605 Baseline Rd, Chandler, AZ, 852390.80City re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-28860PRVMariana Mitchell1972-03-12UHC-47406-207717381941762 Sage Ct, Tempe, AZ, 852030.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-28908PRVRalph Garcia1945-04-22UHC-55034-7437357843472592 Forest Ave, Miami, FL0.80Name re-casedCity re-casedZIP missingPlaceholder values cleared
PRV-26457PRVKayla Rice1997-11-11UHC-34816-4051062580983442 Church St, Gilbert, AZ, 852720.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28363PRVNicole Nunez1991-08-12—48780634471464 Cedar Ln, Austin, TX, 787470.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-22097PRVChristian Yang1945-08-01—9002477102—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-24251PRVKelly Patteson1948-12-03UHC-93961-326053798623124 Grand Ave, Gilbert, AZ, 852590.80Name re-casedTwo-digit birth yearPhone reformattedPlaceholder values cleared
PRV-21660PRVMary Schmidt1977-05-21——6452 Harbor Blvd, Miami, FL, 331320.80Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared
9,596 rows, page 137 of 192PreviousNext