musiccaps_details (view)
7 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "groovy bass" and musiccaps_aspects contains "noisy"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- energetic · 7 ✖
- groovy bass · 7 ✖
- low quality 7
- noisy · 7 ✖
- live performance 5
- energetic drums 3
- mono 3
- passionate 3
- punchy snare 3
- emotional 2
- flat male vocal 2
- banjo solo melody 1
- blues 1
- boomy 1
- chaotic 1
- commentary 1
- country 1
- crowd noise 1
- dub 1
- electric guitar melody 1
- electric guitar solo melody 1
- folk 1
- harmonica solo melody 1
- high pitched female vocals 1
- joyful 1
- jungle 1
- mellow snare 1
- mellow synth keys melody 1
- muffled 1
- muffled male vocal 1
- …
musiccaps_names (array) 21 ✖
- Music 4
- Music of Latin America 2
- Musical instrument 2
- Banjo 1
- Bluegrass 1
- Bowed string instrument 1
- Cello 1
- Double bass 1
- Drum 1
- Drum kit 1
- Electric piano 1
- Electronic music 1
- Guitar 1
- Harmonica 1
- House music 1
- Keyboard (musical) 1
- Piano 1
- Plucked string instrument 1
- Pulse 1
- Wedding music 1
- Wind instrument, woodwind instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rehearsal Part IV - Urban R&B Worship Flowing and Worshiping | The low quality recording features a live performance of a R&B song that consists of muffled male vocal singing over groovy bass guitar, mellow synth keys melody and energetic drums. There are some crowd noises in the background. The recording is noisy, as it was probably recorded with a phone, but it sounds energetic, passionate and emotional. | 2010-06-12T04:53:53Z | Gospel Musicians | http://gospelmusicians.com/ - Jamal Hartwell, Lydell on bass Tate, Cash on Drums. Worshipping during rehearsal to some Urban Worship | ["Electric piano", "Keyboard (musical)", "Piano"] | ["low quality", "noisy", "crowd noise", "live performance", "r&b", "energetic drums", "muffled male vocal", "groovy bass", "mellow synth keys melody", "energetic", "passionate", "emotional"] | 4 | 2I6pPRWKsCQ | 348 | |
Sud Sound System@Villa Ada - feat. Maria Ganja | The low quality recording features a live performance of dub song manically rapped by flat male vocals, followed by energetic drums, groovy bass and offbeat key chords. The recording is noisy and chaotic a bit, as it is probably recorded with a phone. | 2007-07-25T12:28:57Z | Ivano Zizzi | grande performance! Sud sound systema a "Roma Incontra il mondo" VILLA ADA. Nuh se po proibire & erba erba | ["Music", "Music of Latin America"] | ["low quality", "dub", "noisy", "live performance", "energetic", "offbeat guitar melody", "energetic drums", "flat male vocal", "chaotic", "groovy bass"] | 4 | JN_VJCJhC4Y | 1996 | |
Jimmy Alapag Tribute to the Legend "Wings" | The low quality recording features a flat male vocal rapping over sustained strings melody, punchy kick, mellow snare, groovy bass and some commentary that can be heard in the background. It sounds emotional, energetic and the recording is noisy. | 2015-01-11T07:28:50Z | REMAR TV | You Know who's the true face of the PBA and The Philippine Basketball? It's no other than Jimmy Alapag, Playing with a very big heart against the tallest, athletic and talented in the world but never back down instead carry the country in his small shoulders and hits so many historic and memorable basket for the Philippine basketball. We are proud to witness your incredible career Jimmy "The Mighty Mouse" Alapag #Salute #Greatness Credits to the sources and owners of the videos that I used. Like my Facebook Page: https://www.facebook.com/AdminRemarMIX Follow me on Twitter: https://twitter.com/remar_09 Follow me on Instagram: http://instagram.com/remar_09/ - Admin Remar MIX | ["Cello", "Double bass", "Bowed string instrument"] | ["low quality", "sustained strings", "flat male vocal", "punchy kick", "mellow snare", "groovy bass", "commentary", "noisy", "emotional", "energetic"] | 4 | WmTDKYYH5OU | 3133 | |
DJ Princess @ Pulse | The low quality recording features an electro song being played in a club and it consists of high pitched, repetitive, female vocals singing over groovy bass, punchy snare hits and shimmering hi hats. It sounds upbeat and energetic, even though the sound is muffled, noisy and in mono. | 2007-09-10T06:28:59Z | Shannon Wood | spinnin' at our (dubbz, me) bday party 8/31/07 | ["Electronic music", "House music", "Music", "Pulse"] | ["low quality", "boomy", "muffled", "high pitched female vocals", "jungle", "groovy bass", "punchy snare", "shimmering hi hats", "upbeat", "noisy", "mono", "energetic"] | 4 | XI9CNsX6JSE | 3173 | |
Azerbaijan Music Wedding in Israel - Issey | The low quality recording features a live performance of a folk song that consists of a passionate male vocal singing over groovy bass, woodwind melody, punchy snare and wooden percussion. It sounds joyful, energetic and the recording is noisy. | 2007-08-09T13:31:14Z | IzzIPiano | Keyboard played by Issey | ["Drum", "Drum kit", "Music", "Musical instrument", "Wedding music", "Music of Latin America"] | ["low quality", "folk", "passionate male vocal", "groovy bass", "woodwind melody", "punchy snare", "energetic", "wooden percussions", "live performance", "joyful", "noisy"] | 4 | fiAcNMpd2vM | 3971 | |
EARL SCRUGGS & STEVE MARTIN - DUELING BANJOS-EARLSCRUGGS DEAD AT 88-WEB-GIFTS.COM | The low quality recording features a live performance of a country song and it consists of banjo solo melody and electric guitar melody going back and forth, energetic drums, groovy bass and sustained strings melody playing in the background. The recording is noisy and in mono, and it sounds energetic and passionate. | 2012-03-29T13:51:03Z | TINKER2ELVIS | Scruggs died Wednesday morning at age 88 of natural causes. The legacy he helped build with bandleader Bill Monroe, guitarist Lester Flatt and the rest of the Blue Grass Boys was evident all around Nashville, where he died in an area hospital. His string-bending, mind-blowing way of picking helped transform a regional sound into a national passion. "It's not just bluegrass, it's American music," bluegrass fan turned country star Dierks Bentley said. "There's 17- or 18-year-old kids turning on today's country music and hearing that banjo and they have no idea where that came from. That sound has probably always been there for them and they don't realize someone invented that three-finger roll style of playing. You hear it everywhere | ["Banjo", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["low quality", "mono", "noisy", "live performance", "banjo solo melody", "electric guitar solo melody", "energetic drums", "groovy bass", "sustained string melody", "energetic", "passionate", "country", "uptempo"] | 4 | nqd7mXvHupU | 4581 | |
Steve Miller mercury blues norton buffalo harmonica solo | The low quality recording features a live performance of blues songs and it consists of a harmonica solo melody played over groovy bass, punchy snare, shimmering cymbals and electric guitar melody. As it was recorded with a phone, there are some whistling crowd noises, aside from the fact that the recording is in mono and noisy. It still sounds energetic and passionate. | 2006-10-04T03:46:37Z | Sunshine Day | part of song with awesome harmonica solo by norton | ["Harmonica", "Wind instrument, woodwind instrument"] | ["low quality", "whistling sound", "mono", "noisy", "harmonica solo melody", "groovy bass", "punchy snare", "shimmering cymbals", "electric guitar melody", "live performance", "blues", "passionate", "energetic"] | 4 | ovomUNSo_uo | 4666 |
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;