LEGACY
wordnet 2.0 to 3.0
SELECT lemma,quality,ssynsetid,dsynsetid,ssensekey,dsensekey,SUBSTRING(definition FROM 1 FOR 32) FROM legacy20 where ssynsetid=100124550
wordnet 3.0 to 2.0
SELECT lemma,quality,ssynsetid,dsynsetid,ssensekey,dsensekey,SUBSTRING(definition FROM 1 FOR 32) FROM legacy20 where dsynsetid=100130045
wordnet 3.0 to 2.1
SELECT lemma,quality,ssynsetid,dsynsetid,ssensekey,dsensekey,SUBSTRING(definition FROM 1 FOR 32) FROM legacy21 where dsynsetid=100130045
wordnet 3.0 to 2.1
SELECT lemma,quality,ssynsetid,dsynsetid,ssensekey,dsensekey,SUBSTRING(definition FROM 1 FOR 32) FROM legacy21 where dsynsetid=102690270
lemmaqualityssynsetiddsynsetidssensekeydsensekeySUBSTRING(definition FROM 1 FOR 32)
air hose100102665619102690270air_hose%1:06:00::air_hose%1:06:00::a hose that carries air under pr
airline100102665619102690270airline%1:06:01::airline%1:06:01::a hose that carries air under pr
abase (mono)
SELECT lemma,quality,ssynsetid,dsynsetid,ssensekey,dsensekey,SUBSTRING(definition FROM 1 FOR 32) FROM legacy21 WHERE lemma='abase' ORDER BY ssensekey
lemmaqualityssynsetiddsynsetidssensekeydsensekeySUBSTRING(definition FROM 1 FOR 32)
abase100201782644201799794abase%2:37:00::abase%2:37:00::cause to feel shame; hurt the pr
afford (poly)
SELECT lemma,quality,ssynsetid,dsynsetid,ssensekey,dsensekey,SUBSTRING(definition FROM 1 FOR 32) FROM legacy21 WHERE lemma='afford' ORDER BY ssensekey
lemmaqualityssynsetiddsynsetidssensekeydsensekeySUBSTRING(definition FROM 1 FOR 32)
afford100201181406201192628afford%2:34:00::afford%2:34:00::be able to spare or give up
afford100202316932202339171afford%2:40:00::afford%2:40:00::be the cause or source of
afford70202335639202358034afford%2:40:01::afford%2:40:01::afford access to
afford70202335639202744451afford%2:40:01::afford%2:42:00::have the financial means to do s
afford100202719910202744451afford%2:42:00::afford%2:42:00::have the financial means to do s
wordnet 2.0 to 3.0 for "want" from sensekey
SELECT lemma,quality,ssynsetid,dsynsetid,ssensekey,dsensekey,SUBSTRING(definition FROM 1 FOR 32) FROM legacy20 WHERE ssensekey LIKE 'want\%%'
synset merge
SELECT lemma,quality,ssynsetid,dsynsetid,ssensekey,dsensekey,SUBSTRING(definition FROM 1 FOR 32) FROM legacy21 WHERE dsynsetid=100002137 ORDER BY ssensekey
lemmaqualityssynsetiddsynsetidssensekeydsensekeySUBSTRING(definition FROM 1 FOR 32)
abstraction80100002236100002137abstraction%1:03:00::abstraction%1:03:00::a general concept formed by extr
abstract entity100100002119100002137abstract_entity%1:03:00::abstract_entity%1:03:00::a general concept formed by extr
synset merge
SELECT quality,synset2id,synsetid,SUBSTRING(definition FROM 1 FOR 32) FROM synsetmaps2130 INNER JOIN synsets USING (synsetid) WHERE synsetid=100002137
qualitysynset2idsynsetidSUBSTRING(definition FROM 1 FOR 32)
37100002119100002137a general concept formed by extr
100100002119100002137a general concept formed by extr
62100002236100002137a general concept formed by extr
100100002236100002137a general concept formed by extr
synset split
SELECT lemma,quality,ssynsetid,dsynsetid,ssensekey,dsensekey,SUBSTRING(definition FROM 1 FOR 32) FROM legacy21 WHERE ssynsetid=100019102 ORDER BY ssensekey
lemmaqualityssynsetiddsynsetidssensekeydsensekeySUBSTRING(definition FROM 1 FOR 32)
matter90100019102100020827matter%1:03:00::matter%1:03:00::that which has mass and occupies
substance80100019102100019613substance%1:03:00::substance%1:03:00::the real physical matter of whic
synset split
SELECT quality,synset2id,synsetid,SUBSTRING(definition FROM 1 FOR 32) FROM synsetmaps2130 INNER JOIN synsets USING (synsetid) WHERE synset2id=100019102
qualitysynset2idsynsetidSUBSTRING(definition FROM 1 FOR 32)
100100019102100020827that which has mass and occupies
100100019102100019613the real physical matter of whic
100100019102100020090a particular kind or species of
100100019102114580597material of a particular kind or
synset map view (from sensemap)
query from destination synset
SELECT quality,ssynsetid,dsynsetid,SUBSTRING(definition FROM 1 FOR 32) FROM legacy21 WHERE dsynsetid=202358034
qualityssynsetiddsynsetidSUBSTRING(definition FROM 1 FOR 32)
100202335639202358034afford access to
100202335639202358034afford access to
70202335639202358034afford access to
query from sensekey
SELECT sensekey,SUBSTRING(definition FROM 1 FOR 64) FROM senses INNER JOIN synsets USING (synsetid) WHERE sensekey LIKE 'james\%%'
sensekeySUBSTRING(definition FROM 1 FOR 64)
james%1:10:00::a New Testament book attributed to Saint James the Apostle
james%1:17:00::a river that rises in North Dakota and flows southward across So
james%1:17:01::a river in Virginia that flows east into Chesapeake Bay at Hampt
james%1:18:00::(New Testament) disciple of Jesus; brother of John; author of th
james%1:18:01::writer who was born in the United States but lived in England (1
james%1:18:02::United States pragmatic philosopher and psychologist (1842-1910)
james%1:18:03::United States outlaw who fought as a Confederate soldier and lat
james%1:18:04::the first Stuart to be king of England and Ireland from 1603 to
james%1:18:05::the last Stuart to be king of England and Ireland and Scotland;
james%1:18:06::a Stuart king of Scotland who married a daughter of Henry VII; w