Buscar Menu
200

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 ( '10063', '2024-06-16', '00:00:00', '24.7', '6.6', '31.33', '0', '0', '0', '15.8', '204.5', '1010', '62.8', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-16', '01:00:00', '22.6', '9.1', '42.16', '0', '0', '0', '10.1', '169.5', '1010', '30.1', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-16', '02:00:00', '22.2', '9.7', '44.98', '0', '0', '0', '7.2', '200.5', '1010', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-16', '03:00:00', '23', '8.4', '39.25', '0', '0', '0', '6.8', '210.3', '1010', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-16', '04:00:00', '22.7', '8.7', '40.79', '0', '0', '0', '9', '189', '1010', '45.8', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-16', '05:00:00', '21', '9.6', '48.08', '0', '0', '0', '6.8', '186', '1011', '72.6', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-16', '06:00:00', '21.5', '10.1', '48.21', '0', '0', '0', '13.3', '166.5', '1012', '39.6', '24.1', '0', 'partly-cloudy-day' ),( '10063', '2024-06-16', '07:00:00', '21.8', '8.6', '42.79', '0', '0', '0', '11.5', '177.2', '1012', '14.4', '24.1', '1', 'clear-day' ),( '10063', '2024-06-16', '08:00:00', '23.4', '7.9', '37.03', '0', '0', '0', '5', '181.5', '1012', '3.1', '24.1', '4', 'clear-day' ),( '10063', '2024-06-16', '09:00:00', '25.5', '6.8', '30.29', '0', '0', '0', '8.6', '199', '1012', '0', '24.1', '6', 'clear-day' ),( '10063', '2024-06-16', '10:00:00', '27.3', '6.3', '26.32', '0', '0', '0', '10.8', '194.1', '1011', '0', '24.1', '8', 'clear-day' ),( '10063', '2024-06-16', '11:00:00', '28.7', '5.6', '23.11', '0', '0', '0', '11.2', '177.6', '1010', '30.6', '24.1', '9', 'partly-cloudy-day' ),( '10063', '2024-06-16', '12:00:00', '29.8', '4.7', '20.37', '0', '0', '0', '10.8', '156', '1008', '63.5', '24.1', '10', 'partly-cloudy-day' ),( '10063', '2024-06-16', '13:00:00', '30.4', '5.4', '20.66', '0', '0', '0', '13.3', '157.6', '1007', '85', '24.1', '9', 'partly-cloudy-day' ),( '10063', '2024-06-16', '14:00:00', '29.3', '8.5', '27.22', '0', '0', '0', '21.6', '167.7', '1007', '78.3', '24.1', '7', 'partly-cloudy-day' ),( '10063', '2024-06-16', '15:00:00', '27.5', '11.3', '36.46', '0', '0', '0', '25.2', '184.9', '1007', '82.3', '24.1', '6', 'partly-cloudy-day' ),( '10063', '2024-06-16', '16:00:00', '27.4', '11.2', '36.43', '0', '0', '0', '19.4', '186.4', '1007', '96.2', '24.1', '5', 'cloudy' ),( '10063', '2024-06-16', '17:00:00', '26.8', '11.2', '37.74', '0', '0', '0', '18', '173.6', '1008', '92.1', '24.1', '3', 'cloudy' ),( '10063', '2024-06-16', '18:00:00', '25.4', '11.3', '41.27', '0', '0', '0', '16.9', '183.5', '1009', '95.5', '24.1', '1', 'cloudy' ),( '10063', '2024-06-16', '19:00:00', '25', '9.7', '37.99', '0', '0', '0', '14.8', '192.8', '1010', '95', '24.1', '0', 'cloudy' ),( '10063', '2024-06-16', '20:00:00', '25.1', '8.3', '34.36', '0', '0', '0', '11.9', '188.7', '1010', '96.2', '24.1', '0', 'cloudy' ),( '10063', '2024-06-16', '21:00:00', '24.7', '8.5', '35.67', '0', '0', '0', '10.4', '184', '1011', '96.2', '24.1', '0', 'cloudy' ),( '10063', '2024-06-16', '22:00:00', '24.3', '9', '37.79', '0', '0', '0', '8.3', '176.4', '1011', '91.7', '24.1', '0', 'cloudy' ),( '10063', '2024-06-16', '23:00:00', '23.9', '8.8', '38.19', '0', '0', '0', '4.3', '202.8', '1011', '62.7', '24.1', '0', 'partly-cloudy-night' ) ON DUPLICATE KEY UPDATE temp = VALUES(temp), dew = VALUES(dew), humidity = VALUES(humidity), precip = VALUES(precip), precipprob = VALUES(precipprob), snow = VALUES(snow), windspeed = VALUES(windspeed), winddir = VALUES(winddir), pressure = VALUES(pressure), cloudcover = VALUES(cloudcover), visibility = VALUES(visibility), uvindex = VALUES(uvindex), icon = VALUES(icon)

