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

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
PRV-27549PRVAhmed I Li1952-05-11—80793696139424 Park Pl, Eden Prairie, MN, 553610.92Phone reformattedState code upper-casedWhitespace trimmedPlaceholder values cleared
PRV-21618PRVSofia Sims1954-06-06UHC-52577-7055222031877390 Washington St, Fresno, CA, 937960.92Phone reformattedState code upper-casedWhitespace trimmedPlaceholder values cleared
PRV-25617PRVKaren Phillips1976-08-27—70049424346656 Washington St, Tempe, AZ, 852820.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-20912PRVBetty Allen1956-09-12—96596356938596 Broadway, Tempe, AZ, 852480.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-21740PRVDoris X Coleman1989-06-06——342 Valley View Dr, Tempe, AZ, 852750.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-22936PRVGeradl Chavez1987-03-27UHC-99698-9142682732563225 Hillcrest Rd, Atlanta, GA, 303480.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-26286PRVMaria Spencer1977-03-27UHC-16004-647254509368973 Sage Ct, Eden Prairie, MN, 553490.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-26080PRVMartha Gardner1944-05-13UHC-33697-5225798371233192 Sunset Blvd, Gilbert, AZ, 852150.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-22326PRVLarry Walker1993-05-24—23222536545805 Mesa Dr, Eden Prairie, MN, 553290.92Date of birth reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
PRV-25323PRVEugene N Greene1979-09-16UHC-12315-9495897873037677 Highland Ave, Tampa, FL, 336150.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-26756PRVEthan Fernandez2000-08-05——3381 Church St, San Diego, CA, 921660.92Date of birth reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
PRV-22201PRVElijah Aguilar1996-12-19———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-25640PRVJesse Wallace2005-06-01—49071742936051 River Rd, San Diego, CA, 921820.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
PRV-22567PRVBryan Cox1964-06-15UHC-15669-808887331750—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-25933PRVWei Walker1976-05-14UHC-30724-807004052828—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-22938PRVAaron Cruz2008-01-18UHC-89556-765962960753—0.92Phone reformattedMember ID reformattedWhitespace trimmedPlaceholder values cleared
PRV-28258PRVShirley Vasquez1954-09-09—69770380474637 Mesa Dr, Plano, TX, 750410.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-25706PRVElijah Munoz1957-11-23—66086760977576 Jefferson Ave, Houston, TX, 770040.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-26819PRVSteven Maldonado1985-04-19—86727965541352 Desert Sky Blvd, Minneapolis, MN, 554780.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-20870PRVSharon R Olson1999-08-10UHC-00596-779203586966—0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-28407PRVDouglas Kelly1995-05-25—96444243329857 Washington St, Charlotte, NC, 282310.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-28762PRVBruce Garza1948-11-15UHC-00733-1273332454073302 Jefferson Ave, Plano, TX, 750140.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-26610PRVValentina Hikks1951-08-06—8808488420137 Canyon Rd, Denver, CO, 802450.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-20736PRVSarah N Cruz2002-05-22—4789514363—0.92Name re-casedPhone reformattedPlan code upper-casedPlaceholder values cleared
PRV-29480PRVAaron D Salazar1990-08-04—49282917585972 Sunset Blvd, Sacramento, CA, 958480.92Date of birth reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
PRV-28971PRVSandra McCoy1999-11-15—26881838772098 Camelback Rd, Scottsdale, AZ, 852820.92Date of birth reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
PRV-24943PRVMelissa Holmes1950-12-25——7566 Spring St, San Antonio, TX, 782030.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-20587PRVMaria James2001-11-10——9109 Broadway, Orlando, FL, 328410.92Name re-casedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-24878PRVBrandon Stevens1976-11-18—6343461500—0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-24877PRVBrandon Stevens1976-11-18—6343461500—0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-23611PRVHelen Torres1995-03-23UHC-80874-526155136040—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-24029PRVMary Pena1964-10-04UHC-87810-2732068754435221 River Rd, Seattle, WA, 981840.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-22890PRVMaria Bailey1990-05-28—4909490878—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-23776PRVJudy Stevens1962-08-11UHC-82487-20—3652 Palm Dr, Los Angeles, CA, 900410.92Name re-casedEmail lower-casedWhitespace trimmedPlaceholder values cleared
PRV-28868PRVBrandon Munoz1939-12-06—2786174336—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-29443PRVJerry Weber2007-02-02UHC-25856-5969857696701357 Union St, Eden Prairie, MN, 553170.92Date of birth reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
PRV-25855PRVRios Maosn1939-11-04UHC-42367-40—2850 Valley View Dr, Tampa, FL, 336900.92Name re-casedEmail lower-casedWhitespace trimmedPlaceholder values cleared
PRV-20915PRVPaul Hunter1942-08-04—43135342548964 Maple Ave, Fresno, CA, 937910.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-26559PRVKelly I Reid1974-02-13—85838194497525 Palm Dr, Fresno, CA, 937210.92Name re-casedPhone reformattedCity re-casedPlaceholder values cleared
PRV-21689PRVJack Anderson1952-04-04—7147204119339 Broadway, Las Vegas, NV, 891170.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-25290PRVRoger Black1992-07-21—2847301448929 Harbor Blvd, Dallas, TX, 752170.92Phone reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
PRV-25677PRVDonna Stone1997-10-18—32961102998866 Grand Ave, Jacksonville, FL, 322590.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-22600PRVAnn Patel1977-06-01—33691092897149 Bayshore Dr, Orlando, FL, 328390.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-24210PRVLarry I Banks2006-01-04UHC-51013-043904874762152 Lincoln Way, Atlanta, GA, 303670.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-23560PRVJustin C Gonzales1962-09-12UHC-43830-3657623429932916 Broadway, Seattle, WA, 981150.92Date of birth reformattedCity re-casedEmail lower-casedPlaceholder values cleared
PRV-21083PRVGarry Sandoval1946-07-26UHC-80407-022448261734—0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-26072PRVWei Alvarez1986-10-15—86433007865127 Elm St, Houston, TX, 770390.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-21104PRVYuki X Fox1944-10-15—9358892383—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-25580PRVSophia Evans1974-12-27UHC-44844-7380262810869437 Sunset Blvd, Chandler, AZ, 852300.92Date of birth reformattedMember ID reformattedCity re-casedPlaceholder values cleared
PRV-26801PRVMaria Scott1942-07-07—43336084997104 Church St, Austin, TX, 787790.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
9,596 rows, page 161 of 192PreviousNext