A Few Key Posts

For those who feel 2+ years of a blog qualifies as TL;DR.

Advertisements
Posted in Feelings, myExperience | Leave a comment

PrezPlayPro Progress

I’ve made so much progress since I last revised my schema in Nov 2017. Most of that progress has been in the last week — two weeks at the very most. The Mobile Web Specialist nanodegree program I’m in as a Google Udacity Scholar via a Grow With Google scholarship has made my skillset and confidence go all supernova.

See also: I have a dream come true (2012 results made manually in Photoshop)

Here is what I’m up to:

pppProgress.png

Gray states are those with no socialist candidates (or there were socialist candidates but they received zero votes).

This query fetches only socialist candidates (excluding Hillary Clinton in one state where she’s actually on the ballot as a socialist — she’s not included because then she’d win all the states … until I fix my query by, hopefully, finally completing the affiliations table below) to see who among would “win” among the socialist candidates.

Here’s the new schema … I still haven’t added a stateAbbr column to the affiliations2016 table which, I think, is the reason for a problem I’m having with my first major query.

schema_061918.png

I need some buttons to change what results are fetched and displayed including but not limited to:

  • Results if all the “left-ish” third parties voted for a single candidate — would that candidate have beaten Trump?
  • If all the right-ish votes went to Trump, would he have have won the popular vote?
Posted in Elections, myLearning, myProgress, myProjects | Tagged , , , , , | Leave a comment

Mentor to the Masses

Check it out — I answered my first bona fide StackOverflow question!

stackAnswer.png

I’m practically the greatest programmer and teacher in history now.

Pretty much.

Posted in myLearning, myProgress | Leave a comment

I Can Feel the Power

Geeky Iron Maiden data is at the bottom.

Learning so much in the Mobile Web Specialist nanodegree. My Dev Tools skills have exploded. For example, I’ve struggled for hours (all together over the course of many days) to figure out what’s making my pretty new album chart display with either way too much margin:

idol

Note also the horizontal scroll showing how much space is there for nothing.

or, when I tried (among other “fixes”) the fix that did anything remotely desirable, up against the left with no margin:

billyIdol

Well, today, I used my little web app to look something (Iron Maiden related — see below if you’re interested) up and — a combination of irritation and actually having the time — I fought with it until I fixed it.

The chart is in a DIV with

id="forChart"

No matter what style in CSS or property in D3 I changed, nothing seemed to work. I also tried removing various DIVs and, opened my dev tools and saw that the page was still seeing a style for #forChart I’d commented out a while back. Even though the page file itself was being updated when I refreshed, the CSS wasn’t!

Once that was fixed by clearing my cache, it was better but still didn’t look right so I uncommented the “container” DIV I’d commented out while debugging and that added some huge margins again. I was back to having Yucky Version A …

ironMaiden_2400.png

or Yucky Version B.

ironMaiden_wContainer.png

Just to make sure — because I was going insane — I at least identified the culprit was something in Bootstrap by removing all the Bootstrap:

ironMaiden_noBootstrap.png

I went back to Dev Tools and, while I couldn’t see anything affecting the margins, I scrolled all the way down to the little diagram showing the margins and padding. When you click the components inside, it highlights them in the browser so I could see there was a buttload of margins — I just had to figure out where. Then I realized that when I clicked in the code (the Elements tab of DevTools), it showed much more specific information under the Styles tab.

Then I finally got to do one of the coolest things Dev Tools can do which is hack around in the code to change what’s displayed. So I could test it “live” without uploading, refreshing, testing, changing the code again, etc. … OH MY GOD what a time saver!

Once it was beautiful, I copied the new CSS fromt the Styles tab, pasted it into my CSS file, uploaded, and viola! Awesomeness.

fixed.png

What made me visit my little app today was this … the sort of nerdy curiosity about data that inspired the app in the first place.

Geeky (Geekier) Iron Maiden Data

I was celebrating yesterday’s purchase of Iron Maiden‘s Live After Death by pricing some of the other albums on Amazon — in particular, Brave New World because it is my second favorite album of theirs and it has a wicked cool cover similar to Live After Death.

And this nonsense is what I saw …

nonsense.png

Can you see it? What a … a travesty! an injustice!

“Blood Brothers” — obviously the best song on the album, has like zero popularity. I couldn’t even hum what Amazon says are the most popular tracks from memory. I almost lost my faith in humanity. So, I went to my little app to see how the song rated on Spotify.

