{"id":104722,"date":"2024-09-04T15:23:06","date_gmt":"2024-09-04T20:23:06","guid":{"rendered":"https:\/\/news.medill.northwestern.edu\/chicago\/?p=104722"},"modified":"2024-09-04T15:23:12","modified_gmt":"2024-09-04T20:23:12","slug":"methodology-a-new-chinatown-demographics-business-landscapes-evolve-in-chicagos-11th-ward","status":"publish","type":"post","link":"https:\/\/news.medill.northwestern.edu\/chicago\/methodology-a-new-chinatown-demographics-business-landscapes-evolve-in-chicagos-11th-ward\/","title":{"rendered":"Methodology – A new Chinatown: Demographics, business landscapes evolve in Chicago\u2019s 11th Ward"},"content":{"rendered":"

By Grace Xue and Tianshu Hu
\n<\/b>Medill Reports<\/span><\/i><\/p>\n

The datasets used in this report were downloaded from the U.S. Census Bureau, the Chicago Metropolitan Agency for Planning (CMAP) and the Chicago Data Portal. These datasets are all publicly available.<\/span>\u00a0<\/span><\/p>\n

Three different types of data were obtained from these official agencies and authorities. The U.S. Census Bureau provides detailed demographic data about race and ethnicity. We specifically examined the population of Chinese ethnicity in ZIP codes 60608, 60609, 60616 and 60632. CMAP gathered data from the 2017-2021 American Community Survey five-year estimates, which is a survey conducted by the U.S. Census Bureau. This survey provides information about the languages spoken in households, which can indicate the Chinese population since most Chinese speakers are Chinese. The percentage of non-English languages spoken can also reflect the diversity of a neighborhood. The Chicago Data Portal contains a dataset named \u201cChicago Chinatown Chamber of Commerce New Businesses Ward 11,\u201d which includes all current and active business licenses issued by the Department of Business Affairs and Consumer Protection and are members of the Chicago Chinatown Chamber of Commerce.<\/span><\/p>\n

To streamline the analysis process, we standardized the formats and removed unwanted columns. For example, when cleaning the business license data from the Chicago Chinatown Chamber of Commerce, we deleted rows with registration IDs and selected only the registration date among other dates to simplify the dataset. For the Census Bureau\u2019s population data, we combined different downloaded CSV files into one Google sheet and added different ZIP codes as columns to consolidate the data. We also used OpenRefine to remove duplicates of business names, eliminate spaces and ensure the numbers were in the same format. We used the sorting and PivotTable functions in Google Sheets for further data analysis and utilized Flourish to create visualizations.<\/span><\/p>\n

There are no major ethical concerns with our data since none of it involves personal information about individuals or households. All three datasets come from credible government agencies: the U.S. Census Bureau, the Chicago Metropolitan Agency for Planning and the Department of Business Affairs and Consumer Protection of the City of Chicago. The census and CMAP data only reflect large-scale statistics, such as the number of people, median household income and languages spoken. Although the Ward 11 business dataset contains detailed license numbers and dates, they are intended to be transparent for consumers, and we do not use this information in our analysis. We only analyze the business license dataset to observe trends and changes over time in business numbers and types.<\/span><\/p>\n

One limitation of the Ward 11 business dataset is that it only contains 387 members who joined the Chinatown Chamber of Commerce, while there are 1,260 businesses in total in Ward 11. We selected the dataset limited to chamber members because many chain businesses, such as CVS, Starbucks and Chipotle, are not owned by or catering to Chinese immigrants, which could dilute the results when analyzing local business trends in Chinatown. Our interviewed source, executives from the Chinatown Chamber of Commerce, indicated they could only speak about the insights and patterns of businesses that are chamber members. However, it is important to be aware there are other businesses in the greater Chinatown area that have not been included in our analysis, which future stories can investigate further.<\/span><\/p>\n

 <\/p>\n

Data Diary<\/b><\/p>\n

    \n
  1. Data Collection<\/span><\/li>\n<\/ol>\n