musiccaps_details (view)
1 row where musiccaps_aspects contains "box opening video", musiccaps_aspects contains "electric guitar", musiccaps_aspects contains "rock music" and musiccaps_names contains "Hi-hat"
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 |
---|---|---|---|---|---|---|---|---|---|---|
LITTLE TIKES Bounce & Slide Bouncer by JohnnyAndZoey | This is a box opening video. There is a male voice speaking and kids shouting. A rock music piece starts playing with a common sounding electric guitar tune and a simple acoustic drum beat. The atmosphere is generic. | 2015-07-08T19:43:27Z | Johnny and Zoey | The Little Tikes Bounce and Slider Bouncer is easy to set up and a whole lot of fun to play with. For young kids this bounce house by Little Tikes is virtually indestructible! Be sure to subscribe for more awesome videos: http://www.youtube.com/JohnnyAndZoey Here's a link to our toy channel! Enjoy. http://www.youtube.com/EpicToyChannel Check out some of our recent videos: PAW PATROL Power Wheels Lil Quad w/ Chase and Marshall "Official Paw Patrol Power Wheel 4 Wheeler" https://youtu.be/TooImgnyblU TOWING STACKED POWER WHEELS Including Mercedes Benz, Corvette, Dune Racer and Paw Patrol 4 Wheeler https://youtu.be/zB9_EyGmmlI DISNEYLAND VACATION Surprise with Cars Ride, Lightning McQueen, Cars Land & Splash Mountain https://youtu.be/wJFzaLwZpyE MERCEDES BENZ "Aria Child" Mercedes GL450 Power Wheels Style Car aka: Mercedes for Kids https://youtu.be/eQc7fYBKRd8 POWER WHEELS VIDEO Power Wheels Collection + Off Road Power Wheels http://youtu.be/RGXYUrMGR6I POWER WHEELS "Little Fireman" Saves Cute Kitty in "Power Wheels Dune Racer" http://youtu.be/_OhZiQyprIQ The New Power Wheels 2014 Corvette Stingray with Teenage Mutant Ninja Turtles http://youtu.be/lh0F3M77vWM Music by http://www.audionautix.com Song: Modern Rock Boy Creative Commons | ["Cymbal", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["box opening video", "male voice speaking", "clap sounds", "kids shouting", "rock music", "electric guitar", "acoustic drums", "generic", "common sounding"] | 9 | KjJj5-HvSvQ | 2111 |
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;