day 3 session 5 accessing social protection data and information - adb spi website

7/28/2019 Day 3 Session 5 Accessing Social Protection Data and Information - ADB SPI Website

1/38

Accessing Social Protection Data

and Information

Presentation by

Dalisay S. Maligalig

16 May 2013

BPS-Statistics Indonesia, Jakarta, Indonesia

Capacity Development Workshop

on Measuring Social Protection

Disclaimer: The views expressed in this paper/presentation are the views of the author and

do not necessarily reflect the views or policies of the Asian Development Bank (ADB), or its

Board of Governors, or the governments they represent. ADB does not guarantee the accuracy

of the data included in this paper and accepts no responsibility for any consequence of their

use. Terminology used may not necessarily be consistent with ADB official terms.


2/38

SPI Website ContentMain Category Sub-category

Home About SPIOnline

Database

Expenditures and number of

beneficiaries of SP programs, SPI indices

and components, other relevant

indicators (poverty, employment, GDP,etc.)

Graphs Graphs2Go (Ready-made graphs)

Visualization (user-defined graphs)

References The Revised SPI Handbook

Concepts and Definitions

Process Flow Diagram

Country Reports

Help Quick Users Guide


3/38

SPI Website

Homepage


4/38

SPI Website

Online Data Query

Select Country:Philippines

Select Main topic:

Social Protection Index

Select Year: 2005,

2008-2010

Select Subjects: All


5/38

SPI Website

Online Data Query Results

Download data in

csv format


6/38

SPI Website

Data in csv formatCO-160 Philippines

Source 2005 2008 2009 2010SOCIAL PROTECTION INDEX

SU-2542 Social Protection Index, Overall Asian Dev 0.06456 0.07164 0.08479 0.07293

SU-2543 Social Protection Index for Social Insurance Asian Dev 0.061 0.06027 0.06817 0.06217

SU-2689 Social Protection Index for Social Insurance, Poor Asian Dev ... 0.00514 0.00742 0.00669

SU-2692 Social Protection Index for Social Insurance, Non-poor Asian Dev ... 0.05513 0.06075 0.05548

SU-2695 Social Protection Index for Social Insurance, Female Asian Dev ... 0.02964 0.03357 0.03062

SU-2698 Social Protection Index for Social Insurance, Male Asian Dev ... 0.03063 0.0346 0.03155

SU-2544 Social Protection Index for Social Assistance Asian Dev 0.004 0.00888 0.01139 0.00962

SU-2545 Social Protection Index for Labor Market Programs Asian Dev 0 0.00248 0.00523 0.00114

SU-2546 Social Protection Index, Depth Asian Dev 0.161 0.18251 0.36767 0.46734

SU-2547 Social Protection Index, Breadth Asian Dev 0.40127 0.39251 0.23061 0.15605

SU-2690 Social Protection Index for Social Assistance, Poor Asian Dev ... 0.0066 0.00855 0.00814

SU-2548 Social Protection Index, Poor Asian Dev 0.00303 0.01318 0.0185 0.01567

SU-2549 Social Protection Index, Non-Poor Asian Dev 0.06155 0.05846 0.06629 0.05726

Social Protection Index: example

Social Protection Index, Overall

Social Protection Index for Social Insurance

Social Protection Index for Social Assistance

Social Protection Index for Labor Market Programs


7/38

SPI Website

Online Data Query

Select Country:

Philippines

Select other topic:

Social Assistance

Select Year: 2002-

2010



8/38

SPI Website


Download data in

csv format


9/38

CO-160 Philippines Source 2005 2008 2009 2010SOCIAL ASSISTANCE

SU-2292 Expenditures on Disaster Relief and Assistance, Public Department Of Agriculture ... 215640 431280 ...

SU-2292 Expenditures on Disaster Relief and Assistance, Public Department Of Social Welfare An ... 625200 553420 187105

SU-2292 Expenditures on Disaster Relief and Assistance, Public National Disaster Risk Reduction 15188 ... ... ...

SU-2292 Expenditures on Disaster Relief and Assistance, Public Philippine Charity Sweepstakes O 15639 ... ... ...

