musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "piano" and musiccaps_names contains "Jazz" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- instrumental 2
- piano · 2 ✖
- 12 bar blues 1
- acoustic jazz drums 1
- backing track 1
- bass 1
- bass guitar 1
- guitar solo 1
- jazz 1
- light-hearted 1
- mellow 1
- no singer 1
- no voices 1
- simple percussion 1
- slow blues song 1
- slow tempo 1
- soft 1
- swing 1
musiccaps_names (array) 5 ✖
- Jazz · 2 ✖
- Music 2
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fly Me To The Moon Jazz Backing Track | This is an instrumental backing track of a jazz music piece. There is no singer in this version of the piece. The piano is playing the chords in the minor key while a bass guitar can be heard playing a walking bass line. The rhythmic background consists of acoustic drums playing a jazz swing beat. The atmosphere is delicate. This piece could be playing in the background at a coffee shop. It could be used in the soundtrack of a romantic movie. | 2009-08-13T06:58:18Z | gamerohan | This is a Fly Me To The Moon backing track (C MAJOR) Chords as followed | Am7 | Dm7 | G7 | CM7 | FM7 | Bm7b5 | E7b9 | | Am7 | Dm7 | G9 | CM9 | Am7 | Dm7 | G7 | CM7 | Bm7, E7 | | Am7 | Dm7 | G7 | CM7 | FM7 | B half dim. | E7 b9 | | Am7 | Dm7 | G9 | First Ending | Em7b5 | A7b9 | Dm7 | Dm7/G | C6 | Bm7, E7 | | Am7 | Dm7 | G7 | CM7 | FM7 | Bm7b5 | E7b9 | | Am7 | Dm7 | G9 | CM9 | Am7 | Dm7 | G7 | CM7 | Bm7, E7 | | Am7 | Dm7 | G7 | CM7 | FM7 | B half dim. | E7 b9 | | Am7 | Dm7 | G9 | Second Ending : | Em7b5 | A7b9 | Dm7 | G7 | C6 | C6 || Instruments: Bass Piano Drums Bass and Piano recorded by me , drums - garageband loop MIcrophones Used : Rode M3 Rode NT1-A | ["Jazz", "Music"] | ["jazz", "no singer", "instrumental", "backing track", "piano", "bass guitar", "acoustic jazz drums", "mellow", "soft", "swing", "light-hearted"] | 9 | 3TQmts_MxyQ | 471 | |
Jazzed Blues Solo | This slow blues song features a solo played on a guitar. The tempo of this song is slow. This is accompanied by percussion playing a simple beat. The bass follows the 12 bar blues pattern. The piano plays chords in the background. The mood of this song is romantic and the pattern played on the guitar is similar to a call-response theme. This song can be played in a bar. | 2006-07-17T14:30:15Z | looptruefire | My favorite solo from TrueFire's Jazz ed Blues course with Mark Stefani. | ["Guitar", "Jazz", "Music", "Musical instrument", "Plucked string instrument"] | ["slow blues song", "instrumental", "guitar solo", "bass", "simple percussion", "12 bar blues", "piano", "slow tempo", "no voices"] | 0 | qAgZ__fk9LY | 4760 |
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;