musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "energetic", musiccaps_aspects contains "energetic drums" and musiccaps_aspects contains "groovy bass guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- energetic · 3 ✖
- energetic drums · 3 ✖
- groovy bass guitar · 3 ✖
- low quality 3
- flat male vocal 2
- addictive synth melody 1
- cover 1
- crowd screaming 1
- crushed 1
- distorted 1
- distorted electric guitar melody 1
- electric guitar solo melody 1
- exciting 1
- flat female vocal 1
- indie rock 1
- live performance 1
- loud 1
- muffled 1
- nasal 1
- passionate 1
- passionate female vocal 1
- pop rock 1
- rock 1
- uplifting 1
musiccaps_names (array) 10 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"Nashville Indie Music Rocks" [Nokia - Sundance London Film Festival Entry by Russb] | The low quality recording features an indie rock song that consists of passionate female vocal singing over energetic drums, electric guitar solo melody and groovy bass, over which there is a flat, nasal and muffled male vocal narrating. The song sounds energetic and uplifting. | 2013-03-21T09:15:50Z | Joy Collins Music | DOWNLOAD Great Indie Music @ http://bit.ly/iTunesJoyCollins Visit http://countrymusicsongs.co Go TO http://bit.ly/NashvilleIndieMusicDocumentary AND Click The "SUPPORT RUSS" Button for the http://facebook.com/NokiaMusic #NokiaXSundanceLDN #Lumia920 Music Contest. Our documentary is about the extremely talented, diverse, Nashville Independent Music Scene. Please share this with all of your friends and help us take our documentary to the upcoming Sundance Film Festival in London. Stop by http://twitter.com/NokiaMusic and let them know that you support The Indie Music Scene in Nashville and would like to see our city chosen as a participant! Thanks and PLEASE SHARE and COMMENT!! Nashville Independent Music Rocks! For collaborations and business inquiries, please contact via Channel Pages: http://ChannelPages.com/CountryMusicSongs4u | ["Music", "Independent music", "Speech"] | ["low quality", "flat male vocal", "indie rock", "passionate female vocal", "energetic drums", "electric guitar solo melody", "groovy bass guitar", "energetic", "uplifting", "muffled", "nasal"] | 4 | CKO35LsM0XI | 1352 | |
Jonas Brothers - Take on Me Music Video | The low quality recording features a live performance of a pop rock song and it consists of flat male vocals counting down over addictive synth melody, energetic drums and groovy bass guitar. There are loud crowd screams in the background. It sounds distorted, loud and crushed, as it was probably recorded with a phone, but it is still energetic and exciting. | 2008-03-16T18:30:37Z | JBMusicOnRedbull465 | I took off the comments because i was super sick of what people were saying...maybe i'll put them back up later http://jbmusiconredbull.webs.com | ["Music", "Pop music", "Exciting music"] | ["pop rock", "flat male vocal", "low quality", "live performance", "energetic", "exciting", "crowd screaming", "loud", "addictive synth melody", "energetic drums", "groovy bass guitar", "distorted", "crushed"] | 4 | WTVC7ZI9WtY | 3098 | |
Metallica - Fade to Black - Cover By Keara | The low quality recording features a cover of a rock song that consists of flat male vocal singing over distorted electric guitar melody, energetic drums and groovy bass guitar. The song sounds passionate and energetic. | 2013-08-28T00:39:45Z | guitarprincesskeara | This video took a lot of hard work and time. Enjoy, thanks for all the support! | ["Singing", "Guitar", "Music", "Musical instrument", "Psychedelic rock", "Plucked string instrument"] | ["low quality", "distorted electric guitar melody", "rock", "cover", "energetic drums", "groovy bass guitar", "energetic", "passionate", "flat female vocal"] | 4 | XJXn88r9ys8 | 3176 |
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;