eBusinessGems.com
Description
Details
Collection of state symbols, figures and facts about all states of United States of America. There are 30+ information fields about each of the states.
Following information are available for each of the state:
01. ST
02. State
03. Capital
04. State Flower
05. Flower Scientific Name
06. State Bird
07. Bird Scientific Name
08. State Tree
09. State Motto
10. State Nickname
11. Land Area (Sq Miles)
12. WaterArea (Sq Miles)
13. Total Area (Sq Miles)
14. Time Zone
15. Time Zone Description
16. Bordering States
17. Highest Point
18. Highest Elevation (ft)
19. Lowest Point
20. Lowest Elevation (ft)
21. Mean Elevation (ft)
22. Date of Statehood
23. Population per Sq Miles
24. State Population (2015)
25. State Population (2010)
26. State Population (2000)
27. State Population (1990)
28. State Population (1950)
29. State Population (1900)
30. Popular Girl Name
31. Popular Boy Name
32. State Geo Center
The database can be used for personal use; learning or research purpose; or as content for application, blog or website.
Structure
Details
Field | Description | Data Type |
ST | State code | Char(2) |
State | Name of the state | Char(50) |
Capital | Capital of the state | Char(50) |
State Flower | State flower name | Char(50) |
Flower Scientific Name | Scientific name of the state flower | Char(50) |
State Bird | State bird name | Char(50) |
Bird Scientific Name | Scientific name of the state bird | Char(50) |
State Tree | State tree name | Char(50) |
State Motto | Motto of the state | Char(100) |
State Nickname | Nick name of the state | Char(100) |
Land Area (Sq Miles) | Area of land in suare miles | Long Integer |
WaterArea (Sq Miles) | Area of water in square miles | Long Integer |
Total Area (Sq Miles) | Total area of the state in square miles | Long Integer |
Time Zone | Time zone(s) of the state | Char(50) |
Time Zone Description | Time zonbe description(s) of the state | Char(50) |
Bordering States | Name of the bordering states | Char(100) |
Highest Point | Name of the highest point of the state | Char(50) |
Highest Elevation (ft) | Elevation of the highest point of the state in feet | Long Integer |
Lowest Point | Name of the lowest point of the state | Char(50) |
Lowest Elevation (ft) | Elevation of the lowest point of the state in feet | Long Integer |
Mean Elevation (ft) | Mean elevation of the state in feet | Long Integer |
Date of Statehood | Date of statehood | Char(50) |
Population per Sq Miles | Population of the state per square mile (2015) | Date |
State Population (2015) | Year 2015 State population | Long Integer |
State Population (2010) | Year 2010 State population | Long Integer |
State Population (2000) | Year 2000 State population | Long Integer |
State Population (1990) | Year 1990 State population | Long Integer |
State Population (1950) | Year 1950 State population | Long Integer |
State Population (1900) | Year 1900 State population | Long Integer |
Popular Girl Name | Popular girl name of the state | Char(20) |
Popular Boy Name | Popular boy name of the state | Char(20) |
State Geo Center | Geographic center location of the state | Char(100) |
Others
Additional Information
File Format | Tab Delimited Text, MS Excel 2003 Spread Sheet, MS Access 2007 Database | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Format Details | The data is available in TAB delimited Text file, Spreadsheet (MS Excel 2003) format, and Database (MS Access 2007) format. Other formats may be available on request. An additional fee may be applicable for additional file format. | ||||||||||||||||
Total Records |
50 states and 30+ information field for each of the states
|
||||||||||||||||
File Size | Approx 125 KB Zipped, 650 KB Unzipped | ||||||||||||||||
Additional Info |
Click here to download a sample state database.
|
||||||||||||||||
Keywords | us, state, symbol, figure, fact, flower, tree, bird, motto, nickname, land, area, water, highest, lowest, mean, elevation, population, density | ||||||||||||||||
Key Phrases | us states, states symbols, us state flowers, us state trees, us state birds, us state motto, us state nicknames, land area, water area, total area, highest point, lowest point, mean elevation, state population, population density, geographic center | ||||||||||||||||
Specific Terms and Condition |
|
Sample
Details
Click here to download a sample state database.