Coronavirus (COVID 19)

102

A little info on what it is like here in Australia:

We have been very lucky so far and the deaths (63) whilst sad are very low and new cases are falling. The changes to our lives are big and I would call it a semi lockdown that are said to be in place for a month longer before things will slowly get lifted if things keep going the way they are. I am still going to work each day and am lucky to have a very stable job in uncertain times. Many people have lost jobs and it is illegal to kick people out of a house if they can not pay rent. Shopping for food is crazy as you get people pushing past you in a rush to get out of the shop when we follow a 1.5 meter distance rule here. 90% of people do the right thing.

We had bush fires only a few months ago and this ruined a lot of the wine grapes as they get smoke flavours that are not nice, so these are now getting brewed and turned into hand sanitizer by small batch whiskey and gin distillers.

It will be much higher in your country as it appears that >50% of people appear to get the virus and not show any symptoms. Usually the people who don’t get symptoms, don’t get tested and hence get missed from the stats.

Prelim results of a German study can be heard about here. Similar studies are taking place in at least 2 other countries.

103

The Heinsberg study (which you are referring to) is under heavy criticism. Heinsberg has (on average) a much younger population than Germany in total (-10% for age 65+) and the study does not reveal if the selected group is representative. Additionally the test used is questioned by other scientists because it also shows positive results on non-SARS-CoV-2 corona viruses which are responsible for 30% of flu-like diseases.

Also the study (or at least the result published up to today) does not meet scientific criteria (absolute numbers missing, questionable wording).

1 Like
104

Thanks for the extra info especially the reason why the tests used in that study are not reliable, sadly that will be the case for most if not all data getting released as resources of all types are stretched.

USA aircraft carrier has started doing antigen and antibody tests which Is in the news today.

UK study also had the issue of antibody tests not being reliable enough.

EDIT:
New data from New York maternity ward which was based on PCR antigen tests.

105

I hope you all continue to do alright. Our state is slowly moving toward reopening. Life is still very strange here.

106

I am from South Africa. we have moved down to level 4 . 2 weeks ago. currently they are investigating to move some of the provinces to lvl 3 and some not. as in some we are actually experiencing a increase of infections.

Stay safe OpenHAB Friends .

107

Can someone anyone tell why this isnt working?

http.cfg

covid_Florida.url=https://corona-stats.online/states/US?format=json
covid_Florida.updateInterval=900000

http.items

Number      FL_Corona_Confirmed     "Florida Covid 19 confirmed [%d]" <corona> (CoronaUS_FL) {http="<[covid_Florida:5000:JSONPATH($.[?(@.state=='Florida')].cases)]"}
Number      FL_Corona_Confirmed_Today     "Florida Covid 19 confirmed Today [%d]" <corona> (CoronaUS_FL) {http="<[covid_Florida:5000:JSONPATH($.[?(@.state=='Florida')].todayCases)]"}
Number      FL_Corona_Deaths     "Florida Covid 19 Deaths [%d]" <corona> (CoronaUS_FL) {http="<[covid_Florida:5000:JSONPATH($.[?(@.state=='Florida')].deaths)]"}
Number      FL_Corona_Deaths_Today     "Florida Covid 19 Deaths Today [%d]" <corona> (CoronaUS_FL) {http="<[covid_Florida:5000:JSONPATH($.[?(@.state=='Florida')].todayDeaths)]"}
Number      FL_Corona_Active     "Florida Covid 19 Active [%d]" <corona> (CoronaUS_FL) {http="<[covid_Florida:5000:JSONPATH($.[?(@.state=='Florida')].active)]"}
Number      FL_Corona_Cases_Per_Million     "Florida Covid 19 Cases Per Million [%d]" <corona> (CoronaUS_FL) {http="<[covid_Florida:5000:JSONPATH($.[?(@.state=='Florida')].casesPerOneMillion)]"}
Number      FL_Corona_Deaths_Per_Million     "Florida Covid 19 Deaths Per Million [%d]" <corona> (CoronaUS_FL) {http="<[covid_Florida:5000:JSONPATH($.[?(@.state=='Florida')].deathsPerOneMillion)]"}
Number      FL_Corona_Tests     "Florida Covid 19 Tests [%d]" <corona> (CoronaUS_FL) {http="<[covid_Florida:5000:JSONPATH($.[?(@.state=='Florida')].tests)]"}
Number      FL_Corona_Tests_Per_Million     "Florida Covid 19 Tests Per Million [%d]" <corona> (CoronaUS_FL) {http="<[covid_Florida:5000:JSONPATH($.[?(@.state=='Florida')].testsPerOneMillion)]"}

