musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "flamenco guitar" and musiccaps_names contains "Flamenco" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- flamenco guitar · 2 ✖
- average audio quality 1
- dance song 1
- emotional 1
- fast guitar strumming 1
- fast tempo 1
- female voice singing vocables 1
- folk music 1
- folk singer 1
- foot stomping 1
- groovy music 1
- groovy tempo 1
- guitar accompaniment 1
- latin singer 1
- live performance 1
- low quality recording 1
- male singer 1
- no other instruments 1
- passionate 1
- passionate music 1
- passionate singing 1
- romantic 1
- spirited 1
- spirited singing 1
- street musician 1
- traditional latin music 1
- two chord song 1
musiccaps_names (array) 7 ✖
- Flamenco · 2 ✖
- Music 2
- Music of Latin America 1
- Singing 1
- Song 1
- Tambourine 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Novia baila flamenco | This low quality audio features a guitar playing flamenco style. The guitar plays only two chords. The sound of foot-stomping can be heard. A female voice sings vocals in the background. This song has no other instruments. This song can be played for a flamenco dance. | 2011-11-22T17:53:23Z | Carlos Lopez | ...y que la novia se lanza a bailar flamenco con las chicas de su academia, que le acaban de dar la sorpresa de varias coreografias en su boda. | ["Flamenco", "Music", "Tambourine", "Music of Latin America"] | ["flamenco guitar", "foot stomping", "dance song", "no other instruments", "low quality recording", "two chord song", "female voice singing vocables"] | 0 | KPymcVenomk | 2081 | |
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 |
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;