musiccaps_details (view)
2 rows where musiccaps_aspects contains "country", musiccaps_aspects contains "upright bass" 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 |
---|---|---|---|---|---|---|---|---|---|---|
Family Guy Live Action Intro Homemade Behind The Scenes | An acoustic drum set is playing a 16th note rhythm using the edge of his snare and a hihat sound opening and closing. A banjo is playing a fast melody along with a violin/viola playing the same melody. An upright bass is playing a walking bassline. This song may be playing in a funny tv-show. | 2013-12-10T20:13:41Z | CineFix - IGN Movies and TV | Go behind the scenes as Brock Baker, Christine Lakin, Colleen Ballinger and Mikey Bolts star in the live action Family Guy! Subscribe for new Homemade Movies every Tuesday - http://goo.gl/9AGRm Watch the Main Video: http://bit.ly/1iTGiC3 Watch the Side by Side Comparison: http://bit.ly/1d6Y8u3 It's Homemade Movies' Family Guy edition! We've taken this cartoon intro remade it shot for shot in real life! Including Brock Baker (McGoiter), Colleen Ballinger (Psycho Soprano), Christine Lakin (the voice of Joyce Kinney on the REAL Family Guy) and Mikey Bolts!!! Homemade Movies serves up creative remakes of your favorite movies, trailers and original songs. Every episode is an exact shot-for-shot remake created at home without any visual effects. It's homemade movie magic from acclaimed director Dustin McLean! Let us know in the comments what movie you want to see homemade next! -Starring- Brock Baker (McGoiter) -- http://bit.ly/1btPgiI Christine Lakin -- http://bit.ly/1e2BasY Colleen Ballinger (Psycho Soprano) -- http://bit.ly/1e3o92p Mikey Bolts -- http://bit.ly/1cmd0mL Tilt Tyree Brandon Breault Rena Strober Daniel Landau Evan Arnold Anna Neal Anne Brashier Brian Savage Steve Grubel Jill Angelone Kristen Pelz Produced by Ethan Cushing - Ethancushing.com Directed by Dustin McLean Edited by Benjamin Martin | ["Banjo", "Music"] | ["country", "banjo", "acoustic piano", "violin", "upright bass", "uptempo"] | 6 | -uaTK8sa5Ms | 99 | |
TOKAI BANJO HUMMING BIRD T-600R | A banjo is playing a solo along to an upright-bass laying a simple monotone bassline. This song may be playing in a bar with live music. This is an amateur recording. | 2010-08-18T14:06:27Z | kanpai2007 | アラン・セノーキーのサイン入り | ["Banjo", "Music"] | ["country", "banjo", "upright bass", "medium tempo", "amateur recording"] | 6 | ad6gQQ_0evk | 3560 |
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;