musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "male vocal" and musiccaps_aspects contains "poor quality" sorted by youtube_published
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 25 ✖
- acoustic drums 3
- bass guitar 3
- male vocal · 3 ✖
- poor quality · 3 ✖
- amateur recording 2
- aggressive 1
- christian pop 1
- compilation 1
- cover 1
- distorted electric guitar 1
- easygoing 1
- electric guitar 1
- female vocal 1
- grunge rock 1
- grunt-like singing 1
- jam 1
- major key 1
- melodic singing 1
- noisy 1
- positive 1
- rebellious 1
- religious 1
- sound check 1
- t-pop 1
- uplifting 1
musiccaps_names (array) 9 ✖
- Music 3
- Musical instrument 2
- Christian music 1
- Exciting music 1
- Guitar 1
- Pop music 1
- Pulse 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 |
---|---|---|---|---|---|---|---|---|---|---|
Banda - Floyd The Barber (Nirvana) | This is an amateur cover of a grunge rock music piece. Both the recording and the playing are of poor quality. There is a male vocalist singing in a grunt-like manner as the lead. A crunchy riff is being played by the distorted electric guitar and the bass guitar while the acoustic drums are playing a simple rock beat. The atmosphere is rebellious and noisy. | 2006-12-04T17:57:48Z | drugstoremarc | Marco e Roberto unem-se a Joao Cassio e Benedito em sua banda para tocar "Floyd The Barber", do Nirvana. Marco and Roberto unite with Joao Cassio and Benedito on their band to play "Floyd The Barber", of Nirvana. | ["Music", "Musical instrument", "Rock music", "Pulse"] | ["cover", "amateur recording", "poor quality", "grunge rock", "male vocal", "grunt-like singing", "distorted electric guitar", "bass guitar", "acoustic drums", "rebellious", "aggressive", "noisy"] | 9 | oPiyXhxRGe4 | 4626 | |
Christian Music Mix #2, 19 songs!! | This is a poor quality Christian pop music compilation. There are many pieces sung by male and female voices melodically. The usual theme of the instrumental backing consists of a tune played in major key by an electric guitar and a bass guitar alongside a simple acoustic drum beat. The overall atmosphere is uplifting. This mix could be used in a movie to imply the sounds coming from a gospel radio station in passing. | 2009-04-13T01:50:06Z | AudioMan62 | This is The second installment of my christian music mix. be sure to listen my first one! enjoy! Made about 2002. | ["Christian music", "Guitar", "Music", "Musical instrument", "Pop music", "Song"] | ["compilation", "poor quality", "christian pop", "male vocal", "female vocal", "melodic singing", "electric guitar", "bass guitar", "acoustic drums", "major key", "positive", "uplifting", "religious"] | 9 | RPqz3vJYMLQ | 2697 | |
Lipta sound check in Bangkok winter music festival 2010 | This is an amateur recording of a sound check jam. The audio quality is quite poor with an emphasis on the drum sound. There is a male vocal that can be barely heard over the sound of the bass guitar and the acoustic drums. The piece is easygoing. This recording can be sampled for use in beat-making. | 2010-02-18T08:24:09Z | Kandanai Visuthsiri | พี่เน มือกลองวงลิปตา ซาวน์เช็คงาน Bangkok Winter Music Festival 2010 ที่สนามราชมังคลากีฬาสถาน ครับ | ["Music", "Exciting music"] | ["jam", "sound check", "amateur recording", "poor quality", "t-pop", "male vocal", "bass guitar", "acoustic drums", "easygoing"] | 9 | O73wigUotGo | 2401 |
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;