Data 607 Week 3 - Tuberculosis Rates

0. Optional: Download CSS Stylesheet here.

Save into working directory.

getwd()

## [1] "C:/data"

1. Load packages

## Loading required package: xml2

## Loading required package: bitops

## 
## Attaching package: 'dplyr'

## The following objects are masked from 'package:plyr':
## 
##     arrange, count, desc, failwith, id, mutate, rename, summarise,
##     summarize

## The following objects are masked from 'package:stats':
## 
##     filter, lag

## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union

2. Create a CSV file using SQL.

Resulting CSV file was uploaded to GitHub for next step.

/*
DATA 607 WEEK 3 HOMEWORK
SQL CODE INSERT
BY ARMENOUSH ASLANIAN-PERSICO

*/
-- 0. Check file location.
SHOW VARIABLES LIKE 'secure_file_priv';

-- 1. If the schema does not exist, create it.
CREATE SCHEMA IF NOT EXISTS tb;

-- 2. Load tuberculosis data.
-- 2a. Create a temporary CSV holding table for tb.
DROP TABLE IF EXISTS tb;
CREATE TABLE tb 
(
  country varchar(100) NOT NULL,
  year int NOT NULL,
  sex varchar(6) NOT NULL,
  child int NULL,
  adult int NULL,
  elderly int NULL
);
-- 2b. Load the CSV file.
LOAD DATA LOCAL INFILE 'C:/data/tb.csv' 
    INTO TABLE tb
    FIELDS TERMINATED BY ',' 
    ENCLOSED BY '"'
    LINES TERMINATED BY '\n'
    (country, year, sex, @child, @adult, @elderly)
    SET
-- 2c. Assign a null value to any negative values.
    child = nullif(@child,-1),
    adult = nullif(@adult,-1),
    elderly = nullif(@elderly,-1)
    ;

-- 3. View the head of the temporary table, selecting all columns.
SELECT * 
FROM tb
ORDER BY year ASC, country ASC 
LIMIT 10;


-- 4. Load population data.
-- 4a. Create a temporary CSV holding table for pop.
DROP TABLE IF EXISTS pop;
CREATE TABLE pop
(
  country varchar(100) NOT NULL,
  year int NOT NULL,
  population int NOT NULL
);
-- 4b. Load the CSV file.
LOAD DATA LOCAL INFILE 'C:/data/population.csv' 
    INTO TABLE pop
    FIELDS TERMINATED BY ',' 
    ENCLOSED BY '"'
    LINES TERMINATED BY '\n'
-- 4c. Ignore the column header row.
    IGNORE 1 LINES
    (country, year, population);

-- 5. View the head of the temporary table, selecting all columns.
SELECT * 
FROM pop
ORDER BY year ASC, country ASC LIMIT 10;

-- 6. Check for duplicates before creating join.
-- 6a. Compare countries in both tables. 
SELECT country AS Unmatching_Country_TbTable 
FROM tb 
WHERE (country) NOT IN 
(SELECT country FROM pop);
SELECT country AS Unmatching_Country_PopTable 
FROM pop
WHERE (country) NOT IN 
(SELECT country FROM tb );
-- 6b. Compare years in both tables.
SELECT year AS Unmatching_Year_TbTable 
FROM tb 
WHERE (year) NOT IN 
(SELECT year FROM pop);
SELECT year AS Unmatching_Year_PopTable FROM pop
WHERE (year) NOT IN 
(SELECT year FROM tb );
      
-- 7. Import temporary tables into working tables.
-- 7a. Create a working table for tb data.
DROP TABLE IF EXISTS tb1;
CREATE TABLE tb1
    (
    id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    combocy VARCHAR(100) NOT NULL,
    combocys VARCHAR(100) NOT NULL,
    country VARCHAR(100) NOT NULL,
    year INT NOT NULL,
    sex varchar(6) NOT NULL,
    child INT NULL,
    adult INT NULL,
    elderly INT NULL,
    d_total INT NULL
    );
-- 7b. Create a working table for population data.
DROP TABLE IF EXISTS pop1;
CREATE TABLE pop1
    (
    id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    combocy VARCHAR(100) NOT NULL,
    country VARCHAR(100) NOT NULL,
    year INT NOT NULL,
    population INT NOT NULL
    );
-- 7c. Paste the temporary table information into the working table tb1.
INSERT INTO tb1 
    (
    combocy, 
    combocys, 
    country, 
    year, 
    sex, 
    child, 
    adult, 
    elderly, 
    d_total)  
SELECT 
    CONCAT(country,'_',year), 
    CONCAT(country,'_',year,'_',sex), 
    country, 
    year, 
    sex, 
    child, 
    adult, 
    elderly, 
    child+adult+elderly
FROM tb;
-- 7d. Paste the temporary table information into the working table pop1.
INSERT INTO pop1 
(
    combocy, 
    country, 
    year, 
    population
)  
SELECT 
    CONCAT(country,'_',year), 
    country, 
    year, 
    population
FROM pop;
  
  -- 8a. View the head of the tb working table, selecting all columns.
SELECT *
FROM tb1
ORDER BY id ASC
LIMIT 30;
-- 8b. View the head of the pop working table, selecting all columns.
SELECT *
FROM pop1
ORDER BY id ASC 
LIMIT 30;

-- 9a. Check for combocy duplicates in pop1.
SELECT combocy, COUNT(combocy) AS Duplicate_Combo_Names_pop1
FROM pop1
GROUP BY combocy
HAVING ( COUNT(combocy) > 1 )
LIMIT 30;
-- 9b. Check that each combocy appears only twice in tb1.
SELECT combocy, COUNT(combocy) AS Duplicate_Combo_Names_tb1
FROM tb1
GROUP BY combocy
HAVING (COUNT(combocy) > 2 OR COUNT(combocy) < 2)
LIMIT 30;
-- 9c. Check for combocys duplicates in tb1.
SELECT combocys, COUNT(combocys) Duplicate_Combo_Names_2_tb1
FROM tb1
GROUP BY combocys
HAVING (COUNT(combocys) > 1)
LIMIT 30;

-- 10. View male and female cases on separate rows.
SELECT * FROM tb1
ORDER BY year ASC, country ASC
LIMIT 100;

-- 11. Create a table for male and female cases combined.
DROP TABLE IF EXISTS tb2;
CREATE TABLE tb2 AS
SELECT 
    combocy AS cid,
    country AS loc,
    year AS yr,
    SUM(child) AS d1,
    SUM(adult) AS d2,
    SUM(elderly) AS d3,
    SUM(d_total) AS dt
FROM tb1
GROUP BY combocy;

SELECT *
FROM tb2
ORDER BY yr ASC, loc ASC
LIMIT 30;

-- 12. Join with population table.
-- 12a. View highest rates.
SELECT
    tb2.cid,
    tb2.loc,
    tb2.yr,
    tb2.d1,
    tb2.d2,
    tb2.d3,
    tb2.dt,
    pop1.population,
    tb2.dt/pop1.population AS rate
FROM tb2
LEFT JOIN pop1
ON tb2.cid=pop1.combocy
ORDER BY rate DESC;
-- 12b. View total cases by year.
SELECT
    tb2.yr,
    SUM(tb2.dt)
FROM tb2
GROUP BY tb2.yr
ORDER BY tb2.yr ASC;

-- 13. Create table for export.
DROP TABLE IF EXISTS tb3;
CREATE TABLE tb3 AS
SELECT
    tb2.cid,
    tb2.loc,
    tb2.yr,
    tb2.d1,
    tb2.d2,
    tb2.d3,
    tb2.dt,
    pop1.population,
    tb2.dt/pop1.population AS rate
FROM tb2
LEFT JOIN pop1
ON tb2.cid=pop1.combocy;
-- 13a. View table head.
SELECT *
FROM tb3
ORDER BY yr ASC, loc ASC
LIMIT 30;

-- 14. Export into CSV file.
SELECT * 
FROM tb3
INTO OUTFILE 'C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/tb3.csv' 
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n'

3. Import CSV file from GitHub.

Indicate “header=F” for missing header row.

x <- getURL("https://raw.githubusercontent.com/spsstudent15/20160160703/master/tb3.csv")
dftb<-data.frame(read.csv(text=x, header=F, stringsAsFactors = F))

4. View data frame dimensions, head, structure.

dim(dftb)

## [1] 1900    9

head(dftb)

##                 V1          V2   V3  V4   V5  V6   V7        V8     V9
## 1 Afghanistan_1995 Afghanistan 1995 \\N  \\N \\N  \\N  17586073    \\N
## 2     Algeria_1995     Algeria 1995 \\N  \\N \\N  \\N  29315463    \\N
## 3      Angola_1995      Angola 1995 757 3803  32 4592  12104952 0.0004
## 4   Argentina_1995   Argentina 1995 \\N  \\N \\N  \\N  34833168    \\N
## 5  Azerbaijan_1995  Azerbaijan 1995   0   89   1   90   7770806 0.0000
## 6  Bangladesh_1995  Bangladesh 1995  93 5468 462 6023 119869585 0.0001

str(dftb)

## 'data.frame':    1900 obs. of  9 variables:
##  $ V1: chr  "Afghanistan_1995" "Algeria_1995" "Angola_1995" "Argentina_1995" ...
##  $ V2: chr  "Afghanistan" "Algeria" "Angola" "Argentina" ...
##  $ V3: int  1995 1995 1995 1995 1995 1995 1995 1995 1995 1995 ...
##  $ V4: chr  "\\N" "\\N" "757" "\\N" ...
##  $ V5: chr  "\\N" "\\N" "3803" "\\N" ...
##  $ V6: chr  "\\N" "\\N" "32" "\\N" ...
##  $ V7: chr  "\\N" "\\N" "4592" "\\N" ...
##  $ V8: int  17586073 29315463 12104952 34833168 7770806 119869585 10189075 5985658 7635362 1583453 ...
##  $ V9: chr  "\\N" "\\N" "0.0004" "\\N" ...

This returns 1900 records for 9 variables and shows we need to convert character columns to numeric.

5. Convert character columns to numeric. This converts NA values to 0.

dftb$V4<-as.numeric(dftb$V4)

## Warning: NAs introduced by coercion

dftb$V5<-as.numeric(dftb$V5)

## Warning: NAs introduced by coercion

dftb$V6<-as.numeric(dftb$V6)

