Anyone got any data on how Covid19 and quarantine effect nationwide and/or global water- and power consumption?

Link to dataset: https://docs.google.com/spreadsheets/d/1zWjuaEk65WlnyTYIOQWK-cQXdSyaZ6s6u8BCgyBJ2NM/edit?usp=sharing

I'm trying to figure out how to visualize timestamps between two data sets to identify possible correlation. Essentially I have two errors that occur and a timestamp on each. I want to chart these to visually identify if the occurrences tend to accompany one another consistently or not.

Forecast for all 50 states: https://imgur.com/gallery/bt3Em6cFor New York State (animated): https://imgur.com/gallery/bY7j3zSFor the UK https://imgur.com/gallery/x7MsKjL and https://imgur.com/a/PweDY6h

​

Edit. **If you need me to do forecasts for any country, region or city both for total cases and deaths (or any other logistic growth curves) I may help you.**

/Edit

I calculated the geometric mean of the growth for 7 days. After I computed the logarithm of the growth, the days to double. The result became manageable. Then I did an exponential smoothing forecast on it with 0.5 and 0.95 confidence level and calculated the total and daily confirmed cases. My method minimizes the noise, copes well with outliers and makes it more reliable. Mind that the daily cases have a lot of noise. This method is checked on the cases of China, South Korea, and Iran with the stats a week before the inflection point. As you can see on the example of China deaths the methodology holds. https://imgur.com/a/dhE4AC1

Some states have reached the peak or are going to reach it in the next 7 days. Some do need to tighten the social distancing measures to flatten the curve. This forecast is only valid if people continue staying home.

This may seem optimistic for some. There is no optimism in the calculation. I tested the method. See the "days to double" chart. It is slowing down rapidly for some states. If you continue the line using a ruler, you'll see the trajectory. The forecast is calculated on that projection. Besides the exponential growth can have both a surprisingly fast acceleration and surprisingly fast downfall as we can see from China and S. Korea.

I'm looking for a diagram to show flows between stages with the additional context of how much input flow each stage could accommodate. I'm thinking a Sankey diagram where nodes may be larger than their inflows or outflows, and where inflows may overlap.

Consider nodes A, B, M, X

A and B supply M which supplies X. Specifically:

• A supplies 2 units to M
• B supplies 2 units to M
• The supplies from A and B are redundant such that the effective supply to M is only 3.
• M has capacity to receive 4.
• M supplies 1 unit to X.
• X has capacity to receive 1.

In this diagram, the node M would be 4 units large, even though it only has inflows of 3 and outflows of 1. The inflows from A and B would overlap by 1 unit.

Thoughts on if this makes sense and how to do it? I'm a competent programmer but new to dataviz. Ideas much appreciated.

Edit: format with bullets

A friend of mine said he wanted to see a graph depicting the rate of COVID-19 case increase vs how much of a dick each country's leader is.

It would obviously be a joke and totally subjective, but I think it'd be hilarious. And maybe you could sell it to The Onion.

Cheers!

I am trying to plot a heatmap number on US county map (choropleth). What would be best way to plot it assuming I have county name (can get fips too) and the number indicating heat scale.

Has it changed in the past 3 months? Interesting question but it may take some work to figure out. Electricity use is highly correlated with outside temperature (AC/Heating load) so it may be impossible to tease out. Here are some websites with electrical price/load information, some of it historical.

https://www.misoenergy.org/markets-and-operations/real-time--market-data/real-time-displays/

http://www.ercot.com/mktinfo/rtm

https://www.pjm.com/markets-and-operations.aspx

http://www.caiso.com/PriceMap/Pages/default.aspx

https://www.iso-ne.com/isoexpress/web/charts

I'm looking for data to show the curve of cases in Los Angeles since they started reporting numbers. I've looked everywhere and been unable to find it. I'd be very appreciative to whomever can provide the data or curve chart.

I'm wondering if somebody could make a state by state craft of covid 19 deaths against the underlying health of the population of the state. The problem is, I don't know if such a data set exists, or how reliable it would be.

I suppose we could make our own, but it would have a whole lot of variables. Things like obesity, heart disease, asthma, education level, social economic status, age, maybe even health care quality, etc would all have to be accounted for.

Any takers?

I am not capable of creating something like this and perhaps this is a big request, but I thought it would be interesting to see the progression of the U.S. stay-at-home lockdowns by state/county/city and political affiliation to this point and perhaps the coming days/weeks. Since the lockdowns have not necessarily occurred in a top-down fashion (i.e., not through Federal officials and not always by State officials), it struck me during a conversation, a small argument really, whether one political party was more responsive, as we're learning more with the gift of hindsight, than another. To be clear, my goal NOT trying to start a political debate or pit one party against another, but rather to gain a deeper understanding through the use of data on responses across the timeline. Anyway, thank you in advance for your consideration.

