musiccaps_details (view)
3 rows where musiccaps_aspects contains "live performance", musiccaps_aspects contains "passionate" and musiccaps_names contains "/t/dd00004"
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- live performance · 3 ✖
- passionate · 3 ✖
- emotional 2
- low quality 2
- ambient crowd noise 1
- ballad 1
- blues music 1
- blues turnaround 1
- female singer 1
- fret noise 1
- groovy 1
- groovy synth bass 1
- guitar notes playing 1
- guitar playing 1
- heartbeat kick pattern 1
- heartfelt 1
- hissing ambient sound 1
- lilting vocals 1
- live audience 1
- love song 1
- madly in love 1
- mellow sustained strings melody 1
- noisy 1
- passionate female vocal 1
- passionate muddy female vocal 1
- poor audio quality 1
- pop 1
- pop diva 1
- pop song 1
- pop super hits 1
- punchy snare 1
- romantic 1
- singer talking 1
- soft crash cymbal 1
- soft hi hats 1
- soft piano melody 1
- song introduction 1
- soul music 1
- soul singer 1
- sustained stings 1
musiccaps_names (array) 4 ✖
- /t/dd00004 · 3 ✖
- Music 3
- Inside, large room or hall 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 North American Tour 2008 | A female singer sings this bluesy melody. The song is medium tempo with minimal guitar accompaniment and no other instrumentation. The song's medium tempo is very emotional and passionate. The song is a modern pop hit but with poor audio quality. | 2011-03-17T20:16:50Z | Viswijfable | This shortfilm was on the bonus disc. of 19. Directed by Charlie Robins © | ["Singing", "Music", "/t/dd00004", "Inside, large room or hall"] | ["female singer", "blues music", "live audience", "romantic", "hissing ambient sound", "madly in love", "love song", "passionate", "ambient crowd noise", "guitar playing", "singer talking", "song introduction", "blues turnaround", "fret noise", "pop song", "pop super hits", "pop diva", "poor audio quality", "guitar notes playing", "live performance", "lilting vocals", "soul singer", "soul music"] | 1 | B90BOtSOD2Q | 1210 | |
Charice crying while singing Maghintay Ka Lamang | The low quality recording features a live performance of a ballad song that consists of sustained strings, soft crash cymbals and soft piano melody. At the very end of the loop, there are passionate muddy female vocals. It sounds passionate, emotional and heartfelt, while it is a bit noisy too. | 2011-02-14T13:17:04Z | Hachie Simon | Please subscribe to my channel :) Gobless you! Maghintay Ka Lamang by Charice Pempengco on GMA SNBO presents Charice Home for the Valentines Special | ["Music", "/t/dd00004"] | ["low quality", "noisy", "live performance", "sustained stings", "passionate muddy female vocal", "soft piano melody", "ballad", "soft crash cymbal", "passionate", "emotional", "heartfelt"] | 4 | Wdtku1dqJo0 | 3115 | |
Nicole Scherzinger singing Phantom Of The Opera on Royal Variety Performance Dec. 14/11 | The low quality recording features a live performance of a pop song that consists of groovy synth bass, punchy snare, soft hi hats, heartbeat kick pattern, mellow sustained string melody and passionate female vocal singing over it. It sounds emotional, passionate and groovy thanks to that synth bass. | 2011-12-15T07:14:00Z | HeartOfWorship | December 14, 2011 Royal Variety Show John Owen-Jones "I'd like to report that not only is @NicoleScherzy lovely to work with but she sung the entire track LIVE. And she nailed it." Ramin Karimloo "She could and did sing that on her head. Was totally blown away and she was sick." 2 of the phantoms' Tweets about Nicole :) Nicole Scherzinger singing with the 4 phantoms Simon Bowman, Earl Carpenter, Ramin Karimloo and John Owen-Jones - in commemoration of the musical The Phantom Of The Opera's 25th year anniversary. Recorded on the 5th of December at The Lowry in Salford in the presence of Her Royal Highness The Princess Royal and aired on ITV this Wednesday evening - December 14, 2011. | ["Music", "/t/dd00004"] | ["low quality", "live performance", "groovy synth bass", "punchy snare", "heartbeat kick pattern", "mellow sustained strings melody", "passionate female vocal", "soft hi hats", "groovy", "passionate", "emotional", "pop"] | 4 | pmdoDcNBt0E | 4733 |
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;