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-138652ENRJacob J Estrada2003-02-10UHC-56956-5076352467273162 Park Pl, Miami, FL, 331980.40Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-111023ENRJoyce B Mills1971-03-28UHC-61487-5681737471098718 Valley View Dr # 754, Austin, TX, 787360.40Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-431131CLMDebra Nelson1945-02-26UHC-84410-57—9628 Maple Ave, San Diego, CA, 921420.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-410656CLMAmanda Foster———395 Washington St # 772, San Diego, CA, 921990.40Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-133489ENRKim Bryant1999-01-19UHC-33003-66—1902 Willow Ct, Dallas, TX, 752980.40Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+2 more
TPA-60898TPAGrace Owens1972-01-25——685 Apache Blvd # 542, Dallas, TX, 752110.40Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-139244ENRJose M Boyd1961-05-09UHC-21496-08—2859 River Rd, Sacramento, CA, 958050.40Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-128746ENRHarold Green1967-04-09UHC-13221-7948622092455940 Grand Ave # 946, Chandler, AZ0.40Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-432613CLMSamantha Martiin——82771229839290 Canyon Rd Apt 28, San Antonio, TX, 782170.40Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-26444PRVLarson Joan1949-09-16——2943 Pine Dr, Tempe, AZ0.40Name split from “Last, First”Date of birth reformattedState name converted to codeZIP missing+2 more
CLM-432791CLMNancy Miller1953-09-11—77950037813880 Desert Sky Blvd # 907, Dallas, TX, 752720.40Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-126345ENRChris Castro—UHC-49384-6725038085915106 Ridge Rd, Tucson, AZ, 857320.40Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+2 more
TPA-63709TPABruce K Turner1996-12-12——7712 Park Pl, San Diego, CA, 921680.40Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-126583ENRGary Arnold1996-02-18UHC-03152-9678122377953675 Mesa Dr, Houston, TX, 770670.40Name split from “Last, First”Two-digit birth yearPhone reformattedSSN last four extracted+2 more
ENR-141183ENRNicole Gonzales1941-02-13UHC-80545-64—4175 Forest Ave, Orlando, FL, 328800.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-408150CLMHudson V Sarah2008-11-07UHC-43359-39—3760 Willow Ct # 157, Denver, CO, 802070.40Name re-casedPhone missing area codeUnit split from streetStreet suffix standardised+2 more
ENR-137085ENRThomas H Palmer1977-10-02UHC-62672-3353845899782368 Sage Ct, Glendale, AZ, 853070.40Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
ENR-114950ENRJake Welch1958-01-25UHC-92655-20—1663 Highland Ave, Jacksonville, FL, 322160.40Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-130278ENRBruce Jakcson1956-01-19UHC-34324-1881671145268460 Oak St, Jacksonville, FL0.40Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-422037CLMAbby Nichols1956-10-26UHC-31174-53—4189 Elm St, Orlando, FL, 328890.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-53689TPAShron Johnston1938-02-26——1670 Meadow Ln, Tempe, AZ0.40Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-115598ENRPaul H Jensen1952-06-06UHC-67862-9645533582022332 Highland Ave, Dallas, TX0.40Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-138980ENRSam Armstrong1954-05-07UHC-46849-1842263245496687 Elm St Apt 20, Denver, CO, 802970.40Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-123543ENRRebecca Z Park—UHC-38162-90—3900 Valley View Dr, San Diego, CA, 921090.40Name re-casedDate of birth missingPhone missing area codeStreet suffix standardised+2 more
ENR-108230ENRNicole Rodriguez2008-05-07UHC-29082-9198598422789401 Ocean Ave # 664, Tempe, AZ, 852210.40Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-121239ENRHarold Greene1994-12-16UHC-22101-8195954398917545 Ocean Ave, Seattle, WA, 981320.40Name split from “Last, First”Two-digit birth yearPhone reformattedSSN last four extracted+2 more
ENR-113760ENRRonald W Hernandez1959-09-24UHC-70616-9843148811274335 Main St, Las Vegas, NV, 891890.40Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-114293ENRDiane O Hughes—UHC-66969-7164731177458869 Spring St, Atlanta, GA, 303040.40Date of birth missingSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-427966CLMJuan Armstrong1955-11-06UHC-53733-41—4410 Forest Ave Apt 12, Columbus, OH, 432450.40Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-119643ENRJesse E Mejia1978-07-04UHC-75572-5197369354537813 Main St Apt 23, Austin, TX, 787940.40SSN last four extractedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-56782TPALucia W Porter1944-02-23——8965 Canyon Rd, San Antonio, TX, 782340.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-56783TPALucia W Porter1944-02-23——8965 Canyon Rd, San Antonio, TX, 782340.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-118363ENRBruce N Bradley—UHC-17909-89—9096 Washington St, Glendale, AZ, 853820.40Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-120365ENRBetty H Howell1945-07-07—48639572237429 Canyon Rd, Fresno, CA, 937230.40Name split from “Last, First”Middle initial moved out of first nameStreet suffix standardisedAddress re-cased+2 more
ENR-133412ENRJanice Q Hansen1970-06-13UHC-17796-507636570096930 Camelback Rd # 989, Fresno, CA, 937290.40Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-50945TPARyan Cooepr1995-07-25——9896 Sunset Blvd, Tampa, FL, 336040.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-411946CLMElijah Wood—UHC-50101-19—2755 Sage Ct, Glendale, AZ0.40Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-418822CLMSophia U Davis1966-05-17UHC-17097-4180638121934997 Baseline Rd, Houston, TX0.40Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
ENR-110408ENRAlexis B Burton—UHC-80754-22—6768 Oak St # 694, Dallas, TX, 752780.40Date of birth unreadableSSN last four extractedUnit split from streetStreet suffix standardised+2 more
CLM-407763CLMHeather Hansen1938-08-09——8586 Apache Blvd, Sacramento, CA, 958120.40Name split from “Last, First”Phone missing area codeSSN last four extractedState name converted to code+2 more
ENR-110037ENRMichael P Jordan—UHC-00509-3390764531167237 Palm Dr, Los Angeles, CA0.40Date of birth missingStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-25434PRVBobby Rodriguez1967-01-04UHC-12282-59—2655 Bayshore Dr Apt 13, Phoenix, AZ, 850520.40Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-25433PRVBobby Rodriguez1967-01-04UHC-12282-59—2655 Bayshore Dr Apt 13, Phoenix, AZ, 850520.40Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-106861ENRJess X Montgomery1977-07-19UHC-28580-2266540199854165 Jefferson Ave Apt 16, Fresno, CA, 937870.40Middle initial moved out of first namePhone reformattedUnit split from streetStreet suffix standardised+2 more
TPA-62508TPAIsabella Mjia1963-12-17——9832 Washington St, Phoenix, AZ, 850750.40Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-422268CLMJustin Knight1985-10-27UHC-39714-96—2762 Forest Ave, Seattle, WA, 981020.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-421133CLMJacqueline Woods1954-12-17UHC-84563-2262074103608373 Mesa Dr, Chandler, AZ0.40Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
PRV-24345PRVCynthia Jensen1959-05-28UHC-82520-15—454 Apache Blvd Apt 36, Columbus, OH, 432770.40Name split from “Last, First”Two-digit birth yearUnit split from streetStreet suffix standardised+2 more
CLM-424377CLMAnna Morris1960-03-24——3498 Willow Ct, Columbus, OH0.40Name split from “Last, First”State name converted to codeZIP missingGender normalised+2 more
ENR-121639ENRZachary Morgan1999-07-13UHC-30597-8985882396004537 Church St Apt 33, Chandler, AZ, 852050.40Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
100,000 rows, page 36 of 2,000PreviousNext