musiccaps_details (view)
1 row where musiccaps_aspects contains "strummed acoustic guitar", musiccaps_names contains "Musical instrument", musiccaps_names contains "Plucked string instrument" 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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;