INSERT INTO w_hours_17 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '10063', '2024-06-17', '00:00:00', '23.5', '8.8', '39.12', '0', '0', '0', '5.8', '248.3', '1010', '68', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-17', '01:00:00', '23.2', '9.5', '41.76', '0', '0', '0', '8.6', '271.7', '1010', '50.1', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-17', '02:00:00', '22.9', '9.8', '43.39', '0', '0', '0', '10.4', '286.7', '1009', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-17', '03:00:00', '22.7', '8.8', '41.06', '0', '0', '0', '10.4', '287.8', '1009', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-17', '04:00:00', '22.2', '8', '40.1', '0', '0', '0', '7.2', '275.3', '1009', '61', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-17', '05:00:00', '21.7', '7.7', '40.5', '0', '0', '0', '6.5', '200.9', '1010', '39.1', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-17', '06:00:00', '21.3', '8.8', '44.73', '0', '0', '0', '9.4', '156.2', '1011', '64', '24.1', '0', 'partly-cloudy-day' ),( '10063', '2024-06-17', '07:00:00', '21.1', '11.4', '53.88', '0', '0', '0', '9.7', '161.8', '1012', '51.1', '24.1', '1', 'partly-cloudy-day' ),( '10063', '2024-06-17', '08:00:00', '22.3', '11.2', '49.41', '0', '0', '0', '14.8', '174', '1013', '93.2', '24.1', '4', 'cloudy' ),( '10063', '2024-06-17', '09:00:00', '23.7', '9.9', '41.62', '0', '0', '0', '13.7', '189.4', '1012', '70.1', '24.1', '6', 'partly-cloudy-day' ),( '10063', '2024-06-17', '10:00:00', '25.8', '9.1', '34.79', '0', '0', '0', '10.8', '213.7', '1011', '5.9', '24.1', '8', 'clear-day' ),( '10063', '2024-06-17', '11:00:00', '28', '7.3', '27.05', '0', '0', '0', '10.8', '184.5', '1010', '9.3', '24.1', '9', 'clear-day' ),( '10063', '2024-06-17', '12:00:00', '29.4', '5.9', '22.65', '0', '0', '0', '11.9', '158.3', '1008', '18.9', '24.1', '10', 'clear-day' ),( '10063', '2024-06-17', '13:00:00', '29.8', '6.6', '23.23', '0', '0', '0', '16.6', '154.2', '1007', '41.9', '24.1', '10', 'partly-cloudy-day' ),( '10063', '2024-06-17', '14:00:00', '28.8', '9.3', '29.58', '0', '0', '0', '23', '155.8', '1007', '23.4', '24.1', '9', 'partly-cloudy-day' ),( '10063', '2024-06-17', '15:00:00', '28', '10.4', '33.36', '0', '0', '0', '20.2', '167.5', '1007', '5.1', '24.1', '8', 'clear-day' ),( '10063', '2024-06-17', '16:00:00', '27.7', '10.1', '33.27', '0', '0', '0', '18.4', '169.2', '1007', '73.5', '24.1', '6', 'partly-cloudy-day' ),( '10063', '2024-06-17', '17:00:00', '25.9', '11.1', '39.54', '0', '0', '0', '18.7', '166.7', '1008', '99.7', '24.1', '4', 'cloudy' ),( '10063', '2024-06-17', '18:00:00', '24.7', '10.8', '41.63', '0', '0', '0', '16.6', '171', '1009', '100', '24.1', '1', 'cloudy' ),( '10063', '2024-06-17', '19:00:00', '23.7', '10.1', '42.18', '0', '0', '0', '16.6', '180.1', '1010', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-17', '20:00:00', '23.5', '9.4', '40.74', '0', '0', '0', '13.3', '178.1', '1011', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-17', '21:00:00', '23.5', '9.1', '39.92', '0', '0', '0', '12.6', '177.9', '1010', '97.8', '24.1', '0', 'cloudy' ),( '10063', '2024-06-17', '22:00:00', '23.3', '8.8', '39.6', '0', '0', '0', '8.6', '195.2', '1011', '89.9', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-17', '23:00:00', '23.1', '8.6', '39.54', '0', '0', '0', '6.8', '228.6', '1010', '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_18 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '10063', '2024-06-18', '00:00:00', '22.9', '8.4', '39.49', '0', '0', '0', '6.5', '232.5', '1009', '70.6', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-18', '01:00:00', '22.6', '8.2', '39.67', '0', '0', '0', '6.8', '230.2', '1009', '50.8', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-18', '02:00:00', '22', '8.4', '41.71', '0', '0', '0', '6.1', '208.2', '1009', '65.8', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-18', '03:00:00', '21.5', '8.4', '43', '0', '0', '0', '6.8', '159.5', '1009', '96.2', '24.1', '0', 'cloudy' ),( '10063', '2024-06-18', '04:00:00', '20.3', '9.1', '48.54', '0', '0', '0', '15.1', '162.3', '1010', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-18', '05:00:00', '18.8', '10.2', '57.36', '0', '0', '0', '11.5', '172.5', '1012', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-18', '06:00:00', '19', '9.9', '55.52', '0', '0', '0', '9.7', '178.4', '1012', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-18', '07:00:00', '20.6', '8.7', '46.38', '0', '0', '0', '9.4', '186.2', '1012', '99.1', '24.1', '1', 'cloudy' ),( '10063', '2024-06-18', '08:00:00', '22.4', '8.3', '40.43', '0', '0', '0', '13.7', '180.4', '1012', '8.6', '24.1', '4', 'clear-day' ),( '10063', '2024-06-18', '09:00:00', '23.8', '8', '36.4', '0', '0', '0', '13', '185.5', '1012', '38.6', '24.1', '6', 'partly-cloudy-day' ),( '10063', '2024-06-18', '10:00:00', '25.3', '7.9', '33.04', '0', '3.2', '0', '13.7', '183.4', '1011', '39.9', '24.1', '8', 'partly-cloudy-day' ),( '10063', '2024-06-18', '11:00:00', '26.7', '7.7', '30', '0', '3.2', '0', '16.6', '177.7', '1010', '84.7', '24.1', '9', 'partly-cloudy-day' ),( '10063', '2024-06-18', '12:00:00', '27.7', '8.3', '29.47', '0', '3.2', '0', '22', '172', '1009', '100', '24.1', '10', 'cloudy' ),( '10063', '2024-06-18', '13:00:00', '27.5', '10.3', '34.12', '0', '3.2', '0', '23.8', '169', '1009', '96.7', '24.1', '10', 'cloudy' ),( '10063', '2024-06-18', '14:00:00', '26.9', '11.6', '38.53', '0', '3.2', '0', '23', '173.6', '1008', '100', '24.1', '9', 'cloudy' ),( '10063', '2024-06-18', '15:00:00', '26.6', '12.5', '41.61', '0', '3.2', '0', '22.7', '181.3', '1008', '100', '24.1', '7', 'cloudy' ),( '10063', '2024-06-18', '16:00:00', '25.7', '12.7', '44.46', '0', '3.2', '0', '22', '180', '1008', '14.5', '24.1', '6', 'clear-day' ),( '10063', '2024-06-18', '17:00:00', '24.6', '12.3', '46.24', '0', '3.2', '0', '19.8', '168', '1009', '100', '24.1', '4', 'cloudy' ),( '10063', '2024-06-18', '18:00:00', '23.4', '12', '48.73', '0', '3.2', '0', '18', '174.5', '1010', '100', '24.1', '1', 'cloudy' ),( '10063', '2024-06-18', '19:00:00', '22.4', '11.8', '51.09', '0', '3.2', '0', '13.7', '181', '1010', '59.9', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-18', '20:00:00', '22.6', '10.9', '47.56', '0', '3.2', '0', '10.1', '184', '1011', '64.7', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-18', '21:00:00', '22.5', '10.4', '46.28', '0', '3.2', '0', '10.1', '187.1', '1011', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-18', '22:00:00', '22.6', '9.9', '44.49', '0', '0', '0', '4.7', '172.5', '1011', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-18', '23:00:00', '22.5', '9.2', '42.7', '0', '0', '0', '5', '226.4', '1011', '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_19 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '10063', '2024-06-19', '00:00:00', '22.6', '8.3', '39.94', '0', '0', '0', '7.2', '243.4', '1010', '93', '24.1', '0', 'cloudy' ),( '10063', '2024-06-19', '01:00:00', '22.4', '7.4', '38.02', '0', '0', '0', '6.1', '227.2', '1010', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-19', '02:00:00', '21.8', '7.4', '39.44', '0', '0', '0', '6.8', '168.8', '1009', '99.8', '24.1', '0', 'cloudy' ),( '10063', '2024-06-19', '03:00:00', '20.6', '9.5', '48.95', '0', '0', '0', '15.8', '171.4', '1010', '99.8', '24.1', '0', 'cloudy' ),( '10063', '2024-06-19', '04:00:00', '19.1', '11.2', '60.17', '0', '0', '0', '14', '175.6', '1011', '84.9', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-19', '05:00:00', '18.7', '10.4', '58.5', '0', '0', '0', '9.7', '172.8', '1011', '5', '24.1', '0', 'clear-night' ),( '10063', '2024-06-19', '06:00:00', '19.1', '9.5', '53.72', '0', '0', '0', '5.8', '185', '1012', '4', '24.1', '0', 'clear-day' ),( '10063', '2024-06-19', '07:00:00', '21', '8.7', '45.25', '0', '0', '0', '6.8', '216.2', '1011', '5', '24.1', '1', 'clear-day' ),( '10063', '2024-06-19', '08:00:00', '23', '8.6', '39.78', '0', '0', '0', '12.2', '189.4', '1011', '5', '24.1', '4', 'clear-day' ),( '10063', '2024-06-19', '09:00:00', '24.3', '8.9', '37.54', '0', '0', '0', '13', '184.6', '1011', '0', '24.1', '6', 'clear-day' ),( '10063', '2024-06-19', '10:00:00', '25.6', '8.8', '34.5', '0', '0', '0', '13', '188.6', '1011', '0', '24.1', '8', 'clear-day' ),( '10063', '2024-06-19', '11:00:00', '27.6', '7.9', '28.85', '0', '0', '0', '16.6', '183.5', '1009', '20.4', '24.1', '9', 'partly-cloudy-day' ),( '10063', '2024-06-19', '12:00:00', '28.8', '7.6', '26.36', '0', '0', '0', '19.1', '169.3', '1008', '41.1', '24.1', '10', 'partly-cloudy-day' ),( '10063', '2024-06-19', '13:00:00', '29', '8.5', '27.7', '0', '0', '0', '21.6', '167.4', '1007', '45.6', '24.1', '10', 'partly-cloudy-day' ),( '10063', '2024-06-19', '14:00:00', '28.4', '10.4', '32.59', '0', '0', '0', '23', '179.3', '1006', '5.4', '24.1', '9', 'clear-day' ),( '10063', '2024-06-19', '15:00:00', '27.6', '12.1', '38.22', '0', '0', '0', '22', '177.4', '1006', '63.9', '24.1', '8', 'partly-cloudy-day' ),( '10063', '2024-06-19', '16:00:00', '26.6', '12.7', '42.16', '0', '3.2', '0', '19.4', '162.2', '1006', '98.3', '24.1', '6', 'cloudy' ),( '10063', '2024-06-19', '17:00:00', '26', '13', '44.54', '0', '3.2', '0', '17.3', '172.2', '1007', '98.6', '24.1', '4', 'cloudy' ),( '10063', '2024-06-19', '18:00:00', '24.7', '13.8', '50.7', '0', '3.2', '0', '15.1', '176.1', '1008', '78.9', '24.1', '1', 'partly-cloudy-day' ),( '10063', '2024-06-19', '19:00:00', '23.7', '14.2', '55.25', '0', '3.2', '0', '10.4', '176.9', '1009', '91.4', '24.1', '0', 'cloudy' ),( '10063', '2024-06-19', '20:00:00', '23.6', '14', '54.87', '0', '3.2', '0', '7.2', '155.4', '1009', '84.6', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-19', '21:00:00', '23.4', '13.7', '54.46', '0', '3.2', '0', '6.1', '157.8', '1010', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-19', '22:00:00', '23.3', '13.5', '54.08', '0', '0', '0', '5', '183.7', '1010', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-19', '23:00:00', '23.1', '13.1', '53.33', '0', '0', '0', '6.1', '234.7', '1010', '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 ( '10063', '2024-06-20', '00:00:00', '23', '12.7', '52.27', '0', '0', '0', '6.5', '273.5', '1010', '73.3', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-20', '01:00:00', '22.9', '12.4', '51.56', '0', '0', '0', '8.3', '293.3', '1009', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-20', '02:00:00', '23.1', '11.1', '46.75', '0', '0', '0', '9.4', '291.4', '1008', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-20', '03:00:00', '22.6', '9.5', '43.31', '0', '0', '0', '6.1', '274', '1008', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-20', '04:00:00', '21.8', '10.4', '48.3', '0', '0', '0', '10.4', '166.4', '1009', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-20', '05:00:00', '20', '12.4', '61.59', '0', '0', '0', '8.6', '148.2', '1010', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-20', '06:00:00', '19.6', '12.3', '62.72', '0', '0', '0', '6.5', '146.1', '1011', '5.6', '24.1', '0', 'clear-day' ),( '10063', '2024-06-20', '07:00:00', '20.8', '12', '57.1', '0', '0', '0', '5.4', '172.3', '1011', '5', '24.1', '1', 'clear-day' ),( '10063', '2024-06-20', '08:00:00', '22.6', '12.2', '51.82', '0', '0', '0', '13.7', '177.6', '1011', '5', '24.1', '4', 'clear-day' ),( '10063', '2024-06-20', '09:00:00', '24.3', '11.8', '45.56', '0', '0', '0', '18', '187.5', '1011', '5', '24.1', '6', 'clear-day' ),( '10063', '2024-06-20', '10:00:00', '25.4', '10.8', '39.93', '0', '3.2', '0', '17.6', '171.8', '1011', '48.3', '24.1', '8', 'partly-cloudy-day' ),( '10063', '2024-06-20', '11:00:00', '26.1', '10.2', '36.8', '0', '3.2', '0', '15.5', '164.5', '1010', '100', '24.1', '9', 'cloudy' ),( '10063', '2024-06-20', '12:00:00', '27.3', '9.6', '32.94', '0', '3.2', '0', '16.2', '165.9', '1009', '100', '24.1', '9', 'cloudy' ),( '10063', '2024-06-20', '13:00:00', '28', '9.1', '30.57', '0', '3.2', '0', '16.6', '159.6', '1008', '100', '24.1', '9', 'cloudy' ),( '10063', '2024-06-20', '14:00:00', '28.7', '8.9', '28.96', '0', '3.2', '0', '15.5', '157.4', '1007', '100', '24.1', '8', 'cloudy' ),( '10063', '2024-06-20', '15:00:00', '28.9', '8.9', '28.62', '0', '3.2', '0', '14.8', '170.5', '1006', '99.9', '24.1', '6', 'cloudy' ),( '10063', '2024-06-20', '16:00:00', '28.5', '9', '29.44', '0', '12.9', '0', '12.6', '159.5', '1006.3', '99.9', '24.1', '5', 'cloudy' ),( '10063', '2024-06-20', '17:00:00', '28.1', '9.1', '30.28', '0', '12.9', '0', '10.4', '148.4', '1006.7', '100', '24.1', '3', 'cloudy' ),( '10063', '2024-06-20', '18:00:00', '27.8', '9.2', '31.14', '0.1', '12.9', '0', '8.3', '137.4', '1007', '100', '24.1', '2', 'cloudy' ),( '10063', '2024-06-20', '19:00:00', '27.2', '8.2', '30.03', '0', '12.9', '0', '8.5', '119', '1007.7', '95.9', '24.1', '0', 'cloudy' ),( '10063', '2024-06-20', '20:00:00', '26.7', '7.2', '28.94', '0', '12.9', '0', '8.8', '100.7', '1008.3', '91.9', '24.1', '0', 'cloudy' ),( '10063', '2024-06-20', '21:00:00', '26.2', '6.2', '27.88', '0', '12.9', '0', '9', '82.3', '1009', '87.8', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-20', '22:00:00', '25.9', '6.7', '29.39', '0', '9.7', '0', '9', '121.8', '1009', '91.3', '24.1', '0', 'cloudy' ),( '10063', '2024-06-20', '23:00:00', '25.7', '7.3', '30.98', '0', '9.7', '0', '9', '161.4', '1009', '94.7', '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_21 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '10063', '2024-06-21', '00:00:00', '25.5', '7.9', '32.65', '0.1', '9.7', '0', '9', '200.9', '1009', '98.2', '24.1', '0', 'cloudy' ),( '10063', '2024-06-21', '01:00:00', '24.8', '7.9', '33.99', '0', '9.7', '0', '7.4', '246.9', '1009', '93.3', '20.6', '0', 'cloudy' ),( '10063', '2024-06-21', '02:00:00', '24.2', '7.9', '35.38', '0', '9.7', '0', '5.9', '293', '1009', '88.5', '17', '0', 'partly-cloudy-night' ),( '10063', '2024-06-21', '03:00:00', '23.6', '8', '36.84', '0', '9.7', '0', '4.3', '339', '1009', '83.6', '13.5', '0', 'partly-cloudy-night' ),( '10063', '2024-06-21', '04:00:00', '23.2', '8.7', '39.75', '0', '6.5', '0', '4.2', '287.8', '1009.7', '76.3', '17', '0', 'partly-cloudy-night' ),( '10063', '2024-06-21', '05:00:00', '22.8', '9.5', '42.88', '0', '6.5', '0', '4.1', '236.7', '1010.3', '69', '20.6', '0', 'partly-cloudy-night' ),( '10063', '2024-06-21', '06:00:00', '22.4', '10.3', '46.25', '0.3', '6.5', '0', '4', '185.5', '1011', '61.7', '24.1', '0', 'partly-cloudy-day' ),( '10063', '2024-06-21', '07:00:00', '23.1', '10.5', '44.94', '0', '6.5', '0', '5.9', '189.1', '1011.3', '58.2', '24.1', '1', 'partly-cloudy-day' ),( '10063', '2024-06-21', '08:00:00', '23.9', '10.8', '43.68', '0', '6.5', '0', '7.8', '192.7', '1011.7', '54.6', '24.1', '2', 'partly-cloudy-day' ),( '10063', '2024-06-21', '09:00:00', '24.7', '11.1', '42.46', '0', '6.5', '0', '9.7', '196.3', '1012', '51.1', '24.1', '3', 'partly-cloudy-day' ),( '10063', '2024-06-21', '10:00:00', '26.4', '10.5', '36.98', '0', '12.9', '0', '11.9', '189.9', '1011', '57.9', '24.1', '5', 'partly-cloudy-day' ),( '10063', '2024-06-21', '11:00:00', '28.1', '10', '32.23', '0', '12.9', '0', '14', '183.6', '1010', '64.7', '24.1', '7', 'partly-cloudy-day' ),( '10063', '2024-06-21', '12:00:00', '29.9', '9.5', '28.13', '0', '12.9', '0', '16.2', '177.2', '1009', '71.5', '24.1', '9', 'partly-cloudy-day' ),( '10063', '2024-06-21', '13:00:00', '28.4', '10.6', '33.1', '0', '12.9', '0', '18.7', '184.8', '1008.7', '54.1', '24.1', '7', 'partly-cloudy-day' ),( '10063', '2024-06-21', '14:00:00', '26.9', '11.7', '38.95', '0', '12.9', '0', '21.2', '192.5', '1008.3', '36.8', '24.1', '5', 'partly-cloudy-day' ),( '10063', '2024-06-21', '15:00:00', '25.4', '12.9', '45.86', '0.1', '12.9', '0', '23.8', '200.1', '1008', '19.4', '24.1', '2', 'clear-day' ),( '10063', '2024-06-21', '16:00:00', '23.3', '12.5', '50.56', '0', '38.7', '0', '25.4', '152.5', '1009.7', '46.3', '21.2', '3', 'partly-cloudy-day' ),( '10063', '2024-06-21', '17:00:00', '21.2', '12.1', '55.85', '0', '38.7', '0', '27.1', '104.9', '1011.3', '73.1', '18.4', '3', 'partly-cloudy-day' ),( '10063', '2024-06-21', '18:00:00', '19.2', '11.7', '61.81', '2.6', '38.7', '0', '28.8', '57.3', '1013', '100', '15.5', '3', 'cloudy' ),( '10063', '2024-06-21', '19:00:00', '20.8', '10.9', '52.87', '0', '38.7', '0', '23.3', '45.3', '1012.3', '96.6', '18.4', '0', 'cloudy' ),( '10063', '2024-06-21', '20:00:00', '22.5', '10.1', '45.27', '0', '38.7', '0', '17.8', '33.3', '1011.7', '93.1', '21.2', '0', 'cloudy' ),( '10063', '2024-06-21', '21:00:00', '24.2', '9.3', '38.8', '0.2', '38.7', '0', '12.2', '21.3', '1011', '89.7', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-21', '22:00:00', '23.9', '9.3', '39.6', '0', '19.4', '0', '10.9', '103.5', '1011', '87.1', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-21', '23:00:00', '23.6', '9.4', '40.42', '0', '19.4', '0', '9.6', '185.8', '1011', '84.4', '24.1', '0', 'partly-cloudy-night' ) ON DUPLICATE KEY UPDATE temp = VALUES(temp), dew = VALUES(dew), humidity = VALUES(humidity), precip = VALUES(precip), precipprob = VALUES(precipprob), snow = VALUES(snow), windspeed = VALUES(windspeed), winddir = VALUES(winddir), pressure = VALUES(pressure), cloudcover = VALUES(cloudcover), visibility = VALUES(visibility), uvindex = VALUES(uvindex), icon = VALUES(icon)

INSERT INTO w_hours_22 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '10063', '2024-06-22', '00:00:00', '23.4', '9.5', '41.26', '0.1', '19.4', '0', '8.3', '268', '1011', '81.8', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-22', '01:00:00', '23.2', '9.3', '41.21', '0', '19.4', '0', '9.7', '231.2', '1010.3', '58.8', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-22', '02:00:00', '22.9', '9.1', '41.15', '0', '19.4', '0', '11.2', '194.5', '1009.7', '35.7', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-22', '03:00:00', '22.8', '8.9', '41.09', '0', '19.4', '0', '12.6', '157.7', '1009', '12.7', '24.1', '0', 'clear-night' ),( '10063', '2024-06-22', '04:00:00', '21.9', '10', '46.85', '0', '0', '0', '11.6', '188.4', '1009.3', '41.8', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-22', '05:00:00', '21', '11.2', '53.39', '0', '0', '0', '10.7', '219.2', '1009.7', '70.9', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-22', '06:00:00', '20.2', '12.4', '60.83', '0', '0', '0', '9.7', '249.9', '1010', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-22', '07:00:00', '21.8', '11.9', '53.47', '0', '0', '0', '11.2', '231', '1010', '87.7', '24.1', '1', 'partly-cloudy-day' ),( '10063', '2024-06-22', '08:00:00', '23.4', '11.4', '47.04', '0', '0', '0', '12.6', '212.1', '1010', '75.5', '24.1', '2', 'partly-cloudy-day' ),( '10063', '2024-06-22', '09:00:00', '25', '11', '41.43', '0', '0', '0', '14', '193.2', '1010', '63.2', '24.1', '3', 'partly-cloudy-day' ),( '10063', '2024-06-22', '10:00:00', '26.1', '11.3', '39.44', '0', '0', '0', '16.1', '186.5', '1009.3', '46.4', '24.1', '5', 'partly-cloudy-day' ),( '10063', '2024-06-22', '11:00:00', '27.3', '11.6', '37.56', '0', '0', '0', '18.1', '179.9', '1008.7', '29.7', '24.1', '7', 'partly-cloudy-day' ),( '10063', '2024-06-22', '12:00:00', '28.5', '11.9', '35.79', '0', '0', '0', '20.2', '173.2', '1008', '12.9', '24.1', '9', 'clear-day' ),( '10063', '2024-06-22', '13:00:00', '28.8', '12.1', '35.65', '0', '0', '0', '20.9', '172.8', '1007', '34.8', '24.1', '9', 'partly-cloudy-day' ),( '10063', '2024-06-22', '14:00:00', '29.1', '12.3', '35.5', '0', '0', '0', '21.6', '172.3', '1006', '56.8', '24.1', '9', 'partly-cloudy-day' ),( '10063', '2024-06-22', '15:00:00', '29.5', '12.6', '35.37', '0', '0', '0', '22.3', '171.9', '1005', '78.7', '24.1', '9', 'partly-cloudy-day' ),( '10063', '2024-06-22', '16:00:00', '28.4', '13.4', '39.72', '0', '32.3', '0', '20.5', '168.4', '1005.7', '70.9', '24.1', '7', 'partly-cloudy-day' ),( '10063', '2024-06-22', '17:00:00', '27.3', '14.2', '44.61', '0', '32.3', '0', '18.7', '165', '1006.3', '63', '24.1', '5', 'partly-cloudy-day' ),( '10063', '2024-06-22', '18:00:00', '26.2', '15', '50.12', '0', '32.3', '0', '16.9', '161.5', '1007', '55.2', '24.1', '3', 'partly-cloudy-day' ),( '10063', '2024-06-22', '19:00:00', '25', '15.1', '53.95', '0', '32.3', '0', '15.2', '169.1', '1007.7', '62.1', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-22', '20:00:00', '23.9', '15.2', '58.11', '0', '32.3', '0', '13.6', '176.7', '1008.3', '68.9', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-22', '21:00:00', '22.8', '15.3', '62.63', '0.1', '32.3', '0', '11.9', '184.3', '1009', '75.8', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-22', '22:00:00', '22.8', '15.3', '62.37', '0', '6.5', '0', '10.1', '189', '1009', '57', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-22', '23:00:00', '22.9', '15.3', '62.12', '0', '6.5', '0', '8.3', '193.8', '1009', '38.3', '24.1', '0', 'partly-cloudy-night' ) ON DUPLICATE KEY UPDATE temp = VALUES(temp), dew = VALUES(dew), humidity = VALUES(humidity), precip = VALUES(precip), precipprob = VALUES(precipprob), snow = VALUES(snow), windspeed = VALUES(windspeed), winddir = VALUES(winddir), pressure = VALUES(pressure), cloudcover = VALUES(cloudcover), visibility = VALUES(visibility), uvindex = VALUES(uvindex), icon = VALUES(icon)

INSERT INTO w_hours_23 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '10063', '2024-06-23', '00:00:00', '23', '15.3', '61.87', '0', '6.5', '0', '6.5', '198.5', '1009', '19.5', '24.1', '0', 'clear-night' ),( '10063', '2024-06-23', '01:00:00', '21.9', '15.1', '65.31', '0', '6.5', '0', '10', '192', '1009', '14.4', '24.1', '0', 'clear-night' ),( '10063', '2024-06-23', '02:00:00', '20.8', '14.9', '68.98', '0', '6.5', '0', '13.4', '185.6', '1009', '9.3', '24.1', '0', 'clear-night' ),( '10063', '2024-06-23', '03:00:00', '19.8', '14.8', '72.89', '0', '6.5', '0', '16.9', '179.1', '1009', '4.2', '24.1', '0', 'clear-night' ),( '10063', '2024-06-23', '04:00:00', '19.4', '14.6', '73.47', '0', '0', '0', '13.3', '181.4', '1009.7', '2.8', '24.1', '0', 'clear-night' ),( '10063', '2024-06-23', '05:00:00', '19.2', '14.4', '74.05', '0', '0', '0', '9.7', '183.8', '1010.3', '1.4', '24.1', '0', 'clear-night' ),( '10063', '2024-06-23', '06:00:00', '18.9', '14.3', '74.64', '0', '0', '0', '6.1', '186.1', '1011', '0', '24.1', '0', 'clear-day' ),( '10063', '2024-06-23', '07:00:00', '20.6', '13.7', '64.76', '0', '0', '0', '7.8', '188.1', '1010.3', '3', '24.1', '1', 'clear-day' ),( '10063', '2024-06-23', '08:00:00', '22.3', '13.2', '56.25', '0', '0', '0', '9.5', '190.2', '1009.7', '6.1', '24.1', '3', 'clear-day' ),( '10063', '2024-06-23', '09:00:00', '24.1', '12.7', '48.92', '0', '0', '0', '11.2', '192.2', '1009', '9.1', '24.1', '4', 'clear-day' ),( '10063', '2024-06-23', '10:00:00', '25.8', '12', '42.13', '0', '3.2', '0', '14.2', '184.3', '1008', '26.1', '24.1', '6', 'partly-cloudy-day' ),( '10063', '2024-06-23', '11:00:00', '27.5', '11.3', '36.32', '0', '3.2', '0', '17.2', '176.5', '1007', '43', '24.1', '7', 'partly-cloudy-day' ),( '10063', '2024-06-23', '12:00:00', '29.3', '10.6', '31.35', '0', '3.2', '0', '20.2', '168.6', '1006', '60', '24.1', '9', 'partly-cloudy-day' ),( '10063', '2024-06-23', '13:00:00', '29.9', '9.4', '27.97', '0', '3.2', '0', '16.7', '160', '1005', '60.1', '24.1', '9', 'partly-cloudy-day' ),( '10063', '2024-06-23', '14:00:00', '30.7', '8.4', '24.95', '0', '3.2', '0', '13.2', '151.4', '1004', '60.3', '24.1', '9', 'partly-cloudy-day' ),( '10063', '2024-06-23', '15:00:00', '31.4', '7.3', '22.24', '0', '3.2', '0', '9.7', '142.8', '1003', '60.4', '24.1', '9', 'partly-cloudy-day' ),( '10063', '2024-06-23', '16:00:00', '28.7', '10.5', '32.38', '0', '19.4', '0', '13.1', '155.2', '1004.3', '67.6', '24.1', '7', 'partly-cloudy-day' ),( '10063', '2024-06-23', '17:00:00', '25.9', '13.8', '47.03', '0', '19.4', '0', '16.4', '167.5', '1005.7', '74.7', '24.1', '5', 'partly-cloudy-day' ),( '10063', '2024-06-23', '18:00:00', '23.3', '17.1', '68.15', '0.1', '19.4', '0', '19.8', '179.9', '1007', '81.9', '24.1', '4', 'partly-cloudy-day' ),( '10063', '2024-06-23', '19:00:00', '23.1', '16.7', '66.98', '0', '19.4', '0', '15.4', '171.4', '1007.7', '71.8', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-23', '20:00:00', '23', '16.3', '65.83', '0', '19.4', '0', '10.9', '162.8', '1008.3', '61.6', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-23', '21:00:00', '22.9', '15.9', '64.69', '0', '19.4', '0', '6.5', '154.3', '1009', '51.5', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-23', '22:00:00', '22.8', '15.4', '62.91', '0', '0', '0', '6.8', '171.6', '1008.7', '41.8', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-23', '23:00:00', '22.8', '14.9', '61.18', '0', '0', '0', '7.2', '188.8', '1008.3', '32', '24.1', '0', 'partly-cloudy-night' ) ON DUPLICATE KEY UPDATE temp = VALUES(temp), dew = VALUES(dew), humidity = VALUES(humidity), precip = VALUES(precip), precipprob = VALUES(precipprob), snow = VALUES(snow), windspeed = VALUES(windspeed), winddir = VALUES(winddir), pressure = VALUES(pressure), cloudcover = VALUES(cloudcover), visibility = VALUES(visibility), uvindex = VALUES(uvindex), icon = VALUES(icon)

