Easily Connect to Government Data with the Socrata Web Data Connector for Tableau


Easily Connect to Government Data with the Socrata Web Data Connector for Tableau

Do you want an easy way to compare NASA’s meteorite tracking data with your own UFO sighting adventures? Maybe you would like to combine food service inspection violations for restaurants in your area with your credit card statements, instead. The good news is that it’s now easier to connect to governmental data in Tableau and use it alongside your existing data sources.

InterWorks has created a Tableau Web Data Connector (WDC) for Socrata. You can use it to connect to your own Socrata site, or sources you happen upon at OpenDataNetwork.com.

How to Use the Socrata WDC

To get to the desired Socrata data, simply add a new data source in Tableau Desktop versions 10 and up. Beneath the To a server section, select Web Data Connector.

In the URL bar of the WDC, type https://wdc.interworks.com/.  Among others, you should notice a button for Socrata. Don’t be afraid. Click that button.

Socrata Web Data Connector for Tableau

At this point, you will be able to enter the Socrata site, dataset ID and optional filter conditions. If you’re looking at a data source on OpenDataNetwork.com, you can copy and paste the site and dataset ID from the URL bar of your browser. For the example case of the NASA meteorite landing data, they will be data.nasa.gov and gh4g-9sfh, respectively.

Meteorite Data

Filtering the data using a where clause will depend a great deal on the data set you’re using. The good news is that once you enter the site and dataset ID, you’ll be presented with a listing of columns available in that dataset as a guide. The WDC will pass along filter conditions to the data set (e.g. restaurant_rating = ‘Failed’) to really narrow down to the stuff that interests you. 

If you need further assistance writing where clauses, you don’t have to wake up your favorite search engine – there’s a link to the documentation in the How to use box at the top of the screen (gently tap the + button to expand). When in doubt, just leave it blank and do your filtering in Tableau.

When you’ve had all of the fun you can with the form, just click on the Get Data button and visualize the data to your heart’s content. And if you’re feeling a little frisky, try connecting to more than one Socrata data source in your project to really spice things up.

More About the Author

Matthew Orr

Curator Architect
Git Nested Branching with Squash Bird nests? Tree limbs? Summer squash? There sure are a lot of plant, animal and food terms in that title. What are we talking about ...
Get to Know pdb, the Python Debugger While my day-to-day is spent working within Curator’s PHP platform, my favorite programming language is Python. I used it daily in a ...

See more from this author →

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK


Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072


Love our blog? You should see our emails. Sign up for our newsletter!