Protoball:AreaStats

Borough Games in Year Range

select Places.name borough, count(1) games
  from Ballgames join Places
 where MBRContains(area, coordinates_point)
   and level = 6
   and year(Ballgames.date) BETWEEN 1842 AND 1870
 group by Places.name

Result

borough	games
Kings County	764
Nassau County	1
New York County	752
Queens County	1113
Richmond County	2