musiccaps_details (view)
2 rows where musiccaps_aspects contains "medium tempo" and "youtube_published" is on date 2008-07-21
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- medium tempo · 2 ✖
- dance groove 1
- digital drums 1
- digital strings 1
- female vocalist 1
- female voice singing 1
- folk song 1
- groovy bass lines 1
- latin music 1
- latin song 1
- mellifluous 1
- mellow 1
- mystic vibe 1
- pandeireta rhythm 1
- piano accompaniment 1
- r&b 1
- regional music 1
- regional pop 1
- romantic 1
- slick drumming 1
- soothing 1
- spanish guitar harmony 1
- spanish song 1
- sub bass 1
- triangle 1
- vocal backup 1
- world music 1
musiccaps_names (array) 4 ✖
- Flamenco 1
- Funk 1
- Music 1
- Music of Latin America 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 | |
No Scrubs by TLC [Lyrics] | This song contains a digital drum with a shaker sound and a triangle. A soft sub bass is playing along. In the background you can hear one continuous high tone from a digital string sound. Other strings and a piano are playing a simple repeating melody. The female voice is singing along with backing vocals in the background. This song may be playing loud while driving a car. | 2008-07-21T13:52:45Z | heartbraeker | LYRICS HERE, SUB FOR SUB :) A scrub is a guy that can't get no love from me And is also known as a buster Always talkin' about what he wants And just sits on his broke ass So (no) I don't want your number (no) I don't want to give you mine and (no) I don't want to meet you nowhere (no) I don't want none of your time and (no) [Chorus:] I don't want no scrub A scrub is a guy that can't get no love from me Hanging out the passenger side Of his best friend's ride Trying to holler at me I don't want no scrub A scrub is a guy that can't get no love from me Hanging out the passenger side Of his best friend's ride Trying to holler at me But a scrub is checkin' me But his game is kinda weak And I know that he cannot approach me Cuz I'm lookin' like class and he's lookin' like trash Can't get wit' no deadbeat ass So (no) I don't want your number (no) I don't want to give you mine and (no) I don't want to meet you nowhere (no) I don't want none of your time (no) [Chorus] If you don't have a car and you're walking Oh yes son I'm talking to you If you live at home wit' your momma Oh yes son I'm talking to you (baby) If you have a shorty but you don't show love Oh yes son I'm talking to you Wanna get with me with no money Oh no I don't want no (oh) No scrub No scrub (no no) No scrub (no no no no no) No scrub (no no) No [Chorus] [Chorus] [Chorus] [Chorus] | ["Funk"] | ["r&b", "digital drums", "digital strings", "sub bass", "triangle", "female voice singing", "medium tempo"] | 6 | VP1cB_AVu6c | 2999 |
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;