musiccaps_details (view)

2 rows where musiccaps_aspects contains "noisy" and musiccaps_names contains "Skateboard"

✎ 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
$5 PENNY BOARD TEST RIDE! The low quality recording is a noisy and windy recording that has some asphalt sound effects in it and a wide, happy sounding background song added in postproduction. Sounds really loud and harsh, due to the wind. 2015-07-23T03:08:24Z Ronnie Sarmiento Support this channel: https://www.patreon.com/ronniesarmiento ►►►Follow Me! Email: iamronniesarmiento@gmail.com Twitter: @Supronnie Instagram: @Supronnie Snapchat: @Supronnie ►►►Longboard Setup: Anonymous Feather:http://anonymouslongboards.com/ Paris 180mm trucks: http://amzn.to/2sbdrjX Reds Bearings: http://amzn.to/2qywVxO Arbor Mosh Wheels: http://amzn.to/2qzvE9J #StayStoked - DISCLAIMER: This video and description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. This helps support the channel and allows us to continue to make videos like this. Thank you for the support! ["Music", "Skateboard"] ["low quality", "wide happy sounding background song", "wind", "noisy", "asphalt sound effect", "loud", "harsh"] 4 8m-a_6wLTkU 942
Longboarding: Malibu Invitational Slide Jam The low quality recording features a hip hop beat and some skateboard sound effects in the background. The beat consists of female opera vocalists that sing over punchy snare and kick hits, simple hi hats, energetic crash cymbals, simple piano chords, smooth bass and sustained strings melody. It sounds epic and powerful, almost inspiring. The stereo image is unbalanced, since the snare hits are panned a bit to the right channel, and overall the left channel is a bit louder. 2010-05-20T20:09:39Z Loaded Boards Longboarding event. A recap of the Malibu Invitational Longboard Slide Jam, hosted by Orangatang Wheels. Filmed by Adam Colton & Jonathan Jelkin Edited by http://www.JonathanJelkin.com Sponsored by: http://www.ParisTruckCo.com http://www.CometSkateboards.com http://www.StokedSkateboards.com http://www.FireballWheels.com ["Music", "Skateboard"] ["low quality", "hip hop", "female opera vocal", "punchy snare", "sustained violin melody", "heartbeat kick pattern", "simlpe hi hats", "simple piano chords", "smooth bass", "epic", "powerful", "skateboard sound effects", "noisy", "unbalanced stereo image", "energetic cymbal crash", "inspiring"] 4 BHDhHO7J-Oo 1224

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;