I used this site to check my JSON parameter and it appears to be working as I am expecting except the values remain Null and never update.

image
image1272×729 41.7 KB

Using the data from here https://corona-stats.online/states/US?format=json as input.

On a side note, I am also using the Word data using this just below and that is working properly so I know everything is installed correctly.

Part that does work.

.cfg
covid_US.url=https://corona-stats.online/US?format=json
covid_US.updateInterval=900000

.items
Number	COVID19_WORLD_Confirmed    "Confirmed [%,d]"    <corona>         (Corona)   {http="<[covid_world:5000:JSONPATH($.worldStats..cases)]"}
Number	COVID19_WORLD_Deaths       "Deaths [%,d]"       <death>          (Corona)   {http="<[covid_world:5000:JSONPATH($.worldStats..deaths)]"}
Number	COVID19_WORLD_Recovered    "Recovered [%,d]"    <recovered>      (Corona)   {http="<[covid_world:5000:JSONPATH($.worldStats..recovered)]"}
Number	COVID19_WORLD_Active       "Active [%,d]"       <active>         (Corona)   {http="<[covid_world:5000:JSONPATH($.worldStats..active)]"}
Number	COVID19_WORLD_Critical     "Critical [%,d]"     <critical>       (Corona)   {http="<[covid_world:5000:JSONPATH($.worldStats..critical)]"}
108

ok figured it out. I needed to add “data”. I went from this

Number      FL_Corona_Confirmed     "Florida Covid 19 confirmed [%d]" <corona> (CoronaUS_FL) {http="<[covid_Florida:5000:JSONPATH($.[?(@.state=='Florida')].cases)]"}

to this


Number      FL_Corona_Confirmed     "Florida Covid 19 confirmed [%d]" <corona> (CoronaUS_FL) {http="<[covid_Florida:5000:JSONPATH($.[?(@.data.state=='Florida')].cases)]"}

and now it is working.

In case anyone wants a fully functioning example including your state you can use this below. I used Florida but you can change it to your US state. I noticed in the example above some of the countries are upper case in the items file but lower case in the cfg causing it not to work so I just fixed it here.

http.cfg

covid_world.url=https://corona-stats.online/?format=json
covid_world.updateInterval=900000
covid_DE.url=https://corona-stats.online/DE?format=json
covid_DE.updateInterval=900000
covid_IT.url=https://corona-stats.online/IT?format=json
covid_IT.updateInterval=900000
covid_SP.url=https://corona-stats.online/SP?format=json
covid_SP.updateInterval=900000
covid_FR.url=https://corona-stats.online/FR?format=json
covid_FR.updateInterval=900000
covid_LU.url=https://corona-stats.online/LU?format=json
covid_LU.updateInterval=900000
covid_NL.url=https://corona-stats.online/NL?format=json
covid_NL.updateInterval=900000
covid_BE.url=https://corona-stats.online/BE?format=json
covid_BE.updateInterval=900000
covid_GB.url=https://corona-stats.online/GB?format=json
covid_GB.updateInterval=900000
covid_RO.url=https://corona-stats.online/RO?format=json
covid_RO.updateInterval=900000
covid_US.url=https://corona-stats.online/US?format=json
covid_US.updateInterval=900000
covid_Florida.url=https://corona-stats.online/states/US?format=json
covid_Florida.updateInterval=900000

