Data Files & UPDATES

Below you will find links to the spreadsheets, raw data files, and other relevant sources (where available) corresponding to the tables, figures, and maps in Bulls Markets. You will also find updates that clarify certain aspects of the book’s analysis in light of information obtained since its publication. If you discover any errors/inconsistencies, let me know; and I’ll make a note below.

Tables

Table 1.1

Selected Employment and Population Statistics, City of Chicago, 1950 — 1990

Data spreadsheet (.xlsx)

County and City Data Book(s) (link)

Table 1.2

Downtown Population Change, Major Midwestern Cities, 1980 — 2000

Data spreadsheet (.xlsx)

Birch, Eugenie. Who Lives Downtown. Washington, D.C.: Brookings Institution, 2005. (PDF)

Table 1.3

Table 1.4

Estimated Combined Festival Attendance, Chicago City, 1993 — 1999

Data spreadsheet (.xlsx)

Table 1.5

Table 2.1

Table 2.2

Venue-Related Revenues (Millions of 1996 Dollars) for Chicago Bulls and Chicago Blackhawks, 1992 — 1996

Data spreadsheet (.xlsx)

”NBA Income and Expense Data,” Rodney Fort’s Sports Business Data (link)

”NHL Income and Expense Data,” Rodney Fort’s Sports Business Data (link)

Update (06/17/2019): In the text that discusses this table on p. 61 (located at the bottom of the paragraph that beings, “Jerry Reinsdorf and Bill Wirtz…”), the phrase “earnings from suite rentals” should read “revenues from suite rentals”.

Table 2.3

Team Marketing Report “Frugal Fan Index,” 1995 — 1996 to 1998 — 1999

Data spreadsheet (.xlsx)

Original Team Marketing Report Data obtained from the LA84 Library (PDF)

Table 2.4

Comparison of Changes in Chicago Bulls Player Salaries (Total) and Average Ticket Price, 1995 — 1996 to 2004 — 2005

Data spreadsheet (.xlsx)

”NBA Ticket Price Data,” Rodney Fort’s Sports Business Data (link)

BasketballReference.com salary data (PDF)

Table 3.1

Selected Demographic Data for Chicago’s Near West Side Community Area, 1940 — 1990

Data spreadsheet (.xlsx)

Table 3.2

Table 4.1

Direct Neighborhood Investment by United Center Ownership

Data spreadsheet (.xlsx)

Table 4.2

Public Investment in Support of the United Center

Data spreadsheet (.xlsx)

Table 4.3

Table 4.4

Table 6.1

Table A.A.1

Descriptive Statistics for General Social Survey Samples

Data spreadsheet (.xlsx)

1993 General Social Survey raw data (Stata .dta file)

Statistical Coding (Stata .do file)

Stata Output (Stata .smcl file)

Stata Output (PDF)

Table A.A.2

Logistic Regression of Probability of Having Attended a Sporting Event on Individual- and Household-Level Variables

Data spreadsheet (.xlsx)

For data and coding, see files for Table A.A.1.

Table A.b.1

Individual Campaign Contributions by United Center Ownership and Executives

Data spreadsheet (.xlsx)

Raw Data from Illinois State Board of Elections and Illinois Sunshine Database (.xlsx)

Table A.b.2

Corporate Campaign Contributions by United Center Ownership and Executives, 1980 - 2016

Data spreadsheet (.xlsx)

For raw data, see files listed in Table A.B.1.

Table A.b.3

United Center Ownership and Executives Campaign Contributions by Office, 1980 — 2016

Data spreadsheet (.xlsx)

For raw data, see files listed in Table A.B.1.

Table A.C.1

Net Income Adjustments for United Center, Fiscal Years 1996 — 2010

Data spreadsheet (.xlsx)

United Center Income Statements obtained from Cook County Assessor’s Office via Freedom of Information Act (FOIA) Request

