How to access health indicator data at the census tract level from NEOCANDO
Here's a step-by-step guide to get you started
How to access health indicators data form NEOCANDO
You can obtain aggregated summary reports on many social and health indicators at the census tract level for Cleveland and Cuyahoga County municipalities at the NEOCANDO Data Warehouse.
You can obtain data from 1999-2006 by neigborhood, zip code, Cleveland ward or district, even to the census tract (when available.) Printed reports are available, and you can download data tables for use.
Example: Census Population
Use these steps to navigate through the site.
1) Go to http://neocando.case.edu/cando/fullDataReport/interface.jsp, the NEOCANDO portal
2) You are in the Social and Economic Data portal of NEOCANDO. Familiarize yourself with the box on the upper left (Data Access) and the selections on the left which are hotlinks to a selection and use guide, data dictionary (explaining variables and data sources), and even a tutorial.
3) Under "Subject Category, #1", select 'Population' option. (You may need to use the elevator bar at the right side of the selection window to see other options such as "Births", "Deaths", and crime data. More of that, later.)
4) Under window #2, 'Detailed Category" select the type of report of interest. There are nine different types of data reports based on census data. You can make multiple selections by holding the Shift key down and clicking the types of reports, or holding the CTRL button while you select the individual reports.
For our example, simply select the field, "POP-Total population, 1990 and 2000".
- For other options in window #2, NEOCANDO may provide you with a list of years where data are available. Under window #2b, select the years of interest, 1998-2006. You can select multiple years by holding the Shift key down and clicking the range of years, or holding the CTRL button while you select the individual years.
5) Under window #3, "Cuyahoga" is the default selection for Geographic Area/ County.
6) Under window #4, select the geographis level of interest (e.g. by city, neighborhood, district, zip code...census tract, too.) Depending on your choice in #4, you will have a more granular (more detailed) level of data in window #5, Geographic Entities and window #6, Report by Geography. Make your selections accordingly.
For our example, select "Census Tract" or make sure it is highlighted.
7) Selections under window #5, Geographic Entities, include a list of census tracts. Select single or multiple census tracts using the CRTL key and left-clicking your census tract selections with a mouse.
- "Report by Geography" defaults to Census Tract level. You may choose lower levels but, generally, few data are available below the census tract level.
When you've made your census selections, click the NEXT key at the bottom of the page.
8) The last page allows you to select the many different statistics available at the geographic levels you selected earlier. Make your single or multiple selections in the same way you did earlier. Data for 2000 is adequate. Once done, click get data,
You can see the data on your terminal, obtain Adobe .pdf print-ready reports, or even download the data. You can visualize your data in their interactive map tool, see charts of the data.
Select on of the four output options highlighted in gray fields above the report. Adobe .pdf reports will give you a simple hard copy of the data.
Export to Excel?
Once you're looking at your final data table, click "Download Menu" in the gray bar. You can download the data table into different formats
- Comma delimited table (.csv) that can be opened in Excel
- DBase IV (.dbf) table that can be used in geocoding software like ArcCatalog, ArcMap, ArcView, etc.
- SAS dataset (.sas7bdat)
- Excel file (.xls)
Try choosing the last selection by clicking the download option. You will be instructed to the location where you want the data.
Want other data?
You can use the back option in the file menu (or Backspace) to go back pages to choose alternative data. Select other indicator data from window #1. You will find that data are available at different levels
Try beginning at window #1, the "Subject Category"
- Don't forget to check the bottom of each output page for the suggestion citation format.
- Keep track of source attribution. This includes the URL where you found the material, the date last accessed and the date the data was last revised.
- Pay attention the units for each data field.
- Use the tutorial developed by MSASS to learn new methods and discover new data.
Keywords: Data Help, Health Info Portal, Open Access, Statistics