musiccaps_details (view)
4 rows where musiccaps_aspects contains "distorted" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- distorted · 4 ✖
- low quality 4
- passionate · 4 ✖
- live performance 3
- emotional 2
- harmonizing vocals 2
- messy 2
- noisy 2
- punchy kick 2
- punchy snare 2
- shimmering hi hats 2
- acoustic rhythm guitar 1
- addictive 1
- addictive female vocal 1
- breathy flute melody 1
- crowd cheering 1
- crowd clapping 1
- electric guitar melody 1
- energetic 1
- exciting 1
- folk rock 1
- groovy bass 1
- groovy bass guitar 1
- harsh 1
- mellow piano chords 1
- mellow strings melody 1
- mono 1
- muddy 1
- simple bass 1
- snappy rimshots 1
- snare roll 1
- soulful 1
- string melody 1
- synth pads 1
- traditional pop 1
- wooden percussions 1
musiccaps_names (array) 9 ✖
- Music 3
- Singing 2
- /t/dd00003 1
- Flute 1
- Music of Asia 1
- Pop music 1
- Salsa music 1
- Whoop 1
- Wind instrument, woodwind instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Raga Shuddha Sarang on Bansuri | The low quality recording features a breathy flute melody played over mellow strings melody. It sounds soulful and passionate. The recording is noisy and slightly distorted. | 2012-12-14T03:27:54Z | Bansuriflute | Http://www.bansuriflute.com Http://www.facebook.com/bansuriflute Raga Shuddha Sarang is an afternoon raga signifying the element of fire and heat. It is played here in form of free improvisation (alap) and two compositions in teentaal (rhythm of 16 beats) and Ektaal (12 beats). Accompanying on tabla is Vikas Yendluri. | ["Wind instrument, woodwind instrument", "Flute"] | ["low quality", "noisy", "breathy flute melody", "mellow strings melody", "soulful", "passionate", "distorted"] | 4 | GWcTd6XrQj4 | 1730 | |
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 | |
Tracy Chapman and Bruce Springsteen - My Hometown (Live 2004) | The low quality recording features a live performance of a folk rock song that consists of harmonizing vocals singing over shimmering hi hats, snappy rimshots, groovy bass guitar and acoustic rhythm guitar, followed by some crowd claps. It sounds messy, muddy and distorted, but still emotional and passionate too. | 2010-09-19T11:10:04Z | Tracy Chapman Online | ♥ Subscribe our newsletter ► https://www.about-tracy-chapman.net/newsletter/ ♥ ♥ Subscribe Tracy Chapman Youtube Channel ► http://www.youtube.com/tchapmanfan ♥ See also ► Fan website : http://www.about-tracy-chapman.net/ ► Facebook: https://www.facebook.com/tracychapmanonline ► Instagram https://instagram.com/tracychapmanonline ► Twitter: https://twitter.com/tchapmanonline Order Tracy Chapman’s "Greatest Hits" on iTunes http://apple.co/1RtSdDu | Amazon: http://hyperurl.co/TC-GH Tracy Chapman and Bruce Springsteen perform "My hometown" in 2004. Low Quality rare video. | ["Singing", "Music", "/t/dd00003"] | ["low quality", "live performance", "folk rock", "distorted", "shimmering hi hats", "harmonizing vocals", "groovy bass guitar", "acoustic rhythm guitar", "snappy rimshots", "crowd clapping", "messy", "muddy", "emotional", "passionate"] | 4 | aPQTrv2B1sw | 3536 | |
Fatima Tuz Zahra Oyshee-De De pal Tule de - Live on RTV MUSIC STATION | The low quality recording features a live performance of a traditional pop song and it consists of an addictive female vocal singing over punchy kick and snare hits, groovy bass, electric guitar melody, strings melody and wooden percussion. There is a short snare roll, right before the bass drops. It sounds messy, a bit harsh, distorted, but also passionate, addictive and energetic. | 2015-11-15T15:01:18Z | Oyshee Express | Singer- Fatima Tuz zahra Oyshee Lyric & Tune: Abdur Rahman Boyati Produced by Khoshru Anchored by Liza Bass Guitar- Sohel Rana Flute: Kamrul Lead Guitar: Roman Keyboard: Nadim Pad: Sakib Percussion: Ujjol | ["Music of Asia", "Music", "Salsa music"] | ["live performance", "low quality", "traditional pop", "addictive female vocal", "punchy snare", "wooden percussions", "snare roll", "groovy bass", "string melody", "electric guitar melody", "punchy kick", "messy", "distorted", "harsh", "passionate", "addictive", "energetic"] | 4 | eISYX9koocM | 3855 |
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;