MYSQL

SELECT * FROM vnroletypes

roletypeid	roletype
1	Actor
2	Actor1
3	Actor2
4	Agent
5	Asset
6	Attribute
7	Beneficiary
8	Cause
9	Destination
10	Experiencer
11	Extent
12	Instrument
13	Location
14	Material
15	Oblique
16	Patient
17	Patient1
18	Patient2
19	Predicate
20	Product
21	Proposition
22	Recipient
23	Source
24	Stimulus
25	Theme
26	Theme1
27	Theme2
28	Time
29	Topic
30	Value

SELECT class,COUNT(wordid) AS N,SUBSTRING(GROUP_CONCAT(lemma) FROM 1 FOR 80) FROM vnclassmembers INNER JOIN vnclasses USING (classid) INNER JOIN words USING (wordid) GROUP BY classid ORDER BY N DESC LIMIT 20

class	N	SUBSTRING(GROUP_CONCAT(lemma) FROM 1 FOR 80)
other_cos-45.4	373	distend,abbreviate,soak,granulate,clog,worsen,nitrify,empty,amplify,straighten,i
amuse-31.1	242	confound,flabbergast,roil,depress,jollify,horrify,spook,terrify,dispirit,numb,ag
run-51.3.2	126	speed,gallop,limp,tear,promenade,waddle,scramble,canter,slog,flit,jog,swagger,pa
butter-9.9	117	calk,plaster,forest,salve,starch,label,turf,bridle,patch,drug,rouge,sod,halter,t
sound_emission-43.2	116	creak,tick,hum,whish,plunk,chime,shrill,clunk,thud,gurgle,wail,pink,burble,rustl
fill-9.8	97	replenish,bind,stipple,deck,entangle,inlay,panel,anoint,speckle,contaminate,enci
judgement-33	93	forgive,malign,reprove,belittle,toast,condone,excuse,insult,remunerate,assail,sn
manner_speaking-37.3	83	thunder,coo,yell,holler,rasp,squeal,chant,whistle,grumble,prattle,splutter,burbl
animal_sounds-38	68	call,growl,pipe,wail,boom,cuckoo,moo,trill,bay,yip,cluck,low,squeak,woof,cheep,h
tape-22.4	57	hitch,padlock,tack,glue,manacle,staple,chain,leash,seal,truss,bracket,lace,plast
crane-40.3.2	47	bat,flutter,show,flap,raise,waggle,crane,knit,turn,clench,grind,snap,bare,flick,
steal-10.5	47	cabbage,liberate,rescue,highjack,purloin,take,extort,pilfer,snatch,confiscate,na
pocket-9.10	47	cellar,pasture,tin,box,jail,spit,bench,garage,shoulder,bag,corral,pocket,warehou
admire-31.2	45	disbelieve,pity,trust,bewail,lament,suffer,affirm,fancy,revere,envy,reaffirm,wor
entity_specific_modes_being-47.2	45	decompose,rage,tarnish,burn,grow,stagnate,blow,flower,smoke,ferment,roil,wither,
nonverbal_expression-40.2	43	snivel,cackle,groan,sneeze,glower,simper,yawn,gasp,pout,sob,cough,howl,snigger,b
spatial_configuration-47.6	41	dangle,perch,squat,balance,loom,slope,kneel,rise,fly,protrude,straddle,crouch,op
pit-10.7	40	worm,core,poll,tassel,bark,pip,stem,louse,shuck,head,scale,wind,burl,pod,tail,pi
remove-10.1	39	draw,partition,disengage,lop,withdraw,deduct,expel,shoo,eradicate,remove,dismiss
modes_of_being_with_motion-47.3	38	bow,quiver,vibrate,joggle,totter,float,sway,drift,roil,waver,bob,quake,vacillate

SELECT lemma,COUNT(classid) N,SUBSTRING(GROUP_CONCAT(class) FROM 1 FOR 80) FROM vnclassmembers INNER JOIN vnclasses USING (classid) INNER JOIN words USING (wordid) GROUP BY wordid ORDER BY N DESC LIMIT 20

lemma	N	SUBSTRING(GROUP_CONCAT(class) FROM 1 FOR 80)
roll	10	coil-9.6,split-23.2,roll-51.3.1,build-26.1,sound_emission-43.2,run-51.3.2,shake-
take	9	steal-10.5,require-103,performance-26.7-2,fit-54.3,hire-13.5.3,bring-11.3,charac
cut	8	amuse-31.1,build-26.1-1,hurt-40.8.3-2,cut-21.1-1,cut-21.1,braid-41.2.2,split-23.
shake	8	shake-22.3,amuse-31.1,knead-26.5,funnel-9.3-2-1,shake-22.3-2,crane-40.3.2,modes_
draw	7	remove-10.1,force-59-1,carry-11.4,performance-26.7-2-1,scribble-25.2,split-23.2,
kick	7	carry-11.4-1-1,swat-18.2,crane-40.3.2,throw-17.1-1-1,hit-18.1-1,body_internal_mo
clear	6	clear-10.3-1,other_cos-45.4,weather-57,clear-10.3,free-80-1,preparing-26.3-1
feel	6	stimulus_subject-30.4,hunt-35.1,consider-29.9-2,see-30.1-1,conjecture-29.5-1,mar
grow	6	entity_specific_modes_being-47.2,other_cos-45.4,build-26.1,appear-48.1.1,calibra
hang	6	spray-9.7-1,assuming_position-50,poison-42.2,put_spatial-9.2-1,spatial_configura
leave	6	keep-15.2,leave-51.2-1,resign-10.11,future_having-13.3,escape-51.1-1,fulfilling-
paint	6	butter-9.9,coloring-24,characterize-29.2,scribble-25.2,image_impression-25.1,per
pass	6	send-11.1-1,throw-17.1-1,consume-66,occurrence-48.3,give-13.1,spend_time-104
pull	6	split-23.2,push-12-1,hurt-40.8.3-1-1,carry-11.4,get-13.5.1,hold-15.1-1
push	6	push-12-1-1,hold-15.1-1,split-23.2,funnel-9.3-2-1,carry-11.4-1-1,force-59
read	6	discover-84-1-1,learn-14-2-1,transfer_mesg-37.1.1-1,register-54.1-1,learn-14-1,t
run	6	bump-18.4,carry-11.4,meander-47.7,preparing-26.3-1,swarm-47.5.1-1,run-51.3.2
scratch	6	cut-21.1-1,scribble-25.2,swat-18.2,wipe_manner-10.4.1-1,hurt-40.8.3-2,rummage-35
turn	6	hurt-40.8.3-1-1,crane-40.3.2,roll-51.3.1,convert-26.6.2,meander-47.7,turn-26.6.1
burn	6	entity_specific_modes_being-47.2,light_emission-43.1,entity_specific_cos-45.5,hu

