musiccaps_details (view)
3 rows where musiccaps_aspects contains "energetic drums", musiccaps_aspects contains "flat male vocal" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- energetic 3
- energetic drums · 3 ✖
- flat male vocal · 3 ✖
- low quality 3
- groovy bass guitar 2
- live performance 2
- addictive synth melody 1
- chaotic 1
- crowd screaming 1
- crushed 1
- distorted 1
- dub 1
- electric guitar solo melody 1
- exciting 1
- groovy bass 1
- indie rock 1
- loud 1
- muffled 1
- nasal 1
- noisy 1
- offbeat guitar melody 1
- passionate female vocal 1
- pop rock 1
- uplifting 1
musiccaps_names (array) 6 ✖
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 | |
Sud Sound System@Villa Ada - feat. Maria Ganja | The low quality recording features a live performance of dub song manically rapped by flat male vocals, followed by energetic drums, groovy bass and offbeat key chords. The recording is noisy and chaotic a bit, as it is probably recorded with a phone. | 2007-07-25T12:28:57Z | Ivano Zizzi | grande performance! Sud sound systema a "Roma Incontra il mondo" VILLA ADA. Nuh se po proibire & erba erba | ["Music", "Music of Latin America"] | ["low quality", "dub", "noisy", "live performance", "energetic", "offbeat guitar melody", "energetic drums", "flat male vocal", "chaotic", "groovy bass"] | 4 | JN_VJCJhC4Y | 1996 | |
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 |
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;