musiccaps_details (view)
4 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "flat male vocal" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- emotional · 4 ✖
- flat male vocal · 4 ✖
- low quality 4
- noisy 2
- punchy kick 2
- rock 2
- shimmering hi hats 2
- acoustic sitar guitar melody 1
- addictive 1
- arpeggiated electric guitar melody 1
- background male vocal 1
- banjo guitar melody 1
- country 1
- crowd cheering 1
- crowd singing 1
- electric guitars melodies 1
- energetic 1
- groovy bass 1
- groovy bass guitar 1
- heartfelt 1
- live performance 1
- mono 1
- passionate 1
- passionate male vocal 1
- punchy snare 1
- snappy rimshots 1
- tutorial 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
1977 - Bat Out of Hell Cover | The low quality recording features a, what it seems like, cover of a country song and it consists of flat male vocals singing over acoustic sitar guitar melody. It sounds very noisy, but also heartfelt and emotional. | 2011-02-11T04:06:00Z | Nightfrailer | (Practice session... This is where the magic of the 1970's hits and the bumbling frailing and drop thumb starts coming together.) The greatest song ever written maybe? | ["Banjo", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "acoustic sitar guitar melody", "flat male vocal", "noisy", "heartfelt", "country", "emotional"] | 4 | 9A_OmOetiuw | 980 | |
Part 1 - How to play banjo with two fingers | The low quality recording features a tutorial where in the beginning there is a banjo guitar melody over which a passionate male vocalist is singing. In the second half of the loop, a flat male vocal is talking. The recording is noisy, in mono and it sounds passionate and emotional. | 2011-06-02T23:56:53Z | deeringads | Banjo playing lesson for beginners | ["Banjo", "Music", "Musical instrument", "Speech", "Plucked string instrument"] | ["low quality", "flat male vocal", "banjo guitar melody", "passionate male vocal", "passionate", "emotional", "tutorial", "noisy", "mono"] | 4 | Uc_1PzGr5xw | 2928 | |
Compact - Fata din vis | The low quality recording features a live performance of a rock song and it consists of flat male vocal singing over arpeggiated electric guitar melody, groovy bass guitar, shimmering hi hats, snappy rimshots and punchy kicks. In the background, there are some crowd singing and crowd cheering noises. It sounds emotional and a bit addictive. | 2008-04-19T14:23:33Z | Horia D | nice love song | ["Blues", "Singing", "Music", "Musical instrument"] | ["low quality", "live performance", "rock", "crowd cheering", "crowd singing", "flat male vocal", "punchy kick", "snappy rimshots", "shimmering hi hats", "arpeggiated electric guitar melody", "groovy bass guitar", "emotional", "addictive"] | 4 | cTJqIkSuf6s | 3710 | |
Alkaline Trio - All On Black (Live On Letterman) | The low quality recording features a rock song that consists of a flat male vocal, alongside background male vocals, singing over shimmering hi hats, groovy bass, punchy kick and snare hits and electric guitar melodies. It sounds energetic and emotional. | 2007-06-24T14:06:26Z | AllHopeDeleted | All On Black Performed Live on Letterman from the album 'Good Mourning' http://www.youtube.com/jazzbandrock | ["Drum kit", "Guitar", "Music", "Musical instrument", "Punk rock", "Rock music"] | ["low quality", "rock", "background male vocal", "flat male vocal", "shimmering hi hats", "electric guitars melodies", "groovy bass", "punchy kick", "punchy snare", "emotional", "energetic"] | 4 | yQN9gj7Vk0w | 5408 |
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;