SELECT lemma,SUBSTRING(definition FROM 1 FOR 32),class,roletype,selrestrs FROM verbnetroles WHERE pos='v' AND lemma='want' ORDER BY synsetid,classid,roletype

lemma	SUBSTRING(definition FROM 1 FOR 32)	class	roletype	selrestrs
want	wish or demand the presence of	appoint-29.1	Agent	<SELRESTRS logic="or"><SELRESTR Value="+" type="animate"/><SELRESTR Value="+" type="organization"/></SELRESTRS>
want	wish or demand the presence of	appoint-29.1	Predicate	<SELRESTRS/>
want	wish or demand the presence of	appoint-29.1	Theme	<SELRESTRS/>
want	wish or demand the presence of	want-32.1-1-1	Attribute	<SELRESTRS/>
want	wish or demand the presence of	want-32.1-1-1	Experiencer	<SELRESTRS><SELRESTR Value="+" type="animate"/></SELRESTRS>
want	wish or demand the presence of	want-32.1-1-1	Theme	<SELRESTRS/>
want	have need of	want-32.1-1-1	Attribute	<SELRESTRS/>
want	have need of	want-32.1-1-1	Experiencer	<SELRESTRS><SELRESTR Value="+" type="animate"/></SELRESTRS>
want	have need of	want-32.1-1-1	Theme	<SELRESTRS/>
want	hunt or look for; want for a par	want-32.1-1-1	Attribute	<SELRESTRS/>
want	hunt or look for; want for a par	want-32.1-1-1	Experiencer	<SELRESTRS><SELRESTR Value="+" type="animate"/></SELRESTRS>
want	hunt or look for; want for a par	want-32.1-1-1	Theme	<SELRESTRS/>
want	feel or have a desire for; want	order-60	Agent	<SELRESTRS logic="or"><SELRESTR Value="+" type="animate"/><SELRESTR Value="+" type="organization"/></SELRESTRS>
want	feel or have a desire for; want	order-60	Patient	<SELRESTRS logic="or"><SELRESTR Value="+" type="animate"/><SELRESTR Value="+" type="organization"/></SELRESTRS>
want	feel or have a desire for; want	order-60	Proposition	<SELRESTRS/>
want	feel or have a desire for; want	want-32.1-1-1	Attribute	<SELRESTRS/>
want	feel or have a desire for; want	want-32.1-1-1	Experiencer	<SELRESTRS><SELRESTR Value="+" type="animate"/></SELRESTRS>
want	feel or have a desire for; want	want-32.1-1-1	Theme	<SELRESTRS/>
want	be without, lack; be deficient i	want-32.1-1-1	Attribute	<SELRESTRS/>
want	be without, lack; be deficient i	want-32.1-1-1	Experiencer	<SELRESTRS><SELRESTR Value="+" type="animate"/></SELRESTRS>
want	be without, lack; be deficient i	want-32.1-1-1	Theme	<SELRESTRS/>

SELECT lemma,SUBSTRING(definition FROM 1 FOR 32),framename,framesubname,syntax,semantics,example FROM verbnetframes WHERE pos='v' AND lemma='want'

