musiccaps_details (view)
4 rows where musiccaps_names contains "Whoop" and musiccaps_names contains "Yell"
This data as json, CSV (advanced)
musiccaps_aspects (array) 62 ✖
- energetic 2
- exciting 2
- acoustic guitar 1
- adventurous 1
- aggressive 1
- ambient crowd noises 1
- backup singers 1
- bad audio quality 1
- black gospel influences 1
- boomy bass 1
- choral harmony 1
- crooners 1
- crowd cheering 1
- distorted 1
- diva 1
- electric rhythm guitar playing 1
- electro 1
- emotional 1
- fast tempo 1
- female backing voice 1
- female guitarist 1
- female singers 1
- groovy bass line 1
- guitar solo 1
- hard rock 1
- home video 1
- instrumental music 1
- jazz music influences 1
- keyboard accompaniment 1
- live concert video 1
- live performance 1
- loud cheering and clapping 1
- love song 1
- low quality 1
- male voice rapping 1
- medium fast tempo 1
- medium fats tempo 1
- mono 1
- muffled 1
- music 1
- music you 1
- need your loving 1
- noisy 1
- passionate 1
- people cheering 1
- people screaming 1
- percussive bass line 1
- percussive horn section 1
- poor audio recording 1
- positive vibe 1
- punchy snare 1
- retro pop influences 1
- rock band 1
- rock drumming 1
- rock guitar solo 1
- singer-songwriter/rap 1
- soul singers 1
- stro telling 1
- testosterone driven 1
- uptempo 1
- vocal harmony 1
- youthful 1
musiccaps_names (array) 9 ✖
- Music 4
- Whoop · 4 ✖
- Yell · 4 ✖
- Inside, large room or hall 2
- Crowd 1
- Electronic music 1
- Guitar 1
- Pop music 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Orianthi - Guitar Solo [singfest 3/8/10] | The song is an instrumental. The tempo is medium fast with a strong guitar lead, rock drumming rhythm, percussive bass line and an electric guitar strumming rhythm. The song is high on adrenaline and exciting. The audio quality is very bad with ambient crowd screaming noises. | 2010-08-05T15:37:54Z | Zahara Sulaiman | Orianthi performance during singfest in Singapore. | ["Guitar", "Music", "Pop music", "Whoop", "Yell", "Inside, large room or hall"] | ["live performance", "ambient crowd noises", "medium fast tempo", "live concert video", "home video", "poor audio recording", "testosterone driven", "female guitarist", "exciting", "youthful", "diva", "rock guitar solo", "adventurous", "people screaming", "guitar solo", "rock band", "instrumental music", "people cheering", "bad audio quality", "hard rock", "rock band", "medium fats tempo", "rock drumming", "percussive bass line", "electric rhythm guitar playing"] | 1 | G8iTuTi8ywU | 1694 | |
SHOUT - The Fabsisters [Cover Of - The Isley Brothers/Lulu] | A female singer sings this soulful melody with backup singers in vocal harmony. The song is fast tempo with a quick drumming rhythm, percussive bass line, guitar strumming rhythm and keyboard accompaniment. The song has black gospel roots. | 2012-02-22T18:56:06Z | The Fabsisters | Please watch: "The Drinks are all on him-Folake (The Fabsisters)" https://www.youtube.com/watch?v=pTs3mNrht_4 -~-~~-~~~-~~-~- Please watch: "The Fabsisters - Can't Be With You Tonight" ➨ https://www.youtube.com/watch?v=lG1ce8BrEQ4 | ["Music", "Whoop", "Yell"] | ["female singers", "vocal harmony", "backup singers", "passionate", "music you", "need your loving", "soul singers", "percussive horn section", "keyboard accompaniment", "crooners", "stro telling", "love song", "emotional", "choral harmony", "black gospel influences", "emotional", "exciting", "energetic", "jazz music influences", "retro pop influences", "music", "fast tempo", "groovy bass line"] | 1 | qpt3umHYfmY | 4824 | |
Prodigy Smack My Bitch Up EXIT 2009 - The Best | The low quality recording features an electro song played live and it consists of at least a punchy snare and a boomy bass. There are some crowd cheering noises in the background. It sounds muffled, energetic, aggressive and distorted as the recording is very noisy and in mono. | 2009-07-15T05:06:06Z | strika88BL | The Best Live Performance EVER. Look at 04:00 incredible moment. | ["Electronic music", "Crowd", "Music", "Whoop", "Yell"] | ["low quality", "muffled", "electro", "aggressive", "punchy snare", "boomy bass", "distorted", "noisy", "mono", "crowd cheering", "energetic"] | 4 | qtNTHnXOQew | 4831 | |
Room39 - Mixed Song @ FAT Fest 10 | An acoustic guitar is strumming chords along with a male voice rapping that gets backing vocals from a female voice for a moment. A lot of people are clapping and cheering. This song may be playing at a live concert. | 2010-11-07T17:27:20Z | KaitoGallery | from iPhone upload by http://www.entertainstation.com | ["Singing", "Music", "Whoop", "Yell", "Inside, large room or hall"] | ["singer-songwriter/rap", "acoustic guitar", "male voice rapping", "loud cheering and clapping", "female backing voice", "uptempo", "positive vibe"] | 6 | sOSU7p9pLjs | 4946 |
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;