musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "acoustic drums" and musiccaps_names contains "Harmonica" sorted by youtube_published
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 18 ✖
- acoustic drums · 2 ✖
- bass guitar 2
- instrumental 2
- acoustic guitar 1
- amateur recording 1
- backing track 1
- blues 1
- easygoing 1
- electric guitar 1
- glockenspiel 1
- harmonica 1
- harmonica solo 1
- heart-touching 1
- hindi film music 1
- lively 1
- no singer 1
- rock-n-roll 1
- vibrant 1
musiccaps_names (array) 3 ✖
- Harmonica · 2 ✖
- Wind instrument, woodwind instrument 2
- Jingle, tinkle 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Yeh hai bombay meri jan-Milon Gupta | This is a Hindi film music piece. This is an instrumental piece. The harmonica is playing a cheerful melody in the lead. The glockenspiel is playing a secondary melody while the acoustic guitar and the bass guitar are supporting them in the background. The acoustic drums are playing a jazz swing beat with the brushes. The atmosphere is lively. This piece could be used in a feelgood movie during scenes where everything is going well for the main character. | 2010-07-12T16:07:06Z | ramanaraaga | Yeh hai bombay meri jan from the movie "CID" played on harmonica by Shri Milon Gupta | ["Harmonica", "Jingle, tinkle", "Wind instrument, woodwind instrument"] | ["hindi film music", "no singer", "instrumental", "harmonica", "glockenspiel", "acoustic guitar", "bass guitar", "acoustic drums", "vibrant", "lively", "heart-touching"] | 9 | 8dE1x--TuF8 | 932 | |
Mondharmonica beginners video 5; solo opbouw deel 1 : diverse loopjes | This is an amateur recording of a harmonica solo being performed over a blues/rock-n-roll music piece. The piece is instrumental. The harmonica plays a melodic solo in the style of blues. The backing track consists of the electric guitar and the bass guitar playing a simple tune while the medium tempo acoustic drums are playing a basic blues rock beat. The atmosphere is easygoing. This piece could be playing from the radio during a road trip in a movie. | 2011-05-23T18:08:11Z | Harmonicaworkshops | Toonsoort: G , harp in C Video-instructie behorende bij de vervolg-lessen van Hans de Vries. Een solo wint aan kracht als je structuur aanbrengt. Al met een paar eenvoudige loopjes kun je een functionele solo spelen... je kunt in deze solo ook nog je handen gebruiken voor een mooi vibrato affect. Ik laat dit achterwege, zodat je goed kunt zien wat ik doe. De originele backingtrack om zelf op los te gaan , vind je hier: https://www.youtube.com/watch?v=68dvF4_5HK0 Want more? zie http://www.harmonicatips.nl | ["Harmonica", "Wind instrument, woodwind instrument"] | ["amateur recording", "blues", "rock-n-roll", "instrumental", "harmonica solo", "backing track", "electric guitar", "bass guitar", "acoustic drums", "easygoing"] | 9 | Ypuv3htJlpg | 3313 |
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;