The fc_shd dataset can be added to NYCDB by running:

> nycdb --download fc_shd
> nycdb --load fc_shd

The dataset comes from the NYU Furman Center CoreData.nyc website:

CoreData.nyc’s Subsidized Housing Database includes the only publicly available, property-level database of New York City’s subsidized housing. It allows users to identify currently subsidized properties in the city, the subsidy type and program applicable to specific properties, and the start and end date for the subsidy on a property, allowing the user to identify properties at risk of exiting from affordability restrictions.

They provide download files in two formats (we currently have only added the BBL-analysis version to NYCDB):

The FC_SHD_subsidy_analysis_yyyy-mm-dd.csv file is provided for detailed analysis of subsidies and properties. Each entry in this data file represents the combination of a subsidy record and a property. If multiple subsidies are available for one property (identified by Borough-Block-Lot aka BBL), there will be multiple entries associated with the single BBL. Also, if a single subsidy contract applies to multiple properties, then there will be multiple entries associated with the single subsidy. Along with the subsidy information such as corresponding agency, subsidy type, as well as the start and end date, the subsidy analysis file provides the information of the property including address, the number of residential units, year built and etc. The file also provides latitude and longitude points of the BBLs for potential geospatial analysis. For detailed information, please refer to FC_SHD_subsidy_analysis_data_dictionary_yyyy-mm-dd.xlsx.

The FC_SHD_bbl_analysis_yyyy-mm-dd.csv file will be useful for property-level analysis. Each entry is a unique property (BBL). The data set has compiled all the subsidies associated with the BBL into one entry with the property details, captured in a series of columns for each program. The file also provides latitude and longitude points of the BBLs for potential geospatial analysis. For detailed information, please refer to FC_SHD_bbl_analysis_data_dictionary_yyyy-mm-dd.xlsx.

This dataset provides a useful collection of many different sources of subsidized housing data from city, state, and national programs all geocoded and linked to NYC's parcel id BBL (borough-block-lot) which allows for easy linking to all other datasets in NYCDB.

You can download the bbl-analysis file's data dictionary XLSX.

This dataset has the following tables:

• fc_shd_building is the only table in this dataset (a subsidy-level dataset may be added to NYCDB in the future).

There currently are some duplicate records even though the fc_shd_building file should be unique by BBL. We haven't added the subsidy-level analysis file because of an issue with the encoding of the file, and it's generally less useful for typical NYCDB analysis for linking to other datasets via BBL.