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-27795PRVSofia S Soto1964-02-12UHC-89751-9057675256122267 Spring St, Atlanta, GA, 303400.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-21282PRVGabriel Campbell1941-09-14——1460 Pine Dr, Plano, TX, 750010.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
PRV-28901PRVChristina V Mills1968-09-02—72273015262856 Grand Ave, Fresno, CA, 937370.66Middle initial moved out of first namePhone reformattedGender normalisedWhitespace trimmed+1 more
PRV-22233PRVMelissa Valdez1954-02-10——962 Valley View Dr, Dallas, TX, 752280.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
PRV-24270PRVCharlie Palmer2001-02-02UHC-16746-0293364518199260 Palm Dr, Las Vegas, NV0.66Street suffix standardisedAddress re-casedCity re-casedZIP missing+1 more
PRV-24575PRVAlexander Barnes1958-02-19—68445145175295 Main St, Charlotte, NC, 282360.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
PRV-26337PRVMegan A Berry1943-10-26UHC-79894-32—6422 Highland Ave, Sacramento, CA, 958880.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
PRV-27392PRVSofia Ortiz1995-11-04UHC-16134-88—3988 Lincoln Way, Jacksonville, FL, 322420.66Phone missing area codeState name converted to codeEmail lower-casedWhitespace trimmed+1 more
PRV-23308PRVJoe O Adams2008-05-04UHC-31330-6256663613272370 Canyon Rd, Atlanta, GA, 303260.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-28317PRVFrances Berry1968-02-08UHC-64195-37—384 Highland Ave, Minneapolis, MN, 554060.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-29594PRVEugene V Daniels1994-02-05—69081896849891 Oak St, Mesa, AZ0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-22875PRVMariana Le1997-11-10—3095152774733 Lake View Rd, Dallas, TX, 752430.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
PRV-22577PRVGary Stone1939-03-24UHC-26978-96—7116 Camelback Rd, Nashville, TN, 372940.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-22389PRVShirley H Welch1944-11-10—50961026145380 Washington St, Miami, FL, 331470.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-25466PRVMegan Ford2008-05-18UHC-44478-63—1688 Bayshore Dr # 942, Columbus, OH, 432310.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-27668PRVJason Ross1952-10-22—75942405251716 Maple Ave # 669, Gilbert, AZ, 852780.66Name re-casedUnit split from streetState name converted to codeWhitespace trimmed+1 more
PRV-27588PRVJason Ruiz2000-12-27—5813823891—0.66Name split from “Last, First”Two-digit birth yearPhone reformattedWhitespace trimmed+1 more
PRV-21417PRVJerry Hawkins1982-08-16UHC-79567-63—2004 Sunset Blvd, Dallas, TX, 752800.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-20222PRVPena O Janet1944-10-07——3537 Valley View Dr, Minneapolis, MN, 554620.66Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
PRV-23129PRVEdward Daniels1985-10-27UHC-52432-1133431721638035 Central Ave, Tampa, FL, 336150.66Two-digit birth yearPhone reformattedState name converted to codeEmail lower-cased+1 more
PRV-26585PRVNoah Woods1969-10-02——3225 Church St, Glendale, AZ, 853370.66Name split from “Last, First”Date of birth reformattedGender normalisedWhitespace trimmed+1 more
PRV-27173PRVHelen Hudson1992-12-26—44522048833802 Elm St, Jacksonville, FL, 322330.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-29570PRVLinda Bishop1942-05-16UHC-76949-1145470078951478 Maple Ave # 884, Jacksonville, FL0.66Name re-casedDate of birth reformattedUnit split from streetZIP missing+1 more
PRV-23142PRVJacqueline F Flores1939-12-16UHC-03070-5342852780694401 Union St, Las Vegas, NV0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-24823PRVRonald Q Brown1964-02-24——758 Elm St, Mesa, AZ, 852040.66Middle initial moved out of first nameName re-casedDate of birth reformattedPhone missing area code+1 more
PRV-24202PRVTyler M Woods1982-04-20UHC-14817-37—7877 Ridge Rd, Houston, TX0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-29498PRVHiroshi Williams1950-01-04—8202222304232 Mountain View Dr, Denver, CO, 802750.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-24135PRVBryant Cynthia1971-11-16—37746821745310 Washington St, Los Angeles, CA, 900110.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-21736PRVMichael Wells1953-10-18—62857839244425 Mesa Dr, Charlotte, NC, 282540.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-21626PRVMark Vargas1982-06-13—63824183797658 Oak St, Phoenix, AZ, 850190.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-25196PRVAlbert Cruz1991-04-19——8046 Camelback Rd, Seattle, WA, 981370.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
PRV-28682PRVAisha McCoy2004-08-22UHC-89978-225824146818354 Market St, San Diego, CA, 921980.66Name split from “Last, First”Phone reformattedGender normalisedPlan code upper-cased+1 more
PRV-23353PRVHelen West1958-11-03UHC-25626-7592062631186857 Union St, Miami, FL, 331900.66Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+1 more
PRV-24093PRVChristian Hghes1942-03-18UHC-52016-6760747287642182 Desert Sky Blvd, Chandler, AZ, 852370.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
PRV-20828PRVDennis Gutierrez1984-04-08UHC-41524-3995263272839635 Mountain View Dr, Seattle, WA, 981320.66Date of birth reformattedMember ID reformattedState name converted to codeGender normalised+1 more
PRV-20003PRVShirley Hernandez——46077387961513 Baseline Rd, Eden Prairie, MN, 553410.66Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-21095PRVVictoria Ford1988-05-02UHC-37553-9836963943421293 Mountain View Dr Apt 18, Miami, FL, 331640.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-28141PRVAbigail Daniels1969-05-18—36175800336875 Indian School Rd # 625, Los Angeles, CA, 900590.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-25342PRVLisa Q Lee1970-07-14—5949070880589 Elm St, Nashville, TN0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-21173PRVPter Li1990-06-04——4194 Washington St, Minneapolis, MN, 554400.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
PRV-23222PRVSandra Snyder1952-02-28UHC-06644-6056831094683716 Washington St, Las Vegas, NV, 891400.66Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
PRV-26901PRVEric Bowman1972-09-14——6475 Pine Dr, Orlando, FL, 328450.66Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
PRV-26981PRVJulia Walker1973-07-13UHC-38007-53—8617 Apache Blvd Apt 36, Plano, TX, 750770.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-21400PRVHeather Myers1958-01-04UHC-23811-9843799555585967 Ridge Rd # 439, Phoenix, AZ, 850390.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-22860PRVAlbert O Williams1960-08-14UHC-50412-2566026754245057 Forest Ave, Austin, TX, 787270.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-24195PRVStephanie Z Mejia1984-11-12—56484769843840 Highland Ave, Glendale, AZ, 853830.66Phone reformattedState name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
PRV-24194PRVStephanie Z Mejia1984-11-12—56484769843840 Highland Ave, Glendale, AZ, 853830.66Phone reformattedState name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
PRV-20722PRVPriya James1999-02-25UHC-14750-4234529358009288 Spring St # 422, Gilbert, AZ, 852720.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-23749PRVJennifer E Wattson——89071403899725 Harbor Blvd, Tucson, AZ, 857830.66Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+1 more
PRV-27109PRVDonald Hudson1976-01-19UHC-43303-5370174749946764 Baseline Rd, Charlotte, NC, 282840.66Name split from “Last, First”Phone reformattedZIP+4 trimmedWhitespace trimmed+1 more
9,596 rows, page 67 of 192PreviousNext