swb-ief / etl-pipeline

The Covid Lens
1 stars 10 forks source link

Extra Ward metric confirmed growth rate #114

Closed Nozziel closed 3 years ago

Nozziel commented 3 years ago

New: confirmed growth rate (last 14 days avg. vs prev. 14 days avg.) Note: this is very similar to what we use to calculate the top priority districts (for Rt). make sure we use the same function from the backend there.

Verify the existence of: City, Ward, date, delta.cases, delta.cases per million population, delta.fatalities, delta.fatalities per million population, case growth rate (last 14 days avg. vs prev. 14 days avg.), daily tests, 21 DMA cases, delta.positivity, 21 DMA TPR, doubling time, 21 DMA fatalities

Naming in Phase 2 is slightly different and we will maintain that because its more consistent. But needs to be communicated with the PowerBI team.