musiccaps_details (view)
1 row where musiccaps_aspects contains "harmonizing girls vocals", musiccaps_names contains "Singing" and "youtube_published" is on date 2008-05-13
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Learn to sing the U.S. National Anthem (feat. The Cactus Cuties) | The low quality recording features a national anthem sung by harmonizing girls' vocals. It sounds passionate and emotional. The recording is noisy and in mono. | 2008-05-13T21:38:19Z | PhanRegSop | Enable "Annotations" and watch in High Quality! Comments must be approved before posting to ensure family and school viewing preferences. RATED PG. www.TheCactusCuties.com from Lubbock TX, The Cactus Cuties from are (from left to right) Baylee age 14, Blaire 11, Andi 11, and Madeline 9 at the time of this video (May 11, 2008). They performed our nation's Star-Spangled Banner and halftime show medley at the Spurs vs. Hornet's NBA Playoff Game on May 11, 2008. The book inspired by The CC's entitled "Oh Say, Did You Know?" is a story about the Star Spangled Banner through the eyes of The Cuties as told by music mentor Terri Caldwell. You can purchase a copy by visiting their website. With each book comes a 3-song CD inlcuding The Star-Spangled Banner, "Think" by Aretha Franklin and "Children of America" by Terri Caldwell. Look for other songs on iTunes!! www.TheCactusCuties.com | ["Singing", "Choir"] | ["low quality", "noisy", "mono", "harmonizing girls vocals", "national anthem", "passionate", "emotional"] | 4 | v8bBrrXUpdo | 5158 |
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;