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