INSERT INTO w_hours_24 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '10063', '2024-06-24', '00:00:00', '22.8', '14.5', '59.48', '0', '0', '0', '7.6', '206.1', '1008', '22.3', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-24', '01:00:00', '21.7', '15.1', '65.98', '0', '0', '0', '8.4', '190.5', '1008', '48.2', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-24', '02:00:00', '20.7', '15.7', '73.22', '0', '0', '0', '9.2', '175', '1008', '74.1', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-24', '03:00:00', '19.7', '16.4', '81.26', '0', '0', '0', '10.1', '159.4', '1008', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-24', '04:00:00', '19.5', '15.6', '78.19', '0', '3.2', '0', '8.8', '147.5', '1008.3', '81.3', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-24', '05:00:00', '19.3', '14.8', '75.21', '0', '3.2', '0', '7.4', '135.7', '1008.7', '62.6', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-24', '06:00:00', '19.2', '14.1', '72.32', '0', '3.2', '0', '6.1', '123.8', '1009', '43.9', '24.1', '0', 'partly-cloudy-day' ),( '10063', '2024-06-24', '07:00:00', '20.2', '13.4', '65.37', '0', '3.2', '0', '9.1', '137.9', '1009.3', '30.9', '24.1', '1', 'partly-cloudy-day' ),( '10063', '2024-06-24', '08:00:00', '21.2', '12.9', '59.1', '0', '3.2', '0', '12.1', '151.9', '1009.7', '18', '24.1', '2', 'clear-day' ),( '10063', '2024-06-24', '09:00:00', '22.2', '12.3', '53.45', '0', '3.2', '0', '15.1', '166', '1010', '5', '24.1', '4', 'clear-day' ),( '10063', '2024-06-24', '10:00:00', '23.7', '11.9', '47.76', '0', '9.7', '0', '14.9', '170', '1009', '9.1', '24.1', '5', 'clear-day' ),( '10063', '2024-06-24', '11:00:00', '25.2', '11.7', '42.72', '0', '9.7', '0', '14.6', '174', '1008', '13.1', '24.1', '7', 'clear-day' ),( '10063', '2024-06-24', '12:00:00', '26.8', '11.4', '38.24', '0', '9.7', '0', '14.4', '178', '1007', '17.2', '24.1', '9', 'clear-day' ),( '10063', '2024-06-24', '13:00:00', '27.4', '11', '35.74', '0', '9.7', '0', '16', '168.8', '1006.3', '44.8', '24.1', '9', 'partly-cloudy-day' ),( '10063', '2024-06-24', '14:00:00', '28.2', '10.6', '33.41', '0', '9.7', '0', '17.5', '159.7', '1005.7', '72.4', '24.1', '9', 'partly-cloudy-day' ),( '10063', '2024-06-24', '15:00:00', '28.9', '10.2', '31.24', '0', '9.7', '0', '19.1', '150.5', '1005', '100', '24.1', '9', 'cloudy' ),( '10063', '2024-06-24', '16:00:00', '27.2', '12.3', '39.57', '0', '22.6', '0', '18.7', '153.8', '1005.7', '100', '24.1', '7', 'cloudy' ),( '10063', '2024-06-24', '17:00:00', '25.6', '14.4', '50.08', '0', '22.6', '0', '18.4', '157.2', '1006.3', '100', '24.1', '5', 'cloudy' ),( '10063', '2024-06-24', '18:00:00', '24', '16.6', '63.3', '0', '22.6', '0', '18', '160.5', '1007', '100', '24.1', '3', 'cloudy' ),( '10063', '2024-06-24', '19:00:00', '23.6', '16.4', '64.03', '0', '22.6', '0', '14.2', '160.1', '1007.7', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-24', '20:00:00', '23.3', '16.3', '64.78', '0', '22.6', '0', '10.3', '159.7', '1008.3', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-24', '21:00:00', '23', '16.2', '65.54', '0.1', '22.6', '0', '6.5', '159.3', '1009', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-24', '22:00:00', '22.5', '16', '66.7', '0', '16.1', '0', '7.6', '162.2', '1009', '90.1', '24.1', '0', 'cloudy' ),( '10063', '2024-06-24', '23:00:00', '22', '15.8', '67.89', '0', '16.1', '0', '8.6', '165', '1009', '80.2', '24.1', '0', 'partly-cloudy-night' ) ON DUPLICATE KEY UPDATE temp = VALUES(temp), dew = VALUES(dew), humidity = VALUES(humidity), precip = VALUES(precip), precipprob = VALUES(precipprob), snow = VALUES(snow), windspeed = VALUES(windspeed), winddir = VALUES(winddir), pressure = VALUES(pressure), cloudcover = VALUES(cloudcover), visibility = VALUES(visibility), uvindex = VALUES(uvindex), icon = VALUES(icon)

INSERT INTO w_hours_25 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '10063', '2024-06-25', '00:00:00', '21.5', '15.6', '69.11', '0.2', '16.1', '0', '9.7', '167.9', '1009', '70.3', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-25', '01:00:00', '20.6', '15.2', '71.34', '0', '16.1', '0', '10.3', '171.4', '1009.3', '76.7', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-25', '02:00:00', '19.7', '14.8', '73.66', '0', '16.1', '0', '10.9', '174.8', '1009.7', '83', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-25', '03:00:00', '18.8', '14.5', '76.09', '0.3', '16.1', '0', '11.5', '178.3', '1010', '89.4', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-25', '04:00:00', '18.6', '13.9', '74.43', '0', '0', '0', '10.9', '178.4', '1010.3', '84.4', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-25', '05:00:00', '18.4', '13.4', '72.8', '0', '0', '0', '10.3', '178.5', '1010.7', '79.5', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-25', '06:00:00', '18.2', '12.9', '71.2', '0', '0', '0', '9.7', '178.6', '1011', '74.5', '24.1', '0', 'partly-cloudy-day' ),( '10063', '2024-06-25', '07:00:00', '19.6', '12.6', '63.98', '0', '0', '0', '9.7', '182.2', '1011', '70.2', '24.1', '1', 'partly-cloudy-day' ),( '10063', '2024-06-25', '08:00:00', '21.1', '12.4', '57.56', '0', '0', '0', '9.7', '185.8', '1011', '65.9', '24.1', '2', 'partly-cloudy-day' ),( '10063', '2024-06-25', '09:00:00', '22.6', '12.2', '51.82', '0', '0', '0', '9.7', '189.4', '1011', '61.6', '24.1', '4', 'partly-cloudy-day' ),( '10063', '2024-06-25', '10:00:00', '24.2', '12', '46.46', '0', '9.7', '0', '13', '181.5', '1010', '43.6', '24.1', '5', 'partly-cloudy-day' ),( '10063', '2024-06-25', '11:00:00', '25.9', '11.9', '41.7', '0', '9.7', '0', '16.2', '173.5', '1009', '25.5', '24.1', '7', 'partly-cloudy-day' ),( '10063', '2024-06-25', '12:00:00', '27.6', '11.8', '37.47', '0', '9.7', '0', '19.4', '165.6', '1008', '7.5', '24.1', '9', 'clear-day' ),( '10063', '2024-06-25', '13:00:00', '27.6', '12.2', '38.48', '0', '9.7', '0', '18.4', '163.4', '1007.3', '24.8', '24.1', '9', 'partly-cloudy-day' ),( '10063', '2024-06-25', '14:00:00', '27.6', '12.6', '39.51', '0', '9.7', '0', '17.3', '161.2', '1006.7', '42.2', '24.1', '9', 'partly-cloudy-day' ),( '10063', '2024-06-25', '15:00:00', '27.7', '13.1', '40.57', '0', '9.7', '0', '16.2', '159', '1006', '59.5', '24.1', '9', 'partly-cloudy-day' ),( '10063', '2024-06-25', '16:00:00', '26.5', '13.5', '44.69', '0', '22.6', '0', '13', '187.3', '1006.7', '73', '24.1', '7', 'partly-cloudy-day' ),( '10063', '2024-06-25', '17:00:00', '25.3', '13.9', '49.25', '0', '22.6', '0', '9.7', '215.6', '1007.3', '86.5', '24.1', '5', 'partly-cloudy-day' ),( '10063', '2024-06-25', '18:00:00', '24.2', '14.4', '54.31', '1.3', '22.6', '0', '6.5', '243.9', '1008', '100', '24.1', '4', 'cloudy' ),( '10063', '2024-06-25', '19:00:00', '23.4', '13.7', '54.24', '0', '22.6', '0', '11.8', '262.7', '1008.7', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-25', '20:00:00', '22.7', '12.9', '54.18', '0', '22.6', '0', '17', '281.6', '1009.3', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-25', '21:00:00', '22', '12.3', '54.11', '0.4', '22.6', '0', '22.3', '300.4', '1010', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-25', '22:00:00', '22.2', '11.9', '51.96', '0', '6.5', '0', '20.9', '307.1', '1010', '98.8', '24.1', '0', 'cloudy' ),( '10063', '2024-06-25', '23:00:00', '22.4', '11.4', '49.89', '0', '6.5', '0', '19.4', '313.9', '1010', '97.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_26 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '10063', '2024-06-26', '00:00:00', '22.7', '11.1', '47.9', '0', '6.5', '0', '18', '320.6', '1010', '96.4', '24.1', '0', 'cloudy' ),( '10063', '2024-06-26', '01:00:00', '22.3', '11.4', '50.07', '0', '6.5', '0', '13.6', '281', '1009.3', '97.6', '24.1', '0', 'cloudy' ),( '10063', '2024-06-26', '02:00:00', '21.9', '11.7', '52.35', '0', '6.5', '0', '9.1', '241.5', '1008.7', '98.8', '24.1', '0', 'cloudy' ),( '10063', '2024-06-26', '03:00:00', '21.6', '12.1', '54.72', '0', '6.5', '0', '4.7', '201.9', '1008', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-26', '04:00:00', '21.6', '12.1', '54.84', '0', '3.2', '0', '4.9', '198.6', '1008.3', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-26', '05:00:00', '21.6', '12.1', '54.96', '0', '3.2', '0', '5.2', '195.3', '1008.7', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-26', '06:00:00', '21.6', '12.2', '55.08', '0', '3.2', '0', '5.4', '192', '1009', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-26', '07:00:00', '22.7', '12', '50.95', '0', '3.2', '0', '8.5', '194.4', '1009', '68.3', '24.1', '1', 'partly-cloudy-day' ),( '10063', '2024-06-26', '08:00:00', '23.8', '11.8', '47.15', '0', '3.2', '0', '11.6', '196.8', '1009', '36.7', '24.1', '2', 'partly-cloudy-day' ),( '10063', '2024-06-26', '09:00:00', '24.9', '11.7', '43.66', '0', '3.2', '0', '14.8', '199.2', '1009', '5', '24.1', '3', 'clear-day' ),( '10063', '2024-06-26', '10:00:00', '26.1', '11.3', '39.69', '0', '6.5', '0', '16.3', '195.3', '1008', '32.3', '24.1', '5', 'partly-cloudy-day' ),( '10063', '2024-06-26', '11:00:00', '27.3', '11', '36.1', '0', '6.5', '0', '17.9', '191.4', '1007', '59.5', '24.1', '7', 'partly-cloudy-day' ),( '10063', '2024-06-26', '12:00:00', '28.6', '10.7', '32.86', '0', '6.5', '0', '19.4', '187.5', '1006', '86.8', '24.1', '9', 'partly-cloudy-day' ),( '10063', '2024-06-26', '13:00:00', '28.7', '10.6', '32.4', '0', '6.5', '0', '19.9', '189.2', '1005.3', '67.4', '24.1', '8', 'partly-cloudy-day' ),( '10063', '2024-06-26', '14:00:00', '28.9', '10.5', '31.95', '0', '6.5', '0', '20.4', '190.8', '1004.7', '48', '24.1', '7', 'partly-cloudy-day' ),( '10063', '2024-06-26', '15:00:00', '29.1', '10.5', '31.5', '0', '6.5', '0', '20.9', '192.5', '1004', '28.6', '24.1', '6', 'partly-cloudy-day' ),( '10063', '2024-06-26', '16:00:00', '28.1', '11.4', '35.38', '0', '16.1', '0', '18', '205.6', '1004.7', '52.4', '24.1', '5', 'partly-cloudy-day' ),( '10063', '2024-06-26', '17:00:00', '27.2', '12.3', '39.74', '0', '16.1', '0', '15.1', '218.6', '1005.3', '76.2', '24.1', '4', 'partly-cloudy-day' ),( '10063', '2024-06-26', '18:00:00', '26.3', '13.3', '44.63', '0', '16.1', '0', '12.2', '231.7', '1006', '100', '24.1', '3', 'cloudy' ),( '10063', '2024-06-26', '19:00:00', '25.6', '12.3', '43.49', '0', '16.1', '0', '10.8', '221.4', '1006.3', '99.9', '24.1', '0', 'cloudy' ),( '10063', '2024-06-26', '20:00:00', '25', '11.3', '42.37', '0', '16.1', '0', '9.4', '211.1', '1006.7', '99.9', '24.1', '0', 'cloudy' ),( '10063', '2024-06-26', '21:00:00', '24.4', '10.4', '41.27', '0.6', '16.1', '0', '7.9', '200.8', '1007', '99.8', '24.1', '0', 'cloudy' ),( '10063', '2024-06-26', '22:00:00', '24.1', '11.2', '44.51', '0', '3.2', '0', '7.9', '211', '1006.7', '90.2', '24.1', '0', 'cloudy' ),( '10063', '2024-06-26', '23:00:00', '23.8', '12.1', '47.99', '0', '3.2', '0', '7.9', '221.3', '1006.3', '80.7', '24.1', '0', 'partly-cloudy-night' ) ON DUPLICATE KEY UPDATE temp = VALUES(temp), dew = VALUES(dew), humidity = VALUES(humidity), precip = VALUES(precip), precipprob = VALUES(precipprob), snow = VALUES(snow), windspeed = VALUES(windspeed), winddir = VALUES(winddir), pressure = VALUES(pressure), cloudcover = VALUES(cloudcover), visibility = VALUES(visibility), uvindex = VALUES(uvindex), icon = VALUES(icon)

