musiccaps_details (view)
2 rows where musiccaps_aspects contains "poor audio quality", musiccaps_aspects contains "spirited" and musiccaps_aspects contains "various percussion hits"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- medium tempo 2
- poor audio quality · 2 ✖
- spirited · 2 ✖
- various percussion hits · 2 ✖
- african rhythms 1
- backup singers 1
- bad audio quality 1
- booming bass line 1
- dance hits 1
- dj 1
- emotional 1
- energetic 1
- exciting 1
- groovy dance music 1
- groovy dance rhythm 1
- groovy drumming rhythm 1
- guitar rhythm 1
- high pitched singing 1
- house mix 1
- instrumental music 1
- keyboard harmony 1
- love song 1
- male singer 1
- party all night 1
- party mix 1
- passionate 1
- percussive bass line 1
- ping pong shot tones 1
- pop hits 1
- romantic 1
- sweeping keyboard harmony 1
- techno dance rhythm 1
- trance music 1
- underground music scene 1
- vocal harmony 1
- xylophone 1
- youthful 1
musiccaps_names (array) 11 ✖
- Music 2
- Dance music 1
- Disco 1
- Drum and bass 1
- Dubstep 1
- Electronic dance music 1
- House music 1
- Maraca 1
- Pop music 1
- Singing 1
- Techno 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Kwabena Kwabena - Odo Nkoa (Feat. Kofi B) | A male singer sings this passionately with backup singers in vocal harmony. The song is medium tempo with a steady drumming rhythm, various percussion, percussive bass line, guitar rhythm and keyboard harmony . The song is passionate and romantic with a cool dance groove. The song has poor audio quality. | 2011-04-03T16:51:56Z | NaaKwame | Kwabena Kwabena - Odo Nkoa (Feat. Kofi B) Album: Dabi | ["Singing", "Music", "Pop music", "Maraca"] | ["male singer", "backup singers", "african rhythms", "poor audio quality", "guitar rhythm", "xylophone", "vocal harmony", "groovy drumming rhythm", "percussive bass line", "various percussion hits", "medium tempo", "groovy dance rhythm", "pop hits", "dance hits", "love song", "passionate", "emotional", "spirited", "bad audio quality", "high pitched singing", "romantic"] | 1 | IPO79GrOYjg | 1904 | |
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;