musiccaps_details (view)
2 rows where musiccaps_aspects contains "female vocal", musiccaps_names contains "Music" and musiccaps_names contains "Scratching (performance technique)"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
FREESTYLE-OLD SCHOOL AND LATIN HOUSE MIX 2011 ( MIX BY DJ SECO ) MIX IN LIVE | This is a DJ freestyle performance with old-school and latin house influences. There is a female vocalist singing melodically with an 80s pop feel. A fuzzy synth bass is playing a groovy bass line. In the rhythmic background, there is an electronic drum beat with a 909-like sound. The atmosphere is eccentric and the sound is modern. This performance could be played at nightclubs or dance clubs. | 2011-04-19T08:52:12Z | DJSECO20111 | FREESTYLE-OLD SCHOOL AND LATIN HOUSE MIX ( MIX BY DJ SECO ) MIX IN LIVE | ["Scratching (performance technique)", "Sampler", "House music", "Music", "Drum machine", "Hip hop music"] | ["dj", "freestyle", "old-school", "latin house", "electronic music", "female vocal", "melodic singing", "fuzzy bass", "electronic drums", "dance", "eccentric", "hip", "modern sounding"] | 9 | Ae8o_FMI0Xs | 1149 | |
Tinashe Performs '2 On' Live At The Viper Room | This is a live performance of an alternative R&B music piece. There is a female vocalist singing in a seductive manner in the lead. Later on, a male vocalist starts rapping. There is a groovy bass line in the background. The DJ is scratching the turntable. The rhythmic background is provided by an R&B acoustic drum beat. The atmosphere is sensual and the sound is urban. Sounds of the crowd cheering can be heard in the recording. | 2014-05-28T20:28:16Z | xoNecole | New artist Tinashe performs her hit song 2 On Live At The Viper Room in Los Angeles | ["Singing", "Scratching (performance technique)", "Music"] | ["alternative r&b", "live performance", "female vocal", "seductive singing", "male vocal", "rapping", "turntable", "scracthing", "groovy bass", "acoustic drums", "crowd cheering", "sensual", "groovy", "urban"] | 9 | _GQnXfIGNKY | 3455 |
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;