1,521 bytes added
, 23:25, 2 April 2021
==Pulling Census Data==
Data on public school expenditures are available through the Census:
*Get all available expenditure variables for all years, US level, through the API: https://api.census.gov/data/timeseries/govs?get=SVY_COMP,SVY_COMP_LABEL,GEO_ID,YEAR,AGG_DESC,AGG_DESC_LABEL,GOVTYPE,GOVTYPE_LABEL,AMOUNT_FORMATTED&for=us:*&SVY_COMP=06
*Also through the API: Staff levels are available in SVG_COMP=01: https://api.census.gov/data/timeseries/govs?get=SVY_COMP,SVY_COMP_LABEL,GEO_ID,YEAR,AGG_DESC,AGG_DESC_LABEL,GOVTYPE,GOVTYPE_LABEL,AMOUNT_FORMATTED&for=us:*&SVY_COMP=01
*Direct from https://www.census.gov/programs-surveys/school-finances.html
*Actual download page: https://www.census.gov/data/tables/2018/econ/school-finances/secondary-education-finance.html
**Sub in other dates down to 1992, though many pages only have the raw file (which is fine)
See also:
*Public Sector API docs:https://www.census.gov/programs-surveys/cog/technical-documentation.html
*https://www2.census.gov/programs-surveys/school-finances/tables/2018/secondary-education-finance/
*All fields available for all years through the API: https://api.census.gov/data/timeseries/govs?get=SVY_COMP,SVY_COMP_LABEL,GEO_ID,YEAR,AGG_DESC,AGG_DESC_LABEL,GOVTYPE,GOVTYPE_LABEL,AMOUNT_FORMATTED&for=u
Note that:
*Vermont has state FIPS code 50: https://www.nrcs.usda.gov/wps/portal/nrcs/detail/?cid=nrcs143_013696
*Lamoille County is CountyFP5 50015.
==Files==
Files are in E:\projects\stowehs
[[Visible to::whitelist]]
[[Visible to user::Ed]]