musiccaps_details (view)
3 rows where musiccaps_aspects contains "emotional", musiccaps_author = 1 and musiccaps_names contains "Ska"
This data as json, CSV (advanced)
musiccaps_aspects (array) 56 ✖
- emotional · 3 ✖
- passionate 3
- guitar rhythm 2
- medium fast tempo 2
- romantic 2
- backup singers 1
- bells percussion tones 1
- crooners 1
- dance groove 1
- dance rhythm 1
- dance with you all night 1
- drum rolls 1
- electric guitar solo 1
- emphatic cries 1
- energetic 1
- entertaining 1
- exciting 1
- finale singer 1
- funk jazz 1
- funky jazz drumming 1
- groovy 1
- groovy bass line 1
- groovy rhythm 1
- guiro percussions 1
- instrumental music 1
- i’m in love 1
- jazz band 1
- jazz festival 1
- jazz improvisation 1
- latin dance band 1
- latin folk singer 1
- latin percussions 1
- live improvisation 1
- love sing 1
- love song 1
- male latin singer 1
- medium tempo 1
- modern day romance 1
- modern jazz hits 1
- people dancing 1
- percussive bass line 1
- piano accompaniment 1
- poor audio quality 1
- retro love songs 1
- retro pop 1
- saxophone playing 1
- soaring vocals 1
- soul singer 1
- spirited 1
- steady drumming rhythm 1
- story telling 1
- together forever 1
- various percussion hits 1
- walking bass line 1
- xylophone playing 1
- youthful 1
musiccaps_names (array) 4 ✖
- Music 3
- Ska · 3 ✖
- Music of Africa 1
- Vibraphone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
el grillo enamorado | A male singer sings this passionate melody. The song is medium tempo with Latin percussion, guiro percussions, guitar rhythm, piano accompaniment and guitar rhythm. The song is romantic and spirited. The song is a Latin dance song with poor audio quality. | 2008-09-05T17:39:10Z | Piko | el grillo enamorado con imagenes de grillos | ["Music of Africa", "Music", "Ska"] | ["male latin singer", "poor audio quality", "latin percussions", "people dancing", "latin dance band", "dance groove", "emotional", "soaring vocals", "latin folk singer", "walking bass line", "piano accompaniment", "dance rhythm", "entertaining", "romantic", "story telling", "passionate", "spirited", "guiro percussions", "medium tempo", "guitar rhythm"] | 1 | 2cxvYC9QZac | 391 | |
Northern Soul .. I'll never stop loving you. | A female singer sings this passionate melody with backup singers in vocal harmony. The song is medium tempo with a percussive bass line, groovy drumming rhythm, keyboard accompaniment and other percussive hits. The song is a retro pop love song. | 2010-12-15T10:18:33Z | docludi | Once acclaimed the Queen of Memphis Soul. Carla Thomas, daughter of Rufus Thomas was born on December 21, 1942 in Memphis, Tennessee. This 1963 Fantasy recording remained unreleased until 1991. "I'll never stop loving you" Video excerpts from Story of the Who, Quadraphenia and other scooter oddments of the period. Twisted Wheel website. http://www.twistedwheel.co.uk | ["Music", "Ska"] | ["finale singer", "retro pop", "backup singers", "passionate", "love sing", "together forever", "i’m in love", "dance with you all night", "modern day romance", "youthful", "soul singer", "percussive bass line", "steady drumming rhythm", "guitar rhythm", "groovy", "romantic", "emotional", "love song", "retro love songs", "crooners", "medium fast tempo"] | 1 | ZwLfj7tvpdc | 3427 | |
Gong - Esnuria | The song is an instrumental improvisation. The song is medium fast tempo with a groovy bass line, electric guitar playing, saxophone playing, jazz drumming with percussive hits and a xylophone playing. The song is highly improvisational and energetic. The song is a modern jazz fusion or improvisation jam. | 2009-07-23T20:02:28Z | funkdigger91 | LP: Gong - Gazeuse! (1976) Bass, Piano, Gong - Francis Moze Congas, Percussion - Mino Cinelu Drums, Vibraphone, Marimba, Glockenspiel - Pierre Moerlen Guitar - Allan Holdsworth Producer - Dennis MacKay Saxophone, Flute - Didier Malherbe Vibraphone - Benoit Moerlen Vibraphone, Marimba, Glockenspiel - Mireille Bauer Maybe heard on: DJ Pogo - Block Party Breaks Vol. 2 (2002) | ["Music", "Ska", "Vibraphone"] | ["funk jazz", "medium fast tempo", "instrumental music", "saxophone playing", "electric guitar solo", "funky jazz drumming", "groovy bass line", "drum rolls", "various percussion hits", "live improvisation", "bells percussion tones", "xylophone playing", "jazz improvisation", "energetic", "exciting", "jazz band", "modern jazz hits", "groovy rhythm", "jazz festival", "emphatic cries", "emotional", "passionate"] | 1 | ylKvglDzBU4 | 5436 |
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;