musiccaps_details (view)
2 rows where musiccaps_aspects contains "male voice", musiccaps_aspects contains "percussion" and musiccaps_names contains "Christian music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- male voice · 2 ✖
- percussion · 2 ✖
- backing voices 1
- bass 1
- children's voices 1
- christmas song 1
- duet 1
- funk song 1
- funky bass 1
- happy mood 1
- holiday theme 1
- moderate tempo 1
- pop song 1
- repetitive trumpet melody 1
- repetitive vocal melody 1
- synth 1
- trumpet 1
musiccaps_names (array) 6 ✖
- Christian music · 2 ✖
- Music 2
- Christmas music 1
- Funk 1
- Gospel music 1
- Singing 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 | ||
This Is Christmas (Christmas 2013 ) Paul Martin Feat Shauna Gallon | This pop song features a male and female voice singing the main melody. There are backing voices singing fills in between lines. Children sing in the background. This is accompanied by percussion playing a simple beat. The bass plays the root notes of the chords. A synth plays a pedal chord in staccato. This song can be played at the end credits of a holiday movie. | 2009-10-07T15:44:15Z | Chris tmasMusic | One of the Finest Christmas songs still yet to Make It. Please Share this song written & performed by one of worlds finest Christmas Crooners Paul Martin aka Mr Success featuring future star Shauna Gallon & a cast of family & friends shot in Newcastle upon Tyne in 2009. www.franksinatratributesinger.co.uk | ["Christmas music", "Singing", "Christian music", "Music"] | ["pop song", "holiday theme", "duet", "male voice", "children's voices", "christmas song", "percussion", "bass", "synth", "happy mood", "moderate tempo", "backing voices"] | 0 | ODOrls3MuZI | 2411 |
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;