musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "minimal instruments" and musiccaps_author = 0
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- amateur recording · 3 ✖
- minimal instruments · 3 ✖
- male voice 2
- no percussion 2
- acoustic guitar 1
- blues guitar 1
- children's voice 1
- foreign language 1
- guitar fills 1
- guitar song 1
- instrumental song 1
- live recording 1
- low quality recording 1
- moderate tempo 1
- no lyrics 1
- no voice 1
- repetitive melody 1
- romantic theme 1
- slow tempo 1
- suspenseful mood 1
- tambourine backing 1
musiccaps_names (array) 9 ✖
- Music 3
- /t/dd00003 1
- Chant 1
- Grunge 1
- Heavy metal 1
- Progressive rock 1
- Psychedelic rock 1
- Punk rock 1
- Rock music 1
youtube_published (date) 3 ✖
- 2008-11-18 1
- 2010-07-16 1
- 2010-08-31 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Joseph Gordon-Levitt singing "La Valse à Mille Temps" (SitC) | This amateur recording features a male voice. This is accompanied by an electric guitar. The notes of the chords are first plucked and the chord is struck once. There is no percussion and no other instruments in this song. This is a slow tempo song. The mood of this song is romantic. | 2010-08-31T06:47:59Z | winegodof | Joseph Gordon-Levitt singing Jacques Brel's "La Valse à Mille Temps" at hitRECord.org's second Summer in the City show. | ["Music", "/t/dd00003"] | ["amateur recording", "guitar song", "male voice", "no percussion", "slow tempo", "foreign language", "minimal instruments", "live recording", "romantic theme"] | 0 | 3otUlQ4wvLY | 505 | |
Justin Bieber "Baby" (cover) Nick Pitera feat Rudy and Rosie Pitera | This song is an amateur recording of a person strumming an acoustic guitar. A group of adults and children sing the main melody using vocables and no lyrics. The melody is repetitive. There are no other instruments in this song. The song has a happy mood. This is a party song. | 2010-07-16T03:44:42Z | Nick Pitera | This is how I spent my 4th of July vacation. It's not to be taken seriously. We were just having fun :) thanks to my cousins, and brother for participating! | ["Chant", "Music"] | ["amateur recording", "low quality recording", "male voice", "children's voice", "acoustic guitar", "no percussion", "repetitive melody", "no lyrics", "minimal instruments"] | 0 | 3tlaELkmRqs | 515 | |
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 |
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;