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
To view the variables and layout in DataFerrett, you will save this file to the folder TheDataWeb/FerrettTabulationFiles.
- To do this Right Click on this link
- Then select (browser dependent): Save Target As or Save Link Target As or Save Link As;
- Save this file into
your C:/TheDataWeb/FerrettTabulationFiles folder;
- 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"
- Start DataFerrett,
- Select File >
- Open >
- 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.