O tempo em Northumberland

200

INSERT INTO w_hours_15 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '148856', '2024-06-15', '00:00:00', '16.5', '12.7', '78.45', '0', '0', '0', '2.1', '356', '1012.4', '95.4', '16', '0', 'cloudy' ),( '148856', '2024-06-15', '01:00:00', '15.3', '11.5', '78.26', '0', '0', '0', '2.9', '360', '1012.1', '0', '16', '0', 'clear-night' ),( '148856', '2024-06-15', '02:00:00', '14.3', '10.5', '77.78', '0', '0', '0', '6.2', '331', '1012.3', '0', '16', '0', 'clear-night' ),( '148856', '2024-06-15', '03:00:00', '13.1', '9.4', '78.31', '0', '0', '0', '5.6', '352', '1012.8', '33.7', '16', '0', 'partly-cloudy-night' ),( '148856', '2024-06-15', '04:00:00', '12.6', '8.8', '77.77', '0', '0', '0', '4.3', '360', '1013.2', '0', '16', '0', 'clear-night' ),( '148856', '2024-06-15', '05:00:00', '11.5', '8', '79.31', '0', '0', '0', '0', '0', '1014.3', '61.8', '16', '0', 'partly-cloudy-night' ),( '148856', '2024-06-15', '06:00:00', '11.8', '7.5', '74.51', '0', '0', '0', '9', '346', '1014.9', '73.5', '16', '0', 'partly-cloudy-day' ),( '148856', '2024-06-15', '07:00:00', '13.2', '7.6', '68.63', '0', '0', '0', '11', '352', '1015.5', '61.8', '16', '0', 'partly-cloudy-day' ),( '148856', '2024-06-15', '08:00:00', '14.1', '7', '62.49', '0', '0', '0', '6.3', '356', '1016', '0', '16', '2', 'clear-day' ),( '148856', '2024-06-15', '09:00:00', '15', '5.7', '53.74', '0', '0', '0', '15', '342', '1016.6', '25', '16', '4', 'partly-cloudy-day' ),( '148856', '2024-06-15', '10:00:00', '15.6', '5.3', '50.03', '0', '0', '0', '18.1', '352', '1016.6', '73.5', '16', '7', 'partly-cloudy-day' ),( '148856', '2024-06-15', '11:00:00', '16.3', '5', '47.09', '0', '0', '0', '17', '346', '1016.5', '64.5', '16', '6', 'partly-cloudy-day' ),( '148856', '2024-06-15', '12:00:00', '17', '4.2', '42.47', '0', '0', '0', '23', '334', '1016.5', '30.9', '16', '9', 'partly-cloudy-day' ),( '148856', '2024-06-15', '13:00:00', '18.1', '4.3', '40.06', '0', '0', '0', '19.5', '318', '1016.8', '15.4', '16', '8', 'clear-day' ),( '148856', '2024-06-15', '14:00:00', '18.2', '4.2', '39.39', '0', '0', '0', '23', '324', '1016.7', '0', '16', '9', 'clear-day' ),( '148856', '2024-06-15', '15:00:00', '17.7', '4.1', '40.4', '0', '0', '0', '19.7', '328', '1017', '40.4', '16', '9', 'partly-cloudy-day' ),( '148856', '2024-06-15', '16:00:00', '18.1', '4.2', '39.75', '0', '0', '0', '18.4', '321', '1017.1', '15.4', '16', '7', 'clear-day' ),( '148856', '2024-06-15', '17:00:00', '18.4', '4', '38.59', '0', '0', '0', '15', '334', '1017.4', '0', '16', '5', 'clear-day' ),( '148856', '2024-06-15', '18:00:00', '17.8', '3.9', '39.66', '0', '0', '0', '14.8', '320', '1018', '6', '16.2', '4', 'clear-day' ),( '148856', '2024-06-15', '19:00:00', '16.7', '4.5', '44.35', '0', '0', '0', '11.2', '320', '1018', '8', '16.2', '3', 'clear-day' ),( '148856', '2024-06-15', '20:00:00', '15', '3.9', '47.4', '0', '0', '0', '7.6', '320', '1019', '8', '16.2', '1', 'clear-day' ),( '148856', '2024-06-15', '21:00:00', '12.8', '4.5', '57.03', '0', '0', '0', '5.4', '330', '1019', '7', '16.2', '0', 'clear-night' ),( '148856', '2024-06-15', '22:00:00', '10.6', '4.5', '65.95', '0', '0', '0', '3.6', '350', '1020', '5', '16.2', '0', 'clear-night' ),( '148856', '2024-06-15', '23:00:00', '8.9', '4.5', '73.91', '0', '0', '0', '3.6', '10', '1020', '3', '16.2', '0', 'clear-night' ) ON DUPLICATE KEY UPDATE temp = VALUES(temp), dew = VALUES(dew), humidity = VALUES(humidity), precip = VALUES(precip), precipprob = VALUES(precipprob), snow = VALUES(snow), windspeed = VALUES(windspeed), winddir = VALUES(winddir), pressure = VALUES(pressure), cloudcover = VALUES(cloudcover), visibility = VALUES(visibility), uvindex = VALUES(uvindex), icon = VALUES(icon)

INSERT INTO w_hours_16 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '148856', '2024-06-16', '00:00:00', '7.3', '3.9', '79', '0', '0', '0', '1.8', '320', '1020', '2', '16.2', '0', 'clear-night' ),( '148856', '2024-06-16', '01:00:00', '6.7', '3.4', '79.47', '0', '0', '0', '1.8', '240', '1021', '2', '16.2', '0', 'clear-night' ),( '148856', '2024-06-16', '02:00:00', '5.6', '2.8', '82.18', '0', '0', '0', '1.8', '200', '1022', '2', '16.2', '0', 'clear-night' ),( '148856', '2024-06-16', '03:00:00', '4.5', '2.8', '88.72', '0', '0', '0', '1.8', '200', '1022', '2', '16.2', '0', 'clear-night' ),( '148856', '2024-06-16', '04:00:00', '3.9', '2.3', '89.3', '0', '0', '0', '1.8', '210', '1022', '4', '16.2', '0', 'clear-night' ),( '148856', '2024-06-16', '05:00:00', '3.4', '1.7', '88.62', '0', '0', '0', '1.8', '210', '1023', '10', '16.2', '0', 'clear-night' ),( '148856', '2024-06-16', '06:00:00', '3.9', '2.8', '92.53', '0', '0', '0', '1.8', '220', '1023', '12', '16.2', '1', 'clear-day' ),( '148856', '2024-06-16', '07:00:00', '7.3', '3.9', '79', '0', '0', '0', '1.8', '240', '1023', '8', '16.2', '2', 'clear-day' ),( '148856', '2024-06-16', '08:00:00', '11.2', '5.6', '68.41', '0', '0', '0', '1.8', '250', '1025', '10', '16.2', '4', 'clear-day' ),( '148856', '2024-06-16', '09:00:00', '13.4', '5.6', '59.2', '0', '0', '0', '1.8', '260', '1025', '11', '16.2', '6', 'clear-day' ),( '148856', '2024-06-16', '10:00:00', '15.6', '5.6', '51.36', '0', '0', '0', '1.8', '300', '1025', '12', '16.2', '8', 'clear-day' ),( '148856', '2024-06-16', '11:00:00', '17.3', '5', '44.21', '0', '0', '0', '3.6', '320', '1025', '20', '16.2', '8', 'clear-day' ),( '148856', '2024-06-16', '12:00:00', '19.5', '5.6', '40.15', '0', '0', '0', '3.6', '300', '1024', '25', '16.3', '9', 'partly-cloudy-day' ),( '148856', '2024-06-16', '13:00:00', '20', '5.6', '38.93', '0', '0', '0', '3.6', '280', '1024', '30', '16.3', '9', 'partly-cloudy-day' ),( '148856', '2024-06-16', '14:00:00', '21.2', '5.6', '36.15', '0', '0', '0', '5.4', '270', '1023', '36', '16.3', '9', 'partly-cloudy-day' ),( '148856', '2024-06-16', '15:00:00', '22.3', '6.2', '35.23', '0', '0', '0', '5.4', '260', '1023', '40', '16.3', '8', 'partly-cloudy-day' ),( '148856', '2024-06-16', '16:00:00', '22.3', '6.2', '35.23', '0', '0', '0', '5.4', '250', '1023', '45', '16.3', '7', 'partly-cloudy-day' ),( '148856', '2024-06-16', '17:00:00', '22.8', '6.2', '34.18', '0', '0', '0', '5.4', '240', '1022', '50', '16.3', '5', 'partly-cloudy-day' ),( '148856', '2024-06-16', '18:00:00', '21.2', '6.7', '39', '0', '0', '0', '5.4', '220', '1022', '46', '16.3', '4', 'partly-cloudy-day' ),( '148856', '2024-06-16', '19:00:00', '19.5', '7.8', '46.7', '0', '0', '0', '3.6', '200', '1022', '42', '16.3', '3', 'partly-cloudy-day' ),( '148856', '2024-06-16', '20:00:00', '18.4', '7.8', '50.02', '0', '0', '0', '3.6', '180', '1022', '37', '16.3', '1', 'partly-cloudy-day' ),( '148856', '2024-06-16', '21:00:00', '16.7', '7.3', '53.82', '0', '0', '0', '3.6', '180', '1022', '43', '16.3', '0', 'partly-cloudy-night' ),( '148856', '2024-06-16', '22:00:00', '15', '7.3', '60', '0', '0', '0', '3.6', '160', '1022', '48', '16.3', '0', 'partly-cloudy-night' ),( '148856', '2024-06-16', '23:00:00', '13.9', '6.7', '61.83', '0', '0', '0', '3.6', '160', '1022', '54', '16.3', '0', 'partly-cloudy-night' ) ON DUPLICATE KEY UPDATE temp = VALUES(temp), dew = VALUES(dew), humidity = VALUES(humidity), precip = VALUES(precip), precipprob = VALUES(precipprob), snow = VALUES(snow), windspeed = VALUES(windspeed), winddir = VALUES(winddir), pressure = VALUES(pressure), cloudcover = VALUES(cloudcover), visibility = VALUES(visibility), uvindex = VALUES(uvindex), icon = VALUES(icon)

