This repo contains all the scripts used to build the City Planning Facilities Database (FacDB). Please note this database and its build and maintenance processes are still in active development.
Previously we had decided with HHS to exclude records whose contract had expired, but now since the data is over a year old, many contracts that were likely renewed are missing in FacDB. New data should be available in December.
Previously we had decided with HHS to exclude records whose contract had expired, but now since the data is over a year old, many contracts that were likely renewed are missing in FacDB. New data should be available in December.
https://github.com/NYCPlanning/db-facilities/blob/master/2_assembly/config_hhs_facilities_financialscontracts.sql#L333
https://github.com/NYCPlanning/db-facilities/blob/master/2_assembly/config_hhs_facilities_proposals.sql#L333
https://github.com/NYCPlanning/db-facilities/blob/master/2_assembly/config_hhs_facilities_fmscontracts.sql#L332