musiccaps_details (view)
4 rows where musiccaps_aspects contains "electric guitar strumming"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| C minor rock power ballad guitar backing track | Here we have a powerful rock ballad instrumental in a minor key. The guitar is grungy and overdriven, and the piano is clean and plays the same chords as the guitar at the same time. | 2012-05-13T21:33:38Z | Iain MacLeod | Hey guys! Sorry I haven't uploaded any tracks in a while. I made this one today and I hope you enjoy playing over it as much as I did :) Thanks for all the amazing support so far! Happy shreddin'! | ["Electric guitar", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["rock music", "piano", "electric guitar strumming", "minor key", "rock power ballad", "ballad", "grungy electric guitar strumming", "overdrive"] | 3 | 4M0njWKFsME | 560 | |
| Nukeateen - Face Up (Official Video, 1998 album Ozone - 90's Indie Rock / Grunge Band) | The clip features the tone of an alarm bell beeping. It beeps with a high and fuzzy tone. A button is then pressed. There is then the sound of a grungy electric guitar being played in a rock style. | 2010-04-07T14:51:46Z | jonnyroyster | http://itunes.apple.com/gb/album/reginalds-revenge/id383698450 http://www.amazon.com/Reginalds-Revenge-Explicit/dp/B003WZ9IR6 Nukeateen (Grunge band) official video for the track Face Up from the album Ozone. Nukeateen are an old school grunge / punk rock band. They have a new album out in 2010 called Reginalds Revenge check their myspace page for more details: http://www.myspace.com/nukeateen The Grunge Revival starts here. For a free download of Face Up visit our last fm page: http://www.last.fm/music/Nukeateen/_/Face+up | ["Alarm clock", "Music", "Independent music", "Rock music", "Alarm"] | ["alarm clock beeping", "alarm clock", "beeping", "high pitched tone", "ringing", "electric guitar strumming", "grungy electric guitar", "rock", "button pressing"] | 3 | 9ZUzftiN2uw | 1022 | |
| KARA - 「マンマミーア！」Music Video | A female singer sings this cool pop melody. The song is medium with a steady drumming rhythm, percussive bass line, keyboard accompaniment and various percussion hits. The song is modern K-pop. The song is romantic and cheerful. | 2014-08-18T19:00:08Z | KARAJAPANChannel | 遂にベールを脱いだ新生KARAが放つ、超最新ダンスチューン！ New Single 2014.08.27 Release!! 「マンマミーア！」 予約はこちらから： http://umusic.ly/kara_umstore 初回封入特典:2014年全国ツアーチケット先行抽選受け付けシリアルナンバー 応募期間:2014年8月26(火)18:00〜2014年9月3(水)23:00 初回限定盤ASG+DVDUMCK-9696 ￥1,886(税抜)＋税 ＜CD＞ 1. マンマミーア！ 2. ソー・グッド 3. マンマミーア！(Instrumental) 4. ソー・グッド(Instrumental) ＜DVD＞ マンマミーア！(Music Video Clip) マンマミーア！(Dance Shot Ver.) マンマミーア！(Music Video Clip オフショット) 初回限定盤BSG+フォトブックUMCK-9697 ￥1,600(税抜価格)＋税 ＜CD＞ 1. マンマミーア！ 2. ソー・グッド 3. マンマミーア！(Instrumental) 4. ソー・グッド(Instrumental) ＜フォトブック＞ 28Pスペシャルフォトブック 初回限定盤CSG+ボーナストラックUMCK-9698 ￥1,200(税抜価格)＋税 ＜CD＞ 1. マンマミーア！ 2. ソー・グッド 3. マンマミーア！(Instrumental) 4. ソー・グッド(Instrumental) 5. Don’t Hurry (Bonus Track) ＊初回盤Cが終了次第、通常盤SGのみ（UMCK-5494 ￥1,000＋税）に移行します ◆UM JAPAN KARA オフィシャルサイト http://umusic.ly/um_kara | ["Music of Asia", "Music"] | ["k-pop", "korean pop", "percussive bass line", "medium tempo", "backup singers", "vocal harmony", "steady drumming rhythm", "keyboard accompaniment", "various percussion hits", "pop hits", "pop diva", "romantic", "love song", "emotional", "female singer", "cheerful positive", "love me", "electric guitar strumming"] | 1 | EQSv7DIJJtw | 1555 | |
| Barbara Moleko - Paranoia // Backstage Music | The song is an upbeat, soulful song which has a motif repeated on a woodwind instrument. The song would be suitable for some mellow dancing. The singer has a raspy voice. | 2015-06-09T11:34:51Z | BACKSTAGE MUSIC | Dejlige Barbara Moleko optræder med Paranoia i Backstage Music studiet! | ["Afrobeat", "Music", "Dance music", "Tender music"] | ["electric guitar strumming", "woodwind instrument", "dance music", "upbeat", "groovy", "soulful pop", "classic soul", "disco soul", "raspy female vocal"] | 3 | hDsA_ky9Hfw | 4086 |
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;