musiccaps_details (view)
2 rows where musiccaps_aspects contains "bad audio quality", musiccaps_aspects contains "romantic" and musiccaps_aspects contains "steady drumming rhythm"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- bad audio quality · 2 ✖
- emotional 2
- romantic · 2 ✖
- steady drumming rhythm · 2 ✖
- dance rhythm 1
- distorted audio quality 1
- distorted harmony 1
- energetic 1
- female singer 1
- funk music 1
- funky groove 1
- groovy bass line 1
- groovy music 1
- guitar rhythm 1
- inspiring 1
- keyboard accompaniment 1
- love song 1
- madly in love 1
- male singer 1
- medium tempo 1
- memdium tempo 1
- modern pop hits 1
- modern r&b hits 1
- motivational 1
- never give up on you 1
- organ accompaniment 1
- percussive bass line 1
- poor audio quality 1
- r&b 1
- retro pop 1
- soul singer 1
- story telling 1
- strong bass drum hits 1
- vocal harmony 1
musiccaps_names (array) 3 ✖
- Funk 1
- Music 1
- Music of Asia 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
FUNK!! Starr-Shes So Fine | A male singer sings this groovy melody. The tempo is medium with a strong bass line, steady drumming, keyboard playing a countermelody and various percussion hits. The song is funk pop in nature. The song has poor audio quality. | 2010-06-18T18:51:57Z | turtle101392 | Starr-Shes so Fine | ["Funk", "Music"] | ["female singer", "bad audio quality", "romantic", "emotional", "dance rhythm", "retro pop", "distorted audio quality", "poor audio quality", "distorted harmony", "keyboard accompaniment", "steady drumming rhythm", "strong bass drum hits", "groovy music", "energetic", "funky groove", "funk music", "groovy bass line"] | 1 | NZn4-gP2GiI | 2347 | |
John Legend - Who Did That to You (Lyrics) from Django Unchained Soundtrack | A male singer sings this soulful melody with backup singers in vocal harmony. The song is medium tempo with an organ accompaniment, steady drumming , guitar rhythm and various percussion hits. The song is story telling and passionate in nature. The audio quality is very poor. | 2012-12-29T14:50:41Z | django unchained | The lyrics for John Legend's song - Who Did That To You fro the soundtrack of Quentin Tarantino's movie - Django Unchained buy this song at http://www.amazon.com/Who-Did-That-to-You/dp/B00AL3KI76 | ["Music of Asia"] | ["male singer", "bad audio quality", "modern pop hits", "bad audio quality", "medium tempo", "emotional", "inspiring", "motivational", "romantic", "never give up on you", "madly in love", "love song", "story telling", "soul singer", "vocal harmony", "organ accompaniment", "memdium tempo", "guitar rhythm", "steady drumming rhythm", "percussive bass line", "r&b", "modern r&b hits"] | 1 | ozjs2d_xlSI | 4674 |
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;