INSERT INTO w_hours_17 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '148856', '2024-06-17', '00:00:00', '13.4', '7.3', '66.55', '0', '0', '0', '3.6', '160', '1022', '60', '15.2', '0', 'partly-cloudy-night' ),( '148856', '2024-06-17', '01:00:00', '12.8', '7.3', '69.21', '0', '0', '0', '3.6', '160', '1022', '67', '14.2', '0', 'partly-cloudy-night' ),( '148856', '2024-06-17', '02:00:00', '12.8', '7.3', '69.21', '0', '3', '0', '3.6', '160', '1022', '73', '13.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-17', '03:00:00', '12.3', '7.3', '71.52', '0', '4', '0', '3.6', '160', '1022', '76', '13.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-17', '04:00:00', '12.3', '7.6', '73', '0', '8', '0', '3.6', '160', '1022', '79', '13.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-17', '05:00:00', '12.3', '7.8', '74', '0', '8', '0', '3.6', '160', '1023', '82', '13.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-17', '06:00:00', '13.6', '8.9', '73.23', '0', '23', '0', '2.9', '160', '1022', '84.7', '13.1', '1', 'partly-cloudy-day' ),( '148856', '2024-06-17', '07:00:00', '14.9', '10.1', '72.98', '0', '23', '0', '2.5', '160', '1022', '87.3', '13.1', '1', 'partly-cloudy-day' ),( '148856', '2024-06-17', '08:00:00', '16.2', '11.2', '72.25', '0', '23', '0', '1.8', '160', '1021', '90', '13.1', '2', 'partly-cloudy-day' ),( '148856', '2024-06-17', '09:00:00', '18.2', '11.9', '66.67', '0', '23', '0', '2.5', '170', '1021', '84', '13', '2', 'partly-cloudy-day' ),( '148856', '2024-06-17', '10:00:00', '20.3', '12.7', '61.66', '0', '23', '0', '2.9', '180', '1020', '78', '12.9', '2', 'partly-cloudy-day' ),( '148856', '2024-06-17', '11:00:00', '22.3', '13.4', '57.09', '0', '23', '0', '3.6', '190', '1019', '72', '12.8', '2', 'partly-cloudy-day' ),( '148856', '2024-06-17', '12:00:00', '23.2', '13.8', '55.48', '0', '17', '0', '5', '196.7', '1018', '71', '12.9', '3', 'partly-cloudy-day' ),( '148856', '2024-06-17', '13:00:00', '24.1', '14.1', '53.59', '0', '17', '0', '6.1', '203.3', '1018', '70', '13', '4', 'partly-cloudy-day' ),( '148856', '2024-06-17', '14:00:00', '25', '14.5', '52.11', '0.3', '17', '0', '7.6', '210', '1017', '69', '13.1', '5', 'partly-cloudy-day' ),( '148856', '2024-06-17', '15:00:00', '25.6', '14.9', '51.6', '0', '17', '0', '7.6', '210', '1017', '66', '13.1', '4', 'partly-cloudy-day' ),( '148856', '2024-06-17', '16:00:00', '26.1', '15.2', '51.07', '0', '17', '0', '7.6', '210', '1016', '63', '13.1', '3', 'partly-cloudy-day' ),( '148856', '2024-06-17', '17:00:00', '26.7', '15.6', '50.57', '0', '17', '0', '7.6', '210', '1016', '60', '13.1', '3', 'partly-cloudy-day' ),( '148856', '2024-06-17', '18:00:00', '25.4', '16.2', '56.75', '0', '3', '0', '6.1', '206.7', '1016', '54.3', '13.1', '2', 'partly-cloudy-day' ),( '148856', '2024-06-17', '19:00:00', '24.1', '16.7', '63.32', '0', '3', '0', '5', '203.3', '1016', '48.7', '13.1', '1', 'partly-cloudy-day' ),( '148856', '2024-06-17', '20:00:00', '22.8', '17.3', '71.14', '0', '3', '0', '3.6', '200', '1017', '43', '13.1', '1', 'partly-cloudy-day' ),( '148856', '2024-06-17', '21:00:00', '21.7', '18', '79.5', '0', '11', '0', '2.5', '210', '1018', '41', '13.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-17', '22:00:00', '20.4', '17.6', '83.97', '0', '11', '0', '1.8', '210', '1019', '35', '13.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-17', '23:00:00', '19', '17.3', '89.87', '0', '11', '0', '1.4', '210', '1019', '29', '13.1', '0', 'partly-cloudy-night' ) ON DUPLICATE KEY UPDATE temp = VALUES(temp), dew = VALUES(dew), humidity = VALUES(humidity), precip = VALUES(precip), precipprob = VALUES(precipprob), snow = VALUES(snow), windspeed = VALUES(windspeed), winddir = VALUES(winddir), pressure = VALUES(pressure), cloudcover = VALUES(cloudcover), visibility = VALUES(visibility), uvindex = VALUES(uvindex), icon = VALUES(icon)

