-
Notifications
You must be signed in to change notification settings - Fork 4
/
cdc_submission.html
76 lines (70 loc) · 5.05 KB
/
cdc_submission.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="chrome=1">
<title>DC Community Resource Data by leahbannon</title>
<link rel="stylesheet" href="stylesheets/styles.css">
<link rel="stylesheet" href="stylesheets/pygment_trac.css">
<meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no">
<!--[if lt IE 9]>
<script src="//html5shiv.googlecode.com/svn/trunk/html5.js"></script>
<![endif]-->
</head>
<body>
<div class="wrapper">
<header>
<h1>DC Community Resource Data</h1>
<p><strong><a href="http://communityresourcedata.codefordc.org">HOME</a></strong></p>
<p>(Formerly DC Open 211)</p>
<ul>
<li><a href="/solution.html">Read about <strong>Our Plan</strong></a></li>
<li><a href="http://codefordc.org/">Code for DC <strong>Join Us</strong></a></li>
<li><a href="http://opendatadc.org/api/3/action/datastore_search?resource_id=81d74b9f-6793-469a-b47d-a097d8ca3a86">View <strong>Our Data</strong></a></li>
</ul>
</header>
<section>
<h3>Are there Community Services where there is Poverty?</h3>
<img src="img/poverty_vs_communityworkers.png"/>
<br>
<br>
<p>The primary objective of our project is the development of an open, interoperable directory of community resources, such as health and social service agencies. This first entails the integration of multiple different sources of data
(including federal 990 data, 2-1-1 referral data, and local service agencies' own internal directories) -- which we have already accomplished. We need funding to develop institutional capacity to facilitate the use of this database over time,
for which we are seeking seed funding from sources like this challenge. </p>
<p>As prompted by the Knight Civic Data Challenge, we explored the correspondence between social service providers
and poverty levels. Using the 2012
<a href="http://www.civicdatachallenge.org/data/civic-health-data">CPS data</a> for household size and income, we estimated the poverty rate per geographic region (MSA)
for the largest cities based on the federal poverty guidelines (e.g. $23,050 income threshold for a household of 4).
We compared this to the presence of "community workers" (defined to include most of the BLS O*NET occupations under
"Community and Social Service Occupations") from
<a href="http://www.bls.gov/oes/">BLS data</a>
, and region populations from
<a href="http://www.census.gov/popest/data/metro/totals/2012/tables/CBSA-EST2012-01.csv">census data</a> . We used R to convert the SPSS files to csv format, and used Python to combine the BLS and CPS data based on MSA names. We cleaned some MSA names in the CPS data, since some were not standardized, and there was no MSA (or FIPS) ID provided.</p>
<p>We found a mismatch between concentrations of poverty and community workers. In Dallas, LA, and Miami, with poverty rates > 15%, there are over 35 people in poverty per community worker while Boston and Philadelphia, with poverty rates < 15%, have less than 15. This suggests an inverse relationship between service density and potential people in need. </p>
<p>Given anecdotal evidence from non-profit organizations in DC participating in this project, it appears the challenge of finding information about resources appears to be universally shared among service providers and residents themselves. </p>
<p>We believe there is great opportunity for a viable open resource directory system to not only improve referral processes but also help identify and target such regional mismatches between need and capacity. </p>
<p>This chart shows the concentration of community workers to poverty rate. Each bubble represents a metropolitan area, with the size corresponding to total population.</p>
<p>
Internal Links/Code:<br/>
<a href="https://docs.google.com/spreadsheet/ccc?key=0AkpWA1dZQbPodFNHYmpzRkNPSDl6dVh4QTJpQjVVV2c#gid=6">Data for this Chart</a><br/>
<a href="https://github.com/tlingf/cdc_open211">Code for this Analysis</a><br>
<a href="https://docs.google.com/document/d/1FGGpwBUFuBce-hkelp29CuLf_h_rTgtASMVg41g9B_Y/edit">Project Background</a><br>
<a href="https://docs.google.com/presentation/d/1xUivkQ02fSlq_8-_kc_sCyYnemeW9XrbZFW1M_6ct48/edit#slide=id.gd953dc10_27">Background on Ppt (In Progress)</a><br>
<a href="https://hackpad.com/Open211-Data-Commons-Project-yMfDTnFwo6g">Hackpad</a><br/>
<br>
Partners:<br>
<a href="https://www.auntbertha.com/">Aunt Bertha</a><br>
<a href="http://thebridgeprojectdc.org">The Bridge Project</a><br>
<a href="http://idealistics.org/">Idealistics</a><br>
<a href="http://nccs.urban.org/">National Center for Charitable Statistics</a><br>
<a href="http://www.breadforthecity.org/">Bread for the City</a><br>
<a href="http://marthastable.org/">Martha's Table</a><br>
</p>
</section>
<footer>
<p>Help improve this content on <a href="https://github.com/leahbannon/communityresources">GitHub</a>.</p>
</footer>
</div>
<script src="javascripts/scale.fix.js"></script>
</body>
</html>