musiccaps_details (view)
2 rows where musiccaps_aspects contains "passionate" and "youtube_published" is on date 2011-12-02
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- passionate · 2 ✖
- amplifier 1
- bass master class 1
- cymbals crashing 1
- distorted guitar 1
- drum track 1
- exciting 1
- experimental 1
- fruity male vocal 1
- funk rock 1
- guitar demo 1
- guitar effects pedal 1
- improvisational 1
- instrumental music 1
- joyful 1
- low quality 1
- mono 1
- noisy 1
- passionate harmonizing choir vocals 1
- quick slap bass inquest 1
- slap bass 1
- spirited 1
- technique video 1
- traditional 1
- youtube music video 1
musiccaps_names (array) 10 ✖
- Music 2
- A capella 1
- Bass guitar 1
- Choir 1
- Gospel music 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Rock music 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Experimental Funk Rock Slap Bass | The song is an instrumental. The tempo is medium with a bass guitar using innovative improvisation skills along with a drum track with heavy cymbal crashes. The song is energetic and passionate. | 2011-12-02T00:42:41Z | Remco's Groove Lab | Jam-based freefunk with an EBS bass iq, multidrive and octabass. I also used a digitech whammy pedal to bend the harmonic. Thanks for watching! Get this track on iTunes: https://music.apple.com/album/groove-a-holic-vol-2/1505339451 Bandcamp: http://remcohendriks.bandcamp.com/album/groove-a-holic-vol-2 Spotify: https://open.spotify.com/album/0CHNzopWXpDPskk3VUldxm?si=ammyhHEXRqKXiDvMSX20eQ Facebook: https://www.facebook.com/Gr00veLab Instagram: https://www.instagram.com/groove_a_holic Cheers! On request, here's the tab for the slap part on the first riff: h= hammer-on x= muted slap G ----------4--2--------2----44- D ----------------2h4x---xx----- A ---0h2x--x--------------------- | ["Bass guitar", "Guitar", "Music", "Musical instrument", "Rock music", "Plucked string instrument"] | ["funk rock", "slap bass", "instrumental music", "youtube music video", "experimental", "improvisational", "drum track", "cymbals crashing", "guitar effects pedal", "amplifier", "distorted guitar", "exciting", "passionate", "spirited", "quick slap bass inquest", "guitar demo", "technique video", "bass master class"] | 1 | T8U3ihbHh9A | 2815 | |
UNAM Choir - Ba Nyorilweng (Song of Prayer) | The low quality recording features passionate harmonizing choir vocals, alongside fruity male vocals. It sounds passionate, traditional and joyful. The recording is noisy and in mono. | 2011-12-02T23:42:18Z | GT Choir Ongwediva | The UNAM (University of Namibia) Choir performing at the UNAM Northern Campus during the October 2011 Northern Namibia Choral Extravaganza. | ["Gospel music", "Music", "Song", "Choir", "A capella"] | ["low quality", "mono", "noisy", "passionate harmonizing choir vocals", "fruity male vocal", "traditional", "joyful", "passionate"] | 4 | rizanOQM61k | 4897 |
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;