<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="">Interesting! Thanks Doug, this is great. I wonder why they stop counting after 91%, that’s a weird stopping point. </div><div class=""><br class=""></div><div class="">I don’t know about converting the districts. And actually I’m just realizing, since the voter turnout data is % of <i class="">registered </i>voters, ideally we’d want to combine the two datasets to get a picture of percentage of <i class="">eligible</i> voters to who voted.</div><div class=""><br class=""></div><div class="">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 class=""><br class=""></div><div class="">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 class=""><br class=""></div><div class="">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 class=""><blockquote type="cite" class=""><div class="">On Sep 27, 2020, at 10:09 PM, Douglas Sexton <<a href="mailto:sextondouglas@comcast.net" class="">sextondouglas@comcast.net</a>> wrote:</div><br class="Apple-interchange-newline"><div class="">
<meta charset="UTF-8" class="">
<div class="">
<div style="font-size: 12pt; font-family: helvetica, arial, sans-serif; color: #333333;" class="">
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: #333333;" class="">
<span id="cid:a17614cb8421448b88c2c2bc99cf11c8@Open-Xchange"><image.png></span>
<br class="">
</div>
<div style="font-size: 12pt; font-family: helvetica, arial, sans-serif; color: #333333;" class="">
<span style="font-family: helvetica; font-size: 12pt;" class=""><span id="cid:11adf99c5fd3453db44b1739842742bd@Open-Xchange"><image.png></span></span>
</div>
<blockquote type="cite" class="">
<div class="">
On 09/27/2020 9:38 PM Katie Wilson <<a href="mailto:katie@transitriders.org" class="">katie@transitriders.org</a>> wrote:
</div>
<div class="">
<br class="">
</div>
<div class="">
<br class="">
</div>
<div class="">
Awesome, thank you Doug!
</div>
<div class="">
<br class="">
<blockquote type="cite" class="">
<div class="">
On Sep 27, 2020, at 9:24 PM, Douglas Sexton <
<a class="" href="mailto:sextondouglas@comcast.net">sextondouglas@comcast.net</a>> wrote:
</div>
<br class="Apple-interchange-newline">
<div class="">
<div class="">
<div class="" style="font-size: 12pt; font-family: helvetica, arial, sans-serif; color: #333333;">
<span class="" 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 class="">
</div>
<div class="" style="font-size: 12pt; font-family: helvetica, arial, sans-serif; color: #333333;">
<span class="" style="font-family: helvetica; font-size: 12pt;"><br class=""></span>
</div>
<div class="" style="font-size: 12pt; font-family: helvetica, arial, sans-serif; color: #333333;">
<span class="" style="font-family: helvetica; font-size: 12pt;">Haven't made the scatter plot yet! Will do that in a sec.<br class=""></span>
</div>
<blockquote type="cite" class="">
<div class="">
On 09/27/2020 8:13 PM sextondouglas <
<a class="" href="mailto:sextondouglas@comcast.net">sextondouglas@comcast.net</a>> wrote:
</div>
<div class="">
<br class="">
</div>
<div class="">
<br class="">
</div>
<div class="" dir="auto">
Giving it a go right now
</div>
<div class="" dir="auto">
<br class="">
</div>
<div class="">
<br class="">
</div>
<div class="" dir="auto" style="font-size: 100%;">
<div class="">
-------- Original message --------
</div>
<div class="">
From: Katie Wilson <
<a class="" href="mailto:katie@transitriders.org">katie@transitriders.org</a>>
</div>
<div class="">
Date: 9/27/20 7:50 PM (GMT-08:00)
</div>
<div class="">
To:
<a class="" href="mailto:research@transitriders.org">research@transitriders.org</a>
<br class="">
</div>
<div class="">
Subject: [TRU Research] Data on voting by income
</div>
<div class="">
<br class="">
</div>
</div>Hey all,
<div class="">
<br class="">
</div>
<div class="">
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 class="" href="https://www.politico.com/magazine/story/2015/01/income-gap-at-the-polls-113997">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 class="" href="https://www.kuow.org/stories/the-neighborhoods-with-highest-and-lowest-voter-turnout-in-king-county">this story</a>, which is good but not super detailed. However, there is also this map and data set:
<a class="" href="https://www.communitiescount.org/voter-registration-voter-turnout">https://www.communitiescount.org/voter-registration-voter-turnout</a>
<br class="">
</div>
<div class="">
<br class="">
</div>
<div class="">
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 class="">
<br class="">
</div>
<div class="">
1. Percent registered voters by census tract
</div>
<div class="">
2. 2019 general election voter turnout by precinct
</div>
<div class="">
<br class="">
</div>
<div class="">
And, in the King County demographics layer —> Income:
</div>
<div class="">
A. Median household income
</div>
<div class="">
B. Percent below 200% of federal poverty level
</div>
<div class="">
<br class="">
</div>
<div class="">
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 class="">
<br class="">
</div>
<div class="">
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 class="">
<br class="">
</div>
<div class="">
Thanks!
</div>
<div class="">
Katie
</div>
<div class="">
<br class="">
<div class="">
<div class="" style="caret-color: #000000; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" dir="auto">
<div class="" style="letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">
<div class="" style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">
<div class="" 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; -webkit-text-stroke-width: 0px;">
<span class="" style="color: #666666; font-family: arial, sans-serif; font-size: 13px;">Katie Wilson</span>
</div>
<div class="" 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; -webkit-text-stroke-width: 0px;">
<div style="color: #222222; font-family: arial, sans-serif; font-size: 13px;" class="">
<span style="color: #666666;" class="">General Secretary</span>
</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: 13px;" class="">
<span style="color: #666666;" class="">Transit Riders Union</span>
</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: 13px;" class="">
<span style="color: #666666;" class=""><a class="" href="https://transitriders.org/">https://transitriders.org</a></span>
<br class="">
</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: 13px;" class="">
<span class=""><span style="color: #666666;" class="">206-781-7204</span></span>
</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: 13px;" class="">
<span style="color: #999999;" class=""><br class=""></span>
</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: 13px;" class="">
<em class=""><span style="color: #999999;" class="">The Transit Riders Union is a democratic organization of working and poor </span></em>
<em class=""><span style="color: #999999;" class="">people, including students, seniors, and people with disabilities, taking control over our own lives, and building up the power we </span></em>
<em class=""><span style="color: #999999;" class="">need to change society for the good of humanity and of the planet. We will </span></em>
<em class=""><span style="color: #999999;" class="">fight to preserve, expand, and improve the public transportation system in </span></em>
<em class=""><span style="color: #999999;" class="">Seattle and beyond, so that every human being has access to safe, </span></em>
<em class=""><span style="color: #999999;" class="">affordable, and reliable public transit.</span></em>
</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: 13px;" class="">
<em class=""><span style="color: #999999;" class=""><br class=""></span></em>
</div>
<div style="color: #222222; font-family: arial, sans-serif; font-size: 13px;" class="">
<em class=""><span style="color: #999999;" class=""><span class="" style="caret-color: #000000; font-style: normal;">I also write </span><a class="" style="caret-color: #000000; font-style: normal;" href="https://crosscut.com/author/katie-wilson">opinions</a><span class="" style="caret-color: #000000; font-style: normal;"> for Crosscut. </span></span></em>
<em style="caret-color: #222222;" class=""><span style="color: #999999;" class=""><span style="caret-color: #000000; font-style: normal;" class="">Sign up for my newsletter </span><a style="caret-color: #000000; font-style: normal;" class="" href="http://eepurl.com/g_D3nf">here</a>.</span></em>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br class="">
</blockquote>
</div>
<span id="cid:9ECEEF3B-6277-42B1-B6AC-6140AF0D34D2@hsd1.wa.comcast.net." class=""><CensusVoterRegistrationAndIncomeData.csv></span>
<span id="cid:876B7DDA-D412-4361-B6D9-E5C2D6E96BA7@hsd1.wa.comcast.net." class=""><parse.py></span>
<span id="cid:042C4D96-592E-4518-A0D6-30AE1C0EFD39@hsd1.wa.comcast.net." class=""><query1-398.json></span>
</div>
</blockquote>
</div>
<br class="">
</blockquote>
</div>
</div></blockquote></div><br class=""></body></html>