musiccaps_details (view)
2 rows where musiccaps_names contains "Music" and "youtube_published" is on date 2012-02-07
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- acoustic drums 1
- bass guitar 1
- causal 1
- chill 1
- drum brush hits 1
- electric guitar 1
- emotional 1
- fun 1
- funk jazz 1
- groovy 1
- groovy bass line 1
- guitar playing 1
- improvisation 1
- instrumental music 1
- jam session 1
- jazz festival 1
- jazz music 1
- keyboard 1
- keyboard accompaniment 1
- laid-back singing 1
- live performance 1
- male vocal 1
- memdium tempo 1
- playful 1
- poor audio quality 1
- reggae 1
- relaxing 1
- subtle jazz drumming 1
- trippy 1
musiccaps_names (array) 5 ✖
- Music · 2 ✖
- Blues 1
- Singing 1
- Soul music 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Big Mountain - Baby I Love Your Way (1994) | This is a reggae music piece. There is a male vocalist singing in a laid-back manner. The keyboard is playing the main tune. The electric guitar is being strummed in a staccato off-beat pattern. There is a groovy bass line being played by the bass guitar. The rhythmic background consists of a reggae acoustic drum beat. The atmosphere is chill and trippy. This piece could be used in the soundtrack of a romance movie with a tropical setting. | 2012-02-07T22:10:21Z | BillyStollNewsletter | While recording our second album "Unity", we were approached by Ron Fair of RCA Records, resulting in this remake of Peter Frampton's "Baby I Love Your Way" for the "Reality Bites" movie soundtrack album. | ["Singing", "Music", "Soul music"] | ["reggae", "male vocal", "laid-back singing", "keyboard", "electric guitar", "bass guitar", "acoustic drums", "chill", "trippy", "groovy"] | 9 | DvN5813H7Bo | 1519 | |
"Slow" by Shane Theriot at the Atlanta Institute of Music | The song is an instrumental. The tempo is medium with subtle jazz drumming, keyboard accompaniment, groovy bass line and an electric guitar playing lead. The song is relaxing and groovy. The song is a live jazz instrumental performance with poor audio quality. | 2012-02-07T20:28:49Z | aimmedu | In their stellar performance at the Atlanta Institute of Music, guitarist Shane Theriot, bassist Adam Nitti, drummer Kirk Covington, and keyboardist Mike Whittaker perform Shane Theriot's sultry and bluesy "Slow". Be sure to check out other clips from this concert on the Atlanta Institute of Music's YouTube channel! And don't forget to visit our website at aim-music.com! | ["Blues", "Music", "Tender music"] | ["live performance", "instrumental music", "jazz festival", "jam session", "improvisation", "fun", "funk jazz", "groovy bass line", "keyboard accompaniment", "guitar playing", "subtle jazz drumming", "emotional", "playful", "causal", "relaxing", "jazz music", "poor audio quality", "memdium tempo", "drum brush hits"] | 1 | LnczSOwV9Ds | 2221 |
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;