Name: Neighborhoods With SNAP Data
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Neighborhoods With SNAP Data

Pittsburgh Neighborhoods
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:06:50.371049
Tags: business-and-economy, civic-vitality-and-governance, demographics, education, environment, geography, harvested, housing-and-properties, public-safety-and-justice, transportation

Tables

Table 1

@usgov.allegheny_county_city_of_pitts_neighborhoods_with_snap_data.table_1

221.55 kB
90 rows
190 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "fid_blockg" BIGINT,
  "statefp10" BIGINT,
  "countyfp10" BIGINT,
  "tractce10" BIGINT,
  "blkgrpce10" BIGINT,
  "geoid10" BIGINT,
  "namelsad10" VARCHAR,
  "mtfcc10" VARCHAR,
  "funcstat10" VARCHAR,
  "aland10" BIGINT,
  "awater10" BIGINT,
  "intptlat10" DOUBLE,
  "intptlon10" DOUBLE,
  "shape_leng" DOUBLE,
  "fid_neighb" BIGINT,
  "area" DOUBLE,
  "perimeter" DOUBLE,
  "neighbor" BIGINT,
  "neighbor_i" BIGINT,
  "hood" VARCHAR,
  "hood_no" BIGINT,
  "acres" DOUBLE,
  "sqmiles" DOUBLE,
  "dpwdiv" BIGINT,
  "unique_id" BIGINT,
  "sectors" BIGINT,
  "shape_le_1" DOUBLE,
  "shape_ar_1" DOUBLE,
  "page_number" VARCHAR,
  "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" VARCHAR  -- % 2+ Races (2010),
  "n__hispanic_of_any_race_2010" VARCHAR  -- % Hispanic (of Any Race) (2010),
  "n__pop_age_5_2010" VARCHAR  -- % Pop. Age < 5 (2010),
  "n__pop_age_5_19_2010" VARCHAR  -- % Pop. Age 5-19 (2010),
  "n__pop_age_20_34_2010" VARCHAR  -- % Pop. Age 20-34 (2010),
  "n__pop_age_35_59_2010" VARCHAR  -- % Pop. Age 35-59 (2010),
  "n__pop_age_60_74_2010" VARCHAR  -- % Pop. Age 60-74 (2010),
  "n__pop_age_75_2010" VARCHAR  -- % Pop. Age > 75 (2010),
  "total_units_2000" BIGINT  -- Total # Units (2000),
  "total_units_2010" BIGINT  -- Total # Units (2010),
  "n__occupied_units_2010" VARCHAR  -- % Occupied Units (2010),
  "n__vacant_units_2010" VARCHAR  -- % Vacant Units (2010),
  "n__occupied_units_2010_3e8111" BIGINT  -- # Occupied Units (2010),
  "n__owner_occupied_units_2010" VARCHAR  -- % Owner Occupied Units (2010),
  "n__renter_occupied_units_2010" VARCHAR  -- % Renter Occupied Units (2010),
  "est_avg_yrs_of_residence_2010" BIGINT  -- Est. Avg. Yrs. Of Residence (2010),
  "n__living_in_household_2010" VARCHAR  -- % Living In Household (2010),
  "n__living_in_group_quarters_2010" VARCHAR  -- % Living In Group Quarters (2010),
  "n__units_built_00_09" VARCHAR  -- % Units Built 00-09,
  "n__units_built_90_99" VARCHAR  -- % Units Built 90-99,
  "n__units_built_80_89" VARCHAR  -- % Units Built 80-89,
  "n__units_built_60_79" VARCHAR  -- % Units Built 60-79,
  "n__units_built_40_59" VARCHAR  -- % Units Built 40-59,
  "n__units_built_before_1939" VARCHAR  -- % Units Built Before 1939,
  "median_home_value_2000" VARCHAR  -- Median Home Value (2000),
  "med_val_00_in_10_dollars" VARCHAR  -- Med. Val. ('00 In '10 Dollars),
  "median_home_value_2010" VARCHAR  -- Median Home Value (2010),
  "n__change_real_value_2000_2010" VARCHAR  -- % Change Real Value 2000-2010,
  "median_sale_price_2010" VARCHAR  -- Median Sale Price (2010),
  "n__sales_counted_2010" BIGINT  -- # Sales Counted (2010),
  "foreclosures_2008" BIGINT  -- Foreclosures (2008),
  "foreclosures_2010" BIGINT  -- Foreclosures (2010),
  "n__of_all_housing_units_foreclosed_2010" VARCHAR  -- % Of All Housing Units Foreclosed (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
);