Best MySQL schema for ZIP-code based weather prediction data?

[USASnow DayCalculator]

Hi everyone,

I’m working on a small project that predicts school closures based on
weather conditions (snowfall, temperature, alerts).

The system collects:
- ZIP code
- Hourly weather metrics
- Probability scores (0–100)
- Timestamped updates

I’m unsure whether a single table with indexed ZIP codes is enough,
or if partitioning by state/date would be better for performance.

Any advice on schema design or indexing strategies would be appreciated.
Thanks!