lemma	SUBSTRING(definition FROM 1 FOR 32)	framename	framesubname	syntax	semantics	example
want	wish or demand the presence of	NP-NP		<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP><NP value="Predicate"><SYNRESTRS/></NP>	<PRED value="designated"><ARGS><ARG type="Event" value="result(E)"/><ARG type="ThemRole" value="Theme"/><ARG type="ThemRole" value="Predicate"/></ARGS></PRED><PRED value="cause"><ARGS><ARG type="ThemRole" value="Agent"/><ARG type="Event" value="E"/></ARGS></PRED>	We elected him governor
want	wish or demand the presence of	NP-PP	as-PP	<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP><LEX value="as"/><NP value="Predicate"><SYNRESTRS><SYNRESTR Value="-" type="sentential"/></SYNRESTRS></NP>	<PRED value="designated"><ARGS><ARG type="Event" value="result(E)"/><ARG type="ThemRole" value="Theme"/><ARG type="ThemRole" value="Predicate"/></ARGS></PRED><PRED value="cause"><ARGS><ARG type="ThemRole" value="Agent"/><ARG type="Event" value="E"/></ARGS></PRED>	We elected him as governor
want	wish or demand the presence of	Infinitival Copular Clause		<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP><LEX value="to"/><LEX value="be"/><NP value="Predicate"><SYNRESTRS><SYNRESTR Value="-" type="sentential"/></SYNRESTRS></NP>	<PRED value="designated"><ARGS><ARG type="Event" value="result(E)"/><ARG type="ThemRole" value="Theme"/><ARG type="ThemRole" value="Predicate"/></ARGS></PRED><PRED value="cause"><ARGS><ARG type="ThemRole" value="Agent"/><ARG type="Event" value="E"/></ARGS></PRED>	We elected Alan to be our new governor
want	wish or demand the presence of	Basic Transitive		<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP>	<PRED value="designated"><ARGS><ARG type="Event" value="result(E)"/><ARG type="ThemRole" value="Theme"/><ARG type="ThemRole" value="Predicate"/></ARGS></PRED><PRED value="cause"><ARGS><ARG type="ThemRole" value="Agent"/><ARG type="Event" value="E"/></ARGS></PRED>	They elected John
want	wish or demand the presence of	NP-TO-INF		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="np_to_inf"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I needed him to go
want	wish or demand the presence of	NP-TOBE		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="to_be"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I need him to be nice
want	wish or demand the presence of	FOR-TO-INF		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="for_comp"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I need for her to be happy
want	wish or demand the presence of	ING-NP-OMIT		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="np_omit_ing"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I need exercising
want	wish or demand the presence of	NP-ADJP-PRED		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP><ADJ/>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	She wanted the meat red
want	wish or demand the presence of	NP-ADVP-PRED		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I needed him here
want	wish or demand the presence of	NP-ING		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="acc_ing"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I need him cooking
want	wish or demand the presence of	NP-VEN-NP-OMIT		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="np_ppart"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I need the children found
want	wish or demand the presence of	POSSING		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="poss_ing"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I needed his cooking
want	wish or demand the presence of	TO-INF-SC		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="sc_to_inf"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I needed to come
want	wish or demand the presence of	Basic Transitive		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	Dorothy needs new shoes
want	wish or demand the presence of	NP-PP	Possessor Object, Attribute-PP	<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP><PREP value="for"><SELRESTRS/></PREP><NP value="Attribute"><SYNRESTRS/></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	Dorothy needs her for her skills
want	have need of	NP-TO-INF		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="np_to_inf"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I needed him to go
want	have need of	NP-TOBE		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="to_be"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I need him to be nice
want	have need of	FOR-TO-INF		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="for_comp"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I need for her to be happy
want	have need of	ING-NP-OMIT		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="np_omit_ing"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I need exercising
want	have need of	NP-ADJP-PRED		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP><ADJ/>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	She wanted the meat red
want	have need of	NP-ADVP-PRED		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I needed him here
want	have need of	NP-ING		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="acc_ing"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I need him cooking
want	have need of	NP-VEN-NP-OMIT		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="np_ppart"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I need the children found
want	have need of	POSSING		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="poss_ing"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I needed his cooking
want	have need of	TO-INF-SC		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="sc_to_inf"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I needed to come
want	have need of	Basic Transitive		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	Dorothy needs new shoes
want	have need of	NP-PP	Possessor Object, Attribute-PP	<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP><PREP value="for"><SELRESTRS/></PREP><NP value="Attribute"><SYNRESTRS/></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	Dorothy needs her for her skills
want	hunt or look for; want for a par	NP-TO-INF		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="np_to_inf"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I needed him to go
want	hunt or look for; want for a par	NP-TOBE		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="to_be"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I need him to be nice
want	hunt or look for; want for a par	FOR-TO-INF		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="for_comp"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I need for her to be happy
want	hunt or look for; want for a par	ING-NP-OMIT		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="np_omit_ing"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I need exercising
want	hunt or look for; want for a par	NP-ADJP-PRED		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP><ADJ/>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	She wanted the meat red
want	hunt or look for; want for a par	NP-ADVP-PRED		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I needed him here
want	hunt or look for; want for a par	NP-ING		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="acc_ing"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I need him cooking
want	hunt or look for; want for a par	NP-VEN-NP-OMIT		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="np_ppart"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I need the children found
want	hunt or look for; want for a par	POSSING		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="poss_ing"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I needed his cooking
want	hunt or look for; want for a par	TO-INF-SC		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="sc_to_inf"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I needed to come
want	hunt or look for; want for a par	Basic Transitive		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	Dorothy needs new shoes
want	hunt or look for; want for a par	NP-PP	Possessor Object, Attribute-PP	<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP><PREP value="for"><SELRESTRS/></PREP><NP value="Attribute"><SYNRESTRS/></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	Dorothy needs her for her skills
want	feel or have a desire for; want	Basic Transitive		<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Patient"><SYNRESTRS/></NP>	<PRED value="command"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Agent"/><ARG type="ThemRole" value="Patient"/><ARG type="ThemRole" value="?Proposition"/></ARGS></PRED>	He ordered John
want	feel or have a desire for; want	NP-TO-INF-OC		<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Patient"><SYNRESTRS/></NP><NP value="Proposition"><SYNRESTRS><SYNRESTR Value="+" type="oc_to_inf"/></SYNRESTRS></NP>	<PRED value="command"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Agent"/><ARG type="ThemRole" value="Patient"/><ARG type="ThemRole" value="Proposition"/></ARGS></PRED>	He ordered John to eat his sloth
want	feel or have a desire for; want	NP-TO-INF		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="np_to_inf"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I needed him to go
want	feel or have a desire for; want	NP-TOBE		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="to_be"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I need him to be nice
want	feel or have a desire for; want	FOR-TO-INF		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="for_comp"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I need for her to be happy
want	feel or have a desire for; want	ING-NP-OMIT		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="np_omit_ing"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I need exercising
want	feel or have a desire for; want	NP-ADJP-PRED		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP><ADJ/>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	She wanted the meat red
want	feel or have a desire for; want	NP-ADVP-PRED		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I needed him here
want	feel or have a desire for; want	NP-ING		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="acc_ing"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I need him cooking
want	feel or have a desire for; want	NP-VEN-NP-OMIT		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="np_ppart"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I need the children found
want	feel or have a desire for; want	POSSING		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="poss_ing"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I needed his cooking
want	feel or have a desire for; want	TO-INF-SC		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="sc_to_inf"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I needed to come
want	feel or have a desire for; want	Basic Transitive		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	Dorothy needs new shoes
want	feel or have a desire for; want	NP-PP	Possessor Object, Attribute-PP	<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP><PREP value="for"><SELRESTRS/></PREP><NP value="Attribute"><SYNRESTRS/></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	Dorothy needs her for her skills
want	be without, lack; be deficient i	NP-TO-INF		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="np_to_inf"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I needed him to go
want	be without, lack; be deficient i	NP-TOBE		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="to_be"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I need him to be nice
want	be without, lack; be deficient i	FOR-TO-INF		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="for_comp"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I need for her to be happy
want	be without, lack; be deficient i	ING-NP-OMIT		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="np_omit_ing"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I need exercising
want	be without, lack; be deficient i	NP-ADJP-PRED		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP><ADJ/>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	She wanted the meat red
want	be without, lack; be deficient i	NP-ADVP-PRED		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I needed him here
want	be without, lack; be deficient i	NP-ING		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="acc_ing"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I need him cooking
want	be without, lack; be deficient i	NP-VEN-NP-OMIT		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="np_ppart"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I need the children found
want	be without, lack; be deficient i	POSSING		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="poss_ing"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I needed his cooking
want	be without, lack; be deficient i	TO-INF-SC		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS><SYNRESTR Value="+" type="sc_to_inf"/></SYNRESTRS></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	I needed to come
want	be without, lack; be deficient i	Basic Transitive		<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	Dorothy needs new shoes
want	be without, lack; be deficient i	NP-PP	Possessor Object, Attribute-PP	<NP value="Experiencer"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP><PREP value="for"><SELRESTRS/></PREP><NP value="Attribute"><SYNRESTRS/></NP>	<PRED value="desire"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Experiencer"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	Dorothy needs her for her skills

