Not all “complete” job records have corresponding CofO records

NYCPlanning / db-housingdev

Please note this is the legacy repo. New repo is db-housing

3 stars 0 forks source link

Not all “complete” job records have corresponding CofO records #52

Open hannahkates opened 6 years ago

hannahkates commented 6 years ago

Most of them are from 2018

SELECT min(status_x), max(status_x), left(status_x::text,4), count(*) FROM capitalplanning.dob_housing_20180126v3 where dcp_status = 'Complete' and c_date_latest is null group by left(status_x::text,4) order by left(status_x::text,4) desc