Skip to content

Instantly share code, notes, and snippets.

@Lessica

Lessica/ssn_mappings.json

Created July 10, 2021 05:39
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Lessica/8103957c401e59875e21d607e2ec2fa1 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Lessica/8103957c401e59875e21d607e2ec2fa1 to your computer and use it in GitHub Desktop.
Download ZIP
Prefix List for Social Security Numbers USA
Raw
ssn_mappings.json
{
"AK": {
"ssn_parts": [
"574"
],
"ssn_prefixes": [
"574"
],
"ssn_sql_parts": [
"LIKE '574%'"
],
"state_full": "AK, Alaska",
"state_name": "Alaska",
"state_prefix": "AK"
},
"AL": {
"ssn_parts": [
"416",
"417",
"418",
"419",
"420",
"421",
"422",
"423",
"424"
],
"ssn_prefixes": [
"416-424"
],
"ssn_sql_parts": [
"LIKE '416%'",
"LIKE '417%'",
"LIKE '418%'",
"LIKE '419%'",
"LIKE '420%'",
"LIKE '421%'",
"LIKE '422%'",
"LIKE '423%'",
"LIKE '424%'"
],
"state_full": "AL, Alabama",
"state_name": "Alabama",
"state_prefix": "AL"
},
"AR": {
"ssn_parts": [
"429",
"430",
"431",
"432",
"676",
"677",
"678",
"679"
],
"ssn_prefixes": [
"429-432",
"676-679"
],
"ssn_sql_parts": [
"LIKE '429%'",
"LIKE '430%'",
"LIKE '431%'",
"LIKE '432%'",
"LIKE '676%'",
"LIKE '677%'",
"LIKE '678%'",
"LIKE '679%'"
],
"state_full": "AR, Arkansas",
"state_name": "Arkansas",
"state_prefix": "AR"
},
"AS": {
"ssn_parts": [
"586"
],
"ssn_prefixes": [
"586"
],
"ssn_sql_parts": [
"LIKE '586%'"
],
"state_full": "AS, American Samoa",
"state_name": "American Samoa",
"state_prefix": "AS"
},
"AZ": {
"ssn_parts": [
"526",
"527",
"600",
"601",
"764",
"765"
],
"ssn_prefixes": [
"526-527",
"600-601",
"764-765"
],
"ssn_sql_parts": [
"LIKE '526%'",
"LIKE '527%'",
"LIKE '600%'",
"LIKE '601%'",
"LIKE '764%'",
"LIKE '765%'"
],
"state_full": "AZ, Arizona",
"state_name": "Arizona",
"state_prefix": "AZ"
},
"CA": {
"ssn_parts": [
"545",
"546",
"547",
"548",
"549",
"550",
"551",
"552",
"553",
"554",
"555",
"556",
"557",
"558",
"559",
"560",
"561",
"562",
"563",
"564",
"565",
"566",
"567",
"568",
"569",
"570",
"571",
"572",
"573",
"602",
"603",
"604",
"605",
"606",
"607",
"608",
"609",
"610",
"611",
"612",
"613",
"614",
"615",
"616",
"617",
"618",
"619",
"620",
"621",
"622",
"623",
"624",
"625",
"626"
],
"ssn_prefixes": [
"545-573",
"602-626"
],
"ssn_sql_parts": [
"LIKE '545%'",
"LIKE '546%'",
"LIKE '547%'",
"LIKE '548%'",
"LIKE '549%'",
"LIKE '550%'",
"LIKE '551%'",
"LIKE '552%'",
"LIKE '553%'",
"LIKE '554%'",
"LIKE '555%'",
"LIKE '556%'",
"LIKE '557%'",
"LIKE '558%'",
"LIKE '559%'",
"LIKE '560%'",
"LIKE '561%'",
"LIKE '562%'",
"LIKE '563%'",
"LIKE '564%'",
"LIKE '565%'",
"LIKE '566%'",
"LIKE '567%'",
"LIKE '568%'",
"LIKE '569%'",
"LIKE '570%'",
"LIKE '571%'",
"LIKE '572%'",
"LIKE '573%'",
"LIKE '602%'",
"LIKE '603%'",
"LIKE '604%'",
"LIKE '605%'",
"LIKE '606%'",
"LIKE '607%'",
"LIKE '608%'",
"LIKE '609%'",
"LIKE '610%'",
"LIKE '611%'",
"LIKE '612%'",
"LIKE '613%'",
"LIKE '614%'",
"LIKE '615%'",
"LIKE '616%'",
"LIKE '617%'",
"LIKE '618%'",
"LIKE '619%'",
"LIKE '620%'",
"LIKE '621%'",
"LIKE '622%'",
"LIKE '623%'",
"LIKE '624%'",
"LIKE '625%'",
"LIKE '626%'"
],
"state_full": "CA, California",
"state_name": "California",
"state_prefix": "CA"
},
"CO": {
"ssn_parts": [
"521",
"522",
"523",
"524",
"650",
"651",
"652",
"653"
],
"ssn_prefixes": [
"521-524",
"650-653"
],
"ssn_sql_parts": [
"LIKE '521%'",
"LIKE '522%'",
"LIKE '523%'",
"LIKE '524%'",
"LIKE '650%'",
"LIKE '651%'",
"LIKE '652%'",
"LIKE '653%'"
],
"state_full": "CO, Colorado",
"state_name": "Colorado",
"state_prefix": "CO"
},
"CT": {
"ssn_parts": [
"040",
"041",
"042",
"043",
"044",
"045",
"046",
"047",
"048",
"049"
],
"ssn_prefixes": [
"040-049"
],
"ssn_sql_parts": [
"LIKE '040%'",
"LIKE '041%'",
"LIKE '042%'",
"LIKE '043%'",
"LIKE '044%'",
"LIKE '045%'",
"LIKE '046%'",
"LIKE '047%'",
"LIKE '048%'",
"LIKE '049%'"
],
"state_full": "CT, Connecticut",
"state_name": "Connecticut",
"state_prefix": "CT"
},
"DC": {
"ssn_parts": [
"577",
"578",
"579"
],
"ssn_prefixes": [
"577-579"
],
"ssn_sql_parts": [
"LIKE '577%'",
"LIKE '578%'",
"LIKE '579%'"
],
"state_full": "DC, District of Columbia",
"state_name": "District of Columbia",
"state_prefix": "DC"
},
"DE": {
"ssn_parts": [
"221",
"222"
],
"ssn_prefixes": [
"221-222"
],
"ssn_sql_parts": [
"LIKE '221%'",
"LIKE '222%'"
],
"state_full": "DE, Delaware",
"state_name": "Delaware",
"state_prefix": "DE"
},
"FL": {
"ssn_parts": [
"261",
"262",
"263",
"264",
"265",
"266",
"267",
"589",
"590",
"591",
"592",
"593",
"594",
"595",
"765",
"766",
"767",
"768",
"769",
"770",
"771",
"772"
],
"ssn_prefixes": [
"261-267",
"589-595",
"765-772"
],
"ssn_sql_parts": [
"LIKE '261%'",
"LIKE '262%'",
"LIKE '263%'",
"LIKE '264%'",
"LIKE '265%'",
"LIKE '266%'",
"LIKE '267%'",
"LIKE '589%'",
"LIKE '590%'",
"LIKE '591%'",
"LIKE '592%'",
"LIKE '593%'",
"LIKE '594%'",
"LIKE '595%'",
"LIKE '765%'",
"LIKE '766%'",
"LIKE '767%'",
"LIKE '768%'",
"LIKE '769%'",
"LIKE '770%'",
"LIKE '771%'",
"LIKE '772%'"
],
"state_full": "FL, Florida",
"state_name": "Florida",
"state_prefix": "FL"
},
"GA": {
"ssn_parts": [
"252",
"253",
"254",
"255",
"256",
"257",
"258",
"259",
"260",
"667",
"668",
"669",
"670",
"671",
"672",
"673",
"674",
"675"
],
"ssn_prefixes": [
"252-260",
"667-675"
],
"ssn_sql_parts": [
"LIKE '252%'",
"LIKE '253%'",
"LIKE '254%'",
"LIKE '255%'",
"LIKE '256%'",
"LIKE '257%'",
"LIKE '258%'",
"LIKE '259%'",
"LIKE '260%'",
"LIKE '667%'",
"LIKE '668%'",
"LIKE '669%'",
"LIKE '670%'",
"LIKE '671%'",
"LIKE '672%'",
"LIKE '673%'",
"LIKE '674%'",
"LIKE '675%'"
],
"state_full": "GA, Georgia",
"state_name": "Georgia",
"state_prefix": "GA"
},
"GU": {
"ssn_parts": [
"586"
],
"ssn_prefixes": [
"586"
],
"ssn_sql_parts": [
"LIKE '586%'"
],
"state_full": "GU, Guam",
"state_name": "Guam",
"state_prefix": "GU"
},
"HI": {
"ssn_parts": [
"575",
"576",
"750",
"751"
],
"ssn_prefixes": [
"575-576",
"750-751"
],
"ssn_sql_parts": [
"LIKE '575%'",
"LIKE '576%'",
"LIKE '750%'",
"LIKE '751%'"
],
"state_full": "HI, Hawaii",
"state_name": "Hawaii",
"state_prefix": "HI"
},
"IA": {
"ssn_parts": [
"478",
"479",
"480",
"481",
"482",
"483",
"484",
"485"
],
"ssn_prefixes": [
"478-485"
],
"ssn_sql_parts": [
"LIKE '478%'",
"LIKE '479%'",
"LIKE '480%'",
"LIKE '481%'",
"LIKE '482%'",
"LIKE '483%'",
"LIKE '484%'",
"LIKE '485%'"
],
"state_full": "IA, Iowa",
"state_name": "Iowa",
"state_prefix": "IA"
},
"ID": {
"ssn_parts": [
"518",
"519"
],
"ssn_prefixes": [
"518-519"
],
"ssn_sql_parts": [
"LIKE '518%'",
"LIKE '519%'"
],
"state_full": "ID, Idaho",
"state_name": "Idaho",
"state_prefix": "ID"
},
"IL": {
"ssn_parts": [
"318",
"319",
"320",
"321",
"322",
"323",
"324",
"325",
"326",
"327",
"328",
"329",
"330",
"331",
"332",
"333",
"334",
"335",
"336",
"337",
"338",
"339",
"340",
"341",
"342",
"343",
"344",
"345",
"346",
"347",
"348",
"349",
"350",
"351",
"352",
"353",
"354",
"355",
"356",
"357",
"358",
"359",
"360",
"361"
],
"ssn_prefixes": [
"318-361"
],
"ssn_sql_parts": [
"LIKE '318%'",
"LIKE '319%'",
"LIKE '320%'",
"LIKE '321%'",
"LIKE '322%'",
"LIKE '323%'",
"LIKE '324%'",
"LIKE '325%'",
"LIKE '326%'",
"LIKE '327%'",
"LIKE '328%'",
"LIKE '329%'",
"LIKE '330%'",
"LIKE '331%'",
"LIKE '332%'",
"LIKE '333%'",
"LIKE '334%'",
"LIKE '335%'",
"LIKE '336%'",
"LIKE '337%'",
"LIKE '338%'",
"LIKE '339%'",
"LIKE '340%'",
"LIKE '341%'",
"LIKE '342%'",
"LIKE '343%'",
"LIKE '344%'",
"LIKE '345%'",
"LIKE '346%'",
"LIKE '347%'",
"LIKE '348%'",
"LIKE '349%'",
"LIKE '350%'",
"LIKE '351%'",
"LIKE '352%'",
"LIKE '353%'",
"LIKE '354%'",
"LIKE '355%'",
"LIKE '356%'",
"LIKE '357%'",
"LIKE '358%'",
"LIKE '359%'",
"LIKE '360%'",
"LIKE '361%'"
],
"state_full": "IL, Illinois",
"state_name": "Illinois",
"state_prefix": "IL"
},
"IN": {
"ssn_parts": [
"303",
"304",
"305",
"306",
"307",
"308",
"309",
"310",
"311",
"312",
"313",
"314",
"315",
"316",
"317"
],
"ssn_prefixes": [
"303-317"
],
"ssn_sql_parts": [
"LIKE '303%'",
"LIKE '304%'",
"LIKE '305%'",
"LIKE '306%'",
"LIKE '307%'",
"LIKE '308%'",
"LIKE '309%'",
"LIKE '310%'",
"LIKE '311%'",
"LIKE '312%'",
"LIKE '313%'",
"LIKE '314%'",
"LIKE '315%'",
"LIKE '316%'",
"LIKE '317%'"
],
"state_full": "IN, Indiana",
"state_name": "Indiana",
"state_prefix": "IN"
},
"KS": {
"ssn_parts": [
"508",
"509",
"510",
"511",
"512",
"513",
"514",
"515"
],
"ssn_prefixes": [
"508-515"
],
"ssn_sql_parts": [
"LIKE '508%'",
"LIKE '509%'",
"LIKE '510%'",
"LIKE '511%'",
"LIKE '512%'",
"LIKE '513%'",
"LIKE '514%'",
"LIKE '515%'"
],
"state_full": "KS, Kansas",
"state_name": "Kansas",
"state_prefix": "KS"
},
"KY": {
"ssn_parts": [
"400",
"401",
"402",
"403",
"404",
"405",
"406",
"407"
],
"ssn_prefixes": [
"400-407"
],
"ssn_sql_parts": [
"LIKE '400%'",
"LIKE '401%'",
"LIKE '402%'",
"LIKE '403%'",
"LIKE '404%'",
"LIKE '405%'",
"LIKE '406%'",
"LIKE '407%'"
],
"state_full": "KY, Kentucky",
"state_name": "Kentucky",
"state_prefix": "KY"
},
"LA": {
"ssn_parts": [
"433",
"434",
"435",
"436",
"437",
"438",
"439",
"659",
"660",
"661",
"662",
"663",
"664",
"665"
],
"ssn_prefixes": [
"433-439",
"659-665"
],
"ssn_sql_parts": [
"LIKE '433%'",
"LIKE '434%'",
"LIKE '435%'",
"LIKE '436%'",
"LIKE '437%'",
"LIKE '438%'",
"LIKE '439%'",
"LIKE '659%'",
"LIKE '660%'",
"LIKE '661%'",
"LIKE '662%'",
"LIKE '663%'",
"LIKE '664%'",
"LIKE '665%'"
],
"state_full": "LA, Louisiana",
"state_name": "Louisiana",
"state_prefix": "LA"
},
"MA": {
"ssn_parts": [
"010",
"011",
"012",
"013",
"014",
"015",
"016",
"017",
"018",
"019",
"020",
"021",
"022",
"023",
"024",
"025",
"026",
"027",
"028",
"029",
"030",
"031",
"032",
"033",
"034"
],
"ssn_prefixes": [
"010-034"
],
"ssn_sql_parts": [
"LIKE '010%'",
"LIKE '011%'",
"LIKE '012%'",
"LIKE '013%'",
"LIKE '014%'",
"LIKE '015%'",
"LIKE '016%'",
"LIKE '017%'",
"LIKE '018%'",
"LIKE '019%'",
"LIKE '020%'",
"LIKE '021%'",
"LIKE '022%'",
"LIKE '023%'",
"LIKE '024%'",
"LIKE '025%'",
"LIKE '026%'",
"LIKE '027%'",
"LIKE '028%'",
"LIKE '029%'",
"LIKE '030%'",
"LIKE '031%'",
"LIKE '032%'",
"LIKE '033%'",
"LIKE '034%'"
],
"state_full": "MA, Massachusetts",
"state_name": "Massachusetts",
"state_prefix": "MA"
},
"MD": {
"ssn_parts": [
"212",
"213",
"214",
"215",
"216",
"217",
"218",
"219",
"220"
],
"ssn_prefixes": [
"212-220"
],
"ssn_sql_parts": [
"LIKE '212%'",
"LIKE '213%'",
"LIKE '214%'",
"LIKE '215%'",
"LIKE '216%'",
"LIKE '217%'",
"LIKE '218%'",
"LIKE '219%'",
"LIKE '220%'"
],
"state_full": "MD, Maryland",
"state_name": "Maryland",
"state_prefix": "MD"
},
"ME": {
"ssn_parts": [
"004",
"005",
"006",
"007"
],
"ssn_prefixes": [
"004-007"
],
"ssn_sql_parts": [
"LIKE '004%'",
"LIKE '005%'",
"LIKE '006%'",
"LIKE '007%'"
],
"state_full": "ME, Maine",
"state_name": "Maine",
"state_prefix": "ME"
},
"MI": {
"ssn_parts": [
"362",
"363",
"364",
"365",
"366",
"367",
"368",
"369",
"370",
"371",
"372",
"373",
"374",
"375",
"376",
"377",
"378",
"379",
"380",
"381",
"382",
"383",
"384",
"385",
"386"
],
"ssn_prefixes": [
"362-386"
],
"ssn_sql_parts": [
"LIKE '362%'",
"LIKE '363%'",
"LIKE '364%'",
"LIKE '365%'",
"LIKE '366%'",
"LIKE '367%'",
"LIKE '368%'",
"LIKE '369%'",
"LIKE '370%'",
"LIKE '371%'",
"LIKE '372%'",
"LIKE '373%'",
"LIKE '374%'",
"LIKE '375%'",
"LIKE '376%'",
"LIKE '377%'",
"LIKE '378%'",
"LIKE '379%'",
"LIKE '380%'",
"LIKE '381%'",
"LIKE '382%'",
"LIKE '383%'",
"LIKE '384%'",
"LIKE '385%'",
"LIKE '386%'"
],
"state_full": "MI, Michigan",
"state_name": "Michigan",
"state_prefix": "MI"
},
"MN": {
"ssn_parts": [
"468",
"469",
"470",
"471",
"472",
"473",
"474",
"475",
"476",
"477"
],
"ssn_prefixes": [
"468-477"
],
"ssn_sql_parts": [
"LIKE '468%'",
"LIKE '469%'",
"LIKE '470%'",
"LIKE '471%'",
"LIKE '472%'",
"LIKE '473%'",
"LIKE '474%'",
"LIKE '475%'",
"LIKE '476%'",
"LIKE '477%'"
],
"state_full": "MN, Minnesota",
"state_name": "Minnesota",
"state_prefix": "MN"
},
"MO": {
"ssn_parts": [
"486",
"487",
"488",
"489",
"490",
"491",
"492",
"493",
"494",
"495",
"496",
"497",
"498",
"499",
"500"
],
"ssn_prefixes": [
"486-500"
],
"ssn_sql_parts": [
"LIKE '486%'",
"LIKE '487%'",
"LIKE '488%'",
"LIKE '489%'",
"LIKE '490%'",
"LIKE '491%'",
"LIKE '492%'",
"LIKE '493%'",
"LIKE '494%'",
"LIKE '495%'",
"LIKE '496%'",
"LIKE '497%'",
"LIKE '498%'",
"LIKE '499%'",
"LIKE '500%'"
],
"state_full": "MO, Missouri",
"state_name": "Missouri",
"state_prefix": "MO"
},
"MS": {
"ssn_parts": [
"425",
"426",
"427",
"428",
"587",
"588",
"752",
"753",
"754",
"755"
],
"ssn_prefixes": [
"425-428",
"587-588",
"752-755"
],
"ssn_sql_parts": [
"LIKE '425%'",
"LIKE '426%'",
"LIKE '427%'",
"LIKE '428%'",
"LIKE '587%'",
"LIKE '588%'",
"LIKE '752%'",
"LIKE '753%'",
"LIKE '754%'",
"LIKE '755%'"
],
"state_full": "MS, Mississippi",
"state_name": "Mississippi",
"state_prefix": "MS"
},
"MT": {
"ssn_parts": [
"516",
"517"
],
"ssn_prefixes": [
"516-517"
],
"ssn_sql_parts": [
"LIKE '516%'",
"LIKE '517%'"
],
"state_full": "MT, Montana",
"state_name": "Montana",
"state_prefix": "MT"
},
"NC": {
"ssn_parts": [
"232",
"237",
"238",
"239",
"240",
"241",
"242",
"243",
"244",
"245",
"246",
"681",
"682",
"683",
"684",
"685",
"686",
"687",
"688",
"689",
"690"
],
"ssn_prefixes": [
"232",
"237-246",
"681-690"
],
"ssn_sql_parts": [
"LIKE '232%'",
"LIKE '237%'",
"LIKE '238%'",
"LIKE '239%'",
"LIKE '240%'",
"LIKE '241%'",
"LIKE '242%'",
"LIKE '243%'",
"LIKE '244%'",
"LIKE '245%'",
"LIKE '246%'",
"LIKE '681%'",
"LIKE '682%'",
"LIKE '683%'",
"LIKE '684%'",
"LIKE '685%'",
"LIKE '686%'",
"LIKE '687%'",
"LIKE '688%'",
"LIKE '689%'",
"LIKE '690%'"
],
"state_full": "NC, North Carolina",
"state_name": "North Carolina",
"state_prefix": "NC"
},
"ND": {
"ssn_parts": [
"501",
"502"
],
"ssn_prefixes": [
"501-502"
],
"ssn_sql_parts": [
"LIKE '501%'",
"LIKE '502%'"
],
"state_full": "ND, North Dakota",
"state_name": "North Dakota",
"state_prefix": "ND"
},
"NE": {
"ssn_parts": [
"505",
"506",
"507",
"508"
],
"ssn_prefixes": [
"505-508"
],
"ssn_sql_parts": [
"LIKE '505%'",
"LIKE '506%'",
"LIKE '507%'",
"LIKE '508%'"
],
"state_full": "NE, Nebraska",
"state_name": "Nebraska",
"state_prefix": "NE"
},
"NH": {
"ssn_parts": [
"001",
"002",
"003"
],
"ssn_prefixes": [
"001-003"
],
"ssn_sql_parts": [
"LIKE '001%'",
"LIKE '002%'",
"LIKE '003%'"
],
"state_full": "NH, New Hampshire",
"state_name": "New Hampshire",
"state_prefix": "NH"
},
"NJ": {
"ssn_parts": [
"135",
"136",
"137",
"138",
"139",
"140",
"141",
"142",
"143",
"144",
"145",
"146",
"147",
"148",
"149",
"150",
"151",
"152",
"153",
"154",
"155",
"156",
"157",
"158"
],
"ssn_prefixes": [
"135-158"
],
"ssn_sql_parts": [
"LIKE '135%'",
"LIKE '136%'",
"LIKE '137%'",
"LIKE '138%'",
"LIKE '139%'",
"LIKE '140%'",
"LIKE '141%'",
"LIKE '142%'",
"LIKE '143%'",
"LIKE '144%'",
"LIKE '145%'",
"LIKE '146%'",
"LIKE '147%'",
"LIKE '148%'",
"LIKE '149%'",
"LIKE '150%'",
"LIKE '151%'",
"LIKE '152%'",
"LIKE '153%'",
"LIKE '154%'",
"LIKE '155%'",
"LIKE '156%'",
"LIKE '157%'",
"LIKE '158%'"
],
"state_full": "NJ, New Jersey",
"state_name": "New Jersey",
"state_prefix": "NJ"
},
"NM": {
"ssn_parts": [
"525",
"585",
"648",
"649"
],
"ssn_prefixes": [
"525",
"585",
"648-649"
],
"ssn_sql_parts": [
"LIKE '525%'",
"LIKE '585%'",
"LIKE '648%'",
"LIKE '649%'"
],
"state_full": "NM, New Mexico",
"state_name": "New Mexico",
"state_prefix": "NM"
},
"NV": {
"ssn_parts": [
"530",
"680"
],
"ssn_prefixes": [
"530",
"680"
],
"ssn_sql_parts": [
"LIKE '530%'",
"LIKE '680%'"
],
"state_full": "NV, Nevada",
"state_name": "Nevada",
"state_prefix": "NV"
},
"NY": {
"ssn_parts": [
"050",
"051",
"052",
"053",
"054",
"055",
"056",
"057",
"058",
"059",
"060",
"061",
"062",
"063",
"064",
"065",
"066",
"067",
"068",
"069",
"070",
"071",
"072",
"073",
"074",
"075",
"076",
"077",
"078",
"079",
"080",
"081",
"082",
"083",
"084",
"085",
"086",
"087",
"088",
"089",
"090",
"091",
"092",
"093",
"094",
"095",
"096",
"097",
"098",
"099",
"100",
"101",
"102",
"103",
"104",
"105",
"106",
"107",
"108",
"109",
"110",
"111",
"112",
"113",
"114",
"115",
"116",
"117",
"118",
"119",
"120",
"121",
"122",
"123",
"124",
"125",
"126",
"127",
"128",
"129",
"130",
"131",
"132",
"133",
"134"
],
"ssn_prefixes": [
"050-134"
],
"ssn_sql_parts": [
"LIKE '050%'",
"LIKE '051%'",
"LIKE '052%'",
"LIKE '053%'",
"LIKE '054%'",
"LIKE '055%'",
"LIKE '056%'",
"LIKE '057%'",
"LIKE '058%'",
"LIKE '059%'",
"LIKE '060%'",
"LIKE '061%'",
"LIKE '062%'",
"LIKE '063%'",
"LIKE '064%'",
"LIKE '065%'",
"LIKE '066%'",
"LIKE '067%'",
"LIKE '068%'",
"LIKE '069%'",
"LIKE '070%'",
"LIKE '071%'",
"LIKE '072%'",
"LIKE '073%'",
"LIKE '074%'",
"LIKE '075%'",
"LIKE '076%'",
"LIKE '077%'",
"LIKE '078%'",
"LIKE '079%'",
"LIKE '080%'",
"LIKE '081%'",
"LIKE '082%'",
"LIKE '083%'",
"LIKE '084%'",
"LIKE '085%'",
"LIKE '086%'",
"LIKE '087%'",
"LIKE '088%'",
"LIKE '089%'",
"LIKE '090%'",
"LIKE '091%'",
"LIKE '092%'",
"LIKE '093%'",
"LIKE '094%'",
"LIKE '095%'",
"LIKE '096%'",
"LIKE '097%'",
"LIKE '098%'",
"LIKE '099%'",
"LIKE '100%'",
"LIKE '101%'",
"LIKE '102%'",
"LIKE '103%'",
"LIKE '104%'",
"LIKE '105%'",
"LIKE '106%'",
"LIKE '107%'",
"LIKE '108%'",
"LIKE '109%'",
"LIKE '110%'",
"LIKE '111%'",
"LIKE '112%'",
"LIKE '113%'",
"LIKE '114%'",
"LIKE '115%'",
"LIKE '116%'",
"LIKE '117%'",
"LIKE '118%'",
"LIKE '119%'",
"LIKE '120%'",
"LIKE '121%'",
"LIKE '122%'",
"LIKE '123%'",
"LIKE '124%'",
"LIKE '125%'",
"LIKE '126%'",
"LIKE '127%'",
"LIKE '128%'",
"LIKE '129%'",
"LIKE '130%'",
"LIKE '131%'",
"LIKE '132%'",
"LIKE '133%'",
"LIKE '134%'"
],
"state_full": "NY, New York",
"state_name": "New York",
"state_prefix": "NY"
},
"OH": {
"ssn_parts": [
"268",
"269",
"270",
"271",
"272",
"273",
"274",
"275",
"276",
"277",
"278",
"279",
"280",
"281",
"282",
"283",
"284",
"285",
"286",
"287",
"288",
"289",
"290",
"291",
"292",
"293",
"294",
"295",
"296",
"297",
"298",
"299",
"300",
"301",
"302"
],
"ssn_prefixes": [
"268-302"
],
"ssn_sql_parts": [
"LIKE '268%'",
"LIKE '269%'",
"LIKE '270%'",
"LIKE '271%'",
"LIKE '272%'",
"LIKE '273%'",
"LIKE '274%'",
"LIKE '275%'",
"LIKE '276%'",
"LIKE '277%'",
"LIKE '278%'",
"LIKE '279%'",
"LIKE '280%'",
"LIKE '281%'",
"LIKE '282%'",
"LIKE '283%'",
"LIKE '284%'",
"LIKE '285%'",
"LIKE '286%'",
"LIKE '287%'",
"LIKE '288%'",
"LIKE '289%'",
"LIKE '290%'",
"LIKE '291%'",
"LIKE '292%'",
"LIKE '293%'",
"LIKE '294%'",
"LIKE '295%'",
"LIKE '296%'",
"LIKE '297%'",
"LIKE '298%'",
"LIKE '299%'",
"LIKE '300%'",
"LIKE '301%'",
"LIKE '302%'"
],
"state_full": "OH, Ohio",
"state_name": "Ohio",
"state_prefix": "OH"
},
"OK": {
"ssn_parts": [
"440",
"441",
"442",
"443",
"444",
"445",
"446",
"447",
"448"
],
"ssn_prefixes": [
"440-448"
],
"ssn_sql_parts": [
"LIKE '440%'",
"LIKE '441%'",
"LIKE '442%'",
"LIKE '443%'",
"LIKE '444%'",
"LIKE '445%'",
"LIKE '446%'",
"LIKE '447%'",
"LIKE '448%'"
],
"state_full": "OK, Oklahoma",
"state_name": "Oklahoma",
"state_prefix": "OK"
},
"OR": {
"ssn_parts": [
"540",
"541",
"542",
"543",
"544"
],
"ssn_prefixes": [
"540-544"
],
"ssn_sql_parts": [
"LIKE '540%'",
"LIKE '541%'",
"LIKE '542%'",
"LIKE '543%'",
"LIKE '544%'"
],
"state_full": "OR, Oregon",
"state_name": "Oregon",
"state_prefix": "OR"
},
"PA": {
"ssn_parts": [
"159",
"160",
"161",
"162",
"163",
"164",
"165",
"166",
"167",
"168",
"169",
"170",
"171",
"172",
"173",
"174",
"175",
"176",
"177",
"178",
"179",
"180",
"181",
"182",
"183",
"184",
"185",
"186",
"187",
"188",
"189",
"190",
"191",
"192",
"193",
"194",
"195",
"196",
"197",
"198",
"199",
"200",
"201",
"202",
"203",
"204",
"205",
"206",
"207",
"208",
"209",
"210",
"211"
],
"ssn_prefixes": [
"159-211"
],
"ssn_sql_parts": [
"LIKE '159%'",
"LIKE '160%'",
"LIKE '161%'",
"LIKE '162%'",
"LIKE '163%'",
"LIKE '164%'",
"LIKE '165%'",
"LIKE '166%'",
"LIKE '167%'",
"LIKE '168%'",
"LIKE '169%'",
"LIKE '170%'",
"LIKE '171%'",
"LIKE '172%'",
"LIKE '173%'",
"LIKE '174%'",
"LIKE '175%'",
"LIKE '176%'",
"LIKE '177%'",
"LIKE '178%'",
"LIKE '179%'",
"LIKE '180%'",
"LIKE '181%'",
"LIKE '182%'",
"LIKE '183%'",
"LIKE '184%'",
"LIKE '185%'",
"LIKE '186%'",
"LIKE '187%'",
"LIKE '188%'",
"LIKE '189%'",
"LIKE '190%'",
"LIKE '191%'",
"LIKE '192%'",
"LIKE '193%'",
"LIKE '194%'",
"LIKE '195%'",
"LIKE '196%'",
"LIKE '197%'",
"LIKE '198%'",
"LIKE '199%'",
"LIKE '200%'",
"LIKE '201%'",
"LIKE '202%'",
"LIKE '203%'",
"LIKE '204%'",
"LIKE '205%'",
"LIKE '206%'",
"LIKE '207%'",
"LIKE '208%'",
"LIKE '209%'",
"LIKE '210%'",
"LIKE '211%'"
],
"state_full": "PA, Pennsylvania",
"state_name": "Pennsylvania",
"state_prefix": "PA"
},
"PR": {
"ssn_parts": [
"580",
"581",
"582",
"583",
"584",
"596",
"597",
"598",
"599"
],
"ssn_prefixes": [
"580-584",
"596-599"
],
"ssn_sql_parts": [
"LIKE '580%'",
"LIKE '581%'",
"LIKE '582%'",
"LIKE '583%'",
"LIKE '584%'",
"LIKE '596%'",
"LIKE '597%'",
"LIKE '598%'",
"LIKE '599%'"
],
"state_full": "PR, Puerto Rico",
"state_name": "Puerto Rico",
"state_prefix": "PR"
},
"RI": {
"ssn_parts": [
"035",
"036",
"037",
"038",
"039"
],
"ssn_prefixes": [
"035-039"
],
"ssn_sql_parts": [
"LIKE '035%'",
"LIKE '036%'",
"LIKE '037%'",
"LIKE '038%'",
"LIKE '039%'"
],
"state_full": "RI, Rhode Island",
"state_name": "Rhode Island",
"state_prefix": "RI"
},
"SC": {
"ssn_parts": [
"247",
"248",
"249",
"250",
"251",
"654",
"655",
"656",
"657",
"658"
],
"ssn_prefixes": [
"247-251",
"654-658"
],
"ssn_sql_parts": [
"LIKE '247%'",
"LIKE '248%'",
"LIKE '249%'",
"LIKE '250%'",
"LIKE '251%'",
"LIKE '654%'",
"LIKE '655%'",
"LIKE '656%'",
"LIKE '657%'",
"LIKE '658%'"
],
"state_full": "SC, South Carolina",
"state_name": "South Carolina",
"state_prefix": "SC"
},
"SD": {
"ssn_parts": [
"503",
"504"
],
"ssn_prefixes": [
"503-504"
],
"ssn_sql_parts": [
"LIKE '503%'",
"LIKE '504%'"
],
"state_full": "SD, South Dakota",
"state_name": "South Dakota",
"state_prefix": "SD"
},
"TN": {
"ssn_parts": [
"408",
"409",
"410",
"411",
"412",
"413",
"414",
"415",
"756",
"757",
"758",
"759",
"760",
"761",
"762",
"763"
],
"ssn_prefixes": [
"408-415",
"756-763"
],
"ssn_sql_parts": [
"LIKE '408%'",
"LIKE '409%'",
"LIKE '410%'",
"LIKE '411%'",
"LIKE '412%'",
"LIKE '413%'",
"LIKE '414%'",
"LIKE '415%'",
"LIKE '756%'",
"LIKE '757%'",
"LIKE '758%'",
"LIKE '759%'",
"LIKE '760%'",
"LIKE '761%'",
"LIKE '762%'",
"LIKE '763%'"
],
"state_full": "TN, Tennessee",
"state_name": "Tennessee",
"state_prefix": "TN"
},
"TX": {
"ssn_parts": [
"449",
"450",
"451",
"452",
"453",
"454",
"455",
"456",
"457",
"458",
"459",
"460",
"461",
"462",
"463",
"464",
"465",
"466",
"467",
"627",
"628",
"629",
"630",
"631",
"632",
"633",
"634",
"635",
"636",
"637",
"638",
"639",
"640",
"641",
"642",
"643",
"644",
"645",
"646",
"647"
],
"ssn_prefixes": [
"449-467",
"627-647"
],
"ssn_sql_parts": [
"LIKE '449%'",
"LIKE '450%'",
"LIKE '451%'",
"LIKE '452%'",
"LIKE '453%'",
"LIKE '454%'",
"LIKE '455%'",
"LIKE '456%'",
"LIKE '457%'",
"LIKE '458%'",
"LIKE '459%'",
"LIKE '460%'",
"LIKE '461%'",
"LIKE '462%'",
"LIKE '463%'",
"LIKE '464%'",
"LIKE '465%'",
"LIKE '466%'",
"LIKE '467%'",
"LIKE '627%'",
"LIKE '628%'",
"LIKE '629%'",
"LIKE '630%'",
"LIKE '631%'",
"LIKE '632%'",
"LIKE '633%'",
"LIKE '634%'",
"LIKE '635%'",
"LIKE '636%'",
"LIKE '637%'",
"LIKE '638%'",
"LIKE '639%'",
"LIKE '640%'",
"LIKE '641%'",
"LIKE '642%'",
"LIKE '643%'",
"LIKE '644%'",
"LIKE '645%'",
"LIKE '646%'",
"LIKE '647%'"
],
"state_full": "TX, Texas",
"state_name": "Texas",
"state_prefix": "TX"
},
"UT": {
"ssn_parts": [
"528",
"529"
],
"ssn_prefixes": [
"528-529"
],
"ssn_sql_parts": [
"LIKE '528%'",
"LIKE '529%'"
],
"state_full": "UT, Utah",
"state_name": "Utah",
"state_prefix": "UT"
},
"VA": {
"ssn_parts": [
"223",
"224",
"225",
"226",
"227",
"228",
"229",
"230",
"231",
"691",
"692",
"693",
"694",
"695",
"696",
"697",
"698",
"699"
],
"ssn_prefixes": [
"223-231",
"691-699"
],
"ssn_sql_parts": [
"LIKE '223%'",
"LIKE '224%'",
"LIKE '225%'",
"LIKE '226%'",
"LIKE '227%'",
"LIKE '228%'",
"LIKE '229%'",
"LIKE '230%'",
"LIKE '231%'",
"LIKE '691%'",
"LIKE '692%'",
"LIKE '693%'",
"LIKE '694%'",
"LIKE '695%'",
"LIKE '696%'",
"LIKE '697%'",
"LIKE '698%'",
"LIKE '699%'"
],
"state_full": "VA, Virginia",
"state_name": "Virginia",
"state_prefix": "VA"
},
"VI": {
"ssn_parts": [
"580"
],
"ssn_prefixes": [
"580"
],
"ssn_sql_parts": [
"LIKE '580%'"
],
"state_full": "VI, Virgin Islands",
"state_name": "Virgin Islands",
"state_prefix": "VI"
},
"VT": {
"ssn_parts": [
"008",
"009"
],
"ssn_prefixes": [
"008-009"
],
"ssn_sql_parts": [
"LIKE '008%'",
"LIKE '009%'"
],
"state_full": "VT, Vermont",
"state_name": "Vermont",
"state_prefix": "VT"
},
"WA": {
"ssn_parts": [
"531",
"532",
"533",
"534",
"535",
"536",
"537",
"538",
"539"
],
"ssn_prefixes": [
"531-539"
],
"ssn_sql_parts": [
"LIKE '531%'",
"LIKE '532%'",
"LIKE '533%'",
"LIKE '534%'",
"LIKE '535%'",
"LIKE '536%'",
"LIKE '537%'",
"LIKE '538%'",
"LIKE '539%'"
],
"state_full": "WA, Washington",
"state_name": "Washington",
"state_prefix": "WA"
},
"WI": {
"ssn_parts": [
"387",
"388",
"389",
"390",
"391",
"392",
"393",
"394",
"395",
"396",
"397",
"398",
"399"
],
"ssn_prefixes": [
"387-399"
],
"ssn_sql_parts": [
"LIKE '387%'",
"LIKE '388%'",
"LIKE '389%'",
"LIKE '390%'",
"LIKE '391%'",
"LIKE '392%'",
"LIKE '393%'",
"LIKE '394%'",
"LIKE '395%'",
"LIKE '396%'",
"LIKE '397%'",
"LIKE '398%'",
"LIKE '399%'"
],
"state_full": "WI, Wisconsin",
"state_name": "Wisconsin",
"state_prefix": "WI"
},
"WV": {
"ssn_parts": [
"232",
"233",
"234",
"235",
"236"
],
"ssn_prefixes": [
"232-236"
],
"ssn_sql_parts": [
"LIKE '232%'",
"LIKE '233%'",
"LIKE '234%'",
"LIKE '235%'",
"LIKE '236%'"
],
"state_full": "WV, West Virginia",
"state_name": "West Virginia",
"state_prefix": "WV"
},
"WY": {
"ssn_parts": [
"520"
],
"ssn_prefixes": [
"520"
],
"ssn_sql_parts": [
"LIKE '520%'"
],
"state_full": "WY, Wyoming",
"state_name": "Wyoming",
"state_prefix": "WY"
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment