musiccaps_details (view)
3 rows where musiccaps_aspects contains "live performance", musiccaps_aspects contains "pop music" and musiccaps_names contains "Pop music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- live performance · 3 ✖
- pop music · 3 ✖
- acoustic drums 2
- melodic singing 2
- acoustic guitar 1
- amateur recording 1
- bad audio quality 1
- bass guitar 1
- big band plays 1
- big show 1
- big stage 1
- boy band 1
- brass band 1
- crowd cheering 1
- crowd singing 1
- crowds sing along 1
- diva 1
- electric guitar 1
- emotional 1
- female singer 1
- horn section 1
- huge arena 1
- jazz music show 1
- live audience 1
- male vocals 1
- medium tempo 1
- memdium tempo 1
- orchestra plays 1
- percussion hits 1
- syncopated rhythms 1
- teen male vocal 1
- violin solo 1
musiccaps_names (array) 7 ✖
- Music 3
- Pop music · 3 ✖
- Singing 3
- Bang 2
- Crowd 1
- Inside, large room or hall 1
- Inside, public space 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
JENNY RIVERA EN MONTERREY 2012 DICIEMBRE | A female singer sings in a huge arena live along with crowds singing along with her in vocals. The song is medium tempo with steady drumming rhyme and giant drum rolls, violin playing solo, a brass band section and orchestra playing along. The song is energetic, cheerful and highly popular. The audio quality is very poor with heavy ambient crowd noises. | 2012-12-12T14:11:53Z | A CH | Jenni Rivera En La Arena Monterrey 8 de Diciembre 2012, ULTIMA PRESENTACION EN CONCIERTO, aqui un resumen.... https://www.youtube.com/watch?v=L7oF9oG3LIM ---- No Copyright infringement intended. I do not own this music. "Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use." | ["Singing", "Music", "Pop music", "Inside, large room or hall", "Inside, public space"] | ["live performance", "female singer", "bad audio quality", "syncopated rhythms", "medium tempo", "pop music", "huge arena", "crowds sing along", "live audience", "diva", "memdium tempo", "orchestra plays", "violin solo", "horn section", "brass band", "percussion hits", "big show", "jazz music show", "pop music", "big stage", "big band plays"] | 1 | dHDosntsNho | 3772 | |
Burning Up - Jonas Brothers - Jingle Ball 2012 | This is the live performance of a pop music piece. It is an amateur recording. There are male vocals singing melodically. An electric guitar strums a chord for the ending of a song while the sounds of the cymbals can be heard from the acoustic drums. The cheers of the crowd can be heard even more than the music itself. This recording could be sampled for use in beat-making. | 2012-12-03T00:47:17Z | Marielle Bravo-Saltzman | Last song performed by Jonas Brothers at Jingle Ball 2012 | ["Singing", "Crowd", "Music", "Pop music", "Bang"] | ["pop music", "live performance", "amateur recording", "male vocals", "melodic singing", "electric guitar", "acoustic drums", "crowd cheering"] | 9 | qxWVr67g6yY | 4839 |
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;