The BabbyNames Sample Database – Now on GitHub

1960 was the most popular year to name your baby ‘Dino’, with 386 Dinos born.

I love playing around with the free data that the Social Security Administration publishes on baby names each year.

It’s fun to manipulate the dataset in a variety of ways, and you learn odd things along the way… like the fact that more than 7,000 babies in the US have been named ‘Kale’ since 1917.

I’ve got more facts about Kale than you knew you wanted

The most popular year to be named Kale was 2008 (567 kales), which predates the time when the vegetable became super popular by at least a few years. More kale on your plate doesn’t mean you want to raise a ‘Kale’: there were only 175 Kales named in 2015.

Are those Kale Babies girls, or are they boys?

If you want to know, you’re going to have to download the BabbyNames database yourself– or grab the scripts and source data and build it.

It’s easy to download

It’s all free over on GitHub.

No login required, no nothin’.

“Why would I want this?”

Even if you don’t have a natural curiosity about babies named after vegetables, it can be fun to play around with different data sources to test queries and features. Not that I don’t love Microsoft’s WideWorldImporters, I just sometimes want something a little different.

“Why is it named BabbyNames?”

There are at least two lame jokes related to the name:

  • You’ve heard of Little Bobby Tables? This is Little Babby Tables.
  • An internet meme famously asked the question, “How is Babby Formed?” This database answers the question, “How is Babby Named?”

But I like the name because I find the word “Babby” to be funny, all by itself.

Enjoy!

6 Responses to The BabbyNames Sample Database – Now on GitHub

  1. Jeff February 28, 2017 at 8:47 am #

    Man, talk about going down the rabbit hole! There goes my afternoon.

    I had no idea somebody would name their kid Knowledge…..but in fact 761 of them did.

    Thanks for the data set!

  2. Roy February 28, 2017 at 9:30 am #

    Is it possible to have the database in SQL 2014 or even SQL 2012 compatibility level? I understand this database may be use for demo on SQL 2016 SP1 Standard edition. But I guess most of us are still on Windows 7 and can’t install SQL 2016 yet.

    • Kendra Little February 28, 2017 at 10:46 am #

      You can have the database on lower versions already! Just download the source and run CreateBabbyNames.sql per the instructions at the top.

      But if you’re serious about SQL Server, you really should have *someplace* where you can run a dev edition of 2016, though. This isn’t true for every SQL Server version, but 2016 has enough new features in it that it’s something you really want to be able to kick around now and get to know them, even if it’s probably going to be a bit of time before you run it in production.

  3. Kyle March 1, 2017 at 11:43 am #

    I actually personally know a Kale, (guy)…

    • Kendra Little March 2, 2017 at 12:01 pm #

      Wow! I think this means I have a second level connection to a real world Kale. Awesome.

  4. Sandra March 4, 2017 at 1:47 pm #

    I built the database using your script — one small suggestion: although it’s easy enough to figure out where to extract namesbystate.zip, it would be nice to include it in the instructions, right below your instructions for names.zip. “Extract all files from namesbystate.zip into C:\BabbyNamesImport.”

    In scanning least popular names, it looks like spell-check would help. Rbecca and Barbaraa would have benefited. I was surprised to see that there are some naming restrictions in the U.S., and it’s interesting to see what the laws are in other countries. https://en.wikipedia.org/wiki/Naming_law

Leave a Reply