musiccaps_details (view)
3 rows where musiccaps_aspects contains "amateur recording" and musiccaps_aspects contains "scuffling"
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- amateur recording · 3 ✖
- scuffling · 3 ✖
- home recording 2
- alto 1
- angelic 1
- bubbles 1
- buzzing 1
- celestial 1
- choral harmony 1
- electronic music 1
- energetic drumming 1
- ethereal 1
- female singer 1
- female voice talking 1
- finger snapping 1
- harmonious 1
- high notes 1
- inferior audio quality 1
- instrumental 1
- male vocalist 1
- mediocre sound recording 1
- medium tempo 1
- melodic 1
- muffled sound 1
- muffled sounds 1
- no instruments 1
- person talking 1
- poor audio quality 1
- quality of 1
- rock 1
- rustling 1
- seconds 1
- soprano 1
- sound of chatter 1
- sound of water 1
- spirited 1
- static 1
- steel pan 1
- superimposed sounds 1
- superimposed sounds over song 1
- tapping 1
- vigorous drumming 1
- vigours background beat 1
- vocal vibrations 1
- whirring sound 1
musiccaps_names (array) 5 ✖
- Music 3
- A capella 1
- Electric toothbrush 1
- Gurgling 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fill the World With Love 6-09 | A female vocalist sings this mellifluous song.The tempo is slow with the vocalist singing a soprano, with alto choral harmony. There are sounds of rustling, whirring,scuttling and people talking in the background. The vocals are beautiful, mellifluous,and ethereal. | 2009-06-07T23:08:18Z | noodlebrain500 | Fill the World With Love 6-09 | ["Music", "Vocal music", "A capella"] | ["female singer", "high notes", "choral harmony", "ethereal", "vocal vibrations", "ethereal", "soprano", "alto", "whirring sound", "seconds", "melodic", "angelic", "celestial", "no instruments", "sound of chatter", "rustling", "scuffling", "harmonious", "amateur recording", "mediocre sound recording", "inferior audio quality", "quality of"] | 7 | -YIT4HBM__g | 61 | |
Missing from YouTube | This music is instrumental. The tempo is fast but the music is muffled as it is superimposed by a loud buzzing sound along with some tapping,scuffling, finger snapping ans tapping sounds. The music sounds like energetic Electronic music with vigorous drumming. | ["Electric toothbrush", "Music"] | ["instrumental", "buzzing", "tapping", "vigours background beat", "superimposed sounds", "finger snapping", "tapping", "amateur recording", "home recording", "poor audio quality", "electronic music", "vigorous drumming", "muffled sounds", "scuffling", "steel pan"] | 7 | 4042 | |||||
HZO Water Blocking Technology Demo | A male vocalist sings this energetic song. The tempo is fast with enthusiastic drumming , rhythmic electric and keyboard harmony. The song is muffled because of poor audio quality and several sounds that are superimposed on it. There are sounds of water, static, bubbles, scuffling and a female voice speaking. The song is incoherent but from what can be heard it sounds like Pop Rock. | 2011-08-18T19:44:40Z | ZAGGTV | HzO introduces its new WaterBlock technologies. HzO coatings enhance and protect devices from smartphones to textiles to important documents. HzO prevents damage caused by water; electronic devices remain fully functional after exposure. This video demonstrates the power of one of its WaterBlocking technologies. | ["Music", "Gurgling"] | ["male vocalist", "medium tempo", "spirited", "scuffling", "bubbles", "sound of water", "static", "person talking", "superimposed sounds over song", "muffled sound", "home recording", "amateur recording", "rock", "energetic drumming", "female voice talking"] | 7 | zjsWFvUkh7M | 5508 |
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;