musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "average audio quality" and musiccaps_aspects contains "male singer"
This data as json, CSV (advanced)
musiccaps_aspects (array) 69 ✖
- average audio quality · 4 ✖
- male singer · 4 ✖
- romantic 3
- emotional 2
- guitar accompaniment 2
- live performance 2
- medium tempo 2
- passionate 2
- spirited 2
- ambient room noise 1
- american country music 1
- backup singers 1
- bollywood hits 1
- bollywood music 1
- breakup song 1
- clapping percussions 1
- classic bollywood hits 1
- country folk musical folk singer 1
- country music band 1
- country music hits 1
- courtship song 1
- dance rhythm 1
- double bass 1
- fast guitar strumming 1
- fast tempo 1
- female singers 1
- flamenco guitar 1
- folk music 1
- folk singer 1
- gentle music 1
- groovy bass line 1
- groovy music 1
- groovy rhythm 1
- groovy tempo 1
- guitar band 1
- guitar rhythm 1
- guitars rhyme 1
- hindi song 1
- hissing vocals 1
- home studio 1
- indian percussions 1
- inspiring 1
- keybiard accompaniment 1
- latin singer 1
- life lessons 1
- lilting melody 1
- lilting voice 1
- mandolin 1
- motivational 1
- movie soundtrack 1
- nostalgic 1
- passionate music 1
- passionate singing 1
- retro bollywood super hits 1
- retro pop hits 1
- sad song 1
- sadness 1
- sitar 1
- slow tempo 1
- song cover 1
- spirited singing 1
- story telling 1
- street musician 1
- strong bass line 1
- tablas percussions 1
- traditional latin music 1
- tragedy 1
- ukulele accompaniment 1
- vocal echoes 1
musiccaps_names (array) 9 ✖
- Music 4
- Singing 2
- Song 2
- Flamenco 1
- Independent music 1
- Mandolin 1
- Pop music 1
- Traditional music 1
- Vocal music 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 | |
Country Poor and Country Proud - Bluegrass Brothers | A male singer sings this gentle country music melody. The song is slow tempo with banjo, mandolin and guitar accompaniment and a double bass playing the lower register harmony. The song is emotional and nostalgic. The song is a country music hit with an average audio quality. | 2009-03-07T02:47:45Z | BGRTV | This is an older clip of the Bluegrass Brothers during a show at Hoofer's Gospel Barn in LaGrange GA. The Bluegrass Brothers are a lot of fun to watch... | ["Music", "Mandolin"] | ["male singer", "country music band", "double bass", "mandolin", "american country music", "nostalgic", "story telling", "average audio quality", "live performance", "ambient room noise", "ukulele accompaniment", "guitars rhyme", "guitar band", "country folk musical folk singer", "slow tempo", "gentle music", "country music hits", "romantic", "emotional", "lilting melody"] | 1 | O0sDg-yLvlE | 2388 | |
Khilona - 6/15 - Bollywood Movie - Sanjeev Kumar, Jeetendra & Mumtaaz | A male Hindi singer sings this tragic romantic song. The song is medium tempo with a strong percussion line with tablas and other Indian percussion, strong bass line and a sitar or guitar playing accompaniment. The song is sad yet romantic. The audio quality is average. | 2009-11-10T05:22:39Z | Rajshri | "Khilona - 1970 Directed By : Chander Vohra Starring : Sanjeev Kumar, Mumtaaz, Jitendra, Jagdeep, Shatrughan Sinha, Durga Khote,Ramesh Deo,Shabnam,Chand Usmani, Bipin Gupta, Jayashree Music Director : Laxmikant Pyarelal Synopsis : Thakur Suraj Singh lives a wealthy lifestyle with his wife; three sons - Kishore, his wife Laxmi & two children Pappu and Laali; Vijaykamal, & Mohan; and an unmarried daughter, Radha. Kishore looks after the family business, while Vijaykamal is a renowned poet, and Mohan is studying law in the city. Vijaykamal is in love with Sapna, but she is forced to marry Bihari, and kills herself on the night of the marriage. Vijaykamal witnesses her death and loses his mind. The family decides to keep him under lock and key on the terrace of their house. Unable to admit Vijaykamal to a mental asylum, Suraj brings home a young courtisan, Chand, who he hopes will cure Vijaykamal, and she does succeed considerably, but is traumatized, sexually assaulted by Vijaykamal, and abused by the rest of the family. Mohan finds her very attractive and wants her for himself, so does Bihari. A pregnant Chand is again traumatized when Vijaykamal recovers, but is unable to recognize her. The rest of the family do not believe that the child she is carrying is Vijaykamal's, and want her to leave. The question remains, what can this woman, who has been used as a toy, do under these circumstances? Subscribe To Our Channel : http://bit.ly/SubscribeToRajshri Follow us on G+ http://plus.google.com/+rajshri Like us on Facebook - https://www.facebook.com/rajshri Follow us on Twitter - https://twitter.com/Rajshri Follow us on Pinterest - http://www.pinterest.com/rajshrivideos Visit Rajshri's Website - http://www.rajshri.com | ["Traditional music", "Music"] | ["bollywood music", "male singer", "medium tempo", "average audio quality", "bollywood hits", "tablas percussions", "sitar", "indian percussions", "movie soundtrack", "hindi song", "tragedy", "sad song", "breakup song", "sadness", "romantic", "courtship song", "vocal echoes", "lilting voice", "strong bass line", "guitar rhythm", "classic bollywood hits", "retro bollywood super hits"] | 1 | doHRurF8bf8 | 3813 | |
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 |
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;