musiccaps_details (view)
4 rows where musiccaps_aspects contains "enthusiastic", musiccaps_aspects contains "keyboard harmony" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 77 ✖
- enthusiastic · 4 ✖
- keyboard harmony · 4 ✖
- energetic 3
- dance music 2
- fast tempo 2
- foreign language 2
- inferior audio quality 2
- male vocalist 2
- medium tempo 2
- people talking 2
- pop 2
- vocal backup 2
- acousitc guitar 1
- acoustic guitar accompaniment 1
- amateur recording 1
- bass guitar 1
- bongos 1
- bouncy 1
- bright 1
- cheering 1
- chirpy 1
- club music 1
- congas 1
- crowd chatter 1
- crowd cheering 1
- crowd hooting 1
- dance groove 1
- emotional 1
- female backup 1
- female singer 1
- folk song 1
- fresh 1
- fresh punchy 1
- funky 1
- funky bass line 1
- gig 1
- groovy bass line 1
- happy 1
- home video 1
- hooting 1
- inferior sound quality 1
- intense drumming 1
- intense electric guitar 1
- jarring 1
- live performance 1
- lively trumpets 1
- loud 1
- lucid vocals 1
- male singer 1
- muffled sounds 1
- muffled vocals 1
- party songs 1
- passionate 1
- people cheering 1
- peppy 1
- perky vocals 1
- pop rock 1
- popular songs 1
- punchy 1
- punchy drumming 1
- regional music 1
- regional pop 1
- rhythmic acoustic guitar 1
- rock 1
- rock and roll 1
- romantic 1
- rustling 1
- salsa music 1
- slick drumming 1
- soft pop 1
- sound of chatter 1
- spirited 1
- steady drumming 1
- straight bass lines 1
- upbeat groove 1
- vigorous vivacious 1
- youthful 1
musiccaps_names (array) 11 ✖
- Music 4
- Singing · 4 ✖
- Inside, large room or hall 1
- Music of Latin America 1
- Musical instrument 1
- Rock music 1
- Roll 1
- Ska 1
- Soul music 1
- Vocal music 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rock 'n' Roll Girls -- John Fogerty | A male vocalist sings this spirited rock and rock song. The tempo is fast with bright drumming, intense electric guitar feedback, keyboard harmony and rhythmic acoustic guitar with vocal backup. The song is upbeat, spirited, enthusiastic, vibrant, vivacious, buoyant and youthful with a dance groove. The sound quality is inferior making it difficult to understand the lyrics or the finer elements of this Rock and Roll song. | 2008-09-03T02:10:47Z | zanzkantdance | John Fogerty performs "Rock and Roll Girls" from Centerfield live in Oakland in 1986, set to various background videos. | ["Singing", "Music", "Musical instrument", "Rock music", "Roll", "Inside, large room or hall"] | ["male vocalist", "fast tempo", "intense electric guitar", "punchy drumming", "keyboard harmony", "vocal backup", "rhythmic acoustic guitar", "groovy bass line", "loud", "jarring", "inferior audio quality", "people cheering", "people talking", "energetic", "enthusiastic", "vigorous vivacious", "bright", "enthusiastic", "dance music", "pop", "pop rock", "rock", "rock and roll"] | 7 | 1ZaxqZMs21M | 287 | |
Shira Choir Rocking it away with Pinky Weber Music by Pinny Ostreicher | A male vocalist sings this spirited song. The tempo is fast with trumpets, keyboard harmony, steady drumming and simple bass lines along with vocal backup. The song is happy, energetic, enthusiastic, popular, peppy, vivacious and celebratory. There are sounds in the background of people talking, hooting, cheering and scuttling and rustling. This is a popular Folk/Regional song. | 2015-09-04T19:04:46Z | Go Jewish Music | At a Siyem in Upstate! | ["Singing", "Music", "Ska", "Music of Latin America"] | ["male singer", "fast tempo", "vocal backup", "popular songs", "hooting", "rustling", "home video", "amateur recording", "party songs", "foreign language", "lively trumpets", "keyboard harmony", "steady drumming", "straight bass lines", "vocal backup", "people talking", "cheering", "energetic", "happy", "enthusiastic", "home video", "inferior audio quality", "folk song", "regional music", "happy", "peppy", "chirpy"] | 7 | 1hABzqBHh7w | 297 | |
Sallie Ford and the Sound Outside at The Crystal Ballroom 5-23-09 | A female vocalist sings this perky pop. The tempo is medium with rhythmic acoustic guitar , groovy bass lines, keyboard accompaniment and enthusiastic drumming. The song is simple, dulcet, fresh, peppy, youthful, vibrant and punchy with sounds of crowd hooting and cheering and talking. This song is a Pop song. | 2009-05-27T05:02:05Z | ConcordKurve | Great video of Sallie Ford and the Sound Outside singing "Not an animal" at the Crystal Ballroom. They opened for the Avett Brothers on May 22 and 23, 2009. | ["Singing", "Music", "Soul music", "Vocal music"] | ["female singer", "medium tempo", "club music", "keyboard harmony", "lucid vocals", "enthusiastic", "live performance", "energetic", "slick drumming", "spirited", "crowd cheering", "sound of chatter", "gig", "upbeat groove", "punchy", "fresh", "crowd hooting", "perky vocals", "acoustic guitar accompaniment", "funky bass line", "slick drumming", "keyboard harmony", "funky", "youthful", "fresh punchy", "bouncy", "pop"] | 7 | I-Z3gB6pfIA | 1859 | |
Dan Nguyen va Cat Tien hat Loi To Tinh De Thuong | A male vocalist sings this pop song. The tempo is medium with keyboard accompaniment ,steady drumming, groovy bass, congas and bongos percussion and acoustic guitar accompaniment with vocal backup. The sound quality of the audio is inferior and there is the sound of chatter in the background .The song is fresh, simple, breezy, romantic, passionate, sentimental and youthful with a dance groove. This song is Regional Pop. | 2015-07-28T01:31:19Z | Oanh Nguyen | ["Singing", "Music", "Wedding music"] | ["male vocalist", "medium tempo", "female backup", "soft pop", "dance groove", "dance music", "muffled sounds", "crowd chatter", "salsa music", "keyboard harmony", "congas", "bongos", "bass guitar", "intense drumming", "acousitc guitar", "muffled vocals", "inferior sound quality", "foreign language", "regional pop", "passionate", "emotional", "romantic", "enthusiastic"] | 7 | JWNWCKdfpzM | 2015 |
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;