I need the following information for each US state: Area, recent
population, population 5-10 years ago, sales tax revenue, income tax
revenue, unemployment rate (traditional), % employed (literal,
estimated), % receiving some type of welfare benefit (ss, foodstamps,
subsidized housing, medicare, medicaid), number of new car sales some
year, number of home forclosures some year. The timepoint for each can
be different, but the same within an information type and all within
the last ten years. If one or two types need to be dropped because
they are stupid or too hard, lets comment and clarify. |
Request for Question Clarification by
rainbow-ga
on
15 Sep 2004 14:21 PDT
Hi iterative,
After several hours of research to compile the information you want,
here is an update on my progress.
As you are probably aware, there are not just one or two sites that
give you all the information you are seeking. What I have done so far
is I've gathered the sites I will need to compile the data. My
suggestion is inserting this data into an excel sheet for you to
download when completed.
I can provide you with the following:
1. Area - Land area, the year 2000 (square miles)
2. Recent population - for the year 2003
3. Population 5-10 years ago - for the year 1997
4. Sales tax revenue - Fiscal Year 2002
For this and the Income tax revenue, the table I have located shows
the Total in dollars and then the percentage of state tax collections
and distribution by source. Let me know which you prefer, the total in
dollars or percentage. If the dollar amount, I will have to calculate
each state's percentage to obtain the information.
5. Income tax revenue - Same as above with but the following addition:
The income tax revenue is separated into Individual and Corporate
Income. Please advise.
6. Unemployment rate - Unemployment rates, not seasonally adjusted,
taken in July 2004
7. % Employed - I have located a table which provides the total
Civilian labor force and the percent of labor force unemployed in June
2004. To arrive at the information you require, I will have to do the
math :)
8. % Receiving some type of welfare benefit - I have located a table
which contains the following information:
AFDC/TANF Recipiency Rates for Total Population by State for the year 2001.
(AFDC: Aid to Families with Dependent Children)
(TANF: Temporary Assistance for Needy Families)
I also located another table which gives the SSI (Supplemental
Security Income )Recipiency Rates by State for the year 2001. Please
advise.
I was unable so far to locate the last two pieces of information on your list.
Waiting to hear your views.
Best regards,
Rainbow
|
Clarification of Question by
iterative-ga
on
15 Sep 2004 20:20 PDT
Text file tab delineated is fine but Im really looking for the
sources. Do not bother doing any math, just replace with the
nonreduntant relevant source data. I will have to look into GA policy
for changing questions becuase I thought at least one of the last two
items would be readily found. I would very much like one of them at
least, and maybe replace the other with number of people incarcerated.
I have never heard of AFDC/TANF or SSI, I thought there was something
more uniform, total welfare spending by state, but I will look into it
so please pause on that. For tax you mean the total dollars per state
and then the percent that sales, individual income and corporate
income and others make up of that total? Then take it all. Total
income tax is ok but the breakdown is better. Thanks.
|
Request for Question Clarification by
rainbow-ga
on
16 Sep 2004 06:01 PDT
Hi iterative,
Correct me if I've misunderstood; you want the sources I have located
for the information you are seeking.
Regarding the number of new car sales by state, I have not been able
to locate this. However, I have located the number of new passenger
car and light truck registrations by state for the year 2003.
Would this information interest you?
Regards,
Rainbow
|
Clarification of Question by
iterative-ga
on
16 Sep 2004 07:45 PDT
I was under the impression that all answers (the data) came with
sources (evidence). This is a requirement. Yes I will take
registration in place of new car sales. I will decide on welfare
within 12 hours. Thanks.
|
Request for Question Clarification by
rainbow-ga
on
16 Sep 2004 08:06 PDT
Hi iterative,
Thank you for your clarification. You are correct in assuming all the
information gathered should be sourced. What I meant in my previous
clarification is do you only want the sources for the various data or
would you also like them compiled in an xls format?
Best regards,
Rainbow
|
Clarification of Question by
iterative-ga
on
16 Sep 2004 08:19 PDT
Data in a table, and sources at the bottom, tab delineated text file
or xls is fine. I just dont know how you get anything but text to me.
Thanks
|
Clarification of Question by
iterative-ga
on
16 Sep 2004 21:09 PDT
sorry Im late on the welfare. The problem is that I cant come up with
the answer or one like it but its practically the thesis of the data
collection. number of people living in subsidized housing. or number
of people on food stamps. or amount of money owed by individuals in
the sate (total debt). Or average credit rating. Average income. % of
total state population living in urban areas. What do you think?
Im sorry this is not as cut an dry as I thought it would be
iterative
|
Request for Question Clarification by
mathtalk-ga
on
16 Sep 2004 21:48 PDT
Just a suggestion, but how about people living below the "povery line"?
regards, mathtalk-ga
|
Clarification of Question by
iterative-ga
on
17 Sep 2004 05:41 PDT
eh. I guess Im more focused on dollar amounts. Fiscals. Amount spent
on unemployment would be pretty nice.
|
Request for Question Clarification by
rainbow-ga
on
17 Sep 2004 14:33 PDT
Hi iterative,
I have located the amount spent by state and local governments on
public welfare for the year 2000.
Would that suffice for the welfare benefits category?
Regards,
Rainbow
|
Clarification of Question by
iterative-ga
on
17 Sep 2004 15:53 PDT
that sounds very good.
|
