musiccaps_details (view)
1 row where musiccaps_aspects contains "euphoric", musiccaps_aspects contains "synth choir keys" and musiccaps_names contains "Christmas 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 |
---|---|---|---|---|---|---|---|---|---|---|
Christmas Sheet Music, Carols and Songs - Jingle Bells, Silent Night and more | The low quality recording features a Christmas song that consists of a widely spread, groovy piano melody, followed by synth choir keys. It sounds happy, joyful, fun and euphoric - as any Christmas song should sound. | 2010-11-20T00:56:22Z | Virtual Sheet Music | http://www.virtualsheetmusic.com/christmas Be sure to Like this Video! Enjoy Christmas with this collection of the most famous Christmas Carols for voice and piano: Jingle Bells, Joy to the World, We Wish you a Merry Christmas, O Christmas Tree, Carol of the Bells, O Come All Ye Faithful, Silent Night. Find all our Christmas Carols collection (thousands of titles!): http://www.virtualsheetmusic.com/christmas Click the link above to find hundreds of carols and Christmas sheet music songs for any instrument and ensemble (piano, violin, flute, trumpet, cello, viola, string quartet, brass quintet, etc). Discover and vote for your favorite Carol, then get in touch with us to receive free sheet music directly in your mailbox... just comment below, be sure to subscribe and thank you for watching! | ["Christmas music", "Music", "Happy music"] | ["low quality", "wide groovy piano melody", "synth choir keys", "happy", "joyful", "fun", "christmas song", "euphoric"] | 4 | 0lIETNZ_7sg | 206 |
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;