musiccaps_details (view)
3 rows where musiccaps_aspects contains "booming bass line" and musiccaps_aspects contains "medium tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 46 ✖
- booming bass line · 3 ✖
- medium tempo · 3 ✖
- energetic 2
- exciting 2
- keyboard harmony 2
- passionate 2
- spirited 2
- amateur video quality 1
- ambient noise 1
- backup singers 1
- bad audio quality 1
- beeping tones 1
- damage rap music 1
- dj 1
- enthusiastic 1
- experimental music 1
- groovy 1
- groovy dance music 1
- groovy music 1
- gym talk 1
- home rap video 1
- house mix 1
- instrumental music 1
- latin dance music 1
- male rapper 1
- male singer 1
- missing harmony section 1
- party all night 1
- party mix 1
- percussive bass line 1
- percussive rhythm 1
- ping pong shot tones 1
- poor audio quality 1
- poor quality audio 1
- romantic 1
- singer self introduction 1
- story telling 1
- street noises 1
- sweeping keyboard harmony 1
- techno dance rhythm 1
- trance music 1
- typing sounds 1
- underground music scene 1
- various percussion hits 1
- vocal commentary 1
- youthful 1
musiccaps_names (array) 10 ✖
- Music 3
- Dance music 1
- Disco 1
- Drum and bass 1
- Dubstep 1
- Electronic dance music 1
- House music 1
- Reggae 1
- Single-lens reflex camera 1
- Techno 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
PupaJim Raggamuffin | A male Latin singer sings this cool melody. The song is medium tempo with keyboard accompaniment and steady drumming rhythm and a percussive bass-line with missing harmonies. The song is experimental and has bad audio quality. | 2013-08-23T21:58:26Z | bouby076 | Pupajim - Stand High Smokers Pack (2011) | ["Music", "Reggae"] | ["male singer", "booming bass line", "bad audio quality", "missing harmony section", "experimental music", "medium tempo", "latin dance music", "groovy music", "percussive bass line", "exciting", "enthusiastic", "passionate", "spirited", "romantic", "keyboard harmony", "percussive rhythm"] | 1 | 8wty3wJfmEY | 960 | |
Street Workout Featuring Mysonne "All Around The World" | A male singer sings this rap vocals with backup singers in harmony. The song is medium tempo with typing and beeping tones, followed by steady drumming rhythm, groovy bass and keyboard harmony. The song is energetic and exciting. The song has a home video intro followed by a rap song. | 2009-11-16T19:20:34Z | djvlad | - http://VladTV.com - A gym membership is not necessary to be brolic. You are now training with Mysonne. Dir: Vernon Baines | ["Music", "Single-lens reflex camera"] | ["typing sounds", "male rapper", "backup singers", "singer self introduction", "groovy", "damage rap music", "beeping tones", "booming bass line", "amateur video quality", "home rap video", "vocal commentary", "medium tempo", "ambient noise", "street noises", "energetic", "passionate", "story telling", "amateur video quality", "gym talk", "poor quality audio"] | 1 | JI26wmUPcrM | 1988 | |
Polycarpus - Ping Pong | The song is an instrumental. The tempo is medium with a booming bass line, grooving drum rhythm, sweeping keyboard harmony, sonic sound effects, and pin pong ball sound effects. The song has trance vibes and is very groovy. The song has poor audio quality. | 2009-12-20T21:38:12Z | Harder_Stylezz89 | Polycarpus - Ping Pong | ["Disco", "Drum and bass", "House music", "Music", "Techno", "Dubstep", "Electronic dance music", "Dance music"] | ["techno dance rhythm", "keyboard harmony", "poor audio quality", "trance music", "dj", "house mix", "party mix", "medium tempo", "instrumental music", "ping pong shot tones", "booming bass line", "various percussion hits", "groovy dance music", "exciting", "youthful", "energetic", "spirited", "party all night", "underground music scene", "sweeping keyboard harmony"] | 1 | hgGCfJoYDUU | 4124 |
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;