musiccaps_details (view)
1 row where musiccaps_aspects contains "distorted bass guitar", musiccaps_aspects contains "energetic crash cymbal", musiccaps_aspects contains "rock" and "youtube_published" is on date 2012-05-05
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
80's Music Compilation Part 5 Some Of The Best 80's Songs | The low quality recording features a compilation of rock songs and it consists of punchy kicks, wide electric guitar melodies, distorted bass guitar, energetic crash cymbals, shimmering hi hats and harmonizing male vocals singing over it. It sounds energetic. | 2012-05-05T09:39:09Z | outlandz | My compilation of some great songs of the 80's...Also check out the other parts! Part 1: http://www.youtube.com/watch?v=U2rvxWyxR28 Part 2: http://www.youtube.com/watch?v=_r-0C9TGkpc Part 3: http://www.youtube.com/watch?v=pjDY7Vz9e2A Part 4: http://www.youtube.com/watch?v=I1hyzOHpalc Part 5: http://www.youtube.com/watch?v=-T4GeTHKtJQ Part 6: http://www.youtube.com/watch?v=DZUlbsmTPIw Part 7: http://www.youtube.com/watch?v=hOMI3u6j5Rg Hope you enjoy it! Tracklist Part 5: 01. ABC - Poison Arrow (1982) 02. Alannah Myles - Black Velvet (1989) 03. Alice Cooper - Poison (1989) 04. Baltimora - Tarzan Boy (1985) 05. Belouis Some - Imagination (1985) 06. Bette Midler - Beat Of Burden (1984) 07. Billy Idol - Sweet Sixteen (1987) 08. Blondie - Atomic (1980) 09. Bruce Springsteen - The River (1981) 10. Captain Sensible - Wot (1982) 11. Culture Club - Do You Really Want To Hurt Me (1982) 12. Cyndi Lauper - True Colors (1986) 13. Daryl Hall & John Oates - Maneater (1982) 14. Depeche Mode - Just Can't Get Enough (1981) 15. Dionne Warwich - Heartbreaker (1983) 16. Dire Straits - Walk Of Life (1986) 17. Duran Duran - The Reflex (1984) 18. Elton John - I'm Still Standing 19. Erasure - Sometimes (1987) 20. Europe - Carrie (1987) 21. F.R. David - Words (1982) 22. Falco - Jeanny (1986) 23. Foreigner - Waiting For A Girl Like You (1982) 24. Genesis - Invisible Touch (1986) 25. Gloria Estefan - Don't Wanna Lose You (1989) 26. Go West - We Close Our Eyes (1985) 27. Guns 'N Roses - Paradise City (1989) 28. Harold Faltermeyer - Axel F (1984) 29. Huey Lewis & The News - If This Is It (1984) 30. Human League - Human (1986) 31. Jan Hammer - Miami Vice Theme (1985) 32. Jefferson Starship - We Built This City (1985) 33. Jennifer Rush - Power Of Love (1985) 34. Joe Jackson - Steppin' Out (1983) 35. Journey - Open Arms (1982) 36. KC & The Sunshine Band - Give It Up (1983) 37. Kiss - Crazy Crazy Nights (1987) 38. Laura Branigan - Self Control (1983) 39. Limahl - Neverending Story (1984) 40. Lionel Richie - Say You Say Me (1985) 41. Maria… | ["Funk", "Music"] | ["low quality", "rock", "punchy kick", "punchy kick", "wide electric guitar melodies", "distorted bass guitar", "energetic crash cymbal", "shimmering hi hats", "harmonizing male vocals", "energetic", "compilation"] | 4 | -T4GeTHKtJQ | 49 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW musiccaps_details AS select musiccaps.url as video, json_object( 'label', coalesce(videos.title, 'Missing from YouTube'), 'href', musiccaps.url ) as youtube_link, musiccaps.caption as musiccaps_caption, videos.publishedAt as youtube_published, videos.channelTitle as youtube_channel, videos.description as youtube_description, musiccaps.audioset_names as musiccaps_names, musiccaps.aspect_list as musiccaps_aspects, musiccaps.author_id as musiccaps_author, videos.id as youtube_id, musiccaps.rowid as musiccaps_rowid from musiccaps left join videos on musiccaps.ytid = videos.id;