musiccaps_details (view)
2 rows where musiccaps_aspects contains "low quality" and "youtube_published" is on date 2009-07-22
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- low quality · 2 ✖
- noisy 2
- audio crackles 1
- emotional 1
- flat male vocal 1
- harsh 1
- live performance 1
- loud 1
- rock 1
- sad 1
- seat crackles 1
- simple electric guitar chords 1
- wide resonating woodwind melody 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Semnale de bucium / Carpathianhorn signals | The low quality recording features a wide resonating woodwind melody. The recording is loud, noisy with some crackles and it sounds harsh. | 2009-07-22T07:37:47Z | Fabr1s | "Semnale de bucium" performed by a group of six carpathianhorn ("bucium", "tulnic") players. Romanian traditional folk song from Transylvania area. ****** Carpathianhorn: http://en.wikipedia.org/wiki/Bucium ***** © Fabris, 2009 | ["Foghorn", "Music"] | ["wide resonating woodwind melody", "noisy", "audio crackles", "loud", "harsh", "low quality"] | 4 | 0MzrXd8CUCg | 153 | |
☆Black Sheep cover Ver☆Fastest Pram☆the pillowsカバーコンテスト | The low quality recording features a live performance of a rock song that consists of flat male vocal singing over simple electric guitar chords. The recording is noisy and it has some seat crackling noises in it. It sounds sad and emotional though. | 2009-07-22T12:28:48Z | hiro2cyclone | [black sheep/ Fastest Pram] the pillowsカバーコンテスト。 the pillows20周年おめでとうございます! 7/20 BUSTERS TRIBUTE SHOW!!!と銘打って関東関西同時に行われたイベントから! ピロウズの曲は楽しく弾いてなんぼ!ってことでこの曲を^^ | ["Blues", "Guitar", "Music"] | ["low quality", "live performance", "seat crackles", "noisy", "simple electric guitar chords", "flat male vocal", "emotional", "sad", "rock"] | 4 | FbV2Lgt3H1Q | 1655 |
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;