musiccaps_details (view)
3 rows where musiccaps_aspects contains "passionate" and musiccaps_names contains "Whoop" sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 51 ✖
- emotional 3
- passionate · 3 ✖
- exciting 2
- backup singers 1
- black gospel influences 1
- choral harmony 1
- crooners 1
- crowd cheering 1
- crowds cheering 1
- distorted 1
- energetic 1
- fast tempo 1
- female singers 1
- girls screaming 1
- groovy bass line 1
- guitar accompaniment 1
- harmonizing vocals 1
- hissing noises 1
- jazz music influences 1
- keyboard accompaniment 1
- live performance 1
- live shows 1
- love song 1
- love songs 1
- low quality 1
- madly in love 1
- mellow piano chords 1
- modern love 1
- modern pop hits 1
- mono 1
- music 1
- music you 1
- need your loving 1
- noisy 1
- packed stadium 1
- percussive horn section 1
- poor audio quality 1
- pop hits 1
- pop star sings live 1
- punchy kick 1
- punchy snare 1
- retro pop influences 1
- romantic 1
- shimmering hi hats 1
- simple bass 1
- soul singers 1
- stro telling 1
- synth pads 1
- teen heartthrob 1
- teenage romance 1
- vocal harmony 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
KC Concepcion in Chicago #8 | The low quality recording features harmonizing vocals singing over punchy kick and snare hits, shimmering hi hats, synth pads, simple bass and mellow piano chords. There are crowd cheering noises in the background as this is a live performance. It sounds passionate, emotional, exciting and the recording is noisy, in mono and slightly distorted. | 2011-10-31T01:02:49Z | TeamKC4life | KC Concepcion as Vivian sings the themesong of Lovers in Paris, Wag Na Wag Mong Sasabihin. Much love & thanks to my honey, John, for being KC's best videographer. | ["Singing", "Music", "Pop music", "Whoop"] | ["live performance", "low quality", "noisy", "mono", "crowd cheering", "distorted", "harmonizing vocals", "punchy snare", "punchy kick", "shimmering hi hats", "synth pads", "simple bass", "mellow piano chords", "passionate", "emotional", "exciting"] | 4 | He63KV_9Pwg | 1823 | |
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 | |
Harry Styles | Best Vocals [Part 2] | A male singer sings various songs in live audience situations. The songs have a different tempo and are mostly accompanied by a band. The songs are sung at live venues with people screaming and cheering. The songs are modern pop hits , recorded in poor audio quality with hissing noises. | 2013-08-20T05:03:21Z | fr0zenintimeee | follow me i follow back :) ♡ https://twitter.com/fr0zentweets ♡ Tumblr: http://http://harryfml.tumblr.com/ (1D blog) i don't own any of these videos. I don't own any rights to this song. No copyright intended. | ["Singing", "Music", "Pop music", "Whoop"] | ["poor audio quality", "hissing noises", "pop star sings live", "live shows", "emotional", "passionate", "crowds cheering", "guitar accompaniment", "pop hits", "romantic", "girls screaming", "packed stadium", "pop hits", "teen heartthrob", "modern pop hits", "love songs", "romantic", "madly in love", "modern love", "teenage romance"] | 1 | pNlrM-GhFZU | 4705 |
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;