musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "acoustic drums" and musiccaps_names contains "Wind instrument, woodwind instrument" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- acoustic drums · 3 ✖
- bass guitar 2
- instrumental 2
- acoustic guitar 1
- amateur recording 1
- backing track 1
- blues 1
- cuban ska 1
- e-bass 1
- e-guitar 1
- easygoing 1
- electric guitar 1
- energetic 1
- glockenspiel 1
- harmonica 1
- harmonica solo 1
- heart-touching 1
- hindi film music 1
- lively 1
- no singer 1
- organ 1
- piano 1
- rock-n-roll 1
- saxophones 1
- trumpets 1
- upbeat 1
- vibrant 1
musiccaps_names (array) 4 ✖
- Wind instrument, woodwind instrument · 3 ✖
- Harmonica 2
- Accordion 1
- 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 | |
Ska Cubano - Identity | This audio contains acoustic drums playing something like a reggae groove along with an e-bass. A e-guitar strumming chords, piano, organ saxophones and trumpets are playing a short melody on the backbeat giving this song its reggae feeling. In-between the instruments are playing a short loud melody to break into the next part. The instruments are spread across the sides of the speakers. This audio may be playing in an urban coffee shop. | 2011-05-16T22:21:47Z | Eder Eulogio | Canción del disco Mambo Ska de esta banda de nacionalidades múltiples y que ha resaltado la cultura musical de dos islas caribeñas como lo son Cuba y Jamaica..... Disfruten, Comenten y Suscríbanse!!!!!!!!!!!!!! | ["Wind instrument, woodwind instrument", "Accordion"] | ["cuban ska", "e-guitar", "trumpets", "saxophones", "organ", "piano", "acoustic drums", "e-bass", "upbeat", "energetic"] | 6 | nW6Naj6eeI4 | 4547 | |
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;