musiccaps_details (view)
7 rows where musiccaps_aspects contains "male voice", musiccaps_aspects contains "moderate tempo" and musiccaps_aspects contains "no percussion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- male voice · 7 ✖
- moderate tempo · 7 ✖
- no percussion · 7 ✖
- minimal instruments 3
- acoustic guitar 2
- amateur recording 2
- banjo song 2
- country song 2
- double bass 2
- folk song 2
- happy mood 2
- no other instruments 2
- no vocal melody 2
- announcement 1
- banjo 1
- bluegrass 1
- comedy 1
- distortion guitar 1
- duet 1
- female voice 1
- fingerstyle guitar 1
- guitar 1
- guitar song 1
- heavy metal 1
- instructional audio 1
- mandolin 1
- no words 1
- octaves 1
- patriotic song 1
- pedal bass notes 1
- piano 1
- quirky sounds 1
- repetitive melody 1
- romantic mood 1
- slow rock song 1
- violin 1
- vocal harmony 1
- yodeling 1
musiccaps_names (array) 15 ✖
- Music 7
- Bluegrass 4
- Banjo 3
- Musical instrument 3
- Plucked string instrument 3
- Country 2
- Speech 2
- Bowed string instrument 1
- Christmas music 1
- Guitar 1
- Mandolin 1
- Singing 1
- Song 1
- Tapping (guitar technique) 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jódlující Vojta Dyk | This clip is of an amateur recording. It features a male voice. He starts off the song by singing a quacking melody followed by yodeling. There are no words in this song. This voice is accompanied by a piano playing chords. There are no other instruments in this song. This song has a comedic feel to it. This song can be played at a house party. | 2008-10-12T21:53:55Z | Zuzuvideos | Jódlující Vojta Dyk 10.10.2008 Divadlo Kolowrat | ["Singing", "Yodeling", "Music"] | ["amateur recording", "yodeling", "male voice", "quirky sounds", "piano", "no words", "no percussion", "minimal instruments", "moderate tempo", "comedy"] | 0 | 1gDNqOQFopY | 295 | |
How to Play Trust by Megadeth Guitar Lesson (w/ Tabs!!) | This song features a distortion guitar. This is an instructional video. The song features an open note followed by the octave. Then a descending pattern is played on the distortion guitar. The voice gives instructions on how to play the pattern. There is no percussion in this song. There are no other instruments in this song. There is no vocal melody in this song. | 2009-03-15T04:06:25Z | m169marroquin | http://www.ObeyYourMATTster.com | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument"] | ["distortion guitar", "heavy metal", "male voice", "instructional audio", "octaves", "no other instruments", "no percussion", "no vocal melody", "moderate tempo"] | 0 | 52odOK7G2kg | 628 | |
Memphis Yodel | This amateur recording features a male voice singing the main melody. This is accompanied by a banjo being strummed in a country rhythm. This song is sung at a moderate tempo. This song has a patriotic feel. There are no other instruments in this song apart from the tenor banjo. This song can be played in a patriotic American movie. | 2008-12-23T05:34:54Z | lewdite | This is one of my favorite Jimmie Rodgers songs. Recorded in 1928. Here I am with my trusty tenor banjo. I recorded this song with my friend Johnny Fast. He has a fantastic voice (I do the yodeling) and to make it easy for you to check it out I've posted as a video response. THE WORDS & CHORDS TO THIS SONG AT: www.youtube.com/LDsongscreen | ["Banjo", "Music", "Mandolin", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["country song", "banjo song", "amateur recording", "no percussion", "male voice", "moderate tempo", "folk song", "minimal instruments", "patriotic song"] | 0 | LFYRuK8YstI | 2168 | |
Never Live Life (Like This) Country Music Video | This country song features a male voice singing in a Southern accent. The main melody is a typical country melody. This is accompanied by a violin playing backing notes. The guitar strums chords. The double bass plays the root note and lower fifth of the chords. This song has a happy mood. At the end, there are multiple male voices singing one word together. This song can be played in a happy Country Western movie. | 2013-08-03T02:08:03Z | Papa Darwell | Darwell and The RiskTaker Band Filmed at Darwells Cafe Our Tribute to the Great Earnest Tubb | ["Country", "Music", "Bluegrass"] | ["country song", "violin", "double bass", "male voice", "acoustic guitar", "moderate tempo", "happy mood", "no percussion"] | 0 | colnyHv9CAA | 3744 | |
Scar Tissue (The Red Hot Chili Peppers) | This folk song is a duet and features a male and a female voice singing in harmony. This is accompanied by an acoustic guitar strumming chords. A banjo player fills in between lines. There is no percussion in this song. The mood of this song is happy and upbeat. This song can be played in a coffee shop. | 2012-12-24T02:14:04Z | goosebearmusic | if you dig the tune you can download it here: https://soundcloud.com/thejunebugs/scar-tissue-the-red-hot-chili Goose and me throwing out some 90's folk... or something like that. | ["Christmas music", "Banjo", "Country", "Music", "Song", "Bluegrass"] | ["folk song", "duet", "male voice", "female voice", "vocal harmony", "banjo song", "guitar song", "no percussion", "minimal instruments", "happy mood", "moderate tempo", "repetitive melody"] | 0 | f6wrXzvByrg | 3922 | |
We'll Meet Again Sweet Heart- Japanese bluegrass Band in Korea.wmv | This bluegrass song starts off with a male voice making an announcement. The music starts to play. The banjo plays an introductory bluegrass lick. This is accompanied by an acoustic guitar strumming chords. The double bass plays the root note and the fifth of the chord. The mandolin plays the rhythm section in the song. There is no vocal melody in this song. There is no percussion in this song. This song can be played in a movie with a Western theme. | 2010-11-25T14:46:00Z | sun shin | ["Banjo", "Music", "Musical instrument", "Speech", "Plucked string instrument", "Bowed string instrument"] | ["bluegrass", "male voice", "announcement", "no percussion", "no vocal melody", "mandolin", "guitar", "banjo", "double bass", "moderate tempo", "romantic mood"] | 0 | oyAAhjGTNvQ | 4671 | ||
Dust In The Wind - Vocal Cover. | This slow rock song starts with an acoustic guitar playing chords in fingerstyle. For each chord, a pedal bass note is played while the higher pitch notes are played in a repeated sequence of three notes being played one after the other. A male voice sings the main melody. There are no other instruments in this song. This song can be played in a movie scene where a car is driving across a deserted highway. | 2009-10-12T20:44:26Z | Aaron James Haslam Guitar Covers | This is my dads cover of the great Kansas song Dust in the wind. He's wanted to record this song for a long time so we decided to get him into our home studio. Recorded raw onto a backing track. Pretty good I think you'll agree? Look out for our original tunes coming soon! | ["Music", "Bluegrass"] | ["slow rock song", "male voice", "acoustic guitar", "fingerstyle guitar", "moderate tempo", "no other instruments", "no percussion", "pedal bass notes"] | 0 | wc4UEh8wvCA | 5278 |
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;