<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
</head>
<body>
<div name="messageBodySection">Thanks. Then the issue is how to get it since the 2015 Lookup trick won't work.</div>
<div name="messageSignatureSection"><br />
Thanks,<br />
<br />
Jon<br />
<br />
--<br />
Jonathan Zadra, PhD<br />
Data Scientist<br />
Sorenson Impact Center<br />
David Eccles School of Business, University of Utah<br />
(801) 581-4815<br />
jon.zadra@sorensonimpact.com<br />
www.sorensonimpact.com</div>
<div name="messageReplySection"><br />
On Apr 9, 2018, 06:54 -0600, Meagan Pharis <mpharis@pewtrusts.org>, wrote:<br />
<blockquote type="cite">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Hi Jon,</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">You can do searches using that, and any, table name at factfinder.census.gov. You can see from the picture of the search results below, that the table you’re looking for is only available in 5-year form for the 2016 5-year estimates.</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Best of luck,</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span></p>
<p class="MsoNormal"><img width="1558" height="905" id="Picture_x0020_1" src="cid:image001.png@01D3CFE0.68F5F5D0" /><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span></p>
<div>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Century Gothic","sans-serif";color:#205689">Meagan Pharis</span></b></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Century Gothic","sans-serif";color:#205689">The Pew Charitable Trusts</span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Century Gothic","sans-serif";color:#205689">p: <a dir="ltr" href="tel:215-575-4773" x-apple-data-detectors="true" x-apple-data-detectors-type="telephone" x-apple-data-detectors-result="2">215-575-4773</a> | e:</span> <span style="font-size:8.0pt;font-family:"Century Gothic","sans-serif";color:#1F497D"><a href="mailto:mpharis@pewtrusts.org"><span style="color:blue">mpharis@pewtrusts.org</span></a></span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"></span></p>
</div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b> <span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">acs-r-bounces@mit.edu [mailto:acs-r-bounces@mit.edu] <b>On Behalf Of</b> Jon Zadra<br />
<b>Sent:</b> Sunday, April 08, 2018 12:40 PM<br />
<b>To:</b> acs-r@mit.edu<br />
<b>Subject:</b> [acs-r] Trick to get 2016 data failing for C16001</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<div name="messageBodySection">
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial","sans-serif"">HI,</span></p>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial","sans-serif""> </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial","sans-serif"">I’ve been using the lookup 2015 then fetch 2016 trick without issue for many tables, however today I ran into an issue with table C16001 where it can’t find it in the 2016 lookup:</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial","sans-serif""> </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial","sans-serif"">a <- acs.lookup(table.number = "C16001", endyear = 2015, span = 5) </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial","sans-serif"">Warning message: In acs.lookup(table.number = "C16001", endyear = 2015, span = 5) : Sorry, no tables/keyword meets your search. Suggestions: try with 'case.sensitive=F', remove search terms, change 'keyword' to 'table.name' in search (or vice-versa</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial","sans-serif""> </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial","sans-serif"">I’m not sure if this is because they didn’t have C16001 in 2015 and it’s a new addition for 2016, or whether they don’t have the C version via the API (the B version exists).</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial","sans-serif""> </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial","sans-serif"">I really need the C version, as the B version has a lot of suppression due to about 20 more categories.  Any help is appreciated!</span></p>
</div>
</div>
<div name="messageSignatureSection">
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial","sans-serif""><br />
Thanks,<br />
<br />
Jon<br />
<br />
--<br />
Jonathan Zadra, PhD<br />
Data Scientist<br />
Sorenson Impact Center<br />
David Eccles School of Business, University of Utah<br />
<a dir="ltr" href="tel:(801)%20581-4815" x-apple-data-detectors="true" x-apple-data-detectors-type="telephone" x-apple-data-detectors-result="7/0">(801) 581-4815</a><br />
<a href="mailto:jon.zadra@sorensonimpact.com">jon.zadra@sorensonimpact.com</a><br />
<a href="http://www.sorensonimpact.com">www.sorensonimpact.com</a></span></p>
</div>
<div name="messageReplySection">
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial","sans-serif""> </span></p>
</div>
<p class="MsoNormal"><br />
<img border="0" id="_x0000_i1025" src="https://s30.postimg.org/wymgl6v5d/email_signature_final_01.png" /></p>
</div>
</blockquote>
</div>
</body>
</html>
<br>
<img src="https://s30.postimg.org/wymgl6v5d/email_signature_final_01.png">