Global Covid Strategies

COVID-19 data encompasses a wide array of information related to the spread, impact, and response to the COVID-19 pandemic. Here's a detailed description of the various types of data that are typically collected:

## Types of COVID-19 Data

1. Case Data 

Confirmed Cases: Total number of individuals who have tested positive for COVID-19.

Active Cases: Current number of individuals who are still infected and have not yet recovered or died.

Recovered Cases: Number of individuals who have recovered from COVID-19.

Deaths: Total number of deaths attributed to COVID-19.

2. Testing Data 

Total Tests Conducted: Cumulative number of COVID-19 tests administered.

Positive Test Rate: Percentage of tests that return positive results.

Testing Capacity: Information on the availability and utilization of testing resources.

3. Vaccination Data 

Total Vaccinations Administered: Total number of vaccine doses given.

People Fully Vaccinated: Number of individuals who have received all required doses of a COVID-19 vaccine.

Vaccination Rate: Percentage of the population that has been vaccinated.

4. Hospitalization Data 

Current Hospitalizations: Number of individuals currently hospitalized due to COVID-19.

ICU Admissions: Number of individuals in intensive care units.

5. Google Mobility Report 

Retail and Recreation: Includes restaurants, cafes, shopping centers, theme parks, museums, libraries, and movie theaters.

Grocery and Pharmacy: Includes grocery markets, food warehouses, farmers markets, specialty food shops, drug stores, and pharmacies.

Parks: Includes local parks, national parks, public beaches, marinas, dog parks, plazas, and public gardens.

Transit Stations: Includes places like public transport hubs such as subway, bus, and train stations.

Workplaces: Includes places of work.

Residential: Covers places of residence.

原始信息汇总

Global Covid Strategies 数据集概述

数据集基本信息

• 提供商: InSights
• 费用: 免费
• 访问权限: Unlimited Access
• 数据更新频率: 每周
• 时间覆盖范围: 2020年1月5日 - 2024年5月10日（按天）
• 地理覆盖范围: 全球（按国家）

数据类型

1. 病例数据

   • 确诊病例数
   • 活跃病例数
   • 康复病例数
   • 死亡病例数

2. 检测数据

   • 总检测次数
   • 阳性检测率
   • 检测能力

3. 疫苗接种数据

   • 总接种剂量
   • 完全接种人数
   • 接种率

4. 住院数据

   • 当前住院人数
   • ICU入院人数

5. Google移动报告

   • 零售和娱乐场所活动
   • 杂货店和药店活动
   • 公园活动
   • 交通站点活动
   • 工作场所活动
   • 住宅活动

商业用途

• 公共卫生与安全

  • 接触者追踪
  • 资源分配优化
  • 疫苗接种计划监控

• 经济影响分析

  • 市场趋势分析
  • 失业趋势分析
  • 消费者行为研究

数据字典

主要数据表

• COVID19_HOSPITAL_METRICS_BY_COUNTRY
• COVID19_JHU_CSSE_METRICS
• COVID19_METRICS_BY_CONTINENT
• COVID19_METRICS_BY_COUNTRY
• COVID19_VACCINATION_METRICS_BY_COUNTRY

关键字段

• CONTINENT: 大陆名称
• COUNTRY: 国家名称
• DATE: 日期
• HOSPITAL_BEDS_PER_THOUSAND: 每千人病床数
• HOSP_PATIENTS: 当日住院患者数
• ICU_PATIENTS: 当日ICU患者数
• ISO_CODE: 国家ISO代码
• WEEKLY_HOSP_ADMISSIONS: 每周新入院患者数

使用示例

1. 按大陆汇总病例、死亡和检测数据 sql SELECT CONTINENT, SUM(TOTAL_CASES_PER_MILLION) AS TOTAL_CASES_PER_MILLION, SUM(TOTAL_DEATHS_PER_MILLION) AS TOTAL_DEATHS_PER_MILLION, SUM(TOTAL_TESTS_PER_THOUSAND) AS TOTAL_TESTS_PER_THOUSAND FROM INSIGHTS.COVID19_METRICS_BY_COUNTRY GROUP BY CONTINENT ORDER BY TOTAL_CASES_PER_MILLION DESC;

2. 计算特定日期范围内各国的死亡率 sql SELECT CONTINENT, COUNTRY, SUM(TOTAL_CASE) AS TOTAL_CASES, SUM(TOTAL_DEATHS) AS TOTAL_DEATHS, (SUM(TOTAL_DEATHS)::FLOAT / NULLIF(SUM(TOTAL_CASE), 0)) AS DEATH_RATE FROM INSIGHTS.COVID19_METRICS_BY_COUNTRY WHERE DATE BETWEEN 2021-01-01 AND 2021-12-31 GROUP BY CONTINENT, COUNTRY ORDER BY DEATH_RATE DESC;

提供商联系方式

• 销售: [e-mail]
• 支持: [e-mail]

搜集汇总

背景与挑战

背景概述

该数据集涵盖COVID-19疫情相关的五类核心数据：病例统计（含确诊、活跃、康复及死亡病例）、检测指标、疫苗接种进度、住院情况，以及反映人员流动模式的谷歌移动报告（包含零售、公园等6类场所活动数据）。