musiccaps_details (view)
1 row where musiccaps_aspects contains "noisy", musiccaps_aspects contains "plastic impact", musiccaps_author = 4 and musiccaps_names contains "Scratch"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Toy Cutting Velcro Cooking Playset Pizza, Hot Dog, Cake, Croissant, Muffin, Crepe | The low quality recording features a happy sounding background song playing in the background and some plastic impact, breaking and plastic scraping sound effects. It seems like it is a tutorial for a kids game. | 2015-01-24T22:36:08Z | Funformi | This toy playset featuring sliceable pizza, hot dog, cake and pastries is both educational and fun for young children to play. It develops their imagination through role-play, while helping to develop their fine motor skills, problem solving skills and memory, solving puzzles and memorizing the names of various foods and desserts, like pizza, hot dog, cake, muffin, criossant. It is also very affordable and great for both boys and girls. This toy is also like a puzzle for children teaching how to put the pieces back together correctly to make the foods whole again. Playland is a channel for babies and young children. It aims to entertain and educate using toys which help with learning colors, shapes, numbers, role-play, as well as to develop their fine motor skills, memory skills, and hand-eye co-ordination. More videos by Playland: Wooden Velcro Fruit and Vegetavles Slicing Playset https://www.youtube.com/watch?v=oNIGcC2P_oY Slicing velcro toy vegetables https://www.youtube.com/watch?v=tf_W-RkLFss Build-a-Burger Hamburger Velcro Toy Food Set https://www.youtube.com/watch?v=PoJ4RSQcnw0 Velcro Foods Cooking in Toy Oven https://www.youtube.com/watch?v=ex2FD8BWrvY Toy Cutting Fruit Velcro Cooking Playset https://www.youtube.com/watch?v=adzpqj5tH3Y Music by Silver Dolphin Music: https://www.youtube.com/user/silverdolphinmusic http://silverdolphinmusic.weebly.com/ https://soundcloud.com/silver-dolphin-music | ["Scratching (performance technique)", "Music", "Scratch"] | ["happy sounding background song", "noisy", "low quality", "plastic scraping sound effect", "breaking plastic sound effect", "plastic impact"] | 4 | k9w2aaNKenE | 4301 |
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;