SELECT lemma,SUBSTRING(definition FROM 1 FOR 32),framename,framesubname,frameid,SUBSTRING(semantics FROM 1 FOR 32) FROM verbnetframes INNER JOIN vnpredicatemaps USING (semanticsid) INNER JOIN vnpredicates USING (predid) WHERE pred='rotational_motion' ORDER BY lemma,framename,framesubname

lemma	SUBSTRING(definition FROM 1 FOR 32)	framename	framesubname	frameid	SUBSTRING(semantics FROM 1 FOR 32)
coil	wind around something in coils o	Middle Construction		310	<PRED value="rotational_motion">
coil	wind around something in coils o	NP-PP	path-PP	641	<PRED value="rotational_motion">
coil	wind around something in coils o	PP	path-PP	945	<PRED value="rotational_motion">
curl	twist or roll into coils or ring	Middle Construction		310	<PRED value="rotational_motion">
curl	shape one's body into a curl	Middle Construction		310	<PRED value="rotational_motion">
curl	wind around something in coils o	Middle Construction		310	<PRED value="rotational_motion">
curl	twist or roll into coils or ring	NP-PP	path-PP	641	<PRED value="rotational_motion">
curl	shape one's body into a curl	NP-PP	path-PP	641	<PRED value="rotational_motion">
curl	wind around something in coils o	NP-PP	path-PP	641	<PRED value="rotational_motion">
curl	wind around something in coils o	PP	path-PP	945	<PRED value="rotational_motion">
curl	twist or roll into coils or ring	PP	path-PP	945	<PRED value="rotational_motion">
curl	shape one's body into a curl	PP	path-PP	945	<PRED value="rotational_motion">
loop	make a loop in	NP-PP	path-PP	641	<PRED value="rotational_motion">
loop	wind around something in coils o	NP-PP	path-PP	641	<PRED value="rotational_motion">
loop	make a loop in	PP	path-PP	945	<PRED value="rotational_motion">
loop	wind around something in coils o	PP	path-PP	945	<PRED value="rotational_motion">
roll	arrange or or coil around	NP-PP	path-PP	641	<PRED value="rotational_motion">
roll	arrange or or coil around	PP	path-PP	945	<PRED value="rotational_motion">
rotate	turn on or around an axis or a c	NP-PP	path-PP	641	<PRED value="rotational_motion">
rotate	turn on or around an axis or a c	PP	path-PP	945	<PRED value="rotational_motion">
spin	cause to spin	NP-PP	path-PP	641	<PRED value="rotational_motion">
spin	cause to spin	PP	path-PP	945	<PRED value="rotational_motion">
swing	move in a curve or arc, usually	Middle Construction		310	<PRED value="rotational_motion">
swing	change direction with a swinging	Middle Construction		310	<PRED value="rotational_motion">
swing	move in a curve or arc, usually	NP-PP	path-PP	641	<PRED value="rotational_motion">
swing	change direction with a swinging	NP-PP	path-PP	641	<PRED value="rotational_motion">
swing	move in a curve or arc, usually	PP	path-PP	945	<PRED value="rotational_motion">
swing	change direction with a swinging	PP	path-PP	945	<PRED value="rotational_motion">
swirl	turn in a twisting or spinning m	NP-PP	path-PP	641	<PRED value="rotational_motion">
swirl	turn in a twisting or spinning m	PP	path-PP	945	<PRED value="rotational_motion">
twine	arrange or or coil around	NP-PP	path-PP	641	<PRED value="rotational_motion">
twine	arrange or or coil around	PP	path-PP	945	<PRED value="rotational_motion">
twirl	cause to spin	Middle Construction		310	<PRED value="rotational_motion">
twirl	cause to spin	NP-PP	path-PP	641	<PRED value="rotational_motion">
twirl	cause to spin	PP	path-PP	945	<PRED value="rotational_motion">
twist	form into twists	Middle Construction		310	<PRED value="rotational_motion">
twist	form into twists	NP-PP	path-PP	641	<PRED value="rotational_motion">
twist	form into twists	PP	path-PP	945	<PRED value="rotational_motion">
whirl	cause to spin	NP-PP	path-PP	641	<PRED value="rotational_motion">
whirl	cause to spin	PP	path-PP	945	<PRED value="rotational_motion">
wind	arrange or or coil around	NP-PP	path-PP	641	<PRED value="rotational_motion">
wind	arrange or or coil around	PP	path-PP	945	<PRED value="rotational_motion">

