musiccaps_details (view)
2 rows where musiccaps_names contains "/t/dd00004" and musiccaps_names contains "Synthetic singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
musiccaps_names (array) 4 ✖
- /t/dd00004 · 2 ✖
- Music 2
- Synthetic singing · 2 ✖
- Child singing 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 | |
Tyler Perry Laugh To Stop From Crying Play in Philadelphia-The Whole Cast Singing | This is a low quality recording of a motown style song. The song seems to have been recorded using a cellphone. The lead female vocalist has a soulful and powerful voice. The song is upbeat and jovial. | 2009-10-29T06:19:52Z | Sylvia Lawton | October 25th -The whole cast singing The Jackson's Five I Want You Back. | ["Music", "/t/dd00004", "Synthetic singing"] | ["live performance", "low quality recording", "cellphone recording", "low quality audio", "motown song", "upbeat", "soulful female vocal"] | 3 | MocXmVbat3s | 2298 |
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;