Arts Datathon . Los Angeles

Datasets

Many of the data we have are about arts nonprofits, arts education, artworks and grants. There’s a fair amount of data available about arts finance, mostly in the nonprofit realm. We are curating a set of arts and related datasets for the datathon. This list will continue to grow until the day of the datathon, so come back often to see what we’ve added. Be sure to check out the Data Analysis Tools page and get to know some of the newest and some tried-and-true ways to explore data.

Have a dataset to suggest? Contact us!

This page has two sections: 1) a list of downloadable data. We have selected datasets that are most relevant for the day. You can read about the context of each dataset and download the data as CSV files; 2) a list of dashboards, maps, and databases that give interactive or visualized results of data. At the end of each section, you will also find an embedded table that displays a full list of datasets and dashboards, each with information such as description, geography, periodicity, and topics.

For the authoritative dataset files and documentation used during the event, please go to our GitHub repository.

Downloadable Data

MUSEUMS IN LA COUNTY

LA County is home to at least 226 museums. This list of LA County museums is a curated subset of a crowdsourced list of museums created by the Institute of Museum and Library Services. This is the most complete list of museums in the County, but there may be other, smaller museums that are not included.
List view https://data.lacounty.gov/Arts-and-Culture/LA-County-Museums-2015/fmxp-v6mx/data
Map view https://data.lacounty.gov/Arts-and-Culture/Map-LA-County-Museums/svhk-hgbg
Source Curated by the Los Angeles County Arts Commission

URBAN ART IN WEST HOLLYWOOD

The City of West Hollywood’s Percent for Art Program includes works by Billy Al Bengston, Shepard Fairey, and Ball-Nogues. Over 60 artworks are included in this dataset with links to photos for each artwork.

List view https://data.weho.org/Art/Urban-Art-Locations/twt6-v6gc
Map view https://data.weho.org/Art/Map-of-Urban-Art-Installations/ntku-757x
Source WeHo Arts, City of West Hollywood

LA COUNTY CIVIC ART COLLECTION

The Civic Art Program was established in 2004 after the Los Angeles County Board of Supervisors adopted the County’s first Civic Art Policy, which allocates one percent of design and construction costs of new County capital projects to a Civic Art Special fund. The County Civic Art Collection includes artworks accessioned through capital project commissions, donations, purchases, and historic artworks acquired by the County prior to the adoption of the Civic Art Policy. The dataset includes artist name, artwork title, location (geocoded and addresses), medium, artwork type, and creation date. Images are not included in the dataset.

Dataset https://data.lacounty.gov/Arts-and-Culture/Los-Angeles-County-Civic-Art-Collection/9qv9-dayy
Source Los Angeles County Arts Commission

LIBRARIES IN THE UNITED STATES

This database provides basic information about every main library, branch and bookmobile in the US. If you only want to see LA County, set the “filter” function so that COUNTY is LOS ANGELES. There are 37 library systems in LA County.

Dataset https://data.imls.gov/Public-Libraries-Survey/Main-Libraries-Branches-and-Bookmobiles-FY-2014-Pu/ucdn-7aur/data
Source Institute of Museum and Library Services

CIRCULATION STATISTICS, LA COUNTY LIBRARIES

How many books are checked out or renewed from each library every month? This dataset provides the answer, dating back to 2014. This includes County libraries only and does not include the City of LA’s library data or any of the other 36 library systems in the County.

Dataset https://data.lacounty.gov/Arts-and-Culture/Public-Library-Monthly-Circulation/gf6j-sjun/data
Source County of LA Public Library

BOOKSTORES IN LA COUNTY

This is the most complete list of bookstores in LA County available, compiled in 2013 from a mix of websites, social media and crowdsourced data. Bookstores open and close with some regularity so this list is likely to be slightly out of date.

Dataset https://data.lacounty.gov/Arts-and-Culture/LA-County-Bookstores-2013/a3k2-6v7z/data
Source Los Angeles County Arts Commission

ARTS NONPROFITS IN CALIFORNIA – REVENUE SOURCES 

This dataset shows revenue by all sources for all arts nonprofits in California. This is a very large file that includes a significant amount of contextual data. Use the codebook in the second tab to help you understand the headers. The data have been anonymized to protect confidentiality. This dataset is limited to those arts nonprofits that report data to DataArts.

Dataset https://github.com/b-mauldin/DataArts/blob/master/DataArts_CaliOrgs_DetailedRevTypes.xlsx
Source DataArts 

ARTS NONPROFITS IN THE US – EVENT ATTENDANCE 

