CREATE TABLE table_2267857_1 (report VARCHAR, date VARCHAR)

Name the total number for report july 23
SELECT COUNT(report) FROM table_2267857_1 WHERE date = "July 23"
SELECT COUNT("report") FROM "table_2267857_1" WHERE "July 23" = "date"