<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 Jim, this looks great. Even though we can’t 100% trust this list (according to the person who gave it to me) at least it gives us an idea of some employers that may be affected. I’m going to share this with our organizers and ask them if some version of this list would be helpful for them as they plan their outreach.</div><div class=""><br class=""></div><div class="">I have added Isaac and Bryn to this list, believing that they expressed an interest in being part of our volunteer research/data team. Isaac and Bryn, if this is mistaken, please let me know, and otherwise welcome to our email group!</div><div class=""><br class=""></div><div class="">- Katie</div>
<div><br class=""><blockquote type="cite" class=""><div class="">On Feb 14, 2020, at 8:03 PM, Jim Walseth <<a href="mailto:jim.walseth@gmail.com" class="">jim.walseth@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class=""><div class="">Hi y'all.</div><div class=""><br class=""></div>I started 'reducing' the spreadsheet manually then realized at 1100 lines I was not up for that. So I wrote a script to collapse multiple businesses. Now 337 rows.<div class=""><br class=""></div><div class="">The 'Legal name' is the one associated with the first line in a group. Perhaps of little value. <br class=""><div class=""><br class=""></div><div class=""><a href="https://drive.google.com/file/d/1qg5u6Tkphu-jRS8vhRgAXGeN7vDI8zEc/view?usp=sharing" class="">https://drive.google.com/file/d/1qg5u6Tkphu-jRS8vhRgAXGeN7vDI8zEc/view?usp=sharing</a><br class=""></div><div class=""><br class=""></div><div class="">Jim</div></div></div><br class=""><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Feb 11, 2020 at 8:06 PM Jim Walseth <<a href="mailto:jim.walseth@gmail.com" class="">jim.walseth@gmail.com</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 dir="ltr" class="">Yes this seems fine to me, I've started on this. Cheers, Jim<br class=""></div><br class=""><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Feb 7, 2020 at 5:41 PM Katie Wilson <<a href="mailto:katie@transitriders.org" target="_blank" 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 class="">And by “occupations” in that first bullet point I meant “locations”.<div class="">
</div>
<div class=""><br class=""><blockquote type="cite" class=""><div class="">On Feb 7, 2020, at 5:35 PM, Katie Wilson <<a href="mailto:katie@transitriders.org" target="_blank" class="">katie@transitriders.org</a>> wrote:</div><br class=""><div class=""><div class="">I think what we’re going for here is a list <i class="">only</i> including employers we believe will be affected by our legislation— so that means 500+ employees worldwide and not already doing full transit benefits for everyone.<div class=""><br class=""></div><div class="">The spreadsheet I attached contains food and retail industry employers that probably qualify, in general. So maybe it makes sense to start by stripping down that spreadsheet so that:</div><div class=""><br class=""></div><div class=""><ul class=""><li class="">Businesses with multiple occupations occupy only one row, putting the number of locations (previously the number of rows) in the locations column</li><li class="">Same for franchises, but add a note in the notes column that it’s a franchise</li><li class="">Remove the address columns and the NAICS code column, but maybe retain the NAICS description column since that may be useful for us to know for businesses whose names we don’t recognize.</li></ul><div class=""><br class=""></div></div><div class="">After that, I think it may be best to add other employers we think will be affected one by one, rather than trying to merge any of our other spreadsheets— otherwise we’re going to be adding tons of smaller employers and ones who may already be doing full transit benefits.</div><div class=""><br class=""></div><div class="">Does that make sense? Totally open to other approaches to cleaning up the data if we can get to the desired outcome.</div><div class=""><br class=""></div><div class="">Katie</div><div class=""><div class="">
</div>
<div class=""><br class=""><blockquote type="cite" class=""><div class="">On Feb 7, 2020, at 5:09 PM, Jim Walseth <<a href="mailto:jim.walseth@gmail.com" target="_blank" class="">jim.walseth@gmail.com</a>> wrote:</div><br class=""><div class=""><div dir="ltr" class=""><div class="">I have merged our old spread sheet with the new. The schemas are very different as we say in the data business so it is kind of a hot mess right now. Also there are many franchises (7 Eleven e.g.). Etc. I'm happy to process this more as needed.<br class=""></div><div class=""><br class=""></div><div class="">Merged list: <a href="https://docs.google.com/spreadsheets/d/1ETvJ_YpXIUek9_1ZfKBlaobrzf6f4LnJl-LfijGJUi4/edit?usp=sharing" target="_blank" class="">https://docs.google.com/spreadsheets/d/1ETvJ_YpXIUek9_1ZfKBlaobrzf6f4LnJl-LfijGJUi4/edit?usp=sharing</a></div><div class=""><br class=""></div><div class="">Jim<br class=""></div><div class=""><br class=""></div></div><br class=""><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Feb 7, 2020 at 4:33 PM Jim Walseth <<a href="mailto:jim.walseth@gmail.com" target="_blank" class="">jim.walseth@gmail.com</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 dir="ltr" class=""><div class="">Katie,</div><div class=""><br class=""></div><div class="">I volunteered to do the Employer data spreadsheet. I just copied the data from our previous spreadsheet in there and and added the 'Locations' column. I'll merge in the data from the list you just sent as well.</div><div class=""><br class=""></div><div class="">
<a href="https://docs.google.com/spreadsheets/d/1XgvT6L3EF_6029xExDFA7CbK2cMYfliKJiSd_ys3ZMY/edit?usp=sharing" target="_blank" class="">https://docs.google.com/spreadsheets/d/1XgvT6L3EF_6029xExDFA7CbK2cMYfliKJiSd_ys3ZMY/edit?usp=sharing</a>
</div><div class=""><br class=""></div><div class="">Jim<br class=""></div></div><br class=""><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Feb 7, 2020 at 8:57 AM Katie Wilson <<a href="mailto:katie@transitriders.org" target="_blank" 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 class="">Hi folks,<div class=""><br class=""></div><div class="">We a had a good meeting last Thursday. My apologies for the slow follow-up, things have been busy! In my recollection — I’m having trouble finding my notes right now — we settled on two main projects:</div><div class=""><br class=""></div><div class="">1. Compiling a spreadsheet of employers that could be affected by our legislation, and (if possible) an estimate of the number of employees they have in Seattle who could be affected. I’m attaching a spreadsheet from my friend at Working Washington, listing employers they thought would be covered by the secure scheduling legisation that passed in 2018. He says: "Wouldn’t trust this very far but here you go. Note it also will include franchisees with <500 employees provided the franchise system employs 500+ b/c that’s how coverage works on this.” For our spreadsheet, I think we decided to keep it simple with a column for employer name, another for estimated number of employees, and another for notes. Looking at the WW spreadsheet, I think we should add another column for estimated number of locations. So, a first step would be to create our spreadsheet by condensing the info in this spreadsheet. I can’t remember who volunteered to start this project (Jim maybe?) so if it was you, speak up!</div><div class=""><br class=""></div><div class="">2. Thinking of informative data-containing graphics that we could create and spread through social media etc. to help propel the campaign forward. One I remember was to translate an individual’s monthly transit costs into other necessary goods, to show what they could be doing with that money instead. We had some other ideas that hopefully I wrote down in my notes, which I will keep looking for. If we can come up with concepts & numbers, we have a few people in our membership & networks who can probably create the graphics and make ‘em look cool. If you have ideas, just share them with the group by email & we can start that way.</div><div class=""><br class=""></div><div class="">Also, has anyone been keeping tabs on our <a href="https://docs.google.com/spreadsheets/d/14HbO7S-KLxjt57Mi_lmlKOVMOHd0OH6bPwkmC25balw/edit?usp=sharing" target="_blank" class="">spreadsheet of form entries from the O4A website</a>? Looks like we have some more people telling us what transit benefits their employers offer. Stephen, can you take a look and move the relevant info over to the master spreadsheet so that Jim can update the chart?</div><div class=""><br class=""></div><div class="">If I’m forgetting anything from our meeting, please chime in!</div><div class=""><br class=""></div><div class="">Katie</div><div class=""><br class=""></div><div class=""></div></div><div class=""><div class=""><br class=""><div class="">
<div 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="">
</blockquote></div>
</blockquote></div>
</div></blockquote></div><br class=""></div></div></div></blockquote></div><br class=""></div></blockquote></div>
</blockquote></div>
</div></blockquote></div><br class=""></body></html>