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