Tamaulipas state police said about 100 people were in the church at the time of the collapse