musiccaps_details (view)
2 rows where musiccaps_aspects contains "male voice singing", musiccaps_aspects contains "organ" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 11 ✖
- male voice singing · 2 ✖
- organ · 2 ✖
- acoustic drum 1
- amateur recording 1
- e-bass 1
- e-guitar 1
- positive vibes 1
- rock&roll 1
- slow tempo 1
- soul/r&b/gospel 1
- uptempo 1
musiccaps_names (array) 3 ✖
- Music · 2 ✖
- /t/dd00003 1
- Independent music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jamie Foxx singing the National Anthem (Coming to America style) | An organ is playing chords and melodies while a male voice is singing soulfully with a lot of reverb and delay in his voice. This is an amateur recording. This song may be playing proposing to someone. | 2015-05-03T20:41:46Z | Tech Guy T.V. | Manny Pacquiao vs Floyd Mayweather May 2, 2015 Don't miss the Ending!! Need professional videos edited??..hit me at djad09+vids2edit at gmail dot com and let's discuss what you need! | ["Music", "/t/dd00003"] | ["soul/r&b/gospel", "organ", "male voice singing", "amateur recording", "slow tempo"] | 6 | 1ACn3u5UnBw | 243 | |
Strawberry Alarm Clock - California Day | This song contains acoustic drums playing a steady groove with an uplifting bassline that repeats itself. An e-guitar is playing a single note melody while strings and an organ are elevating the energy with long higher register chords. Some backing vocals are singing along to the strings while the male voice is singing his melody. This song may be playing on a sunny day at the park having a picnic. | 2010-06-27T08:13:10Z | Optinon | Genre: Pop/Psychedelic Pop Released: 1970 Release: California Day / Three | ["Music", "Independent music"] | ["rock&roll", "acoustic drum", "e-bass", "organ", "e-guitar", "male voice singing", "uptempo", "positive vibes"] | 6 | BHu95Y_kVQA | 1225 |
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;