musiccaps_details (view)
3 rows where musiccaps_aspects contains "female voice", musiccaps_aspects contains "pop song", musiccaps_aspects contains "simple percussion" and musiccaps_names contains "Music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
The Carpenters - You | This pop song starts off with the backing singers singing vocables in harmony. This is backed by percussion playing a simple beat. The bass plays a flourish ending on the root note of the next chord. The string section plays high pitched notes. The piano plays a flourish of ascending notes before the main female voice starts to sing the main melody. This is accompanied by the percussion continuing with the simple beat. The string section fades away. The bass plays a descending walk down and ends on a high note. This song has a romantic feel. This song can be played in a romantic movie. | 2008-06-25T12:52:31Z | sisterlead02 | One of their beautiful songs! From A kind of hush album. | ["Singing", "Christian music", "Music"] | ["pop song", "female voice", "bass", "backing vocal harmony", "simple percussion", "piano", "string section", "slow tempo", "romantic theme"] | 0 | 6QHfXuVLhe0 | 755 | |
Lexa Raquel - One of a Kind (Official Music Video) | This pop song features a female voice singing the main melody. This is accompanied by percussion playing a simple beat. At the end of the first bar, the percussion pauses and a piano strikes one chord when the voice reaches her high pitch. The percussion resumes playing the simple beat. The bass follows the root notes of the chords. The piano plays chords in the background. A string section plays notes in the background filling the musicscape. This song has a romantic theme. This song can be played in a romantic movie. | 2012-05-11T05:43:42Z | DesertSolRecords | Lexa Raquel's official music video for "One of a Kind" The Tucson-based artist has steadily gained attention with her single "One of a Kind," which is currently #9 on the Billboard Hot Singles Sales Chart. The track is available for digital download on iTunes. The music video will soon be featured nationwide on the in-store media systems at Foot Locker and Forever 21 and can also be viewed on YouTube. Currently a freshman on a full music scholarship at the University of Arizona, the 19-year-old singer songwriter has sung in church choirs, gone on mission trips to build homes in Mexicali and on local Indian Reservations and worked part time as a Zumba instructor at a local gym, teaching Latin dance inspired fitness to local women. She is a former Associate Youth Music Director at her church and has taken first and second place for vocal performance in her denomination's district Fine Arts Festival. She has also coordinated a benefit concert for Honor Flight, a program which funds trips for World War II veterans to visit the WWII Memorial in Washington, DC. Raquel is currently working on her debut album, to be released on Desert Sol Records with renowned Tucson based musicians Kelvin Lewis (also her producer and musical director for live gigs) and guitarist Jonathan Thomas—who performed at her show and will be permanent parts of her band when she tours. For the past few years, she has developed a dynamic ongoing student mentor relationship with former American Idol finalist Crystal Stark. Lexa is quickly showing her own style while proving she can keep up with the big names like, Adele, Katy Perry, Alicia Keys, and Sara Bareilles. Lexa Raquel is the next big artist in the music industry who will shine above the rest. She truly is One of a Kind. For more music and information, visit http://lexaraquel.desertsolrecords.com/. Lexa Raquel Facebook page: https://www.facebook.com/pages/Lexa-Raquel/169053369789483 Follow Lexa on twitter: https://twitter.com/#!/lexaraquel | ["Music", "Zing"] | ["pop song", "female voice", "romantic theme", "simple percussion", "piano", "keyboard music", "moderate tempo", "strings sound"] | 0 | G2uCAwYS6w0 | 1689 | |
Juanita Bynum Holy | This gospel song features a female voice singing the main melody. There are other female voices singing in harmony with the main voice. This is accompanied by simple percussion playing a minimalist beat. The bass plays the root notes of the chords with no flourishes. There are strings playing fills in the background. A piano plays arpeggiated notes in between lines. The song is sung with a passionate voice. This song can be played in a movie with a Christian theme. | 2011-05-05T02:48:59Z | Adam Shelby | ["Music", "Wedding music"] | ["gospel song", "female voice", "pop song", "passionate emotion", "female backing voices", "string backing", "simple percussion", "simple bass", "piano"] | 0 | zRpPf62Zvto | 5476 |
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;