Community Profiles User Guide

7. Working with Tables

In Table View, each indicator has a table showing data for the latest year available. Each row breaks the data down into different groups, and each column compares your selected area to larger comparison areas. Table view shows all the indicators you’ve added, just like chart view. 

7.1. Interpreting the Data

7.1.1. Breakdowns (Rows)

Each row in a table shows the indicator for a different subgroup. The example below shows the table for the “Poverty” indicator.

The first row shows data for the data population. (Some indicators are not about people, but about buildings or parcels. In this case the first row would be data about all buildings or all parcels.) Read across this row to see that, in the selected area, there are an estimated 897 people in poverty, which is a 9 percent poverty.

The “Hispanic” row shows data about the hispanic population living in the selected area. Read across the to see that there are 42 Hispanic people in poverty in this area, which is a poverty rate of 29 percent. (There are 145 Hispanic people in the area, and 42 ÷ 145 is 29 percent.)

7.1.2. Count and Percent (Columns)

Columns labeled “Count” will show you the indicator as a numeral, whether this is how many people are in poverty, how many structures are vacant, or how much income the median household earns. So in the table below, we see that, in our selected area, 42 Hispanic people are in poverty and 174 Black people are in poverty.

There are two ways to calculate percent, either as a rate or as a percent of total. We’ll explain each one here, and below each table, we let you know how we calculated the percent columns in that table. (Our percent calculation never changes within the same table.)

Rate

Usually, the “Percent” column shows the rate for that specific row.

We calculate it like this:

Indicator for subgroup ÷ Total subgroup

For poverty in the Hispanic row, this means:

Number of Hispanic people in poverty ÷ Total number of Hispanic People

Our table shows that in our selected area, 29 percent of Hispanic people are in poverty, while 7 percent of Black people are in poverty.

Percent of Total

For certain indicators, like population, the percent column works differently. In this case we show a percent of the column’s grand total. So in this example, there and estimated 9,836 people living in our selected area. There are 406 Asian people, which is 4 percent of the total. This column won’t add up to 100 percent, because we don’t include all race categories.

Sometimes percent does not apply to an indicator (like age or income, for example). In these cases the “Percent” column is blank.

7.1.3. Comparison Areas (Column Groups)

 The first “Count” and “Percent” columns show data for the area you selected when you created your profile. We combine (or aggregate) all the areas you selected, and show you data about that combined area.

Where possible, we also give you data for comparison areas. Here’s how those comparisons work.

First, we show data for the county. This means we find the county where your selected area is located, and show the overall numbers for that county. If you choose areas that are in more than one county, we don’t show any data for this column group. If your selected area is itself a county, then “My Area” and “County” data will match exactly.

Next, we “zoom out” to the metro, or regional, level. We compare your area to the Indianapolis Metropolitan Statistical Area and find the average statistic for this 11-county area.

Finally, we compare your area to the statistics for Indiana overall.

7.2. Adding Data

You can add data to the Table View just like in the Card View. New tables always appear at the top of your profile.

Learn more about adding data.

7.3. Filtering Tables

You can use the search box at the top of the Table View to filter the data in all tables. Use this to search for population subgroups, and you will see the rows in each table that match your search.

In the example below, we entered “black” in the search box, and our tables were filtered to only show rows that contain the word “black”.

This search is a live filter. You don’t need to “submit” your search for it to work. Just start typing, and we’ll filter the tables based on what you’ve typed.