Property Valuation And Assessment Data Tax Classes 2,3,4
City of New York
@usgov.city_of_new_york_property_valuation_and_assessment_tax_d906ac12
City of New York
@usgov.city_of_new_york_property_valuation_and_assessment_tax_d906ac12
CREATE TABLE table_1 (
"bble" VARCHAR,
"boro" BIGINT,
"block" BIGINT,
"lot" BIGINT,
"ease" VARCHAR,
"secvol" BIGINT,
"district" VARCHAR,
"year4" BIGINT,
"cur_fv_l" BIGINT,
"cur_fv_t" BIGINT,
"new_fv_l" BIGINT,
"new_fv_t" BIGINT,
"fv_chgdt" TIMESTAMP,
"curavl" BIGINT,
"curavt" BIGINT,
"curexl" BIGINT,
"curext" BIGINT,
"curavl_a" BIGINT,
"curavt_a" BIGINT,
"curexl_a" BIGINT,
"curext_a" BIGINT,
"chgdt" TIMESTAMP,
"tn_avl" BIGINT,
"tn_avt" BIGINT,
"tn_exl" BIGINT,
"tn_ext" BIGINT,
"tn_avl_a" BIGINT,
"tn_avt_a" BIGINT,
"tn_exl_a" BIGINT,
"tn_ext_a" BIGINT,
"fchgdt" TIMESTAMP,
"fn_avl" BIGINT,
"fn_avt" BIGINT,
"fn_exl" BIGINT,
"fn_ext" BIGINT,
"fn_avl_a" BIGINT,
"fn_avt_a" BIGINT,
"fn_exl_a" BIGINT,
"fn_ext_a" BIGINT,
"txcl" VARCHAR,
"o_txcl" VARCHAR,
"cbn_txcl" VARCHAR,
"bldgcl" VARCHAR,
"exmtcl" VARCHAR,
"owner" VARCHAR,
"hnum_lo" VARCHAR,
"hnum_hi" VARCHAR,
"str_name" VARCHAR,
"zip" BIGINT,
"tot_unit" BIGINT,
"res_unit" BIGINT,
"lfrt_dec" DOUBLE,
"ldep_dec" DOUBLE,
"l_acre" VARCHAR,
"irreg" VARCHAR,
"bfrt_dec" DOUBLE,
"bdep_dec" DOUBLE,
"bld_var" VARCHAR,
"ext" VARCHAR,
"story" DOUBLE,
"bldgs" BIGINT,
"corner" VARCHAR,
"lnd_area" BIGINT,
"gr_sqft" BIGINT,
"zoning" VARCHAR,
"yrb" BIGINT,
"yrb_flag" VARCHAR,
"yrb_rng" BIGINT,
"yra1" BIGINT,
"yra1_rng" BIGINT,
"yra2" BIGINT,
"yra2_rng" BIGINT,
"cp_boro" DOUBLE,
"cp_dist" DOUBLE,
"limit" DOUBLE,
"o_limit" DOUBLE,
"status1" BIGINT,
"status2" VARCHAR,
"newlot" BIGINT,
"droplot" BIGINT,
"delchg" VARCHAR,
"corchg" BIGINT,
"nodesc" BIGINT,
"noav" BIGINT,
"valref" DOUBLE,
"mbldg" DOUBLE,
"condo_nm" BIGINT,
"condo_s1" VARCHAR,
"condo_s2" DOUBLE,
"condo_s3" VARCHAR,
"condo_a" VARCHAR,
"comint_l" DOUBLE,
"comint_b" DOUBLE,
"aptno" VARCHAR,
"ap_boro" BIGINT,
"ap_block" BIGINT,
"ap_lot" BIGINT,
"ap_ease" VARCHAR,
"ap_date" TIMESTAMP,
"ap_time" BIGINT
);
Anyone who has the link will be able to view this.