musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_author = 6 and musiccaps_names contains "Maraca"
This data as json, CSV (advanced)
Suggested facets: musiccaps_names
musiccaps_aspects (array) 17 ✖
- acoustic guitar 2
- amateur recording 2
- backing voices 1
- e-bass 1
- e-guitar 1
- fast tempo 1
- female soul voice 1
- latin/country 1
- maracas 1
- medium tempo 1
- medium to uptempo 1
- percussion 1
- r&b/reggae/soul 1
- reggae/pop 1
- relaxing vibe 1
- shaker 1
- tambourine 1
musiccaps_names (array) 6 ✖
- Maraca · 3 ✖
- Music 3
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Singing 1
youtube_published (date) 3 ✖
- 2010-06-09 1
- 2012-01-01 1
- 2014-09-10 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
timile ta haina | Someone is playing an acoustic guitar strumming chords on the backbeat while someone is holding the rhythm with a shaker and a percussion in the background. This song may be playing while having a jam session with your friends. | 2014-09-10T14:13:19Z | Jolon Deepanjali Joshi | rehearsal | ["Singing", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Maraca"] | ["reggae/pop", "amateur recording", "acoustic guitar", "shaker", "percussion", "medium tempo"] | 6 | Gow0TlxIx7U | 1755 | |
Maracas Llaneras | Someone is playing maracas very skillfully while an acoustic guitar is supported with strumming chords that are constantly changing. This sounds like an amateur recording. This song may be playing at a local music store where people jam. | 2010-06-09T16:16:53Z | leonardoj333 | Maraquero apureño Manuel Mirabal ejecutando maracas llaneras elaboradas en San Fernando de Apure por el luthier José Leonardo Jiménez | ["Music", "Maraca"] | ["latin/country", "maracas", "acoustic guitar", "fast tempo", "amateur recording"] | 6 | P5IxlG4-CY8 | 2505 | |
Tweet feat Missy Elliott - Thugman aka Steady Thug (Reggae Mash Up by Dedy Dread) | A female voice is singing soulfully. She gets support from several backing vocals singing harmonies along. A tambourine is holding the rhythm along with a bassline and a e-guitar giving the song a reggae feeling. This song may be playing in a car. This is an amateur recording. | 2012-01-01T12:10:38Z | Bismarck126 | Putting this vocal to this old Studio One rhythm (Larry and Alvin's 'Your Love', originally) is inspired. | ["Music", "Maraca"] | ["r&b/reggae/soul", "female soul voice", "backing voices", "tambourine", "e-bass", "e-guitar", "medium to uptempo", "relaxing vibe"] | 6 | uTfLf1Y8hhM | 5117 |
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;