musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "cover", musiccaps_aspects contains "mellow" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- cover · 3 ✖
- mellow · 3 ✖
- acoustic rhythm guitar 2
- low quality 2
- rock 2
- addictive 1
- addictive synth keys melody 1
- breathy flute melody 1
- electric guitar melody 1
- emotional 1
- energetic 1
- fun 1
- groovy bass 1
- groovy bass guitar 1
- happy 1
- heartfelt 1
- kids song 1
- passionate 1
- passionate girl vocal 1
- punchy kick 1
- punchy snare 1
- shimmering cymbals 1
- simple bass guitar 1
- soft 1
- soft male vocal 1
- sweet girl vocal 1
musiccaps_names (array) 7 ✖
- Music 2
- Acoustic guitar 1
- Independent music 1
- Music for children 1
- Singing 1
- Song 1
- Yodeling 1
youtube_published (date) 3 ✖
- 2006-08-06 1
- 2012-06-11 1
- 2013-02-02 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
He Taught Me How To Yodel(Alessandra) 7yrs Old | The low quality recording features a cover of a kids song that consists of sweet girl vocal singing over breathy flute melody, groovy bass and acoustic rhythm guitar. It sounds mellow, happy and fun. | 2013-02-02T02:10:57Z | Alessandra Riehl | Recorded and edited by Germaine Mashall David (gmdavidstudios.com) | ["Singing", "Yodeling", "Music", "Song"] | ["sweet girl vocal", "cover", "kids song", "breathy flute melody", "groovy bass", "acoustic rhythm guitar", "happy", "fun", "mellow", "low quality"] | 4 | 8hSmQpOPXJE | 936 | |
Vazquez Sounds - Let It Be (Cover) | The low quality recording features a cover of a rock song and it consists of a passionate girl vocal singing over acoustic rhythm guitar chords and simple bass guitar. It sounds passionate, emotional, heartfelt, mellow and soft. | 2012-06-11T21:01:17Z | Vazquez Sounds | FOLLOW US: Instagram.com/VazquezSounds http://twitter.com/VazquezSounds LIKE US: http://www.facebook.com/vazquezsoundsproduction http://www.vazquezsounds.com iTunes: http://smarturl.it/vazquezsounds Music Produced by Abelardo Vazquez & Joe "Loquito" Dabdoub. Mix by Christian Cummings Video Produced by Abelardo Vazquez, Jaime Mejía, Carlos Hernandez (Aguachile) | ["Acoustic guitar", "Music", "Music for children"] | ["low quality", "cover", "rock", "acoustic rhythm guitar", "simple bass guitar", "passionate girl vocal", "passionate", "emotional", "heartfelt", "mellow", "soft"] | 4 | LTG-uVV_6q0 | 2192 | |
Maps (UCSC Version) - Yeah Yeah Yeahs | The cover of a rock song consists of soft male vocal singing over shimmering cymbals, punchy snare and kick hits, groovy bass guitar, addictive synth keys melody and electric guitar melody. It sounds energetic, but yet mellow and addictive - thanks to that cadence. | 2006-08-06T04:59:47Z | Michael Tucker | "Fantastically Creepy" is one way it has been described. How would you describe it? Video for "Maps" by the Yeah Yeah Yeahs. Go UCSC (University of California at Santa Cruz). Check out more of our movies at http://www.finite-films.com | ["Independent music"] | ["cover", "rock", "soft male vocal", "shimmering cymbals", "punchy snare", "punchy kick", "groovy bass guitar", "addictive synth keys melody", "electric guitar melody", "energetic", "addictive", "mellow"] | 4 | nZOgoVEud_w | 4553 |
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;