musiccaps_details (view)
6 rows where musiccaps_aspects contains "medium tempo", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "western classical music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 82 ✖
- instrumental music 6
- medium tempo · 6 ✖
- passionate · 6 ✖
- western classical music · 6 ✖
- poor audio quality 4
- emotional 3
- exciting 3
- great composers 3
- live audience 3
- live performance 3
- bach 2
- bad audio quality 2
- baroque music 2
- cellist 2
- cello 2
- conductors 2
- opera hall 2
- philharmonic orchestra 2
- romantic 2
- spirited 2
- acoustic guitar strumming 1
- ambient room noises 1
- bow 1
- brass section 1
- building anticipation 1
- cello concerto 1
- cello suite 1
- cheerful 1
- composer 1
- composers 1
- concert hall 1
- concerto 1
- conductor 1
- dance music 1
- dvorak 1
- energetic 1
- engaging 1
- enthusiastic 1
- fingering technique 1
- great technique 1
- groovy music 1
- harpsichord 1
- harpsichord harmony 1
- harpsichord player 1
- harpsichordist 1
- home video 1
- live elector 1
- live music 1
- live recording 1
- loud drumming 1
- low pitched notes 1
- mace 1
- majestic 1
- male bravado 1
- male opera singer 1
- no other instrumentation 1
- nostalgic 1
- party music 1
- practice session 1
- royal dance 1
- soloist 1
- soundboard 1
- steady marching rhythm 1
- string harmony 1
- string orchestra 1
- string quartet 1
- string section 1
- string trio 1
- strings 1
- studio performance 1
- studio session 1
- timpani bangs loud 1
- timpani playing 1
- trumpets blaring 1
- two harpsichords 1
- victory march 1
- viola 1
- violin 1
- violins playing harmony 1
- virtuously 1
- wedding music 1
- wind sections 1
musiccaps_names (array) 13 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
J.S.Bach - Cello Suite No.1 - Prelude - Double Bass | The song is an instrumental. The tempo is medium with a cellist playing a JS Bach tune with exemplary skill in a rehearsal session. The song has bad audio quality. The song is a western classical music tune. | 2014-09-03T19:30:44Z | TESEO | J.S.Bach - Suite No.1 for Double Bass BWV 1007 - Prelude - Plays Francesco Tesei - New Fan Page - https://www.facebook.com/Teseoguitar - SUBSCRIBE! http://www.youtube.com/user/teseoguitar?sub_confirmation=1 | ["Cello", "Double bass", "Bowed string instrument"] | ["cello suite", "cello", "cellist", "home video", "emotional", "passionate", "romantic", "nostalgic", "instrumental music", "medium tempo", "bad audio quality", "western classical music", "bach", "practice session", "live recording", "exciting", "low pitched notes", "strings", "soundboard", "fingering technique", "bow", "studio session", "great composers", "soloist"] | 1 | B1ixRtiUJ-U | 1194 | |
Ultramarines Soundtrack Track 1 - Steel and Doom | A male opera singer sings this majestic operatic song with a philharmonic orchestra accompaniment, trumpets blaring, string section accompaniment and a strong rhythm section with loud timpani playing. The song is energetic and dramatic. The song is a movie soundtrack and western classic song with poor audio quality. | 2011-09-15T17:18:20Z | Geisto | Track 1 Steel and Doom, Sign up for Warhammer 40k, Eternal Crusade!! https://www.eternalcrusade.com/account/sign-up/?ref_code=EC-4R9LMSPIXVVW9 The amazing soundtrack from the Ultramarines Movie, Performed by Adam Harvey. http://ultramarinesthemovie.com/shop | ["Timpani", "Music", "Soundtrack music"] | ["poor audio quality", "male opera singer", "building anticipation", "philharmonic orchestra", "string orchestra", "passionate", "energetic", "steady marching rhythm", "medium tempo", "loud drumming", "majestic", "victory march", "western classical music", "male bravado", "instrumental music", "timpani playing", "trumpets blaring", "brass section"] | 1 | Pf9AaTV4-yw | 2555 | |
Couperin & Clavecin | The song is an instrumental. The song is medium tempo with a harpsichord belting played with no other instrumentation. The music is emotional, passionate and melancholic. The song audio quality is poor. | 2007-10-14T21:47:21Z | profsha | Eric DEM joue Couperin au clavecin à l'église de Cesson-Sévigné. | ["Harpsichord", "Keyboard (musical)"] | ["harpsichord", "harpsichord player", "harpsichordist", "poor audio quality", "instrumental music", "medium tempo", "composers", "conductors", "live music", "live performance", "live audience", "emotional", "spirited", "romantic", "baroque music", "passionate", "western classical music"] | 1 | S38KjqRR418 | 2737 | |
J.Mouret - Rondeau String Quartet | The song is an instrumental. The song is medium tempo with a violin, viola, cello playing a string harmony accompanied by an acoustic guitar strumming chords. The song is a western classical music piece. | 2012-06-04T17:03:48Z | cellony | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | ["violin", "viola", "cello", "acoustic guitar strumming", "poor audio quality", "wedding music", "party music", "string quartet", "string trio", "string harmony", "instrumental music", "western classical music", "live performance", "studio performance", "medium tempo", "exciting", "cheerful", "dance music", "composer", "enthusiastic", "passionate", "exciting"] | 1 | fxznho_kNPY | 3995 | ||
Bach: Concerto for 2 Harpsichords in C major, BWV 1061 (3/3) | The song is an instrumental. The tempo is medium fast with two harpsichordists playing an instrument harmony with no other instrumentation. The song is exciting like a dance but has a bad audio quality. | 2007-04-26T01:52:16Z | Ty Chan | J.S. Bach: Concerto for Two Harpsichords in C major, BWV 1061: 3. Fuga vivace Stephen Gamboa and Tyrone Chan, soloists U.C. Berkeley University Baroque Ensemble Spring 2007 Concert April 24, 2007 125 Morrison Hall | ["Harpsichord", "Keyboard (musical)", "Piano"] | ["two harpsichords", "bach", "concerto", "harpsichord harmony", "bad audio quality", "ambient room noises", "instrumental music", "western classical music", "opera hall", "great composers", "conductors", "live audience", "live elector", "mace", "engaging", "exciting", "passionate", "passionate", "baroque music", "instrumental music", "medium tempo", "royal dance", "no other instrumentation"] | 1 | spyBrs3relU | 4982 | |
Dvořák: Cello Concerto / Isserlis · Gilbert · Berliner Philharmoniker | The song is an instrumental. The tempo is medium with a cellist playing a virtuoso solo accompanied by a string section harmony, flutes in harmony and a loud banging timpani. The song is spirited and passionate with poor audio quality. The song is a western classical piece. | 2009-06-19T08:28:26Z | Berliner Philharmoniker | Full-length concert: http://www.digitalconcerthall.com/concert/27/?a=youtube&c=true Antonín Dvořák: Cello Concerto / Steven Isserlis, cello · Alan Gilbert, conductor · Berliner Philharmoniker / Recorded at the Berlin Philharmonie, 19 April 2009. The Berliner Philharmoniker's Digital Concert Hall: http://www.digitalconcerthall.com Subscribe to our newsletter: http://www.digitalconcerthall.com/newsletter Website of the Berliner Philharmoniker: http://www.berliner-philharmoniker.de | ["Cello", "Music", "Musical instrument", "Orchestra", "Violin, fiddle", "Classical music", "Bowed string instrument"] | ["cellist", "string section", "philharmonic orchestra", "cello concerto", "dvorak", "virtuously", "timpani bangs loud", "medium tempo", "wind sections", "violins playing harmony", "groovy music", "western classical music", "great composers", "conductor", "opera hall", "live audience", "live performance", "instrumental music", "passionate", "spirited", "emotional", "great technique", "poor audio quality", "concert hall"] | 1 | yrme-KRBvzk | 5445 |
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;