musiccaps_details (view)
3 rows where musiccaps_aspects contains "acoustic rhythm guitar", musiccaps_aspects contains "cover" and musiccaps_aspects contains "fun"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- acoustic rhythm guitar · 3 ✖
- cover · 3 ✖
- fun · 3 ✖
- happy 3
- low quality 3
- kids song 2
- noisy 2
- sweet girl vocal 2
- breathy flute melody 1
- children song 1
- emotional 1
- emotional girl vocal 1
- groovy bass 1
- innocent 1
- mellow 1
- mono 1
- unbalanced stereo 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 | |
The Cat that loves Horses | The low quality video features a cover of a kids song and it consists of a sweet girl vocal singing over acoustic rhythm guitar. The recording is in mono, noisy and it sounds fun and happy. | 2008-10-19T03:57:30Z | kangurski | so cute :) | ["Music", "Mandolin", "Ukulele"] | ["low quality", "mono", "cover", "sweet girl vocal", "acoustic rhythm guitar", "noisy", "fun", "happy", "kids song"] | 4 | 9ZWmZdgrE78 | 1023 | |
The Sound of Music Video Audition Contest | The low quality recording features a cover of a children's song and it consists of an emotional girl vocal singing over acoustic rhythm guitar located in the right channel of the stereo image, which makes the stereo image unbalanced. The recording is a bit noisy and It sounds fun, happy, emotional and innocent. | 2009-08-17T18:08:11Z | Marty Frolick | Emily auditioning for Brigitta von Trapp | ["Music", "/t/dd00032"] | ["low quality", "emotional girl vocal", "acoustic rhythm guitar", "cover", "noisy", "unbalanced stereo", "fun", "happy", "emotional", "children song", "innocent"] | 4 | KCytKo5LzCc | 2066 |
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;