musiccaps_details (view)
2 rows where musiccaps_aspects contains "adrenaline rush" and musiccaps_aspects contains "hard rock music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- adrenaline rush · 2 ✖
- hard rock music · 2 ✖
- instrumental music 2
- advertisement jingle 1
- amplified guitar harmony 1
- collectors choice 1
- disc scratching tones 1
- distorted guitar lead 1
- distorted guitar rhythm 1
- dj 1
- fast cars 1
- glass shattering sounds 1
- groovy bass line 1
- groovy sluice 1
- grunge keyboard tones 1
- high spirited 1
- male rapper 1
- medium tempo 1
- piano accompaniment 1
- poor audio quality 1
- pristine audio quality 1
- rich and famous 1
- sophisticated 1
- steady marching rhythm 1
- string rock drumming 1
- strong bass drum hits 1
- strong bass line 1
- supercar documentary soundtrack 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 | |
Get Cut With Glass - Safe Shoulder Workouts #1 | The song is an advertisement jingle. A male singer sings rapping vocals, with a strong drumming rhythm, piano accompaniment, groovy bass line and a distorted guitar playing an aggressive lead. The song is high on adrenaline and energetic. The song is a soundtrack for an ad and is of poor audio quality. | 2012-11-02T15:33:33Z | StrenghtHuman | Adam Kirby treinando com o Trainer Pro Charles Glass para o 2007 Mr. Veneza Beach | ["Music", "Chink, clink"] | ["instrumental music", "hard rock music", "dj", "poor audio quality", "glass shattering sounds", "disc scratching tones", "medium tempo", "string rock drumming", "distorted guitar lead", "piano accompaniment", "groovy bass line", "advertisement jingle", "high spirited", "adrenaline rush", "male rapper"] | 1 | N1Mxns_JJTk | 2318 |
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;