US Government Databases to study in ACCESS
Here are links to some US Government databases along with some information
on importing the data into ACCESS.
Your assignment is to find a database of suitable size and authority
on the web, free to use (e.g. from a US Government Agency), to answer important
questions.
report it with a pasted link via email to ba103 @ bud banis .com and
I will collect the list and add it to this page for everyone's use
report the name of the site, the link, and a brief description of the
data included and how it might be used -- for example, what important questions
might you seek an answer to by doing queries on the database?
YRBSS
CDC Youth Risk Behavior Surveillance System (YRBSS) database http://www.cdc.gov/nccdphp/dash/yrbs/
CDC Home http://www.cdc.gov
US Census 2000 data
http://www.census.gov/
Miscellaneous links related to importing Census data into ACCESS:
README File for Census 2000 Summary File 1 Delivered via FTP ftp://ftp2.census.gov/census_2000/datasets/Summary_File_1/0README_SF1.txt
Converting to ACCESS Census 2000 Summary File 1 ASCII
text data files http://www.census.gov/support/SF1ASCII.html
Miscellaneous support files for http://www.census.gov/support/2000/SF1/
International Data Base (IDB)
The International Data
Base (IDB) is a computerized data bank containing statistical tables
of demographic, and socio-economic data for 227 countries and areas of
the world.
Other Government Agencies:
CDC National Center for Health Statistics http://www.cdc.gov/nchs/
National Center for Health statistics NCHS Data Warehouse. http://www.cdc.gov/nchs/datawh.htm
National Institute of Allergy and Infectious diseases NIAID.NIH
NIH Health Information Database
Dietary Supplements Database IBIDS
Federal Consumer Information Center http://www.info.gov/
The National Climatic Data Center has weather data from around the
world. The website for this is: http://www5.ncdc.noaa.gov/pubs/publications.html
Other Places to find data:
Chance Course
The
Chance Database Welcome Page
Home of the Chance Course--"Scientific American
of Statistics" dedicated to promoting informed use of statistics in everyday
life, and especially in understanding of news articles in the popular press.
A vast treasure trove of materials from lesson plans to examples to online
movies about statistics in the practical everyday world
Statistics databases links at Prentice-Hall http://cwx.prenhall.com/bookbind/pubbooks/mcclave4/chapter11/deluxe.html
Database links found by course participants:
name of site: MedlinePlus http://medlineplus.gov/
Link: Consumer Drug Info
List drugs and uses
might be used to determine what medications are available and popularity
of medicine
--
http://www.drugabusestatistics.samhsa.gov/
This is samhsa.gov. It gives lots of stats about drug and alcohol.
http://www.dea.gov/stats/stats.htm
This is DEA.gov. It gives more stats about drug use and about
drug busts.
http://www.state.mo.us/cgi/htsearch.cgi
Here is a site with "tons" of surveys taken in Missouri.
http://www.fda.gov/opacom/campaigns/tobacco/compliancechecker.html
Site name= FDA's Children & Tobacco Compliance Checker Discription:
This site gives statistical data on the results of FDA's investigations
of tobacco retailers for compliance with FDA's age and I.D.laws.
Data is from Febuary 1997 to March 200o. We can use this data
to see how well these laws were renforced etc.
The name of the site is the official website of the Dept. of Defense
for the Anthrax Vaccine Immunization Program(a little scary if you ask
me).
I really like the setup of the web page it is very pleasing to look
at. And it is very easy to navigate through.
It includes all the information you would ever want to know about anthrax
like how big of a threat it is, how to get a vaccine, and a Q&A section.
Here is the web address http://www.anthrax.osd.mil/
It is a study done in 1991 called "National School-Based Youth
Risk Behavior Survey." Here is the link:
http://www.cdc.gov/nccdphp/dash/yrbs/00binaries/yrbs1991.pdf
I think it would be a good site in order to compare these stats with
other stats taken in the present time.
This data is about
Life Expectancy at Single Years of Age, United States, 1998 and Life
Expectancy at Birth, by Race and Sex, Selected Years 1929-98
http://www.cdc.gov/nchs/fastats/lifexpec.htm
One of the most powerful tools for understanding ourselves is the Enneagram,
an ancient symbol of unity and diversity, change and transformation.
The nine Enneagram personality types. Enneagram is "a geometric figure
that delineates the nine basic personality types of human nature and their
complex interrelationships." While the Enneagram suggests that there are
nine basic personality types of human nature, there are, of course, many
subtypes and variations within the nine fundamental categories.
Nevertheless, the assertion of Enneagram theory is that these nine
adequately map out the territory of "personality types."
http://www.enneagraminstitute.com/
This is the access point to the Goddard DAAC Climatology Interdisciplinary
Data Collection (CIDC). Monthly mean data from the atmospheric, oceanic,
and land use sciences have been placed on a common global map grid and
made accessible by FTP. http://daac.gsfc.nasa.gov/CAMPAIGN_DOCS/FTP_SITE/inter_disc.html
http://www.cfsan.fda.gov/~dms/pesrpts.html
FDA pesticide program residue monitoring
Results in these reports demonstrate levels of pesticide residues in
the U.S. food supply. We could use this to determine the amount of
residue we are consuming.
http://www.census.gov/csd/susb/usst99.htm
U.S. Census Bureau -Statistics of U.S. Businesses We could use the data
for the total amount of annual payroll for each state and compare them.
ftp://ftp.cdc.gov/pub/Data/YRBS/yrbs1990.dat
Name of the site"Youth Risk Behavior Surveillance system" Can be used
for predicting teenage behaviors,as well as changing them in the way most
suitable for society.
The US Patent Database This database is used to search through all of
the US patents. This is especially useful if you have an invention
in mind. Find dates, ideas, and descriptions of inventions.
http://patents.cos.com/
http://www.nal.usda.gov/fnic/foodcomp/
USDA NUTRIENT DATA LABORATORY
http://www.rcdb.com/
ROLLER COASTER DATABASE
Site Name: Data and Program Library Service
http://dpls.dacc.wisc.edu/catasto/cat_doc.html
The site contains a Census and Property Survey for Florentine Domains
and the City of Verona in Fifteenth Century Italy. Although the data
might not be extremely useful, it sounds interesting.
Site Name: Subcommittee on Census Data for Transportation Planning
Link: http://www.trbcensus.com/c2ss.html
The site contains information about how people get to work, the vehicles
available, and their travel time. The travel time might be useful
in vacation planning, or if you were new to an area.
http://www.nara.gov/
National Archives and Record Administration - NARA is an independent
Federal agency that helps preserve our nation's history by overseeing the
management of all Federal records.
http://www.usdoj.gov:80/dea/stats/drugsurvey.htm
This site talks about the teens and the use of drugs.
The Enneagram Institute is dedicated to the Work of human liberation
and transformation. This data base provides information on a geometric
figure that delineates the nine basic personality types of human nature
and their complex interrelationships. It is one of the most powerful tools
for understanding ourselves is the Enneagram, an ancient symbol of unity
and diversity, change and transformation.
http://www.enneagraminstitute.com/
Hockeyresearch is the site. It has pretty much all the hockey
leagues in the US and Canada with stats and standings from as far back
as 1917-1918. The link is http://www.hockeyresearch.com/stats/.
It could be used for many different things like winning your self a bet
with a friend. Information on a paper that your writting about how
the defense is getting so much better that the scoring in the NHL is down
from the early 90's.
I found a database of hockey statistics and many other things for almost
every professional league since that leauge started... It has lists
of every hockey card ever printed for every player.. It would be
extremely helpful with any project requiring hockey research...http://www.hockeydb.com/
Here is a site that is a useful database. The website address
is http://www.stat-usa.gov.
The name of the site is Stat-USA Internet. Some of the data includes
economic data and country analysis data that was interesting.
http://www.cdc.gov/nchs/fastats/divorce.htm
This is a break down of the divorces and marriages by state from 1996-1998.
HISTORICAL POVERTY TABLES
http://www.census.gov/hhes/poverty/poverty00/table5.html
This is a link showing poverty stats for 2000. You can search for percentage
of poor in each age class and their type of residence as well as a lot
more interesting stats about poverty in America.
http://www.nupd.com/ The national
unclaimed property database This site shows were unclaimed money from stocks
etc. goes.
http://www.fns.usda.gov/fns/
FNS increases food security and reduces hunger in partnership with
cooperating organizations by providing children and low-income people access
to food, a healthful diet, and nutrition education in a manner that supports
American agriculture and inspires public confidence.
http://www.umsl.edu/~s1041014/CHS9901.htm
Personal site containing statistics for the 1999, 2000, and 2001 Clayton
High School Water Polo team. Also includes a link to the excel file.
Can be used to sort player's stats by year, to see who scored the most
each year, or for general statistical calculations. Can also track
each player's progress through the years.
Here are a couple of links to government databases
that I have found very useful for research projects this semester. The
Department of Labor: http://www.dol.gov
and the Bureau of Labor Statistics: http://stats.bls.gov/
Both of these web-sites contain an enormous base of information in regard
to the U.S. economy. It might be interesting
to do a query on wages for specific sectors of the U.S. economy.
I hope that these might be useful for this project.
http://www.childinfo.org/eddb/mat_mortal/database.htm
Site name: unicef-Progress since the world summit for children
A brief description of this site:
This database contain the WHO/UNICEF/UNFPA estimates of maternal mortality
for 1995. The Maternal Mortality Ratio Data reported to UNICEF in connection
with the End Decade Assessment will be published on these pages at a later
date
Obviously sites like this are invaluable to scientists doing research
on anything from finding cures to human genetic diseases to pure
research on genetic expression. The www has increased the speed with
which scientific communication and sharing can take place, and thus accelerated
discovery.
http://bioinformatics.weizmann.ac.il/mb/db/human/detailed_list.html
http://www.ai.org/icpr/webfile/archives/life_pri.html
shows Life prisoners statements
I found this webpage that give great data
on law enforcement agents deaths thought out the years. It is on
the DEA webpage here is the link.
Drug Law Enforcement
Statistics
http://www.fbi.gov/ucr/cius_00/hate00.pdf
This site shows the brackgrounds of the hate crimes that have occured
in the year 2000. The list includes cities, counties, univeristies and
other agencies in that state (All 50 of them). It is a pdf format.
http://www.census.gov/population/censusdata/table-4.pdf
a census of urban and rural populations of the us from 1790-1990
http://sports.espn.go.com/ncaa/clubhouse?collegeId=158
This is Nebraska cornhuskers statistics for 2001.
This is a link to The United Nations Environment Program that has several
Database information that could be used with access. http://grid2.cr.usgs.gov/datasets/datalist.php3
> www.thetruth.com
> i picked this web site because i think the
> anti-smoking movement is an important one.
>
a link to a very useful database:
http://www.census.gov/population/censusdata/table-2.pdf
This site tells you how many people are living on how much land.
This is the website that I got the database from:
http://www.medicare.gov/Download/DownloadDB.asp
Here is my link to a good database:
www.eur.nl/fsw/research/happiness/hap_nat/nat_wdl.htm
when you get the link click on download and it should open!
The access link that i found for information that would be able to
be used
was www.nva.is/surveys/ The company does demographic
surveys and has
displayed the data here.
This site provides database for the annual emissions of the greenhouse
gases in the united states.
http://www.eia.doe.gov/oiaf/1605/1605a-db.html
Here is a good site for data on weather, temperatures, environmental
events,
etc. around the world. This data can be used to find climate
trends, El
Nino effects, and common factors for disasters that could help predict
them.
This is the National Weather Service http://www.nws.noaa.gov/
Here is a link to planned parenthood, I feel every one should be educated
on
the proper forms of birth control so that unwanted pregnancies aren't
a
problem. www.plannedparenthood.org
> >Infectious Disease WebLink
> >
> >I chose this website because I think that infectious diseases are
a huge
> >problem in the world today. Especially sexually transmitted diseases.
I
> >think everyone should be educated on the diseases that may impose
a
>threat
> >to the human race and us as individuals.
> >
>
>
>so what's the link? I want to add it to the page
>
>http://www.cdc.gov/ncidod/
>
http://www.cdc.gov/nchs/fastats/pdf/10199t66.pdf
this link is about chronic conditions by geographic location and place
of residence.
http://www.cfsan.fda.gov/~download/pes99db.html
found database on fda website
here's play off stats from last season
www.nfl.com/playoffstats
United States:
1998 Legislative Elections (Senate)
Name of the site:Political Database of the Americas
It can be used for like:
"Who got the most votes?"
"Which state got the most votes?"
http://www.georgetown.edu/pdba/Elecdata/USA/leg98.html
I chose to send you this because I think it is
interesting to find out the population amount in the
U.S. including business'
http://www.census.gov/
Here is a link that I think would some day be useful for an access
exercise/project.
It is http://www.cdc.gov/nccdphp/dash/yrbs/nchrbs.htm
I think that it might be interesting to future students because it
is on
adolescent and school health. It is a survey National College
Health Risk
Behavoir.
Over the years, I have engaged in considerable deep thought about (among
other things): Our place in the universe, ancient civilizations, human
migrations, international conflicts, local and world economics, ozone depletion,
the human genome, cloning, pollution, racism, local and world politics,
population growth, extinctions, natural disasters, the environment, health
care, the Internet, human relations, the space-time continuum and other
aspects of relativity, and other factors that affect mankind's struggle
to exist.
>
> After all of that deep thought, I have arrived at this conclusion:
When all is said and done, in spite of or because of what we may or may
not do or think, it is just as likely as not that, for better or for worse,
everything will turn out one way or another, sooner or later.
Other Tools:
Databases will probably be too big to carry around on floppy disk--use
your FTP account for storage and retrieval
download ws_ftp95LE.exe
Here is a freeware html ASCII editor for work on your webpages at the
html level
download html_note.zip html
ASCII editor
Download Winzip 8.1 shareware 1.7
MB
Return to BA103
last modified April 23, 2002 ~~ comments and suggestions to
rbanis@jinx.umsl.edu
Return
to Bud's Page
Go to UM-St. Louis Home Page
Go to UM-St. Louis School of Business Page