musiccaps_details (view)
2 rows where musiccaps_aspects contains "cello", musiccaps_aspects contains "emotional" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- cello · 2 ✖
- emotional · 2 ✖
- baroque 1
- christmas 1
- classical music 1
- dramatic 1
- female child vocal 1
- jingle 1
- male vocal 1
- male voice 1
- soprano 1
- spoken word 1
- strings 1
- violin 1
- wind chimes 1
musiccaps_names (array) 4 ✖
- Music 2
- Child singing 1
- Classical music 1
- Opera 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Kaitlyn Maher singing in Santa Paws 2: The Santa Pups | This is a Christmas themed jingle piece. There is a little girl singing sentimentally at a medium-to-high pitch. In the melodic background, treble strings play the tune while the cello holds the bass notes with rhythm. There is also a passing section of wind chimes. A male voice makes a brief comment over the girl's singing. This could be used in Christmas themed social media content. | 2012-11-13T19:50:46Z | Sheenasa | Two year ago i uploaded a video of Kaitlyn when she was in The search for santa paws, This is Kaitlyn singing in Santa paws 2 This clip is from the end of the movie. Kaitlyns voice has grown so much over the years.. I just had to share this :D This video is for entertainment purposes only, no copyright infringement intended... Enjoy! | ["Music", "Child singing"] | ["female child vocal", "jingle", "strings", "cello", "wind chimes", "male voice", "spoken word", "emotional", "christmas"] | 9 | 4q6e_ZDFOZI | 609 | |
Baroque music - Extremely rare voice (Sad classical music) | This is a classic music piece belonging to the baroque era. There is a soprano male vocal singing at an extraordinarily high pitch. The melody is being played by the violin and the cello. There is an emotional atmosphere to this piece. It could be playing in the background at a classy restaurant. It could also work well in the soundtrack of an art movie. | 2012-04-07T00:22:30Z | Ksenia Vorobieva | Baroque, classical music ... Extremely rare voice - male soprano Radu Marian sings aria from Baroque cantata "Vorrei, pupille belle, con Violini" (Bononcini). This is his natural soprano voice, not falsetto. For more songs and videos: http://www.youtube.com/user/radumariandotnet If you like, please share this video with others. --- Раду Марьян (мужское сопрано). http://www.youtube.com/user/radumariandotnet --- Baroque music, sad classical music | ["Music", "Opera", "Classical music"] | ["classical music", "baroque", "male vocal", "soprano", "violin", "cello", "emotional", "dramatic"] | 9 | 5nJr7iar6ZM | 695 |
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;