musiccaps_details (view)
2 rows where musiccaps_aspects contains "r&b/soul" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- r&b/soul · 2 ✖
- appealing male vocals 1
- easygoing 1
- emotional 1
- fun 1
- heartfelt 1
- jazz fusion 1
- jazzy drum kit 1
- live music 1
- live performance 1
- low quality 1
- mid tempo 1
- passionate 1
- passionate female vocal 1
- seductive saxophone 1
- wide harmonizing female background vocals 1
musiccaps_names (array) 4 ✖
- Music 2
- Singing · 2 ✖
- A capella 1
- Rattle (instrument) 1
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 | |
348 Leon Bridges "Brown Skin Girl" Live at the White Water Tavern | The music features a mix between jazz and soul music. The instrumental is easygoing and fun. A male singer with a seductive and appealing voice sings a fun melody. A saxophone plays a melody in the background that adds texture to the instrumental. The music is a live recording of a performance. | 2015-03-13T17:24:04Z | John Shaw | Young singer Leon Bridges writes his own material, much of it in a beautifully retro aesthetic of classic soul. Last Monday, he thrilled the standing-room-only crowd at the White Water Tavern in Little Rock, 3/9/15 | ["Singing", "Music", "Rattle (instrument)"] | ["jazz fusion", "r&b/soul", "easygoing", "appealing male vocals", "seductive saxophone", "mid tempo", "fun", "jazzy drum kit", "live music"] | 5 | wXmIm6Bq3Tc | 5273 |
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;