musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "groovy", musiccaps_aspects contains "punchy snare" and musiccaps_names contains "Rock music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- groovy · 3 ✖
- punchy snare · 3 ✖
- shimmering hi hats 3
- energetic 2
- groovy bass guitar 2
- low quality 2
- punchy kick 2
- rock 2
- aggressive 1
- aggressive electric guitar riffs 1
- arpeggiated electric guitar melody 1
- drum sticks countdown 1
- easygoing 1
- energetic cymbals 1
- flat male vocal 1
- fun 1
- groovy bass 1
- happy 1
- noisy 1
- punk 1
- reverberant male vocal 1
- short electric guitar chords 1
- soft crash cymbal 1
- soft kick hits 1
- unbalanced stereo 1
musiccaps_names (array) 8 ✖
- Music 3
- Rock music · 3 ✖
- Funk 2
- Progressive rock 2
- Punk rock 2
- Bass guitar 1
- Heavy metal 1
- Ska 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Afraid of Mice - Trans-parents | The low quality recording features a rock song that consists of reverberant male vocal singing over groovy bass, short electric guitar chords, punchy snare, soft kick hits, shimmering hi hats and soft crash cymbals. The reverb of the vocal is located in the right channel of the stereo image, which makes it sound interesting. It is easygoing and groovy. | 2011-09-25T11:40:58Z | exadaktylos | ["Funk", "Music", "Punk rock", "Rock music", "Progressive rock"] | ["low quality", "noisy", "rock", "reverberant male vocal", "groovy bass", "shimmering hi hats", "soft crash cymbal", "punchy snare", "soft kick hits", "short electric guitar chords", "easygoing", "groovy"] | 4 | 4refolVb_uQ | 610 | ||
Fed Up - "So Stupid" | The low quality recording features a punk song that consists of a groovy bass guitar, punchy kick, shimmering hi hats, energetic cymbals and aggressive electric guitar riffs. At the very beginning of the loop, there is a drum stick countdown, after which the bass drops. It sounds energetic, groovy and aggressive. | 2007-05-04T20:57:37Z | f1rstperson | This was the first music video I ever edited and filmed. It is simply awful, but it's fun too look back at the process and realize the things we learn. The band Fed Up was from Kansas City...this song was off their first EP....and they grew to be one of the best punk rock bands around (in my opinion). Check out the other video I did for them 3 years later...called "When Looking Back". | ["Bass guitar", "Heavy metal", "Music", "Punk rock", "Rock music", "Progressive rock"] | ["punk", "low quality", "groovy bass guitar", "punchy snare", "punchy kick", "shimmering hi hats", "energetic cymbals", "aggressive electric guitar riffs", "aggressive", "energetic", "groovy", "drum sticks countdown"] | 4 | ARXTRdKCupM | 1115 | |
Das Leben ist ein Rodeo Schule Illingen Hiss | The Rock song features a flat male vocal singing over arpeggiated electric guitar melody located in the right channel of the stereo image, groovy bass guitar, punchy kick and snare hits and shimmering hi hats. The stereo image is unbalanced because of the electric guitar, which makes it lean towards the right channel. It sounds energetic, groovy, happy and fun. | 2012-04-21T15:03:23Z | 55alwin | Ein Stopp-Motion Projekt der Klasse H6, GHRS Illingen | ["Funk", "Music", "Rock music", "Ska"] | ["rock", "groovy bass guitar", "punchy snare", "flat male vocal", "shimmering hi hats", "punchy kick", "arpeggiated electric guitar melody", "energetic", "groovy", "unbalanced stereo", "happy", "fun"] | 4 | JNwt0afB1fQ | 1998 |
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;