IFs.db

Note that this table in IFs.db cannot handle Null values. Instead, replace Nulls with 0s.

Agriculture

FAO FBS

The FAOSTAT FBS series are blended from two datasets: The historical data goes from 1961 to 2009 while the preliminary data goes from 2010 to 2021. Both datasets are from the FAOSTAT website.

• The data can be accessed on the FAOSTAT website. Historical data series are available here <http://www.fao.org/faostat/en/#data/FBSH> and preliminary data series are available here <http://www.fao.org/faostat/en/#data/FBS>.

AgGlobalFeedtoDomSuppRatios

The most recent update date was April, 2024.

Regions: World + (Total)

Elements: Feed (5521), Domestic supply quantity (5301)

Years: 1960 - 2023

Items:

FishCategory	Item Code
AqAnimals	2769
AqPlants	2775
Body Oil	2781
Cephalopods	2766
Crustaceans	2765
Demersal	2762
Freshwater	2761
Liver Oil	2782
Marine	2764
Meal
Molluscs	2767
Pelagic	2763

Note: "Meal" was no longer existing.

Health

IHME

HealthDetailedDeathsCtry

Note that this table in IFs.db cannot handle Null values. Instead, replace Nulls with 0s.

The most recent update date was Feburary, 2024.

Original Source: VizHub - GBD Results (healthdata.org)

GBD Estimate: Cause of death or injury

Measure: Deaths

Metric: Rate

Cause: Select all level 2 causes (note: “Sense organ disease” is not available for Deaths Rate)

CauseID	Cause	cause_name	category
1	Other CD	Other infectious diseases	Communicable, maternal, neonatal, and nutritional diseases
1	Other CD	Maternal and neonatal disorders	Communicable, maternal, neonatal, and nutritional diseases
1	Other CD	Nutritional deficiencies	Communicable, maternal, neonatal, and nutritional diseases
2	Malignant Neoplasms	Neoplasms	Communicable, maternal, neonatal, and nutritional diseases
3	Cardiac	Cardiovascular diseases	Communicable, maternal, neonatal, and nutritional diseases
4	Digestive	Digestive diseases	Communicable, maternal, neonatal, and nutritional diseases
5	Respiratory	Chronic respiratory diseases	Communicable, maternal, neonatal, and nutritional diseases
6	Other NCD	Neurological disorders	Non-communicable
6	Other NCD	Substance use disorders	Non-communicable
6	Other NCD	Skin and subcutaneous diseases	Non-communicable
6	Other NCD	Sense organ diseases	Non-communicable
6	Other NCD	Musculoskeletal disorders	Non-communicable
6	Other NCD	Other non-communicable diseases	Non-communicable
7	Road Injuries	Transport injuries	Non-communicable
8	Other Unintentional Injuries	Unintentional injuries	Non-communicable
9	Intentional Injuries	Self-harm and interpersonal violence	Non-communicable
10	Diabetes	Diabetes and kidney diseases	Non-communicable
11	HIV	HIV/AIDS and sexually transmitted infections	Non-communicable
12	Diarrhea	Enteric infections	Non-communicable
13	Malaria	Neglected tropical diseases and malaria	Injuries
14	Respiratory Infection	Respiratory infections and tuberculosis	Injuries
15	Mental Health	Mental disorders	Injuries

Location: Select all countries and territories

Age: Select the values in Age_Name

IHME_Age_ID	Age_Name	Age_IFs
5	1 to 4	p2
6	5 to 9	p3
7	10 to 14	p4
8	15 to 19	p5
9	20 to 24	p6
10	25 to 29	p7
11	30 to 34	p8
12	35 to 39	p9
13	40 to 44	p10
14	45 to 49	p11
15	50 to 54	p12
16	55 to 59	p13
17	60 to 64	p14
18	65 to 69	p15
19	70 to 74	p16
20	75 to 79	p17
28	<1 year	p1
30	80 to 84	p18
31	85 to 89	p19
32	90 to 94	p20
235	95 +	p21

Sex: Male(1), Female(2)

Year: 2019 (Use the most recent available year.)

The Source Unit is Deaths per 100,000. (IHME_GBD_2019_A3_MEASURE_METRIC_DEFINITIONS_Y2020M10D15.XLSX (live.com) from Global Burden of Disease (GBD) data and tools guide | Institute for Health Metrics and Evaluation (healthdata.org))

Need to use Formula /100 to transform the Unit to Deaths per 1,000.