musiccaps_details (view)
2 rows where musiccaps_aspects contains "poor audio quality", musiccaps_aspects contains "techno drumming rhythm" and musiccaps_names contains "Electronic music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- poor audio quality · 2 ✖
- techno drumming rhythm · 2 ✖
- auto tuned female vocals 1
- dance club 1
- dance floor 1
- dancers 1
- distorted tones 1
- dj 1
- dubstep music 1
- electronic dance music 1
- electronic music 1
- energetic 1
- entertaining 1
- euro pop hits 1
- exciting 1
- fast tempo 1
- groovy bass line 1
- grunge keyboard tones 1
- grunge tones 1
- instrumentals music 1
- keyboard accompaniment 1
- male singer 1
- overdriven keyboard harmony 1
- rap singer 1
- rubbing tones 1
- russian pop hits 1
- russian singer 1
- sonic effects 1
- steady drumming rhythm 1
- synth string pad section 1
- techno dance hits 1
- techno dance music 1
- trance party 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Baile de Dubstep | The song is an instrumental. The song is medium tempo with a slick drumming rhythm, grunge keyboard tones, overdriven synth tones and string pad section. The song is groovy and exciting. The audio quality is poor in general. | 2013-03-08T02:22:05Z | Rafael Chávez | Mira mi nuevo video y aprende 3 pasos sencillos https://www.youtube.com/watch?v=nhlQRS4vDYo | ["Electronic music", "Music", "Dubstep"] | ["instrumentals music", "dubstep music", "overdriven keyboard harmony", "poor audio quality", "dj", "electronic music", "grunge keyboard tones", "steady drumming rhythm", "distorted tones", "synth string pad section", "electronic dance music", "techno drumming rhythm", "techno dance music", "rubbing tones"] | 1 | MP7KPlqoQW0 | 2262 | |
Russen Techno Remix | A male Russian singer sings this rap vocals with a female backup singer in vocal harmony. The song is fast tempo with techno drumming rhythm, percussive bass line, keyboard accompaniment and sonic effects. The song is a techno dance hit. The audio quality is poor. | 2008-10-23T14:40:58Z | CoolerRussenking | Russische Musik mit Verschiedenen Bildern. | ["Electronic music", "Music", "Techno"] | ["russian singer", "male singer", "rap singer", "poor audio quality", "fast tempo", "techno drumming rhythm", "groovy bass line", "keyboard accompaniment", "grunge tones", "sonic effects", "auto tuned female vocals", "exciting", "energetic", "entertaining", "dancers", "dance floor", "dance club", "trance party", "russian pop hits", "euro pop hits", "techno dance hits"] | 1 | dDKUjMHerLs | 3770 |
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;