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-20258PRVStephen C Morales1961-03-24UHC-68494-8391837964765118 Grand Ave, Los Angeles, CA, 900750.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-25073PRVWayne Moorris1984-06-07UHC-85819-2481664045423686 Main St, Charlotte, NC, 282670.76Date of birth reformattedPhone reformattedMember ID reformattedState name converted to code+2 more
PRV-24283PRVSandra Soto2001-10-01—21297142869307 Mesa Dr, Denver, CO, 802800.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25634PRVHiroshi Espinoza1997-12-09——2482 Mesa Dr, Tempe, AZ, 852260.76Street suffix standardisedAddress re-casedCity re-casedEmail lower-cased+2 more
PRV-20739PRVElizabeth Gardner1981-04-12—46892842067874 Union St, Orlando, FL, 328630.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-24624PRVDeborah Hamilton1963-03-05—83498949654385 Highland Ave, Austin, TX, 787210.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-28741PRVValentina Perry1958-07-19—69457924094222 Maple Ave, Nashville, TN, 372340.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28119PRVWayne Fernandez1941-12-03UHC-71673-5249895147066873 Canyon Rd, Jacksonville, FL, 322690.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27652PRVEthan E Sanchez—UHC-35179-0356232799041217 Oak St, San Antonio, TX, 782520.76Name re-casedDate of birth missingPhone reformattedCity re-cased+2 more
PRV-25334PRVJack Dunn1975-08-10——4632 Mesa Dr, Los Angeles, CA, 900290.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24263PRVJoyce A Tran1939-04-24UHC-45030-1354462905683124 Grand Ave, Miami, FL, 331620.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-29329PRVOlivia M Adams1961-12-26UHC-25800-6226127515206363 Hillcrest Rd, Minneapolis, MN, 554020.76Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+2 more
PRV-22997PRVTerry Sms1938-08-05UHC-54059-4138795445812868 Elm St, Phoenix, AZ, 850230.76Member ID reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
PRV-20536PRVWalter Peters1966-02-13UHC-02548-5261182042745060 Highland Ave Apt 22, Minneapolis, MN, 554340.76Date of birth reformattedPhone reformattedUnit split from streetPlan code upper-cased+2 more
PRV-22268PRVJudith Perry1979-08-23UHC-06397-9039858727136815 Canyon Rd, Miami, FL, 331910.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20964PRVJulia Dean1959-11-20UHC-46436-4649841466586505 Highland Ave, Jacksonville, FL, 322730.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26623PRVFrank Fernandez1960-04-04UHC-46561-1387430065826763 Mesa Dr, Glendale, AZ, 853230.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22373PRVSteven Miller1943-03-21UHC-50421-8320578343526461 Grand Ave, Tampa, FL, 336230.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-24793PRVAnthony Reed1942-05-02—83327515346410 Cedar Ln, Nashville, TN, 372210.76Name re-casedPhone reformattedCity re-casedState name converted to code+2 more
PRV-22687PRVNicole Carter1978-02-06—29221994195698 Grand Ave, Houston, TX, 770480.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23487PRVRalph Cox2006-05-21UHC-01981-8198356440717355 Cedar Ln, Phoenix, AZ, 850380.76Name re-casedPhone reformattedCity re-casedGender normalised+2 more
PRV-28100PRVRos A Gary1970-06-13—80153407476125 Sunset Blvd, Columbus, OH, 432680.76Date of birth reformattedPhone reformattedState name converted to codePlan code upper-cased+2 more
PRV-29058PRVCatherine B Lne2007-10-27UHC-93377-92—3738 Apache Blvd, Sacramento, CA, 958960.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28604PRVDon Banks1971-06-13—47423550705222 Camelback Rd, Austin, TX, 787300.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28041PRVRandy D Lawrence1968-05-03—91240500854612 Highland Ave, Charlotte, NC, 282830.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20061PRVBrandon D Benett1976-10-06—6375998649625 Spring St, Tampa, FL, 336200.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28546PRVLarry Taylor1939-04-10——3402 Ocean Ave, Tampa, FL, 336520.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23292PRVMason Gardner1957-02-01UHC-03087-9451328163261165 Oak St, Tucson, AZ, 857860.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26889PRVBryan Perez1989-08-17——4600 Canyon Rd, Tempe, AZ, 852340.76Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
PRV-21766PRVLarry Barnes1958-04-09UHC-76599-0543124022306609 Market St, Houston, TX, 770370.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-29209PRVAdrea Aguilar1971-03-17—28648471358116 Indian School Rd, Scottsdale, AZ, 852640.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20295PRVKathryn L Vasquez1985-08-26UHC-16182-6283167048891861 Cedar Ln, Los Angeles, CA, 900600.76Middle initial moved out of first namePhone reformattedMember ID reformattedEmail lower-cased+2 more
PRV-25437PRVDorothy Griffin1944-12-26—45647824353855 Spring St, Orlando, FL, 328860.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26175PRVChristopher Castro2005-02-27—30143251481841 Maple Ave, Las Vegas, NV, 891080.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22902PRVAustin Domynguez1954-04-10——7136 Cedar Ln, Tampa, FL, 336010.76Date of birth reformattedCity re-casedState code upper-casedZIP+4 trimmed+2 more
PRV-20411PRVJoan Nunez2001-10-23—65077980996137 Mountain View Dr, Las Vegas, NV, 891680.76Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more
PRV-24163PRVRachel Kellly1944-02-27UHC-94298-238564026237572 Market St, Chandler, AZ, 852310.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28181PRVStepen Holmes1962-07-06UHC-14308-3068828600673832 Meadow Ln, Scottsdale, AZ, 852420.76Name re-casedPhone reformattedMember ID reformattedZIP+4 trimmed+2 more
PRV-22830PRVCheryl Daniels1974-11-24UHC-88831-9892638794925417 Palm Dr, Fresno, CA, 937820.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20040PRVHannah Campbbell2007-04-15—32551782939710 Canyon Rd, Phoenix, AZ, 850990.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24237PRVAshley O Valdez1999-02-10—2358623232483 Hillcrest Rd, Glendale, AZ, 853880.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22333PRVAlan U Patterson2007-11-15UHC-71714-8386633598025417 Baseline Rd, Seattle, WA, 981400.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24764PRVEugene Bailey1968-02-11UHC-60178-1052644729135402 Church St, Tempe, AZ0.76Name re-casedDate of birth reformattedPhone reformattedZIP missing+2 more
PRV-28733PRVAustin Contreras1941-12-19UHC-72120-4928879227147460 Canyon Rd, San Diego, CA, 921250.76Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21179PRVRyan Rivera1974-02-14—66323189026236 Desert Sky Blvd, Mesa, AZ, 852580.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-23880PRVJeremy Romero1954-11-14UHC-73018-0434678712254322 Bayshore Dr, Sacramento, CA, 958340.76Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more
PRV-27876PRVPamela Shaw1999-12-17UHC-66394-2924951462706583 Indian School Rd, Tampa, FL, 336900.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27126PRVAisha Harvey1979-02-02UHC-39601-0922929882334208 Main St, Dallas, TX, 752110.76Name re-casedDate of birth reformattedPhone reformattedZIP+4 trimmed+2 more
PRV-24097PRVKyle Young1957-11-24—21170344915907 Harbor Blvd, San Antonio, TX, 782310.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24212PRVJason Ortega1941-09-03UHC-52395-15—8529 Indian School Rd, Seattle, WA, 981660.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
9,596 rows, page 90 of 192PreviousNext