IFs.db: Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
m (Add sections)
 
Line 1: Line 1:
Note that this table in IFs.db cannot handle Null values. Instead, replace Nulls with 0s.
== Agriculture ==
== Agriculture ==


== IHME ==
=== 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 <<nowiki>http://www.fao.org/faostat/en/#data/FBSH</nowiki>> and preliminary data series are available here <<nowiki>http://www.fao.org/faostat/en/#data/FBS</nowiki>>.
 
==== AgGlobalFeedtoDomSuppRatios ====
The most recent update date was April, 2024.
 
Regions: World + (Total)
 
Elements: Feed (5521), Domestic supply quantity (5301)
 
Years: 1960 - 2023
 
Items:
{| class="wikitable"
|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 ====
The most recent update date was Feburary, 2024.
 
Original Source: [https://vizhub.healthdata.org/gbd-results/ 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'')
{| class="wikitable"
|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
{| class="wikitable"
|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. ([https://view.officeapps.live.com/op/view.aspx?src=https%3A%2F%2Fwww.healthdata.org%2Fsites%2Fdefault%2Ffiles%2Ffiles%2FProjects%2FGBD%2FIHME_GBD_2019_A3_MEASURE_METRIC_DEFINITIONS_Y2020M10D15.XLSX&wdOrigin=BROWSELINK IHME_GBD_2019_A3_MEASURE_METRIC_DEFINITIONS_Y2020M10D15.XLSX (live.com)] from [https://www.healthdata.org/research-analysis/about-gbd/gbd-data-and-tools-guide 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.

Latest revision as of 20:18, 24 April 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

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.