Re: COVID-19 Tracker (based on John Hopkins CSSE)
Posted: 28 Mar 2020 17:14
I just discover some flaw in the url link to query the json. The url used to be fine as the provinces/states is less than 250. Now we have more 306 provinces already, so the url used above will trimmed out the last 56 results, giving wrong total. The overall number still close to the real number, but I don't want to show wrong result. Anyone who still use this flow, show change the url to
The difference is only the Record count 250 changed to 1000.
My v2 flow still have some problem on the flipped calculation (between Death and Recovery number). This is bad, as I will scare people out there with flipped number. Gotta change and review everything again from beginning.
Code: Select all
url = "https://services1.arcgis.com/0MSEUqKaxRlEPj5g/arcgis/rest/services/ncov_cases/FeatureServer/1/query?f=json&where=Confirmed%20%3E%200&returnGeometry=false&spatialRel=esriSpatialRelIntersects&outFields=*&orderByFields=Confirmed%20desc%2CCountry_Region%20asc%2CProvince_State%20asc&resultOffset=0&resultRecordCount=1000&cacheHint=true"
My v2 flow still have some problem on the flipped calculation (between Death and Recovery number). This is bad, as I will scare people out there with flipped number. Gotta change and review everything again from beginning.