 Database
Question Worksheet
Kentucky
Counties Database Questions
Name(s)________________________
Date________________________
Sorting
1. Which county has the largest area?
2. What two counties have the largest
population?
3. What is the county seat of the
county with the lowest yearly reported crime rate?
4. What is the area of the county with
the lowest population level?
5. What is the region of the county
with the third highest population?
6. What is the population of the county with the highest reported total
earnings?
7. Which county has the most income
from farming?
8. What is the county seat of the
county with the most income from industry?
9.
Which three counties have the
lowest population levels?
10. What is the population of the county
with the lowest area?
Searching (One Criterion)
1.
How many counties have a crime
rate less than 200 per year?
2.
Which counties have more than
$10,000,000 in total earnings?
Which counties have less that
$30,000 in total earnings?
3.
How many counties
are in each region? (Remember some counties are in more than one region.)
Bluegrass:
Cumberland: Eastern Coal Field:
Jackson
Purchase: Knobs:
Western Coal:
Pennyroyal:
4. Which counties have no income from
industry?
5. What are the county seats of the counties with no income
from industry?
6. What is the population range of the counties with more than
one civil war site?
7. What is the
range in area of the counties with an industry income more than $50,000?
8.
What is the range in crimes per
year for the counties with total earnings under $50,000?
9.
Search for the counties whose
total population is greater than 40,000. What is the region and county seat of
these counties with the largest African American population?
10.
What is the population of the
county with an average of 2.2 autos per household?
11. How many counties have at least one hospital?
Searching (Multiple Criterion)
1.
What county has a reported crime
rate greater than 4000 per year and an area less than 200 square miles?
2.
Which are the county seats of
the counties with total earnings greater than $100,000 and a population greater
than 80,000?
3.
What is the largest crime rate
of the Western Coal counties with at least one hospital and average of more than
1.5 autos per household?
4.
For the county with a reported
crime rate higher than 30,000 per year and a population greater than 650,000,
which is higher: farm earnings or industry earnings?
5.
Which county has a covered
bridge and a civil war site?
6.
How many counties have a covered
bridge or a civil war site?
7.
Which Eastern Coal counties
have report 1.6 autos per household and total earnings less than $50,000?
8.
Which regions are
represented by the counties that have more than one hospital and a civil war
site?
9. What are the county seats of the Pennyroyal counties with
reported crime rates more than 400?
10. What are the total earnings for counties
that have farm earnings more than $30,000 and at least one hospital?
Kentucky Counties Database Questions Answer Key
Sorting
1.
Which county has the largest
area? Pike; (Sort on the Area Field, Answer in
County field)
2. What two counties have the largest
population? Jefferson and Fayette; (Sort on the
Population Field, Answer in County field)
3. What four counties have the lowest
yearly reported crime rate? Christian,
Robertson, Wolfe, Carlise; (Sort on the Crime Per Year Field, Answer in County
field)
4.
What is the area of the
county with the lowest population level? 443;
(Sort on the Population Field, Answer in Area field)
5. What is the region of the county
with the third highest population? Bluegrass; (Sort
on the Population Field, Answer in Region field)
6. What is the population of the
county with the highest reported total earnings?
670,837; (Sort on the Total Earnings Field, Answer in Population field)
7. Which county has the most income
from farming? Kenton; (Sort on the Farm Earnings
Field, Answer in County field)
8. What is the county seat of the
county with the most income from industry?
Louisville; (Sort on the Industry Earnings Field, Answer in County Seat field)
10.
Which three counties have
the lowest population levels? Trigg, Robertson,
Minifee; (Sort on the Population Field, Answer in County field)
10. What is the population
of the county with the lowest area? 5678; (Sort on
the Area Field, Answer in Population field)
Searching (One
Criterion)
1. How many counties have a crime rate less than 200 per year?
53; (Filter by Form: type <200 in Crimes Per Year
field, click Filter, answer in number of filtered records at the bottom)
2. Which counties have more than $10,000,000 in total earnings?
Jefferson;
(Filter by Form: type >10000000 [no commas] in Total Earnings field, click
Filter, answer in County field)
3. Which counties have less that $30,000.00 in total earnings?
Johnson, Kenton, Roberston, Menifee, Owlsely,
Elliott, Gallatin, Carlise, Spence, Wolfe; ;
(Filter by Form: type <30000 [no commas] in Total Earnings field, click
Filter, answer in County field)
4.
How many counties are in each region?
Bluegrass
35; (Filter by Form: type Like *Blue* in Region
field, click Filter, answer in number of filtered records at the bottom)
Cumberland 3; (Filter by Form:
type Like *Cumber* in Region field, click Filter, answer in number of
filtered records at the bottom)
Eastern Coal Field? 27; (Filter
by Form: type Like *E. Coal* in Region field, click Filter, answer in
number of filtered records at the bottom)
Jackson Purchase 9; (Filter by
Form: type Like *Jackson* in Region field, click Filter, answer in number
of filtered records at the bottom)
Knobs 7; (Filter by Form: type
Like *Knobs* in Region field, click Filter, answer in number of filtered
records at the bottom)
Pennyroyal 27; (Filter by Form:
type Like *Penny* in Region field, click Filter, answer in number of
filtered records at the bottom)
Western Coal 12; (Filter by Form:
type Like *W. Coal* in Region field, click Filter, answer in number of
filtered records at the bottom)
5. What are the county seats of the counties with no income
from industry? Booneville, Mt. Olivet; (Filter by
Form: type 0 in Industry Earnings field, click Filter, answer in County Seat
field)
6. What if the population range of the counties with more than
one civil war site? 15,487 - 44,038; (Filter by Form:
type >1 in Civil War Site field, click Filter, sort the Population field and
record highest and lowest values)
7.
What is the range in area of the
counties with an industry income more than $50,000?
130 721; (Filter by Form: type >50000 [no commas] in Industry Earnings
field, click Filter, sort the Area field and record highest and lowest values)
8.
What is the range in crimes per
year for the counties with total earnings under $50,000?
6 6925; (Filter
by Form: type <50000 [no commas] in Total Earnings field, click Filter, sort
the Crimes Per Year field and record highest and lowest values)
9.
Search for the counties whose
total population is greater than 40,000. What is the region and county seat of
these counties with the largest African American population?
Bluegrass, Louisville; (Filter
by Form: type >40000 [no commas] in Population field, click Filter, sort the
Blacks field, answers in the Region field and County Seat field)
10.
What is the population of the
county with an average of 2.2 autos per household?
36461; (Filter by Form: type 2.2 in
Autos Per Household field, click Filter, answer in Population field)
11. How many counties have at least one hospital?
78; (Filter by Form: type >0 in Hospitals field,
click Filter, answer in number of filtered records at the bottom)
Searching (Multiple Criterion)
9.
What county has a reported crime
rate greater than 4000 per year and an area less than 200 square miles?
Kenton; (Filter by Form: type >4000 in Crimes Per Year field and type
<200 in Area field, click Filter, answer in County field)
10.
Which are the county seats of the counties with total earnings
greater than $100,000 and a population greater than 80,000?
Louisville, Lexington,
Elizabethtown; (Filter by Form: type >100000 [no commas] in Total Earnings
field and type >80000 [no commas] in Population field, click Filter, answer in
County Seat field)
11.
What is the largest crime rate
of the Western Coal counties with at least one hospital and average of more than
1.5 autos per household? 3275;
(Filter by Form: type >0 in Hospital field,
type W. Coal in the Region field, and type >1.5 in Autos Per Household
field, click Filter, sort the Crimes Per Year, answer in Crimes Per Year field)
12.
For the county with a reported
crime rate higher than 30,000 per year and a population greater than 650,000,
which is higher: farm earnings or industry earnings?
Industry earnings; (Filter by Form: type >30000 in Crimes Per Year field and
type >650000 in the Population field, click Filter, look at farm and industry
earnings to determine highest level)
13.
Which county has a covered
bridge and a civil war site? None; (Filter by Form:
type >0 in Civil War Site field and type >0 in Covered Bridge field, click
Filter, answer in County field)
14.
How many counties have a covered
bridge or a civil war site? 19; (Filter by Form: type
>0 in Civil War Site field; click the OR tab at the bottom of the window, and
type >0 in Covered Bridge field, click Filter, answer in number of filtered
records at the bottom)
15.
Which Eastern Coal counties
have report 1.6 autos per household and total earnings less than $50,000?
Elliot, Meniffe, Owsley, McCreary, Wolfe; (Filter by Form: type 1.6 in
Autos Per Household field, type E. Coal in the Region field, and type <50000
in Total Earnings field, click Filter, answers in County field)
8.
Which regions are represented by the counties that have more than one hospital
and a civil war site? Cumberland Plateau, Jackson
Purchase, Knobs; (Filter by Form: type >1 in Hospital field and type >0 in
Civil War Site field, click Filter, answers in Region field)
9. What
are the county seats of the Pennyroyal counties with reported crime rates more
than 400? Bowling Green, Elizabethtown, Somerset,
Russellville; (Filter by Form: type Like *Penny* in Region field and type
>400 in Crimes Per Year field, click Filter, answers in County Seat field)
10. What
are the total earnings for counties that have farm earnings more than $30,000
and at least one hospital? Kenton $131441; Woodford
$351769; Oldham $261197; Scott $370476; Bourbon $154646; (Filter by Form: type
>0 in Hospital field and type >30000 in Farm Earnings field, click Filter,
answers in Total Earnings field)
| 
