Thursday, October 27, 2016

Girls Named Richard, Boys Named Sue

Google's BigQuery tool includes a public data set (usa_names.usa in the query below) that contains 5,552,452 first names gleaned from U.S. Social Security applications between 1910 and 2013. Querying that data shows that some women are named using traditionally male names like "Richard", the top years shown below. Perhaps Johnny Cash would not be surprised that ten baby boys have been named "Sue". Sigh ... what were they thinking?

SELECT name, gender, year, count(*) as popular
FROM [bigquery-public-data:usa_names.usa_1910_2013] 
WHERE NAME = 'Richard' AND gender = 'F'
GROUP BY name, gender, year
ORDER BY popular DESC



No comments:

Post a Comment