musiccaps_details (view)
2 rows where musiccaps_aspects contains "home video" and musiccaps_aspects contains "steady rhythm"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- home video · 2 ✖
- medium tempo 2
- steady rhythm · 2 ✖
- acapella singers 1
- audience cheering 1
- bad audio quality 1
- black gospel music 1
- church music 1
- congressional music 1
- devotional 1
- drum lesson 1
- drum rhythm 1
- drum sticks 1
- energetic 1
- exciting 1
- gospel hits 1
- gospel music 1
- groovy 1
- guitar accompaniment 1
- home music video 1
- inspiring 1
- live audience 1
- male singers 1
- motivational 1
- no harmony instruments 1
- passionate 1
- percussionist 1
- poor audio recording 1
- practice session 1
- practice sessions 1
- silent practice 1
- sunday morning 1
- syncopated rhythms 1
- various rhythms 1
- vocal harmony 1
musiccaps_names (array) 4 ✖
- Harmonic 1
- Music 1
- Percussion 1
- Wood block 1
youtube_published (date) 2 ✖
- 2010-05-17 1
- 2011-02-06 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
offworld percussion invader v3 practice pad | A percussionist plays various drum rhythms at a medium tempo. The tempo is me doom with no harmony instruments. The song is exciting and energetic. The audio quality is poor and sounds like a music tutorial for drummers. | 2011-02-06T21:21:49Z | Joseph Santana | my new pad. worth the 80 bucks feels just like a real drum. im playing an excersise called 12/8 from a drum corps that im auditioning for. no hating constructive criticism please sticks are promark dc50s | ["Wood block", "Percussion"] | ["percussionist", "drum sticks", "practice session", "exciting", "energetic", "passionate", "steady rhythm", "various rhythms", "home music video", "silent practice", "syncopated rhythms", "drum lesson", "home video", "practice sessions", "bad audio quality", "no harmony instruments", "drum rhythm", "groovy", "medium tempo"] | 1 | KxUcwQ5BEBk | 2132 | |
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;