musiccaps_details (view)
1 row where musiccaps_aspects contains "background pop instrumental", musiccaps_aspects contains "noisy", musiccaps_aspects contains "passionate" 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 |
---|---|---|---|---|---|---|---|---|---|---|
"Impossible"- Shontelle( Katrina cover) | The low quality recording features a cover of a pop song. It is sung by passionate female vocalists over pop instrumental playing in the background. It is noisy and it sounds roomy as it is probably recorded with a phone or a camera microphone, but it is also emotional, passionate and addictive. | 2010-06-21T03:28:53Z | katrina briones | I DO NOT OWN ANY COPYRIGHTS its so nice to be back. i was just busy these past few days. but yeah lil' somethin for yah guys. i miss youtube!. :) Subscribe to me! yay!. i love ya'll Lyrics: i remember years ago someone told me i should take caution when it comes to love i did, i did and you were strong and i was not my illusion, my mistake i was careless, i forgot i did and now when all is done there is nothing to say you have gone and so effortlessly you have won you can go ahead tell them tell them all i know now shout it from the roof top write it on the skyline all we had is gone now tell them i was happy and my heart is broken all my scars are open tell them what i hoped would be impossible, impossible impossible, impossible falling out of love is hard falling for betrayal is worst broken trust and broken hearts i know, i know thinking all you need is there building faith on love and words empty promises will wear i know (i know) and know when all is gone there is nothing to say and if you're done with embarrassing me on your own you can go ahead tell them tell them all i know now shout it from the roof top write it on the skyline all we had is gone now tell them i was happy and my heart is broken all my scars are open tell them what i hoped would be impossible, impossible impossible, impossible impossible, impossible impossible, impossible impossible, impossible | ["Singing", "Music", "/t/dd00004"] | ["low quality", "cover", "passionate female vocal", "background pop instrumental", "noisy", "roomy", "emotional", "passionate", "addictive"] | 4 | 2f7NnTVQzR0 | 395 |
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;