musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "live performance" and musiccaps_aspects contains "melodic singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- acoustic guitar · 3 ✖
- emotional 3
- live performance · 3 ✖
- melodic singing · 3 ✖
- acoustic drums 2
- crowd singing 2
- pop music 2
- acoustic 1
- alternative 1
- ballad 1
- bass guitar 1
- boy band 1
- female vocal 1
- simple tune 1
- slow tempo 1
- soprano 1
- spanish 1
- teen female vocal 1
- teen male vocal 1
youtube_published (date) 3 ✖
- 2009-11-02 1
- 2014-09-29 1
- 2015-06-17 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Invencible/Music Club de Vázquez Sounds | This is a live performance of a pop music piece. There is a teenage female vocalist singing melodically in the Spanish language. An acoustic guitar plays the main tune while there is a slow tempo acoustic drum beat in the rhythmic background. The spectators are joining the song at a volume that is sometimes higher than the song itself and it creates an irritating aura. | 2014-09-29T02:14:40Z | Vázquez Sounds Support Mexico | Nuestras redes sociales: Facebook: http://bitly.com/1rW5VpV Youtube: http://bitly.com/1vpC2gw Instagram: http://bit.ly/1oHYlJB Twitter: http://bitly.com/1yEsrar Ask: http://bit.ly/1CKk6AM {Grabado por nosotros} Club de fans oficial. Vazquez Sounds en vivo (Live) | ["Singing", "Music", "Song", "A capella"] | ["live performance", "pop music", "ballad", "teen female vocal", "melodic singing", "acoustic guitar", "acoustic drums", "crowd singing", "emotional", "slow tempo", "spanish"] | 9 | BaMBwXQwK3g | 1263 | |
Harry + Louis || OTRA Tour PART 10 || Larry Stylinson | This is the compilation of live performances from a pop music boy band. There are teen male vocalists singing melodically. The melody is being played by an acoustic guitar and a bass guitar while an acoustic drum beat is playing in the rhythmic background. There are sounds of a crowd singing and cheering. The recording quality is poor. | 2015-06-17T11:19:42Z | TheVickylove90 | Watch in HD!! Sometimes I have the doubt that they're not a couple, but then they look at each other, they're not just friend ;) Hope you like the video !! xoxo PART 1 https://www.youtube.com/watch?v=lg1nF... PART 2 https://www.youtube.com/watch?v=JORQM... PART 3 https://www.youtube.com/watch?v=KZLGl... PART 4 https://www.youtube.com/watch?v=1AwHQ... PART 5 https://www.youtube.com/watch?v=knHl-... PART 6 https://www.youtube.com/watch?v=Blu_R... PART 7 https://www.youtube.com/watch?v=Zb8YN... PART 8 https://www.youtube.com/watch?v=zvILN... PART 9 https://www.youtube.com/watch?v=4iio1oYeQI0 PART 11 https://www.youtube.com/watch?v=098Fv2j-c2M PART 12 https://www.youtube.com/watch?v=3VIM2e5TP0A&feature=youtu.be PART 13 https://www.youtube.com/watch?v=uw9fjCNrbx0 PART 14 https://www.youtube.com/watch?v=jTGQAklkr4M Harry Styles + Louis Tomlinson Larry Stylinson One Direction Program Sony Vegas Pro 13 | ["Singing", "Music", "Pop music", "Bang"] | ["live performance", "pop music", "boy band", "teen male vocal", "melodic singing", "acoustic guitar", "bass guitar", "acoustic drums", "crowd singing", "emotional"] | 9 | OvjmfGU4y_M | 2481 | |
Hayley Williams & Josh Farro - You Ain't Woman Enough (Loretta Lynn cover) - Paramore | This is an acoustic live performance of an alternative music piece. There is a female vocalist singing melodically at a soprano range. In the melodic background, there is an acoustic guitar playing a simple tune. The piece has an emotion-filled atmosphere. It could be used in the soundtrack of a drama movie or a TV show. | 2009-11-02T07:39:48Z | planecrashdream | This is the original, first, and only UNPLUGGED performance! This is my video. The other copies of this around youtube are fakes. This was on November 1st, 2009. Ryman Auditorium, Nashville, Tennessee. It was so incredible. PLEASE no comments about the yelling, or comments bashing Jenna or about Hayley and Josh being together. They aren't together and their significant others don't deserve hate. | ["Singing", "Music", "/t/dd00004"] | ["alternative", "acoustic", "live performance", "female vocal", "soprano", "melodic singing", "acoustic guitar", "simple tune", "emotional"] | 9 | eWGGj4duzIo | 3869 |
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;