SELECT * FROM VCGI_Admin.TABLE_INDICATORS_cntyfarm WHERE CNTYFIPS = #URL.ProfileCounty# SELECT * FROM VCGI_Admin.TABLE_INDICATORS_cntynames WHERE CNTYNAME = '#ProfileCounty#' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_POPN WHERE CNTYNAME = '#ProfileCounty#' AND GEOTYPE = 'c' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_HOUS WHERE CNTYNAME = '#ProfileCounty#' AND GEOTYPE = 'c' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_ECON WHERE CNTYNAME = '#ProfileCounty#' AND GEOTYPE = 'c' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_TRAN WHERE CNTYNAME = '#ProfileCounty#' AND GEOTYPE = 'c' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_EDUC WHERE CNTYNAME = '#ProfileCounty#' AND GEOTYPE = 'c' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_PROP WHERE CNTYNAME = '#ProfileCounty#' AND GEOTYPE = 'c' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_SFTY WHERE CNTYNAME = '#ProfileCounty#' AND GEOTYPE = 'c' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_NATR WHERE CNTYNAME = '#ProfileCounty#' AND GEOTYPE = 'c' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_POPN WHERE GEOTYPE = 's' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_HOUS WHERE GEOTYPE = 's' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_ECON WHERE GEOTYPE = 's' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_TRAN WHERE GEOTYPE = 's' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_EDUC WHERE GEOTYPE = 's' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_PROP WHERE GEOTYPE = 's' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_SFTY WHERE GEOTYPE = 's' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_NATR WHERE GEOTYPE = 's' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_cntynames WHERE county NOT LIKE '#ProfileCounty#' ORDER BY county

#getCountyRec0.COUNTY# County

Click on Hyperlinked numbers to get a historical trend report.
Click on Variable Titles to access data definitions and sources.

View A Theme Table

Select A New County To Profile

Compare a Second County