musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "happy" and musiccaps_names contains "Rhythm and blues" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- happy · 2 ✖
- acoustic guitar lead 1
- buoyant 1
- cheerful 1
- distorted 1
- electric guitar harmony 1
- electric guitar melody 1
- enthusiastic drumming 1
- female singer 1
- flat male vocal 1
- foreign language 1
- fresh 1
- fun 1
- funky bass lines 1
- groovy 1
- groovy bass 1
- low quality 1
- medium tempo 1
- noisy 1
- peppy 1
- perky 1
- pleasant melody 1
- pop song 1
- punchy snare 1
- shimmering cymbals 1
- simple 1
- teen pop 1
- vivacious 1
- vocal harmony 1
- youthful 1
musiccaps_names (array) 11 ✖
- Music 2
- Rhythm and blues · 2 ✖
- Bass guitar 1
- Blues 1
- Guitar 1
- Happy music 1
- Harmonic 1
- Jingle (music) 1
- Musical instrument 1
- Plucked string instrument 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Blues Rhythms - #1 - Guitar Lesson - Corey Congilio | The low quality recording features an electric guitar melody played over a playback that consists of groovy bass, punchy snare and shimmering cymbals. At the end of the loop, there is a flat male vocal talking. It sounds groovy, fun and the recording is noisy and slightly distorted. | 2012-11-21T19:01:01Z | TrueFire | *FULL COURSE NOW AVAILABLE FOR DOWNLOAD w/ TAB, JAMS & MORE: http://tfir.es/50BluesRhythms COREY CONGILIO: http://tfir.es/CoreyC MORE FREE GUITAR LESSONS: http://bit.ly/TrueFire | ["Blues", "Bass guitar", "Guitar", "Music", "Musical instrument", "Rhythm and blues", "Speech", "Harmonic", "Plucked string instrument"] | ["low quality", "electric guitar melody", "groovy bass", "punchy snare", "shimmering cymbals", "groovy", "fun", "happy", "flat male vocal", "distorted", "noisy"] | 4 | NZ2kFIaW05k | 2345 | |
Happy Music 今こそハッピーな歌を! by misc | A female vocalist sings this chirpy song. The tempo is medium with a melodic electric guitar harmony, acoustic guitar lead, sprightly drumming, funky bass lines and peppy backup. The song is youthful, perky, cheerful, vivacious ,bubbly and in a foreign language.This song is teen pop/ Pop. | 2011-03-18T23:09:55Z | happymusicX | 悩みなんか 弾け飛んで 忘れちゃって 流しちゃって 太陽が笑うよ happy music 僕らはみんな宇宙のフレンズ 何が起きても独りじゃない 笑顔の数だけのハッピー 集めたらまわり出す ほら聴こえて繰るよ happy music (歌詞の一部より) 歌タイトル:太陽と猫と私 Vocal & Violin: misc (ミスク) Music arrangement: iNA (ex hide with spread beaver) 想像を超えた大災害に心が震えるけど、そんなときこそ、口ずさみたい歌に出会ったのでアップロードしたよ。これ聞きながら、駅まで歩いたら明るい気分になれたから。 | ["Jingle (music)", "Music", "Rhythm and blues", "Happy music"] | ["female singer", "medium tempo", "foreign language", "electric guitar harmony", "funky bass lines", "acoustic guitar lead", "enthusiastic drumming", "vocal harmony", "youthful", "pleasant melody", "simple", "fresh", "happy", "perky", "cheerful", "vivacious", "buoyant", "peppy", "pop song", "teen pop"] | 7 | gBuLpP4klvI | 4012 |
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;