Update (12/18/2018): When reading the United Center income statements linked to above, be aware that the Cook County Assessor defines “net income” as profits before payment of income taxes and mortgage interest (see p. 137 of the Illinois Introduction to Residential Assessment Practices). Once a commercial real estate concern like the United Center receives its property tax bill, it then deducts interest and state/local taxes (including property taxes) to arrive at “net income” as defined by the IRS for corporate income tax collection. Chapter 6 and Appendix C of Bulls Markets use the Cook County Assessor’s definition of “net income”; so it would be more precise on p. 192 to state that “the owners would have taken home tens of millions of dollars in annual profits, before income tax, even without the breaks.” Based on some back-of-the-napkin math, the statement would still be true in some years without the foregoing qualification—and in more if the figures are adjusted for inflation—but in nominal terms factoring in income tax payments would drag bottom-line profits below $20 million in most years. With regard to mortgage interest, the income statements are confusing. The property tax deal with the state allowed arena owners to deduct hypothetical interest payments on the arena construction loan even after they paid it off. This is why they continued to deduct “STATUTORY INTEREST EXPENSE” from their “net income” (as defined by the Assessor) even after actual amortization and interest expenses dropped to zero after 2000, the year when they paid off the loan (see this article from the Chicago Tribune for corroboration).

Table A.C.2

Estimated United Center Property Tax Liabilities in Constant 2016 Dollars, under Standard Assessment Procedures, Tax Years 1997 — 2011

Data spreadsheet (.xlsx)

For income statements obtained from Cook County Assessor, see files for Table A.C.1.

United Center Net Income Multipliers (NIMs) (.xlsx)

Table A.c.3

Difference between Property Tax Bills Under Standard Assessment Procedures and Actual Tax Payments for the United Center, in Constant 2016 Dollars, Tax Years 1997 — 2011

Data spreadsheet (.xlsx)

For income statements obtained from Cook County Assessor, see files for Table A.C.1.

Table A.D.1

United Center City Amusement Tax Savings in Constant 2016 Dollars, Fiscal Years 2002 — 2007

Data spreadsheet (.xlsx)

United Center revenue data filed with Cook County Board of Review (PDF)

Figures

figure 1.1

Real Total Personal Income Growth, Chicago-Naperville-Elgin Metropolitan Statistical Area and Metropolitan United States, 1969 — 1980

Data spreadsheet w/figure (.xlsx)

figure 2.1

Responses to February 1997 ABC News Nightline Poll Question: “Do you think that the presence of Whites, Blacks and other minorities on sports teams helps, hurts, or has no effect on integration and reduction of racial tension in other areas of life?”

Data spreadsheet w/figure (.xlsx)

1997 ABC News Nightline Poll raw data (Stata .dta file)

Statistical Coding (Stata .do file)

Stata Output (Stata .smcl file)

Stata Output (PDF)

figure 2.2

Cost in Constant 2016 Dollars of Most Expensive (Courtside) and Least Expensive (Second Balcony) Seats for the Bulls, 1970 — 1971 to 1994 — 1995

Data spreadsheet w/figure (.xlsx)

figure 2.3

Predicted Probabilities of Attendance at an Amateur or Professional Sporting Event in 1992 by Per Capita Family Income

Data spreadsheet w/figure (.xlsx)

1993 General Social Survey processed data w/predicted probabilities (.dta)

figure 2.4

Predicted Probabilities of Attendance at an Amateur or Professional Sporting Event in 1992 by Years of Education

Data spreadsheet w/figure (.xlsx)

For processed survey data w/predicted probabilities, see files for Figure 2.3.

figure 2.5

Average Ticket Prices in Constant 2016 Dollars, Chicago Bulls and National Basketball Association, 1991 — 1992 to 2001 — 2002

Data spreadsheet w/figure (.xlsx)

For raw ticket price data, see links for Table 2.4.

figure 2.6

figure 2.7

Chicago Bulls Core Financial Data, 1989 — 1990 to 2000 — 2002

Data spreadsheet w/figure (.xlsx)

For NBA income/expense data, see links for Table 2.2.

figure 2.8

Operating Margins of the Chicago Bulls and National Basketball Association, 1989 — 1990 to 2001 — 2002

Data spreadsheet w/figure (.xlsx)

For NBA income/expense data, see links for Table 2.2.

figure 2.9

Aggregated Core Financial Data, National Basketball Association Franchises, 1989 — 1990 to 2001 — 2002

Data spreadsheet w/figure (.xlsx)

For NBA income/expense data, see links for Table 2.2.

figure 2.10

figure 2.11

figure 2.12

