August 16, 2003

Soundex Surname Code

This technique was originally developed by Margaret K. Odell and Robert C. Russell for use in encoding surnames for the U.S. Census Bureau. This technique is designed to bring together a great variety of surname spellings which might represent errors in the spelling of the last name during data entry or inquiry.

The code consists of a four position code. The first position contains the first letter of the surname followed by three positions encoded as follows:

  1. B, P, F, V
  2. C, G, J, K, Q, S, X, Z
  3. D, T
  4. L
  5. M, N
  6. R

Letters whose codes do not appear on this list will be ignored. If there are sufficient letters in the name to generate a code longer than four digits, then all other letters in the name will be discarded. Surnames that do not generate a code of sufficient length will have the extra digits filled with zeroes.

Code numbers will never be repeated in succession; only the first occurrence will be used. This rule also applies to the first letter of the surname. If the next coded letter of the name matches what the coded value of the first letter would have been, then it will be discarded.

Examples of correct soundex codes are as follows: Smith–S530, Scott–S300, Miller–M460, Schmit–S530, Williams–W452, McDougall–M232, and Bilbo–B410. The selection of the correct name from the list of similar sounding names will be made by examining the other criteria presented along with the surnames.

Posted by pscott at 11:03 PM

Valid Social Security Numbers

Sorted by SSN

Sorted by State

First 3 DigitsState/Territory
001–003 New Hampshire
004–007 Maine
008–009 Vermont
010–034 Massachusetts
035–039 Rhode Island
040–049 Connecticut
050–134 New York
135–158 New Jersey
159–211 Pennsylvania
212–220 Maryland
221–222 Delaware
223–231 Virginia
232 North Carolina,
West Virginia
233–236 West Virginia
237–246 North Carolina
247–251 South Carolina
252–260 Georgia
261–267 Florida
268–302 Ohio
303–317 Indiana
318–361 Illinois
362–386 Michigan
387–399 Wisconsin
400–407 Kentucky
408–415 Tennessee
416–424 Alabama
425–428 Mississippi
429–432 Arkansas
433–439 Louisiana
440–448 Oklahoma
449–467 Texas
468–477 Minnesota
478–485 Iowa
486–500 Missouri
501–502 North Dakota
503–504 South Dakota
505–508 Nebraska
509–515 Kansas
516–517 Montana
518–519 Idaho
520 Wyoming
521–524 Colorado
525 New Mexico
526–527 Arizona
528–529 Utah
530 Nevada
531–539 Washington
540–544 Oregon
545–573 California
574 Alaska
575–576 Hawaii
577–579 District of Columbia
580 Virgin Islands
580–584 Puerto Rico
585 New Mexico
586 Guam,
American Samoa,
Philippine Islands
587–588 Mississippi
589–595 Florida
596–599 Puerto Rico
600–601 Arizona
602–626 California
627–645 Texas
646–647 Utah
648–649 New Mexico
650–653 Colorado
654–658 South Carolina
659–665 Louisiana
667–675 Georgia
676–679 Arkansas
680 Nevada
681–690 North Carolina
691–699 Virginia
700–728 Railroad Board
750–751 Hawaii
752–755 Mississippi
756–763 Tennessee
764–765 Arizona
766–772 Florida
 
State/TerritoryFirst 3 Digits
Alabama416–424
Alaska574
American Samoa586
Arizona526–527,
600-601,
764-765
Arkansas 429–432,
676-679
California 545–573,
602-626
Colorado 521–524,
650-653
Connecticut040–049
Delaware221–222
District of Columbia577–579
Florida261–267,
589-595,
766-772
Georgia252–260,
667-675
Guam586
Hawaii 575–576,
750–751
Idaho518–519
Illinois318–361
Indiana303–317
Iowa478–485
Kansas509–515
Kentucky400–407
Louisiana 433–439,
659–665
Maine004–007
Maryland212–220
Massachusetts010–034
Michigan362–386
Minnesota468–477
Mississippi425–428,
587–588,
752-755
Missouri486–500
Montana516–517
Nebraska505–508
Nevada 530 680
New Hampshire001–003
New Jersey135–158
New Mexico 525,
585,
648–649
New York050–134
North Carolina232,
237–246,
681-690
North Dakota501–502
Ohio268–302
Oklahoma440–448
Oregon540–544
Pennsylvania159–211
Philippine Islands586
Puerto Rico 580–584,
596-599
Railroad Board700–728
Rhode Island035–039
South Carolina247–251,
654-658
South Dakota503–504
Tennessee408–415,
756-763
Texas 449–467,
627-645
Utah 528–529,
646-647
Vermont008–009
Virginia223–231,
691-699
Virgin Islands580
Washington531–539
West Virginia232–236
Wisconsin387–399
Wyoming520
Posted by pscott at 09:54 PM

Invalid Social Security Numbers

  1. All single digits are the same
  2. The number is 123-45-6789
  3. The number is 987-65-4321
  4. The number is 078-05-1120
  5. First three positions are 000
  6. First three positions are 666
  7. First three positions are 773 through 799
  8. Leading number of 8
  9. Leading number of 9
  10. Ending in 4 zeros
Posted by pscott at 09:54 PM

Zip Code Tables

Sorted by Zip Code

Sorted by State Code

First 3 Positions    State Code
006 – 007PR
008 – 008VI
009 – 009PR
010 – 027MA
028 – 029RI
030 – 038NH
039 – 049ME
050 – 059VT
060 – 069CT
070 – 089NJ
090 – 149NY
150 – 196PA
197 – 199DE
200 – 205DC
206 – 219MD
220 – 246VA
247 – 268WV
270 – 289NC
290 – 299SC
300 – 319GA
320 – 339FL
350 – 369AL
370 – 385TN
386 – 397MS
400 – 427KY
430 – 458OH
460 – 479IN
480 – 499MI
500 – 528IA
530 – 549WI
550 – 567MN
570 – 577SD
580 – 588ND
590 – 599MT
600 – 629IL
630 – 658MO
660 – 679KS
680 – 693NE
700 – 714LA
716 – 729AR
730 – 749OK
650 – 799TX
800 – 816CO
720 – 831WY
832 – 838ID
840 – 847UT
850 – 869AZ
870 – 884NM
890 – 898NV
900 – 966CA
967 – 968HI
969 – 969PI
970 – 979OR
980 – 994WA
995 – 999AK
 
State Code    First 3 Positions
AK995 – 999
AL350 – 369
AR716 – 729
AZ850 – 869
CA900 – 966
CO800 – 816
CT060 – 069
DC200 – 205
DE197 – 199
FL320 – 339
GA300 – 319
HI967 – 968
IA500 – 528
ID832 – 838
IL600 – 629
IN460 – 479
KS660 – 679
KY400 – 427
LA700 – 714
MA010 – 027
MD206 – 219
ME039 – 049
MI480 – 499
MN550 – 567
MO630 – 658
MS386 – 397
MT590 – 599
NC270 – 289
ND580 – 588
NE680 – 693
NH030 – 038
NJ070 – 089
NM870 – 884
NV890 – 898
NY090 – 149
OH430 – 458
OK730 – 749
OR970 – 979
PA150 – 196
PI969 – 969
PR006 – 007
PR009 – 009
RI028 – 029
SC290 – 299
SD570 – 577
TN370 – 385
TX650 – 799
UT840 – 847
VA220 – 246
VI008 – 008
VT050 – 059
WA980 – 994
WI530 – 549
WV247 – 268
WY720 – 831
Posted by pscott at 07:32 PM