## Warning: NAs introduced by coercion

dftb$V7<-as.numeric(dftb$V7)

## Warning: NAs introduced by coercion

dftb$V9<-as.numeric(dftb$V9)

## Warning: NAs introduced by coercion

6. View head and structure.

str(dftb)

## 'data.frame':    1900 obs. of  9 variables:
##  $ V1: chr  "Afghanistan_1995" "Algeria_1995" "Angola_1995" "Argentina_1995" ...
##  $ V2: chr  "Afghanistan" "Algeria" "Angola" "Argentina" ...
##  $ V3: int  1995 1995 1995 1995 1995 1995 1995 1995 1995 1995 ...
##  $ V4: num  NA NA 757 NA 0 93 NA 40 NA NA ...
##  $ V5: num  NA NA 3803 NA 89 ...
##  $ V6: num  NA NA 32 NA 1 462 NA 114 NA NA ...
##  $ V7: num  NA NA 4592 NA 90 ...
##  $ V8: int  17586073 29315463 12104952 34833168 7770806 119869585 10189075 5985658 7635362 1583453 ...
##  $ V9: num  NA NA 4e-04 NA 0e+00 1e-04 NA 3e-04 NA NA ...

head(dftb)

##                 V1          V2   V3  V4   V5  V6   V7        V8    V9
## 1 Afghanistan_1995 Afghanistan 1995  NA   NA  NA   NA  17586073    NA
## 2     Algeria_1995     Algeria 1995  NA   NA  NA   NA  29315463    NA
## 3      Angola_1995      Angola 1995 757 3803  32 4592  12104952 4e-04
## 4   Argentina_1995   Argentina 1995  NA   NA  NA   NA  34833168    NA
## 5  Azerbaijan_1995  Azerbaijan 1995   0   89   1   90   7770806 0e+00
## 6  Bangladesh_1995  Bangladesh 1995  93 5468 462 6023 119869585 1e-04

7. Group by year, create bar plot.

Check against Excel and SQL:

1995: 494742 total cases

1996: 615510 total cases

grpyear<-aggregate(cbind(V7) ~ V3, data = dftb, sum)
grpyear

##      V3      V7
## 1  1995  494742
## 2  1996  615510
## 3  1997  707032
## 4  1998  819307
## 5  1999  972403
## 6  2000 1129928
## 7  2001 1217466
## 8  2002 1499640
## 9  2003 1834928
## 10 2004 2155527
## 11 2005 2336700
## 12 2006 2945389
## 13 2007 3789689
## 14 2008 3475415
## 15 2009 3779375
## 16 2010 3938515
## 17 2011 3921712
## 18 2012 3885645
## 19 2013 3108132

barplot(
  as.numeric(grpyear$V7/1000000), 
  names=grpyear$V3, 
  xlab="Year",
  ylab="Cases in Millions",
  main="Worldwide Tuberculosis Cases by Year", 
  border="black", 
  col="blue", 
  ylim=c(0,5))

8. Rename column headers.

colnames(dftb) <-c(
  "CID",
  "COUNTRY",
  "YEAR",
  "CHILD",
  "ADULT",
  "ELDERLY",
  "TOTAL", 
  "COUNTRY_POPULATION", 
  "RATE")

9. What kind of analysis and reporting could be done with this data?

We could see trends of increasing rates in specific countries and adjust public policy and funding to address those issues. We could also see which countries are missing data.

10. Table output.

Format table with Kable package.

tb3s <- subset(dftb,select= c( 2,3,9))
summary(tb3s)

##    COUNTRY               YEAR           RATE       
##  Length:1900        Min.   :1995   Min.   :0.0000  
##  Class :character   1st Qu.:1999   1st Qu.:0.0002  
##  Mode  :character   Median :2004   Median :0.0004  
##                     Mean   :2004   Mean   :0.0006  
##                     3rd Qu.:2009   3rd Qu.:0.0007  
##                     Max.   :2013   Max.   :0.0081  
##                                    NA's   :209

kable(tb3s,align="c",caption="Tuberculosis Infection Rates Per Capita by Country and Year")

