musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "r&b" and musiccaps_names contains "Zing" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- r&b · 2 ✖
- acoustic guitar 1
- aggressive 1
- distorted 1
- electronic drums 1
- emotional 1
- female vocal 1
- heartfelt 1
- hollering 1
- loud 1
- melodic singing 1
- passionate male vocal 1
- punchy kick 1
- punchy snare 1
- remix 1
- romantic 1
- shimmering hi hats 1
- smooth bass guitar 1
- snappy rimshots 1
- soft crash cymbal 1
- strong bass 1
- trap 1
- upbeat 1
- vocal sample 1
- wide funky electric guitar melody 1
musiccaps_names (array) 4 ✖
- Music 2
- Zing · 2 ✖
- Outside, rural or natural 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Shook - "Lullaby" | The R&B song features a passionate male vocalist singing over a wide funky electric guitar melody, smooth bass guitar, punchy kick and snare hits, shimmering hi hats, snappy rimshots and soft crash cymbals. The rimshots are present in the first half of the loop, while a more energetic second part of the loop consists of punchy snare hits. It sounds emotional and heartfelt, as the vocal is slightly distorted. | 2010-07-15T19:21:57Z | funkysoul2000 | from EP "Can U Still Dance?" © 2010 www.shooksounds.com | ["Music", "Song", "Zing"] | ["r&b", "passionate male vocal", "punchy snare", "punchy kick", "shimmering hi hats", "soft crash cymbal", "wide funky electric guitar melody", "smooth bass guitar", "snappy rimshots", "emotional", "romantic", "heartfelt", "distorted"] | 4 | _m-N4i-ge28 | 3487 | |
AFS Doing Flips, Flipping Just Practicing (Preview | This is a sped-up trap remix of an R&B music piece. There is a female vocalist singing melodically with her vocal sample used in beat repeats. There is a hollering sample added alongside it. The beat has a strong synth bass with a repeating acoustic guitar sample playing every now and then. The electronic drum beat is slightly fast-paced and filled with cicada hi-hats. The atmosphere is loud and upbeat. This piece could be used as an accompaniment piece at a modern break dance course. It could also be played at nightclubs. | 2013-08-05T16:08:41Z | Zyhiir dorsey | Follow me on twitter @iflip_zahbreezy & instagram @zyhiir | ["Music", "Zing", "Outside, rural or natural"] | ["r&b", "trap", "remix", "female vocal", "melodic singing", "vocal sample", "hollering", "acoustic guitar", "strong bass", "electronic drums", "loud", "aggressive", "upbeat"] | 9 | xl4FJzeU0YA | 5350 |
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;