musiccaps_details (view)
2 rows where musiccaps_aspects contains "soft snare hits", musiccaps_author = 4 and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- soft snare hits · 2 ✖
- addictive 1
- ballad 1
- bright brass melody 1
- crackles 1
- emotional 1
- funk/soul 1
- funky 1
- funky guitar melody 1
- groovy bass 1
- groovy hi hats 1
- harmonizing mixed vocals 1
- heartfelt 1
- low quality 1
- mellow female vocal 1
- mellow organ keys melody 1
- mono 1
- noisy 1
- romantic 1
- shimmering cymbals 1
- smooth bass 1
- soft kick hits 1
musiccaps_names (array) 9 ✖
- Music 2
- Singing · 2 ✖
- Classical music 1
- Music of Asia 1
- Psychedelic rock 1
- Rock and roll 1
- Song 1
- Swing music 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Music City Soul Brothers - let our love go on (Music City) | The low quality recording features harmonizing mixed vocals singing over groovy bass, shimmering cymbals, soft snare hits, funky guitar melody and bright brass melody. The recording is very noisy, in mono, with some crackles in it and it sounds funky and addictive - thanks to those vocals. Sounds like something you would hear in clubs during the 60s and 70s. | 2014-01-27T18:37:44Z | Alex Rural Soul | this song remind me the impressions Hit "it's allright"..i love this style of mid tempo soul ... for first time on youtube!!!! | ["Singing", "Swing music", "Music", "Psychedelic rock", "Rock and roll"] | ["funk/soul", "low quality", "harmonizing mixed vocals", "groovy bass", "shimmering cymbals", "soft snare hits", "bright brass melody", "funky guitar melody", "funky", "noisy", "crackles", "addictive", "mono"] | 4 | ZsmfIMEzrQs | 3422 | |
Famous paintings of wedding and marriage (Music: I dream of you/Sha la la love song) | The ballad song features a mellow female vocal singing over a mellow organ keys melody, groovy hi hats, soft snare and kick hits and smooth bass. It sounds emotional, heartfelt and romantic - like something you would hear at a wedding. | 2011-05-05T16:33:05Z | isisip | Famous paintings of wedding and marriage in the history of art. Artists include: John Henry Frederick Bacon, Tuxen Laurits, Pierre-Auguste Renoir, Firs Sergeevich Zhuravlev, Edmund Blair Leighton, Harrison Fisher. If you are interested in knowing the titles of the paintings, please visit http://weddingdressmarriage.blogspot.com/ Song: I dream of you Words and Music by: Isisip Performed by :Isisip (C) 2008-2011 Isisip MP3 available at http://www.pianomusicdownload.blogspot.com See also: Sad beauty piano solo in 3 keys https://www.youtube.com/watch?v=IE95p3edfIg Top 10 piano songs https://www.youtube.com/watch?v=fKxmSe5s9_s Piano music playlist https://www.youtube.com/watch?v=K0mXJ-QYIRw The unfinished story piano performance https://www.youtube.com/watch?v=N06aA_vjZPA Moonlight piano performance https://www.youtube.com/watch?v=NFcPR5WgeQA Sad beauty piano performance https://www.youtube.com/watch?v=DgbdWyTtWco Ask the sky without words piano performance https://www.youtube.com/watch?v=EnJSIOaPxp0 Please buy the music or make a donation: http://pianodiscography.blogspot.com Sheet music: http://isisippianosheetmusic.blogspot.com | ["Singing", "Music of Asia", "Music", "Wedding music", "Song", "Classical music"] | ["ballad", "mellow organ keys melody", "groovy hi hats", "soft kick hits", "soft snare hits", "smooth bass", "mellow female vocal", "emotional", "heartfelt", "romantic"] | 4 | g0scnRzoo9M | 4003 |
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;