SELECT * FROM VCGI_Admin.TABLE_INDICATORS_cntyfarm WHERE CNTYCODE = #URL.ProfileCounty# SELECT * FROM VCGI_Admin.TABLE_INDICATORS_CNTYPOPN WHERE CNTYCODE = #URL.ProfileSecondCounty# 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_cntynames WHERE CNTYNAME = '#ProfileSecondCounty#' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_POPN WHERE CNTYNAME = '#ProfileSecondCounty#' AND GEOTYPE = 'c' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_HOUS WHERE CNTYNAME = '#ProfileSecondCounty#' AND GEOTYPE = 'c' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_ECON WHERE CNTYNAME = '#ProfileSecondCounty#' AND GEOTYPE = 'c' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_TRAN WHERE CNTYNAME = '#ProfileSecondCounty#' AND GEOTYPE = 'c' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_EDUC WHERE CNTYNAME = '#ProfileSecondCounty#' AND GEOTYPE = 'c' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_PROP WHERE CNTYNAME = '#ProfileSecondCounty#' AND GEOTYPE = 'c' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_SFTY WHERE CNTYNAME = '#ProfileSecondCounty#' AND GEOTYPE = 'c' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_NATR WHERE CNTYNAME = '#ProfileSecondCounty#' AND GEOTYPE = 'c' SELECT * FROM VCGI_Admin.TABLE_INDICATORS_cntynames WHERE county NOT LIKE '#ProfileSecondCounty#' 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