musiccaps_details (view)
4 rows where musiccaps_aspects contains "mellow", musiccaps_aspects contains "passionate male vocal" and musiccaps_aspects contains "soft"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- mellow · 4 ✖
- passionate male vocal · 4 ✖
- soft · 4 ✖
- emotional 3
- low quality 2
- passionate 2
- sad 2
- acoustic rhythm guitar 1
- addictive brass melody 1
- arpeggiated acoustic guitar melody 1
- lullaby 1
- mellow piano chords 1
- mellow woodwind melody 1
- noisy 1
- pop 1
- regional mexican 1
- shimmering bells 1
- smooth bass 1
- soft piano melody 1
- sustained strings melody 1
- walking on concrete sound 1
- wide arpeggiated piano melody 1
musiccaps_names (array) 7 ✖
- Music 3
- Brass instrument 1
- Lullaby 1
- Sad music 1
- Song 1
- Soul music 1
- Trumpet 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
GREAT SPIRIT [Nahko bear music video] | The Pop song features a passionate male vocal singing over mellow piano chords. It sounds passionate, emotional, mellow and soft. | 2012-05-13T00:46:26Z | Gro Films Storytelling | GREAT SPIRIT by Nahko http://nahko.com/ SHOT ON CANON 6D https://amzn.to/34nXZo3 (affiliate link) EAGLE MASK created by KOZMO MIMZI www.kozmomimzi.com https://www.facebook.com/KozmoMimzi/ Director/Edit- Dominik Walczuk www.grofilms.com Cinematography- Mikography (www.mikography.com) Dancer- Lea Black Vagabond- Piotr Walczuk Bird- Dominik Walczuk Special Thanks to- Renata Walczuk Maria Karin Lee Michael Walczuk Todd Hornbaker David McMahon Jennie Berghuis http://nahko.com/ www.grototote.com | ["Music", "Soul music"] | ["pop", "passionate male vocal", "mellow piano chords", "emotional", "passionate", "mellow", "soft"] | 4 | 0M7nETLOsKQ | 152 | |
Fawn Rescue | The low quality recording features a wide arpeggiated piano melody, sustained strings melody, mellow woodwind melody and shimmering bells over which the passionate male vocalist is singing at the very end of the loop. There is also the sound of walking on concrete. It sounds mellow, soft and sad. There is also the sound of walking on concrete. | 2011-06-21T06:56:26Z | Darren Jesse | Fawn rescued from pool on its last breath and reunited with its mother. Song: "Abba Father" by Christ Our Life - www.christourlife.ca. Song: "I Will Never Leave You" by Jay Stocker - www.scripture-lullabies.com | ["Music", "Sad music"] | ["walking on concrete sound", "low quality", "wide arpeggiated piano melody", "sustained strings melody", "mellow woodwind melody", "shimmering bells", "mellow", "soft", "passionate male vocal", "sad"] | 4 | 6CaZAITdAsk | 735 | |
Los Lobos - Bella Maria De Mi Alma | The Regional Mexican song features a soft piano melody, rhythm acoustic guitar, smooth bass, addictive brass melody and passionate male vocal singing on top of it. It sounds soft, mellow, passionate and emotional. | 2008-07-30T15:32:28Z | Rumpun Melayu | One of my all time favorites | ["Brass instrument", "Trumpet"] | ["regional mexican", "soft piano melody", "acoustic rhythm guitar", "smooth bass", "passionate male vocal", "addictive brass melody", "soft", "mellow", "emotional", "passionate"] | 4 | 7FHzw4HV75Y | 821 | |
funny divorce song (new version) - lullaby stephen lynch | The low quality recording features a lullaby sung by passionate male vocalists over an arpeggiated acoustic guitar melody. It sounds mellow, soft, sad and so emotional that you forget about how noisy the recording actually is. | 2010-09-27T00:48:20Z | TheLegallyfunny | Hillarious song and Service for cheryl cole Sumtime u have to ditch da B!@3ch or Dump the B@$Turd , I included a link to a great service which I used, it was online and they were quick so this song just cheered me up and thought id share a good Divorce Lawyers. | ["Music", "Song", "Lullaby"] | ["low quality", "noisy", "lullaby", "passionate male vocal", "arpeggiated acoustic guitar melody", "mellow", "soft", "sad", "emotional"] | 4 | iqOPJWWKo90 | 4220 |
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;