[ { "database": "cdeschools", "table": "", "sql": "", "col_names": null, "questions": [ "1. What percentage of schools served by CDS had an enrollment of 12 or more in SAT scores? ", "2. How does the average SAT score in reading vary by county? ", "3. What is the difference in the average SAT scores for math between charter and non-charter schools? ", "4. What district has the highest average SAT score for writing? ", "5. How does the percent of students who score at least 1500 in math vary by county? ", "6. What district has the highest enrollment of students ages 5-17 eligible for FRPM? ", "7. How has the percent of students eligible for free meals (ages 5 -17) changed between 2012-2013 and 2013-2014? ", "8. What is the difference in the average SAT scores for reading between charter and non-charter schools? ", "9. What is the average SAT score in reading for each district? ", "10. How does the number of students taking SAT tests vary by county? ", "11. What percentage of schools in California had an enrollment of 12 or more in SAT scores? ", "12. What is the average SAT score in writing for each county? ", "13. How does the average SAT score in writing vary by district? ", "14. What percentage of students in California scored at least 1500 in math? ", "15. What is the difference in the average SAT scores for math between districts in the same county? ", "16. How does the percent of students eligible for FRPM (ages 5 -17) vary by district? ", "17. Which CDSC school has the highest enrollment of students ages 5-17 eligible for FRPM? ", "18. How does the number of students taking SAT tests vary by county type? ", "19. What is the difference in the average SAT scores for writing between charter and non-charter schools? ", "20. How has the percent of students eligible for free meals (ages 5-17) changed between 2012-2013 and 2013-2014 for each county? ", "21. What is the average SAT score in math for each school? ", "22. What is the difference in the number of students taking SAT tests between charter and non-charter schools? ", "23. What is the percentage change in the percent of students eligible for FRPM (ages 5 -17) between 2012-2013 and 2013-2014? ", "24. How does the number of students scoring at least 1500 in math vary by district? ", "25. How does the percent of students eligible for free meals (ages 5-17) vary by county type? ", "26. What is the difference in the average SAT scores for math between states? ", "27. What is the average SAT score in writing for each school? ", "28. How has the average SAT score in reading changed between 2012-2013 and 2013-2014? ", "29. What percentage of schools had an Educational Option Type in California? ", "30. What is the difference in the average SAT scores for reading between states?" ] }, { "database": "dallas_ois", "table": "", "sql": "", "col_names": null, "questions": [ "1. How often do OIS incidents involving multiple subjects occur? ", "2. What was the highest number of officers listed in a single OIS incident? ", "3. What percentage of OIS incidents resulted in a grand jury disposition? ", "4. What was the most common subject race of OIS incidents?", "5. What was the most common officer race of OIS incidents?", "6. What percent of subjects were armed with a weapon in OIS incidents?", "7. How many OIS incidents are missing summary text?", "8. Does the latitude and longitude clearly indicate the location of an OIS incident?", "9. Is there any correlation between OIS incidents and the gender of officers or subjects?", "10. Are there any trends in date or location of OIS incidents?", "11. How often do OIS incidents result in an attorney general FORM?", "12. Is there a correlation between the amount of officers involved in an incident and the grand jury outcome?", "13. Are there any geographical trends in OIS incidents?", "14. Is there any correlation between the gender of the subjects and the officers involved in OIS incidents? ", "15. Is there any difference in the percentage of subjects being armed between different races? ", "16. What is the distribution of OIS incidents based on the month and year? ", "17. What is the likelihood of an OIS incident involving multiple officers? ", "18. How often does an OIS incident result in a summary URL?", "19. Are there any trends between the length of an OIS summary text and its outcome? ", "20. How often do OIS incidents result in attorney general forms?", "21. Does the amount of officers present in an OIS incident correlate with the likelihood of the officer being injured or killed?", "22. How often do OIS incidents involve a subject and no officers?", "23. Is there any correlation between the Officer/Subject race and the Grand Jury Disposition?", "24. How often do OIS incidents occur in the same geographical area?", "25. Does the amount of officers present in an incident increase the likelihood that a subject is armed with a weapon?", "26. Does the race of an officer affect their likelihood of being injured or killed in an OIS incident? ", "27. What are the chances of an OIS incident having a summary URL attached to it?", "28. Is there any correlation between the OIS incident location and summary text?", "29. Does the amount of subjects involved in OIS incidents vary with the location?", "30. Does the number of officers involved in an incident influence the outcome of the Grand Jury Disposition?" ] }, { "database": "acs_1_year_2015", "table": "", "sql": "", "col_names": null, "questions": [ "1. What is the median household income for each state in 2015?", "2. What is the percentage of foreign-born populations in each place in 2015?", "3. What place has the highest number of people in the other_race category in 2015?", "4. How many states have a median age below the national average?", "5. What congressional districts have the highest median household incomes in 2015?", "6. What was the median value of owner-occupied homes in each state in 2015?", "7. What state has the highest per capita income in 2015?", "8. What is the ratio of black to white population for each congressional district in 2015?", "9. What are the poverty rates for each place in 2015?", "10. What is the difference in median household income between different states in 2015?", "11. What percentage of people in each state identifies as American Indian in 2015?", "12. What is the difference in median age between cities and towns in 2015?", "13. What are the median incomes in each congressional district compared to their respective states in 2015?", "14. How has the foreign-born population in each county changed from 2014 to 2015?", "15. How does total population in each state compare to that of the nation in 2015?", "16. Are there any congressional districts where the Asian population outnumbers the white population in 2015?", "17. What are the poverty rates among Pacific Islanders in each state in 2015? ", "18. What is the ratio of owner-occupied homes to total households in each place in 2015?", "19. How does the median household income vary among different cities and counties in 2015?", "20. What is the percentage of owner-occupied homes that have a median value above the national average in 2015?", "21. Are there any states that have a higher poverty rate than the national average in 2015?", "22. What is the difference in median age between whites, blacks, Hispanics, and Asians in 2015?", "23. How does median household income compare between states, congressional districts, and places in 2015?", "24. What is the difference in per capita income between states, congressional districts, and places in 2015?", "25. How has the percentage of owner-occupied homes changed in each place from 2014 to 2015?", "26. What congressional district has the highest percentage of people below the poverty line in 2015?", "27. What is the difference in median household income between states, congressional districts, and places within each state in 2015?", "28. What are the median incomes for people in each race category in 2015?", "29. How does the percentage of people identifying as American Indian vary between states and congressional districts in 2015?", "30. How does the median value of owner-occupied homes compare between cities, towns, and counties in 2015?" ] }, { "database": "sfscores", "table": "", "sql": "", "col_names": null, "questions": [ "1. How many unique businesses are present in the sfscores.businesses table?", "2. What is the average score of the businesses in the sfscores.inspections table? ", "3. What is the maximum score in the sfscores.inspections table?", "4. What is the most common violation type in the sfscores.violations table?", "5. What is the percentage of businesses with a TaxCode in the sfscores.businesses table?", "6. What is the number of businesses that have a business_certificate in the sfscores.businesses table?", "7. Of the businesses located in San Francisco, what is the number of businesses that have an owner from a different city?", "8. What is the median score of the businesses in the sfscores.inspections table?", "9. What is the average score by risk category in the sfscores.violations table?", "10. What is the average number of inspections per business in the sfscores.inspections table?", "11. What is the most common type of inspection in the sfscores.inspections table?", "12. How many unique owner_states are found in the sfscores.businesses table?", "13. What is the percentage of businesses located in San Francisco with a business certificate?", "14. What is the maximum score given to any business in the sfscores.inspections table?", "15. What is the average number of violations per business in the sfscores.violations table?", "16. Which business_id has the highest number of inspections in the sfscores.inspections table?", "17. What is the percentage of businesses with a TaxCode from San Francisco in the sfscores.businesses table?", "18. Of the businesses in the sfscores.businesses table, what is the average number of violations per risk category?", "19. What is the average inspection score by risk category in the sfscores.inspections table?", "20. What is the most common zip code in the sfscores.businesses table?", "21. What is the average score of businesses in the sfscores.inspections table that have a TaxCode?", "22. In the sfscores.businesses table, how many businesses have owner_info from a different city?", "23. Which business_id has the highest number of violations in the sfscores.violations table?", "24. What is the percentage of businesses with a business certificate in the sfscores.businesses table?", "25. How many unique business_ids are present in the sfscores.violations table?", "26. What is the average violation score by risk category in the sfscores.violations table?", "27. In the sfscores.violations table, what is the most common ViolationTypeID?", "28. What is the maximum inspection score given to a business in the sfscores.inspections table?", "29. What is the average number of violations per business in the sfscores.violations table?", "30. What is the average number of violations per inspection type in the sfscores.violations table?" ] }, { "database": "thr_gendered_babynames", "table": "", "sql": "", "col_names": null, "questions": [ "1. What states had the highest total number of baby names in each year?", "2. How has the primary sex ratio changed over the years?", "3. What was the most popular first name in each state in each year?", "4. How many babies were given each name in the thr_power_list in each year?", "5. How did the occupation of the names in the thr_power_list evolve over the years?", "6. What was the most popular name in each state in each year overall?", "7. Which occupation had the most unique names from the thr_power_list in each year?", "8. What are the top 5 most common first names in each state?", "9. How many babies were named for individuals in the thr_power_list in each year?", "10. How has the percentage of people with a unique name in each state changed from year to year?", "11. How has the popularity of specific names in the thr_power_list evolved over the years?", "12. Which occupations had the highest primary sex ratio in each year?", "13. What were the most popular baby names in each state in each year?", "14. How has the number of babies named with names from the thr_power_list changed over the years?", "15. What were the top 5 most popular first names in each state overall?", "16. How many distinct names were given to babies in each state in each year?", "17. How has the proportion of babies given each name in the thr_power_list changed from year to year?", "18. What was the most popular last name in each state in each year?", "19. How did the company rankings of the names in the thr_power_list change by year?", "20. How many babies were named for individuals in each state for each year?", "21. What were the most common surnames in each state in each year?", "22. How has the ratio of male to female babies named with names from the thr_power_list changed over the years?", "23. How has the distribution of baby names in each state changed by year?", "24. How has the average age for each name in the thr_power_list changed by year?", "25. How have the total number of babies given each name in the thr_power_list changed from year to year?", "26. How have the percentages of babies in each state given each name in the thr_power_list changed from year to year?", "27. What has been the most common occupation for names in the thr_power_list in each year?", "28. What have been the most popular baby names in each state for each year, in terms of total babies given the name?", "29. How has the distribution of baby names in the thr_power_list changed by year?", "30. How has the percentage of babies given each name in the thr_power_list changed in each occupation in each year?" ] }, { "database": "simplefolks", "table": "", "sql": "", "col_names": null, "questions": [ "1. How many homes does an individual own?", "2. Who owns the most expensive home? ", "3. What is the average home value in a given area?", "4. How does the sex of an individual correlate with their home’s value?", "5. How many pets does an owner have?", "6. What is the most common type of pet owned?", "7. Are there any correlations between the age of an individual and the value of their home?", "8. How many inmates are currently in the prison system?", "9. When were most inmates sentenced?", "10. Who has served the longest sentence in the prison system?", "11. What is the average age of people with pets?", "12. Are Politicians more likely to be associated with a particular party or state?", "13. What is the average age of Politicians?", "14. Who has been in public office the longest?", "15. What is the average service end date for Politicians in the same position?", "16. How many people are currently in public office?", "17. What is the most common name in the homes table?", "18. What is the most common type of pet for people in certain age groups?", "19. How does the average home value vary in different areas?", "20. What is the average sentence length for inmates with a particular first name?", "21. How does the average value of a home correlate with the age of its owner?", "22. What is the average number of pets owned by individuals of a particular sex?", "23. Does the ownership of a pet correlate with the average age of inmates in the prison system?", "24. What is the average length of service for Politicians of a particular party? ", "25. What is the most common state for Politicians in a particular position?", "26. Is there any correlation between the last name of an individual and their home’s value?", "27. Are females more likely to own pets than males?", "28. What is the most common first name of Politicians?", "29. Are Politicians from certain states more likely to serve longer terms in public office?", "30. How does the inmate’s birth year correlate with their sentence length?" ] } ]