Income - ACS 2016-2020 - Tempe Tracts
City of Tempe
@usgov.city_of_tempe_income_acs_2016_2020_tempe_tracts_dbef1
City of Tempe
@usgov.city_of_tempe_income_acs_2016_2020_tempe_tracts_dbef1
CREATE TABLE table_1 (
"objectid_1" BIGINT,
"tract_id" VARCHAR,
"households_total" BIGINT,
"households_total_less_than_10" DOUBLE,
"households_total_10_000_to_14" DOUBLE,
"households_total_15_000_to_24" DOUBLE,
"households_total_25_000_to_34" DOUBLE,
"households_total_35_000_to_49" DOUBLE,
"households_total_50_000_to_74" DOUBLE,
"households_total_75_000_to_99" DOUBLE,
"households_total_100_000_to_1" DOUBLE,
"households_total_150_000_to_1" DOUBLE,
"households_total_200_000_or_mo" DOUBLE,
"households_median_income_dolla" DOUBLE,
"households_mean_income_dollars" DOUBLE,
"families_total" BIGINT,
"families_total_less_than_10_00" DOUBLE,
"families_total_10_000_to_14_9" DOUBLE,
"families_total_15_000_to_24_9" DOUBLE,
"families_total_25_000_to_34_9" DOUBLE,
"families_total_35_000_to_49_9" DOUBLE,
"families_total_50_000_to_74_9" DOUBLE,
"families_total_75_000_to_99_9" DOUBLE,
"families_total_100_000_to_149" DOUBLE,
"families_total_150_000_to_199" DOUBLE,
"families_total_200_000_or_more" DOUBLE,
"families_median_income_dollars" DOUBLE,
"families_mean_income_dollars" DOUBLE,
"marriedcouple_families_total" BIGINT,
"marriedcouple_families_total_le" DOUBLE,
"marriedcouple_families_total_1" DOUBLE,
"marriedcouple_families_total_2" DOUBLE,
"marriedcouple_families_total_3" DOUBLE,
"marriedcouple_families_total_4" DOUBLE,
"marriedcouple_families_total_5" DOUBLE,
"marriedcouple_families_total_7" DOUBLE,
"marriedcouple_families_total_6" DOUBLE,
"marriedcouple_families_total_8" DOUBLE,
"marriedcouple_families_total_9" DOUBLE,
"marriedcouple_families_median_i" DOUBLE,
"marriedcouple_families_mean_inc" DOUBLE,
"nonfamily_households_total" BIGINT,
"nonfamily_households_total_less" DOUBLE,
"nonfamily_households_total_10" DOUBLE,
"nonfamily_households_total_15" DOUBLE,
"nonfamily_households_total_25" DOUBLE,
"nonfamily_households_total_35" DOUBLE,
"nonfamily_households_total_50" DOUBLE,
"nonfamily_households_total_75" DOUBLE,
"nonfamily_households_total_100" DOUBLE,
"nonfamily_households_total_150" DOUBLE,
"nonfamily_households_total_200" DOUBLE,
"nonfamily_households_median_inc" DOUBLE,
"nonfamily_households_mean_incom" DOUBLE,
"city" VARCHAR,
"shape_area" DOUBLE,
"shape_length" DOUBLE
);
Anyone who has the link will be able to view this.