musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "amateur recording" and musiccaps_aspects contains "melancholic" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- amateur recording · 2 ✖
- melancholic · 2 ✖
- acoustic 1
- acoustic drums 1
- buskers 1
- busking 1
- cajun percussion 1
- deeper male voice singing 1
- e-bass 1
- e-guitar 1
- earnest 1
- emotional 1
- keyboard accompaniment 1
- male vocalist 1
- mediumto uptempo 1
- mellow acoustic guitar 1
- minimalist 1
- organ 1
- pensive 1
- romantic 1
- sentimental 1
- simple 1
- slow tempo 1
- soft 1
- unplugged 1
musiccaps_names (array) 7 ✖
- Electric piano 1
- Electronic organ 1
- Keyboard (musical) 1
- Music 1
- Organ 1
- Piano 1
- Tick 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Love Street - The Doors - Vox Continental & Fender Rhodes Piano Bass | Someone is playing a melody on an electric organ in a minor key. An acoustic drum is playing a simple groove with single hits on the ride. An e-bass is playing the root note of the melody accompanied by a clean e-guitar sound fingerpicking the chords. Then a deeper male voice starts singing. This song may be playing in a sad romantic movie scene. | 2010-11-17T22:29:18Z | Willem Vonhof | I´m playing Love Street by The Doors. The authentic instruments I used in this video are a Vox Continental (1967) and a Fender Rhodes Piano Bass (1972). Enjoy, Please rate & comment! | ["Organ", "Electric piano", "Electronic organ", "Keyboard (musical)", "Piano"] | ["amateur recording", "acoustic drums", "e-bass", "organ", "e-guitar", "deeper male voice singing", "mediumto uptempo", "melancholic"] | 6 | p2yedR_jMTU | 4684 | |
Walking On Cars - Tick Tock (acoustic) 4.2.16 | A male vocalist sings this soft pop. The tempo is slow with a simple piano accompaniment, mellow acoustic guitar and rhythmic Cajun beats. The song is a simple, unaffected, romantic, melodic, sentimental, emotional and pensive Pop. | 2016-02-05T11:40:49Z | Kerri Loughney | Walking On Cars performing an acoustic version of Tick Tock from their new album Everything This Way. Performed in Banquet Records, Kingston for the album release on the 4th of February 2016. Enjoy! Check out my other videos from the Walking On Cars acoustic in-store show at Banquet Records: Always Be With You - https://www.youtube.com/watch?v=FG-wYSnmEwo Hand In Hand - https://www.youtube.com/watch?v=oaEMyV_dOXw Flying High Falling Low - https://www.youtube.com/watch?v=6M6AcVAQJMI Catch Me If You Can - https://www.youtube.com/watch?v=6nhEE5NpglQ Speeding Cars - https://www.youtube.com/watch?v=1YDNRlYRahs Plus check out Banquet's videos from the night! In-store - https://www.youtube.com/watch?v=aid6nk5I5Bw New Slang - https://www.youtube.com/watch?v=e-WkwnHWUJE | ["Music", "Tick"] | ["male vocalist", "slow tempo", "acoustic", "minimalist", "busking", "buskers", "simple", "earnest", "emotional", "sentimental", "keyboard accompaniment", "mellow acoustic guitar", "cajun percussion", "soft", "melancholic", "romantic", "pensive", "unplugged", "amateur recording"] | 7 | UDN11Q90Fa4 | 2895 |
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;