SELECT class,GROUP_CONCAT(lemma) FROM verbnetroles WHERE roletype = 'Stimulus' GROUP BY roleid

class	GROUP_CONCAT(lemma)
see-30.1-1-1	hear,savor,sound,ogle,espy,sight,stare,inspect,survey,feel,note,watch,gape,see,peruse,look,listen,see,descry,scan,peer,experience,spy,taste,investigate,watch,feel,observe,sniff,glance,see,regard,smell,look,hear,discover,scrutinize,squint,inspect,survey,discern,note,watch,check,notice,perceive,look,leer,see,hear,scan,taste,peep,examine,spot,taste,investigate,watch,feel,observe,witness,gaze,see,recognize,smell,look,see,discover,scrutinize,snoop,glimpse,study,detect,note,watch,check,notice,overhear,feel,goggle,see,hear,savor,taste,peek,examine,spot,smell,inspect,view,feel,observe,witness,gawk,see,recognize,look,listen,see,discover,scent,sniff,eye,spy,taste,make out,watch,sense,observe,feel,glare,see

class

GROUP_CONCAT(lemma)

see-30.1-1-1

hear,savor,sound,ogle,espy,sight,stare,inspect,survey,feel,note,watch,gape,see,peruse,look,listen,see,descry,scan,peer,experience,spy,taste,investigate,watch,feel,observe,sniff,glance,see,regard,smell,look,hear,discover,scrutinize,squint,inspect,survey,discern,note,watch,check,notice,perceive,look,leer,see,hear,scan,taste,peep,examine,spot,taste,investigate,watch,feel,observe,witness,gaze,see,recognize,smell,look,see,discover,scrutinize,snoop,glimpse,study,detect,note,watch,check,notice,overhear,feel,goggle,see,hear,savor,taste,peek,examine,spot,smell,inspect,view,feel,observe,witness,gawk,see,recognize,look,listen,see,discover,scent,sniff,eye,spy,taste,make out,watch,sense,observe,feel,glare,see

SELECT synsetid,class,lemma,GROUP_CONCAT(roletype ORDER BY roletype),SUBSTRING(definition FROM 1 FOR 64) FROM verbnetroles WHERE lemma = 'guide' GROUP BY synsetid,classid ORDER BY synsetid,classid

synsetid	class	lemma	GROUP_CONCAT(roletype ORDER BY roletype)	SUBSTRING(definition FROM 1 FOR 64)
201212230	accompany-51.7	guide	Agent,Destination,Theme	pass over, across, or through
201931768	accompany-51.7	guide	Agent,Destination,Theme	direct the course; determine the direction of travelling
201931768	force-59-1	guide	Agent,Patient,Proposition	direct the course; determine the direction of travelling
201999798	accompany-51.7	guide	Agent,Destination,Theme	take somebody somewhere
202439732	force-59-1	guide	Agent,Patient,Proposition	be a guiding or motivating force or drive

SELECT lemma,class,sensekey,roletype,selrestrs,rquality FROM verbnetroles WHERE lemma = 'guide' ORDER BY classid,sensekey,roletype,selrestrs

