[Music]
Hi, my name is Tyson.
In today's census data gem, I'll show you some of my favorite tricks to customize your
view on data.census.gov and download your tables.
In just a few, quick clicks, you can start having fun with census data.
Let's try it out.
You don't have to leave data.census.gov to start playing around with your favorite table
on the site.
Here we've pulled up, data profiles from The American Community Survey.
Once you're on the table results page on the right-hand side of your screen, you'll see
a button that says customize table.
Click in that to get to the full set of options to alter your view and customize your look
on data.census.gov.
To show you just a couple of quick things we can start clicking, the arrows on the left-hand
side.
To collapse parts of the table that we're not interested in viewing.
Here we can see some housing tenure data, which is data by owner versus renter housing
units from the American Community Survey.
A couple of things you can do on the top hand side, where it says "estimate" once we click
and hold and drag that off of our screen.
We can alter this, so we can see the percent owners versus percent renters in the United
States.
Also, you can drag the columns to expand or collapse so you can read the full labels.
Just make sure that you do it in the shaded area in the upper left.
If you'd like to work with this data outside of the site, there are a couple of different
options for how you can go about doing that.
In the table view, copying cells right-clicking, you can copy and paste that information into
Excel.
If you just want certain cells or you can export the entire table for smaller tables
to Excel or CSV.
To take a quick look, I've clicked export table and export to excel, that gives you
a download that looks like this.
A table view of that information, very similar to the same way it was laid out on the site
and your customizations do carry over from the export into the downloaded file.
Moving on to our second example here to show you other ways you can download data.
Particularly, if you want to have more flexibility with census data in programs outside of data
census.gov.
We have the flat-file format.
Here I've typed in B19013 median household income for all states.
I get that table for the total population, as well as the table ID's ending in A through
I repeated for a different race and ethnic groups.
My favorite way to download on data.census.gov is on the table results page next to the filter
button where it says download.
That allows you to select multiple tables at a time just clicking the checkboxes next
to each table title.
Until you have all the selections that you'd like to download.
Then once we're ready scrolling up to the top clicking where it says download selected
to; you can also download these tables across the 1 and 5-year estimates and across years.
I've selected the 2017 American Community Survey 1-year estimates, the CSV download,
and click download in the lower right.
Once we've done that, our pop up will load up to a 100 percent, and we'll click download
now; and then go through the process to open the zip file.
With your zip file, you'll get three separate items what you want is the titles with the
naming convention data with overlays.
Once that file has opened up this is what the data will look like, where each geography
is its own row, and all the estimates will carry over across that row.
Which may be different layout than the table view and data table census.gov.
These are my favorite tricks to customize tables on data.census.gov.
For more videos like this, please check out census.gov/academy and subscribe.
Thank you.
[Music]