Ray,

We've been working on adding some features to the directory on the wiki and a very helpful volunteer has updated a lot of info for US-based shops, so this should be pretty comprehensive for the shops we already knew about:

Table of shops with contact info: https://bikecollectives.org/wiki/index.php?title=Special%3ACargoQuery&tables=shop_info%2C+&fields=shop_info._pageTitle%2C+shop_info.email%2C+shop_info.phone%2C+shop_info.other_contact%2C+shop_info.country%2C+shop_info.year_dissolved%2C+&where=&join_on=&group_by=&having=&order_by%5B0%5D=&order_by_options%5B0%5D=ASC&limit=50&offset=50&format=

The same thing as a CSV file you can open in Excel or similar: https://bikecollectives.org/wiki/index.php?title=Special%3ACargoQuery&tables=shop_info%2C+&fields=shop_info._pageTitle%2C+shop_info.email%2C+shop_info.phone%2C+shop_info.other_contact%2C+shop_info.country%2C+shop_info.year_dissolved%2C+&where=&join_on=&group_by=&having=&order_by%5B0%5D=&order_by_options%5B0%5D=ASC&limit=50&offset=50&format=csv&delimiter=&link+text=&filename= (click the "View CSV" link to download the file)

With either of those you can use the "Modify query" section at the bottom to change what data it pulls, whether it gives you a table or a file, etc.. More advanced features like filtering require some knowledge of SQL, at least for now.

There are almost certainly still missing shops and bad data in that list, but for the US it's probably as up-to-date as it has been in several years.

I hope that's helpful!

April Wick (she/her)

P.S. If BRAIN is interested in supporting the maintenance and further development of that list and similar projects, we've got a way to handle donations now via OpenCollective. You could even earmark it specifically for something like improvements and updates to the list of Collectives, if you want.



---- On Tue, 09 Jan 2024 09:17:47 -0800 Ray Keener via TheThinkTank <thethinktank@lists.bikecollectives.org> wrote ---

Super helpful, thanks, Emily! Here's the previous BRAIN article FYI.

I know it sounds greedy... what I'd really like (if it's available anywhere) is an Excel spreadsheet where I can copy and paste e-mail addresses in one fell swoop.

Barring that, I'll set aside a morning to go through the state-by-state list and fish them out of there! Thanks again, and good luck in 2024!



On Tue, Jan 9, 2024 at 10:10 AM Emily Gage <emily@phoenixbikes.org> wrote:
Hi Ray, I'm not sure how updated it is, but there is a list of community bike organizations on the Bike Collectives site here: https://us01.z.antigena.com/l/VIH9xbwi3aAcngVan_QO2tTU6zAwGfMQvCFjXIcDJtB0JXvhTcqM_bh-lfbtKcgN1_lWtdTN5wkHUqls4UMZMMplo3It8fPMXWOFJypI2cK9IgT7XePjCk03FTKJ4KBSrB6k3wXzmi1tsL2gdIxuKa27_b6cjG-wWiHl8zLuq3Lw4sGG4LBJxkzOdajtUwpE . Hope that's helpful. 







On Tue, Jan 9, 2024 at 12:05 PM rkeener--- via TheThinkTank <thethinktank@lists.bikecollectives.org> wrote:
Hi I'm Ray Keener, Retail Editor of Bicycle Retailer and Industry News magazine, former President (2013-16) and current Industry Liaison with Community Cycles here in Boulder. I wrote a BRAIN story about community bike shops back in 2016. I'd be glad to share the story if there a way to attach a .pdf?

It's time to do this story again. Last time, someone at bike!bike! provided us with with a list of community shops to which I sent the Survey Monkey. Seeings how this benefits you at bike!bike! and all community shops by providing information, and the industry overall by promoting understanding of what y'all do...

Might you be willing to either provide the list, or send out a link to the survey to your list, please? I'm glad to hear back from anyone on here if you can point me in the right direction!

Cheers and Happy New Year, Ray
(303) 525-5489
_______________________________________________
TheThinkTank mailing list -- thethinktank@lists.bikecollectives.org
To unsubscribe send an email to thethinktank-leave@lists.bikecollectives.org
To view this discussion on the web visit bikecollectives.org


--
RAY KEENER
Retail Editor
Bicycle Retailer and Industry News
(303) 525-5489


This message and any documents, files or previous e-mail messages attached to it may contain confidential information and is intended only for the individual named herein.  If you are not the intended recipient, you should not disseminate, distribute, review, or otherwise make use of this information.  Please notify the sender  immediately by telephone or return e-mail if you have received this email in error, and delete the original transmission and its attachments and destroy any copies thereof. Thank you._______________________________________________
TheThinkTank mailing list -- thethinktank@lists.bikecollectives.org
To unsubscribe send an email to thethinktank-leave@lists.bikecollectives.org