Euclid Avenue City Directory Data

Year

Categories

Fig. 1: Interactive map displaying historical city directory data for lower Euclid Avenue in Cleveland, Ohio (Public Square to the Innerbelt) by location. Source: Cleveland City Directories, select years from 1937 to 1997. NOTE: 2019 data was manually compiled by Mark Souther and is not part of any city directory. Download source data as .csv file

Introduction

City directories were compendia of residents, businesses, and institutions with associated addresses that were widely used in U.S. cities from the 19th century into the 1970s (and sporadically thereafter). Beginning in 1929, city directories incorporated a new feature, the criss-cross directory, which listed all building occupants by street and then by address, enabling them to be read in a place-based manner. Commercial listings also included abbreviated business types. Although these varied from year to year, we have devised a typology of categories and subcategories (adopting widely recognized terminology) that enable more meaningful and accurate analysis. City directories are a rich resource for spatial analysis that can inform urban, public, and digital history. These visualizations depict nearly a century of change along lower Euclid Avenue, the spine of downtown Cleveland.

Category

Fig. 2: Interactive chart displaying historical city directory data for lower Euclid Avenue in Cleveland, Ohio (Public Square to the Innerbelt) by category. Source: Cleveland City Directories, select years from 1937 to 1997. NOTE: 2019 data was manually compiled by Mark Souther and is not part of any city directory. Download source data as .csv file

Methodology

This visualization began with the question: Could historical city directory data reveal meaningful patterns of change in building uses in downtown Cleveland? If so, it might yield insights useful not only to urban historians but also others in urban planning, finance, real estate, placemaking, and marketing, as well as become a model that is easily replicable in other cities.

City directories were compendia of residents, businesses, and institutions with associated addresses that were widely used in U.S. cities from the 19th century into the 1970s (and sporadically thereafter). Beginning in 1929, city directories incorporated a new feature, the criss-cross directory, which listed all building occupants by street and then by address, enabling them to be read in a place-based manner.

Graduate students developed a spreadsheet of all addresses listed in the criss-cross directories at more or less regular 5-year intervals. Ease of access to CSU's collections led to selecting mainly years ending in a 2 or 7 rather than a 0 or 5. We also collected the information for 2019 using firsthand observation. We surveyed a 26-block stretch of Euclid Avenue, downtown’s preeminent commercial corridor, from Public Square to the Innerbelt Freeway. Our focus was primarily on the pedestrian experience, so we charted only what was located in storefronts, lobbies, mezzanines, arcades, and concourses—not offices or other building uses on upper floors reached only by elevators.

Commercial listings in the directories included abbreviated business types. These varied from year to year, so we devised a typology of categories and subcategories (adopting widely recognized terminology) to enable more meaningful and accurate analysis.

The Center's web developer created a site to provide access to – and contextual information about – the collected data. Before publication online, data was reviewed, normalized, and geocoded. The user interface provides a number of methods for interactive data visualization. The map (Fig. 1) provides for spatial analysis by year and category, with color coding to represent the primary categories for each business. The stacked bar chart (Fig. 2) also employs color coding, providing visual representation of changes to the quantity and distribution of categories over time. Users may also select a particular category to assess changes according to narrower criteria. Finally, the full dataset is made accessible in a browsable card-based interface (Fig. 3), which can be filtered/searched by keyword, year, and category. The data may also be downloaded in full as a spreadsheet file. The website source code is available on github.com.

To be sure, our methodology could not capture a full picture of change on Euclid Avenue. More data points might have helped reveal any anomalies in particular years and pointed more precisely to the onset of certain patterns. Drawing on only the top-level categories rather than also on subcategories further limits the visualization of the emergence and disappearance of more-specific business types. For instance, the visualization does not show the gradual disappearance of fur shops, the emergence of savings and loan companies, or the rise and fall of airline ticket offices. Additionally, there is some ambiguity in the dataset because qualitative assessment was used to interpret how to categorize businesses into categories and subcategories. While done with great care (including additional newspaper research), there is certainly a degree of subjectivity, in part because businesses may provide multiple services, making it difficult to select a primary one. Rather than assign "Other" to every business whose category was not 100% certain, we opted to make informed decisions to assign a more precise category when we had a reasonably high level of confidence.

Despite these limitations, the collection, digitization, and consolidation of otherwise dispersed and inaccessible city directory data (albeit limited by geography) provides an ongoing opportunity for further iteration and analysis – by our team and others. The visualization demonstrates at a minimum the possibilities for the spatial analysis of city directories to depict the shifting contours of downtown business landscapes.

 Project Info  White Paper  Source Data

Data Viewer

Select a year or category, or enter some text to view matching records.

Fig. 3: Interactive widget for browsing historical city directory data for lower Euclid Avenue in Cleveland, Ohio (Public Square to the Innerbelt) by category. Source: Cleveland City Directories, select years from 1937 to 1997. NOTE: 2019 data was manually compiled by Mark Souther and is not part of any city directory. Download source data as .csv file