musiccaps_details (view)
2 rows where musiccaps_aspects contains "passionate", musiccaps_author = 1 and musiccaps_names contains "Tambourine"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- passionate · 2 ✖
- acoustic song 1
- ambient room noise 1
- bad audio quality 1
- clickers 1
- clicking percussions 1
- dance music 1
- dance rhythm 1
- energetic 1
- entertaining 1
- fats tempo 1
- female latin singer 1
- footstep sounds 1
- guitar playing rhythm 1
- hissing noise 1
- home music video 1
- instrumental music 1
- live performance 1
- maracas playing percussively 1
- medium fast tempo 1
- percussionist 1
- poor audio quality 1
- positive 1
- practice room 1
- rehearsal session 1
- soloist 1
- spirited 1
- string section playing 1
- tambourine playing percussively 1
- tap dance rhythm 1
- traditional dancing 1
- varying volume levels 1
- western classical music 1
- women dancing 1
musiccaps_names (array) 3 ✖
- Music 2
- Tambourine · 2 ✖
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
鈴木能律子フラメンコスタジオ*BELEN ご案内 | A female singer sings this traditional melody. The song is medium tempo with a clicking percussion rhythm, guitar strumming accompaniment and tap dancing tones. The song is energetic and passionate. The song has very poor audio quality. | 2012-05-27T11:47:36Z | STUDIO NORI | ["Music", "Tambourine", "Vocal music"] | ["dance music", "maracas playing percussively", "acoustic song", "live performance", "tap dance rhythm", "women dancing", "traditional dancing", "clicking percussions", "clickers", "poor audio quality", "guitar playing rhythm", "energetic", "passionate", "ambient room noise", "dance rhythm", "fats tempo", "female latin singer", "footstep sounds"] | 1 | jtRse-cDB18 | 4286 | ||
Carnival Overture - Tambourine performed by Steve Myers | The song is an instrumental. The song is medium fast tempo with a western classic al piece featuring a string string section plays and a tambourine player practices along with background music. The song is spirited and passionate. The audio quality is very poor. | 2011-06-22T18:06:47Z | ybooby | Dvoraks Carnival Overture | ["Music", "Tambourine"] | ["tambourine playing percussively", "home music video", "entertaining", "soloist", "percussionist", "rehearsal session", "bad audio quality", "practice room", "instrumental music", "hissing noise", "varying volume levels", "string section playing", "positive", "spirited", "passionate", "western classical music", "medium fast tempo"] | 1 | xzgnLpKkvdg | 5375 |
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;