musiccaps_details (view)

1 row where musiccaps_aspects contains "low quality", musiccaps_aspects contains "plastic impact", musiccaps_names contains "Music" and musiccaps_names contains "Scratch"

✎ View and edit SQL

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

CSV options: 

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;