Anon is here.
Wanna help me make a relational database with Q drops?
Had first hoped to take
https://docs.google.com/spreadsheets/d/1Efm2AcuMJ7whuuB6T7ouOIwrE_9S-1vDJLAXIVPZU2g
and pull columns to create a cleaner spreadsheet.
But, can't find the times stamps on that one (although spreadsheet anon swears they are in it.)
So then thought to pull it from the raw text files in the dough stored on pastebin.
pastebin.com/3YwyKxJE
Is the first of three.
Then decided to start with the first 84 posts given this one from Q. Image attached.
Worked with excel to import the raw text, and was able to manage the columns for various header information, but when it came to the text it wouldn't import properly.
Also considered using DHTMLX - which I think is java - in hopes of importing to something like Freemind which is also java.
As explained on the main board, hope to create a database that will offer returns based on timestamps or phrases (Godfather III as an example) similar to
https://www.sixdegreesofwikipedia.com
Thanks of any help!
>https://github.com/jwngr/sdow
Whoa. Now I'm in new territory. CodeFags are something else. I breed them, but have never spent the time to learn more than spreadsheets or html.
I have the resources to make a website, but that wasn't my first goal.
My primary goal is to properly map the first 84 posts. I'm absolutely convinced we've missed something.
The "spider web" database is in my mind the proper way to manage it.
OMGosh is that your work at qanon.news? Stunning.
If you, then much is already done. Would like to be able to sort the posts by minutes, though, as I'm suspicious that counts. (Two images of first 84 included. See anything?)
Also, for analytics, could there be a bubble chart for phrases?
I think I'm going to work backward a bit, and then be in touch. I want to map a few by hand to show you what's in my head, and from that example perhaps you can see the outcome I envision. Then we figure out how to sort the data to make it happen.
Dang. It's fabulous to talk this through. We'll see how it goes
Oops. That sort is by hours and then minutes.
When Q says wind the clock - are these time stamps important in order?
Were we able to see the text would the markers appear to have better meaning?
>Timezones are a thing.
That's why I think only MINUTES matter on the clock.
Minutes give Q 60 slots to categorize. Thinking there's a there there. 01 is one subject, 02 another, etc.
(Watched the team try to grab seconds one night. Rarely accomplished.)
I am trying. I am failing.
Don't have the resources to map the drops by image.
Want to map them according to phrases and clues and subjects.
Arrrrrgh.
Also, tomorrow I'm going to work on the clock, which is separate from the map, and might be less frustrating technically.
Images are first 84 drops sorted by minute time stamps.
This is from the timestamp spreadsheet someone else has done. The very right column is deltas. The shading is 0 5 10 or 20.
Right now I wonder if you find the phrases and then sort them by minutes in the time stamp.
I can do it other ways, though. For instance, qanon.pub has a few phrases inserted to sort by. But I have to choose from one of the preset phrases. It returns the posts in drop order, but if the search for something like Alice & Wonderland also has the phrase Snow White or Godfather III I can't draw lines between all of that.
Of course, I could print everything out and tape it up and use string. :D I could enter every text manually in a mind map like free mind.
What is in my head is a way for a program to do it like sixdegreesofwikipedia. Enter a search term and boom. All the secondary connections pop up.
I know. It's a lot to dream.