Fee Charges
City of New York
@usgov.city_of_new_york_fee_charges
City of New York
@usgov.city_of_new_york_fee_charges
Contains information about fees assessed against properties by HPD pursuant to the Housing Maintenance Code.
Organization: City of New York
Last updated: 2020-11-10T17:02:15.014521
Tags: charges, department-of-housing-preservation-and-development, fee-charges, hpd
CREATE TABLE table_1 (
"feeid" BIGINT,
"buildingid" BIGINT,
"boroid" BIGINT,
"boro" VARCHAR,
"housenumber" VARCHAR,
"streetname" VARCHAR,
"zip" DOUBLE,
"block" BIGINT,
"lot" BIGINT,
"lifecycle" VARCHAR,
"feetypeid" BIGINT,
"feetype" VARCHAR,
"feesourcetypeid" BIGINT,
"feesourcetype" VARCHAR,
"feesourceid" BIGINT,
"feeissueddate" TIMESTAMP,
"feeamount" BIGINT,
"dofaccounttype" BIGINT,
"doftransferdate" TIMESTAMP,
"latitude" DOUBLE,
"longitude" DOUBLE,
"community_board" DOUBLE,
"council_district" DOUBLE,
"census_tract" DOUBLE,
"bin" DOUBLE,
"bbl" DOUBLE,
"nta" VARCHAR
);Anyone who has the link will be able to view this.