musiccaps_details (view)
2 rows where musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "triangle" sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- medium tempo · 2 ✖
- triangle · 2 ✖
- cheeky 1
- cheesy organ 1
- digital drums 1
- digital strings 1
- female voice singing 1
- jazzy 1
- lead trombone melody 1
- quirky 1
- r&b 1
- sub bass 1
- swing pattern 1
musiccaps_names (array) 3 ✖
- Brass instrument 1
- Funk 1
- Trombone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
P-Bone | Eric Westerink | PinkBondSmoke | Quirky, cheeky, jazzy music featuring a lead trombone melody, a triangle playing a swing pattern, a cheesy organ and a medium tempo. | 2012-03-17T08:33:10Z | Eric Westerink | P-Bone-solo with tape | P-Bone: Eric Westerink | Tape: Eric Westerink | Pink Panter, James Bond, Smoke on the water | Arranged by Eric Westerink | West Sound Music | www.ericwesterink.nl | ["Brass instrument", "Trombone"] | ["lead trombone melody", "triangle", "swing pattern", "medium tempo", "cheesy organ", "jazzy", "quirky", "cheeky"] | 8 | AtWf5OAE8aM | 1180 | |
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;