First I sorted all their tracks by Track Name.

myspotBlood.png

Various versions of “Blood Brothers” do seem to be a bit low on the curve. For comparison, I sorted by popularity. Here are their top tracks as of last Sunday.

topMaidenTracks.png

Then I sorted by album so I could see how the song placed compared to other tracks on the album — the way Amazon showed them.

braveNewWorld.png

On Spotify, it is the second most popular track on the album and by a decent margin.

Posted in D3, Data Visualization, Debugging, Developer Tools, myProgress, myProjects, Spotify, Web Development | Tagged , , | Leave a comment

My Train of Thought Down the Internet Rabbit Hole

Stop #1

While reading Twitter, social network analysis and data jouralism by Alessandro Zonin, one of many articles I found this morning during my first visit to LinkedIn‘s Data Journalism group,

Stop #2

I clicked a link to an obscure book (Who Shall Survive? by Jacob Levy Moreno) cited by the author. I am so grateful for the age in which we live where not only can I instantly go to the 84-year-old primary source without leaving my seat but then send my very own free copy to multiple devices with which I can read it anytime, anywhere.

I love archive.org (home to the WayBack Machine, among literally–and I mean literally in the literal sense–millions of other things).

Stop #1 again

A couple charts in Zonin’s article inspired a couple ideas for my Spotify app but I didn’t know the name of the chart type I wanted to use so I

Stop #3

Googled “types of charts” and, after opening a few results in other tabs,

Stop #2 again

I returned to archive.org and searched for “charts” wondering if there were other really old cool books related to data visualization.

One of the results was Charts On Ciphered Codes by William F. Friedman which is interesting to me in and of itself because I love Edgar Allan Poe who was one of the greatest cryptographers in history but also interesting because the book is in the William F. Friedman NSA Collection. So I clicked it

Stop #4

and saw it is also in the nationalsecurityarchive which, of course, I clicked. Here’s that collection of collections:

nsia.png

Those are just the top results. Look at all that yummy goodness!

Stop #5

 

The National Security Internet Archive (NSIA) above includes, among a giant pile of candy like the Friedman NSA Collection, the NSA Archive.

nsa.png

Am I the only thinking, “What are the Venona Documents”?

That Dept. of Army Technical Manual and a Field Manual that appeared a little further down both reminded me of my best friend from high school and college who collected lots of books that probably creeped most people out. He was not only one of those people with shelves of true-crime novels about serial killers but he also had books he could only find at gun shows like the infamous How to Kill from Paladin Press and an innocence-shattering Department of Defense book on … the title either called it “advanced” or “enhanced” interrogation. He bought this and I saw it in the early 90s, 10-15 years before such a term entered the mainstream vernacular.

Stop #6

So I googled that. First, I searched for “DOD advanced interrogation handbook”. What I find most interesting about these are URLs … I am also so grateful to live in a country were our government is this transparent and the rest of us are free enough to question and criticize our government.

advanced.png

The results often included “enhanced” so I then started searching for “enhanced interrogation” — that auto-populated as “enhanced interrogation techniques pdf” so I used that.

enhanced.png

I opened many of them in other tabs but think I’ll just close those and get back to thinking about things less dark on this Wednesday like … today is my wife’s birthday and my daughter is baking a cake.

Well, I closed all of them except for this one …

charts.png

 

 

Posted in Cryptography, Data Visualization, privacy, Resources, Security | Leave a comment

Just Some More Screenshots

Last post like this, I promise. Not that anyone reads this. I’m just quite pleased with myself. Some more album graphs featuring album art — yay for me.

Cirith Ungol

cirithUngol.png

Billy Idol

billyIdol.png

Generation X

Note that this group that had only, like, two albums … has 8 or nine depending on how many you count and … AND … more than Mr. Idol who legit has many more than they did together.

genX.png

Mortal

mortal.png

Circle o’ Dust

circleOfDust.png

I’m so glad bands like those last two are finally available digitally. If only we could get Under Midnight albums without hours of searching.

Posted in Music, myProjects, Spotify | Leave a comment

“More Popular Than Jesus” Part Deux

My “all artists” ranker thingy now has album art. When I saw it for the first time, I noticed something. Previously, all the “christian” artists were lumped together at the bottom … of the very bottom 28, only one artist was “secular.”

See also: “More Popular Than Jesus” – John Lennon

