musiccaps: musiccaps_details: 6 rows where musiccaps_author = 1 and musiccaps

6 rows where musiccaps_author = 1 and musiccaps_names contains "Funk"

descending

youtube_link	musiccaps_caption	youtube_published	youtube_channel	youtube_description	musiccaps_names	musiccaps_aspects	musiccaps_author	youtube_id	musiccaps_rowid
I'm An Indian Too - The 1491s	A female singer sings this catchy tune with backup singers in vocal harmony. The song is medium tempo with a groovy bass line, keyboard accompaniment, steady drumming with a clapping percussion. The song is catchy and has a dance rhythm. The song is a pop dance song.	2012-09-21T20:22:49Z	the1491s	Support more content, buy a t-shirt! https://squareup.com/market/the-1491s/s-t-shirt	["Funk", "Music"]	["female singer", "funny song", "backup singers", "pop dance hits", "dance club", "vocal harmony", "animated singing", "steady drumming rhythm", "keybiard accompaniment", "clapping rhythm", "percussion hits", "catchy tune", "dance rhythm", "people dancing", "energetic", "children’s song", "pop song", "medium tempo", "groovy bass line"]	1	9BHvpWP2V9Y	981
FUNK!! Starr-Shes So Fine	A male singer sings this groovy melody. The tempo is medium with a strong bass line, steady drumming, keyboard playing a countermelody and various percussion hits. The song is funk pop in nature. The song has poor audio quality.	2010-06-18T18:51:57Z	turtle101392	Starr-Shes so Fine	["Funk", "Music"]	["female singer", "bad audio quality", "romantic", "emotional", "dance rhythm", "retro pop", "distorted audio quality", "poor audio quality", "distorted harmony", "keyboard accompaniment", "steady drumming rhythm", "strong bass drum hits", "groovy music", "energetic", "funky groove", "funk music", "groovy bass line"]	1	NZn4-gP2GiI	2347
Groovy Live Musik : "We no speak americano" by 4 to the bar : jazzy swing and lounge music	A male singer sings this groovy bop tune. The song is medium tempo with a groovy double bass playing, piano accompaniment, trumpet playing percussively and brush drumming rhythm. The song is entertaining and exciting. The song is a jazz dance tune with an electronica twist.	2011-02-01T14:48:22Z	loungemusicband	http://4tothebar.de : More groovy lounge music, swing sounds and jazzy live music for club, event and party. Lounge Music: Die Live Band 4 to the bar spielt Swing, Samba und Jazz mit Drums, Kontrabass, Piano und Sängerin und Deejay	["Swing music", "Funk", "Music", "Reggae", "Ska", "Rock and roll"]	["groovy music", "love performance", "dj", "dance music", "brush drumming rhythm", "groovy bass line", "steady drum rhythm", "piano accompaniment", "trumpet playing percussively", "male singer", "female backup singer", "vocal harmony", "bop tune", "double bass harmony", "jazz music", "jazz dance music", "poor audio quality", "people dancing", "dance rhythm"]	1	RtgHU1UMo5o	2729
Despicable Me - Boogie Fever - The Sylvers	A male singer sings this cool melody with backup singers in vocal harmony. The song is medium tempo with a percussive bass line, ethnic drumming rhythm, trumpets playing percussively and a keyboard harmony. The song is groovy and cheerful. The song is retro final pop song;	2010-07-15T01:19:34Z	Duke Tran	I do not own the music or take any credit for this video. I am not claiming that it is mine nor taking any form of incentive.	["Funk", "Music"]	["male singers", "backup singers", "vocal harmony", "funk pop hits", "dance floor", "percussive hits", "medium tempo", "groovy bass line", "medium drumming rhythm", "trumpets playing percussively", "story telling", "love song", "brass band", "pop song", "female backup singers", "exciting", "cheerful", "enegetic", "retro pop hits", "dance music"]	1	SSO7F_Ex0s4	2767
Animals \| Zoo \| Kids \| Music \| Preschool \| Silly Bus	A male singer sings this animated melody . The song is medium tempo with a groovy bass , keyboard accompaniment and steady drumming rhythm. The song is cheerful and animated and designed as educational material for little children.	2011-09-11T22:29:16Z	Silly Bus	Silly Bus is proud to release our At The Zoo song and video.	["Funk", "Music", "Exciting music"]	["medium tempo", "male singer", "groovy bass line", "preschool teaching", "educational material", "learning", "schools", "toddlers", "positive", "cheerful", "spirited", "fun learning", "children dancing", "animated video", "nursery rhymes", "zoo", "animals", "steady drumming rhythm", "piano accompaniment", "children’s song", "animated singing"]	1	hhohfEC82JI	4130
Salt N Pepa Twist and Shout yrics	A female singer sings this cool melody with backup singers in vocal harmony. The song is medium tempo with a groovy bass line and guitar rhythm, steady drums g rhythm and keyboard harmony. The song is catchy and has a dance groove. The song is a retro dance hit. The song has a poor audio quality issue.	2013-06-01T16:22:35Z	katcat654		["Disco", "Funk", "Music", "Pop music"]	["retro pop hits", "doo-wop hits", "female singer", "memdium tempo", "female backup singers", "vocal harmony", "groovy guitar rhythm", "strong bass line", "keybiard harmony", "groovy drumming rhythm", "dance rhythm", "passionate", "cheerful courtship song", "woo her", "sexy", "feeling good", "retro pop super hits", "retro dance hits", "poor audio quality"]	1	kQw2NQ_eqyg	4315

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;

musiccaps_details (view)

6 rows where musiccaps_author = 1 and musiccaps_names contains "Funk"

Advanced export