Pittsburgh SNAP Census Data

CREATE TABLE built_environment_conditions_2010 (
  "neighborhood" VARCHAR,
  "sector" BIGINT  -- Sector #,
  "population_2010" BIGINT  -- Population (2010),
  "land_area_acres" DOUBLE  -- Land Area (acres),
  "approx_total_parcels_2010" BIGINT  -- Approx. Total # Parcels (2010),
  "approx_total_taxable_parcels_2010" BIGINT  -- Approx. Total # Taxable Parcels (2010),
  "approx_of_structures_2010" BIGINT  -- Approx. # Of Structures (2010),
  "approx_unoccupied_parcels_2010" BIGINT  -- Approx. # Unoccupied Parcels (2010),
  "n__good_excellent_condition_buildings_2009" VARCHAR  -- % Good / Excellent Condition Buildings (2009),
  "n__average_condition_buildings_2009" VARCHAR  -- % Average Condition Buildings (2009),
  "n__poor_derelict_condition_buildings_2009" VARCHAR  -- % Poor / Derelict Condition Buildings (2009),
  "n__residential_bldg_permits_2010" BIGINT  -- # Residential Bldg. Permits (2010),
  "n__residential_bldg_permits_2010_b2209c" VARCHAR  -- $ Residential Bldg. Permits (2010),
  "n__commercial_bldg_permits_2010" BIGINT  -- # Commercial Bldg. Permits (2010),
  "n__commercial_bldg_permits_2010_87c285" VARCHAR  -- $ Commercial Bldg. Permits (2010),
  "n__code_violations_2010" BIGINT  -- # Code Violations (2010),
  "n__of_all_bldgs_w_code_violations_2010" VARCHAR  -- % Of All Bldgs. W/ Code Violations (2010),
  "n__condemned_structures_2010" BIGINT  -- # Condemned Structures (2010),
  "n__of_all_bldgs_condemned_2010" VARCHAR  -- % Of All Bldgs. Condemned (2010),
  "n__demolitions_2010" BIGINT  -- # Demolitions (2010),
  "n__tax_delinquent_prop_2_yrs_2010" BIGINT  -- # Tax Delinquent Prop. (2+ Yrs.) (2010),
  "n__of_taxable_prop_delinquent_2010" VARCHAR  -- % Of Taxable Prop. Delinquent (2010)
);

