musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "live performance", musiccaps_aspects contains "low quality" and musiccaps_names contains "Music of Latin America"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- live performance · 4 ✖
- low quality · 4 ✖
- groovy 3
- groovy bass 3
- shimmering hi hats 3
- crowd cheering 2
- electric guitar melody 2
- exciting 2
- passionate 2
- punchy snare 2
- accordion melody 1
- brass melody 1
- crowd chattering 1
- crowd clapping 1
- crowd whistling 1
- easygoing 1
- energetic 1
- exciting background male vocal 1
- exotic 1
- flat male vocal 1
- folk 1
- fruity male vocal 1
- funky electric guitar chords 1
- groovy bass guitar 1
- groovy piano melody 1
- harmonizing male vocals 1
- playback 1
- pop 1
- punchy kick 1
- reggae 1
- …
musiccaps_names (array) 11 ✖
- Music of Latin America · 4 ✖
- Music 3
- Singing 3
- Accordion 1
- Maraca 1
- Musical instrument 1
- Orchestra 1
- Rumble 1
- Salsa music 1
- Speech 1
- Traditional music 1
youtube_published (date) 4 ✖
- 2009-07-03 1
- 2009-11-24 1
- 2015-11-13 1
- 2016-04-16 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Samuel Rossi Orchestra Ringo Story Goleada polka | The low quality recording features a live performance of a folk song that consists of an accordion melody playing over groovy bass, shimmering hi hats, punchy snare and electric guitar melody. There are crowd chattering noises in the background. It sounds passionate and groovy. | 2009-07-03T12:40:13Z | Tuttofisa | Samuel Rossi Orchestra Ringo Story Goleada polka | ["Singing", "Traditional music", "Music", "Musical instrument", "Orchestra", "Speech", "Music of Latin America", "Accordion"] | ["low quality", "live performance", "crowd chattering", "folk", "groovy bass", "accordion melody", "electric guitar melody", "shimmering hi hats", "punchy snare", "passionate", "groovy"] | 4 | ChqJYrmQIN4 | 1394 | |
Voltio - Medley De Salsa Carcelaria (Video En Vivo Desde Oso Blanco) | The low quality recording features a live performance of an urban latin song that consists of flat male vocal singing over groovy piano melody, groovy bass guitar, wooden percussive elements, wide toms, warm brass melody and widely spread claps. There is a short, exciting background male vocal in the middle of the loop. It sounds exotic, groovy and passionate. | 2009-11-24T21:07:11Z | VoltioVEVO | Music video by Voltio performing Medley De Salsa Carcelaria. (C) 2008 SONY BMG MUSIC ENTERTAINMENT (US Latin) LLC YouTube view counts pre-VEVO: 878 | ["Singing", "Music", "Music of Latin America", "Salsa music"] | ["low quality", "live performance", "urban latin", "wooden percussive elements", "wide toms", "warm brass", "groovy piano melody", "groovy bass", "flat male vocal", "wide claps", "passionate", "exotic", "groovy", "exciting background male vocal"] | 4 | FEuXIeWoCQQ | 1628 | |
Reply1988 Go Kyung-pyo-Ryu Jun-yeol-Lee Dong-hwi, chnages to 'Fire Engine' for Hye-ri 151113 EP3 | The low quality recording features a live performance of a pop song that consists of harmonizing male vocals singing over punchy kick and snare, shimmering hi hats, groovy bass, brass melody and electric guitar melody. There are some crowd clapping and cheering sounds in the background. It sounds energetic, exciting and groovy. | 2015-11-13T12:53:53Z | tvN drama | tvN Family Comedy Drama Reply 1988 Every Fri-Sat 7:50PM Broadcast | ["Singing", "Music of Latin America"] | ["live performance", "low quality", "crowd clapping", "crowd cheering", "pop", "harmonizing male vocals", "punchy snare", "punchy kick", "shimmering hi hats", "groovy bass", "brass melody", "electric guitar melody", "groovy", "energetic", "exciting"] | 4 | oBBTqXQFTiA | 4608 | |
Downbeat sound at Irish and chin vintage rumble 2016 amazura | The low quality recording features a live performance of a reggae song and it consists of a fruity male vocal preparing to sing over shimmering hi hats, snappy rimshots, funky electric guitar chords and groovy bass. As it is a live performance, there are some crowd whistling and cheering noises in the background. It sounds easygoing and exciting. | 2016-04-16T14:14:11Z | Kerryannbrown music promotions | Downbeat sound at vintage rumble 2016 Irish and chin sound clash | ["Music", "Rumble", "Music of Latin America", "Maraca"] | ["low quality", "reggae", "crowd whistling", "fruity male vocal", "crowd cheering", "live performance", "playback", "shimmering hi hats", "snappy rimshots", "funky electric guitar chords", "groovy bass guitar", "easygoing", "exciting"] | 4 | zXxJymYt8Z4 | 5487 |
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;