SCI Grant Recipients

These maps present variables that we developed to measure different aspects of collaboration in each region (defined as the counties associated with each grantee) funded under the Sustainable Communities Initiative Regional Planning Grants. Below we describe each database in more detail and provide a data dictionary. We provide the databases for download in the hopes that others will use them for research. The Partner Database describes who participated in the grant. The Collaboration Database describes the structure of the collaboration as well as the economic characteristics of the region. The eLogic Database reports on several grant outcomes (for 2011 grantees only). For more detail on database construction, please see Karen Chapple, Grace Streltzov, Mariana Blondet, and Cristina Nape, Epistemic Communities or Forced Marriages? Evaluating Collaboration among SCI-RPG Grantees (Cityscape, November 2017).

Partner Database
To better understand the sectoral diversity of each grant consortium, we gathered the organizational characteristics of partners that collaborated with SCI grantees. We defined “partners” as the organizations listed in a HUD-maintained database of 2,550 organizations involved with each grantee project. For each of these partners, we gathered a series of variables: budget (2014 gross revenue) and mission statement (available from their website and the Guidestar nonprofit database) and entity type, which we defined as the stakeholder group that the partner represented, we developed a typology of twenty-two organization types (see Appendix); these were then consolidated into the six categories used in the analysis.

Data Dictionary

Demographic

Population (2010) - Total 2010 population of the grantee region

Poverty Rate (2014) - Total 2010 population of the grantee region

Percentage Foreign Born (2014) - Percent of 2014 region residents born outside of the United States

Percentage Residents of Color - Nonwhite percent of 2014 grantee region residents

Economic

Inequality (2014) - Median income difference between white and nonwhite households, expressed as a proportion

Median Income (2014) - Median household income of the grantee region

Sectoral Diversity Index - Entropy index (a measure of evenness across industry groups) of employment data by 2 digit NAICS code

Tech Sector by % Total Employment -  Professional, scientific, and technical services employees (NAICS code 54) and information employees (NAICS code 51) as a percentage of total employees in grantee region

Eds & Meds Sector by % Total Employment -  Health care and social assistance employees (NAICS code 62) and educational services employees (NAICS code 6) as a percentage of total employees in grantee region

Manufacturing Sector by % Total Employment -  Manufacturing employees (NAICS code 31-33) as a percentage of total employees in grantee region

% GDP, Public (2010) - Percent of regional GDP generated by the public sector in 2010

% GDP, Private (2010) - Percent of regional GDP generated by the public sector in 2014

% GDP, Public (2014) - Percent of regional GDP generated by the private sector in 2010

% GDP, Private (2014) -  Percent of regional GDP generated by the private sector in 2014

Governance

Number of Municipalities per 10,000 People - Number of municipalities within the grantee region per 10,000 residents

Number of Consortium Signatories - Number of consortium agreement signatories

Grant Dollars Per Resident - Grant amount divided by the number of residents in the region to determine how many dollars per resident were granted

% Consortium Members, Nonprofits - Percent of consortium members that are nonprofit organizations

% Consortium Members, Businesses - Percent of consortium members that are businesses

% Consortium Members, Universities - Percent of consortium members that are universities

% Consortium Members, Local Governments - Percent of consortium members that are local governments

% Consortium Members, Regional Governments - Percent of consortium members that are regional governments

% Consortium Members, Other Governments - Percent of consortium members that are other types of governments