geo.cphrase
Here you can browse the full geo.cphrase.
There is also an associated file Geo.db_xml full database state.
<?xml version="1.0" encoding="UTF-8"?>
<config id="Geo" db="sqlite:geo.db" language="english">
<table id="City" lex="city,cities,cites,town,towns,cities or towns">
<column id="name" type="text" lex="name,names,named,called">
<value val="New York" lex="the big apple,empire city"/>
</column>
<column id="state" type="text" lex="state,states,where" select="false" properties="none"/>
<column id="population" type="int" lower="100" lex="population,populations,large,people,citizens,residents,how many people stay,how many people reside,how many people live,how many people,how many people lived,how many residents live,size,number of people,number of citizens,how many citizens live,how many citizens,inhabitants,how big,how large,how many inhabitants">
<max lex="most people,most population,biggest,biggest population,greatest population,most populous,biggest,highest number of citizens,highest populations,highest population,with the most inhabitants"/>
<min lex="smallest population,lowest population,least populous,least population"/>
</column>
<primary_key key="name,state"/>
<foreign_key from="state" to="State" lex="located in,have,in,of,with"/>
<primary_value key="name"/>
</table>
<table id="State" lex="state,states">
<column id="name" type="text" lex="name,names,named,called">
<value val="District of Columbia" lex="dc,washington dc,washington"/>
<set_value lex="west coast">
<element val="California"/>
<element val="Oregon"/>
<element val="Washington"/>
<element val="Alaska"/>
</set_value>
</column>
<column id="population" type="int" lex="population,populations,large,big,people,citizens,residents,how many people stay,how many people reside,how many people live,how many people,how many residents live in,size,how many citizens live,how many citizens,how many inhabitants,how big,how many citizens,how much,how large,how much population">
<max lex="most people,most population,biggest population,greatest population,most populous,most inhabitants,most populated,biggest,highest number of citizens,highest populations,highest population,highest number of citizens"/>
<min lex="smallest population,lowest population,least populous"/>
</column>
<column id="area" type="int" lex="area,areas,large,big,size,square kilometers,how many square kilometers,how big,how large">
<max lex="biggest"/>
<min lex="smallest area"/>
</column>
<column id="density" type="real" lex="population density,population densities,average population per square km,population per square km">
<max lex="highest population density,greatest density,largest density,largest population density,most dense"/>
<min lex="smallest population density,sparsest population density,lowest population density,least population density"/>
</column>
<column id="capital" type="text" select="false" properties="none"/>
<primary_key key="name"/>
</table>
<table id="Border" lex="border,borders,bordering,bordering,surrounding,neighbor,next to,adjacent,adjoin,neighboring">
<column id="state1" type="text" properties="none"/>
<column id="state2" type="text" properties="none"/>
<foreign_key from="state1" to="State"/>
<foreign_key from="state2" to="State"/>
</table>
<table id="Mountain" lex="mountain,mountains,mount,peak,summit">
<column id="state" type="text" lex="state,states,located,where" properties="none"/>
<column id="name" type="text"/>
<column id="height" type="int" lex="height,heights,how tall" units="meters">
<max lex="highest,tallest"/>
<min lex="shortest"/>
</column>
<primary_key key="name"/>
<foreign_key from="state" to="State" lex="in,that have,of"/>
</table>
<table id="Lake">
<column id="name" type="text"/>
<column id="area" type="int"/>
<primary_key key="name"/>
</table>
<table id="Lakeinstate" silent="true" lex="lake-state membership record,lake-state membership records,accesses,within,has within,is within">
<column id="state" type="text" properties="none"/>
<column id="lake" type="text" properties="none"/>
<foreign_key from="state" to="State"/>
<foreign_key from="lake" to="Lake"/>
</table>
<table id="River" lex="river,rivers">
<column id="name" type="text" lex="name,names,called,named"/>
<column id="length" type="int" lex="length,how long">
<max lex="longest"/>
<min lex="shortest"/>
</column>
<primary_key key="name"/>
</table>
<table id="Riverflowsthrough" lex="with a flowing of,flowing through,flowing,flow though,are found in,run through,pass through,that cross over,go through,running through,run,flows,flow,runs,traverses,lie on,cross,washed by,traverse,traversed by,goes through,passes through,runs through,through,flow through,are in">
<column id="state" type="text" properties="none"/>
<column id="river" type="text" select="false" properties="none"/>
<foreign_key from="state" to="State"/>
<foreign_key from="river" to="River"/>
</table>
<table id="Road" lex="road,roads">
<column id="number" type="text" lex="number,numbers,called,named"/>
<primary_key key="number"/>
</table>
<table id="Roadpassesthrough" lex="road passing,road passings,through,through">
<column id="state" type="text" properties="none"/>
<column id="road" type="text" select="false" properties="none"/>
<foreign_key from="state" to="State"/>
<foreign_key from="road" to="Road"/>
</table>
<table id="High" lex="highest point,highest points,point,points,high point,high points,highest spot,highest elevation,highest">
<column id="state" type="text" properties="none"/>
<column id="point" type="text" lex="point,where"/>
<column id="elevation" type="int" lex="highest elevation,height,how tall,how high">
<max lex="highest"/>
</column>
<primary_key key="point"/>
<foreign_key from="state" to="State" lex="of,contains,in,with,has"/>
</table>
<table id="Low" lex="lowest point,low points,point,points,lowest spot,lowest elevation">
<column id="state" type="text" properties="none"/>
<column id="point" type="text" lex="point,where"/>
<column id="elevation" type="int" lex="lowest elevation,low">
<value val="0" lex="sea level"/>
<min lex="lowest"/>
</column>
<primary_key key="point"/>
<foreign_key from="state" to="State" lex="of,contains,in,with,has"/>
</table>
<view id="Capital" lex="capital,capitals,capital city,capital cities,state capital">
<column id="name" type="text"/>
<column id="state" type="text" lex="state" properties="none"/>
<column id="population" type="int" lex="large,big,people,citizens,residents,people stay,people reside,people live,residents live,size,citizens live,inhabitants,how many people live">
<max lex="most people,most population,biggest population,greatest population,most populous,most populated,biggest,most inhabitants,highest number of citizens,highest populations"/>
<min lex="smallest population,lowest population,least populous"/>
</column>
<foreign_key from="state" to="State" lex="located in,have,in,of,with"/>
<primary_value key="name"/><![CDATA[
SELECT city.state,
city.abbrev,
city.name,
city.population
FROM city
WHERE (EXISTS(SELECT state.name,
state.abbreviation,
state.capital,
state.population,
state.area,
state.number,
state.density
FROM state
WHERE state.capital =
city.name))
]]>
</view>
<cascade>
<response from="governor" to="there is no information on politicians"/>
<pre from="of the us" to=""/>
<pre from="name the" to="what"/>
<pre from="name all" to="what"/>
<pre from="state the" to="what"/>
<pre from="whats" to="what"/>
<pre from="major cities" to="cities population over 500000"/>
<pre from="big cities" to="cities"/>
<pre from="rivers in" to="rivers flowing through"/>
<pre from="river in" to="river flowing through"/>
<pre from="rivers are in" to="rivers flowing through"/>
<pre from="rivers are there" to="rivers flowing through"/>
<pre from="rivers does" to="rivers flowing through"/>
<pre from="do not have rivers" to="not flowing through rivers"/>
<pre from="has no rivers" to="not flowing through rivers"/>
<pre from="rivers of" to="rivers flowing through"/>
<pre from="have a river" to="rivers flowing through"/>
<pre from="with a river" to="rivers flowing through"/>
<pre from="have rivers" to="flowing through rivers"/>
<pre from="have rivers running through" to="rivers flowing through"/>
<pre from="continental" to=""/>
<pre from="american" to=""/>
<pre from="usa" to="states"/>
<pre from="us" to="states"/>
<pre from="united states" to="states"/>
<pre from="america" to="states"/>
<pre from="country" to="states"/>
<pre from="all the states" to="states"/>
<pre from="50 capitals" to="capitals"/>
<pre from="50 states" to="states"/>
<pre from="atlanta ga" to="atlanta georgia"/>
<pre from="sea level" to="elevation 0"/>
<pre from="lakes in" to="lakes within"/>
<pre from="lakes of" to="lakes within"/>
</cascade>
</config>