musiccaps_details (view)
4 rows where musiccaps_aspects contains "exciting" and musiccaps_names contains "Whoop"
This data as json, CSV (advanced)
musiccaps_aspects (array) 61 ✖
- exciting · 4 ✖
- emotional 2
- energetic 2
- live performance 2
- low quality 2
- mono 2
- noisy 2
- passionate 2
- adventurous 1
- ambient crowd noises 1
- backup singers 1
- bad audio quality 1
- black gospel influences 1
- choral harmony 1
- crooners 1
- crowd cheering 1
- crowd harmonizing singing 1
- distorted 1
- diva 1
- electric rhythm guitar playing 1
- fast tempo 1
- female guitarist 1
- female singers 1
- groovy bass line 1
- guitar solo 1
- hard rock 1
- harmonizing vocals 1
- home video 1
- instrumental music 1
- jazz music influences 1
- joyful 1
- keyboard accompaniment 1
- live concert video 1
- loud wooden percussion 1
- love song 1
- medium fast tempo 1
- medium fats tempo 1
- mellow piano chords 1
- music 1
- music you 1
- need your loving 1
- people cheering 1
- people screaming 1
- percussive bass line 1
- percussive horn section 1
- phone recording 1
- poor audio recording 1
- punchy kick 1
- punchy snare 1
- retro pop influences 1
- rock band 1
- rock drumming 1
- rock guitar solo 1
- shimmering hi hats 1
- simple bass 1
- soul singers 1
- stro telling 1
- synth pads 1
- testosterone driven 1
- vocal harmony 1
- youthful 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 | |
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 | |
AIESEC Turkey shout at NATCO before the Opening | The low quality recording features a crowd harmonized singing over loud wooden percussion. The recording is noisy, in mono and it sounds energetic, joyful and exciting. | 2011-05-24T08:40:49Z | Tatish | NATCO 2011 | ["Music", "Whoop"] | ["low quality", "noisy", "mono", "phone recording", "loud wooden percussion", "crowd harmonizing singing", "energetic", "exciting", "joyful"] | 4 | nf3LGAL1LZc | 4568 | |
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 |
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;