musiccaps_details (view)
1 row where musiccaps_aspects contains "indie rock", musiccaps_aspects contains "muffled", musiccaps_aspects contains "uplifting" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
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 |
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;