musiccaps_details (view)
3 rows where search matches "guitar" and musiccaps_names contains "Ping" sorted by youtube_published
This data as json, CSV (advanced)
Suggested facets: musiccaps_names
musiccaps_aspects (array) 36 ✖
- acoustic drums 1
- acoustic guitar 1
- electric guitar melody 1
- electronic drums 1
- emotional 1
- engaging 1
- fast tempo 1
- generic 1
- groovy bass lines 1
- inspiring 1
- instrument samples 1
- instrumental 1
- jingle 1
- keyboard harmony 1
- keys 1
- male voice rapping 1
- mellifluous 1
- moderate tempo 1
- people shouting 1
- pingpong 1
- pleasant 1
- pleasant melody 1
- pop 1
- pulse effect 1
- rap/reggeaton 1
- rhythmic acoustic guitar 1
- simple 1
- simple melody 1
- soothing 1
- sound-effects 1
- steady drumming 1
- steady rhythm 1
- string instruments 1
- strings 1
- sub bass 1
- tension 1
musiccaps_names (array) 4 ✖
- Music 3
- Ping · 3 ✖
- Hip hop music 1
- Music of Africa 1
youtube_published (date) 3 ✖
- 2011-09-06 1
- 2013-11-19 1
- 2014-12-18 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
E Weg'i Ping - BlackJoker ft JeWeet, Remyman, Uncle Jee & Lady Shanti | This song has a typical reggaeton drumbeat that just sounds a little softer and not so much in the foreground. A synthetic bass is supporting the drums with a simple bassline. A processed guitar-like sound is panned to the left side of the speakers. Some gameboy coinlike sound is popping up here and there. A male voice is rapping while getting backing voices from another male voice. This song may be playing at a latin barber shop. | 2011-09-06T21:05:39Z | BlackJoker Music | E Weg'i Ping, BlackJoker, RemyMan, Uncle Jee, Lady Shanti Dancehall, Bubbling, Reggaeton, Rub A Dub. | ["Music of Africa", "Music", "Ping", "Hip hop music"] | ["rap/reggeaton", "electronic drums", "sub bass", "sound-effects", "instrument samples", "keys", "male voice rapping", "moderate tempo"] | 6 | Pln4GLIMqKY | 2563 | |
NapoliTube | Maradona: palleggio con pallone, palla da tennis e pallina da ping pong! | RIP D10S! | This music is instrumental. The tempo is fast with rhythmic acoustic guitar, steady drumming, keyboard harmony, groovy bass line and electric guitar accompaniment. The music is mellow,nostalgic, emotional, simple, pleasant, charming and melodic pop. | 2013-11-19T20:26:34Z | NapoliTube | NAPOLITUBE | La Videoenciclopedia del Napoli: https://www.napolitube.eu SEGUI TUTTA LA STORIA DEL NAPOLI IN VIDEO SU https://www.napolitube.eu LA VIDEOENCICLOPEDIA DEL NAPOLI! | ["Music", "Ping"] | ["instrumental", "fast tempo", "rhythmic acoustic guitar", "pop", "steady drumming", "simple melody", "pleasant", "mellifluous", "inspiring", "emotional", "string instruments", "keyboard harmony", "steady drumming", "groovy bass lines", "electric guitar melody", "pleasant melody", "simple", "steady rhythm", "soothing", "engaging"] | 7 | aYoRcnmz6ZE | 3553 | |
MINUTE MAID NUTRIBOOST - #DuelDuet Adu Ping Pong | This is a jingle piece in the background of an advertisement video. There is an acoustic guitar playing a generic tune while medium-pitched strings can be heard accompanying it. There is a slightly fast-paced acoustic drum beat as the rhythmic background. Sounds can be heard related to the ad such as a blood pulse sound effect, a pingpong ball bouncing and people shouting. The overall atmosphere is generic. | 2014-12-18T08:48:17Z | Nutriboost Indonesia | Final Battle antara The Dandees VS Cow & Orange nih! Lihat gokilnya aksi mereka adu ping pong. | ["Music", "Ping"] | ["jingle", "strings", "acoustic guitar", "acoustic drums", "pulse effect", "pingpong", "people shouting", "tension", "generic"] | 9 | A2NtJ12KIuU | 1059 |
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;