musiccaps_details (view)
2 rows where musiccaps_aspects contains "male rapper" and musiccaps_aspects contains "poor audio quality" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- adrenaline rush 2
- male rapper · 2 ✖
- poor audio quality · 2 ✖
- advertisement jingle 1
- beeping tones 1
- dance groove 1
- dance rhythm 1
- disc scratching tones 1
- distorted guitar lead 1
- dj 1
- energetic 1
- excitement 1
- fast tempo 1
- fats tempo 1
- glass shattering sounds 1
- groovy bass line 1
- grunge keyboard tones 1
- hard rock music 1
- high spirited 1
- instrumental music 1
- medium tempo 1
- passionate 1
- people dancing 1
- percussive bass line 1
- piano accompaniment 1
- rap hits 1
- retro rap hits 1
- story telling 1
- string rock drumming 1
- strong drumming rhythm 1
- tambourine percussions 1
musiccaps_names (array) 3 ✖
- Music 2
- Chink, clink 1
- Rapping 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Kai - Grind Low | A male rapper sings this exciting melody. The tempo is fast with a groovy bass line, grunge keyboard tones, strong drumming rhythm, various percussion hits and beeping tones. The song is pulsating and energetic. The audio quality is very poor. | 2008-03-06T13:46:34Z | kilickai | ["Music", "Rapping"] | ["male rapper", "poor audio quality", "beeping tones", "fast tempo", "people dancing", "retro rap hits", "tambourine percussions", "strong drumming rhythm", "percussive bass line", "story telling", "adrenaline rush", "passionate", "energetic", "excitement", "dance rhythm", "dance groove", "fats tempo", "poor audio quality", "rap hits", "grunge keyboard tones"] | 1 | 9STauy5DsC8 | 1009 | ||
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;