musiccaps_details (view)

3 rows where musiccaps_aspects contains "low quality" and musiccaps_names contains "Child singing"

✎ View and edit SQL

This data as json, CSV (advanced)

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

CSV options: 

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;