musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "groovy bass lines" and musiccaps_aspects contains "mellifluous" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- groovy bass lines · 2 ✖
- mellifluous · 2 ✖
- soothing 2
- dance groove 1
- electric guitar melody 1
- emotional 1
- engaging 1
- fast tempo 1
- female vocalist 1
- folk song 1
- inspiring 1
- instrumental 1
- keyboard harmony 1
- latin music 1
- latin song 1
- medium tempo 1
- mellow 1
- mystic vibe 1
- pandeireta rhythm 1
- piano accompaniment 1
- pleasant 1
- pleasant melody 1
- pop 1
- regional music 1
- regional pop 1
- rhythmic acoustic guitar 1
- romantic 1
- simple 1
- simple melody 1
- slick drumming 1
- spanish guitar harmony 1
- spanish song 1
- steady drumming 1
- steady rhythm 1
- string instruments 1
- vocal backup 1
- world music 1
musiccaps_names (array) 4 ✖
- Music 2
- Flamenco 1
- Music of Latin America 1
- Ping 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Las Chuches - Amor, amor, amor | A female vocalist sings this romantic song in a foreign language that sounds like Spanish. The tempo is medium with a melodious guitar accompaniment, slick drumming, piano accompaniment, steady bass line and pandeireta rhythm. The song is soft, mellow, catchy, emotional and soothing. This song is a Folk Pop/Regional Pop song. | 2008-07-21T00:44:11Z | Faico90 | Las chuches como siempre derroxando arte | ["Flamenco", "Music", "Music of Latin America"] | ["female vocalist", "medium tempo", "regional pop", "regional music", "folk song", "spanish song", "latin song", "spanish guitar harmony", "groovy bass lines", "slick drumming", "latin music", "piano accompaniment", "pandeireta rhythm", "romantic", "mellifluous", "soothing", "mellow", "world music", "regional music", "dance groove", "vocal backup", "mystic vibe"] | 7 | 7_q36NyJtQY | 863 | |
NapoliTube | Maradona: palleggio con pallone, palla da tennis e pallina da ping pong! | RIP D10S! | This music is instrumental. The tempo is fast with rhythmic acoustic guitar, steady drumming, keyboard harmony, groovy bass line and electric guitar accompaniment. The music is mellow,nostalgic, emotional, simple, pleasant, charming and melodic pop. | 2013-11-19T20:26:34Z | NapoliTube | NAPOLITUBE | La Videoenciclopedia del Napoli: https://www.napolitube.eu SEGUI TUTTA LA STORIA DEL NAPOLI IN VIDEO SU https://www.napolitube.eu LA VIDEOENCICLOPEDIA DEL NAPOLI! | ["Music", "Ping"] | ["instrumental", "fast tempo", "rhythmic acoustic guitar", "pop", "steady drumming", "simple melody", "pleasant", "mellifluous", "inspiring", "emotional", "string instruments", "keyboard harmony", "steady drumming", "groovy bass lines", "electric guitar melody", "pleasant melody", "simple", "steady rhythm", "soothing", "engaging"] | 7 | aYoRcnmz6ZE | 3553 |
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;