Ec228

Welcome to www.cMaxxSports.com

Some Handouts, Tools and Datasets

Stata, Excel & Wooldridge's Text

Excel Easy website
UCLA's IDRE: Tips for Excel ... More Tips
Keystroke Commands in Excel.pdf
Merging datasets in Excel and in Stata.pdf

Formatting Regression Output (eststo and esttab).pdf

t stat demo.xls
Statistical Dists - Normal, t, F, and ChiSq.xls

Slides for Wooldridge (Patricia Anderson) homepage 1 2 3 4 5 6 7 8 9 10 17 19
Wooldridge Datasets
Wooldridge Dataset Handbook

Data: Some data sources

NOAA weather data: online ftp site

Census Bureau links

Statistical abstracts of the US: 1901- 2012

2010s: 2010 2011 2012
2000s: 2000 2001 2002 2003 2004-2005 2006 2007 2008 2009
1990s: 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999
1980s: 1980 1981 1982-83 1984 1985 1986 1987 1988 1989
1970s: 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979
1960s: 1960 1961 1962 1963 1964 1965 1966 1967 1968 1969
1950s: 1950 1951 1952 1953 1954 1955 1956 1957 1958 1959
1940s: 1940 1941 1942 1943 1944-45 1946 1947 1948 1949
1930s: 1930 1931 1932 1933 1934 1935 1936 1937 1938 1939
1920s: 1920 1921 1922 1923 1924 1925 1926 1927 1928 1929
1910s: 1910 1911 1912 1913 1914 1915 1916 1917 1918 1919
1900s: 1900 1901 1902 1903 1904 1905 1906 1907 1908 1909
Program terminated 11Oct2011 (go figure). Prior years also available. Source

State and county datasets and links

Geocoded Data

US State Borders: kmz file Source:NOAA NOAA kmz file:link
US Mexico Border file (longitudes and latitudes): zipped dta xlsx
US County Centroids (longitudes and latitudes): home page 1990 2000 2012 2013 2014 2015 2016 2017

State Data

State Pops

state pops 1990 2014: zipped dta file xlsx sources: 1990's 2000's 2010's
state pops 2010 2019 (annual; by sex, age, race, hispanic): csv users manual Census link
NBER's state pops (by sex, age; zipped dta file): 1970-1999 2000-2014 NBER link
Urbanization, by decade (1900-2010): xls source: Iowa State
Metropolitan Area v. non-Metro - 1929 2017: zipped dta xlsx

Public Employment/Payroll... including police protection (by state year) (1996 /NA)

ASPEP Datasets and Tables 1992- 2021: here
ASPEP state and local level data, 1993-1995 1997-2016 (zipped csv file): here
... state level data, 1993-1995 1997-2016 (zipped csv file): here
... local level data, 1993-1995 1997-2016 (zipped csv file): here
Source: ICPSR
ASPEP state and local level data, 1944-2010 (zipped access file): here
... Employment FTEs, 1944-2010 (xlsx file): here
Source: Public_Emp

State per capita Personal Income

State pcPI 1929 2017: zipped dta xlsx
Source: BEA State Annual Personal and Employment data here

State (Un)Employment

... by year (csv format): 1960 - 2004 1976-2017
... by year/month (1976-2017): csv zipped dta
Source: BLS Local Area Unemployment Stats: homepage data

Census Data ... including Current Population Survey (CPS) data

Build your own data-table (seven yrs at a time)... CPS Table Creator
... or try the DataFerrett (works only with IE and Firefox... not with Chrome)
... or the American FactFinder

County Data

General sources...

US Census (no longer supported; lots of data): here
USDA ERS: here
NIH SEER: here
ICPSR (2000-07): here

Specific datasets and links

Median household income and Poverty rates (1989, 1993, 1995-2016) zipped dta file: here
Local Area Personal Income accounts: here (scroll down) and zipped dta file here (2MB)
(un)Employment data, annual (1990-2016; .txt and .xlsx formats): here and zipped dta file here (4MB)
... monthly data: scroll down to la.data.64.county ... and zipped files: xlsx dta footnotes.dta county fips
Educational attainment 1990 2005 (zipped files): dta ... xlsx
Poverty (SAIEP) 1989 2018 (zipped files): dta ... xlsx
Population (1990-2015; by age, sex, race, hispanic): here (NBER)

County Pops

... by age, sex and race

1990's (zipped): dta csv xlsx
2000's (zipped): dta csv xlsx
2010's (zipped): dta csv xlsx
Source: NERA Census U.S. Intercensal County Population Data by Age, Sex, Race, and Hispanic Origin here

Crime Data

DOJ/FBI Uniform Crime Reporting Statistics

UCR data: data tool
UCR state crime data (by state yr): xlsx ... and zipped dta files: levels and rates /100K
UCR county crime data - 1994 thru 2014 (by county yr; zipped): csv dta
UCR county arrest data - 1994 thru 2014 (by county yr; zipped): csv dta
FBI/UCR - Crime Data Explorer: here
Crime in the U.S., 2010-2019: 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019
Crime in the U.S., 2000-2009: 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009
Crime in the U.S., 1995-1999: 1995 1996 1997 1998 1999
Sources: guide files easy access

DOJ Prisoners Statistics (by state)

