musiccaps_details (view)
5 rows where musiccaps_aspects contains "female singer", musiccaps_author = 8 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Charles aka Faithful Singing Pleasure P Did U Wrong | A low fidelity recording of a gospel choir with group vocals, a female singer, a male rapper, piano, a busy kick pattern, finger snaps and a slow tempo. The mood is hopeful and spiritual. | 2007-12-11T05:35:03Z | Nook4pound | Pleasure | ["Music", "Choir", "/t/dd00003", "Synthetic singing"] | ["low fidelity recording", "gospel", "choir", "piano", "group vocals", "female singer", "male rapper", "busy kick pattern", "finger snaps", "slow tempo", "hopeful", "spiritual"] | 8 | 01hjVJN9xCg | 111 | |
| Mia Rose - Just Us | Low-fidelity recording of a female singer displaying vocal virtuosity and melisma, accompaniment by strummed steel string acoustic guitar. | 2008-06-29T15:38:01Z | Mia Rose | Official site: http://www.Officialmiarose.com Official Twitter: http://www.twitter.com/officialmiarose Official Facebook: http://www.facebook.com/Miaroseworld Professional/Media Contact: info@officialmiarose.com Hey, Here's an original song of mine! I wrote it a couple of days ago! Hope you enjoy =) Mia Lyrics Sometimes in the dark of the night brings confusion you cant find the right from wrong you live for With everything changing, your feelings inside you wanna find comfort in somebody's eyes travelled through passed pain and finally what I found is That with you everything just melts away and its just us... Just us.... Sometimes when feel yourself slipping away You cant find the truth from the lie you live for With everything moving, your fears come alive you wanna find true love, in somebody's eyes wandered through hurricanes and finally what I found is That with you everything just melts away and its just us... Just us.... That with you my true love will always remain Just us Just us... | ["Singing", "Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["female singer", "melisma", "vocal virtuosity", "strummed acoustic guitar", "steel string guitar", "low-fidelity recording"] | 8 | KyRJP_fDrbk | 2136 | |
| jászsági népdalok (hungarian folk music) | A low fidelity recording of a drone instrument playing a chord while a female singer and double reed instrument double a technically challenging melody. | 2010-08-23T12:12:56Z | Jász Gyerek | 4 népdal | ["Traditional music", "Folk music", "Music"] | ["low fidelity", "female singer", "double reed solo", "drone", "technically challenging melody", "world music"] | 8 | RFKTlhbnfXA | 2683 | |
| Amira Willighagen - O Mio Babbino Caro - Andre Rieu - Maastricht - July 2014 | A female opera singer accompanied by an orchestra featuring string bass, harp and string ensemble. It sounds like it was performed in a concert hall. Dramatic. | 2014-07-13T11:01:00Z | pa1189j | ["Singing", "Music", "Opera"] | ["opera", "female singer", "orchestral accompaniment", "string bass", "harp", "string ensemble", "concert hall reverb", "dramatic"] | 8 | Z0htOHTOtHY | 3336 | ||
| Dorit Chrysler | Sustain Me | Moog Sound Lab | A quirky drum machine and warm synth bass provide the accompaniment for a female singer with noticeable reverb. A wild theremin with delay and wide aggressive vibrato enters to give the music a wild sci-fi feel. | 2011-05-26T20:19:04Z | Moog Music Inc | Dorit Chrysler dynamically plays an original composition on her customized Moog Etherwave Pro, a theremin manufactured by Moog Music from 2004-2006, for an ethereal Moog Sound Lab. To function as a one woman band, Dorit triggers a prerecorded backtrack on her laptop, adding vocals and Etherwave Pro theremin in real time. At her feet are a MF-104Z Analog Delay and an Akai Head Rush looper to add depth to her sound. Voila! See other Moog Sound Lab performances: http://bit.ly/MoogSoundLabVideos | ["Singing", "Sampler", "Music", "Theremin", "Synthesizer"] | ["female singer", "synth bass", "reverb", "theremin", "unconventional", "retro", "sci-fi", "quirky drum machine", "wide aggressive vibrato", "wild"] | 8 | ztfegVzqeCI | 5515 |
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;