musiccaps_details (view)
2 rows where musiccaps_aspects contains "funky bass", musiccaps_author = 0 and musiccaps_names contains "Funk"
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- funky bass · 2 ✖
- male voice 2
- funk rock 1
- funk song 1
- keyboard layers 1
- keyboard song 1
- moderate tempo 1
- percussion 1
- repetitive piano melody 1
- repetitive trumpet melody 1
- repetitive vocal melody 1
- simple percussion 1
- trumpet 1
musiccaps_names (array) 5 ✖
- Funk · 2 ✖
- Music 2
- Christian music 1
- Gospel music 1
- Rhythm and blues 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
FUNK GOSPEL 123 | This funk song features a male voice singing the main melody. The melody is repetitive. This is accompanied by percussion that does not play any cymbals. A trumpet plays a repetitive melody of staccato notes. There are other quirky instruments playing in the background adding to the percussion. The mood of this song is upbeat. This song can be played in a bank robbery movie. | 2009-02-16T12:04:24Z | andersoncoutinho123 | ["Gospel music", "Christian music", "Funk", "Music"] | ["funk song", "male voice", "percussion", "funky bass", "trumpet", "repetitive vocal melody", "repetitive trumpet melody"] | 0 | 3FJFcgaa0oE | 451 | ||
Funk Initiative - Architects [Official Music Video] | This funk rock song features a male voice singing the main melody. This is accompanied by percussion playing a simple beat. A tambourine, snare and kick are played simultaneously on every count. The tambourine plays on the eighth note. This song is common time. A repetitive piano melody is played in the background. The bass plays the root notes with fills. A whistling sound is played in the gap between lines. At the beginning and toward the middle of the song, the sound of strings is heard playing a short lick. This song can be played in a spy romance movie. | 2013-02-12T16:28:54Z | Funk Initiative | Music by Funk Initiative Song and lyrics by Paul Torpiano Vocals - Gianluca Bezzina Bass guitar - Shaun Abdilla Guitar - Daniel Cassar Sax - Fabian Bonello Drums - Daniel Buttigieg Keys - Paul Torpiano Recorded and produced by Niki Gravino at Foreface Studios. Video: - Directed and Produced by Jacques Norris Special thanks to: - ELSA - SACES - INSITE - Chris Mintoff - Jake Dalli - Nichi Agius - Andrew Schembri - Rob Rizzo - Simon Callus - Deborah Farrugia - Warren Sammut | ["Funk", "Music", "Rhythm and blues"] | ["funk rock", "male voice", "repetitive piano melody", "funky bass", "simple percussion", "keyboard song", "keyboard layers", "moderate tempo"] | 0 | ONfd_rHtL74 | 2433 |
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;