musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "distorted bass guitar", musiccaps_aspects contains "rock" and musiccaps_aspects contains "shimmering hi hats"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- distorted bass guitar · 2 ✖
- energetic 2
- low quality 2
- rock · 2 ✖
- shimmering hi hats · 2 ✖
- compilation 1
- energetic crash cymbal 1
- harmonizing male vocals 1
- imbalanced 1
- instrumental 1
- muffled 1
- punchy kick 1
- punchy snare 1
- uptempo kick pattern 1
- wide electric guitar melodies 1
- wide electric guitars chord progressions 1
musiccaps_names (array) 6 ✖
- Music 2
- Funk 1
- Progressive rock 1
- Psychedelic rock 1
- Punk rock 1
- Rock music 1
youtube_published (date) 2 ✖
- 2008-12-31 1
- 2012-05-05 1
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 | |
Rat Race - Seminal Rats | The low quality recording features a rock song that consists of wide electric guitar chord progressions, distorted bass guitar, shimmering hi hats, uptempo kick pattern and punchy snare. This instrumental sounds a bit muffled and imbalanced in volume, as the guitars are really loud, but it is very energetic regardless. | 2008-12-31T23:39:53Z | Seminalrats | On the occasion of the 10th. anniversary of the death of Mick Weber. | ["Music", "Punk rock", "Psychedelic rock", "Rock music", "Progressive rock"] | ["rock", "low quality", "wide electric guitars chord progressions", "distorted bass guitar", "shimmering hi hats", "uptempo kick pattern", "punchy snare", "imbalanced", "energetic", "instrumental", "muffled"] | 4 | 9dBWFEpcJIo | 1030 |
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;