Yes those are raw daily means, but the monthly averages derived from them can be found in another part of the spreadsheet, they were averaged by EC and should all be within 0.1 rounded of what you would get from the work on those daily numbers. Also my tables for Toronto run top to bottom without a space for missing 29 Feb (the NYC tables have that feature) so that formulae for some columns would be different than others. Here's the grid references (range) for the monthly averages in the spreadsheet.
They are located in rows 1840 to 2021 to make it easier to figure out to which year the data belong. The columns in play are HW to II. That gives you Jan to Dec and annual means. Unfortunately I did not block the data to convert to one decimal for round numbers, e.g. you'll see April 1842 says 7 which is 7.0.
Let me know if you find this data section and have any questions. The website data are derived from their (EC) averages of monthly mean max and mean min rather than directly from averages of mean daily. It won't make much difference but some of these data would be 0.1 different from what you would get by taking the average of daily means. Once again, my table of daily means is derived from their conversions of the original F data whereas the tables above (the ones that are in F deg) are calculated by me from the entries in the original grids.
If you still wanted to average my data rather than using this table, be aware then that each column runs unbroken from 1 Jan to 31 Dec so that leap years will run from (a) days 1232-1260 for February and (b) days 1261-1291 for March compared to 1260-1290 for non-leap years (incl 1900), etc to end of columns.
My averages at the end of each row for dates have the formulae worked out for that. I suppose I should standardize this work with the NYC tables which I altered for missing leap year dates so that all similar dates of the year after Feb 28 are in the same row. Maybe the next version will have that built in. I'm nervous about throwing off formulae although they should convert along with the shifts.
Also minor point but the -7 and -3 for Jan and Feb 1840 are just rough guesses based on data from Providence RI, there was no weather station at Toronto until 1st of March 1840.
By the way, if you're transcribing these numbers into an excel file, then they also exist in print in the net-weather thread, in the second post of the thread.
You asked if they were raw data and the answer is yes, including those monthly means I mentioned.
For comparison with other data sets, I would recommend applying the urban heat island correction as follows: data 1840 to 1880 is okay as is. Data 1881 to 1890 reduce by 0.1 (to colder values), data 1891 to 1900 reduce 0.2, etc until you reach 1971 to 1980 which would reduce by 1.0 (C deg). After that 1981 to present all reduce by 1.1 C.
If it would save you some work, I could post an excel file of those conversions, that does not yet exist in the excel file but it does exist in print in the net-weather thread, this time on page two after the data on dry spells is tabulated (go to page two of the thread, second post).
If the purpose is to compare with CET or Irish data, I would prefer that these adjusted values would be compared, otherwise there will appear to be a spurious warming trend in the Toronto data over the 20th century into recent decades. If it's to compare with the re-analysis, I don't know what to recommend because I don't know if they factored into their numbers any result of the change in the environment from small city (in 1900) to metropolis (after 1960). By 1900 Toronto was already about a quarter million people with the weather station near the centre of the core, so an urban heat island would already be in place then. It would have grown approximately as suggested by my corrections thereafter. By about 1960 Toronto had surpassed two million population and had spread out a good 20-25 miles beyond its 1900 extent. Changes since then have been relatively minor with most of the growth out beyond the 1960 suburban belt, and tending to cluster rather than run out unbroken, due to greenbelt and river valley intrusions. So I don't think the urban heat island grew very much after about 1950-1960 and the data suggest that also. I used to run my own backyard weather station in a perfect spot for urban-rural comparisons (30 miles west of the downtown station) so I had about ten years of data for comparison, although the location where Toronto downtown is located would be a bit warmer than my location anyway due to lower elevation and closer proximity in winter to Lake Ontario. A sample of some very cold clear night readings would average about 6-8 F deg colder at the MTC-jr location. And that was in a small heat island of a smaller town, really rural settings might be another 4-6 F deg colder again. Most daytime readings were 1-2 deg lower there. However that was complicated by cooling lake breezes that would be just about extinct at my location inland, so some days in March to June in particular would run cooler in the city. It looked to me like that season extended into July more frequently in the 1840s and 1850s before there was any real urban development to weaken the lake breezes (and probably after some of those winters the lake was pretty cold into the middle of summer too).
Last edited by M.T. Cranium; 03-04-2021 at 21:44.