SELECT property_id from property WHERE property_name = '83 Hurlingham'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1185148800,97.90)<BR>SELECT property_id from property WHERE property_name = '220 Townsend'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1185148800,100)<BR>SELECT property_id from property WHERE property_name = '6-8 Boothwood'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1185148800,97.50)<BR>SELECT property_id from property WHERE property_name = 'Standard Hosue'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1198368000,97.90)<BR>SELECT property_id from property WHERE property_name = '1A Seymour -Flat 1'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1201046400,95.80)<BR>SELECT property_id from property WHERE property_name = '1A Seymour -Flat 2'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1201046400,98.70)<BR>SELECT property_id from property WHERE property_name = '1A Seymour -Flat 3'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1201046400,96.20)<BR>SELECT property_id from property WHERE property_name = '18 Thorntree Cl'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1203724800,100)<BR>SELECT property_id from property WHERE property_name = '170 Thomas Ln -Flat 1'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1203724800,96.60)<BR>SELECT property_id from property WHERE property_name = '170 Thomas Ln -Flat 2'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1203724800,97.50)<BR>SELECT property_id from property WHERE property_name = '170 Thomas Ln -Flat 3'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1203724800,100)<BR>SELECT property_id from property WHERE property_name = '170 Thomas Ln -Flat 4'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1203724800,100)<BR>SELECT property_id from property WHERE property_name = '61 Queen's Drive'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1208908800,95.40)<BR>SELECT property_id from property WHERE property_name = '61 Queen's Drive'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1208908800,95.40)<BR>SELECT property_id from property WHERE property_name = 'Nursng '<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1219449600,98.70)<BR>SELECT property_id from property WHERE property_name = '17 Tremore'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1222128000,100)<BR>SELECT property_id from property WHERE property_name = 'Chorley Old Rd [Lanc]'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1250985600,95)<BR>SELECT property_id from property WHERE property_name = 'Black Bull lane [Lancs]'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1222128000,86.6)<BR>SELECT property_id from property WHERE property_name = '76 Lakeland [Lancs]'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1224720000,100)<BR>SELECT property_id from property WHERE property_name = '99 Lakeland [Lancs]'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1224720000,96)<BR>SELECT property_id from property WHERE property_name = '5 Willow'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1227398400,100)<BR>SELECT property_id from property WHERE property_name = '1 Willow Close'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1227398400,99)<BR>SELECT property_id from property WHERE property_name = '61 Queens Drive'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1232668800,97.50)<BR>SELECT property_id from property WHERE property_name = '10 Old Colliery Rd'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1243036800,91.60)<BR>SELECT property_id from property WHERE property_name = '170 Thomas Lane Flat 1'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1243036800,99.20)<BR>SELECT property_id from property WHERE property_name = '172 Thomas Lane Flat 1'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1243036800,100)<BR>SELECT property_id from property WHERE property_name = '172 Thomas Lane Flat 2'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1243036800,100)<BR>SELECT property_id from property WHERE property_name = '60A Wingate'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1250985600,95.40)<BR>SELECT property_id from property WHERE property_name = '9 Priory Farm Court'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1261526400,95)<BR>SELECT property_id from property WHERE property_name = '60A Wingate'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1269302400,95.40)<BR>SELECT property_id from property WHERE property_name = '10 Old Colliery Rd'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1271980800,94.50)<BR>SELECT property_id from property WHERE property_name = '74B Edenhall Drive'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1274572800,82.40)<BR>SELECT property_id from property WHERE property_name = '2 Willow Close'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1277251200,93.70)<BR>SELECT property_id from property WHERE property_name = '4 Willow Close'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1277251200,95.40)<BR>SELECT property_id from property WHERE property_name = '42 Thingwall lane'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1285200000,97.10)<BR>SELECT property_id from property WHERE property_name = '48 Railton'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1292976000,100)<BR>SELECT property_id from property WHERE property_name = '3 North Barcombe'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1298419200,100)<BR>SELECT property_id from property WHERE property_name = '60A Wingate '<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1298419200,95.40)<BR>SELECT property_id from property WHERE property_name = '42 Thingwall Lane'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1300838400,100)<BR>SELECT property_id from property WHERE property_name = '4 Portico Lane '<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1311379200,95.80)<BR>SELECT property_id from property WHERE property_name = '12 Sherdley P Dr'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1311379200,97.10)<BR>SELECT property_id from property WHERE property_name = '218 Higher Rd'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1311379200,95.40)<BR>SELECT property_id from property WHERE property_name = '123 Mill Lane'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1311379200,98.70)<BR>SELECT property_id from property WHERE property_name = '74B Edenhall Dr'<BR>first check if this inspection date and property is not already in DB!<BR>INSERT INTO hs_matrix (property_id,inspection_ts,inspection_score) VALUES (property_id,1314057600,95.80)<BR>