musiccaps_details (view)
2 rows where musiccaps_aspects contains "children’s song" and musiccaps_aspects contains "simple melody" sorted by musiccaps_aspects
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- children’s song · 2 ✖
- simple melody · 2 ✖
- acoustic guitar 1
- alternative pop 1
- alternative rock 1
- amateur recording 1
- animated 1
- bass drums 1
- boomy 1
- child singer 1
- children’s popular songs 1
- educational 1
- female vocalist 1
- funny song 1
- home video 1
- informative 1
- learning 1
- lively piano 1
- male vocalist 1
- medium tempo 1
- minimal instruments 1
- monotone singing 1
- nursery rhymes 1
- percussion 1
- simple beats 1
- simple lyrics 1
- sound of static 1
- tambourine beats 1
- two different tracks 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects ▼ | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Just Like Home Bread and Cheese Set - Toy Cutting Food - Velcro Cooking Playset Review | This clip is two different tracks. The first one is a female vocalist singing a nursery rhyme with lively drums, tambourine beats and vocal backup. The second track is a child singing a song with a playful piano accompaniment . The songs are children’s nursery rhymes. | 2015-03-15T19:29:20Z | Toys And Funny Kids Play Doh Cartoons | Welcome to Toysandfunnykids! New videos everyday! Subscribe and stay tuned!!! https://www.youtube.com/toysandfunnykids | ["Music", "Music for children"] | ["female vocalist", "child singer", "nursery rhymes", "children’s song", "two different tracks", "lively piano", "percussion", "tambourine beats", "bass drums", "simple beats", "simple melody", "children’s popular songs"] | 7 | rDusaHYR69g | 4857 | |
Music - David Bowie Space Oddity/Major Tom | A male vocalist sings this soft pop. The tempo is medium with an acoustic guitar accompaniment and sound of static in the background. The song has simple lyrics and melody . It is informative and educational. This song is a Children’s song/Alternative Pop. | 2007-08-12T05:38:32Z | artcarver | The orchestra entrance section to the bridge - replaced with a climbing chord progression. See my Universal Records posting: http://www.unpredictableporridge.com/artist.aspx?id=589777ec-a379-4ae5-9b22-5956d51ee4bb | ["Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum"] | ["male vocalist", "medium tempo", "acoustic guitar", "boomy", "simple melody", "simple lyrics", "informative", "educational", "learning", "monotone singing", "home video", "amateur recording", "sound of static", "simple melody", "funny song", "children’s song", "alternative pop", "alternative rock", "animated", "simple melody", "minimal instruments"] | 7 | lIBsL97sUmY | 4390 |
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;