musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "enthusiastic", musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- enthusiastic · 4 ✖
- medium tempo · 4 ✖
- passionate · 4 ✖
- dance music 2
- emotional 2
- poor audio quality 2
- romantic 2
- wedding music 2
- acousitc guitar 1
- acoustic guitar strumming 1
- bachata 1
- bad quality audio 1
- bass guitar 1
- bongos 1
- cello 1
- cheerful 1
- composer 1
- congas 1
- crowd chatter 1
- dance groove 1
- deteriorating audio quality 1
- electric rhythm guitar plays 1
- energetic 1
- exciting 1
- female backup 1
- foreign language 1
- groovy bass line 1
- groovy dance hits 1
- groovy music 1
- guitar lead 1
- …
musiccaps_names (array) 11 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dan Nguyen va Cat Tien hat Loi To Tinh De Thuong | A male vocalist sings this pop song. The tempo is medium with keyboard accompaniment ,steady drumming, groovy bass, congas and bongos percussion and acoustic guitar accompaniment with vocal backup. The sound quality of the audio is inferior and there is the sound of chatter in the background .The song is fresh, simple, breezy, romantic, passionate, sentimental and youthful with a dance groove. This song is Regional Pop. | 2015-07-28T01:31:19Z | Oanh Nguyen | ["Singing", "Music", "Wedding music"] | ["male vocalist", "medium tempo", "female backup", "soft pop", "dance groove", "dance music", "muffled sounds", "crowd chatter", "salsa music", "keyboard harmony", "congas", "bongos", "bass guitar", "intense drumming", "acousitc guitar", "muffled vocals", "inferior sound quality", "foreign language", "regional pop", "passionate", "emotional", "romantic", "enthusiastic"] | 7 | JWNWCKdfpzM | 2015 | ||
J.Mouret - Rondeau String Quartet | The song is an instrumental. The song is medium tempo with a violin, viola, cello playing a string harmony accompanied by an acoustic guitar strumming chords. The song is a western classical music piece. | 2012-06-04T17:03:48Z | cellony | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | ["violin", "viola", "cello", "acoustic guitar strumming", "poor audio quality", "wedding music", "party music", "string quartet", "string trio", "string harmony", "instrumental music", "western classical music", "live performance", "studio performance", "medium tempo", "exciting", "cheerful", "dance music", "composer", "enthusiastic", "passionate", "exciting"] | 1 | fxznho_kNPY | 3995 | ||
BACHATA MIX AVENTURA | A male Latin singer sings this passionate melody. The song is medium tempo with various Latin percussions, groovy bass line, keyboard harmony and a guitar playing lead. The song is romantic and a classic Latin dance groove. The song is a Latin dance hit with a deteriorating audio quality. | 2009-01-05T07:54:32Z | R G COCINA | BACHATA | ["Music", "Salsa music"] | ["male latin singer", "bad quality audio", "latin dance band", "deteriorating audio quality", "groovy dance hits", "retro latin hits", "medium tempo", "bachata", "vocal echoes", "latin percussions", "guitar lead", "keyboard tones", "enthusiastic", "emotional", "passionate", "romantic", "retro latin hits", "latin pop hits", "people dancing", "passionate", "romantic", "groovy bass line", "latin love hits", "wedding music", "people dancing", "latin dance hits", "latin dance music"] | 1 | qsRPTMXFGsA | 4830 | |
'For Little Jimmy' (Official Music Video) - Ron Killings aka WWE Superstar "R-Truth" | A male singer with a rough voice sings this hip hop dance song. The song is medium tempo with a distorted electric guitar playing rhythm, keyboard accompaniment, slick drumming rhythm, telephone ring tones and various percussion hits. The song ends with a fade . The song has poor audio quality. | 2013-02-10T14:09:09Z | RonKillingsTV | 'For Little Jimmy' official music video from Ron Killings aka WWE Superstar "R-Truth" #RTruth #WWE #ForLittleJimmy #RonKillings #LittleJimmy Subscribe to RonKillingsTV: https://www.youtube.com/channel/UCkK8dn3G5IxAigWgRbdJmyw Website: https://www.theofficialronkillings.com Merchandise: https://www.ronkillings.com Facebook: https://www.facebook.com/ronkillings Twitter: https://www.twitter.com/ronkillings Tik Tok: https://www.tiktok.com/ronkillings1 Youtube: https://www.youtube.com/ronkillingstv IG: https://www.instagram.com/ronkillings1 Booking info: ronkillingsbooking1@gmail.com https://www.textrke.com (fan text line) (310) 406-7100 Director IG handle(s): @shotbyreginald | ["Music", "Telephone bell ringing", "Inside, small room", "Inside, large room or hall"] | ["male singer", "rapping vocals", "hip hop music", "telephone ringing", "slick drumming rhythm", "song stops playing", "keyboard beep tones", "keyboard accompaniment", "story telling", "enthusiastic", "medium tempo", "rough male vocals", "energetic", "passionate", "poor audio quality", "groovy music", "electric rhythm guitar plays", "song fade"] | 1 | sgJT5lIFttM | 4970 |
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;