Data Analysis Tool For All

U.S. Census American Community Survey data at Census Bureau Data (https://data.census.gov)

• S1701 Poverty Status in the Past 12 Months
  • Contents: Poverty (<100%) counts and percentages by age, sex, race, educational attainment, employment status, and work experience, and population totals by poverty at various levels (including <125%, <200%, etc.).
  • Data Limitation: This table does not provide detailed demographic characteristics about the <125% poverty level population, but it does have data for all 5 counties, including counties with small populations.

1. Open Explore Census Data Census Bureau Data.
2. If you know you need the S1701 Poverty Status in the Past 12 Months table, type "s1701" in the search bar. If you do not know the table name, you may enter a search term, such as "poverty" to be taken to a list of relevant tables, including S1701.
3. Click on the S1701 table.
   
4. Click on +View All 25 Products under the table name.
5. Click on 2023: ACS 5-Year Estimates Subject Tables
   1. If your geographies have populations over 65,000 you may stay with the default 1-Year Estimates, which provide more current, but less reliable data or you may use 5-Year Estimates, which provide less current, but more reliable 5-year averages. If some or all of your geographies have fewer than 65,000 people, you must select 5-Year Estimates.
   2. For information about choosing 5-year or 1-year estimates, click here: Using 1-Year or 5-Year American Community Survey Data (http://census.gov/programs-surveys/acs/guidance/estimates.html)
      
6. Under Geographies in the far-left filter panel, select a geographic level, and click on it (In this example: geographic level is Census Tracts).
7. Select a state (Georgia in this example).
8. Click on all a county (in this example, Clayton County) then click on All Census Tracts within County (in this example, All the Census Tracts in Clayton County).
9. Click on the county name at the top to be taken back to the list of all counties in the state.
10. Repeat Steps 8 & 9 until you have added Census Tracts for all the counties in your service area (in this example, Census Tracts were added for Clayton, Cobb, DeKalb, Fulton, & Gwinnett counties).
    
11. Once all geographies have been added, click on close panel << button.
12. A message will appear saying that the table is too large to display. You may download the data, and/or you may click on Map (in this example, Map was clicked).
    
13. At the top left of the map, click on Population for whom poverty status is determined.
    1. Expand the dropdown menu. You may select from any of the demographic characteristics listed to map.
14. At the very bottom of the drop down, under Units, you may select # Number or % Percent (in this example, # Number was clicked).
15. You may select a specific poverty level (150 percent of poverty level in this example) or just above where you selected Units, you may Select Below poverty level-Estimate for the map's Dimensions to see the population below 100% of poverty.
    
16. Click on Colors.
17. Select you preferred color group in Sequential category.
    
18. Zoom in and move the map.
19. Drag the legend so that it's closer to the highlighted map.
20. Click on Boundaries button in the top ribbon.
    
21. Showing census tract numbers can clutter a map, uncheck the Boundary Label for Census Tract to remove the tract number label.
22. Zoom in and adjust the map as you prefer. You may want to adjust the Basemap, other Boundaries, Colors, and/or Classes.
23. Make sure the title across the top of the map refers to the field you intended to map. Having verified that, you may click on the pencil icon and edit the title.
    
     
24. You may screenshot the map, generate a shared link by clicking on the Share button, or generate a GeoJSON file by clicking on the GeoJSON button that may be added to Power BI, Mapbox, or other.