INSERT INTO w_hours_18 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '148856', '2024-06-18', '00:00:00', '18.4', '17.1', '92.14', '0', '11', '0', '1.4', '213.3', '1019', '32', '11.2', '0', 'partly-cloudy-night' ),( '148856', '2024-06-18', '01:00:00', '17.9', '16.8', '93.28', '0', '11', '0', '1.4', '216.7', '1020', '35', '9.3', '0', 'partly-cloudy-night' ),( '148856', '2024-06-18', '02:00:00', '17.3', '16.6', '95.66', '0', '11', '0', '1.4', '220', '1020', '38', '7.4', '0', 'partly-cloudy-night' ),( '148856', '2024-06-18', '03:00:00', '17.1', '16.5', '96.26', '0', '3', '0', '1.1', '220', '1020', '42.3', '6', '0', 'partly-cloudy-night' ),( '148856', '2024-06-18', '04:00:00', '16.9', '16.4', '96.87', '0', '3', '0', '0.4', '220', '1021', '46.7', '4.6', '0', 'partly-cloudy-night' ),( '148856', '2024-06-18', '05:00:00', '16.7', '16.3', '97.49', '0', '3', '0', '0', '220', '1021', '51', '3.2', '0', 'partly-cloudy-night' ),( '148856', '2024-06-18', '06:00:00', '18.3', '17.2', '93.3', '0', '3', '0', '0', '223.3', '1021', '52', '6.4', '0', 'partly-cloudy-day' ),( '148856', '2024-06-18', '07:00:00', '19.9', '18.2', '89.94', '0', '3', '0', '0', '226.7', '1021', '53', '9.7', '1', 'partly-cloudy-day' ),( '148856', '2024-06-18', '08:00:00', '21.5', '19.1', '86.22', '0', '3', '0', '0', '230', '1021', '54', '12.9', '1', 'partly-cloudy-day' ),( '148856', '2024-06-18', '09:00:00', '23.9', '19.7', '77.37', '0', '2', '0', '0.4', '233.3', '1021', '50.7', '12.9', '3', 'partly-cloudy-day' ),( '148856', '2024-06-18', '10:00:00', '26.2', '20.2', '69.57', '0', '2', '0', '1.1', '236.7', '1021', '47.3', '12.9', '5', 'partly-cloudy-day' ),( '148856', '2024-06-18', '11:00:00', '28.6', '20.8', '62.73', '0', '2', '0', '1.4', '240', '1021', '44', '12.9', '6', 'partly-cloudy-day' ),( '148856', '2024-06-18', '12:00:00', '29.9', '20.7', '57.83', '0', '2', '0', '2.5', '243.3', '1021', '45', '13', '7', 'partly-cloudy-day' ),( '148856', '2024-06-18', '13:00:00', '31.3', '20.5', '52.72', '0', '2', '0', '3.2', '246.7', '1020', '46', '13', '7', 'partly-cloudy-day' ),( '148856', '2024-06-18', '14:00:00', '32.6', '20.4', '48.68', '0', '2', '0', '4.3', '250', '1020', '47', '24.1', '8', 'partly-cloudy-day' ),( '148856', '2024-06-18', '15:00:00', '32.6', '20.3', '48.38', '0', '6', '0', '4.3', '246.7', '1020', '43.3', '24.1', '8', 'partly-cloudy-day' ),( '148856', '2024-06-18', '16:00:00', '32.5', '20.2', '48.35', '0', '6', '0', '4.7', '243.3', '1020', '39.7', '24.1', '7', 'partly-cloudy-day' ),( '148856', '2024-06-18', '17:00:00', '32.5', '20.1', '48.05', '0', '6', '0', '4.7', '240', '1020', '36', '24.1', '7', 'partly-cloudy-day' ),( '148856', '2024-06-18', '18:00:00', '31.1', '20.9', '54.66', '0', '6', '0', '3.6', '226.7', '1020', '36.3', '24.1', '6', 'partly-cloudy-day' ),( '148856', '2024-06-18', '19:00:00', '29.7', '21.6', '61.82', '0', '6', '0', '2.5', '213.3', '1020', '36.7', '24.1', '5', 'partly-cloudy-day' ),( '148856', '2024-06-18', '20:00:00', '28.3', '22.4', '70.4', '0', '6', '0', '1.4', '200', '1020', '37', '24.1', '4', 'partly-cloudy-day' ),( '148856', '2024-06-18', '21:00:00', '26.5', '21.9', '75.88', '0', '9', '0', '1.1', '186.7', '1022', '31', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-18', '22:00:00', '24.6', '21.4', '82.39', '0', '9', '0', '0.4', '173.3', '1022', '25', '11.3', '0', 'partly-cloudy-night' ),( '148856', '2024-06-18', '23:00:00', '22.8', '20.9', '89.04', '0', '9', '0', '0', '160', '1022', '19', '24.1', '0', 'clear-night' ) ON DUPLICATE KEY UPDATE temp = VALUES(temp), dew = VALUES(dew), humidity = VALUES(humidity), precip = VALUES(precip), precipprob = VALUES(precipprob), snow = VALUES(snow), windspeed = VALUES(windspeed), winddir = VALUES(winddir), pressure = VALUES(pressure), cloudcover = VALUES(cloudcover), visibility = VALUES(visibility), uvindex = VALUES(uvindex), icon = VALUES(icon)

INSERT INTO w_hours_19 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '148856', '2024-06-19', '00:00:00', '22', '20.5', '91.21', '0', '9', '0', '0', '166.7', '1022', '23.3', '16.7', '0', 'partly-cloudy-night' ),( '148856', '2024-06-19', '01:00:00', '21.3', '20', '92.3', '0', '9', '0', '0', '173.3', '1022', '27.7', '21.4', '0', 'partly-cloudy-night' ),( '148856', '2024-06-19', '02:00:00', '20.5', '19.6', '94.58', '0', '9', '0', '0', '180', '1023', '32', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-19', '03:00:00', '20.1', '19.3', '95.16', '0', '7', '0', '0', '183.3', '1023', '37.7', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-19', '04:00:00', '19.8', '19.1', '95.74', '0', '7', '0', '0', '186.7', '1023', '43.3', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-19', '05:00:00', '19.4', '18.8', '96.33', '0', '7', '0', '0', '190', '1023', '49', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-19', '06:00:00', '21', '19.7', '92.28', '0', '7', '0', '0', '196.7', '1024', '44.3', '24.1', '0', 'partly-cloudy-day' ),( '148856', '2024-06-19', '07:00:00', '22.5', '20.5', '88.47', '0', '7', '0', '0', '203.3', '1024', '39.7', '24.1', '1', 'partly-cloudy-day' ),( '148856', '2024-06-19', '08:00:00', '24.1', '21.4', '84.89', '0', '7', '0', '0', '210', '1024', '35', '24.1', '1', 'partly-cloudy-day' ),( '148856', '2024-06-19', '09:00:00', '26.3', '21.4', '74.47', '0', '5', '0', '0.4', '223.3', '1024', '33.3', '24.1', '3', 'partly-cloudy-day' ),( '148856', '2024-06-19', '10:00:00', '28.6', '21.5', '65.48', '0', '5', '0', '1.1', '236.7', '1024', '31.7', '24.1', '4', 'partly-cloudy-day' ),( '148856', '2024-06-19', '11:00:00', '30.8', '21.5', '57.69', '0', '5', '0', '1.4', '250', '1023', '30', '24.1', '6', 'partly-cloudy-day' ),( '148856', '2024-06-19', '12:00:00', '31.7', '21', '53.15', '0', '5', '0', '2.5', '250', '1023', '37.3', '24.1', '6', 'partly-cloudy-day' ),( '148856', '2024-06-19', '13:00:00', '32.7', '20.5', '48.7', '0', '5', '0', '3.6', '250', '1023', '44.7', '24.1', '7', 'partly-cloudy-day' ),( '148856', '2024-06-19', '14:00:00', '33.6', '20', '44.89', '0', '5', '0', '4.7', '250', '1022', '52', '24.1', '7', 'partly-cloudy-day' ),( '148856', '2024-06-19', '15:00:00', '33.4', '20', '45.4', '0', '15', '0', '4.7', '250', '1021', '54.7', '24.1', '7', 'partly-cloudy-day' ),( '148856', '2024-06-19', '16:00:00', '33.2', '20.1', '46.2', '0', '15', '0', '4.7', '250', '1021', '57.3', '24.1', '7', 'partly-cloudy-day' ),( '148856', '2024-06-19', '17:00:00', '33', '20.1', '46.72', '0', '15', '0', '4.7', '250', '1021', '60', '24.1', '7', 'partly-cloudy-day' ),( '148856', '2024-06-19', '18:00:00', '31.4', '20.9', '53.73', '0', '15', '0', '3.6', '240', '1021', '60.7', '24.1', '6', 'partly-cloudy-day' ),( '148856', '2024-06-19', '19:00:00', '29.8', '21.6', '61.47', '0', '15', '0', '2.5', '230', '1021', '61.3', '13.8', '5', 'partly-cloudy-day' ),( '148856', '2024-06-19', '20:00:00', '28.2', '22.4', '70.81', '0.5', '15', '0', '1.4', '220', '1022', '62', '24.1', '4', 'partly-cloudy-day' ),( '148856', '2024-06-19', '21:00:00', '26.7', '22', '75.45', '0', '17', '0', '1.1', '220', '1022', '61', '16.8', '0', 'partly-cloudy-night' ),( '148856', '2024-06-19', '22:00:00', '25.3', '21.7', '80.48', '0', '17', '0', '0.4', '220', '1022', '60', '16.8', '0', 'partly-cloudy-night' ),( '148856', '2024-06-19', '23:00:00', '23.8', '21.3', '85.91', '0', '17', '0', '0', '220', '1023', '59', '24.1', '0', 'partly-cloudy-night' ) ON DUPLICATE KEY UPDATE temp = VALUES(temp), dew = VALUES(dew), humidity = VALUES(humidity), precip = VALUES(precip), precipprob = VALUES(precipprob), snow = VALUES(snow), windspeed = VALUES(windspeed), winddir = VALUES(winddir), pressure = VALUES(pressure), cloudcover = VALUES(cloudcover), visibility = VALUES(visibility), uvindex = VALUES(uvindex), icon = VALUES(icon)

INSERT INTO w_hours_20 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '148856', '2024-06-20', '00:00:00', '23.2', '21', '87.45', '0', '17', '0', '0', '223.3', '1022', '59.7', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-20', '01:00:00', '22.5', '20.6', '89.02', '0', '17', '0', '0', '226.7', '1022', '60.3', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-20', '02:00:00', '21.9', '20.3', '90.64', '0', '17', '0', '0', '230', '1022', '61', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-20', '03:00:00', '21.5', '20.1', '91.74', '0', '9', '0', '0', '226.7', '1022', '62.3', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-20', '04:00:00', '21.1', '19.8', '92.29', '0', '9', '0', '0', '223.3', '1022', '63.7', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-20', '05:00:00', '20.7', '19.6', '93.42', '0', '9', '0', '0', '220', '1022', '65', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-20', '06:00:00', '21.8', '20.3', '91.2', '0', '9', '0', '0.4', '223.3', '1022', '64.7', '24.1', '0', 'partly-cloudy-day' ),( '148856', '2024-06-20', '07:00:00', '22.9', '21', '89.05', '0', '9', '0', '1.1', '226.7', '1022', '64.3', '24.1', '0', 'partly-cloudy-day' ),( '148856', '2024-06-20', '08:00:00', '24', '21.7', '86.99', '0', '9', '0', '1.4', '230', '1022', '64', '24.1', '1', 'partly-cloudy-day' ),( '148856', '2024-06-20', '09:00:00', '25.8', '21.5', '77.18', '0', '13', '0', '2.5', '243.3', '1022', '59.3', '24.1', '2', 'partly-cloudy-day' ),( '148856', '2024-06-20', '10:00:00', '27.7', '21.3', '68.17', '0', '13', '0', '3.2', '256.7', '1021', '54.7', '24.1', '4', 'partly-cloudy-day' ),( '148856', '2024-06-20', '11:00:00', '29.5', '21.1', '60.65', '0', '13', '0', '4.3', '270', '1021', '50', '24.1', '6', 'partly-cloudy-day' ),( '148856', '2024-06-20', '12:00:00', '30.4', '20.6', '55.85', '0', '13', '0', '5.4', '270', '1021', '49.3', '24.1', '6', 'partly-cloudy-day' ),( '148856', '2024-06-20', '13:00:00', '31.3', '20.2', '51.76', '0', '13', '0', '6.5', '270', '1020', '48.7', '24.1', '6', 'partly-cloudy-day' ),( '148856', '2024-06-20', '14:00:00', '32.2', '19.7', '47.68', '0', '13', '0', '7.6', '270', '1020', '48', '24.1', '7', 'partly-cloudy-day' ),( '148856', '2024-06-20', '15:00:00', '31.8', '19.7', '48.77', '0', '31', '0', '7.6', '273.3', '1020', '49', '24.1', '6', 'partly-cloudy-day' ),( '148856', '2024-06-20', '16:00:00', '31.3', '19.6', '49.87', '0', '31', '0', '7.6', '276.7', '1019', '50', '24.1', '5', 'partly-cloudy-day' ),( '148856', '2024-06-20', '17:00:00', '30.9', '19.6', '51.02', '0.3', '31', '0', '7.6', '280', '1019', '51', '24.1', '5', 'partly-cloudy-day' ),( '148856', '2024-06-20', '18:00:00', '29.3', '20.1', '57.69', '0', '31', '0', '6.1', '276.7', '1020', '52.7', '24.1', '4', 'partly-cloudy-day' ),( '148856', '2024-06-20', '19:00:00', '27.7', '20.5', '64.89', '0', '31', '0', '4.3', '273.3', '1020', '54.3', '24.1', '4', 'partly-cloudy-day' ),( '148856', '2024-06-20', '20:00:00', '26.1', '21', '73.53', '0', '31', '0', '2.9', '270', '1021', '56', '24.1', '3', 'partly-cloudy-day' ),( '148856', '2024-06-20', '21:00:00', '24.8', '20.8', '78.46', '0', '35', '0', '2.5', '263.3', '1022', '56', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-20', '22:00:00', '23.5', '20.5', '83.28', '0', '35', '0', '1.8', '256.7', '1022', '56', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-20', '23:00:00', '22.2', '20.3', '89', '0.3', '35', '0', '1.4', '250', '1023', '56', '24.1', '0', 'partly-cloudy-night' ) ON DUPLICATE KEY UPDATE temp = VALUES(temp), dew = VALUES(dew), humidity = VALUES(humidity), precip = VALUES(precip), precipprob = VALUES(precipprob), snow = VALUES(snow), windspeed = VALUES(windspeed), winddir = VALUES(winddir), pressure = VALUES(pressure), cloudcover = VALUES(cloudcover), visibility = VALUES(visibility), uvindex = VALUES(uvindex), icon = VALUES(icon)

