Legacy Data Download

Updated 2 months ago by Phil Vu

Users can download consistently-formatted CSV files any publicly available datasets. Simply add data to the Map or Table to get started.

Here is a quick video on using the Data Download:


The Download Data popup has 3 simple steps:

Step 1 lets you choose what type of data you want to download. This list is based on what data you have already loaded before opening the Download Data box.

Step 2 lets you select the area to download data for. This can be pre-defined locations like states, counties, or congressional districts, or can be custom regions. This step also lets you choose the geography

Step 3 confirms the data to be downloaded.

There are 3 different types of data that can be downloaded:

Layer: Data representing geographies like census tracts, counties, and states.

Points: Address/location level data.

Points with Layer Data: The ability to find the geography and layer data for the geography each points sits in.


Download Layers

  • Step 1 shows the data layer, the variable, and year.
  • Select Next.
  • Step 2 lets you choose the area to download data for. This is the extent within which data will be provided. If you had a location selected and/or custom region loaded on the Maps, Tables, or 3-Layer Maps page, that will be shown in Step 2. Otherwise, use the Add button to select a pre-defined location or a saved Custom Region. Or use the Change button to access the Location bar to change locations.
    • Once a location is listed, select the geography type of the data using the Shaded By menu.
    • The Shaded By menu allows users to download data for the data layer for any available geography equal to or smaller than the location.
    • For example, if Pennsylvania is listed, users can download data for the state or all the way down to all the block groups within the state, depending on the indicator.
    • You can download data for the entire country by entering "United States" in the Location search.
  • Select Next.
  • Step 3 displays a complete sentence which describes:
    • the data that is being downloaded,
    • year or time frame,
    • geography type that the data will be shown at, also called the Shade By,
    • the location or area for the download.
  • Select Download CSV.
 At any time, users can go back to any of the previous steps. Go to Step 1 to change what data to download or go to Step 2 to change the area and geography type to download.

If users need data for additional years or variables from the data layer, after downloading the file, close the data download box, change the year or variable in the legend, and repeat the data download steps.

Layer data downloads will show the geography, the FIPS code for that geography (if available), the indicator values, the source of the data, and the area that the data was generated for. A column called "Formatted FIPS" is available so the codes are displayed correctly in Microsoft Excel.


Download Points

  • Step 1 shows the point dataset. Because users can have multiple point datasets loaded, users might see a list of datasets to choose from. If filters were set, it will note that it is filtered.
  • Select Next.
  • Step 2 lets you choose the area to download data for. This is the extent within which data will be provided. If you had a location or custom region loaded on the maps, tables, or 3-Layer Maps, that will be shown in step 2. Otherwise, use the Add button to select a pre-defined location or a saved Custom Regions. Or use the Change button to access the Location bar to change locations.
Please note: There is not a Shaded By option similar to Layers since you are simply downloading all the points within an area.
  • Select Next.
  • Step 3 displays a complete sentence which describes:
    • the point dataset
    • the area to download
    • If there was a filter used, then the text below will display the filter.
  • Select Download CSV.

At any time, users can go back to any of the previous steps. Go to Step 1 to change what data to download or go to Step 2 will change the area to download.

Point dataset downloads give users all the data for each address, the source of the data, and the area the data was generated for.


Points with Layers

To start, add a point dataset and set any filters if needed, then add a data layer and choose the year and variable to download, and then select the download icon from the share buttons.

  • Step 1 shows the data layer and point dataset to download data for.
    If you have multiple point datasets loaded, you must select one.
  • Select Next.
  • Step 2 lets you choose the area to download data for. This is the extent within which data will be provided. If you had a location and/or custom region loaded on the Maps, Tables, or 3-Layer Maps, that will be shown in Step 2. Otherwise, use the Add button to select a saved Custom Region. Or use the Change button to access the Location bar to change locations.
    • Once a location is listed, select the geography type of the data using the Shaded By menu.
    • The Shaded By menu allows users to download data for the data layer for any available geography equal to or smaller than the location.
    • For example, if Pennsylvania is listed, users can download data for the state or all the way down to all the block groups within the state, depending on the indicator.
    • You can download data for the entire country by entering "United States" in the Location search.
    • If you are downloading Points with Layers for block groups, the largest area you can download data for is a state. If you have a custom region larger than a state, it will require you to reduce the location to a state.
  • Select Next.
  • Step 3 displays a complete sentence which describes:
      • the data layer that is being downloaded,
      • year or period of years,
      • the point dataset,
      • geography type that the layer data will be shown at, also called the Shaded By,
      • area for which you are downloading data.
  • Select Download CSV.

 

Due to the size and processing time of the Points with Layer Data download, these files will be emailed to you, and a copy will be saved in your My Saved Work.

At any time, users can go back to any of the previous steps. Go to Step 1 to change what data to download or go to Step 2 to change the area and geography type to download.

Points with Layer Data downloads will display the geography, the FIPS code (if available), all the data for the point dataset, the values of the layer data indicator where the point is in, the source of the data layer and points, and the location the data was generated for. A column called "Formatted FIPS" is available so the codes are displayed correctly in Microsoft Excel.

With the Download Data tool, you can download data for the nation, download block group (and sometimes even block level) data, find FIPS codes for layer data so that files can be easily used in complementary data visualization and mapping tools, and much more.

If you have any questions or want to lean more, visit our training calendar and attend a free session or contact us at any time.


How did we do?