musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "noisy", musiccaps_aspects contains "punchy snare" and musiccaps_aspects contains "soulful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- groovy bass 2
- noisy · 2 ✖
- punchy snare · 2 ✖
- soulful · 2 ✖
- acoustic rhythm guitar 1
- electric guitar melodies 1
- electric guitar melody 1
- emotional 1
- harmonizing male vocals 1
- hopeful 1
- joyful 1
- live performance 1
- low quality 1
- mellow kick hits 1
- mono 1
- passionate male vocal 1
- playback instrumental 1
- rock 1
- shimmering hi hats 1
- shimmering tambourine 1
- soft kick hits 1
- soul 1
- sustained strings melody 1
- toms roll 1
musiccaps_names (array) 5 ✖
- Music 2
- /t/dd00003 1
- Psychedelic rock 1
- Rock and roll 1
- Rock music 1
youtube_published (date) 2 ✖
- 2008-12-15 1
- 2010-03-07 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
New York Subway's Danny Small aka Singing Dragon | The low quality recording features a live performance of a soul song and it consists of passionate male vocal singing over playback instrumentals. The instrumental consists of a shimmering tambourine layered with punchy snare hits, soft kick hits, some toms rolls, groovy bass, electric guitar melody and harmonizing male vocals. It sounds emotional, soulful, hopeful and joyful. | 2010-03-07T21:11:15Z | BayardStudios | He calls himself the "Singing Dragon", his name is Mitchell Hughes aka Danny Small of Gheechee Records LLC aka the Singing Dragon and he was performing at the 14th St/6th Ave station. Originally from South Carolina, there is logic to the moniker Singing Dragon, he was born the same year as Bruce Lee in the Chinese calendar year of the Dragon, of Puerto Rican, Dominican, Cuban, Brazilian, Mexican and Guyanese and even Chinese descent. A marvel amongst subway performers, what a wonderful way to end a walkabout. Shot with a Canon 5D Mark II, Canon 16-35mm f/2.8L, recorded with the in-camera mic and moderately mixed in Final Cut Pro 6. | ["Music", "/t/dd00003"] | ["low quality", "live performance", "noisy", "mono", "passionate male vocal", "soul", "playback instrumental", "shimmering tambourine", "punchy snare", "groovy bass", "electric guitar melody", "soft kick hits", "toms roll", "harmonizing male vocals", "emotional", "hopeful", "joyful", "soulful"] | 4 | l1coM570kVw | 4370 |
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;