lemma	class	sensekey	roletype	selrestrs	rquality
guide	accompany-51.7	guide%2:35:00::	Agent	<SELRESTRS><SELRESTR Value="+" type="animate"/></SELRESTRS>	100
guide	accompany-51.7	guide%2:35:00::	Destination	<SELRESTRS/>	100
guide	accompany-51.7	guide%2:35:00::	Theme	<SELRESTRS><SELRESTR Value="+" type="animate"/></SELRESTRS>	100
guide	accompany-51.7	guide%2:38:00::	Agent	<SELRESTRS><SELRESTR Value="+" type="animate"/></SELRESTRS>	100
guide	accompany-51.7	guide%2:38:00::	Destination	<SELRESTRS/>	100
guide	accompany-51.7	guide%2:38:00::	Theme	<SELRESTRS><SELRESTR Value="+" type="animate"/></SELRESTRS>	100
guide	accompany-51.7	guide%2:38:01::	Agent	<SELRESTRS><SELRESTR Value="+" type="animate"/></SELRESTRS>	0
guide	accompany-51.7	guide%2:38:01::	Destination	<SELRESTRS/>	0
guide	accompany-51.7	guide%2:38:01::	Theme	<SELRESTRS><SELRESTR Value="+" type="animate"/></SELRESTRS>	0
guide	force-59-1	guide%2:38:01::	Agent	<SELRESTRS logic="or"><SELRESTR Value="+" type="animate"/><SELRESTR Value="+" type="organization"/></SELRESTRS>	100
guide	force-59-1	guide%2:38:01::	Patient	<SELRESTRS logic="or"><SELRESTR Value="+" type="animate"/><SELRESTR Value="+" type="organization"/></SELRESTRS>	100
guide	force-59-1	guide%2:38:01::	Proposition	<SELRESTRS/>	100
guide	force-59-1	guide%2:41:00::	Agent	<SELRESTRS logic="or"><SELRESTR Value="+" type="animate"/><SELRESTR Value="+" type="organization"/></SELRESTRS>	100
guide	force-59-1	guide%2:41:00::	Patient	<SELRESTRS logic="or"><SELRESTR Value="+" type="animate"/><SELRESTR Value="+" type="organization"/></SELRESTRS>	100
guide	force-59-1	guide%2:41:00::	Proposition	<SELRESTRS/>	100

SELECT DISTINCT sensekey,class,framename,framesubname,number,xtag,syntax,semantics,exampleset, roletype,selrestrs,fquality,rquality FROM verbnetrolesframes LEFT JOIN vnexamplesets USING (frameid) WHERE sensekey LIKE 'guide%%2:38%' ORDER BY synsetid,class ASC,frameid ASC,roletypeid ASC

