task_categories:text-classification language:en license:apache-2.0 size_categories:n<1K region:us
---
license: apache-2.0
task_categories:
- text-classification
language:
- en
size_categories:
- n<1K
---
Input tables

bigquery-public-data.usa_names.usa_1910_2013
bigquery-public-data.samples.natality


To Do
Is the last letter of the Name a good proxy for Gender? [20 min]
Gender Mix development across years in USA. what is the year with the highest % of Female names from 1920 until now?
Is there any peculiar development you may notice when looking at the share of Female Vs Male names? [50 min]
What was the 4th most common male name in the 60´s ?  [15 min]



Schema of table: bigquery-public-data.usa_names.usa_1910_2013


[
  {
    "name": "state",
    "mode": "NULLABLE",
    "type": "STRING",
    "description": "2-digit state code",
    "fields": []
  },
  {
    "name": "gender",
    "mode": "NULLABLE",
    "type": "STRING",
    "description": "Sex (M=male or F=female)",
    "fields": []
  },
  {
    "name": "year",
    "mode": "NULLABLE",
    "type": "INTEGER",
    "description": "4-digit year of birth",
    "fields": []
  },
  {
    "name": "name",
    "mode": "NULLABLE",
    "type": "STRING",
    "description": "Given name of a person at birth",
    "fields": []
  },
  {
    "name": "number",
    "mode": "NULLABLE",
    "type": "INTEGER",
    "description": "Number of occurrences of the name",
    "fields": []
  }
]






Schema of Table: bigquery-public-data.samples.natality

