musiccaps_details (view)
3 rows where musiccaps_aspects contains "low quality audio" and musiccaps_names contains "Song"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- low quality audio · 3 ✖
- male voice 2
- acoustic guitar 1
- alternative rock 1
- amateur recording 1
- bass 1
- calm female vocal 1
- distortion guitar 1
- emotive voice 1
- fast paced percussion 1
- fast tempo song 1
- guitar scratching 1
- keyboard fills 1
- missed guitar notes 1
- muffled recording 1
- nursery rhyme 1
- percussion 1
- psychedelic feel 1
- shaker 1
- slow tempo 1
- tambourine 1
- trumpet song 1
- workout song 1
musiccaps_names (array) 10 ✖
- Song · 3 ✖
- Music 2
- Acoustic guitar 1
- Maraca 1
- Mouse 1
- Music for children 1
- Music of Latin America 1
- Salsa music 1
- Singing 1
- Steel guitar, slide guitar 1
youtube_published (date) 3 ✖
- 2008-10-18 1
- 2010-09-18 1
- 2011-11-07 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ABC Song - "I Love My ABC's!" - Alphabet Song | This clip features a nursery rhyme. The singer plays the guitar and sings in a calm and gentle tone. The singer misses some notes on the guitar - playing with some mistakes. The quality of the audio recording is low. | 2011-11-07T00:39:15Z | ILoveLearningABCs | Sing your ABC's as you watch lovely clouds float by! Visit http://www.i-love-learning.com for more kids educational videos, or visit our channel. On our website we have many more ABC songs, nursery rhymes, and other fun videos for kids. A fun, and easy to sing ABC song. Wonderful kids songs and song for children: phonics, pronouncing letters, letter sounds... Watch more videos on Mati's website: http://www.i-love-learning.com . JOIN QUIZGROUP PARTNER PROGRAM: http://join.quizgroup.com/ . | ["Acoustic guitar", "Music", "Music for children", "Steel guitar, slide guitar", "Song"] | ["low quality audio", "acoustic guitar", "calm female vocal", "muffled recording", "missed guitar notes", "nursery rhyme"] | 3 | CzHZNJEV-3o | 1423 | |
Margot & the Nuclear So & So's: Quiet As A Mouse 10-16-08 | This alternative rock song features a male voice singing the main melody. This is accompanied by percussion playing a simple beat. A shaker is played on every count. At the beginning, a scratch slide is played on the distortion guitar. The bass plays notes in groups of three on the first and second counts of each bar. A keyboard plays repetitive fills in between lines. The voice is emotive and the feel of this song is psychedelic. The audio quality is low. This song can be played in a night driving scene in a movie. | 2008-10-18T18:49:52Z | Keith Robbins | Margot & the Nuclear So & So's: 10-16-08 - Quiet As A Mouse 930 Listening Room Louisville, KY Recorded and edited by Keith Robbins keith@keithrobbbins.net | ["Singing", "Music", "Mouse", "Song"] | ["amateur recording", "alternative rock", "low quality audio", "distortion guitar", "bass", "percussion", "tambourine", "slow tempo", "psychedelic feel", "guitar scratching", "emotive voice", "male voice", "shaker", "keyboard fills"] | 0 | Wr5sFgqxLzQ | 3141 | |
Zumba Michelle Marco Island (Da La Vuelta) | This low quality audio features a male voice singing the main melody. This is accompanied by percussion playing a simple but fast paced beat. Trumpets are featured in this song playing fills at high pitch. This song can be played in an aerobics workout session where fast movements are required. | 2010-09-18T04:28:34Z | Michelle Jordan | Choreography by Michelle Jordan | ["Song", "Music of Latin America", "Salsa music", "Maraca"] | ["low quality audio", "fast tempo song", "male voice", "trumpet song", "fast paced percussion", "workout song"] | 0 | jIoDR_eskaU | 4245 |
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;