musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "energetic" and musiccaps_aspects contains "indie rock" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- energetic · 2 ✖
- indie rock · 2 ✖
- acoustic drums 1
- alternative 1
- bass guitar 1
- electric guitar 1
- electric guitar solo melody 1
- electronic sound effect 1
- energetic drums 1
- flat male vocal 1
- groovy bass guitar 1
- hip 1
- laser 1
- live performance 1
- low quality 1
- male vocal 1
- muffled 1
- nasal 1
- passionate female vocal 1
- post-punk 1
- uplifting 1
- youthful 1
musiccaps_names (array) 6 ✖
- Independent music 2
- Music 2
- Cacophony 1
- Rock music 1
- Singing 1
- Speech 1
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 | |
Bloc Party - Hunting For Witches @ Bristol Academy 7/2/07 | This is the live performance of an indie rock/post-punk piece. There is a male vocalist in the lead. The tune is being played by the electric guitar and the bass guitar while an electronic sound effect that resembles a laser is adding texture. There is a fast and slightly off-tempo acoustic drum beat playing in the rhythmic background. The atmosphere is energetic. The piece could be playing in the soundtrack of a teenage drama TV series. | 2007-02-23T17:52:05Z | matthewm674 | Bloc Party performing Hunting For Witches live at the Bristol Carling Academy - 7th Feb 2007. | ["Singing", "Music", "Independent music", "Rock music", "Cacophony"] | ["live performance", "indie rock", "post-punk", "alternative", "male vocal", "electric guitar", "bass guitar", "electronic sound effect", "laser", "acoustic drums", "energetic", "hip", "youthful"] | 9 | xUMzNtC2ITA | 5332 |
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;