INSERT INTO w_hours_21 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '148856', '2024-06-21', '00:00:00', '21.6', '19.9', '90.06', '0', '35', '0', '1.4', '250', '1023', '58.7', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-21', '01:00:00', '20.9', '19.4', '91.14', '0', '35', '0', '1.4', '250', '1022', '61.3', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-21', '02:00:00', '20.3', '19', '92.24', '0', '35', '0', '1.4', '250', '1022', '64', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-21', '03:00:00', '19.9', '18.8', '93.38', '0', '22', '0', '1.4', '253.3', '1022', '67.3', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-21', '04:00:00', '19.5', '18.5', '93.95', '0', '22', '0', '1.4', '256.7', '1023', '70.7', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-21', '05:00:00', '19.1', '18.3', '95.12', '0', '22', '0', '1.4', '260', '1023', '74', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-21', '06:00:00', '19.9', '18.9', '93.97', '0', '22', '0', '1.4', '270', '1023', '73.3', '24.1', '0', 'partly-cloudy-day' ),( '148856', '2024-06-21', '07:00:00', '20.7', '19.5', '92.84', '0', '22', '0', '1.4', '280', '1024', '72.7', '24.1', '1', 'partly-cloudy-day' ),( '148856', '2024-06-21', '08:00:00', '21.5', '20.1', '91.74', '0', '22', '0', '1.4', '290', '1024', '72', '24.1', '1', 'partly-cloudy-day' ),( '148856', '2024-06-21', '09:00:00', '23.1', '19.9', '82.21', '0', '32', '0', '1.8', '290', '1024', '67.3', '24.1', '3', 'partly-cloudy-day' ),( '148856', '2024-06-21', '10:00:00', '24.6', '19.6', '73.73', '0', '32', '0', '2.5', '290', '1024', '62.7', '24.1', '5', 'partly-cloudy-day' ),( '148856', '2024-06-21', '11:00:00', '26.2', '19.4', '66.21', '0.3', '32', '0', '2.9', '290', '1024', '58', '24.1', '7', 'partly-cloudy-day' ),( '148856', '2024-06-21', '12:00:00', '27', '18.9', '61.22', '0', '32', '0', '4', '293.3', '1024', '56', '24.1', '7', 'partly-cloudy-day' ),( '148856', '2024-06-21', '13:00:00', '27.8', '18.5', '56.97', '0', '32', '0', '5', '296.7', '1023', '54', '24.1', '8', 'partly-cloudy-day' ),( '148856', '2024-06-21', '14:00:00', '28.6', '18', '52.7', '0.6', '32', '0', '6.1', '300', '1023', '52', '24.1', '8', 'partly-cloudy-day' ),( '148856', '2024-06-21', '15:00:00', '28.4', '17.8', '52.65', '0', '44', '0', '6.1', '300', '1023', '54.3', '24.1', '8', 'partly-cloudy-day' ),( '148856', '2024-06-21', '16:00:00', '28.1', '17.6', '52.9', '0', '44', '0', '6.1', '300', '1022', '56.7', '24.1', '8', 'partly-cloudy-day' ),( '148856', '2024-06-21', '17:00:00', '27.9', '17.4', '52.85', '0.3', '44', '0', '6.1', '300', '1022', '59', '24.1', '8', 'partly-cloudy-day' ),( '148856', '2024-06-21', '18:00:00', '26.6', '17.8', '58.5', '0', '44', '0', '5', '303.3', '1023', '59.3', '24.1', '7', 'partly-cloudy-day' ),( '148856', '2024-06-21', '19:00:00', '25.2', '18.3', '65.59', '0', '44', '0', '4', '306.7', '1023', '59.7', '24.1', '6', 'partly-cloudy-day' ),( '148856', '2024-06-21', '20:00:00', '23.9', '18.7', '72.69', '0', '44', '0', '2.9', '310', '1024', '60', '24.1', '5', 'partly-cloudy-day' ),( '148856', '2024-06-21', '21:00:00', '22.5', '18.3', '77.16', '0', '40', '0', '2.5', '316.7', '1024', '58.7', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-21', '22:00:00', '21.1', '18', '82.48', '0', '40', '0', '1.8', '323.3', '1024', '57.3', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-21', '23:00:00', '19.7', '17.6', '87.69', '0.3', '40', '0', '1.4', '330', '1024', '56', '24.1', '0', 'partly-cloudy-night' ) ON DUPLICATE KEY UPDATE temp = VALUES(temp), dew = VALUES(dew), humidity = VALUES(humidity), precip = VALUES(precip), precipprob = VALUES(precipprob), snow = VALUES(snow), windspeed = VALUES(windspeed), winddir = VALUES(winddir), pressure = VALUES(pressure), cloudcover = VALUES(cloudcover), visibility = VALUES(visibility), uvindex = VALUES(uvindex), icon = VALUES(icon)

INSERT INTO w_hours_22 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '148856', '2024-06-22', '00:00:00', '19.1', '17.2', '88.75', '0', '40', '0', '1.4', '266.7', '1024', '56', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-22', '01:00:00', '18.5', '16.9', '90.41', '0', '40', '0', '1.4', '203.3', '1023', '56', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-22', '02:00:00', '17.9', '16.5', '91.52', '0', '40', '0', '1.4', '140', '1023', '56', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-22', '03:00:00', '17.3', '16', '92.07', '0', '24', '0', '1.4', '123.3', '1023', '57.3', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-22', '04:00:00', '16.6', '15.6', '93.82', '0', '24', '0', '1.4', '106.7', '1022', '58.7', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-22', '05:00:00', '16', '15.1', '94.4', '0.3', '24', '0', '1.4', '90', '1022', '60', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-22', '06:00:00', '17.3', '15.8', '90.9', '0', '24', '0', '1.4', '136.7', '1022', '57', '24.1', '0', 'partly-cloudy-day' ),( '148856', '2024-06-22', '07:00:00', '18.5', '16.6', '88.7', '0', '24', '0', '1.4', '183.3', '1021', '54', '24.1', '0', 'partly-cloudy-day' ),( '148856', '2024-06-22', '08:00:00', '19.8', '17.3', '85.51', '0', '24', '0', '1.4', '230', '1021', '51', '24.1', '1', 'partly-cloudy-day' ),( '148856', '2024-06-22', '09:00:00', '21.7', '17.2', '75.59', '0', '30', '0', '2.5', '236.7', '1020', '51.7', '24.1', '2', 'partly-cloudy-day' ),( '148856', '2024-06-22', '10:00:00', '23.7', '17.2', '66.95', '0', '30', '0', '3.2', '243.3', '1019', '52.3', '24.1', '4', 'partly-cloudy-day' ),( '148856', '2024-06-22', '11:00:00', '25.6', '17.1', '59.38', '0.3', '30', '0', '4.3', '250', '1018', '53', '24.1', '6', 'partly-cloudy-day' ),( '148856', '2024-06-22', '12:00:00', '26.4', '16.9', '55.92', '0', '30', '0', '5', '253.3', '1017', '54.7', '23', '6', 'partly-cloudy-day' ),( '148856', '2024-06-22', '13:00:00', '27.1', '16.6', '52.65', '0', '30', '0', '5.4', '256.7', '1015', '56.3', '21.9', '6', 'partly-cloudy-day' ),( '148856', '2024-06-22', '14:00:00', '27.9', '16.4', '49.61', '0', '30', '0', '6.1', '260', '1014', '58', '20.8', '6', 'partly-cloudy-day' ),( '148856', '2024-06-22', '15:00:00', '27.5', '16.5', '51.1', '0', '40', '0', '6.1', '260', '1013', '60.3', '19.3', '5', 'partly-cloudy-day' ),( '148856', '2024-06-22', '16:00:00', '27.1', '16.7', '52.99', '0', '40', '0', '6.1', '260', '1013', '62.7', '17.7', '5', 'partly-cloudy-day' ),( '148856', '2024-06-22', '17:00:00', '26.7', '16.8', '54.59', '0.3', '40', '0', '6.1', '260', '1012', '65', '16.2', '5', 'partly-cloudy-day' ),( '148856', '2024-06-22', '18:00:00', '25.6', '17.1', '59.38', '0', '40', '0', '5', '263.3', '1011', '67', '17', '4', 'partly-cloudy-day' ),( '148856', '2024-06-22', '19:00:00', '24.5', '17.4', '64.62', '0', '40', '0', '4.3', '266.7', '1011', '69', '17.7', '4', 'partly-cloudy-day' ),( '148856', '2024-06-22', '20:00:00', '23.4', '17.7', '70.36', '0', '40', '0', '3.2', '270', '1010', '71', '18.5', '3', 'partly-cloudy-day' ),( '148856', '2024-06-22', '21:00:00', '22.1', '17.4', '74.7', '0', '43', '0', '2.5', '260', '1010', '67.7', '15.4', '0', 'partly-cloudy-night' ),( '148856', '2024-06-22', '22:00:00', '20.7', '17', '79.36', '0', '43', '0', '2.2', '250', '1009', '64.3', '12.2', '0', 'partly-cloudy-night' ),( '148856', '2024-06-22', '23:00:00', '19.4', '16.7', '84.39', '0.3', '43', '0', '1.4', '240', '1009', '61', '9.1', '0', 'partly-cloudy-night' ) ON DUPLICATE KEY UPDATE temp = VALUES(temp), dew = VALUES(dew), humidity = VALUES(humidity), precip = VALUES(precip), precipprob = VALUES(precipprob), snow = VALUES(snow), windspeed = VALUES(windspeed), winddir = VALUES(winddir), pressure = VALUES(pressure), cloudcover = VALUES(cloudcover), visibility = VALUES(visibility), uvindex = VALUES(uvindex), icon = VALUES(icon)

