musiccaps_details (view)
6 rows where musiccaps_aspects contains "home video" and musiccaps_aspects contains "spirited"
This data as json, CSV (advanced)
musiccaps_aspects (array) 96 ✖
- home video · 6 ✖
- spirited · 6 ✖
- emotional 4
- energetic 3
- medium tempo 3
- no other instrumentation 3
- passionate 3
- poor audio quality 3
- fast tempo 2
- guitar technique 2
- instrumental 2
- instrumental music 2
- no percussions 2
- romantic 2
- acoustic steel drum 1
- african percussion 1
- amateur play 1
- amateur singing 1
- animated 1
- bad audio quality 1
- bad audio recording 1
- beeping 1
- blues influences 1
- blues lick 1
- boisterous 1
- busy 1
- buzzing 1
- cameras clicking 1
- classical music 1
- clicking sound 1
- crowds clapping 1
- crowds whistling 1
- dealing with depression 1
- deep 1
- echo tone 1
- electric guitar lead 1
- electronic music 1
- encouraging crowd 1
- engaging 1
- enthusiastic 1
- female singer 1
- groovy 1
- guitar a 1
- guitar accompaniment 1
- guitar amplifier 1
- guitar lead 1
- guitar solo 1
- gunshots 1
- inspiring 1
- learner 1
- legato playing 1
- live performance 1
- lively keyboard accompaniment 1
- loneliness 1
- loud 1
- moody blues 1
- motivational 1
- muffled audio 1
- music concert 1
- noisy 1
- note bending 1
- pannist 1
- phone ringing 1
- playing rhythm guitar 1
- pleasant sounds 1
- plification 1
- poor quality video 1
- recital 1
- recycled instrument 1
- resounding melody 1
- rhythmic 1
- sax cover 1
- sax tonguing 1
- saxophone lessons online 1
- scratching sound 1
- simple harmony 1
- solo guitar 1
- solo guitarist 1
- soloist 1
- song cover 1
- sound check 1
- stainless steel instrument 1
- steel drums 1
- steel pan 1
- strong bass line 1
- synthesiser arrangement 1
- tenor sax 1
- tremolo effect 1
- upbeat 1
- vibrant 1
- vibrato style 1
- video game music 1
- whirring 1
- whirring sounds 1
- youthful 1
- youtube music video 1
musiccaps_names (array) 13 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Alizee - Sound Of Silence, Moscow, 18-05-2008 | A female singer sings this live cover version of a famous song. The song is medium tempo with guitar accompaniment, crowds cheering and whistling and cameras clicking. The song has a poor audio quality and has a lot of ambient crowd noises, | 2008-05-24T21:54:38Z | mazarakis | Alizee - Sound Of Silence, Moscow, 18-05-2008 thanks to Didevil, ikm, pavel zubarev links to big files is here http://alizeeforum.fastbb.ru/?1-0-0-00001519-000-0-0#028 http://alizeeforum.fastbb.ru/?1-0-0-00001519-000-0-0#029.001 | ["Applause", "Music", "Crackle"] | ["female singer", "live performance", "song cover", "romantic", "loneliness", "dealing with depression", "crowds whistling", "crowds clapping", "poor audio quality", "song cover", "guitar accompaniment", "encouraging crowd", "emotional", "spirited", "passionate", "inspiring", "motivational", "amateur singing", "strong bass line", "home video", "music concert", "cameras clicking"] | 1 | 69oU6LfyQ_4 | 731 | |
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 | |
ギター レスポールを弾いてみた | The song is an instrumental guitar solo. The song tempo is medium with a racy electric guitar solo with a show of technique of note bending, tremolo and playing rhythmically. The song is home video and an average quality recording. | 2013-05-08T08:11:45Z | RDRGuitarBass | エレキギター RDRを弾いてみた | ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Distortion"] | ["electric guitar lead", "note bending", "playing rhythm guitar", "solo guitarist", "soloist", "no other instrumentation", "no percussions", "home video", "poor quality video", "guitar technique", "guitar a", "plification", "medium tempo", "spirited", "emotional", "youthful", "groovy", "energetic"] | 1 | 7V0G65FK2VQ | 850 | |
"Fanfare" - Hang Drum Solo by Dante Bucci | This song is an instrumental. The tempo is fast with a lively keyboard harmony and rhythmic steel pan . It is minimal and rhythmic. The harmony is simple , straight and the steel pan adds an interesting layer to it. The music is engaging, interesting, energetic, spirited and melodic. | 2008-08-13T16:11:38Z | Dante Bucci | This is a solo acoustic version of "Fanfare" performed on the HandPan (PANArt Hang). Dm Pentatonic Scale: (D) A C D F G A C F major Pentatonic Scale: (F) A Bb C E F A Bb C Copyright 2008 Dante Bucci UFOTunes/ASCAP. http://itunes.dantebucci.com http://facebook.dantebucci.com ~~~~~~~~~~~~~~~~~~~~~~~ If you want a HandPan: The makers of the "Hang" are no longer creating a musical instrument. PANArt is now focusing on creating a tool for meditation that does not follow the conventions of traditional musical notes. If you would like to purchase a hand-pan, I would suggest you look into one of the several other instrument makers who are creating very high-quality instruments. Websites for other Hand-Pan makers: www.spacedrum.fr www.bellart.es www.pantheonsteel.com www.balisteelpan.com www.caisa-music.com | ["Music", "Steelpan"] | ["instrumental", "fast tempo", "pleasant sounds", "simple harmony", "energetic", "spirited", "vibrant", "engaging", "steel drums", "steel pan", "rhythmic", "resounding melody", "african percussion", "pannist", "lively keyboard accompaniment", "home video", "stainless steel instrument", "recycled instrument", "acoustic steel drum"] | 7 | UNJswfXKJ3s | 2909 | |
Disney Dancing and Singing Donald Duck (Solo) | This song is an instrumental. The tempo is fast with electronic instrumentation and sounds. There is a vigorous keyboard harmony along with sounds of gunshots, clicking, whirring, beeping, phone ring and scratching. The music is busy, animated and boisterous. The audio quality is inferior and muddled, making it difficult to hear the finer elements. | 2009-02-28T11:39:55Z | xiaohwee85 | 3 x great songs from Daffy 3 x AA battery operated | ["Music", "Synthetic singing"] | ["instrumental", "fast tempo", "loud", "busy", "boisterous", "beeping", "whirring", "noisy", "scratching sound", "video game music", "upbeat", "energetic", "enthusiastic", "electronic music", "clicking sound", "animated", "synthesiser arrangement", "muffled audio", "home video", "whirring sounds", "gunshots", "buzzing", "phone ringing", "spirited", "energetic"] | 7 | XjoRxeEyjz4 | 3217 | |
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;