musiccaps_details (view)
3 rows where musiccaps_aspects contains "groovy bass", musiccaps_aspects contains "shimmering cymbals" and musiccaps_aspects contains "soft kick hits"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- groovy bass · 3 ✖
- shimmering cymbals · 3 ✖
- soft kick hits · 3 ✖
- clapping 2
- low quality 2
- addictive 1
- blues 1
- boomy 1
- cool 1
- country blues 1
- filtered monotone male vocal 1
- fruity male vocal 1
- groovy 1
- groovy electric guitar melodies 1
- groovy organ keys chords 1
- happy 1
- joyful 1
- mellow snare 1
- noisy 1
- passionate 1
- passionate male vocal 1
- poor mix 1
- pop 1
- punchy snare 1
- uptempo 1
- vintage 1
- wide harmonizing background vocals 1
musiccaps_names (array) 9 ✖
- Music 3
- Blues 1
- Country 1
- Grunge 1
- Music of Latin America 1
- Rhythm and blues 1
- Singing 1
- Soul music 1
- Swing music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Pharrell Williams - Happy (WE ARE FROM HONG KONG) Dance edition | The Pop song features a passionate male vocal, alongside wide harmonizing background vocals, singing over clapping, shimmering cymbals, groovy bass and soft kick hits. It sounds addictive, happy and joyful. | 2014-01-28T21:37:50Z | di2dadance | 今次誠邀多位跳舞前輩及好友拍攝HAPPY 希望鼓勵新一代的舞蹈員 以開心和享樂的態度跳舞 堅持不放棄! 由於我的時間有限,未能邀請所有的朋友參與拍攝, 非常感謝幫忙拍攝的 ﹣Allen To ﹣Kinko Koo ﹣Lok Man ﹣Leung ﹣Sunny Wong ﹣Vivian ﹣Bo Sir ﹣小燕 ﹣Bowie ﹣Popping Douglee ﹣Kato ﹣榮 ﹣Maska ﹣Timothy ﹣Louis ﹣Popper 88 ﹣Virago Carmen ﹣Wh Chung ﹣Popping Lok ﹣Chu Tin ﹣Shing ﹣Danie ﹣佳 三月我會繼續拍攝繼續享受跳舞的樂趣 PLS SUPPORT~~ | ["Music", "Soul music"] | ["pop", "passionate male vocal", "wide harmonizing background vocals", "clapping", "shimmering cymbals", "groovy bass", "soft kick hits", "addictive", "happy", "joyful"] | 4 | L2-EGNKzUAQ | 2146 | |
Blues, Country Blues, Rhythm & Blues | The low quality recording features a country blues song that consists of fruity male vocal singing over groovy electric guitar melodies, groovy bass, shimmering cymbals, mellow snare, soft kick hits and clapping. The recording is a bit noisy, as it is vintage, and it sounds passionate, groovy, uptempo and cool. | 2010-06-04T21:51:03Z | StrontiumDawg | 3 fine slices of blues music. Got my mojo workin' - Muddy Waters, Frankie - Missisipi John Hurt, Crawling up a hill - John Mayall | ["Blues", "Singing", "Swing music", "Country", "Music", "Rhythm and blues", "Music of Latin America"] | ["low quality", "country blues", "vintage", "noisy", "fruity male vocal", "groovy electric guitar melodies", "groovy bass", "shimmering cymbals", "mellow snare", "soft kick hits", "clapping", "uptempo", "groovy", "passionate", "cool"] | 4 | ZzyWbehtt0M | 3433 | |
Hellsing Opening (Full Song) | The low quality recording features a blues song that consists of filtered monotone male vocal singing over groovy bass, groovy organ keys, chords, soft kick hits, punchy snare and shimmering cymbals. The song is poorly mixed, as the vocals are not so much in the face as they should be, probably because the bass is eating the other elements - making it sound boomy. | 2008-10-02T19:30:20Z | M00skit0 | Hellsing Op. Full. Yasushi Ishii - Logos naki World | ["Music", "Grunge"] | ["blues", "punchy snare", "groovy bass", "filtered monotone male vocal", "shimmering cymbals", "soft kick hits", "groovy organ keys chords", "boomy", "low quality", "poor mix"] | 4 | d-KxsdWX9xE | 3754 |
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;