musiccaps_details (view)
1 row where musiccaps_aspects contains "key changes", musiccaps_aspects contains "male singer", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "poor audio quality"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Without Love (Harry/Ginny and Ron/Hermione) | A male singer sings this pop melody with backup singers with vocal harmony. The song is medium, with a keyboard accompaniment , steady drumming rhythm and strong bass line. The song is passionate and cheerful. The audio quality is poor. | 2007-12-24T21:37:03Z | iamobsessedandproud | okay, i know everyone and their sister has made this vid, but i just obtained some good clips and i really wanted to try them out. Plus i needed to make a fun vid to make up for the past few really serious ones. Enjoy, and Merry Christmas! Song: "Without Love" From: "Hairspray" Movie Soundtrack | ["Music", "Happy music"] | ["male singer", "medium tempo", "retro pop melody", "key changes", "percussive bass line", "passionate", "energetic", "modern pop", "steady drumming rhythm", "poor audio quality", "backup singers", "backup singers", "vocal harmony", "pop songs", "movie soundtrack", "friendship", "emotional", "passionate", "love song"] | 1 | kjmmzA6i5rk | 4350 |
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;