musiccaps_details (view)
2 rows where musiccaps_aspects contains "electric guitar" and musiccaps_aspects contains "high pitch singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- electric guitar · 2 ✖
- high pitch singing · 2 ✖
- male vocal 2
- acoustic drums 1
- bass guitar 1
- cover 1
- groovy 1
- male narrator 1
- pop punk 1
- pop rock 1
- r&b music 1
- simple riff 1
- sit-com soundtrack 1
- urban 1
musiccaps_names (array) 8 ✖
- Music 2
- Electric guitar 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Pulse 1
- Ska 1
- Speech 1
youtube_published (date) 2 ✖
- 2007-02-10 1
- 2015-03-12 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fall Out Boy-Novocaine | Electric Guitar Cover | This is the electric guitar cover of a pop punk/pop rock music piece. There is an electric guitar playing a simple riff. In the backing track, a male vocalist is singing melodically at a high range. | 2015-03-12T16:34:55Z | Cassi Charlier | Enjoy my video and don't forget to subscribe, leave a comment, share and like. Let me know which song I should cover next in the comments below, on Twitter or Instagram. And if you need a guitarist and songwriter, let me know! :) social media: TWITTER • www.twitter.com/CassiCharlier INSTAGRAM • www.instagram.com/cassicharlier TUMBLR • www.tumblr.com/cassicharlier VINE • www.vine.com/CassiCharlier chords (standard tuning) | no Capo: Intro: Em 2x Verse: Em,C and Em Pre-Chorus: C,G,D and Em Chorus: Em,C and G Bridge: Em | ["Electric guitar", "Guitar", "Music", "Musical instrument", "Pulse", "Plucked string instrument"] | ["cover", "pop punk", "pop rock", "electric guitar", "simple riff", "male vocal", "high pitch singing"] | 9 | AuwwPMrH5sE | 1184 | |
Everybody Hates Chris | This is an R&B music piece from a sit-com soundtrack. Initially, there is a male voice narrating what is going on in the episode. Then the piece starts playing with a high pitched male vocal at the forefront. The melody is being played by the electric guitar and the bass guitar while the rhythmic background consists of an acoustic drum beat. The atmosphere is urban. | 2007-02-10T13:09:18Z | tigerzrule | My Personal Fav Bits OF EHC | ["Music", "Ska", "Speech"] | ["sit-com soundtrack", "male narrator", "r&b music", "male vocal", "high pitch singing", "electric guitar", "bass guitar", "acoustic drums", "groovy", "urban"] | 9 | T78nMdsJMmk | 2810 |
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;