musiccaps_details (view)
3 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "noisy" and musiccaps_names contains "Gospel music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Melfina's Lullaby [Fandub] By Kizzy | The low quality recording features a lullaby that consists of mellow girl vocal singing over staccato string melody in the left channel and plucked strings melody in the right channel of the stereo image. There are muffled, barely audible, muffled snare rolls in the background. The recording is noisy and reverberant, and it sounds soft, emotional and mellow. | 2007-11-28T22:50:24Z | Kizzychan04 | A new version, it was hard to hear myself in the old on @3@ | ["Singing", "Gospel music", "Music", "Song", "Lullaby"] | ["low quality", "mellow girl vocal", "plucked strings melody", "staccato strings melody", "reverberant", "noisy", "lullaby", "soft", "emotional", "mellow", "muffled snare rolls"] | 4 | H_2ZPxy80Eo | 1815 | |
Chiquilla. Interpretacion GRUPO FREE SOUNDS de Ensenada, BC | The low quality recording features a live performance of a regional Mexican song and it consists of passionate male vocal singing over groovy bass guitar, mellow synth keys melody and electric guitar melody, followed by shimmering tambourine, hi hats and punchy kick. It sounds passionate, emotional and soulful - like something you would hear at family gathering events. | 2012-04-20T18:44:22Z | victor lopez | PRESENTACION EN EL PROGRAMA LA VELADA DE SINTESIS TELEVISION TIJUANA (DERECHOS RESERVADOS) DEL GRUPO MUSICAL FREE SOUNDS DE ENSENADA, BC | ["Christmas music", "Gospel music", "Music", "Song"] | ["low quality", "live performance", "regional mexican", "passionate male vocal", "groovy bass guitar", "soft synth keys melody", "shimmering tambourine", "punchy kick", "electric guitar melody", "noisy", "passionate", "emotional", "soulful", "shimmering hi hats"] | 4 | RNwiEsjrhiQ | 2694 | |
phawulos tegegn in Oslo Norway | The low quality recording features a live performance of fruity male vocal singing over funky piano melody and beat played on playback that consists of punchy snare and kick hits, shimmering hi hats and smooth bass. The crowd is also singing along, harmonizing with the lead vocal. It sounds emotional and groovy, even though the recording is noisy. | 2015-01-01T02:26:13Z | GoSo GoSo | Oromo gospel song phawulos tegegn | ["Singing", "Gospel music", "Music", "Vocal music"] | ["low quality", "folk", "fruity male vocal", "funky piano melody", "playback beat", "shimmering hi hats", "punchy snare", "punchy kick", "smooth bass", "noisy", "live performance", "harmonizing crowd vocals", "emotional", "groovy"] | 4 | _78P-0zWJtg | 3445 |
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;