Veteran Population Projection Model 2016 (VetPop2016)
2015-2045. Veteran population projections by county for US counties. From va.gov: "The Veteran Population Projection Model 2016 (VetPop2016) provides the latest official Veteran population projection from the Department of Veterans Affairs (VA). VetPop2016 is a deterministic actuarial projection model developed by the office of Predictive Analytics and Actuary (PAA) to estimate and project the Veteran Population from Fiscal Year (FY) 2015 to FY2045. Using the best available Veteran data at the end of FY2015 as the base population. VetPop2016 projects living and deceased Veteran counts by key demographic characteristics such as age, gender, period of service, and race/ethnicity at various geographic levels for the next 30 years." ***NOTE: Current upload to data.mi excludes location information for Puerto Rico, American Samoa, Guam, Northern Mariana Islands, Virgin Islands, and Foreign Countries projections. This is because of a geocoding error between the VetPop2016 and the county location file from the US Census Bureau. Point locations for the above mentioned geographies will be added to this dataset once the error is resolved.
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on
this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \
-H "Content-Type: application/json" \
-d@-<<EOF
{"sql": "
SELECT *
FROM \"michigan-gov/veteran-population-projection-model-2016-pzfj-fnph\".\"veteran_population_projection_model_2016\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
