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-25035PRVAlan U Rice1997-01-02UHC-08546-5448736376385955 Sage Ct, Seattle, WA, 981610.80State name converted to codeEmail lower-casedWhitespace trimmedPlaceholder values cleared
PRV-23138PRVAlbert Santos1985-08-12UHC-10621-5066597909402953 Union St, Chandler, AZ, 852210.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27991PRVWillie K Herrera1938-05-16—78090965236978 Mountain View Dr, Houston, TX, 770290.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20772PRVKenneth Perkins1996-07-07UHC-46973-8998460819116141 Maple Ave, Glendale, AZ, 853010.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28467PRVChristopher Moreno1982-03-18UHC-90490-5881399206537662 Cedar Ln, Seattle, WA, 981040.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-24759PRVBrenda O Wong1952-02-16UHC-83913-1823073101312021 Willow Ct, Miami, FL, 331630.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
PRV-20159PRVDebra X Bishop1939-08-24UHC-47053-4842148319546338 Grand Ave # 441, Orlando, FL, 328620.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
PRV-25054PRVThomas Foster1999-05-26——369 Ocean Ave, Denver, CO, 802600.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-25653PRVElizabeth Simmons1985-06-17—92576537549041 Baseline Rd, Fresno, CA0.80Name re-casedPhone reformattedZIP missingPlaceholder values cleared
PRV-28962PRVDonna Salazar1978-06-02—6144530709212 Forest Ave, Orlando, FL, 328170.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-29112PRVBrian Montgomery1997-04-14UHC-99370-9925228115621387 Hillcrest Rd, Miami, FL, 331160.80Phone reformattedCity re-casedZIP+4 trimmedPlaceholder values cleared
PRV-26330PRVBarbara Johnston1974-09-16UHC-72209-44——0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-25475PRVJordan Y Hill1979-05-24—24661497499487 Church St, Tampa, FL, 336950.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-22550PRVSteve Watins1954-12-25UHC-84173-477594208672860 Hillcrest Rd, Austin, TX, 787000.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28002PRVMary Coleman1995-06-14UHC-92494-525556313855—0.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-23768PRVCamila E Weaver1976-10-02—55181716441120 Spring St, Tempe, AZ, 852980.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-23509PRVBen Shaw1993-05-24UHC-42535-60—2003 Central Ave, Jacksonville, FL, 322160.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
PRV-22068PRVBryan Baiiley1972-07-16UHC-99666-8162592794336961 Washington St, Scottsdale, AZ, 852770.80Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased
PRV-29114PRVTimothy Bishop1978-10-26UHC-78355-4976250345552293 Washington St, Jacksonville, FL, 322520.80Phone reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-27815PRVGary G Collins1978-09-17—3428991081—0.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-22196PRVNatalie W Wang2000-08-13UHC-11557-27—5773 Baseline Rd, Minneapolis, MN, 554890.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-27243PRVCatherine Matthews1998-08-27UHC-17578-7827027686812400 Ocean Ave, San Diego, CA, 921460.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25444PRVKenneth Fisher1957-09-07—81899701478808 Harbor Blvd, Tucson, AZ, 857450.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25787PRVVincent Guerrero1965-09-01—20127515804646 Baseline Rd, Minneapolis, MN, 554830.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-24767PRVJordan Romero1989-01-18UHC-83045-22—1743 Jefferson Ave, Fresno, CA, 937050.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-27617PRVAustin Tucker1949-03-19—47796428589774 Central Ave, Mesa, AZ, 852890.80Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed
PRV-22601PRVJerry Butler1964-11-15—4414910136467 Indian School Rd # 319, Mesa, AZ, 852680.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
PRV-24336PRVLuis Delgado1999-07-17—71994668603376 Camelback Rd, Denver, CO, 802160.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21062PRVVictoria Cook1942-07-17—54060859238105 Cedar Ln, Fresno, CA, 937560.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
PRV-28287PRVLaura Thomas1940-04-21UHC-63477-4081048044482534 Central Ave, Columbus, OH, 432270.80Date of birth reformattedPhone reformattedState name converted to codePlaceholder values cleared
PRV-23556PRVCharlotte Lawson1952-02-25UHC-42796-3583620106344101 River Rd, Fresno, CA, 937000.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-29592PRVRyan George2005-10-22——7634 Hillcrest Rd, Columbus, OH, 432890.80SSN last four extractedCity re-casedWhitespace trimmedPlaceholder values cleared
PRV-27406PRVMary Smith1945-07-09——1344 Apache Blvd, Austin, TX, 787040.80Date of birth reformattedPhone missing area codeCity re-casedPlaceholder values cleared
PRV-26757PRVRachel Daniels1951-07-18—20178553606715 Cedar Ln, Glendale, AZ, 853120.80Date of birth reformattedPhone reformattedZIP+4 trimmedPlaceholder values cleared
PRV-24583PRVDebra Stone1984-04-14—34338463371874 Maple Ave, Atlanta, GA, 303850.80Phone reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-26590PRVHernandez William2001-09-12UHC-46931-84—7899 Cedar Ln, Dallas, TX, 752310.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
PRV-29471PRVJacob K Rojas1988-12-24—75390033514083 Elm St, Plano, TX, 750280.80Two-digit birth yearPhone reformattedCity re-casedPlaceholder values cleared
PRV-20230PRVAnna S Fisher1990-09-28UHC-66514-159384466330—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
PRV-26415PRVDonald V Rojas1981-02-18UHC-71744-3661189293103130 Grand Ave, Charlotte, NC, 282770.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25857PRVJoshua Walker1948-12-24—71441196421765 Lincoln Way, Orlando, FL, 328060.80City re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
PRV-24129PRVMatt Lewis1980-08-11UHC-42467-3873867420072427 Harbor Blvd, Tempe, AZ, 852170.80Phone reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-21957PRVGabriel R Ross1982-07-27—41237472435064 Mesa Dr, Sacramento, CA, 958750.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27633PRVStephanie Vasquez1949-05-18UHC-25440-7251579702736735 Central Ave, Seattle, WA, 981310.80Phone reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-22789PRVJacob Aguilar1970-02-26UHC-45993-8238254392352492 Lake View Rd, San Diego, CA, 921050.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-21391PRVShirley Harris1973-06-03UHC-83247-8645742269877248 Broadway, Chandler, AZ, 852690.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-24829PRVHannah Porter2007-10-26UHC-06283-4161893321762195 Mesa Dr, Eden Prairie, MN0.80State code upper-casedZIP missingWhitespace trimmedPlaceholder values cleared
PRV-27345PRVMaria P Henry1981-02-04UHC-39990-48—4187 Central Ave, Plano, TX, 750530.80Name split from “Last, First”Date of birth reformattedCity re-casedPlaceholder values cleared
PRV-24844PRVArthur Wagner1954-06-18UHC-89496-4158027204806277 Spring St, Tempe, AZ, 852240.80Two-digit birth yearPhone reformattedState code upper-casedPlaceholder values cleared
PRV-28835PRVPriya J Oewns1979-12-19———0.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-27604PRVDonna A Silva1989-10-06———0.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
9,596 rows, page 125 of 192PreviousNext