musiccaps_details (view)
4 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "r&b" and musiccaps_names contains "Hip hop music"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ariana Grande Rap rapping singing THE WAY ft. Mac Miller | This is an r&b/hip-hop music piece. There is a male vocal rapping and a female vocal singing in a rap-like manner. The beat consists of a piano playing the chords of the tune with an electronic drum backing. The atmosphere of the piece is playful and energetic. This piece could be used in the soundtrack of a high school drama movie/TV show. It could also be played at birthday parties or beach parties. | 2013-10-11T08:10:43Z | Only Best | Like and Subscribe if you like Ariana! | ["Music", "Rapping", "Hip hop music", "Electronica"] | ["r&b", "hip-hop", "male vocal", "rapping", "female vocal", "rap-like singing", "piano", "electronic drums", "energetic", "hip", "danceable", "playful", "modern sounding"] | 9 | UcabTrKowlI | 2929 | |
2014-15 NBA Game Winners and Buzzer Beaters (Regular Season) | The low quality recording features a compilation of basketball game highlights and it consists of crowd cheering and floor squeaking sound effects, followed by commentary of energetic male vocals, while a R&B song is playing in the background. The song consists of a boomy kick, claps, shimmering hi hats, high pitched piano chord progression and passionate male vocals, alongside wide male doubling vocals, singing over it. It sounds energetic and exciting. | 2015-04-18T23:22:44Z | Taras Polakoff | Song: Winner by Jamie Foxx All right reserved. | ["Music", "Speech", "Hip hop music"] | ["compilation", "basketball", "low quality", "crowd cheering", "floor squeaking", "r&b", "energetic male vocal", "commentary", "claps", "boomy kick", "shimmering hi hats", "high pitched piano chord progression", "passionate male vocal", "wide male doubling vocals", "energetic", "exciting"] | 4 | Y0_Ixl1d7oQ | 3249 | |
Wale - Focused clean version | The low quality recording features a R&B song that consists of flat male vocals, alongside filtered background male vocals, singing over punchy kick and snare hits, shimmering cymbals, uptempo hi hats, distorted bass and repetitive synth lead melody. It sounds messy, as the frequencies are clashing with each other, but also energetic, emotional and addictive - like something you would quickly learn to sing along. | 2011-11-26T16:53:06Z | DjDrewskie | I was Really Feeiling His Albm But There Was No Clean Version Anywhere So You KNow I Had To Do It! if want anymore songs done comment nd ill get to it I DO NOT OWN ANY RIGHTS TO THIS SONG RML | ["Music", "Rapping", "Zing", "Hip hop music"] | ["low quality", "r&b", "uptempo hi hats", "distorted bass", "repetitive synth lead melody", "filtered background male vocal", "punchy snare", "shimmering cymbals", "punchy kick", "flat male vocal", "energetic", "emotional", "addictive", "messy"] | 4 | nSLxQLYYoNE | 4538 | |
Anthony Hall - Breathe (New R&B Song 2010) | The low quality recording features a R&B song that consists of a passionate female vocal, alongside wide exhale sounds and wide repetitive female vocals, singing over claps, punchy kick, shimmering hi hats, synth lead melody and simple synth bass. It sounds energetic and exciting. | 2010-01-09T17:09:41Z | Janniiex3 | Hit me up on Facebook: Jannie NiCheer Introducing a hot new R&B-Artist: Anthony Hall :) ! enjoy the brandnew Single and leave a comment or rate :) thank you ;) almost daily new music :) | ["Music", "Pop music", "Rhythm and blues", "Hip hop music"] | ["low quality", "r&b", "synth lead melody", "wide exhale sounds", "passionate female vocal", "wide repetitive female vocals", "claps", "punchy kick", "shimmering hi hats", "simple synth bass", "energetic", "exciting"] | 4 | pELIBvAnbkY | 4692 |
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;