Tuberculosis Infection Rates Per Capita by Country and Year
COUNTRY	YEAR	RATE
Afghanistan	1995	NA
Algeria	1995	NA
Angola	1995	0.0004
Argentina	1995	NA
Azerbaijan	1995	0.0000
Bangladesh	1995	0.0001
Belarus	1995	NA
Benin	1995	0.0003
Bolivia (Plurinational State of)	1995	NA
Botswana	1995	NA
Brazil	1995	NA
Burkina Faso	1995	0.0001
Burundi	1995	0.0002
Cambodia	1995	0.0012
Cameroon	1995	0.0002
Central African Republic	1995	0.0005
Chad	1995	NA
Chile	1995	0.0001
China	1995	0.0001
China, Hong Kong SAR	1995	NA
Colombia	1995	NA
Congo	1995	0.0007
Côte d’Ivoire	1995	0.0006
Democratic People’s Republic of Korea	1995	NA
Democratic Republic of the Congo	1995	0.0003
Djibouti	1995	NA
Dominican Republic	1995	NA
Ecuador	1995	NA
Egypt	1995	0.0001
Ethiopia	1995	0.0001
France	1995	0.0001
Georgia	1995	0.0000
Germany	1995	0.0000
Ghana	1995	0.0002
Guatemala	1995	0.0002
Guinea	1995	0.0003
Haiti	1995	NA
Honduras	1995	0.0004
India	1995	0.0000
Indonesia	1995	0.0000
Iran (Islamic Republic of)	1995	0.0002
Iraq	1995	0.0006
Italy	1995	0.0000
Japan	1995	0.0001
Kazakhstan	1995	NA
Kenya	1995	0.0005
Kyrgyzstan	1995	0.0002
Lao People’s Democratic Republic	1995	0.0001
Lesotho	1995	0.0008
Liberia	1995	NA
Madagascar	1995	0.0006
Malawi	1995	0.0006
Malaysia	1995	0.0003
Mali	1995	0.0002
Mexico	1995	NA
Mongolia	1995	0.0003
Morocco	1995	0.0005
Mozambique	1995	0.0007
Myanmar	1995	0.0002
Namibia	1995	0.0004
Nepal	1995	NA
Nicaragua	1995	0.0003
Niger	1995	NA
Nigeria	1995	0.0001
Pakistan	1995	0.0000
Paraguay	1995	0.0002
Peru	1995	0.0003
Philippines	1995	0.0000
Poland	1995	0.0001
Portugal	1995	0.0002
Republic of Korea	1995	0.0003
Republic of Moldova	1995	0.0002
Romania	1995	0.0008
Russian Federation	1995	NA
Rwanda	1995	NA
Saudi Arabia	1995	NA
Senegal	1995	0.0006
Sierra Leone	1995	0.0004
Somalia	1995	0.0004
South Africa	1995	NA
Spain	1995	0.0000
Sri Lanka	1995	0.0002
Sudan	1995	0.0002
Swaziland	1995	0.0007
Syrian Arab Republic	1995	0.0001
Tajikistan	1995	NA
Thailand	1995	0.0003
Togo	1995	0.0002
Turkey	1995	NA
Uganda	1995	0.0007
Ukraine	1995	0.0002
United Kingdom of Great Britain and Northern Ireland	1995	NA
United Republic of Tanzania	1995	0.0007
United States of America	1995	0.0000
Uzbekistan	1995	NA
Venezuela (Bolivarian Republic of)	1995	NA
Viet Nam	1995	NA
Yemen	1995	0.0002
Zambia	1995	0.0010
Zimbabwe	1995	NA
Afghanistan	1996	NA
Algeria	1996	NA
Angola	1996	0.0006
Argentina	1996	0.0002
Azerbaijan	1996	0.0001
Bangladesh	1996	0.0001
Belarus	1996	NA
Benin	1996	0.0003
Bolivia (Plurinational State of)	1996	0.0009
Botswana	1996	NA
Brazil	1996	NA
Burkina Faso	1996	0.0001
Burundi	1996	0.0002
Cambodia	1996	0.0011
Cameroon	1996	0.0002
Central African Republic	1996	0.0006
Chad	1996	NA
Chile	1996	0.0001
China	1996	0.0001
China, Hong Kong SAR	1996	NA
Colombia	1996	NA
Congo	1996	NA
Côte d’Ivoire	1996	0.0005
Democratic People’s Republic of Korea	1996	NA
Democratic Republic of the Congo	1996	0.0003
Djibouti	1996	0.0027
Dominican Republic	1996	0.0002
Ecuador	1996	NA
Egypt	1996	0.0001
Ethiopia	1996	0.0002
France	1996	0.0001
Georgia	1996	0.0001
Germany	1996	0.0000
Ghana	1996	0.0001
Guatemala	1996	0.0002
Guinea	1996	0.0004
Haiti	1996	0.0004
Honduras	1996	0.0003
India	1996	0.0000
Indonesia	1996	0.0001
Iran (Islamic Republic of)	1996	0.0001
Iraq	1996	NA
Italy	1996	0.0000
Japan	1996	0.0001
Kazakhstan	1996	NA
Kenya	1996	0.0006
Kyrgyzstan	1996	0.0002
Lao People’s Democratic Republic	1996	0.0002
Lesotho	1996	0.0010
Liberia	1996	0.0003
Madagascar	1996	0.0006
Malawi	1996	0.0007
Malaysia	1996	0.0003
Mali	1996	0.0002
Mexico	1996	0.0001
Mongolia	1996	0.0003
Morocco	1996	0.0005
Mozambique	1996	0.0006
Myanmar	1996	0.0002
Namibia	1996	0.0017
Nepal	1996	0.0004
Nicaragua	1996	0.0004
Niger	1996	NA
Nigeria	1996	0.0001
Pakistan	1996	NA
Paraguay	1996	0.0002
Peru	1996	0.0002
Philippines	1996	0.0000
Poland	1996	0.0002
Portugal	1996	0.0002
Republic of Korea	1996	0.0003
Republic of Moldova	1996	0.0001
Romania	1996	0.0005
Russian Federation	1996	0.0000
Rwanda	1996	0.0003
Saudi Arabia	1996	NA
Senegal	1996	0.0007
Sierra Leone	1996	0.0006
Somalia	1996	0.0004
South Africa	1996	NA
Spain	1996	NA
Sri Lanka	1996	0.0002
Sudan	1996	NA
Swaziland	1996	0.0022
Syrian Arab Republic	1996	0.0001
Tajikistan	1996	0.0000
Thailand	1996	0.0003
Togo	1996	0.0002
Turkey	1996	NA
Uganda	1996	0.0007
Ukraine	1996	0.0002
United Kingdom of Great Britain and Northern Ireland	1996	NA
United Republic of Tanzania	1996	0.0007
United States of America	1996	0.0000
Uzbekistan	1996	0.0001
Venezuela (Bolivarian Republic of)	1996	NA
Viet Nam	1996	0.0006
Yemen	1996	0.0000
Zambia	1996	NA
Zimbabwe	1996	NA
Afghanistan	1997	0.0000
Algeria	1997	0.0003
Angola	1997	0.0006
Argentina	1997	0.0001
Azerbaijan	1997	0.0001
Bangladesh	1997	0.0002
Belarus	1997	NA
Benin	1997	0.0003
Bolivia (Plurinational State of)	1997	0.0008
Botswana	1997	0.0016
Brazil	1997	NA
Burkina Faso	1997	0.0001
Burundi	1997	0.0003
Cambodia	1997	NA
Cameroon	1997	0.0002
Central African Republic	1997	0.0007
Chad	1997	NA
Chile	1997	0.0001
China	1997	0.0002
China, Hong Kong SAR	1997	0.0003
Colombia	1997	NA
Congo	1997	NA
Côte d’Ivoire	1997	0.0006
Democratic People’s Republic of Korea	1997	0.0002
Democratic Republic of the Congo	1997	0.0003
Djibouti	1997	0.0028
Dominican Republic	1997	0.0003
Ecuador	1997	NA
Egypt	1997	0.0001
Ethiopia	1997	0.0003
France	1997	0.0000
Georgia	1997	0.0001
Germany	1997	0.0000
Ghana	1997	0.0003
Guatemala	1997	0.0002
Guinea	1997	0.0004
Haiti	1997	0.0007
Honduras	1997	0.0003
India	1997	0.0000
Indonesia	1997	0.0001
Iran (Islamic Republic of)	1997	0.0001
Iraq	1997	0.0004
Italy	1997	0.0000
Japan	1997	0.0001
Kazakhstan	1997	0.0003
Kenya	1997	0.0007
Kyrgyzstan	1997	0.0003
Lao People’s Democratic Republic	1997	0.0002
Lesotho	1997	0.0013
Liberia	1997	NA
Madagascar	1997	NA
Malawi	1997	0.0007
Malaysia	1997	0.0003
Mali	1997	0.0003
Mexico	1997	NA
Mongolia	1997	0.0005
Morocco	1997	0.0005
Mozambique	1997	0.0007
Myanmar	1997	0.0002
Namibia	1997	0.0018
Nepal	1997	NA
Nicaragua	1997	0.0003
Niger	1997	0.0001
Nigeria	1997	0.0001
Pakistan	1997	NA
Paraguay	1997	0.0002
Peru	1997	0.0011
Philippines	1997	0.0000
Poland	1997	0.0001
Portugal	1997	0.0002
Republic of Korea	1997	0.0002
Republic of Moldova	1997	0.0001
Romania	1997	0.0005
Russian Federation	1997	0.0000
Rwanda	1997	0.0004
Saudi Arabia	1997	NA
Senegal	1997	0.0006
Sierra Leone	1997	0.0006
Somalia	1997	0.0005
South Africa	1997	NA
Spain	1997	NA
Sri Lanka	1997	0.0002
Sudan	1997	NA
Swaziland	1997	NA
Syrian Arab Republic	1997	0.0001
Tajikistan	1997	0.0000
Thailand	1997	0.0002
Togo	1997	NA
Turkey	1997	NA
Uganda	1997	0.0008
Ukraine	1997	0.0002
United Kingdom of Great Britain and Northern Ireland	1997	0.0000
United Republic of Tanzania	1997	0.0007
United States of America	1997	0.0000
Uzbekistan	1997	NA
Venezuela (Bolivarian Republic of)	1997	NA
Viet Nam	1997	0.0007
Yemen	1997	0.0003
Zambia	1997	NA
Zimbabwe	1997	NA
Afghanistan	1998	0.0001
Algeria	1998	NA
Angola	1998	0.0006
Argentina	1998	0.0001
Azerbaijan	1998	0.0000
Bangladesh	1998	0.0003
Belarus	1998	NA
Benin	1998	0.0003
Bolivia (Plurinational State of)	1998	0.0008
Botswana	1998	NA
Brazil	1998	NA
Burkina Faso	1998	0.0001
Burundi	1998	0.0005
Cambodia	1998	0.0012
Cameroon	1998	0.0003
Central African Republic	1998	0.0008
Chad	1998	NA
Chile	1998	NA
China	1998	0.0002
China, Hong Kong SAR	1998	NA
Colombia	1998	NA
Congo	1998	NA
Côte d’Ivoire	1998	0.0006
Democratic People’s Republic of Korea	1998	0.0000
Democratic Republic of the Congo	1998	0.0007
Djibouti	1998	0.0024
Dominican Republic	1998	0.0003
Ecuador	1998	NA
Egypt	1998	0.0001
Ethiopia	1998	0.0003
France	1998	NA
Georgia	1998	0.0001
Germany	1998	0.0000
Ghana	1998	0.0004
Guatemala	1998	0.0002
Guinea	1998	0.0004
Haiti	1998	0.0008
Honduras	1998	0.0004
India	1998	0.0000
Indonesia	1998	0.0002
Iran (Islamic Republic of)	1998	0.0001
Iraq	1998	0.0004
Italy	1998	0.0000
Japan	1998	0.0001
Kazakhstan	1998	0.0004
Kenya	1998	0.0008
Kyrgyzstan	1998	0.0002
Lao People’s Democratic Republic	1998	0.0003
Lesotho	1998	0.0014
Liberia	1998	0.0005
Madagascar	1998	0.0006
Malawi	1998	0.0008
Malaysia	1998	0.0003
Mali	1998	0.0003
Mexico	1998	0.0001
Mongolia	1998	0.0006
Morocco	1998	0.0005
Mozambique	1998	NA
Myanmar	1998	0.0002
Namibia	1998	0.0020
Nepal	1998	0.0005
Nicaragua	1998	0.0003
Niger	1998	0.0002
Nigeria	1998	0.0001
Pakistan	1998	0.0000
Paraguay	1998	0.0002
Peru	1998	0.0011
Philippines	1998	0.0000
Poland	1998	0.0001
Portugal	1998	0.0002
Republic of Korea	1998	0.0002
Republic of Moldova	1998	0.0001
Romania	1998	0.0005
Russian Federation	1998	0.0000
Rwanda	1998	NA
Saudi Arabia	1998	0.0000
Senegal	1998	0.0006
Sierra Leone	1998	0.0006
Somalia	1998	0.0005
South Africa	1998	NA
Spain	1998	0.0000
Sri Lanka	1998	0.0002
Sudan	1998	0.0003
Swaziland	1998	NA
Syrian Arab Republic	1998	0.0001
Tajikistan	1998	0.0001
Thailand	1998	0.0001
Togo	1998	0.0002
Turkey	1998	NA
Uganda	1998	0.0008
Ukraine	1998	0.0002
United Kingdom of Great Britain and Northern Ireland	1998	0.0000
United Republic of Tanzania	1998	0.0007
United States of America	1998	0.0000
Uzbekistan	1998	0.0000
Venezuela (Bolivarian Republic of)	1998	NA
Viet Nam	1998	0.0007
Yemen	1998	0.0003
Zambia	1998	NA
Zimbabwe	1998	NA
Afghanistan	1999	0.0000
Algeria	1999	0.0002
Angola	1999	0.0007
Argentina	1999	0.0001
Azerbaijan	1999	0.0001
Bangladesh	1999	0.0003
Belarus	1999	NA
Benin	1999	0.0003
Bolivia (Plurinational State of)	1999	0.0008
Botswana	1999	0.0017
Brazil	1999	0.0002
Burkina Faso	1999	0.0001
Burundi	1999	0.0004
Cambodia	1999	0.0013
Cameroon	1999	0.0004
Central African Republic	1999	0.0008
Chad	1999	0.0004
Chile	1999	0.0001
China	1999	0.0002
China, Hong Kong SAR	1999	0.0003
Colombia	1999	0.0002
Congo	1999	0.0007
Côte d’Ivoire	1999	0.0006
Democratic People’s Republic of Korea	1999	0.0001
Democratic Republic of the Congo	1999	0.0008
Djibouti	1999	0.0022
Dominican Republic	1999	0.0004
Ecuador	1999	NA
Egypt	1999	0.0001
Ethiopia	1999	0.0003
France	1999	0.0000
Georgia	1999	0.0002
Germany	1999	0.0000
Ghana	1999	0.0004
Guatemala	1999	0.0002
Guinea	1999	0.0004
Haiti	1999	0.0008
Honduras	1999	0.0004
India	1999	0.0001
Indonesia	1999	0.0002
Iran (Islamic Republic of)	1999	0.0001
Iraq	1999	0.0005
Italy	1999	0.0000
Japan	1999	0.0001
Kazakhstan	1999	0.0005
Kenya	1999	0.0009
Kyrgyzstan	1999	0.0003
Lao People’s Democratic Republic	1999	0.0003
Lesotho	1999	NA
Liberia	1999	NA
Madagascar	1999	NA
Malawi	1999	0.0007
Malaysia	1999	0.0004
Mali	1999	0.0003
Mexico	1999	0.0001
Mongolia	1999	0.0006
Morocco	1999	0.0005
Mozambique	1999	NA
Myanmar	1999	0.0002
Namibia	1999	0.0020
Nepal	1999	0.0006
Nicaragua	1999	0.0003
Niger	1999	NA
Nigeria	1999	NA
Pakistan	1999	0.0000
Paraguay	1999	0.0002
Peru	1999	0.0010
Philippines	1999	NA
Poland	1999	0.0001
Portugal	1999	0.0002
Republic of Korea	1999	0.0002
Republic of Moldova	1999	0.0001
Romania	1999	0.0005
Russian Federation	1999	0.0001
Rwanda	1999	0.0003
Saudi Arabia	1999	0.0001
Senegal	1999	0.0005
Sierra Leone	1999	NA
Somalia	1999	0.0005
South Africa	1999	0.0002
Spain	1999	NA
Sri Lanka	1999	0.0002
Sudan	1999	0.0004
Swaziland	1999	NA
Syrian Arab Republic	1999	NA
Tajikistan	1999	NA
Thailand	1999	0.0002
Togo	1999	0.0002
Turkey	1999	NA
Uganda	1999	0.0007
Ukraine	1999	0.0002
United Kingdom of Great Britain and Northern Ireland	1999	0.0000
United Republic of Tanzania	1999	0.0007
United States of America	1999	0.0000
Uzbekistan	1999	0.0002
Venezuela (Bolivarian Republic of)	1999	0.0002
Viet Nam	1999	0.0007
Yemen	1999	0.0002
Zambia	1999	NA
Zimbabwe	1999	NA
Afghanistan	2000	0.0001
Algeria	2000	0.0003
Angola	2000	0.0006
Argentina	2000	0.0001
Azerbaijan	2000	0.0000
Bangladesh	2000	0.0003
Belarus	2000	NA
Benin	2000	0.0003
Bolivia (Plurinational State of)	2000	0.0008
Botswana	2000	0.0018
Brazil	2000	0.0005
Burkina Faso	2000	0.0001
Burundi	2000	NA
Cambodia	2000	0.0012
Cameroon	2000	0.0002
Central African Republic	2000	NA
Chad	2000	NA
Chile	2000	0.0001
China	2000	0.0002
China, Hong Kong SAR	2000	0.0003
Colombia	2000	0.0002
Congo	2000	NA
Côte d’Ivoire	2000	NA
Democratic People’s Republic of Korea	2000	0.0007
Democratic Republic of the Congo	2000	0.0008
Djibouti	2000	0.0019
Dominican Republic	2000	0.0003
Ecuador	2000	NA
Egypt	2000	0.0001
Ethiopia	2000	0.0005
France	2000	0.0000
Georgia	2000	0.0001
Germany	2000	NA
Ghana	2000	0.0004
Guatemala	2000	0.0002
Guinea	2000	0.0004
Haiti	2000	0.0007
Honduras	2000	0.0004
India	2000	0.0002
Indonesia	2000	NA
Iran (Islamic Republic of)	2000	0.0001
Iraq	2000	0.0001
Italy	2000	0.0000
Japan	2000	0.0001
Kazakhstan	2000	0.0006
Kenya	2000	0.0009
Kyrgyzstan	2000	0.0003
Lao People’s Democratic Republic	2000	0.0003
Lesotho	2000	0.0015
Liberia	2000	0.0004
Madagascar	2000	NA
Malawi	2000	0.0007
Malaysia	2000	0.0003
Mali	2000	0.0002
Mexico	2000	0.0001
Mongolia	2000	0.0006
Morocco	2000	0.0004
Mozambique	2000	NA
Myanmar	2000	0.0004
Namibia	2000	0.0021
Nepal	2000	0.0006
Nicaragua	2000	0.0003
Niger	2000	0.0002
Nigeria	2000	0.0001
Pakistan	2000	0.0000
Paraguay	2000	0.0002
Peru	2000	0.0009
Philippines	2000	NA
Poland	2000	0.0001
Portugal	2000	0.0002
Republic of Korea	2000	0.0002
Republic of Moldova	2000	0.0001
Romania	2000	0.0005
Russian Federation	2000	0.0000
Rwanda	2000	0.0005
Saudi Arabia	2000	0.0001
Senegal	2000	0.0006
Sierra Leone	2000	0.0006
Somalia	2000	0.0005
South Africa	2000	0.0003
Spain	2000	NA
Sri Lanka	2000	0.0002
Sudan	2000	0.0004
Swaziland	2000	0.0015
Syrian Arab Republic	2000	0.0001
Tajikistan	2000	NA
Thailand	2000	0.0003
Togo	2000	0.0002
Turkey	2000	NA
Uganda	2000	0.0007
Ukraine	2000	0.0002
United Kingdom of Great Britain and Northern Ireland	2000	0.0000
United Republic of Tanzania	2000	0.0007
United States of America	2000	0.0000
Uzbekistan	2000	0.0002
Venezuela (Bolivarian Republic of)	2000	NA
Viet Nam	2000	0.0007
Yemen	2000	0.0003
Zambia	2000	0.0013
Zimbabwe	2000	NA
Afghanistan	2001	0.0002
Algeria	2001	0.0002
Angola	2001	0.0005
Argentina	2001	0.0001
Azerbaijan	2001	NA
Bangladesh	2001	0.0003
Belarus	2001	NA
Benin	2001	0.0003
Bolivia (Plurinational State of)	2001	0.0008
Botswana	2001	0.0017
Brazil	2001	0.0002
Burkina Faso	2001	0.0001
Burundi	2001	0.0004
Cambodia	2001	0.0012
Cameroon	2001	0.0003
Central African Republic	2001	0.0004
Chad	2001	NA
Chile	2001	0.0001
China	2001	0.0002
China, Hong Kong SAR	2001	0.0003
Colombia	2001	0.0002
Congo	2001	0.0013
Côte d’Ivoire	2001	0.0006
Democratic People’s Republic of Korea	2001	0.0006
Democratic Republic of the Congo	2001	0.0008
Djibouti	2001	0.0018
Dominican Republic	2001	NA
Ecuador	2001	0.0003
Egypt	2001	0.0001
Ethiopia	2001	0.0005
France	2001	0.0000
Georgia	2001	0.0002
Germany	2001	0.0000
Ghana	2001	0.0004
Guatemala	2001	0.0001
Guinea	2001	0.0005
Haiti	2001	0.0006
Honduras	2001	0.0004
India	2001	0.0002
Indonesia	2001	0.0003
Iran (Islamic Republic of)	2001	0.0001
Iraq	2001	0.0001
Italy	2001	0.0000
Japan	2001	0.0001
Kazakhstan	2001	0.0006
Kenya	2001	0.0010
Kyrgyzstan	2001	0.0003
Lao People’s Democratic Republic	2001	0.0003
Lesotho	2001	NA
Liberia	2001	0.0003
Madagascar	2001	0.0007
Malawi	2001	0.0007
Malaysia	2001	0.0003
Mali	2001	NA
Mexico	2001	0.0001
Mongolia	2001	0.0007
Morocco	2001	0.0004
Mozambique	2001	NA
Myanmar	2001	0.0004
Namibia	2001	0.0023
Nepal	2001	0.0006
Nicaragua	2001	0.0003
Niger	2001	NA
Nigeria	2001	0.0001
Pakistan	2001	0.0001
Paraguay	2001	0.0002
Peru	2001	0.0008
Philippines	2001	NA
Poland	2001	0.0001
Portugal	2001	0.0002
Republic of Korea	2001	0.0003
Republic of Moldova	2001	0.0003
Romania	2001	0.0005
Russian Federation	2001	0.0002
Rwanda	2001	NA
Saudi Arabia	2001	0.0001
Senegal	2001	0.0006
Sierra Leone	2001	0.0006
Somalia	2001	0.0006
South Africa	2001	0.0005
Spain	2001	0.0001
Sri Lanka	2001	0.0002
Sudan	2001	0.0003
Swaziland	2001	0.0024
Syrian Arab Republic	2001	0.0001
Tajikistan	2001	0.0001
Thailand	2001	0.0005
Togo	2001	NA
Turkey	2001	NA
Uganda	2001	0.0007
Ukraine	2001	0.0002
United Kingdom of Great Britain and Northern Ireland	2001	0.0000
United Republic of Tanzania	2001	0.0007
United States of America	2001	0.0000
Uzbekistan	2001	0.0002
Venezuela (Bolivarian Republic of)	2001	NA
Viet Nam	2001	0.0007
Yemen	2001	0.0003
Zambia	2001	NA
Zimbabwe	2001	NA
Afghanistan	2002	0.0003
Algeria	2002	0.0003
Angola	2002	0.0012
Argentina	2002	0.0001
Azerbaijan	2002	0.0002
Bangladesh	2002	0.0003
Belarus	2002	0.0001
Benin	2002	0.0003
Bolivia (Plurinational State of)	2002	0.0008
Botswana	2002	0.0018
Brazil	2002	0.0002
Burkina Faso	2002	0.0001
Burundi	2002	0.0004
Cambodia	2002	0.0014
Cameroon	2002	0.0004
Central African Republic	2002	0.0007
Chad	2002	0.0004
Chile	2002	0.0001
China	2002	0.0002
China, Hong Kong SAR	2002	0.0003
Colombia	2002	0.0002
Congo	2002	NA
Côte d’Ivoire	2002	0.0007
Democratic People’s Republic of Korea	2002	0.0008
Democratic Republic of the Congo	2002	0.0009
Djibouti	2002	0.0017
Dominican Republic	2002	0.0002
Ecuador	2002	NA
Egypt	2002	0.0001
Ethiopia	2002	0.0005
France	2002	0.0000
Georgia	2002	0.0002
Germany	2002	0.0000
Ghana	2002	0.0004
Guatemala	2002	0.0002
Guinea	2002	0.0004
Haiti	2002	0.0007
Honduras	2002	0.0005
India	2002	0.0003
Indonesia	2002	0.0004
Iran (Islamic Republic of)	2002	0.0001
Iraq	2002	0.0002
Italy	2002	0.0000
Japan	2002	0.0001
Kazakhstan	2002	0.0006
Kenya	2002	0.0010
Kyrgyzstan	2002	0.0003
Lao People’s Democratic Republic	2002	0.0003
Lesotho	2002	0.0016
Liberia	2002	0.0006
Madagascar	2002	0.0007
Malawi	2002	NA
Malaysia	2002	0.0003
Mali	2002	0.0003
Mexico	2002	0.0001
Mongolia	2002	0.0007
Morocco	2002	0.0004
Mozambique	2002	NA
Myanmar	2002	0.0005
Namibia	2002	0.0024
Nepal	2002	0.0006
Nicaragua	2002	0.0003
Niger	2002	NA
Nigeria	2002	0.0002
Pakistan	2002	0.0001
Paraguay	2002	0.0002
Peru	2002	0.0002
Philippines	2002	NA
Poland	2002	0.0001
Portugal	2002	0.0002
Republic of Korea	2002	0.0002
Republic of Moldova	2002	0.0003
Romania	2002	0.0005
Russian Federation	2002	0.0002
Rwanda	2002	0.0001
Saudi Arabia	2002	0.0001
Senegal	2002	0.0006
Sierra Leone	2002	0.0007
Somalia	2002	0.0006
South Africa	2002	0.0017
Spain	2002	0.0001
Sri Lanka	2002	0.0002
Sudan	2002	0.0003
Swaziland	2002	0.0013
Syrian Arab Republic	2002	0.0001
Tajikistan	2002	0.0001
Thailand	2002	0.0004
Togo	2002	0.0002
Turkey	2002	NA
Uganda	2002	0.0007
Ukraine	2002	NA
United Kingdom of Great Britain and Northern Ireland	2002	0.0000
United Republic of Tanzania	2002	0.0007
United States of America	2002	0.0000
Uzbekistan	2002	0.0001
Venezuela (Bolivarian Republic of)	2002	0.0001
Viet Nam	2002	0.0007
Yemen	2002	0.0002
Zambia	2002	0.0015
Zimbabwe	2002	0.0009
Afghanistan	2003	0.0003
Algeria	2003	0.0002
Angola	2003	0.0012
Argentina	2003	0.0001
Azerbaijan	2003	0.0001
Bangladesh	2003	0.0004
Belarus	2003	0.0001
Benin	2003	0.0003
Bolivia (Plurinational State of)	2003	0.0007
Botswana	2003	0.0017
Brazil	2003	0.0002
Burkina Faso	2003	0.0001
Burundi	2003	0.0004
Cambodia	2003	0.0015
Cameroon	2003	0.0006
Central African Republic	2003	NA
Chad	2003	0.0004
Chile	2003	0.0001
China	2003	0.0002
China, Hong Kong SAR	2003	0.0003
Colombia	2003	0.0002
Congo	2003	NA
Côte d’Ivoire	2003	0.0007
Democratic People’s Republic of Korea	2003	0.0007
Democratic Republic of the Congo	2003	0.0010
Djibouti	2003	0.0016
Dominican Republic	2003	0.0003
Ecuador	2003	0.0001
Egypt	2003	0.0001
Ethiopia	2003	0.0006
France	2003	0.0000
Georgia	2003	0.0002
Germany	2003	0.0000
Ghana	2003	0.0004
Guatemala	2003	0.0001
Guinea	2003	0.0005
Haiti	2003	0.0008
Honduras	2003	0.0003
India	2003	0.0004
Indonesia	2003	0.0004
Iran (Islamic Republic of)	2003	0.0001
Iraq	2003	0.0001
Italy	2003	0.0000
Japan	2003	0.0001
Kazakhstan	2003	NA
Kenya	2003	0.0011
Kyrgyzstan	2003	0.0003
Lao People’s Democratic Republic	2003	0.0003
Lesotho	2003	0.0020
Liberia	2003	0.0004
Madagascar	2003	0.0008
Malawi	2003	0.0006
Malaysia	2003	0.0006
Mali	2003	0.0003
Mexico	2003	0.0001
Mongolia	2003	0.0006
Morocco	2003	0.0004
Mozambique	2003	NA
Myanmar	2003	0.0006
Namibia	2003	0.0028
Nepal	2003	0.0006
Nicaragua	2003	0.0003
Niger	2003	0.0004
Nigeria	2003	0.0002
Pakistan	2003	0.0001
Paraguay	2003	0.0002
Peru	2003	0.0001
Philippines	2003	0.0008
Poland	2003	0.0001
Portugal	2003	0.0002
Republic of Korea	2003	0.0002
Republic of Moldova	2003	0.0003
Romania	2003	0.0005
Russian Federation	2003	0.0002
Rwanda	2003	0.0003
Saudi Arabia	2003	0.0001
Senegal	2003	0.0006
Sierra Leone	2003	0.0007
Somalia	2003	0.0006
South Africa	2003	0.0024
Spain	2003	0.0000
Sri Lanka	2003	0.0002
Sudan	2003	0.0003
Swaziland	2003	0.0015
Syrian Arab Republic	2003	0.0001
Tajikistan	2003	NA
Thailand	2003	0.0004
Togo	2003	0.0002
Turkey	2003	NA
Uganda	2003	0.0008
Ukraine	2003	0.0003
United Kingdom of Great Britain and Northern Ireland	2003	0.0000
United Republic of Tanzania	2003	0.0007
United States of America	2003	0.0000
Uzbekistan	2003	0.0002
Venezuela (Bolivarian Republic of)	2003	0.0002
Viet Nam	2003	0.0007
Yemen	2003	0.0002
Zambia	2003	0.0017
Zimbabwe	2003	0.0011
Afghanistan	2004	0.0003
Algeria	2004	0.0002
Angola	2004	0.0013
Argentina	2004	0.0001
Azerbaijan	2004	0.0002
Bangladesh	2004	0.0004
Belarus	2004	0.0000
Benin	2004	0.0003
Bolivia (Plurinational State of)	2004	0.0007
Botswana	2004	0.0017
Brazil	2004	0.0002
Burkina Faso	2004	0.0001
Burundi	2004	0.0004
Cambodia	2004	0.0014
Cameroon	2004	0.0006
Central African Republic	2004	0.0008
Chad	2004	0.0002
Chile	2004	0.0001
China	2004	0.0003
China, Hong Kong SAR	2004	0.0002
Colombia	2004	0.0002
Congo	2004	0.0012
Côte d’Ivoire	2004	0.0007
Democratic People’s Republic of Korea	2004	0.0008
Democratic Republic of the Congo	2004	0.0012
Djibouti	2004	0.0014
Dominican Republic	2004	0.0003
Ecuador	2004	0.0003
Egypt	2004	0.0001
Ethiopia	2004	0.0006
France	2004	0.0000
Georgia	2004	0.0003
Germany	2004	0.0000
Ghana	2004	0.0003
Guatemala	2004	0.0002
Guinea	2004	0.0005
Haiti	2004	0.0008
Honduras	2004	0.0003
India	2004	0.0004
Indonesia	2004	0.0006
Iran (Islamic Republic of)	2004	0.0001
Iraq	2004	0.0001
Italy	2004	0.0000
Japan	2004	0.0001
Kazakhstan	2004	0.0005
Kenya	2004	0.0012
Kyrgyzstan	2004	0.0004
Lao People’s Democratic Republic	2004	0.0004
Lesotho	2004	0.0022
Liberia	2004	0.0008
Madagascar	2004	0.0006
Malawi	2004	0.0007
Malaysia	2004	0.0006
Mali	2004	0.0003
Mexico	2004	0.0001
Mongolia	2004	0.0007
Morocco	2004	0.0004
Mozambique	2004	NA
Myanmar	2004	0.0006
Namibia	2004	0.0026
Nepal	2004	0.0006
Nicaragua	2004	0.0002
Niger	2004	NA
Nigeria	2004	0.0002
Pakistan	2004	0.0002
Paraguay	2004	0.0002
Peru	2004	0.0007
Philippines	2004	0.0009
Poland	2004	0.0001
Portugal	2004	0.0001
Republic of Korea	2004	0.0002
Republic of Moldova	2004	0.0004
Romania	2004	0.0005
Russian Federation	2004	0.0002
Rwanda	2004	0.0004
Saudi Arabia	2004	0.0001
Senegal	2004	0.0006
Sierra Leone	2004	0.0008
Somalia	2004	0.0008
South Africa	2004	0.0027
Spain	2004	0.0000
Sri Lanka	2004	0.0002
Sudan	2004	0.0003
Swaziland	2004	0.0017
Syrian Arab Republic	2004	0.0001
Tajikistan	2004	0.0001
Thailand	2004	0.0004
Togo	2004	0.0003
Turkey	2004	0.0000
Uganda	2004	0.0008
Ukraine	2004	NA
United Kingdom of Great Britain and Northern Ireland	2004	0.0000
United Republic of Tanzania	2004	0.0007
United States of America	2004	0.0000
Uzbekistan	2004	0.0002
Venezuela (Bolivarian Republic of)	2004	0.0001
Viet Nam	2004	0.0007
Yemen	2004	0.0002
Zambia	2004	0.0015
Zimbabwe	2004	0.0011
Afghanistan	2005	0.0004
Algeria	2005	0.0003
Angola	2005	0.0012
Argentina	2005	0.0001
Azerbaijan	2005	0.0002
Bangladesh	2005	0.0006
Belarus	2005	NA
Benin	2005	0.0003
Bolivia (Plurinational State of)	2005	0.0007
Botswana	2005	0.0017
Brazil	2005	0.0002
Burkina Faso	2005	0.0002
Burundi	2005	0.0004
Cambodia	2005	0.0016
Cameroon	2005	0.0007
Central African Republic	2005	0.0005
Chad	2005	0.0003
Chile	2005	0.0001
China	2005	0.0004
China, Hong Kong SAR	2005	0.0008
Colombia	2005	0.0002
Congo	2005	NA
Côte d’Ivoire	2005	0.0007
Democratic People’s Republic of Korea	2005	0.0007
Democratic Republic of the Congo	2005	0.0012
Djibouti	2005	0.0014
Dominican Republic	2005	0.0003
Ecuador	2005	0.0002
Egypt	2005	0.0001
Ethiopia	2005	0.0005
France	2005	0.0000
Georgia	2005	0.0003
Germany	2005	0.0000
Ghana	2005	0.0004
Guatemala	2005	0.0002
Guinea	2005	0.0006
Haiti	2005	0.0008
Honduras	2005	0.0003
India	2005	0.0005
Indonesia	2005	0.0007
Iran (Islamic Republic of)	2005	0.0001
Iraq	2005	0.0001
Italy	2005	0.0000
Japan	2005	0.0001
Kazakhstan	2005	0.0005
Kenya	2005	0.0011
Kyrgyzstan	2005	0.0004
Lao People’s Democratic Republic	2005	0.0005
Lesotho	2005	0.0022
Liberia	2005	0.0007
Madagascar	2005	0.0006
Malawi	2005	0.0007
Malaysia	2005	0.0006
Mali	2005	0.0003
Mexico	2005	0.0001
Mongolia	2005	0.0007
Morocco	2005	0.0004
Mozambique	2005	NA
Myanmar	2005	0.0007
Namibia	2005	0.0026
Nepal	2005	0.0006
Nicaragua	2005	0.0002
Niger	2005	0.0004
Nigeria	2005	0.0003
Pakistan	2005	0.0003
Paraguay	2005	0.0002
Peru	2005	0.0007
Philippines	2005	0.0010
Poland	2005	0.0001
Portugal	2005	0.0001
Republic of Korea	2005	0.0002
Republic of Moldova	2005	0.0005
Romania	2005	0.0005
Russian Federation	2005	NA
Rwanda	2005	0.0004
Saudi Arabia	2005	0.0001
Senegal	2005	0.0006
Sierra Leone	2005	0.0009
Somalia	2005	0.0008
South Africa	2005	0.0026
Spain	2005	0.0001
Sri Lanka	2005	0.0002
Sudan	2005	0.0003
Swaziland	2005	0.0020
Syrian Arab Republic	2005	0.0001
Tajikistan	2005	0.0003
Thailand	2005	0.0004
Togo	2005	0.0003
Turkey	2005	0.0001
Uganda	2005	0.0007
Ukraine	2005	NA
United Kingdom of Great Britain and Northern Ireland	2005	0.0000
United Republic of Tanzania	2005	0.0007
United States of America	2005	0.0000
Uzbekistan	2005	0.0002
Venezuela (Bolivarian Republic of)	2005	0.0001
Viet Nam	2005	0.0007
Yemen	2005	0.0002
Zambia	2005	0.0013
Zimbabwe	2005	0.0010
Afghanistan	2006	0.0005
Algeria	2006	0.0002
Angola	2006	0.0013
Argentina	2006	0.0002
Azerbaijan	2006	0.0005
Bangladesh	2006	0.0010
Belarus	2006	0.0005
Benin	2006	0.0003
Bolivia (Plurinational State of)	2006	0.0006
Botswana	2006	0.0017
Brazil	2006	0.0004
Burkina Faso	2006	0.0002
Burundi	2006	0.0004
Cambodia	2006	0.0014
Cameroon	2006	0.0007
Central African Republic	2006	0.0016
Chad	2006	NA
Chile	2006	0.0001
China	2006	0.0004
China, Hong Kong SAR	2006	0.0007
Colombia	2006	0.0002
Congo	2006	0.0009
Côte d’Ivoire	2006	0.0007
Democratic People’s Republic of Korea	2006	0.0008
Democratic Republic of the Congo	2006	0.0011
Djibouti	2006	0.0015
Dominican Republic	2006	0.0003
Ecuador	2006	0.0002
Egypt	2006	0.0001
Ethiopia	2006	0.0005
France	2006	0.0001
Georgia	2006	0.0010
Germany	2006	0.0001
Ghana	2006	0.0004
Guatemala	2006	NA
Guinea	2006	0.0006
Haiti	2006	0.0015
Honduras	2006	0.0004
India	2006	0.0005
Indonesia	2006	0.0008
Iran (Islamic Republic of)	2006	0.0001
Iraq	2006	0.0003
Italy	2006	0.0001
Japan	2006	0.0002
Kazakhstan	2006	0.0017
Kenya	2006	0.0011
Kyrgyzstan	2006	0.0004
Lao People’s Democratic Republic	2006	0.0005
Lesotho	2006	0.0021
Liberia	2006	0.0013
Madagascar	2006	0.0008
Malawi	2006	0.0006
Malaysia	2006	0.0003
Mali	2006	0.0004
Mexico	2006	0.0002
Mongolia	2006	0.0008
Morocco	2006	0.0009
Mozambique	2006	NA
Myanmar	2006	0.0008
Namibia	2006	0.0026
Nepal	2006	0.0005
Nicaragua	2006	0.0002
Niger	2006	0.0004
Nigeria	2006	0.0003
Pakistan	2006	0.0004
Paraguay	2006	0.0004
Peru	2006	0.0007
Philippines	2006	0.0010
Poland	2006	0.0002
Portugal	2006	0.0003
Republic of Korea	2006	0.0007
Republic of Moldova	2006	0.0005
Romania	2006	0.0009
Russian Federation	2006	0.0002
Rwanda	2006	0.0004
Saudi Arabia	2006	0.0001
Senegal	2006	0.0006
Sierra Leone	2006	0.0009
Somalia	2006	0.0013
South Africa	2006	0.0056
Spain	2006	0.0002
Sri Lanka	2006	0.0004
Sudan	2006	0.0003
Swaziland	2006	0.0071
Syrian Arab Republic	2006	0.0002
Tajikistan	2006	NA
Thailand	2006	0.0004
Togo	2006	0.0004
Turkey	2006	0.0003
Uganda	2006	0.0007
Ukraine	2006	0.0004
United Kingdom of Great Britain and Northern Ireland	2006	0.0001
United Republic of Tanzania	2006	0.0006
United States of America	2006	0.0000
Uzbekistan	2006	0.0007
Venezuela (Bolivarian Republic of)	2006	0.0002
Viet Nam	2006	0.0007
Yemen	2006	0.0002
Zambia	2006	0.0012
Zimbabwe	2006	0.0034
Afghanistan	2007	0.0005
Algeria	2007	0.0002
Angola	2007	0.0012
Argentina	2007	0.0002
Azerbaijan	2007	NA
Bangladesh	2007	0.0007
Belarus	2007	0.0005
Benin	2007	0.0003
Bolivia (Plurinational State of)	2007	0.0006
Botswana	2007	0.0016
Brazil	2007	0.0004
Burkina Faso	2007	0.0003
Burundi	2007	0.0004
Cambodia	2007	0.0014
Cameroon	2007	0.0007
Central African Republic	2007	NA
Chad	2007	NA
Chile	2007	0.0001
China	2007	0.0003
China, Hong Kong SAR	2007	0.0007
Colombia	2007	0.0002
Congo	2007	0.0009
Côte d’Ivoire	2007	0.0008
Democratic People’s Republic of Korea	2007	0.0010
Democratic Republic of the Congo	2007	0.0012
Djibouti	2007	0.0035
Dominican Republic	2007	0.0002
Ecuador	2007	0.0002
Egypt	2007	0.0001
Ethiopia	2007	0.0005
France	2007	0.0001
Georgia	2007	0.0009
Germany	2007	0.0001
Ghana	2007	0.0003
Guatemala	2007	0.0002
Guinea	2007	0.0006
Haiti	2007	0.0015
Honduras	2007	0.0004
India	2007	0.0010
Indonesia	2007	0.0012
Iran (Islamic Republic of)	2007	0.0001
Iraq	2007	0.0003
Italy	2007	0.0000
Japan	2007	0.0002
Kazakhstan	2007	0.0014
Kenya	2007	0.0010
Kyrgyzstan	2007	0.0003
Lao People’s Democratic Republic	2007	0.0005
Lesotho	2007	0.0004
Liberia	2007	NA
Madagascar	2007	0.0011
Malawi	2007	0.0006
Malaysia	2007	0.0006
Mali	2007	0.0004
Mexico	2007	0.0002
Mongolia	2007	0.0007
Morocco	2007	0.0008
Mozambique	2007	NA
Myanmar	2007	0.0008
Namibia	2007	0.0024
Nepal	2007	0.0006
Nicaragua	2007	0.0003
Niger	2007	0.0004
Nigeria	2007	0.0003
Pakistan	2007	0.0005
Paraguay	2007	0.0004
Peru	2007	0.0006
Philippines	2007	0.0010
Poland	2007	0.0002
Portugal	2007	0.0003
Republic of Korea	2007	0.0007
Republic of Moldova	2007	0.0011
Romania	2007	0.0009
Russian Federation	2007	0.0008
Rwanda	2007	0.0004
Saudi Arabia	2007	0.0001
Senegal	2007	0.0006
Sierra Leone	2007	0.0017
Somalia	2007	0.0007
South Africa	2007	0.0058
Spain	2007	0.0002
Sri Lanka	2007	0.0004
Sudan	2007	0.0004
Swaziland	2007	NA
Syrian Arab Republic	2007	0.0002
Tajikistan	2007	0.0009
Thailand	2007	0.0004
Togo	2007	0.0004
Turkey	2007	0.0003
Uganda	2007	0.0007
Ukraine	2007	0.0005
United Kingdom of Great Britain and Northern Ireland	2007	0.0002
United Republic of Tanzania	2007	0.0006
United States of America	2007	0.0000
Uzbekistan	2007	0.0007
Venezuela (Bolivarian Republic of)	2007	0.0002
Viet Nam	2007	0.0006
Yemen	2007	0.0002
Zambia	2007	0.0011
Zimbabwe	2007	0.0031
Afghanistan	2008	0.0005
Algeria	2008	0.0002
Angola	2008	0.0012
Argentina	2008	0.0002
Azerbaijan	2008	NA
Bangladesh	2008	0.0013
Belarus	2008	0.0005
Benin	2008	0.0003
Bolivia (Plurinational State of)	2008	0.0006
Botswana	2008	0.0040
Brazil	2008	0.0004
Burkina Faso	2008	0.0002
Burundi	2008	0.0004
Cambodia	2008	0.0014
Cameroon	2008	0.0007
Central African Republic	2008	0.0010
Chad	2008	NA
Chile	2008	0.0001
China	2008	0.0003
China, Hong Kong SAR	2008	0.0007
Colombia	2008	0.0002
Congo	2008	0.0009
Côte d’Ivoire	2008	0.0008
Democratic People’s Republic of Korea	2008	0.0029
Democratic Republic of the Congo	2008	0.0012
Djibouti	2008	0.0017
Dominican Republic	2008	0.0003
Ecuador	2008	0.0002
Egypt	2008	0.0001
Ethiopia	2008	0.0005
France	2008	0.0001
Georgia	2008	0.0009
Germany	2008	0.0000
Ghana	2008	NA
Guatemala	2008	0.0002
Guinea	2008	0.0006
Haiti	2008	0.0015
Honduras	2008	0.0004
India	2008	0.0005
Indonesia	2008	0.0013
Iran (Islamic Republic of)	2008	0.0001
Iraq	2008	0.0003
Italy	2008	0.0001
Japan	2008	0.0002
Kazakhstan	2008	0.0013
Kenya	2008	0.0020
Kyrgyzstan	2008	0.0010
Lao People’s Democratic Republic	2008	0.0005
Lesotho	2008	0.0020
Liberia	2008	0.0008
Madagascar	2008	0.0008
Malawi	2008	0.0005
Malaysia	2008	0.0006
Mali	2008	0.0004
Mexico	2008	0.0001
Mongolia	2008	0.0007
Morocco	2008	0.0008
Mozambique	2008	NA
Myanmar	2008	0.0008
Namibia	2008	0.0023
Nepal	2008	0.0004
Nicaragua	2008	0.0003
Niger	2008	0.0004
Nigeria	2008	0.0003
Pakistan	2008	0.0006
Paraguay	2008	0.0003
Peru	2008	0.0006
Philippines	2008	0.0009
Poland	2008	0.0002
Portugal	2008	0.0002
Republic of Korea	2008	0.0007
Republic of Moldova	2008	0.0011
Romania	2008	0.0009
Russian Federation	2008	0.0008
Rwanda	2008	0.0004
Saudi Arabia	2008	0.0001
Senegal	2008	0.0006
Sierra Leone	2008	NA
Somalia	2008	0.0007
South Africa	2008	0.0064
Spain	2008	0.0001
Sri Lanka	2008	0.0004
Sudan	2008	0.0005
Swaziland	2008	0.0027
Syrian Arab Republic	2008	0.0002
Tajikistan	2008	0.0008
Thailand	2008	0.0004
Togo	2008	0.0004
Turkey	2008	0.0002
Uganda	2008	0.0007
Ukraine	2008	0.0008
United Kingdom of Great Britain and Northern Ireland	2008	0.0001
United Republic of Tanzania	2008	0.0014
United States of America	2008	0.0000
Uzbekistan	2008	0.0006
Venezuela (Bolivarian Republic of)	2008	0.0002
Viet Nam	2008	0.0006
Yemen	2008	0.0002
Zambia	2008	0.0011
Zimbabwe	2008	0.0028
Afghanistan	2009	0.0005
Algeria	2009	0.0002
Angola	2009	0.0012
Argentina	2009	0.0002
Azerbaijan	2009	0.0002
Bangladesh	2009	NA
Belarus	2009	0.0002
Benin	2009	0.0003
Bolivia (Plurinational State of)	2009	0.0008
Botswana	2009	0.0041
Brazil	2009	0.0004
Burkina Faso	2009	0.0002
Burundi	2009	0.0004
Cambodia	2009	0.0013
Cameroon	2009	0.0007
Central African Republic	2009	0.0012
Chad	2009	0.0003
Chile	2009	0.0001
China	2009	0.0007
China, Hong Kong SAR	2009	0.0007
Colombia	2009	0.0002
Congo	2009	0.0009
Côte d’Ivoire	2009	0.0008
Democratic People’s Republic of Korea	2009	0.0030
Democratic Republic of the Congo	2009	0.0012
Djibouti	2009	0.0017
Dominican Republic	2009	0.0002
Ecuador	2009	0.0002
Egypt	2009	0.0001
Ethiopia	2009	0.0005
France	2009	0.0000
Georgia	2009	0.0010
Germany	2009	0.0000
Ghana	2009	0.0003
Guatemala	2009	0.0002
Guinea	2009	0.0005
Haiti	2009	NA
Honduras	2009	0.0004
India	2009	0.0005
Indonesia	2009	0.0012
Iran (Islamic Republic of)	2009	0.0001
Iraq	2009	0.0003
Italy	2009	0.0000
Japan	2009	0.0002
Kazakhstan	2009	0.0011
Kenya	2009	0.0022
Kyrgyzstan	2009	0.0010
Lao People’s Democratic Republic	2009	0.0005
Lesotho	2009	0.0058
Liberia	2009	0.0011
Madagascar	2009	0.0010
Malawi	2009	0.0005
Malaysia	2009	NA
Mali	2009	0.0004
Mexico	2009	0.0001
Mongolia	2009	0.0007
Morocco	2009	0.0008
Mozambique	2009	NA
Myanmar	2009	0.0008
Namibia	2009	0.0021
Nepal	2009	0.0006
Nicaragua	2009	0.0004
Niger	2009	0.0004
Nigeria	2009	0.0003
Pakistan	2009	0.0006
Paraguay	2009	0.0003
Peru	2009	NA
Philippines	2009	0.0010
Poland	2009	0.0002
Portugal	2009	0.0002
Republic of Korea	2009	0.0007
Republic of Moldova	2009	0.0011
Romania	2009	0.0008
Russian Federation	2009	0.0008
Rwanda	2009	0.0004
Saudi Arabia	2009	0.0001
Senegal	2009	0.0006
Sierra Leone	2009	0.0011
Somalia	2009	0.0006
South Africa	2009	0.0075
Spain	2009	0.0000
Sri Lanka	2009	0.0004
Sudan	2009	0.0005
Swaziland	2009	0.0030
Syrian Arab Republic	2009	0.0002
Tajikistan	2009	0.0008
Thailand	2009	0.0005
Togo	2009	0.0004
Turkey	2009	0.0002
Uganda	2009	0.0007
Ukraine	2009	0.0007
United Kingdom of Great Britain and Northern Ireland	2009	0.0001
United Republic of Tanzania	2009	0.0014
United States of America	2009	0.0000
Uzbekistan	2009	0.0006
Venezuela (Bolivarian Republic of)	2009	0.0002
Viet Nam	2009	0.0006
Yemen	2009	0.0002
Zambia	2009	0.0010
Zimbabwe	2009	0.0032
Afghanistan	2010	0.0005
Algeria	2010	0.0002
Angola	2010	0.0011
Argentina	2010	0.0002
Azerbaijan	2010	0.0005
Bangladesh	2010	0.0010
Belarus	2010	0.0005
Benin	2010	0.0003
Bolivia (Plurinational State of)	2010	0.0008
Botswana	2010	0.0033
Brazil	2010	0.0004
Burkina Faso	2010	0.0002
Burundi	2010	0.0008
Cambodia	2010	0.0012
Cameroon	2010	0.0007
Central African Republic	2010	0.0014
Chad	2010	0.0007
Chile	2010	0.0001
China	2010	0.0006
China, Hong Kong SAR	2010	0.0007
Colombia	2010	0.0002
Congo	2010	0.0008
Côte d’Ivoire	2010	0.0007
Democratic People’s Republic of Korea	2010	0.0033
Democratic Republic of the Congo	2010	0.0012
Djibouti	2010	0.0014
Dominican Republic	2010	0.0002
Ecuador	2010	0.0002
Egypt	2010	0.0001
Ethiopia	2010	0.0005
France	2010	0.0000
Georgia	2010	0.0010
Germany	2010	0.0000
Ghana	2010	0.0005
Guatemala	2010	0.0001
Guinea	2010	0.0006
Haiti	2010	0.0014
Honduras	2010	0.0004
India	2010	0.0005
Indonesia	2010	0.0012
Iran (Islamic Republic of)	2010	0.0001
Iraq	2010	0.0003
Italy	2010	0.0000
Japan	2010	0.0002
Kazakhstan	2010	0.0010
Kenya	2010	0.0021
Kyrgyzstan	2010	0.0010
Lao People’s Democratic Republic	2010	0.0006
Lesotho	2010	0.0056
Liberia	2010	0.0016
Madagascar	2010	0.0011
Malawi	2010	0.0005
Malaysia	2010	0.0006
Mali	2010	0.0003
Mexico	2010	0.0002
Mongolia	2010	0.0016
Morocco	2010	0.0009
Mozambique	2010	NA
Myanmar	2010	0.0008
Namibia	2010	0.0020
Nepal	2010	0.0006
Nicaragua	2010	0.0002
Niger	2010	0.0004
Nigeria	2010	0.0003
Pakistan	2010	0.0007
Paraguay	2010	0.0003
Peru	2010	NA
Philippines	2010	0.0010
Poland	2010	0.0002
Portugal	2010	0.0002
Republic of Korea	2010	0.0008
Republic of Moldova	2010	0.0010
Romania	2010	0.0007
Russian Federation	2010	0.0007
Rwanda	2010	0.0003
Saudi Arabia	2010	0.0002
Senegal	2010	0.0006
Sierra Leone	2010	0.0012
Somalia	2010	0.0005
South Africa	2010	0.0071
Spain	2010	0.0001
Sri Lanka	2010	0.0004
Sudan	2010	0.0002
Swaziland	2010	0.0081
Syrian Arab Republic	2010	0.0002
Tajikistan	2010	0.0008
Thailand	2010	0.0005
Togo	2010	0.0003
Turkey	2010	0.0002
Uganda	2010	0.0007
Ukraine	2010	0.0001
United Kingdom of Great Britain and Northern Ireland	2010	0.0001
United Republic of Tanzania	2010	0.0013
United States of America	2010	0.0000
Uzbekistan	2010	0.0006
Venezuela (Bolivarian Republic of)	2010	0.0002
Viet Nam	2010	0.0006
Yemen	2010	0.0002
Zambia	2010	NA
Zimbabwe	2010	0.0033
Afghanistan	2011	0.0005
Algeria	2011	0.0002
Angola	2011	0.0013
Argentina	2011	0.0002
Azerbaijan	2011	0.0001
Bangladesh	2011	0.0010
Belarus	2011	0.0004
Benin	2011	0.0003
Bolivia (Plurinational State of)	2011	0.0008
Botswana	2011	0.0030
Brazil	2011	0.0004
Burkina Faso	2011	0.0002
Burundi	2011	0.0007
Cambodia	2011	0.0011
Cameroon	2011	0.0007
Central African Republic	2011	0.0012
Chad	2011	0.0007
Chile	2011	0.0001
China	2011	0.0006
China, Hong Kong SAR	2011	0.0006
Colombia	2011	0.0002
Congo	2011	0.0009
Côte d’Ivoire	2011	0.0007
Democratic People’s Republic of Korea	2011	0.0035
Democratic Republic of the Congo	2011	0.0011
Djibouti	2011	0.0016
Dominican Republic	2011	0.0002
Ecuador	2011	0.0003
Egypt	2011	0.0001
Ethiopia	2011	0.0006
France	2011	0.0000
Georgia	2011	0.0010
Germany	2011	0.0000
Ghana	2011	0.0006
Guatemala	2011	0.0001
Guinea	2011	0.0010
Haiti	2011	0.0015
Honduras	2011	0.0004
India	2011	0.0005
Indonesia	2011	0.0013
Iran (Islamic Republic of)	2011	0.0001
Iraq	2011	0.0003
Italy	2011	0.0000
Japan	2011	0.0002
Kazakhstan	2011	0.0009
Kenya	2011	0.0020
Kyrgyzstan	2011	0.0003
Lao People’s Democratic Republic	2011	0.0006
Lesotho	2011	0.0054
Liberia	2011	0.0019
Madagascar	2011	0.0008
Malawi	2011	0.0005
Malaysia	2011	0.0007
Mali	2011	0.0003
Mexico	2011	0.0002
Mongolia	2011	0.0014
Morocco	2011	0.0009
Mozambique	2011	NA
Myanmar	2011	0.0008
Namibia	2011	0.0020
Nepal	2011	0.0006
Nicaragua	2011	0.0003
Niger	2011	0.0004
Nigeria	2011	0.0003
Pakistan	2011	0.0007
Paraguay	2011	0.0003
Peru	2011	NA
Philippines	2011	0.0010
Poland	2011	0.0002
Portugal	2011	0.0002
Republic of Korea	2011	0.0008
Republic of Moldova	2011	0.0011
Romania	2011	0.0007
Russian Federation	2011	0.0007
Rwanda	2011	0.0003
Saudi Arabia	2011	0.0001
Senegal	2011	0.0006
Sierra Leone	2011	0.0013
Somalia	2011	0.0008
South Africa	2011	0.0056
Spain	2011	0.0001
Sri Lanka	2011	0.0005
Sudan	2011	0.0005
Swaziland	2011	0.0046
Syrian Arab Republic	2011	0.0002
Tajikistan	2011	0.0008
Thailand	2011	0.0005
Togo	2011	0.0003
Turkey	2011	0.0002
Uganda	2011	0.0007
Ukraine	2011	0.0002
United Kingdom of Great Britain and Northern Ireland	2011	0.0001
United Republic of Tanzania	2011	0.0006
United States of America	2011	0.0000
Uzbekistan	2011	0.0005
Venezuela (Bolivarian Republic of)	2011	0.0002
Viet Nam	2011	0.0006
Yemen	2011	0.0001
Zambia	2011	0.0031
Zimbabwe	2011	0.0028
Afghanistan	2012	0.0005
Algeria	2012	0.0002
Angola	2012	0.0010
Argentina	2012	0.0002
Azerbaijan	2012	0.0005
Bangladesh	2012	0.0010
Belarus	2012	0.0004
Benin	2012	0.0003
Bolivia (Plurinational State of)	2012	0.0007
Botswana	2012	0.0029
Brazil	2012	0.0004
Burkina Faso	2012	0.0002
Burundi	2012	0.0007
Cambodia	2012	0.0010
Cameroon	2012	0.0007
Central African Republic	2012	0.0010
Chad	2012	0.0007
Chile	2012	0.0001
China	2012	0.0006
China, Hong Kong SAR	2012	0.0006
Colombia	2012	0.0002
Congo	2012	0.0009
Côte d’Ivoire	2012	0.0007
Democratic People’s Republic of Korea	2012	0.0034
Democratic Republic of the Congo	2012	0.0011
Djibouti	2012	0.0014
Dominican Republic	2012	0.0002
Ecuador	2012	0.0003
Egypt	2012	0.0001
Ethiopia	2012	NA
France	2012	0.0000
Georgia	2012	0.0009
Germany	2012	0.0000
Ghana	2012	0.0006
Guatemala	2012	NA
Guinea	2012	0.0004
Haiti	2012	0.0016
Honduras	2012	0.0004
India	2012	0.0005
Indonesia	2012	0.0013
Iran (Islamic Republic of)	2012	0.0001
Iraq	2012	0.0003
Italy	2012	0.0000
Japan	2012	0.0002
Kazakhstan	2012	0.0008
Kenya	2012	0.0019
Kyrgyzstan	2012	0.0011
Lao People’s Democratic Republic	2012	0.0006
Lesotho	2012	0.0050
Liberia	2012	0.0019
Madagascar	2012	0.0008
Malawi	2012	0.0004
Malaysia	2012	0.0007
Mali	2012	0.0003
Mexico	2012	0.0002
Mongolia	2012	0.0014
Morocco	2012	0.0008
Mozambique	2012	NA
Myanmar	2012	0.0008
Namibia	2012	0.0044
Nepal	2012	0.0005
Nicaragua	2012	0.0000
Niger	2012	0.0004
Nigeria	2012	0.0003
Pakistan	2012	0.0007
Paraguay	2012	0.0003
Peru	2012	NA
Philippines	2012	0.0010
Poland	2012	0.0002
Portugal	2012	0.0002
Republic of Korea	2012	0.0008
Republic of Moldova	2012	0.0011
Romania	2012	0.0006
Russian Federation	2012	0.0007
Rwanda	2012	0.0003
Saudi Arabia	2012	0.0001
Senegal	2012	0.0006
Sierra Leone	2012	0.0016
Somalia	2012	0.0008
South Africa	2012	0.0057
Spain	2012	0.0001
Sri Lanka	2012	0.0004
Sudan	2012	0.0002
Swaziland	2012	0.0056
Syrian Arab Republic	2012	0.0001
Tajikistan	2012	0.0007
Thailand	2012	0.0005
Togo	2012	0.0003
Turkey	2012	0.0002
Uganda	2012	0.0007
Ukraine	2012	0.0006
United Kingdom of Great Britain and Northern Ireland	2012	0.0001
United Republic of Tanzania	2012	0.0006
United States of America	2012	0.0000
Uzbekistan	2012	0.0005
Venezuela (Bolivarian Republic of)	2012	0.0002
Viet Nam	2012	0.0006
Yemen	2012	0.0004
Zambia	2012	0.0028
Zimbabwe	2012	0.0025
Afghanistan	2013	NA
Algeria	2013	0.0002
Angola	2013	0.0010
Argentina	2013	0.0002
Azerbaijan	2013	0.0005
Bangladesh	2013	0.0012
Belarus	2013	0.0005
Benin	2013	0.0003
Bolivia (Plurinational State of)	2013	0.0008
Botswana	2013	0.0034
Brazil	2013	0.0004
Burkina Faso	2013	0.0002
Burundi	2013	0.0007
Cambodia	2013	0.0009
Cameroon	2013	NA
Central African Republic	2013	0.0009
Chad	2013	0.0009
Chile	2013	0.0001
China	2013	0.0006
China, Hong Kong SAR	2013	0.0007
Colombia	2013	0.0002
Congo	2013	0.0009
Côte d’Ivoire	2013	0.0008
Democratic People’s Republic of Korea	2013	0.0036
Democratic Republic of the Congo	2013	0.0011
Djibouti	2013	0.0013
Dominican Republic	2013	0.0003
Ecuador	2013	0.0003
Egypt	2013	0.0001
Ethiopia	2013	NA
France	2013	0.0001
Georgia	2013	0.0008
Germany	2013	0.0001
Ghana	2013	0.0006
Guatemala	2013	0.0001
Guinea	2013	0.0010
Haiti	2013	0.0017
Honduras	2013	0.0004
India	2013	NA
Indonesia	2013	0.0013
Iran (Islamic Republic of)	2013	0.0001
Iraq	2013	0.0003
Italy	2013	0.0000
Japan	2013	0.0002
Kazakhstan	2013	0.0012
Kenya	2013	0.0017
Kyrgyzstan	2013	0.0011
Lao People’s Democratic Republic	2013	0.0006
Lesotho	2013	0.0043
Liberia	2013	0.0009
Madagascar	2013	NA
Malawi	2013	0.0010
Malaysia	2013	0.0008
Mali	2013	0.0002
Mexico	2013	0.0002
Mongolia	2013	0.0015
Morocco	2013	0.0008
Mozambique	2013	NA
Myanmar	2013	NA
Namibia	2013	0.0041
Nepal	2013	0.0005
Nicaragua	2013	0.0003
Niger	2013	0.0004
Nigeria	2013	0.0006
Pakistan	2013	NA
Paraguay	2013	0.0003
Peru	2013	0.0009
Philippines	2013	0.0010
Poland	2013	0.0002
Portugal	2013	0.0002
Republic of Korea	2013	0.0008
Republic of Moldova	2013	0.0013
Romania	2013	0.0007
Russian Federation	2013	0.0006
Rwanda	2013	0.0005
Saudi Arabia	2013	0.0001
Senegal	2013	NA
Sierra Leone	2013	0.0012
Somalia	2013	0.0006
South Africa	2013	0.0059
Spain	2013	0.0001
Sri Lanka	2013	0.0004
Sudan	2013	NA
Swaziland	2013	0.0054
Syrian Arab Republic	2013	0.0001
Tajikistan	2013	0.0006
Thailand	2013	NA
Togo	2013	0.0004
Turkey	2013	0.0002
Uganda	2013	0.0007
Ukraine	2013	0.0008
United Kingdom of Great Britain and Northern Ireland	2013	0.0001
United Republic of Tanzania	2013	NA
United States of America	2013	0.0000
Uzbekistan	2013	0.0007
Venezuela (Bolivarian Republic of)	2013	0.0002
Viet Nam	2013	0.0006
Yemen	2013	0.0004
Zambia	2013	0.0028
Zimbabwe	2013	0.0023

Data 607 Week 3 - Tuberculosis Rates

Armenoush Aslanian-Persico

0. Optional: Download CSS Stylesheet here.

Save into working directory.

1. Load packages

2. Create a CSV file using SQL.

Resulting CSV file was uploaded to GitHub for next step.

3. Import CSV file from GitHub.

Indicate “header=F” for missing header row.

4. View data frame dimensions, head, structure.

This returns 1900 records for 9 variables and shows we need to convert character columns to numeric.

5. Convert character columns to numeric. This converts NA values to 0.

6. View head and structure.

7. Group by year, create bar plot.

Check against Excel and SQL:

1995: 494742 total cases

1996: 615510 total cases

8. Rename column headers.

9. What kind of analysis and reporting could be done with this data?

We could see trends of increasing rates in specific countries and adjust public policy and funding to address those issues. We could also see which countries are missing data.

10. Table output.

Format table with Kable package.