musiccaps_details (view)

3 rows where musiccaps_aspects contains "low quality" 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
micro ramp skateboard session The low quality recording features an Alternative/Indie song playing in the background while there are some skateboarding sound effects and foley in front. It is obviously a skateboarding compilation video. The song consists of groovy bass, energetic drums, wide synth key chords and wide synth pad chords, while the harmonizing female vocals are singing on top of it. It sounds fun and happy. 2007-05-20T16:16:22Z Øyvind Nilsen Micro ramp session in Trikkestallen, Trondheim 19.05.2007 ["Music", "Skateboard"] ["alternative/indie", "low quality", "skateboarding sound effects", "harmonizing female vocals", "energetic drums", "groovy bass", "wide synth keys chords", "wide synth pad chords", "fun", "happy"] 4 y_lfY0uzmr0 5421

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;