musiccaps_details (view)
2 rows where musiccaps_aspects contains "male singer" and musiccaps_aspects contains "saxophone harmony" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- male singer · 2 ✖
- saxophone harmony · 2 ✖
- ambient music 1
- bad sound quality 1
- blues 1
- brass band 1
- complex harmony 1
- dance music 1
- emotional 1
- groovy bass line 1
- groovy rhythm 1
- home music video 1
- instrumental squid 1
- jazz 1
- latin dance hits 1
- latin dance music 1
- latin percussions 1
- love song 1
- marimba 1
- medium tempo 1
- people dancing 1
- pleasant 1
- proposal song 1
- r&b 1
- romantic 1
- romantic piano 1
- saxophones 1
- sentimental 1
- slow tempo 1
- soul 1
- steady drumming 1
- syncopated 1
- syncopated rhythms 1
- traditional latin dance 1
- trumpets 1
- wedding song 1
- wooden xylophone 1
musiccaps_names (array) 4 ✖
- Brass instrument 1
- Music 1
- Saxophone 1
- Wedding music 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
2013 Wedding Song (You Are) Derek Rusel | A male vocalist sings this soft love song. The tempo is slow with a romantic piano accompaniment, groovy bass line, steady drumming and ambient saxophone harmony. The song is a romantic, emotional, mellow, sentimental, proposal or wedding song. This song is a R&B/Soul song. | 2011-01-14T10:13:18Z | Vent Music | ["Music", "Wedding music"] | ["male singer", "slow tempo", "romantic piano", "ambient music", "saxophone harmony", "steady drumming", "groovy bass line", "r&b", "soul", "blues", "jazz", "complex harmony", "syncopated", "pleasant", "romantic", "emotional", "sentimental", "love song", "wedding song", "proposal song"] | 7 | 07xGXxIHOL4 | 125 | ||
Marimba Perla de Chiapas 2010 abeja miope | The song is an instrumental. The tempo is medium with a brass including trumpets and saxophones playing in harmony, wooden xylophones and Latin percussions play accompaniment to the band along with a male singer. The song is exciting and groovy. The audio quality is poor and probably a home recording. | 2010-01-15T12:34:08Z | Jawar TresCeros | Marimba Perla de Chiapas 2010 abeja miope | ["Brass instrument", "Saxophone"] | ["marimba", "latin dance music", "saxophones", "medium tempo", "instrumental squid", "traditional latin dance", "brass band", "trumpets", "groovy rhythm", "syncopated rhythms", "dance music", "people dancing", "male singer", "saxophone harmony", "wooden xylophone", "bad sound quality", "home music video", "latin dance hits", "latin percussions", "medium tempo"] | 1 | gb8PG-5i5YI | 4040 |
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;