musiccaps_details (view)
3 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "guitar strumming" and musiccaps_aspects contains "percussive bass line"
This data as json, CSV (advanced)
musiccaps_aspects (array) 47 ✖
- energetic · 3 ✖
- guitar strumming · 3 ✖
- percussive bass line · 3 ✖
- ambient noises 2
- guitar lead 2
- instrumental music 2
- passionate 2
- spirited 2
- amateur band 1
- backup singers 1
- bad audio quality 1
- bad recording 1
- chaotic harmony 1
- college music festival 1
- country guitar band 1
- country singer 1
- country super hits 1
- crooning vocals 1
- cymbals crashing 1
- dance rhythm 1
- dissonant harmonies 1
- exciting 1
- fast tempo 1
- fusion music 1
- groovy music 1
- groovy rhythm 1
- guitar leads 1
- heavy metal drumming 1
- hindustani music 1
- improvisational 1
- indian classical music 1
- keyboard accompaniment 1
- live audience 1
- live band 1
- love song 1
- madly in love 1
- male singer 1
- medium tempo 1
- metal band 1
- modern country love songs 1
- poor audio quality 1
- romantic 1
- tabla percussions 1
- teen spirit 1
- very poor audio quality 1
- vocal harmony 1
- youthful 1
musiccaps_names (array) 7 ✖
- Music 3
- Burst, pop 1
- Country 1
- Exciting music 1
- Flamenco 1
- Happy music 1
- Rock and roll 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
'Kiss a Girl Sessions' Video Keith Urban AOL Music | A male country singer sings this passionate melody with backup singers in vocal harmony. The song is medium tempo with a strong drumming rhythm, guitar accompaniment, guitar lead, percussive bass line and percussion hits. The song is passionate and romantic. The song has bad audio quality. | 2009-04-16T00:03:13Z | Nick Czapiewski | http://nickwinch.blogspot.com/ Keith Urban singing Kiss a Girl on AOL music. Make sure you pick up "Defying Gravity" in stores and online now!! ***NO INFRINGEMENT INTENDED*** just spreading the good news of Keith Urban | ["Music", "Happy music", "Exciting music"] | ["male singer", "country singer", "backup singers", "vocal harmony", "crooning vocals", "medium tempo", "guitar leads", "guitar strumming", "percussive bass line", "keyboard accompaniment", "energetic", "passionate", "love song", "romantic", "country guitar band", "modern country love songs", "country super hits", "madly in love", "bad audio quality"] | 1 | 9uToez74x_M | 1048 | |
CloseHead - Heart Of Pop (percayalah) @SMAN 11 Jakarta | The song is instrumental.The tempo is fast with a strong metal drumming rhythm, groovy bass line, cymbals crashing, guitar lead and guitar rhythm. The song is chaotic and energetic. The song has very poor audio quality. | 2014-02-19T18:36:24Z | ricky t julianto | Closehead - Heart Of Pop (percayalah) Event NEOVECTOR @SMAN 11 Jakarta Video Rec & Editing : Ricky T Julianto | ["Music", "Burst, pop", "Rock and roll"] | ["live band", "very poor audio quality", "ambient noises", "chaotic harmony", "bad recording", "percussive bass line", "metal band", "college music festival", "heavy metal drumming", "guitar strumming", "guitar lead", "cymbals crashing", "chaotic harmony", "dissonant harmonies", "groovy music", "amateur band", "youthful", "energetic", "spirited", "teen spirit", "instrumental music", "fast tempo"] | 1 | DaeJYtWgcoI | 1497 | |
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;