Explore Social Issues with Microdata

Posted by on Sep 15, 2017 in Meeting | 0 comments

In this Hands-On presentation, we’ll be exploring social issues using two sources of microdata: The General Social Survey , a 40 year survey program that asks a representative sample of Americans questions on a huge number of social issues, and IPUMS, a curated, processed collection of international survey and census data. Using these two sources you can study a wide range of social questions.

For instance, here is an analysis of the relationship between Occupational Prestige and Personal Income, using the IPUMS online analysis tool, with data from the ACS 2010-2015:

The Red color means that the intersection between the prestige group and the income group is more frequent than would be predicted by chance. The red diagonal shows a correlation between prestige and income, with higher prestige being associated with higher income. Since income is a a component of job prestige, this is exactly what you would expect. We’ll be demonstrating how to construct analyses like this, as well as analyses using Jupyter notebooks.  The meeting will consist of both a presentation and a demonstration. Bring a laptop, and you can explore some of the data during the meeting.

Also, we will spend about 30 minutes for updates and discussion about the ongoing Mission Driven Credit Analysis  project, including an overview of the FFIEC data sources for studying lending patterns.

Please visit our Meetup.com page for the meeting to RSVP. 

Read More

Mission Driven Credit Analysis

Posted by on Aug 20, 2017 in Current Projects | 0 comments

We’re excited to announce the first of our next round of social data projects.

Mission Driven Finance is a San Diego impact investment fund that provides loans to nonprofits, social enterprises, and businesses that benefit the San Diego community.  MDF is interested in helping businesses understand the regional lending landscape and advocating for improvements to make it easier for businesses that have a hard time getting financing to be able to get the money they need to grow.

This project will explore:

  • Characterizing the state of small and medium business (SMB) lending in SD County.
  • Visualizing regions of the county by Credit Score, similar to this map.
  • Demographic analysis of SMB lending

We will be collecting data related to businesses, demographics and lending and creating some datasets and visualizations.

We will probably start project meetings in October, but may get started with wrangling data before then.  More details about the project are in the project wiki and the Initial Questions document, and visit Meetup.com to register for the kickoff meeting

Here is a map that is the inspiration for the project; we’d like to produce something similar for San Diego:



Join The Project
Read More

Pro Bono Data Analysis This Summer

Posted by on Apr 4, 2017 in Analysis, News, Projects | 0 comments

Disadvantaged Student Performance

For Summer of 2017, The San Diego Regional Data Library will be running a data internship program, working on pro-bono data analysis projects for nonprofits, governments and journalists in San Diego County. If your organization has questions that can be answered with data, you can have an undergraduate data analyst work on your project, with professional guidance, for up to 12 weeks.

Project sponsors must be able to describe their needs as a set of questions that can be answered with available data, and must be able to meet with the interns at their site for 1 hour per week. Projects must have a social goal or benefit.

We’re currently running two projects, and expect to be running three or four more this summer.

If your organization needs data analysis this summer, please contact the Data Library Director, Eric Busboom at (619) 363-2607 or eric@sandiegodata.org.

Read More

Age-Friendly Communities

Posted by on Dec 12, 2016 in Old Projects | 0 comments

Project Management Site

Consumer Advocates for RCFE Reform (CARR) works to improve the quality of  residential care facilities for the elderly (RCFE)  by making public RCFE records and reports easier to find, search and understand. This recent article in Senior Housing and Care Journal provides an excellent introduction to the data issues involved in reviewing these facilities, as does CARR’s final report to the county for the rating system pilot program.

For this data project, we will be collecting data to analyze the capacity and affordability of San Diego’s assisted living industry, considering the anticipated need for these services over the next 30 years.  The goal is to to identify those communities in San Diego experiencing the greatest difficulty finding and affording assisted living care services. 

This project will use regional Census data, San Diego’s 211 intake records, SANDAG data, and data from California’s Departments of Health Care Services and Social Services. The analysis from the project will reveal the ability of those 65 and over to afford lifetime average assisted living expenditures of $4,000/month for three years.   Of particular interest for this program would be identifying communities with high concentrations of low-income seniors and the availability (or lack thereof) of Assisted Living Medicaid Waiver Program (ALWP) beds within the immediate community.

A good place to start for data is the County’s Aging and Independence Services website, but in the kick off meeting will will identify many other sources of data that we should consider and analyze.

Joining The Project

If you’d like to join the project, see the list of items under “Joining a Project”  on the main project list page.

Read More