musiccaps_details (view)
3 rows where musiccaps_aspects contains "male vocal", musiccaps_aspects contains "vibrant" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- male vocal · 3 ✖
- vibrant · 3 ✖
- live performance 2
- acoustic guitar 1
- amp 1
- bass guitar 1
- carnatic classical 1
- carnatic violin 1
- complex 1
- crowd cheering 1
- electric guitar 1
- electronic drums 1
- emotional 1
- female vocal 1
- flamenco 1
- keyboard 1
- medium tempo 1
- melodic singing 1
- passionate singing 1
- pop music 1
- reverb 1
- sentimental 1
- simple tune 1
- spanish 1
- tabla 1
- versatile singing 1
musiccaps_names (array) 13 ✖
- Music 3
- Singing · 3 ✖
- Carnatic music 1
- Classical music 1
- Flamenco 1
- Guitar 1
- Music of Asia 1
- Music of Latin America 1
- Pop music 1
- Radio 1
- Reverberation 1
- Speech 1
- Tabla 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Endaro part 2/3 (Thyagaraja Pancharathna) | This is a Carnatic classical music piece. It is a live performance. There is a male vocalist singing in a versatile manner. The melody is being played by the Carnatic violin. There is a tabla percussion beat in the rhythmic background. There is a complex feel to the piece. The atmosphere is vibrant. | 2007-01-17T14:25:50Z | musiquebox | Prince Rama Varma sings at the Rashtrapti Bhavan: Endaro Mahanubhavulu | ["Singing", "Carnatic music", "Tabla", "Music", "Classical music"] | ["carnatic classical", "live performance", "male vocal", "versatile singing", "carnatic violin", "tabla", "vibrant", "complex"] | 9 | 7uKkUTml-DA | 888 | |
Antonio José canta por fandangos (Directo Málaga) | This is the live performance of a flamenco music piece. There is a male vocalist singing passionately in the Spanish language. An acoustic guitar strums a characteristic flamenco tune. Sounds of the crowd cheering can be heard in the background. The atmosphere is vibrant. | 2015-04-27T20:37:09Z | Carmen SV | Concierto sala Tenessee (Málaga) 26/04/2015 | ["Singing", "Flamenco", "Guitar", "Music", "Speech", "Music of Latin America"] | ["flamenco", "live performance", "spanish", "male vocal", "passionate singing", "acoustic guitar", "crowd cheering", "emotional", "vibrant"] | 9 | GUwBLItoJXk | 1727 | |
REVERBERATION AMP.wmv | This is a pop music piece being played through a reverberation amp. There is a male and a female vocalist singing melodically. A clean sounding electric guitar is playing a simple tune while a keyboard is holding the chords and a bass guitar is playing in the background. The rhythmic background is provided by a medium tempo electronic drum beat that has characteristics resembling an acoustic drum kit. The atmosphere is sentimental and vibrant. This piece could be used in advertisement jingles. It could be playing in the background in a romantic setting. | 2010-05-30T21:33:11Z | Jared Twedell | SANSUI REVERBERATION AMP. | ["Singing", "Reverberation", "Music of Asia", "Music", "Pop music", "Radio"] | ["pop music", "male vocal", "female vocal", "melodic singing", "keyboard", "electric guitar", "bass guitar", "electronic drums", "amp", "reverb", "simple tune", "sentimental", "vibrant", "medium tempo"] | 9 | Mf6Ql55o7Es | 2286 |
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;