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-419127CLMEtan Wood1959-11-23——2316 Washington St, Austin, TX, 787530.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-414528CLMBryan Anderson1956-03-03——2161 Meadow Ln, Orlando, FL0.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-402062CLMBarbara Jacobs1984-08-03—53436953832168 Harbor Blvd, Scottsdale, AZ, 852450.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-432418CLMMateo Morneo—UHC-15058-8451230382631447 Ridge Rd # 976, Tempe, AZ, 852990.50Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-421270CLMStephen Wang1979-08-11UHC-64067-18—1084 Washington St, Austin, TX, 787670.50Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-429430CLMDorothy Collins2002-11-16——7220 Forest Ave, Mesa, AZ0.50Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-423893CLMCarol Riley1995-12-18UHC-60140-2627068659806128 Main St, Tampa, FL, 336270.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-420449CLMAaron Andrews1995-07-06UHC-11785-20—4074 Central Ave, Charlotte, NC, 282690.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-413134CLMMarilyn Aguilar1989-02-22——4665 Baseline Rd, Chandler, AZ, 852350.50Street suffix standardisedAddress re-casedState code upper-casedZIP+4 trimmed+3 more
CLM-417574CLMElizabeth Baker1994-09-04UHC-60905-9520543339349587 Park Pl, San Antonio, TX0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-416819CLMDiana Chen1971-06-13UHC-87642-8139981800063556 Meadow Ln, Eden Prairie, MN, 553130.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-416818CLMDiana Chen1971-06-13UHC-87642-8139981800063556 Meadow Ln, Eden Prairie, MN, 553130.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-406840CLMJacob W Jenkins1968-04-24——3294 Union St # 479, Glendale, AZ, 853550.50Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-417965CLMSofia Ramirez1976-11-13—48266153728190 Camelback Rd # 946, Jacksonville, FL0.50Phone reformattedUnit split from streetCity re-casedState name converted to code+3 more
CLM-418220CLMStephen Brown1992-11-14——2974 Baseline Rd, Austin, TX, 787430.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-418998CLMCynthia Mitchell1944-10-20—35373541496540 Meadow Ln, Charlotte, NC, 282190.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-408796CLMDenise Parker1947-11-17UHC-17727-44—1449 Central Ave, Tempe, AZ0.50Member ID reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-421700CLMMariana G Wilson1947-07-01——4779 Canyon Rd, Dallas, TX, 752720.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423178CLMKelly Lucas1947-12-15UHC-15635-05—6413 Meadow Ln, Seattle, WA, 981180.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-417588CLMAndrea Le1957-02-16UHC-70351-27—8785 Canyon Rd # 219, Sacramento, CA, 958540.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-408122CLMJason Mason1983-09-02UHC-84953-5052788081186011 Washington St Apt 11, Sacramento, CA, 958000.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-402607CLMGerald Howell1941-04-08——2627 Baseline Rd, Minneapolis, MN0.50Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-419332CLMGregory F James1971-03-22UHC-64701-90—669 Desert Sky Blvd, San Antonio, TX, 782940.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425167CLMRandy Jensen2008-05-28—41074486847270 Ridge Rd, Austin, TX0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423738CLMAlan Thompson1972-10-05UHC-77689-96—2288 Sunset Blvd, Eden Prairie, MN, 553460.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-411546CLMMaria Snyder1966-05-27UHC-84820-97—5805 Mountain View Dr, Denver, CO, 802550.50Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-422414CLMGary Espinoza1942-02-25UHC-09582-4442346650728150 Mesa Dr, Mesa, AZ0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-420402CLMCarol Ortega1996-01-15UHC-51717-7359678030695241 Central Ave Apt 18, Tampa, FL, 336120.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-432665CLMZachary Allen1997-01-10——2122 Union St, Plano, TX, 750210.50Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-413780CLMGloria Ray1982-06-02—823277365864 Central Ave, Tucson, AZ, 857120.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-406504CLMEmma S Pena1949-07-17UHC-14042-8531621651562462 Highland Ave, Nashville, TN, 372450.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428898CLMDan Ward1941-04-15UHC-94840-20—2104 Palm Dr, Denver, CO, 802940.50Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more
CLM-422641CLMDeborah Wilils1974-02-17——2399 Harbor Blvd, Miami, FL0.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-407502CLMCamila A Sandovval1972-06-25—61538616857717 Ocean Ave, Jacksonville, FL0.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-418592CLMCatherine Coleman2004-08-12UHC-75249-3955082842244690 Camelback Rd, San Antonio, TX, 782920.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-407403CLMPeter Riley1989-11-21UHC-68971-8259367593355137 Willow Ct, Phoenix, AZ, 850180.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403788CLMSamuel Ramireez1986-05-28UHC-35438-68—895 Church St, Glendale, AZ, 853760.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-419681CLMOlivia Z Arnold—UHC-48489-95—824 Forest Ave, Plano, TX, 750490.50Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-414647CLMSantiago Wong1981-08-16—23856276897006 Mesa Dr, Jacksonville, FL0.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-416533CLMAlexander Perkins1959-03-26UHC-60662-97716433639526 Camelback Rd Apt 21, Plano, TX0.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-426066CLMCharles Tucker1961-02-23——6126 Indian School Rd, Mesa, AZ, 852190.50Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-403433CLMAnthony Salazar—UHC-22769-73—3940 Hillcrest Rd, Plano, TX0.50Date of birth missingMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400128CLMWilliam Den—UHC-57472-0222069017798983 Spring St, Austin, TX0.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-422351CLMMatthew Hoffman1995-04-23——3568 Church St # 305, Gilbert, AZ, 852310.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-423939CLMGerald Foster———8689 Jefferson Ave # 482, Tucson, AZ, 857620.50Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+3 more
CLM-422743CLMWillie Delgado1965-09-16UHC-47830-16—2592 Sunset Blvd, Charlotte, NC, 282570.50Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410259CLMFatima Sandoval1987-09-14UHC-28392-8089566151931902 Mountain View Dr, Denver, CO, 802950.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-402646CLMJoyce Armstrong1968-01-03——7518 Desert Sky Blvd # 468, Houston, TX, 770240.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-412489CLMHenry Nguyen1975-07-18UHC-89598-3449256280113106 Palm Dr, Columbus, OH0.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-426125CLMLogan Lucas1974-09-21UHC-41254-21—6921 Harbor Blvd Apt 2, Plano, TX0.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
32,829 rows, page 35 of 657PreviousNext