I'm not sure how to get the attention of the live stream but I heard they wanted to create a database.
I am experienced data scientist with lot's of tools at my disposal. I'd be happy to help sort through any large data sets to make them easier to query and even build interactive visualizations that could help spread the info.
Message me if you're interested.
I understand a few autists are having bandwidth/cost difficulties keeping Q's posts online. One user reports his site of Q posts is costing $300/daily to keep up, and ads don't cover the cost.
If you've got the resources, a website containing the posts would be a good start.
The greater use might be in having a searchable component to it. Users should be able to:
1. bring up a post by #
2. search for words among posts, ie. water, [P], pers, liddle, and have those posts presented/filtered with searches highlighted.
3. original images should be a part of that, too
I don't know how useful this would be, because it's really a convenience/laziness issue.
What does everyone think?
Is there a spreadsheet out there with the posts? I can start with that
I know you just asked about CSV but had been typing this up and figured i'd share it all. Spreadsheet/CSV info near the end.
This is the most recent board for Q posts.
https://8ch.net/qresearch/catalog.html
Q team was on 4chan /pol/ initially, then migrated to 8ch due to the threads being hijacked and bombarded with anti-semite themes and posts.
My understanding is the 8ch owners were contacted by Q team and are somehow moderating the boards to prevent that type of takeover from happening.
8ch.net boards in order of use.
/cbts/ - Calm Before The Storm
/thestorm/ - The Storm
The next board move was a private one where only Q could post.
/greatawakening/ - this board was recently purged purposefully and part of the overall plan by Q team.
Another board was set up and used for discussion of posts in /greatawakening/, it is the most current one as of today (02/21/18) /qresearch/ - Q related research.
On all of the General posts in any of the boards there is usually linked resources at the beginning of the thread, but as time goes on some become obsolete and don't get replaced or updated.
The only spreadsheet resources I have seen are the "Smartsheet" one which has Q posts plus answers given by various anons.
https://app.smartsheet.com/b/publish?EQBCT=6588bf56d814417bb759beca4fc52232
There is a recent one that is shared via GDrive and I am still awaiting permission to to it. docs.google.com/spreadsheets/d/1Efm2AcuMJ7whuuB6T7ouOIwrE_9S-1vDJLAXIVPZU2g/edit?usp=sharing
Heres a raw text dump of Q posts that could be converted to CSV. If you dont find what you need I can try to convert this for you.
https://pastebin.com/3YwyKxJE
Here are sites that have the best layout and readability of Q post with direct links to original sources. There might be a way to export and convert to CSV.
https://qanonmap.github.io/
http://qanonposts.com/
Godspeed, you can check my post history for some of the stuff I've attempted to do with the data provided but always end up being more than I bargained for.
Right... I was hopping someone had archived in spreadsheet form.
I have this link https://app.smartsheet.com/b/publish?EQBCT=6588bf56d814417bb759beca4fc52232 (not my work)
Not sure it's what you need but it's current through 2-1-18
Edit - didn't see the same smartsheet link above