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-28191PRVAaron Reid1968-04-25—76457959131642 Apache Blvd, Miami, FL, 331460.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-22705PRVMary Ross1970-03-28——7635 Harbor Blvd, Las Vegas, NV, 891160.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25494PRVMiller S Santiago1996-07-17UHC-18873-044508456758161 Broadway, Scottsdale, AZ, 852100.76Phone reformattedAddress re-casedState code upper-casedGender normalised+2 more
PRV-23383PRVEthan Taylor1961-01-06UHC-92353-0244483752196658 Highland Ave, Austin, TX, 787390.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21051PRVJen Anderson1975-07-27UHC-24465-0742344909213368 Willow Ct, Orlando, FL, 328930.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-29162PRVRyan T Anderson1999-10-17UHC-78959-9555638239511852 Main St, Las Vegas, NV, 891110.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21339PRVSean Torres1939-04-18UHC-30998-6569067656551225 Park Pl, Las Vegas, NV, 891210.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25287PRVJohn B Hernandez2001-09-16—97722306765504 Desert Sky Blvd, Denver, CO, 802030.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22714PRVCarol Lane1956-06-01—57574998277896 Willow Ct, Mesa, AZ, 852500.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26179PRVAngela Lee1983-06-07UHC-45982-3596244058537108 Meadow Ln, Sacramento, CA, 958030.76Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+2 more
PRV-23604PRVBeverly Y Hunt1984-05-06—33733360931902 Maple Ave, Gilbert, AZ, 852460.76Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more
PRV-21727PRVKathryn Harvey1999-12-05——1314 Main St, Mesa, AZ, 852540.76Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
PRV-21421PRVLinda Murray1958-10-15UHC-87160-2042366006589085 Washington St, Mesa, AZ, 852500.76Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+2 more
PRV-24814PRVAlan Maldonado1940-09-18UHC-40405-9896486407403947 Willow Ct, Fresno, CA, 937600.76Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-29370PRVEthan Lopez1972-07-10UHC-92695-796246151566992 Sage Ct, San Diego, CA, 921480.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28850PRVEvelyn Kim1991-05-18UHC-97183-1786271109733615 Palm Dr, Seattle, WA, 981170.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21301PRVJose E McDonald1985-07-13UHC-98359-0651998977213515 Union St, San Antonio, TX, 782730.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28843PRVKyle Kennedy1994-02-14UHC-77184-965887905978357 Canyon Rd, Eden Prairie, MN, 553870.76Name split from “Last, First”Date of birth reformattedCity re-casedEmail lower-cased+2 more
PRV-26818PRVKaren Y Warren1996-05-10UHC-86315-0887984987904669 Church St, Houston, TX, 770710.76Name re-casedPhone reformattedState code upper-casedGender normalised+2 more
PRV-21643PRVRobert Z Tucker1946-03-04—44662991857017 Baseline Rd, San Diego, CA, 921760.76Name re-casedDate of birth reformattedPhone reformattedZIP+4 trimmed+2 more
PRV-23205PRVWei H Gardner1966-07-12—58256793067036 Central Ave, San Diego, CA, 921320.76Date of birth reformattedPhone reformattedCity re-casedGender normalised+2 more
PRV-22716PRVSandra M Fox1971-01-19UHC-53823-2623528751578751 Washington St, Las Vegas, NV, 891560.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-23681PRVStephen Duncan1963-01-07—84568888822845 Market St, Tampa, FL, 336480.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25601PRVHeather Morales1942-08-03—40872603946122 Baseline Rd, Austin, TX, 787080.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-24279PRVSantiago M Woods1999-07-20—65789355668090 Lake View Rd # 730, Chandler, AZ, 852780.76Date of birth reformattedPhone reformattedUnit split from streetCity re-cased+2 more
PRV-28527PRVFrances Wood1962-08-02UHC-40418-0441739190737219 Cedar Ln, Austin, TX, 787210.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-26418PRVPerez Jose1980-04-25—62655673164123 Central Ave, Gilbert, AZ, 852570.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25892PRVDoris Chavez1945-06-01UHC-61116-8962191624963187 Main St, Phoenix, AZ, 850040.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21514PRVLogan Rivera1989-06-13—95755649097090 Maple Ave, Mesa, AZ, 852370.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21977PRVKelly B Richards1995-06-22—86526591287406 Pine Dr, Orlando, FL, 328300.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-27271PRVJoyce Sadners1944-01-23—82096214599492 Ocean Ave, San Antonio, TX, 782780.76Date of birth reformattedStreet suffix standardisedAddress re-casedPlan code upper-cased+2 more
PRV-22691PRVBarbara Ruiz1942-03-19UHC-93786-8971981833598554 Ridge Rd, Tampa, FL, 336080.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24014PRVHeather Q Schultz2003-12-09UHC-31606-78—8354 Baseline Rd, Tucson, AZ, 857450.76Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20078PRVLogan Jenkins1983-02-11—95139365622509 Spring St, Minneapolis, MN, 554080.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25951PRVPriya Ramos1960-03-13UHC-54011-482178346182814 Apache Blvd, Miami, FL, 331790.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21268PRVScott O Moreno1984-10-06UHC-00221-3780985236323320 Cedar Ln, Dallas, TX, 752450.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22439PRVGloria Webb1941-12-28UHC-39563-0142189003957915 Mountain View Dr, Austin, TX, 787570.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-29097PRVDavid Armstrong2003-07-06—96330895336241 Hillcrest Rd, Glendale, AZ, 853690.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24619PRVLogan Lawson1992-11-11—28368073939216 Mesa Dr, Atlanta, GA, 303130.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25470PRVScott G Alvarado1973-09-21—96492973885896 Hillcrest Rd, Glendale, AZ, 853990.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20849PRVDavid J Turner2008-02-01——6101 Palm Dr, Dallas, TX, 752940.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-26807PRVAlan Adams1967-08-10—28049517663569 Meadow Ln, Minneapolis, MN, 554800.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25198PRVBilly Weaver1975-06-25—75179466402855 Bayshore Dr, Scottsdale, AZ, 852670.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23728PRVLogan Carpenter1977-10-08UHC-28655-2746660790544033 Mountain View Dr, Phoenix, AZ, 850520.76Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more
PRV-24154PRVTimothy N Rice1994-11-24——8880 Forest Ave, Las Vegas, NV, 891930.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-24581PRVGabriel W Hunt1974-07-23—49152693896315 Harbor Blvd, Minneapolis, MN, 554210.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-27576PRVDenise W Chapman2005-07-28UHC-35764-3441356507476110 Grand Ave, Chandler, AZ, 852640.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-20432PRVDaniel Stephens1991-01-12UHC-83301-0298242557423320 Sunset Blvd, Denver, CO, 802590.76Name re-casedPhone reformattedCity re-casedGender normalised+2 more
PRV-21773PRVLaura Perkins1956-09-28—82067780655448 Baseline Rd, Minneapolis, MN, 554930.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22924PRVJustin Roberts1993-12-10—80777548573616 Valley View Dr, Plano, TX0.76Name re-casedPhone reformattedZIP missingEmail lower-cased+2 more
9,596 rows, page 94 of 192PreviousNext