musiccaps_details (view)
2 rows where musiccaps_aspects contains "baby crying" and musiccaps_aspects contains "keyboard harmony" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- baby crying · 2 ✖
- keyboard harmony · 2 ✖
- arabic music influences 1
- bass guitar 1
- classic pop 1
- distorted vocals 1
- fast tempo 1
- groaning sound 1
- home video 1
- horn playing melody 1
- hunger 1
- infectious drumming 1
- love song 1
- male singer 1
- movie soundtrack 1
- poor audio quality 1
- retro 1
- rock and roll 1
- romantic 1
- sad 1
- slowed down audio 1
- static 1
- steady drumming 1
- superimposed noises 1
- synthesiser arrangements 1
- tapping sound 1
- traditional horn instruments 1
- unsettling 1
- upbeat 1
- violins 1
- vivacious 1
- youthful 1
musiccaps_names (array) 4 ✖
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
RickRolling the Baby | A male singer sings this classic pop song. The tempo is fast with keyboard harmony, violins,infectious drumming,funky bass guitar and synthesiser arrangement. There are sounds of static, tapping and a baby crying loudly superimposed on the song. The audio quality is inferior and the recording is amateur. This song is Retro Rock and Roll. | 2008-01-26T06:05:33Z | DessertSage | http://www.marylowd.com | ["Crying, sobbing", "Music", "Baby cry, infant cry", "Inside, small room"] | ["male singer", "fast tempo", "baby crying", "youthful", "romantic", "upbeat", "superimposed noises", "synthesiser arrangements", "infectious drumming", "love song", "romantic", "vivacious", "violins", "bass guitar", "keyboard harmony", "tapping sound", "static", "steady drumming", "classic pop", "rock and roll", "retro"] | 7 | qMbGFWz9who | 4780 | |
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;