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-24348PRVPatrikk Nguyen2001-11-21UHC-62124-1269625712254943 Elm St, Sacramento, CA, 958090.74Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28432PRVGregory Pena1944-04-24UHC-46769-6352376986011872 Meadow Ln, Columbus, OH, 432180.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-21458PRVSantiago Torres1961-06-15—25962440745968 Park Pl, Tucson, AZ, 857560.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20521PRVVirginia E Castillo1992-06-06UHC-00947-15—6133 Canyon Rd, Los Angeles, CA, 900900.74Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-28096PRVTyler Sanders1995-01-19—64972440731664 Forest Ave, Minneapolis, MN, 554560.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23920PRVBradley N Johnson1940-08-14UHC-61999-9052157061595772 Ocean Ave, Mesa, AZ, 852920.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-25014PRVNaatlie Shaw1966-08-15UHC-04451-662396014239491 Palm Dr, Sacramento, CA, 958190.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20168PRVDiego Sanchez1965-02-07UHC-13365-2859054751009567 Park Pl, Charlotte, NC, 282310.74Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+3 more
PRV-28716PRVSam Rodriguez1969-03-03UHC-63074-7820755114673532 Sage Ct # 296, Sacramento, CA, 958430.74Name re-casedPhone reformattedMember ID reformattedUnit split from street+3 more
PRV-27434PRVAlan Wheeler1941-03-09—20664425242513 Bayshore Dr, Las Vegas, NV, 891670.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-25575PRVRobert B Washingtun1969-04-03UHC-52616-95—8721 Apache Blvd, Miami, FL, 331460.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-29184PRVChristina A Silva1989-01-20—55249320054021 Maple Ave, Las Vegas, NV, 891610.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-27642PRVRuth Z Ross1970-04-21—53925676513071 Canyon Rd, Phoenix, AZ, 850960.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-28415PRVFrances Carlson1966-02-26UHC-63471-0551289714806154 Grand Ave, Tampa, FL, 336080.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-28338PRVElijah Z Le1964-09-23UHC-95173-48—9800 Elm St, Fresno, CA, 937090.74Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-25289PRVAdam O Rodriguez1997-06-16—44853796567818 Oak St, San Diego, CA, 921310.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-21844PRVDunn Terry1970-06-22—41931524491568 Cedar Ln, San Antonio, TX, 782020.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-26805PRVAlan Adams1967-08-10UHC-50559-2228049517663569 Meadow Ln, Minneapolis, MN, 554800.74Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+3 more
PRV-27941PRVMarilyn Guerrero1997-05-12UHC-29798-3293156634243267 Mesa Dr, Orlando, FL, 328040.74Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
PRV-20552PRVCatherine J Bishop1967-10-17—2628916417513 Ocean Ave, Tempe, AZ, 852210.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-26168PRVGrace N Patterson1983-10-22UHC-65183-7495790548032433 Forest Ave, Jacksonville, FL, 322140.74Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-25040PRVJuan George1969-10-12UHC-51548-976812589562416 Hillcrest Rd, Austin, TX, 787900.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28433PRVAndrea Boyd2001-04-15—42881026096842 Harbor Blvd, Columbus, OH, 432080.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-20616PRVNancy Carr1981-10-16UHC-63787-773997255243489 Market St, Sacramento, CA, 958550.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-24328PRVCarlos U Ramos1967-06-09UHC-80608-7763476249872238 Indian School Rd, Tempe, AZ, 852550.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-25251PRVBrenda H Santiago1995-01-10—56373279617882 Washington St, Glendale, AZ, 853770.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-25399PRVOmar Rivera1956-11-01UHC-34231-8095090407272530 Sunset Blvd, Tampa, FL, 336360.74Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+3 more
PRV-25636PRVMark Greene1991-10-25UHC-68929-3824548011479173 Meadow Ln, Dallas, TX, 752230.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22548PRVBailey Harold1979-08-05——2892 Maple Ave, Tucson, AZ, 857560.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-29342PRVCharles Jordan1963-03-19—85623250249327 Pine Dr, Las Vegas, NV, 891680.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-25618PRVMateo Wilson1980-06-19—44164711254537 Highland Ave, Dallas, TX, 752360.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-26357PRVGeorge Robinson1999-01-11—95891385364700 Highland Ave, Miami, FL, 331600.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-24241PRVNoah Garrett1948-06-17UHC-99638-9179522689323201 Sunset Blvd, Charlotte, NC, 282460.74Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
PRV-23834PRVAnn X Fields1946-01-03UHC-32591-8128028245565259 Valley View Dr, Tempe, AZ, 852410.74Date of birth reformattedPhone reformattedCity re-casedZIP+4 trimmed+3 more
PRV-28936PRVArnold U Kethleen1967-02-03UHC-42875-9682169023715324 Willow Ct, Minneapolis, MN, 554960.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-23242PRVHelne Robinson1996-03-10—65320549411332 Hillcrest Rd, Atlanta, GA, 303780.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-29429PRVLisa S Nelson1971-08-13UHC-22297-4649475616744376 Mesa Dr, Scottsdale, AZ, 852890.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-20895PRVCarlos Z Davis1969-10-11—92489048467596 Indian School Rd, Phoenix, AZ, 850980.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-22605PRVElizabeth Bell1969-12-27UHC-65359-8734764913584741 Hillcrest Rd, Dallas, TX, 752490.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-27482PRVJoan Santos1978-01-04—53354372948108 Ridge Rd, Dallas, TX, 752080.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28251PRVBruce Garrett1950-06-24UHC-17603-9041555484879636 Bayshore Dr, Columbus, OH, 432990.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-22040PRVDiane Gibson1978-01-07—72892136288641 Highland Ave, Austin, TX, 787200.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-25919PRVRalph Jacobs1982-04-19UHC-34844-1464690232873178 Lincoln Way, Jacksonville, FL, 322710.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-26140PRVDanielle Russell1991-07-01—47391648772379 Forest Ave, Tucson, AZ, 857370.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-28877PRVPamela Wallace1988-03-20—68770750108337 Bayshore Dr, Tempe, AZ, 852980.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-25383PRVChristopher Cunningham1990-03-02UHC-09111-6987758720869136 Apache Blvd, Seattle, WA, 981200.74Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more
PRV-25598PRVArjun Rojas1990-12-11—45945416019833 Jefferson Ave, Chandler, AZ, 852990.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-25513PRVEthan Davis1973-12-20—62920194416281 River Rd, Eden Prairie, MN, 553440.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-26570PRVAmber Hamilton1988-09-26UHC-84817-8736444573213555 Forest Ave, Mesa, AZ, 852740.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-20291PRVChristian I Williamson1974-08-05UHC-01208-7766467025643455 Oak St, Chandler, AZ, 852850.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
9,596 rows, page 84 of 192PreviousNext