musiccaps_details (view)
3 rows where search matches "guitar" and musiccaps_aspects contains "resonator guitar" sorted by youtube_description descending
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- resonator guitar · 3 ✖
- mellow 2
- soft 2
- acoustic guitar 1
- auto harp 1
- blues guitar 1
- breakup 1
- breakup song 1
- busking 1
- captivating 1
- cello 1
- country pop 1
- country song 1
- despondent 1
- dobro 1
- emotional 1
- female singer 1
- fingerstyle guitar 1
- folk song 1
- harmonica 1
- instrumental 1
- instrumental music 1
- lonely 1
- love song 1
- medium tempo 1
- melodious tune 1
- minimalist 1
- no percussion 1
- no voices 1
- people talking in background 1
- regional music 1
- relaxing 1
- sad song 1
- sentimental 1
- serene 1
- simple melody 1
- slow tempo 1
- steady bass lines 1
- steady drumming 1
- whistling 1
musiccaps_names (array) 10 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▲ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mike Dowling " Blues In G ." | This blues guitar song features a resonator guitar. Fingerstyle guitar is being played. The melody is a blues style guitar. There are no other instruments in this song. There are no voices in this song. This song can be played in a bar. | 2014-05-08T19:25:05Z | nationalguitars | Mike Dowling presents "Blues In G." courtesy of Homespun. | ["Blues", "Guitar", "Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | ["blues guitar", "fingerstyle guitar", "no percussion", "resonator guitar", "no voices", "instrumental music", "relaxing"] | 0 | F1X7egd8Us0 | 1608 | |
~Good As I Was To You~ (With Lyrics) | A female singer sings this sad Country song. The tempo is medium with a Harmonica harmony, steady bass line, acoustic guitar, auto harp and dobro accompaniment. The song is soft, mellow, sad, poignant, emotional, sentimental and despondent with a melodious tune. This Song is a classic Country Pop. | 2008-09-22T07:04:10Z | VampiressSilvia | Lorrie Morgan's Good As I Was To You With the lyrics | ["Christian music", "Music"] | ["female singer", "medium tempo", "country song", "despondent", "melodious tune", "country pop", "regional music", "folk song", "love song", "sad song", "breakup song", "breakup", "harmonica", "steady drumming", "steady bass lines", "auto harp", "dobro", "resonator guitar", "mellow", "lonely", "soft", "sentimental", "emotional"] | 7 | tUJ_ZniLjhc | 5038 | |
AMAZING Whistling Solos! Buskers perform On A Slow Boat to China in NYC Subway | This music is a pleasant instrumental. The music is slow tempo with a soft cello and guitar duet with a whistle melody. The song is mellow, soothing, calming , dulcet, warm and relaxing in contrast to the background noises of people talking and walking. The musicians are buskers. | 2016-04-08T15:02:24Z | Benjamin Lamson | I've been living in NYC for nearly a decade and these are two of the best buskers I've ever seen. Not only is this guys voice butter but they're both amazing whistlers! My only regret is that I started filming halfway through the song. Filmed at the Metropolitan Lorimer stop on the G train. UPDATE: Vilray recorded and released his first album. Download it at http://vilray.bandcamp.com/ Band's Info: http://patreon.com/vilray http://soundcloud.com/vilray http://www.facebook.com/Vilray-75001313101/ http://www.vilraysings.com http://www.instagram.com/vilray/ http://twitter.com/theactualvilray Jukin Media Verified (Original) * For licensing / permission to use: Contact - licensing(at)jukinmediadotcom | ["Flamenco", "Music"] | ["instrumental", "slow tempo", "cello", "whistling", "resonator guitar", "acoustic guitar", "simple melody", "people talking in background", "busking", "minimalist", "soft", "mellow", "captivating", "serene"] | 7 | rfQ94EXIpTc | 4891 |
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;