Monthly Surface Temperature By Country
@owid.surface_temperature
@owid.surface_temperature
ERA5 is the latest climate reanalysis produced by ECMWF, providing hourly data on many atmospheric, land-surface and sea-state parameters together with estimates of uncertainty.
ERA5 data are available in the Climate Data Store on regular latitude-longitude grids at 0.25° x 0.25° resolution, with atmospheric parameters on 37 pressure levels.
ERA5 is available from 1940 and continues to be extended forward in time, with daily updates being made available 5 days behind real time
Initial release data, i.e., data no more than three months behind real time, are called ERA5T.
CREATE TABLE owid_surface_temperature_1 (
"country" VARCHAR,
"time" TIMESTAMP,
"temperature_2m" FLOAT,
"temperature_anomaly" FLOAT,
"anomaly_below_0" FLOAT,
"anomaly_above_0" FLOAT
);CREATE TABLE owid_surface_temperature_2 (
"country" VARCHAR,
"time" TIMESTAMP,
"temperature_2m" FLOAT,
"temperature_anomaly" FLOAT,
"anomaly_below_0" FLOAT,
"anomaly_above_0" FLOAT
);Anyone who has the link will be able to view this.