INSERT INTO w_hours_27 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '10063', '2024-06-27', '00:00:00', '23.5', '13', '51.72', '0', '3.2', '0', '7.9', '231.5', '1006', '71.1', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-27', '01:00:00', '22.8', '13.4', '55.4', '0', '3.2', '0', '7.9', '230.2', '1005.7', '59', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-27', '02:00:00', '22.2', '13.9', '59.35', '0', '3.2', '0', '7.9', '228.9', '1005.3', '46.9', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-27', '03:00:00', '21.6', '14.4', '63.58', '0', '3.2', '0', '7.9', '227.6', '1005', '34.8', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-27', '04:00:00', '21.3', '14', '63.12', '0', '3.2', '0', '7.9', '230.5', '1005.3', '25.5', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-27', '05:00:00', '21.1', '13.7', '62.66', '0', '3.2', '0', '7.9', '233.5', '1005.7', '16.3', '24.1', '0', 'clear-night' ),( '10063', '2024-06-27', '06:00:00', '20.9', '13.4', '62.2', '0', '3.2', '0', '7.9', '236.4', '1006', '7', '24.1', '0', 'clear-day' ),( '10063', '2024-06-27', '07:00:00', '22.6', '12.4', '52.63', '0', '3.2', '0', '8.4', '231.2', '1005.7', '38', '24.1', '1', 'partly-cloudy-day' ),( '10063', '2024-06-27', '08:00:00', '24.3', '11.5', '44.58', '0', '3.2', '0', '8.9', '226', '1005.3', '69', '24.1', '2', 'partly-cloudy-day' ),( '10063', '2024-06-27', '09:00:00', '26.1', '10.6', '37.8', '0', '3.2', '0', '9.4', '220.8', '1005', '100', '24.1', '4', 'cloudy' ),( '10063', '2024-06-27', '10:00:00', '27.7', '8.9', '30.63', '0', '0', '0', '8.5', '177.1', '1004.3', '85.8', '24.1', '5', 'partly-cloudy-day' ),( '10063', '2024-06-27', '11:00:00', '29.3', '7.2', '24.82', '0', '0', '0', '7.7', '133.4', '1003.7', '71.7', '24.1', '7', 'partly-cloudy-day' ),( '10063', '2024-06-27', '12:00:00', '31', '5.5', '20.1', '0', '0', '0', '6.8', '89.7', '1003', '57.5', '24.1', '9', 'partly-cloudy-day' ),( '10063', '2024-06-27', '13:00:00', '31.6', '4.2', '17.78', '0', '0', '0', '11.2', '73.2', '1002', '62.5', '24.1', '9', 'partly-cloudy-day' ),( '10063', '2024-06-27', '14:00:00', '32.2', '2.9', '15.72', '0', '0', '0', '15.5', '56.8', '1001', '67.6', '24.1', '9', 'partly-cloudy-day' ),( '10063', '2024-06-27', '15:00:00', '32.8', '1.7', '13.89', '0', '0', '0', '19.8', '40.3', '1000', '72.6', '24.1', '9', 'partly-cloudy-day' ),( '10063', '2024-06-27', '16:00:00', '31.2', '4.8', '18.89', '0', '12.9', '0', '17.3', '68.2', '1001', '81.7', '24.1', '7', 'partly-cloudy-day' ),( '10063', '2024-06-27', '17:00:00', '29.6', '7.9', '25.59', '0', '12.9', '0', '14.8', '96.1', '1002', '90.9', '24.1', '5', 'cloudy' ),( '10063', '2024-06-27', '18:00:00', '28.1', '11', '34.51', '0', '12.9', '0', '12.2', '124', '1003', '100', '24.1', '3', 'cloudy' ),( '10063', '2024-06-27', '19:00:00', '26.8', '12.8', '41.77', '0', '12.9', '0', '10.2', '150.4', '1003.7', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-27', '20:00:00', '25.6', '14.6', '50.51', '0', '12.9', '0', '8.2', '176.8', '1004.3', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-27', '21:00:00', '24.4', '16.4', '61.01', '0', '12.9', '0', '6.1', '203.2', '1005', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-27', '22:00:00', '24.8', '15', '54.25', '0', '3.2', '0', '4.7', '232.3', '1004.7', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-27', '23:00:00', '25.3', '13.6', '48.19', '0', '3.2', '0', '3.2', '261.5', '1004.3', '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_28 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '10063', '2024-06-28', '00:00:00', '25.8', '12.2', '42.77', '0', '3.2', '0', '1.8', '290.6', '1004', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-28', '01:00:00', '24.9', '12.6', '46.23', '0', '3.2', '0', '2.5', '238.6', '1003.7', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-28', '02:00:00', '24', '13', '49.99', '0', '3.2', '0', '3.2', '186.6', '1003.3', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-28', '03:00:00', '23.2', '13.4', '54.06', '0', '3.2', '0', '4', '134.6', '1003', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-28', '04:00:00', '22.8', '13.7', '56.49', '0', '3.2', '0', '5.5', '173.3', '1003.7', '91.4', '24.1', '0', 'cloudy' ),( '10063', '2024-06-28', '05:00:00', '22.5', '14.1', '59.04', '0', '3.2', '0', '7.1', '212.1', '1004.3', '82.8', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-28', '06:00:00', '22.2', '14.5', '61.69', '0', '3.2', '0', '8.6', '250.8', '1005', '74.2', '24.1', '0', 'partly-cloudy-day' ),( '10063', '2024-06-28', '07:00:00', '22.8', '13.8', '57.09', '0', '3.2', '0', '8.3', '221.4', '1005.3', '69.1', '24.1', '1', 'partly-cloudy-day' ),( '10063', '2024-06-28', '08:00:00', '23.4', '13.2', '52.83', '0', '3.2', '0', '7.9', '191.9', '1005.7', '64', '24.1', '2', 'partly-cloudy-day' ),( '10063', '2024-06-28', '09:00:00', '24', '12.6', '48.89', '0', '3.2', '0', '7.6', '162.5', '1006', '58.9', '24.1', '4', 'partly-cloudy-day' ),( '10063', '2024-06-28', '10:00:00', '26.6', '7.8', '30.53', '0', '6.5', '0', '11.3', '118', '1005', '72.6', '24.1', '5', 'partly-cloudy-day' ),( '10063', '2024-06-28', '11:00:00', '29.2', '3.1', '18.89', '0', '6.5', '0', '15', '73.6', '1004', '86.3', '24.1', '7', 'partly-cloudy-day' ),( '10063', '2024-06-28', '12:00:00', '31.8', '-1.6', '11.57', '0', '6.5', '0', '18.7', '29.1', '1003', '100', '24.1', '8', 'cloudy' ),( '10063', '2024-06-28', '13:00:00', '32.1', '-1.2', '11.77', '0', '6.5', '0', '16.8', '36.4', '1002', '81.7', '24.1', '8', 'partly-cloudy-day' ),( '10063', '2024-06-28', '14:00:00', '32.4', '-0.7', '11.97', '0', '6.5', '0', '14.9', '43.7', '1001', '63.3', '24.1', '8', 'partly-cloudy-day' ),( '10063', '2024-06-28', '15:00:00', '32.7', '-0.2', '12.18', '0', '6.5', '0', '13', '51', '1000', '45', '24.1', '8', 'partly-cloudy-day' ),( '10063', '2024-06-28', '16:00:00', '30.9', '4', '18.22', '0', '12.9', '0', '13.4', '79.1', '1001', '63.3', '24.1', '7', 'partly-cloudy-day' ),( '10063', '2024-06-28', '17:00:00', '29.1', '8.2', '27', '0', '12.9', '0', '13.9', '107.1', '1002', '81.7', '24.1', '5', 'partly-cloudy-day' ),( '10063', '2024-06-28', '18:00:00', '27.4', '12.5', '39.7', '0', '12.9', '0', '14.4', '135.2', '1003', '100', '24.1', '4', 'cloudy' ),( '10063', '2024-06-28', '19:00:00', '26.2', '13.8', '46.29', '0', '12.9', '0', '12.6', '166.2', '1003.7', '87.2', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-28', '20:00:00', '25.1', '15.1', '53.97', '0', '12.9', '0', '10.8', '197.2', '1004.3', '74.4', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-28', '21:00:00', '24', '16.5', '62.89', '0', '12.9', '0', '9', '228.2', '1005', '61.6', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-28', '22:00:00', '24.1', '16.1', '60.82', '0', '9.7', '0', '7.8', '213.1', '1005', '74.4', '24.1', '0', 'partly-cloudy-night' ),( '10063', '2024-06-28', '23:00:00', '24.2', '15.7', '58.81', '0', '9.7', '0', '6.6', '198.1', '1005', '87.1', '24.1', '0', 'partly-cloudy-night' ) ON DUPLICATE KEY UPDATE temp = VALUES(temp), dew = VALUES(dew), humidity = VALUES(humidity), precip = VALUES(precip), precipprob = VALUES(precipprob), snow = VALUES(snow), windspeed = VALUES(windspeed), winddir = VALUES(winddir), pressure = VALUES(pressure), cloudcover = VALUES(cloudcover), visibility = VALUES(visibility), uvindex = VALUES(uvindex), icon = VALUES(icon)

INSERT INTO w_hours_29 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '10063', '2024-06-29', '00:00:00', '24.4', '15.3', '56.87', '0', '9.7', '0', '5.4', '183', '1005', '99.9', '24.1', '0', 'cloudy' ),( '10063', '2024-06-29', '01:00:00', '24.4', '14.6', '54.49', '0', '9.7', '0', '6.7', '212.1', '1004.7', '99.9', '24.1', '0', 'cloudy' ),( '10063', '2024-06-29', '02:00:00', '24.4', '14', '52.2', '0', '9.7', '0', '8', '241.2', '1004.3', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-29', '03:00:00', '24.5', '13.4', '49.99', '0', '9.7', '0', '9.4', '270.3', '1004', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-29', '04:00:00', '24.5', '12.5', '47.15', '0', '3.2', '0', '9.6', '266.9', '1004.3', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-29', '05:00:00', '24.6', '11.7', '44.46', '0', '3.2', '0', '9.8', '263.5', '1004.7', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-29', '06:00:00', '24.7', '10.9', '41.9', '0', '3.2', '0', '10.1', '260.1', '1005', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-29', '07:00:00', '25.2', '11.5', '42.24', '0', '3.2', '0', '9.2', '242.2', '1005', '100', '24.1', '1', 'cloudy' ),( '10063', '2024-06-29', '08:00:00', '25.7', '12.1', '42.57', '0', '3.2', '0', '8.4', '224.2', '1005', '100', '24.1', '2', 'cloudy' ),( '10063', '2024-06-29', '09:00:00', '26.3', '12.7', '42.91', '0', '3.2', '0', '7.6', '206.3', '1005', '100', '24.1', '3', 'cloudy' ),( '10063', '2024-06-29', '10:00:00', '28.3', '9.9', '31.7', '0', '12.9', '0', '7.9', '158', '1004.3', '99.9', '24.1', '5', 'cloudy' ),( '10063', '2024-06-29', '11:00:00', '30.3', '7.1', '23.36', '0', '12.9', '0', '8.3', '109.7', '1003.7', '99.8', '24.1', '6', 'cloudy' ),( '10063', '2024-06-29', '12:00:00', '32.3', '4.3', '17.17', '0', '12.9', '0', '8.6', '61.4', '1003', '99.7', '24.1', '8', 'cloudy' ),( '10063', '2024-06-29', '13:00:00', '32.6', '2.9', '15.28', '0', '12.9', '0', '11', '57.9', '1002.3', '99.8', '24.1', '8', 'cloudy' ),( '10063', '2024-06-29', '14:00:00', '33', '1.5', '13.58', '0', '12.9', '0', '13.4', '54.5', '1001.7', '99.9', '24.1', '8', 'cloudy' ),( '10063', '2024-06-29', '15:00:00', '33.4', '0.2', '12.05', '0', '12.9', '0', '15.8', '51', '1001', '100', '24.1', '8', 'cloudy' ),( '10063', '2024-06-29', '16:00:00', '32.4', '2.5', '15.05', '0', '22.6', '0', '13.2', '69.8', '1001.3', '96.7', '24.1', '6', 'cloudy' ),( '10063', '2024-06-29', '17:00:00', '31.4', '4.8', '18.73', '0', '22.6', '0', '10.6', '88.7', '1001.7', '93.4', '24.1', '5', 'cloudy' ),( '10063', '2024-06-29', '18:00:00', '30.5', '7.2', '23.25', '0', '22.6', '0', '7.9', '107.5', '1002', '90.1', '24.1', '3', 'cloudy' ),( '10063', '2024-06-29', '19:00:00', '29', '9.9', '30.38', '0', '22.6', '0', '7', '135.6', '1003', '93.4', '24.1', '0', 'cloudy' ),( '10063', '2024-06-29', '20:00:00', '27.5', '12.6', '39.57', '0', '22.6', '0', '6', '163.7', '1004', '96.7', '24.1', '0', 'cloudy' ),( '10063', '2024-06-29', '21:00:00', '26.1', '15.3', '51.4', '0', '22.6', '0', '5', '191.8', '1005', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-29', '22:00:00', '26.4', '13.9', '46.33', '0', '0', '0', '5.2', '232.8', '1004.7', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-29', '23:00:00', '26.7', '12.6', '41.73', '0', '0', '0', '5.3', '273.7', '1004.3', '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_30 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '10063', '2024-06-30', '00:00:00', '27', '11.3', '37.55', '0', '0', '0', '5.4', '314.7', '1004', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-30', '01:00:00', '26.3', '10', '35.89', '0', '0', '0', '4.9', '270.5', '1003.7', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-30', '02:00:00', '25.6', '8.7', '34.29', '0', '0', '0', '4.4', '226.4', '1003.3', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-30', '03:00:00', '25', '7.5', '32.74', '0', '0', '0', '4', '182.2', '1003', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-30', '04:00:00', '24.8', '6.9', '31.74', '0', '0', '0', '6', '213.1', '1003.7', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-30', '05:00:00', '24.7', '6.3', '30.77', '0', '0', '0', '8', '243.9', '1004.3', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-30', '06:00:00', '24.6', '5.8', '29.83', '0', '0', '0', '10.1', '274.8', '1005', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-30', '07:00:00', '25.9', '3.9', '24.24', '0', '0', '0', '12', '184.5', '1005', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-30', '08:00:00', '27.2', '2', '19.67', '0', '0', '0', '13.9', '94.1', '1005', '100', '24.1', '1', 'cloudy' ),( '10063', '2024-06-30', '09:00:00', '28.5', '0.2', '15.94', '0', '0', '0', '15.8', '3.8', '1005', '100', '24.1', '1', 'cloudy' ),( '10063', '2024-06-30', '10:00:00', '29.9', '-0.3', '14.25', '0', '3.2', '0', '22.3', '4.5', '1004.3', '100', '24.1', '3', 'cloudy' ),( '10063', '2024-06-30', '11:00:00', '31.3', '-0.7', '12.74', '0', '3.2', '0', '28.8', '5.1', '1003.7', '100', '24.1', '5', 'cloudy' ),( '10063', '2024-06-30', '12:00:00', '32.7', '-1.1', '11.4', '0', '3.2', '0', '35.3', '5.8', '1003', '100', '24.1', '7', 'cloudy' ),( '10063', '2024-06-30', '13:00:00', '32.8', '-1.8', '10.73', '0', '3.2', '0', '37.2', '9.8', '1002.3', '99.6', '24.1', '7', 'cloudy' ),( '10063', '2024-06-30', '14:00:00', '33', '-2.6', '10.1', '0', '3.2', '0', '39.1', '13.7', '1001.7', '99.3', '24.1', '7', 'cloudy' ),( '10063', '2024-06-30', '15:00:00', '33.2', '-3.2', '9.5', '0', '3.2', '0', '41', '17.7', '1001', '98.9', '24.1', '8', 'cloudy' ),( '10063', '2024-06-30', '16:00:00', '32.5', '-2.9', '10.09', '0', '29', '0', '32.4', '24.2', '1001.3', '99.3', '24.1', '6', 'cloudy' ),( '10063', '2024-06-30', '17:00:00', '31.9', '-2.6', '10.72', '0', '29', '0', '23.8', '30.7', '1001.7', '99.6', '24.1', '4', 'cloudy' ),( '10063', '2024-06-30', '18:00:00', '31.3', '-2.2', '11.39', '0', '29', '0', '15.1', '37.2', '1002', '100', '24.1', '3', 'cloudy' ),( '10063', '2024-06-30', '19:00:00', '30.4', '-0.7', '13.37', '0', '29', '0', '13.3', '37.4', '1003', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-30', '20:00:00', '29.7', '0.9', '15.68', '0', '29', '0', '11.5', '37.7', '1004', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-30', '21:00:00', '28.9', '2.5', '18.37', '0', '29', '0', '9.7', '37.9', '1005', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-30', '22:00:00', '27.9', '4.9', '23.16', '0', '6.5', '0', '8.3', '76.5', '1005', '100', '24.1', '0', 'cloudy' ),( '10063', '2024-06-30', '23:00:00', '26.9', '7.4', '29.12', '0', '6.5', '0', '6.8', '115.1', '1005', '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)

