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.

  • cmnybo@discuss.tchncs.de
    link
    fedilink
    English
    arrow-up
    7
    ·
    edit-2
    21 days ago

    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.

    • purplemonkeymad@programming.dev
      link
      fedilink
      arrow-up
      1
      ·
      21 days ago

      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.

      • BigDanishGuy@sh.itjust.works
        link
        fedilink
        arrow-up
        0
        ·
        21 days ago

        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

        • PM_Your_Nudes_Please@lemmy.world
          link
          fedilink
          arrow-up
          1
          ·
          16 days ago

          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…

      • foggy@lemmy.world
        link
        fedilink
        arrow-up
        0
        ·
        21 days ago

        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.

        • yoevli@lemmy.world
          link
          fedilink
          English
          arrow-up
          2
          ·
          21 days ago

          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.

            • 11111one11111@lemmy.world
              link
              fedilink
              arrow-up
              0
              arrow-down
              1
              ·
              20 days ago

              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?

              • homicidalrobot@lemm.ee
                link
                fedilink
                arrow-up
                1
                ·
                20 days ago

                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

                • 11111one11111@lemmy.world
                  link
                  fedilink
                  arrow-up
                  0
                  arrow-down
                  1
                  ·
                  20 days ago

                  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.

    • rbn@sopuli.xyz
      link
      fedilink
      arrow-up
      1
      ·
      21 days ago

      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.

      • Piafraus@lemmy.world
        link
        fedilink
        arrow-up
        0
        ·
        edit-2
        21 days ago

        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.

        • rbn@sopuli.xyz
          link
          fedilink
          arrow-up
          1
          ·
          edit-2
          21 days ago

          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.

      • palordrolap@fedia.io
        link
        fedilink
        arrow-up
        0
        ·
        21 days ago

        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.

          • PM_Your_Nudes_Please@lemmy.world
            link
            fedilink
            arrow-up
            1
            ·
            edit-2
            16 days ago

            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.

  • bokherif@lemmy.world
    link
    fedilink
    arrow-up
    0
    ·
    21 days ago

    Considering there are around 330M citizens right now, I think they ran out already and they’re probably recycling them.

    • Th4tGuyII@fedia.io
      link
      fedilink
      arrow-up
      0
      ·
      21 days ago

      You could be right about them recycling numbers already, but 330 million < 999 million, so that wouldn’t be why

      • bokherif@lemmy.world
        link
        fedilink
        arrow-up
        1
        ·
        21 days ago

        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.

    • BigDanishGuy@sh.itjust.works
      link
      fedilink
      arrow-up
      0
      ·
      edit-2
      21 days ago

      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.

      • bokherif@lemmy.world
        link
        fedilink
        arrow-up
        1
        ·
        21 days ago

        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.

      • paddirn@lemmy.world
        link
        fedilink
        English
        arrow-up
        0
        ·
        edit-2
        21 days ago

        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.

        • BigDanishGuy@sh.itjust.works
          link
          fedilink
          arrow-up
          0
          ·
          21 days ago

          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.

              • BigDanishGuy@sh.itjust.works
                link
                fedilink
                arrow-up
                1
                ·
                edit-2
                17 days ago

                Meh, why do today what you can put off until it’s someone else’s problem?

                It’s not even like you leave for future you, that guy hates you already^1 you leave it for someone entirely unknown. They won’t even know who to blame.

                ^1 Shayne Smith banned from karate reference.

                Bummer, superscript doesn’t work in any client, does it work for anybody else? Come to think about it, how stupid am I, I’ve used ^ extensively in this fucking thread smh

  • dQw4w9WgXcQ@lemm.ee
    link
    fedilink
    arrow-up
    0
    ·
    21 days ago

    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.