musiccaps_details (view)
2 rows where musiccaps_aspects contains "home video" and musiccaps_aspects contains "sad"
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|
bathtub - waxahatchee (cover) | A female vocalist sings this soft melody. The tempo is slow with acoustic guitar accompaniment. The guitar sound is muffled. The song is sad,poignant, melancholic, sentimental,emotional and lonely. This song is Pop. | 2013-10-01T02:06:18Z | gabbywade | idk hey blog: http://2003rapvideo.tumblr.com/ instagram: veganclit_ | ["Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum", "Vocal music"] | ["home video", "home recording", "female singing", "lonely sad", "room acoustics", "muffled guitar quality", "husky voice", "lonely", "sad", "poignant", "acoustic guitar", "slow tempo", "soft", "mellow", "poignant", "melancholic", "pop"] | 7 | mq_b6QKVsuc | 4495 | |
gangster baby crying 2 | A baby cries in pain followed by a slowed down version of the audio that sounds like a groan. The sound track has an Arabian flavour to it with a traditional horn playing melody with a keyboard harmony and no percussion. The audio quality is extremely poor and highly distorted. | 2008-02-22T15:44:49Z | bob sam | just watch the damn video and comment on it | ["Music", "Baby cry, infant cry"] | ["poor audio quality", "baby crying", "horn playing melody", "slowed down audio", "arabic music influences", "groaning sound", "keyboard harmony", "traditional horn instruments", "unsettling", "sad", "hunger", "home video", "movie soundtrack", "distorted vocals"] | 1 | tk4s-nlhmEQ | 5060 |
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;