musiccaps_details (view)
5 rows where musiccaps_aspects contains "groovy bass line", musiccaps_aspects contains "piano accompaniment" and musiccaps_aspects contains "poor audio quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 68 ✖
- groovy bass line · 5 ✖
- piano accompaniment · 5 ✖
- poor audio quality · 5 ✖
- dj 3
- dance music 2
- dance rhythm 2
- disc scratching tones 2
- female backup singer 2
- instrumental music 2
- jazz music 2
- vocal harmony 2
- acapella 1
- adrenaline rush 1
- advertisement jingle 1
- ambient room noise 1
- big band 1
- big band hits 1
- bop tune 1
- brass section harmony 1
- brush drumming rhythm 1
- christian contemporary music 1
- christian praise hits 1
- congregational 1
- dance club 1
- dance floor 1
- devotional 1
- distorted guitar lead 1
- double bass harmony 1
- energetic 1
- fast jazz drumming 1
- fast tempo 1
- fats jazz drumming 1
- glass shattering sounds 1
- groovy music 1
- guitar rhythm 1
- hard rock music 1
- high spirited 1
- hymns 1
- inspiring 1
- jazz band 1
- jazz dance music 1
- jazz legends 1
- jazz super hits 1
- live performance 1
- love performance 1
- make vocals 1
- male rapper 1
- male singer 1
- male singers 1
- meditational 1
- medium fast tempo 1
- medium tempo 1
- motivational 1
- passionate 1
- people clapping 1
- people dance 1
- people dancing 1
- praise and worship 1
- rap vocals 1
- retro jazz classics 1
- steady drum rhythm 1
- steady drumming rhythm 1
- steady techno drumming rhythm 1
- string rock drumming 1
- techno dance club 1
- techno dance music 1
- trumpet playing percussively 1
- trumpets playing percussively 1
musiccaps_names (array) 11 ✖
- Music 5
- Chink, clink 1
- Clapping 1
- Funk 1
- Music of Latin America 1
- Reggae 1
- Rock and roll 1
- Ska 1
- Steelpan 1
- Swing music 1
- Tambourine 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ernie Haase & Signature Sound - Will The Lord Be With Me | Male singers sing this vocal harmony. The song is medium fast tempo with a groovy bass line, steady drumming rhythm, piano accompaniment and guitar rhythm. The song is devotional and congregational. The song is a classic Christian praise hit. | 2007-04-15T03:40:47Z | moondoggy22 | Will The Lord Be With Me is another fantastic performance from Ernie Haase and Signature Sound video | ["Music", "Clapping"] | ["male singers", "vocal harmony", "people clapping", "acapella", "poor audio quality", "steady drumming rhythm", "piano accompaniment", "guitar rhythm", "groovy bass line", "christian contemporary music", "praise and worship", "christian praise hits", "devotional", "meditational", "congregational", "inspiring", "motivational", "hymns", "medium fast tempo"] | 1 | 0trWdhSvab4 | 218 | |
ZATURNO ESPACIAL EN COPIAPO IMPERIO PUB 2011 WARRIOR SOUND SYSTEM | A male singer sings this cool melody with backup female singers in vocal harmony. The song is medium tempo with a groovy rhythm, steady drumming rhythm, disc scratching tones, and piano accompaniment. The song is groovy and has a dance rhythm. The song has poor audio quality. | 2011-01-26T05:25:14Z | HEISGRAFF | WARRIOR SOUND SYSTEM PRESENTA EN IMPERIO PUB A ZATURNO ESPACIAL | ["Music", "Tambourine", "Music of Latin America"] | ["techno dance music", "groovy bass line", "dance club", "dance floor", "people dance", "disc scratching tones", "dj", "techno dance club", "make vocals", "rap vocals", "dance music", "live performance", "female backup singer", "piano accompaniment", "ambient room noise", "poor audio quality", "groovy bass line", "dance rhythm", "steady techno drumming rhythm"] | 1 | 8pc8fjPIV-Q | 950 | |
Get Cut With Glass - Safe Shoulder Workouts #1 | The song is an advertisement jingle. A male singer sings rapping vocals, with a strong drumming rhythm, piano accompaniment, groovy bass line and a distorted guitar playing an aggressive lead. The song is high on adrenaline and energetic. The song is a soundtrack for an ad and is of poor audio quality. | 2012-11-02T15:33:33Z | StrenghtHuman | Adam Kirby treinando com o Trainer Pro Charles Glass para o 2007 Mr. Veneza Beach | ["Music", "Chink, clink"] | ["instrumental music", "hard rock music", "dj", "poor audio quality", "glass shattering sounds", "disc scratching tones", "medium tempo", "string rock drumming", "distorted guitar lead", "piano accompaniment", "groovy bass line", "advertisement jingle", "high spirited", "adrenaline rush", "male rapper"] | 1 | N1Mxns_JJTk | 2318 | |
Groovy Live Musik : "We no speak americano" by 4 to the bar : jazzy swing and lounge music | A male singer sings this groovy bop tune. The song is medium tempo with a groovy double bass playing, piano accompaniment, trumpet playing percussively and brush drumming rhythm. The song is entertaining and exciting. The song is a jazz dance tune with an electronica twist. | 2011-02-01T14:48:22Z | loungemusicband | http://4tothebar.de : More groovy lounge music, swing sounds and jazzy live music for club, event and party. Lounge Music: Die Live Band 4 to the bar spielt Swing, Samba und Jazz mit Drums, Kontrabass, Piano und Sängerin und Deejay | ["Swing music", "Funk", "Music", "Reggae", "Ska", "Rock and roll"] | ["groovy music", "love performance", "dj", "dance music", "brush drumming rhythm", "groovy bass line", "steady drum rhythm", "piano accompaniment", "trumpet playing percussively", "male singer", "female backup singer", "vocal harmony", "bop tune", "double bass harmony", "jazz music", "jazz dance music", "poor audio quality", "people dancing", "dance rhythm"] | 1 | RtgHU1UMo5o | 2729 | |
Chuck Mangione - Sun Shower | The song is an instrumental. The tempo is fast with trumpets playing percussively along with other brass instruments, piano accompaniment, groovy bass line jazz drumming rhythm. The song is energetic and passionate. The song is a retro big band jazz classic with poor audio quality. | 2011-01-29T01:59:44Z | Henry Cooper | From 1971's Together. Sampled by Tonex for "Sonshine" | ["Music", "Steelpan"] | ["instrumental music", "jazz music", "fast jazz drumming", "energetic", "passionate", "retro jazz classics", "jazz super hits", "jazz legends", "big band hits", "trumpets playing percussively", "fast tempo", "piano accompaniment", "fats jazz drumming", "brass section harmony", "groovy bass line", "big band", "poor audio quality", "jazz band"] | 1 | lNg2y6SRZPo | 4392 |
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;