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

All sources, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-113724ENRNathan S Sanchez1949-11-13UHC-34921-7497962435034029 Pine Dr Apt 11, Houston, TX, 770930.32Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more
CLM-405092CLMJonathan P Bell1988-02-22UHC-75396-8965590206714740 Forest Ave, Sacramento, CA, 958960.32Name split from “Last, First”Middle initial moved out of first nameTwo-digit birth yearPhone reformatted+6 more
CLM-425489CLMKelly Stephens1994-10-12UHC-33651-42—5799 Main St Apt 33, Fresno, CA, 937330.32Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+6 more
ENR-119540ENRShirley Z Russell1975-04-25UHC-17459-8972295814306139 Spring St # 518, Miami, FL, 331910.32Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+6 more
ENR-113215ENRWei P Park1944-05-28UHC-43011-3374844225291301 Main St # 261, Plano, TX, 750910.32Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+6 more
TPA-63147TPAMichael S Romero——9586948183118 Washington St Apt 8, Tucson, AZ, 857720.32Name re-casedDate of birth unreadablePhone reformattedUnit split from street+6 more
ENR-132033ENRDouglas Shaw2003-06-09UHC-63265-5373036020957808 Union St, San Diego, CA, 921290.32Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+6 more
ENR-100543ENRDouglas E Reyes1968-09-09UHC-89598-4229621064017814 Central Ave, Scottsdale, AZ, 852840.32Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
CLM-404261CLMBevverly Cruz1984-09-25UHC-18244-8352443386836302 Harbor Blvd # 691, Seattle, WA, 981890.32Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more
CLM-427327CLMMelissa Anderson1947-01-17UHC-80083-7043023456426687 Baseline Rd # 400, Seattle, WA, 981030.32Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+6 more
CLM-414589CLMLaryr Franklin—UHC-07734-4589450555158091 Sunset Blvd Apt 17, Atlanta, GA, 303110.32Name re-casedDate of birth missingPhone reformattedUnit split from street+6 more
ENR-124296ENRWei W Garrett1986-11-10UHC-19525-85—2747 Harbor Blvd, Seattle, WA0.32Name re-casedDate of birth reformattedPhone missing area codeMember ID reformatted+6 more
ENR-119894ENRLaura R Stevens1994-12-28UHC-21915-7341833689444388 Jefferson Ave, Chandler, AZ0.32Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+6 more
CLM-403169CLMAnn Gilbert2004-10-07UHC-20636-06—2196 Sage Ct, Chandler, AZ0.32Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+6 more
ENR-106071ENRPriya M Vasquez2002-08-06UHC-73382-0957236855389473 Maple Ave, Plano, TX0.32Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+6 more
ENR-128034ENRSantiago Green1998-04-02UHC-12115-2481388245266800 Canyon Rd # 512, Columbus, OH0.32Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+6 more
PRV-23306PRVMargaret Cruz2000-01-09UHC-61807-7179196381519104 Jefferson Ave # 302, Glendale, AZ, 853530.32Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more
CLM-420757CLMKenneth Dunan1946-12-23—66684269316472 Indian School Rd # 106, Orlando, FL0.32Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more
PRV-22562PRVAna Ray2008-03-10—7314391317467 Harbor Blvd Apt 39, Atlanta, GA0.32Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more
TPA-57039TPAAlan Marquez—UHC-88620-29—2304 Central Ave, Fresno, CA, 937420.32Name re-casedDate of birth missingMember ID reformattedStreet suffix standardised+6 more
CLM-400338CLMRalph Little1941-02-04—84878061623843 Elm St # 201, Tucson, AZ, 857600.32Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+6 more
CLM-400233CLMAusttin Stone1949-11-17UHC-55219-4846255305744169 Jefferson Ave # 603, Chandler, AZ, 852520.32Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more
ENR-113591ENRVirginia P Hall1987-05-17UHC-97106-2721937287971081 Oak St, Tempe, AZ, 852360.32Middle initial moved out of first nameName re-casedDate of birth reformattedStreet suffix standardised+6 more
TPA-52838TPACarolyn Carter1950-11-24UHC-48342-14—3394 Park Pl, Tampa, FL, 336320.32Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+6 more
ENR-115013ENRAshley O Ryan1968-11-18UHC-36732-5555070504649051 Spring St Apt 19, San Antonio, TX, 782700.32Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+6 more
ENR-115014ENRAshley O Ryan1968-11-18UHC-36732-5555070504649051 Spring St Apt 19, San Antonio, TX, 782700.32Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+6 more
ENR-117025ENRDavid L Herrera1981-04-04UHC-41384-5148993257943549 Palm Dr Apt 2, Las Vegas, NV0.34Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+5 more
CLM-430427CLM—Junk1968-03-23—88957938375967 Willow Ct, Eden Prairie, MN, 553290.34Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+5 more
ENR-117394ENRFrank Q Bailey1949-06-25UHC-20314-3341259969557687 Indian School Rd, Las Vegas, NV, 891500.34Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+5 more
CLM-414853CLMPeter Gilbert1961-12-23—31825301044458 Canyon Rd, Tucson, AZ0.34Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-119644ENRMarcus Carlson1952-10-07UHC-22047-6152965219194973 Spring St # 808, Orlando, FL, 328760.34Name re-casedPhone reformattedMember ID reformattedSSN last four extracted+5 more
CLM-403740CLMGerald Cunningham1983-06-15—53921547187237 Camelback Rd Apt 4, Nashville, TN, 372950.34Name split from “Last, First”Two-digit birth yearPhone reformattedUnit split from street+5 more
TPA-55953TPAKenneth Contreras1987-05-02—27850051809101 Ridge Rd # 840, Atlanta, GA0.34Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+5 more
CLM-416065CLMRalph Myers1966-04-05—40939835823366 Hillcrest Rd Apt 38, Glendale, AZ0.34Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+5 more
ENR-122845ENRRuth E Patterson1998-03-24UHC-86334-2582532903398110 Oak St, Mesa, AZ0.34Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-420582CLMCral Smith1960-09-16UHC-10143-60—1255 Jefferson Ave, Minneapolis, MN, 554610.34Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-421015CLMAdam Williamson—UHC-12020-33—2283 Valley View Dr, Miami, FL0.34Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+5 more
ENR-129164ENRGabriel H Bradley1946-03-05UHC-00034-6246843868331795 Church St, Fresno, CA, 937420.34Middle initial moved out of first nameDate of birth reformattedPhone reformattedMember ID reformatted+5 more
CLM-403639CLMDorothy Gonzalez—UHC-11908-7971144796862871 Elm St, Tempe, AZ, 852510.34Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-103015ENRAngela Williams1995-05-28UHC-24589-9043981503727312 Meadow Ln Apt 38, Jacksonville, FL0.34Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+5 more
ENR-139968ENRBradley Padilla1960-11-01UHC-20978-259146679296863 Indian School Rd, Tampa, FL, 336100.34Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+5 more
ENR-138491ENRCarl Yang1971-09-16UHC-09711-5457327091267828 Central Ave, Plano, TX, 750170.34Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-427890CLMEmily Palmer1961-07-18—44994928387132 Forest Ave Apt 21, Nashville, TN, 372240.34Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+5 more
PRV-22866PRVGary L Burton1963-10-18—92676244809473 Harbor Blvd, Tucson, AZ0.34Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-115626ENRNatalie Z Garza—UHC-86293-5351269874466728 Elm St, Austin, TX, 787940.34Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+5 more
ENR-107309ENRJun R Simpson1953-03-05UHC-71857-2470933974274156 Sunset Blvd, Jacksonville, FL, 322110.34Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-26412PRVAlan G Bradley1971-09-10UHC-99205-78—5458 Oak St, Tampa, FL, 336330.34Name re-casedTwo-digit birth yearMember ID reformattedSSN last four extracted+5 more
CLM-423140CLMVirginia C Boyd2006-01-27—28786545807938 Harbor Blvd, San Antonio, TX, 782390.34Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+5 more
CLM-422779CLMDylan Luna1956-01-18UHC-88278-1553055406519845 Camelback Rd Apt 21, Plano, TX, 750730.34Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more
PRV-28492PRVShirley I Webb1995-02-11UHC-31639-6428629847859083 Hillcrest Rd, Tempe, AZ, 852640.34Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
100,000 rows, page 7 of 2,000PreviousNext