INSERT INTO w_hours_23 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '148856', '2024-06-23', '00:00:00', '18.9', '16.6', '86.51', '0', '43', '0', '1.4', '240', '1008', '63.3', '14.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-23', '01:00:00', '18.4', '16.5', '88.69', '0', '43', '0', '1.4', '240', '1007', '65.7', '19.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-23', '02:00:00', '17.9', '16.4', '90.94', '0', '43', '0', '1.4', '240', '1006', '68', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-23', '03:00:00', '17.2', '15.9', '92.07', '0', '32', '0', '1.4', '240', '1006', '67.7', '21.3', '0', 'partly-cloudy-night' ),( '148856', '2024-06-23', '04:00:00', '16.4', '15.4', '93.81', '0', '32', '0', '1.4', '240', '1005', '67.3', '18.6', '0', 'partly-cloudy-night' ),( '148856', '2024-06-23', '05:00:00', '15.7', '14.9', '94.99', '0', '22.6', '0', '1.4', '240', '1005', '67', '15.8', '0', 'partly-cloudy-night' ),( '148856', '2024-06-23', '06:00:00', '16.6', '15.5', '93.22', '0', '22.6', '0', '1.8', '236.7', '1005', '65.7', '17.4', '0', 'partly-cloudy-day' ),( '148856', '2024-06-23', '07:00:00', '17.6', '16', '90.34', '0', '22.6', '0', '2.5', '233.3', '1006', '64.3', '18.9', '0', 'partly-cloudy-day' ),( '148856', '2024-06-23', '08:00:00', '18.3', '16.8', '90.97', '0.9', '22.6', '0', '25.6', '270.5', '1006', '63.8', '20.5', '1', 'partly-cloudy-day' ),( '148856', '2024-06-23', '09:00:00', '17.2', '14.8', '85.79', '0', '54.8', '0', '24.8', '276.9', '1007', '75.9', '21.7', '2', 'showers-day' ),( '148856', '2024-06-23', '10:00:00', '16.1', '12.7', '80.26', '0', '54.8', '0', '24.1', '283.3', '1009', '87.9', '22.9', '3', 'showers-day' ),( '148856', '2024-06-23', '11:00:00', '15', '10.7', '75.47', '0', '54.8', '0', '23.4', '289.7', '1010', '100', '24.1', '4', 'rain' ),( '148856', '2024-06-23', '12:00:00', '16.2', '9.9', '66.25', '0', '54.8', '0', '23', '296.7', '1010', '96.7', '24.1', '4', 'rain' ),( '148856', '2024-06-23', '13:00:00', '17.5', '9.2', '58.2', '0', '54.8', '0', '22.3', '303.7', '1011', '93.3', '24.1', '5', 'rain' ),( '148856', '2024-06-23', '14:00:00', '18.7', '8.4', '51.14', '0', '54.8', '0', '22', '310.7', '1011', '90', '24.1', '6', 'showers-day' ),( '148856', '2024-06-23', '15:00:00', '19', '8.3', '49.85', '0', '51.6', '0', '20.9', '308.9', '1011', '93.3', '24.1', '6', 'rain' ),( '148856', '2024-06-23', '16:00:00', '19.3', '8.1', '48.26', '0', '51.6', '0', '20.2', '307.2', '1012', '96.7', '24.1', '7', 'rain' ),( '148856', '2024-06-23', '17:00:00', '19.6', '8', '47.05', '0', '51.6', '0', '19.1', '305.4', '1012', '100', '24.1', '7', 'rain' ),( '148856', '2024-06-23', '18:00:00', '18.4', '8.7', '53.18', '0', '51.6', '0', '16.9', '295.8', '1013', '100', '24.1', '5', 'rain' ),( '148856', '2024-06-23', '19:00:00', '17.1', '9.3', '60.1', '0', '51.6', '0', '15.1', '286.3', '1013', '100', '24.1', '4', 'rain' ),( '148856', '2024-06-23', '20:00:00', '15.9', '10', '67.99', '0.1', '51.6', '0', '13', '276.7', '1014', '100', '24.1', '2', 'rain' ),( '148856', '2024-06-23', '21:00:00', '14.4', '9.8', '73.87', '0', '25.8', '0', '10.1', '275.5', '1015', '100', '24.1', '0', 'cloudy' ),( '148856', '2024-06-23', '22:00:00', '12.9', '9.5', '79.82', '0', '25.8', '0', '7.6', '274.4', '1015', '100', '24.1', '0', 'cloudy' ),( '148856', '2024-06-23', '23:00:00', '11.4', '9.3', '86.92', '0', '25.8', '0', '4.7', '273.2', '1016', '100', '24.1', '0', 'cloudy' ) ON DUPLICATE KEY UPDATE temp = VALUES(temp), dew = VALUES(dew), humidity = VALUES(humidity), precip = VALUES(precip), precipprob = VALUES(precipprob), snow = VALUES(snow), windspeed = VALUES(windspeed), winddir = VALUES(winddir), pressure = VALUES(pressure), cloudcover = VALUES(cloudcover), visibility = VALUES(visibility), uvindex = VALUES(uvindex), icon = VALUES(icon)

INSERT INTO w_hours_24 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '148856', '2024-06-24', '00:00:00', '11', '9.2', '88.66', '0', '25.8', '0', '4.7', '284.9', '1016', '100', '24.1', '0', 'cloudy' ),( '148856', '2024-06-24', '01:00:00', '10.6', '9.2', '91.05', '0', '25.8', '0', '4.3', '296.7', '1017', '100', '24.1', '0', 'cloudy' ),( '148856', '2024-06-24', '02:00:00', '10.2', '9.1', '92.88', '0', '25.8', '0', '4.3', '308.4', '1017', '100', '24.1', '0', 'cloudy' ),( '148856', '2024-06-24', '03:00:00', '9.9', '8.6', '91.62', '0', '25.8', '0', '4.3', '306', '1018', '100', '24.1', '0', 'cloudy' ),( '148856', '2024-06-24', '04:00:00', '9.7', '8', '89.15', '0', '25.8', '0', '4', '303.5', '1018', '100', '24.1', '0', 'cloudy' ),( '148856', '2024-06-24', '05:00:00', '9.4', '7.5', '87.92', '0', '25.8', '0', '4', '301.1', '1019', '100', '24.1', '0', 'cloudy' ),( '148856', '2024-06-24', '06:00:00', '11', '6.8', '75.31', '0', '25.8', '0', '3.6', '314.4', '1019', '92.1', '24.1', '0', 'cloudy' ),( '148856', '2024-06-24', '07:00:00', '12.7', '6.2', '64.6', '0', '25.8', '0', '2.9', '327.6', '1020', '84.3', '24.1', '1', 'partly-cloudy-day' ),( '148856', '2024-06-24', '08:00:00', '14.3', '5.5', '55.45', '0', '25.8', '0', '2.5', '340.9', '1020', '76.4', '24.1', '1', 'partly-cloudy-day' ),( '148856', '2024-06-24', '09:00:00', '16.3', '4.6', '45.81', '0', '32.3', '0', '4', '332.5', '1020', '82.4', '24.1', '3', 'partly-cloudy-day' ),( '148856', '2024-06-24', '10:00:00', '18.4', '3.6', '37.4', '0', '32.3', '0', '5', '324', '1019', '88.4', '24.1', '5', 'partly-cloudy-day' ),( '148856', '2024-06-24', '11:00:00', '20.4', '2.7', '30.99', '0', '32.3', '0', '6.5', '315.6', '1019', '94.4', '24.1', '7', 'cloudy' ),( '148856', '2024-06-24', '12:00:00', '21.4', '3', '29.76', '0', '32.3', '0', '6.1', '309', '1019', '96', '24.1', '7', 'cloudy' ),( '148856', '2024-06-24', '13:00:00', '22.4', '3.4', '28.8', '0', '32.3', '0', '5.4', '302.4', '1018', '97.6', '24.1', '8', 'cloudy' ),( '148856', '2024-06-24', '14:00:00', '23.4', '3.7', '27.69', '0', '32.3', '0', '5', '295.8', '1018', '99.2', '24.1', '8', 'cloudy' ),( '148856', '2024-06-24', '15:00:00', '23.2', '4', '28.62', '0', '35.5', '0', '5.4', '299.9', '1018', '99.5', '24.1', '8', 'cloudy' ),( '148856', '2024-06-24', '16:00:00', '23.1', '4.2', '29.2', '0', '35.5', '0', '5.4', '303.9', '1017', '99.7', '24.1', '7', 'cloudy' ),( '148856', '2024-06-24', '17:00:00', '22.9', '4.5', '30.19', '0', '35.5', '0', '5.8', '308', '1017', '100', '24.1', '7', 'cloudy' ),( '148856', '2024-06-24', '18:00:00', '20.6', '6.5', '39.91', '0', '35.5', '0', '4.7', '324.5', '1017', '98', '24.1', '5', 'cloudy' ),( '148856', '2024-06-24', '19:00:00', '18.3', '8.5', '52.79', '0', '35.5', '0', '3.2', '341', '1017', '95.9', '24.1', '4', 'cloudy' ),( '148856', '2024-06-24', '20:00:00', '16', '10.5', '69.85', '1.3', '35.5', '0', '2.2', '357.5', '1017', '93.9', '24.1', '2', 'cloudy' ),( '148856', '2024-06-24', '21:00:00', '14.8', '9.7', '71.51', '0', '19.4', '0', '1.8', '289', '1017', '95.9', '24.1', '0', 'cloudy' ),( '148856', '2024-06-24', '22:00:00', '13.7', '8.8', '72.27', '0', '19.4', '0', '1.8', '220.5', '1018', '98', '24.1', '0', 'cloudy' ),( '148856', '2024-06-24', '23:00:00', '12.5', '8', '74.04', '0', '19.4', '0', '1.4', '152', '1018', '100', '24.1', '0', 'cloudy' ) ON DUPLICATE KEY UPDATE temp = VALUES(temp), dew = VALUES(dew), humidity = VALUES(humidity), precip = VALUES(precip), precipprob = VALUES(precipprob), snow = VALUES(snow), windspeed = VALUES(windspeed), winddir = VALUES(winddir), pressure = VALUES(pressure), cloudcover = VALUES(cloudcover), visibility = VALUES(visibility), uvindex = VALUES(uvindex), icon = VALUES(icon)

