musiccaps_details (view)
2 rows where musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "moderate tempo" and musiccaps_aspects contains "no voice"
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- amateur recording · 2 ✖
- moderate tempo · 2 ✖
- no voice · 2 ✖
- blues guitar 1
- guitar fills 1
- harp song 1
- instrumental 1
- instrumental song 1
- minimal instruments 1
- no other instruments 1
- repetitive melody 1
- suspenseful mood 1
- tambourine backing 1
musiccaps_names (array) 9 ✖
- Grunge 1
- Harp 1
- Heavy metal 1
- Music 1
- Pizzicato 1
- Progressive rock 1
- Psychedelic rock 1
- Punk rock 1
- Rock music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Two Pin Din - Screaming Blue Murder live - Nov 15th, 2008 | This amateur recording features two guitars being played. One guitar is playing a blues rhythm. The other guitar is strumming the main chord once and then playing fills on the higher register. This is accompanied by a tambourine as the percussion. There are no voices in this song. This is an instrumental blues rock song. The mood of this song is suspenseful. This song can be used in a detective movie. | 2008-11-18T20:01:48Z | twopindin | When in doubt, follow the advice of Nick Lowe. Namely, "bash it out then tart it up later". Where's Deja Voodoo when you need them? Yet another song offered up off of Two Pin Din's oh-so-fab-you-just-don't-know-it-yet album "In Case Of Fire Break Glass". | ["Heavy metal", "Music", "Punk rock", "Psychedelic rock", "Rock music", "Progressive rock", "Grunge"] | ["amateur recording", "blues guitar", "guitar fills", "tambourine backing", "minimal instruments", "no voice", "instrumental song", "suspenseful mood", "moderate tempo"] | 0 | gp7j9o2x9co | 4055 | |
Low Leaf - June Gloom | This instrumental song features a harp being played. This song is in compound time of 6/8. The bass note is played on the first count of the bar. The high part plays four descending notes followed by two ascending notes in each bar. On the fourth bar, the strings are tapped on the second half of the bar to give a percussive effect. Then the melody continues. There are no other instruments in this song. There are no voices in this song. This is an amateur recording. This song can be played in a dreamy sequence in a movie. | 2011-09-13T05:05:50Z | llowlleaf | Hear the Official version of June Gloom :: http://soundcloud.com/lowleaf/june-gloom-alchemizing-dawn "Alchemizing Dawn" drops October 15, 2012 for past releases visit :: http://lowleaf.bandcamp.com/ | ["Harp", "Pizzicato"] | ["harp song", "instrumental", "amateur recording", "repetitive melody", "no voice", "no other instruments", "moderate tempo"] | 0 | yAoMoKe7gj8 | 5388 |
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;