musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "passionate", musiccaps_aspects contains "simple bass" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- passionate · 4 ✖
- simple bass · 4 ✖
- low quality 3
- emotional 2
- acoustic guitar melody 1
- acoustic guitar solo melody 1
- acoustic rhythm guitar melody 1
- arpeggiated harp melody 1
- country 1
- fruity male vocal 1
- heartfelt 1
- keys chords 1
- mellow 1
- passionate female vocal 1
- passionate reverberant male vocal 1
- percussive acoustic rhythm guitar 1
- punchy snare 1
- shimmering bells melody 1
- simple hi hats 1
- soft 1
- soft kick hits 1
- soulful 1
- sustained strings melody 1
- traditional 1
- wide arpeggiated acoustic guitar melody 1
- wide harmonizing background vocals 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Disney Princess | The low quality recording features a wide harmonizing background vocals singing alongside passionate female lead vocal, over punchy snare hits, shimmering bells melody, simple hi hats, soft kick hits, simple bass and acoustic guitar melody. It sounds passionate, mellow and soft. | 2009-01-02T18:58:44Z | Renie42 | I like Disney´s characters so I decided to make this video about Ariel, Aurora, Belle, Cinderella, Jasmine, Mulan, Pocahontas and Snow White. | ["Christian music", "Music"] | ["low quality", "wide harmonizing background vocals", "passionate female vocal", "punchy snare", "shimmering bells melody", "simple hi hats", "soft kick hits", "simple bass", "acoustic guitar melody", "passionate", "mellow", "soft"] | 4 | NLQts9t7d8k | 2332 | |
Kjarkas - Mi gran amor | The low quality recording features a passionate, reverberant male vocal singing over a wide arpeggiated acoustic guitar melody and acoustic guitar solo melody, followed by a simple bass. It sounds emotional and passionate. | 2012-11-07T23:29:37Z | Erick Salazar | Mi amor, mi gran amor, mi mas bella ilusión, mejor canción, los ojos de mi alma a quien cuide, la tierna ilusión que alimente... | ["Folk music", "Music"] | ["low quality", "passionate reverberant male vocal", "acoustic guitar solo melody", "wide arpeggiated acoustic guitar melody", "simple bass", "emotional", "passionate"] | 4 | TWV3YLscSaw | 2839 | |
the origin of the white race | The low quality recording features an acoustic rhythm guitar melody, arpeggiated harp melody, simple bass and sustained strings melody. It sounds soulful and passionate - like a traditional song. | 2011-06-17T13:50:28Z | sicarevoluta | http://lasxtribus.wordpress.com/ Only countries whose populations have at least fifty percent of R1b haplogroup may be "sensu stricto" western european white people. that is, Only from Germany to the atlantic coast. The rest of Eastern Europe were mixed with asian and mongol people and these populations are distinctly Asian nonwhite. | ["Music", "Tender music"] | ["low quality", "acoustic rhythm guitar melody", "arpeggiated harp melody", "simple bass", "sustained strings melody", "soulful", "passionate", "traditional"] | 4 | cGrQw46ftj0 | 3694 | |
George Jones - Colour of the Blues - Country Music Experience | The Country song features a fruity male vocal singing over percussive acoustic rhythm guitar, simple bass and keys chords. It sounds emotional, passionate and heartfelt - like something you would hear in the old pubs and bars. | 2012-10-07T07:52:56Z | Country Music Experience | Country Music Experience : (Re)Discover the finestcountry Music Selection. Country Music experience is your channel for all the country music, where you can experience music, in high audio quality. Subscribe to stay connected to our channel and receive all of our video updates! -Country Music experience | ["Christmas music", "Music"] | ["country", "percussive acoustic rhythm guitar", "keys chords", "fruity male vocal", "emotional", "passionate", "heartfelt", "simple bass"] | 4 | tGic59TlrVg | 5022 |
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;