This dataset shows attendance by discipline for arts nonprofits in every county in the US that reports Cultural Data Profiles to DataArts. It shows both paid and free attendance, and covers the years 2002-2016. Organizations can be sorted by budget size and by discipline as well as zip code. The data have been anonymized to protect confidentiality. This dataset is limited to those arts nonprofits that report data to DataArts.

Dataset https://github.com/b-mauldin/DataArts/blob/master/DataArts_BasicAttendance_Discipline.xlsx
Source DataArts 

GRANTEES OF CITY OF LOS ANGELES CULTURAL GRANTS PROGRAM

This is a list nonprofit cultural-arts organizations awarded with financial support for public-benefit projects taking place within the City of Los Angeles. The Cultural Grants Program is administered by the Grants Division of the City of Los Angeles Department of Cultural Affairs. This list contains the name and address of the organizational grantee, discipline of the project proposed, and grant amount allocation from fiscal year 2010-11 to 2016-17. This workbook contains tabs for a spreadsheet per fiscal year cycle.

Dataset https://drive.google.com/open?id=0B9IiYHqFF1zHOG8wRlJlZkg0Z0xpVE9zMVpFWVRHaC1Sb3pF
Source City of Los Angeles Department of Cultural Affairs

GRANTEES OF LA COUNTY’S ORGANIZATIONAL GRANTS PROGRAM

This is a list of arts nonprofit organizations in LA County awarded two-year grants by the Organizational Grants Program (OGP), managed by the LA County Arts Commission. Each organization listed received a two-year grant. For each grantee, the organization name, award amount, project description and website is provided. This dataset shows the most recent three years of awards.

Dataset https://data.lacounty.gov/Arts-and-Culture/Organizational-Grants-for-Arts-Services/73tm-r9gy/data
Source Los Angeles County Arts Commission

GRANTEES OF LA COUNTY’S COMMUNITY IMPACT ARTS GRANTS 

This is a list of arts nonprofit organizations in LA County awarded one-year grants by the Community Impact Arts Grants (CIAG) program managed by the LA County Arts Commission. These are nonprofit organizations whose main mission is not arts, but who use high quality arts programming to meet their mission. For each grantee, the organization name, award amount, project description and website is provided. CIAG grants were launched in 2016-17 and this dataset shows the first year of awards.

Dataset https://data.lacounty.gov/Arts-and-Culture/Community-Impact-Arts-Grants/fspu-ggmr/data
Source Los Angeles County Arts Commission

COMMUNITY ARTS CENTERS, CITY OF LOS ANGELES

A list of the 22 cultural centers, theaters, historic sites, and galleries managed by City of Los Angeles Department of Cultural Affairs (DCA). Administered by the Community Arts Division, these cultural centers have year-round classes, workshops, exhibitions, and events; and engage in conservation efforts and educational tours at historical sites.

Dataset https://data.lacity.org/A-Livable-and-Sustainable-City/Cultural-Centers-Theaters-Historic-Sites-and-Galle/vdjf-if28
Source City of Los Angeles Department of Cultural Affairs

FREE CONCERTS IN PUBLIC SITES

Each summer the LA County Board of Supervisors funds free concerts in public sites across LA County. This dataset is a list of all concerts in 2015 and 2016.

Dataset https://data.lacounty.gov/Arts-and-Culture/Free-Concerts-in-LA-County-Public-Sites/m2fm-jjhb
Source Los Angeles County Arts Commission

ARTS EDUCATION IN LA COUNTY PUBLIC SCHOOLS 

Each year all public schools in California report on enrollment and instruction in all courses. This dataset reports on all arts education courses reported to the state by all schools in all 81 school districts in LA County. Arts education data is combined with key demographic data such as the percent of English language learners and percent on free and reduced price meals, for each school. This dataset is limited to individual arts courses and therefore only includes middle school and high school arts education. It does not include arts education integrated into subjects, afterschool arts education, or arts education offered by community arts partners.

Dataset https://docs.google.com/spreadsheets/d/12ZgR2g8uORXbCxCFNi3d9mw7DnjxRCNt-r0p5xbr3aw/edit?usp=sharing
Source California Department of Education (curated by the LA County Arts Commission and Arts for All)

ARTS EDUCATION – ADVANCEMENT GRANTS TO SCHOOL DISTRICTS 

LA County’s Advancement Grant program offers financial support to school districts in the County, aiming to provide quality arts education for public school students. Grant funds assist school districts in achieving key action items in their district arts plans, and cultivating skills and practices that can be sustained beyond the term of the grant. This dataset includes all grantees in the 2015-16 and 2016-17 school years.