I’ve added some artists since then but not enough — I don’t think — to mix them up as much as they are now … I find this sort of thing interesting … which is why I do stuff like this and why I love programming and data and … other nerdy things …

55_47.png

Like last time, DC Talk is the highest if you don’t count Alice Cooper and such. I included several bands above them to give an idea of what’s down there on top of [hey … MxPx is a few higher than DC Talk! I just checked and that’s right where they were at the time of the last post, too … so, I was wrong] all the christian peeps.

46_38.png

Last time, I just noted that amidst a huge chasm was Stryper. There they are. Same place. Just above Venom, Gwar, and Sodom. He he.

For the record, “Ronnie James Dio” the person is not Dio the band. That RJD thing is some solo song … some solo song that is not “Dream On” or any of his Doo-Wop or … oh, note to self … add Elf

Down a few more and we start to see the frequency of the christian peeps spike beginning with King’s X.

38_24.png

Cirith Ungol–stuck amidst the gospel artists–is a new addition to my database. Heaven & Hell, for those who don’t know is not a “christian” band but is what Black Sabbath called themselves for a single album when Sharon “Nobody messes with my husband” Osbourne threatened to beat them up.

22_10.png

Last time, Iggy & James were the only secular artist(s) down this far.

10_00.png

I can’t believe Deitiphobia has a poor, little zero. Fear of the Digital Remix is one of the all time greatest albums EVER. E-V-E-R.

Okay … maybe they didn’t get all mixed up like I thought so maybe this is kind of a waste of a post but, hey, look! I have artist images now!

Posted in Music, myProjects, Spotify | Leave a comment

Major Milestone Monday

After lots of hard work, I have D3 not only working with my database but have album art to go with the albums. It took me a while — even after I got the album covers to appear — to get the covers to display where I wanted them. I had to do math a lot. Still not “done,” but this is a big, big deal. This is my #BadAssTakeover.

I have cron jobs that regularly reach out to Spotify and store the popularity of artists, albums, and tracks. Here is a sampling of the bar graphs I can now do. Albums are in chronological order and the numbers are the popularity scores as of Sunday, April 22, 2018. Their popularity scores are relative to all albums on Spotify but I don’t know how they work … I don’t know if an album’s popularity takes into consideration the tracks’ popularity.

Click all images for full size

Alice Cooper

aliceCooper_01

Alice has tons of compilations which is frustrating for multiple reasons. He’s one of the artists that makes me think a vertical graph might be better.

aliceCooper_02

David Bowie

davidBowie_01

As you might expect, Bowie has a ton of albums even without compilations.

davidBowie_02

I’m not sure what the albums without art are … their titles are visible in a sortable table on a different page but I’m busy at the moment …

Bride

I chose them as a sample for a couple reasons. One, they have relatively few albums and two, they were played last night on IntenseRadio during The Great Scott Diversion.

bride

Deliverance

I really don’t like Deliverance but a lot of people do and they have a new album out.

deliverance

Iron Maiden

I feel like I should like Iron Maiden more than I do. Today was a bad Iron Maiden day for me. I’ve been trying to find a relatively inexpensive used copy of Live After Death (on vinyl) and finally found one at a local used record shop but they wouldn’t sell it to me because it wasn’t priced yet. How do I know it was relatively inexpensive if it wasn’t priced yet? The cover was in horrible condition.

ironMaiden

Led Zeppelin

I chose them because I wanted to show some really tall columns … all that “gray space” in the screen shots is how high up the columns could go.

ledZeppelin

Led Zeppelin is another reason my recent … I’ve started buying records again — for the first time in over 30 years — and it’s a lot less fun than I thought it would be.

Meat Loaf

meatLoaf

I think all those blank spaces are compilations. He’s like Alice that way. Ew.

Mortification

Mortification, like Deliverance, are in my database because I wanted a health selection of thrash and black metal and similar artists to compare to each other.

mortification

One Bad Pig

Because I love them.

oneBadPig

They only have four albums which is sad. Well, they’ve also got a demo and a live album but those aren’t on Spotify.

Resurrection Band/Rez Band/Rez/Resurrection Band

rez

For some reason, there’s at least one … wait … it does say Resurrection Band … I thought Ampendectomy was a Glenn Kaiser solo album. Can you believe Lament isn’t their most popular album? People are dumb.

Posted in D3, Data Visualization, Music, myProgress, myProjects, Spotify | Tagged , , , , , , , , , , , | Leave a comment