Last active
January 2, 2016 07:18
-
-
Save JoeGermuska/8268755 to your computer and use it in GitHub Desktop.
Find geographies with a poverty rate of greater than 40% with less than 10% derived MOE (excluding Puerto Rico) -- see https://www.pivotaltracker.com/story/show/63255358 I can't remember what it takes to get HTML rendered in gist, so I included the same data as text also.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <table border="1"> | |
| <tr> | |
| <th align="center">geoid</th> | |
| <th align="center">rate</th> | |
| <th align="center">moe</th> | |
| <th align="center">b17001001</th> | |
| <th align="center">b17001002</th> | |
| <th align="center">b17001001_moe</th> | |
| <th align="center">b17001002_moe</th> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/79500US0400122/">79500US0400122</a></td> | |
| <td align="right">0.520799429983902</td> | |
| <td align="right">0.0537939231790804</td> | |
| <td align="right">113681</td> | |
| <td align="right">59205</td> | |
| <td align="right">8981</td> | |
| <td align="right">7699</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/95000US0400600/">95000US0400600</a></td> | |
| <td align="right">0.447420042643923</td> | |
| <td align="right">0.0660020423918999</td> | |
| <td align="right">93800</td> | |
| <td align="right">41968</td> | |
| <td align="right">8535</td> | |
| <td align="right">7274</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/95000US0401680/">95000US0401680</a></td> | |
| <td align="right">0.416170531994701</td> | |
| <td align="right">0.0440379827872173</td> | |
| <td align="right">125302</td> | |
| <td align="right">52147</td> | |
| <td align="right">9127</td> | |
| <td align="right">6699</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/79500US0603745/">79500US0603745</a></td> | |
| <td align="right">0.466382624961031</td> | |
| <td align="right">0.0433176169895789</td> | |
| <td align="right">115476</td> | |
| <td align="right">53856</td> | |
| <td align="right">8714</td> | |
| <td align="right">6445</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/79500US0603746/">79500US0603746</a></td> | |
| <td align="right">0.420913402490411</td> | |
| <td align="right">0.0471581739407899</td> | |
| <td align="right">105846</td> | |
| <td align="right">44552</td> | |
| <td align="right">7451</td> | |
| <td align="right">5895</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/79500US0603751/">79500US0603751</a></td> | |
| <td align="right">0.417321208487392</td> | |
| <td align="right">0.0411214644336622</td> | |
| <td align="right">150105</td> | |
| <td align="right">62642</td> | |
| <td align="right">9906</td> | |
| <td align="right">7429</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/96000US0610860/">96000US0610860</a></td> | |
| <td align="right">0.452185005989514</td> | |
| <td align="right">0.0714375977736638</td> | |
| <td align="right">64279</td> | |
| <td align="right">29066</td> | |
| <td align="right">3992</td> | |
| <td align="right">4934</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/79500US1304600/">79500US1304600</a></td> | |
| <td align="right">0.426252200215322</td> | |
| <td align="right">0.0520670741223895</td> | |
| <td align="right">117034</td> | |
| <td align="right">49886</td> | |
| <td align="right">8082</td> | |
| <td align="right">7000</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/79500US1703528/">79500US1703528</a></td> | |
| <td align="right">0.413743343506966</td> | |
| <td align="right">0.0358094045521654</td> | |
| <td align="right">156614</td> | |
| <td align="right">64798</td> | |
| <td align="right">8267</td> | |
| <td align="right">6569</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/06000US1809711512/">06000US1809711512</a></td> | |
| <td align="right">0.409965053705808</td> | |
| <td align="right">0.0288951292063697</td> | |
| <td align="right">139929</td> | |
| <td align="right">57366</td> | |
| <td align="right">1730</td> | |
| <td align="right">4105</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/79500US1802305/">79500US1802305</a></td> | |
| <td align="right">0.409965053705808</td> | |
| <td align="right">0.0288951292063697</td> | |
| <td align="right">139929</td> | |
| <td align="right">57366</td> | |
| <td align="right">1730</td> | |
| <td align="right">4105</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/79500US2202401/">79500US2202401</a></td> | |
| <td align="right">0.402979366263171</td> | |
| <td align="right">0.030404093183895</td> | |
| <td align="right">104586</td> | |
| <td align="right">42146</td> | |
| <td align="right">5714</td> | |
| <td align="right">3926</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/06000US2616322000/">06000US2616322000</a></td> | |
| <td align="right">0.422967984214881</td> | |
| <td align="right">0.0164751410764237</td> | |
| <td align="right">691284</td> | |
| <td align="right">292391</td> | |
| <td align="right">2342</td> | |
| <td align="right">11432</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/16000US2622000/">16000US2622000</a></td> | |
| <td align="right">0.422967984214881</td> | |
| <td align="right">0.0164751410764237</td> | |
| <td align="right">691284</td> | |
| <td align="right">292391</td> | |
| <td align="right">2342</td> | |
| <td align="right">11432</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/31200US198202622000/">31200US198202622000</a></td> | |
| <td align="right">0.422967984214881</td> | |
| <td align="right">0.0164751410764237</td> | |
| <td align="right">691284</td> | |
| <td align="right">292391</td> | |
| <td align="right">2342</td> | |
| <td align="right">11432</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/79500US2603210/">79500US2603210</a></td> | |
| <td align="right">0.451747032948792</td> | |
| <td align="right">0.0322222302250782</td> | |
| <td align="right">120490</td> | |
| <td align="right">54431</td> | |
| <td align="right">6918</td> | |
| <td align="right">4984</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/79500US2603211/">79500US2603211</a></td> | |
| <td align="right">0.455522686234585</td> | |
| <td align="right">0.0439448201650972</td> | |
| <td align="right">130145</td> | |
| <td align="right">59284</td> | |
| <td align="right">7924</td> | |
| <td align="right">6763</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/79500US2603212/">79500US2603212</a></td> | |
| <td align="right">0.478159602333611</td> | |
| <td align="right">0.0405580365832754</td> | |
| <td align="right">134384</td> | |
| <td align="right">64257</td> | |
| <td align="right">7472</td> | |
| <td align="right">6517</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/97000US2612000/">97000US2612000</a></td> | |
| <td align="right">0.422967984214881</td> | |
| <td align="right">0.0164751410764237</td> | |
| <td align="right">691284</td> | |
| <td align="right">292391</td> | |
| <td align="right">2342</td> | |
| <td align="right">11432</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/50000US3615/">50000US3615</a></td> | |
| <td align="right">0.410377715010344</td> | |
| <td align="right">0.0149427553610107</td> | |
| <td align="right">714454</td> | |
| <td align="right">293196</td> | |
| <td align="right">14693</td> | |
| <td align="right">12261</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/79500US3603705/">79500US3603705</a></td> | |
| <td align="right">0.463706727488458</td> | |
| <td align="right">0.0366271718525234</td> | |
| <td align="right">162661</td> | |
| <td align="right">75427</td> | |
| <td align="right">10601</td> | |
| <td align="right">7724</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/79500US3603707/">79500US3603707</a></td> | |
| <td align="right">0.422871606074551</td> | |
| <td align="right">0.0362679457548118</td> | |
| <td align="right">130380</td> | |
| <td align="right">55134</td> | |
| <td align="right">7632</td> | |
| <td align="right">5725</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/79500US3603710/">79500US3603710</a></td> | |
| <td align="right">0.461091213231078</td> | |
| <td align="right">0.038301427794154</td> | |
| <td align="right">148257</td> | |
| <td align="right">68360</td> | |
| <td align="right">7757</td> | |
| <td align="right">6711</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/79500US3900906/">79500US3900906</a></td> | |
| <td align="right">0.418940842953754</td> | |
| <td align="right">0.0404027475846143</td> | |
| <td align="right">117112</td> | |
| <td align="right">49063</td> | |
| <td align="right">6026</td> | |
| <td align="right">5363</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/79500US3905504/">79500US3905504</a></td> | |
| <td align="right">0.404119843431519</td> | |
| <td align="right">0.0338321347027111</td> | |
| <td align="right">110878</td> | |
| <td align="right">44808</td> | |
| <td align="right">6047</td> | |
| <td align="right">4477</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/06000US4201163624/">06000US4201163624</a></td> | |
| <td align="right">0.405008222629142</td> | |
| <td align="right">0.0452530197175636</td> | |
| <td align="right">85739</td> | |
| <td align="right">34725</td> | |
| <td align="right">489</td> | |
| <td align="right">3885</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/16000US4263624/">16000US4263624</a></td> | |
| <td align="right">0.405008222629142</td> | |
| <td align="right">0.0452530197175636</td> | |
| <td align="right">85739</td> | |
| <td align="right">34725</td> | |
| <td align="right">489</td> | |
| <td align="right">3885</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/31200US397404263624/">31200US397404263624</a></td> | |
| <td align="right">0.405008222629142</td> | |
| <td align="right">0.0452530197175636</td> | |
| <td align="right">85739</td> | |
| <td align="right">34725</td> | |
| <td align="right">489</td> | |
| <td align="right">3885</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/79500US4203205/">79500US4203205</a></td> | |
| <td align="right">0.43746383652587</td> | |
| <td align="right">0.036338120387386</td> | |
| <td align="right">164185</td> | |
| <td align="right">71825</td> | |
| <td align="right">9918</td> | |
| <td align="right">7377</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/79500US4203207/">79500US4203207</a></td> | |
| <td align="right">0.408080878386608</td> | |
| <td align="right">0.0452995047949378</td> | |
| <td align="right">114938</td> | |
| <td align="right">46904</td> | |
| <td align="right">9449</td> | |
| <td align="right">6479</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/97000US4220040/">97000US4220040</a></td> | |
| <td align="right">0.405008222629142</td> | |
| <td align="right">0.0452530197175636</td> | |
| <td align="right">85739</td> | |
| <td align="right">34725</td> | |
| <td align="right">489</td> | |
| <td align="right">3885</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/79500US4806301/">79500US4806301</a></td> | |
| <td align="right">0.411378752471688</td> | |
| <td align="right">0.0371155158219529</td> | |
| <td align="right">133512</td> | |
| <td align="right">54924</td> | |
| <td align="right">8572</td> | |
| <td align="right">6082</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/79500US4806807/">79500US4806807</a></td> | |
| <td align="right">0.489415587518517</td> | |
| <td align="right">0.0716349028944279</td> | |
| <td align="right">104635</td> | |
| <td align="right">51210</td> | |
| <td align="right">9228</td> | |
| <td align="right">8751</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/97000US4826130/">97000US4826130</a></td> | |
| <td align="right">0.452014483935002</td> | |
| <td align="right">0.0613262566204547</td> | |
| <td align="right">100249</td> | |
| <td align="right">45314</td> | |
| <td align="right">8992</td> | |
| <td align="right">7370</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/97000US4826790/">97000US4826790</a></td> | |
| <td align="right">0.48031295988481</td> | |
| <td align="right">0.0452113592963683</td> | |
| <td align="right">94453</td> | |
| <td align="right">45367</td> | |
| <td align="right">7696</td> | |
| <td align="right">5648</td> | |
| </tr> | |
| <tr valign="top"> | |
| <td align="left"><a target="_blank" href="http://censusreporter.org/profiles/79500US5541003/">79500US5541003</a></td> | |
| <td align="right">0.4744689386414</td> | |
| <td align="right">0.0376990160190411</td> | |
| <td align="right">104696</td> | |
| <td align="right">49675</td> | |
| <td align="right">5694</td> | |
| <td align="right">4783</td> | |
| </tr> | |
| </table> | |
| <p>(36 rows)<br /> | |
| </p> |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select g.geoid, B17001002/B17001001 as rate, | |
| ((|/((B17001002_moe^2)-(((B17001002/B17001001)^2)*(B17001001_moe^2))))/B17001001) as moe, | |
| B17001001, B17001002, B17001001_moe, B17001002_moe | |
| from acs2012_1yr.B17001_moe d, acs2012_1yr.geoheader g | |
| where g.geoid = d.geoid and component = '00' and g.state != '72' | |
| and ((|/((B17001002_moe^2)-(((B17001002/B17001001)^2)*(B17001001_moe^2))))/B17001001) < .1 | |
| and B17001002/B17001001 > .4 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| geoid | rate | moe | b17001001 | b17001002 | b17001001_moe | b17001002_moe | |
| ---------------------+-------------------+--------------------+-----------+-----------+---------------+--------------- | |
| 79500US0400122 | 0.520799429983902 | 0.0537939231790804 | 113681 | 59205 | 8981 | 7699 | |
| 95000US0400600 | 0.447420042643923 | 0.0660020423918999 | 93800 | 41968 | 8535 | 7274 | |
| 95000US0401680 | 0.416170531994701 | 0.0440379827872173 | 125302 | 52147 | 9127 | 6699 | |
| 79500US0603745 | 0.466382624961031 | 0.0433176169895789 | 115476 | 53856 | 8714 | 6445 | |
| 79500US0603746 | 0.420913402490411 | 0.0471581739407899 | 105846 | 44552 | 7451 | 5895 | |
| 79500US0603751 | 0.417321208487392 | 0.0411214644336622 | 150105 | 62642 | 9906 | 7429 | |
| 96000US0610860 | 0.452185005989514 | 0.0714375977736638 | 64279 | 29066 | 3992 | 4934 | |
| 79500US1304600 | 0.426252200215322 | 0.0520670741223895 | 117034 | 49886 | 8082 | 7000 | |
| 79500US1703528 | 0.413743343506966 | 0.0358094045521654 | 156614 | 64798 | 8267 | 6569 | |
| 06000US1809711512 | 0.409965053705808 | 0.0288951292063697 | 139929 | 57366 | 1730 | 4105 | |
| 79500US1802305 | 0.409965053705808 | 0.0288951292063697 | 139929 | 57366 | 1730 | 4105 | |
| 79500US2202401 | 0.402979366263171 | 0.030404093183895 | 104586 | 42146 | 5714 | 3926 | |
| 06000US2616322000 | 0.422967984214881 | 0.0164751410764237 | 691284 | 292391 | 2342 | 11432 | |
| 16000US2622000 | 0.422967984214881 | 0.0164751410764237 | 691284 | 292391 | 2342 | 11432 | |
| 31200US198202622000 | 0.422967984214881 | 0.0164751410764237 | 691284 | 292391 | 2342 | 11432 | |
| 79500US2603210 | 0.451747032948792 | 0.0322222302250782 | 120490 | 54431 | 6918 | 4984 | |
| 79500US2603211 | 0.455522686234585 | 0.0439448201650972 | 130145 | 59284 | 7924 | 6763 | |
| 79500US2603212 | 0.478159602333611 | 0.0405580365832754 | 134384 | 64257 | 7472 | 6517 | |
| 97000US2612000 | 0.422967984214881 | 0.0164751410764237 | 691284 | 292391 | 2342 | 11432 | |
| 50000US3615 | 0.410377715010344 | 0.0149427553610107 | 714454 | 293196 | 14693 | 12261 | |
| 79500US3603705 | 0.463706727488458 | 0.0366271718525234 | 162661 | 75427 | 10601 | 7724 | |
| 79500US3603707 | 0.422871606074551 | 0.0362679457548118 | 130380 | 55134 | 7632 | 5725 | |
| 79500US3603710 | 0.461091213231078 | 0.038301427794154 | 148257 | 68360 | 7757 | 6711 | |
| 79500US3900906 | 0.418940842953754 | 0.0404027475846143 | 117112 | 49063 | 6026 | 5363 | |
| 79500US3905504 | 0.404119843431519 | 0.0338321347027111 | 110878 | 44808 | 6047 | 4477 | |
| 06000US4201163624 | 0.405008222629142 | 0.0452530197175636 | 85739 | 34725 | 489 | 3885 | |
| 16000US4263624 | 0.405008222629142 | 0.0452530197175636 | 85739 | 34725 | 489 | 3885 | |
| 31200US397404263624 | 0.405008222629142 | 0.0452530197175636 | 85739 | 34725 | 489 | 3885 | |
| 79500US4203205 | 0.43746383652587 | 0.036338120387386 | 164185 | 71825 | 9918 | 7377 | |
| 79500US4203207 | 0.408080878386608 | 0.0452995047949378 | 114938 | 46904 | 9449 | 6479 | |
| 97000US4220040 | 0.405008222629142 | 0.0452530197175636 | 85739 | 34725 | 489 | 3885 | |
| 79500US4806301 | 0.411378752471688 | 0.0371155158219529 | 133512 | 54924 | 8572 | 6082 | |
| 79500US4806807 | 0.489415587518517 | 0.0716349028944279 | 104635 | 51210 | 9228 | 8751 | |
| 97000US4826130 | 0.452014483935002 | 0.0613262566204547 | 100249 | 45314 | 8992 | 7370 | |
| 97000US4826790 | 0.48031295988481 | 0.0452113592963683 | 94453 | 45367 | 7696 | 5648 | |
| 79500US5541003 | 0.4744689386414 | 0.0376990160190411 | 104696 | 49675 | 5694 | 4783 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment