musiccaps_details (view)
2 rows where musiccaps_aspects contains "male singer" and musiccaps_aspects contains "soaring vocals"
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- emotional 2
- male singer · 2 ✖
- medium tempo 2
- movie soundtrack 2
- passionate 2
- soaring vocals · 2 ✖
- bad quality audio 1
- bollywood music 1
- buzzing 1
- christmas 1
- christmas ade nature 1
- christmas carols 1
- christmas classics 1
- christmas time 1
- deteriorated audio quality 1
- devotional 1
- groovy bass line 1
- guitar accompaniment 1
- hissing noise 1
- humming 1
- inspiring 1
- longing for you 1
- love song 1
- madly in love 1
- miracles 1
- motivational 1
- no percussion instruments 1
- orchestra playing 1
- philharmonic orchestra 1
- piano accompaniment 1
- poor audio quality 1
- poor quality audio 1
- pop hits 1
- reindeers 1
- romantic 1
- santa claus 1
- snow 1
- spirited 1
- steady drumming rhythm 1
- string section harmony 1
- strong bass line 1
- tamil love songs 1
- tamil movie songs 1
- violin accompaniment 1
- winter wonderland 1
musiccaps_names (array) 3 ✖
- Music 2
- Christian music 1
- Humming 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Nenjam Pesuthey Male Humming song | A male singer sings this soaring melody. The song is medium tempo with a guitar accompaniment, strong bass line and a violin accompaniment. The song quality is poor and badly deteriorated. The song is a romantic love song from a Tamil movie. | 2014-03-17T01:41:42Z | VENGADASSALAM K | Photo Add | ["Humming", "Music"] | ["male singer", "soaring vocals", "bad quality audio", "tamil love songs", "poor audio quality", "medium tempo", "emotional", "passionate", "madly in love", "longing for you", "tamil movie songs", "movie soundtrack", "guitar accompaniment", "violin accompaniment", "no percussion instruments", "romantic", "deteriorated audio quality", "humming", "buzzing", "romantic", "love song", "spirited", "passionate", "bollywood music", "strong bass line"] | 1 | k3A5xX8yfig | 4295 | |
The Polar Express- "Believe" | A male singer sings this passionate and emotional melody. The song is medium tempo with a groovy bass line, steady drumming rhythm, piano accompaniment and an emotional string section harmony. The song is inspiring and emotional. The song is a Christmas classic and movie soundtrack. The audio quality is poor with a lot of hissing noises. | 2009-11-16T04:28:03Z | MECFilmProductions | Wow, almost 50,000 views! Thank you everyone! This took two weeks because of Windows Movie Maker, which kept malfunctioning. Then when I upload WMG Copyright kicks in. Ya well it can't beat me;) Anyway here it is in all it's splendor. It didn't turn out as well as I hoped but I have no more patience with it. Enjoy! I do not own anything, movie and music belong to respectful owners! | ["Christian music", "Music"] | ["male singer", "soaring vocals", "hissing noise", "string section harmony", "medium tempo", "movie soundtrack", "christmas", "inspiring", "steady drumming rhythm", "groovy bass line", "piano accompaniment", "orchestra playing", "inspiring", "motivational", "devotional", "christmas time", "winter wonderland", "poor quality audio", "pop hits", "christmas classics", "miracles", "santa claus", "christmas ade nature", "christmas carols", "emotional", "passionate", "reindeers", "snow", "philharmonic orchestra"] | 1 | nZ19mW-TMRk | 4551 |
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;