Charity  Ferry

Charity Ferry

1620263764

Using PostgreSQL Aggregate Functions in YugabyteDB to Analyze COVID-19 Data

Overview of the Account of the COVIDcast Use Case in the YSQL Documentation

The first part is covered by the sections [Finding and downloading the COVIDcast data] and [Ingesting, checking, and combining the COVIDcast data] . It explains how to ingest the downloaded COVIDcast data into a single 'covidcast_fb_survey_results’  table upon which various analysis queries can be run.

The second part is covered by the section [Using the YSQL linear regression analysis functions on the COVIDcast data] . It explains the analysis and shows how to produce values and graphs like those that the Washington Post article presents.

#postgresql #covid 19 #yugabytedb

Using PostgreSQL Aggregate Functions in YugabyteDB to Analyze COVID-19 Data