National Prisoner Statistics ... 1978-2015 zipped dta ... 2016 zipped dta
Sources: DOJ/BJS ICPSR

UCR Law Enforcement Employees (by city, county, state, etc)

Law Enforcement Employees Data, 1960-2021 (700K records): zipped csv
Source: Crime Data Explorer here (scroll down to Additional Datasets)

Datasets and .do files posted by Justin Wolfers

Donohue and Wolfers (2005) (multiple datasets): zipped
Dezbakhsh, Rubin and Shepherd (2003) (county level data 1977-1996): zipped
Katz, Levitt and Shustorovich 2003) (state-level data 1933-1990): zipped

Steven Levitt

Abortion on crime data (zipped file)

Steven Rafael

John Lott

Undocumented Immigrants and Crime

Other Datasets

Election Results - Sources

Princeton Library resources: link
MIT Election Lab data: link
Polidata Pres. Election Results by Cong. Districts (logins required): @Duke @Princeton
ICPSR (historical data): link1 link2

David Leap's Atlas: link
Links to state election offices: link
Daily Kos: link methodology data sets

Presidential Election Results - Some data

by State (1976-2020)

MIT Election Lab data: csv source

by Congressional District (1996-2020)

Daily Kos (2012-2020): xlsx source
Daily Kos (2008; old/new CDs): xlsx source
Daily Kos (2000-2008; 2006 CDs): xlsx source
Polidata (1996): xlsx source zipped pdfs

by Media Market (1980-2020)

Daily Kos data: xlsx source

Congressional Directory

116th Congress (2019-2020) v1 (July, 2020): txt source
115th Congress (2017-2018) v2 (Oct, 2018): txt source
115th Congress (2017-2018) v1 (July, 2018): txt source
114th Congress (2015-2016) v1 (Feb, 2016): txt source
113th Congress (2013-2014) v1 (Feb, 2014): txt source
112th Congress (2011-2012) v1 (Dec, 2011): txt source
111th Congress (2009-2010) v1 (Dec, 2009): txt source
110th Congress (2007-2008) v2 (Aug, 2008): txt source
110th Congress (2007-2008) v1 (Aug, 2007): txt source
109th Congress (2005-2006) v2 (Sept, 2006): txt source
109th Congress (2005-2006) v1 (July, 2005): txt source
108th Congress (2003-2004) v4 (Aug, 2004): txt source
108th Congress (2003-2004) v3 (Jan, 2004): txt source
108th Congress (2003-2004) v2 (Nov, 2003): txt source
108th Congress (2003-2004) v1 (July, 2003): txt source
107th Congress (2001-2002) v2 (Oct, 2002): txt source
107th Congress (2001-2002) v1 (Dec, 2001): txt source
106th Congress (1999-2000) v3 (Oct, 2000): txt source
106th Congress (1999-2000) v2 (Feb, 2000): txt source
106th Congress (1999-2000) v1 (June, 1999): txt source
105th Congress (1997-1998) v1 (June, 1997): txt source

Religions of House and Senate members (1993-2006): xlsx source

Coronavirus Data

Country I: Worldometers (html)
Country II: Our World in Data (xslx, csv & json)
Country III: WHO (csv)
US State & County I: New York Times (csv)
US State & County II: Johns Hopkins

Some datasets (Updated 4/20/2021)

Worldometer (country level): Excel(xlsx) Stata(dta)
Our World in Data (country level): Excel(xlsx) csv
NYTimes US (state level): csv
NYTimes US (county level): csv(zipped)

National Longitudinal Survey of Youth 1979

NLSY79: homepage cohorts
NLS Investigator (variable search/download): NLSY79 Search
NLSY79 (zipped dta files: nlsy_01 nlsy_02 nlsy_03 nlsy_04 nlsy_05 nlsy_06
.... append the six files; 16K variables; 01-05 have 2,500 records each; 06 has 186 records
Source: BLS NLSY79

Early Childhood Longitudinal Program (ECLS): Kindergarten-Eighth Grade Data

ECLS-K Child (K to 8; zipped dta file) data.zip !!Warning!! 332MB
... or: broken into 11 smaller files (zipped) 1 2 3 4 5 6 7 8 9 10 11
User Manuals (pdf format): Part 1 Part 2
... .do files: tabulates summaries
Source: NCES

Music (Charts) Data

Kworb: data FAQs
Spotify: charts
Billboard: charts

Movie Revenues Data

Box Office Mojo: data
The Numbers: data

FARS Highway Accident Fatality Data (1975 - 2017)

SWITRS data (2009 - 2014) (CA Highway Patrol Statewide Integrated Traffic Records System)

SWITRS accident data ('09-'14): zipped guide
SWITRS data access: link
CA Collision Data Summary (annual): 2009 2010 2011 2012 2013 2014
Caltrans - Annual Crash Data: link

The Beer Institute

The Brewers Almanac (2019): xlsx source

Bureau of Transportation

BTS Statistical products/data: link

Aviation Data Index: link
Airline Data Downloads: link
Origin and Destimation Survey Data: link
Ontime Performance data (by flight): big! datasets fields
Global Airport Database (IATA codes, cities, longitudes, latitudess, etc.): zipped csv source

Email: maxwellc@bc.edu