NNDSS - Table II. Spotted Fever Rickettsiosis To Syphilis, Primary And Secondary
U.S. Department of Health & Human Services
@usgov.hhs_gov_nndss_ii_spotted_fever_rickettsiosis_to_syphil_21414c5e
U.S. Department of Health & Human Services
@usgov.hhs_gov_nndss_ii_spotted_fever_rickettsiosis_to_syphil_21414c5e
NNDSS - Table II. Spotted fever rickettsiosis to Syphilis, primary and secondary - 2018. In this Table, provisional cases of selected notifiable diseases (≥1,000 cases reported during the preceding year), and selected low frequency diseases are displayed. The Table includes total number of cases reported in the United States, by region and by states or territory.
Note:
This table contains provisional cases of selected national notifiable diseases from the National Notifiable Diseases Surveillance System (NNDSS). NNDSS data from the 50 states, New York City, the District of Columbia and the U.S. territories are collated and published weekly on the NNDSS Data and Statistics web page (https://wwwn.cdc.gov/nndss/data-and-statistics.html). Cases reported by state health departments to CDC for weekly publication are provisional because of the time needed to complete case follow-up. Therefore, numbers presented in later weeks may reflect changes made to these counts as additional information becomes available. The national surveillance case definitions used to define a case are available on the NNDSS web site at https://wwwn.cdc.gov/nndss/. Information about the weekly provisional data and guides to interpreting data are available at: https://wwwn.cdc.gov/nndss/infectious-tables.html.
Footnotes:
C.N.M.I.: Commonwealth of Northern Mariana Islands.
U: Unavailable. —: No reported cases. N: Not reportable. NA: Not Available. NN: Not Nationally Notifiable. NP: Nationally notifiable but not published. Cum: Cumulative year-to-date counts. Med: Median. Max: Maximum.
CREATE TABLE table_1 (
"reporting_area" VARCHAR,
"mmwr_year" BIGINT,
"mmwr_week" BIGINT,
"spotted_fever_rickettsiosis_confirmed_current_week" DOUBLE -- Spotted Fever Rickettsiosis, Confirmed, Current Week,
"spotted_fever_rickettsiosis_confirmed_current_week_flag" VARCHAR -- Spotted Fever Rickettsiosis, Confirmed, Current Week, Flag,
"spotted_fever_rickettsiosis_confirmed_previous_52_weeks_med" DOUBLE -- Spotted Fever Rickettsiosis, Confirmed, Previous 52 Weeks Med,
"spotted_fever_rickettsiosis_confirmed_previous_52_week_09122646" VARCHAR -- Spotted Fever Rickettsiosis, Confirmed, Previous 52 Weeks Med, Flag,
"spotted_fever_rickettsiosis_confirmed_previous_52_weeks_max" DOUBLE -- Spotted Fever Rickettsiosis, Confirmed, Previous 52 Weeks Max,
"spotted_fever_rickettsiosis_confirmed_previous_52_week_7b772f01" VARCHAR -- Spotted Fever Rickettsiosis, Confirmed, Previous 52 Weeks Max, Flag,
"spotted_fever_rickettsiosis_confirmed_cum_2018" DOUBLE -- Spotted Fever Rickettsiosis, Confirmed, Cum 2018,
"spotted_fever_rickettsiosis_confirmed_cum_2018_flag" VARCHAR -- Spotted Fever Rickettsiosis, Confirmed, Cum 2018, Flag,
"spotted_fever_rickettsiosis_confirmed_cum_2017" DOUBLE -- Spotted Fever Rickettsiosis, Confirmed, Cum 2017,
"spotted_fever_rickettsiosis_confirmed_cum_2017_flag" VARCHAR -- Spotted Fever Rickettsiosis, Confirmed, Cum 2017, Flag,
"spotted_fever_rickettsiosis_probable_current_week" DOUBLE -- Spotted Fever Rickettsiosis, Probable, Current Week,
"spotted_fever_rickettsiosis_probable_current_week_flag" VARCHAR -- Spotted Fever Rickettsiosis, Probable, Current Week, Flag,
"spotted_fever_rickettsiosis_probable_previous_52_weeks_med" DOUBLE -- Spotted Fever Rickettsiosis, Probable, Previous 52 Weeks Med,
"spotted_fever_rickettsiosis_probable_previous_52_weeks_med_flag" VARCHAR -- Spotted Fever Rickettsiosis, Probable, Previous 52 Weeks Med, Flag,
"spotted_fever_rickettsiosis_probable_previous_52_weeks_max" DOUBLE -- Spotted Fever Rickettsiosis, Probable, Previous 52 Weeks Max,
"spotted_fever_rickettsiosis_probable_previous_52_weeks_max_flag" VARCHAR -- Spotted Fever Rickettsiosis, Probable, Previous 52 Weeks Max, Flag,
"spotted_fever_rickettsiosis_probable_cum_2018" DOUBLE -- Spotted Fever Rickettsiosis, Probable, Cum 2018,
"spotted_fever_rickettsiosis_probable_cum_2018_flag" VARCHAR -- Spotted Fever Rickettsiosis, Probable, Cum 2018, Flag,
"spotted_fever_rickettsiosis_probable_cum_2017" DOUBLE -- Spotted Fever Rickettsiosis, Probable, Cum 2017,
"spotted_fever_rickettsiosis_probable_cum_2017_flag" VARCHAR -- Spotted Fever Rickettsiosis, Probable, Cum 2017, Flag,
"syphilis_primary_and_secondary_current_week" DOUBLE -- Syphilis, Primary And Secondary, Current Week,
"syphilis_primary_and_secondary_current_week_flag" VARCHAR -- Syphilis, Primary And Secondary, Current Week, Flag,
"syphilis_primary_and_secondary_previous_52_weeks_med" DOUBLE -- Syphilis, Primary And Secondary, Previous 52 Weeks Med,
"syphilis_primary_and_secondary_previous_52_weeks_med_flag" VARCHAR -- Syphilis, Primary And Secondary, Previous 52 Weeks Med, Flag,
"syphilis_primary_and_secondary_previous_52_weeks_max" DOUBLE -- Syphilis, Primary And Secondary, Previous 52 Weeks Max,
"syphilis_primary_and_secondary_previous_52_weeks_max_flag" VARCHAR -- Syphilis, Primary And Secondary, Previous 52 Weeks Max, Flag,
"syphilis_primary_and_secondary_cum_2018" DOUBLE -- Syphilis, Primary And Secondary, Cum 2018,
"syphilis_primary_and_secondary_cum_2018_flag" VARCHAR -- Syphilis, Primary And Secondary, Cum 2018, Flag,
"syphilis_primary_and_secondary_cum_2017" DOUBLE -- Syphilis, Primary And Secondary, Cum 2017,
"syphilis_primary_and_secondary_cum_2017_flag" VARCHAR -- Syphilis, Primary And Secondary, Cum 2017, Flag,
"location_1" VARCHAR,
"location_2" VARCHAR
);Anyone who has the link will be able to view this.