musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "dance rhythm", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "spirited" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 65 ✖
- dance rhythm · 4 ✖
- passionate · 4 ✖
- spirited · 4 ✖
- groovy rhythm 3
- medium tempo 3
- emotional 2
- guitar strumming 2
- instrumental music 2
- poor audio quality 2
- ambient noises 1
- average audio quality 1
- backup singers 1
- bad audio quality 1
- banjo 1
- cheerful 1
- child performers 1
- clapping percussions 1
- country bluegrass 1
- country dance music 1
- country folk music 1
- country music 1
- dance groove 1
- energetic 1
- entertaining 1
- exciting 1
- female singers 1
- fiddlers 1
- fusion music 1
- groovy bass line 1
- guiro percussions 1
- guitar accompaniment 1
- guitar lead 1
- guitar rhythm 1
- hindustani music 1
- hissing vocals 1
- home studio 1
- improvisational 1
- indian classical music 1
- inspiring 1
- keybiard accompaniment 1
- latin dance band 1
- latin folk singer 1
- latin percussions 1
- life lessons 1
- live audience 1
- live performance 1
- male latin singer 1
- male singer 1
- motivational 1
- never give up 1
- people dancing 1
- percussive bass line 1
- piano accompaniment 1
- positive 1
- retro pop hits 1
- romantic 1
- soaring vocals 1
- song cover 1
- story telling 1
- tabla percussions 1
- the country life 1
- the wild west 1
- traditional music 1
- violinists 1
- walking bass line 1
musiccaps_names (array) 13 ✖
- Music 4
- Country 2
- Banjo 1
- Bowed string instrument 1
- Flamenco 1
- Independent music 1
- Music of Africa 1
- Musical instrument 1
- Plucked string instrument 1
- Pop music 1
- Singing 1
- Ska 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
sleepy man banjo boys vs mountain rhythm | The song is instrumental. The tempo is medium with a prolific fiddler playing melody and a banjo and guitar accompaniment. The song is adventurous and exciting. The song is a classic country instrumental. The song has poor audio quality. | 2011-05-15T21:20:57Z | RubenProducciones | blatle of banjos. read the description: friends can go to this link and give it a like, would help me a lot to back up videos like this :) http://www.youtube.com/watch?v=g1I7seXs6O4 | ["Banjo", "Country", "Music", "Musical instrument", "Plucked string instrument", "Bowed string instrument"] | ["violinists", "country music", "fiddlers", "child performers", "instrumental music", "guitar strumming", "country folk music", "live performance", "groovy rhythm", "country dance music", "the country life", "the wild west", "dance rhythm", "passionate", "emotional", "spirited", "never give up", "cheerful", "positive", "traditional music", "bad audio quality", "country bluegrass", "banjo", "medium tempo"] | 1 | O84YjlJ_Qw4 | 2402 | |
el grillo enamorado | A male singer sings this passionate melody. The song is medium tempo with Latin percussion, guiro percussions, guitar rhythm, piano accompaniment and guitar rhythm. The song is romantic and spirited. The song is a Latin dance song with poor audio quality. | 2008-09-05T17:39:10Z | Piko | el grillo enamorado con imagenes de grillos | ["Music of Africa", "Music", "Ska"] | ["male latin singer", "poor audio quality", "latin percussions", "people dancing", "latin dance band", "dance groove", "emotional", "soaring vocals", "latin folk singer", "walking bass line", "piano accompaniment", "dance rhythm", "entertaining", "romantic", "story telling", "passionate", "spirited", "guiro percussions", "medium tempo", "guitar rhythm"] | 1 | 2cxvYC9QZac | 391 | |
Anil Shahi - Maya Mantra (Instrumental) | The song is an instrumental. The song is medium tempo with a percussive tabla rhythm, groovy bass line and a guitar strumming rhythm and playing lead. The song is Indian classical fusion with a poor audio quality. | 2013-02-23T19:05:58Z | NepaliLyricsChords | http://NepaliLyricsChords.com Anil Shahi performing Maya Mantra (Instrumental) in Thamel Square Grand Opening Program Program Name: Thamel Square Grand Opening Location: JP Road, Thamel. Kathmandu Facebook Page (Thamel Square): https://www.facebook.com/ThamelSquare Facebook Page (Nepali Lyrics Chords): http://www.facebook.com/Golomech | ["Country", "Flamenco", "Music"] | ["indian classical music", "hindustani music", "improvisational", "energetic", "exciting", "passionate", "spirited", "live audience", "ambient noises", "dance rhythm", "guitar lead", "poor audio quality", "poor audio quality", "tabla percussions", "groovy rhythm", "guitar strumming", "instrumental music", "percussive bass line", "fusion music"] | 1 | TWm_2QncYXg | 2841 |
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;