musiccaps_details (view)
1 row where musiccaps_aspects contains "groovy kick", musiccaps_aspects contains "noisy" and musiccaps_names contains "Rapping"
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 |
---|---|---|---|---|---|---|---|---|---|---|
MCX Rap music video for Men's Wear | The low quality recording features a hip hop song that consists doubled, cool male vocals, alongside background male ad libs, rapping over jazzy piano chords, groovy kick, shimmering hi hats and soft snare hits all located in the right channel of the stereo image, making it unbalanced. The recording is noisy. | 2011-07-14T16:07:26Z | mccs29palmstv | MCX rap video for Mens Wear Music and Lyrics: by Corey Johnson Singing: by Corey Johnson www.facebook.com/WhoisJohnny Jyeah.spreadshirt.com Music Director: Harper Hug Actors and Actress: Jenn Purviance, Jeremy Putansu, Jamie Spradley,Breyana Burton, MCX employees, Marines | ["Music", "Rapping", "Exciting music"] | ["low quality", "hip hop", "doubled cool male vocals", "jazzy piano chords", "groovy kick", "shimmering hi hats", "soft snare hits", "background male ad libs", "unbalanced stereo", "noisy"] | 4 | tG5C-Smp-eY | 5020 |
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;