Help needed finding profiles before a certain date and place.

Question

I would like to find all profiles with a birth, marriage or death date before 11 Mar 1752 and born, married or died in Berks County, Pennsylvania.

What are the WikiTree+ search parameters that would find these profiles?

Answer 1

The closest I could narrow down by using these in "Search"
17cen "Berks, Pennsylvania"
18cen "Berks, Pennsylvania"

Comments

From the help page

• sql="([Default].[Birth Date].AsNumber > 19731231)" returns the profiles born after 31 dec 1973

So this search entered in the "Text" field narrows it down some more but does not take into account birth location being Berks County, Pennsylvania:

• Berks Pennsylvania sql="([Default].[Birth Date].AsNumber < 17520311)"

I think this is the correct query to find all profiles with a birth date before 11 Mar 1752 and born in Berks:

• Berks Pennsylvania sql="([Default].[Birth Date].AsNumber < 17520311) and ([Default].[Birth Location].AsString like '*Berks*')"