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-23062PRVCarol Hart1945-05-28—38124201237981 Pine Dr Apt 13, Austin, TX, 787890.46Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more
PRV-27381PRVMateo V Dean2000-12-27UHC-92928-499219120581493 Forest Ave, Plano, TX, 750460.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-21711PRVRachal Campbell2005-02-19UHC-11063-3168241968923867 Cedar Ln, Las Vegas, NV, 891010.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-21539PRVLawrence Hamilton1949-01-17—36622688278701 Sunset Blvd, Sacramento, CA0.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-24390PRVEric Cooper1969-04-02UHC-23594-28—282 Union St, Phoenix, AZ, 850080.46Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+5 more
PRV-28076PRVAnthony Oliver1962-09-24UHC-51791-985877572903697 Meadow Ln, Phoenix, AZ0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-27976PRVHudson K Alexander1964-03-17UHC-67582-644126394110965 Hillcrest Rd, Gilbert, AZ, 852900.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-23494PRVEvelyn Gardner1992-09-28UHC-73149-1893263507463445 Mountain View Dr Apt 14, Mesa, AZ, 852500.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
PRV-27875PRVRebecca D Mendoza2006-03-10UHC-41468-6086963900349585 Baseline Rd, Houston, TX, 770940.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-23741PRVChapman Heather1981-12-02—67950817317036 Park Pl, Minneapolis, MN0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-21599PRVDenise Dunn1954-05-11UHC-66614-2637971970485263 Sunset Blvd # 365, Tempe, AZ0.46Name re-casedPhone reformattedMember ID reformattedUnit split from street+5 more
PRV-25658PRVAisha Stone1984-07-07UHC-36349-477474481889905 Main St, Houston, TX0.46Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+5 more
PRV-20936PRVGary Palmer1948-08-24—73188824644655 Meadow Ln, Los Angeles, CA, 900910.46Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+5 more
PRV-27501PRVObrien M Laura2000-08-16—44860016813657 Desert Sky Blvd Apt 36, Los Angeles, CA, 900290.46Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+5 more
PRV-20657PRVStephen Mason1949-01-20—72674423555037 Ocean Ave, Columbus, OH, 432240.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-27711PRVKelly Carlson——56094767474379 Palm Dr Apt 19, Jacksonville, FL, 322810.46Name re-casedDate of birth unreadablePhone reformattedUnit split from street+5 more
PRV-21370PRVJesse Hernandez1989-02-19—79660251482786 Spring St, Fresno, CA0.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-29234PRVRuth F Mejia1994-02-05UHC-04349-3752445071764936 Ocean Ave, Seattle, WA, 981300.46Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
PRV-27059PRVGeorge B Gilbert1990-12-21UHC-16075-9681260493565038 Ocean Ave, Seattle, WA, 981650.46Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more
PRV-26326PRVCarol Mason1947-06-16UHC-05630-6841586041551548 Grand Ave Apt 38, Los Angeles, CA0.46Name re-casedPhone reformattedMember ID reformattedUnit split from street+5 more
PRV-20606PRVRandy D Barnes2000-03-03UHC-19730-932408991504429 Union St, Houston, TX, 770940.46Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
PRV-26078PRVAnthony Riley1941-12-25UHC-65454-3690967951106638 Willow Ct, Charlotte, NC0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-24808PRVAaron Willis1992-01-26UHC-69925-563095902243446 Grand Ave, Fresno, CA, 937470.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-23537PRVKathleen Hill1999-03-18UHC-13926-3729538584858010 Oak St, Fresno, CA, 937460.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-26271PRVVictoria Estrada1995-09-18UHC-18975-43—1939 Park Pl Apt 19, Seattle, WA, 981240.46Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
PRV-26272PRVVictoria Estrada1995-09-18UHC-18975-43—1939 Park Pl Apt 19, Seattle, WA, 981240.46Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
PRV-27366PRVSara Kelley1984-12-26UHC-19411-9726666519231137 Meadow Ln, Glendale, AZ, 853530.46Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more
PRV-27314PRVNicole Gilbert1951-01-25UHC-93489-4277028183606879 Market St, Orlando, FL, 328530.46Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+5 more
PRV-24317PRVJack A Chavez1996-05-15—53161871913756 Sunset Blvd, Gilbert, AZ, 852750.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-22845PRVAbigail Jenkins2005-12-11UHC-73523-6772178800875428 Apache Blvd, San Diego, CA, 921850.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-23411PRVDebra Lewis1949-12-24—43480893989547 Meadow Ln # 330, Austin, TX0.46Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
PRV-25087PRV—Junk2005-01-27—88389637838651 Highland Ave, Nashville, TN, 372790.46Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+5 more
PRV-24558PRVAisha Q Hendeerson1986-02-18UHC-27793-06—563 Spring St, San Antonio, TX, 782870.46Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-28677PRVAustin O Gordon1964-09-27UHC-50210-6238759105639313 Highland Ave # 505, Jacksonville, FL, 322400.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
PRV-20652PRVHarold G Singh1949-12-22—58178026357435 Lake View Rd, San Antonio, TX, 782850.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-26178PRVBeverly Z Soto—UHC-36735-6528233671235451 Camelback Rd, Fresno, CA0.46Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+5 more
PRV-29125PRVArjun X Crawford—UHC-35273-6141337618668223 Highland Ave, Eden Prairie, MN, 553720.46Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+5 more
PRV-25939PRVKayla Richards1976-01-10UHC-42568-6625353207642779 Pine Dr, Dallas, TX, 752560.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
PRV-22070PRVLarry Myers2001-02-11—95990453056114 Church St, Atlanta, GA, 303270.46Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+5 more
PRV-23521PRVBeverly Z Harrison1962-03-11UHC-76087-4443364076088994 Cedar Ln, Sacramento, CA, 958360.46Middle initial moved out of first nameDate of birth reformattedPhone reformattedMember ID reformatted+5 more
PRV-23232PRVVirginia A Lynch2002-12-21UHC-46988-5354155574448501 Valley View Dr, Atlanta, GA, 303740.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-22637PRVBrandon G Jacobs1955-08-05UHC-10592-7285197385499500 Grand Ave Apt 1, Orlando, FL, 328250.46Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+5 more
PRV-21944PRVAmy Daniels2007-04-08—75680229921993 Main St, San Antonio, TX0.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-21538PRVScott AJunk1991-10-09UHC-85790-90—3667 River Rd, Gilbert, AZ, 852160.46Date of birth reformattedPhone missing area codeMember ID reformattedStreet suffix standardised+5 more
PRV-25727PRVMaria J Oliver1982-04-02UHC-92965-7894881596698314 Willow Ct # 843, Miami, FL0.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
PRV-23446PRVJanet Sullivan1964-11-13—39349030351756 Lake View Rd, Phoenix, AZ, 850390.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-21420PRVAmber Robinson2006-08-07UHC-29861-8664325453303458 Highland Ave, Mesa, AZ, 852930.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-22408PRVAna Richards2001-02-07UHC-53141-66—841 Sage Ct, Glendale, AZ0.46Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+5 more
PRV-20925PRVGeorge Willis1939-10-03UHC-36586-6477544868014974 Maple Ave # 728, Phoenix, AZ, 850760.46Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more
PRV-28788PRVNoha Salazar2006-01-25—59957191981356 Meadow Ln, Tempe, AZ, 852730.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
9,596 rows, page 5 of 192PreviousNext