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-28059PRVRuth L Flores1999-02-18—48077772387256 Valley View Dr, Gilbert, AZ, 852920.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-27766PRVCarl Q Porter1982-09-09—97128305867075 Willow Ct, Miami, FL, 331720.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-25797PRVSarah S Hawkins1991-12-19—83642273294993 Ocean Ave, Charlotte, NC, 282340.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-27878PRVVirginia Green1963-10-26—22920474998700 Sunset Blvd, San Diego, CA, 921260.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-23457PRVJesse S Kim1974-05-20UHC-24310-9640980568162579 Harbor Blvd, Denver, CO, 802130.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-26297PRVDyln L Bowman1983-06-22—43869764322383 Cedar Ln, Jacksonville, FL, 322370.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-28207PRVRachel Alexander2008-03-24—70027533677317 Apache Blvd # 596, Nashville, TN, 372880.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
PRV-21858PRVBetty Ramos1944-01-17UHC-55325-3288266064459450 Valley View Dr, Tucson, AZ, 857740.60Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more
PRV-26974PRVDennis Morris1956-08-01UHC-52301-4445292918011163 Willow Ct Apt 1, Minneapolis, MN, 554850.60Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
PRV-26927PRVTyler Taylor1957-10-27—42962981954037 Indian School Rd, Las Vegas, NV, 891630.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-29589PRVAlan Mendez1979-10-25UHC-71838-7658059880977393 Central Ave, Eden Prairie, MN0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-25103PRVArthur T Burke1969-01-09UHC-65754-3835635163739271 Desert Sky Blvd, Dallas, TX, 752160.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-29202PRVNicole Rice——9634760847735 Mesa Dr, Denver, CO, 802600.60Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
PRV-22675PRVJanice Marshall1952-09-07—65092035882157 Highland Ave, Scottsdale, AZ, 852510.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-20518PRVArthur N Mason1975-07-11UHC-95789-7433739743675652 Jefferson Ave, San Antonio, TX, 782660.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-25541PRVHeather Mitchell1979-10-22UHC-85304-1431572395159293 Apache Blvd Apt 12, Chandler, AZ, 852400.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
PRV-20420PRVJustin Rodriguez1953-06-15—83845295218205 Baseline Rd, Chandler, AZ, 852670.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
PRV-24061PRVNancy Millls1981-07-20UHC-00702-2847063893237380 Oak St, Charlotte, NC, 282440.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-24060PRVNancy Millls1981-07-20UHC-00702-2847063893237380 Oak St, Charlotte, NC, 282440.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-21592PRVValeentina B Duncan1952-02-08—33176674185220 Indian School Rd, Los Angeles, CA, 900890.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-23859PRVGary Miller1993-04-20—21129206336416 Harbor Blvd, Los Angeles, CA, 900380.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-23609PRVBrandon Banks1955-04-16UHC-97066-54590417759141 Central Ave, Houston, TX, 770730.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-27494PRVCharles Rojas2001-12-27UHC-80561-0233052380147847 Camelback Rd Apt 17, Los Angeles, CA, 900030.60Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
PRV-26246PRVAlexis Payne1960-09-09UHC-05678-368432121327309 Indian School Rd, Phoenix, AZ, 850620.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-25838PRVJen Guerrero1942-11-07UHC-50155-2096652901728528 Washington St, Fresno, CA, 937010.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-26809PRVTeresa Chavez1980-12-08—37178338522318 Harbor Blvd, Mesa, AZ0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-23786PRVWilliam X Rodriguez1968-09-04—22333758825466 Church St, Gilbert, AZ, 852390.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-24715PRVTimothy Robertson1952-01-06UHC-04478-9742495150292331 Valley View Dr, Orlando, FL, 328200.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-24822PRVEdward K Cox1978-07-11—42989139468251 Sage Ct, Houston, TX, 770230.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-28345PRVMartha E Estrada1990-04-12UHC-83322-4752937480784612 Park Pl, Miami, FL, 331640.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-26038PRVSean Padilla1952-08-23UHC-71398-0428023960171293 Harbor Blvd, Eden Prairie, MN, 553460.60Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
PRV-21973PRVMadison Hamilton1990-02-09—22179027332720 Forest Ave, Scottsdale, AZ, 852880.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-20305PRVJoan Singh1960-03-25—72489196135676 Palm Dr, Eden Prairie, MN, 553170.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-23166PRVWillie V Dunn1967-09-07UHC-04570-8823744123957513 Jefferson Ave, Minneapolis, MN, 554760.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-25276PRVJordan Mitchell1999-01-13UHC-41287-909138838022882 Lake View Rd, Dallas, TX, 752810.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-22365PRVAngela E Saazar2001-02-03UHC-20499-9368467236469038 Lincoln Way, Atlanta, GA, 303620.60Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
PRV-21090PRVDonna Hughes1994-12-11UHC-61161-6782086455085811 Desert Sky Blvd, Columbus, OH0.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-28507PRVSteven Cunningham1982-11-19UHC-73884-4054261804399570 Palm Dr, Jacksonville, FL, 322170.60Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
PRV-25572PRVTheresa Austin1996-09-22UHC-47101-3789060880008576 Canyon Rd, Mesa, AZ, 852450.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-22765PRVBobby Perz2005-02-16—6677276081669 Ridge Rd, Plano, TX0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-26241PRVHelenJunk1991-05-18UHC-00390-6067820759025356 Oak St, Dallas, TX, 752170.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-28501PRVSusan Diaz1963-09-01UHC-72659-1531156214739143 Desert Sky Blvd, Phoenix, AZ, 850090.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
PRV-25789PRVHenry C Brooks1980-08-28UHC-09209-8720869813979799 Pine Dr, Denver, CO, 802170.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-25262PRVWayne D Castro1950-09-06—81499129852524 Baseline Rd Apt 24, Sacramento, CA, 958620.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
PRV-23978PRVEthan Morgan1939-03-26—83787157816874 Baseline Rd, Fresno, CA, 937150.60Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
PRV-27496PRVAhmed V Montgomery1993-10-05UHC-74670-8289738740356407 Grand Ave, Tempe, AZ0.60Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
PRV-27934PRVJon Weber1998-03-17—86733426884212 Maple Ave, Gilbert, AZ, 852390.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-26393PRVThomas Rodriguez1948-09-10—83564597106430 Maple Ave, Minneapolis, MN, 554970.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-25332PRVDylan Watkins1957-02-07UHC-98153-1062632978887577 Highland Ave, Glendale, AZ, 853780.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-28403PRVLarry Bishop1967-05-20UHC-45766-3952888717543231 Mountain View Dr # 403, Mesa, AZ, 852610.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
9,596 rows, page 26 of 192PreviousNext