Please find all the cities (include state) in the USA with a
population between 3,000 and 10,000.  This data should be no older
than the year 2000.  Extra $20 if the data is input into Excel
spreadsheet.  Data should be entered with state, city, and population.
 NEED ASAP, PLEASE!

Hi kelp76!!


Thank you for asking to Google Answers.
I found the information that you need and I compiled it in an Excel
Spreadsheet after filtered from the large databases that includes all
cities and towns.
The source of information are the following tables:
- Tables 4: Annual Estimates of the Population for Incorporated Places
in each State, Listed Alphabetically: April 1, 2000 to July 1, 2003,
from Population Division, U.S. Census Bureau; release date: June 24,
2004.
"Population Estimates for All Places: 2000 to 2003 - Cities and Towns":
http://www.census.gov/popest/cities/SUB-EST2003-04.html

and
- Tables 5: Annual Estimates of the Population for Minor Civil
Divisions in some States, Listed Alphabetically Within County: April
1, 2000 to July 1, 2003 , from Population Division, U.S. Census
Bureau; release date: June 24, 2004.
"Population Estimates for All Places: 2000 to 2003 - Cities and Towns":
http://www.census.gov/popest/cities/SUB-EST2003-05.html							

I splitted the data in two different sheets, one for the incorporated
places that includes cities and towns and the other for the minor
civil divisions that includes townships, villages, and also town and
cities in some states, for more clear definitions see:
"Population Estimates Geography":
http://www.census.gov/popest/geographic/


You can download the spreadsheet from the following link:
http://www.geocities.com/artistaflores/City_Population.xls


Search strategy:
navigated the Census.gov site

I hope that this helps you. If you hava any trouble to get the file,
please just tell me using the clarification feature, I will gladly
respond your requests and/or try a different method to make the
spreadsheet available to you.
Note that I cannot send it to you via e-mail due Google Answers policies.

Best regards,
livioflores-ga

---

Request for Answer Clarification by kelp76-ga on 29 Dec 2004 07:50 PST

GREAT WORK!!  Thank you so much.  I did notice that 3 states are
missing (there are only 47).  What 3 states are missing and is there
any data on them?

---

Clarification of Answer by livioflores-ga on 29 Dec 2004 21:28 PST

Hi!!

I think that you are requesting info about Hawaii, Massachusets and Rhode Island.
I will clarify this:
- Massachusets: The info for Massachusets is all in the Minor Civil
Divisions sheet of the spreadsheet that I prepared for you because the
Census Bureau include minor cities in this category for census
purposes. The Massachusets' Incorporated Places are all cities larger
than 10,000 inhabitants. See:
"Annual Estimates of the Population for Incorporated Places in
Massachusetts, Listed Alphabetically: April 1, 2000 to July 1, 2003":
http://www.census.gov/popest/cities/tables/SUB-EST2003-04-25.xls
and
"Annual Estimates of the Population for Minor Civil Divisions in
Massachusetts, Listed Alphabetically Within County: April 1, 2000 to
July 1, 2003":
http://www.census.gov/popest/cities/tables/SUB-EST2003-05-25.xls


- Rhode Island: the same explanation is valid here, Rhode Island's
info is all in the Minor Civil Divisions sheet of the spreadsheet that
I prepared for you because the Census Bureau include minor cities in
this category for census purposes. The Rhode island's Incorporated
Places are all cities larger than 10,000 inhabitants. See:
"Annual Estimates of the Population for Incorporated Places in Rhode
Island, Listed Alphabetically: April 1, 2000 to July 1, 2003":
http://www.census.gov/popest/cities/tables/SUB-EST2003-04-44.xls
and
"Annual Estimates of the Population for Minor Civil Divisions in Rhode
Island, Listed Alphabetically Within County: April 1, 2000 to July 1,
2003":
http://www.census.gov/popest/cities/tables/SUB-EST2003-05-44.xls


- Hawaii: here the Census Bureau has divided Hawaii as several CPD
(census-designated place). Hawaii is the only state that has no
incorporated places recognized by the U.S. Census Bureau below the
county level. All data for places in Hawaii reported by the Census are
CDPs. This is why the info about Hawaii places is missing from the
source dataset. I researched further about Hawaii at Census Bureau and
found the following table:
"Census 2000 Data for the State of Hawaii - Population, Housing Units,
Area, and Density: 2000":
http://factfinder.census.gov/servlet/GCTTable?_bm=y&-geo_id=04000US15&-_box_head_nbr=GCT-PH1&-ds_name=DEC_2000_SF1_U&-format=ST-7&-mt_name=DEC_2000_SF1_U_GCTPH1_ST2

Then I extracted from the above table the list of places of Hawaii
with a population between 3,000 and 10,000, here is the result of that
work:
Ahuimanu CDP, Honolulu County	         8506
Aiea CDP, Honolulu County	         9019
Captain Cook CDP, Hawaii County	         3206
Ewa Gentry CDP, Honolulu County	         4939
Ewa Villages CDP, Honolulu County         4741
Haiku-Pauwela CDP, Maui County	         6578
Hanamaulu CDP, Kauai County	         3272
Hauula CDP, Honolulu County	         3651
Hawaiian Beaches CDP, Hawaii County       3709
Hawaiian Paradise Park CDP, Hawaii County	 7051
Heeia CDP, Honolulu County	         4944
Hickam Housing CDP, Honolulu County	 5471
Holualoa CDP, Hawaii County	         6107
Kailua CDP, Hawaii County	         9870
Kalaheo CDP, Kauai County	         3913
Kalaoa CDP, Hawaii County	         6794
Kapaa CDP, Kauai County	                 9472
Kekaha CDP, Kauai County	                 3175
Lahaina CDP, Maui County	                 9118
Laie CDP, Honolulu County	         4585
Lanai City CDP, Maui County	         3164
Lihue CDP, Kauai County	                 5674
Maili CDP, Honolulu County	         5943
Makaha CDP, Honolulu County	         7753
Makawao CDP, Maui County	                 6327
Maunawili CDP, Honolulu County	         4869
Napili-Honokowai CDP, Maui County	 6788
Pukalani CDP, Maui County	         7380
Pupukea CDP, Honolulu County	         4250
Village Park CDP, Honolulu County	 9625
Waialua CDP, Honolulu County	         3761
Waihee-Waiehu CDP, Maui County	         7310
Waikoloa Village CDP, Hawaii County	 4806
Wailea-Makena CDP, Maui County	         5671
Wailua Homesteads CDP, Kauai County	 4567
Waimanalo CDP, Honolulu County	         3664
Waimanalo Beach CDP, Honolulu County	 4271
Waimea CDP, Hawaii County	         7028
Waipio Acres CDP, Honolulu County	 5298
Whitmore Village CDP, Honolulu County	 4057

I also added a sheet to your spreadsheet named Hawaii places that
contains the above info. Please download the updated spreadsheet from:
http://www.geocities.com/artistaflores/City_Population.xls


I hope that this helps you. Please do not hesitate to use again the
clarification feature if you need it.

Regards.
livioflores-ga

Fast response and exactly what I wanted.  Great work!  I will
definitely use Google answers again because of this experience.