This is wonderful! Thanks for sharing it!

On Jan 23, 2020, at 8:23 AM, Alex Karner <> wrote:

Everyone should check out Kyle Walker's tidycensus package for R. It's a wrapper for the various census APIs and makes downloading/importing/mapping/visualizing a breeze:

I no longer access census data using any other method.

On Thu, Jan 23, 2020 at 10:04 AM Jami Dennis <> wrote:
Totally agree!   I ended up downloading the summary files and importing them into ms sql databases. Then just query what i want from there. If anyone wants those i have the files exported by state so should be easily imported into SQL. You will need to know sql and understand the summary file and geography relationships but it isnt too difficult and i can provide sample queries if needed. 


Jami Dennis
Geodetic Analysis, llc

On Jan 23, 2020, at 7:54 AM, Vince Post <> wrote:



Truer words have not been spoken.




Vincent Post, III

Transportation/GIS Specialist

Mid-Ohio Valley Regional Council

Wood-Washington-Wirt Interstate Planning Commission

709 Market Street

P.O. Box 247

Parkersburg, WV 26101


Phone: 304.422.4993 ext. 106

Fax: 304.422.4998


From: Alan Pisarski []
Sent: Thursday, January 23, 2020 10:48 AM
Subject: [CTPP] Re: Troubles with


Hard to believe they could have produced something worse than FactFinder.  I could never imagine missing it.  Alan E Pisarski



Alan E. Pisarski Consultancy

Landline 703 941-4257

Cell          703 650-8925




From: Catala, Martin <>
Sent: Thursday, January 23, 2020 8:29 AM
Subject: [CTPP] Re: Troubles with




From: Bob Schwartz <>
Sent: Thursday, January 23, 2020 7:12:23 AM
To: <>; <>
Subject: [CTPP] Re: Troubles with


This email originated from outside of USF. Do not click links or open attachments unless you recognize the sender or understand the content is safe.


I agree with Jonathan. I HATE Bring back American FactFinder.


From: jonathan lupton []
Sent: Wednesday, January 22, 2020 4:22 PM
Subject: [CTPP] Troubles with


Am I the only user having chronic problems with


After nearly a year of constant attempts at use and self-training, my personal experience is that is capricious, inconsistent, and inadequate. The potential is (probably) there but to my view it’s not yet ready for prime time – yet it is the only way you can access the 2018 ACS. American Factfinder is going away in a matter of months, so soon the shaky and unstable system will be all that we have.


Perhaps there’s some magic bullet I have yet to find. Or an alternative that provides the professional reliability the data community needs. API?


Can anybody in the data community offer insights?




Jonathan Lupton AICP

Senior Planner – Publications


Little Rock AR

ctpp-news mailing list --
To unsubscribe send an email to
ctpp-news mailing list --
To unsubscribe send an email to
ctpp-news mailing list --
To unsubscribe send an email to