musiccaps_details (view)
4 rows where musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "groovy" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- acoustic drums · 4 ✖
- groovy · 4 ✖
- bass guitar 3
- male vocal 3
- electric guitar 2
- female vocal 2
- live performance 2
- melodic singing 2
- urban 2
- alternative r&b 1
- chill 1
- country music 1
- crowd cheering 1
- easygoing 1
- female choir 1
- groovy bass 1
- keyboard 1
- laid-back singing 1
- piano 1
- r&b 1
- rapping 1
- reggae 1
- scracthing 1
- seductive singing 1
- sensual 1
- sentimental 1
- story-telling mood 1
- trippy 1
- turntable 1
- western swing 1
musiccaps_names (array) 8 ✖
- Music 4
- Singing · 4 ✖
- Christian music 1
- Country 1
- Scratching (performance technique) 1
- Ska 1
- Song 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Brandy Sings: "Long Distance" | This is a live performance of an R&B music piece. There is a female vocalist singing melodically in the lead. Three female supporting vocals can be heard singing in the back. The melody is being played by the piano while the bass guitar plays a groovy bass line. The rhythm is provided by an acoustic drum beat. The atmosphere is sentimental. This piece can be used in the soundtrack of a romance movie involving a couple in a long distance relationship. | 2008-12-10T19:16:12Z | CBS | Brandy performs the single "Long Distance" from her much anticipated album, "Human." | ["Singing", "Christian music", "Music"] | ["r&b", "live performance", "female vocal", "melodic singing", "female choir", "piano", "bass guitar", "acoustic drums", "sentimental", "groovy", "urban"] | 9 | 3u9OO9Og0Gc | 517 | |
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 | |
Tinashe Performs '2 On' Live At The Viper Room | This is a live performance of an alternative R&B music piece. There is a female vocalist singing in a seductive manner in the lead. Later on, a male vocalist starts rapping. There is a groovy bass line in the background. The DJ is scratching the turntable. The rhythmic background is provided by an R&B acoustic drum beat. The atmosphere is sensual and the sound is urban. Sounds of the crowd cheering can be heard in the recording. | 2014-05-28T20:28:16Z | xoNecole | New artist Tinashe performs her hit song 2 On Live At The Viper Room in Los Angeles | ["Singing", "Scratching (performance technique)", "Music"] | ["alternative r&b", "live performance", "female vocal", "seductive singing", "male vocal", "rapping", "turntable", "scracthing", "groovy bass", "acoustic drums", "crowd cheering", "sensual", "groovy", "urban"] | 9 | _GQnXfIGNKY | 3455 | |
Jim Reeves on the Grand Ole Opry This May Well Be The Best Jim Reeves Video on Youtube www keepvid com | This is a country/western swing music piece. There is a male vocalist singing melodically in the lead with a story-telling attitude. The main tune is being played by the electric guitar with a bass guitar backing. The rhythm is being played by the acoustic drums. The atmosphere is easygoing. This piece could be playing in the background at an American roadside diner. | 2010-06-16T20:31:33Z | petedrakemusic | ["Singing", "Country", "Music", "Ska", "Song"] | ["country music", "western swing", "male vocal", "melodic singing", "story-telling mood", "electric guitar", "bass guitar", "acoustic drums", "easygoing", "groovy"] | 9 | ymGg5TA2YfM | 5437 |
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;