musiccaps_details (view)
4 rows where musiccaps_aspects contains "amateur recording" and musiccaps_names contains "Ice cream truck, ice cream van"
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- amateur recording · 4 ✖
- electronic music 2
- home video 2
- instrumental 2
- medium tempo 2
- birds chirping 1
- car engine 1
- carousel 1
- carousel music 1
- children electronic toys 1
- children’s game music 1
- children’s music 1
- children’s toy music 1
- digital melody 1
- dreamy lo-fi sound 1
- elctronic music 1
- engine sound 1
- engine whirring 1
- high notes 1
- ice-cream cart 1
- low quality audio 1
- lullaby 1
- melodic 1
- merry-go round 1
- muddled audio 1
- muffled audio 1
- outdoors 1
- people’s voices 1
- sharp 1
- slow tempo 1
- slower tempo 1
- synthesiser arrangements 1
- thudding 1
- video game music 1
- whirring 1
- white noise 1
- whooshing sound 1
- xylophone melody 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
1st Ice Cream Truck of the Year | This music is instrumental. The tempo is medium with an electronic xylophone melody. The audio is of inferior quality and it sounds like it is being played outdoors. There are ambient nature sounds like birds chirping, a car engine, a loud thud and people’s voices. | 2011-04-15T01:41:18Z | Elizabeth's Adventures | Here is a video that I took of the first ice cream truck of the year. This truck comes around almost every day in front of our building. The song is the Mr Softee song | ["Ice cream truck, ice cream van", "Music"] | ["instrumental", "medium tempo", "engine sound", "car engine", "people’s voices", "low quality audio", "amateur recording", "home video", "outdoors", "ice-cream cart", "merry-go round", "carousel", "carousel music", "engine whirring", "thudding", "xylophone melody", "birds chirping", "electronic music", "children’s music", "children’s toy music"] | 7 | ZsmxO0wnqdQ | 3423 | |
Mister Softee Florida | A digital melody is playing a lullaby. This is an amateur recording with poor audio-quality. This song may be playing to bring children to sleep. | 2008-09-21T22:17:36Z | vidrobb | Mister Softee has expanded service into southwest Florida. How long has it been since you chased that truck jingle'n through the streets? This one is for you! www.mistersofteeflorida.com | ["Ice cream truck, ice cream van", "Music"] | ["lullaby", "digital melody", "amateur recording", "slow tempo"] | 6 | eBlyC9bJacs | 3851 | |
Windows Vista Instant BSOD (7F) When Unplugging Dazzle Capture Card | A lo-fi pluck, bell sound is playing an arpeggio melody. It sounds dreamy and melancholic. This song may be playing in a sequence of a video game. | 2008-12-30T21:31:02Z | pokemonfan4000 | The music playing is the game over theme from A Link To The Past running off my Gamecube. Remember my Dazzle capture card I use to record some of my videos with? Well, to get an instant Blue Screen of Death with stop code 7F on Windows Vista, simply remove the Dazzle's USB cable when Pinnacle Studio is using it. | ["Ice cream truck, ice cream van", "Music"] | ["melodic", "slower tempo", "dreamy lo-fi sound", "amateur recording"] | 6 | tUppIOzUo2Q | 5041 | |
1/18 Tampa City of Tampa Florida POLICE Diecast Car with Lights and SIREN | This music is instrumental. The tempo is slow with an electronic keyboard playing a simple, high pitched harmony. There are sounds in the background like whirring, whooshing and clicking. The music is not very clear as the audio clip is muffled, but it sounds like video game music or the music Ina child’s electronic toy. | 2010-10-29T21:53:59Z | 6877mercedes Ebay | City of Tampa Florida POLICE Diecast Car with Lights and SIREN | ["Ice cream truck, ice cream van", "Music"] | ["instrumental", "medium tempo", "high notes", "sharp", "children electronic toys", "electronic music", "whirring", "white noise", "whooshing sound", "video game music", "children’s game music", "elctronic music", "synthesiser arrangements", "muffled audio", "muddled audio", "home video", "amateur recording"] | 7 | uwPeQy7ZtGo | 5143 |
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;