indicators.json

[
  {
    "target_id": "1.1",
    "has_metadata": true,
    "goal": 1,
    "goal_meta_link": "http://unstats.un.org/sdgs/files/metadata-compilation/Metadata-Goal-1.pdf",
    "goal_meta_link_page": 2,
    "target": "By 2030, eradicate extreme poverty for all people everywhere, currently measured as people living on less than $1.25 a day.",
    "indicator_id": "1.1.1",
    "indicator": "Proportion of population below the international poverty line, by sex, age, employment status and geographical location (urban/rural)",
    "responsible_entities": [
      "ILO",
      "World Bank"
    ],
    "definition": "This indicator provides the proportion of the total population and the proportion of the employed population living in households with per-capita consumption or income that is below the international poverty line of US$1.25. ",
    "method": "Calculated by dividing the number of persons living in households below the poverty line (disaggregated by sex, age and employment status) by the total number of persons (disaggregated by the same sex, age and employment status groups).",
    "rationale_interpretation": "This indicator combines the poverty indicator under the first target (1a) of the MDGs on the eradication of poverty with the corresponding working indicator for monitoring the second target (1b) of the MDGs on decent work. By combining poverty status with employment status, the concept of the working poor is captured, which aims to measure how many workers, despite being in employment, live in poverty.",
    "domain": "",
    "subdomain": "",
    "target_linkage": "",
    "exists_reported": "",
    "reliability_coverage_comparability_subnational_compute": "",
    "baseline_value_2015": "",
    "sources_data_collection": "Household surveys (LFS, HIES, LSMS, Integrated HH surveys, etc.).",
    "quantifiable_derivatives": "",
    "frequency": "",
    "disaggregation": "Data are available by sex and age.",
    "global_regional_monitoring_data": "The ILO has estimates of the employed population (number and proportion) living below the US$1.25 poverty line, disaggregated by age (youth and adult) and sex for the world as a whole and by (flexible) regional groupings. The global and regional estimates are based on estimates for 141 countries (with both reported and imputed values).",
    "comments_limitations": "At the country level, comparisons over time may be affected by such factors as changes in survey types or data collection methods. The use of PPPs rather than market exchange rates ensures that differences in price levels across countries are taken into account. However, it cannot be categorically asserted that two people in two different countries, living below US$1.25 a day at PPP, face the same degree of deprivation or have the same degree of need. This poverty line is not appropriate for highincome economies and may not be appropriate for upper-middle income countries.",
    "gender_equality_issues": "As this indicator is disaggregated by sex, it is well-suited for analysis of gender equality issues.",
    "current_data_availability": "The ILO has estimates available by employment status for 119 countries.",
    "supplementary_information": "Decent Work Indicators: ILO Manual - Second Version, available at: www.ilo.org/wcmsp5/groups/public/---dgreports/---stat/documents/publication/wcms_223121.pdf Key Indicators of the Labour Market, 8th Edition, available at: http://www.ilo.org/empelm/what/WCMS_114240/lang--en/index.htm \\nFrom World Bank:\\nUpdate to the 'International Poverty Line' (defined earlier as 'Proportion of population below $1.25 (PPP) per day per capita') As differences in the cost of living across the world evolve, the global poverty line has to be periodically updated to reflect these changes. Since 2008, the last update, the World Bank used $1.25 as the global line using 2005 prices. The 2014 release of a new set of purchasing power parity conversion factors (PPPs) for 2011 has prompted a revision of the international poverty line. In order to preserve the integrity of the goalposts for international targets such as the Sustainable Development Goals (and the World Bank's twin goals), the new poverty line was chosen so as to preserve the real purchasing power of the earlier $1.25 line (in 2005 PPPs) in poor countries. Using the new 2011 PPPs, the new line equals $1.90 per person per day. The higher value of the line in US dollars reflects the fact that the new PPPs yield a relatively lower purchasing power of that currency vis-�-vis those of most poor countries. Because the line was designed to preserve real purchasing power in poor countries, the revisions lead to relatively small changes in global poverty incidence: from 14.5 percent in the old method to 14.2 percent in the new method for 2011. There are changes in the regional composition of poverty, but they are also relatively small.\\n After a new round of internationally comparable prices were collected in 2005, the international poverty line was set based on 15 national poverty lines from some of the poorest countries in the world. These national poverty lines were converted to a common currency by using purchasing power parity (PPP) exchange rates, which are constructed to ensure that the same quantity of goods and services are priced equivalently across countries. The average of these 15 lines was $1.25 per person per day (in 2005 PPP terms), and this became the new international poverty line.\\n In 2015, the poverty lines of those same 15 poorest countries from 2005 were used to determine the new global poverty line. The new global poverty line uses updated price data to paint a more accurate picture of the costs of basic food, clothing, and shelter needs around the world. As of October 2015, the new global line is set at $1.90 using 2011 prices. The estimates have been back-casted for previous years, in order to assess the trends in poverty reduction over the last 25 years.\\n Note that the PPP is computed on the basis of price data from across the world, and the responsibility for determining a particular year's PPP rests with the International Comparison Program (ICP), an independent statistical program with a Global Office housed within the World Bank's Development Data Group. For the 2011 PPPs, prices were collected across 199 countries of the world.\\n For detailed information on this new line please consult:\\n http://documents.worldbank.org/curated/en/2015/10/25114899/global-count-extreme-poor- 2012-data-issues-methodology-initial-results \\n For a short review see:\\n http://www.worldbank.org/en/topic/poverty/brief/global-poverty-line-faq \\n From ESCAP:\\n ESCAP proposes to monitor this indicator for persons with disabilities. The Asia-Pacific regional framework to implement the Convention on the Rights of Persons with Disabilities during the Asian and Pacific Decade of Persons with Disabilities, 2013-2022, the Incheon Strategy to �Make the Right Real� for Persons with Disabilities in Asia and the Pacific, contains 10 disability inclusive development goals, 27 targets and 62 indicators to track progress in achieving goals and targets. Indicator 1.1 of the Strategy is �Proportion of persons with disabilities living below the US$ 1.25 (PPP) per day international poverty line�. All ESCAP member States are requested to establish a baseline data on the Incheon Strategy indicators including 1.1, by 2017, and some have already started reviewing their existing statistical instruments (e.g. household income and expenditure survey) to generate this indicator. The Washing Group short set of disabilities questions is recommended to be included as a module in the survey. Monitoring this indicator by age group would be practically impossible given that the main source is household income or consumption survey. It would be more practical to monitor the indicator by urban/rural area, and by social or ethnic characteristics (e.g. disability status, as is the case of Incheon Strategy indicator 1.1). Same for Indicator 1.2.2.\\n The Incheon Strategy and the ESCAP Guide on its indicators are accessible online at: http://www.maketherightreal.net/incheon-strategy/",
    "references": ""
  }
]

nodejs-file.js

var data = 'indicators.json'; //load data 

var fields = 'indicator_id,indicator,target_id,[target],goal,goal_meta_link,goal_meta_link_page,has_metadata';
var opts = {
  base_fields : fields,
  data : data,
  target_id : '1.1'
};

var result = alasql('SELECT $base_fields FROM $data WHERE target_id=$target_id', opts);
console.log(result);