musiccaps_details (view)
1 row where musiccaps_aspects contains "kids talking", musiccaps_aspects contains "low quality", musiccaps_author = 4 and musiccaps_names contains "Maraca"
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 |
---|---|---|---|---|---|---|---|---|---|---|
How to make Recycled Toy Maracas - EP - simplekidscrafts - simplekidscrafts | The low quality recording features a plucked melody and groovy bass playing in the background and shimmering shakers and kids talking sound in the front. The recording is very noisy, as it was probably recorded with an old phone. It gives off happy and fun vibes. | 2009-09-05T18:52:54Z | SimpleCrafts - 5 Minute Crafts For All | In this episode we show you how to make Recycled Toy Maracas http://www.simplekidscrafts.com/ and English: http://www.manualidadesconninos.com/ Come Back to Simplekidscrafts Channel Every Day for Fun Easy Crafts and Miniature Dollhouse Accessories, Toys and Rooms for Barbie Dolls. I will wait for you every Wednesday and Saturday with new 5 Minute Crafts and Dolls stories just for you. Simple Kids Crafts (simplekidscrafts) is a video blog where we share crafts for dolls, dollhouse accessories, miniatures and toys for dolls (Barbie, Hairdorables, The Bellies, L.O.L Dolls, Monster High, Ever After High, Equestria Girls, Liv, Bratz, American Girl, Winx Club, Blythe, Pullip, LPS, Lalaloopsy, MLP, My Little Pony, Disney Princesses, Fulla, Arrosa, Razanne, Momoko, Obitsu, Dollfie, Moxie, Madame Alexander, Licca-chan, etc.) our crafts are mainly original crafts and made with recycled materials, each video is a 5 minute craft or in a craft in less than 5 minutes. XOXOXO, Merve | ["Music", "Maraca"] | ["shimmering shakers", "kids talking", "plucked melody", "groovy bass", "noisy", "low quality", "happy", "fun"] | 4 | APUDprnfOIs | 1114 |
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;