musiccaps_details (view)
2 rows where musiccaps_aspects contains "piano", musiccaps_author = 9 and musiccaps_names contains "Jazz"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- instrumental 2
- jazz 2
- piano · 2 ✖
- acoustic drums 1
- acoustic jazz drums 1
- backing track 1
- bass guitar 1
- big band 1
- clarinet 1
- flute 1
- light-hearted 1
- lively 1
- mellow 1
- no singer 1
- playful 1
- saxophone 1
- soft 1
- swing 1
- trumpet 1
- upbeat 1
- upright bass 1
- winds section 1
musiccaps_names (array) 3 ✖
- Jazz · 2 ✖
- Music 2
- Swing music 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 | |
A Griffon Day | This is a big band jazz music piece. It is an instrumental piece. The main melody is played by a wide variety of the winds section composed of the saxophone, the trumpet, the flute and the clarinet. The piano and the upright bass provide backing structures. The rhythmic background consists of a jazz acoustic drum beat. The atmosphere is playful. This piece could fit perfectly in the soundtrack of a Disney-type animation movie. | 2008-01-27T00:18:25Z | George Pfeiffer | Gus the Brussels Griffon documents a typical day in his life. If you like dogs...or monkeys...or Ewoks....then you'll love this little pooch! | ["Swing music", "Jazz", "Music"] | ["jazz", "big band", "instrumental", "winds section", "saxophone", "trumpet", "flute", "clarinet", "upright bass", "piano", "acoustic drums", "lively", "playful", "upbeat"] | 9 | JU6GUqRqbtI | 2011 |
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;