musiccaps_details (view)
2 rows where "youtube_published" is on date 2008-01-09 sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- alternative rock 1
- ambient 1
- arpeggiated acoustic guitar melody 1
- booming 1
- dark 1
- eerie 1
- electro pop 1
- electronic music 1
- flat male vocal 1
- futuristic 1
- goth 1
- gothic ambience 1
- horror film music 1
- industrial rock 1
- instrumental 1
- intense 1
- low quality 1
- mono 1
- noisy 1
- scary 1
- sinister 1
- slow tempo 1
- synthesiser articulation 1
- techno 1
- techno pop 1
- tutorial 1
- video game music 1
musiccaps_names (array) 7 ✖
- Music 2
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Speech 1
- Strum 1
- Theremin 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
How to play romanza (romance) classical guitar lessons with Gary | The low quality recording features a guitar tutorial that consists of a flat male vocal talking and counting the rhythm over an arpeggiated acoustic guitar melody. The recording is mono and noisy. | 2008-01-09T06:25:04Z | Taffypro | TO HEAR THIS WITHOUT THE ANNOYING ACCENT AND AT FULL QUALITY PLEASE VISIT: http://taffyproductions.com/ How to play romance classical guitar lesson, Guitar lessons, classical guitar lessons, How to play, beginning guitar lesson How to play romanza romanza on the guitar | ["Guitar", "Music", "Musical instrument", "Strum", "Speech", "Plucked string instrument"] | ["low quality", "flat male vocal", "arpeggiated acoustic guitar melody", "tutorial", "noisy", "mono"] | 4 | 0K-zyeLuKho | 146 | |
Half-Life 2 - Song 31. | This music is an Electronic instrumental. The tempo is slow with synthesiser arrangements and digitally arranged sounds. The music is dark, futuristic,intense, sinister, and scary with a gothic ambiance. This music is futuristic techno pop. | 2008-01-09T22:45:23Z | Halflifer | The Orange Box - Original Soundtrack (2007) Half-Life 2 - Song 31. | ["Music", "Theremin"] | ["instrumental", "slow tempo", "intense", "techno pop", "electro pop", "synthesiser articulation", "electronic music", "industrial rock", "sinister", "eerie", "booming", "techno", "alternative rock", "goth", "dark", "ambient", "scary", "video game music", "horror film music", "eerie", "futuristic", "gothic ambience"] | 7 | 5bn7PPKcqSA | 675 |
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;