musiccaps_details (view)
4 rows where musiccaps_aspects contains "romantic", musiccaps_author = 1 and musiccaps_names contains "Blues"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Sivert Høyem - Where Is My Moon? (Official Music Video) | A male singer sings this poignant melody. The tempo pop is slow with a steady drumming rhythm, cymbal crashes, guitar accompaniment, keyboard organ accompaniment and a strong bass line. The song is a poignant love song. | 2012-08-22T13:37:36Z | Sivert Høyem | New single, taken off the upcoming "Where s My Moon EP" - out Sept 21th. Buy/Stream: WiMP: http://www.smarturl.it/moonwimp iTunes: http://smarturl.it/moonitunes Spotify: http://smarturl.it/moonspotify EP iTunes: http://itunes.apple.com/no/album/where-is-my-moon-ep/id556250399?l=nb WiMP: http://wimp.no/album/16905855 Spotify: http://open.spotify.com/album/5ClXDaBHFRHBlMlpl2YoZt Follow Sivert: http://www.siverthoyem.com http://www.facebook.com/sivert.hoyem http://www.twitter.com/siverthoyem Directed & Produced by Thor Brenne DOP: Martin Edelsteen fnf Edit: Thor Brenne VFX & Online: Cato Lauvli Typography: Christian Albriktsen Gaffers: Daniel Berrum & Jon-Andrè Hakvåg Grip: Espen Zubi/Gripservice Sivert Høyem - Autumn in Arcadia - Solo European Tour: Norway: 04. okt - Tromsø, Verdensteatret 05. okt - Tromsø, Verdensteatret 06. okt - Sortland, Kinoen 11. okt - Trondheim, Byscenen 12. okt - Bergen, Gamle Logen 13. okt - Oslo, Kulturkirken Jakob 20. okt - Drammen Teater Europe: 31 okt - Kofmehl, Solothurn, Switzerland 1 nov - Plaza, Zurich, Sveits 3 nov - Faust, Hannover, Germany 4 nov - Heimathafen, Berlin, Germany 5 nov - Mousonturm, Frankfurt, Germany 6 nov - Petit Bain, Paris, France 8 nov - Paradjiskerk, Rotterdam, Holland 9 nov - Amstelkerk, Amsterdam, Holland 10 nov - Trix, Antwerp, Belgium 11 nov - Bush Hall, London, UK 28 nov - Lithografion, Patra, Greece 29 nov - Acropol, Aten, Greece 30 nov - Stage Club Larissa, Larissa, Greece | ["Blues", "Music"] | ["male singer", "poignant mood", "slow tempo", "reflecting", "nostalgia", "old memories", "good old times", "vocal echoes", "guitar strumming", "keyboard organ accompaniment", "steady drumming rhythm", "cymbal crashes", "elanchoilic", "emotional", "sentimental", "romantic", "love song", "modern pop song", "strong bass line"] | 1 | 6jeq5lP5Up0 | 782 | |
| Gaby Moreno - "Blues de mar" (Audio Single) | A female singer sings this beautiful vintage French melody. The song is medium tempo with a steady drum rhythm, steady bass line, piano accompaniment , string section harmony and some lush snare play. The song is romantic and cheerful with an avant-garde nature. | 2012-10-18T23:56:00Z | Gaby Moreno | @Gaby_Moreno | ["Blues", "Music"] | ["female singer", "lilting melody", "vocal vibrato", "avant-garde", "string section accompaniment", "piano accompaniment", "steady drumming rhythm", "snare playing", "retro pop hits", "avante-garde", "french jazz", "retro jazz", "pleasant", "emotional", "it’s a wonderful life", "carefree", "love song", "retro hits", "vintage pop", "vintage jazz", "cheerful", "romantic"] | 1 | DgqPgNqW2hE | 1504 | |
| Mavericks - Things You Said To Me (Live In Austin) | A male singer sings this cool melody. The song is medium tempo with a groovy guitar lead and steady drumming with tambourine percussion. The song is cool and sophisticated. The audio quality is bad. | 2009-08-31T06:32:02Z | leshumphrey | ["Blues", "Singing"] | ["bass guitar solo", "male singer", "guitar lead", "retro pop hits", "noir style", "rhythm guitar", "percussion hits", "love song", "missing you", "together forever", "strong bass guitar", "percussions", "big band", "story telling", "romantic", "emotional", "groovy", "tambourine percussions", "medium tempo", "bad audio quality"] | 1 | FXVu-YwjhxM | 1646 | ||
| 4 Albert King Style Blues Licks (Slow Blues Guitar Lesson) | The song is an instrumental. The tempo is medium with a slick drumming rhythm starting with a solid drum introduction, strong bass line and a blues guitar solo. The song is energetic and passionate. The audio quality is excellent. | 2011-05-20T21:29:49Z | Texas Blues Alley | * Join The TXBA Locals: https://texasbluesalley.com/locals * TXBA Email List: https://texasbluesalley.com/email * Lesson page: https://texasbluesalley.com/woodshed/free/4-albert-king-style-licks * Insta: https://instagram.com/texasbluesalley * Twitter: https://twitter.com/texasbluesalley In this free lesson, you'll learn 4 licks from the Albert's Influence course. If you like this video, you'll love the course. Join the TXBA Locals today for unlimited access to our huge library of Texas Blues guitar courses. | ["Blues", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["electric guitar blues", "instrumental music", "blues guitar lessons", "legendary licks", "excellent audio quality", "the blues", "blues guitar tutorial", "romantic", "the lush life", "blues legends", "sophisticated", "blues guitar licks", "new orleans blues", "blues hits", "relaxing music", "energetic", "passionate", "groovy", "solid intro", "blues giants", "romantic", "massive drum roll", "medium tempo"] | 1 | JLYb7DwCaQU | 1994 |
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;