SU-2292 Expenditures on Disaster Relief and Assistance, Public Social Security System ... 50000 100000 ...

SU-2295 Expenditures on Disaster Relief and Assistance for the Poor, Publ ic ADB Staff Estimate 22625.48 222710 271175 46776.25SU-2298 Expenditures on Educational Assistance for Children, Public Commission On Higher Education ... 507045 506280 385766

SU-2298 Expenditures on Educational Assistance for Children, Public Department Of Education 39430 8532019 8789027 9046754

SU-2298 Expenditures on Educational Assistance for Children, Public Department Of Science And Tech ... 321000 321000 321000

SU-2298 Expenditures on Educational Assistance for Children, Public Philippine Veterans Affairs Office... 53748 57997 62714

SU-2301 Expenditures on Educational Assistance for Poor Chi ldren, Publ ic ADB Staff Estimate 29572.5 8228845 8460526 8585197

SU-2301 Expenditures on Educational Assistance for Poor Children, Public Philippine Veterans Affairs Office ... 13437 14499.25 15678.5

SPI Website

Data in csv format

Social Assistance: examples

Expenditures on Disaster Relief and Assistance

Expenditures on Disaster Relief and Assistance for the Poor

Number of Beneficiaries Covered by Disaster Relief and Assistance

Number of Poor Beneficiaries Covered by Disaster Relief and Assistance


10/38

SPI Website

Online Data Query


Select other topic:

Social Insurance

Select Year: 2002-

2010


SPI W b it


11/38

SPI Website


Download data in

csv format


12/38

SPI Website

Data in csv format

CO-160 Philippines

Source 2005 2008 2009 2010

SOCIAL INSURANCE

SU-2412 Expenditures on Disability Insurance, Public Government Service Insurance System 46200 ... ... ...

SU-2412 Expenditures on Disability Insurance , Public Social Security System 2963793 3160757 3133799 3242661

SU-2415 Expenditures on Disabi li ty Insurance for the Poor, Publ ic ADB Staf f Estimate - 63215.14 62675.98 64853.22

SU-2418 Expenditures on Health Insurance, Publ ic Government Service Insurance System 14800 3627 88762 113861

SU-2418 Expenditures on Health Insurance, Public Philippine Health Insurance Corporatio 14800000 25967300 36872700 42250700

SU-2418 Expenditures on Health Insurance, Public Philippine Veterans Affairs Office ... 255316 253491 265448

SU-2418 Expenditures on Health Insurance, Public Social Security System 27.38 255316 253491 265448

SU-2421 Expenditures on Heal th Insurance for the Poor, Publ ic ADB Staf f Estimate ... 9449483 14398062 15334395

SU-2424 Expenditures on Maternity Insurance, Public Social Security System ... 29384726 31107071 32942891

SU-2427 Expenditures on Materni ty Insurance for the Poor, Publ ic ADB Staf f Estimate ... 9431575 14379430 15314675

Social Insurance: examplesExpenditures on Disability Insurance

Expenditures on Disability Insurance for the Poor

Number of Beneficiaries Covered by Disability Insurance

Number of Poor Beneficiaries Covered by Disability Insurance


13/38

SPI Website

Online Data Query


Select other topic:

Labor Market Program

Select Year: 2002-

2010



14/38

SPI Website


Download data in

csv format


15/38

SPI Website

Data in csv formatCO-160 Philippines

Source 2005 2008 2009 2010

LABOR MARKET PROGRAM

SU-2508 Expenditures on Employment Generation, Public Department Of Environment And Natural ... 276843 3343480 103402

SU-2508 Expenditures on Employment Generation, Public Department Of Labor And Employment 133687 ... ... ...

SU-2508 Expenditures on Employment Generation, Public Department Of Social Welfare And Devel 126824 ... ... ...

SU-2508 Expenditures on Employment Generation, Public Department Of Trade And Industry ... 2693020 1734480 1374220

SU-2511 Expendi tures on Empl oyment Generati on for the Poor, Publ ic ADB Staff Esti mate 71604.27 1164031 3281852 563698.6