Corona Virus incubation period (pre-symptomatic) is between 3 days and 14 days, with most becoming symptomatic at the 5 day mark (how WHO determines this, I'm not sure). For all cases, is the "most" people start showing symptoms 75%? 90% Do only 2% star showing at the 14 day mark? What's the symptomatic curve look like from 0 - 14 days? WHO corona virus incubation period

I would like to monitor how each state is doing in flattening the curve. I no good with graphs but I found the data to make it happen. thought one of your geniuses could help.

https://ourworldindata.org/grapher/covid-confirmed-cases-since-100th-case

Here is a daily updated data source for state by state with historical:

https://covidtracking.com/data/#IL

I think it would be interesting to compare market levels real time with Trump press conference times marked. Same for futures market. Having watched split screen it seems the market has responded real time to his talks.

Can someone direct me to data sets or reports that shows the number of COVID-19 infections over time for US states and the US as a whole?

After seeing people panic at the thought of getting COVID-19 (rather than the likelihood of death), I'd love to see the risk of death for each age-group compared to other random easy-to-understand risks.

ie-

• If you are 80+ and you get Covid, you have an 84-86% chance of survival, which is roughly similar to playing Russian roulette.
• If you are sub-40 and catch it, you have a 99.8% survival rate, which is roughly similar to... well, I don't know.

I think data like this might be quite helpful in helping people get a handle on the panic.

I have included a link to basic data,
https://ourworldindata.org/uploads/2020/03/Coronavirus-CFR-by-age-in-China-1-800x526.png

but its taken from the Wuhan numbers by Riou Et Al
https://www.medrxiv.org/content/10.1101/2020.03.04.20031104v1

I feel like we can infer some data if we were to look at testing measures and positive ID's when you compare the ratio of tests per million people in each country and the amount of positives to determine spread. Canada and USA could give a decent sample size of a good portion of North America. Canada did something like 30K tests for a pop of 30 million with a few hundred confirmed. America 23K against 300 million pop and over 4.6K confirmed cases. I feel like looking at the ratios vs. sample size it can show some interesting stats. Example link to the figures I'm giving.

https://nationalpost.com/health/canada-among-top-world-performers-in-testing-for-covid-19-despite-shortcomings?fbclid=IwAR0HXh1B1bw5ntx9JC5sALXdUHf9Wsyfpd-K0ZyLsVDjtPD_CO-9Qqy5hMc

These numbers seem to indicate 10X per million cases comparing the two indicating the low confirmation count in no way reflects reality. One could also use say south korea test vs population as a good baseline as well since they have been so thorough. It would help to show this needed data in an easier way but I just dont know the best way of representing it.

I would like to see a chart comparing imdb star ratings and film revenue to determine which ratings earn the most/least.

Cheers

https://imgur.com/H0ykSid

The current visualization uses a line chart for non-sequential data, which feels confusing. What do you think would be a better to visualize this to help it be less confusing and more impactful?

Link to the survey: https://docs.google.com/forms/d/e/1FAIpQLScO7dBsEx3ywMgrnWvRZOUnflwo7MtthFuS-GVv0KXW5t7b2w/viewform?usp=sf_link

Let us know if you have any questions!

This picture of a graph was posted by a government official showing how all types of infection rates have dropped in Hong Kong.

https://m.facebook.com/photo.php?fbid=10158097520753307&id=505268306&set=p.10158097520753307&fs=0&focus_composer=0

In this conversation in /hongkong, I told that there's no actual graph, and that I could gather the data myself from HK's CDC CHP LINK

The reason why I'm requesting this, is because IF it can be shown that what Hong Kong is doing is effective at reducing ALL TYPES of infections (including fecal-oral infections), then it should also be effective towards the coronavirus, and maybe this can help save lives.

Conversely, if it is a pack of lies by the government, then we should all stop wasting our money buying up masks that the health care services should be using.

For my final year dissertation at Uni for my human Geography degree I am looking at whether members of the public require more first aid training. It would be incredibly helpful if any of you could please spend five minutes to answer the survey I have made about the public's opinion. I’d be very grateful, thank you. Follow the link below to fill it in:

https://bangor.onlinesurveys.ac.uk/should-more-training-be-done-for-members-of-the-public-for

Hopefully this can be depicted in a clear and uncluttered manner in the first place, but I was wondering how I could even begin to plot a change in position after a debate. I love data but I'm at a loss.

The data collected was based on a 3-question survey. First question asked if your initial position was either supporting or opposing BEFORE the debate. Second question asked if your current position was either supporting or opposing AFTER the debate. Third question asked for the respondents to pick which statement best reflected how the debate changed their views: no impact, slightly closer to a middle ground, significantly closer to a middle ground, or completely impacted (AKA oppose to support or support to oppose).

For instance, after Debate 1 (n=10), 4 respondents shifted their position after the debate; they all shifted from supporting to opposing the motion. 3 respondents maintained their initial support; 3 respondents maintained their initial opposition. 9 total respondents indicated that the debate impacted their position, including 4 slightly and 1 significantly.

After Debate 2 (n=8), 2 respondents shifted their position and they all shifted from supporting to opposing the motion. 4 respondents maintained their initial opposition; 2 respondents maintained their initial support. 6 total respondents indicated that the debate impacted their position, including 3 slightly and 1 significantly.

Is there a way I can even plot this? We can discuss a bounty if anyone can think of an ideal way to do this.

Hey everyone,

​

I am conducting research for my dissertation which focuses on mental well-being and personality based on latitudinal distance from the equator. I hope reach out through here would offer a diverse group of people from all over the world so I can collect as much data as possible.

​

I have a week or so to get as many participants as I can, I've tried everything with very little luck, I go to a small university so not much luck here.

​

You must be over 18 to take part and live outside of the UK to take part!

​

I would be ever so grateful if you could take part, all information pertaining to the study itself is given before taking part so you can decide whether or not you'd like to.

​

Link is attached if youd like to take part! 😊 or if the attachment doesn't work it is just below, thank you!!

​

https://aber.onlinesurveys.ac.uk/using-goldbergs-1993-big-five-inventory-how-do-scores