musiccaps_details (view)
3 rows where "youtube_published" is on date 2009-09-13 sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- low quality 3
- noisy 2
- arpeggiated acoustic guitar melody 1
- atmosphere 1
- church bell sound effect 1
- crowd chattering 1
- folk 1
- fun 1
- groovy accordion melody 1
- groovy bass 1
- happy 1
- harmonized vocals 1
- haunting 1
- live performance 1
- mono 1
- nature 1
- outdoor recording 1
- passionate trumpet melody 1
- sea sound effect 1
- spooky 1
- wind sound effects 1
musiccaps_names (array) 8 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
YODELING IN KOREA | The low quality recording features a live performance of a folk song and it contains harmonized mixed vocals singing over groovy bass, groovy accordion melody and arpeggiated acoustic guitar solo melody. The recording took place outdoors, since there was some crowd chattering and nature sounds. It sounds happy and fun. | 2009-09-13T15:23:28Z | VascoPolonia | Six Korean college students yodeling at Global Fair & Festival in Incheon, South Korea. | ["Singing", "Yodeling", "Music", "Bluegrass"] | ["low quality", "live performance", "folk", "harmonized vocals", "crowd chattering", "outdoor recording", "groovy bass", "groovy accordion melody", "arpeggiated acoustic guitar melody", "happy", "fun", "nature"] | 4 | gNjeps3EbJA | 4026 | |
Sunday Morning Theme Song By Wynton Marsalis | The low quality recording features a passionate trumpet melody. The recording is noisy and in mono. | 2009-09-13T05:14:42Z | Kaiser Gerhardt | Wynton Marsalis records Abblasen, the Sunday Morning theme song, for CBS Sunday Morning on June 8, 2004. | ["Brass instrument", "Trumpet", "Wind instrument, woodwind instrument"] | ["low quality", "passionate trumpet melody", "mono", "noisy"] | 4 | K_ZuxYxxT60 | 2096 | |
PainKiller [Music] - City On Water | The low quality recording features haunting and spooky noises of wind, sea and some church bell sound effects. Sounds like a thriller movie atmosphere. | 2009-09-13T09:28:43Z | xRussianYulia17x | http://www.painkillergame.com/pc_site/index2.php | ["Music", "Gurgling"] | ["low quality", "noisy", "haunting", "wind sound effects", "sea sound effect", "church bell sound effect", "spooky", "atmosphere"] | 4 | O9_avJFKIQk | 2406 |
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;