More data!

[alex-sun-kuo]

Starting a discussion around datasets people want to see. We currently only have the following tables/columns:

crime_by_city

• city (TEXT)
• violent_crime (DOUBLE_PRECISION)
• murder_and_nonnegligent_manslaughter (DOUBLE_PRECISION)
• rape (DOUBLE_PRECISION)
• robbery (DOUBLE_PRECISION)
• aggravated_assault (DOUBLE_PRECISION)
• property_crime (DOUBLE_PRECISION)
• burglary (DOUBLE_PRECISION)
• larceny_theft (DOUBLE_PRECISION)
• motor_vehicle_theft (DOUBLE_PRECISION)
• arson (DOUBLE_PRECISION), state (TEXT)

acs_census_data

• zip_code (TEXT)
• city (TEXT)
• state (TEXT)
• county (TEXT)
• lat (DOUBLE_PRECISION)
• lon (DOUBLE_PRECISION)
• total_population (DOUBLE_PRECISION)
• elderly_population (DOUBLE_PRECISION)
• male_population (DOUBLE_PRECISION)
• female_population (DOUBLE_PRECISION)
• white_population (DOUBLE_PRECISION)
• black_population (DOUBLE_PRECISION)
• native_american_population (DOUBLE_PRECISION)
• asian_population (DOUBLE_PRECISION)
• two_or_more_population (DOUBLE_PRECISION)
• hispanic_population (DOUBLE_PRECISION)
• adult_population (DOUBLE_PRECISION)
• citizen_adult_population (DOUBLE_PRECISION)
• average_household_size (DOUBLE_PRECISION)
• pop_under_5_years (DOUBLE_PRECISION)
• pop_5_to_9_years (DOUBLE_PRECISION)
• pop_10_to_14_years (DOUBLE_PRECISION)
• pop_15_to_19_years (DOUBLE_PRECISION)
• pop_20_to_24_years (DOUBLE_PRECISION)
• pop_25_to_34_years (DOUBLE_PRECISION)
• pop_35_to_44_years (DOUBLE_PRECISION)
• pop_45_to_54_years (DOUBLE_PRECISION)
• pop_55_to_59_years (DOUBLE_PRECISION)
• pop_60_to_64_years (DOUBLE_PRECISION)
• pop_65_to_74_years (DOUBLE_PRECISION)
• pop_75_to_84_years (DOUBLE_PRECISION)
• pop_85_years_and_over (DOUBLE_PRECISION)
• per_capita_income (DOUBLE_PRECISION)
• median_income_for_workers (DOUBLE_PRECISION)