• Home
  • About
  • Our Services
    • AI Applied
    • AI Accelerate
  • Key Industries
    • Finance and Banking
    • Healthcare
    • Manufacturing
    • Retail
    • Product Design and Development
    • Smart City and Infrastructure
  • Resources
    • Case Studies
    • Ebook: How to Bring AI to Your Organization
    • Free Guide: Discussion Questions for AI Readiness
    • New Research: 50 AI Examples from the Fortune 500
  • Projects
    • Unredactor
    • Using Bigquery to Debunk Coronavirus Myths
  • Coronavirus + AI
    • Apply for Manceps' Covid-19 AI Initiative
    • Using BigQuery to Debunk Coronavirus Myths
  • Careers
    • Current Openings
    • Get Google Cloud Artchitect Certified
  • Blog
  • Contact us
Manceps

Using BigQuery to Debunk Coronavirus Myths

A real-time data visualization project by Manceps

As misinformation and rumor continue to swirl around the spread of the COVID-19 pandemic, we decided to create a series of charts to see if it would be possible to identify any previously-unnoticed trends. By combining health data from the WHO, climate data from NOAA, and World Development Indicators from the World Bank, we were able to discover some fascinating correlations.

Attn Mobile Users: To improve performance, please click on each chart to view its most up-to-date version.

International Impact

In this chart, we mapped the prevalence of confirmed cases, recovered patients, and deaths. In terms of raw numbers, you can see that America is clearly at the top. However, by looking at it per capita, we can see that the US's case rate is similar to that of Europe.

Confirmed Cases by Average National Temperature

Here, we attempted to validate whether average temperature is correlated to the spread of the virus. We grouped by latitude, longitude buckets so that we could look at temperature effects independent of countries. Many have theorized that warmer temperatures will lead to a reduction in confirmed cases; however, these charts seem to indicate that there is not a relationship.

Growth Rate By National Economies

We were curious to see whether national economies could be correlated to the number of corona virus cases. As these charts seem to indicate, wealthier nations tend to have higher numbers of cases (and deaths) per capita. Presumably, poorer nations aren't testing as often as wealthier ones, which may skew the information presented in these charts.

Growth Rate By National Health Indicators

One way to score overall healthcare systems is to look at each country's infant and overall mortality rates. In the first row of charts, we can see a clear pattern that seems to suggest that nations with better functioning healthcare systems have more cases of corona. Again, this could be related to the availability of testing. In the second row of charts, the correlation becomes less clearly defined.

Get Notified of Future Projects

OUR LATEST RESOURCES
OUR LATEST ARTICLES

DevFest West Coast 2020

Watch videos of some of the world's top AI experts discuss everything from Tensorflow Extended to Kubernetes to AutoML to Coral.

Video: Machine Learning Engineering with Tensorflow Extended

In this talk, Hannes is providing insights into Machine Learning Engineering with TensorFlow Extended (TFX). He introduces how TFX for machine learning pipeline tasks and how to orchestrate entire ML pipelines with TFX. The audience learns how to run ML production pipelines with Kubeflow Pipelines, and therefore, free the data scientist's time from maintaining production machine learning models.

Video: How to Build a Reproducible ML Pipeline

Solving a data science problem usually requires multiple steps. These steps can include extracting and transforming data, training a model, and deploying the model into production. In this session, we'll discuss how to specify those steps with Python into an ML pipeline. We'll show how to create a Kubeflow Pipeline, a component of the Kubeflow open-source project. The audience will learn about how to integrate TensorFlow Extended components into the pipeline, and how to deploy the pipeline to the hosted Cloud AI Pipelines environment on Google Cloud. The key takeaway is how to improve reuse and reproducibility of the machine learning process.

LOAD MORE

OUR HEADQUARTERS
Headquartered in the heart of Portland, Oregon, our satellite offices span North America, Europe, the Middle East, and Africa.

(503) 922-1164

Our address is
US Custom House
220 NW 8th Ave
Portland, OR 97209

Copyright © 2019 Manceps