musiccaps_details (view)
4 rows where musiccaps_aspects contains "bass guitar", musiccaps_author = 9 and musiccaps_names contains "Swing music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- bass guitar · 4 ✖
- acoustic drums 3
- acoustic guitar 2
- male vocals 2
- melodic singing 2
- albanian pop music 1
- choir 1
- clarinet 1
- concert 1
- cumbia 1
- dance 1
- devotional 1
- easygoing 1
- electric guitar 1
- electric guitat 1
- emotional 1
- female vocal 1
- gospel 1
- jewish 1
- latin 1
- latin dance 1
- latin percussion 1
- live performance 1
- lively 1
- male vocal 1
- piano 1
- playful 1
- reggae 1
- relaxing 1
- religious 1
- saxophone 1
- seductive singing 1
- strings 1
- trumpets 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ven a mi casa mama ( original ) HQ | This is a cumbia piece. There is a female vocal singing seductively joined by male back vocals singing in the chorus. The trumpet is playing the main melody joined by the piano and the bass guitar in the background. Latin percussion playing a cumbia beat provides the rhythmic background. The atmosphere of the piece is very playful. The ideal setting for this piece can be a latin dance course. | 2011-07-15T21:44:16Z | tecoloves | sonideros | ["Swing music", "Music"] | ["cumbia", "latin", "latin dance", "female vocal", "seductive singing", "male vocals", "choir", "latin percussion", "trumpets", "piano", "bass guitar", "playful", "dance"] | 9 | 7NnvEryyYdo | 840 | |
אברימי רוט - אלבום 'אמת ויציב' ♫ Rote&Green Sampler | This is a Jewish gospel music piece. There is a male vocalist singing melodically in the Hebrew language. A strings section is playing the melody with the acoustic guitar and the bass guitar in the backing. In the rhythmic background, the acoustic drums are playing a simple 4/4 beat. The atmosphere of this piece is religious/devotional. It could be used in Jewish religious events or related social media content. | 2013-09-16T12:16:05Z | אברימי רוט Avremi Roth | אברימי בפייסבוק: https://Facebook.com/AvremiR אברימי באינסטגרם: https://instagram.com/avremiroth אברימי בטוויטר: https://Twitter.com/avremi_roth אברימי ביוטיוב: https://YouTube.com/ybaudio להזמנת אירועים ומופעים: נייד: 054-8087150 דוא"ל: Avremiroth@gmail.com | ["Swing music", "Music", "Independent music"] | ["jewish", "gospel", "male vocal", "melodic singing", "strings", "acoustic guitar", "bass guitar", "acoustic drums", "religious", "emotional", "devotional"] | 9 | JU4CZ-GApu4 | 2010 | |
Bob Marley Jammin - One Love Peace Concert | This is the opening of a reggae song played live during a performance. There is a saxophone playing a solo as the lead. An electric guitar and a bass guitar play the tune in the background. The acoustic drums follow a basic, repetitive reggae beat. The song could be played at a bar or a coffee house. | 2007-03-12T07:33:30Z | ae86user | Marley making history in one love peace concert | ["Swing music", "Music"] | ["reggae", "live performance", "concert", "saxophone", "electric guitar", "bass guitar", "acoustic drums", "relaxing"] | 9 | XKp670Yh0E0 | 3177 | |
Klajdi Haruni - O bo bo (Kenga Magjike 2015) | This is an Albanian pop music piece. There are male vocals singing melodically in the Albanian language. The main theme is being played on the clarinet while there is a melodic backing composed of the acoustic guitar, the electric guitar and the bass guitar. The rhythm is provided by a laid-back acoustic drum beat. The atmosphere is lively. This piece could be used as an opening theme for an Albanian sit-com. | 2015-11-17T17:00:02Z | KlajdiHaruniVEVO | Music video for O bo bo (Kenga Magjike 2015) performed by Klajdi Haruni. Site: http://www.threedots.al Facebook: https://www.facebook.com/klajdiharunithreedots?fref=ts Copyright (C) 2015 Threedots Production. http://vevo.ly/fQQQYu | ["Singing", "Swing music", "Pop music"] | ["albanian pop music", "male vocals", "melodic singing", "clarinet", "acoustic guitar", "electric guitat", "bass guitar", "acoustic drums", "easygoing", "lively"] | 9 | t5fW1-6iXZY | 5004 |
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;