# Data Providing

**URL:** <https://community.glideapps.com/t/data-providing/32405>\
**Category:** Ask for Help\
**Created:** [September 28, 2021, 8:15am UTC](https://community.glideapps.com/t/data-providing/32405 "2021-09-28T08:15:05Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [September 29, 2021, 9:04am UTC](https://community.glideapps.com/t/data-providing/32405/6 "2021-09-29T09:04:25Z")

</div>

Hi @Science_HotSpot

You can use an experimental column to create a fetch column or JSON transformation column.

If you find a public api with the covid-related data you are looking for, it might work. Careful: not all open api’s will work. There is a comment about this in the link below.

More here:

> [@Fetch Column](https://community.glideapps.com/t/fetch-column/31731):
>
> Glide Fetch Column column.sh/fetch is an experimental code column that fetches JSON data from a public API and transforms it with an optional [jq query](https://stedolan.github.io/jq/tutorial/). Example: Fetch a Cat Fact Add column at https://column.sh/fetch Set URL to https://cat-fact.herokuapp.com/facts to fetch cat facts. Set query to .[0].text to get the text of the first fact. [image] Development [View on GitHub](https://github.com/glideapps/glide-code-columns)

---

_[View the full topic](https://community.glideapps.com/t/data-providing/32405)._