Overpass Turbo query: number of village halls in a given geographic area

otq_village_halls_in_an_area.query.txt

/*
number of village halls in a province
*/
[out:csv(::id,"name",::lat,::lon,::is_in;false)]
[timeout:60];
area["name"="Calabarzon"]->.territory;
way(area.territory)["townhall:type"="village"];
  foreach(
    node(w)->.n;
    .n is_in->.a;
    area.a[name][boundary=administrative][admin_level~"^[2-8]$"] -> .a;
    out center;
    convert way ::=::,
              ::id = id(),
              is_in=a.set("{" + t[admin_level] + ":" + t[name] + "}");

    out;
  );