musiccaps_details (view)
2 rows where musiccaps_aspects contains "low quality", musiccaps_aspects contains "offbeat piano chords" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- easygoing 2
- groovy bass 2
- low quality · 2 ✖
- offbeat piano chords · 2 ✖
- brass melody 1
- chill 1
- flat male vocal 1
- harmonizing background male vocal 1
- muffled snare 1
- noisy 1
- punchy kick 1
- reggae 1
- shimmering hi hats 1
- shimmering shakers 1
- tinny echoing snare 1
- tinny percussive elements 1
- upbeat 1
- wide harmonizing low male vocals 1
- wide toms 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
danger in your eyes riddim dj divinity | The low quality recording features a reggae song that consists of a flat male vocal, alongside harmonizing background male vocals, singing over shimmering shakers, offbeat piano chords, brass melody, wide toms, tinny echoing snare and punchy kick layered with it. It sounds upbeat and easygoing. | 2010-09-15T14:18:53Z | Big Poppa Funko AKA DJ Divinity | pure chunage is all i'm gona say, by these reggae legends https://twitter.com/deejaydivinity https://www.facebook.com/pages/DJ-divinity/161626630517139 download link below https://soundcloud.com/lee-divinity-neal/danger-in-your-eyes-riddim-dj | ["Music", "Reggae", "Maraca"] | ["low quality", "harmonizing background male vocal", "groovy bass", "brass melody", "offbeat piano chords", "shimmering shakers", "wide toms", "tinny echoing snare", "punchy kick", "flat male vocal", "upbeat", "easygoing"] | 4 | cOsm3r-xKEE | 3703 | |
Echo Sound System - Echo Sound (None A Jah Jah Children Riddim) | The low quality recording features a reggae song that consists of wide harmonizing low male vocals singing over groovy bass, muffled snare, shimmering hi hats, tinny percussive elements and offbeat piano chords. The recording is noisy and it sounds easygoing and chill. | 2009-06-18T03:20:15Z | Voxcesar Selektah | Album:Tempo Vai Dizer, Artist: Echo Sound System & General Smiley Year: 2005 , Label: Phantom , Tracks: 21 | ["Echo", "Music", "Reggae"] | ["reggae", "low quality", "wide harmonizing low male vocals", "offbeat piano chords", "groovy bass", "muffled snare", "tinny percussive elements", "shimmering hi hats", "noisy", "easygoing", "chill"] | 4 | yVWk3yq3Abc | 5415 |
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;