Created a JSON-based API. #8
Comments
This is super helpful and works swimmingly. Thanks! |
Thank you! I start to use it on my site. |
Glad to hear you're using it! @altezza04 . Feel free to share your site :)! I'd love to see it. |
WIP - Power BI |
@ExpDev07 possible to return the date fields unpivoted ? grate job btw :) |
|
@3verse nice viz :), yea did the google sheet first.. hope this will be stable. |
http://chinavirus.live/ |
FYI added Deaths and Recovered, with Measure select option. |
Looks to be broken now. |
@chovy it broke when they re-formatted the repo, I've fixed it to point to the correct paths now and it's working again. |
awesome. thank you sir. |
FYI |
I made a website too with latest tweets, timeline and charts regarding the virus https://the2019ncov.com |
I parse your API endpoint, massage it and throw it in an influxDB. At the same time I build a unique list of locations to feed the Grafana WorldMap plugin served via Flask. Here is a first draft of the Grafana dashboard. I plan to work a bit more around my code and share dashboard, parser and Flask server code. |
@leopoul Grafana and InfluxDB, I love it. Nice work! |
Cool, how did you get the data into influxDB? |
I noticed a map that has quanrtined data. Can we add that? |
@chovy ill see what I can do!:) |
Code is here: https://github.com/leopoul/covid19_grafana . It's a quick and dirty release so feel free to contribute. I transform the data to get it into Influx and extract the unique locations to make it work with the Grafana plugin. I wanted to have something quickly out so there is lots of room for improvement. |
Great work! Is there a possibility to filter by country in the request? |
Please head over to https://github.com/ExpDev07/coronavirus-tracker-api for any questions/discussions regarding the API. :)! |
Oh nice work! I did similar thing : )! |
Hello, this API is never up to date and not in sync with the daily reports |
Hello @mauro-gobbi. It caches the daily reports for 1 hourr. So at most, it takes 1 hour for it to show the changes after an update. This is to allow for faster results and avoid having to make calls to GitHub per request. If you fork the API, you can change the cache duration to 30 minutes, or completely remove it if you wish. It's as simply as just changing a variable. Feel also free to open an issue or pull request if you believe it should be lowered. I haven't had any complaints besides yours, so most seem OK with the delay. |
Hi, thanks a lot for your reply and thanks for making this API available. 😊 |
Yes, you are correct in that. So whenever JSU updates their time series, it takes a maximum of 1 hour and a minimum of 0 seconds for it to reflect in the API (which is why the data may differ). If you're talking about live updates, that's not really a thing. Most sources will give you daily updates. |
Ok great, fair enough. Live updates are not possible for sure, I hope they will start to upload a new .csv report at least every 12h. Thanks again 👍 @ExpDevv07 also, it's quite weird, that this branch https://github.com/CSSEGISandData/COVID-19/tree/web-data mentions a crawler to worldometers.info and bnonews.com. I thought those two websites used to get data from the JHU dashboard, not the opposite (they are fully synchronized indeed). |
Hello everyone, I maid an android app calling @ExpDev07 Rest API, check the repo. https://github.com/Omaroid/Covid-19-Android |
@ExpDev07 thanks for the great work. could you please explain on how to get confirmed cases for example for one single country. how the GET url will look like. Thanks a lot. |
api missing data again. |
@ExpDev07 Your API works great. I have one hosted locally since I’m developing my own coronavirus dashboard. Sorry if off topic but typically how often do the numbers presented update? Thank you. |
@bjarkimg : I'm new to Power BI, and would like to use the data in this Repo. The problem is I don't know how to connect said data in Power BI. |
@roenw Updates whenever this repo updates (with a delay of max an hour for cache to reload) :). |
Thanks @ExpDev07! |
Hi, bjarkimg Could you share your pbix file. I would like to learn how you do this amazing dashboards |
Hi bjarkimg |
@ExpDev07 Thank You! |
Are individual US states data no longer coming through in recoveries and deaths? |
@itsgorain JHU has dropped tracking of recoveries completely, for confirmed and deaths, they have decided to do U.S.A as a whole instead of individual states. These changes obviously are reflected in the API. |
I'm a beginer here and wanted to store how we can store this data in Google cloud storage first (Using the API). Would be helpful if anyone can help me with the exact steps. Also, any resources for data related to user sentiments like shopping behavior, spending etc. Much thanks in advance. |
@ajmishra1989 I'm guessing you'd have to write a script to periodically retrieve the data you want and push it to Google Cloud Storage. |
OK, Thanks. Any possible workaround my second question? I'm looking for place to fetch data for user sentiments around Covid-19. Thanks. |
I believe there’s some scrapers out there that offers a news feed etc, google around “Covid19 news scraper github” @ajmishra1989 |
Good bye recovered data. |
They added the recovered data ! |
Hi, Create a variable all the columns (by excluding the one who are not part of the unpivot) ColsUnPivot = List.Skip(Cols,9), Unpivot the columns: Source = Json.Document(Web.Contents("https://coronavirus-tracker-api.herokuapp.com/all")), |
Hi @ExpDev07 , |
Hey All, I am trying to set up a Power BI map for US Counties, but literally have no clue what I am doing. Can anyone give me a quick tutorial to connect this? I was able to get a Shape Map with US Counties, but how to connect the confirmed coronavirus cases to it?? |
@ExpDev07 Is there any way to update the json files same as the worldometer. I checked the json https://coronavirus-tracker-api.herokuapp.com/confirmed but it's a bit delayed compared to worldometer. |
@ExpDev07 appreciate this but it doesn't look like there is a report available for the 8th yet, however the api is reporting the last updated date on the figures provided as the 8th? Surely it should be reporting these with the last updated date set to the 7th as this is when the figures are from? |
The endpoint https://coronavirus-tracker-api.herokuapp.com/all seems to be down at the moment (Status 503 Service Unavailable) |
Hello! We are also providing JSON query of the feature layer, such as this one. Thanks! |
Is the API still maintained? |
Nope, looks dead. I am using a csv based daily data https://github.com/bumbeishvili/covid19-daily-data Using it here https://github.com/wobsoriano/covid3d |
Hello and thank you so much for maintaining this! I have created an API that reads your data and returns it in a way that's more friendly to use in programs. It also supports history. It's still a W.I.P and I would love contributions! It is open-sourced here: https://github.com/ExpDev07/coronavirus-tracker-api. Feel free to use it in your projects!
It is very fast due to caching.
The current endpoints are (more will be added):
https://coronavirus-tracker-api.herokuapp.com/confirmed
https://coronavirus-tracker-api.herokuapp.com/deaths
https://coronavirus-tracker-api.herokuapp.com/recovered
For all of them combined:
https://coronavirus-tracker-api.herokuapp.com/all
The text was updated successfully, but these errors were encountered: