| A | B | C | D | E | F | ||
|---|---|---|---|---|---|---|---|
1 | Measuring your Local News and Information Ecosystem The Impact Architects | HOW TO USE: Use this spreadsheet to collect data on your community, and compare it against national averages and comparison metrics. | |||||
2 | Definition | Data Sources | National Average or Comparison Metric | Your Community | Compare Baseline to National Average or Comparison Metric | ||
3 | Community Indicators | ||||||
4 | Demographics | ||||||
5 | Population | Total Population | US Census Bureau Quick Facts | 327,167,439 | |||
6 | % under 18 | Percent of population under age of 18 | US Census Bureau Quick Facts | 22% | Low | ||
7 | % over 65 | Percent of population under over age of 65 | US Census Bureau Quick Facts | 16% | Low | ||
8 | % White | Percent of population identifying as white | US Census Bureau Quick Facts | 75% | Low | ||
9 | % Black / African American | Percent of population identifying as Black or African/American | US Census Bureau Quick Facts | 14% | Low | ||
10 | % Hispanic / Latinx | Percent of population identifying as Hispanic/Latinx | US Census Bureau Quick Facts | 18% | Low | ||
11 | % Asian / Asian American Pacific Islander | Percent of population identifying as Asian or Asian American Pacific Islander | US Census Bureau Quick Facts | 7% | Low | ||
12 | % Native American/ Asian American | Percent of population identifying as Native American | US Census Bureau Quick Facts | 1% | Low | ||
13 | * insert community important to you | Percent of population | Manual Research | ||||
14 | * insert community important to you | Percent of population | Manual Research | ||||
15 | * insert community important to you | Percent of population | Manual Research | ||||
16 | Economics | ||||||
17 | Median Household Income | Median Household income of population | US Census Bureau Quick Facts | $61,937 | Low | ||
18 | Per Capita Income | Per Capita income of population | US Census Bureau Quick Facts | $33,831 | Low | ||
19 | Poverty Rate | Poverty rate of population | US Census Bureau Quick Facts | 13.10% | Low | ||
20 | Education | ||||||
21 | High School Degree | High School Graduates include people whose highest degree was a high school diploma or its equivalent, people who attended college but did not receive a degree, and people who received an associate's, bachelor's, master's, or professional or doctorate degree. | US Census Bureau Quick Facts | 90% | Low | ||
22 | Bachelor’s Degree | Percent population who have received a bachelor's degree from a college or university, or a master's, professional, or doctorate degree | US Census Bureau Quick Facts | 36% | Low | ||
23 | Literacy Rate | Functionally literate with reading and math skills at a 4th grade level or higher | Manual Research | 79% | Low | ||
24 | Resources & Infrastructure | ||||||
25 | Households with Computer | Number of households with a computer | US Census Bureau Quick Facts | 89% | Low | ||
26 | Broadband Access | Percent of population with access to broadband internet | US Census Bureau Quick Facts | 80% | Low | ||
27 | Universities | Number of accredited universities in the community | Schools and universities by zip code: https://nces.ed.gov/globallocator/ | ||||
28 | Population per University | Population divided by number of universities in the community | 45,093 | #DIV/0! | #DIV/0! | ||
29 | Libraries | Number of libraries, library branches, and bookmobiles in the community | Local Library.gov | ||||
30 | Population per Library | Population divided by number of libraries in the community | 30,395 | #DIV/0! | #DIV/0! | ||
31 | Community Satisfaction | Level to which residents feel interpersonal trust and/or a sense of belonging or attachment to their community | Well Being Index | 50% | Low | ||
32 | Voter Turnout of most recent election | Percent of population participating in most recent presidential, midterm, or local municipal elections | Manual Research | 47% | Low | ||
33 | Prior Information Needs Study | Presence of any prior information needs study | Manual Research | Yes/No | |||
34 | Prior Ecosystem Study | Presence of any prior information or journalism ecosystem studies | Manual Research | Yes/No | |||
35 | |||||||
36 | Information Providers | ||||||
37 | Number of Organizations | Number of journalism organizations based within the community | News Deserts Database, New York Times Database, Local journalism associations, Knight Civic Bright Spots Map | ||||
38 | Population per Organization | Number of Journalism organizations in the community divided by the population | 22,548 | #DIV/0! | #DIV/0! | ||
39 | Mediums | ||||||
40 | Newspapers | Percentage of journalism organizations in the community that are newspapers | News Deserts Database | 51% | High | ||
41 | Television Stations | Percentage of journalism organizations in the community that are newspapers broadcast television stations | FCC License Coverage Maps, PBS Member Organizations, Manual Research | 25% | High | ||
42 | Radio Stations | Percentage of journalism organizations in the community that are broadcast radio stations | News Deserts Database, NPR Member Organizations, Manual Research | 15% | High | ||
43 | Digital | Percentage of journalism organizations in the community that are primarily digital publications | News Deserts, Online Organizations | 15% | High | ||
44 | Business Models | ||||||
45 | Nonprofit | Percentage of journalism organizations in the community that are nonprofit | INN Membership, Manual Research | 21% | High | ||
46 | Public Media | Percentage of journalism organizations in the community that are public media | News Deserts Database, NPR & PBS Member Organizations, Manual Research | 4% | High | ||
47 | National Broadcast Chain | Percentage of journalism organizations in the community that are nationally-affiliated television broadcast stations | FCC License Coverage Maps, Manual Research | 22% | High | ||
48 | National Newspaper Chain | Percentage of journalism organizations in the community that are newspapers national chain newspapers | News Deserts Database | 15% | High | ||
49 | Independent For Profit | Percentage of journalism organizations in the community that are independent, for-profit | Manual Research | 37% | High | ||
50 | Ethnic Media | ||||||
51 | African American / Black | Number of media outlets in community produced for and by the African-American, Black, Afro-Caribbean community | News Deserts Database, CUNY Center for Community Media | ||||
52 | Population per outlet | Population identifying as African-American / Black divided by the number of media outlets in community produced for and by the African-American, Black, Afro-Caribbean community | 85,292 | #DIV/0! | #DIV/0! | ||
53 | Hispanic / Latinx | Number of media outlets in community produced for and by the Latinx or Hispanic community, or in Spanish | State of the Latino News, News Deserts Database, Manual Research | ||||
54 | Population per outlet | Population identifying as Latinx/Hispanic, divided by the number of media outlets in community produced for and by the Latinx or Hispanic community, or in Spanish | 40,231 | #DIV/0! | #DIV/0! | ||
55 | % Asian / Asian American | Number of media outlets in community produced for and by the Asian or Asian American community | |||||
56 | Population per outlet | Population identifying as Latinx/Hispanic, divided by the number of media outlets in community produced for and by the Latinx or Hispanic community, or in Spanish | #DIV/0! | ||||
57 | % Native American/ Asian American Pacific Islander | Number of media outlets in community produced for and by the Native American or Asian American Pacific Islander community | American Indian Media Today - Democracy Fund 2018 | ||||
58 | Population per outlet | Population identifying as Native American or Asian American Pacific Islander, divided by the number of media outlets in community produced for and by the Native American or Asian American Pacific Islander Community | #DIV/0! | ||||
59 | * insert community important to you | Number of media outlets in community produced for and by community important to your context | |||||
60 | Population per outlet | Population of community important to you divided by publications for and by that community | #DIV/0! | ||||
61 | * insert community important to you | Number of media outlets in community produced for and by community important to your context | |||||
62 | Population per outlet | Population of community important to you divided by publications for and by that community | #DIV/0! | ||||
63 | * insert community important to you | Number of media outlets in community produced for and by community important to your context | |||||
64 | Population per outlet | Population of community important to you divided by publications for and by that community | #DIV/0! | ||||
65 | Diversity | ||||||
66 | Journalist Diversity | Racial and gender diversity of journalists in journalism organizations in the community | ASNE Diversity Survey, Manual Research | ||||
67 | Source Diversity | Racial and gender diversity of sources quoted in the journalistic output of the community in the last 12 months | Manual Research | ||||
68 | Collaboration | Number of collaborations in the community over the last 12 months | Manual Research, Collaborative Journalism Database | ||||
69 | Journalism Funding | ||||||
70 | Philanthropic Dollars over the 3 previous years | Number of philanthropic dollars invested in media and information in the community over the previous 3 years (e.g. if recording in 2020, 2017-2019) | Foundation Center - Media Impact Funders (Journalism News and Information) | $18,749,444 | |||
71 | Funders | Number of philanthropic funders invested in media and information in the community over the previous 3 years | Foundation Center - Media Impact Funders (Journalism News and Information) | 68 | |||
72 | Recipients | Number of recipients of philanthropic funding for media and information in the community over the previous 3 years | Foundation Center - Media Impact Funders (Journalism News and Information) | 31 | |||
73 | Invested Per Capita | Population divided by number of philanthropic dollars invested in media and information in the community over the previous 3 years | $20.63 | #DIV/0! | #DIV/0! | ||
74 | |||||||
75 | Information Providers & Community | ||||||
76 | Representation and Proximity | ||||||
77 | % Who say local Journalists are in touch with the community | Percent of adults in community who say journalists are in touch with the community | Pew Local Journalism Dynamics | 63% | Low | ||
78 | % Who have spoken with a journalist | Percent of adults in community who say they have spoken with a journalist | Pew Local Journalism Dynamics | 21% | Low | ||
79 | % Who say their local news source mostly covers the area where they live | Percent of adults in community who say the local news primarily covers the area in which they live (vs another area, such as a nearby city) | Pew Local Journalism Dynamics | 51% | Low | ||
80 | Includes people like you in their stories | Percent of adults who say their local news does well at including people like them in their stories | Pew Local Journalism Dynamics | 58% | Low | ||
81 | Financial Support | ||||||
82 | % Who pay for local news in the past year | Percent of adults who have paid for local news in the past year | Pew Local Journalism Dynamics | 14% | Low | ||
83 | Perceptions of Information Providers - % Who Say Their Local News: | ||||||
84 | Reports news accurately | Percent of adults who say their local news does well at reporting the news accurately | Pew Local Journalism Dynamics | 71% | Low | ||
85 | Keeps an eye on local political leaders | Percent of adults who say their local news does well at keeping an eye on local political leaders | Pew Local Journalism Dynamics | 66% | Low | ||
86 | Provides news that they use daily | Percent of adults who say their local news does well at providing news that they use daily | Pew Local Journalism Dynamics | 67% | Low | ||
87 | Covers news stories thoroughly | Percent of adults who say their local news does well at covering news stories thoroughly | Pew Local Journalism Dynamics | 65% | Low | ||
88 | Are transparent about their reporting | Percent of adults who say their local news does well at being transparent about their reporting | Pew Local Journalism Dynamics | 62% | Low | ||
89 | Deals fairly with all sides | Percent of adults who say their local news does well at dealing fairly with all sides | Pew Local Journalism Dynamics | 62% | Low | ||
90 |