INSERT INTO w_hours_25 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '148856', '2024-06-25', '00:00:00', '12', '7.7', '74.97', '0', '19.4', '0', '2.5', '165.7', '1018', '95.2', '24.1', '0', 'cloudy' ),( '148856', '2024-06-25', '01:00:00', '11.6', '7.4', '75.41', '0', '19.4', '0', '3.6', '179.5', '1017', '90.3', '24.1', '0', 'cloudy' ),( '148856', '2024-06-25', '02:00:00', '11.1', '7.1', '76.37', '0', '19.4', '0', '4.7', '193.2', '1017', '85.5', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-25', '03:00:00', '10.5', '7', '78.93', '0', '19.4', '0', '4.3', '248.2', '1017', '90', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-25', '04:00:00', '9.9', '6.8', '81.04', '0', '19.4', '0', '4', '303.1', '1018', '94.5', '24.1', '0', 'cloudy' ),( '148856', '2024-06-25', '05:00:00', '9.3', '6.7', '83.79', '0', '19.4', '0', '3.6', '358.1', '1018', '99', '24.1', '0', 'cloudy' ),( '148856', '2024-06-25', '06:00:00', '11.8', '7.4', '74.42', '0', '19.4', '0', '3.2', '357.8', '1018', '66', '24.1', '1', 'partly-cloudy-day' ),( '148856', '2024-06-25', '07:00:00', '14.3', '8', '65.84', '0', '19.4', '0', '3.2', '357.6', '1017', '33', '24.1', '1', 'partly-cloudy-day' ),( '148856', '2024-06-25', '08:00:00', '16.8', '8.7', '58.82', '0', '19.4', '0', '2.9', '357.3', '1017', '0', '24.1', '2', 'clear-day' ),( '148856', '2024-06-25', '09:00:00', '18.8', '8.1', '49.79', '0', '19.4', '0', '4.7', '244.1', '1017', '0', '24.1', '4', 'clear-day' ),( '148856', '2024-06-25', '10:00:00', '20.8', '7.6', '42.51', '0', '19.4', '0', '6.5', '130.9', '1016', '0', '24.1', '5', 'clear-day' ),( '148856', '2024-06-25', '11:00:00', '22.8', '7', '36.11', '0', '19.4', '0', '8.3', '17.7', '1016', '0', '24.1', '7', 'clear-day' ),( '148856', '2024-06-25', '12:00:00', '23.7', '7.2', '34.67', '0', '19.4', '0', '8.6', '13.3', '1015', '0', '24.1', '8', 'clear-day' ),( '148856', '2024-06-25', '13:00:00', '24.6', '7.3', '33.07', '0', '19.4', '0', '9', '9', '1015', '0', '24.1', '9', 'clear-day' ),( '148856', '2024-06-25', '14:00:00', '25.5', '7.5', '31.78', '2.1', '19.4', '0', '9.4', '4.6', '1014', '0', '24.1', '10', 'clear-day' ),( '148856', '2024-06-25', '15:00:00', '25.5', '8', '32.88', '0', '25.8', '0', '9.4', '117.6', '1014', '0', '24.1', '9', 'clear-day' ),( '148856', '2024-06-25', '16:00:00', '25.6', '8.4', '33.58', '0', '25.8', '0', '9', '230.6', '1014', '0', '24.1', '8', 'clear-day' ),( '148856', '2024-06-25', '17:00:00', '25.6', '8.9', '34.74', '0', '25.8', '0', '9', '343.6', '1014', '0', '24.1', '8', 'clear-day' ),( '148856', '2024-06-25', '18:00:00', '23.2', '10.4', '44.36', '0', '25.8', '0', '8.3', '345.8', '1014', '33.3', '24.1', '6', 'partly-cloudy-day' ),( '148856', '2024-06-25', '19:00:00', '20.8', '11.8', '56.35', '0', '25.8', '0', '7.6', '348.1', '1015', '66.7', '24.1', '5', 'partly-cloudy-day' ),( '148856', '2024-06-25', '20:00:00', '18.4', '13.3', '72.17', '0', '25.8', '0', '6.8', '350.3', '1015', '100', '24.1', '3', 'cloudy' ),( '148856', '2024-06-25', '21:00:00', '17.1', '12.5', '74.34', '0', '19.4', '0', '6.1', '240.2', '1015', '91.7', '24.1', '0', 'cloudy' ),( '148856', '2024-06-25', '22:00:00', '15.7', '11.8', '77.61', '0', '19.4', '0', '5.8', '130', '1016', '83.4', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-25', '23:00:00', '14.4', '11', '80.03', '0', '19.4', '0', '5', '19.9', '1016', '75.1', '24.1', '0', 'partly-cloudy-night' ) ON DUPLICATE KEY UPDATE temp = VALUES(temp), dew = VALUES(dew), humidity = VALUES(humidity), precip = VALUES(precip), precipprob = VALUES(precipprob), snow = VALUES(snow), windspeed = VALUES(windspeed), winddir = VALUES(winddir), pressure = VALUES(pressure), cloudcover = VALUES(cloudcover), visibility = VALUES(visibility), uvindex = VALUES(uvindex), icon = VALUES(icon)

INSERT INTO w_hours_26 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '148856', '2024-06-26', '00:00:00', '13.9', '11', '82.66', '0', '19.4', '0', '4', '15.4', '1016', '82.9', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-26', '01:00:00', '13.4', '10.9', '84.83', '0', '19.4', '0', '2.9', '10.9', '1017', '90.8', '24.1', '0', 'cloudy' ),( '148856', '2024-06-26', '02:00:00', '12.9', '10.9', '87.65', '0', '19.4', '0', '1.8', '6.4', '1017', '98.6', '24.1', '0', 'cloudy' ),( '148856', '2024-06-26', '03:00:00', '12.5', '10.7', '88.78', '0', '19.4', '0', '1.8', '13.5', '1017', '67.4', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-26', '04:00:00', '12.2', '10.6', '89.95', '0', '19.4', '0', '1.8', '20.7', '1017', '36.2', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-26', '05:00:00', '11.8', '10.4', '91.13', '0', '19.4', '0', '1.8', '27.8', '1017', '5', '24.1', '0', 'clear-night' ),( '148856', '2024-06-26', '06:00:00', '14.4', '10.8', '78.97', '0', '19.4', '0', '1.4', '85.1', '1017', '21.8', '24.1', '1', 'partly-cloudy-day' ),( '148856', '2024-06-26', '07:00:00', '17', '11.3', '69.12', '0', '19.4', '0', '0.7', '142.5', '1017', '38.5', '24.1', '1', 'partly-cloudy-day' ),( '148856', '2024-06-26', '08:00:00', '19.6', '11.7', '60.29', '1.6', '19.4', '0', '0.4', '199.8', '1017', '55.3', '24.1', '2', 'partly-cloudy-day' ),( '148856', '2024-06-26', '09:00:00', '21.9', '11.7', '52.33', '0', '12.9', '0', '1.4', '235.5', '1017', '37.4', '24.1', '3', 'partly-cloudy-day' ),( '148856', '2024-06-26', '10:00:00', '24.2', '11.6', '45.23', '0', '12.9', '0', '2.9', '271.1', '1016', '19.6', '24.1', '5', 'clear-day' ),( '148856', '2024-06-26', '11:00:00', '26.5', '11.6', '39.44', '0', '12.9', '0', '4', '306.8', '1016', '1.7', '24.1', '7', 'clear-day' ),( '148856', '2024-06-26', '12:00:00', '27.2', '10.7', '35.66', '0', '12.9', '0', '5.4', '301', '1016', '1.2', '24.1', '8', 'clear-day' ),( '148856', '2024-06-26', '13:00:00', '27.8', '9.7', '32.2', '0', '12.9', '0', '6.8', '295.1', '1015', '0.8', '24.1', '9', 'clear-day' ),( '148856', '2024-06-26', '14:00:00', '28.5', '8.8', '29.1', '0', '12.9', '0', '8.3', '289.3', '1015', '0.3', '24.1', '9', 'clear-day' ),( '148856', '2024-06-26', '15:00:00', '28.4', '8.8', '29.27', '0', '29', '0', '8.6', '293.9', '1015', '0.2', '24.1', '9', 'clear-day' ),( '148856', '2024-06-26', '16:00:00', '28.3', '8.8', '29.44', '0', '29', '0', '9', '298.5', '1014', '0.1', '24.1', '8', 'clear-day' ),( '148856', '2024-06-26', '17:00:00', '28.2', '8.8', '29.61', '0', '29', '0', '9.4', '303.1', '1014', '0', '24.1', '8', 'clear-day' ),( '148856', '2024-06-26', '18:00:00', '25.3', '10.2', '38.59', '0', '29', '0', '7.9', '313.7', '1014', '1.5', '24.1', '6', 'clear-day' ),( '148856', '2024-06-26', '19:00:00', '22.3', '11.7', '51.07', '0', '29', '0', '6.1', '324.3', '1015', '2.9', '24.1', '5', 'clear-day' ),( '148856', '2024-06-26', '20:00:00', '19.4', '13.1', '66.92', '0', '29', '0', '4.7', '334.9', '1015', '4.4', '24.1', '3', 'clear-day' ),( '148856', '2024-06-26', '21:00:00', '18.1', '11.7', '66.21', '0', '22.6', '0', '3.6', '335.5', '1015', '3', '24.1', '0', 'clear-night' ),( '148856', '2024-06-26', '22:00:00', '16.8', '10.2', '65.06', '0', '22.6', '0', '2.2', '336', '1016', '1.5', '24.1', '0', 'clear-night' ),( '148856', '2024-06-26', '23:00:00', '15.5', '8.8', '64.34', '0', '22.6', '0', '1.1', '336.6', '1016', '0.1', '24.1', '0', 'clear-night' ) ON DUPLICATE KEY UPDATE temp = VALUES(temp), dew = VALUES(dew), humidity = VALUES(humidity), precip = VALUES(precip), precipprob = VALUES(precipprob), snow = VALUES(snow), windspeed = VALUES(windspeed), winddir = VALUES(winddir), pressure = VALUES(pressure), cloudcover = VALUES(cloudcover), visibility = VALUES(visibility), uvindex = VALUES(uvindex), icon = VALUES(icon)

INSERT INTO w_hours_27 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '148856', '2024-06-27', '00:00:00', '15.2', '8.5', '64.28', '0', '22.6', '0', '1.1', '278.1', '1016', '1.7', '24.1', '0', 'clear-night' ),( '148856', '2024-06-27', '01:00:00', '15', '8.2', '63.8', '0', '22.6', '0', '1.1', '219.6', '1016', '3.4', '24.1', '0', 'clear-night' ),( '148856', '2024-06-27', '02:00:00', '14.7', '7.9', '63.73', '1.1', '22.6', '0', '1.1', '161.1', '1016', '5', '24.1', '0', 'clear-night' ),( '148856', '2024-06-27', '03:00:00', '14.4', '8.1', '65.86', '0', '22.6', '0', '2.2', '171.5', '1016', '22.4', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-27', '04:00:00', '14', '8.2', '68.05', '0', '22.6', '0', '3.2', '181.9', '1016', '39.7', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-27', '05:00:00', '13.7', '8.4', '70.34', '0', '22.6', '0', '4.3', '192.3', '1016', '57.1', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-27', '06:00:00', '16.1', '9.6', '65.35', '0', '22.6', '0', '3.6', '199.8', '1016', '54.9', '24.1', '1', 'partly-cloudy-day' ),( '148856', '2024-06-27', '07:00:00', '18.4', '10.8', '61.22', '0', '22.6', '0', '3.2', '207.4', '1016', '52.8', '24.1', '1', 'partly-cloudy-day' ),( '148856', '2024-06-27', '08:00:00', '20.8', '12', '57.1', '0', '22.6', '0', '2.5', '214.9', '1016', '50.6', '24.1', '2', 'partly-cloudy-day' ),( '148856', '2024-06-27', '09:00:00', '23', '12', '49.92', '0', '29', '0', '3.2', '235.8', '1016', '33.7', '24.1', '4', 'partly-cloudy-day' ),( '148856', '2024-06-27', '10:00:00', '25.2', '11.9', '43.46', '0', '29', '0', '4.3', '256.6', '1015', '16.9', '24.1', '5', 'clear-day' ),( '148856', '2024-06-27', '11:00:00', '27.4', '11.9', '38.16', '0', '29', '0', '5', '277.5', '1015', '0', '24.1', '7', 'clear-day' ),( '148856', '2024-06-27', '12:00:00', '28.4', '11.3', '34.6', '0', '29', '0', '5.4', '272.1', '1014', '0', '24.1', '8', 'clear-day' ),( '148856', '2024-06-27', '13:00:00', '29.3', '10.8', '31.77', '0', '29', '0', '5.4', '266.8', '1014', '0', '24.1', '9', 'clear-day' ),( '148856', '2024-06-27', '14:00:00', '30.3', '10.2', '28.81', '0', '29', '0', '5.8', '261.4', '1013', '0', '24.1', '9', 'clear-day' ),( '148856', '2024-06-27', '15:00:00', '30.2', '10.3', '29.17', '0', '32.3', '0', '5.8', '248.8', '1013', '0', '24.1', '9', 'clear-day' ),( '148856', '2024-06-27', '16:00:00', '30.1', '10.5', '29.74', '0', '32.3', '0', '5.4', '236.3', '1012', '0', '24.1', '8', 'clear-day' ),( '148856', '2024-06-27', '17:00:00', '30', '10.6', '30.11', '0', '32.3', '0', '5.4', '223.7', '1012', '0', '24.1', '8', 'clear-day' ),( '148856', '2024-06-27', '18:00:00', '27.3', '12.2', '39.15', '0', '32.3', '0', '4.7', '202.4', '1012', '0.1', '24.1', '6', 'clear-day' ),( '148856', '2024-06-27', '19:00:00', '24.6', '13.7', '50.67', '0', '32.3', '0', '4', '181.1', '1013', '0.2', '24.1', '5', 'clear-day' ),( '148856', '2024-06-27', '20:00:00', '21.9', '15.3', '66.15', '0', '32.3', '0', '3.2', '159.8', '1013', '0.3', '24.1', '3', 'clear-day' ),( '148856', '2024-06-27', '21:00:00', '20.6', '14.1', '66.31', '0', '19.4', '0', '3.2', '129.6', '1013', '16.2', '24.1', '0', 'clear-night' ),( '148856', '2024-06-27', '22:00:00', '19.2', '13', '67.32', '0', '19.4', '0', '3.2', '99.3', '1013', '32.1', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-27', '23:00:00', '17.9', '11.8', '67.5', '0', '19.4', '0', '3.2', '69.1', '1013', '48', '24.1', '0', 'partly-cloudy-night' ) ON DUPLICATE KEY UPDATE temp = VALUES(temp), dew = VALUES(dew), humidity = VALUES(humidity), precip = VALUES(precip), precipprob = VALUES(precipprob), snow = VALUES(snow), windspeed = VALUES(windspeed), winddir = VALUES(winddir), pressure = VALUES(pressure), cloudcover = VALUES(cloudcover), visibility = VALUES(visibility), uvindex = VALUES(uvindex), icon = VALUES(icon)

