New, but spent a fair amount of time looking for county-level data for key measures. Not with detailed breakout (race and age etc.) Just wanted county-level highlights for key measures. There are some field dups between tables. I've downloaded the tables and ref docs and played with the data a bit. So I'm looking for the county with the highest UI, or lowest income, not by race or age just in general. I think this might be a good starting point. OK find the county with the highest level of poverty, go deeper with race, age, and more. Because you can't download "everything"
In any case, this represents some degree of effort that might be helpful to someone else. Just know I'm new and it's not 100%.
S0101 AGE AND SEXS1101 HOUSEHOLDS AND FAMILIESS1901 INCOME IN THE PAST 12 MONTHS (IN 2021 INFLATION-ADJUSTED DOLLARS)S2101 VETERAN STATUSS2501 OCCUPANCY CHARACTERISTICSS1701 POVERTY STATUS IN THE PAST 12 MONTHSS2701 SELECTED CHARACTERISTICS OF HEALTH INSURANCE COVERAGE IN THE UNITED STATESS1401 SCHOOL ENROLLMENTS2301 EMPLOYMENT STATUSS0201 SELECTED POPULATION PROFILE IN THE UNITED STATESB19055 SOCIAL SECURITY INCOME IN THE PAST 12 MONTHS FOR HOUSEHOLDSB19065 AGGREGATE SOCIAL SECURITY INCOME IN THE PAST 12 MONTHS (IN 2021 INFLATION-ADJUSTED DOLLARS) FOR HOUSEB05012 NATIVITY IN THE UNITED STATESB25003 TENURE (housing)B15001 SEX BY AGE BY EDUCATIONAL ATTAINMENT FOR THE POPULATION 18 YEARS AND OVERB25013 TENURE BY EDUCATIONAL ATTAINMENT OF HOUSEHOLDERB19057 PUBLIC ASSISTANCE INCOME IN THE PAST 12 MONTHS FOR HOUSEHOLDSB19058 PUBLIC ASSISTANCE INCOME OR FOOD STAMPS/SNAP IN THE PAST 12 MONTHS FOR HOUSEHOLDSB99087 ALLOCATION OF TIME ARRIVING AT WORK FROM HOME FOR WORKPLACE GEOGRAPHYCP02 COMPARATIVE SOCIAL CHARACTERISTICS IN THE UNITED STATESCP05 COMPARATIVE DEMOGRAPHIC ESTIMATES
OK, I have about 1/2 of the fields. Some are full numbers some are percent so a little adjustment is required, but overall a good set. The best I could get from Subject (S) tables, as the API format varies by table type. I hope I can finish the rest tomorrow. Again these are top-level measures by division, no race by age by ed etc. but age groups, race groups, ed groups.
api.census.gov/.../subject