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-402035CLMMatrha Dean1989-02-17—91920438215105 Spring St, Tempe, AZ, 852500.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423673CLMAlbert Santos1975-05-16—74592940572445 Church St Apt 39, Jacksonville, FL, 322290.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-405515CLMKatryn Lawson1941-09-02UHC-96469-2343961185596143 Washington St, San Antonio, TX, 782740.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-422801CLMKyle Freeman1959-03-26——1330 Jefferson Ave, Tucson, AZ, 857550.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410044CLMWarren Sean1961-04-01—82575385066622 Hillcrest Rd, Nashville, TN, 372860.62Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-410045CLMWarren Sean1961-04-01—82575385066622 Hillcrest Rd, Nashville, TN, 372860.62Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-424663CLMKayla Willis1994-12-20—66828342616807 Highland Ave, Scottsdale, AZ, 852410.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421100CLMRyan Li1963-09-10—23935495995648 Elm St # 719, Fresno, CA, 937350.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-411012CLMGloria Godon1952-09-04UHC-34684-5638257523419544 Camelback Rd, Orlando, FL, 328490.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-424252CLMKelly Evans1943-06-21UHC-73587-33—4317 Grand Ave, Miami, FL, 331880.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-409314CLMDouglas Pierce1939-01-26—39456487842467 Church St, Glendale, AZ, 853040.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424637CLMAutsin Bell1953-01-18UHC-52108-19—775 Canyon Rd, Eden Prairie, MN, 553720.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410221CLMEllijah Gutierrez1994-08-15UHC-33290-1596593073772882 Spring St, Los Angeles, CA, 900520.62Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-408737CLMGeorge Z Guerrero1954-03-15UHC-05538-4828556195555087 Union St, Eden Prairie, MN, 553140.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-414740CLMSandra Obrien1985-10-07UHC-52659-9090091666397731 Spring St, Atlanta, GA, 303200.62Name split from “Last, First”Name re-casedPhone reformattedStreet suffix standardised+3 more
CLM-418897CLMJean Fields1944-12-22UHC-82456-16—4268 Elm St, Houston, TX, 770270.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-407198CLMHenry Miller1963-04-22UHC-82425-5239476735525024 Valley View Dr, Los Angeles, CA0.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-421169CLMPriya Ortega1998-10-25——2401 Park Pl # 271, Charlotte, NC, 282970.62Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-411606CLMNoah Burton1951-04-05UHC-87151-3332382789367202 Apache Blvd, San Diego, CA, 921290.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424791CLMTyler Weber1967-02-10UHC-32985-45—5659 Main St, Las Vegas, NV0.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-428381CLMJuan Marshall1938-10-26——4144 Maple Ave, Gilbert, AZ, 852840.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407911CLMFrank Franklin2003-09-11——7574 Broadway, Phoenix, AZ, 850200.62Date of birth reformattedAddress re-casedCity re-casedState name converted to code+3 more
CLM-415889CLMNatalie Murphy1958-12-02—23267047189355 Meadow Ln, San Antonio, TX, 782150.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427065CLMAna Bell2007-05-09——2813 Lake View Rd, Seattle, WA, 981270.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403984CLMMariana Johnson2003-10-16UHC-15319-3124897363849680 Park Pl, Plano, TX, 750400.62Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-408864CLMJerry Crawford1980-07-03UHC-60376-7391171807297106 Jefferson Ave # 683, Jacksonville, FL, 322190.62Name re-casedPhone reformattedMember ID reformattedUnit split from street+3 more
CLM-405531CLMLarry Spencer1976-10-23UHC-16960-57—5830 Lake View Rd, Miami, FL, 331390.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-410900CLMWayne Bennett1949-04-19UHC-21799-63—4620 Baseline Rd, Columbus, OH0.62Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-405568CLMMasson Gomez1962-04-19UHC-14665-9279550814233565 Hillcrest Rd, Gilbert, AZ, 852640.62Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-422229CLMGerald Hcks1938-04-05—47093599088131 Main St, Charlotte, NC, 282380.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-411398CLMJulie T Ortega1964-09-26UHC-75380-4384695920351649 Mountain View Dr, Fresno, CA, 937640.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423959CLMDigo Ramos2004-03-13UHC-23117-9240760075546810 Highland Ave, Tucson, AZ, 857250.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423958CLMDigo Ramos2004-03-13UHC-23117-9240760075546810 Highland Ave, Tucson, AZ, 857250.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405478CLMMei N Watkins1986-04-13—86137461172223 Apache Blvd, Chandler, AZ, 852620.62Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-426138CLMSharon P Burns——6054189476695 Oak St, Scottsdale, AZ, 852910.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-405035CLMCarlos G Young2004-11-02—68278875155970 Main St, Columbus, OH0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412490CLMHenry Nguyen1975-07-18UHC-89598-3449256280113106 Palm Dr, Columbus, OH, 432720.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400462CLMDavid Coleman1950-03-23—74444658662925 Main St # 565, Scottsdale, AZ, 852860.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-417887CLMPaul Lucas1946-06-15—77965976063616 Camelback Rd, Jacksonville, FL, 322620.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-415746CLMDoonald Murrray2001-12-17UHC-38778-25—7821 Lincoln Way # 717, Sacramento, CA, 958250.62Name re-casedMember ID reformattedUnit split from streetCity re-cased+3 more
CLM-415505CLMDebra Stone1984-04-14—34338463371874 Maple Ave, Atlanta, GA, 303850.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-422070CLMFatima Thomas1960-03-25—47765292989534 Sage Ct, Scottsdale, AZ, 852290.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-407106CLMMaria Collins1938-11-13UHC-92321-8963621049979590 Central Ave # 804, Mesa, AZ, 852610.62Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
CLM-408705CLMJulia A Lynch2006-07-12UHC-71261-133395189680962 Meadow Ln, Nashville, TN, 372110.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-414193CLMHenry F Holmes1999-05-23—63179161232925 Camelback Rd, Mesa, AZ, 852260.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-414192CLMHenry F Holmes1999-05-23—63179161232925 Camelback Rd, Mesa, AZ, 852260.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-410308CLMVincent Wilson1948-08-22UHC-04051-0395566129308307 Jefferson Ave, Dallas, TX, 752490.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-420270CLMKyle Rojas1966-04-09—45645675695815 Harbor Blvd, Glendale, AZ, 853890.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-412668CLMYuki Hoffman1940-03-10UHC-91732-5464937410972368 Harbor Blvd, Las Vegas, NV, 891000.62Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-410555CLMJoe Green1980-10-16UHC-41373-9660760110683650 Union St, Fresno, CA, 937850.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
32,829 rows, page 94 of 657PreviousNext