musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "exciting", musiccaps_aspects contains "groovy bass line" and musiccaps_names contains "Ska"
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- exciting · 2 ✖
- groovy bass line · 2 ✖
- backup singers 1
- bells percussion tones 1
- dance club 1
- dance groove 1
- dance rhythm 1
- drum rolls 1
- electric guitar solo 1
- emotional 1
- emphatic cries 1
- energetic 1
- female singer 1
- funk jazz 1
- funky jazz drumming 1
- groovy rhythm 1
- guitar rhythm 1
- instrumental music 1
- jazz band 1
- jazz festival 1
- jazz improvisation 1
- keyboard accompaniment 1
- live improvisation 1
- live performance 1
- male singer 1
- medium fast tempo 1
- medium tempo 1
- modern jazz hits 1
- motown 1
- passionate 1
- people dancing 1
- poor audio quality 1
- r&b music 1
- saxophone playing 1
- song cover 1
- soul music 1
- steady drumming rhythm 1
- various percussion hits 1
- vocal harmony 1
- xylophone playing 1
musiccaps_names (array) 8 ✖
- Music 2
- Ska · 2 ✖
- Disco 1
- Rhythm and blues 1
- Singing 1
- Song 1
- Soul music 1
- Vibraphone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Soul Motown R&B Rap Swing Wedding Music Band Hip Cool Disco Top-40 Dance Band Covers www.igmc.net | A male singer sings this cool melody with female and male backup singers in vocal harmony. The song is medium tempo with a groovy bass line, percussive drum rhythm, keyboard harmony and guitar rhythm. The song is exciting and groovy. The song is a R&B cover of a famous pop song. The song has poor audio quality. | 2008-02-27T20:49:11Z | IGMCmusic | 212-765-8714 www.igmc.net Soul Motown R&B Rap Swing Wedding Music Band Hip Cool Disco Top-40 Dance Band Covers www.igmc.net | ["Singing", "Disco", "Music", "Rhythm and blues", "Ska", "Song", "Soul music"] | ["male singer", "female singer", "backup singers", "dance club", "vocal harmony", "r&b music", "soul music", "motown", "song cover", "r&b music", "groovy bass line", "steady drumming rhythm", "keyboard accompaniment", "guitar rhythm", "exciting", "dance groove", "dance rhythm", "people dancing", "dance club", "live performance", "poor audio quality", "medium tempo"] | 1 | AGNqX_OL-dU | 1095 | |
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;