Housing Indicators

CREATE TABLE unimproved_parcels_oct_2021_by_tract (
  "geo_id_tract" BIGINT,
  "countofparid" BIGINT
);

CREATE TABLE parcels_with_1_to_2_unit_properties_by_tract (
  "tract" BIGINT,
  "parcels" BIGINT
);

CREATE TABLE total_parcels_oct_2021_by_tract (
  "tract" BIGINT,
  "totparcels" BIGINT
);

CREATE TABLE housing_sales_1_2_unit_by_tract (
  "geo_id_tract" BIGINT,
  "n_2012" BIGINT,
  "n_2013" BIGINT,
  "n_2014" BIGINT,
  "n_2015" BIGINT,
  "n_2016" BIGINT,
  "n_2017" BIGINT,
  "n_2018" BIGINT,
  "n_2019" BIGINT,
  "n_2020" BIGINT,
  "n_2021" BIGINT
);

CREATE TABLE median_1_2_unit_homes_median_price_in_2021_by_tract (
  "tract" BIGINT,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE
);

CREATE TABLE median_1_2_unit_homes_median_price_in_actual_by_tract (
  "tract" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE
);

CREATE TABLE ownership_change_2011_2020_1_to_2_unit_sales_tract (
  "row_labels" BIGINT,
  "yy" BIGINT,
  "yn" BIGINT,
  "ny" BIGINT,
  "nn" BIGINT,
  "total" BIGINT
);

CREATE TABLE foreclosures_initiated_2009_21_tract (
  "geo_id_tract" BIGINT,
  "n_2009" BIGINT,
  "n_2010" BIGINT,
  "n_2011" BIGINT,
  "n_2012" BIGINT,
  "n_2013" BIGINT,
  "n_2014" BIGINT,
  "n_2015" BIGINT,
  "n_2016" BIGINT,
  "n_2017" BIGINT,
  "n_2018" BIGINT,
  "n_2019" BIGINT,
  "n_2020" BIGINT,
  "n_2021" BIGINT
);

CREATE TABLE tax_liens_by_tract_feb_2022 (
  "geo_id_tract" BIGINT,
  "tot_parcels_lien" BIGINT,
  "sumliens" BIGINT,
  "sumamount" DOUBLE
);

CREATE TABLE building_code_violations_2021_by_pittsburgh_tract (
  "geo_id_tract" BIGINT,
  "n_2021" BIGINT
);

CREATE TABLE housing_choice_voucher_by_tract_2012_2021 (
  "tract" BIGINT,
  "n_2012" BIGINT,
  "n_2013" BIGINT,
  "n_2014" BIGINT,
  "n_2015" BIGINT,
  "n_2016" BIGINT,
  "n_2017" BIGINT,
  "n_2018" BIGINT,
  "n_2019" BIGINT,
  "n_2020" BIGINT,
  "n_2021" BIGINT
);

CREATE TABLE vacant_usps_addresses_march_2021_tract (
  "geoid" BIGINT,
  "quarter" VARCHAR,
  "ams_res" BIGINT,
  "res_vac" BIGINT,
  "nostat_res" BIGINT,
  "vac_3_res" BIGINT,
  "vac_3_6_r" BIGINT,
  "vac_6_12r" BIGINT,
  "vac_12_24r" BIGINT,
  "vac_24_36r" BIGINT,
  "vac_36_res" BIGINT,
  "ns_3_res" BIGINT,
  "ns_3_6_res" BIGINT,
  "ns_6_12_r" BIGINT,
  "ns_12_24_r" BIGINT,
  "ns_24_36_r" BIGINT,
  "ns_36_res" BIGINT
);

CREATE TABLE parcels_with_1_4_unit_including_condominimums_tract_oct_2021 (
  "tract" BIGINT,
  "count" BIGINT
);

CREATE TABLE n_1_to_4_unit_sales_by_year_and_tract (
  "geo_id_tract" BIGINT,
  "n_2012" BIGINT,
  "n_2013" BIGINT,
  "n_2014" BIGINT,
  "n_2015" BIGINT,
  "n_2016" BIGINT,
  "n_2017" BIGINT,
  "n_2018" BIGINT,
  "n_2019" BIGINT,
  "n_2020" BIGINT,
  "n_2021" BIGINT,
  "n_2022" BIGINT
);

CREATE TABLE profiles_format_median_1_2_unit_homes_median_price_in__5dd39740 (
  "tract" BIGINT,
  "value" DOUBLE,
  "year" BIGINT
);

