musiccaps_details (view)
2 rows where musiccaps_aspects contains "female voice" and musiccaps_aspects contains "trumpet"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- female voice · 2 ✖
- moderate tempo 2
- trumpet · 2 ✖
- bass 1
- congas 1
- dance music 1
- dance song 1
- female backing voice 1
- happy mood 1
- low quality recording 1
- male backing voice 1
- percussion 1
- piano 1
- pop song 1
- repetitive melody 1
- salsa song 1
- saxophone 1
- seductive rhythm 1
musiccaps_names (array) 3 ✖
- Music 2
- Funk 1
- Salsa music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Midtown Music Traditional Salsa | This salsa song features a female voice singing the main melody. This is accompanied by the congas. The beat is a dance beat. Trumpets and a saxophone play fills in between lines. A piano plays a melody at the end of the song. The song starts with the voice singing a melody at a moderate tempo. After the piano plays, the tempo of the song increases. Other instruments cannot be heard as the quality of the recording is low. This song can be played in a Latin dance sequence in a movie. | 2011-10-27T17:36:40Z | MidtownMusicUK | http://www.midtownmusic.co.uk Midtown Music Agency is a bespoke music service based in Midtown London, Supplying the top event acts in the country. | ["Music", "Salsa music"] | ["low quality recording", "salsa song", "congas", "saxophone", "trumpet", "piano", "female voice", "moderate tempo", "dance music", "seductive rhythm"] | 0 | CN2QSmhP-HI | 1358 | |
SUPERSCI - Get! (Feat. Remedeeh) (Official Video) | This pop song features a female voice singing the main melody. This is accompanied by male and female backing voices. The voices sing a repetitive melody. This is accompanied by percussion playing a simple beat. Trumpets play a backing melody. The bass plays a groovy descending bassline. The mood of this song is happy. This song can be played at a club. | 2006-06-07T17:33:35Z | Supersci Flyphonic | Swedish hip hop at its finest with a sweet summer vibe. Supersci's first video from the 2006 album "Pinetrees on the Pavement". Shot around the Sundsvall area using super-8 film. Video directed by Måns Berthas. Music produced by Flyphonic Beats. Lyrics by Mr Noun, Arka and Remedeeh. www.flyphonic.com/supersci | ["Funk", "Music"] | ["pop song", "female voice", "male backing voice", "female backing voice", "percussion", "trumpet", "bass", "moderate tempo", "dance song", "repetitive melody", "happy mood"] | 0 | EtmKuWPpjG0 | 1598 |
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;