Average Annual Consumer Unit Expenditures, in Constant 2016 Dollars, on “Entertainment and Admissions” by Pretax Income Quintile, 1984 — 2016

Data spreadsheet w/figure (.xlsx)

U.S. Bureau of Labor Statistics. “Quintiles of Income before Taxes: Annual Average Expenditures and Characteristics.” Consumer Expenditure Survey Tables, 1984 — 2016. (PDF)

figure 2.13

Average Ticket Prices by Team in Constant 2016 Dollars, Major-League Baseball, 1975 — 2012

Data spreadsheet w/figure (.xlsx)

”MLB Ticket Price Data,” Rodney Fort’s Sports Business Data (link)

figure 4.1

New Owner-Occupied Home Purchase Loans in West Haven by Minority Status, 1997 — 2006

Data spreadsheet w/figure (.xlsx)

Urban Institute Home Mortgage Disclosure Act Data in .tab & .dta format, along with data documentation and Stata coding (link)

figure 4.2

New Owner-Occupied Home Purchase Loans in West Haven by Income Level, 1997 — 2006

Data spreadsheet w/figure (.xlsx)

For raw Home Mortgage Disclosure Act data, see links for Figure 4.1.

figure 5.2

Price in Constant 2016 Dollars for Typical Family Basket of Concessions at a Chicago Bulls Game, 1991 — 2002

Data spreadsheet w/figure (.xlsx)

”NBA Fan Cost Index,” Rodney Fort’s Sports Business Data (link)

figure 6.1

United Center’s Actual Property-Tax Payments versus Estimated Property-Tax Liabilities under Standard Assessment Procedure, in Constant 2016 Dollars, 1997 — 2011

Data spreadsheet w/figure (.xlsx)

For income statements obtained from Cook County Assessor, see files for Table A.C.1.

figure 6.2

maps

Click on the map title below to access a Dropbox folder containing the associated data files (spreadsheets), shapefiles, .mxd (ArcMap) files, and .ai exports (for Adobe Illustrator users). If you want to work with the .mxd files in ArcMap, click the desired link, then click “Download” (top right), and finally click on “Direct download” for a zipped version of the parent folder. Once the download completes, unzip the folder, click on the “Mapfiles” subfolder, and open the .mxd file. Do not reorganize the subfolders or files, as this will un-link the underlying shapefiles and data from the .mxd file. Note that the legends/labels in the book may vary slightly from those in the files linked to below, since the designers made some tweaks to enhance grayscale visibility.

map 1.1

map 1.2

map 2.1

map 3.1

map 3.2

map 3.3

map 3.4

map 3.5

map 3.6

map 4.1

map 4.2

map 4.3

map 4.4

map 4.5

map 4.6

map 4.7

map 5.1

map 5.2

map 6.1

Other Data files

Consumer price indices

Consumer Price Index All Urban Consumers (CPI-U): All Items, U.S. City Average, 1990 — 2018 (.xlsx)

Consumer Price Index All Urban Consumers (CPI-U): All Items, Chicago-Naperville-Elgin. Ill.-Ind.-Wis., 1914 — 2012 (.xlsx)

Consumer Price Index All Urban Consumers (CPI-U): All Items, Chicago-Naperville-Elgin, Ill.-Ind.-Wis., 1990 — 2017 (PDF)

United Center effective property tax rateS, 1997 — 2011

United Center Effective Property Tax Rates, 1997 — 2011 (.xlsx)

For relevant section(s) in Bulls Markets, see p. 192 and p. 284 (note 17).

Present value Property tax calculations

Net Present Value of United Center Tax Savings, 1994 — 2015 (.xlsx)

U.S. Federal Reserve. "Selected Interest Rates (yearly)- H.15: Twenty-Year Treasury Bill, 1993 — 2014." (.csv)

For relevant section(s) in Bulls Markets, see pp. 192 — 194 and p. 285 (note 20).

Update (12/18/2018): You will notice a minor difference between the final present value figure in the spreadsheet linked to above ($85.6 million) and the figure provided in the text ($85.9 million). I updated the calculations before publication to account for the impact of NBA/NHL labor stoppages on United Center income flows during the period in question (this is referenced in the endnotes). However, in the chaos of final manuscript preparation, the main text was not updated with the new value.