musiccaps_details (view)
6 rows where musiccaps_aspects contains "home video", musiccaps_aspects contains "instrumental music" and musiccaps_aspects contains "poor audio quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 87 ✖
- home video · 6 ✖
- instrumental music · 6 ✖
- poor audio quality · 6 ✖
- medium tempo 5
- emotional 3
- no other instrumentation 3
- passionate 3
- guitar amplifier 2
- guitar solo 2
- hissing tones 2
- soloist 2
- spirited 2
- youtube music video 2
- aboriginal music 1
- adventure music 1
- adventurous 1
- amateur play 1
- ambient echoes 1
- ambient noises 1
- ambient room noise 1
- ambient street noise 1
- bad audio quality 1
- bad audio recording 1
- bamboo didgeridoo 1
- bell vibrations 1
- birds chirping 1
- blues influences 1
- blues lick 1
- breathing sounds 1
- calm 1
- church 1
- classical music 1
- dance groove 1
- dance rhythm 1
- deep 1
- deep hollow tones 1
- demonstration 1
- devotional 1
- different tones 1
- echo tone 1
- energetic 1
- exciting 1
- faith music 1
- female percussionist 1
- gong sounds 1
- groovy rhythm 1
- guitar demo 1
- guitar lead 1
- guitar played accompaniment style 1
- guitar technique 1
- healing 1
- increasing tempos 1
- latin percussions 1
- learner 1
- legato playing 1
- maracas playing percussion 1
- meditational 1
- meditative 1
- moody blues 1
- music artist 1
- music demo 1
- nature sounds 1
- no percussions 1
- overtones 1
- percussion styles 1
- percussive playing 1
- prayers 1
- recital 1
- religious 1
- romantic 1
- sax cover 1
- sax tonguing 1
- saxophone lessons online 1
- serene 1
- solo guitar 1
- solo instrument 1
- sound check 1
- spiritual 1
- subtle bass line 1
- temple 1
- temple bells 1
- tenor sax 1
- tone generator 1
- tremolo effect 1
- various tempos 1
- vibrato style 1
- wind instrument 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
Didgeridoo BAMBUS | The song is an instrumental. The tempo is medium with a bamboo didgeridoo being played percussively with no other instrumentation. The tone is deep and meditative in nature. The song is a demo play with poor audio quality. | 2009-02-16T21:42:45Z | didgyclausy | Soundsampel_BAMBUS_Eigenbau | ["Didgeridoo", "Music"] | ["bamboo didgeridoo", "poor audio quality", "soloist", "aboriginal music", "home video", "breathing sounds", "percussive playing", "deep hollow tones", "wind instrument", "no other instrumentation", "music demo", "instrumental music", "hissing tones", "ambient room noise", "meditative", "medium tempo"] | 1 | L5UDz2PJ9sk | 2151 | |
MARACAS II | The song is an instrumental. The tempo is varying with maracas being played percussively. The playing is energetic and exciting. The song is a home music video and probably a demonstration of Latin percussion styles. | 2008-06-06T19:51:39Z | Grace LASCANO GARRIDO | Ejercicios MARACAS | ["Music", "Maraca"] | ["maracas playing percussion", "female percussionist", "dance rhythm", "percussion styles", "demonstration", "music artist", "groovy rhythm", "home video", "poor audio quality", "various tempos", "latin percussions", "dance groove", "solo instrument", "instrumental music", "ambient noises", "hissing tones", "increasing tempos", "energetic"] | 1 | MwE7REVj8JQ | 2309 | |
Vercelli - Campana della vita - | The song track is instrumental. The tempo is medium with temple bells being played to create two distinct tones with long vibrations creating clear overtones. The soundtrack is calming and deeply religious. The audio track quality is poor with ambient environment noises. | 2007-06-25T19:40:04Z | Giovanni Ottone | Questa campana si trova in un giardino della Parrocchia di S.Pietro Apostolo a Vercelli... Fusa nel 2000 (Trebino) pesa 3600kg Nota nominale LA2 | ["Bell"] | ["temple bells", "different tones", "gong sounds", "prayers", "temple", "church", "faith music", "overtones", "ambient street noise", "birds chirping", "instrumental music", "medium tempo", "poor audio quality", "nature sounds", "calm", "serene", "bell vibrations", "healing", "spiritual", "religious", "meditational", "devotional", "home video"] | 1 | _Slo8QXYOp8 | 3472 | |
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;