INSERT INTO w_hours_28 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '148856', '2024-06-28', '00:00:00', '17.4', '11.3', '67.39', '0', '19.4', '0', '4', '98', '1013', '58.3', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-28', '01:00:00', '16.9', '10.7', '66.84', '0', '19.4', '0', '5', '126.9', '1014', '68.6', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-28', '02:00:00', '16.4', '10.2', '66.74', '0', '19.4', '0', '5.8', '155.8', '1014', '78.9', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-28', '03:00:00', '16', '10.3', '68.92', '0', '22.6', '0', '5.4', '153.1', '1014', '52.6', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-28', '04:00:00', '15.6', '10.3', '70.71', '0', '22.6', '0', '5', '150.5', '1014', '26.4', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-28', '05:00:00', '15.2', '10.4', '73.03', '0', '22.6', '0', '4.7', '147.8', '1014', '0.1', '24.1', '0', 'clear-night' ),( '148856', '2024-06-28', '06:00:00', '17.4', '11.3', '67.39', '0', '22.6', '0', '4.7', '152.1', '1014', '0.2', '24.1', '1', 'clear-day' ),( '148856', '2024-06-28', '07:00:00', '19.7', '12.1', '61.52', '0', '22.6', '0', '5', '156.4', '1013', '0.3', '24.1', '1', 'clear-day' ),( '148856', '2024-06-28', '08:00:00', '21.9', '13', '56.99', '0', '22.6', '0', '5', '160.7', '1013', '0.4', '24.1', '2', 'clear-day' ),( '148856', '2024-06-28', '09:00:00', '23.9', '12.6', '49.18', '0', '19.4', '0', '6.8', '164.1', '1013', '32.6', '24.1', '4', 'partly-cloudy-day' ),( '148856', '2024-06-28', '10:00:00', '26', '12.2', '42.27', '0', '19.4', '0', '8.6', '167.4', '1012', '64.8', '24.1', '5', 'partly-cloudy-day' ),( '148856', '2024-06-28', '11:00:00', '28', '11.8', '36.6', '0', '19.4', '0', '10.4', '170.8', '1012', '97', '24.1', '7', 'cloudy' ),( '148856', '2024-06-28', '12:00:00', '29', '9.5', '29.63', '0', '19.4', '0', '13', '175.5', '1011', '66.3', '24.1', '8', 'partly-cloudy-day' ),( '148856', '2024-06-28', '13:00:00', '30', '7.1', '23.77', '0', '19.4', '0', '15.5', '180.2', '1011', '35.5', '24.1', '9', 'partly-cloudy-day' ),( '148856', '2024-06-28', '14:00:00', '31', '4.8', '19.15', '0', '19.4', '0', '18', '184.9', '1010', '4.8', '24.1', '9', 'clear-day' ),( '148856', '2024-06-28', '15:00:00', '30.1', '7.4', '24.12', '0', '25.8', '0', '18', '185.7', '1010', '26.5', '24.1', '9', 'partly-cloudy-day' ),( '148856', '2024-06-28', '16:00:00', '29.3', '9.9', '29.91', '0', '25.8', '0', '18', '186.4', '1009', '48.1', '24.1', '8', 'partly-cloudy-day' ),( '148856', '2024-06-28', '17:00:00', '28.4', '12.5', '37.45', '0', '25.8', '0', '18', '187.2', '1009', '69.8', '24.1', '8', 'partly-cloudy-day' ),( '148856', '2024-06-28', '18:00:00', '26.1', '13.7', '46.35', '0', '25.8', '0', '15.5', '186.8', '1010', '79.1', '24.1', '6', 'partly-cloudy-day' ),( '148856', '2024-06-28', '19:00:00', '23.9', '14.9', '57.11', '0', '25.8', '0', '13.3', '186.3', '1010', '88.5', '24.1', '3', 'partly-cloudy-day' ),( '148856', '2024-06-28', '20:00:00', '21.6', '16.1', '70.92', '0', '25.8', '0', '10.8', '185.9', '1011', '97.8', '24.1', '1', 'cloudy' ),( '148856', '2024-06-28', '21:00:00', '21', '16.2', '74.04', '0', '22.6', '0', '10.1', '178.8', '1011', '69.7', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-28', '22:00:00', '20.3', '16.4', '78.3', '0', '22.6', '0', '9.4', '171.6', '1010', '41.7', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-28', '23:00:00', '19.7', '16.5', '81.78', '0', '22.6', '0', '8.6', '164.5', '1010', '13.6', '24.1', '0', 'clear-night' ) ON DUPLICATE KEY UPDATE temp = VALUES(temp), dew = VALUES(dew), humidity = VALUES(humidity), precip = VALUES(precip), precipprob = VALUES(precipprob), snow = VALUES(snow), windspeed = VALUES(windspeed), winddir = VALUES(winddir), pressure = VALUES(pressure), cloudcover = VALUES(cloudcover), visibility = VALUES(visibility), uvindex = VALUES(uvindex), icon = VALUES(icon)

