musiccaps_details (view)
2 rows where musiccaps_aspects contains "acoustic song" and musiccaps_aspects contains "passionate" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- acoustic song · 2 ✖
- passionate · 2 ✖
- poor audio quality 2
- ambient noises 1
- ambient room noise 1
- breathing sounds 1
- classical music 1
- clickers 1
- clicking percussions 1
- dance music 1
- dance rhythm 1
- emotional 1
- energetic 1
- fats tempo 1
- female latin singer 1
- footstep sounds 1
- guitar playing rhythm 1
- hissing noises 1
- instrumental music 1
- lilting 1
- live performance 1
- maracas playing percussively 1
- medium tempo 1
- piano accompaniment 1
- pop song 1
- rustling tones 1
- school recital 1
- song introduction 1
- spirited 1
- tap dance rhythm 1
- traditional dancing 1
- vocal recital 1
- women dancing 1
musiccaps_names (array) 4 ✖
- Music 2
- Rustling leaves 1
- Tambourine 1
- Vocal music 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Madison sings Who Has Seen the Wind | The song is an instrumental. The tempo is medium and has a piano accompaniment. The song has a lot of ambient noises like hissing, breathing and hushed tones. The song is emotional but of poor audio quality. | 2009-04-27T16:51:17Z | lmsouthern | Madison sings her competition solo, Who Has Seen the Wind, at the Choir Concert April 26th. | ["Music", "Rustling leaves"] | ["ambient noises", "piano accompaniment", "emotional", "lilting", "vocal recital", "passionate", "spirited", "classical music", "pop song", "acoustic song", "breathing sounds", "rustling tones", "instrumental music", "hissing noises", "poor audio quality", "school recital", "song introduction", "medium tempo", "classical music"] | 1 | oJyyNWuyig4 | 4616 | |
鈴木能律子フラメンコスタジオ*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 |
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;