http.items

Group Corona
Group CoronaDE
Group CoronaIT
Group CoronaSP
Group CoronaFR
Group CoronaLU
Group CoronaNL
Group CoronaBE
Group CoronaGB
Group CoronaRO
Group CoronaUS
Group CoronaUS_FL


Number	COVID19_WORLD_Confirmed    "Confirmed [%,d]"    <corona>         (Corona)   {http="<[covid_world:5000:JSONPATH($.worldStats..cases)]"}
Number	COVID19_WORLD_Deaths       "Deaths [%,d]"       <death>          (Corona)   {http="<[covid_world:5000:JSONPATH($.worldStats..deaths)]"}
Number	COVID19_WORLD_Recovered    "Recovered [%,d]"    <recovered>      (Corona)   {http="<[covid_world:5000:JSONPATH($.worldStats..recovered)]"}
Number	COVID19_WORLD_Active       "Active [%,d]"       <active>         (Corona)   {http="<[covid_world:5000:JSONPATH($.worldStats..active)]"}
Number	COVID19_WORLD_Critical     "Critical [%,d]"     <critical>       (Corona)   {http="<[covid_world:5000:JSONPATH($.worldStats..critical)]"}

Number	COVID19_DE_Confirmed    "Confirmed [%,d]"    <corona>            (CoronaDE)   {http="<[covid_DE:5000:JSONPATH($.data..cases)]"}
Number	COVID19_DE_Deaths       "Deaths [%,d]"       <death>             (CoronaDE)   {http="<[covid_DE:5000:JSONPATH($.data..deaths)]"}
Number	COVID19_DE_Recovered    "Recovered [%,d]"    <recovered>         (CoronaDE)   {http="<[covid_DE:5000:JSONPATH($.data..recovered)]"}
Number	COVID19_DE_Active       "Active [%,d]"       <active>            (CoronaDE)   {http="<[covid_DE:5000:JSONPATH($.data..active)]"}
Number	COVID19_DE_Critical     "Critical [%,d]"     <critical>          (CoronaDE)   {http="<[covid_DE:5000:JSONPATH($.data..critical)]"}

Number	COVID19_IT_Confirmed    "Confirmed [%,d]"    <corona>            (CoronaIT)   {http="<[covid_IT:5000:JSONPATH($.data..cases)]"}
Number	COVID19_IT_Deaths       "Deaths [%,d]"       <death>             (CoronaIT)   {http="<[covid_IT:5000:JSONPATH($.data..deaths)]"}
Number	COVID19_IT_Recovered    "Recovered [%,d]"    <recovered>         (CoronaIT)   {http="<[covid_IT:5000:JSONPATH($.data..recovered)]"}
Number	COVID19_IT_Active       "Active [%,d]"       <active>            (CoronaIT)   {http="<[covid_IT:5000:JSONPATH($.data..active)]"}
Number	COVID19_IT_Critical     "Critical [%,d]"     <critical>          (CoronaIT)   {http="<[covid_IT:5000:JSONPATH($.data..critical)]"}

Number	COVID19_SP_Confirmed    "Confirmed [%,d]"    <corona>            (CoronaSP)   {http="<[covid_SP:5000:JSONPATH($.data..cases)]"}
Number	COVID19_SP_Deaths       "Deaths [%,d]"       <death>             (CoronaSP)   {http="<[covid_SP:5000:JSONPATH($.data..deaths)]"}
Number	COVID19_SP_Recovered    "Recovered [%,d]"    <recovered>         (CoronaSP)   {http="<[covid_SP:5000:JSONPATH($.data..recovered)]"}
Number	COVID19_SP_Active       "Active [%,d]"       <active>            (CoronaSP)   {http="<[covid_SP:5000:JSONPATH($.data..active)]"}
Number	COVID19_SP_Critical     "Critical [%,d]"     <critical>          (CoronaSP)   {http="<[covid_SP:5000:JSONPATH($.data..critical)]"}

