Differences

This shows you the differences between two versions of the page.

--- census:qgis_poverty_date [2025/12/31 19:43] – created mlivolsi
+++ census:qgis_poverty_date [2025/12/31 19:44] (current) – mlivolsi
@@ Line 63: / Line 63: @@
 insert into meta_values (name, code, value)
-select 'households by state' as household, statefip, sum(hh_weight) from temp where gq = 1 group by household, statefip;
+select 'households by state' as household, statefip, sum(hh_weight)
+from temp
+where gq = 1
+group by household, statefip;
 insert into meta_values (name, code, value)
-select 'households by puma' as household, concat(statefip, lpad(puma,5,0)), sum(hh_weight) from temp where gq = 1 group by household,  statefip, puma;
+select 'households by puma' as household, concat(statefip, lpad(puma,5,0)), sum(hh_weight)
+from temp
+where gq = 1
+group by household, statefip, puma;
 </code>