Duplicate Same Table for Multiple locations
You are talking about less than 5 queries per second.  A well maintained database can handle 100 qps or more.

A poorly handled db will melt down even with 5 qps.

It is rarely a good idea to split a table artificially.

It is usually a good idea to normalize repeated data.  But don't normalize 'continuous' data, such as numbers, dates, floats, etc.

What will the SELECTs look like?  And SHOW CREATE TABLE.  Then we can discuss what indexes to have, and whether you have under/over-normalized, etc.