INSERT INTO w_hours_29 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '148856', '2024-06-29', '00:00:00', '18.6', '16.4', '87.03', '0', '22.6', '0', '7.9', '160.6', '1010', '25.6', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-29', '01:00:00', '17.5', '16.3', '92.67', '0', '22.6', '0', '7.2', '156.7', '1010', '37.6', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-29', '02:00:00', '16.4', '16.2', '98.73', '0', '22.6', '0', '6.5', '152.8', '1010', '49.6', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-29', '03:00:00', '16.3', '16.1', '98.73', '0', '9.7', '0', '6.5', '155.9', '1010', '63.5', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-29', '04:00:00', '16.3', '16.1', '98.73', '0', '9.7', '0', '6.1', '159', '1010', '77.5', '24.1', '0', 'partly-cloudy-night' ),( '148856', '2024-06-29', '05:00:00', '16.2', '16', '98.73', '0', '9.7', '0', '6.1', '162.1', '1010', '91.4', '24.1', '0', 'cloudy' ),( '148856', '2024-06-29', '06:00:00', '17.9', '16.6', '92.11', '0', '9.7', '0', '7.6', '168.1', '1009', '79.7', '24.1', '0', 'partly-cloudy-day' ),( '148856', '2024-06-29', '07:00:00', '19.7', '17.3', '86.04', '0', '9.7', '0', '8.6', '174.2', '1009', '68', '24.1', '1', 'partly-cloudy-day' ),( '148856', '2024-06-29', '08:00:00', '21.4', '17.9', '80.46', '0', '9.7', '0', '10.1', '180.2', '1008', '56.3', '24.1', '1', 'partly-cloudy-day' ),( '148856', '2024-06-29', '09:00:00', '22.7', '17.9', '74.33', '0', '16.1', '0', '11.2', '191.4', '1008', '70.9', '24.1', '3', 'partly-cloudy-day' ),( '148856', '2024-06-29', '10:00:00', '24', '17.8', '68.29', '0', '16.1', '0', '12.2', '202.5', '1007', '85.4', '24.1', '4', 'partly-cloudy-day' ),( '148856', '2024-06-29', '11:00:00', '25.3', '17.8', '63.18', '0', '16.1', '0', '13.3', '213.7', '1007', '100', '24.1', '5', 'cloudy' ),( '148856', '2024-06-29', '12:00:00', '23.7', '18.5', '72.66', '0', '16.1', '0', '11.2', '212.2', '1007', '100', '24.1', '5', 'cloudy' ),( '148856', '2024-06-29', '13:00:00', '22', '19.2', '84.14', '0', '16.1', '0', '8.6', '210.8', '1007', '100', '24.1', '5', 'cloudy' ),( '148856', '2024-06-29', '14:00:00', '20.4', '19.9', '96.95', '0', '16.1', '0', '6.5', '209.3', '1007', '100', '24.1', '5', 'cloudy' ),( '148856', '2024-06-29', '15:00:00', '21.6', '20', '90.62', '0', '19.4', '0', '7.6', '210.1', '1007', '75.9', '24.1', '5', 'partly-cloudy-day' ),( '148856', '2024-06-29', '16:00:00', '22.7', '20.2', '85.8', '0', '19.4', '0', '9', '211', '1006', '51.8', '24.1', '4', 'partly-cloudy-day' ),( '148856', '2024-06-29', '17:00:00', '23.9', '20.3', '80.3', '0', '19.4', '0', '10.1', '211.8', '1006', '27.7', '24.1', '4', 'partly-cloudy-day' ),( '148856', '2024-06-29', '18:00:00', '23', '20.2', '84.25', '0', '19.4', '0', '9', '200.6', '1006', '51.8', '21.6', '4', 'partly-cloudy-day' ),( '148856', '2024-06-29', '19:00:00', '22', '20.1', '88.98', '0', '19.4', '0', '8.3', '189.5', '1006', '75.9', '19.2', '3', 'partly-cloudy-day' ),( '148856', '2024-06-29', '20:00:00', '21.1', '20', '93.44', '0.1', '19.4', '0', '7.2', '178.3', '1006', '100', '16.7', '3', 'cloudy' ),( '148856', '2024-06-29', '21:00:00', '20.3', '19.1', '92.82', '0', '6.5', '0', '7.6', '206', '1006', '100', '19.2', '0', 'cloudy' ),( '148856', '2024-06-29', '22:00:00', '19.6', '18.3', '92.2', '0', '6.5', '0', '8.3', '233.7', '1007', '100', '21.6', '0', 'cloudy' ),( '148856', '2024-06-29', '23:00:00', '18.8', '17.4', '91.58', '0', '6.5', '0', '8.6', '261.4', '1007', '100', '24.1', '0', 'cloudy' ) ON DUPLICATE KEY UPDATE temp = VALUES(temp), dew = VALUES(dew), humidity = VALUES(humidity), precip = VALUES(precip), precipprob = VALUES(precipprob), snow = VALUES(snow), windspeed = VALUES(windspeed), winddir = VALUES(winddir), pressure = VALUES(pressure), cloudcover = VALUES(cloudcover), visibility = VALUES(visibility), uvindex = VALUES(uvindex), icon = VALUES(icon)

O clima para hoje em Northumberland

Desculpe, houve um problema ao carregar os dados meteorológicos. Fomos notificados e vamos resolver o mais rápido possível. Por favor, tente novamente mais tarde. Pedimos desculpas pelo transtorno.

O clima médio em Northumberland por mês

Clique em um mês abaixo e veja em detalhes como normalmente é o clima em Northumberland e o que você pode esperar. Com base nos dados históricos do clima de Northumberland, você pode ver a temperatura média, precipitação, vento e índice UV para cada dia do mês.

O clima em Northumberland

O clima para hoje em Northumberland

O clima médio em Northumberland por mês