Use Ziptastic API to Forward Geocode a Zip Code into Locale Information

County Is the Unit of Healthcare Market Analysis

Negotiated rates vary by geography, and the geography that matters is usually the county or metro area rather than the zip code. Medicare payment localities are geographic, market share is measured by county, and network filings are county-based. Source data, meanwhile, almost always arrives with a zip code and nothing else.

Where this comes up:

• Rate rollups: Aggregate zip-level rate data to county so benchmarks compare like with like.
• Medicare alignment: Map providers to the localities Medicare uses to set payment.
• Market share: Build county-level views of provider or payer concentration.

If you need the crosswalk as a file rather than an API call, see the zip code to county spreadsheet.

The Ziptastic Forward Geocoding API provides an endpoint that returns the City, State, Country and other locale information of a zip code you supply, also known as Forward Geocoding. This frictionless access to accurate geographic data allows you to bring more understanding to your enriched data in Gigasheet. 

‍

‍Provider Website: https://www.getziptastic.com/
Provider Enrichment Docs: https://www.getziptastic.com/documentation
Endpoint: curl https://zip.getziptastic.com/v3/US/48867 -H "x-key: 123examplekey456"
Token / Registration Required: Yes

‍

How To Enrich A Spreadsheet With Ziptastic:

For this example, our data looks like this. It is a list of restaurant locations with only Zip and Phone number.

‍

‍

Step 1. In Gigasheet, head to the Enrichments function and select Custom Enrichment. First we paste in the cURL request from Ziptastic.

‍

Step 2. On the next screen we’ll insert the column variable from our Gigasheet sheet for the prompt. In this case, we highlight the zip code, “48867”, in the input, and then select our Location column and click +Insert Column Reference. We also need to highlight the “123examplekey456” and paste our API key from Ziptastic. Then click Next.

‍

‍

Step 3. In this screen we see a preview of the results. Gigasheet makes requests for the first three rows and shows the Ziptastic API response. At this point select the fields you want to be inserted into your sheet. We recommend hitting Select All since you can easily delete columns in Gigasheet.

‍

Step 4. Finally, confirm the number of requests is to your liking, and when ready click Run to kickoff the custom enrichment process. It’s ok to leave or close the sheet; the custom enrichment will keep running and you’ll receive an email once the job has been completed. You can monitor the progress of your enrichment, or cancel the job at the top of the sheet. 

‍

Step 5. Once completed, Gigasheet will send a completion toast and refresh the page. The result will show generation of new columns based on the Ziptastic API for Forward Geocoding. Ziptastic has added the City, County, State, Country and other locale information data for each zip code of interest. 

‍