[TRU Research] Research/data projects

[Jim Walseth]

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.

Merged list:
https://docs.google.com/spreadsheets/d/1ETvJ_YpXIUek9_1ZfKBlaobrzf6f4LnJl-LfijGJUi4/edit?usp=sharing

Jim


On Fri, Feb 7, 2020 at 4:33 PM Jim Walseth <jim.walseth at gmail.com> wrote:

> 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/22472ec9/attachment.html>