[TRU Research] Research/data projects

[Jim Walseth]

Yes this seems fine to me, I've started on this. Cheers, Jim

On Fri, Feb 7, 2020 at 5:41 PM Katie Wilson <katie at transitriders.org> wrote:

> And by “occupations” in that first bullet point I meant “locations”.
>
> On Feb 7, 2020, at 5:35 PM, Katie Wilson <katie at transitriders.org> wrote:
>
> I think what we’re going for here is a list *only* 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.
>
> 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:
>
>
>    - Businesses with multiple occupations occupy only one row, putting
>    the number of locations (previously the number of rows) in the locations
>    column
>    - Same for franchises, but add a note in the notes column that it’s a
>    franchise
>    - 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.
>
>
> 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.
>
> Does that make sense? Totally open to other approaches to cleaning up the
> data if we can get to the desired outcome.
>
> Katie
>
> On Feb 7, 2020, at 5:09 PM, Jim Walseth <jim.walseth at gmail.com> wrote:
>
> 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/20200211/b972f1bd/attachment.html>