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

Claims, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-417429CLMMaria Jenkins1941-07-28UHC-97871-08—771 Ridge Rd, Denver, CO, 802020.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-429041CLMMei Thompson1980-10-20UHC-34224-4970025223553545 Harbor Blvd, San Antonio, TX, 782320.50Name split from “Last, First”Phone reformattedCity re-casedZIP+4 trimmed+3 more
CLM-415598CLMRuth Hall——2722957547470 Apache Blvd, Columbus, OH, 432900.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404556CLMSean Moreno1989-08-28UHC-94786-19—8250 Elm St Apt 4, San Diego, CA, 921880.50Name re-casedSSN last four extractedUnit split from streetStreet suffix standardised+3 more
CLM-406292CLMNathan Powell1989-03-17UHC-58381-414416767283683 Willow Ct, Seattle, WA, 981770.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-413067CLMStephen Montgumery1975-11-13UHC-57923-64—2336 Church St, Dallas, TX, 752190.50Phone missing area codeStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-414828CLMHenry V Perkins1980-07-05—45190605105280 Camelback Rd, Miami, FL0.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403651CLMEvelyn Ray1914-10-09UHC-12550-9323132908121967 Camelback Rd Apt 33, Eden Prairie, MN, 553300.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-430950CLMTimothy Robinson1984-01-20—60924185862406 Maple Ave, Miami, FL0.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-405135CLMSara Pena1957-03-18UHC-34572-9062027557661798 River Rd, Tampa, FL0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-409806CLMHelen Alexander——36257486197137 Cedar Ln, Nashville, TN, 372620.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-420742CLMCarl Banks1980-11-20UHC-01367-28—6504 Mountain View Dr Apt 25, Minneapolis, MN, 554670.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-416559CLMJacck Bowman1940-04-17—30629097538293 Washington St Apt 11, Gilbert, AZ, 852050.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
CLM-417097CLMHannah Graham2005-01-26UHC-42390-49—3757 Meadow Ln, Eden Prairie, MN, 553640.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-407385CLMGeorge Holmes1997-06-27UHC-85048-47—6643 Hillcrest Rd, Denver, CO, 802780.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-400896CLMLori C Dixon—UHC-20645-16—2347 Sunset Blvd, Plano, TX0.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-422818CLMSfoia P Rodriguez1941-08-23UHC-80555-0298851054385934 Harbor Blvd, Atlanta, GA, 303490.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-428334CLMJoyce Wng1947-06-23UHC-83210-2295020798853082 Meadow Ln, San Diego, CA, 921640.50Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+3 more
CLM-414104CLMAmanda U Shaw1966-03-05UHC-91321-72—7331 Washington St, Columbus, OH, 432560.50Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-420943CLMRussell Bell2006-04-02UHC-91116-5829879687582688 Jefferson Ave, Atlanta, GA, 303800.50Name re-casedTwo-digit birth yearPhone reformattedState name converted to code+3 more
CLM-431230CLMJerremy Garrett1946-10-22UHC-79001-2261887900071633 Indian School Rd # 273, Gilbert, AZ, 852400.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
CLM-408298CLMJean White1946-10-19——546 Desert Sky Blvd # 990, Los Angeles, CA, 900960.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-412055CLMPriya Miller1996-01-07UHC-98912-3633882823009293 Valley View Dr, Las Vegas, NV0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-430443CLMAndreew S Vega1963-12-13UHC-45507-37—2350 Harbor Blvd, Eden Prairie, MN, 553920.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430704CLMAhmmed A Cooper1942-03-08UHC-91936-31—8482 Valley View Dr, Los Angeles, CA0.50Street suffix standardisedAddress re-casedZIP missingGender normalised+3 more
CLM-421661CLMHeather F Duncan1946-05-05—79398818377012 Central Ave, Mesa, AZ, 852310.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-428030CLMRalph Lee———9298 Oak St # 834, San Antonio, TX, 782720.50Name re-casedDate of birth missingUnit split from streetStreet suffix standardised+3 more
CLM-406499CLMBarbara Lynch1958-02-01UHC-29653-61—8824 Maple Ave, Austin, TX, 787420.50Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407391CLMDylan Stone1968-07-11——4962 Market St # 463, Charlotte, NC0.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-428338CLMElizabeth Dean—UHC-02330-44—2775 Harbor Blvd, Glendale, AZ, 853720.50Name split from “Last, First”Date of birth reformattedDate of birth unreadableStreet suffix standardised+3 more
CLM-404648CLMMary Wilson2008-01-16——5888 Canyon Rd # 670, Los Angeles, CA, 900790.50Name re-casedDate of birth reformattedPhone missing area codeUnit split from street+3 more
CLM-400360CLMAnna Stevens1970-11-09UHC-64371-858123424815582 Union St, Orlando, FL, 328280.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-429909CLMBarb Carroll1966-01-23—52396375707998 Harbor Blvd, San Diego, CA, 921160.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-402522CLMMary Shaw1961-12-27UHC-19721-07—958 Palm Dr # 393, Denver, CO, 802900.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-413628CLMKeith Banks——42064151388804 Camelback Rd, Las Vegas, NV, 891710.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-421858CLMLauren Garza1939-08-06UHC-35044-2848456046017624 Church St, Phoenix, AZ0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-413025CLMKayla Gardner1947-02-13UHC-87728-37—9879 Elm St, Jacksonville, FL, 322780.50Name split from “Last, First”Two-digit birth yearMember ID reformattedStreet suffix standardised+3 more
CLM-405935CLMPeter Simpson1980-02-20UHC-03143-6240889074832473 Lincoln Way Apt 4, Fresno, CA0.50Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
CLM-423022CLMCarl N Barnes1952-12-04UHC-59895-5864923582606835 River Rd # 953, San Antonio, TX0.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-404277CLMVirginia H Ross1944-06-04UHC-66259-5640148276088604 Maple Ave, Tempe, AZ, 852970.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-413947CLMMason Rios1950-09-14—22082205288770 Washington St, Glendale, AZ0.50Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-422107CLMOlivia Davis1995-11-18——5346 Elm St, Columbus, OH0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430466CLMJoyke Sanders1972-01-18—6839567999566 Union St # 641, Las Vegas, NV, 891770.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-428959CLMRobert Carter1978-08-07——1465 Ocean Ave, Eden Prairie, MN, 553370.50Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-414509CLMSamuel Guerrero2004-08-11—35622211194432 Willow Ct, Plano, TX, 750400.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418453CLMJulia Jackson1987-05-03UHC-00538-03—9856 Maple Ave, San Antonio, TX, 782520.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412200CLMKaren Y Jackson1949-11-02——1976 Main St, Tempe, AZ0.50Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+3 more
CLM-409431CLMAhmed T Le2003-06-10UHC-34122-14—1420 Washington St # 228, Las Vegas, NV0.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-418744CLMMarilyn Barnes1997-03-01UHC-46631-1495466933171252 Mountain View Dr, Chandler, AZ, 852750.50Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430555CLMBilly Reid1999-03-09UHC-17079-68—2250 Apache Blvd, Eden Prairie, MN, 553760.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
32,829 rows, page 38 of 657PreviousNext