musiccaps_details (view)
2 rows where musiccaps_aspects contains "poor audio quality" and musiccaps_aspects contains "steady drumming"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- male singer 2
- medium tempo 2
- poor audio quality · 2 ✖
- steady drumming · 2 ✖
- ambient sounds 1
- ambient tones 1
- audio transitions 1
- christmas concert 1
- christmas song 1
- christmas time 1
- clapping 1
- comical 1
- different music tracks 1
- emphatic vocals 1
- forest ambient sounds 1
- funny video music track 1
- heavy reverb 1
- idea music track 1
- incoherent music 1
- insect noises 1
- keyboard harmony 1
- live audience 1
- live performance 1
- male sighing tones 1
- marching style drumming 1
- piano accompaniment 1
- teen singer 1
- vocal backup 1
- water filling sounds 1
- youtube 1
musiccaps_names (array) 7 ✖
- Music 2
- Choir 1
- Christmas music 1
- Outside, rural or natural 1
- Singing 1
- Trickle, dribble 1
- Water 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
15 Types of NSmen | The song is an instrumental piece with various tracks. The song is medium tempo with a piano accompaniment, groovy bass line , steady drumming track, a male sighing in pleasure and water filling a bottle tone. The song is a mix bag of music tracks for various scenes. The song is an instrumental track for a funny YouTube video. | 2013-06-13T09:30:44Z | Wah!Banana | We're on Facebook! http://www.facebook.com/wahbananasg And Twitter @wahbananasg In collaboration with Night Owl Cinematics Facebook: https://www.facebook.com/Nightowlcine... Youtube: http://www.youtube.com/alozerk Guest Starring Clifford: http://www.facebook.com/clifford.yow.7 James: http://www.youtube.com/james060688 Franster: http://www.facebook.com/franster.wong Sikeen: https://www.facebook.com/SikeenNOC Subscribe to Wah!Banana! We bring you the best locally flavoured comedy in Singapore and Malaysia! Tune in every Thursday for brand spanking new content featuring our cast and crew. | ["Music", "Trickle, dribble", "Water", "Outside, rural or natural"] | ["piano accompaniment", "different music tracks", "youtube", "idea music track", "audio transitions", "forest ambient sounds", "male singer", "water filling sounds", "medium tempo", "steady drumming", "insect noises", "ambient tones", "comical", "funny video music track", "male sighing tones", "poor audio quality", "marching style drumming"] | 1 | PAX2PMha2dU | 2514 | |
Justin Bieber singing Christmas songs in Washington 2011 (perfoming for Obama!).mp4 | A male vocalist sings this Christmas song. The tempo is medium with minimal instruments like keyboard harmony and steady drumming. The audio quality is inferior so the music is incoherent. This is a live performance with ambient sounds of people clapping and cheering. This is a contemporary Christmas Song. | 2012-03-17T20:04:17Z | virgi92dT | Yeeeee!!! 1. Mistletoe 2. Away in a manger 3. a classic Christmas song featuring with Obama | ["Christmas music", "Singing", "Music", "Choir"] | ["male singer", "teen singer", "medium tempo", "vocal backup", "keyboard harmony", "steady drumming", "poor audio quality", "incoherent music", "emphatic vocals", "live performance", "ambient sounds", "clapping", "christmas song", "christmas time", "christmas concert", "live performance", "live audience", "heavy reverb"] | 7 | ZNGJN30LCwM | 3369 |
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;