musiccaps_details (view)
2 rows where musiccaps_aspects contains "motivational" and musiccaps_aspects contains "steady rhythm"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- motivational · 2 ✖
- steady rhythm · 2 ✖
- acapella singers 1
- audience cheering 1
- backup singers 1
- black gospel music 1
- church music 1
- congressional music 1
- dance rhythm 1
- devotional 1
- emotional 1
- gangs 1
- gospel hits 1
- gospel music 1
- groovy drumming rhythm 1
- groovy rhythm 1
- grunge string section harmony 1
- guitar accompaniment 1
- hip hop dance hits 1
- hip hop hits 1
- hip hop music 1
- home video 1
- hood 1
- inspirational 1
- inspiring 1
- live audience 1
- male singer 1
- male singers 1
- medium tempo 1
- memdium tehsil po 1
- poor audio recording 1
- rapping vocals 1
- story telling 1
- strong bass line 1
- sunday morning 1
- vocal harmony 1
musiccaps_names (array) 3 ✖
- Music 2
- Harmonic 1
- Rhythm and blues 1
youtube_published (date) 2 ✖
- 2010-05-17 1
- 2012-03-27 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Chamillionaire Wont Hear A Sound Freestyle (NEW 3/27/2012) | A male singer sings this hip hop melody with backup singers in vocal harmony. The song is medium tempo with a groovy drum rhythm, steady bass line and a grunge keyboard harmony. The song is exciting and energetic. The song has average audio quality. | 2012-03-27T03:07:58Z | TechnicalPrecision | This is Chamillionaires Wont hear a sound freestyle! Subscribe for quality music! | ["Music", "Rhythm and blues"] | ["male singer", "hip hop music", "backup singers", "rapping vocals", "memdium tehsil po", "groovy drumming rhythm", "strong bass line", "grunge string section harmony", "story telling", "groovy rhythm", "dance rhythm", "steady rhythm", "emotional", "gangs", "hood", "motivational", "inspirational", "hip hop hits", "hip hop dance hits"] | 1 | 67S7s_jFXhc | 726 | |
Harmonic Brothers - I'll Fly Away | Male singers sing this gospel tune in vocal harmony. The song is medium tempo with a guitar accompaniment . The song is devotional amid inspiring. The song is a black gospel acapella recorded live in a church with poor quality audio. | 2010-05-17T07:00:46Z | anewbeginning2009 | ["Music", "Harmonic"] | ["acapella singers", "male singers", "home video", "devotional", "inspiring", "motivational", "gospel hits", "sunday morning", "guitar accompaniment", "live audience", "church music", "gospel music", "medium tempo", "steady rhythm", "vocal harmony", "poor audio recording", "congressional music", "audience cheering", "black gospel music"] | 1 | yAqznhOhoIk | 5389 |
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;