Madison, WI weather in January 1977

Temperature for January 1977

In January 1977 the average high temperature in Madison, WI was 15.9°F, and this was 12.3°F cooler than the average of 28.2°F. The hottest day in January 1977 was 25 January when the temperature reached 28.9°F. Overnight the average temperature in January is 9.8°F and in 1977 the average overnight temperature was 17.6°F cooler at -7.8°F.

Precipitation for January 1977

In January the average monthly rainfall in Madison, WI is 1.33 inches with rain usually falling on 4 days. In January 1977 there was a total of 0.60 inches of rain, that fell on 2 days.

  BENCHMARKS  
Loading Time: Base Classes  0.0073
Controller Execution Time ( Climate / Summary )  0.0262
Total Execution Time  0.0336
  GET DATA  
No GET data exists
  MEMORY USAGE  
2,194,036 bytes
  POST DATA  
No POST data exists
  URI STRING  
climate/summary/united-states/wisconsin/dane-co-rgnl-truax-fld/january/1977
  CLASS/METHOD  
climate/summary
  DATABASE:  xrssweather0-climatespy   QUERIES: 6  (Hide)
0.0007   SELECT `locationId`, `cityName`, `urlName`, `urlState`, `stateName`, `stateCode`, `StationName`, `countryName`, `urlCountry`, `dd1`.`year` as earliestYear, `dd1`.`monthNo` as earliestMonth, `dd1`.`dayNo` as earliestDay, `dd2`.`year` as latestYear, `dd2`.`monthNo` as latestMonth, `dd2`.`dayNo` as latestDay
FROM 
(`dimLocation`)
JOIN `dimDatedd1 ON `dimLocation`.`beginDateId` = `dd1`.`dateId`
JOIN `dimDatedd2 ON `dimLocation`.`endDateId` = `dd2`.`dateId`
WHERE `urlState` =  'wisconsin'
AND `urlName` =  'dane-co-rgnl-truax-fld'
LIMIT 1 
0.0007   SELECT `monthNo`, AVG(`meanMinTemp`) AS meanMinTempAVG(`meanMaxTemp`) AS meanMaxTemp
FROM 
(`aggMonthly`)
WHERE `monthNo` =  1
AND `locationId` =  '4176'
GROUP BY `monthNo
0.0004   SELECT `monthNo`, AVG(`meanMinTemp`) AS meanMinTempAVG(`meanMaxTemp`) AS meanMaxTemp
FROM 
(`aggMonthly`)
WHERE `monthNo` =  1
AND `year` =  '1977'
AND `locationId` =  '4176'
GROUP BY `monthNo
0.0015   SELECT `maxTemp`, `monthName`, `dayNo`, `dimDate`.`year`, `dimLocation`.`locationId`, `dimLocation`.`countryName`, `dimLocation`.`stateName`, `dimLocation`.`presentationName`, `dimLocation`.`urlCountry`, `dimLocation`.`urlState`, `dimLocation`.`urlName`
FROM (`aggMonthly`)
JOIN `dimLocationON `dimLocation`.`locationId` = `aggMonthly`.`locationId`
JOIN `dimDateON `dimDate`.`dateId` = `aggMonthly`.`maxTempDate`
WHERE `aggMonthly`.`locationId` =  '4176'
AND `dimDate`.`monthNo` =  1
AND `dimDate`.`year` =  '1977'
ORDER BY `maxTempdesc
LIMIT 1 
0.0007   SELECT AVG(`sumRainfall`) AS sumRainfallAVG(`daysRainfall`) AS daysRainfallAVG(`daysSnow`) AS daysSnowAVG(`daysTornado`) AS daysTornadoAVG(`daysThunder`) AS daysThunder, `monthNo`
FROM (`aggMonthly`)
WHERE `monthNo` =  1
AND `locationId` =  '4176'
GROUP BY `monthNo
0.0004   SELECT AVG(`sumRainfall`) AS sumRainfallAVG(`daysRainfall`) AS daysRainfallAVG(`daysSnow`) AS daysSnowAVG(`daysTornado`) AS daysTornadoAVG(`daysThunder`) AS daysThunder, `monthNo`
FROM (`aggMonthly`)
WHERE `monthNo` =  1
AND `year` =  '1977'
AND `locationId` =  '4176'
GROUP BY `monthNo
  HTTP HEADERS  (Show)
  CONFIG VARIABLES  (Show)