musiccaps_details (view)
3 rows where musiccaps_names contains "Pizzicato" and youtube_description = ""
This data as json, CSV (advanced)
Suggested facets: musiccaps_names, youtube_published (date)
musiccaps_aspects (array) 34 ✖
- emotional 2
- medium tempo 2
- amateur recording 1
- ambient crowd noises 1
- arpeggiated harp melody 1
- background voices 1
- breathy flute melody 1
- cheerful 1
- classical 1
- couples dan 1
- dance music 1
- family gatherings 1
- festive spirit 1
- folk dance music 1
- groovy bass line 1
- harp 1
- harpist 1
- instrumental duo 1
- instrumental music 1
- joyful 1
- low quality 1
- noisy 1
- passionate 1
- people talking 1
- poor audio quality 1
- positive 1
- romantic 1
- sentimental 1
- south american folk music 1
- togetherness 1
- traditional custom dance 1
- transverse flute 1
- violin melody 1
- violinist 1
musiccaps_names (array) 4 ✖
- Harp 3
- Pizzicato · 3 ✖
- Bowed string instrument 2
- Violin, fiddle 2
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 | ||
Canon in D (Pachelbel) - flute & harp | This song contains someone playing a harp along with someone playing a melody on a transverse flute in the higher mid range. In the background you can hear people whispering. | 2011-01-06T11:21:40Z | Fiona | ["Harp", "Pizzicato"] | ["classical", "amateur recording", "transverse flute", "harp", "background voices", "medium tempo"] | 6 | BXcEsM8ykhE | 1253 | ||
Musici Nuziali - Canone di Pachelbel - Arpa, Violino, Flauto | The low quality recording features a breathy flute melody, violin melody and arpeggiated harp melody. It sounds joyful, emotional and passionate. The recording is a bit noisy. | 2010-04-03T14:31:22Z | musicinuziali | ["Harp", "Violin, fiddle", "Pizzicato", "Bowed string instrument"] | ["low quality", "noisy", "breathy flute melody", "violin melody", "arpeggiated harp melody", "joyful", "emotional", "passionate"] | 4 | j5R0hwX27Gk | 4234 |
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;