IFs.db: Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
No edit summary
 
(One intermediate revision by the same user not shown)
Line 65: Line 65:


==== HealthDetailedDeathsCtry ====
==== 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.
The most recent update date was Feburary, 2024.


Line 75: Line 77:
Metric: Rate
Metric: Rate


Cause: Select all level 2 causes (''note: “Sense organ disease” is not available for Deaths Rate'')
Cause: Select all level 2 causes as well as some detailed causes listed below.
 
{| class="wikitable"
{| class="wikitable"
|CauseID
|IHME_Cause_ID_Sequence
|Cause
|IHME_Cause_Name
|cause_name
|IFs_Group
|category
|IFs_Name
|IFs_Cause_ID
|-
|-
|1
|294_295_957_302
|Other CD
|Diarrheal diseases
|Other infectious  diseases
|Communicable, maternal, neonatal, and nutritional diseases
|Communicable, maternal, neonatal, and nutritional diseases
|Diarrhea
|12
|-
|-
|1
|294_295_955_298
|Other CD
|HIV/AIDS
|Maternal and neonatal  disorders
|Communicable, maternal, neonatal, and nutritional diseases
|Communicable, maternal, neonatal, and nutritional diseases
|HIV
|11
|-
|-
|1
|294_295_344_345
|Other CD
|Malaria
|Nutritional  deficiencies
|Communicable, maternal, neonatal, and nutritional diseases
|Communicable, maternal, neonatal, and nutritional diseases
|Malaria
|13
|-
|-
|2
|294_295_956_322
|Malignant Neoplasms
|Lower respiratory infections
|Neoplasms
|Communicable, maternal, neonatal, and nutritional diseases
|Communicable, maternal, neonatal, and nutritional diseases
|Respiratory Infection
|14
|-
|-
|3
|294_295_956_328
|Cardiac
|Upper respiratory infections
|Cardiovascular  diseases
|Communicable, maternal, neonatal, and nutritional diseases
|Communicable, maternal, neonatal, and nutritional diseases
|Respiratory Infection
|14
|-
|-
|4
|294_295_956_329
|Digestive
|Otitis media
|Digestive diseases
|Communicable, maternal, neonatal, and nutritional diseases
|Communicable, maternal, neonatal, and nutritional diseases
|Respiratory Infection
|14
|-
|-
|5
|294_295
|Respiratory
|Residual of Communicable, maternal, neonatal, and nutritional diseases
|Chronic respiratory  diseases
|Communicable, maternal, neonatal, and nutritional diseases
|Communicable, maternal, neonatal, and nutritional diseases
|Other CD
|1
|-
|-
|6
|294_409_491
|Other NCD
|Cardiovascular diseases
|Neurological  disorders
|Non-communicable
|Non-communicable
|Cardiac
|3
|-
|-
|6
|294_409_974_587
|Other NCD
|Diabetes mellitus
|Substance use  disorders
|Non-communicable
|Non-communicable
|Diabetes
|10
|-
|-
|6
|294_409_526
|Other NCD
|Digestive diseases
|Skin and subcutaneous  diseases
|Non-communicable
|Non-communicable
|Digestive
|4
|-
|-
|6
|294_409_410
|Other NCD
|Neoplasms
|Sense organ diseases
|Non-communicable
|Non-communicable
|Malignant Neoplasms
|2
|-
|-
|6
|294_409_542
|Other NCD
|Neurological disorders
|Musculoskeletal  disorders
|Non-communicable
|Non-communicable
|Mental Health
|15
|-
|-
|6
|294_409_558
|Other NCD
|Mental disorders
|Other  non-communicable diseases
|Non-communicable
|Non-communicable
|Mental Health
|15
|-
|-
|7
|294_409_973
|Road Injuries
|Substance use disorders
|Transport injuries
|Non-communicable
|Non-communicable
|Mental Health
|15
|-
|-
|8
|294_409_508
|Other Unintentional  Injuries
|Chronic respiratory diseases
|Unintentional  injuries
|Non-communicable
|Non-communicable
|Respiratory
|5
|-
|-
|9
|294_409
|Intentional Injuries
|Residual of Non-communicable diseases
|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
|Non-communicable
|Other NCD
|6
|-
|-
|13
|294_687_717
|Malaria
|Self-harm and interpersonal violence
|Neglected tropical  diseases and malaria
|Injuries
|Injuries
|Intentional Injuries
|9
|-
|-
|14
|294_687_688
|Respiratory Infection
|Transport injuries
|Respiratory  infections and tuberculosis
|Injuries
|Injuries
|Road Injuries
|7
|-
|-
|15
|294_687_696
|Mental Health
|Unintentional injuries
|Mental disorders
|Injuries
|Injuries
|Other Unintentional Injuries
|8
|}Location: Select all countries and territories
|}Location: Select all countries and territories


Line 200: Line 208:
|-
|-
|5
|5
|1 to 4
| 1 to 4
|p2
|p2
|-
|-
|6
|6
|5 to 9
| 5 to 9
|p3
|p3
|-
|-

Latest revision as of 17:52, 30 July 2024

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 as well as some detailed causes listed below.

IHME_Cause_ID_Sequence IHME_Cause_Name IFs_Group IFs_Name IFs_Cause_ID
294_295_957_302 Diarrheal diseases Communicable, maternal, neonatal, and nutritional diseases Diarrhea 12
294_295_955_298 HIV/AIDS Communicable, maternal, neonatal, and nutritional diseases HIV 11
294_295_344_345 Malaria Communicable, maternal, neonatal, and nutritional diseases Malaria 13
294_295_956_322 Lower respiratory infections Communicable, maternal, neonatal, and nutritional diseases Respiratory Infection 14
294_295_956_328 Upper respiratory infections Communicable, maternal, neonatal, and nutritional diseases Respiratory Infection 14
294_295_956_329 Otitis media Communicable, maternal, neonatal, and nutritional diseases Respiratory Infection 14
294_295 Residual of Communicable, maternal, neonatal, and nutritional diseases Communicable, maternal, neonatal, and nutritional diseases Other CD 1
294_409_491 Cardiovascular diseases Non-communicable Cardiac 3
294_409_974_587 Diabetes mellitus Non-communicable Diabetes 10
294_409_526 Digestive diseases Non-communicable Digestive 4
294_409_410 Neoplasms Non-communicable Malignant Neoplasms 2
294_409_542 Neurological disorders Non-communicable Mental Health 15
294_409_558 Mental disorders Non-communicable Mental Health 15
294_409_973 Substance use disorders Non-communicable Mental Health 15
294_409_508 Chronic respiratory diseases Non-communicable Respiratory 5
294_409 Residual of Non-communicable diseases Non-communicable Other NCD 6
294_687_717 Self-harm and interpersonal violence Injuries Intentional Injuries 9
294_687_688 Transport injuries Injuries Road Injuries 7
294_687_696 Unintentional injuries Injuries Other Unintentional Injuries 8

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.