musiccaps_details (view)
3 rows where musiccaps_aspects contains "ambient room noises" and musiccaps_aspects contains "groovy music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 57 ✖
- ambient room noises · 3 ✖
- groovy music · 3 ✖
- instrumental music 2
- live performance 2
- passionate 2
- poor audio quality 2
- adrenaline rush 1
- amateur jazz musician 1
- amateur musician 1
- average audio quality 1
- body movement noises 1
- choreography sounds 1
- country music 1
- cowboys 1
- dance rehearsal 1
- dance studio 1
- echoes 1
- electric guitar 1
- emotional 1
- encouraging vocals 1
- energetic 1
- energetic dancing sounds 1
- epic stories 1
- excited 1
- fast tempo 1
- female sounds 1
- female vocals 1
- footsteps 1
- groovy 1
- guitar band 1
- guitar pick percussions 1
- guitar solo 1
- gunslingers 1
- heroes and villains 1
- high energy 1
- hip hop dance song 1
- jam session 1
- jazz musician 1
- keyboard accompaniment 1
- legends 1
- live audience 1
- male singers love performance 1
- medium tempo 1
- people cheering 1
- people talking 1
- rhythm guitars 1
- scratching tones 1
- song covers 1
- story tellers 1
- strings scratched with plectrum percussions 1
- suspense 1
- tap dancing 1
- techno drumming rhythm 1
- tense 1
- the wild west 1
- unimpressive 1
- vocoder 1
musiccaps_names (array) 8 ✖
- Music 3
- Guitar 1
- Harmonic 1
- Musical instrument 1
- Plucked string instrument 1
- Singing 1
- Strum 1
- Tap 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Good, the Bad and the Ugly / Reel Matawa by California Guitar Trio & Montreal Guitar Trio | The song is an instrumental. The song is medium tempo with a guitar playing lead and several guitarists playing harmony and accompaniment and a pick scratching guitar strings producing a percussive line. The song is immersive and has a classic country gun fight duel vibe to it. The song has ambient room noises. | 2009-11-19T18:55:29Z | MG3 : Montréal Guitare Trio / Montreal Guitar Trio | Montreal Guitar Trio & California Guitar Trio performed The Good, the Bad and the Ugly by Ennio Morricone followed by the Reel Matawa by Richard Forest at Palais Montcalm in Quebec City, October 23, 2009. | ["Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["guitar band", "guitar solo", "scratching tones", "guitar pick percussions", "song covers", "strings scratched with plectrum percussions", "live performance", "live audience", "ambient room noises", "echoes", "average audio quality", "groovy music", "instrumental music", "country music", "tense", "suspense", "gunslingers", "groovy", "story tellers", "the wild west", "emotional", "passionate", "heroes and villains", "legends", "epic stories", "electric guitar", "rhythm guitars", "cowboys"] | 1 | 3w3fD54bNvU | 521 | |
Shake it up | A hip hop dance song with female vocals plays as a dance track for three dancers. The song is fast tempo with faint audio signal with a lot of ambient room noises like footsteps sounds,body movements sounds and ambient room noise. The audio quality is very poor. | 2012-01-11T00:31:05Z | THESPACETV | shake it up | ["Music", "Tap"] | ["live performance", "dance studio", "tap dancing", "groovy music", "live performance", "high energy", "adrenaline rush", "choreography sounds", "encouraging vocals", "footsteps", "people cheering", "female sounds", "ambient room noises", "body movement noises", "hip hop dance song", "female vocals", "poor audio quality", "dance rehearsal", "instrumental music", "fast tempo", "energetic dancing sounds"] | 1 | jy0gitU1BFA | 4289 | |
More Bounce To The ounce Rendition | A male singer sings this vocals with a vocoder. The song is medium tempo with a groovy techno drumming rhythm and keyboard accompaniment. The song is passionate but an amateurish production. The audio quality is very poor. | 2007-11-24T00:35:38Z | TalkBoxerDX | Me playing the talkbox first run! This is shout out to all my talk boxers out there! and to TRCP my dads band! also wanna give a special shout out to curbswirvin if it wasn't for him i wouldn't be doing it! | ["Singing", "Music", "Harmonic"] | ["vocoder", "male singers love performance", "poor audio quality", "jam session", "amateur jazz musician", "medium tempo", "amateur musician", "jazz musician", "keyboard accompaniment", "groovy music", "techno drumming rhythm", "poor audio quality", "people talking", "unimpressive", "excited", "energetic", "passionate", "ambient room noises"] | 1 | xL7Krm6FSWE | 5320 |
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;