I’ve made myself a birthday playlist nearly every year since 2002. The playlists are meant to played in order, not on random. (Pre-2012 Spotify playlists probably have broken links to the copies of the songs on my computer.) Where certain tracks aren’t available on Tidal, I added a link to a YouTube video in the track listing.
Jump to: 2023 | 2022 | 2021 | 2020 | 2019 | 2018 | 2015 | 2014 | 2013 | 2012 | 2011 | 2010 | 2009 | 2008 | 2007 | 2006 | 2005 | 2004 | 2003 | 2002 | Meta-analysis
2023
Listen on: Spotify
Track listing
- Attack of the Ghost Riders by
- Vacant Lot by
- Pelican by
- Humbug Mountain Song by
- Howling by
- Brotherhood by
- Beograd by
- Pa Pa Power by
- Wayfinder by
- Canon Pt. II by
- Confetti by
- Spellwork by
- Taurus by
- I Go by
- The Killing by
- Disobey by
- Walkman by
- Obey by
- Hardware by
- Kinda I Want To by
- Synapse by
- Feet by
- Ghost Town by
- Howl by
- That Life by
- My Little Japanese Cigarette Case by
- Gore by
- Soft Stud by
- The Well by
- Dream Steppin’ by
- Navy Light by
- Wise Men by
- Disciples IV by
- Closed Captioning by
- All This Time by
- Thug Feast by
- I <3 U SO by
Breakdown of included tracks by release date:
2022
Track listing
- Heaven by
- Meateater by
- Lust by
- Scatter the Scars by
- Shoom by
- Adult Goth by
- Goodbye (feat. Lyse) – Slow Version by
- Vessel by
- Such a Whore (Baddest Remix) by
- Walkman by
- Attica by
- The Motor by
- Say Hello to the Angels by
- Okay by
- Dear Miami by
- Clovers by
- Lovely 2 C U by
- All Work by
- Steam by
- I Feel the Transition by
- The Breaks by
- What Do You Want by
- Attack by
- Clouds by
- SIMMER DOWN by
- Us by
- Buchla by
- Obey by
- Plastic Wrap by
- can’t stop me from dying by
- Harsh Realm by
Breakdown of included tracks by release date:
2021
Track listing
- lucy by
- Roscoe by
- Oino by
- Vampires by
- Two Hearts by
- Play Out by
- Bone by
- I Saw You Close Your Eyes by
- Fire for You by
- Bad Times by
- From Nowhere by
- You Used to Love Me (feat. Denitia) by
- Small Town by
- Dimension Shifter by
- Soldiers by
- I Won’t Let You Down by
- Electricity (Rush) by
- Reset – EP Version by
- The Winds of Change by
- Partners in Motion by
- Banned From Living by
- Vide Noir by
- Move – Tensnake Remix by
- Hush by
- Re (Visit) by
Breakdown of included tracks by release date:
2020
Track listing
- Sea Salt & Caramel by
- Lost In Yesterday by
- Your Letter by
- Feel It All Around by
- The Suburbs by
- I Dreamt We Spoke Again by
- The Well by
- 30% Off! by
- The Rover (DJDS Remix) by
- Feel It by
- Into Happiness by
- Glitches by
- Patience by
- It Might Be Time by
- 61 Cygni Ave by
- Amabutho by
- Scavenger by
- Apocalyptical by
- In A Spiral by
- Friends – Psychemagik Remix by
- Slumlord by
- The Reeling by
- Borderline by
- Night Running by
- Feather by
- One More Hour by
- Deadly Valentine by
- Magnetism by
- Solitude – Felsmann + Tiley Reinterpretation by
- Devils And Angels (Hatred) by
- Breathe Deeper by
- Feel The Way I Want by
- I Could Use A Miracle by
- Anxious by
- Pluma by
- Good Luck by
Breakdown of included tracks by release date:
2019
Track listing
- Battlefields by
- In Private by
- Invite Me In by
- You Used to Love Me (feat. Denitia) by
- Love Me Again by
- Loan Shark Blues by
- Put Me to Work by
- You’re Mine by
- Hott by
- More Like You by
- Glass Island (feat. Lacey Guthrie) by
- Egowerk by
- Dam Girl by
- You’ve Changed by
- Confide In Me (triple j Like A Version) by
- Journal of Ardency by
- Afterglow by
- Hardware by
- main by
- Call It Home by
- The Wave – Instrumental by
- Favorite Lover (Dead Astronauts Theme) – Original Mix by
Breakdown of included tracks by release date:
2018
Track listing
- When I Get Home by
- Gods in Heat by
- Stoned – Yoke Lore Remix by
- I Never Knew by
- Friends by
- &Run by
- Nighttalk by
- Sincere by
- Face Down In The Gutter Of Your Love by
- If U C My Enemies by
- Forget – Radio Edit by
- Be Afraid by
- Ready Aim Fire – Owl Vision Remix by
- Terror by
- warpaint by
- Stone Men by
- NY by
- Nevermind by
- Little Dark Age by
- My Trigger by
Breakdown of included tracks by release date:
2015
Track listing
- Nightcall by
- All Your Light (Times Like These) by
- The Sting by
- Pity the Free Man by
- Yellow Flicker Beat by
- Beat And The Pulse by
- Killing Strangers by
- Rampage by
- Arabella by
- Fresh Blood by
- Ain’t Gonna Drown by
- Truth by
- Renegades by
- Heartbreaker (feat. John Legend) by
- Paddling Out by
- White Lies – EP Version by
- Last of Our Kinds by
- My Type by
- Shades Of Black by
- Embody by
- Dangerous (feat. Joywave) by
- R U Mine? by
- Tear You Apart by
- Change (In the House of Flies) – Acoustic; 2005 Remaster by
- West Coast by
- Boom by
- Purple Yellow Red and Blue by
- Peaches by
- I’m On Fire – From “Fifty Shades Of Grey” Soundtrack by
Breakdown of included tracks by release date:
2014
Track listing
- If I Had A Heart by
- Scheherazade by
- Deserts by
- Happy Home by
- Alarm Call by
- Mercy Street by
- West Coast by
- Shotgun Vision by
- Brief Encounters by
- Fire by
- Come with Me Now by
- Dangerous (feat. Joywave) by
- Odessa by
- Evil Eye by
- Death Drive by
- Modern Jesus by
- Stolen Dance by
- Bad Blood by
- Fear & Delight by
- R U Mine? by
Breakdown of included tracks by release date:
2013
Track listing
- Can’t Play Dead by
- Dollars In the Night by
- Gold Rush Pt. II by
- Winged Beat Drums by
- Carried Away by
- Hold the Night by
- Second Chance by
- Talking in Your Sleep by
- Hallways by
- What’s Happened to Soho? by
- Girls by
- In For The Kill by
- Evil Eye by
- Blowing Off Steam by
- Cheating With You by
- Backslider by
- Deserts by
- Bones by
- Soul Meets Body by
- Quicksand by
- Take a Walk by
- Safe and Sound by
- Disparate Youth by
- Keep You by
- Death Drive by
- Hurricane by
- Signs by
- Head Over Heels by
Breakdown of included tracks by release date:
2012
Track listing
- Driving My Escort Cosworth To The Cake Circus by
- Happy Up Here by
- Little Talks by
- Sunny by
- It Don’t Move Me by
- Satin Chic by
- Never Go Solo by
- I Need A Dollar by
- JJC Sports by
- I Want You! by
- Options by
- Hallways by
- No You Girls by
- Automaton by
- Too Close by
- Tiny Man by
- Ambulances by
- What’s A Girl To Do? – Edit by
- Midnight City by
- Last Night by
- Jealousy by
- Half Life by
- Röyksopp Forever by
- Keep The Streets Empty For Me by
Breakdown of included tracks by release date:
2011
Track listing
- Ulysses by
- The Ghost Inside by
- Triangle Walks by
- Happy Up Here by
- Pumped Up Kicks by
- Ace of Hz (Album Version) by
- This Too Shall Pass by
- White Collar Boy by
- Four Winds by
- Rolling In The Deep by
- No You Girls by
- Rox In The Box by
- Fell on Black Days by
- Stick W/ Me Kid by
- Heads Will Roll by
- Tighten Up by
- Victorian Vigilante by
- Mirage by
- It Makes Me Wonder by
- Two Against One (feat. Jack White) by
2010
Track listing
- Like A Pen by
- Black Hole Sun by
- Closer [Explicit] by
- Heads Will Roll by
- Candy Flip by
- Tiny Cities Made Of Ashes by
- Crystalised by The
- Fire In Freetown by
- Ships And Clouds by
- Bullet With Butterfly Wings by
- Until the Day You Die by
- Home by
- Lithium (Nirvana Cover) by
- Tonight, Tonight by
- Crisis 1 & 2 by
- One Hit by
- Up on the Roof by
2009
Listen on: Tidal | Spotify (I suspect this one should be played on random)
Track listing
- Crisis 1 & 2 by
- The Beginning Is The End Is The Beginning [Explicit] by
- Willful Suspension Of Disbelief by
- Devout by
- You’re The Good Things by
- Electric Feel by
- Mykonos by
- Neonland by
- Diamond Dave by
- Red And Purple by
- Won’t Want for Love (Margaret In the Taiga) by
- Over The Falls by
- Up on the Roof by
- We Share Our Mothers’ Health by
- Sugar by
- Marble House by
- Forest Families by
- Predict The Day by
- Time To Pretend by
- Love Letter To Japan by
- Personal Jesus by
- Big Time by
- Silent Shout by
- Shake Hands With Beef [Extended Version] by
- Southbound Pachyderm by
- Paralyzer by
- The Arm by
- Runaway by
- Ragged Wood by
- Blue Ridge Mountains by
- Flesh & Bone by
- Gold Into Straw by
- Candy Shop by
- Tea & Thorazine by
- Lights Off by
- Your Protector by
2008
Track listing
- Aly, Walk With Me by
- Neonland by
- Harder, Better, Faster, Stronger by
- Paralyzer by
- Heartbeats by
- Creeper by
- Generation Celebration by
- Ragged Wood by
- The Arm by
- Revenge of the Number by
- In the Rushes by
- Crazy [Album Version] by
2007
Track listing
- Silence is a Burden by
- El Camino Del Che by
- Damned If I Do by
- The Doubtful Guest by
- Half A Person by
- In Liverpool by
- We Danced Together by
- Never Destroy Us by
- Heat Dies Down by
- People Are People by
- New Black Day by
- Fett’s Vette by
- Everywhere You Turn by
- Smoke and Mirrors by
- In The House – In A Heartbeat by
- A Beautiful Morning by
- When I Grow Up by
- Detroit Swing 66 by
- So I Fall Again by
2006
Track listing
- Holy Shit by
- Cocaine and Toupees by
- We All Fall Down by
- Equus by
- Noir Désir by
- Light & Magic by
- Strangers by
- Slippage by
- Every Planet We Reach is Dead by
- Faggot by
- Time Is Running Out by
- Paper Heart by
- Ocean Breathes Salty by
- This is Hardcore by
- Friend is a Four-Letter Word by
- Bukowski by
- New York’s Not My Home by
- The One You Love by
- outsiders by
2005
Track listing
- Oxygene I by
- Mad Man Moon by
- Even Song by
- devil’s playground by
- Side by
- Cherries by
- The Prize Fighter by
- Snowden by
- dirty horse by
- The Good, the Bad and the Ugly by
- I’ve Got More by
- Cherry Lips (go Baby Go!) by
- Train by
- Destroy Everything You Touch by
- Fight Fire With Fire by
- A Hazy Shade of Winter by
- Memory Lane by
- Knock Yourself Out by
2004
Track listing
- Foreplay/Long Time by
- Refugee by
- Song 2 by
- Blue Monday [Single Mix] by
- Anything for Your Love by
- Lines in the Suit by
- Melancholia by
- Writing to Reach You by
- L’Amour est Bleu by
- Survival by
- Still in Love Song by
- Satin in a Coffin by
- Sunrise by
- Thank You by
- Hey You by
- In the Air Tonight by
2003
Track listing
- Livin’ Thing by
- Tonight She Comes by
- Baba O’Riley by
- Imperial March (Darth Vader’s Theme) by
- Valley by
- He’s Simple, He’s Dumb He’s The Pilot by
- Are You A Hypnotist by
- Emma J by
- The General by
- Date With the Night by
- There’s No Home for You Here by
- The Crystal Lake by
- Pestilent Muse by
- Bad Company by
- No, Not Now by
- I Hung My Head by
- AM180 by
- Jerk It Out by
- Not Coming Home by
- Island In The Sun by
- Russians by
- Standin’ in the Rain by
- Nights in White Satin by
- From the Beginning by
- Lonely Day by
- Jed The Humanoid by
Meta-analysis
This is just me having fun. 😁
Relative length of playlist by year:
Distribution of release dates of included songs from 2012-2022 playlists (songs released before 2009 omitted for space):
Diversity of release years by playlist year (i.e. number of years songs were released), 2012-2022:
Distribution of 34 repeat artists by number of songs included from 2012-2022 playlists (an additional 140 artists appeared once):
Top six appearing artists (2012-2022 playlists):
Distribution of 72 repeat artists by number of songs included from 2002-2022 playlists (an additional 208 artists appeared once):
Top nine appearing artists (2002-2022 playlists):
9 replies on “Birthday playlists”
I’m a book lover, sci-fi writer, and native plant nerd. Learn more about me, and see what I’m up to now. This is my personal site — you may be looking for my professional sustainability consulting services. Explore my site Join me in pondering my big questions (my approach to organizing my learning and thinking…
What’s Tracy up to lately?
Updated 7/15/2023
Started my own business offering consulting services in sustainability outreach and planning 🌎 🙌
Writing a sci-fi novel 📝 Aiming to (finally) self-publish in fall 2023!
Continuing to mask up and avoid indoor spaces 😷
Posting thoughts and saving bookmarks here 🤓
Lately I’ve been sharing weeknotes about what I did and read each week.
Basics:
Located in Washington State in the Seattle area
Living in the suburbs with my husband and two cats
Inspired by Derek Sivers
Listen Posts (podcasts, albums and tracks)
Music Data
Listened in 2024
Listened in 2023 | Music of 2023
Listened in 2022 | Music of 2022
Music of 2021
Last.fm profile
Favorite Music
Best of Year Playlists
Birthday Playlists
Favorite Albums
To Listen
Music to Try
Podcasts to Listen to
Listen Posts (podcasts, albums and tracks)
Music Data
Listened in 2024
Listened in 2023 | Music of 2023
Listened in 2022 | Music of 2022
Music of 2021
Last.fm profile
Favorite Music
Best of Year Playlists
Birthday Playlists
Favorite Albums
To Listen
Music to Try
Podcasts to Listen to
I created a list of my annual birthday playlists since 2002.
For this process, I used a third party program to extract the data, Excel to format it, and CSS to style it. I’m assuming you’ve used formulas in Excel before so you can plug in the appropriate cells, and have written simple HTML and CSS.
Getting the data
I used Exportify to download a .csv file of all my Spotify playlists.
Columns included that I used in this process:
Track Name,
Artist Name,
Album Release Date,
Album Name,
Album Image URL
Track list
I used the CONCATENATE function in Excel to compile the HTML list to paste into WordPress. You could do this all in one step; I did it in multiple steps so I could experiment with showing different things, and so the cell didn’t get crazy long.
I created a column with the link to the track:
=CONCATENATE("<span class=",CHAR(34),"h-cite track",CHAR(34),"><span class=",CHAR(34),"p-name tracktitle",CHAR(34),">",[CELL WITH SONG TITLE],"</span> by <span class=",CHAR(34),"p-author artist bandname",CHAR(34),">",[CELL WITH ARTIST NAME],"</span></span>")
I created another column that created the list item that I could paste into WordPress:
=CONCATENATE("<li>",B2,"</li>")
To keep the page from being super long, I added the track list to the page using the <details> property, which allows it to be clicked on and expanded. Then I used CSS to style “details > summary” to look like a link so people know to expand it.
Adding Microformats
I also included (experimental) microformats based on what I use for my books. Microformats allow other programs to correctly interpret specific types of data, such as a book or (in this case) song citation. No program currently reads microformatted playlists, but I figured better to do it now than wish I had done it later 😉 Once it’s done, the odds I’d go back and update it are low. I picked my own microformats because there is no accepted standard.
The microformats I used were:
For the whole listing: “h-cite track”
For the track name: “p-name tracktitle”
For the artist name: “p-author artist bandname”
Apparently only the h- and p- values will actually be parsed so you could omit the other values.
Because microformats are added as classes, it also gives you an opportunity to style specific parts of the text. I chose to style the track title.
Year data
I extracted the year data from their format by adding a column with this formula:
=TEXT(I2,"YYYY")
I calculated the number of songs per year by using COUNTIF:
=COUNTIF(J$2:J$23,I25)
where J2 through J23 contains the year data (created in step one), and I25 is a cell with the year in plain text. Adding the $ signs in the source data range is important so you can drag the formula down without it also shifting the source cells.
Graph by year
I followed this tutorial to create a stacked bar graph. Because I wanted multiple graphs on a page, I substituted class instead of id. I also used inline CSS for the grid display properties so I could define a different fractional breakdown for each graph.
Album art
The data included a link to the album art hosted by Spotify’s CDN. I created a column that created the image link with alt text:
=CONCATENATE("<img src=",CHAR(34),[CELL WITH ALBUM ART URL],CHAR(34)," width=",CHAR(34),"50px",CHAR(34)," alt=",CHAR(34),[CELL WITH ALBUM NAME]," by ",[CELL WITH ARTIST NAME],CHAR(34)," />")
I have too many pages to fit in my nav! Here’s a sitemap of all the pages on this website. Blog Mind Garden Post Index Links to blog about Big Questions Big Questions Balanced Lifestyle Effective Creative Processes Writing Fiction Thinking Better Information Diet Future of the Internet Resisting Fascism Building Community Transforming Capitalism Collections…
I tried out weeknotes this summer and fall over on my blog, but I’m not sure that’s the right place for them — going to try out posting them here on Fridays.
Stuff I did this week
spent 9.5 hours on my novel — worked on outlining the next four chapters, which make up one big, very important sequence at the midpoint
attended a 2-day virtual conference — two half days is a nice format
published my birthday playlists on my website
updated my RSS feed and newsletter subscriptions — when I finished, I counted my subscriptions by the gender of the author and was pleasantly surprised that the breakdown was pretty close — ignoring multi-author and anonymous authors, I follow 51 blogs by women and nonbinary authors and 58 written by men
took the weekend off working / writing
walked with a friend
got my teeth cleaned
used Teladoc to get a 3-month prescription for my birth control, so I have a countdown to find a new PCP
Reading
read The Long Game, realized it was a sequel, then read the first book Heated Rivalry
started reading Ducks by Kate Beaton
still reading Rest is Resistance by Tricia Hersey and The 12 Week Year for Writers by Trevor Thrall
added 19 books to my TBR based on end of year recs
Website changes
added a land acknowledgment to my about page
changed the background color from tan to a soft pink
updated and reorganized the menu — added a writing heading
created a page to collect pages on this site
moved my listening stats onto a page for the year
Autumn at Kubota Garden Stuff I did: 11.25 hours of writing Made myself this year’s birthday playlist — apparently my 20th! Visited Kubota…
Replied to 100 things you can do on your personal website by an author (jamesg.blog)
James has a fun collection of ideas of things to do on one’s website, some of which I have done and some of which I have not. Here are a few more things I have on my website that weren’t on the list: Yearly listening pages to supplement last.fm’s tracking Recreated playlists A page listing…