County level educational attainment data from year 2000-2021

[Tariq Abdullah]

Hello everyone,

This is not exactly a stata related question rather than a data relevant question.

I need. help finding data at county level from year 2000-2021 for educational attainment in usa. I know seer is a good source for finding data at county level. (https://seer.cancer.gov/seerstat/var...bs/static.html )

However, to find educational attainment I need to rely on 5 year average estimates from ACS (2007-2011 2008-2012, 2013-2017, 2017-2021). The rest of the year left (2000-2007 , decennial data) can be found from here (https://seer.cancer.gov/seerstat/var...ic.html#ca2000).

Though, they are showing me the county attributes, I' not sure from where I can get the data for educational attainment.

Can anyone kindly tell me who has personal experience dealing with specific dates where can I get this educational attainment data for the above mentioned timeframe ??

[George Ford]

You want the mean over the entire period? Annually? 5-year averages?

[Tariq Abdullah]

annually at county level would be my priority.

However, I can also do this with 5 year-average if annually is not feasible. I have struggled a lot finding demographics data at county level annually, and I have seen a lot of published papers have used data for five year average from ACS data. Therefore, if annual at county level is not possible, I'm more than fine with 5 year average for the timeframe from 2000-2021

[George Ford]

I don't think Census provides the data annually, and it will change by a trivial amount on an annual basis.

Why not use 2000/2010/2020 census? Could interpolate between if really need annual data. NHGIS will get you that easy.

[George Ford]

This should do it. Easy.

https://www.ers.usda.gov/webdocs/DataFiles/48747/Education.xls

[Tariq Abdullah]

thanks so much for guiding me! Highly obliged for this valuable input and mentoring!

[George Ford]

You can interpolate to each year (ipolate). They change so little it won't matter a whole lot.