musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "energetic", musiccaps_aspects contains "instrumental music" and musiccaps_aspects contains "live audience"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- energetic · 2 ✖
- exciting 2
- instrumental music · 2 ✖
- live audience · 2 ✖
- percussive bass line 2
- adrenaline rush 1
- ambient noises 1
- cymbals crashing 1
- dance rhythm 1
- electric guitar lead 1
- electric guitar riff 1
- entertaining 1
- funk jazz 1
- fusion music 1
- groovy drumming rhythm 1
- groovy music 1
- groovy rhythm 1
- guitar band 1
- guitar lead 1
- guitar strumming 1
- hindustani music 1
- improvisational 1
- improvisational music 1
- indian classical music 1
- jazz funk 1
- live band 1
- live performance 1
- medium fast tempo 1
- passionate 1
- poor audio quality 1
- smooth jazz 1
- spirited 1
- tabla percussions 1
musiccaps_names (array) 8 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
喃語 LIVE @札幌SOUND CRUE 2015/11/03 | The song is an instrumental. The song is medium tempo with a groovy drumming rhythm, percussive bass line and cool electric guitar riff played repeatedly. The song is exciting and energetic. The song has smooth jazz or funk jazz roots. | 2015-11-18T13:14:34Z | YASASHIIKIMOCHI RECORDS | 2015/11/03@札幌SOUND CRUE 忍者ワールド 0:00 https://youtu.be/BTE_WG2fiT8 山の巨大ゴリラ村を荒らす 05:02 https://youtu.be/qPwVkHXKdsI 清らかな生き物 09:10 https://youtu.be/guj0H2Pdvcg 映像撮影・編集 つるりん こんちゃん てるてる 音声編集 北川 昭行 (Hello Micro Computer) 喃語(nango) http://naango.tumblr.com/ Twitter https://twitter.com/naaango Soundcloud http://soundcloud.com/nang0 Facebook https://www.facebook.com/naaaango | ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Psychedelic rock", "Progressive rock"] | ["electric guitar lead", "live performance", "live band", "guitar band", "exciting", "instrumental music", "adrenaline rush", "energetic", "electric guitar riff", "live audience", "entertaining", "funk jazz", "groovy drumming rhythm", "percussive bass line", "cymbals crashing", "improvisational music", "jazz funk", "smooth jazz", "groovy music", "medium fast tempo"] | 1 | Nqb7nw58q08 | 2370 | |
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;