Number	COVID19_FR_Confirmed    "Confirmed [%,d]"    <corona>            (CoronaFR)   {http="<[covid_FR:5000:JSONPATH($.data..cases)]"}
Number	COVID19_FR_Deaths       "Deaths [%,d]"       <death>             (CoronaFR)   {http="<[covid_FR:5000:JSONPATH($.data..deaths)]"}
Number	COVID19_FR_Recovered    "Recovered [%,d]"    <recovered>         (CoronaFR)   {http="<[covid_FR:5000:JSONPATH($.data..recovered)]"}
Number	COVID19_FR_Active       "Active [%,d]"       <active>            (CoronaFR)   {http="<[covid_FR:5000:JSONPATH($.data..active)]"}
Number	COVID19_FR_Critical     "Critical [%,d]"     <critical>          (CoronaFR)   {http="<[covid_FR:5000:JSONPATH($.data..critical)]"}

Number	COVID19_LU_Confirmed    "Confirmed [%,d]"    <corona>            (CoronaLU)   {http="<[covid_LU:5000:JSONPATH($.data..cases)]"}
Number	COVID19_LU_Deaths       "Deaths [%,d]"       <death>             (CoronaLU)   {http="<[covid_LU:5000:JSONPATH($.data..deaths)]"}
Number	COVID19_LU_Recovered    "Recovered [%,d]"    <recovered>         (CoronaLU)   {http="<[covid_LU:5000:JSONPATH($.data..recovered)]"}
Number	COVID19_LU_Active       "Active [%,d]"       <active>            (CoronaLU)   {http="<[covid_LU:5000:JSONPATH($.data..active)]"}
Number	COVID19_LU_Critical     "Critical [%,d]"     <critical>          (CoronaLU)   {http="<[covid_LU:5000:JSONPATH($.data..critical)]"}

Number	COVID19_NL_Confirmed    "Confirmed [%,d]"    <corona>            (CoronaNL)   {http="<[covid_NL:5000:JSONPATH($.data..cases)]"}
Number	COVID19_NL_Deaths       "Deaths [%,d]"       <death>             (CoronaNL)   {http="<[covid_NL:5000:JSONPATH($.data..deaths)]"}
Number	COVID19_NL_Recovered    "Recovered [%,d]"    <recovered>         (CoronaNL)   {http="<[covid_NL:5000:JSONPATH($.data..recovered)]"}
Number	COVID19_NL_Active       "Active [%,d]"       <active>            (CoronaNL)   {http="<[covid_NL:5000:JSONPATH($.data..active)]"}
Number	COVID19_NL_Critical     "Critical [%,d]"     <critical>          (CoronaNL)   {http="<[covid_NL:5000:JSONPATH($.data..critical)]"}

Number	COVID19_BE_Confirmed    "Confirmed [%,d]"    <corona>            (CoronaBE)   {http="<[covid_BE:5000:JSONPATH($.data..cases)]"}
Number	COVID19_BE_Deaths       "Deaths [%,d]"       <death>             (CoronaBE)   {http="<[covid_BE:5000:JSONPATH($.data..deaths)]"}
Number	COVID19_BE_Recovered    "Recovered [%,d]"    <recovered>         (CoronaBE)   {http="<[covid_BE:5000:JSONPATH($.data..recovered)]"}
Number	COVID19_BE_Active       "Active [%,d]"       <active>            (CoronaBE)   {http="<[covid_BE:5000:JSONPATH($.data..active)]"}
Number	COVID19_BE_Critical     "Critical [%,d]"     <critical>          (CoronaBE)   {http="<[covid_BE:5000:JSONPATH($.data..critical)]"}

