Key fields to tables for ACS-1 (any help is appreciated) Poverty and Ed level college or higher

I am trying to find county level data for approx 20 fields. I really want to map each field to a simple table with as little extra (race etc.) data as possible. It's not the best method but will help me learn and understand and more easily check my numbers. I assume there's no such reference here. I've spent over a day trying to figure out what fields I want and hopefully find the tables. For example Own\Rent=B25003, Food Stamps=B19058, Public Assist=B19057, Stamps or Pub Assist= B19058, Disability=C18101?, Household Size= S2501 Foreign Born=B05012.   I am somewhat confused on a few items and any help on Poverty and Education level would be appreciated. So, Poverty and Official Poverty? and somewhat confusing elements on education and why the over 25? Many people finish college before 25?

  • So, I think I want the official poverty =? table (county level but as simple as possible)
  • Ed level college or higher all ages (I guess the best one is over 18) =?table county level but as simple as possible)

Once I get all this data and have a decent understanding of the tables, I think I'll move to pulling the data in an API (perhaps this weekend), but I really want to see and understand the tables directly first.

If anyone's interested I have the worlds best list and ranking of Medical journals with key info pulled from PubMed at;

https://public.tableau.com/app/profile/tom.lahey/viz/PubMedJournalRanking2021/PubMed_Ranking?publish=yes

Thanks in advance.

Tom

Parents
  • Yes, there are lots of tables from the ACS, and it can be difficult finding what you need.  This link contains another link to an excel spreadsheet of all the table shells. https://www.census.gov/programs-surveys/acs/technical-documentation/table-shells.html  I went there to find these two tables: B15001 (covers educational attainment for the population `18 years and older); B17003 (covers poverty status by educational attainment).

    I believe the reason for most educational attainment tables restricting the table universe to 25 years and older is to include many (most?) of the people with advanced degrees.

    I hope this helps.

    Doug Hillmer

Reply
  • Yes, there are lots of tables from the ACS, and it can be difficult finding what you need.  This link contains another link to an excel spreadsheet of all the table shells. https://www.census.gov/programs-surveys/acs/technical-documentation/table-shells.html  I went there to find these two tables: B15001 (covers educational attainment for the population `18 years and older); B17003 (covers poverty status by educational attainment).

    I believe the reason for most educational attainment tables restricting the table universe to 25 years and older is to include many (most?) of the people with advanced degrees.

    I hope this helps.

    Doug Hillmer

Children
No Data