musiccaps_details (view)
2 rows where musiccaps_aspects contains "epic" and musiccaps_names contains "Skateboard"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- epic · 2 ✖
- electronic drums 1
- electronic/rap 1
- energetic cymbal crash 1
- female opera vocal 1
- heartbeat kick pattern 1
- hip hop 1
- inspiring 1
- low quality 1
- male choir sample 1
- medium tempo 1
- noisy 1
- powerful 1
- punchy snare 1
- simlpe hi hats 1
- simple piano chords 1
- skateboard sound effects 1
- smooth bass 1
- sustained violin melody 1
- unbalanced stereo image 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Kyle Walker Propeller Edit | This song contains electronic drums that sound overdriven with an aggressive kick and clap sounds as snare. A male choir sample is singing a chord melody with breaks in-between. The whole thing sounds urban and epic as if something heroic is happening. | 2015-07-03T17:36:03Z | Btrigga | Rights go to Vans and Thrasher Magazine. Like and subscribe for more edits. | ["Music", "Skateboard"] | ["electronic/rap", "electronic drums", "male choir sample", "epic", "medium tempo"] | 6 | ZaUaqnLdg6k | 3394 |
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;