musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "inspiring" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_aspects (array) 87 ✖
- inspiring · 5 ✖
- passionate · 5 ✖
- guitar accompaniment 4
- emotional 3
- groovy bass line 3
- medium tempo 3
- spirited 3
- female singer 2
- groovy music 2
- motivational 2
- people dancing 2
- song cover 2
- steady drumming rhythm 2
- amateur singing 1
- average audio quality 1
- backup singers 1
- beachside party 1
- booming bass line 1
- brass band harmony 1
- cameras clicking 1
- caribbean music style 1
- caribbean percussions rhythm 1
- clapping percussions 1
- classic reverse hits 1
- crowds clapping 1
- crowds whistling 1
- dance club 1
- dance groove 1
- dance mix 1
- dance music 1
- dance rhythm 1
- dealing with depression 1
- discotheque 1
- electric guitar player 1
- encouraging crowd 1
- enjoy life 1
- euro pop 1
- excited 1
- exciting 1
- female singers 1
- flute countermelody 1
- groovy 1
- groovy rhythm 1
- guitar demonstration 1
- guitar lessons online 1
- guitar licks 1
- guitar solo 1
- guitarist 1
- hardship 1
- hissing vocals 1
- home studio 1
- home video 1
- instrumental music 1
- keybiard accompaniment 1
- keyboard harmony 1
- life is a dance 1
- life is good 1
- life lessons 1
- live performance 1
- loneliness 1
- male rapper 1
- male singer 1
- medium fast tempo 1
- medium fats tempo 1
- melancholic 1
- music concert 1
- poignant 1
- poor audio quality 1
- positive 1
- purposeful 1
- reggae groove 1
- reggae hits 1
- retro pop hits 1
- riffs 1
- romantic 1
- russian hit songs 1
- russian rap music 1
- soloist 1
- spirited singing 1
- story telling 1
- strong bass line 1
- strumming rhythm 1
- tropical dance hit 1
- trumpets blaring 1
- underground music 1
- youthful 1
- youtube music video 1
musiccaps_names (array) 15 ✖
- Music 5
- /t/dd00003 1
- Applause 1
- Crackle 1
- Guitar 1
- Hip hop music 1
- Independent music 1
- Inside, small room 1
- Musical instrument 1
- Plucked string instrument 1
- Pop music 1
- Rapping 1
- Reverberation 1
- Singing 1
- Song 1
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 | |
Bill Lawrence "Wilde" L-45 pickups | The song is an instrumental. The song is medium tempo with an electric guitar playing guitar riffs with a nice low end; The audio quality is average. The song is passionate and exciting. | 2010-06-03T01:03:09Z | Flagrant Potato | Playing starts at 2:25. Quick sound test of the Bill and Becky "Wilde" L-45 strat pickups in my Warmoth guitar. Alnico V magnets, dual rail pole pieces (flat). Guitar is 1pc alder body with a goncalo alves neck and ebony fretboard. Guitar is plugged straight into a Yamaha Fifty (G50) 410 combo and was recorded with an active dual-ribbon mic. | ["Reverberation", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Inside, small room"] | ["electric guitar player", "guitarist", "riffs", "guitar licks", "passionate", "exciting", "guitar lessons online", "soloist", "youtube music video", "guitar demonstration", "excited", "positive", "medium fast tempo", "groovy music", "inspiring", "inspiring", "guitar solo", "medium fats tempo", "strumming rhythm", "groovy", "booming bass line", "instrumental music"] | 1 | Ta0GmXPnGWk | 2847 | |
Gunshot - ROCMA ( Feat. XEptional ) | A male rapper sings this groovy melody. The song is medium tempo with a steady drumming rhythm, groovy bass line, a melancholic flute countermelody, keyboard harmony and guitar accompaniment. The song is exciting and passionate. The song is a modern Russian rap song with a story telling nature. | 2014-04-05T21:46:22Z | Mehdi Rafale | Produced and Mixed by XEptional https://www.facebook.com/Gunshot.officiel https://www.facebook.com/thexeptionalpage | ["Music", "Rapping", "Hip hop music"] | ["male rapper", "russian rap music", "medium tempo", "purposeful", "inspiring", "underground music", "youthful", "discotheque", "hardship", "flute countermelody", "guitar accompaniment", "groovy bass line", "steady drumming rhythm", "steady drumming rhythm", "keyboard harmony", "poignant", "melancholic", "emotional", "russian hit songs", "euro pop", "groovy music", "dance music", "dance mix", "dance club", "people dancing", "passionate", "story telling"] | 1 | TakkuFZJsis | 2849 | |
singing sandra crying | A female singer sings this passionate melody. The song is medium tempo with steady drumming rhythm, groovy bass line, Caribbean percussion, guitar accompaniment and a brass band playing percussively. The song is emotional and spirited. The song is a classic renege hit. | 2008-09-26T00:01:17Z | ANDY WONG KEE | music | ["Music", "/t/dd00003"] | ["female singer", "spirited singing", "reggae hits", "tropical dance hit", "caribbean music style", "trumpets blaring", "caribbean percussions rhythm", "medium tempo", "guitar accompaniment", "groovy bass line", "steady drumming rhythm", "brass band harmony", "emotional", "passionate", "reggae groove", "classic reverse hits", "spirited", "dance groove", "beachside party", "people dancing", "inspiring", "life is good", "enjoy life", "life is a dance"] | 1 | XXBVsNt2Qr8 | 3192 | |
Jakes List Jun 2012 Top 10 Independent Music Video Uploads | Male and female singers sing this vocal harmony. The song is medium tempo with a groovy bass-line, keyboard accompaniment, guitar rhythm and a steady drumming rhythm with clapping percussions. The song is exciting and groovy. The song is a classic pop hit cover with an average quality sound. | 2012-06-30T22:34:02Z | Jake Niall Foster | The top 10 music video uploads for the month of June 2012 (with a cut-off date of 22 Jun) for Independent and Unsigned artists. | ["Singing", "Music", "Independent music", "Pop music", "Song"] | ["male singer", "backup singers", "female singers", "clapping percussions", "groovy bass line", "medium tempo", "guitar accompaniment", "keybiard accompaniment", "song cover", "home studio", "average audio quality", "hissing vocals", "spirited", "passionate", "dance rhythm", "groovy rhythm", "life lessons", "motivational", "inspiring", "retro pop hits"] | 1 | lR8am4rK7qQ | 4395 |
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;