musiccaps_details (view)
2 rows where musiccaps_aspects contains "urban" and musiccaps_names contains "Speech" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- urban · 2 ✖
- acoustic drums 1
- amateur recording 1
- background cheering 1
- bass guitar 1
- electric guitar 1
- groovy 1
- high pitch singing 1
- hiphop 1
- male narrator 1
- male vocal 1
- r&b music 1
- short female voice sample 1
- sit-com soundtrack 1
- uptempo 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Everybody Hates Chris | This is an R&B music piece from a sit-com soundtrack. Initially, there is a male voice narrating what is going on in the episode. Then the piece starts playing with a high pitched male vocal at the forefront. The melody is being played by the electric guitar and the bass guitar while the rhythmic background consists of an acoustic drum beat. The atmosphere is urban. | 2007-02-10T13:09:18Z | tigerzrule | My Personal Fav Bits OF EHC | ["Music", "Ska", "Speech"] | ["sit-com soundtrack", "male narrator", "r&b music", "male vocal", "high pitch singing", "electric guitar", "bass guitar", "acoustic drums", "groovy", "urban"] | 9 | T78nMdsJMmk | 2810 | |
Predatorz/Illusion Of Exist vs Bad Trip // .BBoy World // BREAKING 4on4 | HIP-HOPERATIONNEL 2013 | This audio contains a loud and strong digital drum almost sounding like an acoustic drum set. A bass sound rich in harmonica is serving as bassline while a short female shouting voice sample is repeatedly being played as a rhythmic element. This song may be playing for a dance battle. | 2013-04-07T17:55:43Z | BBOY WORLD | Winner: Predatorz/Illusion Of Exist - Russia ----------------------------------------------------------------------------------------------------------- BBoy World SINCE 1999 | First Breakdance Community Worldwide Info@bboyworld.com FOLLOW THE REAL COMMUNITY: #Bboyworld http://www.Bboyworld.com http://www.youtube.com/bboyworld https://www.facebook.com/bboyworld ----------------------------------------------------------------------------------------------------------- | ["Scratching (performance technique)", "Music", "Scratch", "Speech"] | ["amateur recording", "hiphop", "short female voice sample", "background cheering", "uptempo", "urban"] | 6 | oZF73R89bk0 | 4641 |
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;