Dataset https://data.lacounty.gov/Arts-and-Culture/Arts-for-All-Advancement-Grants-2016-17/9dwz-arec/data
Source Los Angeles County Arts Commission

ARTS EQUITY INDEX IN LAUSD SCHOOLS

The Arts Equity Index (AEI) categorizes all LAUSD schools (K-12) based on the scope of their provided arts instruction, arts resources, arts professional development, Title 1 Status, and Student Equity Index (Poverty, Foster Students, English Language Learners). This dataset is limited to schools in the Los Angeles Unified School District.

Dataset (Secondary) https://drive.google.com/open?id=0B9IiYHqFF1zHeWE3MXBybkZDVWs
Dataset (Elementary) https://drive.google.com/open?id=0B9IiYHqFF1zHdFpBeThYU0llZG8
Source Los Angeles Unified School District

COMMUNITY ARTS PARTNERS SERVING LA COUNTY PUBLIC SCHOOLS

The LA County Arts Commission surveyed teaching artists and arts organizations to find out who provided what services in LA County public schools in 2012. This dataset presents all the schools and districts where we found 185 community arts partners serving 1,174 schools. The full report is available for download. This is a non-representative convenience sample of teaching artists and arts organizations that serve LA County public schools. It includes only arts partners that provide services during the school day. Many other teaching artists and arts organizations serve the public schools.

Datasets https://data.lacounty.gov/Arts-and-Culture/Community-Arts-Partners-serving-LA-County-Public-S/bs8c-4eeb/data
Source Los Angeles County Arts Commission

EMPLOYMENT: CREATIVE INDUSTRIES IN LA COUNTY 

These datasets present information about employment in creative industries in LA County, using North American Industrial Classification System (NAICS) codes and definitions developed in the annual Otis Report on the Creative Economy.. The data include the count of workers in each industry in LA County by race, gender, and age, as well as the number of people working in those industries and their hourly earnings. Comparison data for creative industries in the entire US are provided in a separate workbook. Data showing race, gender, and age for all residents of LA County are also provided. The fourth dataset shows employment in creative industries by zip code. These data come from Economic Modeling Specialist International and are based on their proprietary model of aggregating data from over 100 sources.

Datasets 
Creative industries in LA County: https://docs.google.com/spreadsheets/d/16EKF7Ev9DgFWzgiB4f9OHAPgx76bWFt–YjL_X7U1jU/edit#gid=1341812452
Creative industries in the US: https://docs.google.com/spreadsheets/d/15IrLvbBy4-HrYWe5S2s5HrMJodrm10flnrasVt9kIws/edit#gid=721694742
Demographics of LA County: https://docs.google.com/spreadsheets/d/1v0M5nbqZN2P3sRmT4dXpXPddHgqPNqn1LjXVOha-p0U/edit#gid=1328501454
Creative industries by zip code : https://docs.google.com/spreadsheets/d/1xu4EAjphOWlfMJ-LiEBN3PGu0I0hpqMNWCHy_2YZCms/edit#gid=877393813
Source CVSuite, a product of the Western States Arts Federation (WESTAF)

EMPLOYMENT: CREATIVE OCCUPATIONS IN LA COUNTY 

These datasets present information about employment creative occupations in LA County, using occupational codes developed by the US Department of Labor and definitions developed in the annual Otis Report on the Creative Economy. These are occupations that require some kind of creativity, but may be in any industry. The data include the count of workers in each occupation in LA County by race, gender, and age, as well as the number of people working in those occupations and their hourly earnings. Comparison data for the creative occupations in the entire US are provided in a separate workbook. Data showing race, gender, and age for all residents of LA County are also provided. The fourth dataset shows employment in creative occupations by zip code. These data come from Economic Modeling Specialist International and are based on their proprietary model of aggregating data from over 100 sources.

Datasets 
Creative occupations in LA County: https://docs.google.com/spreadsheets/d/1q1MjRm8N1BswO4dfmXYBdUHohex1kE6d8QWpYks0qpw/edit#gid=2130517749
Creative occupations in the US: https://docs.google.com/spreadsheets/d/19LJVSzFI2HGbq_3rltbwOQVPrTOmtqQWOsy-0l9bg0Y/edit#gid=303073659
Demographics of LA County: https://docs.google.com/spreadsheets/d/1v0M5nbqZN2P3sRmT4dXpXPddHgqPNqn1LjXVOha-p0U/edit#gid=1328501454
Creative occupations by zip code : https://docs.google.com/spreadsheets/d/1k9gz0bGGqdl4TghBGfu9wPA_j6Hczo-qPt5LL5Vchjw/edit#gid=1406718942
Source CVSuite, a product of the Western States Arts Federation (WESTAF)

