musiccaps_details (view)
1 row where musiccaps_aspects contains "emotional", musiccaps_aspects contains "indie folk", musiccaps_aspects contains "sad" 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 |
---|---|---|---|---|---|---|---|---|---|---|
Top 30 Indie Folk and Acoustic (Playlist #5) | The low quality recording features an indie folk song that consists of wide harmonizing male vocals and acoustic rhythm guitar. In the second half of the loop, the lead female vocal appears, creating a perfect harmony with the previously mentioned male vocals. It sounds passionate, emotional and sad. | 2014-02-28T23:48:23Z | Indie & Folky Me | Indie Folk Playlist of march 2014 by the Indie and Folky Me Team Website: http://IndieFolkyMe.tk Follow us on twitter : @IndieFolkyMe Join us on facebook : https://www.facebook.com/IndieFolkyMe Photo by Antsa Rvl (Fickr) : http://www.flickr.com/people/10663187... Go here to watch the EXCLUSIVE Top 20 Indie Pop Charts : http://t.co/Isqtvo2FQ5 TRACKLIST Fall At Your Feet - Boy & Bear Just For Now - Cloud Control Where We Gonna Go From Here - Mat Kearney More Than Life - Whitley Message - Xavier Rudd Big Black Car - Gregory Alan Isakov Wolves - The Accidental Something Better - Ecclectic Approach Horses - The Be Good Tanyas Follow Fires - Matthew & The Atlas Move mountains - Roo Panes Without You - Keith Urban Night Bus - Lucy Rose David - Noah Gundersen The Romance Of Wolves - Roma Di Luna Send Me On My Way - Rusted Root Stereo Heart - Collin Mcloughlin Willow Tree March - THe Paper Kites Where Is My Mind - Tramped By Turtles Girl - Lovedrug Riverbanks - Charlie Simpson Sunday best - Augustana The Story I Heard - Blind Pilot Karen O - The Moon Song People - Sharon Nutzati Hidden Edelweiss - Spark Alaska Always Remember Me - Ry Cuming ft Sara Bareilles Worry - Rhodes Rosemary - Ghost & Gale Sons & Daughters - Allman Brown ft Liz Lawrence Bonus: I Lived - One Republic * Copyright Disclaimer * Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use." | ["Folk music", "Acoustic guitar", "Music", "Independent music", "Song", "Strum", "Plucked string instrument"] | ["low quality", "wide harmonizing male vocals", "indie folk", "acoustic rhythm guitar", "lead female vocal", "passionate", "emotional", "sad"] | 4 | hTlIqICkbW8 | 4110 |
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;