musiccaps_details (view)
2 rows where musiccaps_aspects contains "smooth bass", musiccaps_aspects contains "unbalanced stereo image" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- low quality 2
- smooth bass · 2 ✖
- unbalanced stereo image · 2 ✖
- energetic cymbal crash 1
- epic 1
- female opera vocal 1
- haunting synth lead melody 1
- heartbeat kick pattern 1
- hip hop 1
- humming sound effects 1
- inspiring 1
- munching sound effects 1
- noisy 1
- powerful 1
- punchy snare 1
- shimmering chain sound effects 1
- simlpe hi hats 1
- simple piano chords 1
- skateboard sound effects 1
- sustained violin melody 1
musiccaps_names (array) 3 ✖
- Music 2
- Crunch 1
- Skateboard 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 | |
Cinnamon Toast Crunch: Pieces-Gone Television Commercial | The low quality recording features a munching and humming sound effect - like someone is enjoyably eating. At the very beginning, there is also a haunting synth lead melody and a smooth bass located in the left channel of the stereo image - making it unbalanced. | 2009-08-26T15:33:51Z | eatmedaily | ["Music", "Crunch"] | ["munching sound effects", "humming sound effects", "shimmering chain sound effects", "haunting synth lead melody", "smooth bass", "low quality", "unbalanced stereo image"] | 4 | Z9hnLYpypCU | 3344 |
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;