<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div class="">Thanks Stephen! For starters it would be useful to have a spreadsheet with just the headline data corresponding to that graph: annual dollars for police, housing, and human services, for each year from 2010 through 2020. That way, in addition to the visualization, we can say things like “the human services budget fell X% from 2010 to 2012, and it didn’t recover to 2010 levels till 2017 (or whatever) and by 2019 it had only grown by Y% since 2010, adjusted for inflation…” etc. (I’m assuming this data is not inflation-adjusted btw, but it would be good to confirm that.)</div>
<div><br class=""><blockquote type="cite" class=""><div class="">On Jun 6, 2020, at 3:41 PM, Stephen DeSanto <<a href="mailto:rachidian@gmail.com" class="">rachidian@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class=""><div class="">Hi Katie. I found it a little easier to go to the data source here: <a href="https://data.seattle.gov/dataset/City-of-Seattle-Operating-Budget/8u2j-imqx" class="">https://data.seattle.gov/dataset/City-of-Seattle-Operating-Budget/8u2j-imqx</a></div><div class=""><br class=""></div><div class="">I also found their data visualization tool difficult to work with (and it wouldn't let me save my work), but maybe we can export the data to a different environment (e.g. Tableau, python) to make it easier to sort through the budget data.<br class=""></div><div class=""><br class=""></div><div class=""><div class=""><span id="cid:ii_kb47f45c1"><image.png></span></div><div class=""><br class=""></div><div class="">
The raw numbers live in the data set linked above. I was able to get them to show up in the graph, though it's hard to read.</div><div class=""><br class=""></div><div class="">As far as a more detailed breakdown of how money is being spent, you might have to be a CM to get answers, if at all: <a href="https://twitter.com/eyesonthestorm/status/1269061348144513024" class="">https://twitter.com/eyesonthestorm/status/1269061348144513024</a></div><div class=""><br class=""></div><div class="">Let me know if there's something specific you'd like from the data set and I'll see if I can pull it out.<br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div></div></div><br class=""><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Jun 5, 2020 at 8:54 PM Katie Wilson <<a href="mailto:katie@transitriders.org" class="">katie@transitriders.org</a>> wrote:<br class=""></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div style="overflow-wrap: break-word;" class=""><div class="">Just to give an example: After a few minutes poking around in the site I was able to get this graph, showing how the police budget didn’t get cut during the great recession, whereas human services and housing did, and human services in particular took a long time to recover to 2010 levels, whereas the police budget just kept going up (presumably much faster than inflation).</div><div class=""><br class=""></div><div class="">But I can’t figure out easily how to get the data set so that I can see the actual numbers. I know you can download all the data on the site but it’s not immediately obvious to me how to isolate just the data for this graph.</div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><span id="cid:1728b9a4b4f986a9fc01"><Screen Shot 2020-06-05 at 8.49.43 PM.png></span></div>
<div class=""><br class=""><blockquote type="cite" class=""><div class="">On Jun 5, 2020, at 8:48 PM, Katie Wilson <<a href="mailto:katie@transitriders.org" target="_blank" class="">katie@transitriders.org</a>> wrote:</div><br class=""><div class=""><div style="overflow-wrap: break-word;" class="">Hey data & research folks,<div class=""><br class=""></div><div class="">Anyone want to do some digging into the police budget?</div><div class=""><br class=""></div><div class=""><a href="https://openbudget.seattle.gov/#!/year/default" target="_blank" class="">https://openbudget.seattle.gov/#!/year/default</a></div><div class=""><br class=""></div><div class="">I’m in touch with some of the people who are thinking seriously about how to cut the police budget & we have a chance to help out with this in a number of ways. </div><div class=""><br class=""><div class="">
<div style="overflow-wrap: break-word;" class=""><div style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px" class=""><span style="color:rgb(102,102,102);font-family:arial,sans-serif;font-size:13px" class="">Katie Wilson</span></div><div style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px" class=""><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px" class=""><font color="#666666" class="">General Secretary</font></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px" class=""><font color="#666666" class="">Transit Riders Union</font></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px" class=""><font color="#666666" class=""><a href="https://transitriders.org/" target="_blank" class="">https://transitriders.org</a></font></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px" class=""><span class=""><font color="#666666" class="">206-781-7204</font></span></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px" class=""><font color="#999999" class=""><br class=""></font></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px" class=""><i class=""><font color="#999999" class="">The Transit Riders Union is a democratic organization of working and poor </font></i><i class=""><font color="#999999" class="">people, including students, seniors, and people with disabilities, taking control over our own lives, and building up the power we </font></i><i class=""><font color="#999999" class="">need to change society for the good of humanity and of the planet. We will </font></i><i class=""><font color="#999999" class="">fight to preserve, expand, and improve the public transportation system in </font></i><i class=""><font color="#999999" class="">Seattle and beyond, so that every human being has access to safe, </font></i><i class=""><font color="#999999" class="">affordable, and reliable public transit.</font></i></div></div></div>
</div>
<br class=""></div></div><br class=""></div></blockquote></div><br class=""></div><br class="">
</blockquote></div>
</div></blockquote></div><br class=""></body></html>