SU-2514 Expenditures on Employment Services, Public Department Of Labor And Employment 8000 ... . .. . ..

SU-2517 Expenditures on Employment Services for the Poor, Public ADB Staff Estimate 2080 ... ... ...

SU-2520 Expenditures on Skills Development Programs, Public Technical Education And Skills Developm ... 1447681 5752756 809426.2

SU-2523 Expenditures on Skills Development Programs for the Poor, Pu ADB Staff Estimate ... 253444 810005.1 178541

SU-2526 Number of Beneficiaries Covered by Employment Generation, Department Of Environment And Natural ... 3.57 18.416 9.717

SU-2526 Number of Beneficiaries Covered by Employment Generation, Department Of Labor And Employment 9.014 ... . .. . ..

SU-2526 Number of Beneficiaries Covered by Employment Generation, Department Of Social Welfare And Devel 111.95 ... ... ...

SU-2526 Number of Beneficiaries Covered by Employment Generation, Department Of Trade And Industry .. . 85.419 84.268 63.493

SU-2529 Number of Poor Beneficiaries Covered by Employment Generat ADB Staff Estimate 58.258 32.75265 44.2266 29.99615

Labor Market Program: examples

Expenditures on Employment Generation

Expenditures on Employment Generation for the Poor

Number of Beneficiaries Covered by Employment Generation

Number of Poor Beneficiaries Covered by Employment Generation


16/38

SPI Website

Graphs

2 Graphing Tools

1. Graphs2Go

2. Visualization


17/38

SPI Website

Graphs2Go: Select Indicator and Year

Select 1 Indicator: SPI by Insurance,

Assistance, and Labor Market

Select 1 Year: 2010 Select: Generate graph


18/38

SPI Website

Graphs2Go: SPI by Insurance, Assistance and Labor Market

Graph generated:

1 indicator

1 year

Pre-defined multiple countries


19/38

SPI Website

Graphs2Go: Select Other Indicator

Select other indicator:

SPI by Depth and Breadth


20/38

Graph generated:

1 indicator

1 year


SPI Website

Graphs2Go: SPI by Depth and Breadth


21/38

SPI Website



SPI by Poor and Nonpoor


22/38

SPI Website

Graphs2Go: SPI by Poor and Nonpoor

Graph generated:

1 indicator

1 year


b


23/38

SPI Website



SPI by Male and Female


24/38

SPI Website

Graphs2Go: SPI by Male and Female

Graph generated:

1 indicator

1 year



25/38

SPI Website

Graphs2Go: Switch to Generate Table

Switch to: Generate Table


26/38

SPI Website

Graphs2Go Table: SPI by Male and Female


27/38

SPI Website

Graphs Visualization

Select Indicators:

Social Protection Index, Overall;

Social Protection Index, Poor;

Social Protection Index, Nonpoor

Select: Generate graph

Select Countries:

Indonesia, Philippines,

and Sri Lanka


28/38

SPI WebsiteGraph: Social Protection Index, Overall

Graph generated:

1 indicator

Multiple countries

Pre-defined years


29/38

SPI WebsiteGraphs Visualization

Switch indicator:

Social Protection Index, Poor


30/38

SPI WebsiteGraph: Social Protection Index, Poor

Graph generated:

1 indicator

Multiple countries

Pre-defined years


31/38

SPI WebsiteGraphs Visualization

Add Countries:

Malaysia, Singapore, and Thailand


32/38

SPI WebsiteGraph: Social Protection Index, Poor

Graph generated:

1 indicator

Multiple countries

Pre-defined years

SPI W b it


33/38

SPI Website

References

SPI Website


34/38

SPI Website

References

SPI Website


35/38

SPI Website

References

SPI Website


36/38

SPI Website

References

SPI Website


37/38

SPI Website

Help


38/38

For More Information

Sri Wening Handayani

[email protected]

Dalisay S. Maligalig

d li li @ db

Thank you
mailto:[email protected]:[email protected]:[email protected]:[email protected]

day 3 session 5 accessing social protection data and information - adb spi website

Documents