musiccaps_details (view)
2 rows where musiccaps_aspects contains "various percussion effects" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- keyboard accompaniment 2
- various percussion effects · 2 ✖
- adventure 1
- against all odds 1
- animated movie 1
- animated vocals 1
- cheerful 1
- children’s learning 1
- children’s show soundtrack 1
- cyberwars 1
- dangerous game 1
- emotional 1
- fight the machines 1
- flute harmony 1
- flute playing 1
- instrumental music 1
- male and child voices 1
- medium tempo 1
- movie soundtrack 1
- nursery rhymes 1
- ominous 1
- percussion hits 1
- philharmonic orchestra 1
- piano accompaniment 1
- pleasant 1
- poor audio quality 1
- positive 1
- sci-fi movie 1
- sentimental 1
- sonic effects 1
- standing bass line 1
- steady rhythm 1
- super hits 1
- ticking clock percussions 1
- various sound effects 1
- vocabulary expansion 1
- western classical music 1
musiccaps_names (array) 3 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sesame Street: "Sing After Me" with Ernie and Elmo | A male and child sing in animated vocals. The song is medium tempo with western classical music influences, flute harmony, keyboard accompaniment, standing bass line and piano accompaniment. The song is positive and cheerful with an onus on children’s education. | 2010-04-02T17:14:43Z | Sesame Street | Join in on Elmo and Ernie's game of Sing After Me in this favorite Sesame Street classic song. -- If you're watching videos with your preschooler and would like to do so in a safe, child-friendly environment, please join us at http://www.sesamestreet.org Sesame Street is a production of Sesame Workshop, a nonprofit educational organization which also produces Pinky Dinky Doo, The Electric Company, and other programs for children around the world. | ["Music for children"] | ["animated vocals", "male and child voices", "flute playing", "children’s show soundtrack", "western classical music", "piano accompaniment", "standing bass line", "steady rhythm", "flute harmony", "keyboard accompaniment", "various percussion effects", "emotional", "sentimental", "positive", "children’s learning", "nursery rhymes", "vocabulary expansion", "pleasant", "cheerful"] | 1 | vtnuHbHbveg | 5217 | |
Transformers 3 Soundtrack #3 Lost Signal- Steve Jablonsky | The song is instrumental. The tempo is medium with a steady percussive rhythm, keyboard accompaniment, string section harmony and various sound effects. The song is ominous and full of suspense. The song is a movie soundtrack and has poor audio quality. | 2011-07-01T17:15:00Z | TheP1291pictures | soundtrack | ["Music", "Scary music"] | ["movie soundtrack", "sci-fi movie", "instrumental music", "poor audio quality", "various percussion effects", "dangerous game", "adventure", "against all odds", "fight the machines", "cyberwars", "animated movie", "super hits", "sonic effects", "philharmonic orchestra", "ticking clock percussions", "various sound effects", "percussion hits", "ominous", "instrumental music", "medium tempo", "keyboard accompaniment"] | 1 | zSq2D_GF00o | 5479 |
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;