A.R:B=Q
theodore_roosevelt.birth_country:usa=1
theodore_roosevelt.birth_state:new_york=1
theodore_roosevelt.birth_year:ad1858=1
theodore_roosevelt.child:alice_lee_roosevelt=1
theodore_roosevelt.child:and_quentin_roosevelt=1
theodore_roosevelt.child:ethel_roosevelt=1
theodore_roosevelt.child:kermit_roosevelt=1
theodore_roosevelt.child:theodore_roosevelt=1
theodore_roosevelt.college:harvard=1
theodore_roosevelt.death_year:ad1919=1
theodore_roosevelt.election_year:ad1904=1
theodore_roosevelt.occupation:author=1
theodore_roosevelt.occupation:congressman=1
theodore_roosevelt.occupation:military_officer=1
theodore_roosevelt.occupation:new_york_governor=1
theodore_roosevelt.party:republican=1
theodore_roosevelt.pres_order:first=26
theodore_roosevelt.spouse:alice_hathaway_lee_roosevelt=1
theodore_roosevelt.spouse:edith_kermit_carow=1
theodore_roosevelt.time_served:year=8
/* SQL */
SELECT * FROM meme WHERE aid='theodore_roosevelt' AND qnt!=0;
Example Queries (Help)
qry.all Show all data in this DB.
george_washington All about George Washington.
.child Who were children of the presidents?
:lawyer Which presidents were lawyers?
.college:harvard Which presidents attended Harvard for college?
.pres_order=10 Who was the tenth president?
.college:columbia .occupation:lawyer Which presidents attended Columbia and were lawyers?
.pres_order>=20 .pres_order<=30 Who were the twentieth through thirtieth presidents?
.pres_order .child=f Which presidents did NOT have children?
.pres_order>=20 .pres_order<=30 .spouse=g Who were the spouses of the twentieth through thirtieth presidents?
.college:harvard .college:columbia qry.all Use qry.all to return all memes related to the matching As.
james_carter; ronald_reagan Get all about James Carter as well as Ronald Reagan