DOF: Cooperative Comparable Rental Income – Brooklyn – FY 2008/2009
City of New York
@usgov.city_of_new_york_dof_cooperative_comparable_rental_inc_3be9a8d5
City of New York
@usgov.city_of_new_york_dof_cooperative_comparable_rental_inc_3be9a8d5
CREATE TABLE table_1 (
"brooklyn_cooperatives_comparable_properties_boro_block_lot" VARCHAR,
"brooklyn_cooperatives_comparable_properties_address" VARCHAR,
"borough" BIGINT,
"postcode" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"community_board" DOUBLE,
"council_district" DOUBLE,
"census_tract" DOUBLE,
"bin" DOUBLE,
"bbl" DOUBLE,
"nta" VARCHAR,
"brooklyn_cooperatives_comparable_properties_neighborhood" VARCHAR,
"brooklyn_cooperatives_comparable_properties_building_c_b30a808a" VARCHAR,
"brooklyn_cooperatives_comparable_properties_total_units" BIGINT,
"brooklyn_cooperatives_comparable_properties_year_built" BIGINT,
"brooklyn_cooperatives_comparable_properties_gross_sqft" BIGINT,
"brooklyn_cooperatives_comparable_properties_est_gross_income" BIGINT,
"brooklyn_cooperatives_comparable_properties_gross_inco_25b048ac" DOUBLE,
"brooklyn_cooperatives_comparable_properties_full_market_value" BIGINT,
"brooklyn_cooperatives_comparable_properties_market_val_18e0fc4a" DOUBLE,
"comparable_rental_1_boro_block_lot" VARCHAR,
"comparable_rental_1_address" VARCHAR,
"comparable_rental_1_neighborhood" VARCHAR,
"comparable_rental_1_building_classification" VARCHAR,
"comparable_rental_1_total_units" BIGINT,
"comparable_rental_1_year_built" BIGINT,
"comparable_rental_1_gross_sqft" BIGINT,
"comparable_rental_1_est_gross_income" BIGINT,
"comparable_rental_1_gross_income_per_sqft" DOUBLE,
"comparable_rental_1_full_market_value" BIGINT,
"comparable_rental_1_market_value_per_sqft" DOUBLE,
"comparable_rental_1_dist_from_coop_in_miles" DOUBLE,
"comparable_rental_2_boro_block_lot" VARCHAR,
"comparable_rental_2_address" VARCHAR,
"comparable_rental_2_neighborhood" VARCHAR,
"comparable_rental_2_building_classification" VARCHAR,
"comparable_rental_2_total_units" DOUBLE,
"comparable_rental_2_year_built" DOUBLE,
"comparable_rental_2_gross_sqft" DOUBLE,
"comparable_rental_2_est_gross_income" DOUBLE,
"comparable_rental_2_gross_income_per_sqft" DOUBLE,
"comparable_rental_2_full_market_value" DOUBLE,
"comparable_rental_2_market_value_per_sqft" DOUBLE,
"comparable_rental_2_dist_from_coop_in_miles" DOUBLE
);
Anyone who has the link will be able to view this.