musiccaps_details (view)
3 rows where musiccaps_aspects contains "bass", musiccaps_aspects contains "pop song" and musiccaps_names contains "Christian music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- bass · 3 ✖
- pop song · 3 ✖
- male voice 2
- simple percussion 2
- slow tempo 2
- synth 2
- backing vocal harmony 1
- backing voices 1
- children's voices 1
- christmas song 1
- duet 1
- female voice 1
- happy mood 1
- holiday mood 1
- holiday theme 1
- keyboard 1
- low quality audio 1
- moderate tempo 1
- percussion 1
- piano 1
- romantic theme 1
- string section 1
- synth pads 1
musiccaps_names (array) 4 ✖
- Christian music · 3 ✖
- Music 3
- Singing 2
- Christmas music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Carpenters - You | This pop song starts off with the backing singers singing vocables in harmony. This is backed by percussion playing a simple beat. The bass plays a flourish ending on the root note of the next chord. The string section plays high pitched notes. The piano plays a flourish of ascending notes before the main female voice starts to sing the main melody. This is accompanied by the percussion continuing with the simple beat. The string section fades away. The bass plays a descending walk down and ends on a high note. This song has a romantic feel. This song can be played in a romantic movie. | 2008-06-25T12:52:31Z | sisterlead02 | One of their beautiful songs! From A kind of hush album. | ["Singing", "Christian music", "Music"] | ["pop song", "female voice", "bass", "backing vocal harmony", "simple percussion", "piano", "string section", "slow tempo", "romantic theme"] | 0 | 6QHfXuVLhe0 | 755 | |
NEWSONG - Christmas Shoes | This song features a male voice singing the main melody. The first two lines are sung using the same melody and it culminates in the third line. This is accompanied by percussion playing a simple beat. The bass plays the root notes of the chords. The keyboard plays arpeggiated chords in the background. Another synth plays a windy pad voice throughout the song sounding like strings. This song has a holiday mood. This song can be played in a holiday movie. | 2007-12-24T11:51:57Z | Lee O. | This was made by me for my wonderful friend Rhena! A really special girl who is so nice to everyone, and truly deserves something really special done for her too! She has always wanted to see a video to this touching song, so Rhena... I hope this doesn't disappoint! The Song: Christmas Shoes The Artist: Newsong | ["Christian music", "Music"] | ["low quality audio", "pop song", "holiday mood", "male voice", "synth", "synth pads", "simple percussion", "keyboard", "bass", "slow tempo"] | 0 | KfAq7kxHjPk | 2104 | |
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;