musiccaps_details (view)
3 rows where musiccaps_aspects contains "exciting", musiccaps_aspects contains "home video" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_aspects (array) 48 ✖
- exciting · 3 ✖
- home video · 3 ✖
- medium tempo 3
- passionate · 3 ✖
- bad audio quality 2
- emotional 2
- instrumental music 2
- practice session 2
- soloist 2
- adventure music 1
- adventurous 1
- ambient echoes 1
- bach 1
- bow 1
- cellist 1
- cello 1
- cello suite 1
- drum lesson 1
- drum rhythm 1
- drum sticks 1
- energetic 1
- fingering technique 1
- great composers 1
- groovy 1
- guitar amplifier 1
- guitar demo 1
- guitar played accompaniment style 1
- guitar solo 1
- home music video 1
- live recording 1
- low pitched notes 1
- no harmony instruments 1
- nostalgic 1
- percussionist 1
- poor audio quality 1
- practice sessions 1
- romantic 1
- silent practice 1
- soundboard 1
- steady rhythm 1
- strings 1
- studio session 1
- subtle bass line 1
- syncopated rhythms 1
- tone generator 1
- various rhythms 1
- western classical music 1
- youtube music video 1
musiccaps_names (array) 12 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
J.S.Bach - Cello Suite No.1 - Prelude - Double Bass | The song is an instrumental. The tempo is medium with a cellist playing a JS Bach tune with exemplary skill in a rehearsal session. The song has bad audio quality. The song is a western classical music tune. | 2014-09-03T19:30:44Z | TESEO | J.S.Bach - Suite No.1 for Double Bass BWV 1007 - Prelude - Plays Francesco Tesei - New Fan Page - https://www.facebook.com/Teseoguitar - SUBSCRIBE! http://www.youtube.com/user/teseoguitar?sub_confirmation=1 | ["Cello", "Double bass", "Bowed string instrument"] | ["cello suite", "cello", "cellist", "home video", "emotional", "passionate", "romantic", "nostalgic", "instrumental music", "medium tempo", "bad audio quality", "western classical music", "bach", "practice session", "live recording", "exciting", "low pitched notes", "strings", "soundboard", "fingering technique", "bow", "studio session", "great composers", "soloist"] | 1 | B1ixRtiUJ-U | 1194 | |
1964 Fender Deluxe Reverb + 1999 Fender 52 Vintage Telecaster Part2 | The song is an instrumental. The song is medium tempo with a guitar playing solo accompaniment style, with a subtle bass line. The song is entertaining and passionate. The song audio quality is poor with a lot of ambient echoes. | 2010-03-17T17:54:45Z | GregsGuitars | 1964 Fender Deluxe Reverb is an original vintage amp - not Reissue. Tele has a Texas Special Pickup at the neck and a nocaster bridge pickup. Okko Diablo Custom made overdrive pedal with 3 channels www.gregorhilden.de | ["Reverberation", "Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["instrumental music", "poor audio quality", "guitar solo", "ambient echoes", "guitar played accompaniment style", "guitar amplifier", "tone generator", "subtle bass line", "home video", "youtube music video", "soloist", "guitar solo", "exciting", "adventurous", "guitar demo", "passionate", "medium tempo", "emotional", "adventure music"] | 1 | DUNOn71oGCw | 1482 | |
offworld percussion invader v3 practice pad | A percussionist plays various drum rhythms at a medium tempo. The tempo is me doom with no harmony instruments. The song is exciting and energetic. The audio quality is poor and sounds like a music tutorial for drummers. | 2011-02-06T21:21:49Z | Joseph Santana | my new pad. worth the 80 bucks feels just like a real drum. im playing an excersise called 12/8 from a drum corps that im auditioning for. no hating constructive criticism please sticks are promark dc50s | ["Wood block", "Percussion"] | ["percussionist", "drum sticks", "practice session", "exciting", "energetic", "passionate", "steady rhythm", "various rhythms", "home music video", "silent practice", "syncopated rhythms", "drum lesson", "home video", "practice sessions", "bad audio quality", "no harmony instruments", "drum rhythm", "groovy", "medium tempo"] | 1 | KxUcwQ5BEBk | 2132 |
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;