[TRU Research] Research/data projects

[Jim Walseth]

Katie,

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.

https://docs.google.com/spreadsheets/d/1XgvT6L3EF_6029xExDFA7CbK2cMYfliKJiSd_ys3ZMY/edit?usp=sharing

Jim

On Fri, Feb 7, 2020 at 8:57 AM Katie Wilson <katie at transitriders.org> wrote:

> Hi folks,
>
> 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:
>
> 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!
>
> 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.
>
> Also, has anyone been keeping tabs on our spreadsheet of form entries
> from the O4A website
> <https://docs.google.com/spreadsheets/d/14HbO7S-KLxjt57Mi_lmlKOVMOHd0OH6bPwkmC25balw/edit?usp=sharing>?
> 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?
>
> If I’m forgetting anything from our meeting, please chime in!
>
> Katie
>
>
> Katie Wilson
> General Secretary
> Transit Riders Union
> https://transitriders.org
> 206-781-7204
>
> *The Transit Riders Union is a democratic organization of working and
> poor **people, including students, seniors, and people with disabilities,
> taking control over our own lives, and building up the power we **need to
> change society for the good of humanity and of the planet. We will **fight
> to preserve, expand, and improve the public transportation system in **Seattle
> and beyond, so that every human being has access to safe, **affordable,
> and reliable public transit.*
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.transitriders.org/pipermail/research/attachments/20200207/95fc9d61/attachment.html>