musiccaps_details (view)
4 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "soft" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- emotional · 4 ✖
- soft · 4 ✖
- low quality 3
- mellow 2
- noisy 2
- passionate 2
- acoustic guitar 1
- arpeggiated acoustic guitar melody 1
- ballad 1
- country hits 1
- country pop 1
- cover 1
- duet 1
- folk music 1
- folk pop 1
- heartfelt 1
- live performance 1
- lullaby 1
- male vocal 1
- mandolin 1
- medium tempo 1
- mellifluous 1
- mellow girl vocal 1
- mellow piano melody 1
- melodious 1
- mono 1
- muffled snare rolls 1
- plucked strings melody 1
- pop 1
- reverberant 1
- …
musiccaps_names (array) 11 ✖
- Music 4
- Singing · 4 ✖
- Mandolin 2
- Ukulele 2
- Gospel music 1
- Guitar 1
- Lullaby 1
- Musical instrument 1
- Plucked string instrument 1
- Song 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Going to California (Led Zeppelin) | The low quality recording features a cover of a rock song and it consists of an arpeggiated acoustic guitar melody over which there is a soft female vocal singing. The recording is noisy, in mono and it sounds emotional, soft and passionate. | 2011-01-17T17:58:17Z | iLoveSHELmusic | I haven't been able to get this song out of my head the last few months, so I decided to play with it a little using my friend Wendy's bright little Fender mando. -Eva Keep in touch with SHEL - http://shelmusic.com Facebook: http://on.fb.me/1X7qCMV Twitter: http://bit.ly/1UinXkS instagram: http://bit.ly/1KnWWb0 iTunes: http://apple.co/1fS1zvB | ["Singing", "Guitar", "Music", "Mandolin", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["low quality", "soft female vocal", "arpeggiated acoustic guitar melody", "noisy", "mono", "passionate", "emotional", "soft", "cover", "rock"] | 4 | 62L5kn1qFeY | 719 | |
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 | |
Christophe Willem Pour Ne Pas Vivre Seul | The low quality recording features a live performance of a ballad song that consists of passionate male vocal singing over a mellow piano melody. It sounds soft, emotional, sad and heartfelt. | 2009-06-03T11:59:11Z | kyubi59241 | Pour ne pas vivre seul On vit avec un chien On vit avec des roses Ou avec une croix Pour ne pas vivre seul On sfait du cinéma On aime un souvenir Une ombre, nimporte quoi Pour ne pas vivre seul On vit pour le printemps Et quand le printemps meurt Pour le prochain printemps Pour ne pas vivre seul Je taime et je tattends Pour avoir lillusion De ne pas vivre seul De ne pas vivre seul Pour ne pas vivre seul Des filles aiment des filles Et lon voit des garçons Épousaient des garçons Pour ne pas vivre seul Dautres font des enfants Des enfants qui sont seuls Comme tous les enfants Pour ne pas vivre seul On fait des cathédrales Où tous ceux qui sont seuls Saccrochent à une étoile Pour ne pas vivre seul Je taime et je tattends Pour avoir lillusion De ne pas vivre seul Pour ne pas vivre seul On se fait des amis Et on les réunit Quand vient les soirs dennui On vit pour son argent Ses rêves, ces palaces Mais on na jamais fait Un cercueil à deux places Pour ne pas vivre seul Moi, je vis avec toi Je suis seul avec toi Tu es seul avec moi Pour ne pas vivre seul On vit comme ceux qui veulent Se donner lillusion De ne pas vivre seul | ["Singing", "Music", "Tender music"] | ["low quality", "live performance", "passionate", "male vocal", "mellow piano melody", "soft", "emotional", "heartfelt", "ballad", "sad"] | 4 | NwUJe24OxC8 | 2379 | |
Mandolin Orange - Wake Me @Pickathon 2014 On The Farm | This song is a pleasant love song duet. The tempo is medium with acoustic guitar and ukulele accompaniment.the song is mellow, soft, emotional, romantic, nostalgic. This song is Country/Folk pop. | 2015-01-29T23:15:41Z | Pickathon | http://pickathon.com/ Presents Mandolin Orange live at Pendarvis Farm. Filmed on August 2, 2014 Channel Host: http://Grist.org Song: Wake Me Record Label: http://www.redeyeusa.com/ Producer: Ryan Stiles Executive Producer: Zale Schoenborn Associate Producer: Eric Schoenborn, Terry Groves, Ned Failing, John MacArthur Production Manager: Seth Chandler Production Coordinator: Alisha Flaumenbaum Editor: Stephanie Manzo Camera: Emilee Booher Audio/Co-Producer: Dylan McNab http://www.mandolinorange.com/ http://pickathon.com | ["Singing", "Music", "Mandolin", "Ukulele"] | ["duet", "medium tempo", "ukelele", "folk pop", "folk music", "mellifluous", "simple melody", "country pop", "country hits", "string instruments", "folk music", "acoustic guitar", "mandolin", "melodious", "pop", "country pop", "mellifluous", "romantic", "emotional", "sentimental", "soft", "mellow"] | 7 | n1fY-23ffl0 | 4513 |
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;