Baby Names from US Gov

Provides access to the Social Security Administration's national baby names data in a database-optimized structure.

This data is provided for all names used in the United States since 1880. Names must be used at least 5 times in a year to be included. See the readme file included in the names data download for more information about this data.

This module is only intended to provide the count data so you can query it and then display in custom ways. It does not provide any front-end or node/entity integration.

Schema

baby_names_usgov_names
Currently is 99,070 rows and ~14MB in size.

• bnid - The primary identifier for a name.
• name - The baby name.
• gender - Character indicating which gender (F/M).

baby_names_usgov_counts
Currently is 1,859,283 rows and ~59MB in size.

• bnid - The primary identifier for a name.
• year - The year this count is from.
• count - The number of people with this name.

baby_names_usgov_totals
One row for each year of data (136 currently) and negligible size. This table is used to enable per-capita-type calculations inside the DB queries.

• year - The year this total is from.
• total - The number of people.

Functions
baby_names_usgov_counts_get($name, $gender = NULL)
Return all count data for a name (and optionally a gender).

baby_names_usgov_name_id_get($name, $gender)
Return a Baby Name ID (bnid) when provided a name and gender.

This module does take around 2 minutes to insert the almost 2 million rows when it is enabled. This is highly optimized, but still should be expected that there will be a delay after you enable the module.

Built and maintained by the Parents.com team for our Baby Names site section. Photo courtesy of here :)