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

All sources, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-120838ENRJacob V George1957-06-02UHC-55194-6942238899381133 Lincoln Way # 436, Eden Prairie, MN, 553830.52Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+2 more
ENR-111678ENRAhmed Vasquez1956-06-02UHC-88338-8174623832316948 Camelback Rd, Gilbert, AZ, 852820.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-406545CLMBrian Y Nunez1966-01-09——8089 Sunset Blvd, Las Vegas, NV, 891660.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
CLM-413789CLMAlice Baker1952-04-16UHC-01066-48—2666 Church St, Gilbert, AZ0.52Street suffix standardisedAddress re-casedZIP missingEmail lower-cased+2 more
CLM-416572CLMJake Hall2001-06-06UHC-90583-09—2618 Ridge Rd # 477, Phoenix, AZ, 850940.52Name split from “Last, First”Date of birth reformattedUnit split from streetZIP+4 trimmed+2 more
ENR-108355ENRAlice F Freeman1970-09-12UHC-21999-4458159017589795 Sunset Blvd, Eden Prairie, MN, 553110.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-422713CLMLarry Daniels———5621 Market St, Glendale, AZ, 853430.52Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
ENR-110320ENRJoan Ellis2007-12-16—44977793183040 Willow Ct, Atlanta, GA0.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-121552ENRJeremy O Bizhop1971-03-21UHC-33995-1239680422037906 Lake View Rd, Minneapolis, MN, 554500.52Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-138765ENRMargaret Hanson1994-05-23UHC-18541-055189797677614 Lake View Rd, Charlotte, NC, 282680.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-138146ENRCatherine T Harrison—UHC-57587-4170157021168631 Bayshore Dr, Plano, TX, 750310.52Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
CLM-408844CLMMarilyn T Richards1995-06-26UHC-52260-31—2627 Church St Apt 15, Denver, CO, 802400.52Middle initial moved out of first nameUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-50837TPAKyle Z Phillips1964-08-19——4114 Cedar Ln, Chandler, AZ0.52Name re-casedTwo-digit birth yearZIP missingGender normalised+2 more
ENR-140894ENRArjun M West1942-08-06UHC-19962-7950585163657968 Main St, Jacksonville, FL0.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
TPA-51163TPACarl George1959-08-09——2222 Oak St, Tucson, AZ, 857390.52Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-141753ENRBruce Sandoval1945-12-02UHC-23741-56—2479 Mesa Dr, Mesa, AZ, 852820.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-107420ENRNicholas Alvarado1951-11-27UHC-40551-4898962613574682 Baseline Rd, Eden Prairie, MN0.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
ENR-140212ENRSophia M Soto1949-02-25UHC-01510-2956224365618505 Ridge Rd # 709, Jacksonville, FL, 322870.52Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
CLM-432784CLMMateo Simpson—UHC-48188-73—9683 Canyon Rd, Minneapolis, MN, 554090.52Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+2 more
ENR-107872ENRPhilip A Gibson1968-03-08UHC-90044-5470871592019675 Highland Ave Apt 23, Minneapolis, MN, 554480.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-122731ENRLuis C Payne—UHC-99621-9475428274229208 Baseline Rd Apt 19, Houston, TX, 770570.52Name re-casedDate of birth unreadablePhone reformattedUnit split from street+2 more
PRV-24925PRVNuah Turner1949-03-28——441 Palm Dr # 868, Chandler, AZ, 852870.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-100229ENRAlexis M Jensen1969-07-01UHC-56840-4433651676146717 Pine Dr, Phoenix, AZ, 850670.52Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-102046ENRRichard P Stewart1997-01-27UHC-90730-92—524 Mountain View Dr, Miami, FL0.52Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+2 more
TPA-61307TPAMason McDonaald1974-03-23UHC-56620-7986895198162651 Mountain View Dr, Glendale, AZ0.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-414270CLMAlbert R Watson1984-01-26UHC-54144-2829240543348403 Sage Ct, Las Vegas, NV0.52Name re-casedTwo-digit birth yearPhone reformattedZIP missing+2 more
ENR-107984ENRScott L Kim1949-12-21UHC-98455-8677247424073083 Ocean Ave, Tempe, AZ0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22216PRVDonna Ford1941-04-09—25059444186615 Canyon Rd Apt 31, Las Vegas, NV, 891570.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-400742CLMCarolyn Hanson2008-08-09UHC-95340-585937236006300 Indian School Rd, Houston, TX, 770160.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-58643TPADennis Bowman2001-08-12UHC-53395-8087663622454292 Market St Apt 8, Charlotte, NC, 282580.52Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-110873ENRMarcus P Parker1974-11-24UHC-90476-5892944086418429 Camelback Rd, Chandler, AZ, 852550.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54871TPAElijah Sullivan1941-04-26—34959929447717 Lake View Rd, Eden Prairie, MN, 553730.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-120454ENRSean A Fisher—UHC-79579-4171088553812407 Market St, San Diego, CA, 921480.52Date of birth unreadablePhone reformattedState name converted to codeGender normalised+2 more
TPA-58356TPABradley Soto1989-06-17——4949 Lake View Rd, Los Angeles, CA, 900930.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-423004CLMJulia Schmidt1983-02-09——3498 Valley View Dr, Charlotte, NC, 282760.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
ENR-139633ENRAlan P Gilbert———7071 Union St, Columbus, OH, 432980.52Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
ENR-116245ENRJeffrey C Cruz1953-02-14UHC-64784-69—6155 Ocean Ave # 695, Nashville, TN, 372110.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-112428ENRJoan Dominguez2006-01-28UHC-90621-1934738734363534 Canyon Rd # 389, Miami, FL, 331190.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-404784CLMStephen Li1994-06-25UHC-49292-64—9593 Harbor Blvd, Atlanta, GA, 303210.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
TPA-64228TPALisa Graham1951-12-26——4093 Ridge Rd, Tampa, FL0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
CLM-425786CLMDanielle Bradley1998-02-18——670 Pine Dr, Denver, CO, 802010.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52868TPALinda Myers1975-11-06—24658365218146 Church St, Phoenix, AZ, 850390.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-125705ENRPhilip Ferguson1991-08-28UHC-35676-8834826703248340 Desert Sky Blvd, Tucson, AZ, 857090.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-142606ENRNathan A Palmer2006-09-05UHC-74591-49—4351 Elm St, Scottsdale, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
ENR-138594ENRRussell T Simpson1976-04-09UHC-87350-8450163092469007 Palm Dr, Tampa, FL, 336430.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-430554CLMKathleen P Spencer1986-11-25UHC-15103-98—8175 Broadway, Charlotte, NC, 282010.52Middle initial moved out of first nameName re-casedState name converted to codeGender normalised+2 more
CLM-411319CLMBetty Rojas1976-12-27UHC-59588-79—3322 Hillcrest Rd, Sacramento, CA, 958310.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-410867CLMMegan Carpenter—UHC-78670-63—3675 Willow Ct, Nashville, TN, 372310.52Date of birth unreadableMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416047CLMVirginia Harvey1957-05-13UHC-73952-53—5319 Indian School Rd # 324, Seattle, WA, 981010.52Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+2 more
ENR-110428ENRFrank Franklin2003-09-11UHC-27271-2459145124967574 Broadway # 630, Phoenix, AZ, 850200.52Date of birth reformattedUnit split from streetAddress re-casedZIP+4 trimmed+2 more
100,000 rows, page 175 of 2,000PreviousNext