musiccaps_details (view)
2 rows where musiccaps_aspects contains "percussion" and musiccaps_aspects contains "vocables"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- percussion · 2 ✖
- vocables · 2 ✖
- amateur recording 1
- bass 1
- crooning 1
- female voice 1
- low quality audio 1
- low quality recording 1
- male voice 1
- moderate tempo 1
- motivational 1
- rock song 1
- slow tempo 1
- strings 1
- synth 1
musiccaps_names (array) 3 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Wendy Sulca - Like A Virgin (Festival Centro 2011) [Ensayo] | This song features a female voice crooning the main melody. She is using vocables and no lyrics. The same melody is played on the synth immediately after she sings the first first line. A percussion player plays a simple beat. A tambourine plays in the background. The rest of the instruments are not clear due to the low audio quality. This song can be played in a coffee shop. The mood of this song is romantic. | 2011-01-27T01:36:45Z | Wendy Sulca | Detrás de cámaras del ensayo de Wendy Sulca para lo que fue su gran presentación en el Festival Centro 2011, realizado en Bogotá (Colombia) el día 22 de enero de 2011. Aquí podemos notar la nueva versión que Wendy, ha hecho al cover de Madonna llamado "Like a virgin". Más información en: http://www.wendysulca.com http://wendysulcaclub.blogspot.com http://www.twitter.com/wendy_oficial http://www.myspace.com/wendysulcaoficial http://www.facebook.com/wendysulcaoficial Más información: Contacto: manager@wendysulca.com / wendysulca16@gmail.com http://www.wendysulca.com Facebook: https://www.facebook.com/WendySulcaOficial/ Twitter: http://www.twitter.com/wendy_oficial Instagram: http://www.instagram.com/wensulca | ["Music", "Vocal music"] | ["amateur recording", "synth", "low quality audio", "percussion", "female voice", "slow tempo", "crooning", "vocables"] | 0 | Gh4KBdcCU64 | 1747 | |
Drops Of Jupiter | This is a low quality recording of a rock song. The main lead melody is sung by a male voice. Other male voices sing vocables in the background in between lines. A string ensemble plays fills in the background with an ascending lick in between lines. The percussion plays a simple rock beat in common time with snare strokes on every alternate count. The bass plays the root notes of the chords. The mood of this song is motivational. Other instruments cannot be identified due to the low audio quality. This song can be played at the end credits of a superhero movie. | 2007-04-30T05:54:49Z | PunkPinkPower | A Tribute to Power Rangers Ninja Storm in its entirety. That I am abnormally proud of. An epic season deserved an epic song, so I chose Drops of Jupiter by Train. And Always Remember: A happy ending is nothing more than a new beginning! | ["Independent music"] | ["low quality recording", "rock song", "male voice", "strings", "percussion", "bass", "vocables", "bass", "moderate tempo", "motivational"] | 0 | rnOIXOGfSUE | 4901 |
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;