musiccaps_details (view)
2 rows where musiccaps_aspects contains "noisy", musiccaps_aspects contains "passionate female vocal" and musiccaps_aspects contains "thin"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Don't Rain On My Parade: Maria Friedman | The low quality recording features a musical played on a small device that reproduces mono sound. The song consists of energetic drums, brass section and passionate female vocal singing on top of it. It sounds noisy, muffled and thin, as it was probably recorded with a poor quality microphone. | 2009-10-11T01:25:06Z | LadyLizaElliott | Maria Friedman sings Don't Rain on My Parade in the concert, Music in the Park, featured on Lesley Garrett: Music from the Movies Disclaimer: I do not own the footage, I am uploading this purely to show the fantastic performance, and this concert is available on DVD, but in Region 2, so it is tricky for us stuck in America. Credit is due to the BBC, EV CLASSICS, Lesley Garrett, and all others affiliated with this concert. The footage used is from the MUSIC FROM THE MOVIES concert featured on the BONUS features of Lesley Garrett's DVD MUSIC IN THE PARK. Special Thanks to Dress Circle Featured Performer: Maria Friedman Song: 'Don't Rain on My Parade' by Jule Styne from FUNNY GIRL | ["Singing", "Gospel music", "Music"] | ["low quality", "live performance", "muffled", "thin", "orchestral", "passionate female vocal", "mono", "musical", "energetic drums", "brass section", "noisy"] | 4 | HVsXJDR1_Lw | 1808 | |
Before They Fade Away - Rebecca Pham (Official Music Video) | The low quality recording features a passionate female vocalist singing over a hollow piano melody. It sounds thin and noisy, and you can really hear the unprofessional recording technique, especially in vocals. | 2012-10-08T03:59:25Z | randomjlt | FREE MP3: http://wfurl.com/f97fd81 I had the honour of working with the talented Rebecca Pham on her first music video (and mine too). Follow me on Twitter: www.twitter.com/randomjlt Written and Performed by Rebecca Pham Directed/filmed/edited by Jay Turchansky With thanks to Harley Kennett and Drew Zielsdorf for their acting help, and to Alvin Yu for his cameo appearance. Mixed by Elisha Pham ===================== Lyrics Do the see the pain in her eyes? Or that she's been down this road so many times? And all she needs is somebody to believe in her But we just pass her by How can we say That we don't know about her pain? Turn your eyes right here Lend that listening ear Before she fades away Do you see the burden he bares? That for him, there is nobody there And all he needs is somebody's one good deed But we act as if we don't even care How can we say That we don't know about his pain? Turn your eyes right here Lend that listening ear Before he fades away How can we say That we don't know of all their pain? Turn your eyes right here Lend that listening ear Before they fade away Turn your eyes right here And lend that listening ear Before they fade away So that we can be their change | ["Music", "Sad music"] | ["low quality", "noisy", "hollow piano melody", "emotional", "sad", "heartfelt", "passionate female vocal", "thin"] | 4 | jjg0TCq3wbY | 4279 |
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;