ggplot - each axis different column of df

The typical way to refer to data frame columns in ggplot is by name. Let's say column 6 is named Year and column 7 is named Cases.

geom_point(data = diseases_california,mapping = aes(x = Year, y = Cases))

If something like that does not work, please post a reproducible example.