musiccaps_details (view)
3 rows where musiccaps_aspects contains "boomy kick", musiccaps_aspects contains "exciting" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- boomy kick · 3 ✖
- energetic 3
- exciting · 3 ✖
- claps 2
- low quality 2
- addictive 1
- addictive synth lead melody 1
- basketball 1
- commentary 1
- compilation 1
- crowd cheering 1
- echoing energetic male vocal 1
- energetic crash cymbals 1
- energetic male vocal 1
- filtered male vocal 1
- flat male vocal 1
- floor squeaking 1
- groovy 1
- groovy bass guitar 1
- high pitched piano chord progression 1
- laser synth riser 1
- laughing 1
- live performance 1
- passionate male vocal 1
- pop 1
- punchy snare 1
- r&b 1
- rock 1
- shimmering hi hats 1
- wide electric guitar chord progression 1
- wide male doubling vocals 1
musiccaps_names (array) 6 ✖
- Music 3
- Hip hop music 2
- Dance music 1
- Rock and roll 1
- Roll 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Foo Fighters - Rock and Roll - Kennedy Center Honors - Led Zeppelin | The low quality recording features a live performance of a rock song that consists of echoing, energetic male vocals that are singing over wide electric guitar chord progression, energetic crash cymbals, punchy snare, boomy kick and groovy bass guitar. It sounds energetic and exciting. | 2012-12-27T03:55:00Z | saveyouckufer | Foo Fighters - Rock and Roll - Kennedy Center Honors - Led Zeppelin Celebration Day http://amzn.to/TFuvtc | ["Music", "Roll", "Rock and roll"] | ["low quality", "echoing energetic male vocal", "wide electric guitar chord progression", "energetic crash cymbals", "punchy snare", "boomy kick", "groovy bass guitar", "rock", "live performance", "energetic", "exciting"] | 4 | Q8f6y2IcVg0 | 2600 | |
2014-15 NBA Game Winners and Buzzer Beaters (Regular Season) | The low quality recording features a compilation of basketball game highlights and it consists of crowd cheering and floor squeaking sound effects, followed by commentary of energetic male vocals, while a R&B song is playing in the background. The song consists of a boomy kick, claps, shimmering hi hats, high pitched piano chord progression and passionate male vocals, alongside wide male doubling vocals, singing over it. It sounds energetic and exciting. | 2015-04-18T23:22:44Z | Taras Polakoff | Song: Winner by Jamie Foxx All right reserved. | ["Music", "Speech", "Hip hop music"] | ["compilation", "basketball", "low quality", "crowd cheering", "floor squeaking", "r&b", "energetic male vocal", "commentary", "claps", "boomy kick", "shimmering hi hats", "high pitched piano chord progression", "passionate male vocal", "wide male doubling vocals", "energetic", "exciting"] | 4 | Y0_Ixl1d7oQ | 3249 | |
Pok'Chop - What You Bout (ft. Solo, Sly) (NEW BAY ORDER!! 2011) | The Pop song features a filtered male vocal, alongside flat male vocal, singing over some claps, boomy kick hits, laser synth riser and addictive synth lead melody. There are also some male laughing sounds. It sounds addictive, groovy and exciting - like something you would hear in clubs. | 2011-11-04T04:27:10Z | WeLovePokChop | Free Download: http://hulkshare.com/yjvnoy3zwhl2 | ["Music", "Dance music", "Hip hop music"] | ["pop", "addictive synth lead melody", "filtered male vocal", "flat male vocal", "claps", "boomy kick", "laser synth riser", "energetic", "laughing", "addictive", "groovy", "exciting"] | 4 | on18CWdmxn8 | 4657 |
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;