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-26137PRVRalph V Santos1971-04-17UHC-84145-92—6368 Highland Ave, Sacramento, CA, 958090.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-24457PRVAaron Evans1944-06-16—69353654222320 Central Ave # 426, Austin, TX, 787530.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
PRV-21530PRVCamila Snyder1993-06-09UHC-17020-1641963417643515 Willow Ct, Miami, FL, 331920.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-27264PRVBraldey Chen1993-05-27—5717582303285 Ridge Rd, Tucson, AZ, 857770.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27997PRVTeresa Sism1981-01-25—38471850919302 Meadow Ln, Houston, TX, 770450.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28588PRVKayla Dominguez2005-12-04—79236893343204 Bayshore Dr, Plano, TX, 750510.80Name re-casedPhone reformattedZIP+4 trimmedPlaceholder values cleared
PRV-22556PRVBetty Le1953-07-25UHC-26618-6860774734249800 Mesa Dr, Houston, TX, 770090.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
PRV-27912PRVAlan Vega1974-07-23UHC-86604-4398722769087471 Ocean Ave, Mesa, AZ0.80Phone reformattedZIP missingWhitespace trimmedPlaceholder values cleared
PRV-24935PRVLarry Y Garza1975-06-15UHC-05817-3029482281653322 Lincoln Way, Las Vegas, NV, 891270.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27309PRVAngela Hunter1997-06-20—64335330558782 Lincoln Way, Orlando, FL, 328170.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-21343PRVSofia Lane1964-08-03——5091 Sage Ct, Scottsdale, AZ, 852830.80Name split from “Last, First”Date of birth reformattedCity re-casedPlaceholder values cleared
PRV-20885PRVAmber Castro1973-03-24—84676978201117 Indian School Rd, Gilbert, AZ, 852230.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-28737PRVLauren Sullivan1938-07-08—82492688726489 Oak St, Seattle, WA, 981890.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20528PRVAbigail Snyder1970-01-20UHC-21758-854774688648565 Ocean Ave, Plano, TX, 750870.80Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased
PRV-25717PRVVincent Reyes2006-10-23—68334923578555 Park Pl, Plano, TX, 750160.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
PRV-28075PRVCynthia B Burke1950-06-14—95080556805687 Central Ave, Fresno, CA, 937320.80Name re-casedDate of birth reformattedZIP+4 trimmedPlaceholder values cleared
PRV-28074PRVCynthia B Burke1950-06-14—95080556805687 Central Ave, Fresno, CA, 937320.80Name re-casedDate of birth reformattedZIP+4 trimmedPlaceholder values cleared
PRV-23502PRVJenice Jacobs1965-04-10——631 Forest Ave, Mesa, AZ, 852700.80Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared
PRV-27479PRVMadison Reyes1966-01-19UHC-19088-319178275217—0.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
PRV-23475PRVAndrea Weaver2004-09-02UHC-37102-6153374713807005 Union St, Columbus, OH, 432950.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-20210PRVRaymnod Mendoza1943-05-14—94044157576759 Canyon Rd, Columbus, OH, 432760.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-29381PRVFatima Richards2008-07-13—54238359717368 Baseline Rd, Columbus, OH, 432620.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-22264PRVPatrick Garcia1998-12-01——1849 Ocean Ave, San Diego, CA, 921990.80Name re-casedDate of birth reformattedPhone missing area codePlaceholder values cleared
PRV-21578PRVBryan Stevens1944-01-04—2625639406—0.80Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed
PRV-23961PRVFrances Jacobs1974-02-01—79530784743130 Desert Sky Blvd, Denver, CO, 802230.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-22224PRVLaura V Bryant1985-06-09UHC-42238-0479193210752223 Jefferson Ave, Mesa, AZ, 852150.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21675PRVKathleen Taylor2004-01-06—34129965237201 Union St, Gilbert, AZ0.80Phone reformattedZIP missingWhitespace trimmedPlaceholder values cleared
PRV-28548PRVBrandon Santos1965-05-10UHC-60608-3972034353081113 Broadway, Houston, TX, 770910.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-23825PRVFrank W Salazar1988-09-10UHC-98170-435212129491—0.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
PRV-21303PRVGrace Gardner1961-12-10—63230316944389 Mesa Dr, Eden Prairie, MN, 553240.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-24998PRVJulia Carpenter1939-09-16UHC-53528-1589726606103269 Sage Ct, Gilbert, AZ, 852910.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-20384PRVPeter Robertson2003-07-16UHC-65809-3289428143963414 Broadway Apt 29, Chandler, AZ, 852270.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
PRV-20383PRVPeter Robertson2003-07-16UHC-65809-3289428143963414 Broadway Apt 29, Chandler, AZ, 852270.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
PRV-28580PRVJensen U Austin1945-08-06—38050631476006 Church St, San Diego, CA, 921790.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25898PRVLucia Jenkins1962-08-09—25176369662112 Sunset Blvd, Columbus, OH, 432530.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28066PRVJamees Bryant1982-01-07UHC-17281-995765912996—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-24850PRVAlbert Danieels1954-05-11UHC-88907-28—5558 Oak St, Tampa, FL, 336810.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
PRV-26132PRVCarolyn Kennedy1948-08-06UHC-02309-9753975283245655 Main St # 179, Glendale, AZ, 853360.80Date of birth reformattedPhone reformattedUnit split from streetPlaceholder values cleared
PRV-29067PRVDiego J Berry1949-04-06—4662533984—0.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
PRV-20610PRVBenjamin Mitchell1976-12-10——7287 Desert Sky Blvd, San Diego, CA, 921440.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-20713PRVBobby Park1979-02-20—28476465503122 Park Pl, Nashville, TN, 372300.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-29040PRVChristopher Yang1961-08-27—80850759616043 Church St, Chandler, AZ, 852890.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-24719PRVThomas Ortiz1973-04-08—46736147955104 Cedar Ln, Las Vegas, NV, 891090.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-24192PRVDeborah Yang1976-08-28UHC-58910-7175775208894152 Lincoln Way # 696, Orlando, FL, 328430.80Name re-casedDate of birth reformattedUnit split from streetWhitespace trimmed
PRV-27897PRVCharlotte Y Kennedy1945-11-08—24645435066137 Maple Ave, Chandler, AZ, 852140.80Date of birth reformattedPhone reformattedState name converted to codePlaceholder values cleared
PRV-29522PRVChristina Martinez2000-02-25UHC-18976-5022752279388291 Sunset Blvd, Houston, TX, 770590.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20542PRVTheresa V Fowler1979-04-14—39962986969800 Lake View Rd, Columbus, OH, 432970.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-23557PRVRaymond Moreno1971-05-25UHC-10088-5725539439708655 Grand Ave, Orlando, FL0.80Phone reformattedZIP missingWhitespace trimmedPlaceholder values cleared
PRV-22640PRVJennifer K Oliver1972-09-17UHC-58266-5371220910928588 Union St, Orlando, FL, 328740.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25457PRVJudy Soto1981-01-26UHC-64354-1762199084639496 Ridge Rd, Glendale, AZ, 853220.80Member ID reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
9,596 rows, page 132 of 192PreviousNext