![[Solved] CS217-Assignment](https://assignmentchef.com/wp-content/uploads/2022/08/downloadzip.jpg)
- The dashboard is based on aggregated data of the Covid 19 cases transmitted to the RKI by the health authorities in accordance with the IfSG
- The current status (00:00) is displayed with the data and the changes in cases and deaths from the previous day are displayed
- The data source contains the following parameters:
| Object_Id | |
| State_Id: Id of the federal state of the case with 1 = Schleswig-Holstein to 16 = Thuringia | |
| State: Name of the federal state | |
| District: Name of the district | |
| Age_Group: Age group of the case from the 6 group 0-4, 5-14, 15-34, 35-59, 60-79, 80+ and unknown | |
| Sex: Gender of the case M0 male, W = female and unknown | |
| Number_of_Cases: Number of cases in the corresponding group | |
| Number_of_deaths: Number of deaths in the corresponding group | |
| Reporting_date: the date when the health department became aware of the case | |
| District_Id: ID of the district of the case in the usual coding 1001 to 16077 = LK Altenburger Land | |
| Last_Updated: Date when the data record was last updated | |
| New_Case:▪ 0: Case is included in the publication for the current day and in the one for the previous day▪ 1: Case is only included in the current publication▪ -1: Case is only included in the previous days publication▪ This results in: number of cases in the current publication as a sum (number of cases), if new case in (0.1); Delta on the previous day as the sum (number of cases) if new case in (-1.1) | |
| New_Death:▪ 0: The case is one death in the publication for the current day and in the one for the previous day▪ 1: The case is a death in the current publication, but not in the previous days publication▪ -1: The case is not a death in the current publication, but it was a death in the previous days publication▪ -9: The case is not a death in either the current publication or that of the previous day▪ this results in: number of deaths in the current publication as a total (number of deaths) if new death in (0.1); Delta on the previous day as total (number of deaths) if new death in (-1.1) | |
| Reference_Date: date of illness or, if this is not known, the reporting date | |
| New_Recovered: |
1
▪ 0: The case is recovery in the publication for the current day and in the one for the previous day
▪ 1: Case is recovered in the current publication, but not in the previous days publication
▪ -1: The case is not recovered in the current publication, but was recovered in the previous days publication
▪ -9: The case is neither in the current publication nor in that of the previous day recovered
▪ This results in: number of geneses of the current publication as the sum (number of geneses) if new geneses in (0.1); Delta on the previous day as sum (number of generations) if new generation in (-1.1)
Number_of_recovered: Number of recovered in the corresponding group
Disease_Onset: 1 if the reference date is the onset of illness, 0 otherwise
Age-group2: Age group of the case from 5-year groups 0-4, 5-9, 10-14, , 75-79, 80+ and unknown
![[Solved] CS217-Assignment Classes](https://assignmentchef.com/wp-content/uploads/2022/08/downloadzip-1200x1200.jpg)
Reviews
There are no reviews yet.