musiccaps_details (view)
2 rows where musiccaps_aspects contains "relaxing", musiccaps_author = 9 and musiccaps_names contains "Blues"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| David Byrd - HD Live! (Tropical Addiction Series 2012) Chicago Reggae Channel | This is the recording of a jazz reggae concert. There is a saxophone lead playing a solo. There is a keyboard and an electric guitar playing the main tune with the backing of a bass guitar. In the rhythmic background, there is an acoustic reggae drum beat. The atmosphere is groovy and chill. This piece could be playing in the background at a beach. It could also be included in the soundtrack of a summer/vacation/tropical themed movie. | 2012-08-16T15:30:54Z | Whitelion Promotio | http://chicagoreggaechannel.com presents: Tropical Addiction Series 2012 - Reggae At The Dock Produced by WhiteLion Promotion, Hosted by Madhatter Promotions August 1st, 2012 | ["Blues", "Effects unit", "Electric guitar", "Guitar", "Music", "Reggae", "Plucked string instrument", "Distortion"] | ["jazz", "reggae", "live performance", "concert", "saxophone", "keyboard", "electric guitar", "bass guitar", "acoustic drums", "groovy", "relaxing", "calm", "chill", "tropical", "jam"] | 9 | ALVS3Q_jNaU | 1108 | |
| ♫ Blues Music - Relaxing Romantic Sexy Slow Blues - Instrumental Guitar Blues Chill Out | This is an instrumental blues music piece. A clean electric guitar is playing a groovy solo while the bass guitar plays in the background. The acoustic drums are playing a slow tempo blues beat. The piece has a relaxing atmosphere. It could be playing in the background at a rock bar. This piece could also be playing in the soundtrack of a romantic movie especially during flirting scenes. | 2013-09-27T22:08:24Z | BLUES GUITAR NATION by KENNETH ST. KING | Blues Music, Blues songs. Blues Guitar. Sweet Old School slow Blues vibe for your enjoyment. Fashioned in the classic style of BB King, Eric Clapton, Peter Green, Mick Taylor, Mike Bloomfield and all my other boyhood Blues guitar hero's! Thanks! ~KJ St. King Gear used: Fender Hot Rod Telecaster, Fender Jeff Beck Strat, Fender Super Champ XD. Recorded using Garageband. A little sexy musica de striptrips! Photo use: Rodrigo Gianesi @ http://www.flickr.com/photos/perfectsonnet/ Photo use: My Huy Streetphotography @ http://www.flickr.com/photos/myhuyphoto/with/8685713769/ Photos used via Creative Commons License 2.0 @ http://creativecommons.org/licenses/by/2.0/deed.en_CA Great old school Blues guitar. Romantic, sexy and sensual sounding. Rich top notch tones from two of Fender's best guitars played through a superb Fender Amp. Best Relaxing Blues. Best Romantic Blues Guitar. Top Instrumental Blues Guitar. Best Blues Guitar. Blues Guitar Solo. Blues Music Guitar. Instrumental Blues. Blues Guitar Solo. Blues Licks. Blues Riffs. Hot Blues. Best Blues Solo. Blues Tones. For my overseas friends and friends from Non-English speaking countries, here are some descriptives in order to assist you in finding our sweet Blues! Blues Music la música blues موسيقى البلوز блюз Blues müzik muzica blues blues musikk ブルース音楽 blues μουσική Blues-Musik blues musika bluesmuziek Blues Guitar guitarra de blues Блюз гітара guitarra de blues blues gitar блюзової гітари blues gitarr blues gitara блюзовой гитары chitara blues guitarra blues Blues-Gitarre la guitare blues blues gitaar blues kytara | ["Blues", "Music"] | ["blues", "no singer", "instrumental", "clean electric guitar", "guitar solo", "bass guitar", "acoustic drums", "groovy", "chill", "relaxing", "easygoing", "slow tempo"] | 9 | QIjShFhrp6w | 2610 |
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;