musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "live performance", musiccaps_names contains "Music of Latin America" and musiccaps_names contains "Speech"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- live performance · 2 ✖
- accordion melody 1
- acoustic guitar 1
- crowd chattering 1
- crowd cheering 1
- electric guitar melody 1
- emotional 1
- flamenco 1
- folk 1
- groovy 1
- groovy bass 1
- low quality 1
- male vocal 1
- passionate 1
- passionate singing 1
- punchy snare 1
- shimmering hi hats 1
- spanish 1
- vibrant 1
musiccaps_names (array) 10 ✖
- Music 2
- Music of Latin America · 2 ✖
- Singing 2
- Speech · 2 ✖
- Accordion 1
- Flamenco 1
- Guitar 1
- Musical instrument 1
- Orchestra 1
- Traditional music 1
youtube_published (date) 2 ✖
- 2009-07-03 1
- 2015-04-27 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 | |
Antonio José canta por fandangos (Directo Málaga) | This is the live performance of a flamenco music piece. There is a male vocalist singing passionately in the Spanish language. An acoustic guitar strums a characteristic flamenco tune. Sounds of the crowd cheering can be heard in the background. The atmosphere is vibrant. | 2015-04-27T20:37:09Z | Carmen SV | Concierto sala Tenessee (Málaga) 26/04/2015 | ["Singing", "Flamenco", "Guitar", "Music", "Speech", "Music of Latin America"] | ["flamenco", "live performance", "spanish", "male vocal", "passionate singing", "acoustic guitar", "crowd cheering", "emotional", "vibrant"] | 9 | GUwBLItoJXk | 1727 |
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;