ARTS TICKET BUYERS IN LA COUNTY

TRG Arts compiles information about ticket buyers from arts institutions in LA County, then combines that with more than 200 demographic and psychographic metrics, to construct profiles of arts patrons. The first dataset below is a demographic profile—age, education, income, presence of children, and other key metrics—in statistical and chart format. The second dataset looks at ticket buyers by zip code. It shows the penetration rate, which is the ratio of household count to the overall population in each postal code. The data is also represented in two postal code maps which can be found on the first two pages of the report. This data is limited to arts organizations that contribute data to TRG Arts; these range in annual budget size from $500,000 up to more than $12 million.

Datasets
Demographics: https://github.com/b-mauldin/TRGArts/blob/master/TRGArts_CommunityDemographics.xls
Zip codes: https://github.com/b-mauldin/TRGArts/blob/master/TRGArts_CommunityPostalCode_WithMap.xls
Source TRG Arts 

LOS ANGELES INDICES OF NEIGHBORHOOD CHANGE

The Los Angeles Indices of Neighborhood Change is a project of the Los Angeles Innovation Team, as part of its wider efforts to develop City programs to reduce displacement in revitalizing areas of Los Angeles. From our link, you can download the underlying data (table and shapefiles) and a data dictionary related to the below metrics developed to rank neighborhood change and displacement pressure: 1) the Los Angeles Index of Neighborhood Change, a measure that combines comparative change among six demographic factors from 2000 to 2014, at the Zip Code level; 2) The Los Angeles Index of Displacement Pressure, a score of a Census Tract’s “displacement pressure,” as determined by predictive factors that suggest future revitalization, as well as the current population’s sensitivity to extreme rent increases.

Dataset https://drive.google.com/drive/folders/0B9IiYHqFF1zHWVlQN2s4YzBxWHM
Source City of Los Angeles, Innovation Team, Mayor’s Office


Downloadable Data – Tabular Version



Dashboard, Map, Database

NATIONAL CENTER FOR THE ARTS KIPI DASHBOARD

The National Center for Arts Research (NCAR) at Southern Methodist University (SMU) has created a free, online tool, the NCAR KIPI (Key Intangible Performance Indicator) Dashboard, which allows arts organizations across the U.S. to see how they compare to their peers. This dashboard, powered by data from DataArts’ Cultural Data Profile (CDP), illuminates organizations’ performance trends across nine key areas, and provides a KIPI score, ranging from 0-100, so organizations have an idea of their overall financial and operating health relative to similar organizations nationally. If you are from an arts organization that enters data into the CDP, you can look up your organization and compare it to others of the same size in the same discipline.

http://mcs.smu.edu/dashboard

Get started now This tutorial will walk you through how to use the dashboard.

CALIFORNIA ARTS EDUCATION DATA PROJECT

How much arts education is provided in schools across the 81 school districts in LA County? What classes are offered, and how many students enroll? This interactive dashboard is a project of CreateCA (built with Tableau) that allows you to look up the data by county, by district and by school. This is data reported each year to the California Department of Education. Keep in mind, this only reflects individual arts classes so it only shows secondary education. Also, you can’t download the data to create your own carts and graphs.

http://www.createca.dreamhosters.com/interactive-dashboard

Get started now Listen to a webinar that provides an overview of how the dashboard works.

PUBLIC ART ARCHIVE

A crowdsourced database of publicly viewable and sanctioned artworks that were commissioned, placed or displayed through a traditional commissioning process, or acquired through an official acquisition process. The site is maintained by the Western States Arts Federation (WESTAF) and all entries are screened before being added. Description of each artwork is accompanied by an image. Because this is crowdsourced, it is an incomplete picture of public art. Searchable by location and other factors, and includes a mapping function.

http://www.publicartarchive.org/search/apachesolr_search/los%20angeles

AARP LIVABILITY INDEX

https://livabilityindex.aarp.org

REVISION REGIONAL MAPPING AND ANALYSIS APPLICATION (UCLA/SCAG)

http://revision.lewis.ucla.edu/index.html

HEALTHY CITY

http://www.healthycity.org


Dashboard, Map, Database – Tabular Version