musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_author = 9 and musiccaps_names contains "Maraca" sorted by youtube_description
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 17 ✖
- accordeon 1
- acoustic guitar 1
- bass guitar 1
- electronic drums 1
- energetic 1
- jam 1
- latin dance 1
- latin music 1
- latin percussion 1
- loud 1
- male vocal 1
- male vocals 1
- maracas 1
- people shouting 1
- rising pattern 1
- spanish 1
- vibrant 1
musiccaps_names (array) 3 ✖
- Maraca · 2 ✖
- Music 2
- Music of Latin America 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
siguen la maraca en orlando car wash | This is the recording of a latin dance music piece. It has a male vocalist singing the same word repeatedly at a medium-to-high pitch. There is an accordion playing the melody and a bass guitar in the background. The electronic drums play a latin beat for the rhythm. There is a constant rising and accelerating pattern in the piece. The sound of people shouting can be heard in the recording. The atmosphere is very loud and vibrant. | 2008-02-09T03:27:15Z | DREVENTOS COM | ALANTE ALANTE | ["Music", "Maraca"] | ["latin dance", "male vocal", "rising pattern", "accordeon", "bass guitar", "electronic drums", "people shouting", "energetic", "vibrant", "loud"] | 9 | woyCm7d2UIM | 5287 | |
Joropo Maracas jamming #2 | This is an amateur recording of a percussive jam over a backing track that has the acoustic guitar and hollering male vocals singing in the Spanish language, iconic features of latin folk music. Two pairs of maracas are being played to create the rhythm. | 2013-05-22T02:59:20Z | tonydven | Twelve year old Edgar Sebastian Bermejo of Bogota, Colombia shows how to play joropo maracas with real style. Little Johan is learning too. | ["Music", "Music of Latin America", "Maraca"] | ["maracas", "latin percussion", "jam", "male vocals", "spanish", "acoustic guitar", "latin music"] | 9 | bpKbpKZB0Q0 | 3653 |
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;