musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "flat male vocal", musiccaps_aspects contains "groovy bass" and musiccaps_aspects contains "groovy piano melody"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- flat male vocal · 2 ✖
- groovy bass · 2 ✖
- groovy piano melody · 2 ✖
- low quality 2
- 4 on the floor kick 1
- exciting background male vocal 1
- exotic 1
- funky guitar chords 1
- groovy 1
- live performance 1
- melodic background male vocals 1
- mono 1
- northern soul 1
- nostalgic 1
- passionate 1
- sentimental 1
- shimmering open hats 1
- urban latin 1
- vintage 1
- warm 1
- warm brass 1
- wide claps 1
- wide toms 1
- wooden percussive elements 1
musiccaps_names (array) 7 ✖
- Music 2
- Funk 1
- Music of Latin America 1
- Salsa music 1
- Singing 1
- Ska 1
- Soul music 1
youtube_published (date) 2 ✖
- 2009-11-24 1
- 2013-05-03 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dooley Silverspoon - Game Players : Northern Soul | The low quality recording features a northern soul song that consists of flat male vocals, alongside melodic male background vocals, singing over funky guitar chords, groovy piano chords, groovy bass, "4 on the floor" kick pattern and shimmering open hats. It is noisy and in mono and therefore vintage, but it also sounds warm, nostalgic and sentimental. | 2013-05-03T20:08:03Z | Mike Patterson | Dooley Silverspoon - Game Players : Northern Soul, with some Northern Soul Video Clips | ["Funk", "Music", "Ska", "Soul music"] | ["low quality", "vintage", "northern soul", "groovy bass", "groovy piano melody", "funky guitar chords", "shimmering open hats", "4 on the floor kick", "flat male vocal", "melodic background male vocals", "mono", "warm", "nostalgic", "sentimental"] | 4 | EUNTykrvpok | 1563 | |
Voltio - Medley De Salsa Carcelaria (Video En Vivo Desde Oso Blanco) | The low quality recording features a live performance of an urban latin song that consists of flat male vocal singing over groovy piano melody, groovy bass guitar, wooden percussive elements, wide toms, warm brass melody and widely spread claps. There is a short, exciting background male vocal in the middle of the loop. It sounds exotic, groovy and passionate. | 2009-11-24T21:07:11Z | VoltioVEVO | Music video by Voltio performing Medley De Salsa Carcelaria. (C) 2008 SONY BMG MUSIC ENTERTAINMENT (US Latin) LLC YouTube view counts pre-VEVO: 878 | ["Singing", "Music", "Music of Latin America", "Salsa music"] | ["low quality", "live performance", "urban latin", "wooden percussive elements", "wide toms", "warm brass", "groovy piano melody", "groovy bass", "flat male vocal", "wide claps", "passionate", "exotic", "groovy", "exciting background male vocal"] | 4 | FEuXIeWoCQQ | 1628 |
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;