musiccaps_details (view)
2 rows where musiccaps_aspects contains "hip hop" and musiccaps_names contains "Jazz"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- hip hop · 2 ✖
- cow bell 1
- jazzy 1
- kick drum 1
- live performance 1
- male laughing 1
- minimal production 1
- pitched vocal sample 1
- repetitive male vocal 1
- repetitive piano melody 1
- shaker 1
- shimmering hi hats 1
- smooth bass 1
- soft kick 1
- soft snare 1
- triangle 1
- warm 1
- young male rapper 1
musiccaps_names (array) 4 ✖
- Jazz · 2 ✖
- Music 2
- Dance music 1
- Rhythm and blues 1
youtube_published (date) 2 ✖
- 2008-04-19 1
- 2009-06-11 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Oden Park ( Fresh Boyz ) - iSkateBoard ( HOT MUSIC ) | hip hop music featuring a young male rapper over a minimalist beat with only percussion such as cowbell, kick drum, shaker, and triangle. | 2009-06-11T07:28:41Z | Oden Park | iSkateBoard by Oden Park (there's a dance to this song)Yuh mainly jerk to it but dont forget to hit the Skate Board with it! Type iSkateboard dance....Twitter us @OdenPark http://itunes.apple.com/us/album/iskateboard/id425746911?i=425746950 | ["Jazz", "Music", "Rhythm and blues", "Dance music"] | ["hip hop", "cow bell", "kick drum", "young male rapper", "pitched vocal sample", "triangle", "male laughing", "minimal production", "shaker"] | 8 | 2RMOegT2Jn8 | 362 | |
Rafael Lechowsky y la Banda de Jazz - Concierto Radio 3 | The Hip Hip songs live performance consists of repetitive male vocal singing over repetitive piano melody, smooth bass, shimmering hi hats and soft kick and snare hits. It sounds jazzy and warm. | 2008-04-19T22:10:21Z | MrSlowFlow23 | Rafael Lechowsky y la Banda de Jazz - Concierto Radio 3 | ["Jazz", "Music"] | ["hip hop", "live performance", "warm", "repetitive piano melody", "smooth bass", "repetitive male vocal", "shimmering hi hats", "soft snare", "soft kick", "jazzy"] | 4 | 3bg0iy-ypcw | 487 |
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;