musiccaps_details (view)
2 rows where musiccaps_aspects contains "passionate girl vocal" and musiccaps_author = 4 sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- cover 2
- low quality 2
- passionate girl vocal · 2 ✖
- acoustic guitar melody 1
- acoustic rhythm guitar 1
- crackling 1
- emotional 1
- heartfelt 1
- mellow 1
- noisy 1
- passionate 1
- rock 1
- simple bass guitar 1
- smooth bass 1
- soft 1
musiccaps_names (array) 6 ✖
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Angelica singing Cheetah Sisters - Cheetah Girls | The low quality recording features a cover of a song sung by passionate girl vocalists over acoustic guitar melody and smooth bass. The recording is very noisy and crackly. Judging by the quality of it, the vocalist is singing on a very cheap sounding microphone - which makes the sound quality even worse. | 2006-11-17T00:14:17Z | cchhaanneeyy | Angelica (age 7) singing Cheetah Girls - "Cheetah Sisters." | ["Music", "/t/dd00004", "Child singing", "Synthetic singing"] | ["cover", "low quality", "passionate girl vocal", "acoustic guitar melody", "smooth bass", "noisy", "crackling"] | 4 | 5XXAeSybGK0 | 665 | |
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 |
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;