musiccaps_details (view)
4 rows where musiccaps_aspects contains "groovy", musiccaps_aspects contains "groovy bass" and musiccaps_names contains "Ska"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- groovy · 4 ✖
- groovy bass · 4 ✖
- low quality 4
- passionate 4
- punchy kick 3
- shimmering hi hats 2
- addictive 1
- electric guitar chords 1
- energetic 1
- funky 1
- funky electric guitar melody 1
- harmonizing background vocals 1
- harmonizing male vocals 1
- jazz 1
- live performance 1
- muffled passionate male vocal 1
- noisy 1
- passionate male vocal 1
- regional mexican 1
- rock 1
- shimmering cymbals 1
- snappy rimshot 1
- strings melody 1
- synth pad 1
- tinny snare 1
- wide acoustic rhythm guitar 1
- wide acoustic rhythm guitars 1
- wide bouncy wooden percussion 1
- wide passionate harmonizing male vocals 1
musiccaps_names (array) 6 ✖
- Ska · 4 ✖
- Music 3
- Funk 1
- Music of Asia 1
- Pop music 1
- Rhythm and blues 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
El Pali - De Agujeritos! | The low quality recording features a regional Mexican song that consists of harmonizing male vocals singing over wide, bouncy wooden percussion, wide acoustic rhythm guitar, groovy bass, punchy kick and strings melody. It sounds passionate, energetic and groovy. | 2009-02-08T22:49:27Z | frager046 | ["Music", "Ska"] | ["regional mexican", "low quality", "wide bouncy wooden percussion", "wide acoustic rhythm guitar", "harmonizing male vocals", "groovy bass", "punchy kick", "strings melody", "passionate", "energetic", "groovy"] | 4 | 3rbWoeUg9yo | 508 | ||
Devil in Disguise | The low quality features a rock song that consists of a muffled passionate male vocal singing over wide acoustic rhythm guitars chords, shimmering cymbals, punchy kick and groovy bass. It sounds addictive, passionate and groovy - like something you would hear in pubs and bars during the 50s. | 2009-07-27T16:11:01Z | autopeerke | ["Music", "Rhythm and blues", "Ska"] | ["low quality", "rock", "muffled passionate male vocal", "wide acoustic rhythm guitars", "shimmering cymbals", "punchy kick", "groovy bass", "passionate", "addictive", "groovy"] | 4 | 9UOPRQhNzQ8 | 1014 | ||
Jon Cleary - When You Get Back (Live at Jazz Fest 2007) | The low quality recording features a live performance of a jazz song that consists of a wide passionate, harmonizing male vocals singing over punchy snare and kick hits, shimmering hi hats, groovy bass guitar, synth pad and funky electric guitar melody. It sounds funky, groovy and passionate. | 2009-04-24T23:01:22Z | Jon Cleary | Jon Cleary live at the New Orleans Jazz & Heritage Festival Follow Jon https://www.facebook.com/jonclearymusicofficial/ https://www.instagram.com/jonclearymusic/ https://twitter.com/jonclearymusic http://www.bandsintown.com/JonCleary | ["Ska"] | ["low quality", "noisy", "jazz", "live performance", "synth pad", "groovy bass", "funky electric guitar melody", "wide passionate harmonizing male vocals", "punchy kick", "punchy kick", "shimmering hi hats", "funky", "groovy", "passionate"] | 4 | _y07ENAx2_E | 3503 | |
A Love I Can Feel Riddim (26 songs) - Beres, Sanchez, Frankie Paul, Busy Signal, etc. | The low quality recording features a passionate male vocal, alongside harmonizing background vocals, singing over tinny snares, snappy rimshots, shimmering hi hats, groovy bass and electric guitar chords. It sounds groovy and passionate. | 2012-05-24T15:52:14Z | DJ Riddim | Timeless lover's rock riddim Facebook – https://www.facebook.com/DJRiddimNYC?ref=hl Instagram - http://instagram.com/djriddim_ Twitter – https://twitter.com/DJRiddim_ | ["Music of Asia", "Funk", "Music", "Pop music", "Ska"] | ["low quality", "passionate male vocal", "harmonizing background vocals", "tinny snare", "shimmering hi hats", "snappy rimshot", "groovy bass", "electric guitar chords", "groovy", "passionate"] | 4 | c-85TtcfVSI | 3672 |
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;