musiccaps_details (view)
2 rows where musiccaps_aspects contains "crowd cheering" and musiccaps_names contains "Vocal music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- crowd cheering · 2 ✖
- acoustic guitar accompaniment 1
- amateur recording 1
- beatbox 1
- bouncy 1
- cheerful atmosphere 1
- club music 1
- crowd hooting 1
- energetic 1
- enthusiastic 1
- female singer 1
- fresh 1
- fresh punchy 1
- funky 1
- funky bass line 1
- gig 1
- keyboard harmony 1
- live performance 1
- lucid vocals 1
- male voice singing 1
- medium tempo 1
- medium to uptempo 1
- perky vocals 1
- pop 1
- punchy 1
- slick drumming 1
- sound of chatter 1
- spirited 1
- upbeat groove 1
- youthful 1
musiccaps_names (array) 7 ✖
- Music 2
- Vocal music · 2 ✖
- Beatboxing 1
- Inside, large room or hall 1
- Singing 1
- Soul music 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Joel Turner Live. Coke Live 2006 | This audio contains someone beatboxing. Then a male voice starts singing loud and at a higher pitch. The crowd is cheering in the background. This song may be playing live during a beatbox performance. | 2006-04-15T06:32:50Z | lynxplayuh | Joel Turner Live. Coke Live 2006 | ["Beatboxing", "Music", "Speech", "Vocal music", "Inside, large room or hall"] | ["amateur recording", "beatbox", "male voice singing", "crowd cheering", "medium to uptempo", "cheerful atmosphere"] | 6 | ByF0pp-dVEo | 1309 | |
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 |
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;