Number	COVID19_GB_Confirmed    "Confirmed [%,d]"    <corona>            (CoronaGB)   {http="<[covid_GB:5000:JSONPATH($.data..cases)]"}
Number	COVID19_GB_Deaths       "Deaths [%,d]"       <death>             (CoronaGB)   {http="<[covid_GB:5000:JSONPATH($.data..deaths)]"}
Number	COVID19_GB_Recovered    "Recovered [%,d]"    <recovered>         (CoronaGB)   {http="<[covid_GB:5000:JSONPATH($.data..recovered)]"}
Number	COVID19_GB_Active       "Active [%,d]"       <active>            (CoronaGB)   {http="<[covid_GB:5000:JSONPATH($.data..active)]"}
Number	COVID19_GB_Critical     "Critical [%,d]"     <critical>          (CoronaGB)   {http="<[covid_GB:5000:JSONPATH($.data..critical)]"}

Number	COVID19_RO_Confirmed    "Confirmed [%,d]"    <corona>            (CoronaRO)   {http="<[covid_RO:5000:JSONPATH($.data..cases)]"}
Number	COVID19_RO_Deaths       "Deaths [%,d]"       <death>             (CoronaRO)   {http="<[covid_RO:5000:JSONPATH($.data..deaths)]"}
Number	COVID19_RO_Recovered    "Recovered [%,d]"    <recovered>         (CoronaRO)   {http="<[covid_RO:5000:JSONPATH($.data..recovered)]"}
Number	COVID19_RO_Active       "Active [%,d]"       <active>            (CoronaRO)   {http="<[covid_RO:5000:JSONPATH($.data..active)]"}
Number	COVID19_RO_Critical     "Critical [%,d]"     <critical>          (CoronaRO)   {http="<[covid_RO:5000:JSONPATH($.data..critical)]"}

Number	COVID19_US_Confirmed    "Confirmed [%,d]"    <corona>            (CoronaUS)   {http="<[covid_US:5000:JSONPATH($.data..cases)]"}
Number	COVID19_US_Deaths       "Deaths [%,d]"       <death>             (CoronaUS)   {http="<[covid_US:5000:JSONPATH($.data..deaths)]"}
Number	COVID19_US_Recovered    "Recovered [%,d]"    <recovered>         (CoronaUS)   {http="<[covid_US:5000:JSONPATH($.data..recovered)]"}
Number	COVID19_US_Active       "Active [%,d]"       <active>            (CoronaUS)   {http="<[covid_US:5000:JSONPATH($.data..active)]"}
Number	COVID19_US_Critical     "Critical [%,d]"     <critical>          (CoronaUS)   {http="<[covid_US:5000:JSONPATH($.data..critical)]"}

Number      FL_Corona_Confirmed     "Florida Covid 19 confirmed [%d]" <corona> (CoronaUS_FL) {http="<[covid_Florida:5000:JSONPATH($.data.[?(@.state=='Florida')].cases)]"}
Number      FL_Corona_Confirmed_Today     "Florida Covid 19 confirmed Today [%d]" <corona> (CoronaUS_FL) {http="<[covid_Florida:5000:JSONPATH($.data.[?(@.state=='Florida')].todayCases)]"}
Number      FL_Corona_Deaths     "Florida Covid 19 Deaths [%d]" <corona> (CoronaUS_FL) {http="<[covid_Florida:5000:JSONPATH($.data.[?(@.state=='Florida')].deaths)]"}
Number      FL_Corona_Deaths_Today     "Florida Covid 19 Deaths Today [%d]" <corona> (CoronaUS_FL) {http="<[covid_Florida:5000:JSONPATH($.data.[?(@.state=='Florida')].todayDeaths)]"}
Number      FL_Corona_Active     "Florida Covid 19 Active [%d]" <corona> (CoronaUS_FL) {http="<[covid_Florida:5000:JSONPATH($.data.[?(@.state=='Florida')].active)]"}
Number      FL_Corona_Cases_Per_Million     "Florida Covid 19 Cases Per Million [%d]" <corona> (CoronaUS_FL) {http="<[covid_Florida:5000:JSONPATH($.data.[?(@.state=='Florida')].casesPerOneMillion)]"}
Number      FL_Corona_Deaths_Per_Million     "Florida Covid 19 Deaths Per Million [%d]" <corona> (CoronaUS_FL) {http="<[covid_Florida:5000:JSONPATH($.data.[?(@.state=='Florida')].deathsPerOneMillion)]"}
Number      FL_Corona_Tests     "Florida Covid 19 Tests [%d]" <corona> (CoronaUS_FL) {http="<[covid_Florida:5000:JSONPATH($.data.[?(@.state=='Florida')].tests)]"}
Number      FL_Corona_Tests_Per_Million     "Florida Covid 19 Tests Per Million [%d]" <corona> (CoronaUS_FL) {http="<[covid_Florida:5000:JSONPATH($.data.[?(@.state=='Florida')].testsPerOneMillion)]"}

