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-21437PRVNatalie Hicks2004-09-04UHC-35559-1563844446983013 Palm Dr # 677, San Antonio, TX, 782460.66Phone reformattedUnit split from streetGender normalisedWhitespace trimmed+1 more
PRV-22074PRVJennifer Hawkins1943-07-14UHC-46500-91—1107 Lake View Rd Apt 40, Denver, CO, 802660.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-27003PRVAmy Warren1940-12-08—75038526028408 Palm Dr # 631, Columbus, OH0.66Date of birth reformattedUnit split from streetZIP missingWhitespace trimmed+1 more
PRV-25486PRVDenise J Armstrong1973-06-18UHC-73122-4330741225116088 Desert Sky Blvd, Miami, FL, 331830.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-28402PRVAdam Z Baker—UHC-26096-0870053341401209 Park Pl, Eden Prairie, MN0.66Date of birth unreadablePhone reformattedCity re-casedZIP missing+1 more
PRV-23088PRVRichard Brown1955-05-11UHC-07594-559155620804304 Oak St, Columbus, OH, 432800.66Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
PRV-20971PRVWayne H Wang1963-02-23UHC-60912-66—9494 Market St, Jacksonville, FL, 322930.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-24211PRVDiana I Harris1967-08-04UHC-73519-3232652606494392 Broadway, Fresno, CA, 937860.66Name split from “Last, First”Date of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more
PRV-29186PRVAlan Nichols1975-03-06UHC-14705-8156058445667434 Cedar Ln, Gilbert, AZ, 852240.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
PRV-21892PRVAlbert Q Kennedy1945-12-05UHC-89191-012908392311—0.66Middle initial moved out of first nameTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more
PRV-24252PRVDorothy Taylor1989-04-01—27736674363562 Meadow Ln, Gilbert, AZ, 852480.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-22107PRVDylan Watkins2007-10-27UHC-44967-83—343 Bayshore Dr, Seattle, WA, 981910.66Two-digit birth yearStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
PRV-23374PRVKayla Vargas1987-08-09——9824 Elm St, Scottsdale, AZ, 852390.66Phone missing area codeCity re-casedZIP+4 trimmedWhitespace trimmed+1 more
PRV-28698PRVCharles Hunter2000-04-06——433 Cedar Ln, Fresno, CA, 937140.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-21068PRVMichelle Richards1944-03-15—38580357147612 Union St, San Diego, CA, 921880.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-26651PRVAisha Peterson1964-06-27——722 Church St, Houston, TX, 770350.66SSN last four extractedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-25692PRVBerry Keith2006-04-02——810 Valley View Dr, Mesa, AZ, 852620.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
PRV-20010PRVSarah Collins1940-09-18UHC-06515-4264732725126195 Camelback Rd # 834, Mesa, AZ, 852750.66Name split from “Last, First”Phone reformattedUnit split from streetWhitespace trimmed+1 more
PRV-20816PRVJordan P Joseph1945-09-27UHC-60507-5570493114198990 Desert Sky Blvd Apt 25, Austin, TX, 787210.66Name split from “Last, First”Phone reformattedUnit split from streetWhitespace trimmed+1 more
PRV-20991PRVTiler W Jackson—UHC-45708-1292973635627548 Baseline Rd, Atlanta, GA, 303260.66Name re-casedDate of birth unreadablePhone reformattedSSN last four extracted+1 more
PRV-23972PRVFrank Baker1990-09-08—77426010922429 Sage Ct, Glendale, AZ, 853070.66Name re-casedPhone reformattedZIP+4 trimmedGender normalised+1 more
PRV-23973PRVFrank Baker1990-09-08—77426010922429 Sage Ct, Glendale, AZ, 853070.66Name re-casedPhone reformattedZIP+4 trimmedGender normalised+1 more
PRV-23635PRVDenise Price1939-12-27UHC-27721-07—8071 Desert Sky Blvd, Seattle, WA, 981190.66Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-21748PRVDavid Padilla1992-07-28——4545 Lincoln Way, Los Angeles, CA, 900970.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-27844PRVBeth Rodriguez1963-12-06UHC-01963-1827871509217374 Sage Ct, Tampa, FL0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-28809PRVValentina Williams1982-09-21—92865125468185 Mesa Dr, Columbus, OH, 432870.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-25455PRVAnn Simpson2006-01-05—87255076122030 Central Ave, Gilbert, AZ, 852680.66Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-22619PRVNicole Arnold1998-05-01—91222223677966 Market St, Fresno, CA, 937330.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-23263PRVPatrick Jones2003-05-09—35670960133171 Cedar Ln, Plano, TX, 750210.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-24988PRVJeffrey Q Mendzoa1965-08-12UHC-92808-1563747151963159 Canyon Rd, Dallas, TX, 752210.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
PRV-24936PRVMadison W Lee——87555151327266 Sage Ct, Houston, TX, 770980.66Name re-casedDate of birth unreadablePhone reformattedGender normalised+1 more
PRV-28895PRVAlan Nguyen1999-06-19—58733377159871 Main St, Mesa, AZ, 852210.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-22432PRVMateo K Clark2006-01-06—8574659904399 Mesa Dr Apt 29, Scottsdale, AZ, 852040.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-22223PRVRoger White1948-08-05UHC-38078-4533745702521094 Baseline Rd, Seattle, WA, 981050.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-22140PRVLauren Howard2002-10-01UHC-36100-8091867965605084 River Rd, Gilbert, AZ, 852510.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-24253PRVPerry Nicole1952-01-17—58831503757253 Ocean Ave, Tampa, FL0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-23120PRVBilly Morris1999-02-06——1727 Canyon Rd, Atlanta, GA, 303640.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
PRV-24537PRVJoshua Bishop1944-01-16UHC-15066-2179340585029490 Desert Sky Blvd, Chandler, AZ, 852020.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-25546PRVGeorge Shaw1984-10-02UHC-36004-7779965395686572 Bayshore Dr, Tucson, AZ, 857800.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-25279PRVJustin L Gordn1958-09-10UHC-93719-60—8913 Mountain View Dr, Phoenix, AZ, 850690.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
PRV-26183PRVGabriel Torres1962-04-24UHC-05549-07—2356 Desert Sky Blvd, Nashville, TN, 372490.66Phone missing area codeState name converted to codeEmail lower-casedWhitespace trimmed+1 more
PRV-28299PRVMaria Little—UHC-24075-3442091788521334 Harbor Blvd, Phoenix, AZ, 850300.66Date of birth unreadablePhone reformattedZIP+4 trimmedWhitespace trimmed+1 more
PRV-24518PRVSara Scott1958-06-18—88935403839443 Broadway # 751, Tempe, AZ, 852700.66Name re-casedPhone reformattedUnit split from streetGender normalised+1 more
PRV-26527PRVFranecs G Hicks1963-04-27—83526505872571 Desert Sky Blvd, Chandler, AZ, 852250.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-25497PRVRuth I Maldnoado1989-07-03——1565 Lake View Rd, Plano, TX, 750970.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
PRV-26372PRVVictoria Fields1943-08-20UHC-70359-7461948850164522 Mesa Dr, Minneapolis, MN0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
PRV-27490PRVJeeffrey Cook1986-04-06UHC-48436-17—7290 Highland Ave, Minneapolis, MN, 554050.66Name re-casedState name converted to codeGender normalisedPlan code upper-cased+1 more
PRV-23663PRVJaccob Pierce1950-04-11UHC-39294-1262165454883638 Hillcrest Rd Apt 28, Mesa, AZ, 852290.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-27884PRVAngela S Ellis1949-03-02——9545 Apache Blvd Apt 12, Fresno, CA, 937610.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-20907PRVAnn Taylor1945-09-03—42991177427489 Valley View Dr Apt 18, Scottsdale, AZ, 852130.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
9,596 rows, page 59 of 192PreviousNext