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

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-402986CLMCarolyn SJunk2004-03-16UHC-59025-32—9472 Desert Sky Blvd, Chandler, AZ, 852980.68Street suffix standardisedAddress re-casedPlaceholder values clearedNo usable name (quarantined)
CLM-414705CLMCynthia Green1979-06-21UHC-66762-67—1316 Jefferson Ave Apt 29, Orlando, FL, 328830.68Member ID reformattedUnit split from streetState name converted to codePlaceholder values cleared
CLM-427646CLMSofia Arnold1973-09-13UHC-41265-386218378889423 Market St # 601, Sacramento, CA, 958430.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-409775CLMJason Larson1981-03-24——50 Bayshore Dr, Dallas, TX, 752750.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-428473CLMTerry Howard1938-02-09UHC-55912-8934998228874948 Washington St, Jacksonville, FL, 322510.68Two-digit birth yearPhone reformattedZIP+4 trimmedPlaceholder values cleared
CLM-428472CLMTerry Howard1938-02-09UHC-55912-8934998228874948 Washington St, Jacksonville, FL, 322510.68Two-digit birth yearPhone reformattedZIP+4 trimmedPlaceholder values cleared
CLM-400001CLMBilly Woods1966-12-16UHC-33855-54—9218 Palm Dr, Los Angeles, CA, 900650.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-427160CLMSue Owens1941-08-12———0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-420495CLMNicole P George2006-06-12—53875335065730 Sunset Blvd, Austin, TX, 787500.68Phone reformattedSSN last four extractedGender normalisedPlaceholder values cleared
CLM-406907CLMLauren Moore1988-05-28UHC-05013-5541054895208085 Spring St # 934, Tempe, AZ, 852170.68Name re-casedUnit split from streetZIP+4 trimmedPlaceholder values cleared
CLM-423391CLMHiroshi Greene1999-03-25—75985212732623 Maple Ave, Las Vegas, NV, 891760.68Name split from “Last, First”ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
CLM-408961CLMPriya Carr1970-04-24UHC-13946-61—5301 Church St, Plano, TX, 750930.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-408960CLMPriya Carr1970-04-24UHC-13946-61—5301 Church St, Plano, TX, 750930.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-401502CLMKimberly A Miller2002-12-17—59773275993861 Ridge Rd, Sacramento, CA, 958330.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-429126CLMLauren Wagner1959-01-09UHC-76656-6981061617866697 Highland Ave, Seattle, WA, 981720.68Phone reformattedState name converted to codeZIP+4 trimmedPlaceholder values cleared
CLM-428097CLMMelisas Hawkins1975-06-26UHC-87638-8743866897929255 Harbor Blvd, Chandler, AZ, 852250.68City re-casedZIP+4 trimmedGender normalisedPlaceholder values cleared
CLM-415383CLMSantiago Tayllor2007-08-18———0.68Name split from “Last, First”Phone missing area codeWhitespace trimmedPlaceholder values cleared
CLM-421244CLMMartha Sullivan2007-02-09——175 Main St, Eden Prairie, MN, 553430.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-420588CLMEmma Sanders1948-08-06UHC-54455-12—6865 Sage Ct, Nashville, TN, 372970.68Date of birth reformattedZIP+4 trimmedGender normalisedPlaceholder values cleared
CLM-420587CLMEmma Sanders1948-08-06UHC-54455-12—6865 Sage Ct, Nashville, TN, 372970.68Date of birth reformattedZIP+4 trimmedGender normalisedPlaceholder values cleared
CLM-401849CLMJacob Holmes1993-04-12——9299 Apache Blvd, Austin, TX, 787640.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-401850CLMJacob Holmes1993-04-12——9299 Apache Blvd, Austin, TX, 787640.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-409032CLMCatherine Gordon1995-11-23UHC-95390-20—8861 River Rd, Austin, TX, 787800.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-415914CLMJulie Rios1994-08-06UHC-27625-4189542992765635 Lincoln Way, Los Angeles, CA, 900020.68Name split from “Last, First”Phone reformattedGender normalisedWhitespace trimmed
CLM-408743CLMRandy Thompson1994-11-20UHC-81534-47—4277 Elm St, Houston, TX, 770810.68Phone missing area codeGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-403036CLMPatricia Ray1993-04-14——7829 Jefferson Ave, Phoenix, AZ, 850200.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-421774CLMLuis McDonald1940-06-07UHC-12314-1287129621484096 Main St, Glendale, AZ0.68Phone reformattedMember ID reformattedSSN last four extractedZIP missing
CLM-401354CLMJean Lucas1940-03-20UHC-13467-3123227390614579 Union St, Scottsdale, AZ, 852530.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
CLM-402562CLMMelissa Black1988-07-05—88294332292435 Meadow Ln Apt 16, Eden Prairie, MN, 553530.68Name split from “Last, First”Phone reformattedUnit split from streetPlaceholder values cleared
CLM-413079CLMKathryn Moreno1988-12-02——9188 Grand Ave Apt 11, Columbus, OH, 432390.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-402282CLMAna Z Vazquez1950-08-01UHC-27900-79—8506 Ridge Rd, Phoenix, AZ, 850550.68Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code
CLM-413316CLMJon Ellis1979-09-23UHC-80469-45—5849 Palm Dr, Tampa, FL, 336090.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-402750CLMPatrick Martin1999-03-11—8724437999—0.68Name split from “Last, First”Two-digit birth yearPhone reformattedPlaceholder values cleared
CLM-403595CLMIsabella Griffin1958-12-20UHC-44529-74—8641 Main St, Houston, TX, 770180.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-420310CLMSophia Kennedy1978-12-02——2158 Main St, Tucson, AZ0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-414618CLMCynthia Y Chavez2008-06-17——4829 Willow Ct, Mesa, AZ, 852990.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-410872CLMThomas Luna1986-04-10UHC-64102-71—3916 Bayshore Dr, Houston, TX, 770250.68Name re-casedStreet suffix standardisedAddress re-casedGender normalised
CLM-418151CLMChristine Boyd1960-02-28——7777 Elm St # 849, Jacksonville, FL, 322440.68Unit split from streetZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
CLM-426252CLMThomas Anderson1934-05-21—65149955725771 Canyon Rd, Sacramento, CA, 958550.68Name re-casedState name converted to codeZIP+4 trimmedPlaceholder values cleared
CLM-406614CLMJose Roberts1942-07-12UHC-90725-16—1301 Elm St, Jacksonville, FL0.68Street suffix standardisedAddress re-casedCity re-casedZIP missing
CLM-413605CLMKevin S Price1988-06-23—57277586978595 Broadway, Austin, TX, 787860.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-427700CLMKathy West2001-01-25——798 Central Ave, Dallas, TX, 752130.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-427699CLMKathy West2001-01-25——798 Central Ave, Dallas, TX, 752130.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-428115CLMPriya Lopez1947-04-09UHC-53383-79—6000 Harbor Blvd, Chandler, AZ, 852960.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-419972CLMBobby Murphy1992-04-03——4556 Ridge Rd, Houston, TX, 770890.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-424370CLMPeter F Alvarez1972-06-19——1142 Church St Apt 34, Tempe, AZ, 852630.68Unit split from streetGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-418211CLMCynthia Rogers1951-07-01UHC-45664-9925665254356059 Broadway, Charlotte, NC, 282230.68ZIP+4 trimmedGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-425925CLMAbigail P Luna1954-12-16UHC-36079-6571485490858942 Hillcrest Rd, Dallas, TX, 752300.68Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased
CLM-400346CLMEugene Campbell1951-03-21UHC-94513-70—9531 Central Ave # 147, Atlanta, GA, 303700.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-428577CLMHarold Sandoval2006-12-28UHC-13759-35—3094 Mountain View Dr Apt 8, Jacksonville, FL, 322880.68Name re-casedUnit split from streetGender normalisedPlaceholder values cleared
32,829 rows, page 204 of 657PreviousNext