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
CLM-416976CLMContreras Mark1994-06-05——7677 Indian School Rd, Sacramento, CA, 958310.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-123648ENRCarlyn D Coleman1985-08-11UHC-68786-2044076059696924 Bayshore Dr, Jacksonville, FL, 322250.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
ENR-139226ENRSusan Perry1946-01-03UHC-00025-27—8796 Camelback Rd, Eden Prairie, MN, 553090.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
ENR-113394ENRDylan P Simpsoon1996-12-09UHC-44034-7246726818354745 Lake View Rd, Minneapolis, MN, 554750.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-138496ENRCarolyn S Hernandez1939-12-07UHC-64823-0236322542572739 Pine Dr Apt 27, Austin, TX, 787390.52Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+2 more
ENR-141338ENRJoan O Jimeenz1945-02-22UHC-52208-38—3952 Valley View Dr, San Diego, CA, 921600.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-120122ENRSean Guzman2002-12-28UHC-71216-4735140303263295 Church St, Glendale, AZ, 853520.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
TPA-57906TPAEmily Luna1939-09-28—80892123404489 Market St Apt 36, Denver, CO, 802990.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-416885CLMAisha Garcia—UHC-35298-4525760116746404 Union St, Sacramento, CA, 958760.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-417150CLMMariaJunk1977-08-11—44776457507203 Central Ave, Los Angeles, CA, 900800.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-415730CLMMadison Castro1952-02-01UHC-96414-21—8120 Main St, Jacksonville, FL, 322230.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-114712ENRJohn S Gomez1958-03-19UHC-49320-7553546306425201 Park Pl, Orlando, FL0.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
TPA-50554TPAJoe Reid1960-07-03——8020 Sunset Blvd Apt 22, Seattle, WA, 981180.52Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+2 more
CLM-401838CLMCaroolyn U Jimenez1942-02-17UHC-13964-61—7201 Meadow Ln, Houston, TX, 770540.52Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-130990ENRPriya Fernandez1961-09-06UHC-54311-9222324941869179 Spring St, Tucson, AZ, 857850.52Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-413391CLMJanice Butler1974-06-26UHC-65173-31—5465 Park Pl, San Antonio, TX0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
ENR-111591ENRJacob D Hoffman1997-03-25UHC-51039-0168476495406402 Willow Ct, Chandler, AZ, 852360.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-425469CLMSteven Ramos1969-01-26——1184 Hillcrest Rd Apt 12, Sacramento, CA0.52Name re-casedUnit split from streetZIP missingGender normalised+2 more
CLM-404931CLMCynthia Chapman1978-05-02UHC-75673-50—8451 Willow Ct, Dallas, TX, 752090.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-111619ENRTheresa Wheeler1953-07-08UHC-04306-8732835426338531 Camelback Rd, San Diego, CA, 921870.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56544TPASara Jimenez1986-08-07——7674 Spring St, Nashville, TN, 372520.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-427801CLM—Junk1993-07-11—42423609701303 Maple Ave, Mesa, AZ0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-125658ENRAlexxander Fisher1947-06-15UHC-01049-2829397559733904 Baseline Rd # 325, Jacksonville, FL, 322990.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-54980TPADylan Deaan1940-04-18—37228138443307 Apache Blvd, Atlanta, GA0.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-128433ENRLarry Q Simpson1973-01-25UHC-81950-28—406 Lincoln Way, Charlotte, NC, 282350.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-125183ENRTerryJunk1994-07-21UHC-97302-8437478248981875 Indian School Rd, Dallas, TX, 752540.52Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-56509TPAJacob K Carr1995-12-25——473 Grand Ave Apt 3, San Antonio, TX, 782030.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-60629TPASofia Walker1997-10-01——3784 Oak St, Mesa, AZ, 852770.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
ENR-135614ENRLaura U Jackson1987-12-28UHC-55292-33—4088 Highland Ave, Chandler, AZ, 852700.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-109642ENRSofia Henderson1998-04-15UHC-82416-1139945386786222 Cedar Ln, Eden Prairie, MN, 553140.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-133534ENRLuis Y Green1964-04-24UHC-57723-185752658492873 Indian School Rd, Fresno, CA, 937830.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20856PRVArjun Turner1984-09-08——8735 Valley View Dr, Phoenix, AZ, 850670.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-410260CLMDanielle Jenkins1949-07-28UHC-41018-56—5059 Oak St, Nashville, TN, 372150.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-406610CLMSophia Carroll1979-02-23——5642 Desert Sky Blvd Apt 21, Atlanta, GA0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-101614ENRDiana H Morrison—UHC-01125-53—9490 Willow Ct, Minneapolis, MN, 554720.52Date of birth unreadableStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
ENR-100341ENRJonathan P Black1952-12-24UHC-08559-01—6042 Forest Ave, Seattle, WA, 981840.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-125278ENRFrances Garza2000-08-16UHC-66708-43—3974 Valley View Dr, Fresno, CA0.52Street suffix standardisedAddress re-casedZIP missingEmail lower-cased+2 more
PRV-24422PRVThersea Harris1958-09-18UHC-49222-72—7303 Valley View Dr, Miami, FL, 331450.52Phone missing area codeStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-422749CLMJulie Banks1988-03-13——2818 River Rd Apt 11, Minneapolis, MN, 554190.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-135500ENRAna W Bell2007-05-09UHC-07204-0450762290562813 Lake View Rd, Seattle, WA, 981270.52Middle initial moved out of first nameName re-casedDate of birth reformattedStreet suffix standardised+2 more
CLM-418200CLMLaura Guzman1971-04-20—88476831383197 Ridge Rd Apt 3, Plano, TX, 750220.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-430592CLMStephanie Burke1974-03-25UHC-61758-29—7411 Valley View Dr, Mesa, AZ0.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57599TPAJeck Campbell1968-03-16UHC-15180-41—1440 Grand Ave, Las Vegas, NV, 891330.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
ENR-111599ENRDavid Ryan1984-05-22UHC-43444-74—701 Ridge Rd, Mesa, AZ0.52Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
ENR-136390ENRBrandon Bennett1939-08-21UHC-20776-2883730455421280 Camelback Rd, Tucson, AZ0.52Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+2 more
ENR-136391ENRBrandon Bennett1939-08-21UHC-20776-2883730455421280 Camelback Rd, Tucson, AZ0.52Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+2 more
ENR-131240ENRFatima T Carroll1945-03-08UHC-54168-9065830100028669 Maple Ave Apt 19, Tempe, AZ, 852910.52Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+2 more
ENR-135924ENRNicholas B Park1963-11-01UHC-31302-4547872589076548 Jefferson Ave, Los Angeles, CA, 900470.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-426161CLMRoy Watson1981-02-16UHC-53548-2759696106337291 Hillcrest Rd, Glendale, AZ, 853030.52Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-138383ENRVirginia U Rose1996-07-26UHC-18993-7028931714646726 Market St, Minneapolis, MN, 554310.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
100,000 rows, page 189 of 2,000PreviousNext