musiccaps_details (view)
4 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "simple bass"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- emotional · 4 ✖
- passionate · 4 ✖
- simple bass · 4 ✖
- low quality 3
- live performance 2
- acoustic guitar solo melody 1
- country 1
- crowd cheering 1
- crowd clapping 1
- crowd talking 1
- distorted 1
- exciting 1
- fruity male vocal 1
- harmonizing vocals 1
- harp melody 1
- heartfelt 1
- keys chords 1
- mellow piano chords 1
- mixed harmonized vocals 1
- mono 1
- noisy 1
- passionate female vocal 1
- passionate reverberant male vocal 1
- percussive acoustic rhythm guitar 1
- playback 1
- punchy kick 1
- punchy snare 1
- shimmering hi hats 1
- soul 1
- sustained strings melody 1
- synth pads 1
- wide arpeggiated acoustic guitar melody 1
musiccaps_names (array) 7 ✖
- Music 4
- Singing 2
- Christmas music 1
- Folk music 1
- Music of Asia 1
- Pop music 1
- Whoop 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
KC Concepcion in Chicago #8 | The low quality recording features harmonizing vocals singing over punchy kick and snare hits, shimmering hi hats, synth pads, simple bass and mellow piano chords. There are crowd cheering noises in the background as this is a live performance. It sounds passionate, emotional, exciting and the recording is noisy, in mono and slightly distorted. | 2011-10-31T01:02:49Z | TeamKC4life | KC Concepcion as Vivian sings the themesong of Lovers in Paris, Wag Na Wag Mong Sasabihin. Much love & thanks to my honey, John, for being KC's best videographer. | ["Singing", "Music", "Pop music", "Whoop"] | ["live performance", "low quality", "noisy", "mono", "crowd cheering", "distorted", "harmonizing vocals", "punchy snare", "punchy kick", "shimmering hi hats", "synth pads", "simple bass", "mellow piano chords", "passionate", "emotional", "exciting"] | 4 | He63KV_9Pwg | 1823 | |
St Julian's School flashmob | The low quality recording features a crowd talking and clapping to a soul song that is played on a playback. The song consists of a passionate female vocal, alongside mixed harmonizing vocals, singing over sustained strings melody, simple bass and harp melody. It sounds emotional and passionate. | 2015-07-16T19:47:33Z | SouthWalesArgus | St Julian's School flashmob for Mrs Gabica | ["Singing", "Music of Asia", "Music"] | ["low quality", "crowd talking", "crowd clapping", "simple bass", "harp melody", "passionate female vocal", "mixed harmonized vocals", "sustained strings melody", "soul", "passionate", "emotional", "live performance", "playback"] | 4 | PuJxL6tLxm4 | 2575 | |
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 | |
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;