musiccaps_details (view)
5 rows where musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "drums" and musiccaps_aspects contains "e-bass"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- amateur recording · 5 ✖
- drums · 5 ✖
- e-bass · 5 ✖
- medium tempo 2
- mid range 2
- acoustic guitar 1
- background laughter 1
- background-noises 1
- brass melody/keyboard 1
- crowd screaming 1
- dog barking 1
- e-guitar 1
- e-guitars 1
- experimental 1
- female voice 1
- funky 1
- glass shattering 1
- hands clapping 1
- lagging video 1
- male voice shouting 1
- male voice singing 1
- male voices singing 1
- medium to uptempo 1
- pop 1
- popmusic 1
- positive energy 1
- saxophone 1
- tambourine 1
- upbeat 1
- uptempo 1
musiccaps_names (array) 10 ✖
- Music 4
- Music of Latin America 2
- Music of Africa 1
- Pop music 1
- Scrape 1
- Scratch 1
- Singing 1
- Ska 1
- Tambourine 1
- Whoop 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mothers Day Special Service by Denver Tamil Church - Tambourine Praise dance | A drum is playing a four on the floor groove with a kick on every beat along to a bassline and a tambourine. Two e-guitars are strumming funky sounding chords. Male singers are singing a melody together in the mid-range. This song may be playing live at a local event. | 2012-05-09T06:42:04Z | Denver TamilChurch | Tambourine Praise dance by: Sis.Yolanda Moses Music from VIDUTHALAI album by Bro Moses Maharaja www.DenverTamilChurch.Org | ["Singing", "Music", "Ska", "Tambourine", "Music of Latin America"] | ["popmusic", "e-guitars", "drums", "tambourine", "male voices singing", "mid range", "e-bass", "amateur recording", "uptempo"] | 6 | HDSV7Pzq8CA | 1780 | |
160508 방탄소년단 BTS YOONGI CRYING | This audio contains an e-bass playing a melody along with a simple drum groove and other stringlike instruments. An e-guitar is playing a lead melody on top and in the background you can hear the crowd screaming. This is an amateur recording and of poor audio-quality. This song may be playing during a live show. | 2016-05-08T19:40:43Z | Fan noona dot com | He's looking for his parents in the audience when he finds them, he smiled at them, kneeling in thanks and we can see his shoulders shaking because of the crying. We love you very much too, Min yoongi. ♥ cr: in the vid | ["Music", "Pop music", "Whoop"] | ["amateur recording", "e-guitar", "drums", "e-bass", "crowd screaming", "medium tempo"] | 6 | IFumVgqOVaM | 1886 | |
Senior Brunch Performance | This audio contains a catchy melody played by a brass instrument, maybe a saxophone and a keyboard. A horn is playing a bass in a lower register along with a drum. In the background you can hear people laughing. This is an amateur recording and of poor audio-quality. | 2011-03-24T21:16:20Z | magleby1 | CJ Cosas/Mahomed Bassa, Zack Magleby/Cody Anderson, and Andy Harris/Shane McNeill put on a show at Clayton Valley's Senior Brunch. Video by: Sara McCracken | ["Music of Latin America"] | ["amateur recording", "background laughter", "hands clapping", "drums", "e-bass", "brass melody/keyboard", "upbeat", "positive energy"] | 6 | JSqyTVjYY6k | 2009 | |
Sound Asleep | An e-bass is playing a funky bassline with a drumbeat that sounds like the high frequencies have been filtered out. You can hear a lot of background noises that do not belong to the recording. Such as a dog barking, glass shattering, a male voice shouting and a female voice singing. All these sounds are using a reverb. This song may be playing as part of a movie scene. | 2007-10-18T10:44:06Z | selfademus | by Cathy Slim | ["Music", "Scratch", "Scrape"] | ["funky", "experimental", "e-bass", "background-noises", "glass shattering", "male voice shouting", "female voice", "drums", "dog barking", "amateur recording", "medium to uptempo"] | 6 | jbe3VM-5xdc | 4264 | |
Abrish Zegeyt - Idmaeyaen Bemulu | This song contains a male voice singing in the midrange while percussion instruments such a triangle and drums are playing a rhythm along with an e-bass. A baritone saxophone is playing a melody and someone is strumming chords and a melody on an acoustic guitar. This is an amateur recording. You can hear a high frequency tone from the recording and the sound is lagging. This song may be playing on the radio in a small village. | 2007-10-31T17:13:22Z | ahnd | ethiopian music | ["Music of Africa", "Music"] | ["pop", "amateur recording", "lagging video", "male voice singing", "mid range", "e-bass", "acoustic guitar", "saxophone", "drums", "medium tempo"] | 6 | pzpg2-jYu6k | 4748 |
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;