musiccaps_details (view)
3 rows where musiccaps_aspects contains "groovy", musiccaps_aspects contains "noisy" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- groovy · 3 ✖
- low quality 3
- noisy · 3 ✖
- fruity male vocal 2
- passionate 2
- boogie 1
- clapping 1
- cool 1
- country blues 1
- cover 1
- emotional 1
- folk 1
- funky 1
- funky electric guitars melodies 1
- funky piano melody 1
- groovy bass 1
- groovy electric guitar melodies 1
- harmonizing crowd vocals 1
- live performance 1
- mellow snare 1
- mono 1
- passionate male vocal 1
- playback beat 1
- punchy kick 1
- punchy snare 1
- shimmering cymbals 1
- shimmering hi hats 1
- smooth bass 1
- soft kick hits 1
- uptempo 1
- …
musiccaps_names (array) 15 ✖
- Music 3
- Singing · 3 ✖
- Blues 1
- Chorus effect 1
- Country 1
- Effects unit 1
- Gospel music 1
- Guitar 1
- Inside, small room 1
- Music of Latin America 1
- Musical instrument 1
- Plucked string instrument 1
- Rhythm and blues 1
- Swing music 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
LA Amp Show 2008 -- Carl Verheyen & Steve Trovato (Mercury Magnetics room) | The low quality recording features a cover of a boogie song sung by a passionate male vocalist, followed by funky electric guitar melodies. It sounds passionate, groovy, funky and the recording is in mono and noisy. | 2008-10-10T00:30:35Z | MercuryMagnetics | Mercury Magnetics - Carl Verheyen and Steve Trovato live jam at the Amp Show 2008 in the Mercury Magnetics room. Check out www.stevetrovato.com ! | ["Singing", "Effects unit", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Inside, small room"] | ["low quality", "noisy", "mono", "boogie", "cover", "funky electric guitars melodies", "passionate male vocal", "passionate", "groovy", "funky"] | 4 | 89eBh_Djflw | 899 | |
Blues, Country Blues, Rhythm & Blues | The low quality recording features a country blues song that consists of fruity male vocal singing over groovy electric guitar melodies, groovy bass, shimmering cymbals, mellow snare, soft kick hits and clapping. The recording is a bit noisy, as it is vintage, and it sounds passionate, groovy, uptempo and cool. | 2010-06-04T21:51:03Z | StrontiumDawg | 3 fine slices of blues music. Got my mojo workin' - Muddy Waters, Frankie - Missisipi John Hurt, Crawling up a hill - John Mayall | ["Blues", "Singing", "Swing music", "Country", "Music", "Rhythm and blues", "Music of Latin America"] | ["low quality", "country blues", "vintage", "noisy", "fruity male vocal", "groovy electric guitar melodies", "groovy bass", "shimmering cymbals", "mellow snare", "soft kick hits", "clapping", "uptempo", "groovy", "passionate", "cool"] | 4 | ZzyWbehtt0M | 3433 | |
phawulos tegegn in Oslo Norway | The low quality recording features a live performance of fruity male vocal singing over funky piano melody and beat played on playback that consists of punchy snare and kick hits, shimmering hi hats and smooth bass. The crowd is also singing along, harmonizing with the lead vocal. It sounds emotional and groovy, even though the recording is noisy. | 2015-01-01T02:26:13Z | GoSo GoSo | Oromo gospel song phawulos tegegn | ["Singing", "Gospel music", "Music", "Vocal music"] | ["low quality", "folk", "fruity male vocal", "funky piano melody", "playback beat", "shimmering hi hats", "punchy snare", "punchy kick", "smooth bass", "noisy", "live performance", "harmonizing crowd vocals", "emotional", "groovy"] | 4 | _78P-0zWJtg | 3445 |
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;