musiccaps_details (view)
5 rows where musiccaps_aspects contains "home video", musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_aspects (array) 72 ✖
- home video · 5 ✖
- medium tempo · 5 ✖
- passionate · 5 ✖
- emotional 4
- instrumental music 4
- bad audio quality 3
- exciting 3
- poor audio quality 3
- guitar amplifier 2
- guitar solo 2
- no other instrumentation 2
- practice session 2
- romantic 2
- soloist 2
- spirited 2
- youtube music video 2
- adventure music 1
- adventurous 1
- amateur play 1
- ambient echoes 1
- bach 1
- bad audio recording 1
- blues influences 1
- blues lick 1
- bow 1
- cellist 1
- cello 1
- cello suite 1
- classical music 1
- deep 1
- drum lesson 1
- drum rhythm 1
- drum sticks 1
- echo tone 1
- energetic 1
- fingering technique 1
- great composers 1
- groovy 1
- guitar demo 1
- guitar lead 1
- guitar played accompaniment style 1
- guitar technique 1
- home music video 1
- learner 1
- legato playing 1
- live recording 1
- low pitched notes 1
- moody blues 1
- no harmony instruments 1
- no percussions 1
- nostalgic 1
- percussionist 1
- practice sessions 1
- recital 1
- sax cover 1
- sax tonguing 1
- saxophone lessons online 1
- silent practice 1
- solo guitar 1
- sound check 1
- soundboard 1
- steady rhythm 1
- strings 1
- studio session 1
- subtle bass line 1
- syncopated rhythms 1
- tenor sax 1
- tone generator 1
- tremolo effect 1
- various rhythms 1
- vibrato style 1
- western classical music 1
musiccaps_names (array) 14 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fender FSR Limited Edition Deluxe Reverb RI | A male guitarist plays a cool guitar like on an electric guitar. The song is medium tempo with a guitar solo with heavy a[echoes played though a guitar amplifier and no other instrumentation. The song is bluesy and passionate. The song is a casual blue slick played on a guitar. | 2012-05-09T06:39:38Z | Thomas Fargo | Testing the amp with Lollar P-90s | ["Reverberation", "Electric guitar", "Guitar", "Music", "Musical instrument"] | ["home video", "poor audio quality", "sound check", "deep", "emotional", "passionate", "blues influences", "instrumental music", "guitar solo", "tremolo effect", "guitar amplifier", "guitar lead", "echo tone", "solo guitar", "bad audio recording", "no other instrumentation", "guitar technique", "moody blues", "spirited", "passionate", "medium tempo", "blues lick"] | 1 | 6_zzu2KON6c | 768 | |
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 | |
CCB sax tenor hino 119 | The song is an instrumental. The song is medium tempo with a tenor saxophone playing a lilting melody in legato style. The song has no other instrumentation support. The audio quality is very poor. | 2010-01-07T21:22:33Z | Lucas Cerqueira | CCB sax tenor hino 119 | ["Brass instrument", "Saxophone"] | ["tenor sax", "amateur play", "legato playing", "poor audio quality", "saxophone lessons online", "recital", "vibrato style", "instrumental music", "no other instrumentation", "sax tonguing", "emotional", "romantic", "home video", "bad audio quality", "learner", "youtube music video", "sax cover", "passionate", "spirited", "classical music", "passionate", "no percussions", "medium tempo"] | 1 | m--xEFqqrLc | 4434 |
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;