musiccaps_details (view)
2 rows where musiccaps_aspects contains "strong bass drum hits" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- strong bass drum hits · 2 ✖
- adrenaline rush 1
- amplified guitar harmony 1
- bad audio quality 1
- collectors choice 1
- dance rhythm 1
- distorted audio quality 1
- distorted guitar rhythm 1
- distorted harmony 1
- emotional 1
- energetic 1
- fast cars 1
- female singer 1
- funk music 1
- funky groove 1
- groovy bass line 1
- groovy music 1
- groovy sluice 1
- grunge keyboard tones 1
- hard rock music 1
- instrumental music 1
- keyboard accompaniment 1
- poor audio quality 1
- pristine audio quality 1
- retro pop 1
- rich and famous 1
- romantic 1
- sophisticated 1
- steady drumming rhythm 1
- steady marching rhythm 1
- strong bass line 1
- supercar documentary soundtrack 1
musiccaps_names (array) 3 ✖
- Music 2
- Angry music 1
- Funk 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
C7 Callaway Corvette Z06 Standing Mile Run at the NASA Runway | The song is an instrumental. The tempo is medium with a strong marching drum rhythm, with cymbal crashes and bass drum kicks, percussive bass line and amplified guitar playing rhythm. The audio quality is pristine and the soundtrack is high on adrenaline. | 2016-03-31T21:27:36Z | xxtamgxx | 2015 C7 Callaway Corvette Z06 Blasts Off at NASA Runway | ["Music", "Angry music"] | ["hard rock music", "strong bass drum hits", "rich and famous", "collectors choice", "sophisticated", "pristine audio quality", "instrumental music", "distorted guitar rhythm", "strong bass line", "groovy sluice", "steady marching rhythm", "amplified guitar harmony", "adrenaline rush", "supercar documentary soundtrack", "fast cars", "grunge keyboard tones"] | 1 | LMGpKPavV4Q | 2181 | |
FUNK!! Starr-Shes So Fine | A male singer sings this groovy melody. The tempo is medium with a strong bass line, steady drumming, keyboard playing a countermelody and various percussion hits. The song is funk pop in nature. The song has poor audio quality. | 2010-06-18T18:51:57Z | turtle101392 | Starr-Shes so Fine | ["Funk", "Music"] | ["female singer", "bad audio quality", "romantic", "emotional", "dance rhythm", "retro pop", "distorted audio quality", "poor audio quality", "distorted harmony", "keyboard accompaniment", "steady drumming rhythm", "strong bass drum hits", "groovy music", "energetic", "funky groove", "funk music", "groovy bass line"] | 1 | NZn4-gP2GiI | 2347 |
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;