Announcement

Collapse
No announcement yet.

usa surnames from usa census

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • usa surnames from usa census

    last name listing from usa census
    Attached Files
    Last edited by Paul Purvis; 17 May 2018, 02:01 AM.
    p purvis

  • #2
    new the listing is built twice and verified twice
    Last edited by Paul Purvis; 17 May 2018, 04:10 AM.
    p purvis

    Comment


    • #3
      151671 names! (Frequency might be interesting?)
      Rgds, Dave

      Comment


      • #4
        Dave. Yes. There is more that could be of use but just visually over looking the names. Th frequency of the first 3 characters in names might give you some clue
        p purvis

        Comment


        • #5
          https://www.census.gov/topics/popula..._surnames.html

          https://www.ssa.gov/oact/babynames/limits.html
          p purvis

          Comment


          • #6
            Thanks for those lists - perfect timing.

            I've currently working on a new project and I needed some test company and personnel data. I reduced the firstname and last name lists to unique names and grabbed a list of company names from here:
            https://www.sec.gov/divisions/corpfi.../alpha2001.htm

            With liberal use of Rnd on the three tables, I quickly build a list of several hundred employee/company records. I also populated other fields such as date of birth, drivers licence number, place of origin etc as well with more Rnds() and a few geodata tables that I already had)
            --
            [URL="http://www.camcopng.com"]CAMCo - Applications Development & ICT Consultancy[/URL][URL="http://www.hostingpng.com"]
            PNG Domain Hosting[/URL]

            Comment


            • #7
              151671 names! (Frequency might be interesting?) [bold mine MCM}
              Ask and you shall receive! Use this code here...


              Count unique keys and occurrences thereof in sequential file 8-21-2006
              SOURCE THREAD (new BBS) : https://forum.powerbasic.com/forum/u...rray-in-memory


              MCM
              Michael Mattias
              Tal Systems Inc.
              Racine WI USA
              mmattias@talsystems.com
              http://www.talsystems.com

              Comment


              • #8
                i have never shared a google drive and really never even started with till a few weeks ago.
                it names since to me to put these large files there now rather than having my host these files.
                I put the link to the google drive where the files are located in this zip file to keep it from the public.
                I am uploading files now. There will be a-z files plus a last name. I have not extracted first names to make a first name yet.
                Attached Files
                p purvis

                Comment


                • #9
                  Dave. Here you go fella. Found it.
                  https://names.mongabay.com/most_common_surnames.htm
                  I have a good reason for names. You know it is best to have people double put names in twice to confirm no misspelling in data input.
                  I have seen even numbers placed in names.
                  Did you see the last name "AA". Makes you wonder on validity of data doesn't it.
                  Here is also some knowledge and entertainment.
                  https://m.youtube.com/watch?v=p7THJoRYA2c
                  p purvis

                  Comment


                  • #10
                    Thanks Paul,

                    BTW I see..
                    Surname, Rank, Estimated Number, %per 100,000
                    BIGGS 1448 22634 8.39
                    PURVIS 2028 16381 6.07
                    Guess that makes me more common
                    Rgds, Dave

                    Comment


                    • #11
                      Dave, I think you mean # per 100,000.
                      Rod
                      "To every unsung hero in the universe
                      To those who roam the skies and those who roam the earth
                      To all good men of reason may they never thirst " - from "Heaven Help the Devil" by G. Lightfoot

                      Comment


                      • #12
                        Dave. My mother was a Bigner. So I guess we are kin somewhere down the road. She liked to sing Irish songs she learn from her mama which she was a Lot.
                        p purvis

                        Comment

                        Working...
                        X