musiccaps_details (view)
3 rows where "youtube_published" is on date 2010-05-20
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- lo-fi 2
- acoustic guitar strumming 1
- bedroom recording 1
- broken 1
- cold 1
- distant 1
- distorted 1
- diy 1
- electronic 1
- energetic cymbal crash 1
- epic 1
- experimental 1
- female opera vocal 1
- finger snapping 1
- fingerstyle 1
- folk 1
- harsh 1
- hazy muffled 1
- heartbeat kick pattern 1
- hip hop 1
- indie 1
- inspiring 1
- knocking on guitar 1
- low quality 1
- metallic 1
- noisy 1
- powerful 1
- punchy snare 1
- room reverb 1
- shrill 1
- simlpe hi hats 1
- simple piano chords 1
- skateboard sound effects 1
- slightly 1
- smooth bass 1
- solo guitar 1
- steady tempo 1
- sustained violin melody 1
- techno 1
- trashy 1
- unbalanced stereo image 1
musiccaps_names (array) 11 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
La Monde (Len Faki) - Peak (Elephant Sequence EP B2) | A trashy, lo-fi sounding experimental techno track with a steady tempo and shrill, metallic sounds. The mood is cold and distant. Everything sounds a little broken. | 2010-05-20T18:34:55Z | TomSawyer1973 | La Monde (Len Faki) - Elephant Sequence EP B2 - Monoid 018 | ["Electronic music", "Music", "Electronic dance music", "Sidetone"] | ["shrill", "metallic", "steady tempo", "experimental", "electronic", "techno", "harsh", "lo-fi", "trashy", "distorted", "cold", "broken", "distant"] | 8 | 5hyRWertUbI | 683 | |
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 | |
diane cluck - focus on their eyes | Intentionally lo-fi bedroom recording of acoustic guitar strumming, knocking and fingerstyle playing. Finger snaps can also be heard. There is a slightly muffled room reverb over everything. Has an indie folk DIY aesthetic. | 2010-05-20T23:30:43Z | frinkianz | focus on their eyes | ["Tapping (guitar technique)", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["diy", "solo guitar", "acoustic guitar strumming", "room reverb", "lo-fi", "knocking on guitar", "fingerstyle", "finger snapping", "bedroom recording", "indie", "slightly", "hazy muffled", "folk"] | 8 | BI8YQ3ueD24 | 1226 |
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;