musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "medium tempo", musiccaps_aspects contains "sentimental" and musiccaps_aspects contains "simple melody"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- medium tempo · 2 ✖
- romantic 2
- sentimental · 2 ✖
- simple melody · 2 ✖
- acoustic guitar 1
- ambient 1
- cheerful 1
- country hits 1
- country pop 1
- cymbals 1
- duet 1
- electric guitar 1
- emotional 1
- engaging 1
- euphonious 1
- folk music 1
- folk pop 1
- instrumental 1
- lingering 1
- mandolin 1
- mellifluous 1
- mellow 1
- melodic 1
- melodious 1
- pleasant 1
- pop 1
- sedate 1
- soft 1
- soft pop 1
- soft rock 1
- soothing 1
- steady drumming 1
- string instruments 1
- subtle bass lines 1
- synthesiser arrangement 1
- tambourine beats 1
- ukelele 1
musiccaps_names (array) 7 ✖
- Music 2
- Distortion 1
- Electric guitar 1
- Mandolin 1
- Singing 1
- Ukulele 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dave and John ....pedal steel and telecaster | This music is an electronic guitar instrumental. The tempo is medium with a harmonious electric guitar lead, steady drumming, subtle bass ,tambourine beats and synthesiser arrangement. The music is a pleasant, soothing, unhurried, calm, romantic, sentimental , sedate and lingering Electric Guitar, soft pop instrumental. | 2011-02-03T01:36:36Z | Bob Adams | David Hartley and John Stannard's duet on Chasing Rainbows.. super stuff as ever! At JD's steel meeting in the south of England Jan 2011 | ["Electric guitar", "Music", "Wedding music", "Distortion"] | ["instrumental", "medium tempo", "electric guitar", "lingering", "sedate", "romantic", "sentimental", "soft pop", "soft rock", "subtle bass lines", "steady drumming", "tambourine beats", "melodic", "pleasant", "soothing", "ambient", "romantic", "synthesiser arrangement", "steady drumming", "cymbals", "simple melody", "euphonious", "engaging", "cheerful", "sentimental", "ambient"] | 7 | bt7rDryN7G4 | 3663 | |
Mandolin Orange - Wake Me @Pickathon 2014 On The Farm | This song is a pleasant love song duet. The tempo is medium with acoustic guitar and ukulele accompaniment.the song is mellow, soft, emotional, romantic, nostalgic. This song is Country/Folk pop. | 2015-01-29T23:15:41Z | Pickathon | http://pickathon.com/ Presents Mandolin Orange live at Pendarvis Farm. Filmed on August 2, 2014 Channel Host: http://Grist.org Song: Wake Me Record Label: http://www.redeyeusa.com/ Producer: Ryan Stiles Executive Producer: Zale Schoenborn Associate Producer: Eric Schoenborn, Terry Groves, Ned Failing, John MacArthur Production Manager: Seth Chandler Production Coordinator: Alisha Flaumenbaum Editor: Stephanie Manzo Camera: Emilee Booher Audio/Co-Producer: Dylan McNab http://www.mandolinorange.com/ http://pickathon.com | ["Singing", "Music", "Mandolin", "Ukulele"] | ["duet", "medium tempo", "ukelele", "folk pop", "folk music", "mellifluous", "simple melody", "country pop", "country hits", "string instruments", "folk music", "acoustic guitar", "mandolin", "melodious", "pop", "country pop", "mellifluous", "romantic", "emotional", "sentimental", "soft", "mellow"] | 7 | n1fY-23ffl0 | 4513 |
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;