A detailed coastal water monitoring near Diu coast, western part of India was performed from October, 2020 to May, 2021 covering the 2nd lockdown time. Average monthly fluctuation from 7 different sampling stations of total 9 physico-chemical parameters such as pH, salinity, turbidity, nitrite (NO 2 ), nitrate (NO 3 ), ammonia (NH 3 ), phosphate (PO 4 ), total alkalinity and silicate were recorded. Initially, Mann-Kendall trend test for all the 9 parameters showed non-zero trend, which may be either linear or non-linear. During 2nd lockdown period, there was a fluctuation of value for parameters like pH, salinity, nitrate, nitrite and phosphate. Average total bacterial count and differential bacterial count also gradually decreased from March, 2021 sampling. Principal component analysis (PCA) plot covering all the physico-chemical parameters as well as the differential bacterial count showed a distinct cluster of all bacterial count with total alkalinity value. Subsequently, mathematical equation was formulated between total alkalinity value and all differential bacterial count. Upto our knowledge, this is the first report where mathematical equation was formulated to obtain value of different bacterial load based on the derived total alkalinity value of the coastal water samples near Diu, India.