musiccaps_details (view)
2 rows where musiccaps_aspects contains "hissing tones" and musiccaps_aspects contains "love song" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- emotional 2
- hissing tones · 2 ✖
- love song · 2 ✖
- piano accompaniment 2
- poor audio quality 2
- acoustic pop hits 1
- asian soap opera 1
- classic pop hits 1
- deteriorated audio quality 1
- female singer 1
- hall reverb 1
- inspiring 1
- keyboard accompaniment 1
- live audience 1
- live concert 1
- male singer 1
- medium tempo 1
- modern pop 1
- motivational 1
- movie soundtrack 1
- music video 1
- percussion hits 1
- pop diva 1
- pop hit 1
- pop super hits 1
- romantic song 1
- shakers percussions 1
- soulful singing 1
- story telling 1
- subtle bass line 1
- subtle drumming 1
- tv show theme 1
musiccaps_names (array) 5 ✖
- Music 2
- Song 2
- Christian music 1
- Music of Asia 1
- Singing 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Adele crying at Royal Albert Hall - Someone like you live HD | A female pop star sings this lilting melody. The song is medium tempo with a piano playing accompaniment with a subtle bass line. The song is emotional and inspiring. The song is a modern pop hit played to a live audience. The song audio quality is poor and deteriorated. | 2012-09-29T19:17:31Z | Nil Iys | XL Records C. http://tinyurl.com/97zvsko Adele crying at Royal Albert Hall after singing someone like you! :) | ["Singing", "Christian music", "Music", "Song"] | ["female singer", "poor audio quality", "pop hit", "live concert", "emotional", "love song", "classic pop hits", "story telling", "live audience", "pop diva", "soulful singing", "piano accompaniment", "deteriorated audio quality", "hissing tones", "acoustic pop hits", "inspiring", "emotional", "love song", "motivational", "subtle bass line", "pop super hits", "modern pop", "hall reverb"] | 1 | nSinUcyFFqg | 4539 | |
Mouse Loves Rice | A male singer sings this emotional melody. The song is medium tempo with shakers and other percussion, keyboard accompaniment and a subtle bass line. The audio quality is poor. The song is romantic and emotional.the song is probably a music video or a movie sound track. | 2008-10-01T08:57:41Z | tropicalhut6 | Tammy Chen And Ambrose Hsu | ["Music of Asia", "Music", "Song"] | ["emotional", "male singer", "poor audio quality", "asian soap opera", "medium tempo", "romantic song", "love song", "movie soundtrack", "music video", "percussion hits", "piano accompaniment", "subtle drumming", "shakers percussions", "keyboard accompaniment", "tv show theme", "hissing tones"] | 1 | W85w938G5ZM | 3069 |
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;