musiccaps_details (view)
6 rows where musiccaps_aspects contains "live audience" and musiccaps_aspects contains "romantic"
This data as json, CSV (advanced)
musiccaps_aspects (array) 89 ✖
- live audience · 6 ✖
- live performance 6
- romantic · 6 ✖
- emotional 4
- instrumental music 4
- passionate 4
- love song 3
- poor audio quality 3
- western classical music 3
- slow tempo 2
- ambient crowd noise 1
- ambient noises 1
- ambient room noises 1
- backup singers 1
- bad audio quality 1
- baroque music 1
- beautiful love 1
- blues music 1
- blues turnaround 1
- cascade of notes 1
- cello solo 1
- clapping rhythm 1
- clarinetist 1
- classical masterpieces 1
- composers 1
- concert hall 1
- conductor 1
- conductors 1
- dance song 1
- duet 1
- endless love 1
- exciting 1
- female singer 1
- forever together 1
- fret noise 1
- great composers 1
- great vibrato 1
- groovy bass line 1
- groovy rhythm 1
- guitar accompaniment 1
- guitar notes playing 1
- guitar playing 1
- harp playing beautifully 1
- harpist 1
- harpsichord 1
- harpsichord player 1
- harpsichordist 1
- heart strings 1
- heartfelt 1
- hip hop hits 1
- hip hop music 1
- hip hops love song 1
- hissing ambient sound 1
- life is beautiful 1
- lilting vocals 1
- live music 1
- madly in love 1
- male singer 1
- masterful string technique 1
- medium tempo 1
- melancholic music 1
- opera hall 1
- orchestra 1
- philharmonic orchestra 1
- piano accompaniment 1
- pop diva 1
- pop song 1
- pop super hits 1
- precious moments 1
- pure and innocent 1
- sad 1
- sentimental 1
- singer talking 1
- slick drumming rhythm 1
- soloist 1
- song introduction 1
- soul music 1
- soul singer 1
- spirited 1
- steady drumming line 1
- string duet 1
- string quartet 1
- string section 1
- super hits 1
- theremin 1
- together forever 1
- violin solo 1
- virtuosos in play 1
- youtube music video 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Stevie Hoang - Addicted - new music video 2009 | A male singer sings this cool hip hop love song with backup singers in vocal harmony. The tempo is medium with keyboard accompaniment, piano accompaniment, steady drumming rhythm, clapping percussion and other sonic effects. The song is emotional and romantic with a cool dance groove, | 2009-05-18T16:36:44Z | steviehoang | Buy the Physicial CD http://www.cdbaby.com/cd/steviehoang3 Official Facebook https://www.facebook.com/StevieHoangMusic Twitter https://twitter.com/steviehoang | ["Music", "Soul music"] | ["male singer", "hip hop music", "backup singers", "live performance", "live audience", "super hits", "piano accompaniment", "groovy bass line", "steady drumming line", "slick drumming rhythm", "emotional", "romantic", "passionate", "together forever", "love song", "hip hop hits", "groovy rhythm", "dance song", "hip hops love song", "clapping rhythm"] | 1 | -oP-XX28B0s | 87 | |
Tubular Bells (Start of the 2nd part) on Theremin | The song is an instrumental. The song is in slow tempo with a theremin playing a melancholic melody with a guitar accompaniment. The song is emotional and lilting. The audio quality is poor. | 2007-05-29T15:55:35Z | DANI ROTTENBRAIN | Versión thereministica del principio de la segunda parte de tubular bells de Mike Oldfield | ["Music", "Theremin"] | ["theremin", "emotional", "guitar accompaniment", "poor audio quality", "romantic", "love song", "endless love", "forever together", "ambient noises", "youtube music video", "beautiful love", "pure and innocent", "live performance", "live audience", "melancholic music", "instrumental music", "slow tempo", "emotional", "sad"] | 1 | 03frQGyrgQ4 | 114 | |
Adele North American Tour 2008 | A female singer sings this bluesy melody. The song is medium tempo with minimal guitar accompaniment and no other instrumentation. The song's medium tempo is very emotional and passionate. The song is a modern pop hit but with poor audio quality. | 2011-03-17T20:16:50Z | Viswijfable | This shortfilm was on the bonus disc. of 19. Directed by Charlie Robins © | ["Singing", "Music", "/t/dd00004", "Inside, large room or hall"] | ["female singer", "blues music", "live audience", "romantic", "hissing ambient sound", "madly in love", "love song", "passionate", "ambient crowd noise", "guitar playing", "singer talking", "song introduction", "blues turnaround", "fret noise", "pop song", "pop super hits", "pop diva", "poor audio quality", "guitar notes playing", "live performance", "lilting vocals", "soul singer", "soul music"] | 1 | B90BOtSOD2Q | 1210 | |
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 | |
Ravel Introduction et Allegro for Harp, stringquartet, flute, clarinet | The song is an instrumental. The song is in medium tempo with a harpist playing a beautiful cascade of notes while the orchestra watches. The song is exciting and passionate. The audio quality is poor. | 2008-10-20T22:15:32Z | eefkedegeus | Introduction et Allegro M. Ravel Harp, stringquartet, flute, clarinet. From left to right Mariana, Angela, David, Cristina, Eefke, Miguel, Germaine. M. Ravel - Introduction et Allegro Royal Conservatory Den Haag, Holland | ["Harp"] | ["harpist", "harp playing beautifully", "clarinetist", "string quartet", "bad audio quality", "live audience", "life is beautiful", "precious moments", "classical masterpieces", "live performance", "ambient room noises", "slow tempo", "cascade of notes", "live performance", "soloist", "western classical music", "exciting", "romantic", "instrumental music"] | 1 | u8aB6EALonk | 5091 | |
Kirito - Icaross (Orchestra Version) | The song is an instrumental. The song is slow tempo with a violin and cello playing a duet with no other instrumentation. The song is emotional and extremely heartfelt. The song is a western classical music hit. | 2007-09-07T19:31:10Z | Marcus | live from Kiritos Symphonic Concert | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | ["violin solo", "cello solo", "string duet", "heartfelt", "duet", "orchestra", "opera hall", "concert hall", "live audience", "string section", "great composers", "great vibrato", "masterful string technique", "virtuosos in play", "conductor", "live performance", "heart strings", "instrumental music", "philharmonic orchestra", "western classical music", "emotional", "romantic", "passionate", "sentimental"] | 1 | wBe5tW8iJew | 5246 |
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;