200

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 ( '10190', '2024-06-16', '00:00:00', '24', '4.2', '27.66', '0', '0', '0', '16.6', '193.1', '1010', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-16', '01:00:00', '23.5', '4.3', '28.71', '0', '0', '0', '9.7', '217.6', '1010', '98.5', '24.1', '0', 'cloudy' ),( '10190', '2024-06-16', '02:00:00', '23.1', '5.3', '31.53', '0', '0', '0', '9', '237.3', '1010', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-16', '03:00:00', '22.6', '5.8', '33.65', '0', '0', '0', '8.6', '256.8', '1010', '73', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-16', '04:00:00', '21.3', '6.4', '37.97', '0', '0', '0', '7.2', '181.9', '1011', '81.3', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-16', '05:00:00', '21.1', '7.1', '40.33', '0', '0', '0', '7.9', '176.5', '1011', '56.5', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-16', '06:00:00', '20.6', '10', '50.62', '0', '0', '0', '14.8', '171.5', '1012', '5.1', '24.1', '0', 'clear-day' ),( '10190', '2024-06-16', '07:00:00', '21.2', '10', '48.78', '0', '0', '0', '14', '177.1', '1013', '5', '24.1', '1', 'clear-day' ),( '10190', '2024-06-16', '08:00:00', '23', '8.7', '40.05', '0', '0', '0', '6.1', '215.5', '1012', '1.2', '24.1', '4', 'clear-day' ),( '10190', '2024-06-16', '09:00:00', '25.2', '7.6', '32.57', '0', '0', '0', '10.1', '218.2', '1012', '0', '24.1', '6', 'clear-day' ),( '10190', '2024-06-16', '10:00:00', '26.9', '7', '28.27', '0', '0', '0', '10.4', '203.6', '1011', '0', '24.1', '8', 'clear-day' ),( '10190', '2024-06-16', '11:00:00', '28.4', '5.5', '23.35', '0', '0', '0', '11.2', '188.6', '1010', '56.1', '24.1', '9', 'partly-cloudy-day' ),( '10190', '2024-06-16', '12:00:00', '29.5', '4.3', '20.15', '0', '0', '0', '9.4', '179', '1008', '97.6', '24.1', '9', 'cloudy' ),( '10190', '2024-06-16', '13:00:00', '29.8', '5.1', '20.94', '0', '0', '0', '17.3', '176.5', '1007', '98.9', '24.1', '6', 'cloudy' ),( '10190', '2024-06-16', '14:00:00', '27.8', '8.9', '30.52', '0', '0', '0', '32.4', '180.4', '1007', '98.9', '24.1', '4', 'cloudy' ),( '10190', '2024-06-16', '15:00:00', '28.1', '9.2', '30.6', '0', '0', '0', '21.6', '176.8', '1007', '70.5', '24.1', '6', 'partly-cloudy-day' ),( '10190', '2024-06-16', '16:00:00', '28.3', '9', '29.84', '0', '0', '0', '24.5', '167.1', '1007', '100', '24.1', '5', 'cloudy' ),( '10190', '2024-06-16', '17:00:00', '25.7', '11.6', '41.36', '0', '0', '0', '22.7', '170.1', '1008', '100', '24.1', '3', 'cloudy' ),( '10190', '2024-06-16', '18:00:00', '25.2', '11.7', '42.89', '0', '0', '0', '18.7', '175.4', '1009', '100', '24.1', '1', 'cloudy' ),( '10190', '2024-06-16', '19:00:00', '24.8', '11.7', '43.92', '0', '0', '0', '16.6', '172', '1010', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-16', '20:00:00', '24.7', '11', '42.18', '0', '0', '0', '15.1', '183.7', '1010', '97.6', '24.1', '0', 'cloudy' ),( '10190', '2024-06-16', '21:00:00', '24.3', '11.5', '44.66', '0', '0', '0', '15.5', '192.2', '1011', '26.1', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-16', '22:00:00', '23.6', '12.2', '48.78', '0', '0', '0', '10.4', '208.1', '1011', '99.4', '24.1', '0', 'cloudy' ),( '10190', '2024-06-16', '23:00:00', '23', '12.4', '51.25', '0', '0', '0', '8.3', '234.6', '1011', '99.9', '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_17 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '10190', '2024-06-17', '00:00:00', '22.5', '12.1', '51.8', '0', '0', '0', '8.3', '255.8', '1011', '28.4', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-17', '01:00:00', '22.2', '11.4', '50.37', '0', '0', '0', '7.9', '273.8', '1010', '22.5', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-17', '02:00:00', '22.1', '10.3', '47.1', '0', '0', '0', '7.9', '288.6', '1009', '49.4', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-17', '03:00:00', '21.9', '9.3', '44.59', '0', '0', '0', '9', '289.9', '1009', '84.2', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-17', '04:00:00', '21.5', '8.1', '42.13', '0', '0', '0', '7.6', '281.1', '1010', '97.7', '24.1', '0', 'cloudy' ),( '10190', '2024-06-17', '05:00:00', '20.7', '7.4', '42.19', '0', '0', '0', '4.3', '240.5', '1010', '7.1', '24.1', '0', 'clear-night' ),( '10190', '2024-06-17', '06:00:00', '21.2', '8', '42.63', '0', '0', '0', '10.1', '171.6', '1011', '68.6', '24.1', '0', 'partly-cloudy-day' ),( '10190', '2024-06-17', '07:00:00', '20.7', '12.2', '58.21', '0', '0', '0', '15.1', '160.2', '1012', '33.8', '24.1', '1', 'partly-cloudy-day' ),( '10190', '2024-06-17', '08:00:00', '21.8', '12.3', '54.77', '0', '0', '0', '17.3', '172.3', '1013', '88', '24.1', '4', 'partly-cloudy-day' ),( '10190', '2024-06-17', '09:00:00', '23.3', '11.3', '46.81', '0', '0', '0', '14.8', '184.2', '1012', '5.8', '24.1', '6', 'clear-day' ),( '10190', '2024-06-17', '10:00:00', '25.4', '10.4', '38.88', '0', '0', '0', '9', '207.4', '1011', '5', '24.1', '8', 'clear-day' ),( '10190', '2024-06-17', '11:00:00', '28.1', '7.3', '26.9', '0', '0', '0', '14', '162.1', '1010', '35.2', '24.1', '9', 'partly-cloudy-day' ),( '10190', '2024-06-17', '12:00:00', '29.6', '6.6', '23.5', '0', '0', '0', '18', '153.6', '1008', '55.1', '24.1', '10', 'partly-cloudy-day' ),( '10190', '2024-06-17', '13:00:00', '30.2', '5.6', '21.19', '0', '0', '0', '16.2', '152.4', '1007', '63.8', '24.1', '10', 'partly-cloudy-day' ),( '10190', '2024-06-17', '14:00:00', '30.6', '5', '19.86', '0', '0', '0', '16.2', '143.8', '1006', '70.5', '24.1', '9', 'partly-cloudy-day' ),( '10190', '2024-06-17', '15:00:00', '29.9', '7.5', '24.57', '0', '0', '0', '23.4', '149.3', '1006', '6.2', '24.1', '8', 'clear-day' ),( '10190', '2024-06-17', '16:00:00', '27.9', '9.8', '32.23', '0', '0', '0', '24.1', '157.7', '1007', '8.5', '24.1', '6', 'clear-day' ),( '10190', '2024-06-17', '17:00:00', '25.4', '11.6', '42.1', '0', '0', '0', '25.9', '176.9', '1008', '99.9', '24.1', '4', 'cloudy' ),( '10190', '2024-06-17', '18:00:00', '22.8', '11.7', '49.54', '0', '0', '0', '18.4', '168.8', '1010', '100', '24.1', '1', 'cloudy' ),( '10190', '2024-06-17', '19:00:00', '23.8', '10.7', '43.64', '0', '0', '0', '19.8', '167.2', '1010', '99.9', '24.1', '0', 'cloudy' ),( '10190', '2024-06-17', '20:00:00', '22.9', '10.7', '46.08', '0', '0', '0', '16.9', '178.2', '1011', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-17', '21:00:00', '22.9', '10.5', '45.47', '0', '0', '0', '16.2', '183.6', '1011', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-17', '22:00:00', '22.7', '11', '47.58', '0', '0', '0', '10.4', '194.4', '1011', '99', '24.1', '0', 'cloudy' ),( '10190', '2024-06-17', '23:00:00', '22.7', '10.6', '46.33', '0', '0', '0', '7.6', '213', '1010', '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_18 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '10190', '2024-06-18', '00:00:00', '22.6', '10.2', '45.39', '0', '0', '0', '9.7', '232.9', '1010', '98.1', '24.1', '0', 'cloudy' ),( '10190', '2024-06-18', '01:00:00', '22.3', '10.1', '45.92', '0', '0', '0', '8.6', '253.1', '1009', '89', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-18', '02:00:00', '22', '10', '46.45', '0', '0', '0', '8.3', '242.2', '1009', '95', '24.1', '0', 'cloudy' ),( '10190', '2024-06-18', '03:00:00', '21.5', '9.8', '47.26', '0', '0', '0', '8.3', '172.3', '1009', '87.4', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-18', '04:00:00', '20', '9.8', '51.83', '0', '0', '0', '17.6', '162.8', '1010', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-18', '05:00:00', '18', '10.7', '62.36', '0', '0', '0', '16.6', '163.6', '1012', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-18', '06:00:00', '18', '10', '59.51', '0', '0', '0', '15.5', '174.8', '1012', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-18', '07:00:00', '19.9', '8.8', '48.76', '0', '0', '0', '13.7', '181.4', '1012', '49.3', '24.1', '1', 'partly-cloudy-day' ),( '10190', '2024-06-18', '08:00:00', '21.9', '8.5', '42.25', '0', '0', '0', '14.4', '187.1', '1012', '5.5', '24.1', '4', 'clear-day' ),( '10190', '2024-06-18', '09:00:00', '23.6', '8.3', '37.59', '0', '0', '0', '13.7', '194', '1012', '14.9', '24.1', '6', 'clear-day' ),( '10190', '2024-06-18', '10:00:00', '25.5', '8', '32.88', '0', '3.2', '0', '14.8', '180.8', '1011', '41', '24.1', '8', 'partly-cloudy-day' ),( '10190', '2024-06-18', '11:00:00', '26.9', '7.8', '29.86', '0', '3.2', '0', '20.5', '170.1', '1010', '51.7', '24.1', '9', 'partly-cloudy-day' ),( '10190', '2024-06-18', '12:00:00', '27.4', '8.2', '29.79', '0', '3.2', '0', '28.1', '166.4', '1009', '84', '24.1', '10', 'partly-cloudy-day' ),( '10190', '2024-06-18', '13:00:00', '26.9', '9.5', '33.5', '0', '3.2', '0', '29.2', '171.2', '1009', '99.8', '24.1', '10', 'cloudy' ),( '10190', '2024-06-18', '14:00:00', '27.2', '10.6', '35.42', '0', '3.2', '0', '25.9', '171.3', '1008', '100', '24.1', '9', 'cloudy' ),( '10190', '2024-06-18', '15:00:00', '26.6', '12', '40.26', '0', '3.2', '0', '25.6', '172.1', '1008', '99.4', '24.1', '7', 'cloudy' ),( '10190', '2024-06-18', '16:00:00', '25.2', '12.6', '45.5', '0', '3.2', '0', '24.5', '176.3', '1008', '88.9', '24.1', '5', 'partly-cloudy-day' ),( '10190', '2024-06-18', '17:00:00', '24.8', '12.3', '45.69', '0', '3.2', '0', '23.8', '166.2', '1008', '100', '24.1', '4', 'cloudy' ),( '10190', '2024-06-18', '18:00:00', '23.7', '12', '47.86', '0', '3.2', '0', '22.7', '167.7', '1009', '100', '24.1', '1', 'cloudy' ),( '10190', '2024-06-18', '19:00:00', '22', '12', '53.05', '0', '3.2', '0', '18', '171.8', '1010', '93.9', '24.1', '0', 'cloudy' ),( '10190', '2024-06-18', '20:00:00', '21.4', '12', '55.03', '0', '3.2', '0', '12.6', '192.6', '1011', '78.1', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-18', '21:00:00', '21.8', '11.9', '53.35', '0', '3.2', '0', '10.4', '196', '1011', '99.4', '24.1', '0', 'cloudy' ),( '10190', '2024-06-18', '22:00:00', '21.9', '11.6', '51.98', '0', '0', '0', '6.5', '197.3', '1012', '95.2', '24.1', '0', 'cloudy' ),( '10190', '2024-06-18', '23:00:00', '21.9', '11', '49.96', '0', '0', '0', '7.2', '225.3', '1012', '97.8', '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_19 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '10190', '2024-06-19', '00:00:00', '22', '10', '46.45', '0', '0', '0', '7.2', '229.2', '1010', '92.2', '24.1', '0', 'cloudy' ),( '10190', '2024-06-19', '01:00:00', '21.8', '8.8', '43.38', '0', '0', '0', '6.5', '238.2', '1010', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-19', '02:00:00', '21.6', '8.3', '42.45', '0', '0', '0', '7.9', '184.5', '1009', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-19', '03:00:00', '20.1', '9.6', '50.82', '0', '0', '0', '19.1', '168.4', '1010', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-19', '04:00:00', '18.5', '11.8', '65', '0', '0', '0', '14.8', '167.2', '1011', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-19', '05:00:00', '18.1', '11.3', '64.49', '0', '0', '0', '12.6', '168.4', '1012', '19.2', '24.1', '0', 'clear-night' ),( '10190', '2024-06-19', '06:00:00', '18.2', '10.5', '60.76', '0', '0', '0', '10.1', '178.3', '1012', '1.1', '24.1', '0', 'clear-day' ),( '10190', '2024-06-19', '07:00:00', '20.2', '9.8', '51.19', '0', '0', '0', '8.6', '206.7', '1012', '5', '24.1', '1', 'clear-day' ),( '10190', '2024-06-19', '08:00:00', '22.6', '9.5', '43.31', '0', '0', '0', '11.2', '198.3', '1011', '5.3', '24.1', '4', 'clear-day' ),( '10190', '2024-06-19', '09:00:00', '24.3', '9.2', '38.31', '0', '0', '0', '13.3', '193.3', '1011', '3.6', '24.1', '6', 'clear-day' ),( '10190', '2024-06-19', '10:00:00', '26', '8.7', '33.47', '0', '0', '0', '14', '189.4', '1010', '0', '24.1', '8', 'clear-day' ),( '10190', '2024-06-19', '11:00:00', '28.1', '6.7', '25.81', '0', '0', '0', '18', '181.8', '1009', '62.6', '24.1', '9', 'partly-cloudy-day' ),( '10190', '2024-06-19', '12:00:00', '29.2', '6.4', '23.72', '0', '0', '0', '21.6', '177.3', '1008', '63.6', '24.1', '10', 'partly-cloudy-day' ),( '10190', '2024-06-19', '13:00:00', '29.4', '8.2', '26.52', '0', '0', '0', '27', '171.3', '1007', '75.5', '24.1', '10', 'partly-cloudy-day' ),( '10190', '2024-06-19', '14:00:00', '28', '10.5', '33.58', '0', '0', '0', '28.1', '167.2', '1007', '25.1', '24.1', '9', 'partly-cloudy-day' ),( '10190', '2024-06-19', '15:00:00', '27.6', '11.2', '36.01', '0', '0', '0', '25.6', '177.7', '1006', '94.3', '24.1', '8', 'cloudy' ),( '10190', '2024-06-19', '16:00:00', '27.6', '11.2', '36.01', '0', '3.2', '0', '24.8', '178.5', '1006', '88.4', '24.1', '6', 'partly-cloudy-day' ),( '10190', '2024-06-19', '17:00:00', '26.2', '12', '41.22', '0', '3.2', '0', '22.3', '171.6', '1007', '100', '24.1', '4', 'cloudy' ),( '10190', '2024-06-19', '18:00:00', '25.5', '11.9', '42.69', '0', '3.2', '0', '19.1', '183.8', '1007', '98.9', '24.1', '1', 'cloudy' ),( '10190', '2024-06-19', '19:00:00', '25.1', '11.8', '43.43', '0', '3.2', '0', '14.8', '188.5', '1008', '98.9', '24.1', '0', 'cloudy' ),( '10190', '2024-06-19', '20:00:00', '24.7', '12', '45.07', '0', '3.2', '0', '13.7', '185.7', '1009', '97.9', '24.1', '0', 'cloudy' ),( '10190', '2024-06-19', '21:00:00', '23.7', '13.1', '51.44', '0', '3.2', '0', '12.6', '177.8', '1010', '99.8', '24.1', '0', 'cloudy' ),( '10190', '2024-06-19', '22:00:00', '23.1', '13.6', '55.1', '0', '0', '0', '9.4', '193.6', '1010', '99.7', '24.1', '0', 'cloudy' ),( '10190', '2024-06-19', '23:00:00', '22.8', '13.4', '55.38', '0', '0', '0', '6.1', '205.5', '1010', '97.9', '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 ( '10190', '2024-06-20', '00:00:00', '22.7', '12.3', '51.85', '0', '0', '0', '5.8', '269.4', '1010', '14.2', '24.1', '0', 'clear-night' ),( '10190', '2024-06-20', '01:00:00', '22.5', '10.6', '46.9', '0', '0', '0', '6.5', '295', '1009', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-20', '02:00:00', '22.5', '9.3', '42.99', '0', '0', '0', '7.6', '280.2', '1009', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-20', '03:00:00', '22.1', '8.3', '41.17', '0', '0', '0', '6.1', '285.9', '1008', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-20', '04:00:00', '21.8', '8.6', '42.79', '0', '0', '0', '11.2', '176.3', '1009', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-20', '05:00:00', '19.5', '12.9', '65.65', '0', '0', '0', '12.2', '161.4', '1010', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-20', '06:00:00', '19', '13.9', '72.28', '0', '0', '0', '10.1', '156.1', '1011', '5', '24.1', '0', 'clear-day' ),( '10190', '2024-06-20', '07:00:00', '20.3', '13.4', '64.54', '0', '0', '0', '10.4', '171.5', '1011', '5', '24.1', '1', 'clear-day' ),( '10190', '2024-06-20', '08:00:00', '22.1', '13.2', '57.04', '0', '0', '0', '17.3', '174', '1011', '5', '24.1', '4', 'clear-day' ),( '10190', '2024-06-20', '09:00:00', '23.6', '12.3', '49.1', '0', '0', '0', '18', '178.1', '1011', '6', '24.1', '6', 'clear-day' ),( '10190', '2024-06-20', '10:00:00', '25.2', '11.1', '41.22', '0', '3.2', '0', '16.9', '181.1', '1010', '73.5', '24.1', '8', 'partly-cloudy-day' ),( '10190', '2024-06-20', '11:00:00', '26.7', '10.2', '35.52', '0', '3.2', '0', '18.7', '166', '1010', '100', '24.1', '9', 'cloudy' ),( '10190', '2024-06-20', '12:00:00', '27.8', '9.5', '31.77', '0', '3.2', '0', '23.8', '161.8', '1009', '100', '24.1', '9', 'cloudy' ),( '10190', '2024-06-20', '13:00:00', '27.9', '8.9', '30.34', '0', '3.2', '0', '22.3', '159.4', '1008', '100', '24.1', '9', 'cloudy' ),( '10190', '2024-06-20', '14:00:00', '27.8', '8.9', '30.52', '0', '3.2', '0', '16.6', '198', '1008', '100', '24.1', '6', 'cloudy' ),( '10190', '2024-06-20', '15:00:00', '27.3', '8.9', '31.42', '0', '3.2', '0', '12.2', '190.8', '1007', '99.7', '24.1', '3', 'cloudy' ),( '10190', '2024-06-20', '16:00:00', '27.1', '9.2', '32.32', '0', '12.9', '0', '13.7', '181.5', '1007.3', '98.9', '24.1', '2', 'cloudy' ),( '10190', '2024-06-20', '17:00:00', '27', '9.4', '33.23', '0', '12.9', '0', '15.1', '172.2', '1007.7', '98.2', '24.1', '2', 'cloudy' ),( '10190', '2024-06-20', '18:00:00', '26.9', '9.8', '34.18', '0.1', '12.9', '0', '16.6', '162.9', '1008', '97.4', '24.1', '2', 'cloudy' ),( '10190', '2024-06-20', '19:00:00', '26.4', '9.6', '34.82', '0', '12.9', '0', '14.6', '203.3', '1008.3', '98.1', '24.1', '0', 'cloudy' ),( '10190', '2024-06-20', '20:00:00', '25.9', '9.5', '35.47', '0', '12.9', '0', '12.7', '243.7', '1008.7', '98.7', '24.1', '0', 'cloudy' ),( '10190', '2024-06-20', '21:00:00', '25.5', '9.4', '36.14', '0.1', '12.9', '0', '10.8', '284.1', '1009', '99.4', '24.1', '0', 'cloudy' ),( '10190', '2024-06-20', '22:00:00', '25', '9.5', '37.48', '0', '9.7', '0', '10.1', '254', '1009.3', '99.6', '24.1', '0', 'cloudy' ),( '10190', '2024-06-20', '23:00:00', '24.5', '9.6', '38.88', '0', '9.7', '0', '9.4', '224', '1009.7', '99.7', '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_21 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '10190', '2024-06-21', '00:00:00', '24', '9.7', '40.34', '0', '9.7', '0', '8.6', '193.9', '1010', '99.9', '24.1', '0', 'cloudy' ),( '10190', '2024-06-21', '01:00:00', '23.9', '9', '38.63', '0', '9.7', '0', '10.2', '155.1', '1009.7', '99.9', '24.1', '0', 'cloudy' ),( '10190', '2024-06-21', '02:00:00', '23.8', '8.3', '37', '0', '9.7', '0', '11.8', '116.4', '1009.3', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-21', '03:00:00', '23.8', '7.6', '35.42', '0', '9.7', '0', '13.3', '77.6', '1009', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-21', '04:00:00', '23.4', '7.8', '36.71', '0', '6.5', '0', '10.6', '97.2', '1009.7', '93.1', '23.4', '0', 'cloudy' ),( '10190', '2024-06-21', '05:00:00', '23', '8', '38.04', '0', '6.5', '0', '7.8', '116.9', '1010.3', '86.1', '22.7', '0', 'partly-cloudy-night' ),( '10190', '2024-06-21', '06:00:00', '22.7', '8.2', '39.43', '0.2', '6.5', '0', '5', '136.5', '1011', '79.2', '22', '0', 'partly-cloudy-day' ),( '10190', '2024-06-21', '07:00:00', '23.4', '8.9', '39.81', '0', '6.5', '0', '7.3', '148.1', '1011.3', '58.3', '22.7', '1', 'partly-cloudy-day' ),( '10190', '2024-06-21', '08:00:00', '24.1', '9.7', '40.18', '0', '6.5', '0', '9.6', '159.7', '1011.7', '37.5', '23.4', '2', 'partly-cloudy-day' ),( '10190', '2024-06-21', '09:00:00', '24.8', '10.5', '40.56', '0', '6.5', '0', '11.9', '171.3', '1012', '16.6', '24.1', '4', 'clear-day' ),( '10190', '2024-06-21', '10:00:00', '26.2', '9.7', '35.4', '0', '12.9', '0', '12.8', '177.7', '1011', '43.7', '24.1', '5', 'partly-cloudy-day' ),( '10190', '2024-06-21', '11:00:00', '27.7', '9', '30.91', '0', '12.9', '0', '13.8', '184.2', '1010', '70.9', '24.1', '6', 'partly-cloudy-day' ),( '10190', '2024-06-21', '12:00:00', '29.2', '8.3', '27.01', '0', '12.9', '0', '14.8', '190.6', '1009', '98', '24.1', '8', 'cloudy' ),( '10190', '2024-06-21', '13:00:00', '28.6', '9.1', '29.6', '0', '12.9', '0', '17.4', '181.6', '1008.7', '92.2', '24.1', '6', 'cloudy' ),( '10190', '2024-06-21', '14:00:00', '28', '10', '32.42', '0', '12.9', '0', '20', '172.6', '1008.3', '86.4', '24.1', '5', 'partly-cloudy-day' ),( '10190', '2024-06-21', '15:00:00', '27.5', '10.9', '35.51', '0.1', '12.9', '0', '22.7', '163.6', '1008', '80.6', '24.1', '3', 'partly-cloudy-day' ),( '10190', '2024-06-21', '16:00:00', '24.8', '11.5', '43.36', '0', '38.7', '0', '24.5', '135', '1009.7', '87.1', '21', '3', 'partly-cloudy-day' ),( '10190', '2024-06-21', '17:00:00', '22.2', '12.2', '53.11', '0', '38.7', '0', '26.3', '106.4', '1011.3', '93.5', '17.9', '2', 'cloudy' ),( '10190', '2024-06-21', '18:00:00', '19.6', '12.9', '65.24', '0.7', '38.7', '0', '28.1', '77.8', '1013', '100', '14.8', '1', 'cloudy' ),( '10190', '2024-06-21', '19:00:00', '20.4', '12.5', '60.23', '0', '38.7', '0', '26.4', '159.7', '1012.7', '100', '17.9', '0', 'cloudy' ),( '10190', '2024-06-21', '20:00:00', '21.3', '12.1', '55.62', '0', '38.7', '0', '24.7', '241.7', '1012.3', '100', '21', '0', 'cloudy' ),( '10190', '2024-06-21', '21:00:00', '22.2', '11.7', '51.38', '0.2', '38.7', '0', '23', '323.6', '1012', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-21', '22:00:00', '22.3', '11.3', '49.73', '0', '19.4', '0', '21.2', '297.3', '1011.3', '97.8', '24.1', '0', 'cloudy' ),( '10190', '2024-06-21', '23:00:00', '22.4', '10.9', '48.14', '0', '19.4', '0', '19.4', '270.9', '1010.7', '95.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_22 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '10190', '2024-06-22', '00:00:00', '22.5', '10.5', '46.59', '0.1', '19.4', '0', '17.6', '244.6', '1010', '93.4', '24.1', '0', 'cloudy' ),( '10190', '2024-06-22', '01:00:00', '22.2', '9.8', '45.29', '0', '19.4', '0', '15.2', '225', '1009.7', '64', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-22', '02:00:00', '21.9', '9.1', '44.01', '0', '19.4', '0', '12.8', '205.5', '1009.3', '34.5', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-22', '03:00:00', '21.7', '8.5', '42.77', '0', '19.4', '0', '10.4', '185.9', '1009', '5.1', '24.1', '0', 'clear-night' ),( '10190', '2024-06-22', '04:00:00', '21.1', '9.3', '46.84', '0', '0', '0', '10.8', '207.5', '1009.3', '36.7', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-22', '05:00:00', '20.5', '10.1', '51.29', '0', '0', '0', '11.2', '229.2', '1009.7', '68.2', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-22', '06:00:00', '20', '11', '56.15', '0', '0', '0', '11.5', '250.8', '1010', '99.8', '24.1', '0', 'cloudy' ),( '10190', '2024-06-22', '07:00:00', '22', '10.3', '47.2', '0', '0', '0', '12.4', '238.2', '1009.7', '99', '24.1', '1', 'cloudy' ),( '10190', '2024-06-22', '08:00:00', '24.1', '9.6', '39.75', '0', '0', '0', '13.2', '225.5', '1009.3', '98.2', '24.1', '2', 'cloudy' ),( '10190', '2024-06-22', '09:00:00', '26.2', '8.9', '33.52', '0', '0', '0', '14', '212.9', '1009', '97.4', '24.1', '3', 'cloudy' ),( '10190', '2024-06-22', '10:00:00', '27.3', '9.3', '32.35', '0', '0', '0', '18', '200', '1008.3', '89.1', '24.1', '5', 'partly-cloudy-day' ),( '10190', '2024-06-22', '11:00:00', '28.4', '9.7', '31.24', '0', '0', '0', '22', '187.2', '1007.7', '80.7', '24.1', '7', 'partly-cloudy-day' ),( '10190', '2024-06-22', '12:00:00', '29.5', '10.2', '30.17', '0', '0', '0', '25.9', '174.3', '1007', '72.4', '24.1', '9', 'partly-cloudy-day' ),( '10190', '2024-06-22', '13:00:00', '29.5', '10.7', '31.07', '0', '0', '0', '26.8', '175.8', '1006.3', '81', '24.1', '9', 'partly-cloudy-day' ),( '10190', '2024-06-22', '14:00:00', '29.6', '11.2', '32', '0', '0', '0', '27.6', '177.2', '1005.7', '89.6', '24.1', '9', 'partly-cloudy-day' ),( '10190', '2024-06-22', '15:00:00', '29.7', '11.7', '32.95', '0', '0', '0', '28.4', '178.7', '1005', '98.2', '24.1', '9', 'cloudy' ),( '10190', '2024-06-22', '16:00:00', '28.7', '12.3', '36.18', '0', '32.3', '0', '25.7', '175.9', '1005.3', '97.9', '24.1', '6', 'cloudy' ),( '10190', '2024-06-22', '17:00:00', '27.8', '12.9', '39.73', '0', '32.3', '0', '22.9', '173.2', '1005.7', '97.6', '24.1', '4', 'cloudy' ),( '10190', '2024-06-22', '18:00:00', '26.9', '13.5', '43.64', '0', '32.3', '0', '20.2', '170.4', '1006', '97.3', '24.1', '2', 'cloudy' ),( '10190', '2024-06-22', '19:00:00', '25.5', '14.1', '49.3', '0', '32.3', '0', '18.6', '182.4', '1007.3', '96.6', '24.1', '0', 'cloudy' ),( '10190', '2024-06-22', '20:00:00', '24.1', '14.7', '55.73', '0', '32.3', '0', '17', '194.5', '1008.7', '96', '24.1', '0', 'cloudy' ),( '10190', '2024-06-22', '21:00:00', '22.8', '15.4', '63.03', '0.1', '32.3', '0', '15.5', '206.5', '1010', '95.3', '24.1', '0', 'cloudy' ),( '10190', '2024-06-22', '22:00:00', '22.8', '14.5', '59.36', '0', '6.5', '0', '13.2', '216.6', '1009.7', '65.2', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-22', '23:00:00', '22.8', '13.6', '55.88', '0', '6.5', '0', '10.9', '226.6', '1009.3', '35.1', '24.1', '0', 'partly-cloudy-night' ) ON DUPLICATE KEY UPDATE temp = VALUES(temp), dew = VALUES(dew), humidity = VALUES(humidity), precip = VALUES(precip), precipprob = VALUES(precipprob), snow = VALUES(snow), windspeed = VALUES(windspeed), winddir = VALUES(winddir), pressure = VALUES(pressure), cloudcover = VALUES(cloudcover), visibility = VALUES(visibility), uvindex = VALUES(uvindex), icon = VALUES(icon)

