<div dir="ltr">Nick:<div>I would suggest that the 2010 population data is pretty thin for analysis.  Off the top of my head, our 87505 ZIP has about 25k people as of 2019.  ZIP 87507 has about 50k.  Hence the crying need for an appropriate denominator when looking at cases by ZIP.</div><div>Tom</div><div>Tom<br clear="all"><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><br>============================================<br>Tom Johnson - <a href="mailto:tom@jtjohnson.com" target="_blank">tom@jtjohnson.com</a><br>Institute for Analytic Journalism   --     Santa Fe, NM USA<br>505.577.6482(c)                                    505.473.9646(h)<br><a href="http://nmfog.org" target="_blank"><b><font color="#0b5394">NM Foundation for Open Government</font></b></a><br><b><font color="#0000ff">Check out <a href="https://www.facebook.com/pages/Its-The-Peoples-Data/1599854626919671" target="_blank">It's The People's Data</a></font></b>                 </div><div>============================================</div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div><br></div></div><div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br>
<table style="border-top:1px solid #d3d4de">
        <tr>
        <td style="width:55px;padding-top:13px"><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif" alt="" width="46" height="29" style="width: 46px; height: 29px;"></a></td>
                <td style="width:470px;padding-top:12px;color:#41424e;font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">Virus-free. <a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link" target="_blank" style="color:#4453ea">www.avast.com</a>
                </td>
        </tr>
