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

Claims, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-419938CLMMateo Diaz1952-06-25——2968 Apache Blvd, Houston, TX, 770850.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-405639CLMRuh Herrera1953-11-13——7181 Central Ave, Tempe, AZ, 852450.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-401636CLMLucia Gutierrez1993-06-18UHC-40274-7335360132889828 Maple Ave, Atlanta, GA, 303840.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-404255CLMJordan Ross1975-01-26——8556 Market St, Eden Prairie, MN0.64Street suffix standardisedAddress re-casedState code upper-casedZIP missing+2 more
CLM-423551CLMDoris Castillo1982-09-17——9025 Highland Ave, Columbus, OH0.64Name re-casedDate of birth reformattedZIP missingGender normalised+2 more
CLM-425021CLMMaria Henry1981-02-04——4187 Central Ave, Plano, TX, 750530.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-408501CLMJoe S Matthews1945-05-09UHC-80322-37—1238 Willow Ct, Las Vegas, NV, 891830.64Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+2 more
CLM-411920CLMJulia Adams1962-04-13UHC-29398-0562082747534202 Cedar Ln, Atlanta, GA, 303860.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418765CLMTyler Vargas1980-01-13—43463158746278 Highland Ave, Atlanta, GA0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-431312CLMArjun Miller1981-04-27UHC-66412-848375761857810 Spring St, Phoenix, AZ, 850400.64Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+2 more
CLM-428884CLMAustin Garcia1972-07-16UHC-61676-05—8689 Meadow Ln, Sacramento, CA, 958630.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-406215CLMJerry Chavez2003-09-16UHC-59936-83—5132 Baseline Rd, Phoenix, AZ, 850470.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-402857CLMOmar Vazquez1953-09-15UHC-33790-46—753 Camelback Rd, Tucson, AZ, 857520.64Member ID reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-432730CLMMadison U Thomas1945-05-25UHC-45958-44—9336 Maple Ave, Minneapolis, MN, 554400.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-420259CLMSandra X Powell1996-04-25UHC-02733-4797585055459548 Main St, Los Angeles, CA, 900260.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-425096CLMValentina T White1946-10-18UHC-42715-2059891535205207 Jefferson Ave, Gilbert, AZ, 852220.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-407201CLMRalph E Perry1979-12-08—62294618519310 Lake View Rd, Jacksonville, FL, 322470.64Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+2 more
CLM-418625CLMEdwadr Russell1991-02-21UHC-31057-9440299660997133 Meadow Ln # 832, Tucson, AZ, 857950.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-423397CLMVicky Cuok1987-07-25UHC-08669-16—2012 Ridge Rd, San Antonio, TX, 782400.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-409215CLMNicholas Patterson1974-12-05UHC-35022-2097332211829852 Washington St Apt 19, Tempe, AZ, 852590.64Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+2 more
CLM-423066CLMFrank D Diaz1943-02-03UHC-91487-7589791461675994 Church St, Dallas, TX, 752750.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408881CLMMariana D Reynolds—UHC-70487-07—5259 Palm Dr, Phoenix, AZ, 850380.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-425979CLMMark Padilla1968-04-28UHC-93890-4398356278837838 Harbor Blvd, Fresno, CA, 937480.64Phone reformattedState name converted to codeEmail lower-casedGender normalised+2 more
CLM-425635CLMJoyce Williams1955-08-15UHC-83998-1340994407577046 Oak St, Dallas, TX, 752430.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-426083CLMDouglas R Woods1940-01-07UHC-42719-1937232335462430 Elm St, Columbus, OH, 432930.64Date of birth reformattedPhone reformattedZIP+4 trimmedGender normalised+2 more
CLM-412480CLMGeorge J Larson1964-08-18UHC-26066-3940795642564673 Park Pl, Los Angeles, CA, 900470.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-422177CLMAustin Tucker1954-08-12——2721 Camelback Rd, Nashville, TN, 372060.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-424510CLMBruce I Cruz1981-12-23UHC-98583-6372749641635953 Elm St # 125, Los Angeles, CA, 900080.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-419898CLMAmy Castillo1947-04-12—97662120673849 Apache Blvd, Austin, TX0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-422819CLMKathleen Fowler2000-06-27——6825 Canyon Rd, Minneapolis, MN, 554990.64Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-409329CLMCharlotte Nunez1991-06-08—69969975363202 Meadow Ln, Phoenix, AZ, 850160.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-420491CLMMargaret F Stephens1953-06-08——1667 Park Pl # 124, Seattle, WA, 981470.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-400103CLMAnnna McDonald1972-03-16UHC-61383-31—5798 Union St, Los Angeles, CA, 900150.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-406333CLMBetty A Richards1964-11-14UHC-44493-3230447407723269 Apache Blvd, Denver, CO, 802690.64Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-417026CLMGerald Hamilton1986-10-02——6006 Spring St, San Antonio, TX, 782370.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-406198CLMChristine Murray2002-03-11—47965311143663 Oak St, Tempe, AZ, 852020.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418003CLMBetty Y Martinez1968-04-26—57934894593912 Central Ave, Los Angeles, CA, 900100.64Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-402472CLMJanice Rodriguez1992-04-26——53 Camelback Rd # 523, Dallas, TX, 752180.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-400311CLMKenneth Flores1991-11-17UHC-45261-618689873126456 Meadow Ln, Glendale, AZ, 853370.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-425420CLMPatrick Gilbert1986-05-26UHC-38235-1478170517279878 Indian School Rd, Atlanta, GA, 303000.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-429559CLMBruce Alexander1988-07-25—91988031557801 Apache Blvd, Scottsdale, AZ, 852750.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-403826CLMMari Wood1941-12-26UHC-46790-74—8674 Hillcrest Rd, Los Angeles, CA, 900070.64City re-casedState name converted to codeZIP+4 trimmedPlan code upper-cased+2 more
CLM-429455CLMJose J Yang1996-12-24UHC-79343-176139254564—0.64Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+2 more
CLM-417218CLMEdward Gomez1995-05-03UHC-65993-61—6547 Ridge Rd, Eden Prairie, MN0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-421296CLMAmanda Hall2005-05-01UHC-90296-3047824324329017 Church St, Mesa, AZ, 852150.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-403013CLMElizabeth Carr———8111 Bayshore Dr, San Antonio, TX, 782460.64Date of birth reformattedDate of birth unreadableSSN last four extractedCity re-cased+2 more
CLM-403381CLMDebra Green2003-11-26UHC-24356-5872339302794701 Washington St, Chandler, AZ, 852050.64Date of birth reformattedPhone reformattedState name converted to codeGender normalised+2 more
CLM-431655CLMKen Sims1975-11-15UHC-21958-6963775793044019 Baseline Rd, Minneapolis, MN0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-402346CLMJoan Vargas1975-09-14UHC-56474-61—5951 Maple Ave, Seattle, WA, 981750.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-421730CLMKenneth Gordon1988-08-27UHC-87982-02—9879 Union St # 283, Atlanta, GA, 303610.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
32,829 rows, page 140 of 657PreviousNext