INSERT INTO w_hours_23 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '10190', '2024-06-23', '00:00:00', '22.9', '12.7', '52.59', '0', '6.5', '0', '8.6', '236.7', '1009', '5', '24.1', '0', 'clear-night' ),( '10190', '2024-06-23', '01:00:00', '21.5', '13.7', '60.88', '0', '6.5', '0', '12', '217', '1009.3', '4.9', '24.1', '0', 'clear-night' ),( '10190', '2024-06-23', '02:00:00', '20.2', '14.7', '70.51', '0', '6.5', '0', '15.4', '197.2', '1009.7', '4.8', '24.1', '0', 'clear-night' ),( '10190', '2024-06-23', '03:00:00', '18.9', '15.7', '81.68', '0', '6.5', '0', '18.7', '177.5', '1010', '4.7', '24.1', '0', 'clear-night' ),( '10190', '2024-06-23', '04:00:00', '18.7', '15.5', '81.84', '0', '0', '0', '15.4', '180', '1010.3', '4.7', '24.1', '0', 'clear-night' ),( '10190', '2024-06-23', '05:00:00', '18.5', '15.4', '81.99', '0', '0', '0', '12', '182.6', '1010.7', '4.8', '24.1', '0', 'clear-night' ),( '10190', '2024-06-23', '06:00:00', '18.4', '15.3', '82.14', '0', '0', '0', '8.6', '185.1', '1011', '4.8', '24.1', '0', 'clear-day' ),( '10190', '2024-06-23', '07:00:00', '20.6', '13.9', '65.61', '0', '0', '0', '10.2', '191.6', '1010.3', '5.1', '24.1', '1', 'clear-day' ),( '10190', '2024-06-23', '08:00:00', '22.9', '12.7', '52.48', '0', '0', '0', '11.8', '198', '1009.7', '5.3', '24.1', '2', 'clear-day' ),( '10190', '2024-06-23', '09:00:00', '25.2', '11.4', '42.04', '0', '0', '0', '13.3', '204.5', '1009', '5.6', '24.1', '4', 'clear-day' ),( '10190', '2024-06-23', '10:00:00', '27.1', '9.7', '33.49', '0', '3.2', '0', '15.5', '200.6', '1007.7', '9.4', '24.1', '6', 'clear-day' ),( '10190', '2024-06-23', '11:00:00', '29', '7.9', '26.67', '0', '3.2', '0', '17.6', '196.6', '1006.3', '13.1', '24.1', '7', 'clear-day' ),( '10190', '2024-06-23', '12:00:00', '31', '6.3', '21.25', '0', '3.2', '0', '19.8', '192.7', '1005', '16.9', '24.1', '9', 'clear-day' ),( '10190', '2024-06-23', '13:00:00', '31.4', '4.5', '18.3', '0', '3.2', '0', '15.1', '159.3', '1004.3', '43.3', '24.1', '9', 'partly-cloudy-day' ),( '10190', '2024-06-23', '14:00:00', '31.9', '2.7', '15.74', '0', '3.2', '0', '10.4', '125.8', '1003.7', '69.7', '24.1', '9', 'partly-cloudy-day' ),( '10190', '2024-06-23', '15:00:00', '32.4', '1', '13.51', '0', '3.2', '0', '5.8', '92.4', '1003', '96.1', '24.1', '9', 'cloudy' ),( '10190', '2024-06-23', '16:00:00', '29.3', '5.8', '22.58', '0', '19.4', '0', '12.5', '122.9', '1004.3', '85.5', '24.1', '7', 'partly-cloudy-day' ),( '10190', '2024-06-23', '17:00:00', '26.2', '10.6', '37.42', '0', '19.4', '0', '19.2', '153.4', '1005.7', '75', '24.1', '5', 'partly-cloudy-day' ),( '10190', '2024-06-23', '18:00:00', '23.2', '15.4', '61.52', '0', '19.4', '0', '25.9', '183.9', '1007', '64.4', '24.1', '3', 'partly-cloudy-day' ),( '10190', '2024-06-23', '19:00:00', '23.2', '15', '59.72', '0', '19.4', '0', '20.6', '179.9', '1007.3', '45.2', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-23', '20:00:00', '23.3', '14.6', '57.97', '0', '19.4', '0', '15.4', '175.8', '1007.7', '26.1', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-23', '21:00:00', '23.4', '14.2', '56.26', '0', '19.4', '0', '10.1', '171.8', '1008', '6.9', '24.1', '0', 'clear-night' ),( '10190', '2024-06-23', '22:00:00', '23.2', '13.6', '54.77', '0', '0', '0', '9.5', '179.2', '1008', '6.4', '24.1', '0', 'clear-night' ),( '10190', '2024-06-23', '23:00:00', '22.9', '13', '53.31', '0', '0', '0', '8.9', '186.6', '1008', '6', '24.1', '0', 'clear-night' ) ON DUPLICATE KEY UPDATE temp = VALUES(temp), dew = VALUES(dew), humidity = VALUES(humidity), precip = VALUES(precip), precipprob = VALUES(precipprob), snow = VALUES(snow), windspeed = VALUES(windspeed), winddir = VALUES(winddir), pressure = VALUES(pressure), cloudcover = VALUES(cloudcover), visibility = VALUES(visibility), uvindex = VALUES(uvindex), icon = VALUES(icon)

