musiccaps_details (view)
3 rows where musiccaps_aspects contains "guitar song", musiccaps_aspects contains "male voice" and musiccaps_aspects contains "no percussion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- guitar song · 3 ✖
- male voice · 3 ✖
- no percussion · 3 ✖
- minimal instruments 2
- amateur recording 1
- banjo song 1
- duet 1
- electric guitar 1
- female voice 1
- folk song 1
- foreign language 1
- happy mood 1
- instructional clip 1
- live recording 1
- moderate tempo 1
- narration 1
- no other instrument 1
- overdriven guitar 1
- repetitive melody 1
- romantic theme 1
- slow tempo 1
- vocal harmony 1
musiccaps_names (array) 13 ✖
- Music 3
- /t/dd00003 1
- Banjo 1
- Bluegrass 1
- Christmas music 1
- Country 1
- Electric guitar 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Reverberation 1
- Song 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Joseph Gordon-Levitt singing "La Valse à Mille Temps" (SitC) | This amateur recording features a male voice. This is accompanied by an electric guitar. The notes of the chords are first plucked and the chord is struck once. There is no percussion and no other instruments in this song. This is a slow tempo song. The mood of this song is romantic. | 2010-08-31T06:47:59Z | winegodof | Joseph Gordon-Levitt singing Jacques Brel's "La Valse à Mille Temps" at hitRECord.org's second Summer in the City show. | ["Music", "/t/dd00003"] | ["amateur recording", "guitar song", "male voice", "no percussion", "slow tempo", "foreign language", "minimal instruments", "live recording", "romantic theme"] | 0 | 3otUlQ4wvLY | 505 | |
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 | |
PRS 30th Anniversary Custom 24 electric guitar review demo | This clip features a guitar song. An overdriven guitar is struck at the beginning. This is followed by an electric guitar strumming two chords once each. The chords are strummed with a light overdrive sound. There are no other instruments in this song. A male voice talks in a narrative tone at the end of the segment. | 2015-02-19T14:56:55Z | Guitarist | Reviewed in Guitarist issue 391 Gear demos playlist: http://goo.gl/30cAf Subscribe for more from Guitarist: http://goo.gl/2PRXE Buy Guitarist magazine in print and digital forms: http://www.myfavouritemagazines.co.uk/content/lp/digitalbundles/mm-guitarist/ Visit our website: http://www.guitarist.co.uk Facebook: http://www.facebook.com/guitaristmagazine Twitter: http://www.twitter.com/Guitarist_Mag | ["Reverberation", "Electric guitar", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument"] | ["guitar song", "overdriven guitar", "male voice", "narration", "electric guitar", "instructional clip", "no percussion", "no other instrument"] | 0 | vOiDwXo-SuM | 5180 |
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;