Jeu de données : Données hospitalières relatives à l'épidémie de COVID-19
Titre : What is the cumulative number of Covid-19 hospitalizations?
Date : 2020-07-02 11:42

Good day everyone

I investigate the relationship between the anxiety of the population and some covid-19 parameters.

For France, what is the cumulative number of Covid-19 hospitalizations to date?

If possible, please split up for intensive care and normal hospitalizations.

Thank you very much for your help!

Frederik Feys
PhD Medical Sciences
Independent researcher
https://www.researchgate.net/profile/Frederik_Feys
+32488020010
Hello,

You have several ways to obtain these data.
1) you can open the "donnees-hospitalieres-covid19-2020-07-03-19h00.csv" file (upper on this page). Date/Time is changing everyday. File is provided around 7PM CET time (Paris TZ). Data collection is stopped at 2PM CET.
In this file you have several columns: one is "hosp" : this is the number of person occupying a bed in hospital fot covid-19 reason (suspected, if a person is finally not contaminated by covid-19, so he/she is removed for table with -1 in the corresponding column 3 days after -as test is taking 3 days)
Another column is "rea": this is the intensive care.
"rea" is already included in "hosp", meaning that, if on a line you have 100 hosp and 20 rea, it means you have 20 "rea/intensive care unit" and 80 in "non rea/intensive care unit". 80 is what you called "normal" hospitalization
The file is with a lot of lines because there is 1 by day (your request) and 1 by departement. For France departement is an area smallest than country or region. I do not know where you are located (+32 is Belgium no?) but departement is an area between the state and the county for the USAs.
2) you can check with the government site : https://www.gouvernement.fr/info-coronavirus/carte-et-donnees
on the left part, in the bottom, you will see a graph/chart with the data you are expecting. Just put the mouse on 1 column (do not click, just focus the mouse on) and you will see the figures
3) You also have the GEODES site https://geodes.santepubliquefrance.fr/#c=indicator&view=map2 but you will need to be fluent in french
...

For the stress feedback, I suggest you to consult the SPF (Santé Publique France / France Public Health) https://www.santepubliquefrance.fr/maladies-et-traumatismes/maladies-et-infections-respiratoires/infection-a-coronavirus/articles/infection-au-nouveau-coronavirus-sars-cov-2-covid-19-france-et-monde with the weekly report (point hebdomadaire) but you will need to check the archives 
You also have on the same site : https://www.santepubliquefrance.fr/etudes-et-enquetes/covid-19-une-enquete-pour-suivre-l-evolution-des-comportements-et-de-la-sante-mentale-pendant-l-epidemie
Thank you very much for your time, Denis! 

I used the file “donnees-hospitalieres-covid19-2020-07-03-19h00.csv” that you indicate. I want to calculate the total number of hospitalized during the entire pandemic. I cannot use the column "hosp" because then I count the same person more than once. The column "rad" shows the cumulative number of people who returned home (from the hospital?). I assume they were hospitalized first? For example, according to the data up to and including 3 July, I will meet 153,756 ex-hospital patients.

To what extent is this a correct calculation?

For the calculation of fear among the French population, I took the data from Dr Deschasaux (https://www.medrxiv.org/content/10.1101/2020.06.04.20121855v1). They used the same scale (GAD-7) that I also use. Strangely enough, according to that study, France had the least fear during the epidemic compared to the rest of the world. I try to understand how this is possible? What are your ideas?

Thank you
Frederik
OK. So in this case the file "donnees-hospitalieres-nouveaux-covid19-2020-07-03-19h00.csv" is maybe better for you
This file is counting the number of new incoming people in the hospital.
As an example, you have 100 persons in a bed. 10 new (nouveaux), 3 rad (back to home/retour à domicile identified as rad, initial of each word) then the new number of person in bed is 107 (100 + 10 - 3)
Then you are right, in the 107, you already get 100 with the yesterday number. I needed to understand your exact need.
So donnees-hospitalieres-nouveaux-covid19-2020-07-03-19h00.csv is certainly better for you
rad is th enumber of person leaving the hospital after admission.
But we never had answer (I have following those files since March 20th ... around) from where they were leaving : hosp? rea? other? We think this is certainly from hosp and not rea because we cannot believe somebody can go from rea to home like this. The only way is to die ... but in this case it is in the column dc (dc is for decease, in french we say décès and phonetic is dc)
I have not studied the fear so I cannot help you on this topic but I will take time to look the reference you gave
Indeed the file “donnees-hospitalieres-nouveaux-covid19-2020-07-03-19h00.csv” is what I need. Thank you. I calculated 111,917 were hospitalized in France. As a side-note: with a 'retour à domiclie' of 153,756 people-> makes me wonder were these extra some 40,000 people come back from? 
Hello Frederik,

If I have the same result than you for the hosp (111339 # 111917) I have not the same for the rad: 78943. Half yours. The official number is 77655 (on the french government site). I have 77644 with 'my' data.
Check if you do not count double because of the sexe (1 is men, 2 is female, 0 is male + female. So if you do not filter on sexe, you count twice male and female with 0. Same for age classes : 0 is sum of age A and B and C ... until E. Some other age classes are from 9 to 9 0 to 9 + 10 to 19 + 20 to 29 and so on)
A lot of people is doing this mistake. You look like too ...
Thank you for clarifying this sex=0. Still, how come that 77,644 gone home again and 111,339 ever were hospitalised; 29,933 are dead, so 3,762 still hospitalized. But on the monitor I see 7,594 hosp. https://www.gouvernement.fr/info-coronavirus/carte-et-donnees
Hello,

Not 29933. Only 19457. The 10 thousand else are ehpad and not hospital. You need to count same dataset.
So only 19457 (for yesterday, I have not yet checked for today) : those ones only are hospital.
DELETED

Annotation : Demande de jeu de données (set) (Accessibilité )