INSERT INTO w_hours_24 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '10190', '2024-06-24', '00:00:00', '22.8', '12.4', '51.88', '0', '0', '0', '8.3', '194', '1008', '5.5', '24.1', '0', 'clear-night' ),( '10190', '2024-06-24', '01:00:00', '21.6', '13.3', '59.21', '0', '0', '0', '9.6', '184.4', '1008', '37', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-24', '02:00:00', '20.5', '14.3', '67.59', '0', '0', '0', '10.9', '174.7', '1008', '68.5', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-24', '03:00:00', '19.4', '15.3', '77.17', '0', '0', '0', '12.2', '165.1', '1008', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-24', '04:00:00', '19.3', '13.7', '70.19', '0', '3.2', '0', '11.2', '164.2', '1008.3', '85.1', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-24', '05:00:00', '19.2', '12.2', '63.76', '0', '3.2', '0', '10.1', '163.2', '1008.7', '70.3', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-24', '06:00:00', '19.2', '10.7', '57.85', '0', '3.2', '0', '9', '162.3', '1009', '55.4', '24.1', '0', 'partly-cloudy-day' ),( '10190', '2024-06-24', '07:00:00', '20.4', '10.6', '53.34', '0', '3.2', '0', '12.5', '167.3', '1009', '42.4', '24.1', '1', 'partly-cloudy-day' ),( '10190', '2024-06-24', '08:00:00', '21.6', '10.5', '49.22', '0', '3.2', '0', '16', '172.4', '1009', '29.4', '24.1', '2', 'partly-cloudy-day' ),( '10190', '2024-06-24', '09:00:00', '22.8', '10.4', '45.44', '0', '3.2', '0', '19.4', '177.4', '1009', '16.4', '24.1', '4', 'clear-day' ),( '10190', '2024-06-24', '10:00:00', '24.3', '10.1', '40.79', '0', '9.7', '0', '19.8', '175.2', '1008.3', '30.8', '24.1', '6', 'partly-cloudy-day' ),( '10190', '2024-06-24', '11:00:00', '25.8', '9.9', '36.65', '0', '9.7', '0', '20.2', '173.1', '1007.7', '45.1', '24.1', '7', 'partly-cloudy-day' ),( '10190', '2024-06-24', '12:00:00', '27.4', '9.7', '32.97', '0', '9.7', '0', '20.5', '170.9', '1007', '59.5', '24.1', '9', 'partly-cloudy-day' ),( '10190', '2024-06-24', '13:00:00', '27.9', '9.9', '32.39', '0', '9.7', '0', '20.9', '169.9', '1006', '73', '24.1', '9', 'partly-cloudy-day' ),( '10190', '2024-06-24', '14:00:00', '28.5', '10.1', '31.84', '0', '9.7', '0', '21.2', '168.8', '1005', '86.5', '24.1', '9', 'partly-cloudy-day' ),( '10190', '2024-06-24', '15:00:00', '29.1', '10.4', '31.29', '0', '9.7', '0', '21.6', '167.8', '1004', '100', '24.1', '9', 'cloudy' ),( '10190', '2024-06-24', '16:00:00', '28.1', '11.2', '35.05', '0', '22.6', '0', '21.5', '169.1', '1004.7', '100', '24.1', '7', 'cloudy' ),( '10190', '2024-06-24', '17:00:00', '27.1', '12', '39.27', '0', '22.6', '0', '21.4', '170.3', '1005.3', '100', '24.1', '5', 'cloudy' ),( '10190', '2024-06-24', '18:00:00', '26.1', '12.9', '43.99', '0.1', '22.6', '0', '21.2', '171.6', '1006', '100', '24.1', '3', 'cloudy' ),( '10190', '2024-06-24', '19:00:00', '24.9', '13.9', '50.53', '0', '22.6', '0', '17.9', '182.5', '1007', '99.6', '24.1', '0', 'cloudy' ),( '10190', '2024-06-24', '20:00:00', '23.7', '14.9', '58.05', '0', '22.6', '0', '14.5', '193.5', '1008', '99.3', '24.1', '0', 'cloudy' ),( '10190', '2024-06-24', '21:00:00', '22.5', '16', '66.7', '0.4', '22.6', '0', '11.2', '204.4', '1009', '98.9', '24.1', '0', 'cloudy' ),( '10190', '2024-06-24', '22:00:00', '22.1', '16', '68.49', '0', '16.1', '0', '11.8', '190.5', '1009', '99.2', '24.1', '0', 'cloudy' ),( '10190', '2024-06-24', '23:00:00', '21.7', '16', '70.33', '0', '16.1', '0', '12.4', '176.5', '1009', '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_25 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '10190', '2024-06-25', '00:00:00', '21.3', '16.1', '72.23', '0', '16.1', '0', '13', '162.6', '1009', '99.9', '24.1', '0', 'cloudy' ),( '10190', '2024-06-25', '01:00:00', '20.2', '15.6', '75.03', '0', '16.1', '0', '13.6', '169.6', '1009.3', '98.6', '24.1', '0', 'cloudy' ),( '10190', '2024-06-25', '02:00:00', '19.1', '15.2', '77.97', '0', '16.1', '0', '14.2', '176.7', '1009.7', '97.2', '24.1', '0', 'cloudy' ),( '10190', '2024-06-25', '03:00:00', '18.1', '14.8', '81.06', '0.3', '16.1', '0', '14.8', '183.7', '1010', '95.9', '24.1', '0', 'cloudy' ),( '10190', '2024-06-25', '04:00:00', '17.8', '14.4', '80.16', '0', '0', '0', '13', '185.2', '1010.3', '97.1', '24.1', '0', 'cloudy' ),( '10190', '2024-06-25', '05:00:00', '17.6', '13.9', '79.27', '0', '0', '0', '11.2', '186.8', '1010.7', '98.3', '24.1', '0', 'cloudy' ),( '10190', '2024-06-25', '06:00:00', '17.4', '13.6', '78.38', '0', '0', '0', '9.4', '188.3', '1011', '99.5', '24.1', '0', 'cloudy' ),( '10190', '2024-06-25', '07:00:00', '19.3', '13.1', '67.2', '0', '0', '0', '9.5', '192', '1010.7', '71.4', '24.1', '1', 'partly-cloudy-day' ),( '10190', '2024-06-25', '08:00:00', '21.2', '12.6', '57.71', '0', '0', '0', '9.6', '195.8', '1010.3', '43.4', '24.1', '2', 'partly-cloudy-day' ),( '10190', '2024-06-25', '09:00:00', '23.2', '12.1', '49.65', '0', '0', '0', '9.7', '199.5', '1010', '15.3', '24.1', '4', 'clear-day' ),( '10190', '2024-06-25', '10:00:00', '25', '11.4', '42.65', '0', '9.7', '0', '14.2', '189.8', '1009', '12.7', '24.1', '5', 'clear-day' ),( '10190', '2024-06-25', '11:00:00', '26.8', '10.8', '36.69', '0', '9.7', '0', '18.6', '180.2', '1008', '10.1', '24.1', '7', 'clear-day' ),( '10190', '2024-06-25', '12:00:00', '28.7', '10.2', '31.6', '0', '9.7', '0', '23', '170.5', '1007', '7.5', '24.1', '9', 'clear-day' ),( '10190', '2024-06-25', '13:00:00', '27.4', '11.4', '36.78', '0', '9.7', '0', '20.6', '172.6', '1007', '37.7', '24.1', '8', 'partly-cloudy-day' ),( '10190', '2024-06-25', '14:00:00', '26.2', '12.6', '42.8', '0', '9.7', '0', '18.2', '174.8', '1007', '67.8', '24.1', '6', 'partly-cloudy-day' ),( '10190', '2024-06-25', '15:00:00', '25', '13.8', '49.8', '0', '9.7', '0', '15.8', '176.9', '1007', '98', '24.1', '5', 'cloudy' ),( '10190', '2024-06-25', '16:00:00', '24.1', '13.9', '52.8', '0', '22.6', '0', '16.1', '216.4', '1007.7', '98.7', '17.7', '4', 'cloudy' ),( '10190', '2024-06-25', '17:00:00', '23.3', '14', '56', '0', '22.6', '0', '16.3', '255.8', '1008.3', '99.3', '11.3', '3', 'cloudy' ),( '10190', '2024-06-25', '18:00:00', '22.5', '14.2', '59.41', '2.7', '22.6', '0', '16.6', '295.3', '1009', '100', '4.9', '1', 'cloudy' ),( '10190', '2024-06-25', '19:00:00', '21.6', '13.3', '58.96', '0', '22.6', '0', '19.9', '297', '1009.7', '100', '11.3', '0', 'cloudy' ),( '10190', '2024-06-25', '20:00:00', '20.8', '12.4', '58.5', '0', '22.6', '0', '23.3', '298.7', '1010.3', '100', '17.7', '0', 'cloudy' ),( '10190', '2024-06-25', '21:00:00', '20', '11.5', '58.04', '2.2', '22.6', '0', '26.6', '300.4', '1011', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-25', '22:00:00', '20.4', '11.3', '55.77', '0', '6.5', '0', '24.8', '307.6', '1010.7', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-25', '23:00:00', '20.9', '11.1', '53.6', '0', '6.5', '0', '23', '314.9', '1010.3', '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_26 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '10190', '2024-06-26', '00:00:00', '21.4', '11', '51.51', '0', '6.5', '0', '21.2', '322.1', '1010', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-26', '01:00:00', '21.2', '11', '51.93', '0', '6.5', '0', '16.7', '280.7', '1009.3', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-26', '02:00:00', '21.1', '11', '52.36', '0', '6.5', '0', '12.1', '239.2', '1008.7', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-26', '03:00:00', '21', '11', '52.79', '0', '6.5', '0', '7.6', '197.8', '1008', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-26', '04:00:00', '21.3', '10.6', '50.69', '0', '3.2', '0', '7.6', '226.6', '1008.3', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-26', '05:00:00', '21.6', '10.3', '48.67', '0', '3.2', '0', '7.6', '255.4', '1008.7', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-26', '06:00:00', '21.9', '10', '46.74', '0', '3.2', '0', '7.6', '284.2', '1009', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-26', '07:00:00', '22.6', '10.3', '45.61', '0', '3.2', '0', '10.2', '256.8', '1009', '68.3', '24.1', '1', 'partly-cloudy-day' ),( '10190', '2024-06-26', '08:00:00', '23.4', '10.6', '44.52', '0', '3.2', '0', '12.8', '229.3', '1009', '36.7', '24.1', '2', 'partly-cloudy-day' ),( '10190', '2024-06-26', '09:00:00', '24.2', '11', '43.47', '0', '3.2', '0', '15.5', '201.9', '1009', '5', '24.1', '3', 'clear-day' ),( '10190', '2024-06-26', '10:00:00', '25.7', '10.2', '37.62', '0', '6.5', '0', '16', '206.2', '1008', '14', '24.1', '5', 'clear-day' ),( '10190', '2024-06-26', '11:00:00', '27.3', '9.4', '32.58', '0', '6.5', '0', '16.4', '210.5', '1007', '22.9', '24.1', '7', 'partly-cloudy-day' ),( '10190', '2024-06-26', '12:00:00', '28.9', '8.7', '28.24', '0', '6.5', '0', '16.9', '214.8', '1006', '31.9', '24.1', '9', 'partly-cloudy-day' ),( '10190', '2024-06-26', '13:00:00', '28.5', '9.3', '30.17', '0', '6.5', '0', '20.2', '208.7', '1005.7', '50.4', '24.1', '8', 'partly-cloudy-day' ),( '10190', '2024-06-26', '14:00:00', '28.1', '10', '32.23', '0', '6.5', '0', '23.4', '202.7', '1005.3', '69', '24.1', '6', 'partly-cloudy-day' ),( '10190', '2024-06-26', '15:00:00', '27.8', '10.7', '34.43', '0', '6.5', '0', '26.6', '196.6', '1005', '87.5', '24.1', '5', 'partly-cloudy-day' ),( '10190', '2024-06-26', '16:00:00', '27.4', '10.7', '35.25', '0', '16.1', '0', '22.8', '200.9', '1005.3', '91.7', '24.1', '4', 'cloudy' ),( '10190', '2024-06-26', '17:00:00', '27', '10.7', '36.1', '0', '16.1', '0', '19', '205.3', '1005.7', '95.8', '24.1', '4', 'cloudy' ),( '10190', '2024-06-26', '18:00:00', '26.7', '10.8', '36.97', '0', '16.1', '0', '15.1', '209.6', '1006', '100', '24.1', '3', 'cloudy' ),( '10190', '2024-06-26', '19:00:00', '25.8', '11.3', '40.4', '0', '16.1', '0', '15.6', '202.6', '1006.3', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-26', '20:00:00', '24.9', '11.9', '44.16', '0', '16.1', '0', '16.1', '195.7', '1006.7', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-26', '21:00:00', '24.1', '12.5', '48.28', '0.2', '16.1', '0', '16.6', '188.7', '1007', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-26', '22:00:00', '23.8', '12.9', '50.36', '0', '3.2', '0', '14.9', '217.3', '1006.7', '87.1', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-26', '23:00:00', '23.5', '13.3', '52.53', '0', '3.2', '0', '13.2', '245.8', '1006.3', '74.2', '24.1', '0', 'partly-cloudy-night' ) ON DUPLICATE KEY UPDATE temp = VALUES(temp), dew = VALUES(dew), humidity = VALUES(humidity), precip = VALUES(precip), precipprob = VALUES(precipprob), snow = VALUES(snow), windspeed = VALUES(windspeed), winddir = VALUES(winddir), pressure = VALUES(pressure), cloudcover = VALUES(cloudcover), visibility = VALUES(visibility), uvindex = VALUES(uvindex), icon = VALUES(icon)

