musiccaps_details (view)
2 rows where musiccaps_aspects contains "male vocals", musiccaps_aspects contains "synth" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- electronic drums 2
- male vocals · 2 ✖
- synth · 2 ✖
- aggressive 1
- czech 1
- dance 1
- harmonica 1
- intimate 1
- keyboard 1
- loud 1
- mellow bass 1
- melodic singing 1
- neo-soul 1
- r&b 1
- rap 1
- seductive 1
musiccaps_names (array) 5 ✖
- Music 2
- Hip hop music 1
- Rapping 1
- Rhythm and blues 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Carl Thomas: Conquer | This is a neo-soul music piece. There is a male vocal singing melodically with another male back vocal singing in a more erotic fashion. The tune is played with a keyboard and a synth. There is a mellow bass line in the background. An acoustic-sounding electronic drum kit provides the rhythmic background. The piece has a seductive atmosphere to it. It could be played at a nightclub during earlier hours. It could also work well as the jingle of a fashion/fragrance advertisement. | 2011-07-15T01:14:54Z | CarlThomasLive | Carl Thomas new album "Conquer" Coming out October 4th, 2011 | ["Music", "Rhythm and blues", "Song"] | ["r&b", "neo-soul", "male vocals", "melodic singing", "keyboard", "synth", "mellow bass", "electronic drums", "harmonica", "dance", "seductive", "intimate"] | 9 | 9ZAmdxKLnhs | 1021 | |
Smack Igor Ty nevíš co sem dělal dřív | This is a Czech rap music piece. There is a male voice rapping in the Czech language. There is a medium-pitch synth playing the melody. The medium tempo electronic drum beat carries the rhythmic background. The atmosphere of the piece is loud and aggressive. This piece could be used in the soundtrack of a crime movie taking place in Central Europe. | 2012-11-19T13:02:12Z | Radek Betyár | ["Music", "Rapping", "Hip hop music"] | ["rap", "czech", "male vocals", "synth", "electronic drums", "aggressive", "loud"] | 9 | tQ1Nl4Dy2aI | 5035 |
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;