Nationwide Commercial Laboratory Seroprevalence Survey
U.S. Department of Health & Human Services
@usgov.hhs_gov_nationwide_commercial_laboratory_seroprevalence_survey
U.S. Department of Health & Human Services
@usgov.hhs_gov_nationwide_commercial_laboratory_seroprevalence_survey
CDC is working with commercial laboratories to conduct large-scale geographic seroprevalence surveys to estimate the percentage of people who were previously infected with SARS-CoV-2, the virus that causes COVID-19 disease. The strategy involves working with state, local, territorial, academic, and commercial partners to better understand COVID-19 in the United States using serology (antibody) testing for surveillance (“seroprevalence surveys” or “serosurveys”). For the surveys, de-identified clinical blood samples are tested for antibodies to SARS-CoV-2. This dataset contains the data used to by the Nationwide Commercial Laboratory Seroprevalence Survey interactive visualization available at https://covid.cdc.gov/covid-data-tracker/#national-lab. Additional information is available at https://www.cdc.gov/coronavirus/2019-ncov/cases-updates/commercial-lab-surveys.html.
Organization: U.S. Department of Health & Human Services
Last updated: 2020-11-10T16:16:39.665415
Tags: coronavirus, covid, covid-19, covid19, laboratory, prevalence, seroprevalence, serosurveys
CREATE TABLE table_1 (
"site" VARCHAR,
"date_range_of_specimen_collection" VARCHAR,
"round" BIGINT,
"catchment_fips_code_description" VARCHAR,
"catchment_area_description" VARCHAR,
"catchment_population" BIGINT,
"n_anti_n_0_4_years_prevalence" DOUBLE -- N [Anti-N, 0-4 Years Prevalence],
"rate_anti_n_0_4_years_prevalence" DOUBLE -- Rate (%) [Anti-N, 0-4 Years Prevalence],
"lower_ci_anti_n_0_4_years_prevalence" DOUBLE -- Lower CI [Anti-N, 0-4 Years Prevalence],
"upper_ci_anti_n_0_4_years_prevalence" DOUBLE -- Upper CI [Anti-N, 0-4 Years Prevalence],
"ci_flag_anti_n_0_4_years_prevalence" DOUBLE -- CI Flag [Anti-N, 0-4 Years Prevalence],
"n_anti_n_5_11_years_prevalence" DOUBLE -- N [Anti-N, 5-11 Years Prevalence],
"rate_anti_n_5_11_years_prevalence" DOUBLE -- Rate (%) [Anti-N, 5-11 Years Prevalence],
"lower_ci_anti_n_5_11_years_prevalence" DOUBLE -- Lower CI [Anti-N, 5-11 Years Prevalence],
"upper_ci_anti_n_5_11_years_prevalence" DOUBLE -- Upper CI [Anti-N, 5-11 Years Prevalence],
"ci_flag_anti_n_5_11_years_prevalence" DOUBLE -- CI Flag [Anti-N, 5-11 Years Prevalence],
"n_anti_n_0_11_years_prevalence" DOUBLE -- N [Anti-N, 0-11 Years Prevalence],
"rate_anti_n_0_11_years_prevalence" DOUBLE -- Rate (%) [Anti-N, 0-11 Years Prevalence],
"lower_ci_anti_n_0_11_years_prevalence" DOUBLE -- Lower CI [Anti-N, 0-11 Years Prevalence],
"upper_ci_anti_n_0_11_years_prevalence" DOUBLE -- Upper CI [Anti-N, 0-11 Years Prevalence],
"ci_flag_anti_n_0_11_years_prevalence" DOUBLE -- CI Flag [Anti-N, 0-11 Years Prevalence],
"n_anti_n_12_17_years_prevalence" DOUBLE -- N [Anti-N, 12-17 Years Prevalence],
"rate_anti_n_12_17_years_prevalence" DOUBLE -- Rate (%) [Anti-N, 12-17 Years Prevalence],
"lower_ci_anti_n_12_17_years_prevalence" DOUBLE -- Lower CI [Anti-N, 12-17 Years Prevalence],
"upper_ci_anti_n_12_17_years_prevalence" DOUBLE -- Upper CI [Anti-N, 12-17 Years Prevalence],
"ci_flag_anti_n_12_17_years_prevalence" DOUBLE -- CI Flag [Anti-N, 12-17 Years Prevalence],
"n_anti_n_0_17_years_prevalence" DOUBLE -- N [Anti-N, 0-17 Years Prevalence],
"rate_anti_n_0_17_years_prevalence" DOUBLE -- Rate (%) [Anti-N, 0-17 Years Prevalence],
"lower_ci_anti_n_0_17_years_prevalence" DOUBLE -- Lower CI [Anti-N, 0-17 Years Prevalence],
"upper_ci_anti_n_0_17_years_prevalence" DOUBLE -- Upper CI [Anti-N, 0-17 Years Prevalence],
"ci_flag_anti_n_0_17_years_prevalence" DOUBLE -- CI Flag [Anti-N, 0-17 Years Prevalence],
"n_anti_n_18_49_years_prevalence_rounds_1_30_only" DOUBLE -- N [Anti-N, 18-49 Years Prevalence, Rounds 1-30 Only],
"rate_anti_n_18_49_years_prevalence_rounds_1_30_only" DOUBLE -- Rate (%) [Anti-N, 18-49 Years Prevalence, Rounds 1-30 Only],
"lower_ci_anti_n_18_49_years_prevalence_rounds_1_30_only" DOUBLE -- Lower CI [Anti-N, 18-49 Years Prevalence, Rounds 1-30 Only],
"upper_ci_anti_n_18_49_years_prevalence_rounds_1_30_only" DOUBLE -- Upper CI [Anti-N, 18-49 Years Prevalence, Rounds 1-30 Only],
"ci_flag_anti_n_18_49_years_prevalence_rounds_1_30_only" DOUBLE -- CI Flag [Anti-N, 18-49 Years Prevalence, Rounds 1-30 Only],
"n_anti_n_50_64_years_prevalence_rounds_1_30_only" DOUBLE -- N [Anti-N, 50-64 Years Prevalence, Rounds 1-30 Only],
"rate_anti_n_50_64_years_prevalence_rounds_1_30_only" DOUBLE -- Rate (%) [Anti-N, 50-64 Years Prevalence, Rounds 1-30 Only],
"lower_ci_anti_n_50_64_years_prevalence_rounds_1_30_only" DOUBLE -- Lower CI [Anti-N, 50-64 Years Prevalence, Rounds 1-30 Only],
"upper_ci_anti_n_50_64_years_prevalence_rounds_1_30_only" DOUBLE -- Upper CI [Anti-N, 50-64 Years Prevalence, Rounds 1-30 Only],
"ci_flag_anti_n_50_64_years_prevalence_rounds_1_30_only" DOUBLE -- CI Flag [Anti-N, 50-64 Years Prevalence, Rounds 1-30 Only],
"n_anti_n_65_years_prevalence_rounds_1_30_only" DOUBLE -- N [Anti-N, 65+ Years Prevalence, Rounds 1-30 Only],
"rate_anti_n_65_years_prevalence_rounds_1_30_only" DOUBLE -- Rate (%) [Anti-N, 65+ Years Prevalence, Rounds 1-30 Only],
"lower_ci_anti_n_65_years_prevalence_rounds_1_30_only" DOUBLE -- Lower CI [Anti-N, 65+ Years Prevalence, Rounds 1-30 Only],
"upper_ci_anti_n_65_years_prevalence_rounds_1_30_only" DOUBLE -- Upper CI [Anti-N, 65+ Years Prevalence, Rounds 1-30 Only],
"ci_flag_anti_n_65_years_prevalence_rounds_1_30_only" DOUBLE -- CI Flag [Anti-N, 65+ Years Prevalence, Rounds 1-30 Only],
"n_anti_n_all_ages_cumulative_prevalence_rounds_1_30_only" DOUBLE -- N [Anti-N, All Ages Cumulative Prevalence, Rounds 1-30 Only],
"rate_anti_n_all_ages_cumulative_prevalence_rounds_1_30_only" DOUBLE -- Rate (%) [Anti-N, All Ages Cumulative Prevalence, Rounds 1-30 Only],
"lower_ci_anti_n_all_ages_cumulative_prevalence_rounds__92b0e715" DOUBLE -- Lower CI [Anti-N, All Ages Cumulative Prevalence, Rounds 1-30 Only],
"upper_ci_anti_n_all_ages_cumulative_prevalence_rounds__7048179b" DOUBLE -- Upper CI [Anti-N, All Ages Cumulative Prevalence, Rounds 1-30 Only],
"ci_flag_anti_n_all_ages_cumulative_prevalence_rounds_1_30_only" DOUBLE -- CI Flag [Anti-N, All Ages Cumulative Prevalence, Rounds 1-30 Only],
"n_anti_n_all_ages_male_prevalence_rounds_1_30_only" DOUBLE -- N [Anti-N, All Ages Male Prevalence, Rounds 1-30 Only],
"rate_anti_n_all_ages_male_prevalence_rounds_1_30_only" DOUBLE -- Rate (%) [Anti-N, All Ages Male Prevalence, Rounds 1-30 Only],
"lower_ci_anti_n_all_ages_male_prevalence_rounds_1_30_only" DOUBLE -- Lower CI [Anti-N, All Ages Male Prevalence, Rounds 1-30 Only],
"upper_ci_anti_n_all_ages_male_prevalence_rounds_1_30_only" DOUBLE -- Upper CI [Anti-N, All Ages Male Prevalence, Rounds 1-30 Only],
"ci_flag_anti_n_all_ages_male_prevalence_rounds_1_30_only" DOUBLE -- CI Flag [Anti-N, All Ages Male Prevalence, Rounds 1-30 Only],
"n_anti_n_all_ages_female_prevalence_rounds_1_30_only" DOUBLE -- N [Anti-N, All Ages Female Prevalence, Rounds 1-30 Only],
"rate_anti_n_all_ages_female_prevalence_rounds_1_30_only" DOUBLE -- Rate (%) [Anti-N, All Ages Female Prevalence, Rounds 1-30 Only],
"lower_ci_anti_n_all_ages_female_prevalence_rounds_1_30_only" DOUBLE -- Lower CI [Anti-N, All Ages Female Prevalence, Rounds 1-30 Only],
"upper_ci_anti_n_all_ages_female_prevalence_rounds_1_30_only" DOUBLE -- Upper CI [Anti-N, All Ages Female Prevalence, Rounds 1-30 Only],
"ci_flag_anti_n_all_ages_female_prevalence_rounds_1_30_only" DOUBLE -- CI Flag [Anti-N, All Ages Female Prevalence, Rounds 1-30 Only],
"n_anti_n_0_17_male_prevalence_rounds_31_and_later" DOUBLE -- N [Anti-N, 0-17 Male Prevalence, Rounds 31 And Later],
"rate_anti_n_0_17_male_prevalence_rounds_31_and_later" DOUBLE -- Rate (%) [Anti-N, 0-17 Male Prevalence, Rounds 31 And Later],
"lower_ci_anti_n_0_17_male_prevalence_rounds_31_and_later" DOUBLE -- Lower CI [Anti-N, 0-17 Male Prevalence, Rounds 31 And Later],
"upper_ci_anti_n_0_17_male_prevalence_rounds_31_and_later" DOUBLE -- Upper CI [Anti-N, 0-17 Male Prevalence, Rounds 31 And Later],
"ci_flag_anti_n_0_17_male_prevalence_rounds_31_and_later" DOUBLE -- CI Flag [Anti-N, 0-17 Male Prevalence, Rounds 31 And Later],
"n_anti_n_0_17_female_prevalence_rounds_31_and_later" DOUBLE -- N [Anti-N, 0-17 Female Prevalence, Rounds 31 And Later],
"rate_anti_n_0_17_female_prevalence_rounds_31_and_later" DOUBLE -- Rate (%) [Anti-N, 0-17 Female Prevalence, Rounds 31 And Later],
"lower_ci_anti_n_0_17_female_prevalence_rounds_31_and_later" DOUBLE -- Lower CI [Anti-N, 0-17 Female Prevalence, Rounds 31 And Later],
"upper_ci_anti_n_0_17_female_prevalence_rounds_31_and_later" DOUBLE -- Upper CI [Anti-N, 0-17 Female Prevalence, Rounds 31 And Later],
"ci_flag_anti_n_0_17_female_prevalence_rounds_31_and_later" DOUBLE -- CI Flag [Anti-N, 0-17 Female Prevalence, Rounds 31 And Later],
"n_anti_s_0_4_years_prevalence" DOUBLE -- N [Anti-S, 0-4 Years Prevalence],
"rate_anti_s_0_4_years_prevalence" DOUBLE -- Rate (%) [Anti-S, 0-4 Years Prevalence],
"lower_ci_anti_s_0_4_years_prevalence" DOUBLE -- Lower CI [Anti-S, 0-4 Years Prevalence],
"upper_ci_anti_s_0_4_years_prevalence" DOUBLE -- Upper CI [Anti-S, 0-4 Years Prevalence],
"ci_flag_anti_s_0_4_years_prevalence" DOUBLE -- CI Flag [Anti-S, 0-4 Years Prevalence],
"n_anti_s_5_11_years_prevalence" DOUBLE -- N [Anti-S, 5 - 11 Years Prevalence],
"rate_anti_s_5_11_years_prevalence" DOUBLE -- Rate (%) [Anti-S, 5 - 11 Years Prevalence],
"lower_ci_anti_s_5_11_years_prevalence" DOUBLE -- Lower CI [Anti-S, 5 - 11 Years Prevalence],
"upper_ci_anti_s_5_11_years_prevalence" DOUBLE -- Upper CI [Anti-S, 5 - 11 Years Prevalence],
"ci_flag_anti_s_5_11_years_prevalence" DOUBLE -- CI Flag [Anti-S, 5 - 11 Years Prevalence],
"n_anti_s_0_11_years_prevalence" DOUBLE -- N [Anti-S, 0-11 Years Prevalence],
"rate_anti_s_0_11_years_prevalence" DOUBLE -- Rate (%) [Anti-S, 0-11 Years Prevalence],
"lower_ci_anti_s_0_11_years_prevalence" DOUBLE -- Lower CI [Anti-S, 0-11 Years Prevalence],
"upper_ci_anti_s_0_11_years_prevalence" DOUBLE -- Upper CI [Anti-S, 0-11 Years Prevalence],
"ci_flag_anti_s_0_11_years_prevalence" DOUBLE -- CI Flag [Anti-S, 0-11 Years Prevalence],
"n_anti_s_12_17_years_prevalence" DOUBLE -- N [Anti-S, 12-17 Years Prevalence],
"rate_anti_s_12_17_years_prevalence" DOUBLE -- Rate (%) [Anti-S, 12-17 Years Prevalence],
"lower_ci_anti_s_12_17_years_prevalence" DOUBLE -- Lower CI [Anti-S, 12-17 Years Prevalence],
"upper_ci_anti_s_12_17_years_prevalence" DOUBLE -- Upper CI [Anti-S, 12-17 Years Prevalence],
"ci_flag_anti_s_12_17_years_prevalence" DOUBLE -- CI Flag [Anti-S, 12-17 Years Prevalence],
"n_anti_s_0_17_years_prevalence" DOUBLE -- N [Anti-S, 0-17 Years Prevalence],
"rate_anti_s_0_17_years_prevalence" DOUBLE -- Rate (%) [Anti-S, 0-17 Years Prevalence],
"lower_ci_anti_s_0_17_years_prevalence" DOUBLE -- Lower CI [Anti-S, 0-17 Years Prevalence],
"upper_ci_anti_s_0_17_years_prevalence" DOUBLE -- Upper CI [Anti-S, 0-17 Years Prevalence],
"ci_flag_anti_s_0_17_years_prevalence" DOUBLE -- CI Flag [Anti-S, 0-17 Years Prevalence],
"n_anti_s_male_0_17_prevalence_rounds_31_and_later" DOUBLE -- N [Anti-S, Male 0-17 Prevalence, Rounds 31 And Later],
"rate_anti_s_male_0_17_prevalence_rounds_31_and_later" DOUBLE -- Rate (%) [Anti-S, Male 0-17 Prevalence, Rounds 31 And Later],
"lower_ci_anti_s_male_0_17_prevalence_rounds_31_and_later" DOUBLE -- Lower CI [Anti-S, Male 0-17 Prevalence, Rounds 31 And Later],
"upper_ci_anti_s_male_0_17_prevalence_rounds_31_and_later" DOUBLE -- Upper CI [Anti-S, Male 0-17 Prevalence, Rounds 31 And Later]
);Anyone who has the link will be able to view this.