The Cluster Sensitivity Profiler
The Cluster Sensitivity Profiler automatically performs context and content inspection to detect various types of sensitive data and suggest suitable classifications or tags based on the type of sensitive content detected or discovered.
Tag Rules
The Cluster Sensitivity Profiler have system-defined and user-defined tags that identify data types based on regular expressions.
Auto-detected data types and system-defined regular expressions
The system-defined tag rules identify the following data types:
Bank account, credit card, email
- Bank account
- Credit card
- Driver number (UK)
- Name: bankaccount
- Match Type: Column value
- Confidence: 85
- Regular expression:
-
regex("\\b(AD)\\d{2}\\d{8}[a-zA-Z0-9]{12}|(AE|IL)\\d{2}\\d{19}|(AL|CY)\\d{2}\\d{8}[a-zA-Z0-9]{16}|(PL)\\d{2}\\d{24}|(AT|BA|EE|LT)\\d{2}\\d{16}|(BE)\\d{2}\\d{12}|(BG)\\d{2}[A-Z]{4}\\d{6}[a-zA-Z0-9]{8}|(BH)\\d{2}[A-Z]{4}[a-zA-Z0-9]{14}|(CH)\\d{2}\\d{5}[a-zA-Z0-9]{12}|(CZ|ES|SE|SK|TN)\\d{2}\\d{20}|(DE|ME|RS)\\d{2}\\d{18}|(DK|FI|FO|GL)\\d{2}\\d{14}|(DO)\\d{2}[A-Z]{4}\\d{20}|(FR|MC)\\d{2}\\d{10}[a-zA-Z0-9]{11}\\d\\d|(GB)\\d{2}[A-Z]{4}\\d{14}|(IE)\\d{2}[a-zA-Z0-9]{4}\\d{14}|(GE)\\d{2}[a-zA-Z0-9]{2}\\d{16}|(GI)\\d{2}[A-Z]{4}[a-zA-Z0-9]{15}|(GR)\\d{2}\\d{7}[a-zA-Z0-9]{16}|(HR)\\d{2}\\d{17}|(HU)\\d{2}\\d{24}|(IS)\\d{2}\\d{22}|(IT|SM)\\d{2}[A-Z]\\d{10}[a-zA-Z0-9]{12}|(KW)\\d{2}[A-Z]{4}[a-zA-Z0-9]{22}|(KZ)\\d{2}\\d{3}[a-zA-Z0-9]{3}\\d{10}|(LU)\\d{2}\\d{3}[a-zA-Z0-9]{13}|(LB)\\d{2}\\d{4}[a-zA-Z0-9]{20}|(LI)\\d{2}\\d{5}[a-zA-Z0-9]{12}|(LV)\\d{2}[A-Z]{4}[a-zA-Z0-9]{13}|(MK)\\d{2}\\d{3}[a-zA-Z0-9]{10}\\d\\d|(MR)\\d{2}\\d{23}|(MT)\\d{2}[A-Z]{4}\\d{5}[a-zA-Z0-9]{18}|(MU)\\d{2}[A-Z]{4}\\d{19}[A-Z]{3}|(NL)\\d{2}[A-Z]{4}\\d{10}|(NO)\\d{2}\\d{11}|(PT)\\d{2}\\d{21}|(RO)\\d{2}[A-Z]{4}[a-zA-Z0-9]{16}|(SA)\\d{2}\\d{2}[a-zA-Z0-9]{18}|(SI)\\d{2}\\d{15}|(TR)\\d{2}\\d{5}[a-zA-Z0-9]{17}\\b")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("bankaccount","account","accountnumber")
- Match Type: Column value
- Name: creditcard
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("\\b((5[1-5][0-9]{2}[0-9]{4}[0-9]{4}[0-9]{4})|((633(3|4)|67(67|59)|49(36|11|05|03))[0-9]{4}[0-9]{4}[0-9]{4}(([0-9]{3}|[0-9]{2}))?)|(4[0-9]{3}[0-9]{4}[0-9]{4}[0-9]{4}|4[0-9]{3}[0-9]{4}[0-9]{4}[0-9]{1})|((6011)[0-9]{4}[0-9]{4}[0-9]{4})|((622)[0-9]{1}[0-9]{4}[0-9]{4}[0-9]{4})|((65)[0-9]{2}[0-9]{4}[0-9]{4}[0-9]{4})|((64)[0-9]{2}[0-9]{4}[0-9]{4}[0-9]{4})|(((3[47][0-9]{2})|2014|2149)[0-9]{4}[0-9]{4}[0-9]{3})|(3(0[0-5]|[68][0-9])[0-9][0-9]{4}[0-9]{4}[0-9]{2})|((3528)[0-9]{4}[0-9]{4}[0-9]{4})|((3529)[0-9]{4}[0-9]{4}[0-9]{4})|((35)[3-8][0-9][0-9]{4}[0-9]{4}[0-9]{4})|(63[789][0-9][0-9]{4}[0-9]{4}[0-9]{4})|(5610[0-9]{4}[0-9]{4}[0-9]{4})|(56022[1-5][0-9]{2}[0-9]{4}[0-9]{4}))\\b|\\b((5893|0604|6304|6759|676[1-3]|50(18|20|38))[0-9]{4}[0-9]{4}([0-9]{0,4})?([0-9]{0,3})?)\\b|\\b(67(06|71|09)[0-9]{4}[0-9]{4}[0-9]{4}([0-9]{0,3})?)\\b|\\b((633110|564182)[0-9]{2}[0-9]{4}[0-9]{4}([0-9]{3}|[0-9]{2})?)\\b","\\b((5[1-5][0-9]{2}[\\][0-9]{4}[\[ ][0-9]{4}[\\ ][0-9]{4})|((633(3|4)|67(67|59)|49(36|11|05|03))[\\][0-9]{4}[\\][0-9]{4}[\[ ][0-9]{4}([\\]([0-9]{3}|[0-9]{2}))?)|(4[0-9]{3}[\\ ][0-9]{4}[\[ ][0-9]{4}[\\][0-9]{4}|4[0-9]{3}[\\ ][0-9]{4}[\\ ][0-9]{4}[\[ ][0-9]{1})|((6011)[\\][0-9]{4}[\\][0-9]{4}[\\ ][0-9]{4})|((622)[0-9]{1}[\[ ][0-9]{4}[\\][0-9]{4}[\\][0-9]{4})|((65)[0-9]{2}[\\ ][0-9]{4}[\[ ][0-9]{4}[\\][0-9]{4})|((64)[0-9]{2}[\\][0-9]{4}[\[ ][0-9]{4}[\\][0-9]{4})|(((3[47][0-9]{2})|2014|2149)[\\ ][0-9]{4}[\\][0-9]{4}[\[ ][0-9]{3})|((3[47][0-9]{2})[\\ ][0-9]{6}[\\][0-9]{5})|(3(0[0-5]|[68][0-9])[0-9][\[ ][0-9]{4}[\\ ][0-9]{4}[\\][0-9]{2})|(3(0[0-5]|[68][0-9])[0-9][\\ ][0-9]{6}[\[ ][0-9]{4})|((3528)[\\][0-9]{4}[\\][0-9]{4}[\\ ][0-9]{4})|((3529)[\\ ][0-9]{4}[\[ ][0-9]{4}[\\][0-9]{4})|((35)[3-8][0-9][\\][0-9]{4}[\\ ][0-9]{4}[\[ ][0-9]{4})|(63[789][0-9][\\][0-9]{4}[\\ ][0-9]{4}[\\][0-9]{4})|(5610[\\ ][0-9]{4}[\[ ][0-9]{4}[\\][0-9]{4})|(5602[\[ ]2[1-5][0-9]{2}[\\][0-9]{4}[\\][0-9]{4}))|((5893|0604|6304|6759|676[1-3]|50(18|20|38))[\[ ][0-9]{4}[\\][0-9]{4}([\\ ][0-9]{0,4})?([\\ ][0-9]{0,3})?)|(67(06|71|09)[\[ ][0-9]{4}[\\][0-9]{4}[\\][0-9]{4}([\\ ][0-9]{0,3})?)|((6331[\\ ]10|5641[\\]82)[0-9]{2}[\[ ][0-9]{4}[\\][0-9]{4}([\[ ][0-9]{3}|[\\][0-9]{2})?)\\b","\\b((5[1-5][0-9]{2}-[0-9]{4}-[0-9]{4}-[0-9]{4})|((633(3|4)|67(67|59)|49(36|11|05|03))-[0-9]{4}-[0-9]{4}-[0-9]{4}(-([0-9]{3}|[0-9]{2}))?)|(4[0-9]{3}-[0-9]{4}-[0-9]{4}-[0-9]{4}|4[0-9]{3}-[0-9]{4}-[0-9]{4}-[0-9]{1})|((6011)-[0-9]{4}-[0-9]{4}-[0-9]{4})|((622)[0-9]{1}-[0-9]{4}-[0-9]{4}-[0-9]{4})|((65)[0-9]{2}-[0-9]{4}-[0-9]{4}-[0-9]{4})|((64)[0-9]{2}-[0-9]{4}-[0-9]{4}-[0-9]{4})|(((3[47][0-9]{2})|2014|2149)-[0-9]{4}-[0-9]{4}-[0-9]{3})|((3[47][0-9]{2})-[0-9]{6}-[0-9]{5})|(3(0[0-5]|[68][0-9])[0-9]-[0-9]{4}-[0-9]{4}-[0-9]{2})|(3(0[0-5]|[68][0-9])[0-9]-[0-9]{6}-[0-9]{4})|((3528)-[0-9]{4}-[0-9]{4}-[0-9]{4})|((3529)-[0-9]{4}-[0-9]{4}-[0-9]{4})|((35)[3-8][0-9]-[0-9]{4}-[0-9]{4}-[0-9]{4})|(63[789][0-9]-[0-9]{4}-[0-9]{4}-[0-9]{4})|(5610-[0-9]{4}-[0-9]{4}-[0-9]{4})|(5602-2[1-5][0-9]{2}-[0-9]{4}-[0-9]{4}))|((5893|0604|6304|6759|676[1-3]|50(18|20|38))-[0-9]{4}-[0-9]{4}(-[0-9]{0,4})?(-[0-9]{0,3})?)|(67(06|71|09)-[0-9]{4}-[0-9]{4}-[0-9]{4}(-[0-9]{0,3})?)|((6331-10|5641-82)[0-9]{2}-[0-9]{4}-[0-9]{4}(-[0-9]{3}|-[0-9]{2})?)\\b")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("creditcard","ccnumber")
- Match Type: Column value
- Name: ukdrivernumber
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("\\b([A-Z0-9]{5}[0-9][0156][0-9]([0][1-9]|[1-2][0-9]|[3][01])[0-9][A-Z0-9]{3}[A-Z]{2})\\b")
- Match Type: Column value
- Name: email
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("\\b(([a-zA-Z0-9_\\-\\.]+)@((\\[[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}\\.)|(([a-zA-Z0-9\\-]+\\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\\]?))\\b")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("emailaddress","emailaddr","email")
- Match Type: Table name
- Confidence: 100
- Regular expression:
(?i)\w*email\w*
- Match Type: Column value
IBAN numbers
- Austria (AUT)
- Belgium (BEL)
- Bulgaria (BGR)
- Switzerland (CHE)
- Cyprus (CYP)
- Czech Republic (CZE)
- Germany (DEU)
- Denmark (DNK)
- Spain (ESP)
- Estonia (EST)
- Finland (FIN)
- France (FRA)
- United Kingdom (GBR)
- Greece (GRC)
- Croatia (HRV)
- Hungary (HUN)
- Ireland (IRL)
- Iceland (ISL)
- Italy (ITA)
- Liechtenstein (LIE)
- Lithuania (LTU)
- Latvia (LVA)
- Luxembourg (LUX)
- Malta (MLT)
- Netherlands (NLD)
- Norway (NOR)
- Poland (POL)
- Portugal (PRT)
- Romania (ROU)
- Slovakia (SVK)
- Slovenia (SVN)
- Sweden (SWE)
- Name: LVA_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(LV\\d{2}([ ]?)[A-Z]{4}\\3[A-Za-z0-9]{4}\\3[A-Za-z0-9]{4}\\3[A-Za-z0-9]{4}\\3[A-Za-z0-9])(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Latvia IBAN","Latvia International Bank Account Number")
- Match Type: Column value
- Name: ROU_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(RO\\d{2}(?)[A-Z]{4}\\3[A-Za-z0-9]{4}\\3[A-Za-z0-9]{4}\\3[A-Za-z0-9]{4}\\3[A-Za-z0-9]{4})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Romania IBAN","Romania International Bank Account Number")
- Match Type: Column value
- Name: FRA_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(FR\\d{2}([ ]?)\\d{4}\\3\\d{4}\\3\\d{2}[0-9A-Z]{2}\\3[0-9A-Z]{4}\\3[0-9A-Z]{4}\\3[0-9A-Z](9[0-7]|0[1-9]|[1-8]\\d))(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("France IBAN","France International Bank Account Number")
- Match Type: Column value
- Name: DEU_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(DE\\d{2}([ ]?)\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{2})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Germany IBAN","Germany International Bank Account Number")
- Match Type: Column value
- Name: CYP_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(CY\\d{2}([ ]?)\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{4})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular
expression:
is_in_ci("Cyprus IBAN","Cyprus International Bank Account Number")
- Match Type: Column value
- Name: AUT_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular
expression:
regex("(\\s|,|;|\\A)(AT\\d{2}([ ]?)\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{4})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Austria IBAN","Austria International Bank Account Number")
- Match Type: Column value
- Name: BEL_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(BE\\d{2}([ ]?)\\d{4}\\3\\d{4}\\3\\d{4})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Belgium IBAN","Belgium International Bank Account Number")
- Match Type: Column value
- Name: EST_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(EE\\d{2}([ ]?)\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{4})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Estonia IBAN","Estonia International Bank Account Number")
- Match Type: Column value
- Name: CHE_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(CH\\d{2}([ ]?)\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d)(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Switzerland IBAN","Switzerland International Bank Account Number")
- Match Type: Column value
- Name: ESP_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(ES\\d{2}([ ]?)\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{4})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Spain IBAN","Spain International Bank Account Number")
- Match Type: Column value
- Name: ITA_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(IT\\d{2}([ ]?)[A-Z]{1}\\3\\d{10}\\3[A-Z0-9]{12})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Italy IBAN","Italy International Bank Account Number")
- Match Type: Column value
- Name: SVK_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(SK\\d{2}([ ]?)\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{4})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Slovakia IBAN","Slovakia International Bank Account Number")
- Match Type: Column value
- Name: SWE_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(SE\\d{2}([ ]?)\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{4})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Sweden IBAN","Sweden International Bank Account Number")
- Match Type: Column value
- Name: NOR_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(NO\\d{2}([ ]?)\\d{4}\\3\\d{4}\\3\\d{3})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Norway IBAN","Norway International Bank Account Number")
- Match Type: Column value
- Name: GRC_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(GR\\d{2}([ ]?)\\d{3}\\3\\d{4}\\3[A-Z0-9]{4}\\3[A-Z0-9]{4}\\3[A-Z0-9]{4}\\3[A-Z0-9]{3})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Greece IBAN","Greece International Bank Account Number")
- Match Type: Column value
- Name: IBAN_Detection
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("IBAN","International Bank Account Number")
- Match Type: Column name
- Name: GBR_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(GB\\d{2}([ ]?)[A-Z]{4}\\3\\d{4}\\3\\d{4}\\3\\d{4})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("United Kingdom IBAN","United Kingdom International Bank Account Number")
- Match Type: Column value
- Name: IRL_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(IE\\d{2}([ ]?)[A-Z]{4}\\3\\d{4}\\3\\d{4}\\3\\d{4})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Ireland IBAN","Ireland International Bank Account Number")
- Match Type: Column value
- Name: FIN_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(FI\\d{2}([ ]?)\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{2})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Finland IBAN","Finland International Bank Account Number")
- Match Type: Column value
- Name: NLD_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(NL\\d{2}([ ]?)[A-Z]{4}\\3\\d{4}\\3\\d{4}\\3\\d{2})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Netherlands IBAN","Netherlands International Bank Account Number")
- Match Type: Column value
- Name: BGR_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(BG\\d{2}([ ]?)[A-Z]{4}\\3\\d{4}\\3[A-Z0-9]{4}\\3[A-Z0-9]{4}\\3[A-Z0-9])(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Bulgaria IBAN","Bulgaria International Bank Account Number")
- Match Type: Column value
- Name: SVN_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(SI\\d{2}([ ]?)\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{3})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Slovenia IBAN","Slovenia International Bank Account Number")
- Match Type: Column value
- Name: LIE_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(LI\\d{2}([ ]?)\\d{4}\\3\\d{1}[A-Z0-9]{3}\\3[A-Z0-9]{4}\\3[A-Z0-9]{4}\\3[A-Z0-9]{1})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Liechtenstein IBAN","Liechtenstein International Bank Account Number")
- Match Type: Column value
- Name: POL_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(PL\\d{2}([ ]?)\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{4})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Poland IBAN","Poland International Bank Account Number")
- Match Type: Column value
- Name: PRT_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(PT\\d{2}([n]?)\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{1})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Portugal IBAN","Portugal International Bank Account Number")
- Match Type: Column value
- Name: LTU_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(LT\\d{2}([ ]?)\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{4})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Lithuanian IBAN","Lithuania International Bank Account Number")
- Match Type: Column value
- Name: HRV_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(HR\\d{2}([ ]?)\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{1})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Croatian IBAN","Croatia International Bank Account Number")
- Match Type: Column value
- Name: LUX_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(LU\\d{2}([ ]?)\\d{3}[A-Z0-9]{1}\\3[A-Z0-9]{4}\\3[A-Z0-9]{4}\\3[A-Z0-9]{4})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Luxembourg IBAN","Luxembourg International Bank Account Number")
- Match Type: Column value
- Name: DNK_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(DK\\d{2}([ ]?)\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{2})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Denmark IBAN","Denmark International Bank Account Number")
- Match Type: Column value
- Name: HUN_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(HU\\d{2}([ ]?)\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{4})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Hungary IBAN","Hungary International Bank Account Number")
- Match Type: Column value
- Name: CZE_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(CZ\\d{2}([ ]?)\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{4})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Czech Republic IBAN","Czechia IBAN","Czech Republic International Bank Account Number","Czechia International Bank Account Number")
- Match Type: Column value
- Name: ISL_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(IS\\d{2}([ ]?)\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{4}\\3\\d{2})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Iceland IBAN","Iceland International Bank Account Number")
- Match Type: Column value
- Name: MLT_IBAN_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("\\A(MT\\d{2}([ ]?)[A-Z]{4}\\3\\d{4}\\3\\d{1}[A-Z0-9]{3}\\3[A-Z0-9]{4}\\3[A-Z0-9]{4}\\3[A-Z0-9]{4}\\3[A-Z0-9]{3})\\Z")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Malta IBAN","Malta International Bank Account Number")
- Match Type: Column value
IP addresses, NPI, names
- IP address
- NPI
- Name
Regular expressions:
- Name: ipaddress
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)))(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("ipaddress","ipaddr","ip")
- Match Type: Column value
- Name: npi
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)((([12]\\d{9}))|(((80840)[12]\\d{9})))(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("npi")
- Match Type: Column value
National ID numbers
- Bulgaria (BGR)
- Switzerland (CHE)
- Czech Republic (CZE)
- Denmark (DNK)
- Spain (ESP)
- Estonia (EST)
- Finland (FIN)
- Greece (GRC)
- Ireland (IRL)
- Iceland (ISL)
- Italy (ITA)
- Lithuania (LTU)
- Latvia (LVA)
- Norway (NOR)
- Poland (POL)
- Portugal (PRT)
- Romania (ROU)
- Slovakia (SVK)
- Sweden (SWE)
Regular expressions:
- Name: NOR_NationalID_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)((0[1-9]|[12][0-9]|3[01])([0][1-9]|[1][012])\\d{2}\\d{3}\\d{2})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Norway National ID","Norway National identification number")
- Match Type: Column value
- Name: FIN_NationalID_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)((0[1-9]|[12][0-9]|3[01])([0][1-9]|[1][012])\\d{2}[+\\-A](00[2-9]|[0][1-9]\\d|[1-9]\\d{2})[A-Za-z0-9])(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Finland National ID","Finland National identification number")
- Match Type: Column value
- Name: GRC_NationalID_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)([ABEZHIKMNOPTYX]{2}\\-\\d{6})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Greece National ID","Greece National identification number")
- Match Type: Column value
- Name: CHE_NationalID_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(756([ -.]?)\\d{4}\\3\\d{4}\\3\\d{2})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Switzerland National ID","Switzerland National identification number")
- Match Type: Column value
- Name: PRT_NationalID_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(\\d{8}([ -]?)\\d[0-9a-zA-Z]{2}\\d)(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Portugal National ID","Portugal National identification number")
- Match Type: Column value
- Name: LTU_NationalID_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)([3-6]\\d{2}([0][1-9]|[1][012])(0[1-9]|[12][0-9]|3[01])\\d{3}\\d)(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Lithuania National ID","Lithuania National identification number")
- Match Type: Column value
- Name: POL_NationalID_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(\\d{2}([0][1-9]|[1][012])(0[1-9]|[12][0-9]|3[01])\\d{3}\\d{1}\\d{1})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Poland National ID","Poland National identification number")
- Match Type: Column value
- Name: LVA_NationalID_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)((0[1-9]|[12][0-9]|3[01])([0][1-9]|[1][012])\\d{2}\\-?[012]\\d{3}\\d)(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Latvia National ID","Latvia National identification number")
- Match Type: Column value
- Name: DNK_NationalID_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(([0][1-9]|[12][0-9]|[3][01])([0][1-9]|[1][012])\\d{2}[ -]?\\d{4})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Denmark National ID","Denmark National identification number")
- Match Type: Column value
- Name: CZE_NationalID_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(\\d{4}(0[1-9]|[12][0-9]|3[01])\\/?\\d{4})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Czech Republic National ID","Czechia National ID","Czech Republic National identification number","Czechia National identification number")
- Match Type: Column value
- Name: SWE_NationalID_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)((19|20)?\\d{2}(0[1-9]|1[012])([06][1-9]|[12]\\d|3[01])[-+]\\d{4})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Sweden National ID","Sweden National identification number")
- Match Type: Column value
- Name: ISL_NationalID_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)((0[1-9]|[12][0-9]|3[01])([0][1-9]|[1][012])\\d{2}\\-\\d{2}\\d[09])(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Iceland National ID","Iceland National identification number")
- Match Type: Column value
- Name: ESP_NationalID_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(\\d{8}([ -]?)[A-Z])(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Spain National ID","Spain National identification number")
- Match Type: Column value
- Name: EST_NationalID_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)([1-6]\\d{2}([0][1-9]|[1][012])(0[1-9]|[12][0-9]|3[01])\\d{3}\\d)(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Estonia National ID","Estonia National identification number")
- Match Type: Column value
- Name: ITA_NationalID_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)([A-Z]{3}[A-Z]{3}\\d{2}[A-EHLMPRST]([04][1-9]|[1256]\\d|[37][01])[A-Z]\\d{3}[A-Z])(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Italy National ID","Italy National identification number")
- Match Type: Column value
- Name: NationalID_Detection
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("National ID","National identification number")
- Match Type: Column name
- Name: ROU_NationalID_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)([1-9]\\d{2}([0][1-9]|[1][012])(0[1-9]|[12][0-9]|3[01])([01234]\\d|5[012]|99)\\d{4})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Romania National ID","Romania National identification number")
- Match Type: Column value
- Name: BGR_NationalID_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(\\d{2}([024][1-9]|[135][012])(0[1-9]|[12][0-9]|3[01])\\d{3}\\d{1})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Bulgaria National ID","Bulgaria National identification number")
- Match Type: Column value
- Name: IRL_NationalID_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(\\d{7}[A-Za-z]{1,2})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Ireland National ID","Ireland National identification number")
- Match Type: Column value
- Name: SVK_NationalID_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(\\d{4}(0[1-9]|[12][0-9]|3[01])\\/\\d{4})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Slovakia National ID","Slovakia National identification number")
- Match Type: Column value
National insurance number (UK)
Regular expressions:
- Name: uknationalinsurancenumber
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("\\b[A-CEGHJ-NOPR-TW-Z]{1}[A-CEGHJ-NPR-TW-Z]{1}[0-9]{6}[A-D\\s]{1}\\b")
- Match Type: Column value
Passport numbers
- Austria (AUT)
- Belgium (BEL)
- Switzerland (CHE)
- Germany (DEU)
- Spain (ESP)
- Finland (FIN)
- France (FRA)
- Greece (GRC)
- Ireland (IRL)
- Italy (ITA)
- Poland (POL)
- United Kingdom (UK)
Regular expressions:
- Name: AUT_Passport_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)([A-Z][ ]?\\d{7})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Austria Passport Number")
- Match Type: Column value
- Name: ESP_Passport_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)([A-Z]{2}[ -]?\\d{6})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Spain Passport Number")
- Match Type: Column value
- Name: DEU_Passport_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)([0-9CF-HJ-NPRTV-Z]{9})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Germany Passport Number")
- Match Type: Column value
- Name: FIN_Passport_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)([A-Za-z]{2}\\d{7})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Finland Passport Number")
- Match Type: Column value
- Name: POL_Passport_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)([A-Za-z]{2}\\d{7})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Poland Passport Number")
- Match Type: Column value
- Name: CHE_Passport_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)([A-Z]\\d{7})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Switzerland Passport Number")
- Match Type: Column value
- Name: Passport_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)([A-Z][A-Z0-9][0-9]{7})(\\s|,|;|\\A)","(\\s|,|;|\\A)([A-Za-z]{2}\\d{7})(\\s|,|;|\\Z)","(\\s|,|;|\\A)([A-Z][ ]?\\d{7})(\\s|,|;|\\Z)","(\\s|,|;|\\A)([A-Z]{2}[0-9]{7})(\\s|,|;|\\Z)","(\\s|,|;|\\A)([A-Za-z]{2}\\d{7})(\\s|,|;|\\Z)","(\\s|,|;|\\A)([A-Z]{2}[0-9]{7})(\\s|,|;|\\Z)","(\\s|,|;|\\A)([0-9CF-HJ-NPRTV-Z]{9})(\\s|,|;|\\Z)","(\\s|,|;|\\A)([A-Za-z]{2}\\d{6})(\\s|,|;|\\Z)","(\\s|,|;|\\A)([A-Z]{2}[ -]?\\d{6})(\\s|,|;|\\Z)","(\\s|,|;|\\A)([A-Z]\\d{7})(\\s|,|;|\\Z)","(\\s|,|;|\\A)(\\d{2}[A-Z]{2}\\d{5})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Passport Number")
- Match Type: Column value
- Name: GRC_Passport_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)([A-Z]{2}[0-9]{7})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Greece Passport Number")
- Match Type: Column value
- Name: BEL_Passport_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)([A-Za-z]{2}\\d{6})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Belgium Passport Number")
- Match Type: Column value
- Name: FRA_Passport_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)(\\d{2}[A-Z]{2}\\d{5})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("France Passport Number")
- Match Type: Column value
- Name: ITA_Passport_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)([A-Z]{2}[0-9]{7})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Italy Passport Number")
- Match Type: Column value
- Name: IRL_Passport_Detection
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("(\\s|,|;|\\A)([A-Z][A-Z0-9][0-9]{7})(\\s|,|;|\\Z)")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("Ireland Passport Number")
- Match Type: Column value
Miscellaneous identifications: bank, passport, social security
- SWIFT code
- UK passport number
- Bank Routing Number
- US Social Security Number
- Society for Worldwide Interbank Financial Telecommunication (SWIFT)
- Telephone
Regular expressions:
- Name: swiftcode
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("\\b[a-zA-Z]{4}(AF|AX|AL|DZ|AS|AD|AO|AI|AQ|AG|AR|AM|AW|AU|AT|AZ|BS|BH|BD|BB|BY|BE|BZ|BJ|BM|BT|BO|BQ|BA|BW|BV|BR|IO|BN|BG|BF|BI|KH|CM|CA|CV|KY|CF|TD|CL|CN|CX|CC|CO|KM|CG|CD|CK|CR|CI|HR|CU|CW|CY|CZ|DK|DJ|DM|DO|EC|EG|SV|GQ|ER|EE|ET|FK|FO|FJ|FI|FR|GF|PF|TF|GA|GM|GE|DE|GH|GI|GR|GL|GD|GP|GU|GT|GG|GN|GW|GY|HT|HM|VA|HN|HK|HU|IS|IN|ID|IR|IQ|IE|IM|IL|IT|JM|JP|JE|JO|KZ|KE|KI|KP|KR|KW|KG|LA|LV|LB|LS|LR|LY|LI|LT|LU|MO|MK|MG|MW|MY|MV|ML|MT|MH|MQ|MR|MU|YT|MX|FM|MD|MC|MN|ME|MS|MA|MZ|MM|NA|NR|NP|NL|NC|NZ|NI|NE|NG|NU|NF|MP|NO|OM|PK|PW|PS|PA|PG|PY|PE|PH|PN|PL|PT|PR|QA|RE|RO|RU|RW|BL|SH|KN|LC|MF|PM|VC|WS|SM|ST|SA|SN|RS|SC|SL|SG|SX|SK|SI|SB|SO|ZA|GS|ES|LK|SD|SR|SJ|SZ|SE|CH|SY|TW|TJ|TZ|TH|TL|TG|TK|TO|TT|TN|TR|TM|TC|TV|UG|UA|AE|GB|US|UM|UY|UZ|VU|VE|VN|VG|VI|WF|EH|YE|ZM|ZW)[a-zA-Z0-9]{2}([a-zA-Z0-9]{3})?\\b")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("swiftcode")
- Match Type: Column value
- Name: ukpassportnumber
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("\\b([A-Z0-9]{1}[0-9]{4}[A-Z0-9]{1})\\b")
- Match Type: Column value
- Name: telephone
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("\\b(((\\+)?(1|7|2([07]|1[12368]|[2-6][0-9]|9[01789])|3([57][0-9]|8[0125679]|[0123469])|4([013456789]|2[013])|5([1-8]|39(9)?|[09][0-9])|6([0-6]|[78][0-9]|9[0-2])|(758)|8([1246]|0[089]|5[02356]|7(8|[0-4])|8(1[01236789]|21[36]|[016]))|9(6[0-8]|7[0-7]|[0123458]|9(8|[2-6]))|(1-(68|2(4[16]|6[48])|(34[05])|4(41|73)|6(49|64|7[01]|84)|7(58|67|8[47])|8(0|6[89]|[24]9|76)|(939)))|(7-7))(\[ )?)?([2-9][0-9]{9}))\\b","\\b(((\\+)?(1|7|2([07]|1[12368]|[2-6][0-9]|9[01789])|3([57][0-9]|8[0125679]|[0123469])|4([013456789]|2[013])|5([1-8]|39(9)?|[09][0-9])|6([0-6]|[78][0-9]|9[0-2])|(758)|8([1246]|0[089]|5[02356]|7(8|[0-4])|8(1[01236789]|21[36]|[016]))|9(6[0-8]|7[0-7]|[0123458]|9(8|[2-6]))|(1-(68|2(4[16]|6[48])|(34[05])|4(41|73)|6(49|64|7[01]|84)|7(58|67|8[47])|8(0|6[89]|[24]9|76)|(939)))|(7-7))(\[ ))?([2-9][0-9]{2}[\[ ][0-9]{3}[\\][0-9]{4}))\\b","\\b(((\\+)?(1|7|2([07]|1[12368]|[2-6][0-9]|9[01789])|3([57][0-9]|8[0125679]|[0123469])|4([013456789]|2[013])|5([1-8]|39(9)?|[09][0-9])|6([0-6]|[78][0-9]|9[0-2])|(758)|8([1246]|0[089]|5[02356]|7(8|[0-4])|8(1[01236789]|21[36]|[016]))|9(6[0-8]|7[0-7]|[0123458]|9(8|[2-6]))|(1-(68|2(4[16]|6[48])|(34[05])|4(41|73)|6(49|64|7[01]|84)|7(58|67|8[47])|8(0|6[89]|[24]9|76)|(939)))|(7-7))[-\[ ])?([2-9][0-9]{2}-[0-9]{3}-[0-9]{4}))\\b","\\b(((\\+)?(1|7|2([07]|1[12368]|[2-6][0-9]|9[01789])|3([57][0-9]|8[0125679]|[0123469])|4([013456789]|2[013])|5([1-8]|39(9)?|[09][0-9])|6([0-6]|[78][0-9]|9[0-2])|(758)|8([1246]|0[089]|5[02356]|7(8|[0-4])|8(1[01236789]|21[36]|[016]))|9(6[0-8]|7[0-7]|[0123458]|9(8|[2-6]))|(1-(68|2(4[16]|6[48])|(34[05])|4(41|73)|6(49|64|7[01]|84)|7(58|67|8[47])|8(0|6[89]|[24]9|76)|(939)))|(7-7))[\\.\[ ])?([2-9][0-9]{2}\\.[0-9]{3}\\.[0-9]{4}))\\b","((\\+)?(1|7|2([07]|1[12368]|[2-6][0-9]|9[01789])|3([57][0-9]|8[0125679]|[0123469])|4([013456789]|2[013])|5([1-8]|39(9)?|[09][0-9])|6([0-6]|[78][0-9]|9[0-2])|(758)|8([1246]|0[089]|5[02356]|7(8|[0-4])|8(1[01236789]|21[36]|[016]))|9(6[0-8]|7[0-7]|[0123458]|9(8|[2-6]))|(1-(68|2(4[16]|6[48])|(34[05])|4(41|73)|6(49|64|7[01]|84)|7(58|67|8[47])|8(0|6[89]|[24]9|76)|(939)))|(7-7))[\[ ]?)?(\\([2-9][0-9]{2}\\)[\[ ][0-9]{3}-[0-9]{4})","((\\+)?(1|7|2([07]|1[12368]|[2-6][0-9]|9[01789])|3([0123469]|[57][0-9]|8[0125679])|4(2[013]|[013456789])|5([1-8]|399|[09][0-9]|39)|6([0-6]|[78][0-9]|9[0-2])|(758)|8(0[089]|5[02356]|7([0-4]|8)|8([016]|1[01236789]|21[36])|[1246])|9(6[0-8]|7[0-7]|9([2-6]|8)|[0123458])|(1-(68|2(4[16]|6[48]|84)|(34[05])|4(41|73)|6(49|64|7[01]|84)|7(58|67|8[47])|8(0[89]|[24]9|6[89]|76)|(939)))|(7-7))\\.)?(\\([2-9][0-9]{2}\\)[\\.][0-9]{3}\\.[0-9]{4})","((\\+)?(1|7|2([07]|1[12368]|[2-6][0-9]|9[01789])|3([57][0-9]|8[0125679]|[0123469])|4([013456789]|2[013])|5([1-8]|39(9)?|[09][0-9])|6([0-6]|[78][0-9]|9[0-2])|(758)|8([1246]|0[089]|5[02356]|7(8|[0-4])|8(1[01236789]|21[36])|[016]))|9(6[0-8]|7[0-7]|[0123458]|9(8|[2-6]))|(1-(68|2(4[16]|6[48])|(34[05])|4(41|73)|6(49|64|7[01]|84)|7(58|67|8[47])|8(0|6[89]|[24]9|76)|(939)))|(7-7)))?(\\([2-9][0-9]{2}\\)[0-9]{3}-[0-9]{4})","((\\+)?(1|7|2([07]|1[12368]|[2-6][0-9]|9[01789])|3([0123469]|[57][0-9]|8[0125679])|4(2[013]|[013456789])|5([1-8]|399|[09][0-9]|39)|6([0-6]|[78][0-9]|9[0-2])|(758)|8(0[089]|5[02356]|7([0-4]|8)|8([016]|1[01236789]|21[36])|[1246])|9(6[0-8]|7[0-7]|9([2-6]|8)|[0123458])|(1-(68|2(4[16]|6[48]|84)|(34[05])|4(41|73)|6(49|64|7[01]|84)|7(58|67|8[47])|8(0[89]|[24]9|6[89]|76)|(939)))|(7-7))\\.)?(\\([2-9][0-9]{2}\\)[\\.][0-9]{3}\\.[0-9]{4})")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("telephone","tel")
- Match Type: Column value
- Name: routingnumber
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("\\b[^459][0-9]{8}\\b")
- Match Type: Column value
- Name: ssn
- Match Type: Column value
- Confidence: 85
- Regular expression:
regex("\\b((((?!(000|666))([0-8][0-9][0-9]))((?!00)([0-9]{2}))((?!0000)([0-9]{4})))|(98765432[0-9]))\\b","\\b((((?!(000|666))([0-8][0-9][0-9]))[\\]((?!00)([0-9]{2}))[\\]((?!0000)([0-9]{4})))|((987)-(65)-(432)[0-9]))\\b","\\b((((?!(000|666))([0-8][0-9][0-9]))-((?!00)([0-9]{2}))-((?!0000)([0-9]{4})))|((987)-(65)-(432)[0-9]))\\b")
- Match Type: Column name
- Confidence: 15
- Regular expression:
is_in_ci("ssn","ssnnumber","ssnno")
- Match Type: Column value
