musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "noisy" and musiccaps_aspects contains "sustained strings melody" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- noisy · 3 ✖
- sustained strings melody · 3 ✖
- low quality 2
- acoustic rhythm guitar 1
- compressed 1
- electric guitar melodies 1
- emotional 1
- enka 1
- flute solo melody 1
- groovy bass 1
- groovy percussive elements 1
- heartfelt 1
- live performance 1
- loud 1
- mellow bells chord progression 1
- mellow kick hits 1
- mono 1
- passionate 1
- punchy snare 1
- rock 1
- shimmering hi hats 1
- sitar guitar melody 1
- soulful 1
- steel guitar solo melody 1
- sustained brass melody 1
musiccaps_names (array) 8 ✖
- Music 3
- Flamenco 1
- Pizzicato 1
- Psychedelic rock 1
- Rock and roll 1
- Rock music 1
- Traditional music 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Enka - itsuki hiroshi | The low quality recording features an Enka song that consists of a steel guitar solo melody, mellow bell chord progression, sustained strings melody and sustained brass melody. The recording is noisy and in mono, and it sounds emotional, heartfelt and passionate. | 2007-08-06T13:45:53Z | Ali mohammed yousof | music video | ["Music", "Ukulele", "Pizzicato"] | ["enka", "low quality", "mono", "steel guitar solo melody", "sustained strings melody", "sustained brass melody", "emotional", "heartfelt", "passionate", "noisy", "mellow bells chord progression"] | 4 | nvvXOfLs-ng | 4595 | |
Palestinian Traditional Music @ GlobalCAFE | The low quality recording features a live performance of percussive elements, sitar guitar melody, sustained strings melody, groovy percussive elements and flute solo melody. The recording is noisy and it sounds compressed and loud. | 2008-07-21T00:38:40Z | Bevin Ginder | Enjoy some Palestinian music from Bethlehem featuring the Oud, the Darbuka and a type of flute.GlobalCAFE is a travel video podcast celebrating people, places, & purpose... join the EPIC! Subscribe to GlobalCAFE for free. | ["Traditional music", "Flamenco", "Music"] | ["low quality", "live performance", "groovy percussive elements", "sitar guitar melody", "sustained strings melody", "flute solo melody", "noisy", "compressed", "loud"] | 4 | hQ5OBio4Cy0 | 4102 | |
Duane Eddy - Because They`re Young | The Rock song features a sustained strings melody, groovy bass, electric guitar melodies, punchy snare, shimmering hi hats, mellow kick hits and acoustic rhythm guitar. It sounds soulful and like something you would hear during the 70s. The recording is a bit noisy. | 2008-12-15T22:20:12Z | 45RPMbyMikeEvans | Duane Eddy`s UK chart hit singles - 1958 Rebel Rouser #19 1959 Cannonball #22 1959 Peter Gunn # 6 1959 Yep! #17 1959 40 Miles of Bad Road #11 1959 Some Kind-A-Earthquake #12 1960 Bonnie Came Back #12 1960 Shazam #4 1960 Becuase They`re Young #2 1960 Kommotion #13 1961 Pepe #2 1961 Theme From Dixie #7 1961 Ring Of Fire #17 1961 Drivin` Home #30 1961 Caravan #42 1962 Deep In The Heart Of Texas #19 1962 Ballad Of Paladin #10 1962 ( Dance With The ) Guitar Man # 4 1963 Boss guitar # 27 1963 Lonely Boy Lonely Guitar #35 1963 Your Baby`s Gone Surfin` #49 1975 Play Me Like You Play Your Guitar #9 1986 Peter Gunn #8 ( with Art of Noise ) | ["Music", "Psychedelic rock", "Rock music", "Rock and roll"] | ["rock", "sustained strings melody", "groovy bass", "electric guitar melodies", "punchy snare", "shimmering hi hats", "mellow kick hits", "acoustic rhythm guitar", "soulful", "noisy"] | 4 | bKm2_67xtVs | 3617 |
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;