Home Page list
Births of children as facts #birth #child #events
The birth of a child is a major life event for a person so I thought it would be worth adding to the stream of events query for a person. This query is designed to be pasted into the AllFacts4Person5.sql file - it follows the same columnar format - or it can be run on its own. For some unknown reason, it was unnecessary to mess with INDEXED BY and NOT INDEXED clauses to get fast results so this query should run on all flavours of SQLite3.
Screen shot from SQLite Developer - note the filter drop-down list box on the Count column.