musiccaps_details (view)
2 rows where musiccaps_aspects contains "passionate echoing female vocal" and musiccaps_author = 4 sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- energetic 2
- low quality 2
- passionate echoing female vocal · 2 ✖
- 4 on the floor kick pattern 1
- addictive 1
- clapping 1
- claps 1
- disco 1
- funky bass guitar 1
- funky electric guitar chords 1
- groovy bass 1
- hollow 1
- mellow synth keys chords 1
- passionate 1
- pop 1
- punchy kick 1
- repetitive synth lead melody 1
- shimmering hi hats 1
- thin 1
- wide harmonizing female vocals 1
musiccaps_names (array) 5 ✖
- Music 2
- Dance music 1
- Disco 1
- Exciting music 1
- Pop music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Pump It Up - Caution | The low quality recording features a disco song that consists of passionate female vocals and wide harmonizing female vocals singing over funky bass guitar, mellow synth keys chords, funky electric guitar chords, shimmering hi hats, clapping and "4 on the floor" kick pattern. It sounds funky and energetic, but also thin and hollow, due to the bad mixing. | 2006-04-14T17:42:36Z | Agustín Romero | otro videx! de la pump px! y uno muy weno! :D see! | ["Disco", "Music", "Pop music", "Dance music"] | ["low quality", "funky bass guitar", "disco", "passionate echoing female vocal", "wide harmonizing female vocals", "funky electric guitar chords", "mellow synth keys chords", "energetic", "shimmering hi hats", "clapping", "thin", "hollow", "4 on the floor kick pattern"] | 4 | 1a_nvi4sW64 | 290 | |
ronaldinho vs robinho | The low quality recording features a pop song that consists of a passionate, echoing female vocal singing over punchy kick, groovy bass, repetitive synth lead melody and some claps. It sounds energetic, passionate and addictive. | 2006-07-31T13:04:30Z | Claudio Maio | the gods of tricks see the new video: henry vs zlatan ibrahimovic melhorado | ["Music", "Exciting music"] | ["low quality", "pop", "punchy kick", "groovy bass", "claps", "passionate echoing female vocal", "repetitive synth lead melody", "energetic", "passionate", "addictive"] | 4 | kAAGkKPVgZ8 | 4302 |
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;