CREATE TABLE profiles_format_foreclosure_2009_2021 (
  "tract" VARCHAR,
  "foreclosure" DOUBLE,
  "year" DOUBLE
);

CREATE TABLE hmda_by_race (
  "census_tract" BIGINT,
  "activity_year" BIGINT,
  "originations" BIGINT,
  "originationsraceknown" BIGINT,
  "orig_2ormoreminority" BIGINT,
  "orig_aian" BIGINT,
  "orig_asian" BIGINT,
  "orig_black" BIGINT,
  "orig_freeformtxt" BIGINT,
  "orig_joint" BIGINT,
  "orig_nativehawaiian_pacificisl" BIGINT,
  "orig_racenotavail" BIGINT,
  "orig_white" BIGINT,
  "denials" BIGINT,
  "denialsraceknown" BIGINT,
  "denial_2ormoreminority" BIGINT,
  "denial_aian" BIGINT,
  "denial_asian" BIGINT,
  "denial_black" BIGINT,
  "denial_joint" BIGINT,
  "denial_nativehawaiian_pacificisl" BIGINT,
  "denial_racenotavail" BIGINT,
  "denial_white" BIGINT,
  "applications" BIGINT,
  "applicationsraceknown" BIGINT,
  "app_2ormoreminority" BIGINT,
  "app_aian" BIGINT,
  "app_asian" BIGINT,
  "app_black" BIGINT,
  "app_freeformtxt" BIGINT,
  "app_joint" BIGINT,
  "app_nativehawaiian_pacificisl" BIGINT,
  "app_racenotavail" BIGINT,
  "app_white" BIGINT,
  "sumofloan_amount" BIGINT,
  "avgofloan_amount" DOUBLE
);

CREATE TABLE profiles_format_number_of_housing_sales_1_2_unit_by_tract (
  "geo_id_tract" DOUBLE,
  "numsales" DOUBLE,
  "year" DOUBLE
);

CREATE TABLE average_sale_price_tract_in_2021_1_to_2_unit (
  "tract" BIGINT,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE
);

CREATE TABLE profiles_format_average_sale_price_tract_in_2021_1_to_2_unit (
  "tract" BIGINT,
  "year" BIGINT,
  "value" DOUBLE
);

CREATE TABLE parcels_to_sales_ratio (
  "geo_id_tract" BIGINT,
  "numsales" BIGINT,
  "year" BIGINT,
  "numparcels" DOUBLE,
  "parcels_sales" DOUBLE
);

CREATE TABLE age_of_housing_by_tract (
  "row_labels" BIGINT,
  "before_1900" BIGINT,
  "n_1900_to_1929" BIGINT,
  "n_1930_to_1945" BIGINT,
  "n_1946_to_1978" BIGINT,
  "n_1979_to_2008" BIGINT,
  "n_2009_to_2022" BIGINT,
  "total" BIGINT
);

CREATE TABLE housing_prices_by_price_range_2021 (
  "row_labels" BIGINT,
  "under_50k" BIGINT,
  "n__50k_to_100k" BIGINT,
  "n__100k_to_150k" BIGINT,
  "n__150k_to_200k" BIGINT,
  "n__200k_to_250k" BIGINT,
  "n__250k_to_300k" BIGINT,
  "n__300k_to_350k" BIGINT,
  "n__350k_to_400k" BIGINT,
  "n__400k_to_450k" BIGINT,
  "n__450k_to_500k" BIGINT,
  "over_500k" BIGINT,
  "total" BIGINT
);

CREATE TABLE market_value_analysis_classifications_by_tract_2021 (
  "row_labels" BIGINT,
  "mvalabel2021" VARCHAR
);

CREATE TABLE mortgage_to_sales_ratio (
  "tract" BIGINT,
  "num_sales" BIGINT,
  "mor_orig" DOUBLE,
  "mortgage_to_sales" DOUBLE,
  "year" BIGINT,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR
);

CREATE TABLE condo_sales_price_2021_tract (
  "tract" BIGINT,
  "n_2012" BIGINT,
  "n_2013" BIGINT,
  "n_2014" BIGINT,
  "n_2015" BIGINT,
  "n_2016" BIGINT,
  "n_2017" BIGINT,
  "n_2018" BIGINT,
  "n_2019" BIGINT,
  "n_2020" BIGINT,
  "n_2021" BIGINT
);

CREATE TABLE condo_sales_tract (
  "geo_id_tra" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE
);