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-27695PRVEmily Lucas1987-03-01——664 Hillcrest Rd, Atlanta, GA, 303250.64Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-21144PRVDan Palmer1960-03-08UHC-52734-9345430069462641 Apache Blvd, Chandler, AZ, 852820.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-26348PRVFrances L Ruiz1994-03-16—38179427299212 Main St, Atlanta, GA, 303530.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28690PRVArjun Martinez1977-04-11—62636501665901 Central Ave # 438, Phoenix, AZ, 850910.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-24101PRVDavid Y Garcia2002-10-28—27292157034316 Church St, Sacramento, CA, 958170.64Name re-casedPhone reformattedState name converted to codeEmail lower-cased+2 more
PRV-26830PRVHenry E Weaver2006-03-11—88585792341779 Ridge Rd, Tucson, AZ, 857840.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-22795PRVDebra Mitchell1988-07-23UHC-96771-5938833798007275 Lincoln Way, Las Vegas, NV0.64Date of birth reformattedPhone reformattedCity re-casedZIP missing+2 more
PRV-26925PRVVicky Clark—UHC-04405-7270230786487958 Indian School Rd, Scottsdale, AZ, 852470.64Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
PRV-20721PRVKathleen Cole1991-08-26UHC-27256-0158450725617611 Central Ave, Fresno, CA, 937300.64Name re-casedPhone reformattedCity re-casedZIP+4 trimmed+2 more
PRV-20773PRVAaron Harvey2001-07-05UHC-57296-5181995997525852 Apache Blvd, Glendale, AZ, 853730.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-22962PRVElijah Gutierrez1994-08-15—96593073772882 Spring St Apt 27, Los Angeles, CA, 900520.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
PRV-24356PRVArjun Ward1980-04-04—3409287056535 Willow Ct, Denver, CO, 802120.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-25430PRVPaul Campbell1957-07-01UHC-49908-48—571 Palm Dr, Sacramento, CA, 958910.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-26924PRVBilly A Watkins1990-11-07UHC-49351-5351728487244593 River Rd, Las Vegas, NV, 891530.64Date of birth reformattedPhone reformattedZIP+4 trimmedGender normalised+2 more
PRV-23704PRVRobert Dixon2000-10-05—57458044477749 Meadow Ln, Denver, CO, 802340.64Date of birth reformattedPhone reformattedZIP+4 trimmedGender normalised+2 more
PRV-29491PRVJoe Stevens1952-07-16—57858757086977 Apache Blvd, Seattle, WA, 981740.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24040PRVPamela Chen1941-11-06—79794373798718 Canyon Rd, Fresno, CA, 937880.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-20871PRVRandy Ward1980-01-25UHC-24436-3979755444501813 Union St, Plano, TX, 750090.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-29328PRVKathleen Crawford1969-08-11UHC-66203-106363262724432 Central Ave, San Antonio, TX, 782060.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
PRV-22345PRVJeremy Reyes—UHC-87372-549305131662—0.64Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+2 more
PRV-20685PRVAlan Rice1989-01-27UHC-29266-3495351428674973 Church St, Tucson, AZ, 857210.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-23483PRVMichael Bishop1941-05-08—24785812565310 Lincoln Way, Tempe, AZ, 852310.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22327PRVBrian X Crawford1992-10-20UHC-01606-11—8357 Mountain View Dr, Nashville, TN, 372180.64Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20179PRVDaniel U Cox1941-11-23UHC-76175-4496164762897426 River Rd Apt 11, Dallas, TX, 752150.64Phone reformattedUnit split from streetCity re-casedGender normalised+2 more
PRV-29551PRVBryan Walker—UHC-36656-106824572043—0.64Name split from “Last, First”Date of birth unreadablePhone reformattedMember ID reformatted+2 more
PRV-29550PRVBryan Walker—UHC-36656-106824572043—0.64Name split from “Last, First”Date of birth unreadablePhone reformattedMember ID reformatted+2 more
PRV-26979PRVJanice Banks1964-06-22UHC-81252-6972161836076376 Church St, Scottsdale, AZ, 852750.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26980PRVJanice Banks1964-06-22UHC-81252-6972161836076376 Church St, Scottsdale, AZ, 852750.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28165PRVNichoals B West1984-01-12UHC-15259-4523950187155521 Grand Ave, Fresno, CA, 937760.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-27369PRVJoan Fowler1983-10-14UHC-85183-7871261095267025 Sage Ct, Fresno, CA, 937220.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22689PRVSophia Patterson1968-12-23—23271949606635 Church St, Jacksonville, FL, 322840.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25372PRVLogan Z Richardson1981-11-11—35665525892481 Apache Blvd # 472, Las Vegas, NV, 891670.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-20579PRVNathan Brooks——78763832785065 Meadow Ln, Charlotte, NC, 282840.64Name re-casedDate of birth unreadablePhone reformattedState name converted to code+2 more
PRV-23160PRVMadison Ellis1974-10-12UHC-31543-8563931161935893 Central Ave, Atlanta, GA, 303850.64Name split from “Last, First”Phone reformattedCity re-casedState name converted to code+2 more
PRV-29512PRVAmanda Bennett2004-01-08UHC-35446-7748276298396065 Union St, Columbus, OH, 432510.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-29408PRVAngela Riley1991-01-03UHC-71344-9252870362111064 Main St, Houston, TX, 770990.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-26846PRVKaren V Campbell1942-01-28—97064130404437 River Rd, Columbus, OH, 432640.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28714PRVOmar Gonzalez1968-04-12UHC-96715-9050242679817931 Forest Ave, Plano, TX, 750520.64Street suffix standardisedAddress re-casedState code upper-casedGender normalised+2 more
PRV-21050PRVDiane Y Robinson1940-05-24—45633584716707 Spring St, Orlando, FL, 328060.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
PRV-27202PRVIsabella Perkins1995-04-22UHC-94647-1798734611324650 Union St, Dallas, TX, 752450.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-21276PRVLucia M Wood——34187496198150 Pine Dr, Fresno, CA, 937260.64Name re-casedDate of birth unreadableCity re-casedGender normalised+2 more
PRV-21765PRVAhmed X Harper1954-11-08UHC-87526-5142635985811661 Central Ave, Tampa, FL, 336650.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-20433PRVAndrea Russell1985-03-04——9061 Ocean Ave, Houston, TX, 770800.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-26525PRVIsabella Kelly1959-02-25—45059334222733 Sunset Blvd, Dallas, TX0.64Name split from “Last, First”Date of birth reformattedState code upper-casedZIP missing+2 more
PRV-24729PRVAlbert Johnston1961-03-13UHC-99093-5492120377756902 Indian School Rd, Chandler, AZ, 852830.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21355PRVAshley Gordon1983-11-11—57979967327103 Spring St Apt 1, Glendale, AZ0.64Date of birth reformattedPhone reformattedUnit split from streetZIP missing+2 more
PRV-27698PRVHelen Lane1975-05-05UHC-35404-03—9691 Sunset Blvd # 561, Minneapolis, MN, 554700.64Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+2 more
PRV-26502PRVSean U Tucker1942-02-27—67698742104803 Canyon Rd, Minneapolis, MN0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-29080PRVAngela L Morriis1957-05-17——610 Grand Ave, Dallas, TX, 752190.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-20668PRVHiroshi Banks1989-07-07——3319 Ocean Ave, Las Vegas, NV, 891190.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
9,596 rows, page 52 of 192PreviousNext