The first part

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

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.

Finding and downloading the COVIDcast data

The account of the COVIDcast use case starts by explaining [how to find and download the COVIDcast] data.

#postgresql #covid-19 #yugabytedb #analysis #using postgresql aggregate functions