musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "medium tempo", musiccaps_names contains "Music" and musiccaps_names contains "Steel guitar, slide guitar"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 24 ✖
- acoustic guitar · 2 ✖
- amateur recording 2
- medium tempo · 2 ✖
- alternative pop 1
- alternative rock 1
- animated 1
- boomy 1
- children’s song 1
- educational 1
- funny song 1
- higher register singing 1
- home video 1
- informative 1
- learning 1
- male vocalist 1
- male voice 1
- melancholy 1
- minimal instruments 1
- monotone singing 1
- simple lyrics 1
- simple melody 1
- singer-songwriter 1
- soft stomping noise 1
- sound of static 1
musiccaps_names (array) 7 ✖
- Acoustic guitar 2
- Music · 2 ✖
- Steel guitar, slide guitar · 2 ✖
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Strum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Cours de guitare The sound of silence | Someone is playing acoustic guitar. While a higher pitched male voice is singing a sad song. This is an amateur recording. This song may be playing at home on a rainy day. | 2011-08-06T09:41:42Z | bluesbosse1 | ..des tablatures pour débutants au : www.partition-guitare-tablature.com | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | ["singer-songwriter", "acoustic guitar", "male voice", "higher register singing", "soft stomping noise", "melancholy", "amateur recording", "medium tempo"] | 6 | DroAzooK4yw | 1514 | |
Music - David Bowie Space Oddity/Major Tom | A male vocalist sings this soft pop. The tempo is medium with an acoustic guitar accompaniment and sound of static in the background. The song has simple lyrics and melody . It is informative and educational. This song is a Children’s song/Alternative Pop. | 2007-08-12T05:38:32Z | artcarver | The orchestra entrance section to the bridge - replaced with a climbing chord progression. See my Universal Records posting: http://www.unpredictableporridge.com/artist.aspx?id=589777ec-a379-4ae5-9b22-5956d51ee4bb | ["Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum"] | ["male vocalist", "medium tempo", "acoustic guitar", "boomy", "simple melody", "simple lyrics", "informative", "educational", "learning", "monotone singing", "home video", "amateur recording", "sound of static", "simple melody", "funny song", "children’s song", "alternative pop", "alternative rock", "animated", "simple melody", "minimal instruments"] | 7 | lIBsL97sUmY | 4390 |
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;