TheDataWeb  

A collaboration between the U.S. Census Bureau and the Centers for Disease Control     

DataFerrett Aggregate Data Example Queries

Below please find example(s) of Aggregated data queries. More are currently under construction and will be added soon.

US Children Living in Poverty

This example shows 2 different uses of the 1999-2000 Decennial Census of Population and Housing, Summary File 3 dataset. It will depict the population by all US counties with children in their household under the age of 18 living below the poverty level. The second example selects only the state of Alabama. Please note that at this time Pureto Rico, Hawaii and Alaska have been excluded due to geographical constraints within DataFerrett.

To view the variables and layout in DataFerrett, you will save this file to the folder TheDataWeb/FerrettTabulationFiles.

1. To do this Right Click on this link sf3_children_in_poverty.ftf;
2. Then select (browser dependent): Save Target As or Save Link Target As or Save Link As;
3. Save this file into your C:/TheDataWeb/FerrettTabulationFiles folder;
   
   
4. Make sure to save the file by selecting the Save As Type: (at the bottom of the popup Save window). It should indicate "All Files"
   
   
5. Start DataFerrett,
6. Select File >
7. Open >
8. Select the "CPS_poverty.ftf" file

In DataFerrett the .ftf file will automatically open a Ferrett Tabulation screen. To retrieve the data to replace the (?) Question Marks, select the green Go Get Data button to see the data selected/extracted for this example. You can double click on each variable listed (on the right) to view a description of the variable and their values. You can also add more variables, by going to Step 1 of DataFerrett.

2005cpsbasic_education.ftf

Microdata Examples of CPS Poverty DataFerrett Queries

Last update: 7/29/05