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

Provider network, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
PRV-25284PRVJack Carlson1985-10-14——4608 Main St, Nashville, TN, 372080.54Two-digit birth yearState name converted to codeGender normalisedWhitespace trimmed+1 more
PRV-23313PRVKayla S Crter1970-04-24—40046545633471 Apache Blvd, Miami, FL0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
PRV-21684PRVEugene Foster1959-03-24—68568869846273 Central Ave, Sacramento, CA0.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-20626PRVBobby Wilson1971-02-25—4152432213633 Meadow Ln, Miami, FL, 331170.54Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
PRV-24824PRVJoyce E Hanson1944-01-14——2684 Grand Ave, Plano, TX, 750620.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
PRV-21061PRVMariana Bradley1960-08-08UHC-30373-4871593177683194 Sunset Blvd, Seattle, WA, 981560.54Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-27821PRVStephanei J Moore1978-07-04UHC-96480-1259873820914646 Ridge Rd, San Antonio, TX, 782560.54Name re-casedTwo-digit birth yearZIP+4 trimmedGender normalised+1 more
PRV-20463PRVSofia Chen1996-09-25—45574195147943 Washington St, Phoenix, AZ, 850060.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
PRV-21097PRVAlbert Marshall1938-08-12—68126721321431 Ocean Ave, San Diego, CA0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
PRV-25820PRVNicole Carlson1941-10-20——8802 Pine Dr Apt 3, Tampa, FL, 336630.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-28482PRVDeborah Richards1955-06-14——7280 Bayshore Dr, Atlanta, GA, 303960.54Two-digit birth yearPhone missing area codeZIP+4 trimmedWhitespace trimmed+1 more
PRV-27488PRVSean Perkins1943-10-17——2758 Harbor Blvd, Mesa, AZ, 852420.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
PRV-21427PRVCarlos Lawrence1949-08-04UHC-29118-10—9012 Mesa Dr Apt 16, Plano, TX, 750350.54Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-23799PRVFrank A Howard1971-07-01UHC-33748-5125466838035872 Jefferson Ave, Nashville, TN, 372530.54Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
PRV-27962PRVMargaret Foster—UHC-01099-35—9550 Highland Ave, Phoenix, AZ0.54Date of birth missingState name converted to codeZIP missingWhitespace trimmed+1 more
PRV-21754PRVHelen Oliver1953-06-11UHC-09294-96——0.54Name split from “Last, First”Phone missing area codeMember ID reformattedGender normalised+1 more
PRV-28938PRVLinda Thomas2008-07-21——1820 Valley View Dr, Mesa, AZ, 852150.54Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
PRV-25134PRVAndy Johnson1988-02-15——845 Pine Dr, Plano, TX, 750130.54Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
PRV-20681PRVJohnston Lawrence1952-10-18—52380413885968 Park Pl, Chandler, AZ, 852230.54Name split from “Last, First”Two-digit birth yearPhone reformattedGender normalised+1 more
PRV-23297PRVJacob X Rios2008-04-24UHC-73234-7135025455083158 Canyon Rd, Orlando, FL, 328630.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-22893PRVEvelyn Gardner1981-08-14UHC-86706-8773556252577508 Highland Ave, Los Angeles, CA, 900200.54Two-digit birth yearPhone reformattedState name converted to codeGender normalised+1 more
PRV-23588PRVWillie Armsttrong1957-11-18UHC-69417-66—5056 Market St, Las Vegas, NV, 891730.54Name split from “Last, First”Two-digit birth yearPhone missing area codeWhitespace trimmed+1 more
PRV-25242PRVRyan Chen—UHC-69720-39—4269 Maple Ave # 585, San Diego, CA, 921510.54Name re-casedDate of birth unreadableUnit split from streetZIP+4 trimmed+1 more
PRV-25241PRVRyan Chen—UHC-69720-39—4269 Maple Ave # 585, San Diego, CA, 921510.54Name re-casedDate of birth unreadableUnit split from streetZIP+4 trimmed+1 more
PRV-21600PRVLarry W Spencer—UHC-16960-57—5830 Lake View Rd # 488, Miami, FL, 331390.54Date of birth unreadablePhone missing area codeUnit split from streetWhitespace trimmed+1 more
PRV-27645PRVBryan Lee1953-03-06UHC-60783-6697731121222721 Indian School Rd, Scottsdale, AZ, 852850.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
PRV-24918PRVStephen Harper——73943399174259 Pine Dr, Seattle, WA0.54Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-25246PRVAmy F Parker1948-05-10UHC-80718-0870854738463601 Jefferson Ave, Scottsdale, AZ, 852920.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
PRV-26323PRVBobby Peterson1965-06-27UHC-08242-6389437715019031 Jefferson Ave, Austin, TX, 787570.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
PRV-20324PRVKelly Larson1965-12-05—82290956473092 Washington St # 572, Chandler, AZ, 852210.54Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-22142PRVDeborah Y Jackson1951-07-21UHC-89997-7065171705078786 Jefferson Ave Apt 11, Las Vegas, NV0.54Name split from “Last, First”Phone reformattedUnit split from streetZIP missing+1 more
PRV-24364PRVRyan M Daniels1949-03-16UHC-67026-8329086820032759 Bayshore Dr Apt 13, Glendale, AZ, 853310.54Name split from “Last, First”Two-digit birth yearPhone reformattedUnit split from street+1 more
PRV-29294PRVAisha T Hughes2002-02-24——3610 Oak St, Las Vegas, NV, 891820.54Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-21789PRVJake Kim—UHC-20478-9361766438229324 Indian School Rd, Charlotte, NC0.54Date of birth missingPhone reformattedState name converted to codeZIP missing+1 more
PRV-21255PRVGregory Smith1984-03-20—51179602696641 Mesa Dr, Seattle, WA, 981500.54Name split from “Last, First”City re-casedState name converted to codeZIP+4 trimmed+1 more
PRV-21529PRVCarolyn Barnes—UHC-31715-5934525638708801 Broadway # 849, Plano, TX, 750340.54Date of birth unreadablePhone reformattedUnit split from streetGender normalised+1 more
PRV-27650PRVJoseph Reynolds1960-03-27—27342483846878 Grand Ave, Fresno, CA0.54Name split from “Last, First”Phone reformattedState name converted to codeZIP missing+1 more
PRV-22275PRVValentina Price2004-04-24——9812 Meadow Ln # 599, Phoenix, AZ, 850320.54Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-24569PRVJacob Greene—UHC-35926-2231496579459893 Meadow Ln # 312, Jacksonville, FL, 322110.54Date of birth unreadableUnit split from streetState name converted to codeWhitespace trimmed+1 more
PRV-21995PRVAlex Hunt2003-02-22——2344 Church St Apt 9, Miami, FL, 331660.54Name split from “Last, First”Unit split from streetState name converted to codeWhitespace trimmed+1 more
PRV-21882PRV—Junk1945-05-06UHC-12903-2582839461818733 Park Pl, Los Angeles, CA0.54Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared+1 more
PRV-20541PRVJudy Perez1996-05-07—28143231459661 Mesa Dr, Minneapolis, MN, 554560.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-22372PRVVirginia Hughes1964-08-27UHC-52299-9134891108868827 Lincoln Way, Denver, CO, 802380.56Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+6 more
PRV-26829PRVAlice L Marquez1997-08-26—75356761482926 Jefferson Ave # 615, Denver, CO0.56Unit split from streetZIP missingGender normalisedPlaceholder values cleared
PRV-20053PRVCamila Jimenez2008-07-04UHC-95243-6234923425754881 Sunset Blvd Apt 40, Orlando, FL, 328350.56Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code
PRV-27720PRVLsa I Wood1938-11-08UHC-20238-5895183196637709 Meadow Ln, Glendale, AZ, 853690.56Middle initial moved out of first nameName re-casedPhone reformattedMember ID reformatted+6 more
PRV-28848PRVOmar Jacobs1943-10-14UHC-10426-17—1000 Washington St, Dallas, TX0.56Name split from “Last, First”State name converted to codeZIP missingPlaceholder values cleared
PRV-26657PRVTheresa Hicks1969-02-09UHC-01574-14—1799 Highland Ave, Jacksonville, FL0.56SSN last four extractedZIP missingGender normalisedPlaceholder values cleared
PRV-21242PRVMatthew Diaz—UHC-83536-21—2988 Market St # 894, Scottsdale, AZ, 852710.56Date of birth missingUnit split from streetState name converted to codePlaceholder values cleared
PRV-26555PRVLuis V Freeman1999-10-21UHC-92466-1970847422537776 Indian School Rd, Chandler, AZ0.56Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
9,596 rows, page 21 of 192PreviousNext