code: 12009
code:12009-- q: SELECT ID FROM indicators.nat_acs20115_all a WHERE ucounty = '12009' ORDER BY NccsLabel, StUsAb
- Sorry, there was an error processing record: -
Please contact us at info@civicLeadershipProject.org. We are sorry for the inconvenience.
census id: -1
SELECT *,
PopPoorPersons/TotPop*100 as PctPov,
PopPoorChildren/(Pop5to17Years+ PopUnder5Years)*100 as PctChildPov,
PopPoorElderly/Pop65andOverYears*100 as PctElderPov,
NumOccupiedHsgUnits/NumHsgUnits*100 as OccupRateHsgUnits,
TotValueOwnerHshlds/NumOwnerOccHsgUnitsWithValueDet as AvgValueOwnerHshlds,
AggHshldIncome/NumHshlds as AvgHshldIncome
from indicators.nat_acs20115_all a
LEFT JOIN nccs.states b ON a.stusab = b.code
where a.id = -1
- Sorry, there was an error processing record: -
Please contact us at info@civicLeadershipProject.org. We are sorry for the inconvenience.