Buscar Menu
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 ( '93940', '2024-06-15', '00:00:00', '8.5', '7.5', '93.43', '0', '0', '0', '2.2', '41', '1012', '88', '10', '0', 'partly-cloudy-night' ),( '93940', '2024-06-15', '01:00:00', '7.8', '7.2', '96.06', '0', '0', '0', '2.5', '141', '1012', '88', '10', '0', 'partly-cloudy-night' ),( '93940', '2024-06-15', '02:00:00', '7.2', '6.8', '97.22', '0', '0', '0', '3.6', '90', '1012', '100', '10', '0', 'cloudy' ),( '93940', '2024-06-15', '03:00:00', '7.2', '7.2', '100', '0', '0', '0', '5.2', '300', '1012', '100', '6.8', '0', 'cloudy' ),( '93940', '2024-06-15', '04:00:00', '8.8', '7.8', '93.44', '0', '0', '0', '4.3', '20', '1012', '100', '10', '0', 'cloudy' ),( '93940', '2024-06-15', '05:00:00', '8.5', '8', '96.08', '0', '0', '0', '4.3', '320', '1012', '95.1', '7.5', '1', 'cloudy' ),( '93940', '2024-06-15', '06:00:00', '9.9', '9.4', '96.13', '0', '0', '0', '4.7', '20', '1012', '79.4', '10', '2', 'partly-cloudy-day' ),( '93940', '2024-06-15', '07:00:00', '11', '9.4', '89.93', '0', '0', '0', '6.3', '70', '1012', '50.9', '10', '3', 'partly-cloudy-day' ),( '93940', '2024-06-15', '08:00:00', '11.9', '9.9', '87.56', '0', '0', '0', '7.8', '110', '1012', '100', '10', '4', 'cloudy' ),( '93940', '2024-06-15', '09:00:00', '13.5', '9.5', '76.77', '0', '0', '0', '8.6', '156', '1012', '88', '10', '5', 'partly-cloudy-day' ),( '93940', '2024-06-15', '10:00:00', '14.9', '9.1', '68.16', '0', '0', '0', '13', '165', '1011.4', '69.2', '10', '6', 'partly-cloudy-day' ),( '93940', '2024-06-15', '11:00:00', '16.1', '9.9', '66.79', '0.1', '100', '0', '15.1', '154', '1011.4', '50.9', '10', '7', 'showers-day' ),( '93940', '2024-06-15', '12:00:00', '17.1', '10.1', '63.43', '0.1', '100', '0', '17.6', '170', '1011.4', '25', '10', '8', 'showers-day' ),( '93940', '2024-06-15', '13:00:00', '17.1', '9.1', '59.31', '0.2', '100', '0', '19.2', '160', '1011.4', '50', '10', '8', 'showers-day' ),( '93940', '2024-06-15', '14:00:00', '17.5', '9.1', '57.79', '0.1', '100', '0', '19.2', '166', '1011.4', '65.6', '10', '5', 'showers-day' ),( '93940', '2024-06-15', '15:00:00', '17.5', '8.7', '56.21', '0.4', '100', '0', '14.8', '155', '1011.4', '95.1', '10', '3', 'rain' ),( '93940', '2024-06-15', '16:00:00', '15.6', '10.3', '70.77', '0.1', '100', '0', '21.6', '290', '1011.4', '95.1', '10', '3', 'rain' ),( '93940', '2024-06-15', '17:00:00', '16.4', '10.1', '66.35', '1.4', '100', '0', '11.6', '278', '1011.4', '88', '10', '2', 'showers-day' ),( '93940', '2024-06-15', '18:00:00', '16.5', '8.4', '58.46', '0.4', '100', '0', '16.9', '158', '1011', '92.9', '10', '3', 'rain' ),( '93940', '2024-06-15', '19:00:00', '16.1', '8.4', '60.01', '0.4', '100', '0', '20', '162', '1011.4', '95.1', '10', '3', 'rain' ),( '93940', '2024-06-15', '20:00:00', '15.5', '8', '60.6', '0', '0', '0', '20.3', '164', '1011', '65.6', '10', '2', 'partly-cloudy-day' ),( '93940', '2024-06-15', '21:00:00', '14.5', '8.9', '69.15', '0', '0', '0', '16.9', '162', '1011.4', '15.6', '10', '1', 'clear-day' ),( '93940', '2024-06-15', '22:00:00', '13.5', '8.9', '73.78', '0', '0', '0', '13.3', '158', '1011.4', '33.7', '10', '1', 'partly-cloudy-day' ),( '93940', '2024-06-15', '23:00:00', '11.5', '9.4', '86.49', '0', '0', '0', '7.6', '132', '1012', '86.1', '10', '0', 'partly-cloudy-day' ) 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 ( '93940', '2024-06-16', '00:00:00', '7.6', '6.8', '94.67', '0', '0', '0', '5', '123.7', '1012', '100', '24.1', '0', 'cloudy' ),( '93940', '2024-06-16', '01:00:00', '7', '6.5', '96.62', '0', '0', '0', '5.8', '124.1', '1012', '100', '24.1', '0', 'cloudy' ),( '93940', '2024-06-16', '02:00:00', '7', '6.8', '98.64', '0', '0', '0', '6.1', '122.5', '1012', '100', '24.1', '0', 'cloudy' ),( '93940', '2024-06-16', '03:00:00', '7.6', '7.4', '98.64', '0', '0', '0', '6.5', '115', '1012', '98.4', '24.1', '0', 'cloudy' ),( '93940', '2024-06-16', '04:00:00', '8.2', '7.9', '97.98', '0', '0', '0', '7.2', '116.3', '1013', '100', '24.1', '0', 'cloudy' ),( '93940', '2024-06-16', '05:00:00', '8.9', '8.3', '96.02', '0', '0', '0', '8.6', '121', '1013', '100', '24.1', '1', 'cloudy' ),( '93940', '2024-06-16', '06:00:00', '9.6', '8.3', '91.6', '0', '0', '0', '10.4', '130.7', '1012', '100', '24.1', '1', 'cloudy' ),( '93940', '2024-06-16', '07:00:00', '10.3', '8.3', '87.41', '0', '0', '0', '10.1', '116.4', '1012', '100', '24.1', '1', 'cloudy' ),( '93940', '2024-06-16', '08:00:00', '10.8', '8.2', '83.97', '0', '0', '0', '11.5', '119.5', '1012', '100', '24.1', '2', 'cloudy' ),( '93940', '2024-06-16', '09:00:00', '11', '8.9', '86.88', '0.3', '90.3', '0', '13', '108.7', '1012', '100', '24.1', '3', 'rain' ),( '93940', '2024-06-16', '10:00:00', '10.9', '9.2', '89.25', '0.5', '90.3', '0', '14', '97.2', '1012', '100', '24.1', '2', 'rain' ),( '93940', '2024-06-16', '11:00:00', '11.2', '9.6', '89.88', '0', '90.3', '0', '18', '106.9', '1012', '99.3', '22.2', '1', 'rain' ),( '93940', '2024-06-16', '12:00:00', '11.6', '9.5', '86.94', '0.1', '90.3', '0', '18.4', '114.1', '1011', '94.9', '14.1', '0', 'rain' ),( '93940', '2024-06-16', '13:00:00', '11.2', '9.5', '89.27', '0', '90.3', '0', '16.2', '112.2', '1011', '100', '0.4', '0', 'rain' ),( '93940', '2024-06-16', '14:00:00', '11.3', '9.4', '88.09', '0', '90.3', '0', '18.7', '118.8', '1011', '100', '0.3', '1', 'rain' ),( '93940', '2024-06-16', '15:00:00', '12.5', '9.8', '83.6', '0', '35.5', '0', '17.3', '133.3', '1011', '100', '0.3', '2', 'fog' ),( '93940', '2024-06-16', '16:00:00', '14.3', '10.5', '77.91', '0', '35.5', '0', '11.2', '126.1', '1010', '85.4', '17.1', '2', 'partly-cloudy-day' ),( '93940', '2024-06-16', '17:00:00', '14', '10.6', '79.97', '0', '35.5', '0', '12.6', '144.9', '1010', '98', '24.1', '2', 'cloudy' ),( '93940', '2024-06-16', '18:00:00', '14.5', '10.5', '76.91', '0.1', '35.5', '0', '12.6', '154.7', '1010', '84.9', '24.1', '1', 'partly-cloudy-day' ),( '93940', '2024-06-16', '19:00:00', '14.3', '10.6', '78.43', '0', '35.5', '0', '11.5', '158.4', '1010', '80.6', '24.1', '1', 'partly-cloudy-day' ),( '93940', '2024-06-16', '20:00:00', '14', '10.9', '81.59', '0', '35.5', '0', '9.4', '157.5', '1011', '68.1', '24.1', '2', 'partly-cloudy-day' ),( '93940', '2024-06-16', '21:00:00', '13.1', '11.2', '88.25', '0', '0', '0', '9', '153.4', '1012', '61.6', '24.1', '1', 'partly-cloudy-day' ),( '93940', '2024-06-16', '22:00:00', '11.8', '11.1', '95.47', '0', '0', '0', '6.5', '139.6', '1012', '63.1', '24.1', '0', 'partly-cloudy-day' ),( '93940', '2024-06-16', '23:00:00', '10.9', '10.6', '98.02', '0', '0', '0', '6.1', '134.7', '1013', '66.6', '24.1', '0', 'partly-cloudy-day' ) 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 ( '93940', '2024-06-17', '00:00:00', '9.9', '9.7', '98.67', '0', '0', '0', '5', '124.1', '1013', '79.7', '24.1', '0', 'partly-cloudy-night' ),( '93940', '2024-06-17', '01:00:00', '9.5', '9.4', '99.33', '0', '0', '0', '4.3', '123.4', '1013', '96.7', '24.1', '0', 'cloudy' ),( '93940', '2024-06-17', '02:00:00', '9.3', '9.3', '100', '0', '0', '0', '4.3', '112.4', '1014', '83.7', '24.1', '0', 'partly-cloudy-night' ),( '93940', '2024-06-17', '03:00:00', '9', '9', '100', '0', '0', '0', '4.7', '108.7', '1014', '80.4', '24.1', '0', 'partly-cloudy-day' ),( '93940', '2024-06-17', '04:00:00', '9.4', '9.4', '100', '0', '0', '0', '5.4', '110.5', '1014', '93.9', '24.1', '0', 'cloudy' ),( '93940', '2024-06-17', '05:00:00', '10.3', '10.1', '98.67', '0', '0', '0', '7.6', '115.7', '1014', '99.9', '24.1', '1', 'cloudy' ),( '93940', '2024-06-17', '06:00:00', '10.7', '10.3', '97.37', '0', '0', '0', '7.6', '119.5', '1014', '100', '24.1', '1', 'cloudy' ),( '93940', '2024-06-17', '07:00:00', '12.4', '10.4', '87.6', '0', '0', '0', '7.9', '133.1', '1014', '100', '24.1', '2', 'cloudy' ),( '93940', '2024-06-17', '08:00:00', '13.6', '10.8', '83.18', '0', '0', '0', '7.9', '128.2', '1014', '100', '24.1', '3', 'cloudy' ),( '93940', '2024-06-17', '09:00:00', '14.7', '10.8', '77.46', '0', '64.5', '0', '9', '124.6', '1014', '100', '24.1', '3', 'rain' ),( '93940', '2024-06-17', '10:00:00', '14.9', '10.9', '76.97', '0', '64.5', '0', '9.7', '118.3', '1014', '100', '24.1', '5', 'rain' ),( '93940', '2024-06-17', '11:00:00', '15', '11.6', '80.11', '0.2', '64.5', '0', '11.2', '125.5', '1014', '100', '24.1', '6', 'rain' ),( '93940', '2024-06-17', '12:00:00', '14.8', '11.8', '82.23', '0.3', '64.5', '0', '10.4', '119', '1013', '99.8', '24.1', '7', 'rain' ),( '93940', '2024-06-17', '13:00:00', '14.4', '11.4', '82.18', '0.3', '64.5', '0', '10.8', '125.6', '1013', '100', '24.1', '6', 'rain' ),( '93940', '2024-06-17', '14:00:00', '14.3', '11.4', '82.71', '0.1', '64.5', '0', '11.5', '124.8', '1013', '100', '24.1', '4', 'rain' ),( '93940', '2024-06-17', '15:00:00', '14.6', '11.3', '80.59', '0', '35.5', '0', '12.2', '125.8', '1013', '100', '24.1', '6', 'cloudy' ),( '93940', '2024-06-17', '16:00:00', '14.3', '11.2', '81.62', '0', '35.5', '0', '11.2', '128.7', '1013', '99.5', '24.1', '6', 'cloudy' ),( '93940', '2024-06-17', '17:00:00', '14.4', '11.1', '80.56', '0', '35.5', '0', '9.7', '128', '1012', '97.2', '24.1', '5', 'cloudy' ),( '93940', '2024-06-17', '18:00:00', '13.9', '11.1', '83.21', '0', '35.5', '0', '7.9', '125.1', '1012', '88.3', '24.1', '5', 'partly-cloudy-day' ),( '93940', '2024-06-17', '19:00:00', '13.7', '10.9', '83.19', '0', '35.5', '0', '6.5', '122.6', '1012', '90.7', '24.1', '3', 'cloudy' ),( '93940', '2024-06-17', '20:00:00', '13.4', '10.9', '84.83', '0', '35.5', '0', '6.1', '119.3', '1011', '72', '24.1', '2', 'partly-cloudy-day' ),( '93940', '2024-06-17', '21:00:00', '12.9', '10.8', '87.06', '0', '3.2', '0', '4.3', '126', '1011', '61.8', '24.1', '1', 'partly-cloudy-day' ),( '93940', '2024-06-17', '22:00:00', '11.3', '10.5', '94.82', '0', '3.2', '0', '3.6', '130.3', '1011', '49.1', '24.1', '0', 'partly-cloudy-day' ),( '93940', '2024-06-17', '23:00:00', '9.6', '9.2', '97.35', '0', '3.2', '0', '4', '147.7', '1012', '47.8', '24.1', '0', 'partly-cloudy-day' ) 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 ( '93940', '2024-06-18', '00:00:00', '8.6', '8.4', '98.65', '0', '3.2', '0', '3.2', '192.7', '1011', '52.4', '24.1', '0', 'partly-cloudy-night' ),( '93940', '2024-06-18', '01:00:00', '8.6', '8.1', '96.67', '0', '3.2', '0', '4', '192.1', '1011', '57.7', '24.1', '0', 'partly-cloudy-night' ),( '93940', '2024-06-18', '02:00:00', '8.4', '8.2', '98.65', '0', '3.2', '0', '3.6', '191.6', '1011', '62.1', '24.1', '0', 'partly-cloudy-night' ),( '93940', '2024-06-18', '03:00:00', '8.1', '8.1', '100', '0', '16.1', '0', '3.2', '160.2', '1011', '90.3', '24.1', '0', 'cloudy' ),( '93940', '2024-06-18', '04:00:00', '8.5', '8.5', '100', '0', '16.1', '0', '3.6', '144.6', '1011', '100', '24.1', '0', 'cloudy' ),( '93940', '2024-06-18', '05:00:00', '9.2', '9.2', '100', '0', '16.1', '0', '2.9', '124.3', '1010', '97.7', '24.1', '1', 'cloudy' ),( '93940', '2024-06-18', '06:00:00', '10.1', '9.6', '96.71', '0', '16.1', '0', '3.6', '125', '1010', '96.5', '24.1', '1', 'cloudy' ),( '93940', '2024-06-18', '07:00:00', '11', '9.8', '92.31', '0.1', '16.1', '0', '4.7', '119.2', '1009', '92.3', '24.1', '1', 'cloudy' ),( '93940', '2024-06-18', '08:00:00', '11.5', '9.9', '89.9', '0.1', '16.1', '0', '6.5', '132.5', '1009', '98.6', '24.1', '2', 'cloudy' ),( '93940', '2024-06-18', '09:00:00', '13', '10.2', '83.11', '0', '67.7', '0', '7.2', '155.7', '1008', '83', '24.1', '3', 'showers-day' ),( '93940', '2024-06-18', '10:00:00', '14', '10.6', '79.97', '0', '67.7', '0', '10.8', '192.9', '1008', '94.9', '24.1', '4', 'rain' ),( '93940', '2024-06-18', '11:00:00', '14.9', '10.4', '74.45', '0', '67.7', '0', '9.4', '185.2', '1007', '90.6', '24.1', '5', 'rain' ),( '93940', '2024-06-18', '12:00:00', '16.4', '10.8', '69.46', '0', '67.7', '0', '9.7', '185.8', '1007', '76.6', '11.2', '6', 'showers-day' ),( '93940', '2024-06-18', '13:00:00', '17.5', '10.5', '63.5', '0', '67.7', '0', '9.7', '189.1', '1006', '50.3', '16.7', '4', 'showers-day' ),( '93940', '2024-06-18', '14:00:00', '18.5', '9.7', '56.52', '0', '67.7', '0', '9.7', '191.5', '1005', '42.4', '24.1', '3', 'showers-day' ),( '93940', '2024-06-18', '15:00:00', '19.2', '8.9', '51.27', '0', '77.4', '0', '9.7', '199.9', '1005', '61.9', '24.1', '2', 'showers-day' ),( '93940', '2024-06-18', '16:00:00', '19.6', '8.4', '48.35', '0', '77.4', '0', '9.4', '206.4', '1004', '74.4', '24.1', '2', 'showers-day' ),( '93940', '2024-06-18', '17:00:00', '17.8', '11.3', '65.71', '0.2', '77.4', '0', '12.2', '171.1', '1004', '72', '24.1', '4', 'showers-day' ),( '93940', '2024-06-18', '18:00:00', '17.7', '11.2', '65.69', '0.1', '77.4', '0', '12.2', '172.9', '1003', '20.7', '22', '4', 'showers-day' ),( '93940', '2024-06-18', '19:00:00', '17.3', '11.3', '67.82', '0', '77.4', '0', '10.8', '160.9', '1003', '74.1', '12.4', '2', 'showers-day' ),( '93940', '2024-06-18', '20:00:00', '16.7', '11.4', '70.92', '0', '77.4', '0', '12.6', '164.8', '1002', '28', '24.1', '1', 'showers-day' ),( '93940', '2024-06-18', '21:00:00', '15.2', '10.8', '75.34', '0', '45.2', '0', '10.2', '170.2', '1001.7', '52', '24.1', '0', 'showers-day' ),( '93940', '2024-06-18', '22:00:00', '13.7', '10.3', '80.11', '0', '45.2', '0', '7.8', '175.5', '1001.3', '76', '24.1', '0', 'showers-day' ),( '93940', '2024-06-18', '23:00:00', '12.2', '9.8', '85.27', '0', '45.2', '0', '5.4', '180.9', '1001', '100', '24.1', '0', 'rain' ) 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 ( '93940', '2024-06-19', '00:00:00', '11.6', '9.2', '85.4', '0', '45.2', '0', '4.4', '186.1', '1000.7', '86.3', '18.7', '0', 'showers-night' ),( '93940', '2024-06-19', '01:00:00', '11', '8.7', '85.53', '0', '45.2', '0', '3.5', '191.2', '1000.3', '72.5', '13.1', '0', 'showers-night' ),( '93940', '2024-06-19', '02:00:00', '10.5', '8.2', '85.66', '0.1', '45.2', '0', '2.5', '196.4', '1000', '58.8', '23.1', '0', 'showers-night' ),( '93940', '2024-06-19', '03:00:00', '10.4', '8.4', '87.42', '0', '25.8', '0', '3.6', '201.3', '999.7', '72.5', '24.1', '0', 'partly-cloudy-day' ),( '93940', '2024-06-19', '04:00:00', '10.4', '8.7', '89.21', '0', '25.8', '0', '4.7', '206.2', '999.3', '86.3', '24.1', '0', 'partly-cloudy-day' ),( '93940', '2024-06-19', '05:00:00', '10.4', '9', '91.04', '0.3', '25.8', '0', '5.8', '211.1', '999', '100', '24.1', '0', 'cloudy' ),( '93940', '2024-06-19', '06:00:00', '11.2', '9.2', '87.3', '0', '25.8', '0', '5.6', '209.9', '998.3', '100', '24.1', '0', 'cloudy' ),( '93940', '2024-06-19', '07:00:00', '12.1', '9.4', '83.75', '0', '25.8', '0', '5.5', '208.8', '997.7', '99.9', '24.1', '0', 'cloudy' ),( '93940', '2024-06-19', '08:00:00', '13', '9.7', '80.37', '0.9', '25.8', '0', '5.4', '207.6', '997', '99.9', '24.1', '0', 'cloudy' ),( '93940', '2024-06-19', '09:00:00', '13.1', '10', '81.48', '0', '54.8', '0', '5.5', '225.4', '996.7', '99.9', '22.6', '0', 'rain' ),( '93940', '2024-06-19', '10:00:00', '13.3', '10.4', '82.59', '0', '54.8', '0', '5.6', '243.1', '996.3', '100', '21.8', '0', 'rain' ),( '93940', '2024-06-19', '11:00:00', '13.5', '10.8', '83.72', '3', '54.8', '0', '5.8', '260.9', '996', '100', '21.9', '0', 'rain' ),( '93940', '2024-06-19', '12:00:00', '13.8', '10.7', '81.57', '0', '54.8', '0', '6.8', '271.4', '995.7', '98.5', '17.9', '0', 'rain' ),( '93940', '2024-06-19', '13:00:00', '14.2', '10.7', '79.48', '0', '54.8', '0', '7.9', '281.9', '995.3', '97', '11.6', '0', 'rain' ),( '93940', '2024-06-19', '14:00:00', '14.6', '10.7', '77.44', '1.1', '54.8', '0', '9', '292.4', '995', '95.5', '14', '0', 'rain' ),( '93940', '2024-06-19', '15:00:00', '14', '10.7', '80.69', '0', '35.5', '0', '11.8', '296.9', '995.3', '97', '24.1', '1', 'cloudy' ),( '93940', '2024-06-19', '16:00:00', '13.4', '10.8', '84.09', '0', '35.5', '0', '14.5', '301.4', '995.7', '98.5', '24.1', '2', 'cloudy' ),( '93940', '2024-06-19', '17:00:00', '12.9', '10.9', '87.65', '4.6', '35.5', '0', '17.3', '305.9', '996', '100', '24.1', '5', 'cloudy' ),( '93940', '2024-06-19', '18:00:00', '12.1', '9.3', '83', '0', '35.5', '0', '19', '302.8', '996', '100', '24.1', '5', 'cloudy' ),( '93940', '2024-06-19', '19:00:00', '11.3', '7.7', '78.52', '0', '35.5', '0', '20.6', '299.8', '996', '100', '24.1', '4', 'cloudy' ),( '93940', '2024-06-19', '20:00:00', '10.6', '6.2', '74.21', '1.3', '35.5', '0', '22.3', '296.7', '996', '100', '24.1', '2', 'cloudy' ),( '93940', '2024-06-19', '21:00:00', '9.7', '5.1', '73.2', '0', '19.4', '0', '21.8', '297.7', '996.7', '99.9', '24.1', '1', 'cloudy' ),( '93940', '2024-06-19', '22:00:00', '8.8', '4.1', '72.2', '0', '19.4', '0', '21.4', '298.7', '997.3', '99.7', '24.1', '0', 'cloudy' ),( '93940', '2024-06-19', '23:00:00', '8', '3.1', '71.19', '0', '19.4', '0', '20.9', '299.7', '998', '99.6', '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_20 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '93940', '2024-06-20', '00:00:00', '7.4', '2.7', '72.1', '0', '19.4', '0', '20.5', '297.7', '997.7', '99.7', '24.1', '0', 'cloudy' ),( '93940', '2024-06-20', '01:00:00', '6.9', '2.4', '73.03', '0', '19.4', '0', '20.2', '295.8', '997.3', '99.9', '24.1', '0', 'cloudy' ),( '93940', '2024-06-20', '02:00:00', '6.4', '2.1', '73.98', '0', '19.4', '0', '19.8', '293.8', '997', '100', '24.1', '0', 'cloudy' ),( '93940', '2024-06-20', '03:00:00', '6.1', '1.8', '73.94', '0', '12.9', '0', '19.3', '292.9', '997', '94', '24.1', '0', 'cloudy' ),( '93940', '2024-06-20', '04:00:00', '5.9', '1.6', '73.9', '0', '12.9', '0', '18.8', '292.1', '997', '87.9', '24.1', '0', 'partly-cloudy-day' ),( '93940', '2024-06-20', '05:00:00', '5.7', '1.4', '73.86', '0', '12.9', '0', '18.4', '291.2', '997', '81.9', '24.1', '1', 'partly-cloudy-day' ),( '93940', '2024-06-20', '06:00:00', '6.6', '1.9', '72.28', '0', '12.9', '0', '18.4', '293.2', '996.7', '85.1', '24.1', '1', 'partly-cloudy-day' ),( '93940', '2024-06-20', '07:00:00', '7.5', '2.5', '70.76', '0', '12.9', '0', '18.4', '295.3', '996.3', '88.4', '24.1', '2', 'partly-cloudy-day' ),( '93940', '2024-06-20', '08:00:00', '8.4', '3.1', '69.28', '0', '12.9', '0', '18.4', '297.3', '996', '91.6', '24.1', '4', 'cloudy' ),( '93940', '2024-06-20', '09:00:00', '9.2', '3.3', '66.89', '0', '19.4', '0', '18.7', '299.7', '995.7', '92.5', '24.1', '5', 'cloudy' ),( '93940', '2024-06-20', '10:00:00', '9.9', '3.6', '64.59', '0', '19.4', '0', '19.1', '302', '995.3', '93.5', '24.1', '5', 'cloudy' ),( '93940', '2024-06-20', '11:00:00', '10.8', '3.9', '62.39', '0', '19.4', '0', '19.4', '304.4', '995', '94.4', '24.1', '3', 'cloudy' ),( '93940', '2024-06-20', '12:00:00', '12.2', '1.8', '49.01', '0.1', '19.4', '0', '22.7', '305.3', '999', '100', '24.1', '7', 'cloudy' ),( '93940', '2024-06-20', '13:00:00', '11.3', '2.3', '53.9', '0', '19.4', '0', '22.3', '295.7', '999', '99.9', '24.1', '3', 'cloudy' ),( '93940', '2024-06-20', '14:00:00', '11.5', '0.2', '45.74', '0', '19.4', '0', '21.6', '298.2', '999', '94.2', '24.1', '3', 'cloudy' ),( '93940', '2024-06-20', '15:00:00', '11.9', '0.2', '44.66', '0', '29', '0', '21.4', '297.1', '999.3', '91.9', '24.1', '3', 'cloudy' ),( '93940', '2024-06-20', '16:00:00', '12.3', '0.2', '43.6', '0', '29', '0', '21.1', '295.9', '999.7', '89.5', '24.1', '4', 'partly-cloudy-day' ),( '93940', '2024-06-20', '17:00:00', '12.7', '0.3', '42.58', '0', '29', '0', '20.9', '294.8', '1000', '87.2', '24.1', '4', 'partly-cloudy-day' ),( '93940', '2024-06-20', '18:00:00', '11.7', '1.1', '48.08', '0', '29', '0', '23.4', '297.7', '1000.7', '59.8', '24.1', '4', 'partly-cloudy-day' ),( '93940', '2024-06-20', '19:00:00', '10.8', '1.9', '54.29', '0', '29', '0', '25.9', '300.6', '1001.3', '32.4', '24.1', '3', 'partly-cloudy-day' ),( '93940', '2024-06-20', '20:00:00', '9.9', '2.8', '61.31', '0', '29', '0', '28.4', '303.5', '1002', '5', '24.1', '3', 'clear-day' ),( '93940', '2024-06-20', '21:00:00', '9.2', '2.3', '62.31', '0', '12.9', '0', '27.2', '300.9', '1002.3', '36.7', '24.1', '2', 'partly-cloudy-day' ),( '93940', '2024-06-20', '22:00:00', '8.4', '1.9', '63.34', '0', '12.9', '0', '26', '298.2', '1002.7', '68.3', '24.1', '1', 'partly-cloudy-day' ),( '93940', '2024-06-20', '23:00:00', '7.8', '1.5', '64.4', '0', '12.9', '0', '24.8', '295.6', '1003', '100', '24.1', '1', '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_21 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '93940', '2024-06-21', '00:00:00', '7.5', '2.3', '69.44', '0', '12.9', '0', '24.8', '291.6', '1003', '100', '24.1', '0', 'cloudy' ),( '93940', '2024-06-21', '01:00:00', '7.3', '3.1', '74.85', '0', '12.9', '0', '24.8', '287.6', '1003', '100', '24.1', '0', 'cloudy' ),( '93940', '2024-06-21', '02:00:00', '7.1', '4', '80.66', '0', '12.9', '0', '24.8', '283.6', '1003', '100', '24.1', '0', 'cloudy' ),( '93940', '2024-06-21', '03:00:00', '7.2', '4.1', '80.68', '0', '9.7', '0', '25.2', '285.7', '1003', '100', '24.1', '0', 'cloudy' ),( '93940', '2024-06-21', '04:00:00', '7.4', '4.3', '80.7', '0', '9.7', '0', '25.6', '287.9', '1003', '100', '24.1', '0', 'cloudy' ),( '93940', '2024-06-21', '05:00:00', '7.6', '4.5', '80.73', '0', '9.7', '0', '25.9', '290', '1003', '100', '24.1', '0', 'cloudy' ),( '93940', '2024-06-21', '06:00:00', '8.1', '4.7', '79.13', '0', '9.7', '0', '25.7', '289.5', '1002.7', '100', '24.1', '0', 'cloudy' ),( '93940', '2024-06-21', '07:00:00', '8.6', '4.9', '77.57', '0', '9.7', '0', '25.4', '288.9', '1002.3', '100', '24.1', '0', 'cloudy' ),( '93940', '2024-06-21', '08:00:00', '9.2', '5.2', '76.05', '0', '9.7', '0', '25.2', '288.4', '1002', '100', '24.1', '0', 'cloudy' ),( '93940', '2024-06-21', '09:00:00', '10.9', '5', '67.09', '0', '19.4', '0', '24.2', '292.6', '1002', '95.9', '24.1', '1', 'cloudy' ),( '93940', '2024-06-21', '10:00:00', '12.6', '4.8', '59.28', '0', '19.4', '0', '23.3', '296.7', '1002', '91.7', '24.1', '2', 'cloudy' ),( '93940', '2024-06-21', '11:00:00', '14.3', '4.7', '52.45', '0', '19.4', '0', '22.3', '300.9', '1002', '87.6', '24.1', '3', 'partly-cloudy-day' ),( '93940', '2024-06-21', '12:00:00', '15.5', '4.6', '48.22', '0', '19.4', '0', '22.4', '300.8', '1002', '64.4', '24.1', '4', 'partly-cloudy-day' ),( '93940', '2024-06-21', '13:00:00', '16.7', '4.5', '44.37', '0', '19.4', '0', '22.6', '300.6', '1002', '41.2', '24.1', '5', 'partly-cloudy-day' ),( '93940', '2024-06-21', '14:00:00', '18', '4.5', '40.85', '0', '19.4', '0', '22.7', '300.5', '1002', '18', '24.1', '7', 'clear-day' ),( '93940', '2024-06-21', '15:00:00', '18.2', '4.6', '40.81', '0', '19.4', '0', '21.6', '298.4', '1002', '14.8', '24.1', '7', 'clear-day' ),( '93940', '2024-06-21', '16:00:00', '18.4', '4.8', '40.77', '0', '19.4', '0', '20.5', '296.2', '1002', '11.7', '24.1', '7', 'clear-day' ),( '93940', '2024-06-21', '17:00:00', '18.6', '5', '40.74', '0', '19.4', '0', '19.4', '294.1', '1002', '8.5', '24.1', '7', 'clear-day' ),( '93940', '2024-06-21', '18:00:00', '17.7', '5.4', '44.43', '0', '19.4', '0', '18.5', '290.8', '1002.3', '5.7', '24.1', '6', 'clear-day' ),( '93940', '2024-06-21', '19:00:00', '16.8', '5.8', '48.46', '0', '19.4', '0', '17.5', '287.5', '1002.7', '2.8', '24.1', '5', 'clear-day' ),( '93940', '2024-06-21', '20:00:00', '15.9', '6.3', '52.88', '0', '19.4', '0', '16.6', '284.2', '1003', '0', '24.1', '4', 'clear-day' ),( '93940', '2024-06-21', '21:00:00', '14', '6', '58.8', '0', '6.5', '0', '14.3', '287.9', '1003.3', '0.1', '24.1', '3', 'clear-day' ),( '93940', '2024-06-21', '22:00:00', '12.1', '5.8', '65.51', '0', '6.5', '0', '12', '291.7', '1003.7', '0.1', '24.1', '2', 'clear-day' ),( '93940', '2024-06-21', '23:00:00', '10.2', '5.6', '73.12', '0', '6.5', '0', '9.7', '295.4', '1004', '0.2', '24.1', '1', 'clear-day' ) 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 ( '93940', '2024-06-22', '00:00:00', '9.1', '5.4', '78', '0', '6.5', '0', '8.5', '301.7', '1003.7', '0.1', '24.1', '0', 'clear-night' ),( '93940', '2024-06-22', '01:00:00', '8', '5.3', '83.25', '0', '6.5', '0', '7.3', '307.9', '1003.3', '0.1', '24.1', '0', 'clear-night' ),( '93940', '2024-06-22', '02:00:00', '6.9', '5.2', '88.92', '0', '6.5', '0', '6.1', '314.2', '1003', '0', '24.1', '0', 'clear-night' ),( '93940', '2024-06-22', '03:00:00', '7.4', '5.3', '86.34', '0', '6.5', '0', '5.5', '305.8', '1003.3', '0', '24.1', '0', 'clear-day' ),( '93940', '2024-06-22', '04:00:00', '8', '5.4', '83.84', '0', '6.5', '0', '4.9', '297.5', '1003.7', '0', '24.1', '0', 'clear-day' ),( '93940', '2024-06-22', '05:00:00', '8.6', '5.6', '81.43', '0', '6.5', '0', '4.3', '289.1', '1004', '0', '24.1', '0', 'clear-day' ),( '93940', '2024-06-22', '06:00:00', '10.2', '5.4', '71.95', '0', '6.5', '0', '6.2', '304.3', '1004', '0', '24.1', '1', 'clear-day' ),( '93940', '2024-06-22', '07:00:00', '11.8', '5.2', '63.67', '0', '6.5', '0', '8.2', '319.4', '1004', '0', '24.1', '2', 'clear-day' ),( '93940', '2024-06-22', '08:00:00', '13.5', '5', '56.42', '0', '6.5', '0', '10.1', '334.6', '1004', '0', '24.1', '3', 'clear-day' ),( '93940', '2024-06-22', '09:00:00', '14.9', '4', '48.16', '0', '19.4', '0', '9.5', '340.1', '1003.7', '0', '24.1', '4', 'clear-day' ),( '93940', '2024-06-22', '10:00:00', '16.3', '3', '41.13', '0', '19.4', '0', '8.9', '345.7', '1003.3', '0', '24.1', '5', 'clear-day' ),( '93940', '2024-06-22', '11:00:00', '17.7', '2.1', '35.14', '0', '19.4', '0', '8.3', '351.2', '1003', '0', '24.1', '6', 'clear-day' ),( '93940', '2024-06-22', '12:00:00', '18.9', '1.9', '32.07', '0', '19.4', '0', '6.8', '339.5', '1003', '0', '24.1', '7', 'clear-day' ),( '93940', '2024-06-22', '13:00:00', '20.2', '1.7', '29.29', '0', '19.4', '0', '5.4', '327.7', '1003', '0', '24.1', '7', 'clear-day' ),( '93940', '2024-06-22', '14:00:00', '21.5', '1.6', '26.78', '0', '19.4', '0', '4', '316', '1003', '0', '24.1', '8', 'clear-day' ),( '93940', '2024-06-22', '15:00:00', '21.4', '1.4', '26.45', '0', '16.1', '0', '4.2', '299.1', '1002.7', '1', '24.1', '7', 'clear-day' ),( '93940', '2024-06-22', '16:00:00', '21.4', '1.2', '26.12', '0', '16.1', '0', '4.4', '282.1', '1002.3', '2', '24.1', '7', 'clear-day' ),( '93940', '2024-06-22', '17:00:00', '21.4', '1', '25.8', '0', '16.1', '0', '4.7', '265.2', '1002', '3', '24.1', '7', 'clear-day' ),( '93940', '2024-06-22', '18:00:00', '20.3', '3.1', '32.09', '0', '16.1', '0', '6.1', '244.7', '1002.3', '2.1', '24.1', '6', 'clear-day' ),( '93940', '2024-06-22', '19:00:00', '19.3', '5.3', '39.83', '0', '16.1', '0', '7.6', '224.3', '1002.7', '1.1', '24.1', '5', 'clear-day' ),( '93940', '2024-06-22', '20:00:00', '18.3', '7.5', '49.32', '0', '16.1', '0', '9', '203.8', '1003', '0.2', '24.1', '4', 'clear-day' ),( '93940', '2024-06-22', '21:00:00', '15.8', '7.8', '58.99', '0', '16.1', '0', '8.6', '196.1', '1003.3', '1.9', '24.1', '3', 'clear-day' ),( '93940', '2024-06-22', '22:00:00', '13.4', '8.2', '70.77', '0', '16.1', '0', '8.3', '188.4', '1003.7', '3.7', '24.1', '2', 'clear-day' ),( '93940', '2024-06-22', '23:00:00', '11', '8.6', '85.14', '0', '16.1', '0', '7.9', '180.7', '1004', '5.4', '24.1', '1', 'clear-day' ) 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 ( '93940', '2024-06-23', '00:00:00', '10.9', '8.2', '83.05', '0', '16.1', '0', '7', '183.5', '1004.3', '25.4', '24.1', '0', 'partly-cloudy-night' ),( '93940', '2024-06-23', '01:00:00', '10.9', '7.8', '81', '0', '16.1', '0', '6', '186.4', '1004.7', '45.5', '24.1', '0', 'partly-cloudy-night' ),( '93940', '2024-06-23', '02:00:00', '10.9', '7.4', '78.99', '0', '16.1', '0', '5', '189.2', '1005', '65.5', '24.1', '0', 'partly-cloudy-night' ),( '93940', '2024-06-23', '03:00:00', '11', '7.5', '79.02', '0', '9.7', '0', '3.7', '194.1', '1005.3', '55.2', '24.1', '0', 'partly-cloudy-day' ),( '93940', '2024-06-23', '04:00:00', '11.2', '7.7', '79.04', '0', '9.7', '0', '2.4', '198.9', '1005.7', '44.8', '24.1', '0', 'partly-cloudy-day' ),( '93940', '2024-06-23', '05:00:00', '11.4', '7.9', '79.06', '0', '9.7', '0', '1.1', '203.8', '1006', '34.5', '24.1', '0', 'partly-cloudy-day' ),( '93940', '2024-06-23', '06:00:00', '13.3', '7.9', '70.1', '0', '9.7', '0', '1.6', '233.9', '1006.3', '31.6', '24.1', '1', 'partly-cloudy-day' ),( '93940', '2024-06-23', '07:00:00', '15.2', '8', '62.27', '0', '9.7', '0', '2', '263.9', '1006.7', '28.7', '24.1', '2', 'partly-cloudy-day' ),( '93940', '2024-06-23', '08:00:00', '17.1', '8.1', '55.41', '0', '9.7', '0', '2.5', '294', '1007', '25.8', '24.1', '3', 'partly-cloudy-day' ),( '93940', '2024-06-23', '09:00:00', '18.4', '7.6', '49.15', '0', '22.6', '0', '3.5', '276.7', '1007', '25.9', '24.1', '4', 'partly-cloudy-day' ),( '93940', '2024-06-23', '10:00:00', '19.9', '7.1', '43.63', '0', '22.6', '0', '4.4', '259.5', '1007', '26', '24.1', '5', 'partly-cloudy-day' ),( '93940', '2024-06-23', '11:00:00', '21.3', '6.7', '38.76', '0', '22.6', '0', '5.4', '242.2', '1007', '26.1', '24.1', '6', 'partly-cloudy-day' ),( '93940', '2024-06-23', '12:00:00', '21.6', '6.4', '37.3', '0', '22.6', '0', '6.5', '246.8', '1007.3', '50.7', '24.1', '6', 'partly-cloudy-day' ),( '93940', '2024-06-23', '13:00:00', '22', '6.2', '35.89', '0', '22.6', '0', '7.6', '251.5', '1007.7', '75.4', '24.1', '7', 'partly-cloudy-day' ),( '93940', '2024-06-23', '14:00:00', '22.4', '6', '34.54', '0', '22.6', '0', '8.6', '256.1', '1008', '100', '24.1', '7', 'cloudy' ),( '93940', '2024-06-23', '15:00:00', '22.5', '6.1', '34.5', '0', '16.1', '0', '8.2', '245', '1008', '79.9', '24.1', '7', 'partly-cloudy-day' ),( '93940', '2024-06-23', '16:00:00', '22.6', '6.2', '34.45', '0', '16.1', '0', '7.7', '233.8', '1008', '59.7', '24.1', '6', 'partly-cloudy-day' ),( '93940', '2024-06-23', '17:00:00', '22.8', '6.3', '34.41', '0', '16.1', '0', '7.2', '222.7', '1008', '39.6', '24.1', '6', 'partly-cloudy-day' ),( '93940', '2024-06-23', '18:00:00', '21.6', '7.6', '40.57', '0', '16.1', '0', '9.4', '207.4', '1008.7', '31.2', '24.1', '5', 'partly-cloudy-day' ),( '93940', '2024-06-23', '19:00:00', '20.4', '8.9', '47.81', '0', '16.1', '0', '11.5', '192.1', '1009.3', '22.8', '24.1', '4', 'partly-cloudy-day' ),( '93940', '2024-06-23', '20:00:00', '19.2', '10.3', '56.32', '0', '16.1', '0', '13.7', '176.8', '1010', '14.4', '24.1', '3', 'clear-day' ),( '93940', '2024-06-23', '21:00:00', '17.1', '10.1', '63.55', '0', '9.7', '0', '11.6', '179.7', '1010.3', '20.8', '24.1', '2', 'partly-cloudy-day' ),( '93940', '2024-06-23', '22:00:00', '15', '9.9', '71.87', '0', '9.7', '0', '9.6', '182.6', '1010.7', '27.1', '24.1', '2', 'partly-cloudy-day' ),( '93940', '2024-06-23', '23:00:00', '12.9', '9.8', '81.44', '0', '9.7', '0', '7.6', '185.5', '1011', '33.5', '24.1', '1', 'partly-cloudy-day' ) 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 ( '93940', '2024-06-24', '00:00:00', '12', '9.6', '84.87', '0', '9.7', '0', '6.4', '207.9', '1011.7', '23.8', '24.1', '0', 'partly-cloudy-night' ),( '93940', '2024-06-24', '01:00:00', '11.2', '9.4', '88.48', '0', '9.7', '0', '5.2', '230.4', '1012.3', '14.1', '24.1', '0', 'clear-night' ),( '93940', '2024-06-24', '02:00:00', '10.4', '9.2', '92.27', '0', '9.7', '0', '4', '252.8', '1013', '4.4', '24.1', '0', 'clear-night' ),( '93940', '2024-06-24', '03:00:00', '11', '8.8', '86.5', '0', '16.1', '0', '3.8', '255.3', '1013.3', '14.6', '24.1', '0', 'clear-day' ),( '93940', '2024-06-24', '04:00:00', '11.6', '8.5', '81.1', '0', '16.1', '0', '3.7', '257.9', '1013.7', '24.8', '24.1', '0', 'partly-cloudy-day' ),( '93940', '2024-06-24', '05:00:00', '12.3', '8.2', '76.04', '0', '16.1', '0', '3.6', '260.4', '1014', '35', '24.1', '0', 'partly-cloudy-day' ),( '93940', '2024-06-24', '06:00:00', '13.9', '7.4', '64.58', '0', '16.1', '0', '4.9', '266.2', '1014', '56.7', '24.1', '1', 'partly-cloudy-day' ),( '93940', '2024-06-24', '07:00:00', '15.6', '6.6', '54.91', '0', '16.1', '0', '6.2', '271.9', '1014', '78.3', '24.1', '2', 'partly-cloudy-day' ),( '93940', '2024-06-24', '08:00:00', '17.3', '5.8', '46.73', '0', '16.1', '0', '7.6', '277.7', '1014', '100', '24.1', '2', 'cloudy' ),( '93940', '2024-06-24', '09:00:00', '17.4', '5.4', '45.39', '0', '25.8', '0', '7.6', '271.2', '1014.3', '100', '24.1', '3', 'cloudy' ),( '93940', '2024-06-24', '10:00:00', '17.5', '5.2', '44.08', '0', '25.8', '0', '7.6', '264.7', '1014.7', '100', '24.1', '3', 'cloudy' ),( '93940', '2024-06-24', '11:00:00', '17.7', '4.9', '42.81', '0.1', '25.8', '0', '7.6', '258.2', '1015', '100', '24.1', '3', 'cloudy' ),( '93940', '2024-06-24', '12:00:00', '18.9', '4.7', '39.07', '0', '25.8', '0', '8.6', '262.2', '1015', '100', '24.1', '3', 'cloudy' ),( '93940', '2024-06-24', '13:00:00', '20.1', '4.4', '35.69', '0', '25.8', '0', '9.7', '266.1', '1015', '100', '24.1', '4', 'cloudy' ),( '93940', '2024-06-24', '14:00:00', '21.4', '4.3', '32.62', '0', '25.8', '0', '10.8', '270.1', '1015', '100', '24.1', '5', 'cloudy' ),( '93940', '2024-06-24', '15:00:00', '21.8', '3.3', '29.62', '0', '35.5', '0', '10.7', '281', '1015', '72.7', '24.1', '5', 'partly-cloudy-day' ),( '93940', '2024-06-24', '16:00:00', '22.3', '2.3', '26.88', '0', '35.5', '0', '10.6', '291.8', '1015', '45.4', '24.1', '6', 'partly-cloudy-day' ),( '93940', '2024-06-24', '17:00:00', '22.8', '1.4', '24.38', '0', '35.5', '0', '10.4', '302.7', '1015', '18.1', '24.1', '6', 'clear-day' ),( '93940', '2024-06-24', '18:00:00', '22', '3.1', '28.9', '0', '35.5', '0', '8.8', '308.8', '1015', '14', '24.1', '5', 'clear-day' ),( '93940', '2024-06-24', '19:00:00', '21.2', '4.8', '34.21', '0', '35.5', '0', '7.1', '315', '1015', '9.9', '24.1', '4', 'clear-day' ),( '93940', '2024-06-24', '20:00:00', '20.5', '6.6', '40.44', '0', '35.5', '0', '5.4', '321.1', '1015', '5.8', '24.1', '4', 'clear-day' ),( '93940', '2024-06-24', '21:00:00', '18.2', '5.9', '44.77', '0', '32.3', '0', '5.9', '314.5', '1015.7', '32.2', '24.1', '3', 'partly-cloudy-day' ),( '93940', '2024-06-24', '22:00:00', '15.9', '5.4', '49.69', '0', '32.3', '0', '6.4', '307.8', '1016.3', '58.5', '24.1', '2', 'partly-cloudy-day' ),( '93940', '2024-06-24', '23:00:00', '13.6', '4.8', '55.27', '0', '32.3', '0', '6.8', '301.2', '1017', '84.9', '24.1', '1', 'partly-cloudy-day' ) 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 ( '93940', '2024-06-25', '00:00:00', '12.8', '4.8', '58.38', '0', '32.3', '0', '6.6', '301.3', '1017.3', '89.8', '24.1', '0', 'partly-cloudy-night' ),( '93940', '2024-06-25', '01:00:00', '12', '4.9', '61.68', '0', '32.3', '0', '6.4', '301.5', '1017.7', '94.7', '24.1', '0', 'cloudy' ),( '93940', '2024-06-25', '02:00:00', '11.3', '5', '65.18', '0', '32.3', '0', '6.1', '301.6', '1018', '99.6', '24.1', '0', 'cloudy' ),( '93940', '2024-06-25', '03:00:00', '11.4', '5.6', '67.21', '0', '9.7', '0', '5.6', '313.7', '1018.3', '99.7', '24.1', '0', 'cloudy' ),( '93940', '2024-06-25', '04:00:00', '11.6', '6.2', '69.29', '0', '9.7', '0', '5.2', '325.8', '1018.7', '99.9', '24.1', '0', 'cloudy' ),( '93940', '2024-06-25', '05:00:00', '11.8', '6.8', '71.42', '0', '9.7', '0', '4.7', '337.9', '1019', '100', '24.1', '0', 'cloudy' ),( '93940', '2024-06-25', '06:00:00', '13.5', '7.1', '65.38', '0', '9.7', '0', '4.8', '253.7', '1019', '98.9', '24.1', '1', 'cloudy' ),( '93940', '2024-06-25', '07:00:00', '15.2', '7.5', '59.93', '0', '9.7', '0', '4.9', '169.6', '1019', '97.7', '24.1', '2', 'cloudy' ),( '93940', '2024-06-25', '08:00:00', '17', '7.9', '55.01', '0', '9.7', '0', '5', '85.4', '1019', '96.6', '24.1', '2', 'cloudy' ),( '93940', '2024-06-25', '09:00:00', '18.4', '8.2', '51.19', '0', '12.9', '0', '5.2', '96.3', '1019', '73.2', '24.1', '3', 'partly-cloudy-day' ),( '93940', '2024-06-25', '10:00:00', '19.9', '8.4', '47.68', '0', '12.9', '0', '5.3', '107.2', '1019', '49.9', '24.1', '5', 'partly-cloudy-day' ),( '93940', '2024-06-25', '11:00:00', '21.4', '8.8', '44.45', '0', '12.9', '0', '5.4', '118.1', '1019', '26.5', '24.1', '6', 'partly-cloudy-day' ),( '93940', '2024-06-25', '12:00:00', '22', '8.4', '41.73', '0', '12.9', '0', '4.2', '135.3', '1018.7', '50.4', '24.1', '6', 'partly-cloudy-day' ),( '93940', '2024-06-25', '13:00:00', '22.7', '8.1', '39.17', '0', '12.9', '0', '3', '152.5', '1018.3', '74.4', '24.1', '6', 'partly-cloudy-day' ),( '93940', '2024-06-25', '14:00:00', '23.4', '7.8', '36.78', '0', '12.9', '0', '1.8', '169.7', '1018', '98.3', '24.1', '7', 'cloudy' ),( '93940', '2024-06-25', '15:00:00', '21.7', '8.6', '42.97', '0', '19.4', '0', '5.3', '155.5', '1018.3', '98.9', '24.1', '5', 'cloudy' ),( '93940', '2024-06-25', '16:00:00', '20', '9.4', '50.25', '0', '19.4', '0', '8.8', '141.4', '1018.7', '99.4', '24.1', '3', 'cloudy' ),( '93940', '2024-06-25', '17:00:00', '18.4', '10.2', '58.82', '0', '19.4', '0', '12.2', '127.2', '1019', '100', '24.1', '1', 'cloudy' ),( '93940', '2024-06-25', '18:00:00', '18.1', '10.1', '59.54', '0', '19.4', '0', '12.1', '134.3', '1019.3', '100', '24.1', '1', 'cloudy' ),( '93940', '2024-06-25', '19:00:00', '17.8', '10', '60.28', '0', '19.4', '0', '12', '141.5', '1019.7', '100', '24.1', '1', 'cloudy' ),( '93940', '2024-06-25', '20:00:00', '17.6', '10', '61.03', '0', '19.4', '0', '11.9', '148.6', '1020', '100', '24.1', '1', 'cloudy' ),( '93940', '2024-06-25', '21:00:00', '15.9', '9.7', '66.49', '0', '12.9', '0', '10.4', '147.2', '1020.3', '68.3', '24.1', '1', 'partly-cloudy-day' ),( '93940', '2024-06-25', '22:00:00', '14.2', '9.4', '72.54', '0', '12.9', '0', '9', '145.8', '1020.7', '36.7', '24.1', '1', 'partly-cloudy-day' ),( '93940', '2024-06-25', '23:00:00', '12.6', '9.1', '79.24', '0', '12.9', '0', '7.6', '144.4', '1021', '5', '24.1', '0', 'clear-day' ) 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 ( '93940', '2024-06-26', '00:00:00', '12.4', '9', '79.93', '0', '12.9', '0', '6.6', '186.3', '1021', '36.3', '24.1', '0', 'partly-cloudy-night' ),( '93940', '2024-06-26', '01:00:00', '12.2', '8.9', '80.62', '0', '12.9', '0', '5.6', '228.2', '1021', '67.7', '24.1', '0', 'partly-cloudy-night' ),( '93940', '2024-06-26', '02:00:00', '12', '8.9', '81.32', '0', '12.9', '0', '4.7', '270.1', '1021', '99', '24.1', '0', 'cloudy' ),( '93940', '2024-06-26', '03:00:00', '12.5', '8.9', '78.69', '0', '12.9', '0', '7.4', '275.3', '1021', '99.3', '24.1', '0', 'cloudy' ),( '93940', '2024-06-26', '04:00:00', '13', '8.9', '76.16', '0', '12.9', '0', '10.2', '280.6', '1021', '99.7', '24.1', '0', 'cloudy' ),( '93940', '2024-06-26', '05:00:00', '13.5', '8.9', '73.71', '0', '12.9', '0', '13', '285.8', '1021', '100', '24.1', '0', 'cloudy' ),( '93940', '2024-06-26', '06:00:00', '14.1', '9.1', '72.02', '0', '12.9', '0', '14.8', '290', '1021', '100', '24.1', '0', 'cloudy' ),( '93940', '2024-06-26', '07:00:00', '14.7', '9.3', '70.38', '0', '12.9', '0', '16.6', '294.3', '1021', '100', '24.1', '1', 'cloudy' ),( '93940', '2024-06-26', '08:00:00', '15.3', '9.6', '68.78', '0', '12.9', '0', '18.4', '298.5', '1021', '100', '24.1', '1', 'cloudy' ),( '93940', '2024-06-26', '09:00:00', '16.4', '7.1', '53.77', '0', '29', '0', '18.8', '304.3', '1021.3', '100', '24.1', '2', 'cloudy' ),( '93940', '2024-06-26', '10:00:00', '17.7', '4.6', '41.92', '0', '29', '0', '19.3', '310.2', '1021.7', '100', '24.1', '3', 'cloudy' ),( '93940', '2024-06-26', '11:00:00', '18.9', '2.1', '32.59', '0', '29', '0', '19.8', '316', '1022', '100', '24.1', '4', 'cloudy' ),( '93940', '2024-06-26', '12:00:00', '19.4', '2.2', '31.9', '0', '29', '0', '19.6', '313.2', '1021.7', '100', '24.1', '5', 'cloudy' ),( '93940', '2024-06-26', '13:00:00', '19.9', '2.4', '31.23', '0', '29', '0', '19.3', '310.5', '1021.3', '100', '24.1', '6', 'cloudy' ),( '93940', '2024-06-26', '14:00:00', '20.5', '2.6', '30.58', '0', '29', '0', '19.1', '307.7', '1021', '100', '24.1', '6', 'cloudy' ),( '93940', '2024-06-26', '15:00:00', '21', '2.7', '29.8', '0', '35.5', '0', '18.2', '305.5', '1021', '68.3', '24.1', '6', 'partly-cloudy-day' ),( '93940', '2024-06-26', '16:00:00', '21.5', '2.8', '29.05', '0', '35.5', '0', '17.4', '303.3', '1021', '36.7', '24.1', '6', 'partly-cloudy-day' ),( '93940', '2024-06-26', '17:00:00', '22.1', '2.9', '28.32', '0', '35.5', '0', '16.6', '301.1', '1021', '5', '24.1', '6', 'clear-day' ),( '93940', '2024-06-26', '18:00:00', '21.3', '3.6', '31.33', '0', '35.5', '0', '16', '300.8', '1021', '7.6', '24.1', '5', 'clear-day' ),( '93940', '2024-06-26', '19:00:00', '20.5', '4.4', '34.65', '0', '35.5', '0', '15.4', '300.4', '1021', '10.2', '24.1', '4', 'clear-day' ),( '93940', '2024-06-26', '20:00:00', '19.8', '5.2', '38.33', '0', '35.5', '0', '14.8', '300.1', '1021', '12.8', '24.1', '4', 'clear-day' ),( '93940', '2024-06-26', '21:00:00', '17.7', '5.1', '43.41', '0', '19.4', '0', '13', '299.9', '1021.7', '10.2', '24.1', '3', 'clear-day' ),( '93940', '2024-06-26', '22:00:00', '15.6', '5', '49.26', '0', '19.4', '0', '11.2', '299.6', '1022.3', '7.6', '24.1', '2', 'clear-day' ),( '93940', '2024-06-26', '23:00:00', '13.5', '4.9', '56.02', '0', '19.4', '0', '9.4', '299.4', '1023', '5', '24.1', '1', 'clear-day' ) 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 ( '93940', '2024-06-27', '00:00:00', '12.4', '4.8', '59.79', '0', '19.4', '0', '8.4', '298.6', '1023', '5', '24.1', '0', 'clear-night' ),( '93940', '2024-06-27', '01:00:00', '11.3', '4.7', '63.85', '0', '19.4', '0', '7.4', '297.7', '1023', '5', '24.1', '0', 'clear-night' ),( '93940', '2024-06-27', '02:00:00', '10.3', '4.7', '68.23', '0', '19.4', '0', '6.5', '296.9', '1023', '5', '24.1', '0', 'clear-night' ),( '93940', '2024-06-27', '03:00:00', '10.6', '5', '67.99', '0', '12.9', '0', '6', '295.5', '1023', '5.1', '24.1', '0', 'clear-day' ),( '93940', '2024-06-27', '04:00:00', '11', '5.3', '67.75', '0', '12.9', '0', '5.5', '294', '1023', '5.1', '24.1', '0', 'clear-day' ),( '93940', '2024-06-27', '05:00:00', '11.4', '5.6', '67.51', '0', '12.9', '0', '5', '292.6', '1023', '5.2', '24.1', '0', 'clear-day' ),( '93940', '2024-06-27', '06:00:00', '13.1', '5.6', '60.24', '0', '12.9', '0', '6', '293.1', '1022.7', '5.1', '24.1', '1', 'clear-day' ),( '93940', '2024-06-27', '07:00:00', '14.8', '5.6', '53.83', '0', '12.9', '0', '7', '293.5', '1022.3', '5', '24.1', '2', 'clear-day' ),( '93940', '2024-06-27', '08:00:00', '16.6', '5.6', '48.18', '0', '12.9', '0', '7.9', '294', '1022', '4.9', '24.1', '3', 'clear-day' ),( '93940', '2024-06-27', '09:00:00', '17.9', '5.4', '43.59', '0', '22.6', '0', '8.5', '290.7', '1021.7', '3.3', '24.1', '4', 'clear-day' ),( '93940', '2024-06-27', '10:00:00', '19.4', '5.2', '39.48', '0', '22.6', '0', '9.1', '287.3', '1021.3', '1.7', '24.1', '5', 'clear-day' ),( '93940', '2024-06-27', '11:00:00', '20.8', '5.1', '35.79', '0', '22.6', '0', '9.7', '284', '1021', '0.1', '24.1', '6', 'clear-day' ),( '93940', '2024-06-27', '12:00:00', '21.8', '4.6', '32.5', '0', '22.6', '0', '10.7', '289.5', '1020.7', '0.8', '24.1', '6', 'clear-day' ),( '93940', '2024-06-27', '13:00:00', '22.8', '4.1', '29.53', '0', '22.6', '0', '11.6', '295', '1020.3', '1.6', '24.1', '7', 'clear-day' ),( '93940', '2024-06-27', '14:00:00', '23.8', '3.6', '26.84', '0', '22.6', '0', '12.6', '300.5', '1020', '2.3', '24.1', '8', 'clear-day' ),( '93940', '2024-06-27', '15:00:00', '24', '4.4', '28.07', '0', '22.6', '0', '13.1', '302.7', '1019.7', '3.7', '24.1', '7', 'clear-day' ),( '93940', '2024-06-27', '16:00:00', '24.3', '5.3', '29.35', '0', '22.6', '0', '13.6', '304.9', '1019.3', '5.2', '24.1', '7', 'clear-day' ),( '93940', '2024-06-27', '17:00:00', '24.6', '6.2', '30.67', '0', '22.6', '0', '14', '307.1', '1019', '6.6', '24.1', '7', 'clear-day' ),( '93940', '2024-06-27', '18:00:00', '23.8', '6.7', '33.3', '0', '22.6', '0', '13.9', '301.3', '1019', '4.4', '24.1', '6', 'clear-day' ),( '93940', '2024-06-27', '19:00:00', '23', '7.2', '36.17', '0', '22.6', '0', '13.8', '295.4', '1019', '2.2', '24.1', '5', 'clear-day' ),( '93940', '2024-06-27', '20:00:00', '22.2', '7.7', '39.29', '0', '22.6', '0', '13.7', '289.6', '1019', '0', '24.1', '4', 'clear-day' ),( '93940', '2024-06-27', '21:00:00', '19.9', '7.8', '45.56', '0', '19.4', '0', '11.6', '291.9', '1019.3', '0', '24.1', '3', 'clear-day' ),( '93940', '2024-06-27', '22:00:00', '17.6', '7.9', '52.97', '0', '19.4', '0', '9.6', '294.3', '1019.7', '0', '24.1', '2', 'clear-day' ),( '93940', '2024-06-27', '23:00:00', '15.3', '8', '61.73', '0', '19.4', '0', '7.6', '296.6', '1020', '0', '24.1', '1', 'clear-day' ) 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 ( '93940', '2024-06-28', '00:00:00', '14.4', '7.9', '64.7', '0', '19.4', '0', '7.3', '300', '1020.3', '0', '24.1', '0', 'clear-night' ),( '93940', '2024-06-28', '01:00:00', '13.6', '7.8', '67.82', '0', '19.4', '0', '7.1', '303.3', '1020.7', '0', '24.1', '0', 'clear-night' ),( '93940', '2024-06-28', '02:00:00', '12.8', '7.7', '71.13', '0', '19.4', '0', '6.8', '306.7', '1021', '0', '24.1', '0', 'clear-night' ),( '93940', '2024-06-28', '03:00:00', '13', '7.9', '71.01', '0', '16.1', '0', '6.6', '302.5', '1021', '0', '24.1', '0', 'clear-day' ),( '93940', '2024-06-28', '04:00:00', '13.2', '8.1', '70.9', '0', '16.1', '0', '6.4', '298.3', '1021', '0', '24.1', '0', 'clear-day' ),( '93940', '2024-06-28', '05:00:00', '13.5', '8.3', '70.78', '0', '16.1', '0', '6.1', '294.1', '1021', '0', '24.1', '0', 'clear-day' ),( '93940', '2024-06-28', '06:00:00', '15', '8.1', '63.38', '0', '16.1', '0', '7.2', '297.8', '1020.7', '0', '24.1', '1', 'clear-day' ),( '93940', '2024-06-28', '07:00:00', '16.6', '8', '56.82', '0', '16.1', '0', '8.3', '301.5', '1020.3', '0', '24.1', '2', 'clear-day' ),( '93940', '2024-06-28', '08:00:00', '18.2', '7.9', '51', '0', '16.1', '0', '9.4', '305.2', '1020', '0', '24.1', '3', 'clear-day' ),( '93940', '2024-06-28', '09:00:00', '19.6', '7.2', '44.56', '0', '51.6', '0', '9.5', '307.3', '1020', '0', '24.1', '4', 'showers-day' ),( '93940', '2024-06-28', '10:00:00', '21', '6.5', '38.96', '0', '51.6', '0', '9.6', '309.4', '1020', '0', '24.1', '5', 'showers-day' ),( '93940', '2024-06-28', '11:00:00', '22.5', '5.9', '34.09', '0', '51.6', '0', '9.7', '311.5', '1020', '0', '24.1', '6', 'showers-day' ),( '93940', '2024-06-28', '12:00:00', '23.4', '5.7', '31.84', '0', '51.6', '0', '9.8', '308.9', '1019.7', '1.7', '24.1', '6', 'showers-day' ),( '93940', '2024-06-28', '13:00:00', '24.3', '5.4', '29.75', '0', '51.6', '0', '10', '306.4', '1019.3', '3.3', '24.1', '7', 'showers-day' ),( '93940', '2024-06-28', '14:00:00', '25.2', '5.3', '27.8', '0', '51.6', '0', '10.1', '303.8', '1019', '5', '24.1', '8', 'showers-day' ),( '93940', '2024-06-28', '15:00:00', '25.5', '5.2', '27.19', '0', '35.5', '0', '10.2', '305.3', '1018.7', '21.8', '24.1', '7', 'partly-cloudy-day' ),( '93940', '2024-06-28', '16:00:00', '25.8', '5.2', '26.6', '0', '35.5', '0', '10.3', '306.8', '1018.3', '38.5', '24.1', '7', 'partly-cloudy-day' ),( '93940', '2024-06-28', '17:00:00', '26.2', '5.2', '26.02', '0', '35.5', '0', '10.4', '308.3', '1018', '55.3', '24.1', '7', 'partly-cloudy-day' ),( '93940', '2024-06-28', '18:00:00', '25.3', '6.8', '30.6', '0', '35.5', '0', '9.4', '303.2', '1018', '41.4', '24.1', '5', 'partly-cloudy-day' ),( '93940', '2024-06-28', '19:00:00', '24.5', '8.4', '35.95', '0', '35.5', '0', '8.3', '298.1', '1018', '27.5', '24.1', '4', 'partly-cloudy-day' ),( '93940', '2024-06-28', '20:00:00', '23.7', '10.1', '42.18', '0', '35.5', '0', '7.2', '293', '1018', '13.6', '24.1', '3', 'clear-day' ),( '93940', '2024-06-28', '21:00:00', '21.5', '10', '48.11', '0', '22.6', '0', '7', '295.5', '1018.3', '36.5', '24.1', '2', 'partly-cloudy-day' ),( '93940', '2024-06-28', '22:00:00', '19.3', '10', '54.98', '0', '22.6', '0', '6.7', '298', '1018.7', '59.5', '24.1', '2', 'partly-cloudy-day' ),( '93940', '2024-06-28', '23:00:00', '17.1', '10', '62.99', '0', '22.6', '0', '6.5', '300.5', '1019', '82.4', '24.1', '1', 'partly-cloudy-day' ) 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 ( '93940', '2024-06-29', '00:00:00', '16.2', '9.6', '64.94', '0', '22.6', '0', '6.2', '303', '1019.3', '71.5', '24.1', '0', 'partly-cloudy-night' ),( '93940', '2024-06-29', '01:00:00', '15.3', '9.2', '66.97', '0', '22.6', '0', '6', '305.4', '1019.7', '60.7', '24.1', '0', 'partly-cloudy-night' ),( '93940', '2024-06-29', '02:00:00', '14.5', '8.9', '69.08', '0', '22.6', '0', '5.8', '307.9', '1020', '49.8', '24.1', '0', 'partly-cloudy-night' ),( '93940', '2024-06-29', '03:00:00', '14.7', '9.1', '69.28', '0', '12.9', '0', '5.5', '310.9', '1020', '34.9', '24.1', '0', 'partly-cloudy-day' ),( '93940', '2024-06-29', '04:00:00', '14.9', '9.3', '69.47', '0', '12.9', '0', '5.3', '313.8', '1020', '19.9', '24.1', '0', 'clear-day' ),( '93940', '2024-06-29', '05:00:00', '15.1', '9.6', '69.67', '0', '12.9', '0', '5', '316.8', '1020', '5', '24.1', '0', 'clear-day' ),( '93940', '2024-06-29', '06:00:00', '17', '9.4', '61.04', '0', '12.9', '0', '4.6', '218.4', '1020', '30.7', '24.1', '1', 'partly-cloudy-day' ),( '93940', '2024-06-29', '07:00:00', '19', '9.4', '53.58', '0', '12.9', '0', '4.1', '120', '1020', '56.3', '24.1', '2', 'partly-cloudy-day' ),( '93940', '2024-06-29', '08:00:00', '21', '9.3', '47.12', '0', '12.9', '0', '3.6', '21.6', '1020', '82', '24.1', '3', 'partly-cloudy-day' ),( '93940', '2024-06-29', '09:00:00', '22.5', '9.4', '43.19', '0', '32.3', '0', '2.6', '112.8', '1019.7', '71.3', '24.1', '4', 'partly-cloudy-day' ),( '93940', '2024-06-29', '10:00:00', '24', '9.4', '39.64', '0', '32.3', '0', '1.7', '203.9', '1019.3', '60.6', '24.1', '5', 'partly-cloudy-day' ),( '93940', '2024-06-29', '11:00:00', '25.6', '9.6', '36.41', '0', '32.3', '0', '0.7', '295.1', '1019', '49.9', '24.1', '6', 'partly-cloudy-day' ),( '93940', '2024-06-29', '12:00:00', '26.3', '8.9', '33.33', '0', '32.3', '0', '2.5', '282.8', '1019', '57.2', '24.1', '6', 'partly-cloudy-day' ),( '93940', '2024-06-29', '13:00:00', '27', '8.2', '30.5', '0', '32.3', '0', '4.3', '270.6', '1019', '64.4', '24.1', '7', 'partly-cloudy-day' ),( '93940', '2024-06-29', '14:00:00', '27.7', '7.5', '27.91', '0', '32.3', '0', '6.1', '258.3', '1019', '71.7', '24.1', '8', 'partly-cloudy-day' ),( '93940', '2024-06-29', '15:00:00', '27.7', '6.8', '26.5', '0', '35.5', '0', '6', '261.6', '1018.7', '81.1', '24.1', '7', 'partly-cloudy-day' ),( '93940', '2024-06-29', '16:00:00', '27.8', '6.1', '25.16', '0', '35.5', '0', '5.9', '264.9', '1018.3', '90.5', '24.1', '7', 'cloudy' ),( '93940', '2024-06-29', '17:00:00', '27.9', '5.4', '23.87', '0', '35.5', '0', '5.8', '268.2', '1018', '99.9', '24.1', '7', 'cloudy' ),( '93940', '2024-06-29', '18:00:00', '25.1', '7.1', '31.74', '0', '35.5', '0', '7.6', '225.9', '1018.3', '99.9', '24.1', '5', 'cloudy' ),( '93940', '2024-06-29', '19:00:00', '22.3', '8.8', '42.26', '0', '35.5', '0', '9.4', '183.5', '1018.7', '100', '24.1', '4', 'cloudy' ),( '93940', '2024-06-29', '20:00:00', '19.5', '10.6', '56.4', '0', '35.5', '0', '11.2', '141.2', '1019', '100', '24.1', '3', 'cloudy' ),( '93940', '2024-06-29', '21:00:00', '17.8', '10.1', '60.42', '0', '25.8', '0', '10.1', '146.1', '1019.3', '94.1', '24.1', '2', 'cloudy' ),( '93940', '2024-06-29', '22:00:00', '16.2', '9.6', '64.79', '0', '25.8', '0', '9', '151', '1019.7', '88.3', '24.1', '1', 'partly-cloudy-day' ),( '93940', '2024-06-29', '23:00:00', '14.6', '9.1', '69.57', '0', '25.8', '0', '7.9', '155.9', '1020', '82.4', '24.1', '0', 'partly-cloudy-day' ) 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)

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 ( '93918', '2024-06-15', '00:00:00', '8.7', '7.7', '93.44', '0', '0', '0', '1.3', '24', '1012', '88', '10', '0', 'partly-cloudy-night' ),( '93918', '2024-06-15', '01:00:00', '7.4', '6.7', '94.93', '0', '0', '0', '2.2', '80.2', '1012', '88', '10', '0', 'partly-cloudy-night' ),( '93918', '2024-06-15', '02:00:00', '6.7', '6.4', '98.37', '0', '0', '0', '3.6', '90', '1012', '100', '10', '0', 'cloudy' ),( '93918', '2024-06-15', '03:00:00', '6.7', '6.7', '100', '0', '0', '0', '6.2', '300', '1012', '100', '6.5', '0', 'cloudy' ),( '93918', '2024-06-15', '04:00:00', '8.4', '7.4', '93.43', '0', '0', '0', '4', '351', '1012', '100', '10', '0', 'cloudy' ),( '93918', '2024-06-15', '05:00:00', '8.7', '8', '94.98', '0', '0', '0', '4', '320', '1012', '97.1', '8.6', '1', 'cloudy' ),( '93918', '2024-06-15', '06:00:00', '10', '9.2', '95.02', '0', '0', '0', '5', '20', '1012', '88', '10', '2', 'partly-cloudy-day' ),( '93918', '2024-06-15', '07:00:00', '11', '9.2', '88.9', '0', '0', '0', '5.9', '70', '1012', '40.1', '10', '3', 'partly-cloudy-day' ),( '93918', '2024-06-15', '08:00:00', '12', '10', '87.56', '0', '0', '0', '6.8', '110', '1012', '100', '10', '4', 'cloudy' ),( '93918', '2024-06-15', '09:00:00', '13.7', '9.7', '76.79', '0', '0', '0', '8.9', '158', '1012', '88', '10', '5', 'partly-cloudy-day' ),( '93918', '2024-06-15', '10:00:00', '15', '9.5', '69.75', '0', '0', '0', '13', '176', '1011.2', '82', '10', '6', 'partly-cloudy-day' ),( '93918', '2024-06-15', '11:00:00', '16.5', '10', '65.35', '0.1', '100', '0', '15.7', '160', '1011.2', '40.1', '10', '7', 'showers-day' ),( '93918', '2024-06-15', '12:00:00', '17.5', '10.5', '63.51', '0.1', '100', '0', '17.9', '170', '1011.2', '25', '10', '8', 'showers-day' ),( '93918', '2024-06-15', '13:00:00', '17.5', '9.5', '59.4', '0.2', '100', '0', '18.9', '160', '1011.2', '50', '10', '8', 'showers-day' ),( '93918', '2024-06-15', '14:00:00', '17.7', '9.5', '58.51', '0.2', '100', '0', '18.9', '160', '1011.2', '59.1', '10', '5', 'showers-day' ),( '93918', '2024-06-15', '15:00:00', '17.7', '9.2', '57.57', '0', '0', '0', '14.8', '144', '1011.2', '97.1', '10', '3', 'cloudy' ),( '93918', '2024-06-15', '16:00:00', '14.9', '11', '77.41', '0.6', '100', '0', '21.9', '319', '1011.2', '97.1', '10', '3', 'rain' ),( '93918', '2024-06-15', '17:00:00', '16.2', '11.3', '72.65', '0.2', '100', '0', '9', '304', '1011.2', '88', '10', '2', 'showers-day' ),( '93918', '2024-06-15', '18:00:00', '16.7', '8.2', '57.16', '0.1', '100', '0', '17.5', '155', '1011', '90.9', '10', '3', 'rain' ),( '93918', '2024-06-15', '19:00:00', '16.5', '8.2', '58.04', '0.1', '100', '0', '20.9', '157', '1011.2', '97.1', '10', '3', 'rain' ),( '93918', '2024-06-15', '20:00:00', '15.7', '8', '59.94', '0', '0', '0', '21.9', '162', '1011', '59.1', '10', '2', 'partly-cloudy-day' ),( '93918', '2024-06-15', '21:00:00', '14.7', '9', '68.39', '0', '0', '0', '17.5', '157', '1011.2', '19.9', '10', '1', 'clear-day' ),( '93918', '2024-06-15', '22:00:00', '13.7', '9', '72.97', '0', '0', '0', '13.9', '155', '1011.2', '34.7', '10', '1', 'partly-cloudy-day' ),( '93918', '2024-06-15', '23:00:00', '11.7', '9.2', '84.53', '0', '0', '0', '7.6', '127', '1012', '100', '10', '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_16 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '93918', '2024-06-16', '00:00:00', '8.4', '7.6', '94.71', '0', '0', '0', '5.8', '101.3', '1012', '100', '24.1', '0', 'cloudy' ),( '93918', '2024-06-16', '01:00:00', '8.2', '7.6', '96', '0', '0', '0', '5.8', '103', '1012', '100', '24.1', '0', 'cloudy' ),( '93918', '2024-06-16', '02:00:00', '8.8', '8.3', '96.67', '0', '0', '0', '6.1', '111.4', '1012', '100', '24.1', '0', 'cloudy' ),( '93918', '2024-06-16', '03:00:00', '8.9', '8.4', '96.67', '0', '0', '0', '7.2', '113.6', '1012', '99.2', '24.1', '0', 'cloudy' ),( '93918', '2024-06-16', '04:00:00', '9.3', '8.5', '94.74', '0', '0', '0', '8.3', '119.5', '1012', '100', '24.1', '0', 'cloudy' ),( '93918', '2024-06-16', '05:00:00', '9.6', '8.6', '93.48', '0', '0', '0', '8.3', '120.6', '1012', '100', '24.1', '1', 'cloudy' ),( '93918', '2024-06-16', '06:00:00', '10.3', '8.4', '88', '0', '0', '0', '10.1', '124.1', '1012', '100', '24.1', '1', 'cloudy' ),( '93918', '2024-06-16', '07:00:00', '10.9', '8.4', '84.55', '0', '0', '0', '10.8', '125.4', '1012', '100', '24.1', '1', 'cloudy' ),( '93918', '2024-06-16', '08:00:00', '11.4', '8.6', '82.91', '0.1', '0', '0', '10.4', '111.2', '1012', '100', '24.1', '2', 'cloudy' ),( '93918', '2024-06-16', '09:00:00', '11.3', '9.2', '86.91', '0.6', '90.3', '0', '11.9', '92.8', '1012', '100', '24.1', '3', 'rain' ),( '93918', '2024-06-16', '10:00:00', '12.3', '9.4', '82.46', '0.1', '90.3', '0', '16.9', '106.7', '1011', '99.5', '24.1', '2', 'rain' ),( '93918', '2024-06-16', '11:00:00', '12', '9.4', '84.11', '0', '90.3', '0', '15.5', '110', '1011', '97.9', '22.2', '1', 'rain' ),( '93918', '2024-06-16', '12:00:00', '12.2', '9.6', '84.13', '0', '90.3', '0', '18', '112.7', '1011', '98.8', '14.1', '0', 'rain' ),( '93918', '2024-06-16', '13:00:00', '11.6', '9.5', '86.94', '0', '90.3', '0', '16.6', '112.7', '1011', '100', '0.4', '0', 'rain' ),( '93918', '2024-06-16', '14:00:00', '12.3', '9.6', '83.58', '0.1', '90.3', '0', '17.6', '123.7', '1011', '100', '0.3', '1', 'rain' ),( '93918', '2024-06-16', '15:00:00', '13.5', '10.2', '80.44', '0', '35.5', '0', '11.9', '138.1', '1011', '98.8', '0.3', '2', 'fog' ),( '93918', '2024-06-16', '16:00:00', '14.9', '10', '72.49', '0', '35.5', '0', '13', '152.3', '1010', '98.9', '17.1', '2', 'cloudy' ),( '93918', '2024-06-16', '17:00:00', '14.7', '11.3', '80.07', '0', '35.5', '0', '12.6', '145.9', '1010', '82', '24.1', '2', 'partly-cloudy-day' ),( '93918', '2024-06-16', '18:00:00', '14.9', '11', '77.49', '0', '35.5', '0', '13', '154', '1010', '80.6', '24.1', '1', 'partly-cloudy-day' ),( '93918', '2024-06-16', '19:00:00', '14.7', '11.2', '79.54', '0.1', '35.5', '0', '11.5', '159.3', '1010', '76.8', '24.1', '1', 'partly-cloudy-day' ),( '93918', '2024-06-16', '20:00:00', '14.1', '11.4', '83.79', '0.1', '35.5', '0', '10.8', '153.4', '1011', '71.9', '24.1', '2', 'partly-cloudy-day' ),( '93918', '2024-06-16', '21:00:00', '13.4', '11.6', '88.86', '0', '0', '0', '9.7', '145.7', '1012', '61.4', '24.1', '1', 'partly-cloudy-day' ),( '93918', '2024-06-16', '22:00:00', '12.4', '11.4', '93.62', '0', '0', '0', '7.9', '134.5', '1012', '74.4', '24.1', '0', 'partly-cloudy-day' ),( '93918', '2024-06-16', '23:00:00', '11.3', '10.9', '97.38', '0', '0', '0', '6.1', '125.8', '1012', '73.7', '24.1', '0', 'partly-cloudy-day' ) 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 ( '93918', '2024-06-17', '00:00:00', '10.7', '10.4', '98.02', '0', '0', '0', '5', '120', '1013', '75.1', '24.1', '0', 'partly-cloudy-night' ),( '93918', '2024-06-17', '01:00:00', '10.2', '9.9', '98.01', '0', '0', '0', '4.3', '107.8', '1013', '85.8', '24.1', '0', 'partly-cloudy-night' ),( '93918', '2024-06-17', '02:00:00', '9.5', '9.3', '98.66', '0', '0', '0', '4.7', '90.8', '1013', '77.4', '24.1', '0', 'partly-cloudy-night' ),( '93918', '2024-06-17', '03:00:00', '9.2', '9', '98.66', '0', '0', '0', '4.7', '87.2', '1014', '79.8', '24.1', '0', 'partly-cloudy-day' ),( '93918', '2024-06-17', '04:00:00', '9.6', '9.4', '98.67', '0', '0', '0', '4.3', '81', '1014', '81.7', '24.1', '0', 'partly-cloudy-day' ),( '93918', '2024-06-17', '05:00:00', '10.6', '10.1', '96.72', '0', '0', '0', '4.7', '84.9', '1014', '95.4', '24.1', '1', 'cloudy' ),( '93918', '2024-06-17', '06:00:00', '11.9', '10.5', '91.14', '0', '0', '0', '7.2', '121.9', '1014', '100', '24.1', '1', 'cloudy' ),( '93918', '2024-06-17', '07:00:00', '13.1', '10.6', '84.8', '0', '0', '0', '7.2', '129', '1014', '100', '24.1', '2', 'cloudy' ),( '93918', '2024-06-17', '08:00:00', '14.5', '10.6', '77.43', '0', '0', '0', '7.6', '138.6', '1013', '100', '24.1', '3', 'cloudy' ),( '93918', '2024-06-17', '09:00:00', '15.5', '10.5', '72.12', '0', '64.5', '0', '8.3', '146.6', '1014', '100', '24.1', '3', 'rain' ),( '93918', '2024-06-17', '10:00:00', '15.7', '10.7', '72.15', '0', '64.5', '0', '9.7', '137.3', '1014', '100', '24.1', '5', 'rain' ),( '93918', '2024-06-17', '11:00:00', '15.4', '11.4', '77.05', '0.2', '64.5', '0', '11.2', '121.5', '1014', '99.3', '24.1', '6', 'rain' ),( '93918', '2024-06-17', '12:00:00', '15.4', '11.6', '78.08', '0.1', '64.5', '0', '11.5', '122.2', '1013', '99', '24.1', '7', 'rain' ),( '93918', '2024-06-17', '13:00:00', '15.1', '11.3', '78.03', '0.2', '64.5', '0', '10.1', '124.4', '1013', '100', '24.1', '6', 'rain' ),( '93918', '2024-06-17', '14:00:00', '15', '11.2', '78.02', '0', '64.5', '0', '10.4', '133.1', '1013', '100', '24.1', '4', 'rain' ),( '93918', '2024-06-17', '15:00:00', '15.1', '11.1', '77.01', '0.1', '35.5', '0', '12.2', '135.8', '1013', '100', '24.1', '6', 'cloudy' ),( '93918', '2024-06-17', '16:00:00', '15.1', '11', '76.5', '0', '35.5', '0', '10.4', '131.3', '1013', '93.4', '24.1', '6', 'cloudy' ),( '93918', '2024-06-17', '17:00:00', '14.9', '11', '77.49', '0', '35.5', '0', '9.4', '129.1', '1012', '90.9', '24.1', '5', 'cloudy' ),( '93918', '2024-06-17', '18:00:00', '14.5', '10.9', '78.99', '0', '35.5', '0', '7.2', '124.7', '1012', '92.4', '24.1', '5', 'cloudy' ),( '93918', '2024-06-17', '19:00:00', '14.4', '10.7', '78.45', '0', '35.5', '0', '6.5', '122.2', '1011', '58.2', '24.1', '3', 'partly-cloudy-day' ),( '93918', '2024-06-17', '20:00:00', '14.1', '10.7', '79.99', '0', '35.5', '0', '6.1', '132.6', '1011', '52.1', '24.1', '2', 'partly-cloudy-day' ),( '93918', '2024-06-17', '21:00:00', '13.3', '10.7', '84.26', '0', '3.2', '0', '4.3', '146.1', '1011', '39.9', '24.1', '1', 'partly-cloudy-day' ),( '93918', '2024-06-17', '22:00:00', '11.4', '10.2', '92.33', '0', '3.2', '0', '3.6', '135.3', '1011', '7', '24.1', '0', 'clear-day' ),( '93918', '2024-06-17', '23:00:00', '9.7', '8.9', '94.76', '0', '3.2', '0', '4.3', '117.7', '1012', '43.1', '24.1', '0', 'partly-cloudy-day' ) 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 ( '93918', '2024-06-18', '00:00:00', '9', '8.5', '96.68', '0', '3.2', '0', '4.3', '125.6', '1012', '62', '24.1', '0', 'partly-cloudy-night' ),( '93918', '2024-06-18', '01:00:00', '8.8', '8.6', '98.66', '0', '3.2', '0', '4', '105.6', '1011', '64.6', '24.1', '0', 'partly-cloudy-night' ),( '93918', '2024-06-18', '02:00:00', '8.5', '8.5', '100', '0', '3.2', '0', '4', '113.1', '1011', '76.8', '24.1', '0', 'partly-cloudy-night' ),( '93918', '2024-06-18', '03:00:00', '8.6', '8.6', '100', '0', '16.1', '0', '3.6', '99.4', '1011', '83.7', '24.1', '0', 'partly-cloudy-day' ),( '93918', '2024-06-18', '04:00:00', '8.7', '8.6', '99.33', '0', '16.1', '0', '3.2', '80.5', '1011', '95.3', '24.1', '0', 'cloudy' ),( '93918', '2024-06-18', '05:00:00', '9.7', '9.1', '96.05', '0', '16.1', '0', '4', '101.7', '1010', '97.1', '24.1', '1', 'cloudy' ),( '93918', '2024-06-18', '06:00:00', '10.6', '9.2', '91.05', '0', '16.1', '0', '2.9', '111.8', '1010', '99.1', '24.1', '1', 'cloudy' ),( '93918', '2024-06-18', '07:00:00', '11.1', '9.4', '89.27', '0.3', '16.1', '0', '4.7', '123.8', '1009', '95.9', '24.1', '1', 'cloudy' ),( '93918', '2024-06-18', '08:00:00', '11.7', '9.4', '85.79', '0.1', '16.1', '0', '6.1', '137.8', '1009', '95.6', '24.1', '2', 'cloudy' ),( '93918', '2024-06-18', '09:00:00', '13.2', '9.9', '80.4', '0', '67.7', '0', '8.6', '174', '1009', '90.1', '24.1', '3', 'rain' ),( '93918', '2024-06-18', '10:00:00', '14.2', '10.6', '78.94', '0', '67.7', '0', '7.2', '171.1', '1008', '95.2', '24.1', '4', 'rain' ),( '93918', '2024-06-18', '11:00:00', '15.9', '10.6', '70.76', '0', '67.7', '0', '9.4', '178.7', '1007', '82.9', '24.1', '5', 'showers-day' ),( '93918', '2024-06-18', '12:00:00', '17', '10.3', '64.67', '0', '67.7', '0', '9', '184', '1007', '72.1', '11.2', '6', 'showers-day' ),( '93918', '2024-06-18', '13:00:00', '18.4', '9.9', '57.65', '0', '67.7', '0', '9', '185.2', '1006', '78.3', '16.7', '4', 'showers-day' ),( '93918', '2024-06-18', '14:00:00', '19.4', '9.2', '51.67', '0', '67.7', '0', '10.1', '188.6', '1005', '86.1', '24.1', '3', 'showers-day' ),( '93918', '2024-06-18', '15:00:00', '19.7', '8.5', '48.37', '0', '77.4', '0', '10.1', '197.3', '1005', '72.8', '24.1', '2', 'showers-day' ),( '93918', '2024-06-18', '16:00:00', '19.1', '9.7', '54.44', '0.1', '77.4', '0', '13.7', '164.3', '1004', '75.7', '24.1', '2', 'showers-day' ),( '93918', '2024-06-18', '17:00:00', '18.1', '11.4', '64.91', '0.2', '77.4', '0', '12.6', '153.8', '1004', '46.9', '24.1', '4', 'showers-day' ),( '93918', '2024-06-18', '18:00:00', '18', '11.3', '64.89', '0.2', '77.4', '0', '11.2', '156', '1004', '40.8', '22', '4', 'showers-day' ),( '93918', '2024-06-18', '19:00:00', '17.9', '11.3', '65.3', '0', '77.4', '0', '13', '152.5', '1003', '37.6', '12.4', '2', 'showers-day' ),( '93918', '2024-06-18', '20:00:00', '16.5', '11.2', '70.88', '0', '77.4', '0', '13.3', '152.2', '1002', '19.2', '24.1', '1', 'showers-day' ),( '93918', '2024-06-18', '21:00:00', '14.8', '10.8', '76.8', '0', '45.2', '0', '10.6', '149.2', '1002', '44.2', '24.1', '0', 'showers-day' ),( '93918', '2024-06-18', '22:00:00', '13.2', '10.4', '83.32', '0', '45.2', '0', '7.8', '146.3', '1002', '69.3', '24.1', '0', 'showers-day' ),( '93918', '2024-06-18', '23:00:00', '11.6', '10.1', '90.51', '0', '45.2', '0', '5', '143.3', '1002', '94.3', '24.1', '0', 'rain' ) 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 ( '93918', '2024-06-19', '00:00:00', '11', '9.4', '90.07', '0', '45.2', '0', '4.8', '132.8', '1001.3', '83.9', '18.7', '0', 'showers-night' ),( '93918', '2024-06-19', '01:00:00', '10.5', '8.9', '89.62', '0', '45.2', '0', '4.6', '122.4', '1000.7', '73.4', '13.1', '0', 'showers-night' ),( '93918', '2024-06-19', '02:00:00', '10', '8.3', '89.18', '0', '45.2', '0', '4.3', '111.9', '1000', '63', '23.1', '0', 'showers-night' ),( '93918', '2024-06-19', '03:00:00', '10', '8.6', '90.81', '0', '25.8', '0', '3.7', '109.5', '999.7', '75.3', '24.1', '0', 'partly-cloudy-day' ),( '93918', '2024-06-19', '04:00:00', '10', '8.9', '92.46', '0', '25.8', '0', '3.1', '107.1', '999.3', '87.7', '24.1', '0', 'partly-cloudy-day' ),( '93918', '2024-06-19', '05:00:00', '10.1', '9.2', '94.14', '0.8', '25.8', '0', '2.5', '104.7', '999', '100', '24.1', '0', 'cloudy' ),( '93918', '2024-06-19', '06:00:00', '11.2', '9.2', '87.69', '0', '25.8', '0', '4', '142.1', '998.3', '97.6', '24.1', '0', 'cloudy' ),( '93918', '2024-06-19', '07:00:00', '12.3', '9.3', '81.74', '0', '25.8', '0', '5.4', '179.4', '997.7', '95.1', '24.1', '0', 'cloudy' ),( '93918', '2024-06-19', '08:00:00', '13.5', '9.4', '76.24', '0.2', '25.8', '0', '6.8', '216.8', '997', '92.7', '24.1', '0', 'cloudy' ),( '93918', '2024-06-19', '09:00:00', '13.9', '9.7', '75.64', '0', '54.8', '0', '6.6', '225.8', '996.7', '92.4', '22.6', '0', 'rain' ),( '93918', '2024-06-19', '10:00:00', '14.4', '10', '75.04', '0', '54.8', '0', '6.4', '234.7', '996.3', '92', '21.8', '0', 'rain' ),( '93918', '2024-06-19', '11:00:00', '14.9', '10.4', '74.45', '1', '54.8', '0', '6.1', '243.7', '996', '91.7', '21.9', '0', 'rain' ),( '93918', '2024-06-19', '12:00:00', '14.7', '10.5', '76.1', '0', '54.8', '0', '6.8', '258.5', '996', '94.5', '17.9', '0', 'rain' ),( '93918', '2024-06-19', '13:00:00', '14.5', '10.7', '77.78', '0', '54.8', '0', '7.6', '273.4', '996', '97.2', '11.6', '0', 'rain' ),( '93918', '2024-06-19', '14:00:00', '14.4', '10.9', '79.5', '2.4', '54.8', '0', '8.3', '288.2', '996', '100', '14', '0', 'rain' ),( '93918', '2024-06-19', '15:00:00', '13.9', '10.9', '81.94', '0', '35.5', '0', '10.6', '293.7', '996', '100', '24.1', '1', 'cloudy' ),( '93918', '2024-06-19', '16:00:00', '13.4', '10.9', '84.46', '0', '35.5', '0', '12.8', '299.3', '996', '100', '24.1', '2', 'cloudy' ),( '93918', '2024-06-19', '17:00:00', '13', '10.9', '87.07', '3.7', '35.5', '0', '15.1', '304.8', '996', '100', '24.1', '5', 'cloudy' ),( '93918', '2024-06-19', '18:00:00', '12.1', '8.9', '80.44', '0', '35.5', '0', '16.9', '303', '996.3', '100', '24.1', '5', 'cloudy' ),( '93918', '2024-06-19', '19:00:00', '11.3', '6.9', '74.17', '0', '35.5', '0', '18.7', '301.2', '996.7', '100', '24.1', '4', 'cloudy' ),( '93918', '2024-06-19', '20:00:00', '10.5', '4.9', '68.27', '1', '35.5', '0', '20.5', '299.4', '997', '100', '24.1', '2', 'cloudy' ),( '93918', '2024-06-19', '21:00:00', '9.7', '4.2', '68.27', '0', '19.4', '0', '19.4', '299.2', '997.3', '100', '24.1', '1', 'cloudy' ),( '93918', '2024-06-19', '22:00:00', '9', '3.4', '68.28', '0', '19.4', '0', '18.4', '299', '997.7', '100', '24.1', '0', 'cloudy' ),( '93918', '2024-06-19', '23:00:00', '8.3', '2.8', '68.29', '0', '19.4', '0', '17.3', '298.8', '998', '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_20 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '93918', '2024-06-20', '00:00:00', '7.6', '2.5', '69.96', '0', '19.4', '0', '16.6', '297.5', '998', '95.2', '24.1', '0', 'cloudy' ),( '93918', '2024-06-20', '01:00:00', '7', '2.2', '71.68', '0', '19.4', '0', '15.8', '296.1', '998', '90.5', '24.1', '0', 'cloudy' ),( '93918', '2024-06-20', '02:00:00', '6.4', '2', '73.46', '0', '19.4', '0', '15.1', '294.8', '998', '85.7', '24.1', '0', 'partly-cloudy-night' ),( '93918', '2024-06-20', '03:00:00', '6.2', '1.5', '71.53', '0', '12.9', '0', '14.9', '294.4', '997.7', '88.4', '24.1', '0', 'partly-cloudy-day' ),( '93918', '2024-06-20', '04:00:00', '6.1', '1', '69.64', '0', '12.9', '0', '14.6', '294.1', '997.3', '91', '24.1', '0', 'cloudy' ),( '93918', '2024-06-20', '05:00:00', '6', '0.5', '67.8', '0', '12.9', '0', '14.4', '293.7', '997', '93.7', '24.1', '1', 'cloudy' ),( '93918', '2024-06-20', '06:00:00', '7', '1.2', '66.26', '0', '12.9', '0', '15.1', '294.5', '996.7', '82', '24.1', '1', 'partly-cloudy-day' ),( '93918', '2024-06-20', '07:00:00', '8.1', '1.9', '64.78', '0', '12.9', '0', '15.8', '295.2', '996.3', '70.2', '24.1', '2', 'partly-cloudy-day' ),( '93918', '2024-06-20', '08:00:00', '9.2', '2.6', '63.35', '0', '12.9', '0', '16.6', '296', '996', '58.5', '24.1', '4', 'partly-cloudy-day' ),( '93918', '2024-06-20', '09:00:00', '10', '2.9', '61.19', '0', '19.4', '0', '17', '298.3', '996', '70.3', '24.1', '5', 'partly-cloudy-day' ),( '93918', '2024-06-20', '10:00:00', '10.8', '3.2', '59.13', '0', '19.4', '0', '17.5', '300.5', '996', '82', '24.1', '5', 'partly-cloudy-day' ),( '93918', '2024-06-20', '11:00:00', '11.7', '3.5', '57.15', '0', '19.4', '0', '18', '302.8', '996', '93.8', '24.1', '3', 'cloudy' ),( '93918', '2024-06-20', '12:00:00', '12.2', '1.8', '49.01', '0.1', '19.4', '0', '22.7', '305.3', '999', '100', '24.1', '7', 'cloudy' ),( '93918', '2024-06-20', '13:00:00', '11.3', '2.3', '53.9', '0', '19.4', '0', '22.3', '295.7', '999', '99.9', '24.1', '3', 'cloudy' ),( '93918', '2024-06-20', '14:00:00', '11.5', '0.2', '45.74', '0', '19.4', '0', '21.6', '298.2', '999', '94.2', '24.1', '3', 'cloudy' ),( '93918', '2024-06-20', '15:00:00', '11.9', '0.2', '44.66', '0', '29', '0', '21.4', '297.1', '999.3', '91.9', '24.1', '3', 'cloudy' ),( '93918', '2024-06-20', '16:00:00', '12.3', '0.2', '43.6', '0', '29', '0', '21.1', '295.9', '999.7', '89.5', '24.1', '4', 'partly-cloudy-day' ),( '93918', '2024-06-20', '17:00:00', '12.7', '0.3', '42.58', '0', '29', '0', '20.9', '294.8', '1000', '87.2', '24.1', '4', 'partly-cloudy-day' ),( '93918', '2024-06-20', '18:00:00', '11.7', '1.1', '48.08', '0', '29', '0', '23.4', '297.7', '1000.7', '59.8', '24.1', '4', 'partly-cloudy-day' ),( '93918', '2024-06-20', '19:00:00', '10.8', '1.9', '54.29', '0', '29', '0', '25.9', '300.6', '1001.3', '32.4', '24.1', '3', 'partly-cloudy-day' ),( '93918', '2024-06-20', '20:00:00', '9.9', '2.8', '61.31', '0', '29', '0', '28.4', '303.5', '1002', '5', '24.1', '3', 'clear-day' ),( '93918', '2024-06-20', '21:00:00', '9.2', '2.3', '62.31', '0', '12.9', '0', '27.2', '300.9', '1002.3', '36.7', '24.1', '2', 'partly-cloudy-day' ),( '93918', '2024-06-20', '22:00:00', '8.4', '1.9', '63.34', '0', '12.9', '0', '26', '298.2', '1002.7', '68.3', '24.1', '1', 'partly-cloudy-day' ),( '93918', '2024-06-20', '23:00:00', '7.8', '1.5', '64.4', '0', '12.9', '0', '24.8', '295.6', '1003', '100', '24.1', '1', '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_21 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '93918', '2024-06-21', '00:00:00', '7.5', '2.3', '69.44', '0', '12.9', '0', '24.8', '291.6', '1003', '100', '24.1', '0', 'cloudy' ),( '93918', '2024-06-21', '01:00:00', '7.3', '3.1', '74.85', '0', '12.9', '0', '24.8', '287.6', '1003', '100', '24.1', '0', 'cloudy' ),( '93918', '2024-06-21', '02:00:00', '7.1', '4', '80.66', '0', '12.9', '0', '24.8', '283.6', '1003', '100', '24.1', '0', 'cloudy' ),( '93918', '2024-06-21', '03:00:00', '7.2', '4.1', '80.68', '0', '9.7', '0', '25.2', '285.7', '1003', '100', '24.1', '0', 'cloudy' ),( '93918', '2024-06-21', '04:00:00', '7.4', '4.3', '80.7', '0', '9.7', '0', '25.6', '287.9', '1003', '100', '24.1', '0', 'cloudy' ),( '93918', '2024-06-21', '05:00:00', '7.6', '4.5', '80.73', '0', '9.7', '0', '25.9', '290', '1003', '100', '24.1', '0', 'cloudy' ),( '93918', '2024-06-21', '06:00:00', '8.1', '4.7', '79.13', '0', '9.7', '0', '25.7', '289.5', '1002.7', '100', '24.1', '0', 'cloudy' ),( '93918', '2024-06-21', '07:00:00', '8.6', '4.9', '77.57', '0', '9.7', '0', '25.4', '288.9', '1002.3', '100', '24.1', '0', 'cloudy' ),( '93918', '2024-06-21', '08:00:00', '9.2', '5.2', '76.05', '0', '9.7', '0', '25.2', '288.4', '1002', '100', '24.1', '0', 'cloudy' ),( '93918', '2024-06-21', '09:00:00', '10.9', '5', '67.09', '0', '19.4', '0', '24.2', '292.6', '1002', '95.9', '24.1', '1', 'cloudy' ),( '93918', '2024-06-21', '10:00:00', '12.6', '4.8', '59.28', '0', '19.4', '0', '23.3', '296.7', '1002', '91.7', '24.1', '2', 'cloudy' ),( '93918', '2024-06-21', '11:00:00', '14.3', '4.7', '52.45', '0', '19.4', '0', '22.3', '300.9', '1002', '87.6', '24.1', '3', 'partly-cloudy-day' ),( '93918', '2024-06-21', '12:00:00', '15.5', '4.6', '48.22', '0', '19.4', '0', '22.4', '300.8', '1002', '64.4', '24.1', '4', 'partly-cloudy-day' ),( '93918', '2024-06-21', '13:00:00', '16.7', '4.5', '44.37', '0', '19.4', '0', '22.6', '300.6', '1002', '41.2', '24.1', '5', 'partly-cloudy-day' ),( '93918', '2024-06-21', '14:00:00', '18', '4.5', '40.85', '0', '19.4', '0', '22.7', '300.5', '1002', '18', '24.1', '7', 'clear-day' ),( '93918', '2024-06-21', '15:00:00', '18.2', '4.6', '40.81', '0', '19.4', '0', '21.6', '298.4', '1002', '14.8', '24.1', '7', 'clear-day' ),( '93918', '2024-06-21', '16:00:00', '18.4', '4.8', '40.77', '0', '19.4', '0', '20.5', '296.2', '1002', '11.7', '24.1', '7', 'clear-day' ),( '93918', '2024-06-21', '17:00:00', '18.6', '5', '40.74', '0', '19.4', '0', '19.4', '294.1', '1002', '8.5', '24.1', '7', 'clear-day' ),( '93918', '2024-06-21', '18:00:00', '17.7', '5.4', '44.43', '0', '19.4', '0', '18.5', '290.8', '1002.3', '5.7', '24.1', '6', 'clear-day' ),( '93918', '2024-06-21', '19:00:00', '16.8', '5.8', '48.46', '0', '19.4', '0', '17.5', '287.5', '1002.7', '2.8', '24.1', '5', 'clear-day' ),( '93918', '2024-06-21', '20:00:00', '15.9', '6.3', '52.88', '0', '19.4', '0', '16.6', '284.2', '1003', '0', '24.1', '4', 'clear-day' ),( '93918', '2024-06-21', '21:00:00', '14', '6', '58.8', '0', '6.5', '0', '14.3', '287.9', '1003.3', '0.1', '24.1', '3', 'clear-day' ),( '93918', '2024-06-21', '22:00:00', '12.1', '5.8', '65.51', '0', '6.5', '0', '12', '291.7', '1003.7', '0.1', '24.1', '2', 'clear-day' ),( '93918', '2024-06-21', '23:00:00', '10.2', '5.6', '73.12', '0', '6.5', '0', '9.7', '295.4', '1004', '0.2', '24.1', '1', 'clear-day' ) 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 ( '93918', '2024-06-22', '00:00:00', '9.1', '5.4', '78', '0', '6.5', '0', '8.5', '301.7', '1003.7', '0.1', '24.1', '0', 'clear-night' ),( '93918', '2024-06-22', '01:00:00', '8', '5.3', '83.25', '0', '6.5', '0', '7.3', '307.9', '1003.3', '0.1', '24.1', '0', 'clear-night' ),( '93918', '2024-06-22', '02:00:00', '6.9', '5.2', '88.92', '0', '6.5', '0', '6.1', '314.2', '1003', '0', '24.1', '0', 'clear-night' ),( '93918', '2024-06-22', '03:00:00', '7.4', '5.3', '86.34', '0', '6.5', '0', '5.5', '305.8', '1003.3', '0', '24.1', '0', 'clear-day' ),( '93918', '2024-06-22', '04:00:00', '8', '5.4', '83.84', '0', '6.5', '0', '4.9', '297.5', '1003.7', '0', '24.1', '0', 'clear-day' ),( '93918', '2024-06-22', '05:00:00', '8.6', '5.6', '81.43', '0', '6.5', '0', '4.3', '289.1', '1004', '0', '24.1', '0', 'clear-day' ),( '93918', '2024-06-22', '06:00:00', '10.2', '5.4', '71.95', '0', '6.5', '0', '6.2', '304.3', '1004', '0', '24.1', '1', 'clear-day' ),( '93918', '2024-06-22', '07:00:00', '11.8', '5.2', '63.67', '0', '6.5', '0', '8.2', '319.4', '1004', '0', '24.1', '2', 'clear-day' ),( '93918', '2024-06-22', '08:00:00', '13.5', '5', '56.42', '0', '6.5', '0', '10.1', '334.6', '1004', '0', '24.1', '3', 'clear-day' ),( '93918', '2024-06-22', '09:00:00', '14.9', '4', '48.16', '0', '19.4', '0', '9.5', '340.1', '1003.7', '0', '24.1', '4', 'clear-day' ),( '93918', '2024-06-22', '10:00:00', '16.3', '3', '41.13', '0', '19.4', '0', '8.9', '345.7', '1003.3', '0', '24.1', '5', 'clear-day' ),( '93918', '2024-06-22', '11:00:00', '17.7', '2.1', '35.14', '0', '19.4', '0', '8.3', '351.2', '1003', '0', '24.1', '6', 'clear-day' ),( '93918', '2024-06-22', '12:00:00', '18.9', '1.9', '32.07', '0', '19.4', '0', '6.8', '339.5', '1003', '0', '24.1', '7', 'clear-day' ),( '93918', '2024-06-22', '13:00:00', '20.2', '1.7', '29.29', '0', '19.4', '0', '5.4', '327.7', '1003', '0', '24.1', '7', 'clear-day' ),( '93918', '2024-06-22', '14:00:00', '21.5', '1.6', '26.78', '0', '19.4', '0', '4', '316', '1003', '0', '24.1', '8', 'clear-day' ),( '93918', '2024-06-22', '15:00:00', '21.4', '1.4', '26.45', '0', '16.1', '0', '4.2', '299.1', '1002.7', '1', '24.1', '7', 'clear-day' ),( '93918', '2024-06-22', '16:00:00', '21.4', '1.2', '26.12', '0', '16.1', '0', '4.4', '282.1', '1002.3', '2', '24.1', '7', 'clear-day' ),( '93918', '2024-06-22', '17:00:00', '21.4', '1', '25.8', '0', '16.1', '0', '4.7', '265.2', '1002', '3', '24.1', '7', 'clear-day' ),( '93918', '2024-06-22', '18:00:00', '20.3', '3.1', '32.09', '0', '16.1', '0', '6.1', '244.7', '1002.3', '2.1', '24.1', '6', 'clear-day' ),( '93918', '2024-06-22', '19:00:00', '19.3', '5.3', '39.83', '0', '16.1', '0', '7.6', '224.3', '1002.7', '1.1', '24.1', '5', 'clear-day' ),( '93918', '2024-06-22', '20:00:00', '18.3', '7.5', '49.32', '0', '16.1', '0', '9', '203.8', '1003', '0.2', '24.1', '4', 'clear-day' ),( '93918', '2024-06-22', '21:00:00', '15.8', '7.8', '58.99', '0', '16.1', '0', '8.6', '196.1', '1003.3', '1.9', '24.1', '3', 'clear-day' ),( '93918', '2024-06-22', '22:00:00', '13.4', '8.2', '70.77', '0', '16.1', '0', '8.3', '188.4', '1003.7', '3.7', '24.1', '2', 'clear-day' ),( '93918', '2024-06-22', '23:00:00', '11', '8.6', '85.14', '0', '16.1', '0', '7.9', '180.7', '1004', '5.4', '24.1', '1', 'clear-day' ) 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 ( '93918', '2024-06-23', '00:00:00', '10.9', '8.2', '83.05', '0', '16.1', '0', '7', '183.5', '1004.3', '25.4', '24.1', '0', 'partly-cloudy-night' ),( '93918', '2024-06-23', '01:00:00', '10.9', '7.8', '81', '0', '16.1', '0', '6', '186.4', '1004.7', '45.5', '24.1', '0', 'partly-cloudy-night' ),( '93918', '2024-06-23', '02:00:00', '10.9', '7.4', '78.99', '0', '16.1', '0', '5', '189.2', '1005', '65.5', '24.1', '0', 'partly-cloudy-night' ),( '93918', '2024-06-23', '03:00:00', '11', '7.5', '79.02', '0', '9.7', '0', '3.7', '194.1', '1005.3', '55.2', '24.1', '0', 'partly-cloudy-day' ),( '93918', '2024-06-23', '04:00:00', '11.2', '7.7', '79.04', '0', '9.7', '0', '2.4', '198.9', '1005.7', '44.8', '24.1', '0', 'partly-cloudy-day' ),( '93918', '2024-06-23', '05:00:00', '11.4', '7.9', '79.06', '0', '9.7', '0', '1.1', '203.8', '1006', '34.5', '24.1', '0', 'partly-cloudy-day' ),( '93918', '2024-06-23', '06:00:00', '13.3', '7.9', '70.1', '0', '9.7', '0', '1.6', '233.9', '1006.3', '31.6', '24.1', '1', 'partly-cloudy-day' ),( '93918', '2024-06-23', '07:00:00', '15.2', '8', '62.27', '0', '9.7', '0', '2', '263.9', '1006.7', '28.7', '24.1', '2', 'partly-cloudy-day' ),( '93918', '2024-06-23', '08:00:00', '17.1', '8.1', '55.41', '0', '9.7', '0', '2.5', '294', '1007', '25.8', '24.1', '3', 'partly-cloudy-day' ),( '93918', '2024-06-23', '09:00:00', '18.4', '7.6', '49.15', '0', '22.6', '0', '3.5', '276.7', '1007', '25.9', '24.1', '4', 'partly-cloudy-day' ),( '93918', '2024-06-23', '10:00:00', '19.9', '7.1', '43.63', '0', '22.6', '0', '4.4', '259.5', '1007', '26', '24.1', '5', 'partly-cloudy-day' ),( '93918', '2024-06-23', '11:00:00', '21.3', '6.7', '38.76', '0', '22.6', '0', '5.4', '242.2', '1007', '26.1', '24.1', '6', 'partly-cloudy-day' ),( '93918', '2024-06-23', '12:00:00', '21.6', '6.4', '37.3', '0', '22.6', '0', '6.5', '246.8', '1007.3', '50.7', '24.1', '6', 'partly-cloudy-day' ),( '93918', '2024-06-23', '13:00:00', '22', '6.2', '35.89', '0', '22.6', '0', '7.6', '251.5', '1007.7', '75.4', '24.1', '7', 'partly-cloudy-day' ),( '93918', '2024-06-23', '14:00:00', '22.4', '6', '34.54', '0', '22.6', '0', '8.6', '256.1', '1008', '100', '24.1', '7', 'cloudy' ),( '93918', '2024-06-23', '15:00:00', '22.5', '6.1', '34.5', '0', '16.1', '0', '8.2', '245', '1008', '79.9', '24.1', '7', 'partly-cloudy-day' ),( '93918', '2024-06-23', '16:00:00', '22.6', '6.2', '34.45', '0', '16.1', '0', '7.7', '233.8', '1008', '59.7', '24.1', '6', 'partly-cloudy-day' ),( '93918', '2024-06-23', '17:00:00', '22.8', '6.3', '34.41', '0', '16.1', '0', '7.2', '222.7', '1008', '39.6', '24.1', '6', 'partly-cloudy-day' ),( '93918', '2024-06-23', '18:00:00', '21.6', '7.6', '40.57', '0', '16.1', '0', '9.4', '207.4', '1008.7', '31.2', '24.1', '5', 'partly-cloudy-day' ),( '93918', '2024-06-23', '19:00:00', '20.4', '8.9', '47.81', '0', '16.1', '0', '11.5', '192.1', '1009.3', '22.8', '24.1', '4', 'partly-cloudy-day' ),( '93918', '2024-06-23', '20:00:00', '19.2', '10.3', '56.32', '0', '16.1', '0', '13.7', '176.8', '1010', '14.4', '24.1', '3', 'clear-day' ),( '93918', '2024-06-23', '21:00:00', '17.1', '10.1', '63.55', '0', '9.7', '0', '11.6', '179.7', '1010.3', '20.8', '24.1', '2', 'partly-cloudy-day' ),( '93918', '2024-06-23', '22:00:00', '15', '9.9', '71.87', '0', '9.7', '0', '9.6', '182.6', '1010.7', '27.1', '24.1', '2', 'partly-cloudy-day' ),( '93918', '2024-06-23', '23:00:00', '12.9', '9.8', '81.44', '0', '9.7', '0', '7.6', '185.5', '1011', '33.5', '24.1', '1', 'partly-cloudy-day' ) 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 ( '93918', '2024-06-24', '00:00:00', '12', '9.6', '84.87', '0', '9.7', '0', '6.4', '207.9', '1011.7', '23.8', '24.1', '0', 'partly-cloudy-night' ),( '93918', '2024-06-24', '01:00:00', '11.2', '9.4', '88.48', '0', '9.7', '0', '5.2', '230.4', '1012.3', '14.1', '24.1', '0', 'clear-night' ),( '93918', '2024-06-24', '02:00:00', '10.4', '9.2', '92.27', '0', '9.7', '0', '4', '252.8', '1013', '4.4', '24.1', '0', 'clear-night' ),( '93918', '2024-06-24', '03:00:00', '11', '8.8', '86.5', '0', '16.1', '0', '3.8', '255.3', '1013.3', '14.6', '24.1', '0', 'clear-day' ),( '93918', '2024-06-24', '04:00:00', '11.6', '8.5', '81.1', '0', '16.1', '0', '3.7', '257.9', '1013.7', '24.8', '24.1', '0', 'partly-cloudy-day' ),( '93918', '2024-06-24', '05:00:00', '12.3', '8.2', '76.04', '0', '16.1', '0', '3.6', '260.4', '1014', '35', '24.1', '0', 'partly-cloudy-day' ),( '93918', '2024-06-24', '06:00:00', '13.9', '7.4', '64.58', '0', '16.1', '0', '4.9', '266.2', '1014', '56.7', '24.1', '1', 'partly-cloudy-day' ),( '93918', '2024-06-24', '07:00:00', '15.6', '6.6', '54.91', '0', '16.1', '0', '6.2', '271.9', '1014', '78.3', '24.1', '2', 'partly-cloudy-day' ),( '93918', '2024-06-24', '08:00:00', '17.3', '5.8', '46.73', '0', '16.1', '0', '7.6', '277.7', '1014', '100', '24.1', '2', 'cloudy' ),( '93918', '2024-06-24', '09:00:00', '17.4', '5.4', '45.39', '0', '25.8', '0', '7.6', '271.2', '1014.3', '100', '24.1', '3', 'cloudy' ),( '93918', '2024-06-24', '10:00:00', '17.5', '5.2', '44.08', '0', '25.8', '0', '7.6', '264.7', '1014.7', '100', '24.1', '3', 'cloudy' ),( '93918', '2024-06-24', '11:00:00', '17.7', '4.9', '42.81', '0.1', '25.8', '0', '7.6', '258.2', '1015', '100', '24.1', '3', 'cloudy' ),( '93918', '2024-06-24', '12:00:00', '18.9', '4.7', '39.07', '0', '25.8', '0', '8.6', '262.2', '1015', '100', '24.1', '3', 'cloudy' ),( '93918', '2024-06-24', '13:00:00', '20.1', '4.4', '35.69', '0', '25.8', '0', '9.7', '266.1', '1015', '100', '24.1', '4', 'cloudy' ),( '93918', '2024-06-24', '14:00:00', '21.4', '4.3', '32.62', '0', '25.8', '0', '10.8', '270.1', '1015', '100', '24.1', '5', 'cloudy' ),( '93918', '2024-06-24', '15:00:00', '21.8', '3.3', '29.62', '0', '35.5', '0', '10.7', '281', '1015', '72.7', '24.1', '5', 'partly-cloudy-day' ),( '93918', '2024-06-24', '16:00:00', '22.3', '2.3', '26.88', '0', '35.5', '0', '10.6', '291.8', '1015', '45.4', '24.1', '6', 'partly-cloudy-day' ),( '93918', '2024-06-24', '17:00:00', '22.8', '1.4', '24.38', '0', '35.5', '0', '10.4', '302.7', '1015', '18.1', '24.1', '6', 'clear-day' ),( '93918', '2024-06-24', '18:00:00', '22', '3.1', '28.9', '0', '35.5', '0', '8.8', '308.8', '1015', '14', '24.1', '5', 'clear-day' ),( '93918', '2024-06-24', '19:00:00', '21.2', '4.8', '34.21', '0', '35.5', '0', '7.1', '315', '1015', '9.9', '24.1', '4', 'clear-day' ),( '93918', '2024-06-24', '20:00:00', '20.5', '6.6', '40.44', '0', '35.5', '0', '5.4', '321.1', '1015', '5.8', '24.1', '4', 'clear-day' ),( '93918', '2024-06-24', '21:00:00', '18.2', '5.9', '44.77', '0', '32.3', '0', '5.9', '314.5', '1015.7', '32.2', '24.1', '3', 'partly-cloudy-day' ),( '93918', '2024-06-24', '22:00:00', '15.9', '5.4', '49.69', '0', '32.3', '0', '6.4', '307.8', '1016.3', '58.5', '24.1', '2', 'partly-cloudy-day' ),( '93918', '2024-06-24', '23:00:00', '13.6', '4.8', '55.27', '0', '32.3', '0', '6.8', '301.2', '1017', '84.9', '24.1', '1', 'partly-cloudy-day' ) 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 ( '93918', '2024-06-25', '00:00:00', '12.8', '4.8', '58.38', '0', '32.3', '0', '6.6', '301.3', '1017.3', '89.8', '24.1', '0', 'partly-cloudy-night' ),( '93918', '2024-06-25', '01:00:00', '12', '4.9', '61.68', '0', '32.3', '0', '6.4', '301.5', '1017.7', '94.7', '24.1', '0', 'cloudy' ),( '93918', '2024-06-25', '02:00:00', '11.3', '5', '65.18', '0', '32.3', '0', '6.1', '301.6', '1018', '99.6', '24.1', '0', 'cloudy' ),( '93918', '2024-06-25', '03:00:00', '11.4', '5.6', '67.21', '0', '9.7', '0', '5.6', '313.7', '1018.3', '99.7', '24.1', '0', 'cloudy' ),( '93918', '2024-06-25', '04:00:00', '11.6', '6.2', '69.29', '0', '9.7', '0', '5.2', '325.8', '1018.7', '99.9', '24.1', '0', 'cloudy' ),( '93918', '2024-06-25', '05:00:00', '11.8', '6.8', '71.42', '0', '9.7', '0', '4.7', '337.9', '1019', '100', '24.1', '0', 'cloudy' ),( '93918', '2024-06-25', '06:00:00', '13.5', '7.1', '65.38', '0', '9.7', '0', '4.8', '253.7', '1019', '98.9', '24.1', '1', 'cloudy' ),( '93918', '2024-06-25', '07:00:00', '15.2', '7.5', '59.93', '0', '9.7', '0', '4.9', '169.6', '1019', '97.7', '24.1', '2', 'cloudy' ),( '93918', '2024-06-25', '08:00:00', '17', '7.9', '55.01', '0', '9.7', '0', '5', '85.4', '1019', '96.6', '24.1', '2', 'cloudy' ),( '93918', '2024-06-25', '09:00:00', '18.4', '8.2', '51.19', '0', '12.9', '0', '5.2', '96.3', '1019', '73.2', '24.1', '3', 'partly-cloudy-day' ),( '93918', '2024-06-25', '10:00:00', '19.9', '8.4', '47.68', '0', '12.9', '0', '5.3', '107.2', '1019', '49.9', '24.1', '5', 'partly-cloudy-day' ),( '93918', '2024-06-25', '11:00:00', '21.4', '8.8', '44.45', '0', '12.9', '0', '5.4', '118.1', '1019', '26.5', '24.1', '6', 'partly-cloudy-day' ),( '93918', '2024-06-25', '12:00:00', '22', '8.4', '41.73', '0', '12.9', '0', '4.2', '135.3', '1018.7', '50.4', '24.1', '6', 'partly-cloudy-day' ),( '93918', '2024-06-25', '13:00:00', '22.7', '8.1', '39.17', '0', '12.9', '0', '3', '152.5', '1018.3', '74.4', '24.1', '6', 'partly-cloudy-day' ),( '93918', '2024-06-25', '14:00:00', '23.4', '7.8', '36.78', '0', '12.9', '0', '1.8', '169.7', '1018', '98.3', '24.1', '7', 'cloudy' ),( '93918', '2024-06-25', '15:00:00', '21.7', '8.6', '42.97', '0', '19.4', '0', '5.3', '155.5', '1018.3', '98.9', '24.1', '5', 'cloudy' ),( '93918', '2024-06-25', '16:00:00', '20', '9.4', '50.25', '0', '19.4', '0', '8.8', '141.4', '1018.7', '99.4', '24.1', '3', 'cloudy' ),( '93918', '2024-06-25', '17:00:00', '18.4', '10.2', '58.82', '0', '19.4', '0', '12.2', '127.2', '1019', '100', '24.1', '1', 'cloudy' ),( '93918', '2024-06-25', '18:00:00', '18.1', '10.1', '59.54', '0', '19.4', '0', '12.1', '134.3', '1019.3', '100', '24.1', '1', 'cloudy' ),( '93918', '2024-06-25', '19:00:00', '17.8', '10', '60.28', '0', '19.4', '0', '12', '141.5', '1019.7', '100', '24.1', '1', 'cloudy' ),( '93918', '2024-06-25', '20:00:00', '17.6', '10', '61.03', '0', '19.4', '0', '11.9', '148.6', '1020', '100', '24.1', '1', 'cloudy' ),( '93918', '2024-06-25', '21:00:00', '15.9', '9.7', '66.49', '0', '12.9', '0', '10.4', '147.2', '1020.3', '68.3', '24.1', '1', 'partly-cloudy-day' ),( '93918', '2024-06-25', '22:00:00', '14.2', '9.4', '72.54', '0', '12.9', '0', '9', '145.8', '1020.7', '36.7', '24.1', '1', 'partly-cloudy-day' ),( '93918', '2024-06-25', '23:00:00', '12.6', '9.1', '79.24', '0', '12.9', '0', '7.6', '144.4', '1021', '5', '24.1', '0', 'clear-day' ) 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 ( '93918', '2024-06-26', '00:00:00', '12.4', '9', '79.93', '0', '12.9', '0', '6.6', '186.3', '1021', '36.3', '24.1', '0', 'partly-cloudy-night' ),( '93918', '2024-06-26', '01:00:00', '12.2', '8.9', '80.62', '0', '12.9', '0', '5.6', '228.2', '1021', '67.7', '24.1', '0', 'partly-cloudy-night' ),( '93918', '2024-06-26', '02:00:00', '12', '8.9', '81.32', '0', '12.9', '0', '4.7', '270.1', '1021', '99', '24.1', '0', 'cloudy' ),( '93918', '2024-06-26', '03:00:00', '12.5', '8.9', '78.69', '0', '12.9', '0', '7.4', '275.3', '1021', '99.3', '24.1', '0', 'cloudy' ),( '93918', '2024-06-26', '04:00:00', '13', '8.9', '76.16', '0', '12.9', '0', '10.2', '280.6', '1021', '99.7', '24.1', '0', 'cloudy' ),( '93918', '2024-06-26', '05:00:00', '13.5', '8.9', '73.71', '0', '12.9', '0', '13', '285.8', '1021', '100', '24.1', '0', 'cloudy' ),( '93918', '2024-06-26', '06:00:00', '14.1', '9.1', '72.02', '0', '12.9', '0', '14.8', '290', '1021', '100', '24.1', '0', 'cloudy' ),( '93918', '2024-06-26', '07:00:00', '14.7', '9.3', '70.38', '0', '12.9', '0', '16.6', '294.3', '1021', '100', '24.1', '1', 'cloudy' ),( '93918', '2024-06-26', '08:00:00', '15.3', '9.6', '68.78', '0', '12.9', '0', '18.4', '298.5', '1021', '100', '24.1', '1', 'cloudy' ),( '93918', '2024-06-26', '09:00:00', '16.4', '7.1', '53.77', '0', '29', '0', '18.8', '304.3', '1021.3', '100', '24.1', '2', 'cloudy' ),( '93918', '2024-06-26', '10:00:00', '17.7', '4.6', '41.92', '0', '29', '0', '19.3', '310.2', '1021.7', '100', '24.1', '3', 'cloudy' ),( '93918', '2024-06-26', '11:00:00', '18.9', '2.1', '32.59', '0', '29', '0', '19.8', '316', '1022', '100', '24.1', '4', 'cloudy' ),( '93918', '2024-06-26', '12:00:00', '19.4', '2.2', '31.9', '0', '29', '0', '19.6', '313.2', '1021.7', '100', '24.1', '5', 'cloudy' ),( '93918', '2024-06-26', '13:00:00', '19.9', '2.4', '31.23', '0', '29', '0', '19.3', '310.5', '1021.3', '100', '24.1', '6', 'cloudy' ),( '93918', '2024-06-26', '14:00:00', '20.5', '2.6', '30.58', '0', '29', '0', '19.1', '307.7', '1021', '100', '24.1', '6', 'cloudy' ),( '93918', '2024-06-26', '15:00:00', '21', '2.7', '29.8', '0', '35.5', '0', '18.2', '305.5', '1021', '68.3', '24.1', '6', 'partly-cloudy-day' ),( '93918', '2024-06-26', '16:00:00', '21.5', '2.8', '29.05', '0', '35.5', '0', '17.4', '303.3', '1021', '36.7', '24.1', '6', 'partly-cloudy-day' ),( '93918', '2024-06-26', '17:00:00', '22.1', '2.9', '28.32', '0', '35.5', '0', '16.6', '301.1', '1021', '5', '24.1', '6', 'clear-day' ),( '93918', '2024-06-26', '18:00:00', '21.3', '3.6', '31.33', '0', '35.5', '0', '16', '300.8', '1021', '7.6', '24.1', '5', 'clear-day' ),( '93918', '2024-06-26', '19:00:00', '20.5', '4.4', '34.65', '0', '35.5', '0', '15.4', '300.4', '1021', '10.2', '24.1', '4', 'clear-day' ),( '93918', '2024-06-26', '20:00:00', '19.8', '5.2', '38.33', '0', '35.5', '0', '14.8', '300.1', '1021', '12.8', '24.1', '4', 'clear-day' ),( '93918', '2024-06-26', '21:00:00', '17.7', '5.1', '43.41', '0', '19.4', '0', '13', '299.9', '1021.7', '10.2', '24.1', '3', 'clear-day' ),( '93918', '2024-06-26', '22:00:00', '15.6', '5', '49.26', '0', '19.4', '0', '11.2', '299.6', '1022.3', '7.6', '24.1', '2', 'clear-day' ),( '93918', '2024-06-26', '23:00:00', '13.5', '4.9', '56.02', '0', '19.4', '0', '9.4', '299.4', '1023', '5', '24.1', '1', 'clear-day' ) 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 ( '93918', '2024-06-27', '00:00:00', '12.4', '4.8', '59.79', '0', '19.4', '0', '8.4', '298.6', '1023', '5', '24.1', '0', 'clear-night' ),( '93918', '2024-06-27', '01:00:00', '11.3', '4.7', '63.85', '0', '19.4', '0', '7.4', '297.7', '1023', '5', '24.1', '0', 'clear-night' ),( '93918', '2024-06-27', '02:00:00', '10.3', '4.7', '68.23', '0', '19.4', '0', '6.5', '296.9', '1023', '5', '24.1', '0', 'clear-night' ),( '93918', '2024-06-27', '03:00:00', '10.6', '5', '67.99', '0', '12.9', '0', '6', '295.5', '1023', '5.1', '24.1', '0', 'clear-day' ),( '93918', '2024-06-27', '04:00:00', '11', '5.3', '67.75', '0', '12.9', '0', '5.5', '294', '1023', '5.1', '24.1', '0', 'clear-day' ),( '93918', '2024-06-27', '05:00:00', '11.4', '5.6', '67.51', '0', '12.9', '0', '5', '292.6', '1023', '5.2', '24.1', '0', 'clear-day' ),( '93918', '2024-06-27', '06:00:00', '13.1', '5.6', '60.24', '0', '12.9', '0', '6', '293.1', '1022.7', '5.1', '24.1', '1', 'clear-day' ),( '93918', '2024-06-27', '07:00:00', '14.8', '5.6', '53.83', '0', '12.9', '0', '7', '293.5', '1022.3', '5', '24.1', '2', 'clear-day' ),( '93918', '2024-06-27', '08:00:00', '16.6', '5.6', '48.18', '0', '12.9', '0', '7.9', '294', '1022', '4.9', '24.1', '3', 'clear-day' ),( '93918', '2024-06-27', '09:00:00', '17.9', '5.4', '43.59', '0', '22.6', '0', '8.5', '290.7', '1021.7', '3.3', '24.1', '4', 'clear-day' ),( '93918', '2024-06-27', '10:00:00', '19.4', '5.2', '39.48', '0', '22.6', '0', '9.1', '287.3', '1021.3', '1.7', '24.1', '5', 'clear-day' ),( '93918', '2024-06-27', '11:00:00', '20.8', '5.1', '35.79', '0', '22.6', '0', '9.7', '284', '1021', '0.1', '24.1', '6', 'clear-day' ),( '93918', '2024-06-27', '12:00:00', '21.8', '4.6', '32.5', '0', '22.6', '0', '10.7', '289.5', '1020.7', '0.8', '24.1', '6', 'clear-day' ),( '93918', '2024-06-27', '13:00:00', '22.8', '4.1', '29.53', '0', '22.6', '0', '11.6', '295', '1020.3', '1.6', '24.1', '7', 'clear-day' ),( '93918', '2024-06-27', '14:00:00', '23.8', '3.6', '26.84', '0', '22.6', '0', '12.6', '300.5', '1020', '2.3', '24.1', '8', 'clear-day' ),( '93918', '2024-06-27', '15:00:00', '24', '4.4', '28.07', '0', '22.6', '0', '13.1', '302.7', '1019.7', '3.7', '24.1', '7', 'clear-day' ),( '93918', '2024-06-27', '16:00:00', '24.3', '5.3', '29.35', '0', '22.6', '0', '13.6', '304.9', '1019.3', '5.2', '24.1', '7', 'clear-day' ),( '93918', '2024-06-27', '17:00:00', '24.6', '6.2', '30.67', '0', '22.6', '0', '14', '307.1', '1019', '6.6', '24.1', '7', 'clear-day' ),( '93918', '2024-06-27', '18:00:00', '23.8', '6.7', '33.3', '0', '22.6', '0', '13.9', '301.3', '1019', '4.4', '24.1', '6', 'clear-day' ),( '93918', '2024-06-27', '19:00:00', '23', '7.2', '36.17', '0', '22.6', '0', '13.8', '295.4', '1019', '2.2', '24.1', '5', 'clear-day' ),( '93918', '2024-06-27', '20:00:00', '22.2', '7.7', '39.29', '0', '22.6', '0', '13.7', '289.6', '1019', '0', '24.1', '4', 'clear-day' ),( '93918', '2024-06-27', '21:00:00', '19.9', '7.8', '45.56', '0', '19.4', '0', '11.6', '291.9', '1019.3', '0', '24.1', '3', 'clear-day' ),( '93918', '2024-06-27', '22:00:00', '17.6', '7.9', '52.97', '0', '19.4', '0', '9.6', '294.3', '1019.7', '0', '24.1', '2', 'clear-day' ),( '93918', '2024-06-27', '23:00:00', '15.3', '8', '61.73', '0', '19.4', '0', '7.6', '296.6', '1020', '0', '24.1', '1', 'clear-day' ) 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 ( '93918', '2024-06-28', '00:00:00', '14.4', '7.9', '64.7', '0', '19.4', '0', '7.3', '300', '1020.3', '0', '24.1', '0', 'clear-night' ),( '93918', '2024-06-28', '01:00:00', '13.6', '7.8', '67.82', '0', '19.4', '0', '7.1', '303.3', '1020.7', '0', '24.1', '0', 'clear-night' ),( '93918', '2024-06-28', '02:00:00', '12.8', '7.7', '71.13', '0', '19.4', '0', '6.8', '306.7', '1021', '0', '24.1', '0', 'clear-night' ),( '93918', '2024-06-28', '03:00:00', '13', '7.9', '71.01', '0', '16.1', '0', '6.6', '302.5', '1021', '0', '24.1', '0', 'clear-day' ),( '93918', '2024-06-28', '04:00:00', '13.2', '8.1', '70.9', '0', '16.1', '0', '6.4', '298.3', '1021', '0', '24.1', '0', 'clear-day' ),( '93918', '2024-06-28', '05:00:00', '13.5', '8.3', '70.78', '0', '16.1', '0', '6.1', '294.1', '1021', '0', '24.1', '0', 'clear-day' ),( '93918', '2024-06-28', '06:00:00', '15', '8.1', '63.38', '0', '16.1', '0', '7.2', '297.8', '1020.7', '0', '24.1', '1', 'clear-day' ),( '93918', '2024-06-28', '07:00:00', '16.6', '8', '56.82', '0', '16.1', '0', '8.3', '301.5', '1020.3', '0', '24.1', '2', 'clear-day' ),( '93918', '2024-06-28', '08:00:00', '18.2', '7.9', '51', '0', '16.1', '0', '9.4', '305.2', '1020', '0', '24.1', '3', 'clear-day' ),( '93918', '2024-06-28', '09:00:00', '19.6', '7.2', '44.56', '0', '51.6', '0', '9.5', '307.3', '1020', '0', '24.1', '4', 'showers-day' ),( '93918', '2024-06-28', '10:00:00', '21', '6.5', '38.96', '0', '51.6', '0', '9.6', '309.4', '1020', '0', '24.1', '5', 'showers-day' ),( '93918', '2024-06-28', '11:00:00', '22.5', '5.9', '34.09', '0', '51.6', '0', '9.7', '311.5', '1020', '0', '24.1', '6', 'showers-day' ),( '93918', '2024-06-28', '12:00:00', '23.4', '5.7', '31.84', '0', '51.6', '0', '9.8', '308.9', '1019.7', '1.7', '24.1', '6', 'showers-day' ),( '93918', '2024-06-28', '13:00:00', '24.3', '5.4', '29.75', '0', '51.6', '0', '10', '306.4', '1019.3', '3.3', '24.1', '7', 'showers-day' ),( '93918', '2024-06-28', '14:00:00', '25.2', '5.3', '27.8', '0', '51.6', '0', '10.1', '303.8', '1019', '5', '24.1', '8', 'showers-day' ),( '93918', '2024-06-28', '15:00:00', '25.5', '5.2', '27.19', '0', '35.5', '0', '10.2', '305.3', '1018.7', '21.8', '24.1', '7', 'partly-cloudy-day' ),( '93918', '2024-06-28', '16:00:00', '25.8', '5.2', '26.6', '0', '35.5', '0', '10.3', '306.8', '1018.3', '38.5', '24.1', '7', 'partly-cloudy-day' ),( '93918', '2024-06-28', '17:00:00', '26.2', '5.2', '26.02', '0', '35.5', '0', '10.4', '308.3', '1018', '55.3', '24.1', '7', 'partly-cloudy-day' ),( '93918', '2024-06-28', '18:00:00', '25.3', '6.8', '30.6', '0', '35.5', '0', '9.4', '303.2', '1018', '41.4', '24.1', '5', 'partly-cloudy-day' ),( '93918', '2024-06-28', '19:00:00', '24.5', '8.4', '35.95', '0', '35.5', '0', '8.3', '298.1', '1018', '27.5', '24.1', '4', 'partly-cloudy-day' ),( '93918', '2024-06-28', '20:00:00', '23.7', '10.1', '42.18', '0', '35.5', '0', '7.2', '293', '1018', '13.6', '24.1', '3', 'clear-day' ),( '93918', '2024-06-28', '21:00:00', '21.5', '10', '48.11', '0', '22.6', '0', '7', '295.5', '1018.3', '36.5', '24.1', '2', 'partly-cloudy-day' ),( '93918', '2024-06-28', '22:00:00', '19.3', '10', '54.98', '0', '22.6', '0', '6.7', '298', '1018.7', '59.5', '24.1', '2', 'partly-cloudy-day' ),( '93918', '2024-06-28', '23:00:00', '17.1', '10', '62.99', '0', '22.6', '0', '6.5', '300.5', '1019', '82.4', '24.1', '1', 'partly-cloudy-day' ) 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 ( '93918', '2024-06-29', '00:00:00', '16.2', '9.6', '64.94', '0', '22.6', '0', '6.2', '303', '1019.3', '71.5', '24.1', '0', 'partly-cloudy-night' ),( '93918', '2024-06-29', '01:00:00', '15.3', '9.2', '66.97', '0', '22.6', '0', '6', '305.4', '1019.7', '60.7', '24.1', '0', 'partly-cloudy-night' ),( '93918', '2024-06-29', '02:00:00', '14.5', '8.9', '69.08', '0', '22.6', '0', '5.8', '307.9', '1020', '49.8', '24.1', '0', 'partly-cloudy-night' ),( '93918', '2024-06-29', '03:00:00', '14.7', '9.1', '69.28', '0', '12.9', '0', '5.5', '310.9', '1020', '34.9', '24.1', '0', 'partly-cloudy-day' ),( '93918', '2024-06-29', '04:00:00', '14.9', '9.3', '69.47', '0', '12.9', '0', '5.3', '313.8', '1020', '19.9', '24.1', '0', 'clear-day' ),( '93918', '2024-06-29', '05:00:00', '15.1', '9.6', '69.67', '0', '12.9', '0', '5', '316.8', '1020', '5', '24.1', '0', 'clear-day' ),( '93918', '2024-06-29', '06:00:00', '17', '9.4', '61.04', '0', '12.9', '0', '4.6', '218.4', '1020', '30.7', '24.1', '1', 'partly-cloudy-day' ),( '93918', '2024-06-29', '07:00:00', '19', '9.4', '53.58', '0', '12.9', '0', '4.1', '120', '1020', '56.3', '24.1', '2', 'partly-cloudy-day' ),( '93918', '2024-06-29', '08:00:00', '21', '9.3', '47.12', '0', '12.9', '0', '3.6', '21.6', '1020', '82', '24.1', '3', 'partly-cloudy-day' ),( '93918', '2024-06-29', '09:00:00', '22.5', '9.4', '43.19', '0', '32.3', '0', '2.6', '112.8', '1019.7', '71.3', '24.1', '4', 'partly-cloudy-day' ),( '93918', '2024-06-29', '10:00:00', '24', '9.4', '39.64', '0', '32.3', '0', '1.7', '203.9', '1019.3', '60.6', '24.1', '5', 'partly-cloudy-day' ),( '93918', '2024-06-29', '11:00:00', '25.6', '9.6', '36.41', '0', '32.3', '0', '0.7', '295.1', '1019', '49.9', '24.1', '6', 'partly-cloudy-day' ),( '93918', '2024-06-29', '12:00:00', '26.3', '8.9', '33.33', '0', '32.3', '0', '2.5', '282.8', '1019', '57.2', '24.1', '6', 'partly-cloudy-day' ),( '93918', '2024-06-29', '13:00:00', '27', '8.2', '30.5', '0', '32.3', '0', '4.3', '270.6', '1019', '64.4', '24.1', '7', 'partly-cloudy-day' ),( '93918', '2024-06-29', '14:00:00', '27.7', '7.5', '27.91', '0', '32.3', '0', '6.1', '258.3', '1019', '71.7', '24.1', '8', 'partly-cloudy-day' ),( '93918', '2024-06-29', '15:00:00', '27.7', '6.8', '26.5', '0', '35.5', '0', '6', '261.6', '1018.7', '81.1', '24.1', '7', 'partly-cloudy-day' ),( '93918', '2024-06-29', '16:00:00', '27.8', '6.1', '25.16', '0', '35.5', '0', '5.9', '264.9', '1018.3', '90.5', '24.1', '7', 'cloudy' ),( '93918', '2024-06-29', '17:00:00', '27.9', '5.4', '23.87', '0', '35.5', '0', '5.8', '268.2', '1018', '99.9', '24.1', '7', 'cloudy' ),( '93918', '2024-06-29', '18:00:00', '25.1', '7.1', '31.74', '0', '35.5', '0', '7.6', '225.9', '1018.3', '99.9', '24.1', '5', 'cloudy' ),( '93918', '2024-06-29', '19:00:00', '22.3', '8.8', '42.26', '0', '35.5', '0', '9.4', '183.5', '1018.7', '100', '24.1', '4', 'cloudy' ),( '93918', '2024-06-29', '20:00:00', '19.5', '10.6', '56.4', '0', '35.5', '0', '11.2', '141.2', '1019', '100', '24.1', '3', 'cloudy' ),( '93918', '2024-06-29', '21:00:00', '17.8', '10.1', '60.42', '0', '25.8', '0', '10.1', '146.1', '1019.3', '94.1', '24.1', '2', 'cloudy' ),( '93918', '2024-06-29', '22:00:00', '16.2', '9.6', '64.79', '0', '25.8', '0', '9', '151', '1019.7', '88.3', '24.1', '1', 'partly-cloudy-day' ),( '93918', '2024-06-29', '23:00:00', '14.6', '9.1', '69.57', '0', '25.8', '0', '7.9', '155.9', '1020', '82.4', '24.1', '0', 'partly-cloudy-day' ) 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 em Grundtjärn

A previsão do tempo para hoje, amanhã e os próximos 10 dias em Grundtjärn, Suécia

O clima para hoje em Grundtjärn

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 Grundtjärn por mês

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

1
Janeiro
2
Fevereiro
3
Março
4
Abril
5
Maio
6
Junho
7
Julho
8
Agosto
9
Setembro
10
Outubro
11
Novembro
12
Dezembro