musiccaps_details (view)
2 rows where musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "simple lyrics"
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- medium tempo · 2 ✖
- simple lyrics · 2 ✖
- acoustic guitar 1
- alternative pop 1
- alternative rock 1
- amateur recording 1
- animated 1
- beat boxing 1
- boomy 1
- bouncy 1
- children’s song 1
- christian rap 1
- clean lyrics 1
- digital drum rhythm 1
- drum machine 1
- educational 1
- emotional 1
- funny song 1
- hip-hop 1
- home video 1
- impactful 1
- informative 1
- insightful 1
- intense 1
- keyboard harmony 1
- learning 1
- male singer 1
- male vocalist 1
- minimal instruments 1
- monotone singing 1
- passionate 1
- punchy 1
- rap 1
- rhythmic patter 1
- rhythmic speech 1
- simple melody 1
- sound of static 1
- steady bass 1
- teen rap 1
- youthful 1
musiccaps_names (array) 10 ✖
- Music 2
- Acoustic guitar 1
- Afrobeat 1
- Christian music 1
- Hip hop music 1
- Rapping 1
- Reggae 1
- Rhythm and blues 1
- Steel guitar, slide guitar 1
- Strum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
NEW Christian Rap - J-Tru Soldier4Christ ft. Gigglez - "Never Give Up" (@ChristianRapz) | A male vocalist sings this rap. The tempo is medium with the keyboard harmony, digital drum rhythm and boomy bass. The song is passionate, youthful, emotional, buoyant, insightful, intense and story telling in a rhythmic patter. This song is contemporary Rap/Hip. | 2015-10-07T12:29:47Z | Christian Hip Hop | CLICK HERE TO SUBSCRIBE - https://www.youtube.com/subscription_center?add_user=christianrapz Follow Christian Hip Hop Hits Just as Hard! Twitter - http://www.christianrapz.org Facebook - http://www.christianrapz.us Matt Bold - http://www.christianrapz.info YouTube - http://www.christianrapz.com Soundcloud - https://soundcloud.com/christianraps Visit http://www.christianraps.com for more Christian Hip-Hop & Rap Not for selling purposes all honor and glory to God http://www.evelutionbeats.com http://www.soundcloud.com/jtrujillo220 NEW Christian Rap - J-Tru Soldier4Christ ft. Gigglez - "Never Give Up" (@ChristianRapz) | ["Afrobeat", "Christian music", "Music", "Rapping", "Reggae", "Rhythm and blues", "Hip hop music"] | ["male singer", "medium tempo", "hip-hop", "rap", "insightful", "clean lyrics", "simple lyrics", "christian rap", "youthful", "teen rap", "bouncy", "punchy", "steady bass", "beat boxing", "keyboard harmony", "drum machine", "digital drum rhythm", "rhythmic patter", "rhythmic speech", "passionate", "emotional", "impactful", "intense"] | 7 | dwAo0dKCyBI | 3828 | |
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;