INSERT INTO w_hours_27 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '10190', '2024-06-27', '00:00:00', '23.3', '13.7', '54.79', '0', '3.2', '0', '11.5', '274.4', '1006', '61.3', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-27', '01:00:00', '22.8', '13.4', '55.16', '0', '3.2', '0', '10.3', '263.8', '1005.7', '43.1', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-27', '02:00:00', '22.4', '13.1', '55.53', '0', '3.2', '0', '9.1', '253.1', '1005.3', '25', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-27', '03:00:00', '22', '12.8', '55.91', '0', '3.2', '0', '7.9', '242.5', '1005', '6.8', '24.1', '0', 'clear-night' ),( '10190', '2024-06-27', '04:00:00', '21.8', '12.3', '54.66', '0', '3.2', '0', '8.5', '245', '1005.3', '6.6', '24.1', '0', 'clear-night' ),( '10190', '2024-06-27', '05:00:00', '21.6', '11.8', '53.43', '0', '3.2', '0', '9.1', '247.6', '1005.7', '6.4', '24.1', '0', 'clear-night' ),( '10190', '2024-06-27', '06:00:00', '21.5', '11.3', '52.22', '0', '3.2', '0', '9.7', '250.1', '1006', '6.2', '24.1', '0', 'clear-day' ),( '10190', '2024-06-27', '07:00:00', '23.2', '10.6', '44.97', '0', '3.2', '0', '11', '244.6', '1005.7', '37.5', '24.1', '1', 'partly-cloudy-day' ),( '10190', '2024-06-27', '08:00:00', '25', '10', '38.77', '0', '3.2', '0', '12.4', '239.1', '1005.3', '68.7', '24.1', '2', 'partly-cloudy-day' ),( '10190', '2024-06-27', '09:00:00', '26.8', '9.4', '33.47', '0', '3.2', '0', '13.7', '233.6', '1005', '100', '24.1', '4', 'cloudy' ),( '10190', '2024-06-27', '10:00:00', '28.6', '5.9', '23.79', '0', '0', '0', '14.5', '162.7', '1004', '85.8', '24.1', '5', 'partly-cloudy-day' ),( '10190', '2024-06-27', '11:00:00', '30.4', '2.5', '16.83', '0', '0', '0', '15.4', '91.9', '1003', '71.7', '24.1', '7', 'partly-cloudy-day' ),( '10190', '2024-06-27', '12:00:00', '32.3', '-0.9', '11.84', '0', '0', '0', '16.2', '21', '1002', '57.5', '24.1', '9', 'partly-cloudy-day' ),( '10190', '2024-06-27', '13:00:00', '32.6', '-1.3', '11.33', '0', '0', '0', '21.2', '22.5', '1001.3', '70.7', '24.1', '9', 'partly-cloudy-day' ),( '10190', '2024-06-27', '14:00:00', '32.9', '-1.7', '10.84', '0', '0', '0', '26.3', '24', '1000.7', '83.8', '24.1', '9', 'partly-cloudy-day' ),( '10190', '2024-06-27', '15:00:00', '33.2', '-2', '10.38', '0', '0', '0', '31.3', '25.5', '1000', '97', '24.1', '9', 'cloudy' ),( '10190', '2024-06-27', '16:00:00', '32.5', '-2.5', '10.37', '0', '12.9', '0', '26.9', '33.8', '1000.3', '98', '24.1', '7', 'cloudy' ),( '10190', '2024-06-27', '17:00:00', '31.9', '-3', '10.35', '0', '12.9', '0', '22.4', '42.2', '1000.7', '99', '24.1', '5', 'cloudy' ),( '10190', '2024-06-27', '18:00:00', '31.3', '-3.5', '10.34', '0', '12.9', '0', '18', '50.5', '1001', '100', '24.1', '3', 'cloudy' ),( '10190', '2024-06-27', '19:00:00', '29.1', '2.5', '18.13', '0', '12.9', '0', '16', '99.5', '1002.3', '99.8', '24.1', '0', 'cloudy' ),( '10190', '2024-06-27', '20:00:00', '27', '8.5', '31.21', '0', '12.9', '0', '13.9', '148.5', '1003.7', '99.6', '24.1', '0', 'cloudy' ),( '10190', '2024-06-27', '21:00:00', '24.9', '14.6', '52.76', '0', '12.9', '0', '11.9', '197.5', '1005', '99.4', '24.1', '0', 'cloudy' ),( '10190', '2024-06-27', '22:00:00', '24.9', '13.9', '50.75', '0', '3.2', '0', '10.1', '219.9', '1004.7', '99.6', '24.1', '0', 'cloudy' ),( '10190', '2024-06-27', '23:00:00', '24.9', '13.4', '48.81', '0', '3.2', '0', '8.3', '242.4', '1004.3', '99.8', '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_28 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '10190', '2024-06-28', '00:00:00', '24.9', '12.8', '46.94', '0', '3.2', '0', '6.5', '264.8', '1004', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-28', '01:00:00', '24.8', '11.7', '44.03', '0', '3.2', '0', '5.6', '264.9', '1003.7', '99.8', '24.1', '0', 'cloudy' ),( '10190', '2024-06-28', '02:00:00', '24.7', '10.7', '41.28', '0', '3.2', '0', '4.8', '265.1', '1003.3', '99.7', '24.1', '0', 'cloudy' ),( '10190', '2024-06-28', '03:00:00', '24.7', '9.7', '38.68', '0', '3.2', '0', '4', '265.2', '1003', '99.5', '24.1', '0', 'cloudy' ),( '10190', '2024-06-28', '04:00:00', '23.8', '10.9', '44.05', '0', '3.2', '0', '5', '244.3', '1003.7', '70.7', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-28', '05:00:00', '23', '12.1', '50.15', '0', '3.2', '0', '6.1', '223.5', '1004.3', '41.8', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-28', '06:00:00', '22.2', '13.3', '57.07', '0', '3.2', '0', '7.2', '202.6', '1005', '13', '24.1', '0', 'clear-day' ),( '10190', '2024-06-28', '07:00:00', '23', '13.4', '54.73', '0', '3.2', '0', '8', '193.9', '1005.3', '27.6', '24.1', '1', 'partly-cloudy-day' ),( '10190', '2024-06-28', '08:00:00', '23.8', '13.5', '52.5', '0', '3.2', '0', '8.9', '185.3', '1005.7', '42.3', '24.1', '2', 'partly-cloudy-day' ),( '10190', '2024-06-28', '09:00:00', '24.7', '13.7', '50.37', '0', '3.2', '0', '9.7', '176.6', '1006', '56.9', '24.1', '3', 'partly-cloudy-day' ),( '10190', '2024-06-28', '10:00:00', '26.9', '8', '30.21', '0', '6.5', '0', '16.4', '124.9', '1005', '71.3', '24.1', '5', 'partly-cloudy-day' ),( '10190', '2024-06-28', '11:00:00', '29.1', '2.3', '17.84', '0', '6.5', '0', '23.2', '73.1', '1004', '85.6', '24.1', '7', 'partly-cloudy-day' ),( '10190', '2024-06-28', '12:00:00', '31.4', '-3.4', '10.36', '0', '6.5', '0', '29.9', '21.4', '1003', '100', '24.1', '8', 'cloudy' ),( '10190', '2024-06-28', '13:00:00', '31.7', '-3.2', '10.32', '0', '6.5', '0', '28', '24', '1002.3', '88', '24.1', '8', 'partly-cloudy-day' ),( '10190', '2024-06-28', '14:00:00', '32', '-3', '10.27', '0', '6.5', '0', '26', '26.5', '1001.7', '76.1', '24.1', '8', 'partly-cloudy-day' ),( '10190', '2024-06-28', '15:00:00', '32.4', '-2.8', '10.23', '0', '6.5', '0', '24.1', '29.1', '1001', '64.1', '24.1', '8', 'partly-cloudy-day' ),( '10190', '2024-06-28', '16:00:00', '31.5', '0', '13.26', '0', '12.9', '0', '22', '61.1', '1001.3', '76.1', '24.1', '6', 'partly-cloudy-day' ),( '10190', '2024-06-28', '17:00:00', '30.6', '2.8', '17.1', '0', '12.9', '0', '19.8', '93', '1001.7', '88', '24.1', '5', 'partly-cloudy-day' ),( '10190', '2024-06-28', '18:00:00', '29.7', '5.7', '21.96', '0', '12.9', '0', '17.6', '125', '1002', '100', '24.1', '4', 'cloudy' ),( '10190', '2024-06-28', '19:00:00', '28.1', '8.6', '29.46', '0', '12.9', '0', '15.2', '150.4', '1003', '94.5', '24.1', '0', 'cloudy' ),( '10190', '2024-06-28', '20:00:00', '26.5', '11.6', '39.38', '0', '12.9', '0', '12.8', '175.9', '1004', '89.1', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-28', '21:00:00', '25', '14.6', '52.45', '0', '12.9', '0', '10.4', '201.3', '1005', '83.6', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-28', '22:00:00', '24.7', '14.2', '52.05', '0', '9.7', '0', '9.2', '220.9', '1005', '77.3', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-28', '23:00:00', '24.5', '13.9', '51.65', '0', '9.7', '0', '8', '240.6', '1005', '70.9', '24.1', '0', 'partly-cloudy-night' ) ON DUPLICATE KEY UPDATE temp = VALUES(temp), dew = VALUES(dew), humidity = VALUES(humidity), precip = VALUES(precip), precipprob = VALUES(precipprob), snow = VALUES(snow), windspeed = VALUES(windspeed), winddir = VALUES(winddir), pressure = VALUES(pressure), cloudcover = VALUES(cloudcover), visibility = VALUES(visibility), uvindex = VALUES(uvindex), icon = VALUES(icon)

INSERT INTO w_hours_29 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '10190', '2024-06-29', '00:00:00', '24.3', '13.6', '51.26', '0', '9.7', '0', '6.8', '260.2', '1005', '64.6', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-29', '01:00:00', '24.2', '12.7', '48.84', '0', '9.7', '0', '6.5', '260.1', '1004.7', '76.4', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-29', '02:00:00', '24.1', '11.9', '46.51', '0', '9.7', '0', '6.1', '259.9', '1004.3', '88.2', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-29', '03:00:00', '24', '11.1', '44.28', '0', '9.7', '0', '5.8', '259.8', '1004', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-29', '04:00:00', '24', '10.6', '42.93', '0', '3.2', '0', '5.4', '247.9', '1004.3', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-29', '05:00:00', '24', '10.1', '41.62', '0', '3.2', '0', '5', '235.9', '1004.7', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-29', '06:00:00', '24', '9.7', '40.34', '0', '3.2', '0', '4.7', '224', '1005', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-29', '07:00:00', '24.8', '10', '39.33', '0', '3.2', '0', '5.8', '228.2', '1005', '100', '24.1', '1', 'cloudy' ),( '10190', '2024-06-29', '08:00:00', '25.6', '10.4', '38.35', '0', '3.2', '0', '6.8', '232.5', '1005', '100', '24.1', '2', 'cloudy' ),( '10190', '2024-06-29', '09:00:00', '26.5', '10.8', '37.41', '0', '3.2', '0', '7.9', '236.7', '1005', '100', '24.1', '2', 'cloudy' ),( '10190', '2024-06-29', '10:00:00', '28.5', '6.2', '24.33', '0', '12.9', '0', '10.7', '166.9', '1004.3', '99.2', '24.1', '4', 'cloudy' ),( '10190', '2024-06-29', '11:00:00', '30.6', '1.6', '15.67', '0', '12.9', '0', '13.4', '97.2', '1003.7', '98.3', '24.1', '6', 'cloudy' ),( '10190', '2024-06-29', '12:00:00', '32.7', '-2.9', '9.99', '0', '12.9', '0', '16.2', '27.4', '1003', '97.5', '24.1', '8', 'cloudy' ),( '10190', '2024-06-29', '13:00:00', '32.8', '-3.3', '9.65', '0', '12.9', '0', '19.4', '28.6', '1002.3', '98.3', '24.1', '8', 'cloudy' ),( '10190', '2024-06-29', '14:00:00', '32.9', '-3.7', '9.31', '0', '12.9', '0', '22.7', '29.8', '1001.7', '99.2', '24.1', '8', 'cloudy' ),( '10190', '2024-06-29', '15:00:00', '33.1', '-4', '8.99', '0', '12.9', '0', '25.9', '31', '1001', '100', '24.1', '8', 'cloudy' ),( '10190', '2024-06-29', '16:00:00', '32.4', '-2.5', '10.46', '0', '22.6', '0', '22.4', '55.4', '1001.3', '87.2', '24.1', '6', 'partly-cloudy-day' ),( '10190', '2024-06-29', '17:00:00', '31.7', '-1', '12.16', '0', '22.6', '0', '19', '79.8', '1001.7', '74.4', '24.1', '5', 'partly-cloudy-day' ),( '10190', '2024-06-29', '18:00:00', '31', '0.5', '14.11', '0', '22.6', '0', '15.5', '104.2', '1002', '61.6', '24.1', '3', 'partly-cloudy-day' ),( '10190', '2024-06-29', '19:00:00', '29.3', '3.9', '19.82', '0', '22.6', '0', '13.3', '134.1', '1003', '74.4', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-29', '20:00:00', '27.6', '7.3', '27.69', '0', '22.6', '0', '11.2', '164', '1004', '87.2', '24.1', '0', 'partly-cloudy-night' ),( '10190', '2024-06-29', '21:00:00', '25.9', '10.7', '38.5', '0', '22.6', '0', '9', '193.9', '1005', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-29', '22:00:00', '25.9', '9.6', '35.63', '0', '0', '0', '8.5', '232.9', '1005', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-29', '23:00:00', '26', '8.5', '32.95', '0', '0', '0', '8', '271.9', '1005', '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_30 (post_id, weather_date, weather_time, temp, dew, humidity, precip, precipprob, snow, windspeed, winddir, pressure, cloudcover, visibility, uvindex, icon) VALUES ( '10190', '2024-06-30', '00:00:00', '26.1', '7.4', '30.46', '0', '0', '0', '7.6', '310.9', '1005', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-30', '01:00:00', '25.6', '5.9', '28.19', '0', '0', '0', '7.4', '302.3', '1004.3', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-30', '02:00:00', '25.2', '4.4', '26.06', '0', '0', '0', '7.3', '293.6', '1003.7', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-30', '03:00:00', '24.8', '2.9', '24.06', '0', '0', '0', '7.2', '285', '1003', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-30', '04:00:00', '24.5', '3.3', '25.16', '0', '0', '0', '7.2', '278.4', '1003.7', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-30', '05:00:00', '24.3', '3.7', '26.3', '0', '0', '0', '7.2', '271.9', '1004.3', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-30', '06:00:00', '24.1', '4.2', '27.5', '0', '0', '0', '7.2', '265.3', '1005', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-30', '07:00:00', '25.1', '3.3', '24.26', '0', '0', '0', '10.2', '293', '1005.3', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-30', '08:00:00', '26.1', '2.4', '21.41', '0', '0', '0', '13.2', '320.7', '1005.7', '100', '24.1', '1', 'cloudy' ),( '10190', '2024-06-30', '09:00:00', '27.2', '1.5', '18.89', '0', '0', '0', '16.2', '348.4', '1006', '100', '24.1', '1', 'cloudy' ),( '10190', '2024-06-30', '10:00:00', '28.7', '0.5', '16.12', '0', '3.2', '0', '22.2', '236.9', '1005', '100', '24.1', '3', 'cloudy' ),( '10190', '2024-06-30', '11:00:00', '30.3', '-0.4', '13.76', '0', '3.2', '0', '28.2', '125.4', '1004', '100', '24.1', '5', 'cloudy' ),( '10190', '2024-06-30', '12:00:00', '31.9', '-1.3', '11.76', '0', '3.2', '0', '34.2', '13.9', '1003', '100', '24.1', '6', 'cloudy' ),( '10190', '2024-06-30', '13:00:00', '32.1', '-1.9', '11.11', '0', '3.2', '0', '36', '18', '1002.7', '100', '24.1', '7', 'cloudy' ),( '10190', '2024-06-30', '14:00:00', '32.4', '-2.5', '10.5', '0', '3.2', '0', '37.8', '22.1', '1002.3', '100', '24.1', '7', 'cloudy' ),( '10190', '2024-06-30', '15:00:00', '32.7', '-3', '9.91', '0', '3.2', '0', '39.6', '26.2', '1002', '100', '24.1', '8', 'cloudy' ),( '10190', '2024-06-30', '16:00:00', '32', '-3.2', '10.16', '0', '29', '0', '34.1', '26.3', '1002.3', '100', '24.1', '6', 'cloudy' ),( '10190', '2024-06-30', '17:00:00', '31.3', '-3.4', '10.42', '0', '29', '0', '28.6', '26.3', '1002.7', '100', '24.1', '4', 'cloudy' ),( '10190', '2024-06-30', '18:00:00', '30.6', '-3.6', '10.68', '0', '29', '0', '23', '26.4', '1003', '100', '24.1', '2', 'cloudy' ),( '10190', '2024-06-30', '19:00:00', '29.9', '-3', '11.64', '0', '29', '0', '18.2', '26', '1003.7', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-30', '20:00:00', '29.3', '-2.3', '12.68', '0', '29', '0', '13.4', '25.5', '1004.3', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-30', '21:00:00', '28.7', '-1.6', '13.82', '0', '29', '0', '8.6', '25.1', '1005', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-30', '22:00:00', '27.7', '1.6', '18.49', '0', '6.5', '0', '8', '68.8', '1005', '100', '24.1', '0', 'cloudy' ),( '10190', '2024-06-30', '23:00:00', '26.8', '4.9', '24.6', '0', '6.5', '0', '7.4', '112.6', '1005', '100', '24.1', '0', 'cloudy' ) ON DUPLICATE KEY UPDATE temp = VALUES(temp), dew = VALUES(dew), humidity = VALUES(humidity), precip = VALUES(precip), precipprob = VALUES(precipprob), snow = VALUES(snow), windspeed = VALUES(windspeed), winddir = VALUES(winddir), pressure = VALUES(pressure), cloudcover = VALUES(cloudcover), visibility = VALUES(visibility), uvindex = VALUES(uvindex), icon = VALUES(icon)

O clima em Al Ḩiḑn

A previsão do tempo para hoje, amanhã e os próximos 10 dias em Al Ḩiḑn, Iémen

O clima para hoje em Al Ḩiḑn

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 Al Ḩiḑn por mês

Clique em um mês abaixo e veja em detalhes como normalmente é o clima em Al Ḩiḑn e o que você pode esperar. Com base nos dados históricos do clima de Al Ḩiḑn, 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