musiccaps_details (view)
3 rows where musiccaps_aspects contains "loud", musiccaps_author = 4 and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- loud · 3 ✖
- low quality 3
- distorted 2
- live performance 2
- "4 on the floor" kick pattern 1
- aggressive strumming 1
- flat male vocal 1
- groovy 1
- groovy didgeridoo 1
- happy 1
- hollow 1
- loud impact 1
- noisy 1
- playback 1
- shimmering hi hats 1
- snappy rimshots 1
- tuba solo melody 1
- uptempo acoustic rhythm guitar chord progression 1
musiccaps_names (array) 9 ✖
- Music 3
- Musical instrument · 3 ✖
- Brass instrument 1
- Didgeridoo 1
- Foghorn 1
- Guitar 1
- Orchestra 1
- Plucked string instrument 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Vaughan Williams Tuba Concerto Part 3 | The low quality recording features a live performance that consists of a tuba solo melody and some loud impact in the background. The recording is noisy, loud and distorted. | 2008-06-17T12:09:48Z | sersvet | National Filarmonica, Chisinau,R.V. Williams - Tuba Concerto, Part 3. Solist Serghei Svet | ["Brass instrument", "Foghorn", "Music", "Musical instrument", "Orchestra"] | ["low quality", "loud", "distorted", "loud impact", "tuba solo melody", "noisy", "live performance"] | 4 | KB4e9v_5uTE | 2062 | |
Aboriginal DIDGERIDOO Playing Live in Sydney | The low quality recording features a groovy didgeridoo playing over playback that consists of a "4 on the floor" kick pattern and shimmering hi hats, followed by snappy rimshots. There is a flat male vocal talking at one point. The recording is loud, distorted and it sounds groovy overall. | 2007-09-13T09:57:48Z | Andy Lloyd | What is says lol | ["Didgeridoo", "Music", "Musical instrument"] | ["low quality", "live performance", "groovy didgeridoo", "shimmering hi hats", "snappy rimshots", "\"4 on the floor\" kick pattern", "playback", "flat male vocal", "loud", "distorted", "groovy"] | 4 | VgwsGjRk61M | 3021 | |
He'eia (Ukulele, Traditional Hawaiian Song) | The low quality recording features an acoustic rhythm guitar being aggressively strummed, while producing some happy sounding melodies. The guitar sounds a bit hollow, almost as if it is recorded with a phone. | 2007-02-20T21:09:49Z | Chris Brown | He'eia is an traditional Hawaiian song about the Kings favorite surfing spot. It was originally a chant that has been adapted to ukulele. Carl Ray VillaVerde plays both rhythm and lead in this version. He and wife Joannie form a duet called "Mango" and have produced a number of entertaining recordings. There is a site where downloads and CD's are available at http://cdbaby.com/cd/mangolilikoi | ["Guitar", "Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["low quality", "uptempo acoustic rhythm guitar chord progression", "hollow", "loud", "aggressive strumming", "happy"] | 4 | mW5_chAgg8c | 4475 |
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;