<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div dir="ltr">I’ll be working on it next weekend most likely!. (Gotta do my TRU work too after all...) So anything we can come up with this week is great!</div><div dir="ltr"><br><blockquote type="cite">On Sep 28, 2020, at 9:44 AM, Jim Walseth <jim.walseth@gmail.com> wrote:<br><br></blockquote></div><blockquote type="cite"><div dir="ltr"><div dir="ltr"><div class="gmail_default" style="font-size:large">Katie <i>et al</i>,</div><div class="gmail_default" style="font-size:large">I'll do what I can in Tableau Public with this (anyone can BTW). Maps are my speciality so that could happen. And I can make prettier plots with correlation lines. Maybe not until this evening though. When is the Crosscut article due?</div><div class="gmail_default" style="font-size:large">Jim<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Sep 28, 2020 at 8:47 AM Katie Wilson <<a href="mailto:katie@transitriders.org">katie@transitriders.org</a>> wrote:<br></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;"><div>Interesting! Thanks Doug, this is great. I wonder why they stop counting after 91%, that’s a weird stopping point. </div><div><br></div><div>I don’t know about converting the districts. And actually I’m just realizing, since the voter turnout data is % of <i>registered </i>voters, ideally we’d want to combine the two datasets to get a picture of percentage of <i>eligible</i> voters to who voted.</div><div><br></div><div>If we can’t convert the districts, I guess from the point of view of putting the registered voter correlations into words, it would help to be able to say something like:</div><div><br></div><div>In the (10% or 20%? not sure which is best) of districts with the lowest median income, average voter registration was X%, while for districts with the highest median income it was Y%</div><div><br></div><div>and similarly for the % of households below 200% FPL measure, though looking at the graphs it appears that the median income correlation will be much clearer. It’s kind of interesting how the dots for the highest percentages of low-income households are really all of over the place when it comes to voter registration. I wonder why that is.</div>
<div><br><blockquote type="cite"><div>On Sep 27, 2020, at 10:09 PM, Douglas Sexton <<a href="mailto:sextondouglas@comcast.net" target="_blank">sextondouglas@comcast.net</a>> wrote:</div><br><div>
<div>
<div style="font-size:12pt;font-family:helvetica,arial,sans-serif;color:rgb(51,51,51)">
Definitely can see some correlations. They stop counting after 91% voter registration. I have ugly knockoff excel so hopefully you can make prettier graphs than me. I'm not sure how hard it is to convert voting districts to census districts so I haven't tried 2A/2B. Still open for someone else to try!
</div>
<div style="font-size:12pt;font-family:helvetica,arial,sans-serif;color:rgb(51,51,51)">
<span id="gmail-m_-3915923363778807077cid:a17614cb8421448b88c2c2bc99cf11c8@Open-Xchange"><image.png></span>
<br>
</div>
<div style="font-size:12pt;font-family:helvetica,arial,sans-serif;color:rgb(51,51,51)">
<span style="font-family:helvetica;font-size:12pt"><span id="gmail-m_-3915923363778807077cid:11adf99c5fd3453db44b1739842742bd@Open-Xchange"><image.png></span></span>
</div>
<blockquote type="cite">
<div>
On 09/27/2020 9:38 PM Katie Wilson <<a href="mailto:katie@transitriders.org" target="_blank">katie@transitriders.org</a>> wrote:
</div>
<div>
<br>
</div>
<div>
<br>
</div>
<div>
Awesome, thank you Doug!
</div>
<div>
<br>
<blockquote type="cite">
<div>
On Sep 27, 2020, at 9:24 PM, Douglas Sexton <
<a href="mailto:sextondouglas@comcast.net" target="_blank">sextondouglas@comcast.net</a>> wrote:
</div>
<br>
<div>
<div>
<div style="font-size:12pt;font-family:helvetica,arial,sans-serif;color:rgb(51,51,51)">
<span style="font-family:helvetica;font-size:12pt">I made a csv file with the census voter registration and income data combined. I also attached the json that was tricky to find with the income data and a script I used to convert it to csv in case anyone wants to check my work or use it for something else.</span>
<br>
</div>
<div style="font-size:12pt;font-family:helvetica,arial,sans-serif;color:rgb(51,51,51)">
<span style="font-family:helvetica;font-size:12pt"><br></span>
</div>
<div style="font-size:12pt;font-family:helvetica,arial,sans-serif;color:rgb(51,51,51)">
<span style="font-family:helvetica;font-size:12pt">Haven't made the scatter plot yet! Will do that in a sec.<br></span>
</div>
<blockquote type="cite">
<div>
On 09/27/2020 8:13 PM sextondouglas <
<a href="mailto:sextondouglas@comcast.net" target="_blank">sextondouglas@comcast.net</a>> wrote:
</div>
<div>
<br>
</div>
<div>
<br>
</div>
<div dir="auto">
Giving it a go right now
</div>
<div dir="auto">
<br>
</div>
<div>
<br>
</div>
<div dir="auto" style="font-size:100%">
<div>
-------- Original message --------
</div>
<div>
From: Katie Wilson <
<a href="mailto:katie@transitriders.org" target="_blank">katie@transitriders.org</a>>
</div>
<div>
Date: 9/27/20 7:50 PM (GMT-08:00)
</div>
<div>
To:
<a href="mailto:research@transitriders.org" target="_blank">research@transitriders.org</a>
<br>
</div>
<div>
Subject: [TRU Research] Data on voting by income
</div>
<div>
<br>
</div>
</div>Hey all,
<div>
<br>
</div>
<div>
I’m going to shamelessly use this list to ask for some data help for a Crosscut column I’m working on, not directly TRU-related. Nationally there’s
<a href="https://www.politico.com/magazine/story/2015/01/income-gap-at-the-polls-113997" target="_blank">a strong correlation between voting rates and income</a>— as you might expect, poor people tend not to vote. I was looking for something about the strength of this trend in Washington state or King County, and I found
<a href="https://www.kuow.org/stories/the-neighborhoods-with-highest-and-lowest-voter-turnout-in-king-county" target="_blank">this story</a>, which is good but not super detailed. However, there is also this map and data set:
<a href="https://www.communitiescount.org/voter-registration-voter-turnout" target="_blank">https://www.communitiescount.org/voter-registration-voter-turnout</a>
<br>
</div>
<div>
<br>
</div>
<div>
I played around with the layers in the map a little, enough to know there’s a lot of interesting stuff in there. It looks like you can download .csvs, but I’m not adept enough with the format to figure out quickly how to get to what I want. I’m interested specifically in correlations between:
</div>
<div>
<br>
</div>
<div>
1. Percent registered voters by census tract
</div>
<div>
2. 2019 general election voter turnout by precinct
</div>
<div>
<br>
</div>
<div>
And, in the King County demographics layer —> Income:
</div>
<div>
A. Median household income
</div>
<div>
B. Percent below 200% of federal poverty level
</div>
<div>
<br>
</div>
<div>
I’m interested to see how each of 1. and 2. correlate with each of A. and B. Perhaps in the form of scatter graphs?
</div>
<div>
<br>
</div>
<div>
If anyone is interested and has time to dig into this, let me know— and maybe reply on this list if you’re working on it so no one is duplicating efforts unless they want to.
</div>
<div>
<br>
</div>
<div>
Thanks!
</div>
<div>
Katie
</div>
<div>
<br>
<div>
<div style="letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none" dir="auto">
<div style="letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<div style="overflow-wrap: break-word;">
<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">
<span style="color:rgb(102,102,102);font-family:arial,sans-serif;font-size:13px">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">
<div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px">
<span style="color:rgb(102,102,102)">General Secretary</span>
</div>
<div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px">
<span style="color:rgb(102,102,102)">Transit Riders Union</span>
</div>
<div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px">
<span style="color:rgb(102,102,102)"><a href="https://transitriders.org/" target="_blank">https://transitriders.org</a></span>
<br>
</div>
<div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px">
<span><span style="color:rgb(102,102,102)">206-781-7204</span></span>
</div>
<div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px">
<span style="color:rgb(153,153,153)"><br></span>
</div>
<div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px">
<em><span style="color:rgb(153,153,153)">The Transit Riders Union is a democratic organization of working and poor </span></em>
<em><span style="color:rgb(153,153,153)">people, including students, seniors, and people with disabilities, taking control over our own lives, and building up the power we </span></em>
<em><span style="color:rgb(153,153,153)">need to change society for the good of humanity and of the planet. We will </span></em>
<em><span style="color:rgb(153,153,153)">fight to preserve, expand, and improve the public transportation system in </span></em>
<em><span style="color:rgb(153,153,153)">Seattle and beyond, so that every human being has access to safe, </span></em>
<em><span style="color:rgb(153,153,153)">affordable, and reliable public transit.</span></em>
</div>
<div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px">
<em><span style="color:rgb(153,153,153)"><br></span></em>
</div>
<div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px">
<em><span style="color:rgb(153,153,153)"><span style="font-style:normal">I also write </span><a style="font-style:normal" href="https://crosscut.com/author/katie-wilson" target="_blank">opinions</a><span style="font-style:normal"> for Crosscut. </span></span></em>
<em><span style="color:rgb(153,153,153)"><span style="font-style:normal">Sign up for my newsletter </span><a style="font-style:normal" href="http://eepurl.com/g_D3nf" target="_blank">here</a>.</span></em>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
</blockquote>
</div>
<span id="gmail-m_-3915923363778807077cid:9ECEEF3B-6277-42B1-B6AC-6140AF0D34D2@hsd1.wa.comcast.net."><CensusVoterRegistrationAndIncomeData.csv></span>
<span id="gmail-m_-3915923363778807077cid:876B7DDA-D412-4361-B6D9-E5C2D6E96BA7@hsd1.wa.comcast.net."><parse.py></span>
<span id="gmail-m_-3915923363778807077cid:042C4D96-592E-4518-A0D6-30AE1C0EFD39@hsd1.wa.comcast.net."><query1-398.json></span>
</div>
</blockquote>
</div>
<br>
</blockquote>
</div>
</div></blockquote></div><br></div><br>
</blockquote></div>
</div></blockquote></body></html>