musiccaps_details (view)
11 rows where search matches "guitar", musiccaps_aspects contains "male singer", musiccaps_aspects contains "spirited" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- male singer · 11 ✖
- spirited · 11 ✖
- passionate 8
- guitar accompaniment 6
- medium tempo 6
- poor audio quality 5
- emotional 4
- groovy bass line 4
- bad audio quality 3
- exciting 3
- groovy music 3
- guitar rhythm 3
- live performance 3
- love song 3
- percussive bass line 3
- romantic 3
- adrenaline rush 2
- average audio quality 2
- backup singers 2
- cymbals crashing 2
- dance rhythm 2
- enthusiastic 2
- excitement 2
- folk music 2
- groovy rhythm 2
- inspiring 2
- live audience 2
- spirited singing 2
- strong bass line 2
- youthful 2
- …
musiccaps_names (array) 17 ✖
- Music 11
- Singing 4
- Song 3
- Independent music 2
- Maraca 2
- Pop music 2
- Rock music 2
- Afrobeat 1
- Didgeridoo 1
- Exciting music 1
- Flamenco 1
- Humming 1
- Progressive rock 1
- Psychedelic rock 1
- Sampler 1
- Vocal music 1
- Yell 1
youtube_published (date) 11 ✖
- 2007-07-25 1
- 2009-05-26 1
- 2009-12-21 1
- 2011-04-03 1
- 2011-12-04 1
- 2012-06-30 1
- 2013-01-27 1
- 2014-03-17 1
- 2015-03-08 1
- 2016-01-22 1
- 2016-07-13 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Flamenco en la calle. Cáceres | A male singer sings this spirited Latin vocal. The song is fast tempo with slick guitar strumming and percussive guitar accompaniment. The song is romantic and steeped in rich Latin classical music traditions. The song is about a Latin street musician playing folk music. The recording is of average quality. | 2016-01-22T12:08:16Z | Antonio Lara Arco | En pleno casco antiguo de la ciudad... | ["Singing", "Flamenco", "Music", "Song", "Vocal music"] | ["male singer", "latin singer", "average audio quality", "fast tempo", "groovy tempo", "fast guitar strumming", "guitar accompaniment", "groovy music", "romantic", "emotional", "passionate", "spirited", "passionate singing", "spirited singing", "flamenco guitar", "live performance", "street musician", "passionate music", "traditional latin music", "folk singer", "folk music"] | 1 | Bx726MYz6Uo | 1306 | |
Kwabena Kwabena - Odo Nkoa (Feat. Kofi B) | A male singer sings this passionately with backup singers in vocal harmony. The song is medium tempo with a steady drumming rhythm, various percussion, percussive bass line, guitar rhythm and keyboard harmony . The song is passionate and romantic with a cool dance groove. The song has poor audio quality. | 2011-04-03T16:51:56Z | NaaKwame | Kwabena Kwabena - Odo Nkoa (Feat. Kofi B) Album: Dabi | ["Singing", "Music", "Pop music", "Maraca"] | ["male singer", "backup singers", "african rhythms", "poor audio quality", "guitar rhythm", "xylophone", "vocal harmony", "groovy drumming rhythm", "percussive bass line", "various percussion hits", "medium tempo", "groovy dance rhythm", "pop hits", "dance hits", "love song", "passionate", "emotional", "spirited", "bad audio quality", "high pitched singing", "romantic"] | 1 | IPO79GrOYjg | 1904 | |
LG톤플러스 CF 국카스텐 하현우 'Sound change music video' 편 | A male singer sings this youthful k-pop song. The tempo is fast with a heartbeat rhythm, electro static sounds, electric buzz, followed by a fast paced drum rhythm, guitar accompaniment and a groovy bass line. The song is groovy and very youthful. | 2016-07-13T23:02:19Z | LG전자 Library | 복면가왕 음악대장 국카스텐 하현우가 들려주는 톤플러스의 블루투스 세계최초 24비트 놀라운 사운드를 뮤직비디오형식으로 표현 | ["Music", "Exciting music"] | ["heart beat melody", "male singer", "k-pop", "storm cloud noises", "electrostatic sounds", "buzz", "signal tempo", "drum roll", "enthusiastic drumming", "guitar strumming", "distorted amplified guitar", "percussive bass line", "pop", "pop dance rhythm", "pop dance song", "get tones", "korean rock band", "exciting", "building anticipation", "break the tension", "youthful", "exciting", "teen spirit", "enthusiastic", "spirited", "passionate"] | 1 | OhZmxS5DUKU | 2458 | |
Dale Maraca - ABS in Zumba Dance Class with ART ( Mo Betta ) | A male singer sings this Latin dance tune. The song is medium tempo with trumpets, latin percussions; medium drumming rhythm, keyboard harmony and guitar accompaniment. The song is exciting and groovy. The audio quality is poor and is played for work out exercise. | 2009-12-21T09:41:49Z | 19mobetta06 | Great song for ab work. Pull stomach in and use your hips in circular motion not so much work with the shoulders. www.CardioAssassin.com | ["Music", "Song", "Maraca"] | ["ambient room noise", "poor audio quality", "gym music", "zumba dance hits", "trumpets", "guitar accompaniment", "latin percussion", "strong bass line", "latin dance hits", "workout playlist", "passionate", "spirited", "adrenaline rush", "male singer", "latin dance music", "exercise class", "zumba music", "medium tempo", "groovy music"] | 1 | Sj5MQtqDw8Y | 2783 | |
Raga Style Improv in G: Sklar, Tower, & Montfort | The song is an instrumental with male vocalist chanting. The song is medium tempo with a didgeridoo playing percussively along with a guitar accompaniment. The song is meditative and has both aboriginal and Indian music influences . The audio quality is bad and it is a live audience performance. | 2007-07-25T02:30:56Z | Steve Sklar | Live video: Throat-singing (Steve Sklar); Didgeridoo (Alan Tower); Guitar (Matthew Montfort) Get better quality videos, mp3s, online throat-singing lessons, throat-and-overtone singing forum and lots more at http://khoomei.com | ["Didgeridoo", "Music"] | ["live music", "didgeridoo solo", "aboriginal music", "fusion music", "inspiring", "relaxing", "male singer", "raaga", "vocalist chanting", "poor audio quality", "indian music influences", "medium tempo", "guitar accompaniment", "folk music", "poignant", "spirited", "ancient", "meditational", "love music", "musical trio"] | 1 | bTuKGXDrqdQ | 3629 | |
Eloy - Eloy ... Same (Mülltonnencover) - Rare Progressive | A male singer sings this cool spirited melody. The song is medium tempo with a steady drumming rhythm, guitar playing lead, guitar strumming, strong bass line and various percussion hits. The song is exciting and energetic. The song has poor audio quality. | 2009-05-26T06:56:15Z | SirHenryII | Eloy - Eloy ... Same (Mülltonnencover) - Rare Progressive | ["Music", "Psychedelic rock", "Rock music", "Progressive rock"] | ["male singer", "guitar rhythm", "percussive bass line", "medium tempo", "groovy rhythm", "old school music", "spirited singing", "retro pop music", "story telling", "steady drumming rhythm", "marching rhythm", "cymbals crashing", "snare hits", "enteric", "exciting", "positive cheerful", "spirited", "emotional", "vintage hits", "poor audio quality"] | 1 | ckOe-8qdaew | 3736 | |
robzn - Kill the sound boy feat. Karen Firlej | A male singer sings this reggae melody with a live audience. The song is medium tempo with a groovy drum rhythm, trumpet playing rhythmically, guitar playing accompaniment and a groovy bass line. The song is exciting and cheerful. The song is a modern reggae tune and played in both a live audience situation and studio recording quality. | 2015-03-08T15:21:56Z | Das Octagon | Luiggis Finest Kill the sound boy feat. Karen Firlej Karen: https://www.facebook.com/pages/Karen-Firlej/179074595612477 robzn: https://www.facebook.com/robznoffiziellergehtnicht http://robznoffiziell.de/ vrob: https://www.facebook.com/vroboffiziellergehtnicht Luiggis Finest: https://soundcloud.com/luiggisfinest/luiggis-finest-hip-hop-reggaeneration | ["Afrobeat", "Music"] | ["reggae music", "live recording", "reggae band", "exciting", "energetic", "dance rhythm", "spirited", "beach party", "dance club", "dance mix", "excitement", "groove to the music", "people dancing", "studio recording", "dj", "noisy crowds", "people cheering", "guitar playing rhythm", "trumpets play percussively", "steady drumming", "live audience", "live performance", "male singer", "people cheering", "dance rhythm", "groovy bass line"] | 1 | fWypK9RHJJI | 3955 | |
Nenjam Pesuthey Male Humming song | A male singer sings this soaring melody. The song is medium tempo with a guitar accompaniment, strong bass line and a violin accompaniment. The song quality is poor and badly deteriorated. The song is a romantic love song from a Tamil movie. | 2014-03-17T01:41:42Z | VENGADASSALAM K | Photo Add | ["Humming", "Music"] | ["male singer", "soaring vocals", "bad quality audio", "tamil love songs", "poor audio quality", "medium tempo", "emotional", "passionate", "madly in love", "longing for you", "tamil movie songs", "movie soundtrack", "guitar accompaniment", "violin accompaniment", "no percussion instruments", "romantic", "deteriorated audio quality", "humming", "buzzing", "romantic", "love song", "spirited", "passionate", "bollywood music", "strong bass line"] | 1 | k3A5xX8yfig | 4295 | |
Jakes List Jun 2012 Top 10 Independent Music Video Uploads | Male and female singers sing this vocal harmony. The song is medium tempo with a groovy bass-line, keyboard accompaniment, guitar rhythm and a steady drumming rhythm with clapping percussions. The song is exciting and groovy. The song is a classic pop hit cover with an average quality sound. | 2012-06-30T22:34:02Z | Jake Niall Foster | The top 10 music video uploads for the month of June 2012 (with a cut-off date of 22 Jun) for Independent and Unsigned artists. | ["Singing", "Music", "Independent music", "Pop music", "Song"] | ["male singer", "backup singers", "female singers", "clapping percussions", "groovy bass line", "medium tempo", "guitar accompaniment", "keybiard accompaniment", "song cover", "home studio", "average audio quality", "hissing vocals", "spirited", "passionate", "dance rhythm", "groovy rhythm", "life lessons", "motivational", "inspiring", "retro pop hits"] | 1 | lR8am4rK7qQ | 4395 | |
Los Mejores Gritos de Axl Rose/Best Cries Of Axl Rose [El Mejor Grito De La Historia] | A male rock singer sings this climatic solo with a long sustained note. The tempo is medium with strong rock drumming, guitar rhythm; guitar lead and a percussive bass line. The song is hard rock with a lot of spirit and excitement. The audio quality is bad with a lot of ambient crowd noises. | 2013-01-27T02:36:43Z | M. Adonis Ortiz | Like Please: http://www.facebook.com/ILoveGunsNRoses1 Únete/Me Gusta Por Favor: http://www.facebook.com/ILoveGunsNRoses1 Lista de gritos de Axl Rose LIVE. Una maravilla de 4 octavas: Axl Rose. Un bajo-barítono que se empuja hacia la 5ª octava. Algunos dicen que Axl suena como una guitarra, y tiene razón! No es un cantante melódico pero hace el trabajo! 01.El pasaje grave hacia el final de ¨Sweet child o' mine¨, la nota más baja es F#2. 02.La armonía grave en el comienzo de ¨Paradise City¨, también F#2. 03.Un sólido D#2 en ¨You ain´t the first¨. 04.La versión en vivo tiene dos D#2 :s. 05.C#2 desde ¨Shackler´s revenge¨ en Chinese Democracy (Que bueno que Axl Por fin lo terminó). 06.Puede Axl bajar más? El está hablando en la parte inferior de su segunda octava acá y canta un C#2 (una vez más) al final del Rockumental de MTV. 07.Axl se desliza hacia abajo para un C2 tambaleante, pero sostenido, al final de ¨Ain´t going down¨ (demo). 08.Un lindo B1 de ¨Don´t cry¨. 09.El B1 también está en esta conocida canción, ¨November rain¨ (¿Voz de fritura?) 10.Esto también suena como B1, una armonía baja (separada de la voz principal) de ¨There was a time¨. 11.La nota más baja de Axl, A1, de ¨Get in the ring con un A2¨. La armonia tiene una línea en B1, una línea en D2, una en A1 y una línea más en B1, luego las repite. 12.Hora de ir hacia arriba. Un C#5 de ¨Paradise City¨. 13.El final clásico de ¨Sweet Child o' mine¨ donde Axl toca D#5 varias veces :s y también un corto E5. 14.D#5 con trinos de ¨Welcome to the jungle¨. 15.Un D#5 de ¨Anything goes¨. 16.F5 de ¨You could be mine¨. 17.Misma nota, pero en vivo. 18.Cantando hasta F#5! y luego manteniendo esa nota, en ¨There was a time¨. Su nota más alta cantada, esto debe ser duro para él en los conciertos. 19.Gran F#5 de ¨I.R.S¨. 20.Un G5 de una versión en vivo de ¨Welcome to the jungle¨. 21.G5 en ¨Chinese democracy¨. 22.Linda cadenza hasta G#5 de ¨Scraped¨ con una armonía de C#2 abajo. 23.Manteniendo un G#5 junto con Sebastian Bach (que tenía y tiene excelent… | ["Singing", "Music", "Rock music", "Yell"] | ["live performance", "bad audio quality", "singing long notes", "rock singer", "male singer", "crowds cheering", "rock music", "rock drumming rhythm", "cymbals crashing", "live audience", "ambient crowd noises", "groovy bass line", "guitar rhythm", "g]adrenaline rush", "lifetime experience", "groovy music", "excitement", "enthusiastic", "adrenaline rush", "passionate", "spirited", "retro rock hits"] | 1 | pHC25Ia8Dxo | 4694 | |
Teddy Sampler 2011.mp4 | A male singer sings this passionate melody. The song is medium tempo with an amplified guitar playing a distant rhythm with a percussive bass line. The song has ambient noises like rain pattering down, thunder rumble sounds and ambient noise. The sound quality is poor with hissing tones. The song is an amateur metal music video. | 2011-12-04T15:25:59Z | agnvik26 | What i managed to do this year. Not good. Hope for better times next year cause this is just laughable, haha! Thx for watching guys, i love all of you who inspires me and like my tricks, thx to you all! | ["Sampler", "Music", "Independent music"] | ["male singer", "bad audio quality", "ambient noises", "rumbling tones", "amateur music video", "no percussions", "thunder noise", "lightning", "guitar accompaniment", "groovy bass line", "rain sounds", "emotional metal song", "angst", "love song", "passionate", "disturbed mind", "hurt", "youthful", "spirited"] | 1 | tEdeb9eSKDI | 5018 |
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;