musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "fast tempo", musiccaps_names contains "Singing" and musiccaps_names contains "Ska"
This data as json, CSV (advanced)
Suggested facets: musiccaps_names
musiccaps_aspects (array) >30 ✖
- fast tempo · 3 ✖
- acoustic drums 1
- alternative rock 1
- amateur recording 1
- bass drum 1
- blues 1
- blues drum kit 1
- bouncy bass 1
- bright drumming 1
- bright male vocals 1
- cymbals 1
- e-bass 1
- e-guitar 1
- electric piano 1
- energetic 1
- enthusiastic 1
- falsetto male vocals 1
- funky bass line 1
- funky keyboard harmony 1
- groovy electric guitar accompaniment 1
- happy 1
- hard rock 1
- lively 1
- male vocal backup 1
- male vocalist 1
- male voices singing 1
- positive 1
- raspy male vocals 1
- rock 1
- skarock 1
- …
musiccaps_names (array) 6 ✖
- Music 3
- Singing · 3 ✖
- Ska · 3 ✖
- Music of Asia 1
- Rock and roll 1
- Whoop 1
youtube_published (date) 3 ✖
- 2007-01-16 1
- 2007-05-03 1
- 2013-04-02 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
RapScallions - The Garage Sessions - "What Do Ya Say?" | A male vocalist sings this enthusiastic song. The tempo is fast with infectious drumming, groovy bass lines, funky electric guitar harmony and an energetic keyboard accompaniment with vocal backup. The song is energetic, high-spirited, youthful, infectious, pulsating and vigorous. This song is a popular Alternative Rock. | 2013-04-02T04:59:36Z | OfficialRapScallions | BUY THE NEW ALBUM "IN MY HEAD" on iTunes https://itunes.apple.com/us/album/in-my-head-ep/id611204088 The Garage Sessions #2: "What Do Ya Say?" Vocals: Sergio Ochoa Guitar: Dario Forzato Bass: Chris Clemence Drums: James Forsberg Video Director: Alessandro Casati RapScallions would like to thank their sponsors: D'Addario Strings, Planet Waves, Evans, Pro Mark, Warwick and Truth Custom Drums. | ["Singing", "Music", "Ska"] | ["male vocalist", "fast tempo", "male vocal backup", "cymbals", "bass drum", "bright drumming", "funky keyboard harmony", "groovy electric guitar accompaniment", "funky bass line", "youthful", "spirited", "enthusiastic", "energetic", "lively", "vigorous", "rock", "hard rock", "alternative rock"] | 7 | 5xBfKiQcMZQ | 707 | |
Tokyo Ska Paradise Orchestra Live - Ska Me Crazy | An e-bass is playing a bluesy bassline along with acoustic drums with a slightly open hihat. An electric piano/organ is playing one short chord as a rhythmic element adding reggae vibes along with a e-guitar strumming fast chords on the offbeat. The guitar is running through a chorus effect. The male voices are singing a simple melody. This song may be playing at a live concert before a sports-event. | 2007-01-16T11:24:03Z | SkaRebel | SKA SKA SKA!!! | ["Singing", "Music", "Ska"] | ["skarock", "acoustic drums", "e-bass", "electric piano", "e-guitar", "male voices singing", "amateur recording", "fast tempo", "uplifting mood"] | 6 | rJZgUpzqAyY | 4864 | |
The Blues Willies - Shout | The track is an upbeat blues song that features falsetto and raspy male vocals. A drum kit plays an energetic and happy beat. A bass guitar follows the rhythm and adds a bouncy vibe to the song. The overall sound of the instruments is bright and happy. A guitar follows the bass and the drum kit. | 2007-05-03T10:44:42Z | Alfredo | I Blues Willies al concertone del primo Maggio 2007 a S. Giovanni. A parte il mitico Chuck Berry, l'unico vero gruppo che c'entrava qualcosa con il rock'n'roll! www.blueswillies.it | ["Singing", "Music of Asia", "Music", "Ska", "Whoop", "Rock and roll"] | ["blues", "upbeat", "falsetto male vocals", "raspy male vocals", "fast tempo", "blues drum kit", "positive", "happy", "bright male vocals", "bouncy bass"] | 5 | vtVfl5Ff5lw | 5216 |
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;