Values in map don't match values in Stats about nyc-crash-mapper HOT 2 CLOSED

--- filter where pedestrians_killed > 0
SELECT COUNT(c.cartodb_id) as total_crashes, 
SUM(CASE WHEN c.number_of_persons_injured > 0 THEN 1 ELSE 0 END) AS total_crashes_with_injury, 
SUM(CASE WHEN c.number_of_persons_killed > 0 THEN 1 ELSE 0 END) AS total_crashes_with_death, 
SUM(c.number_of_cyclist_injured) as cyclist_injured, 
SUM(c.number_of_cyclist_killed) as cyclist_killed, 
SUM(c.number_of_motorist_injured) as motorist_injured, 
SUM(c.number_of_motorist_killed) as motorist_killed, 
SUM(c.number_of_pedestrian_injured) as pedestrian_injured, 
SUM(c.number_of_pedestrian_killed) as pedestrian_killed, 
SUM(c.number_of_persons_injured) as persons_injured, 
SUM(c.number_of_persons_killed) as persons_killed 
FROM export2016_07 c  
WHERE (date_val <= date 'Aug 6, 2016') 
AND (date_val >= date 'Jul 1, 2016')  
AND ( number_of_pedestrian_killed > 0 )

--- filter where pedestrians > 0
SELECT c.the_geom, 
c.the_geom_webmercator, 
c.on_street_name, 
c.cross_street_name, 
COUNT(c.cartodb_id) as total_crashes, 
SUM(c.number_of_cyclist_injured) as cyclist_injured, 
SUM(c.number_of_cyclist_killed) as cyclist_killed, 
SUM(c.number_of_motorist_injured) as motorist_injured, 
SUM(c.number_of_motorist_killed) as motorist_killed, 
SUM(c.number_of_pedestrian_injured) as pedestrian_injured, 
SUM(c.number_of_pedestrian_killed) as pedestrian_killed, 
SUM(c.number_of_pedestrian_injured + c.number_of_cyclist_injured + c.number_of_motorist_injured) as persons_injured, 
SUM(c.number_of_pedestrian_killed + c.number_of_cyclist_killed + c.number_of_motorist_killed) as persons_killed 
FROM export2016_07 c  
WHERE (date_val <= date '2016-08-06') 
AND (date_val >= date '2016-07-01')  
AND ( number_of_pedestrian_killed > 0 )  
AND c.the_geom IS NOT NULL 
GROUP BY c.the_geom, c.the_geom_webmercator, c.on_street_name, c.cross_street_name