sitemap

     

Frame label="COVID-19 status" icon="corona"
{ 
	Group item=Corona       label="World"        icon="world"
        Group item=CoronaDE     label="Germany"      icon="de"
        Group item=CoronaIT     label="Italy"        icon="it"
        Group item=CoronaSP     label="Spin"         icon="sp"
        Group item=CoronaFR     label="France"       icon="fr"
        Group item=CoronaLU     label="Luxembourg"   icon="lu"
        Group item=CoronaNL     label="Netherlands"  icon="nl"
        Group item=CoronaBE     label="Belgium"      icon="be"
        Group item=CoronaGB     label="England"      icon="uk"
        Group item=CoronaRO     label="Romania"      icon="ro"
        Group item=CoronaUS     label="USA"          icon="us"
	Group item=CoronaUS_FL  label="USA - Florida"          icon="us"
}
1 Like
109

Thank you for your work on this; implementing it now. Can you provide the images for your items also?

Best, Jay

110

For the countries, I used this page that @Bruce_Osborne noted earlier, https://www.freeflagicons.com/buy/round_icon/. Right-click on the webpages blank area and select save. Then select save as web page complete. It will download all the icons into a folder for you. Then you can grab the ones you need and delete the rest. Note I did change my icon names as shown below after I posted that up there…

Here are some of the other icons I have used. not the best lineup but some are ok I guess.

world
corona
death
recovered
active
critical

…

This is what my sitemap looks like now.

	Group item=Corona       label="World"        icon="world"
        Group item=CoronaDE     label="Germany"      icon="germany_64"
        Group item=CoronaIT     label="Italy"        icon="italy_64"
        Group item=CoronaSP     label="Spin"         icon="spain_64"
        Group item=CoronaFR     label="France"       icon="france_64"
        Group item=CoronaLU     label="Luxembourg"   icon="luxembourg_64"
        Group item=CoronaNL     label="Netherlands"  icon="netherlands_64"
        Group item=CoronaBE     label="Belgium"      icon="belgium_64"
        Group item=CoronaGB     label="England"      icon="england_64"
        Group item=CoronaRO     label="Romania"      icon="romania_64"
        Group item=CoronaUS     label="USA"          icon="united_states_of_america_64"
	Group item=CoronaUS_FL  label="USA - Florida"          icon="united_states_of_america_64"

image
image1389×509 43.2 KB

image
image1684×329 26.1 KB

image
image1658×478 49.7 KB

Just have to figure out how to change the epoch time to a real date time stamp now + my wife wants data from my county so on the search for that next… Got to make the wife happy :smiley:

Also on a side note, I noticed Germany wasn’t working so I updated it my items above. I had left it in lower case witch didn’t match the cfg.

111

This topic was automatically closed 41 days after the last reply. New replies are no longer allowed.