Parsed sub-national area statements

Data license: Public Domain (CDC) · Data source: CDC Travelers' Health (Yellow Fever & Malaria, by country)

150 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: seq, scope, elev_max_m

tier 3

polarity 2

area_statement_id ▼ record_id seq raw_text polarity tier scope place_name elev_max_m elev_min_m season_text
1 8 8 0 All include prophylaxis all        
2 9 9 0 All include prophylaxis all        
3 11 11 0 All include prophylaxis all        
4 12 12 0 All include prophylaxis all        
5 13 13 0 All include prophylaxis all        
6 14 14 0 All include prophylaxis all        
7 15 15 0 All include prophylaxis all        
8 16 16 0 All include prophylaxis all        
9 17 17 0 All include prophylaxis all        
10 18 18 0 All; except in the regions of Dakhlet Nouadhibou and Tiris Zemmour where there is no transmission include prophylaxis area        
11 19 19 0 All include prophylaxis all        
12 20 20 0 All include prophylaxis all        
13 22 22 0 All include prophylaxis all        
14 23 23 0 All include prophylaxis all        
15 24 24 0 All include prophylaxis all        
16 25 25 0 All include prophylaxis all        
17 26 26 0 All include prophylaxis all        
18 27 27 0 All include prophylaxis all        
19 28 28 0 All include prophylaxis all        
20 29 29 0 All include prophylaxis all        
21 30 30 0 All include prophylaxis all        
22 31 31 0 All include prophylaxis all        
23 32 32 0 All include prophylaxis all        
24 33 33 0 All include prophylaxis all        
25 34 34 0 All include prophylaxis all        
26 35 35 0 All include prophylaxis all        
27 36 36 0 All include prophylaxis all        
28 37 37 0 All include prophylaxis all        
29 38 38 0 All include prophylaxis all        
30 39 39 0 All areas <2,200 m (<7,200 ft) elevation include prophylaxis all   2200    
31 39 39 1 No malaria transmission in Asmara (the capital) exclude none area Asmara (the capital)      
32 40 40 0 All areas <2,500 m (<8,200 ft) elevation include prophylaxis all   2500    
33 41 41 0 All areas (including game parks) <2,500 m (<8,200 ft) elevation; rare cases in the highly urbanized central part of the city of Nairobi (the capital) include sporadic all   2500    
34 42 42 0 All; except in Antananarivo (the capital) where malaria transmission is rare include sporadic all        
35 43 43 0 All include prophylaxis all        
36 45 45 0 All. Although malaria was previously controlled, an increasing number of locally acquired cases are being reported. include prophylaxis all        
37 46 46 0 All include prophylaxis all        
38 48 48 0 All include prophylaxis all        
39 50 50 0 All include prophylaxis all        
40 51 51 0 All areas below 1,800 m (5,900 ft) elevation include prophylaxis all        
41 52 52 0 All include prophylaxis all        
42 53 53 0 Districts/subdistricts of Bobirwa, Boteti, Chobe (including Chobe National Park), Ghanzi, Mahalapye, Ngamiland (Ngami), North-East (including its capital, Francistown), Okavango, Serowe/Palapye, and Tutume include prophylaxis area        
43 53 53 1 Rare cases or sporadic foci of transmission in districts/subdistricts of Kgalagadi North, Kgatleng, Kweneng, and Southern include sporadic area        
44 53 53 2 No malaria transmission in Gaborone (the capital) exclude none area Gaborone (the capital)      
45 55 55 0 In the regions of Kavango (East and West), Kunene, Ohangwena, Omaheke, Omusati, Oshana, Oshikoto, Otjozondjupa, and Zambezi include prophylaxis area        
46 55 55 1 Rare in other parts of the country include sporadic area        
47 55 55 2 No malaria transmission in Windhoek (the capital) exclude none area Windhoek (the capital)      
48 56 56 0 Along the border with Mozambique and Zimbabwe include prophylaxis area        
49 56 56 1 KwaZulu-Natal Province: uMkhanyakude District; the districts of King Cetshwayo and Zululand (few cases) include prophylaxis area        
50 56 56 2 Limpopo Province: the districts of Mopani and Vhembe; the districts of Capricorn, Greater Sekhukhune, and Waterberg (few cases) include prophylaxis area        
51 56 56 3 Mpumalanga Province: Ehlanzeni District include prophylaxis area        
52 56 56 4 Kruger National Park include prophylaxis area        
53 57 57 0 Eastern areas bordering Mozambique and South Africa, including the entire region of Lubombo and the eastern half of Hhohho, Manzini, and Shiselweni Regions include prophylaxis area        
54 58 58 0 All include prophylaxis all        
55 68 68 0 Primarily in the provinces (including resort areas) of Azua, Elias Piña, La Altagracia, San Juan, and Santo Domingo include prophylaxis area        
56 68 68 1 In the Distrito Nacional, city of Santo Domingo (the capital), primarily in the La Ciénaga and Los Tres Brazos areas include prophylaxis area        
57 68 68 2 Rare transmission in other provinces include sporadic area        
58 71 71 0 All (including Labadee, also known as Port Labadee) include prophylaxis all        
59 84 84 0 Present in the provinces of Alajuela and Limón include prophylaxis area        
60 84 84 1 Rare to no transmission in other parts of the country include sporadic area        
61 86 86 0 Primarily in the departments of Alta Verapaz, Baja Verapaz, Escuintla, Izabal, and Petén include prophylaxis area        
62 86 86 1 Few cases reported in other departments include prophylaxis area        
63 86 86 2 No malaria transmission in the cities of Antigua or Guatemala City (the capital) exclude none area the cities of Antigua or Guatemala City (the capital)      
64 86 86 3 No malaria transmission at Lake Atitlán exclude none area        
65 87 87 0 Throughout the country and on the island of Roat á n and other Bay Islands include prophylaxis all        
66 87 87 1 No malaria transmission in the cities of San Pedro Sula or Tegucigalpa (the capital) exclude none area the cities of San Pedro Sula or Tegucigalpa (the capital)      
67 88 88 0 Campeche, Chiapas, and the southern part of Chihuahua state include prophylaxis area        
68 88 88 1 Rare in the states of Oaxaca, Sinaloa, Sonora, and Tabasco include sporadic area        
69 88 88 2 No malaria transmission along the U.S.–Mexico border exclude none area        
70 89 89 0 Región Autónoma Atlántico Norte (RAAN) and Región Autónoma Atlántico Sur (RAAS) include prophylaxis area        
71 89 89 1 Rare cases in the departments of Boaco, Chinandega, Estelí, Jinotega, León, Matagalpa, Nueva Segovia, and other parts of the country include sporadic area        
72 89 89 2 No malaria transmission in Managua (the capital) exclude none area Managua (the capital)      
73 90 90 0 The provinces of Bocas del Toro, Chiriquí, Colón, Darién, Panamá, Panamá Oeste, and Veraguas include prophylaxis area        
74 90 90 1 The indigenous provinces ( comarcas indígena ) of Emberá, Kuna Yala (also spelled Guna Yala) and Ngäbe-Buglé include prophylaxis area        
75 90 90 2 Rare cases in other parts of the country include sporadic area        
76 90 90 3 No malaria transmission in the Canal Zone or in Panama City (the capital) exclude none area the Canal Zone or in Panama City (the capital)      
77 91 91 0 All areas <2,500 m (<8,200 ft) elevation include prophylaxis all   2500    
78 91 91 1 No malaria transmission in La Paz (administrative capital) exclude none area La Paz (administrative capital)      
79 92 92 0 All areas in the states of Acre, Amapá, Amazonas, Rondônia, and Roraima include prophylaxis area        
80 92 92 1 Present in the states of Maranhão, Mato Grosso, and Pará, but rare cases in their capital cities (São Luis [capital of Maranhão], Cuiabá [capital of Mato Grosso], Belém [capital of Pará]) include sporadic area        
81 92 92 2 Rare cases and sporadic foci of transmission in rural and forested areas in the states of Espírito Santo, Goiás, Minas Gerais, Mato Grosso do Sul, Piauí, Rio de Janeiro, São Paolo, and Tocantins include sporadic area        
82 92 92 3 No malaria transmission in the cities of Brasília (the capital), Rio de Janeiro, or São Paolo exclude none area the cities of Brasília (the capital), Rio de Janeiro, or São Paolo      
83 92 92 4 No malaria transmission at Iguaçu Falls exclude none area        
84 93 93 0 All areas <1,700 m (<5,600 ft) elevation include prophylaxis all   1700    
85 93 93 1 No malaria transmission in the cities of Bogotá (the capital), Cartagena, or Medellín exclude none area the cities of Bogotá (the capital), Cartagena, or Medellín      
86 94 94 0 Areas <1,500 m (<5,000 ft) elevation in the provinces of Cotopaxi, Esmeraldas, Morona-Santiago, Orellana, Pastaza, and Sucumbíos include prophylaxis area   1500    
87 94 94 1 Rare cases <1,500 m (<5,000 ft) in all other provinces include sporadic area   1500    
88 94 94 2 No malaria transmission in the cities of Guayaquil or Quito (the capital) exclude none area the cities of Guayaquil or Quito (the capital)      
89 94 94 3 No malaria transmission on the Galápagos Islands exclude none area        
90 95 95 0 Areas associated with gold mining, primarily the communes near the border with Brazil and Suriname, especially Régina and Saint-Georges-de-l’Oyapock; also, the communes of Kourou, Matoury, and Saint-Élie include prophylaxis area        
91 95 95 1 No malaria transmission in coastal areas west of Kourou exclude none area coastal areas west of Kourou      
92 95 95 2 No malaria transmission in Cayenne City (the capital) exclude none area Cayenne City (the capital)      
93 96 96 0 All include prophylaxis all        
94 96 96 1 Rare cases in the cities of Georgetown (the capital) and New Amsterdam include sporadic area        
95 98 98 0 All areas of the country <2,500 m (<8,200 ft) elevation east of the Andes, including the cities of Iquitos and Puerto Maldonado include prophylaxis all   2500    
96 98 98 1 Rare cases in Tumbes and Piura regions include sporadic area        
97 98 98 2 No malaria transmission in the following areas: Lima Province; the cities of Arequipa, Ica, Moquegua, Nazca, Puno, or Tacna; the highland tourist areas (the city of Cusco, Machu Picchu, Lake Titicaca); along the central and southern Pacific Coast exclude none area the following areas: Lima Province; the cities of Arequipa, Ica, Moquegua, Nazca, Puno, or Tacna; the highland tourist areas (the city of Cusco, Machu Picchu, Lake Titicaca); along the central and southern Pacific Coast      
98 99 99 0 No indigenous cases since 2021 include prophylaxis area        
99 99 99 1 Previously, primarily in Sipaliwini District, near the border with French Guiana, with limited transmission in Brokopondo, Marowijne, and Para (near the border with French Guiana) include prophylaxis area        
100 100 100 0 All areas <1,700 m (<5,600 ft) elevation and Angel Falls include prophylaxis all   1700    

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE area_statement (
  area_statement_id INTEGER PRIMARY KEY,
  record_id     INTEGER NOT NULL REFERENCES malaria_record(record_id) ON DELETE CASCADE,
  seq           INTEGER NOT NULL,
  raw_text      TEXT NOT NULL,                -- verbatim li text (entities decoded, tags stripped)
  polarity      TEXT NOT NULL,               -- 'include' | 'exclude'
  tier          TEXT NOT NULL,               -- 'prophylaxis' | 'sporadic' | 'none'
  scope         TEXT,                         -- 'all' | 'region' | 'city' | 'district' | 'other'
  place_name    TEXT,
  elev_max_m    INTEGER,
  elev_min_m    INTEGER,
  season_text   TEXT,
  UNIQUE (record_id, seq)
);
CREATE INDEX ix_area_record ON area_statement(record_id);