musiccaps_details (view)
3 rows where musiccaps_aspects contains "low quality", musiccaps_author = 4 and musiccaps_names contains "Child singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- low quality · 3 ✖
- noisy 3
- mono 2
- acoustic guitar melody 1
- cover 1
- crackling 1
- fun 1
- happy 1
- muffled 1
- passionate 1
- passionate girl vocal 1
- playback 1
- pop 1
- raw innocent girl vocal 1
- sloppy acoustic rhythm guitar 1
- smooth bass 1
- sweet girl vocal 1
musiccaps_names (array) 9 ✖
- Child singing · 3 ✖
- Music 3
- /t/dd00004 1
- Acoustic guitar 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Strum 1
- Synthetic singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Little girl singing Cassie's "me and u" | The low quality recording features a girl with a sweet voice singing over pop songs played on playback. The recording is in mono, very noisy and it sounds muffled, but also happy, fun and innocent. | 2007-08-14T00:46:47Z | melisarock1 | She is 4 and so cute!! | ["Music", "Child singing"] | ["low quality", "pop", "playback", "sweet girl vocal", "fun", "happy", "noisy", "muffled", "mono"] | 4 | 1PN-bfs2EhY | 267 | |
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 | |
5 year old singing Taylor Swift and playing custom made Taylor guitar | The low quality recording features a raw innocent girl vocal singing over sloppy acoustic rhythm guitar chords. It sounds passionate and the recording is noisy and in mono. | 2011-04-05T22:28:53Z | txfire76 | this is my 5 year old singing a Taylor Swift song and playing the Taylor guitar I made for her sister. | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument", "Child singing"] | ["low quality", "mono", "noisy", "raw innocent girl vocal", "sloppy acoustic rhythm guitar", "passionate"] | 4 | 5pIdH6p3kuo | 696 |
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;