Extend Reporter - SC Poverty Stats

-- let's take circs and users in the zip codes

SELECT COUNT(DISTINCT au.id) as patrons, count(distinct acirc.id) as circs, szc.zip
FROM ACTION.circulation acirc
JOIN actor.usr au ON au.id = acirc.usr
JOIN actor.usr_address aua ON aua.usr = au.id
JOIN extend_reporter.stats_sc_poverty szc ON szc.zip = left(aua.post_code,5)
WHERE date(acirc.xact_start) >= NOW() - INTERVAL '3 years' AND szc.poverty_percent > 19.9
GROUP BY 3
;

drop table if exists extend_reporter.stats_sc_poverty;

create table extend_reporter.stats_sc_poverty (
id  serial,
zip text,
poverty_percent numeric
);

insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29202',80.29);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29840',63.40);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29810',51.24);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29923',47.91);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29590',47.71);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29945',45.80);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29403',45.78);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29481',45.65);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29104',44.61);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29556',43.57);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29434',41.22);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29592',39.31);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29567',39.31);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29405',39.06);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29564',38.46);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29940',38.45);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29306',38.34);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29446',38.14);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29436',37.19);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29142',36.59);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29042',36.55);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29018',36.43);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29114',36.42);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29560',35.96);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29510',35.78);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29536',35.75);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29046',35.60);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29525',35.29);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29817',35.07);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29129',35.03);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29163',34.93);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29727',34.93);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29468',34.92);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29545',34.30);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29148',34.29);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29059',34.29);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29921',33.98);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29080',33.77);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29056',33.71);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29015',33.50);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29113',33.44);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29827',33.34);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29062',33.33);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29003',32.98);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29659',32.75);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29081',32.61);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29479',32.42);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29426',32.40);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29849',32.37);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29475',32.16);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29540',31.72);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29203',31.60);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29069',31.60);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29822',31.17);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29125',31.09);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29571',30.73);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29932',30.66);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29132',30.61);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29565',30.59);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29843',30.39);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29101',30.29);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29102',30.20);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29168',30.18);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29718',30.16);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29574',30.02);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29568',29.95);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29506',29.83);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29624',29.82);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29927',29.59);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29082',29.57);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29939',29.32);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29570',29.28);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29133',29.26);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29051',29.26);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29112',29.22);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29546',29.11);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29922',28.84);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29658',28.79);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29918',28.74);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29115',28.64);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29828',28.22);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29593',28.10);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29520',27.97);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29204',27.70);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29180',27.46);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29581',27.45);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29856',27.40);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29429',27.04);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29512',26.57);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29488',26.57);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29518',26.53);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29108',26.41);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29554',26.40);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29853',26.23);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29449',26.19);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29584',26.19);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29128',26.19);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29832',26.16);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29836',26.10);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29547',26.07);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29532',25.93);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29001',25.84);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29845',25.78);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29047',25.72);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29487',25.71);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29440',25.67);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29728',25.47);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29555',25.42);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29048',25.15);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29550',25.11);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29812',25.08);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29438',25.07);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29601',25.04);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29944',25.03);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29842',24.81);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29153',24.62);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29569',24.59);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29406',24.53);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29044',24.48);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29631',24.44);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29453',24.38);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29178',24.18);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29477',24.16);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29146',24.15);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29010',23.99);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29936',23.92);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29458',23.84);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29014',23.82);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29516',23.80);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29137',23.76);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29164',23.72);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29030',23.71);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29470',23.53);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29801',23.52);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29162',23.49);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29829',23.46);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29563',23.36);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29646',23.33);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29150',23.29);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29611',23.27);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29834',23.23);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29377',23.23);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29065',23.15);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29709',23.02);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29474',23.01);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29920',22.79);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29201',22.66);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29135',22.64);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29161',22.57);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29628',22.56);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29527',22.52);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29039',22.46);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29911',22.43);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29138',22.29);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29032',22.28);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29583',22.06);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29916',21.86);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29355',21.79);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29530',21.77);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29040',21.62);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29580',21.61);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29743',21.60);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29934',21.47);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29589',21.42);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29452',21.25);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29851',21.23);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29123',21.22);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29006',21.16);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29729',20.95);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29055',20.81);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29435',20.75);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29033',20.70);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29511',20.70);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29706',20.54);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29924',20.40);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29630',20.27);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29031',20.24);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29714',20.24);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29303',20.15);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29340',20.05);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29058',20.05);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29741',20.01);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29448',19.90);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29656',19.89);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29379',19.87);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29166',19.86);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29020',19.68);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29325',19.63);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29107',19.61);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29122',19.60);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29844',19.60);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29053',19.56);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29172',19.52);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29437',19.47);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29605',19.46);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29471',19.46);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29360',19.45);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29401',19.43);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29617',19.29);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29929',19.27);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29351',19.14);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29169',18.99);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29332',18.80);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29661',18.71);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29205',18.69);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29684',18.44);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29702',18.42);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29373',18.40);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29432',18.31);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29591',18.28);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29370',18.24);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29420',18.06);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29655',17.98);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29596',17.93);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29330',17.69);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29130',17.61);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29620',17.59);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29160',17.58);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29372',17.54);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29175',17.51);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29654',17.25);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29544',17.24);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29720',17.19);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29678',17.07);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29691',17.06);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29826',17.02);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29038',16.92);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29805',16.86);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29670',16.83);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29730',16.79);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29726',16.77);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29009',16.70);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29667',16.66);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29692',16.64);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29075',16.54);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29461',16.41);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29384',16.37);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29450',16.26);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29334',16.24);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29052',16.19);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29835',16.19);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29418',16.17);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29105',16.07);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29625',15.95);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29745',15.81);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29301',15.80);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29385',15.79);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29831',15.72);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29388',15.66);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29407',15.57);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29455',15.45);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29809',15.43);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29848',15.42);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29541',15.40);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29821',15.25);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29341',15.19);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29689',15.18);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29824',15.16);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29645',15.10);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29685',14.99);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29501',14.97);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29841',14.96);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29607',14.95);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29526',14.93);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29697',14.93);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29640',14.87);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29118',14.81);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29627',14.79);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29037',14.73);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29472',14.73);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29704',14.69);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29323',14.66);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29061',14.62);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29483',14.57);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29577',14.57);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29671',14.55);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29209',14.50);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29431',14.41);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29364',14.28);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29906',14.12);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29126',14.04);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29609',14.03);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29649',13.97);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29519',13.86);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29657',13.78);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29690',13.68);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29626',13.64);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29439',13.60);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29356',13.57);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29074',13.55);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29492',13.52);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29353',13.41);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29145',13.33);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29643',13.26);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29682',13.24);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29430',13.15);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29847',13.14);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29322',13.12);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29715',13.06);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29651',12.97);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29579',12.94);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29210',12.91);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29307',12.62);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29860',12.56);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29644',12.49);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29819',12.43);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29935',12.42);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29376',12.38);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29816',12.32);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29693',12.31);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29683',12.23);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29653',12.22);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29666',12.22);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29067',12.20);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29335',12.18);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29445',12.03);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29543',11.98);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29742',11.87);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29349',11.82);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29673',11.82);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29154',11.79);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29127',11.72);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29045',11.52);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29456',11.35);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29621',11.32);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29687',11.27);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29910',11.21);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29412',11.19);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29710',11.07);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29070',11.07);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29638',11.06);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29078',10.80);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29223',10.79);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29664',10.69);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29505',10.58);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29686',10.57);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29926',10.56);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29594',10.52);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29566',10.44);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29582',10.38);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29902',10.21);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29696',10.10);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29152',10.05);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29724',10.00);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29316',10.00);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29585',10.00);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29803',9.84);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29365',9.75);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29321',9.73);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29639',9.69);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29732',9.52);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29302',9.50);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29635',9.19);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29712',9.12);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29073',9.00);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29111',8.94);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29669',8.91);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29650',8.89);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29079',8.77);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29717',8.71);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29672',8.71);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29414',8.63);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29642',8.45);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29575',8.42);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29485',8.40);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29466',8.39);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29943',8.37);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29206',8.20);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29615',8.10);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29493',7.96);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29677',7.63);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29054',7.40);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29838',7.34);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29464',7.28);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29676',7.24);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29404',7.21);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29572',6.80);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29576',6.78);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29072',6.71);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29846',6.66);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29662',6.64);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29170',6.58);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29016',6.47);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29369',6.37);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29680',6.23);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29063',6.02);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29212',5.75);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29681',5.72);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29928',5.67);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29482',5.33);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29229',4.96);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29469',4.38);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29451',4.07);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29374',3.85);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29036',2.53);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29708',1.79);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29338',0.00);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29375',0.00);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29665',0.00);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29177',0.00);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29207',0.00);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29423',0.00);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29688',0.00);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29320',0.00);
insert into extend_reporter.stats_sc_poverty (zip,poverty_percent) values ('29850',0.00);