World Health Statistics 2020|Complete|Geo-Analysis

location Location	period Period	indicator Indicator	dim1 Dim1	first_tooltip First Tooltip
Afghanistan	2019	New HIV infections (per 1000 uninfected population)	Both sexes	0.04 [0.01-0.15]
Afghanistan	2019	New HIV infections (per 1000 uninfected population)	Male	0.06 [0.02-0.21]
Afghanistan	2019	New HIV infections (per 1000 uninfected population)	Female	0.03
Afghanistan	2015	New HIV infections (per 1000 uninfected population)	Both sexes	0.03 [0.01-0.11]
Afghanistan	2015	New HIV infections (per 1000 uninfected population)	Male	0.05 [0.02-0.16]
Afghanistan	2015	New HIV infections (per 1000 uninfected population)	Female	0.02
Afghanistan	2010	New HIV infections (per 1000 uninfected population)	Both sexes	0.03 [0.01-0.06]
Afghanistan	2010	New HIV infections (per 1000 uninfected population)	Male	0.03 [0.01-0.09]
Afghanistan	2010	New HIV infections (per 1000 uninfected population)	Female	0.02
Afghanistan	2005	New HIV infections (per 1000 uninfected population)	Both sexes	0.02


CREATE TABLE newhivinfections (
  "location" VARCHAR,
  "period" BIGINT,
  "indicator" VARCHAR,
  "dim1" VARCHAR,
  "first_tooltip" VARCHAR
);