</table><a href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"></a></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Nov 2, 2020 at 12:27 PM <<a href="mailto:thompnickson2@gmail.com">thompnickson2@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div lang="EN-US" style="overflow-wrap: break-word;"><div class="gmail-m_-5063292500720025874WordSection1"><p class="gmail-m_-5063292500720025874MsoPlainText">Thanks, Glen, I think the relevant data line was POP100, although I don't know why "100".  In a  sane world, that would be the population in hundreds, but that would give our zip code a population of 4.5 million, which seems a bit  heavy.  In any case, for those of  you following case increments by zip code, here are some denominators as of 2010, as well as the most recent per day 7 day increments. .  The second two columns are deviation are expectation and deviation.  No surprises there, except that there seems to be a bit of a run of cases out by the golf course.  507 has a third more cases than it should have, which demonstrates once again that it's better for your health to be rich than poor.  <b><i>Caveat emptor:</i></b> these calculations were done literally on the back of an envelope by an 82 year old guy with poor eyesight and C's in math.  <u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText"><u></u> <u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">501 - 15,147  - 13% - 02.3c - 4  -<u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">505 - 31,013  - 25% - 06.0   - 8  -<u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">506 - 12, 580 - 09% - 05.5   - 3 +<u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">507 - 45, 890 - 38% - 18.0   - 12 ++<u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">508 - 18, 183 - 15% - 01.5  -  5 -<u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText"><u></u> <u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">Nick <u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText"><u></u> <u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">Nicholas Thompson<u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">Emeritus Professor of Ethology and Psychology<u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">Clark University<u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText"><a href="mailto:ThompNickSon2@gmail.com" target="_blank">ThompNickSon2@gmail.com</a><u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText"><a href="https://wordpress.clarku.edu/nthompson/" target="_blank">https://wordpress.clarku.edu/nthompson/</a><u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText"> <u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText"><u></u> <u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText"><u></u> <u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">-----Original Message-----<br>From: Friam <<a href="mailto:friam-bounces@redfish.com" target="_blank">friam-bounces@redfish.com</a>> On Behalf Of u?l? ???<br>Sent: Monday, November 2, 2020 12:08 PM<br>To: FriAM <<a href="mailto:friam@redfish.com" target="_blank">friam@redfish.com</a>><br>Subject: Re: [FRIAM] numbers</p><p class="gmail-m_-5063292500720025874MsoPlainText"><u></u> <u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">And if you don't want to download a huge file, you can use the census web app:<u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText"><u></u> <u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">E.g. for my zip code (98502):<u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText"><u></u> <u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText"><a href="https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/PUMA_TAD_TAZ_UGA_ZCTA/MapServer/7/query?where=ZCTA5%3D%2798502%27&text=&objectIds=&time=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelIntersects&relationParam=&outFields=*&returnGeometry=false&returnTrueCurves=false&maxAllowableOffset=&geometryPrecision=&outSR=&returnIdsOnly=false&returnCountOnly=false&orderByFields=&groupByFieldsForStatistics=&outStatistics=&returnZ=false&returnM=false&gdbVersion=&returnDistinctValues=false&resultOffset=&resultRecordCount=&queryByDistance=&returnExtentsOnly=false&datumTransformation=&parameterValues=&rangeValues=&f=html" target="_blank"><span style="color:windowtext;text-decoration:none">https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/PUMA_TAD_TAZ_UGA_ZCTA/MapServer/7/query?where=ZCTA5%3D%2798502%27&text=&objectIds=&time=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelIntersects&relationParam=&outFields=*&returnGeometry=false&returnTrueCurves=false&maxAllowableOffset=&geometryPrecision=&outSR=&returnIdsOnly=false&returnCountOnly=false&orderByFields=&groupByFieldsForStatistics=&outStatistics=&returnZ=false&returnM=false&gdbVersion=&returnDistinctValues=false&resultOffset=&resultRecordCount=&queryByDistance=&returnExtentsOnly=false&datumTransformation=&parameterValues=&rangeValues=&f=html</span></a><u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText"><u></u> <u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">I'd say this is an excellent example of government transparency.<u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText"><u></u> <u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">On 11/2/20 9:08 AM, Barry MacKichan wrote:<u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">> One of the first search hits is <u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">> <a href="https://www.kaggle.com/census/us-population-by-zip-code" target="_blank"><span style="color:windowtext;text-decoration:none">https://www.kaggle.com/census/us-population-by-zip-code</span></a> <u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">> <<a href="https://www.kaggle.com/census/us-population-by-zip-code" target="_blank"><span style="color:windowtext;text-decoration:none">https://www.kaggle.com/census/us-population-by-zip-code</span></a>><u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">> —Barry<u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">> <u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">> On 2 Nov 2020, at 11:59, <a href="mailto:thompnickson2@gmail.com" target="_blank"><span style="color:windowtext;text-decoration:none">thompnickson2@gmail.com</span></a> wrote:<u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">> <u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">>     Is it possible to get population by zipcode?  It seems like it’s <u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">> proprietary info.<u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">> <u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">>      <u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">> <u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">>     How’s that for government transparency!<u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText"><u></u> <u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">--<u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">↙↙↙ uǝlƃ<u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText"><u></u> <u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">- .... . -..-. . -. -.. -..-. .. ... -..-. .... . .-. .<u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">FRIAM Applied Complexity Group listserv<u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">Zoom Fridays 9:30a-12p Mtn GMT-6  <a href="http://bit.ly/virtualfriam" target="_blank">bit.ly/virtualfriam</a> un/subscribe <a href="http://redfish.com/mailman/listinfo/friam_redfish.com" target="_blank"><span style="color:windowtext;text-decoration:none">http://redfish.com/mailman/listinfo/friam_redfish.com</span></a><u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">archives: <a href="http://friam.471366.n2.nabble.com/" target="_blank"><span style="color:windowtext;text-decoration:none">http://friam.471366.n2.nabble.com/</span></a><u></u><u></u></p><p class="gmail-m_-5063292500720025874MsoPlainText">FRIAM-COMIC <a href="http://friam-comic.blogspot.com/" target="_blank"><span style="color:windowtext;text-decoration:none">http://friam-comic.blogspot.com/</span></a> <u></u><u></u></p></div></div>- .... . -..-. . -. -.. -..-. .. ... -..-. .... . .-. .<br>
FRIAM Applied Complexity Group listserv<br>
Zoom Fridays 9:30a-12p Mtn GMT-6  <a href="http://bit.ly/virtualfriam" rel="noreferrer" target="_blank">bit.ly/virtualfriam</a><br>
un/subscribe <a href="http://redfish.com/mailman/listinfo/friam_redfish.com" rel="noreferrer" target="_blank">http://redfish.com/mailman/listinfo/friam_redfish.com</a><br>
archives: <a href="http://friam.471366.n2.nabble.com/" rel="noreferrer" target="_blank">http://friam.471366.n2.nabble.com/</a><br>
FRIAM-COMIC <a href="http://friam-comic.blogspot.com/" rel="noreferrer" target="_blank">http://friam-comic.blogspot.com/</a> <br>
</blockquote></div><div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br>
<table style="border-top:1px solid #d3d4de">
        <tr>
        <td style="width:55px;padding-top:13px"><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif" alt="" width="46" height="29" style="width: 46px; height: 29px;"></a></td>
                <td style="width:470px;padding-top:12px;color:#41424e;font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">Virus-free. <a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link" target="_blank" style="color:#4453ea">www.avast.com</a>
                </td>
        </tr>
</table><a href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"></a></div>