musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy kick" and musiccaps_author = 4 sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- groovy kick · 2 ✖
- addictive electric guitar melody 1
- arpeggiated synth keys melody 1
- background male ad libs 1
- doubled cool male vocals 1
- emotional 1
- energetic 1
- groovy bass 1
- hip hop 1
- industrial rock 1
- jazzy piano chords 1
- low quality 1
- noisy 1
- punchy snare 1
- shimmering cymbals 1
- shimmering hi hats 1
- soft snare hits 1
- unbalanced stereo 1
musiccaps_names (array) 4 ✖
- Music 2
- Angry music 1
- Exciting music 1
- Rapping 1
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dope Stars Inc. - Dressed Inside Your Fear | The Industrial Rock song features a groovy bass, punchy snare, groovy kick pattern, shimmering cymbals, addictive electric guitar melody and arpeggiated synth keys melody playing. It sounds energetic and emotional - like something you would jump to at concerts. | 2015-05-28T11:58:57Z | Dope Stars Inc. | DOWNLOAD ⇒ https://dopestarsinc.bandcamp.com/album/terapunk Written, directed & edited by Daniele Campea at http://www.creativesfilm.com | ["Music", "Angry music"] | ["industrial rock", "groovy bass", "punchy snare", "groovy kick", "shimmering cymbals", "addictive electric guitar melody", "arpeggiated synth keys melody", "energetic", "emotional"] | 4 | udQQrQB-gr4 | 5129 | |
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;