musiccaps_details (view)
1 row where musiccaps_aspects contains "emotional", musiccaps_aspects contains "heartfelt", musiccaps_aspects contains "wide harmonizing female background vocals" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
VIRAL VIDEO- Perrie Edwards crying - perrie edwards cries on stage | Perrie Edwards Break Down | The low quality recording features a live performance of R&B/Soul song and it consists of passionate female vocal singing alongside widely spread harmonizing female background vocals. It sounds passionate, emotional and heartfelt. | 2015-08-19T20:22:11Z | VisuMedia | The stunning blonde showed Zayn Malik what he's missing in a tiny white playsuit - but couldn't contain her emotions Perrie Edwards has managed to keep a brave face on over the last few weeks, as she puts her heartbreaking split from fiance Zayn Malik behind her. But the star let her emotions get the better of her, and broke down in tears as she performed with her Little Mix bandmates on the Today Show today. Singing a solo for emotional song The End - heartbreakingly fitting given the circumstances - Perrie was forced to stop mid-way through as she was overcome with tears, with her best friends flocking round to comfort her. Fans caught the sad moment on camera, and they've rushed to share it online - sending their well wishes to the star. Jesy can be heard telling the crowd: "It's been a long day, we've had no sleep." One fan wrote on Twitter: "I just saw a video of Perrie Edwards crying and I started crying as well and I've been doing that for 20 minutes now." Another added: "Perrie Edwards is everything to me I'm so hurt by her crying today :'c my bby." The crowd quickly began shouting "We love you Perrie" as she struggled to overcome her emotions and carry on. However it followed another electric performance, as the stunning star put on an energetic show as she flashed her long legs in a white playsuit despite her recent heartbreak. Wearing a very revealing outfit, Perrie showed off her famous pins as she joined her Little Mix bandmates to perform their new single Black Magic on the Today show. Even after recently splitting from her fiancé, the singer looked to be great spirits as she smiled throughout the performance in New York. The girls have been spending some time in the US - including an appearance at the Teen Choice Awards - and their promo tour included a visit to fellow Brit James Corden. The chat show host comforted Perrie following her heartbreak, and pulled her close into a big hug. He said: "Are you OK? It has been tough few weeks." Perrie – who was dumped by her fiancé by text – said:… | ["Singing", "Music", "A capella"] | ["low quality", "live performance", "passionate female vocal", "wide harmonizing female background vocals", "r&b/soul", "passionate", "emotional", "heartfelt"] | 4 | At5v5ZZQHmw | 1178 |
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;