musiccaps_details (view)
2 rows where musiccaps_aspects contains "cover" and musiccaps_names contains "Child singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- cover · 2 ✖
- acoustic 1
- acoustic guitar melody 1
- child male vocal 1
- chill 1
- crackling 1
- emotional 1
- low quality 1
- medium tempo 1
- melancholic 1
- melodic singing 1
- noisy 1
- passionate girl vocal 1
- pop music 1
- smooth bass 1
- ukulele 1
musiccaps_names (array) 8 ✖
- Child singing · 2 ✖
- Music 2
- /t/dd00004 1
- Musical instrument 1
- Plucked string instrument 1
- Singing 1
- Synthetic singing 1
- Ukulele 1
youtube_published (date) 2 ✖
- 2006-11-17 1
- 2011-10-16 1
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 | |
Someone Like You - Adele (cover) | This is an acoustic cover of a pop music piece. There is a boy singing melodically. The chords are being played on the ukulele. The atmosphere of the original piece is emotional, but the characteristics of the ukulele create a chill atmosphere. The piece is in medium tempo. This rendition of the piece could be used in the soundtrack of a high school drama movie/TV series. It could also be playing in the background of a coffee shop. | 2011-10-16T01:36:39Z | Aidan Laprete | (2011) This is my ukulele cover of "Someone Like You" By Adele. | ["Singing", "Music", "Musical instrument", "Ukulele", "Plucked string instrument", "Child singing"] | ["cover", "acoustic", "pop music", "ukulele", "child male vocal", "melodic singing", "emotional", "melancholic", "chill", "medium tempo"] | 9 | I1fcUe9MoMw | 1865 |
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;