Housing Indicators

CREATE TABLE age_of_housing_by_tract (
  "row_labels" BIGINT,
  "before_1900" BIGINT,
  "n_1900_to_1929" BIGINT  -- 1900 To 1929,
  "n_1930_to_1945" BIGINT  -- 1930 To 1945,
  "n_1946_to_1978" BIGINT  -- 1946 To 1978,
  "n_1979_to_2008" BIGINT  -- 1979 To 2008,
  "n_2009_to_2022" BIGINT  -- 2009 To 2022,
  "total" BIGINT
);

CREATE TABLE average_sale_price_tract_in_2021_1_to_2_unit (
  "tract" BIGINT,
  "n_2012" DOUBLE  -- 2012,
  "n_2013" DOUBLE  -- 2013,
  "n_2014" DOUBLE  -- 2014,
  "n_2015" DOUBLE  -- 2015,
  "n_2016" DOUBLE  -- 2016,
  "n_2017" DOUBLE  -- 2017,
  "n_2018" DOUBLE  -- 2018,
  "n_2019" DOUBLE  -- 2019,
  "n_2020" DOUBLE  -- 2020,
  "n_2021" DOUBLE  -- 2021
);

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

CREATE TABLE condo_sales_price_2021_tract (
  "tract" BIGINT,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015,
  "n_2016" BIGINT  -- 2016,
  "n_2017" BIGINT  -- 2017,
  "n_2018" BIGINT  -- 2018,
  "n_2019" BIGINT  -- 2019,
  "n_2020" BIGINT  -- 2020,
  "n_2021" BIGINT  -- 2021
);

CREATE TABLE condo_sales_tract (
  "geo_id_tra" DOUBLE,
  "n_2012" DOUBLE  -- 2012,
  "n_2013" DOUBLE  -- 2013,
  "n_2014" DOUBLE  -- 2014,
  "n_2015" DOUBLE  -- 2015,
  "n_2016" DOUBLE  -- 2016,
  "n_2017" DOUBLE  -- 2017,
  "n_2018" DOUBLE  -- 2018,
  "n_2019" DOUBLE  -- 2019,
  "n_2020" DOUBLE  -- 2020,
  "n_2021" DOUBLE  -- 2021
);

CREATE TABLE foreclosures_initiated_2009_21_tract (
  "geo_id_tract" BIGINT,
  "n_2009" BIGINT  -- 2009,
  "n_2010" BIGINT  -- 2010,
  "n_2011" BIGINT  -- 2011,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015,
  "n_2016" BIGINT  -- 2016,
  "n_2017" BIGINT  -- 2017,
  "n_2018" BIGINT  -- 2018,
  "n_2019" BIGINT  -- 2019,
  "n_2020" BIGINT  -- 2020,
  "n_2021" BIGINT  -- 2021
);

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 housing_choice_voucher_by_tract_2012_2021 (
  "tract" BIGINT,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015,
  "n_2016" BIGINT  -- 2016,
  "n_2017" BIGINT  -- 2017,
  "n_2018" BIGINT  -- 2018,
  "n_2019" BIGINT  -- 2019,
  "n_2020" BIGINT  -- 2020,
  "n_2021" BIGINT  -- 2021
);

CREATE TABLE housing_prices_by_price_range_2021 (
  "row_labels" BIGINT,
  "under_50k" BIGINT  -- Under $50K,
  "n__50k_to_100k" BIGINT  -- $50K To $100K,
  "n__100k_to_150k" BIGINT  -- $100K To $150K,
  "n__150k_to_200k" BIGINT  -- $150K To $200K,
  "n__200k_to_250k" BIGINT  -- $200K To $250K,
  "n__250k_to_300k" BIGINT  -- $250K To $300K,
  "n__300k_to_350k" BIGINT  -- $300K To $350K,
  "n__350k_to_400k" BIGINT  -- $350K To $400K,
  "n__400k_to_450k" BIGINT  -- $400K To $450K,
  "n__450k_to_500k" BIGINT  -- $450K To $500K,
  "over_500k" BIGINT  -- Over $500K,
  "total" BIGINT
);

CREATE TABLE housing_sales_1_2_unit_by_tract (
  "geo_id_tract" BIGINT,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015,
  "n_2016" BIGINT  -- 2016,
  "n_2017" BIGINT  -- 2017,
  "n_2018" BIGINT  -- 2018,
  "n_2019" BIGINT  -- 2019,
  "n_2020" BIGINT  -- 2020,
  "n_2021" BIGINT  -- 2021
);

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

CREATE TABLE median_1_2_unit_homes_median_price_in_2021_by_tract (
  "tract" BIGINT,
  "n_2012" DOUBLE  -- 2012,
  "n_2013" DOUBLE  -- 2013,
  "n_2014" DOUBLE  -- 2014,
  "n_2015" DOUBLE  -- 2015,
  "n_2016" DOUBLE  -- 2016,
  "n_2017" DOUBLE  -- 2017,
  "n_2018" DOUBLE  -- 2018,
  "n_2019" DOUBLE  -- 2019,
  "n_2020" DOUBLE  -- 2020,
  "n_2021" DOUBLE  -- 2021
);

CREATE TABLE median_1_2_unit_homes_median_price_in_actual_by_tract (
  "tract" DOUBLE,
  "n_2012" DOUBLE  -- 2012,
  "n_2013" DOUBLE  -- 2013,
  "n_2014" DOUBLE  -- 2014,
  "n_2015" DOUBLE  -- 2015,
  "n_2016" DOUBLE  -- 2016,
  "n_2017" DOUBLE  -- 2017,
  "n_2018" DOUBLE  -- 2018,
  "n_2019" DOUBLE  -- 2019,
  "n_2020" DOUBLE  -- 2020,
  "n_2021" DOUBLE  -- 2021
);

CREATE TABLE mortgage_to_sales_ratio (
  "tract" BIGINT,
  "num_sales" BIGINT,
  "mor_orig" DOUBLE,
  "mortgage_to_sales" DOUBLE,
  "year" BIGINT,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6
);

CREATE TABLE n_1_to_4_unit_sales_by_year_and_tract (
  "geo_id_tract" BIGINT,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015,
  "n_2016" BIGINT  -- 2016,
  "n_2017" BIGINT  -- 2017,
  "n_2018" BIGINT  -- 2018,
  "n_2019" BIGINT  -- 2019,
  "n_2020" BIGINT  -- 2020,
  "n_2021" BIGINT  -- 2021,
  "n_2022" BIGINT  -- 2022
);

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 parcels_to_sales_ratio (
  "geo_id_tract" BIGINT,
  "numsales" BIGINT,
  "year" BIGINT,
  "numparcels" DOUBLE,
  "parcels_sales" DOUBLE
);

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

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

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

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

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

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

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

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