[
  {
    "name": "source_year",
    "mode": "REQUIRED",
    "type": "INTEGER",
    "description": "Four-digit year of the birth. Example: 1975.",
    "fields": []
  },
  {
    "name": "year",
    "mode": "NULLABLE",
    "type": "INTEGER",
    "description": "Four-digit year of the birth. Example: 1975.",
    "fields": []
  },
  {
    "name": "month",
    "mode": "NULLABLE",
    "type": "INTEGER",
    "description": "Month index of the date of birth, where 1=January.",
    "fields": []
  },
  {
    "name": "day",
    "mode": "NULLABLE",
    "type": "INTEGER",
    "description": "Day of birth, starting from 1.",
    "fields": []
  },
  {
    "name": "wday",
    "mode": "NULLABLE",
    "type": "INTEGER",
    "description": "Day of the week, where 1 is Sunday and 7 is Saturday.",
    "fields": []
  },
  {
    "name": "state",
    "mode": "NULLABLE",
    "type": "STRING",
    "description": "The two character postal code for the state. Entries after 2004 do not include this value.",
    "fields": []
  },
  {
    "name": "is_male",
    "mode": "REQUIRED",
    "type": "BOOLEAN",
    "description": "TRUE if the child is male, FALSE if female.",
    "fields": []
  },
  {
    "name": "child_race",
    "mode": "NULLABLE",
    "type": "INTEGER",
    "description": "The race of the child. One of the following numbers:\n\n1 - White\n2 - Black\n3 - American Indian\n4 - Chinese\n5 - Japanese\n6 - Hawaiian\n7 - Filipino\n9 - Unknown/Other\n18 - Asian Indian\n28 - Korean\n39 - Samoan\n48 - Vietnamese",
    "fields": []
  },
  {
    "name": "weight_pounds",
    "mode": "NULLABLE",
    "type": "FLOAT",
    "description": "Weight of the child, in pounds.",
    "fields": []
  },
  {
    "name": "plurality",
    "mode": "NULLABLE",
    "type": "INTEGER",
    "description": "How many children were born as a result of this pregnancy. twins=2, triplets=3, and so on.",
    "fields": []
  },
  {
    "name": "apgar_1min",
    "mode": "NULLABLE",
    "type": "INTEGER",
    "description": "Apgar scores measure the health of a newborn child on a scale from 0-10. Value after 1 minute. Available from 1978-2002.",
    "fields": []
  },
  {
    "name": "apgar_5min",
    "mode": "NULLABLE",
    "type": "INTEGER",
    "description": "Apgar scores measure the health of a newborn child on a scale from 0-10. Value after 5 minutes. Available from 1978-2002.",
    "fields": []
  },
  {
    "name": "mother_residence_state",
    "mode": "NULLABLE",
    "type": "STRING",
    "description": "The two-letter postal code of the mother's state of residence when the child was born.",
    "fields": []
  },
  {
    "name": "mother_race",
    "mode": "NULLABLE",
    "type": "INTEGER",
    "description": "Race of the mother. Same values as child_race.",
    "fields": []
  },
  {
    "name": "mother_age",
    "mode": "NULLABLE",
    "type": "INTEGER",
    "description": "Reported age of the mother when giving birth.",
    "fields": []
  },
  {
    "name": "gestation_weeks",
    "mode": "NULLABLE",
    "type": "INTEGER",
    "description": "The number of weeks of the pregnancy.",
    "fields": []
  },
  {
    "name": "lmp",
    "mode": "NULLABLE",
    "type": "STRING",
    "description": "Date of the last menstrual period in the format MMDDYYYY. Unknown values are recorded as \"99\" or \"9999\".",
    "fields": []
  },
  {
    "name": "mother_married",
    "mode": "NULLABLE",
    "type": "BOOLEAN",
    "description": "True if the mother was married when she gave birth.",
    "fields": []
  },
  {
    "name": "mother_birth_state",
    "mode": "NULLABLE",
    "type": "STRING",
    "description": "The two-letter postal code of the mother's birth state.",
    "fields": []
  },
  {
    "name": "cigarette_use",
    "mode": "NULLABLE",
    "type": "BOOLEAN",
    "description": "True if the mother smoked cigarettes. Available starting 2003.",
    "fields": []
  },
  {
    "name": "cigarettes_per_day",
    "mode": "NULLABLE",
    "type": "INTEGER",
    "description": "Number of cigarettes smoked by the mother per day. Available starting 2003.",
    "fields": []
  },
  {
    "name": "alcohol_use",
    "mode": "NULLABLE",
    "type": "BOOLEAN",
    "description": "True if the mother used alcohol. Available starting 1989.",
    "fields": []
  },
  {
    "name": "drinks_per_week",
    "mode": "NULLABLE",
    "type": "INTEGER",
    "description": "Number of drinks per week consumed by the mother. Available starting 1989.",
    "fields": []
  },
  {
    "name": "weight_gain_pounds",
    "mode": "NULLABLE",
    "type": "INTEGER",
    "description": "Number of pounds gained by the mother during pregnancy.",
    "fields": []
  },
  {
    "name": "born_alive_alive",
    "mode": "NULLABLE",
    "type": "INTEGER",
    "description": "Number of children previously born to the mother who are now living.",
    "fields": []
  },
  {
    "name": "born_alive_dead",
    "mode": "NULLABLE",
    "type": "INTEGER",
    "description": "Number of children previously born to the mother who are now dead.",
    "fields": []
  },
  {
    "name": "born_dead",
    "mode": "NULLABLE",
    "type": "INTEGER",
    "description": "Number of children who were born dead (i.e. miscarriages)",
    "fields": []
  },
  {
    "name": "ever_born",
    "mode": "NULLABLE",
    "type": "INTEGER",
    "description": "Total number of children to whom the woman has ever given birth (includes the current birth).",
    "fields": []
  },
  {
    "name": "father_race",
    "mode": "NULLABLE",
    "type": "INTEGER",
    "description": "Race of the father. Same values as child_race.",
    "fields": []
  },
  {
    "name": "father_age",
    "mode": "NULLABLE",
    "type": "INTEGER",
    "description": "Age of the father when the child was born.",
    "fields": []
  },
  {
    "name": "record_weight",
    "mode": "NULLABLE",
    "type": "INTEGER",
    "description": "1 or 2, where 1 is a row from a full-reporting area, and 2 is a row from a 50% sample area.",
    "fields": []
  }
]