sensekey	class	framename	framesubname	number	xtag	syntax	semantics	exampleset	roletype	selrestrs	fquality	rquality
guide%2:38:01::	accompany-51.7	Basic Transitive		0.2	0.2	<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP>	<PRED value="motion"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Agent"/></ARGS></PRED><PRED value="motion"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	Jackie accompanied Rose\|Jackie chased the thief	Agent	<SELRESTRS><SELRESTR Value="+" type="animate"/></SELRESTRS>	0	0
guide%2:38:01::	accompany-51.7	Basic Transitive		0.2	0.2	<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP>	<PRED value="motion"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Agent"/></ARGS></PRED><PRED value="motion"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	Jackie accompanied Rose\|Jackie chased the thief	Destination	<SELRESTRS/>	0	0
guide%2:38:01::	accompany-51.7	Basic Transitive		0.2	0.2	<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP>	<PRED value="motion"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Agent"/></ARGS></PRED><PRED value="motion"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	Jackie accompanied Rose\|Jackie chased the thief	Theme	<SELRESTRS><SELRESTR Value="+" type="animate"/></SELRESTRS>	0	0
guide%2:38:01::	accompany-51.7	NP-PP	path-PP	0.2		<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP><PREP><SELRESTRS><SELRESTR Value="+" type="spatial"/></SELRESTRS></PREP><NP value="Destination"><SYNRESTRS/></NP>	<PRED value="motion"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Agent"/></ARGS></PRED><PRED value="motion"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED><PRED value="Prep"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Theme"/><ARG type="ThemRole" value="Destination"/></ARGS></PRED><PRED value="Prep"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Agent"/><ARG type="ThemRole" value="Destination"/></ARGS></PRED>	Jackie accompanied Rose to the store	Agent	<SELRESTRS><SELRESTR Value="+" type="animate"/></SELRESTRS>	0	0
guide%2:38:01::	accompany-51.7	NP-PP	path-PP	0.2		<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP><PREP><SELRESTRS><SELRESTR Value="+" type="spatial"/></SELRESTRS></PREP><NP value="Destination"><SYNRESTRS/></NP>	<PRED value="motion"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Agent"/></ARGS></PRED><PRED value="motion"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED><PRED value="Prep"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Theme"/><ARG type="ThemRole" value="Destination"/></ARGS></PRED><PRED value="Prep"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Agent"/><ARG type="ThemRole" value="Destination"/></ARGS></PRED>	Jackie accompanied Rose to the store	Destination	<SELRESTRS/>	0	0
guide%2:38:01::	accompany-51.7	NP-PP	path-PP	0.2		<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP><PREP><SELRESTRS><SELRESTR Value="+" type="spatial"/></SELRESTRS></PREP><NP value="Destination"><SYNRESTRS/></NP>	<PRED value="motion"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Agent"/></ARGS></PRED><PRED value="motion"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED><PRED value="Prep"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Theme"/><ARG type="ThemRole" value="Destination"/></ARGS></PRED><PRED value="Prep"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Agent"/><ARG type="ThemRole" value="Destination"/></ARGS></PRED>	Jackie accompanied Rose to the store	Theme	<SELRESTRS><SELRESTR Value="+" type="animate"/></SELRESTRS>	0	0
guide%2:38:01::	force-59-1	Basic Transitive		0.2	0.2	<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Patient"><SYNRESTRS/></NP>	<PRED value="force"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Agent"/><ARG type="ThemRole" value="Patient"/><ARG type="ThemRole" value="?Proposition"/></ARGS></PRED>	I forced him	Agent	<SELRESTRS logic="or"><SELRESTR Value="+" type="animate"/><SELRESTR Value="+" type="organization"/></SELRESTRS>	100	100
guide%2:38:01::	force-59-1	Basic Transitive		0.2	0.2	<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Patient"><SYNRESTRS/></NP>	<PRED value="force"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Agent"/><ARG type="ThemRole" value="Patient"/><ARG type="ThemRole" value="?Proposition"/></ARGS></PRED>	I forced him	Patient	<SELRESTRS logic="or"><SELRESTR Value="+" type="animate"/><SELRESTR Value="+" type="organization"/></SELRESTRS>	100	100
guide%2:38:01::	force-59-1	Basic Transitive		0.2	0.2	<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Patient"><SYNRESTRS/></NP>	<PRED value="force"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Agent"/><ARG type="ThemRole" value="Patient"/><ARG type="ThemRole" value="?Proposition"/></ARGS></PRED>	I forced him	Proposition	<SELRESTRS/>	100	100
guide%2:38:01::	force-59-1	NP-P-ING-OC	into-PP	0.2	0.2	<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Patient"><SYNRESTRS/></NP><PREP value="into"><SELRESTRS/></PREP><NP value="Proposition"><SYNRESTRS><SYNRESTR Value="+" type="oc_ing"/></SYNRESTRS></NP>	<PRED value="force"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Agent"/><ARG type="ThemRole" value="Patient"/><ARG type="ThemRole" value="Proposition"/></ARGS></PRED>	I forced him into coming	Agent	<SELRESTRS logic="or"><SELRESTR Value="+" type="animate"/><SELRESTR Value="+" type="organization"/></SELRESTRS>	100	100
guide%2:38:01::	force-59-1	NP-P-ING-OC	into-PP	0.2	0.2	<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Patient"><SYNRESTRS/></NP><PREP value="into"><SELRESTRS/></PREP><NP value="Proposition"><SYNRESTRS><SYNRESTR Value="+" type="oc_ing"/></SYNRESTRS></NP>	<PRED value="force"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Agent"/><ARG type="ThemRole" value="Patient"/><ARG type="ThemRole" value="Proposition"/></ARGS></PRED>	I forced him into coming	Patient	<SELRESTRS logic="or"><SELRESTR Value="+" type="animate"/><SELRESTR Value="+" type="organization"/></SELRESTRS>	100	100
guide%2:38:01::	force-59-1	NP-P-ING-OC	into-PP	0.2	0.2	<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Patient"><SYNRESTRS/></NP><PREP value="into"><SELRESTRS/></PREP><NP value="Proposition"><SYNRESTRS><SYNRESTR Value="+" type="oc_ing"/></SYNRESTRS></NP>	<PRED value="force"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Agent"/><ARG type="ThemRole" value="Patient"/><ARG type="ThemRole" value="Proposition"/></ARGS></PRED>	I forced him into coming	Proposition	<SELRESTRS/>	100	100
guide%2:38:01::	force-59-1	NP-PP	into-PP	0.2	0.1	<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Patient"><SYNRESTRS/></NP><PREP value="into"><SELRESTRS/></PREP><NP value="Proposition"><SYNRESTRS><SYNRESTR Value="-" type="sentential"/></SYNRESTRS></NP>	<PRED value="force"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Agent"/><ARG type="ThemRole" value="Patient"/><ARG type="ThemRole" value="Proposition"/></ARGS></PRED>	I forced John into the chairmanship	Agent	<SELRESTRS logic="or"><SELRESTR Value="+" type="animate"/><SELRESTR Value="+" type="organization"/></SELRESTRS>	100	100
guide%2:38:01::	force-59-1	NP-PP	into-PP	0.2	0.1	<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Patient"><SYNRESTRS/></NP><PREP value="into"><SELRESTRS/></PREP><NP value="Proposition"><SYNRESTRS><SYNRESTR Value="-" type="sentential"/></SYNRESTRS></NP>	<PRED value="force"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Agent"/><ARG type="ThemRole" value="Patient"/><ARG type="ThemRole" value="Proposition"/></ARGS></PRED>	I forced John into the chairmanship	Patient	<SELRESTRS logic="or"><SELRESTR Value="+" type="animate"/><SELRESTR Value="+" type="organization"/></SELRESTRS>	100	100
guide%2:38:01::	force-59-1	NP-PP	into-PP	0.2	0.1	<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Patient"><SYNRESTRS/></NP><PREP value="into"><SELRESTRS/></PREP><NP value="Proposition"><SYNRESTRS><SYNRESTR Value="-" type="sentential"/></SYNRESTRS></NP>	<PRED value="force"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Agent"/><ARG type="ThemRole" value="Patient"/><ARG type="ThemRole" value="Proposition"/></ARGS></PRED>	I forced John into the chairmanship	Proposition	<SELRESTRS/>	100	100
guide%2:38:01::	force-59-1	NP-TO-INF-OC		8.1	0.1	<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Patient"><SYNRESTRS/></NP><NP value="Proposition"><SYNRESTRS><SYNRESTR Value="+" type="oc_to_inf"/></SYNRESTRS></NP>	<PRED value="force"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Agent"/><ARG type="ThemRole" value="Patient"/><ARG type="ThemRole" value="Proposition"/></ARGS></PRED>	I forced him to come	Agent	<SELRESTRS logic="or"><SELRESTR Value="+" type="animate"/><SELRESTR Value="+" type="organization"/></SELRESTRS>	100	100
guide%2:38:01::	force-59-1	NP-TO-INF-OC		8.1	0.1	<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Patient"><SYNRESTRS/></NP><NP value="Proposition"><SYNRESTRS><SYNRESTR Value="+" type="oc_to_inf"/></SYNRESTRS></NP>	<PRED value="force"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Agent"/><ARG type="ThemRole" value="Patient"/><ARG type="ThemRole" value="Proposition"/></ARGS></PRED>	I forced him to come	Patient	<SELRESTRS logic="or"><SELRESTR Value="+" type="animate"/><SELRESTR Value="+" type="organization"/></SELRESTRS>	100	100
guide%2:38:01::	force-59-1	NP-TO-INF-OC		8.1	0.1	<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Patient"><SYNRESTRS/></NP><NP value="Proposition"><SYNRESTRS><SYNRESTR Value="+" type="oc_to_inf"/></SYNRESTRS></NP>	<PRED value="force"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Agent"/><ARG type="ThemRole" value="Patient"/><ARG type="ThemRole" value="Proposition"/></ARGS></PRED>	I forced him to come	Proposition	<SELRESTRS/>	100	100
guide%2:38:00::	accompany-51.7	Basic Transitive		0.2	0.2	<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP>	<PRED value="motion"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Agent"/></ARGS></PRED><PRED value="motion"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	Jackie accompanied Rose\|Jackie chased the thief	Agent	<SELRESTRS><SELRESTR Value="+" type="animate"/></SELRESTRS>	100	100
guide%2:38:00::	accompany-51.7	Basic Transitive		0.2	0.2	<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP>	<PRED value="motion"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Agent"/></ARGS></PRED><PRED value="motion"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	Jackie accompanied Rose\|Jackie chased the thief	Destination	<SELRESTRS/>	100	100
guide%2:38:00::	accompany-51.7	Basic Transitive		0.2	0.2	<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP>	<PRED value="motion"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Agent"/></ARGS></PRED><PRED value="motion"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED>	Jackie accompanied Rose\|Jackie chased the thief	Theme	<SELRESTRS><SELRESTR Value="+" type="animate"/></SELRESTRS>	100	100
guide%2:38:00::	accompany-51.7	NP-PP	path-PP	0.2		<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP><PREP><SELRESTRS><SELRESTR Value="+" type="spatial"/></SELRESTRS></PREP><NP value="Destination"><SYNRESTRS/></NP>	<PRED value="motion"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Agent"/></ARGS></PRED><PRED value="motion"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED><PRED value="Prep"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Theme"/><ARG type="ThemRole" value="Destination"/></ARGS></PRED><PRED value="Prep"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Agent"/><ARG type="ThemRole" value="Destination"/></ARGS></PRED>	Jackie accompanied Rose to the store	Agent	<SELRESTRS><SELRESTR Value="+" type="animate"/></SELRESTRS>	100	100
guide%2:38:00::	accompany-51.7	NP-PP	path-PP	0.2		<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP><PREP><SELRESTRS><SELRESTR Value="+" type="spatial"/></SELRESTRS></PREP><NP value="Destination"><SYNRESTRS/></NP>	<PRED value="motion"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Agent"/></ARGS></PRED><PRED value="motion"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED><PRED value="Prep"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Theme"/><ARG type="ThemRole" value="Destination"/></ARGS></PRED><PRED value="Prep"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Agent"/><ARG type="ThemRole" value="Destination"/></ARGS></PRED>	Jackie accompanied Rose to the store	Destination	<SELRESTRS/>	100	100
guide%2:38:00::	accompany-51.7	NP-PP	path-PP	0.2		<NP value="Agent"><SYNRESTRS/></NP><VERB/><NP value="Theme"><SYNRESTRS/></NP><PREP><SELRESTRS><SELRESTR Value="+" type="spatial"/></SELRESTRS></PREP><NP value="Destination"><SYNRESTRS/></NP>	<PRED value="motion"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Agent"/></ARGS></PRED><PRED value="motion"><ARGS><ARG type="Event" value="during(E)"/><ARG type="ThemRole" value="Theme"/></ARGS></PRED><PRED value="Prep"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Theme"/><ARG type="ThemRole" value="Destination"/></ARGS></PRED><PRED value="Prep"><ARGS><ARG type="Event" value="E"/><ARG type="ThemRole" value="Agent"/><ARG type="ThemRole" value="Destination"/></ARGS></PRED>	Jackie accompanied Rose to the store	Theme	<SELRESTRS><SELRESTR Value="+" type="animate"/></SELRESTRS>	100	100

SELECT COUNT(*) FROM vnframemaps

COUNT(*)
52968

SELECT fquality,COUNT(*) FROM vnframemaps WHERE fquality = 0

fquality	COUNT(*)
0	643

SELECT fquality,COUNT(*) FROM vnframemaps WHERE fquality = 100

fquality	COUNT(*)
100	52325

SELECT COUNT(*) FROM vnrolemaps

COUNT(*)
26779

SELECT rquality,COUNT(*) FROM vnrolemaps WHERE rquality = 0

rquality	COUNT(*)
0	418

SELECT rquality,COUNT(*) FROM vnrolemaps WHERE rquality = 100

rquality	COUNT(*)
100	26361