CREATE TABLE education_income_2010 (
  "neighborhood" VARCHAR,
  "sector" BIGINT  -- Sector #,
  "population_2010" BIGINT  -- Population (2010),
  "total_pop_25_and_older_2010" BIGINT  -- Total Pop, 25 And Older (2010),
  "edu_attainment_less_than_high_school_2010" VARCHAR  -- Edu. Attainment: Less Than High School (2010),
  "edu_attainment_high_school_graduate_2010" VARCHAR  -- Edu. Attainment: High School Graduate (2010),
  "edu_attainment_assoc_prof_degree_2010" VARCHAR  -- Edu. Attainment: Assoc./Prof. Degree (2010),
  "edu_attainment_bachelor_s_degree_2010" VARCHAR  -- Edu. Attainment: Bachelor's Degree (2010),
  "edu_attainment_postgraduate_degree_2010" VARCHAR  -- Edu. Attainment: Postgraduate Degree (2010),
  "n_1999_median_income_99_dollars" VARCHAR  -- 1999 Median Income ('99 Dollars),
  "n_2009_median_income_09_dollars" VARCHAR  -- 2009 Median Income ('09 Dollars),
  "n_1999_median_income_11_dollars" VARCHAR  -- 1999 Median Income ('11 Dollars),
  "n_2009_med_income_13_dollars" VARCHAR  -- 2009 Med. Income ('13 Dollars),
  "est_pop_for_which_poverty_calc_2010" BIGINT  -- Est. Pop. For Which Poverty Calc. (2010),
  "est_pop_under_poverty_2010" BIGINT  -- Est. Pop. Under Poverty (2010),
  "est_percent_under_poverty_2010" VARCHAR  -- Est. Percent Under Poverty (2010)
);

CREATE TABLE employment_2010 (
  "neighborhood" VARCHAR,
  "sector" BIGINT  -- Sector #,
  "population_2010" BIGINT  -- Population (2010),
  "total_age_16_n_hood_residents_employed_2010_est" BIGINT  -- Total Age 16+ N'hood Residents Employed (2010 Est.),
  "resident_jobs_construction" VARCHAR  -- Resident Jobs: Construction,
  "resident_jobs_manufacturing" VARCHAR  -- Resident Jobs: Manufacturing,
  "resident_jobs_retail_trade" VARCHAR  -- Resident Jobs: Retail Trade,
  "resident_jobs_transportation_warehousing_utilities" VARCHAR  -- Resident Jobs: Transportation, Warehousing, Utilities,
  "resident_jobs_information" VARCHAR  -- Resident Jobs: Information,
  "resident_jobs_finance_insurance_real_estate" VARCHAR  -- Resident Jobs: Finance, Insurance, Real Estate,
  "resident_jobs_prof_scientific_admin_and_waste_mgmt" VARCHAR  -- Resident Jobs: Prof, Scientific, Admin, And Waste Mgmt,
  "resident_jobs_educ_health_and_social_svc" VARCHAR  -- Resident Jobs: Educ, Health And Social Svc,
  "resident_jobs_arts_ent_recreation_accommodation_and_fo_1e8aa87e" VARCHAR  -- Resident Jobs: Arts, Ent, Recreation, Accommodation And Food Services,
  "resident_jobs_public_admin" VARCHAR  -- Resident Jobs: Public Admin,
  "resident_jobs_other" VARCHAR  -- Resident Jobs: Other,
  "total_jobs_located_in_n_hood_2000_latest_yr_avail" BIGINT  -- Total # Jobs Located In N'hood (2000 - Latest Yr. Avail.),
  "jobs_in_hood_construction" VARCHAR  -- Jobs In 'Hood: Construction,
  "jobs_in_hood_manufacturing" VARCHAR  -- Jobs In 'Hood: Manufacturing,
  "jobs_in_hood_retail_trade" VARCHAR  -- Jobs In 'Hood: Retail Trade,
  "jobs_in_hood_transport_warehousing_utilities" VARCHAR  -- Jobs In 'Hood: Transport, Warehousing, Utilities,
  "jobs_in_hood_information" VARCHAR  -- Jobs In 'Hood: Information,
  "jobs_in_hood_finance_insurance_real_estate" VARCHAR  -- Jobs In 'Hood: Finance, Insurance, Real Estate,
  "jobs_in_hood_prof_scientific_admin_and_waste_mgmt" VARCHAR  -- Jobs In 'Hood: Prof, Scientific, Admin, And Waste Mgmt,
  "jobs_in_hood_educ_health_and_social_svc" VARCHAR  -- Jobs In 'Hood: Educ, Health, And Social Svc,
  "jobs_in_hood_arts_ent_recreation_accommodation_and_foo_674e4499" VARCHAR  -- Jobs In 'Hood: Arts, Ent, Recreation, Accommodation And Food Services,
  "jobs_in_hood_public_admin" VARCHAR  -- Jobs In 'Hood: Public Admin,
  "jobs_in_hood_other" VARCHAR  -- Jobs In 'Hood: Other
);

CREATE TABLE land_use_zoning_2010 (
  "neighborhood" VARCHAR,
  "sector" BIGINT  -- Sector #,
  "population_2010" BIGINT  -- Population (2010),
  "land_area_acres" DOUBLE  -- Land Area (acres),
  "residential" VARCHAR,
  "mixed_use_commercial" VARCHAR  -- Mixed Use / Commercial,
  "mixed_use_industrial" VARCHAR  -- Mixed Use / Industrial,
  "institutional_edu_med" VARCHAR  -- Institutional / Edu. / Med.,
  "open_space" VARCHAR,
  "hillside" VARCHAR,
  "special_land_use" VARCHAR
);

CREATE TABLE natural_environment_conditions_2010 (
  "neighborhood" VARCHAR,
  "sector" BIGINT  -- Sector #,
  "population_2010" BIGINT  -- Population (2010),
  "land_area_acres" DOUBLE  -- Land Area (acres),
  "landslide_prone_land_area" VARCHAR  -- Landslide Prone (% Land Area),
  "undermined_land_area" VARCHAR  -- Undermined (% Land Area),
  "flood_plain_land_area" VARCHAR  -- Flood Plain (% Land Area),
  "n__street_trees" BIGINT  -- # Street Trees,
  "park_space_acres" DOUBLE  -- Park Space (acres),
  "park_space_of_land_area" VARCHAR  -- Park Space (% Of Land Area),
  "park_space_acres_1000_pers" DOUBLE  -- Park Space (acres/1000 Pers.),
  "greenway_of_land_area" VARCHAR  -- Greenway (% Of Land Area),
  "woodland_of_land_area" VARCHAR  -- Woodland (% Of Land Area),
  "cemetery_of_land_area" VARCHAR  -- Cemetery (% Of Land Area)
);

CREATE TABLE population_density_2010 (
  "neighborhood" VARCHAR,
  "sector" BIGINT  -- Sector #,
  "pop_1940" BIGINT  -- Pop. 1940,
  "pop_1950" BIGINT  -- Pop. 1950,
  "pop_1960" BIGINT  -- Pop. 1960,
  "pop_1970" BIGINT  -- Pop. 1970,
  "pop_1980" BIGINT  -- Pop. 1980,
  "pop_1990" BIGINT  -- Pop. 1990,
  "pop_2000" BIGINT  -- Pop. 2000,
  "pop_2010" BIGINT  -- Pop. 2010,
  "n__pop_change_60_70" VARCHAR  -- % Pop. Change, 60-70,
  "n__pop_change_70_80" VARCHAR  -- % Pop. Change, 70-80,
  "n__pop_change_80_90" VARCHAR  -- % Pop. Change, 80-90,
  "n__pop_change_90_00" VARCHAR  -- % Pop. Change, 90-00,
  "n__pop_change_00_10" VARCHAR  -- % Pop. Change, 00-10,
  "pop_as_of_city_total_2010" VARCHAR  -- Pop. As % Of City Total (2010),
  "land_area_sq_mi" DOUBLE  -- Land Area (sq. Mi),
  "land_area_acres" DOUBLE  -- Land Area (acres),
  "persons_sq_mi_2010" DOUBLE  -- Persons / Sq. Mi (2010),
  "persons_sq_mi_2000" DOUBLE  -- Persons / Sq. Mi (2000),
  "persons_acre_2010" DOUBLE  -- Persons / Acre (2010),
  "persons_acre_2000" DOUBLE  -- Persons / Acre (2000),
  "n__african_american_2010" VARCHAR  -- % African American (2010),
  "n__asian_2010" VARCHAR  -- % Asian (2010),
  "n__other_2010" VARCHAR  -- % Other (2010),
  "n__white_2010" VARCHAR  -- % White (2010),
  "n__2_races_2010" DOUBLE  -- % 2+ Races (2010),
  "n__hispanic_of_any_race_2010" DOUBLE  -- % Hispanic (of Any Race) (2010),
  "n__pop_age_5_2010" DOUBLE  -- % Pop. Age < 5 (2010),
  "n__pop_age_5_19_2010" DOUBLE  -- % Pop. Age 5-19 (2010),
  "n__pop_age_20_34_2010" DOUBLE  -- % Pop. Age 20-34 (2010),
  "n__pop_age_35_59_2010" DOUBLE  -- % Pop. Age 35-59 (2010),
  "n__pop_age_60_74_2010" DOUBLE  -- % Pop. Age 60-74 (2010),
  "n__pop_age_75_2010" DOUBLE  -- % Pop. Age > 75 (2010)
);

CREATE TABLE public_safety_2010 (
  "neighborhood" VARCHAR,
  "sector" BIGINT  -- Sector #,
  "population_2010" BIGINT  -- Population (2010),
  "n__part_1_major_crime_reports_2010" BIGINT  -- #Part 1 (Major Crime) Reports (2010),
  "n__part_2_reports_2010" BIGINT  -- #Part 2 Reports (2010),
  "n__other_police_reports_2010" BIGINT  -- #Other Police Reports (2010),
  "part_1_crime_per_100_persons_2010" DOUBLE  -- Part 1 Crime Per 100 Persons (2010),
  "part_2_crime_per_100_persons_2010" DOUBLE  -- Part 2 Crime Per 100 Persons (2010),
  "n__murder_2010" BIGINT  -- #Murder (2010),
  "n__rape_2010" BIGINT  -- #Rape (2010),
  "n__robbery_2010" BIGINT  -- #Robbery (2010),
  "n__agr_assault_2010" BIGINT  -- #Agr. Assault (2010),
  "n__burglary_2010" BIGINT  -- #Burglary (2010),
  "n__auto_theft_2010" BIGINT  -- #Auto Theft (2010),
  "n__drug_violations_2010" BIGINT  -- #Drug Violations (2010)
);

CREATE TABLE transportation_2010 (
  "neighborhood" VARCHAR,
  "sector" BIGINT  -- Sector #,
  "population_2010" BIGINT  -- Population (2010),
  "miles_of_major_roads" DOUBLE,
  "total_street_miles" DOUBLE,
  "street_density_st_mi_area_sq_mi" DOUBLE  -- Street Density (st. Mi/area Sq. Mi),
  "n__sets_of_steps" BIGINT  -- # Sets Of Steps,
  "n__step_treads" BIGINT  -- # Step Treads,
  "res_permit_parking_area_s" VARCHAR  -- Res. Permit Parking Area(s),
  "total_working_pop_age_16_2010" BIGINT  -- Total Working Pop. (Age 16+) (2010),
  "commute_to_work_drive_alone_2010" VARCHAR  -- Commute To Work: Drive Alone (2010),
  "commute_to_work_carpool_vanpool_2010" VARCHAR  -- Commute To Work: Carpool/Vanpool (2010),
  "commute_to_work_public_transportation_2010" VARCHAR  -- Commute To Work: Public Transportation (2010),
  "commute_to_work_taxi_2010" VARCHAR  -- Commute To Work: Taxi (2010),
  "commute_to_work_motorcycle_2010" VARCHAR  -- Commute To Work: Motorcycle (2010),
  "commute_to_work_bicycle_2010" VARCHAR  -- Commute To Work: Bicycle (2010),
  "commute_to_work_walk_2010" VARCHAR  -- Commute To Work: Walk (2010),
  "commute_to_work_other_2010" VARCHAR  -- Commute To Work: Other (2010),
  "work_at_home_2010" VARCHAR  -- Work At Home (2010)
);