SSN numbers are good for 999,999,999 people alive or dead. At some point the US will hit that, right? Do we start reusing numbers? Sounds like a disaster waiting to happen.
Just add another digit and watch the entire country break down because they can’t find someone to update their 40+ year old software written in COBOL.
Sorry we can’t employ you as your ssn is too long. Also we can’t have any new employees called Mike Smith as the HR system already has someone with that name.
The LMS we use at my school can’t handle multiple students with the same name. So we have John Smith and John Smith-2. We have like 2000 new students each year, and we have recently transitioned to this LMS. Smh
In this two thousand and twenty fourth year of our lord, there are still people using databases that don’t automatically append a unique number to entries to avoid this exact scenario…
Social Security numbers are not unique identifiers.
Really?
Nope.
If you got your social Security number before 2011, your first three digits represent the geographical location you were born in. You share those three digits with each of your siblings who were born in the same geographical location before in 2011. Go ahead and ask them.
If memory serves, and all we would really need to do is check a Wikipedia article, the middle two digits were done in some weird sequence, and then the last four were pseudo-random.
So basically, any people receiving their social security number any multiple of 100 people apart from another (prior to 2011) in the same geographic location have a 1 in 10,000 chance of having identical social security numbers.
Basically, if you live in a large city, you definitely have a few twinsies out there.
This was changed in 2011, because of this, but it is still not a unique identifier. It’s just more random.
This generally isn’t true. The SSA makes an effort to assign a unique number to each individual. It’s happened before where two people have accidentally gotten the same SSN, but they try to avoid this.
An ID analytics study showed 40 million united states SSN had more than one name associated with them over a decade ago.
Whitepaper from LexisNexis, corporate background check company, explaining avout SSN not being a unique or even really reliable identifier
That white paper was very uninformative lol. I see now rereading your comment that its wasnt meant to support your 40 mil claim. So I googled varius combinations of ID analytics, ssn, studies, and 40 million but couldn’t find anything. I’m not that interested, I just wanted to read it tonsee if my gut feeling was correct. The funny thing is the white paper kinda outlined my gut feeling, that the 40 million count is wildly inaccurate demonstration of duplicate ssn’s being issued. Rather I felt it was more of an indication of the rampant problem this country has with the amount of stolen identities that happen each year.
Do you have any direction you could point me in to read more about this douplicate ssn problem?
Idk dude, just googled “id analytics ssn” and I immediately get a page of results of articles from 2012-15. Could probably just add “as someone else” in scholar for the paper
I guess i shouldve just asked where you pulled the 40 million from? Lol cuz that would mean 15% of the US is sharing ssn’s and that seems super high.
Does it even have that many permutations when the first 3 and middle 2 are coded to actually mean something?
Considering there are around 330M citizens right now, I think they ran out already and they’re probably recycling them.
You could be right about them recycling numbers already, but 330 million < 999 million, so that wouldn’t be why
Well, if only one generation passed away, that already puts us at 660M lol. Then there’s immigration, temporary issued SSNs based on work visas (huge numbers here btw) and so on.
The first SSNs were issued in 1936 https://en.wikipedia.org/wiki/Social_Security_number
According to the death master file entry in wiki 111x10^6 SSNs died between 1962 and 2018. https://en.wikipedia.org/wiki/Death_Master_File
That’s 1.982 x 10^6 x deaths x year^-1. Assume that number to be a constant during the period 1936-2024
1.982 x 10^6 x deaths x year^-1 x (2024-1936) x year = 174.4 x 10^6 deaths
According to https://en.wikipedia.org/wiki/Demographics_of_the_United_States there’s 335.9 x 10^6 residents, but I can’t tell if they are citizens with SSNs, but I’m going to assume that for now.
So (335.9 + 174.4) x 10^6 is 510.3 x 10^6 spent SSNs.
According to the same demographics wiki article the birth rate is 11 births per 1000 population. Death rate is 10.4 deaths per 1000 population. Because I’m just doing back of the envelope estimation for fun, while trying to manage my hangover in the early afternoon, I’m not going to create an exponential function to describe population growth. Instead I’m going to only consider future the US population a constant and not consider the 200 x 10^3 annual net growth (it only affects the next year’s growth by 120 anyway)
With all of that BS out of the way, at the present birthrate the US requires 3.695 x 10^6 new SSNs annually. The total amount SSNs in the current scheme is (10^9) - 1. I’m going to be leaving out the -1. 10^9 total SSNs - 510.3x^6 spent SSNs leaves 489.7 x 10^6 SSNs available. 489.7/3.695 is 132.5.
So in conclusion, assuming a constant population, the US can go for another 132.5 years with the present scheme without having to reuse any SSN.
How about dead SSNs between ‘36 and ‘62? Great work on the calculation but all I’m saying is, if the government ran out of numbers and recycled them already, nobody would know about it. The whole situation is ridiculous if you ask me and there’s no database of SSNs you can compare it to. Weirdly enough, official government departments straight up lie about things and easily get away with it heh.
SSN’s are also given out to immigrants as well though, so that’s a whole other population of people outside of just natural born citizens to account for. The US awards around one million green cards annually, though I don’t know what the historical numbers are.
SSN’s are also given out to immigrants as well though
Oh snap! Thanks for bringing that up. Adding another million each year, and assuming a constant green card rate since before WW2(!), adds another 88 million spent SSNs. With an additional million green cards annually, that makes the calculation (1000-510.3-88)x10^6 SSNs /4.695 x 10^6 SSNs/year = 85.6 years.
So the US has until about the end of the century to figure it out.
We could switch to hexadecimal digits and we’d be good for 68 billion.
Why stop at hex? You could use the entire alphabet. Even if you take only uppercase letters and numbers, we are at 36^9 possible numbers. If we include lowercase and special characters from ASCII, we can go much further.
It’s all fun and games until you’re assigned an SSN that contains a profanity. Because you know there’s a strong chance they’ll forget to implement a check for that until someone complains, and an even stronger chance that something that looks like a profanity will escape the first implementation of checks.
e.g. There will be someone assigned IMABUM123 and a) that will get through the understaffed / automated profanity check (no four letter words) and b) the person who gets it will have so many problems getting people to believe that it’s really their SSN, including the people who could assign them a new one.
You can actually get a new SSN already, if you have strong cultural or religious issues with your SSN https://faq.ssa.gov/en-us/Topic/article/KA-02220
So no need to implement a check in software, let the people do it for you.
The most common reason to get a new number is because you were the victim of identity theft. The gross part is that getting a new SSN doesn’t actually remove your old SSN. It just ties your new SSN to your old one; You can use either one interchangeably, because the new one just automatically routes back to the old one. This means there are now two numbers that can be used to steal your identity, instead of just one. And it doesn’t prevent the people who already have your old number from continuing to use it.
E. G. For storage and performs reasons. 5 bytes vs 9 bytes. Multiplying by amount of users and various indexes - can produce very noticeably difference. More records per page.
If we say that the SSN database internally only stores numbers today, but could also store hexadecimal values without significant redesigns, I would assume that SSNs are stored as text already. So no matter if you put numbers, hex or text, 9 places will always use 9 bytes (assuming it’s ASCII only and doesn’t support UTF-8 etc.).
Furthermore, the post implied that the current technical limit is 999,999,999. That very much sounds like a character data type to me. Otherwise, the limit is usually something like 2^x.
If SSNs are stored as numbers today, then hex and text would lead to quite some change. If you go for a re-design, you can as well just increase the length of the field.
Norawy is facing a similar issue. Even though the national identification number is 11 digits, the first 6 are reserved for birth date. The 7th digit has some set of rules derived from which century the birth was (something like 5-9 is reserved for year 2000 and beyond). The 9th digit is even for women and odd for men. The 10th and 11th digit are fixed and derived from the rest of the numbers.
In conclusion, the system only leaves room for around 240 people per date of birth per gender (yes this system assumes 2 genders). So if the birth rate would have a spike, even just for a day, the system could be in trouble.
Could embiggen it by a factor of 10 by removing the gender marker.
