musiccaps_details (view)
3 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "people talking" and musiccaps_aspects contains "poor audio quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- emotional · 3 ✖
- people talking · 3 ✖
- poor audio quality · 3 ✖
- groovy bass line 2
- instrumental music 2
- live performance 2
- medium tempo 2
- adventurous 1
- ambient crowd noises 1
- ambient noise 1
- ambient room nosiness 1
- bass rhythm 1
- cheerful 1
- chromatic harmony 1
- classic western music 1
- couples dan 1
- crystal glass harp solo 1
- dance music 1
- energetic 1
- family gatherings 1
- fast tempo 1
- festive spirit 1
- folk dance music 1
- folk music 1
- glass harp 1
- guitar accompaniment 1
- guitarist 1
- harpist 1
- hissing tones 1
- instrumental duo 1
- magical journey 1
- male singer 1
- mysterious 1
- passionate 1
- positive 1
- romantic 1
- sentimental 1
- solo performance 1
- south american folk music 1
- steady percussions 1
- story telling 1
- togetherness 1
- traditional custom dance 1
- violinist 1
- virtuoso glass harpist 1
musiccaps_names (array) 9 ✖
- Music 2
- Bowed string instrument 1
- Glass 1
- Harp 1
- Pizzicato 1
- Rattle (instrument) 1
- Singing 1
- Tubular bells 1
- Violin, fiddle 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
PARARCA - OCT - 2013 - ARPA Y VIOLIN (A) | The song is instrumental. The tempo is medium with a harpist playing a bass line accompanying a violist. The song is folk-like with a dance rhythm. The audio quality is poor with ambient crowd noise. | 2013-11-01T18:51:07Z | Johnny Torres | ["Harp", "Violin, fiddle", "Pizzicato", "Bowed string instrument"] | ["harpist", "violinist", "dance music", "groovy bass line", "instrumental music", "couples dan", "family gatherings", "poor audio quality", "romantic", "south american folk music", "folk dance music", "instrumental duo", "people talking", "ambient crowd noises", "medium tempo", "sentimental", "emotional", "cheerful", "positive", "festive spirit", "togetherness", "traditional custom dance"] | 1 | 8DQbnR7hwpc | 904 | ||
Musical Crystal Glasses Like Never Before | The song is an instrumental piece. The song is fast tempo with a glass harpist playing an extremely intricate solo with no other instrumentation . The song is magical and mysterious. The song is a live performance with ambient sounds of people talking in the background. | 2008-02-14T01:47:31Z | Amplify | I've only seen this in dramatized situations (film, cartoon). This man is ridiculous. I bet he could satisfy a classroom of women all at once. | ["Tubular bells", "Glass", "Music"] | ["crystal glass harp solo", "glass harp", "live performance", "hissing tones", "people talking", "instrumental music", "mysterious", "adventurous", "magical journey", "instrumental music", "solo performance", "emotional", "passionate", "chromatic harmony", "fast tempo", "virtuoso glass harpist", "classic western music", "poor audio quality", "ambient noise"] | 1 | ew-7SwLcHBg | 3909 | |
Devendra Banhart - Chin Chin & Muck Muck | A male singer raises this passionate melody. The song is medium tempo with an acoustic guitar accompaniment, groovy bass line and a subtle drumming rhythm. The song is passionate and relaxing. The song is played live and has poor audio quality. | 2009-04-21T19:14:32Z | eachnotesecure | Devendra Banhart performs Chin Chin & Muck Muck live at The Independent in San Francisco in April 2009 | ["Singing", "Music", "Rattle (instrument)"] | ["male singer", "live performance", "groovy bass line", "medium tempo", "story telling", "ambient room nosiness", "people talking", "guitar accompaniment", "bass rhythm", "steady percussions", "folk music", "emotional", "energetic", "people talking", "poor audio quality", "folk music", "folk music", "guitarist"] | 1 | jFek2xLbEww | 4243 |
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;