musiccaps_details (view)
2 rows where musiccaps_aspects contains "hurt" and musiccaps_aspects contains "medium tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- hurt · 2 ✖
- medium tempo · 2 ✖
- amateur piano player 1
- amateur piano playing 1
- animated show music 1
- bitter 1
- blues 1
- blues-rock 1
- blues-rockvigorous electric guitar 1
- breakup 1
- carefree music 1
- cartoon violence 1
- cheerful piano play 1
- crashing sounds 1
- crunching sounds 1
- depressed 1
- emotional 1
- groovy bass line 1
- heart break 1
- injury 1
- intense drumming 1
- jittery piano playing 1
- lonely 1
- male singer 1
- mangled noises 1
- metal clanging tones 1
- movie soundtrack 1
- piano accompaniment 1
- poignant 1
- rock 1
- sad 1
- synthesiser arrangement 1
- tv show tune 1
- vigorous electric guitar riff 1
- violence 1
- violent background music 1
- violent tv show 1
- western classical music 1
musiccaps_names (array) 4 ✖
- Music 2
- Blues 1
- Breaking 1
- Inside, large room or hall 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Joe Bonamassa - "Blues of Desperation" - Official Music Video | A male vocalist sings this emphatic rock. The tempo is medium with vigorous electric guitar, synthesiser arrangement, groovy bass line and intense drumming. The vocals are soft ,sad, lonely, poignant, mellow, and melodic in contrast to the intense instrumentation. This song is Blues-Rock. | 2016-08-01T14:41:20Z | JoeBonamassaTV | ► STREAM JOE NOW: https://jbonamassa.com/streaming/ ► FREE ALBUM DOWNLOAD - http://goo.gl/9oI018 ● Official Tickets ● http://jbonamassa.com/tour-dates/ ● Official Social Links ● https://www.facebook.com/JoeBonamassa https://twitter.com/jbonamassa https://instagram.com/joebonamassa/ https://www.pinterest.com/jbonamassa/ ● Official Merchandise ● http://shop.jbonamassa.com/ | ["Blues", "Music"] | ["male singer", "medium tempo", "sad", "depressed", "heart break", "blues-rock", "vigorous electric guitar riff", "breakup", "hurt", "poignant", "bitter", "lonely", "blues-rockvigorous electric guitar", "synthesiser arrangement", "blues", "rock", "groovy bass line", "intense drumming"] | 7 | 6JJMlY3Go9s | 743 | |
[SFM FNAF] #Mangle & Foxy Plushie | The song is an instrumental piece. The song is medium tempo with a casual piano accompaniment which is cheerful and jittery in style, along with violent sounds of a crash, crushing tones, metal clanging and rubber twisting sounds. The song is cheerful and at the same time has violent tones of injury and accident superimposed in it. The song is a background effect for an animated show which is violent in nature. | 2016-03-26T23:32:20Z | FiveNight | ►Happy Easter :) ►Facebook: https://www.facebook.com/SFMFiveNight ►NCS the best music channel: https://www.youtube.com/user/NoCopyrightSounds | ["Music", "Breaking", "Inside, large room or hall"] | ["piano accompaniment", "crashing sounds", "animated show music", "violent tv show", "tv show tune", "jittery piano playing", "amateur piano player", "western classical music", "metal clanging tones", "crunching sounds", "injury", "hurt", "violence", "carefree music", "movie soundtrack", "cartoon violence", "emotional", "cheerful piano play", "medium tempo", "amateur piano playing", "violent background music", "mangled noises"] | 1 | Lq0LMMZfHCU | 2224 |
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;