musiccaps_details (view)
4 rows where musiccaps_aspects contains "guitar accompaniment" and musiccaps_names contains "Song"
This data as json, CSV (advanced)
musiccaps_aspects (array) 66 ✖
- guitar accompaniment · 4 ✖
- male singer 4
- passionate 3
- spirited 3
- average audio quality 2
- groovy music 2
- medium tempo 2
- romantic 2
- adrenaline rush 1
- ambient room noise 1
- and audio quality 1
- at 1
- backup singers 1
- boudin’s percussions 1
- choreography music 1
- clapping percussions 1
- courtship song 1
- dance music 1
- dance rhythm 1
- emotional 1
- exercise class 1
- fast guitar strumming 1
- fast tempo 1
- female singers 1
- flamenco guitar 1
- flute playing melodiously 1
- folk music 1
- folk singer 1
- groovy bass line 1
- groovy rhythm 1
- groovy tempo 1
- gym music 1
- hissing vocals 1
- home studio 1
- indian percussions 1
- inspiring 1
- keybiard accompaniment 1
- latin dance hits 1
- latin dance music 1
- latin percussion 1
- latin singer 1
- life lessons 1
- live performance 1
- loud vocals 1
- motivational 1
- muted audio track 1
- passionate music 1
- passionate singing 1
- poor audio quality 1
- retro pop hits 1
- song cover 1
- south indian music 1
- special animated sound effects 1
- spirited singing 1
- street musician 1
- stringed instruments 1
- strong bass line 1
- tabla playing 1
- tambourine percussions 1
- telugu comedy show 1
- traditional dance music 1
- traditional latin music 1
- trumpets 1
- workout playlist 1
- zumba dance hits 1
- zumba music 1
musiccaps_names (array) 9 ✖
- Music 4
- Song · 4 ✖
- Singing 3
- Flamenco 1
- Folk music 1
- Independent music 1
- Maraca 1
- Pop music 1
- Vocal music 1
youtube_published (date) 4 ✖
- 2009-12-21 1
- 2012-06-30 1
- 2016-01-22 1
- 2016-03-02 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Flamenco en la calle. Cáceres | A male singer sings this spirited Latin vocal. The song is fast tempo with slick guitar strumming and percussive guitar accompaniment. The song is romantic and steeped in rich Latin classical music traditions. The song is about a Latin street musician playing folk music. The recording is of average quality. | 2016-01-22T12:08:16Z | Antonio Lara Arco | En pleno casco antiguo de la ciudad... | ["Singing", "Flamenco", "Music", "Song", "Vocal music"] | ["male singer", "latin singer", "average audio quality", "fast tempo", "groovy tempo", "fast guitar strumming", "guitar accompaniment", "groovy music", "romantic", "emotional", "passionate", "spirited", "passionate singing", "spirited singing", "flamenco guitar", "live performance", "street musician", "passionate music", "traditional latin music", "folk singer", "folk music"] | 1 | Bx726MYz6Uo | 1306 | |
Dale Maraca - ABS in Zumba Dance Class with ART ( Mo Betta ) | A male singer sings this Latin dance tune. The song is medium tempo with trumpets, latin percussions; medium drumming rhythm, keyboard harmony and guitar accompaniment. The song is exciting and groovy. The audio quality is poor and is played for work out exercise. | 2009-12-21T09:41:49Z | 19mobetta06 | Great song for ab work. Pull stomach in and use your hips in circular motion not so much work with the shoulders. www.CardioAssassin.com | ["Music", "Song", "Maraca"] | ["ambient room noise", "poor audio quality", "gym music", "zumba dance hits", "trumpets", "guitar accompaniment", "latin percussion", "strong bass line", "latin dance hits", "workout playlist", "passionate", "spirited", "adrenaline rush", "male singer", "latin dance music", "exercise class", "zumba music", "medium tempo", "groovy music"] | 1 | Sj5MQtqDw8Y | 2783 | |
అందాల నా కొక్క బంగ్లా | Telangana Folk Dj Video Song | Telugu Video Dj Songs 2018 | Janapad Video Dj | A male singer sings this Telugu folk song. The tempo pop is medium with a tambourine, tabla and other south Indian percussion playing steadily, along with string instrument harmony. The song is a folk tune and probably a courtship song. The song has loud sound effects which are funny. The audio quality is poor. | 2016-03-02T12:19:15Z | Telangana Folk Songs - Janapada Songs Telugu | Subscribe For More: Telangana Folk Songs: http://goo.gl/s0weMF Telangana Devotinal Songs: http://goo.gl/NjvTPR Telangana Music: https://goo.gl/FKv2fA Telangana Folk Video Songs: https://goo.gl/hhDV3c Telangana Banjara Folk Songs: https://goo.gl/Qj0p5E Telangana Folk Songs JukeBox's: https://goo.gl/Gfe8vu Like Us on FaceBook: https://www.facebook.com/TelanganaFolks మరిన్ని గీతాల కోసం: తెలంగాణ జానపద గీతాలు: http://goo.gl/s0weMF తెలంగాణ భక్తి గీతాలు: http://goo.gl/NjvTPR తెలంగాణ ఆడియో గీతాలు: https://goo.gl/FKv2fA తెలంగాణ జానపద వీడియో గీతాలు: https://goo.gl/hhDV3c తెలంగాణ బంజారా జానపద గీతాలు: https://goo.gl/Qj0p5E తెలంగాణ జానపద గీతాలు జ్యూక్ బాక్స్: https://goo.gl/Gfe8vu పేస్ బుక్ లో లైక్ చేయండి : https://www.facebook.com/TelanganaFolks | ["Singing", "Folk music", "Music", "Song"] | ["telugu comedy show", "male singer", "courtship song", "tambourine percussions", "romantic", "choreography music", "indian percussions", "tabla playing", "south indian music", "dance music", "at", "boudin’s percussions", "flute playing melodiously", "stringed instruments", "and audio quality", "muted audio track", "loud vocals", "special animated sound effects", "traditional dance music", "guitar accompaniment"] | 1 | _5fwnVeZbvI | 3442 | |
Jakes List Jun 2012 Top 10 Independent Music Video Uploads | Male and female singers sing this vocal harmony. The song is medium tempo with a groovy bass-line, keyboard accompaniment, guitar rhythm and a steady drumming rhythm with clapping percussions. The song is exciting and groovy. The song is a classic pop hit cover with an average quality sound. | 2012-06-30T22:34:02Z | Jake Niall Foster | The top 10 music video uploads for the month of June 2012 (with a cut-off date of 22 Jun) for Independent and Unsigned artists. | ["Singing", "Music", "Independent music", "Pop music", "Song"] | ["male singer", "backup singers", "female singers", "clapping percussions", "groovy bass line", "medium tempo", "guitar accompaniment", "keybiard accompaniment", "song cover", "home studio", "average audio quality", "hissing vocals", "spirited", "passionate", "dance rhythm", "groovy rhythm", "life lessons", "motivational", "inspiring", "retro pop hits"] | 1 | lR8am4rK7qQ | 4395 |
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;