musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "low quality audio" and musiccaps_author = 0
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- acoustic guitar · 3 ✖
- low quality audio · 3 ✖
- no percussion 2
- slow tempo 2
- amateur recording 1
- basic percussion 1
- child's voice 1
- female voice 1
- folk song 1
- holiday song 1
- male voice 1
- minimal instruments 1
- moderate tempo 1
- no other instruments 1
- romantic mood 1
- vocables backing 1
- wind instrument 1
musiccaps_names (array) 9 ✖
- Music 3
- Child speech, kid speaking 1
- Choir 1
- Christmas music 1
- Humming 1
- Rustling leaves 1
- Sad music 1
- Singing 1
- Vocal music 1
youtube_published (date) 3 ✖
- 2009-03-01 1
- 2009-08-07 1
- 2014-01-01 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Johnny Cash - Blowin' In The Wind | This folk song features a male voice singing the main melody in a southern accent. The voice falls in the bass category. This is accompanied by an acoustic guitar strumming chords. The recording is of low quality and there is a lot of white noise drowning the other sounds. A basic percussion instrument is played. The voice is emotional. This song can be played in a retro style movie where a family goes to meet their grandparents out in the countryside. | 2009-03-01T21:52:19Z | phormt2912 | Johnny Cash Cantando "Blowin' In The Wind" de Bob Dylan | ["Music", "Rustling leaves"] | ["folk song", "male voice", "low quality audio", "acoustic guitar", "basic percussion", "moderate tempo"] | 0 | 2i4UNf8tjvU | 399 | |
DIO COMO TI AMO - música | This song features a female voice singing the main melody. This is accompanied by a guitar playing arpeggiated chords. A wind instrument plays fills in between lines. There is no percussion in this song. This song has a romantic mood. This song can be played in a romantic movie. | 2009-08-07T15:42:24Z | uililopes | música: DIO COMO TI AMO ============ Dio, come ti amo é uma canção italiana de Domenico Modugno que fez sucesso na voz de Gigliola Cinquetti, que a gravou em 1965. =========== Nel cielo passano le nuvole che vanno verso il mare, sembrano fazzoletti bianchi che salutano il nostro amore. Dio come ti amo! Non è possibile avere fra le braccia tanta felicità. Baciare le tue labbra che odorano di vento, noi due innamorati come nessuno al mondo. Dio come ti amo! Mi vien da piangere, in tutta la mia vita non ho provato mai un bene così caro, un bene così vero. Chi può fermare il fiume che corre verso il mare, le rondini nel cielo che vanno verso il sole, chi può cambiar l'amore l'amore mio per te. Dio come ti amo! Un bene così caro, un bene così vero. Chi può fermare il fiume che corre verso il mare, le rondini nel cielo che vanno verso il sole, chi può cambiar l'amore l'amore mio per te. | ["Music", "Sad music"] | ["low quality audio", "female voice", "acoustic guitar", "slow tempo", "wind instrument", "no percussion", "minimal instruments", "romantic mood"] | 0 | 3gh1oldZ7Zc | 493 | |
Mercado Kids Singing Christmas song Mary Did You Know by Mark Lowry | This low quality audio features a child singing the main melody. This is accompanied by other children's voices singing vocables in the background in harmony. An acoustic guitar strums chords. There are no other instruments in this song. This song has a holiday mood. This song can be played in a Christmas movie. | 2014-01-01T03:51:21Z | MercadoFamilyMusic | Hey all! This is our first YouTube upload. We are a sibling group from North Carolina. We love music, performing and most of all we love our Lord and Savior, Jesus Christ. We hope that you enjoy what we have to share. God bless! ~The Mercados Jeremiah 1:5-9 Please like, comment, subscribe and share! Be looking for more videos from us. mercadofamilymusic@gmail.com | ["Christmas music", "Singing", "Humming", "Music", "Choir", "Vocal music", "Child speech, kid speaking"] | ["amateur recording", "low quality audio", "child's voice", "vocables backing", "acoustic guitar", "no percussion", "no other instruments", "holiday song", "slow tempo"] | 0 | Ve6Zy1BXBbY | 3015 |
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;