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-23005PRVVincent K Smith1954-08-27—34922611412219 Canyon Rd, San Diego, CA, 921840.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-29393PRVCharles Marquez1943-08-17UHC-60230-7276856267209250 Park Pl, Charlotte, NC, 282090.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22768PRVJack Mendoza1978-09-13—68682088346468 Camelback Rd, Chandler, AZ, 852430.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-27591PRVDebra E Spencer2002-07-17——1364 Willow Ct, Plano, TX, 750230.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-29251PRVAshley Castillo2007-03-10UHC-36019-0650766742179750 Desert Sky Blvd, Denver, CO, 802890.74Name re-casedDate of birth reformattedCity re-casedZIP+4 trimmed+3 more
PRV-28637PRVChistina Garcia1969-02-11UHC-73700-7543367488127938 Church St, Houston, TX, 770170.74Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
PRV-21298PRVJohn Wast1938-01-22UHC-39164-0177499196688348 Market St, Austin, TX, 787480.74Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more
PRV-27682PRVLauren U Peters1984-07-16—22528577911420 Oak St, Glendale, AZ, 853920.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-27946PRVSean A Gordon1948-09-19UHC-57083-4662695403929787 Canyon Rd, Mesa, AZ, 852720.74Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-29310PRVJeremy Carroll1981-07-04—34633078969384 Church St, Las Vegas, NV, 891180.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-21572PRVSara Patel2002-03-22UHC-48728-3376783984281780 Baseline Rd, Tucson, AZ, 857680.74Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
PRV-24591PRVKathleen Crawford1999-06-01UHC-99013-4330782356925269 Jefferson Ave, Glendale, AZ, 853560.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-29240PRVMary Hudzon1995-01-14UHC-28041-4077547971939385 Mesa Dr, San Diego, CA, 921710.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28574PRVJohn Moore1996-04-11—40720618473523 Market St, Sacramento, CA, 958630.74Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more
PRV-29521PRVAlan Harris1946-08-05—67659250491221 Union St, Minneapolis, MN, 554220.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-29204PRVCharles Z Jimenez1946-02-17UHC-25702-2298155655965023 River Rd, Austin, TX, 787670.74Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more
PRV-24690PRVKenneth Thompson1952-02-21—47654724242624 Central Ave, San Antonio, TX, 782700.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23716PRVChristian W Lane1971-03-19—90394190295676 Meadow Ln, Jacksonville, FL, 322600.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20120PRVCamila Bryant1941-07-01UHC-78163-314093755405517 Harbor Blvd, Columbus, OH, 432590.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-26351PRVMarcus O Nichols2005-03-17UHC-25674-1836721420963722 Camelback Rd, Eden Prairie, MN, 553220.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-20408PRVJoe Y Reid1960-07-03UHC-26803-2179263074348020 Sunset Blvd, Seattle, WA, 981180.74Name re-casedPhone reformattedMember ID reformattedCity re-cased+3 more
PRV-25769PRVJennifer Dean1954-01-02UHC-62336-8962054216898007 Indian School Rd, Jacksonville, FL, 322040.74Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22162PRVLisa J Bryant1997-02-06—92681846285893 Meadow Ln, Nashville, TN, 372240.74Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more
PRV-21651PRVAmanda Wright1972-08-09—40564496411297 Willow Ct, Charlotte, NC, 282410.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-21652PRVAmanda Wright1972-08-09—40564496411297 Willow Ct, Charlotte, NC, 282410.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20822PRVBeverly Taylor1996-03-12UHC-10404-5048424872458531 Canyon Rd, Mesa, AZ, 852400.74Name re-casedDate of birth reformattedPhone reformattedState code upper-cased+3 more
PRV-21613PRVAlbert Mason1954-03-14UHC-72233-6876959360392440 Desert Sky Blvd, Glendale, AZ, 853550.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20543PRVTeresa Chavez1953-05-09UHC-36535-4243621244131648 Valley View Dr, Eden Prairie, MN, 553430.74Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
PRV-27600PRVAlice Hunter2006-08-21UHC-81231-2160056918132357 Indian School Rd, Plano, TX, 750620.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-28256PRVLogan Laron1945-04-19UHC-56916-2898668874576157 Forest Ave, Phoenix, AZ, 850530.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-22291PRVJulia Mitchell1953-11-03UHC-66986-0637198758709134 Cedar Ln, Nashville, TN, 372110.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-27153PRVDeborah Vargas1944-06-26—40964336784953 Apache Blvd, Minneapolis, MN, 554730.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-21249PRVJeffrey Larson1955-09-24UHC-00373-9528955141595242 Jefferson Ave, Scottsdale, AZ, 852360.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-21602PRVWayne Gutierrez1982-11-13UHC-35850-2742871316167979 Park Pl, Miami, FL, 331960.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-24201PRVKathryn Nunez1984-11-27—70879940063733 Meadow Ln, Los Angeles, CA, 900250.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-23824PRVMelissa Rose1954-07-10UHC-51916-7287487140406028 Maple Ave, Phoenix, AZ, 850840.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-21406PRVBrenda Johnston1996-01-24—87842587241490 River Rd, Tampa, FL, 336560.74Name re-casedPhone reformattedCity re-casedZIP+4 trimmed+3 more
PRV-21405PRVBrenda Johnston1996-01-24—87842587241490 River Rd, Tampa, FL, 336560.74Name re-casedPhone reformattedCity re-casedZIP+4 trimmed+3 more
PRV-20485PRVTerry Hansen1956-10-09—47988984249836 Camelback Rd, Gilbert, AZ, 852940.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22990PRVRonald I Watkins2008-06-26—949232041521 Washington St, Fresno, CA, 937920.74Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+3 more
PRV-26986PRVFatima Z Bell1997-02-17—37839624603325 Harbor Blvd, Miami, FL, 331790.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-25160PRVAmanda Weaver2008-06-06—69426643237895 Park Pl, Plano, TX, 750070.74Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-27537PRVElijah Wilson1945-03-07—32727674708213 River Rd, Denver, CO, 802310.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20586PRVStephen Garza1947-12-11—90465364879896 Ridge Rd, Orlando, FL, 328630.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-26430PRVArjun Evans1979-02-19—29135742715961 Broadway, Scottsdale, AZ, 852350.74Name split from “Last, First”Date of birth reformattedPhone reformattedAddress re-cased+3 more
PRV-24712PRVCharles J Ray1951-09-17——8897 Ridge Rd, Nashville, TN, 372270.74Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
PRV-28512PRVPriya Ryan1989-06-17UHC-94155-4747764118646949 Canyon Rd, Chandler, AZ, 852490.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-25728PRVJoseph O Delgado1980-05-26UHC-93057-5851638077617648 Jefferson Ave, San Diego, CA, 921590.74Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
PRV-26804PRVKathleen Hughes1949-12-20UHC-40860-3069684089505289 Oak St, Phoenix, AZ, 850650.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-29382PRVKeith Cruz1946-01-14UHC-71380-3981176291095885 Sunset Blvd # 810, Plano, TX, 750540.74Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+3 more
9,596 rows, page 83 of 192PreviousNext